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;