From 2f06cc501be05fe6c2cc6099d2122006dee12496 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 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. Signed-off-by: Jonathan Druart --- .../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 +++ .../unimarc/optional/unimarc_authorities_CO_general.sql | 3 +++ .../unimarc/optional/unimarc_authorities_NP_general.sql | 3 +++ .../unimarc/optional/unimarc_authorities_SAUTTIT_general.sql | 3 +++ .../unimarc/optional/unimarc_authorities_SAUT_general.sql | 3 +++ .../unimarc/optional/unimarc_authorities_SCO_general.sql | 3 +++ .../unimarc/optional/unimarc_authorities_SNC_general.sql | 3 +++ .../unimarc/optional/unimarc_authorities_SNG_general.sql | 3 +++ .../unimarc/optional/unimarc_authorities_STU_general.sql | 3 +++ .../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 7742e6ca64..b4882294ff 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 058a47f63b..ce60cceb0f 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 a3b6749130..d6f9975f9a 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 cd91143a19..0f391d1e73 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 4fdfc68f18..096ffccdea 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 ff53c76b03..f2560f786a 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 a54e4df258..07d75af7df 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 4e8896b6af..4d92b4cea0 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 4b4d66268c..9d1489eb46 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 2e9de3f7f0..3ae95ae78d 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 9c3cf57f38..76886d8c34 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 f4add34f9b..6dc04a4c55 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 0d8d56c1ce..36868d52c4 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 37f221ca08..91d900ac24 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 f612172758..0e4e8b7b0b 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 cd6edcf7e0..3cf1f65b9c 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 e619a551e2..d2e25ccca4 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 9157800c84..31388afd9d 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 08a4465196..2a7fb5b65e 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 8c95212a79..216f10387f 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 3a4da5357e..fbf2dca557 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 14bfb2c086..ff4e596b15 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 33eda632c8..6e84e1ef43 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 8a56de2879..38fed1273f 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 84b4cd2b41..bb6b2ec386 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 e7722e3ecd..cda21add1e 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 c31bc2bbba..0cace0f85b 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.20.1