summaryrefslogtreecommitdiff
path: root/util/updates
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-02-04 22:59:22 +0100
committerYorhel <git@yorhel.nl>2010-02-04 22:59:22 +0100
commit3cd6626fefaed0461d27377e2a349871c49e7154 (patch)
tree3deab8e26f780a3524810633bffa9d49d7992659 /util/updates
parent7255ee9b1febae2b845c5ade5af145fc234bc959 (diff)
SQL: Alter the default of sessions.added in the update script
Forgot to do this in the earlier commit.
Diffstat (limited to 'util/updates')
-rw-r--r--util/updates/update_2.11.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/util/updates/update_2.11.sql b/util/updates/update_2.11.sql
index d488e228..d05d18c0 100644
--- a/util/updates/update_2.11.sql
+++ b/util/updates/update_2.11.sql
@@ -100,6 +100,7 @@ DROP FUNCTION tmp_edit_hidlock(text, integer);
ALTER TABLE sessions ADD COLUMN lastused timestamptz NOT NULL DEFAULT NOW();
ALTER TABLE sessions RENAME COLUMN expiration TO added;
UPDATE sessions SET added = added - '1 year'::interval;
+ALTER TABLE sessions ALTER COLUMN added SET DEFAULT NOW();
CREATE TRIGGER notify_pm AFTER INSERT ON threads_posts FOR EACH ROW EXECUTE PROCEDURE notify_pm();