From 11e7e6ec6c8c6d8077dc1fe21a5b6d2a800add95 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 24 Mar 2022 09:01:34 -0400 Subject: [PATCH] Stamping upgrade script Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...X.schema.portal_page_table.sql => 1315.schema.portal_page_table.sql} | 2 ++ ...Y.data.default_portal_page.sql => 1316.data.default_portal_page.sql} | 2 ++ ...{ZZZZ.data.portal_admin_perm.sql => 1317.data.portal_admin_perm.sql} | 2 ++ 4 files changed, 7 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.portal_page_table.sql => 1315.schema.portal_page_table.sql} (95%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.data.default_portal_page.sql => 1316.data.default_portal_page.sql} (97%) rename Open-ILS/src/sql/Pg/upgrade/{ZZZZ.data.portal_admin_perm.sql => 1317.data.portal_admin_perm.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 f49c1dec42..be5d1d0ae6 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 ('1314', :eg_version); -- Dyrcona/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1317', :eg_version); -- gmc/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.portal_page_table.sql b/Open-ILS/src/sql/Pg/upgrade/1315.schema.portal_page_table.sql similarity index 95% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.portal_page_table.sql rename to Open-ILS/src/sql/Pg/upgrade/1315.schema.portal_page_table.sql index 41e872c9b2..259edf041c 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.portal_page_table.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1315.schema.portal_page_table.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1315', :eg_version); + CREATE TABLE config.ui_staff_portal_page_entry_type ( code TEXT PRIMARY KEY, label TEXT NOT NULL diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.default_portal_page.sql b/Open-ILS/src/sql/Pg/upgrade/1316.data.default_portal_page.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.data.default_portal_page.sql rename to Open-ILS/src/sql/Pg/upgrade/1316.data.default_portal_page.sql index 4dbdd5202f..dc80e102b4 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.default_portal_page.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1316.data.default_portal_page.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1316', :eg_version); + INSERT INTO config.ui_staff_portal_page_entry (id, page_col, col_pos, entry_type, label, image_url, target_url, owner) VALUES diff --git a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.data.portal_admin_perm.sql b/Open-ILS/src/sql/Pg/upgrade/1317.data.portal_admin_perm.sql similarity index 76% rename from Open-ILS/src/sql/Pg/upgrade/ZZZZ.data.portal_admin_perm.sql rename to Open-ILS/src/sql/Pg/upgrade/1317.data.portal_admin_perm.sql index c9cbf209a7..5dce02c15c 100644 --- a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.data.portal_admin_perm.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1317.data.portal_admin_perm.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1317', :eg_version); + INSERT INTO permission.perm_list ( id, code, description ) VALUES ( 636, 'ADMIN_STAFF_PORTAL_PAGE', oils_i18n_gettext( 636, 'Update the staff client portal page', 'ppl', 'description' )) -- 2.11.0