View | Details | Raw Unified | Return to bug 4310
Collapse All | Expand All

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +2 lines)
Lines 2997-3002 BUDGETDROPDATES Link Here
2997
                    ADD COLUMN  `sort2_authcat` varchar(10) default NULL" );
2997
                    ADD COLUMN  `sort2_authcat` varchar(10) default NULL" );
2998
2998
2999
                # cannot do until aqorderbreakdown removed
2999
                # cannot do until aqorderbreakdown removed
3000
    $dbh->do("UPDATE  aqorders, aqorderbreakdown set aqorders.budget_id=aqorderbreakdown.bookfundid where aqorders.ordernumber=aqorderbreakdown.ordernumber ");
3001
    $dbh->do("UPDATE  aqorders, aqorderbreakdown,aqbudgets set aqorders.budget_group_id=aqbudgets.budget_period_id where aqorders.ordernumber=aqorderbreakdown.ordernumber  and aqbudgets=aqorderbreakdown.bookfundid");
3000
#    $dbh->do("DROP TABLE aqbookfund ");
3002
#    $dbh->do("DROP TABLE aqbookfund ");
3001
3003
3002
#    $dbh->do("ALTER TABLE aqorders  ADD FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON UPDATE CASCADE  " ); ????
3004
#    $dbh->do("ALTER TABLE aqorders  ADD FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON UPDATE CASCADE  " ); ????
3003
- 

Return to bug 4310