diff options
| author |  Joe Banks <[email protected]> | 2020-10-28 20:53:03 +0000 |
|---|---|---|
| committer | Joe Banks <[email protected]> | 2020-10-28 20:53:03 +0000 |
| commit | c9c4b5f7b886482680d3b27e6a7b305b3bc42fc8 (patch) | |
| tree | 0f090d3769793da65f507e80589785f67fcc08c7 /postgres | |
| parent | Remove unnecessary timestamp conversion (diff) | |
Add new column to Postgres init
Diffstat (limited to 'postgres')
| -rw-r--r-- | postgres/init.sql | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/postgres/init.sql b/postgres/init.sql index 922ce1ad..75a9154c 100644 --- a/postgres/init.sql +++ b/postgres/init.sql @@ -16,15 +16,18 @@ INSERT INTO users VALUES ( CREATE TABLE messages ( id varchar, author_id varchar references users(id), - primary key(id) + primary key(id), + is_deleted boolean ); INSERT INTO messages VALUES( 0, - 0 + 0, + false ); INSERT INTO messages VALUES( 1, - 0 + 0, + false ); |