CREATE TABLE `tracker` ( `JobType` varchar(50) DEFAULT NULL, `HiringManager` varchar(45) DEFAULT NULL, `Department` varchar(45) DEFAULT NULL, `OfferAmount` int(11) DEFAULT NULL, `Unit` varchar(45) DEFAULT NULL, `StartDate` varchar(45) DEFAULT NULL, `JobTitle` varchar(45) DEFAULT NULL, `OfferDate` varchar(45) DEFAULT NULL, `ApplicantName` varchar(45) NOT NULL, `Address` varchar(45) DEFAULT NULL, `City` varchar(45) DEFAULT NULL, `State` varchar(45) DEFAULT NULL, `ApplicantReviewStatus` varchar(45) DEFAULT NULL, `ApplicantSignature` varchar(45) DEFAULT NULL, `AcceptanceDate` varchar(45) DEFAULT NULL, `HiringManagerReviewStatus` varchar(45) DEFAULT NULL, PRIMARY KEY (`ApplicantName`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;