-- Adding three date-related columns to LoanAccountStat that will be used to keep track of EOD and VDT runs

ALTER TABLE `LoanAccountStat`
 ADD COLUMN `last_value_date_on` DATE DEFAULT NULL  AFTER `written_off_on` ,
 ADD COLUMN `last_value_date_updated_on` DATE DEFAULT NULL  AFTER `last_value_date_on` ,
 ADD COLUMN `adv_installment_demanded_on` DATE DEFAULT NULL  AFTER `last_value_date_updated_on` ;
