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

(-)a/installer/data/mysql/atomicupdate/bug_30130.pl (+19 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "30130",
5
    description => "A standard to edi_account",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        unless ( column_exists('vendor_edi_accounts', 'standard') ) {
10
            $dbh->do(q{
11
                ALTER TABLE vendor_edi_accounts ADD standard varchar(3) DEFAULT 'EUR' AFTER san
12
            });
13
14
            $dbh->do(q{
15
                UPDATE vendor_edi_accounts SET standard = 'BIC' WHERE san IN ( '5013546025065', '9377779308820' )
16
            });
17
        }
18
    },
19
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 5263-5268 CREATE TABLE `vendor_edi_accounts` ( Link Here
5263
  `download_directory` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5263
  `download_directory` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5264
  `upload_directory` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5264
  `upload_directory` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5265
  `san` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5265
  `san` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5266
  `standard` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT 'EUR',
5266
  `id_code_qualifier` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT '14',
5267
  `id_code_qualifier` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT '14',
5267
  `transport` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT 'FTP',
5268
  `transport` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT 'FTP',
5268
  `quotes_enabled` tinyint(1) NOT NULL DEFAULT 0,
5269
  `quotes_enabled` tinyint(1) NOT NULL DEFAULT 0,
5269
- 

Return to bug 30130