@@ -, +, @@ --- 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 --- a/installer/data/mysql/atomicupdate/bug_17355.perl +++ a/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"); +} --- a/installer/data/mysql/kohastructure.sql +++ a/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; --