DROP TABLE `LoanScheduleInstallment` ;

ALTER TABLE `LoanAccountSchedule` DROP COLUMN `id` 
, DROP PRIMARY KEY 
, ADD PRIMARY KEY (`account_id`, `effective_date`) 
, DROP INDEX `loanaccountschedule_acct_eff_idx` ;

DROP TABLE LoanScheduleARLog;

DELETE FROM `AccountStatusMaster` WHERE `id`='1';
UPDATE `AccountStatusMaster` SET `id`=9 WHERE `id`='8';
UPDATE `AccountStatusMaster` SET `id`=8 WHERE `id`='7';
UPDATE `AccountStatusMaster` SET `id`=7 WHERE `id`='6';
UPDATE `AccountStatusMaster` SET `id`=6 WHERE `id`='5';
UPDATE `AccountStatusMaster` SET `id`=5 WHERE `id`='4';
UPDATE `AccountStatusMaster` SET `id`=4 WHERE `id`='3';
UPDATE `AccountStatusMaster` SET `id`=1 WHERE `id`='2';
INSERT INTO `AccountStatusMaster` (`id`, `name`) VALUES (2, 'Credit check');
INSERT INTO `AccountStatusMaster` (`id`, `name`) VALUES (3, 'Awaiting approval');
