From f32605e5ad6cf8ece852af911e41260af5a3b59a Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Fri, 16 Sep 2011 11:29:19 -0400 Subject: [PATCH] Stamping db upgrade script for Fixed Field Cont/Conf typo/thinko Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...x_marc_conf_cont.sql => 0624.data.fix_marc_conf_cont.sql} | 12 ++++++++++++ 2 files changed, 13 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.fix_marc_conf_cont.sql => 0624.data.fix_marc_conf_cont.sql} (80%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 02f699e745..fe25d5ae96 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -86,7 +86,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 ('0623', :eg_version); -- Joseph Lewis / phasefx / tsbere +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0624', :eg_version); -- miker / tsbere CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.fix_marc_conf_cont.sql b/Open-ILS/src/sql/Pg/upgrade/0624.data.fix_marc_conf_cont.sql similarity index 80% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.fix_marc_conf_cont.sql rename to Open-ILS/src/sql/Pg/upgrade/0624.data.fix_marc_conf_cont.sql index 6a4f2f1e7f..d2e1afa822 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.fix_marc_conf_cont.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0624.data.fix_marc_conf_cont.sql @@ -1,3 +1,12 @@ +-- Evergreen DB patch 0624.data.fix_marc_conf_cont.sql +-- +-- +BEGIN; + + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0624', :eg_version); + -- Cont was typod as Conf. Update the old entries. UPDATE config.marc21_ff_pos_map SET fixed_field = 'Cont' WHERE fixed_field = 'Conf' AND length > 1; -- Conf thus didn't exist. Add it. @@ -5,3 +14,6 @@ INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, leng INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Conf', '006', 'SER', 11, 1, ' '); INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Conf', '008', 'BKS', 29, 1, ' '); INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Conf', '008', 'SER', 29, 1, ' '); + + +COMMIT; -- 2.11.0