X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=db%2F074to080.sql;h=e3631e214accb851050f2660c8ca7d641e14afc3;hb=1fdc72f5956f00c736f7761aead4abd8da192eda;hp=ff08191596655ab8e1bef3c20d7be7380bf9f3f4;hpb=5067f2ba3a39100c9922ce073b2a2fe2d3ada0e5;p=quix0rs-gnu-social.git diff --git a/db/074to080.sql b/db/074to080.sql index ff08191596..e3631e214a 100644 --- a/db/074to080.sql +++ b/db/074to080.sql @@ -107,3 +107,15 @@ create table group_alias ( index group_alias_group_id_idx (group_id) ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; + +create table session ( + + id varchar(32) primary key comment 'session ID', + session_data text comment 'session data', + created datetime not null comment 'date this record was created', + modified timestamp comment 'date this record was modified', + + index session_modified_idx (modified) + +) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; +