Add mod option to set deletion reason for forum posts

1 files changed, 17 insertions, 0 deletions

diff --git a/util/updates/2021-11-07-posts-hidden-msg.sql b/util/updates/2021-11-07-posts-hidden-msg.sql
new file mode 100644
index 00000000..878ae0ab
--- /dev/null
+++ b/util/updates/2021-11-07-posts-hidden-msg.sql
@@ -0,0 +1,17 @@
+BEGIN;
+ALTER TABLE threads_posts
+    DROP CONSTRAINT threads_posts_first_nonhidden,
+    ALTER COLUMN hidden DROP NOT NULL,
+    ALTER COLUMN hidden DROP DEFAULT,
+    ALTER COLUMN hidden TYPE text USING case when hidden then '' else null end,
+    ADD CONSTRAINT threads_posts_first_nonhidden CHECK(num > 1 OR hidden IS NULL);
+
+ALTER TABLE reviews_posts
+    ALTER COLUMN hidden DROP NOT NULL,
+    ALTER COLUMN hidden DROP DEFAULT,
+    ALTER COLUMN hidden TYPE text USING case when hidden then '' else null end;
+
+\i sql/func.sql
+COMMIT;
+
+\i sql/triggers.sql