summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorEvan Prodromou <evan@status.net>2010-11-09 12:53:57 -0500
committerEvan Prodromou <evan@status.net>2010-11-09 15:09:00 -0500
commita4654bfe9f950fa3ca76d109f21030a03507c3da (patch)
treeff878d994232697b55dfa8b7cb9e18bd8db9d0b7 /db
parente90bf6c15ba83d995cbd2665185c3e4920a82a5a (diff)
session table was missing from upgrade scripts
Diffstat (limited to 'db')
-rw-r--r--db/074to080.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/db/074to080.sql b/db/074to080.sql
index ff0819159..e3631e214 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;
+