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