From 0849a8b71099f8ad456a0f42919df5217d375fdd Mon Sep 17 00:00:00 2001 From: Jane Sandberg Date: Tue, 2 May 2023 14:11:25 -0700 Subject: [PATCH] lp1857911: stamp upgrade script Signed-off-by: Jane Sandberg --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../sql/Pg/upgrade/1370.data.stat-cat-admin.sql | 31 ++++++++++++++++++++ .../sql/Pg/upgrade/XXXX.data.stat-cat-admin.sql | 31 -------------------- 3 files changed, 32 insertions(+), 32 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/1370.data.stat-cat-admin.sql delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.stat-cat-admin.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 7f313cc..93911a3 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 ('1369', :eg_version); -- miker / berick / gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1370', :eg_version); -- phasefx / sandbergja CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/1370.data.stat-cat-admin.sql b/Open-ILS/src/sql/Pg/upgrade/1370.data.stat-cat-admin.sql new file mode 100644 index 0000000..9f00163 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/1370.data.stat-cat-admin.sql @@ -0,0 +1,31 @@ + +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('1370', :eg_version); + +INSERT INTO config.workstation_setting_type (name, grp, datatype, label) +VALUES + ( + 'eg.orgselect.admin.stat_cat.owner', 'gui', 'integer', + oils_i18n_gettext( + 'eg.orgselect.admin.stat_cat.owner', + 'Default org unit for stat cat and stat cat entry editors', + 'cwst', 'label' + ) + ), ( + 'eg.orgfamilyselect.admin.item_stat_cat.main_org_selector', 'gui', 'integer', + oils_i18n_gettext( + 'eg.orgfamilyselect.admin.item_stat_cat.main_org_selector', + 'Default org unit for the main org select in the item stat cat and stat cat entry admin interfaces.', + 'cwst', 'label' + ) + ), ( + 'eg.orgfamilyselect.admin.patron_stat_cat.main_org_selector', 'gui', 'integer', + oils_i18n_gettext( + 'eg.orgfamilyselect.admin.patron_stat_cat.main_org_selector', + 'Default org unit for the main org select in the patron stat cat and stat cat entry admin interfaces.', + 'cwst', 'label' + ) + ); + +COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.stat-cat-admin.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.stat-cat-admin.sql deleted file mode 100644 index 8b020ef..0000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.stat-cat-admin.sql +++ /dev/null @@ -1,31 +0,0 @@ - -BEGIN; - ---SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); - -INSERT INTO config.workstation_setting_type (name, grp, datatype, label) -VALUES - ( - 'eg.orgselect.admin.stat_cat.owner', 'gui', 'integer', - oils_i18n_gettext( - 'eg.orgselect.admin.stat_cat.owner', - 'Default org unit for stat cat and stat cat entry editors', - 'cwst', 'label' - ) - ), ( - 'eg.orgfamilyselect.admin.item_stat_cat.main_org_selector', 'gui', 'integer', - oils_i18n_gettext( - 'eg.orgfamilyselect.admin.item_stat_cat.main_org_selector', - 'Default org unit for the main org select in the item stat cat and stat cat entry admin interfaces.', - 'cwst', 'label' - ) - ), ( - 'eg.orgfamilyselect.admin.patron_stat_cat.main_org_selector', 'gui', 'integer', - oils_i18n_gettext( - 'eg.orgfamilyselect.admin.patron_stat_cat.main_org_selector', - 'Default org unit for the main org select in the patron stat cat and stat cat entry admin interfaces.', - 'cwst', 'label' - ) - ); - -COMMIT; -- 1.7.2.5