diff options
| author | Matthew Somerville <matthew-github@dracos.co.uk> | 2018-05-24 10:33:05 +0100 |
|---|---|---|
| committer | Matthew Somerville <matthew-github@dracos.co.uk> | 2018-05-24 10:33:05 +0100 |
| commit | 72ab2740e2c8c24e62b6e9d98f686498b1225b09 (patch) | |
| tree | 4e0260c14afbbdcd79ebe66f09aa37d9af509157 /db/schema_0062-add-user-created-last-active.sql | |
| parent | da305260b4db386af9fb2c48d9055a2934069c84 (diff) | |
| parent | ec4fb8fe445efd5cb584ac7021707c41a0188cdb (diff) | |
Merge branch 'user-inactivity'
Diffstat (limited to 'db/schema_0062-add-user-created-last-active.sql')
| -rw-r--r-- | db/schema_0062-add-user-created-last-active.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/db/schema_0062-add-user-created-last-active.sql b/db/schema_0062-add-user-created-last-active.sql new file mode 100644 index 000000000..0e8875870 --- /dev/null +++ b/db/schema_0062-add-user-created-last-active.sql @@ -0,0 +1,7 @@ +BEGIN; + +ALTER TABLE users ADD created timestamp default current_timestamp not null; +ALTER TABLE users ADD last_active timestamp default current_timestamp not null; + +COMMIT; + |