From 57c3298cbb88181ab2a9e2dd5309b7a5df6eb30f Mon Sep 17 00:00:00 2001 From: sostler Date: Sun, 11 Apr 2010 16:50:40 -0400 Subject: Initial muting implementation --- db/0-create.psql | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'db') 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) -- cgit v1.2.3-70-g09d2