From 9fa6cf9e7fcd1b3c69c3fff3f1a7e7a3d4cf6fd4 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 8bc143f..a52e6bd 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8711,6 +8711,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); } -- 2.1.0