From 25e1e83f5e2151ab3e3172470e00cdbbff3ce854 Mon Sep 17 00:00:00 2001 From: Matt Blenkinsop Date: Fri, 18 Oct 2024 15:41:07 +0000 Subject: [PATCH] Bug 23005: Add a vendor language field --- .../bug_38209-add-a-vendor-language-field.pl | 24 +++++++++++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 25 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_38209-add-a-vendor-language-field.pl diff --git a/installer/data/mysql/atomicupdate/bug_38209-add-a-vendor-language-field.pl b/installer/data/mysql/atomicupdate/bug_38209-add-a-vendor-language-field.pl new file mode 100644 index 00000000000..587e5cebf8b --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_38209-add-a-vendor-language-field.pl @@ -0,0 +1,24 @@ +use Modern::Perl; +use Koha::Installer::Output qw(say_warning say_failure say_success say_info); + +return { + bug_number => "38209", + description => "Add a language to the vendor table", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + unless ( column_exists( 'aqbooksellers', 'language' ) ) { + $dbh->do( + q{ + ALTER TABLE aqbooksellers + ADD COLUMN `language` varchar(255) NULL DEFAULT NULL + COMMENT 'the language for the vendor' + AFTER payment_method + } + ); + + say $out "Added new column 'aqbooksellers.language'"; + } + }, +}; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index f58c0527903..0bef09e9d3a 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -502,6 +502,7 @@ CREATE TABLE `aqbooksellers` ( `deliverytime` int(11) DEFAULT NULL COMMENT 'vendor delivery time', `external_id` varchar(255) DEFAULT NULL COMMENT 'external id of the vendor', `payment_method` varchar(255) DEFAULT NULL COMMENT 'the payment method for the vendor', + `language` varchar(255) DEFAULT NULL COMMENT 'the language for the vendor', PRIMARY KEY (`id`), KEY `listprice` (`listprice`), KEY `invoiceprice` (`invoiceprice`), -- 2.48.1