From 25829d2d0e379c323b8f2ae6e7c2aad7548f0a30 Mon Sep 17 00:00:00 2001 From: FChannel <> Date: Sat, 18 Jun 2022 13:57:30 -0700 Subject: sticky and lock implemented --- databaseschema.psql | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) (limited to 'databaseschema.psql') 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 -- cgit v1.2.3