From f509955a7d6ed5f82341ceb1747e23b12c6c901c Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Mon, 1 Jul 2013 21:24:30 -0300 Subject: [PATCH] Bug 5858 - Update default MARC21 framework to Update No. 16 (April 2013) Content-Type: text/plain; charset=utf-8 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 | 521 +++++++++++-------- 1 files changed, 302 insertions(+), 219 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 e1c2b10..ff739f3 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, '', ''), @@ -225,15 +225,17 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('070', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 1, 0, NULL, ''), ('071', 'NATIONAL AGRICULTURAL LIBRARY COPY STATEMENT', 'NATIONAL AGRICULTURAL LIBRARY COPY STATEMENT', 1, 0, NULL, ''), ('072', 'SUBJECT CATEGORY CODE', 'SUBJECT CATEGORY CODE', 1, 0, NULL, ''), - ('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, ''), - ('084', 'OTHER CLASSIFICATION NUMBER', 'OTHER CLASSIFICATION NUMBER', 1, 0, NULL, ''), - ('085', 'SYNTHESIZED CLASSIFICATION NUMBER COMPONENTS', 'SYNTHESIZED CLASSIFICATION NUMBER COMPONENTS', 0, 1, 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, ''), + ('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, ''), + 1, 0, NULL, ''), +DDITIONAL DEWEY DECIMAL CLASSIFICATION NUMBER', 'ADDITIONAL DEWEY DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL, ''), + ('084', 'OTHER CLASSIFICATION NUMBER', 'OTHER CLASSIFICATION NUMBER', 1, 0, NULL, ''), +MBER', 1, 0, NULL, ''), +IZED 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, ''), ('090', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC)', 1, 0, '', ''), ('091', 'MICROFILM SHELF LOCATION (AM) [OBSOLETE]', 'MICROFILM SHELF LOCATION (AM) [OBSOLETE]', 0, 0, '', ''), ('092', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 'LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)', 1, 0, '', ''), @@ -257,19 +259,21 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('246', 'VARYING FORM OF TITLE', 'VARYING FORM OF TITLE', 1, 0, NULL, ''), ('247', 'FORMER TITLE', 'FORMER TITLE', 1, 0, NULL, ''), ('250', 'EDITION STATEMENT', 'EDITION STATEMENT', 1, 0, NULL, ''), - ('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, ''), + ('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, ''), + 0, 0, NULL, ''), +OUNTRY 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, ''), - ('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, ''), + ('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, ''), + 'PROJECTED PUBLICATION DATE', 0, 0, NULL, ''), +BUTION, 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, ''), ('301', 'PHYSICAL DESCRIPTION FOR FILMS (PRE-AACR 2) (VM) [OBSOLETE, USMARC]', 'PHYSICAL DESCRIPTION FOR FILMS (PRE-AACR 2) (VM) [OBSOLETE, USMARC]', 0, 0, NULL, ''), ('302', 'PAGE OR ITEM COUNT (BK AM) [OBSOLETE]', 'PAGE OR ITEM COUNT (BK AM) [OBSOLETE]', 0, 0, NULL, ''), ('303', 'UNIT COUNT (AM) [OBSOLETE, USMARC]', 'UNIT COUNT (AM) [OBSOLETE, USMARC]', 0, 0, NULL, ''), @@ -278,40 +282,54 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('306', 'PLAYING TIME', 'PLAYING TIME', 0, 0, NULL, ''), ('307', 'HOURS, ETC.', 'HOURS, ETC.', 1, 0, NULL, ''), ('308', 'PHYSICAL DESCRIPTION FOR FILMS (ARCHIVAL) (VM) [OBSOLETE]', 'PHYSICAL DESCRIPTION FOR FILMS (ARCHIVAL) (VM) [OBSOLETE]', 1, 0, NULL, ''), - ('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, ''), - ('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, ''), - ('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, ''), + ('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, ''), + 1, 0, NULL, ''), +ONTENT TYPE', 'CONTENT TYPE', 1, 0, NULL, ''), + 1, 0, NULL, ''), +EDIA TYPE', 'MEDIA TYPE', 1, 0, NULL, ''), + 1, 0, NULL, ''), +ARRIER 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, ''), + COORDINATE DATA', 1, 0, NULL, ''), +CS', 'SOUND CHARACTERISTICS', 1, 0, NULL, ''), + CHARACTERISTICS', 1, 0, NULL, ''), +RISTICS OF MOVING IMAGE', 'PROJECTION CHARACTERISTICS OF MOVING IMAGE', 1, 0, NULL, ''), + OF MOVING IMAGE', 1, 0, NULL, ''), +CS', 'VIDEO CHARACTERISTICS', 1, 0, NULL, ''), + CHARACTERISTICS', 1, 0, NULL, ''), +TERISTICS', '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, ''), ('355', 'SECURITY CLASSIFICATION CONTROL', 'SECURITY CLASSIFICATION CONTROL', 1, 0, NULL, ''), - ('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, ''), - ('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, ''), + ('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, ''), + 1, 0, NULL, ''), +ORMALIZED 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, ''), +NFORMATION', 1, 0, NULL, ''), +NGUAGE', 'ASSOCIATED LANGUAGE', 1, 0, NULL, ''), +D LANGUAGE', 1, 0, NULL, ''), +, 'FORM OF WORK', 1, 0, NULL, ''), +RM OF WORK', 1, 0, NULL, ''), +UISHING CHARACTERISTICS OF WORK OR EXPRESSION', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 1, 0, NULL, ''), +EXPRESSION', 1, 0, NULL, ''), +FORMANCE', 'MEDIUM OF PERFORMANCE', 1, 0, NULL, ''), +ERFORMANCE', 1, 0, NULL, ''), +NATION OF MUSICAL WORK', 'NUMERIC DESIGNATION OF MUSICAL WORK', 1, 0, NULL, ''), +SICAL WORK', 1, 0, NULL, ''), +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, ''), + ('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, ''), ('440', 'SERIES STATEMENT/ADDED ENTRY--TITLE', 'SERIES STATEMENT/ADDED ENTRY--TITLE', 1, 0, NULL, ''), ('490', 'SERIES STATEMENT', 'SERIES STATEMENT', 1, 0, '', ''), ('500', 'GENERAL NOTE', 'GENERAL NOTE', 1, 0, NULL, ''), @@ -338,8 +356,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, ''), @@ -347,12 +365,13 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('535', 'LOCATION OF ORIGINALS/DUPLICATES NOTE', 'LOCATION OF ORIGINALS/DUPLICATES NOTE', 1, 0, NULL, ''), ('536', 'FUNDING INFORMATION NOTE', 'FUNDING INFORMATION NOTE', 1, 0, NULL, ''), ('537', 'SOURCE OF DATA NOTE (CF) [OBSOLETE]', 'SOURCE OF DATA NOTE (CF) [OBSOLETE]', 0, 0, NULL, ''), - ('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, ''), - ('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, ''), + ('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, ''), + 1, 0, NULL, ''), +NFORMATION 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, ''), ('546', 'LANGUAGE NOTE', 'LANGUAGE NOTE', 1, 0, NULL, ''), ('547', 'FORMER TITLE COMPLEXITY NOTE', 'FORMER TITLE COMPLEXITY NOTE', 1, 0, NULL, ''), @@ -370,13 +389,14 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('581', 'PUBLICATIONS ABOUT DESCRIBED MATERIALS NOTE', 'PUBLICATIONS ABOUT DESCRIBED MATERIALS NOTE', 1, 0, NULL, ''), ('582', 'RELATED COMPUTER FILES NOTE (CF) [OBSOLETE]', 'RELATED COMPUTER FILES NOTE (CF) [OBSOLETE]', 1, 0, NULL, ''), ('583', 'ACTION NOTE', 'ACTION NOTE', 1, 0, NULL, ''), - ('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, ''), - ('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, ''), + ('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, ''), + 1, 0, NULL, ''), +OURCE 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, ''), ('611', 'SUBJECT ADDED ENTRY--MEETING NAME', 'SUBJECT ADDED ENTRY--MEETING NAME', 1, 0, NULL, ''), ('630', 'SUBJECT ADDED ENTRY--UNIFORM TITLE', 'SUBJECT ADDED ENTRY--UNIFORM TITLE', 1, 0, NULL, ''), ('648', 'SUBJECT ADDED ENTRY--CHRONOLOGICAL TERM', 'SUBJECT ADDED ENTRY--CHRONOLOGICAL TERM', 1, 0, NULL, ''), @@ -401,13 +421,14 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('710', 'ADDED ENTRY--CORPORATE NAME', 'ADDED ENTRY--CORPORATE NAME', 1, 0, NULL, ''), ('711', 'ADDED ENTRY--MEETING NAME', 'ADDED ENTRY--MEETING NAME', 1, 0, NULL, ''), ('715', 'ADDED ENTRY--CORPORATE NAME (PERFORMER) (MU) [OBSOLETE]', 'ADDED ENTRY--CORPORATE NAME (PERFORMER) (MU) [OBSOLETE]', 1, 0, NULL, ''), - ('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, ''), - ('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, ''), + ('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, ''), + 1, 0, NULL, ''), +DDED 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, ''), ('755', 'ADDED ENTRY--PHYSICAL CHARACTERISTICS [OBSOLETE]', 'ADDED ENTRY--PHYSICAL CHARACTERISTICS [OBSOLETE]', 1, 0, NULL, ''), ('760', 'MAIN SERIES ENTRY', 'MAIN SERIES ENTRY', 1, 0, NULL, ''), ('762', 'SUBSERIES ENTRY', 'SUBSERIES ENTRY', 1, 0, NULL, ''), @@ -459,13 +480,14 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('873', 'VARIANT UNIFORM TITLE HEADING (SE) [OBSOLETE]', 'VARIANT UNIFORM TITLE HEADING (SE) [OBSOLETE]', 1, 0, NULL, ''), ('876', 'ITEM INFORMATION--BASIC BIBLIOGRAPHIC UNIT', 'ITEM INFORMATION--BASIC BIBLIOGRAPHIC UNIT', 1, 0, NULL, ''), ('877', 'ITEM INFORMATION--SUPPLEMENTARY MATERIAL', 'ITEM INFORMATION--SUPPLEMENTARY MATERIAL', 1, 0, NULL, ''), - ('878', 'ITEM INFORMATION--INDEXES', 'ITEM INFORMATION--INDEXES', 1, 0, NULL, ''), - ('880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL, ''), + ('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, ''), - ('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, '', ''), + 0, 0, NULL, ''), +ACHINE-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, '', ''), ('897', 'LOCAL SERIES ADDED ENTRY--CORPORATE NAME (RLIN)', 'LOCAL SERIES ADDED ENTRY--CORPORATE NAME (RLIN)', 1, 0, '', ''), ('898', 'LOCAL SERIES ADDED ENTRY--MEETING NAME (RLIN)', 'LOCAL SERIES ADDED ENTRY--MEETING NAME (RLIN)', 1, 0, '', ''), ('899', 'LOCAL SERIES ADDED ENTRY--UNIFORM TITLE (RLIN)', 'LOCAL SERIES ADDED ENTRY--UNIFORM TITLE (RLIN)', 1, 0, '', ''), @@ -579,13 +601,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('026', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('026', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('026', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('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', '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), +', '', '', NULL), +', '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), + ('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), ('027', 'a', 'Standard technical report number', 'Standard technical report number', 0, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), ('027', 'z', 'Canceled/invalid number', 'Canceled/invalid number', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), ('028', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), @@ -688,7 +711,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 +751,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 +822,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 +1089,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 +1098,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), @@ -1086,12 +1109,13 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('256', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('256', 'a', 'Computer file characteristics', 'Computer file characteristics', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('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), - ('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), + ('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), +', '', '', NULL), +', '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), ('258', 'b', 'Denomination', 'Denomination', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('260', '3', 'Materials specified', 'Materials specified', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('260', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), @@ -1102,7 +1126,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 +1209,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 +1272,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 +1297,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,17 +1464,59 @@ 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), - ('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), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', '', '', NULL, -6, '', '', '', NULL), +NULL), +'', '', '', NULL, -6, '', '', '', NULL), + '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), +mber', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), +umber or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), +', 3, '', '', '', NULL, -6, '', '', '', NULL), + +', 3, '', '', '', NULL, -6, '', '', '', NULL), +erials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), + '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), +mber', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), +term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), +code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), +Demographic group term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), +Demographic group code', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), +umber or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), +', 3, '', '', '', NULL, -6, '', '', '', NULL), + +', 3, '', '', '', NULL, -6, '', '', '', NULL), +erials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), + '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), +mber', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), + 'Creator/contributor term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), + 'Creator/contributor code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), +Demographic group term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), +'', 3, '', '', '', NULL, -6, '', '', '', NULL), +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), ('400', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), ('400', 'a', 'Personal name', 'Personal name', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), ('400', 'b', 'Numeration', 'Numeration', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), @@ -1520,13 +1586,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('490', '3', 'Materials specified', 'Materials specified', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), ('490', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), ('490', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', NULL, NULL, -6, '', '', '', NULL), - ('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', '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), - ('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), +', '', '', NULL), +', '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), ('500', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('500', 'a', 'General note', 'General note', 0, 0, 'biblio.notes', 5, '', '', '', NULL, 0, '', '', '', NULL), ('500', 'l', 'Library of Congress call number (SE) [OBSOLETE]', 'Library of Congress call number (SE) [OBSOLETE]', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), @@ -1754,11 +1821,12 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('541', 'b', 'Address', 'Address', 0, 0, '', 5, '', '', '', NULL, 1, '', '', '', NULL), ('541', 'c', 'Method of acquisition', 'Method of acquisition', 0, 0, '', 5, '', '', '', NULL, 1, '', '', '', NULL), ('541', 'd', 'Date of acquisition', 'Date of acquisition', 0, 0, '', 5, '', '', '', NULL, 1, '', '', '', NULL), - ('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', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 5, '', '', '', NULL, 1, '', '', '', NULL), + ('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), +', '', '', NULL), +', '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), ('542', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), @@ -1902,7 +1970,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 +2141,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 +2539,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), @@ -2507,13 +2575,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('760', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('760', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL), ('760', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('760', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('760', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('760', 'q', 'Parallel title (BK SE) [OBSOLETE]', 'Parallel title (BK SE) [OBSOLETE]', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('760', 's', 'Uniform title', 'Uniform title', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('760', 't', 'Title', 'Title', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2527,13 +2596,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('762', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('762', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('762', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('762', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('762', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('762', 'q', 'Parallel title (BK SE) [OBSOLETE]', 'Parallel title (BK SE) [OBSOLETE]', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('762', 's', 'Uniform title', 'Uniform title', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('762', 't', 'Title', 'Title', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2547,13 +2617,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('765', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('765', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('765', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('765', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('765', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('765', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('765', 'q', 'Parallel title (BK SE) [OBSOLETE]', 'Parallel title (BK SE) [OBSOLETE]', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('765', 'r', 'Report number', 'Report number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2571,13 +2642,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('767', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('767', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('767', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('767', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('767', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('767', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('767', 'q', 'Parallel title (BK SE) [OBSOLETE]', 'Parallel title (BK SE) [OBSOLETE]', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('767', 'r', 'Report number', 'Report number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2595,13 +2667,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('770', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('770', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('770', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('770', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('770', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('770', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('770', 'q', 'Parallel title (BK SE) [OBSOLETE]', 'Parallel title (BK SE) [OBSOLETE]', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('770', 'r', 'Report number', 'Report number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2619,13 +2692,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('772', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('772', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('772', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('772', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('772', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('772', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('772', 'q', 'Parallel title (BK SE) [OBSOLETE]', 'Parallel title (BK SE) [OBSOLETE]', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('772', 'r', 'Report number', 'Report number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2645,13 +2719,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('773', '9', 'Host Itemnumber', 'Host Itemnumber', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('773', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('773', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('773', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('773', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('773', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('773', 'p', 'Abbreviated title', 'Abbreviated title', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('773', 'q', 'Enumeration and first page', 'Enumeration and first page', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), @@ -2670,13 +2745,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('774', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('774', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('774', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('774', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('774', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('774', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('774', 'r', 'Report number', 'Report number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('774', 's', 'Uniform title', 'Uniform title', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2695,13 +2771,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('775', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('775', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('775', 'e', 'Language code', 'Language code', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('775', 'f', 'Country code', 'Country code', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('775', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('775', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('775', 'q', 'Parallel title (BK SE) [OBSOLETE]', 'Parallel title (BK SE) [OBSOLETE]', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('775', 'r', 'Report number', 'Report number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2719,13 +2796,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('776', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('776', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('776', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('776', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('776', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('776', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('776', 'q', 'Parallel title (BK SE) [OBSOLETE]', 'Parallel title (BK SE) [OBSOLETE]', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('776', 'r', 'Report number', 'Report number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2743,13 +2821,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('777', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('777', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('777', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('777', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('777', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('777', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('777', 'q', 'Parallel title (BK SE) [OBSOLETE]', 'Parallel title (BK SE) [OBSOLETE]', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('777', 's', 'Uniform title', 'Uniform title', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2764,13 +2843,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('780', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('780', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('780', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('780', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('780', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('780', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('780', 'q', 'Parallel title (BK SE) [OBSOLETE]', 'Parallel title (BK SE) [OBSOLETE]', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('780', 'r', 'Report number', 'Report number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2788,13 +2868,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('785', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('785', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('785', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('785', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('785', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('785', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('785', 'q', 'Parallel title (BK SE) [OBSOLETE]', 'Parallel title (BK SE) [OBSOLETE]', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('785', 'r', 'Report number', 'Report number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2812,13 +2893,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('786', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('786', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('786', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('786', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('786', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('786', 'n', 'Note', 'Note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('786', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('786', 'p', 'Abbreviated title', 'Abbreviated title', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2838,13 +2920,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('787', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('787', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('787', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('787', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('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', '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), + ('787', 'h', 'Physical description', 'Physical description', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), +', '', '', NULL), +', '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), ('787', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('787', 'q', 'Parallel title (BK SE) [OBSOLETE]', 'Parallel title (BK SE) [OBSOLETE]', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('787', 'r', 'Report number', 'Report number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -3146,7 +3229,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 +3240,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.7.6