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

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql (-20 / +20 lines)
Lines 1205-1211 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1205
		('', '500', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1205
		('', '500', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1206
		('', '500', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1206
		('', '500', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1207
		('', '500', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1207
		('', '500', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1208
		('', '500', '0', 'Record control number', 'Record control number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1208
		('', '500', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1209
		('', '500', '4', 'Relationship code', 'Relationship code', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1209
		('', '500', '4', 'Relationship code', 'Relationship code', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1210
		('', '500', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1210
		('', '500', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1211
		('', '500', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1211
		('', '500', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1234-1240 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1234
		('', '510', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1234
		('', '510', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1235
		('', '510', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1235
		('', '510', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1236
		('', '510', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1236
		('', '510', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1237
		('', '510', '0', 'Record control number', 'Record control number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1237
		('', '510', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1238
		('', '510', '4', 'Relationship code', 'Relationship code', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1238
		('', '510', '4', 'Relationship code', 'Relationship code', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1239
		('', '510', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1239
		('', '510', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1240
		('', '510', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1240
		('', '510', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1261-1267 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1261
		('', '511', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1261
		('', '511', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1262
		('', '511', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1262
		('', '511', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1263
		('', '511', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1263
		('', '511', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1264
		('', '511', '0', 'Record control number', 'Record control number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1264
		('', '511', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1265
		('', '511', '4', 'Relationship code', 'Relationship code', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1265
		('', '511', '4', 'Relationship code', 'Relationship code', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1266
		('', '511', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1266
		('', '511', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1267
		('', '511', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1267
		('', '511', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1287-1293 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1287
		('', '530', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1287
		('', '530', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1288
		('', '530', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1288
		('', '530', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1289
		('', '530', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1289
		('', '530', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1290
		('', '530', '0', 'Record control number', 'Record control number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1290
		('', '530', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1291
		('', '530', '4', 'Relationship code', 'Relationship code', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1291
		('', '530', '4', 'Relationship code', 'Relationship code', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1292
		('', '530', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1292
		('', '530', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1293
		('', '530', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1293
		('', '530', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1315-1321 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1315
		('', '550', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1315
		('', '550', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1316
		('', '550', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1316
		('', '550', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1317
		('', '550', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1317
		('', '550', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1318
		('', '550', '0', 'Record control number', 'Record control number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1318
		('', '550', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1319
		('', '550', '4', 'Relationship code', 'Relationship code', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1319
		('', '550', '4', 'Relationship code', 'Relationship code', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1320
		('', '550', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1320
		('', '550', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1321
		('', '550', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1321
		('', '550', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1329-1335 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1329
		('', '551', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1329
		('', '551', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1330
		('', '551', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1330
		('', '551', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1331
		('', '551', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1331
		('', '551', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1332
		('', '551', '0', 'Record control number', 'Record control number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1332
		('', '551', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1333
		('', '551', '4', 'Relationship code', 'Relationship code', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1333
		('', '551', '4', 'Relationship code', 'Relationship code', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1334
		('', '551', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1334
		('', '551', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1335
		('', '551', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
1335
		('', '551', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1570-1576 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1570
		('', '700', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1570
		('', '700', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1571
		('', '700', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1571
		('', '700', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1572
		('', '700', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1572
		('', '700', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1573
		('', '700', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1573
		('', '700', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1574
		('', '700', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1574
		('', '700', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1575
		('', '700', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1575
		('', '700', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1576
		('', '700', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1576
		('', '700', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1600-1606 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1600
		('', '710', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1600
		('', '710', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1601
		('', '710', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1601
		('', '710', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1602
		('', '710', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1602
		('', '710', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1603
		('', '710', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1603
		('', '710', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1604
		('', '710', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1604
		('', '710', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1605
		('', '710', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1605
		('', '710', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1606
		('', '710', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1606
		('', '710', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1614-1620 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1614
		('', '711', 'f', 'Date of a work', 'Date of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1614
		('', '711', 'f', 'Date of a work', 'Date of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1615
		('', '711', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1615
		('', '711', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1616
		('', '711', 'h', 'Medium', 'Medium', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1616
		('', '711', 'h', 'Medium', 'Medium', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1617
		('', '711', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1617
		('', '711', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1618
		('', '711', 'j', 'Relator term', 'Relator term', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1618
		('', '711', 'j', 'Relator term', 'Relator term', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1619
		('', '711', 'k', 'Form subheading', 'Form subheading', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1619
		('', '711', 'k', 'Form subheading', 'Form subheading', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1620
		('', '711', 'l', 'Language of a work', 'Language of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1620
		('', '711', 'l', 'Language of a work', 'Language of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1628-1637 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1628
		('', '711', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1628
		('', '711', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1629
		('', '711', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1629
		('', '711', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1630
		('', '711', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1630
		('', '711', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1631
		('', '711', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1631
		('', '711', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1632
		('', '711', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1632
		('', '711', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1633
		('', '711', '3', 'Materials specified', 'Materials specified', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1633
		('', '711', '3', 'Materials specified', 'Materials specified', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1634
		('', '711', '4', 'Relator code', 'Relator code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1634
		('', '711', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1635
		('', '711', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1635
		('', '711', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1636
		('', '711', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1636
		('', '711', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1637
		('', '711', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1637
		('', '711', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1655-1661 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1655
		('', '730', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1655
		('', '730', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1656
		('', '730', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1656
		('', '730', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1657
		('', '730', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1657
		('', '730', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1658
		('', '730', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1658
		('', '730', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1659
		('', '730', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1659
		('', '730', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1660
		('', '730', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1660
		('', '730', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1661
		('', '730', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1661
		('', '730', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1669-1675 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1669
		('', '748', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1669
		('', '748', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1670
		('', '748', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1670
		('', '748', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1671
		('', '748', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1671
		('', '748', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1672
		('', '748', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1672
		('', '748', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1673
		('', '748', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1673
		('', '748', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1674
		('', '748', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1674
		('', '748', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1675
		('', '748', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1675
		('', '748', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1687-1693 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1687
		('', '750', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1687
		('', '750', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1688
		('', '750', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1688
		('', '750', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1689
		('', '750', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1689
		('', '750', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1690
		('', '750', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1690
		('', '750', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1691
		('', '750', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1691
		('', '750', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1692
		('', '750', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1692
		('', '750', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1693
		('', '750', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1693
		('', '750', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1702-1708 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1702
		('', '751', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1702
		('', '751', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1703
		('', '751', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1703
		('', '751', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1704
		('', '751', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1704
		('', '751', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1705
		('', '751', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1705
		('', '751', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1706
		('', '751', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1706
		('', '751', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1707
		('', '751', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1707
		('', '751', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1708
		('', '751', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1708
		('', '751', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1737-1743 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1737
		('', '755', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1737
		('', '755', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1738
		('', '755', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1738
		('', '755', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1739
		('', '755', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1739
		('', '755', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1740
		('', '755', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1740
		('', '755', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1741
		('', '755', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1741
		('', '755', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1742
		('', '755', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1742
		('', '755', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1743
		('', '755', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1743
		('', '755', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1823-1829 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1823
		('', '780', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1823
		('', '780', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1824
		('', '780', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1824
		('', '780', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1825
		('', '780', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1825
		('', '780', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1826
		('', '780', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1826
		('', '780', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1827
		('', '780', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1827
		('', '780', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1828
		('', '780', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1828
		('', '780', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1829
		('', '780', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1829
		('', '780', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1835-1841 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1835
		('', '781', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1835
		('', '781', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1836
		('', '781', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1836
		('', '781', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1837
		('', '781', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1837
		('', '781', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1838
		('', '781', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1838
		('', '781', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1839
		('', '781', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1839
		('', '781', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1840
		('', '781', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1840
		('', '781', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1841
		('', '781', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1841
		('', '781', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1847-1853 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1847
		('', '782', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1847
		('', '782', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1848
		('', '782', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1848
		('', '782', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1849
		('', '782', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1849
		('', '782', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1850
		('', '782', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1850
		('', '782', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1851
		('', '782', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1851
		('', '782', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1852
		('', '782', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1852
		('', '782', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1853
		('', '782', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1853
		('', '782', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1859-1865 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1859
		('', '785', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1859
		('', '785', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1860
		('', '785', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1860
		('', '785', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1861
		('', '785', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1861
		('', '785', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1862
		('', '785', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1862
		('', '785', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1863
		('', '785', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1863
		('', '785', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1864
		('', '785', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1864
		('', '785', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1865
		('', '785', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
1865
		('', '785', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-32 / +31 lines)
Lines 260-266 INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, Link Here
260
		('256', 'COMPUTER FILE CHARACTERISTICS', 'COMPUTER FILE CHARACTERISTICS', 0, 0, NULL, ''),
260
		('256', 'COMPUTER FILE CHARACTERISTICS', 'COMPUTER FILE CHARACTERISTICS', 0, 0, NULL, ''),
261
        ('257', 'COUNTRY OF PRODUCING ENTITY', 'COUNTRY OF PRODUCING ENTITY', 1, 0, NULL, ''),
261
        ('257', 'COUNTRY OF PRODUCING ENTITY', 'COUNTRY OF PRODUCING ENTITY', 1, 0, NULL, ''),
262
        ('258', 'PHILATELIC ISSUE DATA', 'PHILATELIC ISSUE DATA', 1, 0, NULL, ''),
262
        ('258', 'PHILATELIC ISSUE DATA', 'PHILATELIC ISSUE DATA', 1, 0, NULL, ''),
263
		('260', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 1, 0, NULL, ''),
263
		('260', 'PUBLICATION, DISTRIBUTION, ETC.', 'PUBLICATION, DISTRIBUTION, ETC.', 1, 0, NULL, ''),
264
		('261', 'IMPRINT STATEMENT FOR FILMS (Pre-AACR 1 Revised) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'IMPRINT STATEMENT FOR FILMS (Pre-AACR 1 Revised) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 0, 0, NULL, ''),
264
		('261', 'IMPRINT STATEMENT FOR FILMS (Pre-AACR 1 Revised) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'IMPRINT STATEMENT FOR FILMS (Pre-AACR 1 Revised) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 0, 0, NULL, ''),
265
		('262', 'IMPRINT STATEMENT FOR SOUND RECORDINGS (Pre-AACR 2) [LOCAL, USA]', 'IMPRINT STATEMENT FOR SOUND RECORDINGS (Pre-AACR 2) [LOCAL, USA]', 0, 0, NULL, ''),
265
		('262', 'IMPRINT STATEMENT FOR SOUND RECORDINGS (Pre-AACR 2) [LOCAL, USA]', 'IMPRINT STATEMENT FOR SOUND RECORDINGS (Pre-AACR 2) [LOCAL, USA]', 0, 0, NULL, ''),
266
		('263', 'PROJECTED PUBLICATION DATE', 'PROJECTED PUBLICATION DATE', 0, 0, NULL, ''),
266
		('263', 'PROJECTED PUBLICATION DATE', 'PROJECTED PUBLICATION DATE', 0, 0, NULL, ''),
Lines 541-547 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
541
		('016', '2', 'Source', 'Source', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
541
		('016', '2', 'Source', 'Source', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
542
		('016', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
542
		('016', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
543
		('016', 'a', 'Record control number', 'Record control number', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
543
		('016', 'a', 'Record control number', 'Record control number', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
544
        ('016', 'z', 'Canceled/invalid record control number', 'Canceled/invalid record control number', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
544
		('016', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
545
		('017', '2', 'Source', 'Source', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
545
		('017', '2', 'Source', 'Source', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
546
		('017', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
546
		('017', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
547
		('017', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
547
		('017', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
Lines 897-903 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
897
		('099', 'a', 'Classification number', 'Classification number', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
897
		('099', 'a', 'Classification number', 'Classification number', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
898
		('099', 'e', 'Feature heading', 'Feature heading', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
898
		('099', 'e', 'Feature heading', 'Feature heading', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
899
		('099', 'f', 'Filing suffix', 'Filing suffix', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
899
		('099', 'f', 'Filing suffix', 'Filing suffix', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
900
        ('100', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
900
		('100', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
901
		('100', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
901
		('100', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
902
		('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
902
		('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
903
		('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
903
		('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
Lines 917-923 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
917
		('100', 'q', 'Fuller form of name', 'Fuller form of name', 0, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
917
		('100', 'q', 'Fuller form of name', 'Fuller form of name', 0, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
918
		('100', 't', 'Title of a work', 'Title of a work', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
918
		('100', 't', 'Title of a work', 'Title of a work', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
919
		('100', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
919
		('100', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
920
        ('110', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
920
		('110', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
921
		('110', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', NULL, 0, '', '', '', NULL),
921
		('110', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', NULL, 0, '', '', '', NULL),
922
		('110', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
922
		('110', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
923
		('110', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
923
		('110', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
Lines 935-941 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
935
		('110', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
935
		('110', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
936
		('110', 't', 'Title of a work', 'Title of a work', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
936
		('110', 't', 'Title of a work', 'Title of a work', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
937
		('110', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
937
		('110', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
938
        ('111', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
938
		('111', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
939
		('111', '4', 'Relator code', 'Relator code', 1, 0, NULL, 1, NULL, NULL, '', NULL, 0, '', '', '', NULL),
939
		('111', '4', 'Relator code', 'Relator code', 1, 0, NULL, 1, NULL, NULL, '', NULL, 0, '', '', '', NULL),
940
		('111', '6', 'Linkage', 'Linkage', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
940
		('111', '6', 'Linkage', 'Linkage', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
941
		('111', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
941
		('111', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
Lines 955-961 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
955
		('111', 'q', 'Name of meeting following jurisdiction name entry element', 'Name of meeting following jurisdiction name entry element', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
955
		('111', 'q', 'Name of meeting following jurisdiction name entry element', 'Name of meeting following jurisdiction name entry element', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
956
		('111', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
956
		('111', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
957
		('111', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
957
		('111', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
958
        ('130', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
958
		('130', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
959
		('130', '6', 'Linkage', 'Linkage', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
959
		('130', '6', 'Linkage', 'Linkage', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
960
		('130', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
960
		('130', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
961
		('130', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, -5, '', '', '', NULL),
961
		('130', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, -5, '', '', '', NULL),
Lines 988-994 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
988
		('222', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL),
988
		('222', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL),
989
		('222', 'a', 'Key title', 'Key title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, '', '', '', NULL),
989
		('222', 'a', 'Key title', 'Key title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, '', '', '', NULL),
990
		('222', 'b', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, '', '', '', NULL),
990
		('222', 'b', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, '', '', '', NULL),
991
        ('240', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
991
		('240', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
992
		('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
992
		('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
993
		('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
993
		('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
994
		('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL),
994
		('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL),
Lines 1260-1266 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1260
		('342', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1260
		('342', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1261
		('342', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1261
		('342', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1262
        ('342', 'a', 'Name', 'Name', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1262
        ('342', 'a', 'Name', 'Name', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1263
		('342', 'b', 'Coordinate or distance units', 'Coordinate or distance units', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1263
		('342', 'b', 'Coordinate units or distance units', 'Coordinate unist or distance units', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1264
		('342', 'c', 'Latitude resolution', 'Latitude resolution', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1264
		('342', 'c', 'Latitude resolution', 'Latitude resolution', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1265
		('342', 'd', 'Longitude resolution', 'Longitude resolution', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1265
		('342', 'd', 'Longitude resolution', 'Longitude resolution', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1266
		('342', 'e', 'Standard parallel or oblique line latitude', 'Standard parallel or oblique line latitude', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1266
		('342', 'e', 'Standard parallel or oblique line latitude', 'Standard parallel or oblique line latitude', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
Lines 1603-1609 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1603
		('503', 'a', 'Bibliographic history note', 'Bibliographic history note', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1603
		('503', 'a', 'Bibliographic history note', 'Bibliographic history note', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1604
		('504', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1604
		('504', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1605
		('504', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1605
		('504', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1606
		('504', 'a', 'Bibliography, etc', 'Bibliography, etc', 0, 0, '', 5, NULL, NULL, '', NULL, 0, '', '', '', NULL),
1606
		('504', 'a', 'Bibliography, etc. note', 'Bibliography, etc. note', 0, 0, '', 5, NULL, NULL, '', NULL, 0, '', '', '', NULL),
1607
		('504', 'b', 'Number of references', 'Number of references', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1607
		('504', 'b', 'Number of references', 'Number of references', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1608
		('505', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1608
		('505', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1609
		('505', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
1609
		('505', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
Lines 1991-1997 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1991
		('590', 'b', 'Provenance (VM) [OBSOLETE]', 'Provenance (VM) [OBSOLETE]', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1991
		('590', 'b', 'Provenance (VM) [OBSOLETE]', 'Provenance (VM) [OBSOLETE]', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1992
		('590', 'c', 'Condition of individual reels (VM) [OBSOLETE]', 'Condition of individual reels (VM) [OBSOLETE]', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1992
		('590', 'c', 'Condition of individual reels (VM) [OBSOLETE]', 'Condition of individual reels (VM) [OBSOLETE]', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1993
		('590', 'd', 'Origin of safety copy (VM) [OBSOLETE]', 'Origin of safety copy (VM) [OBSOLETE]', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1993
		('590', 'd', 'Origin of safety copy (VM) [OBSOLETE]', 'Origin of safety copy (VM) [OBSOLETE]', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
1994
        ('600', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1994
		('600', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1995
		('600', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
1995
		('600', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
1996
		('600', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1996
		('600', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1997
		('600', '4', 'Relator code', 'Relator code', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
1997
		('600', '4', 'Relator code', 'Relator code', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2022-2028 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2022
		('600', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2022
		('600', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2023
		('600', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2023
		('600', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2024
		('600', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2024
		('600', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2025
        ('610', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2025
		('610', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2026
		('610', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2026
		('610', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2027
		('610', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2027
		('610', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2028
		('610', '4', 'Relator code', 'Relator code', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2028
		('610', '4', 'Relator code', 'Relator code', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2051-2057 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2051
		('610', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2051
		('610', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2052
		('610', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2052
		('610', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2053
		('610', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2053
		('610', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2054
        ('611', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2054
		('611', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2055
		('611', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
2055
		('611', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
2056
		('611', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2056
		('611', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2057
		('611', '4', 'Relator code', 'Relator code', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2057
		('611', '4', 'Relator code', 'Relator code', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
Lines 2079-2085 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2079
		('611', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
2079
		('611', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
2080
		('611', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
2080
		('611', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
2081
		('611', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
2081
		('611', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
2082
        ('630', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2082
		('630', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2083
		('630', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
2083
		('630', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
2084
		('630', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2084
		('630', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2085
		('630', '4', 'Relator code', 'Relator code', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2085
		('630', '4', 'Relator code', 'Relator code', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
Lines 2105-2111 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2105
		('630', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2105
		('630', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2106
		('630', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2106
		('630', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2107
		('630', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2107
		('630', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2108
        ('648', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2108
		('648', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2109
		('648', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2109
		('648', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2110
		('648', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2110
		('648', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2111
		('648', '6', 'Linkage', 'Linkage', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2111
		('648', '6', 'Linkage', 'Linkage', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
Lines 2116-2130 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2116
		('648', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2116
		('648', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2117
		('648', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2117
		('648', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2118
		('648', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2118
		('648', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2119
        ('650', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2119
		('650', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2120
		('650', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2120
		('650', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2121
		('650', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL),
2121
		('650', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL),
2122
		('650', '4', 'Relator code', 'Relator code', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2122
		('650', '4', 'Relator code', 'Relator code', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2123
		('650', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL),
2123
		('650', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL),
2124
		('650', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL),
2124
		('650', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL),
2125
		('650', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, '', '', '', NULL),
2125
		('650', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, '', '', '', NULL),
2126
		('650', 'a', 'Topical term or geographic name as entry element', 'Topical term or geographic name as entry element', 0, 0, 'bibliosubject.subject', 6, '', 'TOPIC_TERM', '', 0, 0, '', '''6003'',''600a'',''600b'',''600c'',''600d'',''600e'',''600f'',''600g'',''600h'',''600k'',''600l'',''600m'',''600n'',''600o'',''600p'',''600r'',''600s'',''600t'',''600u'',''600x'',''600z'',''600y'',''600v'',''6103'',''610a'',''610b'',''610c'',''610d'',''610e'',''610f'',''610g'',''610h'',''610k'',''610l'',''610m'',''610n'',''610o'',''610p'',''610r'',''610s'',''610t'',''610u'',''610x'',''610z'',''610y'',''610v'',''6113'',''611a'',''611b'',''611c'',''611d'',''611e'',''611f'',''611g'',''611h'',''611k'',''611l'',''611m'',''611n'',''611o'',''611p'',''611r'',''611s'',''611t'',''611u'',''611x'',''611z'',''611y'',''611v'',''630a'',''630b'',''630c'',''630d'',''630e'',''630f'',''630g'',''630h'',''630k'',''630l'',''630m'',''630n'',''630o'',''630p'',''630r'',''630s'',''630t'',''630x'',''630z'',''630y'',''630v'',''6483'',''648a'',''648x'',''648z'',''648y'',''648v'',''6503'',''650b'',''650c'',''650d'',''650e'',''650x'',''650z'',''650y'',''650v'',''6513'',''651a'',''651b'',''651c'',''651d'',''651e'',''651x'',''651z'',''651y'',''651v'',''653a'',''6543'',''654a'',''654b'',''654x'',''654z'',''654y'',''654v'',''6553'',''655a'',''655b'',''655x'',''655z'',''655y'',''655v'',''6563'',''656a'',''656k'',''656x'',''656z'',''656y'',''656v'',''6573'',''657a'',''657x'',''657z'',''657y'',''657v'',''658a'',''658b'',''658c'',''658d'',''658v''', '', NULL),
2126
		('650', 'a', 'Topical term or geographic name entry element', 'Topical term or geographic name entry element', 0, 0, 'bibliosubject.subject', 6, '', 'TOPIC_TERM', '', 0, 0, '', '''6003'',''600a'',''600b'',''600c'',''600d'',''600e'',''600f'',''600g'',''600h'',''600k'',''600l'',''600m'',''600n'',''600o'',''600p'',''600r'',''600s'',''600t'',''600u'',''600x'',''600z'',''600y'',''600v'',''6103'',''610a'',''610b'',''610c'',''610d'',''610e'',''610f'',''610g'',''610h'',''610k'',''610l'',''610m'',''610n'',''610o'',''610p'',''610r'',''610s'',''610t'',''610u'',''610x'',''610z'',''610y'',''610v'',''6113'',''611a'',''611b'',''611c'',''611d'',''611e'',''611f'',''611g'',''611h'',''611k'',''611l'',''611m'',''611n'',''611o'',''611p'',''611r'',''611s'',''611t'',''611u'',''611x'',''611z'',''611y'',''611v'',''630a'',''630b'',''630c'',''630d'',''630e'',''630f'',''630g'',''630h'',''630k'',''630l'',''630m'',''630n'',''630o'',''630p'',''630r'',''630s'',''630t'',''630x'',''630z'',''630y'',''630v'',''6483'',''648a'',''648x'',''648z'',''648y'',''648v'',''6503'',''650b'',''650c'',''650d'',''650e'',''650x'',''650z'',''650y'',''650v'',''6513'',''651a'',''651b'',''651c'',''651d'',''651e'',''651x'',''651z'',''651y'',''651v'',''653a'',''6543'',''654a'',''654b'',''654x'',''654z'',''654y'',''654v'',''6553'',''655a'',''655b'',''655x'',''655z'',''655y'',''655v'',''6563'',''656a'',''656k'',''656x'',''656z'',''656y'',''656v'',''6573'',''657a'',''657x'',''657z'',''657y'',''657v'',''658a'',''658b'',''658c'',''658d'',''658v''', '', NULL),
2127
		('650', 'b', 'Topical term following geographic name as entry element', 'Topical term following geographic name as entry element', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2127
		('650', 'b', 'Topical term following geographic name entry element', 'Topical term following geographic name entry element', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2128
		('650', 'c', 'Location of event', 'Location of event', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2128
		('650', 'c', 'Location of event', 'Location of event', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2129
		('650', 'd', 'Active dates', 'Active dates', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2129
		('650', 'd', 'Active dates', 'Active dates', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2130
        ('650', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
2130
        ('650', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
Lines 2133-2139 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2133
		('650', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2133
		('650', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2134
		('650', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2134
		('650', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2135
		('650', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2135
		('650', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
2136
        ('651', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2136
		('651', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2137
		('651', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2137
		('651', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2138
		('651', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2138
		('651', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2139
		('651', '4', 'Relator code', 'Relator code', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2139
		('651', '4', 'Relator code', 'Relator code', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2156-2162 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2156
		('653', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2156
		('653', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2157
		('653', 'a', 'Uncontrolled term', 'Uncontrolled term', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2157
		('653', 'a', 'Uncontrolled term', 'Uncontrolled term', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2158
        ('654', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2158
        ('654', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2159
		('654', '2', 'Source of term', 'Source of term', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2159
		('654', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2160
		('654', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2160
		('654', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2161
		('654', '4', 'Relator code', 'Relator code', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2161
		('654', '4', 'Relator code', 'Relator code', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2162
		('654', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2162
		('654', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2207-2213 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2207
		('657', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2207
		('657', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2208
		('657', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2208
		('657', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2209
		('657', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2209
		('657', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2210
		('658', '2', 'Source of term', 'Source of term', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2210
		('658', '2', 'Source of term or code', 'Source of term or code', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2211
		('658', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2211
		('658', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2212
		('658', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2212
		('658', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2213
		('658', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, '', '', '', NULL),
2213
		('658', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, '', '', '', NULL),
Lines 2216-2222 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2216
		('658', 'c', 'Curriculum code', 'Curriculum code', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2216
		('658', 'c', 'Curriculum code', 'Curriculum code', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2217
		('658', 'd', 'Correlation factor', 'Correlation factor', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2217
		('658', 'd', 'Correlation factor', 'Correlation factor', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2218
        ('662', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2218
        ('662', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2219
		('662', '2', 'Source of term', 'Source of term', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2219
		('662', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
2220
		('662', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2220
		('662', '3', 'Materials specified', 'Materials specified', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2221
		('662', '4', 'Relator code', 'Relator code', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2221
		('662', '4', 'Relator code', 'Relator code', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2222
		('662', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
2222
		('662', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2367-2373 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2367
		('699', 'v', 'Form subdivision', 'Form subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2367
		('699', 'v', 'Form subdivision', 'Form subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2368
		('699', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2368
		('699', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2369
		('699', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2369
		('699', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2370
        ('700', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2370
		('700', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2371
		('700', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2371
		('700', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2372
		('700', '4', 'Relator code', 'Relator code', 1, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL),
2372
		('700', '4', 'Relator code', 'Relator code', 1, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL),
2373
		('700', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2373
		('700', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2413-2419 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2413
		('705', 'r', 'Key for music', 'Key for music', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2413
		('705', 'r', 'Key for music', 'Key for music', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2414
		('705', 's', 'Version', 'Version', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2414
		('705', 's', 'Version', 'Version', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2415
		('705', 't', 'Title of a work', 'Title of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2415
		('705', 't', 'Title of a work', 'Title of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2416
        ('710', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2416
		('710', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2417
		('710', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2417
		('710', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2418
		('710', '4', 'Relator code', 'Relator code', 1, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL),
2418
		('710', '4', 'Relator code', 'Relator code', 1, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL),
2419
		('710', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2419
		('710', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2440-2446 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2440
		('710', 't', 'Title of a work', 'Title of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2440
		('710', 't', 'Title of a work', 'Title of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2441
		('710', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2441
		('710', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2442
		('710', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2442
		('710', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2443
        ('711', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2443
		('711', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2444
		('711', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2444
		('711', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2445
		('711', '4', 'Relator code', 'Relator code', 1, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2445
		('711', '4', 'Relator code', 'Relator code', 1, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2446
		('711', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2446
		('711', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
Lines 2486-2492 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2486
		('720', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2486
		('720', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2487
		('720', 'a', 'Name', 'Name', 0, 0, '', 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2487
		('720', 'a', 'Name', 'Name', 0, 0, '', 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2488
		('720', 'e', 'Relator term', 'Relator term', 1, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2488
		('720', 'e', 'Relator term', 'Relator term', 1, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
2489
        ('730', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2489
		('730', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2490
		('730', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2490
		('730', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2491
		('730', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2491
		('730', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2492
		('730', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2492
		('730', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2887-2893 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2887
		('786', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2887
		('786', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2888
		('786', 'y', 'CODEN designation', 'CODEN designation', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2888
		('786', 'y', 'CODEN designation', 'CODEN designation', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2889
		('786', 'z', 'International Standard Book Number', 'International Standard Book Number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2889
		('786', 'z', 'International Standard Book Number', 'International Standard Book Number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2890
        ('787', '4', 'Relationshop code', 'Relationshop code', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2890
		('787', '4', 'Relationship code', 'Relationship code', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2891
		('787', '6', 'Linkage', 'Linkage', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2891
		('787', '6', 'Linkage', 'Linkage', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2892
		('787', '7', 'Control subfield', 'Control subfield', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2892
		('787', '7', 'Control subfield', 'Control subfield', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2893
		('787', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2893
		('787', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
Lines 3045-3051 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3045
		('799', 's', 'Version', 'Version', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
3045
		('799', 's', 'Version', 'Version', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
3046
		('799', 't', 'Title of a work', 'Title of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
3046
		('799', 't', 'Title of a work', 'Title of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
3047
		('799', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
3047
		('799', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
3048
        ('800', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3048
		('800', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3049
        ('800', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3049
        ('800', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3050
		('800', '4', 'Relator code', 'Relator code', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3050
		('800', '4', 'Relator code', 'Relator code', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3051
        ('800', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3051
        ('800', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
Lines 3076-3082 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3076
		('800', 'v', 'Volume/sequential designation', 'Volume/sequential designation', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3076
		('800', 'v', 'Volume/sequential designation', 'Volume/sequential designation', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3077
		('800', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3077
		('800', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3078
        ('800', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3078
        ('800', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3079
        ('810', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3079
		('810', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3080
        ('810', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3080
        ('810', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3081
		('810', '4', 'Relator code', 'Relator code', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3081
		('810', '4', 'Relator code', 'Relator code', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3082
        ('810', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3082
        ('810', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
Lines 3105-3111 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3105
		('810', 'v', 'Volume/sequential designation', 'Volume/sequential designation', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3105
		('810', 'v', 'Volume/sequential designation', 'Volume/sequential designation', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3106
		('810', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3106
		('810', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3107
        ('810', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3107
        ('810', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3108
        ('811', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3108
		('811', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3109
        ('811', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3109
        ('811', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3110
		('811', '4', 'Relator code', 'Relator code', 1, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL),
3110
		('811', '4', 'Relator code', 'Relator code', 1, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL),
3111
        ('811', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3111
        ('811', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
Lines 3133-3139 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3133
		('811', 'v', 'Volume/sequential designation', 'Volume/sequential designation', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3133
		('811', 'v', 'Volume/sequential designation', 'Volume/sequential designation', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3134
		('811', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3134
		('811', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3135
        ('811', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3135
        ('811', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3136
        ('830', '0', 'Authority record control number', 'Authority record control number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3136
		('830', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3137
        ('830', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3137
        ('830', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3138
        ('830', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3138
        ('830', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3139
		('830', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3139
		('830', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
Lines 3154-3160 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
3154
		('830', 'r', 'Key for music', 'Key for music', 0, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3154
		('830', 'r', 'Key for music', 'Key for music', 0, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3155
		('830', 's', 'Version', 'Version', 0, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3155
		('830', 's', 'Version', 'Version', 0, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
3156
		('830', 't', 'Title of a work', 'Title of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3156
		('830', 't', 'Title of a work', 'Title of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3157
		('830', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3157
		('830', 'v', 'Volume/sequential designation', 'Volume/sequential designation', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3158
		('830', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3158
		('830', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
3159
        ('830', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3159
        ('830', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3160
		('840', 'a', 'Title', 'Title', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3160
		('840', 'a', 'Title', 'Title', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
3161
- 

Return to bug 14333