· 9 years ago · Oct 18, 2016, 05:18 PM
1CREATE TABLE IF NOT EXISTS `uni.Applicant` (
2 `Applicate_ID` int(11) NOT NULL,
3 `Fee_ID` int(11) NOT NULL,
4 `Title` varchar(8) NOT NULL,
5 `First_name` varchar(20) NOT NULL,
6 `Last_name` varchar(20) NOT NULL,
7 `Address_line_1` varchar(30) NOT NULL,
8 `Address_line_2` varchar(30) NOT NULL,
9 `Town` varchar(30) NOT NULL,
10 `Postcode` varchar(20) NOT NULL,
11 `County` varchar(15) NOT NULL,
12 `Home_Phone` int(15) NOT NULL,
13 `Mobile_Phone` int(15) NOT NULL,
14 PRIMARY KEY (`Applicate_ID`)
15) ENGINE=MyISAM DEFAULT CHARSET=latin1;