From 8054e9ebbd317fe0262a5d9fd37e789bfd46cbcb Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 19 Jun 2017 12:18:19 -0400 Subject: [PATCH] LP#1691237: stamp schema update Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...l => 1046.data.webstaff_date_format_ou_settings.sql} | 17 +---------------- 2 files changed, 2 insertions(+), 17 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.webstaff_date_format_ou_settings.sql => 1046.data.webstaff_date_format_ou_settings.sql} (70%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index df2bb56515..07d491e9f7 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -90,7 +90,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 ('1045', :eg_version); -- csharp/berick/gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1046', :eg_version); -- phasefx/berick/gmcharlt CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.webstaff_date_format_ou_settings.sql b/Open-ILS/src/sql/Pg/upgrade/1046.data.webstaff_date_format_ou_settings.sql similarity index 70% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.webstaff_date_format_ou_settings.sql rename to Open-ILS/src/sql/Pg/upgrade/1046.data.webstaff_date_format_ou_settings.sql index a7ac6af63d..d1e302700a 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.webstaff_date_format_ou_settings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1046.data.webstaff_date_format_ou_settings.sql @@ -1,6 +1,6 @@ BEGIN; ---SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1046', :eg_version); -- phasefx/berick/gmcharlt INSERT into config.org_unit_setting_type ( name @@ -50,19 +50,4 @@ WHERE name IN ('format.date','format.time') ; --- for testing, setting removal: ---DELETE FROM actor.org_unit_setting WHERE name IN ( --- 'webstaff.format.dates' --- ,'webstaff.format.date_and_time' ---); ---DELETE FROM config.org_unit_setting_type_log WHERE field_name IN ( --- 'webstaff.format.dates' --- ,'webstaff.format.date_and_time' ---); ---DELETE FROM config.org_unit_setting_type WHERE name IN ( --- 'webstaff.format.dates' --- ,'webstaff.format.date_and_time' ---); ---UPDATE config.org_unit_setting_type SET label = REPLACE(label,'Deprecated: ','') WHERE name in ('format.date','format.time'); - COMMIT; -- 2.11.0