ALTER TABLE `proll_employee`
	CHANGE COLUMN `e_pass_word` `e_pass_word` TEXT NULL COLLATE 'latin1_swedish_ci' AFTER `pass_word`;
ALTER TABLE `proll_client_assist`
	CHANGE COLUMN `e_pass_word` `e_pass_word` TEXT NOT NULL COLLATE 'latin1_swedish_ci' AFTER `pass_word`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `shift_id` `shift_id` INT(11) NULL DEFAULT NULL AFTER `applyed_roster`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `weekend_day_id` `weekend_day_id` TINYINT(1) NULL DEFAULT NULL AFTER `shift_id`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `domicile_country_id` `domicile_country_id` INT(11) NULL DEFAULT NULL AFTER `second_nationality_id`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `domicile_city_id` `domicile_city_id` INT(11) NULL DEFAULT NULL AFTER `domicile_country_id`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `location` `location` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci' AFTER `city`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `fs_status` `fs_status` INT(11) NULL DEFAULT NULL AFTER `imp_id`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `emp_band` `emp_band` INT(11) NULL DEFAULT NULL AFTER `bg_color`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `user_id` `user_id` INT(11) NULL DEFAULT NULL AFTER `portal_id`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `ntn_number` `ntn_number` INT(11) NULL DEFAULT NULL AFTER `native_language_id`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `ntn_country_id` `ntn_country_id` INT(11) NULL DEFAULT NULL AFTER `ntn_number`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `ex_employee_flag` `ex_employee_flag` TINYINT(1) NULL DEFAULT NULL AFTER `ntn_status`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `nomination_agree_check` `nomination_agree_check` TINYINT(1) NULL DEFAULT NULL AFTER `ex_employee_code`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `ex_relevent_experience_flag` `ex_relevent_experience_flag` TINYINT(1) NULL DEFAULT NULL AFTER `nomination_agree_check`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `experience_with_client_flag` `experience_with_client_flag` TINYINT(1) NULL DEFAULT NULL AFTER `ex_relevent_experience_flag`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `ex_inquire_objection_flag` `ex_inquire_objection_flag` TINYINT(1) NULL DEFAULT NULL AFTER `experience_with_client_flag`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `serious_ailment_flag` `serious_ailment_flag` TINYINT(1) NULL DEFAULT NULL AFTER `ex_inquire_objection_detail`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `arrested_flag` `arrested_flag` TINYINT(1) NULL DEFAULT NULL AFTER `serious_ailment_brief`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `arrested_brief` `arrested_brief` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci' AFTER `arrested_flag`;
ALTER TABLE `proll_employee`
	CHANGE COLUMN `default_currency_id` `default_currency_id` INT(11) NULL DEFAULT NULL AFTER `arrested_brief`;
ALTER TABLE `multi_login`
	CHANGE COLUMN `login_verify_time` `login_verify_time` DATETIME NULL DEFAULT NULL AFTER `login_time`;
ALTER TABLE `multi_login`
	CHANGE COLUMN `logout_time` `logout_time` DATETIME NULL DEFAULT NULL AFTER `login_verify_time`;


