From beee20c5b0a63bf8248a630686f2fb262d4789ac Mon Sep 17 00:00:00 2001 From: Kathy Lussier Date: Fri, 3 Aug 2018 13:29:14 -0400 Subject: [PATCH] LP#1750894: Stamping upgrade script for workstation settings on server Signed-off-by: Kathy Lussier --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ma.workstation-settings.sql => 1116.schema.workstation-settings.sql} | 2 +- ...data.workstation-settings.sql => 1117.data.workstation-settings.sql} | 2 ++ 3 files changed, 4 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.workstation-settings.sql => 1116.schema.workstation-settings.sql} (99%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.data.workstation-settings.sql => 1117.data.workstation-settings.sql} (99%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 31cd398275..08763f66f6 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 ('1115', :eg_version); -- miker/berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1117', :eg_version); -- berick/kmlussier CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.workstation-settings.sql b/Open-ILS/src/sql/Pg/upgrade/1116.schema.workstation-settings.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.workstation-settings.sql rename to Open-ILS/src/sql/Pg/upgrade/1116.schema.workstation-settings.sql index 11ff097c3c..fd2e16a162 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.workstation-settings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1116.schema.workstation-settings.sql @@ -8,7 +8,7 @@ CREATE TYPE actor.cascade_setting_summary AS ( has_workstation_setting BOOLEAN ); --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1116', :eg_version); CREATE TABLE config.workstation_setting_type ( name TEXT PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.workstation-settings.sql b/Open-ILS/src/sql/Pg/upgrade/1117.data.workstation-settings.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.data.workstation-settings.sql rename to Open-ILS/src/sql/Pg/upgrade/1117.data.workstation-settings.sql index ba841cd516..1b99f9da5c 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.workstation-settings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1117.data.workstation-settings.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1117', :eg_version); + INSERT INTO permission.perm_list (id, code, description) VALUES (608, 'APPLY_WORKSTATION_SETTING', oils_i18n_gettext(608, 'APPLY_WORKSTATION_SETTING', 'ppl', 'description')); -- 2.11.0