From c4d0a91c262612f7f07a8de75683fb60149064e8 Mon Sep 17 00:00:00 2001 From: Jonathan Druart 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) --- 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 1cb3165eee..341c17bc26 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.20.1