diff options
author | Yorhel <git@yorhel.nl> | 2009-07-30 09:47:51 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-07-30 09:47:51 +0200 |
commit | 54ff8e3219e22b24640b2d5273c2a635ee6976da (patch) | |
tree | ac788773a0a311453428d5bb56620ef7967decab /util | |
parent | 4e1a84ae9ee6dbc5ea18517a9112ae1821797eb7 (diff) |
Fixed syntax error in update_2.6.sql and removed leading spaces in dump.sql
That syntax error was partly 3dB's fault, and partly my fault for
changing too much in that merge, heh.
Diffstat (limited to 'util')
-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) ); |