diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/0-create.psql | 6 |
1 files changed, 4 insertions, 2 deletions
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)); |