LP#1780639 - add marc tag identifier field 758

Add needed sql to seed data.

Signed-off by: Cesar Velez <cesar.velez@equinoxinitiative.org>
Signed-off by: Beth Willis <willis@noblenet.org>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>

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 ee03d59..16963c7 100644 (file)
--- 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 (file)
index 0000000..7071c5e
--- /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;