Bugzilla – Attachment 102038 Details for
Bug 7947
440/490 Koha Mapping
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 7947: Update MARC21 440/490 mapping and visibility in uk-UA installer
Bug-7947-Update-MARC21-440490-mapping-and-visibili.patch (text/plain), 64.84 KB, created by
Katrin Fischer
on 2020-03-28 10:34:36 UTC
(
hide
)
Description:
Bug 7947: Update MARC21 440/490 mapping and visibility in uk-UA installer
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2020-03-28 10:34:36 UTC
Size:
64.84 KB
patch
obsolete
>From b1a6c2812bc1497d321afe77a68bc7fec8280b1a Mon Sep 17 00:00:00 2001 >From: Katrin Fischer <katrin.fischer.83@web.de> >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 >--- > .../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 | 32 +++++++++---------- > .../marc21_bibliographic_CF_local.sql | 2 +- > .../marc21_bibliographic_IR_general.sql | 32 +++++++++---------- > .../marc21_bibliographic_IR_local.sql | 2 +- > .../marc21_bibliographic_KT_general.sql | 32 +++++++++---------- > .../marc21_bibliographic_KT_local.sql | 2 +- > .../marc21_bibliographic_SER_general.sql | 32 +++++++++---------- > .../marc21_bibliographic_SER_local.sql | 2 +- > .../marc21_bibliographic_SR_general.sql | 32 +++++++++---------- > .../marc21_bibliographic_SR_local.sql | 2 +- > .../marc21_bibliographic_VR_general.sql | 32 +++++++++---------- > .../marc21_bibliographic_VR_local.sql | 2 +- > 18 files changed, 139 insertions(+), 139 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..81e07745ac 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); >- >-INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES >- ('CF', '490', '', 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', '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', 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, 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..ca56a404ba 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); >- >-INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES >- ('IR', '490', '', 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', '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', 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, 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..60ae4cf5a7 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); >- >-INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES >- ('KT', '490', '', 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', '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', 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, 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..a9984ae433 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); >- >-INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES >- ('SER', '490', '', 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', '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', 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, 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..caeed4c9be 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); >- >-INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES >- ('SR', '490', '', 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', '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', 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, 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..856a8a58a1 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); >- >-INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES >- ('VR', '490', '', 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', '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', 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, 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.17.1
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=102038">View the attachment on a separate page</a>.</b>
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 7947
:
102030
|
102031
|
102032
|
102033
|
102034
|
102035
|
102036
|
102037
|
102038
|
103572
|
103573
|
103574
|
103575
|
103576
|
103577
|
103578
|
103579
|
103580
|
103581
|
103582
|
103583
|
103584
|
104282
|
104283
|
104284
|
104285
|
104286
|
104287
|
104288
|
104289
|
104290
|
104291
|
104292