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

(-)a/installer/data/mysql/db_revs/231200022.pl (-16 / +17 lines)
Lines 7-30 return { Link Here
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', 'download_port' ) ) {
10
        if ( column_exists( 'vendor_edi_accounts', 'password' ) ) {
11
            $dbh->do(
11
            if ( !column_exists( 'vendor_edi_accounts', 'download_port' ) ) {
12
                q{
12
                $dbh->do(
13
              ALTER TABLE vendor_edi_accounts ADD COLUMN `download_port` int(11) DEFAULT NULL AFTER `password`
13
                    q{
14
          }
14
                      ALTER TABLE vendor_edi_accounts ADD COLUMN `download_port` int(11) DEFAULT NULL AFTER `password`
15
            );
15
                      }
16
                );
16
17
17
            say $out "Added column 'vendor_edi_accounts.download_port'";
18
                say $out "Added column 'vendor_edi_accounts.download_port'";
18
        }
19
            }
19
20
20
        if ( !column_exists( 'vendor_edi_accounts', 'upload_port' ) ) {
21
            if ( !column_exists( 'vendor_edi_accounts', 'upload_port' ) ) {
21
            $dbh->do(
22
                $dbh->do(
22
                q{
23
                    q{
23
              ALTER TABLE vendor_edi_accounts ADD COLUMN `upload_port` int(11) DEFAULT NULL AFTER `download_port`
24
                          ALTER TABLE vendor_edi_accounts ADD COLUMN `upload_port` int(11) DEFAULT NULL AFTER `download_port`
24
          }
25
                    }
25
            );
26
                );
26
27
27
            say $out "Added column 'vendor_edi_accounts.upload_port'";
28
                say $out "Added column 'vendor_edi_accounts.upload_port'";
29
            }
28
        }
30
        }
29
    },
31
    },
30
};
32
};
31
- 

Return to bug 38489