From 0ec46f4a3f67612c2b6cca24b6aa6cbf8b27124e Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Fri, 27 Dec 2019 10:09:22 -0300 Subject: [PATCH] Bug 24312: Update MARC21 frameworks to Updates 28+29 (May and November 2019) MARC21 format changes Bibliographic ------------- Update 28 (May 2019) New subfield f in 540 New subfield g in 506,540 New subfield q in 506,540 New subfield 2 in 540 New subfield 2 in 100,110,111,130,240, 700,710,711,730,758 800,810,811,830 New subfield 7 in 856 New code b in 007/01 Sound Recording Update 29 (November 2019) New field 688 New subfield i in 041 New subfield t in 041 New subfield g in 751 Renamed subfield g in 041 Authority --------- Update 28 (May 2019) New subfield 0 and 1 in 024 Renamed subfield 2 in 024 New subfield 7 in 856 Update 29 (November 2019) No changes To test: 1) Remove all your frameworks 2) Check mandatory bibliographic and authority files load without problem 3) Check new fields/subfields --- .../mandatory/authorities_normal_marc21.sql | 7 +++- .../mandatory/marc21_framework_DEFAULT.sql | 39 ++++++++++++++++++- .../prog/en/data/marc21_field_007.xml | 1 + 3 files changed, 43 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index f605303a78..2033ed376e 100644 --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -1,7 +1,7 @@ -- ******************************************************* -- KOHA MARC 21 STANDARD DEFAULT AUTHORITY FRAMEWORKS -- --- Revised to Update No. 27 (November 2018) +-- Revised to Update No. 29 (November 2019) -- ******************************************************* -- ****************************************************** @@ -311,7 +311,9 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '024', 'd', 'Additional codes following the standard number or code', 'Additional codes following the standard number or code', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '024', 'q', 'Qualifying information', 'Qualifying information', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '024', 'z', 'Canceled/invalid standard number or code', 'Canceled/invalid standard number or code', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '024', '2', 'Source of number or code', 'Source of number or code', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '024', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '024', '1', 'Real World Object URI', 'Real World Object URI', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '024', '2', 'Source', 'Source', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '024', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '024', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '031', 'a', 'Number of work', 'Number of work', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -2047,6 +2049,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '856', '2', 'Access method', 'Access method', 0, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '856', '3', 'Materials specified', 'Materials specified', 0, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '856', '6', 'Linkage', 'Linkage', 0, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '856', '7', 'Access status', 'Access status', 0, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '856', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '880', 'a', 'a', 'a', 1, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '880', 'b', 'b', 'b', 1, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''), diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index a8db66ec67..56f33d7309 100644 --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -7,7 +7,7 @@ -- guided by Paul POULAIN -- by thd for LibLime -- --- Revised to Update No. 27 (November 2018) +-- Revised to Update No. 29 (November 2019) -- ************************************************************* @@ -394,6 +394,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, ('657', 'INDEX TERM--FUNCTION', 'INDEX TERM--FUNCTION', 1, 0, NULL, ''), ('658', 'INDEX TERM--CURRICULUM OBJECTIVE', 'INDEX TERM--CURRICULUM OBJECTIVE', 1, 0, NULL, ''), ('662', 'SUBJECT ADDED ENTRY--HIERARCHICAL PLACE NAME', 'SUBJECT ADDED ENTRY--HIERARCHICAL PLACE NAME', 1, 0, NULL, ''), + ('688', 'SUBJECT ADDED ENTRY-TYPE OF ENTITY UNSPECIFIED', 'SUBJECT ADDED ENTRY-TYPE OF ENTITY UNSPECIFIED', 1, 0, NULL, ''), ('690', 'LOCAL SUBJECT ADDED ENTRY--TOPICAL TERM (OCLC, RLIN)', 'LOCAL SUBJECT ADDED ENTRY--TOPICAL TERM (OCLC, RLIN)', 1, 0, '', ''), ('691', 'LOCAL SUBJECT ADDED ENTRY--GEOGRAPHIC NAME (RLIN)', 'LOCAL SUBJECT ADDED ENTRY--GEOGRAPHIC NAME (RLIN)', 1, 0, '', ''), ('696', 'LOCAL SUBJECT ADDED ENTRY--PERSONAL NAME (RLIN)', 'LOCAL SUBJECT ADDED ENTRY--PERSONAL NAME (RLIN)', 1, 0, '', ''), @@ -712,8 +713,9 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), ('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), + ('041', 'g', 'Language code of accompanying material other than librettos and transcripts', 'Language code of accompanying material other than librettos and transcripts', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), ('041', 'h', 'Language code of original', 'Language code of original', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), + ('041', 'i', 'Language code of intertitles', 'Language code of intertitles', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), ('041', 'j', 'Language code of subtitles', 'Language code of subtitles', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), ('041', 'k', 'Language code of intermediate translations', 'Language code of intermediate translations', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), ('041', 'm', 'Language code of original accompanying materials other than librettos', 'Language code of original accompanying materials other than librettos', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), @@ -721,6 +723,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('041', 'p', 'Language code of captions', 'Language code of captions', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), ('041', 'q', 'Language code of accessible audio', 'Language code of accessible audio', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), ('041', 'r', 'Language code of accessible visual language', 'Language code of accessible visual language', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), + ('041', 't', 'Language code of accompanying transcripts for audiovisual materials', 'Language code of accompanying transcripts for audiovisual materials', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), ('042', 'a', 'Authentication code', 'Authentication code', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), ('043', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), ('043', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), @@ -927,6 +930,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('099', 'f', 'Filing suffix', 'Filing suffix', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('100', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('100', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), + ('100', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('100', '4', 'Relationship', 'Relationship', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL), ('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL), @@ -948,6 +952,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('100', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL), ('110', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('110', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), + ('110', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('110', '4', 'Relationship', 'Relationship', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('110', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('110', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), @@ -967,6 +972,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('110', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('111', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('111', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), + ('111', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('111', '4', 'Relationship', 'Relationship', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('111', '6', 'Linkage', 'Linkage', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('111', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -988,6 +994,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('111', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('130', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('130', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), + ('130', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('130', '6', 'Linkage', 'Linkage', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('130', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('130', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, -5, '', '', '', NULL), @@ -1022,6 +1029,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('222', 'b', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, '', '', '', NULL), ('240', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('240', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('240', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL), @@ -1706,6 +1714,8 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('506', 'd', 'Authorized users', 'Authorized users', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('506', 'e', 'Authorization', 'Authorization', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('506', 'f', 'Standardized terminology for access restriction', 'Standardized terminology for access restriction', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), + ('506', 'g', 'Availability date', 'Availability date', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), + ('506', 'q', 'Supplying agency', 'Supplying agency', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('506', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -6, '', '', '', NULL), ('507', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('507', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), @@ -1878,6 +1888,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('538', 'a', 'System details note', 'System details note', 0, 0, '', 5, '', '', '', NULL, -1, '', '', '', NULL), ('538', 'i', 'Display text', 'Display text', 0, 0, '', 5, '', '', '', NULL, -1, '', '', '', NULL), ('538', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -1, '', '', '', NULL), + ('540', '2', 'Source of term', 'Source of term', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('540', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('540', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('540', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), @@ -1886,6 +1897,9 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('540', 'b', 'Jurisdiction', 'Jurisdiction', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('540', 'c', 'Authorization', 'Authorization', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('540', 'd', 'Authorized users', 'Authorized users', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), + ('540', 'f', 'Use and reproduction rights', 'Use and reproduction rights', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), + ('540', 'g', 'Availability date', 'Availability date', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), + ('540', 'q', 'Supplying agency', 'Supplying agency', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('540', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -6, '', '', '', NULL), ('541', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('541', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), @@ -2343,6 +2357,16 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('662', 'f', 'City subsection', 'City subsection', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL), ('662', 'g', 'Other nonjurisdictional geographic region and feature', 'Other nonjurisdictional geographic region and feature', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL), ('662', 'h', 'Extraterrestrial area', 'Extraterrestrial area', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL), + ('688', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), + ('688', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), + ('688', '2', 'Source of name, title, or term', 'Source of name, title, or term', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), + ('688', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), + ('688', '4', 'Relationship', 'Relationship', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), + ('688', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), + ('688', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), + ('688', 'a', 'Name, title, or term', 'Name, title, or term', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), + ('688', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), + ('688', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), ('690', '%', '% (RLIN)', '% (RLIN)', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), ('690', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL), ('690', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), @@ -2482,6 +2506,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('699', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('700', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('700', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('700', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), @@ -2529,6 +2554,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('705', 't', 'Title of a work', 'Title of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('710', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('710', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('710', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('710', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('710', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('710', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), @@ -2557,6 +2583,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('710', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('711', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('711', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('711', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('711', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('711', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('711', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2604,6 +2631,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('720', 'e', 'Relator term', 'Relator term', 1, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL), ('730', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('730', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('730', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('730', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('730', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('730', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), @@ -2642,6 +2670,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('751', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('751', 'a', 'Geographic name', 'Geographic name', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('751', 'e', 'Relator term', 'Relator term', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('751', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('752', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('752', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('752', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2684,6 +2713,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('755', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('758', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('758', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('758', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('758', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('758', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('758', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), @@ -3185,6 +3215,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('799', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('800', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('800', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('800', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('800', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('800', '4', 'Relationship', 'Relationship', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL), ('800', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), @@ -3217,6 +3248,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('800', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('810', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('810', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('810', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('810', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('810', '4', 'Relationship', 'Relationship', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL), ('810', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), @@ -3247,6 +3279,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('810', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('811', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('811', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('811', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('811', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('811', '4', 'Relationship', 'Relationship', 1, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL), ('811', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), @@ -3276,6 +3309,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('811', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('830', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('830', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('830', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('830', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('830', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('830', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), @@ -3448,6 +3482,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('856', '2', 'Access method', 'Access method', 0, 0, '', 8, '', '', '', 0, -6, '', '', '', NULL), ('856', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', 0, 0, '', '', '', NULL), ('856', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', 0, -6, '', '', '', NULL), + ('856', '7', 'Access status', 'Access status', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('856', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', 0, -6, '', '', '', NULL), ('856', 'a', 'Host name', 'Host name', 1, 0, '', 8, '', '', '', 0, -1, '', '', '', NULL), ('856', 'b', 'Access number', 'Access number', 1, 0, '', 8, '', '', '', 0, -1, '', '', '', NULL), diff --git a/koha-tmpl/intranet-tmpl/prog/en/data/marc21_field_007.xml b/koha-tmpl/intranet-tmpl/prog/en/data/marc21_field_007.xml index 2db665b813..fe956b357e 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/data/marc21_field_007.xml +++ b/koha-tmpl/intranet-tmpl/prog/en/data/marc21_field_007.xml @@ -932,6 +932,7 @@ Sound recording Specific material designationSpecial class of sound recording to which the item belongs (e.g., a cylinder). + Belt Sound disc Cylinder Sound cartridge -- 2.17.1