From 1e8c8170154466ba4f8aba7b2cc44b38ddd79183 Mon Sep 17 00:00:00 2001 From: Julian Maurice Date: Thu, 23 Mar 2017 11:24:30 +0100 Subject: [PATCH] Bug 18309: UNIMARC update from IFLA - biblio UNIMARC complet (en) --- .../mandatory/unimarc_framework_DEFAULT.sql | 188 ++++++++++++++++++ 1 file changed, 188 insertions(+) diff --git a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql index 94ccaa9f96..d14ac4ca68 100644 --- a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql +++ b/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql @@ -90,6 +90,69 @@ insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` -- Current primary biblioitems Field/Subfields (942) +INSERT INTO authorised_value_categories( category_name ) VALUES +('unimarc_146a'), +('unimarc_181c'), +('unimarc_182a'), +('unimarc_182c'), +('unimarc_325h'); + +INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`, `lib_opac`, `imageurl`) VALUES +('unimarc_146a', 'a', 'vocal a cappella music', NULL, ''), +('unimarc_146a', 'b', 'instrumental music', NULL, ''), +('unimarc_146a', 'c', 'vocal and instrumental music', NULL, ''), +('unimarc_146a', 'd', 'electroacoustic music', NULL, ''), +('unimarc_146a', 'e', 'mixed media music (electroacoustic and other media)', NULL, ''), +('unimarc_146a', 'u', 'undefined, variable', NULL, ''), +('unimarc_146a', 'z', 'other', NULL, ''), +('unimarc_181c', 'crt', 'cartographic tactile image', NULL, ''), +('unimarc_181c', 'cod', 'computer dataset', NULL, ''), +('unimarc_181c', 'cop', 'computer program', NULL, ''), +('unimarc_181c', 'crd', 'cartographic dataset', NULL, ''), +('unimarc_181c', 'crf', 'cartographic three-dimensional form', NULL, ''), +('unimarc_181c', 'cri', 'cartographic image', NULL, ''), +('unimarc_181c', 'crm', 'cartographic moving image', NULL, ''), +('unimarc_181c', 'crn', 'cartographic tactile three-dimensional form', NULL, ''), +('unimarc_181c', 'ntm', 'notated music', NULL, ''), +('unimarc_181c', 'ntv', 'notated movement', NULL, ''), +('unimarc_181c', 'prm', 'performed music', NULL, ''), +('unimarc_181c', 'snd', 'sounds', NULL, ''), +('unimarc_181c', 'spw', 'spoken word', NULL, ''), +('unimarc_181c', 'sti', 'still image', NULL, ''), +('unimarc_181c', 'tcf', 'tactile three-dimensional form', NULL, ''), +('unimarc_181c', 'tci', 'tactile image', NULL, ''), +('unimarc_181c', 'tcm', 'tactile notated music', NULL, ''), +('unimarc_181c', 'tcn', 'tactile notated movement', NULL, ''), +('unimarc_181c', 'tct', 'tactile text', NULL, ''), +('unimarc_181c', 'tdf', 'three-dimensional form', NULL, ''), +('unimarc_181c', 'tdi', 'two-dimensional moving image', NULL, ''), +('unimarc_181c', 'tdm', 'three-dimensional moving image', NULL, ''), +('unimarc_181c', 'txt', 'text', NULL, ''), +('unimarc_181c', 'xxx', 'other', NULL, ''), +('unimarc_182a', 'a', 'audio', NULL, ''), +('unimarc_182a', 'b', 'electronic', NULL, ''), +('unimarc_182a', 'c', 'microform', NULL, ''), +('unimarc_182a', 'd', 'microscopic', NULL, ''), +('unimarc_182a', 'e', 'projected', NULL, ''), +('unimarc_182a', 'f', 'stereographic', NULL, ''), +('unimarc_182a', 'g', 'video', NULL, ''), +('unimarc_182a', 'm', 'multiple media', NULL, ''), +('unimarc_182a', 'n', 'unmediated', NULL, ''), +('unimarc_182a', 'z', 'other media', NULL, ''), +('unimarc_182c', 's', 'audio', NULL, ''), +('unimarc_182c', 'c', 'computer', NULL, ''), +('unimarc_182c', 'h', 'microform', NULL, ''), +('unimarc_182c', 'p', 'microscopic', NULL, ''), +('unimarc_182c', 'g', 'projected', NULL, ''), +('unimarc_182c', 'e', 'stereographic', NULL, ''), +('unimarc_182c', 'n', 'unmediated', NULL, ''), +('unimarc_182c', 'v', 'video', NULL, ''), +('unimarc_182c', 'x', 'other', NULL, ''), +('unimarc_182c', 'z', 'unspecified', NULL, ''), +('unimarc_325h', '0', 'Reproduction is not complete', NULL, ''), +('unimarc_325h', '1', 'Reproduction is complete', NULL, ''), +('unimarc_325h', '#', 'undetermined', NULL, ''); + INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('942', 'ADDED ENTRY ELEMENTS (KOHA)', 'ADDED ENTRY ELEMENTS (KOHA)', 0, 0, '', ''); @@ -206,6 +269,8 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('141', 'Coded Data Field: Copy Specific Attributes', 'Coded Data Field: Copy Specific Attributes', 1, 0, '', ''), ('145', 'Coded Data Field: Medium of Performance [Obsolete]', 'Coded Data Field: Medium of Performance [Obsolete]', 1, 0, '', ''), ('146', 'Coded Data Field: Medium of Performance', 'Coded Data Field: Medium of Performance', 1, 0, '', ''), + ('181', 'Coded Data Field: content form', '', 1, 0, '', ''), + ('182', 'Coded Data Field: media type', '', 1, 0, '', ''), ('200', 'Title and Statement of Responsibility', 'Title and Statement of Responsibility', 0, 1, '', ''), ('204', 'General Material Designation [Obsolete]', 'General Material Designation [Obsolete]', 1, 0, '', ''), ('205', 'Edition Statement', 'Edition Statement', 1, 0, '', ''), @@ -332,7 +397,10 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('617', 'Hierarchical Geographical Name Used as Subject', 'Hierarchical Geographical Name Used as Subject', 1, 0, '', ''), ('620', 'Place and Date of Publication, Performance, etc.', 'Place and Date of Publication, Performance, etc.', 1, 0, '', ''), ('621', 'Place and Date of Provenance', 'Place and Date of Provenance', 1, 0, '', ''), + ('623', 'Character', '', 1 , 0, '', ''), ('626', 'Technical Details Access (Electronic Resources) [Obsolete]', 'Technical Details Access (Electronic Resources) [Obsolete]', 1, 0, '', ''), + ('631', 'Occupation', '', 1, 0, '', ''), + ('632', 'Function', '', 1, 0, '', ''), ('660', 'Geographic Area Code', 'Geographic Area Code', 1, 0, '', ''), ('661', 'Time Period Code', 'Time Period Code', 1, 0, '', ''), ('670', 'PRECIS', 'PRECIS', 1, 0, '', ''), @@ -543,6 +611,15 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('146', 'f', 'Specific Instrument', 'Specific Instrument', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL), ('146', 'h', 'Number of Parts', 'Number of Parts', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL), ('146', 'i', 'Number of Players', 'Number of Players', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL), + ('181', '2', 'System code', '', 0, 0, '', 1, '', '', '', 0, 0, '', '', '', ''), + ('181', '6', 'Interfield Linking Data', '', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', ''), + ('181', 'a', 'ISBD Content form Code', '', 0, 0, '', 1, '', '', '', 0, 0, '', '', '', ''), + ('181', 'b', 'ISBD Content Qualification Code', '', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', ''), + ('181', 'c', 'Other Coding for Content Form', '', 1, 0, '', 1, 'unimarc_181c', '', '', 0, 0, '', '', '', ''), + ('182', '2', 'System code', '', 0, 0, '', 1, '', '', '', 0, 0, '', '', '', ''), + ('182', '6', 'Interfield Linking Data', '', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', ''), + ('182', 'a', 'ISBD Media Type Code', '', 0, 0, '', 1, 'unimarc_182a', '', '', 0, 0, '', '', '', ''), + ('182', 'c', 'Other Coding for Media Type', '', 1, 0, '', 1, 'unimarc_182c', '', '', 0, 0, '', '', '', ''), ('200', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), ('200', 'a', 'Title Proper', 'Title Proper', 1, 0, 'biblio.title', 2, '', '', '', 0, 0, '', '', '', NULL), ('200', 'b', 'General Material Designation', 'General Material Designation', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), @@ -586,6 +663,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('210', 's', 'Printing and/or Publishing Information Transcribed as Found in the Colophon', 'Printing and/or Publishing Information Transcribed as Found in the Colophon', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('211', 'a', 'Date', 'Date', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), ('215', 'a', 'Specific Material Designation and Extent of Item', 'Specific Material Designation and Extent of Item', 1, 0, 'biblioitems.pages', 2, '', '', '', 0, 0, '', '', '', NULL), + ('215', 'b', 'Materials and Technique display', '', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', ''), ('215', 'c', 'Other Physical Details', 'Other Physical Details', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), ('215', 'd', 'Dimensions', 'Dimensions', 1, 0, 'biblioitems.size', 2, '', '', '', 0, 0, '', '', '', NULL), ('215', 'e', 'Accompanying Material', 'Accompanying Material', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), @@ -652,6 +730,21 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('323', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL), ('324', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL), ('325', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL), + ('325', 'b', 'Type of reproduction', '', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', ''), + ('325', 'c', 'Place of reproduction', '', 1, 0, '', 3, '', '', '', 0, 0, '', '', '', ''), + ('325', 'd', 'Agency Responsible for the Reproduction', '', 1, 0, '', 3, '', '', '', 0, 0, '', '', '', ''), + ('325', 'e', 'Date of publication for the reproduction', '', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', ''), + ('325', 'f', 'Physical description of the reproduction', '', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', ''), + ('325', 'g', 'Series statement for the reproduction', '', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', ''), + ('325', 'h', 'completeness of the reproduction code', '', 0, 0, '', 3, 'unimarc_325h', '', '', 0, 0, '', '', '', ''), + ('325', 'i', 'Coverage of the reproduction', '', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', ''), + ('325', 'j', 'Terms of access to the reproduction', '', 1, 0, '', 3, '', '', '', 0, 0, '', '', '', ''), + ('325', 'n', 'Note About Reproduction', '', 1, 0, '', 3, '', '', '', 0, 0, '', '', '', ''), + ('325', 'u', 'URL of the reproduction', '', 0, 0, '', 3, '', '', '', 1, 0, '', '', '', ''), + ('325', 'v', 'Date of consultation', '', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', ''), + ('325', 'x', 'ISSN of the reproduction', '', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', ''), + ('325', 'y', 'ISBN of the reproduction', '', 1, 0, '', 3, '', '', '', 0, 0, '', '', '', ''), + ('325', 'z', 'Date when the URL in $u was found to be invalid', '', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', ''), ('326', 'a', 'Frequency', 'Frequency', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL), ('326', 'b', 'Dates of Frequency', 'Dates of Frequency', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL), ('327', 'a', 'Text of Note', 'Text of Note', 1, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL), @@ -704,6 +797,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('410', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('410', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('410', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('410', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('410', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('410', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('410', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -731,6 +825,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('411', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('411', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('411', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('411', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('411', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('411', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('411', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -758,6 +853,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('412', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('412', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('412', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('412', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('412', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('412', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('412', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), @@ -785,6 +881,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('413', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('413', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('413', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('413', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('413', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('413', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('413', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), @@ -812,6 +909,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('421', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('421', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('421', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('421', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('421', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('421', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('421', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -839,6 +937,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('422', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('422', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('422', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('422', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('422', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('422', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('422', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -866,6 +965,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('423', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('423', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('423', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('423', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('423', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('423', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('423', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -893,6 +993,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('424', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('424', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('424', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('424', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('424', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('424', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('424', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), @@ -920,6 +1021,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('425', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('425', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('425', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('425', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('425', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('425', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('425', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), @@ -947,6 +1049,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('430', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('430', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('430', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('430', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('430', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('430', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('430', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -974,6 +1077,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('431', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('431', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('431', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('431', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('431', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('431', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('431', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1001,6 +1105,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('432', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('432', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('432', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('432', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('432', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('432', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('432', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1028,6 +1133,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('433', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('433', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('433', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('433', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('433', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('433', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('433', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1055,6 +1161,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('434', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('434', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('434', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('434', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('434', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('434', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('434', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1082,6 +1189,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('435', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('435', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('435', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('435', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('435', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('435', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('435', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1109,6 +1217,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('436', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('436', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('436', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('436', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('436', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('436', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('436', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1136,6 +1245,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('437', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('437', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('437', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('437', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('437', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('437', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('437', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1163,6 +1273,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('440', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('440', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('440', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('440', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('440', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('440', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('440', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1190,6 +1301,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('441', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('441', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('441', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('441', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('441', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('441', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('441', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1217,6 +1329,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('442', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('442', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('442', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('442', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('442', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('442', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('442', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1244,6 +1357,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('443', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('443', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('443', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('443', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('443', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('443', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('443', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1271,6 +1385,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('444', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('444', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('444', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('444', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('444', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('444', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('444', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1298,6 +1413,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('445', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('445', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('445', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('445', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('445', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('445', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('445', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1325,6 +1441,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('446', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('446', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('446', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('446', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('446', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('446', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('446', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1352,6 +1469,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('447', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('447', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('447', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('447', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('447', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('447', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('447', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1379,6 +1497,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('448', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('448', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('448', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('448', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('448', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('448', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('448', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1406,6 +1525,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('451', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('451', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('451', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('451', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('451', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('451', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('451', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1433,6 +1553,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('452', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('452', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('452', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('452', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('452', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('452', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('452', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1460,6 +1581,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('453', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('453', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('453', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('453', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('453', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('453', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('453', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1487,6 +1609,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('454', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('454', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('454', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('454', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('454', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('454', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('454', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1514,6 +1637,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('455', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('455', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('455', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('455', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('455', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('455', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('455', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1541,6 +1665,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('456', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('456', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('456', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('456', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('456', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('456', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('456', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1568,6 +1693,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('461', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('461', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('461', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('461', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('461', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('461', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('461', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1595,6 +1721,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('462', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('462', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('462', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('462', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('462', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('462', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('462', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1622,6 +1749,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('463', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('463', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('463', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('463', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('463', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('463', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('463', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1649,6 +1777,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('464', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('464', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('464', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('464', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('464', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('464', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('464', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1676,6 +1805,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('470', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('470', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('470', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('470', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('470', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('470', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('470', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1703,6 +1833,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('481', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('481', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('481', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('481', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('481', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('481', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('481', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1730,6 +1861,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('482', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('482', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('482', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('482', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('482', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('482', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('482', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1757,6 +1889,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('488', '1', 'Linking Data', 'Linking Data', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('488', '3', 'Authority Record Number', 'Authority Record Number', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('488', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('488', '9', 'Koha number', '', 0, 0, '', 4, '', '', '', 0, 0, '', '', '001@', ''), ('488', 'a', 'Author', 'Author', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('488', 'b', 'General Material Designation', 'General Material Designation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('488', 'c', 'Place of Publication', 'Place of Publication', 1, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), @@ -1830,6 +1963,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('503', 'n', 'Institution in Locality', 'Institution in Locality', 0, 0, '', 5, '', '', '', 0, -5, '', '', '', NULL), ('503', 'o', 'Place in Locality', 'Place in Locality', 0, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('506', '3', 'Authority Entry Record Number', 'Authority Entry Record Number', 0, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), + ('506', '9', 'Koha number', '', 0, 0, '', 5, '', '', '', 0, 0, '', '', '', ''), ('506', 'a', 'Title', 'Title', 0, 1, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('506', 'c', 'Form of Work', 'Form of Work', 0, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('506', 'd', 'Date of Work', 'Date of Work', 0, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), @@ -1842,6 +1976,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('506', 's', 'Numeric Designation (for Music)', 'Numeric Designation (for Music)', 1, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('506', 'u', 'Key (for Music)', 'Key (for Music)', 0, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('507', '3', 'Authority Entry Record Number', 'Authority Entry Record Number', 0, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), + ('507', '9', 'Koha number', '', 0, 0, '', 5, '', '', '', 0, 0, '', '', '', ''), ('507', 'a', 'Title', 'Title', 0, 1, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('507', 'c', 'Form of Work', 'Form of Work', 0, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('507', 'd', 'Date of Work', 'Date of Work', 0, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), @@ -1959,6 +2094,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('560', 'e', 'Other Title Information', 'Other Title Information', 1, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('576', '1', 'Linking Data', 'Linking Data', 1, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('576', '3', 'Authority Entry Record Number', 'Authority Entry Record Number', 0, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), + ('576', '9', 'Koha number', '', 0, 0, '', 5, '', '', '', 0, 0, '', '', '', ''), ('576', 'a', 'Name', 'Name', 0, 1, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('576', 'c', 'Form of Work', 'Form of Work', 0, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('576', 'd', 'Date of Work', 'Date of Work', 0, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), @@ -1977,6 +2113,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('576', 'z', 'Chronological Subdivision', 'Chronological Subdivision', 1, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('577', '1', 'Linking Data', 'Linking Data', 1, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('577', '3', 'Authority Entry Record Number', 'Authority Entry Record Number', 0, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), + ('577', '9', 'Koha number', '', 0, 0, '', 5, '', '', '', 0, 0, '', '', '', ''), ('577', 'a', 'Name', 'Name', 0, 1, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('577', 'c', 'Form of Work', 'Form of Work', 0, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), ('577', 'd', 'Date of Work', 'Date of Work', 0, 0, '', 5, '', '', '', 0, -6, '', '', '', NULL), @@ -2105,6 +2242,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('616', 'z', 'Chronological Subdivision', 'Chronological Subdivision', 1, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), ('617', '2', 'System Code', 'System Code', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), ('617', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), + ('617', '9', 'Koha number', '', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), ('617', 'a', 'Country (Nation State)', 'Country (Nation State)', 1, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), ('617', 'b', 'State or Province, etc.', 'State or Province, etc.', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), ('617', 'c', 'Intermediate Political Jurisdiction', 'Intermediate Political Jurisdiction', 1, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), @@ -2136,6 +2274,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('621', '2', 'System Code', 'System Code', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), ('621', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), ('621', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), + ('621', '9', 'Koha number', '', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), ('621', 'a', 'Country (Nation State) or Larger Entity Country', 'Country (Nation State) or Larger Entity Country', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), ('621', 'b', 'State or Province, etc.', 'State or Province, etc.', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), ('621', 'c', 'Intermediate Political Jurisdiction', 'Intermediate Political Jurisdiction', 1, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), @@ -2152,6 +2291,23 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('626', 'a', 'Make and Model of Machines', 'Make and Model of Machines', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL), ('626', 'b', 'Programming Languages', 'Programming Languages', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL), ('626', 'c', 'Operating System', 'Operating System', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL), + ('631', '2', 'System Code', '', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('631', '3', 'Authority Record Number', '', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('631', '8', 'Materials specified', '', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('631', 'a', 'occupation', 'sujet', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('631', 'b', 'form', '', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('631', 'j', 'Form Subdivision', '', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('631', 'x', 'Topical Subdivision', '', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('631', 'y', 'Geographical Subdivision', '', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('631', 'z', 'Chronological Subdivision', '', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('632', '2', 'System Code', '', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('632', '3', 'Authority Record Number', '', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('632', '8', 'Materials specified', '', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('632', 'a', 'Function', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('632', 'j', 'Form Subdivision', '', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('632', 'x', 'Topical Subdivision', '', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('632', 'y', 'Geographical Subdivision', '', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), + ('632', 'z', 'Chronological Subdivision', '', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', ''), ('660', 'a', 'Code', 'Code', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL), ('661', 'a', 'Time Period Code', 'Time Period Code', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL), ('670', 'b', 'Subject Indicator Number', 'Subject Indicator Number', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL), @@ -2177,6 +2333,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('686', 'v', 'Edition', 'Edition', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL), ('700', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('700', '4', 'Relator Code', 'Relator Code', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), + ('700', '8', 'Materials specified', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), ('700', '9', 'Koha Internal Code', 'Koha Internal Code', 0, 0, '', 7, '', '', '', 0, 1, '', '', '', NULL), ('700', 'a', 'Entry Element', 'Entry Element', 0, 0, '', 7, '', 'PER', '', 0, 0, '', '', '', NULL), ('700', 'b', 'Part of Name Other than Entry Element', 'Part of Name Other than Entry Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), @@ -2184,10 +2341,12 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', 'd', 'Roman Numerals', 'Roman Numerals', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('700', 'f', 'Dates', 'Dates', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('700', 'g', 'Expansion of Initials of Forename', 'Expansion of Initials of Forename', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), + ('700', 'k', 'Attribution qualifier', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), ('700', 'o', 'International Standard Identifier for the Name', 'International Standard Identifier for the Name', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('700', 'p', 'Affiliation/Address', 'Affiliation/Address', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('701', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('701', '4', 'Relator Code', 'Relator Code', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), + ('701', '8', 'Materials specified', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), ('701', '9', 'Koha Internal Code', 'Koha Internal Code', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('701', 'a', 'Entry Element', 'Entry Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('701', 'b', 'Part of Name Other than Entry Element', 'Part of Name Other than Entry Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), @@ -2195,10 +2354,13 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('701', 'd', 'Roman Numerals', 'Roman Numerals', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('701', 'f', 'Dates', 'Dates', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('701', 'g', 'Expansion of Initials of Forename', 'Expansion of Initials of Forename', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), + ('701', 'k', 'Attribution qualifier', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), + ('701', 'o', 'ISNI', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), ('701', 'p', 'Affiliation/Address', 'Affiliation/Address', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('702', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('702', '4', 'Relator Code', 'Relator Code', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('702', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), + ('702', '8', 'Materials specified', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), ('702', '9', 'Koha Internal Code', 'Koha Internal Code', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('702', 'a', 'Entry Element', 'Entry Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('702', 'b', 'Part of Name Other than Entry Element', 'Part of Name Other than Entry Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), @@ -2206,22 +2368,28 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('702', 'd', 'Roman Numerals', 'Roman Numerals', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('702', 'f', 'Dates', 'Dates', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('702', 'g', 'Expansion of Initials of Forename', 'Expansion of Initials of Forename', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), + ('702', 'k', 'Attribution qualifier', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), ('702', 'o', 'International Standard Identifier for the Name', 'International Standard Identifier for the Name', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('702', 'p', 'Affiliation/Address', 'Affiliation/Address', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('702', 'r', 'Part or Role Played', 'Part or Role Played', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('703', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('703', '4', 'Relator Code', 'Relator Code', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('703', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), + ('703', '8', 'Materials specified', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), + ('703', '9', 'koha internal code', '', 0, 0, '', 7, '', '', '', 0, 1, '', NULL, '', ''), ('703', 'a', 'Entry Element', 'Entry Element', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('703', 'b', 'Part of Name Other than Entry Element', 'Part of Name Other than Entry Element', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('703', 'c', 'Additions to Names Other than Dates', 'Additions to Names Other than Dates', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('703', 'd', 'Roman Numerals', 'Roman Numerals', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('703', 'f', 'Dates', 'Dates', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('703', 'g', 'Expansion of Initials of Forename', 'Expansion of Initials of Forename', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), + ('703', 'k', 'Attribution qualifier', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), ('703', 'o', 'International Standard Identifier for the Name', 'International Standard Identifier for the Name', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('703', 'p', 'Affiliation/Address', 'Affiliation/Address', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('710', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('710', '4', 'Relator Code', 'Relator Code', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), + ('710', '8', 'Materials specified', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), + ('710', '9', 'koha internal code', '', 1, 0, '', 7, '', '', '', 0, 0, '', NULL, '', ''), ('710', 'a', 'Entry Element', 'Entry Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('710', 'b', 'Subdivision', 'Subdivision', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('710', 'c', 'Addition to Name or Qualifier', 'Addition to Name or Qualifier', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), @@ -2234,6 +2402,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('710', 'p', 'Affiliation/Address', 'Affiliation/Address', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('711', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('711', '4', 'Relator Code', 'Relator Code', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), + ('711', '8', 'Materials specified', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), + ('711', '9', 'koha internal code', '', 1, 0, '', 7, '', '', '', 0, 0, '', NULL, '', ''), ('711', 'a', 'Entry Element', 'Entry Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('711', 'b', 'Subdivision', 'Subdivision', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('711', 'c', 'Addition to Name or Qualifier', 'Addition to Name or Qualifier', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), @@ -2242,10 +2412,13 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('711', 'f', 'Date of Meeting', 'Date of Meeting', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('711', 'g', 'Inverted Element', 'Inverted Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('711', 'h', 'Part of Name Other than Entry Element and Inverted Element', 'Part of Name Other than Entry Element and Inverted Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), + ('711', 'o', 'ISNI', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), ('711', 'p', 'Affiliation/Address', 'Affiliation/Address', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('712', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('712', '4', 'Relator Code', 'Relator Code', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('712', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 1, '', 7, '', '', '', 0, -6, '', '', '', NULL), + ('712', '8', 'Materials specified', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), + ('712', '9', 'koha internal code', '', 1, 0, '', 7, '', '', '', 0, 0, '', NULL, '', ''), ('712', 'a', 'Entry Element', 'Entry Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('712', 'b', 'Subdivision', 'Subdivision', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('712', 'c', 'Addition to Name or Qualifier', 'Addition to Name or Qualifier', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), @@ -2254,11 +2427,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('712', 'f', 'Date of Meeting', 'Date of Meeting', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('712', 'g', 'Inverted Element', 'Inverted Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('712', 'h', 'Part of Name Other than Entry Element and Inverted Element', 'Part of Name Other than Entry Element and Inverted Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), + ('712', 'o', 'ISNI', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), ('712', 'p', 'Affiliation/Address', 'Affiliation/Address', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('712', 'r', 'Part or Role Played', 'Part or Role Played', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('713', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('713', '4', 'Relator Code', 'Relator Code', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('713', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 1, '', 7, '', '', '', 0, -6, '', '', '', NULL), + ('713', '8', 'Materials specified', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), + ('713', '9', 'koha internal code', '', 0, 0, '', 7, '', '', '', 0, 0, '', NULL, '', ''), ('713', 'a', 'Entry Element', 'Entry Element', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('713', 'b', 'Subdivision', 'Subdivision', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('713', 'c', 'Addition to Name or Qualifier', 'Addition to Name or Qualifier', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), @@ -2267,6 +2443,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('713', 'f', 'Date of Meeting', 'Date of Meeting', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('713', 'g', 'Inverted Element', 'Inverted Element', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('713', 'h', 'Part of Name Other than Entry Element and Inverted Element', 'Part of Name Other than Entry Element and Inverted Element', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), + ('713', 'o', 'ISNI', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), ('713', 'p', 'Affiliation/Address', 'Affiliation/Address', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('716', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('716', 'a', 'Data Element', 'Data Element', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), @@ -2274,6 +2451,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('716', 'f', 'Dates', 'Dates', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('720', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('720', '4', 'Relator Code', 'Relator Code', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), + ('720', '8', 'Materials specified', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), + ('720', '9', 'Koha number', '', 1, 0, '', 7, '', '', '', 0, 0, '', NULL, '', ''), ('720', 'a', 'Entry Element', 'Entry Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('720', 'c', 'Type of Family', 'Type of Family', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('720', 'd', 'Places Associated with the Family', 'Places Associated with the Family', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), @@ -2281,11 +2460,18 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('720', 'o', 'International Standard Identifier for the Name', 'International Standard Identifier for the Name', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('721', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('721', '4', 'Relator Code', 'Relator Code', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), + ('721', '8', 'Materials specified', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), + ('721', '9', 'koha internal code', '', 1, 0, '', 7, '', '', '', 0, 0, '', NULL, '', ''), ('721', 'a', 'Entry Element', 'Entry Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), + ('721', 'c', 'Type of family', '', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), + ('721', 'd', 'Places Associated with the Family', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), ('721', 'f', 'Dates', 'Dates', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), + ('721', 'o', 'ISNI', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), ('722', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('722', '4', 'Relator Code', 'Relator Code', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('722', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 1, '', 7, '', '', '', 0, -6, '', '', '', NULL), + ('722', '8', 'Materials specified', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), + ('722', '9', 'Koha number', '', 1, 0, '', 7, '', '', '', 0, 0, '', NULL, '', ''), ('722', 'a', 'Entry Element', 'Entry Element', 0, 0, '', 7, '', '', '', 0, 0, '', '', '', NULL), ('722', 'c', 'Type of Family', 'Type of Family', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('722', 'd', 'Places Associated with the Family', 'Places Associated with the Family', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), @@ -2295,6 +2481,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('723', '3', 'Authority Record Number', 'Authority Record Number', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('723', '4', 'Relator Code', 'Relator Code', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('723', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 1, '', 7, '', '', '', 0, -6, '', '', '', NULL), + ('723', '8', 'Materials specified', '', 1, 0, '', 7, '', '', '', 0, 0, '', '', '', ''), + ('723', '9', 'Koha number', '', 0, 0, '', 7, '', '', '', 0, 1, '', NULL, '', ''), ('723', 'a', 'Entry Element', 'Entry Element', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('723', 'c', 'Type of Family', 'Type of Family', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('723', 'd', 'Places Associated with the Family', 'Places Associated with the Family', 1, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), -- 2.20.1