From dc68d5ed06591cbae2cca876fdc1474385d789ae Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 3 Aug 2011 12:40:42 -0400 Subject: [PATCH] 2.0-2.1 upgrade integration of a patch from Steven Callender addressing payment types in money.materialized_summary_payment Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) diff --git a/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql b/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql index 92eda10cbd..cbb6f71c2b 100644 --- a/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql @@ -6012,3 +6012,20 @@ INSERT INTO reporter.materialized_simple_record ; COMMIT; + +DROP TRIGGER IF EXISTS mat_summary_add_tgr ON money.cash_payment; +DROP TRIGGER IF EXISTS mat_summary_upd_tgr ON money.cash_payment; +DROP TRIGGER IF EXISTS mat_summary_del_tgr ON money.cash_payment; + +CREATE TRIGGER mat_summary_add_tgr AFTER INSERT ON money.cash_payment FOR EACH ROW EXECUTE PROCEDURE money.materialized_summary_payment_add ('cash_payment'); +CREATE TRIGGER mat_summary_upd_tgr AFTER UPDATE ON money.cash_payment FOR EACH ROW EXECUTE PROCEDURE money.materialized_summary_payment_update ('cash_payment'); +CREATE TRIGGER mat_summary_del_tgr BEFORE DELETE ON money.cash_payment FOR EACH ROW EXECUTE PROCEDURE money.materialized_summary_payment_del ('cash_payment'); + +DROP TRIGGER IF EXISTS mat_summary_add_tgr ON money.check_payment; +DROP TRIGGER IF EXISTS mat_summary_upd_tgr ON money.check_payment; +DROP TRIGGER IF EXISTS mat_summary_del_tgr ON money.check_payment; + +CREATE TRIGGER mat_summary_add_tgr AFTER INSERT ON money.check_payment FOR EACH ROW EXECUTE PROCEDURE money.materialized_summary_payment_add ('check_payment'); +CREATE TRIGGER mat_summary_upd_tgr AFTER UPDATE ON money.check_payment FOR EACH ROW EXECUTE PROCEDURE money.materialized_summary_payment_update ('check_payment'); +CREATE TRIGGER mat_summary_del_tgr BEFORE DELETE ON money.check_payment FOR EACH ROW EXECUTE PROCEDURE money.materialized_summary_payment_del ('check_payment'); + -- 2.11.0