summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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();