From c1b85d1d09151483c62bba1cce268cec154ab0a4 Mon Sep 17 00:00:00 2001 From: Michele Morgan Date: Thu, 27 Oct 2022 10:39:33 -0400 Subject: [PATCH] LP1396764 - Stamping upgrade script Signed-off-by: Michele Morgan --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ote.sql => 1343.schema.hours-of-operation-note} | 26 +++++++++++----------- 2 files changed, 14 insertions(+), 14 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{xxxx.schema.lp1396764-hours-of-operation-note.sql => 1343.schema.hours-of-operation-note} (76%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 991f4eeef4..68a29567a3 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 ('1342', :eg_version); -- jeffdavis/blake/sandbergja +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1343', :eg_version); -- khuckins/christine-burns/mmorgan CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.lp1396764-hours-of-operation-note.sql b/Open-ILS/src/sql/Pg/upgrade/1343.schema.hours-of-operation-note similarity index 76% rename from Open-ILS/src/sql/Pg/upgrade/xxxx.schema.lp1396764-hours-of-operation-note.sql rename to Open-ILS/src/sql/Pg/upgrade/1343.schema.hours-of-operation-note index c8555d9834..90de8ba3f5 100644 --- a/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.lp1396764-hours-of-operation-note.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1343.schema.hours-of-operation-note @@ -1,13 +1,13 @@ -BEGIN; - -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); - -ALTER TABLE actor.hours_of_operation - ADD COLUMN dow_0_note TEXT, - ADD COLUMN dow_1_note TEXT, - ADD COLUMN dow_2_note TEXT, - ADD COLUMN dow_3_note TEXT, - ADD COLUMN dow_4_note TEXT, - ADD COLUMN dow_5_note TEXT, - ADD COLUMN dow_6_note TEXT; -COMMIT; \ No newline at end of file +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('1343', :eg_version); + +ALTER TABLE actor.hours_of_operation + ADD COLUMN dow_0_note TEXT, + ADD COLUMN dow_1_note TEXT, + ADD COLUMN dow_2_note TEXT, + ADD COLUMN dow_3_note TEXT, + ADD COLUMN dow_4_note TEXT, + ADD COLUMN dow_5_note TEXT, + ADD COLUMN dow_6_note TEXT; +COMMIT; -- 2.11.0