Bug 21899: Update MARC21 frameworks to Update 27 (November 2018)

This bug updates MARC21 english frameworks to Update 27

Bibliographic
-------------
 * New fields 251, 341 and 532 with corresponding subfields
 * New subfields 041$p, 041$q and 041$r
 * Renamed subfield 041$j

Authorities
-----------
 * New subfield 055$2

To test:
1) Remove all your frameworks
2) Check mandatory bibliographic and authority files load without problem
3) Check new fields/subfields

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>

diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql
index 9015619..79d0018 100644 (file)
--- a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql
+++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql
@@ -1,7 +1,7 @@
 -- *******************************************************
 --   KOHA  MARC 21 STANDARD DEFAULT AUTHORITY FRAMEWORKS
 --
---        Revised to Update No. 26 (April 2018)
+--        Revised to Update No. 27 (November 2018)
 -- *******************************************************
 
 -- ******************************************************
@@ -425,6 +425,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
                ('', '055', 'd', 'Volumes/dates to which call number applies', 'Volumes/dates to which call number applies', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
                ('', '055', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
                ('', '055', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
+        ('', '055', '2', 'Number source', 'Number source', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
                ('', '055', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
                ('', '055', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),
                ('', '055', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''),

diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql
index 6b74a3f..a97496e 100644 (file)
--- a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql
+++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql
@@ -7,7 +7,7 @@
 --                    guided by Paul POULAIN
 --                      by thd for LibLime
 --
---           Revised to Update No. 26 (April 2018)
+--           Revised to Update No. 27 (November 2018)
 -- *************************************************************
 
 
@@ -255,6 +255,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`,
                ('246', 'VARYING FORM OF TITLE', 'VARYING FORM OF TITLE', 1, 0, NULL, ''),
                ('247', 'FORMER TITLE', 'FORMER TITLE', 1, 0, NULL, ''),
         ('250', 'EDITION STATEMENT', 'EDITION STATEMENT', 1, 0, NULL, ''),
+        ('251', 'VERSION INFORMATION', 'VERSION INFORMATION', 1, 0, NULL, ''),
                ('254', 'MUSICAL PRESENTATION STATEMENT', 'MUSICAL PRESENTATION STATEMENT', 0, 0, NULL, ''),
                ('255', 'CARTOGRAPHIC MATHEMATICAL DATA', 'CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL, ''),
                ('256', 'COMPUTER FILE CHARACTERISTICS', 'COMPUTER FILE CHARACTERISTICS', 0, 0, NULL, ''),
@@ -283,6 +284,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`,
         ('337', 'MEDIA TYPE', 'MEDIA TYPE', 1, 0, NULL, ''),
         ('338', 'CARRIER TYPE', 'CARRIER TYPE', 1, 0, NULL, ''),
                ('340', 'PHYSICAL MEDIUM', 'PHYSICAL MEDIUM', 1, 0, NULL, ''),
+        ('341', 'ACCESSIBILITY CONTENT', 'ACCESSIBILITY CONTENT', 1, 0, NULL, ''),
                ('342', 'GEOSPATIAL REFERENCE DATA', 'GEOSPATIAL REFERENCE DATA', 1, 0, NULL, ''),
                ('343', 'PLANAR COORDINATE DATA', 'PLANAR COORDINATE DATA', 1, 0, NULL, ''),
         ('344', 'SOUND CHARACTERISTICS', 'SOUND CHARACTERISTICS', 1, 0, NULL, ''),
@@ -343,6 +345,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`,
         ('526', 'STUDY PROGRAM INFORMATION NOTE', 'STUDY PROGRAM INFORMATION NOTE', 1, 0, NULL, ''),
                ('527', 'CENSORSHIP NOTE (VM) [OBSOLETE]', 'CENSORSHIP NOTE (VM) [OBSOLETE]', 1, 0, NULL, ''),
                ('530', 'ADDITIONAL PHYSICAL FORM AVAILABLE NOTE', 'ADDITIONAL PHYSICAL FORM AVAILABLE NOTE', 1, 0, NULL, ''),
+        ('532', 'ACCESSIBILITY NOTE', 'ACCESSIBILITY NOTE', 1, 0, NULL, ''),
                ('533', 'REPRODUCTION NOTE', 'REPRODUCTION NOTE', 1, 0, NULL, ''),
                ('534', 'ORIGINAL VERSION NOTE', 'ORIGINAL VERSION NOTE', 1, 0, NULL, ''),
                ('535', 'LOCATION OF ORIGINALS/DUPLICATES NOTE', 'LOCATION OF ORIGINALS/DUPLICATES NOTE', 1, 0, NULL, ''),
@@ -713,10 +716,13 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
                ('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
                ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
         ('041', 'h', 'Language code of original', 'Language code of original', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
-        ('041', 'j', 'Language code of subtitles or captions', 'Language code of subtitles or captions', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
+        ('041', 'j', 'Language code of subtitles', 'Language code of subtitles', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
         ('041', 'k', 'Language code of intermediate translations', 'Language code of intermediate translations', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
         ('041', 'm', 'Language code of original accompanying materials other than librettos', 'Language code of original accompanying materials other than librettos', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
         ('041', 'n', 'Language code of original libretto', 'Language code of original libretto', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
+        ('041', 'p', 'Language code of captions', 'Language code of captions', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
+        ('041', 'q', 'Language code of accessible audio', 'Language code of accessible audio', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
+        ('041', 'r', 'Language code of accessible visual language', 'Language code of accessible visual language', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
         ('042', 'a', 'Authentication code', 'Authentication code', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
         ('043', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
                ('043', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL),
@@ -1107,6 +1113,13 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
                ('250', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
                ('250', 'a', 'Edition statement', 'Edition statement', 0, 0, 'biblioitems.editionstatement', 2, '', '', '', NULL, 0, '', '', '', NULL),
                ('250', 'b', 'Remainder of edition statement', 'Remainder of edition statement', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL),
+        ('251', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
+        ('251', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
+        ('251', '2', 'Source', 'Source', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
+        ('251', '3', 'Materials specified', 'Materials specified', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
+        ('251', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
+        ('251', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
+        ('251', 'a', 'Version', 'Version', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
                ('254', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
                ('254', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
                ('254', 'a', 'Musical presentation statement', 'Musical presentation statement', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
@@ -1292,6 +1305,15 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
         ('340', 'm', 'Book format', 'Book format', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
         ('340', 'n', 'Font size', 'Font size', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
         ('340', 'o', 'Polarity', 'Polarity', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
+        ('341', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
+        ('341', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
+        ('341', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
+        ('341', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
+        ('341', 'a', 'Content access mode', 'Content access mode', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
+        ('341', 'b', 'Textual assistive features', 'Textual assistive features', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
+        ('341', 'c', 'Visual assistive features', 'Visual assistive features', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
+        ('341', 'd', 'Auditory assistive features', 'Auditory assistive features', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
+        ('341', 'e', 'Tactile assistive features', 'Tactile assistive features', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
                ('342', '2', 'Reference method used', 'Reference method used', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
                ('342', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
                ('342', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
@@ -1798,6 +1820,9 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
                ('530', 'd', 'Order number', 'Order number', 0, 0, NULL, 5, NULL, NULL, '', NULL, -1, '', '', '', NULL),
                ('530', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, NULL, 5, NULL, NULL, '', 1, -1, '', '', '', NULL),
                ('530', 'z', 'Source of note information (AM CF VM SE) [OBSOLETE]', 'Source of note information (AM CF VM SE) [OBSOLETE]', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
+        ('532', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
+        ('532', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
+        ('532', 'a', 'Summary of accessibility', 'Summary of accessibility', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
                ('533', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),
         ('533', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL),
                ('533', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL),