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 |
- |
|
|