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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +5 lines)
Lines 9540-9545 if ( CheckVersion($DBversion) ) { Link Here
9540
        ALTER TABLE aqorders
9540
        ALTER TABLE aqorders
9541
        ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived
9541
        ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived
9542
    });
9542
    });
9543
    $dbh->do(q{
9544
        UPDATE aqorders, aqbasket
9545
        SET aqorders.created_by = aqbasket.authorisedby
9546
        WHERE aqorders.basketno = aqbasket.basketno
9547
    });
9543
    print "Upgrade to $DBversion done (Bug 12395: Add aqorders.created_by column)\n";
9548
    print "Upgrade to $DBversion done (Bug 12395: Add aqorders.created_by column)\n";
9544
    SetVersion ($DBversion);
9549
    SetVersion ($DBversion);
9545
}
9550
}
9546
- 

Return to bug 12395