aboutsummaryrefslogtreecommitdiff
path: root/databaseschema.psql
diff options
context:
space:
mode:
Diffstat (limited to 'databaseschema.psql')
-rw-r--r--databaseschema.psql12
1 files changed, 11 insertions, 1 deletions
diff --git a/databaseschema.psql b/databaseschema.psql
index f5671c2..d4b2616 100644
--- a/databaseschema.psql
+++ b/databaseschema.psql
@@ -244,4 +244,14 @@ instance varchar(100) primary key,
timestamp TIMESTAMP default NOW()
);
-ALTER TABLE boardaccess ADD COLUMN IF NOT EXISTS label varchar(50) default 'Anon'; \ No newline at end of file
+ALTER TABLE boardaccess ADD COLUMN IF NOT EXISTS label varchar(50) default 'Anon';
+
+CREATE TABLE IF NOT EXISTS sticky(
+actor_id varchar(100),
+activity_id varchar(100)
+);
+
+CREATE TABLE IF NOT EXISTS locked(
+actor_id varchar(100),
+activity_id varchar(100)
+); \ No newline at end of file