ALTER TABLE `spn_prod`.`staff_spouse` 
DROP COLUMN `file_no`,
DROP COLUMN `business_trip_back_date`,
DROP COLUMN `business_trip_date`,
DROP COLUMN `business_trip`,
DROP COLUMN `retirement_date`,
DROP COLUMN `fifteen_years`,
DROP COLUMN `ten_years`,
DROP COLUMN `ccc_date`,
DROP COLUMN `ccc_no`,
DROP COLUMN `profession`,
DROP COLUMN `educational`,
DROP COLUMN `religion`,
DROP COLUMN `nationality`,
DROP COLUMN `place_of_birth`,
CHANGE COLUMN `mother_name` `mother_tel` VARCHAR(45) NULL DEFAULT NULL ;