CREATE TABLE `upp129`.`applicant_choice` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`personal_number` VARCHAR( 10 ) NOT NULL ,
`dist_choice1` VARCHAR( 10 ) NOT NULL ,
`dist_choice2` VARCHAR( 10 ) NOT NULL ,
`dist_choice3` VARCHAR( 10 ) NOT NULL ,
`dist_choice4` VARCHAR( 10 ) NOT NULL ,
`transDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE = InnoDB;

