diff options
author | Yorhel <git@yorhel.nl> | 2021-03-02 13:15:19 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2021-03-02 13:15:19 +0100 |
commit | d3d36aa02c9d1558dea603cd64bcf0d266fe5b00 (patch) | |
tree | 8c7ef69a399dc9760a5e02c3f12cd1bba93a9438 /util | |
parent | 1d9e8f67e6b746c31717d56789deed212c31d7eb (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.sql | 4 |
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; |