aboutsummaryrefslogtreecommitdiffstats
path: root/postgres/init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'postgres/init.sql')
-rw-r--r--postgres/init.sql91
1 files changed, 91 insertions, 0 deletions
diff --git a/postgres/init.sql b/postgres/init.sql
index ae86fca0..190a705c 100644
--- a/postgres/init.sql
+++ b/postgres/init.sql
@@ -13,6 +13,11 @@ INSERT INTO users VALUES (
current_timestamp
);
+INSERT INTO users VALUES (
+ 1,
+ current_timestamp
+);
+
CREATE TABLE channels (
id varchar,
name varchar,
@@ -25,6 +30,36 @@ INSERT INTO channels VALUES(
);
INSERT INTO channels VALUES(
+ '11',
+ 'help-apple'
+);
+
+INSERT INTO channels VALUES(
+ '12',
+ 'help-cherry'
+);
+
+INSERT INTO channels VALUES(
+ '21',
+ 'ot0-hello'
+);
+
+INSERT INTO channels VALUES(
+ '22',
+ 'ot1-world'
+);
+
+INSERT INTO channels VALUES(
+ '31',
+ 'voice-chat-0'
+);
+
+INSERT INTO channels VALUES(
+ '32',
+ 'code-help-voice-0'
+);
+
+INSERT INTO channels VALUES(
'1234',
'zebra'
);
@@ -53,3 +88,59 @@ INSERT INTO messages VALUES(
now() + INTERVAL '10 minutes,',
'1234'
);
+
+INSERT INTO messages VALUES(
+ 2,
+ 0,
+ false,
+ now(),
+ '11'
+);
+
+INSERT INTO messages VALUES(
+ 3,
+ 0,
+ false,
+ now(),
+ '12'
+);
+
+INSERT INTO messages VALUES(
+ 4,
+ 1,
+ false,
+ now(),
+ '21'
+);
+
+INSERT INTO messages VALUES(
+ 5,
+ 1,
+ false,
+ now(),
+ '22'
+);
+
+INSERT INTO messages VALUES(
+ 6,
+ 1,
+ false,
+ now(),
+ '31'
+);
+
+INSERT INTO messages VALUES(
+ 7,
+ 1,
+ false,
+ now(),
+ '32'
+);
+
+INSERT INTO messages VALUES(
+ 8,
+ 1,
+ true,
+ now(),
+ '32'
+);