Attachment #162498 for bug #35724

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




        my ($args) = @_;
        my ( $dbh, $out ) = @$args{qw(dbh out)};

        if ( !column_exists( 'vendor_edi_accounts', 'download_port' ) ) {
            $dbh->do(
                q{
              ALTER TABLE vendor_edi_accounts ADD COLUMN `download_port` int(11) DEFAULT NULL AFTER `password`
          }
            );

            say $out "Added column 'vendor_edi_accounts.download_port'";
        }

        if ( !column_exists( 'vendor_edi_accounts', 'upload_port' ) ) {
            $dbh->do(
                q{
              ALTER TABLE vendor_edi_accounts ADD COLUMN `upload_port` int(11) DEFAULT NULL AFTER `download_port`
          }
            );

            say $out "Added column 'vendor_edi_accounts.upload_port'";
        }
    },
};

Lines 6427-6434 CREATE TABLE `vendor_edi_accounts` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
6427	`host` varchar(40) DEFAULT NULL,	6427	`host` varchar(40) DEFAULT NULL,
6428	`username` varchar(40) DEFAULT NULL,	6428	`username` varchar(40) DEFAULT NULL,
6429	`password` mediumtext DEFAULT NULL,	6429	`password` mediumtext DEFAULT NULL,
6430	`upload_port` varchar(40) DEFAULT NULL,	6430	`upload_port` int(11) DEFAULT NULL,
6431	`download_port` varchar(40) DEFAULT NULL,	6431	`download_port` int(11) DEFAULT NULL,
6432	`last_activity` date DEFAULT NULL,	6432	`last_activity` date DEFAULT NULL,
6433	`vendor_id` int(11) DEFAULT NULL,	6433	`vendor_id` int(11) DEFAULT NULL,
6434	`download_directory` mediumtext DEFAULT NULL,	6434	`download_directory` mediumtext DEFAULT NULL,
6435	-

Return to bug 35724

Lines 7-30 return { Link Here

(-)a/installer/data/mysql/atomicupdate/bug_35724-add_upload_port_and_download_port_columns.pl (-6 / +6 lines)
7	my ($args) = @_;	7	my ($args) = @_;
8	my ( $dbh, $out ) = @$args{qw(dbh out)};	8	my ( $dbh, $out ) = @$args{qw(dbh out)};
9		9
10	if ( !column_exists( 'vendor_edi_accounts', 'upload_port' ) ) {	10	if ( !column_exists( 'vendor_edi_accounts', 'download_port' ) ) {
11	$dbh->do(	11	$dbh->do(
12	q{	12	q{
13	ALTER TABLE vendor_edi_accounts ADD COLUMN `upload_port` varchar(40) DEFAULT '22' AFTER `password`	13	ALTER TABLE vendor_edi_accounts ADD COLUMN `download_port` int(11) DEFAULT NULL AFTER `password`
14	}	14	}
15	);	15	);
16		16
17	say $out "Added column 'vendor_edi_accounts.upload_port'";	17	say $out "Added column 'vendor_edi_accounts.download_port'";
18	}	18	}
19		19
20	if ( !column_exists( 'vendor_edi_accounts', 'download_port' ) ) {	20	if ( !column_exists( 'vendor_edi_accounts', 'upload_port' ) ) {
21	$dbh->do(	21	$dbh->do(
22	q{	22	q{
23	ALTER TABLE vendor_edi_accounts ADD COLUMN `download_port` varchar(40) DEFAULT '22' AFTER `password`	23	ALTER TABLE vendor_edi_accounts ADD COLUMN `upload_port` int(11) DEFAULT NULL AFTER `download_port`
24	}	24	}
25	);	25	);
26		26
27	say $out "Added column 'vendor_edi_accounts.download_port'";	27	say $out "Added column 'vendor_edi_accounts.upload_port'";
28	}	28	}
29	},	29	},
30	};	30	};