SET SESSION sql_mode = '';
ALTER TABLE `position`
    CHANGE `pos_id` `pos_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `employee_history`
    CHANGE `pos_id` `pos_id` INT(30) UNSIGNED NOT NULL,
    CHANGE `voluntary_termination` `voluntary_termination` BIT(1) NULL DEFAULT NULL,
    CHANGE `is_super_visor` `is_super_visor` BIT(1) NULL DEFAULT NULL,
    CHANGE `super_visor_id` `super_visor_id` BIGINT(30) UNSIGNED NULL DEFAULT NULL,
    CHANGE `indirect_super_visor_id` `indirect_super_visor_id` BIGINT(11) UNSIGNED NULL DEFAULT NULL,
    CHANGE `gender` `gender` INT(11) UNSIGNED NULL DEFAULT NULL,
    CHANGE `marital_status` `marital_status` INT(11) UNSIGNED NULL DEFAULT NULL,
    ADD INDEX(`gender`, `marital_status`, `joining_notified`);