aboutsummaryrefslogtreecommitdiffstats
path: root/postgres/init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'postgres/init.sql')
-rw-r--r--postgres/init.sql11
1 files changed, 7 insertions, 4 deletions
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'
);