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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +5 lines)
Lines 8711-8716 if ( CheckVersion($DBversion) ) { Link Here
8711
        ALTER TABLE aqorders
8711
        ALTER TABLE aqorders
8712
        ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived
8712
        ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived
8713
    });
8713
    });
8714
    $dbh->do(q{
8715
        UPDATE aqorders, aqbasket
8716
        SET aqorders.created_by = aqbasket.authorisedby
8717
        WHERE aqorders.basketno = aqbasket.basketno
8718
    });
8714
    print "Upgrade to $DBversion done (Bug 12395: Add aqorders.created_by column)\n";
8719
    print "Upgrade to $DBversion done (Bug 12395: Add aqorders.created_by column)\n";
8715
    SetVersion ($DBversion);
8720
    SetVersion ($DBversion);
8716
}
8721
}
8717
- 

Return to bug 12395