koha-cvs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Koha-cvs] koha/misc asmp_marc21_bib_framework.sql [rel_2_2]


From: Thomas D
Subject: [Koha-cvs] koha/misc asmp_marc21_bib_framework.sql [rel_2_2]
Date: Fri, 08 Sep 2006 12:31:16 +0000

CVSROOT:        /sources/koha
Module name:    koha
Branch:         rel_2_2
Changes by:     Thomas D <thd>  06/09/08 12:31:14

Modified files:
        misc           : asmp_marc21_bib_framework.sql 

Log message:
        Corrected some subfield visibility values and improved the ease of 
        understanding for some librarian's field labels for sound recordings.

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/misc/asmp_marc21_bib_framework.sql?cvsroot=koha&only_with_tag=rel_2_2&r1=1.1.2.6&r2=1.1.2.7

Patches:
Index: asmp_marc21_bib_framework.sql
===================================================================
RCS file: /sources/koha/koha/misc/asmp_marc21_bib_framework.sql,v
retrieving revision 1.1.2.6
retrieving revision 1.1.2.7
diff -u -b -r1.1.2.6 -r1.1.2.7
--- asmp_marc21_bib_framework.sql       7 Sep 2006 22:43:39 -0000       1.1.2.6
+++ asmp_marc21_bib_framework.sql       8 Sep 2006 12:31:13 -0000       1.1.2.7
@@ -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', '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', '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', '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', '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', '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', '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 ('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', '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', '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', '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', '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', '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', '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', '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', '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', '', '');




reply via email to

[Prev in Thread] Current Thread [Next in Thread]