From 2c4f09a52b881576396b40e5f1e81cd31b0c2161 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Tue, 15 Sep 2020 12:10:02 -0400 Subject: [PATCH] LP#1811710: stamp schema update Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ttings.sql => 1233.data.wide_holds-workstation-settings.sql} | 2 +- ...schema.hopeless_holds.sql => 1234.schema.hopeless_holds.sql} | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.wide_holds-workstation-settings.sql => 1233.data.wide_holds-workstation-settings.sql} (82%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.schema.hopeless_holds.sql => 1234.schema.hopeless_holds.sql} (78%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 2978fe859b..351a9a4dc7 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 ('1232', :eg_version); -- khuckins/sandbergja/JBoyer/mmorgan/gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1234', :eg_version); -- phasefx/gmcharlt/terranm/charp CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.wide_holds-workstation-settings.sql b/Open-ILS/src/sql/Pg/upgrade/1233.data.wide_holds-workstation-settings.sql similarity index 82% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.wide_holds-workstation-settings.sql rename to Open-ILS/src/sql/Pg/upgrade/1233.data.wide_holds-workstation-settings.sql index 717001d121..7a53e96f0b 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.wide_holds-workstation-settings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1233.data.wide_holds-workstation-settings.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1233', :eg_version); INSERT into config.workstation_setting_type (name, grp, datatype, label) VALUES ( diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.hopeless_holds.sql b/Open-ILS/src/sql/Pg/upgrade/1234.schema.hopeless_holds.sql similarity index 78% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.schema.hopeless_holds.sql rename to Open-ILS/src/sql/Pg/upgrade/1234.schema.hopeless_holds.sql index 7205a71dd7..b06e4a5e01 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.hopeless_holds.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1234.schema.hopeless_holds.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('YYYY', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1234', :eg_version); ALTER TABLE config.copy_status ADD COLUMN hopeless_prone BOOL NOT NULL DEFAULT FALSE; -- 002.schema.config.sql ALTER TABLE action.hold_request ADD COLUMN hopeless_date TIMESTAMP WITH TIME ZONE; -- 090.schema.action.sql -- 2.43.2