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

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql (-1 / +20 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. 19 (October 2014)
4
--        Revised to Update No. 21 (September 2015)
5
-- *******************************************************
5
-- *******************************************************
6
6
7
-- ******************************************************
7
-- ******************************************************
Lines 162-167 INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l Link Here
162
		('', '253', 'COMPLEX SEE REFERENCE [CLASSIFICATION FORMAT]', 'COMPLEX SEE REFERENCE [CLASSIFICATION FORMAT]', 1, 0, NULL),
162
		('', '253', 'COMPLEX SEE REFERENCE [CLASSIFICATION FORMAT]', 'COMPLEX SEE REFERENCE [CLASSIFICATION FORMAT]', 1, 0, NULL),
163
		('', '260', 'COMPLEX SEE REFERENCE--SUBJECT', 'COMPLEX SEE REFERENCE--SUBJECT', 1, 0, NULL),
163
		('', '260', 'COMPLEX SEE REFERENCE--SUBJECT', 'COMPLEX SEE REFERENCE--SUBJECT', 1, 0, NULL),
164
		('', '336', 'CONTENT TYPE', 'CONTENT TYPE', 1, 0, NULL),
164
		('', '336', 'CONTENT TYPE', 'CONTENT TYPE', 1, 0, NULL),
165
		('', '348', 'FORMAT OF NOTATED MUSIC', 'FORMAT OF NOTATED MUSIC', 1, 0, NULL),
165
		('', '353', 'COMPLEX SEE ALSO REFERENCE [CLASSIFICATION FORMAT]', 'COMPLEX SEE ALSO REFERENCE [CLASSIFICATION FORMAT]', 1, 0, NULL),
166
		('', '353', 'COMPLEX SEE ALSO REFERENCE [CLASSIFICATION FORMAT]', 'COMPLEX SEE ALSO REFERENCE [CLASSIFICATION FORMAT]', 1, 0, NULL),
166
		('', '360', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 1, 0, NULL),
167
		('', '360', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 'COMPLEX SEE ALSO REFERENCE--SUBJECT', 1, 0, NULL),
167
		('', '368', 'OTHER ATTRIBUTES OF PERSON OR CORPORATE BODY', 'OTHER ATTRIBUTES OF PERSON OR CORPORATE BODY', 1, 0, NULL),
168
		('', '368', 'OTHER ATTRIBUTES OF PERSON OR CORPORATE BODY', 'OTHER ATTRIBUTES OF PERSON OR CORPORATE BODY', 1, 0, NULL),
Lines 264-269 INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l Link Here
264
		('', '856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL),
265
		('', '856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL),
265
		('', '880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL),
266
		('', '880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL),
266
		('', '883', 'MACHINE-GENERATED METADATA PROVENANCE', 'MACHINE-GENERATED METADATA PROVENANCE', 1, 0, NULL),
267
		('', '883', 'MACHINE-GENERATED METADATA PROVENANCE', 'MACHINE-GENERATED METADATA PROVENANCE', 1, 0, NULL),
268
		('', '884', 'DESCRIPTION CONVERSION INFORMATION', 'DESCRIPTION CONVERSION INFORMATION', 1, 0, NULL),
267
		('', '942', 'KOHA INTERNAL USE', 'KOHA INTERNAL USE', 0, 1, NULL);
269
		('', '942', 'KOHA INTERNAL USE', 'KOHA INTERNAL USE', 0, 1, NULL);
268
270
269
271
Lines 376-381 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
376
		('', '046', 'l', 'Ending date created', 'Ending date created', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
378
		('', '046', 'l', 'Ending date created', 'Ending date created', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
377
        ('', '046', 'o', 'Single or starting date for aggregated content', 'Single or starting date for aggregated content', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
379
        ('', '046', 'o', 'Single or starting date for aggregated content', 'Single or starting date for aggregated content', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
378
        ('', '046', 'p', 'Ending date for aggregated content', 'Ending date for aggregated content', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
380
        ('', '046', 'p', 'Ending date for aggregated content', 'Ending date for aggregated content', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
381
		('', '046', 'q', 'Establishment date', 'Establishment date', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
382
		('', '046', 'r', 'Termination date', 'Termination date', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
379
		('', '046', 's', 'Start period', 'Start period', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
383
		('', '046', 's', 'Start period', 'Start period', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
380
		('', '046', 't', 'End period', 'End period', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
384
		('', '046', 't', 'End period', 'End period', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
381
		('', '046', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
385
		('', '046', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 776-785 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
776
		('', '260', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 2, NULL, NULL, NULL, 0, 0, '', '', ''),
780
		('', '260', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 2, NULL, NULL, NULL, 0, 0, '', '', ''),
777
		('', '336', 'a', 'Content type term', 'Content type term', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
781
		('', '336', 'a', 'Content type term', 'Content type term', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
778
		('', '336', 'b', 'Content type code', 'Content type code', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
782
		('', '336', 'b', 'Content type code', 'Content type code', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
783
		('', '336', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
779
		('', '336', '2', 'Source', 'Source', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
784
		('', '336', '2', 'Source', 'Source', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
780
		('', '336', '3', 'Materials specified', 'Materials specified', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
785
		('', '336', '3', 'Materials specified', 'Materials specified', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
781
		('', '336', '6', 'Linkage', 'Linkage', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
786
		('', '336', '6', 'Linkage', 'Linkage', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
782
		('', '336', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
787
		('', '336', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
788
		('', '348', 'a', 'Format of notated music term', 'Format of notated music term', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
789
		('', '348', 'b', 'Format of notated music code', 'Format of notated music code', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
790
		('', '348', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
791
		('', '348', '2', 'Source of term', 'Source of term', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
792
		('', '348', '3', 'Materials specified', 'Materials specified', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
793
		('', '348', '6', 'Linkage', 'Linkage', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
794
		('', '348', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
783
		('', '353', 'a', 'Classification number referred to--Single number or beginning number of span', 'Classification number referred to--Single number or beginning number of span', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
795
		('', '353', 'a', 'Classification number referred to--Single number or beginning number of span', 'Classification number referred to--Single number or beginning number of span', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
784
		('', '353', 'c', 'Classification number referred to--Ending number of span', 'Classification number referred to--Ending number of span', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
796
		('', '353', 'c', 'Classification number referred to--Ending number of span', 'Classification number referred to--Ending number of span', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
785
		('', '353', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
797
		('', '353', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 903-908 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
903
		('', '382', 'a', 'Medium of performance', 'Medium of performance', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
915
		('', '382', 'a', 'Medium of performance', 'Medium of performance', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
904
		('', '382', 'b', 'Soloist', 'Soloist', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
916
		('', '382', 'b', 'Soloist', 'Soloist', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
905
		('', '382', 'd', 'Doubling instrument', 'Doubling instrument', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
917
		('', '382', 'd', 'Doubling instrument', 'Doubling instrument', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
918
		('', '382', 'e', 'Number of ensembles', 'Number of ensembles', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
906
		('', '382', 'n', 'Number of performers of the same medium', 'Number of performers of the same medium', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
919
		('', '382', 'n', 'Number of performers of the same medium', 'Number of performers of the same medium', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
907
		('', '382', 'p', 'Alternative medium of performance', 'Alternative medium of performance', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
920
		('', '382', 'p', 'Alternative medium of performance', 'Alternative medium of performance', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
908
		('', '382', 's', 'Total number of performers', 'Total number of performers', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
921
		('', '382', 's', 'Total number of performers', 'Total number of performers', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1458-1463 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1458
		('', '670', 'a', 'Source citation', 'Source citation', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1471
		('', '670', 'a', 'Source citation', 'Source citation', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1459
		('', '670', 'b', 'Information found', 'Information found', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1472
		('', '670', 'b', 'Information found', 'Information found', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1460
		('', '670', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1473
		('', '670', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1474
		('', '670', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1461
		('', '670', '6', 'Linkage', 'Linkage', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1475
		('', '670', '6', 'Linkage', 'Linkage', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1462
		('', '670', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1476
		('', '670', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1463
		('', '671', 'a', 'Citation', 'Citation', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1477
		('', '671', 'a', 'Citation', 'Citation', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1932-1937 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1932
		('', '883', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''),
1946
		('', '883', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''),
1933
		('', '883', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''),
1947
		('', '883', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''),
1934
		('', '883', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''),
1948
		('', '883', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''),
1949
		('', '884', 'a', 'Conversion process', 'Conversion process', 0, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''),
1950
		('', '884', 'g', 'Conversion date', 'Conversion date', 0, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''),
1951
		('', '884', 'k', 'Identifier of source metadata', 'Identifier of source metadata', 0, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''),
1952
		('', '884', 'q', 'Conversion agency', 'Conversion agency', 0, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''),
1953
		('', '884', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, 8, NULL, NULL, NULL, 0, 0, '', '', ''),
1935
		('', '942', 'a', 'Koha auth type', 'Koha auth type', 0, 1, 9, NULL, NULL, NULL, 0, 8, '', 'auth_header.authtypecode', '');
1954
		('', '942', 'a', 'Koha auth type', 'Koha auth type', 0, 1, 9, NULL, NULL, NULL, 0, 8, '', 'auth_header.authtypecode', '');
1936
1955
1937
1956
(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-2 / +21 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. 19 (October 2014)
10
--           Revised to Update No. 21 (September 2015)
11
-- *************************************************************
11
-- *************************************************************
12
12
13
13
Lines 289-294 INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, Link Here
289
        ('345', 'PROJECTION CHARACTERISTICS OF MOVING IMAGE', 'PROJECTION CHARACTERISTICS OF MOVING IMAGE', 1, 0, NULL, ''),
289
        ('345', 'PROJECTION CHARACTERISTICS OF MOVING IMAGE', 'PROJECTION CHARACTERISTICS OF MOVING IMAGE', 1, 0, NULL, ''),
290
        ('346', 'VIDEO CHARACTERISTICS', 'VIDEO CHARACTERISTICS', 1, 0, NULL, ''),
290
        ('346', 'VIDEO CHARACTERISTICS', 'VIDEO CHARACTERISTICS', 1, 0, NULL, ''),
291
        ('347', 'DIGITAL FILE CHARACTERISTICS', 'DIGITAL FILE CHARACTERISTICS', 1, 0, NULL, ''),
291
        ('347', 'DIGITAL FILE CHARACTERISTICS', 'DIGITAL FILE CHARACTERISTICS', 1, 0, NULL, ''),
292
		('348', 'FORMAT OF NOTATED MUSIC', 'FORMAT OF NOTATED MUSIC', 1, 0, NULL, ''),
292
		('350', 'PRICE (NR) (BK AM CF MU VM SE) [OBSOLETE]', 'PRICE (NR) (BK AM CF MU VM SE) [OBSOLETE]', 1, 0, NULL, ''),
293
		('350', 'PRICE (NR) (BK AM CF MU VM SE) [OBSOLETE]', 'PRICE (NR) (BK AM CF MU VM SE) [OBSOLETE]', 1, 0, NULL, ''),
293
		('351', 'ORGANIZATION AND ARRANGEMENT OF MATERIALS', 'ORGANIZATION AND ARRANGEMENT OF MATERIALS', 1, 0, NULL, ''),
294
		('351', 'ORGANIZATION AND ARRANGEMENT OF MATERIALS', 'ORGANIZATION AND ARRANGEMENT OF MATERIALS', 1, 0, NULL, ''),
294
		('352', 'DIGITAL GRAPHIC REPRESENTATION', 'DIGITAL GRAPHIC REPRESENTATION', 1, 0, NULL, ''),
295
		('352', 'DIGITAL GRAPHIC REPRESENTATION', 'DIGITAL GRAPHIC REPRESENTATION', 1, 0, NULL, ''),
Lines 463-468 INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, Link Here
463
		('880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL, ''),
464
		('880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL, ''),
464
        ('882', 'REPLACEMENT RECORD INFORMATION', 'REPLACEMENT RECORD INFORMATION', 0, 0, NULL, ''),
465
        ('882', 'REPLACEMENT RECORD INFORMATION', 'REPLACEMENT RECORD INFORMATION', 0, 0, NULL, ''),
465
        ('883', 'MACHINE-GENERATED METADATA PROVENANCE', 'MACHINE-GENERATED METADATA PROVENANCE', 1, 0, NULL, ''),
466
        ('883', 'MACHINE-GENERATED METADATA PROVENANCE', 'MACHINE-GENERATED METADATA PROVENANCE', 1, 0, NULL, ''),
467
		('884', 'DESCRIPTION CONVERSION INFORMATION', 'DESCRIPTION CONVERSION INFORMATION', 1, 0, NULL, ''),
466
		('886', 'FOREIGN MARC INFORMATION FIELD', 'FOREIGN MARC INFORMATION FIELD', 1, 0, NULL, ''),
468
		('886', 'FOREIGN MARC INFORMATION FIELD', 'FOREIGN MARC INFORMATION FIELD', 1, 0, NULL, ''),
467
		('887', 'NON-MARC INFORMATION FIELD', 'NON-MARC INFORMATION FIELD', 1, 0, NULL, ''),
469
		('887', 'NON-MARC INFORMATION FIELD', 'NON-MARC INFORMATION FIELD', 1, 0, NULL, ''),
468
		('896', 'LOCAL SERIES ADDED ENTRY--PERSONAL NAME (RLIN)', 'LOCAL SERIES ADDED ENTRY--PERSONAL NAME (RLIN)', 1, 0, '', ''),
470
		('896', 'LOCAL SERIES ADDED ENTRY--PERSONAL NAME (RLIN)', 'LOCAL SERIES ADDED ENTRY--PERSONAL NAME (RLIN)', 1, 0, '', ''),
Lines 670-675 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
670
		('036', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
672
		('036', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
671
		('036', 'a', 'Original study number', 'Original study number', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
673
		('036', 'a', 'Original study number', 'Original study number', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
672
        ('036', 'b', 'Source agency assigning number', 'Source agency assigning number', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
674
        ('036', 'b', 'Source agency assigning number', 'Source agency assigning number', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
675
		('037', '3', 'Materials specified', 'Materials specified', 0, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
676
		('037', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
673
		('037', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
677
		('037', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
674
		('037', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
678
		('037', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
675
		('037', 'a', 'Stock number', 'Stock number', 0, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
679
		('037', 'a', 'Stock number', 'Stock number', 0, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
Lines 1213-1230 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1213
		('321', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1217
		('321', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1214
		('321', 'a', 'Former publication frequency', 'Former publication frequency', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1218
		('321', 'a', 'Former publication frequency', 'Former publication frequency', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1215
        ('321', 'b', 'Dates of former publication frequency', 'Dates of former publication frequency', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1219
        ('321', 'b', 'Dates of former publication frequency', 'Dates of former publication frequency', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1220
        ('336', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1216
        ('336', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1221
        ('336', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1217
        ('336', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1222
        ('336', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1218
        ('336', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1223
        ('336', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1219
        ('336', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1224
        ('336', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1220
        ('336', 'a', 'Content type term', 'Content type term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1225
        ('336', 'a', 'Content type term', 'Content type term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1221
        ('336', 'b', 'Content type code', 'Content type code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1226
        ('336', 'b', 'Content type code', 'Content type code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1227
        ('337', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1222
        ('337', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1228
        ('337', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1223
        ('337', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1229
        ('337', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1224
        ('337', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1230
        ('337', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1225
        ('337', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1231
        ('337', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1226
        ('337', 'a', 'Media type term', 'Media type term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1232
        ('337', 'a', 'Media type term', 'Media type term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1227
        ('337', 'b', 'Media type code', 'Media type code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1233
        ('337', 'b', 'Media type code', 'Media type code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1234
        ('338', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1228
        ('338', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1235
        ('338', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1229
        ('338', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1236
        ('338', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1230
        ('338', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1237
        ('338', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
Lines 1324-1329 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1324
        ('347', 'd', 'Resolution', 'Resolution', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1331
        ('347', 'd', 'Resolution', 'Resolution', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1325
        ('347', 'e', 'Regional encoding', 'Regional encoding', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1332
        ('347', 'e', 'Regional encoding', 'Regional encoding', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1326
        ('347', 'f', 'Encoded bitrate', 'Encoded bitrate', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1333
        ('347', 'f', 'Encoded bitrate', 'Encoded bitrate', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1334
		('348', 'a', 'Format of notated music term', 'Format of notated music term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1335
		('348', 'b', 'Format of notated music code', 'Format of notated music code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1336
		('348', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1337
		('348', '2', 'Source of term', 'Source of term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1338
		('348', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1339
		('348', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1340
		('348', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1327
		('350', '6', 'Linkage', 'Linkage', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1341
		('350', '6', 'Linkage', 'Linkage', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1328
		('350', 'a', 'Price', 'Price', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1342
		('350', 'a', 'Price', 'Price', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1329
		('350', 'b', 'Form of issue', 'Form of issue', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1343
		('350', 'b', 'Form of issue', 'Form of issue', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL),
Lines 1448-1453 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1448
        ('382', 'a', 'Medium of performance', 'Medium of performance', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1462
        ('382', 'a', 'Medium of performance', 'Medium of performance', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1449
        ('382', 'b', 'Soloist', 'Soloist', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1463
        ('382', 'b', 'Soloist', 'Soloist', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1450
        ('382', 'd', 'Doubling instrument', 'Doubling instrument', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1464
        ('382', 'd', 'Doubling instrument', 'Doubling instrument', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1465
		('382', 'e', 'Number of ensembles', 'Number of ensembles', 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),
1466
        ('382', 'n', 'Number of performers of the same medium', 'Number of performers of the same medium', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1452
        ('382', 'p', 'Alternative medium of performance', 'Alternative medium of performance', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1467
        ('382', 'p', 'Alternative medium of performance', 'Alternative medium of performance', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1453
        ('382', 's', 'Total number of performers', 'Total number of performers', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1468
        ('382', 's', 'Total number of performers', 'Total number of performers', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
Lines 3576-3581 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3576
        ('883', 'x', 'Validity end date', 'Validity end date', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3591
        ('883', 'x', 'Validity end date', 'Validity end date', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3577
        ('883', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3592
        ('883', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3578
        ('883', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3593
        ('883', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3594
		('884', 'a', 'Conversion process', 'Conversion process', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3595
		('884', 'g', 'Conversion date', 'Conversion date', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3596
		('884', 'k', 'Identifier of source metadata', 'Identifier of source metadata', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3597
		('884', 'q', 'Conversion agency', 'Conversion agency', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3598
		('884', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3579
		('886', '0', '0', '0', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3599
		('886', '0', '0', '0', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3580
		('886', '1', '1', '1', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3600
		('886', '1', '1', '1', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3581
		('886', '2', '2', '2', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3601
		('886', '2', '2', '2', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3582
- 

Return to bug 14333