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

(-)a/installer/data/mysql/atomicupdate/bug_32435.pl (+21 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "32435",
5
    description => "Add resolution types to catalog concerns",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        unless( column_exists('aqbooksellers','type') ){
10
            $dbh->do(q{
11
                ALTER TABLE ticket_updates ADD COLUMN status varchar(80) DEFAULT NULL COMMENT 'status of ticket at this update' AFTER message
12
            });
13
14
            say $out "Added column 'ticket_updates.status'";
15
        }
16
        $dbh->do(q{
17
            INSERT IGNORE INTO authorised_value_categories( category_name, is_system ) VALUES ('TICKET_RESOLUTION', 1);
18
        });
19
        say $out "Added TICKET_RESOLUTION authorised value category";
20
    },
21
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 6270-6275 CREATE TABLE `ticket_updates` ( Link Here
6270
  `public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public',
6270
  `public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public',
6271
  `date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged',
6271
  `date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged',
6272
  `message` text NOT NULL COMMENT 'update message content',
6272
  `message` text NOT NULL COMMENT 'update message content',
6273
  `status` varchar(80) DEFAULT NULL COMMENT 'status of ticket at this update',
6273
  PRIMARY KEY (`id`),
6274
  PRIMARY KEY (`id`),
6274
  KEY `ticket_updates_ibfk_1` (`ticket_id`),
6275
  KEY `ticket_updates_ibfk_1` (`ticket_id`),
6275
  KEY `ticket_updates_ibfk_2` (`user_id`),
6276
  KEY `ticket_updates_ibfk_2` (`user_id`),
6276
- 

Return to bug 32435