From 9d67114bd74e2cc4d5715ca8fd6ed3af446ac3bb Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 12 Aug 2021 15:20:53 -0400 Subject: [PATCH] LP1904244 Stamping DB Upgrade : ACQ Admin Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../{WWWW.schema.add_indexes.sql => 1274.schema.add_indexes.sql} | 2 ++ ....update_fund_xfr_notes.sql => 1275.schema.update_fund_xfr_notes.sql} | 2 ++ ...cq-admin-grid-settings.sql => 1276.data.acq-admin-grid-settings.sql} | 2 ++ ...e-acqf-code-not-null.sql => 1277.schema.make-acqf-code-not-null.sql} | 2 ++ 5 files changed, 9 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{WWWW.schema.add_indexes.sql => 1274.schema.add_indexes.sql} (68%) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.update_fund_xfr_notes.sql => 1275.schema.update_fund_xfr_notes.sql} (99%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.data.acq-admin-grid-settings.sql => 1276.data.acq-admin-grid-settings.sql} (96%) rename Open-ILS/src/sql/Pg/upgrade/{ZZZZ.schema.make-acqf-code-not-null.sql => 1277.schema.make-acqf-code-not-null.sql} (76%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 95a94a57a9..9cd06181f0 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -92,7 +92,7 @@ CREATE TRIGGER no_overlapping_deps BEFORE INSERT OR UPDATE ON config.db_patch_dependencies FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates'); -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1273', :eg_version); -- miker/erohlfs/gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1277', :eg_version); -- gmcharlt/rfrasur/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/WWWW.schema.add_indexes.sql b/Open-ILS/src/sql/Pg/upgrade/1274.schema.add_indexes.sql similarity index 68% rename from Open-ILS/src/sql/Pg/upgrade/WWWW.schema.add_indexes.sql rename to Open-ILS/src/sql/Pg/upgrade/1274.schema.add_indexes.sql index 30296c0e6d..be676b08c7 100644 --- a/Open-ILS/src/sql/Pg/upgrade/WWWW.schema.add_indexes.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1274.schema.add_indexes.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1274', :eg_version); + CREATE INDEX poi_fund_debit_idx ON acq.po_item (fund_debit); CREATE INDEX ii_fund_debit_idx ON acq.invoice_item (fund_debit); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.update_fund_xfr_notes.sql b/Open-ILS/src/sql/Pg/upgrade/1275.schema.update_fund_xfr_notes.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.update_fund_xfr_notes.sql rename to Open-ILS/src/sql/Pg/upgrade/1275.schema.update_fund_xfr_notes.sql index 2f80e0d08a..4e4244a7da 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.update_fund_xfr_notes.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1275.schema.update_fund_xfr_notes.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1275', :eg_version); + CREATE OR REPLACE FUNCTION acq.transfer_fund( old_fund IN INT, old_amount IN NUMERIC, -- in currency of old fund diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.acq-admin-grid-settings.sql b/Open-ILS/src/sql/Pg/upgrade/1276.data.acq-admin-grid-settings.sql similarity index 96% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.data.acq-admin-grid-settings.sql rename to Open-ILS/src/sql/Pg/upgrade/1276.data.acq-admin-grid-settings.sql index c29c099329..cbf48afd37 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.acq-admin-grid-settings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1276.data.acq-admin-grid-settings.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1276', :eg_version); + INSERT INTO config.workstation_setting_type (name, grp, datatype, label) VALUES ( 'eg.grid.acq.fund.fund_debit', 'gui', 'object', diff --git a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.make-acqf-code-not-null.sql b/Open-ILS/src/sql/Pg/upgrade/1277.schema.make-acqf-code-not-null.sql similarity index 76% rename from Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.make-acqf-code-not-null.sql rename to Open-ILS/src/sql/Pg/upgrade/1277.schema.make-acqf-code-not-null.sql index f923c1131e..9c84bedcc9 100644 --- a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.make-acqf-code-not-null.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1277.schema.make-acqf-code-not-null.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1277', :eg_version); + -- if there are any straggling funds without a code set, fix that UPDATE acq.fund SET code = 'FUND-WITH-ID-' || id -- 2.11.0