diff options
author | Yorhel <git@yorhel.nl> | 2010-01-26 19:51:30 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2010-01-26 19:51:30 +0100 |
commit | f82550b1cef9e91780b43e61c60c61af1ba139fd (patch) | |
tree | aa4d580db4e6558abb3e4a80a73aff529a64dd72 /util/updates | |
parent | 38174567d7f68a2751426c0fadcda5eca1bd6861 (diff) |
SQL: Replaced sessions.expiration with sessions.added
An expiration date doesn't make much sense if it's both not used and if
it can't be configured by the user, so just make this a timestamp to
indicate when the session has been added, which, while still not really
used, is more valuable.
Diffstat (limited to 'util/updates')
-rw-r--r-- | util/updates/update_2.11.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/util/updates/update_2.11.sql b/util/updates/update_2.11.sql index 09efd7d6..c59b2815 100644 --- a/util/updates/update_2.11.sql +++ b/util/updates/update_2.11.sql @@ -84,4 +84,7 @@ DROP FUNCTION tmp_edit_hidlock(text, integer); -- keep track of when a session is last used 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; + |