From e7042035792377649f5862b8adce7820f29aebf7 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Fri, 8 Mar 2019 14:19:02 -0500 Subject: [PATCH] LP#1759238: stamping upgrade script Signed-off-by: Chris Sharp --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../Pg/upgrade/1158.data.fix-typo-in-seed-data.sql | 11 +++++++++++ .../Pg/upgrade/XXXX.data.fix-typo-in-seed-data.sql | 11 ----------- 3 files changed, 12 insertions(+), 12 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/1158.data.fix-typo-in-seed-data.sql delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix-typo-in-seed-data.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index b6f2665..4607359 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 ('1157', :eg_version); -- berick/sandbergja/Dyrcona +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1158', :eg_version); -- bshum/stompro/csharp CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/1158.data.fix-typo-in-seed-data.sql b/Open-ILS/src/sql/Pg/upgrade/1158.data.fix-typo-in-seed-data.sql new file mode 100644 index 0000000..294a990 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/1158.data.fix-typo-in-seed-data.sql @@ -0,0 +1,11 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('1158', :eg_version); + +--LP#1759238: Fix typo in seed data for Physical Description + +UPDATE config.metabib_field + SET label = 'Physical Description' + WHERE id = 39 AND label = 'Physical Descrption'; + +COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix-typo-in-seed-data.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix-typo-in-seed-data.sql deleted file mode 100644 index 5e77249..0000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix-typo-in-seed-data.sql +++ /dev/null @@ -1,11 +0,0 @@ -BEGIN; - ---SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); - ---LP#1759238: Fix typo in seed data for Physical Description - -UPDATE config.metabib_field - SET label = 'Physical Description' - WHERE id = 39 AND label = 'Physical Descrption'; - -COMMIT; -- 1.7.2.5