From 6456296c9007e96573653899c3915e0716cea234 Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Sun, 31 May 2020 21:05:17 -0300 Subject: [PATCH] Bug 25632: [19.11] Update MARC21 frameworks to update Nr. 30 (May 2020) For version <= 19.11 New subfields 0 1 2 in 310 and 321 Changes 310 change to repeatable 883 renamed 883 a d q renamed To test: 1) Remove bibliographic frameworks 2) Check mandatory bibliographic fw load without problem 3) Check new/renamed fields/subfields Signed-off-by: Phil Ringnalda --- .../mandatory/marc21_framework_DEFAULT.sql | 16 +++++++++++----- 1 file changed, 11 insertions(+), 5 deletions(-) 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 3572503ce0..445419a37a 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 @@ -276,7 +276,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, ('306', 'PLAYING TIME', 'PLAYING TIME', 0, 0, NULL, ''), ('307', 'HOURS, ETC.', 'HOURS, ETC.', 1, 0, NULL, ''), ('308', 'PHYSICAL DESCRIPTION FOR FILMS (ARCHIVAL) (VM) [OBSOLETE]', 'PHYSICAL DESCRIPTION FOR FILMS (ARCHIVAL) (VM) [OBSOLETE]', 1, 0, NULL, ''), - ('310', 'CURRENT PUBLICATION FREQUENCY', 'CURRENT PUBLICATION FREQUENCY', 0, 0, NULL, ''), + ('310', 'CURRENT PUBLICATION FREQUENCY', 'CURRENT PUBLICATION FREQUENCY', 1, 0, NULL, ''), ('315', 'FREQUENCY (CF MP) [OBSOLETE]', 'FREQUENCY (CF MP) [OBSOLETE]', 0, 0, NULL, ''), ('321', 'FORMER PUBLICATION FREQUENCY', 'FORMER PUBLICATION FREQUENCY', 1, 0, NULL, ''), ('336', 'CONTENT TYPE', 'CONTENT TYPE', 1, 0, NULL, ''), @@ -468,7 +468,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, ('878', 'ITEM INFORMATION--INDEXES', 'ITEM INFORMATION--INDEXES', 1, 0, NULL, ''), ('880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL, ''), ('882', 'REPLACEMENT RECORD INFORMATION', 'REPLACEMENT RECORD INFORMATION', 0, 0, NULL, ''), - ('883', 'MACHINE-GENERATED METADATA PROVENANCE', 'MACHINE-GENERATED METADATA PROVENANCE', 1, 0, NULL, ''), + ('883', 'METADATA PROVENANCE', 'METADATA PROVENANCE', 1, 0, NULL, ''), ('884', 'DESCRIPTION CONVERSION INFORMATION', 'DESCRIPTION CONVERSION INFORMATION', 1, 0, NULL, ''), ('885', 'MATCHING INFORMATION', 'MATCHING INFORMATION', 1, 0, NULL, ''), ('886', 'FOREIGN MARC INFORMATION FIELD', 'FOREIGN MARC INFORMATION FIELD', 1, 0, NULL, ''), @@ -1256,6 +1256,9 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('308', 'd', 'Color characteristics', 'Color characteristics', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('308', 'e', 'Width', 'Width', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('308', 'f', 'Presentation format', 'Presentation format', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('310', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('310', '1', 'Real World Object', 'Real World Object', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('310', '2', 'Source', 'Source', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('310', '6', 'Linkage', 'Linkage', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('310', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('310', 'a', 'Current publication frequency', 'Current publication frequency', 0, 0, NULL, 3, NULL, NULL, '', NULL, -1, '', '', '', NULL), @@ -1263,6 +1266,9 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('315', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('315', 'a', 'Frequency', 'Frequency', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('315', 'b', 'Dates of frequency', 'Dates of frequency', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('321', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('321', '1', 'Real World Object', 'Real World Object', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('321', '2', 'Source', 'Source', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('321', '6', 'Linkage', 'Linkage', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('321', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('321', 'a', 'Former publication frequency', 'Former publication frequency', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -3762,10 +3768,10 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('883', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('883', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('883', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), - ('883', 'a', 'Generation process', 'Generation process', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('883', 'a', 'Creation process', 'Creation process', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('883', 'c', 'Confidence value', 'Confidence value', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), - ('883', 'd', 'Generation date', 'Generation date', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), - ('883', 'q', 'Generation agency', 'Generation agency', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('883', 'd', 'Creation date', 'Creation date', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('883', 'q', 'Assigning or generating agency', 'Assigning or generating agency', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('883', 'x', 'Validity end date', 'Validity end date', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('883', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('883', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), -- 2.26.1