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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +5 lines)
Lines 9738-9743 if ( CheckVersion($DBversion) ) { Link Here
9738
        ALTER TABLE aqorders
9738
        ALTER TABLE aqorders
9739
        ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived
9739
        ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived
9740
    });
9740
    });
9741
    $dbh->do(q{
9742
        UPDATE aqorders, aqbasket
9743
        SET aqorders.created_by = aqbasket.authorisedby
9744
        WHERE aqorders.basketno = aqbasket.basketno
9745
    });
9741
    print "Upgrade to $DBversion done (Bug 12395: Add aqorders.created_by column)\n";
9746
    print "Upgrade to $DBversion done (Bug 12395: Add aqorders.created_by column)\n";
9742
    SetVersion ($DBversion);
9747
    SetVersion ($DBversion);
9743
}
9748
}
9744
- 

Return to bug 12395