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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +5 lines)
Lines 9765-9770 if ( CheckVersion($DBversion) ) { Link Here
9765
        ALTER TABLE aqorders
9765
        ALTER TABLE aqorders
9766
        ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived
9766
        ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived
9767
    });
9767
    });
9768
    $dbh->do(q{
9769
        UPDATE aqorders, aqbasket
9770
        SET aqorders.created_by = aqbasket.authorisedby
9771
        WHERE aqorders.basketno = aqbasket.basketno
9772
    });
9768
    print "Upgrade to $DBversion done (Bug 12395: Add aqorders.created_by column)\n";
9773
    print "Upgrade to $DBversion done (Bug 12395: Add aqorders.created_by column)\n";
9769
    SetVersion ($DBversion);
9774
    SetVersion ($DBversion);
9770
}
9775
}
9771
- 

Return to bug 12395