-- Table structure for table `catalog_category_flat_store_6`
--

CREATE TABLE `catalog_category_flat_store_6` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'attribute_set_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_6_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_6_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_6_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_6`
--

INSERT INTO `catalog_category_flat_store_6` VALUES (1,0,0,'2016-04-04 15:47:43','2019-12-13 10:10:44','1',0,0,203,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2016-08-22 19:08:30','1/2',1,1,77,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default Category',NULL,NULL,NULL,NULL),(4,3,2,'2016-04-04 20:49:44','2016-08-22 19:08:30','1/2/4',4,2,5,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Accessories',NULL,NULL,'accessories','accessories'),(5,3,2,'2016-04-04 20:53:47','2016-08-22 19:08:30','1/2/5',5,2,17,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bags & Purses',NULL,NULL,'bags-purses','bags-purses'),(6,3,2,'2016-04-04 20:56:55','2016-08-22 19:08:30','1/2/6',6,2,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','jeans'),(7,3,2,'2016-04-04 20:58:37','2016-08-22 19:08:30','1/2/7',7,2,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','men'),(8,3,38,'2016-04-04 21:32:28','2016-04-04 23:56:51','1/2/38/8',1,3,5,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','shop/men'),(9,3,8,'2016-04-04 21:33:02','2016-04-04 23:56:51','1/2/38/8/9',1,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','shop/men/clothing'),(10,3,8,'2016-04-04 21:33:58','2016-04-05 00:00:10','1/2/38/8/10',2,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Handbags',NULL,NULL,'handbags','shop/men/handbags'),(11,3,8,'2016-04-04 21:34:45','2016-04-04 23:56:51','1/2/38/8/11',3,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','shop/men/shose'),(12,3,8,'2016-04-04 21:35:39','2016-04-04 23:56:51','1/2/38/8/12',4,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','shop/men/jeans'),(13,3,8,'2016-04-04 21:36:43','2016-04-04 23:56:51','1/2/38/8/13',5,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','shop/men/t-shirts'),(14,3,38,'2016-04-04 21:37:42','2016-04-05 00:06:16','1/2/38/14',2,3,5,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Womens',NULL,NULL,'womens','shop/womens'),(15,3,14,'2016-04-04 21:38:18','2016-04-05 00:06:16','1/2/38/14/15',1,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','shop/womens/curabitur'),(16,3,14,'2016-04-04 21:40:09','2016-04-05 00:06:16','1/2/38/14/16',2,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','shop/womens/sed-dui-ante'),(17,3,14,'2016-04-04 21:41:56','2016-04-05 00:06:16','1/2/38/14/17',3,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','shop/womens/mauris-et-neque'),(18,3,14,'2016-04-04 21:43:00','2016-04-05 00:06:16','1/2/38/14/18',4,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','shop/womens/donec-porttitor'),(19,3,14,'2016-04-04 21:44:05','2016-04-05 00:06:16','1/2/38/14/19',5,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','shop/womens/clothing'),(20,3,38,'2016-04-04 21:46:33','2016-05-05 00:12:22','1/2/38/20',3,3,8,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','shop/mauris-et-neque'),(21,3,20,'2016-04-04 21:47:38','2016-04-05 00:11:41','1/2/38/20/21',1,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','shop/mauris-et-neque/sed-dui-ante'),(22,3,20,'2016-04-04 21:48:51','2016-05-05 00:12:22','1/2/38/20/22',2,4,3,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','shop/mauris-et-neque/morbi-quis'),(23,3,20,'2016-04-04 21:50:08','2016-04-05 00:11:41','1/2/38/20/23',3,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','shop/mauris-et-neque/donec-porttitor'),(24,3,20,'2016-04-04 21:51:28','2016-04-05 00:11:41','1/2/38/20/24',4,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Suspendisse',NULL,NULL,'suspendisse','shop/mauris-et-neque/suspendisse'),(25,3,20,'2016-04-04 21:52:52','2016-04-05 00:11:41','1/2/38/20/25',5,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Nulla facilisi',NULL,NULL,'nulla-facilisi','shop/mauris-et-neque/nulla-facilisi'),(26,3,38,'2016-04-04 21:54:24','2016-04-05 00:20:23','1/2/38/26',4,3,5,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','shop/donec-porttitor'),(27,3,26,'2016-04-04 21:55:33','2016-04-05 00:20:23','1/2/38/26/27',1,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','shop/donec-porttitor/mauris-et-neque'),(28,3,26,'2016-04-04 21:56:59','2016-04-05 00:20:23','1/2/38/26/28',2,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Quisque placerat',NULL,NULL,'quisque-placerat','shop/donec-porttitor/quisque-placerat'),(29,3,26,'2016-04-04 21:58:35','2016-04-05 00:20:23','1/2/38/26/29',3,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Get Inspired',NULL,NULL,'get-inspired','shop/donec-porttitor/get-inspired'),(30,3,26,'2016-04-04 22:00:11','2016-04-05 00:20:23','1/2/38/26/30',4,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','shop/donec-porttitor/curabitur'),(31,3,26,'2016-04-04 22:03:32','2016-04-05 00:20:23','1/2/38/26/31',5,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec pretium',NULL,NULL,'donec-pretium','shop/donec-porttitor/donec-pretium'),(32,3,4,'2016-04-04 22:19:26','2016-04-04 22:29:47','1/2/4/32',1,3,4,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All',NULL,NULL,'all','accessories/all'),(33,3,32,'2016-04-04 22:22:08','2016-04-04 22:22:08','1/2/4/32/33',1,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Footwear',NULL,NULL,'footwear','accessories/all/footwear'),(34,3,32,'2016-04-04 22:25:56','2016-04-04 22:25:57','1/2/4/32/34',2,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Furniture',NULL,NULL,'furniture','accessories/all/furniture'),(35,3,32,'2016-04-04 22:27:45','2016-04-04 22:27:45','1/2/4/32/35',3,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','accessories/all/shose'),(36,3,32,'2016-04-04 22:29:47','2016-04-04 22:29:47','1/2/4/32/36',4,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jewelry',NULL,NULL,'jewelry','accessories/all/jewelry'),(38,3,2,'2016-04-04 23:47:55','2016-05-05 00:12:22','1/2/38',1,2,27,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,'imges-cate.jpg',1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shop',NULL,NULL,'shop','shop'),(39,3,2,'2016-04-17 03:48:08','2016-08-22 19:08:30','1/2/39',8,2,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','t-shirts'),(40,3,5,'2016-04-18 14:19:54','2016-04-18 14:23:34','1/2/5/40',1,3,5,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','bags-purses/men'),(41,3,40,'2016-04-18 14:20:41','2016-04-18 14:20:41','1/2/5/40/41',1,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','bags-purses/men/clothing'),(42,3,40,'2016-04-18 14:21:26','2016-04-18 14:21:26','1/2/5/40/42',2,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Handbags',NULL,NULL,'handbags','bags-purses/men/handbags'),(43,3,40,'2016-04-18 14:22:17','2016-04-18 14:22:18','1/2/5/40/43',3,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','bags-purses/men/shose'),(44,3,40,'2016-04-18 14:22:56','2016-04-18 14:22:56','1/2/5/40/44',4,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','bags-purses/men/jeans'),(45,3,40,'2016-04-18 14:23:34','2016-04-18 14:23:34','1/2/5/40/45',5,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','bags-purses/men/t-shirts'),(46,3,5,'2016-04-18 14:24:39','2016-04-18 14:28:33','1/2/5/46',2,3,5,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Womens',NULL,NULL,'womens','bags-purses/womens'),(47,3,46,'2016-04-18 14:25:41','2016-04-18 14:25:41','1/2/5/46/47',1,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','bags-purses/womens/curabitur'),(48,3,46,'2016-04-18 14:26:28','2016-04-25 21:23:50','1/2/5/46/48',2,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','bags-purses/womens/sed-dui-ante'),(49,3,46,'2016-04-18 14:27:11','2016-04-18 14:27:11','1/2/5/46/49',3,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','bags-purses/womens/mauris-et-neque'),(50,3,46,'2016-04-18 14:27:51','2016-04-18 14:27:52','1/2/5/46/50',4,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','bags-purses/womens/donec-porttitor'),(51,3,46,'2016-04-18 14:28:33','2016-04-18 14:28:33','1/2/5/46/51',5,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','bags-purses/womens/clothing'),(52,3,5,'2016-04-18 14:29:41','2016-04-18 14:32:31','1/2/5/52',3,3,4,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','bags-purses/mauris-et-neque'),(53,3,52,'2016-04-18 14:30:06','2016-04-18 14:30:06','1/2/5/52/53',1,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','bags-purses/mauris-et-neque/sed-dui-ante'),(54,3,52,'2016-04-18 14:30:46','2016-04-18 14:30:46','1/2/5/52/54',2,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','bags-purses/mauris-et-neque/morbi-quis'),(55,3,52,'2016-04-18 14:31:32','2016-04-18 14:31:32','1/2/5/52/55',3,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','bags-purses/mauris-et-neque/donec-porttitor'),(56,3,52,'2016-04-18 14:32:31','2016-04-18 14:32:31','1/2/5/52/56',4,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Suspendisse',NULL,NULL,'suspendisse','bags-purses/mauris-et-neque/suspendisse'),(60,3,2,'2016-04-18 15:12:31','2019-05-31 13:44:08','1/2/60',9,2,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Hot',NULL,NULL,NULL,NULL,'Features',NULL,NULL,'features','features'),(67,3,22,'2016-05-05 00:01:36','2016-05-05 00:01:36','1/2/38/20/22/67',1,5,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','shop/mauris-et-neque/morbi-quis/morbi-quis'),(69,3,22,'2016-05-05 00:11:50','2016-05-05 00:11:50','1/2/38/20/22/69',2,5,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quisr',NULL,NULL,'morbi-quisr','shop/mauris-et-neque/morbi-quis/morbi-quisr'),(70,3,22,'2016-05-05 00:12:22','2016-05-05 00:12:22','1/2/38/20/22/70',3,5,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quist',NULL,NULL,'morbi-quist','shop/mauris-et-neque/morbi-quis/morbi-quist'),(71,3,2,'2016-08-22 18:20:40','2016-08-22 19:08:30','1/2/71',10,2,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','clothing'),(72,3,2,'2016-08-22 18:21:26','2016-08-22 19:08:30','1/2/72',11,2,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','curabitur'),(73,3,2,'2016-08-22 18:59:57','2016-08-22 19:08:30','1/2/73',2,2,18,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Boys',NULL,NULL,'boys','boys'),(74,3,73,'2016-08-22 19:00:21','2016-08-22 19:06:13','1/2/73/74',1,3,5,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','boys/men'),(75,3,74,'2016-08-22 19:00:43','2016-08-22 19:00:43','1/2/73/74/75',1,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','boys/men/clothing'),(76,3,73,'2016-08-22 19:01:09','2016-08-22 19:08:11','1/2/73/76',2,3,5,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Womens',NULL,NULL,'womens','boys/womens'),(77,3,76,'2016-08-22 19:01:31','2016-08-22 19:01:31','1/2/73/76/77',1,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','boys/womens/curabitur'),(78,3,73,'2016-08-22 19:02:03','2016-08-22 19:04:14','1/2/73/78',3,3,5,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','boys/mauris-et-neque'),(79,3,78,'2016-08-22 19:02:23','2016-08-22 19:02:23','1/2/73/78/79',1,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','boys/mauris-et-neque/sed-dui-ante'),(80,3,78,'2016-08-22 19:02:51','2016-08-22 19:02:51','1/2/73/78/80',2,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','boys/mauris-et-neque/morbi-quis'),(81,3,78,'2016-08-22 19:03:17','2016-08-22 19:03:17','1/2/73/78/81',3,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','boys/mauris-et-neque/donec-porttitor'),(82,3,78,'2016-08-22 19:03:44','2016-08-22 19:03:44','1/2/73/78/82',4,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Suspendisse',NULL,NULL,'suspendisse','boys/mauris-et-neque/suspendisse'),(83,3,78,'2016-08-22 19:04:14','2016-08-22 19:04:14','1/2/73/78/83',5,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Nulla facilisi',NULL,NULL,'nulla-facilisi','boys/mauris-et-neque/nulla-facilisi'),(84,3,74,'2016-08-22 19:04:47','2016-08-22 19:04:47','1/2/73/74/84',2,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Handbags',NULL,NULL,'handbags','boys/men/handbags'),(85,3,74,'2016-08-22 19:05:14','2016-08-22 19:05:15','1/2/73/74/85',3,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','boys/men/shose'),(86,3,74,'2016-08-22 19:05:43','2016-08-22 19:05:43','1/2/73/74/86',4,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','boys/men/jeans'),(87,3,74,'2016-08-22 19:06:13','2016-08-22 19:06:13','1/2/73/74/87',5,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','boys/men/t-shirts'),(88,3,76,'2016-08-22 19:06:42','2016-08-22 19:06:42','1/2/73/76/88',2,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','boys/womens/sed-dui-ante'),(89,3,76,'2016-08-22 19:07:11','2016-08-22 19:07:12','1/2/73/76/89',3,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','boys/womens/mauris-et-neque'),(90,3,76,'2016-08-22 19:07:42','2016-08-22 19:07:42','1/2/73/76/90',4,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','boys/womens/donec-porttitor'),(91,3,76,'2016-08-22 19:08:11','2016-08-22 19:08:11','1/2/73/76/91',5,4,0,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','boys/womens/clothing');

--
-- Table structure for table `catalog_category_flat_store_7`
--

CREATE TABLE `catalog_category_flat_store_7` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'attribute_set_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_7_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_7_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_7_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_7`
--

INSERT INTO `catalog_category_flat_store_7` VALUES (1,0,0,'2016-04-04 15:47:43','2019-12-13 10:10:44','1',0,0,203,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2016-08-22 19:08:30','1/2',1,1,77,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default Category',NULL,NULL,NULL,NULL),(4,3,2,'2016-04-04 20:49:44','2016-08-22 19:08:30','1/2/4',4,2,5,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Accessories',NULL,NULL,'accessories','accessories'),(5,3,2,'2016-04-04 20:53:47','2016-08-22 19:08:30','1/2/5',5,2,17,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bags & Purses',NULL,NULL,'bags-purses','bags-purses'),(6,3,2,'2016-04-04 20:56:55','2016-08-22 19:08:30','1/2/6',6,2,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','jeans'),(7,3,2,'2016-04-04 20:58:37','2016-08-22 19:08:30','1/2/7',7,2,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','men'),(8,3,38,'2016-04-04 21:32:28','2016-04-04 23:56:51','1/2/38/8',1,3,5,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','shop/men'),(9,3,8,'2016-04-04 21:33:02','2016-04-04 23:56:51','1/2/38/8/9',1,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','shop/men/clothing'),(10,3,8,'2016-04-04 21:33:58','2016-04-05 00:00:10','1/2/38/8/10',2,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Handbags',NULL,NULL,'handbags','shop/men/handbags'),(11,3,8,'2016-04-04 21:34:45','2016-04-04 23:56:51','1/2/38/8/11',3,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','shop/men/shose'),(12,3,8,'2016-04-04 21:35:39','2016-04-04 23:56:51','1/2/38/8/12',4,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','shop/men/jeans'),(13,3,8,'2016-04-04 21:36:43','2016-04-04 23:56:51','1/2/38/8/13',5,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','shop/men/t-shirts'),(14,3,38,'2016-04-04 21:37:42','2016-04-05 00:06:16','1/2/38/14',2,3,5,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Womens',NULL,NULL,'womens','shop/womens'),(15,3,14,'2016-04-04 21:38:18','2016-04-05 00:06:16','1/2/38/14/15',1,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','shop/womens/curabitur'),(16,3,14,'2016-04-04 21:40:09','2016-04-05 00:06:16','1/2/38/14/16',2,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','shop/womens/sed-dui-ante'),(17,3,14,'2016-04-04 21:41:56','2016-04-05 00:06:16','1/2/38/14/17',3,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','shop/womens/mauris-et-neque'),(18,3,14,'2016-04-04 21:43:00','2016-04-05 00:06:16','1/2/38/14/18',4,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','shop/womens/donec-porttitor'),(19,3,14,'2016-04-04 21:44:05','2016-04-05 00:06:16','1/2/38/14/19',5,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','shop/womens/clothing'),(20,3,38,'2016-04-04 21:46:33','2016-05-05 00:12:22','1/2/38/20',3,3,8,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','shop/mauris-et-neque'),(21,3,20,'2016-04-04 21:47:38','2016-04-05 00:11:41','1/2/38/20/21',1,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','shop/mauris-et-neque/sed-dui-ante'),(22,3,20,'2016-04-04 21:48:51','2016-05-05 00:12:22','1/2/38/20/22',2,4,3,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','shop/mauris-et-neque/morbi-quis'),(23,3,20,'2016-04-04 21:50:08','2016-04-05 00:11:41','1/2/38/20/23',3,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','shop/mauris-et-neque/donec-porttitor'),(24,3,20,'2016-04-04 21:51:28','2016-04-05 00:11:41','1/2/38/20/24',4,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Suspendisse',NULL,NULL,'suspendisse','shop/mauris-et-neque/suspendisse'),(25,3,20,'2016-04-04 21:52:52','2016-04-05 00:11:41','1/2/38/20/25',5,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Nulla facilisi',NULL,NULL,'nulla-facilisi','shop/mauris-et-neque/nulla-facilisi'),(26,3,38,'2016-04-04 21:54:24','2016-04-05 00:20:23','1/2/38/26',4,3,5,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','shop/donec-porttitor'),(27,3,26,'2016-04-04 21:55:33','2016-04-05 00:20:23','1/2/38/26/27',1,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','shop/donec-porttitor/mauris-et-neque'),(28,3,26,'2016-04-04 21:56:59','2016-04-05 00:20:23','1/2/38/26/28',2,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Quisque placerat',NULL,NULL,'quisque-placerat','shop/donec-porttitor/quisque-placerat'),(29,3,26,'2016-04-04 21:58:35','2016-04-05 00:20:23','1/2/38/26/29',3,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Get Inspired',NULL,NULL,'get-inspired','shop/donec-porttitor/get-inspired'),(30,3,26,'2016-04-04 22:00:11','2016-04-05 00:20:23','1/2/38/26/30',4,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','shop/donec-porttitor/curabitur'),(31,3,26,'2016-04-04 22:03:32','2016-04-05 00:20:23','1/2/38/26/31',5,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec pretium',NULL,NULL,'donec-pretium','shop/donec-porttitor/donec-pretium'),(32,3,4,'2016-04-04 22:19:26','2016-04-04 22:29:47','1/2/4/32',1,3,4,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All',NULL,NULL,'all','accessories/all'),(33,3,32,'2016-04-04 22:22:08','2016-04-04 22:22:08','1/2/4/32/33',1,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Footwear',NULL,NULL,'footwear','accessories/all/footwear'),(34,3,32,'2016-04-04 22:25:56','2016-04-04 22:25:57','1/2/4/32/34',2,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Furniture',NULL,NULL,'furniture','accessories/all/furniture'),(35,3,32,'2016-04-04 22:27:45','2016-04-04 22:27:45','1/2/4/32/35',3,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','accessories/all/shose'),(36,3,32,'2016-04-04 22:29:47','2016-04-04 22:29:47','1/2/4/32/36',4,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jewelry',NULL,NULL,'jewelry','accessories/all/jewelry'),(38,3,2,'2016-04-04 23:47:55','2016-05-05 00:12:22','1/2/38',1,2,27,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,'imges-cate.jpg',1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shop',NULL,NULL,'shop','shop'),(39,3,2,'2016-04-17 03:48:08','2016-08-22 19:08:30','1/2/39',8,2,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','t-shirts'),(40,3,5,'2016-04-18 14:19:54','2016-04-18 14:23:34','1/2/5/40',1,3,5,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','bags-purses/men'),(41,3,40,'2016-04-18 14:20:41','2016-04-18 14:20:41','1/2/5/40/41',1,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','bags-purses/men/clothing'),(42,3,40,'2016-04-18 14:21:26','2016-04-18 14:21:26','1/2/5/40/42',2,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Handbags',NULL,NULL,'handbags','bags-purses/men/handbags'),(43,3,40,'2016-04-18 14:22:17','2016-04-18 14:22:18','1/2/5/40/43',3,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','bags-purses/men/shose'),(44,3,40,'2016-04-18 14:22:56','2016-04-18 14:22:56','1/2/5/40/44',4,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','bags-purses/men/jeans'),(45,3,40,'2016-04-18 14:23:34','2016-04-18 14:23:34','1/2/5/40/45',5,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','bags-purses/men/t-shirts'),(46,3,5,'2016-04-18 14:24:39','2016-04-18 14:28:33','1/2/5/46',2,3,5,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Womens',NULL,NULL,'womens','bags-purses/womens'),(47,3,46,'2016-04-18 14:25:41','2016-04-18 14:25:41','1/2/5/46/47',1,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','bags-purses/womens/curabitur'),(48,3,46,'2016-04-18 14:26:28','2016-04-25 21:23:50','1/2/5/46/48',2,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','bags-purses/womens/sed-dui-ante'),(49,3,46,'2016-04-18 14:27:11','2016-04-18 14:27:11','1/2/5/46/49',3,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','bags-purses/womens/mauris-et-neque'),(50,3,46,'2016-04-18 14:27:51','2016-04-18 14:27:52','1/2/5/46/50',4,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','bags-purses/womens/donec-porttitor'),(51,3,46,'2016-04-18 14:28:33','2016-04-18 14:28:33','1/2/5/46/51',5,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','bags-purses/womens/clothing'),(52,3,5,'2016-04-18 14:29:41','2016-04-18 14:32:31','1/2/5/52',3,3,4,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','bags-purses/mauris-et-neque'),(53,3,52,'2016-04-18 14:30:06','2016-04-18 14:30:06','1/2/5/52/53',1,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','bags-purses/mauris-et-neque/sed-dui-ante'),(54,3,52,'2016-04-18 14:30:46','2016-04-18 14:30:46','1/2/5/52/54',2,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','bags-purses/mauris-et-neque/morbi-quis'),(55,3,52,'2016-04-18 14:31:32','2016-04-18 14:31:32','1/2/5/52/55',3,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','bags-purses/mauris-et-neque/donec-porttitor'),(56,3,52,'2016-04-18 14:32:31','2016-04-18 14:32:31','1/2/5/52/56',4,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Suspendisse',NULL,NULL,'suspendisse','bags-purses/mauris-et-neque/suspendisse'),(60,3,2,'2016-04-18 15:12:31','2019-05-31 13:44:08','1/2/60',9,2,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Hot',NULL,NULL,NULL,NULL,'Features',NULL,NULL,'features','features'),(67,3,22,'2016-05-05 00:01:36','2016-05-05 00:01:36','1/2/38/20/22/67',1,5,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','shop/mauris-et-neque/morbi-quis/morbi-quis'),(69,3,22,'2016-05-05 00:11:50','2016-05-05 00:11:50','1/2/38/20/22/69',2,5,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quisr',NULL,NULL,'morbi-quisr','shop/mauris-et-neque/morbi-quis/morbi-quisr'),(70,3,22,'2016-05-05 00:12:22','2016-05-05 00:12:22','1/2/38/20/22/70',3,5,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quist',NULL,NULL,'morbi-quist','shop/mauris-et-neque/morbi-quis/morbi-quist'),(71,3,2,'2016-08-22 18:20:40','2016-08-22 19:08:30','1/2/71',10,2,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','clothing'),(72,3,2,'2016-08-22 18:21:26','2016-08-22 19:08:30','1/2/72',11,2,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','curabitur'),(73,3,2,'2016-08-22 18:59:57','2016-08-22 19:08:30','1/2/73',2,2,18,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Boys',NULL,NULL,'boys','boys'),(74,3,73,'2016-08-22 19:00:21','2016-08-22 19:06:13','1/2/73/74',1,3,5,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','boys/men'),(75,3,74,'2016-08-22 19:00:43','2016-08-22 19:00:43','1/2/73/74/75',1,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','boys/men/clothing'),(76,3,73,'2016-08-22 19:01:09','2016-08-22 19:08:11','1/2/73/76',2,3,5,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Womens',NULL,NULL,'womens','boys/womens'),(77,3,76,'2016-08-22 19:01:31','2016-08-22 19:01:31','1/2/73/76/77',1,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','boys/womens/curabitur'),(78,3,73,'2016-08-22 19:02:03','2016-08-22 19:04:14','1/2/73/78',3,3,5,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','boys/mauris-et-neque'),(79,3,78,'2016-08-22 19:02:23','2016-08-22 19:02:23','1/2/73/78/79',1,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','boys/mauris-et-neque/sed-dui-ante'),(80,3,78,'2016-08-22 19:02:51','2016-08-22 19:02:51','1/2/73/78/80',2,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','boys/mauris-et-neque/morbi-quis'),(81,3,78,'2016-08-22 19:03:17','2016-08-22 19:03:17','1/2/73/78/81',3,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','boys/mauris-et-neque/donec-porttitor'),(82,3,78,'2016-08-22 19:03:44','2016-08-22 19:03:44','1/2/73/78/82',4,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Suspendisse',NULL,NULL,'suspendisse','boys/mauris-et-neque/suspendisse'),(83,3,78,'2016-08-22 19:04:14','2016-08-22 19:04:14','1/2/73/78/83',5,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Nulla facilisi',NULL,NULL,'nulla-facilisi','boys/mauris-et-neque/nulla-facilisi'),(84,3,74,'2016-08-22 19:04:47','2016-08-22 19:04:47','1/2/73/74/84',2,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Handbags',NULL,NULL,'handbags','boys/men/handbags'),(85,3,74,'2016-08-22 19:05:14','2016-08-22 19:05:15','1/2/73/74/85',3,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','boys/men/shose'),(86,3,74,'2016-08-22 19:05:43','2016-08-22 19:05:43','1/2/73/74/86',4,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','boys/men/jeans'),(87,3,74,'2016-08-22 19:06:13','2016-08-22 19:06:13','1/2/73/74/87',5,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','boys/men/t-shirts'),(88,3,76,'2016-08-22 19:06:42','2016-08-22 19:06:42','1/2/73/76/88',2,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','boys/womens/sed-dui-ante'),(89,3,76,'2016-08-22 19:07:11','2016-08-22 19:07:12','1/2/73/76/89',3,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','boys/womens/mauris-et-neque'),(90,3,76,'2016-08-22 19:07:42','2016-08-22 19:07:42','1/2/73/76/90',4,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','boys/womens/donec-porttitor'),(91,3,76,'2016-08-22 19:08:11','2016-08-22 19:08:11','1/2/73/76/91',5,4,0,7,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','boys/womens/clothing');

--
-- Table structure for table `catalog_category_flat_store_8`
--

CREATE TABLE `catalog_category_flat_store_8` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'attribute_set_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_8_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_8_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_8_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_8`
--

INSERT INTO `catalog_category_flat_store_8` VALUES (1,0,0,'2016-04-04 15:47:43','2019-12-13 10:10:44','1',0,0,203,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2016-08-22 19:08:30','1/2',1,1,77,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default Category',NULL,NULL,NULL,NULL),(4,3,2,'2016-04-04 20:49:44','2016-08-22 19:08:30','1/2/4',4,2,5,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Accessories',NULL,NULL,'accessories','accessories'),(5,3,2,'2016-04-04 20:53:47','2016-08-22 19:08:30','1/2/5',5,2,17,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bags & Purses',NULL,NULL,'bags-purses','bags-purses'),(6,3,2,'2016-04-04 20:56:55','2016-08-22 19:08:30','1/2/6',6,2,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','jeans'),(7,3,2,'2016-04-04 20:58:37','2016-08-22 19:08:30','1/2/7',7,2,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','men'),(8,3,38,'2016-04-04 21:32:28','2016-04-04 23:56:51','1/2/38/8',1,3,5,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','shop/men'),(9,3,8,'2016-04-04 21:33:02','2016-04-04 23:56:51','1/2/38/8/9',1,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','shop/men/clothing'),(10,3,8,'2016-04-04 21:33:58','2016-04-05 00:00:10','1/2/38/8/10',2,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Handbags',NULL,NULL,'handbags','shop/men/handbags'),(11,3,8,'2016-04-04 21:34:45','2016-04-04 23:56:51','1/2/38/8/11',3,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','shop/men/shose'),(12,3,8,'2016-04-04 21:35:39','2016-04-04 23:56:51','1/2/38/8/12',4,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','shop/men/jeans'),(13,3,8,'2016-04-04 21:36:43','2016-04-04 23:56:51','1/2/38/8/13',5,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','shop/men/t-shirts'),(14,3,38,'2016-04-04 21:37:42','2016-04-05 00:06:16','1/2/38/14',2,3,5,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Womens',NULL,NULL,'womens','shop/womens'),(15,3,14,'2016-04-04 21:38:18','2016-04-05 00:06:16','1/2/38/14/15',1,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','shop/womens/curabitur'),(16,3,14,'2016-04-04 21:40:09','2016-04-05 00:06:16','1/2/38/14/16',2,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','shop/womens/sed-dui-ante'),(17,3,14,'2016-04-04 21:41:56','2016-04-05 00:06:16','1/2/38/14/17',3,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','shop/womens/mauris-et-neque'),(18,3,14,'2016-04-04 21:43:00','2016-04-05 00:06:16','1/2/38/14/18',4,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','shop/womens/donec-porttitor'),(19,3,14,'2016-04-04 21:44:05','2016-04-05 00:06:16','1/2/38/14/19',5,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','shop/womens/clothing'),(20,3,38,'2016-04-04 21:46:33','2016-05-05 00:12:22','1/2/38/20',3,3,8,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','shop/mauris-et-neque'),(21,3,20,'2016-04-04 21:47:38','2016-04-05 00:11:41','1/2/38/20/21',1,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','shop/mauris-et-neque/sed-dui-ante'),(22,3,20,'2016-04-04 21:48:51','2016-05-05 00:12:22','1/2/38/20/22',2,4,3,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','shop/mauris-et-neque/morbi-quis'),(23,3,20,'2016-04-04 21:50:08','2016-04-05 00:11:41','1/2/38/20/23',3,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','shop/mauris-et-neque/donec-porttitor'),(24,3,20,'2016-04-04 21:51:28','2016-04-05 00:11:41','1/2/38/20/24',4,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Suspendisse',NULL,NULL,'suspendisse','shop/mauris-et-neque/suspendisse'),(25,3,20,'2016-04-04 21:52:52','2016-04-05 00:11:41','1/2/38/20/25',5,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Nulla facilisi',NULL,NULL,'nulla-facilisi','shop/mauris-et-neque/nulla-facilisi'),(26,3,38,'2016-04-04 21:54:24','2016-04-05 00:20:23','1/2/38/26',4,3,5,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','shop/donec-porttitor'),(27,3,26,'2016-04-04 21:55:33','2016-04-05 00:20:23','1/2/38/26/27',1,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','shop/donec-porttitor/mauris-et-neque'),(28,3,26,'2016-04-04 21:56:59','2016-04-05 00:20:23','1/2/38/26/28',2,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Quisque placerat',NULL,NULL,'quisque-placerat','shop/donec-porttitor/quisque-placerat'),(29,3,26,'2016-04-04 21:58:35','2016-04-05 00:20:23','1/2/38/26/29',3,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Get Inspired',NULL,NULL,'get-inspired','shop/donec-porttitor/get-inspired'),(30,3,26,'2016-04-04 22:00:11','2016-04-05 00:20:23','1/2/38/26/30',4,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','shop/donec-porttitor/curabitur'),(31,3,26,'2016-04-04 22:03:32','2016-04-05 00:20:23','1/2/38/26/31',5,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec pretium',NULL,NULL,'donec-pretium','shop/donec-porttitor/donec-pretium'),(32,3,4,'2016-04-04 22:19:26','2016-04-04 22:29:47','1/2/4/32',1,3,4,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All',NULL,NULL,'all','accessories/all'),(33,3,32,'2016-04-04 22:22:08','2016-04-04 22:22:08','1/2/4/32/33',1,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Footwear',NULL,NULL,'footwear','accessories/all/footwear'),(34,3,32,'2016-04-04 22:25:56','2016-04-04 22:25:57','1/2/4/32/34',2,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Furniture',NULL,NULL,'furniture','accessories/all/furniture'),(35,3,32,'2016-04-04 22:27:45','2016-04-04 22:27:45','1/2/4/32/35',3,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','accessories/all/shose'),(36,3,32,'2016-04-04 22:29:47','2016-04-04 22:29:47','1/2/4/32/36',4,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jewelry',NULL,NULL,'jewelry','accessories/all/jewelry'),(38,3,2,'2016-04-04 23:47:55','2016-05-05 00:12:22','1/2/38',1,2,27,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,'imges-cate.jpg',1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shop',NULL,NULL,'shop','shop'),(39,3,2,'2016-04-17 03:48:08','2016-08-22 19:08:30','1/2/39',8,2,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','t-shirts'),(40,3,5,'2016-04-18 14:19:54','2016-04-18 14:23:34','1/2/5/40',1,3,5,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','bags-purses/men'),(41,3,40,'2016-04-18 14:20:41','2016-04-18 14:20:41','1/2/5/40/41',1,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','bags-purses/men/clothing'),(42,3,40,'2016-04-18 14:21:26','2016-04-18 14:21:26','1/2/5/40/42',2,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Handbags',NULL,NULL,'handbags','bags-purses/men/handbags'),(43,3,40,'2016-04-18 14:22:17','2016-04-18 14:22:18','1/2/5/40/43',3,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','bags-purses/men/shose'),(44,3,40,'2016-04-18 14:22:56','2016-04-18 14:22:56','1/2/5/40/44',4,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','bags-purses/men/jeans'),(45,3,40,'2016-04-18 14:23:34','2016-04-18 14:23:34','1/2/5/40/45',5,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','bags-purses/men/t-shirts'),(46,3,5,'2016-04-18 14:24:39','2016-04-18 14:28:33','1/2/5/46',2,3,5,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Womens',NULL,NULL,'womens','bags-purses/womens'),(47,3,46,'2016-04-18 14:25:41','2016-04-18 14:25:41','1/2/5/46/47',1,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','bags-purses/womens/curabitur'),(48,3,46,'2016-04-18 14:26:28','2016-04-25 21:23:50','1/2/5/46/48',2,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','bags-purses/womens/sed-dui-ante'),(49,3,46,'2016-04-18 14:27:11','2016-04-18 14:27:11','1/2/5/46/49',3,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','bags-purses/womens/mauris-et-neque'),(50,3,46,'2016-04-18 14:27:51','2016-04-18 14:27:52','1/2/5/46/50',4,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','bags-purses/womens/donec-porttitor'),(51,3,46,'2016-04-18 14:28:33','2016-04-18 14:28:33','1/2/5/46/51',5,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','bags-purses/womens/clothing'),(52,3,5,'2016-04-18 14:29:41','2016-04-18 14:32:31','1/2/5/52',3,3,4,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','bags-purses/mauris-et-neque'),(53,3,52,'2016-04-18 14:30:06','2016-04-18 14:30:06','1/2/5/52/53',1,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','bags-purses/mauris-et-neque/sed-dui-ante'),(54,3,52,'2016-04-18 14:30:46','2016-04-18 14:30:46','1/2/5/52/54',2,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','bags-purses/mauris-et-neque/morbi-quis'),(55,3,52,'2016-04-18 14:31:32','2016-04-18 14:31:32','1/2/5/52/55',3,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','bags-purses/mauris-et-neque/donec-porttitor'),(56,3,52,'2016-04-18 14:32:31','2016-04-18 14:32:31','1/2/5/52/56',4,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Suspendisse',NULL,NULL,'suspendisse','bags-purses/mauris-et-neque/suspendisse'),(60,3,2,'2016-04-18 15:12:31','2019-05-31 13:44:08','1/2/60',9,2,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Hot',NULL,NULL,NULL,NULL,'Features',NULL,NULL,'features','features'),(67,3,22,'2016-05-05 00:01:36','2016-05-05 00:01:36','1/2/38/20/22/67',1,5,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','shop/mauris-et-neque/morbi-quis/morbi-quis'),(69,3,22,'2016-05-05 00:11:50','2016-05-05 00:11:50','1/2/38/20/22/69',2,5,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quisr',NULL,NULL,'morbi-quisr','shop/mauris-et-neque/morbi-quis/morbi-quisr'),(70,3,22,'2016-05-05 00:12:22','2016-05-05 00:12:22','1/2/38/20/22/70',3,5,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quist',NULL,NULL,'morbi-quist','shop/mauris-et-neque/morbi-quis/morbi-quist'),(71,3,2,'2016-08-22 18:20:40','2016-08-22 19:08:30','1/2/71',10,2,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','clothing'),(72,3,2,'2016-08-22 18:21:26','2016-08-22 19:08:30','1/2/72',11,2,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','curabitur'),(73,3,2,'2016-08-22 18:59:57','2016-08-22 19:08:30','1/2/73',2,2,18,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Boys',NULL,NULL,'boys','boys'),(74,3,73,'2016-08-22 19:00:21','2016-08-22 19:06:13','1/2/73/74',1,3,5,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','boys/men'),(75,3,74,'2016-08-22 19:00:43','2016-08-22 19:00:43','1/2/73/74/75',1,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','boys/men/clothing'),(76,3,73,'2016-08-22 19:01:09','2016-08-22 19:08:11','1/2/73/76',2,3,5,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Womens',NULL,NULL,'womens','boys/womens'),(77,3,76,'2016-08-22 19:01:31','2016-08-22 19:01:31','1/2/73/76/77',1,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','boys/womens/curabitur'),(78,3,73,'2016-08-22 19:02:03','2016-08-22 19:04:14','1/2/73/78',3,3,5,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','boys/mauris-et-neque'),(79,3,78,'2016-08-22 19:02:23','2016-08-22 19:02:23','1/2/73/78/79',1,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','boys/mauris-et-neque/sed-dui-ante'),(80,3,78,'2016-08-22 19:02:51','2016-08-22 19:02:51','1/2/73/78/80',2,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','boys/mauris-et-neque/morbi-quis'),(81,3,78,'2016-08-22 19:03:17','2016-08-22 19:03:17','1/2/73/78/81',3,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','boys/mauris-et-neque/donec-porttitor'),(82,3,78,'2016-08-22 19:03:44','2016-08-22 19:03:44','1/2/73/78/82',4,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Suspendisse',NULL,NULL,'suspendisse','boys/mauris-et-neque/suspendisse'),(83,3,78,'2016-08-22 19:04:14','2016-08-22 19:04:14','1/2/73/78/83',5,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Nulla facilisi',NULL,NULL,'nulla-facilisi','boys/mauris-et-neque/nulla-facilisi'),(84,3,74,'2016-08-22 19:04:47','2016-08-22 19:04:47','1/2/73/74/84',2,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Handbags',NULL,NULL,'handbags','boys/men/handbags'),(85,3,74,'2016-08-22 19:05:14','2016-08-22 19:05:15','1/2/73/74/85',3,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','boys/men/shose'),(86,3,74,'2016-08-22 19:05:43','2016-08-22 19:05:43','1/2/73/74/86',4,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','boys/men/jeans'),(87,3,74,'2016-08-22 19:06:13','2016-08-22 19:06:13','1/2/73/74/87',5,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','boys/men/t-shirts'),(88,3,76,'2016-08-22 19:06:42','2016-08-22 19:06:42','1/2/73/76/88',2,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','boys/womens/sed-dui-ante'),(89,3,76,'2016-08-22 19:07:11','2016-08-22 19:07:12','1/2/73/76/89',3,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','boys/womens/mauris-et-neque'),(90,3,76,'2016-08-22 19:07:42','2016-08-22 19:07:42','1/2/73/76/90',4,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','boys/womens/donec-porttitor'),(91,3,76,'2016-08-22 19:08:11','2016-08-22 19:08:11','1/2/73/76/91',5,4,0,8,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','boys/womens/clothing');

--
-- Table structure for table `catalog_category_flat_store_9`
--

CREATE TABLE `catalog_category_flat_store_9` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'attribute_set_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_9_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_9_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_9_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_9`
--

INSERT INTO `catalog_category_flat_store_9` VALUES (1,0,0,'2016-04-04 15:47:43','2019-12-13 10:10:44','1',0,0,203,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2016-08-22 19:08:30','1/2',1,1,77,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default Category',NULL,NULL,NULL,NULL),(4,3,2,'2016-04-04 20:49:44','2016-08-22 19:08:30','1/2/4',4,2,5,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Accessories',NULL,NULL,'accessories','accessories'),(5,3,2,'2016-04-04 20:53:47','2016-08-22 19:08:30','1/2/5',5,2,17,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bags & Purses',NULL,NULL,'bags-purses','bags-purses'),(6,3,2,'2016-04-04 20:56:55','2016-08-22 19:08:30','1/2/6',6,2,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','jeans'),(7,3,2,'2016-04-04 20:58:37','2016-08-22 19:08:30','1/2/7',7,2,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','men'),(8,3,38,'2016-04-04 21:32:28','2016-04-04 23:56:51','1/2/38/8',1,3,5,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','shop/men'),(9,3,8,'2016-04-04 21:33:02','2016-04-04 23:56:51','1/2/38/8/9',1,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','shop/men/clothing'),(10,3,8,'2016-04-04 21:33:58','2016-04-05 00:00:10','1/2/38/8/10',2,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Handbags',NULL,NULL,'handbags','shop/men/handbags'),(11,3,8,'2016-04-04 21:34:45','2016-04-04 23:56:51','1/2/38/8/11',3,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','shop/men/shose'),(12,3,8,'2016-04-04 21:35:39','2016-04-04 23:56:51','1/2/38/8/12',4,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','shop/men/jeans'),(13,3,8,'2016-04-04 21:36:43','2016-04-04 23:56:51','1/2/38/8/13',5,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','shop/men/t-shirts'),(14,3,38,'2016-04-04 21:37:42','2016-04-05 00:06:16','1/2/38/14',2,3,5,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Womens',NULL,NULL,'womens','shop/womens'),(15,3,14,'2016-04-04 21:38:18','2016-04-05 00:06:16','1/2/38/14/15',1,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','shop/womens/curabitur'),(16,3,14,'2016-04-04 21:40:09','2016-04-05 00:06:16','1/2/38/14/16',2,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','shop/womens/sed-dui-ante'),(17,3,14,'2016-04-04 21:41:56','2016-04-05 00:06:16','1/2/38/14/17',3,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','shop/womens/mauris-et-neque'),(18,3,14,'2016-04-04 21:43:00','2016-04-05 00:06:16','1/2/38/14/18',4,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','shop/womens/donec-porttitor'),(19,3,14,'2016-04-04 21:44:05','2016-04-05 00:06:16','1/2/38/14/19',5,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','shop/womens/clothing'),(20,3,38,'2016-04-04 21:46:33','2016-05-05 00:12:22','1/2/38/20',3,3,8,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','shop/mauris-et-neque'),(21,3,20,'2016-04-04 21:47:38','2016-04-05 00:11:41','1/2/38/20/21',1,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','shop/mauris-et-neque/sed-dui-ante'),(22,3,20,'2016-04-04 21:48:51','2016-05-05 00:12:22','1/2/38/20/22',2,4,3,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','shop/mauris-et-neque/morbi-quis'),(23,3,20,'2016-04-04 21:50:08','2016-04-05 00:11:41','1/2/38/20/23',3,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','shop/mauris-et-neque/donec-porttitor'),(24,3,20,'2016-04-04 21:51:28','2016-04-05 00:11:41','1/2/38/20/24',4,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Suspendisse',NULL,NULL,'suspendisse','shop/mauris-et-neque/suspendisse'),(25,3,20,'2016-04-04 21:52:52','2016-04-05 00:11:41','1/2/38/20/25',5,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Nulla facilisi',NULL,NULL,'nulla-facilisi','shop/mauris-et-neque/nulla-facilisi'),(26,3,38,'2016-04-04 21:54:24','2016-04-05 00:20:23','1/2/38/26',4,3,5,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','shop/donec-porttitor'),(27,3,26,'2016-04-04 21:55:33','2016-04-05 00:20:23','1/2/38/26/27',1,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','shop/donec-porttitor/mauris-et-neque'),(28,3,26,'2016-04-04 21:56:59','2016-04-05 00:20:23','1/2/38/26/28',2,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Quisque placerat',NULL,NULL,'quisque-placerat','shop/donec-porttitor/quisque-placerat'),(29,3,26,'2016-04-04 21:58:35','2016-04-05 00:20:23','1/2/38/26/29',3,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Get Inspired',NULL,NULL,'get-inspired','shop/donec-porttitor/get-inspired'),(30,3,26,'2016-04-04 22:00:11','2016-04-05 00:20:23','1/2/38/26/30',4,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','shop/donec-porttitor/curabitur'),(31,3,26,'2016-04-04 22:03:32','2016-04-05 00:20:23','1/2/38/26/31',5,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec pretium',NULL,NULL,'donec-pretium','shop/donec-porttitor/donec-pretium'),(32,3,4,'2016-04-04 22:19:26','2016-04-04 22:29:47','1/2/4/32',1,3,4,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All',NULL,NULL,'all','accessories/all'),(33,3,32,'2016-04-04 22:22:08','2016-04-04 22:22:08','1/2/4/32/33',1,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Footwear',NULL,NULL,'footwear','accessories/all/footwear'),(34,3,32,'2016-04-04 22:25:56','2016-04-04 22:25:57','1/2/4/32/34',2,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Furniture',NULL,NULL,'furniture','accessories/all/furniture'),(35,3,32,'2016-04-04 22:27:45','2016-04-04 22:27:45','1/2/4/32/35',3,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','accessories/all/shose'),(36,3,32,'2016-04-04 22:29:47','2016-04-04 22:29:47','1/2/4/32/36',4,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jewelry',NULL,NULL,'jewelry','accessories/all/jewelry'),(38,3,2,'2016-04-04 23:47:55','2016-05-05 00:12:22','1/2/38',1,2,27,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,'imges-cate.jpg',1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shop',NULL,NULL,'shop','shop'),(39,3,2,'2016-04-17 03:48:08','2016-08-22 19:08:30','1/2/39',8,2,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','t-shirts'),(40,3,5,'2016-04-18 14:19:54','2016-04-18 14:23:34','1/2/5/40',1,3,5,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','bags-purses/men'),(41,3,40,'2016-04-18 14:20:41','2016-04-18 14:20:41','1/2/5/40/41',1,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','bags-purses/men/clothing'),(42,3,40,'2016-04-18 14:21:26','2016-04-18 14:21:26','1/2/5/40/42',2,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Handbags',NULL,NULL,'handbags','bags-purses/men/handbags'),(43,3,40,'2016-04-18 14:22:17','2016-04-18 14:22:18','1/2/5/40/43',3,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','bags-purses/men/shose'),(44,3,40,'2016-04-18 14:22:56','2016-04-18 14:22:56','1/2/5/40/44',4,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','bags-purses/men/jeans'),(45,3,40,'2016-04-18 14:23:34','2016-04-18 14:23:34','1/2/5/40/45',5,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','bags-purses/men/t-shirts'),(46,3,5,'2016-04-18 14:24:39','2016-04-18 14:28:33','1/2/5/46',2,3,5,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Womens',NULL,NULL,'womens','bags-purses/womens'),(47,3,46,'2016-04-18 14:25:41','2016-04-18 14:25:41','1/2/5/46/47',1,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','bags-purses/womens/curabitur'),(48,3,46,'2016-04-18 14:26:28','2016-04-25 21:23:50','1/2/5/46/48',2,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','bags-purses/womens/sed-dui-ante'),(49,3,46,'2016-04-18 14:27:11','2016-04-18 14:27:11','1/2/5/46/49',3,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','bags-purses/womens/mauris-et-neque'),(50,3,46,'2016-04-18 14:27:51','2016-04-18 14:27:52','1/2/5/46/50',4,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','bags-purses/womens/donec-porttitor'),(51,3,46,'2016-04-18 14:28:33','2016-04-18 14:28:33','1/2/5/46/51',5,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','bags-purses/womens/clothing'),(52,3,5,'2016-04-18 14:29:41','2016-04-18 14:32:31','1/2/5/52',3,3,4,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','bags-purses/mauris-et-neque'),(53,3,52,'2016-04-18 14:30:06','2016-04-18 14:30:06','1/2/5/52/53',1,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','bags-purses/mauris-et-neque/sed-dui-ante'),(54,3,52,'2016-04-18 14:30:46','2016-04-18 14:30:46','1/2/5/52/54',2,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','bags-purses/mauris-et-neque/morbi-quis'),(55,3,52,'2016-04-18 14:31:32','2016-04-18 14:31:32','1/2/5/52/55',3,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','bags-purses/mauris-et-neque/donec-porttitor'),(56,3,52,'2016-04-18 14:32:31','2016-04-18 14:32:31','1/2/5/52/56',4,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Suspendisse',NULL,NULL,'suspendisse','bags-purses/mauris-et-neque/suspendisse'),(60,3,2,'2016-04-18 15:12:31','2019-05-31 13:44:08','1/2/60',9,2,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Hot',NULL,NULL,NULL,NULL,'Features',NULL,NULL,'features','features'),(67,3,22,'2016-05-05 00:01:36','2016-05-05 00:01:36','1/2/38/20/22/67',1,5,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','shop/mauris-et-neque/morbi-quis/morbi-quis'),(69,3,22,'2016-05-05 00:11:50','2016-05-05 00:11:50','1/2/38/20/22/69',2,5,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quisr',NULL,NULL,'morbi-quisr','shop/mauris-et-neque/morbi-quis/morbi-quisr'),(70,3,22,'2016-05-05 00:12:22','2016-05-05 00:12:22','1/2/38/20/22/70',3,5,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quist',NULL,NULL,'morbi-quist','shop/mauris-et-neque/morbi-quis/morbi-quist'),(71,3,2,'2016-08-22 18:20:40','2016-08-22 19:08:30','1/2/71',10,2,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','clothing'),(72,3,2,'2016-08-22 18:21:26','2016-08-22 19:08:30','1/2/72',11,2,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','curabitur'),(73,3,2,'2016-08-22 18:59:57','2016-08-22 19:08:30','1/2/73',2,2,18,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Boys',NULL,NULL,'boys','boys'),(74,3,73,'2016-08-22 19:00:21','2016-08-22 19:06:13','1/2/73/74',1,3,5,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Men',NULL,NULL,'men','boys/men'),(75,3,74,'2016-08-22 19:00:43','2016-08-22 19:00:43','1/2/73/74/75',1,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','boys/men/clothing'),(76,3,73,'2016-08-22 19:01:09','2016-08-22 19:08:11','1/2/73/76',2,3,5,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Womens',NULL,NULL,'womens','boys/womens'),(77,3,76,'2016-08-22 19:01:31','2016-08-22 19:01:31','1/2/73/76/77',1,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'New',NULL,NULL,NULL,NULL,'Curabitur',NULL,NULL,'curabitur','boys/womens/curabitur'),(78,3,73,'2016-08-22 19:02:03','2016-08-22 19:04:14','1/2/73/78',3,3,5,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','boys/mauris-et-neque'),(79,3,78,'2016-08-22 19:02:23','2016-08-22 19:02:23','1/2/73/78/79',1,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','boys/mauris-et-neque/sed-dui-ante'),(80,3,78,'2016-08-22 19:02:51','2016-08-22 19:02:51','1/2/73/78/80',2,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Morbi quis',NULL,NULL,'morbi-quis','boys/mauris-et-neque/morbi-quis'),(81,3,78,'2016-08-22 19:03:17','2016-08-22 19:03:17','1/2/73/78/81',3,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','boys/mauris-et-neque/donec-porttitor'),(82,3,78,'2016-08-22 19:03:44','2016-08-22 19:03:44','1/2/73/78/82',4,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Suspendisse',NULL,NULL,'suspendisse','boys/mauris-et-neque/suspendisse'),(83,3,78,'2016-08-22 19:04:14','2016-08-22 19:04:14','1/2/73/78/83',5,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Nulla facilisi',NULL,NULL,'nulla-facilisi','boys/mauris-et-neque/nulla-facilisi'),(84,3,74,'2016-08-22 19:04:47','2016-08-22 19:04:47','1/2/73/74/84',2,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,'Sale',NULL,NULL,NULL,NULL,'Handbags',NULL,NULL,'handbags','boys/men/handbags'),(85,3,74,'2016-08-22 19:05:14','2016-08-22 19:05:15','1/2/73/74/85',3,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shose',NULL,NULL,'shose','boys/men/shose'),(86,3,74,'2016-08-22 19:05:43','2016-08-22 19:05:43','1/2/73/74/86',4,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Jeans',NULL,NULL,'jeans','boys/men/jeans'),(87,3,74,'2016-08-22 19:06:13','2016-08-22 19:06:13','1/2/73/74/87',5,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'T-Shirts',NULL,NULL,'t-shirts','boys/men/t-shirts'),(88,3,76,'2016-08-22 19:06:42','2016-08-22 19:06:42','1/2/73/76/88',2,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Sed dui ante',NULL,NULL,'sed-dui-ante','boys/womens/sed-dui-ante'),(89,3,76,'2016-08-22 19:07:11','2016-08-22 19:07:12','1/2/73/76/89',3,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mauris et neque',NULL,NULL,'mauris-et-neque','boys/womens/mauris-et-neque'),(90,3,76,'2016-08-22 19:07:42','2016-08-22 19:07:42','1/2/73/76/90',4,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Donec porttitor',NULL,NULL,'donec-porttitor','boys/womens/donec-porttitor'),(91,3,76,'2016-08-22 19:08:11','2016-08-22 19:08:11','1/2/73/76/91',5,4,0,9,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clothing',NULL,NULL,'clothing','boys/womens/clothing');

--
-- Table structure for table `catalog_category_product`
--

CREATE TABLE `catalog_category_product` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'Position',
  `entity_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  PRIMARY KEY (`entity_id`,`category_id`,`product_id`),
  UNIQUE KEY `CATALOG_CATEGORY_PRODUCT_CATEGORY_ID_PRODUCT_ID` (`category_id`,`product_id`),
  KEY `CATALOG_CATEGORY_PRODUCT_PRODUCT_ID` (`product_id`),
  CONSTRAINT `CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_CTGR_PRD_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product To Category Linkage Table';

--
-- Dumping data for table `catalog_category_product`
--


--
-- Table structure for table `catalog_category_product_index`
--

CREATE TABLE `catalog_category_product_index` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `CAT_CTGR_PRD_IDX_STORE_ID_CTGR_ID_VISIBILITY_IS_PARENT_POSITION` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index';

--
-- Dumping data for table `catalog_category_product_index`
--


--
-- Table structure for table `catalog_category_product_index_replica`
--

CREATE TABLE `catalog_category_product_index_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `CAT_CTGR_PRD_IDX_STORE_ID_CTGR_ID_VISIBILITY_IS_PARENT_POSITION` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index';

--
-- Dumping data for table `catalog_category_product_index_replica`
--


--
-- Table structure for table `catalog_category_product_index_store1`
--

CREATE TABLE `catalog_category_product_index_store1` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_4B965DC45C352D6E4C9DC0FF50B1FCF5` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_47AB760CD6A893ACEA69A9C2E0112C60` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store1';

--
-- Dumping data for table `catalog_category_product_index_store1`
--


--
-- Table structure for table `catalog_category_product_index_store10`
--

CREATE TABLE `catalog_category_product_index_store10` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_BF8E9C147B9E369FA5F75474BF410B76` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_399EE76B5BD4142D9CCF0511849161E3` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store10';

--
-- Dumping data for table `catalog_category_product_index_store10`
--


--
-- Table structure for table `catalog_category_product_index_store10_replica`
--

CREATE TABLE `catalog_category_product_index_store10_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE10_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_F8ACF7CDE70069E0E1260FAB3C7FAF7E` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store10 Replica';

--
-- Dumping data for table `catalog_category_product_index_store10_replica`
--


--
-- Table structure for table `catalog_category_product_index_store11`
--

CREATE TABLE `catalog_category_product_index_store11` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_C745732E55C32D6FA5D2C9868E174B08` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_8E65224CF04CDBE62BE589AFCF1494B1` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store11';

--
-- Dumping data for table `catalog_category_product_index_store11`
--


--
-- Table structure for table `catalog_category_product_index_store11_replica`
--

CREATE TABLE `catalog_category_product_index_store11_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE11_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_9F0B77094AF348D2A235C90B326004F3` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store11 Replica';

--
-- Dumping data for table `catalog_category_product_index_store11_replica`
--


--
-- Table structure for table `catalog_category_product_index_store12`
--

CREATE TABLE `catalog_category_product_index_store12` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_16609E051506ED4B6244E0113C273205` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_4428CAC3271DF82611D82D3FF2E50FBB` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store12';

--
-- Dumping data for table `catalog_category_product_index_store12`
--


--
-- Table structure for table `catalog_category_product_index_store12_replica`
--

CREATE TABLE `catalog_category_product_index_store12_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE12_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_26FC86C5E205CE457A898997567F236E` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store12 Replica';

--
-- Dumping data for table `catalog_category_product_index_store12_replica`
--


--
-- Table structure for table `catalog_category_product_index_store13`
--

CREATE TABLE `catalog_category_product_index_store13` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_8389A453B1D17695872A3F5AB53CED55` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_15E0763074BBF12DA79E845D659BCC7F` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store13';

--
-- Dumping data for table `catalog_category_product_index_store13`
--


--
-- Table structure for table `catalog_category_product_index_store13_replica`
--

CREATE TABLE `catalog_category_product_index_store13_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE13_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_755D4F0D55D5EE6C608F4FF47294DEAF` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store13 Replica';

--
-- Dumping data for table `catalog_category_product_index_store13_replica`
--


--
-- Table structure for table `catalog_category_product_index_store14`
--

CREATE TABLE `catalog_category_product_index_store14` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_9B9988D49BCDD4DDA85639A10275AF55` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_4397C9A49019C8638DCA278481D2BA08` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store14';

--
-- Dumping data for table `catalog_category_product_index_store14`
--


--
-- Table structure for table `catalog_category_product_index_store14_replica`
--

CREATE TABLE `catalog_category_product_index_store14_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE14_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_0E7866384855D9DF5A459DF1F4331653` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store14 Replica';

--
-- Dumping data for table `catalog_category_product_index_store14_replica`
--


--
-- Table structure for table `catalog_category_product_index_store15`
--

CREATE TABLE `catalog_category_product_index_store15` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_7DD7C99BC8E8114A4D848016820DE2B5` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_8D43B1BEE1CA20FAB1718BAAF180DEA4` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store15';

--
-- Dumping data for table `catalog_category_product_index_store15`
--


--
-- Table structure for table `catalog_category_product_index_store15_replica`
--

CREATE TABLE `catalog_category_product_index_store15_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE15_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_30AF691B78F49C797377718B2DE040CF` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store15 Replica';

--
-- Dumping data for table `catalog_category_product_index_store15_replica`
--


--
-- Table structure for table `catalog_category_product_index_store16`
--

CREATE TABLE `catalog_category_product_index_store16` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_F7BB9FC1254D6AE58303F0E99F29E8D6` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_7EAFABA0BB20986BA68F4336BB04BC06` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store16';

--
-- Dumping data for table `catalog_category_product_index_store16`
--


--
-- Table structure for table `catalog_category_product_index_store16_replica`
--

CREATE TABLE `catalog_category_product_index_store16_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE16_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_3FCA7BB482F2A772620280C9007DB7F4` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store16 Replica';

--
-- Dumping data for table `catalog_category_product_index_store16_replica`
--


--
-- Table structure for table `catalog_category_product_index_store17`
--

CREATE TABLE `catalog_category_product_index_store17` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_537EBC4692CC4DCF8775BED1A7496D4E` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_E993A2D0EFF6EE785AA874FF5AED05BB` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store17';

--
-- Dumping data for table `catalog_category_product_index_store17`
--


--
-- Table structure for table `catalog_category_product_index_store17_replica`
--

CREATE TABLE `catalog_category_product_index_store17_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE17_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_7DB8B0AEC370845BCF75B550C2A66F47` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store17 Replica';

--
-- Dumping data for table `catalog_category_product_index_store17_replica`
--


--
-- Table structure for table `catalog_category_product_index_store18`
--

CREATE TABLE `catalog_category_product_index_store18` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_FE62EE5029D6B6B86BA6422E3BD7D3ED` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_6FD7B35BC5C70623A337127701885011` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store18';

--
-- Dumping data for table `catalog_category_product_index_store18`
--


--
-- Table structure for table `catalog_category_product_index_store18_replica`
--

CREATE TABLE `catalog_category_product_index_store18_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE18_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_3AC23404BB83160D5EE72D270D5C65B0` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store18 Replica';

--
-- Dumping data for table `catalog_category_product_index_store18_replica`
--


--
-- Table structure for table `catalog_category_product_index_store1_replica`
--

CREATE TABLE `catalog_category_product_index_store1_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE1_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_216E521C8AD125E066D2B0BAB4A08412` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store1 Replica';

--
-- Dumping data for table `catalog_category_product_index_store1_replica`
--


--
-- Table structure for table `catalog_category_product_index_store2`
--

CREATE TABLE `catalog_category_product_index_store2` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_87FCED52F67C72BB6992C79EB4DCFA8A` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_15B841C92B67D986A980051DF109F9D1` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store2';

--
-- Dumping data for table `catalog_category_product_index_store2`
--


--
-- Table structure for table `catalog_category_product_index_store20`
--

CREATE TABLE `catalog_category_product_index_store20` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_92A85414EA8D4FF1B880C684C605BD06` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_F4026BE614ED5AEE87C0195662EC9E1D` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store20';

--
-- Dumping data for table `catalog_category_product_index_store20`
--


--
-- Table structure for table `catalog_category_product_index_store20_replica`
--

CREATE TABLE `catalog_category_product_index_store20_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE20_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_A188CA2B301606E2B15DB75055D75EA8` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store20 Replica';

--
-- Dumping data for table `catalog_category_product_index_store20_replica`
--


--
-- Table structure for table `catalog_category_product_index_store21`
--

CREATE TABLE `catalog_category_product_index_store21` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_721C6AB95AB22995AF8E44317207DEF5` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_D3B5128D2707807AE149665B7613AA5C` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store21';

--
-- Dumping data for table `catalog_category_product_index_store21`
--


--
-- Table structure for table `catalog_category_product_index_store21_replica`
--

CREATE TABLE `catalog_category_product_index_store21_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE21_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_64CBFFB96BA3FA6476EE6CE065328279` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store21 Replica';

--
-- Dumping data for table `catalog_category_product_index_store21_replica`
--


--
-- Table structure for table `catalog_category_product_index_store22`
--

CREATE TABLE `catalog_category_product_index_store22` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_E2F404E14EABD9CFCF04336B7513EBAD` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_3845002CD81D987886AD046A6FEEEBF9` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store22';

--
-- Dumping data for table `catalog_category_product_index_store22`
--


--
-- Table structure for table `catalog_category_product_index_store22_replica`
--

CREATE TABLE `catalog_category_product_index_store22_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE22_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_2390CABA0542B9FEE737398F3AAEFB83` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store22 Replica';

--
-- Dumping data for table `catalog_category_product_index_store22_replica`
--


--
-- Table structure for table `catalog_category_product_index_store23`
--

CREATE TABLE `catalog_category_product_index_store23` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_382FE8EC99C38D003662EC35102CE874` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_D83F5A49F76A0611349B5BDDD6DC40F9` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store23';

--
-- Dumping data for table `catalog_category_product_index_store23`
--


--
-- Table structure for table `catalog_category_product_index_store23_replica`
--

CREATE TABLE `catalog_category_product_index_store23_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE23_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_344C788AFCBABE679435B703B2349BC0` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store23 Replica';

--
-- Dumping data for table `catalog_category_product_index_store23_replica`
--


--
-- Table structure for table `catalog_category_product_index_store24`
--

CREATE TABLE `catalog_category_product_index_store24` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_CB719A027B9E6B314363CBE78531AEBE` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_B7BACB0010B47F57594691A99365DCEE` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store24';

--
-- Dumping data for table `catalog_category_product_index_store24`
--


--
-- Table structure for table `catalog_category_product_index_store24_replica`
--

CREATE TABLE `catalog_category_product_index_store24_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE24_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_350694C3EAAE00E6D1964FD3D4A2591B` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store24 Replica';

--
-- Dumping data for table `catalog_category_product_index_store24_replica`
--


--
-- Table structure for table `catalog_category_product_index_store25`
--

CREATE TABLE `catalog_category_product_index_store25` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_CF001C3E51D59094245EB5E184713DEB` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_BC2DEB4F3A40C26B972B7EF4212CE935` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store25';

--
-- Dumping data for table `catalog_category_product_index_store25`
--


--
-- Table structure for table `catalog_category_product_index_store25_replica`
--

CREATE TABLE `catalog_category_product_index_store25_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE25_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_816DDD43DFA578B2B4EA4496783514FA` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store25 Replica';

--
-- Dumping data for table `catalog_category_product_index_store25_replica`
--


--
-- Table structure for table `catalog_category_product_index_store26`
--

CREATE TABLE `catalog_category_product_index_store26` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_0646F4B1B915122FB7696CFF9188D3A1` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_9C3D1036890DEFB405A3650CF8227CFB` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store26';

--
-- Dumping data for table `catalog_category_product_index_store26`
--


--
-- Table structure for table `catalog_category_product_index_store26_replica`
--

CREATE TABLE `catalog_category_product_index_store26_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE26_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_F15753C5E965732D4D4C1DD1372E8A0A` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store26 Replica';

--
-- Dumping data for table `catalog_category_product_index_store26_replica`
--


--
-- Table structure for table `catalog_category_product_index_store27`
--

CREATE TABLE `catalog_category_product_index_store27` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_877D3D6D985C04AF6ACD9E28BE6E4643` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_990F795AF99D9893827F6A7537A9A3BA` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store27';

--
-- Dumping data for table `catalog_category_product_index_store27`
--


--
-- Table structure for table `catalog_category_product_index_store27_replica`
--

CREATE TABLE `catalog_category_product_index_store27_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE27_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_137D1C0D86BF49DCF4AE414D0B7AA825` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store27 Replica';

--
-- Dumping data for table `catalog_category_product_index_store27_replica`
--


--
-- Table structure for table `catalog_category_product_index_store28`
--

CREATE TABLE `catalog_category_product_index_store28` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_1D650C590C4E2235BA4BBA9F61D8794F` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_976CE0CA1BF8E86A5545487FBE02E5F1` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store28';

--
-- Dumping data for table `catalog_category_product_index_store28`
--


--
-- Table structure for table `catalog_category_product_index_store28_replica`
--

CREATE TABLE `catalog_category_product_index_store28_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE28_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_4D4F58797967A467CBC4C4C21D1018F0` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store28 Replica';

--
-- Dumping data for table `catalog_category_product_index_store28_replica`
--


--
-- Table structure for table `catalog_category_product_index_store29`
--

CREATE TABLE `catalog_category_product_index_store29` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_D615F260B5664ABB32C5DC9DF1CCE0AA` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_F39252FC9C2B743BDF02ACC846D4FB53` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store29';

--
-- Dumping data for table `catalog_category_product_index_store29`
--


--
-- Table structure for table `catalog_category_product_index_store29_replica`
--

CREATE TABLE `catalog_category_product_index_store29_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE29_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_75C92F002E0FD36A892A9CCDC61A7F90` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store29 Replica';

--
-- Dumping data for table `catalog_category_product_index_store29_replica`
--


--
-- Table structure for table `catalog_category_product_index_store2_replica`
--

CREATE TABLE `catalog_category_product_index_store2_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE2_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_2AB6FE58F086547FA7E4590837296849` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store2 Replica';

--
-- Dumping data for table `catalog_category_product_index_store2_replica`
--


--
-- Table structure for table `catalog_category_product_index_store3`
--

CREATE TABLE `catalog_category_product_index_store3` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_43726D149468373EB56B59700A89860C` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_3A62575144A54728FACD3A0D6309E61D` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store3';

--
-- Dumping data for table `catalog_category_product_index_store3`
--


--
-- Table structure for table `catalog_category_product_index_store30`
--

CREATE TABLE `catalog_category_product_index_store30` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE30_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_AB1C07D4C8DD02C5999067C96AAAAE0C` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store30 Replica';

--
-- Dumping data for table `catalog_category_product_index_store30`
--


--
-- Table structure for table `catalog_category_product_index_store30_replica`
--

CREATE TABLE `catalog_category_product_index_store30_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_F52374B3D16C99B9D9D172EA73E7FC52` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_6D31D8EE6A63E3E66820D5084D135584` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store30';

--
-- Dumping data for table `catalog_category_product_index_store30_replica`
--


--
-- Table structure for table `catalog_category_product_index_store31`
--

CREATE TABLE `catalog_category_product_index_store31` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE31_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_4060D5E42E9EA7F2BEDE72733B7DC112` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store31 Replica';

--
-- Dumping data for table `catalog_category_product_index_store31`
--


--
-- Table structure for table `catalog_category_product_index_store31_replica`
--

CREATE TABLE `catalog_category_product_index_store31_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_C9E26C6BDD34B908776776C12042D282` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_E09FE6E25272C1F8590DB90F3C3E8683` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store31';

--
-- Dumping data for table `catalog_category_product_index_store31_replica`
--


--
-- Table structure for table `catalog_category_product_index_store32`
--

CREATE TABLE `catalog_category_product_index_store32` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE32_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_DA312F12A1BC87A46285084870D8AF8F` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store32 Replica';

--
-- Dumping data for table `catalog_category_product_index_store32`
--


--
-- Table structure for table `catalog_category_product_index_store32_replica`
--

CREATE TABLE `catalog_category_product_index_store32_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_4B8D3BDD131E3BA7BCE79A993173ED08` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_FA45B57F5BA8CF1C6313C3A5BF839796` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store32';

--
-- Dumping data for table `catalog_category_product_index_store32_replica`
--


--
-- Table structure for table `catalog_category_product_index_store33`
--

CREATE TABLE `catalog_category_product_index_store33` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE33_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_75569FD88581AED43F9DCB36F0A34DE8` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store33 Replica';

--
-- Dumping data for table `catalog_category_product_index_store33`
--


--
-- Table structure for table `catalog_category_product_index_store33_replica`
--

CREATE TABLE `catalog_category_product_index_store33_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_A40304AA6128C986EF2F4F9BBB20E56F` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_57AB4BCB1C36460F8DBDED8F9740C952` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store33';

--
-- Dumping data for table `catalog_category_product_index_store33_replica`
--


--
-- Table structure for table `catalog_category_product_index_store34`
--

CREATE TABLE `catalog_category_product_index_store34` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE34_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_5F1785CC63C7C07B159C15D910DE7011` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store34 Replica';

--
-- Dumping data for table `catalog_category_product_index_store34`
--


--
-- Table structure for table `catalog_category_product_index_store34_replica`
--

CREATE TABLE `catalog_category_product_index_store34_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_2B07AEEDF1EF543A0EF7B62AAAE63BD3` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_8BD5058A75F33D7BBBC47C7BCE084D93` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store34';

--
-- Dumping data for table `catalog_category_product_index_store34_replica`
--


--
-- Table structure for table `catalog_category_product_index_store35`
--

CREATE TABLE `catalog_category_product_index_store35` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE35_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_D9889D913EA1A7B9105E7D55E15CFE37` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store35 Replica';

--
-- Dumping data for table `catalog_category_product_index_store35`
--


--
-- Table structure for table `catalog_category_product_index_store35_replica`
--

CREATE TABLE `catalog_category_product_index_store35_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_887910B742EF22E629C0CE7D5A01456A` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_0CD05F47B762E925334B5909B23FFEB0` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store35';

--
-- Dumping data for table `catalog_category_product_index_store35_replica`
--


--
-- Table structure for table `catalog_category_product_index_store36`
--

CREATE TABLE `catalog_category_product_index_store36` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE36_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_7F5AB68AFF0F54AFD6EE5001C876D314` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store36 Replica';

--
-- Dumping data for table `catalog_category_product_index_store36`
--


--
-- Table structure for table `catalog_category_product_index_store36_replica`
--

CREATE TABLE `catalog_category_product_index_store36_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_CBE022AB42E9E370E61B68DCDCA78802` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_82587DFCAFE29018F031AB683960BFF0` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store36';

--
-- Dumping data for table `catalog_category_product_index_store36_replica`
--


--
-- Table structure for table `catalog_category_product_index_store37`
--

CREATE TABLE `catalog_category_product_index_store37` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE37_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_0CF06DE8A38D120EED089320AD43D268` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store37 Replica';

--
-- Dumping data for table `catalog_category_product_index_store37`
--


--
-- Table structure for table `catalog_category_product_index_store37_replica`
--

CREATE TABLE `catalog_category_product_index_store37_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_672C226B0AA4FA622FA566F18A0CA1A2` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_C066775E7F77665C7EE9C696D61DD1A3` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store37';

--
-- Dumping data for table `catalog_category_product_index_store37_replica`
--


--
-- Table structure for table `catalog_category_product_index_store38`
--

CREATE TABLE `catalog_category_product_index_store38` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE38_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_1DD41976C8350F3ACFEC1A3328A71B6B` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store38 Replica';

--
-- Dumping data for table `catalog_category_product_index_store38`
--


--
-- Table structure for table `catalog_category_product_index_store38_replica`
--

CREATE TABLE `catalog_category_product_index_store38_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_6CE6A3FE2E35BE3DAC7244610B56A206` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_DA20ADA9B38E45FD4F6A42EF22F9E384` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store38';

--
-- Dumping data for table `catalog_category_product_index_store38_replica`
--


--
-- Table structure for table `catalog_category_product_index_store39`
--

CREATE TABLE `catalog_category_product_index_store39` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE39_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_901F13EFDAF88E5F5EB4DE3CA14A7639` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store39 Replica';

--
-- Dumping data for table `catalog_category_product_index_store39`
--


--
-- Table structure for table `catalog_category_product_index_store39_replica`
--

CREATE TABLE `catalog_category_product_index_store39_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_18D7CFDC9ED6A45A44A0C09372AD854E` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_EBFC58D32C3DD1B3912091B09630FFC4` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store39';

--
-- Dumping data for table `catalog_category_product_index_store39_replica`
--


--
-- Table structure for table `catalog_category_product_index_store3_replica`
--

CREATE TABLE `catalog_category_product_index_store3_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE3_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_E9342558FA31C65508E1FE75E6242607` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store3 Replica';

--
-- Dumping data for table `catalog_category_product_index_store3_replica`
--


--
-- Table structure for table `catalog_category_product_index_store4`
--

CREATE TABLE `catalog_category_product_index_store4` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_966AADF0F2BFAFFC1235C826759845CC` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_F43ABBF162395BE3A1D5B1AE17C24FE2` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store4';

--
-- Dumping data for table `catalog_category_product_index_store4`
--


--
-- Table structure for table `catalog_category_product_index_store40`
--

CREATE TABLE `catalog_category_product_index_store40` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE40_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_875653C4A6FB598200F473DB8B58CCEA` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store40 Replica';

--
-- Dumping data for table `catalog_category_product_index_store40`
--


--
-- Table structure for table `catalog_category_product_index_store40_replica`
--

CREATE TABLE `catalog_category_product_index_store40_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_492DB3A7634579E629F661553DF69D55` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_6214B18AC363E4B23E59E6BA3B048BE6` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store40';

--
-- Dumping data for table `catalog_category_product_index_store40_replica`
--


--
-- Table structure for table `catalog_category_product_index_store41`
--

CREATE TABLE `catalog_category_product_index_store41` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE41_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_ADDA986D171D528138B31D94F31E5145` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store41 Replica';

--
-- Dumping data for table `catalog_category_product_index_store41`
--


--
-- Table structure for table `catalog_category_product_index_store41_replica`
--

CREATE TABLE `catalog_category_product_index_store41_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_3B5EED6D87A0E0A6B8D4F6C620D0A7DC` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_A5C497BFF9F6F6F7C99E4D8B1945F699` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store41';

--
-- Dumping data for table `catalog_category_product_index_store41_replica`
--


--
-- Table structure for table `catalog_category_product_index_store4_replica`
--

CREATE TABLE `catalog_category_product_index_store4_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE4_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_ABB606D1CB36CD160DB880F39838BC3F` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store4 Replica';

--
-- Dumping data for table `catalog_category_product_index_store4_replica`
--


--
-- Table structure for table `catalog_category_product_index_store5`
--

CREATE TABLE `catalog_category_product_index_store5` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_78288F76D618C4C378D1DE1DB362C05F` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_04B1890D19F381013371F9182F62C602` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store5';

--
-- Dumping data for table `catalog_category_product_index_store5`
--


--
-- Table structure for table `catalog_category_product_index_store5_replica`
--

CREATE TABLE `catalog_category_product_index_store5_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE5_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_D66B6557126C2DE627A049511C72BE10` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store5 Replica';

--
-- Dumping data for table `catalog_category_product_index_store5_replica`
--


--
-- Table structure for table `catalog_category_product_index_store6`
--

CREATE TABLE `catalog_category_product_index_store6` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_60907034DE58E5F1696F31290F80B9B6` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_65189DCB54C58237E1298BDD7727D150` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store6';

--
-- Dumping data for table `catalog_category_product_index_store6`
--


--
-- Table structure for table `catalog_category_product_index_store6_replica`
--

CREATE TABLE `catalog_category_product_index_store6_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE6_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_715799A609D876BA8BC3889F4D0D2350` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store6 Replica';

--
-- Dumping data for table `catalog_category_product_index_store6_replica`
--


--
-- Table structure for table `catalog_category_product_index_store7`
--

CREATE TABLE `catalog_category_product_index_store7` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_E9F919EC2BB507793EE19DA7C71D1C68` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_429013479D97EE179DF15355662AC756` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store7';

--
-- Dumping data for table `catalog_category_product_index_store7`
--


--
-- Table structure for table `catalog_category_product_index_store7_replica`
--

CREATE TABLE `catalog_category_product_index_store7_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE7_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_FC3C465EAA213CB948AAD83C52813CCF` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store7 Replica';

--
-- Dumping data for table `catalog_category_product_index_store7_replica`
--


--
-- Table structure for table `catalog_category_product_index_store8`
--

CREATE TABLE `catalog_category_product_index_store8` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_57B5E46D5E5C9F39BB7CE63D46A21EF5` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_72A17E5BDF6BE100A92393EED4942631` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store8';

--
-- Dumping data for table `catalog_category_product_index_store8`
--


--
-- Table structure for table `catalog_category_product_index_store8_replica`
--

CREATE TABLE `catalog_category_product_index_store8_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE8_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_4D42D0D334EFF63D3E99C6D90D3F3E39` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store8 Replica';

--
-- Dumping data for table `catalog_category_product_index_store8_replica`
--


--
-- Table structure for table `catalog_category_product_index_store9`
--

CREATE TABLE `catalog_category_product_index_store9` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_ADE8510F1BBEC8E64D9E49D2B86DF6A6` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_CAE8981A33EEF72C92B0DA20D82E8789` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store9';

--
-- Dumping data for table `catalog_category_product_index_store9`
--


--
-- Table structure for table `catalog_category_product_index_store9_replica`
--

CREATE TABLE `catalog_category_product_index_store9_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE9_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_ADAF96EF1972B57CCB3A89BA1A467864` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store9 Replica';

--
-- Dumping data for table `catalog_category_product_index_store9_replica`
--


--
-- Table structure for table `catalog_category_product_index_tmp`
--

CREATE TABLE `catalog_category_product_index_tmp` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_TMP_PRD_ID_CTGR_ID_STORE_ID` (`product_id`,`category_id`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Indexer temporary table';

--
-- Dumping data for table `catalog_category_product_index_tmp`
--


--
-- Table structure for table `catalog_compare_item`
--

CREATE TABLE `catalog_compare_item` (
  `catalog_compare_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Compare Item ID',
  `visitor_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Visitor ID',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `list_id` int(10) unsigned DEFAULT NULL COMMENT 'List ID',
  PRIMARY KEY (`catalog_compare_item_id`),
  KEY `CATALOG_COMPARE_ITEM_PRODUCT_ID` (`product_id`),
  KEY `CATALOG_COMPARE_ITEM_VISITOR_ID_PRODUCT_ID` (`visitor_id`,`product_id`),
  KEY `CATALOG_COMPARE_ITEM_CUSTOMER_ID_PRODUCT_ID` (`customer_id`,`product_id`),
  KEY `CATALOG_COMPARE_ITEM_STORE_ID` (`store_id`),
  KEY `CATALOG_COMPARE_ITEM_LIST_ID_CATALOG_COMPARE_LIST_LIST_ID` (`list_id`),
  CONSTRAINT `CATALOG_COMPARE_ITEM_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CATALOG_COMPARE_ITEM_LIST_ID_CATALOG_COMPARE_LIST_LIST_ID` FOREIGN KEY (`list_id`) REFERENCES `catalog_compare_list` (`list_id`) ON DELETE CASCADE,
  CONSTRAINT `CATALOG_COMPARE_ITEM_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CATALOG_COMPARE_ITEM_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Compare Table';

--
-- Dumping data for table `catalog_compare_item`
--


--
-- Table structure for table `catalog_compare_list`
--

CREATE TABLE `catalog_compare_list` (
  `list_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Compare List ID',
  `list_id_mask` varchar(32) DEFAULT NULL COMMENT 'Masked ID',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  PRIMARY KEY (`list_id`),
  UNIQUE KEY `CATALOG_COMPARE_LIST_CUSTOMER_ID` (`customer_id`),
  KEY `CATALOG_COMPARE_LIST_LIST_ID_MASK` (`list_id_mask`),
  CONSTRAINT `CATALOG_COMPARE_LIST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Compare List with hash Table';

--
-- Dumping data for table `catalog_compare_list`
--


--
-- Table structure for table `catalog_eav_attribute`
--

CREATE TABLE `catalog_eav_attribute` (
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `frontend_input_renderer` varchar(255) DEFAULT NULL COMMENT 'Frontend Input Renderer',
  `is_global` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Global',
  `is_visible` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Visible',
  `is_searchable` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Searchable',
  `is_filterable` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Filterable',
  `is_comparable` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Comparable',
  `is_visible_on_front` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible On Front',
  `is_html_allowed_on_front` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is HTML Allowed On Front',
  `is_used_for_price_rules` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Used For Price Rules',
  `is_filterable_in_search` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Filterable In Search',
  `used_in_product_listing` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Used In Product Listing',
  `used_for_sort_by` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Used For Sorting',
  `apply_to` varchar(255) DEFAULT NULL COMMENT 'Apply To',
  `is_visible_in_advanced_search` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible In Advanced Search',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'Position',
  `is_wysiwyg_enabled` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is WYSIWYG Enabled',
  `is_used_for_promo_rules` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Used For Promo Rules',
  `is_required_in_admin_store` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Required In Admin Store',
  `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',
  `search_weight` float NOT NULL DEFAULT '1' COMMENT 'Search Weight',
  `additional_data` text COMMENT 'Additional swatch attributes data',
  `is_pagebuilder_enabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is PageBuilder Enabled',
  PRIMARY KEY (`attribute_id`),
  KEY `CATALOG_EAV_ATTRIBUTE_USED_FOR_SORT_BY` (`used_for_sort_by`),
  KEY `CATALOG_EAV_ATTRIBUTE_USED_IN_PRODUCT_LISTING` (`used_in_product_listing`),
  CONSTRAINT `CATALOG_EAV_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog EAV Attribute Table';

--
-- Dumping data for table `catalog_eav_attribute`
--


--
-- Table structure for table `catalog_product_bundle_option`
--

CREATE TABLE `catalog_product_bundle_option` (
  `option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `required` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Required',
  `position` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Position',
  `type` varchar(255) DEFAULT NULL COMMENT 'Type',
  PRIMARY KEY (`option_id`),
  KEY `CATALOG_PRODUCT_BUNDLE_OPTION_PARENT_ID` (`parent_id`),
  CONSTRAINT `CAT_PRD_BNDL_OPT_PARENT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`parent_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Option';

--
-- Dumping data for table `catalog_product_bundle_option`
--


--
-- Table structure for table `catalog_product_bundle_option_value`
--

CREATE TABLE `catalog_product_bundle_option_value` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `option_id` int(10) unsigned NOT NULL COMMENT 'Option ID',
  `parent_product_id` int(10) unsigned NOT NULL COMMENT 'Parent Product ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CAT_PRD_BNDL_OPT_VAL_OPT_ID_PARENT_PRD_ID_STORE_ID` (`option_id`,`parent_product_id`,`store_id`),
  CONSTRAINT `CAT_PRD_BNDL_OPT_VAL_OPT_ID_CAT_PRD_BNDL_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_bundle_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Option Value';

--
-- Dumping data for table `catalog_product_bundle_option_value`
--


--
-- Table structure for table `catalog_product_bundle_price_index`
--

CREATE TABLE `catalog_product_bundle_price_index` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
  `min_price` decimal(20,6) NOT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) NOT NULL COMMENT 'Max Price',
  PRIMARY KEY (`entity_id`,`website_id`,`customer_group_id`),
  KEY `CATALOG_PRODUCT_BUNDLE_PRICE_INDEX_WEBSITE_ID` (`website_id`),
  KEY `CATALOG_PRODUCT_BUNDLE_PRICE_INDEX_CUSTOMER_GROUP_ID` (`customer_group_id`),
  CONSTRAINT `CAT_PRD_BNDL_PRICE_IDX_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_BNDL_PRICE_IDX_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_BNDL_PRICE_IDX_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Price Index';

--
-- Dumping data for table `catalog_product_bundle_price_index`
--


--
-- Table structure for table `catalog_product_bundle_selection`
--

CREATE TABLE `catalog_product_bundle_selection` (
  `selection_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Selection ID',
  `option_id` int(10) unsigned NOT NULL COMMENT 'Option ID',
  `parent_product_id` int(10) unsigned NOT NULL COMMENT 'Parent Product ID',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
  `position` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Position',
  `is_default` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Default',
  `selection_price_type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Selection Price Type',
  `selection_price_value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Selection Price Value',
  `selection_qty` decimal(12,4) DEFAULT NULL COMMENT 'Selection Qty',
  `selection_can_change_qty` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Selection Can Change Qty',
  PRIMARY KEY (`selection_id`),
  KEY `CATALOG_PRODUCT_BUNDLE_SELECTION_OPTION_ID` (`option_id`),
  KEY `CATALOG_PRODUCT_BUNDLE_SELECTION_PRODUCT_ID` (`product_id`),
  CONSTRAINT `CAT_PRD_BNDL_SELECTION_OPT_ID_CAT_PRD_BNDL_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_bundle_option` (`option_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_BNDL_SELECTION_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Selection';

--
-- Dumping data for table `catalog_product_bundle_selection`
--


--
-- Table structure for table `catalog_product_bundle_selection_price`
--

CREATE TABLE `catalog_product_bundle_selection_price` (
  `selection_id` int(10) unsigned NOT NULL COMMENT 'Selection ID',
  `parent_product_id` int(10) unsigned NOT NULL COMMENT 'Parent Product ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `selection_price_type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Selection Price Type',
  `selection_price_value` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Selection Price Value',
  PRIMARY KEY (`selection_id`,`parent_product_id`,`website_id`),
  KEY `CATALOG_PRODUCT_BUNDLE_SELECTION_PRICE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `CAT_PRD_BNDL_SELECTION_PRICE_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_DCF37523AA05D770A70AA4ED7C2616E4` FOREIGN KEY (`selection_id`) REFERENCES `catalog_product_bundle_selection` (`selection_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Selection Price';

--
-- Dumping data for table `catalog_product_bundle_selection_price`
--


--
-- Table structure for table `catalog_product_bundle_stock_index`
--

CREATE TABLE `catalog_product_bundle_stock_index` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `stock_id` smallint(5) unsigned NOT NULL COMMENT 'Stock ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option ID',
  `stock_status` smallint(6) DEFAULT '0' COMMENT 'Stock Status',
  PRIMARY KEY (`entity_id`,`website_id`,`stock_id`,`option_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Stock Index';

--
-- Dumping data for table `catalog_product_bundle_stock_index`
--


--
-- Table structure for table `catalog_product_entity`
--

CREATE TABLE `catalog_product_entity` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type ID',
  `sku` varchar(64) DEFAULT NULL COMMENT 'SKU',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Has Options',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Required Options',
  `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 (`entity_id`),
  KEY `CATALOG_PRODUCT_ENTITY_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `CATALOG_PRODUCT_ENTITY_SKU` (`sku`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Table';

--
-- Dumping data for table `catalog_product_entity`
--


--
-- Table structure for table `catalog_product_entity_datetime`
--

CREATE TABLE `catalog_product_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',
  `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 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CATALOG_PRODUCT_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_ENTITY_DATETIME_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_PRODUCT_ENTITY_DATETIME_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_DTIME_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_DTIME_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Datetime Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_datetime`
--


--
-- Table structure for table `catalog_product_entity_decimal`
--

CREATE TABLE `catalog_product_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',
  `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(20,6) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CATALOG_PRODUCT_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_DECIMAL_STORE_ID` (`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `CATALOG_PRODUCT_ENTITY_DECIMAL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_DEC_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_DEC_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Decimal Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_decimal`
--


--
-- Table structure for table `catalog_product_entity_gallery`
--

CREATE TABLE `catalog_product_entity_gallery` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value 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',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'Position',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CATALOG_PRODUCT_ENTITY_GALLERY_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_GALLERY_ENTITY_ID` (`entity_id`),
  KEY `CATALOG_PRODUCT_ENTITY_GALLERY_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_ENTITY_GALLERY_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_PRODUCT_ENTITY_GALLERY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_GLR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_GLR_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Gallery Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_gallery`
--


--
-- Table structure for table `catalog_product_entity_int`
--

CREATE TABLE `catalog_product_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',
  `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) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_ENTITY_INT_STORE_ID` (`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_INT_ATTRIBUTE_ID_STORE_ID_VALUE` (`attribute_id`,`store_id`,`value`),
  CONSTRAINT `CATALOG_PRODUCT_ENTITY_INT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_INT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Integer Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_int`
--


--
-- Table structure for table `catalog_product_entity_media_gallery`
--

CREATE TABLE `catalog_product_entity_media_gallery` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  `media_type` varchar(32) NOT NULL DEFAULT 'image' COMMENT 'Media entry type',
  `disabled` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Visibility status',
  PRIMARY KEY (`value_id`),
  KEY `CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Media Gallery Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_media_gallery`
--


--
-- Table structure for table `catalog_product_entity_media_gallery_value`
--

CREATE TABLE `catalog_product_entity_media_gallery_value` (
  `value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Value 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',
  `label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `position` int(10) unsigned DEFAULT NULL COMMENT 'Position',
  `disabled` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Disabled',
  `record_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Record ID',
  PRIMARY KEY (`record_id`),
  KEY `CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_VALUE_STORE_ID` (`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_VALUE_ENTITY_ID` (`entity_id`),
  KEY `CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_VALUE_VALUE_ID` (`value_id`),
  KEY `CAT_PRD_ENTT_MDA_GLR_VAL_ENTT_ID_VAL_ID_STORE_ID` (`entity_id`,`value_id`,`store_id`),
  CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_VAL_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_VAL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_VAL_VAL_ID_CAT_PRD_ENTT_MDA_GLR_VAL_ID` FOREIGN KEY (`value_id`) REFERENCES `catalog_product_entity_media_gallery` (`value_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Media Gallery Attribute Value Table';

--
-- Dumping data for table `catalog_product_entity_media_gallery_value`
--


--
-- Table structure for table `catalog_product_entity_media_gallery_value_to_entity`
--

CREATE TABLE `catalog_product_entity_media_gallery_value_to_entity` (
  `value_id` int(10) unsigned NOT NULL COMMENT 'Value media Entry ID',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Product Entity ID',
  PRIMARY KEY (`value_id`,`entity_id`),
  UNIQUE KEY `CAT_PRD_ENTT_MDA_GLR_VAL_TO_ENTT_VAL_ID_ENTT_ID` (`value_id`,`entity_id`),
  KEY `CAT_PRD_ENTT_MDA_GLR_VAL_TO_ENTT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` (`entity_id`),
  CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_VAL_TO_ENTT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_A6C6C8FAA386736921D3A7C4B50B1185` FOREIGN KEY (`value_id`) REFERENCES `catalog_product_entity_media_gallery` (`value_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Link Media value to Product entity table';

--
-- Dumping data for table `catalog_product_entity_media_gallery_value_to_entity`
--


--
-- Table structure for table `catalog_product_entity_media_gallery_value_video`
--

CREATE TABLE `catalog_product_entity_media_gallery_value_video` (
  `value_id` int(10) unsigned NOT NULL COMMENT 'Media Entity ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `provider` varchar(32) DEFAULT NULL COMMENT 'Video provider ID',
  `url` text COMMENT 'Video URL',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `description` text COMMENT 'Page Meta Description',
  `metadata` text COMMENT 'Video meta data',
  PRIMARY KEY (`value_id`,`store_id`),
  UNIQUE KEY `CAT_PRD_ENTT_MDA_GLR_VAL_VIDEO_VAL_ID_STORE_ID` (`value_id`,`store_id`),
  KEY `CAT_PRD_ENTT_MDA_GLR_VAL_VIDEO_STORE_ID_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_VAL_VIDEO_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_6FDF205946906B0E653E60AA769899F8` FOREIGN KEY (`value_id`) REFERENCES `catalog_product_entity_media_gallery` (`value_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Video Table';

--
-- Dumping data for table `catalog_product_entity_media_gallery_value_video`
--


--
-- Table structure for table `catalog_product_entity_text`
--

CREATE TABLE `catalog_product_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',
  `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 COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_ENTITY_TEXT_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_PRODUCT_ENTITY_TEXT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_TEXT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_TEXT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Text Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_text`
--


--
-- Table structure for table `catalog_product_entity_tier_price`
--

CREATE TABLE `catalog_product_entity_tier_price` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `all_groups` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Applicable To All Customer Groups',
  `customer_group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer Group ID',
  `qty` decimal(12,4) NOT NULL DEFAULT '1.0000' COMMENT 'QTY',
  `value` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Value',
  `percentage_value` decimal(5,2) DEFAULT NULL COMMENT 'Percentage value',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_E8AB433B9ACB00343ABB312AD2FAB087` (`entity_id`,`all_groups`,`customer_group_id`,`qty`,`website_id`),
  KEY `CATALOG_PRODUCT_ENTITY_TIER_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `CATALOG_PRODUCT_ENTITY_TIER_PRICE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Tier Price Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_tier_price`
--


--
-- Table structure for table `catalog_product_entity_varchar`
--

CREATE TABLE `catalog_product_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',
  `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 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CATALOG_PRODUCT_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_ENTITY_VARCHAR_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_PRODUCT_ENTITY_VARCHAR_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_VCHR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_VCHR_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Varchar Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_varchar`
--


--
-- Table structure for table `catalog_product_flat_1`
--

CREATE TABLE `catalog_product_flat_1` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type Id',
  `climate` varchar(255) DEFAULT NULL COMMENT 'climate column',
  `color` int(11) DEFAULT NULL COMMENT 'color column',
  `color_value` varchar(255) DEFAULT NULL COMMENT 'color column',
  `cost` decimal(12,4) DEFAULT NULL COMMENT 'cost',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'created_at',
  `description` longtext COMMENT 'description',
  `featured` int(11) DEFAULT NULL COMMENT 'featured',
  `gift_message_available` smallint(6) DEFAULT NULL COMMENT 'gift_message_available column',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'has_options',
  `image` varchar(255) DEFAULT NULL COMMENT 'image',
  `image_label` varchar(255) DEFAULT NULL COMMENT 'image_label',
  `links_exist` int(11) DEFAULT NULL COMMENT 'links_exist',
  `links_purchased_separately` int(11) DEFAULT NULL COMMENT 'links_purchased_separately',
  `links_title` varchar(255) DEFAULT NULL COMMENT 'links_title',
  `manufacturer` int(11) DEFAULT NULL COMMENT 'manufacturer column',
  `manufacturer_value` varchar(255) DEFAULT NULL COMMENT 'manufacturer column',
  `material` varchar(255) DEFAULT NULL COMMENT 'material column',
  `msrp` decimal(12,4) DEFAULT NULL COMMENT 'msrp',
  `msrp_display_actual_price_type` text COMMENT 'msrp_display_actual_price_type',
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `news_from_date` datetime DEFAULT NULL COMMENT 'news_from_date',
  `news_to_date` datetime DEFAULT NULL COMMENT 'news_to_date',
  `pattern` varchar(255) DEFAULT NULL COMMENT 'pattern column',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'price',
  `price_type` int(11) DEFAULT NULL COMMENT 'price_type',
  `price_view` int(11) DEFAULT NULL COMMENT 'Bundle Price View price_view column',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'required_options',
  `short_description` longtext COMMENT 'short_description',
  `size` int(11) DEFAULT NULL COMMENT 'size column',
  `size_value` varchar(255) DEFAULT NULL COMMENT 'size column',
  `sku` varchar(64) DEFAULT NULL COMMENT 'sku',
  `sku_type` int(11) DEFAULT NULL COMMENT 'sku_type',
  `small_image` varchar(255) DEFAULT NULL COMMENT 'small_image',
  `small_image_label` varchar(255) DEFAULT NULL COMMENT 'small_image_label',
  `special_from_date` datetime DEFAULT NULL COMMENT 'special_from_date',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'special_price',
  `special_to_date` datetime DEFAULT NULL COMMENT 'special_to_date',
  `swatch_image` varchar(255) DEFAULT NULL COMMENT 'swatch_image',
  `tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'tax_class_id tax column',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'thumbnail',
  `thumbnail_label` varchar(255) DEFAULT NULL COMMENT 'thumbnail_label',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'url_key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'url_path',
  `visibility` smallint(5) unsigned DEFAULT NULL COMMENT 'Catalog Product Visibility visibility column',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'weight',
  `weight_type` int(11) DEFAULT NULL COMMENT 'weight_type',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_TYPE_ID` (`type_id`),
  KEY `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_NAME` (`name`),
  KEY `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_PRICE` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Flat (Store 1)';

--
-- Dumping data for table `catalog_product_flat_1`
--


--
-- Table structure for table `catalog_product_flat_10`
--

CREATE TABLE `catalog_product_flat_10` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type Id',
  `climate` varchar(255) DEFAULT NULL COMMENT 'climate column',
  `color` int(11) DEFAULT NULL COMMENT 'color column',
  `color_value` varchar(255) DEFAULT NULL COMMENT 'color column',
  `cost` decimal(12,4) DEFAULT NULL COMMENT 'cost',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'created_at',
  `description` longtext COMMENT 'description',
  `featured` int(11) DEFAULT NULL COMMENT 'featured',
  `gift_message_available` smallint(6) DEFAULT NULL COMMENT 'gift_message_available column',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'has_options',
  `image` varchar(255) DEFAULT NULL COMMENT 'image',
  `image_label` varchar(255) DEFAULT NULL COMMENT 'image_label',
  `links_exist` int(11) DEFAULT NULL COMMENT 'links_exist',
  `links_purchased_separately` int(11) DEFAULT NULL COMMENT 'links_purchased_separately',
  `links_title` varchar(255) DEFAULT NULL COMMENT 'links_title',
  `manufacturer` int(11) DEFAULT NULL COMMENT 'manufacturer column',
  `manufacturer_value` varchar(255) DEFAULT NULL COMMENT 'manufacturer column',
  `material` varchar(255) DEFAULT NULL COMMENT 'material column',
  `msrp` decimal(12,4) DEFAULT NULL COMMENT 'msrp',
  `msrp_display_actual_price_type` text COMMENT 'msrp_display_actual_price_type',
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `news_from_date` datetime DEFAULT NULL COMMENT 'news_from_date',
  `news_to_date` datetime DEFAULT NULL COMMENT 'news_to_date',
  `pattern` varchar(255) DEFAULT NULL COMMENT 'pattern column',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'price',
  `price_type` int(11) DEFAULT NULL COMMENT 'price_type',
  `price_view` int(11) DEFAULT NULL COMMENT 'Bundle Price View price_view column',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'required_options',
  `short_description` longtext COMMENT 'short_description',
  `size` int(11) DEFAULT NULL COMMENT 'size column',
  `size_value` varchar(255) DEFAULT NULL COMMENT 'size column',
  `sku` varchar(64) DEFAULT NULL COMMENT 'sku',
  `sku_type` int(11) DEFAULT NULL COMMENT 'sku_type',
  `small_image` varchar(255) DEFAULT NULL COMMENT 'small_image',
  `small_image_label` varchar(255) DEFAULT NULL COMMENT 'small_image_label',
  `special_from_date` datetime DEFAULT NULL COMMENT 'special_from_date',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'special_price',
  `special_to_date` datetime DEFAULT NULL COMMENT 'special_to_date',
  `swatch_image` varchar(255) DEFAULT NULL COMMENT 'swatch_image',
  `tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'tax_class_id tax column',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'thumbnail',
  `thumbnail_label` varchar(255) DEFAULT NULL COMMENT 'thumbnail_label',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'url_key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'url_path',
  `visibility` smallint(5) unsigned DEFAULT NULL COMMENT 'Catalog Product Visibility visibility column',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'weight',
  `weight_type` int(11) DEFAULT NULL COMMENT 'weight_type',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_PRODUCT_FLAT_10_TMP_INDEXER_TYPE_ID` (`type_id`),
  KEY `CATALOG_PRODUCT_FLAT_10_TMP_INDEXER_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `CATALOG_PRODUCT_FLAT_10_TMP_INDEXER_NAME` (`name`),
  KEY `CATALOG_PRODUCT_FLAT_10_TMP_INDEXER_PRICE` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Flat (Store 10)';

--
