@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_35616.pl | 17 +++++++++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 18 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_35616.pl --- a/installer/data/mysql/atomicupdate/bug_35616.pl +++ a/installer/data/mysql/atomicupdate/bug_35616.pl @@ -0,0 +1,17 @@ +use Modern::Perl; + +return { + bug_number => "35616", + description => "Add source column to tickets table", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + unless ( column_exists( 'tickets', 'source' ) ) { + $dbh->do( + "ALTER TABLE `tickets` ADD COLUMN `source` enum('catalog') NOT NULL DEFAULT 'catalog' COMMENT 'source of ticket' AFTER `id`" + ); + say $out "Added column 'tickets.source'"; + } + }, +}; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -6287,6 +6287,7 @@ DROP TABLE IF EXISTS `tickets`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tickets` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', + `source` enum('catalog') NOT NULL DEFAULT 'catalog' COMMENT 'source of ticket', `reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket', `reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported', `title` text NOT NULL COMMENT 'ticket title', --