E45rUCPU

1CREATE TABLE IF NOT EXISTS `autoleads` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `firstname` varchar(25) NOT NULL,
4  `lastname` varchar(25) NOT NULL,
5  `email` varchar(50) NOT NULL,
6  `phonenumber` varchar(11) NOT NULL,
7  `worknumber` varchar(11) NOT NULL,
8  `dob` varchar(11) NOT NULL,
9  `ssn` varchar(9) NOT NULL,
10  `address` varchar(255) NOT NULL,
11  `city` varchar(255) NOT NULL,
12  `state` char(2) NOT NULL,
13  `country` varchar(255) NOT NULL,
14  `zipcode` char(5) NOT NULL,
15  `residencetype` varchar(25) NOT NULL,
16  `monthlypayments` int(11) NOT NULL,
17  `yearsaddress` int(2) NOT NULL,
18  `monthsaddress` int(2) NOT NULL,
19  `employmenttype` varchar(25) NOT NULL,
20  `employername` varchar(255) NOT NULL,
21  `yearsemployed` int(2) NOT NULL,
22  `monthsemployed` int(2) NOT NULL,
23  `employerphone` varchar(11) NOT NULL,
24  `occupation` varchar(255) NOT NULL,
25  `grossmonthly` int(11) NOT NULL,
26  `downpayment` int(11) NOT NULL,
27  `checkingsaccount` char(1) NOT NULL,
28  `savingsaccount` char(1) NOT NULL,
29  PRIMARY KEY (`id`)
30) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;