aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema_0062-add-user-created-last-active.sql
diff options
context:
space:
mode:
authorMarius Halden <marius.h@lden.org>2018-06-07 13:28:45 +0200
committerMarius Halden <marius.h@lden.org>2018-06-07 13:28:45 +0200
commit956f8b8a065824f9a9dc379eba1d0aa8b1b669cf (patch)
tree49f9ccb147b18dddee97500d4df7a3fb3dd3737c /db/schema_0062-add-user-created-last-active.sql
parent782457d016084c8de04989dbc824a71899f8b41b (diff)
parent4dbf5371f79c5f290c08e561ba2c881e96b58669 (diff)
Merge tag 'v2.3.3' into fiksgatami-dev
Diffstat (limited to 'db/schema_0062-add-user-created-last-active.sql')
-rw-r--r--db/schema_0062-add-user-created-last-active.sql7
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;
+