From c991003180a2538c2f38ef6ebbc794853aa6f8b9 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Tue, 13 Jul 2021 12:09:57 -0400 Subject: [PATCH] LP#1718782: stamp DB update Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../sql/Pg/upgrade/1270.data.srce_fixed_field.sql | 22 ++++++++++++++++++++ .../sql/Pg/upgrade/XXXX.data.srce_fixed_field.sql | 22 -------------------- 3 files changed, 23 insertions(+), 23 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/1270.data.srce_fixed_field.sql delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.srce_fixed_field.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 7cfdd3d..e6842d0 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 ('1269', :eg_version); -- sandbergja/tmcanna/gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1270', :eg_version); -- sandbergja/mllewellyn/gmcharlt CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/1270.data.srce_fixed_field.sql b/Open-ILS/src/sql/Pg/upgrade/1270.data.srce_fixed_field.sql new file mode 100644 index 0000000..4bcb3f2 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/1270.data.srce_fixed_field.sql @@ -0,0 +1,22 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('1270', :eg_version); + +INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'BKS', 39, 1, ' '); +INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'COM', 39, 1, ' '); +INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'MAP', 39, 1, ' '); +INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'MIX', 39, 1, ' '); +INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'REC', 39, 1, ' '); +INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'SCO', 39, 1, ' '); +INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'SER', 39, 1, ' '); +INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'VIS', 39, 1, ' '); + + +INSERT INTO config.record_attr_definition (name,label,fixed_field) values ('srce','Srce','Srce'); + +INSERT INTO config.coded_value_map (id, ctype, code, value) VALUES +(1750, 'srce', ' ', oils_i18n_gettext('1750', 'National bibliographic agency', 'ccvm', 'value')), +(1751, 'srce', 'c', oils_i18n_gettext('1751', 'Cooperative cataloging program', 'ccvm', 'value')), +(1752, 'srce', 'd', oils_i18n_gettext('1752', 'Other', 'ccvm', 'value')); + +COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.srce_fixed_field.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.srce_fixed_field.sql deleted file mode 100644 index 0d6ad97..0000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.srce_fixed_field.sql +++ /dev/null @@ -1,22 +0,0 @@ -BEGIN; - -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); - -INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'BKS', 39, 1, ' '); -INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'COM', 39, 1, ' '); -INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'MAP', 39, 1, ' '); -INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'MIX', 39, 1, ' '); -INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'REC', 39, 1, ' '); -INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'SCO', 39, 1, ' '); -INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'SER', 39, 1, ' '); -INSERT INTO config.marc21_ff_pos_map (fixed_field, tag, rec_type,start_pos, length, default_val) VALUES ('Srce', '008', 'VIS', 39, 1, ' '); - - -INSERT INTO config.record_attr_definition (name,label,fixed_field) values ('srce','Srce','Srce'); - -INSERT INTO config.coded_value_map (id, ctype, code, value) VALUES -(1750, 'srce', ' ', oils_i18n_gettext('1750', 'National bibliographic agency', 'ccvm', 'value')), -(1751, 'srce', 'c', oils_i18n_gettext('1751', 'Cooperative cataloging program', 'ccvm', 'value')), -(1752, 'srce', 'd', oils_i18n_gettext('1752', 'Other', 'ccvm', 'value')); - -COMMIT; -- 1.7.2.5