diff options
| author |  Lucas Lindström <[email protected]> | 2020-10-06 22:40:14 +0200 |
|---|---|---|
| committer | Lucas Lindström <[email protected]> | 2020-10-06 22:41:09 +0200 |
| commit | 15086b4ab392a8bdc6c33414f0c4e2a294f4a2ef (patch) | |
| tree | 6cc0dc250c60be6f726165c9570dda93bd32c6b8 /postgres | |
| parent | Merge 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.sql | 16 |
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 +); |