From df2a432c65cfe747ac3e741e70a04dd03d48bd16 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Wed, 20 Dec 2023 14:42:20 +0000 Subject: [PATCH] Bug 35616: Add source field to tickets table Signed-off-by: David Nind Signed-off-by: Victor Grousset/tuxayo Signed-off-by: Katrin Fischer --- 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 diff --git a/installer/data/mysql/atomicupdate/bug_35616.pl b/installer/data/mysql/atomicupdate/bug_35616.pl new file mode 100644 index 0000000000..714ca08a8e --- /dev/null +++ b/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'"; + } + }, +}; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index ea4a261f64..2645d0f8ad 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -6304,6 +6304,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', -- 2.39.5