From 1e9d8747dc10248dd713894eaef72b9cf8103ecb Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Mon, 2 Dec 2019 11:13:19 +0100
Subject: [PATCH] Bug 24137: Fix biblio frameworks install for ru-Ru and uk-UA

They both failed with
   Column 'hidden' cannot be null

Test plan:
Make sure the 2 sql files can be inserted without errors
---
 .../marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql           | 2 +-
 .../marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql           | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql
index d0f4066596..a12c74a38e 100644
--- a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql
+++ b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql
@@ -599,7 +599,7 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
  ('', '097', 1, 1, 'Оператор', '', NULL);
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('', '', '097', 'b', 0, 0, 'Оператор', '',                             0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+ ('', '', '097', 'b', 0, 0, 'Оператор', '',                             0, -6, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
  ('', '098', '', 1, 'Другие схемы классификации (OCLC)', '', '');
diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql
index fe7d602067..05603b2125 100644
--- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql
+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql
@@ -637,7 +637,7 @@ INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
  ('', '097', '', 1, 'Оператор', '', '');
 INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
- ('', '', '097', 'b', 0, 0, 'Оператор', '',                             0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+ ('', '', '097', 'b', 0, 0, 'Оператор', '',                             0, -6, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 
 INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
  ('', '098', '', 1, 'Інші схеми класифікації (OCLC)', '', '');
-- 
2.11.0