diff options
-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(); |