aboutsummaryrefslogtreecommitdiffstats
path: root/postgres
diff options
context:
space:
mode:
authorGravatar Lucas Lindström <[email protected]>2020-10-06 22:40:14 +0200
committerGravatar Lucas Lindström <[email protected]>2020-10-06 22:41:09 +0200
commit15086b4ab392a8bdc6c33414f0c4e2a294f4a2ef (patch)
tree6cc0dc250c60be6f726165c9570dda93bd32c6b8 /postgres
parentMerge branch 'feat/397-398-metricity-db-and-api' of https://github.com/dement... (diff)
Added total message count to metricity data response.
Diffstat (limited to 'postgres')
-rw-r--r--postgres/init.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/postgres/init.sql b/postgres/init.sql
index fd29ddbc..45ad440c 100644
--- a/postgres/init.sql
+++ b/postgres/init.sql
@@ -32,3 +32,19 @@ INSERT INTO users VALUES (
'{}',
NULL
);
+
+CREATE TABLE messages (
+ id varchar(255),
+ author_id varchar(255) references users(id),
+ primary key(id)
+);
+
+INSERT INTO messages VALUES(
+ 0,
+ 0
+);
+
+INSERT INTO messages VALUES(
+ 1,
+ 0
+);