/***Store destination office Id while client is pending transfers and effective joining date in a particular branch**/
ALTER TABLE `m_client`
	ADD COLUMN `office_joining_date` DATE NULL AFTER `activation_date`,
	ADD COLUMN `transfer_to_office_id` BIGINT(20) NULL AFTER `office_id`,
	ADD CONSTRAINT `FK_m_client_m_office` FOREIGN KEY (`transfer_to_office_id`) REFERENCES `m_office` (`id`);


/**For current Clients, set the office joining date to activation date**/
update m_client set office_joining_date=activation_date;