path: root/util
diff options
authorYorhel <>2020-09-05 11:37:58 +0200
committerYorhel <>2020-09-05 11:37:58 +0200
commit0b64308cec1d0fb74baf81e6de7fe40d95d0645c (patch)
tree152021bef140dd386c478ca47757e07737b600c8 /util
parent112f64f1c75b19b65cce701754f2f43cea0edcf4 (diff)
Notifications: Add notifications for thread posts and review comments
Diffstat (limited to 'util')
1 files changed, 6 insertions, 0 deletions
diff --git a/util/updates/2020-09-05-notifications.sql b/util/updates/2020-09-05-notifications.sql
index 864824e3..1c3e6bd6 100644
--- a/util/updates/2020-09-05-notifications.sql
+++ b/util/updates/2020-09-05-notifications.sql
@@ -6,5 +6,11 @@ ALTER TABLE notifications ALTER COLUMN c_byuser DROP NOT NULL;
DROP TYPE notification_ltype;
UPDATE notifications SET c_byuser = NULL WHERE c_byuser = 0;
+ALTER TABLE users ADD COLUMN notify_post boolean NOT NULL DEFAULT true;
+ALTER TABLE users ADD COLUMN notify_comment boolean NOT NULL DEFAULT true;
+ALTER TYPE notification_ntype ADD VALUE 'post' AFTER 'announce';
+ALTER TYPE notification_ntype ADD VALUE 'comment' AFTER 'post';
\i sql/func.sql
\i sql/triggers.sql
+\i sql/perms.sql