-- 
-- Table structure for table `xlite_orders`
-- 

CREATE TABLE `xlite_orders` (
  `profile_id` int(11) NOT NULL default '0',
  `orig_profile_id` int(11) NOT NULL default '0',
  `total` decimal(12,2) NOT NULL default '0.00',
  `subtotal` decimal(12,2) NOT NULL default '0.00',
  `shipping_cost` decimal(12,2) NOT NULL default '0.00',
  `tax` decimal(12,2) NOT NULL default '0.00',
  `tracking` varchar(32) default NULL,
  `manufactor` varchar(72) NOT NULL default '',
  `Packnotes` varchar(72) NOT NULL default '',
  `Packnotes2` varchar(72) NOT NULL default '',
  `Packnotes3` varchar(72) NOT NULL default '',
  `Packnotes4` varchar(72) NOT NULL default '',
  `carrier` varchar(72) NOT NULL default '',
  `carrier2` varchar(72) NOT NULL default '',
  `carrier3` varchar(72) NOT NULL default '',
  `carrier4` varchar(72) NOT NULL default '',
  `shipdate` varchar(72) default NULL,
  `shipdate2` varchar(72) default NULL,
  `shipdate3` varchar(72) default NULL,
  `shipdate4` varchar(72) default NULL,
  `tracking2` varchar(72) default NULL,
  `tracking3` varchar(72) default NULL,
  `tracking4` varchar(72) default NULL,
  `freight` varchar(72) default NULL,
  `freight2` varchar(72) default NULL,
  `freight3` varchar(27) default NULL,
  `freight4` varchar(72) default NULL,
  `cutticket` varchar(75) default NULL,
  `PO` varchar(75) default NULL,
  `location` varchar(75) default NULL,
  `ticket` varchar(75) default NULL,
  `printed` varchar(75) default NULL,
  `date` int(11) default NULL,
  `status` char(1) default 'I',
  `payment_method` varchar(64) default NULL,
  `details` text,
  `notes` text,
  `order_id` int(11) NOT NULL auto_increment,
  `shipping_id` int(11) default NULL,
  `detail_labels` text,
  `taxes` text,
  `payedByGC` decimal(12,2) default NULL,
  `gcid` varchar(16) default NULL,
  `payedByPoints` decimal(12,2) default '0.00',
  `discountCoupon` varchar(12) default NULL,
  `discount` decimal(12,2) default '0.00',
  `substatus` char(1) default '',
  `admin_notes` text,
  `snsClientId` varchar(20) default NULL,
  `manual_edit` int(1) NOT NULL default '0',
  `secureDetails` text,
  PRIMARY KEY  (`order_id`),
  KEY `xlite_order_date` (`date`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9408 ;