From c1df9aad54cb1acdacfb0e5681ef83e1b7f24eec Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Mon, 26 Feb 2018 10:59:13 +0100 Subject: [PATCH] Bug 20075: Update installer files for uk-UA 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 Ukrainian install or run a few files on an empty database. Signed-off-by: Jonathan Druart --- .../marc21/mandatory/marc21_authorities_DEFAULT_general.sql | 3 +++ .../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 +++ 28 files changed, 84 insertions(+) diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql index 935ac7ca3e..b67cfdb780 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql @@ -1924,3 +1924,6 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '880', 'x', 0, 1, 'x', 'x', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '880', 'y', 0, 1, 'y', 'y', 8, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '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/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_local.sql index 0f35efb402..7e7ccddbef 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_local.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql index 0bca491e42..ee22315329 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_local.sql index e5e22916ee..482fee3d55 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_local.sql @@ -40,3 +40,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/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql index 475c7f6971..034850ebc5 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_local.sql index 40cd71952b..347eae6305 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_local.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql index 2ed5f70e84..cde54e6bc1 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_local.sql index de542d4c1c..847f8428b8 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_local.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql index 2e673ac1ed..d12b50182d 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_local.sql index d840b9b6a8..5624ad53db 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_local.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql index 833805f645..6bb65db77b 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_local.sql index 2eb95cd011..621c48d40d 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_local.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql index 58ac7a9783..6d17c6db09 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_local.sql index 1375a1bad8..43f9a590e9 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_local.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql index 99bd6a8155..8eaccd9224 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_local.sql index 27be28ecd1..969865a807 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_local.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql index 6c9760685b..ac19a411be 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_local.sql index b702157419..6b009cdc65 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_local.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/unimarc/mandatory/unimarc_authorities_DEFAULT_general.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_authorities_DEFAULT_general.sql index 9157800c84..31388afd9d 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_authorities_DEFAULT_general.sql +++ b/installer/data/mysql/uk-UA/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/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_CO_general.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_CO_general.sql index 0ad86833d5..e91da53228 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_CO_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_CO_general.sql @@ -336,3 +336,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/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_NP_general.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_NP_general.sql index 918dee7ff7..c24c460658 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_NP_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_NP_general.sql @@ -328,3 +328,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/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SAUTTIT_general.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SAUTTIT_general.sql index d2d7abd78e..a28674aea7 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SAUTTIT_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SAUTTIT_general.sql @@ -316,3 +316,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/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SAUT_general.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SAUT_general.sql index ed98611a23..5f389a84a3 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SAUT_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SAUT_general.sql @@ -328,3 +328,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/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SCO_general.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SCO_general.sql index b7f7aa0d91..e8b3e4f1ca 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SCO_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SCO_general.sql @@ -335,3 +335,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/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SNC_general.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SNC_general.sql index 099c579004..3e88f25baf 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SNC_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SNC_general.sql @@ -306,3 +306,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/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SNG_general.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SNG_general.sql index a475eca6e5..2c90a79d4e 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SNG_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SNG_general.sql @@ -304,3 +304,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/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_STU_general.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_STU_general.sql index ccc90a0e4a..6003a72d86 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_STU_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_STU_general.sql @@ -352,3 +352,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/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_TU_general.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_TU_general.sql index 366a2cc0fe..5828d3924b 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_TU_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_TU_general.sql @@ -352,3 +352,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