aboutsummaryrefslogtreecommitdiffstats
path: root/postgres
diff options
context:
space:
mode:
Diffstat (limited to 'postgres')
-rw-r--r--postgres/init.sql9
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
);