From a5cf9c1a721ee50d16aef7e24fca20cb83166350 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Wed, 17 Feb 2021 17:01:29 -0500 Subject: [PATCH] Forward Port 3.5.2 to 3.5.3 db upgrade Signed-off-by: Jason Stephenson --- .../3.5.2-3.5.3-upgrade-db.sql | 22 +++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/3.5.2-3.5.3-upgrade-db.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.5.2-3.5.3-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.5.2-3.5.3-upgrade-db.sql new file mode 100644 index 0000000000..9b1ee86675 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.5.2-3.5.3-upgrade-db.sql @@ -0,0 +1,22 @@ +--Upgrade Script for 3.5.2 to 3.5.3 +\set eg_version '''3.5.3''' +BEGIN; +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.5.3', :eg_version); + +SELECT evergreen.upgrade_deps_block_check('1246', :eg_version); + +CREATE OR REPLACE VIEW money.open_with_balance_usr_summary AS + SELECT + usr, + sum(total_paid) AS total_paid, + sum(total_owed) AS total_owed, + sum(balance_owed) AS balance_owed + FROM money.materialized_billable_xact_summary + WHERE xact_finish IS NULL AND balance_owed <> 0.0 + GROUP BY usr; + +COMMIT; + +-- Update auditor tables to catch changes to source tables. +-- Can be removed/skipped if there were no schema changes. +SELECT auditor.update_auditors(); -- 2.43.2