@@ -, +, @@ --- .../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(+) --- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_local.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_local.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_local.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_local.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_local.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_local.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_local.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_local.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_local.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_authorities_DEFAULT_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_CO_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_NP_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SAUTTIT_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SAUT_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SCO_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SNC_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_SNG_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_STU_general.sql +++ a/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 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_authorities_TU_general.sql +++ a/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 --