-- 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 current_timestamp() 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 DEFAULT NULL COMMENT 'Method Description',
  `price` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Price',
  `error_message` text DEFAULT NULL COMMENT 'Error Message',
  `method_title` text DEFAULT NULL COMMENT 'Method Title',
  PRIMARY KEY (`rate_id`),
  KEY `QUOTE_SHIPPING_RATE_ADDRESS_ID` (`address_id`),
  CONSTRAINT `QUOTE_SHIPPING_RATE_ADDRESS_ID_QUOTE_ADDRESS_ADDRESS_ID` FOREIGN KEY (`address_id`) REFERENCES `quote_address` (`address_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Quote Shipping Rate';

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

INSERT INTO `quote_shipping_rate` VALUES (1,62,'2021-01-11 05:27:11','2021-01-11 05:27:11','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed'),(6,68,'2021-01-11 07:04:57','2021-01-11 07:04:57','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,10.0000,NULL,'Fixed'),(26,77,'2021-01-13 03:00:24','2021-01-13 03:00:24','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,60.0000,NULL,'Fixed'),(27,82,'2021-01-13 03:05:29','2021-01-13 03:05:29','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,10.0000,NULL,'Fixed'),(32,88,'2021-01-14 07:45:08','2021-01-14 07:45:08','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed'),(35,91,'2021-01-15 01:58:07','2021-01-15 01:58:07','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,20.0000,NULL,'Fixed'),(36,93,'2021-01-18 01:44:47','2021-01-18 01:44:47','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,15.0000,NULL,'Fixed'),(44,97,'2021-01-19 02:45:46','2021-01-19 02:45:46','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,80.0000,NULL,'Fixed'),(45,104,'2021-01-19 03:12:16','2021-01-19 03:12:16','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed'),(46,106,'2021-01-19 03:16:01','2021-01-19 03:16:01','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed'),(47,110,'2021-01-19 04:28:56','2021-01-19 04:28:56','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed'),(48,112,'2021-01-19 04:36:29','2021-01-19 04:36:29','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed'),(49,118,'2021-01-19 08:47:23','2021-01-19 08:47:23','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,5.0000,NULL,'Fixed'),(58,95,'2021-01-19 10:14:15','2021-01-19 10:14:15','freeshipping','Free Shipping','freeshipping_freeshipping','freeshipping',NULL,0.0000,NULL,'Free'),(62,123,'2021-01-20 02:36:14','2021-01-20 02:36:14','freeshipping','Free Shipping','freeshipping_freeshipping','freeshipping',NULL,0.0000,NULL,'Free'),(72,160,'2021-02-25 08:08:07','2021-02-25 08:08:07','freeshipping','Free Shipping','freeshipping_freeshipping','freeshipping',NULL,0.0000,NULL,'Free'),(73,160,'2021-02-25 08:08:07','2021-02-25 08:08:07','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,10.0000,NULL,'Fixed'),(77,172,'2021-07-06 04:08:23','2021-07-06 04:08:23','freeshipping','Free Shipping','freeshipping_freeshipping','freeshipping',NULL,0.0000,NULL,'Free'),(82,183,'2021-09-03 13:38:04','2021-09-03 13:38:04','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,25.0000,NULL,'Fixed'),(101,192,'2021-09-05 07:44:24','2021-09-05 07:44:24','freeshipping','Free Shipping','freeshipping_freeshipping','freeshipping',NULL,0.0000,NULL,'Free'),(110,200,'2021-09-09 10:24:19','2021-09-09 10:24:19','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,10.0000,NULL,'Fixed'),(116,203,'2021-09-09 16:52:51','2021-09-09 16:52:51','flatrate','Flat Rate','flatrate_flatrate','flatrate',NULL,10.0000,NULL,'Fixed'),(126,215,'2022-05-11 02:25:14','2022-05-11 02:25:14','freeshipping','Free Shipping','freeshipping_freeshipping','freeshipping',NULL,0.0000,NULL,'Free'),(134,217,'2022-05-11 07:04:20','2022-05-11 07:04:20','instore','In-Store Pickup Delivery','instore_pickup','pickup',NULL,0.0000,NULL,'Pick in Store'),(135,221,'2022-05-12 06:39:27','2022-05-12 06:39:27','instore','In-Store Pickup Delivery','instore_pickup','pickup',NULL,0.0000,NULL,'Pick in Store'),(153,219,'2022-05-12 07:38:21','2022-05-12 07:38:21','freeshipping','Free Shipping','freeshipping_freeshipping','freeshipping',NULL,0.0000,NULL,'Free');

--
-- 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`),
  CONSTRAINT `RATING_ENTITY_ID_RATING_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `rating_entity` (`entity_id`) ON DELETE CASCADE
) 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);

--
-- 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`),
  CONSTRAINT `RATING_OPTION_RATING_ID_RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`rating_id`) ON DELETE CASCADE
) 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);

--
-- 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`),
  CONSTRAINT `RATING_OPTION_VOTE_OPTION_ID_RATING_OPTION_OPTION_ID` FOREIGN KEY (`option_id`) REFERENCES `rating_option` (`option_id`) ON DELETE CASCADE,
  CONSTRAINT `RATING_OPTION_VOTE_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=utf8 COMMENT='Rating option values';

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

INSERT INTO `rating_option_vote` VALUES (1,15,'14.162.209.34',14162,NULL,3,3,2,100,5),(2,10,'14.162.209.34',14162,NULL,3,2,2,100,5),(3,5,'14.162.209.34',14162,NULL,3,1,2,100,5),(4,15,'14.162.209.34',14162,NULL,3,3,3,100,5),(5,10,'14.162.209.34',14162,NULL,3,2,3,100,5),(6,5,'14.162.209.34',14162,NULL,3,1,3,100,5),(7,5,'14.162.209.34',14162,NULL,4,1,4,100,5),(8,15,'14.162.209.34',14162,NULL,4,3,4,100,5),(9,10,'14.162.209.34',14162,NULL,4,2,4,100,5),(10,15,'14.162.209.34',14162,NULL,18,3,5,100,5),(11,10,'14.162.209.34',14162,NULL,18,2,5,100,5),(12,5,'14.162.209.34',14162,NULL,18,1,5,100,5),(13,15,'14.162.209.34',14162,NULL,19,3,6,100,5),(14,10,'14.162.209.34',14162,NULL,19,2,6,100,5),(15,5,'14.162.209.34',14162,NULL,19,1,6,100,5),(16,15,'14.162.209.34',14162,NULL,20,3,7,100,5),(17,10,'14.162.209.34',14162,NULL,20,2,7,100,5),(18,5,'14.162.209.34',14162,NULL,20,1,7,100,5),(19,5,'14.162.209.34',14162,NULL,21,1,8,100,5),(20,15,'14.162.209.34',14162,NULL,21,3,8,100,5),(21,10,'14.162.209.34',14162,NULL,21,2,8,100,5),(22,14,'14.162.209.34',14162,NULL,22,3,9,80,4),(23,9,'14.162.209.34',14162,NULL,22,2,9,80,4),(24,5,'14.162.209.34',14162,NULL,22,1,9,100,5),(25,5,'14.162.209.34',14162,NULL,23,1,10,100,5),(26,14,'14.162.209.34',14162,NULL,23,3,10,80,4),(27,9,'14.162.209.34',14162,NULL,23,2,10,80,4),(28,15,'14.162.209.34',14162,NULL,24,3,11,100,5),(29,8,'14.162.209.34',14162,NULL,24,2,11,60,3),(30,5,'14.162.209.34',14162,NULL,24,1,11,100,5),(31,10,'14.162.209.34',14162,NULL,25,2,12,100,5),(32,5,'14.162.209.34',14162,NULL,25,1,12,100,5),(33,15,'14.162.209.34',14162,NULL,25,3,12,100,5),(34,15,'14.162.209.34',14162,NULL,17,3,13,100,5),(35,10,'14.162.209.34',14162,NULL,17,2,13,100,5),(36,5,'14.162.209.34',14162,NULL,17,1,13,100,5),(37,5,'14.162.209.34',14162,NULL,2,1,14,100,5),(38,15,'14.162.209.34',14162,NULL,2,3,14,100,5),(39,9,'14.162.209.34',14162,NULL,2,2,14,80,4),(40,9,'14.162.209.34',14162,NULL,16,2,15,80,4),(41,5,'14.162.209.34',14162,NULL,16,1,15,100,5),(42,15,'14.162.209.34',14162,NULL,16,3,15,100,5),(43,15,'14.162.209.34',14162,NULL,15,3,16,100,5),(44,10,'14.162.209.34',14162,NULL,15,2,16,100,5),(45,5,'14.162.209.34',14162,NULL,15,1,16,100,5),(46,10,'14.162.209.34',14162,NULL,1,2,17,100,5),(47,5,'14.162.209.34',14162,NULL,1,1,17,100,5),(48,15,'14.162.209.34',14162,NULL,1,3,17,100,5),(49,15,'14.162.209.34',14162,NULL,2,3,18,100,5),(50,10,'14.162.209.34',14162,NULL,2,2,18,100,5),(51,5,'14.162.209.34',14162,NULL,2,1,18,100,5),(52,15,'14.162.209.34',14162,NULL,15,3,19,100,5),(53,10,'14.162.209.34',14162,NULL,15,2,19,100,5),(54,5,'14.162.209.34',14162,NULL,15,1,19,100,5),(55,15,'14.162.209.34',14162,NULL,3,3,20,100,5),(56,10,'14.162.209.34',14162,NULL,3,2,20,100,5),(57,5,'14.162.209.34',14162,NULL,3,1,20,100,5),(58,15,'14.162.209.34',14162,NULL,4,3,21,100,5),(59,10,'14.162.209.34',14162,NULL,4,2,21,100,5),(60,5,'14.162.209.34',14162,NULL,4,1,21,100,5),(61,15,'14.162.209.34',14162,NULL,16,3,22,100,5),(62,10,'14.162.209.34',14162,NULL,16,2,22,100,5),(63,5,'14.162.209.34',14162,NULL,16,1,22,100,5),(64,15,'14.162.209.34',14162,NULL,17,3,23,100,5),(65,10,'14.162.209.34',14162,NULL,17,2,23,100,5),(66,5,'14.162.209.34',14162,NULL,17,1,23,100,5),(67,5,'14.162.209.34',14162,NULL,18,1,24,100,5),(68,15,'14.162.209.34',14162,NULL,18,3,24,100,5),(69,10,'14.162.209.34',14162,NULL,18,2,24,100,5),(70,5,'14.162.209.34',14162,NULL,19,1,25,100,5),(71,15,'14.162.209.34',14162,NULL,19,3,25,100,5),(72,10,'14.162.209.34',14162,NULL,19,2,25,100,5),(73,14,'14.162.209.34',14162,NULL,19,3,26,80,4),(74,10,'14.162.209.34',14162,NULL,19,2,26,100,5),(75,5,'14.162.209.34',14162,NULL,19,1,26,100,5),(76,14,'14.162.209.34',14162,NULL,20,3,27,80,4),(77,10,'14.162.209.34',14162,NULL,20,2,27,100,5),(78,5,'14.162.209.34',14162,NULL,20,1,27,100,5),(79,15,'14.162.209.34',14162,NULL,21,3,28,100,5),(80,10,'14.162.209.34',14162,NULL,21,2,28,100,5),(81,4,'14.162.209.34',14162,NULL,21,1,28,80,4),(82,15,'14.162.209.34',14162,NULL,22,3,29,100,5),(83,10,'14.162.209.34',14162,NULL,22,2,29,100,5),(84,5,'14.162.209.34',14162,NULL,22,1,29,100,5),(85,10,'14.162.209.34',14162,NULL,23,2,30,100,5),(86,5,'14.162.209.34',14162,NULL,23,1,30,100,5),(87,15,'14.162.209.34',14162,NULL,23,3,30,100,5),(88,10,'14.162.209.34',14162,NULL,24,2,31,100,5),(89,5,'14.162.209.34',14162,NULL,24,1,31,100,5),(90,15,'14.162.209.34',14162,NULL,24,3,31,100,5),(91,15,'14.162.209.34',14162,NULL,25,3,32,100,5),(92,10,'14.162.209.34',14162,NULL,25,2,32,100,5),(93,5,'14.162.209.34',14162,NULL,25,1,32,100,5),(94,10,'14.162.209.34',14162,NULL,26,2,33,100,5),(95,5,'14.162.209.34',14162,NULL,26,1,33,100,5),(96,14,'14.162.209.34',14162,NULL,26,3,33,80,4),(97,14,'14.162.209.34',14162,NULL,27,3,34,80,4),(98,8,'14.162.209.34',14162,NULL,27,2,34,60,3),(99,4,'14.162.209.34',14162,NULL,27,1,34,80,4),(100,15,'14.162.209.34',14162,NULL,1,3,35,100,5),(101,9,'14.162.209.34',14162,NULL,1,2,35,80,4),(102,4,'14.162.209.34',14162,NULL,1,1,35,80,4),(103,13,'14.162.209.34',14162,NULL,2,3,36,60,3),(104,9,'14.162.209.34',14162,NULL,2,2,36,80,4),(105,4,'14.162.209.34',14162,NULL,2,1,36,80,4),(106,5,'14.162.209.34',14162,NULL,14,1,37,100,5),(107,15,'14.162.209.34',14162,NULL,14,3,37,100,5),(108,10,'14.162.209.34',14162,NULL,14,2,37,100,5),(109,5,'14.162.209.34',14162,NULL,15,1,38,100,5),(110,15,'14.162.209.34',14162,NULL,15,3,38,100,5),(111,10,'14.162.209.34',14162,NULL,15,2,38,100,5),(112,15,'14.162.218.101',14162,NULL,18,3,1,100,5),(113,10,'14.162.218.101',14162,NULL,18,2,1,100,5),(114,5,'14.162.218.101',14162,NULL,18,1,1,100,5),(115,15,'123.24.136.141',12324,NULL,5,3,39,100,5),(116,10,'123.24.136.141',12324,NULL,5,2,39,100,5),(117,5,'123.24.136.141',12324,NULL,5,1,39,100,5),(118,15,'123.24.136.141',12324,NULL,44,3,42,100,5),(119,10,'123.24.136.141',12324,NULL,44,2,42,100,5),(120,5,'123.24.136.141',12324,NULL,44,1,42,100,5),(121,15,'123.24.136.141',12324,NULL,45,3,43,100,5),(122,10,'123.24.136.141',12324,NULL,45,2,43,100,5),(123,5,'123.24.136.141',12324,NULL,45,1,43,100,5),(124,15,'123.24.136.141',12324,NULL,46,3,44,100,5),(125,10,'123.24.136.141',12324,NULL,46,2,44,100,5),(126,5,'123.24.136.141',12324,NULL,46,1,44,100,5),(127,10,'123.24.136.141',12324,NULL,47,2,45,100,5),(128,5,'123.24.136.141',12324,NULL,47,1,45,100,5),(129,15,'123.24.136.141',12324,NULL,47,3,45,100,5),(130,15,'123.24.136.141',12324,NULL,48,3,46,100,5),(131,10,'123.24.136.141',12324,NULL,48,2,46,100,5),(132,5,'123.24.136.141',12324,NULL,48,1,46,100,5),(133,15,'123.24.136.141',12324,NULL,49,3,47,100,5),(134,10,'123.24.136.141',12324,NULL,49,2,47,100,5),(135,5,'123.24.136.141',12324,NULL,49,1,47,100,5),(136,15,'123.24.136.141',12324,NULL,50,3,48,100,5),(137,10,'123.24.136.141',12324,NULL,50,2,48,100,5),(138,5,'123.24.136.141',12324,NULL,50,1,48,100,5),(139,5,'123.24.136.141',12324,NULL,51,1,49,100,5),(140,15,'123.24.136.141',12324,NULL,51,3,49,100,5),(141,10,'123.24.136.141',12324,NULL,51,2,49,100,5),(142,15,'123.24.136.141',12324,NULL,52,3,50,100,5),(143,10,'123.24.136.141',12324,NULL,52,2,50,100,5),(144,5,'123.24.136.141',12324,NULL,52,1,50,100,5),(145,10,'123.24.136.141',12324,NULL,53,2,51,100,5),(146,5,'123.24.136.141',12324,NULL,53,1,51,100,5),(147,15,'123.24.136.141',12324,NULL,53,3,51,100,5),(148,15,'123.24.136.141',12324,NULL,54,3,52,100,5),(149,10,'123.24.136.141',12324,NULL,54,2,52,100,5),(150,5,'123.24.136.141',12324,NULL,54,1,52,100,5),(151,15,'123.24.136.141',12324,NULL,55,3,53,100,5),(152,10,'123.24.136.141',12324,NULL,55,2,53,100,5),(153,5,'123.24.136.141',12324,NULL,55,1,53,100,5),(154,15,'123.24.136.141',12324,NULL,32,3,54,100,5),(155,10,'123.24.136.141',12324,NULL,32,2,54,100,5),(156,5,'123.24.136.141',12324,NULL,32,1,54,100,5),(157,10,'123.24.136.141',12324,NULL,33,2,55,100,5),(158,5,'123.24.136.141',12324,NULL,33,1,55,100,5),(159,15,'123.24.136.141',12324,NULL,33,3,55,100,5),(160,15,'123.24.136.141',12324,NULL,34,3,56,100,5),(161,10,'123.24.136.141',12324,NULL,34,2,56,100,5),(162,5,'123.24.136.141',12324,NULL,34,1,56,100,5),(163,15,'123.24.136.141',12324,NULL,35,3,57,100,5),(164,10,'123.24.136.141',12324,NULL,35,2,57,100,5),(165,5,'123.24.136.141',12324,NULL,35,1,57,100,5),(166,15,'123.24.136.141',12324,NULL,36,3,58,100,5),(167,10,'123.24.136.141',12324,NULL,36,2,58,100,5),(168,5,'123.24.136.141',12324,NULL,36,1,58,100,5),(169,10,'123.24.136.141',12324,NULL,37,2,59,100,5),(170,5,'123.24.136.141',12324,NULL,37,1,59,100,5),(171,15,'123.24.136.141',12324,NULL,37,3,59,100,5),(172,10,'123.24.136.141',12324,NULL,38,2,60,100,5),(173,5,'123.24.136.141',12324,NULL,38,1,60,100,5),(174,15,'123.24.136.141',12324,NULL,38,3,60,100,5),(175,10,'123.24.136.141',12324,NULL,39,2,61,100,5),(176,5,'123.24.136.141',12324,NULL,39,1,61,100,5),(177,15,'123.24.136.141',12324,NULL,39,3,61,100,5),(178,10,'123.24.136.141',12324,NULL,40,2,62,100,5),(179,5,'123.24.136.141',12324,NULL,40,1,62,100,5),(180,15,'123.24.136.141',12324,NULL,40,3,62,100,5),(181,15,'123.24.136.141',12324,NULL,41,3,63,100,5),(182,10,'123.24.136.141',12324,NULL,41,2,63,100,5),(183,5,'123.24.136.141',12324,NULL,41,1,63,100,5),(184,10,'123.24.136.141',12324,NULL,42,2,64,100,5),(185,5,'123.24.136.141',12324,NULL,42,1,64,100,5),(186,15,'123.24.136.141',12324,NULL,42,3,64,100,5);

--
-- 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`),
  CONSTRAINT `RATING_OPTION_VOTE_AGGREGATED_RATING_ID_RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`rating_id`) ON DELETE CASCADE,
  CONSTRAINT `RATING_OPTION_VOTE_AGGREGATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=822 DEFAULT CHARSET=utf8 COMMENT='Rating vote aggregated';

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

INSERT INTO `rating_option_vote_aggregated` VALUES (1,3,3,3,15,100,100,0),(3,2,3,3,15,100,100,0),(4,2,3,3,15,100,100,1),(5,1,3,3,15,100,100,0),(6,1,3,3,15,100,100,1),(7,1,4,2,10,100,100,0),(8,1,4,2,10,100,100,1),(9,3,4,2,10,100,100,0),(11,2,4,2,10,100,100,0),(12,2,4,2,10,100,100,1),(13,3,18,3,15,100,100,0),(15,2,18,3,15,100,100,0),(16,2,18,3,15,100,100,1),(17,1,18,3,15,100,100,0),(18,1,18,3,15,100,100,1),(19,3,19,3,14,93,93,0),(21,2,19,3,15,100,100,0),(22,2,19,3,15,100,100,1),(23,1,19,3,15,100,100,0),(24,1,19,3,15,100,100,1),(25,3,20,2,9,90,90,0),(27,2,20,2,10,100,100,0),(28,2,20,2,10,100,100,1),(29,1,20,2,10,100,100,0),(30,1,20,2,10,100,100,1),(31,1,21,2,9,90,90,0),(32,1,21,2,9,90,90,1),(33,3,21,2,10,100,100,0),(35,2,21,2,10,100,100,0),(36,2,21,2,10,100,100,1),(37,3,22,2,9,90,90,0),(39,2,22,2,9,90,90,0),(40,2,22,2,9,90,90,1),(41,1,22,2,10,100,100,0),(42,1,22,2,10,100,100,1),(43,1,23,2,10,100,100,0),(44,1,23,2,10,100,100,1),(45,3,23,2,9,90,90,0),(47,2,23,2,9,90,90,0),(48,2,23,2,9,90,90,1),(49,3,24,2,10,100,100,0),(51,2,24,2,8,80,80,0),(52,2,24,2,8,80,80,1),(53,1,24,2,10,100,100,0),(54,1,24,2,10,100,100,1),(55,2,25,2,10,100,100,0),(56,2,25,2,10,100,100,1),(57,1,25,2,10,100,100,0),(58,1,25,2,10,100,100,1),(59,3,25,2,10,100,100,0),(61,3,17,2,10,100,100,0),(63,2,17,2,10,100,100,0),(64,2,17,2,10,100,100,1),(65,1,17,2,10,100,100,0),(66,1,17,2,10,100,100,1),(67,1,2,3,14,93,93,0),(68,1,2,3,14,93,93,1),(69,3,2,3,13,87,87,0),(71,2,2,3,13,87,87,0),(72,2,2,3,13,87,87,1),(73,2,16,2,9,90,90,0),(74,2,16,2,9,90,90,1),(75,1,16,2,10,100,100,0),(76,1,16,2,10,100,100,1),(77,3,16,2,10,100,100,0),(79,3,15,3,15,100,100,0),(81,2,15,3,15,100,100,0),(82,2,15,3,15,100,100,1),(83,1,15,3,15,100,100,0),(84,1,15,3,15,100,100,1),(85,2,1,2,9,90,90,0),(86,2,1,2,9,90,90,1),(87,1,1,2,9,90,90,0),(88,1,1,2,9,90,90,1),(89,3,1,2,10,100,100,0),(91,2,26,1,5,100,100,0),(92,2,26,1,5,100,100,1),(93,1,26,1,5,100,100,0),(94,1,26,1,5,100,100,1),(95,3,26,1,4,80,80,0),(97,3,27,1,4,80,80,0),(99,2,27,1,3,60,60,0),(100,2,27,1,3,60,60,1),(101,1,27,1,4,80,80,0),(102,1,27,1,4,80,80,1),(103,1,14,1,5,100,100,0),(104,1,14,1,5,100,100,1),(105,3,14,1,5,100,100,0),(107,2,14,1,5,100,100,0),(108,2,14,1,5,100,100,1),(109,1,14,1,5,100,100,5),(110,1,14,1,5,100,100,6),(111,1,14,1,5,100,100,7),(112,2,14,1,5,100,100,5),(113,2,14,1,5,100,100,6),(114,2,14,1,5,100,100,7),(118,1,1,2,9,90,90,5),(119,1,1,2,9,90,90,6),(120,1,1,2,9,90,90,7),(121,2,1,2,9,90,90,5),(122,2,1,2,9,90,90,6),(123,2,1,2,9,90,90,7),(127,1,2,3,14,93,93,5),(128,1,2,3,14,93,93,6),(129,1,2,3,14,93,93,7),(130,2,2,3,13,87,87,5),(131,2,2,3,13,87,87,6),(132,2,2,3,13,87,87,7),(136,1,3,3,15,100,100,5),(137,1,3,3,15,100,100,6),(138,1,3,3,15,100,100,7),(139,2,3,3,15,100,100,5),(140,2,3,3,15,100,100,6),(141,2,3,3,15,100,100,7),(145,1,15,3,15,100,100,5),(146,1,15,3,15,100,100,6),(147,1,15,3,15,100,100,7),(148,2,15,3,15,100,100,5),(149,2,15,3,15,100,100,6),(150,2,15,3,15,100,100,7),(154,1,27,1,4,80,80,5),(155,1,27,1,4,80,80,6),(156,1,27,1,4,80,80,7),(157,1,27,1,4,80,80,8),(158,2,27,1,3,60,60,5),(159,2,27,1,3,60,60,6),(160,2,27,1,3,60,60,7),(161,2,27,1,3,60,60,8),(166,1,26,1,5,100,100,5),(167,1,26,1,5,100,100,6),(168,1,26,1,5,100,100,7),(169,1,26,1,5,100,100,8),(170,2,26,1,5,100,100,5),(171,2,26,1,5,100,100,6),(172,2,26,1,5,100,100,7),(173,2,26,1,5,100,100,8),(178,1,23,2,10,100,100,5),(179,1,23,2,10,100,100,6),(180,1,23,2,10,100,100,7),(181,1,23,2,10,100,100,8),(182,2,23,2,9,90,90,5),(183,2,23,2,9,90,90,6),(184,2,23,2,9,90,90,7),(185,2,23,2,9,90,90,8),(190,1,22,2,10,100,100,5),(191,1,22,2,10,100,100,6),(192,1,22,2,10,100,100,7),(193,1,22,2,10,100,100,8),(194,2,22,2,9,90,90,5),(195,2,22,2,9,90,90,6),(196,2,22,2,9,90,90,7),(197,2,22,2,9,90,90,8),(202,1,24,2,10,100,100,5),(203,1,24,2,10,100,100,6),(204,1,24,2,10,100,100,7),(205,1,24,2,10,100,100,8),(206,2,24,2,8,80,80,5),(207,2,24,2,8,80,80,6),(208,2,24,2,8,80,80,7),(209,2,24,2,8,80,80,8),(214,1,2,3,14,93,93,8),(215,2,2,3,13,87,87,8),(217,1,16,2,10,100,100,5),(218,1,16,2,10,100,100,6),(219,1,16,2,10,100,100,7),(220,1,16,2,10,100,100,8),(221,2,16,2,9,90,90,5),(222,2,16,2,9,90,90,6),(223,2,16,2,9,90,90,7),(224,2,16,2,9,90,90,8),(229,1,20,2,10,100,100,5),(230,1,20,2,10,100,100,6),(231,1,20,2,10,100,100,7),(232,1,20,2,10,100,100,8),(233,2,20,2,10,100,100,5),(234,2,20,2,10,100,100,6),(235,2,20,2,10,100,100,7),(236,2,20,2,10,100,100,8),(241,1,21,2,9,90,90,5),(242,1,21,2,9,90,90,6),(243,1,21,2,9,90,90,7),(244,1,21,2,9,90,90,8),(245,2,21,2,10,100,100,5),(246,2,21,2,10,100,100,6),(247,2,21,2,10,100,100,7),(248,2,21,2,10,100,100,8),(253,1,19,3,15,100,100,5),(254,1,19,3,15,100,100,6),(255,1,19,3,15,100,100,7),(256,1,19,3,15,100,100,8),(257,2,19,3,15,100,100,5),(258,2,19,3,15,100,100,6),(259,2,19,3,15,100,100,7),(260,2,19,3,15,100,100,8),(265,1,15,3,15,100,100,8),(266,1,15,3,15,100,100,9),(267,1,15,3,15,100,100,10),(268,1,15,3,15,100,100,11),(271,2,15,3,15,100,100,8),(272,2,15,3,15,100,100,9),(273,2,15,3,15,100,100,10),(274,2,15,3,15,100,100,11),(283,1,2,3,14,93,93,9),(284,1,2,3,14,93,93,10),(285,1,2,3,14,93,93,11),(288,2,2,3,13,87,87,9),(289,2,2,3,13,87,87,10),(290,2,2,3,13,87,87,11),(298,1,14,1,5,100,100,8),(299,1,14,1,5,100,100,9),(300,1,14,1,5,100,100,10),(301,1,14,1,5,100,100,11),(304,2,14,1,5,100,100,8),(305,2,14,1,5,100,100,9),(306,2,14,1,5,100,100,10),(307,2,14,1,5,100,100,11),(316,1,27,1,4,80,80,9),(317,1,27,1,4,80,80,10),(318,1,27,1,4,80,80,11),(321,2,27,1,3,60,60,9),(322,2,27,1,3,60,60,10),(323,2,27,1,3,60,60,11),(331,1,26,1,5,100,100,9),(332,1,26,1,5,100,100,10),(333,1,26,1,5,100,100,11),(336,2,26,1,5,100,100,9),(337,2,26,1,5,100,100,10),(338,2,26,1,5,100,100,11),(346,1,1,2,9,90,90,8),(347,1,1,2,9,90,90,9),(348,1,1,2,9,90,90,10),(349,1,1,2,9,90,90,11),(352,2,1,2,9,90,90,8),(353,2,1,2,9,90,90,9),(354,2,1,2,9,90,90,10),(355,2,1,2,9,90,90,11),(364,1,23,2,10,100,100,9),(365,1,23,2,10,100,100,10),(366,1,23,2,10,100,100,11),(369,2,23,2,9,90,90,9),(370,2,23,2,9,90,90,10),(371,2,23,2,9,90,90,11),(379,1,25,2,10,100,100,5),(380,1,25,2,10,100,100,6),(381,1,25,2,10,100,100,7),(382,1,25,2,10,100,100,8),(383,1,25,2,10,100,100,9),(384,1,25,2,10,100,100,10),(385,1,25,2,10,100,100,11),(388,2,25,2,10,100,100,5),(389,2,25,2,10,100,100,6),(390,2,25,2,10,100,100,7),(391,2,25,2,10,100,100,8),(392,2,25,2,10,100,100,9),(393,2,25,2,10,100,100,10),(394,2,25,2,10,100,100,11),(406,1,24,2,10,100,100,9),(407,1,24,2,10,100,100,10),(408,1,24,2,10,100,100,11),(411,2,24,2,8,80,80,9),(412,2,24,2,8,80,80,10),(413,2,24,2,8,80,80,11),(421,1,22,2,10,100,100,9),(422,1,22,2,10,100,100,10),(423,1,22,2,10,100,100,11),(426,2,22,2,9,90,90,9),(427,2,22,2,9,90,90,10),(428,2,22,2,9,90,90,11),(436,1,21,2,9,90,90,9),(437,1,21,2,9,90,90,10),(438,1,21,2,9,90,90,11),(441,2,21,2,10,100,100,9),(442,2,21,2,10,100,100,10),(443,2,21,2,10,100,100,11),(451,1,20,2,10,100,100,9),(452,1,20,2,10,100,100,10),(453,1,20,2,10,100,100,11),(456,2,20,2,10,100,100,9),(457,2,20,2,10,100,100,10),(458,2,20,2,10,100,100,11),(466,1,19,3,15,100,100,9),(467,1,19,3,15,100,100,10),(468,1,19,3,15,100,100,11),(471,2,19,3,15,100,100,9),(472,2,19,3,15,100,100,10),(473,2,19,3,15,100,100,11),(481,1,18,3,15,100,100,5),(482,1,18,3,15,100,100,6),(483,1,18,3,15,100,100,7),(484,1,18,3,15,100,100,8),(485,1,18,3,15,100,100,9),(486,1,18,3,15,100,100,10),(487,1,18,3,15,100,100,11),(490,2,18,3,15,100,100,5),(491,2,18,3,15,100,100,6),(492,2,18,3,15,100,100,7),(493,2,18,3,15,100,100,8),(494,2,18,3,15,100,100,9),(495,2,18,3,15,100,100,10),(496,2,18,3,15,100,100,11),(508,1,17,2,10,100,100,5),(509,1,17,2,10,100,100,6),(510,1,17,2,10,100,100,7),(511,1,17,2,10,100,100,8),(512,1,17,2,10,100,100,9),(513,1,17,2,10,100,100,10),(514,1,17,2,10,100,100,11),(517,2,17,2,10,100,100,5),(518,2,17,2,10,100,100,6),(519,2,17,2,10,100,100,7),(520,2,17,2,10,100,100,8),(521,2,17,2,10,100,100,9),(522,2,17,2,10,100,100,10),(523,2,17,2,10,100,100,11),(535,1,16,2,10,100,100,9),(536,1,16,2,10,100,100,10),(537,1,16,2,10,100,100,11),(540,2,16,2,9,90,90,9),(541,2,16,2,9,90,90,10),(542,2,16,2,9,90,90,11),(550,1,4,2,10,100,100,5),(551,1,4,2,10,100,100,6),(552,1,4,2,10,100,100,7),(553,1,4,2,10,100,100,8),(554,1,4,2,10,100,100,9),(555,1,4,2,10,100,100,10),(556,1,4,2,10,100,100,11),(559,2,4,2,10,100,100,5),(560,2,4,2,10,100,100,6),(561,2,4,2,10,100,100,7),(562,2,4,2,10,100,100,8),(563,2,4,2,10,100,100,9),(564,2,4,2,10,100,100,10),(565,2,4,2,10,100,100,11),(577,1,3,3,15,100,100,8),(578,1,3,3,15,100,100,9),(579,1,3,3,15,100,100,10),(580,1,3,3,15,100,100,11),(583,2,3,3,15,100,100,8),(584,2,3,3,15,100,100,9),(585,2,3,3,15,100,100,10),(586,2,3,3,15,100,100,11),(595,3,5,1,5,100,100,0),(597,2,5,1,5,100,100,0),(598,2,5,1,5,100,100,1),(599,1,5,1,5,100,100,0),(600,1,5,1,5,100,100,1),(601,3,44,1,5,100,100,0),(602,3,44,1,5,100,100,17),(603,2,44,1,5,100,100,0),(604,2,44,1,5,100,100,17),(605,1,44,1,5,100,100,0),(606,1,44,1,5,100,100,17),(607,3,45,1,5,100,100,0),(608,3,45,1,5,100,100,17),(609,2,45,1,5,100,100,0),(610,2,45,1,5,100,100,17),(611,1,45,1,5,100,100,0),(612,1,45,1,5,100,100,17),(613,3,46,1,5,100,100,0),(614,3,46,1,5,100,100,17),(615,2,46,1,5,100,100,0),(616,2,46,1,5,100,100,17),(617,1,46,1,5,100,100,0),(618,1,46,1,5,100,100,17),(619,2,47,1,5,100,100,0),(620,2,47,1,5,100,100,17),(621,1,47,1,5,100,100,0),(622,1,47,1,5,100,100,17),(623,3,47,1,5,100,100,0),(624,3,47,1,5,100,100,17),(625,3,48,1,5,100,100,0),(626,3,48,1,5,100,100,17),(627,2,48,1,5,100,100,0),(628,2,48,1,5,100,100,17),(629,1,48,1,5,100,100,0),(630,1,48,1,5,100,100,17),(631,3,49,1,5,100,100,0),(632,3,49,1,5,100,100,17),(633,2,49,1,5,100,100,0),(634,2,49,1,5,100,100,17),(635,1,49,1,5,100,100,0),(636,1,49,1,5,100,100,17),(637,3,50,1,5,100,100,0),(638,3,50,1,5,100,100,17),(639,2,50,1,5,100,100,0),(640,2,50,1,5,100,100,17),(641,1,50,1,5,100,100,0),(642,1,50,1,5,100,100,17),(643,1,51,1,5,100,100,0),(644,1,51,1,5,100,100,17),(645,3,51,1,5,100,100,0),(646,3,51,1,5,100,100,17),(647,2,51,1,5,100,100,0),(648,2,51,1,5,100,100,17),(649,3,52,1,5,100,100,0),(650,3,52,1,5,100,100,17),(651,2,52,1,5,100,100,0),(652,2,52,1,5,100,100,17),(653,1,52,1,5,100,100,0),(654,1,52,1,5,100,100,17),(655,2,53,1,5,100,100,0),(656,2,53,1,5,100,100,17),(657,1,53,1,5,100,100,0),(658,1,53,1,5,100,100,17),(659,3,53,1,5,100,100,0),(660,3,53,1,5,100,100,17),(661,3,54,1,5,100,100,0),(662,3,54,1,5,100,100,17),(663,2,54,1,5,100,100,0),(664,2,54,1,5,100,100,17),(665,1,54,1,5,100,100,0),(666,1,54,1,5,100,100,17),(667,3,55,1,5,100,100,0),(668,3,55,1,5,100,100,17),(669,2,55,1,5,100,100,0),(670,2,55,1,5,100,100,17),(671,1,55,1,5,100,100,0),(672,1,55,1,5,100,100,17),(673,3,32,1,5,100,100,0),(674,3,32,1,5,100,100,15),(675,2,32,1,5,100,100,0),(676,2,32,1,5,100,100,15),(677,1,32,1,5,100,100,0),(678,1,32,1,5,100,100,15),(679,2,33,1,5,100,100,0),(680,2,33,1,5,100,100,15),(681,1,33,1,5,100,100,0),(682,1,33,1,5,100,100,15),(683,3,33,1,5,100,100,0),(684,3,33,1,5,100,100,15),(685,3,34,1,5,100,100,0),(686,3,34,1,5,100,100,15),(687,2,34,1,5,100,100,0),(688,2,34,1,5,100,100,15),(689,1,34,1,5,100,100,0),(690,1,34,1,5,100,100,15),(691,3,35,1,5,100,100,0),(692,3,35,1,5,100,100,15),(693,2,35,1,5,100,100,0),(694,2,35,1,5,100,100,15),(695,1,35,1,5,100,100,0),(696,1,35,1,5,100,100,15),(697,3,36,1,5,100,100,0),(698,3,36,1,5,100,100,15),(699,2,36,1,5,100,100,0),(700,2,36,1,5,100,100,15),(701,1,36,1,5,100,100,0),(702,1,36,1,5,100,100,15),(703,2,37,1,5,100,100,0),(704,2,37,1,5,100,100,15),(705,1,37,1,5,100,100,0),(706,1,37,1,5,100,100,15),(707,3,37,1,5,100,100,0),(708,3,37,1,5,100,100,15),(709,2,38,1,5,100,100,0),(710,2,38,1,5,100,100,15),(711,1,38,1,5,100,100,0),(712,1,38,1,5,100,100,15),(713,3,38,1,5,100,100,0),(714,3,38,1,5,100,100,15),(715,2,39,1,5,100,100,0),(716,2,39,1,5,100,100,15),(717,1,39,1,5,100,100,0),(718,1,39,1,5,100,100,15),(719,3,39,1,5,100,100,0),(720,3,39,1,5,100,100,15),(721,2,40,1,5,100,100,0),(722,2,40,1,5,100,100,15),(723,1,40,1,5,100,100,0),(724,1,40,1,5,100,100,15),(725,3,40,1,5,100,100,0),(726,3,40,1,5,100,100,15),(727,3,41,1,5,100,100,0),(728,3,41,1,5,100,100,15),(729,2,41,1,5,100,100,0),(730,2,41,1,5,100,100,15),(731,1,41,1,5,100,100,0),(732,1,41,1,5,100,100,15),(733,2,42,1,5,100,100,0),(734,2,42,1,5,100,100,15),(735,1,42,1,5,100,100,0),(736,1,42,1,5,100,100,15),(737,3,42,1,5,100,100,0),(738,3,42,1,5,100,100,15),(739,1,52,1,5,100,100,16),(740,2,52,1,5,100,100,16),(741,3,52,1,5,100,100,16),(742,1,42,1,5,100,100,14),(743,2,42,1,5,100,100,14),(744,3,42,1,5,100,100,14),(745,1,41,1,5,100,100,14),(746,2,41,1,5,100,100,14),(747,3,41,1,5,100,100,14),(748,1,40,1,5,100,100,14),(749,2,40,1,5,100,100,14),(750,3,40,1,5,100,100,14),(751,1,39,1,5,100,100,14),(752,2,39,1,5,100,100,14),(753,3,39,1,5,100,100,14),(754,1,38,1,5,100,100,14),(755,2,38,1,5,100,100,14),(756,3,38,1,5,100,100,14),(757,1,37,1,5,100,100,14),(758,2,37,1,5,100,100,14),(759,3,37,1,5,100,100,14),(760,1,36,1,5,100,100,14),(761,2,36,1,5,100,100,14),(762,3,36,1,5,100,100,14),(763,1,35,1,5,100,100,14),(764,2,35,1,5,100,100,14),(765,3,35,1,5,100,100,14),(766,1,34,1,5,100,100,14),(767,2,34,1,5,100,100,14),(768,3,34,1,5,100,100,14),(769,1,33,1,5,100,100,14),(770,2,33,1,5,100,100,14),(771,3,33,1,5,100,100,14),(772,1,32,1,5,100,100,14),(773,2,32,1,5,100,100,14),(774,3,32,1,5,100,100,14),(775,1,55,1,5,100,100,16),(776,2,55,1,5,100,100,16),(777,3,55,1,5,100,100,16),(778,1,54,1,5,100,100,16),(779,2,54,1,5,100,100,16),(780,3,54,1,5,100,100,16),(781,1,53,1,5,100,100,16),(782,2,53,1,5,100,100,16),(783,3,53,1,5,100,100,16),(784,1,51,1,5,100,100,16),(785,2,51,1,5,100,100,16),(786,3,51,1,5,100,100,16),(787,1,50,1,5,100,100,16),(788,2,50,1,5,100,100,16),(789,3,50,1,5,100,100,16),(790,1,49,1,5,100,100,16),(791,2,49,1,5,100,100,16),(792,3,49,1,5,100,100,16),(793,1,48,1,5,100,100,16),(794,2,48,1,5,100,100,16),(795,3,48,1,5,100,100,16),(796,1,47,1,5,100,100,16),(797,2,47,1,5,100,100,16),(798,3,47,1,5,100,100,16),(799,1,46,1,5,100,100,16),(800,2,46,1,5,100,100,16),(801,3,46,1,5,100,100,16),(802,1,45,1,5,100,100,16),(803,2,45,1,5,100,100,16),(804,3,45,1,5,100,100,16),(805,1,44,1,5,100,100,16),(806,2,44,1,5,100,100,16),(807,3,44,1,5,100,100,16),(808,1,5,1,5,100,100,5),(809,1,5,1,5,100,100,6),(810,1,5,1,5,100,100,7),(811,1,5,1,5,100,100,8),(812,1,5,1,5,100,100,9),(813,1,5,1,5,100,100,10),(814,1,5,1,5,100,100,11),(815,2,5,1,5,100,100,5),(816,2,5,1,5,100,100,6),(817,2,5,1,5,100,100,7),(818,2,5,1,5,100,100,8),(819,2,5,1,5,100,100,9),(820,2,5,1,5,100,100,10),(821,2,5,1,5,100,100,11);

--
-- 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`),
  CONSTRAINT `RATING_STORE_RATING_ID_RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`rating_id`) ON DELETE CASCADE,
  CONSTRAINT `RATING_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rating Store';

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

INSERT INTO `rating_store` VALUES (1,0),(1,1),(1,5),(1,6),(1,7),(1,8),(1,9),(1,10),(1,11),(1,14),(1,15),(1,16),(1,17),(2,0),(2,1),(2,5),(2,6),(2,7),(2,8),(2,9),(2,10),(2,11),(2,14),(2,15),(2,16),(2,17),(3,0),(3,14),(3,15),(3,16),(3,17);

--
-- 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`),
  CONSTRAINT `RATING_TITLE_RATING_ID_RATING_RATING_ID` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`rating_id`) ON DELETE CASCADE,
  CONSTRAINT `RATING_TITLE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) 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`),
  CONSTRAINT `RELEASE_NOTIFICATION_VIEWER_LOG_VIEWER_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`viewer_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE
) 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`),
  CONSTRAINT `REPORT_CMPD_PRD_IDX_CSTR_ID_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_CMPD_PRD_IDX_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_COMPARED_PRODUCT_INDEX_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) 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`),
  CONSTRAINT `REPORT_EVENT_EVENT_TYPE_ID_REPORT_EVENT_TYPES_EVENT_TYPE_ID` FOREIGN KEY (`event_type_id`) REFERENCES `report_event_types` (`event_type_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_EVENT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) 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`),
  CONSTRAINT `REPORT_VIEWED_PRD_AGGRED_DAILY_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_VIEWED_PRODUCT_AGGREGATED_DAILY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) 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`),
  CONSTRAINT `REPORT_VIEWED_PRD_AGGRED_MONTHLY_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_VIEWED_PRODUCT_AGGREGATED_MONTHLY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) 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`),
  CONSTRAINT `REPORT_VIEWED_PRD_AGGRED_YEARLY_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_VIEWED_PRODUCT_AGGREGATED_YEARLY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) 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`),
  CONSTRAINT `REPORT_VIEWED_PRD_IDX_CSTR_ID_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_VIEWED_PRD_IDX_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REPORT_VIEWED_PRODUCT_INDEX_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) 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(20,4) unsigned DEFAULT NULL,
  `total_base` decimal(20,4) 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`),
  CONSTRAINT `REVIEW_ENTITY_ID_REVIEW_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `review_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID` FOREIGN KEY (`status_id`) REFERENCES `review_status` (`status_id`) ON DELETE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COMMENT='Review base information';

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

INSERT INTO `review` VALUES (1,'2020-11-28 07:54:11',1,18,1),(2,'2020-12-16 02:48:46',1,3,1),(3,'2020-12-16 03:00:11',1,3,1),(4,'2020-12-16 03:06:25',1,4,1),(5,'2020-12-16 03:12:11',1,18,1),(6,'2020-12-16 03:12:51',1,19,1),(7,'2020-12-16 03:13:17',1,20,1),(8,'2020-12-16 03:13:47',1,21,1),(9,'2020-12-16 03:14:25',1,22,1),(10,'2020-12-16 03:15:04',1,23,1),(11,'2020-12-16 03:15:26',1,24,1),(12,'2020-12-16 03:15:50',1,25,1),(13,'2020-12-16 03:16:19',1,17,1),(14,'2020-12-16 03:34:36',1,2,1),(15,'2020-12-16 03:34:52',1,16,1),(16,'2020-12-16 03:35:13',1,15,1),(17,'2020-12-16 03:35:41',1,1,1),(18,'2020-12-16 03:35:57',1,2,1),(19,'2020-12-16 03:36:17',1,15,1),(20,'2020-12-22 07:15:20',1,3,1),(21,'2020-12-22 07:15:33',1,4,1),(22,'2020-12-22 07:15:51',1,16,1),(23,'2020-12-22 07:16:17',1,17,1),(24,'2020-12-22 07:16:34',1,18,1),(25,'2020-12-22 07:16:51',1,19,1),(26,'2020-12-22 07:18:24',1,19,1),(27,'2020-12-22 07:18:50',1,20,1),(28,'2020-12-22 07:19:10',1,21,1),(29,'2020-12-22 07:19:22',1,22,1),(30,'2020-12-22 07:19:54',1,23,1),(31,'2020-12-22 07:20:06',1,24,1),(32,'2020-12-22 07:20:25',1,25,1),(33,'2020-12-22 07:20:48',1,26,1),(34,'2020-12-22 07:21:04',1,27,1),(35,'2020-12-22 07:21:27',1,1,1),(36,'2020-12-22 07:21:57',1,2,1),(37,'2020-12-22 07:22:15',1,14,1),(38,'2020-12-22 07:22:44',1,15,1),(39,'2020-12-30 09:30:11',1,5,1),(40,'2020-12-30 09:37:04',1,44,1),(41,'2020-12-30 09:38:30',1,45,1),(42,'2020-12-30 09:42:43',1,44,1),(43,'2020-12-30 09:43:34',1,45,1),(44,'2020-12-30 09:43:56',1,46,1),(45,'2020-12-30 09:44:13',1,47,1),(46,'2020-12-30 09:44:30',1,48,1),(47,'2020-12-30 09:44:47',1,49,1),(48,'2020-12-30 09:45:08',1,50,1),(49,'2020-12-30 09:45:27',1,51,1),(50,'2020-12-30 09:45:49',1,52,1),(51,'2020-12-30 09:46:05',1,53,1),(52,'2020-12-30 09:46:22',1,54,1),(53,'2020-12-30 09:46:39',1,55,1),(54,'2020-12-30 09:47:49',1,32,1),(55,'2020-12-30 09:48:16',1,33,1),(56,'2020-12-30 09:48:31',1,34,1),(57,'2020-12-30 09:48:56',1,35,1),(58,'2020-12-30 09:49:13',1,36,1),(59,'2020-12-30 09:49:29',1,37,1),(60,'2020-12-30 09:49:49',1,38,1),(61,'2020-12-30 09:50:07',1,39,1),(62,'2020-12-30 09:50:18',1,40,1),(63,'2020-12-30 09:50:32',1,41,1),(64,'2020-12-30 09:50:47',1,42,1);

--
-- Table structure for table `review_detail`
--

CREATE TABLE `review_detail` (
  `detail_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review detail ID',
  `review_id` bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT 'Review ID',
  `store_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Store ID',
  `title` varchar(255) NOT NULL COMMENT 'Title',
  `detail` text NOT NULL COMMENT 'Detail description',
  `nickname` varchar(128) NOT NULL COMMENT 'User nickname',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  PRIMARY KEY (`detail_id`),
  KEY `REVIEW_DETAIL_REVIEW_ID` (`review_id`),
  KEY `REVIEW_DETAIL_STORE_ID` (`store_id`),
  KEY `REVIEW_DETAIL_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `REVIEW_DETAIL_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL,
  CONSTRAINT `REVIEW_DETAIL_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE,
  CONSTRAINT `REVIEW_DETAIL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COMMENT='Review detail information';

--
-- Dumping data for table `review_detail`
--

INSERT INTO `review_detail` VALUES (1,1,1,'Works perfectly','Works perfectly Peter Fonda','Peter Fonda',NULL),(2,2,1,'Very good ','i love it  ','Johson',NULL),(3,3,1,'good product','s3ji53','Chevy Chase',NULL),(4,4,1,'Very good ','good i  lov it ','Jonson',NULL),(5,5,1,'i love it ','i love it ','Jonson',NULL),(6,6,1,'good product','good product','David',NULL),(7,7,1,'Very good ','Very good ','Chevy Chase',NULL),(8,8,1,'Very good ','i love it','Peter Fonda',NULL),(9,9,1,'i love it ','good','Johson',NULL),(10,10,1,'good product','good product','Jonson',NULL),(11,11,1,'i love it ','good product','David',NULL),(12,12,1,'Very good ','good product','Jonson',NULL),(13,13,1,'Good ','good product','Kevin Bacon',NULL),(14,14,1,'good product','good product','David',NULL),(15,15,1,'Very good ','good product','Peter Fonda',NULL),(16,16,1,'i love it ','good product','Chevy Chase',NULL),(17,17,1,'Very good ','good product','Kevin Bacon',NULL),(18,18,1,'good product','good product','Johson',NULL),(19,19,1,'Good ','good product','Peter Fonda',NULL),(20,20,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(21,21,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(22,22,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(23,23,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(24,24,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(25,25,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(26,26,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(27,27,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(28,28,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(29,29,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(30,30,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(31,31,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(32,32,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(33,33,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(34,34,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(35,35,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(36,36,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(37,37,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(38,38,1,'Good product','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s','Harry',NULL),(39,39,1,'i love it ','Very good ','David',NULL),(40,40,17,'Very good ','http://blueskytechco.net/koller/en9/shop.html','Jonson',NULL),(41,41,17,'Good ','http://blueskytechco.net/koller/en9/shop.html','Peter Fonda',NULL),(42,42,17,'good product','good product','Chevy Chase',NULL),(43,43,17,'good ','good product','David',NULL),(44,44,17,'Very good ','good product','Chevy Chase',NULL),(45,45,17,'i love it ','good product','Chevy Chase',NULL),(46,46,17,'Very good ','good product','Kevin Bacon',NULL),(47,47,17,'i love it ','good product','Chevy Chase',NULL),(48,48,17,'Very good ','good product','Jonson',NULL),(49,49,17,'Good ','good product','Jonson',NULL),(50,50,17,'Very good ','good product','David',NULL),(51,51,17,'Good ','good product','David',NULL),(52,52,17,'i love it ','good product','Peter Fonda',NULL),(53,53,17,'Very good ','good product','Peter Fonda',NULL),(54,54,15,'good product','http://blueskytechco.net/koller/en9/shop.html','Chevy Chase',NULL),(55,55,15,'Very good ','i love it ','David',NULL),(56,56,15,'Good ','i love it ','Johson',NULL),(57,57,15,'i love it ','i love it ','Kevin Bacon',NULL),(58,58,15,'Very good ','i love it ','Kevin Bacon',NULL),(59,59,15,'Good ','i love it ','Peter Fonda',NULL),(60,60,15,'Good ','Very good ','Chevy Chase',NULL),(61,61,15,'i love it ','Very good ','Kevin Bacon',NULL),(62,62,15,'i love it ','Very good ','Chevy Chase',NULL),(63,63,15,'Very good ','Very good ','Peter Fonda',NULL),(64,64,15,'i love it ','Very good ','Johson',NULL);

--
-- Table structure for table `review_entity`
--

CREATE TABLE `review_entity` (
  `entity_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Review entity ID',
  `entity_code` varchar(32) NOT NULL COMMENT 'Review entity code',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Review entities';

--
-- Dumping data for table `review_entity`
--

INSERT INTO `review_entity` VALUES (1,'product'),(2,'customer'),(3,'category');

--
-- Table structure for table `review_entity_summary`
--

CREATE TABLE `review_entity_summary` (
  `primary_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Summary review entity ID',
  `entity_pk_value` bigint(20) NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `entity_type` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Entity type ID',
  `reviews_count` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Qty of reviews',
  `rating_summary` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Summarized rating',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
  PRIMARY KEY (`primary_id`),
  UNIQUE KEY `REVIEW_ENTITY_SUMMARY_ENTITY_PK_VALUE_STORE_ID_ENTITY_TYPE` (`entity_pk_value`,`store_id`,`entity_type`),
  KEY `REVIEW_ENTITY_SUMMARY_STORE_ID` (`store_id`),
  CONSTRAINT `REVIEW_ENTITY_SUMMARY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=583 DEFAULT CHARSET=utf8 COMMENT='Review aggregates';

--
-- Dumping data for table `review_entity_summary`
--

INSERT INTO `review_entity_summary` VALUES (1,18,1,3,100,1),(2,3,1,3,100,1),(3,3,1,3,100,5),(4,3,1,3,100,6),(5,3,1,3,100,7),(6,4,1,2,100,1),(7,4,1,2,100,5),(8,4,1,2,100,6),(9,4,1,2,100,7),(10,18,1,3,100,5),(11,18,1,3,100,6),(12,18,1,3,100,7),(13,3,1,3,100,0),(14,4,1,2,100,0),(15,19,1,3,100,1),(16,19,1,3,100,5),(17,19,1,3,100,6),(18,19,1,3,100,7),(19,20,1,2,100,1),(20,20,1,2,100,5),(21,20,1,2,100,6),(22,20,1,2,100,7),(23,21,1,2,95,1),(24,21,1,2,95,5),(25,21,1,2,95,6),(26,21,1,2,95,7),(27,22,1,2,95,1),(28,22,1,2,95,5),(29,22,1,2,95,6),(30,22,1,2,95,7),(31,23,1,2,95,1),(32,23,1,2,95,5),(33,23,1,2,95,6),(34,23,1,2,95,7),(35,24,1,2,90,1),(36,24,1,2,90,5),(37,24,1,2,90,6),(38,24,1,2,90,7),(39,25,1,2,100,1),(40,25,1,2,100,5),(41,25,1,2,100,6),(42,25,1,2,100,7),(43,17,1,2,100,1),(44,17,1,2,100,5),(45,17,1,2,100,6),(46,17,1,2,100,7),(47,18,1,3,100,0),(48,19,1,3,98,0),(49,20,1,2,97,0),(50,21,1,2,97,0),(51,22,1,2,93,0),(52,23,1,2,93,0),(53,24,1,2,93,0),(54,25,1,2,100,0),(55,17,1,2,100,0),(56,2,1,3,90,1),(57,2,1,3,90,5),(58,2,1,3,90,6),(59,2,1,3,90,7),(60,16,1,2,95,1),(61,16,1,2,95,5),(62,16,1,2,95,6),(63,16,1,2,95,7),(64,15,1,3,100,1),(65,15,1,3,100,5),(66,15,1,3,100,6),(67,15,1,3,100,7),(68,1,1,2,90,1),(69,1,1,2,90,5),(70,1,1,2,90,6),(71,1,1,2,90,7),(72,2,1,3,89,0),(73,16,1,2,97,0),(74,15,1,3,100,0),(75,1,1,2,93,0),(76,3,1,3,100,8),(77,4,1,2,100,8),(78,16,1,2,95,8),(79,17,1,2,100,8),(80,18,1,3,100,8),(81,19,1,3,100,8),(82,20,1,2,100,8),(83,21,1,2,95,8),(84,22,1,2,95,8),(85,23,1,2,95,8),(86,24,1,2,90,8),(87,25,1,2,100,8),(88,26,1,1,100,1),(89,26,1,1,100,5),(90,26,1,1,100,6),(91,26,1,1,100,7),(92,26,1,1,100,8),(93,27,1,1,70,1),(94,27,1,1,70,5),(95,27,1,1,70,6),(96,27,1,1,70,7),(97,27,1,1,70,8),(98,1,1,2,90,8),(99,2,1,3,90,8),(100,14,1,1,100,1),(101,14,1,1,100,5),(102,14,1,1,100,6),(103,14,1,1,100,7),(104,14,1,1,100,8),(105,15,1,3,100,8),(106,26,1,1,93,0),(107,27,1,1,73,0),(108,14,1,1,100,0),(109,15,1,3,100,9),(110,15,1,3,100,10),(111,15,1,3,100,11),(114,2,1,3,90,9),(115,2,1,3,90,10),(116,2,1,3,90,11),(119,14,1,1,100,9),(120,14,1,1,100,10),(121,14,1,1,100,11),(124,27,1,1,70,9),(125,27,1,1,70,10),(126,27,1,1,70,11),(129,26,1,1,100,9),(130,26,1,1,100,10),(131,26,1,1,100,11),(134,1,1,2,90,9),(135,1,1,2,90,10),(136,1,1,2,90,11),(139,23,1,2,95,9),(140,23,1,2,95,10),(141,23,1,2,95,11),(144,25,1,2,100,9),(145,25,1,2,100,10),(146,25,1,2,100,11),(149,24,1,2,90,9),(150,24,1,2,90,10),(151,24,1,2,90,11),(154,22,1,2,95,9),(155,22,1,2,95,10),(156,22,1,2,95,11),(159,21,1,2,95,9),(160,21,1,2,95,10),(161,21,1,2,95,11),(164,20,1,2,100,9),(165,20,1,2,100,10),(166,20,1,2,100,11),(169,19,1,3,100,9),(170,19,1,3,100,10),(171,19,1,3,100,11),(174,18,1,3,100,9),(175,18,1,3,100,10),(176,18,1,3,100,11),(179,17,1,2,100,9),(180,17,1,2,100,10),(181,17,1,2,100,11),(184,16,1,2,95,9),(185,16,1,2,95,10),(186,16,1,2,95,11),(189,4,1,2,100,9),(190,4,1,2,100,10),(191,4,1,2,100,11),(194,3,1,3,100,9),(195,3,1,3,100,10),(196,3,1,3,100,11),(199,5,1,1,100,1),(200,5,1,1,100,5),(201,5,1,1,100,6),(202,5,1,1,100,7),(203,5,1,1,100,8),(204,5,1,1,100,9),(205,5,1,1,100,10),(206,5,1,1,100,11),(207,5,1,0,0,14),(208,5,1,0,0,15),(209,5,1,0,0,16),(210,5,1,0,0,17),(211,44,1,2,100,17),(212,44,1,0,0,1),(213,44,1,0,0,5),(214,44,1,0,0,6),(215,44,1,0,0,7),(216,44,1,0,0,8),(217,44,1,0,0,9),(218,44,1,0,0,10),(219,44,1,0,0,11),(220,44,1,0,0,14),(221,44,1,0,0,15),(222,44,1,2,100,16),(223,45,1,2,100,17),(224,45,1,0,0,1),(225,45,1,0,0,5),(226,45,1,0,0,6),(227,45,1,0,0,7),(228,45,1,0,0,8),(229,45,1,0,0,9),(230,45,1,0,0,10),(231,45,1,0,0,11),(232,45,1,0,0,14),(233,45,1,0,0,15),(234,45,1,2,100,16),(235,46,1,1,100,17),(236,46,1,0,0,1),(237,46,1,0,0,5),(238,46,1,0,0,6),(239,46,1,0,0,7),(240,46,1,0,0,8),(241,46,1,0,0,9),(242,46,1,0,0,10),(243,46,1,0,0,11),(244,46,1,0,0,14),(245,46,1,0,0,15),(246,46,1,1,100,16),(247,47,1,1,100,17),(248,47,1,0,0,1),(249,47,1,0,0,5),(250,47,1,0,0,6),(251,47,1,0,0,7),(252,47,1,0,0,8),(253,47,1,0,0,9),(254,47,1,0,0,10),(255,47,1,0,0,11),(256,47,1,0,0,14),(257,47,1,0,0,15),(258,47,1,1,100,16),(259,48,1,1,100,17),(260,48,1,0,0,1),(261,48,1,0,0,5),(262,48,1,0,0,6),(263,48,1,0,0,7),(264,48,1,0,0,8),(265,48,1,0,0,9),(266,48,1,0,0,10),(267,48,1,0,0,11),(268,48,1,0,0,14),(269,48,1,0,0,15),(270,48,1,1,100,16),(271,49,1,1,100,17),(272,49,1,0,0,1),(273,49,1,0,0,5),(274,49,1,0,0,6),(275,49,1,0,0,7),(276,49,1,0,0,8),(277,49,1,0,0,9),(278,49,1,0,0,10),(279,49,1,0,0,11),(280,49,1,0,0,14),(281,49,1,0,0,15),(282,49,1,1,100,16),(283,50,1,1,100,17),(284,50,1,0,0,1),(285,50,1,0,0,5),(286,50,1,0,0,6),(287,50,1,0,0,7),(288,50,1,0,0,8),(289,50,1,0,0,9),(290,50,1,0,0,10),(291,50,1,0,0,11),(292,50,1,0,0,14),(293,50,1,0,0,15),(294,50,1,1,100,16),(295,51,1,1,100,17),(296,51,1,0,0,1),(297,51,1,0,0,5),(298,51,1,0,0,6),(299,51,1,0,0,7),(300,51,1,0,0,8),(301,51,1,0,0,9),(302,51,1,0,0,10),(303,51,1,0,0,11),(304,51,1,0,0,14),(305,51,1,0,0,15),(306,51,1,1,100,16),(307,52,1,1,100,17),(308,52,1,0,0,1),(309,52,1,0,0,5),(310,52,1,0,0,6),(311,52,1,0,0,7),(312,52,1,0,0,8),(313,52,1,0,0,9),(314,52,1,0,0,10),(315,52,1,0,0,11),(316,52,1,0,0,14),(317,52,1,0,0,15),(318,52,1,1,100,16),(319,53,1,1,100,17),(320,53,1,0,0,1),(321,53,1,0,0,5),(322,53,1,0,0,6),(323,53,1,0,0,7),(324,53,1,0,0,8),(325,53,1,0,0,9),(326,53,1,0,0,10),(327,53,1,0,0,11),(328,53,1,0,0,14),(329,53,1,0,0,15),(330,53,1,1,100,16),(331,54,1,1,100,17),(332,54,1,0,0,1),(333,54,1,0,0,5),(334,54,1,0,0,6),(335,54,1,0,0,7),(336,54,1,0,0,8),(337,54,1,0,0,9),(338,54,1,0,0,10),(339,54,1,0,0,11),(340,54,1,0,0,14),(341,54,1,0,0,15),(342,54,1,1,100,16),(343,55,1,1,100,17),(344,55,1,0,0,1),(345,55,1,0,0,5),(346,55,1,0,0,6),(347,55,1,0,0,7),(348,55,1,0,0,8),(349,55,1,0,0,9),(350,55,1,0,0,10),(351,55,1,0,0,11),(352,55,1,0,0,14),(353,55,1,0,0,15),(354,55,1,1,100,16),(355,32,1,1,100,15),(356,32,1,0,0,1),(357,32,1,0,0,5),(358,32,1,0,0,6),(359,32,1,0,0,7),(360,32,1,0,0,8),(361,32,1,0,0,9),(362,32,1,0,0,10),(363,32,1,0,0,11),(364,32,1,1,100,14),(365,32,1,0,0,16),(366,32,1,0,0,17),(367,33,1,1,100,15),(368,33,1,0,0,1),(369,33,1,0,0,5),(370,33,1,0,0,6),(371,33,1,0,0,7),(372,33,1,0,0,8),(373,33,1,0,0,9),(374,33,1,0,0,10),(375,33,1,0,0,11),(376,33,1,1,100,14),(377,33,1,0,0,16),(378,33,1,0,0,17),(379,34,1,1,100,15),(380,34,1,0,0,1),(381,34,1,0,0,5),(382,34,1,0,0,6),(383,34,1,0,0,7),(384,34,1,0,0,8),(385,34,1,0,0,9),(386,34,1,0,0,10),(387,34,1,0,0,11),(388,34,1,1,100,14),(389,34,1,0,0,16),(390,34,1,0,0,17),(391,35,1,1,100,15),(392,35,1,0,0,1),(393,35,1,0,0,5),(394,35,1,0,0,6),(395,35,1,0,0,7),(396,35,1,0,0,8),(397,35,1,0,0,9),(398,35,1,0,0,10),(399,35,1,0,0,11),(400,35,1,1,100,14),(401,35,1,0,0,16),(402,35,1,0,0,17),(403,36,1,1,100,15),(404,36,1,0,0,1),(405,36,1,0,0,5),(406,36,1,0,0,6),(407,36,1,0,0,7),(408,36,1,0,0,8),(409,36,1,0,0,9),(410,36,1,0,0,10),(411,36,1,0,0,11),(412,36,1,1,100,14),(413,36,1,0,0,16),(414,36,1,0,0,17),(415,37,1,1,100,15),(416,37,1,0,0,1),(417,37,1,0,0,5),(418,37,1,0,0,6),(419,37,1,0,0,7),(420,37,1,0,0,8),(421,37,1,0,0,9),(422,37,1,0,0,10),(423,37,1,0,0,11),(424,37,1,1,100,14),(425,37,1,0,0,16),(426,37,1,0,0,17),(427,38,1,1,100,15),(428,38,1,0,0,1),(429,38,1,0,0,5),(430,38,1,0,0,6),(431,38,1,0,0,7),(432,38,1,0,0,8),(433,38,1,0,0,9),(434,38,1,0,0,10),(435,38,1,0,0,11),(436,38,1,1,100,14),(437,38,1,0,0,16),(438,38,1,0,0,17),(439,39,1,1,100,15),(440,39,1,0,0,1),(441,39,1,0,0,5),(442,39,1,0,0,6),(443,39,1,0,0,7),(444,39,1,0,0,8),(445,39,1,0,0,9),(446,39,1,0,0,10),(447,39,1,0,0,11),(448,39,1,1,100,14),(449,39,1,0,0,16),(450,39,1,0,0,17),(451,40,1,1,100,15),(452,40,1,0,0,1),(453,40,1,0,0,5),(454,40,1,0,0,6),(455,40,1,0,0,7),(456,40,1,0,0,8),(457,40,1,0,0,9),(458,40,1,0,0,10),(459,40,1,0,0,11),(460,40,1,1,100,14),(461,40,1,0,0,16),(462,40,1,0,0,17),(463,41,1,1,100,15),(464,41,1,0,0,1),(465,41,1,0,0,5),(466,41,1,0,0,6),(467,41,1,0,0,7),(468,41,1,0,0,8),(469,41,1,0,0,9),(470,41,1,0,0,10),(471,41,1,0,0,11),(472,41,1,1,100,14),(473,41,1,0,0,16),(474,41,1,0,0,17),(475,42,1,1,100,15),(476,42,1,0,0,1),(477,42,1,0,0,5),(478,42,1,0,0,6),(479,42,1,0,0,7),(480,42,1,0,0,8),(481,42,1,0,0,9),(482,42,1,0,0,10),(483,42,1,0,0,11),(484,42,1,1,100,14),(485,42,1,0,0,16),(486,42,1,0,0,17),(487,18,1,0,0,14),(488,18,1,0,0,15),(489,18,1,0,0,16),(490,18,1,0,0,17),(491,3,1,0,0,14),(492,3,1,0,0,15),(493,3,1,0,0,16),(494,3,1,0,0,17),(495,4,1,0,0,14),(496,4,1,0,0,15),(497,4,1,0,0,16),(498,4,1,0,0,17),(499,19,1,0,0,14),(500,19,1,0,0,15),(501,19,1,0,0,16),(502,19,1,0,0,17),(503,20,1,0,0,14),(504,20,1,0,0,15),(505,20,1,0,0,16),(506,20,1,0,0,17),(507,21,1,0,0,14),(508,21,1,0,0,15),(509,21,1,0,0,16),(510,21,1,0,0,17),(511,22,1,0,0,14),(512,22,1,0,0,15),(513,22,1,0,0,16),(514,22,1,0,0,17),(515,23,1,0,0,14),(516,23,1,0,0,15),(517,23,1,0,0,16),(518,23,1,0,0,17),(519,24,1,0,0,14),(520,24,1,0,0,15),(521,24,1,0,0,16),(522,24,1,0,0,17),(523,25,1,0,0,14),(524,25,1,0,0,15),(525,25,1,0,0,16),(526,25,1,0,0,17),(527,17,1,0,0,14),(528,17,1,0,0,15),(529,17,1,0,0,16),(530,17,1,0,0,17),(531,2,1,0,0,14),(532,2,1,0,0,15),(533,2,1,0,0,16),(534,2,1,0,0,17),(535,16,1,0,0,14),(536,16,1,0,0,15),(537,16,1,0,0,16),(538,16,1,0,0,17),(539,15,1,0,0,14),(540,15,1,0,0,15),(541,15,1,0,0,16),(542,15,1,0,0,17),(543,1,1,0,0,14),(544,1,1,0,0,15),(545,1,1,0,0,16),(546,1,1,0,0,17),(547,26,1,0,0,14),(548,26,1,0,0,15),(549,26,1,0,0,16),(550,26,1,0,0,17),(551,27,1,0,0,14),(552,27,1,0,0,15),(553,27,1,0,0,16),(554,27,1,0,0,17),(555,14,1,0,0,14),(556,14,1,0,0,15),(557,14,1,0,0,16),(558,14,1,0,0,17),(559,5,1,1,100,0),(560,44,1,2,100,0),(561,45,1,2,100,0),(562,46,1,1,100,0),(563,47,1,1,100,0),(564,48,1,1,100,0),(565,49,1,1,100,0),(566,50,1,1,100,0),(567,51,1,1,100,0),(568,52,1,1,100,0),(569,53,1,1,100,0),(570,54,1,1,100,0),(571,55,1,1,100,0),(572,32,1,1,100,0),(573,33,1,1,100,0),(574,34,1,1,100,0),(575,35,1,1,100,0),(576,36,1,1,100,0),(577,37,1,1,100,0),(578,38,1,1,100,0),(579,39,1,1,100,0),(580,40,1,1,100,0),(581,41,1,1,100,0),(582,42,1,1,100,0);

--
-- Table structure for table `review_status`
--

CREATE TABLE `review_status` (
  `status_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Status ID',
  `status_code` varchar(32) NOT NULL COMMENT 'Status code',
  PRIMARY KEY (`status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Review statuses';

--
-- Dumping data for table `review_status`
--

INSERT INTO `review_status` VALUES (1,'Approved'),(2,'Pending'),(3,'Not Approved');

--
-- Table structure for table `review_store`
--

CREATE TABLE `review_store` (
  `review_id` bigint(20) unsigned NOT NULL COMMENT 'Review ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`review_id`,`store_id`),
  KEY `REVIEW_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `REVIEW_STORE_REVIEW_ID_REVIEW_REVIEW_ID` FOREIGN KEY (`review_id`) REFERENCES `review` (`review_id`) ON DELETE CASCADE,
  CONSTRAINT `REVIEW_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Review Store';

--
-- Dumping data for table `review_store`
--

INSERT INTO `review_store` VALUES (1,0),(1,1),(1,5),(1,6),(1,7),(1,8),(1,9),(1,10),(1,11),(2,0),(2,1),(2,5),(2,6),(2,7),(2,8),(2,9),(2,10),(2,11),(3,0),(3,1),(3,5),(3,6),(3,7),(3,8),(3,9),(3,10),(3,11),(4,0),(4,1),(4,5),(4,6),(4,7),(4,8),(4,9),(4,10),(4,11),(5,0),(5,1),(5,5),(5,6),(5,7),(5,8),(5,9),(5,10),(5,11),(6,0),(6,1),(6,5),(6,6),(6,7),(6,8),(6,9),(6,10),(6,11),(7,0),(7,1),(7,5),(7,6),(7,7),(7,8),(7,9),(7,10),(7,11),(8,0),(8,1),(8,5),(8,6),(8,7),(8,8),(8,9),(8,10),(8,11),(9,0),(9,1),(9,5),(9,6),(9,7),(9,8),(9,9),(9,10),(9,11),(10,0),(10,1),(10,5),(10,6),(10,7),(10,8),(10,9),(10,10),(10,11),(11,0),(11,1),(11,5),(11,6),(11,7),(11,8),(11,9),(11,10),(11,11),(12,0),(12,1),(12,5),(12,6),(12,7),(12,8),(12,9),(12,10),(12,11),(13,0),(13,1),(13,5),(13,6),(13,7),(13,8),(13,9),(13,10),(13,11),(14,0),(14,1),(14,5),(14,6),(14,7),(14,8),(14,9),(14,10),(14,11),(15,0),(15,1),(15,5),(15,6),(15,7),(15,8),(15,9),(15,10),(15,11),(16,0),(16,1),(16,5),(16,6),(16,7),(16,8),(16,9),(16,10),(16,11),(17,0),(17,1),(17,5),(17,6),(17,7),(17,8),(17,9),(17,10),(17,11),(18,0),(18,1),(18,5),(18,6),(18,7),(18,8),(18,9),(18,10),(18,11),(19,0),(19,1),(19,5),(19,6),(19,7),(19,8),(19,9),(19,10),(19,11),(20,0),(20,1),(20,5),(20,6),(20,7),(20,8),(20,9),(20,10),(20,11),(21,0),(21,1),(21,5),(21,6),(21,7),(21,8),(21,9),(21,10),(21,11),(22,0),(22,1),(22,5),(22,6),(22,7),(22,8),(22,9),(22,10),(22,11),(23,0),(23,1),(23,5),(23,6),(23,7),(23,8),(23,9),(23,10),(23,11),(24,0),(24,1),(24,5),(24,6),(24,7),(24,8),(24,9),(24,10),(24,11),(25,0),(25,1),(25,5),(25,6),(25,7),(25,8),(25,9),(25,10),(25,11),(26,0),(26,1),(26,5),(26,6),(26,7),(26,8),(26,9),(26,10),(26,11),(27,0),(27,1),(27,5),(27,6),(27,7),(27,8),(27,9),(27,10),(27,11),(28,0),(28,1),(28,5),(28,6),(28,7),(28,8),(28,9),(28,10),(28,11),(29,0),(29,1),(29,5),(29,6),(29,7),(29,8),(29,9),(29,10),(29,11),(30,0),(30,1),(30,5),(30,6),(30,7),(30,8),(30,9),(30,10),(30,11),(31,0),(31,1),(31,5),(31,6),(31,7),(31,8),(31,9),(31,10),(31,11),(32,0),(32,1),(32,5),(32,6),(32,7),(32,8),(32,9),(32,10),(32,11),(33,0),(33,1),(33,5),(33,6),(33,7),(33,8),(33,9),(33,10),(33,11),(34,0),(34,1),(34,5),(34,6),(34,7),(34,8),(34,9),(34,10),(34,11),(35,0),(35,1),(35,5),(35,6),(35,7),(35,8),(35,9),(35,10),(35,11),(36,0),(36,1),(36,5),(36,6),(36,7),(36,8),(36,9),(36,10),(36,11),(37,0),(37,1),(37,5),(37,6),(37,7),(37,8),(37,9),(37,10),(37,11),(38,0),(38,1),(38,5),(38,6),(38,7),(38,8),(38,9),(38,10),(38,11),(39,0),(39,1),(39,5),(39,6),(39,7),(39,8),(39,9),(39,10),(39,11),(40,0),(40,16),(40,17),(41,0),(41,16),(41,17),(42,0),(42,16),(42,17),(43,0),(43,16),(43,17),(44,0),(44,16),(44,17),(45,0),(45,16),(45,17),(46,0),(46,16),(46,17),(47,0),(47,16),(47,17),(48,0),(48,16),(48,17),(49,0),(49,16),(49,17),(50,0),(50,16),(50,17),(51,0),(51,16),(51,17),(52,0),(52,16),(52,17),(53,0),(53,16),(53,17),(54,0),(54,14),(54,15),(55,0),(55,14),(55,15),(56,0),(56,14),(56,15),(57,0),(57,14),(57,15),(58,0),(58,14),(58,15),(59,0),(59,14),(59,15),(60,0),(60,14),(60,15),(61,0),(61,14),(61,15),(62,0),(62,14),(62,15),(63,0),(63,14),(63,15),(64,0),(64,14),(64,15);

--
-- Table structure for table `rokan_faq`
--

CREATE TABLE `rokan_faq` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `status` varchar(255) DEFAULT NULL COMMENT 'Status',
  `parent_id` int(11) NOT NULL COMMENT 'Parent_id',
  `question` text NOT NULL COMMENT 'Question',
  `answer` text DEFAULT NULL COMMENT 'Answer',
  `created_time` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Creation Time',
  `updated_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated Time',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='rokan_faq';

--
-- Dumping data for table `rokan_faq`
--

INSERT INTO `rokan_faq` VALUES (1,'1',0,'Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt \r\nmollit anim id est laborum excepteur sint occaecat cupidatat non proident','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.</p>','2020-12-16 04:09:17','2021-01-19 06:44:36'),(2,'1',0,'Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt \r\nmollit anim id est laborum excepteur sint occaecat cupidatat non proident','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.</p>','2020-12-16 04:09:32','2021-01-19 06:44:26'),(3,'1',0,'Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt \r\nmollit anim id est laborum excepteur sint occaecat cupidatat non proident','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.</p>','2020-12-16 04:09:44','2021-01-19 06:44:17'),(4,'1',0,'Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt \r\nmollit anim id est laborum excepteur sint occaecat cupidatat non proident','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.</p>','2020-12-16 04:09:57','2021-01-19 06:44:06');

--
-- Table structure for table `rokanthemes_blog_category`
--

CREATE TABLE `rokanthemes_blog_category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Category ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Category Title',
  `meta_keywords` text DEFAULT NULL COMMENT 'Category Meta Keywords',
  `meta_description` text DEFAULT NULL 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 DEFAULT NULL COMMENT 'Category Content',
  `path` varchar(255) DEFAULT NULL COMMENT 'Category Path',
  `position` smallint(6) NOT NULL COMMENT 'Category Position',
  `is_active` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Is Category Active',
  PRIMARY KEY (`category_id`),
  KEY `ROKANTHEMES_BLOG_CATEGORY_IDENTIFIER` (`identifier`),
  FULLTEXT KEY `FTI_6A0F670BEBE7070477E431D11DAE7DD2` (`title`,`meta_keywords`,`meta_description`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='Rokanthemes Blog Category Table';

--
-- Dumping data for table `rokanthemes_blog_category`
--

INSERT INTO `rokanthemes_blog_category` VALUES (1,'Funiture',NULL,NULL,'funiture',NULL,NULL,'0',0,1),(2,'Inspiration',NULL,NULL,'inspiration',NULL,NULL,'0',0,1),(3,'Fashion',NULL,NULL,'fashion',NULL,NULL,'0',0,1),(4,'Lifestyle',NULL,NULL,'lifestyle',NULL,NULL,'0',0,1),(5,'Photography',NULL,NULL,'photography',NULL,NULL,'0',0,1);

--
-- Table structure for table `rokanthemes_blog_category_store`
--

CREATE TABLE `rokanthemes_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 `ROKANTHEMES_BLOG_CATEGORY_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_B2E5A21E93DC38155A194FCC30551BFB` FOREIGN KEY (`category_id`) REFERENCES `rokanthemes_blog_category` (`category_id`) ON DELETE CASCADE,
  CONSTRAINT `ROKANTHEMES_BLOG_CATEGORY_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rokanthemes Blog Category To Store Linkage Table';

--
-- Dumping data for table `rokanthemes_blog_category_store`
--

INSERT INTO `rokanthemes_blog_category_store` VALUES (1,0),(2,0),(3,0),(4,0),(5,0);

--
-- Table structure for table `rokanthemes_blog_post`
--

CREATE TABLE `rokanthemes_blog_post` (
  `post_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Post ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Post Title',
  `thumbnailimage` varchar(255) DEFAULT NULL COMMENT 'Thumbnail Image',
  `meta_keywords` text DEFAULT NULL COMMENT 'Post Meta Keywords',
  `meta_description` text DEFAULT NULL COMMENT 'Post Meta Description',
  `identifier` varchar(100) DEFAULT NULL COMMENT 'Post String Identifier',
  `content_heading` varchar(255) DEFAULT NULL COMMENT 'Post Content Heading',
  `short_content` text DEFAULT NULL COMMENT 'Short Content',
  `content` mediumtext DEFAULT NULL 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',
  `detailimage` text NOT NULL COMMENT 'Detail Image',
  PRIMARY KEY (`post_id`),
  KEY `ROKANTHEMES_BLOG_POST_IDENTIFIER` (`identifier`),
  FULLTEXT KEY `FTI_06831C0BC8889A99722C611BB316CDA2` (`title`,`meta_keywords`,`meta_description`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='Rokanthemes Blog Post Table';

--
-- Dumping data for table `rokanthemes_blog_post`
--

INSERT INTO `rokanthemes_blog_post` VALUES (1,'Congue eget dapibus congue','rokanthemes/blog/images/1/_/1.jpg',NULL,NULL,'congue-eget-dapibus-congue','Congue eget dapibus congue','Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed luctus, dui eu sagittis sodales, nulla nibh sagittis augue...','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>\r\n<div class=\"row\">\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl1.jpg&quot;}}\" alt=\"\"></div>\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl2.jpg&quot;}}\" alt=\"\"></div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>','2020-11-09 05:00:59','2020-12-31 10:02:36','2020-06-11 00:00:00',1,'rokanthemes/blog/images/1/_/1_1.jpg'),(2,' Fusce laoreet nibh felis porttitor laoreet','rokanthemes/blog/images/2/_/2.jpg',NULL,NULL,'fusce-laoreet-nibh-felis-porttitor-laoreet',' Fusce laoreet nibh felis porttitor laoreet','\r\nClass aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed luctus, dui eu sagittis sodales, nulla nibh sagittis augue..','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>\r\n<div class=\"row\">\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl1.jpg&quot;}}\" alt=\"\"></div>\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl2.jpg&quot;}}\" alt=\"\"></div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>','2020-11-10 07:19:50','2020-11-19 01:34:43','2020-11-10 00:00:00',1,'rokanthemes/blog/images/2/_/2_1.jpg'),(3,'Suspendisse tortor ante adipiscing','rokanthemes/blog/images/3/_/3.jpg',NULL,NULL,'suspendisse-tortor-ante-adipiscing','Suspendisse tortor ante adipiscing','Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed luctus, dui eu sagittis sodales, nulla nibh sagittis augue..','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>\r\n<div class=\"row\">\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl1.jpg&quot;}}\" alt=\"\"></div>\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl2.jpg&quot;}}\" alt=\"\"></div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>','2020-11-10 07:19:52','2020-12-31 10:02:44','2020-11-09 00:00:00',1,'rokanthemes/blog/images/3/_/3_1.jpg'),(4,' Celebrating Female Leader','rokanthemes/blog/images/4/_/4.jpg',NULL,NULL,'celebrating-female-leader',' Celebrating Female Leader','\r\nClass aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed luctus, dui eu sagittis sodales, nulla nibh sagittis augue...','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>\r\n<div class=\"row\">\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl1.jpg&quot;}}\" alt=\"\"></div>\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl2.jpg&quot;}}\" alt=\"\"></div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>','2020-11-10 07:30:13','2020-11-19 01:37:12','2020-11-09 00:00:00',1,'rokanthemes/blog/images/4/_/4_1.jpg'),(5,'Create Good Feng Shui in Your ','rokanthemes/blog/images/5/_/5.jpg',NULL,NULL,'create-good-feng-shui-in-your','Create Good Feng Shui in Your ','Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed luctus, dui eu sagittis sodales, nulla nibh sagittis augue...','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>\r\n<div class=\"row\">\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl1.jpg&quot;}}\" alt=\"\"></div>\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl2.jpg&quot;}}\" alt=\"\"></div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>','2020-11-10 07:30:14','2020-12-31 10:06:54','2018-11-02 00:00:00',1,'rokanthemes/blog/images/5/_/5_1.jpg'),(6,'Stylish color scheme in interior ','rokanthemes/blog/images/6/_/6.jpg',NULL,NULL,'stylish-color-scheme-in-interior','Stylish color scheme in interior ','Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed luctus, dui eu sagittis sodales, nulla nibh sagittis augue...','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>\r\n<div class=\"row\">\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl1.jpg&quot;}}\" alt=\"\"></div>\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl2.jpg&quot;}}\" alt=\"\"></div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>','2020-11-10 07:43:12','2020-12-31 10:02:51','2020-11-07 00:00:00',1,'rokanthemes/blog/images/6/_/6_1.jpg'),(7,'The color scheme for bedrooms','rokanthemes/blog/images/7/_/7.jpg',NULL,NULL,'the-color-scheme-for-bedrooms','The color scheme for bedrooms','Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed luctus, dui eu sagittis sodales, nulla nibh sagittis augue...','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>\r\n<div class=\"row\">\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl1.jpg&quot;}}\" alt=\"\"></div>\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl2.jpg&quot;}}\" alt=\"\"></div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>','2020-11-10 07:47:22','2020-12-31 10:06:33','2019-11-06 00:00:00',1,'rokanthemes/blog/images/7/_/7_1.jpg'),(8,'The sofa in the living room','rokanthemes/blog/images/8/_/8.jpg',NULL,NULL,'the-sofa-in-the-living-room','The sofa in the living room','Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed luctus, dui eu sagittis sodales, nulla nibh sagittis augue...','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>\r\n<div class=\"row\">\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl1.jpg&quot;}}\" alt=\"\"></div>\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl2.jpg&quot;}}\" alt=\"\"></div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>','2020-11-10 07:52:53','2020-12-31 10:06:05','2019-11-05 00:00:00',1,'rokanthemes/blog/images/8/_/8_1.jpg'),(9,'Feng shui the indoor plants','rokanthemes/blog/images/9/_/9.jpg',NULL,NULL,'feng-shui-the-indoor-plants','Feng shui the indoor plants','Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed luctus, dui eu sagittis sodales, nulla nibh sagittis augue...','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>\r\n<div class=\"row\">\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl1.jpg&quot;}}\" alt=\"\"></div>\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl2.jpg&quot;}}\" alt=\"\"></div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>','2020-11-10 07:55:40','2020-12-31 10:02:08','2020-11-04 00:00:00',1,'rokanthemes/blog/images/9/_/9_1.jpg'),(10,' Good Feng Shui in Your Kitchen','rokanthemes/blog/images/1/0/10.jpg',NULL,NULL,'good-feng-shui-in-your-kitchen',' Good Feng Shui in Your Kitchen','Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed luctus, dui eu sagittis sodales, nulla nibh sagittis augue...','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>\r\n<div class=\"row\">\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl1.jpg&quot;}}\" alt=\"\"></div>\r\n<div class=\"col-sm-6\"><img src=\"{{media url=&quot;wysiwyg/bl2.jpg&quot;}}\" alt=\"\"></div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p>','2020-11-10 07:57:47','2020-12-31 10:06:22','2020-11-01 00:00:00',1,'rokanthemes/blog/images/1/0/10_1.jpg');

--
-- Table structure for table `rokanthemes_blog_post_category`
--

CREATE TABLE `rokanthemes_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 `ROKANTHEMES_BLOG_POST_CATEGORY_CATEGORY_ID` (`category_id`),
  CONSTRAINT `ROKANTHEMES_BLOG_POST_CTGR_CTGR_ID_ROKANTHEMES_BLOG_CTGR_CTGR_ID` FOREIGN KEY (`category_id`) REFERENCES `rokanthemes_blog_category` (`category_id`) ON DELETE CASCADE,
  CONSTRAINT `ROKANTHEMES_BLOG_POST_CTGR_POST_ID_ROKANTHEMES_BLOG_POST_POST_ID` FOREIGN KEY (`post_id`) REFERENCES `rokanthemes_blog_post` (`post_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rokanthemes Blog Post To Category Linkage Table';

--
-- Dumping data for table `rokanthemes_blog_post_category`
--

INSERT INTO `rokanthemes_blog_post_category` VALUES (1,1),(1,5),(2,1),(3,1),(3,4),(4,1),(5,1),(5,5),(6,1),(6,3),(7,1),(8,1),(8,3),(9,1),(9,3),(10,1),(10,2);

--
-- Table structure for table `rokanthemes_blog_post_relatedpost`
--

CREATE TABLE `rokanthemes_blog_post_relatedpost` (
  `post_id` int(11) NOT NULL COMMENT 'Post ID',
  `related_id` int(11) NOT NULL COMMENT 'Related Post ID',
  PRIMARY KEY (`post_id`,`related_id`),
  KEY `ROKANTHEMES_BLOG_POST_RELATEDPRODUCT_RELATED_ID` (`related_id`),
  CONSTRAINT `FK_2C6615E88C0955F9C321C9DBDFFA7912` FOREIGN KEY (`post_id`) REFERENCES `rokanthemes_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_611071D67D630FB9854BFE889C8B3EC6` FOREIGN KEY (`post_id`) REFERENCES `rokanthemes_blog_post` (`post_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rokanthemes Blog Post To Post Linkage Table';

--
-- Dumping data for table `rokanthemes_blog_post_relatedpost`
--

INSERT INTO `rokanthemes_blog_post_relatedpost` VALUES (1,4),(1,5),(1,6),(1,7),(1,8),(1,9),(2,4),(2,5),(2,6),(2,8),(2,9),(2,10),(3,1),(3,2),(3,4),(3,5),(3,6),(3,7),(4,5),(4,6),(4,7),(4,8),(4,9),(4,10),(5,4),(5,6),(5,7),(5,8),(5,9),(5,10),(6,2),(6,3),(6,4),(6,5),(6,7),(7,1),(7,4),(7,5),(7,6),(7,8),(7,9),(8,2),(8,5),(8,6),(8,7),(8,9),(8,10),(9,1),(9,2),(9,4),(9,5),(9,7),(9,8),(10,4),(10,5),(10,6),(10,7),(10,8),(10,9);

--
-- Table structure for table `rokanthemes_blog_post_relatedproduct`
--

CREATE TABLE `rokanthemes_blog_post_relatedproduct` (
  `post_id` int(11) NOT NULL COMMENT 'Post ID',
  `related_id` int(10) unsigned NOT NULL COMMENT 'Related Product ID',
  PRIMARY KEY (`post_id`,`related_id`),
  KEY `ROKANTHEMES_BLOG_POST_RELATEDPRODUCT_RELATED_ID` (`related_id`),
  CONSTRAINT `FK_76FB9A5C6ED2E2F36D954A0950982927` FOREIGN KEY (`post_id`) REFERENCES `rokanthemes_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `ROKANTHEMES_BLOG_POST_RELATEDPRD_RELATED_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`related_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rokanthemes Blog Post To Product Linkage Table';

--
-- Dumping data for table `rokanthemes_blog_post_relatedproduct`
--


--
-- Table structure for table `rokanthemes_blog_post_store`
--

CREATE TABLE `rokanthemes_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 `ROKANTHEMES_BLOG_POST_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CE578BDC8F57A050007913DB7FDB5E61` FOREIGN KEY (`post_id`) REFERENCES `rokanthemes_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `ROKANTHEMES_BLOG_POST_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rokanthemes Blog Post To Store Linkage Table';

--
-- Dumping data for table `rokanthemes_blog_post_store`
--

INSERT INTO `rokanthemes_blog_post_store` VALUES (1,0),(2,0),(3,0),(4,0),(5,0),(6,0),(7,0),(8,0),(9,0),(10,0);

--
-- Table structure for table `rokanthemes_brand`
--

CREATE TABLE `rokanthemes_brand` (
  `brand_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Brand ID',
  `name` varchar(255) NOT NULL COMMENT 'Brand Name',
  `url_key` varchar(255) NOT NULL COMMENT 'Brand Url Key',
  `description` text NOT NULL COMMENT 'Brand Description',
  `group_id` int(10) unsigned NOT NULL COMMENT 'Group ID',
  `image` varchar(255) NOT NULL COMMENT 'Brand Image',
  `thumbnail` varchar(255) NOT NULL COMMENT 'Brand Thumbnail',
  `page_title` varchar(255) NOT NULL COMMENT 'Brand Page Title',
  `meta_keywords` text NOT NULL COMMENT 'Meta Keywords',
  `meta_description` text NOT NULL COMMENT 'Meta Description',
  `creation_time` timestamp NULL DEFAULT NULL COMMENT 'Brand Creation Time',
  `update_time` timestamp NULL DEFAULT NULL COMMENT 'Brand Modification Time',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `layout_update_xml` text DEFAULT NULL COMMENT 'Page Layout Update Content',
  `status` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Status',
  `position` int(11) NOT NULL DEFAULT 0 COMMENT 'Position',
  PRIMARY KEY (`brand_id`),
  KEY `ROKANTHEMES_BRAND_GROUP_ID` (`group_id`),
  CONSTRAINT `ROKANTHEMES_BRAND_GROUP_ID_ROKANTHEMES_BRAND_GROUP_ID` FOREIGN KEY (`group_id`) REFERENCES `rokanthemes_brand_group` (`group_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Brand Information';

--
-- Dumping data for table `rokanthemes_brand`
--

INSERT INTO `rokanthemes_brand` VALUES (1,'Brand 1','brand-1','',1,'rokanthemes/brand/brand-2.png','rokanthemes/brand/brand-2.png','','','','2020-11-08 09:01:57','2020-12-31 02:48:46',NULL,NULL,1,0),(2,'Brand 2','brand-2','',1,'rokanthemes/brand/brand-3.png','rokanthemes/brand/brand-3.png','','','','2020-11-08 09:09:44','2020-12-31 02:49:02',NULL,NULL,1,0),(3,'Brand 3','brand-3','',1,'rokanthemes/brand/brand-4.png','rokanthemes/brand/brand-4.png','','','','2020-11-08 09:24:20','2020-12-31 02:49:19',NULL,NULL,1,0),(4,'Brand 4','brand-4','',1,'rokanthemes/brand/brand-1.png','rokanthemes/brand/brand-1.png','','','','2020-11-08 09:25:03','2020-12-31 02:48:27',NULL,NULL,1,0),(5,'Brand 5','brand-5','',1,'rokanthemes/brand/brand-5.png','rokanthemes/brand/brand-5.png','','','','2020-11-08 09:25:43','2020-12-31 02:49:37',NULL,NULL,1,0),(6,'Brand 6','brand-6','',1,'rokanthemes/brand/band-6.png','rokanthemes/brand/band-6.png','','','','2020-11-08 09:26:31','2020-12-31 02:49:56',NULL,NULL,1,0);

--
-- Table structure for table `rokanthemes_brand_group`
--

CREATE TABLE `rokanthemes_brand_group` (
  `group_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Group ID',
  `name` varchar(255) NOT NULL COMMENT 'Group Name',
  `url_key` varchar(255) NOT NULL COMMENT 'Group Url Key',
  `position` int(11) NOT NULL DEFAULT 0 COMMENT 'Position',
  `status` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Status',
  `shown_in_sidebar` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Show In Sidebar',
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Brand Group';

--
-- Dumping data for table `rokanthemes_brand_group`
--

INSERT INTO `rokanthemes_brand_group` VALUES (1,'Funiture','funiture',0,1,1);

--
-- Table structure for table `rokanthemes_brand_product`
--

CREATE TABLE `rokanthemes_brand_product` (
  `brand_id` int(11) NOT NULL COMMENT 'Brand ID',
  `product_id` smallint(5) unsigned NOT NULL COMMENT 'Product ID',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  PRIMARY KEY (`brand_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rokanthemes Brand To Product Linkage Table';

--
-- Dumping data for table `rokanthemes_brand_product`
--

INSERT INTO `rokanthemes_brand_product` VALUES (1,14,0),(1,24,0),(1,44,0),(1,83,0),(1,89,0),(2,3,0),(2,4,0),(2,23,0),(2,25,0),(2,42,0),(2,45,0),(2,55,0),(2,57,0),(2,69,0),(3,5,0),(3,17,0),(3,19,0),(3,46,0),(3,51,0),(4,1,0),(4,15,0),(4,18,0),(4,27,0),(4,32,0),(4,33,0),(4,34,0),(4,35,0),(4,36,0),(4,37,0),(4,38,0),(4,39,0),(4,40,0),(4,41,0),(4,61,0),(5,2,0),(5,6,0),(5,16,0),(5,20,0),(5,26,0),(5,28,0),(5,29,0),(5,30,0),(5,31,0),(5,47,0),(5,49,0),(5,50,0),(5,52,0),(5,53,0),(5,54,0),(5,60,0),(5,70,0),(5,71,0),(6,21,0),(6,22,0),(6,48,0),(6,56,0);

--
-- Table structure for table `rokanthemes_brand_store`
--

CREATE TABLE `rokanthemes_brand_store` (
  `brand_id` int(10) unsigned NOT NULL COMMENT 'Brand Id',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  PRIMARY KEY (`brand_id`,`store_id`),
  KEY `ROKANTHEMES_BRAND_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `ROKANTHEMES_BRAND_STORE_BRAND_ID_ROKANTHEMES_BRAND_BRAND_ID` FOREIGN KEY (`brand_id`) REFERENCES `rokanthemes_brand` (`brand_id`) ON DELETE CASCADE,
  CONSTRAINT `ROKANTHEMES_BRAND_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Brand Store';

--
-- Dumping data for table `rokanthemes_brand_store`
--

INSERT INTO `rokanthemes_brand_store` VALUES (1,0),(2,0),(3,0),(4,0),(5,0),(6,0);

--
-- Table structure for table `rokanthemes_instagram`
--

CREATE TABLE `rokanthemes_instagram` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `media_url` text NOT NULL COMMENT 'media_url',
  `local_media_url` text NOT NULL COMMENT 'local_media_url',
  `id_instagram` varchar(255) NOT NULL DEFAULT '' COMMENT 'id_instagram',
  `username` varchar(255) NOT NULL DEFAULT '' COMMENT 'username',
  `permalink` varchar(255) NOT NULL DEFAULT '' COMMENT 'permalink',
  `caption` text DEFAULT NULL COMMENT 'Caption',
  `store` int(11) DEFAULT NULL COMMENT 'Store',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8 COMMENT='Instagram';

--
-- Dumping data for table `rokanthemes_instagram`
--

INSERT INTO `rokanthemes_instagram` VALUES (96,'https://scontent.cdninstagram.com/v/t51.29350-15/133728040_147006430516175_3415465909804434535_n.jpg?_nc_cat=110&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=FP3bq7INYsMAX9XCg3K&_nc_ht=scontent.cdninstagram.com&oh=a00873bb8e69e40fd26587688cc4b974&oe=60E38802','instagram/17935041664443003_1379082622.jpg','17935041664443003','koller_sneakes','https://www.instagram.com/p/CJagg8knaZ8/',NULL,16),(97,'https://scontent.cdninstagram.com/v/t51.29350-15/134482765_762362844670018_6956789973872920218_n.jpg?_nc_cat=103&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=E66okjFHAhQAX_6CQaw&_nc_ht=scontent.cdninstagram.com&oh=5e4fa19cdc5157bb6f7e0ca0f5744312&oe=60E2B2FE','instagram/17866294919199752_938478892.jpg','17866294919199752','koller_sneakes','https://www.instagram.com/p/CJage_4n6px/',NULL,16),(98,'https://scontent.cdninstagram.com/v/t51.29350-15/134250839_2839234593029097_69412112905002999_n.jpg?_nc_cat=110&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=UUT6c_TK-wgAX-lxcSk&_nc_ht=scontent.cdninstagram.com&oh=608c6cfc2deeb57f51bf1013bee9b655&oe=60E37D6A','instagram/17846317205495654_506439603.jpg','17846317205495654','koller_sneakes','https://www.instagram.com/p/CJagdJRHkOM/',NULL,16),(99,'https://scontent.cdninstagram.com/v/t51.29350-15/133679856_2814095255544782_1253021378055714230_n.jpg?_nc_cat=108&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=j7rWTE7xQDsAX8QNpVs&_nc_ht=scontent.cdninstagram.com&oh=3c0a76755d6f40f109e57452aeb923d6&oe=60E1F9D5','instagram/17887488415864964_1296100827.jpg','17887488415864964','koller_sneakes','https://www.instagram.com/p/CJagbPFHphi/',NULL,16),(100,'https://scontent.cdninstagram.com/v/t51.29350-15/133073748_5167350276638374_2916202019455321022_n.jpg?_nc_cat=103&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=kI5htTjIf6EAX8eiOwi&_nc_ht=scontent.cdninstagram.com&oh=053b207227ceeaca8c5b1e8f51d83c22&oe=60E33FE3','instagram/17904945121627111_755389045.jpg','17904945121627111','koller_sneakes','https://www.instagram.com/p/CJagZQmnx5J/',NULL,16),(101,'https://scontent.cdninstagram.com/v/t51.29350-15/125997579_418365815860108_7321426240436070145_n.jpg?_nc_cat=106&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=-fC9qxvgoH4AX_Smnzr&_nc_ht=scontent.cdninstagram.com&oh=39ffb73822899087c92024c45df6fb07&oe=60E2913F','instagram/18175773982014058_350328964.jpg','18175773982014058','koller_magento','https://www.instagram.com/p/CHwn0MrhMzI/',NULL,0),(102,'https://scontent.cdninstagram.com/v/t51.29350-15/126161301_3515243398561075_1240487264339510569_n.jpg?_nc_cat=105&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=N3zK6JqW8wUAX8mV5ao&_nc_ht=scontent.cdninstagram.com&oh=c315173bcede0b746a1ad4e48dc44e52&oe=60E30BC4','instagram/17864918156183295_713051193.jpg','17864918156183295','koller_magento','https://www.instagram.com/p/CHwnyXhhIFf/',NULL,0),(103,'https://scontent.cdninstagram.com/v/t51.29350-15/125777817_744809686115928_4905657057416855348_n.jpg?_nc_cat=109&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=okJqakyESEIAX9tcAM_&_nc_ht=scontent.cdninstagram.com&oh=adde4f939fe516a0cb941d05f12446ff&oe=60E386F0','instagram/17885383909812832_1256193539.jpg','17885383909812832','koller_magento','https://www.instagram.com/p/CHwnwUoBgis/',NULL,0),(104,'https://scontent.cdninstagram.com/v/t51.29350-15/126112721_2802954353314891_4439246137561083447_n.jpg?_nc_cat=110&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=BjsqDhqYeS0AX_TSfkh&_nc_ht=scontent.cdninstagram.com&oh=dc129ee082f1dad5c79ff0e56b2aafda&oe=60E39997','instagram/17873438954046776_1396866530.jpg','17873438954046776','koller_magento','https://www.instagram.com/p/CHwnuRWhvkF/',NULL,0),(105,'https://scontent.cdninstagram.com/v/t51.29350-15/126194874_190778669243529_1733426555261324593_n.jpg?_nc_cat=109&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=quHCQdS2UG8AX-7_O70&_nc_ht=scontent.cdninstagram.com&oh=d3d7b78369ccae17752858c27697b18f&oe=60E3A1A5','instagram/17883610198872210_1383668913.jpg','17883610198872210','koller_magento','https://www.instagram.com/p/CHwnpvsBjfj/',NULL,0),(106,'https://scontent.cdninstagram.com/v/t51.29350-15/133728040_147006430516175_3415465909804434535_n.jpg?_nc_cat=110&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=FP3bq7INYsMAX9XCg3K&_nc_ht=scontent.cdninstagram.com&oh=a00873bb8e69e40fd26587688cc4b974&oe=60E38802','instagram/17935041664443003_642829564.jpg','17935041664443003','koller_sneakes','https://www.instagram.com/p/CJagg8knaZ8/',NULL,17),(107,'https://scontent.cdninstagram.com/v/t51.29350-15/134482765_762362844670018_6956789973872920218_n.jpg?_nc_cat=103&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=E66okjFHAhQAX_6CQaw&_nc_ht=scontent.cdninstagram.com&oh=5e4fa19cdc5157bb6f7e0ca0f5744312&oe=60E2B2FE','instagram/17866294919199752_543566136.jpg','17866294919199752','koller_sneakes','https://www.instagram.com/p/CJage_4n6px/',NULL,17),(108,'https://scontent.cdninstagram.com/v/t51.29350-15/134250839_2839234593029097_69412112905002999_n.jpg?_nc_cat=110&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=UUT6c_TK-wgAX-lxcSk&_nc_ht=scontent.cdninstagram.com&oh=608c6cfc2deeb57f51bf1013bee9b655&oe=60E37D6A','instagram/17846317205495654_1555342267.jpg','17846317205495654','koller_sneakes','https://www.instagram.com/p/CJagdJRHkOM/',NULL,17),(109,'https://scontent.cdninstagram.com/v/t51.29350-15/133679856_2814095255544782_1253021378055714230_n.jpg?_nc_cat=108&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=j7rWTE7xQDsAX8QNpVs&_nc_ht=scontent.cdninstagram.com&oh=3c0a76755d6f40f109e57452aeb923d6&oe=60E1F9D5','instagram/17887488415864964_1735842394.jpg','17887488415864964','koller_sneakes','https://www.instagram.com/p/CJagbPFHphi/',NULL,17),(110,'https://scontent.cdninstagram.com/v/t51.29350-15/133073748_5167350276638374_2916202019455321022_n.jpg?_nc_cat=103&ccb=1-3&_nc_sid=8ae9d6&_nc_ohc=kI5htTjIf6EAX8eiOwi&_nc_ht=scontent.cdninstagram.com&oh=053b207227ceeaca8c5b1e8f51d83c22&oe=60E33FE3','instagram/17904945121627111_1753678968.jpg','17904945121627111','koller_sneakes','https://www.instagram.com/p/CJagZQmnx5J/',NULL,17);

--
-- Table structure for table `rokanthemes_pricecountdown`
--

CREATE TABLE `rokanthemes_pricecountdown` (
  `timer_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Timer ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Timer title',
  `filename` varchar(255) DEFAULT NULL COMMENT 'File Name',
  `content` text DEFAULT NULL COMMENT 'Content',
  `status` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Timer status',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`timer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cataloginventory Stock Status Indexer Tmp';

--
-- Dumping data for table `rokanthemes_pricecountdown`
--


--
-- Table structure for table `rokanthemes_slide`
--

CREATE TABLE `rokanthemes_slide` (
  `slide_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Slide ID',
  `slider_id` int(11) NOT NULL COMMENT 'Slider ID',
  `store_ids` text NOT NULL COMMENT 'Store Ids',
  `slide_status` smallint(6) DEFAULT 1 COMMENT 'Status',
  `slide_position` int(11) DEFAULT NULL COMMENT 'Slide Position',
  `slide_type` varchar(255) DEFAULT NULL COMMENT 'Slide Type',
  `slide_video` text DEFAULT NULL COMMENT 'Slide Video',
  `slide_image` varchar(255) DEFAULT NULL COMMENT 'Slide image',
  `slide_image_mobile` varchar(255) DEFAULT NULL COMMENT 'Slide image mobile',
  `slide_link` varchar(255) DEFAULT NULL COMMENT 'Slide Link',
  `opennewtab` varchar(50) DEFAULT NULL COMMENT 'Open New Tab',
  `slide_text` text DEFAULT NULL COMMENT 'Slide Text',
  `text_position` varchar(255) DEFAULT NULL COMMENT 'Text position',
  `text_animate` varchar(255) DEFAULT NULL COMMENT 'Text animate',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  PRIMARY KEY (`slide_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='Slide Item';

--
-- Dumping data for table `rokanthemes_slide`
--

INSERT INTO `rokanthemes_slide` VALUES (1,1,'[\"0\"]',1,0,NULL,NULL,'slidebanner/b/n/bnh1.3.jpg','slidebanner/1/_/1.jpg',NULL,'no','[{\"text\":\"Sale Up To 70% Off Now\",\"display\":\"3\",\"animated\":\"slideInDown\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"All Ceiling Lamps & Pendants\",\"display\":\"2\",\"animated\":\"slideInUp\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(2,1,'[\"0\"]',1,0,NULL,NULL,'slidebanner/b/n/bnh1.jpg','slidebanner/2/_/2.jpg',NULL,'no','[{\"text\":\"New Design Decor\",\"display\":\"3\",\"animated\":\"slideInDown\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"Georg Jensen Wall Clock\",\"display\":\"2\",\"animated\":\"fadeInRight\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"slideInUp\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(3,1,'[\"0\"]',1,0,NULL,NULL,'slidebanner/b/n/bnh1.2.jpg','slidebanner/h/2/h2.3_1.jpg',NULL,'no','[{\"text\":\"New Arrivals From $69\",\"display\":\"3\",\"animated\":\"fadeInDown\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"60% Sale Off Home Decor\",\"display\":\"2\",\"animated\":\"fadeInUp\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(4,2,'[\"0\"]',1,0,NULL,NULL,'slidebanner/b/a/banner-2v2.jpg','slidebanner/m/o/mobile-3.jpg',NULL,'no','[{\"text\":\"New Design Decor\",\"display\":\"3\",\"animated\":\"fadeInDown\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"Georg Jensen Wall Clock\",\"display\":\"2\",\"animated\":\"fadeInLeft\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"slideInUp\",\"color\":\"#FFFFFF\",\"customclass\":\"button-shop\"}]','left_center','yes','2021-01-19 00:00:00'),(5,2,'[\"0\"]',1,0,NULL,NULL,'slidebanner/b/a/banner-1v2.jpg','slidebanner/m/o/mobile-2.jpg',NULL,'no','[{\"text\":\"Sale Up To 70% Off Now\",\"display\":\"3\",\"animated\":\"fadeInDown\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"All Ceiling Lamps & Pendants\",\"display\":\"2\",\"animated\":\"fadeInUp\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"slideInLeft\",\"color\":\"#FFFFFF\",\"customclass\":\"button-shop\"}]','left_center','yes','2021-01-19 00:00:00'),(6,2,'[\"0\"]',1,0,NULL,NULL,'slidebanner/b/a/banner-3v2.jpg','slidebanner/m/o/mobile-1.jpg',NULL,'no','[{\"text\":\"New Arrivals From $69\",\"display\":\"3\",\"animated\":\"slideInLeft\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"60% Sale Off Home Decor\",\"display\":\"2\",\"animated\":\"slideInRight\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"slideInUp\",\"color\":\"#FFFFFF\",\"customclass\":\"button-shop\"}]','left_center','yes','2021-01-19 00:00:00'),(7,3,'[\"0\"]',1,0,NULL,NULL,'slidebanner/b/n/bnh2.jpg','slidebanner/h/2/h2.2.jpg',NULL,'no','[{\"text\":\"Sale Up To 70% Off Now\",\"display\":\"3\",\"animated\":\"fadeInDown\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"All Ceiling Lamps & Pendants\",\"display\":\"2\",\"animated\":\"slideInUp\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(8,3,'[\"0\"]',1,0,NULL,NULL,'slidebanner/b/n/bnh2.2.jpg','slidebanner/h/2/h2.3.jpg',NULL,'no','[{\"text\":\"New Arrivals From $69\",\"display\":\"3\",\"animated\":\"slideInUp\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"60% Sale Off Home Decor\",\"display\":\"2\",\"animated\":\"slideInLeft\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(9,3,'[\"0\"]',1,0,NULL,NULL,'slidebanner/b/n/bnh2.1.jpg','slidebanner/h/2/h2.1.jpg',NULL,'no','[{\"text\":\"Ribbed Sweater 60% Off\",\"display\":\"3\",\"animated\":\"fadeInLeft\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"New Design Decor\",\"display\":\"2\",\"animated\":\"fadeInRight\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2020-12-18 00:00:00'),(10,4,'[\"6\"]',1,0,NULL,NULL,'slidebanner/u/n/untitled-1_1.jpg','slidebanner/m/o/mobile-1_1.jpg',NULL,'no','[{\"text\":\"New Design Decor\",\"display\":\"3\",\"animated\":\"fadeInLeft\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"Georg Jensen Wall Clock\",\"display\":\"2\",\"animated\":\"slideInUp\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(11,4,'[\"6\"]',1,0,NULL,NULL,'slidebanner/s/l/slider-2.jpg','slidebanner/m/o/mobile-2_1.jpg',NULL,'no','[{\"text\":\"New Arrivals From $69\",\"display\":\"3\",\"animated\":\"zoomIn\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"60% Sale Off Home Decor\",\"display\":\"2\",\"animated\":\"slideInDown\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"slideInUp\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(12,4,'[\"6\"]',1,0,NULL,NULL,'slidebanner/s/l/slider-3.jpg','slidebanner/m/o/mobile-3_1.jpg',NULL,'no','[{\"text\":\"Sale Up To 70% Off Now\",\"display\":\"3\",\"animated\":\"fadeInTopLeft\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"All Ceiling Lamps & Pendants\",\"display\":\"2\",\"animated\":\"fadeInTopRight\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"fadeInUp\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(13,5,'[\"8\"]',1,0,NULL,NULL,'slidebanner/s/l/slider-1.jpg','slidebanner/m/o/mobile-1_2.jpg',NULL,'no','[{\"text\":\"Limited Time Only\",\"display\":\"3\",\"animated\":\"slideInUp\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"Interior Furniture Design\",\"display\":\"2\",\"animated\":\"fadeInLeft\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"slideInUp\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(14,5,'[\"8\"]',1,0,NULL,NULL,'slidebanner/s/l/slider-2_1.jpg','slidebanner/m/o/mobile-2_2.jpg',NULL,'no','[{\"text\":\"New Arrivals From $69\",\"display\":\"3\",\"animated\":\"fadeInDown\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"60% Sale Off Home Decor\",\"display\":\"2\",\"animated\":\"slideInUp\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(15,5,'[\"8\"]',1,0,NULL,NULL,'slidebanner/s/l/slider-3_1.jpg','slidebanner/m/o/mobile-3_2.jpg',NULL,'no','[{\"text\":\"Sale Up To 70% Off Now\",\"display\":\"3\",\"animated\":\"fadeInLeft\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"All Ceiling Lamps & Pendants\",\"display\":\"2\",\"animated\":\"fadeInLeft\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"slideInUp\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(16,6,'[\"9\"]',1,0,NULL,NULL,'slidebanner/s/i/sider-1.jpg','slidebanner/m/o/mobile-1_3.jpg',NULL,'no','[{\"text\":\"Sale Up To 70% Off Now\",\"display\":\"3\",\"animated\":\"zoomIn\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"All Ceiling Lamps & Pendants\",\"display\":\"2\",\"animated\":\"slideInDown\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"slideInUp\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(17,6,'[\"9\"]',1,0,NULL,NULL,'slidebanner/s/l/slider-2_2.jpg','slidebanner/m/o/mobile-2_3.jpg',NULL,'no','[{\"text\":\"New Design Decor\",\"display\":\"3\",\"animated\":\"fadeInDown\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"Georg Jensen Wall Clock\",\"display\":\"2\",\"animated\":\"fadeInUp\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(18,6,'[\"9\"]',1,0,NULL,NULL,'slidebanner/s/l/slider-3_2.jpg','slidebanner/m/o/mobile-3_3.jpg',NULL,'no','[{\"text\":\"New Arrivals From $69\",\"display\":\"3\",\"animated\":\"slideInDown\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"60% Sale Off Home Decor\",\"display\":\"2\",\"animated\":\"slideInUp\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(19,8,'[\"11\"]',1,0,NULL,NULL,'slidebanner/b/a/banner-1.jpg','slidebanner/m/o/mobile-1_4.jpg',NULL,'no','[{\"text\":\"New Arrivals From $69\",\"display\":\"3\",\"animated\":\"fadeInLeft\",\"color\":\"#1A73E8\",\"customclass\":\"\"},{\"text\":\"60% Sale Off Home Decor\",\"display\":\"2\",\"animated\":\"slideInUp\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_top','yes','2021-01-19 00:00:00'),(20,8,'[\"11\"]',1,0,NULL,NULL,'slidebanner/b/a/banner2-1.jpg','slidebanner/m/o/mobile2-1.jpg',NULL,'no','[{\"text\":\"New Design Your Style\",\"display\":\"3\",\"animated\":\"fadeInUp\",\"color\":\"#1A73E8\",\"customclass\":\"\"},{\"text\":\"Home Decor & Furniture\",\"display\":\"2\",\"animated\":\"fadeInLeft\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','center_top','yes','2021-01-19 00:00:00'),(21,8,'[\"11\"]',1,0,NULL,NULL,'slidebanner/b/a/banner3-1.jpg','slidebanner/m/o/mobile3-1.jpg',NULL,'no','[{\"text\":\"Sale Up To 70% Off Now\",\"display\":\"3\",\"animated\":\"slideInUp\",\"color\":\"#1A73E8\",\"customclass\":\"\"},{\"text\":\"All Ceiling Lamps <br>  & Furniture\",\"display\":\"2\",\"animated\":\"fadeInUp\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','center_center','yes','2021-01-19 00:00:00'),(22,9,'[\"15\"]',1,0,NULL,NULL,'slidebanner/b/a/banner-1_2.jpg','slidebanner/m/o/mobile-1_9.jpg',NULL,'no','[{\"text\":\" Upto 70% Off\",\"display\":\"5\",\"animated\":\"slideInDown\",\"color\":\"#FFFFFF\",\"customclass\":\"\"},{\"text\":\"Great Summer Clearance Sales\",\"display\":\"2\",\"animated\":\"slideInUp\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#343E45\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(23,9,'[\"15\"]',1,0,NULL,NULL,'slidebanner/b/a/banner-2_2.jpg','slidebanner/m/o/mobile-2_8.jpg',NULL,'no','[{\"text\":\"Spring\\/ Summer 2021\",\"display\":\"5\",\"animated\":\"fadeInDown\",\"color\":\"#FFFFFF\",\"customclass\":\"\"},{\"text\":\"Mid - Season Sale 60% Off Now!\",\"display\":\"2\",\"animated\":\"slideInUp\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#343E45\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(24,9,'[\"15\"]',1,0,NULL,NULL,'slidebanner/b/a/banner-3_2.jpg','slidebanner/m/o/mobile-3_8.jpg',NULL,'no','[{\"text\":\"20% Sale\",\"display\":\"5\",\"animated\":\"fadeIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"},{\"text\":\"Enjoy This Summer Trend\",\"display\":\"2\",\"animated\":\"slideInLeft\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#343E45\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(25,10,'[\"14\"]',1,0,NULL,NULL,'slidebanner/s/l/slider-1_2.jpg','slidebanner/m/o/mobile-1_8.jpg',NULL,'yes','[{\"text\":\" Upto 70% Off\",\"display\":\"5\",\"animated\":\"fadeInDown\",\"color\":\"#FFFFFF\",\"customclass\":\"\"},{\"text\":\"Great Summer Clearance Sales\",\"display\":\"2\",\"animated\":\"slideInLeft\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"slideInUp\",\"color\":\"#343E45\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(26,10,'[\"14\"]',1,0,NULL,NULL,'slidebanner/s/l/slider-2_4.jpg','slidebanner/m/o/mobile-2_7.jpg',NULL,'no','[{\"text\":\"Spring\\/ Summer 2021\",\"display\":\"5\",\"animated\":\"fadeInLeft\",\"color\":\"#FFFFFF\",\"customclass\":\"\"},{\"text\":\"Mid - Season Sale 60% Off Now!\",\"display\":\"2\",\"animated\":\"fadeInRight\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#343E45\",\"customclass\":\"\"}]','left_center','yes','2021-01-14 00:00:00'),(27,10,'[\"14\"]',1,0,NULL,NULL,'slidebanner/s/l/slider-3_4.jpg','slidebanner/m/o/mobile-3_7.jpg',NULL,'no','[{\"text\":\"20% Sale\",\"display\":\"5\",\"animated\":\"slideInLeft\",\"color\":\"#FFFFFF\",\"customclass\":\"\"},{\"text\":\"Enjoy This Summer Trend\",\"display\":\"2\",\"animated\":\"slideInUp\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#343E45\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(28,11,'[\"16\",\"17\"]',1,0,NULL,NULL,'slidebanner/u/n/untitled-1_2.jpg','slidebanner/m/o/mobile-1_7.jpg',NULL,'no','[{\"text\":\"2021 Now Featuring <br> Dunk Sneakers.\",\"display\":\"2\",\"animated\":\"slideInDown\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Exclusion & Conditions Apply. *\",\"display\":\"6\",\"animated\":\"slideInLeft\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(29,11,'[\"16\",\"17\"]',1,0,NULL,NULL,'slidebanner/b/a/banner-2_1.jpg','slidebanner/m/o/mobile-2_6.jpg',NULL,'no','[{\"text\":\"Men\\u2019s Lookbook <br> Today 60% Off Shoes.\",\"display\":\"2\",\"animated\":\"slideInUp\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Discover now latest collection.\",\"display\":\"6\",\"animated\":\"slideInLeft\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"zoomIn\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00'),(30,11,'[\"16\",\"17\"]',1,0,NULL,NULL,'slidebanner/b/a/banner-3_1.jpg','slidebanner/m/o/mobile-3_6.jpg',NULL,'no','[{\"text\":\"40% Off Full Price <br> Shoes & Sneakers.\",\"display\":\"2\",\"animated\":\"fadeInDown\",\"color\":\"#343E45\",\"customclass\":\"\"},{\"text\":\"Exclusion & Conditions Apply. *\",\"display\":\"6\",\"animated\":\"fadeInLeft\",\"color\":\"#666666\",\"customclass\":\"\"},{\"text\":\"Start Shopping\",\"display\":\"7\",\"animated\":\"slideInUp\",\"color\":\"#FFFFFF\",\"customclass\":\"\"}]','left_center','yes','2021-01-19 00:00:00');

--
-- Table structure for table `rokanthemes_slider`
--

CREATE TABLE `rokanthemes_slider` (
  `slider_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Slider ID',
  `slider_identifier` varchar(255) NOT NULL COMMENT 'Identifier',
  `slider_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Slider title',
  `slider_status` smallint(6) DEFAULT 1 COMMENT 'Status',
  `slider_setting` text DEFAULT NULL COMMENT 'Setting slider',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created Date',
  PRIMARY KEY (`slider_id`),
  KEY `slider_identifier` (`slider_identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='Slider';

--
-- Dumping data for table `rokanthemes_slider`
--

INSERT INTO `rokanthemes_slider` VALUES (1,'funiture demo 1','Funiture demo 1 slider',1,'{\"fullwidth\":\"1\",\"effect\":\"random\",\"slices\":\"15\",\"boxCols\":\"8\",\"boxRows\":\"4\",\"animSpeed\":\"500\",\"pauseTime\":\"6000\",\"startSlide\":\"0\",\"directionNav\":\"false\",\"controlNav\":\"true\",\"controlNavThumbs\":\"false\",\"pauseOnHover\":\"false\",\"manualAdvance\":\"false\",\"nextText\":\"Next\",\"prevText\":\"Prev\",\"randomStart\":\"false\",\"progressBar\":\"false\"}','2021-01-13 00:00:00'),(2,'funiture-03-slider','Funiture 03 slider',1,'{\"effect\":\"random\",\"slices\":\"15\",\"boxCols\":\"8\",\"boxRows\":\"4\",\"animSpeed\":\"500\",\"pauseTime\":\"6000\",\"startSlide\":\"0\",\"directionNav\":\"false\",\"controlNav\":\"true\",\"controlNavThumbs\":\"false\",\"pauseOnHover\":\"false\",\"manualAdvance\":\"false\",\"nextText\":\"Next\",\"prevText\":\"Prev\",\"randomStart\":\"false\",\"progressBar\":\"false\"}','2020-12-08 00:00:00'),(3,'funiture-02-slider','Funiture 02 slider',1,'{\"effect\":\"random\",\"slices\":\"15\",\"boxCols\":\"8\",\"boxRows\":\"4\",\"animSpeed\":\"500\",\"pauseTime\":\"6000\",\"startSlide\":\"0\",\"directionNav\":\"true\",\"controlNav\":\"true\",\"controlNavThumbs\":\"false\",\"pauseOnHover\":\"false\",\"manualAdvance\":\"false\",\"nextText\":\"Next\",\"prevText\":\"Prev\",\"randomStart\":\"false\",\"progressBar\":\"false\"}','2020-12-21 00:00:00'),(4,'funiture-04-slider','Funiture 04 slider',1,'{\"effect\":\"random\",\"slices\":\"15\",\"boxCols\":\"8\",\"boxRows\":\"4\",\"animSpeed\":\"500\",\"pauseTime\":\"6000\",\"startSlide\":\"0\",\"directionNav\":\"true\",\"controlNav\":\"true\",\"controlNavThumbs\":\"false\",\"pauseOnHover\":\"false\",\"manualAdvance\":\"false\",\"nextText\":\"Next\",\"prevText\":\"Prev\",\"randomStart\":\"false\",\"progressBar\":\"false\"}','2020-12-17 00:00:00'),(5,'funiture-5-slider','Funiture 05 slider',1,'{\"effect\":\"random\",\"slices\":\"15\",\"boxCols\":\"8\",\"boxRows\":\"4\",\"animSpeed\":\"500\",\"pauseTime\":\"6000\",\"startSlide\":\"0\",\"directionNav\":\"true\",\"controlNav\":\"true\",\"controlNavThumbs\":\"false\",\"pauseOnHover\":\"false\",\"manualAdvance\":\"false\",\"nextText\":\"Next\",\"prevText\":\"Prev\",\"randomStart\":\"false\",\"progressBar\":\"false\"}','2020-12-24 00:00:00'),(6,'funiture-6-slider','Funiture 06 slider',1,'{\"effect\":\"random\",\"slices\":\"15\",\"boxCols\":\"8\",\"boxRows\":\"4\",\"animSpeed\":\"500\",\"pauseTime\":\"6000\",\"startSlide\":\"0\",\"directionNav\":\"true\",\"controlNav\":\"true\",\"controlNavThumbs\":\"false\",\"pauseOnHover\":\"false\",\"manualAdvance\":\"false\",\"nextText\":\"Next\",\"prevText\":\"Prev\",\"randomStart\":\"false\",\"progressBar\":\"false\"}','2020-12-25 00:00:00'),(8,'funiture-8-slider','Funiture 08 slider',1,'{\"fullwidth\":\"0\",\"effect\":\"sliceDownLeft\",\"slices\":\"15\",\"boxCols\":\"8\",\"boxRows\":\"4\",\"animSpeed\":\"500\",\"pauseTime\":\"6000\",\"startSlide\":\"0\",\"directionNav\":\"false\",\"controlNav\":\"true\",\"controlNavThumbs\":\"false\",\"pauseOnHover\":\"false\",\"manualAdvance\":\"false\",\"nextText\":\"Next\",\"prevText\":\"Prev\",\"randomStart\":\"false\",\"progressBar\":\"false\"}','2020-12-26 00:00:00'),(9,'fashion-1-slider','Fashion 01 slider',1,'{\"fullwidth\":\"1\",\"effect\":\"random\",\"slices\":\"15\",\"boxCols\":\"8\",\"boxRows\":\"4\",\"animSpeed\":\"500\",\"pauseTime\":\"4000000\",\"startSlide\":\"1\",\"directionNav\":\"true\",\"controlNav\":\"true\",\"controlNavThumbs\":\"false\",\"pauseOnHover\":\"false\",\"manualAdvance\":\"false\",\"nextText\":\"Next\",\"prevText\":\"Prev\",\"randomStart\":\"false\",\"progressBar\":\"false\"}','2020-12-26 00:00:00'),(10,'fashion-2-slider','Fashion 02 slider',1,'{\"fullwidth\":\"1\",\"effect\":\"random\",\"slices\":\"15\",\"boxCols\":\"8\",\"boxRows\":\"4\",\"animSpeed\":\"500\",\"pauseTime\":\"4000\",\"startSlide\":\"1\",\"directionNav\":\"true\",\"controlNav\":\"true\",\"controlNavThumbs\":\"false\",\"pauseOnHover\":\"false\",\"manualAdvance\":\"false\",\"nextText\":\"Next\",\"prevText\":\"Prev\",\"randomStart\":\"false\",\"progressBar\":\"false\"}','2020-12-28 00:00:00'),(11,'sneakers','Sneakers slider',1,'{\"fullwidth\":\"1\",\"effect\":\"random\",\"slices\":\"15\",\"boxCols\":\"8\",\"boxRows\":\"4\",\"animSpeed\":\"500\",\"pauseTime\":\"4000\",\"startSlide\":\"1\",\"directionNav\":\"true\",\"controlNav\":\"true\",\"controlNavThumbs\":\"false\",\"pauseOnHover\":\"false\",\"manualAdvance\":\"false\",\"nextText\":\"Next\",\"prevText\":\"Prev\",\"randomStart\":\"false\",\"progressBar\":\"false\"}','2020-12-30 00:00:00');

--
-- Table structure for table `rokanthemes_sorting_bestseller`
--

CREATE TABLE `rokanthemes_sorting_bestseller` (
  `index_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Index ID',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `bestseller` int(10) unsigned NOT NULL COMMENT 'Bestseller',
  PRIMARY KEY (`index_id`),
  UNIQUE KEY `ROKANTHEMES_SORTING_BESTSELLER_STORE_ID_PRODUCT_ID` (`store_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Count Login Attempts';

--
-- Dumping data for table `rokanthemes_sorting_bestseller`
--


--
-- Table structure for table `rokanthemes_sorting_most_viewed`
--

CREATE TABLE `rokanthemes_sorting_most_viewed` (
  `index_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Index ID',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `viewed` int(10) unsigned NOT NULL COMMENT 'Viewed',
  PRIMARY KEY (`index_id`),
  UNIQUE KEY `ROKANTHEMES_SORTING_MOST_VIEWED_STORE_ID_PRODUCT_ID` (`store_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Count Login Attempts';

--
-- Dumping data for table `rokanthemes_sorting_most_viewed`
--


--
-- Table structure for table `rokanthemes_sorting_review_rate`
--

CREATE TABLE `rokanthemes_sorting_review_rate` (
  `index_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Index ID',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `rate` int(10) unsigned NOT NULL COMMENT 'Rate Average',
  PRIMARY KEY (`index_id`),
  UNIQUE KEY `ROKANTHEMES_SORTING_REVIEW_RATE_STORE_ID_PRODUCT_ID` (`store_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Count Login Attempts';

--
-- Dumping data for table `rokanthemes_sorting_review_rate`
--


--
-- Table structure for table `rokanthemes_themeoptionversion`
--

CREATE TABLE `rokanthemes_themeoptionversion` (
  `version_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Version ID',
  `version` varchar(255) DEFAULT NULL COMMENT 'Version',
  `version_time` timestamp NULL DEFAULT NULL COMMENT 'Version Update Time',
  PRIMARY KEY (`version_id`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8 COMMENT='rokanthemes_themeoptionversion';

--
-- Dumping data for table `rokanthemes_themeoptionversion`
--

INSERT INTO `rokanthemes_themeoptionversion` VALUES (1,'1604413347','2020-11-03 14:22:27'),(2,'1604413648','2020-11-03 14:27:28'),(3,'1604502718','2020-11-04 15:11:58'),(4,'1605193801','2020-11-12 15:10:01'),(5,'1605513912','2020-11-16 08:05:12'),(6,'1607070577','2020-12-04 08:29:37'),(7,'1607570339','2020-12-10 03:18:59'),(8,'1607573061','2020-12-10 04:04:21'),(9,'1607573418','2020-12-10 04:10:18'),(10,'1607576339','2020-12-10 04:58:59'),(11,'1607576674','2020-12-10 05:04:34'),(12,'1607583291','2020-12-10 06:54:51'),(13,'1607585987','2020-12-10 07:39:47'),(14,'1607588219','2020-12-10 08:16:59'),(15,'1607589075','2020-12-10 08:31:15'),(16,'1607589773','2020-12-10 08:42:53'),(17,'1607589848','2020-12-10 08:44:08'),(18,'1607654723','2020-12-11 02:45:23'),(19,'1607654929','2020-12-11 02:48:49'),(20,'1607655359','2020-12-11 02:55:59'),(21,'1607655668','2020-12-11 03:01:08'),(22,'1607655700','2020-12-11 03:01:40'),(23,'1607656622','2020-12-11 03:17:02'),(24,'1607657132','2020-12-11 03:25:32'),(25,'1607659678','2020-12-11 04:07:58'),(26,'1607659769','2020-12-11 04:09:29'),(27,'1607659873','2020-12-11 04:11:13'),(28,'1607659915','2020-12-11 04:11:55'),(29,'1607659952','2020-12-11 04:12:32'),(30,'1607659991','2020-12-11 04:13:11'),(31,'1607660064','2020-12-11 04:14:24'),(32,'1607660118','2020-12-11 04:15:18'),(33,'1607660412','2020-12-11 04:20:12'),(34,'1607660432','2020-12-11 04:20:32'),(35,'1607660499','2020-12-11 04:21:39'),(36,'1607668900','2020-12-11 06:41:40'),(37,'1607743522','2020-12-12 03:25:22'),(38,'1607744014','2020-12-12 03:33:34'),(39,'1607744446','2020-12-12 03:40:46'),(40,'1607744519','2020-12-12 03:41:59'),(41,'1607744801','2020-12-12 03:46:41'),(42,'1607745014','2020-12-12 03:50:14'),(43,'1607745398','2020-12-12 03:56:38'),(44,'1607745784','2020-12-12 04:03:04'),(45,'1607749816','2020-12-12 05:10:16'),(46,'1608093038','2020-12-16 04:30:38'),(47,'1608093130','2020-12-16 04:32:10'),(48,'1608093161','2020-12-16 04:32:41'),(49,'1608093402','2020-12-16 04:36:42'),(50,'1608710122','2020-12-23 07:55:22'),(51,'1609385096','2020-12-31 03:24:56'),(52,'1609737942','2021-01-04 05:25:42'),(53,'1609741154','2021-01-04 06:19:14'),(54,'1610418261','2021-01-12 02:24:21'),(55,'1610507559','2021-01-13 03:12:39'),(56,'1610507641','2021-01-13 03:14:01'),(57,'1610507691','2021-01-13 03:14:51'),(58,'1610507923','2021-01-13 03:18:43'),(59,'1610508087','2021-01-13 03:21:27'),(60,'1610508238','2021-01-13 03:23:58'),(61,'1610508792','2021-01-13 03:33:12'),(62,'1610509530','2021-01-13 03:45:30'),(63,'1610520598','2021-01-13 06:49:58'),(64,'1610520664','2021-01-13 06:51:04'),(65,'1610520716','2021-01-13 06:51:56'),(66,'1610520817','2021-01-13 06:53:37'),(67,'1611105622','2021-01-20 01:20:22'),(68,'1611106912','2021-01-20 01:41:52'),(69,'1611106996','2021-01-20 01:43:16'),(70,'1611107058','2021-01-20 01:44:18'),(71,'1611107134','2021-01-20 01:45:34'),(72,'1611107215','2021-01-20 01:46:55'),(73,'1611107299','2021-01-20 01:48:19'),(74,'1611107484','2021-01-20 01:51:24'),(75,'1611128211','2021-01-20 07:36:51'),(76,'1611201716','2021-01-21 04:01:56'),(77,'1611560675','2021-01-25 07:44:35'),(78,'1611561772','2021-01-25 08:02:52'),(79,'1611565420','2021-01-25 09:03:40'),(80,'1611566572','2021-01-25 09:22:52'),(81,'1611567384','2021-01-25 09:36:24'),(82,'1611625403','2021-01-26 01:43:23'),(83,'1611645008','2021-01-26 07:10:08'),(84,'1611645035','2021-01-26 07:10:35'),(85,'1611645072','2021-01-26 07:11:12'),(86,'1614236941','2021-02-25 07:09:01'),(87,'1614241209','2021-02-25 08:20:09'),(88,'1614241528','2021-02-25 08:25:28'),(89,'1614241947','2021-02-25 08:32:27'),(90,'1614242055','2021-02-25 08:34:15'),(91,'1614242180','2021-02-25 08:36:20'),(92,'1614242248','2021-02-25 08:37:28'),(93,'1614242372','2021-02-25 08:39:32'),(94,'1614242720','2021-02-25 08:45:20'),(95,'1616382318','2021-03-22 03:05:18'),(96,'1616382434','2021-03-22 03:07:14'),(97,'1616383589','2021-03-22 03:26:29'),(98,'1616383674','2021-03-22 03:27:54'),(99,'1616384519','2021-03-22 03:41:59'),(100,'1616384566','2021-03-22 03:42:46'),(101,'1616981642','2021-03-29 01:34:02'),(102,'1622623276','2021-06-02 08:41:16'),(103,'1624893187','2021-06-28 15:13:07'),(104,'1624893847','2021-06-28 15:24:07'),(105,'1624894164','2021-06-28 15:29:24'),(106,'1625541471','2021-07-06 03:17:51'),(107,'1625541686','2021-07-06 03:21:26'),(108,'1625542570','2021-07-06 03:36:10'),(109,'1625562318','2021-07-06 09:05:18'),(110,'1652167523','2022-05-10 07:25:23');

--
-- Table structure for table `sales_bestsellers_aggregated_daily`
--

CREATE TABLE `sales_bestsellers_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',
  `qty_ordered` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Qty Ordered',
  `rating_pos` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_BESTSELLERS_AGGREGATED_DAILY_PERIOD_STORE_ID_PRODUCT_ID` (`period`,`store_id`,`product_id`),
  KEY `SALES_BESTSELLERS_AGGREGATED_DAILY_STORE_ID` (`store_id`),
  KEY `SALES_BESTSELLERS_AGGREGATED_DAILY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `SALES_BESTSELLERS_AGGREGATED_DAILY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Bestsellers Aggregated Daily';

--
-- Dumping data for table `sales_bestsellers_aggregated_daily`
--


--
-- Table structure for table `sales_bestsellers_aggregated_monthly`
--

CREATE TABLE `sales_bestsellers_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',
  `qty_ordered` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Qty Ordered',
  `rating_pos` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_BESTSELLERS_AGGREGATED_MONTHLY_PERIOD_STORE_ID_PRODUCT_ID` (`period`,`store_id`,`product_id`),
  KEY `SALES_BESTSELLERS_AGGREGATED_MONTHLY_STORE_ID` (`store_id`),
  KEY `SALES_BESTSELLERS_AGGREGATED_MONTHLY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `SALES_BESTSELLERS_AGGREGATED_MONTHLY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Bestsellers Aggregated Monthly';

--
-- Dumping data for table `sales_bestsellers_aggregated_monthly`
--


--
-- Table structure for table `sales_bestsellers_aggregated_yearly`
--

CREATE TABLE `sales_bestsellers_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',
  `qty_ordered` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Qty Ordered',
  `rating_pos` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Rating Pos',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_BESTSELLERS_AGGREGATED_YEARLY_PERIOD_STORE_ID_PRODUCT_ID` (`period`,`store_id`,`product_id`),
  KEY `SALES_BESTSELLERS_AGGREGATED_YEARLY_STORE_ID` (`store_id`),
  KEY `SALES_BESTSELLERS_AGGREGATED_YEARLY_PRODUCT_ID` (`product_id`),
  CONSTRAINT `SALES_BESTSELLERS_AGGREGATED_YEARLY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Bestsellers Aggregated Yearly';

--
-- Dumping data for table `sales_bestsellers_aggregated_yearly`
--


--
-- Table structure for table `sales_creditmemo`
--

CREATE TABLE `sales_creditmemo` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Positive',
  `base_shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Amount',
  `store_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Store To Order Rate',
  `base_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Amount',
  `base_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Order Rate',
  `grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
  `base_adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment Negative',
  `base_subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Incl Tax',
  `shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
  `subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Incl Tax',
  `adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Negative',
  `base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
  `store_to_base_rate` decimal(20,4) DEFAULT NULL COMMENT 'Store To Base Rate',
  `base_to_global_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Global Rate',
  `base_adjustment` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment',
  `base_subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal',
  `discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Amount',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `adjustment` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  `base_adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment Positive',
  `base_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Amount',
  `shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Amount',
  `tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Amount',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `email_sent` smallint(5) unsigned DEFAULT NULL COMMENT 'Email Sent',
  `send_email` smallint(5) unsigned DEFAULT NULL COMMENT 'Send Email',
  `creditmemo_status` int(11) DEFAULT NULL COMMENT 'Creditmemo Status',
  `state` int(11) DEFAULT NULL COMMENT 'State',
  `shipping_address_id` int(11) DEFAULT NULL COMMENT 'Shipping Address ID',
  `billing_address_id` int(11) DEFAULT NULL COMMENT 'Billing Address ID',
  `invoice_id` int(11) DEFAULT NULL COMMENT 'Invoice ID',
  `store_currency_code` varchar(3) DEFAULT NULL COMMENT 'Store Currency Code',
  `order_currency_code` varchar(3) DEFAULT NULL COMMENT 'Order Currency Code',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  `global_currency_code` varchar(3) DEFAULT NULL COMMENT 'Global Currency Code',
  `transaction_id` varchar(255) DEFAULT NULL COMMENT 'Transaction ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
  `discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `shipping_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Tax Compensation Amount',
  `base_shipping_discount_tax_compensation_amnt` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Tax Compensation Amount',
  `shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Incl Tax',
  `base_shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Incl Tax',
  `discount_description` varchar(255) DEFAULT NULL COMMENT 'Discount Description',
  `customer_note` text DEFAULT NULL COMMENT 'Customer Note',
  `customer_note_notify` smallint(5) unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_CREDITMEMO_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_CREDITMEMO_STORE_ID` (`store_id`),
  KEY `SALES_CREDITMEMO_ORDER_ID` (`order_id`),
  KEY `SALES_CREDITMEMO_CREDITMEMO_STATUS` (`creditmemo_status`),
  KEY `SALES_CREDITMEMO_STATE` (`state`),
  KEY `SALES_CREDITMEMO_CREATED_AT` (`created_at`),
  KEY `SALES_CREDITMEMO_UPDATED_AT` (`updated_at`),
  KEY `SALES_CREDITMEMO_SEND_EMAIL` (`send_email`),
  KEY `SALES_CREDITMEMO_EMAIL_SENT` (`email_sent`),
  CONSTRAINT `SALES_CREDITMEMO_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_CREDITMEMO_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Creditmemo';

--
-- Dumping data for table `sales_creditmemo`
--


--
-- Table structure for table `sales_creditmemo_comment`
--

CREATE TABLE `sales_creditmemo_comment` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `is_customer_notified` int(11) DEFAULT NULL COMMENT 'Is Customer Notified',
  `is_visible_on_front` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Visible On Front',
  `comment` text DEFAULT NULL COMMENT 'Comment',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_CREDITMEMO_COMMENT_CREATED_AT` (`created_at`),
  KEY `SALES_CREDITMEMO_COMMENT_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_CREDITMEMO_COMMENT_PARENT_ID_SALES_CREDITMEMO_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_creditmemo` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Creditmemo Comment';

--
-- Dumping data for table `sales_creditmemo_comment`
--


--
-- Table structure for table `sales_creditmemo_grid`
--

CREATE TABLE `sales_creditmemo_grid` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `order_increment_id` varchar(50) DEFAULT NULL COMMENT 'Order Increment ID',
  `order_created_at` timestamp NULL DEFAULT NULL COMMENT 'Order Created At',
  `billing_name` varchar(255) DEFAULT NULL COMMENT 'Billing Name',
  `state` int(11) DEFAULT NULL COMMENT 'Status',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  `order_status` varchar(32) DEFAULT NULL COMMENT 'Order Status',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
  `shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
  `customer_name` varchar(128) NOT NULL COMMENT 'Customer Name',
  `customer_email` varchar(128) DEFAULT NULL COMMENT 'Customer Email',
  `customer_group_id` smallint(6) DEFAULT NULL COMMENT 'Customer Group ID',
  `payment_method` varchar(32) DEFAULT NULL COMMENT 'Payment Method',
  `shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `shipping_and_handling` decimal(20,4) DEFAULT NULL COMMENT 'Shipping and handling amount',
  `adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Positive',
  `adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Negative',
  `order_base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Order Grand Total',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_CREDITMEMO_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_CREDITMEMO_GRID_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `SALES_CREDITMEMO_GRID_CREATED_AT` (`created_at`),
  KEY `SALES_CREDITMEMO_GRID_UPDATED_AT` (`updated_at`),
  KEY `SALES_CREDITMEMO_GRID_ORDER_CREATED_AT` (`order_created_at`),
  KEY `SALES_CREDITMEMO_GRID_STATE` (`state`),
  KEY `SALES_CREDITMEMO_GRID_BILLING_NAME` (`billing_name`),
  KEY `SALES_CREDITMEMO_GRID_ORDER_STATUS` (`order_status`),
  KEY `SALES_CREDITMEMO_GRID_BASE_GRAND_TOTAL` (`base_grand_total`),
  KEY `SALES_CREDITMEMO_GRID_STORE_ID` (`store_id`),
  KEY `SALES_CREDITMEMO_GRID_ORDER_BASE_GRAND_TOTAL` (`order_base_grand_total`),
  KEY `SALES_CREDITMEMO_GRID_ORDER_ID` (`order_id`),
  FULLTEXT KEY `FTI_32B7BA885941A8254EE84AE650ABDC86` (`increment_id`,`order_increment_id`,`billing_name`,`billing_address`,`shipping_address`,`customer_name`,`customer_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Creditmemo Grid';

--
-- Dumping data for table `sales_creditmemo_grid`
--


--
-- Table structure for table `sales_creditmemo_item`
--

CREATE TABLE `sales_creditmemo_item` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `base_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Price',
  `tax_amount` decimal(12,4) DEFAULT NULL COMMENT 'Tax Amount',
  `base_row_total` decimal(12,4) DEFAULT NULL COMMENT 'Base Row Total',
  `discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Discount Amount',
  `row_total` decimal(12,4) DEFAULT NULL COMMENT 'Row Total',
  `base_discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Discount Amount',
  `price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Price Incl Tax',
  `base_tax_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Tax Amount',
  `base_price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
  `qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
  `base_cost` decimal(12,4) DEFAULT NULL COMMENT 'Base Cost',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
  `base_row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
  `row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
  `product_id` int(11) DEFAULT NULL COMMENT 'Product ID',
  `order_item_id` int(11) DEFAULT NULL COMMENT 'Order Item ID',
  `additional_data` text DEFAULT NULL COMMENT 'Additional Data',
  `description` text DEFAULT NULL COMMENT 'Description',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `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',
  `tax_ratio` text DEFAULT NULL COMMENT 'Ratio of tax in the creditmemo item over tax of the order item',
  `weee_tax_applied` text DEFAULT NULL 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 (`entity_id`),
  KEY `SALES_CREDITMEMO_ITEM_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_CREDITMEMO_ITEM_PARENT_ID_SALES_CREDITMEMO_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_creditmemo` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Creditmemo Item';

--
-- Dumping data for table `sales_creditmemo_item`
--


--
-- Table structure for table `sales_invoice`
--

CREATE TABLE `sales_invoice` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  `shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Amount',
  `tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Amount',
  `base_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Amount',
  `store_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Store To Order Rate',
  `base_shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Amount',
  `base_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Amount',
  `base_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Order Rate',
  `grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
  `shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
  `subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Incl Tax',
  `base_subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Incl Tax',
  `store_to_base_rate` decimal(20,4) DEFAULT NULL COMMENT 'Store To Base Rate',
  `base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
  `total_qty` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty',
  `base_to_global_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Global Rate',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `base_subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal',
  `discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Amount',
  `billing_address_id` int(11) DEFAULT NULL COMMENT 'Billing Address ID',
  `is_used_for_refund` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Used For Refund',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `email_sent` smallint(5) unsigned DEFAULT NULL COMMENT 'Email Sent',
  `send_email` smallint(5) unsigned DEFAULT NULL COMMENT 'Send Email',
  `can_void_flag` smallint(5) unsigned DEFAULT NULL COMMENT 'Can Void Flag',
  `state` int(11) DEFAULT NULL COMMENT 'State',
  `shipping_address_id` int(11) DEFAULT NULL COMMENT 'Shipping Address ID',
  `store_currency_code` varchar(3) DEFAULT NULL COMMENT 'Store Currency Code',
  `transaction_id` varchar(255) DEFAULT NULL COMMENT 'Transaction ID',
  `order_currency_code` varchar(3) DEFAULT NULL COMMENT 'Order Currency Code',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  `global_currency_code` varchar(3) DEFAULT NULL COMMENT 'Global Currency Code',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
  `discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `shipping_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Tax Compensation Amount',
  `base_shipping_discount_tax_compensation_amnt` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Tax Compensation Amount',
  `shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Incl Tax',
  `base_shipping_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Incl Tax',
  `base_total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Refunded',
  `discount_description` varchar(255) DEFAULT NULL COMMENT 'Discount Description',
  `customer_note` text DEFAULT NULL COMMENT 'Customer Note',
  `customer_note_notify` smallint(5) unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_INVOICE_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_INVOICE_STORE_ID` (`store_id`),
  KEY `SALES_INVOICE_GRAND_TOTAL` (`grand_total`),
  KEY `SALES_INVOICE_ORDER_ID` (`order_id`),
  KEY `SALES_INVOICE_STATE` (`state`),
  KEY `SALES_INVOICE_CREATED_AT` (`created_at`),
  KEY `SALES_INVOICE_UPDATED_AT` (`updated_at`),
  KEY `SALES_INVOICE_SEND_EMAIL` (`send_email`),
  KEY `SALES_INVOICE_EMAIL_SENT` (`email_sent`),
  CONSTRAINT `SALES_INVOICE_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_INVOICE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Invoice';

--
-- Dumping data for table `sales_invoice`
--


--
-- Table structure for table `sales_invoice_comment`
--

CREATE TABLE `sales_invoice_comment` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `is_customer_notified` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Customer Notified',
  `is_visible_on_front` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Visible On Front',
  `comment` text DEFAULT NULL COMMENT 'Comment',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_INVOICE_COMMENT_CREATED_AT` (`created_at`),
  KEY `SALES_INVOICE_COMMENT_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_INVOICE_COMMENT_PARENT_ID_SALES_INVOICE_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_invoice` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Invoice Comment';

--
-- Dumping data for table `sales_invoice_comment`
--


--
-- Table structure for table `sales_invoice_grid`
--

CREATE TABLE `sales_invoice_grid` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `state` int(11) DEFAULT NULL COMMENT 'State',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `store_name` varchar(255) DEFAULT NULL COMMENT 'Store Name',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `order_increment_id` varchar(50) DEFAULT NULL COMMENT 'Order Increment ID',
  `order_created_at` timestamp NULL DEFAULT NULL COMMENT 'Order Created At',
  `customer_name` varchar(255) DEFAULT NULL COMMENT 'Customer Name',
  `customer_email` varchar(255) DEFAULT NULL COMMENT 'Customer Email',
  `customer_group_id` int(11) DEFAULT NULL,
  `payment_method` varchar(128) DEFAULT NULL COMMENT 'Payment Method',
  `store_currency_code` varchar(3) DEFAULT NULL COMMENT 'Store Currency Code',
  `order_currency_code` varchar(3) DEFAULT NULL COMMENT 'Order Currency Code',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  `global_currency_code` varchar(3) DEFAULT NULL COMMENT 'Global Currency Code',
  `billing_name` varchar(255) DEFAULT NULL COMMENT 'Billing Name',
  `billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
  `shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
  `shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `shipping_and_handling` decimal(20,4) DEFAULT NULL COMMENT 'Shipping and handling amount',
  `grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_INVOICE_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_INVOICE_GRID_STORE_ID` (`store_id`),
  KEY `SALES_INVOICE_GRID_GRAND_TOTAL` (`grand_total`),
  KEY `SALES_INVOICE_GRID_ORDER_ID` (`order_id`),
  KEY `SALES_INVOICE_GRID_STATE` (`state`),
  KEY `SALES_INVOICE_GRID_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `SALES_INVOICE_GRID_CREATED_AT` (`created_at`),
  KEY `SALES_INVOICE_GRID_UPDATED_AT` (`updated_at`),
  KEY `SALES_INVOICE_GRID_ORDER_CREATED_AT` (`order_created_at`),
  KEY `SALES_INVOICE_GRID_BILLING_NAME` (`billing_name`),
  KEY `SALES_INVOICE_GRID_BASE_GRAND_TOTAL` (`base_grand_total`),
  FULLTEXT KEY `FTI_95D9C924DD6A8734EB8B5D01D60F90DE` (`increment_id`,`order_increment_id`,`billing_name`,`billing_address`,`shipping_address`,`customer_name`,`customer_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Invoice Grid';

--
-- Dumping data for table `sales_invoice_grid`
--


--
-- Table structure for table `sales_invoice_item`
--

CREATE TABLE `sales_invoice_item` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `base_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Price',
  `tax_amount` decimal(12,4) DEFAULT NULL COMMENT 'Tax Amount',
  `base_row_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Row Total',
  `discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Discount Amount',
  `row_total` decimal(20,4) DEFAULT NULL COMMENT 'Row Total',
  `base_discount_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Discount Amount',
  `price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Price Incl Tax',
  `base_tax_amount` decimal(12,4) DEFAULT NULL COMMENT 'Base Tax Amount',
  `base_price_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
  `qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
  `base_cost` decimal(12,4) DEFAULT NULL COMMENT 'Base Cost',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
  `base_row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
  `row_total_incl_tax` decimal(12,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
  `product_id` int(11) DEFAULT NULL COMMENT 'Product ID',
  `order_item_id` int(11) DEFAULT NULL COMMENT 'Order Item ID',
  `additional_data` text DEFAULT NULL COMMENT 'Additional Data',
  `description` text DEFAULT NULL COMMENT 'Description',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `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',
  `tax_ratio` text DEFAULT NULL COMMENT 'Ratio of tax invoiced over tax of the order item',
  `weee_tax_applied` text DEFAULT NULL 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 (`entity_id`),
  KEY `SALES_INVOICE_ITEM_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_INVOICE_ITEM_PARENT_ID_SALES_INVOICE_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_invoice` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Invoice Item';

--
-- Dumping data for table `sales_invoice_item`
--


--
-- Table structure for table `sales_invoiced_aggregated`
--

CREATE TABLE `sales_invoiced_aggregated` (
  `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',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
  `orders_invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Orders Invoiced',
  `invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced',
  `invoiced_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Captured',
  `invoiced_not_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Not Captured',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_INVOICED_AGGREGATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_INVOICED_AGGREGATED_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_INVOICED_AGGREGATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Invoiced Aggregated';

--
-- Dumping data for table `sales_invoiced_aggregated`
--


--
-- Table structure for table `sales_invoiced_aggregated_order`
--

CREATE TABLE `sales_invoiced_aggregated_order` (
  `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',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
  `orders_invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Orders Invoiced',
  `invoiced` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced',
  `invoiced_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Captured',
  `invoiced_not_captured` decimal(12,4) DEFAULT NULL COMMENT 'Invoiced Not Captured',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_INVOICED_AGGREGATED_ORDER_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_INVOICED_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_INVOICED_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Invoiced Aggregated Order';

--
-- Dumping data for table `sales_invoiced_aggregated_order`
--


--
-- Table structure for table `sales_order_address`
--

CREATE TABLE `sales_order_address` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent ID',
  `customer_address_id` int(11) DEFAULT NULL COMMENT 'Customer Address ID',
  `quote_address_id` int(11) DEFAULT NULL COMMENT 'Quote Address ID',
  `region_id` int(11) DEFAULT NULL COMMENT 'Region ID',
  `customer_id` int(11) DEFAULT NULL COMMENT 'Customer ID',
  `fax` varchar(255) DEFAULT NULL COMMENT 'Fax',
  `region` varchar(255) DEFAULT NULL COMMENT 'Region',
  `postcode` varchar(255) DEFAULT NULL COMMENT 'Postcode',
  `lastname` varchar(255) DEFAULT NULL COMMENT 'Lastname',
  `street` varchar(255) DEFAULT NULL COMMENT 'Street',
  `city` varchar(255) DEFAULT NULL COMMENT 'City',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `telephone` varchar(255) DEFAULT NULL COMMENT 'Phone Number',
  `country_id` varchar(2) DEFAULT NULL COMMENT 'Country ID',
  `firstname` varchar(255) DEFAULT NULL COMMENT 'Firstname',
  `address_type` varchar(255) DEFAULT NULL COMMENT 'Address Type',
  `prefix` varchar(255) DEFAULT NULL COMMENT 'Prefix',
  `middlename` varchar(255) DEFAULT NULL COMMENT 'Middlename',
  `suffix` varchar(255) DEFAULT NULL COMMENT 'Suffix',
  `company` varchar(255) DEFAULT NULL COMMENT 'Company',
  `vat_id` text DEFAULT NULL COMMENT 'Vat ID',
  `vat_is_valid` smallint(6) DEFAULT NULL COMMENT 'Vat Is Valid',
  `vat_request_id` text DEFAULT NULL COMMENT 'Vat Request ID',
  `vat_request_date` text DEFAULT NULL COMMENT 'Vat Request Date',
  `vat_request_success` smallint(6) DEFAULT NULL COMMENT 'Vat Request Success',
  `vertex_vat_country_code` varchar(255) DEFAULT NULL COMMENT 'Vertex Customer Vat Country',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_ORDER_ADDRESS_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_ORDER_ADDRESS_PARENT_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Order Address';

--
-- Dumping data for table `sales_order_address`
--

INSERT INTO `sales_order_address` VALUES (1,1,NULL,68,NULL,NULL,NULL,'Select a region, state, or province.','0126546','li','aboe, ad, Hanoi\nad\nHanoi','Hanoi','dev_ly@gmail.com','+8412345678','VN','YoungLy','shipping',NULL,NULL,NULL,'a.com',NULL,NULL,NULL,NULL,NULL,NULL),(2,1,NULL,69,NULL,NULL,NULL,'Select a region, state, or province.','0126546','li','aboe, ad, Hanoi\nad\nHanoi','Hanoi','dev_ly@gmail.com','+8412345678','VN','YoungLy','billing',NULL,NULL,NULL,'a.com',NULL,NULL,NULL,NULL,NULL,NULL),(3,2,NULL,77,NULL,NULL,NULL,NULL,'0126546','li','aboe','Hanoi','bacgiang.us@gmail.com','+8412345678','UY','YoungLy','shipping',NULL,NULL,NULL,'a.com',NULL,NULL,NULL,NULL,NULL,NULL),(4,2,NULL,80,NULL,NULL,NULL,NULL,'0126546','li','aboe','Hanoi','bacgiang.us@gmail.com','+8412345678','UY','YoungLy','billing',NULL,NULL,NULL,'a.com',NULL,NULL,NULL,NULL,NULL,NULL),(5,3,NULL,88,NULL,NULL,NULL,'Hà Nội','100000','son','My Dinh','Ha Noi','sonpd66@gmail.com','0945606689','VN','John','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,3,NULL,89,NULL,NULL,NULL,'Hà Nội','100000','son','My Dinh','Ha Noi','sonpd66@gmail.com','0945606689','VN','John','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,4,NULL,97,NULL,NULL,NULL,'Select a region, state, or province.','0126546','li','aboe\nad\nHanoi','Hanoi','dev_ly@gmail.com','+8412345678','VN','YoungLy','shipping',NULL,NULL,NULL,'a.com',NULL,NULL,NULL,NULL,NULL,NULL),(8,4,NULL,100,NULL,NULL,NULL,'Select a region, state, or province.','0126546','li','aboe\nad\nHanoi','Hanoi','dev_ly@gmail.com','+8412345678','VN','YoungLy','billing',NULL,NULL,NULL,'a.com',NULL,NULL,NULL,NULL,NULL,NULL),(9,5,NULL,95,NULL,NULL,NULL,'Please select a region, state or province.','0126546','li','aboe','Hanoi','bacgiang.us@gmail.com','+8412345678','UY','YoungLy','shipping',NULL,NULL,NULL,'a.com',NULL,NULL,NULL,NULL,NULL,NULL),(10,5,NULL,119,NULL,NULL,NULL,'Please select a region, state or province.','0126546','li','aboe','Hanoi','bacgiang.us@gmail.com','+8412345678','UY','YoungLy','billing',NULL,NULL,NULL,'a.com',NULL,NULL,NULL,NULL,NULL,NULL),(11,6,NULL,123,NULL,NULL,NULL,'Select a region, state, or province.','0126546','li','aboe\nad\nHanoi','Hanoi','dev_ly@gmail.com','+8412345678','VN','YoungLy','shipping',NULL,NULL,NULL,'a.com',NULL,NULL,NULL,NULL,NULL,NULL),(12,6,NULL,124,NULL,NULL,NULL,'Select a region, state, or province.','0126546','li','aboe\nad\nHanoi','Hanoi','dev_ly@gmail.com','+8412345678','VN','YoungLy','billing',NULL,NULL,NULL,'a.com',NULL,NULL,NULL,NULL,NULL,NULL),(13,7,1,172,NULL,5,NULL,'Australian Capital Territory','2322212','nguyen','sfd\nds\ndsfs','dsfs','adminabc@gmail.com','232323','GB','huy','shipping',NULL,NULL,NULL,'ds',NULL,NULL,NULL,NULL,NULL,NULL),(14,7,1,173,NULL,5,NULL,'Australian Capital Territory','2322212','nguyen','sfd\nds\ndsfs','dsfs','adminabc@gmail.com','232323','GB','huy','billing',NULL,NULL,NULL,'ds',NULL,NULL,NULL,NULL,NULL,NULL),(15,8,2,183,NULL,NULL,NULL,NULL,'100000','Tran','6/16/250 Kim Giang, Dai Kim, Ha Noi','Ha Noi','ductran15601@gmail.com','0333434001','VN','Duc','shipping',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,8,2,184,NULL,NULL,NULL,NULL,'100000','Tran','6/16/250 Kim Giang, Dai Kim, Ha Noi','Ha Noi','ductran15601@gmail.com','0333434001','VN','Duc','billing',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,9,NULL,200,553,NULL,NULL,'Maharashtra','411021','Pratap','Magic furniture opp. Mahindra first choice\nBandhan','Pune','vishnupratap.vp@gmail.com','+919212121221','IN','Vishnu','shipping',NULL,NULL,NULL,'Hills',NULL,NULL,NULL,NULL,NULL,NULL),(18,9,NULL,201,553,NULL,NULL,'Maharashtra','411021','Pratap','Magic furniture opp. Mahindra first choice\nBandhan','Pune','vishnupratap.vp@gmail.com','+919212121221','IN','Vishnu','billing',NULL,NULL,NULL,'Hills',NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `sales_order_aggregated_created`
--

CREATE TABLE `sales_order_aggregated_created` (
  `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',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
  `total_qty_ordered` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Qty Ordered',
  `total_qty_invoiced` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Qty Invoiced',
  `total_income_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Income Amount',
  `total_revenue_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Revenue Amount',
  `total_profit_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Profit Amount',
  `total_invoiced_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Invoiced Amount',
  `total_canceled_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Canceled Amount',
  `total_paid_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Paid Amount',
  `total_refunded_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Refunded Amount',
  `total_tax_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Tax Amount',
  `total_tax_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Tax Amount Actual',
  `total_shipping_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Shipping Amount',
  `total_shipping_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Shipping Amount Actual',
  `total_discount_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Discount Amount',
  `total_discount_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Discount Amount Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_ORDER_AGGREGATED_CREATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_ORDER_AGGREGATED_CREATED_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_ORDER_AGGREGATED_CREATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Aggregated Created';

--
-- Dumping data for table `sales_order_aggregated_created`
--


--
-- Table structure for table `sales_order_aggregated_updated`
--

CREATE TABLE `sales_order_aggregated_updated` (
  `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',
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
  `total_qty_ordered` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Qty Ordered',
  `total_qty_invoiced` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Qty Invoiced',
  `total_income_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Income Amount',
  `total_revenue_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Revenue Amount',
  `total_profit_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Profit Amount',
  `total_invoiced_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Invoiced Amount',
  `total_canceled_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Canceled Amount',
  `total_paid_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Paid Amount',
  `total_refunded_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Refunded Amount',
  `total_tax_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Tax Amount',
  `total_tax_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Tax Amount Actual',
  `total_shipping_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Shipping Amount',
  `total_shipping_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Shipping Amount Actual',
  `total_discount_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Discount Amount',
  `total_discount_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Discount Amount Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_ORDER_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Aggregated Updated';

--
-- Dumping data for table `sales_order_aggregated_updated`
--


--
-- Table structure for table `sales_order_grid`
--

CREATE TABLE `sales_order_grid` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `status` varchar(32) DEFAULT NULL COMMENT 'Status',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `store_name` varchar(255) DEFAULT NULL COMMENT 'Store Name',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  `base_total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Paid',
  `grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
  `total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Total Paid',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  `order_currency_code` varchar(255) DEFAULT NULL COMMENT 'Order Currency Code',
  `shipping_name` varchar(255) DEFAULT NULL COMMENT 'Shipping Name',
  `billing_name` varchar(255) DEFAULT NULL COMMENT 'Billing Name',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
  `shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
  `shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
  `customer_email` varchar(255) DEFAULT NULL COMMENT 'Customer Email',
  `customer_group` varchar(255) DEFAULT NULL COMMENT 'Customer Group',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `shipping_and_handling` decimal(20,4) DEFAULT NULL COMMENT 'Shipping and handling amount',
  `customer_name` varchar(255) DEFAULT NULL COMMENT 'Customer Name',
  `payment_method` varchar(255) DEFAULT NULL COMMENT 'Payment Method',
  `total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Refunded',
  `pickup_location_code` varchar(255) DEFAULT NULL COMMENT 'Pickup Location Code',
  `customer_shipping_date` datetime DEFAULT NULL COMMENT 'Customer Shipping Delivery Date',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_ORDER_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_ORDER_GRID_STATUS` (`status`),
  KEY `SALES_ORDER_GRID_STORE_ID` (`store_id`),
  KEY `SALES_ORDER_GRID_BASE_GRAND_TOTAL` (`base_grand_total`),
  KEY `SALES_ORDER_GRID_BASE_TOTAL_PAID` (`base_total_paid`),
  KEY `SALES_ORDER_GRID_GRAND_TOTAL` (`grand_total`),
  KEY `SALES_ORDER_GRID_TOTAL_PAID` (`total_paid`),
  KEY `SALES_ORDER_GRID_SHIPPING_NAME` (`shipping_name`),
  KEY `SALES_ORDER_GRID_BILLING_NAME` (`billing_name`),
  KEY `SALES_ORDER_GRID_CREATED_AT` (`created_at`),
  KEY `SALES_ORDER_GRID_CUSTOMER_ID` (`customer_id`),
  KEY `SALES_ORDER_GRID_UPDATED_AT` (`updated_at`),
  KEY `SALES_ORDER_GRID_PICKUP_LOCATION_CODE` (`pickup_location_code`),
  FULLTEXT KEY `FTI_65B9E9925EC58F0C7C2E2F6379C233E7` (`increment_id`,`billing_name`,`shipping_name`,`shipping_address`,`billing_address`,`customer_name`,`customer_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Order Grid';

--
-- Dumping data for table `sales_order_grid`
--

INSERT INTO `sales_order_grid` VALUES (1,'pending',16,'sneaker\nsneaker\nEnglish 11',NULL,261.9800,NULL,261.9800,NULL,'16000000001','USD','USD','YoungLy li','YoungLy li','2021-01-11 07:04:58','2021-01-11 07:04:58','a.com,aboe, ad, Hanoi\nad\nHanoi,Hanoi,Select a region, state, or province.,0126546','a.com,aboe, ad, Hanoi\nad\nHanoi,Hanoi,Select a region, state, or province.,0126546','Flat Rate - Fixed','dev_ly@gmail.com','0',251.9800,10.0000,'YoungLy li','checkmo',NULL,NULL,NULL),(2,'pending',16,'sneaker\nsneaker\nEnglish 11',NULL,1341.9800,NULL,1341.9800,NULL,'16000000002','USD','USD','YoungLy li','YoungLy li','2021-01-13 03:00:24','2021-01-13 03:00:25','a.com,aboe,Hanoi,0126546','a.com,aboe,Hanoi,0126546','Flat Rate - Fixed','bacgiang.us@gmail.com','0',1281.9800,60.0000,'YoungLy li','checkmo',NULL,NULL,NULL),(3,'pending',1,'Main Website\nMain Website Store\nEnglish 1',NULL,343.0000,NULL,343.0000,NULL,'000000001','USD','USD','John son','John son','2021-01-14 07:45:09','2021-01-14 07:45:09','My Dinh,Ha Noi,Hà Nội,100000','My Dinh,Ha Noi,Hà Nội,100000','Flat Rate - Fixed','sonpd66@gmail.com','0',338.0000,5.0000,'John son','checkmo',NULL,NULL,NULL),(4,'pending',1,'Main Website\nMain Website Store\nEnglish 1',NULL,5118.0000,NULL,5118.0000,NULL,'000000002','USD','USD','YoungLy li','YoungLy li','2021-01-19 02:45:47','2021-01-19 02:45:47','a.com,aboe\nad\nHanoi,Hanoi,Select a region, state, or province.,0126546','a.com,aboe\nad\nHanoi,Hanoi,Select a region, state, or province.,0126546','Flat Rate - Fixed','dev_ly@gmail.com','0',5038.0000,80.0000,'YoungLy li','checkmo',NULL,NULL,NULL),(5,'pending',1,'Main Website\nMain Website Store\nEnglish 1',NULL,9350.0000,NULL,9350.0000,NULL,'000000003','USD','USD','YoungLy li','YoungLy li','2021-01-19 10:14:16','2021-01-19 10:14:16','a.com,aboe,Hanoi,Please select a region, state or province.,0126546','a.com,aboe,Hanoi,Please select a region, state or province.,0126546','Free Shipping - Free','bacgiang.us@gmail.com','0',9350.0000,0.0000,'YoungLy li','checkmo',NULL,NULL,'2021-01-23 17:13:00'),(6,'pending',1,'Main Website\nMain Website Store\nEnglish 1',NULL,189.0000,NULL,189.0000,NULL,'000000004','USD','USD','YoungLy li','YoungLy li','2021-01-20 02:36:14','2021-01-20 02:36:14','a.com,aboe\nad\nHanoi,Hanoi,Select a region, state, or province.,0126546','a.com,aboe\nad\nHanoi,Hanoi,Select a region, state, or province.,0126546','Free Shipping - Free','dev_ly@gmail.com','0',189.0000,0.0000,'YoungLy li','cashondelivery',NULL,NULL,NULL),(7,'pending',1,'Main Website\nMain Website Store\nEnglish 1',5,600.0000,NULL,600.0000,NULL,'000000005','USD','USD','huy nguyen','huy nguyen','2021-07-06 04:08:24','2021-07-06 04:08:24','ds,sfd\nds\ndsfs,dsfs,Australian Capital Territory,2322212','ds,sfd\nds\ndsfs,dsfs,Australian Capital Territory,2322212','Free Shipping - Free','adminabc@gmail.com','1',600.0000,0.0000,'huy nguyen','cashondelivery',NULL,NULL,NULL),(8,'pending',1,'Main Website\nMain Website Store\nEnglish 1',6,925.0000,NULL,925.0000,NULL,'000000006','USD','USD','Duc Tran','Duc Tran','2021-09-03 13:38:04','2021-09-03 13:38:04','6/16/250 Kim Giang, Dai Kim, Ha Noi,Ha Noi,100000','6/16/250 Kim Giang, Dai Kim, Ha Noi,Ha Noi,100000','Flat Rate - Fixed','ductran15601@gmail.com','1',900.0000,25.0000,'Duc Tran','cashondelivery',NULL,NULL,'2021-09-03 17:37:00'),(9,'pending',1,'Main Website\nMain Website Store\nEnglish 1',NULL,1010.0000,NULL,1010.0000,NULL,'000000007','USD','USD','Vishnu Pratap','Vishnu Pratap','2021-09-09 10:24:20','2021-09-09 10:24:20','Hills,Magic furniture opp. Mahindra first choice\nBandhan,Pune,Maharashtra,411021','Hills,Magic furniture opp. Mahindra first choice\nBandhan,Pune,Maharashtra,411021','Flat Rate - Fixed','vishnupratap.vp@gmail.com','0',1000.0000,10.0000,'Vishnu Pratap','cashondelivery',NULL,NULL,NULL);

--
-- Table structure for table `sales_order_item`
--

CREATE TABLE `sales_order_item` (
  `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Item ID',
  `order_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Order ID',
  `parent_item_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent Item ID',
  `quote_item_id` int(10) unsigned DEFAULT NULL COMMENT 'Quote Item ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
  `product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product ID',
  `product_type` varchar(255) DEFAULT NULL COMMENT 'Product Type',
  `product_options` text DEFAULT NULL COMMENT 'Product Options',
  `weight` decimal(12,4) DEFAULT 0.0000 COMMENT 'Weight',
  `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 DEFAULT NULL COMMENT 'Description',
  `applied_rule_ids` text DEFAULT NULL COMMENT 'Applied Rule Ids',
  `additional_data` text DEFAULT NULL COMMENT 'Additional Data',
  `is_qty_decimal` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Qty Decimal',
  `no_discount` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'No Discount',
  `qty_backordered` decimal(12,4) DEFAULT 0.0000 COMMENT 'Qty Backordered',
  `qty_canceled` decimal(12,4) DEFAULT 0.0000 COMMENT 'Qty Canceled',
  `qty_invoiced` decimal(12,4) DEFAULT 0.0000 COMMENT 'Qty Invoiced',
  `qty_ordered` decimal(12,4) DEFAULT 0.0000 COMMENT 'Qty Ordered',
  `qty_refunded` decimal(12,4) DEFAULT 0.0000 COMMENT 'Qty Refunded',
  `qty_shipped` decimal(12,4) DEFAULT 0.0000 COMMENT 'Qty Shipped',
  `base_cost` decimal(12,4) DEFAULT 0.0000 COMMENT 'Base Cost',
  `price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Price',
  `base_price` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Price',
  `original_price` decimal(12,4) DEFAULT NULL COMMENT 'Original Price',
  `base_original_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Original Price',
  `tax_percent` decimal(12,4) DEFAULT 0.0000 COMMENT 'Tax Percent',
  `tax_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Tax Amount',
  `base_tax_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Tax Amount',
  `tax_invoiced` decimal(20,4) DEFAULT 0.0000 COMMENT 'Tax Invoiced',
  `base_tax_invoiced` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Tax Invoiced',
  `discount_percent` decimal(12,4) DEFAULT 0.0000 COMMENT 'Discount Percent',
  `discount_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Discount Amount',
  `base_discount_amount` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Discount Amount',
  `discount_invoiced` decimal(20,4) DEFAULT 0.0000 COMMENT 'Discount Invoiced',
  `base_discount_invoiced` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Discount Invoiced',
  `amount_refunded` decimal(20,4) DEFAULT 0.0000 COMMENT 'Amount Refunded',
  `base_amount_refunded` decimal(20,4) DEFAULT 0.0000 COMMENT 'Base Amount Refunded',
  `row_total` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Row Total',
  `base_row_total` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Row Total',
  `row_invoiced` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Row Invoiced',
  `base_row_invoiced` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Base Row Invoiced',
  `row_weight` decimal(12,4) DEFAULT 0.0000 COMMENT 'Row Weight',
  `base_tax_before_discount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Before Discount',
  `tax_before_discount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Before Discount',
  `ext_order_item_id` varchar(255) DEFAULT NULL COMMENT 'Ext Order Item ID',
  `locked_do_invoice` smallint(5) unsigned DEFAULT NULL COMMENT 'Locked Do Invoice',
  `locked_do_ship` smallint(5) unsigned DEFAULT NULL COMMENT 'Locked Do Ship',
  `price_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Price Incl Tax',
  `base_price_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Price Incl Tax',
  `row_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Row Total Incl Tax',
  `base_row_total_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Row Total Incl Tax',
  `discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Amount',
  `base_discount_tax_compensation_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Amount',
  `discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Invoiced',
  `base_discount_tax_compensation_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Invoiced',
  `discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Refunded',
  `base_discount_tax_compensation_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Tax Compensation Refunded',
  `tax_canceled` decimal(12,4) DEFAULT NULL COMMENT 'Tax Canceled',
  `discount_tax_compensation_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Discount Tax Compensation Canceled',
  `tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Tax Refunded',
  `base_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Refunded',
  `discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Refunded',
  `base_discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Refunded',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
  `gift_message_available` int(11) DEFAULT NULL COMMENT 'Gift Message Available',
  `free_shipping` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Free Shipping',
  `weee_tax_applied` text DEFAULT NULL 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 `SALES_ORDER_ITEM_ORDER_ID` (`order_id`),
  KEY `SALES_ORDER_ITEM_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_ORDER_ITEM_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_ORDER_ITEM_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Order Item';

--
-- Dumping data for table `sales_order_item`
--

INSERT INTO `sales_order_item` VALUES (1,1,NULL,57,16,'2021-01-11 07:04:58','2021-01-11 07:04:58',55,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjExL3Byb2R1Y3R0YWIvdGFiL3ZpZXcvdHlwZS8yL2xpbWl0LzEwL2ltZ1Qvc21hbGxfaW1hZ2UvaW1nVy8zMzAvaW1nSC80MjAvaW1nSG92ZXIvdGh1bWJuYWlsL3Byb2R1Y3RfbGlzdF9tb2RlL2dyaWQvbnVtYmVyX3Jvdy8xL3Byb2R1Y3RfbGlzdF9vcmRlci9wb3NpdGlvbi8,\",\"product\":\"55\",\"qty\":1}}',NULL,0,'Nike Lebron Witness','Nike Lebron Witness',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,2.0000,0.0000,0.0000,NULL,125.9900,125.9900,125.9900,125.9900,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,251.9800,251.9800,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,125.9900,125.9900,251.9800,251.9800,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,2,NULL,76,16,'2021-01-13 03:00:24','2021-01-13 03:00:24',51,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjExL3Byb2R1Y3R0YWIvdGFiL3ZpZXcvdHlwZS8xL2xpbWl0LzEwL2ltZ1Qvc21hbGxfaW1hZ2UvaW1nVy8zMzAvaW1nSC80MjAvaW1nSG92ZXIvdGh1bWJuYWlsL3Byb2R1Y3RfbGlzdF9tb2RlL2dyaWQvbnVtYmVyX3Jvdy8yL3Byb2R1Y3RfbGlzdF9vcmRlci9wb3NpdGlvbi8,\",\"product\":\"51\",\"qty\":1}}',NULL,0,'Hike Slip-On Flatform Sneakers','Hike Slip-On Flatform Sneakers',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,2.0000,0.0000,0.0000,166.9900,132.0000,132.0000,166.9900,166.9900,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,264.0000,264.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,132.0000,132.0000,264.0000,264.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,2,NULL,77,16,'2021-01-13 03:00:24','2021-01-13 03:00:24',56,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjExL3Byb2R1Y3R0YWIvdGFiL3ZpZXcvdHlwZS8yL2xpbWl0LzEwL2ltZ1Qvc21hbGxfaW1hZ2UvaW1nVy8zMzAvaW1nSC80MjAvaW1nSG92ZXIvdGh1bWJuYWlsL3Byb2R1Y3RfbGlzdF9tb2RlL2dyaWQvbnVtYmVyX3Jvdy8xL3Byb2R1Y3RfbGlzdF9vcmRlci9wb3NpdGlvbi8,\",\"product\":\"56\",\"qty\":1}}',NULL,0,'Nike Reposto Sneakers','Nike Reposto Sneakers',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,6.0000,0.0000,0.0000,144.0000,99.0000,99.0000,144.0000,144.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,594.0000,594.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,99.0000,99.0000,594.0000,594.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,2,NULL,78,16,'2021-01-13 03:00:24','2021-01-13 03:00:24',53,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjExL3Byb2R1Y3R0YWIvdGFiL3ZpZXcvdHlwZS8yL2xpbWl0LzEwL2ltZ1Qvc21hbGxfaW1hZ2UvaW1nVy8zMzAvaW1nSC80MjAvaW1nSG92ZXIvdGh1bWJuYWlsL3Byb2R1Y3RfbGlzdF9tb2RlL2dyaWQvbnVtYmVyX3Jvdy8xL3Byb2R1Y3RfbGlzdF9vcmRlci9wb3NpdGlvbi8,\",\"product\":\"53\",\"qty\":1}}',NULL,0,'Strength Slip-On Sneakers','Strength Slip-On Sneakers',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,2.0000,0.0000,0.0000,NULL,112.9900,112.9900,112.9900,112.9900,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,225.9800,225.9800,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,112.9900,112.9900,225.9800,225.9800,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,2,NULL,80,16,'2021-01-13 03:00:24','2021-01-13 03:00:24',44,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjExL3Byb2R1Y3R0YWIvdGFiL3ZpZXcvdHlwZS8yL2xpbWl0LzEwL2ltZ1Qvc21hbGxfaW1hZ2UvaW1nVy8zMzAvaW1nSC80MjAvaW1nSG92ZXIvdGh1bWJuYWlsL3Byb2R1Y3RfbGlzdF9tb2RlL2dyaWQvbnVtYmVyX3Jvdy8xL3Byb2R1Y3RfbGlzdF9vcmRlci9wb3NpdGlvbi8,\",\"product\":\"44\",\"qty\":1}}',0.0000,0,'Nike Air Max Motion 2 Sneakers','Nike Air Max Motion 2 Sneakers',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,2.0000,0.0000,0.0000,NULL,99.0000,99.0000,99.0000,99.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,198.0000,198.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,99.0000,99.0000,198.0000,198.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,3,NULL,93,1,'2021-01-14 07:45:09','2021-01-14 07:45:09',20,'configurable','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjEvY2F0YWxvZy9wcm9kdWN0L3ZpZXcvaWQvMjAvcXVpY2t2aWV3LzEv\",\"product\":\"20\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"20\",\"super_attribute\":{\"173\":\"16\",\"93\":\"5\"},\"qty\":\"1\"},\"attributes_info\":[{\"label\":\"Size\",\"value\":\"S\",\"option_id\":173,\"option_value\":\"16\"},{\"label\":\"Color\",\"value\":\"yellow\",\"option_id\":93,\"option_value\":\"5\"}],\"simple_name\":\"Ribbed sweater -S-yellow\",\"simple_sku\":\"HLCY710-S-yellow\",\"product_calculations\":1,\"shipment_type\":0}',NULL,1,'HLCY710-S-yellow','Ribbed sweater ',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,NULL,89.0000,89.0000,600.0000,600.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,89.0000,89.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,89.0000,89.0000,89.0000,89.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,3,6,94,1,'2021-01-14 07:45:09','2021-01-14 07:45:09',61,'virtual','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjEvY2F0YWxvZy9wcm9kdWN0L3ZpZXcvaWQvMjAvcXVpY2t2aWV3LzEv\",\"product\":\"20\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"20\",\"super_attribute\":{\"173\":\"16\",\"93\":\"5\"},\"qty\":\"1\"}}',NULL,1,'HLCY710-S-yellow','Ribbed sweater -S-yellow',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,NULL,0.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,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,3,NULL,95,1,'2021-01-14 07:45:09','2021-01-14 07:45:09',23,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjEvc2hvcC5odG1s\",\"product\":\"23\",\"qty\":1}}',NULL,0,'MH1996','Sarpaneva casserole',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,300.0000,249.0000,249.0000,300.0000,300.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,249.0000,249.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,249.0000,249.0000,249.0000,249.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,4,NULL,103,1,'2021-01-19 02:45:47','2021-01-19 02:45:47',24,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjEvc2hvcC5odG1sP3Byb2R1Y3RfbGlzdF9tb2RlPWxpc3Q,\",\"product\":\"24\",\"qty\":1}}',NULL,0,'ON1265','Marble wall clock',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,9.0000,0.0000,0.0000,NULL,300.0000,300.0000,300.0000,300.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,2700.0000,2700.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,300.0000,300.0000,2700.0000,2700.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,4,NULL,107,1,'2021-01-19 02:45:47','2021-01-19 02:45:47',4,'configurable','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjEvdGFibGUtdGVtcG9yYXJ5LWdsYXNzLmh0bWw,\",\"product\":\"4\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"4\",\"super_attribute\":{\"173\":\"15\"},\"qty\":\"1\"},\"attributes_info\":[{\"label\":\"Size\",\"value\":\"M\",\"option_id\":173,\"option_value\":\"15\"}],\"simple_name\":\"Grain pendant lamp                              -M\",\"simple_sku\":\"XD2408-M\",\"product_calculations\":1,\"shipment_type\":0}',NULL,1,'XD2408-M','Grain pendant lamp                              ',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,NULL,200.0000,200.0000,300.0000,300.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,200.0000,200.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,4,10,108,1,'2021-01-19 02:45:47','2021-01-19 02:45:47',59,'virtual','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjEvdGFibGUtdGVtcG9yYXJ5LWdsYXNzLmh0bWw,\",\"product\":\"4\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"4\",\"super_attribute\":{\"173\":\"15\"},\"qty\":\"1\"}}',NULL,1,'XD2408-M','Grain pendant lamp                              -M',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,NULL,0.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,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,4,NULL,109,1,'2021-01-19 02:45:47','2021-01-19 02:45:47',5,'simple','{\"info_buyRequest\":{\"qty\":1}}',NULL,0,'BC1963-pink',' Lune Pendant-pink',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,600.0000,400.0000,400.0000,600.0000,600.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,400.0000,400.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,400.0000,400.0000,400.0000,400.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,4,NULL,110,1,'2021-01-19 02:45:47','2021-01-19 02:45:47',16,'virtual','{\"info_buyRequest\":{\"qty\":1}}',NULL,1,'CT1974','Grand Prix™ chair',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,200.0000,150.0000,150.0000,200.0000,200.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,150.0000,150.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,150.0000,150.0000,150.0000,150.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,4,NULL,111,1,'2021-01-19 02:45:47','2021-01-19 02:45:47',17,'simple','{\"info_buyRequest\":{\"qty\":1}}',NULL,0,'BN1932','Flower vase',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,100.0000,200.0000,200.0000,600.0000,600.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,200.0000,200.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,4,NULL,112,1,'2021-01-19 02:45:47','2021-01-19 02:45:47',18,'simple','{\"info_buyRequest\":{\"qty\":1}}',NULL,0,'ON1999','Orbis vase',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,300.0000,189.0000,189.0000,300.0000,300.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,189.0000,189.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,189.0000,189.0000,189.0000,189.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,4,NULL,113,1,'2021-01-19 02:45:47','2021-01-19 02:45:47',19,'simple','{\"info_buyRequest\":{\"qty\":1}}',NULL,0,'EN1411','Tivoli Bazaar Vase',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,NULL,250.0000,250.0000,250.0000,250.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,250.0000,250.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,250.0000,250.0000,250.0000,250.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,4,NULL,114,1,'2021-01-19 02:45:47','2021-01-19 02:45:47',21,'simple','{\"info_buyRequest\":{\"qty\":1}}',NULL,0,'BN1933','Salt & Pepper',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,NULL,600.0000,600.0000,600.0000,600.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,600.0000,600.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,600.0000,600.0000,600.0000,600.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,4,NULL,115,1,'2021-01-19 02:45:47','2021-01-19 02:45:47',22,'simple','{\"info_buyRequest\":{\"qty\":1}}',NULL,0,'CH1977','Craft Salt and Pepper mill',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,NULL,100.0000,100.0000,300.0000,300.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,100.0000,100.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,4,NULL,116,1,'2021-01-19 02:45:47','2021-01-19 02:45:47',23,'simple','{\"info_buyRequest\":{\"qty\":1}}',NULL,0,'MH1996','Sarpaneva casserole',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,300.0000,249.0000,249.0000,300.0000,300.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,249.0000,249.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,249.0000,249.0000,249.0000,249.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,5,NULL,102,1,'2021-01-19 10:14:16','2021-01-19 10:14:16',16,'virtual','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjEvY2F0YWxvZy9wcm9kdWN0L3ZpZXcvaWQvMTYvcXVpY2t2aWV3LzEv\",\"product\":\"16\",\"selected_configurable_option\":\"\",\"related_product\":\"\",\"item\":\"16\",\"qty\":\"1\"}}',NULL,1,'CT1974','Grand Prix™ chair',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,7.0000,0.0000,0.0000,200.0000,150.0000,150.0000,200.0000,200.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,1050.0000,1050.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,150.0000,150.0000,1050.0000,1050.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,5,NULL,105,1,'2021-01-19 10:14:16','2021-01-19 10:14:16',17,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjEvcHJvZHVjdHRhYi90YWIvdmlldy90eXBlLzEvbGltaXQvMTAvaW1nVC90aHVtYm5haWwvaW1nVy8zNTAvaW1nSC80NDYvaW1nSG92ZXIvc3dhdGNoX2ltYWdlL3Byb2R1Y3RfbGlzdF9tb2RlL2dyaWQvbnVtYmVyX3Jvdy8yL3Byb2R1Y3RfbGlzdF9vcmRlci9wb3NpdGlvbi8,\",\"product\":\"17\",\"qty\":1}}',NULL,0,'BN1932','Flower vase',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,18.0000,0.0000,0.0000,100.0000,200.0000,200.0000,600.0000,600.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,3600.0000,3600.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,200.0000,200.0000,3600.0000,3600.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,5,NULL,117,1,'2021-01-19 10:14:16','2021-01-19 10:14:16',22,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjEvcHJvZHVjdHRhYi90YWIvdmlldy90eXBlLzEvbGltaXQvMTAvaW1nVC90aHVtYm5haWwvaW1nVy8zNTAvaW1nSC80NDYvaW1nSG92ZXIvc3dhdGNoX2ltYWdlL3Byb2R1Y3RfbGlzdF9tb2RlL2dyaWQvbnVtYmVyX3Jvdy8yL3Byb2R1Y3RfbGlzdF9vcmRlci9wb3NpdGlvbi8,\",\"product\":\"22\",\"qty\":1}}',NULL,0,'CH1977','Craft Salt and Pepper mill',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,NULL,100.0000,100.0000,300.0000,300.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,100.0000,100.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,5,NULL,121,1,'2021-01-19 10:14:16','2021-01-19 10:14:16',21,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjEvcHJvZHVjdHRhYi90YWIvdmlldy90eXBlLzIvbGltaXQvMTAvaW1nVC9zbWFsbF9pbWFnZS9pbWdXLzM1MC9pbWdILzQ0Ni9pbWdIb3Zlci90aHVtYm5haWwvcHJvZHVjdF9saXN0X21vZGUvZ3JpZC9udW1iZXJfcm93LzIvcHJvZHVjdF9saXN0X29yZGVyL3Bvc2l0aW9uLw,,\",\"product\":\"21\",\"qty\":1}}',NULL,0,'BN1933','Salt & Pepper',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,3.0000,0.0000,0.0000,NULL,600.0000,600.0000,600.0000,600.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,1800.0000,1800.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,600.0000,600.0000,1800.0000,1800.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,5,NULL,124,1,'2021-01-19 10:14:16','2021-01-19 10:14:16',5,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjEvcHJvZHVjdHRhYi90YWIvdmlldy90eXBlLzEvbGltaXQvMTAvaW1nVC90aHVtYm5haWwvaW1nVy8zNTAvaW1nSC80NDYvaW1nSG92ZXIvc3dhdGNoX2ltYWdlL3Byb2R1Y3RfbGlzdF9tb2RlL2dyaWQvbnVtYmVyX3Jvdy8yL3Byb2R1Y3RfbGlzdF9vcmRlci9wb3NpdGlvbi8,\",\"product\":\"5\",\"qty\":1}}',NULL,0,'BC1963-pink',' Lune Pendant-pink',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,7.0000,0.0000,0.0000,600.0000,400.0000,400.0000,600.0000,600.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,2800.0000,2800.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,400.0000,400.0000,2800.0000,2800.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,6,NULL,135,1,'2021-01-20 02:36:14','2021-01-20 02:36:14',18,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2JsdWVza3l0ZWNoY28ubmV0L2tvbGxlci9lbjEvc2hvcC5odG1s\",\"product\":\"18\",\"qty\":1}}',NULL,0,'ON1999','Orbis vase',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,300.0000,189.0000,189.0000,300.0000,300.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,189.0000,189.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,189.0000,189.0000,189.0000,189.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,7,NULL,181,1,'2021-07-06 04:08:24','2021-07-06 04:08:24',1,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2F6ZXhjaGFuZ2VjbHViLmNvbS9rb2xsZXIyNDIvZW4xL3Nob3AuaHRtbA,,\",\"product\":\"1\",\"qty\":1}}',NULL,0,'FU1259','360 S Carronade low floor lamp',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,6.0000,0.0000,0.0000,132.0000,100.0000,100.0000,109.0000,109.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,600.0000,600.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,100.0000,100.0000,600.0000,600.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,8,NULL,187,1,'2021-09-03 13:38:04','2021-09-03 13:38:04',1,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2F6ZXhjaGFuZ2VjbHViLmNvbS9rb2xsZXIyNDMvZW4xL3Nob3AuaHRtbA,,\",\"product\":\"1\",\"qty\":1}}',NULL,0,'FU1259','360 S Carronade low floor lamp',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,4.0000,0.0000,0.0000,132.0000,100.0000,100.0000,109.0000,109.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,400.0000,400.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,100.0000,100.0000,400.0000,400.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,8,NULL,188,1,'2021-09-03 13:38:04','2021-09-03 13:38:04',3,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2F6ZXhjaGFuZ2VjbHViLmNvbS9rb2xsZXIyNDMvZW4xL3Nob3AuaHRtbA,,\",\"product\":\"3\",\"qty\":1}}',NULL,0,'XQ 241289',' PH 5 Pendant Lamp Copper',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,1.0000,0.0000,0.0000,NULL,500.0000,500.0000,500.0000,500.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,500.0000,500.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,500.0000,500.0000,500.0000,500.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,9,NULL,198,1,'2021-09-09 10:24:20','2021-09-09 10:24:20',3,'simple','{\"info_buyRequest\":{\"uenc\":\"aHR0cDovL2F6ZXhjaGFuZ2VjbHViLmNvbS9rb2xsZXIyNDMvZW4xL3Nob3AuaHRtbA,,\",\"product\":\"3\",\"qty\":1}}',NULL,0,'XQ 241289',' PH 5 Pendant Lamp Copper',NULL,NULL,NULL,0,0,NULL,0.0000,0.0000,2.0000,0.0000,0.0000,NULL,500.0000,500.0000,500.0000,500.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,1000.0000,1000.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,NULL,500.0000,500.0000,1000.0000,1000.0000,0.0000,0.0000,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 `sales_order_status`
--

CREATE TABLE `sales_order_status` (
  `status` varchar(32) NOT NULL COMMENT 'Status',
  `label` varchar(128) NOT NULL COMMENT 'Label',
  PRIMARY KEY (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Status Table';

--
-- Dumping data for table `sales_order_status`
--

INSERT INTO `sales_order_status` VALUES ('canceled','Canceled'),('closed','Closed'),('complete','Complete'),('fraud','Suspected Fraud'),('holded','On Hold'),('payment_review','Payment Review'),('paypal_canceled_reversal','PayPal Canceled Reversal'),('paypal_reversed','PayPal Reversed'),('pending','Pending'),('pending_payment','Pending Payment'),('pending_paypal','Pending PayPal'),('processing','Processing');

--
-- Table structure for table `sales_order_status_history`
--

CREATE TABLE `sales_order_status_history` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `is_customer_notified` int(11) DEFAULT NULL COMMENT 'Is Customer Notified',
  `is_visible_on_front` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Visible On Front',
  `comment` text DEFAULT NULL COMMENT 'Comment',
  `status` varchar(32) DEFAULT NULL COMMENT 'Status',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `entity_name` varchar(32) DEFAULT NULL COMMENT 'Shows what entity history is bind to.',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_ORDER_STATUS_HISTORY_PARENT_ID` (`parent_id`),
  KEY `SALES_ORDER_STATUS_HISTORY_CREATED_AT` (`created_at`),
  CONSTRAINT `SALES_ORDER_STATUS_HISTORY_PARENT_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Order Status History';

--
-- Dumping data for table `sales_order_status_history`
--


--
-- Table structure for table `sales_order_status_label`
--

CREATE TABLE `sales_order_status_label` (
  `status` varchar(32) NOT NULL COMMENT 'Status',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `label` varchar(128) NOT NULL COMMENT 'Label',
  PRIMARY KEY (`status`,`store_id`),
  KEY `SALES_ORDER_STATUS_LABEL_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_ORDER_STATUS_LABEL_STATUS_SALES_ORDER_STATUS_STATUS` FOREIGN KEY (`status`) REFERENCES `sales_order_status` (`status`) ON DELETE CASCADE,
  CONSTRAINT `SALES_ORDER_STATUS_LABEL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Status Label Table';

--
-- Dumping data for table `sales_order_status_label`
--


--
-- Table structure for table `sales_order_status_state`
--

CREATE TABLE `sales_order_status_state` (
  `status` varchar(32) NOT NULL COMMENT 'Status',
  `state` varchar(32) NOT NULL COMMENT 'Label',
  `is_default` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Default',
  `visible_on_front` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Visible on front',
  PRIMARY KEY (`status`,`state`),
  CONSTRAINT `SALES_ORDER_STATUS_STATE_STATUS_SALES_ORDER_STATUS_STATUS` FOREIGN KEY (`status`) REFERENCES `sales_order_status` (`status`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Status Table';

--
-- Dumping data for table `sales_order_status_state`
--

INSERT INTO `sales_order_status_state` VALUES ('canceled','canceled',1,1),('closed','closed',1,1),('complete','complete',1,1),('fraud','payment_review',0,1),('fraud','processing',0,1),('holded','holded',1,1),('payment_review','payment_review',1,1),('pending','new',1,1),('pending_payment','pending_payment',1,0),('processing','processing',1,1);

--
-- Table structure for table `sales_order_tax`
--

CREATE TABLE `sales_order_tax` (
  `tax_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tax ID',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `code` varchar(255) DEFAULT NULL COMMENT 'Code',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `percent` decimal(12,4) DEFAULT NULL COMMENT 'Percent',
  `amount` decimal(20,4) DEFAULT NULL COMMENT 'Amount',
  `priority` int(11) NOT NULL COMMENT 'Priority',
  `position` int(11) NOT NULL COMMENT 'Position',
  `base_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount',
  `process` smallint(6) NOT NULL COMMENT 'Process',
  `base_real_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Real Amount',
  PRIMARY KEY (`tax_id`),
  KEY `SALES_ORDER_TAX_ORDER_ID_PRIORITY_POSITION` (`order_id`,`priority`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Tax Table';

--
-- Dumping data for table `sales_order_tax`
--


--
-- Table structure for table `sales_order_tax_item`
--

CREATE TABLE `sales_order_tax_item` (
  `tax_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tax Item ID',
  `tax_id` int(10) unsigned NOT NULL COMMENT 'Tax ID',
  `item_id` int(10) unsigned DEFAULT NULL COMMENT 'Item ID',
  `tax_percent` decimal(12,4) NOT NULL COMMENT 'Real Tax Percent For Item',
  `amount` decimal(20,4) NOT NULL COMMENT 'Tax amount for the item and tax rate',
  `base_amount` decimal(20,4) NOT NULL COMMENT 'Base tax amount for the item and tax rate',
  `real_amount` decimal(20,4) NOT NULL COMMENT 'Real tax amount for the item and tax rate',
  `real_base_amount` decimal(20,4) NOT NULL COMMENT 'Real base tax amount for the item and tax rate',
  `associated_item_id` int(10) unsigned DEFAULT NULL COMMENT 'Id of the associated item',
  `taxable_item_type` varchar(32) NOT NULL COMMENT 'Type of the taxable item',
  PRIMARY KEY (`tax_item_id`),
  UNIQUE KEY `SALES_ORDER_TAX_ITEM_TAX_ID_ITEM_ID` (`tax_id`,`item_id`),
  KEY `SALES_ORDER_TAX_ITEM_ASSOCIATED_ITEM_ID_SALES_ORDER_ITEM_ITEM_ID` (`associated_item_id`),
  KEY `SALES_ORDER_TAX_ITEM_ITEM_ID` (`item_id`),
  CONSTRAINT `SALES_ORDER_TAX_ITEM_ASSOCIATED_ITEM_ID_SALES_ORDER_ITEM_ITEM_ID` FOREIGN KEY (`associated_item_id`) REFERENCES `sales_order_item` (`item_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_ORDER_TAX_ITEM_ITEM_ID_SALES_ORDER_ITEM_ITEM_ID` FOREIGN KEY (`item_id`) REFERENCES `sales_order_item` (`item_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_ORDER_TAX_ITEM_TAX_ID_SALES_ORDER_TAX_TAX_ID` FOREIGN KEY (`tax_id`) REFERENCES `sales_order_tax` (`tax_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Order Tax Item';

--
