From 8bc8f4b8631a9663f71728dad56992cc32406b1c Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Wed, 2 Oct 2019 11:38:42 -0400 Subject: [PATCH] LP#1846357: adjust 3.3.3-3.4.0 schema update Signed-off-by: Galen Charlton --- .../Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql | 13 ++++++++++++- 1 file changed, 12 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql index b1054a8947..013352ee9d 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql @@ -756,6 +756,7 @@ END; $$ LANGUAGE PLPGSQL; SELECT evergreen.upgrade_deps_block_check('1187', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1192', :eg_version); CREATE OR REPLACE FUNCTION action.age_circ_on_delete () RETURNS TRIGGER AS $$ DECLARE @@ -794,11 +795,21 @@ BEGIN auto_renewal, auto_renewal_remaining FROM action.all_circulation WHERE id = OLD.id; + -- Migrate billings and payments to aged tables + + INSERT INTO money.aged_billing + SELECT * FROM money.billing WHERE xact = OLD.id; + + INSERT INTO money.aged_payment + SELECT * FROM money.payment_view WHERE xact = OLD.id; + + DELETE FROM money.payment WHERE xact = OLD.id; + DELETE FROM money.billing WHERE xact = OLD.id; + RETURN OLD; END; $$ LANGUAGE 'plpgsql'; - SELECT evergreen.upgrade_deps_block_check('1188', :eg_version); UPDATE action.circulation SET auto_renewal = FALSE WHERE auto_renewal IS NULL; -- 2.43.2