From aa8faff980a11d5c6334fa715f34063e9fed8842 Mon Sep 17 00:00:00 2001 From: Cesar Velez Date: Tue, 4 Dec 2018 18:30:56 -0500 Subject: [PATCH] LP#1780639 - add marc tag identifier field 758 Add needed sql to seed data. Signed-off by: Cesar Velez Signed-off by: Beth Willis Signed-off-by: Chris Sharp --- Open-ILS/src/sql/Pg/960.data.marc21-tag-tables.sql | 50 ++++++++++++++++++++ .../src/sql/Pg/upgrade/XXX.data.marc21-tag-758.sql | 54 ++++++++++++++++++++++ 2 files changed, 104 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXX.data.marc21-tag-758.sql diff --git a/Open-ILS/src/sql/Pg/960.data.marc21-tag-tables.sql b/Open-ILS/src/sql/Pg/960.data.marc21-tag-tables.sql index ee03d59b20..16963c7dc7 100644 --- a/Open-ILS/src/sql/Pg/960.data.marc21-tag-tables.sql +++ b/Open-ILS/src/sql/Pg/960.data.marc21-tag-tables.sql @@ -8837,6 +8837,56 @@ INSERT INTO config.marc_subfield(marc_format, marc_record_type, tag, code, descr repeatable, mandatory, hidden) VALUES (1, 'biblio', '754', '8', $$Field link and sequence number$$, TRUE, FALSE, FALSE); + +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); + INSERT INTO config.marc_field(marc_format, marc_record_type, tag, name, description, fixed_field, repeatable, mandatory, hidden) VALUES (1, 'biblio', '760', $$Main Series Entry$$, $$Information concerning the related main series when the target item is a subseries (vertical relationship). When a note is generated from this field, the introductory phrase or may be generated based on the field tag for display.$$, 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 new file mode 100644 index 0000000000..7071c5ee3b --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXX.data.marc21-tag-758.sql @@ -0,0 +1,54 @@ +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; -- 2.11.0