Bugzilla – Attachment 175144 Details for
Bug 23005
Specify notice language for vendors
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23005: Add a vendor language field
Bug-23005-Add-a-vendor-language-field.patch (text/plain), 2.24 KB, created by
Matt Blenkinsop
on 2024-12-04 10:17:07 UTC
(
hide
)
Description:
Bug 23005: Add a vendor language field
Filename:
MIME Type:
Creator:
Matt Blenkinsop
Created:
2024-12-04 10:17:07 UTC
Size:
2.24 KB
patch
obsolete
>From 30925259cce85cfc3f7fb8966d1079c461160515 Mon Sep 17 00:00:00 2001 >From: Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com> >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 428010e612d..d56d37fd476 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -503,6 +503,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.39.3 (Apple Git-146)
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 23005
: 175144 |
175145
|
175146