From c9c4b5f7b886482680d3b27e6a7b305b3bc42fc8 Mon Sep 17 00:00:00 2001
From: Joe Banks <joseph@josephbanks.me>
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(-)

(limited to 'postgres/init.sql')

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

