init with perl stuff

1 files changed, 908 insertions, 0 deletions

diff --git a/db/schema.sql b/db/schema.sql
new file mode 100644
index 0000000..964f447
--- /dev/null
+++ b/db/schema.sql
@@ -0,0 +1,908 @@
+-- MySQL dump 10.13  Distrib 5.6.22, for osx10.10 (x86_64)
+--
+-- Host: 50.62.209.48    Database: db1125136_msashop
+-- ------------------------------------------------------
+-- Server version	5.5.43-37.2-log
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8mb4 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Table structure for table `cw_admin_users`
+--
+
+DROP TABLE IF EXISTS `cw_admin_users`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_admin_users` (
+  `admin_user_id` int(11) NOT NULL AUTO_INCREMENT,
+  `admin_user_alias` varchar(255) DEFAULT NULL,
+  `admin_username` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
+  `admin_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
+  `admin_access_level` varchar(255) DEFAULT NULL,
+  `admin_login_date` datetime DEFAULT NULL,
+  `admin_last_login` datetime DEFAULT NULL,
+  `admin_user_email` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`admin_user_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_cart`
+--
+
+DROP TABLE IF EXISTS `cw_cart`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_cart` (
+  `cart_line_id` int(11) NOT NULL AUTO_INCREMENT,
+  `cart_custcart_id` varchar(255) DEFAULT NULL,
+  `cart_sku_id` int(11) DEFAULT NULL,
+  `cart_sku_unique_id` varchar(255) DEFAULT NULL,
+  `cart_sku_qty` int(11) DEFAULT NULL,
+  `cart_dateadded` datetime DEFAULT NULL,
+  PRIMARY KEY (`cart_line_id`),
+  KEY `cart_custcart_id_idx` (`cart_custcart_id`),
+  KEY `cart_sku_id_idx` (`cart_sku_id`),
+  KEY `cart_sku_unique_id_idx` (`cart_sku_unique_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=9483 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_categories_primary`
+--
+
+DROP TABLE IF EXISTS `cw_categories_primary`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_categories_primary` (
+  `category_id` int(11) NOT NULL AUTO_INCREMENT,
+  `category_name` varchar(75) DEFAULT NULL,
+  `category_archive` smallint(6) DEFAULT '0',
+  `category_sort` float(11,3) DEFAULT '1.000',
+  `category_description` text,
+  `category_nav` smallint(6) DEFAULT '1',
+  PRIMARY KEY (`category_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_categories_secondary`
+--
+
+DROP TABLE IF EXISTS `cw_categories_secondary`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_categories_secondary` (
+  `secondary_id` int(11) NOT NULL AUTO_INCREMENT,
+  `secondary_name` varchar(100) DEFAULT NULL,
+  `secondary_archive` smallint(6) DEFAULT '0',
+  `secondary_sort` float(11,3) DEFAULT '1.000',
+  `secondary_description` text,
+  `secondary_nav` smallint(6) DEFAULT '1',
+  PRIMARY KEY (`secondary_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_config_groups`
+--
+
+DROP TABLE IF EXISTS `cw_config_groups`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_config_groups` (
+  `config_group_id` int(11) NOT NULL AUTO_INCREMENT,
+  `config_group_name` varchar(50) DEFAULT NULL,
+  `config_group_sort` float(11,3) DEFAULT '1.000',
+  `config_group_show_merchant` tinyint(4) DEFAULT '0',
+  `config_group_protected` tinyint(4) DEFAULT '1',
+  `config_group_description` text,
+  PRIMARY KEY (`config_group_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_config_items`
+--
+
+DROP TABLE IF EXISTS `cw_config_items`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_config_items` (
+  `config_id` int(11) NOT NULL AUTO_INCREMENT,
+  `config_group_id` int(11) DEFAULT '0',
+  `config_variable` varchar(50) DEFAULT NULL,
+  `config_name` varchar(50) DEFAULT NULL,
+  `config_value` text,
+  `config_type` varchar(50) DEFAULT NULL,
+  `config_description` text,
+  `config_possibles` text,
+  `config_show_merchant` tinyint(4) DEFAULT '0',
+  `config_sort` float(11,3) DEFAULT '1.000',
+  `config_size` int(3) NOT NULL DEFAULT '35',
+  `config_rows` int(3) NOT NULL DEFAULT '5',
+  `config_protected` tinyint(4) DEFAULT '0',
+  `config_required` tinyint(1) NOT NULL DEFAULT '0',
+  `config_directory` varchar(0) DEFAULT NULL,
+  PRIMARY KEY (`config_id`),
+  KEY `config_group_id_idx` (`config_group_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=245 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_countries`
+--
+
+DROP TABLE IF EXISTS `cw_countries`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_countries` (
+  `country_id` int(11) NOT NULL AUTO_INCREMENT,
+  `country_name` varchar(50) DEFAULT NULL,
+  `country_code` varchar(50) DEFAULT NULL,
+  `country_sort` float(11,3) DEFAULT '1.000',
+  `country_archive` smallint(6) DEFAULT '0',
+  `country_default_country` int(11) DEFAULT '0',
+  PRIMARY KEY (`country_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=199 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_credit_cards`
+--
+
+DROP TABLE IF EXISTS `cw_credit_cards`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_credit_cards` (
+  `creditcard_id` int(11) NOT NULL AUTO_INCREMENT,
+  `creditcard_name` varchar(50) DEFAULT NULL,
+  `creditcard_code` varchar(50) DEFAULT NULL,
+  `creditcard_archive` smallint(6) DEFAULT '0',
+  PRIMARY KEY (`creditcard_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_customer_stateprov`
+--
+
+DROP TABLE IF EXISTS `cw_customer_stateprov`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_customer_stateprov` (
+  `customer_state_id` int(11) NOT NULL AUTO_INCREMENT,
+  `customer_state_customer_id` varchar(50) NOT NULL,
+  `customer_state_stateprov_id` int(11) DEFAULT NULL,
+  `customer_state_destination` varchar(50) DEFAULT NULL,
+  PRIMARY KEY (`customer_state_id`),
+  KEY `customer_state_customer_id_idx` (`customer_state_customer_id`),
+  KEY `customer_state_stateprov_id_idx` (`customer_state_stateprov_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=5363 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_customer_types`
+--
+
+DROP TABLE IF EXISTS `cw_customer_types`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_customer_types` (
+  `customer_type_id` int(11) NOT NULL AUTO_INCREMENT,
+  `customer_type_name` varchar(50) DEFAULT NULL,
+  PRIMARY KEY (`customer_type_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_customers`
+--
+
+DROP TABLE IF EXISTS `cw_customers`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_customers` (
+  `customer_id` varchar(50) NOT NULL,
+  `customer_type_id` int(11) DEFAULT NULL,
+  `customer_date_added` datetime DEFAULT NULL,
+  `customer_date_modified` datetime DEFAULT NULL,
+  `customer_first_name` varchar(255) DEFAULT NULL,
+  `customer_last_name` varchar(255) DEFAULT NULL,
+  `customer_company` varchar(255) DEFAULT NULL,
+  `customer_address1` varchar(255) DEFAULT NULL,
+  `customer_address2` varchar(255) DEFAULT NULL,
+  `customer_city` varchar(255) DEFAULT NULL,
+  `customer_zip` varchar(255) DEFAULT NULL,
+  `customer_ship_name` varchar(255) DEFAULT NULL,
+  `customer_ship_company` varchar(255) DEFAULT NULL,
+  `customer_ship_country` varchar(255) DEFAULT NULL,
+  `customer_ship_address1` varchar(255) DEFAULT NULL,
+  `customer_ship_address2` varchar(255) DEFAULT NULL,
+  `customer_ship_city` varchar(255) DEFAULT NULL,
+  `customer_ship_zip` varchar(255) DEFAULT NULL,
+  `customer_phone` varchar(255) DEFAULT NULL,
+  `customer_phone_mobile` varchar(255) DEFAULT NULL,
+  `customer_email` varchar(255) DEFAULT NULL,
+  `customer_username` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
+  `customer_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
+  `customer_guest` tinyint(1) DEFAULT '0',
+  PRIMARY KEY (`customer_id`),
+  KEY `customer_type_id_idx` (`customer_type_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_discount_amounts`
+--
+
+DROP TABLE IF EXISTS `cw_discount_amounts`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_discount_amounts` (
+  `discount_amount_id` int(11) NOT NULL AUTO_INCREMENT,
+  `discount_amount_discount_id` int(11) NOT NULL DEFAULT '0',
+  `discount_amount_discount` decimal(20,4) NOT NULL DEFAULT '0.0000',
+  `discount_amount_minimum_qty` int(11) DEFAULT NULL,
+  `discount_amount_minimum_amount` decimal(20,4) DEFAULT NULL,
+  `discount_amount_rate_type` varchar(50) DEFAULT NULL,
+  PRIMARY KEY (`discount_amount_id`),
+  KEY `discount_amount_discount_id_idx` (`discount_amount_discount_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_discount_apply_types`
+--
+
+DROP TABLE IF EXISTS `cw_discount_apply_types`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_discount_apply_types` (
+  `discount_apply_type_id` int(11) NOT NULL AUTO_INCREMENT,
+  `discount_apply_type_description` varchar(100) NOT NULL,
+  `discount_apply_type_archive` tinyint(4) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`discount_apply_type_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_discount_categories`
+--
+
+DROP TABLE IF EXISTS `cw_discount_categories`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_discount_categories` (
+  `discount_category_id` int(11) NOT NULL AUTO_INCREMENT,
+  `discount2category_discount_id` int(11) NOT NULL DEFAULT '0',
+  `discount2category_category_id` int(11) NOT NULL DEFAULT '0',
+  `discount_category_type` tinyint(1) NOT NULL DEFAULT '1',
+  PRIMARY KEY (`discount_category_id`),
+  KEY `discount2category_discount_id_idx` (`discount2category_discount_id`),
+  KEY `discount2category_category_id_idx` (`discount2category_category_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_discount_products`
+--
+
+DROP TABLE IF EXISTS `cw_discount_products`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_discount_products` (
+  `discount_product_id` int(11) NOT NULL AUTO_INCREMENT,
+  `discount2product_discount_id` int(11) NOT NULL DEFAULT '0',
+  `discount2product_product_id` int(11) NOT NULL DEFAULT '0',
+  `discount_product_active` int(11) NOT NULL DEFAULT '1',
+  PRIMARY KEY (`discount_product_id`),
+  KEY `discount2product_discount_id_idx` (`discount2product_discount_id`),
+  KEY `discount2product_product_id_idx` (`discount2product_product_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_discount_skus`
+--
+
+DROP TABLE IF EXISTS `cw_discount_skus`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_discount_skus` (
+  `discount_sku_id` int(11) NOT NULL AUTO_INCREMENT,
+  `discount2sku_discount_id` int(11) NOT NULL DEFAULT '0',
+  `discount2sku_sku_id` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`discount_sku_id`),
+  KEY `discount2sku_discount_id_idx` (`discount2sku_discount_id`),
+  KEY `discount2sku_sku_id_idx` (`discount2sku_sku_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_discount_types`
+--
+
+DROP TABLE IF EXISTS `cw_discount_types`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_discount_types` (
+  `discount_type_id` int(11) NOT NULL AUTO_INCREMENT,
+  `discount_type` varchar(100) DEFAULT NULL,
+  `discount_type_description` varchar(100) DEFAULT NULL,
+  `discount_type_archive` tinyint(1) DEFAULT '0',
+  `discount_type_order` int(2) DEFAULT NULL,
+  PRIMARY KEY (`discount_type_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_discount_usage`
+--
+
+DROP TABLE IF EXISTS `cw_discount_usage`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_discount_usage` (
+  `discount_usage_id` int(11) NOT NULL AUTO_INCREMENT,
+  `discount_usage_customer_id` varchar(50) DEFAULT NULL,
+  `discount_usage_datetime` datetime DEFAULT NULL,
+  `discount_usage_order_id` varchar(50) DEFAULT NULL,
+  `discount_usage_discount_name` varchar(255) DEFAULT NULL,
+  `discount_usage_discount_description` text,
+  `discount_usage_promocode` varchar(255) DEFAULT NULL,
+  `discount_usage_discount_id` int(11) DEFAULT '0',
+  PRIMARY KEY (`discount_usage_id`),
+  KEY `discount_usage_order_id_idx` (`discount_usage_order_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=497 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_discounts`
+--
+
+DROP TABLE IF EXISTS `cw_discounts`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_discounts` (
+  `discount_id` int(11) NOT NULL AUTO_INCREMENT,
+  `discount_merchant_id` varchar(50) DEFAULT NULL,
+  `discount_name` varchar(100) DEFAULT NULL,
+  `discount_amount` float(12,2) DEFAULT NULL,
+  `discount_calc` varchar(99) DEFAULT NULL,
+  `discount_description` text,
+  `discount_show_description` tinyint(1) DEFAULT '1',
+  `discount_type` varchar(55) DEFAULT NULL,
+  `discount_promotional_code` varchar(255) DEFAULT NULL,
+  `discount_start_date` datetime DEFAULT NULL,
+  `discount_end_date` datetime DEFAULT NULL,
+  `discount_limit` int(11) DEFAULT '0',
+  `discount_customer_limit` int(11) DEFAULT '0',
+  `discount_global` tinyint(1) DEFAULT NULL,
+  `discount_exclusive` tinyint(1) DEFAULT '0',
+  `discount_priority` bigint(11) DEFAULT '0',
+  `discount_archive` tinyint(4) DEFAULT '0',
+  `discount_filter_customer_type` tinyint(1) DEFAULT '0',
+  `discount_customer_type` varchar(100) DEFAULT NULL,
+  `discount_filter_customer_id` tinyint(1) DEFAULT '0',
+  `discount_customer_id` text,
+  `discount_filter_cart_total` tinyint(1) DEFAULT '0',
+  `discount_cart_total_max` float(12,2) DEFAULT '0.00',
+  `discount_cart_total_min` float(12,2) DEFAULT '0.00',
+  `discount_filter_item_qty` tinyint(1) DEFAULT '0',
+  `discount_item_qty_min` int(8) DEFAULT '0',
+  `discount_item_qty_max` int(8) DEFAULT '0',
+  `discount_filter_cart_qty` tinyint(1) DEFAULT '0',
+  `discount_cart_qty_min` int(8) DEFAULT '0',
+  `discount_cart_qty_max` int(8) DEFAULT '0',
+  `discount_association_method` varchar(50) DEFAULT NULL,
+  PRIMARY KEY (`discount_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=95 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_downloads`
+--
+
+DROP TABLE IF EXISTS `cw_downloads`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_downloads` (
+  `dl_id` int(12) NOT NULL AUTO_INCREMENT,
+  `dl_sku_id` int(12) DEFAULT NULL,
+  `dl_customer_id` varchar(255) DEFAULT NULL,
+  `dl_timestamp` datetime DEFAULT NULL,
+  `dl_file` varchar(255) DEFAULT NULL,
+  `dl_version` varchar(255) DEFAULT NULL,
+  `dl_remote_addr` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`dl_id`),
+  KEY `dl_sku_id_idx` (`dl_sku_id`),
+  KEY `dl_customer_id_idx` (`dl_customer_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_image_types`
+--
+
+DROP TABLE IF EXISTS `cw_image_types`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_image_types` (
+  `imagetype_id` int(11) NOT NULL AUTO_INCREMENT,
+  `imagetype_name` varchar(100) DEFAULT NULL,
+  `imagetype_sortorder` float(11,3) DEFAULT '1.000',
+  `imagetype_folder` varchar(50) DEFAULT NULL,
+  `imagetype_max_width` int(10) DEFAULT NULL,
+  `imagetype_max_height` int(10) DEFAULT NULL,
+  `imagetype_crop_width` int(10) DEFAULT NULL,
+  `imagetype_crop_height` int(10) DEFAULT NULL,
+  `imagetype_upload_group` int(2) DEFAULT '1',
+  `imagetype_user_edit` tinyint(1) DEFAULT '1',
+  PRIMARY KEY (`imagetype_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_option_types`
+--
+
+DROP TABLE IF EXISTS `cw_option_types`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_option_types` (
+  `optiontype_id` int(11) NOT NULL AUTO_INCREMENT,
+  `optiontype_required` tinyint(4) DEFAULT '1',
+  `optiontype_name` varchar(75) DEFAULT NULL,
+  `optiontype_archive` smallint(6) DEFAULT '0',
+  `optiontype_deleted` smallint(1) DEFAULT '0',
+  `optiontype_sort` float(11,3) DEFAULT '1.000',
+  `optiontype_text` text,
+  PRIMARY KEY (`optiontype_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_options`
+--
+
+DROP TABLE IF EXISTS `cw_options`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_options` (
+  `option_id` int(11) NOT NULL AUTO_INCREMENT,
+  `option_type_id` int(11) DEFAULT '0',
+  `option_name` varchar(50) DEFAULT NULL,
+  `option_sort` float(11,3) DEFAULT '1.000',
+  `option_archive` smallint(6) DEFAULT '0',
+  `option_text` text,
+  PRIMARY KEY (`option_id`),
+  KEY `option_type_id_idx` (`option_type_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_order_payments`
+--
+
+DROP TABLE IF EXISTS `cw_order_payments`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_order_payments` (
+  `payment_id` int(12) NOT NULL AUTO_INCREMENT,
+  `order_id` varchar(50) DEFAULT NULL,
+  `payment_method` varchar(255) DEFAULT NULL,
+  `payment_type` varchar(255) DEFAULT NULL,
+  `payment_amount` float(12,2) DEFAULT NULL,
+  `payment_status` varchar(255) DEFAULT NULL,
+  `payment_trans_id` varchar(255) DEFAULT NULL,
+  `payment_trans_response` text,
+  `payment_timestamp` datetime DEFAULT NULL,
+  PRIMARY KEY (`payment_id`),
+  KEY `order_id_idx` (`order_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=2503 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_order_sku_data`
+--
+
+DROP TABLE IF EXISTS `cw_order_sku_data`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_order_sku_data` (
+  `data_id` int(11) NOT NULL AUTO_INCREMENT,
+  `data_sku_id` int(11) DEFAULT NULL,
+  `data_cart_id` bigint(20) DEFAULT NULL,
+  `data_content` text,
+  `data_date_added` datetime DEFAULT NULL,
+  PRIMARY KEY (`data_id`),
+  KEY `data_sku_id_idx` (`data_sku_id`),
+  KEY `data_cart_id_idx` (`data_cart_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_order_skus`
+--
+
+DROP TABLE IF EXISTS `cw_order_skus`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_order_skus` (
+  `ordersku_id` int(11) NOT NULL AUTO_INCREMENT,
+  `ordersku_order_id` varchar(255) NOT NULL,
+  `ordersku_sku` int(11) NOT NULL DEFAULT '0',
+  `ordersku_quantity` int(11) DEFAULT NULL,
+  `ordersku_unit_price` double DEFAULT NULL,
+  `ordersku_sku_total` double DEFAULT '0',
+  `ordersku_tax_rate` double DEFAULT '0',
+  `ordersku_taxrate_id` int(11) DEFAULT NULL,
+  `ordersku_unique_id` varchar(255) DEFAULT NULL,
+  `ordersku_customval` varchar(255) DEFAULT NULL,
+  `ordersku_discount_amount` double DEFAULT NULL,
+  PRIMARY KEY (`ordersku_id`),
+  KEY `ordersku_order_id_idx` (`ordersku_order_id`),
+  KEY `ordersku_unique_id_idx` (`ordersku_unique_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=5637 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_order_status`
+--
+
+DROP TABLE IF EXISTS `cw_order_status`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_order_status` (
+  `shipstatus_id` int(11) NOT NULL AUTO_INCREMENT,
+  `shipstatus_name` varchar(70) DEFAULT NULL,
+  `shipstatus_sort` float(11,3) DEFAULT '1.000',
+  PRIMARY KEY (`shipstatus_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_orders`
+--
+
+DROP TABLE IF EXISTS `cw_orders`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_orders` (
+  `order_id` varchar(75) NOT NULL,
+  `order_date` datetime DEFAULT NULL,
+  `order_status` int(11) DEFAULT '0',
+  `order_customer_id` varchar(50) NOT NULL,
+  `order_checkout_type` varchar(20) DEFAULT NULL,
+  `order_tax` double DEFAULT '0',
+  `order_shipping` double DEFAULT '0',
+  `order_shipping_tax` double DEFAULT '0',
+  `order_total` double DEFAULT '0',
+  `order_ship_method_id` int(11) DEFAULT '0',
+  `order_ship_date` datetime DEFAULT NULL,
+  `order_ship_tracking_id` varchar(100) DEFAULT NULL,
+  `order_ship_name` text,
+  `order_company` varchar(255) DEFAULT NULL,
+  `order_address1` varchar(255) DEFAULT NULL,
+  `order_address2` varchar(255) DEFAULT NULL,
+  `order_city` varchar(255) DEFAULT NULL,
+  `order_state` varchar(50) DEFAULT NULL,
+  `order_zip` varchar(50) DEFAULT NULL,
+  `order_country` varchar(75) DEFAULT NULL,
+  `order_notes` text,
+  `order_actual_ship_charge` double DEFAULT '0',
+  `order_comments` varchar(255) DEFAULT NULL,
+  `order_discount_total` double DEFAULT '0',
+  `order_ship_discount_total` double DEFAULT NULL,
+  `order_return_date` date DEFAULT NULL,
+  `order_return_amount` double DEFAULT NULL,
+  PRIMARY KEY (`order_id`),
+  KEY `order_customer_id_idx` (`order_customer_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_product_categories_primary`
+--
+
+DROP TABLE IF EXISTS `cw_product_categories_primary`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_product_categories_primary` (
+  `product2category_id` int(11) NOT NULL AUTO_INCREMENT,
+  `product2category_product_id` int(11) DEFAULT '0',
+  `product2category_category_id` int(11) DEFAULT '0',
+  PRIMARY KEY (`product2category_id`),
+  KEY `product2category_product_id_idx` (`product2category_product_id`),
+  KEY `product2category_category_id_idx` (`product2category_category_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=326 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_product_categories_secondary`
+--
+
+DROP TABLE IF EXISTS `cw_product_categories_secondary`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_product_categories_secondary` (
+  `product2secondary_id` int(11) NOT NULL AUTO_INCREMENT,
+  `product2secondary_product_id` int(11) DEFAULT '0',
+  `product2secondary_secondary_id` int(11) DEFAULT '0',
+  PRIMARY KEY (`product2secondary_id`),
+  KEY `product2secondary_product_id_idx` (`product2secondary_product_id`),
+  KEY `product2secondary_secondary_id_idx` (`product2secondary_secondary_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=344 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_product_images`
+--
+
+DROP TABLE IF EXISTS `cw_product_images`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_product_images` (
+  `product_image_id` int(11) NOT NULL AUTO_INCREMENT,
+  `product_image_product_id` int(11) DEFAULT '0',
+  `product_image_imagetype_id` int(11) DEFAULT '0',
+  `product_image_filename` varchar(255) DEFAULT NULL,
+  `product_image_sortorder` float(11,3) DEFAULT '1.000',
+  `product_image_caption` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`product_image_id`),
+  KEY `product_image_product_id_idx` (`product_image_product_id`),
+  KEY `product_image_imagetype_id_idx` (`product_image_imagetype_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=331 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_product_options`
+--
+
+DROP TABLE IF EXISTS `cw_product_options`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_product_options` (
+  `product_options_id` int(11) NOT NULL AUTO_INCREMENT,
+  `product_options2prod_id` int(11) NOT NULL DEFAULT '0',
+  `product_options2optiontype_id` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`product_options_id`),
+  KEY `product_options2prod_id_idx` (`product_options2prod_id`),
+  KEY `product_options2optiontype_id_idx` (`product_options2optiontype_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=84 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_product_upsell`
+--
+
+DROP TABLE IF EXISTS `cw_product_upsell`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_product_upsell` (
+  `upsell_id` int(11) NOT NULL AUTO_INCREMENT,
+  `upsell_product_id` int(11) DEFAULT '0',
+  `upsell_2product_id` int(11) DEFAULT '0',
+  PRIMARY KEY (`upsell_id`),
+  KEY `upsell_product_id_idx` (`upsell_product_id`),
+  KEY `upsell_2product_id_idx` (`upsell_2product_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_products`
+--
+
+DROP TABLE IF EXISTS `cw_products`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_products` (
+  `product_id` int(11) NOT NULL AUTO_INCREMENT,
+  `product_merchant_product_id` varchar(50) NOT NULL,
+  `product_name` varchar(125) DEFAULT NULL,
+  `product_description` text,
+  `product_preview_description` text,
+  `product_sort` float(11,3) DEFAULT '1.000',
+  `product_on_web` smallint(6) DEFAULT '1',
+  `product_archive` smallint(6) DEFAULT '0',
+  `product_ship_charge` smallint(6) DEFAULT '0',
+  `product_tax_group_id` int(11) DEFAULT '0',
+  `product_date_modified` datetime DEFAULT NULL,
+  `product_special_description` text,
+  `product_keywords` text,
+  `product_out_of_stock_message` varchar(255) DEFAULT NULL,
+  `product_custom_info_label` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`product_id`),
+  KEY `product_tax_group_id_idx` (`product_tax_group_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_ship_method_countries`
+--
+
+DROP TABLE IF EXISTS `cw_ship_method_countries`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_ship_method_countries` (
+  `ship_method_country_id` int(11) NOT NULL AUTO_INCREMENT,
+  `ship_method_country_method_id` int(11) DEFAULT '0',
+  `ship_method_country_country_id` int(11) DEFAULT '0',
+  PRIMARY KEY (`ship_method_country_id`),
+  KEY `ship_method_country_method_id_idx` (`ship_method_country_method_id`),
+  KEY `ship_method_country_country_id_idx` (`ship_method_country_country_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_ship_methods`
+--
+
+DROP TABLE IF EXISTS `cw_ship_methods`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_ship_methods` (
+  `ship_method_id` int(11) NOT NULL AUTO_INCREMENT,
+  `ship_method_name` varchar(100) NOT NULL DEFAULT '',
+  `ship_method_rate` double DEFAULT NULL,
+  `ship_method_sort` float(11,3) NOT NULL DEFAULT '1.000',
+  `ship_method_archive` smallint(6) DEFAULT '0',
+  `ship_method_calctype` varchar(55) DEFAULT NULL,
+  PRIMARY KEY (`ship_method_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=108 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_ship_ranges`
+--
+
+DROP TABLE IF EXISTS `cw_ship_ranges`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_ship_ranges` (
+  `ship_range_id` int(11) NOT NULL AUTO_INCREMENT,
+  `ship_range_method_id` int(11) DEFAULT '0',
+  `ship_range_from` double DEFAULT '0',
+  `ship_range_to` double DEFAULT '0',
+  `ship_range_amount` double DEFAULT '0',
+  PRIMARY KEY (`ship_range_id`),
+  KEY `ship_range_method_id_idx` (`ship_range_method_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_sku_options`
+--
+
+DROP TABLE IF EXISTS `cw_sku_options`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_sku_options` (
+  `sku_option_id` int(11) NOT NULL AUTO_INCREMENT,
+  `sku_option2sku_id` int(11) NOT NULL DEFAULT '0',
+  `sku_option2option_id` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`sku_option_id`),
+  KEY `sku_option2sku_id_idx` (`sku_option2sku_id`),
+  KEY `sku_option2option_id_idx` (`sku_option2option_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=2725 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_skus`
+--
+
+DROP TABLE IF EXISTS `cw_skus`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_skus` (
+  `sku_id` int(11) NOT NULL AUTO_INCREMENT,
+  `sku_merchant_sku_id` varchar(50) DEFAULT NULL,
+  `sku_product_id` int(11) NOT NULL DEFAULT '0',
+  `sku_price` double DEFAULT NULL,
+  `sku_weight` double DEFAULT '0',
+  `sku_stock` int(11) DEFAULT '0',
+  `sku_on_web` smallint(6) DEFAULT '1',
+  `sku_sort` float(11,3) DEFAULT '1.000',
+  `sku_alt_price` double DEFAULT NULL,
+  `sku_ship_base` double DEFAULT NULL,
+  `sku_download_file` varchar(255) DEFAULT NULL,
+  `sku_download_id` varchar(255) DEFAULT NULL,
+  `sku_download_version` varchar(50) DEFAULT NULL,
+  `sku_download_limit` int(7) DEFAULT '0',
+  PRIMARY KEY (`sku_id`),
+  KEY `sku_product_id_idx` (`sku_product_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=108 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_stateprov`
+--
+
+DROP TABLE IF EXISTS `cw_stateprov`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_stateprov` (
+  `stateprov_id` int(11) NOT NULL AUTO_INCREMENT,
+  `stateprov_code` varchar(50) DEFAULT NULL,
+  `stateprov_name` varchar(255) DEFAULT NULL,
+  `stateprov_country_id` int(11) DEFAULT '0',
+  `stateprov_tax` double DEFAULT '0',
+  `stateprov_ship_ext` double DEFAULT '0',
+  `stateprov_archive` smallint(6) DEFAULT '0',
+  PRIMARY KEY (`stateprov_id`),
+  KEY `stateprov_country_id_idx` (`stateprov_country_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=4216 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_tax_groups`
+--
+
+DROP TABLE IF EXISTS `cw_tax_groups`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_tax_groups` (
+  `tax_group_id` int(11) NOT NULL AUTO_INCREMENT,
+  `tax_group_name` varchar(150) DEFAULT NULL,
+  `tax_group_archive` smallint(6) DEFAULT '0',
+  `tax_group_code` varchar(50) DEFAULT NULL,
+  PRIMARY KEY (`tax_group_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_tax_rates`
+--
+
+DROP TABLE IF EXISTS `cw_tax_rates`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_tax_rates` (
+  `tax_rate_id` int(11) NOT NULL AUTO_INCREMENT,
+  `tax_rate_region_id` int(11) DEFAULT '0',
+  `tax_rate_group_id` int(11) DEFAULT '0',
+  `tax_rate_percentage` double DEFAULT '0',
+  PRIMARY KEY (`tax_rate_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `cw_tax_regions`
+--
+
+DROP TABLE IF EXISTS `cw_tax_regions`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `cw_tax_regions` (
+  `tax_region_id` int(11) NOT NULL AUTO_INCREMENT,
+  `tax_region_country_id` int(11) NOT NULL DEFAULT '0',
+  `tax_region_state_id` int(11) NOT NULL DEFAULT '0',
+  `tax_region_label` varchar(150) DEFAULT NULL,
+  `tax_region_tax_id` varchar(50) DEFAULT NULL,
+  `tax_region_show_id` tinyint(4) DEFAULT NULL,
+  `tax_region_ship_tax_method` varchar(50) DEFAULT NULL,
+  `tax_region_ship_tax_group_id` int(11) DEFAULT '0',
+  PRIMARY KEY (`tax_region_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2017-04-21 11:31:20