8a2caP4p

1CREATE TABLE IF NOT EXISTS `orders` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `firstName` varchar(300) NOT NULL,
4  `lastName` varchar(300) NOT NULL,
5  `street` varchar(500) NOT NULL,
6  `city` varchar(100) NOT NULL,
7  `state` varchar(100) NOT NULL,
8  `zip_code` varchar(100) NOT NULL,
9  `phoneNumber` varchar(100) NOT NULL,
10  `emailAddress` varchar(250) NOT NULL,
11  `itemnum` int(100) NOT NULL,
12  `payment` varchar(30) NOT NULL,
13  `cc_num` varchar(200) NOT NULL,
14  `card` varchar(100) NOT NULL,
15  `amt` varchar(100) NOT NULL,
16  `shipping` varchar(40) NOT NULL,
17  PRIMARY KEY (`id`)
18) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
19
20--
21-- Dumping data for table `orders`
22--
23
24INSERT INTO `orders` (`id`, `firstName`, `lastName`, `street`, `city`, `state`, `zip_code`, `phoneNumber`, `emailAddress`, `itemnum`, `payment`, `cc_num`, `card`, `amt`, `shipping`) VALUES
25(1, 'santos', 'maldonado', '', '', '', '', '407-555-1212', 'sa062331@knights.ucf.edu', 1234566, 'check', '', 'MC', '', '');