summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2021-03-02 13:15:19 +0100
committerYorhel <git@yorhel.nl>2021-03-02 13:15:19 +0100
commitd3d36aa02c9d1558dea603cd64bcf0d266fe5b00 (patch)
tree8c7ef69a399dc9760a5e02c3f12cd1bba93a9438 /util
parent1d9e8f67e6b746c31717d56789deed212c31d7eb (diff)
Reviews: Add moderator note field + only update lastmod when text is changed
Diffstat (limited to 'util')
-rw-r--r--util/updates/2021-03-02-reviews-modnote.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/util/updates/2021-03-02-reviews-modnote.sql b/util/updates/2021-03-02-reviews-modnote.sql
new file mode 100644
index 00000000..f6313303
--- /dev/null
+++ b/util/updates/2021-03-02-reviews-modnote.sql
@@ -0,0 +1,4 @@
+ALTER TABLE reviews ADD COLUMN modnote text NOT NULL DEFAULT '';
+
+-- Not sure why NULL was allowed for the text column, let's fix that while we're here.
+ALTER TABLE reviews ALTER COLUMN text SET NOT NULL;