LP#1206936 Stamping upgrade script; adding test
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0959.schema.correct_mtbs_view.sql
1 BEGIN;
2
3 SELECT evergreen.upgrade_deps_block_check('0959', :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;