diff options
author | Yorhel <git@yorhel.nl> | 2010-02-04 22:59:22 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2010-02-04 22:59:22 +0100 |
commit | 3cd6626fefaed0461d27377e2a349871c49e7154 (patch) | |
tree | 3deab8e26f780a3524810633bffa9d49d7992659 /util/updates | |
parent | 7255ee9b1febae2b845c5ade5af145fc234bc959 (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.sql | 1 |
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(); |