1 -- Evergreen DB patch 0589.money.materialized_summary_payment-triggers.sql
3 -- A fix so that the last payment types will be cash_payment and check_payment rather than bnm_payment for cash and check payments.
7 -- check whether patch can be applied
8 SELECT evergreen.upgrade_deps_block_check('0589', :eg_version);
10 DROP TRIGGER IF EXISTS mat_summary_add_tgr ON money.cash_payment;
11 DROP TRIGGER IF EXISTS mat_summary_upd_tgr ON money.cash_payment;
12 DROP TRIGGER IF EXISTS mat_summary_del_tgr ON money.cash_payment;
14 CREATE TRIGGER mat_summary_add_tgr AFTER INSERT ON money.cash_payment FOR EACH ROW EXECUTE PROCEDURE money.materialized_summary_payment_add ('cash_payment');
15 CREATE TRIGGER mat_summary_upd_tgr AFTER UPDATE ON money.cash_payment FOR EACH ROW EXECUTE PROCEDURE money.materialized_summary_payment_update ('cash_payment');
16 CREATE TRIGGER mat_summary_del_tgr BEFORE DELETE ON money.cash_payment FOR EACH ROW EXECUTE PROCEDURE money.materialized_summary_payment_del ('cash_payment');
18 DROP TRIGGER IF EXISTS mat_summary_add_tgr ON money.check_payment;
19 DROP TRIGGER IF EXISTS mat_summary_upd_tgr ON money.check_payment;
20 DROP TRIGGER IF EXISTS mat_summary_del_tgr ON money.check_payment;
22 CREATE TRIGGER mat_summary_add_tgr AFTER INSERT ON money.check_payment FOR EACH ROW EXECUTE PROCEDURE money.materialized_summary_payment_add ('check_payment');
23 CREATE TRIGGER mat_summary_upd_tgr AFTER UPDATE ON money.check_payment FOR EACH ROW EXECUTE PROCEDURE money.materialized_summary_payment_update ('check_payment');
24 CREATE TRIGGER mat_summary_del_tgr BEFORE DELETE ON money.check_payment FOR EACH ROW EXECUTE PROCEDURE money.materialized_summary_payment_del ('check_payment');