Intermediate commit from muting admin

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));