From 3a026486b0afa2349027435e3cdddf8ccd0c6a8a Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Tue, 28 Apr 2020 11:01:19 +0200
Subject: [PATCH] Bug 17355: DB changes

This patch adds a new authorised_value_category.is_system boolean/tinyint(1)
DB field.

Name 'is_system' is coming from existing tables account_credit_types and
account_debit_types and should not be discussed here (if you disagree
fill a new bug report and deal with naming issue separately)

Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net>
---
 installer/data/mysql/atomicupdate/bug_17355.perl | 13 +++++++++++++
 installer/data/mysql/kohastructure.sql           |  1 +
 2 files changed, 14 insertions(+)
 create mode 100644 installer/data/mysql/atomicupdate/bug_17355.perl

diff --git a/installer/data/mysql/atomicupdate/bug_17355.perl b/installer/data/mysql/atomicupdate/bug_17355.perl
new file mode 100644
index 0000000000..d0c5243cdb
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_17355.perl
@@ -0,0 +1,13 @@
+$DBversion = 'XXX'; # will be replaced by the RM
+if( CheckVersion( $DBversion ) ) {
+
+    unless ( column_exists( 'authorised_value_categories', 'is_system' ) ) {
+        $dbh->do(q|
+            ALTER TABLE authorised_value_categories
+            ADD COLUMN is_system TINYINT(1) DEFAULT 0 AFTER category_name
+        |);
+    }
+
+    # Always end with this (adjust the bug info)
+    NewVersion( $DBversion, 17355, "Description");
+}
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 3f8d490fe6..3e3829bc37 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -100,6 +100,7 @@ CREATE TABLE `auth_tag_structure` (
 DROP TABLE IF EXISTS `authorised_value_categories`;
 CREATE TABLE `authorised_value_categories` (
   `category_name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `is_system` tinyint(1) default 0,
   PRIMARY KEY (`category_name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 
-- 
2.26.2