From 1eba9cfd2fc6eab3c886b14f49a0fb744a66f4c0 Mon Sep 17 00:00:00 2001 From: thd Date: Fri, 8 Sep 2006 12:35:24 +0000 Subject: [PATCH] Corrected some subfield visibility values and improved the ease of understanding for some librarian's field labels for sound recordings. --- misc/asmp_marc21_bib_framework.sql | 82 +++++++++++++++--------------- 1 file changed, 41 insertions(+), 41 deletions(-) diff --git a/misc/asmp_marc21_bib_framework.sql b/misc/asmp_marc21_bib_framework.sql index ee33b9c660..9e31d2e8f7 100644 --- a/misc/asmp_marc21_bib_framework.sql +++ b/misc/asmp_marc21_bib_framework.sql @@ -2,7 +2,7 @@ -- ASMP KOHA MARC 21 BIBLIOGRAPHIC FRAMEWORKS -- POST-INSTALLATION SCRIPT -- --- PRETEST VERSION 0.0.7 +-- PRETEST VERSION 0.0.8 -- 2006-09-07 -- -- drafted @@ -16,7 +16,7 @@ -- KOHA MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK -- POST-INSTALLATION SCRIPT -- --- PRETEST VERSION 0.1.5 +-- PRETEST VERSION 0.1.6 -- 2006-09-07 -- -- original default requiring greater user customisation @@ -34,8 +34,8 @@ -- ********************************************************************* -- -- STOP, DO NOT PROCEED FURTHER WITHOUT FIRST DUMPIMPING --- marc_tag_structure AND marc_subfield_structure TABLES IF NOT THE --- ENTIRE KOHA DATABASE. +-- biblio_framework, marc_tag_structure, AND marc_subfield_structure +-- TABLES IF NOT THE ENTIRE KOHA DATABASE. -- -- However, if you have a Koha installation with no bibliographic -- framework modifications or no records yet then this script should do @@ -898,11 +898,11 @@ INSERT INTO `marc_subfield_structure` VALUES ('041', '8', 'Field link and sequen INSERT INTO `marc_subfield_structure` VALUES ('041', 'a', 'Language code of text/sound track or separate title', 'Language code of text/sound track or separate title', 1, 0, '', 0, '', '', '', 0, -1, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'b', 'Language code of summary or abstract/overprinted title or subtitle', 'Language code of summary or abstract/overprinted title or subtitle', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'c', 'Languages of separate titles (VM) [OBSOLETE] ; Languages of available translation (SE) [OBSOLETE]', 'Languages of separate titles (VM) [OBSOLETE] ; Languages of available translation (SE) [OBSOLETE]', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -1, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -1, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -1, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('042', 'a', 'Authentication code', 'Authentication code', 0, 0, '', 0, '', '', '', 0, -6, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '2', 'Source of local code', 'Source of local code', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', ''); @@ -5071,8 +5071,8 @@ INSERT INTO `marc_subfield_structure` VALUES ('041', 'c', 'Languages of separate INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('042', 'a', 'Authentication code', 'Authentication code', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '2', 'Source of local code', 'Source of local code', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); @@ -9238,11 +9238,11 @@ INSERT INTO `marc_subfield_structure` VALUES ('041', '8', 'Field link and sequen INSERT INTO `marc_subfield_structure` VALUES ('041', 'a', 'Language code of text/sound track or separate title', 'Language code of text/sound track or separate title', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'b', 'Language code of summary or abstract/overprinted title or subtitle', 'Language code of summary or abstract/overprinted title or subtitle', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'c', 'Languages of separate titles (VM) [OBSOLETE] ; Languages of available translation (SE) [OBSOLETE]', 'Languages of separate titles (VM) [OBSOLETE] ; Languages of available translation (SE) [OBSOLETE]', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_COMPUTER_FILES', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_COMPUTER_FILES', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('042', 'a', 'Authentication code', 'Authentication code', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '2', 'Source of local code', 'Source of local code', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); @@ -9474,14 +9474,14 @@ INSERT INTO `marc_subfield_structure` VALUES ('210', '8', 'Field link and sequen INSERT INTO `marc_subfield_structure` VALUES ('210', 'a', 'Abbreviated title', 'Abbreviated title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('210', 'b', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('211', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('211', 'a', 'Acronym or shortened title', 'Acronym or shortened title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_COMPUTER_FILES', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('211', 'a', 'Acronym or shortened title', 'Acronym or shortened title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('212', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('212', 'a', 'Variant access title', 'Variant access title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('214', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('214', 'a', 'Augmented title', 'Augmented title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('222', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('222', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('222', 'a', 'Key title', 'Key title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('222', 'a', 'Key title', 'Key title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('222', 'b', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); @@ -9497,7 +9497,7 @@ INSERT INTO `marc_subfield_structure` VALUES ('240', 'm', 'Medium of performance INSERT INTO `marc_subfield_structure` VALUES ('240', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('240', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, '', 2, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('240', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('240', 'r', 'Key for music', 'Key for music', 0, 0, '', 2, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('240', 'r', 'Key for music', 'Key for music', 0, 0, '', 2, '', '', '', 0, -1, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('240', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', 0, -1, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('241', 'a', 'Romanized title', 'Romanized title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('241', 'h', 'Medium', 'Medium', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); @@ -9526,7 +9526,7 @@ INSERT INTO `marc_subfield_structure` VALUES ('243', 'm', 'Medium of performance INSERT INTO `marc_subfield_structure` VALUES ('243', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('243', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, '', 2, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('243', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('243', 'r', 'Key for music', 'Key for music', 0, 0, '', 2, '', '', '', 0, -6, 'ASMP_COMPUTER_FILES', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('243', 'r', 'Key for music', 'Key for music', 0, 0, '', 2, '', '', '', 0, -1, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('243', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', 0, -1, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, 'ASMP_COMPUTER_FILES', '', ''); @@ -12958,8 +12958,8 @@ INSERT INTO `marc_tag_structure` VALUES ('092', 'LOCALLY ASSIGNED DEWEY CALL NUM INSERT INTO `marc_tag_structure` VALUES ('096', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CALL NUMBER (OCLC)', 1, 0, '', 'ASMP_SOUND_RECORDINGS'); INSERT INTO `marc_tag_structure` VALUES ('098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, '', 'ASMP_SOUND_RECORDINGS'); INSERT INTO `marc_tag_structure` VALUES ('099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, '', 'ASMP_SOUND_RECORDINGS'); -INSERT INTO `marc_tag_structure` VALUES ('100', 'MAIN ENTRY--COMPOSER/PERSONAL NAME', 'MAIN ENTRY--PERSONAL NAME', 0, 0, NULL, 'ASMP_SOUND_RECORDINGS'); -INSERT INTO `marc_tag_structure` VALUES ('110', 'MAIN ENTRY--CORPORATE NAME', 'MAIN ENTRY--CORPORATE NAME', 0, 0, NULL, 'ASMP_SOUND_RECORDINGS'); +INSERT INTO `marc_tag_structure` VALUES ('100', 'MAIN ENTRY--COMPOSER/MAIN PERFORMER/PERSONAL NAME', 'MAIN ENTRY--PERSONAL NAME', 0, 0, NULL, 'ASMP_SOUND_RECORDINGS'); +INSERT INTO `marc_tag_structure` VALUES ('110', 'MAIN ENTRY--PERFORMING GROUP/CORPORATE NAME', 'MAIN ENTRY--CORPORATE NAME', 0, 0, NULL, 'ASMP_SOUND_RECORDINGS'); INSERT INTO `marc_tag_structure` VALUES ('111', 'MAIN ENTRY--MEETING NAME', 'MAIN ENTRY--MEETING NAME', 0, 0, NULL, 'ASMP_SOUND_RECORDINGS'); INSERT INTO `marc_tag_structure` VALUES ('130', 'MAIN ENTRY--UNIFORM TITLE', 'MAIN ENTRY--UNIFORM TITLE', 0, 0, NULL, 'ASMP_SOUND_RECORDINGS'); INSERT INTO `marc_tag_structure` VALUES ('210', 'ABBREVIATED TITLE', 'ABBREVIATED TITLE', 1, 0, NULL, 'ASMP_SOUND_RECORDINGS'); @@ -13408,11 +13408,11 @@ INSERT INTO `marc_subfield_structure` VALUES ('041', '8', 'Field link and sequen INSERT INTO `marc_subfield_structure` VALUES ('041', 'a', 'Language code of text/sound track or separate title', 'Language code of text/sound track or separate title', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'b', 'Language code of summary or abstract/overprinted title or subtitle', 'Language code of summary or abstract/overprinted title or subtitle', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'c', 'Languages of separate titles (VM) [OBSOLETE] ; Languages of available translation (SE) [OBSOLETE]', 'Languages of separate titles (VM) [OBSOLETE] ; Languages of available translation (SE) [OBSOLETE]', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('042', 'a', 'Authentication code', 'Authentication code', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '2', 'Source of local code', 'Source of local code', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); @@ -13667,7 +13667,7 @@ INSERT INTO `marc_subfield_structure` VALUES ('240', 'm', 'Medium of performance INSERT INTO `marc_subfield_structure` VALUES ('240', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('240', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, '', 2, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('240', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('240', 'r', 'Key for music', 'Key for music', 0, 0, '', 2, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('240', 'r', 'Key for music', 'Key for music', 0, 0, '', 2, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('240', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('241', 'a', 'Romanized title', 'Romanized title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('241', 'h', 'Medium', 'Medium', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); @@ -13696,7 +13696,7 @@ INSERT INTO `marc_subfield_structure` VALUES ('243', 'm', 'Medium of performance INSERT INTO `marc_subfield_structure` VALUES ('243', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('243', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, '', 2, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('243', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('243', 'r', 'Key for music', 'Key for music', 0, 0, '', 2, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('243', 'r', 'Key for music', 'Key for music', 0, 0, '', 2, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('243', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); @@ -17577,11 +17577,11 @@ INSERT INTO `marc_subfield_structure` VALUES ('041', '8', 'Field link and sequen INSERT INTO `marc_subfield_structure` VALUES ('041', 'a', 'Language code of text/sound track or separate title', 'Language code of text/sound track or separate title', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'b', 'Language code of summary or abstract/overprinted title or subtitle', 'Language code of summary or abstract/overprinted title or subtitle', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'c', 'Languages of separate titles (VM) [OBSOLETE] ; Languages of available translation (SE) [OBSOLETE]', 'Languages of separate titles (VM) [OBSOLETE] ; Languages of available translation (SE) [OBSOLETE]', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('042', 'a', 'Authentication code', 'Authentication code', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '2', 'Source of local code', 'Source of local code', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); @@ -21750,8 +21750,8 @@ INSERT INTO `marc_subfield_structure` VALUES ('041', 'c', 'Languages of separate INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_ARTIFACTS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_ARTIFACTS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_ARTIFACTS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_ARTIFACTS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_ARTIFACTS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_ARTIFACTS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_ARTIFACTS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('042', 'a', 'Authentication code', 'Authentication code', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_ARTIFACTS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '2', 'Source of local code', 'Source of local code', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_ARTIFACTS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_ARTIFACTS', '', ''); @@ -25917,11 +25917,11 @@ INSERT INTO `marc_subfield_structure` VALUES ('041', '8', 'Field link and sequen INSERT INTO `marc_subfield_structure` VALUES ('041', 'a', 'Language code of text/sound track or separate title', 'Language code of text/sound track or separate title', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_KITS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'b', 'Language code of summary or abstract/overprinted title or subtitle', 'Language code of summary or abstract/overprinted title or subtitle', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_KITS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'c', 'Languages of separate titles (VM) [OBSOLETE] ; Languages of available translation (SE) [OBSOLETE]', 'Languages of separate titles (VM) [OBSOLETE] ; Languages of available translation (SE) [OBSOLETE]', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_KITS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_KITS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_KITS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_KITS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_KITS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_KITS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_KITS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_KITS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_KITS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_KITS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('042', 'a', 'Authentication code', 'Authentication code', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_KITS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '2', 'Source of local code', 'Source of local code', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_KITS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_KITS', '', ''); @@ -30088,10 +30088,10 @@ INSERT INTO `marc_subfield_structure` VALUES ('041', 'a', 'Language code of text INSERT INTO `marc_subfield_structure` VALUES ('041', 'b', 'Language code of summary or abstract/overprinted title or subtitle', 'Language code of summary or abstract/overprinted title or subtitle', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_INTEGRATING_RESOURCES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'c', 'Languages of separate titles (VM) [OBSOLETE] ; Languages of available translation (SE) [OBSOLETE]', 'Languages of separate titles (VM) [OBSOLETE] ; Languages of available translation (SE) [OBSOLETE]', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_INTEGRATING_RESOURCES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_INTEGRATING_RESOURCES', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_INTEGRATING_RESOURCES', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_INTEGRATING_RESOURCES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_INTEGRATING_RESOURCES', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_INTEGRATING_RESOURCES', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_INTEGRATING_RESOURCES', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_INTEGRATING_RESOURCES', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_INTEGRATING_RESOURCES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('042', 'a', 'Authentication code', 'Authentication code', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_INTEGRATING_RESOURCES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '2', 'Source of local code', 'Source of local code', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_INTEGRATING_RESOURCES', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_INTEGRATING_RESOURCES', '', ''); @@ -34258,8 +34258,8 @@ INSERT INTO `marc_subfield_structure` VALUES ('041', 'c', 'Languages of separate INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SERIALS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SERIALS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SERIALS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SERIALS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SERIALS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_SERIALS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_SERIALS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('042', 'a', 'Authentication code', 'Authentication code', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_SERIALS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '2', 'Source of local code', 'Source of local code', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SERIALS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_SERIALS', '', ''); -- 2.39.2