CREATE TABLE `orders` (
`order_id` int(10) NOT NULL auto_increment,
`order_total` float NOT NULL default '0',
`order_date` datetime default '0000-00-00 00:00:00',
`date_accepted` datetime NOT NULL,
`date_rejected` datetime NOT NULL,
`ship_date` datetime NOT NULL,
`ship_method` varchar(45) NOT NULL default 'FEDEX2DAY',
`sat_deliv` varchar(3) default 'no',
`customer_id` int(11) NOT NULL default '0',
`status` int(11) NOT NULL default '0',
`p` tinyint(1) NOT NULL default '0',
`phys_id` int(11) NOT NULL default '0',
`shipping` float NOT NULL default '0',
`payment_type` varchar(50) NOT NULL,
`trans_id` varchar(200) NOT NULL,
`p_id` int(11) NOT NULL default '1',
`notes` text NOT NULL,
`session_data` longtext NOT NULL,
PRIMARY KEY (`order_id`),
UNIQUE KEY `order_id` (`order_id`),
KEY `order_date` (`order_date`),
KEY `customer_id` (`customer_id`),
KEY `ship_date` (`ship_date`),
KEY `Index_5` (`status`),
KEY `Index_6` (`p`),
KEY `phys_id` (`phys_id`),
KEY `order_date_2` (`order_date`)
) ENGINE=InnoDB AUTO_INCREMENT=62489 DEFAULT CHARSET=latin1 PACK_KEYS=0 COMMENT='InnoDB free: 37888 kB'