diff options
Diffstat (limited to 'util/updates/wip-notifications.sql')
-rw-r--r-- | util/updates/wip-notifications.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/util/updates/wip-notifications.sql b/util/updates/wip-notifications.sql new file mode 100644 index 00000000..31dababa --- /dev/null +++ b/util/updates/wip-notifications.sql @@ -0,0 +1,17 @@ +-- Simplified triggers, all the logic is consolidated in notify(). +DROP TRIGGER notify_pm ON threads_posts; +DROP TRIGGER notify_announce ON threads_posts; +DROP FUNCTION notify_pm(); +DROP FUNCTION notify_announce(); + +DROP FUNCTION notify_dbdel(dbentry_type, edit_rettype); +DROP FUNCTION notify_dbedit(dbentry_type, edit_rettype); +DROP FUNCTION notify_listdel(dbentry_type, edit_rettype); + +-- Table changes +ALTER TABLE notifications ALTER COLUMN ntype TYPE notification_ntype[] USING ARRAY[ntype]; +ALTER TABLE notifications DROP COLUMN c_title; +ALTER TABLE notifications DROP COLUMN c_byuser; + +\i sql/func.sql +\i sql/triggers.sql |