ALTER TABLE `applications`
DROP COLUMN `answerOne`,
DROP COLUMN `answerTwo`,
DROP COLUMN `answerThree`,
CHANGE COLUMN `status` `applicationStatus`  tinyint(2) NOT NULL,
ADD COLUMN `uid`  varchar(256) NOT NULL AFTER `id`,
ADD COLUMN `passportValidFrom`  date NULL AFTER `passportNumber`,
ADD COLUMN `passportValidTo`  date NULL AFTER `passportValidFrom`,
MODIFY COLUMN `passportNumber`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
MODIFY COLUMN `nationality`  varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
MODIFY COLUMN `remarks`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
MODIFY COLUMN `visa`  tinyint(1) NOT NULL DEFAULT 0,
MODIFY COLUMN `diet`  tinyint(2) NOT NULL DEFAULT 1;
