add an index for site tags

[quix0rs-gnu-social.git] / db / 074to080.sql

diff --git a/db/074to080.sql b/db/074to080.sql
index e667798eb2ee30ad664d2bda1d0009b79aa6f643..e3631e214accb851050f2660c8ca7d641e14afc3 100644 (file)
--- a/db/074to080.sql
+++ b/db/074to080.sql
@@ -17,7 +17,7 @@ alter table user_group
 
 create table file (
     id integer primary key auto_increment,
-    url varchar(2047) comment 'destination URL after following redirections',
+    url varchar(255) comment 'destination URL after following redirections',
     mimetype varchar(50) comment 'mime type of resource',
     size integer comment 'size of resource when available',
     title varchar(255) comment 'title of resource when available',
@@ -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;
+