From 8ee3fa64b7024388443d07745e7971e7634f591f Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 3 Sep 2020 12:00:27 -0400 Subject: [PATCH] LP1850547 Stamping DB upgrade: Ang Acq Search Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...XXX.data.angular_acq_search.sql => 1217.data.angular_acq_search.sql} | 2 +- .../{YYYY.data.acq_permissions.sql => 1218.data.acq_permissions.sql} | 2 ++ ...{ZZZZ.schema.acq_state_views.sql => 1219.schema.acq_state_views.sql} | 2 +- 4 files changed, 5 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.angular_acq_search.sql => 1217.data.angular_acq_search.sql} (97%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.data.acq_permissions.sql => 1218.data.acq_permissions.sql} (97%) rename Open-ILS/src/sql/Pg/upgrade/{ZZZZ.schema.acq_state_views.sql => 1219.schema.acq_state_views.sql} (90%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index ac3b514f98..82227504dd 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 ('1216', :eg_version); -- berick/sandbergja +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1219', :eg_version); -- gmcharlt/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.angular_acq_search.sql b/Open-ILS/src/sql/Pg/upgrade/1217.data.angular_acq_search.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.angular_acq_search.sql rename to Open-ILS/src/sql/Pg/upgrade/1217.data.angular_acq_search.sql index b3482e0e6c..33988de5bc 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.angular_acq_search.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1217.data.angular_acq_search.sql @@ -1,6 +1,6 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1217', :eg_version); INSERT INTO config.workstation_setting_type (name, grp, datatype, label) diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.acq_permissions.sql b/Open-ILS/src/sql/Pg/upgrade/1218.data.acq_permissions.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.data.acq_permissions.sql rename to Open-ILS/src/sql/Pg/upgrade/1218.data.acq_permissions.sql index 45e33fd6b1..266d9a079f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.acq_permissions.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1218.data.acq_permissions.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1218', :eg_version); + INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) SELECT pgt.id, perm.id, aout.depth, TRUE diff --git a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.acq_state_views.sql b/Open-ILS/src/sql/Pg/upgrade/1219.schema.acq_state_views.sql similarity index 90% rename from Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.acq_state_views.sql rename to Open-ILS/src/sql/Pg/upgrade/1219.schema.acq_state_views.sql index 2ed6c79bf0..41c9c9bd6b 100644 --- a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.acq_state_views.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1219.schema.acq_state_views.sql @@ -1,6 +1,6 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1219', :eg_version); CREATE VIEW acq.li_state_label AS SELECT * -- 2.11.0