X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=db%2F074to080.sql;h=e3631e214accb851050f2660c8ca7d641e14afc3;hb=c1a27922ba738f71b100a520e5db6f32985a307b;hp=ff08191596655ab8e1bef3c20d7be7380bf9f3f4;hpb=abd74673921cd119e05089d3cce2f0a37fdb49fe;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; +