From 6804f4f0f19d7c0047870b7da4b79ab099140b98 Mon Sep 17 00:00:00 2001 From: Joe Banks 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') 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