aboutsummaryrefslogtreecommitdiff
path: root/databaseschema.psql
diff options
context:
space:
mode:
authorFChannel <>2022-06-18 13:57:30 -0700
committerFChannel <>2022-06-19 12:53:29 -0700
commit25829d2d0e379c323b8f2ae6e7c2aad7548f0a30 (patch)
treec828eb5bb04ce04141c717c26b637a59b32ab979 /databaseschema.psql
parentf3d1683d6562afb30522afb98fb3a22456473275 (diff)
sticky and lock implemented
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