1 -- Evergreen DB patch XXXX.data.hold-notification-cleanup-mod.sql
4 -- check whether patch can be applied
5 SELECT evergreen.upgrade_deps_block_check('0647', :eg_version);
7 INSERT INTO action_trigger.cleanup ( module, description ) VALUES (
8 'CreateHoldNotification',
10 'CreateHoldNotification',
11 'Creates a hold_notification record for each notified hold',
17 UPDATE action_trigger.event_definition
19 cleanup_success = 'CreateHoldNotification'
21 id = 5 -- stock hold-ready email event_def
22 AND cleanup_success IS NULL; -- don't clobber any existing cleanup mod