--
-- Host: localhost    Database: computer_ccrt1
-- ------------------------------------------------------


--
-- Current Database: `computer_ccrt1`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `computer_ccrt1` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

USE `computer_ccrt1`;

--
-- Table structure for table `CubeCart_Coupons`
--

CREATE TABLE `CubeCart_Coupons` (
  `id` int(10) NOT NULL auto_increment,
  `status` tinyint(1) NOT NULL default '1',
  `code` varbinary(25) NOT NULL default '',
  `product_id` int(10) NOT NULL default '0',
  `discount_percent` decimal(30,2) NOT NULL default '0.00',
  `discount_price` decimal(30,2) NOT NULL default '0.00',
  `expires` varbinary(10) NOT NULL default '',
  `allowed_uses` smallint(1) NOT NULL default '0',
  `count` smallint(1) NOT NULL default '0',
  `desc` blob NOT NULL,
  `cart_order_id` varbinary(30) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_Coupons`
--

INSERT INTO `CubeCart_Coupons` VALUES (1,1,'bl',0,'10.00','0.00','',0,1,'',NULL);

--
-- Table structure for table `CubeCart_Downloads`
--

CREATE TABLE `CubeCart_Downloads` (
  `id` int(11) NOT NULL auto_increment,
  `customerId` int(11) NOT NULL default '0',
  `cart_order_id` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `noDownloads` int(11) NOT NULL default '0',
  `expire` int(11) NOT NULL default '0',
  `productId` int(11) NOT NULL default '0',
  `accessKey` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_Downloads`
--


--
-- Table structure for table `CubeCart_Modules`
--

CREATE TABLE `CubeCart_Modules` (
  `moduleId` int(11) NOT NULL auto_increment,
  `module` varchar(25) collate utf8_unicode_ci NOT NULL default '',
  `folder` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `status` smallint(1) NOT NULL default '0',
  `default` smallint(1) NOT NULL default '0',
  UNIQUE KEY `folder` (`folder`),
  KEY `moduleId` (`moduleId`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_Modules`
--

INSERT INTO `CubeCart_Modules` VALUES (1,'shipping','Free_Shipping',1,1),(2,'gateway','Print_Order_Form',1,1),(3,'shipping','UPS',1,0),(4,'shipping','USPS',0,0),(5,'gateway','PayPal',1,0);

--
-- Table structure for table `CubeCart_SpamBot`
--

CREATE TABLE `CubeCart_SpamBot` (
  `uniqueId` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `spamCode` varchar(5) collate utf8_unicode_ci NOT NULL default '',
  `userIp` varchar(45) collate utf8_unicode_ci NOT NULL default '',
  `time` int(10) NOT NULL default '0',
  PRIMARY KEY  (`uniqueId`),
  UNIQUE KEY `uniqueId` (`uniqueId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_SpamBot`
--


--
-- Table structure for table `CubeCart_admin_log`
--

CREATE TABLE `CubeCart_admin_log` (
  `id` int(11) NOT NULL auto_increment,
  `user` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `desc` text collate utf8_unicode_ci NOT NULL,
  `time` int(11) NOT NULL default '0',
  `ipAddress` varchar(45) collate utf8_unicode_ci NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=110 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_admin_log`
--

INSERT INTO `CubeCart_admin_log` VALUES (1,'chris','',1276008699,'71.0.203.162'),(2,'chris','Configuration Updated.',1276008784,'71.0.203.162'),(3,'chris','Configuration Updated.',1276008810,'71.0.203.162'),(4,'chris','Configuration Updated.',1276008911,'71.0.203.162'),(5,'chris','Configuration Updated.',1276008947,'71.0.203.162'),(6,'chris','Configuration Updated.',1276008979,'71.0.203.162'),(7,'chris','Deleted successfully.',1276009054,'71.0.203.162'),(8,'chris','&#39;Reebok&#39; added successfully.',1276009194,'71.0.203.162'),(9,'chris','&#39;Calvin Klein&#39; added successfully.',1276009217,'71.0.203.162'),(10,'chris','&#39;shoes&#39; added successfully.',1276009479,'71.0.203.162'),(11,'chris','&#39;Shirts&#39; added successfully.',1276009505,'71.0.203.162'),(12,'chris','&#39;Bookmark and Share RunTone Action - Men&#39; added successfully.',1276009630,'71.0.203.162'),(13,'chris','&#39;Bookmark and Share RunTone Action - Men&#39; updated successfully.',1276009663,'71.0.203.162'),(14,'chris','&#39;Shirts&#39; added successfully.',1276009769,'71.0.203.162'),(15,'chris','&#39;Woven Jacket&#39; added successfully.',1276009807,'71.0.203.162'),(16,'chris','&#39;Challenger Short Sleeve Tee&#39; added successfully.',1276009840,'71.0.203.162'),(17,'chris','&#39;nylon storm jacket for all seasons&#39; added successfully.',1276009908,'71.0.203.162'),(18,'chris','',1276010320,'71.0.203.162'),(19,'chris','Configuration Updated.',1276010382,'71.0.203.162'),(20,'chris','Deleted successfully.',1276010468,'71.0.203.162'),(21,'chris','Option name added.',1276010493,'71.0.203.162'),(22,'chris','Product option deleted successfully.',1276010511,'71.0.203.162'),(23,'chris','No product reviews have been made or match that criteria.',1276010515,'71.0.203.162'),(24,'chris','',1276010540,'71.0.203.162'),(25,'chris','',1276010805,'71.0.203.162'),(26,'chris','',1276010815,'71.0.203.162'),(27,'chris','Configuration Updated.',1276010852,'71.0.203.162'),(28,'chris','Coupon added successfully.',1276013023,'71.0.203.162'),(29,'chris','Configuration Updated.',1276013156,'71.0.203.162'),(30,'chris','Failed to update product.',1276013812,'71.0.203.162'),(31,'chris','',1276013838,'71.0.203.162'),(32,'chris','&#39;Challenger Short Sleeve Tee&#39; updated successfully.',1276014230,'71.0.203.162'),(33,'chris','&#39;nylon storm jacket for all seasons&#39; updated successfully.',1276014255,'71.0.203.162'),(34,'chris','&#39;Bookmark and Share RunTone Action - Men&#39; updated successfully.',1276014392,'71.0.203.162'),(35,'chris','&#39;Woven Jacket&#39; updated successfully.',1276014555,'71.0.203.162'),(36,'chris','&#39;Challenger Short Sleeve Tee&#39; updated successfully.',1276014582,'71.0.203.162'),(37,'chris','&#39;nylon storm jacket for all seasons&#39; updated successfully.',1276014617,'71.0.203.162'),(38,'chris','`en` updated successfully.',1276020920,'71.0.203.162'),(39,'chris','',1276021120,'71.0.203.162'),(40,'chris','Configuration Updated.',1276021159,'71.0.203.162'),(41,'chris','`en` updated successfully.',1276021228,'71.0.203.162'),(42,'chris','`en` updated successfully.',1276021252,'71.0.203.162'),(43,'chris','',1276021266,'71.0.203.162'),(44,'chris','Configuration Updated.',1276021289,'71.0.203.162'),(45,'chris','`en` updated successfully.',1276021320,'71.0.203.162'),(46,'chris','`en` updated successfully.',1276021340,'71.0.203.162'),(47,'chris','`en` updated successfully.',1276021367,'71.0.203.162'),(48,'chris','`en` updated successfully.',1276021390,'71.0.203.162'),(49,'chris','`en` updated successfully.',1276021416,'71.0.203.162'),(50,'chris','`en` updated successfully.',1276021475,'71.0.203.162'),(51,'chris','`en` updated successfully.',1276021505,'71.0.203.162'),(52,'chris','`en` updated successfully.',1276021523,'71.0.203.162'),(53,'chris','`en` updated successfully.',1276021545,'71.0.203.162'),(54,'chris','`en` updated successfully.',1276021751,'71.0.203.162'),(55,'chris','`en` updated successfully.',1276021788,'71.0.203.162'),(56,'chris','`en` updated successfully.',1276021810,'71.0.203.162'),(57,'chris','',1276021829,'71.0.203.162'),(58,'chris','Configuration Updated.',1276021847,'71.0.203.162'),(59,'chris','`en` updated successfully.',1276021931,'71.0.203.162'),(60,'chris','&#39;RunTone Action - Men&#39; updated successfully.',1276022347,'71.0.203.162'),(61,'chris','&#39;Reebok&#39; updated successfully.',1276022376,'71.0.203.162'),(62,'chris','&#39;Calvin Klein&#39; updated successfully.',1276022383,'71.0.203.162'),(63,'chris','&#39;Reebok&#39; updated successfully.',1276022489,'71.0.203.162'),(64,'chris','&#39;Reebok&#39; updated successfully.',1276022514,'71.0.203.162'),(65,'chris','Failed to update category.',1276022533,'71.0.203.162'),(66,'chris','&#39;RunTone Action - Men&#39; updated successfully.',1276022698,'71.0.203.162'),(67,'chris','&#39;RunTone Action - Men&#39; updated successfully.',1276022750,'71.0.203.162'),(68,'chris','&#39;Shirts&#39; updated successfully.',1276022811,'71.0.203.162'),(69,'chris','&#39;nylon storm jacket for all seasons&#39; updated successfully.',1276022901,'71.0.203.162'),(70,'chris','&#39;RunTone Action - Men&#39; updated successfully.',1276022932,'71.0.203.162'),(71,'chris','',1276023440,'71.0.203.162'),(72,'chris','Configuration Updated.',1276023520,'71.0.203.162'),(73,'chris','Configuration Updated.',1276023610,'71.0.203.162'),(74,'chris','',1276026403,'71.0.203.162'),(75,'chris','Configuration Updated.',1276026418,'71.0.203.162'),(76,'chris','Configuration Updated.',1276026551,'71.0.203.162'),(77,'chris','&#39;RunTone Action - Men&#39; updated successfully.',1276027060,'71.0.203.162'),(78,'chris','The catalogue import is complete. View your products to assign the imported products to a category.',1276174889,'71.0.203.162'),(79,'chris','&#39;testtest&#39; updated successfully.',1276175005,'71.0.203.162'),(80,'chris','The catalogue import is complete. View your products to assign the imported products to a category.',1276187149,'71.0.203.162'),(81,'chris','The catalogue import is complete. View your products to assign the imported products to a category.',1276187534,'71.0.203.162'),(82,'chris','&#39;RunToneAction-Men&#39; added successfully.',1276187746,'71.0.203.162'),(83,'chris','&#39;Woven Jacket&#39; added successfully.',1276187839,'71.0.203.162'),(84,'chris','&#39;Challenger Short Sleeve Tee&#39; added successfully.',1276187908,'71.0.203.162'),(85,'chris','&#39;nylon storm jacket for all seasons&#39; added successfully.',1276188000,'71.0.203.162'),(86,'chris','&#39;Woven Jacket&#39; updated successfully.',1276188201,'71.0.203.162'),(87,'chris','&#39;Woven Jacket&#39; updated successfully.',1276188225,'71.0.203.162'),(88,'chris','Deleted successfully.',1276191759,'71.0.203.162'),(89,'chris','&#39;&#39; updated successfully.',1276191831,'71.0.203.162'),(90,'chris','&#39;&#39; updated successfully.',1276191832,'71.0.203.162'),(91,'chris','&#39;&#39; updated successfully.',1276191834,'71.0.203.162'),(92,'chris','Action `CHECK TABLE` has been performed successfully.',1276191902,'71.0.203.162'),(93,'chris','&#39;RunTone Action - Men&#39; added successfully.',1276192059,'71.0.203.162'),(94,'chris','&#39;Reebok shoes&#39; added successfully.',1276192101,'71.0.203.162'),(95,'chris','&#39;RunTone Action - Men&#39; updated successfully.',1276192122,'71.0.203.162'),(96,'chris','&#39;Reebok Shirts&#39; added successfully.',1276192183,'71.0.203.162'),(97,'chris','&#39;Red Short Sleeve&#39; added successfully.',1276192363,'71.0.203.162'),(98,'chris','&#39;Red Short Sleeve&#39; updated successfully.',1276192421,'71.0.203.162'),(99,'chris','&#39;Woven Jacket&#39; added successfully.',1276192525,'71.0.203.162'),(100,'chris','&#39;Nylon Storm Jacket&#39; added successfully.',1276192711,'71.0.203.162'),(101,'chris','&#39;Calvin Klein&#39; added successfully.',1276192740,'71.0.203.162'),(102,'chris','&#39;Nylon Storm Jacket&#39; updated successfully.',1276192782,'71.0.203.162'),(103,'chris','Customer updated successfully.',1276192996,'71.0.203.162'),(104,'chris','Deleted successfully.',1276193127,'71.0.203.162'),(105,'chris','Customer added successfully.',1276193187,'71.0.203.162'),(106,'chris','&#39;Nylon Storm Jacket Red&#39; added successfully.',1276193840,'71.0.203.162'),(107,'chris','&#39;red&#39; added successfully.',1276193861,'71.0.203.162'),(108,'chris','&#39;Nylon Storm Jacket Red&#39; updated successfully.',1276193926,'71.0.203.162'),(109,'chris','',1276615537,'74.5.27.178');

--
-- Table structure for table `CubeCart_admin_permissions`
--

CREATE TABLE `CubeCart_admin_permissions` (
  `permissionId` smallint(6) NOT NULL auto_increment,
  `sectId` smallint(6) NOT NULL default '0',
  `adminId` smallint(6) NOT NULL default '0',
  `read` smallint(6) NOT NULL default '0',
  `write` smallint(6) NOT NULL default '0',
  `edit` smallint(6) NOT NULL default '0',
  `delete` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`permissionId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_admin_permissions`
--


--
-- Table structure for table `CubeCart_admin_sections`
--

CREATE TABLE `CubeCart_admin_sections` (
  `sectId` smallint(6) NOT NULL auto_increment,
  `name` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `description` text collate utf8_unicode_ci NOT NULL,
  KEY `sectId` (`sectId`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_admin_sections`
--

INSERT INTO `CubeCart_admin_sections` VALUES (1,'users','For the administration of admin users and their permissions.'),(2,'products','For the administration of products.'),(3,'categories','For the administration of categories.'),(4,'documents','For the administration of site documents.'),(5,'customers','For the administration of customers details.'),(6,'shipping','For the administration of shipping methods.'),(7,'filemanager','For the administration of the website images.'),(8,'statistics','This section displays store statistics.'),(9,'settings','For the administration of the code store settings.'),(10,'orders','Access rights for the orders section.'),(11,'offers','Special offers &amp; promotions.'),(12,'reviews','Customer reviews &amp; comments.');

--
-- Table structure for table `CubeCart_admin_sessions`
--

CREATE TABLE `CubeCart_admin_sessions` (
  `loginId` int(11) NOT NULL auto_increment,
  `username` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  `ipAddress` varchar(45) collate utf8_unicode_ci NOT NULL default '',
  `success` int(11) NOT NULL default '0',
  KEY `loginId` (`loginId`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_admin_sessions`
--

INSERT INTO `CubeCart_admin_sessions` VALUES (1,'chris',1276007199,'71.0.203.162',1),(2,'chris',1276013007,'71.0.203.162',1),(3,'chris',1276014318,'71.0.203.162',1),(4,'chris',1276014407,'71.0.203.162',1),(5,'chris',1276014487,'71.0.203.162',1),(6,'chris',1276014944,'71.0.203.162',1),(7,'chris',1276020767,'71.0.203.162',1),(8,'chris',1276022261,'71.0.203.162',1),(9,'chris',1276022306,'71.0.203.162',1),(10,'chris',1276026398,'71.0.203.162',1),(11,'chris',1276174129,'71.0.203.162',1),(12,'chris',1276174159,'71.0.203.162',1),(13,'chris',1276174458,'71.0.203.162',1),(14,'chris',1276186818,'71.0.203.162',1),(15,'chris',1276187619,'71.0.203.162',1),(16,'chris',1276615522,'74.5.27.178',1);

--
-- Table structure for table `CubeCart_admin_users`
--

CREATE TABLE `CubeCart_admin_users` (
  `adminId` int(11) NOT NULL auto_increment,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `username` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `password` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `salt` varchar(6) collate utf8_unicode_ci NOT NULL default '',
  `email` varchar(254) collate utf8_unicode_ci NOT NULL default '',
  `noLogins` int(11) NOT NULL default '0',
  `isSuper` int(11) NOT NULL default '0',
  `notes` text collate utf8_unicode_ci,
  `sessId` varchar(32) collate utf8_unicode_ci default NULL,
  `browser` text collate utf8_unicode_ci,
  `sessIp` varchar(45) collate utf8_unicode_ci default NULL,
  `failLevel` smallint(1) NOT NULL default '0',
  `blockTime` int(10) NOT NULL default '0',
  `lastTime` int(10) NOT NULL default '0',
  KEY `adminId` (`adminId`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_admin_users`
--

INSERT INTO `CubeCart_admin_users` VALUES (1,'chris dillon','chris','1d9985780cb9fab1877c3b3be4cee5db','xT0W2y','cdillon@computer-assist.com',16,1,'This user was setup during installation.','0572a56d4e184d35acd69fa735509df0','Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3','74.5.27.178',0,0,0);

--
-- Table structure for table `CubeCart_alt_shipping`
--

CREATE TABLE `CubeCart_alt_shipping` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `status` smallint(1) NOT NULL default '0',
  `byprice` smallint(1) NOT NULL default '0',
  `global` smallint(1) NOT NULL default '0',
  `notes` varchar(255) collate utf8_unicode_ci default NULL,
  `order` int(11) default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_alt_shipping`
--


--
-- Table structure for table `CubeCart_alt_shipping_prices`
--

CREATE TABLE `CubeCart_alt_shipping_prices` (
  `id` int(11) NOT NULL auto_increment,
  `alt_ship_id` int(11) NOT NULL default '0',
  `low` decimal(30,3) NOT NULL default '0.000',
  `high` decimal(30,3) NOT NULL default '0.000',
  `price` decimal(30,3) NOT NULL default '0.000',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_alt_shipping_prices`
--


--
-- Table structure for table `CubeCart_blocker`
--

CREATE TABLE `CubeCart_blocker` (
  `id` int(11) NOT NULL auto_increment,
  `browser` text collate utf8_unicode_ci NOT NULL,
  `ip` varchar(45) collate utf8_unicode_ci NOT NULL default '',
  `username` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `blockTime` int(10) NOT NULL default '0',
  `blockLevel` smallint(1) NOT NULL default '0',
  `loc` char(1) collate utf8_unicode_ci NOT NULL default '',
  `lastTime` int(10) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_blocker`
--


--
-- Table structure for table `CubeCart_category`
--

CREATE TABLE `CubeCart_category` (
  `cat_id` int(16) unsigned NOT NULL auto_increment,
  `cat_name` varchar(100) collate utf8_unicode_ci default NULL,
  `cat_desc` text collate utf8_unicode_ci,
  `cat_father_id` int(16) unsigned NOT NULL default '0',
  `cat_image` varbinary(250) default NULL,
  `per_ship` decimal(20,2) NOT NULL default '0.00',
  `item_ship` decimal(20,2) NOT NULL default '0.00',
  `item_int_ship` decimal(20,2) NOT NULL default '0.00',
  `per_int_ship` decimal(20,2) NOT NULL default '0.00',
  `noProducts` int(11) NOT NULL default '0',
  `hide` tinyint(1) NOT NULL default '0',
  `cat_metatitle` text collate utf8_unicode_ci,
  `cat_metadesc` text collate utf8_unicode_ci,
  `cat_metakeywords` text collate utf8_unicode_ci,
  `seo_custom_url` text collate utf8_unicode_ci,
  `priority` smallint(6) default NULL,
  PRIMARY KEY  (`cat_id`),
  KEY `cat_father_id` (`cat_father_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_category`
--

INSERT INTO `CubeCart_category` VALUES (9,'Reebok Shirts','',0,'','0.00','0.00','0.00','0.00',2,0,NULL,NULL,NULL,NULL,9),(10,'Calvin Klein','',0,'','0.00','0.00','0.00','0.00',2,0,NULL,NULL,NULL,NULL,10),(11,'red','',10,'','0.00','0.00','0.00','0.00',1,0,NULL,NULL,NULL,NULL,11),(2,'Reebok','',0,'','0.00','0.00','0.00','0.00',7,1,NULL,NULL,NULL,NULL,2),(3,'Calvin Klein','',0,'','0.00','0.00','0.00','0.00',2,1,NULL,NULL,NULL,NULL,1),(4,'shoes','',2,'shoe catagory logo.jpg','0.00','0.00','0.00','0.00',1,1,NULL,NULL,NULL,NULL,1),(8,'Reebok shoes','',0,'','0.00','0.00','0.00','0.00',1,0,NULL,NULL,NULL,NULL,8),(6,'Shirts','',2,'shirt image.jpg','0.00','0.00','0.00','0.00',2,0,NULL,NULL,NULL,NULL,2),(7,'Imported Products','##HIDDEN##',0,NULL,'0.00','0.00','0.00','0.00',15,1,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `CubeCart_cats_idx`
--

CREATE TABLE `CubeCart_cats_idx` (
  `id` int(11) NOT NULL auto_increment,
  `cat_id` int(11) NOT NULL default '0',
  `productId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_cats_idx`
--

INSERT INTO `CubeCart_cats_idx` VALUES (1,7,1),(2,7,2),(3,7,3),(4,7,4),(5,7,5),(6,7,6),(7,2,7),(12,2,8),(9,2,9),(10,3,10),(15,8,11),(18,9,12),(19,9,13),(22,10,14),(25,11,15);

--
-- Table structure for table `CubeCart_cats_lang`
--

CREATE TABLE `CubeCart_cats_lang` (
  `id` int(11) NOT NULL auto_increment,
  `cat_master_id` int(11) NOT NULL default '0',
  `cat_lang` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  `cat_name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `cat_desc` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `cat_master_id` (`cat_master_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_cats_lang`
--


--
-- Table structure for table `CubeCart_config`
--

CREATE TABLE `CubeCart_config` (
  `name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `array` text collate utf8_unicode_ci NOT NULL,
  KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_config`
--

INSERT INTO `CubeCart_config` VALUES ('Free_Shipping','a:1:{s:6:\"status\";s:1:\"1\";}'),('Print_Order_Form','a:16:{s:6:\"status\";s:1:\"1\";s:7:\"default\";s:1:\"1\";s:13:\"multiCurrency\";s:1:\"1\";s:4:\"desc\";s:17:\"Postal Order Form\";s:6:\"cheque\";s:1:\"1\";s:9:\"payableTo\";s:16:\"Company Name Ltd\";s:4:\"card\";s:1:\"1\";s:5:\"cards\";s:35:\"Mastercard,Visa,Switch,Maestro,AMEX\";s:4:\"bank\";s:1:\"1\";s:8:\"bankName\";s:13:\"Your Bank Plc\";s:7:\"accName\";s:12:\"Company Name\";s:8:\"sortCode\";s:8:\"xx-xx-xx\";s:4:\"acNo\";s:8:\"xxxxxxxx\";s:9:\"swiftCode\";s:8:\"xxxxxxxx\";s:7:\"address\";s:70:\"Address Line 1\r\nAddress Line 2\r\nAddress Line 3\r\nAddress Line 4\r\nxxxxxx\";s:5:\"notes\";s:44:\"We can only accept payments in xxx currency.\";}'),('config','a:85:{s:9:\"taxCounty\";s:2:\"47\";s:11:\"installTime\";s:10:\"1276007166\";s:16:\"sefprodnamefirst\";s:1:\"0\";s:10:\"taxCountry\";s:3:\"226\";s:7:\"skinDir\";s:8:\"KitaBlue\";s:9:\"siteTitle\";s:14:\"T & L Graphics\";s:15:\"metaDescription\";s:29:\"This is the meta description.\";s:12:\"metaKeyWords\";s:29:\"keyword1, keyword2, keyword3.\";s:9:\"storeName\";s:14:\"T & L Graphics\";s:12:\"storeAddress\";s:39:\"109 E. Main St,\r\nBelle Center, OH 43310\";s:11:\"siteCountry\";s:3:\"226\";s:10:\"siteCounty\";s:2:\"47\";s:3:\"ssl\";s:1:\"0\";s:9:\"force_ssl\";s:1:\"0\";s:11:\"rootRel_SSL\";s:0:\"\";s:12:\"storeURL_SSL\";s:0:\"\";s:12:\"dnLoadExpire\";s:6:\"172800\";s:11:\"dnLoadTimes\";s:1:\"3\";s:11:\"defaultLang\";s:2:\"en\";s:10:\"changeskin\";s:1:\"0\";s:15:\"showLatestProds\";s:1:\"0\";s:13:\"noLatestProds\";s:1:\"0\";s:14:\"noRelatedProds\";s:1:\"0\";s:9:\"dirSymbol\";s:1:\"/\";s:12:\"productPages\";s:2:\"10\";s:13:\"productPrecis\";s:3:\"120\";s:14:\"noSaleBoxItems\";s:2:\"10\";s:17:\"noPopularBoxItems\";s:2:\"10\";s:10:\"masterName\";s:14:\"T & L Graphics\";s:11:\"masterEmail\";s:27:\"cdillon@computer-assist.com\";s:10:\"mailMethod\";s:4:\"mail\";s:8:\"smtpHost\";s:0:\"\";s:8:\"smtpPort\";s:0:\"\";s:8:\"smtpAuth\";s:5:\"false\";s:12:\"smtpUsername\";s:0:\"\";s:12:\"smtpPassword\";s:0:\"\";s:18:\"maxImageUploadSize\";s:6:\"524288\";s:16:\"sqlSessionExpiry\";s:6:\"172800\";s:12:\"floodControl\";s:1:\"0\";s:14:\"richTextEditor\";s:1:\"1\";s:9:\"rteHeight\";s:3:\"350\";s:13:\"rteHeightUnit\";s:0:\"\";s:5:\"debug\";s:1:\"0\";s:13:\"latestNewsRRS\";s:52:\"http://forums.cubecart.com/index.php?act=rssout&id=1\";s:17:\"add_to_basket_act\";s:1:\"1\";s:14:\"imgGalleryType\";s:1:\"0\";s:8:\"cat_tree\";s:1:\"1\";s:11:\"hide_prices\";s:1:\"0\";s:19:\"pop_products_source\";s:1:\"0\";s:5:\"cache\";s:1:\"1\";s:14:\"show_empty_cat\";s:1:\"1\";s:19:\"disable_alert_email\";s:1:\"0\";s:16:\"cat_newest_first\";s:1:\"0\";s:16:\"google_analytics\";s:0:\"\";s:11:\"orderExpire\";s:1:\"0\";s:9:\"gdversion\";s:1:\"2\";s:12:\"gdGifSupport\";s:1:\"1\";s:11:\"gdthumbSize\";s:2:\"75\";s:12:\"gdmaxImgSize\";s:3:\"390\";s:9:\"gdquality\";s:2:\"80\";s:10:\"stockLevel\";s:1:\"0\";s:18:\"outofstockPurchase\";s:1:\"1\";s:17:\"stock_change_time\";s:1:\"0\";s:18:\"stock_replace_time\";a:4:{i:1;s:1:\"1\";i:2;s:1:\"1\";i:5;s:1:\"1\";i:6;s:1:\"1\";}s:15:\"stock_warn_type\";s:1:\"0\";s:16:\"stock_warn_level\";s:1:\"5\";s:10:\"weightUnit\";s:2:\"Lb\";s:10:\"timeFormat\";s:18:\"%b %d %Y, %H:%M %p\";s:10:\"timeOffset\";s:1:\"0\";s:10:\"dateFormat\";s:8:\"l jS F Y\";s:15:\"defaultCurrency\";s:3:\"USD\";s:11:\"currecyAuto\";s:1:\"0\";s:11:\"priceIncTax\";s:1:\"0\";s:14:\"priceTaxDelInv\";s:1:\"0\";s:8:\"saleMode\";s:1:\"1\";s:14:\"salePercentOff\";s:1:\"0\";s:15:\"shipAddressLock\";s:1:\"0\";s:7:\"offLine\";s:1:\"0\";s:17:\"offLineAllowAdmin\";s:1:\"1\";s:5:\"proxy\";s:1:\"0\";s:9:\"proxyHost\";s:0:\"\";s:9:\"proxyPort\";s:0:\"\";s:3:\"sef\";s:1:\"0\";s:7:\"seftags\";s:1:\"0\";s:14:\"offLineContent\";s:84:\"PHA+VGhlIHN0b3JlIGlzIGN1cnJlbnRseSBvZmZsaW5lLiBQbGVhc2UgdmlzaXQgYWdhaW4gc29vbi48L3A+\";}'),('UPS','a:18:{s:6:\"status\";s:1:\"1\";s:8:\"postcode\";s:5:\"43311\";s:9:\"container\";s:2:\"CP\";s:3:\"tax\";s:1:\"1\";s:4:\"rate\";s:3:\"RDP\";s:6:\"rescom\";s:3:\"RES\";s:8:\"handling\";s:0:\"\";s:10:\"product1DM\";s:1:\"0\";s:10:\"product1DA\";s:1:\"0\";s:10:\"product1DP\";s:1:\"0\";s:10:\"product2DM\";s:1:\"0\";s:10:\"product2DA\";s:1:\"0\";s:10:\"product3DS\";s:1:\"0\";s:10:\"productGND\";s:1:\"1\";s:10:\"productSTD\";s:1:\"0\";s:10:\"productXPR\";s:1:\"0\";s:10:\"productXDM\";s:1:\"0\";s:10:\"productXPD\";s:1:\"0\";}'),('Multiple_Tax_Mod','a:2:{s:6:\"status\";s:1:\"0\";s:5:\"debug\";s:1:\"0\";}'),('USPS','a:28:{s:6:\"status\";s:1:\"0\";s:5:\"debug\";s:1:\"0\";s:14:\"serviceExpress\";s:1:\"1\";s:11:\"expressSize\";s:7:\"REGULAR\";s:16:\"expressContainer\";s:18:\"Flat Rate Envelope\";s:17:\"serviceFirstClass\";s:1:\"1\";s:18:\"FirstClassMailType\";s:6:\"LETTER\";s:21:\"FirstClassMachineable\";s:4:\"TRUE\";s:15:\"servicePriority\";s:1:\"1\";s:12:\"prioritySize\";s:7:\"REGULAR\";s:17:\"priorityContainer\";s:8:\"Variable\";s:14:\"priorityLength\";s:0:\"\";s:13:\"priorityWidth\";s:0:\"\";s:14:\"priorityHeight\";s:0:\"\";s:13:\"priorityGirth\";s:0:\"\";s:13:\"serviceParcel\";s:1:\"1\";s:10:\"parcelSize\";s:7:\"REGULAR\";s:17:\"parcelMachineable\";s:4:\"TRUE\";s:10:\"serviceBPM\";s:1:\"0\";s:7:\"BPMSize\";s:7:\"REGULAR\";s:14:\"serviceLibrary\";s:1:\"0\";s:11:\"LibrarySize\";s:7:\"REGULAR\";s:12:\"serviceMedia\";s:1:\"0\";s:9:\"MediaSize\";s:7:\"REGULAR\";s:8:\"handling\";s:0:\"\";s:9:\"ziporigin\";s:0:\"\";s:8:\"username\";s:0:\"\";s:8:\"password\";s:4:\"none\";}'),('PayPal','a:5:{s:6:\"status\";s:1:\"1\";s:4:\"desc\";s:6:\"Paypal\";s:5:\"email\";s:27:\"cdillon@computer-assist.com\";s:7:\"default\";s:1:\"0\";s:8:\"testMode\";s:1:\"0\";}');

--
-- Table structure for table `CubeCart_currencies`
--

CREATE TABLE `CubeCart_currencies` (
  `currencyId` int(11) NOT NULL auto_increment,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `code` varchar(5) collate utf8_unicode_ci NOT NULL default '',
  `symbolLeft` varbinary(10) default NULL,
  `symbolRight` varbinary(10) default NULL,
  `value` decimal(10,5) NOT NULL default '0.00000',
  `decimalPlaces` int(11) NOT NULL default '0',
  `lastUpdated` int(10) NOT NULL default '0',
  `active` smallint(1) NOT NULL default '0',
  `decimalSymbol` smallint(1) NOT NULL default '0',
  KEY `curencyId` (`currencyId`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_currencies`
--

INSERT INTO `CubeCart_currencies` VALUES (1,'British Pounds','GBP','£','','0.52778',2,1111670592,0,0),(2,'US Dollars','USD','$','','1.00000',2,1112128377,1,0),(3,'Euro','EUR','€','','0.76626',2,1111669701,0,1),(4,'Japanese Yen','JPY','¥','','105.53000',0,1111669706,0,0),(5,'Canadian Dollars','CAD','$','','1.23062',2,1108994873,0,0),(6,'Australian Dollars','AUD','$','','1.26895',2,1108994869,0,0),(7,'Swiss Francs','CHF','CHF','','1.18312',2,1108994881,0,0),(8,'Russian Rubles','RUB','','R','27.94500',0,1108994885,0,0),(9,'Chinese Yuan','CNY','','Yuan','8.27650',2,1108994875,0,0),(10,'South African Rand','ZAR','R','','5.93606',0,1108994883,0,0),(11,'Mexican Peso','MXN','$','','11.05500',2,1108994888,0,0);

--
-- Table structure for table `CubeCart_customer`
--

CREATE TABLE `CubeCart_customer` (
  `email` varchar(254) collate utf8_unicode_ci NOT NULL default '',
  `password` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `salt` varchar(6) collate utf8_unicode_ci NOT NULL default '',
  `title` varchar(10) collate utf8_unicode_ci default NULL,
  `firstName` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `lastName` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `companyName` varchar(150) collate utf8_unicode_ci NOT NULL default '',
  `add_1` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `add_2` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `town` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `county` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `postcode` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  `country` int(3) NOT NULL default '0',
  `phone` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  `mobile` varchar(50) collate utf8_unicode_ci default NULL,
  `customer_id` int(11) NOT NULL auto_increment,
  `regTime` int(10) NOT NULL default '0',
  `ipAddress` varchar(45) collate utf8_unicode_ci NOT NULL default '',
  `noOrders` int(11) default '0',
  `optIn1st` int(11) NOT NULL default '0',
  `htmlEmail` int(11) NOT NULL default '1',
  `type` int(11) default '0',
  PRIMARY KEY  (`customer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_customer`
--

INSERT INTO `CubeCart_customer` VALUES ('cdillon1@computer-assist.com','867e6a1b56f478b1f7cc71f2a7ee13cd','p5W2zu','','christopher','dillon','','133 w columbus ave','','bellefontaine','Ohio','43311',226,'937-592-0299','',3,1276615371,'74.5.27.178',1,0,1,1),('cdillon@computer-assist.com','4d4a9f46c6a225d8d5267cebd9451973','uJuDK5','','chris','dillon','','133 w columbus ave','','bellefontaine','ohio','43311',226,'937-592-0299','',2,1276193187,'',1,0,1,1);

--
-- Table structure for table `CubeCart_docs`
--

CREATE TABLE `CubeCart_docs` (
  `doc_name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `doc_content` text collate utf8_unicode_ci NOT NULL,
  `doc_id` int(16) NOT NULL auto_increment,
  `doc_metatitle` text collate utf8_unicode_ci NOT NULL,
  `doc_metadesc` text collate utf8_unicode_ci NOT NULL,
  `doc_metakeywords` text collate utf8_unicode_ci NOT NULL,
  `doc_order` int(11) default '0',
  `doc_terms` smallint(1) default '0',
  `doc_url` text collate utf8_unicode_ci,
  `doc_url_openin` smallint(1) default '0',
  KEY `doc_id` (`doc_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_docs`
--

INSERT INTO `CubeCart_docs` VALUES ('About Us','This can be managed under <span class=\"navTitle\">Documents - Site Documents in the admin control panel.<br/>\r\n</span>',1,'','','',1,0,NULL,0),('Contact Us','This can be managed under <span class=\"navTitle\">Documents - Site Documents in the admin control panel.</span><span class=\"navTitle\"/>',2,'','','',2,0,NULL,0),('Terms & Conditions','This can be managed under <span class=\"navTitle\">Documents - Site Documents in the admin control panel.</span>',3,'','','',3,1,NULL,0),('Privacy Policy','This can be managed under <span class=\"navTitle\">Documents - Site Documents in the admin control panel.</span>',4,'','','',4,0,NULL,0);

--
-- Table structure for table `CubeCart_docs_lang`
--

CREATE TABLE `CubeCart_docs_lang` (
  `id` int(11) NOT NULL auto_increment,
  `doc_master_id` int(11) NOT NULL default '0',
  `doc_lang` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  `doc_name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `doc_content` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_docs_lang`
--


--
-- Table structure for table `CubeCart_filemanager`
--

CREATE TABLE `CubeCart_filemanager` (
  `file_id` int(10) unsigned NOT NULL auto_increment,
  `type` int(1) NOT NULL default '1',
  `disabled` int(1) NOT NULL default '0',
  `filepath` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `filename` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `filesize` int(11) NOT NULL default '0',
  `mimetype` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `md5hash` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `description` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`file_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_filemanager`
--

INSERT INTO `CubeCart_filemanager` VALUES (1,1,0,'images/uploads/rebook logo.jpg','rebook logo.jpg',3139,'image/jpeg','2a0a643f585003f86cae7a2ded16457d',''),(2,1,0,'images/uploads/calvin logo.jpg','calvin logo.jpg',2316,'image/jpeg','1dc028c44961e47c4bfa80e760ba431a',''),(3,1,0,'images/uploads/shoe catagory logo.jpg','shoe catagory logo.jpg',2756,'image/jpeg','6eb1a47b4720e0284816b97ce9d1737f',''),(4,1,0,'images/uploads/shirt image.jpg','shirt image.jpg',6070,'image/jpeg','d7b37fee540fafe40d9459a37531fc5a',''),(5,1,0,'images/uploads/reebok runtone action.jpg','reebok runtone action.jpg',1380,'image/jpeg','a18a8ca0a9797ddc5b2b1a6b4cd83e30',''),(6,1,0,'images/uploads/rbok short sleeve.jpg','rbok short sleeve.jpg',1098,'image/jpeg','b4efd50bbf286f379df1abc42570ed9f',''),(7,1,0,'images/uploads/rok woven jacket.jpg','rok woven jacket.jpg',1010,'image/jpeg','251f45b6a56c104b0f8397c96e9bdadf',''),(8,1,0,'images/uploads/cal jacket.jpg','cal jacket.jpg',6166,'image/jpeg','829037fe5e1b6ca667bab868da3f63de',''),(9,1,0,'images/uploads/red shirt.jpg','red shirt.jpg',1098,'image/jpeg','b4efd50bbf286f379df1abc42570ed9f','');

--
-- Table structure for table `CubeCart_history`
--

CREATE TABLE `CubeCart_history` (
  `id` int(11) NOT NULL auto_increment,
  `version` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_history`
--

INSERT INTO `CubeCart_history` VALUES (1,'4.4.1',1276007167);

--
-- Table structure for table `CubeCart_img_idx`
--

CREATE TABLE `CubeCart_img_idx` (
  `id` int(11) NOT NULL auto_increment,
  `productId` int(11) NOT NULL default '0',
  `img` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `productId` (`productId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_img_idx`
--


--
-- Table structure for table `CubeCart_inv_lang`
--

CREATE TABLE `CubeCart_inv_lang` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `prod_lang` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  `prod_master_id` int(11) NOT NULL default '0',
  `description` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `prod_master_id` (`prod_master_id`),
  FULLTEXT KEY `fulltext` (`name`,`description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_inv_lang`
--


--
-- Table structure for table `CubeCart_inventory`
--

CREATE TABLE `CubeCart_inventory` (
  `productId` int(11) NOT NULL auto_increment,
  `disabled` tinyint(1) NOT NULL default '0',
  `productCode` varchar(60) collate utf8_unicode_ci default NULL,
  `quantity` int(16) NOT NULL default '1',
  `description` text collate utf8_unicode_ci,
  `image` varbinary(250) default NULL,
  `noImages` int(11) NOT NULL default '0',
  `price` decimal(30,2) NOT NULL default '0.00',
  `name` varchar(250) collate utf8_unicode_ci default NULL,
  `cat_id` int(16) NOT NULL default '0',
  `popularity` bigint(64) NOT NULL default '0',
  `sale_price` decimal(30,2) NOT NULL default '0.00',
  `stock_level` int(11) NOT NULL default '0',
  `stockWarn` tinyint(1) NOT NULL default '0',
  `useStockLevel` int(11) NOT NULL default '1',
  `digital` int(11) NOT NULL default '0',
  `digitalDir` varchar(255) collate utf8_unicode_ci default NULL,
  `prodWeight` decimal(10,3) default NULL,
  `taxType` int(11) default NULL,
  `tax_inclusive` tinyint(1) NOT NULL default '0',
  `showFeatured` tinyint(1) unsigned NOT NULL default '1',
  `prod_metatitle` text collate utf8_unicode_ci,
  `prod_metadesc` text collate utf8_unicode_ci,
  `prod_metakeywords` text collate utf8_unicode_ci,
  `eanupcCode` bigint(17) unsigned default NULL,
  `date_added` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `seo_custom_url` text collate utf8_unicode_ci,
  PRIMARY KEY  (`productId`),
  KEY `popularity` (`popularity`),
  KEY `cat_id` (`cat_id`),
  FULLTEXT KEY `fulltext` (`productCode`,`description`,`name`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_inventory`
--

INSERT INTO `CubeCart_inventory` VALUES (12,0,'REDOCA892',1,'<p>Challenger Short Sleeve Tee Our Challenger Short Sleeve Tee is made with a lightweight moisture-wicking PlayDry fabric, which helps accelerate evaporation and increases ventilation, keeping you drier longer during those hardcore workouts. The generous fit allows for ease of movement for high-performance comfort. * 100% Polyester * PlayDry fabric wicks moisture, accelerates evaporation, increases ventilation, reduces chaffing and doesn&rsquo;t trap heat * Regular fit &ndash; not too tight, not too loose; perfect for all exercise types * Knit short sleeve, crew neck design</p>','rbok short sleeve.jpg',0,'19.95','Red Short Sleeve',9,1,'0.00',10,0,1,0,'','1.000',1,0,1,NULL,NULL,NULL,0,'2010-06-10 12:52:43',NULL),(13,0,'WOVUVQ4A9',1,'<p>Our Woven Running Jacket has a packable hood, is made from water repellent material and comes with no excuses. Relaxed fit allows for comfortable runs; on-seam pockets; bungee cord at collar and waist for customized fit; elastic band cuffs. * 100% Polyester * Water repellent shell for all-weather workouts; full-zip front * Packable hood zips into collar; mesh lining for optimal breathability * Relaxed Fit &ndash; hangs off the body for a comfortable, accommodating fit; perfect for exercise and everyday activities </p>','rok woven jacket.jpg',0,'29.95','Woven Jacket',9,4,'0.00',25,0,1,0,'','3.000',1,0,1,NULL,NULL,NULL,0,'2010-06-10 12:55:25',NULL),(14,0,'NYL2CRED3',1,'<p>nylon storm jacket for all seasons * concealed button + full zip closure * brushed chrome logo buttons * molded utility pockets * adjustable Velcro&reg; closures at cuffs * interior zip pockets * machine wash * 100% polyester * imported</p>','cal jacket.jpg',0,'39.95','Nylon Storm Jacket',10,3,'0.00',7,0,1,0,'','4.000',1,0,1,NULL,NULL,NULL,0,'2010-06-10 12:58:31',NULL),(15,0,'NYLVEFXE2',1,'<p>&nbsp;nylon storm jacket for all seasons * concealed button + full zip closure * brushed chrome logo buttons * molded utility pockets * adjustable Velcro&reg; closures at cuffs * interior zip pockets * machine wash * 100% polyester * imported</p>','red shirt.jpg',0,'20.00','Nylon Storm Jacket Red',11,0,'0.00',5,0,1,0,'','3.000',1,0,1,NULL,NULL,NULL,0,'2010-06-10 13:17:20',NULL),(11,0,'RUNP1QM12',1,'<p>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n<meta name=\"ProgId\" content=\"Word.Document\">\r\n<meta name=\"Generator\" content=\"Microsoft Word 11\">\r\n<meta name=\"Originator\" content=\"Microsoft Word 11\">\r\n<link rel=\"File-List\" href=\"file:///C:\\Users\\chris\\AppData\\Local\\Temp\\msohtml1\\09\\clip_filelist.xml\" /><!--[if gte mso 9]><xml>\r\n<w:WordDocument>\r\n<w:View>Normal</w:View>\r\n<w:Zoom>0</w:Zoom>\r\n<w:PunctuationKerning />\r\n<w:ValidateAgainstSchemas />\r\n<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>\r\n<w:IgnoreMixedContent>false</w:IgnoreMixedContent>\r\n<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>\r\n<w:Compatibility>\r\n<w:BreakWrappedTables />\r\n<w:SnapToGridInCell />\r\n<w:WrapTextWithPunct />\r\n<w:UseAsianBreakRules />\r\n<w:DontGrowAutofit />\r\n</w:Compatibility>\r\n<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>\r\n</w:WordDocument>\r\n</xml><![endif]--><!--[if gte mso 9]><xml>\r\n<w:LatentStyles DefLockedState=\"false\" LatentStyleCount=\"156\">\r\n</w:LatentStyles>\r\n</xml><![endif]--><style type=\"text/css\">\r\n<!--\r\n /* Font Definitions */\r\n @font-face\r\n	{font-family:Calibri;\r\n	panose-1:2 15 5 2 2 2 4 3 2 4;\r\n	mso-font-charset:0;\r\n	mso-generic-font-family:swiss;\r\n	mso-font-pitch:variable;\r\n	mso-font-signature:-520092929 1073786111 9 0 415 0;}\r\n /* Style Definitions */\r\n p.MsoNormal, li.MsoNormal, div.MsoNormal\r\n	{mso-style-parent:\"\";\r\n	margin:0in;\r\n	margin-bottom:.0001pt;\r\n	mso-pagination:widow-orphan;\r\n	font-size:12.0pt;\r\n	font-family:\"Times New Roman\";\r\n	mso-fareast-font-family:\"Times New Roman\";}\r\n@page Section1\r\n	{size:8.5in 11.0in;\r\n	margin:1.0in 1.25in 1.0in 1.25in;\r\n	mso-header-margin:.5in;\r\n	mso-footer-margin:.5in;\r\n	mso-paper-source:0;}\r\ndiv.Section1\r\n	{page:Section1;}\r\n-->\r\n</style><!--[if gte mso 10]>\r\n<style>\r\n/* Style Definitions */\r\ntable.MsoNormalTable\r\n{mso-style-name:\"Table Normal\";\r\nmso-tstyle-rowband-size:0;\r\nmso-tstyle-colband-size:0;\r\nmso-style-noshow:yes;\r\nmso-style-parent:\"\";\r\nmso-padding-alt:0in 5.4pt 0in 5.4pt;\r\nmso-para-margin:0in;\r\nmso-para-margin-bottom:.0001pt;\r\nmso-pagination:widow-orphan;\r\nfont-size:10.0pt;\r\nfont-family:\"Times New Roman\";\r\nmso-ansi-language:#0400;\r\nmso-fareast-language:#0400;\r\nmso-bidi-language:#0400;}\r\n</style>\r\n<![endif]--> </meta>\r\n</meta>\r\n</meta>\r\n</meta>\r\n</p>\r\n<p class=\"MsoNormal\" style=\"margin-bottom: 10pt; line-height: 115%;\"><span lang=\"EN\" style=\"font-size: 11pt; line-height: 115%; font-family: Calibri;\">Men You asked for it &ndash; you got it: the muscle-toning shoe you can wear while running, training and working out. Compared to a traditional running shoe, RunTone, a close cousin to our EasyTone shoe, encourages more activation in key leg muscles like the calves and quads and reduces overall body stress. * RunTone patented sole technology features 8 pods of moving air that force your muscles to work harder; encourages increased muscle activation, toning, strength and endurance * Synthetic/mesh upper ensures comfort, fit and durability * SmoothFit seamless liner minimizes rub and irritation * DMX Shear cushioning panels for added comfort and reduced heel stress; IMEVA midsole for added cushioning; removable sockliner accommodates orthotics <o:p></o:p></span></p>\r\n<p>&nbsp;</p>','reebok runtone action.jpg',0,'59.95','RunTone Action - Men',8,3,'0.00',10,0,1,0,'','2.000',1,0,1,NULL,NULL,NULL,0,'2010-06-10 12:47:39',NULL);

--
-- Table structure for table `CubeCart_iso_counties`
--

CREATE TABLE `CubeCart_iso_counties` (
  `id` int(11) NOT NULL auto_increment,
  `countryId` smallint(4) NOT NULL default '0',
  `abbrev` varchar(4) collate utf8_unicode_ci NOT NULL default '',
  `name` varchar(40) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `countryId` (`countryId`)
) ENGINE=MyISAM AUTO_INCREMENT=571 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_iso_counties`
--

INSERT INTO `CubeCart_iso_counties` VALUES (1,226,'AL','Alabama'),(2,226,'AK','Alaska'),(3,226,'AS','American Samoa'),(4,226,'AZ','Arizona'),(5,226,'AR','Arkansas'),(6,226,'AF','Armed Forces Africa'),(7,226,'AA','Armed Forces Americas'),(8,226,'AC','Armed Forces Canada'),(9,226,'AE','Armed Forces Europe'),(10,226,'AM','Armed Forces Middle East'),(11,226,'AP','Armed Forces Pacific'),(12,226,'CA','California'),(13,226,'CO','Colorado'),(14,226,'CT','Connecticut'),(15,226,'DE','Delaware'),(16,226,'DC','District of Columbia'),(17,226,'FM','Federated States Of Micronesia'),(18,226,'FL','Florida'),(19,226,'GA','Georgia'),(20,226,'GU','Guam'),(21,226,'HI','Hawaii'),(22,226,'ID','Idaho'),(23,226,'IL','Illinois'),(24,226,'IN','Indiana'),(25,226,'IA','Iowa'),(26,226,'KS','Kansas'),(27,226,'KY','Kentucky'),(28,226,'LA','Louisiana'),(29,226,'ME','Maine'),(30,226,'MH','Marshall Islands'),(31,226,'MD','Maryland'),(32,226,'MA','Massachusetts'),(33,226,'MI','Michigan'),(34,226,'MN','Minnesota'),(35,226,'MS','Mississippi'),(36,226,'MO','Missouri'),(37,226,'MT','Montana'),(38,226,'NE','Nebraska'),(39,226,'NV','Nevada'),(40,226,'NH','New Hampshire'),(41,226,'NJ','New Jersey'),(42,226,'NM','New Mexico'),(43,226,'NY','New York'),(44,226,'NC','North Carolina'),(45,226,'ND','North Dakota'),(46,226,'MP','Northern Mariana Islands'),(47,226,'OH','Ohio'),(48,226,'OK','Oklahoma'),(49,226,'OR','Oregon'),(50,226,'PW','Palau'),(51,226,'PA','Pennsylvania'),(52,226,'PR','Puerto Rico'),(53,226,'RI','Rhode Island'),(54,226,'SC','South Carolina'),(55,226,'SD','South Dakota'),(56,226,'TN','Tennessee'),(57,226,'TX','Texas'),(58,226,'UT','Utah'),(59,226,'VT','Vermont'),(60,226,'VI','Virgin Islands'),(61,226,'VA','Virginia'),(62,226,'WA','Washington'),(63,226,'WV','West Virginia'),(64,226,'WI','Wisconsin'),(65,226,'WY','Wyoming'),(66,38,'AB','Alberta'),(67,38,'BC','British Columbia'),(68,38,'MB','Manitoba'),(69,38,'NL','Newfoundland'),(70,38,'NB','New Brunswick'),(71,38,'NS','Nova Scotia'),(72,38,'NT','Northwest Territories'),(73,38,'NU','Nunavut'),(74,38,'ON','Ontario'),(75,38,'PE','Prince Edward Island'),(76,38,'QC','Quebec'),(77,38,'SK','Saskatchewan'),(78,38,'YT','Yukon Territory'),(79,80,'NDS','Niedersachsen'),(80,80,'BAW','Baden-Württemberg'),(81,80,'BAY','Bayern'),(82,80,'BER','Berlin'),(83,80,'BRG','Brandenburg'),(84,80,'BRE','Bremen'),(85,80,'HAM','Hamburg'),(86,80,'HES','Hessen'),(87,80,'MEC','Mecklenburg-Vorpommern'),(88,80,'NRW','Nordrhein-Westfalen'),(89,80,'RHE','Rheinland-Pfalz'),(90,80,'SAR','Saarland'),(91,80,'SAS','Sachsen'),(92,80,'SAC','Sachsen-Anhalt'),(93,80,'SCN','Schleswig-Holstein'),(94,80,'THE','Thüringen'),(95,14,'WIE','Wien'),(96,14,'NO','NiederÖsterreich'),(97,14,'OO','OberÖsterreich'),(98,14,'SB','Salzburg'),(99,14,'KN','Kärnten'),(100,14,'ST','Steiermark'),(101,14,'TI','Tirol'),(102,14,'BL','Burgenland'),(103,14,'VB','Voralberg'),(104,206,'AG','Aargau'),(105,206,'AI','Appenzell Innerrhoden'),(106,206,'APP','Appenzell Ausserrhoden'),(107,206,'BE','Bern'),(108,206,'BLA','Basel-Landschaft'),(109,206,'BS','Basel-Stadt'),(110,206,'FR','Freiburg'),(111,206,'GE','Genf'),(112,206,'GL','Glarus'),(113,206,'JUB','Graubünden'),(114,206,'JU','Jura'),(115,206,'LU','Luzern'),(116,206,'NEU','Neuenburg'),(117,206,'NW','Nidwalden'),(118,206,'OW','Obwalden'),(119,206,'SG','St. Gallen'),(120,206,'SH','Schaffhausen'),(121,206,'SO','Solothurn'),(122,206,'SZ','Schwyz'),(123,206,'TG','Thurgau'),(124,206,'TE','Tessin'),(125,206,'UR','Uri'),(126,206,'VD','Waadt'),(127,206,'VS','Wallis'),(128,206,'ZG','Zug'),(129,206,'ZH','Zürich'),(130,199,'ACOR','A Coruña'),(131,199,'ALAV','Alava'),(132,199,'ALBA','Albacete'),(133,199,'ALIC','Alicante'),(134,199,'ALME','Almeria'),(135,199,'ASTU','Asturias'),(136,199,'AVIL','Avila'),(137,199,'BADA','Badajoz'),(138,199,'BALE','Baleares'),(139,199,'BARC','Barcelona'),(140,199,'BURG','Burgos'),(141,199,'CACE','Caceres'),(142,199,'CADI','Cadiz'),(143,199,'CANT','Cantabria'),(144,199,'CAST','Castellon'),(145,199,'CEUT','Ceuta'),(146,199,'CIUD','Ciudad Real'),(147,199,'CORD','Cordoba'),(148,199,'CUEN','Cuenca'),(149,199,'GIRO','Girona'),(150,199,'GRAN','Granada'),(151,199,'GUAD','Guadalajara'),(152,199,'GUIP','Guipuzcoa'),(153,199,'HUEL','Huelva'),(154,199,'HUES','Huesca'),(155,199,'JAEN','Jaen'),(156,199,'LAR','La Rioja'),(157,199,'LAS','Las Palmas'),(158,199,'LEON','Leon'),(159,199,'LLEI','Lleida'),(160,199,'LUGO','Lugo'),(161,199,'MADR','Madrid'),(162,199,'MALA','Malaga'),(163,199,'MELI','Melilla'),(164,199,'MURC','Murcia'),(165,199,'NAVA','Navarra'),(166,199,'OURE','Ourense'),(167,199,'PALE','Palencia'),(168,199,'PONT','Pontevedra'),(169,199,'SALA','Salamanca'),(170,199,'SANT','Santa Cruz de Tenerife'),(171,199,'SEGO','Segovia'),(172,199,'SEVI','Sevilla'),(173,199,'SORI','Soria'),(174,199,'TARR','Tarragona'),(175,199,'TERU','Teruel'),(176,199,'TOLE','Toledo'),(177,199,'VALE','Valencia'),(178,199,'VALL','Valladolid'),(179,199,'VIZC','Vizcaya'),(180,199,'ZAMO','Zamora'),(181,199,'ZARA','Zaragoza'),(415,103,'CW','Carlow'),(416,103,'CN','Cavan'),(417,103,'CE','Clare'),(418,103,'C','Cork'),(419,103,'DL','Donegal'),(420,103,'D','Dublin'),(421,103,'G','Galway'),(422,103,'KY','Kerry'),(423,103,'KE','Kildare'),(424,103,'KK','Kilkenny'),(425,103,'LS','Laoighis'),(426,103,'LM','Leitrim'),(427,103,'LK','Limerick'),(428,103,'LD','Longford'),(429,103,'LH','Louth'),(430,103,'MO','Mayo'),(431,103,'MH','Meath'),(432,103,'MN','Monaghan'),(433,103,'OY','Offaly'),(434,103,'RN','Roscommon'),(435,103,'SO','Sligo'),(436,103,'TA','Tipperary'),(437,103,'WD','Waterford'),(438,103,'WH','Westmeath'),(439,103,'WX','Wexford'),(440,103,'WW','Wicklow'),(441,225,'AVN','Avon'),(442,225,'BDF','Bedfordshire'),(443,225,'BRK','Berkshire'),(444,225,'BKM','Buckinghamshire'),(445,225,'CAM','Cambridgeshire'),(446,225,'CHS','Cheshire'),(447,225,'CLV','Cleveland'),(448,225,'CON','Cornwall'),(449,225,'CUL','Cumberland'),(450,225,'CMA','Cumbria'),(451,225,'DBY','Derbyshire'),(452,225,'DEV','Devon'),(453,225,'DOR','Dorset'),(454,225,'DUR','County Durham'),(455,225,'ESX','East Sussex'),(456,225,'ESS','Essex'),(457,225,'GLS','Gloucestershire'),(458,225,'HAM','Hampshire'),(459,225,'HWR','Hereford and Worcester'),(460,225,'HEF','Herefordshire'),(461,225,'HRT','Hertfordshire'),(462,225,'HUM','Humberside'),(463,225,'HUN','Huntingdonshire'),(464,225,'IOW','Isle of Wight'),(465,225,'KEN','Kent'),(466,225,'LAN','Lancashire'),(467,225,'LEI','Leicestershire'),(468,225,'LIN','Lincolnshire'),(469,225,'GTM','Greater Manchester'),(470,225,'GTL','Greater London'),(471,225,'MSY','Merseyside'),(472,225,'MDX','Middlesex'),(473,225,'NFK','Norfolk'),(474,225,'NTH','Northamptonshire'),(475,225,'NBL','Northumberland'),(476,225,'NTT','Nottinghamshire'),(477,225,'OXF','Oxfordshire'),(478,225,'RUT','Rutland'),(479,225,'SAL','Shropshire'),(480,225,'SOM','Somerset'),(481,225,'STS','Staffordshire'),(482,225,'SFK','Suffolk'),(483,225,'SRY','Surrey'),(484,225,'SSX','Sussex'),(485,225,'TWR','Tyne and Wear'),(486,225,'WAR','Warwickshire'),(487,225,'WMD','West Midlands'),(488,225,'WES','Westmorland'),(489,225,'WIL','Wiltshire'),(490,225,'WOR','Worcestershire'),(491,225,'YOK','Yorkshire'),(492,225,'ABD','Aberdeenshire'),(493,225,'ANS','Angus'),(494,225,'ARL','Argyll'),(495,225,'AYR','Ayrshire'),(496,225,'BAN','Banffshire'),(497,225,'BEW','Berwickshire'),(498,225,'BUT','Bute'),(499,225,'CAI','Caithness'),(500,225,'CLK','Clackmannanshire'),(501,225,'CRO','Cromartyshire'),(502,225,'DFS','Dumfriesshire'),(503,225,'DNB','Dunbartonshire'),(504,225,'ELN','East Lothian'),(505,225,'FIF','Fife'),(506,225,'INV','Inverness-shire'),(507,225,'KRS','Kinross-shire'),(508,225,'KKD','Kirkcudbrightshire'),(509,225,'LAN','Lanarkshire'),(510,225,'MLN','Midlothian'),(511,225,'MOR','Moray'),(512,225,'NAI','Nairnshire'),(513,225,'OKI','Orkney'),(514,225,'PEE','Peeblesshire'),(515,225,'PER','Perthshire'),(516,225,'RFW','Renfrewshire'),(517,225,'ROC','Ross'),(518,225,'ROX','Roxburghshire'),(519,225,'SEL','Selkirkshire'),(520,225,'SHI','Shetland'),(521,225,'STI','Stirlingshire'),(522,225,'SUT','Sutherland'),(523,225,'WLN','West Lothian'),(524,225,'WIG','Wigtownshire'),(525,225,'AGY','Anglesey'),(526,225,'BRN','Brecknockshire'),(527,225,'CAE','Caernarfonshire'),(528,225,'CAD','Cardiganshire'),(529,225,'CRR','Carmarthenshire'),(530,225,'CLW','Clwyd'),(531,225,'DEN','Denbighshire'),(532,225,'DFD','Dyfed'),(533,225,'FLN','Flintshire'),(534,225,'GLA','Glamorgan'),(535,225,'GNT','Gwent'),(536,225,'GWN','Gwynedd'),(537,225,'MER','Merionethshire'),(538,225,'MON','Monmouthshire'),(539,225,'MGY','Montgomeryshire'),(540,225,'PEM','Pembrokeshire'),(541,225,'POW','Powys'),(542,225,'RAD','Radnorshire'),(543,225,'ANT','Antrim'),(544,225,'ARM','Armagh'),(545,225,'LDY','Londonderry'),(546,225,'DOW','Down'),(547,225,'FER','Fermanagh'),(548,225,'TYR','Tyrone'),(549,225,'JEY','Guernsey'),(550,225,'GGY','Channel Islands'),(551,150,'DR','Drenthe'),(552,150,'FL','Flevoland'),(553,150,'FR','Friesland'),(554,150,'GLD','Gelderland'),(555,150,'GR','Groningen'),(556,150,'LI','Limburg'),(557,150,'NB','Noord-Brabant'),(558,150,'NH','Noord-Holland'),(559,150,'OV','Overijssel'),(560,150,'UT','Utrecht'),(561,150,'ZL','Zeeland'),(562,150,'ZH','Zuid-Holland'),(563,13,'ACT','Australian Capital Territory'),(564,13,'NSW','New South Wales'),(565,13,'NT','Northern Territory'),(566,13,'QLD','Queensland'),(567,13,'SA','South Australia'),(568,13,'TAS','Tasmania'),(569,13,'VIC','Victoria'),(570,13,'WA','Western Australia');

--
-- Table structure for table `CubeCart_iso_countries`
--

CREATE TABLE `CubeCart_iso_countries` (
  `id` int(11) NOT NULL auto_increment,
  `iso` varchar(2) collate utf8_unicode_ci NOT NULL default '',
  `printable_name` varchar(80) collate utf8_unicode_ci NOT NULL default '',
  `iso3` varchar(3) collate utf8_unicode_ci default NULL,
  `numcode` smallint(6) default NULL,
  PRIMARY KEY  (`iso`),
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=241 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_iso_countries`
--

INSERT INTO `CubeCart_iso_countries` VALUES (1,'AF','Afghanistan','AFG',4),(2,'AL','Albania','ALB',8),(3,'DZ','Algeria','DZA',12),(4,'AS','American Samoa','ASM',16),(5,'AD','Andorra','AND',20),(6,'AO','Angola','AGO',24),(7,'AI','Anguilla','AIA',660),(8,'AQ','Antarctica','ATA',10),(9,'AG','Antigua and Barbuda','ATG',28),(10,'AR','Argentina','ARG',32),(11,'AM','Armenia','ARM',51),(12,'AW','Aruba','ABW',533),(13,'AU','Australia','AUS',36),(14,'AT','Austria','AUT',40),(15,'AZ','Azerbaijan','AZE',31),(16,'BS','Bahamas','BHS',44),(17,'BH','Bahrain','BHR',48),(18,'BD','Bangladesh','BGD',50),(19,'BB','Barbados','BRB',52),(20,'BY','Belarus','BLR',112),(21,'BE','Belgium','BEL',56),(22,'BZ','Belize','BLZ',84),(23,'BJ','Benin','BEN',204),(24,'BM','Bermuda','BMU',60),(25,'BT','Bhutan','BTN',64),(26,'BO','Bolivia','BOL',68),(27,'BA','Bosnia and Herzegovina','BIH',70),(28,'BW','Botswana','BWA',72),(29,'BV','Bouvet Island',NULL,NULL),(30,'BR','Brazil','BRA',76),(31,'IO','British Indian Ocean Territory',NULL,NULL),(32,'BN','Brunei Darussalam','BRN',96),(33,'BG','Bulgaria','BGR',100),(34,'BF','Burkina Faso','BFA',854),(35,'BI','Burundi','BDI',108),(36,'KH','Cambodia','KHM',116),(37,'CM','Cameroon','CMR',120),(38,'CA','Canada','CAN',124),(39,'CV','Cape Verde','CPV',132),(40,'KY','Cayman Islands','CYM',136),(41,'CF','Central African Republic','CAF',140),(42,'TD','Chad','TCD',148),(43,'CL','Chile','CHL',152),(44,'CN','China','CHN',156),(45,'CX','Christmas Island',NULL,NULL),(46,'CC','Cocos (Keeling) Islands',NULL,NULL),(47,'CO','Colombia','COL',170),(48,'KM','Comoros','COM',174),(49,'CG','Congo','COG',178),(50,'CD','Congo, the Democratic Republic of the','COD',180),(51,'CK','Cook Islands','COK',184),(52,'CR','Costa Rica','CRI',188),(53,'CI','Cote D\'Ivoire','CIV',384),(54,'HR','Croatia','HRV',191),(55,'CU','Cuba','CUB',192),(56,'CY','Cyprus','CYP',196),(57,'CZ','Czech Republic','CZE',203),(58,'DK','Denmark','DNK',208),(59,'DJ','Djibouti','DJI',262),(60,'DM','Dominica','DMA',212),(61,'DO','Dominican Republic','DOM',214),(62,'EC','Ecuador','ECU',218),(63,'EG','Egypt','EGY',818),(64,'SV','El Salvador','SLV',222),(65,'GQ','Equatorial Guinea','GNQ',226),(66,'ER','Eritrea','ERI',232),(67,'EE','Estonia','EST',233),(68,'ET','Ethiopia','ETH',231),(69,'FK','Falkland Islands (Malvinas)','FLK',238),(70,'FO','Faroe Islands','FRO',234),(71,'FJ','Fiji','FJI',242),(72,'FI','Finland','FIN',246),(73,'FR','France','FRA',250),(74,'GF','French Guiana','GUF',254),(75,'PF','French Polynesia','PYF',258),(76,'TF','French Southern Territories',NULL,NULL),(77,'GA','Gabon','GAB',266),(78,'GM','Gambia','GMB',270),(79,'GE','Georgia','GEO',268),(80,'DE','Germany','DEU',276),(81,'GH','Ghana','GHA',288),(82,'GI','Gibraltar','GIB',292),(83,'GR','Greece','GRC',300),(84,'GL','Greenland','GRL',304),(85,'GD','Grenada','GRD',308),(86,'GP','Guadeloupe','GLP',312),(87,'GU','Guam','GUM',316),(88,'GT','Guatemala','GTM',320),(89,'GN','Guinea','GIN',324),(90,'GW','Guinea-Bissau','GNB',624),(91,'GY','Guyana','GUY',328),(92,'HT','Haiti','HTI',332),(93,'HM','Heard Island and Mcdonald Islands',NULL,NULL),(94,'VA','Holy See (Vatican City State)','VAT',336),(95,'HN','Honduras','HND',340),(96,'HK','Hong Kong','HKG',344),(97,'HU','Hungary','HUN',348),(98,'IS','Iceland','ISL',352),(99,'IN','India','IND',356),(100,'ID','Indonesia','IDN',360),(101,'IR','Iran, Islamic Republic of','IRN',364),(102,'IQ','Iraq','IRQ',368),(103,'IE','Ireland','IRL',372),(104,'IL','Israel','ISR',376),(105,'IT','Italy','ITA',380),(106,'JM','Jamaica','JAM',388),(107,'JP','Japan','JPN',392),(108,'JO','Jordan','JOR',400),(109,'KZ','Kazakhstan','KAZ',398),(110,'KE','Kenya','KEN',404),(111,'KI','Kiribati','KIR',296),(112,'KP','Korea, Democratic People\'s Republic of','PRK',408),(113,'KR','Korea, Republic of','KOR',410),(114,'KW','Kuwait','KWT',414),(115,'KG','Kyrgyzstan','KGZ',417),(116,'LA','Lao People\'s Democratic Republic','LAO',418),(117,'LV','Latvia','LVA',428),(118,'LB','Lebanon','LBN',422),(119,'LS','Lesotho','LSO',426),(120,'LR','Liberia','LBR',430),(121,'LY','Libyan Arab Jamahiriya','LBY',434),(122,'LI','Liechtenstein','LIE',438),(123,'LT','Lithuania','LTU',440),(124,'LU','Luxembourg','LUX',442),(125,'MO','Macao','MAC',446),(126,'MK','Macedonia, the Former Yugoslav Republic of','MKD',807),(127,'MG','Madagascar','MDG',450),(128,'MW','Malawi','MWI',454),(129,'MY','Malaysia','MYS',458),(130,'MV','Maldives','MDV',462),(131,'ML','Mali','MLI',466),(132,'MT','Malta','MLT',470),(133,'MH','Marshall Islands','MHL',584),(134,'MQ','Martinique','MTQ',474),(135,'MR','Mauritania','MRT',478),(136,'MU','Mauritius','MUS',480),(137,'YT','Mayotte',NULL,NULL),(138,'MX','Mexico','MEX',484),(139,'FM','Micronesia, Federated States of','FSM',583),(140,'MD','Moldova, Republic of','MDA',498),(141,'MC','Monaco','MCO',492),(142,'MN','Mongolia','MNG',496),(143,'MS','Montserrat','MSR',500),(144,'MA','Morocco','MAR',504),(145,'MZ','Mozambique','MOZ',508),(146,'MM','Myanmar','MMR',104),(147,'NA','Namibia','NAM',516),(148,'NR','Nauru','NRU',520),(149,'NP','Nepal','NPL',524),(150,'NL','Netherlands','NLD',528),(151,'AN','Netherlands Antilles','ANT',530),(152,'NC','New Caledonia','NCL',540),(153,'NZ','New Zealand','NZL',554),(154,'NI','Nicaragua','NIC',558),(155,'NE','Niger','NER',562),(156,'NG','Nigeria','NGA',566),(157,'NU','Niue','NIU',570),(158,'NF','Norfolk Island','NFK',574),(159,'MP','Northern Mariana Islands','MNP',580),(160,'NO','Norway','NOR',578),(161,'OM','Oman','OMN',512),(162,'PK','Pakistan','PAK',586),(163,'PW','Palau','PLW',585),(164,'PS','Palestinian Territory, Occupied',NULL,NULL),(165,'PA','Panama','PAN',591),(166,'PG','Papua New Guinea','PNG',598),(167,'PY','Paraguay','PRY',600),(168,'PE','Peru','PER',604),(169,'PH','Philippines','PHL',608),(170,'PN','Pitcairn','PCN',612),(171,'PL','Poland','POL',616),(172,'PT','Portugal','PRT',620),(173,'PR','Puerto Rico','PRI',630),(174,'QA','Qatar','QAT',634),(175,'RE','Reunion','REU',638),(176,'RO','Romania','ROM',642),(177,'RU','Russian Federation','RUS',643),(178,'RW','Rwanda','RWA',646),(179,'SH','Saint Helena','SHN',654),(180,'KN','Saint Kitts and Nevis','KNA',659),(181,'LC','Saint Lucia','LCA',662),(182,'PM','Saint Pierre and Miquelon','SPM',666),(183,'VC','Saint Vincent and the Grenadines','VCT',670),(184,'WS','Samoa','WSM',882),(185,'SM','San Marino','SMR',674),(186,'ST','Sao Tome and Principe','STP',678),(187,'SA','Saudi Arabia','SAU',682),(188,'SN','Senegal','SEN',686),(189,'RS','Serbia',NULL,NULL),(190,'SC','Seychelles','SYC',690),(191,'SL','Sierra Leone','SLE',694),(192,'SG','Singapore','SGP',702),(193,'SK','Slovakia','SVK',703),(194,'SI','Slovenia','SVN',705),(195,'SB','Solomon Islands','SLB',90),(196,'SO','Somalia','SOM',706),(197,'ZA','South Africa','ZAF',710),(198,'GS','South Georgia and the South Sandwich Islands',NULL,NULL),(199,'ES','Spain','ESP',724),(200,'LK','Sri Lanka','LKA',144),(201,'SD','Sudan','SDN',736),(202,'SR','Suriname','SUR',740),(203,'SJ','Svalbard and Jan Mayen','SJM',744),(204,'SZ','Swaziland','SWZ',748),(205,'SE','Sweden','SWE',752),(206,'CH','Switzerland','CHE',756),(207,'SY','Syrian Arab Republic','SYR',760),(208,'TW','Taiwan','TWN',158),(209,'TJ','Tajikistan','TJK',762),(210,'TZ','Tanzania, United Republic of','TZA',834),(211,'TH','Thailand','THA',764),(212,'TL','Timor-Leste',NULL,NULL),(213,'TG','Togo','TGO',768),(214,'TK','Tokelau','TKL',772),(215,'TO','Tonga','TON',776),(216,'TT','Trinidad and Tobago','TTO',780),(217,'TN','Tunisia','TUN',788),(218,'TR','Turkey','TUR',792),(219,'TM','Turkmenistan','TKM',795),(220,'TC','Turks and Caicos Islands','TCA',796),(221,'TV','Tuvalu','TUV',798),(222,'UG','Uganda','UGA',800),(223,'UA','Ukraine','UKR',804),(224,'AE','United Arab Emirates','ARE',784),(225,'GB','United Kingdom','GBR',826),(226,'US','United States','USA',840),(227,'UM','United States Minor Outlying Islands',NULL,NULL),(228,'UY','Uruguay','URY',858),(229,'UZ','Uzbekistan','UZB',860),(230,'VU','Vanuatu','VUT',548),(231,'VE','Venezuela','VEN',862),(232,'VN','Viet Nam','VNM',704),(233,'VG','Virgin Islands, British','VGB',92),(234,'VI','Virgin Islands, U.s.','VIR',850),(235,'WF','Wallis and Futuna','WLF',876),(236,'EH','Western Sahara','ESH',732),(237,'YE','Yemen','YEM',887),(238,'ZM','Zambia','ZMB',894),(239,'ZW','Zimbabwe','ZWE',716),(240,'ME','Montenegro',NULL,NULL);

--
-- Table structure for table `CubeCart_lang`
--

CREATE TABLE `CubeCart_lang` (
  `identifier` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `langArray` longtext collate utf8_unicode_ci NOT NULL,
  UNIQUE KEY `identifier` (`identifier`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_lang`
--

INSERT INTO `CubeCart_lang` VALUES ('/en/home.inc.php','a:6:{s:7:\"enabled\";s:1:\"1\";s:5:\"title\";s:0:\"\";s:4:\"copy\";s:699:\"<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<h2 style=\"text-align: center\"><span style=\"background-color: #ffffff\"><span style=\"color: #ff0000\">Imprinted Sportswear and Embroidery</span></span></h2>\r\n<h4 style=\"text-align: center\"><span style=\"color: #000000\"><span style=\"background-color: #ffffff\">109 E. Main St.</span><br />\r\n<span style=\"background-color: #ffffff\">Belle Center, OH 43310</span></span><br />\r\n<span style=\"color: #000000\"><span style=\"background-color: #ffffff\">(937) 464-5674&nbsp;&nbsp;&nbsp; (fax) 464-4808</span></span></h4>\r\n<h5 style=\"text-align: center\"><a href=\"mailto:tlgraph@earthlink.net\"><span style=\"background-color: #ffffff\">tlgraph@earthlink.net</span></a></h5>\r\n<p>&nbsp;</p>\";s:13:\"doc_metatitle\";N;s:12:\"doc_metadesc\";N;s:16:\"doc_metakeywords\";N;}');

--
-- Table structure for table `CubeCart_options_bot`
--

CREATE TABLE `CubeCart_options_bot` (
  `assign_id` int(32) NOT NULL auto_increment,
  `product` int(11) NOT NULL default '0',
  `option_id` int(32) NOT NULL default '0',
  `value_id` int(32) NOT NULL default '0',
  `option_price` decimal(30,2) NOT NULL default '0.00',
  `option_symbol` char(1) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`assign_id`),
  KEY `product` (`product`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_options_bot`
--


--
-- Table structure for table `CubeCart_options_mid`
--

CREATE TABLE `CubeCart_options_mid` (
  `value_id` int(16) NOT NULL auto_increment,
  `value_name` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `father_id` int(16) NOT NULL default '0',
  PRIMARY KEY  (`value_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_options_mid`
--


--
-- Table structure for table `CubeCart_options_top`
--

CREATE TABLE `CubeCart_options_top` (
  `option_id` int(16) NOT NULL auto_increment,
  `option_name` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `option_type` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`option_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_options_top`
--


--
-- Table structure for table `CubeCart_order_inv`
--

CREATE TABLE `CubeCart_order_inv` (
  `productId` int(11) NOT NULL default '0',
  `productCode` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `name` varchar(225) collate utf8_unicode_ci NOT NULL default '',
  `quantity` smallint(4) NOT NULL default '0',
  `price` decimal(30,2) NOT NULL default '0.00',
  `cart_order_id` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `id` int(32) NOT NULL auto_increment,
  `product_options` text collate utf8_unicode_ci NOT NULL,
  `digital` smallint(1) NOT NULL default '0',
  `stockUpdated` int(11) NOT NULL default '0',
  `custom` text collate utf8_unicode_ci NOT NULL,
  `couponId` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `productId` (`productId`),
  KEY `cart_order_id` (`cart_order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_order_inv`
--

INSERT INTO `CubeCart_order_inv` VALUES (3,'WOVJ55GW6','Woven Jacket',1,'29.95','100608-110617-9577',1,'',0,0,'',0),(12,'REDOCA892','Red Short Sleeve',1,'19.95','100610-131332-5461',2,'',0,0,'',0),(12,'REDOCA892','Red Short Sleeve',1,'19.95','100615-102301-4595',3,'',0,0,'',0),(11,'RUNP1QM12','RunTone Action - Men',1,'59.95','100615-102301-4595',4,'',0,0,'',0),(12,'REDOCA892','Red Short Sleeve',5,'19.95','100615-102302-3620',5,'',0,0,'',0),(11,'RUNP1QM12','RunTone Action - Men',1,'59.95','100615-102302-3620',6,'',0,0,'',0);

--
-- Table structure for table `CubeCart_order_sum`
--

CREATE TABLE `CubeCart_order_sum` (
  `cart_order_id` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `customer_id` int(11) NOT NULL default '0',
  `name` varchar(225) collate utf8_unicode_ci default NULL,
  `add_1` varchar(225) collate utf8_unicode_ci default NULL,
  `add_2` varchar(225) collate utf8_unicode_ci default NULL,
  `town` varchar(225) collate utf8_unicode_ci default NULL,
  `county` varchar(225) collate utf8_unicode_ci default NULL,
  `postcode` varchar(225) collate utf8_unicode_ci default NULL,
  `country` varchar(225) collate utf8_unicode_ci default NULL,
  `name_d` varchar(225) collate utf8_unicode_ci default NULL,
  `add_1_d` varchar(225) collate utf8_unicode_ci default NULL,
  `add_2_d` varchar(225) collate utf8_unicode_ci default NULL,
  `town_d` varchar(225) collate utf8_unicode_ci default NULL,
  `county_d` varchar(225) collate utf8_unicode_ci default NULL,
  `postcode_d` varchar(225) collate utf8_unicode_ci default NULL,
  `country_d` varchar(225) collate utf8_unicode_ci default NULL,
  `phone` varchar(225) collate utf8_unicode_ci default NULL,
  `mobile` varchar(255) collate utf8_unicode_ci default NULL,
  `subtotal` decimal(30,2) NOT NULL default '0.00',
  `discount` decimal(30,2) NOT NULL default '0.00',
  `prod_total` decimal(30,2) NOT NULL default '0.00',
  `total_tax` decimal(30,2) NOT NULL default '0.00',
  `total_ship` decimal(30,2) NOT NULL default '0.00',
  `status` int(16) NOT NULL default '1',
  `sec_order_id` varchar(30) collate utf8_unicode_ci default NULL,
  `ip` varchar(45) collate utf8_unicode_ci NOT NULL default '0.0.0.0',
  `time` int(10) NOT NULL default '0',
  `email` varchar(254) collate utf8_unicode_ci NOT NULL default '',
  `comments` text collate utf8_unicode_ci,
  `ship_date` varchar(50) collate utf8_unicode_ci default NULL,
  `shipMethod` varchar(255) collate utf8_unicode_ci default NULL,
  `gateway` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `currency` varchar(5) collate utf8_unicode_ci NOT NULL default '',
  `customer_comments` text collate utf8_unicode_ci,
  `extra_notes` text collate utf8_unicode_ci NOT NULL,
  `tax1_disp` varchar(128) collate utf8_unicode_ci default NULL,
  `tax1_amt` decimal(30,2) NOT NULL default '0.00',
  `tax2_disp` varchar(128) collate utf8_unicode_ci default NULL,
  `tax2_amt` decimal(30,2) NOT NULL default '0.00',
  `tax3_disp` varchar(128) collate utf8_unicode_ci default NULL,
  `tax3_amt` decimal(30,2) NOT NULL default '0.00',
  `offline_capture` blob,
  `courier_tracking` text collate utf8_unicode_ci,
  `companyName` varchar(150) collate utf8_unicode_ci default NULL,
  `companyName_d` varchar(150) collate utf8_unicode_ci default NULL,
  `basket` text collate utf8_unicode_ci,
  `lang` varchar(2) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`cart_order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_order_sum`
--

INSERT INTO `CubeCart_order_sum` VALUES ('100608-110617-9577',1,'chris dillon','133 w columbus ave','','bellefontaine','Ohio','43311','United States','chris dillon','133 w columbus ave','','bellefontaine','Ohio','43311','United States','937-592-0299','','26.95','2.99','28.98','2.02','0.00',1,NULL,'71.0.203.162',1276013177,'doughboy@computer-assist.com','Voucher: bl',NULL,'Free Shipping','PayPal','',NULL,'','','0.00','','0.00','','0.00',NULL,NULL,'','','a:14:{s:5:\"conts\";a:1:{s:4:\"3{:}\";a:2:{s:8:\"quantity\";d:1;s:9:\"timestamp\";i:1276012985;}}s:10:\"codeResult\";i:0;s:4:\"code\";s:2:\"bl\";s:16:\"discount_percent\";s:5:\"10.00\";s:14:\"discount_price\";s:4:\"0.00\";s:8:\"invArray\";a:1:{i:1;a:7:{s:9:\"productId\";s:1:\"3\";s:4:\"name\";s:12:\"Woven Jacket\";s:11:\"productCode\";s:9:\"WOVJ55GW6\";s:11:\"prodOptions\";s:0:\"\";s:5:\"price\";s:5:\"29.95\";s:8:\"quantity\";d:1;s:7:\"digital\";s:1:\"0\";}}s:6:\"delInf\";a:10:{s:5:\"title\";s:0:\"\";s:9:\"firstName\";s:5:\"chris\";s:8:\"lastName\";s:6:\"dillon\";s:11:\"companyName\";s:0:\"\";s:5:\"add_1\";s:18:\"133 w columbus ave\";s:5:\"add_2\";s:0:\"\";s:4:\"town\";s:13:\"bellefontaine\";s:6:\"county\";s:4:\"Ohio\";s:8:\"postcode\";s:5:\"43311\";s:7:\"country\";s:3:\"226\";}s:7:\"shipKey\";i:1;s:10:\"shipMethod\";s:13:\"Free Shipping\";s:8:\"shipCost\";s:4:\"0.00\";s:8:\"discount\";d:2.99500000000000010658141036401502788066864013671875;s:8:\"subTotal\";s:5:\"26.95\";s:3:\"tax\";s:4:\"2.02\";s:10:\"grandTotal\";s:5:\"28.98\";}','en'),('100610-131332-5461',2,'chris dillon','133 w columbus ave','','bellefontaine','ohio','43311','United States','chris dillon','133 w columbus ave','','bellefontaine','ohio','43311','United States','937-592-0299','','19.95','0.00','21.45','1.50','0.00',1,NULL,'71.0.203.162',1276193612,'cdillon@computer-assist.com',NULL,NULL,'Free Shipping','Print_Order_Form','',NULL,'','','0.00','','0.00','','0.00',NULL,NULL,'','','a:10:{s:5:\"conts\";a:1:{s:5:\"12{:}\";a:2:{s:8:\"quantity\";d:1;s:9:\"timestamp\";i:1276192818;}}s:8:\"invArray\";a:1:{i:1;a:7:{s:9:\"productId\";s:2:\"12\";s:4:\"name\";s:16:\"Red Short Sleeve\";s:11:\"productCode\";s:9:\"REDOCA892\";s:11:\"prodOptions\";s:0:\"\";s:5:\"price\";s:5:\"19.95\";s:8:\"quantity\";d:1;s:7:\"digital\";s:1:\"0\";}}s:6:\"delInf\";a:10:{s:5:\"title\";s:0:\"\";s:9:\"firstName\";s:5:\"chris\";s:8:\"lastName\";s:6:\"dillon\";s:11:\"companyName\";s:0:\"\";s:5:\"add_1\";s:18:\"133 w columbus ave\";s:5:\"add_2\";s:0:\"\";s:4:\"town\";s:13:\"bellefontaine\";s:6:\"county\";s:4:\"ohio\";s:8:\"postcode\";s:5:\"43311\";s:7:\"country\";s:3:\"226\";}s:7:\"shipKey\";i:1;s:10:\"shipMethod\";s:13:\"Free Shipping\";s:8:\"shipCost\";s:4:\"0.00\";s:8:\"discount\";s:0:\"\";s:8:\"subTotal\";s:5:\"19.95\";s:3:\"tax\";s:4:\"1.50\";s:10:\"grandTotal\";s:5:\"21.45\";}','en'),('100615-102301-4595',3,'christopher dillon','133 w columbus ave','','bellefontaine','Ohio','43311','United States','christopher dillon','133 w columbus ave','','bellefontaine','Ohio','43311','United States','937-592-0299','','79.90','0.00','85.89','5.99','0.00',1,NULL,'74.5.27.178',1276615381,'cdillon1@computer-assist.com',NULL,NULL,'Free Shipping','Undefined','',NULL,'','','0.00','','0.00','','0.00',NULL,NULL,'','','a:10:{s:5:\"conts\";a:2:{s:5:\"12{:}\";a:2:{s:8:\"quantity\";d:1;s:9:\"timestamp\";i:1276615217;}s:5:\"11{:}\";a:2:{s:8:\"quantity\";d:1;s:9:\"timestamp\";i:1276615240;}}s:8:\"invArray\";a:2:{i:1;a:7:{s:9:\"productId\";s:2:\"12\";s:4:\"name\";s:16:\"Red Short Sleeve\";s:11:\"productCode\";s:9:\"REDOCA892\";s:11:\"prodOptions\";s:0:\"\";s:5:\"price\";s:5:\"19.95\";s:8:\"quantity\";d:1;s:7:\"digital\";s:1:\"0\";}i:2;a:7:{s:9:\"productId\";s:2:\"11\";s:4:\"name\";s:20:\"RunTone Action - Men\";s:11:\"productCode\";s:9:\"RUNP1QM12\";s:11:\"prodOptions\";s:0:\"\";s:5:\"price\";s:5:\"59.95\";s:8:\"quantity\";d:1;s:7:\"digital\";s:1:\"0\";}}s:6:\"delInf\";a:10:{s:5:\"title\";s:0:\"\";s:9:\"firstName\";s:11:\"christopher\";s:8:\"lastName\";s:6:\"dillon\";s:11:\"companyName\";s:0:\"\";s:5:\"add_1\";s:18:\"133 w columbus ave\";s:5:\"add_2\";s:0:\"\";s:4:\"town\";s:13:\"bellefontaine\";s:6:\"county\";s:4:\"Ohio\";s:8:\"postcode\";s:5:\"43311\";s:7:\"country\";s:3:\"226\";}s:7:\"shipKey\";i:1;s:10:\"shipMethod\";s:13:\"Free Shipping\";s:8:\"shipCost\";s:4:\"0.00\";s:8:\"discount\";s:0:\"\";s:8:\"subTotal\";s:5:\"79.90\";s:3:\"tax\";s:4:\"5.99\";s:10:\"grandTotal\";s:5:\"85.89\";}','en'),('100615-102302-3620',3,'christopher dillon','133 w columbus ave','','bellefontaine','Ohio','43311','United States','christopher dillon','133 w columbus ave','','bellefontaine','Ohio','43311','United States','937-592-0299','','79.90','0.00','85.89','5.99','0.00',1,NULL,'74.5.27.178',1276615382,'cdillon1@computer-assist.com','','','Free Shipping','Print Order Form','','','','','0.00','','0.00','','0.00',NULL,'','','','a:10:{s:5:\"conts\";a:2:{s:5:\"12{:}\";a:2:{s:8:\"quantity\";d:1;s:9:\"timestamp\";i:1276615217;}s:5:\"11{:}\";a:2:{s:8:\"quantity\";d:1;s:9:\"timestamp\";i:1276615240;}}s:8:\"invArray\";a:2:{i:1;a:7:{s:9:\"productId\";s:2:\"12\";s:4:\"name\";s:16:\"Red Short Sleeve\";s:11:\"productCode\";s:9:\"REDOCA892\";s:11:\"prodOptions\";s:0:\"\";s:5:\"price\";s:5:\"19.95\";s:8:\"quantity\";d:1;s:7:\"digital\";s:1:\"0\";}i:2;a:7:{s:9:\"productId\";s:2:\"11\";s:4:\"name\";s:20:\"RunTone Action - Men\";s:11:\"productCode\";s:9:\"RUNP1QM12\";s:11:\"prodOptions\";s:0:\"\";s:5:\"price\";s:5:\"59.95\";s:8:\"quantity\";d:1;s:7:\"digital\";s:1:\"0\";}}s:6:\"delInf\";a:10:{s:5:\"title\";s:0:\"\";s:9:\"firstName\";s:11:\"christopher\";s:8:\"lastName\";s:6:\"dillon\";s:11:\"companyName\";s:0:\"\";s:5:\"add_1\";s:18:\"133 w columbus ave\";s:5:\"add_2\";s:0:\"\";s:4:\"town\";s:13:\"bellefontaine\";s:6:\"county\";s:4:\"Ohio\";s:8:\"postcode\";s:5:\"43311\";s:7:\"country\";s:3:\"226\";}s:7:\"shipKey\";i:1;s:10:\"shipMethod\";s:13:\"Free Shipping\";s:8:\"shipCost\";s:4:\"0.00\";s:8:\"discount\";s:0:\"\";s:8:\"subTotal\";s:5:\"79.90\";s:3:\"tax\";s:4:\"5.99\";s:10:\"grandTotal\";s:5:\"85.89\";}','en');

--
-- Table structure for table `CubeCart_reviews`
--

CREATE TABLE `CubeCart_reviews` (
  `id` int(11) NOT NULL auto_increment,
  `approved` smallint(1) NOT NULL default '0',
  `productId` int(11) NOT NULL default '0',
  `type` smallint(1) NOT NULL default '0',
  `rating` smallint(1) NOT NULL default '0',
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `email` varchar(254) collate utf8_unicode_ci NOT NULL default '',
  `title` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `review` text collate utf8_unicode_ci NOT NULL,
  `ip` varchar(45) collate utf8_unicode_ci NOT NULL default '',
  `time` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_reviews`
--


--
-- Table structure for table `CubeCart_search`
--

CREATE TABLE `CubeCart_search` (
  `searchstr` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `hits` bigint(64) NOT NULL default '0',
  `id` bigint(64) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_search`
--


--
-- Table structure for table `CubeCart_sessions`
--

CREATE TABLE `CubeCart_sessions` (
  `sessId` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `basket` text collate utf8_unicode_ci,
  `timeStart` int(11) NOT NULL default '0',
  `timeLast` int(11) NOT NULL default '0',
  `customer_id` int(11) NOT NULL default '0',
  `location` varchar(255) collate utf8_unicode_ci default NULL,
  `lang` varchar(20) collate utf8_unicode_ci default NULL,
  `currency` varchar(3) collate utf8_unicode_ci default NULL,
  `skin` varchar(25) collate utf8_unicode_ci default NULL,
  `ip` varchar(45) collate utf8_unicode_ci default NULL,
  `browser` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`sessId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_sessions`
--

INSERT INTO `CubeCart_sessions` VALUES ('2279bfa5d36fbf76d7e38eea919ea4da','N;',1276615159,1276621296,3,'/tandl/index.php?_a=viewProd&amp;productId=14',NULL,NULL,NULL,'74.5.27.178','Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3'),('02477169ab7be507fe382e7b5e9a6c82','a:7:{s:5:\"conts\";a:1:{s:5:\"13{:}\";a:2:{s:8:\"quantity\";d:1;s:9:\"timestamp\";i:1276627351;}}s:8:\"invArray\";a:1:{i:1;a:7:{s:9:\"productId\";s:2:\"13\";s:4:\"name\";s:12:\"Woven Jacket\";s:11:\"productCode\";s:9:\"WOVUVQ4A9\";s:11:\"prodOptions\";s:0:\"\";s:5:\"price\";s:5:\"29.95\";s:8:\"quantity\";d:1;s:7:\"digital\";s:1:\"0\";}}s:8:\"shipCost\";d:0;s:8:\"discount\";s:0:\"\";s:8:\"subTotal\";s:5:\"29.95\";s:3:\"tax\";s:4:\"2.25\";s:10:\"grandTotal\";s:5:\"32.20\";}',1276627312,1276627627,0,'/tandl/index.php',NULL,NULL,NULL,'76.6.224.231','Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB6.5; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)');

--
-- Table structure for table `CubeCart_tax_details`
--

CREATE TABLE `CubeCart_tax_details` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(128) collate utf8_unicode_ci NOT NULL default '',
  `display` varchar(128) collate utf8_unicode_ci NOT NULL default '',
  `reg_number` varchar(128) collate utf8_unicode_ci NOT NULL default '',
  `status` smallint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_tax_details`
--


--
-- Table structure for table `CubeCart_tax_rates`
--

CREATE TABLE `CubeCart_tax_rates` (
  `id` int(11) NOT NULL auto_increment,
  `type_id` int(11) NOT NULL default '1',
  `details_id` int(11) NOT NULL default '0',
  `country_id` int(11) NOT NULL default '0',
  `county_id` int(11) NOT NULL default '0',
  `tax_percent` decimal(7,4) NOT NULL default '0.0000',
  `goods` int(11) NOT NULL default '0',
  `shipping` int(11) NOT NULL default '0',
  `active` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `type_id` (`type_id`,`details_id`,`country_id`,`county_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_tax_rates`
--


--
-- Table structure for table `CubeCart_taxes`
--

CREATE TABLE `CubeCart_taxes` (
  `id` int(11) NOT NULL auto_increment,
  `taxName` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `percent` decimal(7,4) NOT NULL default '0.0000',
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_taxes`
--

INSERT INTO `CubeCart_taxes` VALUES (1,'Standard Tax','7.5000'),(2,'Tax Exempt','0.0000');

--
-- Table structure for table `CubeCart_transactions`
--

CREATE TABLE `CubeCart_transactions` (
  `id` int(11) NOT NULL auto_increment,
  `gateway` varchar(255) collate utf8_unicode_ci default NULL,
  `extra` varchar(255) collate utf8_unicode_ci default NULL,
  `status` varchar(50) collate utf8_unicode_ci default NULL,
  `customer_id` int(11) default NULL,
  `order_id` varchar(255) collate utf8_unicode_ci default NULL,
  `trans_id` varchar(50) collate utf8_unicode_ci default NULL,
  `time` int(10) default NULL,
  `amount` decimal(30,2) default NULL,
  `remainder` decimal(30,2) NOT NULL default '0.00',
  `notes` text collate utf8_unicode_ci,
  PRIMARY KEY  (`id`),
  KEY `customer_id` (`customer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CubeCart_transactions`
--



