From 72117294d7675434fc14303ad84711d43be003b9 Mon Sep 17 00:00:00 2001
From: Eric Helgeson <erichelgeson@gmail.com>
Date: Tue, 28 Jul 2009 20:17:20 -0500
Subject: Splitting br3nda's merge 97db6e17b3f76e9a6acf87ddbad47ba54e9b1a3b Add
 session table to pg.sql

---
 db/laconica_pg.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'db/laconica_pg.sql')

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 */
 
-- 
cgit v1.2.3-54-g00ecf

