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