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

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql (-2 / +4 lines)
Lines 1-7 Link Here
1
-- *******************************************************
1
-- *******************************************************
2
--   KOHA  MARC 21 STANDARD DEFAULT AUTHORITY FRAMEWORKS
2
--   KOHA  MARC 21 STANDARD DEFAULT AUTHORITY FRAMEWORKS
3
--
3
--
4
--        Revised to Update No. 21 (September 2015)
4
--        Revised to Update No. 22 (April 2016)
5
-- *******************************************************
5
-- *******************************************************
6
6
7
-- ******************************************************
7
-- ******************************************************
Lines 915-924 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
915
		('', '382', 'a', 'Medium of performance', 'Medium of performance', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
915
		('', '382', 'a', 'Medium of performance', 'Medium of performance', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
916
		('', '382', 'b', 'Soloist', 'Soloist', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
916
		('', '382', 'b', 'Soloist', 'Soloist', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
917
		('', '382', 'd', 'Doubling instrument', 'Doubling instrument', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
917
		('', '382', 'd', 'Doubling instrument', 'Doubling instrument', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
918
		('', '382', 'e', 'Number of ensembles', 'Number of ensembles', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
918
		('', '382', 'e', 'Number of ensembles of the same type', 'Number of ensembles of the same type', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
919
		('', '382', 'n', 'Number of performers of the same medium', 'Number of performers of the same medium', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
919
		('', '382', 'n', 'Number of performers of the same medium', 'Number of performers of the same medium', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
920
		('', '382', 'p', 'Alternative medium of performance', 'Alternative medium of performance', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
920
		('', '382', 'p', 'Alternative medium of performance', 'Alternative medium of performance', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
921
		('', '382', 'r', 'Total number of individuals performing alongside ensembles', 'Total number of individuals performing alongside ensembles', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
921
		('', '382', 's', 'Total number of performers', 'Total number of performers', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
922
		('', '382', 's', 'Total number of performers', 'Total number of performers', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
923
		('', '382', 't', 'Total number of ensembles', 'Total number of ensembles', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
922
		('', '382', 'v', 'Note', 'Note', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
924
		('', '382', 'v', 'Note', 'Note', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
923
		('', '382', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
925
		('', '382', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
924
		('', '382', '2', 'Source of term', 'Source of term', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
926
		('', '382', '2', 'Source of term', 'Source of term', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-4 / +7 lines)
Lines 7-13 Link Here
7
--                    guided by Paul POULAIN
7
--                    guided by Paul POULAIN
8
--                      by thd for LibLime
8
--                      by thd for LibLime
9
--
9
--
10
--           Revised to Update No. 21 (September 2015)
10
--           Revised to Update No. 22 (April 2016)
11
-- *************************************************************
11
-- *************************************************************
12
12
13
13
Lines 385-391 INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, Link Here
385
		('651', 'SUBJECT ADDED ENTRY--GEOGRAPHIC NAME', 'SUBJECT ADDED ENTRY--GEOGRAPHIC NAME', 1, 0, NULL, ''),
385
		('651', 'SUBJECT ADDED ENTRY--GEOGRAPHIC NAME', 'SUBJECT ADDED ENTRY--GEOGRAPHIC NAME', 1, 0, NULL, ''),
386
		('652', 'SUBJECT ADDED ENTRY--REVERSE GEOGRAPHIC (BK MP SE) [OBSOLETE]', 'SUBJECT ADDED ENTRY--REVERSE GEOGRAPHIC (BK MP SE) [OBSOLETE]', 1, 0, NULL, ''),
386
		('652', 'SUBJECT ADDED ENTRY--REVERSE GEOGRAPHIC (BK MP SE) [OBSOLETE]', 'SUBJECT ADDED ENTRY--REVERSE GEOGRAPHIC (BK MP SE) [OBSOLETE]', 1, 0, NULL, ''),
387
		('653', 'INDEX TERM--UNCONTROLLED', 'INDEX TERM--UNCONTROLLED', 1, 0, NULL, ''),
387
		('653', 'INDEX TERM--UNCONTROLLED', 'INDEX TERM--UNCONTROLLED', 1, 0, NULL, ''),
388
		('654', 'SUBJECT ADDED ENTRY--FACETED TOPICAL TERM', 'SUBJECT ADDED ENTRY--FACETED TOPICAL TERM', 1, 0, NULL, ''),
388
		('654', 'SUBJECT ADDED ENTRY--FACETED TOPICAL TERMS', 'SUBJECT ADDED ENTRY--FACETED TOPICAL TERMS', 1, 0, NULL, ''),
389
		('655', 'INDEX TERM--GENRE/FORM', 'INDEX TERM--GENRE/FORM', 1, 0, NULL, ''),
389
		('655', 'INDEX TERM--GENRE/FORM', 'INDEX TERM--GENRE/FORM', 1, 0, NULL, ''),
390
		('656', 'INDEX TERM--OCCUPATION', 'INDEX TERM--OCCUPATION', 1, 0, NULL, ''),
390
		('656', 'INDEX TERM--OCCUPATION', 'INDEX TERM--OCCUPATION', 1, 0, NULL, ''),
391
		('657', 'INDEX TERM--FUNCTION', 'INDEX TERM--FUNCTION', 1, 0, NULL, ''),
391
		('657', 'INDEX TERM--FUNCTION', 'INDEX TERM--FUNCTION', 1, 0, NULL, ''),
Lines 1462-1471 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
1462
        ('382', 'a', 'Medium of performance', 'Medium of performance', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1462
        ('382', 'a', 'Medium of performance', 'Medium of performance', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1463
        ('382', 'b', 'Soloist', 'Soloist', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1463
        ('382', 'b', 'Soloist', 'Soloist', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1464
        ('382', 'd', 'Doubling instrument', 'Doubling instrument', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1464
        ('382', 'd', 'Doubling instrument', 'Doubling instrument', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1465
		('382', 'e', 'Number of ensembles', 'Number of ensembles', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1465
        ('382', 'e', 'Number of ensembles of the same type', 'Number of ensembles of the same type', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1466
        ('382', 'n', 'Number of performers of the same medium', 'Number of performers of the same medium', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1466
        ('382', 'n', 'Number of performers of the same medium', 'Number of performers of the same medium', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1467
        ('382', 'p', 'Alternative medium of performance', 'Alternative medium of performance', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1467
        ('382', 'p', 'Alternative medium of performance', 'Alternative medium of performance', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1468
        ('382', 'r', 'Total number of individuals performing alongside ensembles', 'Total number of individuals performing alongside ensembles', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1468
        ('382', 's', 'Total number of performers', 'Total number of performers', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1469
        ('382', 's', 'Total number of performers', 'Total number of performers', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1470
        ('382', 't', 'Total number of ensembles', 'Total number of ensembles', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1469
        ('382', 'v', 'Note', 'Note', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1471
        ('382', 'v', 'Note', 'Note', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1470
        ('383', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1472
        ('383', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1471
        ('383', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
1473
        ('383', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
Lines 2534-2539 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here
2534
		('752', 'f', 'City subsection', 'City subsection', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2536
		('752', 'f', 'City subsection', 'City subsection', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2535
		('752', 'g', 'Other nonjurisdictional geographic region and feature', 'Other nonjurisdictional geographic region and feature', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2537
		('752', 'g', 'Other nonjurisdictional geographic region and feature', 'Other nonjurisdictional geographic region and feature', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2536
		('752', 'h', 'Extraterrestrial area', 'Extraterrestrial area', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2538
		('752', 'h', 'Extraterrestrial area', 'Extraterrestrial area', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2539
        ('753', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2540
        ('753', '2', 'Source of term', 'Source of term', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
2537
		('753', '6', 'Linkage', 'Linkage', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2541
		('753', '6', 'Linkage', 'Linkage', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2538
		('753', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2542
		('753', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2539
		('753', 'a', 'Make and model of machine', 'Make and model of machine', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2543
		('753', 'a', 'Make and model of machine', 'Make and model of machine', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
2540
- 

Return to bug 16460