--
-- Host: localhost    Database: martfury
-- ------------------------------------------------------


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

CREATE TABLE `activations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int 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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `activations` VALUES (1,1,'5627LNmLdaihHsVjZ68zEpVjgj3eSxLx',1,'2022-11-10 21:04:40','2022-11-10 21:04:40','2022-11-10 21:04:40');

--
-- Table structure for table `ads`
--

CREATE TABLE `ads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expired_at` datetime DEFAULT NULL,
  `location` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `key` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clicked` bigint NOT NULL DEFAULT '0',
  `order` int 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`),
  UNIQUE KEY `ads_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ads`
--

INSERT INTO `ads` VALUES (1,'Top Slider Image 1','2027-11-11 00:00:00','not_set','VC2C8Q1UGCBG','promotion/1.jpg','/products',0,1,'published','2022-11-10 21:04:40','2022-11-10 21:04:40'),(2,'Top Slider Image 2','2027-11-11 00:00:00','not_set','NBDWRXTSVZ8N','promotion/2.jpg','/products',0,2,'published','2022-11-10 21:04:40','2022-11-10 21:04:40'),(3,'Homepage middle 1','2027-11-11 00:00:00','not_set','IZ6WU8KUALYD','promotion/3.jpg','/products',0,3,'published','2022-11-10 21:04:40','2022-11-10 21:04:40'),(4,'Homepage middle 2','2027-11-11 00:00:00','not_set','ILSFJVYFGCPZ','promotion/4.jpg','/products',0,4,'published','2022-11-10 21:04:40','2022-11-10 21:04:40'),(5,'Homepage middle 3','2027-11-11 00:00:00','not_set','ZDOZUZZIU7FT','promotion/5.jpg','/products',0,5,'published','2022-11-10 21:04:40','2022-11-10 21:04:40'),(6,'Homepage big 1','2027-11-11 00:00:00','not_set','Q9YDUIC9HSWS','promotion/6.jpg','/products',0,6,'published','2022-11-10 21:04:40','2022-11-10 21:04:40'),(7,'Homepage bottom small','2027-11-11 00:00:00','not_set','SSFOIB1D7OGZ','promotion/7.jpg','/products',0,7,'published','2022-11-10 21:04:40','2022-11-10 21:04:40'),(8,'Product sidebar','2027-11-11 00:00:00','product-sidebar','5AJRTDTYKVR9','promotion/8.jpg','/products',0,8,'published','2022-11-10 21:04:40','2022-11-10 21:04:40'),(9,'Homepage big 2','2027-11-11 00:00:00','not_set','IZ6WU8KUALYE','promotion/9.jpg','/products',0,9,'published','2022-11-10 21:04:40','2022-11-10 21:04:40');

--
-- Table structure for table `ads_translations`
--

CREATE TABLE `ads_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ads_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ads_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ads_translations`
--

INSERT INTO `ads_translations` VALUES ('vi',1,'Top Slider Image 1','promotion/1.jpg','/vi/products'),('vi',2,'Top Slider Image 2','promotion/2.jpg','/vi/products'),('vi',3,'Homepage middle 1','promotion/3.jpg','/vi/products'),('vi',4,'Homepage middle 2','promotion/4.jpg','/vi/products'),('vi',5,'Homepage middle 3','promotion/5.jpg','/vi/products'),('vi',6,'Homepage big 1','promotion/6.jpg','/vi/products'),('vi',7,'Homepage bottom small','promotion/7.jpg','/vi/products'),('vi',8,'Product sidebar','promotion/8.jpg','/vi/products'),('vi',9,'Homepage big 2','promotion/9.jpg','/vi/products');

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

CREATE TABLE `audit_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int 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 unsigned NOT NULL,
  `reference_id` int 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 unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` int 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 NOT NULL,
  `author_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `icon` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_featured` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `status` (`status`),
  KEY `created_at` (`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` VALUES (1,'Ecommerce',0,'Ad ratione sit qui officiis eius reprehenderit et. Tenetur qui inventore nulla qui numquam ipsum qui sapiente. Quia qui non ab ut quo eum repudiandae et.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2022-11-10 21:04:38','2022-11-10 21:04:38'),(2,'Fashion',0,'Fugit est eos facilis debitis repellendus non. Eos quam eum velit molestias asperiores. Itaque nihil porro asperiores ratione dolores optio quia sit.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2022-11-10 21:04:38','2022-11-10 21:04:38'),(3,'Electronic',0,'Velit qui nihil consectetur ad. Et nam et veritatis reprehenderit quibusdam numquam vel. Distinctio sint sed repellendus animi et ut autem. Maiores fuga quia molestiae.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2022-11-10 21:04:38','2022-11-10 21:04:38'),(4,'Commercial',0,'Dolores in eos et dolor. Hic nihil consequuntur qui itaque quos. Amet maiores sit vel nemo minima. Id occaecati nesciunt minus quia suscipit deserunt.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2022-11-10 21:04:38','2022-11-10 21:04:38');

--
-- Table structure for table `categories_translations`
--

CREATE TABLE `categories_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `categories_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`categories_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories_translations`
--

INSERT INTO `categories_translations` VALUES ('vi',1,'Thương mại điện tử',NULL),('vi',2,'Thời trang',NULL),('vi',3,'Điện tử',NULL),('vi',4,'Thương mại',NULL);

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_id` int unsigned NOT NULL,
  `country_id` int unsigned DEFAULT NULL,
  `record_id` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--


--
-- Table structure for table `cities_translations`
--

CREATE TABLE `cities_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cities_id` int NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`cities_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities_translations`
--


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

CREATE TABLE `contact_replies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_id` int 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 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 AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `contacts` VALUES (1,'Afton Lebsack','nona.grady@example.net','+1-726-407-0262','7709 O\'Hara Harbor Apt. 233\nJonathonmouth, WY 86487-6831','Eveniet qui optio suscipit optio.','Natus maxime neque aperiam animi quibusdam tempora. Iusto et assumenda magni voluptate. Voluptatem occaecati ut optio vitae. Cumque eos voluptatum vel consequatur natus harum et suscipit. Placeat sit optio deleniti suscipit amet iste mollitia. Delectus nesciunt voluptatibus vero sed adipisci accusamus. In officia voluptatem expedita atque rem neque sed. Fuga amet ut vel.','read','2022-11-10 21:04:37','2022-11-10 21:04:37'),(2,'Ms. Heaven Jakubowski','schowalter.marlon@example.net','+1-657-313-2504','76305 Lorna Knoll\nPort Maximetown, MI 14012','Enim laboriosam explicabo et aut nisi optio.','Aut ut dolore libero inventore. Modi culpa nostrum illo vel illo harum. Laboriosam iure qui omnis deleniti in omnis soluta. Et est hic provident. Magnam expedita voluptatem totam similique. Eveniet et optio unde odit doloremque deleniti fugit blanditiis. Nostrum tenetur quam nesciunt fuga culpa. Impedit nisi cumque accusamus corporis quia. Porro natus aperiam ea dolores. Sed ut maxime et et sed sit.','read','2022-11-10 21:04:37','2022-11-10 21:04:37'),(3,'Domenick D\'Amore','lionel.buckridge@example.com','304.528.1965','523 Tyreek Orchard Apt. 082\nNew Stephania, CT 34427','Placeat aut ea omnis quas itaque commodi itaque.','Voluptas et earum laudantium quae. Et corporis voluptatum quis labore qui. Dolor autem odit nobis quibusdam tempore vel. Doloribus aut nihil consequatur soluta hic. Ex officia illum earum. Quas praesentium itaque non eum aliquid voluptates incidunt. Voluptates velit tempora consequatur. Laudantium atque omnis esse et voluptatem eos tempora. Quia sint adipisci totam ut omnis quis. Consequatur quibusdam ut error inventore mollitia est ea. Voluptatem eaque suscipit culpa excepturi aliquid.','read','2022-11-10 21:04:37','2022-11-10 21:04:37'),(4,'Mr. Narciso West I','tupton@example.net','+1.308.875.7437','7567 Camila Inlet Suite 925\nLake Mckenna, SC 76322','Dolores non atque placeat iure.','Illo sed ut dolorem non ea reprehenderit ut. Natus quia in sed eaque. Nostrum quaerat perspiciatis est accusantium. Sit omnis beatae eum reprehenderit aut error. Nisi voluptates exercitationem exercitationem delectus. Repellendus doloribus facere id pariatur autem expedita cumque. Non ea sit recusandae voluptates accusamus. Nobis non quis laborum quis esse necessitatibus. Repellat quis aliquam alias in. Culpa inventore iusto magnam est est nemo sapiente.','unread','2022-11-10 21:04:37','2022-11-10 21:04:37'),(5,'Mrs. Lonie Franecki MD','fcorwin@example.com','+1.240.247.5427','69144 Parker Ports Suite 515\nNorth Ezekiel, AR 98166','Quibusdam sit amet exercitationem.','Dolorum ullam dicta magnam nemo quia et. Sed nobis doloribus ut aut saepe sapiente rerum. Natus neque et sunt velit quasi et tempora. Molestiae beatae veritatis neque labore. Odit quam accusamus et voluptatibus minus cupiditate quae deserunt. Amet saepe odit eos iste. Atque illum nobis non molestiae ipsam. Possimus accusamus eum sed animi. Et occaecati omnis sed molestiae. Magnam placeat nisi labore rerum numquam sed at quasi. Ab sit nobis possimus.','unread','2022-11-10 21:04:37','2022-11-10 21:04:37'),(6,'Mr. Giovanny Greenfelder II','chad.nader@example.net','+1.979.210.9803','75696 Okuneva Groves\nPort Georgette, AZ 34325','Distinctio in sed aspernatur repudiandae.','Dolore dolore odio earum facere ea adipisci dolor. Aut ducimus quis aut ut ut. Et earum ut quos nihil fugiat nobis excepturi sit. Et qui aut error qui libero rerum aut. Tempora esse odit a. Labore numquam sint sit et fuga non sed. Ipsam aperiam commodi facilis vel eius excepturi maiores reiciendis. Perspiciatis cumque et iusto qui dicta consequatur corporis.','unread','2022-11-10 21:04:37','2022-11-10 21:04:37'),(7,'Eliza Langosh','deffertz@example.org','+15053662169','688 Joe Lake Apt. 022\nGottliebstad, AL 59721-9502','Sed sequi nobis explicabo.','Aut labore hic commodi commodi. Consequatur ipsum animi consequatur repellendus alias aliquam hic. Facere perferendis eius qui aliquid voluptatibus velit unde. Quo occaecati sed blanditiis iusto repellat laborum. Est quidem itaque quas laboriosam repudiandae sunt et. Saepe quas earum necessitatibus enim aut et consectetur. Et et et in eius. Minus aut officia sequi itaque sunt maiores. Perspiciatis quisquam voluptatem deserunt velit est error. Dolorum magni fuga numquam nulla sit.','read','2022-11-10 21:04:37','2022-11-10 21:04:37'),(8,'Prof. Grace Simonis I','eveline87@example.net','+1-952-594-3451','43097 Braun Run Apt. 209\nNew Marciaside, KY 97399-7551','Esse ab magni ut modi laborum.','Hic enim provident perferendis. Dolores sint et voluptatibus odio dolorum. Qui ut ut non aut. Odio molestiae modi libero assumenda. Tempora modi ab possimus odio. Nam tenetur molestiae ea iure voluptatum ab molestias. Fuga omnis et beatae vel debitis. Architecto amet ipsam dolor dolore molestiae a accusantium. Consequuntur ut et fugiat nostrum placeat id. Velit eius non asperiores inventore quos.','unread','2022-11-10 21:04:37','2022-11-10 21:04:37'),(9,'Cheyanne Bauch','johnathan67@example.net','+1-669-552-4313','2675 Quitzon Fort Apt. 747\nBinsville, PA 71205-3767','Quia fugit necessitatibus eos soluta ex.','Non delectus nulla qui qui earum voluptates officiis. Beatae mollitia labore sed nostrum provident nihil perspiciatis. Soluta illo necessitatibus natus et. Ullam quia unde qui aliquam magnam recusandae. Et quis aliquid facere cupiditate non consequatur. Omnis mollitia quibusdam voluptate omnis. Dolores pariatur ipsa excepturi aut consequuntur. Consequatur magni cumque placeat nam ullam nemo quae.','read','2022-11-10 21:04:37','2022-11-10 21:04:37'),(10,'Lurline Sporer','carleton.schmidt@example.org','+1-734-394-2174','1677 Willms Extensions Suite 597\nEast Maiyahaven, IN 11242-6054','Et voluptatem iste id incidunt eos.','Rerum impedit veniam itaque est blanditiis. Tenetur deserunt voluptatem officiis ut. Et nihil aspernatur in autem quod. Aliquid consectetur fugiat cum explicabo. Eaque cupiditate fuga hic omnis dolorem aperiam. Temporibus ab provident ipsa laborum similique voluptates. Soluta aut quia et architecto aut eveniet. Incidunt officiis autem quia praesentium recusandae eos. Illum explicabo eaque et ut ea quisquam est perferendis. Omnis non dolor quod dolores ut. Quia sit ipsum corrupti doloremque.','unread','2022-11-10 21:04:37','2022-11-10 21:04:37');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nationality` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint 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,
  `code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--


--
-- Table structure for table `countries_translations`
--

CREATE TABLE `countries_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `countries_id` int NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nationality` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`countries_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries_translations`
--


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

CREATE TABLE `dashboard_widget_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `settings` text COLLATE utf8mb4_unicode_ci,
  `user_id` int unsigned NOT NULL,
  `widget_id` int unsigned NOT NULL,
  `order` tinyint unsigned NOT NULL DEFAULT '0',
  `status` tinyint 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 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `ec_brands` (
  `id` bigint 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 unsigned NOT NULL DEFAULT '0',
  `is_featured` tinyint 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.jpg','published',0,1,'2022-11-10 21:04:30','2022-11-10 21:04:30'),(2,'Hand crafted',NULL,NULL,'brands/2.jpg','published',1,1,'2022-11-10 21:04:30','2022-11-10 21:04:30'),(3,'Mestonix',NULL,NULL,'brands/3.jpg','published',2,1,'2022-11-10 21:04:30','2022-11-10 21:04:30'),(4,'Sunshine',NULL,NULL,'brands/4.jpg','published',3,1,'2022-11-10 21:04:30','2022-11-10 21:04:30'),(5,'Pure',NULL,NULL,'brands/5.jpg','published',4,1,'2022-11-10 21:04:30','2022-11-10 21:04:30'),(6,'Anfold',NULL,NULL,'brands/6.jpg','published',5,1,'2022-11-10 21:04:30','2022-11-10 21:04:30'),(7,'Automotive',NULL,NULL,'brands/7.jpg','published',6,1,'2022-11-10 21:04:30','2022-11-10 21:04:30');

--
-- Table structure for table `ec_brands_translations`
--

CREATE TABLE `ec_brands_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_brands_id` int NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_brands_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_brands_translations`
--

INSERT INTO `ec_brands_translations` VALUES ('vi',1,'Fashion live',NULL),('vi',2,'Hand crafted',NULL),('vi',3,'Mestonix',NULL),('vi',4,'Sunshine',NULL),('vi',5,'Pure',NULL),('vi',6,'Anfold',NULL),('vi',7,'Automotive',NULL);

--
-- 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 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 unsigned NOT NULL DEFAULT '0',
  `decimals` tinyint unsigned DEFAULT '0',
  `order` int unsigned DEFAULT '0',
  `is_default` tinyint 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,'2022-11-10 21:04:30','2022-11-10 21:04:30'),(2,'EUR','€',0,2,1,0,0.84,'2022-11-10 21:04:30','2022-11-10 21:04:30'),(3,'VND','₫',0,0,2,0,23203,'2022-11-10 21:04:30','2022-11-10 21:04:30');

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

CREATE TABLE `ec_customer_addresses` (
  `id` bigint 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(20) CHARACTER SET utf8mb4 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(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` int unsigned NOT NULL,
  `is_default` tinyint 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,'Berneice Klein','customer@botble.com','+17573310260','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',1,1,'2022-11-10 21:04:37','2022-11-10 21:04:37','67581'),(2,'Berneice Klein','customer@botble.com','+12123103583','ZM','Wyoming','Predovicstad','563 Burdette Underpass',1,0,'2022-11-10 21:04:37','2022-11-10 21:04:37','78804'),(3,'Dr. Brad Thiel','vendor@botble.com','+12792063467','SZ','Maine','Lake Lourdesmouth','98918 Trystan Turnpike Suite 841',2,1,'2022-11-10 21:04:37','2022-11-10 21:04:37','01372-7453'),(4,'Dr. Brad Thiel','vendor@botble.com','+16814314955','UZ','Texas','Quigleyton','510 Janis Ports Apt. 451',2,0,'2022-11-10 21:04:37','2022-11-10 21:04:37','42581-4912'),(5,'Benjamin Ullrich','reynolds.adrien@example.org','+17862843339','GG','North Carolina','Unashire','484 Rath Lodge Apt. 858',3,1,'2022-11-10 21:04:37','2022-11-10 21:04:37','54906'),(6,'Karli VonRueden Sr.','vkub@example.org','+13099371127','CN','Tennessee','Schimmelfurt','601 Quigley Circle',4,1,'2022-11-10 21:04:37','2022-11-10 21:04:37','87422-4680'),(7,'Miss Jayda Erdman','cade.cremin@example.org','+13236726833','NR','New Mexico','Daretown','21488 Krystel Dam',5,1,'2022-11-10 21:04:37','2022-11-10 21:04:37','87007'),(8,'Vella Oberbrunner','reilly18@example.org','+19304994609','GU','Nevada','Coraton','482 Stehr Glen',6,1,'2022-11-10 21:04:37','2022-11-10 21:04:37','36894'),(9,'Lonzo Bauch Jr.','lorna.block@example.net','+12408489996','RS','North Dakota','Port Elmerborough','154 Berge Extension Suite 744',7,1,'2022-11-10 21:04:37','2022-11-10 21:04:37','93671-8125'),(10,'Eli Powlowski','addie.schoen@example.com','+18453156386','PF','Maine','North Hectorstad','78271 Steuber Gateway',8,1,'2022-11-10 21:04:37','2022-11-10 21:04:37','64118'),(11,'Kaelyn Hilpert II','maximilian.feest@example.com','+16802533230','FJ','New York','O\'Connerberg','237 Christopher Brook',9,1,'2022-11-10 21:04:37','2022-11-10 21:04:37','96089-4621'),(12,'Mr. Garry Bins I','gmclaughlin@example.org','+14584402296','BE','Washington','Ondrickaberg','9317 Clyde Skyway Apt. 775',10,1,'2022-11-10 21:04:37','2022-11-10 21:04:37','39641');

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

CREATE TABLE `ec_customer_recently_viewed_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int unsigned NOT NULL,
  `product_id` int unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_customer_recently_viewed_products`
--


--
-- Table structure for table `ec_customers`
--

CREATE TABLE `ec_customers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `phone` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `confirmed_at` datetime DEFAULT NULL,
  `email_verify_token` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'activated',
  `is_vendor` tinyint(1) NOT NULL DEFAULT '0',
  `vendor_verified_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_customers_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_customers`
--

INSERT INTO `ec_customers` VALUES (1,'Berneice Klein','customer@botble.com','$2y$10$OTd3xWXlHuK/eYhlv57pw.4dBJp2UckMIxw26riV3QXQpkEIILp5S','customers/9.jpg','1982-10-13','+19375399244',NULL,'2022-11-10 21:04:37','2022-11-10 21:04:37','2022-11-11 04:04:37',NULL,'activated',0,NULL),(2,'Dr. Brad Thiel','vendor@botble.com','$2y$10$Ck4f6ftGoU8v3e9Zh/rR6O5vdJ9vs4Ryok.F9zpAJqJgoyzaiv/4O','customers/1.jpg','1990-11-03','+12158861719',NULL,'2022-11-10 21:04:37','2022-11-10 21:04:42','2022-11-11 04:04:37',NULL,'activated',1,'2022-11-11 04:04:42'),(3,'Benjamin Ullrich','reynolds.adrien@example.org','$2y$10$x0VFcGU53zrw0bYoBWA5aOKhkbmTDrkXMU4p3bgz5lQDhvdRfa4hi','customers/1.jpg','1979-10-26','+15155228324',NULL,'2022-11-10 21:04:37','2022-11-10 21:04:37','2022-11-11 04:04:37',NULL,'activated',0,NULL),(4,'Karli VonRueden Sr.','vkub@example.org','$2y$10$RV/bsidfSvJdPB9nqlD06uM.NMCsUolBjfbyiFZZGPl4Yq1XydQr6','customers/2.jpg','1997-10-29','+17604571819',NULL,'2022-11-10 21:04:37','2022-11-10 21:04:37','2022-11-11 04:04:37',NULL,'activated',0,NULL),(5,'Miss Jayda Erdman','cade.cremin@example.org','$2y$10$HX851CiSeEa.eatz1L66eeLHtFgUXlN2YT1PrxKdli9C3ek3yaNF2','customers/3.jpg','1992-10-21','+14842526742',NULL,'2022-11-10 21:04:37','2022-11-10 21:04:42','2022-11-11 04:04:37',NULL,'activated',1,'2022-11-11 04:04:42'),(6,'Vella Oberbrunner','reilly18@example.org','$2y$10$Fh2onet3pACnukr4jvyzbexlwXZDyZnz9bZkk61/NGMvLjScBPtUS','customers/4.jpg','1999-10-28','+18457293397',NULL,'2022-11-10 21:04:37','2022-11-10 21:04:42','2022-11-11 04:04:37',NULL,'activated',1,'2022-11-11 04:04:42'),(7,'Lonzo Bauch Jr.','lorna.block@example.net','$2y$10$4FCZv5vxffZHX5Z5k1/A7.0m9vIPMOq05rmZF9tn7bC5YxCPEFcAK','customers/5.jpg','1976-11-02','+13608781570',NULL,'2022-11-10 21:04:37','2022-11-10 21:04:42','2022-11-11 04:04:37',NULL,'activated',1,'2022-11-11 04:04:42'),(8,'Eli Powlowski','addie.schoen@example.com','$2y$10$.juOJkrmpTRuA40LG7jaaeK.qqR0MtEjnAV6qxLvLZqVQYtmHu9W2','customers/6.jpg','1984-11-10','+14782538629',NULL,'2022-11-10 21:04:37','2022-11-10 21:04:37','2022-11-11 04:04:37',NULL,'activated',0,NULL),(9,'Kaelyn Hilpert II','maximilian.feest@example.com','$2y$10$A.VJ7OZWkFKrognZa4Ivj.Vtu/Oany3U.5k41h5U3csc9gJlebMGy','customers/7.jpg','1980-10-21','+17543822413',NULL,'2022-11-10 21:04:37','2022-11-10 21:04:42','2022-11-11 04:04:37',NULL,'activated',1,'2022-11-11 04:04:42'),(10,'Mr. Garry Bins I','gmclaughlin@example.org','$2y$10$aNcEqAki.S72v2F/8BfBhOI2BYFtgXlu/dNQwfTmBXFgQPOCbmL9q','customers/8.jpg','1973-10-13','+15853269556',NULL,'2022-11-10 21:04:37','2022-11-10 21:04:42','2022-11-11 04:04:37',NULL,'activated',1,'2022-11-11 04:04:42');

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

CREATE TABLE `ec_discount_customers` (
  `discount_id` int unsigned NOT NULL,
  `customer_id` int 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 unsigned NOT NULL,
  `product_collection_id` int 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 unsigned NOT NULL,
  `product_id` int 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 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 DEFAULT NULL,
  `total_used` int 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 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,
  `store_id` int unsigned 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 unsigned NOT NULL,
  `product_id` int unsigned NOT NULL,
  `price` double unsigned DEFAULT NULL,
  `quantity` int unsigned DEFAULT NULL,
  `sold` int 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,1,53.7675,9,5),(1,2,17.82,13,1),(1,3,8.2,16,2),(1,4,140.0688,15,3),(1,5,292.06,14,5),(1,6,345.87,9,3),(1,7,343.04,12,1),(1,8,734.31,13,5),(1,9,215.66,6,2),(1,10,696,20,3);

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

CREATE TABLE `ec_flash_sales` (
  `id` bigint 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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_flash_sales` VALUES (1,'Winter Sale','2022-12-11 00:00:00','published','2022-11-10 21:04:37','2022-11-10 21:04:37');

--
-- Table structure for table `ec_flash_sales_translations`
--

CREATE TABLE `ec_flash_sales_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_flash_sales_id` int NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_flash_sales_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_flash_sales_translations`
--

INSERT INTO `ec_flash_sales_translations` VALUES ('vi',1,'Khuyến mãi mùa đông.');

--
-- Table structure for table `ec_global_option_value`
--

CREATE TABLE `ec_global_option_value` (
  `option_id` bigint NOT NULL COMMENT 'option id',
  `option_value` tinytext COLLATE utf8mb4_unicode_ci COMMENT 'option value',
  `affect_price` double DEFAULT NULL COMMENT 'value of price of this option affect',
  `order` int NOT NULL DEFAULT '9999',
  `affect_type` tinyint NOT NULL DEFAULT '0' COMMENT '0. fixed 1. percent',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_global_option_value`
--

INSERT INTO `ec_global_option_value` VALUES (1,'1 Year',0,9999,0,'2022-11-10 21:04:41','2022-11-10 21:04:41'),(1,'2 Year',10,9999,0,'2022-11-10 21:04:41','2022-11-10 21:04:41'),(1,'3 Year',20,9999,0,'2022-11-10 21:04:41','2022-11-10 21:04:41'),(2,'4GB',0,9999,0,'2022-11-10 21:04:41','2022-11-10 21:04:41'),(2,'8GB',10,9999,0,'2022-11-10 21:04:41','2022-11-10 21:04:41'),(2,'16GB',20,9999,0,'2022-11-10 21:04:41','2022-11-10 21:04:41'),(3,'Core i5',0,9999,0,'2022-11-10 21:04:41','2022-11-10 21:04:41'),(3,'Core i7',10,9999,0,'2022-11-10 21:04:41','2022-11-10 21:04:41'),(3,'Core i9',20,9999,0,'2022-11-10 21:04:41','2022-11-10 21:04:41'),(4,'128GB',0,9999,0,'2022-11-10 21:04:41','2022-11-10 21:04:41'),(4,'256GB',10,9999,0,'2022-11-10 21:04:41','2022-11-10 21:04:41'),(4,'512GB',20,9999,0,'2022-11-10 21:04:41','2022-11-10 21:04:41');

--
-- Table structure for table `ec_global_options`
--

CREATE TABLE `ec_global_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of options',
  `option_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'option type',
  `required` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Checked if this option is required',
  `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 `ec_global_options`
--

INSERT INTO `ec_global_options` VALUES (1,'Warranty','Botble\\Ecommerce\\Option\\OptionType\\RadioButton',1,'2022-11-10 21:04:41','2022-11-10 21:04:41'),(2,'RAM','Botble\\Ecommerce\\Option\\OptionType\\RadioButton',1,'2022-11-10 21:04:41','2022-11-10 21:04:41'),(3,'CPU','Botble\\Ecommerce\\Option\\OptionType\\RadioButton',1,'2022-11-10 21:04:41','2022-11-10 21:04:41'),(4,'HDD','Botble\\Ecommerce\\Option\\OptionType\\Dropdown',0,'2022-11-10 21:04:41','2022-11-10 21:04:41');

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

CREATE TABLE `ec_grouped_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `parent_product_id` int unsigned NOT NULL,
  `product_id` int unsigned NOT NULL,
  `fixed_qty` int 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_invoice_items`
--

CREATE TABLE `ec_invoice_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint unsigned NOT NULL,
  `reference_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` int unsigned NOT NULL,
  `sub_total` decimal(15,2) unsigned NOT NULL,
  `tax_amount` decimal(15,2) unsigned NOT NULL DEFAULT '0.00',
  `discount_amount` decimal(15,2) unsigned NOT NULL DEFAULT '0.00',
  `amount` decimal(15,2) unsigned NOT NULL,
  `options` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_invoice_items_reference_type_reference_id_index` (`reference_type`,`reference_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_invoice_items`
--


--
-- Table structure for table `ec_invoices`
--

CREATE TABLE `ec_invoices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `reference_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_tax_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_total` decimal(15,2) unsigned NOT NULL,
  `tax_amount` decimal(15,2) unsigned NOT NULL DEFAULT '0.00',
  `shipping_amount` decimal(15,2) unsigned NOT NULL DEFAULT '0.00',
  `discount_amount` decimal(15,2) unsigned NOT NULL DEFAULT '0.00',
  `shipping_option` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_method` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
  `coupon_code` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(15,2) unsigned NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `payment_id` int unsigned DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `paid_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_invoices_code_unique` (`code`),
  KEY `ec_invoices_reference_type_reference_id_index` (`reference_type`,`reference_id`),
  KEY `ec_invoices_payment_id_index` (`payment_id`),
  KEY `ec_invoices_status_index` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_invoices`
--


--
-- Table structure for table `ec_option_value`
--

CREATE TABLE `ec_option_value` (
  `option_id` bigint NOT NULL COMMENT 'option id',
  `option_value` tinytext COLLATE utf8mb4_unicode_ci COMMENT 'option value',
  `affect_price` double DEFAULT NULL COMMENT 'value of price of this option affect',
  `order` int NOT NULL DEFAULT '9999',
  `affect_type` tinyint NOT NULL DEFAULT '0' COMMENT '0. fixed 1. percent',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_option_value`
--


--
-- Table structure for table `ec_options`
--

CREATE TABLE `ec_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of options',
  `option_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'option type',
  `product_id` bigint NOT NULL DEFAULT '0',
  `order` int NOT NULL DEFAULT '9999',
  `required` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Checked if this option is required',
  `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_options`
--


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

CREATE TABLE `ec_order_addresses` (
  `id` bigint 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 unsigned NOT NULL,
  `zip_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'shipping_address',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_order_addresses` VALUES (1,'Eli Powlowski','+18453156386','addie.schoen@example.com','PF','Maine','North Hectorstad','78271 Steuber Gateway',1,'64118','shipping_address'),(2,'Eli Powlowski','+18453156386','addie.schoen@example.com','PF','Maine','North Hectorstad','78271 Steuber Gateway',2,'64118','shipping_address'),(3,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',3,'87422-4680','shipping_address'),(4,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',4,'87422-4680','shipping_address'),(5,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',5,'87422-4680','shipping_address'),(6,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',6,'87422-4680','shipping_address'),(7,'Benjamin Ullrich','+17862843339','reynolds.adrien@example.org','GG','North Carolina','Unashire','484 Rath Lodge Apt. 858',7,'54906','shipping_address'),(8,'Benjamin Ullrich','+17862843339','reynolds.adrien@example.org','GG','North Carolina','Unashire','484 Rath Lodge Apt. 858',8,'54906','shipping_address'),(9,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',9,'87422-4680','shipping_address'),(10,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',10,'87422-4680','shipping_address'),(11,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',11,'87422-4680','shipping_address'),(12,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',12,'87422-4680','shipping_address'),(13,'Berneice Klein','+17573310260','customer@botble.com','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',13,'67581','shipping_address'),(14,'Berneice Klein','+17573310260','customer@botble.com','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',14,'67581','shipping_address'),(15,'Eli Powlowski','+18453156386','addie.schoen@example.com','PF','Maine','North Hectorstad','78271 Steuber Gateway',15,'64118','shipping_address'),(16,'Eli Powlowski','+18453156386','addie.schoen@example.com','PF','Maine','North Hectorstad','78271 Steuber Gateway',16,'64118','shipping_address'),(17,'Berneice Klein','+17573310260','customer@botble.com','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',17,'67581','shipping_address'),(18,'Berneice Klein','+17573310260','customer@botble.com','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',18,'67581','shipping_address'),(19,'Berneice Klein','+17573310260','customer@botble.com','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',19,'67581','shipping_address'),(20,'Berneice Klein','+17573310260','customer@botble.com','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',20,'67581','shipping_address'),(21,'Berneice Klein','+17573310260','customer@botble.com','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',21,'67581','shipping_address'),(22,'Berneice Klein','+17573310260','customer@botble.com','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',22,'67581','shipping_address'),(23,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',23,'87422-4680','shipping_address'),(24,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',24,'87422-4680','shipping_address'),(25,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',25,'87422-4680','shipping_address'),(26,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',26,'87422-4680','shipping_address'),(27,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',27,'87422-4680','shipping_address'),(28,'Benjamin Ullrich','+17862843339','reynolds.adrien@example.org','GG','North Carolina','Unashire','484 Rath Lodge Apt. 858',28,'54906','shipping_address'),(29,'Benjamin Ullrich','+17862843339','reynolds.adrien@example.org','GG','North Carolina','Unashire','484 Rath Lodge Apt. 858',29,'54906','shipping_address'),(30,'Benjamin Ullrich','+17862843339','reynolds.adrien@example.org','GG','North Carolina','Unashire','484 Rath Lodge Apt. 858',30,'54906','shipping_address'),(31,'Berneice Klein','+17573310260','customer@botble.com','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',31,'67581','shipping_address'),(32,'Berneice Klein','+17573310260','customer@botble.com','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',32,'67581','shipping_address'),(33,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',33,'87422-4680','shipping_address'),(34,'Karli VonRueden Sr.','+13099371127','vkub@example.org','CN','Tennessee','Schimmelfurt','601 Quigley Circle',34,'87422-4680','shipping_address'),(35,'Benjamin Ullrich','+17862843339','reynolds.adrien@example.org','GG','North Carolina','Unashire','484 Rath Lodge Apt. 858',35,'54906','shipping_address'),(36,'Benjamin Ullrich','+17862843339','reynolds.adrien@example.org','GG','North Carolina','Unashire','484 Rath Lodge Apt. 858',36,'54906','shipping_address'),(37,'Benjamin Ullrich','+17862843339','reynolds.adrien@example.org','GG','North Carolina','Unashire','484 Rath Lodge Apt. 858',37,'54906','shipping_address'),(38,'Benjamin Ullrich','+17862843339','reynolds.adrien@example.org','GG','North Carolina','Unashire','484 Rath Lodge Apt. 858',38,'54906','shipping_address'),(39,'Berneice Klein','+17573310260','customer@botble.com','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',39,'67581','shipping_address'),(40,'Berneice Klein','+17573310260','customer@botble.com','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',40,'67581','shipping_address'),(41,'Berneice Klein','+17573310260','customer@botble.com','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',41,'67581','shipping_address'),(42,'Berneice Klein','+17573310260','customer@botble.com','UG','Florida','East Samara','87404 Schinner Ferry Apt. 024',42,'67581','shipping_address');

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

CREATE TABLE `ec_order_histories` (
  `id` bigint 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 unsigned DEFAULT NULL,
  `order_id` int 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=184 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,'2022-10-28 13:04:42','2022-10-28 13:04:42'),(2,'confirm_order','Order was verified by %user_name%',0,1,NULL,'2022-10-28 13:04:42','2022-10-28 13:04:42'),(3,'confirm_payment','Payment was confirmed (amount $1,698.80) by %user_name%',0,1,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(4,'create_shipment','Created shipment for order',0,1,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(5,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,1,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(6,'create_order_from_seeder','Order is created from the checkout page',NULL,2,NULL,'2022-11-04 05:04:42','2022-11-04 05:04:42'),(7,'confirm_order','Order was verified by %user_name%',0,2,NULL,'2022-11-04 05:04:42','2022-11-04 05:04:42'),(8,'confirm_payment','Payment was confirmed (amount $2,904.30) by %user_name%',0,2,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(9,'create_shipment','Created shipment for order',0,2,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(10,'create_order_from_seeder','Order is created from the checkout page',NULL,3,NULL,'2022-10-26 01:04:42','2022-10-26 01:04:42'),(11,'confirm_order','Order was verified by %user_name%',0,3,NULL,'2022-10-26 01:04:42','2022-10-26 01:04:42'),(12,'confirm_payment','Payment was confirmed (amount $44.55) by %user_name%',0,3,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(13,'create_shipment','Created shipment for order',0,3,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(14,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,3,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(15,'create_order_from_seeder','Order is created from the checkout page',NULL,4,NULL,'2022-10-29 05:04:42','2022-10-29 05:04:42'),(16,'confirm_order','Order was verified by %user_name%',0,4,NULL,'2022-10-29 05:04:42','2022-10-29 05:04:42'),(17,'create_shipment','Created shipment for order',0,4,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(18,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,4,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(19,'create_order_from_seeder','Order is created from the checkout page',NULL,5,NULL,'2022-11-09 09:04:42','2022-11-09 09:04:42'),(20,'confirm_order','Order was verified by %user_name%',0,5,NULL,'2022-11-09 09:04:42','2022-11-09 09:04:42'),(21,'confirm_payment','Payment was confirmed (amount $3,884.30) by %user_name%',0,5,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(22,'create_shipment','Created shipment for order',0,5,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(23,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,5,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(24,'create_order_from_seeder','Order is created from the checkout page',NULL,6,NULL,'2022-11-01 21:04:42','2022-11-01 21:04:42'),(25,'confirm_order','Order was verified by %user_name%',0,6,NULL,'2022-11-01 21:04:42','2022-11-01 21:04:42'),(26,'confirm_payment','Payment was confirmed (amount $2,374.60) by %user_name%',0,6,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(27,'create_shipment','Created shipment for order',0,6,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(28,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,6,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(29,'create_order_from_seeder','Order is created from the checkout page',NULL,7,NULL,'2022-10-30 13:04:42','2022-10-30 13:04:42'),(30,'confirm_order','Order was verified by %user_name%',0,7,NULL,'2022-10-30 13:04:42','2022-10-30 13:04:42'),(31,'create_shipment','Created shipment for order',0,7,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(32,'create_order_from_seeder','Order is created from the checkout page',NULL,8,NULL,'2022-10-31 23:04:42','2022-10-31 23:04:42'),(33,'confirm_order','Order was verified by %user_name%',0,8,NULL,'2022-10-31 23:04:42','2022-10-31 23:04:42'),(34,'create_shipment','Created shipment for order',0,8,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(35,'create_order_from_seeder','Order is created from the checkout page',NULL,9,NULL,'2022-11-01 13:04:42','2022-11-01 13:04:42'),(36,'confirm_order','Order was verified by %user_name%',0,9,NULL,'2022-11-01 13:04:42','2022-11-01 13:04:42'),(37,'confirm_payment','Payment was confirmed (amount $578.60) by %user_name%',0,9,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(38,'create_shipment','Created shipment for order',0,9,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(39,'create_order_from_seeder','Order is created from the checkout page',NULL,10,NULL,'2022-11-01 13:04:42','2022-11-01 13:04:42'),(40,'confirm_order','Order was verified by %user_name%',0,10,NULL,'2022-11-01 13:04:42','2022-11-01 13:04:42'),(41,'confirm_payment','Payment was confirmed (amount $4,769.90) by %user_name%',0,10,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(42,'create_shipment','Created shipment for order',0,10,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(43,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,10,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(44,'create_order_from_seeder','Order is created from the checkout page',NULL,11,NULL,'2022-11-09 15:04:42','2022-11-09 15:04:42'),(45,'confirm_order','Order was verified by %user_name%',0,11,NULL,'2022-11-09 15:04:42','2022-11-09 15:04:42'),(46,'confirm_payment','Payment was confirmed (amount $469.70) by %user_name%',0,11,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(47,'create_shipment','Created shipment for order',0,11,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(48,'create_order_from_seeder','Order is created from the checkout page',NULL,12,NULL,'2022-11-09 15:04:42','2022-11-09 15:04:42'),(49,'confirm_order','Order was verified by %user_name%',0,12,NULL,'2022-11-09 15:04:42','2022-11-09 15:04:42'),(50,'confirm_payment','Payment was confirmed (amount $3,701.40) by %user_name%',0,12,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(51,'create_shipment','Created shipment for order',0,12,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(52,'create_order_from_seeder','Order is created from the checkout page',NULL,13,NULL,'2022-11-02 17:04:42','2022-11-02 17:04:42'),(53,'confirm_order','Order was verified by %user_name%',0,13,NULL,'2022-11-02 17:04:42','2022-11-02 17:04:42'),(54,'create_shipment','Created shipment for order',0,13,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(55,'create_order_from_seeder','Order is created from the checkout page',NULL,14,NULL,'2022-11-05 01:04:42','2022-11-05 01:04:42'),(56,'confirm_order','Order was verified by %user_name%',0,14,NULL,'2022-11-05 01:04:42','2022-11-05 01:04:42'),(57,'confirm_payment','Payment was confirmed (amount $1,875.30) by %user_name%',0,14,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(58,'create_shipment','Created shipment for order',0,14,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(59,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,14,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(60,'create_order_from_seeder','Order is created from the checkout page',NULL,15,NULL,'2022-11-05 11:04:42','2022-11-05 11:04:42'),(61,'confirm_order','Order was verified by %user_name%',0,15,NULL,'2022-11-05 11:04:42','2022-11-05 11:04:42'),(62,'create_shipment','Created shipment for order',0,15,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(63,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,15,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(64,'create_order_from_seeder','Order is created from the checkout page',NULL,16,NULL,'2022-11-02 05:04:42','2022-11-02 05:04:42'),(65,'confirm_order','Order was verified by %user_name%',0,16,NULL,'2022-11-02 05:04:42','2022-11-02 05:04:42'),(66,'confirm_payment','Payment was confirmed (amount $1,276.00) by %user_name%',0,16,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(67,'create_shipment','Created shipment for order',0,16,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(68,'create_order_from_seeder','Order is created from the checkout page',NULL,17,NULL,'2022-11-04 21:04:42','2022-11-04 21:04:42'),(69,'confirm_order','Order was verified by %user_name%',0,17,NULL,'2022-11-04 21:04:42','2022-11-04 21:04:42'),(70,'create_shipment','Created shipment for order',0,17,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(71,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,17,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(72,'create_order_from_seeder','Order is created from the checkout page',NULL,18,NULL,'2022-10-31 21:04:42','2022-10-31 21:04:42'),(73,'confirm_order','Order was verified by %user_name%',0,18,NULL,'2022-10-31 21:04:42','2022-10-31 21:04:42'),(74,'confirm_payment','Payment was confirmed (amount $2,608.20) by %user_name%',0,18,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(75,'create_shipment','Created shipment for order',0,18,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(76,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,18,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(77,'create_order_from_seeder','Order is created from the checkout page',NULL,19,NULL,'2022-11-07 05:04:42','2022-11-07 05:04:42'),(78,'confirm_order','Order was verified by %user_name%',0,19,NULL,'2022-11-07 05:04:42','2022-11-07 05:04:42'),(79,'confirm_payment','Payment was confirmed (amount $1,313.40) by %user_name%',0,19,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(80,'create_shipment','Created shipment for order',0,19,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(81,'create_order_from_seeder','Order is created from the checkout page',NULL,20,NULL,'2022-11-04 11:04:42','2022-11-04 11:04:42'),(82,'confirm_order','Order was verified by %user_name%',0,20,NULL,'2022-11-04 11:04:42','2022-11-04 11:04:42'),(83,'confirm_payment','Payment was confirmed (amount $608.30) by %user_name%',0,20,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(84,'create_shipment','Created shipment for order',0,20,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(85,'create_order_from_seeder','Order is created from the checkout page',NULL,21,NULL,'2022-11-03 09:04:42','2022-11-03 09:04:42'),(86,'confirm_order','Order was verified by %user_name%',0,21,NULL,'2022-11-03 09:04:42','2022-11-03 09:04:42'),(87,'create_shipment','Created shipment for order',0,21,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(88,'create_order_from_seeder','Order is created from the checkout page',NULL,22,NULL,'2022-11-03 09:04:42','2022-11-03 09:04:42'),(89,'confirm_order','Order was verified by %user_name%',0,22,NULL,'2022-11-03 09:04:42','2022-11-03 09:04:42'),(90,'confirm_payment','Payment was confirmed (amount $2,374.60) by %user_name%',0,22,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(91,'create_shipment','Created shipment for order',0,22,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(92,'create_order_from_seeder','Order is created from the checkout page',NULL,23,NULL,'2022-11-10 03:04:42','2022-11-10 03:04:42'),(93,'confirm_order','Order was verified by %user_name%',0,23,NULL,'2022-11-10 03:04:42','2022-11-10 03:04:42'),(94,'confirm_payment','Payment was confirmed (amount $1,733.90) by %user_name%',0,23,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(95,'create_shipment','Created shipment for order',0,23,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(96,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,23,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(97,'create_order_from_seeder','Order is created from the checkout page',NULL,24,NULL,'2022-11-08 15:04:42','2022-11-08 15:04:42'),(98,'confirm_order','Order was verified by %user_name%',0,24,NULL,'2022-11-08 15:04:42','2022-11-08 15:04:42'),(99,'confirm_payment','Payment was confirmed (amount $1,664.70) by %user_name%',0,24,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(100,'create_shipment','Created shipment for order',0,24,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(101,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,24,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(102,'create_order_from_seeder','Order is created from the checkout page',NULL,25,NULL,'2022-11-08 15:04:42','2022-11-08 15:04:42'),(103,'confirm_order','Order was verified by %user_name%',0,25,NULL,'2022-11-08 15:04:42','2022-11-08 15:04:42'),(104,'confirm_payment','Payment was confirmed (amount $1,366.20) by %user_name%',0,25,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(105,'create_shipment','Created shipment for order',0,25,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(106,'create_order_from_seeder','Order is created from the checkout page',NULL,26,NULL,'2022-11-08 05:04:42','2022-11-08 05:04:42'),(107,'confirm_order','Order was verified by %user_name%',0,26,NULL,'2022-11-08 05:04:42','2022-11-08 05:04:42'),(108,'create_shipment','Created shipment for order',0,26,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(109,'create_order_from_seeder','Order is created from the checkout page',NULL,27,NULL,'2022-11-08 21:04:42','2022-11-08 21:04:42'),(110,'confirm_order','Order was verified by %user_name%',0,27,NULL,'2022-11-08 21:04:42','2022-11-08 21:04:42'),(111,'confirm_payment','Payment was confirmed (amount $2,608.20) by %user_name%',0,27,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(112,'create_shipment','Created shipment for order',0,27,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(113,'create_order_from_seeder','Order is created from the checkout page',NULL,28,NULL,'2022-11-05 15:04:42','2022-11-05 15:04:42'),(114,'confirm_order','Order was verified by %user_name%',0,28,NULL,'2022-11-05 15:04:42','2022-11-05 15:04:42'),(115,'confirm_payment','Payment was confirmed (amount $1,215.98) by %user_name%',0,28,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(116,'create_shipment','Created shipment for order',0,28,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(117,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,28,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(118,'create_order_from_seeder','Order is created from the checkout page',NULL,29,NULL,'2022-11-09 17:04:42','2022-11-09 17:04:42'),(119,'confirm_order','Order was verified by %user_name%',0,29,NULL,'2022-11-09 17:04:42','2022-11-09 17:04:42'),(120,'create_shipment','Created shipment for order',0,29,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(121,'create_order_from_seeder','Order is created from the checkout page',NULL,30,NULL,'2022-11-06 05:04:42','2022-11-06 05:04:42'),(122,'confirm_order','Order was verified by %user_name%',0,30,NULL,'2022-11-06 05:04:42','2022-11-06 05:04:42'),(123,'create_shipment','Created shipment for order',0,30,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(124,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,30,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(125,'create_order_from_seeder','Order is created from the checkout page',NULL,31,NULL,'2022-11-08 21:04:42','2022-11-08 21:04:42'),(126,'confirm_order','Order was verified by %user_name%',0,31,NULL,'2022-11-08 21:04:42','2022-11-08 21:04:42'),(127,'create_shipment','Created shipment for order',0,31,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(128,'create_order_from_seeder','Order is created from the checkout page',NULL,32,NULL,'2022-11-09 09:04:42','2022-11-09 09:04:42'),(129,'confirm_order','Order was verified by %user_name%',0,32,NULL,'2022-11-09 09:04:42','2022-11-09 09:04:42'),(130,'confirm_payment','Payment was confirmed (amount $2,437.30) by %user_name%',0,32,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(131,'create_shipment','Created shipment for order',0,32,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(132,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,32,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(133,'create_order_from_seeder','Order is created from the checkout page',NULL,33,NULL,'2022-11-06 17:04:42','2022-11-06 17:04:42'),(134,'confirm_order','Order was verified by %user_name%',0,33,NULL,'2022-11-06 17:04:42','2022-11-06 17:04:42'),(135,'create_shipment','Created shipment for order',0,33,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(136,'create_order_from_seeder','Order is created from the checkout page',NULL,34,NULL,'2022-11-10 11:04:42','2022-11-10 11:04:42'),(137,'confirm_order','Order was verified by %user_name%',0,34,NULL,'2022-11-10 11:04:42','2022-11-10 11:04:42'),(138,'create_shipment','Created shipment for order',0,34,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(139,'create_order_from_seeder','Order is created from the checkout page',NULL,35,NULL,'2022-11-07 21:04:42','2022-11-07 21:04:42'),(140,'confirm_order','Order was verified by %user_name%',0,35,NULL,'2022-11-07 21:04:42','2022-11-07 21:04:42'),(141,'create_shipment','Created shipment for order',0,35,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(142,'create_order_from_seeder','Order is created from the checkout page',NULL,36,NULL,'2022-11-10 05:04:42','2022-11-10 05:04:42'),(143,'confirm_order','Order was verified by %user_name%',0,36,NULL,'2022-11-10 05:04:42','2022-11-10 05:04:42'),(144,'confirm_payment','Payment was confirmed (amount $3,701.40) by %user_name%',0,36,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(145,'create_shipment','Created shipment for order',0,36,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(146,'create_order_from_seeder','Order is created from the checkout page',NULL,37,NULL,'2022-11-09 09:04:42','2022-11-09 09:04:42'),(147,'confirm_order','Order was verified by %user_name%',0,37,NULL,'2022-11-09 09:04:42','2022-11-09 09:04:42'),(148,'confirm_payment','Payment was confirmed (amount $2,070.50) by %user_name%',0,37,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(149,'create_shipment','Created shipment for order',0,37,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(150,'create_order_from_seeder','Order is created from the checkout page',NULL,38,NULL,'2022-11-08 21:04:42','2022-11-08 21:04:42'),(151,'confirm_order','Order was verified by %user_name%',0,38,NULL,'2022-11-08 21:04:42','2022-11-08 21:04:42'),(152,'confirm_payment','Payment was confirmed (amount $3,701.40) by %user_name%',0,38,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(153,'create_shipment','Created shipment for order',0,38,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(154,'create_order_from_seeder','Order is created from the checkout page',NULL,39,NULL,'2022-11-10 13:04:42','2022-11-10 13:04:42'),(155,'confirm_order','Order was verified by %user_name%',0,39,NULL,'2022-11-10 13:04:42','2022-11-10 13:04:42'),(156,'confirm_payment','Payment was confirmed (amount $589.60) by %user_name%',0,39,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(157,'create_shipment','Created shipment for order',0,39,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(158,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,39,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(159,'create_order_from_seeder','Order is created from the checkout page',NULL,40,NULL,'2022-11-10 05:04:42','2022-11-10 05:04:42'),(160,'confirm_order','Order was verified by %user_name%',0,40,NULL,'2022-11-10 05:04:42','2022-11-10 05:04:42'),(161,'confirm_payment','Payment was confirmed (amount $2,507.40) by %user_name%',0,40,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(162,'create_shipment','Created shipment for order',0,40,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(163,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,40,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(164,'create_order_from_seeder','Order is created from the checkout page',NULL,41,NULL,'2022-11-10 17:04:42','2022-11-10 17:04:42'),(165,'confirm_order','Order was verified by %user_name%',0,41,NULL,'2022-11-10 17:04:42','2022-11-10 17:04:42'),(166,'confirm_payment','Payment was confirmed (amount $578.60) by %user_name%',0,41,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(167,'create_shipment','Created shipment for order',0,41,NULL,'2022-11-10 21:04:42','2022-11-10 21:04:42'),(168,'create_order_from_seeder','Order is created from the checkout page',NULL,42,NULL,'2022-11-10 13:04:42','2022-11-10 13:04:42'),(169,'confirm_order','Order was verified by %user_name%',0,42,NULL,'2022-11-10 13:04:42','2022-11-10 13:04:42'),(170,'create_shipment','Created shipment for order',0,42,NULL,'2022-11-10 21:04:43','2022-11-10 21:04:43'),(171,'update_status','Order confirmed by %user_name%',0,1,NULL,'2022-11-10 21:04:43','2022-11-10 21:04:43'),(172,'update_status','Order confirmed by %user_name%',0,3,NULL,'2022-11-10 21:04:43','2022-11-10 21:04:43'),(173,'update_status','Order confirmed by %user_name%',0,5,NULL,'2022-11-10 21:04:43','2022-11-10 21:04:43'),(174,'update_status','Order confirmed by %user_name%',0,6,NULL,'2022-11-10 21:04:43','2022-11-10 21:04:43'),(175,'update_status','Order confirmed by %user_name%',0,10,NULL,'2022-11-10 21:04:43','2022-11-10 21:04:43'),(176,'update_status','Order confirmed by %user_name%',0,14,NULL,'2022-11-10 21:04:43','2022-11-10 21:04:43'),(177,'update_status','Order confirmed by %user_name%',0,18,NULL,'2022-11-10 21:04:43','2022-11-10 21:04:43'),(178,'update_status','Order confirmed by %user_name%',0,23,NULL,'2022-11-10 21:04:43','2022-11-10 21:04:43'),(179,'update_status','Order confirmed by %user_name%',0,24,NULL,'2022-11-10 21:04:43','2022-11-10 21:04:43'),(180,'update_status','Order confirmed by %user_name%',0,28,NULL,'2022-11-10 21:04:44','2022-11-10 21:04:44'),(181,'update_status','Order confirmed by %user_name%',0,32,NULL,'2022-11-10 21:04:44','2022-11-10 21:04:44'),(182,'update_status','Order confirmed by %user_name%',0,39,NULL,'2022-11-10 21:04:44','2022-11-10 21:04:44'),(183,'update_status','Order confirmed by %user_name%',0,40,NULL,'2022-11-10 21:04:44','2022-11-10 21:04:44');

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

CREATE TABLE `ec_order_product` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int unsigned NOT NULL,
  `qty` int NOT NULL,
  `price` decimal(15,2) NOT NULL,
  `tax_amount` decimal(15,2) NOT NULL,
  `options` text COLLATE utf8mb4_unicode_ci,
  `product_options` text COLLATE utf8mb4_unicode_ci COMMENT 'product option data',
  `product_id` int unsigned DEFAULT NULL,
  `product_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` double(8,2) DEFAULT '0.00',
  `restock_quantity` int unsigned DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `product_type` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'physical',
  `times_downloaded` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_order_product` VALUES (1,1,3,548.00,54.80,'[]',NULL,31,'Red & Black Headphone',NULL,2613.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(2,2,2,427.00,42.70,'[]',NULL,37,'Nikon HD camera',NULL,1354.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(3,2,2,956.00,95.60,'[]',NULL,64,'Aveeno Moisturizing Body Shower 450ml',NULL,1504.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(4,3,1,40.50,4.05,'[]',NULL,27,'Smart Watches',NULL,551.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(5,4,2,20.00,2.00,'[]',NULL,29,'Beat Headphone',NULL,1024.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(6,5,3,1253.00,125.30,'[]',NULL,52,'Xbox One Wireless Controller Black Color',NULL,1737.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(7,6,3,766.00,76.60,'[]',NULL,73,'Ciate Palemore Lipstick Bold Red Color',NULL,2169.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(8,7,3,20.00,2.00,'[]',NULL,30,'Beat Headphone',NULL,1536.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(9,8,1,526.00,52.60,'[]',NULL,46,'Samsung Smart Phone (Digital)',NULL,535.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(10,9,1,526.00,52.60,'[]',NULL,46,'Samsung Smart Phone (Digital)',NULL,535.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(11,10,3,1160.00,116.00,'[]',NULL,49,'Herschel Leather Duffle Bag In Brown Color',NULL,1758.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(12,10,2,559.00,55.90,'[]',NULL,54,'EPSION Plaster Printer',NULL,1110.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(13,11,1,427.00,42.70,'[]',NULL,37,'Nikon HD camera',NULL,677.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(14,12,3,1194.00,119.40,'[]',NULL,45,'Smart Televisions',NULL,2361.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(15,13,2,526.00,52.60,'[]',NULL,46,'Samsung Smart Phone (Digital)',NULL,1070.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(16,13,2,535.00,53.50,'[]',NULL,55,'Sound Intone I65 Earphone White Version (Digital)',NULL,1030.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(17,14,2,893.00,89.30,'[]',NULL,68,'MVMTH Classical Leather Watch In Black (Digital)',NULL,1444.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(18,15,3,1194.00,119.40,'[]',NULL,42,'Smart Televisions',NULL,2361.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(19,15,1,893.00,89.30,'[]',NULL,68,'MVMTH Classical Leather Watch In Black (Digital)',NULL,722.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(20,16,1,1160.00,116.00,'[]',NULL,49,'Herschel Leather Duffle Bag In Brown Color',NULL,586.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(21,17,2,859.00,85.90,'[]',NULL,36,'Smart Watch External (Digital)',NULL,1244.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(22,17,1,1160.00,116.00,'[]',NULL,47,'Herschel Leather Duffle Bag In Brown Color',NULL,586.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(23,17,1,400.00,40.00,'[]',NULL,69,'Baxter Care Hair Kit For Bearded Mens',NULL,691.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(24,18,2,1242.00,124.20,'[]',NULL,65,'NYX Beauty Couton Pallete Makeup 12',NULL,1290.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(25,19,1,1194.00,119.40,'[]',NULL,43,'Smart Televisions',NULL,787.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(26,20,1,553.00,55.30,'[]',NULL,59,'Apple MacBook Air Retina 13.3-Inch Laptop',NULL,605.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(27,21,3,584.00,58.40,'[]',NULL,57,'B&O Play Mini Bluetooth Speaker',NULL,2082.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(28,22,3,766.00,76.60,'[]',NULL,73,'Ciate Palemore Lipstick Bold Red Color',NULL,2169.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(29,23,2,536.00,53.60,'[]',NULL,41,'Audio Equipment',NULL,1798.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(30,23,1,553.00,55.30,'[]',NULL,60,'Apple MacBook Air Retina 13.3-Inch Laptop',NULL,605.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(31,24,3,537.00,53.70,'[]',NULL,61,'Apple MacBook Air Retina 12-Inch Laptop',NULL,2037.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(32,25,1,1242.00,124.20,'[]',NULL,66,'NYX Beauty Couton Pallete Makeup 12',NULL,645.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(33,26,1,1253.00,125.30,'[]',NULL,51,'Xbox One Wireless Controller Black Color',NULL,579.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(34,27,2,1242.00,124.20,'[]',NULL,65,'NYX Beauty Couton Pallete Makeup 12',NULL,1290.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(35,28,1,80.25,8.03,'[]',NULL,24,'Dual Camera 20MP (Digital)',NULL,760.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(36,28,2,537.00,53.70,'[]',NULL,62,'Apple MacBook Air Retina 12-Inch Laptop',NULL,1358.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(37,29,3,40.50,4.05,'[]',NULL,27,'Smart Watches',NULL,1653.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(38,30,3,526.00,52.60,'[]',NULL,46,'Samsung Smart Phone (Digital)',NULL,1605.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(39,31,3,40.50,4.05,'[]',NULL,27,'Smart Watches',NULL,1653.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(40,32,1,1160.00,116.00,'[]',NULL,48,'Herschel Leather Duffle Bag In Brown Color',NULL,586.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(41,32,2,553.00,55.30,'[]',NULL,60,'Apple MacBook Air Retina 13.3-Inch Laptop',NULL,1210.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(42,33,1,584.00,58.40,'[]',NULL,58,'B&O Play Mini Bluetooth Speaker',NULL,694.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(43,34,2,1242.00,124.20,'[]',NULL,65,'NYX Beauty Couton Pallete Makeup 12',NULL,1290.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(44,35,2,40.50,4.05,'[]',NULL,27,'Smart Watches',NULL,1102.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(45,36,3,1194.00,119.40,'[]',NULL,45,'Smart Televisions',NULL,2361.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(46,37,1,859.00,85.90,'[]',NULL,35,'Smart Watch External (Digital)',NULL,622.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(47,37,2,536.00,53.60,'[]',NULL,41,'Audio Equipment',NULL,1798.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(48,38,3,1194.00,119.40,'[]',NULL,42,'Smart Televisions',NULL,2361.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(49,39,1,536.00,53.60,'[]',NULL,38,'Audio Equipment',NULL,899.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(50,40,2,1194.00,119.40,'[]',NULL,45,'Smart Televisions',NULL,1574.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(51,41,1,526.00,52.60,'[]',NULL,46,'Samsung Smart Phone (Digital)',NULL,535.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(52,42,3,536.00,53.60,'[]',NULL,41,'Audio Equipment',NULL,2697.00,0,'2022-11-10 21:04:42','2022-11-10 21:04:42','physical',0),(53,42,2,553.00,55.30,'[]',NULL,60,'Apple MacBook Air Retina 13.3-Inch Laptop',NULL,1210.00,0,'2022-11-10 21:04:43','2022-11-10 21:04:43','physical',0);

--
-- Table structure for table `ec_order_referrals`
--

CREATE TABLE `ec_order_referrals` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(39) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `landing_domain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `landing_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `landing_params` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referral` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gclid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fclid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_source` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_campaign` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_medium` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_term` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_content` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referrer_url` text COLLATE utf8mb4_unicode_ci,
  `referrer_domain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_order_referrals_order_id_index` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_order_referrals`
--


--
-- Table structure for table `ec_order_return_items`
--

CREATE TABLE `ec_order_return_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_return_id` int unsigned NOT NULL COMMENT 'Order return id',
  `order_product_id` int unsigned NOT NULL COMMENT 'Order product id',
  `product_id` int unsigned NOT NULL COMMENT 'Product id',
  `product_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` int NOT NULL COMMENT 'Quantity return',
  `price` decimal(15,2) NOT NULL COMMENT 'Price Product',
  `reason` text COLLATE utf8mb4_unicode_ci,
  `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_order_return_items`
--


--
-- Table structure for table `ec_order_returns`
--

CREATE TABLE `ec_order_returns` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_id` int unsigned NOT NULL COMMENT 'Order ID',
  `store_id` int unsigned DEFAULT NULL COMMENT 'Store ID',
  `user_id` int unsigned NOT NULL COMMENT 'Customer ID',
  `reason` text COLLATE utf8mb4_unicode_ci COMMENT 'Reason return order',
  `order_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Order current status',
  `return_status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Return status',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_order_returns_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_order_returns`
--


--
-- Table structure for table `ec_orders`
--

CREATE TABLE `ec_orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int unsigned NOT NULL,
  `shipping_option` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_method` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
  `status` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `amount` decimal(15,2) NOT NULL,
  `tax_amount` decimal(15,2) DEFAULT NULL,
  `shipping_amount` decimal(15,2) DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `coupon_code` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_amount` decimal(15,2) DEFAULT NULL,
  `sub_total` decimal(15,2) NOT NULL,
  `is_confirmed` tinyint(1) NOT NULL DEFAULT '0',
  `discount_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_finished` tinyint(1) DEFAULT '0',
  `completed_at` timestamp NULL DEFAULT NULL,
  `token` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `store_id` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_orders_code_unique` (`code`),
  KEY `ec_orders_user_id_status_created_at_index` (`user_id`,`status`,`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_orders`
--

INSERT INTO `ec_orders` VALUES (1,'#10000001',8,'1','default','completed',1698.80,54.80,0.00,NULL,NULL,0.00,1644.00,1,NULL,1,'2022-11-10 21:04:43','XGBeWCYuhYMYRQZgLPt47hWHeBNQp',1,'2022-10-28 13:04:42','2022-11-10 21:04:43',1),(2,'#10000002',8,'1','default','pending',2904.30,138.30,0.00,NULL,NULL,0.00,2766.00,1,NULL,1,NULL,'Oiu6BVz1JcSFZ3hCDaHqdevy3c9gw',2,'2022-11-04 05:04:42','2022-11-10 21:04:42',2),(3,'#10000003',4,'1','default','completed',44.55,4.05,0.00,NULL,NULL,0.00,40.50,1,NULL,1,'2022-11-10 21:04:43','Vaap103zOt4KJmFj61iImSxanGEEl',3,'2022-10-26 01:04:42','2022-11-10 21:04:43',4),(4,'#10000004',4,'1','default','completed',42.00,2.00,0.00,NULL,NULL,0.00,40.00,1,NULL,1,'2022-11-10 21:04:42','v2t2bN4Kywf4ib9rCSqJONa68O2p2',4,'2022-10-29 05:04:42','2022-11-10 21:04:42',2),(5,'#10000005',4,'1','default','completed',3884.30,125.30,0.00,NULL,NULL,0.00,3759.00,1,NULL,1,'2022-11-10 21:04:43','MYCKRZDYN21UxZRWV7XYPdeVMGhhk',5,'2022-11-09 09:04:42','2022-11-10 21:04:43',5),(6,'#10000006',4,'1','default','completed',2374.60,76.60,0.00,NULL,NULL,0.00,2298.00,1,NULL,1,'2022-11-10 21:04:43','v83RkYGa4G8qlMCsLQEUVgJ28g3zI',6,'2022-11-01 21:04:42','2022-11-10 21:04:43',4),(7,'#10000007',3,'1','default','pending',62.00,2.00,0.00,NULL,NULL,0.00,60.00,1,NULL,1,NULL,'jjL4Ry4fNy9UDsJU4fbKcdP5BosB1',7,'2022-10-30 13:04:42','2022-11-10 21:04:42',2),(8,'#10000008',3,'1','default','pending',578.60,52.60,0.00,NULL,NULL,0.00,526.00,1,NULL,1,NULL,'wFMPbfCRa8O0NsWkT95RogauZJyOU',8,'2022-10-31 23:04:42','2022-11-10 21:04:42',1),(9,'#10000009',4,'1','default','pending',578.60,52.60,0.00,NULL,NULL,0.00,526.00,1,NULL,1,NULL,'OvB74Dy6j4RcH86IocM7URtP87SYP',9,'2022-11-01 13:04:42','2022-11-10 21:04:42',1),(10,'#10000010',4,'1','default','completed',4769.90,171.90,0.00,NULL,NULL,0.00,4598.00,1,NULL,1,'2022-11-10 21:04:43','exUXz4SfUBQMpjBBxX1CjGvhZVxto',10,'2022-11-01 13:04:42','2022-11-10 21:04:43',6),(11,'#10000011',4,'1','default','pending',469.70,42.70,0.00,NULL,NULL,0.00,427.00,1,NULL,1,NULL,'hFfbEjFbnlIWn5djS0WU9kRzTdJBu',11,'2022-11-09 15:04:42','2022-11-10 21:04:42',2),(12,'#10000012',4,'1','default','pending',3701.40,119.40,0.00,NULL,NULL,0.00,3582.00,1,NULL,1,NULL,'GhWOcmUbu1XSjneP2dNhtHEMV7JkO',12,'2022-11-09 15:04:42','2022-11-10 21:04:42',3),(13,'#10000013',1,'1','default','pending',2228.10,106.10,0.00,NULL,NULL,0.00,2122.00,1,NULL,1,NULL,'IFBfuEWbZZRBr20L6QLoUHLPlPgj4',13,'2022-11-02 17:04:42','2022-11-10 21:04:42',1),(14,'#10000014',1,'1','default','completed',1875.30,89.30,0.00,NULL,NULL,0.00,1786.00,1,NULL,1,'2022-11-10 21:04:43','mqRIsZsydv5rtBROwGjJXXl1ltWc9',14,'2022-11-05 01:04:42','2022-11-10 21:04:43',3),(15,'#10000015',8,'1','default','completed',4683.70,208.70,0.00,NULL,NULL,0.00,4475.00,1,NULL,1,'2022-11-10 21:04:42','Ikxh4VUywRztmKai278t320ivsGWj',15,'2022-11-05 11:04:42','2022-11-10 21:04:42',3),(16,'#10000016',8,'1','default','pending',1276.00,116.00,0.00,NULL,NULL,0.00,1160.00,1,NULL,1,NULL,'RFdw4oB2sXdfnaPRVT2txvjqw8ByJ',16,'2022-11-02 05:04:42','2022-11-10 21:04:42',6),(17,'#10000017',1,'1','default','completed',3519.90,241.90,0.00,NULL,NULL,0.00,3278.00,1,NULL,1,'2022-11-10 21:04:42','t3UHija0Tk4ZoQPHNkTSQTIGRXkCE',17,'2022-11-04 21:04:42','2022-11-10 21:04:42',6),(18,'#10000018',1,'1','default','completed',2608.20,124.20,0.00,NULL,NULL,0.00,2484.00,1,NULL,1,'2022-11-10 21:04:43','404aCOLDYXHQuzNvT07ColvlDAkRK',18,'2022-10-31 21:04:42','2022-11-10 21:04:43',1),(19,'#10000019',1,'1','default','pending',1313.40,119.40,0.00,NULL,NULL,0.00,1194.00,1,NULL,1,NULL,'o99xj0RBoYckv5Bqvbng1jnDXdE4v',19,'2022-11-07 05:04:42','2022-11-10 21:04:42',3),(20,'#10000020',1,'1','default','pending',608.30,55.30,0.00,NULL,NULL,0.00,553.00,1,NULL,1,NULL,'uJKec1nR5n4Q7UUXI3C39JMKUJY99',20,'2022-11-04 11:04:42','2022-11-10 21:04:42',6),(21,'#10000021',1,'1','default','pending',1810.40,58.40,0.00,NULL,NULL,0.00,1752.00,1,NULL,1,NULL,'M39Q7gnDB6ivjNwkSwz8yOgueqQiZ',21,'2022-11-03 09:04:42','2022-11-10 21:04:42',3),(22,'#10000022',1,'1','default','pending',2374.60,76.60,0.00,NULL,NULL,0.00,2298.00,1,NULL,1,NULL,'bIZOguifE9F6NCt5gtLbkWBnmBZJg',22,'2022-11-03 09:04:42','2022-11-10 21:04:42',4),(23,'#10000023',4,'1','default','completed',1733.90,108.90,0.00,NULL,NULL,0.00,1625.00,1,NULL,1,'2022-11-10 21:04:43','2qs4RiroDYn6UmuUf5muSscsMTYGK',23,'2022-11-10 03:04:42','2022-11-10 21:04:43',6),(24,'#10000024',4,'1','default','completed',1664.70,53.70,0.00,NULL,NULL,0.00,1611.00,1,NULL,1,'2022-11-10 21:04:43','smqMaEhKJp4peYNq0mJHW8EGqCvDA',24,'2022-11-08 15:04:42','2022-11-10 21:04:43',3),(25,'#10000025',4,'1','default','pending',1366.20,124.20,0.00,NULL,NULL,0.00,1242.00,1,NULL,1,NULL,'I5j1OnwSme1EyoKPg6qzO7jpWd1Wl',25,'2022-11-08 15:04:42','2022-11-10 21:04:42',1),(26,'#10000026',4,'1','default','pending',1378.30,125.30,0.00,NULL,NULL,0.00,1253.00,1,NULL,1,NULL,'oAR5IOjwqFebZRrzR1zrUJjy9HcW8',26,'2022-11-08 05:04:42','2022-11-10 21:04:42',5),(27,'#10000027',4,'1','default','pending',2608.20,124.20,0.00,NULL,NULL,0.00,2484.00,1,NULL,1,NULL,'byia5ksM30RC45GdON0MjKernbPxy',27,'2022-11-08 21:04:42','2022-11-10 21:04:42',1),(28,'#10000028',3,'1','default','completed',1215.98,61.73,0.00,NULL,NULL,0.00,1154.25,1,NULL,1,'2022-11-10 21:04:44','xm1BaIvcEzZyCi9ijSqgR64qEkhJw',28,'2022-11-05 15:04:42','2022-11-10 21:04:44',3),(29,'#10000029',3,'1','default','pending',125.55,4.05,0.00,NULL,NULL,0.00,121.50,1,NULL,1,NULL,'xl9UEhkd3T5K3R67aaKYWTalaqfOq',29,'2022-11-09 17:04:42','2022-11-10 21:04:42',4),(30,'#10000030',3,'1','default','completed',1630.60,52.60,0.00,NULL,NULL,0.00,1578.00,1,NULL,1,'2022-11-10 21:04:42','yzbL5Zz9cfyzoAvEzDJ7lzaFeTmKO',30,'2022-11-06 05:04:42','2022-11-10 21:04:42',1),(31,'#10000031',1,'1','default','pending',125.55,4.05,0.00,NULL,NULL,0.00,121.50,1,NULL,1,NULL,'GQlouAizcaWONuDlTJd9iLwEBIdPc',31,'2022-11-08 21:04:42','2022-11-10 21:04:42',4),(32,'#10000032',1,'1','default','completed',2437.30,171.30,0.00,NULL,NULL,0.00,2266.00,1,NULL,1,'2022-11-10 21:04:44','uW3GPMy1Zv49JKFwIUfBLVPaj9LHZ',32,'2022-11-09 09:04:42','2022-11-10 21:04:44',6),(33,'#10000033',4,'1','default','pending',642.40,58.40,0.00,NULL,NULL,0.00,584.00,1,NULL,1,NULL,'v52a5sgFMPF255d24LTh9PP8cecew',33,'2022-11-06 17:04:42','2022-11-10 21:04:42',3),(34,'#10000034',4,'1','default','pending',2608.20,124.20,0.00,NULL,NULL,0.00,2484.00,1,NULL,1,NULL,'vxOHvZt8rPhetEexSThuMyht59zhp',34,'2022-11-10 11:04:42','2022-11-10 21:04:42',1),(35,'#10000035',3,'1','default','pending',85.05,4.05,0.00,NULL,NULL,0.00,81.00,1,NULL,1,NULL,'JAT0wzTMU2VATqBweiUNS4MmlrMkZ',35,'2022-11-07 21:04:42','2022-11-10 21:04:42',4),(36,'#10000036',3,'1','default','pending',3701.40,119.40,0.00,NULL,NULL,0.00,3582.00,1,NULL,1,NULL,'XqwTCFL132vE2ksuSeG9utptghVj7',36,'2022-11-10 05:04:42','2022-11-10 21:04:42',3),(37,'#10000037',3,'1','default','pending',2070.50,139.50,0.00,NULL,NULL,0.00,1931.00,1,NULL,1,NULL,'KCe4HXECuy0w2o2xrs6nQEzpKjVlZ',37,'2022-11-09 09:04:42','2022-11-10 21:04:42',6),(38,'#10000038',3,'1','default','pending',3701.40,119.40,0.00,NULL,NULL,0.00,3582.00,1,NULL,1,NULL,'4lDa4QM6MlqccpDTNh6FWL4dHn1ss',38,'2022-11-08 21:04:42','2022-11-10 21:04:42',3),(39,'#10000039',1,'1','default','completed',589.60,53.60,0.00,NULL,NULL,0.00,536.00,1,NULL,1,'2022-11-10 21:04:44','qsYwqT7ENlyrdKgJNZ4PHQh2TqKhQ',39,'2022-11-10 13:04:42','2022-11-10 21:04:44',6),(40,'#10000040',1,'1','default','completed',2507.40,119.40,0.00,NULL,NULL,0.00,2388.00,1,NULL,1,'2022-11-10 21:04:44','bc1id1xI6wTwj3OYe1uSvYVzigDav',40,'2022-11-10 05:04:42','2022-11-10 21:04:44',3),(41,'#10000041',1,'1','default','pending',578.60,52.60,0.00,NULL,NULL,0.00,526.00,1,NULL,1,NULL,'Izs1Y9njDGdp4gka3dYQQQ27v8UJM',41,'2022-11-10 17:04:42','2022-11-10 21:04:42',1),(42,'#10000042',1,'1','default','pending',2822.90,108.90,0.00,NULL,NULL,0.00,2714.00,1,NULL,1,NULL,'RVtUn9Sy6s8xPul6tBeoJIEEwoYFQ',42,'2022-11-10 13:04:42','2022-11-10 21:04:43',6);

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

CREATE TABLE `ec_product_attribute_sets` (
  `id` bigint 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 unsigned NOT NULL DEFAULT '1',
  `is_comparable` tinyint unsigned NOT NULL DEFAULT '1',
  `is_use_in_product_listing` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `order` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `use_image_from_product_variation` tinyint unsigned NOT NULL DEFAULT '0',
  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,'2022-11-10 21:04:36','2022-11-10 21:04:36',0),(2,'Size','size','text',1,1,1,'published',1,'2022-11-10 21:04:36','2022-11-10 21:04:36',0);

--
-- Table structure for table `ec_product_attribute_sets_translations`
--

CREATE TABLE `ec_product_attribute_sets_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_attribute_sets_id` int NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_product_attribute_sets_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_attribute_sets_translations`
--

INSERT INTO `ec_product_attribute_sets_translations` VALUES ('vi',1,'Màu sắc'),('vi',2,'Kích thước');

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

CREATE TABLE `ec_product_attributes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `attribute_set_id` int 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 unsigned NOT NULL DEFAULT '0',
  `order` tinyint 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`),
  KEY `ec_product_attributes_attribute_set_id_status_index` (`attribute_set_id`,`status`)
) 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','2022-11-10 21:04:36','2022-11-10 21:04:36'),(2,1,'Blue','blue','#333333',NULL,0,2,'published','2022-11-10 21:04:36','2022-11-10 21:04:36'),(3,1,'Red','red','#DA323F',NULL,0,3,'published','2022-11-10 21:04:36','2022-11-10 21:04:36'),(4,1,'Black','back','#2F366C',NULL,0,4,'published','2022-11-10 21:04:36','2022-11-10 21:04:36'),(5,1,'Brown','brown','#87554B',NULL,0,5,'published','2022-11-10 21:04:36','2022-11-10 21:04:36'),(6,2,'S','s',NULL,NULL,1,1,'published','2022-11-10 21:04:36','2022-11-10 21:04:36'),(7,2,'M','m',NULL,NULL,0,2,'published','2022-11-10 21:04:36','2022-11-10 21:04:36'),(8,2,'L','l',NULL,NULL,0,3,'published','2022-11-10 21:04:36','2022-11-10 21:04:36'),(9,2,'XL','xl',NULL,NULL,0,4,'published','2022-11-10 21:04:36','2022-11-10 21:04:36'),(10,2,'XXL','xxl',NULL,NULL,0,5,'published','2022-11-10 21:04:36','2022-11-10 21:04:36');

--
-- Table structure for table `ec_product_attributes_translations`
--

CREATE TABLE `ec_product_attributes_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_attributes_id` int NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_product_attributes_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_attributes_translations`
--

INSERT INTO `ec_product_attributes_translations` VALUES ('vi',1,'Xanh lá cây'),('vi',2,'Xanh da trời'),('vi',3,'Đỏ'),('vi',4,'Đen'),('vi',5,'Nâu'),('vi',6,'S'),('vi',7,'M'),('vi',8,'L'),('vi',9,'XL'),('vi',10,'XXL');

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

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

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

INSERT INTO `ec_product_categories` VALUES (1,'Hot Promotions',0,NULL,'published',0,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(2,'Electronics',0,NULL,'published',1,'product-categories/1.jpg',1,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(3,'Consumer Electronic',2,NULL,'published',0,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(4,'Home Audio & Theaters',3,NULL,'published',0,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(5,'TV & Videos',3,NULL,'published',1,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(6,'Camera, Photos & Videos',3,NULL,'published',2,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(7,'Cellphones & Accessories',3,NULL,'published',3,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(8,'Headphones',3,NULL,'published',4,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(9,'Videos games',3,NULL,'published',5,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(10,'Wireless Speakers',3,NULL,'published',6,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(11,'Office Electronic',3,NULL,'published',7,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(12,'Accessories & Parts',2,NULL,'published',1,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(13,'Digital Cables',12,NULL,'published',0,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(14,'Audio & Video Cables',12,NULL,'published',1,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(15,'Batteries',12,NULL,'published',2,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(16,'Clothing',0,NULL,'published',2,'product-categories/2.jpg',1,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(17,'Computers',0,NULL,'published',3,'product-categories/3.jpg',1,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(18,'Computer & Technologies',17,NULL,'published',0,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(19,'Computer & Tablets',18,NULL,'published',0,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(20,'Laptop',18,NULL,'published',1,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(21,'Monitors',18,NULL,'published',2,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(22,'Computer Components',18,NULL,'published',3,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(23,'Networking',17,NULL,'published',1,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(24,'Drive & Storages',23,NULL,'published',0,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(25,'Gaming Laptop',23,NULL,'published',1,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(26,'Security & Protection',23,NULL,'published',2,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(27,'Accessories',23,NULL,'published',3,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(28,'Home & Kitchen',0,NULL,'published',4,'product-categories/4.jpg',1,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(29,'Health & Beauty',0,NULL,'published',5,'product-categories/5.jpg',1,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(30,'Jewelry & Watch',0,NULL,'published',6,'product-categories/6.jpg',1,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(31,'Technology Toys',0,NULL,'published',7,'product-categories/7.jpg',1,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(32,'Phones',0,NULL,'published',8,'product-categories/8.jpg',1,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(33,'Babies & Moms',0,NULL,'published',9,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(34,'Sport & Outdoor',0,NULL,'published',10,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(35,'Books & Office',0,NULL,'published',11,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(36,'Cars & Motorcycles',0,NULL,'published',12,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31'),(37,'Home Improvements',0,NULL,'published',13,NULL,0,'2022-11-10 21:04:31','2022-11-10 21:04:31');

--
-- Table structure for table `ec_product_categories_translations`
--

CREATE TABLE `ec_product_categories_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_categories_id` int NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`ec_product_categories_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_categories_translations`
--

INSERT INTO `ec_product_categories_translations` VALUES ('vi',1,'Khuyến mãi hấp dẫn',NULL),('vi',2,'Điện tử',NULL),('vi',3,'Điện tử tiêu dùng',NULL),('vi',4,'Thiết bị nghe nhìn',NULL),('vi',5,'TV & Videos',NULL),('vi',6,'Camera, Photos & Videos',NULL),('vi',7,'Điện thoại di động & Phụ kiện',NULL),('vi',8,'Tai nghe',NULL),('vi',9,'Trò chơi video',NULL),('vi',10,'Loa không dây',NULL),('vi',11,'Điện tử văn phòng',NULL),('vi',12,'Phụ kiện & Phụ tùng',NULL),('vi',13,'Digital Cables',NULL),('vi',14,'Audio & Video Cables',NULL),('vi',15,'Pin',NULL),('vi',16,'Quần áo',NULL),('vi',17,'Máy tính',NULL),('vi',18,'Máy tính & Công nghệ',NULL),('vi',19,'Máy tính & Máy tính bảng',NULL),('vi',20,'Máy tính xách tay',NULL),('vi',21,'Màn hình',NULL),('vi',22,'Linh kiện Máy tính',NULL),('vi',23,'Mạng máy tính',NULL),('vi',24,'Thiết bị lưu trữ',NULL),('vi',25,'Máy tính xách tay chơi game',NULL),('vi',26,'Thiết bị bảo mật',NULL),('vi',27,'Phụ kiện',NULL),('vi',28,'Đồ dùng làm bếp',NULL),('vi',29,'Sức khỏe & làm đẹp',NULL),('vi',30,'Trang sức & Đồng hồ',NULL),('vi',31,'Đồ chơi công nghệ',NULL),('vi',32,'Điện thoại',NULL),('vi',33,'Mẹ và bé',NULL),('vi',34,'Thể thao & ngoài trời',NULL),('vi',35,'Sách & Văn phòng',NULL),('vi',36,'Ô tô & Xe máy',NULL),('vi',37,'Cải tiến nhà cửa',NULL);

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

CREATE TABLE `ec_product_category_product` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int unsigned NOT NULL,
  `product_id` int 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=91 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

CREATE TABLE `ec_product_collection_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_collection_id` int unsigned NOT NULL,
  `product_id` int 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=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

CREATE TABLE `ec_product_collections` (
  `id` bigint 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 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','2022-11-10 21:04:31','2022-11-10 21:04:31',0),(2,'Best Sellers','best-sellers',NULL,NULL,'published','2022-11-10 21:04:31','2022-11-10 21:04:31',0),(3,'Special Offer','special-offer',NULL,NULL,'published','2022-11-10 21:04:31','2022-11-10 21:04:31',0);

--
-- Table structure for table `ec_product_collections_translations`
--

CREATE TABLE `ec_product_collections_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_collections_id` int NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_product_collections_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_collections_translations`
--

INSERT INTO `ec_product_collections_translations` VALUES ('vi',1,'Hàng mới về',NULL),('vi',2,'Bán chạy nhất',NULL),('vi',3,'Khuyến mãi đặc biệt',NULL);

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

CREATE TABLE `ec_product_cross_sale_relations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `from_product_id` int unsigned NOT NULL,
  `to_product_id` int 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=136 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--
-- Table structure for table `ec_product_files`
--

CREATE TABLE `ec_product_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int DEFAULT NULL,
  `url` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `extras` mediumtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_product_files_product_id_index` (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_files`
--

INSERT INTO `ec_product_files` VALUES (1,24,'product-files/1.jpg','{\"filename\":\"1.jpg\",\"url\":\"product-files\\/1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"1\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(2,25,'product-files/1.jpg','{\"filename\":\"1.jpg\",\"url\":\"product-files\\/1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"1\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(3,35,'product-files/5.jpg','{\"filename\":\"5.jpg\",\"url\":\"product-files\\/5.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"5\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(4,35,'product-files/5-1.jpg','{\"filename\":\"5-1.jpg\",\"url\":\"product-files\\/5-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"5-1\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(5,35,'product-files/5-2.jpg','{\"filename\":\"5-2.jpg\",\"url\":\"product-files\\/5-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"5-2\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(6,35,'product-files/5-3.jpg','{\"filename\":\"5-3.jpg\",\"url\":\"product-files\\/5-3.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"5-3\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(7,36,'product-files/5.jpg','{\"filename\":\"5.jpg\",\"url\":\"product-files\\/5.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"5\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(8,36,'product-files/5-1.jpg','{\"filename\":\"5-1.jpg\",\"url\":\"product-files\\/5-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"5-1\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(9,36,'product-files/5-2.jpg','{\"filename\":\"5-2.jpg\",\"url\":\"product-files\\/5-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"5-2\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(10,36,'product-files/5-3.jpg','{\"filename\":\"5-3.jpg\",\"url\":\"product-files\\/5-3.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"5-3\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(11,46,'product-files/9.jpg','{\"filename\":\"9.jpg\",\"url\":\"product-files\\/9.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"9\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(12,46,'product-files/9-1.jpg','{\"filename\":\"9-1.jpg\",\"url\":\"product-files\\/9-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"9-1\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(13,46,'product-files/9-2.jpg','{\"filename\":\"9-2.jpg\",\"url\":\"product-files\\/9-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"9-2\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(14,55,'product-files/13.jpg','{\"filename\":\"13.jpg\",\"url\":\"product-files\\/13.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"13\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(15,55,'product-files/13-1.jpg','{\"filename\":\"13-1.jpg\",\"url\":\"product-files\\/13-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"13-1\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(16,56,'product-files/13.jpg','{\"filename\":\"13.jpg\",\"url\":\"product-files\\/13.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"13\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(17,56,'product-files/13-1.jpg','{\"filename\":\"13-1.jpg\",\"url\":\"product-files\\/13-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"13-1\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(18,63,'product-files/17.jpg','{\"filename\":\"17.jpg\",\"url\":\"product-files\\/17.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"17\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(19,63,'product-files/17-1.jpg','{\"filename\":\"17-1.jpg\",\"url\":\"product-files\\/17-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"17-1\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(20,63,'product-files/17-2.jpg','{\"filename\":\"17-2.jpg\",\"url\":\"product-files\\/17-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"17-2\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(21,63,'product-files/17-3.jpg','{\"filename\":\"17-3.jpg\",\"url\":\"product-files\\/17-3.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"17-3\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(22,68,'product-files/21.jpg','{\"filename\":\"21.jpg\",\"url\":\"product-files\\/21.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"21\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(23,68,'product-files/21-1.jpg','{\"filename\":\"21-1.jpg\",\"url\":\"product-files\\/21-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"21-1\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36'),(24,68,'product-files/21-2.jpg','{\"filename\":\"21-2.jpg\",\"url\":\"product-files\\/21-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":2165,\"modified\":\"2022-11-11 04:04:36\",\"name\":\"21-2\",\"extension\":\"jpg\"}','2022-11-10 21:04:36','2022-11-10 21:04:36');

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

CREATE TABLE `ec_product_label_products` (
  `product_label_id` int unsigned NOT NULL,
  `product_id` int 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,9),(2,6),(2,18),(3,3),(3,12),(3,15),(3,21);

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

CREATE TABLE `ec_product_labels` (
  `id` bigint 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','2022-11-10 21:04:31','2022-11-10 21:04:31'),(2,'New','#00c9a7','published','2022-11-10 21:04:31','2022-11-10 21:04:31'),(3,'Sale','#fe9931','published','2022-11-10 21:04:31','2022-11-10 21:04:31');

--
-- Table structure for table `ec_product_labels_translations`
--

CREATE TABLE `ec_product_labels_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_labels_id` int NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_product_labels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_labels_translations`
--

INSERT INTO `ec_product_labels_translations` VALUES ('vi',1,'Nổi bật',NULL),('vi',2,'Mới',NULL),('vi',3,'Giảm giá',NULL);

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

CREATE TABLE `ec_product_related_relations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `from_product_id` int unsigned NOT NULL,
  `to_product_id` int 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 unsigned NOT NULL,
  `tag_id` int 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,1),(1,3),(1,6),(2,3),(2,4),(2,5),(3,2),(3,3),(4,3),(4,4),(5,2),(5,5),(5,6),(6,4),(6,6),(7,3),(7,4),(7,6),(8,1),(8,3),(9,2),(9,3),(9,6),(10,3),(10,6),(11,2),(11,4),(11,6),(12,1),(12,3),(13,4),(13,5),(14,2),(14,3),(14,6),(15,3),(15,4),(15,6),(16,1),(16,6),(17,2),(17,3),(17,5),(18,3),(18,5),(18,6),(19,1),(19,4),(19,5),(20,2),(20,3),(21,3),(21,4),(21,6),(22,2),(22,5),(22,6),(23,3),(23,6);

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

CREATE TABLE `ec_product_tags` (
  `id` bigint 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','2022-11-10 21:04:37','2022-11-10 21:04:37'),(2,'Mobile',NULL,'published','2022-11-10 21:04:37','2022-11-10 21:04:37'),(3,'Iphone',NULL,'published','2022-11-10 21:04:37','2022-11-10 21:04:37'),(4,'Printer',NULL,'published','2022-11-10 21:04:37','2022-11-10 21:04:37'),(5,'Office',NULL,'published','2022-11-10 21:04:37','2022-11-10 21:04:37'),(6,'IT',NULL,'published','2022-11-10 21:04:37','2022-11-10 21:04:37');

--
-- Table structure for table `ec_product_tags_translations`
--

CREATE TABLE `ec_product_tags_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_tags_id` int NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_product_tags_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_tags_translations`
--

INSERT INTO `ec_product_tags_translations` VALUES ('vi',1,'Electronic'),('vi',2,'Mobile'),('vi',3,'Iphone'),('vi',4,'Printer'),('vi',5,'Office'),('vi',6,'IT');

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

CREATE TABLE `ec_product_up_sale_relations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `from_product_id` int unsigned NOT NULL,
  `to_product_id` int 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 unsigned NOT NULL AUTO_INCREMENT,
  `attribute_id` int unsigned NOT NULL,
  `variation_id` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_product_variation_items_attribute_id_variation_id_index` (`attribute_id`,`variation_id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

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

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

CREATE TABLE `ec_product_with_attribute_set` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `attribute_set_id` int unsigned NOT NULL,
  `product_id` int unsigned NOT NULL,
  `order` tinyint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 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);

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

CREATE TABLE `ec_products` (
  `id` bigint 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 unsigned NOT NULL DEFAULT '0',
  `quantity` int unsigned DEFAULT NULL,
  `allow_checkout_when_out_of_stock` tinyint unsigned NOT NULL DEFAULT '0',
  `with_storehouse_management` tinyint unsigned NOT NULL DEFAULT '0',
  `is_featured` tinyint unsigned NOT NULL DEFAULT '0',
  `brand_id` int unsigned DEFAULT NULL,
  `is_variation` tinyint NOT NULL DEFAULT '0',
  `sale_type` tinyint 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,
  `tax_id` int unsigned DEFAULT NULL,
  `views` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `stock_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'in_stock',
  `created_by_id` int DEFAULT '0',
  `created_by_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_type` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT 'physical',
  `store_id` int unsigned DEFAULT NULL,
  `approved_by` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `ec_products_brand_id_status_is_variation_created_at_index` (`brand_id`,`status`,`is_variation`,`created_at`),
  KEY `ec_products_sale_type_index` (`sale_type`),
  KEY `ec_products_start_date_index` (`start_date`),
  KEY `ec_products_end_date_index` (`end_date`),
  KEY `ec_products_sale_price_index` (`sale_price`),
  KEY `ec_products_is_variation_index` (`is_variation`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_products` VALUES (1,'Dual Camera 20MP (Digital)','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\"]','SW-185-A0',0,16,0,1,1,6,0,0,80.25,NULL,NULL,NULL,11.00,18.00,10.00,760.00,1,70686,'2022-11-10 21:04:35','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',3,0),(2,'Smart Watches','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\"]','SW-159-A0',0,19,0,1,1,2,0,0,40.5,NULL,NULL,NULL,15.00,15.00,16.00,551.00,1,165514,'2022-11-10 21:04:35','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',4,0),(3,'Beat Headphone','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\"]','SW-127-A0',0,11,0,1,1,1,0,0,20,NULL,NULL,NULL,16.00,12.00,13.00,512.00,1,112930,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',2,0),(4,'Red & Black Headphone','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\"]','SW-100-A0',0,19,0,1,1,2,0,0,548,389.08,NULL,NULL,13.00,17.00,18.00,871.00,1,41987,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',1,0),(5,'Smart Watch External (Digital)','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\"]','SW-107-A0',0,12,0,1,1,2,0,0,859,NULL,NULL,NULL,16.00,14.00,20.00,622.00,1,37167,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',6,0),(6,'Nikon HD camera','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\"]','SW-126-A0',0,10,0,1,1,5,0,0,427,NULL,NULL,NULL,15.00,19.00,15.00,677.00,1,53984,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',2,0),(7,'Audio Equipment','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\"]','SW-143-A0',0,12,0,1,1,4,0,0,536,NULL,NULL,NULL,14.00,15.00,11.00,899.00,1,77354,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',6,0),(8,'Smart Televisions','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\",\"products\\/8-2.jpg\",\"products\\/8-3.jpg\"]','SW-116-A0',0,12,0,1,1,4,0,0,1194,895.5,NULL,NULL,17.00,12.00,18.00,787.00,1,102792,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',3,0),(9,'Samsung Smart Phone (Digital)','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\",\"products\\/9-2.jpg\"]','SW-129-A0',0,16,0,1,1,4,0,0,526,NULL,NULL,NULL,16.00,10.00,13.00,535.00,1,70774,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',1,0),(10,'Herschel Leather Duffle Bag In Brown Color','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\",\"products\\/10-2.jpg\"]','SW-139-A0',0,14,0,1,0,6,0,0,1160,NULL,NULL,NULL,11.00,14.00,19.00,586.00,1,78824,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',6,0),(11,'Xbox One Wireless Controller Black Color','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\",\"products\\/11-2.jpg\",\"products\\/11-3.jpg\"]','SW-192-A0',0,17,0,1,0,6,0,0,1253,NULL,NULL,NULL,10.00,17.00,10.00,579.00,1,178912,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',5,0),(12,'EPSION Plaster Printer','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\",\"products\\/12-2.jpg\",\"products\\/12-3.jpg\"]','SW-197-A0',0,14,0,1,0,3,0,0,559,441.61,NULL,NULL,19.00,20.00,19.00,555.00,1,23101,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',6,0),(13,'Sound Intone I65 Earphone White Version (Digital)','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\"]','SW-130-A0',0,13,0,1,0,4,0,0,535,NULL,NULL,NULL,17.00,15.00,18.00,515.00,1,43707,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',1,0),(14,'B&O Play Mini Bluetooth Speaker','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\"]','SW-165-A0',0,17,0,1,0,3,0,0,584,NULL,NULL,NULL,19.00,16.00,17.00,694.00,1,150079,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',3,0),(15,'Apple MacBook Air Retina 13.3-Inch Laptop','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\"]','SW-175-A0',0,19,0,1,0,6,0,0,553,NULL,NULL,NULL,16.00,19.00,20.00,605.00,1,162807,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',6,0),(16,'Apple MacBook Air Retina 12-Inch Laptop','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\"]','SW-184-A0',0,17,0,1,0,6,0,0,537,418.86,NULL,NULL,20.00,16.00,19.00,679.00,1,45017,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',3,0),(17,'Samsung Gear VR Virtual Reality Headset (Digital)','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\",\"products\\/17-1.jpg\",\"products\\/17-2.jpg\",\"products\\/17-3.jpg\"]','SW-107-A0',0,19,0,1,0,2,0,0,557,NULL,NULL,NULL,10.00,15.00,20.00,872.00,1,67657,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',4,0),(18,'Aveeno Moisturizing Body Shower 450ml','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\",\"products\\/18-3.jpg\"]','SW-127-A0',0,20,0,1,0,6,0,0,956,NULL,NULL,NULL,17.00,18.00,10.00,752.00,1,38679,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',2,0),(19,'NYX Beauty Couton Pallete Makeup 12','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\",\"products\\/19-2.jpg\",\"products\\/19-3.jpg\"]','SW-144-A0',0,10,0,1,0,4,0,0,1242,NULL,NULL,NULL,19.00,12.00,20.00,645.00,1,124560,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',1,0),(20,'NYX Beauty Couton Pallete Makeup 12','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\",\"products\\/20-2.jpg\",\"products\\/20-3.jpg\"]','SW-196-A0',0,19,0,1,0,5,0,0,903,713.37,NULL,NULL,13.00,13.00,13.00,527.00,1,163378,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',1,0),(21,'MVMTH Classical Leather Watch In Black (Digital)','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\",\"products\\/21-2.jpg\"]','SW-142-A0',0,17,0,1,0,5,0,0,893,NULL,NULL,NULL,10.00,16.00,20.00,722.00,1,136022,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',3,0),(22,'Baxter Care Hair Kit For Bearded Mens','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\",\"products\\/22-2.jpg\",\"products\\/22-3.jpg\"]','SW-147-A0',0,10,0,1,0,5,0,0,400,NULL,NULL,NULL,18.00,14.00,18.00,691.00,1,60853,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',6,0),(23,'Ciate Palemore Lipstick Bold Red Color','<ul><li> Unrestrained and portable active stereo speaker</li>\n            <li> Free from the confines of wires and chords</li>\n            <li> 20 hours of portable capabilities</li>\n            <li> Double-ended Coil Cord with 3.5mm Stereo Plugs Included</li>\n            <li> 3/4″ Dome Tweeters: 2X and 4″ Woofer: 1X</li></ul>','<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\",\"products\\/23-2.jpg\",\"products\\/23-3.jpg\"]','SW-176-A0',0,20,0,1,0,4,0,0,766,NULL,NULL,NULL,16.00,16.00,17.00,723.00,1,15237,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',4,0),(24,'Dual Camera 20MP (Digital)',NULL,NULL,'published','[\"products\\/1.jpg\"]','SW-185-A0',0,16,0,1,0,6,1,0,80.25,NULL,NULL,NULL,11.00,18.00,10.00,760.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,0),(25,'Dual Camera 20MP (Digital)',NULL,NULL,'published','[\"products\\/1.jpg\"]','SW-185-A0-A1',0,16,0,1,0,6,1,0,80.25,NULL,NULL,NULL,11.00,18.00,10.00,760.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,0),(26,'Smart Watches',NULL,NULL,'published','[\"products\\/2.jpg\"]','SW-159-A0',0,19,0,1,0,2,1,0,40.5,NULL,NULL,NULL,15.00,15.00,16.00,551.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(27,'Smart Watches',NULL,NULL,'published','[\"products\\/2-1.jpg\"]','SW-159-A0-A1',0,19,0,1,0,2,1,0,40.5,NULL,NULL,NULL,15.00,15.00,16.00,551.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(28,'Smart Watches',NULL,NULL,'published','[\"products\\/2-2.jpg\"]','SW-159-A0-A2',0,19,0,1,0,2,1,0,40.5,NULL,NULL,NULL,15.00,15.00,16.00,551.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(29,'Beat Headphone',NULL,NULL,'published','[\"products\\/3.jpg\"]','SW-127-A0',0,11,0,1,0,1,1,0,20,NULL,NULL,NULL,16.00,12.00,13.00,512.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(30,'Beat Headphone',NULL,NULL,'published','[\"products\\/3.jpg\"]','SW-127-A0-A1',0,11,0,1,0,1,1,0,20,NULL,NULL,NULL,16.00,12.00,13.00,512.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(31,'Red & Black Headphone',NULL,NULL,'published','[\"products\\/4.jpg\"]','SW-100-A0',0,19,0,1,0,2,1,0,548,389.08,NULL,NULL,13.00,17.00,18.00,871.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(32,'Red & Black Headphone',NULL,NULL,'published','[\"products\\/4-1.jpg\"]','SW-100-A0-A1',0,19,0,1,0,2,1,0,548,460.32,NULL,NULL,13.00,17.00,18.00,871.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(33,'Red & Black Headphone',NULL,NULL,'published','[\"products\\/4-2.jpg\"]','SW-100-A0-A2',0,19,0,1,0,2,1,0,548,482.24,NULL,NULL,13.00,17.00,18.00,871.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(34,'Red & Black Headphone',NULL,NULL,'published','[\"products\\/4-3.jpg\"]','SW-100-A0-A3',0,19,0,1,0,2,1,0,548,465.8,NULL,NULL,13.00,17.00,18.00,871.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(35,'Smart Watch External (Digital)',NULL,NULL,'published','[\"products\\/5.jpg\"]','SW-107-A0',0,12,0,1,0,2,1,0,859,NULL,NULL,NULL,16.00,14.00,20.00,622.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,0),(36,'Smart Watch External (Digital)',NULL,NULL,'published','[\"products\\/5-1.jpg\"]','SW-107-A0-A1',0,12,0,1,0,2,1,0,859,NULL,NULL,NULL,16.00,14.00,20.00,622.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,0),(37,'Nikon HD camera',NULL,NULL,'published','[\"products\\/6.jpg\"]','SW-126-A0',0,10,0,1,0,5,1,0,427,NULL,NULL,NULL,15.00,19.00,15.00,677.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(38,'Audio Equipment',NULL,NULL,'published','[\"products\\/7.jpg\"]','SW-143-A0',0,12,0,1,0,4,1,0,536,NULL,NULL,NULL,14.00,15.00,11.00,899.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(39,'Audio Equipment',NULL,NULL,'published','[\"products\\/7.jpg\"]','SW-143-A0-A1',0,12,0,1,0,4,1,0,536,NULL,NULL,NULL,14.00,15.00,11.00,899.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(40,'Audio Equipment',NULL,NULL,'published','[\"products\\/7.jpg\"]','SW-143-A0-A2',0,12,0,1,0,4,1,0,536,NULL,NULL,NULL,14.00,15.00,11.00,899.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(41,'Audio Equipment',NULL,NULL,'published','[\"products\\/7.jpg\"]','SW-143-A0-A3',0,12,0,1,0,4,1,0,536,NULL,NULL,NULL,14.00,15.00,11.00,899.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(42,'Smart Televisions',NULL,NULL,'published','[\"products\\/8.jpg\"]','SW-116-A0',0,12,0,1,0,4,1,0,1194,895.5,NULL,NULL,17.00,12.00,18.00,787.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(43,'Smart Televisions',NULL,NULL,'published','[\"products\\/8-1.jpg\"]','SW-116-A0-A1',0,12,0,1,0,4,1,0,1194,943.26,NULL,NULL,17.00,12.00,18.00,787.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(44,'Smart Televisions',NULL,NULL,'published','[\"products\\/8-2.jpg\"]','SW-116-A0-A2',0,12,0,1,0,4,1,0,1194,883.56,NULL,NULL,17.00,12.00,18.00,787.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(45,'Smart Televisions',NULL,NULL,'published','[\"products\\/8-3.jpg\"]','SW-116-A0-A3',0,12,0,1,0,4,1,0,1194,871.62,NULL,NULL,17.00,12.00,18.00,787.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(46,'Samsung Smart Phone (Digital)',NULL,NULL,'published','[\"products\\/9.jpg\"]','SW-129-A0',0,16,0,1,0,4,1,0,526,NULL,NULL,NULL,16.00,10.00,13.00,535.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,0),(47,'Herschel Leather Duffle Bag In Brown Color',NULL,NULL,'published','[\"products\\/10.jpg\"]','SW-139-A0',0,14,0,1,0,6,1,0,1160,NULL,NULL,NULL,11.00,14.00,19.00,586.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(48,'Herschel Leather Duffle Bag In Brown Color',NULL,NULL,'published','[\"products\\/10-1.jpg\"]','SW-139-A0-A1',0,14,0,1,0,6,1,0,1160,NULL,NULL,NULL,11.00,14.00,19.00,586.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(49,'Herschel Leather Duffle Bag In Brown Color',NULL,NULL,'published','[\"products\\/10-2.jpg\"]','SW-139-A0-A2',0,14,0,1,0,6,1,0,1160,NULL,NULL,NULL,11.00,14.00,19.00,586.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(50,'Herschel Leather Duffle Bag In Brown Color',NULL,NULL,'published','[\"products\\/10.jpg\"]','SW-139-A0-A3',0,14,0,1,0,6,1,0,1160,NULL,NULL,NULL,11.00,14.00,19.00,586.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(51,'Xbox One Wireless Controller Black Color',NULL,NULL,'published','[\"products\\/11.jpg\"]','SW-192-A0',0,17,0,1,0,6,1,0,1253,NULL,NULL,NULL,10.00,17.00,10.00,579.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(52,'Xbox One Wireless Controller Black Color',NULL,NULL,'published','[\"products\\/11-1.jpg\"]','SW-192-A0-A1',0,17,0,1,0,6,1,0,1253,NULL,NULL,NULL,10.00,17.00,10.00,579.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(53,'EPSION Plaster Printer',NULL,NULL,'published','[\"products\\/12.jpg\"]','SW-197-A0',0,14,0,1,0,3,1,0,559,441.61,NULL,NULL,19.00,20.00,19.00,555.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(54,'EPSION Plaster Printer',NULL,NULL,'published','[\"products\\/12-1.jpg\"]','SW-197-A0-A1',0,14,0,1,0,3,1,0,559,503.1,NULL,NULL,19.00,20.00,19.00,555.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(55,'Sound Intone I65 Earphone White Version (Digital)',NULL,NULL,'published','[\"products\\/13.jpg\"]','SW-130-A0',0,13,0,1,0,4,1,0,535,NULL,NULL,NULL,17.00,15.00,18.00,515.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,0),(56,'Sound Intone I65 Earphone White Version (Digital)',NULL,NULL,'published','[\"products\\/13-1.jpg\"]','SW-130-A0-A1',0,13,0,1,0,4,1,0,535,NULL,NULL,NULL,17.00,15.00,18.00,515.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,0),(57,'B&O Play Mini Bluetooth Speaker',NULL,NULL,'published','[\"products\\/14.jpg\"]','SW-165-A0',0,17,0,1,0,3,1,0,584,NULL,NULL,NULL,19.00,16.00,17.00,694.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(58,'B&O Play Mini Bluetooth Speaker',NULL,NULL,'published','[\"products\\/14.jpg\"]','SW-165-A0-A1',0,17,0,1,0,3,1,0,584,NULL,NULL,NULL,19.00,16.00,17.00,694.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(59,'Apple MacBook Air Retina 13.3-Inch Laptop',NULL,NULL,'published','[\"products\\/15.jpg\"]','SW-175-A0',0,19,0,1,0,6,1,0,553,NULL,NULL,NULL,16.00,19.00,20.00,605.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(60,'Apple MacBook Air Retina 13.3-Inch Laptop',NULL,NULL,'published','[\"products\\/15-1.jpg\"]','SW-175-A0-A1',0,19,0,1,0,6,1,0,553,NULL,NULL,NULL,16.00,19.00,20.00,605.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(61,'Apple MacBook Air Retina 12-Inch Laptop',NULL,NULL,'published','[\"products\\/16.jpg\"]','SW-184-A0',0,17,0,1,0,6,1,0,537,418.86,NULL,NULL,20.00,16.00,19.00,679.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(62,'Apple MacBook Air Retina 12-Inch Laptop',NULL,NULL,'published','[\"products\\/16.jpg\"]','SW-184-A0-A1',0,17,0,1,0,6,1,0,537,381.27,NULL,NULL,20.00,16.00,19.00,679.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(63,'Samsung Gear VR Virtual Reality Headset (Digital)',NULL,NULL,'published','[\"products\\/17.jpg\"]','SW-107-A0',0,19,0,1,0,2,1,0,557,NULL,NULL,NULL,10.00,15.00,20.00,872.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,0),(64,'Aveeno Moisturizing Body Shower 450ml',NULL,NULL,'published','[\"products\\/18.jpg\"]','SW-127-A0',0,20,0,1,0,6,1,0,956,NULL,NULL,NULL,17.00,18.00,10.00,752.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(65,'NYX Beauty Couton Pallete Makeup 12',NULL,NULL,'published','[\"products\\/19.jpg\"]','SW-144-A0',0,10,0,1,0,4,1,0,1242,NULL,NULL,NULL,19.00,12.00,20.00,645.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(66,'NYX Beauty Couton Pallete Makeup 12',NULL,NULL,'published','[\"products\\/19-1.jpg\"]','SW-144-A0-A1',0,10,0,1,0,4,1,0,1242,NULL,NULL,NULL,19.00,12.00,20.00,645.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(67,'NYX Beauty Couton Pallete Makeup 12',NULL,NULL,'published','[\"products\\/20.jpg\"]','SW-196-A0',0,19,0,1,0,5,1,0,903,713.37,NULL,NULL,13.00,13.00,13.00,527.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(68,'MVMTH Classical Leather Watch In Black (Digital)',NULL,NULL,'published','[\"products\\/21.jpg\"]','SW-142-A0',0,17,0,1,0,5,1,0,893,NULL,NULL,NULL,10.00,16.00,20.00,722.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,0),(69,'Baxter Care Hair Kit For Bearded Mens',NULL,NULL,'published','[\"products\\/22.jpg\"]','SW-147-A0',0,10,0,1,0,5,1,0,400,NULL,NULL,NULL,18.00,14.00,18.00,691.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(70,'Ciate Palemore Lipstick Bold Red Color',NULL,NULL,'published','[\"products\\/23.jpg\"]','SW-176-A0',0,20,0,1,0,4,1,0,766,NULL,NULL,NULL,16.00,16.00,17.00,723.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(71,'Ciate Palemore Lipstick Bold Red Color',NULL,NULL,'published','[\"products\\/23-1.jpg\"]','SW-176-A0-A1',0,20,0,1,0,4,1,0,766,NULL,NULL,NULL,16.00,16.00,17.00,723.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(72,'Ciate Palemore Lipstick Bold Red Color',NULL,NULL,'published','[\"products\\/23-2.jpg\"]','SW-176-A0-A2',0,20,0,1,0,4,1,0,766,NULL,NULL,NULL,16.00,16.00,17.00,723.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0),(73,'Ciate Palemore Lipstick Bold Red Color',NULL,NULL,'published','[\"products\\/23-3.jpg\"]','SW-176-A0-A3',0,20,0,1,0,4,1,0,766,NULL,NULL,NULL,16.00,16.00,17.00,723.00,NULL,0,'2022-11-10 21:04:36','2022-11-10 21:04:42','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,0);

--
-- Table structure for table `ec_products_translations`
--

CREATE TABLE `ec_products_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_products_id` int NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `content` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`ec_products_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_products_translations`
--

INSERT INTO `ec_products_translations` VALUES ('vi',1,'Dual Camera 20MP',NULL,NULL),('vi',2,'Smart Watches',NULL,NULL),('vi',3,'Beat Headphone',NULL,NULL),('vi',4,'Red & Black Headphone',NULL,NULL),('vi',5,'Smart Watch External',NULL,NULL),('vi',6,'Nikon HD camera',NULL,NULL),('vi',7,'Audio Equipment',NULL,NULL),('vi',8,'Smart Televisions',NULL,NULL),('vi',9,'Samsung Smart Phone',NULL,NULL),('vi',10,'Herschel Leather Duffle Bag In Brown Color',NULL,NULL),('vi',11,'Xbox One Wireless Controller Black Color',NULL,NULL),('vi',12,'EPSION Plaster Printer',NULL,NULL),('vi',13,'Sound Intone I65 Earphone White Version',NULL,NULL),('vi',14,'B&O Play Mini Bluetooth Speaker',NULL,NULL),('vi',15,'Apple MacBook Air Retina 13.3-Inch Laptop',NULL,NULL),('vi',16,'Apple MacBook Air Retina 12-Inch Laptop',NULL,NULL),('vi',17,'Samsung Gear VR Virtual Reality Headset',NULL,NULL),('vi',18,'Aveeno Moisturizing Body Shower 450ml',NULL,NULL),('vi',19,'NYX Beauty Couton Pallete Makeup 12',NULL,NULL),('vi',20,'NYX Beauty Couton Pallete Makeup 12',NULL,NULL),('vi',21,'MVMTH Classical Leather Watch In Black',NULL,NULL),('vi',22,'Baxter Care Hair Kit For Bearded Mens',NULL,NULL),('vi',23,'Ciate Palemore Lipstick Bold Red Color',NULL,NULL),('vi',24,'Dual Camera 20MP',NULL,NULL),('vi',25,'Dual Camera 20MP',NULL,NULL),('vi',26,'Smart Watches',NULL,NULL),('vi',27,'Smart Watches',NULL,NULL),('vi',28,'Smart Watches',NULL,NULL),('vi',29,'Beat Headphone',NULL,NULL),('vi',30,'Beat Headphone',NULL,NULL),('vi',31,'Red & Black Headphone',NULL,NULL),('vi',32,'Red & Black Headphone',NULL,NULL),('vi',33,'Red & Black Headphone',NULL,NULL),('vi',34,'Red & Black Headphone',NULL,NULL),('vi',35,'Smart Watch External',NULL,NULL),('vi',36,'Smart Watch External',NULL,NULL),('vi',37,'Nikon HD camera',NULL,NULL),('vi',38,'Audio Equipment',NULL,NULL),('vi',39,'Audio Equipment',NULL,NULL),('vi',40,'Audio Equipment',NULL,NULL),('vi',41,'Audio Equipment',NULL,NULL),('vi',42,'Smart Televisions',NULL,NULL),('vi',43,'Smart Televisions',NULL,NULL),('vi',44,'Smart Televisions',NULL,NULL),('vi',45,'Smart Televisions',NULL,NULL),('vi',46,'Samsung Smart Phone',NULL,NULL),('vi',47,'Herschel Leather Duffle Bag In Brown Color',NULL,NULL),('vi',48,'Herschel Leather Duffle Bag In Brown Color',NULL,NULL),('vi',49,'Herschel Leather Duffle Bag In Brown Color',NULL,NULL),('vi',50,'Herschel Leather Duffle Bag In Brown Color',NULL,NULL),('vi',51,'Xbox One Wireless Controller Black Color',NULL,NULL),('vi',52,'Xbox One Wireless Controller Black Color',NULL,NULL),('vi',53,'EPSION Plaster Printer',NULL,NULL),('vi',54,'EPSION Plaster Printer',NULL,NULL),('vi',55,'Sound Intone I65 Earphone White Version',NULL,NULL),('vi',56,'Sound Intone I65 Earphone White Version',NULL,NULL),('vi',57,'B&O Play Mini Bluetooth Speaker',NULL,NULL),('vi',58,'B&O Play Mini Bluetooth Speaker',NULL,NULL),('vi',59,'Apple MacBook Air Retina 13.3-Inch Laptop',NULL,NULL),('vi',60,'Apple MacBook Air Retina 13.3-Inch Laptop',NULL,NULL),('vi',61,'Apple MacBook Air Retina 12-Inch Laptop',NULL,NULL),('vi',62,'Apple MacBook Air Retina 12-Inch Laptop',NULL,NULL),('vi',63,'Samsung Gear VR Virtual Reality Headset',NULL,NULL),('vi',64,'Aveeno Moisturizing Body Shower 450ml',NULL,NULL),('vi',65,'NYX Beauty Couton Pallete Makeup 12',NULL,NULL),('vi',66,'NYX Beauty Couton Pallete Makeup 12',NULL,NULL),('vi',67,'NYX Beauty Couton Pallete Makeup 12',NULL,NULL),('vi',68,'MVMTH Classical Leather Watch In Black',NULL,NULL),('vi',69,'Baxter Care Hair Kit For Bearded Mens',NULL,NULL),('vi',70,'Ciate Palemore Lipstick Bold Red Color',NULL,NULL),('vi',71,'Ciate Palemore Lipstick Bold Red Color',NULL,NULL),('vi',72,'Ciate Palemore Lipstick Bold Red Color',NULL,NULL),('vi',73,'Ciate Palemore Lipstick Bold Red Color',NULL,NULL);

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

CREATE TABLE `ec_reviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int unsigned NOT NULL,
  `product_id` int unsigned NOT NULL,
  `star` double(8,2) NOT NULL,
  `comment` text CHARACTER SET utf8mb4 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,
  `images` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `ec_reviews_product_id_customer_id_status_created_at_index` (`product_id`,`customer_id`,`status`,`created_at`),
  KEY `ec_reviews_product_id_customer_id_status_index` (`product_id`,`customer_id`,`status`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_reviews` VALUES (1,7,5,1.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/14.jpg\"]'),(2,5,21,2.00,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\"]'),(3,6,1,5.00,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/6.jpg\"]'),(4,2,5,5.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/6.jpg\",\"products\\/23.jpg\"]'),(5,3,5,2.00,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/6.jpg\"]'),(6,9,23,4.00,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/7.jpg\"]'),(7,8,20,5.00,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/14.jpg\"]'),(8,8,17,1.00,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/18.jpg\"]'),(9,1,16,2.00,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/5.jpg\",\"products\\/14.jpg\"]'),(10,5,2,3.00,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/7.jpg\"]'),(11,3,6,1.00,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/6.jpg\"]'),(12,6,12,4.00,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\"]'),(13,9,17,5.00,'The code is good, in general, if you like it, can you give it 5 stars?','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\"]'),(14,10,2,5.00,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/6.jpg\",\"products\\/14.jpg\"]'),(15,10,17,1.00,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/6.jpg\"]'),(16,4,17,5.00,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\"]'),(17,10,16,3.00,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/14.jpg\"]'),(18,5,23,5.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\"]'),(19,2,7,1.00,'Great E-commerce system. And much more : Wonderful Customer Support.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/5.jpg\",\"products\\/10.jpg\"]'),(20,3,16,4.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/7.jpg\"]'),(21,4,17,1.00,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/7.jpg\"]'),(22,3,2,2.00,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\"]'),(23,5,7,3.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/7.jpg\",\"products\\/8.jpg\"]'),(24,7,20,1.00,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/7.jpg\"]'),(25,4,4,3.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/5.jpg\"]'),(26,4,17,3.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/6.jpg\"]'),(27,9,22,4.00,'Best ecommerce CMS online store!','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/7.jpg\"]'),(28,5,6,5.00,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/5.jpg\"]'),(29,2,21,5.00,'Good app, good backup service and support. Good documentation.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/6.jpg\",\"products\\/11.jpg\"]'),(30,2,22,2.00,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/5.jpg\"]'),(31,8,15,4.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/5.jpg\",\"products\\/12.jpg\"]'),(32,6,13,2.00,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/5.jpg\",\"products\\/13.jpg\"]'),(33,1,13,3.00,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/5.jpg\"]'),(34,4,21,4.00,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/7.jpg\"]'),(35,10,16,1.00,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\"]'),(36,9,13,4.00,'Good app, good backup service and support. Good documentation.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/5.jpg\",\"products\\/18.jpg\"]'),(37,2,23,5.00,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/5.jpg\",\"products\\/17.jpg\"]'),(38,6,8,2.00,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\"]'),(39,4,17,5.00,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/5.jpg\"]'),(40,5,3,5.00,'Clean & perfect source code','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/7.jpg\",\"products\\/21.jpg\"]'),(41,8,22,3.00,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/6.jpg\"]'),(42,8,6,4.00,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/5.jpg\",\"products\\/11.jpg\"]'),(43,5,2,1.00,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/7.jpg\"]'),(44,2,8,2.00,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/7.jpg\"]'),(45,3,2,5.00,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/7.jpg\",\"products\\/13.jpg\"]'),(46,7,21,5.00,'The code is good, in general, if you like it, can you give it 5 stars?','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\"]'),(47,8,23,1.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/6.jpg\",\"products\\/12.jpg\"]'),(48,1,14,1.00,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/21.jpg\"]'),(49,7,8,5.00,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/7.jpg\",\"products\\/17.jpg\"]'),(50,2,7,2.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/7.jpg\"]'),(51,1,19,1.00,'Best ecommerce CMS online store!','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\"]'),(52,6,13,2.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\"]'),(53,3,4,5.00,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/5.jpg\"]'),(54,10,10,4.00,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/7.jpg\"]'),(55,2,14,2.00,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/7.jpg\"]'),(56,6,14,3.00,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\"]'),(57,4,12,2.00,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/8.jpg\"]'),(58,6,12,4.00,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/7.jpg\"]'),(59,4,23,2.00,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/7.jpg\",\"products\\/16.jpg\"]'),(60,6,16,5.00,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/5.jpg\"]'),(61,6,21,3.00,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/7.jpg\"]'),(62,7,6,1.00,'Great E-commerce system. And much more : Wonderful Customer Support.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\"]'),(63,8,15,5.00,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/7.jpg\"]'),(64,5,8,4.00,'Clean & perfect source code','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\"]'),(65,2,2,3.00,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/7.jpg\"]'),(66,9,23,3.00,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/6.jpg\"]'),(67,3,10,3.00,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/17.jpg\"]'),(68,2,13,1.00,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/5.jpg\"]'),(69,4,21,4.00,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/6.jpg\"]'),(70,6,5,2.00,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/7.jpg\",\"products\\/20.jpg\"]'),(71,1,7,4.00,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\"]'),(72,1,7,5.00,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/7.jpg\"]'),(73,8,5,1.00,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/6.jpg\"]'),(74,10,23,1.00,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/15.jpg\"]'),(75,3,18,5.00,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\"]'),(76,7,11,2.00,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/19.jpg\"]'),(77,10,16,4.00,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/14.jpg\"]'),(78,5,16,2.00,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/5.jpg\",\"products\\/22.jpg\"]'),(79,8,22,5.00,'Great E-commerce system. And much more : Wonderful Customer Support.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/5.jpg\"]'),(80,6,7,2.00,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/8.jpg\"]'),(81,5,4,3.00,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\"]'),(82,7,1,4.00,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/5.jpg\"]'),(83,4,7,4.00,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\"]'),(84,4,6,2.00,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/7.jpg\"]'),(85,2,6,5.00,'Clean & perfect source code','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/5.jpg\"]'),(86,7,23,4.00,'Clean & perfect source code','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/7.jpg\"]'),(87,2,13,1.00,'Good app, good backup service and support. Good documentation.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/6.jpg\"]'),(88,2,19,2.00,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\"]'),(89,7,13,4.00,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/5.jpg\",\"products\\/20.jpg\"]'),(90,6,8,5.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/6.jpg\",\"products\\/9.jpg\"]'),(91,5,11,2.00,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/7.jpg\"]'),(92,10,21,1.00,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/6.jpg\"]'),(93,7,13,2.00,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/5.jpg\"]'),(94,10,4,4.00,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/5.jpg\"]'),(95,1,16,3.00,'Good app, good backup service and support. Good documentation.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\",\"products\\/17.jpg\"]'),(96,5,21,1.00,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/1.jpg\",\"products\\/7.jpg\"]'),(97,6,6,2.00,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/5.jpg\",\"products\\/13.jpg\"]'),(98,4,13,4.00,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/4.jpg\",\"products\\/6.jpg\",\"products\\/23.jpg\"]'),(99,10,11,3.00,'Best ecommerce CMS online store!','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/3.jpg\"]'),(100,7,7,1.00,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','2022-11-10 21:04:37','2022-11-10 21:04:37','[\"products\\/2.jpg\",\"products\\/6.jpg\"]');

--
