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
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches
