From bd3b3dbed60c1822def49d0e3c5abb5c0bb52149 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 5 Sep 2014 17:21:54 +0200 Subject: [PATCH 3/6] 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 Signed-off-by: Paola Rossi --- 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 52bb0c4..539fc9a 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -9779,6 +9779,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.7.10.4