Keep track of when a session has last been used

If we're going to automatically remove older sessions, it would make
more sense to remove unused sessions, rather than old sessions that are
still in use. But we first need to keep track of when a session has last
been used to do so...

1 files changed, 1 insertions, 0 deletions

diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index f345cffd..f0091929 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -173,6 +173,7 @@ CREATE TABLE sessions (
   uid integer NOT NULL,
   token bytea NOT NULL,
   expiration timestamptz NOT NULL DEFAULT (now() + '1 year'::interval),
+  lastused timestamptz NOT NULL DEFAULT NOW(),
   PRIMARY KEY (uid, token)
 );