Attachment 21532 Details for Bug 10962 – Bug 10962 - Update MARC21 frameworks to Update Nr. 17 (September 2013)

[patch] Bug 10962 - Update MARC21 frameworks to Update Nr. 17 (September 2013)

Bug-10962---Update-MARC21-frameworks-to-Update-Nr-.patch (text/plain), 12.01 KB, created by Bernardo Gonzalez Kriegel on 2013-09-27 22:19:07 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Bernardo Gonzalez Kriegel

Created: 2013-09-27 22:19:07 UTC

Size: 12.01 KB

patch

obsolete

>From 8868f70a6e1a3a4113fb90e76a64052d8b3cf73b Mon Sep 17 00:00:00 2001
>From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
>Date: Fri, 27 Sep 2013 18:55:02 -0300
>Subject: [PATCH] Bug 10962 - Update MARC21 frameworks to Update Nr. 17
> (September 2013)
>
>This patch updates MARC21 default bibliografic
>framework and authorities frameworks to
>Update Nr. 17 (September 2013)
>
>Source
>
>Bibliographic: http://www.loc.gov/marc/bibliographic/bdapndxg.html
>Authorities: http://www.loc.gov/marc/authority/adapndxf.html
>
>Only to new installs.
>
>To test
>1) Remove default MARC21 framework
>2) Load marc21_framework_DEFAULT.sql
>3) Verify new subtags
>
>    015_q 020_q 024_q 027_q 800_7 810_7 811_7 830_7
>
>4) Remove authorities frameworks
>5) Load authorities_normal_marc21.sql
>6) Verify new subtags
>
>    020_q 024_q
>---
> .../marc21/mandatory/authorities_normal_marc21.sql |    4 +++-
> .../marc21/mandatory/marc21_framework_DEFAULT.sql  |   12 +++++++++---
> 2 files changed, 12 insertions(+), 4 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 bc17643..dc7c1e6 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. 16 (april 2013)
>+--        Revised to Update No. 17 (September 2013)
> -- *******************************************************
> 
> -- ******************************************************
>@@ -285,6 +285,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '016', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '020', 'a', 'International Standard Book Number', 'International Standard Book Number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '020', 'c', 'Terms of availability', 'Terms of availability', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '020', 'q', 'Qualifying information', 'Qualifying information', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '020', 'z', 'Canceled/invalid ISBN', 'Canceled/invalid ISBN', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '020', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '020', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -298,6 +299,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '024', 'a', 'Standard number or code', 'Standard number or code', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '024', 'c', 'Terms of availability', 'Terms of availability', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '024', 'd', 'Additional codes following the standard number or code', 'Additional codes following the standard number or code', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '024', 'q', 'Qualifying information', 'Qualifying information', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '024', 'z', 'Canceled/invalid standard number or code', 'Canceled/invalid standard number or code', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '024', '2', 'Source of number or code', 'Source of number or code', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '024', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 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 daf6794..d5f340d 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,12 +7,10 @@
> --                    guided by Paul POULAIN
> --                      by thd for LibLime
> --
>---           Revised to Update No. 16 (April 2013)
>+--           Revised to Update No. 17 (September 2013)
> -- *************************************************************
> 
> 
>-
>-
> -- ******************************************************
> -- KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
> -- ******************************************************
>@@ -534,6 +532,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('015', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
> 		('015', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
> 		('015', 'a', 'National bibliography number', 'National bibliography number', 1, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
>+		('015', 'q', 'Qualifying information', 'Qualifying information', 1, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
>         ('015', 'z', 'Canceled/invalid national bibliography number', 'Canceled/invalid national bibliography number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
> 		('016', '2', 'Source', 'Source', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
> 		('016', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
>@@ -555,6 +554,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('020', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
> 		('020', 'a', 'International Standard Book Number', 'International Standard Book Number', 0, 0, 'biblioitems.isbn', 0, '', '', '', 0, 0, '', '', '', NULL),
> 		('020', 'c', 'Terms of availability', 'Terms of availability', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
>+		('020', 'q', 'Qualifying information', 'Qualifying information', 1, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
>         ('020', 'z', 'Canceled/invalid ISBN', 'Canceled/invalid ISBN', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
> 		('022', '2', 'Source', 'Source', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
> 		('022', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
>@@ -572,6 +572,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('024', 'b', 'Additional codes following the standard number [OBSOLETE]', 'Additional codes following the standard number [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
> 		('024', 'c', 'Terms of availability', 'Terms of availability', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
> 		('024', 'd', 'Additional codes following the standard number or code', 'Additional codes following the standard number or code', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
>+		('024', 'q', 'Qualifying information', 'Qualifying information', 1, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
> 		('024', 'z', 'Canceled/invalid standard number or code', 'Canceled/invalid standard number or code', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
> 		('025', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
> 		('025', 'a', 'Overseas acquisition number', 'Overseas acquisition number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
>@@ -587,6 +588,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('027', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
> 		('027', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
> 		('027', 'a', 'Standard technical report number', 'Standard technical report number', 0, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
>+		('027', 'q', 'Qualifying information', 'Qualifying information', 1, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
> 		('027', 'z', 'Canceled/invalid number', 'Canceled/invalid number', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL),
> 		('028', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
> 		('028', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
>@@ -3011,6 +3013,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('800', '4', 'Relator code', 'Relator code', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
>         ('800', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('800', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
>+		('800', '7', 'Control subfield', 'Control subfield', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('800', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('800', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, '', '', '', NULL),
> 		('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -1, '', '', '', NULL),
>@@ -3041,6 +3044,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('810', '4', 'Relator code', 'Relator code', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
>         ('810', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('810', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
>+		('810', '7', 'Control subfield', 'Control subfield', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('810', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('810', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, '', '', '', NULL),
> 		('810', 'a', 'Corporate name or jurisdiction name as entry element', 'Corporate name or jurisdiction name as entry element', 0, 0, '', 8, '', 'CORPO_NAME', '', NULL, -1, '', '', '', NULL),
>@@ -3069,6 +3073,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('811', '4', 'Relator code', 'Relator code', 1, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL),
>         ('811', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('811', '6', 'Linkage', 'Linkage', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>+		('811', '7', 'Control subfield', 'Control subfield', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('811', '8', 'Field link and sequence number ', 'Field link and sequence number ', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('811', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, '', '', '', NULL),
> 		('811', 'a', 'Meeting name or jurisdiction name as entry element', 'Meeting name or jurisdiction name as entry element', 0, 0, NULL, 8, NULL, 'MEETI_NAME', '', NULL, -1, '', '', '', NULL),
>@@ -3095,6 +3100,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
>         ('830', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
>         ('830', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('830', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
>+		('830', '7', 'Control subfield', 'Control subfield', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('830', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('830', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, '', '', '', NULL),
> 		('830', 'a', 'Uniform title', 'Uniform title', 0, 0, '', 8, '', 'UNIF_TITLE', '', NULL, -1, '', '', '', NULL),
>-- 
>1.7.9.5

Actions: View | Diff | Splinter Review

Attachments on bug 10962: 21532 | 21572 | 21594