--
-- Host: localhost    Database: shopwise
-- ------------------------------------------------------


--
-- Table structure for table `activations`
--

CREATE TABLE `activations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `code` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activations_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activations`
--

INSERT INTO `activations` VALUES (1,1,'7UcjD4feKXymKLr60lBj1wShh1EsyuiI',1,'2021-05-03 02:01:13','2021-05-03 02:01:13','2021-05-03 02:01:13'),(2,1,'QzJAXlvGpo4tx37tMxpoXY6fOamqFolp',1,'2021-07-02 20:17:18','2021-07-02 20:17:18','2021-07-02 20:17:18'),(3,1,'tenKNEKgNNpixls9zjhWiP7yEQh7y42z',1,'2021-07-02 20:21:11','2021-07-02 20:21:11','2021-07-02 20:21:11'),(4,1,'AEWRmiHmQC91TrsxcGlZCRMuCihlHbJd',1,'2021-07-02 20:47:01','2021-07-02 20:47:01','2021-07-02 20:47:01'),(5,1,'qmDtNslvquK6wmvIWg3MRUQLa3gWa0Pz',1,'2021-07-02 21:03:29','2021-07-02 21:03:29','2021-07-02 21:03:29');

--
-- Table structure for table `audit_histories`
--

CREATE TABLE `audit_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `module` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `request` text COLLATE utf8mb4_unicode_ci,
  `action` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(39) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_user` int(10) unsigned NOT NULL,
  `reference_id` int(10) unsigned NOT NULL,
  `reference_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_histories_user_id_index` (`user_id`),
  KEY `audit_histories_module_index` (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_histories`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `author_id` int(11) NOT NULL,
  `author_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `icon` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint(4) NOT NULL DEFAULT '0',
  `is_featured` tinyint(4) NOT NULL DEFAULT '0',
  `is_default` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'Ecommerce',0,NULL,'published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2021-07-02 21:03:27','2021-07-02 21:03:27'),(2,'Fashion',0,NULL,'published',1,'Botble\\ACL\\Models\\User',NULL,0,0,0,'2021-07-02 21:03:27','2021-07-02 21:03:27'),(3,'Electronic',0,NULL,'published',1,'Botble\\ACL\\Models\\User',NULL,0,0,0,'2021-07-02 21:03:27','2021-07-02 21:03:27'),(4,'Commercial',0,NULL,'published',1,'Botble\\ACL\\Models\\User',NULL,0,0,0,'2021-07-02 21:03:27','2021-07-02 21:03:27');

--
-- Table structure for table `contact_replies`
--

CREATE TABLE `contact_replies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_replies`
--


--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unread',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--


--
-- Table structure for table `dashboard_widget_settings`
--

CREATE TABLE `dashboard_widget_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `settings` text COLLATE utf8mb4_unicode_ci,
  `user_id` int(10) unsigned NOT NULL,
  `widget_id` int(10) unsigned NOT NULL,
  `order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dashboard_widget_settings_user_id_index` (`user_id`),
  KEY `dashboard_widget_settings_widget_id_index` (`widget_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dashboard_widget_settings`
--


--
-- Table structure for table `dashboard_widgets`
--

CREATE TABLE `dashboard_widgets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dashboard_widgets`
--

INSERT INTO `dashboard_widgets` VALUES (1,'widget_total_1','2021-06-26 20:36:21','2021-06-26 20:36:21'),(2,'widget_total_2','2021-06-26 20:36:22','2021-06-26 20:36:22'),(3,'widget_total_themes','2021-06-26 20:36:22','2021-06-26 20:36:22'),(4,'widget_total_3','2021-06-26 20:36:22','2021-06-26 20:36:22'),(5,'widget_total_4','2021-06-26 20:36:22','2021-06-26 20:36:22'),(6,'widget_total_users','2021-06-26 20:36:22','2021-06-26 20:36:22'),(7,'widget_total_pages','2021-06-26 20:36:22','2021-06-26 20:36:22'),(8,'widget_total_plugins','2021-06-26 20:36:22','2021-06-26 20:36:22'),(9,'widget_analytics_general','2021-06-26 20:36:22','2021-06-26 20:36:22'),(10,'widget_analytics_page','2021-06-26 20:36:22','2021-06-26 20:36:22'),(11,'widget_analytics_browser','2021-06-26 20:36:23','2021-06-26 20:36:23'),(12,'widget_posts_recent','2021-06-26 20:36:23','2021-06-26 20:36:23'),(13,'widget_analytics_referrer','2021-06-26 20:36:23','2021-06-26 20:36:23'),(14,'widget_audit_logs','2021-06-26 20:36:23','2021-06-26 20:36:23'),(15,'widget_ecommerce_report_general','2021-06-26 20:36:23','2021-06-26 20:36:23');

--
-- Table structure for table `ec_brands`
--

CREATE TABLE `ec_brands` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `is_featured` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_brands`
--

INSERT INTO `ec_brands` VALUES (1,'Fashion live',NULL,NULL,'brands/1.png','published',0,1,'2021-07-02 21:02:30','2021-07-02 21:02:30'),(2,'Hand crafted',NULL,NULL,'brands/2.png','published',1,1,'2021-07-02 21:02:30','2021-07-02 21:02:30'),(3,'Mestonix',NULL,NULL,'brands/3.png','published',2,1,'2021-07-02 21:02:30','2021-07-02 21:02:30'),(4,'Sunshine',NULL,NULL,'brands/4.png','published',3,1,'2021-07-02 21:02:30','2021-07-02 21:02:30'),(5,'Pure',NULL,NULL,'brands/5.png','published',4,1,'2021-07-02 21:02:30','2021-07-02 21:02:30'),(6,'Anfold',NULL,NULL,'brands/6.png','published',5,1,'2021-07-02 21:02:30','2021-07-02 21:02:30'),(7,'Automotive',NULL,NULL,'brands/7.png','published',6,1,'2021-07-02 21:02:30','2021-07-02 21:02:30');

--
-- Table structure for table `ec_cart`
--

CREATE TABLE `ec_cart` (
  `identifier` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `instance` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`identifier`,`instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_cart`
--


--
-- Table structure for table `ec_currencies`
--

CREATE TABLE `ec_currencies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_prefix_symbol` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `decimals` tinyint(3) unsigned DEFAULT '0',
  `order` int(10) unsigned DEFAULT '0',
  `is_default` tinyint(4) NOT NULL DEFAULT '0',
  `exchange_rate` double NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_currencies`
--

INSERT INTO `ec_currencies` VALUES (1,'USD','$',1,2,0,1,1,'2021-07-02 21:02:30','2021-07-02 21:02:30'),(2,'EUR','€',0,2,1,0,0.84,'2021-07-02 21:02:30','2021-07-02 21:02:30'),(3,'VND','₫',0,0,2,0,23203,'2021-07-02 21:02:30','2021-07-02 21:02:30');

--
-- Table structure for table `ec_customer_addresses`
--

CREATE TABLE `ec_customer_addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  `is_default` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `zip_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_customer_addresses`
--

INSERT INTO `ec_customer_addresses` VALUES (1,'John Smith','john.smith@botble.com','+19725795880','FI','New Mexico','Port Joanny','88894 Skiles Cliff Apt. 302',1,1,'2021-07-02 21:02:34','2021-07-02 21:02:34','86509'),(2,'John Smith','john.smith@botble.com','+19299586840','AO','West Virginia','Port Armando','8125 German Bridge',1,0,'2021-07-02 21:02:34','2021-07-02 21:02:34','04782'),(3,'Mrs. Eldridge Blick','cora83@example.com','+16785915500','NF','Massachusetts','North Chanel','454 Gerhold Falls',2,1,'2021-07-02 21:02:34','2021-07-02 21:02:34','79996-0341'),(4,'Ms. Nia Hauck','marlon94@example.net','+12235541362','BA','Iowa','East Kaseybury','650 Wolff Estates',3,1,'2021-07-02 21:02:34','2021-07-02 21:02:34','69355'),(5,'Kade Senger','otto.runte@example.com','+17541662003','SV','South Carolina','South Misty','956 Mayert Orchard Apt. 650',4,1,'2021-07-02 21:02:35','2021-07-02 21:02:35','70114-1144'),(6,'Rosendo Casper','magnus.quigley@example.net','+15341388658','NF','Georgia','East Malcolmfort','1676 Glennie Ridge',5,1,'2021-07-02 21:02:35','2021-07-02 21:02:35','65433'),(7,'Mr. Gerhard Sanford','rod.mertz@example.net','+19731127390','FM','Arkansas','Lake Murlmouth','21371 Addie Drive Apt. 587',6,1,'2021-07-02 21:02:35','2021-07-02 21:02:35','69384-7852'),(8,'Prof. Unique Lehner','tohara@example.org','+19128341528','RE','Georgia','Camillafurt','9086 Kutch Burg Suite 559',7,1,'2021-07-02 21:02:36','2021-07-02 21:02:36','90995-1999'),(9,'Mr. Everett Harvey PhD','bahringer.bernice@example.net','+18185966737','FK','Hawaii','Baumbachland','9713 Hartmann Cove',8,1,'2021-07-02 21:02:36','2021-07-02 21:02:36','17388-9390'),(10,'Mason Anderson','atillman@example.org','+14708554768','SH','Mississippi','Raleighport','894 Brayan Keys Suite 015',9,1,'2021-07-02 21:02:36','2021-07-02 21:02:36','08157-9871'),(11,'Hattie Crist','archibald.legros@example.org','+18572615328','CO','Utah','Ednaside','94831 Ericka Circle Suite 382',10,1,'2021-07-02 21:02:36','2021-07-02 21:02:36','06943'),(12,'Gino Feest','wschultz@example.org','+12233793135','SJ','Iowa','North Michaelaborough','442 Legros Fort Apt. 711',11,1,'2021-07-02 21:02:37','2021-07-02 21:02:37','70475-1907');

--
-- Table structure for table `ec_customer_password_resets`
--

CREATE TABLE `ec_customer_password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `ec_customer_password_resets_email_index` (`email`),
  KEY `ec_customer_password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_customer_password_resets`
--


--
-- Table structure for table `ec_discount_customers`
--

CREATE TABLE `ec_discount_customers` (
  `discount_id` int(10) unsigned NOT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`discount_id`,`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_discount_customers`
--


--
-- Table structure for table `ec_discount_product_collections`
--

CREATE TABLE `ec_discount_product_collections` (
  `discount_id` int(10) unsigned NOT NULL,
  `product_collection_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`discount_id`,`product_collection_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_discount_product_collections`
--


--
-- Table structure for table `ec_discount_products`
--

CREATE TABLE `ec_discount_products` (
  `discount_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`discount_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_discount_products`
--


--
-- Table structure for table `ec_discounts`
--

CREATE TABLE `ec_discounts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `total_used` int(10) unsigned NOT NULL DEFAULT '0',
  `value` double DEFAULT NULL,
  `type` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT 'coupon',
  `can_use_with_promotion` tinyint(1) NOT NULL DEFAULT '0',
  `discount_on` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_quantity` int(10) unsigned DEFAULT NULL,
  `type_option` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'amount',
  `target` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'all-orders',
  `min_order_price` decimal(15,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_discounts_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_discounts`
--


--
-- Table structure for table `ec_flash_sale_products`
--

CREATE TABLE `ec_flash_sale_products` (
  `flash_sale_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `price` double unsigned DEFAULT NULL,
  `quantity` int(10) unsigned DEFAULT NULL,
  `sold` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_flash_sale_products`
--

INSERT INTO `ec_flash_sale_products` VALUES (1,105,28.62,15,1),(2,90,31.995,9,5),(3,52,85.8,9,2);

--
-- Table structure for table `ec_flash_sales`
--

CREATE TABLE `ec_flash_sales` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_date` datetime NOT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_flash_sales`
--

INSERT INTO `ec_flash_sales` VALUES (1,'Winter Sale 1','2021-07-23 00:00:00','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(2,'Winter Sale 2','2021-08-19 00:00:00','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(3,'Winter Sale 3','2021-08-22 00:00:00','published','2021-07-02 21:03:24','2021-07-02 21:03:24');

--
-- Table structure for table `ec_grouped_products`
--

CREATE TABLE `ec_grouped_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent_product_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `fixed_qty` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_grouped_products`
--


--
-- Table structure for table `ec_order_addresses`
--

CREATE TABLE `ec_order_addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_id` int(10) unsigned NOT NULL,
  `zip_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_order_addresses`
--

INSERT INTO `ec_order_addresses` VALUES (1,'Mason Anderson','+14708554768','atillman@example.org','SH','Mississippi','Raleighport','894 Brayan Keys Suite 015',1,'08157-9871'),(2,'Hattie Crist','+18572615328','archibald.legros@example.org','CO','Utah','Ednaside','94831 Ericka Circle Suite 382',2,'06943'),(3,'Prof. Unique Lehner','+19128341528','tohara@example.org','RE','Georgia','Camillafurt','9086 Kutch Burg Suite 559',3,'90995-1999'),(4,'Mr. Gerhard Sanford','+19731127390','rod.mertz@example.net','FM','Arkansas','Lake Murlmouth','21371 Addie Drive Apt. 587',4,'69384-7852'),(5,'Prof. Unique Lehner','+19128341528','tohara@example.org','RE','Georgia','Camillafurt','9086 Kutch Burg Suite 559',5,'90995-1999'),(6,'Kade Senger','+17541662003','otto.runte@example.com','SV','South Carolina','South Misty','956 Mayert Orchard Apt. 650',6,'70114-1144'),(7,'Kade Senger','+17541662003','otto.runte@example.com','SV','South Carolina','South Misty','956 Mayert Orchard Apt. 650',7,'70114-1144'),(8,'Mrs. Eldridge Blick','+16785915500','cora83@example.com','NF','Massachusetts','North Chanel','454 Gerhold Falls',8,'79996-0341'),(9,'Ms. Nia Hauck','+12235541362','marlon94@example.net','BA','Iowa','East Kaseybury','650 Wolff Estates',9,'69355'),(10,'Rosendo Casper','+15341388658','magnus.quigley@example.net','NF','Georgia','East Malcolmfort','1676 Glennie Ridge',10,'65433'),(11,'Mr. Everett Harvey PhD','+18185966737','bahringer.bernice@example.net','FK','Hawaii','Baumbachland','9713 Hartmann Cove',11,'17388-9390'),(12,'Kade Senger','+17541662003','otto.runte@example.com','SV','South Carolina','South Misty','956 Mayert Orchard Apt. 650',12,'70114-1144'),(13,'Prof. Unique Lehner','+19128341528','tohara@example.org','RE','Georgia','Camillafurt','9086 Kutch Burg Suite 559',13,'90995-1999'),(14,'Ms. Nia Hauck','+12235541362','marlon94@example.net','BA','Iowa','East Kaseybury','650 Wolff Estates',14,'69355'),(15,'John Smith','+19725795880','john.smith@botble.com','FI','New Mexico','Port Joanny','88894 Skiles Cliff Apt. 302',15,'86509'),(16,'Prof. Unique Lehner','+19128341528','tohara@example.org','RE','Georgia','Camillafurt','9086 Kutch Burg Suite 559',16,'90995-1999'),(17,'John Smith','+19725795880','john.smith@botble.com','FI','New Mexico','Port Joanny','88894 Skiles Cliff Apt. 302',17,'86509'),(18,'Hattie Crist','+18572615328','archibald.legros@example.org','CO','Utah','Ednaside','94831 Ericka Circle Suite 382',18,'06943'),(19,'John Smith','+19725795880','john.smith@botble.com','FI','New Mexico','Port Joanny','88894 Skiles Cliff Apt. 302',19,'86509'),(20,'Mr. Gerhard Sanford','+19731127390','rod.mertz@example.net','FM','Arkansas','Lake Murlmouth','21371 Addie Drive Apt. 587',20,'69384-7852');

--
-- Table structure for table `ec_order_histories`
--

CREATE TABLE `ec_order_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `action` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `order_id` int(10) unsigned NOT NULL,
  `extras` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_order_histories`
--

INSERT INTO `ec_order_histories` VALUES (1,'create_order_from_seeder','Order is created from the checkout page',NULL,1,NULL,'2021-06-29 13:03:25','2021-06-29 13:03:25'),(2,'confirm_order','Order was verified by %user_name%',0,1,NULL,'2021-06-29 13:03:25','2021-06-29 13:03:25'),(3,'confirm_payment','Payment was confirmed (amount $187.28) by %user_name%',0,1,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(4,'create_shipment','Created shipment for order',0,1,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(5,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,1,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(6,'create_order_from_seeder','Order is created from the checkout page',NULL,2,NULL,'2021-07-01 07:03:25','2021-07-01 07:03:25'),(7,'confirm_order','Order was verified by %user_name%',0,2,NULL,'2021-07-01 07:03:25','2021-07-01 07:03:25'),(8,'confirm_payment','Payment was confirmed (amount $597.20) by %user_name%',0,2,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(9,'create_shipment','Created shipment for order',0,2,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(10,'create_order_from_seeder','Order is created from the checkout page',NULL,3,NULL,'2021-06-25 09:03:25','2021-06-25 09:03:25'),(11,'confirm_order','Order was verified by %user_name%',0,3,NULL,'2021-06-25 09:03:25','2021-06-25 09:03:25'),(12,'confirm_payment','Payment was confirmed (amount $214.50) by %user_name%',0,3,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(13,'create_shipment','Created shipment for order',0,3,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(14,'create_order_from_seeder','Order is created from the checkout page',NULL,4,NULL,'2021-07-01 11:03:25','2021-07-01 11:03:25'),(15,'confirm_order','Order was verified by %user_name%',0,4,NULL,'2021-07-01 11:03:25','2021-07-01 11:03:25'),(16,'confirm_payment','Payment was confirmed (amount $330.40) by %user_name%',0,4,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(17,'create_shipment','Created shipment for order',0,4,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(18,'create_order_from_seeder','Order is created from the checkout page',NULL,5,NULL,'2021-07-01 13:03:25','2021-07-01 13:03:25'),(19,'confirm_order','Order was verified by %user_name%',0,5,NULL,'2021-07-01 13:03:25','2021-07-01 13:03:25'),(20,'create_shipment','Created shipment for order',0,5,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(21,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,5,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(22,'create_order_from_seeder','Order is created from the checkout page',NULL,6,NULL,'2021-06-27 21:03:25','2021-06-27 21:03:25'),(23,'confirm_order','Order was verified by %user_name%',0,6,NULL,'2021-06-27 21:03:25','2021-06-27 21:03:25'),(24,'create_shipment','Created shipment for order',0,6,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(25,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,6,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(26,'create_order_from_seeder','Order is created from the checkout page',NULL,7,NULL,'2021-06-28 05:03:25','2021-06-28 05:03:25'),(27,'confirm_order','Order was verified by %user_name%',0,7,NULL,'2021-06-28 05:03:25','2021-06-28 05:03:25'),(28,'confirm_payment','Payment was confirmed (amount $1,075.40) by %user_name%',0,7,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(29,'create_shipment','Created shipment for order',0,7,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(30,'create_order_from_seeder','Order is created from the checkout page',NULL,8,NULL,'2021-07-01 19:03:25','2021-07-01 19:03:25'),(31,'confirm_order','Order was verified by %user_name%',0,8,NULL,'2021-07-01 19:03:25','2021-07-01 19:03:25'),(32,'confirm_payment','Payment was confirmed (amount $430.50) by %user_name%',0,8,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(33,'create_shipment','Created shipment for order',0,8,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(34,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,8,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(35,'create_order_from_seeder','Order is created from the checkout page',NULL,9,NULL,'2021-06-27 21:03:25','2021-06-27 21:03:25'),(36,'confirm_order','Order was verified by %user_name%',0,9,NULL,'2021-06-27 21:03:25','2021-06-27 21:03:25'),(37,'confirm_payment','Payment was confirmed (amount $435.80) by %user_name%',0,9,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(38,'create_shipment','Created shipment for order',0,9,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(39,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,9,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(40,'create_order_from_seeder','Order is created from the checkout page',NULL,10,NULL,'2021-07-01 01:03:25','2021-07-01 01:03:25'),(41,'confirm_order','Order was verified by %user_name%',0,10,NULL,'2021-07-01 01:03:25','2021-07-01 01:03:25'),(42,'confirm_payment','Payment was confirmed (amount $658.90) by %user_name%',0,10,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(43,'create_shipment','Created shipment for order',0,10,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(44,'create_order_from_seeder','Order is created from the checkout page',NULL,11,NULL,'2021-06-25 09:03:25','2021-06-25 09:03:25'),(45,'confirm_order','Order was verified by %user_name%',0,11,NULL,'2021-06-25 09:03:25','2021-06-25 09:03:25'),(46,'confirm_payment','Payment was confirmed (amount $655.60) by %user_name%',0,11,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(47,'create_shipment','Created shipment for order',0,11,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(48,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,11,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(49,'create_order_from_seeder','Order is created from the checkout page',NULL,12,NULL,'2021-06-26 03:03:25','2021-06-26 03:03:25'),(50,'confirm_order','Order was verified by %user_name%',0,12,NULL,'2021-06-26 03:03:25','2021-06-26 03:03:25'),(51,'confirm_payment','Payment was confirmed (amount $1,009.30) by %user_name%',0,12,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(52,'create_shipment','Created shipment for order',0,12,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(53,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,12,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(54,'create_order_from_seeder','Order is created from the checkout page',NULL,13,NULL,'2021-06-28 05:03:25','2021-06-28 05:03:25'),(55,'confirm_order','Order was verified by %user_name%',0,13,NULL,'2021-06-28 05:03:25','2021-06-28 05:03:25'),(56,'confirm_payment','Payment was confirmed (amount $749.00) by %user_name%',0,13,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(57,'create_shipment','Created shipment for order',0,13,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(58,'create_order_from_seeder','Order is created from the checkout page',NULL,14,NULL,'2021-07-02 07:03:25','2021-07-02 07:03:25'),(59,'confirm_order','Order was verified by %user_name%',0,14,NULL,'2021-07-02 07:03:25','2021-07-02 07:03:25'),(60,'create_shipment','Created shipment for order',0,14,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(61,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,14,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(62,'create_order_from_seeder','Order is created from the checkout page',NULL,15,NULL,'2021-06-28 21:03:25','2021-06-28 21:03:25'),(63,'confirm_order','Order was verified by %user_name%',0,15,NULL,'2021-06-28 21:03:25','2021-06-28 21:03:25'),(64,'create_shipment','Created shipment for order',0,15,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(65,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,15,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(66,'create_order_from_seeder','Order is created from the checkout page',NULL,16,NULL,'2021-07-01 05:03:25','2021-07-01 05:03:25'),(67,'confirm_order','Order was verified by %user_name%',0,16,NULL,'2021-07-01 05:03:25','2021-07-01 05:03:25'),(68,'confirm_payment','Payment was confirmed (amount $1,027.10) by %user_name%',0,16,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(69,'create_shipment','Created shipment for order',0,16,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(70,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,16,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(71,'create_order_from_seeder','Order is created from the checkout page',NULL,17,NULL,'2021-07-01 05:03:25','2021-07-01 05:03:25'),(72,'confirm_order','Order was verified by %user_name%',0,17,NULL,'2021-07-01 05:03:25','2021-07-01 05:03:25'),(73,'confirm_payment','Payment was confirmed (amount $662.78) by %user_name%',0,17,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(74,'create_shipment','Created shipment for order',0,17,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(75,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,17,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(76,'create_order_from_seeder','Order is created from the checkout page',NULL,18,NULL,'2021-06-30 15:03:25','2021-06-30 15:03:25'),(77,'confirm_order','Order was verified by %user_name%',0,18,NULL,'2021-06-30 15:03:25','2021-06-30 15:03:25'),(78,'create_shipment','Created shipment for order',0,18,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(79,'create_order_from_seeder','Order is created from the checkout page',NULL,19,NULL,'2021-07-02 01:03:25','2021-07-02 01:03:25'),(80,'confirm_order','Order was verified by %user_name%',0,19,NULL,'2021-07-02 01:03:25','2021-07-02 01:03:25'),(81,'confirm_payment','Payment was confirmed (amount $228.25) by %user_name%',0,19,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(82,'create_shipment','Created shipment for order',0,19,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(83,'create_order_from_seeder','Order is created from the checkout page',NULL,20,NULL,'2021-07-02 19:03:25','2021-07-02 19:03:25'),(84,'confirm_order','Order was verified by %user_name%',0,20,NULL,'2021-07-02 19:03:25','2021-07-02 19:03:25'),(85,'create_shipment','Created shipment for order',0,20,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(86,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,20,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(87,'update_status','Order confirmed by %user_name%',0,1,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(88,'update_status','Order confirmed by %user_name%',0,8,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(89,'update_status','Order confirmed by %user_name%',0,9,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(90,'update_status','Order confirmed by %user_name%',0,11,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(91,'update_status','Order confirmed by %user_name%',0,12,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(92,'update_status','Order confirmed by %user_name%',0,16,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(93,'update_status','Order confirmed by %user_name%',0,17,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25');

--
-- Table structure for table `ec_order_product`
--

CREATE TABLE `ec_order_product` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) unsigned NOT NULL,
  `qty` int(11) NOT NULL,
  `price` decimal(15,2) NOT NULL,
  `tax_amount` decimal(15,2) NOT NULL,
  `options` text COLLATE utf8mb4_unicode_ci,
  `product_id` int(10) unsigned DEFAULT NULL,
  `product_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `weight` double(8,2) DEFAULT '0.00',
  `restock_quantity` int(10) unsigned DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_order_product`
--

INSERT INTO `ec_order_product` VALUES (1,1,1,90.00,9.00,'[]',40,'Chikie - Bluetooth Speaker',861.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(2,1,1,80.25,8.03,'[]',88,'Dual Camera 20MP',741.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(3,2,3,90.00,9.00,'[]',39,'Chikie - Bluetooth Speaker',2583.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(4,2,2,122.00,12.20,'[]',84,'Phillips Mouse',1374.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(5,2,3,20.00,2.00,'[]',95,'Beat Headphone',2091.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(6,3,1,90.00,9.00,'[]',39,'Chikie - Bluetooth Speaker',861.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(7,3,2,55.00,5.50,'[]',46,'Camera Samsung SS-24',1398.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(8,4,1,110.00,11.00,'[]',52,'Macbook Pro 2015',761.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(9,4,2,20.00,2.00,'[]',95,'Beat Headphone',1394.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(10,4,3,54.00,5.40,'[]',104,'Samsung Smart TV',1815.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(11,5,3,374.00,37.40,'[]',36,'Boxed - Bluetooth Headphone',2484.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(12,5,3,123.00,12.30,'[]',63,'Apple Keyboard',2343.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(13,5,1,110.00,11.00,'[]',71,'Black Smart Watches',865.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(14,5,2,121.00,12.10,'[]',74,'Leather Watch Band Serial 3',1262.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(15,6,3,330.00,33.00,'[]',34,'Headphone Ultra Bass',1578.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(16,6,1,111.00,11.10,'[]',47,'Leather Watch Band',583.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(17,7,3,120.00,12.00,'[]',59,'Macbook Pro 13 inch',1695.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(18,7,3,122.00,12.20,'[]',70,'Cool Smart Watches',2535.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(19,7,2,125.00,12.50,'[]',76,'Macbook Pro 2015 13 inch',1462.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(20,7,1,57.00,5.70,'[]',98,'Red & Black Headphone',610.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(21,8,2,90.00,9.00,'[]',39,'Chikie - Bluetooth Speaker',1722.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(22,8,2,115.00,11.50,'[]',80,'Black Glasses',1388.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(23,9,2,121.00,12.10,'[]',74,'Leather Watch Band Serial 3',1262.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(24,9,3,20.00,2.00,'[]',94,'Beat Headphone',2091.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(25,9,2,57.00,5.70,'[]',96,'Red & Black Headphone',1220.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(26,10,1,431.00,43.10,'[]',33,'Smart Home Speaker',771.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(27,10,1,55.00,5.50,'[]',45,'Camera Samsung SS-24',699.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(28,10,1,113.00,11.30,'[]',51,'Apple iPhone 13 Plus',572.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(29,11,1,111.00,11.10,'[]',48,'Leather Watch Band',583.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(30,11,3,110.00,11.00,'[]',66,'Hand playstation',1530.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(31,11,1,121.00,12.10,'[]',74,'Leather Watch Band Serial 3',631.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(32,11,1,54.00,5.40,'[]',101,'Audio Equipment',801.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(33,12,3,125.00,12.50,'[]',76,'Macbook Pro 2015 13 inch',2193.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(34,12,3,122.00,12.20,'[]',82,'Phillips Mouse',2061.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(35,12,2,116.00,11.60,'[]',102,'Smart Televisions',1050.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(36,13,1,111.00,11.10,'[]',64,'MacSafe 80W',646.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(37,13,2,110.00,11.00,'[]',67,'Hand playstation',1020.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(38,13,1,127.00,12.70,'[]',69,'Apple Airpods Serial 3',724.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(39,13,2,122.00,12.20,'[]',82,'Phillips Mouse',1374.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(40,14,2,115.00,11.50,'[]',81,'Black Glasses',1388.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(41,14,2,40.50,4.05,'[]',91,'Smart Watches',1544.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(42,15,3,110.00,11.00,'[]',72,'Black Smart Watches',2595.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(43,15,3,119.00,11.90,'[]',77,'Historic Alarm Clock',2508.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(44,15,3,115.00,11.50,'[]',81,'Black Glasses',2082.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(45,15,1,116.00,11.60,'[]',102,'Smart Televisions',525.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(46,16,1,431.00,43.10,'[]',32,'Smart Home Speaker',771.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(47,16,3,90.00,9.00,'[]',39,'Chikie - Bluetooth Speaker',2583.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(48,16,2,120.00,12.00,'[]',59,'Macbook Pro 13 inch',1130.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(49,16,1,20.00,2.00,'[]',95,'Beat Headphone',697.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(50,17,2,110.00,11.00,'[]',68,'Hand playstation',1020.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(51,17,1,110.00,11.00,'[]',71,'Black Smart Watches',865.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(52,17,3,80.25,8.03,'[]',87,'Dual Camera 20MP',2223.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(53,17,3,20.00,2.00,'[]',93,'Beat Headphone',2091.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(54,18,3,90.00,9.00,'[]',39,'Chikie - Bluetooth Speaker',2583.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(55,18,3,110.00,11.00,'[]',71,'Black Smart Watches',2595.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(56,18,1,122.00,12.20,'[]',83,'Phillips Mouse',687.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(57,18,3,20.00,2.00,'[]',95,'Beat Headphone',2091.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(58,19,1,46.00,4.60,'[]',42,'Camera Hikvision HK-35VS8',896.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(59,19,1,121.00,12.10,'[]',75,'Leather Watch Band Serial 3',631.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(60,19,1,40.50,4.05,'[]',91,'Smart Watches',772.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(61,20,2,55.00,5.50,'[]',46,'Camera Samsung SS-24',1398.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(62,20,2,110.00,11.00,'[]',67,'Hand playstation',1020.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25');

--
-- Table structure for table `ec_product_attribute_sets`
--

CREATE TABLE `ec_product_attribute_sets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `display_layout` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'swatch_dropdown',
  `is_searchable` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `is_comparable` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `is_use_in_product_listing` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_attribute_sets`
--

INSERT INTO `ec_product_attribute_sets` VALUES (1,'Color','color','visual',1,1,1,'published',0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(2,'Size','size','text',1,1,1,'published',1,'2021-07-02 21:02:32','2021-07-02 21:02:32');

--
-- Table structure for table `ec_product_attributes`
--

CREATE TABLE `ec_product_attributes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_set_id` int(10) unsigned NOT NULL,
  `title` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_attributes`
--

INSERT INTO `ec_product_attributes` VALUES (1,1,'Green','green','#5FB7D4',NULL,1,1,'published','2021-07-02 21:02:32','2021-07-02 21:02:32'),(2,1,'Blue','blue','#333333',NULL,0,2,'published','2021-07-02 21:02:32','2021-07-02 21:02:32'),(3,1,'Red','red','#DA323F',NULL,0,3,'published','2021-07-02 21:02:32','2021-07-02 21:02:32'),(4,1,'Black','back','#2F366C',NULL,0,4,'published','2021-07-02 21:02:32','2021-07-02 21:02:32'),(5,1,'Brown','brown','#87554B',NULL,0,5,'published','2021-07-02 21:02:32','2021-07-02 21:02:32'),(6,2,'S','s',NULL,NULL,1,1,'published','2021-07-02 21:02:32','2021-07-02 21:02:32'),(7,2,'M','m',NULL,NULL,1,2,'published','2021-07-02 21:02:32','2021-07-02 21:02:32'),(8,2,'L','l',NULL,NULL,1,3,'published','2021-07-02 21:02:32','2021-07-02 21:02:32'),(9,2,'XL','xl',NULL,NULL,1,4,'published','2021-07-02 21:02:32','2021-07-02 21:02:32'),(10,2,'XXL','xxl',NULL,NULL,1,5,'published','2021-07-02 21:02:32','2021-07-02 21:02:32');

--
-- Table structure for table `ec_product_categories`
--

CREATE TABLE `ec_product_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` int(10) unsigned DEFAULT '0',
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `order` int(10) unsigned NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_featured` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_categories`
--

INSERT INTO `ec_product_categories` VALUES (1,'Television',0,NULL,'published',0,'product-categories/p-1.png',1,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(2,'Mobile',0,NULL,'published',1,'product-categories/p-2.png',1,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(3,'Headphone',0,NULL,'published',2,'product-categories/p-3.png',1,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(4,'Watches',0,NULL,'published',3,'product-categories/p-4.png',1,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(5,'Game',0,NULL,'published',4,'product-categories/p-5.png',1,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(6,'Camera',0,NULL,'published',5,'product-categories/p-6.png',1,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(7,'Audio',0,NULL,'published',6,'product-categories/p-7.png',1,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(8,'Mobile & Tablet',0,NULL,'published',7,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(9,'Accessories',0,NULL,'published',8,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(10,'Home Audio & Theater',0,NULL,'published',9,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(11,'Tv & Smart Box',0,NULL,'published',10,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(12,'Printer',0,NULL,'published',11,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(13,'Computer',0,NULL,'published',12,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(14,'Fax Machine',0,NULL,'published',13,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(15,'Mouse',0,NULL,'published',14,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(16,'Quas fuga dicta qui est.',1,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(17,'Suscipit et maxime in.',1,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(18,'Sed sit ipsa saepe quia.',1,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(19,'Eos est aut cum qui.',1,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(20,'Rem vel sit ut autem.',1,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(21,'Libero et alias eius et.',2,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(22,'Magnam iste a possimus.',2,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(23,'Quo id esse quia et.',2,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(24,'Et alias enim suscipit.',2,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(25,'Rerum quae nam ut quo.',2,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(26,'Quia id sint ad rem.',3,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(27,'Amet eos ut sunt ea.',3,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(28,'Dicta quia expedita ut.',3,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(29,'Sint aut nihil ducimus.',3,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(30,'Dolores dolore quod in.',3,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(31,'Quis id veniam qui hic.',4,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(32,'Cum velit vel aut.',4,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(33,'Expedita sit eos qui.',4,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(34,'Illum impedit et odio.',4,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32'),(35,'Sed et qui sint.',4,NULL,'published',0,NULL,0,'2021-07-02 21:02:32','2021-07-02 21:02:32');

--
-- Table structure for table `ec_product_category_product`
--

CREATE TABLE `ec_product_category_product` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_product_category_product_category_id_index` (`category_id`),
  KEY `ec_product_category_product_product_id_index` (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_category_product`
--

INSERT INTO `ec_product_category_product` VALUES (1,1,1),(2,13,1),(3,8,1),(4,3,2),(5,12,2),(6,2,2),(7,7,3),(8,5,3),(9,8,3),(10,1,4),(11,12,4),(12,5,4),(13,4,5),(14,5,5),(15,3,5),(16,11,6),(17,5,6),(18,8,6),(19,6,7),(20,13,7),(21,9,7),(22,7,8),(23,8,8),(24,1,8),(25,2,9),(26,4,9),(27,9,9),(28,7,10),(29,3,10),(30,1,10),(31,4,11),(32,7,11),(33,11,11),(34,2,12),(35,10,12),(36,4,12),(37,13,13),(38,10,13),(39,2,13),(40,9,14),(41,4,14),(42,10,14),(43,6,15),(44,13,15),(45,8,15),(46,2,16),(47,12,16),(48,9,16),(49,2,17),(50,12,17),(51,1,17),(52,3,18),(53,8,18),(54,2,19),(55,5,19),(56,13,19),(57,11,20),(58,12,20),(59,3,20),(60,4,21),(61,6,21),(62,5,22),(63,8,22),(64,3,22),(65,2,23),(66,11,23),(67,7,24),(68,9,24),(69,12,24),(70,6,25),(71,13,25),(72,1,25),(73,5,26),(74,4,26),(75,4,27),(76,2,27),(77,10,27),(78,4,28),(79,10,28),(80,8,28),(81,11,29),(82,14,29),(83,6,29),(84,3,30),(85,2,30),(86,12,30),(87,2,31),(88,5,31),(89,9,31);

--
-- Table structure for table `ec_product_collection_products`
--

CREATE TABLE `ec_product_collection_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_collection_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_product_collection_products_product_collection_id_index` (`product_collection_id`),
  KEY `ec_product_collection_products_product_id_index` (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_collection_products`
--

INSERT INTO `ec_product_collection_products` VALUES (1,1,1),(2,1,2),(3,2,3),(4,3,4),(5,3,5),(6,1,6),(7,2,7),(8,3,8),(9,3,9),(10,3,10),(11,3,11),(12,1,12),(13,1,13),(14,2,14),(15,3,15),(16,3,16),(17,3,17),(18,1,18),(19,2,19),(20,2,20),(21,2,21),(22,2,22),(23,1,23),(24,1,24),(25,2,25),(26,3,26),(27,1,27),(28,2,28),(29,3,29),(30,3,30),(31,3,31);

--
-- Table structure for table `ec_product_collections`
--

CREATE TABLE `ec_product_collections` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_featured` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_collections`
--

INSERT INTO `ec_product_collections` VALUES (1,'New Arrival','new-arrival',NULL,NULL,'published','2021-07-02 21:02:32','2021-07-02 21:02:32',0),(2,'Best Sellers','best-sellers',NULL,NULL,'published','2021-07-02 21:02:32','2021-07-02 21:02:32',0),(3,'Special Offer','special-offer',NULL,NULL,'published','2021-07-02 21:02:32','2021-07-02 21:02:32',0);

--
-- Table structure for table `ec_product_cross_sale_relations`
--

CREATE TABLE `ec_product_cross_sale_relations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from_product_id` int(10) unsigned NOT NULL,
  `to_product_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_product_cross_sale_relations_from_product_id_index` (`from_product_id`),
  KEY `ec_product_cross_sale_relations_to_product_id_index` (`to_product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=587 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_cross_sale_relations`
--

INSERT INTO `ec_product_cross_sale_relations` VALUES (233,2,12),(365,19,2),(370,21,3),(383,1,10),(390,3,13),(393,4,1),(394,4,14),(396,4,2),(397,5,1),(406,7,30),(407,8,17),(418,12,4),(452,22,3),(454,22,21),(458,23,5),(464,25,28),(466,26,5),(473,28,1),(479,29,10),(481,30,23),(485,31,10),(488,1,19),(489,1,30),(490,1,20),(491,2,11),(492,2,30),(493,2,3),(494,3,26),(495,3,31),(496,3,28),(497,4,27),(498,5,2),(499,5,9),(500,5,4),(501,6,8),(502,6,12),(503,6,22),(504,6,11),(505,7,29),(506,7,15),(507,7,2),(508,8,21),(509,8,11),(510,8,25),(511,9,6),(512,9,26),(513,9,28),(514,9,17),(515,10,18),(516,10,26),(517,10,23),(518,11,25),(519,11,10),(520,11,1),(521,11,22),(522,12,18),(523,12,17),(524,13,28),(525,13,3),(526,13,11),(527,14,17),(528,14,2),(529,14,6),(530,14,5),(531,15,27),(532,15,28),(533,15,14),(534,15,5),(535,16,31),(536,16,8),(537,16,18),(538,16,2),(539,17,8),(540,17,28),(541,17,23),(542,17,9),(543,18,23),(544,18,5),(545,18,13),(546,18,15),(547,19,15),(548,19,24),(549,19,1),(550,20,8),(551,20,7),(552,20,13),(553,20,22),(554,21,5),(555,21,28),(556,21,19),(557,22,11),(558,22,9),(559,23,31),(560,23,10),(561,23,15),(562,24,20),(563,24,28),(564,24,3),(565,24,26),(566,25,23),(567,25,3),(568,26,14),(569,26,28),(570,26,17),(571,27,16),(572,27,26),(573,27,23),(574,27,1),(575,28,15),(576,28,18),(577,28,11),(578,29,11),(579,29,4),(580,29,3),(581,30,21),(582,30,25),(583,30,15),(584,31,5),(585,31,12),(586,31,22);

--
-- Table structure for table `ec_product_label_products`
--

CREATE TABLE `ec_product_label_products` (
  `product_label_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`product_label_id`,`product_id`),
  KEY `ec_product_label_products_product_label_id_index` (`product_label_id`),
  KEY `ec_product_label_products_product_id_index` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_label_products`
--

INSERT INTO `ec_product_label_products` VALUES (1,12),(1,18),(1,24),(2,9),(2,15),(2,21),(3,3),(3,6),(3,27),(3,30);

--
-- Table structure for table `ec_product_labels`
--

CREATE TABLE `ec_product_labels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_labels`
--

INSERT INTO `ec_product_labels` VALUES (1,'Hot','#ec2434','published','2021-07-02 21:02:32','2021-07-02 21:02:32'),(2,'New','#00c9a7','published','2021-07-02 21:02:32','2021-07-02 21:02:32'),(3,'Sale','#fe9931','published','2021-07-02 21:02:32','2021-07-02 21:02:32');

--
-- Table structure for table `ec_product_related_relations`
--

CREATE TABLE `ec_product_related_relations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from_product_id` int(10) unsigned NOT NULL,
  `to_product_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_product_related_relations_from_product_id_index` (`from_product_id`),
  KEY `ec_product_related_relations_to_product_id_index` (`to_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_related_relations`
--


--
-- Table structure for table `ec_product_tag_product`
--

CREATE TABLE `ec_product_tag_product` (
  `product_id` int(10) unsigned NOT NULL,
  `tag_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`product_id`,`tag_id`),
  KEY `ec_product_tag_product_product_id_index` (`product_id`),
  KEY `ec_product_tag_product_tag_id_index` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_tag_product`
--

INSERT INTO `ec_product_tag_product` VALUES (1,2),(1,4),(1,5),(2,2),(2,5),(3,2),(3,4),(3,5),(4,4),(4,5),(4,6),(5,4),(5,5),(6,1),(6,5),(7,3),(7,5),(8,1),(8,2),(8,6),(9,3),(9,5),(10,1),(10,4),(11,3),(11,5),(11,6),(12,1),(12,4),(12,5),(13,5),(13,6),(14,3),(14,4),(15,2),(15,4),(16,5),(16,6),(17,1),(17,2),(18,3),(18,4),(19,1),(19,3),(19,4),(20,1),(20,6),(21,5),(21,6),(22,2),(22,4),(22,5),(23,1),(23,2),(23,5),(24,3),(24,6),(25,2),(25,4),(26,2),(26,3),(26,4),(27,3),(27,6),(28,2),(28,3),(29,2),(29,5),(29,6),(30,3),(30,4),(31,3),(31,4),(31,5);

--
-- Table structure for table `ec_product_tags`
--

CREATE TABLE `ec_product_tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_tags`
--

INSERT INTO `ec_product_tags` VALUES (1,'Electronic',NULL,'published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(2,'Mobile',NULL,'published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(3,'Iphone',NULL,'published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(4,'Printer',NULL,'published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(5,'Office',NULL,'published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(6,'IT',NULL,'published','2021-07-02 21:03:24','2021-07-02 21:03:24');

--
-- Table structure for table `ec_product_up_sale_relations`
--

CREATE TABLE `ec_product_up_sale_relations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from_product_id` int(10) unsigned NOT NULL,
  `to_product_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_product_up_sale_relations_from_product_id_index` (`from_product_id`),
  KEY `ec_product_up_sale_relations_to_product_id_index` (`to_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_up_sale_relations`
--


--
-- Table structure for table `ec_product_variation_items`
--

CREATE TABLE `ec_product_variation_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_id` int(10) unsigned NOT NULL,
  `variation_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_variation_items`
--

INSERT INTO `ec_product_variation_items` VALUES (1,4,1),(2,6,1),(3,3,2),(4,9,2),(5,5,3),(6,9,3),(7,2,4),(8,9,4),(9,4,5),(10,10,5),(11,4,6),(12,9,6),(13,1,7),(14,10,7),(15,3,8),(16,10,8),(17,3,9),(18,10,9),(19,2,10),(20,7,10),(21,5,11),(22,9,11),(23,5,12),(24,8,12),(25,3,13),(26,8,13),(27,3,14),(28,10,14),(29,3,15),(30,10,15),(31,5,16),(32,6,16),(33,3,17),(34,10,17),(35,5,18),(36,10,18),(37,4,19),(38,7,19),(39,2,20),(40,6,20),(41,2,21),(42,9,21),(43,1,22),(44,9,22),(45,2,23),(46,6,23),(47,2,24),(48,8,24),(49,4,25),(50,8,25),(51,2,26),(52,6,26),(53,2,27),(54,9,27),(55,2,28),(56,6,28),(57,2,29),(58,8,29),(59,2,30),(60,9,30),(61,2,31),(62,8,31),(63,5,32),(64,7,32),(65,4,33),(66,8,33),(67,4,34),(68,6,34),(69,4,35),(70,6,35),(71,5,36),(72,6,36),(73,4,37),(74,10,37),(75,3,38),(76,7,38),(77,2,39),(78,9,39),(79,3,40),(80,10,40),(81,1,41),(82,7,41),(83,4,42),(84,7,42),(85,1,43),(86,10,43),(87,3,44),(88,10,44),(89,2,45),(90,9,45),(91,1,46),(92,6,46),(93,5,47),(94,8,47),(95,4,48),(96,7,48),(97,4,49),(98,6,49),(99,4,50),(100,10,50),(101,5,51),(102,7,51),(103,4,52),(104,6,52),(105,3,53),(106,10,53),(107,1,54),(108,8,54),(109,4,55),(110,10,55),(111,1,56),(112,9,56),(113,2,57),(114,8,57),(115,3,58),(116,8,58),(117,5,59),(118,8,59),(119,3,60),(120,9,60),(121,3,61),(122,10,61),(123,3,62),(124,7,62),(125,5,63),(126,9,63),(127,5,64),(128,8,64),(129,1,65),(130,10,65),(131,1,66),(132,7,66),(133,2,67),(134,8,67),(135,3,68),(136,9,68),(137,3,69),(138,6,69),(139,1,70),(140,6,70),(141,3,71),(142,10,71),(143,3,72),(144,6,72),(145,4,73),(146,9,73),(147,4,74),(148,9,74);

--
-- Table structure for table `ec_product_variations`
--

CREATE TABLE `ec_product_variations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(10) unsigned DEFAULT NULL,
  `configurable_product_id` int(10) unsigned NOT NULL,
  `is_default` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_variations`
--

INSERT INTO `ec_product_variations` VALUES (1,32,1,1),(2,33,1,0),(3,34,2,1),(4,35,2,0),(5,36,3,1),(6,37,3,0),(7,38,3,0),(8,39,4,1),(9,40,4,0),(10,41,4,0),(11,42,5,1),(12,43,5,0),(13,44,6,1),(14,45,6,0),(15,46,6,0),(16,47,7,1),(17,48,7,0),(18,49,7,0),(19,50,8,1),(20,51,8,0),(21,52,9,1),(22,53,9,0),(23,54,9,0),(24,55,9,0),(25,56,10,1),(26,57,11,1),(27,58,11,0),(28,59,12,1),(29,60,12,0),(30,61,12,0),(31,62,12,0),(32,63,13,1),(33,64,14,1),(34,65,14,0),(35,66,15,1),(36,67,15,0),(37,68,15,0),(38,69,16,1),(39,70,17,1),(40,71,18,1),(41,72,18,0),(42,73,18,0),(43,74,19,1),(44,75,19,0),(45,76,20,1),(46,77,21,1),(47,78,21,0),(48,79,21,0),(49,80,22,1),(50,81,22,0),(51,82,23,1),(52,83,23,0),(53,84,23,0),(54,85,24,1),(55,86,24,0),(56,87,25,1),(57,88,25,0),(58,89,25,0),(59,90,26,1),(60,91,26,0),(61,92,26,0),(62,93,27,1),(63,94,27,0),(64,95,27,0),(65,96,28,1),(66,97,28,0),(67,98,28,0),(68,99,29,1),(69,100,29,0),(70,101,29,0),(71,102,30,1),(72,103,30,0),(73,104,31,1),(74,105,31,0);

--
-- Table structure for table `ec_product_with_attribute`
--

CREATE TABLE `ec_product_with_attribute` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_with_attribute`
--

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

--
-- Table structure for table `ec_product_with_attribute_set`
--

CREATE TABLE `ec_product_with_attribute_set` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_set_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_with_attribute_set`
--

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

--
-- Table structure for table `ec_products`
--

CREATE TABLE `ec_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `images` text COLLATE utf8mb4_unicode_ci,
  `sku` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int(10) unsigned NOT NULL DEFAULT '0',
  `quantity` int(10) unsigned DEFAULT NULL,
  `allow_checkout_when_out_of_stock` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `with_storehouse_management` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `is_featured` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `options` text COLLATE utf8mb4_unicode_ci,
  `category_id` int(10) unsigned DEFAULT NULL,
  `brand_id` int(10) unsigned DEFAULT NULL,
  `is_variation` tinyint(4) NOT NULL DEFAULT '0',
  `is_searchable` tinyint(4) NOT NULL DEFAULT '0',
  `is_show_on_list` tinyint(4) NOT NULL DEFAULT '0',
  `sale_type` tinyint(4) NOT NULL DEFAULT '0',
  `price` double unsigned DEFAULT NULL,
  `sale_price` double unsigned DEFAULT NULL,
  `start_date` timestamp NULL DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  `length` double(8,2) DEFAULT NULL,
  `wide` double(8,2) DEFAULT NULL,
  `height` double(8,2) DEFAULT NULL,
  `weight` double(8,2) DEFAULT NULL,
  `barcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `length_unit` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wide_unit` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `height_unit` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight_unit` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tax_id` int(10) unsigned DEFAULT NULL,
  `views` bigint(20) NOT NULL DEFAULT '0',
  `stock_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'in_stock',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_products`
--

INSERT INTO `ec_products` VALUES (1,'Smart Home Speaker','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/1.jpg\",\"products\\/1-1.jpg\",\"products\\/1-2.jpg\",\"products\\/1-3.jpg\"]','HS-185-A0',0,20,0,1,1,NULL,NULL,7,0,0,0,0,431,NULL,NULL,NULL,17.00,17.00,18.00,771.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,27035,'in_stock'),(2,'Headphone Ultra Bass','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/2.jpg\",\"products\\/2-1.jpg\",\"products\\/2-2.jpg\",\"products\\/2-3.jpg\"]','HS-109-A0',0,15,0,1,1,NULL,NULL,2,0,0,0,0,330,NULL,NULL,NULL,19.00,17.00,16.00,526.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,158163,'in_stock'),(3,'Boxed - Bluetooth Headphone','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/3.jpg\",\"products\\/3-1.jpg\",\"products\\/3-2.jpg\",\"products\\/3-3.jpg\"]','HS-191-A0',0,11,0,1,1,NULL,NULL,2,0,0,0,0,374,NULL,NULL,NULL,15.00,14.00,20.00,828.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,194826,'in_stock'),(4,'Chikie - Bluetooth Speaker','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/4.jpg\",\"products\\/4-1.jpg\",\"products\\/4-2.jpg\",\"products\\/4-3.jpg\"]','HS-147-A0',0,19,0,1,1,NULL,NULL,7,0,0,0,0,90,81,NULL,NULL,16.00,12.00,14.00,861.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,115540,'in_stock'),(5,'Camera Hikvision HK-35VS8','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/5.jpg\",\"products\\/5-1.jpg\",\"products\\/5-2.jpg\",\"products\\/5-3.jpg\"]','HS-151-A0',0,20,0,1,1,NULL,NULL,5,0,0,0,0,46,NULL,NULL,NULL,13.00,14.00,11.00,896.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,116333,'in_stock'),(6,'Camera Samsung SS-24','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/6.jpg\",\"products\\/6-1.jpg\"]','HS-189-A0',0,15,0,1,1,NULL,NULL,1,0,0,0,0,55,NULL,NULL,NULL,16.00,20.00,17.00,699.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,157014,'in_stock'),(7,'Leather Watch Band','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/7.jpg\",\"products\\/7-1.jpg\"]','HS-122-A0',0,18,0,1,1,NULL,NULL,4,0,0,0,0,111,NULL,NULL,NULL,17.00,12.00,10.00,583.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,30595,'in_stock'),(8,'Apple iPhone 13 Plus','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/8.jpg\",\"products\\/8-1.jpg\"]','HS-148-A0',0,17,0,1,1,NULL,NULL,5,0,0,0,0,113,96.05,NULL,NULL,14.00,17.00,13.00,572.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,160452,'in_stock'),(9,'Macbook Pro 2015','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/9.jpg\",\"products\\/9-1.jpg\"]','HS-197-A0',0,19,0,1,1,NULL,NULL,5,0,0,0,0,110,NULL,NULL,NULL,19.00,19.00,19.00,761.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,91049,'in_stock'),(10,'Macbook Air 12 inch','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/10.jpg\",\"products\\/10-1.jpg\"]','HS-132-A0',0,14,0,1,1,NULL,NULL,2,0,0,0,0,404,NULL,NULL,NULL,10.00,20.00,15.00,710.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,22481,'in_stock'),(11,'Apple Watch Serial 7','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/11.jpg\",\"products\\/11-1.jpg\"]','HS-195-A0',0,12,0,1,1,NULL,NULL,3,0,0,0,0,118,NULL,NULL,NULL,15.00,10.00,14.00,644.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,46934,'in_stock'),(12,'Macbook Pro 13 inch','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/12.jpg\",\"products\\/12-1.jpg\"]','HS-189-A0',0,12,0,1,1,NULL,NULL,7,0,0,0,0,120,100.8,NULL,NULL,18.00,10.00,15.00,565.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,162842,'in_stock'),(13,'Apple Keyboard','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/13.jpg\",\"products\\/13-1.jpg\"]','HS-153-A0',0,12,0,1,1,NULL,NULL,2,0,0,0,0,123,NULL,NULL,NULL,17.00,15.00,11.00,781.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,39408,'in_stock'),(14,'MacSafe 80W','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/14.jpg\",\"products\\/14-1.jpg\"]','HS-143-A0',0,16,0,1,1,NULL,NULL,6,0,0,0,0,111,NULL,NULL,NULL,16.00,16.00,12.00,646.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,117631,'in_stock'),(15,'Hand playstation','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/15.jpg\",\"products\\/15-1.jpg\"]','HS-137-A0',0,16,0,1,1,NULL,NULL,1,0,0,0,0,110,NULL,NULL,NULL,20.00,18.00,15.00,510.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,84921,'in_stock'),(16,'Apple Airpods Serial 3','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/16.jpg\"]','HS-148-A0',0,17,0,1,1,NULL,NULL,7,0,0,0,0,127,92.71,NULL,NULL,20.00,15.00,10.00,724.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,28484,'in_stock'),(17,'Cool Smart Watches','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/17.jpg\"]','HS-130-A0',0,15,0,1,1,NULL,NULL,3,0,0,0,0,122,NULL,NULL,NULL,14.00,18.00,17.00,845.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,49203,'in_stock'),(18,'Black Smart Watches','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/18.jpg\",\"products\\/18-1.jpg\",\"products\\/18-2.jpg\"]','HS-122-A0',0,20,0,1,1,NULL,NULL,7,0,0,0,0,110,NULL,NULL,NULL,12.00,17.00,11.00,865.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,180890,'in_stock'),(19,'Leather Watch Band Serial 3','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/19.jpg\",\"products\\/19-1.jpg\"]','HS-160-A0',0,12,0,1,1,NULL,NULL,3,0,0,0,0,121,NULL,NULL,NULL,11.00,10.00,16.00,631.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,97452,'in_stock'),(20,'Macbook Pro 2015 13 inch','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/20.jpg\",\"products\\/20-1.jpg\"]','HS-150-A0',0,12,0,1,1,NULL,NULL,1,0,0,0,0,125,110,NULL,NULL,19.00,16.00,10.00,731.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,73684,'in_stock'),(21,'Historic Alarm Clock','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/21.jpg\",\"products\\/21-1.jpg\"]','HS-186-A0',0,13,0,1,1,NULL,NULL,2,0,0,0,0,119,NULL,NULL,NULL,16.00,20.00,14.00,836.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,35702,'in_stock'),(22,'Black Glasses','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/22.jpg\",\"products\\/22-1.jpg\"]','HS-148-A0',0,20,0,1,1,NULL,NULL,5,0,0,0,0,115,NULL,NULL,NULL,19.00,18.00,13.00,694.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,100796,'in_stock'),(23,'Phillips Mouse','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/23.jpg\",\"products\\/23-1.jpg\"]','HS-173-A0',0,18,0,1,1,NULL,NULL,6,0,0,0,0,122,NULL,NULL,NULL,20.00,12.00,14.00,687.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,155981,'in_stock'),(24,'Gaming Keyboard','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/24.jpg\",\"products\\/24-1.jpg\"]','HS-143-A0',0,17,0,1,1,NULL,NULL,4,0,0,0,0,115,80.5,NULL,NULL,14.00,16.00,20.00,825.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,51017,'in_stock'),(25,'Dual Camera 20MP','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/25.jpg\",\"products\\/25-1.jpg\"]','HS-156-A0',0,13,0,1,0,NULL,NULL,7,0,0,0,0,80.25,NULL,NULL,NULL,11.00,16.00,11.00,741.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,12944,'in_stock'),(26,'Smart Watches','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/26.jpg\",\"products\\/26-1.jpg\",\"products\\/26-2.jpg\"]','HS-127-A0',0,15,0,1,0,NULL,NULL,4,0,0,0,0,40.5,NULL,NULL,NULL,17.00,15.00,17.00,772.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,2757,'in_stock'),(27,'Beat Headphone','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/27.jpg\",\"products\\/27-1.jpg\"]','HS-140-A0',0,14,0,1,0,NULL,NULL,7,0,0,0,0,20,NULL,NULL,NULL,17.00,12.00,11.00,697.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,54823,'in_stock'),(28,'Red & Black Headphone','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/28.jpg\",\"products\\/28-1.jpg\"]','HS-153-A0',0,17,0,1,0,NULL,NULL,4,0,0,0,0,57,43.32,NULL,NULL,14.00,18.00,16.00,610.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,31624,'in_stock'),(29,'Audio Equipment','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/29.jpg\",\"products\\/29-1.jpg\"]','HS-112-A0',0,12,0,1,0,NULL,NULL,7,0,0,0,0,54,NULL,NULL,NULL,11.00,14.00,16.00,801.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,6810,'in_stock'),(30,'Smart Televisions','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/30.jpg\",\"products\\/30-1.jpg\"]','HS-177-A0',0,20,0,1,0,NULL,NULL,1,0,0,0,0,116,NULL,NULL,NULL,16.00,19.00,15.00,525.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:23','2021-07-02 21:03:24',1,90468,'in_stock'),(31,'Samsung Smart TV','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.</p>','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.</p>\n                                <p>- Casual unisex fit</p>\n\n                                <p>- 64% polyester, 36% polyurethane</p>\n\n                                <p>- Water column pressure: 4000 mm</p>\n\n                                <p>- Model is 187cm tall and wearing a size S / M</p>\n\n                                <p>- Unisex fit</p>\n\n                                <p>- Drawstring hood with built-in cap</p>\n\n                                <p>- Front placket with snap buttons</p>\n\n                                <p>- Ventilation under armpit</p>\n\n                                <p>- Adjustable cuffs</p>\n\n                                <p>- Double welted front pockets</p>\n\n                                <p>- Adjustable elastic string at hempen</p>\n\n                                <p>- Ultrasonically welded seams</p>\n\n                                <p>This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.</p>','published','[\"products\\/31.jpg\",\"products\\/31-1.jpg\"]','HS-100-A0',0,15,0,1,0,NULL,NULL,7,0,0,0,0,54,NULL,NULL,NULL,19.00,13.00,16.00,605.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',1,72105,'in_stock'),(32,'Smart Home Speaker',NULL,NULL,'published','[\"products\\/1.jpg\"]','HS-185-A0',0,20,0,1,0,NULL,NULL,7,1,0,0,0,431,NULL,NULL,NULL,17.00,17.00,18.00,771.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(33,'Smart Home Speaker',NULL,NULL,'published','[\"products\\/1-1.jpg\"]','HS-185-A0-A1',0,20,0,1,0,NULL,NULL,7,1,0,0,0,431,NULL,NULL,NULL,17.00,17.00,18.00,771.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(34,'Headphone Ultra Bass',NULL,NULL,'published','[\"products\\/2.jpg\"]','HS-109-A0',0,15,0,1,0,NULL,NULL,2,1,0,0,0,330,NULL,NULL,NULL,19.00,17.00,16.00,526.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(35,'Headphone Ultra Bass',NULL,NULL,'published','[\"products\\/2-1.jpg\"]','HS-109-A0-A1',0,15,0,1,0,NULL,NULL,2,1,0,0,0,330,NULL,NULL,NULL,19.00,17.00,16.00,526.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(36,'Boxed - Bluetooth Headphone',NULL,NULL,'published','[\"products\\/3.jpg\"]','HS-191-A0',0,11,0,1,0,NULL,NULL,2,1,0,0,0,374,NULL,NULL,NULL,15.00,14.00,20.00,828.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(37,'Boxed - Bluetooth Headphone',NULL,NULL,'published','[\"products\\/3-1.jpg\"]','HS-191-A0-A1',0,11,0,1,0,NULL,NULL,2,1,0,0,0,374,NULL,NULL,NULL,15.00,14.00,20.00,828.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(38,'Boxed - Bluetooth Headphone',NULL,NULL,'published','[\"products\\/3-2.jpg\"]','HS-191-A0-A2',0,11,0,1,0,NULL,NULL,2,1,0,0,0,374,NULL,NULL,NULL,15.00,14.00,20.00,828.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(39,'Chikie - Bluetooth Speaker',NULL,NULL,'published','[\"products\\/4.jpg\"]','HS-147-A0',0,19,0,1,0,NULL,NULL,7,1,0,0,0,90,81,NULL,NULL,16.00,12.00,14.00,861.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(40,'Chikie - Bluetooth Speaker',NULL,NULL,'published','[\"products\\/4-1.jpg\"]','HS-147-A0-A1',0,19,0,1,0,NULL,NULL,7,1,0,0,0,90,77.4,NULL,NULL,16.00,12.00,14.00,861.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(41,'Chikie - Bluetooth Speaker',NULL,NULL,'published','[\"products\\/4-2.jpg\"]','HS-147-A0-A2',0,19,0,1,0,NULL,NULL,7,1,0,0,0,90,71.1,NULL,NULL,16.00,12.00,14.00,861.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(42,'Camera Hikvision HK-35VS8',NULL,NULL,'published','[\"products\\/5.jpg\"]','HS-151-A0',0,20,0,1,0,NULL,NULL,5,1,0,0,0,46,NULL,NULL,NULL,13.00,14.00,11.00,896.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(43,'Camera Hikvision HK-35VS8',NULL,NULL,'published','[\"products\\/5-1.jpg\"]','HS-151-A0-A1',0,20,0,1,0,NULL,NULL,5,1,0,0,0,46,NULL,NULL,NULL,13.00,14.00,11.00,896.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(44,'Camera Samsung SS-24',NULL,NULL,'published','[\"products\\/6.jpg\"]','HS-189-A0',0,15,0,1,0,NULL,NULL,1,1,0,0,0,55,NULL,NULL,NULL,16.00,20.00,17.00,699.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(45,'Camera Samsung SS-24',NULL,NULL,'published','[\"products\\/6-1.jpg\"]','HS-189-A0-A1',0,15,0,1,0,NULL,NULL,1,1,0,0,0,55,NULL,NULL,NULL,16.00,20.00,17.00,699.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(46,'Camera Samsung SS-24',NULL,NULL,'published','[\"products\\/6.jpg\"]','HS-189-A0-A2',0,15,0,1,0,NULL,NULL,1,1,0,0,0,55,NULL,NULL,NULL,16.00,20.00,17.00,699.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(47,'Leather Watch Band',NULL,NULL,'published','[\"products\\/7.jpg\"]','HS-122-A0',0,18,0,1,0,NULL,NULL,4,1,0,0,0,111,NULL,NULL,NULL,17.00,12.00,10.00,583.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(48,'Leather Watch Band',NULL,NULL,'published','[\"products\\/7-1.jpg\"]','HS-122-A0-A1',0,18,0,1,0,NULL,NULL,4,1,0,0,0,111,NULL,NULL,NULL,17.00,12.00,10.00,583.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(49,'Leather Watch Band',NULL,NULL,'published','[\"products\\/7.jpg\"]','HS-122-A0-A2',0,18,0,1,0,NULL,NULL,4,1,0,0,0,111,NULL,NULL,NULL,17.00,12.00,10.00,583.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(50,'Apple iPhone 13 Plus',NULL,NULL,'published','[\"products\\/8.jpg\"]','HS-148-A0',0,17,0,1,0,NULL,NULL,5,1,0,0,0,113,96.05,NULL,NULL,14.00,17.00,13.00,572.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(51,'Apple iPhone 13 Plus',NULL,NULL,'published','[\"products\\/8-1.jpg\"]','HS-148-A0-A1',0,17,0,1,0,NULL,NULL,5,1,0,0,0,113,90.4,NULL,NULL,14.00,17.00,13.00,572.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(52,'Macbook Pro 2015',NULL,NULL,'published','[\"products\\/9.jpg\"]','HS-197-A0',0,19,0,1,0,NULL,NULL,5,1,0,0,0,110,NULL,NULL,NULL,19.00,19.00,19.00,761.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(53,'Macbook Pro 2015',NULL,NULL,'published','[\"products\\/9-1.jpg\"]','HS-197-A0-A1',0,19,0,1,0,NULL,NULL,5,1,0,0,0,110,NULL,NULL,NULL,19.00,19.00,19.00,761.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(54,'Macbook Pro 2015',NULL,NULL,'published','[\"products\\/9.jpg\"]','HS-197-A0-A2',0,19,0,1,0,NULL,NULL,5,1,0,0,0,110,NULL,NULL,NULL,19.00,19.00,19.00,761.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(55,'Macbook Pro 2015',NULL,NULL,'published','[\"products\\/9.jpg\"]','HS-197-A0-A3',0,19,0,1,0,NULL,NULL,5,1,0,0,0,110,NULL,NULL,NULL,19.00,19.00,19.00,761.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(56,'Macbook Air 12 inch',NULL,NULL,'published','[\"products\\/10.jpg\"]','HS-132-A0',0,14,0,1,0,NULL,NULL,2,1,0,0,0,404,NULL,NULL,NULL,10.00,20.00,15.00,710.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(57,'Apple Watch Serial 7',NULL,NULL,'published','[\"products\\/11.jpg\"]','HS-195-A0',0,12,0,1,0,NULL,NULL,3,1,0,0,0,118,NULL,NULL,NULL,15.00,10.00,14.00,644.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(58,'Apple Watch Serial 7',NULL,NULL,'published','[\"products\\/11-1.jpg\"]','HS-195-A0-A1',0,12,0,1,0,NULL,NULL,3,1,0,0,0,118,NULL,NULL,NULL,15.00,10.00,14.00,644.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(59,'Macbook Pro 13 inch',NULL,NULL,'published','[\"products\\/12.jpg\"]','HS-189-A0',0,12,0,1,0,NULL,NULL,7,1,0,0,0,120,100.8,NULL,NULL,18.00,10.00,15.00,565.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(60,'Macbook Pro 13 inch',NULL,NULL,'published','[\"products\\/12-1.jpg\"]','HS-189-A0-A1',0,12,0,1,0,NULL,NULL,7,1,0,0,0,120,87.6,NULL,NULL,18.00,10.00,15.00,565.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(61,'Macbook Pro 13 inch',NULL,NULL,'published','[\"products\\/12.jpg\"]','HS-189-A0-A2',0,12,0,1,0,NULL,NULL,7,1,0,0,0,120,94.8,NULL,NULL,18.00,10.00,15.00,565.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(62,'Macbook Pro 13 inch',NULL,NULL,'published','[\"products\\/12.jpg\"]','HS-189-A0-A3',0,12,0,1,0,NULL,NULL,7,1,0,0,0,120,103.2,NULL,NULL,18.00,10.00,15.00,565.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(63,'Apple Keyboard',NULL,NULL,'published','[\"products\\/13.jpg\"]','HS-153-A0',0,12,0,1,0,NULL,NULL,2,1,0,0,0,123,NULL,NULL,NULL,17.00,15.00,11.00,781.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(64,'MacSafe 80W',NULL,NULL,'published','[\"products\\/14.jpg\"]','HS-143-A0',0,16,0,1,0,NULL,NULL,6,1,0,0,0,111,NULL,NULL,NULL,16.00,16.00,12.00,646.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(65,'MacSafe 80W',NULL,NULL,'published','[\"products\\/14-1.jpg\"]','HS-143-A0-A1',0,16,0,1,0,NULL,NULL,6,1,0,0,0,111,NULL,NULL,NULL,16.00,16.00,12.00,646.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(66,'Hand playstation',NULL,NULL,'published','[\"products\\/15.jpg\"]','HS-137-A0',0,16,0,1,0,NULL,NULL,1,1,0,0,0,110,NULL,NULL,NULL,20.00,18.00,15.00,510.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(67,'Hand playstation',NULL,NULL,'published','[\"products\\/15-1.jpg\"]','HS-137-A0-A1',0,16,0,1,0,NULL,NULL,1,1,0,0,0,110,NULL,NULL,NULL,20.00,18.00,15.00,510.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(68,'Hand playstation',NULL,NULL,'published','[\"products\\/15.jpg\"]','HS-137-A0-A2',0,16,0,1,0,NULL,NULL,1,1,0,0,0,110,NULL,NULL,NULL,20.00,18.00,15.00,510.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(69,'Apple Airpods Serial 3',NULL,NULL,'published','[\"products\\/16.jpg\"]','HS-148-A0',0,17,0,1,0,NULL,NULL,7,1,0,0,0,127,92.71,NULL,NULL,20.00,15.00,10.00,724.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(70,'Cool Smart Watches',NULL,NULL,'published','[\"products\\/17.jpg\"]','HS-130-A0',0,15,0,1,0,NULL,NULL,3,1,0,0,0,122,NULL,NULL,NULL,14.00,18.00,17.00,845.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(71,'Black Smart Watches',NULL,NULL,'published','[\"products\\/18.jpg\"]','HS-122-A0',0,20,0,1,0,NULL,NULL,7,1,0,0,0,110,NULL,NULL,NULL,12.00,17.00,11.00,865.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(72,'Black Smart Watches',NULL,NULL,'published','[\"products\\/18-1.jpg\"]','HS-122-A0-A1',0,20,0,1,0,NULL,NULL,7,1,0,0,0,110,NULL,NULL,NULL,12.00,17.00,11.00,865.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(73,'Black Smart Watches',NULL,NULL,'published','[\"products\\/18-2.jpg\"]','HS-122-A0-A2',0,20,0,1,0,NULL,NULL,7,1,0,0,0,110,NULL,NULL,NULL,12.00,17.00,11.00,865.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(74,'Leather Watch Band Serial 3',NULL,NULL,'published','[\"products\\/19.jpg\"]','HS-160-A0',0,12,0,1,0,NULL,NULL,3,1,0,0,0,121,NULL,NULL,NULL,11.00,10.00,16.00,631.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(75,'Leather Watch Band Serial 3',NULL,NULL,'published','[\"products\\/19-1.jpg\"]','HS-160-A0-A1',0,12,0,1,0,NULL,NULL,3,1,0,0,0,121,NULL,NULL,NULL,11.00,10.00,16.00,631.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(76,'Macbook Pro 2015 13 inch',NULL,NULL,'published','[\"products\\/20.jpg\"]','HS-150-A0',0,12,0,1,0,NULL,NULL,1,1,0,0,0,125,110,NULL,NULL,19.00,16.00,10.00,731.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(77,'Historic Alarm Clock',NULL,NULL,'published','[\"products\\/21.jpg\"]','HS-186-A0',0,13,0,1,0,NULL,NULL,2,1,0,0,0,119,NULL,NULL,NULL,16.00,20.00,14.00,836.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(78,'Historic Alarm Clock',NULL,NULL,'published','[\"products\\/21-1.jpg\"]','HS-186-A0-A1',0,13,0,1,0,NULL,NULL,2,1,0,0,0,119,NULL,NULL,NULL,16.00,20.00,14.00,836.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(79,'Historic Alarm Clock',NULL,NULL,'published','[\"products\\/21.jpg\"]','HS-186-A0-A2',0,13,0,1,0,NULL,NULL,2,1,0,0,0,119,NULL,NULL,NULL,16.00,20.00,14.00,836.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(80,'Black Glasses',NULL,NULL,'published','[\"products\\/22.jpg\"]','HS-148-A0',0,20,0,1,0,NULL,NULL,5,1,0,0,0,115,NULL,NULL,NULL,19.00,18.00,13.00,694.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(81,'Black Glasses',NULL,NULL,'published','[\"products\\/22-1.jpg\"]','HS-148-A0-A1',0,20,0,1,0,NULL,NULL,5,1,0,0,0,115,NULL,NULL,NULL,19.00,18.00,13.00,694.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(82,'Phillips Mouse',NULL,NULL,'published','[\"products\\/23.jpg\"]','HS-173-A0',0,18,0,1,0,NULL,NULL,6,1,0,0,0,122,NULL,NULL,NULL,20.00,12.00,14.00,687.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(83,'Phillips Mouse',NULL,NULL,'published','[\"products\\/23-1.jpg\"]','HS-173-A0-A1',0,18,0,1,0,NULL,NULL,6,1,0,0,0,122,NULL,NULL,NULL,20.00,12.00,14.00,687.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(84,'Phillips Mouse',NULL,NULL,'published','[\"products\\/23.jpg\"]','HS-173-A0-A2',0,18,0,1,0,NULL,NULL,6,1,0,0,0,122,NULL,NULL,NULL,20.00,12.00,14.00,687.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(85,'Gaming Keyboard',NULL,NULL,'published','[\"products\\/24.jpg\"]','HS-143-A0',0,17,0,1,0,NULL,NULL,4,1,0,0,0,115,80.5,NULL,NULL,14.00,16.00,20.00,825.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(86,'Gaming Keyboard',NULL,NULL,'published','[\"products\\/24-1.jpg\"]','HS-143-A0-A1',0,17,0,1,0,NULL,NULL,4,1,0,0,0,115,97.75,NULL,NULL,14.00,16.00,20.00,825.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(87,'Dual Camera 20MP',NULL,NULL,'published','[\"products\\/25.jpg\"]','HS-156-A0',0,13,0,1,0,NULL,NULL,7,1,0,0,0,80.25,NULL,NULL,NULL,11.00,16.00,11.00,741.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(88,'Dual Camera 20MP',NULL,NULL,'published','[\"products\\/25-1.jpg\"]','HS-156-A0-A1',0,13,0,1,0,NULL,NULL,7,1,0,0,0,80.25,NULL,NULL,NULL,11.00,16.00,11.00,741.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(89,'Dual Camera 20MP',NULL,NULL,'published','[\"products\\/25.jpg\"]','HS-156-A0-A2',0,13,0,1,0,NULL,NULL,7,1,0,0,0,80.25,NULL,NULL,NULL,11.00,16.00,11.00,741.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(90,'Smart Watches',NULL,NULL,'published','[\"products\\/26.jpg\"]','HS-127-A0',0,15,0,1,0,NULL,NULL,4,1,0,0,0,40.5,NULL,NULL,NULL,17.00,15.00,17.00,772.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(91,'Smart Watches',NULL,NULL,'published','[\"products\\/26-1.jpg\"]','HS-127-A0-A1',0,15,0,1,0,NULL,NULL,4,1,0,0,0,40.5,NULL,NULL,NULL,17.00,15.00,17.00,772.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(92,'Smart Watches',NULL,NULL,'published','[\"products\\/26-2.jpg\"]','HS-127-A0-A2',0,15,0,1,0,NULL,NULL,4,1,0,0,0,40.5,NULL,NULL,NULL,17.00,15.00,17.00,772.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(93,'Beat Headphone',NULL,NULL,'published','[\"products\\/27.jpg\"]','HS-140-A0',0,14,0,1,0,NULL,NULL,7,1,0,0,0,20,NULL,NULL,NULL,17.00,12.00,11.00,697.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(94,'Beat Headphone',NULL,NULL,'published','[\"products\\/27-1.jpg\"]','HS-140-A0-A1',0,14,0,1,0,NULL,NULL,7,1,0,0,0,20,NULL,NULL,NULL,17.00,12.00,11.00,697.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(95,'Beat Headphone',NULL,NULL,'published','[\"products\\/27.jpg\"]','HS-140-A0-A2',0,14,0,1,0,NULL,NULL,7,1,0,0,0,20,NULL,NULL,NULL,17.00,12.00,11.00,697.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(96,'Red & Black Headphone',NULL,NULL,'published','[\"products\\/28.jpg\"]','HS-153-A0',0,17,0,1,0,NULL,NULL,4,1,0,0,0,57,43.32,NULL,NULL,14.00,18.00,16.00,610.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(97,'Red & Black Headphone',NULL,NULL,'published','[\"products\\/28-1.jpg\"]','HS-153-A0-A1',0,17,0,1,0,NULL,NULL,4,1,0,0,0,57,39.9,NULL,NULL,14.00,18.00,16.00,610.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(98,'Red & Black Headphone',NULL,NULL,'published','[\"products\\/28.jpg\"]','HS-153-A0-A2',0,17,0,1,0,NULL,NULL,4,1,0,0,0,57,41.61,NULL,NULL,14.00,18.00,16.00,610.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(99,'Audio Equipment',NULL,NULL,'published','[\"products\\/29.jpg\"]','HS-112-A0',0,12,0,1,0,NULL,NULL,7,1,0,0,0,54,NULL,NULL,NULL,11.00,14.00,16.00,801.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(100,'Audio Equipment',NULL,NULL,'published','[\"products\\/29-1.jpg\"]','HS-112-A0-A1',0,12,0,1,0,NULL,NULL,7,1,0,0,0,54,NULL,NULL,NULL,11.00,14.00,16.00,801.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(101,'Audio Equipment',NULL,NULL,'published','[\"products\\/29.jpg\"]','HS-112-A0-A2',0,12,0,1,0,NULL,NULL,7,1,0,0,0,54,NULL,NULL,NULL,11.00,14.00,16.00,801.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(102,'Smart Televisions',NULL,NULL,'published','[\"products\\/30.jpg\"]','HS-177-A0',0,20,0,1,0,NULL,NULL,1,1,0,0,0,116,NULL,NULL,NULL,16.00,19.00,15.00,525.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(103,'Smart Televisions',NULL,NULL,'published','[\"products\\/30-1.jpg\"]','HS-177-A0-A1',0,20,0,1,0,NULL,NULL,1,1,0,0,0,116,NULL,NULL,NULL,16.00,19.00,15.00,525.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(104,'Samsung Smart TV',NULL,NULL,'published','[\"products\\/31.jpg\"]','HS-100-A0',0,15,0,1,0,NULL,NULL,7,1,0,0,0,54,NULL,NULL,NULL,19.00,13.00,16.00,605.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock'),(105,'Samsung Smart TV',NULL,NULL,'published','[\"products\\/31-1.jpg\"]','HS-100-A0-A1',0,15,0,1,0,NULL,NULL,7,1,0,0,0,54,NULL,NULL,NULL,19.00,13.00,16.00,605.00,NULL,NULL,NULL,NULL,NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24',NULL,0,'in_stock');

--
-- Table structure for table `ec_reviews`
--

CREATE TABLE `ec_reviews` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `star` double(8,2) NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_reviews`
--

INSERT INTO `ec_reviews` VALUES (1,11,45,5.00,'Incidunt mollitia officiis quaerat ut sint minima alias. Aut provident praesentium quod sint in recusandae eius.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(2,11,38,3.00,'Ut soluta debitis reprehenderit quia. Nobis fuga voluptatibus dolor qui. Nobis qui voluptates non vero iusto.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(3,7,20,1.00,'Eos pariatur quos aut veniam totam. Natus nam rem quo qui. Omnis et rerum sequi nostrum.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(4,8,92,5.00,'Sunt aut officia natus est. Et dolores velit quibusdam nobis non sunt. Eveniet nisi eius necessitatibus nam omnis quam sed.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(5,10,12,5.00,'Accusantium neque libero eum rem at. Mollitia est quia deserunt quasi hic. Nam molestias ut ullam ad quia.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(6,10,101,5.00,'In et reiciendis reprehenderit amet exercitationem voluptatum. Id architecto nulla expedita quo ut. Est reiciendis occaecati omnis dolor sit.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(7,9,37,3.00,'Repellat aliquam molestias enim ex. Recusandae quos ab neque animi id. Vel itaque adipisci et aut. Vero et inventore aliquid omnis perspiciatis esse.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(8,11,3,4.00,'Velit iusto et delectus nulla. Soluta delectus quis ut modi in exercitationem. Et sed et officiis minima totam.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(9,5,34,5.00,'Inventore consequuntur accusamus nulla laboriosam. Quam culpa commodi assumenda cumque. Officiis perferendis excepturi et et omnis excepturi quod.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(10,4,50,5.00,'Enim quo repellendus eaque est illo officiis. Culpa laborum pariatur autem et qui. Delectus perspiciatis nesciunt et quas magni.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(11,11,58,2.00,'Assumenda autem deleniti accusamus quis alias est rerum. Placeat ipsa facilis nemo reiciendis. Minima quod et aut rerum.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(12,8,49,4.00,'In omnis ipsa voluptatem porro quibusdam. Qui rerum laboriosam consequatur et.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(13,1,21,5.00,'Ipsam doloribus voluptatibus aliquid molestiae voluptas. Dignissimos aut quasi optio. Nam sunt atque ipsum deserunt quo.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(14,5,52,2.00,'Rerum at quos quae sapiente velit. Quis alias et dolorem voluptatem et ut. Qui ullam et ex quos.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(15,2,92,1.00,'Asperiores vel autem aperiam. Ipsum voluptate voluptatem sit eius. Quo inventore dolorem in soluta et et.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(16,9,88,1.00,'Magnam unde minima a non quis rerum. Aliquam et animi repudiandae numquam. Pariatur quaerat et dolorem laborum aut.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(17,10,75,5.00,'Sapiente eum ut eaque ab. Cumque dolorum repellat eos qui. Beatae quaerat nostrum vero sunt.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(18,9,105,3.00,'Quo voluptas molestiae ad. Alias illum et reprehenderit quos aliquid illum. Ipsa a nihil quaerat qui ut.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(19,11,92,1.00,'Adipisci illum in qui ex sed. Iusto est nam aliquam harum qui. Animi fugit autem dignissimos eveniet ipsam totam placeat.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(20,5,38,2.00,'Magni provident quibusdam harum. Iure velit facilis cum. Temporibus non laudantium distinctio nesciunt perferendis error consequatur.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(21,9,56,5.00,'Ea consectetur molestiae sint. Quo est non adipisci incidunt. Culpa natus aut earum minima ratione similique.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(22,1,43,1.00,'Sint enim et non ipsa consequuntur. Aut et et dolorem optio ipsam maxime veniam. Illum officia aut aperiam et perspiciatis quidem facere.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(23,11,99,4.00,'Eius modi voluptatem est. Dignissimos quod magnam velit ut illum cumque. Officiis omnis eum aut incidunt voluptatibus commodi.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(24,11,71,5.00,'Non nam ut veniam tempore fuga voluptatum qui. Accusamus dolores laboriosam autem est facilis eligendi.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(25,4,3,5.00,'Natus accusamus ut dicta rerum distinctio sit optio debitis. Autem debitis nemo omnis porro dolor.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(26,6,39,4.00,'Ratione officiis non eligendi harum dolorem alias eos. Sequi laboriosam natus vel facere veritatis quos omnis. Molestiae sint et a quod harum.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(27,6,1,4.00,'Ut doloribus iste corporis qui. Odit eius eum nihil quia sunt. Natus officia qui rerum labore. Qui rerum amet itaque qui iusto eveniet.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(28,1,47,5.00,'Sint omnis et in qui sed libero suscipit. Ut suscipit vitae vero iusto.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(29,9,10,5.00,'Qui provident ipsam exercitationem dolor fugiat cupiditate quidem. Optio eaque minus et debitis inventore fugiat. Ullam hic animi et impedit.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(30,7,39,3.00,'Officia sed tempore doloribus doloremque. Dolorem neque eius laboriosam autem esse ex.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(31,7,31,3.00,'Iusto odit ullam quae incidunt occaecati quia accusamus. Vero est minus veniam quis. Natus illum facilis explicabo quo cumque in autem.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(32,2,23,1.00,'Accusamus quo voluptas nihil totam alias. Error et et amet. Quia et dolorum voluptas aperiam. In omnis consequatur consequatur rem voluptatem.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(33,2,96,3.00,'Accusamus qui nemo et quia qui. Delectus est adipisci numquam dolor ut voluptatibus. Adipisci reprehenderit excepturi sapiente atque.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(34,2,84,1.00,'Sit ut est est deleniti. Veritatis beatae qui nulla molestiae. Quia vero omnis in esse.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(35,10,40,5.00,'Aut illo minus dolores velit ut. Repudiandae doloremque totam non. Et consequatur non atque quia. Animi mollitia pariatur earum ex ipsam officia.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(36,7,32,2.00,'Quod quo totam sit porro et placeat. Quod voluptatem corporis deserunt ut accusantium ex necessitatibus. Labore a quo sint.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(37,9,32,5.00,'Laudantium temporibus delectus reprehenderit sed aut. Et unde voluptates quia odit voluptatem totam eum. Alias eveniet laborum enim.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(38,4,98,5.00,'Voluptas vel est blanditiis. Enim quia iusto nihil nihil distinctio. Et consequatur unde placeat ipsam sequi.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(39,5,16,3.00,'Harum voluptatum molestias quibusdam amet voluptatibus reprehenderit. Vel deserunt atque ullam adipisci.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(40,5,80,2.00,'Aut quaerat dolores non laboriosam. Et sit nemo quos reiciendis doloremque molestiae sint quam. Blanditiis labore eum et facere a autem laborum enim.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(41,2,31,4.00,'Porro voluptate nisi adipisci rem. Laborum ratione et laudantium velit iste. Sit repudiandae occaecati aut quod.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(42,10,40,4.00,'Natus necessitatibus vero libero ducimus labore eum eligendi deleniti. Expedita neque non quasi possimus.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(43,8,26,1.00,'Et non animi accusamus voluptates officia sint non. Quos dolores dicta quae eius laborum. Architecto ratione id quis sed.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(44,9,94,2.00,'Dolore eos qui atque maxime ipsa commodi mollitia. Quam eligendi enim quia eum voluptas. Ducimus dolore id debitis ipsa dolorem esse deleniti.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(45,7,6,2.00,'Dolorum illum eum sint assumenda illo. Quas possimus et non officiis harum. Recusandae consectetur quia et aut.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(46,8,52,2.00,'Unde minus odio maxime repudiandae consectetur voluptatem molestiae. Quis quis possimus nam dolorum magni ratione.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(47,3,17,2.00,'Quibusdam tempore nobis id aspernatur quis qui. Illum sed quis ipsum et. Magni voluptatem unde accusantium earum.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(48,8,34,2.00,'Optio porro placeat corrupti qui placeat sed corporis. Beatae aut placeat odit. Rerum et sunt qui provident accusantium.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(49,9,72,5.00,'Sequi laudantium id beatae non eius omnis. Facere natus recusandae veniam incidunt. Autem sit at labore et aliquid non.','published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(50,9,68,4.00,'Enim numquam id ut voluptatem. Odit ut corporis numquam et quia. Nobis magnam hic iste quae repellendus.','published','2021-07-02 21:03:24','2021-07-02 21:03:24');

--
-- Table structure for table `ec_shipment_histories`
--

CREATE TABLE `ec_shipment_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `action` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `shipment_id` int(10) unsigned NOT NULL,
  `order_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_shipment_histories`
--

INSERT INTO `ec_shipment_histories` VALUES (1,'create_from_order','Shipping was created from order %order_id%',0,1,1,'2021-06-29 13:03:25','2021-06-29 13:03:25'),(2,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,1,1,'2021-07-01 05:03:25','2021-07-02 21:03:25'),(3,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,1,1,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(4,'create_from_order','Shipping was created from order %order_id%',0,2,2,'2021-07-01 07:03:25','2021-07-01 07:03:25'),(5,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,2,2,'2021-07-01 07:03:25','2021-07-02 21:03:25'),(6,'create_from_order','Shipping was created from order %order_id%',0,3,3,'2021-06-25 09:03:25','2021-06-25 09:03:25'),(7,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,3,3,'2021-07-01 09:03:25','2021-07-02 21:03:25'),(8,'create_from_order','Shipping was created from order %order_id%',0,4,4,'2021-07-01 11:03:25','2021-07-01 11:03:25'),(9,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,4,4,'2021-07-01 11:03:25','2021-07-02 21:03:25'),(10,'create_from_order','Shipping was created from order %order_id%',0,5,5,'2021-07-01 13:03:25','2021-07-01 13:03:25'),(11,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,5,5,'2021-07-01 13:03:25','2021-07-02 21:03:25'),(12,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,5,5,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(13,'create_from_order','Shipping was created from order %order_id%',0,6,6,'2021-06-27 21:03:25','2021-06-27 21:03:25'),(14,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,6,6,'2021-07-01 15:03:25','2021-07-02 21:03:25'),(15,'update_cod_status','Updated COD status to Completed . Updated by: %user_name%',0,6,6,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(16,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,6,6,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(17,'create_from_order','Shipping was created from order %order_id%',0,7,7,'2021-06-28 05:03:25','2021-06-28 05:03:25'),(18,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,7,7,'2021-07-01 17:03:25','2021-07-02 21:03:25'),(19,'create_from_order','Shipping was created from order %order_id%',0,8,8,'2021-07-01 19:03:25','2021-07-01 19:03:25'),(20,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,8,8,'2021-07-01 19:03:25','2021-07-02 21:03:25'),(21,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,8,8,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(22,'create_from_order','Shipping was created from order %order_id%',0,9,9,'2021-06-27 21:03:25','2021-06-27 21:03:25'),(23,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,9,9,'2021-07-01 21:03:25','2021-07-02 21:03:25'),(24,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,9,9,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(25,'create_from_order','Shipping was created from order %order_id%',0,10,10,'2021-07-01 01:03:25','2021-07-01 01:03:25'),(26,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,10,10,'2021-07-01 23:03:25','2021-07-02 21:03:25'),(27,'create_from_order','Shipping was created from order %order_id%',0,11,11,'2021-06-25 09:03:25','2021-06-25 09:03:25'),(28,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,11,11,'2021-07-02 01:03:25','2021-07-02 21:03:25'),(29,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,11,11,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(30,'create_from_order','Shipping was created from order %order_id%',0,12,12,'2021-06-26 03:03:25','2021-06-26 03:03:25'),(31,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,12,12,'2021-07-02 03:03:25','2021-07-02 21:03:25'),(32,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,12,12,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(33,'create_from_order','Shipping was created from order %order_id%',0,13,13,'2021-06-28 05:03:25','2021-06-28 05:03:25'),(34,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,13,13,'2021-07-02 05:03:25','2021-07-02 21:03:25'),(35,'create_from_order','Shipping was created from order %order_id%',0,14,14,'2021-07-02 07:03:25','2021-07-02 07:03:25'),(36,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,14,14,'2021-07-02 07:03:25','2021-07-02 21:03:25'),(37,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,14,14,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(38,'create_from_order','Shipping was created from order %order_id%',0,15,15,'2021-06-28 21:03:25','2021-06-28 21:03:25'),(39,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,15,15,'2021-07-02 09:03:25','2021-07-02 21:03:25'),(40,'update_cod_status','Updated COD status to Completed . Updated by: %user_name%',0,15,15,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(41,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,15,15,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(42,'create_from_order','Shipping was created from order %order_id%',0,16,16,'2021-07-01 05:03:25','2021-07-01 05:03:25'),(43,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,16,16,'2021-07-02 11:03:25','2021-07-02 21:03:25'),(44,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,16,16,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(45,'create_from_order','Shipping was created from order %order_id%',0,17,17,'2021-07-01 05:03:25','2021-07-01 05:03:25'),(46,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,17,17,'2021-07-02 13:03:25','2021-07-02 21:03:25'),(47,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,17,17,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(48,'create_from_order','Shipping was created from order %order_id%',0,18,18,'2021-06-30 15:03:25','2021-06-30 15:03:25'),(49,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,18,18,'2021-07-02 15:03:25','2021-07-02 21:03:25'),(50,'create_from_order','Shipping was created from order %order_id%',0,19,19,'2021-07-02 01:03:25','2021-07-02 01:03:25'),(51,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,19,19,'2021-07-02 17:03:25','2021-07-02 21:03:25'),(52,'create_from_order','Shipping was created from order %order_id%',0,20,20,'2021-07-02 19:03:25','2021-07-02 19:03:25'),(53,'update_status','Changed status of shipping to : Approved . Updated by: %user_name%',0,20,20,'2021-07-02 19:03:25','2021-07-02 21:03:25'),(54,'update_status','Changed status of shipping to : Delivered . Updated by: %user_name%',0,20,20,'2021-07-02 21:03:25','2021-07-02 21:03:25');

--
-- Table structure for table `ec_shipments`
--

CREATE TABLE `ec_shipments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `weight` double(8,2) DEFAULT '0.00',
  `shipment_id` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `cod_amount` decimal(15,2) DEFAULT '0.00',
  `cod_status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `cross_checking_status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `price` decimal(15,2) DEFAULT '0.00',
  `store_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_shipments`
--

INSERT INTO `ec_shipments` VALUES (1,1,NULL,1602.00,NULL,'','delivered',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(2,2,NULL,6048.00,NULL,'','approved',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(3,3,NULL,2259.00,NULL,'','approved',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(4,4,NULL,3970.00,NULL,'','approved',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(5,5,NULL,6954.00,NULL,'','delivered',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(6,6,NULL,2161.00,NULL,'','delivered',1145.10,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(7,7,NULL,6302.00,NULL,'','approved',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(8,8,NULL,3110.00,NULL,'','delivered',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(9,9,NULL,4573.00,NULL,'','delivered',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(10,10,NULL,2042.00,NULL,'','approved',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(11,11,NULL,3545.00,NULL,'','delivered',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(12,12,NULL,5304.00,NULL,'','delivered',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(13,13,NULL,3764.00,NULL,'','approved',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(14,14,NULL,2932.00,NULL,'','delivered',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(15,15,NULL,7710.00,NULL,'','delivered',1194.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(16,16,NULL,5181.00,NULL,'','delivered',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(17,17,NULL,6199.00,NULL,'','delivered',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(18,18,NULL,7956.00,NULL,'','approved',816.20,'pending','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(19,19,NULL,2299.00,NULL,'','approved',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25'),(20,20,NULL,2418.00,NULL,'','delivered',0.00,'completed','pending',0.00,0,'2021-07-02 21:03:25','2021-07-02 21:03:25');

--
-- Table structure for table `ec_shipping`
--

CREATE TABLE `ec_shipping` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_shipping`
--

INSERT INTO `ec_shipping` VALUES (1,'All',NULL,'2021-07-02 21:03:24','2021-07-02 21:03:24');

--
-- Table structure for table `ec_shipping_rule_items`
--

CREATE TABLE `ec_shipping_rule_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `shipping_rule_id` int(10) unsigned NOT NULL,
  `country` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adjustment_price` decimal(15,2) DEFAULT '0.00',
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_shipping_rule_items`
--


--
-- Table structure for table `ec_shipping_rules`
--

CREATE TABLE `ec_shipping_rules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_id` int(10) unsigned NOT NULL,
  `type` enum('base_on_price','base_on_weight') COLLATE utf8mb4_unicode_ci DEFAULT 'base_on_price',
  `currency_id` int(10) unsigned DEFAULT NULL,
  `from` decimal(15,2) DEFAULT '0.00',
  `to` decimal(15,2) DEFAULT '0.00',
  `price` decimal(15,2) DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_shipping_rules`
--

INSERT INTO `ec_shipping_rules` VALUES (1,'Delivery',1,'base_on_price',NULL,0.00,NULL,0.00,'2021-07-02 21:03:24','2021-07-02 21:03:24');

--
-- Table structure for table `ec_store_locators`
--

CREATE TABLE `ec_store_locators` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_primary` tinyint(1) DEFAULT '0',
  `is_shipping_location` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_store_locators`
--

INSERT INTO `ec_store_locators` VALUES (1,'Shopwise','sales@botble.com','123-456-7890','123 Street, Old Trafford','US','New York','New York',1,1,'2021-07-02 21:03:29','2021-07-02 21:03:29');

--
-- Table structure for table `ec_taxes`
--

CREATE TABLE `ec_taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `percentage` double(8,6) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_taxes`
--

INSERT INTO `ec_taxes` VALUES (1,'VAT',10.000000,1,'published','2021-07-02 21:03:24','2021-07-02 21:03:24'),(2,'None',0.000000,2,'published','2021-07-02 21:03:24','2021-07-02 21:03:24');

--
-- Table structure for table `ec_wish_lists`
--

CREATE TABLE `ec_wish_lists` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(10) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_wish_lists`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `media_files`
--

CREATE TABLE `media_files` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `folder_id` int(10) unsigned NOT NULL DEFAULT '0',
  `mime_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` int(11) NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_files_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=780 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_files`
--

INSERT INTO `media_files` VALUES (659,0,'1',39,'image/png',3509,'brands/1.png','[]','2021-07-02 21:02:29','2021-07-02 21:02:29',NULL),(660,0,'2',39,'image/png',3505,'brands/2.png','[]','2021-07-02 21:02:29','2021-07-02 21:02:29',NULL),(661,0,'3',39,'image/png',2585,'brands/3.png','[]','2021-07-02 21:02:29','2021-07-02 21:02:29',NULL),(662,0,'4',39,'image/png',6427,'brands/4.png','[]','2021-07-02 21:02:29','2021-07-02 21:02:29',NULL),(663,0,'5',39,'image/png',3246,'brands/5.png','[]','2021-07-02 21:02:30','2021-07-02 21:02:30',NULL),(664,0,'6',39,'image/png',3276,'brands/6.png','[]','2021-07-02 21:02:30','2021-07-02 21:02:30',NULL),(665,0,'7',39,'image/png',3120,'brands/7.png','[]','2021-07-02 21:02:30','2021-07-02 21:02:30',NULL),(666,0,'p-1',40,'image/png',9577,'product-categories/p-1.png','[]','2021-07-02 21:02:30','2021-07-02 21:02:30',NULL),(667,0,'p-2',40,'image/png',5510,'product-categories/p-2.png','[]','2021-07-02 21:02:30','2021-07-02 21:02:30',NULL),(668,0,'p-3',40,'image/png',16215,'product-categories/p-3.png','[]','2021-07-02 21:02:31','2021-07-02 21:02:31',NULL),(669,0,'p-4',40,'image/png',7394,'product-categories/p-4.png','[]','2021-07-02 21:02:31','2021-07-02 21:02:31',NULL),(670,0,'p-5',40,'image/png',6714,'product-categories/p-5.png','[]','2021-07-02 21:02:31','2021-07-02 21:02:31',NULL),(671,0,'p-6',40,'image/png',9541,'product-categories/p-6.png','[]','2021-07-02 21:02:31','2021-07-02 21:02:31',NULL),(672,0,'p-7',40,'image/png',13677,'product-categories/p-7.png','[]','2021-07-02 21:02:32','2021-07-02 21:02:32',NULL),(673,0,'1',41,'image/jpeg',11752,'customers/1.jpg','[]','2021-07-02 21:02:32','2021-07-02 21:02:32',NULL),(674,0,'10',41,'image/jpeg',27814,'customers/10.jpg','[]','2021-07-02 21:02:32','2021-07-02 21:02:32',NULL),(675,0,'2',41,'image/jpeg',19005,'customers/2.jpg','[]','2021-07-02 21:02:32','2021-07-02 21:02:32',NULL),(676,0,'3',41,'image/jpeg',20400,'customers/3.jpg','[]','2021-07-02 21:02:33','2021-07-02 21:02:33',NULL),(677,0,'4',41,'image/jpeg',26819,'customers/4.jpg','[]','2021-07-02 21:02:33','2021-07-02 21:02:33',NULL),(678,0,'5',41,'image/jpeg',14367,'customers/5.jpg','[]','2021-07-02 21:02:33','2021-07-02 21:02:33',NULL),(679,0,'6',41,'image/jpeg',12367,'customers/6.jpg','[]','2021-07-02 21:02:33','2021-07-02 21:02:33',NULL),(680,0,'7',41,'image/jpeg',20652,'customers/7.jpg','[]','2021-07-02 21:02:33','2021-07-02 21:02:33',NULL),(681,0,'8',41,'image/jpeg',21164,'customers/8.jpg','[]','2021-07-02 21:02:33','2021-07-02 21:02:33',NULL),(682,0,'9',41,'image/jpeg',6084,'customers/9.jpg','[]','2021-07-02 21:02:33','2021-07-02 21:02:33',NULL),(683,0,'1-1',42,'image/jpeg',88437,'products/1-1.jpg','[]','2021-07-02 21:02:37','2021-07-02 21:02:37',NULL),(684,0,'1-2',42,'image/jpeg',122690,'products/1-2.jpg','[]','2021-07-02 21:02:37','2021-07-02 21:02:37',NULL),(685,0,'1-3',42,'image/jpeg',117296,'products/1-3.jpg','[]','2021-07-02 21:02:38','2021-07-02 21:02:38',NULL),(686,0,'1',42,'image/jpeg',139025,'products/1.jpg','[]','2021-07-02 21:02:38','2021-07-02 21:02:38',NULL),(687,0,'10-1',42,'image/jpeg',183491,'products/10-1.jpg','[]','2021-07-02 21:02:39','2021-07-02 21:02:39',NULL),(688,0,'10',42,'image/jpeg',150956,'products/10.jpg','[]','2021-07-02 21:02:40','2021-07-02 21:02:40',NULL),(689,0,'11-1',42,'image/jpeg',246200,'products/11-1.jpg','[]','2021-07-02 21:02:40','2021-07-02 21:02:40',NULL),(690,0,'11',42,'image/jpeg',279390,'products/11.jpg','[]','2021-07-02 21:02:41','2021-07-02 21:02:41',NULL),(691,0,'12-1',42,'image/jpeg',249712,'products/12-1.jpg','[]','2021-07-02 21:02:41','2021-07-02 21:02:41',NULL),(692,0,'12',42,'image/jpeg',172221,'products/12.jpg','[]','2021-07-02 21:02:42','2021-07-02 21:02:42',NULL),(693,0,'13-1',42,'image/jpeg',257021,'products/13-1.jpg','[]','2021-07-02 21:02:43','2021-07-02 21:02:43',NULL),(694,0,'13',42,'image/jpeg',232917,'products/13.jpg','[]','2021-07-02 21:02:43','2021-07-02 21:02:43',NULL),(695,0,'14-1',42,'image/jpeg',201773,'products/14-1.jpg','[]','2021-07-02 21:02:44','2021-07-02 21:02:44',NULL),(696,0,'14',42,'image/jpeg',287194,'products/14.jpg','[]','2021-07-02 21:02:44','2021-07-02 21:02:44',NULL),(697,0,'15-1',42,'image/jpeg',273720,'products/15-1.jpg','[]','2021-07-02 21:02:45','2021-07-02 21:02:45',NULL),(698,0,'15',42,'image/jpeg',114265,'products/15.jpg','[]','2021-07-02 21:02:46','2021-07-02 21:02:46',NULL),(699,0,'16',42,'image/jpeg',97174,'products/16.jpg','[]','2021-07-02 21:02:46','2021-07-02 21:02:46',NULL),(700,0,'17',42,'image/jpeg',70179,'products/17.jpg','[]','2021-07-02 21:02:48','2021-07-02 21:02:48',NULL),(701,0,'18-1',42,'image/jpeg',287835,'products/18-1.jpg','[]','2021-07-02 21:02:49','2021-07-02 21:02:49',NULL),(702,0,'18-2',42,'image/jpeg',454869,'products/18-2.jpg','[]','2021-07-02 21:02:51','2021-07-02 21:02:51',NULL),(703,0,'18',42,'image/jpeg',257331,'products/18.jpg','[]','2021-07-02 21:02:53','2021-07-02 21:02:53',NULL),(704,0,'19-1',42,'image/jpeg',144008,'products/19-1.jpg','[]','2021-07-02 21:02:54','2021-07-02 21:02:54',NULL),(705,0,'19',42,'image/jpeg',188821,'products/19.jpg','[]','2021-07-02 21:02:55','2021-07-02 21:02:55',NULL),(706,0,'2-1',42,'image/jpeg',138167,'products/2-1.jpg','[]','2021-07-02 21:02:56','2021-07-02 21:02:56',NULL),(707,0,'2-2',42,'image/jpeg',230552,'products/2-2.jpg','[]','2021-07-02 21:02:56','2021-07-02 21:02:56',NULL),(708,0,'2-3',42,'image/jpeg',179301,'products/2-3.jpg','[]','2021-07-02 21:02:57','2021-07-02 21:02:57',NULL),(709,0,'2',42,'image/jpeg',130048,'products/2.jpg','[]','2021-07-02 21:02:57','2021-07-02 21:02:57',NULL),(710,0,'20-1',42,'image/jpeg',249712,'products/20-1.jpg','[]','2021-07-02 21:02:58','2021-07-02 21:02:58',NULL),(711,0,'20',42,'image/jpeg',172221,'products/20.jpg','[]','2021-07-02 21:02:58','2021-07-02 21:02:58',NULL),(712,0,'21-1',42,'image/jpeg',260746,'products/21-1.jpg','[]','2021-07-02 21:02:59','2021-07-02 21:02:59',NULL),(713,0,'21',42,'image/jpeg',124244,'products/21.jpg','[]','2021-07-02 21:03:00','2021-07-02 21:03:00',NULL),(714,0,'22-1',42,'image/jpeg',268620,'products/22-1.jpg','[]','2021-07-02 21:03:01','2021-07-02 21:03:01',NULL),(715,0,'22',42,'image/jpeg',128692,'products/22.jpg','[]','2021-07-02 21:03:03','2021-07-02 21:03:03',NULL),(716,0,'23-1',42,'image/jpeg',105560,'products/23-1.jpg','[]','2021-07-02 21:03:04','2021-07-02 21:03:04',NULL),(717,0,'23',42,'image/jpeg',177362,'products/23.jpg','[]','2021-07-02 21:03:05','2021-07-02 21:03:05',NULL),(718,0,'24-1',42,'image/jpeg',239311,'products/24-1.jpg','[]','2021-07-02 21:03:06','2021-07-02 21:03:06',NULL),(719,0,'24',42,'image/jpeg',363853,'products/24.jpg','[]','2021-07-02 21:03:07','2021-07-02 21:03:07',NULL),(720,0,'25-1',42,'image/jpeg',17089,'products/25-1.jpg','[]','2021-07-02 21:03:09','2021-07-02 21:03:09',NULL),(721,0,'25',42,'image/jpeg',18069,'products/25.jpg','[]','2021-07-02 21:03:09','2021-07-02 21:03:09',NULL),(722,0,'26-1',42,'image/jpeg',13085,'products/26-1.jpg','[]','2021-07-02 21:03:09','2021-07-02 21:03:09',NULL),(723,0,'26-2',42,'image/jpeg',22667,'products/26-2.jpg','[]','2021-07-02 21:03:09','2021-07-02 21:03:09',NULL),(724,0,'26',42,'image/jpeg',13611,'products/26.jpg','[]','2021-07-02 21:03:10','2021-07-02 21:03:10',NULL),(725,0,'27-1',42,'image/jpeg',10286,'products/27-1.jpg','[]','2021-07-02 21:03:10','2021-07-02 21:03:10',NULL),(726,0,'27',42,'image/jpeg',12569,'products/27.jpg','[]','2021-07-02 21:03:10','2021-07-02 21:03:10',NULL),(727,0,'28-1',42,'image/jpeg',15654,'products/28-1.jpg','[]','2021-07-02 21:03:10','2021-07-02 21:03:10',NULL),(728,0,'28',42,'image/jpeg',18243,'products/28.jpg','[]','2021-07-02 21:03:10','2021-07-02 21:03:10',NULL),(729,0,'29-1',42,'image/jpeg',27890,'products/29-1.jpg','[]','2021-07-02 21:03:10','2021-07-02 21:03:10',NULL),(730,0,'29',42,'image/jpeg',27961,'products/29.jpg','[]','2021-07-02 21:03:10','2021-07-02 21:03:10',NULL),(731,0,'3-1',42,'image/jpeg',135741,'products/3-1.jpg','[]','2021-07-02 21:03:11','2021-07-02 21:03:11',NULL),(732,0,'3-2',42,'image/jpeg',123069,'products/3-2.jpg','[]','2021-07-02 21:03:11','2021-07-02 21:03:11',NULL),(733,0,'3-3',42,'image/jpeg',98645,'products/3-3.jpg','[]','2021-07-02 21:03:12','2021-07-02 21:03:12',NULL),(734,0,'3',42,'image/jpeg',201722,'products/3.jpg','[]','2021-07-02 21:03:12','2021-07-02 21:03:12',NULL),(735,0,'30-1',42,'image/jpeg',26283,'products/30-1.jpg','[]','2021-07-02 21:03:13','2021-07-02 21:03:13',NULL),(736,0,'30',42,'image/jpeg',27107,'products/30.jpg','[]','2021-07-02 21:03:13','2021-07-02 21:03:13',NULL),(737,0,'31-1',42,'image/jpeg',25924,'products/31-1.jpg','[]','2021-07-02 21:03:13','2021-07-02 21:03:13',NULL),(738,0,'31',42,'image/jpeg',18634,'products/31.jpg','[]','2021-07-02 21:03:14','2021-07-02 21:03:14',NULL),(739,0,'4-1',42,'image/jpeg',205312,'products/4-1.jpg','[]','2021-07-02 21:03:14','2021-07-02 21:03:14',NULL),(740,0,'4-2',42,'image/jpeg',223903,'products/4-2.jpg','[]','2021-07-02 21:03:14','2021-07-02 21:03:14',NULL),(741,0,'4-3',42,'image/jpeg',106593,'products/4-3.jpg','[]','2021-07-02 21:03:15','2021-07-02 21:03:15',NULL),(742,0,'4',42,'image/jpeg',456134,'products/4.jpg','[]','2021-07-02 21:03:15','2021-07-02 21:03:15',NULL),(743,0,'5-1',42,'image/jpeg',110014,'products/5-1.jpg','[]','2021-07-02 21:03:16','2021-07-02 21:03:16',NULL),(744,0,'5-2',42,'image/jpeg',104934,'products/5-2.jpg','[]','2021-07-02 21:03:17','2021-07-02 21:03:17',NULL),(745,0,'5-3',42,'image/jpeg',131628,'products/5-3.jpg','[]','2021-07-02 21:03:17','2021-07-02 21:03:17',NULL),(746,0,'5',42,'image/jpeg',214767,'products/5.jpg','[]','2021-07-02 21:03:18','2021-07-02 21:03:18',NULL),(747,0,'6-1',42,'image/jpeg',128041,'products/6-1.jpg','[]','2021-07-02 21:03:18','2021-07-02 21:03:18',NULL),(748,0,'6',42,'image/jpeg',148485,'products/6.jpg','[]','2021-07-02 21:03:19','2021-07-02 21:03:19',NULL),(749,0,'7-1',42,'image/jpeg',144008,'products/7-1.jpg','[]','2021-07-02 21:03:20','2021-07-02 21:03:20',NULL),(750,0,'7',42,'image/jpeg',188821,'products/7.jpg','[]','2021-07-02 21:03:20','2021-07-02 21:03:20',NULL),(751,0,'8-1',42,'image/jpeg',274272,'products/8-1.jpg','[]','2021-07-02 21:03:21','2021-07-02 21:03:21',NULL),(752,0,'8',42,'image/jpeg',217862,'products/8.jpg','[]','2021-07-02 21:03:21','2021-07-02 21:03:21',NULL),(753,0,'9-1',42,'image/jpeg',65624,'products/9-1.jpg','[]','2021-07-02 21:03:22','2021-07-02 21:03:22',NULL),(754,0,'9',42,'image/jpeg',159636,'products/9.jpg','[]','2021-07-02 21:03:23','2021-07-02 21:03:23',NULL),(755,0,'1',43,'image/jpeg',82629,'news/1.jpg','[]','2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(756,0,'2',43,'image/jpeg',119904,'news/2.jpg','[]','2021-07-02 21:03:26','2021-07-02 21:03:26',NULL),(757,0,'3',43,'image/jpeg',89543,'news/3.jpg','[]','2021-07-02 21:03:26','2021-07-02 21:03:26',NULL),(758,0,'4',43,'image/jpeg',51573,'news/4.jpg','[]','2021-07-02 21:03:26','2021-07-02 21:03:26',NULL),(759,0,'5',43,'image/jpeg',41164,'news/5.jpg','[]','2021-07-02 21:03:26','2021-07-02 21:03:26',NULL),(760,0,'6',43,'image/jpeg',80696,'news/6.jpg','[]','2021-07-02 21:03:26','2021-07-02 21:03:26',NULL),(761,0,'1',44,'image/jpeg',2733,'testimonials/1.jpg','[]','2021-07-02 21:03:27','2021-07-02 21:03:27',NULL),(762,0,'2',44,'image/jpeg',2840,'testimonials/2.jpg','[]','2021-07-02 21:03:27','2021-07-02 21:03:27',NULL),(763,0,'3',44,'image/jpeg',3065,'testimonials/3.jpg','[]','2021-07-02 21:03:27','2021-07-02 21:03:27',NULL),(764,0,'4',44,'image/jpeg',2559,'testimonials/4.jpg','[]','2021-07-02 21:03:27','2021-07-02 21:03:27',NULL),(765,0,'1',45,'image/jpeg',98636,'sliders/1.jpg','[]','2021-07-02 21:03:28','2021-07-02 21:03:28',NULL),(766,0,'2',45,'image/jpeg',22560,'sliders/2.jpg','[]','2021-07-02 21:03:28','2021-07-02 21:03:28',NULL),(767,0,'3',45,'image/jpeg',21630,'sliders/3.jpg','[]','2021-07-02 21:03:28','2021-07-02 21:03:28',NULL),(768,0,'american-express',46,'image/png',3209,'general/american-express.png','[]','2021-07-02 21:03:29','2021-07-02 21:03:29',NULL),(769,0,'b-1',46,'image/jpeg',20539,'general/b-1.jpg','[]','2021-07-02 21:03:29','2021-07-02 21:03:29',NULL),(770,0,'b-2',46,'image/jpeg',18320,'general/b-2.jpg','[]','2021-07-02 21:03:29','2021-07-02 21:03:29',NULL),(771,0,'b-3',46,'image/jpeg',42872,'general/b-3.jpg','[]','2021-07-02 21:03:29','2021-07-02 21:03:29',NULL),(772,0,'discover',46,'image/png',2494,'general/discover.png','[]','2021-07-02 21:03:30','2021-07-02 21:03:30',NULL),(773,0,'favicon',46,'image/png',1803,'general/favicon.png','[]','2021-07-02 21:03:30','2021-07-02 21:03:30',NULL),(774,0,'logo-light',46,'image/png',3736,'general/logo-light.png','[]','2021-07-02 21:03:30','2021-07-02 21:03:30',NULL),(775,0,'logo',46,'image/png',3927,'general/logo.png','[]','2021-07-02 21:03:30','2021-07-02 21:03:30',NULL),(776,0,'master-card',46,'image/png',3407,'general/master-card.png','[]','2021-07-02 21:03:30','2021-07-02 21:03:30',NULL),(777,0,'newsletter',46,'image/jpeg',48929,'general/newsletter.jpg','[]','2021-07-02 21:03:30','2021-07-02 21:03:30',NULL),(778,0,'paypal',46,'image/png',2670,'general/paypal.png','[]','2021-07-02 21:03:31','2021-07-02 21:03:31',NULL),(779,0,'visa',46,'image/png',2841,'general/visa.png','[]','2021-07-02 21:03:31','2021-07-02 21:03:31',NULL);

--
-- Table structure for table `media_folders`
--

CREATE TABLE `media_folders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_folders_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_folders`
--

INSERT INTO `media_folders` VALUES (39,0,'brands','brands',0,'2021-07-02 21:02:29','2021-07-02 21:02:29',NULL),(40,0,'product-categories','product-categories',0,'2021-07-02 21:02:30','2021-07-02 21:02:30',NULL),(41,0,'customers','customers',0,'2021-07-02 21:02:32','2021-07-02 21:02:32',NULL),(42,0,'products','products',0,'2021-07-02 21:02:37','2021-07-02 21:02:37',NULL),(43,0,'news','news',0,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(44,0,'testimonials','testimonials',0,'2021-07-02 21:03:27','2021-07-02 21:03:27',NULL),(45,0,'sliders','sliders',0,'2021-07-02 21:03:28','2021-07-02 21:03:28',NULL),(46,0,'general','general',0,'2021-07-02 21:03:29','2021-07-02 21:03:29',NULL);

--
-- Table structure for table `media_settings`
--

CREATE TABLE `media_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `media_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_settings`
--


--
-- Table structure for table `menu_locations`
--

CREATE TABLE `menu_locations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` int(10) unsigned NOT NULL,
  `location` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_locations`
--

INSERT INTO `menu_locations` VALUES (1,1,'main-menu','2021-07-02 21:03:29','2021-07-02 21:03:29');

--
-- Table structure for table `menu_nodes`
--

CREATE TABLE `menu_nodes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` int(10) unsigned NOT NULL,
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `reference_id` int(10) unsigned DEFAULT NULL,
  `reference_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_font` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `title` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `css_class` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
  `has_child` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_nodes_menu_id_index` (`menu_id`),
  KEY `menu_nodes_parent_id_index` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_nodes`
--

INSERT INTO `menu_nodes` VALUES (1,1,0,NULL,NULL,'/',NULL,0,'Home',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(2,1,0,NULL,NULL,'/products',NULL,0,'Products',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(3,1,0,NULL,NULL,'#',NULL,0,'Shop',NULL,'_self',1,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(4,1,3,1,'Botble\\Ecommerce\\Models\\ProductCategory','/product-categories/television',NULL,0,'Product Category',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(5,1,3,1,'Botble\\Ecommerce\\Models\\Brand','/brands/fashion-live',NULL,0,'Brand',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(6,1,3,1,'Botble\\Ecommerce\\Models\\ProductTag','/product-tags/electronic',NULL,0,'Product Tag',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(7,1,3,NULL,NULL,'products/beat-headphone',NULL,0,'Product Single',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(8,1,0,3,'Botble\\Page\\Models\\Page','/blog',NULL,0,'Blog',NULL,'_self',1,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(9,1,8,3,'Botble\\Page\\Models\\Page','/blog',NULL,0,'Blog Left Sidebar',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(10,1,8,1,'Botble\\Blog\\Models\\Category','/news/ecommerce',NULL,0,'Blog Category',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(11,1,8,1,'Botble\\Blog\\Models\\Tag','/tags/general',NULL,0,'Blog Tag',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(12,1,8,NULL,NULL,'news/4-expert-tips-on-how-to-choose-the-right-mens-wallet',NULL,0,'Blog Single',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(13,1,0,2,'Botble\\Page\\Models\\Page','/contact-us',NULL,0,'Contact us',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(14,2,0,4,'Botble\\Page\\Models\\Page','/about-us',NULL,0,'About Us',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(15,2,0,5,'Botble\\Page\\Models\\Page','/faq',NULL,0,'FAQ',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(16,2,0,6,'Botble\\Page\\Models\\Page','/location',NULL,0,'Location',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(17,2,0,7,'Botble\\Page\\Models\\Page','/affiliates',NULL,0,'Affiliates',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(18,2,0,2,'Botble\\Page\\Models\\Page','/contact-us',NULL,0,'Contact',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(19,3,0,1,'Botble\\Ecommerce\\Models\\ProductCategory','/product-categories/television',NULL,0,'Television',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(20,3,0,2,'Botble\\Ecommerce\\Models\\ProductCategory','/product-categories/mobile',NULL,0,'Mobile',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(21,3,0,3,'Botble\\Ecommerce\\Models\\ProductCategory','/product-categories/headphone',NULL,0,'Headphone',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(22,3,0,4,'Botble\\Ecommerce\\Models\\ProductCategory','/product-categories/watches',NULL,0,'Watches',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(23,3,0,5,'Botble\\Ecommerce\\Models\\ProductCategory','/product-categories/game',NULL,0,'Game',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(24,4,0,NULL,NULL,'/customer/overview',NULL,0,'My profile',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(25,4,0,NULL,NULL,'/wishlist',NULL,0,'Wishlist',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(26,4,0,NULL,NULL,'customer/orders',NULL,0,'Orders',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29'),(27,4,0,NULL,NULL,'/orders/tracking',NULL,0,'Order tracking',NULL,'_self',0,'2021-07-02 21:03:29','2021-07-02 21:03:29');

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menus_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (1,'Main menu','main-menu','published','2021-07-02 21:03:29','2021-07-02 21:03:29'),(2,'Useful Links','useful-links','published','2021-07-02 21:03:29','2021-07-02 21:03:29'),(3,'Categories','categories','published','2021-07-02 21:03:29','2021-07-02 21:03:29'),(4,'My Account','my-account','published','2021-07-02 21:03:29','2021-07-02 21:03:29');

--
-- Table structure for table `meta_boxes`
--

CREATE TABLE `meta_boxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_value` text COLLATE utf8mb4_unicode_ci,
  `reference_id` int(10) unsigned NOT NULL,
  `reference_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `meta_boxes_reference_id_index` (`reference_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `meta_boxes`
--

INSERT INTO `meta_boxes` VALUES (1,'icon','[\"flaticon-tv\"]',1,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(2,'icon','[\"flaticon-responsive\"]',2,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(3,'icon','[\"flaticon-headphones\"]',3,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(4,'icon','[\"flaticon-watch\"]',4,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(5,'icon','[\"flaticon-console\"]',5,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(6,'icon','[\"flaticon-camera\"]',6,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(7,'icon','[\"flaticon-music-system\"]',7,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(8,'icon','[\"flaticon-responsive\"]',8,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(9,'icon','[\"flaticon-plugins\"]',9,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(10,'icon','[\"flaticon-music-system\"]',10,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(11,'icon','[\"flaticon-monitor\"]',11,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(12,'icon','[\"flaticon-printer\"]',12,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(13,'icon','[\"flaticon-tv\"]',13,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(14,'icon','[\"flaticon-fax\"]',14,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(15,'icon','[\"flaticon-mouse\"]',15,'Botble\\Ecommerce\\Models\\ProductCategory','2021-05-03 02:01:00','2021-05-03 02:01:00'),(16,'button_text','[\"Shop now\"]',1,'Botble\\SimpleSlider\\Models\\SimpleSliderItem','2021-07-02 20:17:18','2021-07-02 20:17:18'),(17,'button_text','[\"Discover now\"]',2,'Botble\\SimpleSlider\\Models\\SimpleSliderItem','2021-07-02 20:17:18','2021-07-02 20:17:18'),(18,'button_text','[\"Shop now\"]',3,'Botble\\SimpleSlider\\Models\\SimpleSliderItem','2021-07-02 20:17:18','2021-07-02 20:17:18');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2013_04_09_032329_create_base_tables',1),(2,'2013_04_09_062329_create_revisions_table',1),(3,'2014_10_12_000000_create_users_table',1),(4,'2014_10_12_100000_create_password_resets_table',1),(5,'2015_06_18_033822_create_blog_table',1),(6,'2015_06_29_025744_create_audit_history',1),(7,'2016_06_10_230148_create_acl_tables',1),(8,'2016_06_14_230857_create_menus_table',1),(9,'2016_06_17_091537_create_contacts_table',1),(10,'2016_06_28_221418_create_pages_table',1),(11,'2016_10_05_074239_create_setting_table',1),(12,'2016_10_07_193005_create_translations_table',1),(13,'2016_11_28_032840_create_dashboard_widget_tables',1),(14,'2016_12_16_084601_create_widgets_table',1),(15,'2017_05_09_070343_create_media_tables',1),(16,'2017_05_18_080441_create_payment_tables',1),(17,'2017_07_11_140018_create_simple_slider_table',1),(18,'2017_10_24_154832_create_newsletter_table',1),(19,'2017_11_03_070450_create_slug_table',1),(20,'2018_07_09_214610_create_testimonial_table',1),(21,'2019_01_05_053554_create_jobs_table',1),(22,'2019_08_19_000000_create_failed_jobs_table',1),(23,'2020_03_05_041139_create_ecommerce_tables',1),(24,'2020_09_22_135635_update_taxes_table',1),(25,'2020_09_29_101006_add_views_into_ec_products_table',1),(26,'2020_10_01_152311_make_column_image_in_product_attributes_table_nullable',1),(27,'2020_10_06_073439_improve_ecommerce_database',1),(28,'2020_11_01_040415_update_table_ec_order_addresses',1),(29,'2020_11_04_091510_make_column_phone_in_order_addresses_nullable',1),(30,'2020_11_30_015801_update_table_ec_product_categories',1),(31,'2021_01_01_044147_ecommerce_create_flash_sale_table',1),(32,'2021_01_17_082713_add_column_is_featured_to_product_collections_table',1),(33,'2021_01_18_024333_add_zip_code_into_table_customer_addresses',1),(34,'2021_02_16_092633_remove_default_value_for_author_type',1),(35,'2021_02_18_073505_update_table_ec_reviews',1),(36,'2021_03_10_024419_add_column_confirmed_at_to_table_ec_customers',1),(37,'2021_03_10_025153_change_column_tax_amount',1),(38,'2021_03_20_033103_add_column_availability_to_table_ec_products',1),(39,'2021_03_27_144913_add_customer_type_into_table_payments',1),(40,'2021_04_28_074008_ecommerce_create_product_label_table',1),(41,'2021_05_24_034720_make_column_currency_nullable',2),(42,'2021_06_28_153141_correct_slugs_data',3),(43,'2021_07_18_101839_fix_old_theme_options',4);

--
-- Table structure for table `newsletters`
--

CREATE TABLE `newsletters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'subscribed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `newsletters`
--


--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `user_id` int(11) NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `template` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_featured` tinyint(4) NOT NULL DEFAULT '0',
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (1,'Home','<div>[simple-slider key=\"home-slider\"][/simple-slider]</div><div>[featured-product-categories title=\"Top Categories\" description=\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus blandit massa enim Nullam nunc varius.\"][/featured-product-categories]</div><div>[flash-sale title=\"Best deals for you\"][/flash-sale]</div><div>[product-collections title=\"Exclusive Products\"][/product-collections]</div><div>[banners image1=\"general/b-1.jpg\" url1=\"/product-categories/headphone\" image2=\"general/b-2.jpg\" url2=\"/product-categories/camera\" image3=\"general/b-3.jpg\" url3=\"/product-categories/watches\"][/banners]</div><div>[trending-products title=\"Trending Products\"][[/trending-products]</div><div>[product-blocks featured_product_title=\"Featured Products\" top_rated_product_title=\"Top Rated Products\" on_sale_product_title=\"On Sale Products\"][/product-blocks]</div><div>[featured-brands title=\"Our Brands\"][/featured-brands]</div><div>[featured-news title=\"Visit Our Blog\" description=\"Our Blog updated the newest trend of the world regularly\"][/featured-news]</div><div>[testimonials title=\"Our Client Say!\"][/testimonials]</div><div>[our-features icon1=\"flaticon-shipped\" title1=\"Free Delivery\" description1=\"Free shipping on all US order or order above $200\" icon2=\"flaticon-money-back\" title2=\"30 Day Returns Guarantee\" description2=\"Simply return it within 30 days for an exchange\" icon3=\"flaticon-support\" title3=\"27/4 Online Support\" description3=\"Contact us 24 hours a day, 7 days a week\"][/our-features]</div><div>[newsletter-form title=\"Join Our Newsletter Now\" description=\"Register now to get updates on promotions.\"][/newsletter-form]</div>',1,NULL,'homepage',0,NULL,'published','2021-07-02 21:03:29','2021-07-02 21:03:29'),(2,'Contact us','<p>[contact-form][/contact-form]</p>',1,NULL,'default',0,NULL,'published','2021-07-02 21:03:29','2021-07-02 21:03:29'),(3,'Blog','<p>---</p>',1,NULL,'blog-sidebar',0,NULL,'published','2021-07-02 21:03:29','2021-07-02 21:03:29'),(4,'About us','<p>His voice has a timid voice at her feet, for it to speak with. Alice waited a little, \'From the Queen. \'Never!\' said the King; \'and don\'t be nervous, or I\'ll kick you down stairs!\' \'That is not said right,\' said the King, and the choking of the goldfish kept running in her pocket) till she was losing her temper. \'Are you content now?\' said the Knave, \'I didn\'t know that you\'re mad?\' \'To begin with,\' said the Caterpillar. \'Well, perhaps not,\' said the Mock Turtle is.\' \'It\'s the oldest rule in.</p>',1,NULL,'default',0,NULL,'published','2021-07-02 21:03:29','2021-07-02 21:03:29'),(5,'FAQ','<p>CHORUS. \'Wow! wow! wow!\' While the Duchess and the words \'EAT ME\' were beautifully marked in currants. \'Well, I\'ll eat it,\' said the Dormouse, not choosing to notice this last remark. \'Of course you don\'t!\' the Hatter asked triumphantly. Alice did not venture to go near the King said gravely, \'and go on crying in this way! Stop this moment, I tell you!\' said Alice. \'It must be off, then!\' said the Mock Turtle repeated thoughtfully. \'I should like to show you! A little bright-eyed terrier, you.</p>',1,NULL,'default',0,NULL,'published','2021-07-02 21:03:29','2021-07-02 21:03:29'),(6,'Location','<p>Turtle--we used to it!\' pleaded poor Alice began to get to,\' said the Gryphon, the squeaking of the players to be said. At last the Mock Turtle drew a long way back, and barking hoarsely all the time she had tired herself out with his head!\' or \'Off with his tea spoon at the Gryphon at the righthand bit again, and that\'s very like a candle. I wonder who will put on one knee as he spoke. \'UNimportant, of course, I meant,\' the King and the moon, and memory, and muchness--you know you say things.</p>',1,NULL,'default',0,NULL,'published','2021-07-02 21:03:29','2021-07-02 21:03:29'),(7,'Affiliates','<p>It sounded an excellent opportunity for making her escape; so she took up the other, and making quite a new pair of boots every Christmas.\' And she began thinking over other children she knew, who might do something better with the distant sobs of the court. \'What do you know about it, and fortunately was just in time to be trampled under its feet, \'I move that the meeting adjourn, for the garden!\' and she thought at first was moderate. But the snail replied \"Too far, too far!\" and gave a.</p>',1,NULL,'default',0,NULL,'published','2021-07-02 21:03:29','2021-07-02 21:03:29'),(8,'Brands','<p>[all-brands][/all-brands]</p>',1,NULL,'default',0,NULL,'published','2021-07-02 21:03:29','2021-07-02 21:03:29'),(9,'Cookie Policy','<h3>EU Cookie Consent</h3><p>To use this Website we are using Cookies and collecting some Data. To be compliant with the EU GDPR we give you to choose if you allow us to use certain Cookies and to collect some Data.</p><h4>Essential Data</h4><p>The Essential Data is needed to run the Site you are visiting technically. You can not deactivate them.</p><p>- Session Cookie: PHP uses a Cookie to identify user sessions. Without this Cookie the Website is not working.</p><p>- XSRF-Token Cookie: Laravel automatically generates a CSRF \"token\" for each active user session managed by the application. This token is used to verify that the authenticated user is the one actually making the requests to the application.</p>',1,NULL,'default',0,NULL,'published','2021-07-02 21:03:29','2021-07-02 21:03:29');

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `currency` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `charge_id` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_channel` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(15,2) unsigned NOT NULL,
  `order_id` int(10) unsigned DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `payment_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'confirm',
  `customer_id` int(10) unsigned DEFAULT NULL,
  `refunded_amount` decimal(15,2) unsigned DEFAULT NULL,
  `refund_note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `customer_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` VALUES (1,'USD',0,'XPX66PLWAX','paypal',NULL,187.28,1,'completed','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(2,'USD',0,'ENR1BZYMBS','paystack',NULL,597.20,2,'completed','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(3,'USD',0,'CYZ5QTMRS5','sslcommerz',NULL,214.50,3,'completed','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(4,'USD',0,'RFDQMXJNSW','paypal',NULL,330.40,4,'completed','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(5,'USD',0,'XLMMUU9JXO','bank_transfer',NULL,1915.80,5,'pending','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(6,'USD',0,'7PDKC51BT2','cod',NULL,1145.10,6,'pending','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(7,'USD',0,'ZV4GG1KBGY','stripe',NULL,1075.40,7,'completed','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(8,'USD',0,'YDN8A2KXJP','paystack',NULL,430.50,8,'completed','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(9,'USD',0,'QP237WDGZW','paypal',NULL,435.80,9,'completed','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(10,'USD',0,'GO5OZXPEPS','stripe',NULL,658.90,10,'completed','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(11,'USD',0,'57OPA5PVY1','paystack',NULL,655.60,11,'completed','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(12,'USD',0,'9KJDI5OLDG','mollie',NULL,1009.30,12,'completed','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(13,'USD',0,'HJ0Y1Y2CRT','paystack',NULL,749.00,13,'completed','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(14,'USD',0,'NDJUM3ZLBY','bank_transfer',NULL,326.55,14,'pending','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(15,'USD',0,'LZN9IR2O0R','cod',NULL,1194.00,15,'pending','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(16,'USD',0,'E0Q9JB1OKK','sslcommerz',NULL,1027.10,16,'completed','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(17,'USD',0,'6ODVIVCPLB','paystack',NULL,662.78,17,'completed','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(18,'USD',0,'6JW67TIENK','cod',NULL,816.20,18,'pending','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(19,'USD',0,'E9IAGDDCXT','stripe',NULL,228.25,19,'completed','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL),(20,'USD',0,'TWVM80OOO3','bank_transfer',NULL,346.50,20,'pending','confirm',NULL,NULL,NULL,'2021-07-02 21:03:25','2021-07-02 21:03:25',NULL);

--
-- Table structure for table `post_categories`
--

CREATE TABLE `post_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned NOT NULL,
  `post_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_categories`
--

INSERT INTO `post_categories` VALUES (10,4,3),(19,1,1),(20,4,2),(21,3,4),(22,1,5),(23,2,6);

--
-- Table structure for table `post_tags`
--

CREATE TABLE `post_tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tag_id` int(10) unsigned NOT NULL,
  `post_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_tags`
--

INSERT INTO `post_tags` VALUES (1,1,1),(2,2,1),(3,3,1),(4,4,1),(5,5,1),(6,1,2),(7,2,2),(8,3,2),(9,4,2),(10,5,2),(11,1,3),(12,2,3),(13,3,3),(14,4,3),(15,5,3),(16,1,4),(17,2,4),(18,3,4),(19,4,4),(20,5,4),(21,1,5),(22,2,5),(23,3,5),(24,4,5),(25,5,5),(26,1,6),(27,2,6),(28,3,6),(29,4,6),(30,5,6);

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `author_id` int(11) NOT NULL,
  `author_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `is_featured` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `views` int(10) unsigned NOT NULL DEFAULT '0',
  `format_type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` VALUES (1,'4 Expert Tips On How To Choose The Right Men’s Wallet','You should pay more attention when you choose your wallets. There are a lot of them on the market with the different designs and styles. When you choose carefully, you would be able to buy a wallet that is catered to your needs. Not to mention that it will help to enhance your style significantly.','<p>I have seen many people underestimating the power of their wallets. To them, they are just a functional item they use to carry. As a result, they often end up with the wallets which are not really suitable for them.</p>\n\n<p>You should pay more attention when you choose your wallets. There are a lot of them on the market with the different designs and styles. When you choose carefully, you would be able to buy a wallet that is catered to your needs. Not to mention that it will help to enhance your style significantly.</p>\n\n<p style=\"text-align:center\"><img alt=\"f4\" src=\"/storage/news/1.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<p><strong><em>For all of the reason above, here are 7 expert tips to help you pick up the right men&rsquo;s wallet for you:</em></strong></p>\n\n<h4><strong>Number 1: Choose A Neat Wallet</strong></h4>\n\n<p>The wallet is an essential accessory that you should go simple. Simplicity is the best in this case. A simple and neat wallet with the plain color and even&nbsp;<strong>minimalist style</strong>&nbsp;is versatile. It can be used for both formal and casual events. In addition, that wallet will go well with most of the clothes in your wardrobe.</p>\n\n<p>Keep in mind that a wallet will tell other people about your personality and your fashion sense as much as other clothes you put on. Hence, don&rsquo;t go cheesy on your wallet or else people will think that you have a funny and particular style.</p>\n\n<p style=\"text-align:center\"><img alt=\"f5\" src=\"/storage/news/2.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 2: Choose The Right Size For Your Wallet</strong></h4>\n\n<p>You should avoid having an over-sized wallet. Don&rsquo;t think that you need to buy a big wallet because you have a lot to carry with you. In addition, a fat wallet is very ugly. It will make it harder for you to slide the wallet into your trousers&rsquo; pocket. In addition, it will create a bulge and ruin your look.</p>\n\n<p>Before you go on to buy a new wallet, clean out your wallet and place all of the items from your wallet on a table. Throw away things that you would never need any more such as the old bills or the expired gift cards. Remember to check your wallet on a frequent basis to get rid of all of the old stuff that you don&rsquo;t need anymore.</p>\n\n<p style=\"text-align:center\"><img alt=\"f1\" src=\"/storage/news/3.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 3: Don&rsquo;t Limit Your Options Of Materials</strong></h4>\n\n<p>The types and designs of wallets are not the only things that you should consider when you go out searching for your best wallet. You have more than 1 option of material rather than leather to choose from as well.</p>\n\n<p>You can experiment with other available options such as cotton, polyester and canvas. They all have their own pros and cons. As a result, they will be suitable for different needs and requirements. You should think about them all in order to choose the material which you would like the most.</p>\n\n<p style=\"text-align:center\"><img alt=\"f6\" src=\"/storage/news/4.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 4: Consider A Wallet As A Long Term Investment</strong></h4>\n\n<p>Your wallet is indeed an investment that you should consider spending a decent amount of time and effort on it. Another factor that you need to consider is how much you want to spend on your wallet. The price ranges of wallets on the market vary a great deal. You can find a wallet which is as cheap as about 5 to 7 dollars. On the other hand, you should expect to pay around 250 to 300 dollars for a high-quality wallet.</p>\n\n<p>In case you need a wallet to use for a long time, it is a good idea that you should invest a decent amount of money on a wallet. A high quality wallet from a reputational brand with the premium quality such as cowhide leather will last for a long time. In addition, it is an accessory to show off your fashion sense and your social status.</p>\n\n<p style=\"text-align:center\"><img alt=\"f2\" src=\"/storage/news/5.jpg\" /></p>\n\n<p>&nbsp;</p>\n','published',1,'Botble\\ACL\\Models\\User',1,'news/1.jpg',1018,NULL,'2021-07-02 21:03:27','2021-07-02 21:03:27'),(2,'Sexy Clutches: How to Buy & Wear a Designer Clutch Bag','There isn’t much a girl can’t handle with the right accessories. That’s why the perfect women’s clutch bag is a wardrobe essential for first dates and spring weddings.','<p>I have seen many people underestimating the power of their wallets. To them, they are just a functional item they use to carry. As a result, they often end up with the wallets which are not really suitable for them.</p>\n\n<p>You should pay more attention when you choose your wallets. There are a lot of them on the market with the different designs and styles. When you choose carefully, you would be able to buy a wallet that is catered to your needs. Not to mention that it will help to enhance your style significantly.</p>\n\n<p style=\"text-align:center\"><img alt=\"f4\" src=\"/storage/news/1.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<p><strong><em>For all of the reason above, here are 7 expert tips to help you pick up the right men&rsquo;s wallet for you:</em></strong></p>\n\n<h4><strong>Number 1: Choose A Neat Wallet</strong></h4>\n\n<p>The wallet is an essential accessory that you should go simple. Simplicity is the best in this case. A simple and neat wallet with the plain color and even&nbsp;<strong>minimalist style</strong>&nbsp;is versatile. It can be used for both formal and casual events. In addition, that wallet will go well with most of the clothes in your wardrobe.</p>\n\n<p>Keep in mind that a wallet will tell other people about your personality and your fashion sense as much as other clothes you put on. Hence, don&rsquo;t go cheesy on your wallet or else people will think that you have a funny and particular style.</p>\n\n<p style=\"text-align:center\"><img alt=\"f5\" src=\"/storage/news/2.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 2: Choose The Right Size For Your Wallet</strong></h4>\n\n<p>You should avoid having an over-sized wallet. Don&rsquo;t think that you need to buy a big wallet because you have a lot to carry with you. In addition, a fat wallet is very ugly. It will make it harder for you to slide the wallet into your trousers&rsquo; pocket. In addition, it will create a bulge and ruin your look.</p>\n\n<p>Before you go on to buy a new wallet, clean out your wallet and place all of the items from your wallet on a table. Throw away things that you would never need any more such as the old bills or the expired gift cards. Remember to check your wallet on a frequent basis to get rid of all of the old stuff that you don&rsquo;t need anymore.</p>\n\n<p style=\"text-align:center\"><img alt=\"f1\" src=\"/storage/news/3.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 3: Don&rsquo;t Limit Your Options Of Materials</strong></h4>\n\n<p>The types and designs of wallets are not the only things that you should consider when you go out searching for your best wallet. You have more than 1 option of material rather than leather to choose from as well.</p>\n\n<p>You can experiment with other available options such as cotton, polyester and canvas. They all have their own pros and cons. As a result, they will be suitable for different needs and requirements. You should think about them all in order to choose the material which you would like the most.</p>\n\n<p style=\"text-align:center\"><img alt=\"f6\" src=\"/storage/news/4.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 4: Consider A Wallet As A Long Term Investment</strong></h4>\n\n<p>Your wallet is indeed an investment that you should consider spending a decent amount of time and effort on it. Another factor that you need to consider is how much you want to spend on your wallet. The price ranges of wallets on the market vary a great deal. You can find a wallet which is as cheap as about 5 to 7 dollars. On the other hand, you should expect to pay around 250 to 300 dollars for a high-quality wallet.</p>\n\n<p>In case you need a wallet to use for a long time, it is a good idea that you should invest a decent amount of money on a wallet. A high quality wallet from a reputational brand with the premium quality such as cowhide leather will last for a long time. In addition, it is an accessory to show off your fashion sense and your social status.</p>\n\n<p style=\"text-align:center\"><img alt=\"f2\" src=\"/storage/news/5.jpg\" /></p>\n\n<p>&nbsp;</p>\n','published',1,'Botble\\ACL\\Models\\User',1,'news/2.jpg',359,NULL,'2021-07-02 21:03:27','2021-07-02 21:03:27'),(3,'The Top 2020 Handbag Trends to Know','For the handbag obsessives, let\'s dive into the latter a little more. This year will bring a fresh array of bag designs, and already we\'ve gotten a sneak peek of what both spring and fall 2020 collections have to offer/','<p>I have seen many people underestimating the power of their wallets. To them, they are just a functional item they use to carry. As a result, they often end up with the wallets which are not really suitable for them.</p>\n\n<p>You should pay more attention when you choose your wallets. There are a lot of them on the market with the different designs and styles. When you choose carefully, you would be able to buy a wallet that is catered to your needs. Not to mention that it will help to enhance your style significantly.</p>\n\n<p style=\"text-align:center\"><img alt=\"f4\" src=\"/storage/news/1.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<p><strong><em>For all of the reason above, here are 7 expert tips to help you pick up the right men&rsquo;s wallet for you:</em></strong></p>\n\n<h4><strong>Number 1: Choose A Neat Wallet</strong></h4>\n\n<p>The wallet is an essential accessory that you should go simple. Simplicity is the best in this case. A simple and neat wallet with the plain color and even&nbsp;<strong>minimalist style</strong>&nbsp;is versatile. It can be used for both formal and casual events. In addition, that wallet will go well with most of the clothes in your wardrobe.</p>\n\n<p>Keep in mind that a wallet will tell other people about your personality and your fashion sense as much as other clothes you put on. Hence, don&rsquo;t go cheesy on your wallet or else people will think that you have a funny and particular style.</p>\n\n<p style=\"text-align:center\"><img alt=\"f5\" src=\"/storage/news/2.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 2: Choose The Right Size For Your Wallet</strong></h4>\n\n<p>You should avoid having an over-sized wallet. Don&rsquo;t think that you need to buy a big wallet because you have a lot to carry with you. In addition, a fat wallet is very ugly. It will make it harder for you to slide the wallet into your trousers&rsquo; pocket. In addition, it will create a bulge and ruin your look.</p>\n\n<p>Before you go on to buy a new wallet, clean out your wallet and place all of the items from your wallet on a table. Throw away things that you would never need any more such as the old bills or the expired gift cards. Remember to check your wallet on a frequent basis to get rid of all of the old stuff that you don&rsquo;t need anymore.</p>\n\n<p style=\"text-align:center\"><img alt=\"f1\" src=\"/storage/news/3.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 3: Don&rsquo;t Limit Your Options Of Materials</strong></h4>\n\n<p>The types and designs of wallets are not the only things that you should consider when you go out searching for your best wallet. You have more than 1 option of material rather than leather to choose from as well.</p>\n\n<p>You can experiment with other available options such as cotton, polyester and canvas. They all have their own pros and cons. As a result, they will be suitable for different needs and requirements. You should think about them all in order to choose the material which you would like the most.</p>\n\n<p style=\"text-align:center\"><img alt=\"f6\" src=\"/storage/news/4.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 4: Consider A Wallet As A Long Term Investment</strong></h4>\n\n<p>Your wallet is indeed an investment that you should consider spending a decent amount of time and effort on it. Another factor that you need to consider is how much you want to spend on your wallet. The price ranges of wallets on the market vary a great deal. You can find a wallet which is as cheap as about 5 to 7 dollars. On the other hand, you should expect to pay around 250 to 300 dollars for a high-quality wallet.</p>\n\n<p>In case you need a wallet to use for a long time, it is a good idea that you should invest a decent amount of money on a wallet. A high quality wallet from a reputational brand with the premium quality such as cowhide leather will last for a long time. In addition, it is an accessory to show off your fashion sense and your social status.</p>\n\n<p style=\"text-align:center\"><img alt=\"f2\" src=\"/storage/news/5.jpg\" /></p>\n\n<p>&nbsp;</p>\n','published',1,'Botble\\ACL\\Models\\User',1,'news/3.jpg',397,NULL,'2021-07-02 21:03:27','2021-07-02 21:03:27'),(4,'How to Match the Color of Your Handbag With an Outfit','To match your multi-colored purses with your favorite outfits, simply select a complementary handbag hue that will make your outfit pop for work or the weekend.','<p>I have seen many people underestimating the power of their wallets. To them, they are just a functional item they use to carry. As a result, they often end up with the wallets which are not really suitable for them.</p>\n\n<p>You should pay more attention when you choose your wallets. There are a lot of them on the market with the different designs and styles. When you choose carefully, you would be able to buy a wallet that is catered to your needs. Not to mention that it will help to enhance your style significantly.</p>\n\n<p style=\"text-align:center\"><img alt=\"f4\" src=\"/storage/news/1.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<p><strong><em>For all of the reason above, here are 7 expert tips to help you pick up the right men&rsquo;s wallet for you:</em></strong></p>\n\n<h4><strong>Number 1: Choose A Neat Wallet</strong></h4>\n\n<p>The wallet is an essential accessory that you should go simple. Simplicity is the best in this case. A simple and neat wallet with the plain color and even&nbsp;<strong>minimalist style</strong>&nbsp;is versatile. It can be used for both formal and casual events. In addition, that wallet will go well with most of the clothes in your wardrobe.</p>\n\n<p>Keep in mind that a wallet will tell other people about your personality and your fashion sense as much as other clothes you put on. Hence, don&rsquo;t go cheesy on your wallet or else people will think that you have a funny and particular style.</p>\n\n<p style=\"text-align:center\"><img alt=\"f5\" src=\"/storage/news/2.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 2: Choose The Right Size For Your Wallet</strong></h4>\n\n<p>You should avoid having an over-sized wallet. Don&rsquo;t think that you need to buy a big wallet because you have a lot to carry with you. In addition, a fat wallet is very ugly. It will make it harder for you to slide the wallet into your trousers&rsquo; pocket. In addition, it will create a bulge and ruin your look.</p>\n\n<p>Before you go on to buy a new wallet, clean out your wallet and place all of the items from your wallet on a table. Throw away things that you would never need any more such as the old bills or the expired gift cards. Remember to check your wallet on a frequent basis to get rid of all of the old stuff that you don&rsquo;t need anymore.</p>\n\n<p style=\"text-align:center\"><img alt=\"f1\" src=\"/storage/news/3.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 3: Don&rsquo;t Limit Your Options Of Materials</strong></h4>\n\n<p>The types and designs of wallets are not the only things that you should consider when you go out searching for your best wallet. You have more than 1 option of material rather than leather to choose from as well.</p>\n\n<p>You can experiment with other available options such as cotton, polyester and canvas. They all have their own pros and cons. As a result, they will be suitable for different needs and requirements. You should think about them all in order to choose the material which you would like the most.</p>\n\n<p style=\"text-align:center\"><img alt=\"f6\" src=\"/storage/news/4.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 4: Consider A Wallet As A Long Term Investment</strong></h4>\n\n<p>Your wallet is indeed an investment that you should consider spending a decent amount of time and effort on it. Another factor that you need to consider is how much you want to spend on your wallet. The price ranges of wallets on the market vary a great deal. You can find a wallet which is as cheap as about 5 to 7 dollars. On the other hand, you should expect to pay around 250 to 300 dollars for a high-quality wallet.</p>\n\n<p>In case you need a wallet to use for a long time, it is a good idea that you should invest a decent amount of money on a wallet. A high quality wallet from a reputational brand with the premium quality such as cowhide leather will last for a long time. In addition, it is an accessory to show off your fashion sense and your social status.</p>\n\n<p style=\"text-align:center\"><img alt=\"f2\" src=\"/storage/news/5.jpg\" /></p>\n\n<p>&nbsp;</p>\n','published',1,'Botble\\ACL\\Models\\User',1,'news/4.jpg',401,NULL,'2021-07-02 21:03:27','2021-07-02 21:03:27'),(5,'How to Care for Leather Bags','A leather bag is a special, near-universally beloved object, appreciated in equal measure by bon-vivants of both sexes, who cherish the supple hand, understated burnish and heady smell that can only emanate from premium quality skin.','<p>I have seen many people underestimating the power of their wallets. To them, they are just a functional item they use to carry. As a result, they often end up with the wallets which are not really suitable for them.</p>\n\n<p>You should pay more attention when you choose your wallets. There are a lot of them on the market with the different designs and styles. When you choose carefully, you would be able to buy a wallet that is catered to your needs. Not to mention that it will help to enhance your style significantly.</p>\n\n<p style=\"text-align:center\"><img alt=\"f4\" src=\"/storage/news/1.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<p><strong><em>For all of the reason above, here are 7 expert tips to help you pick up the right men&rsquo;s wallet for you:</em></strong></p>\n\n<h4><strong>Number 1: Choose A Neat Wallet</strong></h4>\n\n<p>The wallet is an essential accessory that you should go simple. Simplicity is the best in this case. A simple and neat wallet with the plain color and even&nbsp;<strong>minimalist style</strong>&nbsp;is versatile. It can be used for both formal and casual events. In addition, that wallet will go well with most of the clothes in your wardrobe.</p>\n\n<p>Keep in mind that a wallet will tell other people about your personality and your fashion sense as much as other clothes you put on. Hence, don&rsquo;t go cheesy on your wallet or else people will think that you have a funny and particular style.</p>\n\n<p style=\"text-align:center\"><img alt=\"f5\" src=\"/storage/news/2.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 2: Choose The Right Size For Your Wallet</strong></h4>\n\n<p>You should avoid having an over-sized wallet. Don&rsquo;t think that you need to buy a big wallet because you have a lot to carry with you. In addition, a fat wallet is very ugly. It will make it harder for you to slide the wallet into your trousers&rsquo; pocket. In addition, it will create a bulge and ruin your look.</p>\n\n<p>Before you go on to buy a new wallet, clean out your wallet and place all of the items from your wallet on a table. Throw away things that you would never need any more such as the old bills or the expired gift cards. Remember to check your wallet on a frequent basis to get rid of all of the old stuff that you don&rsquo;t need anymore.</p>\n\n<p style=\"text-align:center\"><img alt=\"f1\" src=\"/storage/news/3.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 3: Don&rsquo;t Limit Your Options Of Materials</strong></h4>\n\n<p>The types and designs of wallets are not the only things that you should consider when you go out searching for your best wallet. You have more than 1 option of material rather than leather to choose from as well.</p>\n\n<p>You can experiment with other available options such as cotton, polyester and canvas. They all have their own pros and cons. As a result, they will be suitable for different needs and requirements. You should think about them all in order to choose the material which you would like the most.</p>\n\n<p style=\"text-align:center\"><img alt=\"f6\" src=\"/storage/news/4.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 4: Consider A Wallet As A Long Term Investment</strong></h4>\n\n<p>Your wallet is indeed an investment that you should consider spending a decent amount of time and effort on it. Another factor that you need to consider is how much you want to spend on your wallet. The price ranges of wallets on the market vary a great deal. You can find a wallet which is as cheap as about 5 to 7 dollars. On the other hand, you should expect to pay around 250 to 300 dollars for a high-quality wallet.</p>\n\n<p>In case you need a wallet to use for a long time, it is a good idea that you should invest a decent amount of money on a wallet. A high quality wallet from a reputational brand with the premium quality such as cowhide leather will last for a long time. In addition, it is an accessory to show off your fashion sense and your social status.</p>\n\n<p style=\"text-align:center\"><img alt=\"f2\" src=\"/storage/news/5.jpg\" /></p>\n\n<p>&nbsp;</p>\n','published',1,'Botble\\ACL\\Models\\User',1,'news/5.jpg',1005,NULL,'2021-07-02 21:03:27','2021-07-02 21:03:27'),(6,'We\'re Crushing Hard on Summer\'s 10 Biggest Bag Trends','Summer is just around the corner, and there\'s no easier way to amp up your new-season look than with a chic, new handbag. Whether you\'re wearing basic sweat shorts and a tank top or a pretty floral maxi dress, a bag is an effortless way to add interest to all your summer ensembles.','<p>I have seen many people underestimating the power of their wallets. To them, they are just a functional item they use to carry. As a result, they often end up with the wallets which are not really suitable for them.</p>\n\n<p>You should pay more attention when you choose your wallets. There are a lot of them on the market with the different designs and styles. When you choose carefully, you would be able to buy a wallet that is catered to your needs. Not to mention that it will help to enhance your style significantly.</p>\n\n<p style=\"text-align:center\"><img alt=\"f4\" src=\"/storage/news/1.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<p><strong><em>For all of the reason above, here are 7 expert tips to help you pick up the right men&rsquo;s wallet for you:</em></strong></p>\n\n<h4><strong>Number 1: Choose A Neat Wallet</strong></h4>\n\n<p>The wallet is an essential accessory that you should go simple. Simplicity is the best in this case. A simple and neat wallet with the plain color and even&nbsp;<strong>minimalist style</strong>&nbsp;is versatile. It can be used for both formal and casual events. In addition, that wallet will go well with most of the clothes in your wardrobe.</p>\n\n<p>Keep in mind that a wallet will tell other people about your personality and your fashion sense as much as other clothes you put on. Hence, don&rsquo;t go cheesy on your wallet or else people will think that you have a funny and particular style.</p>\n\n<p style=\"text-align:center\"><img alt=\"f5\" src=\"/storage/news/2.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 2: Choose The Right Size For Your Wallet</strong></h4>\n\n<p>You should avoid having an over-sized wallet. Don&rsquo;t think that you need to buy a big wallet because you have a lot to carry with you. In addition, a fat wallet is very ugly. It will make it harder for you to slide the wallet into your trousers&rsquo; pocket. In addition, it will create a bulge and ruin your look.</p>\n\n<p>Before you go on to buy a new wallet, clean out your wallet and place all of the items from your wallet on a table. Throw away things that you would never need any more such as the old bills or the expired gift cards. Remember to check your wallet on a frequent basis to get rid of all of the old stuff that you don&rsquo;t need anymore.</p>\n\n<p style=\"text-align:center\"><img alt=\"f1\" src=\"/storage/news/3.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 3: Don&rsquo;t Limit Your Options Of Materials</strong></h4>\n\n<p>The types and designs of wallets are not the only things that you should consider when you go out searching for your best wallet. You have more than 1 option of material rather than leather to choose from as well.</p>\n\n<p>You can experiment with other available options such as cotton, polyester and canvas. They all have their own pros and cons. As a result, they will be suitable for different needs and requirements. You should think about them all in order to choose the material which you would like the most.</p>\n\n<p style=\"text-align:center\"><img alt=\"f6\" src=\"/storage/news/4.jpg\" /></p>\n\n<p><br />\n&nbsp;</p>\n\n<hr />\n<h4><strong>Number 4: Consider A Wallet As A Long Term Investment</strong></h4>\n\n<p>Your wallet is indeed an investment that you should consider spending a decent amount of time and effort on it. Another factor that you need to consider is how much you want to spend on your wallet. The price ranges of wallets on the market vary a great deal. You can find a wallet which is as cheap as about 5 to 7 dollars. On the other hand, you should expect to pay around 250 to 300 dollars for a high-quality wallet.</p>\n\n<p>In case you need a wallet to use for a long time, it is a good idea that you should invest a decent amount of money on a wallet. A high quality wallet from a reputational brand with the premium quality such as cowhide leather will last for a long time. In addition, it is an accessory to show off your fashion sense and your social status.</p>\n\n<p style=\"text-align:center\"><img alt=\"f2\" src=\"/storage/news/5.jpg\" /></p>\n\n<p>&nbsp;</p>\n','published',1,'Botble\\ACL\\Models\\User',1,'news/6.jpg',106,NULL,'2021-07-02 21:03:27','2021-07-02 21:03:27');

--
-- Table structure for table `revisions`
--

CREATE TABLE `revisions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `revisionable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revisionable_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `old_value` text COLLATE utf8mb4_unicode_ci,
  `new_value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `revisions_revisionable_id_revisionable_type_index` (`revisionable_id`,`revisionable_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `revisions`
--


--
-- Table structure for table `role_users`
--

CREATE TABLE `role_users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `role_users_user_id_index` (`user_id`),
  KEY `role_users_role_id_index` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_users`
--


--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permissions` text COLLATE utf8mb4_unicode_ci,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_slug_unique` (`slug`),
  KEY `roles_created_by_index` (`created_by`),
  KEY `roles_updated_by_index` (`updated_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--


--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=191 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (4,'activated_plugins','[\"analytics\",\"audit-log\",\"backup\",\"blog\",\"captcha\",\"contact\",\"cookie-consent\",\"ecommerce\",\"mollie\",\"newsletter\",\"payment\",\"paystack\",\"razorpay\",\"simple-slider\",\"social-login\",\"sslcommerz\",\"testimonial\",\"translation\"]',NULL,NULL),(5,'permalink-botble-blog-models-post','news',NULL,NULL),(6,'permalink-botble-blog-models-category','news',NULL,NULL),(7,'permalink-botble-blog-models-tag','tags',NULL,NULL),(8,'payment_cod_status','1',NULL,NULL),(9,'payment_cod_description','Please pay money directly to the postman, if you choose cash on delivery method (COD).',NULL,NULL),(10,'payment_bank_transfer_status','1',NULL,NULL),(11,'payment_bank_transfer_description','Please send money to our bank account: ACB - 1990 404 19.',NULL,NULL),(12,'plugins_ecommerce_customer_new_order_status','0',NULL,NULL),(13,'plugins_ecommerce_admin_new_order_status','0',NULL,NULL),(14,'ecommerce_store_name','Shopwise',NULL,NULL),(15,'ecommerce_store_phone','123-456-7890',NULL,NULL),(16,'ecommerce_store_address','123 Street, Old Trafford',NULL,NULL),(17,'New York','Singapore',NULL,NULL),(18,'ecommerce_store_country','US',NULL,NULL),(20,'theme','shopwise',NULL,NULL),(40,'social_login_enable','1',NULL,NULL),(41,'social_login_facebook_enable','1',NULL,NULL),(42,'social_login_facebook_app_id','1752152358341085',NULL,NULL),(43,'social_login_facebook_app_secret','39a9c04311e0da0956298c6dcee7d5e6',NULL,NULL),(44,'social_login_google_enable','1',NULL,NULL),(47,'social_login_github_enable','1',NULL,NULL),(50,'social_login_linkedin_enable','1',NULL,NULL),(171,'theme-shopwise-site_title','Shopwise - Laravel Ecommerce system',NULL,NULL),(172,'theme-shopwise-copyright','© 2021 Botble Technologies. All Rights Reserved.',NULL,NULL),(173,'theme-shopwise-favicon','general/favicon.png',NULL,NULL),(174,'theme-shopwise-logo','general/logo.png',NULL,NULL),(175,'theme-shopwise-logo_footer','general/logo-light.png',NULL,NULL),(176,'theme-shopwise-address','123 Street, Old Trafford, NewYork, USA',NULL,NULL),(177,'theme-shopwise-hotline','123-456-7890',NULL,NULL),(178,'theme-shopwise-email','info@sitename.com',NULL,NULL),(179,'theme-shopwise-facebook','https://facebook.com',NULL,NULL),(180,'theme-shopwise-twitter','https://twitter.com',NULL,NULL),(181,'theme-shopwise-youtube','https://youtube.com',NULL,NULL),(182,'theme-shopwise-instagram','https://instagram.com',NULL,NULL),(183,'theme-shopwise-payment_methods','[\"general\\/visa.png\",\"general\\/paypal.png\",\"general\\/master-card.png\",\"general\\/discover.png\",\"general\\/american-express.png\"]',NULL,NULL),(184,'theme-shopwise-newsletter_image','general/newsletter.jpg',NULL,NULL),(185,'theme-shopwise-homepage_id','1',NULL,NULL),(186,'theme-shopwise-blog_page_id','3',NULL,NULL),(187,'theme-shopwise-cookie_consent_message','Your experience on this site will be improved by allowing cookies ',NULL,NULL),(188,'theme-shopwise-cookie_consent_learn_more_url','http://shopwise.local/cookie-policy',NULL,NULL),(189,'theme-shopwise-cookie_consent_learn_more_text','Cookie Policy',NULL,NULL);

--
-- Table structure for table `simple_slider_items`
--

CREATE TABLE `simple_slider_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `simple_slider_id` int(10) unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `order` int(10) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `simple_slider_items`
--

INSERT INTO `simple_slider_items` VALUES (1,1,'Woman Fashion','sliders/1.jpg','/products','Get up to 50% off Today Only!',1,'2021-07-02 21:03:28','2021-07-02 21:03:28'),(2,1,'Man Fashion','sliders/2.jpg','/products','50% off in all products',2,'2021-07-02 21:03:28','2021-07-02 21:03:28'),(3,1,'Summer Sale','sliders/3.jpg','/products','Taking your Viewing Experience to Next Level',3,'2021-07-02 21:03:28','2021-07-02 21:03:28');

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `author_id` int(11) NOT NULL,
  `author_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` VALUES (1,'General',1,'Botble\\ACL\\Models\\User','','published','2021-07-02 21:03:27','2021-07-02 21:03:27'),(2,'Design',1,'Botble\\ACL\\Models\\User','','published','2021-07-02 21:03:27','2021-07-02 21:03:27'),(3,'Jquery',1,'Botble\\ACL\\Models\\User','','published','2021-07-02 21:03:27','2021-07-02 21:03:27'),(4,'Branding',1,'Botble\\ACL\\Models\\User','','published','2021-07-02 21:03:27','2021-07-02 21:03:27'),(5,'Modern',1,'Botble\\ACL\\Models\\User','','published','2021-07-02 21:03:27','2021-07-02 21:03:27');

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` VALUES (1,'Donald H. Hilixer','Gryphon replied rather crossly: \'of course you.','testimonials/1.jpg','Founder, Hilix','published','2021-07-02 21:03:28','2021-07-02 21:03:28'),(2,'Rosalina D. William','HE taught us Drawling, Stretching, and Fainting.','testimonials/2.jpg','Founder, qux co.','published','2021-07-02 21:03:28','2021-07-02 21:03:28'),(3,'John Becker','Gryphon. \'Turn a somersault in the house, quite.','testimonials/3.jpg','CEO, Highlands coffee','published','2021-07-02 21:03:28','2021-07-02 21:03:28'),(4,'Browfish Dumble','Tortoise, if he wasn\'t going to turn round on.','testimonials/4.jpg','Founder, Condo','published','2021-07-02 21:03:28','2021-07-02 21:03:28');

--
-- Table structure for table `translations`
--

CREATE TABLE `translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` int(11) NOT NULL DEFAULT '0',
  `locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `group` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3627 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `translations`
--



--
-- Table structure for table `user_meta`
--

CREATE TABLE `user_meta` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_meta_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_meta`
--


--
-- Table structure for table `widgets`
--

CREATE TABLE `widgets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `widget_id` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sidebar_id` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `data` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `widgets`
--

INSERT INTO `widgets` VALUES (1,'CustomMenuWidget','footer_sidebar','shopwise',1,'{\"id\":\"CustomMenuWidget\",\"name\":\"Useful Links\",\"menu_id\":\"useful-links\"}','2021-07-02 21:03:29','2021-07-02 21:03:29'),(2,'CustomMenuWidget','footer_sidebar','shopwise',2,'{\"id\":\"CustomMenuWidget\",\"name\":\"Categories\",\"menu_id\":\"categories\"}','2021-07-02 21:03:29','2021-07-02 21:03:29'),(3,'CustomMenuWidget','footer_sidebar','shopwise',3,'{\"id\":\"CustomMenuWidget\",\"name\":\"My Account\",\"menu_id\":\"my-account\"}','2021-07-02 21:03:29','2021-07-02 21:03:29');


