Add created and last_active columns to user.

3 files changed, 15 insertions, 0 deletions

diff --git a/db/downgrade_0062---0061.sql b/db/downgrade_0062---0061.sql
new file mode 100644
index 000000000..fa958169a
--- /dev/null
+++ b/db/downgrade_0062---0061.sql
@@ -0,0 +1,6 @@
+BEGIN;
+
+ALTER TABLE users DROP created;
+ALTER TABLE users DROP last_active;
+
+COMMIT;
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,
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;
+