summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEric Helgeson <erichelgeson@gmail.com>2009-07-28 20:17:20 -0500
committerEric Helgeson <erichelgeson@gmail.com>2009-07-28 20:17:20 -0500
commit72117294d7675434fc14303ad84711d43be003b9 (patch)
tree621a4bd3d36a61f9b7168fda7c1aac82e12a1683
parentc85b6155eb004fe556de255482c04b87046c90b3 (diff)
Splitting br3nda's merge 97db6e17b3f76e9a6acf87ddbad47ba54e9b1a3b
Add session table to pg.sql
-rw-r--r--db/laconica_pg.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql
index 24581bad0..ad34720a2 100644
--- a/db/laconica_pg.sql
+++ b/db/laconica_pg.sql
@@ -519,6 +519,16 @@ create table group_alias (
);
create index group_alias_group_id_idx on group_alias (group_id);
+create table session (
+
+ id varchar(32) primary key /* comment 'session ID'*/,
+ session_data text /* comment 'session data'*/,
+ created timestamp not null DEFAULT CURRENT_TIMESTAMP /* comment 'date this record was created'*/,
+ modified integer DEFAULT extract(epoch from CURRENT_TIMESTAMP) /* comment 'date this record was modified'*/
+);
+
+create index session_modified_idx on session (modified);
+
/* Textsearch stuff */