From 0b64308cec1d0fb74baf81e6de7fe40d95d0645c Mon Sep 17 00:00:00 2001 From: Yorhel Date: Sat, 5 Sep 2020 11:37:58 +0200 Subject: Notifications: Add notifications for thread posts and review comments --- util/updates/2020-09-05-notifications.sql | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'util') 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 -- cgit v1.2.3