From d66f9b303e8394f6c58b7c659784fe31f3f00537 Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Tue, 24 Aug 2010 12:28:08 +0200 Subject: [PATCH] Bug #4310 Fixing aqorder migration 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