ALTER TABLE `LoanAccount` CHANGE COLUMN `account_no` `account_no` VARCHAR(15) NOT NULL  ;

ALTER TABLE `AssetInsurance` CHANGE COLUMN `covernote_no` `covernote_no` VARCHAR(30) DEFAULT NULL  ;

ALTER TABLE `VehicleCollateral` CHANGE COLUMN `permit_valid_upto` `permit_valid_upto` DATE DEFAULT NULL  , CHANGE COLUMN `tax_paid_upto` `tax_paid_upto` DATE DEFAULT NULL  ;