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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +5 lines)
Lines 9779-9784 if ( CheckVersion($DBversion) ) { Link Here
9779
        ALTER TABLE aqorders
9779
        ALTER TABLE aqorders
9780
        ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived
9780
        ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived
9781
    });
9781
    });
9782
    $dbh->do(q{
9783
        UPDATE aqorders, aqbasket
9784
        SET aqorders.created_by = aqbasket.authorisedby
9785
        WHERE aqorders.basketno = aqbasket.basketno
9786
    });
9782
    print "Upgrade to $DBversion done (Bug 12395: Add aqorders.created_by column)\n";
9787
    print "Upgrade to $DBversion done (Bug 12395: Add aqorders.created_by column)\n";
9783
    SetVersion ($DBversion);
9788
    SetVersion ($DBversion);
9784
}
9789
}
9785
- 

Return to bug 12395