aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
diff options
context:
space:
mode:
authorMatthew Somerville <matthew-github@dracos.co.uk>2018-05-24 10:33:05 +0100
committerMatthew Somerville <matthew-github@dracos.co.uk>2018-05-24 10:33:05 +0100
commit72ab2740e2c8c24e62b6e9d98f686498b1225b09 (patch)
tree4e0260c14afbbdcd79ebe66f09aa37d9af509157 /db/schema.sql
parentda305260b4db386af9fb2c48d9055a2934069c84 (diff)
parentec4fb8fe445efd5cb584ac7021707c41a0188cdb (diff)
Merge branch 'user-inactivity'
Diffstat (limited to 'db/schema.sql')
-rw-r--r--db/schema.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/db/schema.sql b/db/schema.sql
index fa0bd07bd..30f5d3a30 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -30,6 +30,8 @@ create table users (
from_body integer,
flagged boolean not null default 'f',
is_superuser boolean not null default 'f',
+ created timestamp not null default current_timestamp,
+ last_active timestamp not null default current_timestamp,
title text,
twitter_id bigint unique,
facebook_id bigint unique,