@@ -, +, @@ fr-FR installer - Hide 440 subfields by default - Make 490 3avx visible by default - Add mapping biblioitems.seriestitle to 490a - Add mapping biblioitems.volume to 490v - Run the web installer for this language and verify changes in all frameworks --- .../Obligatoire/marc21_framework_DEFAULT.sql | 19 +-- .../marc21_simple_bib_frameworks.sql | 153 +++++++++--------- 2 files changed, 91 insertions(+), 81 deletions(-) --- a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql +++ a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql @@ -1314,18 +1314,19 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('411', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), ('440', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), ('440', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), - ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), - ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', 4, '', 'UNIF_TITLE', '', NULL, 0, '', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), - ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, 0, '', '', '', NULL), - ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, 0, '', '', '', NULL), - ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, '', '', '', NULL), - ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, '', '', '', NULL), + ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', -6, '', 'UNIF_TITLE', '', NULL, 0, '', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), + ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('490', '3', 'Materials specified', 'Materials specified', 0, 0, '', 4, '', '', '', NULL, 0, '', '', '', NULL), ('490', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), ('490', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', NULL, NULL, -6, '', '', '', NULL), - ('490', 'a', 'Series statement', 'Series statement', 1, 0, '', 4, '', '', '', NULL, -1, '', '', '', NULL), + ('490', 'a', 'Series statement', 'Series statement', 1, 0, 'biblioitems.seriestitle', 4, '', '', '', NULL, 0, '', '', '', NULL), ('490', 'l', 'Library of Congress call number', 'Library of Congress call number', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), - ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, '', 4, '', '', '', NULL, -1, '', '', '', NULL), - ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -1, '', '', '', NULL), + ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, '', '', '', NULL), + ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, '', '', '', NULL), ('500', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('500', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('500', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), --- a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql +++ a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql @@ -1341,18 +1341,19 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('411', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('440', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('440', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', NULL, -6, 'BKS', '', '', NULL), - ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', 4, '', 'UNIF_TITLE', '', NULL, 0, 'BKS', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), - ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, 0, 'BKS', '', '', NULL), - ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, 0, 'BKS', '', '', NULL), - ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'BKS', '', '', NULL), - ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'BKS', '', '', NULL), + ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -6, 'BKS', '', '', NULL), + ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', -6, '', 'UNIF_TITLE', '', NULL, 0, 'BKS', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), + ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, -6, 'BKS', '', '', NULL), + ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, -6, 'BKS', '', '', NULL), + ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, -6, 'BKS', '', '', NULL), + ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'BKS', '', '', NULL), + ('490', '3', 'Materials specified', 'Materials specified', 0, 0, '', 4, '', '', '', NULL, 0, 'BKS', '', '', NULL), ('490', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('490', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', NULL, NULL, -6, 'BKS', '', '', NULL), - ('490', 'a', 'Series statement', 'Series statement', 1, 0, '', 4, '', '', '', NULL, -6, 'BKS', '', '', NULL), + ('490', 'a', 'Series statement', 'Series statement', 1, 0, 'biblioitems.seriestitle', 4, '', '', '', NULL, 0, 'BKS', '', '', NULL), ('490', 'l', 'Library of Congress call number', 'Library of Congress call number', 0, 0, '', 4, '', '', '', NULL, -6, 'BKS', '', '', NULL), - ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, '', 4, '', '', '', NULL, -6, 'BKS', '', '', NULL), - ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'BKS', '', '', NULL), + ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'BKS', '', '', NULL), + ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'BKS', '', '', NULL), ('500', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('500', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('500', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'BKS', '', '', NULL), @@ -5268,18 +5269,19 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('411', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'CF', '', '', NULL), ('440', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'CF', '', '', NULL), ('440', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', NULL, -6, 'CF', '', '', NULL), - ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, 'CF', '', '', NULL), - ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', 4, '', 'UNIF_TITLE', '', NULL, 0, 'CF', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), - ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, 0, 'CF', '', '', NULL), - ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, 0, 'CF', '', '', NULL), - ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'CF', '', '', NULL), - ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'CF', '', '', NULL), + ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -6, 'CF', '', '', NULL), + ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', -6, '', 'UNIF_TITLE', '', NULL, 0, 'CF', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), + ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, -6, 'CF', '', '', NULL), + ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, -6, 'CF', '', '', NULL), + ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, -6, 'CF', '', '', NULL), + ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'CF', '', '', NULL), + ('490', '3', 'Materials specified', 'Materials specified', 0, 0, '', 4, '', '', '', NULL, 0, 'CF', '', '', NULL), ('490', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'CF', '', '', NULL), ('490', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', NULL, NULL, -6, 'CF', '', '', NULL), - ('490', 'a', 'Series statement', 'Series statement', 1, 0, '', 4, '', '', '', NULL, -6, 'CF', '', '', NULL), + ('490', 'a', 'Series statement', 'Series statement', 1, 0, 'biblioitems.seriestitle', 4, '', '', '', NULL, 0, 'CF', '', '', NULL), ('490', 'l', 'Library of Congress call number', 'Library of Congress call number', 0, 0, '', 4, '', '', '', NULL, -6, 'CF', '', '', NULL), - ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, '', 4, '', '', '', NULL, -6, 'CF', '', '', NULL), - ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'CF', '', '', NULL), + ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'CF', '', '', NULL), + ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'CF', '', '', NULL), ('500', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, 'CF', '', '', NULL), ('500', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'CF', '', '', NULL), ('500', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'CF', '', '', NULL), @@ -9194,18 +9196,19 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('411', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'SR', '', '', NULL), ('440', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'SR', '', '', NULL), ('440', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', NULL, -6, 'SR', '', '', NULL), - ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, 'SR', '', '', NULL), - ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', 4, '', 'UNIF_TITLE', '', NULL, 0, 'SR', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), - ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, 0, 'SR', '', '', NULL), - ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, 0, 'SR', '', '', NULL), - ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'SR', '', '', NULL), - ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'SR', '', '', NULL), + ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -6, 'SR', '', '', NULL), + ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', -6, '', 'UNIF_TITLE', '', NULL, 0, 'SR', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), + ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, -6, 'SR', '', '', NULL), + ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, -6, 'SR', '', '', NULL), + ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, -6, 'SR', '', '', NULL), + ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'SR', '', '', NULL), + ('490', '3', 'Materials specified', 'Materials specified', 0, 0, '', 4, '', '', '', NULL, 0, 'SR', '', '', NULL), ('490', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'SR', '', '', NULL), ('490', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', NULL, NULL, -6, 'SR', '', '', NULL), - ('490', 'a', 'Series statement', 'Series statement', 1, 0, '', 4, '', '', '', NULL, -6, 'SR', '', '', NULL), + ('490', 'a', 'Series statement', 'Series statement', 1, 0, 'biblioitems.seriestitle', 4, '', '', '', NULL, 0, 'SR', '', '', NULL), ('490', 'l', 'Library of Congress call number', 'Library of Congress call number', 0, 0, '', 4, '', '', '', NULL, -6, 'SR', '', '', NULL), - ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, '', 4, '', '', '', NULL, -6, 'SR', '', '', NULL), - ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'SR', '', '', NULL), + ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'SR', '', '', NULL), + ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'SR', '', '', NULL), ('500', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, 'SR', '', '', NULL), ('500', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'SR', '', '', NULL), ('500', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'SR', '', '', NULL), @@ -13120,18 +13123,19 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('411', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'VR', '', '', NULL), ('440', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'VR', '', '', NULL), ('440', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', NULL, -6, 'VR', '', '', NULL), - ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, 'VR', '', '', NULL), - ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', 4, '', 'UNIF_TITLE', '', NULL, 0, 'VR', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), - ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, 0, 'VR', '', '', NULL), - ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, 0, 'VR', '', '', NULL), - ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'VR', '', '', NULL), - ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'VR', '', '', NULL), + ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -6, 'VR', '', '', NULL), + ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', -6, '', 'UNIF_TITLE', '', NULL, 0, 'VR', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), + ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, -6, 'VR', '', '', NULL), + ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, -6, 'VR', '', '', NULL), + ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, -6, 'VR', '', '', NULL), + ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'VR', '', '', NULL), + ('490', '3', 'Materials specified', 'Materials specified', 0, 0, '', 4, '', '', '', NULL, 0, 'VR', '', '', NULL), ('490', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'VR', '', '', NULL), ('490', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', NULL, NULL, -6, 'VR', '', '', NULL), - ('490', 'a', 'Series statement', 'Series statement', 1, 0, '', 4, '', '', '', NULL, -6, 'VR', '', '', NULL), + ('490', 'a', 'Series statement', 'Series statement', 1, 0, 'biblioitems.seriestitle', 4, '', '', '', NULL, 0, 'VR', '', '', NULL), ('490', 'l', 'Library of Congress call number', 'Library of Congress call number', 0, 0, '', 4, '', '', '', NULL, -6, 'VR', '', '', NULL), - ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, '', 4, '', '', '', NULL, -6, 'VR', '', '', NULL), - ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'VR', '', '', NULL), + ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'VR', '', '', NULL), + ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'VR', '', '', NULL), ('500', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, 'VR', '', '', NULL), ('500', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'VR', '', '', NULL), ('500', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'VR', '', '', NULL), @@ -17044,17 +17048,19 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('411', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'AR', '', '', NULL), ('440', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'AR', '', '', NULL), ('440', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', NULL, -6, 'AR', '', '', NULL), - ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, 'AR', '', '', NULL), - ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', 4, '', 'UNIF_TITLE', '', NULL, 0, 'AR', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), - ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, 0, 'AR', '', '', NULL), - ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, 0, 'AR', '', '', NULL), - ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'AR', '', '', NULL), - ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'AR', '', '', NULL), + ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -6, 'AR', '', '', NULL), + ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', -6, '', 'UNIF_TITLE', '', NULL, 0, 'AR', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), + ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, -6, 'AR', '', '', NULL), + ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, -6, 'AR', '', '', NULL), + ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, -6, 'AR', '', '', NULL), + ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'AR', '', '', NULL), + ('490', '3', 'Materials specified', 'Materials specified', 0, 0, '', 4, '', '', '', NULL, 0, 'AR', '', '', NULL), ('490', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'AR', '', '', NULL), ('490', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', NULL, NULL, -6, 'AR', '', '', NULL), - ('490', 'a', 'Series statement', 'Series statement', 1, 0, '', 4, '', '', '', NULL, -6, 'AR', '', '', NULL), + ('490', 'a', 'Series statement', 'Series statement', 1, 0, 'biblioitems.seriestitle', 4, '', '', '', NULL, 0, 'AR', '', '', NULL), ('490', 'l', 'Library of Congress call number', 'Library of Congress call number', 0, 0, '', 4, '', '', '', NULL, -6, 'AR', '', '', NULL), - ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, '', 4, '', '', '', NULL, -6, 'AR', '', '', NULL), + ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'AR', '', '', NULL), + ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'AR', '', '', NULL), ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'AR', '', '', NULL), ('500', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, 'AR', '', '', NULL), ('500', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'AR', '', '', NULL), @@ -20968,18 +20974,19 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('411', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'KT', '', '', NULL), ('440', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'KT', '', '', NULL), ('440', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', NULL, -6, 'KT', '', '', NULL), - ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, 'KT', '', '', NULL), - ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', 4, '', 'UNIF_TITLE', '', NULL, 0, 'KT', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), - ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, 0, 'KT', '', '', NULL), - ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, 0, 'KT', '', '', NULL), - ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'KT', '', '', NULL), - ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'KT', '', '', NULL), + ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -6, 'KT', '', '', NULL), + ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', -6, '', 'UNIF_TITLE', '', NULL, 0, 'KT', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), + ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, -6, 'KT', '', '', NULL), + ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, -6, 'KT', '', '', NULL), + ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, -6, 'KT', '', '', NULL), + ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'KT', '', '', NULL), + ('490', '3', 'Materials specified', 'Materials specified', 0, 0, '', 4, '', '', '', NULL, 0, 'KT', '', '', NULL), ('490', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'KT', '', '', NULL), ('490', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', NULL, NULL, -6, 'KT', '', '', NULL), - ('490', 'a', 'Series statement', 'Series statement', 1, 0, '', 4, '', '', '', NULL, -6, 'KT', '', '', NULL), + ('490', 'a', 'Series statement', 'Series statement', 1, 0, 'biblioitems.seriestitle', 4, '', '', '', NULL, 0, 'KT', '', '', NULL), ('490', 'l', 'Library of Congress call number', 'Library of Congress call number', 0, 0, '', 4, '', '', '', NULL, -6, 'KT', '', '', NULL), - ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, '', 4, '', '', '', NULL, -6, 'KT', '', '', NULL), - ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'KT', '', '', NULL), + ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'KT', '', '', NULL), + ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'KT', '', '', NULL), ('500', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, 'KT', '', '', NULL), ('500', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'KT', '', '', NULL), ('500', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'KT', '', '', NULL), @@ -24894,18 +24901,19 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('411', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'IR', '', '', NULL), ('440', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'IR', '', '', NULL), ('440', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', NULL, -6, 'IR', '', '', NULL), - ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, 'IR', '', '', NULL), - ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', 4, '', 'UNIF_TITLE', '', NULL, 0, 'IR', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), - ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, 0, 'IR', '', '', NULL), - ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, 0, 'IR', '', '', NULL), - ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'IR', '', '', NULL), - ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'IR', '', '', NULL), + ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -6, 'IR', '', '', NULL), + ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', -6, '', 'UNIF_TITLE', '', NULL, 0, 'IR', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), + ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, -6, 'IR', '', '', NULL), + ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, -6, 'IR', '', '', NULL), + ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, -6, 'IR', '', '', NULL), + ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'IR', '', '', NULL), + ('490', '3', 'Materials specified', 'Materials specified', 0, 0, '', 4, '', '', '', NULL, 0, 'IR', '', '', NULL), ('490', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'IR', '', '', NULL), ('490', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', NULL, NULL, -6, 'IR', '', '', NULL), - ('490', 'a', 'Series statement', 'Series statement', 1, 0, '', 4, '', '', '', NULL, -6, 'IR', '', '', NULL), + ('490', 'a', 'Series statement', 'Series statement', 1, 0, 'biblioitems.seriestitle', 4, '', '', '', NULL, 0, 'IR', '', '', NULL), ('490', 'l', 'Library of Congress call number', 'Library of Congress call number', 0, 0, '', 4, '', '', '', NULL, -6, 'IR', '', '', NULL), - ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, '', 4, '', '', '', NULL, -6, 'IR', '', '', NULL), - ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'IR', '', '', NULL), + ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'IR', '', '', NULL), + ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'IR', '', '', NULL), ('500', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, 'IR', '', '', NULL), ('500', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'IR', '', '', NULL), ('500', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'IR', '', '', NULL), @@ -27807,7 +27815,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('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, 'SER'), ('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, 'SER'), ('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, 'SER'), - ('440', 'SERIES--TITLE', 'SERIES STATEMENT/ADDED ENTRY--TITLE', 1, 0, NULL, 'SER'), + ('IR', 'SERIES--TITLE', 'SERIES STATEMENT/ADDED ENTRY--TITLE', 1, 0, NULL, 'SER'), ('490', 'SERIES STATEMENT', 'SERIES STATEMENT', 1, 0, '', 'SER'), ('500', 'GENERAL NOTE', 'GENERAL NOTE', 1, 0, NULL, 'SER'), ('501', 'WITH NOTE', 'WITH NOTE', 1, 0, NULL, 'SER'), @@ -28815,18 +28823,19 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('411', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'SER', '', '', NULL), ('440', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'SER', '', '', NULL), ('440', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', NULL, -6, 'SER', '', '', NULL), - ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, 'SER', '', '', NULL), - ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', 4, '', 'UNIF_TITLE', '', NULL, 0, 'SER', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), - ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, 0, 'SER', '', '', NULL), - ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, 0, 'SER', '', '', NULL), - ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'SER', '', '', NULL), - ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'SER', '', '', NULL), + ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -6, 'SER', '', '', NULL), + ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', -6, '', 'UNIF_TITLE', '', NULL, 0, 'SER', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), + ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, -6, 'SER', '', '', NULL), + ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, -6, 'SER', '', '', NULL), + ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, -6, 'SER', '', '', NULL), + ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'SER', '', '', NULL), + ('490', '3', 'Materials specified', 'Materials specified', 0, 0, '', 4, '', '', '', NULL, 0, 'SER', '', '', NULL), ('490', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, 'SER', '', '', NULL), ('490', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', NULL, NULL, -6, 'SER', '', '', NULL), - ('490', 'a', 'Series statement', 'Series statement', 1, 0, '', 4, '', '', '', NULL, -6, 'SER', '', '', NULL), + ('490', 'a', 'Series statement', 'Series statement', 1, 0, 'biblioitems.seriestitle', 4, '', '', '', NULL, 0, 'SER', '', '', NULL), ('490', 'l', 'Library of Congress call number', 'Library of Congress call number', 0, 0, '', 4, '', '', '', NULL, -6, 'SER', '', '', NULL), - ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, '', 4, '', '', '', NULL, -6, 'SER', '', '', NULL), - ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, 'SER', '', '', NULL), + ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, 'SER', '', '', NULL), + ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, 'SER', '', '', NULL), ('500', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, 'SER', '', '', NULL), ('500', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'SER', '', '', NULL), ('500', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'SER', '', '', NULL), --