Bug 7947: Update MARC21 440/490 mapping and visibility in uk-UA 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 avx 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

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql
index 8e0ccbc..e5c6ef6 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql
@@ -1584,21 +1584,21 @@ INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable,
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
  ('', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
- ('', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
- ('', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
- ('', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, 0, '', '', '', NULL, '', '', NULL),
- ('', '', '440', 'v', 0, 0, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
- ('', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
+ ('', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
+ ('', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
+ ('', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
  ('', '490', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
  ('', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
- ('', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, -1, '', '', '', NULL, '', '', NULL),
+ ('', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
  ('', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
- ('', '', '490', 'v', 0, 1, '№ тому', '',                               4, -1, '', '', '', NULL, '', '', NULL),
- ('', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, -1, '', '', '', NULL, '', '', NULL);
+ ('', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
  ('', '500', 0, 1, 'Примітка', '', '');

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql
index 88e6bcf..8b64c97 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql
@@ -53,7 +53,7 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                     4, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                     4, -5, '', '', '', 0, '', '', NULL);
+ ('', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                     4, -6, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                     6, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql
index 77f182c..905b1f9 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql
@@ -1276,25 +1276,25 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
  ('AR', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('AR', '440', '', 1, 'Серія', '', NULL);
+ ('AR', '440', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('AR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
+ ('AR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
  ('AR', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
- ('AR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                    4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
- ('AR', '', '440', 'n', 0, 1, 'Номер частини', '',                      4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
- ('AR', '', '440', 'p', 0, 1, 'Назва частини', '',                      4, 0, '', '', '', NULL, '', '', NULL),
- ('AR', '', '440', 'v', 0, 0, '№ тому', '',                             4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
- ('AR', '', '440', 'x', 0, 0, 'ISSN серії', '',                         4, 0, '', '', '', NULL, '', '', NULL);
+ ('AR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
+ ('AR', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
+ ('AR', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('AR', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('AR', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('AR', '490', '', 1, 'Серія', '', '');
+ ('AR', '490', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('AR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
- ('AR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
- ('AR', '', '490', 'a', 0, 1, 'Назва серії', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('AR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
+ ('AR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
+ ('AR', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
  ('AR', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
- ('AR', '', '490', 'v', 0, 1, '№ тому', '',                             4, -6, '', '', '', NULL, '', '', NULL),
- ('AR', '', '490', 'x', 0, 0, 'ISSN серії', '',                         4, -6, '', '', '', NULL, '', '', NULL);
+ ('AR', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('AR', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
  ('AR', '500', '', 1, 'Примітка', '', NULL);

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql
index 3df307e..2824beb 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql
@@ -43,7 +43,7 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('AR', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('AR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
+ ('AR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -6, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('AR', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql
index 7eed081..fb73bc1 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql
@@ -1276,25 +1276,25 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
  ('BKS', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('BKS', '440', '', 1, 'Серія', '', NULL);
+ ('BKS', '440', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('BKS', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                   4, -6, '', '', '', NULL, '', '', NULL),
+ ('BKS', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
  ('BKS', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
- ('BKS', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                   4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
- ('BKS', '', '440', 'n', 0, 1, 'Номер частини', '',                     4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
- ('BKS', '', '440', 'p', 0, 1, 'Назва частини', '',                     4, 0, '', '', '', NULL, '', '', NULL),
- ('BKS', '', '440', 'v', 0, 0, '№ тому', '',                            4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
- ('BKS', '', '440', 'x', 0, 0, 'ISSN серії', '',                        4, 0, '', '', '', NULL, '', '', NULL);
+ ('BKS', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
+ ('BKS', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
+ ('BKS', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('BKS', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('BKS', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('BKS', '490', '', 1, 'Серія', '', '');
+ ('BKS', '490', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('BKS', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                   4, -6, '', '', '', NULL, '', '', NULL),
- ('BKS', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
- ('BKS', '', '490', 'a', 0, 1, 'Назва серії', '',                       4, -6, '', '', '', NULL, '', '', NULL),
+ ('BKS', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
+ ('BKS', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
+ ('BKS', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
  ('BKS', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
- ('BKS', '', '490', 'v', 0, 1, '№ тому', '',                            4, -6, '', '', '', NULL, '', '', NULL),
- ('BKS', '', '490', 'x', 0, 0, 'ISSN серії', '',                        4, -6, '', '', '', NULL, '', '', NULL);
+ ('BKS', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('BKS', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
  ('BKS', '500', '', 1, 'Примітка', '', NULL);

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql
index 1b0de9f..6f11b78 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql
@@ -43,7 +43,7 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('BKS', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  4, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('BKS', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  4, -5, '', '', '', 0, '', '', NULL);
+ ('BKS', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  4, -6, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('BKS', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  6, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql
index c3f7d1f..51a2a9d 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql
@@ -1276,25 +1276,25 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
  ('CF', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('CF', '440', '', 1, 'Серія', '', NULL);
+ ('CF', '440', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('CF', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
+ ('CF', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
  ('CF', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
- ('CF', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                    4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
- ('CF', '', '440', 'n', 0, 1, 'Номер частини', '',                      4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
- ('CF', '', '440', 'p', 0, 1, 'Назва частини', '',                      4, 0, '', '', '', NULL, '', '', NULL),
- ('CF', '', '440', 'v', 0, 0, '№ тому', '',                             4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
- ('CF', '', '440', 'x', 0, 0, 'ISSN серії', '',                         4, 0, '', '', '', NULL, '', '', NULL);
+ ('CF', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
+ ('CF', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
+ ('CF', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('CF', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('CF', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('CF', '490', '', 1, 'Серія', '', '');
+ ('CF', '490', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('CF', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
- ('CF', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
- ('CF', '', '490', 'a', 0, 1, 'Назва серії', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('CF', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
+ ('CF', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
+ ('CF', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
  ('CF', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
- ('CF', '', '490', 'v', 0, 1, '№ тому', '',                             4, -6, '', '', '', NULL, '', '', NULL),
- ('CF', '', '490', 'x', 0, 0, 'ISSN серії', '',                         4, -6, '', '', '', NULL, '', '', NULL);
+ ('CF', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('CF', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
  ('CF', '500', '', 1, 'Примітка', '', NULL);

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql
index 699bd5f..6226858 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql
@@ -43,7 +43,7 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('CF', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('CF', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
+ ('CF', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -6, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('CF', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql
index 1f1b50b..7ef0973 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql
@@ -1276,25 +1276,25 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
  ('IR', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('IR', '440', '', 1, 'Серія', '', NULL);
+ ('IR', '440', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('IR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
+ ('IR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
  ('IR', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
- ('IR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                    4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
- ('IR', '', '440', 'n', 0, 1, 'Номер частини', '',                      4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
- ('IR', '', '440', 'p', 0, 1, 'Назва частини', '',                      4, 0, '', '', '', NULL, '', '', NULL),
- ('IR', '', '440', 'v', 0, 0, '№ тому', '',                             4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
- ('IR', '', '440', 'x', 0, 0, 'ISSN серії', '',                         4, 0, '', '', '', NULL, '', '', NULL);
+ ('IR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
+ ('IR', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
+ ('IR', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('IR', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('IR', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('IR', '490', '', 1, 'Серія', '', '');
+ ('IR', '490', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('IR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
- ('IR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
- ('IR', '', '490', 'a', 0, 1, 'Назва серії', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('IR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
+ ('IR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
+ ('IR', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
  ('IR', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
- ('IR', '', '490', 'v', 0, 1, '№ тому', '',                             4, -6, '', '', '', NULL, '', '', NULL),
- ('IR', '', '490', 'x', 0, 0, 'ISSN серії', '',                         4, -6, '', '', '', NULL, '', '', NULL);
+ ('IR', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('IR', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
  ('IR', '500', '', 1, 'Примітка', '', NULL);

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql
index f58f27a..f3cca0b 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql
@@ -43,7 +43,7 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('IR', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('IR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
+ ('IR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -6, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('IR', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql
index 42d4c8d..dfee912 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql
@@ -1276,25 +1276,25 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
  ('KT', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('KT', '440', '', 1, 'Серія', '', NULL);
+ ('KT', '440', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('KT', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
+ ('KT', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
  ('KT', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
- ('KT', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                    4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
- ('KT', '', '440', 'n', 0, 1, 'Номер частини', '',                      4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
- ('KT', '', '440', 'p', 0, 1, 'Назва частини', '',                      4, 0, '', '', '', NULL, '', '', NULL),
- ('KT', '', '440', 'v', 0, 0, '№ тому', '',                             4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
- ('KT', '', '440', 'x', 0, 0, 'ISSN серії', '',                         4, 0, '', '', '', NULL, '', '', NULL);
+ ('KT', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
+ ('KT', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
+ ('KT', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('KT', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('KT', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('KT', '490', '', 1, 'Серія', '', '');
+ ('KT', '490', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('KT', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
- ('KT', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
- ('KT', '', '490', 'a', 0, 1, 'Назва серії', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('KT', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
+ ('KT', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
+ ('KT', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
  ('KT', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
- ('KT', '', '490', 'v', 0, 1, '№ тому', '',                             4, -6, '', '', '', NULL, '', '', NULL),
- ('KT', '', '490', 'x', 0, 0, 'ISSN серії', '',                         4, -6, '', '', '', NULL, '', '', NULL);
+ ('KT', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('KT', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
  ('KT', '500', '', 1, 'Примітка', '', NULL);

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql
index 7670a6a..e7a7029 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql
@@ -43,7 +43,7 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('KT', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('KT', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
+ ('KT', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -6, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('KT', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql
index e48310c..0596f5d 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql
@@ -1276,25 +1276,25 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
  ('SER', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('SER', '440', '', 1, 'Серія', '', NULL);
+ ('SER', '440', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('SER', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                   4, -6, '', '', '', NULL, '', '', NULL),
+ ('SER', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
  ('SER', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
- ('SER', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                   4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
- ('SER', '', '440', 'n', 0, 1, 'Номер частини', '',                     4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
- ('SER', '', '440', 'p', 0, 1, 'Назва частини', '',                     4, 0, '', '', '', NULL, '', '', NULL),
- ('SER', '', '440', 'v', 0, 0, '№ тому', '',                            4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
- ('SER', '', '440', 'x', 0, 0, 'ISSN серії', '',                        4, 0, '', '', '', NULL, '', '', NULL);
+ ('SER', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
+ ('SER', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
+ ('SER', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('SER', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('SER', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('SER', '490', '', 1, 'Серія', '', '');
+ ('SER', '490', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('SER', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                   4, -6, '', '', '', NULL, '', '', NULL),
- ('SER', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
- ('SER', '', '490', 'a', 0, 1, 'Назва серії', '',                       4, -6, '', '', '', NULL, '', '', NULL),
+ ('SER', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
+ ('SER', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
+ ('SER', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
  ('SER', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
- ('SER', '', '490', 'v', 0, 1, '№ тому', '',                            4, -6, '', '', '', NULL, '', '', NULL),
- ('SER', '', '490', 'x', 0, 0, 'ISSN серії', '',                        4, -6, '', '', '', NULL, '', '', NULL);
+ ('SER', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('SER', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
  ('SER', '500', '', 1, 'Примітка', '', NULL);

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql
index 118fcaf..77b8b16 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql
@@ -43,7 +43,7 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('SER', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  4, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('SER', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  4, -5, '', '', '', 0, '', '', NULL);
+ ('SER', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  4, -6, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('SER', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  6, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql
index b1d4535..5898006 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql
@@ -1276,25 +1276,25 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
  ('SR', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('SR', '440', '', 1, 'Серія', '', NULL);
+ ('SR', '440', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('SR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
+ ('SR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
  ('SR', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
- ('SR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                    4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
- ('SR', '', '440', 'n', 0, 1, 'Номер частини', '',                      4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
- ('SR', '', '440', 'p', 0, 1, 'Назва частини', '',                      4, 0, '', '', '', NULL, '', '', NULL),
- ('SR', '', '440', 'v', 0, 0, '№ тому', '',                             4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
- ('SR', '', '440', 'x', 0, 0, 'ISSN серії', '',                         4, 0, '', '', '', NULL, '', '', NULL);
+ ('SR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
+ ('SR', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
+ ('SR', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('SR', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('SR', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('SR', '490', '', 1, 'Серія', '', '');
+ ('SR', '490', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('SR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
- ('SR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
- ('SR', '', '490', 'a', 0, 1, 'Назва серії', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('SR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
+ ('SR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
+ ('SR', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
  ('SR', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
- ('SR', '', '490', 'v', 0, 1, '№ тому', '',                             4, -6, '', '', '', NULL, '', '', NULL),
- ('SR', '', '490', 'x', 0, 0, 'ISSN серії', '',                         4, -6, '', '', '', NULL, '', '', NULL);
+ ('SR', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('SR', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
  ('SR', '500', '', 1, 'Примітка', '', NULL);

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql
index 1862fb5..78e6d81 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql
@@ -43,7 +43,7 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('SR', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('SR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
+ ('SR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -6, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('SR', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql
index 87120eb..1d12beb 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql
@@ -1276,25 +1276,25 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
  ('VR', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('VR', '440', '', 1, 'Серія', '', NULL);
+ ('VR', '440', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('VR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
+ ('VR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
  ('VR', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
- ('VR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                    4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
- ('VR', '', '440', 'n', 0, 1, 'Номер частини', '',                      4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
- ('VR', '', '440', 'p', 0, 1, 'Назва частини', '',                      4, 0, '', '', '', NULL, '', '', NULL),
- ('VR', '', '440', 'v', 0, 0, '№ тому', '',                             4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
- ('VR', '', '440', 'x', 0, 0, 'ISSN серії', '',                         4, 0, '', '', '', NULL, '', '', NULL);
+ ('VR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
+ ('VR', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
+ ('VR', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('VR', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('VR', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
- ('VR', '490', '', 1, 'Серія', '', '');
+ ('VR', '490', 0, 1, 'Серія', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('VR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
- ('VR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
- ('VR', '', '490', 'a', 0, 1, 'Назва серії', '',                        4, -6, '', '', '', NULL, '', '', NULL),
+ ('VR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
+ ('VR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
+ ('VR', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
  ('VR', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
- ('VR', '', '490', 'v', 0, 1, '№ тому', '',                             4, -6, '', '', '', NULL, '', '', NULL),
- ('VR', '', '490', 'x', 0, 0, 'ISSN серії', '',                         4, -6, '', '', '', NULL, '', '', NULL);
+ ('VR', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
+ ('VR', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
  ('VR', '500', '', 1, 'Примітка', '', NULL);

diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql
index a75a0f6..38c63cd 100644 (file)
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql
@@ -43,7 +43,7 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('VR', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('VR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
+ ('VR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -6, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
  ('VR', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES