diff options
-rw-r--r-- | util/dump.sql | 4 | ||||
-rw-r--r-- | util/updates/update_2.6.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/util/dump.sql b/util/dump.sql index f7f9bb9e..2bb4fda5 100644 --- a/util/dump.sql +++ b/util/dump.sql @@ -412,7 +412,7 @@ ALTER TABLE wlists ADD FOREIGN KEY (vid) REFERENCES vn -- F U N C T I O N S -- ------------------------- - + -- update_rev(table, ids) - updates the rev column in the changes table CREATE FUNCTION update_rev(tbl text, ids text) RETURNS void AS $$ DECLARE @@ -446,7 +446,7 @@ BEGIN IF id > 0 THEN w := ' WHERE id = '||id; END IF; - EXECUTE 'UPDATE vn SET + EXECUTE 'UPDATE vn SET c_released = COALESCE((SELECT MIN(rr1.released) FROM releases_rev rr1 diff --git a/util/updates/update_2.6.sql b/util/updates/update_2.6.sql index 67bbe584..79fefd69 100644 --- a/util/updates/update_2.6.sql +++ b/util/updates/update_2.6.sql @@ -2,9 +2,9 @@ -- Create table for session data storage CREATE TABLE sessions ( - uid integer NOT NULL REFERENCES users(id); + uid integer NOT NULL REFERENCES users(id), token character(40) NOT NULL, - expiration NOT NULL DEFAULT (NOW() + '1 year'::interval), + expiration timestamp NOT NULL DEFAULT (NOW() + '1 year'::interval), PRIMARY KEY (uid, token) ); |