From 6804f4f0f19d7c0047870b7da4b79ab099140b98 Mon Sep 17 00:00:00 2001
From: Joe Banks <joseph@josephbanks.me>
Date: Sun, 1 Nov 2020 18:41:51 +0000
Subject: Add created_at to metricity database bootstrap

---
 postgres/init.sql | 11 +++++++----
 1 file changed, 7 insertions(+), 4 deletions(-)

(limited to 'postgres/init.sql')

diff --git a/postgres/init.sql b/postgres/init.sql
index 75a9154c..40538492 100644
--- a/postgres/init.sql
+++ b/postgres/init.sql
@@ -16,18 +16,21 @@ INSERT INTO users VALUES (
 CREATE TABLE messages (
     id varchar,
     author_id varchar references users(id),
-    primary key(id),
-    is_deleted boolean
+    is_deleted boolean,
+    created_at timestamp,
+    primary key(id)
 );
 
 INSERT INTO messages VALUES(
     0,
     0,
-    false
+    false,
+    now()
 );
 
 INSERT INTO messages VALUES(
     1,
     0,
-    false
+    false,
+    now() + INTERVAL '10 minutes'
 );
-- 
cgit v1.2.3

