Bugzilla – Attachment 72200 Details for
Bug 20075
Change authority hidden attribute in sql installer files
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 20075: Update installer files for uk-UA
Bug-20075-Update-installer-files-for-uk-UA.patch (text/plain), 32.96 KB, created by
Marcel de Rooy
on 2018-02-26 10:54:29 UTC
(
hide
)
Description:
Bug 20075: Update installer files for uk-UA
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2018-02-26 10:54:29 UTC
Size:
32.96 KB
patch
obsolete
>From a3ef04f496132680484382ea23b1f7634ef5164c Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 20075
:
72198
|
72199
| 72200 |
72201