summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2020-09-03 13:07:20 +0200
committerYorhel <git@yorhel.nl>2020-09-03 13:07:30 +0200
commitc8e5426bfa7d57e6345070d98405ea4eed81ad93 (patch)
tree4e4a8361b64b8da94f337030c4281eacc7308c31 /util
parente9852ed38b6e57e871f2a89bfcc2f42d60f3a676 (diff)
Reviews: Hide downvoted reviews & allow moderator overruling
Seems like a better moderation tool than outright deleting reviews.
Diffstat (limited to 'util')
-rw-r--r--util/updates/2020-09-03-reviews-flagging.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/util/updates/2020-09-03-reviews-flagging.sql b/util/updates/2020-09-03-reviews-flagging.sql
new file mode 100644
index 00000000..3cf8ee2c
--- /dev/null
+++ b/util/updates/2020-09-03-reviews-flagging.sql
@@ -0,0 +1,5 @@
+ALTER TABLE reviews ADD COLUMN c_flagged boolean NOT NULL DEFAULT false;
+ALTER TABLE reviews_votes ADD COLUMN overrule boolean NOT NULL DEFAULT false;
+
+\i sql/func.sql
+select update_reviews_votes_cache(null);