aboutsummaryrefslogtreecommitdiffstats
path: root/postgres
diff options
context:
space:
mode:
authorGravatar Joe Banks <[email protected]>2020-11-02 18:25:27 +0000
committerGravatar Joe Banks <[email protected]>2020-11-02 18:25:27 +0000
commit23bf022cf8fae66225e829c4a0abbccb2940edb7 (patch)
tree08b44a5890931489187bbe805a025091b1266899 /postgres
parentAdd created_at to metricity database bootstrap (diff)
Exclude bot commands and seasonalbot commands from voice gate
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'
);