From 6a13b30d3368657efe1a07c9d231daf16328834d Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 5 Sep 2014 17:21:54 +0200 Subject: [PATCH] Bug 12395: Update aqorders.created_by with aqbasket.authorisedby Before this patch, the interface assumed the basket's creator was the "authorisedby" person. Signed-off-by: Jonathan Druart --- installer/data/mysql/updatedatabase.pl | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index dd35d04..8548255 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -9738,6 +9738,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); } -- 1.9.1