View | Details | Raw Unified | Return to bug 17355
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_17355.perl (+13 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    unless ( column_exists( 'authorised_value_categories', 'is_system' ) ) {
5
        $dbh->do(q|
6
            ALTER TABLE authorised_value_categories
7
            ADD COLUMN is_system TINYINT(1) DEFAULT 0 AFTER category_name
8
        |);
9
    }
10
11
    # Always end with this (adjust the bug info)
12
    NewVersion( $DBversion, 17355, "Description");
13
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 100-105 CREATE TABLE `auth_tag_structure` ( Link Here
100
DROP TABLE IF EXISTS `authorised_value_categories`;
100
DROP TABLE IF EXISTS `authorised_value_categories`;
101
CREATE TABLE `authorised_value_categories` (
101
CREATE TABLE `authorised_value_categories` (
102
  `category_name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
102
  `category_name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
103
  `is_system` tinyint(1) default 0,
103
  PRIMARY KEY (`category_name`)
104
  PRIMARY KEY (`category_name`)
104
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
105
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
105
106
106
- 

Return to bug 17355