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

(-)a/installer/data/mysql/atomicupdate/bug_19066.sql (-1 lines)
Line 1 Link Here
1
ALTER TABLE accountlines ADD branchcode VARCHAR( 10 ) NULL DEFAULT NULL AFTER manager_id;
(-)a/installer/data/mysql/atomicupdate/bug_19066_add_accountlines_branchcode.perl (-1 / +11 lines)
Line 0 Link Here
0
- 
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    if( !column_exists( 'accountlines', 'branchcode' ) ) {
5
        $dbh->do("ALTER TABLE accountlines ADD branchcode VARCHAR( 10 ) NULL DEFAULT NULL AFTER manager_id");
6
    }
7
8
    # Always end with this (adjust the bug info)
9
    SetVersion( $DBversion );
10
    print "Upgrade to $DBversion done (Bug 19066 - Add branchcode to accountlines)\n";
11
}

Return to bug 19066