c45b3c6d18e91ca18ac054f899fabdfbefacaae3
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / XXXX.schema.correct_mtbs_view.sql
1 BEGIN;
2
3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
4
5 CREATE OR REPLACE VIEW money.transaction_billing_summary AS
6     SELECT id as xact,
7         last_billing_type,
8         last_billing_note,
9         last_billing_ts,
10         total_owed
11       FROM money.materialized_billable_xact_summary;
12
13 COMMIT;