Changed sessions.expiration column to timestamp

 -- Updated SQL files to reflect column type change.
 -- Subroutine dbSessionAdd rewritten to accept an expiration
    timestap as an optional third argument.

1 files changed, 3 insertions, 3 deletions

diff --git a/util/updates/update_2.6.sql b/util/updates/update_2.6.sql
index e631039e..25b7782e 100644
--- a/util/updates/update_2.6.sql
+++ b/util/updates/update_2.6.sql
@@ -2,13 +2,13 @@
 -- Create table for session data storage
 
 CREATE TABLE sessions (
-    uid integer NOT NULL REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED;
+    uid integer NOT NULL REFERENCES users(id);
     token character(40) NOT NULL,
-    expiration bigint DEFAULT 0 NOT NULL,
+    expiration timestamp without time zone DEFAULT (NOW() + '1 year'::interval) NOT NULL,
     PRIMARY KEY (uid, token)
 );
 
 -- Add column to users for salt storage
 
-ALTER TABLE users ADD COLUMN salt character(9) NOT NULL DEFAULT '';
+ALTER TABLE users ADD COLUMN salt character(9) NOT NULL DEFAULT ''::bpchar;