Dg5Y5BGc

1CREATE TABLE IF NOT EXISTS `applicant` (
2  `App_FirstName` text COLLATE utf8_bin NOT NULL,
3  `App_LastName` text COLLATE utf8_bin NOT NULL,
4  `App_Email` varchar(40) COLLATE utf8_bin NOT NULL,
5  `App_Address` varchar(40) COLLATE utf8_bin NOT NULL,
6  `App_State` text COLLATE utf8_bin NOT NULL,
7  `App_Zip` int(40) NOT NULL,
8  `App_PrimaryPhone` int(40) NOT NULL,
9  `App_MobilePhone` int(40) NOT NULL,
10  `App_City` text COLLATE utf8_bin NOT NULL,
11  `App_Country` text COLLATE utf8_bin NOT NULL,
12  `App_AcademicYear` int(40) NOT NULL,
13  `App_School` text COLLATE utf8_bin NOT NULL,
14  `App_Concentration` text COLLATE utf8_bin NOT NULL,
15  `App_Employer` text COLLATE utf8_bin NOT NULL,
16  `App_Position` text COLLATE utf8_bin NOT NULL,
17  `App_StartEndDate` varchar(40) COLLATE utf8_bin NOT NULL,
18  `App_PositionApplyFor` text COLLATE utf8_bin NOT NULL,
19  `App_Skills` varchar(120) COLLATE utf8_bin NOT NULL,
20  `App_HowDidYouLearn` varchar(120) COLLATE utf8_bin NOT NULL,
21  `App_ID` int(11) NOT NULL AUTO_INCREMENT,
22  PRIMARY KEY (`App_ID`)
23) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Applicant Information' AUTO_INCREMENT=16 ;