diff options
author | 2021-03-04 11:58:05 +0800 | |
---|---|---|
committer | 2021-03-04 11:58:05 +0800 | |
commit | b5a7dc48cd1ffbb0471858660d58b8b2e6a115fa (patch) | |
tree | 3d9b98700df69ace83c90a31c8625710639427db /postgres/init.sql | |
parent | Hide arrow to the right of More below the 1024px breakpoint (diff) | |
parent | Update Dockerfile (diff) |
Resolve conflicts
Diffstat (limited to 'postgres/init.sql')
-rw-r--r-- | postgres/init.sql | 15 |
1 files changed, 12 insertions, 3 deletions
diff --git a/postgres/init.sql b/postgres/init.sql index 922ce1ad..740063e7 100644 --- a/postgres/init.sql +++ b/postgres/init.sql @@ -4,7 +4,7 @@ CREATE DATABASE metricity; CREATE TABLE users ( id varchar, - verified_at timestamp, + joined_at timestamp, primary key(id) ); @@ -16,15 +16,24 @@ INSERT INTO users VALUES ( CREATE TABLE messages ( id varchar, author_id varchar references users(id), + is_deleted boolean, + created_at timestamp, + channel_id varchar, primary key(id) ); INSERT INTO messages VALUES( 0, - 0 + 0, + false, + now(), + '267659945086812160' ); INSERT INTO messages VALUES( 1, - 0 + 0, + false, + now() + INTERVAL '10 minutes,', + '1234' ); |