From c9c4b5f7b886482680d3b27e6a7b305b3bc42fc8 Mon Sep 17 00:00:00 2001 From: Joe Banks Date: Wed, 28 Oct 2020 20:53:03 +0000 Subject: Add new column to Postgres init --- postgres/init.sql | 9 ++++++--- 1 file 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 ); -- cgit v1.2.3