From c740b510b6d23dd81ed1db74b4928a3ae828720b Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Mon, 1 Jul 2013 21:24:30 -0300 Subject: [PATCH 3/3] [FOLLOWUP 2] Bug 5858 - Update default MARC21 framework to Update No. 16 (April 2013) This is another followup. It updates some missing tags/subtags, also corrects and verify repeatable value for tags/subtags --- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 152 +++++++++++--------- 1 file changed, 85 insertions(+), 67 deletions(-) diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index 8448c4a..19e9757 100644 --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -174,7 +174,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('001', 'CONTROL NUMBER', 'CONTROL NUMBER', 0, 0, '', ''), ('003', 'CONTROL NUMBER IDENTIFIER', 'CONTROL NUMBER IDENTIFIER', 0, 1, '', ''), ('005', 'DATE AND TIME OF LATEST TRANSACTION', 'DATE AND TIME OF LATEST TRANSACTION', 0, 1, '', ''), - ('006', 'FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS--GENERAL INFORMATION', 'FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS--GENERAL INFORMATION', 1, 0, '', ''), + ('006', 'FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS', 'FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS', 1, 0, '', ''), ('007', 'PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION', 'PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION', 1, 0, '', ''), ('008', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 0, 1, '', ''), ('009', 'PHYSICAL DESCRIPTION FIXED-FIELD FOR ARCHIVAL COLLECTION (VM) [OBSOLETE]', 'PHYSICAL DESCRIPTION FIXED-FIELD FOR ARCHIVAL COLLECTION (VM) [OBSOLETE]', 1, 0, '', ''), @@ -228,9 +228,9 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('074', 'GPO ITEM NUMBER', 'GPO ITEM NUMBER', 1, 0, NULL, ''), ('080', 'UNIVERSAL DECIMAL CLASSIFICATION NUMBER', 'UNIVERSAL DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL, ''), ('082', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL, ''), - ('083', 'ADDITIONAL DEWEY DECIMAL CLASSIFICATION NUMBER', 'ADDITIONAL DEWEY DECIMAL CLASSIFICATION NUMBER', 0, 1, NULL, ''), + ('083', 'ADDITIONAL DEWEY DECIMAL CLASSIFICATION NUMBER', 'ADDITIONAL DEWEY DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL, ''), ('084', 'OTHER CLASSIFICATION NUMBER', 'OTHER CLASSIFICATION NUMBER', 1, 0, NULL, ''), - ('085', 'SYNTHESIZED CLASSIFICATION NUMBER COMPONENTS', 'SYNTHESIZED CLASSIFICATION NUMBER COMPONENTS', 0, 1, NULL, ''), + ('085', 'SYNTHESIZED CLASSIFICATION NUMBER COMPONENTS', 'SYNTHESIZED CLASSIFICATION NUMBER COMPONENTS', 1, 0, NULL, ''), ('086', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 1, 0, NULL, ''), ('087', 'REPORT NUMBER [OBSOLETE, CAN/MARC]', 'REPORT NUMBER [OBSOLETE, CAN/MARC]', 1, 0, NULL, ''), ('088', 'REPORT NUMBER', 'REPORT NUMBER', 1, 0, NULL, ''), @@ -260,13 +260,13 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('254', 'MUSICAL PRESENTATION STATEMENT', 'MUSICAL PRESENTATION STATEMENT', 0, 0, NULL, ''), ('255', 'CARTOGRAPHIC MATHEMATICAL DATA', 'CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL, ''), ('256', 'COMPUTER FILE CHARACTERISTICS', 'COMPUTER FILE CHARACTERISTICS', 0, 0, NULL, ''), - ('257', 'COUNTRY OF PRODUCING ENTITY', 'COUNTRY OF PRODUCING ENTITY', 0, 0, NULL, ''), + ('257', 'COUNTRY OF PRODUCING ENTITY', 'COUNTRY OF PRODUCING ENTITY', 1, 0, NULL, ''), ('258', 'PHILATELIC ISSUE DATA', 'PHILATELIC ISSUE DATA', 1, 0, NULL, ''), ('260', 'PUBLICATION, DISTRIBUTION, ETC.', 'PUBLICATION, DISTRIBUTION, ETC.', 1, 0, NULL, ''), ('261', 'IMPRINT STATEMENT FOR FILMS (Pre-AACR 1 Revised) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'IMPRINT STATEMENT FOR FILMS (Pre-AACR 1 Revised) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 0, 0, NULL, ''), ('262', 'IMPRINT STATEMENT FOR SOUND RECORDINGS (Pre-AACR 2) [LOCAL, USA]', 'IMPRINT STATEMENT FOR SOUND RECORDINGS (Pre-AACR 2) [LOCAL, USA]', 0, 0, NULL, ''), ('263', 'PROJECTED PUBLICATION DATE', 'PROJECTED PUBLICATION DATE', 0, 0, NULL, ''), - ('264', 'PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE', 'PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE', 0, 1, NULL, ''), + ('264', 'PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE', 'PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE', 1, 0, NULL, ''), ('265', 'SOURCE FOR ACQUISITION/SUBSCRIPTION ADDRESS [OBSOLETE]', 'SOURCE FOR ACQUISITION/SUBSCRIPTION ADDRESS [OBSOLETE]', 0, 0, NULL, ''), ('270', 'ADDRESS', 'ADDRESS', 1, 0, NULL, ''), ('300', 'PHYSICAL DESCRIPTION', 'PHYSICAL DESCRIPTION', 1, 0, NULL, ''), @@ -281,16 +281,16 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('310', 'CURRENT PUBLICATION FREQUENCY', 'CURRENT PUBLICATION FREQUENCY', 0, 0, NULL, ''), ('315', 'FREQUENCY (CF MP) [OBSOLETE]', 'FREQUENCY (CF MP) [OBSOLETE]', 0, 0, NULL, ''), ('321', 'FORMER PUBLICATION FREQUENCY', 'FORMER PUBLICATION FREQUENCY', 1, 0, NULL, ''), - ('336', 'CONTENT TYPE', 'CONTENT TYPE', 0, 1, NULL, ''), - ('337', 'MEDIA TYPE', 'MEDIA TYPE', 0, 1, NULL, ''), - ('338', 'CARRIER TYPE', 'CARRIER TYPE', 0, 1, NULL, ''), + ('336', 'CONTENT TYPE', 'CONTENT TYPE', 1, 0, NULL, ''), + ('337', 'MEDIA TYPE', 'MEDIA TYPE', 1, 0, NULL, ''), + ('338', 'CARRIER TYPE', 'CARRIER TYPE', 1, 0, NULL, ''), ('340', 'PHYSICAL MEDIUM', 'PHYSICAL MEDIUM', 1, 0, NULL, ''), ('342', 'GEOSPATIAL REFERENCE DATA', 'GEOSPATIAL REFERENCE DATA', 1, 0, NULL, ''), ('343', 'PLANAR COORDINATE DATA', 'PLANAR COORDINATE DATA', 1, 0, NULL, ''), - ('344', 'SOUND CHARACTERISTICS', 'SOUND CHARACTERISTICS', 0, 1, NULL, ''), - ('345', 'PROJECTION CHARACTERISTICS OF MOVING IMAGE', 'PROJECTION CHARACTERISTICS OF MOVING IMAGE', 0, 1, NULL, ''), - ('346', 'VIDEO CHARACTERISTICS', 'VIDEO CHARACTERISTICS', 0, 1, NULL, ''), - ('347', 'DIGITAL FILE CHARACTERISTICS', 'DIGITAL FILE CHARACTERISTICS', 0, 1, NULL, ''), + ('344', 'SOUND CHARACTERISTICS', 'SOUND CHARACTERISTICS', 1, 0, NULL, ''), + ('345', 'PROJECTION CHARACTERISTICS OF MOVING IMAGE', 'PROJECTION CHARACTERISTICS OF MOVING IMAGE', 1, 0, NULL, ''), + ('346', 'VIDEO CHARACTERISTICS', 'VIDEO CHARACTERISTICS', 1, 0, NULL, ''), + ('347', 'DIGITAL FILE CHARACTERISTICS', 'DIGITAL FILE CHARACTERISTICS', 1, 0, NULL, ''), ('350', 'PRICE (NR) (BK AM CF MU VM SE) [OBSOLETE]', 'PRICE (NR) (BK AM CF MU VM SE) [OBSOLETE]', 1, 0, NULL, ''), ('351', 'ORGANIZATION AND ARRANGEMENT OF MATERIALS', 'ORGANIZATION AND ARRANGEMENT OF MATERIALS', 1, 0, NULL, ''), ('352', 'DIGITAL GRAPHIC REPRESENTATION', 'DIGITAL GRAPHIC REPRESENTATION', 1, 0, NULL, ''), @@ -298,17 +298,17 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('357', 'ORIGINATOR DISSEMINATION CONTROL', 'ORIGINATOR DISSEMINATION CONTROL', 0, 0, NULL, ''), ('359', 'RENTAL PRICE (VM) [OBSOLETE]', 'RENTAL PRICE (VM) [OBSOLETE]', 0, 0, NULL, ''), ('362', 'DATES OF PUBLICATION AND/OR SEQUENTIAL DESIGNATION', 'DATES OF PUBLICATION AND/OR SEQUENTIAL DESIGNATION', 1, 0, NULL, ''), - ('363', 'NORMALIZED DATE AND SEQUENTIAL DESIGNATION', 'NORMALIZED DATE AND SEQUENTIAL DESIGNATION', 0, 1, NULL, ''), + ('363', 'NORMALIZED DATE AND SEQUENTIAL DESIGNATION', 'NORMALIZED DATE AND SEQUENTIAL DESIGNATION', 1, 0, NULL, ''), ('365', 'TRADE PRICE', 'TRADE PRICE', 1, 0, NULL, ''), ('366', 'TRADE AVAILABILITY INFORMATION', 'TRADE AVAILABILITY INFORMATION', 1, 0, NULL, ''), - ('377', 'ASSOCIATED LANGUAGE', 'ASSOCIATED LANGUAGE', 0, 1, NULL, ''), - ('380', 'FORM OF WORK', 'FORM OF WORK', 0, 1, NULL, ''), - ('381', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 0, 1, NULL, ''), - ('382', 'MEDIUM OF PERFORMANCE', 'MEDIUM OF PERFORMANCE', 0, 1, NULL, ''), - ('383', 'NUMERIC DESIGNATION OF MUSICAL WORK', 'NUMERIC DESIGNATION OF MUSICAL WORK', 0, 1, NULL, ''), + ('377', 'ASSOCIATED LANGUAGE', 'ASSOCIATED LANGUAGE', 1, 0, NULL, ''), + ('380', 'FORM OF WORK', 'FORM OF WORK', 1, 0, NULL, ''), + ('381', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 1, 0, NULL, ''), + ('382', 'MEDIUM OF PERFORMANCE', 'MEDIUM OF PERFORMANCE', 1, 0, NULL, ''), + ('383', 'NUMERIC DESIGNATION OF MUSICAL WORK', 'NUMERIC DESIGNATION OF MUSICAL WORK', 1, 0, NULL, ''), + ('384', 'KEY', 'KEY', 0, 0, NULL, ''), ('385', 'AUDIENCE CHARACTERISTICS', 'AUDIENCE CHARACTERISTICS', 1, 0, NULL, ''), ('386', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 1, 0, NULL, ''), - ('384', 'KEY', 'KEY', 0, 0, NULL, ''), ('400', 'SERIES STATEMENT/ADDED ENTRY--PERSONAL NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'SERIES STATEMENT/ADDED ENTRY--PERSONAL NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 1, 0, NULL, ''), ('410', 'SERIES STATEMENT/ADDED ENTRY--CORPORATE NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'SERIES STATEMENT/ADDED ENTRY--CORPORATE NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 1, 0, NULL, ''), ('411', 'SERIES STATEMENT/ADDED ENTRY--MEETING NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'SERIES STATEMENT/ADDED ENTRY--MEETING NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 1, 0, NULL, ''), @@ -338,8 +338,8 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('522', 'GEOGRAPHIC COVERAGE NOTE', 'GEOGRAPHIC COVERAGE NOTE', 1, 0, NULL, ''), ('523', 'TIME PERIOD OF CONTENT NOTE (CF) [OBSOLETE]', 'TIME PERIOD OF CONTENT NOTE (CF) [OBSOLETE]', 0, 0, NULL, ''), ('524', 'PREFERRED CITATION OF DESCRIBED MATERIALS NOTE', 'PREFERRED CITATION OF DESCRIBED MATERIALS NOTE', 1, 0, NULL, ''), - ('525', 'SUPPLEMENT NOTE', 'SUPPLEMENT NOTE', 0, 0, NULL, ''), - ('526', 'STUDY PROGRAM INFORMATION NOTE', 'STUDY PROGRAM INFORMATION NOTE', 0, 0, NULL, ''), + ('525', 'SUPPLEMENT NOTE', 'SUPPLEMENT NOTE', 1, 0, NULL, ''), + ('526', 'STUDY PROGRAM INFORMATION NOTE', 'STUDY PROGRAM INFORMATION NOTE', 1, 0, NULL, ''), ('527', 'CENSORSHIP NOTE (VM) [OBSOLETE]', 'CENSORSHIP NOTE (VM) [OBSOLETE]', 1, 0, NULL, ''), ('530', 'ADDITIONAL PHYSICAL FORM AVAILABLE NOTE', 'ADDITIONAL PHYSICAL FORM AVAILABLE NOTE', 1, 0, NULL, ''), ('533', 'REPRODUCTION NOTE', 'REPRODUCTION NOTE', 1, 0, NULL, ''), @@ -350,7 +350,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('538', 'SYSTEM DETAILS NOTE', 'SYSTEM DETAILS NOTE', 1, 0, NULL, ''), ('540', 'TERMS GOVERNING USE AND REPRODUCTION NOTE', 'TERMS GOVERNING USE AND REPRODUCTION NOTE', 1, 0, NULL, ''), ('541', 'IMMEDIATE SOURCE OF ACQUISITION NOTE', 'IMMEDIATE SOURCE OF ACQUISITION NOTE', 1, 0, NULL, ''), - ('542', 'INFORMATION RELATING TO COPYRIGHT STATUS', 'INFORMATION RELATING TO COPYRIGHT STATUS', 0, 1, NULL, ''), + ('542', 'INFORMATION RELATING TO COPYRIGHT STATUS', 'INFORMATION RELATING TO COPYRIGHT STATUS', 1, 0, NULL, ''), ('543', 'SOLICITATION INFORMATION NOTE (AM) [OBSOLETE]', 'SOLICITATION INFORMATION NOTE (AM) [OBSOLETE]', 1, 0, NULL, ''), ('544', 'LOCATION OF OTHER ARCHIVAL MATERIALS NOTE', 'LOCATION OF OTHER ARCHIVAL MATERIALS NOTE', 1, 0, NULL, ''), ('545', 'BIOGRAPHICAL OR HISTORICAL DATA', 'BIOGRAPHICAL OR HISTORICAL DATA', 1, 0, NULL, ''), @@ -373,7 +373,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('584', 'ACCUMULATION AND FREQUENCY OF USE NOTE', 'ACCUMULATION AND FREQUENCY OF USE NOTE', 1, 0, NULL, ''), ('585', 'EXHIBITIONS NOTE', 'EXHIBITIONS NOTE', 1, 0, NULL, ''), ('586', 'AWARDS NOTE', 'AWARDS NOTE', 1, 0, NULL, ''), - ('588', 'SOURCE OF DESCRIPTION NOTE', 'SOURCE OF DESCRIPTION NOTE', 0, 1, NULL, ''), + ('588', 'SOURCE OF DESCRIPTION NOTE', 'SOURCE OF DESCRIPTION NOTE', 1, 0, NULL, ''), ('590', 'LOCAL NOTE (RLIN)', 'LOCAL NOTE (RLIN)', 1, 0, NULL, ''), ('600', 'SUBJECT ADDED ENTRY--PERSONAL NAME', 'SUBJECT ADDED ENTRY--PERSONAL NAME', 1, 0, NULL, ''), ('610', 'SUBJECT ADDED ENTRY--CORPORATE NAME', 'SUBJECT ADDED ENTRY--CORPORATE NAME', 1, 0, NULL, ''), @@ -404,7 +404,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('720', 'ADDED ENTRY--UNCONTROLLED NAME', 'ADDED ENTRY--UNCONTROLLED NAME', 1, 0, NULL, ''), ('730', 'ADDED ENTRY--UNIFORM TITLE', 'ADDED ENTRY--UNIFORM TITLE', 1, 0, NULL, ''), ('740', 'ADDED ENTRY--UNCONTROLLED RELATED/ANALYTICAL TITLE', 'ADDED ENTRY--UNCONTROLLED RELATED/ANALYTICAL TITLE', 1, 0, NULL, ''), - ('751', 'ADDED ENTRY-GEOGRAPHIC NAME', 'ADDED ENTRY-GEOGRAPHIC NAME', 0, 1, NULL, ''), + ('751', 'ADDED ENTRY-GEOGRAPHIC NAME', 'ADDED ENTRY-GEOGRAPHIC NAME', 1, 0, NULL, ''), ('752', 'ADDED ENTRY--HIERARCHICAL PLACE NAME', 'ADDED ENTRY--HIERARCHICAL PLACE NAME', 1, 0, NULL, ''), ('753', 'SYSTEM DETAILS ACCESS TO COMPUTER FILES', 'SYSTEM DETAILS ACCESS TO COMPUTER FILES', 1, 0, NULL, ''), ('754', 'ADDED ENTRY--TAXONOMIC IDENTIFICATION', 'ADDED ENTRY--TAXONOMIC IDENTIFICATION', 1, 0, NULL, ''), @@ -462,7 +462,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('878', 'ITEM INFORMATION--INDEXES', 'ITEM INFORMATION--INDEXES', 1, 0, NULL, ''), ('880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL, ''), ('882', 'REPLACEMENT RECORD INFORMATION', 'REPLACEMENT RECORD INFORMATION', 0, 0, NULL, ''), - ('883', 'MACHINE-GENERATED METADATA PROVENANCE', 'MACHINE-GENERATED METADATA PROVENANCE', 0, 1, NULL, ''), + ('883', 'MACHINE-GENERATED METADATA PROVENANCE', 'MACHINE-GENERATED METADATA PROVENANCE', 1, 0, NULL, ''), ('886', 'FOREIGN MARC INFORMATION FIELD', 'FOREIGN MARC INFORMATION FIELD', 1, 0, NULL, ''), ('887', 'NON-MARC INFORMATION FIELD', 'NON-MARC INFORMATION FIELD', 1, 0, NULL, ''), ('896', 'LOCAL SERIES ADDED ENTRY--PERSONAL NAME (RLIN)', 'LOCAL SERIES ADDED ENTRY--PERSONAL NAME (RLIN)', 1, 0, '', ''), @@ -582,7 +582,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('026', 'a', 'First and second groups of characters', 'First and second groups of characters', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('026', 'b', 'Third and fourth groups of characters', 'Third and fourth groups of characters', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('026', 'c', 'Date', 'Date', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('026', 'd', 'Number of volume or part', 'Number of volume or part', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('026', 'd', 'Number of volume or part', 'Number of volume or part', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('026', 'e', 'Unparsed fingerprint', 'Unparsed fingerprint', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('027', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('027', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), @@ -688,7 +688,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), ('040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 1, '', 0, '', '', '', 0, 0, '', '', '', NULL), ('040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('040', 'e', 'Description conventions', 'Description conventions', 0, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), + ('040', 'e', 'Description conventions', 'Description conventions', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), ('041', '2', 'Source of code', 'Source of code', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('041', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('041', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), @@ -728,10 +728,10 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('046', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('046', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('046', 'a', 'Type of date code', 'Type of date code', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('046', 'b', 'Date 1 (B.C. date)', 'Date 1 (B.C. date)', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('046', 'c', 'Date 1 (C.E. date)', 'Date 1 (C.E. date)', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('046', 'd', 'Date 2 (B.C. date)', 'Date 2 (B.C. date)', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('046', 'e', 'Date 2 (C.E. date)', 'Date 2 (C.E. date)', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('046', 'b', 'Date 1, B.C. date', 'Date 1 (B.C. date)', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('046', 'c', 'Date 1, C.E. date', 'Date 1 (C.E. date)', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('046', 'd', 'Date 2, B.C. date', 'Date 2 (B.C. date)', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('046', 'e', 'Date 2, C.E. date', 'Date 2 (C.E. date)', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('046', 'j', 'Date resource modified', 'Date resource modified', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('046', 'k', 'Beginning or single date created', 'Beginning or single date created', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('046', 'l', 'Ending date created', 'Ending date created', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), @@ -799,7 +799,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('071', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('071', 'a', 'Classification number', 'Classification number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('071', 'b', 'Item number', 'Item number', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('071', 'c', 'Copy information', 'Copy information', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('071', 'c', 'Copy information', 'Copy information', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('072', '2', 'Source', 'Source', 0, 0, NULL, 0, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('072', '6', 'Linkage', 'Linkage', 0, 0, NULL, 0, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('072', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 0, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -1066,7 +1066,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('247', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('247', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('247', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), - ('250', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('250', '3', 'Materials specified', 'Materials specified', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('250', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('250', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('250', 'a', 'Edition statement', 'Edition statement', 0, 0, 'biblioitems.editionstatement', 2, '', '', '', NULL, 0, '', '', '', NULL), ('250', 'b', 'Remainder of edition statement', 'Remainder of edition statement', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), @@ -1075,9 +1075,9 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('254', 'a', 'Musical presentation statement', 'Musical presentation statement', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('255', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('255', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), - ('255', 'a', 'Statement of scale', 'Statement of scale', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), - ('255', 'b', 'Statement of projection', 'Statement of projection', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), - ('255', 'c', 'Statement of coordinates', 'Statement of coordinates', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('255', 'a', 'Statement of scale', 'Statement of scale', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('255', 'b', 'Statement of projection', 'Statement of projection', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('255', 'c', 'Statement of coordinates', 'Statement of coordinates', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('255', 'd', 'Statement of zone', 'Statement of zone', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('255', 'e', 'Statement of equinox', 'Statement of equinox', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('255', 'f', 'Outer G-ring coordinate pairs', 'Outer G-ring coordinate pairs', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), @@ -1088,7 +1088,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('257', '2', 'Source', 'Source', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('257', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('257', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), - ('257', 'a', 'Country of producing entity', 'Country of producing entity', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('257', 'a', 'Country of producing entity', 'Country of producing entity', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('258', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('258', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('258', 'a', 'Issuing jurisdiction', 'Issuing jurisdiction', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), @@ -1102,7 +1102,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('260', 'd', 'Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('260', 'e', 'Place of manufacture', 'Place of manufacture', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('260', 'f', 'Manufacturer', 'Manufacturer', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), - ('260', 'g', 'Date of manufacture', 'Date of manufacture', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('260', 'g', 'Date of manufacture', 'Date of manufacture', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('260', 'k', 'Identification/manufacturer number [OBSOLETE, CAN/MARC]', 'Identification/manufacturer number [OBSOLETE, CAN/MARC]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('260', 'l', 'Matrix and/or take number [OBSOLETE, CAN/MARC]', 'Matrix and/or take number [OBSOLETE, CAN/MARC]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('261', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), @@ -1185,7 +1185,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('305', 'n', 'Matrix and/or take number', 'Matrix and/or take number', 0, 0, '', 3, '', '', NULL, NULL, -6, '', '', '', NULL), ('306', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('306', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), - ('306', 'a', 'Playing time', 'Playing time', 0, 0, '', 3, '', '', '', NULL, 0, '', '', '', NULL), + ('306', 'a', 'Playing time', 'Playing time', 1, 0, '', 3, '', '', '', NULL, 0, '', '', '', NULL), ('307', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('307', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('307', 'a', 'Hours', 'Hours', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), @@ -1248,7 +1248,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('342', '2', 'Reference method used', 'Reference method used', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('342', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('342', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), - ('342', 'a', 'Name', 'Name', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('342', 'a', 'Name', 'Name', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('342', 'b', 'Coordinate or distance units', 'Coordinate or distance units', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('342', 'c', 'Latitude resolution', 'Latitude resolution', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('342', 'd', 'Longitude resolution', 'Longitude resolution', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), @@ -1273,7 +1273,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('342', 'w', 'Local planar or local georeference information', 'Local planar or local georeference information', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('343', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('343', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), - ('343', 'a', 'Planar coordinate encoding method', 'Planar coordinate encoding method', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('343', 'a', 'Planar coordinate encoding method', 'Planar coordinate encoding method', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('343', 'b', 'Planar distance units', 'Planar distance units', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('343', 'c', 'Abscissa resolution', 'Abscissa resolution', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('343', 'd', 'Ordinate resolution', 'Ordinate resolution', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), @@ -1440,14 +1440,32 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('383', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('383', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('383', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), - ('384', 'a', 'Key', 'Key', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), - ('384', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), - ('384', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('383', 'a', 'Serial number', 'Serial number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('383', 'b', 'Opus number', 'Opus number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('383', 'c', 'Thematic index number', 'Thematic index number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('383', 'd', 'Thematic index code', 'Thematic index code', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('383', 'e', 'Publisher associated with opus number', 'Publisher associated with opus number', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('384', 'a', 'Key', 'Key', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('384', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('384', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('385', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('385', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('385', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('385', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('385', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('385', 'a', 'Audience term', 'Audience term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('385', 'b', 'Audience code', 'Audience code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('385', 'm', 'Demographic group term', 'Demographic group term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('385', 'n', 'Demographic group code', 'Demographic group code', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('386', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('386', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('386', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('386', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('386', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('386', 'a', 'Creator/contributor term', 'Creator/contributor term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('386', 'b', 'Creator/contributor code', 'Creator/contributor code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('386', 'm', 'Demographic group term', 'Demographic group term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('386', 'n', 'Demographic group code', 'Demographic group code', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('400', '4', 'Relator code', 'Relator code', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('400', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('400', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), @@ -1523,7 +1541,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('490', 'a', 'Series statement', 'Series statement', 1, 0, '', 4, '', '', '', NULL, -1, '', '', '', NULL), ('490', 'l', 'Library of Congress call number', 'Library of Congress call number', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), ('490', 'v', 'Volume/sequential designation', 'Volume/sequential designation', 1, 0, '', 4, '', '', '', NULL, -1, '', '', '', NULL), - ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -1, '', '', '', NULL), + ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 1, 0, '', 4, '', '', '', NULL, -1, '', '', '', NULL), ('500', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('500', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('500', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), @@ -1757,7 +1775,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('541', 'e', 'Accession number', 'Accession number', 0, 0, '', 5, '', '', '', NULL, 1, '', '', '', NULL), ('541', 'f', 'Owner', 'Owner', 0, 0, '', 5, '', '', '', NULL, 1, '', '', '', NULL), ('541', 'h', 'Purchase price', 'Purchase price', 0, 0, '', 5, '', '', '', NULL, 1, '', '', '', NULL), - ('541', 'n', 'Extent', 'Extent', 0, 0, '', 5, '', '', '', NULL, 1, '', '', '', NULL), + ('541', 'n', 'Extent', 'Extent', 1, 0, '', 5, '', '', '', NULL, 1, '', '', '', NULL), ('541', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 5, '', '', '', NULL, 1, '', '', '', NULL), ('542', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('542', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), @@ -1902,7 +1920,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('583', 'd', 'Action interval', 'Action interval', 1, 0, '', 5, '', '', '', NULL, -1, '', '', '', NULL), ('583', 'e', 'Contingency for action', 'Contingency for action', 1, 0, '', 5, '', '', '', NULL, -1, '', '', '', NULL), ('583', 'f', 'Authorization', 'Authorization', 1, 0, '', 5, '', '', '', NULL, -1, '', '', '', NULL), - ('583', 'h', 'Jurisdiction', 'Jurisdiction', 0, 0, '', 5, '', '', '', NULL, -1, '', '', '', NULL), + ('583', 'h', 'Jurisdiction', 'Jurisdiction', 1, 0, '', 5, '', '', '', NULL, -1, '', '', '', NULL), ('583', 'i', 'Method of action', 'Method of action', 1, 0, '', 5, '', '', '', NULL, -1, '', '', '', NULL), ('583', 'j', 'Site of action', 'Site of action', 1, 0, '', 5, '', '', '', NULL, -1, '', '', '', NULL), ('583', 'k', 'Action agent', 'Action agent', 1, 0, '', 5, '', '', '', NULL, -1, '', '', '', NULL), @@ -2073,7 +2091,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('650', 'b', 'Topical term following geographic name as entry element', 'Topical term following geographic name as entry element', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL), ('650', 'c', 'Location of event', 'Location of event', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL), ('650', 'd', 'Active dates', 'Active dates', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL), - ('650', 'e', 'Relator term', 'Relator term', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL), + ('650', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL), ('650', 'v', 'Form subdivision', 'Form subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL), ('650', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL), ('650', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL), @@ -2471,7 +2489,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('752', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('752', '6', 'Linkage', 'Linkage', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('752', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('752', 'a', 'Country or larger entity', 'Country or larger entity', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('752', 'a', 'Country or larger entity', 'Country or larger entity', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('752', 'b', 'First-order political jurisdiction', 'First-order political jurisdiction', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('752', 'c', 'Intermediate political jurisdiction', 'Intermediate political jurisdiction', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('752', 'd', 'City', 'City', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2510,7 +2528,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('760', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('760', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('760', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('760', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('760', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('760', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('760', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('760', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2530,7 +2548,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('762', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('762', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('762', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('762', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('762', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('762', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('762', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('762', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2550,7 +2568,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('765', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('765', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('765', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('765', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('765', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('765', 'k', 'Series data for related item', 'Series data for related item', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('765', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('765', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2574,7 +2592,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('767', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('767', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('767', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('767', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('767', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('767', 'k', 'Series data for related item', 'Series data for related item', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('767', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('767', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2598,7 +2616,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('770', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('770', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('770', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('770', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('770', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('770', 'k', 'Series data for related item', 'Series data for related item', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('770', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('770', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2622,7 +2640,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('772', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('772', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('772', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('772', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('772', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('772', 'k', 'Series data for related item', 'Series data for related item', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('772', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('772', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2648,7 +2666,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('773', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('773', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('773', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('773', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('773', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('773', 'k', 'Series data for related item', 'Series data for related item', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('773', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('773', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2673,7 +2691,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('774', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('774', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('774', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('774', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('774', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('774', 'k', 'Series data for related item', 'Series data for related item', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('774', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('774', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2698,7 +2716,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('775', 'f', 'Country code', 'Country code', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('775', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('775', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('775', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('775', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('775', 'k', 'Series data for related item', 'Series data for related item', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('775', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('775', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2722,7 +2740,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('776', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('776', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('776', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('776', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('776', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('776', 'k', 'Series data for related item', 'Series data for related item', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('776', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('776', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2746,7 +2764,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('777', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('777', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('777', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('777', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('777', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('777', 'k', 'Series data for related item', 'Series data for related item', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('777', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('777', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2767,7 +2785,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('780', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('780', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('780', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('780', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('780', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('780', 'k', 'Series data for related item', 'Series data for related item', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('780', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('780', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2791,7 +2809,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('785', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('785', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('785', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('785', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('785', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('785', 'k', 'Series data for related item', 'Series data for related item', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('785', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('785', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2815,7 +2833,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('786', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('786', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('786', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('786', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('786', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('786', 'j', 'Period of content', 'Period of content', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('786', 'k', 'Series data for related item', 'Series data for related item', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('786', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2841,7 +2859,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('787', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('787', 'g', 'Related parts', 'Related parts', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('787', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('787', 'i', 'Relationship information', 'Relationship information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('787', 'i', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('787', 'k', 'Series data for related item', 'Series data for related item', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('787', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('787', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -3146,7 +3164,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('852', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('852', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('852', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), - ('852', '8', 'Sequence number', 'Sequence number', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), + ('852', '8', 'Sequence number', 'Sequence number', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('852', 'a', 'Location', 'Location', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('852', 'b', 'Sublocation or collection', 'Sublocation or collection', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('852', 'c', 'Shelving location', 'Shelving location', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), @@ -3157,9 +3175,9 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('852', 'h', 'Classification part', 'Classification part', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('852', 'i', 'Item part', 'Item part', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('852', 'j', 'Shelving control number', 'Shelving control number', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), - ('852', 'k', 'Call number prefix', 'Call number prefix', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), + ('852', 'k', 'Call number prefix', 'Call number prefix', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('852', 'l', 'Shelving form of title', 'Shelving form of title', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), - ('852', 'm', 'Call number suffix', 'Call number suffix', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), + ('852', 'm', 'Call number suffix', 'Call number suffix', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('852', 'n', 'Country code', 'Country code', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('852', 'p', 'Piece designation', 'Piece designation', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('852', 'q', 'Piece physical condition', 'Piece physical condition', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), -- 1.7.9.5