From 27c9d7ee7e24080b200262811c67f9dedc9c2246 Mon Sep 17 00:00:00 2001 From: Julian Maurice Date: Thu, 3 Oct 2019 15:04:35 +0200 Subject: [PATCH] Bug 18309: Add missing fields in biblio framework 018 - [Reserved for other International Standard Numbers] 033 - Other System Persistent Record Identifier 183 - Coded Data Field: Type of Carrier 203 - Content Form and Media Type 231 - Digital File Characteristics 283 - Carrier Type 338 - Funding Information Note Signed-off-by: Sonia BOUIS --- .../mandatory/unimarc_framework_DEFAULT.sql | 37 ++++++++++++++++++++++ 1 file changed, 37 insertions(+) diff --git a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql index 8c6bc92..d618b43 100644 --- a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql +++ b/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql @@ -235,9 +235,11 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('015', 'International Standard Technical Report Number (ISRN)', 'International Standard Technical Report Number (ISRN)', 1, 0, '', ''), ('016', 'International Standard Recording Code (ISRC)', 'International Standard Recording Code (ISRC)', 1, 0, '', ''), ('017', 'Other Standard Identifier', 'Other Standard Identifier', 1, 0, '', ''), + ('018', '[Reserved for other International Standard Numbers]', '[Reserved for other International Standard Numbers]', 1, 0, '', ''), ('020', 'National Bibliography Number', 'National Bibliography Number', 1, 0, '', ''), ('021', 'Legal Deposit Number', 'Legal Deposit Number', 1, 0, '', ''), ('022', 'Government Publication Number', 'Government Publication Number', 1, 0, '', ''), + ('033', 'Other system persistent record identifier', 'Other system persistent record identifier', 1, 0, '', ''), ('035', 'Other System Control Numbers', 'Other System Control Numbers', 1, 0, '', ''), ('036', 'Music Incipit', 'Music Incipit', 1, 0, '', ''), ('040', 'CODEN (Serials)', 'CODEN (Serials)', 1, 0, '', ''), @@ -271,7 +273,9 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('146', 'Coded Data Field: Medium of Performance', 'Coded Data Field: Medium of Performance', 1, 0, '', ''), ('181', 'Coded Data Field: content form', '', 1, 0, '', ''), ('182', 'Coded Data Field: media type', '', 1, 0, '', ''), + ('183', 'Coded Data Field: Type of Carrier', 'Coded Data Field: Type of Carrier', 1, 0, '', ''), ('200', 'Title and Statement of Responsibility', 'Title and Statement of Responsibility', 0, 1, '', ''), + ('203', 'Coded Data Field: Content Form', 'Coded Data Field: Content Form', 1, 0, '', ''), ('204', 'General Material Designation [Obsolete]', 'General Material Designation [Obsolete]', 1, 0, '', ''), ('205', 'Edition Statement', 'Edition Statement', 1, 0, '', ''), ('206', 'Material Specific Area: Cartographic Resources - Mathematical Data', 'Material Specific Area: Cartographic Resources - Mathematical Data', 1, 0, '', ''), @@ -283,7 +287,9 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('215', 'Physical Description', 'Physical Description', 1, 0, '', ''), ('225', 'Series', 'Series', 1, 0, '', ''), ('230', 'Material Specific Area: Electronic Resource Characteristics', 'Material Specific Area: Electronic Resource Characteristics', 1, 0, '', ''), + ('231', 'Digital File Characteristics', 'Digital File Characteristics', 1, 0, '', ''), ('251', 'Organization and Arrangement of Materials', 'Organization and Arrangement of Materials', 1, 0, '', ''), + ('283', 'Carrier Type', 'Carrier Type', 1, 0, '', ''), ('300', 'General Notes', 'General Notes', 1, 0, '', ''), ('301', 'Notes Pertaining to Identification Numbers', 'Notes Pertaining to Identification Numbers', 1, 0, '', ''), ('302', 'Notes Pertaining to Coded Information', 'Notes Pertaining to Coded Information', 1, 0, '', ''), @@ -318,6 +324,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('335', 'Location of Originals/ Reproductions', 'Location of Originals/ Reproductions', 1, 0, '', ''), ('336', 'Type of Electronic Resource Note', 'Type of Electronic Resource Note', 1, 0, '', ''), ('337', 'System Requirements Note (Electronic Resources)', 'System Requirements Note (Electronic Resources)', 1, 0, '', ''), + ('338', 'Funding Information Note', 'Funding Information Note', 1, 0, '', ''), ('345', 'Acquisition Information Note', 'Acquisition Information Note', 0, 0, '', ''), ('371', 'Notes on Information Service Policy', 'Notes on Information Service Policy', 1, 0, '', ''), ('410', 'Series', 'Series', 0, 0, '', ''), @@ -484,6 +491,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('022', 'a', 'Country Code', 'Country Code', 0, 0, '', 0, '', '', '', 0, -5, '', '', '', NULL), ('022', 'b', 'Number', 'Number', 0, 0, '', 0, '', '', '', 0, -5, '', '', '', NULL), ('022', 'z', 'Erroneous Number', 'Erroneous Number', 1, 0, '', 0, '', '', '', 0, -5, '', '', '', NULL), + ('033', 'a', 'Persistent Record Identifier', 'Persistent Record Identifier', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), + ('033', 'z', 'Cancelled or Invalid Persistent Record Identifier', 'Cancelled or Invalid Persistent Record Identifier', 1, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), ('035', 'a', 'System Control Number', 'System Control Number', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('035', 'z', 'Cancelled or Invalid Control Number', 'Cancelled or Invalid Control Number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('036', '2', 'System Code for Musical Notation', 'System Code for Musical Notation', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), @@ -621,6 +630,10 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('182', '6', 'Interfield Linking Data', '', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', ''), ('182', 'a', 'ISBD Media Type Code', '', 0, 0, '', 1, 'unimarc_182a', '', '', 0, 0, '', '', '', ''), ('182', 'c', 'Other Coding for Media Type', '', 1, 0, '', 1, 'unimarc_182c', '', '', 0, 0, '', '', '', ''), + ('183', 'a', 'Type of Carrier Code', 'Type of Carrier Code', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL), + ('183', '2', 'System code', 'System code', 0, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL), + ('183', '6', 'Interfield Linking Data', 'Interfield Linking Data', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL), + ('183', '8', 'Materials specified', 'Materials specified', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL), ('200', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), ('200', 'a', 'Title Proper', 'Title Proper', 1, 0, 'biblio.title', 2, '', '', '', 0, 0, '', '', '', NULL), ('200', 'b', 'General Material Designation', 'General Material Designation', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), @@ -636,6 +649,9 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('200', 'r', 'Title Page Information Following the Title Proper', 'Title Page Information Following the Title Proper', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('200', 'v', 'Volume Designation', 'Volume Designation', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), ('200', 'z', 'Language of Parallel Title Proper', 'Language of Parallel Title Proper', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('203', 'a', 'Content form', 'Content form', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('203', 'b', 'Content qualification', 'Content qualification', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('203', 'c', 'Media type', 'Media type', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), ('204', 'a', 'GMD', 'GMD', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('205', 'a', 'Edition Statement', 'Edition Statement', 0, 0, 'biblioitems.editionstatement', 2, '', '', '', 0, 0, '', '', '', NULL), ('205', 'b', 'Issue Statement', 'Issue Statement', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), @@ -684,9 +700,23 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('225', 'x', 'ISSN of Series', 'ISSN of Series', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), ('225', 'z', 'Language of Parallel Title', 'Language of Parallel Title', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), ('230', 'a', 'Designation and Extent of File', 'Designation and Extent of File', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('231', 'a', 'File type', 'File type', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('231', 'b', 'Encoding standard', 'Encoding standard', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('231', 'c', 'Version of encoding standard', 'Version of encoding standard', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('231', 'd', 'Details of encoding standard', 'Details of encoding standard', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('231', 'e', 'File size', 'File size', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('231', 'f', 'Resolution', 'Resolution', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('231', 'g', 'Regional encoding', 'Regional encoding', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('231', 'h', 'Encoded bitrate', 'Encoded bitrate', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('231', '2', 'Source', 'Source', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('231', '6', 'Interfield linking data', 'Interfield linking data', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), ('251', 'a', 'Organization', 'Organization', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('251', 'b', 'Arrangement', 'Arrangement', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('251', 'c', 'Level', 'Level', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), + ('283', 'a', 'Carrier Type Designation', 'Carrier Type Designation', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('283', '2', 'System code', 'System code', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('283', '6', 'Interfield Linking Data', 'Interfield Linking Data', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), + ('283', '8', 'Materials specified', 'Materials specified', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL), ('300', 'a', 'Text of Note', 'Text of Note', 0, 0, 'biblio.notes', 3, '', '', '', 0, 0, '', '', '', NULL), ('301', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL), ('302', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL), @@ -790,6 +820,13 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('336', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL), ('337', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL), ('337', 'u', 'Uniform Resource Identifier (Uri)', 'Uniform Resource Identifier (Uri)', 1, 0, '', 3, '', '', '', 0, -6, '', '', '', NULL), + ('338', 'a', 'Text of Unstructured Note', 'Text of Unstructured Note', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', NULL), + ('338', 'b', 'Funding Organization', 'Funding Organization', 1, 0, '', 3, '', '', '', 0, 0, '', '', '', NULL), + ('338', 'c', 'Program', 'Program', 1, 0, '', 3, '', '', '', 0, 0, '', '', '', NULL), + ('338', 'd', 'Project Number', 'Project Number', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', NULL), + ('338', 'e', 'Jurisdiction', 'Jurisdiction', 1, 0, '', 3, '', '', '', 0, 0, '', '', '', NULL), + ('338', 'f', 'Project Name', 'Project Name', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', NULL), + ('338', 'g', 'Project Acronym', 'Project Acronym', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', NULL), ('345', 'a', 'Source for Acquisition/Subscription Address', 'Source for Acquisition/Subscription Address', 1, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL), ('345', 'b', 'Stock Number', 'Stock Number', 1, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL), ('345', 'c', 'Medium', 'Medium', 1, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL), -- 2.1.4