diff options
| author |  Joe Banks <[email protected]> | 2020-10-12 00:43:29 +0100 |
|---|---|---|
| committer |  GitHub <[email protected]> | 2020-10-12 00:43:29 +0100 |
| commit | 30ceab5ec9e3e5ebd1ab8766327e8aa3e4d80c3d (patch) | |
| tree | 6c486312fc97270df4d0b996d86299af7423692b /postgres/init.sql | |
| parent | Responsively size YouTube embeds (diff) | |
| parent | Merge pull request #411 from ks129/voice-gate (diff) | |
Merge branch 'master' into feat/timeline
Diffstat (limited to 'postgres/init.sql')
| -rw-r--r-- | postgres/init.sql | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/postgres/init.sql b/postgres/init.sql new file mode 100644 index 00000000..922ce1ad --- /dev/null +++ b/postgres/init.sql @@ -0,0 +1,30 @@ +CREATE DATABASE metricity; + +\c metricity; + +CREATE TABLE users ( + id varchar, + verified_at timestamp, + primary key(id) +); + +INSERT INTO users VALUES ( + 0, + current_timestamp +); + +CREATE TABLE messages ( + id varchar, + author_id varchar references users(id), + primary key(id) +); + +INSERT INTO messages VALUES( + 0, + 0 +); + +INSERT INTO messages VALUES( + 1, + 0 +); |