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