ALTER TABLE `LoanAccountAssociate` CHANGE COLUMN `residence_city` `residence_city` VARCHAR(100) DEFAULT NULL  , CHANGE COLUMN `residence_state_id` `residence_state_id` TINYINT(3) UNSIGNED DEFAULT NULL  , CHANGE COLUMN `residence_country` `residence_country` VARCHAR(100) DEFAULT NULL  , CHANGE COLUMN `residence_pincode` `residence_pincode` MEDIUMINT(6) DEFAULT NULL  , CHANGE COLUMN `office_city` `office_city` VARCHAR(100) DEFAULT NULL  , CHANGE COLUMN `office_state_id` `office_state_id` TINYINT(3) UNSIGNED DEFAULT NULL  , CHANGE COLUMN `office_country` `office_country` VARCHAR(100) DEFAULT NULL  , CHANGE COLUMN `office_pincode` `office_pincode` MEDIUMINT(6) DEFAULT NULL;
