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`=3 WHERE `id`='2';
UPDATE `AccountStatusMaster` SET `id`=2 WHERE `id`='1';
INSERT INTO `AccountStatusMaster` (`id`, `name`) VALUES (1, 'Filing of application');

ALTER TABLE LoanAccountAssociate ADD COLUMN notation VARCHAR(300) DEFAULT NULL AFTER telephone.
