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

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql (-2 / +5 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. 27 (November 2018)
4
--        Revised to Update No. 29 (November 2019)
5
-- *******************************************************
5
-- *******************************************************
6
6
7
-- ******************************************************
7
-- ******************************************************
Lines 311-317 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
311
		('', '024', 'd', 'Additional codes following the standard number or code', 'Additional codes following the standard number or code', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
311
		('', '024', 'd', 'Additional codes following the standard number or code', 'Additional codes following the standard number or code', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
312
		('', '024', 'q', 'Qualifying information', 'Qualifying information', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
312
		('', '024', 'q', 'Qualifying information', 'Qualifying information', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
313
		('', '024', 'z', 'Canceled/invalid standard number or code', 'Canceled/invalid standard number or code', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
313
		('', '024', 'z', 'Canceled/invalid standard number or code', 'Canceled/invalid standard number or code', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
314
		('', '024', '2', 'Source of number or code', 'Source of number or code', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
314
		('', '024', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
315
		('', '024', '1', 'Real World Object URI', 'Real World Object URI', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
316
		('', '024', '2', 'Source', 'Source', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
315
		('', '024', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
317
		('', '024', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
316
		('', '024', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
318
		('', '024', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
317
		('', '031', 'a', 'Number of work', 'Number of work', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
319
		('', '031', 'a', 'Number of work', 'Number of work', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
Lines 2047-2052 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
2047
		('', '856', '2', 'Access method', 'Access method', 0, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''),
2049
		('', '856', '2', 'Access method', 'Access method', 0, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''),
2048
		('', '856', '3', 'Materials specified', 'Materials specified', 0, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''),
2050
		('', '856', '3', 'Materials specified', 'Materials specified', 0, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''),
2049
		('', '856', '6', 'Linkage', 'Linkage', 0, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''),
2051
		('', '856', '6', 'Linkage', 'Linkage', 0, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''),
2052
		('', '856', '7', 'Access status', 'Access status', 0, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''),
2050
		('', '856', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''),
2053
		('', '856', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''),
2051
		('', '880', 'a', 'a', 'a', 1, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''),
2054
		('', '880', 'a', 'a', 'a', 1, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''),
2052
		('', '880', 'b', 'b', 'b', 1, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''),
2055
		('', '880', 'b', 'b', 'b', 1, 0, 8, NULL, NULL, NULL, 0, 0, 0, '', ''),
(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-2 / +37 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. 27 (November 2018)
10
--           Revised to Update No. 29 (November 2019)
11
-- *************************************************************
11
-- *************************************************************
12
12
13
13
Lines 394-399 INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, Link Here
394
		('657', 'INDEX TERM--FUNCTION', 'INDEX TERM--FUNCTION', 1, 0, NULL, ''),
394
		('657', 'INDEX TERM--FUNCTION', 'INDEX TERM--FUNCTION', 1, 0, NULL, ''),
395
		('658', 'INDEX TERM--CURRICULUM OBJECTIVE', 'INDEX TERM--CURRICULUM OBJECTIVE', 1, 0, NULL, ''),
395
		('658', 'INDEX TERM--CURRICULUM OBJECTIVE', 'INDEX TERM--CURRICULUM OBJECTIVE', 1, 0, NULL, ''),
396
		('662', 'SUBJECT ADDED ENTRY--HIERARCHICAL PLACE NAME', 'SUBJECT ADDED ENTRY--HIERARCHICAL PLACE NAME', 1, 0, NULL, ''),
396
		('662', 'SUBJECT ADDED ENTRY--HIERARCHICAL PLACE NAME', 'SUBJECT ADDED ENTRY--HIERARCHICAL PLACE NAME', 1, 0, NULL, ''),
397
		('688', 'SUBJECT ADDED ENTRY--TYPE OF ENTITY UNSPECIFIED', 'SUBJECT ADDED ENTRY--TYPE OF ENTITY UNSPECIFIED', 1, 0, NULL, ''),
397
		('690', 'LOCAL SUBJECT ADDED ENTRY--TOPICAL TERM (OCLC, RLIN)', 'LOCAL SUBJECT ADDED ENTRY--TOPICAL TERM (OCLC, RLIN)', 1, 0, '', ''),
398
		('690', 'LOCAL SUBJECT ADDED ENTRY--TOPICAL TERM (OCLC, RLIN)', 'LOCAL SUBJECT ADDED ENTRY--TOPICAL TERM (OCLC, RLIN)', 1, 0, '', ''),
398
		('691', 'LOCAL SUBJECT ADDED ENTRY--GEOGRAPHIC NAME (RLIN)', 'LOCAL SUBJECT ADDED ENTRY--GEOGRAPHIC NAME (RLIN)', 1, 0, '', ''),
399
		('691', 'LOCAL SUBJECT ADDED ENTRY--GEOGRAPHIC NAME (RLIN)', 'LOCAL SUBJECT ADDED ENTRY--GEOGRAPHIC NAME (RLIN)', 1, 0, '', ''),
399
		('696', 'LOCAL SUBJECT ADDED ENTRY--PERSONAL NAME (RLIN)', 'LOCAL SUBJECT ADDED ENTRY--PERSONAL NAME (RLIN)', 1, 0, '', ''),
400
		('696', 'LOCAL SUBJECT ADDED ENTRY--PERSONAL NAME (RLIN)', 'LOCAL SUBJECT ADDED ENTRY--PERSONAL NAME (RLIN)', 1, 0, '', ''),
Lines 712-719 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
712
		('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
713
		('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
713
		('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
714
		('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
714
		('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
715
		('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
715
		('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
716
		('041', 'g', 'Language code of accompanying material other than librettos and transcripts', 'Language code of accompanying material other than librettos and transcripts', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
716
        ('041', 'h', 'Language code of original', 'Language code of original', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
717
        ('041', 'h', 'Language code of original', 'Language code of original', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
718
        ('041', 'i', 'Language code of intertitles', 'Language code of intertitles', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
717
        ('041', 'j', 'Language code of subtitles', 'Language code of subtitles', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
719
        ('041', 'j', 'Language code of subtitles', 'Language code of subtitles', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
718
        ('041', 'k', 'Language code of intermediate translations', 'Language code of intermediate translations', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
720
        ('041', 'k', 'Language code of intermediate translations', 'Language code of intermediate translations', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
719
        ('041', 'm', 'Language code of original accompanying materials other than librettos', 'Language code of original accompanying materials other than librettos', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
721
        ('041', 'm', 'Language code of original accompanying materials other than librettos', 'Language code of original accompanying materials other than librettos', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
Lines 721-726 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
721
        ('041', 'p', 'Language code of captions', 'Language code of captions', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
723
        ('041', 'p', 'Language code of captions', 'Language code of captions', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
722
        ('041', 'q', 'Language code of accessible audio', 'Language code of accessible audio', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
724
        ('041', 'q', 'Language code of accessible audio', 'Language code of accessible audio', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
723
        ('041', 'r', 'Language code of accessible visual language', 'Language code of accessible visual language', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
725
        ('041', 'r', 'Language code of accessible visual language', 'Language code of accessible visual language', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
726
        ('041', 't', 'Language code of accompanying transcripts for audiovisual materials', 'Language code of accompanying transcripts for audiovisual materials', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
724
        ('042', 'a', 'Authentication code', 'Authentication code', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
727
        ('042', 'a', 'Authentication code', 'Authentication code', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
725
        ('043', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
728
        ('043', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
726
		('043', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
729
		('043', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
Lines 927-932 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
927
		('099', 'f', 'Filing suffix', 'Filing suffix', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
930
		('099', 'f', 'Filing suffix', 'Filing suffix', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
928
		('100', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
931
		('100', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
929
		('100', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
932
		('100', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
933
		('100', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
930
		('100', '4', 'Relationship', 'Relationship', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
934
		('100', '4', 'Relationship', 'Relationship', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
931
		('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
935
		('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
932
		('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
936
		('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
Lines 948-953 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
948
		('100', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
952
		('100', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
949
		('110', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
953
		('110', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
950
		('110', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
954
		('110', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
955
		('110', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
951
		('110', '4', 'Relationship', 'Relationship', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
956
		('110', '4', 'Relationship', 'Relationship', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
952
		('110', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
957
		('110', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
953
		('110', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
958
		('110', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
Lines 967-972 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
967
		('110', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
972
		('110', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
968
		('111', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
973
		('111', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
969
		('111', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
974
		('111', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
975
		('111', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
970
		('111', '4', 'Relationship', 'Relationship', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
976
		('111', '4', 'Relationship', 'Relationship', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
971
		('111', '6', 'Linkage', 'Linkage', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
977
		('111', '6', 'Linkage', 'Linkage', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
972
		('111', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
978
		('111', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
Lines 988-993 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
988
		('111', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
994
		('111', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
989
		('130', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
995
		('130', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
990
		('130', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
996
		('130', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
997
		('130', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
991
		('130', '6', 'Linkage', 'Linkage', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
998
		('130', '6', 'Linkage', 'Linkage', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
992
		('130', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
999
		('130', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
993
		('130', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, -5, '', '', '', NULL),
1000
		('130', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, -5, '', '', '', NULL),
Lines 1022-1027 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1022
		('222', 'b', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, '', '', '', NULL),
1029
		('222', 'b', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, '', '', '', NULL),
1023
		('240', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1030
		('240', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1024
		('240', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1031
		('240', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
1032
		('240', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
1025
		('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
1033
		('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
1026
		('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
1034
		('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
1027
		('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL),
1035
		('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL),
Lines 1706-1711 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1706
		('506', 'd', 'Authorized users', 'Authorized users', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1714
		('506', 'd', 'Authorized users', 'Authorized users', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1707
		('506', 'e', 'Authorization', 'Authorization', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1715
		('506', 'e', 'Authorization', 'Authorization', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1708
		('506', 'f', 'Standardized terminology for access restriction', 'Standardized terminology for access restriction', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1716
		('506', 'f', 'Standardized terminology for access restriction', 'Standardized terminology for access restriction', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1717
		('506', 'g', 'Availability date', 'Availability date', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1718
		('506', 'q', 'Supplying agency', 'Supplying agency', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1709
		('506', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -6, '', '', '', NULL),
1719
		('506', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -6, '', '', '', NULL),
1710
		('507', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1720
		('507', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1711
		('507', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1721
		('507', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
Lines 1878-1883 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1878
		('538', 'a', 'System details note', 'System details note', 0, 0, '', 5, '', '', '', NULL, -1, '', '', '', NULL),
1888
		('538', 'a', 'System details note', 'System details note', 0, 0, '', 5, '', '', '', NULL, -1, '', '', '', NULL),
1879
		('538', 'i', 'Display text', 'Display text', 0, 0, '', 5, '', '', '', NULL, -1, '', '', '', NULL),
1889
		('538', 'i', 'Display text', 'Display text', 0, 0, '', 5, '', '', '', NULL, -1, '', '', '', NULL),
1880
		('538', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -1, '', '', '', NULL),
1890
		('538', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -1, '', '', '', NULL),
1891
		('540', '2', 'Source of term', 'Source of term', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1881
		('540', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1892
		('540', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1882
		('540', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1893
		('540', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1883
		('540', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1894
		('540', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
Lines 1886-1891 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1886
		('540', 'b', 'Jurisdiction', 'Jurisdiction', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1897
		('540', 'b', 'Jurisdiction', 'Jurisdiction', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1887
		('540', 'c', 'Authorization', 'Authorization', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1898
		('540', 'c', 'Authorization', 'Authorization', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1888
		('540', 'd', 'Authorized users', 'Authorized users', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1899
		('540', 'd', 'Authorized users', 'Authorized users', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1900
		('540', 'f', 'Use and reproduction rights', 'Use and reproduction rights', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1901
		('540', 'g', 'Availability date', 'Availability date', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1902
		('540', 'q', 'Supplying agency', 'Supplying agency', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1889
		('540', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -6, '', '', '', NULL),
1903
		('540', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -6, '', '', '', NULL),
1890
		('541', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1904
		('541', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1891
		('541', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1905
		('541', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2343-2348 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2343
		('662', 'f', 'City subsection', 'City subsection', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2357
		('662', 'f', 'City subsection', 'City subsection', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2344
		('662', 'g', 'Other nonjurisdictional geographic region and feature', 'Other nonjurisdictional geographic region and feature', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2358
		('662', 'g', 'Other nonjurisdictional geographic region and feature', 'Other nonjurisdictional geographic region and feature', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2345
		('662', 'h', 'Extraterrestrial area', 'Extraterrestrial area', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2359
		('662', 'h', 'Extraterrestrial area', 'Extraterrestrial area', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2360
        ('688', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2361
        ('688', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2362
        ('688', '2', 'Source of name, title, or term', 'Source of name, title, or term', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2363
        ('688', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2364
        ('688', '4', 'Relationship', 'Relationship', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2365
        ('688', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2366
        ('688', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2367
        ('688', 'a', 'Name, title, or term', 'Name, title, or term', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2368
        ('688', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2369
        ('688', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2346
		('690', '%', '% (RLIN)', '% (RLIN)', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL),
2370
		('690', '%', '% (RLIN)', '% (RLIN)', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL),
2347
		('690', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2371
		('690', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2348
		('690', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL),
2372
		('690', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL),
Lines 2482-2487 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2482
		('699', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2506
		('699', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2483
		('700', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2507
		('700', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2484
		('700', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2508
		('700', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2509
		('700', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
2485
		('700', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2510
		('700', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2486
		('700', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2511
		('700', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2487
		('700', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2512
		('700', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2529-2534 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2529
		('705', 't', 'Title of a work', 'Title of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2554
		('705', 't', 'Title of a work', 'Title of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2530
		('710', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2555
		('710', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2531
		('710', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2556
		('710', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2557
		('710', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
2532
		('710', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2558
		('710', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2533
		('710', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2559
		('710', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2534
		('710', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2560
		('710', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2557-2562 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2557
		('710', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2583
		('710', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2558
		('711', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2584
		('711', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2559
		('711', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2585
		('711', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2586
		('711', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
2560
		('711', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2587
		('711', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2561
		('711', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2588
		('711', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2562
		('711', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2589
		('711', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
Lines 2604-2609 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2604
		('720', 'e', 'Relator term', 'Relator term', 1, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2631
		('720', 'e', 'Relator term', 'Relator term', 1, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2605
		('730', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2632
		('730', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2606
		('730', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2633
		('730', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2634
		('730', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
2607
		('730', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2635
		('730', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2608
		('730', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2636
		('730', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2609
		('730', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2637
		('730', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2642-2647 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2642
        ('751', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2670
        ('751', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2643
        ('751', 'a', 'Geographic name', 'Geographic name', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2671
        ('751', 'a', 'Geographic name', 'Geographic name', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2644
        ('751', 'e', 'Relator term', 'Relator term', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2672
        ('751', 'e', 'Relator term', 'Relator term', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2673
        ('751', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2645
		('752', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2674
		('752', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2646
		('752', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2675
		('752', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2647
		('752', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2676
		('752', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
Lines 2684-2689 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2684
		('755', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2713
		('755', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2685
		('758', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2714
		('758', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2686
		('758', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2715
		('758', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2716
		('758', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
2687
		('758', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2717
		('758', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2688
		('758', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2718
		('758', '4', 'Relationship', 'Relationship', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2689
		('758', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2719
		('758', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
Lines 3185-3190 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3185
		('799', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
3215
		('799', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
3186
		('800', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3216
		('800', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3187
		('800', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3217
		('800', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3218
		('800', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
3188
        ('800', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3219
        ('800', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3189
		('800', '4', 'Relationship', 'Relationship', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3220
		('800', '4', 'Relationship', 'Relationship', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3190
        ('800', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3221
        ('800', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
Lines 3217-3222 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3217
        ('800', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3248
        ('800', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3218
		('810', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3249
		('810', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3219
		('810', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3250
		('810', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3251
		('810', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
3220
        ('810', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3252
        ('810', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3221
		('810', '4', 'Relationship', 'Relationship', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3253
		('810', '4', 'Relationship', 'Relationship', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3222
        ('810', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3254
        ('810', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
Lines 3247-3252 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3247
        ('810', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3279
        ('810', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3248
		('811', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3280
		('811', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3249
		('811', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3281
		('811', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3282
		('811', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
3250
        ('811', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3283
        ('811', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3251
		('811', '4', 'Relationship', 'Relationship', 1, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL),
3284
		('811', '4', 'Relationship', 'Relationship', 1, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL),
3252
        ('811', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3285
        ('811', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
Lines 3276-3281 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3276
        ('811', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3309
        ('811', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3277
		('830', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3310
		('830', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3278
		('830', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3311
		('830', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3312
		('830', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
3279
        ('830', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3313
        ('830', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3280
        ('830', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3314
        ('830', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3281
		('830', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3315
		('830', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
Lines 3448-3453 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3448
		('856', '2', 'Access method', 'Access method', 0, 0, '', 8, '', '', '', 0, -6, '', '', '', NULL),
3482
		('856', '2', 'Access method', 'Access method', 0, 0, '', 8, '', '', '', 0, -6, '', '', '', NULL),
3449
		('856', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', 0, 0, '', '', '', NULL),
3483
		('856', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', 0, 0, '', '', '', NULL),
3450
		('856', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', 0, -6, '', '', '', NULL),
3484
		('856', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', 0, -6, '', '', '', NULL),
3485
		('856', '7', 'Access status', 'Access status', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3451
		('856', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', 0, -6, '', '', '', NULL),
3486
		('856', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', 0, -6, '', '', '', NULL),
3452
		('856', 'a', 'Host name', 'Host name', 1, 0, '', 8, '', '', '', 0, -1, '', '', '', NULL),
3487
		('856', 'a', 'Host name', 'Host name', 1, 0, '', 8, '', '', '', 0, -1, '', '', '', NULL),
3453
		('856', 'b', 'Access number', 'Access number', 1, 0, '', 8, '', '', '', 0, -1, '', '', '', NULL),
3488
		('856', 'b', 'Access number', 'Access number', 1, 0, '', 8, '', '', '', 0, -1, '', '', '', NULL),
(-)a/koha-tmpl/intranet-tmpl/prog/en/data/marc21_field_007.xml (-1 / +1 lines)
Lines 932-937 Link Here
932
      <Value code="s"><description>Sound recording</description></Value>
932
      <Value code="s"><description>Sound recording</description></Value>
933
    </Position>
933
    </Position>
934
    <Position pos="01">Specific material designation<name></name><description>Special class of sound recording to which the item belongs (e.g., a cylinder).</description>
934
    <Position pos="01">Specific material designation<name></name><description>Special class of sound recording to which the item belongs (e.g., a cylinder).</description>
935
      <Value code="b"><description>Belt</description></Value>
935
      <Value code="d"><description>Sound disc</description></Value>
936
      <Value code="d"><description>Sound disc</description></Value>
936
      <Value code="e"><description>Cylinder</description></Value>
937
      <Value code="e"><description>Cylinder</description></Value>
937
      <Value code="g"><description>Sound cartridge</description></Value>
938
      <Value code="g"><description>Sound cartridge</description></Value>
938
- 

Return to bug 24312