-- Table structure for table `checkout_agreement`
--

CREATE TABLE `checkout_agreement` (
  `agreement_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Agreement Id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `content` text COMMENT 'Content',
  `content_height` varchar(25) DEFAULT NULL COMMENT 'Content Height',
  `checkbox_text` text COMMENT 'Checkbox Text',
  `is_active` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `is_html` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Is Html',
  `mode` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Applied mode',
  PRIMARY KEY (`agreement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Checkout Agreement';

--
-- Table structure for table `checkout_agreement_store`
--

CREATE TABLE `checkout_agreement_store` (
  `agreement_id` int(10) unsigned NOT NULL COMMENT 'Agreement Id',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  PRIMARY KEY (`agreement_id`,`store_id`),
  KEY `CHECKOUT_AGREEMENT_STORE_STORE_ID_STORE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Checkout Agreement Store';

--
-- Table structure for table `cms_block`
--

CREATE TABLE `cms_block` (
  `block_id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Block ID',
  `title` varchar(255) NOT NULL COMMENT 'Block Title',
  `identifier` varchar(255) NOT NULL COMMENT 'Block String Identifier',
  `content` mediumtext COMMENT 'Block Content',
  `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Block Creation Time',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Block Modification Time',
  `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Is Block Active',
  PRIMARY KEY (`block_id`),
  FULLTEXT KEY `CMS_BLOCK_TITLE_IDENTIFIER_CONTENT` (`title`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='CMS Block Table';

--
-- Dumping data for table `cms_block`
--

INSERT INTO `cms_block` VALUES (1,'Footer column content 2','footer_col_2','<div class=\"footer-col\">\r\n    <h4>Why buy from us</h4>\r\n    <div class=\"footer-col-content\">\r\n     <ul>\r\n       <li><a href=\"#\">Shipping & Returns</a></li>\r\n       <li><a href=\"#\">Secure Shopping</a></li>\r\n       <li><a href=\"#\">International Shipping</a></li>\r\n       <li><a href=\"#\">Affiliates</a></li>\r\n       <li><a href=\"#\">Group Sales</a></li>\r\n     </ul>\r\n    </div>\r\n</div>','2016-03-12 03:30:44','2017-06-15 12:35:09',1),(4,'Footer column content 3','footer_col_3','<div class=\"footer-col\">\r\n<h4>My account</h4>\r\n<div class=\"footer-col-content\">\r\n   		<ul>\r\n   			<li><a href=\"{{store url=\'customer/account/login/\'}}\">Sign In</a></li>\r\n   			<li><a href=\"{{store url=\'checkout/cart/\'}}\">View Cart</a></li>\r\n   			<li><a href=\"{{store url=\'wishlist/\'}}\">My Wishlist</a></li>\r\n   			<li><a href=\"#\">Track My Order</a></li>\r\n			<li><a href=\"#\">Help</a></li>\r\n   	 	</ul>\r\n</div>\r\n</div>','2016-03-12 03:33:05','2017-06-15 12:43:49',1),(7,'Footer column content 4','footer_col_4','<!-- Learn more -->\r\n<div class=\"footer-col footer-col-contact-info\">\r\n    <h4>Learn more</h4>\r\n    <div class=\"footer-col-content\">\r\n        <ul>\r\n            <li><a href=\"#\">Blog Full Width</a></li>\r\n            <li><a href=\"#\">Blog Sidebar Left</a></li>\r\n            <li><a href=\"#\">Blog Sidebar Right</a></li>\r\n        </ul>\r\n    </div>\r\n</div>\r\n','2016-03-12 03:35:20','2017-06-15 12:44:46',1),(10,'Footer column 1 title','footer_col_1_title','<h4>Information</h4>','2017-06-15 12:45:27','2017-06-15 12:45:27',1),(11,'Footer column content 1','footer_col_1','<ul>\r\n    <li><a href=\"{{store direct_url=\"about-us\"}}\">About Us</a></li>\r\n    <li><a href=\"{{store direct_url=\"customer-service\"}}\">Customer Service</a></li>\r\n    <li><a href=\"{{store url=\"\"}}template-settings\">Template Settings</a></li>\r\n</ul>','2017-06-15 12:47:30','2017-06-15 12:47:30',1),(12,'banner-box','banner-box','<!-- Banner Box -->\r\n<div class=\"banner-box\">\r\n    <div class=\"row\">\r\n        <div class=\"col-m-4\">\r\n            <div class=\"banner-box-item  banner-1\">\r\n                <a href=\"{{store url=\'men.html\'}}\"><img src=\"{{view url=\'\'}}/images/media/banner-1.jpg\"/></a>\r\n                <div class=\"banner-content\">\r\n                    <h2>Flora de` Loda</h2>\r\n                    <h1>Skater Dresses</h1>\r\n                    <span>buy shop</span>\r\n                </div>\r\n            </div>\r\n        </div>\r\n        <div class=\"col-m-8\">\r\n            <div class=\"row\">\r\n                <div class=\"col-m-6\">\r\n                    <div class=\"banner-box-item banner-2\">\r\n                        <a href=\"{{store url=\'men.html\'}}\"><img src=\"{{view url=\'\'}}/images/media/banner-2.jpg\"/></a>\r\n                        <div class=\"banner-content\">\r\n                            <h2>Casual Sneakers</h2>\r\n                            <h1>Yippe Teens</h1>\r\n                            <span>buy shop</span>\r\n                        </div>\r\n                    </div>\r\n                </div>\r\n                <div class=\"col-m-6\">\r\n                    <div class=\"banner-box-item banner-3\">\r\n                        <a href=\"{{store url=\'men.html\'}}\"><img src=\"{{view url=\'\'}}/images/media/banner-3.jpg\"/></a>\r\n                        <div class=\"banner-content\">\r\n                            <h2>Flaunt Skirts</h2>\r\n                            <h1>Laura`s Shop</h1>\r\n                            <span>buy shop</span>\r\n                        </div>\r\n                    </div>\r\n                </div>\r\n            </div>\r\n            <div class=\"row\">\r\n                <div class=\"col-m-7\">\r\n                    <div class=\"banner-box-item banner-4\">\r\n                        <a href=\"{{store url=\'men.html\'}}\"><img src=\"{{view url=\'\'}}/images/media/banner-4.jpg\"/></a>\r\n                        <div class=\"banner-content\">\r\n                            <h2>Backpacks</h2>\r\n                            <h1>Ellen`s Secret</h1>\r\n                            <span>buy shop</span>\r\n                        </div>\r\n                    </div>\r\n                </div>\r\n                <div class=\"col-m-5\">\r\n                    <div class=\"banner-box-item banner-5\">\r\n                        <a href=\"{{store url=\'men.html\'}}\"><img src=\"{{view url=\'\'}}/images/media/banner-5.jpg\"/>\r\n<div class=\"banner-content\">\r\n                            <div>\r\n                                <h2>Sunglass</h2>\r\n                                <h1>Funky Zero</h1>\r\n                                <span>buy shop</span>\r\n                            </div>\r\n                        </div>\r\n</a>\r\n                        \r\n                    </div>\r\n                </div>\r\n            </div>\r\n        </div>\r\n    </div>\r\n</div>','2017-11-14 12:46:44','2017-11-14 12:46:44',1),(13,'AMP Footer Links','amp_footer_links','<ul><li><a href=\"{{store url=\'about-us\'}}\">About Us</a></li><li><a href=\"{{store url=\'contact\'}}\">Contact Us</a></li><li><a href=\"{{store url=\'customer-service\'}}\">Customer Service</a></li><li><a href=\"{{store url=\'privacy-policy-cookie-restriction-mode\'}}\">Privacy Policy</a></li><li><a href=\"{{store url=\'template-settings\'}}\">Templates Settings</a></li></ul>','2018-01-10 15:00:53','2018-01-10 15:00:53',1);

--
-- Table structure for table `cms_block_store`
--

CREATE TABLE `cms_block_store` (
  `block_id` smallint(6) NOT NULL COMMENT 'Block ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`block_id`,`store_id`),
  KEY `CMS_BLOCK_STORE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CMS Block To Store Linkage Table';

--
-- Dumping data for table `cms_block_store`
--

INSERT INTO `cms_block_store` VALUES (1,0),(4,0),(7,0),(10,0),(11,0),(12,0),(13,0);

--
-- Table structure for table `cms_page`
--

CREATE TABLE `cms_page` (
  `page_id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Page ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `meta_keywords` text COMMENT 'Page Meta Keywords',
  `meta_description` text COMMENT 'Page Meta Description',
  `identifier` varchar(100) DEFAULT NULL COMMENT 'Page String Identifier',
  `content_heading` varchar(255) DEFAULT NULL COMMENT 'Page Content Heading',
  `content` mediumtext COMMENT 'Page Content',
  `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Page Creation Time',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Page Modification Time',
  `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Is Page Active',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Page Sort Order',
  `layout_update_xml` text COMMENT 'Page Layout Update Content',
  `custom_theme` varchar(100) DEFAULT NULL COMMENT 'Page Custom Theme',
  `custom_root_template` varchar(255) DEFAULT NULL COMMENT 'Page Custom Template',
  `custom_layout_update_xml` text COMMENT 'Page Custom Layout Update Content',
  `custom_theme_from` date DEFAULT NULL COMMENT 'Page Custom Theme Active From Date',
  `custom_theme_to` date DEFAULT NULL COMMENT 'Page Custom Theme Active To Date',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Meta Title',
  PRIMARY KEY (`page_id`),
  KEY `CMS_PAGE_IDENTIFIER` (`identifier`),
  FULLTEXT KEY `CMS_PAGE_TITLE_META_KEYWORDS_META_DESCRIPTION_IDENTIFIER_CONTENT` (`title`,`meta_keywords`,`meta_description`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='CMS Page Table';

--
-- Dumping data for table `cms_page`
--

INSERT INTO `cms_page` VALUES (1,'404 Not Found','1column','Page keywords','Page description','no-route','Whoops, our bad...','<div class=\"not-found-page\">\r\n    <dl>\r\n        <dt class=\"not-found-page_top\">\r\n            <img src=\"{{view url=\'images/404.png\'}}\" alt=\"404-img\">\r\n            <div>\r\n                <strong>Sorry...</strong>\r\n                <span>It’s not you. It’s us.</span>\r\n            </div>\r\n        </dt>\r\n    </dl>\r\n    <dl class=\"not-found-page_bottom\">\r\n        <dt>The page you are looking for can’t be found.</dt>\r\n        <dd><a href=\"{{store url=\"\"}}\">Go Home!</a></dd>\r\n    </dl>\r\n</div>','2016-03-12 02:24:45','2017-01-19 13:33:44',1,0,'',NULL,NULL,NULL,NULL,NULL,''),(2,'Trendy','1column','','','home','','<div class=\"clearfix\"></div>\r\n','2016-03-12 02:24:45','2016-03-12 02:25:04',1,0,'<!--\r\n    <referenceContainer name=\"right\">\r\n        <action method=\"unsetChild\"><argument name=\"alias\" xsi:type=\"string\">right.reports.product.viewed</argument></action>\r\n        <action method=\"unsetChild\"><argument name=\"alias\" xsi:type=\"string\">right.reports.product.compared</argument></action>\r\n    </referenceContainer>-->','','',NULL,NULL,NULL,''),(3,'Enable Cookies','1column',NULL,NULL,'enable-cookies','What are Cookies?','<div class=\"enable-cookies cms-content\">\r\n<p>\"Cookies\" are little pieces of data we send when you visit our store. Cookies help us get to know you better and personalize your experience. Plus they help protect you and other shoppers from fraud.</p>\r\n<p style=\"margin-bottom: 20px;\">Set your browser to accept cookies so you can buy items, save items, and receive customized recommendations. Here’s how:</p>\r\n<ul>\r\n<li><a href=\"https://support.google.com/accounts/answer/61416?hl=en\" target=\"_blank\">Google Chrome</a></li>\r\n<li><a href=\"http://windows.microsoft.com/en-us/internet-explorer/delete-manage-cookies\" target=\"_blank\">Internet Explorer</a></li>\r\n<li><a href=\"http://support.apple.com/kb/PH19214\" target=\"_blank\">Safari</a></li>\r\n<li><a href=\"https://support.mozilla.org/en-US/kb/enable-and-disable-cookies-website-preferences\" target=\"_blank\">Mozilla/Firefox</a></li>\r\n</ul>\r\n</div>','2016-03-12 02:24:45','2016-03-12 02:24:45',1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'Privacy Policy','1column','','','privacy-policy-cookie-restriction-mode','Privacy Policy','<div class=\"change-message\">\r\n    <span>Please replace this text with your Privacy Policy.</span>\r\n</div>\r\n<dl class=\"custom-page privacy-policy-page\">\r\n    <dt class=\"heading-2\">General information</dt>\r\n    <dd>Welcome to our Privacy Policy page! When you use our store services, you trust us with your information. This Privacy Policy is meant to help you understand what data we collect, why we collect it, and what we do with it. When you share information with us, we can make our services even better for you. For instance, we can show you more relevant search results and ads, help you connect with people or to make sharing with others quicker and easier. As you use our services, we want you to be clear how we’re using information and the ways in which you can protect your privacy. This is important; we hope you will take time to read it carefully. Remember, you can find controls to manage your information and protect your privacy and security. We’ve tried to keep it as simple as possible.</dd>\r\n    <dt class=\"heading-2\">Right to access, correct and delete data and to object to data processing</dt>\r\n    <dd>Our customers have the right to access, correct and delete personal data relating to them, and to object to the processing of such data, by addressing a written request, at any time. The Company makes every effort to put in place suitable precautions to safeguard the security and privacy of personal data, and to prevent it from being altered, corrupted, destroyed or accessed by unauthorized third parties. However, the Company does not control each and every risk related to the use of the Internet, and therefore warns the Site users of the potential risks involved in the functioning and use of the Internet. The Site may include links to other web sites or other internet sources. As the Company cannot control these web sites and external sources, the Company cannot be held responsible for the provision or display of these web sites and external sources, and may not be held liable for the content, advertising, products, services or any other material available on or from these web sites or external sources.</dd>\r\n    <dt class=\"heading-2\">Management of personal data</dt>\r\n    <dd>You can view or edit your personal data online for many of our services. You can also make choices about our collection and use of your data. How you can access or control your personal data will depend on which services you use. You can choose whether you wish to receive promotional communications from our store by email, SMS, physical mail, and telephone. If you receive promotional email or SMS messages from us and would like to opt out, you can do so by following the directions in that message. You can also make choices about the receipt of promotional email, telephone calls, and postal mail by visiting and signing into Company Promotional Communications Manager, which allows you to update contact information, manage contact preferences, opt out of email subscriptions, and choose whether to share your contact information with our partners. These choices do not apply to mandatory service communications that are part of certain store services.</dd>\r\n    <dt class=\"heading-2\">Information We Collect</dt>\r\n    <dd>Our store collects data to operate effectively and provide you the best experiences with our services. You provide some of this data directly, such as when you create a personal account. We get some of it by recording how you interact with our services by, for example, using technologies like cookies, and receiving error reports or usage data from software running on your device. We also obtain data from third parties (including other companies). For example, we supplement the data we collect by purchasing demographic data from other companies. We also use services from other companies to help us determine a location based on your IP address in order to customize certain services to your location. The data we collect depends on the services and features you use.</dd>\r\n    <dt class=\"heading-2\">How We Use Your Information</dt>\r\n    <dd>Our store uses the data we collect for three basic purposes: to operate our business and provide (including improving and personalizing) the services we offer, to send communications, including promotional communications, and to display advertising. In carrying out these purposes, we combine data we collect through the various store services you use to give you a more seamless, consistent and personalized experience. However, to enhance privacy, we have built in technological and procedural safeguards designed to prevent certain data combinations. For example, we store data we collect from you when you are unauthenticated (not signed in) separately from any account information that directly identifies you, such as your name, email address or phone number.</dd>\r\n    <dt class=\"heading-2\">Sharing Your Information</dt>\r\n    <dd>We share your personal data with your consent or as necessary to complete any transaction or provide any service you have requested or authorized. For example, we share your content with third parties when you tell us to do so. When you provide payment data to make a purchase, we will share payment data with banks and other entities that process payment transactions or provide other financial services, and for fraud prevention and credit risk reduction. In addition, we share personal data among our controlled affiliates and subsidiaries. We also share personal data with vendors or agents working on our behalf for the purposes described in this statement. For example, companies we\'ve hired to provide customer service support or assist in protecting and securing our systems and services may need access to personal data in order to provide those functions. In such cases, these companies must abide by our data privacy and security requirements and are not allowed to use personal data they receive from us for any other purpose. We may also disclose personal data as part of a corporate transaction such as a merger or sale of assets.</dd>\r\n</dl>','2016-03-12 02:24:45','2017-01-06 10:46:51',1,0,'','','',NULL,NULL,NULL,''),(6,'Customer Service','1column','','','customer-service','Customer Service','<div class=\"customer-service\">\r\n    <div class=\"text-block customer-service__block\">\r\n        <h3>Delivery</h3>\r\n        <h4>Hello and welcome to the shipping and delivery information page! Here you can get acquainted with useful information on terms \r\nand conditions of our goods delivery</h4>\r\n        <p>You can purchase your items online and pick them up at our street store, or ship them directly to your doorstep. Shipping is free on some orders. We use the best carriers in the business to make sure your order gets to you on time. From the Secure Checkout page you\'ll see your item description, price and delivery timing. Where available, you can also choose a faster delivery method for each item on your order, for an additional fee. Delivery times vary according to your selected delivery address, availability of your items and the time of day you place your order.</p>\r\n    </div>\r\n    <div class=\"table-block  customer-service__block\">\r\n        <h3>Cost</h3>\r\n        <div class=\"table-block_wrapper\">\r\n            <table>\r\n                <thead>\r\n                    <th>Services</th>\r\n                    <th>Locations</th>\r\n                    <th>Delivery Schedule</th>\r\n                    <th>Cost Per Shipment</th>\r\n                </thead>\r\n                <tbody>\r\n                    <tr>\r\n                        <td>Royal mail 1st Class Service (Order value $20 or less)</td>\r\n                        <td>All of UK & some European Countries</td>\r\n                        <td>1-3 days Monday - Saturday</td>\r\n                        <td>$5</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Royal mail Tracker (Order value $50 or less)</td>\r\n                        <td>All of UK</td>\r\n                        <td>1-3 days Delivery 7.30am - 5.30am Monday - Friday</td>\r\n                        <td>$45</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Standard Courier Delivery</td>\r\n                        <td>UK mainland only</td>\r\n                        <td>1-3 days Monday - Saturday</td>\r\n                        <td>$124</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Standard Courier Delivery</td>\r\n                        <td>Northern Ireland, Eire, Scilly Isles</td>\r\n                        <td>1-3 days Delivery 7.30am - 5.30am Monday - Friday</td>\r\n                        <td>$11</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Royal mail 1st Class Service (Order value $20 or less)</td>\r\n                        <td>All of UK & some European Countries</td>\r\n                        <td>1-3 days Monday - Saturday</td>\r\n                        <td>$5</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Priority courier pre 12pm Next Working Day</td>\r\n                        <td>UK mainland only</td>\r\n                        <td>1-3 days Delivery 7.30am - 5.30am Monday - Friday</td>\r\n                        <td>$89</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Royal mail 1st Class Service (Order value $20 or less)</td>\r\n                        <td>All of UK & some European Countries</td>\r\n                        <td>1-3 days Monday - Saturday</td>\r\n                        <td>$72</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>            \r\n        </div>\r\n    </div>\r\n    <div class=\"text-block  customer-service__block\">\r\n        <h3>Free Delivery</h3>\r\n        <p>Free two-day shipping is available on in-stock items. You can see in your bag if your item is in stock. Free two-day shipping is not available on customized, engraved products, and for certain order types, including orders paid for with financing or by bank transfer. To get free two-day shipping, you will need to place your order by 5pm, Monday to Friday. For instance, if you order your goods before 5:00 pm, Monday to Friday we will deliver them in two business days.</p>\r\n    </div>\r\n    <div class=\"list-block  customer-service__block\">\r\n        <h3>Terms & Conditions</h3>\r\n        <ul class=\"row\">\r\n            <li class=\"col-m-6\">\r\n                <h4>Entire agreement</h4>\r\n                <p>If you require a complete delivery of your orders, please enter an X in the Complete Delivery field on the shipping screen of the customer master record. The indicator is copied into the order header, which you can also use for the purpose.</p>\r\n            </li>\r\n            <li class=\"col-m-6\">\r\n                <h4>Entire agreement</h4>\r\n                <p>If you require a complete delivery of your orders, please enter an X in the Complete Delivery field on the shipping screen of the customer master record. The indicator is copied into the order header, which you can also use for the purpose.</p>\r\n            </li>\r\n            <li class=\"col-m-6\">\r\n                <h4>Controlling terms</h4>\r\n                <p>Buyer expressly agrees that Seller’s Invoice and these Terms and Conditions of Sale represent the complete agreement of the parties with respect to the sale of the product(s) listed on the Invoice and no different or additional terms or conditions in Buyer’s purchase order or in any other prior or subsequent communications in any way adding to, modifying or otherwise changing these Terms and Conditions of Sale shall be binding upon Seller.</p>\r\n            </li>\r\n            <li class=\"col-m-6\">\r\n                <h4>Controlling terms</h4>\r\n                <p>Buyer expressly agrees that Seller’s Invoice and these Terms and Conditions of Sale represent the complete agreement of the parties with respect to the sale of the product(s) listed on the Invoice and no different or additional terms or conditions in Buyer’s purchase order or in any other prior or subsequent communications in any way adding to, modifying or otherwise changing these Terms and Conditions of Sale shall be binding upon Seller.</p>\r\n            </li>\r\n            <li class=\"col-m-6\">\r\n                <h4>Entire agreement</h4>\r\n                <p>If you require a complete delivery of your orders, please enter an X in the Complete Delivery field on the shipping screen of the customer master record. The indicator is copied into the order header, which you can also use for the purpose.</p>\r\n            </li>\r\n            <li class=\"col-m-6\">\r\n                <h4>Entire agreement</h4>\r\n                <p>If you require a complete delivery of your orders, please enter an X in the Complete Delivery field on the shipping screen of the customer master record. The indicator is copied into the order header, which you can also use for the purpose.</p>\r\n            </li>\r\n            <li class=\"col-m-6\">\r\n                <h4>Controlling terms</h4>\r\n                <p>Buyer expressly agrees that Seller’s Invoice and these Terms and Conditions of Sale represent the complete agreement of the parties with respect to the sale of the product(s) listed on the Invoice and no different or additional terms or conditions in Buyer’s purchase order or in any other prior or subsequent communications in any way adding to, modifying or otherwise changing these Terms and Conditions of Sale shall be binding upon Seller.</p>\r\n            </li>\r\n            <li class=\"col-m-6\">\r\n                <h4>Controlling terms</h4>\r\n                <p>Buyer expressly agrees that Seller’s Invoice and these Terms and Conditions of Sale represent the complete agreement of the parties with respect to the sale of the product(s) listed on the Invoice and no different or additional terms or conditions in Buyer’s purchase order or in any other prior or subsequent communications in any way adding to, modifying or otherwise changing these Terms and Conditions of Sale shall be binding upon Seller.</p>\r\n            </li>\r\n            <li class=\"col-m-6\">\r\n                <h4>Entire agreement</h4>\r\n                <p>If you require a complete delivery of your orders, please enter an X in the Complete Delivery field on the shipping screen of the customer master record. The indicator is copied into the order header, which you can also use for the purpose.</p>\r\n            </li>\r\n            <li class=\"col-m-6\">\r\n                <h4>Entire agreement</h4>\r\n                <p>If you require a complete delivery of your orders, please enter an X in the Complete Delivery field on the shipping screen of the customer master record. The indicator is copied into the order header, which you can also use for the purpose.</p>\r\n            </li>\r\n            <li class=\"col-m-6\">\r\n                <h4>Controlling terms</h4>\r\n                <p>Buyer expressly agrees that Seller’s Invoice and these Terms and Conditions of Sale represent the complete agreement of the parties with respect to the sale of the product(s) listed on the Invoice and no different or additional terms or conditions in Buyer’s purchase order or in any other prior or subsequent communications in any way adding to, modifying or otherwise changing these Terms and Conditions of Sale shall be binding upon Seller.</p>\r\n            </li>\r\n            <li class=\"col-m-6\">\r\n                <h4>Controlling terms</h4>\r\n                <p>Buyer expressly agrees that Seller’s Invoice and these Terms and Conditions of Sale represent the complete agreement of the parties with respect to the sale of the product(s) listed on the Invoice and no different or additional terms or conditions in Buyer’s purchase order or in any other prior or subsequent communications in any way adding to, modifying or otherwise changing these Terms and Conditions of Sale shall be binding upon Seller.</p>\r\n            </li>\r\n        </ul>\r\n    </div>\r\n</div>\r\n\r\n<script>\r\nvar headertext = [];\r\nvar headers = document.querySelectorAll(\".table-block thead\");\r\nvar tablebody = document.querySelectorAll(\".table-block tbody\");\r\n\r\nfor (var i = 0; i < headers.length; i++) {\r\n    headertext[i]=[];\r\n    for (var j = 0, headrow; headrow = headers[i].rows[0].cells[j]; j++) {\r\n      var current = headrow;\r\n      headertext[i].push(current.textContent);\r\n      }\r\n} \r\n\r\nfor (var h = 0, tbody; tbody = tablebody[h]; h++) {\r\n    for (var i = 0, row; row = tbody.rows[i]; i++) {\r\n      for (var j = 0, col; col = row.cells[j]; j++) {\r\n        col.setAttribute(\"data-th\", headertext[h][j]);\r\n      } \r\n    }\r\n}\r\n</script>','2016-03-12 03:22:30','2017-01-06 10:47:08',1,0,'','','',NULL,NULL,NULL,''),(7,'About Us','1column','','','about-us','About','<div class=\"text-center\">\r\n    <div class=\"about-us_info\">\r\n    	<div class=\"about-us_info_img\">\r\n    		<img src=\"{{view url=\'images/media/about-us_1.jpg\'}}\" alt=\"about-us_img\">\r\n    	</div>\r\n    	<div class=\"about-us_info_txt\">\r\n	        <span class=\"heading-4\">Catering to your requirements,<br>Handling your needs with care</span>\r\n	        <p>Our store is more than just another average online retailer. We sell not only top quality products, but give our customers a positive online shopping experience. Forget about struggling to do everything at once: taking care of the family, running your business, walking your dog, cleaning the house, doing the shopping, etc.</p>\r\n	        <p>Purchase the goods you need every day or just like in a few clicks or taps, depending on the device you use to access the Internet. We work to make your life more enjoyable.</p>\r\n    	</div>\r\n    </div>\r\n    <div class=\"container\">\r\n	    <div class=\"skills row\">\r\n	        <div class=\"col-xs-12 col-sm-4\">\r\n	            <div class=\"value\"><span class=\"number\" data-finish=\"14578\">0</span></div>\r\n	            <div class=\"term\">Products available</div>\r\n	        </div>\r\n	        <div class=\"col-xs-12 col-sm-4\">\r\n	            <div class=\"value\"><span class=\"number\" data-finish=\"89\">0</span>%</div>\r\n	            <div class=\"term\">Clients come back</div>\r\n	        </div>\r\n	        <div class=\"col-xs-12 col-sm-4\">\r\n	            <div class=\"value\"><span class=\"number\" data-finish=\"245789\">0</span></div>\r\n	            <div class=\"term\">Site members</div>\r\n	        </div>\r\n	    </div>\r\n    </div>\r\n\r\n    <div class=\"about-us_services\">\r\n    	<ul>\r\n    		<li>\r\n    			<div class=\"about-us_services_txt\">\r\n    				<i class=\"nc-icon-outline ui-1_zoom\"></i>\r\n    				<h4>For Convenience of Choice</h4>\r\n    				<p>We think about the convenience of your choice. Our products are supplied with star rating that should help hesitant buyers to take a decision. What’s more, you can search our site if you know exactly what you are looking for or use a bunch of different filters that will considerably save your time and efforts.</p>\r\n    			</div>\r\n    		</li>\r\n    		<li>\r\n    			<img src=\"{{view url=\'images/media/about-us_2.jpg\'}}\" alt=\"about-us_img\">\r\n    		</li>\r\n    		<li>\r\n    			<div class=\"about-us_services_txt\">\r\n    				<i class=\"nc-icon-outline business_award-48\"></i>\r\n    				<h4>The Highest Quality of Products</h4>\r\n    				<p>We guarantee the highest quality of the products we sell. Several decades of successful operation and millions of happy customers let us feel certain about that. Besides, all items we sell pass thorough quality control, so no characteristics mismatch can escape the eye of our professionals.</p>\r\n    			</div>\r\n    		</li>\r\n    		<li>\r\n    			<img src=\"{{view url=\'images/media/about-us_3.jpg\'}}\" alt=\"about-us_img\">\r\n    		</li>\r\n    		<li>\r\n    			<div class=\"about-us_services_txt\">\r\n    				<i class=\"nc-icon-outline files_box\"></i>\r\n    				<h4>Delivery to all regions</h4>\r\n    				<p>We deliver our goods worldwide. No matter where you live, your order will be shipped in time and delivered right to your door or to any other location you have stated. The packages are handled with utmost care, so the ordered products will be handed to you safe and sound, just like you expect them to be.</p>\r\n    			</div>\r\n    		</li>\r\n    		<li>\r\n    			<img src=\"{{view url=\'images/media/about-us_4.jpg\'}}\" alt=\"about-us_img\">\r\n    		</li>\r\n    	</ul>\r\n    </div>\r\n\r\n 	<div class=\"container team\">\r\n	    <h3>Our team</h3>\r\n	    <ul class=\"row\">\r\n	        <li class=\"col-xs-12 col-sm-3\">\r\n	            <figure>\r\n	            	<a href=\"#\" title=\"Robert Johnson\"><img src=\"{{view url=\'images/media/team1.jpg\'}}\" alt=\"Robert Johnson\"></a>\r\n		            <span class=\"team_name\"><a href=\"#\" title=\"Robert Johnson\">Robert Johnson</a></span>\r\n		            <p>Senior salesman with 15 years of experience. He knows everything about the products he offers.</p>\r\n            	</figure>\r\n	        </li>\r\n	        <li class=\"col-xs-12 col-sm-3\">\r\n	            <figure>\r\n	            	<a href=\"#\" title=\"JESSICA PRISTON\"><img src=\"{{view url=\'images/media/team2.jpg\'}}\" alt=\"JESSICA PRISTON\"></a>\r\n		            <span class=\"team_name\"><a href=\"#\" title=\"JESSICA PRISTON\">Jessica Priston</a></span>\r\n		            <p>Mega positive shop assistant always ready to help you make the right choice and charm you with a smile.</p>\r\n            	</figure>\r\n	        </li>\r\n	        <li class=\"col-xs-12 col-sm-3\">\r\n	            <figure>\r\n	            	<a href=\"#\" title=\"SAM KROMSTAIN\"><img src=\"{{view url=\'images/media/team3.jpg\'}}\" alt=\"SAM KROMSTAIN\"></a>\r\n	            	<span class=\"team_name\"><a href=\"#\" title=\"SAM KROMSTAIN\">Sam Kromstain</a></span>\r\n	            	<p>Wholesale manager. Contact him if you want to buy a batch of the products offered at our store.</p>\r\n	            </figure>\r\n	        </li>\r\n	        <li class=\"col-xs-12 col-sm-3\">\r\n	            <figure>\r\n	            	<a href=\"#\" title=\"EDNA BARTON\"><img src=\"{{view url=\'images/media/team4.jpg\'}}\" alt=\"EDNA BARTON\"></a>\r\n	            	<span class=\"team_name\"><a href=\"#\" title=\"EDNA BARTON\">Edna Barton</a></span>\r\n	            	<p>Quality control manager. Her mission is to check the products we ship and settle quality issues if any.</p>\r\n	            </figure>\r\n	        </li>\r\n	    </ul>\r\n    </div>\r\n\r\n    <div class=\"testimonials\">\r\n        <div class=\"testimonials_inner owl-carousel owl-testimonials\">\r\n        	<blockquote>\r\n        		<i class=\"nc-icon-outline text_quote\"></i>\r\n        	    <q>Guys, you rock! Made a purchase at your store recently. The order has been shipped and delivered on time. The quality is superb! The price is quite reasonable. Told all my friends about your excellent service and the variety of choice. I think I’ll be your loyal customer in future as well. I wish your store many more years of prosperity.</q>\r\n        	    <cite>Robert Johnson</cite>\r\n        	</blockquote>\r\n        	<blockquote class=\"item\">\r\n        		<i class=\"nc-icon-outline text_quote\"></i>\r\n        	    <q>Having the distressing experience with some online shops before decided to say ‘’THANK YOU” to all personnel of this store. You are not only friendly, but deliver really good products in the shortest possible terms. In a word, I am absolutely happy with my purchase and the service. Everything was perfect!</q>\r\n        	    <cite>Jessica Priston</cite>\r\n        	</blockquote>\r\n        	<blockquote>\r\n        		<i class=\"nc-icon-outline text_quote\"></i>\r\n        	    <q>Guys, you rock! Made a purchase at your store recently. The order has been shipped and delivered on time. The quality is superb! The price is quite reasonable. Told all my friends about your excellent service and the variety of choice. I think I’ll be your loyal customer in future as well. I wish your store many more years of prosperity.</q>\r\n        	    <cite>Sam Kromstain</cite>\r\n        	</blockquote>\r\n        	<blockquote>\r\n        		<i class=\"nc-icon-outline text_quote\"></i>\r\n        	    <q>Having the distressing experience with some online shops before decided to say ‘’THANK YOU” to all personnel of this store. You are not only friendly, but deliver really good products in the shortest possible terms. In a word, I am absolutely happy with my purchase and the service. Everything was perfect!</q>\r\n        	    <cite>Edna Barton</cite>\r\n        	</blockquote>\r\n        </div>\r\n    </div>\r\n</div>','2016-03-12 03:25:42','2017-06-22 11:43:24',1,0,'<referenceContainer name=\"columns\" htmlClass=\"columns\"/>','','',NULL,NULL,NULL,''),(8,'Template settings','1column','','','template-settings','Template Settings','<div class=\"custom-page\">\r\n    <h3><em>1. Home pages configuration</em></h3>\r\n    <table class=\"data-table responsive\">\r\n        <thead>\r\n        <tr>\r\n                <th>#</th>\r\n                <th>Page Name</th>                  \r\n                <th>Page HTML (Content tab)</th>\r\n                <th>Page XML (Design tab)</th>\r\n                <th>Layout</th>\r\n        </tr>\r\n        </thead>\r\n        <tbody>\r\n            <tr>\r\n                <td>1.</td>\r\n                <td>Home Page</td>                      \r\n                <td>sources\\demo\\pages\\home_page.phtml</td>\r\n                <td>sources\\demo\\pages\\home_page.xml</td>\r\n                <td>1 column</td>                        \r\n            </tr>\r\n            <tr>\r\n                <td>2.</td>\r\n                <td>About  Us</td>                      \r\n                <td>sources\\demo\\pages\\about_us.phtml</td>\r\n                <td>sources\\demo\\pages\\about_us.xml</td>\r\n                <td>1 column</td>                 \r\n            </tr>\r\n            <tr>\r\n                <td>3.</td>\r\n                <td>Customer Service</td>                       \r\n                <td>sources\\demo\\pages\\customer_service.phtml</td>\r\n                <td>NA</td>\r\n                <td>1 column</td>\r\n            </tr>\r\n            <tr>\r\n                <td>4.</td>\r\n                <td>Privacy Policy</td>                     \r\n                <td>sources\\demo\\pages\\privacy_policy.phtml</td>\r\n                <td>NA</td>\r\n                <td>1 column</td>\r\n            </tr>\r\n            <tr>\r\n                <td>5.</td>\r\n                <td>Shipping & Delivery</td>                     \r\n                <td>sources\\demo\\pages\\shipping-delivery.phtml</td>\r\n                <td>NA</td>\r\n                <td>1 column</td>\r\n            </tr>\r\n            <tr>\r\n                <td>6.</td>\r\n                <td>FAQ</td>                     \r\n                <td>sources\\demo\\pages\\faq.phtml</td>\r\n                <td>NA</td>\r\n                <td>1 column</td>   \r\n            </tr>\r\n            <tr>\r\n                <td>7.</td>\r\n                <td>Support</td>                     \r\n                <td>sources\\demo\\pages\\support.phtml</td>\r\n                <td>NA</td>\r\n                <td>1 column</td>  \r\n            </tr>\r\n            <tr>\r\n                <td>8.</td>\r\n                <td>Guarantee</td>                     \r\n                <td>sources\\demo\\pages\\guarantee.phtml</td>\r\n                <td>NA</td>\r\n                <td>1 column</td>\r\n            </tr>\r\n            <tr>\r\n                <td>9.</td>\r\n                <td>Secure payment</td>                     \r\n                <td>sources\\demo\\pages\\secure-payment.phtml</td>\r\n                <td>NA</td>\r\n                <td>1 column</td>\r\n            </tr>\r\n            <tr>\r\n                <td>10.</td>\r\n                <td>Terms & Conditions</td>                     \r\n                <td>sources\\demo\\pages\\terms-conditions.phtml</td>\r\n                <td>NA</td>\r\n                <td>1 column</td>\r\n            </tr>\r\n        </tbody>\r\n    </table>\r\n     \r\n     \r\n     \r\n    <h3><em>2. Static blocks configuration</em></h3>\r\n     \r\n    <table class=\"data-table responsive\">\r\n        <thead>\r\n            <tr>\r\n                <th>#</th>\r\n                <th>Block Name</th>\r\n                <th>Block Title</th>\r\n                <th>Identifier</th>\r\n                <th>Content</th>            \r\n            </tr>\r\n        </thead>\r\n        <tbody>\r\n            <tr>\r\n                <td>1.</td>\r\n                <td>Footer column content 2</td>\r\n                <td>Footer column content 2</td>\r\n                <td>footer_col_2</td>\r\n                <td>sources\\demo\\blocks\\footer_col_2.phtml</td>\r\n            </tr>\r\n            <tr>\r\n                <td>2.</td>\r\n                <td>Footer column content 3</td>\r\n                <td>Footer column content 3</td>\r\n                <td>footer_col_3</td>\r\n                <td>sources\\demo\\blocks\\footer_col_3.phtml</td>\r\n            </tr>\r\n            <tr>\r\n                <td>3.</td>\r\n                <td>Footer column content 4</td>\r\n                <td>Footer column content 4</td>\r\n                <td>footer_col_4</td>\r\n                <td>sources\\demo\\blocks\\footer_col_4.phtml</td>\r\n            </tr>\r\n            <tr>\r\n                <td>4.</td>\r\n                <td>Footer column 1 title</td>\r\n                <td>Footer column 1 title</td>\r\n                <td>footer_col_1_title</td>\r\n                <td>sources\\demo\\blocks\\footer_col_1_title.phtml</td>\r\n            </tr>\r\n            <tr>\r\n                <td>5.</td>\r\n                <td>Footer column content 1</td>\r\n                <td>Footer column content 1</td>\r\n                <td>footer_col_1</td>\r\n                <td>sources\\demo\\blocks\\footer_col_1.phtml</td>\r\n            </tr>\r\n            <tr>\r\n                <td>6.</td>\r\n                <td>Banner Box</td>\r\n                <td>Banner Box</td>\r\n                <td>banner_box</td>\r\n                <td>sources\\demo\\blocks\\banner_box.phtml</td>\r\n            </tr>\r\n        </tbody>\r\n    </table>\r\n     \r\n     \r\n    <h3><em>3. Widgets configuration</em></h3>\r\n     \r\n    <table class=\"data-table responsive\">\r\n        <thead>\r\n            <tr>\r\n                <th>#</th>\r\n                <th>Widget Name</th>\r\n                <th>Widget Type</th>\r\n                <th>Block Reference</th>\r\n                <th>Template / (Static Blocks)</th>\r\n                <th>Sort Order</th>\r\n            </tr>\r\n        </thead>\r\n        <tbody>\r\n            <tr>\r\n                <td>2.</td>\r\n                <td>Banner Box</td>\r\n                <td>CMS Block</td>\r\n                <td>Main Content</td>\r\n                <td>Banner Box Block</td>\r\n                <td>1</td>\r\n            </tr>\r\n            <tr>\r\n                <td>3.</td>\r\n                <td>Slider</td>\r\n                <td>FilmSlider</td>\r\n                <td>After Page Header</td>\r\n                <td>FilmSlider Block</td>\r\n                <td>1</td>\r\n            </tr>\r\n            <tr>\r\n                <td>4.</td>\r\n                <td>Featured Products</td>\r\n                <td>CMS Block</td>\r\n                <td>Main Content</td>\r\n                <td>Featured products Block</td>\r\n                <td>2</td>\r\n            </tr>\r\n            <tr>\r\n                <td>5.</td>\r\n                <td>Latest News</td>\r\n                <td>Blog Latest Posts</td>\r\n                <td>Before Page Footer</td>\r\n                <td>Blog Latest Posts</td>\r\n                <td>1</td>\r\n            </tr>\r\n        </tbody>\r\n    </table>\r\n</div>\r\n<script>\r\nvar headertext = [];\r\nvar headers = document.querySelectorAll(\"table.data-table thead\");\r\nvar tablebody = document.querySelectorAll(\"table.data-table tbody\");\r\n\r\nfor (var i = 0; i < headers.length; i++) {\r\n    headertext[i]=[];\r\n    for (var j = 0, headrow; headrow = headers[i].rows[0].cells[j]; j++) {\r\n      var current = headrow;\r\n      headertext[i].push(current.textContent);\r\n      }\r\n} \r\n\r\nfor (var h = 0, tbody; tbody = tablebody[h]; h++) {\r\n    for (var i = 0, row; row = tbody.rows[i]; i++) {\r\n      for (var j = 0, col; col = row.cells[j]; j++) {\r\n        col.setAttribute(\"data-th\", headertext[h][j]);\r\n      } \r\n    }\r\n}\r\n</script>','2016-03-12 03:26:35','2017-06-22 11:45:28',1,0,'','','',NULL,NULL,NULL,''),(9,'Shipping & Delivery','1column','','','shipping-delivery','Shipping & Delivery','<div class=\"shipping-delivery-page row\">\r\n    <div class=\"col-md-8 col-md-preffix-2\">\r\n        <p>\r\n            So you’ve done your shopping; just how long will it be till you can rock that swanky new Axolotl-themed laptop skin? The calculator below will give you the average amount of days it takes to ship a product to your door and the best time to contact our support team. Please note that every order at Redbubble is custom printed just for you, and will take 1-3 business days to print prior to shipping.\r\n        </p>\r\n        <span class=\"heading-3\">Here are a few things to consider while you wait for your order:</span>\r\n        <ul>\r\n            <li><span>We ship in business days. Monday - Friday, excluding national holidays.</span></li>\r\n            <li><span>Shipping starts from the date you received the “Your Order Has Shipped!” email.</span></li>\r\n            <li><span>The estimate above does not include manufacturing time - we need 1-3 business days to make sure your custom order is everything you hoped it would be.</span></li>\r\n        </ul>\r\n        <p>\r\n            Redbubble is a global company - we work with production and shipping partners all over the world to get your things to your doorstep, wherever that may be. Although the vast majority of our customers will get their orders by the day listed above, actual timeframes may vary from region to region.\r\n        </p>\r\n        <div class=\"shipping-delivery-page__border\">\r\n            <span class=\"heading-3\">So when do you contact Redbubble?</span>\r\n            <span>The calculator above lets you know the best time to message us. When that day rolls around.</span>\r\n            <span>Even if your order hasn’t arrived by the listed date, it’s probably still on its way (and worth the wait).</span>\r\n        </div>\r\n        <ol class=\"shipping-delivery-page__list\">\r\n            <li>\r\n                <span class=\"heading-3 shipping-delivery-page_shipping-icon\">How much is shipping?</span>\r\n                <p>Once you’ve clicked through to Secure Checkout, you can enter your delivery address and choose a shipping method. Shipping costs are then calculated and tacked on to your subtotal at the bottom of the page.</p>\r\n            </li>\r\n            <li>\r\n                <span class=\"heading-3 shipping-delivery-page_track-icon\">Can I track my order?</span>\r\n                <p>We rely on a global network of shipping partners (UPS, FedEx, DHL) as well as local postal services (USPS) to get your order to your doorstep as soon as possible. For this reason, tracking is not always available. If your order is being sent by a trackable service, these details will be included on your orders page as well as on the shipping email we send you.</p>\r\n            </li>\r\n            <li>\r\n                <span class=\"heading-3 shipping-delivery-page_order-icon\">Where does my order ship from?</span>\r\n                <p>We rely on a global network of shipping partners (UPS, FedEx, DHL) as well as local postal services (USPS) to get your order to your doorstep as soon as possible. For this reason, tracking is not always available. If your order is being sent by a trackable service, these details will be included on your orders page as well as on the shipping email we send you.</p>\r\n            </li>\r\n        </ol>\r\n    </div>\r\n</div>','2016-09-30 01:54:35','2017-01-06 10:48:23',1,0,'','','',NULL,NULL,NULL,''),(10,'FAQ','1column','','','faq','FAQ','<div class=\"faq-page row\">\r\n    <div class=\"col-md-8 col-md-preffix-2\">\r\n        <div id=\"faq-accordion\">\r\n            <div class=\"accordion-block close\">\r\n                <div class=\"accordion-trigger close\">\r\n                    <span>Is it necessary for me to register an account in order to buy an item?</span>\r\n                </div>\r\n                <div class=\"accordion-content\">\r\n                    <p> Yes and this is made with your own convenience in mind.  By creating (or using) an account during the  purchasing process you will have 3 things made so much easier for yourself:</p>\r\n                    <ul>\r\n                        <li>- keeping track of your order\'s delivery status</li>\r\n                        <li>- changing or canceling the order</li>\r\n                        <li>- using your previous purchase history to become eligible for a Loyal Customer\'s discount</li>\r\n                    </ul>\r\n                  </div>                \r\n            </div>\r\n            <div class=\"accordion-block close\">\r\n                <div class=\"accordion-trigger close\">\r\n                    <span>Which shipping providers do you use?</span>\r\n                </div>\r\n                <div class=\"accordion-content\">\r\n                    <p> Yes and this is made with your own convenience in mind.  By creating (or using) an account during the  purchasing process you will have 3 things made so much easier for yourself:</p>\r\n                    <ul>\r\n                        <li>- keeping track of your order\'s delivery status</li>\r\n                        <li>- changing or canceling the order</li>\r\n                        <li>- using your previous purchase history to become eligible for a Loyal Customer\'s discount</li>\r\n                    </ul>\r\n                  </div>                \r\n            </div>\r\n            <div class=\"accordion-block close\">\r\n                <div class=\"accordion-trigger close\">\r\n                    <span>How long it will take to receive the furniture?</span>\r\n                </div>\r\n                <div class=\"accordion-content\">\r\n                    <p> Yes and this is made with your own convenience in mind.  By creating (or using) an account during the  purchasing process you will have 3 things made so much easier for yourself:</p>\r\n                    <ul>\r\n                        <li>- keeping track of your order\'s delivery status</li>\r\n                        <li>- changing or canceling the order</li>\r\n                        <li>- using your previous purchase history to become eligible for a Loyal Customer\'s discount</li>\r\n                    </ul>\r\n                  </div>                \r\n            </div>\r\n            <div class=\"accordion-block close\">\r\n                <div class=\"accordion-trigger close\">\r\n                    <span>How long it will take to receive the furniture?</span>\r\n                </div>\r\n                <div class=\"accordion-content\">\r\n                    <p> Yes and this is made with your own convenience in mind.  By creating (or using) an account during the  purchasing process you will have 3 things made so much easier for yourself:</p>\r\n                    <ul>\r\n                        <li>- keeping track of your order\'s delivery status</li>\r\n                        <li>- changing or canceling the order</li>\r\n                        <li>- using your previous purchase history to become eligible for a Loyal Customer\'s discount</li>\r\n                    </ul>\r\n                  </div>                \r\n            </div>\r\n            <div class=\"accordion-block close\">\r\n                <div class=\"accordion-trigger close\">\r\n                    <span>Do you offer any kind of discounts?</span>\r\n                </div>\r\n                <div class=\"accordion-content\">\r\n                    <p> Yes and this is made with your own convenience in mind.  By creating (or using) an account during the  purchasing process you will have 3 things made so much easier for yourself:</p>\r\n                    <ul>\r\n                        <li>- keeping track of your order\'s delivery status</li>\r\n                        <li>- changing or canceling the order</li>\r\n                        <li>- using your previous purchase history to become eligible for a Loyal Customer\'s discount</li>\r\n                    </ul>\r\n                  </div>                \r\n            </div>\r\n            <div class=\"accordion-block close\">\r\n                <div class=\"accordion-trigger close\">\r\n                    <span>Do you accept orders from all 50 US states?</span>\r\n                </div>\r\n                <div class=\"accordion-content\">\r\n                    <p> Yes and this is made with your own convenience in mind.  By creating (or using) an account during the  purchasing process you will have 3 things made so much easier for yourself:</p>\r\n                    <ul>\r\n                        <li>- keeping track of your order\'s delivery status</li>\r\n                        <li>- changing or canceling the order</li>\r\n                        <li>- using your previous purchase history to become eligible for a Loyal Customer\'s discount</li>\r\n                    </ul>\r\n                  </div>                \r\n            </div>\r\n        </div>\r\n    </div>\r\n</div>','2016-09-30 01:55:26','2017-01-06 10:48:42',1,0,'',NULL,NULL,NULL,NULL,NULL,''),(11,'Support','1column','','','support','Support','<div class=\"support-page row\">\r\n    <div class=\"col-md-8 col-md-preffix-2\">\r\n        <div class=\"text-block\">\r\n            <p>Our customer support department is ready to come to your aid in a 24/7 manner, be your request in a form on email ticket or a phone call... We have a team of professional managers who will consult you regarding any technical, in-stock or billing question you might have. Also, should there be any problems with the delivery or if you would want to file a return, we will help you as well!</p>\r\n        </div>\r\n        <div class=\"boxes-block\">\r\n            <h3>Have a Question?</h3>\r\n            <ul class=\"row\">\r\n                <li class=\"col-md-6\"><a href=\"#\"><div>\r\n                    <span class=\"support-page__archive-icon\">Knowledge Base</span>\r\n                </div></a></li>\r\n                <li class=\"col-md-6\"><a href=\"#\"><div>\r\n                    <span class=\"support-page__bubbles-icon\">Community Forum</span>\r\n                </div></a></li>\r\n                <li class=\"col-md-6\"><a href=\"#\"><div>\r\n                    <span class=\"support-page__bubble-question-icon\">24/7 Ticket Support</span>\r\n                </div></a></li>\r\n                <li class=\"col-md-6\"><a href=\"#\"><div>\r\n                    <span class=\"support-page__envelope-icon\">Contact us</span>\r\n                </div></a></li>\r\n            </ul>\r\n        </div>        \r\n    </div>\r\n</div>','2016-09-30 01:55:49','2017-06-08 07:59:00',1,0,'',NULL,NULL,NULL,NULL,NULL,''),(12,'Guarantee','1column','','','guarantee','Guarantee & After-Sales Service','<div class=\"guarantee-page row\">\r\n    <div class=\"col-md-8 col-md-preffix-2\">\r\n        <div class=\"text-block\">\r\n            <p>Quite often, even after we’ve chosen an item and purchased it successfully, there may be some things we might want to change or repair afterward - either during or following the delivery process, when filing a return or applying for using our warranty. Here we\'ll try to explain in plain terms how does our store’s warranty policy works and how you can be using it when shopping with us!</p>\r\n        </div>\r\n        <div class=\"text-block\">\r\n            <h3>What Products are Provided with the Warranty?</h3>\r\n            <p>Some of our furniture items apply for an almost unconditional Lifetime Warranty. The items included in this policy are sofas, couches, love seats, upholstered chairs, ottomans, sectionals, and sleepers. As a retailer we warrant these components to you, the original retail purchaser, to be free from material manufacturing defects. The lifetime duration of the Warranty means the standardized usage cycle for a specific furniture item.</p>\r\n            <ul>\r\n                <li>\r\n                    <h4>Repair & Refurbishing</h4>\r\n                    <span>Our store will pay, within one year from the date of purchase, reasonable and conditional labor rates for refurbishing or replacing the defective parts and shipping costs.</span>\r\n                </li>\r\n                <li>\r\n                    <h4>Different Types of Warranty</h4>\r\n                    <span>While for some items we have a lifetime warranty, the springs in all of our items are offered with a 5 Year Limited type of a Warranty.</span>\r\n                </li>\r\n                <li>\r\n                    <h4>Warranty Exceptions</h4>\r\n                    <span>All seat cushion cores have a natural tendencey to become softer during a normal usage cycle, and will conform to the shape of the user. A Limited 1 Year Warranty applies.</span>\r\n                </li>\r\n            </ul>\r\n        </div>\r\n        <div class=\"text-block\">\r\n            <h3>Where to Apply for Warranty Services?</h3>\r\n            <p>Under these Limited Warranties, all of the legal liability of our store is limited to repair, or  if required (or requested by the customer), replacement. We are  ready to pay, within one year from the date of purchase, reasonable and customary labor rates to repair or replace the defective parts and shipping costs from the retailer...</p>\r\n            <p>These Limited Warranties are not applicable for any of our products which ave been altered by any person, dealer, or company without the express written authorization of our store. PLease note, that some States Do Not Allow Limitations On How Long An Implied Warranty Lasts, So The Above Limitations May Not Apply To You.</p>\r\n        </div>\r\n        <div class=\"text-block\">\r\n            <h3>In What Cases the Warranty is Not Provided?</h3>\r\n            <p>There can be two limits for the Warranties issued with the purchase of the furniture items on our website.</p>\r\n            <ul class=\"row\">\r\n                <li class=\"col-md-6\">\r\n                    <h4>1, 3 & 5 Years Limited Warranty</h4>\r\n                    <span>The first one is the Warranty time frame, if it is limited to 1, 3 or 5 years. Hence the Lifetime Warranty is not time-restricted.</span>\r\n                </li>\r\n                <li class=\"col-md-6\">\r\n                    <h4>Regular Usage Check</h4>\r\n                    <span>The second one is the examination of the item by our customer support agent, making sure the usage was regular.</span>\r\n                </li>\r\n            </ul>\r\n        </div>\r\n        <div class=\"text-block\">\r\n            <h3>Change and Return</h3>\r\n            <p>Filing a change or a return is an easy process, requiring nothing more than your proof of purchase (which usually is the receipt you received), the item itself and the return label printed out by you and put at the top of the package...</p>\r\n        </div>    \r\n    </div>\r\n</div>','2016-09-30 01:56:24','2017-01-06 10:49:15',1,0,'',NULL,NULL,NULL,NULL,NULL,''),(13,'Secure payment','1column','','','secure-payment','Secure payment','<div class=\"secure-payment-page row\">\r\n    <div class=\"col-md-8 col-md-preffix-2\">\r\n        <p>\r\n            When it comes to purchasing something, anything online, the security question towers above everything else. We do not take our store’s overall cyber security and particularly the billing process security lightly. We can assure you that all of your shopping here will be a fun and safe experience, enhanced by the all of the factors listed below.\r\n        </p>\r\n        <ul>\r\n            <li>\r\n                <h4>SSL Certificate</h4>\r\n                <span>If the website has an SLL certificate, this means that the owners care about your shopping experience being secure, safe and sound and want to make sure that all the data (including financial) that you enter on our website will be securely encrypted!</span>\r\n            </li>\r\n            <li>\r\n                <h4>Multiple Gateways</h4>\r\n                <span>When we were considering which payment gateways to use on our website, the choice narrowed down to 5 most universal ones: Visa; MasterCard; PayPal; Discover; Stripe.</span>\r\n            </li>\r\n            <li>\r\n                <h4>24/7 Customer Support</h4>\r\n                <span>Also, it is comforting to know that should you experience any kind of technical bump in the road during the checkout process, you can always address our customer support department with your billing questions!</span>\r\n            </li>\r\n        </ul>\r\n        <div class=\"secure-payment_icons\">\r\n            <ul>\r\n                <li><a href=\"#\" class=\"fa fa-cc-visa\"></a></li>\r\n                <li><a href=\"#\" class=\"fa fa-cc-mastercard\"></a></li>\r\n                <li><a href=\"#\" class=\"fa fa-cc-paypal\"></a></li>\r\n                <li><a href=\"#\" class=\"fa fa-cc-discover\"></a></li>\r\n                <li><a href=\"#\" class=\"fa fa-cc-stripe\"></a></li>\r\n            </ul>\r\n        </div>\r\n    </div>\r\n</div>','2016-09-30 01:57:19','2017-01-06 10:49:30',1,0,'',NULL,NULL,NULL,NULL,NULL,''),(14,'Terms & Conditions','1column','','','terms-conditions','Terms & Conditions','<div class=\"terms-conditions-page row\">\r\n    <div class=\"col-md-8 col-md-preffix-2\">\r\n        <div class=\"text-block\">\r\n            <p>This Policy is projected to all personal information and sensitive personal data or information that is given by or obtained from any person who visits or uses or accesses the website (\"User\"). We reserve the right to modify or review the details of this Policy without prior notice and the revised Policy will be in effect from the day of uploading.  Therefore, Users are requested to periodically visit the website and review the policy.</p>\r\n            <ul>\r\n                <li>\r\n                    <h4>Rule 1</h4>\r\n                    <p>A User may be required to give away some Personal Information, including Sensitive Personal Information while browsing through the website or for availing services at the website.\r\n</p>\r\n                </li>\r\n                <li>\r\n                    <h4>Rule 2</h4>\r\n                    <p>Personal Information disclosed to Us by a User will be used by Us for one or more of the following purposes: (a) to help Us in creating content that is relevant to the User; (b)  to collect a database of all the Personal Information collected from User</p>\r\n                </li>\r\n                <li>\r\n                    <h4>Rule 3</h4>\r\n                    <p>When a User visits the website, one or more cookies shall be sent to a computer or the device being used by the User to visit the websites. Cookies are used upscale the quality of the services provided by Us, including for keeping User preferences...</p>\r\n                </li>\r\n            </ul>\r\n        </div>        \r\n    </div>\r\n</div>','2016-09-30 01:58:38','2017-01-06 10:49:54',1,0,'',NULL,NULL,NULL,NULL,NULL,'');

--
-- Table structure for table `cms_page_store`
--

CREATE TABLE `cms_page_store` (
  `page_id` smallint(6) NOT NULL COMMENT 'Page ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`page_id`,`store_id`),
  KEY `CMS_PAGE_STORE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CMS Page To Store Linkage Table';

--
-- Dumping data for table `cms_page_store`
--

INSERT INTO `cms_page_store` VALUES (1,0),(2,0),(3,0),(4,0),(6,0),(7,0),(8,0),(9,0),(10,0),(11,0),(12,0),(13,0),(14,0);

--
-- Table structure for table `core_config_data`
--

CREATE TABLE `core_config_data` (
  `config_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Config Id',
  `scope` varchar(8) NOT NULL DEFAULT 'default' COMMENT 'Config Scope',
  `scope_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Config Scope Id',
  `path` varchar(255) NOT NULL DEFAULT 'general' COMMENT 'Config Path',
  `value` text COMMENT 'Config Value',
  PRIMARY KEY (`config_id`),
  UNIQUE KEY `CORE_CONFIG_DATA_SCOPE_SCOPE_ID_PATH` (`scope`,`scope_id`,`path`)
) ENGINE=InnoDB AUTO_INCREMENT=508 DEFAULT CHARSET=utf8 COMMENT='Config Data';

--
-- Dumping data for table `core_config_data`
--

INSERT INTO `core_config_data` VALUES ('1','default','0','web/seo/use_rewrites','1'),('2','default','0','web/unsecure/base_url','http://192.168.44.82/theme099/'),('3','default','0','web/secure/base_url','https://192.168.0.104/zero/'),('4','default','0','general/locale/code','en_US'),('5','default','0','web/secure/use_in_frontend',NULL),('6','default','0','web/secure/use_in_adminhtml',NULL),('7','default','0','general/locale/timezone','America/Chicago'),('8','default','0','currency/options/base','USD'),('9','default','0','currency/options/default','USD'),('10','default','0','currency/options/allow','EUR,USD'),('11','default','0','general/region/display_all','1'),('12','default','0','general/region/state_required','AT,BR,CA,CH,EE,ES,FI,HR,LT,LV,RO,US'),('13','default','0','catalog/category/root_id',NULL),('14','default','0','design/theme/theme_id','5'),('16','default','0','design/head/default_title','Magento Commerce'),('17','default','0','design/head/title_prefix',NULL),('18','default','0','design/head/title_suffix',NULL),('19','default','0','design/head/default_description','Default Description'),('20','default','0','design/head/default_keywords','Magento, Varien, E-commerce'),('21','default','0','design/head/includes',NULL),('22','default','0','design/head/demonotice','0'),('24','default','0','design/search_engine_robots/default_robots','INDEX,FOLLOW'),('25','default','0','design/search_engine_robots/custom_instructions',NULL),('26','default','0','design/header/logo_width',NULL),('27','default','0','design/header/logo_height',NULL),('28','default','0','design/header/logo_alt','Magento Commerce'),('29','default','0','design/header/welcome','Welcome to our online store!'),('31','default','0','design/footer/copyright',NULL),('32','default','0','design/footer/absolute_footer',NULL),('33','default','0','design/watermark/image_size',NULL),('34','default','0','design/watermark/image_imageOpacity',NULL),('35','default','0','design/watermark/image_position','stretch'),('36','default','0','design/watermark/small_image_size',NULL),('37','default','0','design/watermark/small_image_imageOpacity',NULL),('38','default','0','design/watermark/small_image_position','stretch'),('39','default','0','design/watermark/swatch_image_size',NULL),('40','default','0','design/watermark/swatch_image_imageOpacity',NULL),('41','default','0','design/watermark/swatch_image_position','stretch'),('42','default','0','design/watermark/thumbnail_size',NULL),('43','default','0','design/watermark/thumbnail_imageOpacity',NULL),('44','default','0','design/watermark/thumbnail_position','stretch'),('49','default','0','design/pagination/pagination_frame','5'),('50','default','0','design/pagination/pagination_frame_skip',NULL),('51','default','0','design/pagination/anchor_text_for_previous',NULL),('52','default','0','design/pagination/anchor_text_for_next',NULL),('53','default','0','design/email/logo_alt',NULL),('54','default','0','design/email/logo_width',NULL),('55','default','0','design/email/logo_height',NULL),('56','default','0','design/email/header_template','design_email_header_template'),('57','default','0','design/email/footer_template','design_email_footer_template'),('59','default','0','cms/wysiwyg/enabled','hidden'),('60','default','0','cms/wysiwyg/use_static_urls_in_catalog','0'),('61','default','0','cataloginventory/options/can_back_in_stock','1'),('62','default','0','cataloginventory/options/can_subtract','1'),('63','default','0','cataloginventory/options/show_out_of_stock','1'),('64','default','0','cataloginventory/options/stock_threshold_qty','10000'),('65','default','0','cataloginventory/options/display_product_stock_status','1'),('66','default','0','cataloginventory/item_options/manage_stock','1'),('67','default','0','cataloginventory/item_options/backorders','0'),('68','default','0','cataloginventory/item_options/max_sale_qty','10000'),('69','default','0','cataloginventory/item_options/min_qty','0'),('70','default','0','cataloginventory/item_options/min_sale_qty','1'),('71','default','0','cataloginventory/item_options/notify_stock_qty','1'),('72','default','0','cataloginventory/item_options/enable_qty_increments','0'),('73','default','0','cataloginventory/item_options/auto_return','0'),('74','default','0','catalog/fields_masks/sku','{{name}}'),('75','default','0','catalog/fields_masks/meta_title','{{name}}'),('76','default','0','catalog/fields_masks/meta_keyword','{{name}}'),('77','default','0','catalog/fields_masks/meta_description','{{name}} {{description}}'),('78','default','0','catalog/review/allow_guest','1'),('79','default','0','catalog/frontend/list_mode','grid-list'),('80','default','0','catalog/frontend/grid_per_page_values','9,15,30'),('81','default','0','catalog/frontend/grid_per_page','9'),('82','default','0','catalog/frontend/list_per_page_values','5,10,15,20,25'),('83','default','0','catalog/frontend/list_per_page','10'),('84','default','0','catalog/frontend/list_allow_all','0'),('85','default','0','catalog/frontend/default_sort_by','position'),('86','default','0','catalog/frontend/flat_catalog_category','1'),('87','default','0','catalog/frontend/flat_catalog_product','1'),('88','default','0','catalog/frontend/parse_url_directives','1'),('89','default','0','catalog/frontend/swatches_per_product','16'),('90','default','0','catalog/productalert/allow_price','0'),('91','default','0','catalog/productalert/email_price_template','catalog_productalert_email_price_template'),('92','default','0','catalog/productalert/allow_stock','0'),('93','default','0','catalog/productalert/email_stock_template','catalog_productalert_email_stock_template'),('94','default','0','catalog/productalert/email_identity','general'),('95','default','0','catalog/productalert_cron/frequency','D'),('96','default','0','crontab/default/jobs/catalog_product_alert/schedule/cron_expr','0 0 * * *'),('97','default','0','crontab/default/jobs/catalog_product_alert/run/model',NULL),('98','default','0','catalog/productalert_cron/time','00,00,00'),('99','default','0','catalog/productalert_cron/error_email',NULL),('100','default','0','catalog/productalert_cron/error_email_identity','general'),('101','default','0','catalog/productalert_cron/error_email_template','catalog_productalert_cron_error_email_template'),('102','default','0','catalog/recently_products/scope','website'),('103','default','0','catalog/recently_products/viewed_count','5'),('104','default','0','catalog/recently_products/compared_count','5'),('105','default','0','catalog/product_video/youtube_api_key',' AIzaSyCIMveVYEZDh6Ok-cmppYaU7m14gz_qadE'),('106','default','0','catalog/product_video/play_if_base','0'),('107','default','0','catalog/product_video/show_related','0'),('108','default','0','catalog/product_video/video_auto_restart','0'),('109','default','0','catalog/price/scope','0'),('110','default','0','catalog/layered_navigation/display_product_count','1'),('111','default','0','catalog/layered_navigation/price_range_calculation','auto'),('112','default','0','catalog/search/min_query_length','1'),('113','default','0','catalog/search/max_query_length','128'),('114','default','0','catalog/search/engine','mysql'),('115','default','0','catalog/seo/search_terms','1'),('116','default','0','catalog/seo/product_url_suffix','.html'),('117','default','0','catalog/seo/category_url_suffix','.html'),('118','default','0','catalog/seo/product_use_categories','0'),('119','default','0','catalog/seo/save_rewrites_history','1'),('120','default','0','catalog/seo/title_separator','-'),('121','default','0','catalog/seo/category_canonical_tag','1'),('122','default','0','catalog/seo/product_canonical_tag','1'),('123','default','0','catalog/navigation/max_depth','0'),('124','default','0','catalog/downloadable/order_item_status','9'),('125','default','0','catalog/downloadable/downloads_number','0'),('126','default','0','catalog/downloadable/shareable','0'),('127','default','0','catalog/downloadable/samples_title','Samples'),('128','default','0','catalog/downloadable/links_title','Links'),('129','default','0','catalog/downloadable/links_target_new_window','1'),('130','default','0','catalog/downloadable/content_disposition','inline'),('131','default','0','catalog/downloadable/disable_guest_checkout','1'),('132','default','0','catalog/custom_options/use_calendar','0'),('133','default','0','catalog/custom_options/date_fields_order','m,d,y'),('134','default','0','catalog/custom_options/time_format','12h'),('135','default','0','catalog/custom_options/year_range',','),('136','default','0','catalog/placeholder/image_placeholder',NULL),('137','default','0','catalog/placeholder/small_image_placeholder',NULL),('138','default','0','catalog/placeholder/swatch_image_placeholder',NULL),('139','default','0','catalog/placeholder/thumbnail_placeholder',NULL),('140','default','0','currency/webservicex/timeout','100'),('141','default','0','currency/import/enabled','0'),('142','default','0','currency/import/service','webservicex'),('143','default','0','crontab/default/jobs/currency_rates_update/schedule/cron_expr','0 0 * * *'),('144','default','0','currency/import/time','00,00,00'),('145','default','0','currency/import/frequency','D'),('146','default','0','currency/import/error_email',NULL),('147','default','0','currency/import/error_email_identity','general'),('148','default','0','currency/import/error_email_template','currency_import_error_email_template'),('155','default','0','tm_blog/general/active','1'),('156','default','0','tm_blog/general/toplink_active','1'),('157','default','0','tm_blog/general/toplink_label','Blog'),('158','default','0','tm_blog/general/title','Blog'),('159','default','0','tm_blog/general/meta_keywords',NULL),('160','default','0','tm_blog/general/meta_description',NULL),('161','default','0','tm_blog/general/route','blog'),('162','default','0','tm_blog/general/limits','3/6/9'),('163','default','0','tm_blog/general/list_layout',NULL),('164','default','0','tm_blog/general/post_layout',NULL),('165','default','0','tm_blog/post_view/related_posts/enabled','1'),('166','default','0','tm_blog/post_view/related_posts/posts_number','5'),('167','default','0','tm_blog/post_view/related_products/enabled','1'),('168','default','0','tm_blog/post_view/related_products/products_number','5'),('169','default','0','google_map/general/api_key',NULL),('170','default','0','google_map/home/active','0'),('171','default','0','google_map/home/styles',NULL),('172','default','0','google_map/home/markers','a:0:{}'),('173','default','0','google_map/contacts/active','1'),('174','default','0','google_map/contacts/coordinates','40.5899796,-73.8820439'),('175','default','0','google_map/contacts/zoom','8'),('176','default','0','google_map/contacts/map_type','ROADMAP'),('177','default','0','google_map/contacts/width','100%'),('178','default','0','google_map/contacts/height','375'),('179','default','0','google_map/contacts/styles',NULL),('180','default','0','google_map/contacts/ui','0'),('181','default','0','google_map/contacts/scrollwheel','1'),('182','default','0','google_map/contacts/draggable','1'),('183','default','0','google_map/contacts/markers','a:0:{}'),('184','default','0','google_map/footer/active','0'),('185','default','0','google_map/footer/styles',NULL),('186','default','0','google_map/footer/markers','a:0:{}'),('187','stores','1','design/head/title_prefix',NULL),('188','stores','1','design/head/title_suffix',NULL),('189','stores','1','design/head/includes',NULL),('193','stores','1','design/footer/absolute_footer',NULL),('194','stores','1','design/pagination/pagination_frame_skip',NULL),('195','stores','1','design/pagination/anchor_text_for_previous',NULL),('196','stores','1','design/pagination/anchor_text_for_next',NULL),('197','stores','1','design/watermark/image_size',NULL),('198','stores','1','design/watermark/image_imageOpacity',NULL),('199','stores','1','design/watermark/small_image_size',NULL),('200','stores','1','design/watermark/small_image_imageOpacity',NULL),('201','stores','1','design/watermark/thumbnail_size',NULL),('202','stores','1','design/watermark/thumbnail_imageOpacity',NULL),('203','stores','1','design/email/logo_alt',NULL),('204','stores','1','design/email/logo_width',NULL),('205','stores','1','design/email/logo_height',NULL),('206','stores','1','design/watermark/swatch_image_size',NULL),('207','stores','1','design/watermark/swatch_image_imageOpacity',NULL),('208','default','0','theme_options/general/import_file',',,,4,0,,,,4,0,,,,4,0,,,,4,0,,,,4,0'),('209','default','0','theme_options/general/logo_settings/logo_type','image'),('210','default','0','theme_options/general/logo_settings/logo_width','180'),('211','default','0','theme_options/general/logo_settings/logo_height','26'),('212','default','0','theme_options/general/logo_settings/logo_alt',NULL),('213','default','0','theme_options/general/logo_settings/logo_image','default/logo.png'),('214','default','0','theme_options/general/seo_settings/welcome_text','Welcome to our online store!'),('215','default','0','theme_options/general/seo_settings/site_title','Trendy'),('216','default','0','theme_options/general/seo_settings/description',NULL),('217','default','0','theme_options/general/seo_settings/keywords',NULL),('218','default','0','theme_options/general/seo_settings/copyright','&copy; <script type=\"text/javascript\">var mdate = new Date(); document.write(mdate.getFullYear());</script> Magento Demo Store. All Rights Reserved.'),('219','default','0','theme_options/general/seo_settings/favicon','default/favicon.png'),('220','default','0','theme_options/typography/primary_font_family',NULL),('221','default','0','theme_options/typography/secondary_font_family',NULL),('222','default','0','theme_options/typography/primary_font_size',NULL),('223','default','0','theme_options/typography/primary_line_height',NULL),('224','default','0','theme_options/category_page/grid_view/columns_number',NULL),('225','default','0','theme_options/category_page/grid_view/hover_type','0'),('226','default','0','theme_options/category_page/grid_view/image_width','310'),('227','default','0','theme_options/category_page/grid_view/image_height','420'),('228','default','0','theme_options/category_page/grid_view/image_aspect_ratio','1'),('229','default','0','theme_options/category_page/grid_view/show_swatches','1'),('230','default','0','theme_options/category_page/grid_view/show_compare','1'),('231','default','0','theme_options/category_page/grid_view/show_wishlist','1'),('232','default','0','theme_options/category_page/grid_view/show_reviews','1'),('233','default','0','theme_options/category_page/grid_view/show_desc','0'),('234','default','0','theme_options/category_page/list_view/image_width','310'),('235','default','0','theme_options/category_page/list_view/image_height','420'),('236','default','0','theme_options/category_page/list_view/image_aspect_ratio','1'),('237','default','0','theme_options/category_page/list_view/show_swatches','1'),('238','default','0','theme_options/category_page/list_view/show_compare','1'),('239','default','0','theme_options/category_page/list_view/show_wishlist','1'),('240','default','0','theme_options/category_page/list_view/show_reviews','1'),('241','default','0','theme_options/category_page/list_view/show_desc','1'),('242','default','0','theme_options/product_page/general/show_stock','1'),('243','default','0','theme_options/product_page/general/show_sku','1'),('244','default','0','theme_options/product_page/general/show_compare','1'),('245','default','0','theme_options/product_page/general/show_wishlist','1'),('246','default','0','theme_options/product_page/general/show_email_to_friend','1'),('247','default','0','theme_options/product_page/general/show_reviews','1'),('248','default','0','theme_options/product_page/general/show_short_desc','1'),('249','default','0','theme_options/product_page/general/related/show_related','1'),('250','default','0','theme_options/product_page/general/upsell/show_upsell','1'),('251','default','0','theme_options/product_page/tabs/description','1'),('252','default','0','theme_options/product_page/tabs/description_tab_title',NULL),('253','default','0','theme_options/product_page/tabs/additional','1'),('254','default','0','theme_options/product_page/tabs/additional_tab_title',NULL),('255','default','0','theme_options/product_page/tabs/review','1'),('256','default','0','theme_options/product_page/tabs/review_tab_title',NULL),('257','default','0','theme_options/product_page/gallery/image_width','400'),('258','default','0','theme_options/product_page/gallery/image_height','400'),('259','default','0','theme_options/header/general/sticky_menu','0'),('260','default','0','theme_options/header/social/show_social','0'),('261','default','0','theme_options/header/social/image_icon','[]'),('262','default','0','theme_options/header/social/font_icon','[]'),('263','default','0','theme_options/footer/social/show_social','font'),('264','default','0','theme_options/footer/social/image_icon','[]'),('265','default','0','theme_options/footer/social/font_icon','{\"_1510835247698_698\":{\"css_class\":\"fa fa-facebook\",\"social_url\":\"#\",\"font_size\":\"12px\",\"line_height\":\"18px\"},\"_1510835248464_464\":{\"css_class\":\"fa fa-twitter\",\"social_url\":\"#\",\"font_size\":\"12px\",\"line_height\":\"18px\"},\"_1510835248944_944\":{\"css_class\":\"fa fa-instagram\",\"social_url\":\"#\",\"font_size\":\"12px\",\"line_height\":\"18px\"},\"_1510835249433_433\":{\"css_class\":\"fa fa-youtube\",\"social_url\":\"#\",\"font_size\":\"12px\",\"line_height\":\"18px\"},\"_1510835249976_976\":{\"css_class\":\"fa fa-google-plus\",\"social_url\":\"#\",\"font_size\":\"12px\",\"line_height\":\"18px\"}}'),('266','default','0','theme_options/sidebar/wishlist','1'),('267','default','0','theme_options/sidebar/compare','1'),('268','default','0','theme_options/sidebar/recently_viewed','1'),('269','default','0','theme_options/sidebar/recently_compared','1'),('270','default','0','theme_options/sidebar/orders','1'),('271','default','0','ajaxcompare/config/ajaxcompare_product_active','1'),('272','default','0','ajaxsearch/ajaxsearch/ajaxsearch_default_active','1'),('273','default','0','ajaxsearch/ajaxsearch/ajaxsearch_category_active','1'),('274','default','0','ajaxsearch/ajaxsearch/ajaxsearch_product_active','1'),('275','default','0','ajaxsearch/ajaxsearch/ajaxsearch_default_number','10'),('276','default','0','ajaxsearch/ajaxsearch/ajaxsearch_category_number','10'),('277','default','0','ajaxsearch/ajaxsearch/ajaxsearch_product_number','10'),('278','default','0','tm_blog/general/menu_active','0'),('279','default','0','tm_blog/general/recaptcha','0'),('280','default','0','tm_blog/general/recaptcha_api',NULL),('281','default','0','tm_blog/general/recaptcha_secret',NULL),('282','default','0','tm_blog/general/data_format','M d, Y'),('283','default','0','tm_blog/post_view/related_posts/layout_view','0'),('284','default','0','tm_blog/post_view/related_posts/posts_number_per_view','4'),('285','default','0','tm_blog/post_view/related_products/products_number_per_view','3'),('286','default','0','tm_blog/post_view/related_products/show_links','1'),('287','default','0','tm_blog/sidebar/show_categories','0'),('288','default','0','tm_blog/sidebar/categories_number',NULL),('289','default','0','tm_blog/sidebar/show_posts','0'),('290','default','0','tm_blog/sidebar/posts_number',NULL),('291','default','0','tm_blog/sidebar/show_comments','0'),('292','default','0','tm_blog/sidebar/comments_number',NULL),('293','default','0','tm_blog/social_sharing/general/enabled','0'),('294','default','0','tm_blog/social_sharing/general/profile_id',NULL),('295','default','0','tm_blog/social_sharing/look_and_feel/custom_button',NULL),('296','default','0','tm_blog/social_sharing/look_and_feel/custom_code',NULL),('297','default','0','tm_blog/social_sharing/custom_metadata/url',NULL),('298','default','0','tm_blog/social_sharing/custom_metadata/title',NULL),('299','default','0','tm_blog/social_sharing/custom_metadata/description',NULL),('300','default','0','tm_blog/social_sharing/custom_service/name',NULL),('301','default','0','tm_blog/social_sharing/custom_service/url',NULL),('302','default','0','tm_blog/social_sharing/custom_service/icon',NULL),('303','default','0','tm_blog/social_sharing/api/exclude_services',NULL),('304','default','0','tm_blog/social_sharing/api/compact_menu_services',NULL),('305','default','0','tm_blog/social_sharing/api/expanded_menu_services',NULL),('306','default','0','tm_blog/social_sharing/api/compact_menu_hover','0'),('307','default','0','tm_blog/social_sharing/api/delay',NULL),('308','default','0','tm_blog/social_sharing/api/compact_menu_direction','0'),('309','default','0','tm_blog/social_sharing/api/new_window','0'),('310','default','0','tm_blog/social_sharing/api/menu_language',NULL),('311','default','0','tm_blog/social_sharing/api/offset_top',NULL),('312','default','0','tm_blog/social_sharing/api/offset_left',NULL),('313','default','0','tm_blog/social_sharing/api/load_addthis_css','0'),('314','default','0','tm_blog/social_sharing/api/track_clickbacks','0'),('315','default','0','tm_blog/social_sharing/api/google_analytics_id',NULL),('316','default','0','newsletter_popup/general/enabled','1'),('317','default','0','newsletter_popup/general/show_on_startup','1'),('318','default','0','newsletter_popup/general/show_on_footer','0'),('319','default','0','newsletter_popup/general/title','Ohhh! Hey! <br />Become an inside'),('320','default','0','newsletter_popup/general/content','and gain access to exclusive offers, <br />\r\nnew arrivals, and more!'),('321','default','0','newsletter_popup/general/submit_button','buy now'),('322','default','0','newsletter_popup/general/cancel_button','Cancel'),('323','default','0','newsletter_popup/general/popup_width','1300'),('324','default','0','newsletter_popup/general/show_subscription_link_in_footer','1'),('325','default','0','newsletter_popup/general/footer_link_text','Newsletter Subscription'),('326','default','0','newsletter_popup/general/popup_show_delay','0'),('327','default','0','newsletter_popup/general/button_color','#ffffff'),('328','default','0','newsletter_popup/general/button_hover_color','#ffffff'),('329','default','0','newsletter_popup/general/custom_css_class',NULL),('330','default','0','newsletter_popup/social/enabled_all','0'),('331','default','0','newsletter_popup/social/facebook_settings/enabled','0'),('332','default','0','newsletter_popup/social/facebook_settings/use_default_icon_colors','0'),('333','default','0','newsletter_popup/social/facebook_settings/link',NULL),('334','default','0','newsletter_popup/social/facebook_settings/icon_background','#4e69a2'),('335','default','0','newsletter_popup/social/facebook_settings/icon_color','#ffffff'),('336','default','0','newsletter_popup/social/facebook_settings/icon_background_hover','#4e69a2'),('337','default','0','newsletter_popup/social/facebook_settings/icon_hover_color','#ffffff'),('338','default','0','newsletter_popup/social/twitter_settings/enabled','0'),('339','default','0','newsletter_popup/social/twitter_settings/use_default_icon_colors','0'),('340','default','0','newsletter_popup/social/twitter_settings/link',NULL),('341','default','0','newsletter_popup/social/twitter_settings/icon_background','#1da1f2'),('342','default','0','newsletter_popup/social/twitter_settings/icon_color','#ffffff'),('343','default','0','newsletter_popup/social/twitter_settings/icon_background_hover','#1da1f2'),('344','default','0','newsletter_popup/social/twitter_settings/icon_hover_color','#ffffff'),('345','default','0','newsletter_popup/social/linkedin_settings/enabled','0'),('346','default','0','newsletter_popup/social/linkedin_settings/use_default_icon_colors','0'),('347','default','0','newsletter_popup/social/linkedin_settings/link',NULL),('348','default','0','newsletter_popup/social/linkedin_settings/icon_background','#0083be'),('349','default','0','newsletter_popup/social/linkedin_settings/icon_color','#ffffff'),('350','default','0','newsletter_popup/social/linkedin_settings/icon_background_hover','#0083be'),('351','default','0','newsletter_popup/social/linkedin_settings/icon_hover_color','#ffffff'),('352','default','0','newsletter_popup/social/google_settings/enabled','0'),('353','default','0','newsletter_popup/social/google_settings/use_default_icon_colors','0'),('354','default','0','newsletter_popup/social/google_settings/link',NULL),('355','default','0','newsletter_popup/social/google_settings/icon_background','#e02f2f'),('356','default','0','newsletter_popup/social/google_settings/icon_color','#ffffff'),('357','default','0','newsletter_popup/social/google_settings/icon_background_hover','#e02f2f'),('358','default','0','newsletter_popup/social/google_settings/icon_hover_color','#ffffff'),('359','default','0','newsletter_popup/social/youtube_settings/enabled','0'),('360','default','0','newsletter_popup/social/youtube_settings/use_default_icon_colors','0'),('361','default','0','newsletter_popup/social/youtube_settings/link',NULL),('362','default','0','newsletter_popup/social/youtube_settings/icon_background','#e02f2f'),('363','default','0','newsletter_popup/social/youtube_settings/icon_color','#ffffff'),('364','default','0','newsletter_popup/social/youtube_settings/icon_background_hover','#e02f2f'),('365','default','0','newsletter_popup/social/youtube_settings/icon_hover_color','#ffffff'),('366','default','0','newsletter_popup/social/vimeo_settings/enabled','0'),('367','default','0','newsletter_popup/social/vimeo_settings/use_default_icon_colors','0'),('368','default','0','newsletter_popup/social/vimeo_settings/link',NULL),('369','default','0','newsletter_popup/social/vimeo_settings/icon_background','#20b9eb'),('370','default','0','newsletter_popup/social/vimeo_settings/icon_color','#ffffff'),('371','default','0','newsletter_popup/social/vimeo_settings/icon_background_hover','#20b9eb'),('372','default','0','newsletter_popup/social/vimeo_settings/icon_hover_color','#ffffff'),('373','default','0','newsletter_popup/social/pinterest_settings/enabled','0'),('374','default','0','newsletter_popup/social/pinterest_settings/use_default_icon_colors','0'),('375','default','0','newsletter_popup/social/pinterest_settings/link',NULL),('376','default','0','newsletter_popup/social/pinterest_settings/icon_background','#e02f2f'),('377','default','0','newsletter_popup/social/pinterest_settings/icon_color','#ffffff'),('378','default','0','newsletter_popup/social/pinterest_settings/icon_background_hover','#e02f2f'),('379','default','0','newsletter_popup/social/pinterest_settings/icon_hover_color','#ffffff'),('380','default','0','newsletter_popup/social/instagram_settings/enabled','0'),('381','default','0','newsletter_popup/social/instagram_settings/use_default_icon_colors','0'),('382','default','0','newsletter_popup/social/instagram_settings/link',NULL),('383','default','0','newsletter_popup/social/instagram_settings/icon_background','#316699'),('384','default','0','newsletter_popup/social/instagram_settings/icon_color','#ffffff'),('385','default','0','newsletter_popup/social/instagram_settings/icon_background_hover','#316699'),('386','default','0','newsletter_popup/social/instagram_settings/icon_hover_color','#ffffff'),('387','default','0','newsletter_popup/social/foursquare_settings/enabled','0'),('388','default','0','newsletter_popup/social/foursquare_settings/use_default_icon_colors','0'),('389','default','0','newsletter_popup/social/foursquare_settings/link',NULL),('390','default','0','newsletter_popup/social/foursquare_settings/icon_background','#f94877'),('391','default','0','newsletter_popup/social/foursquare_settings/icon_color','#ffffff'),('392','default','0','newsletter_popup/social/foursquare_settings/icon_background_hover','#f94877'),('393','default','0','newsletter_popup/social/foursquare_settings/icon_hover_color','#ffffff'),('394','default','0','newsletter_popup/social/tumblr_settings/enabled','0'),('395','default','0','newsletter_popup/social/tumblr_settings/use_default_icon_colors','0'),('396','default','0','newsletter_popup/social/tumblr_settings/link',NULL),('397','default','0','newsletter_popup/social/tumblr_settings/icon_background','#44556b'),('398','default','0','newsletter_popup/social/tumblr_settings/icon_color','#ffffff'),('399','default','0','newsletter_popup/social/tumblr_settings/icon_background_hover','#44556b'),('400','default','0','newsletter_popup/social/tumblr_settings/icon_hover_color','#ffffff'),('401','default','0','newsletter_popup/social/rss_settings/enabled','0'),('402','default','0','newsletter_popup/social/rss_settings/use_default_icon_colors','0'),('403','default','0','newsletter_popup/social/rss_settings/link',NULL),('404','default','0','newsletter_popup/social/rss_settings/icon_background','#eb7b1d'),('405','default','0','newsletter_popup/social/rss_settings/icon_color','#ffffff'),('406','default','0','newsletter_popup/social/rss_settings/icon_background_hover','#eb7b1d'),('407','default','0','newsletter_popup/social/rss_settings/icon_hover_color','#ffffff'),('408','default','0','admin/security/use_case_sensitive_login','0'),('409','default','0','admin/security/session_lifetime','31536000'),('410','websites','1','design/pagination/pagination_frame_skip',NULL),('411','websites','1','design/pagination/anchor_text_for_previous',NULL),('412','websites','1','design/pagination/anchor_text_for_next',NULL),('413','websites','1','design/head/shortcut_icon','websites/1/favicon.png'),('414','websites','1','design/head/title_prefix',NULL),('415','websites','1','design/head/title_suffix',NULL),('416','websites','1','design/head/includes',NULL),('417','websites','1','design/header/logo_src','websites/1/logo.png'),('418','websites','1','design/header/logo_width','180'),('419','websites','1','design/header/logo_height','26'),('420','websites','1','design/header/logo_alt','Trendy'),('421','websites','1','design/footer/copyright','&copy; 2017 Magento Demo Store. All Rights Reserved.'),('422','websites','1','design/footer/absolute_footer',NULL),('423','websites','1','design/search_engine_robots/custom_instructions',NULL),('424','websites','1','design/watermark/image_size',NULL),('425','websites','1','design/watermark/image_imageOpacity',NULL),('426','websites','1','design/watermark/small_image_size',NULL),('427','websites','1','design/watermark/small_image_imageOpacity',NULL),('428','websites','1','design/watermark/thumbnail_size',NULL),('429','websites','1','design/watermark/thumbnail_imageOpacity',NULL),('430','websites','1','design/email/logo_alt',NULL),('431','websites','1','design/email/logo_width',NULL),('432','websites','1','design/email/logo_height',NULL),('433','websites','1','design/watermark/swatch_image_size',NULL),('434','websites','1','design/watermark/swatch_image_imageOpacity',NULL),('435','stores','1','design/search_engine_robots/custom_instructions',NULL),('436','default','0','currency/yahoofinance/timeout','100'),('437','default','0','currency/fixerio/timeout','100'),('438','default','0','theme_options/general/logo_settings/logo_text',NULL),('439','default','0','theme_options/general/logo_settings/logo_font_size',NULL),('440','default','0','theme_options/general/logo_settings/logo_line_height',NULL),('441','default','0','theme_options/general/logo_settings/logo_font_color',NULL),('442','default','0','theme_options/general/logo_settings/image_slogan','0'),('443','default','0','theme_options/general/logo_settings/slogan','0'),('444','default','0','theme_options/general/logo_settings/image_slogan_text',NULL),('445','default','0','theme_options/general/logo_settings/slogan_text',NULL),('446','default','0','theme_options/general/logo_settings/image_slogan_font_size',NULL),('447','default','0','theme_options/general/logo_settings/slogan_font_size',NULL),('448','default','0','theme_options/general/logo_settings/image_slogan_line_height',NULL),('449','default','0','theme_options/general/logo_settings/slogan_line_height',NULL),('450','default','0','theme_options/general/logo_settings/image_slogan_font_color',NULL),('451','default','0','theme_options/general/logo_settings/slogan_font_color',NULL),('452','default','0','theme_options/general/logo_settings/image_slogan_position','top'),('453','default','0','theme_options/general/logo_settings/slogan_position','top'),('454','default','0','theme_options/general/loader_to_top/to_top_button','1'),('455','default','0','theme_options/general/loader_to_top/preloader','1'),('456','default','0','theme_options/general/loader_to_top/preloader_type','css_preloader'),('457','default','0','theme_options/general/loader_to_top/preloader_image',NULL),('458','default','0','theme_options/category_page/grid_view/tilt_js','0'),('459','default','0','theme_options/category_page/grid_view/tilt_options','tilt_basic'),('460','default','0','theme_options/category_page/grid_view/thumb_width',NULL),('461','default','0','theme_options/category_page/grid_view/thumb_height',NULL),('462','default','0','theme_options/category_page/grid_view/slides_count',NULL),('463','default','0','theme_options/product_page/general/related/related_limit',NULL),('464','default','0','theme_options/product_page/general/related/related_image_width','310'),('465','default','0','theme_options/product_page/general/related/related_image_height','420'),('466','default','0','theme_options/product_page/general/related/show_related_checkbox','0'),('467','default','0','theme_options/product_page/general/upsell/upsell_limit','310'),('468','default','0','theme_options/product_page/general/upsell/upsell_image_width','420'),('469','default','0','theme_options/product_page/general/upsell/upsell_image_height',NULL),('470','default','0','theme_options/product_page/gallery/image_zoom','0'),('471','default','0','theme_options/header/social/social_position','left'),('472','default','0','theme_options/footer/social/social_position','right'),('473','default','0','instagram_feed/general/enabled','1'),('474','default','0','instagram_feed/general/access_token','3105625247.b3f02ed.6b15cc37ae9647ada02fb71874ae9dc6'),('475','default','0','instagram_feed/homepage/enabled','1'),('476','default','0','instagram_feed/homepage/widget_block_title',NULL),('477','default','0','instagram_feed/homepage/position','content'),('478','default','0','instagram_feed/homepage/tags','football'),('479','default','0','instagram_feed/homepage/count','6'),('480','default','0','instagram_feed/homepage/format','thumbnail'),('481','default','0','instagram_feed/homepage/image_width','400'),('482','default','0','instagram_feed/category/enabled','0'),('483','default','0','instagram_feed/category/widget_block_title',NULL),('484','default','0','instagram_feed/category/position','left'),('485','default','0','instagram_feed/category/tags',NULL),('486','default','0','instagram_feed/category/count','6'),('487','default','0','instagram_feed/category/format','thumbnail'),('488','default','0','instagram_feed/category/image_width',NULL),('489','default','0','instagram_feed/product/enabled','0'),('490','default','0','instagram_feed/product/widget_block_title',NULL),('491','default','0','instagram_feed/product/position','left'),('492','default','0','instagram_feed/product/tags',NULL),('493','default','0','instagram_feed/product/count','6'),('494','default','0','instagram_feed/product/format','thumbnail'),('495','default','0','instagram_feed/product/image_width',NULL),('496','default','0','instagram_feed/cmspage/enabled','0'),('497','default','0','instagram_feed/cmspage/widget_block_title',NULL),('498','default','0','instagram_feed/cmspage/position','left'),('499','default','0','instagram_feed/cmspage/tags',NULL),('500','default','0','instagram_feed/cmspage/count','6'),('501','default','0','instagram_feed/cmspage/format','thumbnail'),('502','default','0','instagram_feed/cmspage/image_width',NULL),('503','default','0','instagram_feed/advanced/selector_left','.sidebar-main'),('504','default','0','instagram_feed/advanced/selector_right','.sidebar-additional'),('505','default','0','instagram_feed/advanced/selector_content','.column.main'),('506','default','0','instagram_feed/advanced/selector_footer','.footer.content'),('507','default','0','tm_amp/general/enabled','1');

--
-- Table structure for table `cron_schedule`
--

CREATE TABLE `cron_schedule` (
  `schedule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Schedule Id',
  `job_code` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Job Code',
  `status` varchar(7) NOT NULL DEFAULT 'pending' COMMENT 'Status',
  `messages` text COMMENT 'Messages',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `scheduled_at` timestamp NULL DEFAULT NULL COMMENT 'Scheduled At',
  `executed_at` timestamp NULL DEFAULT NULL COMMENT 'Executed At',
  `finished_at` timestamp NULL DEFAULT NULL COMMENT 'Finished At',
  PRIMARY KEY (`schedule_id`),
  KEY `CRON_SCHEDULE_JOB_CODE` (`job_code`),
  KEY `CRON_SCHEDULE_SCHEDULED_AT_STATUS` (`scheduled_at`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cron Schedule';

--
-- Table structure for table `customer_address_entity`
--

CREATE TABLE `customer_address_entity` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment Id',
  `parent_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent Id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `is_active` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Active',
  `city` varchar(255) NOT NULL COMMENT 'City',
  `company` varchar(255) DEFAULT NULL COMMENT 'Company',
  `country_id` varchar(255) NOT NULL COMMENT 'Country',
  `fax` varchar(255) DEFAULT NULL COMMENT 'Fax',
  `firstname` varchar(255) NOT NULL COMMENT 'First Name',
  `lastname` varchar(255) NOT NULL COMMENT 'Last Name',
  `middlename` varchar(255) DEFAULT NULL COMMENT 'Middle Name',
  `postcode` varchar(255) DEFAULT NULL COMMENT 'Zip/Postal Code',
  `prefix` varchar(40) DEFAULT NULL COMMENT 'Prefix',
  `region` varchar(255) DEFAULT NULL COMMENT 'State/Province',
  `region_id` int(10) unsigned DEFAULT NULL COMMENT 'State/Province',
  `street` text NOT NULL COMMENT 'Street Address',
  `suffix` varchar(40) DEFAULT NULL COMMENT 'Suffix',
  `telephone` varchar(255) NOT NULL COMMENT 'Phone Number',
  `vat_id` varchar(255) DEFAULT NULL COMMENT 'VAT number',
  `vat_is_valid` int(10) unsigned DEFAULT NULL COMMENT 'VAT number validity',
  `vat_request_date` varchar(255) DEFAULT NULL COMMENT 'VAT number validation request date',
  `vat_request_id` varchar(255) DEFAULT NULL COMMENT 'VAT number validation request ID',
  `vat_request_success` int(10) unsigned DEFAULT NULL COMMENT 'VAT number validation request success',
  PRIMARY KEY (`entity_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_PARENT_ID` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity';

--
-- Dumping data for table `customer_address_entity`
--

INSERT INTO `customer_address_entity` VALUES ('1',NULL,'3','2017-11-30 13:18:45','2017-11-30 13:18:45',1,'demo',NULL,'US',NULL,'demo','demo',NULL,'55555',NULL,'Georgia','19','demo',NULL,'55555',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `customer_address_entity_datetime`
--

CREATE TABLE `customer_address_entity_datetime` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` datetime DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Datetime';

--
-- Table structure for table `customer_address_entity_decimal`
--

CREATE TABLE `customer_address_entity_decimal` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Decimal';

--
-- Table structure for table `customer_address_entity_int`
--

CREATE TABLE `customer_address_entity_int` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Int';

--
-- Table structure for table `customer_address_entity_text`
--

CREATE TABLE `customer_address_entity_text` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` text NOT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Text';

--
-- Table structure for table `customer_address_entity_varchar`
--

CREATE TABLE `customer_address_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Varchar';

--
-- Table structure for table `customer_eav_attribute`
--

CREATE TABLE `customer_eav_attribute` (
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute Id',
  `is_visible` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Visible',
  `input_filter` varchar(255) DEFAULT NULL COMMENT 'Input Filter',
  `multiline_count` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Multiline Count',
  `validate_rules` text COMMENT 'Validate Rules',
  `is_system` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is System',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `data_model` varchar(255) DEFAULT NULL COMMENT 'Data Model',
  `is_used_in_grid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Used in Grid',
  `is_visible_in_grid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible in Grid',
  `is_filterable_in_grid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Filterable in Grid',
  `is_searchable_in_grid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Searchable in Grid',
  PRIMARY KEY (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Eav Attribute';

--
-- Dumping data for table `customer_eav_attribute`
--

INSERT INTO `customer_eav_attribute` VALUES (1,1,NULL,0,NULL,1,'10',NULL,1,1,1,0),(2,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(3,1,NULL,0,NULL,1,'20',NULL,1,1,0,1),(4,0,NULL,0,NULL,0,'30',NULL,0,0,0,0),(5,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,'40',NULL,0,0,0,0),(6,0,NULL,0,NULL,0,'50',NULL,0,0,0,0),(7,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,'60',NULL,0,0,0,0),(8,0,NULL,0,NULL,0,'70',NULL,0,0,0,0),(9,1,NULL,0,'{\"input_validation\":\"email\"}',1,'80',NULL,1,1,1,1),(10,1,NULL,0,NULL,1,'25',NULL,1,1,1,0),(11,0,'date',0,'{\"input_validation\":\"date\"}',0,'90',NULL,1,1,1,0),(12,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(13,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(14,0,NULL,0,'{\"input_validation\":\"date\"}',1,'0',NULL,0,0,0,0),(15,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(16,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(17,0,NULL,0,'{\"max_text_length\":255}',0,'100',NULL,1,1,0,1),(18,0,NULL,0,NULL,1,'0',NULL,1,1,1,0),(19,0,NULL,0,NULL,0,'0',NULL,1,1,1,0),(20,0,NULL,0,'[]',0,'110',NULL,1,1,1,0),(21,1,NULL,0,NULL,1,'28',NULL,0,0,0,0),(22,0,NULL,0,NULL,0,'10',NULL,0,0,0,0),(23,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,'20',NULL,1,0,0,1),(24,0,NULL,0,NULL,0,'30',NULL,0,0,0,0),(25,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,'40',NULL,1,0,0,1),(26,0,NULL,0,NULL,0,'50',NULL,0,0,0,0),(27,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,'60',NULL,1,0,0,1),(28,1,NULL,2,'{\"max_text_length\":255,\"min_text_length\":1}',1,'70',NULL,1,0,0,1),(29,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,'80',NULL,1,0,0,1),(30,1,NULL,0,NULL,1,'90',NULL,1,1,1,0),(31,1,NULL,0,NULL,1,'100',NULL,1,1,0,1),(32,1,NULL,0,NULL,1,'100',NULL,0,0,0,0),(33,1,NULL,0,'[]',1,'110','Magento\\Customer\\Model\\Attribute\\Data\\Postcode',1,1,1,1),(34,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,'120',NULL,1,1,1,1),(35,0,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',0,'130',NULL,1,0,0,1),(36,1,NULL,0,NULL,1,'140',NULL,0,0,0,0),(37,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(38,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(39,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(40,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(41,0,NULL,0,NULL,0,'0',NULL,0,0,0,0),(131,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(132,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(133,0,NULL,0,NULL,1,'0',NULL,0,0,0,0);

--
-- Table structure for table `customer_eav_attribute_website`
--

CREATE TABLE `customer_eav_attribute_website` (
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `is_visible` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Visible',
  `is_required` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Required',
  `default_value` text COMMENT 'Default Value',
  `multiline_count` smallint(5) unsigned DEFAULT NULL COMMENT 'Multiline Count',
  PRIMARY KEY (`attribute_id`,`website_id`),
  KEY `CUSTOMER_EAV_ATTRIBUTE_WEBSITE_WEBSITE_ID` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Eav Attribute Website';

--
-- Dumping data for table `customer_eav_attribute_website`
--

INSERT INTO `customer_eav_attribute_website` VALUES (1,1,NULL,NULL,NULL,NULL),(3,1,NULL,NULL,NULL,NULL),(9,1,NULL,NULL,NULL,NULL),(10,1,NULL,NULL,NULL,NULL),(11,1,NULL,NULL,NULL,NULL),(17,1,NULL,NULL,NULL,NULL),(18,1,NULL,NULL,NULL,NULL),(19,1,NULL,NULL,NULL,NULL),(20,1,NULL,NULL,NULL,NULL),(21,1,NULL,NULL,NULL,NULL),(23,1,NULL,NULL,NULL,NULL),(25,1,NULL,NULL,NULL,NULL),(27,1,NULL,NULL,NULL,NULL),(28,1,NULL,NULL,NULL,NULL),(29,1,NULL,NULL,NULL,NULL),(30,1,NULL,NULL,NULL,NULL),(31,1,NULL,NULL,NULL,NULL),(32,1,NULL,NULL,NULL,NULL),(33,1,NULL,NULL,NULL,NULL),(34,1,NULL,NULL,NULL,NULL),(35,1,NULL,NULL,NULL,NULL),(36,1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `customer_entity`
--

CREATE TABLE `customer_entity` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `website_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Website Id',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Group Id',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment Id',
  `store_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Store Id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `is_active` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Active',
  `disable_auto_group_change` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Disable automatic group change based on VAT ID',
  `created_in` varchar(255) DEFAULT NULL COMMENT 'Created From',
  `prefix` varchar(40) DEFAULT NULL COMMENT 'Prefix',
  `firstname` varchar(255) DEFAULT NULL COMMENT 'First Name',
  `middlename` varchar(255) DEFAULT NULL COMMENT 'Middle Name/Initial',
  `lastname` varchar(255) DEFAULT NULL COMMENT 'Last Name',
  `suffix` varchar(40) DEFAULT NULL COMMENT 'Suffix',
  `dob` date DEFAULT NULL COMMENT 'Date Of Birth',
  `password_hash` varchar(128) DEFAULT NULL COMMENT 'Password_hash',
  `rp_token` varchar(128) DEFAULT NULL COMMENT 'Reset password token',
  `rp_token_created_at` datetime DEFAULT NULL COMMENT 'Reset password token creation time',
  `default_billing` int(10) unsigned DEFAULT NULL COMMENT 'Default Billing Address',
  `default_shipping` int(10) unsigned DEFAULT NULL COMMENT 'Default Shipping Address',
  `taxvat` varchar(50) DEFAULT NULL COMMENT 'Tax/VAT Number',
  `confirmation` varchar(64) DEFAULT NULL COMMENT 'Is Confirmed',
  `gender` smallint(5) unsigned DEFAULT NULL COMMENT 'Gender',
  `failures_num` smallint(6) DEFAULT '0' COMMENT 'Failure Number',
  `first_failure` timestamp NULL DEFAULT NULL COMMENT 'First Failure',
  `lock_expires` timestamp NULL DEFAULT NULL COMMENT 'Lock Expiration Date',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_EMAIL_WEBSITE_ID` (`email`,`website_id`),
  KEY `CUSTOMER_ENTITY_STORE_ID` (`store_id`),
  KEY `CUSTOMER_ENTITY_WEBSITE_ID` (`website_id`),
  KEY `CUSTOMER_ENTITY_FIRSTNAME` (`firstname`),
  KEY `CUSTOMER_ENTITY_LASTNAME` (`lastname`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Customer Entity';

--
-- Dumping data for table `customer_entity`
--

INSERT INTO `customer_entity` VALUES ('1',1,'admin@admin.com',1,NULL,1,'2016-03-15 21:25:53','2016-03-15 21:25:53',1,0,'English',NULL,'admin',NULL,'admin',NULL,NULL,'b969bb7321b0aa25b79664a71fb6c748d7c966be9fd2719b7cfe23db10321e3a:fnSpcnnEEpKbdzyVqLAz82fjPpHh7RMv:1','ba5c38bf6d373fccfd96f7e54524e591','2016-03-16 15:25:53',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),('2',1,'anika@gmail.com',1,NULL,1,'2017-10-23 18:00:18','2017-10-23 18:00:18',1,0,'English',NULL,'Anika',NULL,'Mood',NULL,NULL,'6126b118e894f921489a10934285d0668eb84634ac1ddea65b88d23893fa7f94:I5IlZEiYUVgYjepOwij6YSrJROznYuBG:1','946b0b71e73043c0971c4cf5e33463d3','2017-10-23 18:00:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('3',1,'demo@demo.com',1,NULL,1,'2017-11-30 11:45:51','2017-11-30 13:18:45',1,0,'English',NULL,'demo',NULL,'demo',NULL,NULL,'bd4ced5ad9a24bb66d96c4ae2b45394924e106ae643a7980c81c9f5d331ae76f:ZwQSQO5XZ0H2STHHrIocv7tcnXEWFQsg:1','19edd0a9d85e5e297a9c1724b3cd3b61','2017-11-30 11:45:52',NULL,'1',NULL,NULL,NULL,0,NULL,NULL);

--
-- Table structure for table `customer_entity_datetime`
--

CREATE TABLE `customer_entity_datetime` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` datetime DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Datetime';

--
-- Table structure for table `customer_entity_decimal`
--

CREATE TABLE `customer_entity_decimal` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Decimal';

--
-- Table structure for table `customer_entity_int`
--

CREATE TABLE `customer_entity_int` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Int';

--
-- Table structure for table `customer_entity_text`
--

CREATE TABLE `customer_entity_text` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` text NOT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Text';

--
-- Table structure for table `customer_entity_varchar`
--

CREATE TABLE `customer_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Varchar';

--
-- Table structure for table `customer_form_attribute`
--

CREATE TABLE `customer_form_attribute` (
  `form_code` varchar(32) NOT NULL COMMENT 'Form Code',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute Id',
  PRIMARY KEY (`form_code`,`attribute_id`),
  KEY `CUSTOMER_FORM_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Form Attribute';

--
-- Dumping data for table `customer_form_attribute`
--

INSERT INTO `customer_form_attribute` VALUES ('adminhtml_customer',1),('adminhtml_customer',3),('adminhtml_customer',4),('customer_account_create',4),('customer_account_edit',4),('adminhtml_customer',5),('customer_account_create',5),('customer_account_edit',5),('adminhtml_customer',6),('customer_account_create',6),('customer_account_edit',6),('adminhtml_customer',7),('customer_account_create',7),('customer_account_edit',7),('adminhtml_customer',8),('customer_account_create',8),('customer_account_edit',8),('adminhtml_checkout',9),('adminhtml_customer',9),('customer_account_create',9),('customer_account_edit',9),('adminhtml_checkout',10),('adminhtml_customer',10),('adminhtml_checkout',11),('adminhtml_customer',11),('customer_account_create',11),('customer_account_edit',11),('adminhtml_checkout',17),('adminhtml_customer',17),('customer_account_create',17),('customer_account_edit',17),('adminhtml_customer',19),('customer_account_create',19),('customer_account_edit',19),('adminhtml_checkout',20),('adminhtml_customer',20),('customer_account_create',20),('customer_account_edit',20),('adminhtml_customer',21),('adminhtml_customer_address',22),('customer_address_edit',22),('customer_register_address',22),('adminhtml_customer_address',23),('customer_address_edit',23),('customer_register_address',23),('adminhtml_customer_address',24),('customer_address_edit',24),('customer_register_address',24),('adminhtml_customer_address',25),('customer_address_edit',25),('customer_register_address',25),('adminhtml_customer_address',26),('customer_address_edit',26),('customer_register_address',26),('adminhtml_customer_address',27),('customer_address_edit',27),('customer_register_address',27),('adminhtml_customer_address',28),('customer_address_edit',28),('customer_register_address',28),('adminhtml_customer_address',29),('customer_address_edit',29),('customer_register_address',29),('adminhtml_customer_address',30),('customer_address_edit',30),('customer_register_address',30),('adminhtml_customer_address',31),('customer_address_edit',31),('customer_register_address',31),('adminhtml_customer_address',32),('customer_address_edit',32),('customer_register_address',32),('adminhtml_customer_address',33),('customer_address_edit',33),('customer_register_address',33),('adminhtml_customer_address',34),('customer_address_edit',34),('customer_register_address',34),('adminhtml_customer_address',35),('customer_address_edit',35),('customer_register_address',35),('adminhtml_customer_address',36),('customer_address_edit',36),('customer_register_address',36);

--
-- Table structure for table `customer_grid_flat`
--

CREATE TABLE `customer_grid_flat` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `name` text COMMENT 'Name',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `group_id` int(11) DEFAULT NULL COMMENT 'Group_id',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created_at',
  `website_id` int(11) DEFAULT NULL COMMENT 'Website_id',
  `confirmation` varchar(255) DEFAULT NULL COMMENT 'Confirmation',
  `created_in` text COMMENT 'Created_in',
  `dob` date DEFAULT NULL COMMENT 'Dob',
  `gender` int(11) DEFAULT NULL COMMENT 'Gender',
  `taxvat` varchar(255) DEFAULT NULL COMMENT 'Taxvat',
  `lock_expires` timestamp NULL DEFAULT NULL COMMENT 'Lock_expires',
  `shipping_full` text COMMENT 'Shipping_full',
  `billing_full` text COMMENT 'Billing_full',
  `billing_firstname` varchar(255) DEFAULT NULL COMMENT 'Billing_firstname',
  `billing_lastname` varchar(255) DEFAULT NULL COMMENT 'Billing_lastname',
  `billing_telephone` varchar(255) DEFAULT NULL COMMENT 'Billing_telephone',
  `billing_postcode` varchar(255) DEFAULT NULL COMMENT 'Billing_postcode',
  `billing_country_id` varchar(255) DEFAULT NULL COMMENT 'Billing_country_id',
  `billing_region` varchar(255) DEFAULT NULL COMMENT 'Billing_region',
  `billing_street` varchar(255) DEFAULT NULL COMMENT 'Billing_street',
  `billing_city` varchar(255) DEFAULT NULL COMMENT 'Billing_city',
  `billing_fax` varchar(255) DEFAULT NULL COMMENT 'Billing_fax',
  `billing_vat_id` varchar(255) DEFAULT NULL COMMENT 'Billing_vat_id',
  `billing_company` varchar(255) DEFAULT NULL COMMENT 'Billing_company',
  PRIMARY KEY (`entity_id`),
  KEY `CUSTOMER_GRID_FLAT_GROUP_ID` (`group_id`),
  KEY `CUSTOMER_GRID_FLAT_CREATED_AT` (`created_at`),
  KEY `CUSTOMER_GRID_FLAT_WEBSITE_ID` (`website_id`),
  KEY `CUSTOMER_GRID_FLAT_CONFIRMATION` (`confirmation`),
  KEY `CUSTOMER_GRID_FLAT_DOB` (`dob`),
  KEY `CUSTOMER_GRID_FLAT_GENDER` (`gender`),
  KEY `CUSTOMER_GRID_FLAT_BILLING_COUNTRY_ID` (`billing_country_id`),
  FULLTEXT KEY `FTI_8746F705702DD5F6D45B8C7CE7FE9F2F` (`name`,`email`,`created_in`,`taxvat`,`shipping_full`,`billing_full`,`billing_firstname`,`billing_lastname`,`billing_telephone`,`billing_postcode`,`billing_region`,`billing_city`,`billing_fax`,`billing_company`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='customer_grid_flat';

--
-- Dumping data for table `customer_grid_flat`
--

INSERT INTO `customer_grid_flat` VALUES ('1','admin admin','admin@admin.com','1','2016-03-15 21:25:53','1',NULL,'English',NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('2','Anika Mood','anika@gmail.com','1','2017-10-23 18:00:18','1',NULL,'English',NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('3','demo demo','demo@demo.com','1','2017-11-30 11:45:51','1',NULL,'English',NULL,NULL,NULL,NULL,'demo demo Georgia 55555','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `customer_group`
--

CREATE TABLE `customer_group` (
  `customer_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_group_code` varchar(32) NOT NULL COMMENT 'Customer Group Code',
  `tax_class_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Tax Class Id',
  PRIMARY KEY (`customer_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Customer Group';

--
-- Dumping data for table `customer_group`
--

INSERT INTO `customer_group` VALUES ('0','NOT LOGGED IN','3'),('1','General','3'),('2','Wholesale','3'),('3','Retailer','3');

--
-- Table structure for table `customer_log`
--

CREATE TABLE `customer_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `customer_id` int(11) NOT NULL COMMENT 'Customer ID',
  `last_login_at` timestamp NULL DEFAULT NULL COMMENT 'Last Login Time',
  `last_logout_at` timestamp NULL DEFAULT NULL COMMENT 'Last Logout Time',
  PRIMARY KEY (`log_id`),
  UNIQUE KEY `CUSTOMER_LOG_CUSTOMER_ID` (`customer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Customer Log Table';

--
-- Dumping data for table `customer_log`
--

INSERT INTO `customer_log` VALUES ('1','1','2016-03-15 21:25:56',NULL),('2','2','2017-10-23 18:00:19',NULL),('3','3','2017-12-06 12:38:50','2017-12-01 15:32:54');

--
-- Table structure for table `customer_visitor`
--

CREATE TABLE `customer_visitor` (
  `visitor_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Visitor ID',
  `customer_id` int(11) DEFAULT NULL COMMENT 'Customer Id',
  `session_id` varchar(64) DEFAULT NULL COMMENT 'Session ID',
  `last_visit_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last Visit Time',
  PRIMARY KEY (`visitor_id`),
  KEY `CUSTOMER_VISITOR_CUSTOMER_ID` (`customer_id`),
  KEY `CUSTOMER_VISITOR_LAST_VISIT_AT` (`last_visit_at`)
) ENGINE=InnoDB AUTO_INCREMENT=475 DEFAULT CHARSET=utf8 COMMENT='Visitor Table';

--
-- Dumping data for table `customer_visitor`
--

INSERT INTO `customer_visitor` VALUES (1,NULL,'a6nulhgf8avp7n08cdfdcef0r3','2016-03-12 02:25:46'),(2,NULL,'46shiaeruuac11a4d8f7bmnek1','2016-03-12 03:41:35'),(3,NULL,'0n9r5ebf3g8os57rg50dpfatv1','2016-03-15 20:06:57'),(4,'1','1jm84kt3afrmgsem77p2ffvoq7','2016-03-15 22:21:16'),(5,NULL,'sbmj6nsh1g0c9rb33fpdekdqs5','2016-03-15 23:27:46'),(6,NULL,'7sm6i7dti2ca4acs4oouag4i94','2016-03-16 21:08:26'),(7,NULL,'18ed9gufdpib9pugjjl83rv0h1','2016-03-17 16:26:49'),(8,NULL,'508h6tr6gka9e7dcjbm4umhql4','2016-03-18 12:34:18'),(9,NULL,'ac7ocasgs5jvfhebercmtj4877','2016-03-21 01:30:56'),(10,NULL,'g0u1m8v9ph3hi6ikg34nmkqsh6','2016-03-22 19:34:55'),(11,NULL,'h47fqo8osn1ll88t5l4fsmta00','2016-03-22 23:10:52'),(12,NULL,'nsa69fmj0td3625k87vp1q4491','2016-03-24 21:18:52'),(13,NULL,'u1nl74q6osp5a62ermc22mdnq6','2016-04-18 16:18:09'),(14,NULL,'atup5dr1vd4mjgkah2cv8hie45','2016-06-23 13:54:39'),(15,NULL,'psloa11li6iu92gi8c6hb361v4','2016-06-23 14:13:02'),(16,NULL,'rpbq63roiiv06f6r25v374clb0','2016-06-24 09:55:56'),(17,NULL,'8sp1h7ftlvatfc0bqp3m7o5hs5','2016-06-25 15:38:46'),(18,NULL,'mej0l2p86e4cc01k2sia5dd6k2','2016-08-16 15:23:58'),(19,NULL,'oiu03t7pfssupbo171nvja4jp5','2016-09-29 23:51:00'),(20,NULL,'93ftakpdmup8p8hq11ie7p3o65','2016-09-29 23:52:18'),(21,NULL,'lgka27qurkm74t015hj08ac2q7','2016-09-30 00:03:42'),(22,NULL,'rbv240d3cjlu8d7l90fjnkb5i1','2016-09-30 01:29:14'),(23,NULL,'9jjpklk4502cj6qn8dbp0acuv1','2016-09-30 01:29:46'),(24,NULL,'91qaqo8n9viiacsi1jfa450mn6','2016-09-30 01:29:48'),(25,NULL,'j5pr25q971n51ulmabtra6ti16','2016-09-30 01:30:18'),(26,NULL,'kf0q5tvrv1mm193s82ns0ul6i3','2016-09-30 02:17:26'),(27,NULL,'qs25uckpah9k6bgkk26q52bjp6','2016-09-30 01:30:27'),(28,NULL,'kbbajeomvsbrq25p6is339vl04','2016-10-14 05:56:28'),(29,NULL,'6fg8elbmtg4it9dbsv21694j53','2016-10-14 05:58:14'),(30,NULL,'iiji7lih4bol3m9gqu54cn29h0','2016-10-14 05:59:40'),(31,NULL,'0prigqrqag3f23mueq3r824834','2016-10-14 06:03:30'),(32,NULL,'fagfvfpj61h1kf18kj29ltq0m3','2016-10-14 06:03:31'),(33,NULL,'cp44ncfa79tm777tnambfgfo63','2016-10-14 06:19:49'),(34,NULL,'1jjqtnmoq2bup1hggv8r3do1f4','2016-10-14 06:04:25'),(35,NULL,'9f6r4tdfooijppvig9ut1uj8u4','2016-10-14 06:05:14'),(36,NULL,'ue7veshp4dohc4m9a0cp7saim6','2016-10-14 08:14:41'),(37,NULL,'v1t1v7o0kqsnslngij5n47t7n1','2016-10-14 08:14:41'),(38,NULL,'ieuma0fu3rpaae1s6k5th5mra6','2016-10-14 18:46:12'),(39,NULL,'jdsg4tt36lnlqhh0ar96646mf0','2016-10-14 18:47:35'),(40,NULL,'nn8ktqu4k0uh2g9cu4edms20e2','2017-01-06 10:36:21'),(41,NULL,'064919ul9vs4c0n60cuevf8gg2','2017-01-19 10:50:41'),(42,NULL,'tgiio9pat6t442ehgejdk6mdk3','2017-01-19 10:50:57'),(43,NULL,'l14d519n314m0iasgbb5p2gon6','2017-01-19 10:51:12'),(44,NULL,'h5ejo3dk8bi10d9l5fsja3a4e6','2017-01-19 10:51:59'),(45,NULL,'681ksvkpa6crkps84hdgsb0kk6','2017-01-19 10:52:08'),(46,NULL,'vr7jhmsqpcak882ljj6vjs3vi1','2017-01-19 11:47:15'),(47,NULL,'epouug4tuv6j91p59di671m3j5','2017-01-19 10:53:55'),(48,NULL,'2fcrolbkos5c8guea39ngc8q04','2017-01-19 13:45:18'),(49,NULL,'7b3d16ha3uh4ci6qcs6d40rt06','2017-01-22 12:43:50'),(50,NULL,'3qihudodvcqair9jp28b45fpa2','2017-01-22 15:34:11'),(51,NULL,'ljqv53bt8m2197s1dl1na1usv1','2017-02-06 12:27:11'),(52,NULL,'84lur3bh2gas0otsk76untaii6','2017-02-06 12:27:28'),(53,NULL,'mn4dspups9u1qqsljpk105led3','2017-02-06 12:27:31'),(54,NULL,'05g5e51tqi0s3hs7kjj7fblkv2','2017-02-06 12:27:31'),(55,NULL,'30a0reep6t753oudg1ltahv6i6','2017-03-05 14:11:54'),(56,NULL,'p4ig57ir71up75pu55dupd1u11','2017-03-05 14:12:16'),(57,NULL,'4o6fhfg0hr9soi9ephkvcgaqd6','2017-03-05 14:12:19'),(58,NULL,'0jr815u35jb8fjrj0cdufkrcn6','2017-03-05 14:12:19'),(59,NULL,'34sr9iaslk9g38pkdhmahpkbd2','2017-06-07 06:42:15'),(60,NULL,'ke7ukfkllmta97h9f6b62abng4','2017-06-07 06:42:30'),(61,NULL,'2vamdqkuevijo1qcrknmil7062','2017-06-08 06:18:50'),(62,NULL,'dqtt77cdnkr13alcr1b1tfbam7','2017-06-08 06:19:04'),(63,NULL,'qqmfdfc5hru39o378k4t83o2p5','2017-06-08 06:19:04'),(64,NULL,'sni9m5jgmo8l90roup3fdv7033','2017-06-15 11:57:48'),(65,NULL,'5gv1b3hbvi9ji1psn3217h7gh6','2017-06-15 11:57:57'),(66,NULL,'424o8a9qjmftc0j60mt6pm5q43','2017-06-15 12:18:25'),(67,NULL,'fkp449216e13u8tg5bf4as4bf6','2017-06-15 12:18:27'),(68,NULL,'abri8ofbmhs6kb6ecdhco9h6s1','2017-06-15 12:18:28'),(69,NULL,'35591vuhq242am3kf1ftc59556','2017-06-15 12:30:11'),(70,NULL,'etpnv8chhdgvhuq4fmrkou4eu1','2017-06-15 12:44:13'),(71,NULL,'5beo2g92rt8qk05lk8e5bkhst7','2017-06-15 12:44:15'),(72,NULL,'q314s0j28ms61669o9tc16fqb7','2017-06-15 13:37:06'),(73,NULL,'jp8vp87v45738v5c28vl6ckpl0','2017-06-15 12:44:15'),(74,NULL,'t5bljc26426qb978pvv4moc9j2','2017-06-15 13:50:45'),(75,NULL,'kf5nn9bpaosprthj61via75ch1','2017-06-15 13:50:47'),(76,NULL,'41dqvbuan9d2h37md5jnmnc9c5','2017-06-15 13:53:00'),(77,NULL,'6bip300qr7geonvfbm0pdlp2i5','2017-06-15 13:56:31'),(78,NULL,'skgq12vebaa9stjr9g8o27gbc5','2017-06-15 13:58:45'),(79,NULL,'pprii9a61falnphn9ugvgn3ji6','2017-06-15 13:58:47'),(80,NULL,'agrsvig49roddm5879523crud4','2017-06-15 13:59:12'),(81,NULL,'kjfe9g7qal1qmedu08b9h7ksp6','2017-06-15 14:00:03'),(82,NULL,'vdkl8gcs0551l5nbjvd021vge2','2017-06-15 14:00:04'),(83,NULL,'l78jcaolsp0pou2ic77gpqlc61','2017-06-15 14:00:05'),(84,NULL,'vss05uc25tn9ovk04oejl77ga1','2017-06-15 14:00:07'),(85,NULL,'tsalaam1p0onoc4ebmmefpftp6','2017-06-15 14:02:18'),(86,NULL,'1pgjlqiv2tg586a7q813ue5uf5','2017-06-15 14:03:49'),(87,NULL,'ikgdfen2s1hevej0t0j6m3qqd6','2017-06-15 14:04:09'),(88,NULL,'v4dc792ca1858lls9l4pfbpr21','2017-06-15 14:05:27'),(89,NULL,'5d4viaa0623ukvhij3mi84jgj4','2017-06-15 14:06:34'),(90,NULL,'u2sebl74ndvqb9ca2g37qj5fs1','2017-06-15 14:07:25'),(91,NULL,'m1rb6q72r0eb13bcd91bimk162','2017-06-15 14:07:26'),(92,NULL,'jq8ob983hs7kbtkqqh5lncjav6','2017-06-15 14:08:02'),(93,NULL,'45rmpf7348mkcr0jh0bahhuhl2','2017-06-15 14:08:03'),(94,NULL,'ghufv6suvvof6q1s9lgr6g2qq4','2017-06-15 14:10:01'),(95,NULL,'5cqv7dj71ufp7dlpj9crmsntd5','2017-06-15 14:11:52'),(96,NULL,'a5a5tm49rg5ngeigv932f0m6a6','2017-06-15 14:13:42'),(97,NULL,'fhh1v7pdrjqo1jqv9hkugd56g0','2017-06-15 14:13:44'),(98,NULL,'q0lljiuqv40it8asr5tqrcbe45','2017-06-15 14:14:21'),(99,NULL,'4nl8v3ijoec9rpugm1u3ek2cg5','2017-06-15 14:14:57'),(100,NULL,'vu59ct58ukgdul32k7id59ahu1','2017-06-15 14:16:56'),(101,NULL,'ljnelh7hiqa7ml3injv2fqp2v7','2017-06-16 02:19:25'),(102,NULL,'rq6en24k5j11ev711eajkta2f1','2017-06-16 02:19:29'),(103,NULL,'10ru0cbseuf6pscck9doegcli6','2017-06-16 02:27:34'),(104,NULL,'jp1bulreh3du6e5b9gtf0e2pl5','2017-06-16 02:19:29'),(105,NULL,'vg32hg5nqcq78ahe9g8tvsoal6','2017-06-16 03:20:11'),(106,NULL,'h44itopec1kai67t30rol0uml2','2017-06-16 03:20:06'),(107,NULL,'uo1tma5e8tcmog8cmckmuhea37','2017-06-16 03:20:06'),(108,NULL,'3k8c194mp69ds5ft91am72g7e3','2017-06-16 05:51:38'),(109,NULL,'cd4sb25tpa64ftedhihoa4etp6','2017-06-16 06:00:01'),(110,NULL,'9h8rvphp7h9htpujk67b6nsg27','2017-06-16 06:01:08'),(111,NULL,'l9jlno0lumm3vqck4qqel9dmb3','2017-06-16 06:01:53'),(112,NULL,'pfr1tu94g2s5em3h2ctucon236','2017-06-16 06:03:11'),(113,NULL,'pltq31eeq0b4b60rd9j6thstg1','2017-06-16 06:03:19'),(114,NULL,'ctrrfmmhme0mpib7v2bq0jn9b0','2017-06-16 06:04:10'),(115,NULL,'27fe18f93k7a4mj2mrrloc9bj3','2017-06-16 06:07:19'),(116,NULL,'ps6is212g4cn3bnts6dc9rctk2','2017-06-16 06:08:07'),(117,NULL,'2mqi1od57v7ft52j2finl3drd3','2017-06-16 06:08:09'),(118,NULL,'ru3g0td3lnasv2gf78o70ri5p4','2017-06-16 06:08:53'),(119,NULL,'eeqlmif967n0vf36vuid28u4a2','2017-06-16 06:10:12'),(120,NULL,'i2ul8ve7bt1ehcmv8ik4abaej1','2017-06-16 06:14:04'),(121,NULL,'oktgebrra8tmeon0secklbop82','2017-06-16 06:15:31'),(122,NULL,'1nm25pmtdon4bmf0h0vs4n8g12','2017-06-16 06:15:32'),(123,NULL,'fr8h5begsm97s8b5omr303ekk4','2017-06-16 06:16:13'),(124,NULL,'tlueslgj7mkjfud839q4bf8qn6','2017-06-16 06:17:39'),(125,NULL,'eli7r0ebqldaf0jhoksn51t582','2017-06-16 06:17:40'),(126,NULL,'2c0rg517n2bn344mket68vg732','2017-06-16 06:17:41'),(127,NULL,'t5mp1ivelc8cud4gb4t6nrblc5','2017-06-16 06:17:42'),(128,NULL,'dar3bl7slremgbhrdrjbl6koa5','2017-06-16 06:20:36'),(129,NULL,'cocjjdu6tl20fafqrtuf5g9ts0','2017-06-16 06:20:38'),(130,NULL,'hadjlrmltiaujoqh60mcdib0k1','2017-06-16 06:22:19'),(131,NULL,'6ft21fa33hil90517l7ri21bn2','2017-06-16 06:23:10'),(132,NULL,'mv7ih72hlo3a4upkf24i2269i7','2017-06-16 06:33:28'),(133,NULL,'6d93j5d2k7o7k354vaam2ntd92','2017-06-16 06:33:29'),(134,NULL,'ikv9qrj0q0iddkbkf6v5untpv1','2017-06-16 06:33:31'),(135,NULL,'84smbtntioqi1sgr335eodaa84','2017-06-16 06:33:31'),(136,NULL,'7ukfi1vpi3kbfkfbkrbanpol15','2017-06-16 06:33:31'),(137,NULL,'mfft8eivtbo5cd6uvmf5tpdth6','2017-06-20 06:13:31'),(138,NULL,'ekplef0c4k3me9pfinjnpd46r5','2017-06-20 06:13:33'),(139,NULL,'teeq60a2josne1dc2ikusn9np1','2017-06-20 06:14:49'),(140,NULL,'e53ttcqih9eg6quo2425j84qb1','2017-06-20 06:43:31'),(141,NULL,'pk194v1v4040upugj5apc6ng63','2017-06-20 06:53:09'),(142,NULL,'0vs8odd1ceucl70aq2j2saf401','2017-06-20 06:53:10'),(143,NULL,'fpnr3snto7ahvf69l7chr9p5f7','2017-06-22 11:40:04'),(144,NULL,'7n251m7rgq2b1vlt6hluotnsm7','2017-06-22 11:40:11'),(145,NULL,'ifqb4nf4vm5e5be7pb0jsbpv65','2017-10-20 07:18:46'),(146,NULL,'u7kian0ectpubajl1btasov935','2017-10-20 07:18:48'),(147,NULL,'u2i65lfieo66d9nhthd4hk0a66','2017-10-23 07:07:26'),(148,NULL,'fhqn0faoe0t12hnjjmhpj67fs4','2017-10-23 07:07:33'),(149,NULL,'k19lgpc4peolq44pfmgrjumok5','2017-10-23 07:07:37'),(150,NULL,'1pcen491almqbc79i2cle09qn4','2017-10-23 07:07:44'),(151,NULL,'cs3bbavuddkb4dd8ikn44c4d05','2017-10-23 07:07:37'),(152,NULL,'67ufsff7nvquik7koe2irpa3d5','2017-10-23 15:37:36'),(153,NULL,'s9ifr9jsnke0tr0i8sa9kehqs3','2017-10-23 15:37:52'),(154,NULL,'dr0ar9ndgelrfbecrbiep27gk7','2017-10-23 16:23:24'),(155,NULL,'mtjbtggcksh95cp0ig31a7uvr5','2017-10-23 16:47:06'),(156,NULL,'h2ninh68uk0v86dc24mllan9k2','2017-10-23 17:45:34'),(157,NULL,'avf9i2m68kq7cd4hne7vfmefq5','2017-10-23 16:47:10'),(158,NULL,'ctq1r1472ii19971ma80qqcm13','2017-10-23 16:47:10'),(159,NULL,'2ckf7j3hgui5o9k3kp2o4j1q30','2017-10-23 17:54:17'),(160,'2','1dqo8qtkto11rj9oq3287b9nq6','2017-10-23 18:16:32'),(161,NULL,'kv70u2o52f0l80pbfnts2s8hv3','2017-10-23 17:54:20'),(162,NULL,'9ummtdds4ft3qanonb46bs4ol1','2017-10-23 17:54:20'),(163,NULL,'enu7elg6qtr87ff9s52bkmj3n7','2017-10-29 12:55:41'),(164,NULL,'jp58ueb9he7hgbg3thf67nqq81','2017-10-29 12:55:50'),(165,NULL,'pgo4knk65k2f3o7tifkeq4l3u6','2017-10-29 12:56:08'),(166,NULL,'j7supkm9dltqari5g3ncbtle41','2017-10-31 12:53:51'),(167,NULL,'qukok7ppcb6c94a1j75uqr87k2','2017-10-31 12:53:58'),(168,NULL,'4s9v59ojo203p3el2qhk9fv767','2017-10-31 12:54:07'),(169,NULL,'9vlsm29c3h531cu66s48rbv6b5','2017-11-14 12:03:42'),(170,NULL,'mqigde45f5i95iuvfsdl7o1g82','2017-11-14 12:04:02'),(171,NULL,'gvglectvma7b0sektbo7hjt2u1','2017-11-14 12:04:03'),(172,NULL,'pevj801vvjp7jegklaik7p6uu0','2017-11-14 12:07:55'),(173,NULL,'1iqn4rksmt3v4oddogilqfhsg6','2017-11-14 12:10:52'),(174,NULL,'3d7kbssdl0pqni21ml8ci3p6u6','2017-11-14 12:56:53'),(175,NULL,'doi713b49a7ri1ol8r9o9en6m7','2017-11-14 13:22:51'),(176,NULL,'ttgs4sm3d5paefu0b0ajor0ck4','2017-11-14 13:22:53'),(177,NULL,'0dtl27pj4iufh6vhig7hjep0f3','2017-11-14 13:22:55'),(178,NULL,'s54370j47ej4q4d0mt023a75u1','2017-11-14 13:22:55'),(179,NULL,'sifjgpl2dqo07t2m8aoqvm3og7','2017-11-14 13:25:22'),(180,NULL,'njab9eu82lppsudm04iubv8gh6','2017-11-14 13:25:24'),(181,NULL,'b3tr7jcdki503ss8ms12m52sc4','2017-11-14 13:29:32'),(182,NULL,'9mge5u2rh5h8m8rnj1hdootn05','2017-11-14 13:29:34'),(183,NULL,'5ie97h6lod6opqbnha3ajbh077','2017-11-14 13:31:15'),(184,NULL,'ujc8uno4gok1f45t2pdreac5a2','2017-11-14 13:31:17'),(185,NULL,'kjmfjnao5aluqg88vcv00uv9j1','2017-11-14 15:35:36'),(186,NULL,'gm94hdvvlnd49tub6s70titcp0','2017-11-14 15:10:56'),(187,NULL,'bvtftn6lhpv10p3vi9ajfaaen3','2017-11-14 15:10:56'),(188,NULL,'5sd9vllq021rba41dhu7ngfg50','2017-11-15 08:44:45'),(189,NULL,'ficrp64mupr1u1d2t2dit5q3n5','2017-11-15 08:48:45'),(190,NULL,'9q4snl6s4pblc2dcuqic5hqni4','2017-11-15 08:44:45'),(191,NULL,'o1tln4654b3d6gt6fson2e2oc3','2017-11-15 10:02:22'),(192,NULL,'bq36hjrtg3bkmrs93hv0aoedi6','2017-11-15 10:02:25'),(193,NULL,'inpvl30u7ss2h5n56u1c07ejq7','2017-11-15 10:02:27'),(194,NULL,'b8gkprr692tb55lb58u80av1k7','2017-11-15 11:11:07'),(195,NULL,'bbff3qns6nna77llqvb9c75m35','2017-11-15 10:02:27'),(196,NULL,'d1gbutvvphkn2d799vgd5iqb85','2017-11-15 12:15:18'),(197,NULL,'dao697pa8kpbebcdadkegvghf1','2017-11-15 14:41:23'),(198,NULL,'nel5rrtthhg2cfu4db3ia3vtj0','2017-11-15 12:15:22'),(199,NULL,'fo2hdge1k332gbo4thefbicmk3','2017-11-15 12:15:22'),(200,NULL,'eki8qj2csftf0j7snpcjt0nd14','2017-11-15 15:43:56'),(201,NULL,'7urnqckf7d8bcgh1fus7ln3vd6','2017-11-16 08:19:37'),(202,NULL,'n377tvhi4cjdjtmm2hlum6c8d4','2017-11-16 08:19:37'),(203,NULL,'sjehgni9jcag5609uhafkb9r61','2017-11-16 08:19:37'),(204,NULL,'7urnqckf7d8bcgh1fus7ln3vd6','2017-11-16 09:33:19'),(205,NULL,'7urnqckf7d8bcgh1fus7ln3vd6','2017-11-16 10:19:14'),(206,NULL,'u29olhb4akn6fnqla9j51r8s85','2017-11-16 10:33:44'),(207,NULL,'7oi7cesq9031f5n1rn29numsi0','2017-11-16 10:34:35'),(208,NULL,'61lddgattsfe55itk948v9vpi1','2017-11-16 10:35:02'),(209,NULL,'4ek0g50pbctguf95lkk0rqk7j2','2017-11-16 10:35:33'),(210,NULL,'nmr9i3ca4chjjcfip2e1vh0kp3','2017-11-16 10:35:36'),(211,NULL,'949qt0r62vfdd83kk065nio200','2017-11-16 10:36:08'),(212,NULL,'ubjbblcoa4rs32upv70g9r2t31','2017-11-16 10:36:11'),(213,NULL,'5qc91ohc2o1qp3d4bg8nlmib40','2017-11-16 10:36:36'),(214,NULL,'0nn0077b591qlrst91fs8v1q44','2017-11-16 10:38:47'),(215,NULL,'3jq4h6l4j596i3a05iucrr31m7','2017-11-16 10:39:11'),(216,NULL,'hr511298os4f8v79qpb0c2ki52','2017-11-16 10:38:50'),(217,NULL,'uu4r62dbinvr2elvnota1qr825','2017-11-16 10:38:51'),(218,NULL,'9l86viokqum6qqe1l2fvmm12d2','2017-11-16 11:43:30'),(219,NULL,'3grelecsscfqnsmvue9oo0sg11','2017-11-16 12:30:13'),(220,NULL,'jigbhdc55348ga1ps52bg86mm7','2017-11-16 12:30:22'),(221,NULL,'ti2cvoohfakiqul2bh374kl143','2017-11-16 12:30:22'),(222,NULL,'ap7o7ipht41tn0uiacsm01prd5','2017-11-16 12:32:06'),(223,NULL,'iij2mdgajsqf9gfjc2dtmsma93','2017-11-16 12:30:49'),(224,NULL,'2ll9u309f4rqhnu683221kr585','2017-11-16 12:30:49'),(225,NULL,'2k6tt6c4tuekom51oma1559df7','2017-11-16 13:32:36'),(226,NULL,'72433701089tvkga0dhfs1jr37','2017-11-16 13:32:36'),(227,NULL,'6vhoeamq6oi89elvtcc2rp6kn6','2017-11-16 13:32:38'),(228,NULL,'9rjli7n9ie2uuddme1gdige076','2017-11-16 13:32:38'),(229,NULL,'b36f3iei3gmj25uodi62bi4to5','2017-11-16 13:32:40'),(230,NULL,'164tar1anp6fhtc6u1jl8gepb3','2017-11-16 13:32:40'),(231,NULL,'7tobg4gglo7gn7gl6hrdj4d5h2','2017-11-16 14:49:37'),(232,NULL,'ag6enaqo6gj0skqikgjlouqoo6','2017-11-16 13:33:41'),(233,NULL,'dk2k2595b9k8oed2jog6f3d571','2017-11-16 13:33:42'),(234,NULL,'lis87psvit6tolg9qe7vutulc7','2017-11-17 08:49:14'),(235,NULL,'q7tvtgbmibfi7oujb5i37kl747','2017-11-17 08:49:14'),(236,NULL,'osdcs3mtdslpkbgcgb85l2cg30','2017-11-28 08:15:25'),(237,NULL,'rd7kkh2keuqlm2l9tcgg1v81r3','2017-11-28 08:15:30'),(238,NULL,'r3p7h0nagi69qenh4vl2sfejs2','2017-11-28 08:15:30'),(239,NULL,'f1u63036c4d02r8e72d0pq8md3','2017-11-28 09:17:47'),(240,NULL,'781uf7qk35vcq8h521mp3vopc3','2017-11-28 08:15:36'),(241,NULL,'l5bermb1oc92lh5f5hshgm5qv4','2017-11-28 10:29:26'),(242,NULL,'b0s9u1vq2pkoe3e1iuq39k9c82','2017-11-28 10:36:21'),(243,NULL,'nihfetd24fobms9p7u5duj35g6','2017-11-28 10:29:27'),(244,NULL,'g7p0kneuk4i5r9u13ikvpa5vn1','2017-11-28 11:39:04'),(245,NULL,'6ibq4ar5lqo2sk3g3ceg85g242','2017-11-28 11:39:04'),(246,NULL,'l3vg30uhetbvf0f6e1nngtcr43','2017-11-28 11:40:15'),(247,NULL,'3261cjue5l2fphvtia4stts7q2','2017-11-28 11:40:15'),(248,NULL,'gjms6lsun0nqmg1iba7e621ih6','2017-11-28 11:41:48'),(249,NULL,'2qahb21d63l7i6i4s4cmbpfha6','2017-11-28 11:41:49'),(250,NULL,'kvcl5q75ht220gerb8o0ufeo03','2017-11-28 11:42:29'),(251,NULL,'4utt50488bjaicor3uno3qmre5','2017-11-28 11:42:29'),(252,NULL,'73hi0msfjefqg0kuqjtl848s73','2017-11-28 11:42:31'),(253,NULL,'osl2vonj213iehum12oekr78q7','2017-11-28 11:42:31'),(254,NULL,'tekuaron4dsrer1rsin9ar15p0','2017-11-28 11:50:07'),(255,NULL,'jmmtta08olo3qasmhlij1c33s6','2017-11-28 11:50:07'),(256,NULL,'nim6kbcdiaath4a31jmvr66665','2017-11-28 11:50:07'),(257,NULL,'ff0s2k6u3i2apefl5upmp9sdh7','2017-11-28 13:16:17'),(258,NULL,'ai7qua22gv3vi3jd429252l8o0','2017-11-28 13:06:07'),(259,NULL,'675192fbuthjjlq69jn45hemu6','2017-11-28 13:06:07'),(260,NULL,'jvkndntc3robj6cjhpulqk57m4','2017-11-28 14:19:01'),(261,NULL,'88aef2lvlv18tdsr6u2cn46173','2017-11-28 14:19:01'),(262,NULL,'1njukjuj26imnl780e2dhf1r62','2017-11-28 14:20:15'),(263,NULL,'qmvb8p2njkt4n0v55345vj5mu1','2017-11-28 14:20:15'),(264,NULL,'qvnupig6e3uf1qgj0tetu3q0m0','2017-11-28 14:21:09'),(265,NULL,'jjomja6keh4ud5m1ncvoscgii4','2017-11-28 14:21:09'),(266,NULL,'kdtbsclcm7epltunmi1c3u5k57','2017-11-28 14:22:34'),(267,NULL,'l6do7qfbct6kece9n3uu80und2','2017-11-28 14:22:34'),(268,NULL,'qlvaiba1lqlansdjs90s39i6j1','2017-11-28 14:39:25'),(269,NULL,'lf7tofco6cg9sapf399t8tl7p4','2017-11-28 14:39:25'),(270,NULL,'u9jtoiia9v53ltvuarpjkvpt23','2017-11-28 14:42:42'),(271,NULL,'1ccttq3dn2htcq46h5asr1b0t3','2017-11-28 14:42:42'),(272,NULL,'49516rn97gim2fbsnkt6j6ms24','2017-11-28 14:45:49'),(273,NULL,'mgs2nbft0vapsi1l7pm18h3vh7','2017-11-28 14:45:49'),(274,NULL,'89f69eh9n09lr3cuhvtngoe2s2','2017-11-28 14:46:38'),(275,NULL,'qpmep2t7fgesrgkaipn1ho1st6','2017-11-28 14:46:38'),(276,NULL,'fu5vn7umobi3c14rih7kot2106','2017-11-28 14:48:14'),(277,NULL,'kgqbhskpkfcg184oi7juvcqij4','2017-11-28 14:48:14'),(278,NULL,'44ulav71p0hq1606jokmrkik07','2017-11-28 14:49:18'),(279,NULL,'j4eatku53q0qnsubnn665rh2h3','2017-11-28 14:49:18'),(280,NULL,'9kbj72k8gs91aijrn7puoa1im5','2017-11-28 14:53:02'),(281,NULL,'mld0nclgv4q3qh0o8uibl2pcs0','2017-11-28 14:53:02'),(282,NULL,'374bnvqrfo56sok42k3sjr1966','2017-11-28 14:57:00'),(283,NULL,'27j1o5hv9bb9q9mrfu0t7bq5n0','2017-11-28 14:54:08'),(284,NULL,'hiacll6am0g8disf0rkt60bc04','2017-11-28 14:54:09'),(285,NULL,'71ph0b1h1h2dq58jgof8b8sk22','2017-11-29 08:45:37'),(286,NULL,'crrdf9sb881636fdm321ld9sb1','2017-11-29 08:45:40'),(287,NULL,'b26vm8hj23dmo1t7nhs3vi80o4','2017-11-29 08:45:37'),(288,NULL,'p2q163b16vapn1l2m9ida0dkq1','2017-11-29 10:06:48'),(289,NULL,'arcjuv25jv9352gntdvkimg4k6','2017-11-29 10:06:48'),(290,NULL,'744iahkt670ckor4vmietc6m56','2017-11-29 10:10:24'),(291,NULL,'d4q9jmkiapq4um8ketpiso4hq1','2017-11-29 10:10:24'),(292,NULL,'rn5gbmn53803khhpiecjht8ui7','2017-11-29 10:11:49'),(293,NULL,'n4rtoqkc74m0jks0bkviquckj4','2017-11-29 10:11:49'),(294,NULL,'3c6utce1r2f58sdkhl8pgqdrs6','2017-11-29 10:12:17'),(295,NULL,'580elo6heipcusnj8dohhu8oa3','2017-11-29 10:12:17'),(296,NULL,'5gllngi6jindrf66t23tc385g5','2017-11-29 10:13:00'),(297,NULL,'qepvpfn22bih56d90vl50rvq50','2017-11-29 10:13:00'),(298,NULL,'1931attiqloovhion60q6m3bj5','2017-11-29 10:14:00'),(299,NULL,'cppmp09rk26tdqp9cqr6dk1u96','2017-11-29 10:14:01'),(300,NULL,'6jce0rb3unu9g6ssvvmk81bao1','2017-11-29 10:15:53'),(301,NULL,'ksjhtqt5pp99psjbnkepdu1m21','2017-11-29 10:15:53'),(302,NULL,'l6j0lq46t2ofp3bd4644ff3fq3','2017-11-29 10:17:14'),(303,NULL,'gfd7f06e91nmp8ep8nhbhn4ub7','2017-11-29 10:17:14'),(304,NULL,'56f4fovmbsbnugtb5uk8rnbov4','2017-11-29 10:21:58'),(305,NULL,'m99sbn7pealdj4i99e5t0pfmg7','2017-11-29 10:21:58'),(306,NULL,'8apr8ju2a87il8g1urf34kvl74','2017-11-29 10:22:51'),(307,NULL,'987hnl994b3la2pjm20kso3m33','2017-11-29 10:22:51'),(308,NULL,'0n3mgffforp6p69pb0adjf5nk3','2017-11-29 10:25:10'),(309,NULL,'vspbi9v4aackphfcsfvgakb0v1','2017-11-29 10:25:10'),(310,NULL,'rlb62dbpkqm5279m00ifmd02h0','2017-11-29 11:33:17'),(311,NULL,'5bhm94a6e4ek0hr5abr0mp0ob5','2017-11-29 10:26:15'),(312,NULL,'dutm2461hi2bl5dc5dvrmp9d26','2017-11-29 10:26:15'),(313,NULL,'ps3jkeopj00apve6e1pjabrgs0','2017-11-29 13:17:37'),(314,NULL,'l9pqu3i7oe10kaduhtd0gunqk2','2017-11-29 13:17:40'),(315,NULL,'u479kocrbevthtbh3brd0s4290','2017-11-29 13:17:40'),(316,NULL,'qlflbk562j8mbc7vce7tmeua85','2017-11-29 13:17:43'),(317,NULL,'tqnagk2dm8isec39a2dk5mr7n4','2017-11-29 13:20:49'),(318,NULL,'ftbto1q3d9pnprm0tc1efcuph4','2017-11-29 13:17:44'),(319,NULL,'r034g3hd69dscpmcnq9l4u0od4','2017-11-29 13:21:47'),(320,NULL,'srpo75g830aigugg95stv7vrv6','2017-11-29 13:21:47'),(321,NULL,'dp8c5nr3itlcvpc3fvrtt9u5l0','2017-11-29 14:20:59'),(322,NULL,'5s1vb5ibsphhta6of1otd6uap7','2017-11-29 14:20:59'),(323,NULL,'hvgmpj59a39i40lc771cuk2s26','2017-11-29 14:22:09'),(324,NULL,'ng5aohtletrisv4q3h5tq3d2k4','2017-11-29 14:22:09'),(325,NULL,'cdt18ipqhb536rjfq3e3km4ed0','2017-11-29 15:31:20'),(326,NULL,'j9iadauoo3dtc67eaabtt6acl0','2017-11-29 14:27:15'),(327,NULL,'i2lgs1cv0qkn7kj4d5v3tgg1f6','2017-11-29 14:27:16'),(328,NULL,'ldtuhac3qocrf89bel45d12g16','2017-11-30 08:24:32'),(329,NULL,'8lp71g3n77foh68ib3n2ib6dc6','2017-11-30 08:24:32'),(330,NULL,'losibtucvon2ovm9bfm50m8r37','2017-11-30 09:08:13'),(331,NULL,'ea68v4a3scefkp090k6ekc7ah7','2017-11-30 08:41:40'),(332,NULL,'9nvfucod88keb98is9t48kkjr5','2017-11-30 08:41:40'),(333,NULL,'gffhs39tjsqb1aih3nadobmlr4','2017-11-30 09:08:29'),(334,NULL,'jp5geu9gcd6edif352a601dno4','2017-11-30 09:16:37'),(335,NULL,'1rf5kiaduhls6on9hjukr7mb46','2017-11-30 09:18:42'),(336,NULL,'c591vurlbeah0c13ar2rsl33d1','2017-11-30 09:18:46'),(337,NULL,'1dlv7vi53of8sv0ituhsbtc2f1','2017-11-30 09:18:46'),(338,NULL,'0b08tqlo3pk3p9ojb7ka16k8t2','2017-11-30 09:19:23'),(339,NULL,'0n0p3pspsbi4r09c8svtgt5js4','2017-11-30 09:19:26'),(340,NULL,'21n0hgq53t3fcp3f1s6739rs51','2017-11-30 09:19:26'),(341,NULL,'tlmkckl3l3takhasltnuusqdh0','2017-11-30 09:52:18'),(342,NULL,'2564f22p4eic5mbg0jireq01i6','2017-11-30 09:52:21'),(343,NULL,'4tqql1eeamhthe7vissttrbt81','2017-11-30 09:52:21'),(344,NULL,'8h3l5131cnq0feodff74945mi3','2017-11-30 10:03:30'),(345,NULL,'losibtucvon2ovm9bfm50m8r37','2017-11-30 10:03:47'),(346,NULL,'losibtucvon2ovm9bfm50m8r37','2017-11-30 11:03:32'),(347,NULL,'lfpntc1gcj1fc4455cc63pi501','2017-11-30 11:03:55'),(348,NULL,'o647v7afdfttag4ip0nn5muag3','2017-11-30 11:03:55'),(349,'3','imha97l2658aoegjo3tscfc107','2017-11-30 13:18:48'),(350,NULL,'301mlktjfpao8ake4ricq3tsq3','2017-12-01 08:30:57'),(351,NULL,'9empr97jqe8troqrt65em9f2j1','2017-12-01 08:28:09'),(352,NULL,'sv4psv8o1s26l7mhjvqi1jj5v4','2017-12-01 08:28:09'),(353,NULL,'lmn0u01h2g0rih9jc52sug0uu6','2017-12-01 13:31:34'),(354,'3','7vmnld7i9tudo926tehedvcn64','2017-12-01 15:32:54'),(355,NULL,'71ootdc6ehkn0273v7htl7g6i7','2017-12-01 13:31:34'),(356,NULL,'66vfije9mjvj3al51fhe72hgf0','2017-12-01 13:41:14'),(357,NULL,'a8e45g4cjbe3ocb10tkgfn0eu7','2017-12-01 13:41:14'),(358,NULL,'723c3jev0bffqj481p68o1ivi4','2017-12-01 13:41:51'),(359,NULL,'cjglmdstmed9agrv0nf18j0c40','2017-12-01 13:44:32'),(360,NULL,'c9oh7idos8a4enetnri5kcdtj5','2017-12-01 13:44:32'),(361,NULL,'3a0ohaf9larhh4nmg7hr4og892','2017-12-01 13:44:41'),(362,NULL,'8m055jdsecl7d5028nungd7486','2017-12-01 13:44:41'),(363,NULL,'jj705bcmch7vr448nuuc0c9t34','2017-12-01 13:47:03'),(364,NULL,'easaqh89mh12c2a0eechntske2','2017-12-01 13:47:03'),(365,NULL,'epu549d8seoiflrs6isfqalfp0','2017-12-01 15:10:28'),(366,NULL,'kau42nltiitulqbfb8uk7cht15','2017-12-01 15:10:32'),(367,NULL,'evjjnnoji4g3soicv8vv1btkj1','2017-12-01 15:10:32'),(368,NULL,'9af2imugf55q7j8thbf0push85','2017-12-01 15:50:17'),(369,NULL,'iv9spba7fh1paf06mr3dt12o30','2017-12-01 15:38:14'),(370,NULL,'gujekcqhva3qqbcgg9gm88rjg4','2017-12-01 15:53:21'),(371,NULL,'pgj75o0o8fl4i1u4vvnt31ksk4','2017-12-01 15:54:08'),(372,NULL,'06osj562cmsc4rlr00csuu16r4','2017-12-01 15:54:10'),(373,NULL,'sb9542lt83avrnip6pau68g3d7','2017-12-01 15:54:10'),(374,NULL,'99qpodbvqs2v9c4d0jogjvb211','2017-12-01 15:54:22'),(375,NULL,'gf66cs9q7qd8nn5u2ua0ncdkc6','2017-12-01 15:54:23'),(376,NULL,'63r5dv5p9r45adnpl8lqqck3b4','2017-12-01 16:00:17'),(377,NULL,'blkkq3rnvom19d5tehvvsq9il3','2017-12-01 16:01:10'),(378,NULL,'9qn0nnlclf8124co25rflbnog6','2017-12-01 16:01:15'),(379,NULL,'8p8mkqcmh2uvjgei16gdslgoi6','2017-12-06 09:14:36'),(380,NULL,'cgufkmhct6a804mobt7ihpn1k6','2017-12-06 10:33:44'),(381,NULL,'pvb2qo86as79omvc37f7hqdjm4','2017-12-06 10:33:44'),(382,NULL,'bvqjlquv5oihn0n06e7ssfnf82','2017-12-06 10:41:49'),(383,NULL,'tc2uh68ao8l70s3jklkcehhnl5','2017-12-06 10:41:49'),(384,NULL,'vakec18dvprujs3qnukribvs36','2017-12-06 11:54:38'),(385,NULL,'m5usimq7dnfvakm9fo0uq7apl4','2017-12-06 11:54:38'),(386,NULL,'me7sh5oqtt63nee4n3v898pmb4','2017-12-06 11:56:44'),(387,NULL,'tndt4vt94idtpra2dqso4terl3','2017-12-06 11:56:51'),(388,'3','j5utn4ufv6lem7chuevgstuok5','2017-12-06 12:48:57'),(389,NULL,'323cqa4dhnf7c54vutjb9n1n73','2017-12-06 11:56:51'),(390,NULL,'q3pjjt7qoa58tvk2j35vlo1k06','2017-12-06 11:59:40'),(391,NULL,'ubh2l7fncmmnbfq4vv4qfl9vo0','2017-12-06 11:59:40'),(392,NULL,'ch6pvm84mmrceqi9mqtdar8gc3','2017-12-06 12:00:08'),(393,NULL,'f7c386cde1lij2qaim2i4rao05','2017-12-06 13:57:44'),(394,NULL,'j30ti1iuum846l41k3qd8uler2','2017-12-06 13:57:48'),(395,NULL,'mbrjgqt15i3citoii8bqhggvp4','2017-12-06 13:57:48'),(396,NULL,'tu3labkd37qsl9i0jqr3ss4855','2017-12-06 14:13:58'),(397,NULL,'enof0ssrl7ssfciias2qb4b334','2017-12-06 13:57:50'),(398,NULL,'r0lvua1nsj5peun9pv90umtm27','2017-12-06 13:57:50'),(399,NULL,'8fev90e0bij6tt82tbk4jlgf91','2017-12-07 09:01:34'),(400,NULL,'45cn4u9bt6n8agsikc0hqdkpq7','2017-12-07 09:07:19'),(401,NULL,'1tagtfor0hn29d9h7sfv1a3g80','2017-12-07 16:03:03'),(402,NULL,'fmrnq2an5p0r8qsvgtk8qfbej5','2017-12-07 16:03:07'),(403,NULL,'sqokhatm64k29henjnqoq4ks11','2017-12-07 16:03:07'),(404,NULL,'gvurk528j8qr3qaebbnfm2e7o2','2017-12-08 09:22:01'),(405,NULL,'gqs8v73od4vgqtisbuitnfs051','2017-12-08 09:22:09'),(406,NULL,'v1stu3mh0if8f12riub3qdie50','2017-12-08 09:22:09'),(407,NULL,'kl5ssreea3asheo8s551jkfn01','2017-12-12 12:23:25'),(408,NULL,'14h1b4475a8cv4g3l8qruadu47','2017-12-12 12:23:29'),(409,NULL,'o83ev6lfda6u6u77r464803c10','2017-12-12 12:23:29'),(410,NULL,'l6rc22sqnp1pedo5ij86n7tu82','2017-12-12 12:23:31'),(411,NULL,'0geb63jrla586orfn0mbd3cp83','2017-12-12 13:57:50'),(412,NULL,'ht3lpjvd77825ibmf2rfisvg01','2017-12-12 12:23:32'),(413,NULL,'4lcqh4h4p15bg6nov775s8dce0','2017-12-13 12:25:29'),(414,NULL,'l1tjabkojdofmh6ejpbj63jtg0','2017-12-13 12:25:33'),(415,NULL,'rde7h78s3d4mqc47figd90ofl3','2017-12-13 12:25:33'),(416,NULL,'c6mkt56s3hgbe3vueaecfpm5i1','2017-12-13 13:20:13'),(417,NULL,'bt2tlr0vq7442h09jnqunmftv3','2017-12-14 09:14:24'),(418,NULL,'5jmircr4n05nq95kfqna3fnci3','2017-12-14 09:14:31'),(419,NULL,'t786g963e5dj3l2m86nb7vsms2','2017-12-14 09:14:31'),(420,NULL,'r3vdrl0psv6r6f030362msrmg3','2017-12-14 09:14:31'),(421,NULL,'1q6k6u402abjqkm20356p1gmf4','2017-12-18 10:54:42'),(422,NULL,'r0jdltvvnopp6bevmp56lo83n0','2017-12-18 10:54:46'),(423,NULL,'en42uc02th4o1scutsrb8v2cd3','2017-12-18 10:54:46'),(424,NULL,'5g8f2o08b0e2q0cqo54nia6p50','2017-12-18 10:54:51'),(425,NULL,'ovfnbog45plgmqqvk7g05s47a2','2017-12-18 10:54:58'),(426,NULL,'4s7hhjjujq6b7cso4d60oua2p0','2017-12-27 10:53:59'),(427,NULL,'1tvdmae49ahvijvp57fbuas9q2','2017-12-27 10:54:03'),(428,NULL,'gljr17fb7s083nkhaucrk515k4','2017-12-27 10:54:03'),(429,NULL,'2mneufev6u0b92q20kf1b07hb2','2017-12-27 10:54:53'),(430,NULL,'4oi81ful7acfv9b5ruo1713ml5','2017-12-27 10:59:54'),(431,NULL,'4fll8ruspovvbbpmnpq3qp3296','2017-12-28 10:45:02'),(432,NULL,'d6gc99i4g2ggjms4h413lqvg14','2017-12-28 14:39:27'),(433,NULL,'9v67u6qpbo19t98kog6ku2a4i1','2017-12-28 14:39:30'),(434,NULL,'dr7dq6muhenf4moveop4filfn4','2017-12-28 14:39:30'),(435,NULL,'51mfior3eslvu697i8soujdir5','2017-12-28 14:39:31'),(436,NULL,'fpeo6575fn7e9gv6cbrdd9vma7','2018-01-10 13:17:42'),(437,NULL,'kl62qgkq0bndp4jd2m22mqmfo7','2018-01-10 13:17:47'),(438,NULL,'lu58ica7o47ld447cndrd2mvm1','2018-01-10 13:17:47'),(439,NULL,'ueus9jg4g49tuesqjtijb12sd2','2018-01-10 15:01:16'),(440,NULL,'dg6nrq7m7m1g1rjar37mae1bp6','2018-01-10 15:01:27'),(441,NULL,'1j36nlrj725alrqagup2egsjr3','2018-01-10 15:01:27'),(442,NULL,'1c1005pncbmcb5de5r89cnm022','2018-01-10 15:03:47'),(443,NULL,'6dqk3gnkhdiaf0bc4ifb39gni1','2018-01-10 15:06:53'),(444,NULL,'d1gcfe1qq66oi67ij53qssq5o4','2018-01-10 15:03:47'),(445,NULL,'6dqk3gnkhdiaf0bc4ifb39gni1','2018-01-10 15:48:17'),(446,NULL,'g3jeg00nlksppjsegdr73duvj3','2018-01-11 08:51:52'),(447,NULL,'4ockshk2tgib4g50bbpbq60df1','2018-01-11 08:51:52'),(448,NULL,'j5jkmm5p8gptq1rict02nllvi0','2018-01-11 08:51:52'),(449,NULL,'6l9vg5aa7l34cmg1e86is17ls0','2018-01-11 12:03:39'),(450,NULL,'32qug2q8ti2lsdu97vtqehcl01','2018-01-11 12:07:20'),(451,NULL,'8qu2ic9utks7nteq110ort0li7','2018-01-11 12:03:39'),(452,NULL,'32qug2q8ti2lsdu97vtqehcl01','2018-01-11 12:58:26'),(453,NULL,'o614dlid32pacomk936mifhic3','2018-01-11 13:07:31'),(454,NULL,'f1lkrcae6ib07dt5vog1cpjji0','2018-01-11 13:07:40'),(455,NULL,'p34t07lgj0j26horj36ns0b7e2','2018-01-11 13:07:40'),(456,NULL,'84u8m10a3d4mhk570nh1vpb0k7','2018-01-11 13:09:16'),(457,NULL,'7k98tihj3aqr7ilsj4qbqmq1j4','2018-01-11 13:09:04'),(458,NULL,'s81baoqa4dl83id1plkp403ac1','2018-01-11 13:09:05'),(459,NULL,'84u8m10a3d4mhk570nh1vpb0k7','2018-01-11 13:48:48'),(460,NULL,'gplct20e630080539oe5go9au2','2018-01-11 14:56:42'),(461,NULL,'3pmu771v2fe23vc0l821kb2e84','2018-01-11 14:58:42'),(462,NULL,'sq6bjkkvsm26ev9e6bltpb9ib5','2018-01-11 15:06:43'),(463,NULL,'it76oecn3i2i5hvbs7rv5khis3','2018-01-11 15:08:17'),(464,NULL,'7k5gim9g0qeid9gfknp5fqnj44','2018-01-11 15:11:46'),(465,NULL,'tvb9j97l2uem5mng7ai8l0djh4','2018-01-11 15:16:20'),(466,NULL,'0f1sm27l9gtisc1rkronh2vrf4','2018-01-11 15:18:25'),(467,NULL,'bv1lqvcerc0u7ec869lcvr32i1','2018-01-11 15:20:39'),(468,NULL,'4vpqb1s66b8lqtvp12jm0a39e5','2018-01-11 15:21:18'),(469,NULL,'6mue3t2msrcb4fd16hn1asv2t7','2018-01-11 15:22:59'),(470,NULL,'os539g1ctiud85ga3dikmfajr7','2018-01-11 15:23:03'),(471,NULL,'93mf3fqsm0hur4eulivq6ft9j3','2018-01-11 15:23:03'),(472,NULL,'ht6ge1a57snqqqqbeksiqp6qi5','2018-01-11 15:23:06'),(473,NULL,'isp03dlsse4h9flp3ij3kd6cq5','2018-01-11 15:24:03'),(474,NULL,'639ono1fkqmeehdsqfg9i9uf63','2018-01-11 15:23:07');

--
-- Table structure for table `design_change`
--

CREATE TABLE `design_change` (
  `design_change_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Design Change Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `design` varchar(255) DEFAULT NULL COMMENT 'Design',
  `date_from` date DEFAULT NULL COMMENT 'First Date of Design Activity',
  `date_to` date DEFAULT NULL COMMENT 'Last Date of Design Activity',
  PRIMARY KEY (`design_change_id`),
  KEY `DESIGN_CHANGE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Design Changes';

--
-- Table structure for table `design_config_grid_flat`
--

CREATE TABLE `design_config_grid_flat` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `store_website_id` int(11) DEFAULT NULL COMMENT 'Store_website_id',
  `store_group_id` int(11) DEFAULT NULL COMMENT 'Store_group_id',
  `store_id` int(11) DEFAULT NULL COMMENT 'Store_id',
  `theme_theme_id` varchar(255) DEFAULT NULL COMMENT 'Theme_theme_id',
  PRIMARY KEY (`entity_id`),
  KEY `DESIGN_CONFIG_GRID_FLAT_STORE_WEBSITE_ID` (`store_website_id`),
  KEY `DESIGN_CONFIG_GRID_FLAT_STORE_GROUP_ID` (`store_group_id`),
  KEY `DESIGN_CONFIG_GRID_FLAT_STORE_ID` (`store_id`),
  FULLTEXT KEY `DESIGN_CONFIG_GRID_FLAT_THEME_THEME_ID` (`theme_theme_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='design_config_grid_flat';

--
-- Dumping data for table `design_config_grid_flat`
--

INSERT INTO `design_config_grid_flat` VALUES ('0',NULL,NULL,NULL,'5'),('1','1',NULL,NULL,'5'),('2','1','1','1','5');

--
-- Table structure for table `directory_country`
--

CREATE TABLE `directory_country` (
  `country_id` varchar(2) NOT NULL COMMENT 'Country Id in ISO-2',
  `iso2_code` varchar(2) DEFAULT NULL COMMENT 'Country ISO-2 format',
  `iso3_code` varchar(3) DEFAULT NULL COMMENT 'Country ISO-3',
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Country';

--
-- Dumping data for table `directory_country`
--

INSERT INTO `directory_country` VALUES ('AD','AD','AND'),('AE','AE','ARE'),('AF','AF','AFG'),('AG','AG','ATG'),('AI','AI','AIA'),('AL','AL','ALB'),('AM','AM','ARM'),('AN','AN','ANT'),('AO','AO','AGO'),('AQ','AQ','ATA'),('AR','AR','ARG'),('AS','AS','ASM'),('AT','AT','AUT'),('AU','AU','AUS'),('AW','AW','ABW'),('AX','AX','ALA'),('AZ','AZ','AZE'),('BA','BA','BIH'),('BB','BB','BRB'),('BD','BD','BGD'),('BE','BE','BEL'),('BF','BF','BFA'),('BG','BG','BGR'),('BH','BH','BHR'),('BI','BI','BDI'),('BJ','BJ','BEN'),('BL','BL','BLM'),('BM','BM','BMU'),('BN','BN','BRN'),('BO','BO','BOL'),('BR','BR','BRA'),('BS','BS','BHS'),('BT','BT','BTN'),('BV','BV','BVT'),('BW','BW','BWA'),('BY','BY','BLR'),('BZ','BZ','BLZ'),('CA','CA','CAN'),('CC','CC','CCK'),('CD','CD','COD'),('CF','CF','CAF'),('CG','CG','COG'),('CH','CH','CHE'),('CI','CI','CIV'),('CK','CK','COK'),('CL','CL','CHL'),('CM','CM','CMR'),('CN','CN','CHN'),('CO','CO','COL'),('CR','CR','CRI'),('CU','CU','CUB'),('CV','CV','CPV'),('CX','CX','CXR'),('CY','CY','CYP'),('CZ','CZ','CZE'),('DE','DE','DEU'),('DJ','DJ','DJI'),('DK','DK','DNK'),('DM','DM','DMA'),('DO','DO','DOM'),('DZ','DZ','DZA'),('EC','EC','ECU'),('EE','EE','EST'),('EG','EG','EGY'),('EH','EH','ESH'),('ER','ER','ERI'),('ES','ES','ESP'),('ET','ET','ETH'),('FI','FI','FIN'),('FJ','FJ','FJI'),('FK','FK','FLK'),('FM','FM','FSM'),('FO','FO','FRO'),('FR','FR','FRA'),('GA','GA','GAB'),('GB','GB','GBR'),('GD','GD','GRD'),('GE','GE','GEO'),('GF','GF','GUF'),('GG','GG','GGY'),('GH','GH','GHA'),('GI','GI','GIB'),('GL','GL','GRL'),('GM','GM','GMB'),('GN','GN','GIN'),('GP','GP','GLP'),('GQ','GQ','GNQ'),('GR','GR','GRC'),('GS','GS','SGS'),('GT','GT','GTM'),('GU','GU','GUM'),('GW','GW','GNB'),('GY','GY','GUY'),('HK','HK','HKG'),('HM','HM','HMD'),('HN','HN','HND'),('HR','HR','HRV'),('HT','HT','HTI'),('HU','HU','HUN'),('ID','ID','IDN'),('IE','IE','IRL'),('IL','IL','ISR'),('IM','IM','IMN'),('IN','IN','IND'),('IO','IO','IOT'),('IQ','IQ','IRQ'),('IR','IR','IRN'),('IS','IS','ISL'),('IT','IT','ITA'),('JE','JE','JEY'),('JM','JM','JAM'),('JO','JO','JOR'),('JP','JP','JPN'),('KE','KE','KEN'),('KG','KG','KGZ'),('KH','KH','KHM'),('KI','KI','KIR'),('KM','KM','COM'),('KN','KN','KNA'),('KP','KP','PRK'),('KR','KR','KOR'),('KW','KW','KWT'),('KY','KY','CYM'),('KZ','KZ','KAZ'),('LA','LA','LAO'),('LB','LB','LBN'),('LC','LC','LCA'),('LI','LI','LIE'),('LK','LK','LKA'),('LR','LR','LBR'),('LS','LS','LSO'),('LT','LT','LTU'),('LU','LU','LUX'),('LV','LV','LVA'),('LY','LY','LBY'),('MA','MA','MAR'),('MC','MC','MCO'),('MD','MD','MDA'),('ME','ME','MNE'),('MF','MF','MAF'),('MG','MG','MDG'),('MH','MH','MHL'),('MK','MK','MKD'),('ML','ML','MLI'),('MM','MM','MMR'),('MN','MN','MNG'),('MO','MO','MAC'),('MP','MP','MNP'),('MQ','MQ','MTQ'),('MR','MR','MRT'),('MS','MS','MSR'),('MT','MT','MLT'),('MU','MU','MUS'),('MV','MV','MDV'),('MW','MW','MWI'),('MX','MX','MEX'),('MY','MY','MYS'),('MZ','MZ','MOZ'),('NA','NA','NAM'),('NC','NC','NCL'),('NE','NE','NER'),('NF','NF','NFK'),('NG','NG','NGA'),('NI','NI','NIC'),('NL','NL','NLD'),('NO','NO','NOR'),('NP','NP','NPL'),('NR','NR','NRU'),('NU','NU','NIU'),('NZ','NZ','NZL'),('OM','OM','OMN'),('PA','PA','PAN'),('PE','PE','PER'),('PF','PF','PYF'),('PG','PG','PNG'),('PH','PH','PHL'),('PK','PK','PAK'),('PL','PL','POL'),('PM','PM','SPM'),('PN','PN','PCN'),('PS','PS','PSE'),('PT','PT','PRT'),('PW','PW','PLW'),('PY','PY','PRY'),('QA','QA','QAT'),('RE','RE','REU'),('RO','RO','ROU'),('RS','RS','SRB'),('RU','RU','RUS'),('RW','RW','RWA'),('SA','SA','SAU'),('SB','SB','SLB'),('SC','SC','SYC'),('SD','SD','SDN'),('SE','SE','SWE'),('SG','SG','SGP'),('SH','SH','SHN'),('SI','SI','SVN'),('SJ','SJ','SJM'),('SK','SK','SVK'),('SL','SL','SLE'),('SM','SM','SMR'),('SN','SN','SEN'),('SO','SO','SOM'),('SR','SR','SUR'),('ST','ST','STP'),('SV','SV','SLV'),('SY','SY','SYR'),('SZ','SZ','SWZ'),('TC','TC','TCA'),('TD','TD','TCD'),('TF','TF','ATF'),('TG','TG','TGO'),('TH','TH','THA'),('TJ','TJ','TJK'),('TK','TK','TKL'),('TL','TL','TLS'),('TM','TM','TKM'),('TN','TN','TUN'),('TO','TO','TON'),('TR','TR','TUR'),('TT','TT','TTO'),('TV','TV','TUV'),('TW','TW','TWN'),('TZ','TZ','TZA'),('UA','UA','UKR'),('UG','UG','UGA'),('UM','UM','UMI'),('US','US','USA'),('UY','UY','URY'),('UZ','UZ','UZB'),('VA','VA','VAT'),('VC','VC','VCT'),('VE','VE','VEN'),('VG','VG','VGB'),('VI','VI','VIR'),('VN','VN','VNM'),('VU','VU','VUT'),('WF','WF','WLF'),('WS','WS','WSM'),('YE','YE','YEM'),('YT','YT','MYT'),('ZA','ZA','ZAF'),('ZM','ZM','ZMB'),('ZW','ZW','ZWE');

--
-- Table structure for table `directory_country_format`
--

CREATE TABLE `directory_country_format` (
  `country_format_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Country Format Id',
  `country_id` varchar(2) DEFAULT NULL COMMENT 'Country Id in ISO-2',
  `type` varchar(30) DEFAULT NULL COMMENT 'Country Format Type',
  `format` text NOT NULL COMMENT 'Country Format',
  PRIMARY KEY (`country_format_id`),
  UNIQUE KEY `DIRECTORY_COUNTRY_FORMAT_COUNTRY_ID_TYPE` (`country_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Country Format';

--
-- Table structure for table `directory_country_region`
--

CREATE TABLE `directory_country_region` (
  `region_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Region Id',
  `country_id` varchar(4) NOT NULL DEFAULT '0' COMMENT 'Country Id in ISO-2',
  `code` varchar(32) DEFAULT NULL COMMENT 'Region code',
  `default_name` varchar(255) DEFAULT NULL COMMENT 'Region Name',
  PRIMARY KEY (`region_id`),
  KEY `DIRECTORY_COUNTRY_REGION_COUNTRY_ID` (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=533 DEFAULT CHARSET=utf8 COMMENT='Directory Country Region';

--
-- Dumping data for table `directory_country_region`
--

INSERT INTO `directory_country_region` VALUES ('1','US','AL','Alabama'),('2','US','AK','Alaska'),('3','US','AS','American Samoa'),('4','US','AZ','Arizona'),('5','US','AR','Arkansas'),('6','US','AE','Armed Forces Africa'),('7','US','AA','Armed Forces Americas'),('8','US','AE','Armed Forces Canada'),('9','US','AE','Armed Forces Europe'),('10','US','AE','Armed Forces Middle East'),('11','US','AP','Armed Forces Pacific'),('12','US','CA','California'),('13','US','CO','Colorado'),('14','US','CT','Connecticut'),('15','US','DE','Delaware'),('16','US','DC','District of Columbia'),('17','US','FM','Federated States Of Micronesia'),('18','US','FL','Florida'),('19','US','GA','Georgia'),('20','US','GU','Guam'),('21','US','HI','Hawaii'),('22','US','ID','Idaho'),('23','US','IL','Illinois'),('24','US','IN','Indiana'),('25','US','IA','Iowa'),('26','US','KS','Kansas'),('27','US','KY','Kentucky'),('28','US','LA','Louisiana'),('29','US','ME','Maine'),('30','US','MH','Marshall Islands'),('31','US','MD','Maryland'),('32','US','MA','Massachusetts'),('33','US','MI','Michigan'),('34','US','MN','Minnesota'),('35','US','MS','Mississippi'),('36','US','MO','Missouri'),('37','US','MT','Montana'),('38','US','NE','Nebraska'),('39','US','NV','Nevada'),('40','US','NH','New Hampshire'),('41','US','NJ','New Jersey'),('42','US','NM','New Mexico'),('43','US','NY','New York'),('44','US','NC','North Carolina'),('45','US','ND','North Dakota'),('46','US','MP','Northern Mariana Islands'),('47','US','OH','Ohio'),('48','US','OK','Oklahoma'),('49','US','OR','Oregon'),('50','US','PW','Palau'),('51','US','PA','Pennsylvania'),('52','US','PR','Puerto Rico'),('53','US','RI','Rhode Island'),('54','US','SC','South Carolina'),('55','US','SD','South Dakota'),('56','US','TN','Tennessee'),('57','US','TX','Texas'),('58','US','UT','Utah'),('59','US','VT','Vermont'),('60','US','VI','Virgin Islands'),('61','US','VA','Virginia'),('62','US','WA','Washington'),('63','US','WV','West Virginia'),('64','US','WI','Wisconsin'),('65','US','WY','Wyoming'),('66','CA','AB','Alberta'),('67','CA','BC','British Columbia'),('68','CA','MB','Manitoba'),('69','CA','NL','Newfoundland and Labrador'),('70','CA','NB','New Brunswick'),('71','CA','NS','Nova Scotia'),('72','CA','NT','Northwest Territories'),('73','CA','NU','Nunavut'),('74','CA','ON','Ontario'),('75','CA','PE','Prince Edward Island'),('76','CA','QC','Quebec'),('77','CA','SK','Saskatchewan'),('78','CA','YT','Yukon Territory'),('79','DE','NDS','Niedersachsen'),('80','DE','BAW','Baden-Württemberg'),('81','DE','BAY','Bayern'),('82','DE','BER','Berlin'),('83','DE','BRG','Brandenburg'),('84','DE','BRE','Bremen'),('85','DE','HAM','Hamburg'),('86','DE','HES','Hessen'),('87','DE','MEC','Mecklenburg-Vorpommern'),('88','DE','NRW','Nordrhein-Westfalen'),('89','DE','RHE','Rheinland-Pfalz'),('90','DE','SAR','Saarland'),('91','DE','SAS','Sachsen'),('92','DE','SAC','Sachsen-Anhalt'),('93','DE','SCN','Schleswig-Holstein'),('94','DE','THE','Thüringen'),('95','AT','WI','Wien'),('96','AT','NO','Niederösterreich'),('97','AT','OO','Oberösterreich'),('98','AT','SB','Salzburg'),('99','AT','KN','Kärnten'),('100','AT','ST','Steiermark'),('101','AT','TI','Tirol'),('102','AT','BL','Burgenland'),('103','AT','VB','Vorarlberg'),('104','CH','AG','Aargau'),('105','CH','AI','Appenzell Innerrhoden'),('106','CH','AR','Appenzell Ausserrhoden'),('107','CH','BE','Bern'),('108','CH','BL','Basel-Landschaft'),('109','CH','BS','Basel-Stadt'),('110','CH','FR','Freiburg'),('111','CH','GE','Genf'),('112','CH','GL','Glarus'),('113','CH','GR','Graubünden'),('114','CH','JU','Jura'),('115','CH','LU','Luzern'),('116','CH','NE','Neuenburg'),('117','CH','NW','Nidwalden'),('118','CH','OW','Obwalden'),('119','CH','SG','St. Gallen'),('120','CH','SH','Schaffhausen'),('121','CH','SO','Solothurn'),('122','CH','SZ','Schwyz'),('123','CH','TG','Thurgau'),('124','CH','TI','Tessin'),('125','CH','UR','Uri'),('126','CH','VD','Waadt'),('127','CH','VS','Wallis'),('128','CH','ZG','Zug'),('129','CH','ZH','Zürich'),('130','ES','A Coruсa','A Coruña'),('131','ES','Alava','Alava'),('132','ES','Albacete','Albacete'),('133','ES','Alicante','Alicante'),('134','ES','Almeria','Almeria'),('135','ES','Asturias','Asturias'),('136','ES','Avila','Avila'),('137','ES','Badajoz','Badajoz'),('138','ES','Baleares','Baleares'),('139','ES','Barcelona','Barcelona'),('140','ES','Burgos','Burgos'),('141','ES','Caceres','Caceres'),('142','ES','Cadiz','Cadiz'),('143','ES','Cantabria','Cantabria'),('144','ES','Castellon','Castellon'),('145','ES','Ceuta','Ceuta'),('146','ES','Ciudad Real','Ciudad Real'),('147','ES','Cordoba','Cordoba'),('148','ES','Cuenca','Cuenca'),('149','ES','Girona','Girona'),('150','ES','Granada','Granada'),('151','ES','Guadalajara','Guadalajara'),('152','ES','Guipuzcoa','Guipuzcoa'),('153','ES','Huelva','Huelva'),('154','ES','Huesca','Huesca'),('155','ES','Jaen','Jaen'),('156','ES','La Rioja','La Rioja'),('157','ES','Las Palmas','Las Palmas'),('158','ES','Leon','Leon'),('159','ES','Lleida','Lleida'),('160','ES','Lugo','Lugo'),('161','ES','Madrid','Madrid'),('162','ES','Malaga','Malaga'),('163','ES','Melilla','Melilla'),('164','ES','Murcia','Murcia'),('165','ES','Navarra','Navarra'),('166','ES','Ourense','Ourense'),('167','ES','Palencia','Palencia'),('168','ES','Pontevedra','Pontevedra'),('169','ES','Salamanca','Salamanca'),('170','ES','Santa Cruz de Tenerife','Santa Cruz de Tenerife'),('171','ES','Segovia','Segovia'),('172','ES','Sevilla','Sevilla'),('173','ES','Soria','Soria'),('174','ES','Tarragona','Tarragona'),('175','ES','Teruel','Teruel'),('176','ES','Toledo','Toledo'),('177','ES','Valencia','Valencia'),('178','ES','Valladolid','Valladolid'),('179','ES','Vizcaya','Vizcaya'),('180','ES','Zamora','Zamora'),('181','ES','Zaragoza','Zaragoza'),('182','FR','1','Ain'),('183','FR','2','Aisne'),('184','FR','3','Allier'),('185','FR','4','Alpes-de-Haute-Provence'),('186','FR','5','Hautes-Alpes'),('187','FR','6','Alpes-Maritimes'),('188','FR','7','Ardèche'),('189','FR','8','Ardennes'),('190','FR','9','Ariège'),('191','FR','10','Aube'),('192','FR','11','Aude'),('193','FR','12','Aveyron'),('194','FR','13','Bouches-du-Rhône'),('195','FR','14','Calvados'),('196','FR','15','Cantal'),('197','FR','16','Charente'),('198','FR','17','Charente-Maritime'),('199','FR','18','Cher'),('200','FR','19','Corrèze'),('201','FR','2A','Corse-du-Sud'),('202','FR','2B','Haute-Corse'),('203','FR','21','Côte-d\'Or'),('204','FR','22','Côtes-d\'Armor'),('205','FR','23','Creuse'),('206','FR','24','Dordogne'),('207','FR','25','Doubs'),('208','FR','26','Drôme'),('209','FR','27','Eure'),('210','FR','28','Eure-et-Loir'),('211','FR','29','Finistère'),('212','FR','30','Gard'),('213','FR','31','Haute-Garonne'),('214','FR','32','Gers'),('215','FR','33','Gironde'),('216','FR','34','Hérault'),('217','FR','35','Ille-et-Vilaine'),('218','FR','36','Indre'),('219','FR','37','Indre-et-Loire'),('220','FR','38','Isère'),('221','FR','39','Jura'),('222','FR','40','Landes'),('223','FR','41','Loir-et-Cher'),('224','FR','42','Loire'),('225','FR','43','Haute-Loire'),('226','FR','44','Loire-Atlantique'),('227','FR','45','Loiret'),('228','FR','46','Lot'),('229','FR','47','Lot-et-Garonne'),('230','FR','48','Lozère'),('231','FR','49','Maine-et-Loire'),('232','FR','50','Manche'),('233','FR','51','Marne'),('234','FR','52','Haute-Marne'),('235','FR','53','Mayenne'),('236','FR','54','Meurthe-et-Moselle'),('237','FR','55','Meuse'),('238','FR','56','Morbihan'),('239','FR','57','Moselle'),('240','FR','58','Nièvre'),('241','FR','59','Nord'),('242','FR','60','Oise'),('243','FR','61','Orne'),('244','FR','62','Pas-de-Calais'),('245','FR','63','Puy-de-Dôme'),('246','FR','64','Pyrénées-Atlantiques'),('247','FR','65','Hautes-Pyrénées'),('248','FR','66','Pyrénées-Orientales'),('249','FR','67','Bas-Rhin'),('250','FR','68','Haut-Rhin'),('251','FR','69','Rhône'),('252','FR','70','Haute-Saône'),('253','FR','71','Saône-et-Loire'),('254','FR','72','Sarthe'),('255','FR','73','Savoie'),('256','FR','74','Haute-Savoie'),('257','FR','75','Paris'),('258','FR','76','Seine-Maritime'),('259','FR','77','Seine-et-Marne'),('260','FR','78','Yvelines'),('261','FR','79','Deux-Sèvres'),('262','FR','80','Somme'),('263','FR','81','Tarn'),('264','FR','82','Tarn-et-Garonne'),('265','FR','83','Var'),('266','FR','84','Vaucluse'),('267','FR','85','Vendée'),('268','FR','86','Vienne'),('269','FR','87','Haute-Vienne'),('270','FR','88','Vosges'),('271','FR','89','Yonne'),('272','FR','90','Territoire-de-Belfort'),('273','FR','91','Essonne'),('274','FR','92','Hauts-de-Seine'),('275','FR','93','Seine-Saint-Denis'),('276','FR','94','Val-de-Marne'),('277','FR','95','Val-d\'Oise'),('278','RO','AB','Alba'),('279','RO','AR','Arad'),('280','RO','AG','Argeş'),('281','RO','BC','Bacău'),('282','RO','BH','Bihor'),('283','RO','BN','Bistriţa-Năsăud'),('284','RO','BT','Botoşani'),('285','RO','BV','Braşov'),('286','RO','BR','Brăila'),('287','RO','B','Bucureşti'),('288','RO','BZ','Buzău'),('289','RO','CS','Caraş-Severin'),('290','RO','CL','Călăraşi'),('291','RO','CJ','Cluj'),('292','RO','CT','Constanţa'),('293','RO','CV','Covasna'),('294','RO','DB','Dâmboviţa'),('295','RO','DJ','Dolj'),('296','RO','GL','Galaţi'),('297','RO','GR','Giurgiu'),('298','RO','GJ','Gorj'),('299','RO','HR','Harghita'),('300','RO','HD','Hunedoara'),('301','RO','IL','Ialomiţa'),('302','RO','IS','Iaşi'),('303','RO','IF','Ilfov'),('304','RO','MM','Maramureş'),('305','RO','MH','Mehedinţi'),('306','RO','MS','Mureş'),('307','RO','NT','Neamţ'),('308','RO','OT','Olt'),('309','RO','PH','Prahova'),('310','RO','SM','Satu-Mare'),('311','RO','SJ','Sălaj'),('312','RO','SB','Sibiu'),('313','RO','SV','Suceava'),('314','RO','TR','Teleorman'),('315','RO','TM','Timiş'),('316','RO','TL','Tulcea'),('317','RO','VS','Vaslui'),('318','RO','VL','Vâlcea'),('319','RO','VN','Vrancea'),('320','FI','Lappi','Lappi'),('321','FI','Pohjois-Pohjanmaa','Pohjois-Pohjanmaa'),('322','FI','Kainuu','Kainuu'),('323','FI','Pohjois-Karjala','Pohjois-Karjala'),('324','FI','Pohjois-Savo','Pohjois-Savo'),('325','FI','Etelä-Savo','Etelä-Savo'),('326','FI','Etelä-Pohjanmaa','Etelä-Pohjanmaa'),('327','FI','Pohjanmaa','Pohjanmaa'),('328','FI','Pirkanmaa','Pirkanmaa'),('329','FI','Satakunta','Satakunta'),('330','FI','Keski-Pohjanmaa','Keski-Pohjanmaa'),('331','FI','Keski-Suomi','Keski-Suomi'),('332','FI','Varsinais-Suomi','Varsinais-Suomi'),('333','FI','Etelä-Karjala','Etelä-Karjala'),('334','FI','Päijät-Häme','Päijät-Häme'),('335','FI','Kanta-Häme','Kanta-Häme'),('336','FI','Uusimaa','Uusimaa'),('337','FI','Itä-Uusimaa','Itä-Uusimaa'),('338','FI','Kymenlaakso','Kymenlaakso'),('339','FI','Ahvenanmaa','Ahvenanmaa'),('340','EE','EE-37','Harjumaa'),('341','EE','EE-39','Hiiumaa'),('342','EE','EE-44','Ida-Virumaa'),('343','EE','EE-49','Jõgevamaa'),('344','EE','EE-51','Järvamaa'),('345','EE','EE-57','Läänemaa'),('346','EE','EE-59','Lääne-Virumaa'),('347','EE','EE-65','Põlvamaa'),('348','EE','EE-67','Pärnumaa'),('349','EE','EE-70','Raplamaa'),('350','EE','EE-74','Saaremaa'),('351','EE','EE-78','Tartumaa'),('352','EE','EE-82','Valgamaa'),('353','EE','EE-84','Viljandimaa'),('354','EE','EE-86','Võrumaa'),('355','LV','LV-DGV','Daugavpils'),('356','LV','LV-JEL','Jelgava'),('357','LV','Jēkabpils','Jēkabpils'),('358','LV','LV-JUR','Jūrmala'),('359','LV','LV-LPX','Liepāja'),('360','LV','LV-LE','Liepājas novads'),('361','LV','LV-REZ','Rēzekne'),('362','LV','LV-RIX','Rīga'),('363','LV','LV-RI','Rīgas novads'),('364','LV','Valmiera','Valmiera'),('365','LV','LV-VEN','Ventspils'),('366','LV','Aglonas novads','Aglonas novads'),('367','LV','LV-AI','Aizkraukles novads'),('368','LV','Aizputes novads','Aizputes novads'),('369','LV','Aknīstes novads','Aknīstes novads'),('370','LV','Alojas novads','Alojas novads'),('371','LV','Alsungas novads','Alsungas novads'),('372','LV','LV-AL','Alūksnes novads'),('373','LV','Amatas novads','Amatas novads'),('374','LV','Apes novads','Apes novads'),('375','LV','Auces novads','Auces novads'),('376','LV','Babītes novads','Babītes novads'),('377','LV','Baldones novads','Baldones novads'),('378','LV','Baltinavas novads','Baltinavas novads'),('379','LV','LV-BL','Balvu novads'),('380','LV','LV-BU','Bauskas novads'),('381','LV','Beverīnas novads','Beverīnas novads'),('382','LV','Brocēnu novads','Brocēnu novads'),('383','LV','Burtnieku novads','Burtnieku novads'),('384','LV','Carnikavas novads','Carnikavas novads'),('385','LV','Cesvaines novads','Cesvaines novads'),('386','LV','Ciblas novads','Ciblas novads'),('387','LV','LV-CE','Cēsu novads'),('388','LV','Dagdas novads','Dagdas novads'),('389','LV','LV-DA','Daugavpils novads'),('390','LV','LV-DO','Dobeles novads'),('391','LV','Dundagas novads','Dundagas novads'),('392','LV','Durbes novads','Durbes novads'),('393','LV','Engures novads','Engures novads'),('394','LV','Garkalnes novads','Garkalnes novads'),('395','LV','Grobiņas novads','Grobiņas novads'),('396','LV','LV-GU','Gulbenes novads'),('397','LV','Iecavas novads','Iecavas novads'),('398','LV','Ikšķiles novads','Ikšķiles novads'),('399','LV','Ilūkstes novads','Ilūkstes novads'),('400','LV','Inčukalna novads','Inčukalna novads'),('401','LV','Jaunjelgavas novads','Jaunjelgavas novads'),('402','LV','Jaunpiebalgas novads','Jaunpiebalgas novads'),('403','LV','Jaunpils novads','Jaunpils novads'),('404','LV','LV-JL','Jelgavas novads'),('405','LV','LV-JK','Jēkabpils novads'),('406','LV','Kandavas novads','Kandavas novads'),('407','LV','Kokneses novads','Kokneses novads'),('408','LV','Krimuldas novads','Krimuldas novads'),('409','LV','Krustpils novads','Krustpils novads'),('410','LV','LV-KR','Krāslavas novads'),('411','LV','LV-KU','Kuldīgas novads'),('412','LV','Kārsavas novads','Kārsavas novads'),('413','LV','Lielvārdes novads','Lielvārdes novads'),('414','LV','LV-LM','Limbažu novads'),('415','LV','Lubānas novads','Lubānas novads'),('416','LV','LV-LU','Ludzas novads'),('417','LV','Līgatnes novads','Līgatnes novads'),('418','LV','Līvānu novads','Līvānu novads'),('419','LV','LV-MA','Madonas novads'),('420','LV','Mazsalacas novads','Mazsalacas novads'),('421','LV','Mālpils novads','Mālpils novads'),('422','LV','Mārupes novads','Mārupes novads'),('423','LV','Naukšēnu novads','Naukšēnu novads'),('424','LV','Neretas novads','Neretas novads'),('425','LV','Nīcas novads','Nīcas novads'),('426','LV','LV-OG','Ogres novads'),('427','LV','Olaines novads','Olaines novads'),('428','LV','Ozolnieku novads','Ozolnieku novads'),('429','LV','LV-PR','Preiļu novads'),('430','LV','Priekules novads','Priekules novads'),('431','LV','Priekuļu novads','Priekuļu novads'),('432','LV','Pārgaujas novads','Pārgaujas novads'),('433','LV','Pāvilostas novads','Pāvilostas novads'),('434','LV','Pļaviņu novads','Pļaviņu novads'),('435','LV','Raunas novads','Raunas novads'),('436','LV','Riebiņu novads','Riebiņu novads'),('437','LV','Rojas novads','Rojas novads'),('438','LV','Ropažu novads','Ropažu novads'),('439','LV','Rucavas novads','Rucavas novads'),('440','LV','Rugāju novads','Rugāju novads'),('441','LV','Rundāles novads','Rundāles novads'),('442','LV','LV-RE','Rēzeknes novads'),('443','LV','Rūjienas novads','Rūjienas novads'),('444','LV','Salacgrīvas novads','Salacgrīvas novads'),('445','LV','Salas novads','Salas novads'),('446','LV','Salaspils novads','Salaspils novads'),('447','LV','LV-SA','Saldus novads'),('448','LV','Saulkrastu novads','Saulkrastu novads'),('449','LV','Siguldas novads','Siguldas novads'),('450','LV','Skrundas novads','Skrundas novads'),('451','LV','Skrīveru novads','Skrīveru novads'),('452','LV','Smiltenes novads','Smiltenes novads'),('453','LV','Stopiņu novads','Stopiņu novads'),('454','LV','Strenču novads','Strenču novads'),('455','LV','Sējas novads','Sējas novads'),('456','LV','LV-TA','Talsu novads'),('457','LV','LV-TU','Tukuma novads'),('458','LV','Tērvetes novads','Tērvetes novads'),('459','LV','Vaiņodes novads','Vaiņodes novads'),('460','LV','LV-VK','Valkas novads'),('461','LV','LV-VM','Valmieras novads'),('462','LV','Varakļānu novads','Varakļānu novads'),('463','LV','Vecpiebalgas novads','Vecpiebalgas novads'),('464','LV','Vecumnieku novads','Vecumnieku novads'),('465','LV','LV-VE','Ventspils novads'),('466','LV','Viesītes novads','Viesītes novads'),('467','LV','Viļakas novads','Viļakas novads'),('468','LV','Viļānu novads','Viļānu novads'),('469','LV','Vārkavas novads','Vārkavas novads'),('470','LV','Zilupes novads','Zilupes novads'),('471','LV','Ādažu novads','Ādažu novads'),('472','LV','Ērgļu novads','Ērgļu novads'),('473','LV','Ķeguma novads','Ķeguma novads'),('474','LV','Ķekavas novads','Ķekavas novads'),('475','LT','LT-AL','Alytaus Apskritis'),('476','LT','LT-KU','Kauno Apskritis'),('477','LT','LT-KL','Klaipėdos Apskritis'),('478','LT','LT-MR','Marijampolės Apskritis'),('479','LT','LT-PN','Panevėžio Apskritis'),('480','LT','LT-SA','Šiaulių Apskritis'),('481','LT','LT-TA','Tauragės Apskritis'),('482','LT','LT-TE','Telšių Apskritis'),('483','LT','LT-UT','Utenos Apskritis'),('484','LT','LT-VL','Vilniaus Apskritis'),('485','BR','AC','Acre'),('486','BR','AL','Alagoas'),('487','BR','AP','Amapá'),('488','BR','AM','Amazonas'),('489','BR','BA','Bahia'),('490','BR','CE','Ceará'),('491','BR','ES','Espírito Santo'),('492','BR','GO','Goiás'),('493','BR','MA','Maranhão'),('494','BR','MT','Mato Grosso'),('495','BR','MS','Mato Grosso do Sul'),('496','BR','MG','Minas Gerais'),('497','BR','PA','Pará'),('498','BR','PB','Paraíba'),('499','BR','PR','Paraná'),('500','BR','PE','Pernambuco'),('501','BR','PI','Piauí'),('502','BR','RJ','Rio de Janeiro'),('503','BR','RN','Rio Grande do Norte'),('504','BR','RS','Rio Grande do Sul'),('505','BR','RO','Rondônia'),('506','BR','RR','Roraima'),('507','BR','SC','Santa Catarina'),('508','BR','SP','São Paulo'),('509','BR','SE','Sergipe'),('510','BR','TO','Tocantins'),('511','BR','DF','Distrito Federal'),('512','HR','HR-01','Zagrebačka županija'),('513','HR','HR-02','Krapinsko-zagorska županija'),('514','HR','HR-03','Sisačko-moslavačka županija'),('515','HR','HR-04','Karlovačka županija'),('516','HR','HR-05','Varaždinska županija'),('517','HR','HR-06','Koprivničko-križevačka županija'),('518','HR','HR-07','Bjelovarsko-bilogorska županija'),('519','HR','HR-08','Primorsko-goranska županija'),('520','HR','HR-09','Ličko-senjska županija'),('521','HR','HR-10','Virovitičko-podravska županija'),('522','HR','HR-11','Požeško-slavonska županija'),('523','HR','HR-12','Brodsko-posavska županija'),('524','HR','HR-13','Zadarska županija'),('525','HR','HR-14','Osječko-baranjska županija'),('526','HR','HR-15','Šibensko-kninska županija'),('527','HR','HR-16','Vukovarsko-srijemska županija'),('528','HR','HR-17','Splitsko-dalmatinska županija'),('529','HR','HR-18','Istarska županija'),('530','HR','HR-19','Dubrovačko-neretvanska županija'),('531','HR','HR-20','Međimurska županija'),('532','HR','HR-21','Grad Zagreb');

--
-- Table structure for table `directory_country_region_name`
--

CREATE TABLE `directory_country_region_name` (
  `locale` varchar(8) NOT NULL COMMENT 'Locale',
  `region_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Region Id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Region Name',
  PRIMARY KEY (`locale`,`region_id`),
  KEY `DIRECTORY_COUNTRY_REGION_NAME_REGION_ID` (`region_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Country Region Name';

--
-- Dumping data for table `directory_country_region_name`
--

INSERT INTO `directory_country_region_name` VALUES ('en_US','1','Alabama'),('en_US','2','Alaska'),('en_US','3','American Samoa'),('en_US','4','Arizona'),('en_US','5','Arkansas'),('en_US','6','Armed Forces Africa'),('en_US','7','Armed Forces Americas'),('en_US','8','Armed Forces Canada'),('en_US','9','Armed Forces Europe'),('en_US','10','Armed Forces Middle East'),('en_US','11','Armed Forces Pacific'),('en_US','12','California'),('en_US','13','Colorado'),('en_US','14','Connecticut'),('en_US','15','Delaware'),('en_US','16','District of Columbia'),('en_US','17','Federated States Of Micronesia'),('en_US','18','Florida'),('en_US','19','Georgia'),('en_US','20','Guam'),('en_US','21','Hawaii'),('en_US','22','Idaho'),('en_US','23','Illinois'),('en_US','24','Indiana'),('en_US','25','Iowa'),('en_US','26','Kansas'),('en_US','27','Kentucky'),('en_US','28','Louisiana'),('en_US','29','Maine'),('en_US','30','Marshall Islands'),('en_US','31','Maryland'),('en_US','32','Massachusetts'),('en_US','33','Michigan'),('en_US','34','Minnesota'),('en_US','35','Mississippi'),('en_US','36','Missouri'),('en_US','37','Montana'),('en_US','38','Nebraska'),('en_US','39','Nevada'),('en_US','40','New Hampshire'),('en_US','41','New Jersey'),('en_US','42','New Mexico'),('en_US','43','New York'),('en_US','44','North Carolina'),('en_US','45','North Dakota'),('en_US','46','Northern Mariana Islands'),('en_US','47','Ohio'),('en_US','48','Oklahoma'),('en_US','49','Oregon'),('en_US','50','Palau'),('en_US','51','Pennsylvania'),('en_US','52','Puerto Rico'),('en_US','53','Rhode Island'),('en_US','54','South Carolina'),('en_US','55','South Dakota'),('en_US','56','Tennessee'),('en_US','57','Texas'),('en_US','58','Utah'),('en_US','59','Vermont'),('en_US','60','Virgin Islands'),('en_US','61','Virginia'),('en_US','62','Washington'),('en_US','63','West Virginia'),('en_US','64','Wisconsin'),('en_US','65','Wyoming'),('en_US','66','Alberta'),('en_US','67','British Columbia'),('en_US','68','Manitoba'),('en_US','69','Newfoundland and Labrador'),('en_US','70','New Brunswick'),('en_US','71','Nova Scotia'),('en_US','72','Northwest Territories'),('en_US','73','Nunavut'),('en_US','74','Ontario'),('en_US','75','Prince Edward Island'),('en_US','76','Quebec'),('en_US','77','Saskatchewan'),('en_US','78','Yukon Territory'),('en_US','79','Niedersachsen'),('en_US','80','Baden-Württemberg'),('en_US','81','Bayern'),('en_US','82','Berlin'),('en_US','83','Brandenburg'),('en_US','84','Bremen'),('en_US','85','Hamburg'),('en_US','86','Hessen'),('en_US','87','Mecklenburg-Vorpommern'),('en_US','88','Nordrhein-Westfalen'),('en_US','89','Rheinland-Pfalz'),('en_US','90','Saarland'),('en_US','91','Sachsen'),('en_US','92','Sachsen-Anhalt'),('en_US','93','Schleswig-Holstein'),('en_US','94','Thüringen'),('en_US','95','Wien'),('en_US','96','Niederösterreich'),('en_US','97','Oberösterreich'),('en_US','98','Salzburg'),('en_US','99','Kärnten'),('en_US','100','Steiermark'),('en_US','101','Tirol'),('en_US','102','Burgenland'),('en_US','103','Vorarlberg'),('en_US','104','Aargau'),('en_US','105','Appenzell Innerrhoden'),('en_US','106','Appenzell Ausserrhoden'),('en_US','107','Bern'),('en_US','108','Basel-Landschaft'),('en_US','109','Basel-Stadt'),('en_US','110','Freiburg'),('en_US','111','Genf'),('en_US','112','Glarus'),('en_US','113','Graubünden'),('en_US','114','Jura'),('en_US','115','Luzern'),('en_US','116','Neuenburg'),('en_US','117','Nidwalden'),('en_US','118','Obwalden'),('en_US','119','St. Gallen'),('en_US','120','Schaffhausen'),('en_US','121','Solothurn'),('en_US','122','Schwyz'),('en_US','123','Thurgau'),('en_US','124','Tessin'),('en_US','125','Uri'),('en_US','126','Waadt'),('en_US','127','Wallis'),('en_US','128','Zug'),('en_US','129','Zürich'),('en_US','130','A Coruña'),('en_US','131','Alava'),('en_US','132','Albacete'),('en_US','133','Alicante'),('en_US','134','Almeria'),('en_US','135','Asturias'),('en_US','136','Avila'),('en_US','137','Badajoz'),('en_US','138','Baleares'),('en_US','139','Barcelona'),('en_US','140','Burgos'),('en_US','141','Caceres'),('en_US','142','Cadiz'),('en_US','143','Cantabria'),('en_US','144','Castellon'),('en_US','145','Ceuta'),('en_US','146','Ciudad Real'),('en_US','147','Cordoba'),('en_US','148','Cuenca'),('en_US','149','Girona'),('en_US','150','Granada'),('en_US','151','Guadalajara'),('en_US','152','Guipuzcoa'),('en_US','153','Huelva'),('en_US','154','Huesca'),('en_US','155','Jaen'),('en_US','156','La Rioja'),('en_US','157','Las Palmas'),('en_US','158','Leon'),('en_US','159','Lleida'),('en_US','160','Lugo'),('en_US','161','Madrid'),('en_US','162','Malaga'),('en_US','163','Melilla'),('en_US','164','Murcia'),('en_US','165','Navarra'),('en_US','166','Ourense'),('en_US','167','Palencia'),('en_US','168','Pontevedra'),('en_US','169','Salamanca'),('en_US','170','Santa Cruz de Tenerife'),('en_US','171','Segovia'),('en_US','172','Sevilla'),('en_US','173','Soria'),('en_US','174','Tarragona'),('en_US','175','Teruel'),('en_US','176','Toledo'),('en_US','177','Valencia'),('en_US','178','Valladolid'),('en_US','179','Vizcaya'),('en_US','180','Zamora'),('en_US','181','Zaragoza'),('en_US','182','Ain'),('en_US','183','Aisne'),('en_US','184','Allier'),('en_US','185','Alpes-de-Haute-Provence'),('en_US','186','Hautes-Alpes'),('en_US','187','Alpes-Maritimes'),('en_US','188','Ardèche'),('en_US','189','Ardennes'),('en_US','190','Ariège'),('en_US','191','Aube'),('en_US','192','Aude'),('en_US','193','Aveyron'),('en_US','194','Bouches-du-Rhône'),('en_US','195','Calvados'),('en_US','196','Cantal'),('en_US','197','Charente'),('en_US','198','Charente-Maritime'),('en_US','199','Cher'),('en_US','200','Corrèze'),('en_US','201','Corse-du-Sud'),('en_US','202','Haute-Corse'),('en_US','203','Côte-d\'Or'),('en_US','204','Côtes-d\'Armor'),('en_US','205','Creuse'),('en_US','206','Dordogne'),('en_US','207','Doubs'),('en_US','208','Drôme'),('en_US','209','Eure'),('en_US','210','Eure-et-Loir'),('en_US','211','Finistère'),('en_US','212','Gard'),('en_US','213','Haute-Garonne'),('en_US','214','Gers'),('en_US','215','Gironde'),('en_US','216','Hérault'),('en_US','217','Ille-et-Vilaine'),('en_US','218','Indre'),('en_US','219','Indre-et-Loire'),('en_US','220','Isère'),('en_US','221','Jura'),('en_US','222','Landes'),('en_US','223','Loir-et-Cher'),('en_US','224','Loire'),('en_US','225','Haute-Loire'),('en_US','226','Loire-Atlantique'),('en_US','227','Loiret'),('en_US','228','Lot'),('en_US','229','Lot-et-Garonne'),('en_US','230','Lozère'),('en_US','231','Maine-et-Loire'),('en_US','232','Manche'),('en_US','233','Marne'),('en_US','234','Haute-Marne'),('en_US','235','Mayenne'),('en_US','236','Meurthe-et-Moselle'),('en_US','237','Meuse'),('en_US','238','Morbihan'),('en_US','239','Moselle'),('en_US','240','Nièvre'),('en_US','241','Nord'),('en_US','242','Oise'),('en_US','243','Orne'),('en_US','244','Pas-de-Calais'),('en_US','245','Puy-de-Dôme'),('en_US','246','Pyrénées-Atlantiques'),('en_US','247','Hautes-Pyrénées'),('en_US','248','Pyrénées-Orientales'),('en_US','249','Bas-Rhin'),('en_US','250','Haut-Rhin'),('en_US','251','Rhône'),('en_US','252','Haute-Saône'),('en_US','253','Saône-et-Loire'),('en_US','254','Sarthe'),('en_US','255','Savoie'),('en_US','256','Haute-Savoie'),('en_US','257','Paris'),('en_US','258','Seine-Maritime'),('en_US','259','Seine-et-Marne'),('en_US','260','Yvelines'),('en_US','261','Deux-Sèvres'),('en_US','262','Somme'),('en_US','263','Tarn'),('en_US','264','Tarn-et-Garonne'),('en_US','265','Var'),('en_US','266','Vaucluse'),('en_US','267','Vendée'),('en_US','268','Vienne'),('en_US','269','Haute-Vienne'),('en_US','270','Vosges'),('en_US','271','Yonne'),('en_US','272','Territoire-de-Belfort'),('en_US','273','Essonne'),('en_US','274','Hauts-de-Seine'),('en_US','275','Seine-Saint-Denis'),('en_US','276','Val-de-Marne'),('en_US','277','Val-d\'Oise'),('en_US','278','Alba'),('en_US','279','Arad'),('en_US','280','Argeş'),('en_US','281','Bacău'),('en_US','282','Bihor'),('en_US','283','Bistriţa-Năsăud'),('en_US','284','Botoşani'),('en_US','285','Braşov'),('en_US','286','Brăila'),('en_US','287','Bucureşti'),('en_US','288','Buzău'),('en_US','289','Caraş-Severin'),('en_US','290','Călăraşi'),('en_US','291','Cluj'),('en_US','292','Constanţa'),('en_US','293','Covasna'),('en_US','294','Dâmboviţa'),('en_US','295','Dolj'),('en_US','296','Galaţi'),('en_US','297','Giurgiu'),('en_US','298','Gorj'),('en_US','299','Harghita'),('en_US','300','Hunedoara'),('en_US','301','Ialomiţa'),('en_US','302','Iaşi'),('en_US','303','Ilfov'),('en_US','304','Maramureş'),('en_US','305','Mehedinţi'),('en_US','306','Mureş'),('en_US','307','Neamţ'),('en_US','308','Olt'),('en_US','309','Prahova'),('en_US','310','Satu-Mare'),('en_US','311','Sălaj'),('en_US','312','Sibiu'),('en_US','313','Suceava'),('en_US','314','Teleorman'),('en_US','315','Timiş'),('en_US','316','Tulcea'),('en_US','317','Vaslui'),('en_US','318','Vâlcea'),('en_US','319','Vrancea'),('en_US','320','Lappi'),('en_US','321','Pohjois-Pohjanmaa'),('en_US','322','Kainuu'),('en_US','323','Pohjois-Karjala'),('en_US','324','Pohjois-Savo'),('en_US','325','Etelä-Savo'),('en_US','326','Etelä-Pohjanmaa'),('en_US','327','Pohjanmaa'),('en_US','328','Pirkanmaa'),('en_US','329','Satakunta'),('en_US','330','Keski-Pohjanmaa'),('en_US','331','Keski-Suomi'),('en_US','332','Varsinais-Suomi'),('en_US','333','Etelä-Karjala'),('en_US','334','Päijät-Häme'),('en_US','335','Kanta-Häme'),('en_US','336','Uusimaa'),('en_US','337','Itä-Uusimaa'),('en_US','338','Kymenlaakso'),('en_US','339','Ahvenanmaa'),('en_US','340','Harjumaa'),('en_US','341','Hiiumaa'),('en_US','342','Ida-Virumaa'),('en_US','343','Jõgevamaa'),('en_US','344','Järvamaa'),('en_US','345','Läänemaa'),('en_US','346','Lääne-Virumaa'),('en_US','347','Põlvamaa'),('en_US','348','Pärnumaa'),('en_US','349','Raplamaa'),('en_US','350','Saaremaa'),('en_US','351','Tartumaa'),('en_US','352','Valgamaa'),('en_US','353','Viljandimaa'),('en_US','354','Võrumaa'),('en_US','355','Daugavpils'),('en_US','356','Jelgava'),('en_US','357','Jēkabpils'),('en_US','358','Jūrmala'),('en_US','359','Liepāja'),('en_US','360','Liepājas novads'),('en_US','361','Rēzekne'),('en_US','362','Rīga'),('en_US','363','Rīgas novads'),('en_US','364','Valmiera'),('en_US','365','Ventspils'),('en_US','366','Aglonas novads'),('en_US','367','Aizkraukles novads'),('en_US','368','Aizputes novads'),('en_US','369','Aknīstes novads'),('en_US','370','Alojas novads'),('en_US','371','Alsungas novads'),('en_US','372','Alūksnes novads'),('en_US','373','Amatas novads'),('en_US','374','Apes novads'),('en_US','375','Auces novads'),('en_US','376','Babītes novads'),('en_US','377','Baldones novads'),('en_US','378','Baltinavas novads'),('en_US','379','Balvu novads'),('en_US','380','Bauskas novads'),('en_US','381','Beverīnas novads'),('en_US','382','Brocēnu novads'),('en_US','383','Burtnieku novads'),('en_US','384','Carnikavas novads'),('en_US','385','Cesvaines novads'),('en_US','386','Ciblas novads'),('en_US','387','Cēsu novads'),('en_US','388','Dagdas novads'),('en_US','389','Daugavpils novads'),('en_US','390','Dobeles novads'),('en_US','391','Dundagas novads'),('en_US','392','Durbes novads'),('en_US','393','Engures novads'),('en_US','394','Garkalnes novads'),('en_US','395','Grobiņas novads'),('en_US','396','Gulbenes novads'),('en_US','397','Iecavas novads'),('en_US','398','Ikšķiles novads'),('en_US','399','Ilūkstes novads'),('en_US','400','Inčukalna novads'),('en_US','401','Jaunjelgavas novads'),('en_US','402','Jaunpiebalgas novads'),('en_US','403','Jaunpils novads'),('en_US','404','Jelgavas novads'),('en_US','405','Jēkabpils novads'),('en_US','406','Kandavas novads'),('en_US','407','Kokneses novads'),('en_US','408','Krimuldas novads'),('en_US','409','Krustpils novads'),('en_US','410','Krāslavas novads'),('en_US','411','Kuldīgas novads'),('en_US','412','Kārsavas novads'),('en_US','413','Lielvārdes novads'),('en_US','414','Limbažu novads'),('en_US','415','Lubānas novads'),('en_US','416','Ludzas novads'),('en_US','417','Līgatnes novads'),('en_US','418','Līvānu novads'),('en_US','419','Madonas novads'),('en_US','420','Mazsalacas novads'),('en_US','421','Mālpils novads'),('en_US','422','Mārupes novads'),('en_US','423','Naukšēnu novads'),('en_US','424','Neretas novads'),('en_US','425','Nīcas novads'),('en_US','426','Ogres novads'),('en_US','427','Olaines novads'),('en_US','428','Ozolnieku novads'),('en_US','429','Preiļu novads'),('en_US','430','Priekules novads'),('en_US','431','Priekuļu novads'),('en_US','432','Pārgaujas novads'),('en_US','433','Pāvilostas novads'),('en_US','434','Pļaviņu novads'),('en_US','435','Raunas novads'),('en_US','436','Riebiņu novads'),('en_US','437','Rojas novads'),('en_US','438','Ropažu novads'),('en_US','439','Rucavas novads'),('en_US','440','Rugāju novads'),('en_US','441','Rundāles novads'),('en_US','442','Rēzeknes novads'),('en_US','443','Rūjienas novads'),('en_US','444','Salacgrīvas novads'),('en_US','445','Salas novads'),('en_US','446','Salaspils novads'),('en_US','447','Saldus novads'),('en_US','448','Saulkrastu novads'),('en_US','449','Siguldas novads'),('en_US','450','Skrundas novads'),('en_US','451','Skrīveru novads'),('en_US','452','Smiltenes novads'),('en_US','453','Stopiņu novads'),('en_US','454','Strenču novads'),('en_US','455','Sējas novads'),('en_US','456','Talsu novads'),('en_US','457','Tukuma novads'),('en_US','458','Tērvetes novads'),('en_US','459','Vaiņodes novads'),('en_US','460','Valkas novads'),('en_US','461','Valmieras novads'),('en_US','462','Varakļānu novads'),('en_US','463','Vecpiebalgas novads'),('en_US','464','Vecumnieku novads'),('en_US','465','Ventspils novads'),('en_US','466','Viesītes novads'),('en_US','467','Viļakas novads'),('en_US','468','Viļānu novads'),('en_US','469','Vārkavas novads'),('en_US','470','Zilupes novads'),('en_US','471','Ādažu novads'),('en_US','472','Ērgļu novads'),('en_US','473','Ķeguma novads'),('en_US','474','Ķekavas novads'),('en_US','475','Alytaus Apskritis'),('en_US','476','Kauno Apskritis'),('en_US','477','Klaipėdos Apskritis'),('en_US','478','Marijampolės Apskritis'),('en_US','479','Panevėžio Apskritis'),('en_US','480','Šiaulių Apskritis'),('en_US','481','Tauragės Apskritis'),('en_US','482','Telšių Apskritis'),('en_US','483','Utenos Apskritis'),('en_US','484','Vilniaus Apskritis'),('en_US','485','Acre'),('en_US','486','Alagoas'),('en_US','487','Amapá'),('en_US','488','Amazonas'),('en_US','489','Bahia'),('en_US','490','Ceará'),('en_US','491','Espírito Santo'),('en_US','492','Goiás'),('en_US','493','Maranhão'),('en_US','494','Mato Grosso'),('en_US','495','Mato Grosso do Sul'),('en_US','496','Minas Gerais'),('en_US','497','Pará'),('en_US','498','Paraíba'),('en_US','499','Paraná'),('en_US','500','Pernambuco'),('en_US','501','Piauí'),('en_US','502','Rio de Janeiro'),('en_US','503','Rio Grande do Norte'),('en_US','504','Rio Grande do Sul'),('en_US','505','Rondônia'),('en_US','506','Roraima'),('en_US','507','Santa Catarina'),('en_US','508','São Paulo'),('en_US','509','Sergipe'),('en_US','510','Tocantins'),('en_US','511','Distrito Federal'),('en_US','512','Zagrebačka županija'),('en_US','513','Krapinsko-zagorska županija'),('en_US','514','Sisačko-moslavačka županija'),('en_US','515','Karlovačka županija'),('en_US','516','Varaždinska županija'),('en_US','517','Koprivničko-križevačka županija'),('en_US','518','Bjelovarsko-bilogorska županija'),('en_US','519','Primorsko-goranska županija'),('en_US','520','Ličko-senjska županija'),('en_US','521','Virovitičko-podravska županija'),('en_US','522','Požeško-slavonska županija'),('en_US','523','Brodsko-posavska županija'),('en_US','524','Zadarska županija'),('en_US','525','Osječko-baranjska županija'),('en_US','526','Šibensko-kninska županija'),('en_US','527','Vukovarsko-srijemska županija'),('en_US','528','Splitsko-dalmatinska županija'),('en_US','529','Istarska županija'),('en_US','530','Dubrovačko-neretvanska županija'),('en_US','531','Međimurska županija'),('en_US','532','Grad Zagreb');

--
-- Table structure for table `directory_currency_rate`
--

CREATE TABLE `directory_currency_rate` (
  `currency_from` varchar(3) NOT NULL COMMENT 'Currency Code Convert From',
  `currency_to` varchar(3) NOT NULL COMMENT 'Currency Code Convert To',
  `rate` decimal(24,12) NOT NULL DEFAULT '0.000000000000' COMMENT 'Currency Conversion Rate',
  PRIMARY KEY (`currency_from`,`currency_to`),
  KEY `DIRECTORY_CURRENCY_RATE_CURRENCY_TO` (`currency_to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Currency Rate';

--
-- Dumping data for table `directory_currency_rate`
--

INSERT INTO `directory_currency_rate` VALUES ('EUR','EUR','1.000000000000'),('EUR','USD','1.415000000000'),('USD','EUR','0.706700000000'),('USD','USD','1.000000000000');

--
-- Table structure for table `downloadable_link`
--

CREATE TABLE `downloadable_link` (
  `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Link ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort order',
  `number_of_downloads` int(11) DEFAULT NULL COMMENT 'Number of downloads',
  `is_shareable` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Shareable flag',
  `link_url` varchar(255) DEFAULT NULL COMMENT 'Link Url',
  `link_file` varchar(255) DEFAULT NULL COMMENT 'Link File',
  `link_type` varchar(20) DEFAULT NULL COMMENT 'Link Type',
  `sample_url` varchar(255) DEFAULT NULL COMMENT 'Sample Url',
  `sample_file` varchar(255) DEFAULT NULL COMMENT 'Sample File',
  `sample_type` varchar(20) DEFAULT NULL COMMENT 'Sample Type',
  PRIMARY KEY (`link_id`),
  KEY `DOWNLOADABLE_LINK_PRODUCT_ID_SORT_ORDER` (`product_id`,`sort_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Table';

--
-- Table structure for table `downloadable_link_price`
--

CREATE TABLE `downloadable_link_price` (
  `price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Price ID',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Link ID',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  PRIMARY KEY (`price_id`),
  KEY `DOWNLOADABLE_LINK_PRICE_LINK_ID` (`link_id`),
  KEY `DOWNLOADABLE_LINK_PRICE_WEBSITE_ID` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Price Table';

--
-- Table structure for table `downloadable_link_purchased`
--

CREATE TABLE `downloadable_link_purchased` (
  `purchased_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Purchased ID',
  `order_id` int(10) unsigned DEFAULT '0' COMMENT 'Order ID',
  `order_increment_id` varchar(50) DEFAULT NULL COMMENT 'Order Increment ID',
  `order_item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Order Item ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date of creation',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date of modification',
  `customer_id` int(10) unsigned DEFAULT '0' COMMENT 'Customer ID',
  `product_name` varchar(255) DEFAULT NULL COMMENT 'Product name',
  `product_sku` varchar(255) DEFAULT NULL COMMENT 'Product sku',
  `link_section_title` varchar(255) DEFAULT NULL COMMENT 'Link_section_title',
  PRIMARY KEY (`purchased_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ORDER_ID` (`order_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ORDER_ITEM_ID` (`order_item_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_CUSTOMER_ID` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Purchased Table';

--
-- Table structure for table `downloadable_link_purchased_item`
--

CREATE TABLE `downloadable_link_purchased_item` (
  `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Item ID',
  `purchased_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Purchased ID',
  `order_item_id` int(10) unsigned DEFAULT '0' COMMENT 'Order Item ID',
  `product_id` int(10) unsigned DEFAULT '0' COMMENT 'Product ID',
  `link_hash` varchar(255) DEFAULT NULL COMMENT 'Link hash',
  `number_of_downloads_bought` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of downloads bought',
  `number_of_downloads_used` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of downloads used',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Link ID',
  `link_title` varchar(255) DEFAULT NULL COMMENT 'Link Title',
  `is_shareable` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Shareable Flag',
  `link_url` varchar(255) DEFAULT NULL COMMENT 'Link Url',
  `link_file` varchar(255) DEFAULT NULL COMMENT 'Link File',
  `link_type` varchar(255) DEFAULT NULL COMMENT 'Link Type',
  `status` varchar(50) DEFAULT NULL COMMENT 'Status',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation Time',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Update Time',
  PRIMARY KEY (`item_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ITEM_LINK_HASH` (`link_hash`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ITEM_ORDER_ITEM_ID` (`order_item_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ITEM_PURCHASED_ID` (`purchased_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Purchased Item Table';

--
-- Table structure for table `downloadable_link_title`
--

CREATE TABLE `downloadable_link_title` (
  `title_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Title ID',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Link ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`title_id`),
  UNIQUE KEY `DOWNLOADABLE_LINK_TITLE_LINK_ID_STORE_ID` (`link_id`,`store_id`),
  KEY `DOWNLOADABLE_LINK_TITLE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Link Title Table';

--
-- Table structure for table `downloadable_sample`
--

CREATE TABLE `downloadable_sample` (
  `sample_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Sample ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `sample_url` varchar(255) DEFAULT NULL COMMENT 'Sample URL',
  `sample_file` varchar(255) DEFAULT NULL COMMENT 'Sample file',
  `sample_type` varchar(20) DEFAULT NULL COMMENT 'Sample Type',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`sample_id`),
  KEY `DOWNLOADABLE_SAMPLE_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Sample Table';

--
-- Table structure for table `downloadable_sample_title`
--

CREATE TABLE `downloadable_sample_title` (
  `title_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Title ID',
  `sample_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sample ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`title_id`),
  UNIQUE KEY `DOWNLOADABLE_SAMPLE_TITLE_SAMPLE_ID_STORE_ID` (`sample_id`,`store_id`),
  KEY `DOWNLOADABLE_SAMPLE_TITLE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Sample Title Table';

--
-- Table structure for table `eav_attribute`
--

CREATE TABLE `eav_attribute` (
  `attribute_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_code` varchar(255) NOT NULL COMMENT 'Attribute Code',
  `attribute_model` varchar(255) DEFAULT NULL COMMENT 'Attribute Model',
  `backend_model` varchar(255) DEFAULT NULL COMMENT 'Backend Model',
  `backend_type` varchar(8) NOT NULL DEFAULT 'static' COMMENT 'Backend Type',
  `backend_table` varchar(255) DEFAULT NULL COMMENT 'Backend Table',
  `frontend_model` varchar(255) DEFAULT NULL COMMENT 'Frontend Model',
  `frontend_input` varchar(50) DEFAULT NULL COMMENT 'Frontend Input',
  `frontend_label` varchar(255) DEFAULT NULL COMMENT 'Frontend Label',
  `frontend_class` varchar(255) DEFAULT NULL COMMENT 'Frontend Class',
  `source_model` varchar(255) DEFAULT NULL COMMENT 'Source Model',
  `is_required` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Defines Is Required',
  `is_user_defined` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Defines Is User Defined',
  `default_value` text COMMENT 'Default Value',
  `is_unique` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Defines Is Unique',
  `note` varchar(255) DEFAULT NULL COMMENT 'Note',
  PRIMARY KEY (`attribute_id`),
  UNIQUE KEY `EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE` (`entity_type_id`,`attribute_code`)
) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute';

--
-- Dumping data for table `eav_attribute`
--

INSERT INTO `eav_attribute` VALUES (1,1,'website_id',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Website','static',NULL,NULL,'select','Associate to Website',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Source\\Website',1,0,NULL,0,NULL),(2,1,'store_id',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Store','static',NULL,NULL,'select','Create In',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Source\\Store',1,0,NULL,0,NULL),(3,1,'created_in',NULL,NULL,'static',NULL,NULL,'text','Created From',NULL,NULL,0,0,NULL,0,NULL),(4,1,'prefix',NULL,NULL,'static',NULL,NULL,'text','Prefix',NULL,NULL,0,0,NULL,0,NULL),(5,1,'firstname',NULL,NULL,'static',NULL,NULL,'text','First Name',NULL,NULL,1,0,NULL,0,NULL),(6,1,'middlename',NULL,NULL,'static',NULL,NULL,'text','Middle Name/Initial',NULL,NULL,0,0,NULL,0,NULL),(7,1,'lastname',NULL,NULL,'static',NULL,NULL,'text','Last Name',NULL,NULL,1,0,NULL,0,NULL),(8,1,'suffix',NULL,NULL,'static',NULL,NULL,'text','Suffix',NULL,NULL,0,0,NULL,0,NULL),(9,1,'email',NULL,NULL,'static',NULL,NULL,'text','Email',NULL,NULL,1,0,NULL,0,NULL),(10,1,'group_id',NULL,NULL,'static',NULL,NULL,'select','Group',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Source\\Group',1,0,NULL,0,NULL),(11,1,'dob',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','static',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Frontend\\Datetime','date','Date Of Birth',NULL,NULL,0,0,NULL,0,NULL),(12,1,'password_hash',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Password','static',NULL,NULL,'hidden',NULL,NULL,NULL,0,0,NULL,0,NULL),(13,1,'rp_token',NULL,NULL,'static',NULL,NULL,'hidden',NULL,NULL,NULL,0,0,NULL,0,NULL),(14,1,'rp_token_created_at',NULL,NULL,'static',NULL,NULL,'date',NULL,NULL,NULL,0,0,NULL,0,NULL),(15,1,'default_billing',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Billing','static',NULL,NULL,'text','Default Billing Address',NULL,NULL,0,0,NULL,0,NULL),(16,1,'default_shipping',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Shipping','static',NULL,NULL,'text','Default Shipping Address',NULL,NULL,0,0,NULL,0,NULL),(17,1,'taxvat',NULL,NULL,'static',NULL,NULL,'text','Tax/VAT Number',NULL,NULL,0,0,NULL,0,NULL),(18,1,'confirmation',NULL,NULL,'static',NULL,NULL,'text','Is Confirmed',NULL,NULL,0,0,NULL,0,NULL),(19,1,'created_at',NULL,NULL,'static',NULL,NULL,'date','Created At',NULL,NULL,0,0,NULL,0,NULL),(20,1,'gender',NULL,NULL,'static',NULL,NULL,'select','Gender',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,0,NULL,0,NULL),(21,1,'disable_auto_group_change',NULL,'Magento\\Customer\\Model\\Attribute\\Backend\\Data\\Boolean','static',NULL,NULL,'boolean','Disable Automatic Group Change Based on VAT ID',NULL,NULL,0,0,NULL,0,NULL),(22,2,'prefix',NULL,NULL,'static',NULL,NULL,'text','Prefix',NULL,NULL,0,0,NULL,0,NULL),(23,2,'firstname',NULL,NULL,'static',NULL,NULL,'text','First Name',NULL,NULL,1,0,NULL,0,NULL),(24,2,'middlename',NULL,NULL,'static',NULL,NULL,'text','Middle Name/Initial',NULL,NULL,0,0,NULL,0,NULL),(25,2,'lastname',NULL,NULL,'static',NULL,NULL,'text','Last Name',NULL,NULL,1,0,NULL,0,NULL),(26,2,'suffix',NULL,NULL,'static',NULL,NULL,'text','Suffix',NULL,NULL,0,0,NULL,0,NULL),(27,2,'company',NULL,NULL,'static',NULL,NULL,'text','Company',NULL,NULL,0,0,NULL,0,NULL),(28,2,'street',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\DefaultBackend','static',NULL,NULL,'multiline','Street Address',NULL,NULL,1,0,NULL,0,NULL),(29,2,'city',NULL,NULL,'static',NULL,NULL,'text','City',NULL,NULL,1,0,NULL,0,NULL),(30,2,'country_id',NULL,NULL,'static',NULL,NULL,'select','Country',NULL,'Magento\\Customer\\Model\\ResourceModel\\Address\\Attribute\\Source\\Country',1,0,NULL,0,NULL),(31,2,'region',NULL,'Magento\\Customer\\Model\\ResourceModel\\Address\\Attribute\\Backend\\Region','static',NULL,NULL,'text','State/Province',NULL,NULL,0,0,NULL,0,NULL),(32,2,'region_id',NULL,NULL,'static',NULL,NULL,'hidden','State/Province',NULL,'Magento\\Customer\\Model\\ResourceModel\\Address\\Attribute\\Source\\Region',0,0,NULL,0,NULL),(33,2,'postcode',NULL,NULL,'static',NULL,NULL,'text','Zip/Postal Code',NULL,NULL,0,0,NULL,0,NULL),(34,2,'telephone',NULL,NULL,'static',NULL,NULL,'text','Phone Number',NULL,NULL,1,0,NULL,0,NULL),(35,2,'fax',NULL,NULL,'static',NULL,NULL,'text','Fax',NULL,NULL,0,0,NULL,0,NULL),(36,2,'vat_id',NULL,NULL,'static',NULL,NULL,'text','VAT Number',NULL,NULL,0,0,NULL,0,NULL),(37,2,'vat_is_valid',NULL,NULL,'static',NULL,NULL,'text','VAT number validity',NULL,NULL,0,0,NULL,0,NULL),(38,2,'vat_request_id',NULL,NULL,'static',NULL,NULL,'text','VAT number validation request ID',NULL,NULL,0,0,NULL,0,NULL),(39,2,'vat_request_date',NULL,NULL,'static',NULL,NULL,'text','VAT number validation request date',NULL,NULL,0,0,NULL,0,NULL),(40,2,'vat_request_success',NULL,NULL,'static',NULL,NULL,'text','VAT number validation request success',NULL,NULL,0,0,NULL,0,NULL),(41,1,'updated_at',NULL,NULL,'static',NULL,NULL,'date','Updated At',NULL,NULL,0,0,NULL,0,NULL),(42,3,'name',NULL,NULL,'varchar',NULL,NULL,'text','Name',NULL,NULL,1,0,NULL,0,NULL),(43,3,'is_active',NULL,NULL,'int',NULL,NULL,'select','Is Active',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',1,0,NULL,0,NULL),(44,3,'description',NULL,NULL,'text',NULL,NULL,'textarea','Description',NULL,NULL,0,0,NULL,0,NULL),(45,3,'image',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\Image','varchar',NULL,NULL,'image','Image',NULL,NULL,0,0,NULL,0,NULL),(46,3,'meta_title',NULL,NULL,'varchar',NULL,NULL,'text','Page Title',NULL,NULL,0,0,NULL,0,NULL),(47,3,'meta_keywords',NULL,NULL,'text',NULL,NULL,'textarea','Meta Keywords',NULL,NULL,0,0,NULL,0,NULL),(48,3,'meta_description',NULL,NULL,'text',NULL,NULL,'textarea','Meta Description',NULL,NULL,0,0,NULL,0,NULL),(49,3,'display_mode',NULL,NULL,'varchar',NULL,NULL,'select','Display Mode',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Mode',0,0,NULL,0,NULL),(50,3,'landing_page',NULL,NULL,'int',NULL,NULL,'select','CMS Block',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Page',0,0,NULL,0,NULL),(51,3,'is_anchor',NULL,NULL,'int',NULL,NULL,'select','Is Anchor',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,'1',0,NULL),(52,3,'path',NULL,NULL,'static',NULL,NULL,'text','Path',NULL,NULL,0,0,NULL,0,NULL),(53,3,'position',NULL,NULL,'static',NULL,NULL,'text','Position',NULL,NULL,0,0,NULL,0,NULL),(54,3,'all_children',NULL,NULL,'text',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(55,3,'path_in_store',NULL,NULL,'text',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(56,3,'children',NULL,NULL,'text',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(57,3,'custom_design',NULL,NULL,'varchar',NULL,NULL,'select','Custom Design',NULL,'Magento\\Theme\\Model\\Theme\\Source\\Theme',0,0,NULL,0,NULL),(58,3,'custom_design_from','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute','Magento\\Catalog\\Model\\Attribute\\Backend\\Startdate','datetime',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Frontend\\Datetime','date','Active From',NULL,NULL,0,0,NULL,0,NULL),(59,3,'custom_design_to',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','datetime',NULL,NULL,'date','Active To',NULL,NULL,0,0,NULL,0,NULL),(60,3,'page_layout',NULL,NULL,'varchar',NULL,NULL,'select','Page Layout',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Layout',0,0,NULL,0,NULL),(61,3,'custom_layout_update',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Customlayoutupdate','text',NULL,NULL,'textarea','Custom Layout Update',NULL,NULL,0,0,NULL,0,NULL),(62,3,'level',NULL,NULL,'static',NULL,NULL,'text','Level',NULL,NULL,0,0,NULL,0,NULL),(63,3,'children_count',NULL,NULL,'static',NULL,NULL,'text','Children Count',NULL,NULL,0,0,NULL,0,NULL),(64,3,'available_sort_by',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\Sortby','text',NULL,NULL,'multiselect','Available Product Listing Sort By',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Sortby',1,0,NULL,0,NULL),(65,3,'default_sort_by',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\Sortby','varchar',NULL,NULL,'select','Default Product Listing Sort By',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Sortby',1,0,NULL,0,NULL),(66,3,'include_in_menu',NULL,NULL,'int',NULL,NULL,'select','Include in Navigation Menu',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',1,0,'1',0,NULL),(67,3,'custom_use_parent_settings',NULL,NULL,'int',NULL,NULL,'select','Use Parent Category Settings',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(68,3,'custom_apply_to_products',NULL,NULL,'int',NULL,NULL,'select','Apply To Products',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(69,3,'filter_price_range',NULL,NULL,'decimal',NULL,NULL,'text','Layered Navigation Price Step',NULL,NULL,0,0,NULL,0,NULL),(70,4,'name',NULL,NULL,'varchar',NULL,NULL,'text','Product Name','validate-length maximum-length-255',NULL,1,0,NULL,0,NULL),(71,4,'sku',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Sku','static',NULL,NULL,'text','SKU','validate-length maximum-length-64',NULL,1,0,NULL,1,NULL),(72,4,'description',NULL,NULL,'text',NULL,NULL,'textarea','Description',NULL,NULL,0,0,NULL,0,NULL),(73,4,'short_description',NULL,NULL,'text',NULL,NULL,'textarea','Short Description',NULL,NULL,0,0,NULL,0,NULL),(74,4,'price',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Price',NULL,NULL,1,0,NULL,0,NULL),(75,4,'special_price',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Special Price',NULL,NULL,0,0,NULL,0,NULL),(76,4,'special_from_date',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Startdate','datetime',NULL,NULL,'date','Special Price From Date',NULL,NULL,0,0,NULL,0,NULL),(77,4,'special_to_date',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','datetime',NULL,NULL,'date','Special Price To Date',NULL,NULL,0,0,NULL,0,NULL),(78,4,'cost',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Cost',NULL,NULL,0,1,NULL,0,NULL),(79,4,'weight',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Weight','decimal',NULL,NULL,'weight','Weight',NULL,NULL,0,0,NULL,0,NULL),(81,4,'meta_title',NULL,NULL,'varchar',NULL,NULL,'text','Meta Title',NULL,NULL,0,0,NULL,0,NULL),(82,4,'meta_keyword',NULL,NULL,'text',NULL,NULL,'textarea','Meta Keywords',NULL,NULL,0,0,NULL,0,NULL),(83,4,'meta_description',NULL,NULL,'varchar',NULL,NULL,'textarea','Meta Description',NULL,NULL,0,0,NULL,0,'Maximum 255 chars. Meta Description should optimally be between 150-160 characters'),(84,4,'image',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Base',NULL,NULL,0,0,NULL,0,NULL),(85,4,'small_image',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Small',NULL,NULL,0,0,NULL,0,NULL),(86,4,'thumbnail',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Thumbnail',NULL,NULL,0,0,NULL,0,NULL),(87,4,'media_gallery',NULL,NULL,'static',NULL,NULL,'gallery','Media Gallery',NULL,NULL,0,0,NULL,0,NULL),(88,4,'old_id',NULL,NULL,'int',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(89,4,'tier_price',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Tierprice','decimal',NULL,NULL,'text','Tier Price',NULL,NULL,0,0,NULL,0,NULL),(91,4,'news_from_date',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Startdate','datetime',NULL,NULL,'date','Set Product as New from Date',NULL,NULL,0,0,NULL,0,NULL),(92,4,'news_to_date',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','datetime',NULL,NULL,'date','Set Product as New to Date',NULL,NULL,0,0,NULL,0,NULL),(93,4,'gallery',NULL,NULL,'varchar',NULL,NULL,'gallery','Image Gallery',NULL,NULL,0,0,NULL,0,NULL),(94,4,'status',NULL,NULL,'int',NULL,NULL,'select','Enable Product',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Status',0,0,'1',0,NULL),(95,4,'minimal_price',NULL,NULL,'decimal',NULL,NULL,'price','Minimal Price',NULL,NULL,0,0,NULL,0,NULL),(96,4,'visibility',NULL,NULL,'int',NULL,NULL,'select','Visibility',NULL,'Magento\\Catalog\\Model\\Product\\Visibility',0,0,'4',0,NULL),(97,4,'custom_design',NULL,NULL,'varchar',NULL,NULL,'select','New Theme',NULL,'Magento\\Theme\\Model\\Theme\\Source\\Theme',0,0,NULL,0,NULL),(98,4,'custom_design_from',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Startdate','datetime',NULL,NULL,'date','Active From',NULL,NULL,0,0,NULL,0,NULL),(99,4,'custom_design_to',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','datetime',NULL,NULL,'date','Active To',NULL,NULL,0,0,NULL,0,NULL),(100,4,'custom_layout_update',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Customlayoutupdate','text',NULL,NULL,'textarea','Layout Update XML',NULL,NULL,0,0,NULL,0,NULL),(101,4,'page_layout',NULL,NULL,'varchar',NULL,NULL,'select','Layout',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Layout',0,0,NULL,0,NULL),(102,4,'category_ids',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Category','static',NULL,NULL,'text','Categories',NULL,NULL,0,0,NULL,0,NULL),(103,4,'options_container',NULL,NULL,'varchar',NULL,NULL,'select','Display Product Options In',NULL,'Magento\\Catalog\\Model\\Entity\\Product\\Attribute\\Design\\Options\\Container',0,0,'container2',0,NULL),(104,4,'required_options',NULL,NULL,'static',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(105,4,'has_options',NULL,NULL,'static',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(106,4,'image_label',NULL,NULL,'varchar',NULL,NULL,'text','Image Label',NULL,NULL,0,0,NULL,0,NULL),(107,4,'small_image_label',NULL,NULL,'varchar',NULL,NULL,'text','Small Image Label',NULL,NULL,0,0,NULL,0,NULL),(108,4,'thumbnail_label',NULL,NULL,'varchar',NULL,NULL,'text','Thumbnail Label',NULL,NULL,0,0,NULL,0,NULL),(109,4,'created_at',NULL,NULL,'static',NULL,NULL,'date',NULL,NULL,NULL,1,0,NULL,0,NULL),(110,4,'updated_at',NULL,NULL,'static',NULL,NULL,'date',NULL,NULL,NULL,1,0,NULL,0,NULL),(111,4,'country_of_manufacture',NULL,NULL,'varchar',NULL,NULL,'select','Country of Manufacture',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Countryofmanufacture',0,0,NULL,0,NULL),(112,4,'quantity_and_stock_status',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Stock','int',NULL,NULL,'select','Quantity',NULL,'Magento\\CatalogInventory\\Model\\Source\\Stock',0,0,'1',0,NULL),(113,3,'url_key',NULL,NULL,'varchar',NULL,NULL,'text','URL Key',NULL,NULL,0,0,NULL,0,NULL),(114,3,'url_path',NULL,NULL,'varchar',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(115,4,'url_key',NULL,NULL,'varchar',NULL,NULL,'text','URL Key',NULL,NULL,0,0,NULL,0,NULL),(116,4,'url_path',NULL,NULL,'varchar',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(117,4,'msrp',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Manufacturer\'s Suggested Retail Price',NULL,NULL,0,0,NULL,0,NULL),(118,4,'msrp_display_actual_price_type',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Boolean','varchar',NULL,NULL,'select','Display Actual Price',NULL,'Magento\\Msrp\\Model\\Product\\Attribute\\Source\\Type\\Price',0,0,'0',0,NULL),(119,4,'price_type',NULL,NULL,'int',NULL,NULL,'boolean','Dynamic Price',NULL,NULL,1,0,'0',0,NULL),(120,4,'sku_type',NULL,NULL,'int',NULL,NULL,'boolean','Dynamic SKU',NULL,NULL,1,0,'0',0,NULL),(121,4,'weight_type',NULL,NULL,'int',NULL,NULL,'boolean','Dynamic Weight',NULL,NULL,1,0,'0',0,NULL),(122,4,'price_view',NULL,NULL,'int',NULL,NULL,'select','Price View',NULL,'Magento\\Bundle\\Model\\Product\\Attribute\\Source\\Price\\View',1,0,NULL,0,NULL),(123,4,'shipment_type',NULL,NULL,'int',NULL,NULL,'select','Ship Bundle Items',NULL,'Magento\\Bundle\\Model\\Product\\Attribute\\Source\\Shipment\\Type',1,0,'0',0,NULL),(124,4,'links_purchased_separately',NULL,NULL,'int',NULL,NULL,NULL,'Links can be purchased separately',NULL,NULL,1,0,NULL,0,NULL),(125,4,'samples_title',NULL,NULL,'varchar',NULL,NULL,NULL,'Samples title',NULL,NULL,1,0,NULL,0,NULL),(126,4,'links_title',NULL,NULL,'varchar',NULL,NULL,NULL,'Links title',NULL,NULL,1,0,NULL,0,NULL),(127,4,'links_exist',NULL,NULL,'int',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'0',0,NULL),(128,4,'swatch_image',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Swatch Image',NULL,NULL,0,0,NULL,0,NULL),(129,4,'tax_class_id',NULL,NULL,'int',NULL,NULL,'select','Tax Class',NULL,'Magento\\Tax\\Model\\TaxClass\\Source\\Product',0,0,'2',0,NULL),(130,4,'gift_message_available',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Boolean','varchar',NULL,NULL,'select','Allow Gift Message',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(131,1,'failures_num',NULL,NULL,'static',NULL,NULL,'hidden','Failures Number',NULL,NULL,0,0,NULL,0,NULL),(132,1,'first_failure',NULL,NULL,'static',NULL,NULL,'date','First Failure Date',NULL,NULL,0,0,NULL,0,NULL),(133,1,'lock_expires',NULL,NULL,'static',NULL,NULL,'date','Failures Number',NULL,NULL,0,0,NULL,0,NULL),(134,4,'custom_layout',NULL,NULL,'varchar',NULL,NULL,'select','New Layout',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Layout',0,0,NULL,0,NULL),(137,4,'gender',NULL,NULL,'int',NULL,NULL,'select','Gender',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,1,'',0,NULL),(138,4,'season',NULL,NULL,'int',NULL,NULL,'select','Season',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,1,'',0,NULL),(139,4,'product_type',NULL,NULL,'int',NULL,NULL,'select','Product Type',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,1,'',0,NULL),(140,4,'manufacturer',NULL,NULL,'int',NULL,NULL,'select','Manufacturer',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,1,'',0,NULL),(141,4,'fit',NULL,NULL,'int',NULL,NULL,'select','Fit',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,1,'',0,NULL),(142,4,'occasion',NULL,NULL,'int',NULL,NULL,'select','Occasion',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,1,'',0,NULL),(143,4,'collections',NULL,NULL,'int',NULL,NULL,'select','Collections',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,1,'',0,NULL),(144,4,'care',NULL,NULL,'int',NULL,NULL,'select','Care',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,1,'',0,NULL),(145,4,'color',NULL,NULL,'int',NULL,NULL,'select','Color',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,1,'',0,NULL),(146,3,'thumbnail',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\Image','varchar',NULL,NULL,'image','Thumbnail',NULL,NULL,0,0,NULL,0,NULL),(147,3,'grid_activate',NULL,NULL,'int',NULL,NULL,'select','Activate Image Grid',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(148,3,'icon_class',NULL,NULL,'varchar',NULL,NULL,'text','Css class for Font Icon',NULL,NULL,0,0,NULL,0,NULL),(149,4,'on_hover',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','On Hover',NULL,NULL,0,0,NULL,0,NULL),(150,3,'mm_turn_on',NULL,NULL,'int',NULL,NULL,'select','Turn on megamenu for this category',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,'0',0,NULL),(151,3,'mm_image',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\Image','varchar',NULL,NULL,'image','Category image',NULL,NULL,0,0,NULL,0,NULL),(152,3,'mm_label',NULL,NULL,'varchar',NULL,NULL,'text','Label',NULL,NULL,0,0,NULL,0,NULL),(153,3,'mm_css_class',NULL,NULL,'varchar',NULL,NULL,'text','Css class',NULL,NULL,0,0,NULL,0,NULL),(154,3,'mm_configurator',NULL,'TemplateMonster\\Megamenu\\Model\\Attribute\\Backend\\Configurator','text',NULL,'TemplateMonster\\Megamenu\\Model\\Attribute\\Frontend\\Configurator','text','Configurator',NULL,NULL,0,0,NULL,0,NULL),(155,3,'mm_show_subcategories',NULL,NULL,'int',NULL,NULL,'select','Show subcategories for this category',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,'1',0,NULL),(156,3,'mm_number_of_subcategories',NULL,NULL,'varchar',NULL,NULL,'text','Number of subcategories to show (if empty show all)',NULL,NULL,0,0,NULL,0,NULL),(157,3,'mm_view_mode',NULL,NULL,'varchar',NULL,NULL,'select','View Mode',NULL,'TemplateMonster\\Megamenu\\Model\\Category\\Attribute\\Source\\ViewMode',0,0,'static',0,NULL);

--
-- Table structure for table `eav_attribute_group`
--

CREATE TABLE `eav_attribute_group` (
  `attribute_group_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Group Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set Id',
  `attribute_group_name` varchar(255) DEFAULT NULL COMMENT 'Attribute Group Name',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `default_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Default Id',
  `attribute_group_code` varchar(255) NOT NULL COMMENT 'Attribute Group Code',
  `tab_group_code` varchar(255) DEFAULT NULL COMMENT 'Tab Group Code',
  PRIMARY KEY (`attribute_group_id`),
  UNIQUE KEY `CATALOG_CATEGORY_PRODUCT_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_CODE` (`attribute_set_id`,`attribute_group_code`),
  UNIQUE KEY `EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_NAME` (`attribute_set_id`,`attribute_group_name`),
  KEY `EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_SORT_ORDER` (`attribute_set_id`,`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Group';

--
-- Dumping data for table `eav_attribute_group`
--

INSERT INTO `eav_attribute_group` VALUES (1,1,'General',1,1,'general',NULL),(2,2,'General',1,1,'general',NULL),(3,3,'General',10,1,'general',NULL),(4,3,'General Information',2,0,'general-information',NULL),(5,3,'Display Settings',20,0,'display-settings',NULL),(6,3,'Custom Design',30,0,'custom-design',NULL),(7,4,'Product Details',1,1,'product-details','basic'),(8,4,'Advanced Pricing',5,0,'advanced-pricing','advanced'),(9,4,'Search Engine Optimization',4,0,'search-engine-optimization','basic'),(10,4,'Images',3,0,'image-management','basic'),(11,4,'Design',6,0,'design','advanced'),(12,4,'Autosettings',7,0,'autosettings','advanced'),(13,5,'General',1,1,'general',NULL),(14,6,'General',1,1,'general',NULL),(15,7,'General',1,1,'general',NULL),(16,8,'General',1,1,'general',NULL),(17,4,'Content',2,0,'content','basic'),(18,4,'Schedule Design Update',9,0,'schedule-design-update','advanced'),(19,4,'Bundle Items',8,0,'bundle-items',NULL),(20,4,'Gift Options',10,0,'gift-options',NULL),(21,4,'Shop by Brand',11,0,'shop-by-brand',NULL),(22,9,'Shop by Brand',11,0,'shop-by-brand',NULL),(23,9,'Gift Options',10,0,'gift-options',NULL),(24,9,'Schedule Design Update',9,0,'schedule-design-update','advanced'),(25,9,'Bundle Items',8,0,'bundle-items',NULL),(26,9,'Autosettings',7,0,'autosettings','advanced'),(27,9,'Design',6,0,'design','advanced'),(28,9,'Advanced Pricing',5,0,'advanced-pricing','advanced'),(29,9,'Search Engine Optimization',4,0,'search-engine-optimization','basic'),(30,9,'Images',3,0,'image-management','basic'),(31,9,'Content',2,0,'content','basic'),(32,9,'Product Details',1,1,'product-details','basic'),(33,3,'Content',31,0,'content',NULL),(34,3,'Catalog Images Grid',60,0,'catalog-images-grid',NULL),(35,3,'Megamenu',61,0,'megamenu',NULL);

--
-- Table structure for table `eav_attribute_label`
--

CREATE TABLE `eav_attribute_label` (
  `attribute_label_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Label Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`attribute_label_id`),
  KEY `EAV_ATTRIBUTE_LABEL_STORE_ID` (`store_id`),
  KEY `EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID_STORE_ID` (`attribute_id`,`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Label';

--
-- Dumping data for table `eav_attribute_label`
--

INSERT INTO `eav_attribute_label` VALUES ('76',137,1,'Gender'),('79',138,1,'Season'),('82',139,1,'Product Type'),('88',141,1,'Fit'),('94',143,1,'Collection'),('97',144,1,'Care'),('103',140,1,'Manufacturer'),('106',142,1,'Occasion'),('109',145,1,'Color');

--
-- Table structure for table `eav_attribute_option`
--

CREATE TABLE `eav_attribute_option` (
  `option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`option_id`),
  KEY `EAV_ATTRIBUTE_OPTION_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Option';

--
-- Dumping data for table `eav_attribute_option`
--

INSERT INTO `eav_attribute_option` VALUES ('1',20,0),('2',20,1),('3',20,3),('4',137,1),('5',137,2),('6',137,3),('7',138,1),('8',138,2),('9',139,1),('10',139,2),('11',139,3),('12',140,1),('13',140,2),('14',140,3),('15',140,4),('16',141,1),('17',141,2),('18',142,1),('19',142,2),('20',142,3),('21',143,1),('22',144,1),('23',144,2),('24',144,3),('25',145,1),('26',145,2),('27',145,3),('28',145,4),('29',145,5),('30',145,6);

--
-- Table structure for table `eav_attribute_option_swatch`
--

CREATE TABLE `eav_attribute_option_swatch` (
  `swatch_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Swatch ID',
  `option_id` int(10) unsigned NOT NULL COMMENT 'Option ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `type` smallint(5) unsigned NOT NULL COMMENT 'Swatch type: 0 - text, 1 - visual color, 2 - visual image',
  `value` varchar(255) DEFAULT NULL COMMENT 'Swatch Value',
  PRIMARY KEY (`swatch_id`),
  UNIQUE KEY `EAV_ATTRIBUTE_OPTION_SWATCH_STORE_ID_OPTION_ID` (`store_id`,`option_id`),
  KEY `EAV_ATTRIBUTE_OPTION_SWATCH_SWATCH_ID` (`swatch_id`),
  KEY `EAV_ATTR_OPT_SWATCH_OPT_ID_EAV_ATTR_OPT_OPT_ID` (`option_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Magento Swatches table';

--
-- Dumping data for table `eav_attribute_option_swatch`
--

INSERT INTO `eav_attribute_option_swatch` VALUES ('1','25',0,1,'#000000'),('2','26',0,1,'#ffffff'),('3','27',0,1,'#91f2f0'),('4','28',0,1,'#a3a3a3'),('5','29',0,1,'#f2c2f2'),('6','30',0,1,'#3a8744');

--
-- Table structure for table `eav_attribute_option_value`
--

CREATE TABLE `eav_attribute_option_value` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  KEY `EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID` (`option_id`),
  KEY `EAV_ATTRIBUTE_OPTION_VALUE_STORE_ID` (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Option Value';

--
-- Dumping data for table `eav_attribute_option_value`
--

INSERT INTO `eav_attribute_option_value` VALUES ('1','1',0,'Male'),('2','2',0,'Female'),('3','3',0,'Not Specified'),('4','4',1,'for Her'),('5','4',0,'for Her'),('8','5',1,'for Him'),('9','5',0,'for Him'),('12','6',1,'Neural'),('13','6',0,'Neural'),('16','7',1,'Autumn/Winter'),('17','7',0,'Autumn/Winter'),('20','8',1,'Spring/Summer'),('21','8',0,'Spring/Summer'),('24','9',1,'Clothing'),('25','9',0,'Clothing'),('28','10',1,'Bags'),('29','10',0,'Bags'),('32','11',1,'Shoes'),('33','11',0,'Shoes'),('52','16',1,'Comfort'),('53','16',0,'Comfort'),('56','17',1,'Regular'),('57','17',0,'Regular'),('72','21',1,'Limited'),('73','21',0,'Limited'),('76','22',1,'Hand wash'),('77','22',0,'Hand wash'),('80','23',1,'Machine wash'),('81','23',0,'Machine wash'),('84','24',1,'Dry cleaning'),('85','24',0,'Dry cleaning'),('88','25',1,'black'),('89','25',0,'black'),('92','26',1,'blue'),('93','26',0,'white'),('96','27',1,'blue'),('97','27',0,'blue'),('100','28',1,'gray'),('101','28',0,'gray'),('104','29',1,'pink'),('105','29',0,'pink'),('108','30',1,'green'),('109','30',0,'green'),('112','12',1,'USA'),('113','12',0,'USA'),('116','13',1,'China'),('117','13',0,'China'),('120','14',1,'Germany'),('121','14',0,'Germany'),('124','15',1,'Italy'),('125','15',0,'Italy'),('128','18',1,'Casual'),('129','18',0,'Casual'),('132','19',1,'Office & Career '),('133','19',0,'Office & Career '),('136','20',1,'Evening & Cocktail'),('137','20',0,'Evening & Cocktail');

--
-- Table structure for table `eav_attribute_set`
--

CREATE TABLE `eav_attribute_set` (
  `attribute_set_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Set Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_set_name` varchar(255) DEFAULT NULL COMMENT 'Attribute Set Name',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`attribute_set_id`),
  UNIQUE KEY `EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_ATTRIBUTE_SET_NAME` (`entity_type_id`,`attribute_set_name`),
  KEY `EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_SORT_ORDER` (`entity_type_id`,`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Set';

--
-- Dumping data for table `eav_attribute_set`
--

INSERT INTO `eav_attribute_set` VALUES (1,1,'Default',2),(2,2,'Default',2),(3,3,'Default',1),(4,4,'Default',1),(5,5,'Default',1),(6,6,'Default',1),(7,7,'Default',1),(8,8,'Default',1),(9,4,'Configurable',0);

--
-- Table structure for table `eav_entity`
--

CREATE TABLE `eav_entity` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set Id',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment Id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Parent Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `is_active` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Defines Is Entity Active',
  PRIMARY KEY (`entity_id`),
  KEY `EAV_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
  KEY `EAV_ENTITY_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity';

--
-- Table structure for table `eav_entity_attribute`
--

CREATE TABLE `eav_entity_attribute` (
  `entity_attribute_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Attribute Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set Id',
  `attribute_group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Group Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`entity_attribute_id`),
  UNIQUE KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID` (`attribute_set_id`,`attribute_id`),
  UNIQUE KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_GROUP_ID_ATTRIBUTE_ID` (`attribute_group_id`,`attribute_id`),
  KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_SORT_ORDER` (`attribute_set_id`,`sort_order`),
  KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB AUTO_INCREMENT=988 DEFAULT CHARSET=utf8 COMMENT='Eav Entity Attributes';

--
-- Dumping data for table `eav_entity_attribute`
--

INSERT INTO `eav_entity_attribute` VALUES ('1',1,1,1,1,10),('2',1,1,1,2,20),('3',1,1,1,3,20),('4',1,1,1,4,30),('5',1,1,1,5,40),('6',1,1,1,6,50),('7',1,1,1,7,60),('8',1,1,1,8,70),('9',1,1,1,9,80),('10',1,1,1,10,25),('11',1,1,1,11,90),('12',1,1,1,12,81),('13',1,1,1,13,115),('14',1,1,1,14,120),('15',1,1,1,15,82),('16',1,1,1,16,83),('17',1,1,1,17,100),('18',1,1,1,18,85),('19',1,1,1,19,86),('20',1,1,1,20,110),('21',1,1,1,21,121),('22',2,2,2,22,10),('23',2,2,2,23,20),('24',2,2,2,24,30),('25',2,2,2,25,40),('26',2,2,2,26,50),('27',2,2,2,27,60),('28',2,2,2,28,70),('29',2,2,2,29,80),('30',2,2,2,30,90),('31',2,2,2,31,100),('32',2,2,2,32,100),('33',2,2,2,33,110),('34',2,2,2,34,120),('35',2,2,2,35,130),('36',2,2,2,36,131),('37',2,2,2,37,132),('38',2,2,2,38,133),('39',2,2,2,39,134),('40',2,2,2,40,135),('41',1,1,1,41,87),('42',3,3,4,42,1),('43',3,3,4,43,2),('44',3,3,4,44,4),('45',3,3,4,45,5),('46',3,3,4,46,6),('47',3,3,4,47,7),('48',3,3,4,48,8),('49',3,3,5,49,10),('50',3,3,5,50,20),('51',3,3,5,51,30),('52',3,3,4,52,12),('53',3,3,4,53,13),('54',3,3,4,54,14),('55',3,3,4,55,15),('56',3,3,4,56,16),('57',3,3,6,57,10),('58',3,3,6,58,30),('59',3,3,6,59,40),('60',3,3,6,60,50),('61',3,3,6,61,60),('62',3,3,4,62,24),('63',3,3,4,63,25),('64',3,3,5,64,40),('65',3,3,5,65,50),('66',3,3,4,66,10),('67',3,3,6,67,5),('68',3,3,6,68,6),('69',3,3,5,69,51),('87',4,4,7,88,6),('93',4,4,8,95,8),('102',4,4,7,104,14),('103',4,4,7,105,15),('104',4,4,7,106,16),('105',4,4,7,107,17),('106',4,4,7,108,18),('107',4,4,7,109,19),('108',4,4,7,110,20),('111',3,3,4,113,3),('112',3,3,4,114,17),('114',4,4,7,116,11),('122',4,4,7,124,105),('123',4,4,7,125,106),('124',4,4,7,126,107),('125',4,4,7,127,108),('523',1,1,1,131,100),('524',1,1,1,132,110),('525',1,1,1,133,120),('620',4,4,7,70,1),('622',4,4,7,71,2),('624',4,4,7,74,3),('626',4,4,7,79,5),('628',4,4,7,91,21),('630',4,4,7,92,22),('632',4,4,7,94,4),('634',4,4,7,96,20),('636',4,4,7,102,6),('638',4,4,7,111,23),('640',4,4,7,112,7),('642',4,4,7,119,18),('644',4,4,7,120,17),('646',4,4,7,121,19),('648',4,4,7,129,16),('650',4,4,7,137,14),('652',4,4,7,138,12),('654',4,4,7,139,10),('656',4,4,7,140,8),('658',4,4,7,141,11),('660',4,4,7,142,13),('662',4,4,7,143,9),('664',4,4,7,144,15),('666',4,4,17,72,1),('668',4,4,17,73,2),('670',4,4,10,84,1),('672',4,4,10,85,2),('674',4,4,10,86,4),('676',4,4,10,87,5),('678',4,4,10,93,6),('680',4,4,10,128,3),('682',4,4,10,136,7),('684',4,4,9,81,2),('686',4,4,9,82,3),('688',4,4,9,83,4),('690',4,4,9,115,1),('692',4,4,8,75,1),('694',4,4,8,76,2),('696',4,4,8,77,3),('698',4,4,8,78,4),('700',4,4,8,89,5),('702',4,4,8,117,6),('704',4,4,8,118,7),('706',4,4,8,122,8),('708',4,4,11,100,3),('710',4,4,11,101,1),('712',4,4,11,103,2),('714',4,4,19,123,1),('716',4,4,18,97,3),('718',4,4,18,98,1),('720',4,4,18,99,2),('722',4,4,18,134,4),('724',4,4,20,130,1),('762',4,9,28,95,8),('802',4,9,32,88,6),('816',4,9,32,116,11),('822',4,9,32,104,14),('828',4,9,32,105,15),('830',4,9,32,106,16),('834',4,9,32,107,17),('838',4,9,32,108,18),('842',4,9,32,109,19),('848',4,9,32,110,20),('856',4,9,32,124,105),('858',4,9,32,125,106),('860',4,9,32,126,107),('862',4,9,32,127,108),('864',4,9,32,70,1),('866',4,9,32,71,2),('868',4,9,32,74,3),('870',4,9,32,79,5),('872',4,9,32,91,22),('874',4,9,32,92,23),('876',4,9,32,94,4),('878',4,9,32,96,21),('880',4,9,32,102,6),('882',4,9,32,111,24),('884',4,9,32,112,7),('886',4,9,32,119,19),('888',4,9,32,120,18),('890',4,9,32,121,20),('892',4,9,32,129,17),('894',4,9,32,137,15),('896',4,9,32,138,13),('898',4,9,32,139,11),('900',4,9,32,140,8),('902',4,9,32,141,12),('904',4,9,32,142,14),('906',4,9,32,143,9),('908',4,9,32,144,16),('910',4,9,32,145,10),('912',4,9,31,72,1),('914',4,9,31,73,2),('916',4,9,30,84,1),('918',4,9,30,85,2),('920',4,9,30,86,4),('922',4,9,30,87,5),('924',4,9,30,93,6),('926',4,9,30,128,3),('928',4,9,30,136,7),('930',4,9,29,81,2),('932',4,9,29,82,3),('934',4,9,29,83,4),('936',4,9,29,115,1),('938',4,9,28,75,1),('940',4,9,28,76,2),('942',4,9,28,77,3),('944',4,9,28,78,4),('946',4,9,28,89,5),('948',4,9,28,117,6),('950',4,9,28,118,7),('952',4,9,28,122,8),('954',4,9,27,100,3),('956',4,9,27,101,1),('958',4,9,27,103,2),('960',4,9,25,123,1),('962',4,9,24,97,3),('964',4,9,24,98,1),('966',4,9,24,99,2),('968',4,9,24,134,4),('970',4,9,23,130,1),('974',4,4,7,145,110),('975',3,3,34,146,5),('976',3,3,34,147,6),('977',3,3,34,148,7),('978',4,9,32,149,10),('979',4,4,10,149,10),('980',3,3,35,150,10),('981',3,3,35,151,50),('982',3,3,35,152,110),('983',3,3,35,153,120),('984',3,3,35,154,130),('985',3,3,35,155,140),('986',3,3,35,156,150),('987',3,3,35,157,160);

--
-- Table structure for table `eav_entity_datetime`
--

CREATE TABLE `eav_entity_datetime` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` datetime DEFAULT NULL COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `EAV_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `EAV_ENTITY_DATETIME_STORE_ID` (`store_id`),
  KEY `EAV_ENTITY_DATETIME_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `EAV_ENTITY_DATETIME_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Table structure for table `eav_entity_decimal`
--

CREATE TABLE `eav_entity_decimal` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `EAV_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `EAV_ENTITY_DECIMAL_STORE_ID` (`store_id`),
  KEY `EAV_ENTITY_DECIMAL_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `EAV_ENTITY_DECIMAL_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Table structure for table `eav_entity_int`
--

CREATE TABLE `eav_entity_int` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `EAV_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `EAV_ENTITY_INT_STORE_ID` (`store_id`),
  KEY `EAV_ENTITY_INT_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `EAV_ENTITY_INT_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Table structure for table `eav_entity_store`
--

CREATE TABLE `eav_entity_store` (
  `entity_store_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Store Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `increment_prefix` varchar(20) DEFAULT NULL COMMENT 'Increment Prefix',
  `increment_last_id` varchar(50) DEFAULT NULL COMMENT 'Last Incremented Id',
  PRIMARY KEY (`entity_store_id`),
  KEY `EAV_ENTITY_STORE_ENTITY_TYPE_ID` (`entity_type_id`),
  KEY `EAV_ENTITY_STORE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Store';

--
-- Table structure for table `eav_entity_text`
--

CREATE TABLE `eav_entity_text` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` text NOT NULL COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `EAV_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `EAV_ENTITY_TEXT_ENTITY_TYPE_ID` (`entity_type_id`),
  KEY `EAV_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `EAV_ENTITY_TEXT_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Table structure for table `eav_entity_type`
--

CREATE TABLE `eav_entity_type` (
  `entity_type_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Type Id',
  `entity_type_code` varchar(50) NOT NULL COMMENT 'Entity Type Code',
  `entity_model` varchar(255) NOT NULL COMMENT 'Entity Model',
  `attribute_model` varchar(255) DEFAULT NULL COMMENT 'Attribute Model',
  `entity_table` varchar(255) DEFAULT NULL COMMENT 'Entity Table',
  `value_table_prefix` varchar(255) DEFAULT NULL COMMENT 'Value Table Prefix',
  `entity_id_field` varchar(255) DEFAULT NULL COMMENT 'Entity Id Field',
  `is_data_sharing` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Defines Is Data Sharing',
  `data_sharing_key` varchar(100) DEFAULT 'default' COMMENT 'Data Sharing Key',
  `default_attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Default Attribute Set Id',
  `increment_model` varchar(255) DEFAULT NULL COMMENT 'Increment Model',
  `increment_per_store` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Increment Per Store',
  `increment_pad_length` smallint(5) unsigned NOT NULL DEFAULT '8' COMMENT 'Increment Pad Length',
  `increment_pad_char` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Increment Pad Char',
  `additional_attribute_table` varchar(255) DEFAULT NULL COMMENT 'Additional Attribute Table',
  `entity_attribute_collection` varchar(255) DEFAULT NULL COMMENT 'Entity Attribute Collection',
  PRIMARY KEY (`entity_type_id`),
  KEY `EAV_ENTITY_TYPE_ENTITY_TYPE_CODE` (`entity_type_code`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='Eav Entity Type';

--
-- Dumping data for table `eav_entity_type`
--

INSERT INTO `eav_entity_type` VALUES (1,'customer','Magento\\Customer\\Model\\ResourceModel\\Customer','Magento\\Customer\\Model\\Attribute','customer_entity',NULL,NULL,1,'default',1,'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue',0,8,'0','customer_eav_attribute','Magento\\Customer\\Model\\ResourceModel\\Attribute\\Collection'),(2,'customer_address','Magento\\Customer\\Model\\ResourceModel\\Address','Magento\\Customer\\Model\\Attribute','customer_address_entity',NULL,NULL,1,'default',2,NULL,0,8,'0','customer_eav_attribute','Magento\\Customer\\Model\\ResourceModel\\Address\\Attribute\\Collection'),(3,'catalog_category','Magento\\Catalog\\Model\\ResourceModel\\Category','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute','catalog_category_entity',NULL,NULL,1,'default',3,NULL,0,8,'0','catalog_eav_attribute','Magento\\Catalog\\Model\\ResourceModel\\Category\\Attribute\\Collection'),(4,'catalog_product','Magento\\Catalog\\Model\\ResourceModel\\Product','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute','catalog_product_entity',NULL,NULL,1,'default',4,NULL,0,8,'0','catalog_eav_attribute','Magento\\Catalog\\Model\\ResourceModel\\Product\\Attribute\\Collection'),(5,'order','Magento\\Sales\\Model\\ResourceModel\\Order',NULL,'sales_order',NULL,NULL,1,'default',5,'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue',1,8,'0',NULL,NULL),(6,'invoice','Magento\\Sales\\Model\\ResourceModel\\Order',NULL,'sales_invoice',NULL,NULL,1,'default',6,'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue',1,8,'0',NULL,NULL),(7,'creditmemo','Magento\\Sales\\Model\\ResourceModel\\Order\\Creditmemo',NULL,'sales_creditmemo',NULL,NULL,1,'default',7,'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue',1,8,'0',NULL,NULL),(8,'shipment','Magento\\Sales\\Model\\ResourceModel\\Order\\Shipment',NULL,'sales_shipment',NULL,NULL,1,'default',8,'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue',1,8,'0',NULL,NULL);

--
-- Table structure for table `eav_entity_varchar`
--

CREATE TABLE `eav_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` varchar(255) DEFAULT NULL COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `EAV_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `EAV_ENTITY_VARCHAR_STORE_ID` (`store_id`),
  KEY `EAV_ENTITY_VARCHAR_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `EAV_ENTITY_VARCHAR_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
