ALTER TABLE `spn_prod`.`staff` 
DROP COLUMN `turnover_date`,
DROP COLUMN `entry_date`,
ADD COLUMN `place_of_birth` VARCHAR(45) NULL DEFAULT NULL AFTER `religion_date`,
ADD COLUMN `nationality` VARCHAR(45) NULL DEFAULT NULL AFTER `place_of_birth`,
ADD COLUMN `educational` VARCHAR(45) NULL DEFAULT NULL AFTER `nationality`,
ADD COLUMN `profession` VARCHAR(45) NULL DEFAULT NULL AFTER `educational`,
ADD COLUMN `ccc_no` VARCHAR(45) NULL DEFAULT NULL AFTER `profession`,
ADD COLUMN `ccc_date` DATETIME NULL DEFAULT NULL AFTER `ccc_no`,
ADD COLUMN `ten_years` DATETIME NULL DEFAULT NULL AFTER `ccc_date`,
ADD COLUMN `fifteen_years` DATETIME NULL DEFAULT NULL AFTER `ten_years`,
ADD COLUMN `retirement_date` DATETIME NULL DEFAULT NULL AFTER `fifteen_years`,
ADD COLUMN `business_trip` VARCHAR(45) NULL DEFAULT NULL AFTER `retirement_date`,
ADD COLUMN `business_trip_date` DATETIME NULL DEFAULT NULL AFTER `business_trip`,
ADD COLUMN `business_trip_back_date` DATETIME NULL DEFAULT NULL AFTER `business_trip_date`,
ADD COLUMN `file_no` VARCHAR(45) NULL DEFAULT NULL AFTER `business_trip_back_date`;
