BEFORE INSERT OR UPDATE ON config.db_patch_dependencies
FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates');
-INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0682', :eg_version); -- berick/dbs/tsbere
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0683', :eg_version); -- tsbere/berick
CREATE TABLE config.bib_source (
id SERIAL PRIMARY KEY,
+BEGIN;
+
+-- check whether patch can be applied
+SELECT evergreen.upgrade_deps_block_check('0683', :eg_version);
+
INSERT INTO action_trigger.event_params (event_def, param, value)
VALUES (5, 'check_email_notify', 1);
INSERT INTO action_trigger.event_params (event_def, param, value)
-- NOT COVERED: Adding check_sms_notify to the proper trigger. It doesn't have a static id.
+COMMIT;
+
--UNDO
--UPDATE action_trigger.event_definition SET validator = 'NOOP_True' WHERE id = 9;
--DELETE FROM action_trigger.event_params WHERE param = 'check_email_notify';