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

(-)a/installer/data/mysql/atomicupdate/bug_18639_add_replacementprice_field_to_aqorders.perl (-2 / +4 lines)
Lines 1-6 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do( "ALTER TABLE  aqorders ADD COLUMN replacementprice DECIMAL(28,6)" );
3
    if( !column_exists( 'aqorders', 'replacementprice' ){
4
        $dbh->do( "ALTER TABLE  aqorders ADD COLUMN replacementprice DECIMAL(28,6)" );
5
        $dbh->do( "UPDATE aqorders set replacementprice = rrp WHERE replacementprice IS NULL" );
6
    }
4
    SetVersion( $DBversion );
7
    SetVersion( $DBversion );
5
    print "Upgrade to $DBversion done (Bug 18639 - Add replacementprice field to aqorders table)\n";
8
    print "Upgrade to $DBversion done (Bug 18639 - Add replacementprice field to aqorders table)\n";
6
}
9
}
7
- 

Return to bug 18639