From 7f68a2440f609fb01e3a3ca7f5c970525a4aa603 Mon Sep 17 00:00:00 2001 From: Colin Campbell Date: Mon, 25 Jan 2010 14:20:09 +0000 Subject: [PATCH] delay dropping of aqbookfund aqbookfund cannot be dropped before aqorderbreakdown due to fk cobstraints remove drop of column bookfundid from aqbudget column no longer exists at this point --- installer/data/mysql/updatedatabase.pl | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 8d65a4b136..41dfa3f515 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -2966,11 +2966,9 @@ BUDGETCONSTRAINTS $dbh->do(<do("DROP TABLE aqbookfund "); $dbh->do("DROP TABLE IF EXISTS `aqbudgets_planning` "); $dbh->do("CREATE TABLE `aqbudgets_planning` ( @@ -2991,6 +2989,8 @@ BUDGETDROPDATES ADD COLUMN `sort1_authcat` varchar(10) default NULL, ADD COLUMN `sort2_authcat` varchar(10) default NULL" ); + # cannot do until aqorderbreakdown removed +# $dbh->do("DROP TABLE aqbookfund "); @@ -3074,6 +3074,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { ); $dbh->do(qq| DROP TABLE aqorderbreakdown |); + $dbh->do('DROP TABLE aqbookfund'); print "Upgrade to $DBversion done (New aqorders_items table for acqui)\n"; SetVersion ($DBversion); } -- 2.39.5