ALTER TABLE `proll_employee_info`
    ADD COLUMN `previous_appraisal_rating` DOUBLE NULL DEFAULT NULL;
ALTER TABLE `proll_employee_info`
    ADD COLUMN `lastpromotiondate` DATE NULL DEFAULT NULL;

    ALTER TABLE `proll_employee`
        CHANGE COLUMN `contract_status` `contract_status` INT NULL DEFAULT NULL;

ALTER TABLE `proll_employee_contact`
    CHANGE COLUMN `email` `email` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci' AFTER `address_type`,
    CHANGE COLUMN `mobile_number` `mobile_number` VARCHAR(20) NULL COLLATE 'latin1_swedish_ci' AFTER `email`,
    CHANGE COLUMN `skype_name` `skype_name` VARCHAR(30) NULL COLLATE 'latin1_swedish_ci' AFTER `mobile_number`,
    CHANGE COLUMN `emergency_contact_person_name` `emergency_contact_person_name` VARCHAR(30) NULL COLLATE 'latin1_swedish_ci' AFTER `skype_name`,
    CHANGE COLUMN `emergency_contact_number` `emergency_contact_number` VARCHAR(30) NULL COLLATE 'latin1_swedish_ci' AFTER `emergency_contact_person_name`;


ALTER TABLE `proll_employee_visa_details`
    CHANGE COLUMN `employement_status` `employement_status` INT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci' AFTER `visa_expiry_date`;

ALTER TABLE `proll_employee`
    ADD COLUMN `sub_department_id` INT(11) NOT NULL DEFAULT '0' AFTER `department_id`;


ALTER TABLE `al_roster`
    CHANGE COLUMN `dept_id` `dept_id` INT(11) NULL AFTER `roster_id`,
    CHANGE COLUMN `actual_shift_time_in` `actual_shift_time_in` DATETIME NULL DEFAULT NULL AFTER `plan_shift_time_out`,
    CHANGE COLUMN `actual_shift_time_out` `actual_shift_time_out` DATETIME NULL DEFAULT NULL AFTER `actual_shift_time_in`;
