From 62879335b9c6a6fb4dc6d6233670878225fd2029 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Sat, 28 Mar 2020 11:26:57 +0100 Subject: [PATCH] Bug 7947: Update MARC21 440/490 mapping and visibility in nb-NO installer 440 has been obsoleted in the standard for a long time. 490 is now used for series information. Changes made here only apply for new installations: - Hide 440 subfields by default - Make 490 3avx visible by default - Add mapping biblioitems.seriestitle to 490a - Add mapping biblioitems.volume to 490v To test: - Run the web installer for this language and verify changes in all frameworks --- .../mandatory/marc21_framework_DEFAULT.sql | 19 +-- .../optional/marc21_simple_bib_frameworks.sql | 152 +++++++++--------- .../normarc/Obligatorisk/normarc.sql | 2 +- 3 files changed, 91 insertions(+), 82 deletions(-) diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index 875f6fd9f0..f6402c8148 100644 --- a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/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', 4, '', 'UNIF_TITLE', '', NULL, -6, '', '''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), diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql index 687e3bb44e..7fb00d68e3 100644 --- a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql +++ b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql @@ -1340,18 +1340,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', 4, '', 'UNIF_TITLE', '', NULL, -6, '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), @@ -5266,18 +5267,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', 4, '', 'UNIF_TITLE', '', NULL, -6, '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), @@ -9191,18 +9193,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', 4, '', 'UNIF_TITLE', '', NULL, -6, '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), @@ -13116,18 +13119,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', 4, '', 'UNIF_TITLE', '', NULL, -6, '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), @@ -17039,18 +17043,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', 4, '', 'UNIF_TITLE', '', NULL, -6, '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', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 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), ('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), ('500', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'AR', '', '', NULL), @@ -20962,18 +20967,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', 4, '', 'UNIF_TITLE', '', NULL, -6, '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), @@ -24887,18 +24893,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', 4, '', 'UNIF_TITLE', '', NULL, -6, '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), @@ -28807,18 +28814,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', 4, '', 'UNIF_TITLE', '', NULL, -6, '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), diff --git a/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql b/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql index b404eef218..7015bcf694 100644 --- a/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql +++ b/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql @@ -320,7 +320,7 @@ INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,r INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('440','w','Sorteringsdelfelt for delfelt $a','Sorteringsdelfelt for delfelt $a','0','0','0','4','','','','0','-1','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('440','x','ISSN','ISSN','0','0','0','4','','','','0','-1','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('440','y','Nummerering i underserien','Nummerering i underserien','0','0','0','4','','','','0','-1','','','',NULL,'9999'); -INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('490','a','Serietittel','Serietittel','0','0','0','4','','','','0','-1','','','',NULL,'9999'); +INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('490','a','Serietittel','Serietittel','0','0','biblioitems.seriestitle','4','','','','0','-1','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('500','a','Notens tekst','Notens tekst','0','0','biblio.notes','5','','','','0','0','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('501','a','Notens tekst','Notens tekst','0','0','0','5','','','','0','-1','','','',NULL,'9999'); INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('502','a','Notens tekst','Notens tekst','0','0','0','5','','','','0','-1','','','',NULL,'9999'); -- 2.17.1