-- 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`
--

CREATE TABLE `sales_order` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `state` varchar(32) DEFAULT NULL COMMENT 'State',
  `status` varchar(32) DEFAULT NULL COMMENT 'Status',
  `coupon_code` varchar(255) DEFAULT NULL COMMENT 'Coupon Code',
  `protect_code` varchar(255) DEFAULT NULL COMMENT 'Protect Code',
  `shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
  `is_virtual` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Virtual',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `base_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Amount',
  `base_discount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Canceled',
  `base_discount_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Invoiced',
  `base_discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Discount Refunded',
  `base_grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Base Grand Total',
  `base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
  `base_shipping_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Canceled',
  `base_shipping_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Invoiced',
  `base_shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Refunded',
  `base_shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Amount',
  `base_shipping_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Tax Refunded',
  `base_subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal',
  `base_subtotal_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Canceled',
  `base_subtotal_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Invoiced',
  `base_subtotal_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Refunded',
  `base_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Amount',
  `base_tax_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Canceled',
  `base_tax_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Invoiced',
  `base_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Tax Refunded',
  `base_to_global_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Global Rate',
  `base_to_order_rate` decimal(20,4) DEFAULT NULL COMMENT 'Base To Order Rate',
  `base_total_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Canceled',
  `base_total_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Invoiced',
  `base_total_invoiced_cost` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Invoiced Cost',
  `base_total_offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Offline Refunded',
  `base_total_online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Online Refunded',
  `base_total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Paid',
  `base_total_qty_ordered` decimal(12,4) DEFAULT NULL COMMENT 'Base Total Qty Ordered',
  `base_total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Refunded',
  `discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Discount Amount',
  `discount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Discount Canceled',
  `discount_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Discount Invoiced',
  `discount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Discount Refunded',
  `grand_total` decimal(20,4) DEFAULT NULL COMMENT 'Grand Total',
  `shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
  `shipping_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Canceled',
  `shipping_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Invoiced',
  `shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Refunded',
  `shipping_tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Amount',
  `shipping_tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Tax Refunded',
  `store_to_base_rate` decimal(12,4) DEFAULT NULL COMMENT 'Store To Base Rate',
  `store_to_order_rate` decimal(12,4) DEFAULT NULL COMMENT 'Store To Order Rate',
  `subtotal` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal',
  `subtotal_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Canceled',
  `subtotal_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Invoiced',
  `subtotal_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Refunded',
  `tax_amount` decimal(20,4) DEFAULT NULL COMMENT 'Tax Amount',
  `tax_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Tax Canceled',
  `tax_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Tax Invoiced',
  `tax_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Tax Refunded',
  `total_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Total Canceled',
  `total_invoiced` decimal(20,4) DEFAULT NULL COMMENT 'Total Invoiced',
  `total_offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Offline Refunded',
  `total_online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Online Refunded',
  `total_paid` decimal(20,4) DEFAULT NULL COMMENT 'Total Paid',
  `total_qty_ordered` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty Ordered',
  `total_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Total Refunded',
  `can_ship_partially` smallint(5) unsigned DEFAULT NULL COMMENT 'Can Ship Partially',
  `can_ship_partially_item` smallint(5) unsigned DEFAULT NULL COMMENT 'Can Ship Partially Item',
  `customer_is_guest` smallint(5) unsigned DEFAULT NULL COMMENT 'Customer Is Guest',
  `customer_note_notify` smallint(5) unsigned DEFAULT NULL COMMENT 'Customer Note Notify',
  `billing_address_id` int(11) DEFAULT NULL COMMENT 'Billing Address ID',
  `customer_group_id` int(11) DEFAULT NULL,
  `edit_increment` int(11) DEFAULT NULL COMMENT 'Edit Increment',
  `email_sent` smallint(5) unsigned DEFAULT NULL COMMENT 'Email Sent',
  `send_email` smallint(5) unsigned DEFAULT NULL COMMENT 'Send Email',
  `forced_shipment_with_invoice` smallint(5) unsigned DEFAULT NULL COMMENT 'Forced Do Shipment With Invoice',
  `payment_auth_expiration` int(11) DEFAULT NULL COMMENT 'Payment Authorization Expiration',
  `quote_address_id` int(11) DEFAULT NULL COMMENT 'Quote Address ID',
  `quote_id` int(11) DEFAULT NULL COMMENT 'Quote ID',
  `shipping_address_id` int(11) DEFAULT NULL COMMENT 'Shipping Address ID',
  `adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Negative',
  `adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Adjustment Positive',
  `base_adjustment_negative` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment Negative',
  `base_adjustment_positive` decimal(20,4) DEFAULT NULL COMMENT 'Base Adjustment Positive',
  `base_shipping_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Discount Amount',
  `base_subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Base Subtotal Incl Tax',
  `base_total_due` decimal(20,4) DEFAULT NULL COMMENT 'Base Total Due',
  `payment_authorization_amount` decimal(20,4) DEFAULT NULL COMMENT 'Payment Authorization Amount',
  `shipping_discount_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Discount Amount',
  `subtotal_incl_tax` decimal(20,4) DEFAULT NULL COMMENT 'Subtotal Incl Tax',
  `total_due` decimal(20,4) DEFAULT NULL COMMENT 'Total Due',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
  `customer_dob` datetime DEFAULT NULL COMMENT 'Customer Dob',
  `increment_id` varchar(32) DEFAULT NULL COMMENT 'Increment ID',
  `applied_rule_ids` varchar(128) DEFAULT NULL COMMENT 'Applied Rule Ids',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  `customer_email` varchar(128) DEFAULT NULL COMMENT 'Customer Email',
  `customer_firstname` varchar(128) DEFAULT NULL COMMENT 'Customer Firstname',
  `customer_lastname` varchar(128) DEFAULT NULL COMMENT 'Customer Lastname',
  `customer_middlename` varchar(128) DEFAULT NULL COMMENT 'Customer Middlename',
  `customer_prefix` varchar(32) DEFAULT NULL COMMENT 'Customer Prefix',
  `customer_suffix` varchar(32) DEFAULT NULL COMMENT 'Customer Suffix',
  `customer_taxvat` varchar(32) DEFAULT NULL COMMENT 'Customer Taxvat',
  `discount_description` varchar(255) DEFAULT NULL COMMENT 'Discount Description',
  `ext_customer_id` varchar(32) DEFAULT NULL COMMENT 'Ext Customer ID',
  `ext_order_id` varchar(32) DEFAULT NULL COMMENT 'Ext Order ID',
  `global_currency_code` varchar(3) DEFAULT NULL COMMENT 'Global Currency Code',
  `hold_before_state` varchar(32) DEFAULT NULL COMMENT 'Hold Before State',
  `hold_before_status` varchar(32) DEFAULT NULL COMMENT 'Hold Before Status',
  `order_currency_code` varchar(3) DEFAULT NULL COMMENT 'Order Currency Code',
  `original_increment_id` varchar(32) DEFAULT NULL COMMENT 'Original Increment ID',
  `relation_child_id` varchar(32) DEFAULT NULL COMMENT 'Relation Child ID',
  `relation_child_real_id` varchar(32) DEFAULT NULL COMMENT 'Relation Child Real ID',
  `relation_parent_id` varchar(32) DEFAULT NULL COMMENT 'Relation Parent ID',
  `relation_parent_real_id` varchar(32) DEFAULT NULL COMMENT 'Relation Parent Real ID',
  `remote_ip` varchar(45) DEFAULT NULL COMMENT 'Remote Ip',
  `shipping_method` varchar(120) DEFAULT NULL,
  `store_currency_code` varchar(3) DEFAULT NULL COMMENT 'Store Currency Code',
  `store_name` varchar(255) DEFAULT NULL COMMENT 'Store Name',
  `x_forwarded_for` varchar(255) DEFAULT NULL COMMENT 'X Forwarded For',
  `customer_note` text DEFAULT NULL COMMENT 'Customer Note',
  `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',
  `total_item_count` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Total Item Count',
  `customer_gender` int(11) DEFAULT NULL COMMENT 'Customer Gender',
  `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',
  `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',
  `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',
  `coupon_rule_name` varchar(255) DEFAULT NULL COMMENT 'Coupon Sales Rule Name',
  `gift_message_id` int(11) DEFAULT NULL COMMENT 'Gift Message ID',
  `paypal_ipn_customer_notified` int(11) DEFAULT 0 COMMENT 'Paypal Ipn Customer Notified',
  `customer_shipping_date` datetime DEFAULT NULL COMMENT 'Customer Shipping Delivery Date',
  `customer_shipping_comments` text DEFAULT NULL COMMENT 'Customer Shipping Delivery Comment',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_ORDER_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_ORDER_STATUS` (`status`),
  KEY `SALES_ORDER_STATE` (`state`),
  KEY `SALES_ORDER_STORE_ID` (`store_id`),
  KEY `SALES_ORDER_CREATED_AT` (`created_at`),
  KEY `SALES_ORDER_CUSTOMER_ID` (`customer_id`),
  KEY `SALES_ORDER_EXT_ORDER_ID` (`ext_order_id`),
  KEY `SALES_ORDER_QUOTE_ID` (`quote_id`),
  KEY `SALES_ORDER_UPDATED_AT` (`updated_at`),
  KEY `SALES_ORDER_SEND_EMAIL` (`send_email`),
  KEY `SALES_ORDER_EMAIL_SENT` (`email_sent`),
  CONSTRAINT `SALES_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL,
  CONSTRAINT `SALES_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Order';

--
-- Dumping data for table `sales_order`
--

INSERT INTO `sales_order` VALUES (1,'new','pending',NULL,'f066e0f77e3e1395980ebff83a1dbe04','Flat Rate - Fixed',0,16,NULL,0.0000,NULL,NULL,NULL,261.9800,10.0000,NULL,NULL,NULL,0.0000,NULL,251.9800,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,1.0000,1.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,261.9800,10.0000,NULL,NULL,NULL,0.0000,NULL,0.0000,0.0000,251.9800,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2.0000,NULL,NULL,NULL,1,1,2,0,NULL,1,1,NULL,NULL,NULL,33,1,NULL,NULL,NULL,NULL,0.0000,251.9800,261.9800,NULL,0.0000,251.9800,261.9800,0.0000,NULL,'16000000001',NULL,'USD','dev_ly@gmail.com','YoungLy','li',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'USD',NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL,'123.24.136.104','flatrate_flatrate','USD','sneaker\nsneaker\nEnglish 11',NULL,NULL,'2021-01-11 07:04:58','2021-01-11 07:05:01',1,NULL,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,10.0000,10.0000,NULL,NULL,0,NULL,NULL),(2,'new','pending',NULL,'7838622af6e4af94b54137cd592c99a9','Flat Rate - Fixed',0,16,NULL,0.0000,NULL,NULL,NULL,1341.9800,60.0000,NULL,NULL,NULL,0.0000,NULL,1281.9800,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,1.0000,1.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,1341.9800,60.0000,NULL,NULL,NULL,0.0000,NULL,0.0000,0.0000,1281.9800,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12.0000,NULL,NULL,NULL,1,1,4,0,NULL,1,1,NULL,NULL,NULL,37,3,NULL,NULL,NULL,NULL,0.0000,1281.9800,1341.9800,NULL,0.0000,1281.9800,1341.9800,0.0000,NULL,'16000000002',NULL,'USD','bacgiang.us@gmail.com','YoungLy','li',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'USD',NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL,'123.24.136.104','flatrate_flatrate','USD','sneaker\nsneaker\nEnglish 11',NULL,NULL,'2021-01-13 03:00:24','2021-01-13 03:00:28',4,NULL,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,60.0000,60.0000,NULL,NULL,0,NULL,NULL),(3,'new','pending',NULL,'f09a2ae623019b5a0001250f53114880','Flat Rate - Fixed',0,1,NULL,0.0000,NULL,NULL,NULL,343.0000,5.0000,NULL,NULL,NULL,0.0000,NULL,338.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,1.0000,1.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,343.0000,5.0000,NULL,NULL,NULL,0.0000,NULL,0.0000,0.0000,338.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2.0000,NULL,NULL,NULL,1,1,6,0,NULL,1,1,NULL,NULL,NULL,42,5,NULL,NULL,NULL,NULL,0.0000,338.0000,343.0000,NULL,0.0000,338.0000,343.0000,0.0000,NULL,'000000001',NULL,'USD','sonpd66@gmail.com','John','son',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'USD',NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL,'123.24.136.104','flatrate_flatrate','USD','Main Website\nMain Website Store\nEnglish 1',NULL,NULL,'2021-01-14 07:45:09','2021-01-14 07:45:14',2,NULL,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,5.0000,5.0000,NULL,NULL,0,NULL,NULL),(4,'new','pending',NULL,'36f2dec15a2351cd5ffd1d360f7aa474','Flat Rate - Fixed',0,1,NULL,0.0000,NULL,NULL,NULL,5118.0000,80.0000,NULL,NULL,NULL,0.0000,NULL,5038.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,1.0000,1.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,5118.0000,80.0000,NULL,NULL,NULL,0.0000,NULL,0.0000,0.0000,5038.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18.0000,NULL,NULL,NULL,1,1,8,0,NULL,1,1,NULL,NULL,NULL,46,7,NULL,NULL,NULL,NULL,0.0000,5038.0000,5118.0000,NULL,0.0000,5038.0000,5118.0000,0.0000,NULL,'000000002',NULL,'USD','dev_ly@gmail.com','YoungLy','li',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'USD',NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL,'123.24.136.104','flatrate_flatrate','USD','Main Website\nMain Website Store\nEnglish 1',NULL,NULL,'2021-01-19 02:45:47','2021-01-19 02:45:53',10,NULL,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,80.0000,80.0000,NULL,NULL,0,NULL,NULL),(5,'new','pending',NULL,'15d959ed5e8625467dd2fcc7910a59b1','Free Shipping - Free',0,1,NULL,0.0000,NULL,NULL,NULL,9350.0000,0.0000,NULL,NULL,NULL,0.0000,NULL,9350.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,1.0000,1.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,9350.0000,0.0000,NULL,NULL,NULL,0.0000,NULL,0.0000,0.0000,9350.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,36.0000,NULL,NULL,NULL,1,1,10,0,NULL,1,1,NULL,NULL,NULL,45,9,NULL,NULL,NULL,NULL,0.0000,9350.0000,9350.0000,NULL,0.0000,9350.0000,9350.0000,0.0000,NULL,'000000003',NULL,'USD','bacgiang.us@gmail.com','YoungLy','li',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'USD',NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL,'171.254.9.23','freeshipping_freeshipping','USD','Main Website\nMain Website Store\nEnglish 1',NULL,NULL,'2021-01-19 10:14:16','2021-01-19 10:14:21',5,NULL,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,0.0000,0.0000,NULL,NULL,0,'2021-01-23 17:13:00','asa'),(6,'new','pending',NULL,'4c9469c7531436203e74da6621f92d07','Free Shipping - Free',0,1,NULL,0.0000,NULL,NULL,NULL,189.0000,0.0000,NULL,NULL,NULL,0.0000,NULL,189.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,1.0000,1.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,189.0000,0.0000,NULL,NULL,NULL,0.0000,NULL,0.0000,0.0000,189.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.0000,NULL,NULL,NULL,1,1,12,0,NULL,1,1,NULL,NULL,NULL,58,11,NULL,NULL,NULL,NULL,0.0000,189.0000,189.0000,NULL,0.0000,189.0000,189.0000,0.0000,NULL,'000000004',NULL,'USD','dev_ly@gmail.com','YoungLy','li',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'USD',NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL,'123.24.136.104','freeshipping_freeshipping','USD','Main Website\nMain Website Store\nEnglish 1',NULL,NULL,'2021-01-20 02:36:14','2021-01-20 02:36:17',1,NULL,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,0.0000,0.0000,NULL,NULL,0,NULL,NULL),(7,'new','pending',NULL,'c65009dcce2e13ace9571288eaa1725f','Free Shipping - Free',0,1,5,0.0000,NULL,NULL,NULL,600.0000,0.0000,NULL,NULL,NULL,0.0000,NULL,600.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,1.0000,1.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,600.0000,0.0000,NULL,NULL,NULL,0.0000,NULL,0.0000,0.0000,600.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6.0000,NULL,NULL,NULL,0,1,14,1,NULL,1,1,NULL,NULL,NULL,81,13,NULL,NULL,NULL,NULL,0.0000,600.0000,600.0000,NULL,0.0000,600.0000,600.0000,0.0000,NULL,'000000005',NULL,'USD','adminabc@gmail.com','huy','nguyen',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'USD',NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL,'127.0.0.1','freeshipping_freeshipping','USD','Main Website\nMain Website Store\nEnglish 1','113.190.208.219',NULL,'2021-07-06 04:08:24','2021-07-06 04:08:26',1,NULL,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,0.0000,0.0000,NULL,NULL,0,NULL,NULL),(8,'new','pending',NULL,'546c55a8fdbc8c0d5e20cb8f5ba40385','Flat Rate - Fixed',0,1,6,0.0000,NULL,NULL,NULL,925.0000,25.0000,NULL,NULL,NULL,0.0000,NULL,900.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,1.0000,1.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,925.0000,25.0000,NULL,NULL,NULL,0.0000,NULL,0.0000,0.0000,900.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5.0000,NULL,NULL,NULL,0,1,16,1,NULL,NULL,1,NULL,NULL,NULL,85,15,NULL,NULL,NULL,NULL,0.0000,900.0000,925.0000,NULL,0.0000,900.0000,925.0000,0.0000,NULL,'000000006',NULL,'USD','ductran15601@gmail.com','Duc','Tran',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'USD',NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL,'117.0.201.230','flatrate_flatrate','USD','Main Website\nMain Website Store\nEnglish 1',NULL,NULL,'2021-09-03 13:38:04','2021-09-03 13:38:07',2,NULL,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,25.0000,25.0000,NULL,NULL,0,'2021-09-03 17:37:00',NULL),(9,'new','pending',NULL,'5172713a49048adc3345da333cde0d24','Flat Rate - Fixed',0,1,NULL,0.0000,NULL,NULL,NULL,1010.0000,10.0000,NULL,NULL,NULL,0.0000,NULL,1000.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,1.0000,1.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,1010.0000,10.0000,NULL,NULL,NULL,0.0000,NULL,0.0000,0.0000,1000.0000,NULL,NULL,NULL,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2.0000,NULL,NULL,NULL,1,1,18,0,NULL,NULL,1,NULL,NULL,NULL,92,17,NULL,NULL,NULL,NULL,0.0000,1000.0000,1010.0000,NULL,0.0000,1000.0000,1010.0000,0.0000,NULL,'000000007',NULL,'USD','vishnupratap.vp@gmail.com','Vishnu','Pratap',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'USD',NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL,'49.36.97.46','flatrate_flatrate','USD','Main Website\nMain Website Store\nEnglish 1',NULL,NULL,'2021-09-09 10:24:20','2021-09-09 10:24:24',1,NULL,0.0000,0.0000,0.0000,0.0000,NULL,NULL,NULL,NULL,10.0000,10.0000,NULL,NULL,0,NULL,NULL);

--
-- 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_payment`
--

CREATE TABLE `sales_order_payment` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `base_shipping_captured` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Captured',
  `shipping_captured` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Captured',
  `amount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Amount Refunded',
  `base_amount_paid` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Paid',
  `amount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Amount Canceled',
  `base_amount_authorized` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Authorized',
  `base_amount_paid_online` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Paid Online',
  `base_amount_refunded_online` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Refunded Online',
  `base_shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Amount',
  `shipping_amount` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Amount',
  `amount_paid` decimal(20,4) DEFAULT NULL COMMENT 'Amount Paid',
  `amount_authorized` decimal(20,4) DEFAULT NULL COMMENT 'Amount Authorized',
  `base_amount_ordered` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Ordered',
  `base_shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Shipping Refunded',
  `shipping_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Shipping Refunded',
  `base_amount_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Refunded',
  `amount_ordered` decimal(20,4) DEFAULT NULL COMMENT 'Amount Ordered',
  `base_amount_canceled` decimal(20,4) DEFAULT NULL COMMENT 'Base Amount Canceled',
  `quote_payment_id` int(11) DEFAULT NULL COMMENT 'Quote Payment ID',
  `additional_data` text DEFAULT NULL COMMENT 'Additional Data',
  `cc_exp_month` varchar(12) DEFAULT NULL COMMENT 'Cc Exp Month',
  `cc_ss_start_year` varchar(12) DEFAULT NULL COMMENT 'Cc Ss Start Year',
  `echeck_bank_name` varchar(128) DEFAULT NULL COMMENT 'Echeck Bank Name',
  `method` varchar(128) DEFAULT NULL COMMENT 'Method',
  `cc_debug_request_body` varchar(32) DEFAULT NULL COMMENT 'Cc Debug Request Body',
  `cc_secure_verify` varchar(32) DEFAULT NULL COMMENT 'Cc Secure Verify',
  `protection_eligibility` varchar(32) DEFAULT NULL COMMENT 'Protection Eligibility',
  `cc_approval` varchar(32) DEFAULT NULL COMMENT 'Cc Approval',
  `cc_last_4` varchar(100) DEFAULT NULL COMMENT 'Cc Last 4',
  `cc_status_description` varchar(32) DEFAULT NULL COMMENT 'Cc Status Description',
  `echeck_type` varchar(32) DEFAULT NULL COMMENT 'Echeck Type',
  `cc_debug_response_serialized` varchar(32) DEFAULT NULL COMMENT 'Cc Debug Response Serialized',
  `cc_ss_start_month` varchar(128) DEFAULT NULL COMMENT 'Cc Ss Start Month',
  `echeck_account_type` varchar(255) DEFAULT NULL COMMENT 'Echeck Account Type',
  `last_trans_id` varchar(255) DEFAULT NULL COMMENT 'Last Trans ID',
  `cc_cid_status` varchar(32) DEFAULT NULL COMMENT 'Cc Cid Status',
  `cc_owner` varchar(128) DEFAULT NULL COMMENT 'Cc Owner',
  `cc_type` varchar(32) DEFAULT NULL COMMENT 'Cc Type',
  `po_number` varchar(32) DEFAULT NULL COMMENT 'Po Number',
  `cc_exp_year` varchar(4) DEFAULT NULL COMMENT 'Cc Exp Year',
  `cc_status` varchar(4) DEFAULT NULL COMMENT 'Cc Status',
  `echeck_routing_number` varchar(32) DEFAULT NULL COMMENT 'Echeck Routing Number',
  `account_status` varchar(32) DEFAULT NULL COMMENT 'Account Status',
  `anet_trans_method` varchar(32) DEFAULT NULL COMMENT 'Anet Trans Method',
  `cc_debug_response_body` varchar(32) DEFAULT NULL COMMENT 'Cc Debug Response Body',
  `cc_ss_issue` varchar(32) DEFAULT NULL COMMENT 'Cc Ss Issue',
  `echeck_account_name` varchar(32) DEFAULT NULL COMMENT 'Echeck Account Name',
  `cc_avs_status` varchar(32) DEFAULT NULL COMMENT 'Cc Avs Status',
  `cc_number_enc` varchar(128) DEFAULT NULL,
  `cc_trans_id` varchar(32) DEFAULT NULL COMMENT 'Cc Trans ID',
  `address_status` varchar(32) DEFAULT NULL COMMENT 'Address Status',
  `additional_information` text DEFAULT NULL COMMENT 'Additional Information',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_ORDER_PAYMENT_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_ORDER_PAYMENT_PARENT_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='Sales Flat Order Payment';

--
-- Dumping data for table `sales_order_payment`
--

INSERT INTO `sales_order_payment` VALUES (1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10.0000,10.0000,NULL,NULL,261.9800,NULL,NULL,NULL,261.9800,NULL,NULL,NULL,NULL,'0',NULL,'checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"method_title\":\"Check \\/ Money order\"}'),(2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,60.0000,60.0000,NULL,NULL,1341.9800,NULL,NULL,NULL,1341.9800,NULL,NULL,NULL,NULL,'0',NULL,'checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"method_title\":\"Check \\/ Money order\"}'),(3,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5.0000,5.0000,NULL,NULL,343.0000,NULL,NULL,NULL,343.0000,NULL,NULL,NULL,NULL,'0',NULL,'checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"method_title\":\"Check \\/ Money order\"}'),(4,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,80.0000,80.0000,NULL,NULL,5118.0000,NULL,NULL,NULL,5118.0000,NULL,NULL,NULL,NULL,'0',NULL,'checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"method_title\":\"Check \\/ Money order\"}'),(5,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,0.0000,NULL,NULL,9350.0000,NULL,NULL,NULL,9350.0000,NULL,NULL,NULL,NULL,'0',NULL,'checkmo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"method_title\":\"Check \\/ Money order\"}'),(6,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,0.0000,NULL,NULL,189.0000,NULL,NULL,NULL,189.0000,NULL,NULL,NULL,NULL,'0',NULL,'cashondelivery',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"method_title\":\"Cash On Delivery\",\"instructions\":null}'),(7,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0000,0.0000,NULL,NULL,600.0000,NULL,NULL,NULL,600.0000,NULL,NULL,NULL,NULL,NULL,NULL,'cashondelivery',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"method_title\":\"Cash On Delivery\",\"instructions\":null}'),(8,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,25.0000,25.0000,NULL,NULL,925.0000,NULL,NULL,NULL,925.0000,NULL,NULL,NULL,NULL,'0',NULL,'cashondelivery',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"method_title\":\"Cash On Delivery\",\"instructions\":null}'),(9,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10.0000,10.0000,NULL,NULL,1010.0000,NULL,NULL,NULL,1010.0000,NULL,NULL,NULL,NULL,NULL,NULL,'cashondelivery',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"method_title\":\"Cash On Delivery\",\"instructions\":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';

--
-- Dumping data for table `sales_order_tax_item`
--


--
-- Table structure for table `sales_payment_transaction`
--

CREATE TABLE `sales_payment_transaction` (
  `transaction_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Transaction ID',
  `parent_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent ID',
  `order_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Order ID',
  `payment_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Payment ID',
  `txn_id` varchar(100) DEFAULT NULL COMMENT 'Txn ID',
  `parent_txn_id` varchar(100) DEFAULT NULL COMMENT 'Parent Txn ID',
  `txn_type` varchar(15) DEFAULT NULL COMMENT 'Txn Type',
  `is_closed` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Is Closed',
  `additional_information` blob DEFAULT NULL COMMENT 'Additional Information',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  PRIMARY KEY (`transaction_id`),
  UNIQUE KEY `SALES_PAYMENT_TRANSACTION_ORDER_ID_PAYMENT_ID_TXN_ID` (`order_id`,`payment_id`,`txn_id`),
  KEY `SALES_PAYMENT_TRANSACTION_PARENT_ID` (`parent_id`),
  KEY `SALES_PAYMENT_TRANSACTION_PAYMENT_ID` (`payment_id`),
  CONSTRAINT `FK_B99FF1A06402D725EBDB0F3A7ECD47A2` FOREIGN KEY (`parent_id`) REFERENCES `sales_payment_transaction` (`transaction_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_PAYMENT_TRANSACTION_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_PAYMENT_TRANSACTION_PAYMENT_ID_SALES_ORDER_PAYMENT_ENTT_ID` FOREIGN KEY (`payment_id`) REFERENCES `sales_order_payment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Payment Transaction';

--
-- Dumping data for table `sales_payment_transaction`
--


--
-- Table structure for table `sales_refunded_aggregated`
--

CREATE TABLE `sales_refunded_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) NOT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
  `refunded` decimal(20,4) DEFAULT NULL COMMENT 'Refunded',
  `online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Online Refunded',
  `offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Offline Refunded',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_REFUNDED_AGGREGATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_REFUNDED_AGGREGATED_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_REFUNDED_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 Refunded Aggregated';

--
-- Dumping data for table `sales_refunded_aggregated`
--


--
-- Table structure for table `sales_refunded_aggregated_order`
--

CREATE TABLE `sales_refunded_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) DEFAULT NULL COMMENT 'Order Status',
  `orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
  `refunded` decimal(20,4) DEFAULT NULL COMMENT 'Refunded',
  `online_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Online Refunded',
  `offline_refunded` decimal(20,4) DEFAULT NULL COMMENT 'Offline Refunded',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_REFUNDED_AGGREGATED_ORDER_PERIOD_STORE_ID_ORDER_STATUS` (`period`,`store_id`,`order_status`),
  KEY `SALES_REFUNDED_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_REFUNDED_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 Refunded Aggregated Order';

--
-- Dumping data for table `sales_refunded_aggregated_order`
--


--
-- Table structure for table `sales_sequence_meta`
--

CREATE TABLE `sales_sequence_meta` (
  `meta_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `entity_type` varchar(32) NOT NULL COMMENT 'Prefix',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `sequence_table` varchar(64) NOT NULL COMMENT 'table for sequence',
  PRIMARY KEY (`meta_id`),
  UNIQUE KEY `SALES_SEQUENCE_META_ENTITY_TYPE_STORE_ID` (`entity_type`,`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COMMENT='sales_sequence_meta';

--
-- Dumping data for table `sales_sequence_meta`
--

INSERT INTO `sales_sequence_meta` VALUES (1,'order',0,'sequence_order_0'),(2,'invoice',0,'sequence_invoice_0'),(3,'creditmemo',0,'sequence_creditmemo_0'),(4,'shipment',0,'sequence_shipment_0'),(5,'order',1,'sequence_order_1'),(6,'invoice',1,'sequence_invoice_1'),(7,'creditmemo',1,'sequence_creditmemo_1'),(8,'shipment',1,'sequence_shipment_1'),(13,'order',3,'sequence_order_3'),(14,'invoice',3,'sequence_invoice_3'),(15,'creditmemo',3,'sequence_creditmemo_3'),(16,'shipment',3,'sequence_shipment_3'),(17,'order',4,'sequence_order_4'),(18,'invoice',4,'sequence_invoice_4'),(19,'creditmemo',4,'sequence_creditmemo_4'),(20,'shipment',4,'sequence_shipment_4'),(21,'order',5,'sequence_order_5'),(22,'invoice',5,'sequence_invoice_5'),(23,'creditmemo',5,'sequence_creditmemo_5'),(24,'shipment',5,'sequence_shipment_5'),(25,'order',6,'sequence_order_6'),(26,'invoice',6,'sequence_invoice_6'),(27,'creditmemo',6,'sequence_creditmemo_6'),(28,'shipment',6,'sequence_shipment_6'),(29,'order',7,'sequence_order_7'),(30,'invoice',7,'sequence_invoice_7'),(31,'creditmemo',7,'sequence_creditmemo_7'),(32,'shipment',7,'sequence_shipment_7'),(33,'order',8,'sequence_order_8'),(34,'invoice',8,'sequence_invoice_8'),(35,'creditmemo',8,'sequence_creditmemo_8'),(36,'shipment',8,'sequence_shipment_8'),(37,'order',9,'sequence_order_9'),(38,'invoice',9,'sequence_invoice_9'),(39,'creditmemo',9,'sequence_creditmemo_9'),(40,'shipment',9,'sequence_shipment_9'),(41,'order',10,'sequence_order_10'),(42,'invoice',10,'sequence_invoice_10'),(43,'creditmemo',10,'sequence_creditmemo_10'),(44,'shipment',10,'sequence_shipment_10'),(45,'order',11,'sequence_order_11'),(46,'invoice',11,'sequence_invoice_11'),(47,'creditmemo',11,'sequence_creditmemo_11'),(48,'shipment',11,'sequence_shipment_11'),(57,'order',14,'sequence_order_14'),(58,'invoice',14,'sequence_invoice_14'),(59,'creditmemo',14,'sequence_creditmemo_14'),(60,'shipment',14,'sequence_shipment_14'),(61,'order',15,'sequence_order_15'),(62,'invoice',15,'sequence_invoice_15'),(63,'creditmemo',15,'sequence_creditmemo_15'),(64,'shipment',15,'sequence_shipment_15'),(65,'order',16,'sequence_order_16'),(66,'invoice',16,'sequence_invoice_16'),(67,'creditmemo',16,'sequence_creditmemo_16'),(68,'shipment',16,'sequence_shipment_16'),(69,'order',17,'sequence_order_17'),(70,'invoice',17,'sequence_invoice_17'),(71,'creditmemo',17,'sequence_creditmemo_17'),(72,'shipment',17,'sequence_shipment_17');

--
-- Table structure for table `sales_sequence_profile`
--

CREATE TABLE `sales_sequence_profile` (
  `profile_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `meta_id` int(10) unsigned NOT NULL COMMENT 'Meta_id',
  `prefix` varchar(32) DEFAULT NULL COMMENT 'Prefix',
  `suffix` varchar(32) DEFAULT NULL COMMENT 'Suffix',
  `start_value` int(10) unsigned NOT NULL DEFAULT 1 COMMENT 'Start value for sequence',
  `step` int(10) unsigned NOT NULL DEFAULT 1 COMMENT 'Step for sequence',
  `max_value` int(10) unsigned NOT NULL COMMENT 'MaxValue for sequence',
  `warning_value` int(10) unsigned NOT NULL COMMENT 'WarningValue for sequence',
  `is_active` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'isActive flag',
  PRIMARY KEY (`profile_id`),
  UNIQUE KEY `SALES_SEQUENCE_PROFILE_META_ID_PREFIX_SUFFIX` (`meta_id`,`prefix`,`suffix`),
  CONSTRAINT `SALES_SEQUENCE_PROFILE_META_ID_SALES_SEQUENCE_META_META_ID` FOREIGN KEY (`meta_id`) REFERENCES `sales_sequence_meta` (`meta_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COMMENT='sales_sequence_profile';

--
-- Dumping data for table `sales_sequence_profile`
--

INSERT INTO `sales_sequence_profile` VALUES (1,1,NULL,NULL,1,1,4294967295,4294966295,1),(2,2,NULL,NULL,1,1,4294967295,4294966295,1),(3,3,NULL,NULL,1,1,4294967295,4294966295,1),(4,4,NULL,NULL,1,1,4294967295,4294966295,1),(5,5,NULL,NULL,1,1,4294967295,4294966295,1),(6,6,NULL,NULL,1,1,4294967295,4294966295,1),(7,7,NULL,NULL,1,1,4294967295,4294966295,1),(8,8,NULL,NULL,1,1,4294967295,4294966295,1),(13,13,'3',NULL,1,1,4294967295,4294966295,1),(14,14,'3',NULL,1,1,4294967295,4294966295,1),(15,15,'3',NULL,1,1,4294967295,4294966295,1),(16,16,'3',NULL,1,1,4294967295,4294966295,1),(17,17,'4',NULL,1,1,4294967295,4294966295,1),(18,18,'4',NULL,1,1,4294967295,4294966295,1),(19,19,'4',NULL,1,1,4294967295,4294966295,1),(20,20,'4',NULL,1,1,4294967295,4294966295,1),(21,21,'5',NULL,1,1,4294967295,4294966295,1),(22,22,'5',NULL,1,1,4294967295,4294966295,1),(23,23,'5',NULL,1,1,4294967295,4294966295,1),(24,24,'5',NULL,1,1,4294967295,4294966295,1),(25,25,'6',NULL,1,1,4294967295,4294966295,1),(26,26,'6',NULL,1,1,4294967295,4294966295,1),(27,27,'6',NULL,1,1,4294967295,4294966295,1),(28,28,'6',NULL,1,1,4294967295,4294966295,1),(29,29,'7',NULL,1,1,4294967295,4294966295,1),(30,30,'7',NULL,1,1,4294967295,4294966295,1),(31,31,'7',NULL,1,1,4294967295,4294966295,1),(32,32,'7',NULL,1,1,4294967295,4294966295,1),(33,33,'8',NULL,1,1,4294967295,4294966295,1),(34,34,'8',NULL,1,1,4294967295,4294966295,1),(35,35,'8',NULL,1,1,4294967295,4294966295,1),(36,36,'8',NULL,1,1,4294967295,4294966295,1),(37,37,'9',NULL,1,1,4294967295,4294966295,1),(38,38,'9',NULL,1,1,4294967295,4294966295,1),(39,39,'9',NULL,1,1,4294967295,4294966295,1),(40,40,'9',NULL,1,1,4294967295,4294966295,1),(41,41,'10',NULL,1,1,4294967295,4294966295,1),(42,42,'10',NULL,1,1,4294967295,4294966295,1),(43,43,'10',NULL,1,1,4294967295,4294966295,1),(44,44,'10',NULL,1,1,4294967295,4294966295,1),(45,45,'11',NULL,1,1,4294967295,4294966295,1),(46,46,'11',NULL,1,1,4294967295,4294966295,1),(47,47,'11',NULL,1,1,4294967295,4294966295,1),(48,48,'11',NULL,1,1,4294967295,4294966295,1),(57,57,'14',NULL,1,1,4294967295,4294966295,1),(58,58,'14',NULL,1,1,4294967295,4294966295,1),(59,59,'14',NULL,1,1,4294967295,4294966295,1),(60,60,'14',NULL,1,1,4294967295,4294966295,1),(61,61,'15',NULL,1,1,4294967295,4294966295,1),(62,62,'15',NULL,1,1,4294967295,4294966295,1),(63,63,'15',NULL,1,1,4294967295,4294966295,1),(64,64,'15',NULL,1,1,4294967295,4294966295,1),(65,65,'16',NULL,1,1,4294967295,4294966295,1),(66,66,'16',NULL,1,1,4294967295,4294966295,1),(67,67,'16',NULL,1,1,4294967295,4294966295,1),(68,68,'16',NULL,1,1,4294967295,4294966295,1),(69,69,'17',NULL,1,1,4294967295,4294966295,1),(70,70,'17',NULL,1,1,4294967295,4294966295,1),(71,71,'17',NULL,1,1,4294967295,4294966295,1),(72,72,'17',NULL,1,1,4294967295,4294966295,1);

--
-- Table structure for table `sales_shipment`
--

CREATE TABLE `sales_shipment` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `total_weight` decimal(12,4) DEFAULT NULL COMMENT 'Total Weight',
  `total_qty` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty',
  `email_sent` smallint(5) unsigned DEFAULT NULL COMMENT 'Email Sent',
  `send_email` smallint(5) unsigned DEFAULT NULL COMMENT 'Send Email',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `customer_id` int(11) DEFAULT NULL COMMENT 'Customer ID',
  `shipping_address_id` int(11) DEFAULT NULL COMMENT 'Shipping Address ID',
  `billing_address_id` int(11) DEFAULT NULL COMMENT 'Billing Address ID',
  `shipment_status` int(11) DEFAULT NULL COMMENT 'Shipment Status',
  `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',
  `packages` text DEFAULT NULL COMMENT 'Packed Products in Packages',
  `shipping_label` mediumblob DEFAULT NULL COMMENT 'Shipping Label Content',
  `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_SHIPMENT_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_SHIPMENT_STORE_ID` (`store_id`),
  KEY `SALES_SHIPMENT_TOTAL_QTY` (`total_qty`),
  KEY `SALES_SHIPMENT_ORDER_ID` (`order_id`),
  KEY `SALES_SHIPMENT_CREATED_AT` (`created_at`),
  KEY `SALES_SHIPMENT_UPDATED_AT` (`updated_at`),
  KEY `SALES_SHIPMENT_SEND_EMAIL` (`send_email`),
  KEY `SALES_SHIPMENT_EMAIL_SENT` (`email_sent`),
  CONSTRAINT `SALES_SHIPMENT_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `SALES_SHIPMENT_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 Shipment';

--
-- Dumping data for table `sales_shipment`
--


--
-- Table structure for table `sales_shipment_comment`
--

CREATE TABLE `sales_shipment_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_SHIPMENT_COMMENT_CREATED_AT` (`created_at`),
  KEY `SALES_SHIPMENT_COMMENT_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_SHIPMENT_COMMENT_PARENT_ID_SALES_SHIPMENT_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_shipment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Shipment Comment';

--
-- Dumping data for table `sales_shipment_comment`
--


--
-- Table structure for table `sales_shipment_grid`
--

CREATE TABLE `sales_shipment_grid` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_increment_id` varchar(32) NOT NULL COMMENT 'Order Increment ID',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `order_created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Order Increment ID',
  `customer_name` varchar(128) NOT NULL COMMENT 'Customer Name',
  `total_qty` decimal(12,4) DEFAULT NULL COMMENT 'Total Qty',
  `shipment_status` int(11) DEFAULT NULL COMMENT 'Shipment Status',
  `order_status` varchar(32) DEFAULT NULL COMMENT 'Order',
  `billing_address` varchar(255) DEFAULT NULL COMMENT 'Billing Address',
  `shipping_address` varchar(255) DEFAULT NULL COMMENT 'Shipping Address',
  `billing_name` varchar(128) DEFAULT NULL COMMENT 'Billing Name',
  `shipping_name` varchar(128) DEFAULT NULL COMMENT 'Shipping Name',
  `customer_email` varchar(128) DEFAULT NULL COMMENT 'Customer Email',
  `customer_group_id` int(11) DEFAULT NULL,
  `payment_method` varchar(32) DEFAULT NULL COMMENT 'Payment Method',
  `shipping_information` varchar(255) DEFAULT NULL COMMENT 'Shipping Method Name',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `SALES_SHIPMENT_GRID_INCREMENT_ID_STORE_ID` (`increment_id`,`store_id`),
  KEY `SALES_SHIPMENT_GRID_STORE_ID` (`store_id`),
  KEY `SALES_SHIPMENT_GRID_TOTAL_QTY` (`total_qty`),
  KEY `SALES_SHIPMENT_GRID_ORDER_INCREMENT_ID` (`order_increment_id`),
  KEY `SALES_SHIPMENT_GRID_SHIPMENT_STATUS` (`shipment_status`),
  KEY `SALES_SHIPMENT_GRID_ORDER_STATUS` (`order_status`),
  KEY `SALES_SHIPMENT_GRID_CREATED_AT` (`created_at`),
  KEY `SALES_SHIPMENT_GRID_UPDATED_AT` (`updated_at`),
  KEY `SALES_SHIPMENT_GRID_ORDER_CREATED_AT` (`order_created_at`),
  KEY `SALES_SHIPMENT_GRID_SHIPPING_NAME` (`shipping_name`),
  KEY `SALES_SHIPMENT_GRID_BILLING_NAME` (`billing_name`),
  KEY `SALES_SHIPMENT_GRID_ORDER_ID` (`order_id`),
  FULLTEXT KEY `FTI_086B40C8955F167B8EA76653437879B4` (`increment_id`,`order_increment_id`,`shipping_name`,`customer_name`,`customer_email`,`billing_address`,`shipping_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Shipment Grid';

--
-- Dumping data for table `sales_shipment_grid`
--


--
-- Table structure for table `sales_shipment_item`
--

CREATE TABLE `sales_shipment_item` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `row_total` decimal(20,4) DEFAULT NULL COMMENT 'Row Total',
  `price` decimal(20,4) DEFAULT NULL COMMENT 'Price',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
  `qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
  `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',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `sku` varchar(255) DEFAULT NULL COMMENT 'Sku',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_SHIPMENT_ITEM_PARENT_ID` (`parent_id`),
  CONSTRAINT `SALES_SHIPMENT_ITEM_PARENT_ID_SALES_SHIPMENT_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_shipment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Shipment Item';

--
-- Dumping data for table `sales_shipment_item`
--


--
-- Table structure for table `sales_shipment_track`
--

CREATE TABLE `sales_shipment_track` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
  `qty` decimal(12,4) DEFAULT NULL COMMENT 'Qty',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `track_number` text DEFAULT NULL COMMENT 'Number',
  `description` text DEFAULT NULL COMMENT 'Description',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `carrier_code` varchar(32) DEFAULT NULL COMMENT 'Carrier Code',
  `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',
  PRIMARY KEY (`entity_id`),
  KEY `SALES_SHIPMENT_TRACK_PARENT_ID` (`parent_id`),
  KEY `SALES_SHIPMENT_TRACK_ORDER_ID` (`order_id`),
  KEY `SALES_SHIPMENT_TRACK_CREATED_AT` (`created_at`),
  CONSTRAINT `SALES_SHIPMENT_TRACK_PARENT_ID_SALES_SHIPMENT_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `sales_shipment` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Flat Shipment Track';

--
-- Dumping data for table `sales_shipment_track`
--


--
-- Table structure for table `sales_shipping_aggregated`
--

CREATE TABLE `sales_shipping_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',
  `shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
  `orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
  `total_shipping` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping',
  `total_shipping_actual` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALES_SHPP_AGGRED_PERIOD_STORE_ID_ORDER_STS_SHPP_DESCRIPTION` (`period`,`store_id`,`order_status`,`shipping_description`),
  KEY `SALES_SHIPPING_AGGREGATED_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_SHIPPING_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 Shipping Aggregated';

--
-- Dumping data for table `sales_shipping_aggregated`
--


--
-- Table structure for table `sales_shipping_aggregated_order`
--

CREATE TABLE `sales_shipping_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) DEFAULT NULL COMMENT 'Order Status',
  `shipping_description` varchar(255) DEFAULT NULL COMMENT 'Shipping Description',
  `orders_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Orders Count',
  `total_shipping` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping',
  `total_shipping_actual` decimal(20,4) DEFAULT NULL COMMENT 'Total Shipping Actual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNQ_C05FAE47282EEA68654D0924E946761F` (`period`,`store_id`,`order_status`,`shipping_description`),
  KEY `SALES_SHIPPING_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  CONSTRAINT `SALES_SHIPPING_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 Shipping Aggregated Order';

--
-- Dumping data for table `sales_shipping_aggregated_order`
--


--
-- Table structure for table `salesrule`
--

CREATE TABLE `salesrule` (
  `rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text DEFAULT NULL COMMENT 'Description',
  `from_date` date DEFAULT NULL COMMENT 'From',
  `to_date` date DEFAULT NULL COMMENT 'To',
  `uses_per_customer` int(11) NOT NULL DEFAULT 0 COMMENT 'Uses Per Customer',
  `is_active` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Is Active',
  `conditions_serialized` mediumtext DEFAULT NULL COMMENT 'Conditions Serialized',
  `actions_serialized` mediumtext DEFAULT NULL COMMENT 'Actions Serialized',
  `stop_rules_processing` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Stop Rules Processing',
  `is_advanced` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Is Advanced',
  `product_ids` text DEFAULT NULL COMMENT 'Product Ids',
  `sort_order` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Sort Order',
  `simple_action` varchar(32) DEFAULT NULL COMMENT 'Simple Action',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount',
  `discount_qty` decimal(12,4) DEFAULT NULL COMMENT 'Discount Qty',
  `discount_step` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Discount Step',
  `apply_to_shipping` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Apply To Shipping',
  `times_used` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Times Used',
  `is_rss` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Is Rss',
  `coupon_type` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Coupon Type',
  `use_auto_generation` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Use Auto Generation',
  `uses_per_coupon` int(11) NOT NULL DEFAULT 0 COMMENT 'User Per Coupon',
  `simple_free_shipping` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Simple Free Shipping',
  PRIMARY KEY (`rule_id`),
  KEY `SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE` (`is_active`,`sort_order`,`to_date`,`from_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule';

--
-- Dumping data for table `salesrule`
--


--
-- Table structure for table `salesrule_coupon`
--

CREATE TABLE `salesrule_coupon` (
  `coupon_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Coupon ID',
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
  `code` varchar(255) DEFAULT NULL COMMENT 'Code',
  `usage_limit` int(10) unsigned DEFAULT NULL COMMENT 'Usage Limit',
  `usage_per_customer` int(10) unsigned DEFAULT NULL COMMENT 'Usage Per Customer',
  `times_used` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Times Used',
  `expiration_date` datetime DEFAULT NULL COMMENT 'Expiration Date',
  `is_primary` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Primary',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Coupon Code Creation Date',
  `type` smallint(6) DEFAULT 0 COMMENT 'Coupon Code Type',
  `generated_by_dotmailer` smallint(6) DEFAULT NULL COMMENT '1 = Generated by dotmailer',
  PRIMARY KEY (`coupon_id`),
  UNIQUE KEY `SALESRULE_COUPON_CODE` (`code`),
  UNIQUE KEY `SALESRULE_COUPON_RULE_ID_IS_PRIMARY` (`rule_id`,`is_primary`),
  KEY `SALESRULE_COUPON_RULE_ID` (`rule_id`),
  CONSTRAINT `SALESRULE_COUPON_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Coupon';

--
-- Dumping data for table `salesrule_coupon`
--


--
-- Table structure for table `salesrule_coupon_aggregated`
--

CREATE TABLE `salesrule_coupon_aggregated` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `coupon_code` varchar(50) DEFAULT NULL COMMENT 'Coupon Code',
  `coupon_uses` int(11) NOT NULL DEFAULT 0 COMMENT 'Coupon Uses',
  `subtotal_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Subtotal Amount',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount',
  `total_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Amount',
  `subtotal_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Subtotal Amount Actual',
  `discount_amount_actual` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount Actual',
  `total_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Amount Actual',
  `rule_name` varchar(255) DEFAULT NULL COMMENT 'Rule Name',
  PRIMARY KEY (`id`),
  UNIQUE KEY `SALESRULE_COUPON_AGGRED_PERIOD_STORE_ID_ORDER_STS_COUPON_CODE` (`period`,`store_id`,`order_status`,`coupon_code`),
  KEY `SALESRULE_COUPON_AGGREGATED_STORE_ID` (`store_id`),
  KEY `SALESRULE_COUPON_AGGREGATED_RULE_NAME` (`rule_name`),
  CONSTRAINT `SALESRULE_COUPON_AGGREGATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Coupon Aggregated';

--
-- Dumping data for table `salesrule_coupon_aggregated`
--


--
-- Table structure for table `salesrule_coupon_aggregated_order`
--

CREATE TABLE `salesrule_coupon_aggregated_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `coupon_code` varchar(50) DEFAULT NULL COMMENT 'Coupon Code',
  `coupon_uses` int(11) NOT NULL DEFAULT 0 COMMENT 'Coupon Uses',
  `subtotal_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Subtotal Amount',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount',
  `total_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Amount',
  `rule_name` varchar(255) DEFAULT NULL COMMENT 'Rule Name',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNQ_1094D1FBBCBB11704A29DEF3ACC37D2B` (`period`,`store_id`,`order_status`,`coupon_code`),
  KEY `SALESRULE_COUPON_AGGREGATED_ORDER_STORE_ID` (`store_id`),
  KEY `SALESRULE_COUPON_AGGREGATED_ORDER_RULE_NAME` (`rule_name`),
  CONSTRAINT `SALESRULE_COUPON_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Coupon Aggregated Order';

--
-- Dumping data for table `salesrule_coupon_aggregated_order`
--


--
-- Table structure for table `salesrule_coupon_aggregated_updated`
--

CREATE TABLE `salesrule_coupon_aggregated_updated` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `period` date NOT NULL COMMENT 'Period',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  `order_status` varchar(50) DEFAULT NULL COMMENT 'Order Status',
  `coupon_code` varchar(50) DEFAULT NULL COMMENT 'Coupon Code',
  `coupon_uses` int(11) NOT NULL DEFAULT 0 COMMENT 'Coupon Uses',
  `subtotal_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Subtotal Amount',
  `discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount',
  `total_amount` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Amount',
  `subtotal_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Subtotal Amount Actual',
  `discount_amount_actual` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT 'Discount Amount Actual',
  `total_amount_actual` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT 'Total Amount Actual',
  `rule_name` varchar(255) DEFAULT NULL COMMENT 'Rule Name',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNQ_7196FA120A4F0F84E1B66605E87E213E` (`period`,`store_id`,`order_status`,`coupon_code`),
  KEY `SALESRULE_COUPON_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
  KEY `SALESRULE_COUPON_AGGREGATED_UPDATED_RULE_NAME` (`rule_name`),
  CONSTRAINT `SALESRULE_COUPON_AGGREGATED_UPDATED_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Coupon Aggregated Updated';

--
-- Dumping data for table `salesrule_coupon_aggregated_updated`
--


--
-- Table structure for table `salesrule_coupon_usage`
--

CREATE TABLE `salesrule_coupon_usage` (
  `coupon_id` int(10) unsigned NOT NULL COMMENT 'Coupon ID',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  `times_used` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Times Used',
  PRIMARY KEY (`coupon_id`,`customer_id`),
  KEY `SALESRULE_COUPON_USAGE_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `SALESRULE_COUPON_USAGE_COUPON_ID_SALESRULE_COUPON_COUPON_ID` FOREIGN KEY (`coupon_id`) REFERENCES `salesrule_coupon` (`coupon_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_COUPON_USAGE_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Coupon Usage';

--
-- Dumping data for table `salesrule_coupon_usage`
--


--
-- Table structure for table `salesrule_customer`
--

CREATE TABLE `salesrule_customer` (
  `rule_customer_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule Customer ID',
  `rule_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Rule ID',
  `customer_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer ID',
  `times_used` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Times Used',
  PRIMARY KEY (`rule_customer_id`),
  KEY `SALESRULE_CUSTOMER_RULE_ID_CUSTOMER_ID` (`rule_id`,`customer_id`),
  KEY `SALESRULE_CUSTOMER_CUSTOMER_ID_RULE_ID` (`customer_id`,`rule_id`),
  CONSTRAINT `SALESRULE_CUSTOMER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_CUSTOMER_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Customer';

--
-- Dumping data for table `salesrule_customer`
--


--
-- Table structure for table `salesrule_customer_group`
--

CREATE TABLE `salesrule_customer_group` (
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
  `customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
  PRIMARY KEY (`rule_id`,`customer_group_id`),
  KEY `SALESRULE_CUSTOMER_GROUP_CUSTOMER_GROUP_ID` (`customer_group_id`),
  CONSTRAINT `SALESRULE_CSTR_GROUP_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_CUSTOMER_GROUP_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Rules To Customer Groups Relations';

--
-- Dumping data for table `salesrule_customer_group`
--


--
-- Table structure for table `salesrule_label`
--

CREATE TABLE `salesrule_label` (
  `label_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Label ID',
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `label` varchar(255) DEFAULT NULL COMMENT 'Label',
  PRIMARY KEY (`label_id`),
  UNIQUE KEY `SALESRULE_LABEL_RULE_ID_STORE_ID` (`rule_id`,`store_id`),
  KEY `SALESRULE_LABEL_STORE_ID` (`store_id`),
  CONSTRAINT `SALESRULE_LABEL_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_LABEL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Label';

--
-- Dumping data for table `salesrule_label`
--


--
-- Table structure for table `salesrule_product_attribute`
--

CREATE TABLE `salesrule_product_attribute` (
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  PRIMARY KEY (`rule_id`,`website_id`,`customer_group_id`,`attribute_id`),
  KEY `SALESRULE_PRODUCT_ATTRIBUTE_WEBSITE_ID` (`website_id`),
  KEY `SALESRULE_PRODUCT_ATTRIBUTE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `SALESRULE_PRODUCT_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `SALESRULE_PRD_ATTR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_PRD_ATTR_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_PRODUCT_ATTRIBUTE_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_PRODUCT_ATTRIBUTE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Salesrule Product Attribute';

--
-- Dumping data for table `salesrule_product_attribute`
--


--
-- Table structure for table `salesrule_website`
--

CREATE TABLE `salesrule_website` (
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  PRIMARY KEY (`rule_id`,`website_id`),
  KEY `SALESRULE_WEBSITE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `SALESRULE_WEBSITE_RULE_ID_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `salesrule` (`rule_id`) ON DELETE CASCADE,
  CONSTRAINT `SALESRULE_WEBSITE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Rules To Websites Relations';

--
-- Dumping data for table `salesrule_website`
--


--
-- Table structure for table `search_query`
--

CREATE TABLE `search_query` (
  `query_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Query ID',
  `query_text` varchar(255) DEFAULT NULL COMMENT 'Query text',
  `num_results` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Num results',
  `popularity` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Popularity',
  `redirect` varchar(255) DEFAULT NULL COMMENT 'Redirect',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `display_in_terms` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Display in terms',
  `is_active` smallint(6) DEFAULT 1 COMMENT 'Active status',
  `is_processed` smallint(6) DEFAULT 0 COMMENT 'Processed status',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated at',
  PRIMARY KEY (`query_id`),
  UNIQUE KEY `SEARCH_QUERY_QUERY_TEXT_STORE_ID` (`query_text`,`store_id`),
  KEY `SEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY` (`query_text`,`store_id`,`popularity`),
  KEY `SEARCH_QUERY_STORE_ID` (`store_id`),
  KEY `SEARCH_QUERY_IS_PROCESSED` (`is_processed`),
  KEY `SEARCH_QUERY_STORE_ID_POPULARITY` (`store_id`,`popularity`),
  CONSTRAINT `SEARCH_QUERY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=347 DEFAULT CHARSET=utf8 COMMENT='Search query table';

--
-- Dumping data for table `search_query`
--

INSERT INTO `search_query` VALUES (1,'ggg',0,1,NULL,1,1,1,0,'2020-11-19 15:27:16'),(3,'ggggg',0,1,NULL,1,1,1,0,'2020-11-19 15:27:21'),(5,'gggg',0,1,NULL,1,1,1,0,'2020-11-19 15:27:22'),(7,'gggggkg',0,1,NULL,1,1,1,0,'2020-11-19 15:27:23'),(9,'gggggg',0,1,NULL,1,1,1,0,'2020-11-19 15:27:29'),(11,'gsđg',0,1,NULL,1,1,1,0,'2020-11-19 15:40:58'),(13,'hkhkh',0,1,NULL,1,1,1,0,'2020-11-24 15:36:39'),(15,'360',3,3,NULL,1,1,1,0,'2020-12-01 08:08:16'),(22,'hdhh',0,1,NULL,1,1,1,0,'2020-12-06 06:15:45'),(24,'a',0,0,NULL,5,1,1,0,'2020-12-18 04:03:45'),(25,'asasasas',0,1,NULL,1,1,1,0,'2020-12-18 06:49:16'),(27,'product',0,2,NULL,15,1,1,0,'2020-12-31 09:07:21'),(31,'a',0,0,NULL,15,1,1,0,'2020-12-31 09:07:31'),(33,'an',11,1,NULL,15,1,1,0,'2020-12-31 09:07:40'),(35,'cot',4,3,NULL,15,1,1,0,'2020-12-31 09:08:09'),(43,'âs',0,1,NULL,16,1,1,0,'2021-01-04 04:35:54'),(45,'asas',0,2,NULL,16,1,1,0,'2021-01-04 04:35:56'),(49,'asin',13,1,NULL,16,1,1,0,'2021-01-04 04:37:05'),(51,'grand',1,3,NULL,1,1,1,0,'2021-01-26 03:00:29'),(53,'lamp',5,1,NULL,1,1,1,0,'2021-01-05 06:04:36'),(55,'p12',1,2,NULL,1,1,1,0,'2021-01-11 03:02:26'),(61,'p12èaef',0,2,NULL,1,1,1,0,'2021-01-11 03:08:26'),(65,'drop',1,3,NULL,1,1,1,0,'2021-01-19 02:21:42'),(67,'ad',0,1,NULL,14,1,1,0,'2021-01-11 07:22:14'),(69,'co',6,1,NULL,14,1,1,0,'2021-01-11 07:22:21'),(71,'cot',0,2,NULL,14,1,1,0,'2021-02-03 04:48:39'),(73,'p12',0,2,NULL,14,1,1,0,'2021-01-11 07:22:57'),(77,'cre',1,2,NULL,14,1,1,0,'2021-01-11 07:23:16'),(81,'Cotton T-shirt',5,4,NULL,14,1,1,0,'2021-01-11 07:25:45'),(89,'cv',0,1,NULL,1,1,1,0,'2021-01-12 01:19:46'),(91,'cot',0,1,NULL,1,1,1,0,'2021-01-12 01:19:48'),(93,'sa',3,3,NULL,1,1,1,0,'2021-01-19 02:20:56'),(95,'salf',0,1,NULL,1,1,1,0,'2021-01-12 01:19:59'),(97,'sal',0,1,NULL,1,1,1,0,'2021-01-12 01:20:02'),(103,'sar',0,1,NULL,1,1,1,0,'2021-01-19 02:20:58'),(105,'ribb',0,8,NULL,1,1,1,0,'2021-01-26 03:00:10'),(107,'dr',1,1,NULL,1,1,1,0,'2021-01-19 02:21:37'),(111,'dropc',0,1,NULL,1,1,1,0,'2021-01-19 02:21:39'),(115,'ribb',0,1,NULL,10,1,1,0,'2021-01-19 03:25:40'),(117,'orb',0,1,NULL,10,1,1,0,'2021-01-19 03:26:44'),(119,'orbis',1,1,NULL,10,1,1,0,'2021-01-19 03:26:46'),(121,'product',0,3,NULL,7,1,1,0,'2021-01-19 03:32:58'),(127,'ab',0,1,NULL,7,1,1,0,'2021-01-19 03:33:10'),(129,'abd',0,1,NULL,7,1,1,0,'2021-01-19 03:33:11'),(131,'tiv',1,3,NULL,7,1,1,0,'2021-01-19 03:33:45'),(139,'ti',0,2,NULL,1,1,1,0,'2021-01-19 08:49:18'),(141,'tivo',0,1,NULL,1,1,1,0,'2021-01-19 08:48:57'),(143,'tiv',0,1,NULL,1,1,1,0,'2021-01-19 08:49:01'),(148,'ri',1,2,NULL,1,1,1,0,'2021-01-26 01:45:20'),(150,'rin',0,3,NULL,1,1,1,0,'2021-01-19 08:49:41'),(173,'ase',0,1,NULL,1,1,1,0,'2021-01-20 01:12:35'),(175,'rcc',0,1,NULL,1,1,1,0,'2021-01-20 03:13:49'),(177,'chai',0,9,NULL,1,1,1,0,'2021-01-26 14:56:21'),(179,'chair',2,19,NULL,1,1,1,0,'2021-01-26 14:58:09'),(181,'arr',0,2,NULL,1,1,1,0,'2021-01-20 03:26:38'),(186,'relm',0,1,NULL,1,1,1,0,'2021-01-20 09:44:42'),(188,'lighting',0,1,NULL,1,1,1,0,'2021-01-20 09:48:05'),(192,'chảier',0,1,NULL,1,1,1,0,'2021-01-20 09:48:12'),(194,'ch',2,1,NULL,1,1,1,0,'2021-01-20 09:48:16'),(200,'chair lam',2,1,NULL,1,1,1,0,'2021-01-20 09:49:03'),(202,'chair lamp',5,1,NULL,1,1,1,0,'2021-01-20 09:49:05'),(222,'xxx',0,1,NULL,1,1,1,0,'2021-01-26 01:48:10'),(224,'gra',0,1,NULL,1,1,1,0,'2021-01-26 01:48:25'),(261,'nike',3,1,NULL,17,1,1,0,'2021-01-26 10:41:28'),(263,'nike',3,1,NULL,16,1,1,0,'2021-01-26 10:41:46'),(265,'cott',0,2,NULL,14,1,1,0,'2021-02-03 04:48:43'),(267,'cotton',4,2,NULL,14,1,1,0,'2021-02-03 04:48:46'),(269,'blue',7,1,NULL,15,1,1,0,'2021-01-26 10:42:14'),(271,'ph5',0,1,NULL,6,1,1,0,'2021-01-26 10:42:35'),(273,'grand',1,1,NULL,6,1,1,0,'2021-01-26 10:42:41'),(287,'salt',2,1,NULL,1,1,1,0,'2021-01-26 14:57:40'),(293,'craf',0,1,NULL,1,1,1,0,'2021-01-26 14:59:06'),(295,'craft',1,1,NULL,1,1,1,0,'2021-01-26 14:59:09'),(297,'ligh',0,1,NULL,14,1,1,0,'2021-01-26 15:00:42'),(299,'light',1,1,NULL,14,1,1,0,'2021-01-26 15:00:43'),(301,'blue',7,3,NULL,14,1,1,0,'2021-01-26 15:04:08'),(307,'chair',2,1,NULL,6,1,1,0,'2021-02-03 03:42:46'),(309,'chair',0,3,NULL,14,1,1,0,'2021-02-03 04:48:35'),(311,'chai',0,2,NULL,14,1,1,0,'2021-02-03 04:48:33'),(313,'cha',0,1,NULL,14,1,1,0,'2021-02-03 04:48:01'),(323,'coton',0,1,NULL,14,1,1,0,'2021-02-03 04:48:41'),(327,'cotto',0,1,NULL,14,1,1,0,'2021-02-03 04:48:44'),(331,'360 S Carronade low floor lamp',12,1,NULL,16,1,1,0,'2022-05-11 02:16:10'),(334,'ad',0,1,NULL,11,1,1,0,'2022-05-11 02:18:04'),(336,'dr',1,1,NULL,11,1,1,0,'2022-05-11 02:18:13'),(338,'drop',1,4,NULL,11,1,1,0,'2022-05-11 02:18:23');

--
-- Table structure for table `search_synonyms`
--

CREATE TABLE `search_synonyms` (
  `group_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Synonyms Group ID',
  `synonyms` text NOT NULL COMMENT 'list of synonyms making up this group',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID - identifies the store view these synonyms belong to',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Website ID - identifies the website ID these synonyms belong to',
  PRIMARY KEY (`group_id`),
  KEY `SEARCH_SYNONYMS_STORE_ID` (`store_id`),
  KEY `SEARCH_SYNONYMS_WEBSITE_ID` (`website_id`),
  FULLTEXT KEY `SEARCH_SYNONYMS_SYNONYMS` (`synonyms`),
  CONSTRAINT `SEARCH_SYNONYMS_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `SEARCH_SYNONYMS_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='table storing various synonyms groups';

--
-- Dumping data for table `search_synonyms`
--


--
-- Table structure for table `sendfriend_log`
--

CREATE TABLE `sendfriend_log` (
  `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `ip` bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer IP address',
  `time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Log time',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Website ID',
  PRIMARY KEY (`log_id`),
  KEY `SENDFRIEND_LOG_IP` (`ip`),
  KEY `SENDFRIEND_LOG_TIME` (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Send to friend function log storage table';

--
-- Dumping data for table `sendfriend_log`
--


--
-- Table structure for table `sequence_creditmemo_0`
--

CREATE TABLE `sequence_creditmemo_0` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_0`
--


--
-- Table structure for table `sequence_creditmemo_1`
--

CREATE TABLE `sequence_creditmemo_1` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_1`
--


--
-- Table structure for table `sequence_creditmemo_10`
--

CREATE TABLE `sequence_creditmemo_10` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_10`
--


--
-- Table structure for table `sequence_creditmemo_11`
--

CREATE TABLE `sequence_creditmemo_11` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_11`
--


--
-- Table structure for table `sequence_creditmemo_14`
--

CREATE TABLE `sequence_creditmemo_14` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_14`
--


--
-- Table structure for table `sequence_creditmemo_15`
--

CREATE TABLE `sequence_creditmemo_15` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_15`
--


--
-- Table structure for table `sequence_creditmemo_16`
--

CREATE TABLE `sequence_creditmemo_16` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_16`
--


--
-- Table structure for table `sequence_creditmemo_17`
--

CREATE TABLE `sequence_creditmemo_17` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_17`
--


--
-- Table structure for table `sequence_creditmemo_3`
--

CREATE TABLE `sequence_creditmemo_3` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_3`
--


--
-- Table structure for table `sequence_creditmemo_4`
--

CREATE TABLE `sequence_creditmemo_4` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_4`
--


--
-- Table structure for table `sequence_creditmemo_5`
--

CREATE TABLE `sequence_creditmemo_5` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_5`
--


--
-- Table structure for table `sequence_creditmemo_6`
--

CREATE TABLE `sequence_creditmemo_6` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_6`
--


--
-- Table structure for table `sequence_creditmemo_7`
--

CREATE TABLE `sequence_creditmemo_7` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_7`
--


--
-- Table structure for table `sequence_creditmemo_8`
--

CREATE TABLE `sequence_creditmemo_8` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_8`
--


--
-- Table structure for table `sequence_creditmemo_9`
--

CREATE TABLE `sequence_creditmemo_9` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_creditmemo_9`
--


--
-- Table structure for table `sequence_invoice_0`
--

CREATE TABLE `sequence_invoice_0` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_0`
--


--
-- Table structure for table `sequence_invoice_1`
--

CREATE TABLE `sequence_invoice_1` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_1`
--


--
-- Table structure for table `sequence_invoice_10`
--

CREATE TABLE `sequence_invoice_10` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_10`
--


--
-- Table structure for table `sequence_invoice_11`
--

CREATE TABLE `sequence_invoice_11` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_11`
--


--
-- Table structure for table `sequence_invoice_14`
--

CREATE TABLE `sequence_invoice_14` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_14`
--


--
-- Table structure for table `sequence_invoice_15`
--

CREATE TABLE `sequence_invoice_15` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_15`
--


--
-- Table structure for table `sequence_invoice_16`
--

CREATE TABLE `sequence_invoice_16` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_16`
--


--
-- Table structure for table `sequence_invoice_17`
--

CREATE TABLE `sequence_invoice_17` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_17`
--


--
-- Table structure for table `sequence_invoice_3`
--

CREATE TABLE `sequence_invoice_3` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_3`
--


--
-- Table structure for table `sequence_invoice_4`
--

CREATE TABLE `sequence_invoice_4` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_4`
--


--
-- Table structure for table `sequence_invoice_5`
--

CREATE TABLE `sequence_invoice_5` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_5`
--


--
-- Table structure for table `sequence_invoice_6`
--

CREATE TABLE `sequence_invoice_6` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_6`
--


--
-- Table structure for table `sequence_invoice_7`
--

CREATE TABLE `sequence_invoice_7` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_7`
--


--
-- Table structure for table `sequence_invoice_8`
--

CREATE TABLE `sequence_invoice_8` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_8`
--


--
-- Table structure for table `sequence_invoice_9`
--

CREATE TABLE `sequence_invoice_9` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_invoice_9`
--


--
-- Table structure for table `sequence_order_0`
--

CREATE TABLE `sequence_order_0` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_0`
--


--
-- Table structure for table `sequence_order_1`
--

CREATE TABLE `sequence_order_1` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_1`
--

INSERT INTO `sequence_order_1` VALUES (1),(2),(3),(4),(5),(6),(7);

--
-- Table structure for table `sequence_order_10`
--

CREATE TABLE `sequence_order_10` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_10`
--


--
-- Table structure for table `sequence_order_11`
--

CREATE TABLE `sequence_order_11` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_11`
--


--
-- Table structure for table `sequence_order_14`
--

CREATE TABLE `sequence_order_14` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_14`
--


--
-- Table structure for table `sequence_order_15`
--

CREATE TABLE `sequence_order_15` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_15`
--


--
-- Table structure for table `sequence_order_16`
--

CREATE TABLE `sequence_order_16` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_16`
--

INSERT INTO `sequence_order_16` VALUES (1),(2);

--
-- Table structure for table `sequence_order_17`
--

CREATE TABLE `sequence_order_17` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_17`
--


--
-- Table structure for table `sequence_order_3`
--

CREATE TABLE `sequence_order_3` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_3`
--


--
-- Table structure for table `sequence_order_4`
--

CREATE TABLE `sequence_order_4` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_4`
--


--
-- Table structure for table `sequence_order_5`
--

CREATE TABLE `sequence_order_5` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_5`
--


--
-- Table structure for table `sequence_order_6`
--

CREATE TABLE `sequence_order_6` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_6`
--


--
-- Table structure for table `sequence_order_7`
--

CREATE TABLE `sequence_order_7` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_7`
--


--
-- Table structure for table `sequence_order_8`
--

CREATE TABLE `sequence_order_8` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_8`
--


--
-- Table structure for table `sequence_order_9`
--

CREATE TABLE `sequence_order_9` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_order_9`
--


--
-- Table structure for table `sequence_shipment_0`
--

CREATE TABLE `sequence_shipment_0` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_shipment_0`
--


--
-- Table structure for table `sequence_shipment_1`
--

CREATE TABLE `sequence_shipment_1` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_shipment_1`
--


--
-- Table structure for table `sequence_shipment_10`
--

CREATE TABLE `sequence_shipment_10` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_shipment_10`
--


--
-- Table structure for table `sequence_shipment_11`
--

CREATE TABLE `sequence_shipment_11` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_shipment_11`
--


--
-- Table structure for table `sequence_shipment_14`
--

CREATE TABLE `sequence_shipment_14` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_shipment_14`
--


--
-- Table structure for table `sequence_shipment_15`
--

CREATE TABLE `sequence_shipment_15` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_shipment_15`
--


--
-- Table structure for table `sequence_shipment_16`
--

CREATE TABLE `sequence_shipment_16` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_shipment_16`
--


--
-- Table structure for table `sequence_shipment_17`
--

CREATE TABLE `sequence_shipment_17` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_shipment_17`
--


--
-- Table structure for table `sequence_shipment_3`
--

CREATE TABLE `sequence_shipment_3` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_shipment_3`
--


--
-- Table structure for table `sequence_shipment_4`
--

CREATE TABLE `sequence_shipment_4` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_shipment_4`
--


--
-- Table structure for table `sequence_shipment_5`
--

CREATE TABLE `sequence_shipment_5` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_shipment_5`
--


--
-- Table structure for table `sequence_shipment_6`
--

CREATE TABLE `sequence_shipment_6` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_shipment_6`
--


--
-- Table structure for table `sequence_shipment_7`
--

CREATE TABLE `sequence_shipment_7` (
  `sequence_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`sequence_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequence_shipment_7`
--


--
