From c590ba3e3c6fb90e15e0005fa25eb6416a09952f Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 27 Feb 2020 11:01:31 -0500 Subject: [PATCH] LP1811132 Debit payment SQL upgrade fix Repair a copy/paste thinko in the upgrade script for debit card payments. Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/upgrade/1200.schema.debit_card_payment.sql | 1 - 1 file changed, 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/1200.schema.debit_card_payment.sql b/Open-ILS/src/sql/Pg/upgrade/1200.schema.debit_card_payment.sql index 88ad356037..5e753b03f6 100644 --- a/Open-ILS/src/sql/Pg/upgrade/1200.schema.debit_card_payment.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1200.schema.debit_card_payment.sql @@ -18,7 +18,6 @@ CREATE OR REPLACE VIEW money.non_drawer_payment_view AS SELECT p.*, c.relname AS payment_type FROM money.bnm_payment p JOIN pg_class c ON p.tableoid = c.oid - WHERE c.relname NOT IN ('cash_payment','check_payment','credit_card_payment'); WHERE c.relname NOT IN ('cash_payment','check_payment','credit_card_payment','debit_card_payment'); UPDATE action_trigger.event_definition -- 2.43.2