View | Details | Raw Unified | Return to bug 13322
Collapse All | Expand All

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql (-24 / +56 lines)
Lines 1-7 Link Here
1
-- *******************************************************
1
-- *******************************************************
2
--   KOHA  MARC 21 STANDARD DEFAULT AUTHORITY FRAMEWORKS
2
--   KOHA  MARC 21 STANDARD DEFAULT AUTHORITY FRAMEWORKS
3
--
3
--
4
--        Revised to Update No. 18 (April 2014)
4
--        Revised to Update No. 19 (October 2014)
5
-- *******************************************************
5
-- *******************************************************
6
6
7
-- ******************************************************
7
-- ******************************************************
Lines 181-186 INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l Link Here
181
		('', '384', 'KEY', 'KEY', 0, 0, NULL),
181
		('', '384', 'KEY', 'KEY', 0, 0, NULL),
182
        ('', '385', 'AUDIENCE CHARACTERISTICS', 'AUDIENCE CHARACTERISTICS', 1, 0, NULL),
182
        ('', '385', 'AUDIENCE CHARACTERISTICS', 'AUDIENCE CHARACTERISTICS', 1, 0, NULL),
183
        ('', '386', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 1, 0, NULL),
183
        ('', '386', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 1, 0, NULL),
184
        ('', '388', 'TIME PERIOD OF CREATION', 'TIME PERIOD OF CREATION', 1, 0, NULL),
184
		('', '400', 'SEE FROM TRACING--PERSONAL NAME', 'SEE FROM TRACING--PERSONAL NAME', 1, 0, NULL),
185
		('', '400', 'SEE FROM TRACING--PERSONAL NAME', 'SEE FROM TRACING--PERSONAL NAME', 1, 0, NULL),
185
		('', '410', 'SEE FROM TRACING--CORPORATE NAME', 'SEE FROM TRACING--CORPORATE NAME', 1, 0, NULL),
186
		('', '410', 'SEE FROM TRACING--CORPORATE NAME', 'SEE FROM TRACING--CORPORATE NAME', 1, 0, NULL),
186
		('', '411', 'SEE FROM TRACING--MEETING NAME', 'SEE FROM TRACING--MEETING NAME', 1, 0, NULL),
187
		('', '411', 'SEE FROM TRACING--MEETING NAME', 'SEE FROM TRACING--MEETING NAME', 1, 0, NULL),
Lines 577-583 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
577
		('', '100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
578
		('', '100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
578
		('', '100', 'e', 'Relator term', 'Relator term', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
579
		('', '100', 'e', 'Relator term', 'Relator term', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
579
		('', '100', 'f', 'Date of a work', 'Date of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
580
		('', '100', 'f', 'Date of a work', 'Date of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
580
		('', '100', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
581
		('', '100', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
581
		('', '100', 'h', 'Medium', 'Medium', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
582
		('', '100', 'h', 'Medium', 'Medium', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
582
		('', '100', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
583
		('', '100', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
583
		('', '100', 'k', 'Form subheading', 'Form subheading', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
584
		('', '100', 'k', 'Form subheading', 'Form subheading', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 602-608 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
602
		('', '110', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
603
		('', '110', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
603
		('', '110', 'e', 'Relator term', 'Relator term', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
604
		('', '110', 'e', 'Relator term', 'Relator term', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
604
		('', '110', 'f', 'Date of a work', 'Date of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
605
		('', '110', 'f', 'Date of a work', 'Date of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
605
		('', '110', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
606
		('', '110', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
606
		('', '110', 'h', 'Medium', 'Medium', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
607
		('', '110', 'h', 'Medium', 'Medium', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
607
		('', '110', 'k', 'Form subheading', 'Form subheading', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
608
		('', '110', 'k', 'Form subheading', 'Form subheading', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
608
		('', '110', 'l', 'Language of a work', 'Language of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
609
		('', '110', 'l', 'Language of a work', 'Language of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 625-631 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
625
		('', '111', 'd', 'Date of meeting', 'Date of meeting', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
626
		('', '111', 'd', 'Date of meeting', 'Date of meeting', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
626
		('', '111', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
627
		('', '111', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
627
		('', '111', 'f', 'Date of a work', 'Date of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
628
		('', '111', 'f', 'Date of a work', 'Date of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
628
		('', '111', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
629
		('', '111', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
629
		('', '111', 'h', 'Medium', 'Medium', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
630
		('', '111', 'h', 'Medium', 'Medium', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
630
		('', '111', 'j', 'Relator term', 'Relator term', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
631
		('', '111', 'j', 'Relator term', 'Relator term', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
631
		('', '111', 'k', 'Form subheading', 'Form subheading', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
632
		('', '111', 'k', 'Form subheading', 'Form subheading', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 644-650 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
644
		('', '130', 'a', 'Uniform title', 'Uniform title', 0, 0, 1, NULL, NULL, '''130o'',''130m'',''130r'',''130s'',''130d'',''130k'',''130n'',''130p'',''130g'',''130l'',''130f'',''130h'',''130t'',''130x'',''130z'',''130y'',''130v''', 0, 0, '', '', ''),
645
		('', '130', 'a', 'Uniform title', 'Uniform title', 0, 0, 1, NULL, NULL, '''130o'',''130m'',''130r'',''130s'',''130d'',''130k'',''130n'',''130p'',''130g'',''130l'',''130f'',''130h'',''130t'',''130x'',''130z'',''130y'',''130v''', 0, 0, '', '', ''),
645
		('', '130', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
646
		('', '130', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
646
		('', '130', 'f', 'Date of a work', 'Date of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
647
		('', '130', 'f', 'Date of a work', 'Date of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
647
		('', '130', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
648
		('', '130', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
648
		('', '130', 'h', 'Medium', 'Medium', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
649
		('', '130', 'h', 'Medium', 'Medium', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
649
		('', '130', 'k', 'Form subheading', 'Form subheading', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
650
		('', '130', 'k', 'Form subheading', 'Form subheading', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
650
		('', '130', 'l', 'Language of a work', 'Language of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
651
		('', '130', 'l', 'Language of a work', 'Language of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 698-703 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
698
		('', '148', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
699
		('', '148', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
699
        ('', '150', 'a', 'Topical term or geographic name entry element', 'Topical term or geographic name entry element', 0, 0, 1, NULL, NULL, '''150x'',''150z'',''150y'',''150v''', 0, 0, '', '', ''),
700
        ('', '150', 'a', 'Topical term or geographic name entry element', 'Topical term or geographic name entry element', 0, 0, 1, NULL, NULL, '''150x'',''150z'',''150y'',''150v''', 0, 0, '', '', ''),
700
        ('', '150', 'b', 'Topical term following geographic name entry element', 'Topical term following geographic name entry element', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
701
        ('', '150', 'b', 'Topical term following geographic name entry element', 'Topical term following geographic name entry element', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
702
        ('', '150', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
701
		('', '150', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
703
		('', '150', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
702
		('', '150', 'x', 'General subdivision', 'General subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
704
		('', '150', 'x', 'General subdivision', 'General subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
703
		('', '150', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
705
		('', '150', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 706-711 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
706
		('', '150', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
708
		('', '150', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
707
		('', '151', 'a', 'Geographic name', 'Geographic name', 0, 0, 1, NULL, NULL, '''151z'',''151x'',''151y'',''151v''', 0, 0, '', '', ''),
709
		('', '151', 'a', 'Geographic name', 'Geographic name', 0, 0, 1, NULL, NULL, '''151z'',''151x'',''151y'',''151v''', 0, 0, '', '', ''),
708
		('', '151', 'b', 'Name following place as an entry element {OBSOLETE]', 'Name following place as an entry element {OBSOLETE]', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
710
		('', '151', 'b', 'Name following place as an entry element {OBSOLETE]', 'Name following place as an entry element {OBSOLETE]', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
711
        ('', '151', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
709
		('', '151', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
712
		('', '151', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
710
		('', '151', 'x', 'General subdivision', 'General subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
713
		('', '151', 'x', 'General subdivision', 'General subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
711
		('', '151', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
714
		('', '151', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 937-949 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
937
        ('', '386', '3', 'Materials specified', 'Materials specified', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
940
        ('', '386', '3', 'Materials specified', 'Materials specified', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
938
        ('', '386', '6', 'Linkage', 'Linkage', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
941
        ('', '386', '6', 'Linkage', 'Linkage', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
939
        ('', '386', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
942
        ('', '386', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
943
        ('', '388', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
944
        ('', '388', '2', 'Source of term', 'Source of term', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
945
        ('', '388', '3', 'Materials specified', 'Materials specified', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
946
        ('', '388', '6', 'Linkage', 'Linkage', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
947
        ('', '388', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
948
        ('', '388', 'a', 'Time period of creation term', 'Time period of creation term', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
940
		('', '400', 'a', 'Personal name', 'Personal name', 0, 0, 4, NULL, NULL, '''400b'',''400c'',''400q'',''400d'',''400t'',''400o'',''400m'',''400r'',''400s'',''400k'',''400n'',''400p'',''400g'',''400l'',''400f'',''400h'',''400x'',''400z'',''400y'',''400v''', 0, 0, '', '', 'PERSO_NAME'),
949
		('', '400', 'a', 'Personal name', 'Personal name', 0, 0, 4, NULL, NULL, '''400b'',''400c'',''400q'',''400d'',''400t'',''400o'',''400m'',''400r'',''400s'',''400k'',''400n'',''400p'',''400g'',''400l'',''400f'',''400h'',''400x'',''400z'',''400y'',''400v''', 0, 0, '', '', 'PERSO_NAME'),
941
		('', '400', 'b', 'Numeration', 'Numeration', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
950
		('', '400', 'b', 'Numeration', 'Numeration', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
942
		('', '400', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
951
		('', '400', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
943
		('', '400', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
952
		('', '400', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
944
		('', '400', 'e', 'Relator term', 'Relator term', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
953
		('', '400', 'e', 'Relator term', 'Relator term', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
945
		('', '400', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
954
		('', '400', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
946
		('', '400', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
955
		('', '400', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
947
		('', '400', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
956
		('', '400', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
948
		('', '400', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
957
		('', '400', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
949
		('', '400', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
958
		('', '400', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 973-979 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
973
		('', '410', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
982
		('', '410', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
974
		('', '410', 'e', 'Relator term', 'Relator term', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
983
		('', '410', 'e', 'Relator term', 'Relator term', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
975
		('', '410', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
984
		('', '410', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
976
		('', '410', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
985
		('', '410', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
977
		('', '410', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
986
		('', '410', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
978
		('', '410', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
987
		('', '410', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
979
		('', '410', 'k', 'Form subheading', 'Form subheading', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
988
		('', '410', 'k', 'Form subheading', 'Form subheading', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1001-1007 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1001
		('', '411', 'd', 'Date of meeting', 'Date of meeting', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1010
		('', '411', 'd', 'Date of meeting', 'Date of meeting', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1002
		('', '411', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1011
		('', '411', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1003
		('', '411', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1012
		('', '411', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1004
		('', '411', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1013
		('', '411', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1005
		('', '411', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1014
		('', '411', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1006
		('', '411', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1015
		('', '411', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1007
		('', '411', 'j', 'Relator term', 'Relator term', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1016
		('', '411', 'j', 'Relator term', 'Relator term', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1025-1031 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1025
		('', '430', 'a', 'Uniform title', 'Uniform title', 0, 0, 4, NULL, NULL, '''430o'',''430m'',''430r'',''430s'',''430d'',''430k'',''430n'',''430p'',''430g'',''430l'',''430f'',''430h'',''430t'',''430x'',''430z'',''430y'',''430v''', 0, 0, '', '', 'UNIF_TITLE'),
1034
		('', '430', 'a', 'Uniform title', 'Uniform title', 0, 0, 4, NULL, NULL, '''430o'',''430m'',''430r'',''430s'',''430d'',''430k'',''430n'',''430p'',''430g'',''430l'',''430f'',''430h'',''430t'',''430x'',''430z'',''430y'',''430v''', 0, 0, '', '', 'UNIF_TITLE'),
1026
		('', '430', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1035
		('', '430', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1027
		('', '430', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1036
		('', '430', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1028
		('', '430', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1037
		('', '430', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1029
		('', '430', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1038
		('', '430', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1030
		('', '430', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1039
		('', '430', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1031
		('', '430', 'k', 'Form subheading', 'Form subheading', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1040
		('', '430', 'k', 'Form subheading', 'Form subheading', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1061-1066 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1061
		('', '448', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 4, NULL, NULL, NULL, 0, 1, '', '', ''),
1070
		('', '448', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 4, NULL, NULL, NULL, 0, 1, '', '', ''),
1062
		('', '450', 'a', 'Topical term or geographic name entry element', 'Topical term or geographic name entry element', 0, 0, 4, NULL, NULL, '''450x'',''450z'',''450y'',''450v''', 0, 0, '', '', 'TOPIC_TERM'),
1071
		('', '450', 'a', 'Topical term or geographic name entry element', 'Topical term or geographic name entry element', 0, 0, 4, NULL, NULL, '''450x'',''450z'',''450y'',''450v''', 0, 0, '', '', 'TOPIC_TERM'),
1063
		('', '450', 'b', 'Topical term following geographic name entry element', 'Topical term following geographic name entry element', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1072
		('', '450', 'b', 'Topical term following geographic name entry element', 'Topical term following geographic name entry element', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1073
        ('', '450', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1064
		('', '450', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1074
		('', '450', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1065
		('', '450', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1075
		('', '450', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1066
		('', '450', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1076
		('', '450', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1074-1079 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1074
		('', '450', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 4, NULL, NULL, NULL, 0, 1, '', '', ''),
1084
		('', '450', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 4, NULL, NULL, NULL, 0, 1, '', '', ''),
1075
		('', '451', 'a', 'Geographic name', 'Geographic name', 0, 0, 4, NULL, NULL, '''451z'',''451x'',''451y'',''451v''', 0, 0, '', '', 'GEOGR_NAME'),
1085
		('', '451', 'a', 'Geographic name', 'Geographic name', 0, 0, 4, NULL, NULL, '''451z'',''451x'',''451y'',''451v''', 0, 0, '', '', 'GEOGR_NAME'),
1076
		('', '451', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1086
		('', '451', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1087
        ('', '451', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1077
		('', '451', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1088
		('', '451', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1078
		('', '451', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1089
		('', '451', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1079
		('', '451', 'x', 'General subdivision', 'General subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
1090
		('', '451', 'x', 'General subdivision', 'General subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1162-1168 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1162
		('', '500', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1173
		('', '500', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1163
		('', '500', 'e', 'Relator term', 'Relator term', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1174
		('', '500', 'e', 'Relator term', 'Relator term', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1164
		('', '500', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1175
		('', '500', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1165
		('', '500', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1176
		('', '500', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1166
		('', '500', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1177
		('', '500', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1167
		('', '500', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1178
		('', '500', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1168
		('', '500', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1179
		('', '500', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1193-1199 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1193
		('', '510', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1204
		('', '510', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1194
		('', '510', 'e', 'Relator term', 'Relator term', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1205
		('', '510', 'e', 'Relator term', 'Relator term', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1195
		('', '510', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1206
		('', '510', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1196
		('', '510', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1207
		('', '510', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1197
		('', '510', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1208
		('', '510', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1198
		('', '510', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1209
		('', '510', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1199
		('', '510', 'k', 'Form subheading', 'Form subheading', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1210
		('', '510', 'k', 'Form subheading', 'Form subheading', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1221-1227 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1221
		('', '511', 'd', 'Date of meeting', 'Date of meeting', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1232
		('', '511', 'd', 'Date of meeting', 'Date of meeting', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1222
		('', '511', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1233
		('', '511', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1223
		('', '511', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1234
		('', '511', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1224
		('', '511', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1235
		('', '511', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1225
		('', '511', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1236
		('', '511', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1226
		('', '511', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1237
		('', '511', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1227
		('', '511', 'j', 'Relator term', 'Relator term', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1238
		('', '511', 'j', 'Relator term', 'Relator term', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1246-1252 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1246
		('', '530', 'a', 'Uniform title', 'Uniform title', 0, 0, 5, NULL, NULL, '''530o'',''530m'',''530r'',''530s'',''530d'',''530k'',''530n'',''530p'',''530g'',''530l'',''530f'',''530h'',''530t'',''530x'',''530z'',''530y'',''530v''', 0, 0, '', '', 'UNIF_TITLE'),
1257
		('', '530', 'a', 'Uniform title', 'Uniform title', 0, 0, 5, NULL, NULL, '''530o'',''530m'',''530r'',''530s'',''530d'',''530k'',''530n'',''530p'',''530g'',''530l'',''530f'',''530h'',''530t'',''530x'',''530z'',''530y'',''530v''', 0, 0, '', '', 'UNIF_TITLE'),
1247
		('', '530', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1258
		('', '530', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1248
		('', '530', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1259
		('', '530', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1249
		('', '530', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1260
		('', '530', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1250
		('', '530', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1261
		('', '530', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1251
		('', '530', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1262
		('', '530', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1252
		('', '530', 'k', 'Form subheading', 'Form subheading', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1263
		('', '530', 'k', 'Form subheading', 'Form subheading', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1284-1289 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1284
		('', '548', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 5, NULL, NULL, NULL, 0, 1, '', '', ''),
1295
		('', '548', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 5, NULL, NULL, NULL, 0, 1, '', '', ''),
1285
		('', '550', 'a', 'Topical term or geographic name entry element', 'Topical term or geographic name entry element', 0, 0, 5, NULL, NULL, '''550x'',''550z'',''550y'',''550v''', 0, 0, '', '', 'TOPIC_TERM'),
1296
		('', '550', 'a', 'Topical term or geographic name entry element', 'Topical term or geographic name entry element', 0, 0, 5, NULL, NULL, '''550x'',''550z'',''550y'',''550v''', 0, 0, '', '', 'TOPIC_TERM'),
1286
		('', '550', 'b', 'Topical term following geographic name entry element', 'Topical term following geographic name entry element', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1297
		('', '550', 'b', 'Topical term following geographic name entry element', 'Topical term following geographic name entry element', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1298
        ('', '550', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1287
		('', '550', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1299
		('', '550', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1288
		('', '550', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1300
		('', '550', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1289
		('', '550', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1301
		('', '550', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1297-1302 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1297
		('', '550', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1309
		('', '550', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1298
		('', '550', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 5, NULL, NULL, NULL, 0, 1, '', '', ''),
1310
		('', '550', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 5, NULL, NULL, NULL, 0, 1, '', '', ''),
1299
		('', '551', 'a', 'Geographic name', 'Geographic name', 0, 0, 5, NULL, NULL, '''551z'',''551x'',''551y'',''551v''', 0, 0, '', '', 'GEOGR_NAME'),
1311
		('', '551', 'a', 'Geographic name', 'Geographic name', 0, 0, 5, NULL, NULL, '''551z'',''551x'',''551y'',''551v''', 0, 0, '', '', 'GEOGR_NAME'),
1312
        ('', '551', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1300
		('', '551', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1313
		('', '551', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1301
		('', '551', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1314
		('', '551', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1302
		('', '551', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1315
		('', '551', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1524-1532 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1524
		('', '700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1537
		('', '700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1525
		('', '700', 'e', 'Relator term', 'Relator term', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1538
		('', '700', 'e', 'Relator term', 'Relator term', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1526
		('', '700', 'f', 'Date of a work', 'Date of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1539
		('', '700', 'f', 'Date of a work', 'Date of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1527
		('', '700', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1540
		('', '700', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1528
		('', '700', 'h', 'Medium', 'Medium', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1541
		('', '700', 'h', 'Medium', 'Medium', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1529
		('', '700', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1542
		('', '700', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1530
		('', '700', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1543
		('', '700', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1531
		('', '700', 'k', 'Form subheading', 'Form subheading', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1544
		('', '700', 'k', 'Form subheading', 'Form subheading', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1532
		('', '700', 'l', 'Language of a work', 'Language of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1545
		('', '700', 'l', 'Language of a work', 'Language of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1546-1552 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1546
		('', '700', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1559
		('', '700', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1547
		('', '700', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1560
		('', '700', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1548
		('', '700', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1561
		('', '700', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1549
		('', '700', '4', 'Relator code', 'Relator code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1562
		('', '700', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1550
		('', '700', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1563
		('', '700', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1551
		('', '700', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1564
		('', '700', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1552
		('', '700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1565
		('', '700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1556-1564 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1556
		('', '710', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1569
		('', '710', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1557
		('', '710', 'e', 'Relator term', 'Relator term', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1570
		('', '710', 'e', 'Relator term', 'Relator term', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1558
		('', '710', 'f', 'Date of a work', 'Date of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1571
		('', '710', 'f', 'Date of a work', 'Date of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1559
		('', '710', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1572
		('', '710', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1560
		('', '710', 'h', 'Medium', 'Medium', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1573
		('', '710', 'h', 'Medium', 'Medium', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1561
		('', '710', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1574
		('', '710', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1562
		('', '710', 'k', 'Form subheading', 'Form subheading', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1575
		('', '710', 'k', 'Form subheading', 'Form subheading', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1563
		('', '710', 'l', 'Language of a work', 'Language of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1576
		('', '710', 'l', 'Language of a work', 'Language of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1564
		('', '710', 'm', 'Medium of performance for music', 'Medium of performance for music', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1577
		('', '710', 'm', 'Medium of performance for music', 'Medium of performance for music', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1576-1582 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1576
		('', '710', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1589
		('', '710', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1577
		('', '710', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1590
		('', '710', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1578
		('', '710', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1591
		('', '710', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1579
		('', '710', '4', 'Relator code', 'Relator code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1592
		('', '710', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1580
		('', '710', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1593
		('', '710', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1581
		('', '710', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1594
		('', '710', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1582
		('', '710', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1595
		('', '710', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1611-1619 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1611
		('', '730', 'a', 'Uniform title', 'Uniform title', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1624
		('', '730', 'a', 'Uniform title', 'Uniform title', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1612
		('', '730', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1625
		('', '730', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1613
		('', '730', 'f', 'Date of a work', 'Date of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1626
		('', '730', 'f', 'Date of a work', 'Date of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1614
		('', '730', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1627
		('', '730', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1615
		('', '730', 'h', 'Medium', 'Medium', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1628
		('', '730', 'h', 'Medium', 'Medium', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1616
		('', '730', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1629
		('', '730', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1617
		('', '730', 'k', 'Form subheading', 'Form subheading', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1630
		('', '730', 'k', 'Form subheading', 'Form subheading', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1618
		('', '730', 'l', 'Language of a work', 'Language of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1631
		('', '730', 'l', 'Language of a work', 'Language of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1619
		('', '730', 'm', 'Medium of performance for music', 'Medium of performance for music', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1632
		('', '730', 'm', 'Medium of performance for music', 'Medium of performance for music', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1631-1640 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1631
		('', '730', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1644
		('', '730', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1632
		('', '730', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1645
		('', '730', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1633
		('', '730', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1646
		('', '730', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1647
		('', '730', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1634
		('', '730', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1648
		('', '730', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1635
		('', '730', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1649
		('', '730', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1636
		('', '730', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1650
		('', '730', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1637
		('', '748', 'a', 'Chronological term', 'Chronological term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1651
		('', '748', 'a', 'Chronological term', 'Chronological term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1652
		('', '748', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1638
		('', '748', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1653
		('', '748', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1639
		('', '748', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1654
		('', '748', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1640
		('', '748', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1655
		('', '748', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1643-1648 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1643
		('', '748', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1658
		('', '748', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1644
		('', '748', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1659
		('', '748', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1645
		('', '748', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1660
		('', '748', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1661
		('', '748', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1646
		('', '748', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1662
		('', '748', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1647
		('', '748', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1663
		('', '748', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1648
		('', '748', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1664
		('', '748', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1650-1656 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1650
        ('', '750', 'b', 'Topical term following geographic name entry element', 'Topical term following geographic name entry element', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1666
        ('', '750', 'b', 'Topical term following geographic name entry element', 'Topical term following geographic name entry element', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1651
		('', '750', 'c', 'Location of event', 'Location of event', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1667
		('', '750', 'c', 'Location of event', 'Location of event', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1652
		('', '750', 'd', 'Active date', 'Active date', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1668
		('', '750', 'd', 'Active date', 'Active date', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1653
		('', '750', 'i', 'Explanatory text [CLASSIFICATION FORMAT]', 'Explanatory text [CLASSIFICATION FORMAT]', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1669
        ('', '750', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1670
		('', '750', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1654
		('', '750', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1671
		('', '750', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1655
		('', '750', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1672
		('', '750', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1656
		('', '750', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1673
		('', '750', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1659-1669 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1659
		('', '750', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1676
		('', '750', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1660
		('', '750', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1677
		('', '750', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1661
		('', '750', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1678
		('', '750', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1679
		('', '750', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1662
		('', '750', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1680
		('', '750', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1663
		('', '750', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1681
		('', '750', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1664
		('', '750', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1682
		('', '750', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1665
		('', '751', 'a', 'Geographic name', 'Geographic name', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1683
		('', '751', 'a', 'Geographic name', 'Geographic name', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1666
		('', '751', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1684
        ('', '751', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1685
		('', '751', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1667
		('', '751', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1686
		('', '751', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1668
		('', '751', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1687
		('', '751', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1669
		('', '751', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1688
		('', '751', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1672-1677 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1672
		('', '751', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1691
		('', '751', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1673
		('', '751', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1692
		('', '751', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1674
		('', '751', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1693
		('', '751', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1694
		('', '751', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1675
		('', '751', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1695
		('', '751', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1676
		('', '751', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1696
		('', '751', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1677
		('', '751', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1697
		('', '751', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1697-1702 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1697
		('', '754', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1717
		('', '754', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1698
		('', '754', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1718
		('', '754', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1699
		('', '755', 'a', 'Genre/form term as entry element', 'Genre/form term as entry element', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1719
		('', '755', 'a', 'Genre/form term as entry element', 'Genre/form term as entry element', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1720
		('', '755', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1700
		('', '755', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1721
		('', '755', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1701
		('', '755', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1722
		('', '755', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1702
		('', '755', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1723
		('', '755', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1704-1709 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1704
		('', '755', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1725
		('', '755', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1705
		('', '755', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1726
		('', '755', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1706
		('', '755', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1727
		('', '755', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1728
		('', '755', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1707
		('', '755', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1729
		('', '755', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1708
		('', '755', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1730
		('', '755', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1709
		('', '755', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1731
		('', '755', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1721-1731 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1721
		('', '761', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1743
		('', '761', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1722
		('', '761', '8', 'Field link and sequence number', 'Field link and sequence number', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1744
		('', '761', '8', 'Field link and sequence number', 'Field link and sequence number', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1723
        ('', '762', 'a', 'Medium of performance term as entry element', 'Medium of performance term as entry element', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1745
        ('', '762', 'a', 'Medium of performance term as entry element', 'Medium of performance term as entry element', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1724
		('', '762', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1746
		('', '762', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1725
        ('', '762', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1747
        ('', '762', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1726
		('', '762', 'z', 'Table number', 'Table number', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1748
		('', '762', 'z', 'Table number', 'Table number', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1727
        ('', '762', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1749
        ('', '762', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1728
        ('', '762', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1750
        ('', '762', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1751
        ('', '762', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1729
        ('', '762', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1752
        ('', '762', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1730
		('', '762', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1753
		('', '762', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1731
		('', '762', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1754
		('', '762', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1780-1785 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1780
		('', '768', 'z', 'Table identification--Table number', 'Table identification--Table number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1803
		('', '768', 'z', 'Table identification--Table number', 'Table identification--Table number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1781
		('', '768', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1804
		('', '768', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1782
		('', '768', '8', 'Field link and sequence number', 'Field link and sequence number', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1805
		('', '768', '8', 'Field link and sequence number', 'Field link and sequence number', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1806
		('', '780', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1783
		('', '780', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1807
		('', '780', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1784
		('', '780', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1808
		('', '780', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1785
		('', '780', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1809
		('', '780', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1787-1795 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1787
		('', '780', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1811
		('', '780', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1788
		('', '780', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1812
		('', '780', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1789
		('', '780', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1813
		('', '780', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1814
		('', '780', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1790
		('', '780', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1815
		('', '780', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1791
		('', '780', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1816
		('', '780', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1792
		('', '780', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1817
		('', '780', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1818
		('', '781', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1793
		('', '781', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1819
		('', '781', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1794
		('', '781', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1820
		('', '781', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1795
		('', '781', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1821
		('', '781', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1797-1805 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1797
		('', '781', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1823
		('', '781', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1798
		('', '781', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1824
		('', '781', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1799
		('', '781', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1825
		('', '781', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1826
		('', '781', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1800
		('', '781', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1827
		('', '781', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1801
		('', '781', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1828
		('', '781', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1802
		('', '781', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1829
		('', '781', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1830
		('', '782', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1803
		('', '782', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1831
		('', '782', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1804
		('', '782', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1832
		('', '782', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1805
		('', '782', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1833
		('', '782', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1807-1815 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1807
		('', '782', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1835
		('', '782', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1808
		('', '782', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1836
		('', '782', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1809
		('', '782', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1837
		('', '782', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1838
		('', '782', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1810
		('', '782', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1839
		('', '782', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1811
		('', '782', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1840
		('', '782', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1812
		('', '782', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1841
		('', '782', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1842
		('', '785', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1813
		('', '785', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1843
		('', '785', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1814
		('', '785', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1844
		('', '785', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1815
		('', '785', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1845
		('', '785', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1817-1822 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1817
		('', '785', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1847
		('', '785', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1818
		('', '785', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1848
		('', '785', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1819
		('', '785', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1849
		('', '785', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1850
		('', '785', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1820
		('', '785', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1851
		('', '785', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1821
		('', '785', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1852
		('', '785', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1822
		('', '785', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1853
		('', '785', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1824-1829 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1824
		('', '788', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1855
		('', '788', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1825
		('', '788', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1856
		('', '788', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1826
		('', '788', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1857
		('', '788', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1858
		('', '788', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1827
		('', '788', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1859
		('', '788', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1828
		('', '788', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1860
		('', '788', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1829
		('', '788', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1861
		('', '788', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-23 / +44 lines)
Lines 7-13 Link Here
7
--                    guided by Paul POULAIN
7
--                    guided by Paul POULAIN
8
--                      by thd for LibLime
8
--                      by thd for LibLime
9
--
9
--
10
--           Revised to Update No. 18 (April 2014)
10
--           Revised to Update No. 19 (October 2014)
11
-- *************************************************************
11
-- *************************************************************
12
12
13
13
Lines 299-304 INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, Link Here
299
        ('363', 'NORMALIZED DATE AND SEQUENTIAL DESIGNATION', 'NORMALIZED DATE AND SEQUENTIAL DESIGNATION', 1, 0, NULL, ''),
299
        ('363', 'NORMALIZED DATE AND SEQUENTIAL DESIGNATION', 'NORMALIZED DATE AND SEQUENTIAL DESIGNATION', 1, 0, NULL, ''),
300
		('365', 'TRADE PRICE', 'TRADE PRICE', 1, 0, NULL, ''),
300
		('365', 'TRADE PRICE', 'TRADE PRICE', 1, 0, NULL, ''),
301
		('366', 'TRADE AVAILABILITY INFORMATION', 'TRADE AVAILABILITY INFORMATION', 1, 0, NULL, ''),
301
		('366', 'TRADE AVAILABILITY INFORMATION', 'TRADE AVAILABILITY INFORMATION', 1, 0, NULL, ''),
302
        ('370', 'ASSOCIATED PLACE', 'ASSOCIATED PLACE', 1, 0, NULL, ''),
302
        ('377', 'ASSOCIATED LANGUAGE', 'ASSOCIATED LANGUAGE', 1, 0, NULL, ''),
303
        ('377', 'ASSOCIATED LANGUAGE', 'ASSOCIATED LANGUAGE', 1, 0, NULL, ''),
303
        ('380', 'FORM OF WORK', 'FORM OF WORK', 1, 0, NULL, ''),
304
        ('380', 'FORM OF WORK', 'FORM OF WORK', 1, 0, NULL, ''),
304
        ('381', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 1, 0, NULL, ''),
305
        ('381', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 1, 0, NULL, ''),
Lines 307-312 INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, Link Here
307
        ('384', 'KEY', 'KEY', 0, 0, NULL, ''),
308
        ('384', 'KEY', 'KEY', 0, 0, NULL, ''),
308
        ('385', 'AUDIENCE CHARACTERISTICS', 'AUDIENCE CHARACTERISTICS', 1, 0, NULL, ''),
309
        ('385', 'AUDIENCE CHARACTERISTICS', 'AUDIENCE CHARACTERISTICS', 1, 0, NULL, ''),
309
        ('386', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 1, 0, NULL, ''),
310
        ('386', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 1, 0, NULL, ''),
311
        ('388', 'TIME PERIOD OF CREATION', 'TIME PERIOD OF CREATION', 1, 0, NULL, ''),
310
		('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, ''),
312
		('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, ''),
311
		('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, ''),
313
		('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, ''),
312
		('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, ''),
314
		('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, ''),
Lines 902-908 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
902
		('100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
904
		('100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
903
		('100', 'e', 'Relator term', 'Relator term', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
905
		('100', 'e', 'Relator term', 'Relator term', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
904
		('100', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
906
		('100', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
905
		('100', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
907
		('100', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
906
		('100', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
908
		('100', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
907
		('100', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
909
		('100', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
908
		('100', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
910
		('100', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
Lines 922-928 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
922
		('110', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, '', 1, '', '', '', NULL, -1, '', '', '', NULL),
924
		('110', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, '', 1, '', '', '', NULL, -1, '', '', '', NULL),
923
		('110', 'e', 'Relator term', 'Relator term', 1, 0, '', 1, '', '', '', NULL, 0, '', '', '', NULL),
925
		('110', 'e', 'Relator term', 'Relator term', 1, 0, '', 1, '', '', '', NULL, 0, '', '', '', NULL),
924
		('110', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
926
		('110', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
925
		('110', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
927
		('110', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
926
		('110', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
928
		('110', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
927
		('110', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
929
		('110', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
928
		('110', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
930
		('110', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
Lines 940-946 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
940
		('111', 'd', 'Date of meeting', 'Date of meeting', 0, 0, NULL, 1, NULL, NULL, '', NULL, 0, '', '', '', NULL),
942
		('111', 'd', 'Date of meeting', 'Date of meeting', 0, 0, NULL, 1, NULL, NULL, '', NULL, 0, '', '', '', NULL),
941
		('111', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, NULL, 1, NULL, NULL, '', NULL, 0, '', '', '', NULL),
943
		('111', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, NULL, 1, NULL, NULL, '', NULL, 0, '', '', '', NULL),
942
		('111', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
944
		('111', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
943
		('111', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
945
		('111', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
944
		('111', 'j', 'Relator term', 'Relator term', 1, 0, NULL, 1, NULL, NULL, '', NULL, 0, '', '', '', NULL),
946
		('111', 'j', 'Relator term', 'Relator term', 1, 0, NULL, 1, NULL, NULL, '', NULL, 0, '', '', '', NULL),
945
		('111', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
947
		('111', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
946
		('111', 'l', 'Language of a work', 'Language of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
948
		('111', 'l', 'Language of a work', 'Language of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
Lines 956-962 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
956
		('130', 'a', 'Uniform title', 'Uniform title', 0, 0, NULL, 1, NULL, 'UNIF_TITLE', '', NULL, -1, '', '''130o'',''130m'',''130r'',''130s'',''130d'',''130k'',''130n'',''130p'',''130g'',''130l'',''130f'',''130h'',''130t''', '', NULL),
958
		('130', 'a', 'Uniform title', 'Uniform title', 0, 0, NULL, 1, NULL, 'UNIF_TITLE', '', NULL, -1, '', '''130o'',''130m'',''130r'',''130s'',''130d'',''130k'',''130n'',''130p'',''130g'',''130l'',''130f'',''130h'',''130t''', '', NULL),
957
		('130', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
959
		('130', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
958
		('130', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
960
		('130', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
959
		('130', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
961
		('130', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
960
		('130', 'h', 'Medium', 'Medium', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
962
		('130', 'h', 'Medium', 'Medium', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
961
		('130', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
963
		('130', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
962
		('130', 'l', 'Language of a work', 'Language of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -1, '', '', '', NULL),
964
		('130', 'l', 'Language of a work', 'Language of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -1, '', '', '', NULL),
Lines 989-995 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
989
		('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, '', '', '', NULL),
991
		('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, '', '', '', NULL),
990
		('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
992
		('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
991
		('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
993
		('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
992
		('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
994
		('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
993
		('240', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL),
995
		('240', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL),
994
		('240', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
996
		('240', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
995
		('240', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL),
997
		('240', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL),
Lines 1018-1024 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1018
		('243', 'a', 'Uniform title', 'Unifor title', 0, 0, '', 2, '', '', '', 1, -1, '', '', '', NULL),
1020
		('243', 'a', 'Uniform title', 'Unifor title', 0, 0, '', 2, '', '', '', 1, -1, '', '', '', NULL),
1019
		('243', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
1021
		('243', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
1020
		('243', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
1022
		('243', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
1021
		('243', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
1023
		('243', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
1022
		('243', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL),
1024
		('243', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL),
1023
		('243', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
1025
		('243', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
1024
		('243', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL),
1026
		('243', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL),
Lines 1050-1056 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1050
		('246', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1052
		('246', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1051
		('246', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1053
		('246', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1052
		('246', 'f', 'Date or sequential designation', 'Date or sequential designation', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1054
		('246', 'f', 'Date or sequential designation', 'Date or sequential designation', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1053
		('246', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1055
		('246', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1054
		('246', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, -1, '', '', '', NULL),
1056
		('246', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, -1, '', '', '', NULL),
1055
		('246', 'i', 'Display text', 'Display text', 0, 0, '', 2, '', '', '', NULL, -1, '', '', '', NULL),
1057
		('246', 'i', 'Display text', 'Display text', 0, 0, '', 2, '', '', '', NULL, -1, '', '', '', NULL),
1056
		('246', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1058
		('246', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
Lines 1062-1068 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1062
		('247', 'd', 'Designation of section (SE) [OBSOLETE]', 'Designation of section (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1064
		('247', 'd', 'Designation of section (SE) [OBSOLETE]', 'Designation of section (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1063
		('247', 'e', 'Name of part/section (SE) [OBSOLETE]', 'Name of part/section (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1065
		('247', 'e', 'Name of part/section (SE) [OBSOLETE]', 'Name of part/section (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1064
		('247', 'f', 'Date or sequential designation', 'Date or sequential designation', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1066
		('247', 'f', 'Date or sequential designation', 'Date or sequential designation', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1065
		('247', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1067
		('247', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1066
		('247', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, -1, '', '', '', NULL),
1068
		('247', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, -1, '', '', '', NULL),
1067
		('247', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1069
		('247', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1068
		('247', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1070
		('247', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
Lines 1411-1421 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1411
		('366', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 3, '', '', '', NULL, -1, '', '', '', NULL),
1413
		('366', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 3, '', '', '', NULL, -1, '', '', '', NULL),
1412
		('366', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 3, '', '', '', NULL, -1, '', '', '', NULL),
1414
		('366', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 3, '', '', '', NULL, -1, '', '', '', NULL),
1413
		('366', 'm', 'Identification of agency', 'Identification of agency', 0, 0, '', 3, '', '', '', NULL, -1, '', '', '', NULL),
1415
		('366', 'm', 'Identification of agency', 'Identification of agency', 0, 0, '', 3, '', '', '', NULL, -1, '', '', '', NULL),
1414
        ('377', 'l', 'Language term', 'Language term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1416
        ('370', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1417
        ('370', '2', 'Source of term', 'Source of term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1418
        ('370', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1419
        ('370', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1420
        ('370', 'c', 'Associated country', 'Associated country', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1421
        ('370', 'f', 'Other associated place', 'Other associated place', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1422
        ('370', 'g', 'Place of origin of work', 'Place of origin of work', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1423
        ('370', 's', 'Start period', 'Start period', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1424
        ('370', 't', 'End period', 'End period', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1425
        ('370', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1426
        ('370', 'v', 'Source of information', 'Source of information', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1415
        ('377', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1427
        ('377', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1416
        ('377', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1428
        ('377', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1417
        ('377', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1429
        ('377', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1418
        ('377', 'a', 'Language code', 'Language code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1430
        ('377', 'a', 'Language code', 'Language code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1431
        ('377', 'l', 'Language term', 'Language term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1419
        ('380', '0', 'Record control number', 'Record control number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1432
        ('380', '0', 'Record control number', 'Record control number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1420
        ('380', '2', 'Source of term', 'Source of term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1433
        ('380', '2', 'Source of term', 'Source of term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1421
        ('380', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1434
        ('380', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
Lines 1437-1443 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1437
        ('382', 'd', 'Doubling instrument', 'Doubling instrument', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1450
        ('382', 'd', 'Doubling instrument', 'Doubling instrument', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1438
        ('382', 'n', 'Number of performers of the same medium', 'Number of performers of the same medium', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1451
        ('382', 'n', 'Number of performers of the same medium', 'Number of performers of the same medium', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1439
        ('382', 'p', 'Alternative medium of performance', 'Alternative medium of performance', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1452
        ('382', 'p', 'Alternative medium of performance', 'Alternative medium of performance', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1440
        ('382', 's', 'Total number of performers', 'Total number of performers', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1453
        ('382', 's', 'Total number of performers', 'Total number of performers', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1441
        ('382', 'v', 'Note', 'Note', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1454
        ('382', 'v', 'Note', 'Note', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1442
        ('383', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1455
        ('383', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1443
        ('383', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1456
        ('383', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
Lines 1468-1473 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1468
        ('386', 'b', 'Creator/contributor code', 'Creator/contributor code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1481
        ('386', 'b', 'Creator/contributor code', 'Creator/contributor code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1469
        ('386', 'm', 'Demographic group term', 'Demographic group term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1482
        ('386', 'm', 'Demographic group term', 'Demographic group term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1470
        ('386', 'n', 'Demographic group code', 'Demographic group code', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1483
        ('386', 'n', 'Demographic group code', 'Demographic group code', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1484
        ('388', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1485
        ('388', '2', 'Source of term', 'Source of term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1486
        ('388', '3', ' Materials specified', ' Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1487
        ('388', '6', ' Linkage', ' Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1488
        ('388', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1489
        ('388', 'a', 'Time period of creation term', 'Time period of creation term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1471
		('400', '4', 'Relator code', 'Relator code', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
1490
		('400', '4', 'Relator code', 'Relator code', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
1472
		('400', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
1491
		('400', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
1473
		('400', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
1492
		('400', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
Lines 1970-1976 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1970
		('600', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
1989
		('600', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
1971
		('600', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1990
		('600', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1972
		('600', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1991
		('600', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1973
		('600', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1992
		('600', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1974
		('600', 'h', 'Medium', 'Medium', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1993
		('600', 'h', 'Medium', 'Medium', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1975
		('600', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1994
		('600', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1976
		('600', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1995
		('600', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2001-2007 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2001
		('610', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, '', 6, '', '', '', NULL, -1, '', '', '', NULL),
2020
		('610', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, '', 6, '', '', '', NULL, -1, '', '', '', NULL),
2002
		('610', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2021
		('610', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2003
		('610', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2022
		('610', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2004
		('610', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2023
		('610', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2005
		('610', 'h', 'Medium', 'Medium', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2024
		('610', 'h', 'Medium', 'Medium', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2006
		('610', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2025
		('610', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2007
		('610', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2026
		('610', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2030-2036 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2030
		('611', 'd', 'Date of meeting', 'Date of meeting', 0, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
2049
		('611', 'd', 'Date of meeting', 'Date of meeting', 0, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
2031
		('611', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
2050
		('611', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
2032
		('611', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2051
		('611', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2033
		('611', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2052
		('611', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2034
		('611', 'h', 'Medium', 'Medium', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2053
		('611', 'h', 'Medium', 'Medium', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2035
		('611', 'j', 'Relator term', 'Relator term', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2054
		('611', 'j', 'Relator term', 'Relator term', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2036
		('611', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2055
		('611', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
Lines 2056-2062 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2056
		('630', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2075
		('630', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2057
		('630', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', NULL, -1, '', '', '', NULL),
2076
		('630', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', NULL, -1, '', '', '', NULL),
2058
		('630', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2077
		('630', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2059
		('630', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2078
		('630', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2060
		('630', 'h', 'Medium', 'Medium', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2079
		('630', 'h', 'Medium', 'Medium', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2061
		('630', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2080
		('630', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2062
		('630', 'l', 'Language of a work', 'Language of a work', 0, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2081
		('630', 'l', 'Language of a work', 'Language of a work', 0, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
Lines 2094-2099 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2094
		('650', 'c', 'Location of event', 'Location of event', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2113
		('650', 'c', 'Location of event', 'Location of event', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2095
		('650', 'd', 'Active dates', 'Active dates', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2114
		('650', 'd', 'Active dates', 'Active dates', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2096
        ('650', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2115
        ('650', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2116
        ('650', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2097
		('650', 'v', 'Form subdivision', 'Form subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2117
		('650', 'v', 'Form subdivision', 'Form subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2098
		('650', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2118
		('650', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2099
		('650', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2119
		('650', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
Lines 2108-2113 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2108
		('651', 'a', 'Geographic name', 'Geographic name', 0, 0, '', 6, '', 'GEOGR_NAME', '', NULL, 0, '', '', '', NULL),
2128
		('651', 'a', 'Geographic name', 'Geographic name', 0, 0, '', 6, '', 'GEOGR_NAME', '', NULL, 0, '', '', '', NULL),
2109
		('651', 'b', 'Geographic name following place entry element [OBSOLETE]', 'Geographic name following place entry element [OBSOLETE]', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2129
		('651', 'b', 'Geographic name following place entry element [OBSOLETE]', 'Geographic name following place entry element [OBSOLETE]', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2110
		('651', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', NULL, -1, '', '', '', NULL),
2130
		('651', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', NULL, -1, '', '', '', NULL),
2131
        ('651', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2111
		('651', 'v', 'Form subdivision', 'Form subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2132
		('651', 'v', 'Form subdivision', 'Form subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2112
		('651', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2133
		('651', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2113
		('651', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2134
		('651', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
Lines 2344-2350 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2344
		('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL),
2365
		('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL),
2345
		('700', 'e', 'Relator term', 'Relator term', 1, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL),
2366
		('700', 'e', 'Relator term', 'Relator term', 1, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL),
2346
		('700', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2367
		('700', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2347
		('700', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2368
		('700', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2348
		('700', 'h', 'Medium', 'Medium', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2369
		('700', 'h', 'Medium', 'Medium', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2349
        ('700', 'i', 'Relationship information', 'Relationship information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2370
        ('700', 'i', 'Relationship information', 'Relationship information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2350
		('700', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2371
		('700', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2390-2396 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2390
		('710', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL),
2411
		('710', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL),
2391
		('710', 'e', 'Relator term', 'Relator term', 1, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL),
2412
		('710', 'e', 'Relator term', 'Relator term', 1, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL),
2392
		('710', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2413
		('710', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2393
		('710', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2414
		('710', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2394
		('710', 'h', 'Medium', 'Medium', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2415
		('710', 'h', 'Medium', 'Medium', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2395
        ('710', 'i', 'Relationship information', 'Relationship information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2416
        ('710', 'i', 'Relationship information', 'Relationship information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2396
		('710', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2417
		('710', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2417-2423 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2417
		('711', 'd', 'Date of meeting', 'Date of meeting', 0, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2438
		('711', 'd', 'Date of meeting', 'Date of meeting', 0, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2418
		('711', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2439
		('711', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2419
		('711', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2440
		('711', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2420
		('711', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2441
		('711', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2421
		('711', 'h', 'Medium', 'Medium', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2442
		('711', 'h', 'Medium', 'Medium', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2422
        ('711', 'i', 'Relationship information', 'Relationship information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2443
        ('711', 'i', 'Relationship information', 'Relationship information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2423
		('711', 'j', 'Relator term', 'Relator term', 1, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2444
		('711', 'j', 'Relator term', 'Relator term', 1, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
Lines 2459-2465 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2459
		('730', 'a', 'Uniform title', 'Uniform title', 0, 0, '', 7, '', 'UNIF_TITLE', '', NULL, -1, '', '', '', NULL),
2480
		('730', 'a', 'Uniform title', 'Uniform title', 0, 0, '', 7, '', 'UNIF_TITLE', '', NULL, -1, '', '', '', NULL),
2460
		('730', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2481
		('730', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2461
		('730', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2482
		('730', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2462
		('730', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2483
		('730', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2463
		('730', 'h', 'Medium', 'Medium', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2484
		('730', 'h', 'Medium', 'Medium', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2464
        ('730', 'i', 'Relationship information', 'Relationship information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2485
        ('730', 'i', 'Relationship information', 'Relationship information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2465
		('730', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2486
		('730', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
Lines 3023-3029 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3023
		('800', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3044
		('800', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3024
		('800', 'e', 'Relator term', 'Relator term', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3045
		('800', 'e', 'Relator term', 'Relator term', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3025
		('800', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3046
		('800', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3026
		('800', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3047
		('800', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3027
		('800', 'h', 'Medium', 'Medium', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3048
		('800', 'h', 'Medium', 'Medium', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3028
		('800', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3049
		('800', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3029
		('800', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3050
		('800', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
Lines 3054-3060 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3054
		('810', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3075
		('810', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3055
		('810', 'e', 'Relator term', 'Relator term', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3076
		('810', 'e', 'Relator term', 'Relator term', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3056
		('810', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3077
		('810', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3057
		('810', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3078
		('810', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3058
		('810', 'h', 'Medium', 'Medium', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3079
		('810', 'h', 'Medium', 'Medium', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3059
		('810', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3080
		('810', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3060
		('810', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3081
		('810', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
Lines 3083-3089 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3083
		('811', 'd', 'Date of meeting', 'Date of meeting', 0, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL),
3104
		('811', 'd', 'Date of meeting', 'Date of meeting', 0, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL),
3084
		('811', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL),
3105
		('811', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL),
3085
		('811', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3106
		('811', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3086
		('811', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3107
		('811', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3087
		('811', 'h', 'Medium', 'Medium', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3108
		('811', 'h', 'Medium', 'Medium', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3088
		('811', 'j', 'Relator term', 'Relator term', 1, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL),
3109
		('811', 'j', 'Relator term', 'Relator term', 1, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL),
3089
		('811', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3110
		('811', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
Lines 3107-3113 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3107
		('830', 'a', 'Uniform title', 'Uniform title', 0, 0, '', 8, '', 'UNIF_TITLE', '', NULL, -1, '', '', '', NULL),
3128
		('830', 'a', 'Uniform title', 'Uniform title', 0, 0, '', 8, '', 'UNIF_TITLE', '', NULL, -1, '', '', '', NULL),
3108
		('830', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3129
		('830', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3109
		('830', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3130
		('830', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3110
		('830', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3131
		('830', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3111
		('830', 'h', 'Medium', 'Medium', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3132
		('830', 'h', 'Medium', 'Medium', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3112
		('830', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3133
		('830', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3113
		('830', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3134
		('830', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +108 lines)
Lines 9793-9798 if(CheckVersion($DBversion)) { Link Here
9793
    SetVersion($DBversion);
9793
    SetVersion($DBversion);
9794
}
9794
}
9795
9795
9796
$DBversion = "3.19.00.XXX";
9797
if(CheckVersion($DBversion)) {
9798
    if ( C4::Context->preference('marcflavour') eq 'MARC21' ) {
9799
    $dbh->do(q{
9800
        INSERT IGNORE INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES
9801
        ('', '388', 'TIME PERIOD OF CREATION', 'TIME PERIOD OF CREATION', 1, 0, NULL);
9802
    });
9803
9804
    $dbh->do(q{
9805
        INSERT IGNORE INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
9806
        mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode) VALUES
9807
        ('', '388', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
9808
        ('', '388', '2', 'Source of term', 'Source of term', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
9809
        ('', '388', '3', 'Materials specified', 'Materials specified', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
9810
        ('', '388', '6', 'Linkage', 'Linkage', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
9811
        ('', '388', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
9812
        ('', '388', 'a', 'Time period of creation term', 'Time period of creation term', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', '');
9813
    });
9814
9815
    $dbh->do(q{
9816
        UPDATE IGNORE auth_subfield_structure SET repeatable = 1 WHERE tagsubfield = 'g' AND tagfield IN
9817
        ('100','110','111','130','400','410','411','430','500','510','511','530','700','710','730');
9818
    });
9819
9820
    $dbh->do(q{
9821
        INSERT IGNORE INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
9822
        mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode) VALUES
9823
        ('', '150', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
9824
        ('', '151', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
9825
        ('', '450', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
9826
        ('', '451', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
9827
        ('', '550', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
9828
        ('', '551', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
9829
        ('', '750', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9830
        ('', '751', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9831
        ('', '748', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9832
        ('', '755', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9833
        ('', '780', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9834
        ('', '781', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9835
        ('', '782', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9836
        ('', '785', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9837
        ('', '710', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9838
        ('', '730', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9839
        ('', '748', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9840
        ('', '750', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9841
        ('', '751', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9842
        ('', '755', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9843
        ('', '762', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9844
        ('', '780', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9845
        ('', '781', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9846
        ('', '782', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9847
        ('', '785', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
9848
        ('', '788', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', '');
9849
    });
9850
9851
    $dbh->do(q{
9852
        UPDATE IGNORE auth_subfield_structure SET liblibrarian = 'Relationship information', libopac = 'Relationship information'
9853
        WHERE tagsubfield = 'i' AND tagfield IN ('700','710','730','750','751','762');
9854
    });
9855
9856
    $dbh->do(q{
9857
        UPDATE IGNORE auth_subfield_structure SET liblibrarian = 'Relationship code', libopac = 'Relationship code'
9858
        WHERE tagsubfield = '4' AND tagfield IN ('700','710');
9859
    });
9860
9861
    $dbh->do(q{
9862
        INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) VALUES
9863
        ('370', 'ASSOCIATED PLACE', 'ASSOCIATED PLACE', 1, 0, NULL, ''),
9864
        ('388', 'TIME PERIOD OF CREATION', 'TIME PERIOD OF CREATION', 1, 0, NULL, '');
9865
    });
9866
9867
    $dbh->do(q{
9868
        INSERT IGNORE INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory,
9869
        kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) VALUES
9870
        ('370', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9871
        ('370', '2', 'Source of term', 'Source of term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9872
        ('370', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9873
        ('370', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9874
        ('370', 'c', 'Associated country', 'Associated country', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9875
        ('370', 'f', 'Other associated place', 'Other associated place', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9876
        ('370', 'g', 'Place of origin of work', 'Place of origin of work', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9877
        ('370', 's', 'Start period', 'Start period', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9878
        ('370', 't', 'End period', 'End period', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9879
        ('370', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9880
        ('370', 'v', 'Source of information', 'Source of information', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9881
        ('377', 'l', 'Language term', 'Language term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9882
        ('382', 's', 'Total number of performers', 'Total number of performers', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9883
        ('388', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9884
        ('388', '2', 'Source of term', 'Source of term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9885
        ('388', '3', ' Materials specified', ' Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9886
        ('388', '6', ' Linkage', ' Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9887
        ('388', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9888
        ('388', 'a', 'Time period of creation term', 'Time period of creation term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
9889
        ('650', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
9890
        ('651', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL);
9891
    });
9892
9893
    $dbh->do(q{
9894
        UPDATE IGNORE marc_subfield_structure SET repeatable = 1 WHERE tagsubfield = 'g' AND
9895
        tagfield IN ('100','110','111','130','240','243','246','247','600','610','611','630','700','710','711','730','800','810','811','830');
9896
    });
9897
    }
9898
9899
    print "Upgrade to $DBversion done (Bug 13322 - Update MARC21 frameworks to Update No. 19 - October 2014)\n";
9900
    SetVersion($DBversion);
9901
}
9902
9903
9796
=head1 FUNCTIONS
9904
=head1 FUNCTIONS
9797
9905
9798
=head2 TableExists($table)
9906
=head2 TableExists($table)
9799
- 

Return to bug 13322