4zbC9b0M

1CREATE TABLE IF NOT EXISTS `bigstart_order` (
2  `order_id` int(11) NOT NULL AUTO_INCREMENT,
3  `customer_id` int(11) NOT NULL DEFAULT '0',
4  `firstname` varchar(32) NOT NULL,
5  `lastname` varchar(32) NOT NULL,
6  `email` varchar(96) NOT NULL,
7  `affiliate_id` int(11) NOT NULL,
8  PRIMARY KEY (`order_id`),
9  KEY `customer_id` (`customer_id`,`total`,`email`,`firstname`,`lastname`)
10) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
11
12CREATE TABLE IF NOT EXISTS `bigstart_affiliate` (
13  `affiliate_id` int(11) NOT NULL AUTO_INCREMENT,
14  `firstname` varchar(32) NOT NULL,
15  `lastname` varchar(32) NOT NULL,
16  PRIMARY KEY (`affiliate_id`)
17) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;