-- Table structure for table `mag2_url_rewrite`
--

CREATE TABLE `mag2_url_rewrite` (
  `url_rewrite_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rewrite Id',
  `entity_type` varchar(32) NOT NULL COMMENT 'Entity type code',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `request_path` varchar(255) DEFAULT NULL COMMENT 'Request Path',
  `target_path` varchar(255) DEFAULT NULL COMMENT 'Target Path',
  `redirect_type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Redirect Type',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  `description` varchar(255) DEFAULT NULL COMMENT 'Description',
  `is_autogenerated` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is rewrite generated automatically flag',
  `metadata` varchar(255) DEFAULT NULL COMMENT 'Meta data for url rewrite',
  PRIMARY KEY (`url_rewrite_id`),
  UNIQUE KEY `MAG2_URL_REWRITE_REQUEST_PATH_STORE_ID` (`request_path`,`store_id`),
  KEY `MAG2_URL_REWRITE_TARGET_PATH` (`target_path`),
  KEY `MAG2_URL_REWRITE_STORE_ID_ENTITY_ID` (`store_id`,`entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13821 DEFAULT CHARSET=utf8 COMMENT='Url Rewrites';

--
-- Dumping data for table `mag2_url_rewrite`
--

INSERT INTO `mag2_url_rewrite` VALUES (1,'cms-page',1,'no-route','cms/page/view/page_id/1',0,1,NULL,1,NULL),(3,'cms-page',3,'enable-cookies','cms/page/view/page_id/3',0,1,NULL,1,NULL),(162,'category',22,'women/bottoms-women.html','catalog/category/view/id/22',0,1,NULL,1,NULL),(611,'category',37,'sale.html','catalog/category/view/id/37',0,1,NULL,1,NULL),(625,'cms-page',12,'wokiee_home_page_6','cms/page/view/page_id/12',0,1,NULL,1,NULL),(638,'cms-page',25,'wokiee_404','cms/page/view/page_id/25',0,1,NULL,1,NULL),(655,'category',42,'mawaqaatest.html','catalog/category/view/id/42',0,1,NULL,1,NULL),(1619,'cms-page',42,'term-and-conditions','cms/page/view/page_id/42',0,1,NULL,1,NULL),(1682,'category',13,'boys/bottoms-men.html','catalog/category/view/id/13',0,1,NULL,1,NULL),(1687,'category',13,'men/bottoms-men.html','boys/bottoms-men.html',301,1,NULL,0,NULL),(2579,'category',3,'outdoor.html','catalog/category/view/id/3',0,1,NULL,1,NULL),(2580,'category',4,'outdoor/bags.html','catalog/category/view/id/4',0,1,NULL,1,NULL),(2581,'category',4,'gear/bags.html','outdoor/bags.html',301,1,NULL,0,NULL),(2582,'category',5,'outdoor/fitness-equipment.html','catalog/category/view/id/5',0,1,NULL,1,NULL),(2583,'category',5,'gear/fitness-equipment.html','outdoor/fitness-equipment.html',301,1,NULL,0,NULL),(2584,'category',6,'outdoor/watches.html','catalog/category/view/id/6',0,1,NULL,1,NULL),(2585,'category',6,'gear/watches.html','outdoor/watches.html',301,1,NULL,0,NULL),(2586,'category',3,'gear.html','outdoor.html',301,1,NULL,0,NULL),(8042,'category',53,'furniture.html','catalog/category/view/id/53',0,1,NULL,1,NULL),(8153,'category',43,'shop-by-price.html','catalog/category/view/id/43',0,1,NULL,1,NULL),(8173,'category',43,'shop-by-price-manufacturer-216.html','shop-by-price.html',301,1,NULL,0,NULL),(8432,'category',23,'women/jackets-women.html','catalog/category/view/id/23',0,1,NULL,1,NULL),(8433,'category',23,'women/tops-women/jackets-women.html','women/jackets-women.html',301,1,NULL,0,NULL),(8618,'category',24,'women/hoodies-and-sweatshirts-women.html','catalog/category/view/id/24',0,1,NULL,1,NULL),(8619,'category',24,'women/tops-women/hoodies-and-sweatshirts-women.html','women/hoodies-and-sweatshirts-women.html',301,1,NULL,0,NULL),(8766,'category',25,'women/tees-women.html','catalog/category/view/id/25',0,1,NULL,1,NULL),(8767,'category',25,'women/tops-women/tees-women.html','women/tees-women.html',301,1,NULL,0,NULL),(8962,'category',26,'women/tanks-women.html','catalog/category/view/id/26',0,1,NULL,1,NULL),(8963,'category',26,'women/tops-women/tanks-women.html','women/tanks-women.html',301,1,NULL,0,NULL),(9140,'category',27,'women/pants-women.html','catalog/category/view/id/27',0,1,NULL,1,NULL),(9141,'category',27,'women/bottoms-women/pants-women.html','women/pants-women.html',301,1,NULL,0,NULL),(9320,'category',28,'women/shorts-women.html','catalog/category/view/id/28',0,1,NULL,1,NULL),(9321,'category',28,'women/bottoms-women/shorts-women.html','women/shorts-women.html',301,1,NULL,0,NULL),(9750,'category',17,'boys/tanks-men.html','catalog/category/view/id/17',0,1,NULL,1,NULL),(9751,'category',17,'boys/tops-men/tanks-men.html','boys/tanks-men.html',301,1,NULL,0,NULL),(9752,'category',17,'men/tops-men/tanks-men.html','boys/tanks-men.html',301,1,NULL,0,'[]'),(10484,'category',14,'mawaqaatest/jackets-men.html','catalog/category/view/id/14',0,1,NULL,1,NULL),(10485,'category',14,'furniture/jackets-men.html','mawaqaatest/jackets-men.html',301,1,NULL,0,NULL),(10486,'category',14,'jackets-men.html','mawaqaatest/jackets-men.html',301,1,NULL,0,'[]'),(10487,'category',14,'boys/jackets-men.html','mawaqaatest/jackets-men.html',301,1,NULL,0,'[]'),(10488,'category',14,'boys/tops-men/jackets-men.html','mawaqaatest/jackets-men.html',301,1,NULL,0,'[]'),(10489,'category',14,'men/tops-men/jackets-men.html','mawaqaatest/jackets-men.html',301,1,NULL,0,'[]'),(10600,'category',12,'mawaqaatest/tops-men.html','catalog/category/view/id/12',0,1,NULL,1,NULL),(10601,'category',12,'boys/tops-men.html','mawaqaatest/tops-men.html',301,1,NULL,0,NULL),(10602,'category',12,'men/tops-men.html','mawaqaatest/tops-men.html',301,1,NULL,0,'[]'),(10606,'category',19,'mawaqaatest/shorts-men.html','catalog/category/view/id/19',0,1,NULL,1,NULL),(10607,'category',19,'boys/shorts-men.html','mawaqaatest/shorts-men.html',301,1,NULL,0,NULL),(10608,'category',19,'boys/bottoms-men/shorts-men.html','mawaqaatest/shorts-men.html',301,1,NULL,0,'[]'),(10609,'category',19,'men/bottoms-men/shorts-men.html','mawaqaatest/shorts-men.html',301,1,NULL,0,'[]'),(10772,'category',18,'mawaqaatest/pants-men.html','catalog/category/view/id/18',0,1,NULL,1,NULL),(10773,'category',18,'boys/pants-men.html','mawaqaatest/pants-men.html',301,1,NULL,0,NULL),(10774,'category',18,'boys/bottoms-men/pants-men.html','mawaqaatest/pants-men.html',301,1,NULL,0,'[]'),(10775,'category',18,'men/bottoms-men/pants-men.html','mawaqaatest/pants-men.html',301,1,NULL,0,'[]'),(10978,'category',16,'mawaqaatest/tees-men.html','catalog/category/view/id/16',0,1,NULL,1,NULL),(10979,'category',16,'boys/tees-men.html','mawaqaatest/tees-men.html',301,1,NULL,0,NULL),(10980,'category',16,'boys/tops-men/tees-men.html','mawaqaatest/tees-men.html',301,1,NULL,0,'[]'),(10981,'category',16,'men/tops-men/tees-men.html','mawaqaatest/tees-men.html',301,1,NULL,0,'[]'),(11166,'category',55,'furniture/beds.html','catalog/category/view/id/55',0,1,NULL,1,NULL),(11169,'category',56,'furniture/cabinets.html','catalog/category/view/id/56',0,1,NULL,1,NULL),(11172,'category',57,'furniture/desks.html','catalog/category/view/id/57',0,1,NULL,1,NULL),(11175,'category',58,'furniture/storage-and-organizers.html','catalog/category/view/id/58',0,1,NULL,1,NULL),(11178,'category',59,'furniture/tables.html','catalog/category/view/id/59',0,1,NULL,1,NULL),(11181,'category',60,'outdoor/bicycle.html','catalog/category/view/id/60',0,1,NULL,1,NULL),(11184,'category',61,'outdoor/cars.html','catalog/category/view/id/61',0,1,NULL,1,NULL),(11187,'category',62,'outdoor/sports.html','catalog/category/view/id/62',0,1,NULL,1,NULL),(11190,'category',63,'boys/outdoors.html','catalog/category/view/id/63',0,1,NULL,1,NULL),(11193,'category',64,'women/outdoors.html','catalog/category/view/id/64',0,1,NULL,1,NULL),(11196,'category',65,'educational/books.html','catalog/category/view/id/65',0,1,NULL,1,NULL),(11199,'category',66,'educational/ipads-and-learning.html','catalog/category/view/id/66',0,1,NULL,1,NULL),(11202,'category',67,'educational/games.html','catalog/category/view/id/67',0,1,NULL,1,NULL),(11205,'category',68,'boys/educational.html','catalog/category/view/id/68',0,1,NULL,1,NULL),(11208,'category',69,'boys/electronics.html','catalog/category/view/id/69',0,1,NULL,1,NULL),(11211,'category',70,'boys/games.html','catalog/category/view/id/70',0,1,NULL,1,NULL),(11214,'category',71,'boys/sports.html','catalog/category/view/id/71',0,1,NULL,1,NULL),(11217,'category',72,'boys/ride-on-and-more.html','catalog/category/view/id/72',0,1,NULL,1,NULL),(11220,'category',73,'boys/toy-vehicle.html','catalog/category/view/id/73',0,1,NULL,1,NULL),(11223,'category',74,'boys/action-figure.html','catalog/category/view/id/74',0,1,NULL,1,NULL),(11226,'category',75,'women/sports.html','catalog/category/view/id/75',0,1,NULL,1,NULL),(11229,'category',76,'women/games.html','catalog/category/view/id/76',0,1,NULL,1,NULL),(11232,'category',77,'women/ride-on-and-more.html','catalog/category/view/id/77',0,1,NULL,1,NULL),(11235,'category',78,'educational/writing-tables.html','catalog/category/view/id/78',0,1,NULL,1,NULL),(12219,'cms-page',26,'about-us-old1','cms/page/view/page_id/26',0,1,NULL,1,NULL),(12220,'cms-page',5,'about-us','cms/page/view/page_id/5',0,1,NULL,1,NULL),(12470,'faq-faq',1,'faqs.html','faq/faq/view',0,1,NULL,1,NULL),(12471,'faq-category',1,'faq/category/common.html','faq/category/view/category_id/1',0,1,NULL,1,NULL),(12472,'faq-question',1,'faq/test-question.html','faq/question/view/faq_id/1',0,1,NULL,1,NULL),(12473,'cms-page',4,'privacy-policy','cms/page/view/page_id/4',0,1,NULL,1,NULL),(12475,'cms-page',29,'wk-faq','cms/page/view/page_id/29',0,1,NULL,1,NULL),(12476,'',0,'support/test','support/topic/view/id/1',0,1,NULL,0,NULL),(12477,'',0,'support/test12','support/qa/view/id/1',0,1,NULL,0,NULL),(12571,'category',79,'best-seller.html','catalog/category/view/id/79',0,1,NULL,1,NULL),(12573,'category',81,'best-seller-products.html','catalog/category/view/id/81',0,1,NULL,1,NULL),(12582,'category',82,'traning-category.html','catalog/category/view/id/82',0,1,NULL,1,NULL),(13137,'product',599,'black-and-silver-suit.html','catalog/product/view/id/599',0,1,NULL,1,NULL),(13138,'product',599,'outdoor/black-and-silver-suit.html','catalog/product/view/id/599/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13139,'product',599,'best-seller-products/black-and-silver-suit.html','catalog/product/view/id/599/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13140,'product',599,'/black-and-silver-suit.html','catalog/product/view/id/599/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13237,'category',38,'two-pieces.html','catalog/category/view/id/38',0,1,NULL,1,NULL),(13238,'category',38,'educational.html','two-pieces.html',301,1,NULL,0,NULL),(13239,'category',38,'shop-by-age.html','two-pieces.html',301,1,NULL,0,'[]'),(13240,'category',38,'what-is-new.html','two-pieces.html',301,1,NULL,0,'[]'),(13241,'product',105,'light-beige-suit-with-ruffle-details.html','catalog/product/view/id/105',0,1,NULL,1,NULL),(13242,'product',105,'two-pieces/light-beige-suit-with-ruffle-details.html','catalog/product/view/id/105/category/38',0,1,NULL,1,'{\"category_id\":\"38\"}'),(13243,'product',105,'educational/light-beige-suit-with-ruffle-details.html','two-pieces/light-beige-suit-with-ruffle-details.html',301,1,NULL,0,'{\"category_id\":\"38\"}'),(13244,'product',105,'/light-beige-suit-with-ruffle-details.html','catalog/product/view/id/105/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13245,'product',173,'nude-training-suit.html','catalog/product/view/id/173',0,1,NULL,1,NULL),(13246,'product',173,'two-pieces/nude-training-suit.html','catalog/product/view/id/173/category/38',0,1,NULL,1,'{\"category_id\":\"38\"}'),(13247,'product',173,'educational/nude-training-suit.html','two-pieces/nude-training-suit.html',301,1,NULL,0,'{\"category_id\":\"38\"}'),(13248,'product',173,'/nude-training-suit.html','catalog/product/view/id/173/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13249,'product',222,'sky-blue-set.html','catalog/product/view/id/222',0,1,NULL,1,NULL),(13250,'product',222,'two-pieces/sky-blue-set.html','catalog/product/view/id/222/category/38',0,1,NULL,1,'{\"category_id\":\"38\"}'),(13251,'product',222,'educational/sky-blue-set.html','two-pieces/sky-blue-set.html',301,1,NULL,0,'{\"category_id\":\"38\"}'),(13252,'product',222,'/sky-blue-set.html','catalog/product/view/id/222/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13253,'product',271,'suit-with-ruffle-details.html','catalog/product/view/id/271',0,1,NULL,1,NULL),(13254,'product',271,'two-pieces/suit-with-ruffle-details.html','catalog/product/view/id/271/category/38',0,1,NULL,1,'{\"category_id\":\"38\"}'),(13255,'product',271,'educational/suit-with-ruffle-details.html','two-pieces/suit-with-ruffle-details.html',301,1,NULL,0,'{\"category_id\":\"38\"}'),(13256,'product',271,'/suit-with-ruffle-details.html','catalog/product/view/id/271/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13257,'product',320,'training-suit-with-shoulder-details.html','catalog/product/view/id/320',0,1,NULL,1,NULL),(13258,'product',320,'two-pieces/training-suit-with-shoulder-details.html','catalog/product/view/id/320/category/38',0,1,NULL,1,'{\"category_id\":\"38\"}'),(13259,'product',320,'best-seller-products/training-suit-with-shoulder-details.html','catalog/product/view/id/320/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13260,'product',320,'educational/training-suit-with-shoulder-details.html','two-pieces/training-suit-with-shoulder-details.html',301,1,NULL,0,'{\"category_id\":\"38\"}'),(13261,'product',320,'/training-suit-with-shoulder-details.html','catalog/product/view/id/320/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13262,'product',369,'overlapping-colors-training-suit.html','catalog/product/view/id/369',0,1,NULL,1,NULL),(13263,'product',369,'two-pieces/overlapping-colors-training-suit.html','catalog/product/view/id/369/category/38',0,1,NULL,1,'{\"category_id\":\"38\"}'),(13264,'product',369,'best-seller-products/overlapping-colors-training-suit.html','catalog/product/view/id/369/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13265,'product',369,'educational/overlapping-colors-training-suit.html','two-pieces/overlapping-colors-training-suit.html',301,1,NULL,0,'{\"category_id\":\"38\"}'),(13266,'product',369,'/overlapping-colors-training-suit.html','catalog/product/view/id/369/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13272,'category',11,'new-collection.html','catalog/category/view/id/11',0,1,NULL,1,NULL),(13273,'category',11,'boys.html','new-collection.html',301,1,NULL,0,NULL),(13274,'category',11,'men.html','new-collection.html',301,1,NULL,0,'[]'),(13327,'product',1669,'denim-colour-block-design-training-suit.html','catalog/product/view/id/1669',0,1,NULL,1,NULL),(13328,'product',1669,'new-collection/denim-colour-block-design-training-suit.html','catalog/product/view/id/1669/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13329,'product',1669,'two-pieces/denim-colour-block-design-training-suit.html','catalog/product/view/id/1669/category/38',0,1,NULL,1,'{\"category_id\":\"38\"}'),(13330,'product',1669,'boys/denim-colour-block-design-training-suit.html','new-collection/denim-colour-block-design-training-suit.html',301,1,NULL,0,'{\"category_id\":\"11\"}'),(13331,'product',1669,'educational/denim-colour-block-design-training-suit.html','two-pieces/denim-colour-block-design-training-suit.html',301,1,NULL,0,'{\"category_id\":\"38\"}'),(13332,'product',1669,'/denim-colour-block-design-training-suit.html','catalog/product/view/id/1669/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13339,'category',20,'top.html','catalog/category/view/id/20',0,1,NULL,1,NULL),(13340,'category',20,'women.html','top.html',301,1,NULL,0,NULL),(13341,'product',7,'black-loose-top-with-baby-pink.html','catalog/product/view/id/7',0,1,NULL,1,NULL),(13342,'product',7,'new-collection/black-loose-top-with-baby-pink.html','catalog/product/view/id/7/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13343,'product',7,'best-seller-products/black-loose-top-with-baby-pink.html','catalog/product/view/id/7/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13344,'product',7,'top/black-loose-top-with-baby-pink.html','catalog/product/view/id/7/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13345,'product',7,'women/black-loose-top-with-baby-pink.html','top/black-loose-top-with-baby-pink.html',301,1,NULL,0,'{\"category_id\":\"20\"}'),(13346,'product',7,'boys/black-loose-top-with-baby-pink.html','new-collection/black-loose-top-with-baby-pink.html',301,1,NULL,0,'{\"category_id\":\"11\"}'),(13347,'product',7,'/black-loose-top-with-baby-pink.html','catalog/product/view/id/7/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13348,'product',14,'sky-blue-top.html','catalog/product/view/id/14',0,1,NULL,1,NULL),(13349,'product',14,'top/sky-blue-top.html','catalog/product/view/id/14/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13350,'product',14,'women/sky-blue-top.html','top/sky-blue-top.html',301,1,NULL,0,'{\"category_id\":\"20\"}'),(13351,'product',14,'/sky-blue-top.html','catalog/product/view/id/14/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13352,'product',21,'olive-top.html','catalog/product/view/id/21',0,1,NULL,1,NULL),(13353,'product',21,'top/olive-top.html','catalog/product/view/id/21/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13354,'product',21,'best-seller-products/olive-top.html','catalog/product/view/id/21/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13355,'product',21,'women/olive-top.html','top/olive-top.html',301,1,NULL,0,'{\"category_id\":\"20\"}'),(13356,'product',21,'/olive-top.html','catalog/product/view/id/21/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13357,'product',28,'burgundy-striped-design-top-with-front-pockets.html','catalog/product/view/id/28',0,1,NULL,1,NULL),(13358,'product',28,'new-collection/burgundy-striped-design-top-with-front-pockets.html','catalog/product/view/id/28/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13359,'product',28,'top/burgundy-striped-design-top-with-front-pockets.html','catalog/product/view/id/28/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13360,'product',28,'women/burgundy-striped-design-top-with-front-pockets.html','top/burgundy-striped-design-top-with-front-pockets.html',301,1,NULL,0,'{\"category_id\":\"20\"}'),(13361,'product',28,'boys/burgundy-striped-design-top-with-front-pockets.html','new-collection/burgundy-striped-design-top-with-front-pockets.html',301,1,NULL,0,'{\"category_id\":\"11\"}'),(13362,'product',28,'/burgundy-striped-design-top-with-front-pockets.html','catalog/product/view/id/28/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13363,'product',35,'layered-black-top.html','catalog/product/view/id/35',0,1,NULL,1,NULL),(13364,'product',35,'top/layered-black-top.html','catalog/product/view/id/35/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13365,'product',35,'best-seller-products/layered-black-top.html','catalog/product/view/id/35/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13366,'product',35,'women/layered-black-top.html','top/layered-black-top.html',301,1,NULL,0,'{\"category_id\":\"20\"}'),(13367,'product',35,'/layered-black-top.html','catalog/product/view/id/35/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13368,'product',42,'scarfs-top.html','catalog/product/view/id/42',0,1,NULL,1,NULL),(13369,'product',42,'top/scarfs-top.html','catalog/product/view/id/42/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13370,'product',42,'best-seller-products/scarfs-top.html','catalog/product/view/id/42/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13371,'product',42,'women/scarfs-top.html','top/scarfs-top.html',301,1,NULL,0,'{\"category_id\":\"20\"}'),(13372,'product',42,'/scarfs-top.html','catalog/product/view/id/42/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13373,'product',49,'beige-top-with-striped.html','catalog/product/view/id/49',0,1,NULL,1,NULL),(13374,'product',49,'top/beige-top-with-striped.html','catalog/product/view/id/49/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13375,'product',49,'women/beige-top-with-striped.html','top/beige-top-with-striped.html',301,1,NULL,0,'{\"category_id\":\"20\"}'),(13376,'product',49,'/beige-top-with-striped.html','catalog/product/view/id/49/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13377,'product',56,'white-top-with-mix-colors.html','catalog/product/view/id/56',0,1,NULL,1,NULL),(13378,'product',56,'top/white-top-with-mix-colors.html','catalog/product/view/id/56/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13379,'product',56,'best-seller-products/white-top-with-mix-colors.html','catalog/product/view/id/56/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13380,'product',56,'women/white-top-with-mix-colors.html','top/white-top-with-mix-colors.html',301,1,NULL,0,'{\"category_id\":\"20\"}'),(13381,'product',56,'/white-top-with-mix-colors.html','catalog/product/view/id/56/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13382,'product',124,'ruffle-front-top.html','catalog/product/view/id/124',0,1,NULL,1,NULL),(13383,'product',124,'top/ruffle-front-top.html','catalog/product/view/id/124/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13384,'product',124,'women/ruffle-front-top.html','top/ruffle-front-top.html',301,1,NULL,0,'{\"category_id\":\"20\"}'),(13385,'product',124,'/ruffle-front-top.html','catalog/product/view/id/124/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13386,'product',1579,'caramel-top-with-black.html','catalog/product/view/id/1579',0,1,NULL,1,NULL),(13387,'product',1579,'new-collection/caramel-top-with-black.html','catalog/product/view/id/1579/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13388,'product',1579,'top/caramel-top-with-black.html','catalog/product/view/id/1579/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13389,'product',1579,'women/caramel-top-with-black.html','top/caramel-top-with-black.html',301,1,NULL,0,'{\"category_id\":\"20\"}'),(13390,'product',1579,'boys/caramel-top-with-black.html','new-collection/caramel-top-with-black.html',301,1,NULL,0,'{\"category_id\":\"11\"}'),(13391,'product',1579,'/caramel-top-with-black.html','catalog/product/view/id/1579/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13392,'product',1606,'tiffany-top-with-sky-blue.html','catalog/product/view/id/1606',0,1,NULL,1,NULL),(13393,'product',1606,'new-collection/tiffany-top-with-sky-blue.html','catalog/product/view/id/1606/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13394,'product',1606,'top/tiffany-top-with-sky-blue.html','catalog/product/view/id/1606/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13395,'product',1606,'women/tiffany-top-with-sky-blue.html','top/tiffany-top-with-sky-blue.html',301,1,NULL,0,'{\"category_id\":\"20\"}'),(13396,'product',1606,'boys/tiffany-top-with-sky-blue.html','new-collection/tiffany-top-with-sky-blue.html',301,1,NULL,0,'{\"category_id\":\"11\"}'),(13397,'product',1606,'/tiffany-top-with-sky-blue.html','catalog/product/view/id/1606/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13398,'product',1613,'black-top-with-white-stripes-design.html','catalog/product/view/id/1613',0,1,NULL,1,NULL),(13399,'product',1613,'new-collection/black-top-with-white-stripes-design.html','catalog/product/view/id/1613/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13400,'product',1613,'top/black-top-with-white-stripes-design.html','catalog/product/view/id/1613/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13401,'product',1613,'women/black-top-with-white-stripes-design.html','top/black-top-with-white-stripes-design.html',301,1,NULL,0,'{\"category_id\":\"20\"}'),(13402,'product',1613,'boys/black-top-with-white-stripes-design.html','new-collection/black-top-with-white-stripes-design.html',301,1,NULL,0,'{\"category_id\":\"11\"}'),(13403,'product',1613,'/black-top-with-white-stripes-design.html','catalog/product/view/id/1613/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13404,'product',452,'black-suit-with-gold-deatails.html','catalog/product/view/id/452',0,1,NULL,1,NULL),(13405,'product',452,'ready-to-wear/black-suit-with-gold-deatails.html','catalog/product/view/id/452/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13406,'product',452,'outdoor/black-suit-with-gold-deatails.html','ready-to-wear/black-suit-with-gold-deatails.html',301,1,NULL,0,'{\"category_id\":\"3\"}'),(13407,'product',452,'/black-suit-with-gold-deatails.html','catalog/product/view/id/452/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13408,'product',501,'grey-suit-with-pleat-details.html','catalog/product/view/id/501',0,1,NULL,1,NULL),(13409,'product',501,'ready-to-wear/grey-suit-with-pleat-details.html','catalog/product/view/id/501/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13410,'product',501,'outdoor/grey-suit-with-pleat-details.html','ready-to-wear/grey-suit-with-pleat-details.html',301,1,NULL,0,'{\"category_id\":\"3\"}'),(13411,'product',501,'/grey-suit-with-pleat-details.html','catalog/product/view/id/501/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13412,'product',550,'dark-blue-suit.html','catalog/product/view/id/550',0,1,NULL,1,NULL),(13413,'product',550,'ready-to-wear/dark-blue-suit.html','catalog/product/view/id/550/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13414,'product',550,'outdoor/dark-blue-suit.html','ready-to-wear/dark-blue-suit.html',301,1,NULL,0,'{\"category_id\":\"3\"}'),(13415,'product',550,'/dark-blue-suit.html','catalog/product/view/id/550/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13416,'product',648,'black-suit-with-silver.html','catalog/product/view/id/648',0,1,NULL,1,NULL),(13417,'product',648,'ready-to-wear/black-suit-with-silver.html','catalog/product/view/id/648/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13418,'product',648,'best-seller-products/black-suit-with-silver.html','catalog/product/view/id/648/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13419,'product',648,'outdoor/black-suit-with-silver.html','ready-to-wear/black-suit-with-silver.html',301,1,NULL,0,'{\"category_id\":\"3\"}'),(13420,'product',648,'/black-suit-with-silver.html','catalog/product/view/id/648/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13421,'product',697,'sky-blue-suit-with-shoulder-details.html','catalog/product/view/id/697',0,1,NULL,1,NULL),(13422,'product',697,'ready-to-wear/sky-blue-suit-with-shoulder-details.html','catalog/product/view/id/697/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13423,'product',697,'best-seller-products/sky-blue-suit-with-shoulder-details.html','catalog/product/view/id/697/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13424,'product',697,'outdoor/sky-blue-suit-with-shoulder-details.html','ready-to-wear/sky-blue-suit-with-shoulder-details.html',301,1,NULL,0,'{\"category_id\":\"3\"}'),(13425,'product',697,'/sky-blue-suit-with-shoulder-details.html','catalog/product/view/id/697/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13426,'product',758,'beige-suit-with-ruffle.html','catalog/product/view/id/758',0,1,NULL,1,NULL),(13427,'product',758,'ready-to-wear/beige-suit-with-ruffle.html','catalog/product/view/id/758/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13428,'product',758,'best-seller-products/beige-suit-with-ruffle.html','catalog/product/view/id/758/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13429,'product',758,'outdoor/beige-suit-with-ruffle.html','ready-to-wear/beige-suit-with-ruffle.html',301,1,NULL,0,'{\"category_id\":\"3\"}'),(13430,'product',758,'/beige-suit-with-ruffle.html','catalog/product/view/id/758/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13431,'product',807,'black-suit-with-white.html','catalog/product/view/id/807',0,1,NULL,1,NULL),(13432,'product',807,'ready-to-wear/black-suit-with-white.html','catalog/product/view/id/807/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13433,'product',807,'outdoor/black-suit-with-white.html','ready-to-wear/black-suit-with-white.html',301,1,NULL,0,'{\"category_id\":\"3\"}'),(13434,'product',807,'/black-suit-with-white.html','catalog/product/view/id/807/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13435,'product',1297,'mustard-suit-with-seauin-details.html','catalog/product/view/id/1297',0,1,NULL,1,NULL),(13436,'product',1297,'ready-to-wear/mustard-suit-with-seauin-details.html','catalog/product/view/id/1297/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13437,'product',1297,'outdoor/mustard-suit-with-seauin-details.html','ready-to-wear/mustard-suit-with-seauin-details.html',301,1,NULL,0,'{\"category_id\":\"3\"}'),(13438,'product',1297,'/mustard-suit-with-seauin-details.html','catalog/product/view/id/1297/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13451,'category',9,'trousers.html','catalog/category/view/id/9',0,1,NULL,1,NULL),(13452,'category',9,'training.html','trousers.html',301,1,NULL,0,NULL),(13453,'product',856,'palazzo-trousers.html','catalog/product/view/id/856',0,1,NULL,1,NULL),(13454,'product',856,'trousers/palazzo-trousers.html','catalog/product/view/id/856/category/9',0,1,NULL,1,'{\"category_id\":\"9\"}'),(13455,'product',856,'training/palazzo-trousers.html','trousers/palazzo-trousers.html',301,1,NULL,0,'{\"category_id\":\"9\"}'),(13456,'product',856,'/palazzo-trousers.html','catalog/product/view/id/856/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13457,'product',905,'black-wide-leg-trousers.html','catalog/product/view/id/905',0,1,NULL,1,NULL),(13458,'product',905,'trousers/black-wide-leg-trousers.html','catalog/product/view/id/905/category/9',0,1,NULL,1,'{\"category_id\":\"9\"}'),(13459,'product',905,'best-seller-products/black-wide-leg-trousers.html','catalog/product/view/id/905/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13460,'product',905,'training/black-wide-leg-trousers.html','trousers/black-wide-leg-trousers.html',301,1,NULL,0,'{\"category_id\":\"9\"}'),(13461,'product',905,'/black-wide-leg-trousers.html','catalog/product/view/id/905/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13462,'product',954,'grey-wide-trousers.html','catalog/product/view/id/954',0,1,NULL,1,NULL),(13463,'product',954,'trousers/grey-wide-trousers.html','catalog/product/view/id/954/category/9',0,1,NULL,1,'{\"category_id\":\"9\"}'),(13464,'product',954,'training/grey-wide-trousers.html','trousers/grey-wide-trousers.html',301,1,NULL,0,'{\"category_id\":\"9\"}'),(13465,'product',954,'/grey-wide-trousers.html','catalog/product/view/id/954/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13466,'product',1003,'black-silm-trousers.html','catalog/product/view/id/1003',0,1,NULL,1,NULL),(13467,'product',1003,'trousers/black-silm-trousers.html','catalog/product/view/id/1003/category/9',0,1,NULL,1,'{\"category_id\":\"9\"}'),(13468,'product',1003,'training/black-silm-trousers.html','trousers/black-silm-trousers.html',301,1,NULL,0,'{\"category_id\":\"9\"}'),(13469,'product',1003,'/black-silm-trousers.html','catalog/product/view/id/1003/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13470,'product',1052,'nude-wide-leg-trousers.html','catalog/product/view/id/1052',0,1,NULL,1,NULL),(13471,'product',1052,'trousers/nude-wide-leg-trousers.html','catalog/product/view/id/1052/category/9',0,1,NULL,1,'{\"category_id\":\"9\"}'),(13472,'product',1052,'training/nude-wide-leg-trousers.html','trousers/nude-wide-leg-trousers.html',301,1,NULL,0,'{\"category_id\":\"9\"}'),(13473,'product',1052,'/nude-wide-leg-trousers.html','catalog/product/view/id/1052/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13474,'product',1101,'dark-blue-chanton-wide-leg-trousers.html','catalog/product/view/id/1101',0,1,NULL,1,NULL),(13475,'product',1101,'trousers/dark-blue-chanton-wide-leg-trousers.html','catalog/product/view/id/1101/category/9',0,1,NULL,1,'{\"category_id\":\"9\"}'),(13476,'product',1101,'training/dark-blue-chanton-wide-leg-trousers.html','trousers/dark-blue-chanton-wide-leg-trousers.html',301,1,NULL,0,'{\"category_id\":\"9\"}'),(13477,'product',1101,'/dark-blue-chanton-wide-leg-trousers.html','catalog/product/view/id/1101/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13478,'product',1150,'gray-shanton-wide-leg-trousers.html','catalog/product/view/id/1150',0,1,NULL,1,NULL),(13479,'product',1150,'trousers/gray-shanton-wide-leg-trousers.html','catalog/product/view/id/1150/category/9',0,1,NULL,1,'{\"category_id\":\"9\"}'),(13480,'product',1150,'training/gray-shanton-wide-leg-trousers.html','trousers/gray-shanton-wide-leg-trousers.html',301,1,NULL,0,'{\"category_id\":\"9\"}'),(13481,'product',1150,'/gray-shanton-wide-leg-trousers.html','catalog/product/view/id/1150/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13482,'product',1199,'black-chanton-wide-leg-trousers.html','catalog/product/view/id/1199',0,1,NULL,1,NULL),(13483,'product',1199,'trousers/black-chanton-wide-leg-trousers.html','catalog/product/view/id/1199/category/9',0,1,NULL,1,'{\"category_id\":\"9\"}'),(13484,'product',1199,'training/black-chanton-wide-leg-trousers.html','trousers/black-chanton-wide-leg-trousers.html',301,1,NULL,0,'{\"category_id\":\"9\"}'),(13485,'product',1199,'/black-chanton-wide-leg-trousers.html','catalog/product/view/id/1199/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13486,'product',1248,'crepe-wide-leg-trousers.html','catalog/product/view/id/1248',0,1,NULL,1,NULL),(13487,'product',1248,'trousers/crepe-wide-leg-trousers.html','catalog/product/view/id/1248/category/9',0,1,NULL,1,'{\"category_id\":\"9\"}'),(13488,'product',1248,'training/crepe-wide-leg-trousers.html','trousers/crepe-wide-leg-trousers.html',301,1,NULL,0,'{\"category_id\":\"9\"}'),(13489,'product',1248,'/crepe-wide-leg-trousers.html','catalog/product/view/id/1248/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13490,'product',1346,'dark-blue-crepe-wide-leg-trousers.html','catalog/product/view/id/1346',0,1,NULL,1,NULL),(13491,'product',1346,'trousers/dark-blue-crepe-wide-leg-trousers.html','catalog/product/view/id/1346/category/9',0,1,NULL,1,'{\"category_id\":\"9\"}'),(13492,'product',1346,'training/dark-blue-crepe-wide-leg-trousers.html','trousers/dark-blue-crepe-wide-leg-trousers.html',301,1,NULL,0,'{\"category_id\":\"9\"}'),(13493,'product',1346,'/dark-blue-crepe-wide-leg-trousers.html','catalog/product/view/id/1346/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13494,'category',54,'jacket.html','catalog/category/view/id/54',0,1,NULL,1,NULL),(13495,'category',54,'gifts.html','jacket.html',301,1,NULL,0,NULL),(13496,'product',376,'caramel-denim-jacket.html','catalog/product/view/id/376',0,1,NULL,1,NULL),(13497,'product',376,'jacket/caramel-denim-jacket.html','catalog/product/view/id/376/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13498,'product',376,'gifts/caramel-denim-jacket.html','jacket/caramel-denim-jacket.html',301,1,NULL,0,'{\"category_id\":\"54\"}'),(13499,'product',376,'/caramel-denim-jacket.html','catalog/product/view/id/376/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13500,'product',383,'color-block-oversized.html','catalog/product/view/id/383',0,1,NULL,1,NULL),(13501,'product',383,'jacket/color-block-oversized.html','catalog/product/view/id/383/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13502,'product',383,'best-seller-products/color-block-oversized.html','catalog/product/view/id/383/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13503,'product',383,'gifts/color-block-oversized.html','jacket/color-block-oversized.html',301,1,NULL,0,'{\"category_id\":\"54\"}'),(13504,'product',383,'/color-block-oversized.html','catalog/product/view/id/383/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13505,'product',396,'grey-shanton-jacket.html','catalog/product/view/id/396',0,1,NULL,1,NULL),(13506,'product',396,'jacket/grey-shanton-jacket.html','catalog/product/view/id/396/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13507,'product',396,'best-seller-products/grey-shanton-jacket.html','catalog/product/view/id/396/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13508,'product',396,'gifts/grey-shanton-jacket.html','jacket/grey-shanton-jacket.html',301,1,NULL,0,'{\"category_id\":\"54\"}'),(13509,'product',396,'/grey-shanton-jacket.html','catalog/product/view/id/396/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13510,'product',403,'oversized-denim-jacket-with-sky-blue.html','catalog/product/view/id/403',0,1,NULL,1,NULL),(13511,'product',403,'new-collection/oversized-denim-jacket-with-sky-blue.html','catalog/product/view/id/403/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13512,'product',403,'jacket/oversized-denim-jacket-with-sky-blue.html','catalog/product/view/id/403/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13513,'product',403,'gifts/oversized-denim-jacket-with-sky-blue.html','jacket/oversized-denim-jacket-with-sky-blue.html',301,1,NULL,0,'{\"category_id\":\"54\"}'),(13514,'product',403,'boys/oversized-denim-jacket-with-sky-blue.html','new-collection/oversized-denim-jacket-with-sky-blue.html',301,1,NULL,0,'{\"category_id\":\"11\"}'),(13515,'product',403,'/oversized-denim-jacket-with-sky-blue.html','catalog/product/view/id/403/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13516,'product',1572,'oversized-denim-jacket-with-white.html','catalog/product/view/id/1572',0,1,NULL,1,NULL),(13517,'product',1572,'new-collection/oversized-denim-jacket-with-white.html','catalog/product/view/id/1572/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13518,'product',1572,'jacket/oversized-denim-jacket-with-white.html','catalog/product/view/id/1572/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13519,'product',1572,'gifts/oversized-denim-jacket-with-white.html','jacket/oversized-denim-jacket-with-white.html',301,1,NULL,0,'{\"category_id\":\"54\"}'),(13520,'product',1572,'boys/oversized-denim-jacket-with-white.html','new-collection/oversized-denim-jacket-with-white.html',301,1,NULL,0,'{\"category_id\":\"11\"}'),(13521,'product',1572,'/oversized-denim-jacket-with-white.html','catalog/product/view/id/1572/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13522,'product',1592,'layered-white-jacket.html','catalog/product/view/id/1592',0,1,NULL,1,NULL),(13523,'product',1592,'new-collection/layered-white-jacket.html','catalog/product/view/id/1592/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13524,'product',1592,'jacket/layered-white-jacket.html','catalog/product/view/id/1592/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13525,'product',1592,'gifts/layered-white-jacket.html','jacket/layered-white-jacket.html',301,1,NULL,0,'{\"category_id\":\"54\"}'),(13526,'product',1592,'boys/layered-white-jacket.html','new-collection/layered-white-jacket.html',301,1,NULL,0,'{\"category_id\":\"11\"}'),(13527,'product',1592,'/layered-white-jacket.html','catalog/product/view/id/1592/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13528,'product',1599,'denim-jaket-with-max-colors.html','catalog/product/view/id/1599',0,1,NULL,1,NULL),(13529,'product',1599,'new-collection/denim-jaket-with-max-colors.html','catalog/product/view/id/1599/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13530,'product',1599,'jacket/denim-jaket-with-max-colors.html','catalog/product/view/id/1599/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13531,'product',1599,'gifts/denim-jaket-with-max-colors.html','jacket/denim-jaket-with-max-colors.html',301,1,NULL,0,'{\"category_id\":\"54\"}'),(13532,'product',1599,'boys/denim-jaket-with-max-colors.html','new-collection/denim-jaket-with-max-colors.html',301,1,NULL,0,'{\"category_id\":\"11\"}'),(13533,'product',1599,'/denim-jaket-with-max-colors.html','catalog/product/view/id/1599/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13534,'product',1620,'light-gray-jacket-with-max-colors-design.html','catalog/product/view/id/1620',0,1,NULL,1,NULL),(13535,'product',1620,'new-collection/light-gray-jacket-with-max-colors-design.html','catalog/product/view/id/1620/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13536,'product',1620,'jacket/light-gray-jacket-with-max-colors-design.html','catalog/product/view/id/1620/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13537,'product',1620,'best-seller-products/light-gray-jacket-with-max-colors-design.html','catalog/product/view/id/1620/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13538,'product',1620,'gifts/light-gray-jacket-with-max-colors-design.html','jacket/light-gray-jacket-with-max-colors-design.html',301,1,NULL,0,'{\"category_id\":\"54\"}'),(13539,'product',1620,'boys/light-gray-jacket-with-max-colors-design.html','new-collection/light-gray-jacket-with-max-colors-design.html',301,1,NULL,0,'{\"category_id\":\"11\"}'),(13540,'product',1620,'/light-gray-jacket-with-max-colors-design.html','catalog/product/view/id/1620/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13541,'product',1676,'volume-beige-jacket.html','catalog/product/view/id/1676',0,1,NULL,1,NULL),(13542,'product',1676,'new-collection/volume-beige-jacket.html','catalog/product/view/id/1676/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13543,'product',1676,'jacket/volume-beige-jacket.html','catalog/product/view/id/1676/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13544,'product',1676,'best-seller-products/volume-beige-jacket.html','catalog/product/view/id/1676/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13545,'product',1676,'gifts/volume-beige-jacket.html','jacket/volume-beige-jacket.html',301,1,NULL,0,'{\"category_id\":\"54\"}'),(13546,'product',1676,'boys/volume-beige-jacket.html','new-collection/volume-beige-jacket.html',301,1,NULL,0,'{\"category_id\":\"11\"}'),(13547,'product',1676,'/volume-beige-jacket.html','catalog/product/view/id/1676/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13556,'category',7,'shop-by-age-category.html','catalog/category/view/id/7',0,1,NULL,1,NULL),(13557,'category',7,'collections.html','shop-by-age-category.html',301,1,NULL,0,'[]'),(13558,'product',1419,'beige-cotton-kaftan.html','catalog/product/view/id/1419',0,1,NULL,1,NULL),(13559,'product',1419,'shop-by-age-category/beige-cotton-kaftan.html','catalog/product/view/id/1419/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13560,'product',1419,'dresses/beige-cotton-kaftan.html','shop-by-age-category/beige-cotton-kaftan.html',301,1,NULL,0,'{\"category_id\":\"7\"}'),(13561,'product',1419,'/beige-cotton-kaftan.html','catalog/product/view/id/1419/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13562,'product',1492,'tiffany-kaftan-with-beige.html','catalog/product/view/id/1492',0,1,NULL,1,NULL),(13563,'product',1492,'shop-by-age-category/tiffany-kaftan-with-beige.html','catalog/product/view/id/1492/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13564,'product',1492,'dresses/tiffany-kaftan-with-beige.html','shop-by-age-category/tiffany-kaftan-with-beige.html',301,1,NULL,0,'{\"category_id\":\"7\"}'),(13565,'product',1492,'/tiffany-kaftan-with-beige.html','catalog/product/view/id/1492/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13570,'product',1715,'dress-with-lace.html','catalog/product/view/id/1715',0,1,NULL,1,NULL),(13571,'product',1715,'shop-by-age-category/dress-with-lace.html','catalog/product/view/id/1715/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13572,'product',1715,'new-collection/dress-with-lace.html','catalog/product/view/id/1715/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13573,'product',1715,'sale/dress-with-lace.html','catalog/product/view/id/1715/category/37',0,1,NULL,1,'{\"category_id\":\"37\"}'),(13574,'product',1715,'dresses/dress-with-lace.html','shop-by-age-category/dress-with-lace.html',301,1,NULL,0,'{\"category_id\":\"7\"}'),(13575,'product',1715,'/dress-with-lace.html','catalog/product/view/id/1715/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13576,'product',1865,'organza-kaftan-with-lace.html','catalog/product/view/id/1865',0,1,NULL,1,NULL),(13577,'product',1865,'shop-by-age-category/organza-kaftan-with-lace.html','catalog/product/view/id/1865/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13578,'product',1865,'dresses/organza-kaftan-with-lace.html','shop-by-age-category/organza-kaftan-with-lace.html',301,1,NULL,0,'{\"category_id\":\"7\"}'),(13579,'product',1865,'/organza-kaftan-with-lace.html','catalog/product/view/id/1865/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13580,'product',1938,'sky-blue-cotton-kaftan.html','catalog/product/view/id/1938',0,1,NULL,1,NULL),(13581,'product',1938,'shop-by-age-category/sky-blue-cotton-kaftan.html','catalog/product/view/id/1938/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13582,'product',1938,'/sky-blue-cotton-kaftan.html','catalog/product/view/id/1938/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13583,'product',2011,'dark-beige-kaftan-with-lace.html','catalog/product/view/id/2011',0,1,NULL,1,NULL),(13584,'product',2011,'shop-by-age-category/dark-beige-kaftan-with-lace.html','catalog/product/view/id/2011/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13585,'product',2011,'/dark-beige-kaftan-with-lace.html','catalog/product/view/id/2011/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13586,'product',2084,'half-beige-half-white-kaftan.html','catalog/product/view/id/2084',0,1,NULL,1,NULL),(13587,'product',2084,'shop-by-age-category/half-beige-half-white-kaftan.html','catalog/product/view/id/2084/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13588,'product',2084,'/half-beige-half-white-kaftan.html','catalog/product/view/id/2084/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13589,'product',2157,'wrap-ruffle-dress-in-dark-beige.html','catalog/product/view/id/2157',0,1,NULL,1,NULL),(13590,'product',2157,'ready-to-wear/wrap-ruffle-dress-in-dark-beige.html','catalog/product/view/id/2157/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13591,'product',2157,'new-collection/wrap-ruffle-dress-in-dark-beige.html','catalog/product/view/id/2157/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13592,'product',2157,'/wrap-ruffle-dress-in-dark-beige.html','catalog/product/view/id/2157/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13598,'product',2230,'test-8.html','catalog/product/view/id/2230',0,1,NULL,1,NULL),(13599,'product',2230,'ready-to-wear/test-8.html','catalog/product/view/id/2230/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13600,'product',2230,'warp-ruffle-dress-in-dark-beige.html','test-8.html',301,1,NULL,0,'[]'),(13601,'product',2230,'/test-8.html','catalog/product/view/id/2230/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13602,'product',2423,'wrap-dress-in-dark-beige.html','catalog/product/view/id/2423',0,1,NULL,1,NULL),(13603,'product',2423,'ready-to-wear/wrap-dress-in-dark-beige.html','catalog/product/view/id/2423/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13604,'product',2423,'new-collection/wrap-dress-in-dark-beige.html','catalog/product/view/id/2423/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13605,'product',2423,'/wrap-dress-in-dark-beige.html','catalog/product/view/id/2423/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13609,'product',2641,'dress-in-black.html','catalog/product/view/id/2641',0,1,NULL,1,NULL),(13610,'product',2641,'ready-to-wear/dress-in-black.html','catalog/product/view/id/2641/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13611,'product',2641,'/dress-in-black.html','catalog/product/view/id/2641/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13612,'product',2696,'test-product-110.html','catalog/product/view/id/2696',0,1,NULL,1,NULL),(13613,'product',2696,'traning-category/test-product-110.html','catalog/product/view/id/2696/category/82',0,1,NULL,1,'{\"category_id\":\"82\"}'),(13614,'product',2696,'/test-product-110.html','catalog/product/view/id/2696/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13626,'product',2916,'ruffle-dress-in-dark-beige.html','catalog/product/view/id/2916',0,1,NULL,1,NULL),(13627,'product',2916,'ready-to-wear/ruffle-dress-in-dark-beige.html','catalog/product/view/id/2916/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13628,'product',2916,'new-collection/ruffle-dress-in-dark-beige.html','catalog/product/view/id/2916/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13629,'product',2916,'/ruffle-dress-in-dark-beige.html','catalog/product/view/id/2916/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13630,'product',25072,'dress-ruffle-in-dark-beige.html','catalog/product/view/id/25072',0,1,NULL,1,NULL),(13631,'product',25072,'ready-to-wear/dress-ruffle-in-dark-beige.html','catalog/product/view/id/25072/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13632,'product',25072,'new-collection/dress-ruffle-in-dark-beige.html','catalog/product/view/id/25072/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13633,'product',25072,'/dress-ruffle-in-dark-beige.html','catalog/product/view/id/25072/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13634,'product',25121,'white-suit-with-silver.html','catalog/product/view/id/25121',0,1,NULL,1,NULL),(13635,'product',25121,'ready-to-wear/white-suit-with-silver.html','catalog/product/view/id/25121/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13636,'product',25121,'new-collection/white-suit-with-silver.html','catalog/product/view/id/25121/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13637,'product',25121,'/white-suit-with-silver.html','catalog/product/view/id/25121/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13638,'product',25170,'light-beige-suit-with-seauin-details.html','catalog/product/view/id/25170',0,1,NULL,1,NULL),(13639,'product',25170,'ready-to-wear/light-beige-suit-with-seauin-details.html','catalog/product/view/id/25170/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13640,'product',25170,'new-collection/light-beige-suit-with-seauin-details.html','catalog/product/view/id/25170/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13641,'product',25170,'/light-beige-suit-with-seauin-details.html','catalog/product/view/id/25170/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13642,'product',25243,'grey-suit-with-dress.html','catalog/product/view/id/25243',0,1,NULL,1,NULL),(13643,'product',25243,'ready-to-wear/grey-suit-with-dress.html','catalog/product/view/id/25243/category/3',0,1,NULL,1,'{\"category_id\":\"3\"}'),(13644,'product',25243,'new-collection/grey-suit-with-dress.html','catalog/product/view/id/25243/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13645,'product',25243,'/grey-suit-with-dress.html','catalog/product/view/id/25243/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13646,'product',25256,'beige-loose-top-with-black.html','catalog/product/view/id/25256',0,1,NULL,1,NULL),(13647,'product',25256,'new-collection/beige-loose-top-with-black.html','catalog/product/view/id/25256/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13648,'product',25256,'top/beige-loose-top-with-black.html','catalog/product/view/id/25256/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13649,'product',25256,'/beige-loose-top-with-black.html','catalog/product/view/id/25256/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13654,'product',25263,'dark-olive-top-with-mix-colors.html','catalog/product/view/id/25263',0,1,NULL,1,NULL),(13655,'product',25263,'new-collection/dark-olive-top-with-mix-colors.html','catalog/product/view/id/25263/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13656,'product',25263,'top/dark-olive-top-with-mix-colors.html','catalog/product/view/id/25263/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13657,'product',25263,'best-seller-products/dark-olive-top-with-mix-colors.html','catalog/product/view/id/25263/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13658,'product',25263,'/dark-olive-top-with-mix-colors.html','catalog/product/view/id/25263/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13659,'product',25312,'black-crepe-wide-leg-trousers.html','catalog/product/view/id/25312',0,1,NULL,1,NULL),(13660,'product',25312,'trousers/black-crepe-wide-leg-trousers.html','catalog/product/view/id/25312/category/9',0,1,NULL,1,'{\"category_id\":\"9\"}'),(13661,'product',25312,'best-seller-products/black-crepe-wide-leg-trousers.html','catalog/product/view/id/25312/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13662,'product',25312,'/black-crepe-wide-leg-trousers.html','catalog/product/view/id/25312/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13663,'product',25319,'beige-jacket-with-neon-colors.html','catalog/product/view/id/25319',0,1,NULL,1,NULL),(13664,'product',25319,'new-collection/beige-jacket-with-neon-colors.html','catalog/product/view/id/25319/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13665,'product',25319,'jacket/beige-jacket-with-neon-colors.html','catalog/product/view/id/25319/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13666,'product',25319,'/beige-jacket-with-neon-colors.html','catalog/product/view/id/25319/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13667,'product',25368,'training-suit-with-off-white-ruffle.html','catalog/product/view/id/25368',0,1,NULL,1,NULL),(13668,'product',25368,'new-collection/training-suit-with-off-white-ruffle.html','catalog/product/view/id/25368/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13669,'product',25368,'two-pieces/training-suit-with-off-white-ruffle.html','catalog/product/view/id/25368/category/38',0,1,NULL,1,'{\"category_id\":\"38\"}'),(13670,'product',25368,'best-seller-products/training-suit-with-off-white-ruffle.html','catalog/product/view/id/25368/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13671,'product',25368,'/training-suit-with-off-white-ruffle.html','catalog/product/view/id/25368/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13672,'product',25375,'beige-jacket-with-ruffle.html','catalog/product/view/id/25375',0,1,NULL,1,NULL),(13673,'product',25375,'jacket/beige-jacket-with-ruffle.html','catalog/product/view/id/25375/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13674,'product',25375,'best-seller-products/beige-jacket-with-ruffle.html','catalog/product/view/id/25375/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13675,'product',25375,'/beige-jacket-with-ruffle.html','catalog/product/view/id/25375/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13676,'product',25382,'olive-top-with-orange-details.html','catalog/product/view/id/25382',0,1,NULL,1,NULL),(13677,'product',25382,'new-collection/olive-top-with-orange-details.html','catalog/product/view/id/25382/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13678,'product',25382,'top/olive-top-with-orange-details.html','catalog/product/view/id/25382/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13679,'product',25382,'/olive-top-with-orange-details.html','catalog/product/view/id/25382/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13680,'product',25389,'jeans-jacket-with-bowknot-brown.html','catalog/product/view/id/25389',0,1,NULL,1,NULL),(13681,'product',25389,'jacket/jeans-jacket-with-bowknot-brown.html','catalog/product/view/id/25389/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13682,'product',25389,'best-seller-products/jeans-jacket-with-bowknot-brown.html','catalog/product/view/id/25389/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13683,'product',25389,'/jeans-jacket-with-bowknot-brown.html','catalog/product/view/id/25389/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13684,'product',25396,'sky-blue-top-with-brown-color.html','catalog/product/view/id/25396',0,1,NULL,1,NULL),(13685,'product',25396,'new-collection/sky-blue-top-with-brown-color.html','catalog/product/view/id/25396/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13686,'product',25396,'top/sky-blue-top-with-brown-color.html','catalog/product/view/id/25396/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13687,'product',25396,'best-seller-products/sky-blue-top-with-brown-color.html','catalog/product/view/id/25396/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13688,'product',25396,'/sky-blue-top-with-brown-color.html','catalog/product/view/id/25396/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13689,'product',25445,'sky-blue-top-with-brown-trouser.html','catalog/product/view/id/25445',0,1,NULL,1,NULL),(13690,'product',25445,'two-pieces/sky-blue-top-with-brown-trouser.html','catalog/product/view/id/25445/category/38',0,1,NULL,1,'{\"category_id\":\"38\"}'),(13691,'product',25445,'/sky-blue-top-with-brown-trouser.html','catalog/product/view/id/25445/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13692,'product',25452,'white-loose-top-with-beige-and-black.html','catalog/product/view/id/25452',0,1,NULL,1,NULL),(13693,'product',25452,'new-collection/white-loose-top-with-beige-and-black.html','catalog/product/view/id/25452/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13694,'product',25452,'top/white-loose-top-with-beige-and-black.html','catalog/product/view/id/25452/category/20',0,1,NULL,1,'{\"category_id\":\"20\"}'),(13695,'product',25452,'best-seller-products/white-loose-top-with-beige-and-black.html','catalog/product/view/id/25452/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13696,'product',25452,'/white-loose-top-with-beige-and-black.html','catalog/product/view/id/25452/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13697,'product',25459,'oversized-denim-jacket-with-max-color.html','catalog/product/view/id/25459',0,1,NULL,1,NULL),(13698,'product',25459,'new-collection/oversized-denim-jacket-with-max-color.html','catalog/product/view/id/25459/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13699,'product',25459,'jacket/oversized-denim-jacket-with-max-color.html','catalog/product/view/id/25459/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13700,'product',25459,'best-seller-products/oversized-denim-jacket-with-max-color.html','catalog/product/view/id/25459/category/81',0,1,NULL,1,'{\"category_id\":\"81\"}'),(13701,'product',25459,'/oversized-denim-jacket-with-max-color.html','catalog/product/view/id/25459/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13702,'product',25466,'dark-olive-top-with-mix-colors-1.html','catalog/product/view/id/25466',0,1,NULL,1,NULL),(13706,'product',25482,'olive-shirt-2.html','catalog/product/view/id/25482',0,1,NULL,1,NULL),(13707,'product',25482,'shop-by-price/olive-shirt-2.html','catalog/product/view/id/25482/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13708,'product',25482,'/olive-shirt-2.html','catalog/product/view/id/25482/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13709,'product',25489,'beige-shirt-with-black-3.html','catalog/product/view/id/25489',0,1,NULL,1,NULL),(13710,'product',25489,'shop-by-price/beige-shirt-with-black-3.html','catalog/product/view/id/25489/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13711,'product',25489,'/beige-shirt-with-black-3.html','catalog/product/view/id/25489/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13712,'product',25497,'caramel-shirt-3.html','catalog/product/view/id/25497',0,1,NULL,1,NULL),(13713,'product',25497,'shop-by-price/caramel-shirt-3.html','catalog/product/view/id/25497/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13714,'product',25497,'/caramel-shirt-3.html','catalog/product/view/id/25497/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13715,'product',25505,'tiffany-shirt-4.html','catalog/product/view/id/25505',0,1,NULL,1,NULL),(13716,'product',25505,'shop-by-price/tiffany-shirt-4.html','catalog/product/view/id/25505/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13717,'product',25505,'/tiffany-shirt-4.html','catalog/product/view/id/25505/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13718,'product',25515,'shirt-sky-5.html','catalog/product/view/id/25515',0,1,NULL,1,NULL),(13719,'product',25515,'shop-by-price/shirt-sky-5.html','catalog/product/view/id/25515/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13720,'product',25515,'/shirt-sky-5.html','catalog/product/view/id/25515/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13721,'product',25526,'training-suit1.html','catalog/product/view/id/25526',0,1,NULL,1,NULL),(13722,'product',25526,'shop-by-price/training-suit1.html','catalog/product/view/id/25526/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13723,'product',25526,'/training-suit1.html','catalog/product/view/id/25526/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13724,'product',25533,'scarf-shirt-6.html','catalog/product/view/id/25533',0,1,NULL,1,NULL),(13725,'product',25533,'shop-by-price/scarf-shirt-6.html','catalog/product/view/id/25533/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13726,'product',25533,'/scarf-shirt-6.html','catalog/product/view/id/25533/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13727,'product',25545,'training-suit-2.html','catalog/product/view/id/25545',0,1,NULL,1,NULL),(13728,'product',25545,'shop-by-price/training-suit-2.html','catalog/product/view/id/25545/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13729,'product',25545,'/training-suit-2.html','catalog/product/view/id/25545/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13730,'product',25553,'training-suit-3.html','catalog/product/view/id/25553',0,1,NULL,1,NULL),(13731,'product',25553,'shop-by-price/training-suit-3.html','catalog/product/view/id/25553/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13732,'product',25553,'/training-suit-3.html','catalog/product/view/id/25553/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13733,'product',25560,'beige-shirt-7.html','catalog/product/view/id/25560',0,1,NULL,1,NULL),(13734,'product',25560,'shop-by-price/beige-shirt-7.html','catalog/product/view/id/25560/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13735,'product',25560,'/beige-shirt-7.html','catalog/product/view/id/25560/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13736,'product',25567,'ruffle-shirt-8.html','catalog/product/view/id/25567',0,1,NULL,1,NULL),(13737,'product',25567,'shop-by-price/ruffle-shirt-8.html','catalog/product/view/id/25567/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13738,'product',25567,'/ruffle-shirt-8.html','catalog/product/view/id/25567/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13739,'product',25575,'training-suit-4.html','catalog/product/view/id/25575',0,1,NULL,1,NULL),(13740,'product',25575,'shop-by-price/training-suit-4.html','catalog/product/view/id/25575/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13741,'product',25575,'/training-suit-4.html','catalog/product/view/id/25575/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13742,'product',25582,'training-suit-5.html','catalog/product/view/id/25582',0,1,NULL,1,NULL),(13743,'product',25582,'shop-by-price/training-suit-5.html','catalog/product/view/id/25582/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13744,'product',25582,'/training-suit-5.html','catalog/product/view/id/25582/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13745,'product',25592,'olive-shirt-9.html','catalog/product/view/id/25592',0,1,NULL,1,NULL),(13746,'product',25592,'shop-by-price/olive-shirt-9.html','catalog/product/view/id/25592/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13747,'product',25592,'/olive-shirt-9.html','catalog/product/view/id/25592/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13748,'product',25599,'burgundy-shirt-10.html','catalog/product/view/id/25599',0,1,NULL,1,NULL),(13749,'product',25599,'shop-by-price/burgundy-shirt-10.html','catalog/product/view/id/25599/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13750,'product',25599,'/burgundy-shirt-10.html','catalog/product/view/id/25599/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13751,'product',25607,'layered-black-shirt-10.html','catalog/product/view/id/25607',0,1,NULL,1,NULL),(13752,'product',25607,'shop-by-price/layered-black-shirt-10.html','catalog/product/view/id/25607/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13753,'product',25607,'/layered-black-shirt-10.html','catalog/product/view/id/25607/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13754,'product',25614,'tiffany-shirt-11.html','catalog/product/view/id/25614',0,1,NULL,1,NULL),(13755,'product',25614,'shop-by-price/tiffany-shirt-11.html','catalog/product/view/id/25614/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13756,'product',25614,'/tiffany-shirt-11.html','catalog/product/view/id/25614/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13757,'product',25621,'training-suit-6.html','catalog/product/view/id/25621',0,1,NULL,1,NULL),(13758,'product',25621,'shop-by-price/training-suit-6.html','catalog/product/view/id/25621/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13759,'product',25621,'/training-suit-6.html','catalog/product/view/id/25621/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13760,'product',25629,'winter-jacket-with-leather-details.html','catalog/product/view/id/25629',0,1,NULL,1,NULL),(13761,'product',25629,'new-collection/winter-jacket-with-leather-details.html','catalog/product/view/id/25629/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13762,'product',25629,'jacket/winter-jacket-with-leather-details.html','catalog/product/view/id/25629/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13763,'product',25629,'/winter-jacket-with-leather-details.html','catalog/product/view/id/25629/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13764,'product',25636,'ghanima-jacket.html','catalog/product/view/id/25636',0,1,NULL,1,NULL),(13765,'product',25636,'new-collection/ghanima-jacket.html','catalog/product/view/id/25636/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13766,'product',25636,'jacket/ghanima-jacket.html','catalog/product/view/id/25636/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13767,'product',25636,'/ghanima-jacket.html','catalog/product/view/id/25636/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13768,'product',25643,'winter-training-suit-with-leather-details.html','catalog/product/view/id/25643',0,1,NULL,1,NULL),(13769,'product',25643,'new-collection/winter-training-suit-with-leather-details.html','catalog/product/view/id/25643/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13770,'product',25643,'two-pieces/winter-training-suit-with-leather-details.html','catalog/product/view/id/25643/category/38',0,1,NULL,1,'{\"category_id\":\"38\"}'),(13771,'product',25643,'/winter-training-suit-with-leather-details.html','catalog/product/view/id/25643/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13772,'product',25650,'ghanlma-winter-training-suit.html','catalog/product/view/id/25650',0,1,NULL,1,NULL),(13773,'product',25650,'new-collection/ghanlma-winter-training-suit.html','catalog/product/view/id/25650/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13774,'product',25650,'two-pieces/ghanlma-winter-training-suit.html','catalog/product/view/id/25650/category/38',0,1,NULL,1,'{\"category_id\":\"38\"}'),(13775,'product',25650,'/ghanlma-winter-training-suit.html','catalog/product/view/id/25650/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13776,'product',25652,'light-pink-suit-1.html','catalog/product/view/id/25652',0,1,NULL,1,NULL),(13777,'product',25652,'shop-by-price/light-pink-suit-1.html','catalog/product/view/id/25652/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13778,'product',25652,'/light-pink-suit-1.html','catalog/product/view/id/25652/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13779,'product',25654,'black-suit-with-gold-2.html','catalog/product/view/id/25654',0,1,NULL,1,NULL),(13780,'product',25654,'shop-by-price/black-suit-with-gold-2.html','catalog/product/view/id/25654/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13781,'product',25654,'/black-suit-with-gold-2.html','catalog/product/view/id/25654/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13782,'product',25656,'dark-blue-suit3.html','catalog/product/view/id/25656',0,1,NULL,1,NULL),(13783,'product',25656,'shop-by-price/dark-blue-suit3.html','catalog/product/view/id/25656/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13784,'product',25656,'/dark-blue-suit3.html','catalog/product/view/id/25656/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13785,'product',25663,'winter-jacket-with-leather-details-20.html','catalog/product/view/id/25663',0,1,NULL,1,NULL),(13786,'product',25663,'shop-by-price/winter-jacket-with-leather-details-20.html','catalog/product/view/id/25663/category/43',0,1,NULL,1,'{\"category_id\":\"43\"}'),(13787,'product',25663,'/winter-jacket-with-leather-details-20.html','catalog/product/view/id/25663/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13788,'product',25670,'sponge-gray-jacket-with-black.html','catalog/product/view/id/25670',0,1,NULL,1,NULL),(13789,'product',25670,'new-collection/sponge-gray-jacket-with-black.html','catalog/product/view/id/25670/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13790,'product',25670,'jacket/sponge-gray-jacket-with-black.html','catalog/product/view/id/25670/category/54',0,1,NULL,1,'{\"category_id\":\"54\"}'),(13791,'product',25670,'/sponge-gray-jacket-with-black.html','catalog/product/view/id/25670/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13792,'product',1565,'gray-kaftan-with-black-details.html','catalog/product/view/id/1565',0,1,NULL,1,NULL),(13793,'product',1565,'shop-by-age-category/gray-kaftan-with-black-details.html','catalog/product/view/id/1565/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13794,'product',1565,'dresses/gray-kaftan-with-black-details.html','shop-by-age-category/gray-kaftan-with-black-details.html',301,1,NULL,0,'{\"category_id\":\"7\"}'),(13795,'product',1565,'/gray-kaftan-with-black-details.html','catalog/product/view/id/1565/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13796,'product',25726,'kaftan-1.html','catalog/product/view/id/25726',0,1,NULL,1,NULL),(13797,'product',25726,'shop-by-age-category/kaftan-1.html','catalog/product/view/id/25726/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13798,'product',25726,'/kaftan-1.html','catalog/product/view/id/25726/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13799,'product',25731,'kaftan-2.html','catalog/product/view/id/25731',0,1,NULL,1,NULL),(13800,'product',25731,'shop-by-age-category/kaftan-2.html','catalog/product/view/id/25731/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13801,'product',25731,'/kaftan-2.html','catalog/product/view/id/25731/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13802,'product',25740,'black-organza-kaftan-with-lace.html','catalog/product/view/id/25740',0,1,NULL,1,NULL),(13803,'product',25740,'shop-by-age-category/black-organza-kaftan-with-lace.html','catalog/product/view/id/25740/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13804,'product',25740,'new-collection/black-organza-kaftan-with-lace.html','catalog/product/view/id/25740/category/11',0,1,NULL,1,'{\"category_id\":\"11\"}'),(13805,'product',25740,'/black-organza-kaftan-with-lace.html','catalog/product/view/id/25740/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13806,'product',25747,'white-cotton-kaftan.html','catalog/product/view/id/25747',0,1,NULL,1,NULL),(13807,'product',25747,'shop-by-age-category/white-cotton-kaftan.html','catalog/product/view/id/25747/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13808,'product',25747,'/white-cotton-kaftan.html','catalog/product/view/id/25747/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13809,'product',25754,'beige-kaftan-with-sky-blue.html','catalog/product/view/id/25754',0,1,NULL,1,NULL),(13810,'product',25754,'shop-by-age-category/beige-kaftan-with-sky-blue.html','catalog/product/view/id/25754/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13811,'product',25754,'/beige-kaftan-with-sky-blue.html','catalog/product/view/id/25754/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13812,'product',25761,'light-pink-kaftan-with-red.html','catalog/product/view/id/25761',0,1,NULL,1,NULL),(13813,'product',25761,'shop-by-age-category/light-pink-kaftan-with-red.html','catalog/product/view/id/25761/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13814,'product',25761,'/light-pink-kaftan-with-red.html','catalog/product/view/id/25761/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13815,'product',25768,'bride-kaftan.html','catalog/product/view/id/25768',0,1,NULL,1,NULL),(13816,'product',25768,'shop-by-age-category/bride-kaftan.html','catalog/product/view/id/25768/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13817,'product',25768,'/bride-kaftan.html','catalog/product/view/id/25768/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}'),(13818,'product',25780,'black-kaftan-with-gold.html','catalog/product/view/id/25780',0,1,NULL,1,NULL),(13819,'product',25780,'shop-by-age-category/black-kaftan-with-gold.html','catalog/product/view/id/25780/category/7',0,1,NULL,1,'{\"category_id\":\"7\"}'),(13820,'product',25780,'/black-kaftan-with-gold.html','catalog/product/view/id/25780/category/2',0,1,NULL,1,'{\"category_id\":\"2\"}');

--
-- Table structure for table `mag2_variable`
--

CREATE TABLE `mag2_variable` (
  `variable_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Variable Id',
  `code` varchar(255) DEFAULT NULL COMMENT 'Variable Code',
  `name` varchar(255) DEFAULT NULL COMMENT 'Variable Name',
  PRIMARY KEY (`variable_id`),
  UNIQUE KEY `MAG2_VARIABLE_CODE` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Variables';

--
-- Dumping data for table `mag2_variable`
--


--
-- Table structure for table `mag2_variable_value`
--

CREATE TABLE `mag2_variable_value` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Variable Value Id',
  `variable_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Variable Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `plain_value` text COMMENT 'Plain Text Value',
  `html_value` text COMMENT 'Html Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_VARIABLE_VALUE_VARIABLE_ID_STORE_ID` (`variable_id`,`store_id`),
  KEY `MAG2_VARIABLE_VALUE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Variable Value';

--
-- Dumping data for table `mag2_variable_value`
--


--
-- Table structure for table `mag2_vault_payment_token`
--

CREATE TABLE `mag2_vault_payment_token` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer Id',
  `public_hash` varchar(128) NOT NULL COMMENT 'Hash code for using on frontend',
  `payment_method_code` varchar(128) NOT NULL COMMENT 'Payment method code',
  `type` varchar(128) NOT NULL COMMENT 'Type',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `expires_at` timestamp NULL DEFAULT NULL COMMENT 'Expires At',
  `gateway_token` varchar(255) NOT NULL COMMENT 'Gateway Token',
  `details` text COMMENT 'Details',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_visible` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `MAG2_VAULT_PAYMENT_TOKEN_HASH_UNIQUE_INDEX_PUBLIC_HASH` (`public_hash`),
  UNIQUE KEY `UNQ_DF8882950277807252C2F26F9D8377BB` (`payment_method_code`,`customer_id`,`gateway_token`),
  KEY `MAG2_VAULT_PAYMENT_TOKEN_CSTR_ID_MAG2_CSTR_ENTT_ENTT_ID` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Vault tokens of payment';

--
-- Dumping data for table `mag2_vault_payment_token`
--


--
-- Table structure for table `mag2_vault_payment_token_order_payment_link`
--

CREATE TABLE `mag2_vault_payment_token_order_payment_link` (
  `order_payment_id` int(10) unsigned NOT NULL COMMENT 'Order payment Id',
  `payment_token_id` int(10) unsigned NOT NULL COMMENT 'Payment token Id',
  PRIMARY KEY (`order_payment_id`,`payment_token_id`),
  KEY `FK_5CB22CFCFFF1B1E3976A523A3A397D87` (`payment_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Order payments to vault token';

--
-- Dumping data for table `mag2_vault_payment_token_order_payment_link`
--


--
-- Table structure for table `mag2_vertex_customer_code`
--

CREATE TABLE `mag2_vertex_customer_code` (
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  `customer_code` text COMMENT 'Customer Code for Vertex',
  PRIMARY KEY (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mag2_vertex_customer_code';

--
-- Dumping data for table `mag2_vertex_customer_code`
--


--
-- Table structure for table `mag2_vertex_invoice_sent`
--

CREATE TABLE `mag2_vertex_invoice_sent` (
  `invoice_id` int(10) unsigned NOT NULL COMMENT 'Invoice ID',
  `sent_to_vertex` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Invoice has been logged in Vertex',
  PRIMARY KEY (`invoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mag2_vertex_invoice_sent';

--
-- Dumping data for table `mag2_vertex_invoice_sent`
--


--
-- Table structure for table `mag2_vertex_order_invoice_status`
--

CREATE TABLE `mag2_vertex_order_invoice_status` (
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `sent_to_vertex` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Invoice has been logged in Vertex',
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mag2_vertex_order_invoice_status';

--
-- Dumping data for table `mag2_vertex_order_invoice_status`
--


--
-- Table structure for table `mag2_vertex_taxrequest`
--

CREATE TABLE `mag2_vertex_taxrequest` (
  `request_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `request_type` varchar(255) NOT NULL COMMENT 'Request Type',
  `quote_id` bigint(20) DEFAULT NULL,
  `order_id` bigint(20) DEFAULT NULL,
  `total_tax` varchar(255) NOT NULL COMMENT 'Total Tax Amount',
  `source_path` varchar(255) NOT NULL COMMENT 'Source path controller_module_action',
  `tax_area_id` varchar(255) NOT NULL COMMENT 'Tax Jurisdictions Id',
  `sub_total` varchar(255) NOT NULL COMMENT 'Response Subtotal Amount',
  `total` varchar(255) NOT NULL COMMENT 'Response Total Amount',
  `lookup_result` varchar(255) NOT NULL COMMENT 'Tax Area Response Lookup Result',
  `request_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Request create date',
  `request_xml` text NOT NULL COMMENT 'Request XML',
  `response_xml` text NOT NULL COMMENT 'Response XML',
  PRIMARY KEY (`request_id`),
  UNIQUE KEY `MAG2_VERTEX_TAXREQUEST_REQUEST_ID` (`request_id`),
  KEY `MAG2_VERTEX_TAXREQUEST_REQUEST_TYPE` (`request_type`),
  KEY `MAG2_VERTEX_TAXREQUEST_ORDER_ID` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Log of requests to Vertex';

--
-- Dumping data for table `mag2_vertex_taxrequest`
--


--
-- Table structure for table `mag2_weee_tax`
--

CREATE TABLE `mag2_weee_tax` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `country` varchar(2) DEFAULT NULL COMMENT 'Country',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  `state` int(11) NOT NULL DEFAULT '0' COMMENT 'State',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute Id',
  PRIMARY KEY (`value_id`),
  KEY `MAG2_WEEE_TAX_WEBSITE_ID` (`website_id`),
  KEY `MAG2_WEEE_TAX_ENTITY_ID` (`entity_id`),
  KEY `MAG2_WEEE_TAX_COUNTRY` (`country`),
  KEY `MAG2_WEEE_TAX_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `MAG2_WEEE_TAX_ENTITY_ID_MAG2_CATALOG_PRODUCT_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Weee Tax';

--
-- Dumping data for table `mag2_weee_tax`
--


--
-- Table structure for table `mag2_weltpixel_license`
--

CREATE TABLE `mag2_weltpixel_license` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `module_name` varchar(255) DEFAULT NULL COMMENT 'Module Name',
  `license_key` text COMMENT 'License Key',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='WeltPixel License';

--
-- Dumping data for table `mag2_weltpixel_license`
--


--
-- Table structure for table `mag2_widget`
--

CREATE TABLE `mag2_widget` (
  `widget_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Widget Id',
  `widget_code` varchar(255) DEFAULT NULL COMMENT 'Widget code for template directive',
  `widget_type` varchar(255) DEFAULT NULL COMMENT 'Widget Type',
  `parameters` text COMMENT 'Parameters',
  PRIMARY KEY (`widget_id`),
  KEY `MAG2_WIDGET_WIDGET_CODE` (`widget_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Preconfigured Widgets';

--
-- Dumping data for table `mag2_widget`
--


--
-- Table structure for table `mag2_widget_instance`
--

CREATE TABLE `mag2_widget_instance` (
  `instance_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Instance Id',
  `instance_type` varchar(255) DEFAULT NULL COMMENT 'Instance Type',
  `theme_id` int(10) unsigned NOT NULL COMMENT 'Theme id',
  `title` varchar(255) DEFAULT NULL COMMENT 'Widget Title',
  `store_ids` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Store ids',
  `widget_parameters` text COMMENT 'Widget parameters',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort order',
  PRIMARY KEY (`instance_id`),
  KEY `MAG2_WIDGET_INSTANCE_THEME_ID_THEME_THEME_ID` (`theme_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='Instances of Widget for Package Theme';

--
-- Dumping data for table `mag2_widget_instance`
--

INSERT INTO `mag2_widget_instance` VALUES (1,'Magento\\Cms\\Block\\Widget\\Block',2,'Contact us info','0','{\"block_id\":\"2\"}',0),(2,'Magento\\Cms\\Block\\Widget\\Block',2,'Footer Links','0','{\"block_id\":\"1\"}',0),(3,'Magento\\Cms\\Block\\Widget\\Block',2,'Sale Left Menu','0','{\"block_id\":\"3\"}',0),(4,'Magento\\Cms\\Block\\Widget\\Block',2,'Gear Left Menu','0','{\"block_id\":\"4\"}',0),(5,'Magento\\Cms\\Block\\Widget\\Block',2,'Men\'s Left Menu','0','{\"block_id\":\"5\"}',0),(6,'Magento\\Cms\\Block\\Widget\\Block',2,'Women\'s Left Menu','0','{\"block_id\":\"6\"}',0),(7,'Magento\\Cms\\Block\\Widget\\Block',2,'What\'s New Left Menu','0','{\"block_id\":\"7\"}',0),(8,'Magento\\Cms\\Block\\Widget\\Block',2,'Women Category Content','0','{\"block_id\":\"8\"}',0),(9,'Magento\\Cms\\Block\\Widget\\Block',2,'Training Category Content','0','{\"block_id\":\"9\"}',0),(10,'Magento\\Cms\\Block\\Widget\\Block',2,'Men Category Content','0','{\"block_id\":\"10\"}',0),(11,'Magento\\Cms\\Block\\Widget\\Block',2,'Gear Category Content','0','{\"block_id\":\"11\"}',0),(12,'Magento\\Cms\\Block\\Widget\\Block',2,'New Products Category Content','0','{\"block_id\":\"13\"}',0),(13,'Magento\\Cms\\Block\\Widget\\Block',2,'Sale Category Content','0','{\"block_id\":\"12\"}',0),(14,'Magento\\Cms\\Block\\Widget\\Block',2,'Home Page','0','{\"block_id\":\"14\"}',0),(15,'Magento\\Cms\\Block\\Widget\\Block',2,'Performance Fabrics','0','{\"block_id\":\"15\"}',0),(16,'Magento\\Cms\\Block\\Widget\\Block',2,'Eco Friendly','0','{\"block_id\":\"16\"}',0),(17,'Magento\\Cms\\Block\\Widget\\Block',2,'Login Info','0','{\"block_id\":\"18\"}',0),(18,'Magento\\Cms\\Block\\Widget\\Block',2,'Giftcard Category Content','0','{\"block_id\":\"17\"}',0);

--
-- Table structure for table `mag2_widget_instance_page`
--

CREATE TABLE `mag2_widget_instance_page` (
  `page_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Page Id',
  `instance_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Id',
  `page_group` varchar(25) DEFAULT NULL COMMENT 'Block Group Type',
  `layout_handle` varchar(255) DEFAULT NULL COMMENT 'Layout Handle',
  `block_reference` varchar(255) DEFAULT NULL COMMENT 'Container',
  `page_for` varchar(25) DEFAULT NULL COMMENT 'For instance entities',
  `entities` text COMMENT 'Catalog entities (comma separated)',
  `page_template` varchar(255) DEFAULT NULL COMMENT 'Path to widget template',
  PRIMARY KEY (`page_id`),
  KEY `MAG2_WIDGET_INSTANCE_PAGE_INSTANCE_ID` (`instance_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='Instance of Widget on Page';

--
-- Dumping data for table `mag2_widget_instance_page`
--

INSERT INTO `mag2_widget_instance_page` VALUES (1,1,'pages','contact_index_index','content.top','all','','widget/static_block/default.phtml'),(2,2,'all_pages','default','cms_footer_links_container','all','','widget/static_block/default.phtml'),(3,3,'anchor_categories','catalog_category_view_type_layered','sidebar.main','specific','37','widget/static_block/default.phtml'),(4,4,'anchor_categories','catalog_category_view_type_layered','sidebar.main','specific','3','widget/static_block/default.phtml'),(5,5,'anchor_categories','catalog_category_view_type_layered','sidebar.main','specific','11','widget/static_block/default.phtml'),(6,6,'anchor_categories','catalog_category_view_type_layered','sidebar.main','specific','20','widget/static_block/default.phtml'),(7,7,'anchor_categories','catalog_category_view_type_layered','sidebar.main','specific','38','widget/static_block/default.phtml'),(8,8,'anchor_categories','catalog_category_view_type_layered','content.top','specific','20','widget/static_block/default.phtml'),(9,9,'anchor_categories','catalog_category_view_type_layered','content.top','specific','9','widget/static_block/default.phtml'),(10,10,'anchor_categories','catalog_category_view_type_layered','content.top','specific','11','widget/static_block/default.phtml'),(11,11,'anchor_categories','catalog_category_view_type_layered','content.top','specific','3','widget/static_block/default.phtml'),(12,12,'anchor_categories','catalog_category_view_type_layered','content.top','specific','38','widget/static_block/default.phtml'),(13,13,'anchor_categories','catalog_category_view_type_layered','content.top','specific','37','widget/static_block/default.phtml'),(14,14,'pages','cms_index_index','content','all','','widget/static_block/default.phtml'),(15,15,'anchor_categories','catalog_category_view_type_layered','content.top','specific','39','widget/static_block/default.phtml'),(16,16,'anchor_categories','catalog_category_view_type_layered','content.top','specific','40','widget/static_block/default.phtml'),(17,17,'pages','customer_account_login','customer.login.container','all','','widget/static_block/default.phtml'),(18,18,'anchor_categories','catalog_category_view_type_layered','content.top','specific',NULL,'widget/static_block/default.phtml');

--
-- Table structure for table `mag2_widget_instance_page_layout`
--

CREATE TABLE `mag2_widget_instance_page_layout` (
  `page_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Page Id',
  `layout_update_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Layout Update Id',
  UNIQUE KEY `MAG2_WIDGET_INSTANCE_PAGE_LAYOUT_LAYOUT_UPDATE_ID_PAGE_ID` (`layout_update_id`,`page_id`),
  KEY `MAG2_WIDGET_INSTANCE_PAGE_LAYOUT_PAGE_ID` (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Layout updates';

--
-- Dumping data for table `mag2_widget_instance_page_layout`
--

INSERT INTO `mag2_widget_instance_page_layout` VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10),(11,11),(12,12),(13,13),(14,14),(15,15),(16,16),(17,17),(18,18);

--
-- Table structure for table `mag2_wishlist`
--

CREATE TABLE `mag2_wishlist` (
  `wishlist_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Wishlist ID',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer ID',
  `shared` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Sharing flag (0 or 1)',
  `sharing_code` varchar(32) DEFAULT NULL COMMENT 'Sharing encrypted code',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Last updated date',
  PRIMARY KEY (`wishlist_id`),
  UNIQUE KEY `MAG2_WISHLIST_CUSTOMER_ID` (`customer_id`),
  KEY `MAG2_WISHLIST_SHARED` (`shared`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='Wishlist main Table';

--
-- Dumping data for table `mag2_wishlist`
--

INSERT INTO `mag2_wishlist` VALUES (1,2,0,'6e3fc17ff54da4f95c9515d1c03d6dd4','2019-02-19 08:41:38'),(2,3,1,'9ead00f02cb1fec460f74d26aeb3c970','2019-06-20 11:27:29'),(3,4,0,'e78a94c0aee0621224357c7da63fa5c2','2019-03-26 11:48:04'),(4,5,0,'a951b44a52970a83c3eb8b3985b58c3b','2019-04-10 12:14:14'),(5,6,0,'224eeb9c84161afb113f13d05ef11495','2019-05-28 10:39:56'),(6,7,0,'60279bb38ef161f85ac985756140bf11','2019-05-28 10:56:05'),(7,8,0,'5055e74a5b87679bad268d789cd8fefc','2019-05-28 12:17:43'),(8,9,0,'70963daebb418903545f07e290a9bfb3','2019-06-02 10:55:37'),(9,10,0,'16b170d2bcce6d574814d779616ac3a1','2019-06-08 21:25:29'),(10,11,0,'38ff43f9815ac3162d13c21cb17e6134','2019-06-22 20:41:38'),(11,12,0,'b90b529f7c1eaa5a8eec28452d59c161','2019-06-24 07:17:20'),(12,13,0,'ed7a0ce508b01a82bc56db72c51f0cac','2019-07-14 10:54:36'),(13,14,2,'97a6375b70ce00b33950c5a859fb41b3','2019-07-15 09:30:54'),(14,15,0,'774e008d06e816763fc68732cb38f2e8','2019-10-20 06:40:54'),(15,16,0,'b624f0f3b87ab69f89b56b341c402bc9','2019-12-15 13:25:37'),(16,17,0,'4bc2a139c2842276dc6b2fcec02d20a3','2019-12-18 07:28:50'),(17,18,0,'82b3bee824f5336eb4567ed4cd4db964','2020-01-23 09:55:44'),(18,19,0,'d25b636f69642947e8560c3067919f9c','2021-01-26 09:54:37'),(19,20,0,'f1a626410b77a14e7277504eb0f265f1','2021-02-18 08:28:40'),(20,21,0,'ad4a40783e74ba5736ca0b3a93ca4517','2021-03-07 12:14:42'),(21,22,0,'17b82c43a3270b89419fb9bdb75ecd3c','2021-03-22 15:51:51'),(22,23,0,'9ea91d16a192e772ce59d33dd0e0ee21','2021-03-31 11:29:07'),(23,24,0,'ebddb4ff088a63d2dba1e7a0a46f6854','2021-04-24 22:10:05'),(24,25,0,'14d0ca448e9adb50011bfeef2ca63ed8','2021-07-21 12:26:19'),(25,26,0,'01442bb6211529367a6f3e1cf45b57d5','2021-08-01 11:55:52'),(26,27,0,'cbfe846c1bc28c24c67e3d574cd61447','2022-07-02 04:47:29'),(27,28,0,'422c5535936be51ef6d442edd9f1006f','2022-07-20 19:04:21'),(28,30,0,'d0cc027b17ca3c8779dc1dfcbd37d7ec','2022-08-02 09:03:48'),(29,31,0,'d13aa7dd672d6e9cdfa04ffdc95f73da','2022-11-19 21:29:08'),(30,32,0,'01376d4e1657f907161b38fe0e1cd352','2022-12-17 06:38:27'),(31,33,0,'bd7ae57bccf1412e8233d35c6a396032','2023-01-31 14:27:10'),(32,34,0,'39a389a39c135dcabc65759cc9ac2597','2023-03-08 13:23:10');

--
-- Table structure for table `mag2_wishlist_item`
--

CREATE TABLE `mag2_wishlist_item` (
  `wishlist_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Wishlist item ID',
  `wishlist_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Wishlist ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `added_at` timestamp NULL DEFAULT NULL COMMENT 'Add date and time',
  `description` text COMMENT 'Short description of wish list item',
  `qty` decimal(12,4) NOT NULL COMMENT 'Qty',
  PRIMARY KEY (`wishlist_item_id`),
  KEY `MAG2_WISHLIST_ITEM_WISHLIST_ID` (`wishlist_id`),
  KEY `MAG2_WISHLIST_ITEM_PRODUCT_ID` (`product_id`),
  KEY `MAG2_WISHLIST_ITEM_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_WISHLIST_ITEM_PRD_ID_MAG2_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `mag2_catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='Wishlist items';

--
-- Dumping data for table `mag2_wishlist_item`
--

INSERT INTO `mag2_wishlist_item` VALUES (2,13,2176,1,'2019-07-15 09:02:50',NULL,1.0000),(3,13,2211,1,'2019-07-15 09:30:53',NULL,2.0000),(4,2,2236,1,'2019-10-22 19:26:02',NULL,1.0000),(5,30,25607,1,'2022-12-17 06:38:31',NULL,1.0000);

--
-- Table structure for table `mag2_wishlist_item_option`
--

CREATE TABLE `mag2_wishlist_item_option` (
  `option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Id',
  `wishlist_item_id` int(10) unsigned NOT NULL COMMENT 'Wishlist Item Id',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product Id',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `value` text COMMENT 'Value',
  PRIMARY KEY (`option_id`),
  KEY `FK_4BAADBECA2F55C14A8705A3362039D6E` (`wishlist_item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='Wishlist Item Option Table';

--
-- Dumping data for table `mag2_wishlist_item_option`
--

INSERT INTO `mag2_wishlist_item_option` VALUES (7,2,2176,'info_buyRequest','{\"product\":\"2176\",\"uenc\":\"aHR0cDovL2RyZXNzbWUucGhwbWF3YXFhYS5jb20vdGVzdC1jb25maWdyYWJsZS5odG1s\",\"qty\":\"1\",\"form_key\":\"iNnYYbN2HerNCtdD\"}'),(8,3,2211,'info_buyRequest','{\"uenc\":\"aHR0cDovL2RyZXNzbWUucGhwbWF3YXFhYS5jb20vdGVzdDIuaHRtbA,,\",\"product\":\"2211\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"qty\":2,\"original_qty\":\"1\"}'),(9,4,2236,'info_buyRequest','{\"product\":\"2236\",\"uenc\":\"aHR0cDovL2RyZXNzbWUucGhwbWF3YXFhYS5jb20vdGVzdC0xMC5odG1s\",\"form_key\":\"qYCvidutVS7rsRbh\"}'),(10,5,25607,'info_buyRequest','{\"uenc\":\"aHR0cHM6Ly9kcmVzc21la3cuY29tL2NhdGFsb2cvcHJvZHVjdC92aWV3L2lkLzI1NjA3Lw%2C%2C\",\"product\":\"25607\",\"form_key\":\"114aB0lDgrvGqatg\",\"super_attribute\":{\"141\":\"228\",\"93\":\"319\"}}'),(11,5,25607,'attributes','{\"141\":\"228\",\"93\":\"319\"}'),(12,5,25601,'product_qty_25601','1'),(13,5,25601,'simple_product','25601');

--
-- Table structure for table `mag2cache`
--

CREATE TABLE `mag2cache` (
  `id` varchar(200) NOT NULL COMMENT 'Cache Id',
  `data` mediumblob COMMENT 'Cache Data',
  `create_time` int(11) DEFAULT NULL COMMENT 'Cache Creation Time',
  `update_time` int(11) DEFAULT NULL COMMENT 'Time of Cache Updating',
  `expire_time` int(11) DEFAULT NULL COMMENT 'Cache Expiration Time',
  PRIMARY KEY (`id`),
  KEY `MAG2CACHE_EXPIRE_TIME` (`expire_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Caches';

--
-- Dumping data for table `mag2cache`
--


--
-- Table structure for table `mag2cache_tag`
--

CREATE TABLE `mag2cache_tag` (
  `tag` varchar(100) NOT NULL COMMENT 'Tag',
  `cache_id` varchar(200) NOT NULL COMMENT 'Cache Id',
  PRIMARY KEY (`tag`,`cache_id`),
  KEY `MAG2CACHE_TAG_CACHE_ID` (`cache_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tag Caches';

--
-- Dumping data for table `mag2cache_tag`
--


--
-- Table structure for table `mag2flag`
--

CREATE TABLE `mag2flag` (
  `flag_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Flag Id',
  `flag_code` varchar(255) NOT NULL COMMENT 'Flag Code',
  `state` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Flag State',
  `flag_data` text COMMENT 'Flag Data',
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date of Last Flag Update',
  PRIMARY KEY (`flag_id`),
  KEY `MAG2FLAG_LAST_UPDATE` (`last_update`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Flag';

--
-- Dumping data for table `mag2flag`
--


--
-- Table structure for table `mag2session`
--

CREATE TABLE `mag2session` (
  `session_id` varchar(255) NOT NULL COMMENT 'Session Id',
  `session_expires` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Date of Session Expiration',
  `session_data` mediumblob NOT NULL COMMENT 'Session Data',
  PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Database Sessions Storage';

--
-- Dumping data for table `mag2session`
--


--
-- Table structure for table `mag2setup_module`
--

CREATE TABLE `mag2setup_module` (
  `module` varchar(50) NOT NULL COMMENT 'Module',
  `schema_version` varchar(50) DEFAULT NULL COMMENT 'Schema Version',
  `data_version` varchar(50) DEFAULT NULL COMMENT 'Data Version',
  PRIMARY KEY (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Module versions registry';

--
-- Dumping data for table `mag2setup_module`
--


--
-- Table structure for table `magefan_blog_category`
--

CREATE TABLE `magefan_blog_category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Category ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Category Title',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Category Meta Title',
  `meta_keywords` text COMMENT 'Category Meta Keywords',
  `meta_description` text COMMENT 'Category Meta Description',
  `identifier` varchar(100) DEFAULT NULL COMMENT 'Category String Identifier',
  `content_heading` varchar(255) DEFAULT NULL COMMENT 'Category Content Heading',
  `content` mediumtext COMMENT 'Category Content',
  `path` varchar(255) DEFAULT NULL COMMENT 'Category Path',
  `position` smallint(6) NOT NULL COMMENT 'Category Position',
  `posts_sort_by` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Post Sort By',
  `include_in_menu` smallint(6) DEFAULT NULL COMMENT 'Category In Menu',
  `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Is Category Active',
  `display_mode` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Display Mode',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Post Layout',
  `layout_update_xml` text COMMENT 'Post Layout Update Content',
  `custom_theme` varchar(100) DEFAULT NULL COMMENT 'Post Custom Theme',
  `custom_layout` varchar(255) DEFAULT NULL COMMENT 'Post Custom Template',
  `custom_layout_update_xml` text COMMENT 'Post Custom Layout Update Content',
  `custom_theme_from` date DEFAULT NULL COMMENT 'Post Custom Theme Active From Date',
  `custom_theme_to` date DEFAULT NULL COMMENT 'Post Custom Theme Active To Date',
  PRIMARY KEY (`category_id`),
  KEY `MAGEFAN_BLOG_CATEGORY_IDENTIFIER` (`identifier`),
  KEY `MAGEFAN_BLOG_CATEGORY_INCLUDE_IN_MENU` (`include_in_menu`),
  FULLTEXT KEY `FTI_B76AD11A0A06CC3327BA3A86A016134F` (`title`,`meta_keywords`,`meta_description`,`identifier`,`content`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Category Table';

--
-- Dumping data for table `magefan_blog_category`
--


--
-- Table structure for table `magefan_blog_category_store`
--

CREATE TABLE `magefan_blog_category_store` (
  `category_id` int(11) NOT NULL COMMENT 'Category ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`category_id`,`store_id`),
  KEY `MAGEFAN_BLOG_CATEGORY_STORE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Category To Store Linkage Table';

--
-- Dumping data for table `magefan_blog_category_store`
--


--
-- Table structure for table `magefan_blog_comment`
--

CREATE TABLE `magefan_blog_comment` (
  `comment_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Comment ID',
  `parent_id` int(11) NOT NULL COMMENT 'Parent Comment ID',
  `post_id` int(11) NOT NULL COMMENT 'Post ID',
  `customer_id` int(11) DEFAULT NULL COMMENT 'Customer ID',
  `admin_id` int(11) DEFAULT NULL COMMENT 'Admin User ID',
  `status` smallint(6) NOT NULL COMMENT 'Comment status',
  `author_type` smallint(6) NOT NULL COMMENT 'Author Type',
  `author_nickname` varchar(255) NOT NULL COMMENT 'Comment Author Nickname',
  `author_email` varchar(255) DEFAULT NULL COMMENT 'Comment Author Email',
  `text` mediumtext COMMENT 'Text',
  `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Comment Creation Time',
  `update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Comment Update Time',
  PRIMARY KEY (`comment_id`),
  KEY `MAGEFAN_BLOG_COMMENT_PARENT_ID` (`parent_id`),
  KEY `MAGEFAN_BLOG_COMMENT_POST_ID` (`post_id`),
  KEY `MAGEFAN_BLOG_COMMENT_CUSTOMER_ID` (`customer_id`),
  KEY `MAGEFAN_BLOG_COMMENT_ADMIN_ID` (`admin_id`),
  KEY `MAGEFAN_BLOG_COMMENT_STATUS` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='magefan_blog_comment';

--
-- Dumping data for table `magefan_blog_comment`
--


--
-- Table structure for table `magefan_blog_post`
--

CREATE TABLE `magefan_blog_post` (
  `post_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Post ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Post Title',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Post Meta Title',
  `meta_keywords` text COMMENT 'Post Meta Keywords',
  `meta_description` text COMMENT 'Post Meta Description',
  `identifier` varchar(100) DEFAULT NULL COMMENT 'Post String Identifier',
  `og_title` varchar(255) DEFAULT NULL COMMENT 'Post OG Title',
  `og_description` varchar(255) DEFAULT NULL COMMENT 'Post OG Description',
  `og_img` varchar(255) DEFAULT NULL COMMENT 'Post OG Img',
  `og_type` varchar(255) DEFAULT NULL COMMENT 'Post OG Type',
  `content_heading` varchar(255) DEFAULT NULL COMMENT 'Post Content Heading',
  `content` mediumtext COMMENT 'Post Content',
  `creation_time` timestamp NULL DEFAULT NULL COMMENT 'Post Creation Time',
  `update_time` timestamp NULL DEFAULT NULL COMMENT 'Post Modification Time',
  `publish_time` timestamp NULL DEFAULT NULL COMMENT 'Post Publish Time',
  `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Is Post Active',
  `include_in_recent` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Include in Recent Posts',
  `position` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Position',
  `featured_img` varchar(255) DEFAULT NULL COMMENT 'Thumbnail Image',
  `author_id` int(11) DEFAULT NULL COMMENT 'Author ID',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Post Layout',
  `layout_update_xml` text COMMENT 'Post Layout Update Content',
  `custom_theme` varchar(100) DEFAULT NULL COMMENT 'Post Custom Theme',
  `custom_layout` varchar(255) DEFAULT NULL COMMENT 'Post Custom Template',
  `custom_layout_update_xml` text COMMENT 'Post Custom Layout Update Content',
  `custom_theme_from` date DEFAULT NULL COMMENT 'Post Custom Theme Active From Date',
  `custom_theme_to` date DEFAULT NULL COMMENT 'Post Custom Theme Active To Date',
  `media_gallery` mediumtext COMMENT 'Media Gallery',
  `secret` varchar(32) DEFAULT NULL COMMENT 'Post Secret',
  `views_count` int(11) DEFAULT NULL COMMENT 'Post Views Count',
  `is_recent_posts_skip` smallint(6) DEFAULT NULL COMMENT 'Is Post Skipped From Recent Posts',
  `short_content` mediumtext COMMENT 'Post Short Content',
  PRIMARY KEY (`post_id`),
  KEY `MAGEFAN_BLOG_POST_IDENTIFIER` (`identifier`),
  KEY `MAGEFAN_BLOG_POST_AUTHOR_ID` (`author_id`),
  KEY `MAGEFAN_BLOG_POST_VIEWS_COUNT` (`views_count`),
  KEY `MAGEFAN_BLOG_POST_IS_RECENT_POSTS_SKIP` (`is_recent_posts_skip`),
  FULLTEXT KEY `FTI_A5DB7871E89B230F74EDFBECEB4659FA` (`title`,`meta_keywords`,`meta_description`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post Table';

--
-- Dumping data for table `magefan_blog_post`
--

INSERT INTO `magefan_blog_post` VALUES (1,'Hello world!',NULL,'magento 2 blog','Magento 2 blog default post.','hello-world',NULL,NULL,NULL,NULL,'Hello world!','<p>Welcome to <a title=\"Magefan - solutions for Magento 2\" href=\"http://magefan.com/\" target=\"_blank\">Magefan</a> <a title=\"Magento 2 Blog extension\" href=\"https://magefan.com/magento2-blog-extension/\" target=\"_blank\">blog extension for Magento&reg; 2</a>. This is your first post. Edit or delete it, then start blogging!</p>\n<p><!-- pagebreak --></p>\n<p>Please also read&nbsp;<a title=\"Magento 2 Blog online documentation\" href=\"http://magefan.com/docs/magento-2-blog/\" target=\"_blank\">Online documentation</a>&nbsp;and&nbsp;<a href=\"http://magefan.com/blog/add-read-more-tag-to-blog-post-content/\" target=\"_blank\">How to add \"read more\" tag to post content</a></p>\n<p>Follow Magefan on:</p>\n<p><a title=\"Blog Extension for Magento 2 code\" href=\"https://github.com/magefan/module-blog\" target=\"_blank\">GitHub</a>&nbsp;|&nbsp;<a href=\"https://twitter.com/magento2fan\" target=\"_blank\">Twitter</a>&nbsp;|&nbsp;<a href=\"https://www.facebook.com/magefan/\" target=\"_blank\">Facebook</a>&nbsp;|&nbsp;<a href=\"https://plus.google.com/+Magefan_Magento_2/posts/\" target=\"_blank\">Google +</a></p>','2018-12-04 09:18:15','2018-12-04 09:18:15','2018-12-04 09:18:15',1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `magefan_blog_post_category`
--

CREATE TABLE `magefan_blog_post_category` (
  `post_id` int(11) NOT NULL COMMENT 'Post ID',
  `category_id` int(11) NOT NULL COMMENT 'Category ID',
  PRIMARY KEY (`post_id`,`category_id`),
  KEY `MAGEFAN_BLOG_POST_CATEGORY_CATEGORY_ID` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post To Category Linkage Table';

--
-- Dumping data for table `magefan_blog_post_category`
--


--
-- Table structure for table `magefan_blog_post_relatedpost`
--

CREATE TABLE `magefan_blog_post_relatedpost` (
  `post_id` int(11) NOT NULL COMMENT 'Post ID',
  `related_id` int(11) NOT NULL COMMENT 'Related Post ID',
  `position` int(11) NOT NULL COMMENT 'Position',
  PRIMARY KEY (`post_id`,`related_id`),
  KEY `MAGEFAN_BLOG_POST_RELATEDPRODUCT_RELATED_ID` (`related_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post To Post Linkage Table';

--
-- Dumping data for table `magefan_blog_post_relatedpost`
--


--
-- Table structure for table `magefan_blog_post_relatedproduct`
--

CREATE TABLE `magefan_blog_post_relatedproduct` (
  `post_id` int(11) NOT NULL COMMENT 'Post ID',
  `related_id` int(10) unsigned NOT NULL COMMENT 'Related Product ID',
  `position` int(11) NOT NULL COMMENT 'Position',
  PRIMARY KEY (`post_id`,`related_id`),
  KEY `MAGEFAN_BLOG_POST_RELATEDPRODUCT_RELATED_ID` (`related_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post To Product Linkage Table';

--
-- Dumping data for table `magefan_blog_post_relatedproduct`
--


--
-- Table structure for table `magefan_blog_post_store`
--

CREATE TABLE `magefan_blog_post_store` (
  `post_id` int(11) NOT NULL COMMENT 'Post ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`post_id`,`store_id`),
  KEY `MAGEFAN_BLOG_POST_STORE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post To Store Linkage Table';

--
-- Dumping data for table `magefan_blog_post_store`
--

INSERT INTO `magefan_blog_post_store` VALUES (1,0);

--
-- Table structure for table `magefan_blog_post_tag`
--

CREATE TABLE `magefan_blog_post_tag` (
  `post_id` int(11) NOT NULL COMMENT 'Post ID',
  `tag_id` int(11) NOT NULL COMMENT 'Tag ID',
  PRIMARY KEY (`post_id`,`tag_id`),
  KEY `MAGEFAN_BLOG_POST_TAG_TAG_ID` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post To Category Linkage Table';

--
-- Dumping data for table `magefan_blog_post_tag`
--


--
-- Table structure for table `magefan_blog_tag`
--

CREATE TABLE `magefan_blog_tag` (
  `tag_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Tag ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Tag Title',
  `meta_description` varchar(255) DEFAULT NULL COMMENT 'Tag Meta Description',
  `meta_keywords` varchar(255) DEFAULT NULL COMMENT 'Tag Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Tag Meta Title',
  `identifier` varchar(100) DEFAULT NULL COMMENT 'Tag String Identifier',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Tag Layout',
  `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Is Tag Active',
  `content` mediumtext COMMENT 'Tag Content',
  `layout_update_xml` text COMMENT 'Tag Layout Update Content',
  `custom_theme` varchar(100) DEFAULT NULL COMMENT 'Tag Custom Theme',
  `custom_layout` varchar(255) DEFAULT NULL COMMENT 'Tag Custom Template',
  `custom_layout_update_xml` text COMMENT 'Tag Custom Layout Update Content',
  `custom_theme_from` date DEFAULT NULL COMMENT 'Tag Custom Theme Active From Date',
  `custom_theme_to` date DEFAULT NULL COMMENT 'Tag Custom Theme Active To Date',
  PRIMARY KEY (`tag_id`),
  KEY `MAGEFAN_BLOG_TAG_IDENTIFIER` (`identifier`),
  KEY `MAGEFAN_BLOG_TAG_IS_ACTIVE` (`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Tag Table';

--
-- Dumping data for table `magefan_blog_tag`
--


--
-- Table structure for table `magento_acknowledged_bulk`
--

CREATE TABLE `magento_acknowledged_bulk` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Internal ID',
  `bulk_uuid` varbinary(39) DEFAULT NULL COMMENT 'Related Bulk UUID',
  PRIMARY KEY (`id`),
  UNIQUE KEY `MAGENTO_ACKNOWLEDGED_BULK_BULK_UUID` (`bulk_uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Bulk that was viewed by user from notification area';

--
-- Dumping data for table `magento_acknowledged_bulk`
--


--
-- Table structure for table `magento_bulk`
--

CREATE TABLE `magento_bulk` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Bulk Internal ID (must not be exposed)',
  `uuid` varbinary(39) DEFAULT NULL COMMENT 'Bulk UUID (can be exposed to reference bulk entity)',
  `user_id` int(10) unsigned DEFAULT NULL COMMENT 'ID of the WebAPI user that performed an action',
  `user_type` int(11) DEFAULT NULL COMMENT 'Which type of user',
  `description` varchar(255) DEFAULT NULL COMMENT 'Bulk Description',
  `operation_count` int(10) unsigned NOT NULL COMMENT 'Total number of operations scheduled within this bulk',
  `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Bulk start time',
  PRIMARY KEY (`id`),
  UNIQUE KEY `MAGENTO_BULK_UUID` (`uuid`),
  KEY `MAGENTO_BULK_USER_ID` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Bulk entity that represents set of related asynchronous operations';

--
-- Dumping data for table `magento_bulk`
--


--
-- Table structure for table `magento_operation`
--

CREATE TABLE `magento_operation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Operation ID',
  `bulk_uuid` varbinary(39) DEFAULT NULL COMMENT 'Related Bulk UUID',
  `topic_name` varchar(255) DEFAULT NULL COMMENT 'Name of the related message queue topic',
  `serialized_data` blob COMMENT 'Data (serialized) required to perform an operation',
  `result_serialized_data` blob COMMENT 'Result data (serialized) after perform an operation',
  `status` smallint(6) DEFAULT '0' COMMENT 'Operation status (OPEN | COMPLETE | RETRIABLY_FAILED | NOT_RETRIABLY_FAILED)',
  `error_code` smallint(6) DEFAULT NULL COMMENT 'Code of the error that appeared during operation execution (used to aggregate related failed operations)',
  `result_message` varchar(255) DEFAULT NULL COMMENT 'Operation result message',
  PRIMARY KEY (`id`),
  KEY `MAGENTO_OPERATION_BULK_UUID_ERROR_CODE` (`bulk_uuid`,`error_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Operation entity';

--
-- Dumping data for table `magento_operation`
--


--
-- Table structure for table `magscache`
--

CREATE TABLE `magscache` (
  `id` varchar(200) NOT NULL COMMENT 'Cache Id',
  `data` mediumblob COMMENT 'Cache Data',
  `create_time` int(11) DEFAULT NULL COMMENT 'Cache Creation Time',
  `update_time` int(11) DEFAULT NULL COMMENT 'Time of Cache Updating',
  `expire_time` int(11) DEFAULT NULL COMMENT 'Cache Expiration Time',
  PRIMARY KEY (`id`),
  KEY `MAGSCACHE_EXPIRE_TIME` (`expire_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Caches';

--
-- Dumping data for table `magscache`
--


--
-- Table structure for table `magscache_tag`
--

CREATE TABLE `magscache_tag` (
  `tag` varchar(100) NOT NULL COMMENT 'Tag',
  `cache_id` varchar(200) NOT NULL COMMENT 'Cache Id',
  PRIMARY KEY (`tag`,`cache_id`),
  KEY `MAGSCACHE_TAG_CACHE_ID` (`cache_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tag Caches';

--
-- Dumping data for table `magscache_tag`
--


--
-- Table structure for table `magsflag`
--

CREATE TABLE `magsflag` (
  `flag_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Flag Id',
  `flag_code` varchar(255) NOT NULL COMMENT 'Flag Code',
  `state` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Flag State',
  `flag_data` text COMMENT 'Flag Data',
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date of Last Flag Update',
  PRIMARY KEY (`flag_id`),
  KEY `MAGSFLAG_LAST_UPDATE` (`last_update`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Flag';

--
-- Dumping data for table `magsflag`
--


--
-- Table structure for table `magssession`
--

CREATE TABLE `magssession` (
  `session_id` varchar(255) NOT NULL COMMENT 'Session Id',
  `session_expires` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Date of Session Expiration',
  `session_data` mediumblob NOT NULL COMMENT 'Session Data',
  PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Database Sessions Storage';

--
-- Dumping data for table `magssession`
--


--
-- Table structure for table `magssetup_module`
--

CREATE TABLE `magssetup_module` (
  `module` varchar(50) NOT NULL COMMENT 'Module',
  `schema_version` varchar(50) DEFAULT NULL COMMENT 'Schema Version',
  `data_version` varchar(50) DEFAULT NULL COMMENT 'Data Version',
  PRIMARY KEY (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Module versions registry';

--
-- Dumping data for table `magssetup_module`
--


--
-- Table structure for table `msp_tfa_country_codes`
--

CREATE TABLE `msp_tfa_country_codes` (
  `msp_tfa_country_codes_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'TFA admin user ID',
  `code` text NOT NULL COMMENT 'Country code',
  `name` text NOT NULL COMMENT 'Country name',
  `dial_code` text NOT NULL COMMENT 'Prefix',
  PRIMARY KEY (`msp_tfa_country_codes_id`),
  KEY `MSP_TFA_COUNTRY_CODES_CODE` (`code`(128))
) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=utf8 COMMENT='msp_tfa_country_codes';

--
-- Dumping data for table `msp_tfa_country_codes`
--

INSERT INTO `msp_tfa_country_codes` VALUES (1,'IL','Israel','+972'),(2,'AF','Afghanistan','+93'),(3,'AL','Albania','+355'),(4,'DZ','Algeria','+213'),(5,'AS','AmericanSamoa','+1 684'),(6,'AD','Andorra','+376'),(7,'AO','Angola','+244'),(8,'AI','Anguilla','+1 264'),(9,'AG','Antigua and Barbuda','+1268'),(10,'AR','Argentina','+54'),(11,'AM','Armenia','+374'),(12,'AW','Aruba','+297'),(13,'AU','Australia','+61'),(14,'AT','Austria','+43'),(15,'AZ','Azerbaijan','+994'),(16,'BS','Bahamas','+1 242'),(17,'BH','Bahrain','+973'),(18,'BD','Bangladesh','+880'),(19,'BB','Barbados','+1 246'),(20,'BY','Belarus','+375'),(21,'BE','Belgium','+32'),(22,'BZ','Belize','+501'),(23,'BJ','Benin','+229'),(24,'BM','Bermuda','+1 441'),(25,'BT','Bhutan','+975'),(26,'BA','Bosnia and Herzegovina','+387'),(27,'BW','Botswana','+267'),(28,'BR','Brazil','+55'),(29,'IO','British Indian Ocean Territory','+246'),(30,'BG','Bulgaria','+359'),(31,'BF','Burkina Faso','+226'),(32,'BI','Burundi','+257'),(33,'KH','Cambodia','+855'),(34,'CM','Cameroon','+237'),(35,'CA','Canada','+1'),(36,'CV','Cape Verde','+238'),(37,'KY','Cayman Islands','+ 345'),(38,'CF','Central African Republic','+236'),(39,'TD','Chad','+235'),(40,'CL','Chile','+56'),(41,'CN','China','+86'),(42,'CX','Christmas Island','+61'),(43,'CO','Colombia','+57'),(44,'KM','Comoros','+269'),(45,'CG','Congo','+242'),(46,'CK','Cook Islands','+682'),(47,'CR','Costa Rica','+506'),(48,'HR','Croatia','+385'),(49,'CU','Cuba','+53'),(50,'CY','Cyprus','+537'),(51,'CZ','Czech Republic','+420'),(52,'DK','Denmark','+45'),(53,'DJ','Djibouti','+253'),(54,'DM','Dominica','+1 767'),(55,'DO','Dominican Republic','+1 849'),(56,'EC','Ecuador','+593'),(57,'EG','Egypt','+20'),(58,'SV','El Salvador','+503'),(59,'GQ','Equatorial Guinea','+240'),(60,'ER','Eritrea','+291'),(61,'EE','Estonia','+372'),(62,'ET','Ethiopia','+251'),(63,'FO','Faroe Islands','+298'),(64,'FJ','Fiji','+679'),(65,'FI','Finland','+358'),(66,'FR','France','+33'),(67,'GF','French Guiana','+594'),(68,'PF','French Polynesia','+689'),(69,'GA','Gabon','+241'),(70,'GM','Gambia','+220'),(71,'GE','Georgia','+995'),(72,'DE','Germany','+49'),(73,'GH','Ghana','+233'),(74,'GI','Gibraltar','+350'),(75,'GR','Greece','+30'),(76,'GL','Greenland','+299'),(77,'GD','Grenada','+1 473'),(78,'GP','Guadeloupe','+590'),(79,'GU','Guam','+1 671'),(80,'GT','Guatemala','+502'),(81,'GN','Guinea','+224'),(82,'GW','Guinea-Bissau','+245'),(83,'GY','Guyana','+595'),(84,'HT','Haiti','+509'),(85,'HN','Honduras','+504'),(86,'HU','Hungary','+36'),(87,'IS','Iceland','+354'),(88,'IN','India','+91'),(89,'ID','Indonesia','+62'),(90,'IQ','Iraq','+964'),(91,'IE','Ireland','+353'),(92,'IL','Israel','+972'),(93,'IT','Italy','+39'),(94,'JM','Jamaica','+1 876'),(95,'JP','Japan','+81'),(96,'JO','Jordan','+962'),(97,'KZ','Kazakhstan','+7 7'),(98,'KE','Kenya','+254'),(99,'KI','Kiribati','+686'),(100,'KW','Kuwait','+965'),(101,'KG','Kyrgyzstan','+996'),(102,'LV','Latvia','+371'),(103,'LB','Lebanon','+961'),(104,'LS','Lesotho','+266'),(105,'LR','Liberia','+231'),(106,'LI','Liechtenstein','+423'),(107,'LT','Lithuania','+370'),(108,'LU','Luxembourg','+352'),(109,'MG','Madagascar','+261'),(110,'MW','Malawi','+265'),(111,'MY','Malaysia','+60'),(112,'MV','Maldives','+960'),(113,'ML','Mali','+223'),(114,'MT','Malta','+356'),(115,'MH','Marshall Islands','+692'),(116,'MQ','Martinique','+596'),(117,'MR','Mauritania','+222'),(118,'MU','Mauritius','+230'),(119,'YT','Mayotte','+262'),(120,'MX','Mexico','+52'),(121,'MC','Monaco','+377'),(122,'MN','Mongolia','+976'),(123,'ME','Montenegro','+382'),(124,'MS','Montserrat','+1664'),(125,'MA','Morocco','+212'),(126,'MM','Myanmar','+95'),(127,'NA','Namibia','+264'),(128,'NR','Nauru','+674'),(129,'NP','Nepal','+977'),(130,'NL','Netherlands','+31'),(131,'AN','Netherlands Antilles','+599'),(132,'NC','New Caledonia','+687'),(133,'NZ','New Zealand','+64'),(134,'NI','Nicaragua','+505'),(135,'NE','Niger','+227'),(136,'NG','Nigeria','+234'),(137,'NU','Niue','+683'),(138,'NF','Norfolk Island','+672'),(139,'MP','Northern Mariana Islands','+1 670'),(140,'NO','Norway','+47'),(141,'OM','Oman','+968'),(142,'PK','Pakistan','+92'),(143,'PW','Palau','+680'),(144,'PA','Panama','+507'),(145,'PG','Papua New Guinea','+675'),(146,'PY','Paraguay','+595'),(147,'PE','Peru','+51'),(148,'PH','Philippines','+63'),(149,'PL','Poland','+48'),(150,'PT','Portugal','+351'),(151,'PR','Puerto Rico','+1 939'),(152,'QA','Qatar','+974'),(153,'RO','Romania','+40'),(154,'RW','Rwanda','+250'),(155,'WS','Samoa','+685'),(156,'SM','San Marino','+378'),(157,'SA','Saudi Arabia','+966'),(158,'SN','Senegal','+221'),(159,'RS','Serbia','+381'),(160,'SC','Seychelles','+248'),(161,'SL','Sierra Leone','+232'),(162,'SG','Singapore','+65'),(163,'SK','Slovakia','+421'),(164,'SI','Slovenia','+386'),(165,'SB','Solomon Islands','+677'),(166,'ZA','South Africa','+27'),(167,'GS','South Georgia and the South Sandwich Islands','+500'),(168,'ES','Spain','+34'),(169,'LK','Sri Lanka','+94'),(170,'SD','Sudan','+249'),(171,'SR','Suriname','+597'),(172,'SZ','Swaziland','+268'),(173,'SE','Sweden','+46'),(174,'CH','Switzerland','+41'),(175,'TJ','Tajikistan','+992'),(176,'TH','Thailand','+66'),(177,'TG','Togo','+228'),(178,'TK','Tokelau','+690'),(179,'TO','Tonga','+676'),(180,'TT','Trinidad and Tobago','+1 868'),(181,'TN','Tunisia','+216'),(182,'TR','Turkey','+90'),(183,'TM','Turkmenistan','+993'),(184,'TC','Turks and Caicos Islands','+1 649'),(185,'TV','Tuvalu','+688'),(186,'UG','Uganda','+256'),(187,'UA','Ukraine','+380'),(188,'AE','United Arab Emirates','+971'),(189,'GB','United Kingdom','+44'),(190,'US','United States','+1'),(191,'UY','Uruguay','+598'),(192,'UZ','Uzbekistan','+998'),(193,'VU','Vanuatu','+678'),(194,'WF','Wallis and Futuna','+681'),(195,'YE','Yemen','+967'),(196,'ZM','Zambia','+260'),(197,'ZW','Zimbabwe','+263'),(198,'AX','land Islands',''),(199,'BO','Bolivia, Plurinational State of','+591'),(200,'BN','Brunei Darussalam','+673'),(201,'CC','Cocos (Keeling) Islands','+61'),(202,'CD','Congo, The Democratic Republic of the','+243'),(203,'CI','Cote d\'Ivoire','+225'),(204,'FK','Falkland Islands (Malvinas)','+500'),(205,'GG','Guernsey','+44'),(206,'VA','Holy See (Vatican City State)','+379'),(207,'HK','Hong Kong','+852'),(208,'IR','Iran, Islamic Republic of','+98'),(209,'IM','Isle of Man','+44'),(210,'JE','Jersey','+44'),(211,'KP','Korea, Democratic People\'s Republic of','+850'),(212,'KR','Korea, Republic of','+82'),(213,'LA','Lao People\'s Democratic Republic','+856'),(214,'LY','Libyan Arab Jamahiriya','+218'),(215,'MO','Macao','+853'),(216,'MK','Macedonia, The Former Yugoslav Republic of','+389'),(217,'FM','Micronesia, Federated States of','+691'),(218,'MD','Moldova, Republic of','+373'),(219,'MZ','Mozambique','+258'),(220,'PS','Palestinian Territory, Occupied','+970'),(221,'PN','Pitcairn','+872'),(222,'RE','Réunion','+262'),(223,'RU','Russia','+7'),(224,'BL','Saint Barthélemy','+590'),(225,'SH','Saint Helena, Ascension and Tristan Da Cunha','+290'),(226,'KN','Saint Kitts and Nevis','+1 869'),(227,'LC','Saint Lucia','+1 758'),(228,'MF','Saint Martin','+590'),(229,'PM','Saint Pierre and Miquelon','+508'),(230,'VC','Saint Vincent and the Grenadines','+1 784'),(231,'ST','Sao Tome and Principe','+239'),(232,'SO','Somalia','+252'),(233,'SJ','Svalbard and Jan Mayen','+47'),(234,'SY','Syrian Arab Republic','+963'),(235,'TW','Taiwan, Province of China','+886'),(236,'TZ','Tanzania, United Republic of','+255'),(237,'TL','Timor-Leste','+670'),(238,'VE','Venezuela, Bolivarian Republic of','+58'),(239,'VN','Viet Nam','+84'),(240,'VG','Virgin Islands, British','+1 284'),(241,'VI','Virgin Islands, U.S.','+1 340');

--
-- Table structure for table `msp_tfa_trusted`
--

CREATE TABLE `msp_tfa_trusted` (
  `msp_tfa_trusted_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Trusted device ID',
  `date_time` datetime NOT NULL COMMENT 'Date and time',
  `user_id` int(10) unsigned NOT NULL COMMENT 'User ID',
  `device_name` text NOT NULL COMMENT 'Device name',
  `token` text NOT NULL COMMENT 'Token',
  `last_ip` text NOT NULL COMMENT 'Last IP',
  PRIMARY KEY (`msp_tfa_trusted_id`),
  KEY `MSP_TFA_TRUSTED_USER_ID_ADMIN_USER_USER_ID` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='msp_tfa_trusted';

--
-- Dumping data for table `msp_tfa_trusted`
--


--
-- Table structure for table `msp_tfa_user_config`
--

CREATE TABLE `msp_tfa_user_config` (
  `msp_tfa_user_config_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'TFA admin user ID',
  `user_id` int(10) unsigned NOT NULL COMMENT 'User ID',
  `encoded_providers` text COMMENT 'Encoded providers list',
  `encoded_config` text COMMENT 'Encoded providers configuration',
  `default_provider` text COMMENT 'Default provider',
  PRIMARY KEY (`msp_tfa_user_config_id`),
  KEY `MSP_TFA_USER_CONFIG_USER_ID_ADMIN_USER_USER_ID` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='msp_tfa_user_config';

--
-- Dumping data for table `msp_tfa_user_config`
--


--
-- Table structure for table `mview_state`
--

CREATE TABLE `mview_state` (
  `state_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'View State Id',
  `view_id` varchar(255) DEFAULT NULL COMMENT 'View Id',
  `mode` varchar(16) DEFAULT 'disabled' COMMENT 'View Mode',
  `status` varchar(16) DEFAULT 'idle' COMMENT 'View Status',
  `updated` datetime DEFAULT NULL COMMENT 'View updated time',
  `version_id` int(10) unsigned DEFAULT NULL COMMENT 'View Version Id',
  PRIMARY KEY (`state_id`),
  KEY `MVIEW_STATE_VIEW_ID` (`view_id`),
  KEY `MVIEW_STATE_MODE` (`mode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='View State';

--
-- Dumping data for table `mview_state`
--


--
-- Table structure for table `newsletter_problem`
--

CREATE TABLE `newsletter_problem` (
  `problem_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Problem Id',
  `subscriber_id` int(10) unsigned DEFAULT NULL COMMENT 'Subscriber Id',
  `queue_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Queue Id',
  `problem_error_code` int(10) unsigned DEFAULT '0' COMMENT 'Problem Error Code',
  `problem_error_text` varchar(200) DEFAULT NULL COMMENT 'Problem Error Text',
  PRIMARY KEY (`problem_id`),
  KEY `NEWSLETTER_PROBLEM_SUBSCRIBER_ID` (`subscriber_id`),
  KEY `NEWSLETTER_PROBLEM_QUEUE_ID` (`queue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Problems';

--
-- Dumping data for table `newsletter_problem`
--


--
-- Table structure for table `newsletter_queue`
--

CREATE TABLE `newsletter_queue` (
  `queue_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Queue Id',
  `template_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Template ID',
  `newsletter_type` int(11) DEFAULT NULL COMMENT 'Newsletter Type',
  `newsletter_text` text COMMENT 'Newsletter Text',
  `newsletter_styles` text COMMENT 'Newsletter Styles',
  `newsletter_subject` varchar(200) DEFAULT NULL COMMENT 'Newsletter Subject',
  `newsletter_sender_name` varchar(200) DEFAULT NULL COMMENT 'Newsletter Sender Name',
  `newsletter_sender_email` varchar(200) DEFAULT NULL COMMENT 'Newsletter Sender Email',
  `queue_status` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Queue Status',
  `queue_start_at` timestamp NULL DEFAULT NULL COMMENT 'Queue Start At',
  `queue_finish_at` timestamp NULL DEFAULT NULL COMMENT 'Queue Finish At',
  PRIMARY KEY (`queue_id`),
  KEY `NEWSLETTER_QUEUE_TEMPLATE_ID` (`template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Queue';

--
-- Dumping data for table `newsletter_queue`
--


--
-- Table structure for table `newsletter_queue_link`
--

CREATE TABLE `newsletter_queue_link` (
  `queue_link_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Queue Link Id',
  `queue_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Queue Id',
  `subscriber_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Subscriber Id',
  `letter_sent_at` timestamp NULL DEFAULT NULL COMMENT 'Letter Sent At',
  PRIMARY KEY (`queue_link_id`),
  KEY `NEWSLETTER_QUEUE_LINK_SUBSCRIBER_ID` (`subscriber_id`),
  KEY `NEWSLETTER_QUEUE_LINK_QUEUE_ID_LETTER_SENT_AT` (`queue_id`,`letter_sent_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Queue Link';

--
-- Dumping data for table `newsletter_queue_link`
--


--
-- Table structure for table `newsletter_queue_store_link`
--

CREATE TABLE `newsletter_queue_store_link` (
  `queue_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Queue Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  PRIMARY KEY (`queue_id`,`store_id`),
  KEY `NEWSLETTER_QUEUE_STORE_LINK_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Queue Store Link';

--
-- Dumping data for table `newsletter_queue_store_link`
--


--
-- Table structure for table `newsletter_subscriber`
--

CREATE TABLE `newsletter_subscriber` (
  `subscriber_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Subscriber Id',
  `store_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Store Id',
  `change_status_at` timestamp NULL DEFAULT NULL COMMENT 'Change Status At',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer Id',
  `subscriber_email` varchar(150) DEFAULT NULL COMMENT 'Subscriber Email',
  `subscriber_status` int(11) NOT NULL DEFAULT '0' COMMENT 'Subscriber Status',
  `subscriber_confirm_code` varchar(32) DEFAULT 'NULL' COMMENT 'Subscriber Confirm Code',
  PRIMARY KEY (`subscriber_id`),
  KEY `NEWSLETTER_SUBSCRIBER_CUSTOMER_ID` (`customer_id`),
  KEY `NEWSLETTER_SUBSCRIBER_STORE_ID` (`store_id`),
  KEY `NEWSLETTER_SUBSCRIBER_SUBSCRIBER_EMAIL` (`subscriber_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Subscriber';

--
-- Dumping data for table `newsletter_subscriber`
--


--
-- Table structure for table `newsletter_template`
--

CREATE TABLE `newsletter_template` (
  `template_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Template ID',
  `template_code` varchar(150) DEFAULT NULL COMMENT 'Template Code',
  `template_text` text COMMENT 'Template Text',
  `template_styles` text COMMENT 'Template Styles',
  `template_type` int(10) unsigned DEFAULT NULL COMMENT 'Template Type',
  `template_subject` varchar(200) DEFAULT NULL COMMENT 'Template Subject',
  `template_sender_name` varchar(200) DEFAULT NULL COMMENT 'Template Sender Name',
  `template_sender_email` varchar(200) DEFAULT NULL COMMENT 'Template Sender Email',
  `template_actual` smallint(5) unsigned DEFAULT '1' COMMENT 'Template Actual',
  `added_at` timestamp NULL DEFAULT NULL COMMENT 'Added At',
  `modified_at` timestamp NULL DEFAULT NULL COMMENT 'Modified At',
  PRIMARY KEY (`template_id`),
  KEY `NEWSLETTER_TEMPLATE_TEMPLATE_ACTUAL` (`template_actual`),
  KEY `NEWSLETTER_TEMPLATE_ADDED_AT` (`added_at`),
  KEY `NEWSLETTER_TEMPLATE_MODIFIED_AT` (`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Template';

--
-- Dumping data for table `newsletter_template`
--


--
-- Table structure for table `oauth_consumer`
--

CREATE TABLE `oauth_consumer` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `name` varchar(255) NOT NULL COMMENT 'Name of consumer',
  `key` varchar(32) NOT NULL COMMENT 'Key code',
  `secret` varchar(32) NOT NULL COMMENT 'Secret code',
  `callback_url` text COMMENT 'Callback URL',
  `rejected_callback_url` text NOT NULL COMMENT 'Rejected callback URL',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `OAUTH_CONSUMER_KEY` (`key`),
  UNIQUE KEY `OAUTH_CONSUMER_SECRET` (`secret`),
  KEY `OAUTH_CONSUMER_CREATED_AT` (`created_at`),
  KEY `OAUTH_CONSUMER_UPDATED_AT` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OAuth Consumers';

--
-- Dumping data for table `oauth_consumer`
--


--
-- Table structure for table `oauth_nonce`
--

CREATE TABLE `oauth_nonce` (
  `nonce` varchar(32) NOT NULL COMMENT 'Nonce String',
  `timestamp` int(10) unsigned NOT NULL COMMENT 'Nonce Timestamp',
  `consumer_id` int(10) unsigned NOT NULL COMMENT 'Consumer ID',
  UNIQUE KEY `OAUTH_NONCE_NONCE_CONSUMER_ID` (`nonce`,`consumer_id`),
  KEY `OAUTH_NONCE_CONSUMER_ID_OAUTH_CONSUMER_ENTITY_ID` (`consumer_id`),
  KEY `OAUTH_NONCE_TIMESTAMP` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OAuth Nonce';

--
-- Dumping data for table `oauth_nonce`
--


--
-- Table structure for table `oauth_token`
--

CREATE TABLE `oauth_token` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `consumer_id` int(10) unsigned DEFAULT NULL COMMENT 'Oauth Consumer ID',
  `admin_id` int(10) unsigned DEFAULT NULL COMMENT 'Admin user ID',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer user ID',
  `type` varchar(16) NOT NULL COMMENT 'Token Type',
  `token` varchar(32) NOT NULL COMMENT 'Token',
  `secret` varchar(32) NOT NULL COMMENT 'Token Secret',
  `verifier` varchar(32) DEFAULT NULL COMMENT 'Token Verifier',
  `callback_url` text NOT NULL COMMENT 'Token Callback URL',
  `revoked` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Token revoked',
  `authorized` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Token authorized',
  `user_type` int(11) DEFAULT NULL COMMENT 'User type',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Token creation timestamp',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `OAUTH_TOKEN_TOKEN` (`token`),
  KEY `OAUTH_TOKEN_ADMIN_ID_ADMIN_USER_USER_ID` (`admin_id`),
  KEY `OAUTH_TOKEN_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`customer_id`),
  KEY `OAUTH_TOKEN_CONSUMER_ID` (`consumer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OAuth Tokens';

--
-- Dumping data for table `oauth_token`
--


--
-- Table structure for table `oauth_token_request_log`
--

CREATE TABLE `oauth_token_request_log` (
  `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log Id',
  `user_name` varchar(255) NOT NULL COMMENT 'Customer email or admin login',
  `user_type` smallint(5) unsigned NOT NULL COMMENT 'User type (admin or customer)',
  `failures_count` smallint(5) unsigned DEFAULT '0' COMMENT 'Number of failed authentication attempts in a row',
  `lock_expires_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Lock expiration time',
  PRIMARY KEY (`log_id`),
  UNIQUE KEY `OAUTH_TOKEN_REQUEST_LOG_USER_NAME_USER_TYPE` (`user_name`,`user_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Log of token request authentication failures.';

--
-- Dumping data for table `oauth_token_request_log`
--


--
-- Table structure for table `password_reset_request_event`
--

CREATE TABLE `password_reset_request_event` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `request_type` smallint(5) unsigned NOT NULL COMMENT 'Type of the event under a security control',
  `account_reference` varchar(255) DEFAULT NULL COMMENT 'An identifier for existing account or another target',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Timestamp when the event occurs',
  `ip` varchar(15) NOT NULL COMMENT 'Remote user IP',
  PRIMARY KEY (`id`),
  KEY `PASSWORD_RESET_REQUEST_EVENT_ACCOUNT_REFERENCE` (`account_reference`),
  KEY `PASSWORD_RESET_REQUEST_EVENT_CREATED_AT` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Password Reset Request Event under a security control';

--
-- Dumping data for table `password_reset_request_event`
--


--
-- Table structure for table `patch_list`
--

CREATE TABLE `patch_list` (
  `patch_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Patch Auto Increment',
  `patch_name` varchar(1024) NOT NULL COMMENT 'Patch Class Name',
  PRIMARY KEY (`patch_id`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8 COMMENT='List of data/schema patches';

--
-- Dumping data for table `patch_list`
--

INSERT INTO `patch_list` VALUES (1,'Magento\\Store\\Setup\\Patch\\Schema\\InitializeStoresAndWebsites'),(2,'Magento\\Catalog\\Setup\\Patch\\Schema\\EnableSegmentation'),(3,'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\CreateLegacyStockStatusView'),(4,'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\InitializeDefaultStock'),(5,'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\UpdateInventorySourceItem'),(6,'Magento\\InventoryCatalog\\Setup\\Patch\\Schema\\ReindexDefaultSource'),(7,'Magento\\Store\\Setup\\Patch\\Schema\\InitializeStoresAndWebsites'),(8,'Magento\\InventorySales\\Setup\\Patch\\Schema\\InitializeWebsiteDefaultSock'),(9,'Magento\\Bundle\\Setup\\Patch\\Schema\\UpdateBundleRelatedSchema'),(10,'Magento\\Store\\Setup\\Patch\\Data\\UpdateStoreGroupCodes'),(11,'Magento\\Directory\\Setup\\Patch\\Data\\InitializeDirectoryData'),(12,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForCroatia'),(13,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForIndia'),(14,'Magento\\Theme\\Setup\\Patch\\Data\\RegisterThemes'),(15,'Magento\\Theme\\Setup\\Patch\\Data\\ConvertSerializedData'),(16,'Magento\\Eav\\Setup\\Patch\\Data\\InitializeAttributeModels'),(17,'Magento\\Config\\Setup\\Patch\\Data\\UpdateClassAliases'),(18,'Magento\\Indexer\\Setup\\Patch\\Data\\InitializeIndexerState'),(19,'Magento\\User\\Setup\\Patch\\Data\\UpgradePasswordHashes'),(20,'Magento\\User\\Setup\\Patch\\Data\\UpgradeSerializedFields'),(21,'Magento\\Authorization\\Setup\\Patch\\Data\\InitializeAuthRoles'),(22,'Magento\\Customer\\Setup\\Patch\\Data\\DefaultCustomerGroupsAndAttributes'),(23,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateCustomerAttributesMetadata'),(24,'Magento\\Customer\\Setup\\Patch\\Data\\AddNonSpecifiedGenderAttributeOption'),(25,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateIdentifierCustomerAttributesVisibility'),(26,'Magento\\Customer\\Setup\\Patch\\Data\\AddCustomerUpdatedAtAttribute'),(27,'Magento\\Customer\\Setup\\Patch\\Data\\UpgradePasswordHashAndAddress'),(28,'Magento\\Customer\\Setup\\Patch\\Data\\RemoveCheckoutRegisterAndUpdateAttributes'),(29,'Magento\\Customer\\Setup\\Patch\\Data\\AddSecurityTrackingAttributes'),(30,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateAutocompleteOnStorefrontConfigPath'),(31,'Magento\\Customer\\Setup\\Patch\\Data\\MigrateStoresAllowedCountriesToWebsite'),(32,'Magento\\Customer\\Setup\\Patch\\Data\\ConvertValidationRulesFromSerializedToJson'),(33,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateVATNumber'),(34,'Magento\\Customer\\Setup\\Patch\\Data\\UpdateCustomerAttributeInputFilters'),(35,'Magento\\Cms\\Setup\\Patch\\Data\\CreateDefaultPages'),(36,'Magento\\Cms\\Setup\\Patch\\Data\\UpdatePrivacyPolicyPage'),(37,'Magento\\Cms\\Setup\\Patch\\Data\\ConvertWidgetConditionsToJson'),(38,'Magento\\Catalog\\Setup\\Patch\\Data\\InstallDefaultCategories'),(39,'Magento\\Catalog\\Setup\\Patch\\Data\\SetNewResourceModelsPaths'),(40,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateDefaultAttributeValue'),(41,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateMediaAttributesBackendTypes'),(42,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateProductAttributes'),(43,'Magento\\Catalog\\Setup\\Patch\\Data\\UpdateProductMetaDescription'),(44,'Magento\\Catalog\\Setup\\Patch\\Data\\ChangePriceAttributeDefaultScope'),(45,'Magento\\Catalog\\Setup\\Patch\\Data\\DisallowUsingHtmlForProductName'),(46,'Magento\\Catalog\\Setup\\Patch\\Data\\EnableDirectiveParsing'),(47,'Magento\\Catalog\\Setup\\Patch\\Data\\EnableSegmentation'),(48,'Magento\\Catalog\\Setup\\Patch\\Data\\UpgradeWidgetData'),(49,'Magento\\Catalog\\Setup\\Patch\\Data\\UpgradeWebsiteAttributes'),(50,'Magento\\Quote\\Setup\\Patch\\Data\\InstallEntityTypes'),(51,'Magento\\Quote\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(52,'Magento\\Integration\\Setup\\Patch\\Data\\RemoveInactiveTokens'),(53,'Magento\\CatalogInventory\\Setup\\Patch\\Data\\CreateDefaultStock'),(54,'Magento\\CatalogInventory\\Setup\\Patch\\Data\\UpdateStockItemsWebsite'),(55,'Magento\\CatalogInventory\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(56,'Magento\\Msrp\\Setup\\Patch\\Data\\InitializeMsrpAttributes'),(57,'Magento\\Msrp\\Setup\\Patch\\Data\\ChangePriceAttributeDefaultScope'),(58,'Magento\\CatalogRule\\Setup\\Patch\\Data\\UpdateClassAliasesForCatalogRules'),(59,'Magento\\CatalogRule\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(60,'Magento\\CatalogUrlRewrite\\Setup\\Patch\\Data\\CreateUrlAttributes'),(61,'Magento\\Widget\\Setup\\Patch\\Data\\UpgradeModelInstanceClassAliases'),(62,'Magento\\Widget\\Setup\\Patch\\Data\\ConvertSerializedData'),(63,'Magento\\Sales\\Setup\\Patch\\Data\\InstallOrderStatusesAndInitialSalesConfig'),(64,'Magento\\Sales\\Setup\\Patch\\Data\\UpdateEntityTypes'),(65,'Magento\\Sales\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(66,'Magento\\Sales\\Setup\\Patch\\Data\\FillQuoteAddressIdInSalesOrderAddress'),(67,'Magento\\Sales\\Setup\\Patch\\Data\\UpdateEntityTypeModelForInvoice'),(68,'Magento\\Checkout\\Setup\\Patch\\Data\\PrepareInitialCheckoutConfiguration'),(69,'Magento\\Vault\\Setup\\Patch\\Data\\SetCreditCardAsDefaultTokenType'),(70,'Magento\\ConfigurableProduct\\Setup\\Patch\\Data\\InstallInitialConfigurableAttributes'),(71,'Magento\\ConfigurableProduct\\Setup\\Patch\\Data\\UpdateManufacturerAttribute'),(72,'Magento\\ConfigurableProduct\\Setup\\Patch\\Data\\UpdateTierPriceAttribute'),(73,'Magento\\CurrencySymbol\\Setup\\Patch\\Data\\ConvertSerializedCustomCurrencySymbolToJson'),(74,'Magento\\Paypal\\Setup\\Patch\\Data\\AddPaypalOrderStatuses'),(75,'Magento\\Analytics\\Setup\\Patch\\Data\\PrepareInitialConfig'),(76,'Magento\\Dhl\\Setup\\Patch\\Data\\PrepareShipmentDays'),(77,'Magento\\Downloadable\\Setup\\Patch\\Data\\InstallDownloadableAttributes'),(78,'Magento\\CatalogSearch\\Setup\\Patch\\Data\\MySQLSearchDeprecationNotification'),(79,'Magento\\Wishlist\\Setup\\Patch\\Schema\\AddProductIdConstraint'),(80,'Magento\\Directory\\Setup\\Patch\\Data\\AddDataForAustralia'),(81,'Magento\\Bundle\\Setup\\Patch\\Data\\ApplyAttributesUpdate'),(82,'Magento\\Bundle\\Setup\\Patch\\Data\\UpdateBundleRelatedEntityTytpes'),(83,'Magento\\CatalogSearch\\Setup\\Patch\\Data\\SetInitialSearchWeightForAttributes'),(84,'Magento\\EncryptionKey\\Setup\\Patch\\Data\\SodiumChachaPatch'),(85,'Magento\\Fedex\\Setup\\Patch\\Data\\ConfigureFedexDefaults'),(86,'Magento\\GiftMessage\\Setup\\Patch\\Data\\AddGiftMessageAttributes'),(87,'Magento\\GiftMessage\\Setup\\Patch\\Data\\MoveGiftMessageToGiftOptionsGroup'),(88,'Magento\\GiftMessage\\Setup\\Patch\\Data\\UpdateGiftMessageAttribute'),(89,'Magento\\GroupedProduct\\Setup\\Patch\\Data\\InitializeGroupedProductLinks'),(90,'Magento\\GroupedProduct\\Setup\\Patch\\Data\\UpdateProductRelations'),(91,'Magento\\SalesRule\\Setup\\Patch\\Data\\PrepareRuleModelSerializedData'),(92,'Magento\\SalesRule\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(93,'Magento\\SalesRule\\Setup\\Patch\\Data\\FillSalesRuleProductAttributeTable'),(94,'Magento\\Reports\\Setup\\Patch\\Data\\InitializeReportEntityTypesAndPages'),(95,'Magento\\Review\\Setup\\Patch\\Data\\InitReviewStatusesAndData'),(96,'Magento\\OfflineShipping\\Setup\\Patch\\Data\\UpdateQuoteShippingAddresses'),(97,'Magento\\UrlRewrite\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(98,'Magento\\Swatches\\Setup\\Patch\\Data\\AddSwatchImageAttribute'),(99,'Magento\\Swatches\\Setup\\Patch\\Data\\AddSwatchImageToDefaultAttribtueSet'),(100,'Magento\\Swatches\\Setup\\Patch\\Data\\UpdateAdminTextSwatchValues'),(101,'Magento\\Swatches\\Setup\\Patch\\Data\\ConvertAdditionalDataToJson'),(102,'Magento\\Tax\\Setup\\Patch\\Data\\AddTaxAttributeAndTaxClasses'),(103,'Magento\\Tax\\Setup\\Patch\\Data\\UpdateTaxClassAttributeVisibility'),(104,'Magento\\Tax\\Setup\\Patch\\Data\\UpdateTaxRegionId'),(105,'Magento\\SampleData\\Setup\\Patch\\Data\\ClearSampleDataState'),(106,'Magento\\Usps\\Setup\\Patch\\Data\\UpdateAllowedMethods'),(107,'Magento\\Braintree\\Setup\\Patch\\Data\\ConvertSerializedDataToJson'),(108,'Magento\\Weee\\Setup\\Patch\\Data\\InitQuoteAndOrderAttributes'),(109,'Magento\\Wishlist\\Setup\\Patch\\Data\\ConvertSerializedData'),(110,'Magento\\CatalogSampleData\\Setup\\Patch\\Data\\InstallCatalogSampleData'),(111,'Magento\\GroupedProductSampleData\\Setup\\Patch\\Data\\InstallGroupedProductSampleData'),(112,'Magento\\DownloadableSampleData\\Setup\\Patch\\Data\\InstallDownloadableSampleData'),(113,'Magento\\MsrpSampleData\\Setup\\Patch\\Data\\InstallMsrpSampleData'),(114,'Magento\\BundleSampleData\\Setup\\Patch\\Data\\InstallBundleSampleData'),(115,'Magento\\ConfigurableSampleData\\Setup\\Patch\\Data\\InstallConfigurableSampleData'),(116,'Magento\\ThemeSampleData\\Setup\\Patch\\Data\\InstallThemeSampleData'),(117,'Magento\\OfflineShippingSampleData\\Setup\\Patch\\Data\\InstallOfflineShippingSampleData'),(118,'Magento\\TaxSampleData\\Setup\\Patch\\Data\\InstallTaxSampleData'),(119,'Magento\\CatalogRuleSampleData\\Setup\\Patch\\Data\\InstallCatalogRuleSampleData'),(120,'Magento\\SwatchesSampleData\\Setup\\Patch\\Data\\InstallSwatchesSampleData'),(121,'Magento\\ProductLinksSampleData\\Setup\\Patch\\Data\\InstallProductLinksSampleData'),(122,'Magento\\CustomerSampleData\\Setup\\Patch\\Data\\InstallCustomerSampleData'),(123,'Magento\\CmsSampleData\\Setup\\Patch\\Data\\InstallCmsSampleData'),(124,'Magento\\SalesSampleData\\Setup\\Patch\\Data\\InstallSalesSampleData'),(125,'Magento\\SalesRuleSampleData\\Setup\\Patch\\Data\\InstallSalesRuleSampleData'),(126,'Magento\\ReviewSampleData\\Setup\\Patch\\Data\\InstallReviewSampleData'),(127,'Magento\\WidgetSampleData\\Setup\\Patch\\Data\\InstallWidgetSampleData'),(128,'Magento\\WishlistSampleData\\Setup\\Patch\\Data\\InstallWishlistSampleData');

--
-- Table structure for table `paypal_billing_agreement`
--

CREATE TABLE `paypal_billing_agreement` (
  `agreement_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Agreement Id',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer Id',
  `method_code` varchar(32) NOT NULL COMMENT 'Method Code',
  `reference_id` varchar(32) NOT NULL COMMENT 'Reference Id',
  `status` varchar(20) NOT NULL COMMENT 'Status',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store Id',
  `agreement_label` varchar(255) DEFAULT NULL COMMENT 'Agreement Label',
  PRIMARY KEY (`agreement_id`),
  KEY `PAYPAL_BILLING_AGREEMENT_CUSTOMER_ID` (`customer_id`),
  KEY `PAYPAL_BILLING_AGREEMENT_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Billing Agreement';

--
-- Dumping data for table `paypal_billing_agreement`
--


--
-- Table structure for table `paypal_billing_agreement_order`
--

CREATE TABLE `paypal_billing_agreement_order` (
  `agreement_id` int(10) unsigned NOT NULL COMMENT 'Agreement Id',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order Id',
  PRIMARY KEY (`agreement_id`,`order_id`),
  KEY `PAYPAL_BILLING_AGREEMENT_ORDER_ORDER_ID` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Billing Agreement Order';

--
-- Dumping data for table `paypal_billing_agreement_order`
--


--
-- Table structure for table `paypal_cert`
--

CREATE TABLE `paypal_cert` (
  `cert_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Cert Id',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website Id',
  `content` text COMMENT 'Content',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  PRIMARY KEY (`cert_id`),
  KEY `PAYPAL_CERT_WEBSITE_ID` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Paypal Certificate Table';

--
-- Dumping data for table `paypal_cert`
--


--
-- Table structure for table `paypal_payment_transaction`
--

CREATE TABLE `paypal_payment_transaction` (
  `transaction_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `txn_id` varchar(100) DEFAULT NULL COMMENT 'Txn Id',
  `additional_information` blob COMMENT 'Additional Information',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  PRIMARY KEY (`transaction_id`),
  UNIQUE KEY `PAYPAL_PAYMENT_TRANSACTION_TXN_ID` (`txn_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='PayPal Payflow Link Payment Transaction';

--
-- Dumping data for table `paypal_payment_transaction`
--


--
-- Table structure for table `paypal_settlement_report`
--

CREATE TABLE `paypal_settlement_report` (
  `report_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Report Id',
  `report_date` date DEFAULT NULL COMMENT 'Report Date',
  `account_id` varchar(64) DEFAULT NULL COMMENT 'Account Id',
  `filename` varchar(24) DEFAULT NULL COMMENT 'Filename',
  `last_modified` timestamp NULL DEFAULT NULL COMMENT 'Last Modified',
  PRIMARY KEY (`report_id`),
  UNIQUE KEY `PAYPAL_SETTLEMENT_REPORT_REPORT_DATE_ACCOUNT_ID` (`report_date`,`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Paypal Settlement Report Table';

--
-- Dumping data for table `paypal_settlement_report`
--


--
-- Table structure for table `paypal_settlement_report_row`
--

CREATE TABLE `paypal_settlement_report_row` (
  `row_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Row Id',
  `report_id` int(10) unsigned NOT NULL COMMENT 'Report Id',
  `transaction_id` varchar(19) DEFAULT NULL COMMENT 'Transaction Id',
  `invoice_id` varchar(127) DEFAULT NULL COMMENT 'Invoice Id',
  `paypal_reference_id` varchar(19) DEFAULT NULL COMMENT 'Paypal Reference Id',
  `paypal_reference_id_type` varchar(3) DEFAULT NULL COMMENT 'Paypal Reference Id Type',
  `transaction_event_code` varchar(5) DEFAULT NULL COMMENT 'Transaction Event Code',
  `transaction_initiation_date` timestamp NULL DEFAULT NULL COMMENT 'Transaction Initiation Date',
  `transaction_completion_date` timestamp NULL DEFAULT NULL COMMENT 'Transaction Completion Date',
  `transaction_debit_or_credit` varchar(2) NOT NULL DEFAULT 'CR' COMMENT 'Transaction Debit Or Credit',
  `gross_transaction_amount` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Gross Transaction Amount',
  `gross_transaction_currency` varchar(3) DEFAULT NULL COMMENT 'Gross Transaction Currency',
  `fee_debit_or_credit` varchar(2) DEFAULT NULL COMMENT 'Fee Debit Or Credit',
  `fee_amount` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Fee Amount',
  `fee_currency` varchar(3) DEFAULT NULL COMMENT 'Fee Currency',
  `custom_field` varchar(255) DEFAULT NULL COMMENT 'Custom Field',
  `consumer_id` varchar(127) DEFAULT NULL COMMENT 'Consumer Id',
  `payment_tracking_id` varchar(255) DEFAULT NULL COMMENT 'Payment Tracking ID',
  `store_id` varchar(50) DEFAULT NULL COMMENT 'Store ID',
  PRIMARY KEY (`row_id`),
  KEY `PAYPAL_SETTLEMENT_REPORT_ROW_REPORT_ID` (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Paypal Settlement Report Row Table';

--
-- Dumping data for table `paypal_settlement_report_row`
--


--
-- Table structure for table `persistent_session`
--

CREATE TABLE `persistent_session` (
  `persistent_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Session id',
  `key` varchar(50) NOT NULL COMMENT 'Unique cookie key',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer id',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `info` text COMMENT 'Session Data',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`persistent_id`),
  UNIQUE KEY `PERSISTENT_SESSION_KEY` (`key`),
  UNIQUE KEY `PERSISTENT_SESSION_CUSTOMER_ID` (`customer_id`),
  KEY `PERSISTENT_SESSION_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` (`website_id`),
  KEY `PERSISTENT_SESSION_UPDATED_AT` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Persistent Session';

--
-- Dumping data for table `persistent_session`
--


--
-- Table structure for table `product_alert_price`
--

CREATE TABLE `product_alert_price` (
  `alert_price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product alert price id',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product id',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price amount',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website id',
  `add_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Product alert add date',
  `last_send_date` timestamp NULL DEFAULT NULL COMMENT 'Product alert last send date',
  `send_count` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Product alert send count',
  `status` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Product alert status',
  `store_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Store id',
  PRIMARY KEY (`alert_price_id`),
  KEY `PRODUCT_ALERT_PRICE_CUSTOMER_ID` (`customer_id`),
  KEY `PRODUCT_ALERT_PRICE_PRODUCT_ID` (`product_id`),
  KEY `PRODUCT_ALERT_PRICE_WEBSITE_ID` (`website_id`),
  KEY `PRODUCT_ALERT_PRICE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Product Alert Price';

--
-- Dumping data for table `product_alert_price`
--


--
-- Table structure for table `product_alert_stock`
--

CREATE TABLE `product_alert_stock` (
  `alert_stock_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product alert stock id',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product id',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website id',
  `add_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Product alert add date',
  `send_date` timestamp NULL DEFAULT NULL COMMENT 'Product alert send date',
  `send_count` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Send Count',
  `status` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Product alert status',
  `store_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Store id',
  PRIMARY KEY (`alert_stock_id`),
  KEY `PRODUCT_ALERT_STOCK_CUSTOMER_ID` (`customer_id`),
  KEY `PRODUCT_ALERT_STOCK_PRODUCT_ID` (`product_id`),
  KEY `PRODUCT_ALERT_STOCK_WEBSITE_ID` (`website_id`),
  KEY `PRODUCT_ALERT_STOCK_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Product Alert Stock';

--
-- Dumping data for table `product_alert_stock`
--


--
-- Table structure for table `queue`
--

CREATE TABLE `queue` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Queue ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Queue name',
  PRIMARY KEY (`id`),
  UNIQUE KEY `QUEUE_NAME` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table storing unique queues';

--
-- Dumping data for table `queue`
--


--
-- Table structure for table `queue_lock`
--

CREATE TABLE `queue_lock` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Message ID',
  `message_code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Message Code',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Created At',
  PRIMARY KEY (`id`),
  UNIQUE KEY `QUEUE_LOCK_MESSAGE_CODE` (`message_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Messages that were processed are inserted here to be locked.';

--
-- Dumping data for table `queue_lock`
--


--
-- Table structure for table `queue_message`
--

CREATE TABLE `queue_message` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Message ID',
  `topic_name` varchar(255) DEFAULT NULL COMMENT 'Message topic',
  `body` longtext COMMENT 'Message body',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Queue messages';

--
-- Dumping data for table `queue_message`
--


--
-- Table structure for table `queue_message_status`
--

CREATE TABLE `queue_message_status` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Relation ID',
  `queue_id` int(10) unsigned NOT NULL COMMENT 'Queue ID',
  `message_id` bigint(20) unsigned NOT NULL COMMENT 'Message ID',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `status` smallint(5) unsigned NOT NULL COMMENT 'Message status in particular queue',
  `number_of_trials` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of trials to processed failed message processing',
  PRIMARY KEY (`id`),
  UNIQUE KEY `QUEUE_MESSAGE_STATUS_QUEUE_ID_MESSAGE_ID` (`queue_id`,`message_id`),
  KEY `QUEUE_MESSAGE_STATUS_MESSAGE_ID_QUEUE_MESSAGE_ID` (`message_id`),
  KEY `QUEUE_MESSAGE_STATUS_STATUS_UPDATED_AT` (`status`,`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Relation table to keep associations between queues and messages';

--
-- Dumping data for table `queue_message_status`
--


--
-- Table structure for table `quote`
--

CREATE TABLE `quote` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `converted_at` timestamp NULL DEFAULT NULL COMMENT 'Converted At',
  `is_active` smallint(5) unsigned DEFAULT '1' COMMENT 'Is Active',
  `is_virtual` smallint(5) unsigned DEFAULT '0' COMMENT 'Is Virtual',
  `is_multi_shipping` smallint(5) unsigned DEFAULT '0' COMMENT 'Is Multi Shipping',
  `items_count` int(10) unsigned DEFAULT '0' COMMENT 'Items Count',
  `items_qty` decimal(12,4) DEFAULT '0.0000' COMMENT 'Items Qty',
  `orig_order_id` int(10) unsigned DEFAULT '0' COMMENT 'Orig Order Id',
  `store_to_base_rate` decimal(12,4) DEFAULT '0.0000' COMMENT 'Store To Base Rate',
  `store_to_quote_rate` decimal(12,4) DEFAULT '0.0000' COMMENT 'Store To Quote Rate',
  `base_currency_code` varchar(255) DEFAULT NULL COMMENT 'Base Currency Code',
  `store_currency_code` varchar(255) DEFAULT NULL COMMENT 'Store Currency Code',
  `quote_currency_code` varchar(255) DEFAULT NULL COMMENT 'Quote Currency Code',
  `grand_total` decimal(12,4) DEFAULT '0.0000' COMMENT 'Grand Total',
  `base_grand_total` decimal(12,4) DEFAULT '0.0000' COMMENT 'Base Grand Total',
  `checkout_method` varchar(255) DEFAULT NULL COMMENT 'Checkout Method',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer Id',
  `customer_tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer Tax Class Id',
  `customer_group_id` int(10) unsigned DEFAULT '0' COMMENT 'Customer Group Id',
  `customer_email` varchar(255) DEFAULT NULL COMMENT 'Customer Email',
  `customer_prefix` varchar(40) DEFAULT NULL COMMENT 'Customer Prefix',
  `customer_firstname` varchar(255) DEFAULT NULL COMMENT 'Customer Firstname',
  `customer_middlename` varchar(40) DEFAULT NULL COMMENT 'Customer Middlename',
  `customer_lastname` varchar(255) DEFAULT NULL COMMENT 'Customer Lastname',
  `customer_suffix` varchar(40) DEFAULT NULL COMMENT 'Customer Suffix',
  `customer_dob` datetime DEFAULT NULL COMMENT 'Customer Dob',
  `customer_note` varchar(255) DEFAULT NULL COMMENT 'Customer Note',
  `customer_note_notify` smallint(5) unsigned DEFAULT '1' COMMENT 'Customer Note Notify',
  `customer_is_guest` smallint(5) unsigned DEFAULT '0' COMMENT 'Customer Is Guest',
  `remote_ip` varchar(45) DEFAULT NULL COMMENT 'Remote Ip',
  `applied_rule_ids` varchar(255) DEFAULT NULL COMMENT 'Applied Rule Ids',
  `reserved_order_id` varchar(64) DEFAULT NULL COMMENT 'Reserved Order Id',
  `password_hash` varchar(255) DEFAULT NULL COMMENT 'Password Hash',
  `coupon_code` varchar(255) DEFAULT NULL COMMENT 'Coupon Code',
  `global_currency_code` varchar(255) DEFAULT NULL COMMENT 'Global Currency Code',
  `base_to_global_rate` decimal(12,4) DEFAULT NULL COMMENT 'Base To Global Rate',
  `base_to_quote_rate` decimal(12,4) DEFAULT NULL COMMENT 'Base To Quote Rate',
  `customer_taxvat` varchar(255) DEFAULT NULL COMMENT 'Customer Taxvat',
  `customer_gender` varchar(255) DEFAULT NULL COMMENT 'Customer Gender',
  `subtotal` decimal(12,4) DEFAULT NULL COMMENT 'Subtotal',
  `base_subtotal` decimal(12,4) DEFAULT NULL COMMENT 'Base Subtotal',
  `subtotal_with_discount` decimal(12,4) DEFAULT NULL COMMENT 'Subtotal With Discount',
  `base_subtotal_with_discount` decimal(12,4) DEFAULT NULL COMMENT 'Base Subtotal With Discount',
  `is_changed` int(10) unsigned DEFAULT NULL COMMENT 'Is Changed',
  `trigger_recollect` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Trigger Recollect',
  `ext_shipping_info` text COMMENT 'Ext Shipping Info',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message Id',
  `is_persistent` smallint(5) unsigned DEFAULT '0' COMMENT 'Is Quote Persistent',
  PRIMARY KEY (`entity_id`),
  KEY `QUOTE_CUSTOMER_ID_STORE_ID_IS_ACTIVE` (`customer_id`,`store_id`,`is_active`),
  KEY `QUOTE_STORE_ID` (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote';

--
-- Dumping data for table `quote`
--

INSERT INTO `quote` VALUES (1,1,'2018-12-04 12:35:24','2018-12-04 12:35:25',NULL,0,0,0,1,1.0000,0,0.0000,0.0000,'USD','USD','USD',36.3900,36.3900,NULL,1,3,1,'roni_cost@example.com',NULL,'Veronica',NULL,'Costello',NULL,'1973-12-15 00:00:00',NULL,1,0,NULL,NULL,'000000001',NULL,NULL,'USD',1.0000,1.0000,NULL,'2',29.0000,29.0000,29.0000,29.0000,1,0,NULL,NULL,0),(2,1,'2018-12-04 12:35:26','2018-12-04 12:35:26',NULL,0,0,0,1,1.0000,0,0.0000,0.0000,'USD','USD','USD',39.6400,39.6400,NULL,1,3,1,'roni_cost@example.com',NULL,'Veronica',NULL,'Costello',NULL,'1973-12-15 00:00:00',NULL,1,0,NULL,NULL,'000000002',NULL,NULL,'USD',1.0000,1.0000,NULL,'2',32.0000,32.0000,32.0000,32.0000,1,0,NULL,NULL,0);

--
-- Table structure for table `quote_address`
--

CREATE TABLE `quote_address` (
  `address_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Address Id',
  `quote_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quote Id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer Id',
  `save_in_address_book` smallint(6) DEFAULT '0' COMMENT 'Save In Address Book',
  `customer_address_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer Address Id',
  `address_type` varchar(10) DEFAULT NULL COMMENT 'Address Type',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `prefix` varchar(40) DEFAULT NULL COMMENT 'Prefix',
  `firstname` varchar(255) DEFAULT NULL,
  `middlename` varchar(40) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `suffix` varchar(40) DEFAULT NULL COMMENT 'Suffix',
  `company` varchar(255) DEFAULT NULL COMMENT 'Company',
  `street` varchar(255) DEFAULT NULL COMMENT 'Street',
  `city` varchar(255) DEFAULT NULL,
  `region` varchar(255) DEFAULT NULL,
  `region_id` int(10) unsigned DEFAULT NULL COMMENT 'Region Id',
  `postcode` varchar(20) DEFAULT NULL COMMENT 'Postcode',
  `country_id` varchar(30) DEFAULT NULL COMMENT 'Country Id',
  `telephone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `same_as_billing` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Same As Billing',
  `collect_shipping_rates` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Collect Shipping Rates',
  `shipping_method` varchar(120) DEFAULT NULL,
  `shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
  `weight` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Weight',
  `subtotal` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Subtotal',
  `base_subtotal` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Subtotal',
  `subtotal_with_discount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Subtotal With Discount',
  `base_subtotal_with_discount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Subtotal With Discount',
  `tax_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Tax Amount',
  `base_tax_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Tax Amount',
  `shipping_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Shipping Amount',
  `base_shipping_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Shipping Amount',
  `shipping_tax_amount` decimal(12,4) DEFAULT NULL COMMENT 'Shipping Tax Amount',
  `base_shipping_tax_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Shipping Tax Amount',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Discount Amount',
  `base_discount_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Discount Amount',
  `grand_total` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Grand Total',
  `base_grand_total` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Grand Total',
  `customer_notes` text COMMENT 'Customer Notes',
  `applied_taxes` text COMMENT 'Applied Taxes',
  `discount_description` varchar(255) DEFAULT NULL COMMENT 'Discount Description',
  `shipping_discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Shipping Discount Amount',
  `base_shipping_discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Shipping Discount Amount',
  `subtotal_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Subtotal Incl Tax',
  `base_subtotal_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Subtotal Total Incl Tax',
  `discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `shipping_discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Shipping Discount Tax Compensation Amount',
  `base_shipping_discount_tax_compensation_amnt` decimal(12,4) DEFAULT NULL COMMENT 'Base Shipping Discount Tax Compensation Amount',
  `shipping_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Shipping Incl Tax',
  `base_shipping_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Shipping Incl Tax',
  `vat_id` text COMMENT 'Vat Id',
  `vat_is_valid` smallint(6) DEFAULT NULL COMMENT 'Vat Is Valid',
  `vat_request_id` text COMMENT 'Vat Request Id',
  `vat_request_date` text COMMENT 'Vat Request Date',
  `vat_request_success` smallint(6) DEFAULT NULL COMMENT 'Vat Request Success',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message Id',
  `free_shipping` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Free Shipping',
  PRIMARY KEY (`address_id`),
  KEY `QUOTE_ADDRESS_QUOTE_ID` (`quote_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Address';

--
-- Dumping data for table `quote_address`
--

INSERT INTO `quote_address` VALUES (1,1,'2018-12-04 12:35:24','0000-00-00 00:00:00',1,0,1,'billing','roni_cost@example.com',NULL,'Veronica',NULL,'Costello',NULL,NULL,'6146 Honey Bluff Parkway','Calder','Michigan',33,'49628-7978','US','(555) 229-3326',NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,NULL,NULL,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,0),(2,1,'2018-12-04 12:35:24','0000-00-00 00:00:00',1,0,1,'shipping','roni_cost@example.com',NULL,'Veronica',NULL,'Costello',NULL,NULL,'6146 Honey Bluff Parkway','Calder','Michigan',33,'49628-7978','US','(555) 229-3326',NULL,1,0,'flatrate_flatrate','Flat Rate - Fixed',1.0000,29.0000,29.0000,29.0000,29.0000,2.3900,2.3900,5.0000,5.0000,0.0000,0.0000,0.0000,0.0000,36.3900,36.3900,NULL,'{\"US-MI-*-Rate 1\":{\"amount\":2.39,\"base_amount\":2.39,\"percent\":8.25,\"id\":\"US-MI-*-Rate 1\",\"rates\":[{\"percent\":8.25,\"code\":\"US-MI-*-Rate 1\",\"title\":\"US-MI-*-Rate 1\"}],\"item_id\":null,\"item_type\":\"product\",\"associated_item_id\":null,\"process\":0}}',NULL,0.0000,0.0000,31.3900,31.3900,0.0000,0.0000,0.0000,NULL,5.0000,5.0000,NULL,NULL,NULL,NULL,NULL,NULL,0),(3,2,'2018-12-04 12:35:26','0000-00-00 00:00:00',1,0,1,'billing','roni_cost@example.com',NULL,'Veronica',NULL,'Costello',NULL,NULL,'6146 Honey Bluff Parkway','Calder','Michigan',33,'49628-7978','US','(555) 229-3326',NULL,0,0,NULL,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,'null',NULL,NULL,NULL,0.0000,NULL,0.0000,0.0000,0.0000,NULL,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,0),(4,2,'2018-12-04 12:35:26','0000-00-00 00:00:00',1,0,1,'shipping','roni_cost@example.com',NULL,'Veronica',NULL,'Costello',NULL,NULL,'6146 Honey Bluff Parkway','Calder','Michigan',33,'49628-7978','US','(555) 229-3326',NULL,1,0,'flatrate_flatrate','Flat Rate - Fixed',1.0000,32.0000,32.0000,32.0000,32.0000,2.6400,2.6400,5.0000,5.0000,0.0000,0.0000,0.0000,0.0000,39.6400,39.6400,NULL,'{\"US-MI-*-Rate 1\":{\"amount\":2.64,\"base_amount\":2.64,\"percent\":8.25,\"id\":\"US-MI-*-Rate 1\",\"rates\":[{\"percent\":8.25,\"code\":\"US-MI-*-Rate 1\",\"title\":\"US-MI-*-Rate 1\"}],\"item_id\":null,\"item_type\":\"product\",\"associated_item_id\":null,\"process\":0}}',NULL,0.0000,0.0000,34.6400,34.6400,0.0000,0.0000,0.0000,NULL,5.0000,5.0000,NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `quote_address_item`
--

CREATE TABLE `quote_address_item` (
  `address_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Address Item Id',
  `parent_item_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent Item Id',
  `quote_address_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quote Address Id',
  `quote_item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quote Item Id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `applied_rule_ids` text COMMENT 'Applied Rule Ids',
  `additional_data` text COMMENT 'Additional Data',
  `weight` decimal(12,4) DEFAULT '0.0000' COMMENT 'Weight',
  `qty` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Qty',
  `discount_amount` decimal(12,4) DEFAULT '0.0000' COMMENT 'Discount Amount',
  `tax_amount` decimal(12,4) DEFAULT '0.0000' COMMENT 'Tax Amount',
  `row_total` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Row Total',
  `base_row_total` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Row Total',
  `row_total_with_discount` decimal(12,4) DEFAULT '0.0000' COMMENT 'Row Total With Discount',
  `base_discount_amount` decimal(12,4) DEFAULT '0.0000' COMMENT 'Base Discount Amount',
  `base_tax_amount` decimal(12,4) DEFAULT '0.0000' COMMENT 'Base Tax Amount',
  `row_weight` decimal(12,4) DEFAULT '0.0000' COMMENT 'Row Weight',
  `product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product Id',
  `super_product_id` int(10) unsigned DEFAULT NULL COMMENT 'Super Product Id',
  `parent_product_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent Product Id',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `is_qty_decimal` int(10) unsigned DEFAULT NULL COMMENT 'Is Qty Decimal',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
  `discount_percent` decimal(12,4) DEFAULT NULL COMMENT 'Discount Percent',
  `no_discount` int(10) unsigned DEFAULT NULL COMMENT 'No Discount',
  `tax_percent` decimal(12,4) DEFAULT NULL COMMENT 'Tax Percent',
  `base_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Price',
  `base_cost` decimal(12,4) DEFAULT NULL COMMENT 'Base Cost',
  `price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Price Incl Tax',
  `base_price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
  `row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
  `base_row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
  `discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message Id',
  `free_shipping` int(10) unsigned DEFAULT NULL COMMENT 'Free Shipping',
  PRIMARY KEY (`address_item_id`),
  KEY `QUOTE_ADDRESS_ITEM_QUOTE_ADDRESS_ID` (`quote_address_id`),
  KEY `QUOTE_ADDRESS_ITEM_PARENT_ITEM_ID` (`parent_item_id`),
  KEY `QUOTE_ADDRESS_ITEM_QUOTE_ITEM_ID` (`quote_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Address Item';

--
-- Dumping data for table `quote_address_item`
--


--
-- Table structure for table `quote_id_mask`
--

CREATE TABLE `quote_id_mask` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `quote_id` int(10) unsigned NOT NULL COMMENT 'Quote ID',
  `masked_id` varchar(32) DEFAULT NULL COMMENT 'Masked ID',
  PRIMARY KEY (`entity_id`,`quote_id`),
  KEY `QUOTE_ID_MASK_QUOTE_ID` (`quote_id`),
  KEY `QUOTE_ID_MASK_MASKED_ID` (`masked_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Quote ID and masked ID mapping';

--
-- Dumping data for table `quote_id_mask`
--


--
-- Table structure for table `quote_item`
--

CREATE TABLE `quote_item` (
  `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Item Id',
  `quote_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quote Id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product Id',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store Id',
  `parent_item_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent Item Id',
  `is_virtual` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Virtual',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `applied_rule_ids` text COMMENT 'Applied Rule Ids',
  `additional_data` text COMMENT 'Additional Data',
  `is_qty_decimal` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Qty Decimal',
  `no_discount` smallint(5) unsigned DEFAULT '0' COMMENT 'No Discount',
  `weight` decimal(12,4) DEFAULT '0.0000' COMMENT 'Weight',
  `qty` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Qty',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  `base_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Price',
  `custom_price` decimal(12,4) DEFAULT NULL COMMENT 'Custom Price',
  `discount_percent` decimal(12,4) DEFAULT '0.0000' COMMENT 'Discount Percent',
  `discount_amount` decimal(12,4) DEFAULT '0.0000' COMMENT 'Discount Amount',
  `base_discount_amount` decimal(12,4) DEFAULT '0.0000' COMMENT 'Base Discount Amount',
  `tax_percent` decimal(12,4) DEFAULT '0.0000' COMMENT 'Tax Percent',
  `tax_amount` decimal(12,4) DEFAULT '0.0000' COMMENT 'Tax Amount',
  `base_tax_amount` decimal(12,4) DEFAULT '0.0000' COMMENT 'Base Tax Amount',
  `row_total` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Row Total',
  `base_row_total` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Base Row Total',
  `row_total_with_discount` decimal(12,4) DEFAULT '0.0000' COMMENT 'Row Total With Discount',
  `row_weight` decimal(12,4) DEFAULT '0.0000' COMMENT 'Row Weight',
  `product_type` varchar(255) DEFAULT NULL COMMENT 'Product Type',
  `base_tax_before_discount` decimal(12,4) DEFAULT NULL COMMENT 'Base Tax Before Discount',
  `tax_before_discount` decimal(12,4) DEFAULT NULL COMMENT 'Tax Before Discount',
  `original_custom_price` decimal(12,4) DEFAULT NULL COMMENT 'Original Custom Price',
  `redirect_url` varchar(255) DEFAULT NULL COMMENT 'Redirect Url',
  `base_cost` decimal(12,4) DEFAULT NULL COMMENT 'Base Cost',
  `price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Price Incl Tax',
  `base_price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
  `row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
  `base_row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
  `discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message Id',
  `free_shipping` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Free Shipping',
  `weee_tax_applied` text COMMENT 'Weee Tax Applied',
  `weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Amount',
  `weee_tax_applied_row_amount` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Applied Row Amount',
  `weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Disposition',
  `weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Weee Tax Row Disposition',
  `base_weee_tax_applied_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Amount',
  `base_weee_tax_applied_row_amnt` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Applied Row Amnt',
  `base_weee_tax_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Disposition',
  `base_weee_tax_row_disposition` decimal(12,4) DEFAULT NULL COMMENT 'Base Weee Tax Row Disposition',
  PRIMARY KEY (`item_id`),
  KEY `QUOTE_ITEM_PARENT_ITEM_ID` (`parent_item_id`),
  KEY `QUOTE_ITEM_PRODUCT_ID` (`product_id`),
  KEY `QUOTE_ITEM_QUOTE_ID` (`quote_id`),
  KEY `QUOTE_ITEM_STORE_ID` (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Item';

--
-- Dumping data for table `quote_item`
--

INSERT INTO `quote_item` VALUES (1,1,'2018-12-04 12:35:25','0000-00-00 00:00:00',1434,1,NULL,0,'WS03-XS-Red','Iris Workout Top',NULL,NULL,NULL,0,0,1.0000,1.0000,29.0000,29.0000,NULL,0.0000,0.0000,0.0000,8.2500,2.3900,2.3900,29.0000,29.0000,0.0000,1.0000,'configurable',NULL,NULL,NULL,NULL,NULL,31.3900,31.3900,31.3900,31.3900,0.0000,0.0000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,'2018-12-04 12:35:25','0000-00-00 00:00:00',1421,1,1,0,'WS03-XS-Red','Iris Workout Top-XS-Red',NULL,NULL,NULL,0,0,1.0000,1.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,2,'2018-12-04 12:35:26','0000-00-00 00:00:00',1498,1,NULL,0,'WS08-XS-Blue','Minerva LumaTech&trade; V-Tee',NULL,NULL,NULL,0,0,1.0000,1.0000,32.0000,32.0000,NULL,0.0000,0.0000,0.0000,8.2500,2.6400,2.6400,32.0000,32.0000,0.0000,1.0000,'configurable',NULL,NULL,NULL,NULL,NULL,34.6400,34.6400,34.6400,34.6400,0.0000,0.0000,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,2,'2018-12-04 12:35:26','0000-00-00 00:00:00',1484,1,3,0,'WS08-XS-Blue','Minerva LumaTech&trade; V-Tee-XS-Blue',NULL,NULL,NULL,0,0,1.0000,1.0000,0.0000,0.0000,NULL,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,'simple',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `quote_item_option`
--

CREATE TABLE `quote_item_option` (
  `option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Id',
  `item_id` int(10) unsigned NOT NULL COMMENT 'Item Id',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product Id',
  `code` varchar(255) NOT NULL COMMENT 'Code',
  `value` text COMMENT 'Value',
  PRIMARY KEY (`option_id`),
  KEY `QUOTE_ITEM_OPTION_ITEM_ID` (`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Item Option';

--
-- Dumping data for table `quote_item_option`
--

INSERT INTO `quote_item_option` VALUES (1,1,1434,'info_buyRequest','{\"qty\":1,\"super_attribute\":{\"144\":\"167\",\"93\":\"58\"}}'),(2,1,1434,'attributes','{\"144\":\"167\",\"93\":\"58\"}'),(3,1,1421,'product_qty_1421','1'),(4,1,1421,'simple_product','1421'),(5,2,1421,'info_buyRequest','{\"qty\":1,\"super_attribute\":{\"144\":\"167\",\"93\":\"58\"}}'),(6,2,1421,'parent_product_id','1434'),(7,3,1498,'info_buyRequest','{\"qty\":1,\"super_attribute\":{\"144\":\"167\",\"93\":\"50\"}}'),(8,3,1498,'attributes','{\"144\":\"167\",\"93\":\"50\"}'),(9,3,1484,'product_qty_1484','1'),(10,3,1484,'simple_product','1484'),(11,4,1484,'info_buyRequest','{\"qty\":1,\"super_attribute\":{\"144\":\"167\",\"93\":\"50\"}}'),(12,4,1484,'parent_product_id','1498');

--
-- Table structure for table `quote_payment`
--

CREATE TABLE `quote_payment` (
  `payment_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Payment Id',
  `quote_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quote Id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `method` varchar(255) DEFAULT NULL COMMENT 'Method',
  `cc_type` varchar(255) DEFAULT NULL COMMENT 'Cc Type',
  `cc_number_enc` varchar(255) DEFAULT NULL COMMENT 'Cc Number Enc',
  `cc_last_4` varchar(255) DEFAULT NULL COMMENT 'Cc Last 4',
  `cc_cid_enc` varchar(255) DEFAULT NULL COMMENT 'Cc Cid Enc',
  `cc_owner` varchar(255) DEFAULT NULL COMMENT 'Cc Owner',
  `cc_exp_month` varchar(255) DEFAULT NULL COMMENT 'Cc Exp Month',
  `cc_exp_year` smallint(5) unsigned DEFAULT '0' COMMENT 'Cc Exp Year',
  `cc_ss_owner` varchar(255) DEFAULT NULL COMMENT 'Cc Ss Owner',
  `cc_ss_start_month` smallint(5) unsigned DEFAULT '0' COMMENT 'Cc Ss Start Month',
  `cc_ss_start_year` smallint(5) unsigned DEFAULT '0' COMMENT 'Cc Ss Start Year',
  `po_number` varchar(255) DEFAULT NULL COMMENT 'Po Number',
  `additional_data` text COMMENT 'Additional Data',
  `cc_ss_issue` varchar(255) DEFAULT NULL COMMENT 'Cc Ss Issue',
  `additional_information` text COMMENT 'Additional Information',
  `paypal_payer_id` varchar(255) DEFAULT NULL COMMENT 'Paypal Payer Id',
  `paypal_payer_status` varchar(255) DEFAULT NULL COMMENT 'Paypal Payer Status',
  `paypal_correlation_id` varchar(255) DEFAULT NULL COMMENT 'Paypal Correlation Id',
  PRIMARY KEY (`payment_id`),
  KEY `QUOTE_PAYMENT_QUOTE_ID` (`quote_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Payment';

--
-- Dumping data for table `quote_payment`
--

INSERT INTO `quote_payment` VALUES (1,1,'2018-12-04 12:35:26','0000-00-00 00:00:00','checkmo',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,NULL,NULL,NULL,'null',NULL,NULL,NULL),(2,2,'2018-12-04 12:35:26','0000-00-00 00:00:00','checkmo',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,NULL,NULL,NULL,'null',NULL,NULL,NULL);

--
-- Table structure for table `quote_shipping_rate`
--

CREATE TABLE `quote_shipping_rate` (
  `rate_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rate Id',
  `address_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Address Id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `carrier` varchar(255) DEFAULT NULL COMMENT 'Carrier',
  `carrier_title` varchar(255) DEFAULT NULL COMMENT 'Carrier Title',
  `code` varchar(255) DEFAULT NULL COMMENT 'Code',
  `method` varchar(255) DEFAULT NULL COMMENT 'Method',
  `method_description` text COMMENT 'Method Description',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  `error_message` text COMMENT 'Error Message',
  `method_title` text COMMENT 'Method Title',
  PRIMARY KEY (`rate_id`),
  KEY `QUOTE_SHIPPING_RATE_ADDRESS_ID` (`address_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Shipping Rate';

--
-- Dumping data for table `quote_shipping_rate`
--

INSERT INTO `quote_shipping_rate` VALUES (1,2,'2018-12-04 12:35:25','0000-00-00 00:00:00','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed'),(2,2,'2018-12-04 12:35:25','0000-00-00 00:00:00','tablerate','Best Way','tablerate_bestway','bestway',NULL,15.0000,NULL,'Table Rate'),(3,4,'2018-12-04 12:35:26','0000-00-00 00:00:00','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed'),(4,4,'2018-12-04 12:35:26','0000-00-00 00:00:00','tablerate','Best Way','tablerate_bestway','bestway',NULL,15.0000,NULL,'Table Rate');

--
-- Table structure for table `rating`
--

CREATE TABLE `rating` (
  `rating_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rating ID',
  `entity_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `rating_code` varchar(64) NOT NULL COMMENT 'Rating Code',
  `position` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Position On Storefront',
  `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Rating is active.',
  PRIMARY KEY (`rating_id`),
  UNIQUE KEY `RATING_RATING_CODE` (`rating_code`),
  KEY `RATING_ENTITY_ID` (`entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Ratings';

--
-- Dumping data for table `rating`
--

INSERT INTO `rating` VALUES (1,1,'Quality',0,1),(2,1,'Value',0,1),(3,1,'Price',0,1),(4,1,'Rating',0,1);

--
-- Table structure for table `rating_entity`
--

CREATE TABLE `rating_entity` (
  `entity_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `entity_code` varchar(64) NOT NULL COMMENT 'Entity Code',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `RATING_ENTITY_ENTITY_CODE` (`entity_code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Rating entities';

--
-- Dumping data for table `rating_entity`
--

INSERT INTO `rating_entity` VALUES (1,'product'),(2,'product_review'),(3,'review');

--
-- Table structure for table `rating_option`
--

CREATE TABLE `rating_option` (
  `option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rating Option Id',
  `rating_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Id',
  `code` varchar(32) NOT NULL COMMENT 'Rating Option Code',
  `value` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Option Value',
  `position` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Ration option position on Storefront',
  PRIMARY KEY (`option_id`),
  KEY `RATING_OPTION_RATING_ID` (`rating_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='Rating options';

--
-- Dumping data for table `rating_option`
--

INSERT INTO `rating_option` VALUES (1,1,'1',1,1),(2,1,'2',2,2),(3,1,'3',3,3),(4,1,'4',4,4),(5,1,'5',5,5),(6,2,'1',1,1),(7,2,'2',2,2),(8,2,'3',3,3),(9,2,'4',4,4),(10,2,'5',5,5),(11,3,'1',1,1),(12,3,'2',2,2),(13,3,'3',3,3),(14,3,'4',4,4),(15,3,'5',5,5),(16,4,'1',1,1),(17,4,'2',2,2),(18,4,'3',3,3),(19,4,'4',4,4),(20,4,'5',5,5);

--
-- Table structure for table `rating_option_vote`
--

CREATE TABLE `rating_option_vote` (
  `vote_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Vote id',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Vote option id',
  `remote_ip` varchar(16) NOT NULL COMMENT 'Customer IP',
  `remote_ip_long` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Customer IP converted to long integer format',
  `customer_id` int(10) unsigned DEFAULT '0' COMMENT 'Customer Id',
  `entity_pk_value` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Product id',
  `rating_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating id',
  `review_id` bigint(20) unsigned DEFAULT NULL COMMENT 'Review id',
  `percent` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Percent amount',
  `value` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Vote option value',
  PRIMARY KEY (`vote_id`),
  KEY `RATING_OPTION_VOTE_REVIEW_ID_REVIEW_REVIEW_ID` (`review_id`),
  KEY `RATING_OPTION_VOTE_OPTION_ID` (`option_id`)
) ENGINE=InnoDB AUTO_INCREMENT=347 DEFAULT CHARSET=utf8 COMMENT='Rating option values';

--
-- Dumping data for table `rating_option_vote`
--

INSERT INTO `rating_option_vote` VALUES (1,17,'',0,NULL,1,4,1,40,2),(2,18,'',0,NULL,1,4,2,60,3),(3,20,'',0,NULL,6,4,3,100,5),(4,18,'',0,NULL,6,4,4,60,3),(5,17,'',0,NULL,6,4,5,40,2),(6,19,'',0,NULL,3,4,6,80,4),(7,18,'',0,NULL,3,4,7,60,3),(8,18,'',0,NULL,3,4,8,60,3),(9,20,'',0,NULL,2,4,9,100,5),(10,19,'',0,NULL,2,4,10,80,4),(11,16,'',0,NULL,4,4,11,20,1),(12,19,'',0,NULL,4,4,12,80,4),(13,20,'',0,NULL,4,4,13,100,5),(14,20,'',0,NULL,5,4,14,100,5),(15,17,'',0,NULL,5,4,15,40,2),(16,20,'',0,NULL,37,4,16,100,5),(17,20,'',0,NULL,37,4,17,100,5),(18,18,'',0,NULL,37,4,18,60,3),(19,19,'',0,NULL,40,4,19,80,4),(20,19,'',0,NULL,40,4,20,80,4),(21,18,'',0,NULL,40,4,21,60,3),(22,18,'',0,NULL,38,4,22,60,3),(23,17,'',0,NULL,38,4,23,40,2),(24,17,'',0,NULL,38,4,24,40,2),(25,19,'',0,NULL,36,4,25,80,4),(26,19,'',0,NULL,36,4,26,80,4),(27,20,'',0,NULL,39,4,27,100,5),(28,19,'',0,NULL,39,4,28,80,4),(29,17,'',0,NULL,39,4,29,40,2),(30,17,'',0,NULL,39,4,30,40,2),(31,20,'',0,NULL,276,4,31,100,5),(32,19,'',0,NULL,276,4,32,80,4),(33,20,'',0,NULL,292,4,33,100,5),(34,19,'',0,NULL,292,4,34,80,4),(35,17,'',0,NULL,420,4,35,40,2),(36,17,'',0,NULL,420,4,36,40,2),(37,19,'',0,NULL,420,4,37,80,4),(38,20,'',0,NULL,308,4,38,100,5),(39,19,'',0,NULL,308,4,39,80,4),(40,20,'',0,NULL,308,4,40,100,5),(41,20,'',0,NULL,404,4,41,100,5),(42,18,'',0,NULL,404,4,42,60,3),(43,19,'',0,NULL,404,4,43,80,4),(44,17,'',0,NULL,324,4,44,40,2),(45,18,'',0,NULL,324,4,45,60,3),(46,18,'',0,NULL,340,4,46,60,3),(47,18,'',0,NULL,340,4,47,60,3),(48,19,'',0,NULL,340,4,48,80,4),(49,19,'',0,NULL,356,4,49,80,4),(50,18,'',0,NULL,356,4,50,60,3),(51,19,'',0,NULL,372,4,51,80,4),(52,18,'',0,NULL,372,4,52,60,3),(53,17,'',0,NULL,743,4,53,40,2),(54,19,'',0,NULL,743,4,54,80,4),(55,16,'',0,NULL,743,4,55,20,1),(56,17,'',0,NULL,756,4,56,40,2),(57,17,'',0,NULL,756,4,57,40,2),(58,18,'',0,NULL,756,4,58,60,3),(59,19,'',0,NULL,769,4,59,80,4),(60,18,'',0,NULL,769,4,60,60,3),(61,19,'',0,NULL,782,4,61,80,4),(62,20,'',0,NULL,782,4,62,100,5),(63,19,'',0,NULL,782,4,63,80,4),(64,19,'',0,NULL,795,4,64,80,4),(65,19,'',0,NULL,795,4,65,80,4),(66,18,'',0,NULL,795,4,66,60,3),(67,18,'',0,NULL,564,4,67,60,3),(68,19,'',0,NULL,564,4,68,80,4),(69,20,'',0,NULL,564,4,69,100,5),(70,20,'',0,NULL,580,4,70,100,5),(71,19,'',0,NULL,580,4,71,80,4),(72,20,'',0,NULL,532,4,72,100,5),(73,16,'',0,NULL,532,4,73,20,1),(74,20,'',0,NULL,452,4,74,100,5),(75,17,'',0,NULL,452,4,75,40,2),(76,18,'',0,NULL,452,4,76,60,3),(77,20,'',0,NULL,468,4,77,100,5),(78,19,'',0,NULL,468,4,78,80,4),(79,18,'',0,NULL,468,4,79,60,3),(80,18,'',0,NULL,548,4,80,60,3),(81,19,'',0,NULL,548,4,81,80,4),(82,18,'',0,NULL,612,4,82,60,3),(83,18,'',0,NULL,612,4,83,60,3),(84,19,'',0,NULL,612,4,84,80,4),(85,20,'',0,NULL,628,4,85,100,5),(86,18,'',0,NULL,628,4,86,60,3),(87,18,'',0,NULL,628,4,87,60,3),(88,17,'',0,NULL,628,4,88,40,2),(89,19,'',0,NULL,484,4,89,80,4),(90,17,'',0,NULL,484,4,90,40,2),(91,20,'',0,NULL,484,4,91,100,5),(92,20,'',0,NULL,596,4,92,100,5),(93,16,'',0,NULL,596,4,93,20,1),(94,18,'',0,NULL,596,4,94,60,3),(95,19,'',0,NULL,500,4,95,80,4),(96,18,'',0,NULL,500,4,96,60,3),(97,20,'',0,NULL,500,4,97,100,5),(98,16,'',0,NULL,516,4,98,20,1),(99,17,'',0,NULL,516,4,99,40,2),(100,20,'',0,NULL,516,4,100,100,5),(101,19,'',0,NULL,899,4,101,80,4),(102,19,'',0,NULL,899,4,102,80,4),(103,19,'',0,NULL,899,4,103,80,4),(104,18,'',0,NULL,917,4,104,60,3),(105,19,'',0,NULL,917,4,105,80,4),(106,19,'',0,NULL,917,4,106,80,4),(107,17,'',0,NULL,930,4,107,40,2),(108,18,'',0,NULL,930,4,108,60,3),(109,19,'',0,NULL,930,4,109,80,4),(110,20,'',0,NULL,943,4,110,100,5),(111,17,'',0,NULL,943,4,111,40,2),(112,19,'',0,NULL,943,4,112,80,4),(113,18,'',0,NULL,956,4,113,60,3),(114,19,'',0,NULL,956,4,114,80,4),(115,20,'',0,NULL,969,4,115,100,5),(116,20,'',0,NULL,969,4,116,100,5),(117,18,'',0,NULL,969,4,117,60,3),(118,19,'',0,NULL,982,4,118,80,4),(119,17,'',0,NULL,982,4,119,40,2),(120,18,'',0,NULL,995,4,120,60,3),(121,18,'',0,NULL,995,4,121,60,3),(122,19,'',0,NULL,995,4,122,80,4),(123,16,'',0,NULL,644,4,123,20,1),(124,19,'',0,NULL,644,4,124,80,4),(125,18,'',0,NULL,644,4,125,60,3),(126,18,'',0,NULL,644,4,126,60,3),(127,18,'',0,NULL,660,4,127,60,3),(128,19,'',0,NULL,660,4,128,80,4),(129,20,'',0,NULL,660,4,129,100,5),(130,18,'',0,NULL,676,4,130,60,3),(131,18,'',0,NULL,676,4,131,60,3),(132,17,'',0,NULL,676,4,132,40,2),(133,17,'',0,NULL,682,4,133,40,2),(134,18,'',0,NULL,682,4,134,60,3),(135,19,'',0,NULL,682,4,135,80,4),(136,20,'',0,NULL,682,4,136,100,5),(137,20,'',0,NULL,7,4,137,100,5),(138,19,'',0,NULL,7,4,138,80,4),(139,18,'',0,NULL,7,4,139,60,3),(140,20,'',0,NULL,20,4,140,100,5),(141,19,'',0,NULL,20,4,141,80,4),(142,16,'',0,NULL,20,4,142,20,1),(143,18,'',0,NULL,18,4,143,60,3),(144,18,'',0,NULL,18,4,144,60,3),(145,20,'',0,NULL,23,4,145,100,5),(146,16,'',0,NULL,23,4,146,20,1),(147,18,'',0,NULL,23,4,147,60,3),(148,19,'',0,NULL,17,4,148,80,4),(149,20,'',0,NULL,17,4,149,100,5),(150,20,'',0,NULL,17,4,150,100,5),(151,20,'',0,NULL,19,4,151,100,5),(152,18,'',0,NULL,19,4,152,60,3),(153,20,'',0,NULL,19,4,153,100,5),(154,18,'',0,NULL,15,4,154,60,3),(155,20,'',0,NULL,16,4,155,100,5),(156,20,'',0,NULL,16,4,156,100,5),(157,19,'',0,NULL,8,4,157,80,4),(158,18,'',0,NULL,8,4,158,60,3),(159,18,'',0,NULL,8,4,159,60,3),(160,19,'',0,NULL,9,4,160,80,4),(161,18,'',0,NULL,9,4,161,60,3),(162,20,'',0,NULL,12,4,162,100,5),(163,19,'',0,NULL,12,4,163,80,4),(164,19,'',0,NULL,14,4,164,80,4),(165,18,'',0,NULL,14,4,165,60,3),(166,18,'',0,NULL,14,4,166,60,3),(167,20,'',0,NULL,10,4,167,100,5),(168,18,'',0,NULL,10,4,168,60,3),(169,20,'',0,NULL,11,4,169,100,5),(170,20,'',0,NULL,11,4,170,100,5),(171,16,'',0,NULL,11,4,171,20,1),(172,17,'',0,NULL,13,4,172,40,2),(173,19,'',0,NULL,13,4,173,80,4),(174,18,'',0,NULL,13,4,174,60,3),(175,19,'',0,NULL,42,4,175,80,4),(176,18,'',0,NULL,42,4,176,60,3),(177,18,'',0,NULL,42,4,177,60,3),(178,20,'',0,NULL,44,4,178,100,5),(179,17,'',0,NULL,44,4,179,40,2),(180,17,'',0,NULL,43,4,180,40,2),(181,18,'',0,NULL,43,4,181,60,3),(182,18,'',0,NULL,43,4,182,60,3),(183,19,'',0,NULL,41,4,183,80,4),(184,19,'',0,NULL,41,4,184,80,4),(185,18,'',0,NULL,1050,4,185,60,3),(186,20,'',0,NULL,1050,4,186,100,5),(187,20,'',0,NULL,1050,4,187,100,5),(188,20,'',0,NULL,1066,4,188,100,5),(189,16,'',0,NULL,1066,4,189,20,1),(190,19,'',0,NULL,1066,4,190,80,4),(191,19,'',0,NULL,1082,4,191,80,4),(192,18,'',0,NULL,1082,4,192,60,3),(193,17,'',0,NULL,1082,4,193,40,2),(194,17,'',0,NULL,1098,4,194,40,2),(195,19,'',0,NULL,1098,4,195,80,4),(196,18,'',0,NULL,1098,4,196,60,3),(197,19,'',0,NULL,1114,4,197,80,4),(198,19,'',0,NULL,1114,4,198,80,4),(199,19,'',0,NULL,1114,4,199,80,4),(200,19,'',0,NULL,1120,4,200,80,4),(201,19,'',0,NULL,1120,4,201,80,4),(202,18,'',0,NULL,1226,4,202,60,3),(203,19,'',0,NULL,1226,4,203,80,4),(204,18,'',0,NULL,1226,4,204,60,3),(205,20,'',0,NULL,1242,4,205,100,5),(206,17,'',0,NULL,1242,4,206,40,2),(207,18,'',0,NULL,1242,4,207,60,3),(208,19,'',0,NULL,1242,4,208,80,4),(209,20,'',0,NULL,1258,4,209,100,5),(210,20,'',0,NULL,1258,4,210,100,5),(211,18,'',0,NULL,1258,4,211,60,3),(212,20,'',0,NULL,1274,4,212,100,5),(213,19,'',0,NULL,1274,4,213,80,4),(214,19,'',0,NULL,1290,4,214,80,4),(215,19,'',0,NULL,1290,4,215,80,4),(216,20,'',0,NULL,1290,4,216,100,5),(217,18,'',0,NULL,1386,4,217,60,3),(218,20,'',0,NULL,1386,4,218,100,5),(219,20,'',0,NULL,1386,4,219,100,5),(220,18,'',0,NULL,1306,4,220,60,3),(221,17,'',0,NULL,1306,4,221,40,2),(222,20,'',0,NULL,1306,4,222,100,5),(223,20,'',0,NULL,1322,4,223,100,5),(224,16,'',0,NULL,1322,4,224,20,1),(225,19,'',0,NULL,1338,4,225,80,4),(226,19,'',0,NULL,1338,4,226,80,4),(227,20,'',0,NULL,1338,4,227,100,5),(228,18,'',0,NULL,1354,4,228,60,3),(229,18,'',0,NULL,1354,4,229,60,3),(230,18,'',0,NULL,1354,4,230,60,3),(231,20,'',0,NULL,1370,4,231,100,5),(232,18,'',0,NULL,1370,4,232,60,3),(233,20,'',0,NULL,1370,4,233,100,5),(234,19,'',0,NULL,1825,4,234,80,4),(235,19,'',0,NULL,1825,4,235,80,4),(236,20,'',0,NULL,1832,4,236,100,5),(237,19,'',0,NULL,1832,4,237,80,4),(238,20,'',0,NULL,1832,4,238,100,5),(239,20,'',0,NULL,1839,4,239,100,5),(240,19,'',0,NULL,1839,4,240,80,4),(241,16,'',0,NULL,1839,4,241,20,1),(242,19,'',0,NULL,1846,4,242,80,4),(243,20,'',0,NULL,1846,4,243,100,5),(244,20,'',0,NULL,1846,4,244,100,5),(245,17,'',0,NULL,1846,4,245,40,2),(246,18,'',0,NULL,1853,4,246,60,3),(247,18,'',0,NULL,1853,4,247,60,3),(248,18,'',0,NULL,1860,4,248,60,3),(249,17,'',0,NULL,1860,4,249,40,2),(250,20,'',0,NULL,1860,4,250,100,5),(251,20,'',0,NULL,1578,4,251,100,5),(252,19,'',0,NULL,1578,4,252,80,4),(253,19,'',0,NULL,1578,4,253,80,4),(254,19,'',0,NULL,1418,4,254,80,4),(255,18,'',0,NULL,1418,4,255,60,3),(256,19,'',0,NULL,1418,4,256,80,4),(257,20,'',0,NULL,1434,4,257,100,5),(258,17,'',0,NULL,1434,4,258,40,2),(259,18,'',0,NULL,1434,4,259,60,3),(260,17,'',0,NULL,1434,4,260,40,2),(261,17,'',0,NULL,1450,4,261,40,2),(262,19,'',0,NULL,1450,4,262,80,4),(263,19,'',0,NULL,1594,4,263,80,4),(264,20,'',0,NULL,1594,4,264,100,5),(265,17,'',0,NULL,1594,4,265,40,2),(266,17,'',0,NULL,1482,4,266,40,2),(267,19,'',0,NULL,1482,4,267,80,4),(268,19,'',0,NULL,1498,4,268,80,4),(269,16,'',0,NULL,1498,4,269,20,1),(270,17,'',0,NULL,1498,4,270,40,2),(271,19,'',0,NULL,1514,4,271,80,4),(272,18,'',0,NULL,1514,4,272,60,3),(273,19,'',0,NULL,1514,4,273,80,4),(274,20,'',0,NULL,1530,4,274,100,5),(275,19,'',0,NULL,1530,4,275,80,4),(276,18,'',0,NULL,1530,4,276,60,3),(277,18,'',0,NULL,1546,4,277,60,3),(278,20,'',0,NULL,1546,4,278,100,5),(279,20,'',0,NULL,1546,4,279,100,5),(280,18,'',0,NULL,1562,4,280,60,3),(281,17,'',0,NULL,1562,4,281,40,2),(282,19,'',0,NULL,1562,4,282,80,4),(283,19,'',0,NULL,1925,4,283,80,4),(284,18,'',0,NULL,1925,4,284,60,3),(285,17,'',0,NULL,1925,4,285,40,2),(286,20,'',0,NULL,1941,4,286,100,5),(287,20,'',0,NULL,1941,4,287,100,5),(288,17,'',0,NULL,1941,4,288,40,2),(289,20,'',0,NULL,1957,4,289,100,5),(290,19,'',0,NULL,1957,4,290,80,4),(291,19,'',0,NULL,1973,4,291,80,4),(292,19,'',0,NULL,1973,4,292,80,4),(293,17,'',0,NULL,1989,4,293,40,2),(294,19,'',0,NULL,1989,4,294,80,4),(295,20,'',0,NULL,1989,4,295,100,5),(296,18,'',0,NULL,1996,4,296,60,3),(297,19,'',0,NULL,1996,4,297,80,4),(298,20,'',0,NULL,2003,4,298,100,5),(299,17,'',0,NULL,2003,4,299,40,2),(300,18,'',0,NULL,2003,4,300,60,3),(301,20,'',0,NULL,2009,4,301,100,5),(302,19,'',0,NULL,2009,4,302,80,4),(303,20,'',0,NULL,2009,4,303,100,5),(304,16,'',0,NULL,2016,4,304,20,1),(305,19,'',0,NULL,2016,4,305,80,4),(306,20,'',0,NULL,2016,4,306,100,5),(307,19,'',0,NULL,2023,4,307,80,4),(308,20,'',0,NULL,2023,4,308,100,5),(309,18,'',0,NULL,2023,4,309,60,3),(310,20,'',0,NULL,2030,4,310,100,5),(311,19,'',0,NULL,2030,4,311,80,4),(312,17,'',0,NULL,2030,4,312,40,2),(313,16,'',0,NULL,2046,4,313,20,1),(314,18,'',0,NULL,2046,4,314,60,3),(315,20,'',0,NULL,2046,4,315,100,5),(316,18,'',0,NULL,1610,4,316,60,3),(317,19,'',0,NULL,1610,4,317,80,4),(318,19,'',0,NULL,1610,4,318,80,4),(319,19,'',0,NULL,1610,4,319,80,4),(320,17,'',0,NULL,1626,4,320,40,2),(321,16,'',0,NULL,1626,4,321,20,1),(322,20,'',0,NULL,1626,4,322,100,5),(323,19,'',0,NULL,1626,4,323,80,4),(324,19,'',0,NULL,1642,4,324,80,4),(325,17,'',0,NULL,1642,4,325,40,2),(326,19,'',0,NULL,1642,4,326,80,4),(327,17,'',0,NULL,1658,4,327,40,2),(328,19,'',0,NULL,1658,4,328,80,4),(329,18,'',0,NULL,1658,4,329,60,3),(330,16,'',0,NULL,1674,4,330,20,1),(331,17,'',0,NULL,1674,4,331,40,2),(332,18,'',0,NULL,1674,4,332,60,3),(333,20,'',0,NULL,1770,4,333,100,5),(334,19,'',0,NULL,1770,4,334,80,4),(335,17,'',0,NULL,1770,4,335,40,2),(336,19,'',0,NULL,1786,4,336,80,4),(337,17,'',0,NULL,1802,4,337,40,2),(338,18,'',0,NULL,1802,4,338,60,3),(339,19,'',0,NULL,1802,4,339,80,4),(340,19,'',0,NULL,1818,4,340,80,4),(341,18,'',0,NULL,1818,4,341,60,3),(342,19,'',0,NULL,1690,4,342,80,4),(343,19,'',0,NULL,1690,4,343,80,4),(344,18,'',0,NULL,1706,4,344,60,3),(345,17,'',0,NULL,1706,4,345,40,2),(346,18,'',0,NULL,1706,4,346,60,3);

--
-- Table structure for table `rating_option_vote_aggregated`
--

CREATE TABLE `rating_option_vote_aggregated` (
  `primary_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Vote aggregation id',
  `rating_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating id',
  `entity_pk_value` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Product id',
  `vote_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Vote dty',
  `vote_value_sum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'General vote sum',
  `percent` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Vote percent',
  `percent_approved` smallint(6) DEFAULT '0' COMMENT 'Vote percent approved by admin',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  PRIMARY KEY (`primary_id`),
  KEY `RATING_OPTION_VOTE_AGGREGATED_RATING_ID` (`rating_id`),
  KEY `RATING_OPTION_VOTE_AGGREGATED_STORE_ID` (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=251 DEFAULT CHARSET=utf8 COMMENT='Rating vote aggregated';

--
-- Dumping data for table `rating_option_vote_aggregated`
--

INSERT INTO `rating_option_vote_aggregated` VALUES (1,4,1,2,5,50,50,0),(2,4,1,2,5,50,50,1),(3,4,6,3,10,67,67,0),(4,4,6,3,10,67,67,1),(5,4,3,3,10,67,67,0),(6,4,3,3,10,67,67,1),(7,4,2,2,9,90,90,0),(8,4,2,2,9,90,90,1),(9,4,4,3,10,67,67,0),(10,4,4,3,10,67,67,1),(11,4,5,2,7,70,70,0),(12,4,5,2,7,70,70,1),(13,4,37,3,13,87,87,0),(14,4,37,3,13,87,87,1),(15,4,40,3,11,73,73,0),(16,4,40,3,11,73,73,1),(17,4,38,3,7,47,47,0),(18,4,38,3,7,47,47,1),(19,4,36,2,8,80,80,0),(20,4,36,2,8,80,80,1),(21,4,39,4,13,65,65,0),(22,4,39,4,13,65,65,1),(23,4,276,2,9,90,90,0),(24,4,276,2,9,90,90,1),(25,4,292,2,9,90,90,0),(26,4,292,2,9,90,90,1),(27,4,420,3,8,53,53,0),(28,4,420,3,8,53,53,1),(29,4,308,3,14,93,93,0),(30,4,308,3,14,93,93,1),(31,4,404,3,12,80,80,0),(32,4,404,3,12,80,80,1),(33,4,324,2,5,50,50,0),(34,4,324,2,5,50,50,1),(35,4,340,3,10,67,67,0),(36,4,340,3,10,67,67,1),(37,4,356,2,7,70,70,0),(38,4,356,2,7,70,70,1),(39,4,372,2,7,70,70,0),(40,4,372,2,7,70,70,1),(41,4,743,3,7,47,47,0),(42,4,743,3,7,47,47,1),(43,4,756,3,7,47,47,0),(44,4,756,3,7,47,47,1),(45,4,769,2,7,70,70,0),(46,4,769,2,7,70,70,1),(47,4,782,3,13,87,87,0),(48,4,782,3,13,87,87,1),(49,4,795,3,11,73,73,0),(50,4,795,3,11,73,73,1),(51,4,564,3,12,80,80,0),(52,4,564,3,12,80,80,1),(53,4,580,2,9,90,90,0),(54,4,580,2,9,90,90,1),(55,4,532,2,6,60,60,0),(56,4,532,2,6,60,60,1),(57,4,452,3,10,67,67,0),(58,4,452,3,10,67,67,1),(59,4,468,3,12,80,80,0),(60,4,468,3,12,80,80,1),(61,4,548,2,7,70,70,0),(62,4,548,2,7,70,70,1),(63,4,612,3,10,67,67,0),(64,4,612,3,10,67,67,1),(65,4,628,4,13,65,65,0),(66,4,628,4,13,65,65,1),(67,4,484,3,11,73,73,0),(68,4,484,3,11,73,73,1),(69,4,596,3,9,60,60,0),(70,4,596,3,9,60,60,1),(71,4,500,3,12,80,80,0),(72,4,500,3,12,80,80,1),(73,4,516,3,8,53,53,0),(74,4,516,3,8,53,53,1),(75,4,899,3,12,80,80,0),(76,4,899,3,12,80,80,1),(77,4,917,3,11,73,73,0),(78,4,917,3,11,73,73,1),(79,4,930,3,9,60,60,0),(80,4,930,3,9,60,60,1),(81,4,943,3,11,73,73,0),(82,4,943,3,11,73,73,1),(83,4,956,2,7,70,70,0),(84,4,956,2,7,70,70,1),(85,4,969,3,13,87,87,0),(86,4,969,3,13,87,87,1),(87,4,982,2,6,60,60,0),(88,4,982,2,6,60,60,1),(89,4,995,3,10,67,67,0),(90,4,995,3,10,67,67,1),(91,4,644,4,11,55,55,0),(92,4,644,4,11,55,55,1),(93,4,660,3,12,80,80,0),(94,4,660,3,12,80,80,1),(95,4,676,3,8,53,53,0),(96,4,676,3,8,53,53,1),(97,4,682,4,14,70,70,0),(98,4,682,4,14,70,70,1),(99,4,7,3,12,80,80,0),(100,4,7,3,12,80,80,1),(101,4,20,3,10,67,67,0),(102,4,20,3,10,67,67,1),(103,4,18,2,6,60,60,0),(104,4,18,2,6,60,60,1),(105,4,23,3,9,60,60,0),(106,4,23,3,9,60,60,1),(107,4,17,3,14,93,93,0),(108,4,17,3,14,93,93,1),(109,4,19,3,13,87,87,0),(110,4,19,3,13,87,87,1),(111,4,15,1,3,60,60,0),(112,4,15,1,3,60,60,1),(113,4,16,2,10,100,100,0),(114,4,16,2,10,100,100,1),(115,4,8,3,10,67,67,0),(116,4,8,3,10,67,67,1),(117,4,9,2,7,70,70,0),(118,4,9,2,7,70,70,1),(119,4,12,2,9,90,90,0),(120,4,12,2,9,90,90,1),(121,4,14,3,10,67,67,0),(122,4,14,3,10,67,67,1),(123,4,10,2,8,80,80,0),(124,4,10,2,8,80,80,1),(125,4,11,3,11,73,73,0),(126,4,11,3,11,73,73,1),(127,4,13,3,9,60,60,0),(128,4,13,3,9,60,60,1),(129,4,42,3,10,67,67,0),(130,4,42,3,10,67,67,1),(131,4,44,2,7,70,70,0),(132,4,44,2,7,70,70,1),(133,4,43,3,8,53,53,0),(134,4,43,3,8,53,53,1),(135,4,41,2,8,80,80,0),(136,4,41,2,8,80,80,1),(137,4,1050,3,13,87,87,0),(138,4,1050,3,13,87,87,1),(139,4,1066,3,10,67,67,0),(140,4,1066,3,10,67,67,1),(141,4,1082,3,9,60,60,0),(142,4,1082,3,9,60,60,1),(143,4,1098,3,9,60,60,0),(144,4,1098,3,9,60,60,1),(145,4,1114,3,12,80,80,0),(146,4,1114,3,12,80,80,1),(147,4,1120,2,8,80,80,0),(148,4,1120,2,8,80,80,1),(149,4,1226,3,10,67,67,0),(150,4,1226,3,10,67,67,1),(151,4,1242,4,14,70,70,0),(152,4,1242,4,14,70,70,1),(153,4,1258,3,13,87,87,0),(154,4,1258,3,13,87,87,1),(155,4,1274,2,9,90,90,0),(156,4,1274,2,9,90,90,1),(157,4,1290,3,13,87,87,0),(158,4,1290,3,13,87,87,1),(159,4,1386,3,13,87,87,0),(160,4,1386,3,13,87,87,1),(161,4,1306,3,10,67,67,0),(162,4,1306,3,10,67,67,1),(163,4,1322,2,6,60,60,0),(164,4,1322,2,6,60,60,1),(165,4,1338,3,13,87,87,0),(166,4,1338,3,13,87,87,1),(167,4,1354,3,9,60,60,0),(168,4,1354,3,9,60,60,1),(169,4,1370,3,13,87,87,0),(170,4,1370,3,13,87,87,1),(171,4,1825,2,8,80,80,0),(172,4,1825,2,8,80,80,1),(173,4,1832,3,14,93,93,0),(174,4,1832,3,14,93,93,1),(175,4,1839,3,10,67,67,0),(176,4,1839,3,10,67,67,1),(177,4,1846,4,16,80,80,0),(178,4,1846,4,16,80,80,1),(179,4,1853,2,6,60,60,0),(180,4,1853,2,6,60,60,1),(181,4,1860,3,10,67,67,0),(182,4,1860,3,10,67,67,1),(183,4,1578,3,13,87,87,0),(184,4,1578,3,13,87,87,1),(185,4,1418,3,11,73,73,0),(186,4,1418,3,11,73,73,1),(187,4,1434,4,12,60,60,0),(188,4,1434,4,12,60,60,1),(189,4,1450,2,6,60,60,0),(190,4,1450,2,6,60,60,1),(191,4,1594,3,11,73,73,0),(192,4,1594,3,11,73,73,1),(193,4,1482,2,6,60,60,0),(194,4,1482,2,6,60,60,1),(195,4,1498,3,7,47,47,0),(196,4,1498,3,7,47,47,1),(197,4,1514,3,11,73,73,0),(198,4,1514,3,11,73,73,1),(199,4,1530,3,12,80,80,0),(200,4,1530,3,12,80,80,1),(201,4,1546,3,13,87,87,0),(202,4,1546,3,13,87,87,1),(203,4,1562,3,9,60,60,0),(204,4,1562,3,9,60,60,1),(205,4,1925,3,9,60,60,0),(206,4,1925,3,9,60,60,1),(207,4,1941,3,12,80,80,0),(208,4,1941,3,12,80,80,1),(209,4,1957,2,9,90,90,0),(210,4,1957,2,9,90,90,1),(211,4,1973,2,8,80,80,0),(212,4,1973,2,8,80,80,1),(213,4,1989,3,11,73,73,0),(214,4,1989,3,11,73,73,1),(215,4,1996,2,7,70,70,0),(216,4,1996,2,7,70,70,1),(217,4,2003,3,10,67,67,0),(218,4,2003,3,10,67,67,1),(219,4,2009,3,14,93,93,0),(220,4,2009,3,14,93,93,1),(221,4,2016,3,10,67,67,0),(222,4,2016,3,10,67,67,1),(223,4,2023,3,12,80,80,0),(224,4,2023,3,12,80,80,1),(225,4,2030,3,11,73,73,0),(226,4,2030,3,11,73,73,1),(227,4,2046,3,9,60,60,0),(228,4,2046,3,9,60,60,1),(229,4,1610,4,15,75,75,0),(230,4,1610,4,15,75,75,1),(231,4,1626,4,12,60,60,0),(232,4,1626,4,12,60,60,1),(233,4,1642,3,10,67,67,0),(234,4,1642,3,10,67,67,1),(235,4,1658,3,9,60,60,0),(236,4,1658,3,9,60,60,1),(237,4,1674,3,6,40,40,0),(238,4,1674,3,6,40,40,1),(239,4,1770,3,11,73,73,0),(240,4,1770,3,11,73,73,1),(241,4,1786,1,4,80,80,0),(242,4,1786,1,4,80,80,1),(243,4,1802,3,9,60,60,0),(244,4,1802,3,9,60,60,1),(245,4,1818,2,7,70,70,0),(246,4,1818,2,7,70,70,1),(247,4,1690,2,8,80,80,0),(248,4,1690,2,8,80,80,1),(249,4,1706,3,8,53,53,0),(250,4,1706,3,8,53,53,1);

--
-- Table structure for table `rating_store`
--

CREATE TABLE `rating_store` (
  `rating_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store id',
  PRIMARY KEY (`rating_id`,`store_id`),
  KEY `RATING_STORE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rating Store';

--
-- Dumping data for table `rating_store`
--

INSERT INTO `rating_store` VALUES (4,0),(4,1);

--
-- Table structure for table `rating_title`
--

CREATE TABLE `rating_title` (
  `rating_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `value` varchar(255) NOT NULL COMMENT 'Rating Label',
  PRIMARY KEY (`rating_id`,`store_id`),
  KEY `RATING_TITLE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rating Title';

--
-- Dumping data for table `rating_title`
--


--
-- Table structure for table `release_notification_viewer_log`
--

CREATE TABLE `release_notification_viewer_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `viewer_id` int(10) unsigned NOT NULL COMMENT 'Viewer admin user ID',
  `last_view_version` varchar(16) NOT NULL COMMENT 'Viewer last view on product version',
  PRIMARY KEY (`id`),
  UNIQUE KEY `RELEASE_NOTIFICATION_VIEWER_LOG_VIEWER_ID` (`viewer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Release Notification Viewer Log Table';

--
-- Dumping data for table `release_notification_viewer_log`
--


--
-- Table structure for table `report_compared_product_index`
--

CREATE TABLE `report_compared_product_index` (
  `index_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Index Id',
  `visitor_id` int(10) unsigned DEFAULT NULL COMMENT 'Visitor Id',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer Id',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product Id',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store Id',
  `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Added At',
  PRIMARY KEY (`index_id`),
  UNIQUE KEY `REPORT_COMPARED_PRODUCT_INDEX_VISITOR_ID_PRODUCT_ID` (`visitor_id`,`product_id`),
  UNIQUE KEY `REPORT_COMPARED_PRODUCT_INDEX_CUSTOMER_ID_PRODUCT_ID` (`customer_id`,`product_id`),
  KEY `REPORT_COMPARED_PRODUCT_INDEX_STORE_ID` (`store_id`),
  KEY `REPORT_COMPARED_PRODUCT_INDEX_ADDED_AT` (`added_at`),
  KEY `REPORT_COMPARED_PRODUCT_INDEX_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reports Compared Product Index Table';

--
-- Dumping data for table `report_compared_product_index`
--


--
-- Table structure for table `report_event`
--

CREATE TABLE `report_event` (
  `event_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event Id',
  `logged_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Logged At',
  `event_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Event Type Id',
  `object_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Object Id',
  `subject_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Subject Id',
  `subtype` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Subtype',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  PRIMARY KEY (`event_id`),
  KEY `REPORT_EVENT_EVENT_TYPE_ID` (`event_type_id`),
  KEY `REPORT_EVENT_SUBJECT_ID` (`subject_id`),
  KEY `REPORT_EVENT_OBJECT_ID` (`object_id`),
  KEY `REPORT_EVENT_SUBTYPE` (`subtype`),
  KEY `REPORT_EVENT_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reports Event Table';

--
-- Dumping data for table `report_event`
--


--
-- Table structure for table `report_event_types`
--

CREATE TABLE `report_event_types` (
  `event_type_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event Type Id',
  `event_name` varchar(64) NOT NULL COMMENT 'Event Name',
  `customer_login` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer Login',
  PRIMARY KEY (`event_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Reports Event Type Table';

--
-- Dumping data for table `report_event_types`
--

INSERT INTO `report_event_types` VALUES (1,'catalog_product_view',0),(2,'sendfriend_product',0),(3,'catalog_product_compare_add_product',0),(4,'checkout_cart_add_product',0),(5,'wishlist_add_product',0),(6,'wishlist_share',0);

--
-- Table structure for table `report_viewed_product_aggregated_daily`
--

CREATE TABLE `report_viewed_product_aggregated_daily` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store Id',
  `product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product Id',
  `product_name` varchar(255) DEFAULT NULL COMMENT 'Product Name',
  `product_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Product Price',
  `views_num` int(11) NOT NULL DEFAULT '0' COMMENT 'Number of Views',
  `rating_pos` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `REPORT_VIEWED_PRD_AGGRED_DAILY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `REPORT_VIEWED_PRODUCT_AGGREGATED_DAILY_STORE_ID` (`store_id`),
  KEY `REPORT_VIEWED_PRODUCT_AGGREGATED_DAILY_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Most Viewed Products Aggregated Daily';

--
-- Dumping data for table `report_viewed_product_aggregated_daily`
--


--
-- Table structure for table `report_viewed_product_aggregated_monthly`
--

CREATE TABLE `report_viewed_product_aggregated_monthly` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store Id',
  `product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product Id',
  `product_name` varchar(255) DEFAULT NULL COMMENT 'Product Name',
  `product_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Product Price',
  `views_num` int(11) NOT NULL DEFAULT '0' COMMENT 'Number of Views',
  `rating_pos` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `REPORT_VIEWED_PRD_AGGRED_MONTHLY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `REPORT_VIEWED_PRODUCT_AGGREGATED_MONTHLY_STORE_ID` (`store_id`),
  KEY `REPORT_VIEWED_PRODUCT_AGGREGATED_MONTHLY_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Most Viewed Products Aggregated Monthly';

--
-- Dumping data for table `report_viewed_product_aggregated_monthly`
--


--
-- Table structure for table `report_viewed_product_aggregated_yearly`
--

CREATE TABLE `report_viewed_product_aggregated_yearly` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `period` date DEFAULT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store Id',
  `product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product Id',
  `product_name` varchar(255) DEFAULT NULL COMMENT 'Product Name',
  `product_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Product Price',
  `views_num` int(11) NOT NULL DEFAULT '0' COMMENT 'Number of Views',
  `rating_pos` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `REPORT_VIEWED_PRD_AGGRED_YEARLY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
  KEY `REPORT_VIEWED_PRODUCT_AGGREGATED_YEARLY_STORE_ID` (`store_id`),
  KEY `REPORT_VIEWED_PRODUCT_AGGREGATED_YEARLY_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Most Viewed Products Aggregated Yearly';

--
-- Dumping data for table `report_viewed_product_aggregated_yearly`
--


--
-- Table structure for table `report_viewed_product_index`
--

CREATE TABLE `report_viewed_product_index` (
  `index_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Index Id',
  `visitor_id` int(10) unsigned DEFAULT NULL COMMENT 'Visitor Id',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer Id',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product Id',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store Id',
  `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Added At',
  PRIMARY KEY (`index_id`),
  UNIQUE KEY `REPORT_VIEWED_PRODUCT_INDEX_VISITOR_ID_PRODUCT_ID` (`visitor_id`,`product_id`),
  UNIQUE KEY `REPORT_VIEWED_PRODUCT_INDEX_CUSTOMER_ID_PRODUCT_ID` (`customer_id`,`product_id`),
  KEY `REPORT_VIEWED_PRODUCT_INDEX_STORE_ID` (`store_id`),
  KEY `REPORT_VIEWED_PRODUCT_INDEX_ADDED_AT` (`added_at`),
  KEY `REPORT_VIEWED_PRODUCT_INDEX_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reports Viewed Product Index Table';

--
-- Dumping data for table `report_viewed_product_index`
--


--
-- Table structure for table `reporting_counts`
--

CREATE TABLE `reporting_counts` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `type` varchar(255) DEFAULT NULL COMMENT 'Item Reported',
  `count` int(10) unsigned DEFAULT NULL COMMENT 'Count Value',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reporting for all count related events generated via the cron job';

--
-- Dumping data for table `reporting_counts`
--


--
-- Table structure for table `reporting_module_status`
--

CREATE TABLE `reporting_module_status` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Module Id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Module Name',
  `active` varchar(255) DEFAULT NULL COMMENT 'Module Active Status',
  `setup_version` varchar(255) DEFAULT NULL COMMENT 'Module Version',
  `state` varchar(255) DEFAULT NULL COMMENT 'Module State',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Module Status Table';

--
-- Dumping data for table `reporting_module_status`
--


--
-- Table structure for table `reporting_orders`
--

CREATE TABLE `reporting_orders` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `total` decimal(10,0) unsigned DEFAULT NULL,
  `total_base` decimal(10,0) unsigned DEFAULT NULL,
  `item_count` int(10) unsigned NOT NULL COMMENT 'Line Item Count',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reporting for all orders';

--
-- Dumping data for table `reporting_orders`
--


--
-- Table structure for table `reporting_system_updates`
--

CREATE TABLE `reporting_system_updates` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `type` varchar(255) DEFAULT NULL COMMENT 'Update Type',
  `action` varchar(255) DEFAULT NULL COMMENT 'Action Performed',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reporting for system updates';

--
-- Dumping data for table `reporting_system_updates`
--


--
-- Table structure for table `reporting_users`
--

CREATE TABLE `reporting_users` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `type` varchar(255) DEFAULT NULL COMMENT 'User Type',
  `action` varchar(255) DEFAULT NULL COMMENT 'Action Performed',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Reporting for user actions';

--
-- Dumping data for table `reporting_users`
--


--
-- Table structure for table `review`
--

CREATE TABLE `review` (
  `review_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Review create date',
  `entity_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity id',
  `entity_pk_value` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product id',
  `status_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Status code',
  PRIMARY KEY (`review_id`),
  KEY `REVIEW_ENTITY_ID` (`entity_id`),
  KEY `REVIEW_STATUS_ID` (`status_id`),
  KEY `REVIEW_ENTITY_PK_VALUE` (`entity_pk_value`)
) ENGINE=InnoDB AUTO_INCREMENT=347 DEFAULT CHARSET=utf8 COMMENT='Review base information';

--
-- Dumping data for table `review`
--

INSERT INTO `review` VALUES (1,'2018-12-04 12:35:27',1,1,1),(2,'2018-12-04 12:35:27',1,1,1),(3,'2018-12-04 12:35:27',1,6,1),(4,'2018-12-04 12:35:27',1,6,1),(5,'2018-12-04 12:35:27',1,6,1),(6,'2018-12-04 12:35:27',1,3,1),(7,'2018-12-04 12:35:27',1,3,1),(8,'2018-12-04 12:35:27',1,3,1),(9,'2018-12-04 12:35:27',1,2,1),(10,'2018-12-04 12:35:27',1,2,1),(11,'2018-12-04 12:35:27',1,4,1),(12,'2018-12-04 12:35:27',1,4,1),(13,'2018-12-04 12:35:27',1,4,1),(14,'2018-12-04 12:35:27',1,5,1),(15,'2018-12-04 12:35:27',1,5,1),(16,'2018-12-04 12:35:27',1,37,1),(17,'2018-12-04 12:35:27',1,37,1),(18,'2018-12-04 12:35:27',1,37,1),(19,'2018-12-04 12:35:27',1,40,1),(20,'2018-12-04 12:35:27',1,40,1),(21,'2018-12-04 12:35:27',1,40,1),(22,'2018-12-04 12:35:27',1,38,1),(23,'2018-12-04 12:35:27',1,38,1),(24,'2018-12-04 12:35:27',1,38,1),(25,'2018-12-04 12:35:27',1,36,1),(26,'2018-12-04 12:35:27',1,36,1),(27,'2018-12-04 12:35:27',1,39,1),(28,'2018-12-04 12:35:27',1,39,1),(29,'2018-12-04 12:35:27',1,39,1),(30,'2018-12-04 12:35:27',1,39,1),(31,'2018-12-04 12:35:27',1,276,1),(32,'2018-12-04 12:35:27',1,276,1),(33,'2018-12-04 12:35:27',1,292,1),(34,'2018-12-04 12:35:27',1,292,1),(35,'2018-12-04 12:35:27',1,420,1),(36,'2018-12-04 12:35:27',1,420,1),(37,'2018-12-04 12:35:27',1,420,1),(38,'2018-12-04 12:35:27',1,308,1),(39,'2018-12-04 12:35:27',1,308,1),(40,'2018-12-04 12:35:27',1,308,1),(41,'2018-12-04 12:35:27',1,404,1),(42,'2018-12-04 12:35:27',1,404,1),(43,'2018-12-04 12:35:27',1,404,1),(44,'2018-12-04 12:35:27',1,324,1),(45,'2018-12-04 12:35:27',1,324,1),(46,'2018-12-04 12:35:28',1,340,1),(47,'2018-12-04 12:35:28',1,340,1),(48,'2018-12-04 12:35:28',1,340,1),(49,'2018-12-04 12:35:28',1,356,1),(50,'2018-12-04 12:35:28',1,356,1),(51,'2018-12-04 12:35:28',1,372,1),(52,'2018-12-04 12:35:28',1,372,1),(53,'2018-12-04 12:35:28',1,743,1),(54,'2018-12-04 12:35:28',1,743,1),(55,'2018-12-04 12:35:28',1,743,1),(56,'2018-12-04 12:35:28',1,756,1),(57,'2018-12-04 12:35:28',1,756,1),(58,'2018-12-04 12:35:28',1,756,1),(59,'2018-12-04 12:35:28',1,769,1),(60,'2018-12-04 12:35:28',1,769,1),(61,'2018-12-04 12:35:28',1,782,1),(62,'2018-12-04 12:35:28',1,782,1),(63,'2018-12-04 12:35:28',1,782,1),(64,'2018-12-04 12:35:28',1,795,1),(65,'2018-12-04 12:35:28',1,795,1),(66,'2018-12-04 12:35:28',1,795,1),(67,'2018-12-04 12:35:28',1,564,1),(68,'2018-12-04 12:35:28',1,564,1),(69,'2018-12-04 12:35:28',1,564,1),(70,'2018-12-04 12:35:28',1,580,1),(71,'2018-12-04 12:35:28',1,580,1),(72,'2018-12-04 12:35:28',1,532,1),(73,'2018-12-04 12:35:28',1,532,1),(74,'2018-12-04 12:35:28',1,452,1),(75,'2018-12-04 12:35:28',1,452,1),(76,'2018-12-04 12:35:28',1,452,1),(77,'2018-12-04 12:35:28',1,468,1),(78,'2018-12-04 12:35:28',1,468,1),(79,'2018-12-04 12:35:28',1,468,1),(80,'2018-12-04 12:35:28',1,548,1),(81,'2018-12-04 12:35:28',1,548,1),(82,'2018-12-04 12:35:28',1,612,1),(83,'2018-12-04 12:35:28',1,612,1),(84,'2018-12-04 12:35:28',1,612,1),(85,'2018-12-04 12:35:28',1,628,1),(86,'2018-12-04 12:35:28',1,628,1),(87,'2018-12-04 12:35:28',1,628,1),(88,'2018-12-04 12:35:28',1,628,1),(89,'2018-12-04 12:35:28',1,484,1),(90,'2018-12-04 12:35:28',1,484,1),(91,'2018-12-04 12:35:28',1,484,1),(92,'2018-12-04 12:35:28',1,596,1),(93,'2018-12-04 12:35:28',1,596,1),(94,'2018-12-04 12:35:28',1,596,1),(95,'2018-12-04 12:35:28',1,500,1),(96,'2018-12-04 12:35:28',1,500,1),(97,'2018-12-04 12:35:28',1,500,1),(98,'2018-12-04 12:35:28',1,516,1),(99,'2018-12-04 12:35:28',1,516,1),(100,'2018-12-04 12:35:28',1,516,1),(101,'2018-12-04 12:35:28',1,899,1),(102,'2018-12-04 12:35:28',1,899,1),(103,'2018-12-04 12:35:28',1,899,1),(104,'2018-12-04 12:35:28',1,917,1),(105,'2018-12-04 12:35:28',1,917,1),(106,'2018-12-04 12:35:28',1,917,1),(107,'2018-12-04 12:35:28',1,930,1),(108,'2018-12-04 12:35:28',1,930,1),(109,'2018-12-04 12:35:28',1,930,1),(110,'2018-12-04 12:35:28',1,943,1),(111,'2018-12-04 12:35:28',1,943,1),(112,'2018-12-04 12:35:28',1,943,1),(113,'2018-12-04 12:35:28',1,956,1),(114,'2018-12-04 12:35:28',1,956,1),(115,'2018-12-04 12:35:28',1,969,1),(116,'2018-12-04 12:35:28',1,969,1),(117,'2018-12-04 12:35:28',1,969,1),(118,'2018-12-04 12:35:28',1,982,1),(119,'2018-12-04 12:35:28',1,982,1),(120,'2018-12-04 12:35:28',1,995,1),(121,'2018-12-04 12:35:28',1,995,1),(122,'2018-12-04 12:35:28',1,995,1),(123,'2018-12-04 12:35:28',1,644,1),(124,'2018-12-04 12:35:28',1,644,1),(125,'2018-12-04 12:35:28',1,644,1),(126,'2018-12-04 12:35:28',1,644,1),(127,'2018-12-04 12:35:28',1,660,1),(128,'2018-12-04 12:35:28',1,660,1),(129,'2018-12-04 12:35:29',1,660,1),(130,'2018-12-04 12:35:29',1,676,1),(131,'2018-12-04 12:35:29',1,676,1),(132,'2018-12-04 12:35:29',1,676,1),(133,'2018-12-04 12:35:29',1,682,1),(134,'2018-12-04 12:35:29',1,682,1),(135,'2018-12-04 12:35:29',1,682,1),(136,'2018-12-04 12:35:29',1,682,1),(137,'2018-12-04 12:35:29',1,7,1),(138,'2018-12-04 12:35:29',1,7,1),(139,'2018-12-04 12:35:29',1,7,1),(140,'2018-12-04 12:35:29',1,20,1),(141,'2018-12-04 12:35:29',1,20,1),(142,'2018-12-04 12:35:29',1,20,1),(143,'2018-12-04 12:35:29',1,18,1),(144,'2018-12-04 12:35:29',1,18,1),(145,'2018-12-04 12:35:29',1,23,1),(146,'2018-12-04 12:35:29',1,23,1),(147,'2018-12-04 12:35:29',1,23,1),(148,'2018-12-04 12:35:29',1,17,1),(149,'2018-12-04 12:35:29',1,17,1),(150,'2018-12-04 12:35:29',1,17,1),(151,'2018-12-04 12:35:29',1,19,1),(152,'2018-12-04 12:35:29',1,19,1),(153,'2018-12-04 12:35:29',1,19,1),(154,'2018-12-04 12:35:29',1,15,1),(155,'2018-12-04 12:35:29',1,16,1),(156,'2018-12-04 12:35:29',1,16,1),(157,'2018-12-04 12:35:29',1,8,1),(158,'2018-12-04 12:35:29',1,8,1),(159,'2018-12-04 12:35:29',1,8,1),(160,'2018-12-04 12:35:29',1,9,1),(161,'2018-12-04 12:35:29',1,9,1),(162,'2018-12-04 12:35:29',1,12,1),(163,'2018-12-04 12:35:29',1,12,1),(164,'2018-12-04 12:35:29',1,14,1),(165,'2018-12-04 12:35:29',1,14,1),(166,'2018-12-04 12:35:29',1,14,1),(167,'2018-12-04 12:35:29',1,10,1),(168,'2018-12-04 12:35:29',1,10,1),(169,'2018-12-04 12:35:29',1,11,1),(170,'2018-12-04 12:35:29',1,11,1),(171,'2018-12-04 12:35:29',1,11,1),(172,'2018-12-04 12:35:29',1,13,1),(173,'2018-12-04 12:35:29',1,13,1),(174,'2018-12-04 12:35:29',1,13,1),(175,'2018-12-04 12:35:29',1,42,1),(176,'2018-12-04 12:35:29',1,42,1),(177,'2018-12-04 12:35:29',1,42,1),(178,'2018-12-04 12:35:29',1,44,1),(179,'2018-12-04 12:35:29',1,44,1),(180,'2018-12-04 12:35:29',1,43,1),(181,'2018-12-04 12:35:29',1,43,1),(182,'2018-12-04 12:35:29',1,43,1),(183,'2018-12-04 12:35:29',1,41,1),(184,'2018-12-04 12:35:29',1,41,1),(185,'2018-12-04 12:35:29',1,1050,1),(186,'2018-12-04 12:35:29',1,1050,1),(187,'2018-12-04 12:35:29',1,1050,1),(188,'2018-12-04 12:35:29',1,1066,1),(189,'2018-12-04 12:35:29',1,1066,1),(190,'2018-12-04 12:35:29',1,1066,1),(191,'2018-12-04 12:35:29',1,1082,1),(192,'2018-12-04 12:35:29',1,1082,1),(193,'2018-12-04 12:35:29',1,1082,1),(194,'2018-12-04 12:35:29',1,1098,1),(195,'2018-12-04 12:35:29',1,1098,1),(196,'2018-12-04 12:35:29',1,1098,1),(197,'2018-12-04 12:35:29',1,1114,1),(198,'2018-12-04 12:35:29',1,1114,1),(199,'2018-12-04 12:35:29',1,1114,1),(200,'2018-12-04 12:35:29',1,1120,1),(201,'2018-12-04 12:35:29',1,1120,1),(202,'2018-12-04 12:35:29',1,1226,1),(203,'2018-12-04 12:35:29',1,1226,1),(204,'2018-12-04 12:35:29',1,1226,1),(205,'2018-12-04 12:35:30',1,1242,1),(206,'2018-12-04 12:35:30',1,1242,1),(207,'2018-12-04 12:35:30',1,1242,1),(208,'2018-12-04 12:35:30',1,1242,1),(209,'2018-12-04 12:35:30',1,1258,1),(210,'2018-12-04 12:35:30',1,1258,1),(211,'2018-12-04 12:35:30',1,1258,1),(212,'2018-12-04 12:35:30',1,1274,1),(213,'2018-12-04 12:35:30',1,1274,1),(214,'2018-12-04 12:35:30',1,1290,1),(215,'2018-12-04 12:35:30',1,1290,1),(216,'2018-12-04 12:35:30',1,1290,1),(217,'2018-12-04 12:35:30',1,1386,1),(218,'2018-12-04 12:35:30',1,1386,1),(219,'2018-12-04 12:35:30',1,1386,1),(220,'2018-12-04 12:35:30',1,1306,1),(221,'2018-12-04 12:35:30',1,1306,1),(222,'2018-12-04 12:35:30',1,1306,1),(223,'2018-12-04 12:35:30',1,1322,1),(224,'2018-12-04 12:35:30',1,1322,1),(225,'2018-12-04 12:35:30',1,1338,1),(226,'2018-12-04 12:35:30',1,1338,1),(227,'2018-12-04 12:35:30',1,1338,1),(228,'2018-12-04 12:35:30',1,1354,1),(229,'2018-12-04 12:35:30',1,1354,1),(230,'2018-12-04 12:35:30',1,1354,1),(231,'2018-12-04 12:35:30',1,1370,1),(232,'2018-12-04 12:35:30',1,1370,1),(233,'2018-12-04 12:35:30',1,1370,1),(234,'2018-12-04 12:35:30',1,1825,1),(235,'2018-12-04 12:35:30',1,1825,1),(236,'2018-12-04 12:35:30',1,1832,1),(237,'2018-12-04 12:35:30',1,1832,1),(238,'2018-12-04 12:35:30',1,1832,1),(239,'2018-12-04 12:35:30',1,1839,1),(240,'2018-12-04 12:35:30',1,1839,1),(241,'2018-12-04 12:35:30',1,1839,1),(242,'2018-12-04 12:35:30',1,1846,1),(243,'2018-12-04 12:35:30',1,1846,1),(244,'2018-12-04 12:35:30',1,1846,1),(245,'2018-12-04 12:35:30',1,1846,1),(246,'2018-12-04 12:35:30',1,1853,1),(247,'2018-12-04 12:35:30',1,1853,1),(248,'2018-12-04 12:35:30',1,1860,1),(249,'2018-12-04 12:35:30',1,1860,1),(250,'2018-12-04 12:35:30',1,1860,1),(251,'2018-12-04 12:35:30',1,1578,1),(252,'2018-12-04 12:35:30',1,1578,1),(253,'2018-12-04 12:35:30',1,1578,1),(254,'2018-12-04 12:35:30',1,1418,1),(255,'2018-12-04 12:35:30',1,1418,1),(256,'2018-12-04 12:35:30',1,1418,1),(257,'2018-12-04 12:35:30',1,1434,1),(258,'2018-12-04 12:35:30',1,1434,1),(259,'2018-12-04 12:35:30',1,1434,1),(260,'2018-12-04 12:35:30',1,1434,1),(261,'2018-12-04 12:35:30',1,1450,1),(262,'2018-12-04 12:35:30',1,1450,1),(263,'2018-12-04 12:35:30',1,1594,1),(264,'2018-12-04 12:35:30',1,1594,1),(265,'2018-12-04 12:35:30',1,1594,1),(266,'2018-12-04 12:35:30',1,1482,1),(267,'2018-12-04 12:35:30',1,1482,1),(268,'2018-12-04 12:35:30',1,1498,1),(269,'2018-12-04 12:35:30',1,1498,1),(270,'2018-12-04 12:35:30',1,1498,1),(271,'2018-12-04 12:35:31',1,1514,1),(272,'2018-12-04 12:35:31',1,1514,1),(273,'2018-12-04 12:35:31',1,1514,1),(274,'2018-12-04 12:35:31',1,1530,1),(275,'2018-12-04 12:35:31',1,1530,1),(276,'2018-12-04 12:35:31',1,1530,1),(277,'2018-12-04 12:35:31',1,1546,1),(278,'2018-12-04 12:35:31',1,1546,1),(279,'2018-12-04 12:35:31',1,1546,1),(280,'2018-12-04 12:35:31',1,1562,1),(281,'2018-12-04 12:35:31',1,1562,1),(282,'2018-12-04 12:35:31',1,1562,1),(283,'2018-12-04 12:35:31',1,1925,1),(284,'2018-12-04 12:35:31',1,1925,1),(285,'2018-12-04 12:35:31',1,1925,1),(286,'2018-12-04 12:35:31',1,1941,1),(287,'2018-12-04 12:35:31',1,1941,1),(288,'2018-12-04 12:35:31',1,1941,1),(289,'2018-12-04 12:35:31',1,1957,1),(290,'2018-12-04 12:35:31',1,1957,1),(291,'2018-12-04 12:35:31',1,1973,1),(292,'2018-12-04 12:35:31',1,1973,1),(293,'2018-12-04 12:35:31',1,1989,1),(294,'2018-12-04 12:35:31',1,1989,1),(295,'2018-12-04 12:35:31',1,1989,1),(296,'2018-12-04 12:35:31',1,1996,1),(297,'2018-12-04 12:35:31',1,1996,1),(298,'2018-12-04 12:35:31',1,2003,1),(299,'2018-12-04 12:35:31',1,2003,1),(300,'2018-12-04 12:35:31',1,2003,1),(301,'2018-12-04 12:35:31',1,2009,1),(302,'2018-12-04 12:35:31',1,2009,1),(303,'2018-12-04 12:35:31',1,2009,1),(304,'2018-12-04 12:35:31',1,2016,1),(305,'2018-12-04 12:35:31',1,2016,1),(306,'2018-12-04 12:35:31',1,2016,1),(307,'2018-12-04 12:35:31',1,2023,1),(308,'2018-12-04 12:35:31',1,2023,1),(309,'2018-12-04 12:35:31',1,2023,1),(310,'2018-12-04 12:35:31',1,2030,1),(311,'2018-12-04 12:35:31',1,2030,1),(312,'2018-12-04 12:35:31',1,2030,1),(313,'2018-12-04 12:35:31',1,2046,1),(314,'2018-12-04 12:35:31',1,2046,1),(315,'2018-12-04 12:35:31',1,2046,1),(316,'2018-12-04 12:35:31',1,1610,1),(317,'2018-12-04 12:35:31',1,1610,1),(318,'2018-12-04 12:35:31',1,1610,1),(319,'2018-12-04 12:35:31',1,1610,1),(320,'2018-12-04 12:35:31',1,1626,1),(321,'2018-12-04 12:35:31',1,1626,1),(322,'2018-12-04 12:35:31',1,1626,1),(323,'2018-12-04 12:35:31',1,1626,1),(324,'2018-12-04 12:35:31',1,1642,1),(325,'2018-12-04 12:35:31',1,1642,1),(326,'2018-12-04 12:35:31',1,1642,1),(327,'2018-12-04 12:35:31',1,1658,1),(328,'2018-12-04 12:35:31',1,1658,1),(329,'2018-12-04 12:35:31',1,1658,1),(330,'2018-12-04 12:35:31',1,1674,1),(331,'2018-12-04 12:35:31',1,1674,1),(332,'2018-12-04 12:35:31',1,1674,1),(333,'2018-12-04 12:35:31',1,1770,1),(334,'2018-12-04 12:35:32',1,1770,1),(335,'2018-12-04 12:35:32',1,1770,1),(336,'2018-12-04 12:35:32',1,1786,1),(337,'2018-12-04 12:35:32',1,1802,1),(338,'2018-12-04 12:35:32',1,1802,1),(339,'2018-12-04 12:35:32',1,1802,1),(340,'2018-12-04 12:35:32',1,1818,1),(341,'2018-12-04 12:35:32',1,1818,1),(342,'2018-12-04 12:35:32',1,1690,1),(343,'2018-12-04 12:35:32',1,1690,1),(344,'2018-12-04 12:35:32',1,1706,1),(345,'2018-12-04 12:35:32',1,1706,1),(346,'2018-12-04 12:35:32',1,1706,1);

--
