Initial muting implementation

1 files changed, 12 insertions, 0 deletions

diff --git a/db/0-create.psql b/db/0-create.psql
index e0c5443..10c57a2 100644
--- a/db/0-create.psql
+++ b/db/0-create.psql
@@ -55,6 +55,18 @@ CREATE INDEX tags_message_id_idx ON tags (message_id);
 CREATE INDEX tags_created_on_id_idx ON tags (created_on DESC);
 CREATE INDEX tags_tag_lowercase_idx ON tags (lower(tag));
 
+CREATE TABLE mutes (
+  user_id integer NOT NULL REFERENCES users,
+  admin_id integer NOT NULL REFERENCES users,
+  set_on timestamp NOT NULL DEFAULT now(),
+  duration interval NOT NULL,
+  reason text NOT NULL,
+  is_canceled bool NOT NULL DEFAULT false,
+  cancel_admin_id integer REFERENCES users
+);
+
+CREATE INDEX mutes_expires_idx ON mutes ((set_on + duration));
+
 INSERT INTO rooms (key, name, description, admin_only) 
        VALUES ('dumpfm', 'Room A', 'Hangout', false);
 INSERT INTO rooms (key, name, description, admin_only)