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