From 12cdc425b68270442fc5ce50988431438c6b46b8 Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Thu, 26 Apr 2018 10:52:50 -0300 Subject: [PATCH] Bug 19835: Fix repeatability on MARC21 subfields This followup fixes all repeatability cases, from updates 23+24+25 and a few older ones. To test: 0) Apply both patches 1) Remove all your frameworks 2) Check mandatory bibliographic and authority files load without problem 3) Check repeatability... Bibs and auth frameworks checked against LOC description. --- .../mandatory/authorities_normal_marc21.sql | 102 +++++++++--------- .../mandatory/marc21_framework_DEFAULT.sql | 32 +++--- 2 files changed, 67 insertions(+), 67 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 bdad8fad20..ed31ad2a3f 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 @@ -343,7 +343,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '034', 'm', 'Right ascension - eastern limit', 'Right ascension - eastern limit', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '034', 'n', 'Right ascension - western limit', 'Right ascension - western limit', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '034', 'p', 'Equinox', 'Equinox', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '034', 'r', 'Distance from earth', 'Distance from earth', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '034', 'r', 'Distance from earth', 'Distance from earth', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '034', 's', 'G-ring latitude', 'G-ring latitude', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '034', 't', 'G-ring longitude', 'G-ring longitude', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '034', 'x', 'Beginning date', 'Beginning date', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -363,7 +363,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '040', 'e', 'Description conventions', 'Description conventions', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '040', 'e', 'Description conventions', 'Description conventions', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '040', 'f', 'Subject heading/thesaurus conventions', 'Subject heading/thesaurus conventions', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '040', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '040', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -377,7 +377,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '043', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '043', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '045', 'a', 'Time period code', 'Time period code', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '045', 'b', 'Formatted 9999 B.C. through C.E. time period', 'Formatted 9999 B.C. through C.E. time period', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '045', 'b', 'Formatted 9999 B.C. through C.E. time period', 'Formatted 9999 B.C. through C.E. time period', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '045', 'c', 'Formatted pre-9999 B.C. time period', 'Formatted pre-9999 B.C. time period', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '045', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '045', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -413,7 +413,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '052', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '052', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '053', 'a', 'Classification number element-single number or beginning number of span', 'Classification number element--single number or beginning number of span', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '053', 'b', 'Classification number element-ending number of span', 'Classification number element--ending number of span', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '053', 'b', 'Classification number element-ending number of span', 'Classification number element--ending number of span', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '053', 'c', 'Explanatory term', 'Explanatory term', 0, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '053', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '053', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, 0, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -625,7 +625,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '100', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '100', 'q', 'Fuller form of name', 'Fuller form of name', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '100', 'r', 'Key for music', 'Key for music', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '100', 's', 'Version', 'Version', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '100', 's', 'Version', 'Version', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '100', 't', 'Title of a work', 'Title of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '100', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '100', 'x', 'General subdivision', 'General subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -648,7 +648,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '110', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '110', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '110', 'r', 'Key for music', 'Key for music', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '110', 's', 'Version', 'Version', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '110', 's', 'Version', 'Version', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '110', 't', 'Title of a work', 'Title of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '110', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '110', 'x', 'General subdivision', 'General subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -659,18 +659,18 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '111', 'a', 'Meeting name or jurisdiction name as entry element', 'Meeting name or jurisdiction name as entry element', 0, 0, 1, NULL, NULL, '''111e'',''111c'',''111d'',''111t'',''111s'',''111k'',''111n'',''111p'',''111g'',''111l'',''111f'',''111h'',''111x'',''111z'',''111y'',''111v''', 0, 0, 0, '', ''), ('', '111', 'b', 'Number [OBSOLETE]', 'Number [OBSOLETE]', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '111', 'c', 'Location of meeting', 'Location of meeting', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '111', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '111', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '111', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '111', 'f', 'Date of a work', 'Date of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '111', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '111', 'h', 'Medium', 'Medium', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '111', 'j', 'Relator term', 'Relator term', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '111', 'j', 'Relator term', 'Relator term', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '111', 'k', 'Form subheading', 'Form subheading', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '111', 'l', 'Language of a work', 'Language of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '111', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '111', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '111', 'q', 'Name of meeting following jurisdiction name entry element', 'Name of meeting following jurisdiction name entry element', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '111', 's', 'Version', 'Version', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '111', 's', 'Version', 'Version', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '111', 't', 'Title of a work', 'Title of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '111', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '111', 'x', 'General subdivision', 'General subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -690,7 +690,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '130', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '130', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '130', 'r', 'Key for music', 'Key for music', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '130', 's', 'Version', 'Version', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '130', 's', 'Version', 'Version', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '130', 't', 'Title of a work', 'Title of a work', 0, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '130', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '130', 'x', 'General subdivision', 'General subdivision', 1, 0, 1, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -978,7 +978,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '382', 'n', 'Number of performers of the same medium', 'Number of performers of the same medium', 1, 0, 3, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '382', 'p', 'Alternative medium of performance', 'Alternative medium of performance', 1, 0, 3, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '382', 'r', 'Total number of individuals performing alongside ensembles', 'Total number of individuals performing alongside ensembles', 0, 0, 3, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '382', 's', 'Total number of performers', 'Total number of performers', 1, 0, 3, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '382', 's', 'Total number of performers', 'Total number of performers', 0, 0, 3, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '382', 't', 'Total number of ensembles', 'Total number of ensembles', 0, 0, 3, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '382', 'v', 'Note', 'Note', 1, 0, 3, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '382', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, 3, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1034,7 +1034,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '400', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '400', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '400', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '400', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '400', 'i', 'Relationship information', 'Relationship information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '400', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '400', 'k', 'Form subheading', 'Form subheading', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '400', 'l', 'Language of a work', 'Language of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1044,7 +1044,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '400', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '400', 'q', 'Fuller form of name', 'Fuller form of name', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '400', 'r', 'Key for music', 'Key for music', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '400', 's', 'Version', 'Version', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '400', 's', 'Version', 'Version', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '400', 't', 'Title of a work', 'Title of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '400', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '400', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1064,7 +1064,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '410', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '410', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '410', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '410', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '410', 'i', 'Relationship information', 'Relationship information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '410', 'k', 'Form subheading', 'Form subheading', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '410', 'l', 'Language of a work', 'Language of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '410', 'm', 'Medium of performance for music', 'Medium of performance for music', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1072,7 +1072,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '410', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '410', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '410', 'r', 'Key for music', 'Key for music', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '410', 's', 'Version', 'Version', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '410', 's', 'Version', 'Version', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '410', 't', 'Title of a work', 'Title of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '410', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '410', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1087,19 +1087,19 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '411', 'a', 'Meeting name or jurisdiction name as entry element', 'Meeting name or jurisdiction name as entry element', 0, 0, 4, NULL, NULL, '''411e'',''411c'',''411d'',''411t'',''411s'',''411k'',''411n'',''411p'',''411g'',''411l'',''411f'',''411h'',''411x'',''411z'',''411y'',''411v''', 0, 0, 0, '', 'MEETI_NAME'), ('', '411', 'b', 'Number {OBSOLETE]', 'Number {OBSOLETE]', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '411', 'c', 'Location of meeting', 'Location of meeting', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '411', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '411', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '411', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '411', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '411', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '411', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '411', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '411', 'i', 'Relationship information', 'Relationship information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '411', 'j', 'Relator term', 'Relator term', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '411', 'k', 'Form subheading', 'Form subheading', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '411', 'l', 'Language of a work', 'Language of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '411', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '411', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '411', 'q', 'Name of meeting following jurisdiction name entry element', 'Name of meeting following jurisdiction name entry element', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '411', 's', 'Version', 'Version', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '411', 's', 'Version', 'Version', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '411', 't', 'Title of a work', 'Title of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '411', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '411', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1116,7 +1116,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '430', 'f', 'Date of a work', 'Date of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '430', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '430', 'h', 'Medium', 'Medium', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '430', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '430', 'i', 'Relationship information', 'Relationship information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '430', 'k', 'Form subheading', 'Form subheading', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '430', 'l', 'Language of a work', 'Language of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '430', 'm', 'Medium of performance for music', 'Medium of performance for music', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1124,7 +1124,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '430', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '430', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '430', 'r', 'Key for music', 'Key for music', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '430', 's', 'Version', 'Version', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '430', 's', 'Version', 'Version', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '430', 't', 'Title of a work', 'Title of a work', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '430', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '430', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1165,7 +1165,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '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, 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, 0, '', ''), ('', '450', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '450', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '450', 'i', 'Relationship information', 'Relationship information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '450', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '450', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '450', 'x', 'General subdivision', 'General subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1177,7 +1177,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '450', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '450', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 4, NULL, NULL, NULL, 0, 1, 0, '', ''), ('', '451', 'a', 'Geographic name', 'Geographic name', 0, 0, 4, NULL, NULL, '''451z'',''451x'',''451y'',''451v''', 0, 0, 0, '', 'GEOGR_NAME'), - ('', '451', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '451', 'i', 'Relationship information', 'Relationship information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '451', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '451', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '451', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1203,7 +1203,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '453', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '453', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 4, NULL, NULL, NULL, 0, 1, 0, '', ''), ('', '455', 'a', 'Genre/form term', 'Genre/form term', 0, 0, 4, NULL, NULL, '''455v'',''455x'',''455z'',''455y''', 0, 0, 0, '', 'GENRE/FORM'), - ('', '455', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '455', 'i', 'Relationship information', 'Relationship information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '455', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '455', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '455', 'x', 'General subdivision', 'General subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1221,7 +1221,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '462', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '462', '6', 'Linkage', 'Linkage', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '462', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '480', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '480', 'i', 'Relationship information', 'Relationship information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '480', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '480', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '480', 'x', 'General subdivision', 'General subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1231,7 +1231,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '480', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '480', '6', 'Linkage', 'Linkage', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '480', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '481', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '481', 'i', 'Relationship information', 'Relationship information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '481', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '481', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '481', 'x', 'General subdivision', 'General subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1241,7 +1241,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '481', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '481', '6', 'Linkage', 'Linkage', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '481', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '482', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '482', 'i', 'Relationship information', 'Relationship information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '482', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '482', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '482', 'x', 'General subdivision', 'General subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1251,7 +1251,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '482', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '482', '6', 'Linkage', 'Linkage', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '482', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '485', 'i', 'Relationship information', 'Relationship information', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '485', 'i', 'Relationship information', 'Relationship information', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '485', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '485', 'w', 'Control subfield', 'Control subfield', 0, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '485', 'x', 'General subdivision', 'General subdivision', 1, 0, 4, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1269,7 +1269,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '500', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '500', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '500', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '500', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '500', 'i', 'Relationship information', 'Relationship information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '500', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '500', 'k', 'Form subheading', 'Form subheading', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '500', 'l', 'Language of a work', 'Language of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1279,7 +1279,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '500', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '500', 'q', 'Fuller form of name', 'Fuller form of name', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '500', 'r', 'Key for music', 'Key for music', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '500', 's', 'Version', 'Version', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '500', 's', 'Version', 'Version', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '500', 't', 'Title of a work', 'Title of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '500', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '500', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1301,7 +1301,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '510', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '510', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '510', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '510', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '510', 'i', 'Relationship information', 'Relationship information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '510', 'k', 'Form subheading', 'Form subheading', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '510', 'l', 'Language of a work', 'Language of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '510', 'm', 'Medium of performance for music', 'Medium of performance for music', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1309,7 +1309,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '510', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '510', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '510', 'r', 'Key for music', 'Key for music', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '510', 's', 'Version', 'Version', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '510', 's', 'Version', 'Version', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '510', 't', 'Title of a work', 'Title of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '510', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '510', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1325,19 +1325,19 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '510', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 5, NULL, NULL, NULL, 0, 1, 0, '', ''), ('', '511', 'a', 'Meeting name or jurisdiction name as entry element', 'Meeting name or jurisdiction name as entry element', 0, 0, 5, NULL, NULL, '''511e'',''511c'',''511d'',''511t'',''511s'',''511k'',''511n'',''511p'',''511g'',''511l'',''511f'',''511h'',''511x'',''511z'',''511y'',''511v''', 0, 0, 0, '', 'MEETI_NAME'), ('', '511', 'c', 'Location of meeting', 'Location of meeting', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '511', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '511', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '511', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '511', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '511', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '511', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '511', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '511', 'i', 'Relationship information', 'Relationship information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '511', 'j', 'Relator term', 'Relator term', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '511', 'k', 'Form subheading', 'Form subheading', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '511', 'l', 'Language of a work', 'Language of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '511', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '511', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '511', 'q', 'Name of meeting following jurisdiction name entry element', 'Name of meeting following jurisdiction name entry element', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '511', 's', 'Version', 'Version', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '511', 's', 'Version', 'Version', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '511', 't', 'Title of a work', 'Title of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '511', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '511', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1356,7 +1356,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '530', 'f', 'Date of a work', 'Date of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '530', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '530', 'h', 'Medium', 'Medium', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '530', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '530', 'i', 'Relationship information', 'Relationship information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '530', 'k', 'Form subheading', 'Form subheading', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '530', 'l', 'Language of a work', 'Language of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '530', 'm', 'Medium of performance for music', 'Medium of performance for music', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1364,7 +1364,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '530', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '530', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '530', 'r', 'Key for music', 'Key for music', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '530', 's', 'Version', 'Version', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '530', 's', 'Version', 'Version', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '530', 't', 'Title of a work', 'Title of a work', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '530', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '530', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1411,7 +1411,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '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, 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, 0, '', ''), ('', '550', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '550', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '550', 'i', 'Relationship information', 'Relationship information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '550', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '550', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '550', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1426,7 +1426,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '550', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 5, NULL, NULL, NULL, 0, 1, 0, '', ''), ('', '551', 'a', 'Geographic name', 'Geographic name', 0, 0, 5, NULL, NULL, '''551z'',''551x'',''551y'',''551v''', 0, 0, 0, '', 'GEOGR_NAME'), ('', '551', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '551', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '551', 'i', 'Relationship information', 'Relationship information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '551', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '551', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '551', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1453,7 +1453,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '553', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '553', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, 5, NULL, NULL, NULL, 0, 1, 0, '', ''), ('', '555', 'a', 'Genre/form term', 'Genre/form term', 0, 0, 5, NULL, NULL, '''555v'',''555x'',''555z'',''555y''', 0, 0, 0, '', 'GENRE/FORM'), - ('', '555', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '555', 'i', 'Relationship information', 'Relationship information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '555', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '555', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '555', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1475,7 +1475,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '562', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '562', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '562', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '580', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '580', 'i', 'Relationship information', 'Relationship information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '580', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '580', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '580', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1487,7 +1487,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '580', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '580', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '580', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '581', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '581', 'i', 'Relationship information', 'Relationship information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '581', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '581', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '581', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1499,7 +1499,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '581', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '581', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '581', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '582', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '582', 'i', 'Relationship information', 'Relationship information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '582', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '582', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '582', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1511,7 +1511,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '582', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '582', '6', 'Linkage', 'Linkage', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '582', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '585', 'i', 'Relationship information', 'Relationship information', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '585', 'i', 'Relationship information', 'Relationship information', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '585', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '585', 'w', 'Control subfield', 'Control subfield', 0, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '585', 'x', 'General subdivision', 'General subdivision', 1, 0, 5, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1679,7 +1679,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '700', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '700', 'q', 'Fuller form of name', 'Fuller form of name', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '700', 'r', 'Key for music', 'Key for music', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '700', 's', 'Version', 'Version', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '700', 's', 'Version', 'Version', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '700', 't', 'Title of a work', 'Title of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '700', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '700', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1710,7 +1710,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '710', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '710', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '710', 'r', 'Key for music', 'Key for music', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '710', 's', 'Version', 'Version', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '710', 's', 'Version', 'Version', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '710', 't', 'Title of a work', 'Title of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '710', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '710', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1727,19 +1727,19 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '710', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '711', 'a', 'Meeting name or jurisdiction name as entry element', 'Meeting name or jurisdiction name as entry element', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '711', 'c', 'Location of meeting', 'Location of meeting', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '711', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '711', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '711', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '711', 'f', 'Date of a work', 'Date of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '711', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '711', 'g', 'Miscellaneous information', 'Miscellaneous information', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '711', 'h', 'Medium', 'Medium', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '711', 'i', 'Relationship information', 'Relationship information', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '711', 'j', 'Relator term', 'Relator term', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '711', 'k', 'Form subheading', 'Form subheading', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '711', 'l', 'Language of a work', 'Language of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '711', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '711', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '711', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '711', 'q', 'Name of meeting following jurisdiction name entry element', 'Name of meeting following jurisdiction name entry element', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '711', 's', 'Version', 'Version', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '711', 's', 'Version', 'Version', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '711', 't', 'Title of a work', 'Title of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '711', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '711', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), @@ -1764,10 +1764,10 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '730', 'l', 'Language of a work', 'Language of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '730', 'm', 'Medium of performance for music', 'Medium of performance for music', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '730', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '730', 'o', 'Arranged statement for music', 'Arranged statement for music', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '730', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '730', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '730', 'r', 'Key for music', 'Key for music', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), - ('', '730', 's', 'Version', 'Version', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), + ('', '730', 's', 'Version', 'Version', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '730', 't', 'Title of a work', 'Title of a work', 0, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '730', 'v', 'Form subdivision', 'Form subdivision', 1, 0, 7, NULL, NULL, NULL, 0, 0, 0, '', ''), ('', '730', 'w', 'Control subfield', 'Control subfield', 0, 0, 7, NULL, NULL, NULL, 0, 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 f504c98ec7..b78aa304ef 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 @@ -999,7 +999,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('130', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('130', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('130', 'r', 'Key for music', 'Key for music', 0, 0, NULL, 1, NULL, NULL, '', NULL, -1, '', '', '', NULL), - ('130', 's', 'Version', 'Version', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('130', 's', 'Version', 'Version', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('130', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('210', '2', 'Source', 'Source', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, '', '', '', NULL), ('210', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -1033,7 +1033,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('240', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'r', 'Key for music', 'Key for music', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL), - ('240', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL), + ('240', 's', 'Version', 'Version', 1, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL), ('241', 'a', 'Romanized title', 'Romanized title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('241', 'h', 'Medium', 'Medium', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('242', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -1062,7 +1062,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('243', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('243', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('243', 'r', 'Key for music', 'Key for music', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), - ('243', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL), + ('243', 's', 'Version', 'Version', 1, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL), ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, '', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h'',''505t''', '', NULL), @@ -1742,7 +1742,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('518', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('518', 'a', 'Date/time and place of an event note', 'Date/time and place of an event note', 0, 0, '', 5, '', '', '', NULL, 0, '', '', '', NULL), ('518', 'd', 'Date of event', 'Date of event', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), - ('518', 'o', 'Other event information', 'Other event information', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), + ('518', 'o', 'Other event information', 'Other event information', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('518', 'p', 'Place of event', 'Place of event', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('520', '2', 'Source', 'Source', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('520', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), @@ -2080,7 +2080,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('600', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), ('600', 'q', 'Fuller form of name', 'Fuller form of name', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL), ('600', 'r', 'Key for music', 'Key for music', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), - ('600', 's', 'Version', 'Version', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), + ('600', 's', 'Version', 'Version', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), ('600', 't', 'Title of a work', 'Title of a work', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL), ('600', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), ('600', 'v', 'Form subdivision', 'Form subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL), @@ -2110,7 +2110,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('610', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), ('610', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), ('610', 'r', 'Key for music', 'Key for music', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), - ('610', 's', 'Version', 'Version', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), + ('610', 's', 'Version', 'Version', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), ('610', 't', 'Title of a work', 'Title of a work', 0, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL), ('610', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), ('610', 'v', 'Form subdivision', 'Form subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL), @@ -2139,7 +2139,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('611', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('611', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('611', 'q', 'Name of meeting following jurisdiction name entry element', 'Name of meeting following jurisdiction name entry element', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('611', 's', 'Version', 'Version', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('611', 's', 'Version', 'Version', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('611', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL), ('611', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('611', 'v', 'Form subdivision', 'Form subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, -1, '', '', '', NULL), @@ -2167,7 +2167,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('630', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('630', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('630', 'r', 'Key for music', 'Key for music', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('630', 's', 'Version', 'Version', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('630', 's', 'Version', 'Version', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('630', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL), ('630', 'v', 'Form subdivision', 'Form subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL), ('630', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL), @@ -2479,7 +2479,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('700', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', 'q', 'Fuller form of name', 'Fuller form of name', 0, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL), ('700', 'r', 'Key for music', 'Key for music', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), - ('700', 's', 'Version', 'Version', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('700', 's', 'Version', 'Version', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', 't', 'Title of a work', 'Title of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), @@ -2524,7 +2524,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('710', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('710', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('710', 'r', 'Key for music', 'Key for music', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), - ('710', 's', 'Version', 'Version', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('710', 's', 'Version', 'Version', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('710', 't', 'Title of a work', 'Title of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('710', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('710', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), @@ -2551,7 +2551,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('711', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('711', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('711', 'q', 'Name of meeting following jurisdiction name entry element', 'Name of meeting following jurisdiction name entry element', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('711', 's', 'Version', 'Version', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('711', 's', 'Version', 'Version', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('711', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('711', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('711', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2595,7 +2595,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('730', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('730', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('730', 'r', 'Key for music', 'Key for music', 0, 0, '', 7, '', '', '', NULL, -1, '', '', '', NULL), - ('730', 's', 'Version', 'Version', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('730', 's', 'Version', 'Version', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('730', 't', 'Title of a work', 'Title of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('730', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('740', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), @@ -3181,7 +3181,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('800', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('800', 'q', 'Fuller form of name', 'Fuller form of name', 0, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL), ('800', 'r', 'Key for music', 'Key for music', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), - ('800', 's', 'Version', 'Version', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('800', 's', 'Version', 'Version', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('800', 't', 'Title of a work', 'Title of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('800', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('800', 'v', 'Volume/sequential designation', 'Volume/sequential designation', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), @@ -3211,7 +3211,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('810', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('810', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('810', 'r', 'Key for music', 'Key for music', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), - ('810', 's', 'Version', 'Version', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('810', 's', 'Version', 'Version', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('810', 't', 'Title of a work', 'Title of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('810', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('810', 'v', 'Volume/sequential designation', 'Volume/sequential designation', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), @@ -3240,7 +3240,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('811', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('811', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('811', 'q', 'Name of meeting following jurisdiction name entry element', 'Name of meeting following jurisdiction name entry element', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('811', 's', 'Version', 'Version', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('811', 's', 'Version', 'Version', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('811', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('811', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('811', 'v', 'Volume/sequential designation', 'Volume/sequential designation', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -3266,7 +3266,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('830', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('830', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('830', 'r', 'Key for music', 'Key for music', 0, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL), - ('830', 's', 'Version', 'Version', 0, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL), + ('830', 's', 'Version', 'Version', 1, 0, '', 8, '', '', '', NULL, -1, '', '', '', NULL), ('830', 't', 'Title of a work', 'Title of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('830', 'v', 'Volume/sequential designation', 'Volume/sequential designation', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('830', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), -- 2.17.0