Attachment 38145 Details for Bug 13322 – [PASSED QA] Bug 13322: Update MARC21 frameworks to Update No. 19

[patch] [PASSED QA] Bug 13322: Update MARC21 frameworks to Update No. 19

PASSED-QA-Bug-13322-Update-MARC21-frameworks-to-Up.patch (text/plain), 84.71 KB, created by Katrin Fischer on 2015-04-19 21:10:55 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2015-04-19 21:10:55 UTC

Size: 84.71 KB

patch

obsolete

>From bf410a77008a8630bba879b62f22a7f459712844 Mon Sep 17 00:00:00 2001
>From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
>Date: Sat, 22 Nov 2014 10:09:50 -0300
>Subject: [PATCH] [PASSED QA] Bug 13322: Update MARC21 frameworks to Update No.
> 19
>
>Summary of changes:
>1) Bibliographic
>- Added fields 370 and 388
>- 382s is non repeatable
>- $g added to 650 and 651
>- $g now repeatable on 100,110,111,130,240,243,246,247,
>  600,610,611,630,700,710,711,730,800,810,811 and 830
>
>2) Authority
>- Added field 388
>- New $g on 150,151,450,451,550,551,750 and 751
>- New $i on 700,710,711,730,748,750,751,755,762,780,781,782 and 785
>- New $4 on 700,710,711,730,748,750,751,755,762,780,781,782,785 and 788
>- $g now repeatable on 100,110,111,130,400,410,411,430,500,
>  510,511,530,700,710,711 and 730
>
>This patch updates MARC21 frameworks to Update No. 19 (October 2014)
>Also updates values on database for MARC21 installs.
>
>To test
>1. Apply the patch
>2. Run updatedatbase.pl, check that runs without error
>3. Remove default frameworks, bibliographic and authorities (all of them),
>load again. Check that both files load without errors.
>4. Verify changes
>
>Signed-off-by: Brendan Gallagher <brendan@bywatersolutions.com>
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>---
> .../marc21/mandatory/authorities_normal_marc21.sql |  80 ++++++++++-----
> .../marc21/mandatory/marc21_framework_DEFAULT.sql  |  67 ++++++++-----
> installer/data/mysql/updatedatabase.pl             | 109 +++++++++++++++++++++
> 3 files changed, 209 insertions(+), 47 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 90275df..f205398 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. 18 (April 2014)
>+--        Revised to Update No. 19 (October 2014)
> -- *******************************************************
> 
> -- ******************************************************
>@@ -181,6 +181,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l
> 		('', '384', 'KEY', 'KEY', 0, 0, NULL),
>         ('', '385', 'AUDIENCE CHARACTERISTICS', 'AUDIENCE CHARACTERISTICS', 1, 0, NULL),
>         ('', '386', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 1, 0, NULL),
>+        ('', '388', 'TIME PERIOD OF CREATION', 'TIME PERIOD OF CREATION', 1, 0, NULL),
> 		('', '400', 'SEE FROM TRACING--PERSONAL NAME', 'SEE FROM TRACING--PERSONAL NAME', 1, 0, NULL),
> 		('', '410', 'SEE FROM TRACING--CORPORATE NAME', 'SEE FROM TRACING--CORPORATE NAME', 1, 0, NULL),
> 		('', '411', 'SEE FROM TRACING--MEETING NAME', 'SEE FROM TRACING--MEETING NAME', 1, 0, NULL),
>@@ -577,7 +578,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '100', 'e', 'Relator term', 'Relator term', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '100', 'f', 'Date of a work', 'Date of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '100', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '100', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '100', 'h', 'Medium', 'Medium', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '100', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '100', 'k', 'Form subheading', 'Form subheading', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -602,7 +603,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '110', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '110', 'e', 'Relator term', 'Relator term', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '110', 'f', 'Date of a work', 'Date of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '110', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '110', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '110', 'h', 'Medium', 'Medium', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '110', 'k', 'Form subheading', 'Form subheading', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '110', 'l', 'Language of a work', 'Language of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -625,7 +626,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '111', 'd', 'Date of meeting', 'Date of meeting', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '111', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '111', 'f', 'Date of a work', 'Date of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '111', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '111', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '111', 'h', 'Medium', 'Medium', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '111', 'j', 'Relator term', 'Relator term', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '111', 'k', 'Form subheading', 'Form subheading', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -644,7 +645,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '130', 'a', 'Uniform title', 'Uniform title', 0, 0, 1, NULL, NULL, '''130o'',''130m'',''130r'',''130s'',''130d'',''130k'',''130n'',''130p'',''130g'',''130l'',''130f'',''130h'',''130t'',''130x'',''130z'',''130y'',''130v''', 0, 0, '', '', ''),
> 		('', '130', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '130', 'f', 'Date of a work', 'Date of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '130', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '130', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '130', 'h', 'Medium', 'Medium', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '130', 'k', 'Form subheading', 'Form subheading', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '130', 'l', 'Language of a work', 'Language of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -698,6 +699,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '148', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>         ('', '150', 'a', 'Topical term or geographic name entry element', 'Topical term or geographic name entry element', 0, 0, 1, NULL, NULL, '''150x'',''150z'',''150y'',''150v''', 0, 0, '', '', ''),
>         ('', '150', 'b', 'Topical term following geographic name entry element', 'Topical term following geographic name entry element', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '150', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '150', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '150', 'x', 'General subdivision', 'General subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '150', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -706,6 +708,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '150', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '151', 'a', 'Geographic name', 'Geographic name', 0, 0, 1, NULL, NULL, '''151z'',''151x'',''151y'',''151v''', 0, 0, '', '', ''),
> 		('', '151', 'b', 'Name following place as an entry element {OBSOLETE]', 'Name following place as an entry element {OBSOLETE]', 0, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '151', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '151', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '151', 'x', 'General subdivision', 'General subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '151', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -937,13 +940,19 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
>         ('', '386', '3', 'Materials specified', 'Materials specified', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
>         ('', '386', '6', 'Linkage', 'Linkage', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
>         ('', '386', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '388', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '388', '2', 'Source of term', 'Source of term', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '388', '3', 'Materials specified', 'Materials specified', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '388', '6', 'Linkage', 'Linkage', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '388', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '388', 'a', 'Time period of creation term', 'Time period of creation term', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '400', 'a', 'Personal name', 'Personal name', 0, 0, 4, NULL, NULL, '''400b'',''400c'',''400q'',''400d'',''400t'',''400o'',''400m'',''400r'',''400s'',''400k'',''400n'',''400p'',''400g'',''400l'',''400f'',''400h'',''400x'',''400z'',''400y'',''400v''', 0, 0, '', '', 'PERSO_NAME'),
> 		('', '400', 'b', 'Numeration', 'Numeration', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '400', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '400', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '400', 'e', 'Relator term', 'Relator term', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '400', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '400', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '400', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '400', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '400', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '400', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -973,7 +982,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '410', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '410', 'e', 'Relator term', 'Relator term', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '410', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '410', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '410', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '410', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '410', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '410', 'k', 'Form subheading', 'Form subheading', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1001,7 +1010,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '411', 'd', 'Date of meeting', 'Date of meeting', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '411', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '411', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '411', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '411', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '411', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '411', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '411', 'j', 'Relator term', 'Relator term', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1025,7 +1034,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '430', 'a', 'Uniform title', 'Uniform title', 0, 0, 4, NULL, NULL, '''430o'',''430m'',''430r'',''430s'',''430d'',''430k'',''430n'',''430p'',''430g'',''430l'',''430f'',''430h'',''430t'',''430x'',''430z'',''430y'',''430v''', 0, 0, '', '', 'UNIF_TITLE'),
> 		('', '430', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '430', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '430', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '430', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '430', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '430', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '430', 'k', 'Form subheading', 'Form subheading', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1061,6 +1070,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '448', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 4, NULL, NULL, NULL, 0, 1, '', '', ''),
> 		('', '450', 'a', 'Topical term or geographic name entry element', 'Topical term or geographic name entry element', 0, 0, 4, NULL, NULL, '''450x'',''450z'',''450y'',''450v''', 0, 0, '', '', 'TOPIC_TERM'),
> 		('', '450', 'b', 'Topical term following geographic name entry element', 'Topical term following geographic name entry element', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '450', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '450', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '450', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '450', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1074,6 +1084,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '450', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 4, NULL, NULL, NULL, 0, 1, '', '', ''),
> 		('', '451', 'a', 'Geographic name', 'Geographic name', 0, 0, 4, NULL, NULL, '''451z'',''451x'',''451y'',''451v''', 0, 0, '', '', 'GEOGR_NAME'),
> 		('', '451', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '451', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '451', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '451', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '451', 'x', 'General subdivision', 'General subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1162,7 +1173,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '500', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '500', 'e', 'Relator term', 'Relator term', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '500', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '500', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '500', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '500', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '500', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '500', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1193,7 +1204,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '510', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '510', 'e', 'Relator term', 'Relator term', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '510', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '510', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '510', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '510', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '510', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '510', 'k', 'Form subheading', 'Form subheading', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1221,7 +1232,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '511', 'd', 'Date of meeting', 'Date of meeting', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '511', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '511', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '511', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '511', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '511', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '511', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '511', 'j', 'Relator term', 'Relator term', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1246,7 +1257,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '530', 'a', 'Uniform title', 'Uniform title', 0, 0, 5, NULL, NULL, '''530o'',''530m'',''530r'',''530s'',''530d'',''530k'',''530n'',''530p'',''530g'',''530l'',''530f'',''530h'',''530t'',''530x'',''530z'',''530y'',''530v''', 0, 0, '', '', 'UNIF_TITLE'),
> 		('', '530', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '530', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '530', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '530', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '530', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '530', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '530', 'k', 'Form subheading', 'Form subheading', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1284,6 +1295,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '548', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 5, NULL, NULL, NULL, 0, 1, '', '', ''),
> 		('', '550', 'a', 'Topical term or geographic name entry element', 'Topical term or geographic name entry element', 0, 0, 5, NULL, NULL, '''550x'',''550z'',''550y'',''550v''', 0, 0, '', '', 'TOPIC_TERM'),
> 		('', '550', 'b', 'Topical term following geographic name entry element', 'Topical term following geographic name entry element', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '550', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '550', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '550', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '550', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1297,6 +1309,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '550', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '550', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 5, NULL, NULL, NULL, 0, 1, '', '', ''),
> 		('', '551', 'a', 'Geographic name', 'Geographic name', 0, 0, 5, NULL, NULL, '''551z'',''551x'',''551y'',''551v''', 0, 0, '', '', 'GEOGR_NAME'),
>+        ('', '551', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '551', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '551', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '551', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1524,9 +1537,9 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '700', 'e', 'Relator term', 'Relator term', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '700', 'f', 'Date of a work', 'Date of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '700', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '700', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '700', 'h', 'Medium', 'Medium', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '700', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '700', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '700', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '700', 'k', 'Form subheading', 'Form subheading', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '700', 'l', 'Language of a work', 'Language of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1546,7 +1559,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '700', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '700', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '700', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '700', '4', 'Relator code', 'Relator code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '700', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '700', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '700', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1556,9 +1569,9 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '710', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '710', 'e', 'Relator term', 'Relator term', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '710', 'f', 'Date of a work', 'Date of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '710', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '710', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '710', 'h', 'Medium', 'Medium', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '710', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '710', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '710', 'k', 'Form subheading', 'Form subheading', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '710', 'l', 'Language of a work', 'Language of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '710', 'm', 'Medium of performance for music', 'Medium of performance for music', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1576,7 +1589,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '710', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '710', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '710', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '710', '4', 'Relator code', 'Relator code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '710', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '710', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '710', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '710', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1611,9 +1624,9 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '730', 'a', 'Uniform title', 'Uniform title', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '730', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '730', 'f', 'Date of a work', 'Date of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '730', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '730', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '730', 'h', 'Medium', 'Medium', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '730', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '730', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '730', 'k', 'Form subheading', 'Form subheading', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '730', 'l', 'Language of a work', 'Language of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '730', 'm', 'Medium of performance for music', 'Medium of performance for music', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1631,10 +1644,12 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '730', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '730', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '730', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '730', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '730', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '730', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '730', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '748', 'a', 'Chronological term', 'Chronological term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '748', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '748', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '748', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '748', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1643,6 +1658,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '748', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '748', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '748', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '748', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '748', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '748', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '748', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1650,7 +1666,8 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
>         ('', '750', 'b', 'Topical term following geographic name entry element', 'Topical term following geographic name entry element', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '750', 'c', 'Location of event', 'Location of event', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '750', 'd', 'Active date', 'Active date', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '750', 'i', 'Explanatory text [CLASSIFICATION FORMAT]', 'Explanatory text [CLASSIFICATION FORMAT]', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '750', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '750', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '750', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '750', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '750', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1659,11 +1676,13 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '750', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '750', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '750', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '750', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '750', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '750', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '750', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '751', 'a', 'Geographic name', 'Geographic name', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '751', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '751', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '751', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '751', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '751', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '751', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1672,6 +1691,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '751', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '751', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '751', '3', 'Materials specified [CLASSIFICATION FORMAT]', 'Materials specified [CLASSIFICATION FORMAT]', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '751', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '751', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '751', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '751', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1697,6 +1717,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '754', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '754', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '755', 'a', 'Genre/form term as entry element', 'Genre/form term as entry element', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '755', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '755', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '755', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '755', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1704,6 +1725,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '755', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '755', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '755', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '755', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '755', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '755', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '755', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1721,11 +1743,12 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '761', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '761', '8', 'Field link and sequence number', 'Field link and sequence number', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>         ('', '762', 'a', 'Medium of performance term as entry element', 'Medium of performance term as entry element', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>-		('', '762', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '762', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>         ('', '762', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '762', 'z', 'Table number', 'Table number', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>         ('', '762', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>         ('', '762', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '762', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>         ('', '762', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '762', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '762', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1780,6 +1803,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '768', 'z', 'Table identification--Table number', 'Table identification--Table number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '768', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '768', '8', 'Field link and sequence number', 'Field link and sequence number', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '780', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '780', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '780', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '780', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1787,9 +1811,11 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '780', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '780', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '780', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '780', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '780', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '780', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '780', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '781', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '781', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '781', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '781', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1797,9 +1823,11 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '781', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '781', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '781', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '781', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '781', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '781', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '781', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '782', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '782', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '782', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '782', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1807,9 +1835,11 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '782', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '782', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '782', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '782', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '782', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '782', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '782', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '785', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '785', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '785', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '785', 'x', 'General subdivision', 'General subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1817,6 +1847,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '785', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '785', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '785', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '785', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '785', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '785', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '785', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>@@ -1824,6 +1855,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`
> 		('', '788', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '788', '0', 'Record control number', 'Record control number', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '788', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+		('', '788', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '788', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '788', '6', 'Linkage', 'Linkage', 0, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
> 		('', '788', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, 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 bb1c93d..30303ca 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. 18 (April 2014)
>+--           Revised to Update No. 19 (October 2014)
> -- *************************************************************
> 
> 
>@@ -299,6 +299,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`,
>         ('363', 'NORMALIZED DATE AND SEQUENTIAL DESIGNATION', 'NORMALIZED DATE AND SEQUENTIAL DESIGNATION', 1, 0, NULL, ''),
> 		('365', 'TRADE PRICE', 'TRADE PRICE', 1, 0, NULL, ''),
> 		('366', 'TRADE AVAILABILITY INFORMATION', 'TRADE AVAILABILITY INFORMATION', 1, 0, NULL, ''),
>+        ('370', 'ASSOCIATED PLACE', 'ASSOCIATED PLACE', 1, 0, NULL, ''),
>         ('377', 'ASSOCIATED LANGUAGE', 'ASSOCIATED LANGUAGE', 1, 0, NULL, ''),
>         ('380', 'FORM OF WORK', 'FORM OF WORK', 1, 0, NULL, ''),
>         ('381', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 1, 0, NULL, ''),
>@@ -307,6 +308,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`,
>         ('384', 'KEY', 'KEY', 0, 0, NULL, ''),
>         ('385', 'AUDIENCE CHARACTERISTICS', 'AUDIENCE CHARACTERISTICS', 1, 0, NULL, ''),
>         ('386', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 1, 0, NULL, ''),
>+        ('388', 'TIME PERIOD OF CREATION', 'TIME PERIOD OF CREATION', 1, 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, ''),
> 		('411', 'SERIES STATEMENT/ADDED ENTRY--MEETING NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'SERIES STATEMENT/ADDED ENTRY--MEETING NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 1, 0, NULL, ''),
>@@ -902,7 +904,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
> 		('100', 'e', 'Relator term', 'Relator term', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
> 		('100', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
>-		('100', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
>+		('100', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
> 		('100', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
> 		('100', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
> 		('100', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
>@@ -922,7 +924,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('110', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, '', 1, '', '', '', NULL, -1, '', '', '', NULL),
> 		('110', 'e', 'Relator term', 'Relator term', 1, 0, '', 1, '', '', '', NULL, 0, '', '', '', NULL),
> 		('110', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
>-		('110', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
>+		('110', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
> 		('110', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
> 		('110', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
> 		('110', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
>@@ -940,7 +942,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('111', 'd', 'Date of meeting', 'Date of meeting', 0, 0, NULL, 1, NULL, NULL, '', NULL, 0, '', '', '', NULL),
> 		('111', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, NULL, 1, NULL, NULL, '', NULL, 0, '', '', '', NULL),
> 		('111', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>-		('111', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>+		('111', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('111', 'j', 'Relator term', 'Relator term', 1, 0, NULL, 1, NULL, NULL, '', NULL, 0, '', '', '', NULL),
> 		('111', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('111', 'l', 'Language of a work', 'Language of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>@@ -956,7 +958,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('130', 'a', 'Uniform title', 'Uniform title', 0, 0, NULL, 1, NULL, 'UNIF_TITLE', '', NULL, -1, '', '''130o'',''130m'',''130r'',''130s'',''130d'',''130k'',''130n'',''130p'',''130g'',''130l'',''130f'',''130h'',''130t''', '', NULL),
> 		('130', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('130', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>-		('130', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>+		('130', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('130', 'h', 'Medium', 'Medium', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('130', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('130', 'l', 'Language of a work', 'Language of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -1, '', '', '', NULL),
>@@ -989,7 +991,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 0, -1, '', '', '', NULL),
> 		('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
> 		('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
>-		('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
>+		('240', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
> 		('240', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL),
> 		('240', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
> 		('240', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL),
>@@ -1018,7 +1020,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('243', 'a', 'Uniform title', 'Unifor title', 0, 0, '', 2, '', '', '', 1, -1, '', '', '', NULL),
> 		('243', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
> 		('243', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
>-		('243', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
>+		('243', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
> 		('243', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL),
> 		('243', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
> 		('243', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL),
>@@ -1050,7 +1052,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('246', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
> 		('246', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
> 		('246', 'f', 'Date or sequential designation', 'Date or sequential designation', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
>-		('246', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
>+		('246', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
> 		('246', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, -1, '', '', '', NULL),
> 		('246', 'i', 'Display text', 'Display text', 0, 0, '', 2, '', '', '', NULL, -1, '', '', '', NULL),
> 		('246', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
>@@ -1062,7 +1064,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('247', 'd', 'Designation of section (SE) [OBSOLETE]', 'Designation of section (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
> 		('247', 'e', 'Name of part/section (SE) [OBSOLETE]', 'Name of part/section (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
> 		('247', 'f', 'Date or sequential designation', 'Date or sequential designation', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
>-		('247', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
>+		('247', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
> 		('247', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, -1, '', '', '', NULL),
> 		('247', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
> 		('247', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL),
>@@ -1411,11 +1413,22 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('366', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 3, '', '', '', NULL, -1, '', '', '', NULL),
> 		('366', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 3, '', '', '', NULL, -1, '', '', '', NULL),
> 		('366', 'm', 'Identification of agency', 'Identification of agency', 0, 0, '', 3, '', '', '', NULL, -1, '', '', '', NULL),
>-        ('377', 'l', 'Language term', 'Language term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', '2', 'Source of term', 'Source of term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', 'c', 'Associated country', 'Associated country', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', 'f', 'Other associated place', 'Other associated place', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', 'g', 'Place of origin of work', 'Place of origin of work', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', 's', 'Start period', 'Start period', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', 't', 'End period', 'End period', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', 'v', 'Source of information', 'Source of information', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>         ('377', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>         ('377', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>         ('377', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>         ('377', 'a', 'Language code', 'Language code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('377', 'l', 'Language term', 'Language term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>         ('380', '0', 'Record control number', 'Record control number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>         ('380', '2', 'Source of term', 'Source of term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>         ('380', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>@@ -1437,7 +1450,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
>         ('382', 'd', 'Doubling instrument', 'Doubling instrument', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>         ('382', 'n', 'Number of performers of the same medium', 'Number of performers of the same medium', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>         ('382', 'p', 'Alternative medium of performance', 'Alternative medium of performance', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>-        ('382', 's', 'Total number of performers', 'Total number of performers', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('382', 's', 'Total number of performers', 'Total number of performers', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>         ('382', 'v', 'Note', 'Note', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>         ('383', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>         ('383', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>@@ -1468,6 +1481,12 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
>         ('386', 'b', 'Creator/contributor code', 'Creator/contributor code', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>         ('386', 'm', 'Demographic group term', 'Demographic group term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>         ('386', 'n', 'Demographic group code', 'Demographic group code', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('388', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('388', '2', 'Source of term', 'Source of term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('388', '3', ' Materials specified', ' Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('388', '6', ' Linkage', ' Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('388', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('388', 'a', 'Time period of creation term', 'Time period of creation term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
> 		('400', '4', 'Relator code', 'Relator code', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
> 		('400', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
> 		('400', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
>@@ -1970,7 +1989,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('600', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
> 		('600', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
> 		('600', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
>-		('600', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
>+		('600', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
> 		('600', 'h', 'Medium', 'Medium', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
> 		('600', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
> 		('600', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
>@@ -2001,7 +2020,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('610', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, '', 6, '', '', '', NULL, -1, '', '', '', NULL),
> 		('610', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
> 		('610', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
>-		('610', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
>+		('610', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
> 		('610', 'h', 'Medium', 'Medium', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
> 		('610', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
> 		('610', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
>@@ -2030,7 +2049,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('611', 'd', 'Date of meeting', 'Date of meeting', 0, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
> 		('611', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL),
> 		('611', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>-		('611', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>+		('611', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('611', 'h', 'Medium', 'Medium', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('611', 'j', 'Relator term', 'Relator term', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('611', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>@@ -2056,7 +2075,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('630', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('630', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', NULL, -1, '', '', '', NULL),
> 		('630', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>-		('630', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>+		('630', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('630', 'h', 'Medium', 'Medium', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('630', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('630', 'l', 'Language of a work', 'Language of a work', 0, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
>@@ -2094,6 +2113,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('650', 'c', 'Location of event', 'Location of event', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
> 		('650', 'd', 'Active dates', 'Active dates', 0, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
>         ('650', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
>+        ('650', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
> 		('650', 'v', 'Form subdivision', 'Form subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
> 		('650', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
> 		('650', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', 0, 0, '', '', '', NULL),
>@@ -2108,6 +2128,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('651', 'a', 'Geographic name', 'Geographic name', 0, 0, '', 6, '', 'GEOGR_NAME', '', NULL, 0, '', '', '', NULL),
> 		('651', 'b', 'Geographic name following place entry element [OBSOLETE]', 'Geographic name following place entry element [OBSOLETE]', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL),
> 		('651', 'e', 'Relator term', 'Relator term', 1, 0, '', 6, '', '', '', NULL, -1, '', '', '', NULL),
>+        ('651', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
> 		('651', 'v', 'Form subdivision', 'Form subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
> 		('651', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
> 		('651', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL),
>@@ -2344,7 +2365,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL),
> 		('700', 'e', 'Relator term', 'Relator term', 1, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL),
> 		('700', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
>-		('700', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
>+		('700', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
> 		('700', 'h', 'Medium', 'Medium', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
>         ('700', 'i', 'Relationship information', 'Relationship information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
> 		('700', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
>@@ -2390,7 +2411,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('710', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL),
> 		('710', 'e', 'Relator term', 'Relator term', 1, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL),
> 		('710', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
>-		('710', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
>+		('710', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
> 		('710', 'h', 'Medium', 'Medium', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
>         ('710', 'i', 'Relationship information', 'Relationship information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
> 		('710', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
>@@ -2417,7 +2438,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('711', 'd', 'Date of meeting', 'Date of meeting', 0, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
> 		('711', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
> 		('711', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>-		('711', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>+		('711', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('711', 'h', 'Medium', 'Medium', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>         ('711', 'i', 'Relationship information', 'Relationship information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
> 		('711', 'j', 'Relator term', 'Relator term', 1, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
>@@ -2459,7 +2480,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('730', 'a', 'Uniform title', 'Uniform title', 0, 0, '', 7, '', 'UNIF_TITLE', '', NULL, -1, '', '', '', NULL),
> 		('730', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
> 		('730', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
>-		('730', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
>+		('730', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
> 		('730', 'h', 'Medium', 'Medium', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
>         ('730', 'i', 'Relationship information', 'Relationship information', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
> 		('730', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL),
>@@ -3023,7 +3044,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('800', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
> 		('800', 'e', 'Relator term', 'Relator term', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
> 		('800', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
>-		('800', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
>+		('800', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('800', 'h', 'Medium', 'Medium', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('800', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('800', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
>@@ -3054,7 +3075,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('810', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
> 		('810', 'e', 'Relator term', 'Relator term', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
> 		('810', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
>-		('810', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
>+		('810', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('810', 'h', 'Medium', 'Medium', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('810', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('810', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
>@@ -3083,7 +3104,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('811', 'd', 'Date of meeting', 'Date of meeting', 0, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL),
> 		('811', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL),
> 		('811', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>-		('811', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>+		('811', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('811', 'h', 'Medium', 'Medium', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
> 		('811', 'j', 'Relator term', 'Relator term', 1, 0, NULL, 8, NULL, NULL, '', NULL, -1, '', '', '', NULL),
> 		('811', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL),
>@@ -3107,7 +3128,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
> 		('830', 'a', 'Uniform title', 'Uniform title', 0, 0, '', 8, '', 'UNIF_TITLE', '', NULL, -1, '', '', '', NULL),
> 		('830', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('830', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
>-		('830', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
>+		('830', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('830', 'h', 'Medium', 'Medium', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('830', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL),
> 		('830', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL),
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index ca27cde..d823e11 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -10048,6 +10048,115 @@ while ( my $file = readdir $dirh ) {
>     my $rv = $installer->load_sql( $update_dir . $file ) ? 0 : 1;
> }
> 
>+
>+$DBversion = "3.19.00.XXX";
>+if(CheckVersion($DBversion)) {
>+    if ( C4::Context->preference('marcflavour') eq 'MARC21' ) {
>+    $dbh->do(q{
>+        INSERT IGNORE INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES
>+        ('', '388', 'TIME PERIOD OF CREATION', 'TIME PERIOD OF CREATION', 1, 0, NULL);
>+    });
>+
>+    $dbh->do(q{
>+        INSERT IGNORE INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
>+        mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode) VALUES
>+        ('', '388', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '388', '2', 'Source of term', 'Source of term', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '388', '3', 'Materials specified', 'Materials specified', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '388', '6', 'Linkage', 'Linkage', 0, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '388', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '388', 'a', 'Time period of creation term', 'Time period of creation term', 1, 0, 3, NULL, NULL, NULL, 0, 0, '', '', '');
>+    });
>+
>+    $dbh->do(q{
>+        UPDATE IGNORE auth_subfield_structure SET repeatable = 1 WHERE tagsubfield = 'g' AND tagfield IN
>+        ('100','110','111','130','400','410','411','430','500','510','511','530','700','710','730');
>+    });
>+
>+    $dbh->do(q{
>+        INSERT IGNORE INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
>+        mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode) VALUES
>+        ('', '150', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '151', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '450', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '451', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '550', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '551', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '750', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '751', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '748', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '755', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '780', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '781', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '782', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '785', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '710', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '730', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '748', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '750', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '751', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '755', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '762', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '780', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '781', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '782', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '785', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', ''),
>+        ('', '788', '4', 'Relationship code', 'Relationship code', 1, 0, 7, NULL, NULL, NULL, 0, 0, '', '', '');
>+    });
>+
>+    $dbh->do(q{
>+        UPDATE IGNORE auth_subfield_structure SET liblibrarian = 'Relationship information', libopac = 'Relationship information'
>+        WHERE tagsubfield = 'i' AND tagfield IN ('700','710','730','750','751','762');
>+    });
>+
>+    $dbh->do(q{
>+        UPDATE IGNORE auth_subfield_structure SET liblibrarian = 'Relationship code', libopac = 'Relationship code'
>+        WHERE tagsubfield = '4' AND tagfield IN ('700','710');
>+    });
>+
>+    $dbh->do(q{
>+        INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) VALUES
>+        ('370', 'ASSOCIATED PLACE', 'ASSOCIATED PLACE', 1, 0, NULL, ''),
>+        ('388', 'TIME PERIOD OF CREATION', 'TIME PERIOD OF CREATION', 1, 0, NULL, '');
>+    });
>+
>+    $dbh->do(q{
>+        INSERT IGNORE INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory,
>+        kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) VALUES
>+        ('370', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', '2', 'Source of term', 'Source of term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', 'c', 'Associated country', 'Associated country', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', 'f', 'Other associated place', 'Other associated place', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', 'g', 'Place of origin of work', 'Place of origin of work', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', 's', 'Start period', 'Start period', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', 't', 'End period', 'End period', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('370', 'v', 'Source of information', 'Source of information', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('377', 'l', 'Language term', 'Language term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('382', 's', 'Total number of performers', 'Total number of performers', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('388', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('388', '2', 'Source of term', 'Source of term', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('388', '3', ' Materials specified', ' Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('388', '6', ' Linkage', ' Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('388', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('388', 'a', 'Time period of creation term', 'Time period of creation term', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
>+        ('650', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL),
>+        ('651', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, '', 6, '', '', '', 0, -1, '', '', '', NULL);
>+    });
>+
>+    $dbh->do(q{
>+        UPDATE IGNORE marc_subfield_structure SET repeatable = 1 WHERE tagsubfield = 'g' AND
>+        tagfield IN ('100','110','111','130','240','243','246','247','600','610','611','630','700','710','711','730','800','810','811','830');
>+    });
>+    }
>+
>+    print "Upgrade to $DBversion done (Bug 13322 - Update MARC21 frameworks to Update No. 19 - October 2014)\n";
>+    SetVersion($DBversion);
>+}
>+
>+
> =head1 FUNCTIONS
> 
> =head2 TableExists($table)
>-- 
>1.9.1

Actions: View | Diff | Splinter Review

Attachments on bug 13322: 36257 | 36258 | 36675 | 38145