@@ -, +, @@ aqbasket.authorisedby --- installer/data/mysql/updatedatabase.pl | 5 +++++ 1 file changed, 5 insertions(+) --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -9765,6 +9765,11 @@ if ( CheckVersion($DBversion) ) { ALTER TABLE aqorders ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived }); + $dbh->do(q{ + UPDATE aqorders, aqbasket + SET aqorders.created_by = aqbasket.authorisedby + WHERE aqorders.basketno = aqbasket.basketno + }); print "Upgrade to $DBversion done (Bug 12395: Add aqorders.created_by column)\n"; SetVersion ($DBversion); } --