From a056c1bfae3f5c5a4b876bec4b55689ed7c889a1 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Mon, 26 Feb 2018 10:48:50 +0100 Subject: [PATCH] Bug 20075: Update installer files for ru-RU Content-Type: text/plain; charset=utf-8 Instead of the very laborious task of going thru all these files line by line, I am adding a statement at the very end to correct hidden values. Test plan: Run a new Russian install or run a few files on an empty database. --- .../marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_local.sql | 3 +++ .../marc21/optional/marc21_authorities_CHRON_TERM_general.sql | 3 +++ .../marc21/optional/marc21_authorities_CHRON_TERM_local.sql | 3 +++ .../marc21/optional/marc21_authorities_CORPO_NAME_general.sql | 3 +++ .../marc21/optional/marc21_authorities_CORPO_NAME_local.sql | 3 +++ .../marc21/optional/marc21_authorities_GENRE-FORM_general.sql | 3 +++ .../marc21/optional/marc21_authorities_GENRE-FORM_local.sql | 3 +++ .../marc21/optional/marc21_authorities_GEOGR_NAME_general.sql | 3 +++ .../marc21/optional/marc21_authorities_GEOGR_NAME_local.sql | 3 +++ .../marc21/optional/marc21_authorities_MEETI_NAME_general.sql | 3 +++ .../marc21/optional/marc21_authorities_MEETI_NAME_local.sql | 3 +++ .../marc21/optional/marc21_authorities_PERSO_NAME_general.sql | 3 +++ .../marc21/optional/marc21_authorities_PERSO_NAME_local.sql | 3 +++ .../marc21/optional/marc21_authorities_TOPIC_TERM_general.sql | 3 +++ .../marc21/optional/marc21_authorities_TOPIC_TERM_local.sql | 3 +++ .../marc21/optional/marc21_authorities_UNIF_TITLE_general.sql | 3 +++ .../marc21/optional/marc21_authorities_UNIF_TITLE_local.sql | 3 +++ .../unimarc/mandatory/unimarc_authorities_DEFAULT_general.sql | 3 +++ .../marcflavour/unimarc/optional/unimarc_authorities_CO_general.sql | 3 +++ .../marcflavour/unimarc/optional/unimarc_authorities_NP_general.sql | 3 +++ .../unimarc/optional/unimarc_authorities_SAUTTIT_general.sql | 3 +++ .../marcflavour/unimarc/optional/unimarc_authorities_SAUT_general.sql | 3 +++ .../marcflavour/unimarc/optional/unimarc_authorities_SCO_general.sql | 3 +++ .../marcflavour/unimarc/optional/unimarc_authorities_SNC_general.sql | 3 +++ .../marcflavour/unimarc/optional/unimarc_authorities_SNG_general.sql | 3 +++ .../marcflavour/unimarc/optional/unimarc_authorities_STU_general.sql | 3 +++ .../marcflavour/unimarc/optional/unimarc_authorities_TU_general.sql | 3 +++ 27 files changed, 81 insertions(+) diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_local.sql index 7742e6c..b488229 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_local.sql @@ -42,3 +42,6 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, ('', '942', 1, '', 'KOHA INTERNAL USE', 'KOHA INTERNAL USE', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', '', '942', 'a', 1, 0, 'Koha auth type', 'Koha auth type', 9, 8, 'auth_header.authtypecode', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql index 058a47f..ce60cce 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql @@ -1060,3 +1060,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'CHRON_TERM', '880', 'x', 0, 1, 'x', 'x', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '880', 'y', 0, 1, 'y', 'y', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '880', 'z', 0, 1, 'z', 'z', 8, 0, '', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_local.sql index a3b6749..d6f9975 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_local.sql @@ -42,3 +42,6 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, ('CHRON_TERM', '942', 1, '', 'KOHA INTERNAL USE', 'KOHA INTERNAL USE', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'CHRON_TERM', '942', 'a', 1, 0, 'Koha auth type', 'Koha auth type', 9, 8, 'auth_header.authtypecode', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql index cd91143..0f391d1 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql @@ -1127,3 +1127,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'CORPO_NAME', '880', 'x', 0, 1, 'x', 'x', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CORPO_NAME', '880', 'y', 0, 1, 'y', 'y', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CORPO_NAME', '880', 'z', 0, 1, 'z', 'z', 8, 0, '', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_local.sql index 4fdfc68..096ffcc 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_local.sql @@ -42,3 +42,6 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, ('CORPO_NAME', '942', 1, '', 'KOHA INTERNAL USE', 'KOHA INTERNAL USE', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'CORPO_NAME', '942', 'a', 1, 0, 'Koha auth type', 'Koha auth type', 9, 8, 'auth_header.authtypecode', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql index ff53c76..f2560f7 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql @@ -1070,3 +1070,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'GENRE/FORM', '880', 'x', 0, 1, 'x', 'x', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GENRE/FORM', '880', 'y', 0, 1, 'y', 'y', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GENRE/FORM', '880', 'z', 0, 1, 'z', 'z', 8, 0, '', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_local.sql index a54e4df..07d75af 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_local.sql @@ -42,3 +42,6 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, ('GENRE/FORM', '942', 1, '', 'KOHA INTERNAL USE', 'KOHA INTERNAL USE', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'GENRE/FORM', '942', 'a', 1, 0, 'Koha auth type', 'Koha auth type', 9, 8, 'auth_header.authtypecode', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql index 4e8896b..4d92b4c 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql @@ -1062,3 +1062,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'GEOGR_NAME', '880', 'x', 0, 1, 'x', 'x', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GEOGR_NAME', '880', 'y', 0, 1, 'y', 'y', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GEOGR_NAME', '880', 'z', 0, 1, 'z', 'z', 8, 0, '', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_local.sql index 4b4d662..9d1489e 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_local.sql @@ -42,3 +42,6 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, ('GEOGR_NAME', '942', 1, '', 'KOHA INTERNAL USE', 'KOHA INTERNAL USE', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'GEOGR_NAME', '942', 'a', 1, 0, 'Koha auth type', 'Koha auth type', 9, 8, 'auth_header.authtypecode', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql index 2e9de3f..3ae95ae 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql @@ -1113,3 +1113,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'MEETI_NAME', '880', 'x', 0, 1, 'x', 'x', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'MEETI_NAME', '880', 'y', 0, 1, 'y', 'y', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'MEETI_NAME', '880', 'z', 0, 1, 'z', 'z', 8, 0, '', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_local.sql index 9c3cf57..76886d8 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_local.sql @@ -42,3 +42,6 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, ('MEETI_NAME', '942', 1, '', 'KOHA INTERNAL USE', 'KOHA INTERNAL USE', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'MEETI_NAME', '942', 'a', 1, 0, 'Koha auth type', 'Koha auth type', 9, 8, 'auth_header.authtypecode', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql index f4add34..6dc04a4 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql @@ -1109,3 +1109,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'PERSO_NAME', '880', 'x', 0, 1, 'x', 'x', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'PERSO_NAME', '880', 'y', 0, 1, 'y', 'y', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'PERSO_NAME', '880', 'z', 0, 1, 'z', 'z', 8, 0, '', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_local.sql index 0d8d56c..36868d5 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_local.sql @@ -42,3 +42,6 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, ('PERSO_NAME', '942', 1, '', 'KOHA INTERNAL USE', 'KOHA INTERNAL USE', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'PERSO_NAME', '942', 'a', 1, 0, 'Koha auth type', 'Koha auth type', 9, 8, 'auth_header.authtypecode', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql index 37f221c..91d900a 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql @@ -1064,3 +1064,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'TOPIC_TERM', '880', 'x', 0, 1, 'x', 'x', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'TOPIC_TERM', '880', 'y', 0, 1, 'y', 'y', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'TOPIC_TERM', '880', 'z', 0, 1, 'z', 'z', 8, 0, '', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_local.sql index f612172..0e4e8b7 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_local.sql @@ -42,3 +42,6 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, ('TOPIC_TERM', '942', 1, '', 'KOHA INTERNAL USE', 'KOHA INTERNAL USE', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'TOPIC_TERM', '942', 'a', 1, 0, 'Koha auth type', 'Koha auth type', 9, 8, 'auth_header.authtypecode', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql index cd6edcf..3cf1f65 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql @@ -1172,3 +1172,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'UNIF_TITLE', '880', 'x', 0, 1, 'x', 'x', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'UNIF_TITLE', '880', 'y', 0, 1, 'y', 'y', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', 'UNIF_TITLE', '880', 'z', 0, 1, 'z', 'z', 8, 0, '', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_local.sql index e619a55..d2e25cc 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_local.sql @@ -42,3 +42,6 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, ('UNIF_TITLE', '942', 1, '', 'KOHA INTERNAL USE', 'KOHA INTERNAL USE', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'UNIF_TITLE', '942', 'a', 1, 0, 'Koha auth type', 'Koha auth type', 9, 8, 'auth_header.authtypecode', NULL, NULL, 0, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_authorities_DEFAULT_general.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_authorities_DEFAULT_general.sql index 9157800..31388af 100644 --- a/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_authorities_DEFAULT_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_authorities_DEFAULT_general.sql @@ -576,3 +576,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '886', '2', 0, 0, 'Системний код', 'Системний код', 0, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', '', '886', 'a', 0, 1, 'Тег поля початкового формату', 'Тег поля початкового формату', 0, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', '', '886', 'b', 0, 1, 'Індикатори та підполя поля початкового формату', 'Індикатори та підполя поля початкового формату', 0, 0, NULL, NULL, NULL, NULL, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_CO_general.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_CO_general.sql index 08a4465..2a7fb5b 100644 --- a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_CO_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_CO_general.sql @@ -335,3 +335,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'CO', '886', '2', 0, 0, 'Системний код', 'Системний код', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'CO', '886', 'a', 0, 1, 'Тег поля початкового формату', 'Тег поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'CO', '886', 'b', 0, 1, 'Індикатори та підполя поля початкового формату', 'Індикатори та підполя поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_NP_general.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_NP_general.sql index 8c95212..216f103 100644 --- a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_NP_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_NP_general.sql @@ -327,3 +327,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'NP', '886', '2', 0, 0, 'Системний код', 'Системний код', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'NP', '886', 'a', 0, 1, 'Тег поля початкового формату', 'Тег поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'NP', '886', 'b', 0, 1, 'Індикатори та підполя поля початкового формату', 'Індикатори та підполя поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SAUTTIT_general.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SAUTTIT_general.sql index 3a4da53..fbf2dca 100644 --- a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SAUTTIT_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SAUTTIT_general.sql @@ -315,3 +315,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'SAUTTIT', '886', '2', 0, 0, 'Системний код', 'Системний код', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'SAUTTIT', '886', 'a', 0, 1, 'Тег поля початкового формату', 'Тег поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'SAUTTIT', '886', 'b', 0, 1, 'Індикатори та підполя поля початкового формату', 'Індикатори та підполя поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SAUT_general.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SAUT_general.sql index 14bfb2c..ff4e596 100644 --- a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SAUT_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SAUT_general.sql @@ -327,3 +327,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'SAUT', '886', '2', 0, 0, 'Системний код', 'Системний код', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'SAUT', '886', 'a', 0, 1, 'Тег поля початкового формату', 'Тег поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'SAUT', '886', 'b', 0, 1, 'Індикатори та підполя поля початкового формату', 'Індикатори та підполя поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SCO_general.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SCO_general.sql index 33eda63..6e84e1e 100644 --- a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SCO_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SCO_general.sql @@ -334,3 +334,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'SCO', '886', '2', 0, 0, 'Системний код', 'Системний код', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'SCO', '886', 'a', 0, 1, 'Тег поля початкового формату', 'Тег поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'SCO', '886', 'b', 0, 1, 'Індикатори та підполя поля початкового формату', 'Індикатори та підполя поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SNC_general.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SNC_general.sql index 8a56de2..38fed12 100644 --- a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SNC_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SNC_general.sql @@ -305,3 +305,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'SNC', '886', '2', 0, 0, 'Системний код', 'Системний код', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'SNC', '886', 'a', 0, 1, 'Тег поля початкового формату', 'Тег поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'SNC', '886', 'b', 0, 1, 'Індикатори та підполя поля початкового формату', 'Індикатори та підполя поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SNG_general.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SNG_general.sql index 84b4cd2..bb6b2ec 100644 --- a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SNG_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_SNG_general.sql @@ -303,3 +303,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'SNG', '886', '2', 0, 0, 'Системний код', 'Системний код', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'SNG', '886', 'a', 0, 1, 'Тег поля початкового формату', 'Тег поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'SNG', '886', 'b', 0, 1, 'Індикатори та підполя поля початкового формату', 'Індикатори та підполя поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_STU_general.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_STU_general.sql index e7722e3..cda21ad 100644 --- a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_STU_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_STU_general.sql @@ -351,3 +351,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'STU', '886', '2', 0, 0, 'Системний код', 'Системний код', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'STU', '886', 'a', 0, 1, 'Тег поля початкового формату', 'Тег поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'STU', '886', 'b', 0, 1, 'Індикатори та підполя поля початкового формату', 'Індикатори та підполя поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_TU_general.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_TU_general.sql index c31bc2b..0cace0f 100644 --- a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_TU_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_authorities_TU_general.sql @@ -351,3 +351,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'TU', '886', '2', 0, 0, 'Системний код', 'Системний код', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'TU', '886', 'a', 0, 1, 'Тег поля початкового формату', 'Тег поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0), ('', 'TU', '886', 'b', 0, 1, 'Індикатори та підполя поля початкового формату', 'Індикатори та підполя поля початкового формату', -1, 0, NULL, NULL, NULL, NULL, NULL, 0); + +-- Replace nonzero hidden values like -5, 1 or 8 by 1 +UPDATE auth_subfield_structure SET hidden=1 WHERE hidden<>0 -- 2.1.4