aboutsummaryrefslogtreecommitdiffstats
path: root/postgres
diff options
context:
space:
mode:
Diffstat (limited to 'postgres')
-rw-r--r--postgres/init.sql7
1 files changed, 5 insertions, 2 deletions
diff --git a/postgres/init.sql b/postgres/init.sql
index 40538492..c77fec9e 100644
--- a/postgres/init.sql
+++ b/postgres/init.sql
@@ -18,6 +18,7 @@ CREATE TABLE messages (
author_id varchar references users(id),
is_deleted boolean,
created_at timestamp,
+ channel_id varchar,
primary key(id)
);
@@ -25,12 +26,14 @@ INSERT INTO messages VALUES(
0,
0,
false,
- now()
+ now(),
+ '267659945086812160'
);
INSERT INTO messages VALUES(
1,
0,
false,
- now() + INTERVAL '10 minutes'
+ now() + INTERVAL '10 minutes,',
+ '1234'
);