From 43f4da6902af302749cfdc69d83ee46ebf43e243 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Sat, 28 Mar 2020 11:23:54 +0100 Subject: [PATCH] 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 Signed-off-by: Jonathan Druart --- .../marc21_bibliographic_DEFAULT_general.sql | 16 ++++++------ .../marc21_bibliographic_DEFAULT_local.sql | 2 +- .../marc21_bibliographic_AR_general.sql | 26 +++++++++---------- .../marc21_bibliographic_AR_local.sql | 2 +- .../marc21_bibliographic_BKS_general.sql | 26 +++++++++---------- .../marc21_bibliographic_BKS_local.sql | 2 +- .../marc21_bibliographic_CF_general.sql | 26 +++++++++---------- .../marc21_bibliographic_CF_local.sql | 2 +- .../marc21_bibliographic_IR_general.sql | 26 +++++++++---------- .../marc21_bibliographic_IR_local.sql | 2 +- .../marc21_bibliographic_KT_general.sql | 26 +++++++++---------- .../marc21_bibliographic_KT_local.sql | 2 +- .../marc21_bibliographic_SER_general.sql | 26 +++++++++---------- .../marc21_bibliographic_SER_local.sql | 2 +- .../marc21_bibliographic_SR_general.sql | 26 +++++++++---------- .../marc21_bibliographic_SR_local.sql | 2 +- .../marc21_bibliographic_VR_general.sql | 26 +++++++++---------- .../marc21_bibliographic_VR_local.sql | 2 +- 18 files changed, 121 insertions(+), 121 deletions(-) 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 8e0ccbcbfa..e5c6ef6d92 100644 --- 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 88e6bcff73..8b64c97843 100644 --- 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 77f182c70b..905b1f964b 100644 --- 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 3df307e4fb..2824beb754 100644 --- 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 7eed081af4..fb73bc12b0 100644 --- 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 1b0de9f578..6f11b78109 100644 --- 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 c3f7d1fa42..51a2a9d339 100644 --- 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 699bd5fa0c..6226858d75 100644 --- 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 1f1b50baef..7ef0973698 100644 --- 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 f58f27a707..f3cca0b562 100644 --- 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 42d4c8dccf..dfee91265d 100644 --- 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 7670a6a6f2..e7a702967f 100644 --- 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 e48310c3ba..0596f5dbf6 100644 --- 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 118fcaf83c..77b8b16bd1 100644 --- 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 b1d45356e8..5898006e6e 100644 --- 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 1862fb5227..78e6d813d6 100644 --- 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 87120eb3ce..1d12beb7b3 100644 --- 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 a75a0f6434..38c63cdae6 100644 --- 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 -- 2.20.1