From a2e047fc78048254c0e76abc19253b34f16d09c8 Mon Sep 17 00:00:00 2001 From: Mason James Date: Sat, 1 Jun 2013 13:51:18 +1200 Subject: [PATCH] [FOLLOWUP] Bug 5858 - Default frameworks missing many MARC21 tags Content-Type: text/plain; charset="utf-8" This patch is a *followup* to the previous patch Update MARC21 fields/subfields to version 16 http://www.loc.gov/marc/bibliographic/bdapndxg.html Only to new installs. To test: 1) Delete MARC21 default framework 2) Apply patch 3) Test that new default framework loads without problem Rebased to master. --- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 25 +++++-------------- 1 files changed, 7 insertions(+), 18 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 b9a682e..8448c4a 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 @@ -1,29 +1,13 @@ -- ************************************************************* --- KOHA 3.0 MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK --- --- PRETEST VERSION 0.1.7 --- 2007-11-05 --- --- edited --- by thd --- --- BASED UPON --- -- KOHA MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK -- --- PRETEST VERSION 0.2.8 --- 2007-11-05 -- -- original default requiring greater user customisation -- created by a few Koha Hands -- guided by Paul POULAIN --- --- revised and greatly enlarged to completion, --- well not quite complete yet today --- but close enough for someone to have use, -- by thd for LibLime -- --- Revised to Update No. 15 (September 2012) +-- Revised to Update No. 16 (April 2013) -- ************************************************************* @@ -272,7 +256,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('245', 'TITLE STATEMENT', 'TITLE STATEMENT', 0, 1, '', ''), ('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', 0, 0, NULL, ''), + ('250', 'EDITION STATEMENT', 'EDITION STATEMENT', 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, ''), @@ -322,6 +306,8 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('381', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 0, 1, NULL, ''), ('382', 'MEDIUM OF PERFORMANCE', 'MEDIUM OF PERFORMANCE', 0, 1, NULL, ''), ('383', 'NUMERIC DESIGNATION OF MUSICAL WORK', 'NUMERIC DESIGNATION OF MUSICAL WORK', 0, 1, NULL, ''), + ('385', 'AUDIENCE CHARACTERISTICS', 'AUDIENCE CHARACTERISTICS', 1, 0, NULL, ''), + ('386', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 1, 0, NULL, ''), ('384', 'KEY', 'KEY', 0, 0, NULL, ''), ('400', 'SERIES STATEMENT/ADDED ENTRY--PERSONAL NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'SERIES STATEMENT/ADDED ENTRY--PERSONAL NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 1, 0, NULL, ''), ('410', 'SERIES STATEMENT/ADDED ENTRY--CORPORATE NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'SERIES STATEMENT/ADDED ENTRY--CORPORATE NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 1, 0, NULL, ''), @@ -738,6 +724,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('045', 'b', 'Formatted 9999 B.C. through C.E. time period', 'Formatted 9999 B.C. through C.E. time period', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), ('045', 'c', 'Formatted pre-9999 B.C. time period', 'Formatted pre-9999 B.C. time period', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('046', '2', 'Source of date', 'Source of date', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('046', '3', 'Materials specified', 'Materials specified', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('046', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('046', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('046', 'a', 'Type of date code', 'Type of date code', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), @@ -750,6 +737,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('046', 'l', 'Ending date created', 'Ending date created', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('046', 'm', 'Beginning of date valid', 'Beginning of date valid', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('046', 'n', 'End of date valid', 'End of date valid', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('046', 'o', 'Single or starting date for aggregated content', 'Single or starting date for aggregated content', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('046', 'p', 'Ending date for aggregated content', 'Ending date for aggregated content', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('047', '2', 'Source of code', 'Source of code', 0, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), ('047', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('047', 'a', 'Form of musical composition code', 'Form of musical composition code', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), -- 1.7.2.5