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

(-)a/installer/data/mysql/atomicupdate/bug_35616.pl (+17 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "35616",
5
    description => "Add source column to tickets table",
6
    up          => sub {
7
        my ($args) = @_;
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
10
        unless ( column_exists( 'tickets', 'source' ) ) {
11
            $dbh->do(
12
                "ALTER TABLE `tickets` ADD COLUMN `source` enum('catalog') NOT NULL DEFAULT 'catalog' COMMENT 'source of ticket' AFTER `id`"
13
            );
14
            say $out "Added column 'tickets.source'";
15
        }
16
    },
17
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 6287-6292 DROP TABLE IF EXISTS `tickets`; Link Here
6287
/*!40101 SET character_set_client = utf8 */;
6287
/*!40101 SET character_set_client = utf8 */;
6288
CREATE TABLE `tickets` (
6288
CREATE TABLE `tickets` (
6289
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key',
6289
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key',
6290
  `source` enum('catalog') NOT NULL DEFAULT 'catalog' COMMENT 'source of ticket',
6290
  `reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket',
6291
  `reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket',
6291
  `reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported',
6292
  `reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported',
6292
  `title` text NOT NULL COMMENT 'ticket title',
6293
  `title` text NOT NULL COMMENT 'ticket title',
6293
- 

Return to bug 35616