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 |
- |
|
|