[Koha-patches] [PATCH] Bug #4310 Fixing aqorder migration

[Henri-Damien LAURENT]

setting correct values and migrating aqorderbreakdown
---
 installer/data/mysql/updatedatabase.pl |    2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)

diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index a0b5c4a..7e04455 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -2997,6 +2997,8 @@ BUDGETDROPDATES
                     ADD COLUMN  `sort2_authcat` varchar(10) default NULL" );
 
                 # cannot do until aqorderbreakdown removed
+    $dbh->do("UPDATE  aqorders, aqorderbreakdown set aqorders.budget_id=aqorderbreakdown.bookfundid where aqorders.ordernumber=aqorderbreakdown.ordernumber ");
+    $dbh->do("UPDATE  aqorders, aqorderbreakdown,aqbudgets set aqorders.budget_group_id=aqbudgets.budget_period_id where aqorders.ordernumber=aqorderbreakdown.ordernumber  and aqbudgets=aqorderbreakdown.bookfundid");
 #    $dbh->do("DROP TABLE aqbookfund ");
 
 #    $dbh->do("ALTER TABLE aqorders  ADD FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON UPDATE CASCADE  " ); ????
-- 
1.7.0.4