From 48d671ac39de0ebfd36858d784d3066ecbb89c10 Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Sat, 27 Jun 2009 05:15:59 -0700 Subject: session storage --- db/laconica.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'db') diff --git a/db/laconica.sql b/db/laconica.sql index 3f8918de6..2c04f680a 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -524,3 +524,14 @@ 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; \ No newline at end of file -- cgit v1.2.3-54-g00ecf