From 21922b749a5696a2ea4274e0968ad2d3d20dcc9d Mon Sep 17 00:00:00 2001 From: sostler Date: Fri, 16 Apr 2010 13:41:02 -0400 Subject: Intermediate commit from muting admin --- db/0-create.psql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'db') diff --git a/db/0-create.psql b/db/0-create.psql index 10c57a2..979363d 100644 --- a/db/0-create.psql +++ b/db/0-create.psql @@ -56,13 +56,15 @@ 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 ( + mute_id SERIAL PRIMARY KEY, 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 + cancelled bool NOT NULL DEFAULT false, + cancel_admin_id integer REFERENCES users, + cancel_reason text ); CREATE INDEX mutes_expires_idx ON mutes ((set_on + duration)); -- cgit v1.2.3-70-g09d2