Bugzilla – Attachment 82706 Details for
Bug 21899
Update MARC21 frameworks to Update 27 (November 2018)
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 21899: Update MARC21 frameworks to Update 27 (November 2018)
Bug-21899-Update-MARC21-frameworks-to-Update-27-No.patch (text/plain), 12.26 KB, created by
Bernardo Gonzalez Kriegel
on 2018-11-28 17:32:09 UTC
(
hide
)
Description:
Bug 21899: Update MARC21 frameworks to Update 27 (November 2018)
Filename:
MIME Type:
Creator:
Bernardo Gonzalez Kriegel
Created:
2018-11-28 17:32:09 UTC
Size:
12.26 KB
patch
obsolete
>From ee2f78f2515dcd6acbbb31ede07f84e2d0c736e2 Mon Sep 17 00:00:00 2001 >From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> >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 >--- > .../mandatory/authorities_normal_marc21.sql | 3 +- > .../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 4b77adf23c..cb1cd16ae2 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.17.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 21899
:
82705
|
82706
|
87354
|
87563