From 1e578e7c816cad6d23fe617d54b891d8e7bc7ce4 Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Wed, 28 Nov 2018 13:14:21 -0300 Subject: [PATCH] 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 --- .../marc21/mandatory/authorities_normal_marc21.sql | 3 ++- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 29 ++++++++++++++++++++-- 2 files changed, 29 insertions(+), 3 deletions(-) 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 901561904d..79d00186eb 100644 --- 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 6b74a3f4b2..a97496eec5 100644 --- 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), -- 2.11.0