aboutsummaryrefslogtreecommitdiffstats
path: root/postgres/init.sql
diff options
context:
space:
mode:
authorGravatar Joe Banks <[email protected]>2020-10-31 00:01:34 +0000
committerGravatar GitHub <[email protected]>2020-10-31 00:01:34 +0000
commitc28aab2ffa7c3fc5546125d92e03b43a09752ab2 (patch)
tree3c85f9e4d6eed6d3401189029773673f5c834ab2 /postgres/init.sql
parentUse referral code for Linode (diff)
parentIndent metricity block query correctly (diff)
Merge pull request #418 from python-discord/metricity/add-activity-blocks
Add activity blocks to Metricity data endpoint
Diffstat (limited to '')
-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
);