From 41c3152852132cfba79899d099678e6f9ee5dc5c Mon Sep 17 00:00:00 2001
From: Mike Rylander <mrylander@gmail.com>
Date: Wed, 3 Aug 2011 13:02:30 -0400
Subject: [PATCH] Upgrade script for a patch from Steven Callender addressing
payment types in money.materialized_summary_payment
Signed-off-by: Mike Rylander <mrylander@gmail.com>
---
...money.materialized_summary_payment-triggers.sql | 26 ++++++++++++++++++++++
1 file changed, 26 insertions(+)
create mode 100644 Open-ILS/src/sql/Pg/upgrade/0589.money.materialized_summary_payment-triggers.sql
diff --git a/Open-ILS/src/sql/Pg/upgrade/0589.money.materialized_summary_payment-triggers.sql b/Open-ILS/src/sql/Pg/upgrade/0589.money.materialized_summary_payment-triggers.sql
new file mode 100644
index 0000000000..1a321cf8c6
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/0589.money.materialized_summary_payment-triggers.sql
@@ -0,0 +1,26 @@
+-- Evergreen DB patch 0589.money.materialized_summary_payment-triggers.sql
+--
+-- A fix so that the last payment types will be cash_payment and check_payment rather than bnm_payment for cash and check payments.
+--
+BEGIN;
+
+-- check whether patch can be applied
+SELECT evergreen.upgrade_deps_block_check('0589', :eg_version);
+
+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');
+
+COMMIT;
--
2.11.0