From 66a1ac01ebaa844ff08ccde584c5194e5d78bc59 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Tue, 22 Jan 2013 14:32:00 -0500 Subject: [PATCH] Modify XXXX.schema.money.void_payment.sql. Remove a couple of unnecessary DROP VIEW statements because they're dropped automagically when the voided column is dropped from money.billing. We also don't attempt to recreate the dropped views above because they are meaningless now that the voided column is gone. Signed-off-by: Jason Stephenson --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.money.void_payment.sql | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.money.void_payment.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.money.void_payment.sql index 610625ec19..3c13e555e4 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.money.void_payment.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.money.void_payment.sql @@ -109,9 +109,8 @@ CREATE OR REPLACE VIEW money.billable_xact_summary AS ) credit ON xact.id = credit.xact ORDER BY debit.billing_ts, credit.payment_ts; --- Drop billing summary views that include voided. -DROP VIEW money.transaction_billing_with_void_summary; -DROP VIEW money.transaction_payment_with_void_summary; +-- Drop billable_xact_with_void_summary since billable_xact_summary +-- now takes its place. DROP VIEW money.billable_xact_with_void_summary; -- Alter trigger functions as necessary. -- 2.11.0