From c7c0a9d745f15b16812da97943cf9be0c06bf535 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Fri, 8 Mar 2019 14:33:44 -0500 Subject: [PATCH] LP#1780639 - stamping upgrade script Signed-off-by: Chris Sharp --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../sql/Pg/upgrade/1159.data.marc21-tag-758.sql | 54 ++++++++++++++++++++ .../src/sql/Pg/upgrade/XXX.data.marc21-tag-758.sql | 54 -------------------- 3 files changed, 55 insertions(+), 55 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/1159.data.marc21-tag-758.sql delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXX.data.marc21-tag-758.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 4607359..06969d1 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 ('1158', :eg_version); -- bshum/stompro/csharp +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1159', :eg_version); -- cesardv/willis/csharp CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/1159.data.marc21-tag-758.sql b/Open-ILS/src/sql/Pg/upgrade/1159.data.marc21-tag-758.sql new file mode 100644 index 0000000..8bd1e68 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/1159.data.marc21-tag-758.sql @@ -0,0 +1,54 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('1159', :eg_version); + +INSERT INTO config.marc_field(marc_format, marc_record_type, tag, name, description, + fixed_field, repeatable, mandatory, hidden) +VALUES (1, 'biblio', '758', $$Resource Identifier$$, $$An identifier for a resource that is either the resource described in the bibliographic record or a resource to which it is related. Resources thus identified may include, but are not limited to, FRBR works, expressions, manifestations, and items. The field does not prescribe a particular content standard or data model.$$, +FALSE, TRUE, FALSE, FALSE); +INSERT INTO config.record_attr_definition(name, label) +VALUES ('marc21_biblio_758_ind_1', 'MARC 21 biblio field 758 indicator position 1'); +INSERT INTO config.coded_value_map(ctype, code, value, opac_visible, is_simple) +VALUES ('marc21_biblio_758_ind_1', '#', $$Undefined$$, FALSE, TRUE); +INSERT INTO config.record_attr_definition(name, label) +VALUES ('marc21_biblio_758_ind_2', 'MARC 21 biblio field 758 indicator position 2'); +INSERT INTO config.coded_value_map(ctype, code, value, opac_visible, is_simple) +VALUES ('marc21_biblio_758_ind_2', '#', $$Undefined$$, FALSE, TRUE); +INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, + repeatable, mandatory, hidden) +VALUES (1, 'biblio', '758', 'a', $$Label$$, +FALSE, FALSE, FALSE); +INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, + repeatable, mandatory, hidden) +VALUES (1, 'biblio', '758', 'i', $$Relationship information$$, +TRUE, FALSE, FALSE); +INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, + repeatable, mandatory, hidden) +VALUES (1, 'biblio', '758', '0', $$Authority record control number or standard number$$, +TRUE, FALSE, FALSE); +INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, + repeatable, mandatory, hidden) +VALUES (1, 'biblio', '758', '1', $$Real World Object URI$$, +TRUE, FALSE, FALSE); +INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, + repeatable, mandatory, hidden) +VALUES (1, 'biblio', '758', '3', $$Materials specified$$, +FALSE, FALSE, FALSE); +INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, + repeatable, mandatory, hidden) +VALUES (1, 'biblio', '758', '4', $$Relationship$$, +TRUE, FALSE, FALSE); +INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, + repeatable, mandatory, hidden) +VALUES (1, 'biblio', '758', '5', $$Institution to which field applies$$, +FALSE, FALSE, FALSE); +INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, + repeatable, mandatory, hidden) +VALUES (1, 'biblio', '758', '6', $$Linkage$$, +FALSE, FALSE, FALSE); +INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, + repeatable, mandatory, hidden) +VALUES (1, 'biblio', '758', '8', $$Field link and sequence number$$, +TRUE, FALSE, FALSE); + +-- COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXX.data.marc21-tag-758.sql b/Open-ILS/src/sql/Pg/upgrade/XXX.data.marc21-tag-758.sql deleted file mode 100644 index 7071c5e..0000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXX.data.marc21-tag-758.sql +++ /dev/null @@ -1,54 +0,0 @@ -BEGIN; - ---SELECT evergreen.upgrade_deps_block_check('XXX', :eg_version); - -INSERT INTO config.marc_field(marc_format, marc_record_type, tag, name, description, - fixed_field, repeatable, mandatory, hidden) -VALUES (1, 'biblio', '758', $$Resource Identifier$$, $$An identifier for a resource that is either the resource described in the bibliographic record or a resource to which it is related. Resources thus identified may include, but are not limited to, FRBR works, expressions, manifestations, and items. The field does not prescribe a particular content standard or data model.$$, -FALSE, TRUE, FALSE, FALSE); -INSERT INTO config.record_attr_definition(name, label) -VALUES ('marc21_biblio_758_ind_1', 'MARC 21 biblio field 758 indicator position 1'); -INSERT INTO config.coded_value_map(ctype, code, value, opac_visible, is_simple) -VALUES ('marc21_biblio_758_ind_1', '#', $$Undefined$$, FALSE, TRUE); -INSERT INTO config.record_attr_definition(name, label) -VALUES ('marc21_biblio_758_ind_2', 'MARC 21 biblio field 758 indicator position 2'); -INSERT INTO config.coded_value_map(ctype, code, value, opac_visible, is_simple) -VALUES ('marc21_biblio_758_ind_2', '#', $$Undefined$$, FALSE, TRUE); -INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, - repeatable, mandatory, hidden) -VALUES (1, 'biblio', '758', 'a', $$Label$$, -FALSE, FALSE, FALSE); -INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, - repeatable, mandatory, hidden) -VALUES (1, 'biblio', '758', 'i', $$Relationship information$$, -TRUE, FALSE, FALSE); -INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, - repeatable, mandatory, hidden) -VALUES (1, 'biblio', '758', '0', $$Authority record control number or standard number$$, -TRUE, FALSE, FALSE); -INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, - repeatable, mandatory, hidden) -VALUES (1, 'biblio', '758', '1', $$Real World Object URI$$, -TRUE, FALSE, FALSE); -INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, - repeatable, mandatory, hidden) -VALUES (1, 'biblio', '758', '3', $$Materials specified$$, -FALSE, FALSE, FALSE); -INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, - repeatable, mandatory, hidden) -VALUES (1, 'biblio', '758', '4', $$Relationship$$, -TRUE, FALSE, FALSE); -INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, - repeatable, mandatory, hidden) -VALUES (1, 'biblio', '758', '5', $$Institution to which field applies$$, -FALSE, FALSE, FALSE); -INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, - repeatable, mandatory, hidden) -VALUES (1, 'biblio', '758', '6', $$Linkage$$, -FALSE, FALSE, FALSE); -INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, description, - repeatable, mandatory, hidden) -VALUES (1, 'biblio', '758', '8', $$Field link and sequence number$$, -TRUE, FALSE, FALSE); - --- COMMIT; -- 1.7.2.5