From a3ef04f496132680484382ea23b1f7634ef5164c 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 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 Ukrainian install or run a few files on an empty database. --- .../marc21/mandatory/marc21_authorities_DEFAULT_general.sql | 3 +++ .../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 +++ 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 935ac7c..b67cfdb 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 0f35efb..7e7ccdd 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 0bca491..ee22315 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 e5e2291..482fee3 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 475c7f6..034850e 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 40cd719..347eae6 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 2ed5f70..cde54e6 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 de542d4..847f842 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 2e673ac..d12b501 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 d840b9b..5624ad5 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 833805f..6bb65db 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 2eb95cd..621c48d 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 58ac7a9..6d17c6d 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 1375a1b..43f9a59 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 99bd6a8..8eaccd9 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 27be28e..969865a 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 6c97606..ac19a41 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 b702157..6b009cd 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 9157800..31388af 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 0ad8683..e91da53 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 918dee7..c24c460 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 d2d7abd..a28674a 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 ed98611..5f389a8 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 b7f7aa0..e8b3e4f 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 099c579..3e88f25 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 a475eca..2c90a79 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 ccc90a0..6003a72 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 366a2cc..5828d39 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.1.4