summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-07-30 09:47:51 +0200
committerYorhel <git@yorhel.nl>2009-07-30 09:47:51 +0200
commit54ff8e3219e22b24640b2d5273c2a635ee6976da (patch)
treeac788773a0a311453428d5bb56620ef7967decab /util
parent4e1a84ae9ee6dbc5ea18517a9112ae1821797eb7 (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.sql4
-rw-r--r--util/updates/update_2.6.sql4
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)
);