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


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

CREATE TABLE `activations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint 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,'5SOeYRHqeoeMjyaOjI88GAJH8kdCBaEZ',1,'2024-03-11 00:14:17','2024-03-11 00:14:17','2024-03-11 00:14:17');

--
-- Table structure for table `admin_notifications`
--

CREATE TABLE `admin_notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `permission` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_notifications`
--


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

CREATE TABLE `ads_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ads_id` bigint unsigned 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`
--


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

CREATE TABLE `audit_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `module` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `request` longtext COLLATE utf8mb4_unicode_ci,
  `action` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_user` bigint unsigned NOT NULL,
  `reference_id` bigint 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` bigint 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` bigint unsigned DEFAULT NULL,
  `author_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `icon` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint 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 `categories_parent_id_index` (`parent_id`),
  KEY `categories_status_index` (`status`),
  KEY `categories_created_at_index` (`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,'Et explicabo quasi quia quia saepe. Porro tempore non ut laborum qui. Consequatur vitae blanditiis et amet reprehenderit voluptas dolorum. Fugiat eum labore dignissimos.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2024-03-11 00:14:17','2024-03-11 00:14:17'),(2,'Fashion',0,'Ratione qui non eligendi. Vel tempora voluptatem iusto voluptatibus sequi minus aut. Sed enim qui qui impedit ut dolore at.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-03-11 00:14:17','2024-03-11 00:14:17'),(3,'Electronic',0,'Doloribus similique et asperiores voluptatem est et praesentium omnis. Culpa ut consequatur officiis aperiam aspernatur. Nam nostrum natus optio quo et.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-03-11 00:14:17','2024-03-11 00:14:17'),(4,'Commercial',0,'Magnam ab architecto qui architecto. Dolorem et necessitatibus veniam inventore et quo. Doloribus voluptatem atque quia dolores fugit. Qui aliquid deserunt exercitationem consequatur enim placeat.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-03-11 00:14:17','2024-03-11 00:14:17');

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

CREATE TABLE `categories_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `categories_id` bigint unsigned 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`
--


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

CREATE TABLE `cities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state_id` bigint unsigned DEFAULT NULL,
  `country_id` bigint unsigned DEFAULT NULL,
  `record_id` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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`),
  UNIQUE KEY `cities_slug_unique` (`slug`)
) 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(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cities_id` bigint unsigned NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` 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` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `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,'Jace Considine','ivah.blanda@example.com','303-863-8585','943 Bartoletti Hollow Suite 324\nJacobsville, OH 81381-1245','Ex corporis unde sint voluptatem quia harum.','Quia dolore delectus labore et velit ut. Sed sed officia aut repudiandae animi id voluptatem. Commodi repudiandae et et voluptate quasi. Quasi tenetur animi omnis animi. Hic sunt temporibus nesciunt. Veniam magnam iusto eligendi laboriosam qui aut. Incidunt tenetur est unde vel sunt impedit veniam. Sunt alias deserunt et veritatis. Voluptatem quisquam quia distinctio veniam voluptatum eveniet. Sapiente quaerat et veritatis. Id id cumque minus omnis.','read','2024-03-11 00:14:16','2024-03-11 00:14:16'),(2,'Travon Ondricka DDS','bechtelar.vincenzo@example.org','+14805194500','8349 Leffler Divide Apt. 218\nAndersontown, GA 48649','Sed voluptatem et dolorem consequatur officia.','Quisquam minima nisi sint aspernatur voluptas. Dolorem dolores necessitatibus voluptatem voluptas distinctio et id sint. Amet eaque maxime tenetur aut est. Dolorem officia rerum sit architecto molestias. Voluptatem et magnam sapiente ut aut sequi consequatur eius. Voluptatem error dolores unde dignissimos amet. Tempora ab cupiditate praesentium quod nemo ab.','unread','2024-03-11 00:14:16','2024-03-11 00:14:16'),(3,'Dr. Lucas Block Jr.','tiana42@example.com','(712) 939-7582','1866 Claudia Lakes\nBaumbachhaven, OH 11768','Corporis debitis facilis commodi nostrum et.','Dicta porro atque laboriosam sequi. Eos ducimus magni ipsa sapiente. Et velit illo dolor. Natus ut vitae delectus mollitia dolor ipsam eos ipsam. Quae recusandae vel doloribus illo totam inventore. Expedita voluptas optio molestias doloribus voluptas. Corporis hic autem occaecati rem rerum. Iusto culpa quasi est et eos voluptatibus dolor. Voluptatibus porro tenetur tenetur.','read','2024-03-11 00:14:16','2024-03-11 00:14:16'),(4,'Mortimer Cremin IV','tamia.bednar@example.net','1-760-552-5103','13320 Klocko Landing Apt. 927\nJerodton, TX 92367','Est et quia neque eius eius reiciendis.','Ratione qui perferendis voluptatem aut qui aperiam repellat. Quam quis recusandae quia quis. Vitae illo eum voluptates aliquam sed suscipit in. Sapiente in vero similique qui et. Doloremque necessitatibus magnam quasi sint. Quis ut placeat eum qui. Cupiditate quo enim perspiciatis alias qui voluptates a. Vel neque sequi iste amet sit. Repudiandae qui assumenda eos aliquid at. Laudantium autem omnis error nesciunt. Sunt nulla autem enim sit dolor.','unread','2024-03-11 00:14:16','2024-03-11 00:14:16'),(5,'Prof. Davin Marquardt','alene25@example.org','(351) 713-6322','6773 Haley Greens Apt. 140\nLake Jacques, CT 10083','Qui ab quis tempora inventore dolorem.','Sunt error blanditiis voluptatem voluptas quia quibusdam maiores consequatur. Eum dolor fugiat velit iste nihil fugiat non. Velit adipisci id et ipsa mollitia facere. Voluptatem est est ea natus quos iure. Molestias eum in consequatur aspernatur. Ut eos consequatur omnis voluptas. Sed quas ut corporis ullam dolorem reiciendis. Eum a fugiat esse maxime molestiae voluptates facilis. Non nostrum dolorem placeat sed. Ullam qui in dolor. Et fuga perferendis doloribus optio illum perspiciatis ut.','read','2024-03-11 00:14:16','2024-03-11 00:14:16'),(6,'Jonatan Miller','idurgan@example.net','(304) 303-9863','2395 Cartwright Station\nEricland, IA 67695','Suscipit ducimus placeat ut.','Doloremque excepturi culpa maxime adipisci aut error rerum. Enim libero dolorem est. Consequatur aspernatur dolores est totam incidunt. Ut quia ut ut non. Possimus molestiae quis aspernatur enim. Autem velit voluptates delectus possimus. Neque quia in fugiat. Minus sed optio iste maiores accusantium alias nostrum. Impedit at ea qui incidunt aut iste. Fugit autem asperiores iste odit eligendi voluptatem mollitia. Tenetur alias corrupti voluptatem omnis magni.','read','2024-03-11 00:14:16','2024-03-11 00:14:16'),(7,'Troy Bergstrom','xdietrich@example.org','+1 (806) 408-6430','475 Heller Divide\nNew Francisco, NY 76264-4862','Praesentium explicabo cumque eos quam culpa.','Ipsam non dolores incidunt sunt sed. A quia qui est neque velit est repellat eum. Sit minima iusto dolor vero nihil dolorem. Mollitia repellat aut sit tempore sint aspernatur. Quo occaecati quae numquam et illum expedita exercitationem. Quisquam numquam perferendis iusto suscipit. Dolores eius magnam praesentium quidem qui harum.','unread','2024-03-11 00:14:16','2024-03-11 00:14:16'),(8,'Miss Patience Veum IV','josianne51@example.com','1-240-612-6296','79544 Tyrell Crossing\nConnburgh, MO 19766','Tempora voluptate sapiente qui eum.','Nihil qui cum consequatur provident eos libero. Voluptatem aut rerum recusandae nemo unde voluptatem. Libero et debitis sit sit occaecati error delectus facilis. Amet natus ut vel. Velit voluptatibus perspiciatis ut qui. Sequi ut veniam qui aspernatur a repellendus aspernatur. Reiciendis omnis in in neque ex tempore. Alias deserunt in qui. Corporis maxime repudiandae voluptas dolor omnis autem dicta eveniet. Eligendi ea maiores debitis. Ut quo qui dolor neque sit aut.','unread','2024-03-11 00:14:16','2024-03-11 00:14:16'),(9,'Mireille Dooley','coleman98@example.com','+1-443-323-9485','5448 Brett Points\nAshleighborough, NE 20986-2176','Ut et iure ut iure beatae sapiente commodi sunt.','Iste fugiat vero eos ea id consequatur. Ducimus recusandae dicta accusantium odio. Nihil sint atque et sed laborum et. Deserunt maiores quia qui. Et quia pariatur eligendi nisi ut deserunt nam. Illo animi sit quibusdam. Omnis incidunt quidem enim dignissimos quia qui. Reprehenderit nesciunt laudantium quia ratione. Aut id id qui qui exercitationem. Exercitationem enim numquam similique dolor quia.','read','2024-03-11 00:14:16','2024-03-11 00:14:16'),(10,'Mrs. Cierra Runolfsson','werner.adams@example.org','+14842474313','25693 Jacynthe Field Apt. 240\nLake Tony, NY 38391-7510','Aut minima reprehenderit minima sunt.','Laborum hic placeat nihil. Corrupti molestiae cumque ut cumque. Suscipit velit repellat vero in. Eaque qui fuga consectetur beatae culpa assumenda soluta. Impedit beatae ad velit quis fuga aut. Aut quo et et vero omnis ea nisi. Voluptatem nihil et quasi iusto. Laudantium hic consequuntur officiis quasi. Ex earum deleniti adipisci ea. Voluptates ut magnam fugiat sunt. Ipsum consequuntur voluptatem ullam. Non et officia quaerat voluptas. Ut non quas amet expedita quo corporis qui.','read','2024-03-11 00:14:16','2024-03-11 00:14:16');

--
-- 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) 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(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `countries_id` bigint unsigned 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` bigint unsigned NOT NULL,
  `widget_id` bigint 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(255) 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,'2024-03-11 00:14:06','2024-03-11 00:14:06'),(2,'Hand crafted',NULL,NULL,'brands/2.jpg','published',1,1,'2024-03-11 00:14:06','2024-03-11 00:14:06'),(3,'Mestonix',NULL,NULL,'brands/3.jpg','published',2,1,'2024-03-11 00:14:06','2024-03-11 00:14:06'),(4,'Sunshine',NULL,NULL,'brands/4.jpg','published',3,1,'2024-03-11 00:14:06','2024-03-11 00:14:06'),(5,'Pure',NULL,NULL,'brands/5.jpg','published',4,1,'2024-03-11 00:14:06','2024-03-11 00:14:06'),(6,'Anfold',NULL,NULL,'brands/6.jpg','published',5,1,'2024-03-11 00:14:06','2024-03-11 00:14:06'),(7,'Automotive',NULL,NULL,'brands/7.jpg','published',6,1,'2024-03-11 00:14:06','2024-03-11 00:14:06');

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

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

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


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

CREATE TABLE `ec_cart` (
  `identifier` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `instance` varchar(60) 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(255) 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=5 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,'2024-03-11 00:14:06','2024-03-11 00:14:06'),(2,'EUR','€',0,2,1,0,0.84,'2024-03-11 00:14:06','2024-03-11 00:14:06'),(3,'VND','₫',0,0,2,0,23203,'2024-03-11 00:14:06','2024-03-11 00:14:06'),(4,'NGN','₦',1,2,2,0,895.52,'2024-03-11 00:14:06','2024-03-11 00:14:06');

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

CREATE TABLE `ec_customer_addresses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(20) 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,
  `customer_id` bigint 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,'Dr. Elyse Prohaska','customer@botble.com','+18127482672','SA','Kansas','West Addieville','83639 Hickle Drive Suite 309',1,1,'2024-03-11 00:14:14','2024-03-11 00:14:14','95742'),(2,'Dr. Elyse Prohaska','customer@botble.com','+19492007544','SS','South Dakota','Garthfort','80460 Shanie Port Apt. 722',1,0,'2024-03-11 00:14:14','2024-03-11 00:14:14','19144-3567'),(3,'Sincere Casper','vendor@botble.com','+15678137857','SV','Delaware','Rutherfordhaven','656 Torphy Overpass',2,1,'2024-03-11 00:14:14','2024-03-11 00:14:14','76565-3910'),(4,'Sincere Casper','vendor@botble.com','+13309763320','SV','North Carolina','Rolandochester','41455 Kilback Unions Apt. 015',2,0,'2024-03-11 00:14:14','2024-03-11 00:14:14','30978-8640'),(5,'Isai Osinski','mayert.kiana@example.org','+19038740390','MN','Texas','Heidenreichfurt','293 Quitzon Lights',3,1,'2024-03-11 00:14:14','2024-03-11 00:14:14','48350-4800'),(6,'Corrine Grant','margot.smith@example.net','+17749512938','DZ','Wisconsin','North Garrettfurt','2514 Evert Lane',4,1,'2024-03-11 00:14:15','2024-03-11 00:14:15','17164-1423'),(7,'Mr. Walton Pagac III','quincy.collins@example.net','+13365056070','GU','Delaware','Port Vada','18368 Sandrine Mill',5,1,'2024-03-11 00:14:15','2024-03-11 00:14:15','75805-4230'),(8,'Aylin Effertz','frami.tyreek@example.com','+17628925007','RU','Rhode Island','Montanaborough','7522 Koss Corners',6,1,'2024-03-11 00:14:15','2024-03-11 00:14:15','02353'),(9,'Mr. Nels Legros IV','schulist.ariel@example.com','+12512908614','LS','Utah','Kassulkehaven','260 Brennon Estates Apt. 027',7,1,'2024-03-11 00:14:15','2024-03-11 00:14:15','24166-7166'),(10,'Edwardo Kreiger','bernadette52@example.org','+15809410094','LS','Idaho','West Bessieside','444 Mertz Alley',8,1,'2024-03-11 00:14:16','2024-03-11 00:14:16','03940-7698'),(11,'Dr. Michel Reynolds PhD','cristina.smitham@example.net','+14233056041','CW','Arizona','West Laviniamouth','20837 Parisian Fall',9,1,'2024-03-11 00:14:16','2024-03-11 00:14:16','97666-3788'),(12,'Hertha Schuster','kaylee.mertz@example.com','+12515480623','AI','Alaska','Raefurt','50668 Okey Forge Suite 419',10,1,'2024-03-11 00:14:16','2024-03-11 00:14:16','74038');

--
-- 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` bigint unsigned NOT NULL,
  `product_id` bigint 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_customer_used_coupons`
--

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

--
-- Dumping data for table `ec_customer_used_coupons`
--


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

CREATE TABLE `ec_discount_customers` (
  `discount_id` bigint unsigned NOT NULL,
  `customer_id` bigint 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_categories`
--

CREATE TABLE `ec_discount_product_categories` (
  `discount_id` bigint unsigned NOT NULL,
  `product_category_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`discount_id`,`product_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_discount_product_categories`
--


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

CREATE TABLE `ec_discount_product_collections` (
  `discount_id` bigint unsigned NOT NULL,
  `product_collection_id` bigint 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` bigint unsigned NOT NULL,
  `product_id` bigint 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,
  `apply_via_url` tinyint(1) NOT NULL DEFAULT '0',
  `display_at_checkout` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_id` bigint 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` bigint unsigned NOT NULL,
  `product_id` bigint 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,67.41,14,1),(1,2,12.96,17,5),(1,3,11.8,12,5),(1,4,280.485,12,2),(1,5,379.44,9,2),(1,6,149.48,18,2),(1,7,161.82,14,4),(1,8,631.169,17,2),(1,9,247.48,18,4),(1,10,911.24,18,2);

--
-- 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','2024-04-10 00:00:00','published','2024-03-11 00:14:16','2024-03-11 00:14:16');

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

CREATE TABLE `ec_flash_sales_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_flash_sales_id` bigint unsigned NOT NULL,
  `name` varchar(255) 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`
--


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

CREATE TABLE `ec_global_option_value` (
  `option_id` bigint unsigned NOT NULL COMMENT 'option id',
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_global_option_value` VALUES (1,1,'1 Year',0,9999,0,'2024-03-11 00:14:19','2024-03-11 00:14:19'),(1,2,'2 Year',10,9999,0,'2024-03-11 00:14:19','2024-03-11 00:14:19'),(1,3,'3 Year',20,9999,0,'2024-03-11 00:14:19','2024-03-11 00:14:19'),(2,4,'4GB',0,9999,0,'2024-03-11 00:14:19','2024-03-11 00:14:19'),(2,5,'8GB',10,9999,0,'2024-03-11 00:14:19','2024-03-11 00:14:19'),(2,6,'16GB',20,9999,0,'2024-03-11 00:14:19','2024-03-11 00:14:19'),(3,7,'Core i5',0,9999,0,'2024-03-11 00:14:19','2024-03-11 00:14:19'),(3,8,'Core i7',10,9999,0,'2024-03-11 00:14:19','2024-03-11 00:14:19'),(3,9,'Core i9',20,9999,0,'2024-03-11 00:14:19','2024-03-11 00:14:19'),(4,10,'128GB',0,9999,0,'2024-03-11 00:14:19','2024-03-11 00:14:19'),(4,11,'256GB',10,9999,0,'2024-03-11 00:14:19','2024-03-11 00:14:19'),(4,12,'512GB',20,9999,0,'2024-03-11 00:14:19','2024-03-11 00:14:19');

--
-- Table structure for table `ec_global_option_value_translations`
--

CREATE TABLE `ec_global_option_value_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_global_option_value_id` bigint unsigned NOT NULL,
  `option_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_global_option_value_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_global_option_value_translations`
--


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

CREATE TABLE `ec_global_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of options',
  `option_type` varchar(255) 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,'2024-03-11 00:14:19','2024-03-11 00:14:19'),(2,'RAM','Botble\\Ecommerce\\Option\\OptionType\\RadioButton',1,'2024-03-11 00:14:19','2024-03-11 00:14:19'),(3,'CPU','Botble\\Ecommerce\\Option\\OptionType\\RadioButton',1,'2024-03-11 00:14:19','2024-03-11 00:14:19'),(4,'HDD','Botble\\Ecommerce\\Option\\OptionType\\Dropdown',0,'2024-03-11 00:14:19','2024-03-11 00:14:19');

--
-- Table structure for table `ec_global_options_translations`
--

CREATE TABLE `ec_global_options_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_global_options_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_global_options_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_global_options_translations`
--


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

CREATE TABLE `ec_grouped_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `parent_product_id` bigint unsigned NOT NULL,
  `product_id` bigint 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(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` int unsigned NOT NULL,
  `price` decimal(15,2) NOT NULL DEFAULT '0.00',
  `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 AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_invoice_items` VALUES (1,1,'Botble\\Ecommerce\\Models\\Product',44,'Smart Televisions',NULL,'products/8-1.jpg',2,1171.00,2342.00,0.00,0.00,2342.00,'{\"sku\":\"SW-190-A0-A1\",\"attributes\":\"(Color: Red, Size: XL)\"}','2024-03-11 00:14:21','2024-03-11 00:14:21'),(2,1,'Botble\\Ecommerce\\Models\\Product',58,'Xbox One Wireless Controller Black Color',NULL,'products/11.jpg',1,1149.00,1149.00,0.00,0.00,1149.00,'{\"sku\":\"SW-170-A0-A4\",\"attributes\":\"(Size: L, Color: Brown)\"}','2024-03-11 00:14:21','2024-03-11 00:14:21'),(3,1,'Botble\\Ecommerce\\Models\\Product',82,'Baxter Care Hair Kit For Bearded Mens',NULL,'products/22-1.jpg',3,422.00,1266.00,0.00,0.00,1266.00,'{\"sku\":\"SW-112-A0-A1\",\"attributes\":\"(Color: Black, Size: XXL)\"}','2024-03-11 00:14:21','2024-03-11 00:14:21'),(4,2,'Botble\\Ecommerce\\Models\\Product',52,'Herschel Leather Duffle Bag In Brown Color',NULL,'products/10.jpg',1,1199.00,1199.00,0.00,0.00,1199.00,'{\"sku\":\"SW-147-A0-A3\",\"attributes\":\"(Color: Green, Size: L)\"}','2024-03-11 00:14:22','2024-03-11 00:14:22'),(5,3,'Botble\\Ecommerce\\Models\\Product',33,'Smart Watch External (Digital)',NULL,'products/5-1.jpg',1,744.00,744.00,0.00,0.00,744.00,'{\"sku\":\"SW-181-A0-A1\",\"attributes\":\"(Color: Blue, Size: L)\"}','2024-03-11 00:14:22','2024-03-11 00:14:22'),(6,3,'Botble\\Ecommerce\\Models\\Product',42,'Audio Equipment',NULL,'products/7.jpg',1,522.00,522.00,0.00,0.00,522.00,'{\"sku\":\"SW-163-A0-A4\",\"attributes\":\"(Size: M, Color: Brown)\"}','2024-03-11 00:14:22','2024-03-11 00:14:22'),(7,4,'Botble\\Ecommerce\\Models\\Product',44,'Smart Televisions',NULL,'products/8-1.jpg',3,1171.00,3513.00,0.00,0.00,3513.00,'{\"sku\":\"SW-190-A0-A1\",\"attributes\":\"(Color: Red, Size: XL)\"}','2024-03-11 00:14:22','2024-03-11 00:14:22'),(8,4,'Botble\\Ecommerce\\Models\\Product',58,'Xbox One Wireless Controller Black Color',NULL,'products/11.jpg',2,1149.00,2298.00,0.00,0.00,2298.00,'{\"sku\":\"SW-170-A0-A4\",\"attributes\":\"(Size: L, Color: Brown)\"}','2024-03-11 00:14:22','2024-03-11 00:14:22'),(9,5,'Botble\\Ecommerce\\Models\\Product',45,'Smart Televisions',NULL,'products/8-2.jpg',2,1171.00,2342.00,0.00,0.00,2342.00,'{\"sku\":\"SW-190-A0-A2\",\"attributes\":\"(Size: L, Color: Brown)\"}','2024-03-11 00:14:22','2024-03-11 00:14:22'),(10,5,'Botble\\Ecommerce\\Models\\Product',58,'Xbox One Wireless Controller Black Color',NULL,'products/11.jpg',2,1149.00,2298.00,0.00,0.00,2298.00,'{\"sku\":\"SW-170-A0-A4\",\"attributes\":\"(Size: L, Color: Brown)\"}','2024-03-11 00:14:22','2024-03-11 00:14:22'),(11,5,'Botble\\Ecommerce\\Models\\Product',61,'EPSION Plaster Printer',NULL,'products/12-2.jpg',2,515.00,1030.00,0.00,0.00,1030.00,'{\"sku\":\"SW-199-A0-A2\",\"attributes\":\"(Color: Black, Size: XL)\"}','2024-03-11 00:14:22','2024-03-11 00:14:22'),(12,6,'Botble\\Ecommerce\\Models\\Product',46,'Samsung Smart Phone (Digital)',NULL,'products/9.jpg',3,538.00,1614.00,0.00,0.00,1614.00,'{\"sku\":\"SW-138-A0\",\"attributes\":\"(Color: Red, Size: XXL)\"}','2024-03-11 00:14:22','2024-03-11 00:14:22'),(13,7,'Botble\\Ecommerce\\Models\\Product',29,'Beat Headphone',NULL,'products/3.jpg',2,20.00,40.00,0.00,0.00,40.00,'{\"sku\":\"SW-146-A0-A1\",\"attributes\":\"(Size: L, Color: Black)\"}','2024-03-11 00:14:23','2024-03-11 00:14:23'),(14,8,'Botble\\Ecommerce\\Models\\Product',62,'Sound Intone I65 Earphone White Version (Digital)',NULL,'products/13.jpg',1,504.00,504.00,0.00,0.00,504.00,'{\"sku\":\"SW-156-A0\",\"attributes\":\"(Color: Blue, Size: XL)\"}','2024-03-11 00:14:23','2024-03-11 00:14:23'),(15,8,'Botble\\Ecommerce\\Models\\Product',80,'MVMTH Classical Leather Watch In Black (Digital)',NULL,'products/21-1.jpg',2,758.00,1516.00,0.00,0.00,1516.00,'{\"sku\":\"SW-115-A0-A1\",\"attributes\":\"(Size: L, Color: Brown)\"}','2024-03-11 00:14:23','2024-03-11 00:14:23'),(16,9,'Botble\\Ecommerce\\Models\\Product',39,'Audio Equipment',NULL,'products/7.jpg',2,522.00,1044.00,0.00,0.00,1044.00,'{\"sku\":\"SW-163-A0-A1\",\"attributes\":\"(Color: Black, Size: XXL)\"}','2024-03-11 00:14:23','2024-03-11 00:14:23'),(17,10,'Botble\\Ecommerce\\Models\\Product',52,'Herschel Leather Duffle Bag In Brown Color',NULL,'products/10.jpg',2,1199.00,2398.00,0.00,0.00,2398.00,'{\"sku\":\"SW-147-A0-A3\",\"attributes\":\"(Color: Green, Size: L)\"}','2024-03-11 00:14:23','2024-03-11 00:14:23'),(18,10,'Botble\\Ecommerce\\Models\\Product',53,'Herschel Leather Duffle Bag In Brown Color',NULL,'products/10.jpg',2,1199.00,2398.00,0.00,0.00,2398.00,'{\"sku\":\"SW-147-A0-A4\",\"attributes\":\"(Color: Green, Size: XXL)\"}','2024-03-11 00:14:23','2024-03-11 00:14:23'),(19,10,'Botble\\Ecommerce\\Models\\Product',70,'Samsung Gear VR Virtual Reality Headset (Digital)',NULL,'products/17.jpg',2,520.00,1040.00,0.00,0.00,1040.00,'{\"sku\":\"SW-123-A0\",\"attributes\":\"(Color: Green, Size: L)\"}','2024-03-11 00:14:23','2024-03-11 00:14:23'),(20,11,'Botble\\Ecommerce\\Models\\Product',24,'Dual Camera 20MP (Digital)',NULL,'products/1.jpg',3,80.25,240.75,0.00,0.00,240.75,'{\"sku\":\"SW-107-A0\",\"attributes\":\"(Color: Blue, Size: XL)\"}','2024-03-11 00:14:23','2024-03-11 00:14:23'),(21,11,'Botble\\Ecommerce\\Models\\Product',54,'Xbox One Wireless Controller Black Color',NULL,'products/11.jpg',2,1149.00,2298.00,0.00,0.00,2298.00,'{\"sku\":\"SW-170-A0\",\"attributes\":\"(Color: Green, Size: XL)\"}','2024-03-11 00:14:23','2024-03-11 00:14:23'),(22,12,'Botble\\Ecommerce\\Models\\Product',70,'Samsung Gear VR Virtual Reality Headset (Digital)',NULL,'products/17.jpg',2,520.00,1040.00,0.00,0.00,1040.00,'{\"sku\":\"SW-123-A0\",\"attributes\":\"(Color: Green, Size: L)\"}','2024-03-11 00:14:24','2024-03-11 00:14:24'),(23,13,'Botble\\Ecommerce\\Models\\Product',27,'Smart Watches',NULL,'products/2-2.jpg',3,40.50,121.50,0.00,0.00,121.50,'{\"sku\":\"SW-148-A0-A2\",\"attributes\":\"(Color: Blue, Size: XXL)\"}','2024-03-11 00:14:24','2024-03-11 00:14:24'),(24,13,'Botble\\Ecommerce\\Models\\Product',46,'Samsung Smart Phone (Digital)',NULL,'products/9.jpg',1,538.00,538.00,0.00,0.00,538.00,'{\"sku\":\"SW-138-A0\",\"attributes\":\"(Color: Red, Size: XXL)\"}','2024-03-11 00:14:24','2024-03-11 00:14:24'),(25,14,'Botble\\Ecommerce\\Models\\Product',34,'Smart Watch External (Digital)',NULL,'products/5-2.jpg',3,744.00,2232.00,0.00,0.00,2232.00,'{\"sku\":\"SW-181-A0-A2\",\"attributes\":\"(Color: Green, Size: XXL)\"}','2024-03-11 00:14:24','2024-03-11 00:14:24'),(26,15,'Botble\\Ecommerce\\Models\\Product',73,'Aveeno Moisturizing Body Shower 450ml',NULL,'products/18-1.jpg',1,936.00,936.00,0.00,0.00,936.00,'{\"sku\":\"SW-111-A0-A1\",\"attributes\":\"(Size: M, Color: Black)\"}','2024-03-11 00:14:24','2024-03-11 00:14:24'),(27,16,'Botble\\Ecommerce\\Models\\Product',30,'Beat Headphone',NULL,'products/3.jpg',1,20.00,20.00,0.00,0.00,20.00,'{\"sku\":\"SW-146-A0-A2\",\"attributes\":\"(Color: Brown, Size: XXL)\"}','2024-03-11 00:14:24','2024-03-11 00:14:24'),(28,16,'Botble\\Ecommerce\\Models\\Product',61,'EPSION Plaster Printer',NULL,'products/12-2.jpg',3,515.00,1545.00,0.00,0.00,1545.00,'{\"sku\":\"SW-199-A0-A2\",\"attributes\":\"(Color: Black, Size: XL)\"}','2024-03-11 00:14:24','2024-03-11 00:14:24'),(29,17,'Botble\\Ecommerce\\Models\\Product',37,'Nikon HD camera',NULL,'products/6.jpg',1,404.00,404.00,0.00,0.00,404.00,'{\"sku\":\"SW-194-A0-A2\",\"attributes\":\"(Color: Red, Size: XL)\"}','2024-03-11 00:14:24','2024-03-11 00:14:24'),(30,18,'Botble\\Ecommerce\\Models\\Product',71,'Samsung Gear VR Virtual Reality Headset (Digital)',NULL,'products/17-1.jpg',1,520.00,520.00,0.00,0.00,520.00,'{\"sku\":\"SW-123-A0-A1\",\"attributes\":\"(Size: S, Color: Brown)\"}','2024-03-11 00:14:25','2024-03-11 00:14:25'),(31,19,'Botble\\Ecommerce\\Models\\Product',50,'Herschel Leather Duffle Bag In Brown Color',NULL,'products/10-1.jpg',2,1199.00,2398.00,0.00,0.00,2398.00,'{\"sku\":\"SW-147-A0-A1\",\"attributes\":\"(Color: Blue, Size: M)\"}','2024-03-11 00:14:25','2024-03-11 00:14:25'),(32,19,'Botble\\Ecommerce\\Models\\Product',51,'Herschel Leather Duffle Bag In Brown Color',NULL,'products/10-2.jpg',2,1199.00,2398.00,0.00,0.00,2398.00,'{\"sku\":\"SW-147-A0-A2\",\"attributes\":\"(Color: Green, Size: L)\"}','2024-03-11 00:14:25','2024-03-11 00:14:25'),(33,20,'Botble\\Ecommerce\\Models\\Product',62,'Sound Intone I65 Earphone White Version (Digital)',NULL,'products/13.jpg',2,504.00,1008.00,0.00,0.00,1008.00,'{\"sku\":\"SW-156-A0\",\"attributes\":\"(Color: Blue, Size: XL)\"}','2024-03-11 00:14:25','2024-03-11 00:14:25'),(34,21,'Botble\\Ecommerce\\Models\\Product',54,'Xbox One Wireless Controller Black Color',NULL,'products/11.jpg',1,1149.00,1149.00,0.00,0.00,1149.00,'{\"sku\":\"SW-170-A0\",\"attributes\":\"(Color: Green, Size: XL)\"}','2024-03-11 00:14:25','2024-03-11 00:14:25'),(35,22,'Botble\\Ecommerce\\Models\\Product',68,'Apple MacBook Air Retina 12-Inch Laptop',NULL,'products/16.jpg',2,568.00,1136.00,0.00,0.00,1136.00,'{\"sku\":\"SW-109-A0\",\"attributes\":\"(Size: XL, Color: Brown)\"}','2024-03-11 00:14:25','2024-03-11 00:14:25'),(36,22,'Botble\\Ecommerce\\Models\\Product',76,'NYX Beauty Couton Pallete Makeup 12',NULL,'products/20.jpg',3,899.00,2697.00,0.00,0.00,2697.00,'{\"sku\":\"SW-113-A0\",\"attributes\":\"(Color: Blue, Size: M)\"}','2024-03-11 00:14:25','2024-03-11 00:14:25'),(37,23,'Botble\\Ecommerce\\Models\\Product',72,'Aveeno Moisturizing Body Shower 450ml',NULL,'products/18.jpg',3,936.00,2808.00,0.00,0.00,2808.00,'{\"sku\":\"SW-111-A0\",\"attributes\":\"(Size: L, Color: Brown)\"}','2024-03-11 00:14:26','2024-03-11 00:14:26'),(38,24,'Botble\\Ecommerce\\Models\\Product',52,'Herschel Leather Duffle Bag In Brown Color',NULL,'products/10.jpg',1,1199.00,1199.00,0.00,0.00,1199.00,'{\"sku\":\"SW-147-A0-A3\",\"attributes\":\"(Color: Green, Size: L)\"}','2024-03-11 00:14:26','2024-03-11 00:14:26'),(39,24,'Botble\\Ecommerce\\Models\\Product',53,'Herschel Leather Duffle Bag In Brown Color',NULL,'products/10.jpg',1,1199.00,1199.00,0.00,0.00,1199.00,'{\"sku\":\"SW-147-A0-A4\",\"attributes\":\"(Color: Green, Size: XXL)\"}','2024-03-11 00:14:26','2024-03-11 00:14:26'),(40,24,'Botble\\Ecommerce\\Models\\Product',73,'Aveeno Moisturizing Body Shower 450ml',NULL,'products/18-1.jpg',2,936.00,1872.00,0.00,0.00,1872.00,'{\"sku\":\"SW-111-A0-A1\",\"attributes\":\"(Size: M, Color: Black)\"}','2024-03-11 00:14:26','2024-03-11 00:14:26'),(41,24,'Botble\\Ecommerce\\Models\\Product',74,'Aveeno Moisturizing Body Shower 450ml',NULL,'products/18-2.jpg',1,936.00,936.00,0.00,0.00,936.00,'{\"sku\":\"SW-111-A0-A2\",\"attributes\":\"(Size: L, Color: Brown)\"}','2024-03-11 00:14:26','2024-03-11 00:14:26'),(42,25,'Botble\\Ecommerce\\Models\\Product',37,'Nikon HD camera',NULL,'products/6.jpg',1,404.00,404.00,0.00,0.00,404.00,'{\"sku\":\"SW-194-A0-A2\",\"attributes\":\"(Color: Red, Size: XL)\"}','2024-03-11 00:14:26','2024-03-11 00:14:26'),(43,25,'Botble\\Ecommerce\\Models\\Product',79,'MVMTH Classical Leather Watch In Black (Digital)',NULL,'products/21.jpg',2,758.00,1516.00,0.00,0.00,1516.00,'{\"sku\":\"SW-115-A0\",\"attributes\":\"(Size: L, Color: Black)\"}','2024-03-11 00:14:26','2024-03-11 00:14:26'),(44,26,'Botble\\Ecommerce\\Models\\Product',45,'Smart Televisions',NULL,'products/8-2.jpg',2,1171.00,2342.00,0.00,0.00,2342.00,'{\"sku\":\"SW-190-A0-A2\",\"attributes\":\"(Size: L, Color: Brown)\"}','2024-03-11 00:14:26','2024-03-11 00:14:26'),(45,27,'Botble\\Ecommerce\\Models\\Product',78,'NYX Beauty Couton Pallete Makeup 12',NULL,'products/20-2.jpg',2,899.00,1798.00,0.00,0.00,1798.00,'{\"sku\":\"SW-113-A0-A2\",\"attributes\":\"(Size: M, Color: Black)\"}','2024-03-11 00:14:26','2024-03-11 00:14:26'),(46,28,'Botble\\Ecommerce\\Models\\Product',40,'Audio Equipment',NULL,'products/7.jpg',2,522.00,1044.00,0.00,0.00,1044.00,'{\"sku\":\"SW-163-A0-A2\",\"attributes\":\"(Color: Red, Size: XL)\"}','2024-03-11 00:14:27','2024-03-11 00:14:27'),(47,29,'Botble\\Ecommerce\\Models\\Product',83,'Baxter Care Hair Kit For Bearded Mens',NULL,'products/22-2.jpg',3,422.00,1266.00,0.00,0.00,1266.00,'{\"sku\":\"SW-112-A0-A2\",\"attributes\":\"(Size: L, Color: Brown)\"}','2024-03-11 00:14:27','2024-03-11 00:14:27'),(48,30,'Botble\\Ecommerce\\Models\\Product',84,'Ciate Palemore Lipstick Bold Red Color',NULL,'products/23.jpg',1,1015.00,1015.00,0.00,0.00,1015.00,'{\"sku\":\"SW-193-A0\",\"attributes\":\"(Color: Blue, Size: L)\"}','2024-03-11 00:14:27','2024-03-11 00:14:27'),(49,31,'Botble\\Ecommerce\\Models\\Product',37,'Nikon HD camera',NULL,'products/6.jpg',3,404.00,1212.00,0.00,0.00,1212.00,'{\"sku\":\"SW-194-A0-A2\",\"attributes\":\"(Color: Red, Size: XL)\"}','2024-03-11 00:14:27','2024-03-11 00:14:27'),(50,32,'Botble\\Ecommerce\\Models\\Product',54,'Xbox One Wireless Controller Black Color',NULL,'products/11.jpg',2,1149.00,2298.00,0.00,0.00,2298.00,'{\"sku\":\"SW-170-A0\",\"attributes\":\"(Color: Green, Size: XL)\"}','2024-03-11 00:14:27','2024-03-11 00:14:27'),(51,32,'Botble\\Ecommerce\\Models\\Product',64,'B&amp;O Play Mini Bluetooth Speaker',NULL,'products/14.jpg',2,540.00,1080.00,0.00,0.00,1080.00,'{\"sku\":\"SW-129-A0\",\"attributes\":\"(Color: Green, Size: XXL)\"}','2024-03-11 00:14:27','2024-03-11 00:14:27'),(52,33,'Botble\\Ecommerce\\Models\\Product',70,'Samsung Gear VR Virtual Reality Headset (Digital)',NULL,'products/17.jpg',3,520.00,1560.00,0.00,0.00,1560.00,'{\"sku\":\"SW-123-A0\",\"attributes\":\"(Color: Green, Size: L)\"}','2024-03-11 00:14:27','2024-03-11 00:14:27'),(53,34,'Botble\\Ecommerce\\Models\\Product',48,'Samsung Smart Phone (Digital)',NULL,'products/9-2.jpg',1,538.00,538.00,0.00,0.00,538.00,'{\"sku\":\"SW-138-A0-A2\",\"attributes\":\"(Size: M, Color: Black)\"}','2024-03-11 00:14:28','2024-03-11 00:14:28'),(54,35,'Botble\\Ecommerce\\Models\\Product',75,'NYX Beauty Couton Pallete Makeup 12',NULL,'products/19.jpg',2,1069.00,2138.00,0.00,0.00,2138.00,'{\"sku\":\"SW-131-A0\",\"attributes\":\"(Color: Green, Size: S)\"}','2024-03-11 00:14:28','2024-03-11 00:14:28'),(55,36,'Botble\\Ecommerce\\Models\\Product',40,'Audio Equipment',NULL,'products/7.jpg',3,522.00,1566.00,0.00,0.00,1566.00,'{\"sku\":\"SW-163-A0-A2\",\"attributes\":\"(Color: Red, Size: XL)\"}','2024-03-11 00:14:28','2024-03-11 00:14:28'),(56,36,'Botble\\Ecommerce\\Models\\Product',69,'Apple MacBook Air Retina 12-Inch Laptop',NULL,'products/16.jpg',2,568.00,1136.00,0.00,0.00,1136.00,'{\"sku\":\"SW-109-A0-A1\",\"attributes\":\"(Size: M, Color: Brown)\"}','2024-03-11 00:14:28','2024-03-11 00:14:28'),(57,37,'Botble\\Ecommerce\\Models\\Product',81,'Baxter Care Hair Kit For Bearded Mens',NULL,'products/22.jpg',2,422.00,844.00,0.00,0.00,844.00,'{\"sku\":\"SW-112-A0\",\"attributes\":\"(Color: Green, Size: M)\"}','2024-03-11 00:14:28','2024-03-11 00:14:28'),(58,37,'Botble\\Ecommerce\\Models\\Product',83,'Baxter Care Hair Kit For Bearded Mens',NULL,'products/22-2.jpg',2,422.00,844.00,0.00,0.00,844.00,'{\"sku\":\"SW-112-A0-A2\",\"attributes\":\"(Size: L, Color: Brown)\"}','2024-03-11 00:14:28','2024-03-11 00:14:28'),(59,38,'Botble\\Ecommerce\\Models\\Product',64,'B&amp;O Play Mini Bluetooth Speaker',NULL,'products/14.jpg',1,540.00,540.00,0.00,0.00,540.00,'{\"sku\":\"SW-129-A0\",\"attributes\":\"(Color: Green, Size: XXL)\"}','2024-03-11 00:14:28','2024-03-11 00:14:28'),(60,38,'Botble\\Ecommerce\\Models\\Product',65,'B&amp;O Play Mini Bluetooth Speaker',NULL,'products/14.jpg',1,540.00,540.00,0.00,0.00,540.00,'{\"sku\":\"SW-129-A0-A1\",\"attributes\":\"(Color: Black, Size: XXL)\"}','2024-03-11 00:14:28','2024-03-11 00:14:28'),(61,39,'Botble\\Ecommerce\\Models\\Product',69,'Apple MacBook Air Retina 12-Inch Laptop',NULL,'products/16.jpg',3,568.00,1704.00,0.00,0.00,1704.00,'{\"sku\":\"SW-109-A0-A1\",\"attributes\":\"(Size: M, Color: Brown)\"}','2024-03-11 00:14:29','2024-03-11 00:14:29'),(62,39,'Botble\\Ecommerce\\Models\\Product',78,'NYX Beauty Couton Pallete Makeup 12',NULL,'products/20-2.jpg',2,899.00,1798.00,0.00,0.00,1798.00,'{\"sku\":\"SW-113-A0-A2\",\"attributes\":\"(Size: M, Color: Black)\"}','2024-03-11 00:14:29','2024-03-11 00:14:29'),(63,40,'Botble\\Ecommerce\\Models\\Product',30,'Beat Headphone',NULL,'products/3.jpg',2,20.00,40.00,0.00,0.00,40.00,'{\"sku\":\"SW-146-A0-A2\",\"attributes\":\"(Color: Brown, Size: XXL)\"}','2024-03-11 00:14:29','2024-03-11 00:14:29'),(64,40,'Botble\\Ecommerce\\Models\\Product',54,'Xbox One Wireless Controller Black Color',NULL,'products/11.jpg',1,1149.00,1149.00,0.00,0.00,1149.00,'{\"sku\":\"SW-170-A0\",\"attributes\":\"(Color: Green, Size: XL)\"}','2024-03-11 00:14:29','2024-03-11 00:14:29'),(65,41,'Botble\\Ecommerce\\Models\\Product',72,'Aveeno Moisturizing Body Shower 450ml',NULL,'products/18.jpg',1,936.00,936.00,0.00,0.00,936.00,'{\"sku\":\"SW-111-A0\",\"attributes\":\"(Size: L, Color: Brown)\"}','2024-03-11 00:14:29','2024-03-11 00:14:29'),(66,42,'Botble\\Ecommerce\\Models\\Product',31,'Red &amp; Black Headphone',NULL,'products/4.jpg',1,542.00,542.00,0.00,0.00,542.00,'{\"sku\":\"SW-109-A0\",\"attributes\":\"(Color: Blue, Size: XL)\"}','2024-03-11 00:14:29','2024-03-11 00:14:29'),(67,42,'Botble\\Ecommerce\\Models\\Product',79,'MVMTH Classical Leather Watch In Black (Digital)',NULL,'products/21.jpg',2,758.00,1516.00,0.00,0.00,1516.00,'{\"sku\":\"SW-115-A0\",\"attributes\":\"(Size: L, Color: Black)\"}','2024-03-11 00:14:29','2024-03-11 00:14:29'),(68,43,'Botble\\Ecommerce\\Models\\Product',73,'Aveeno Moisturizing Body Shower 450ml',NULL,'products/18-1.jpg',2,936.00,1872.00,0.00,0.00,1872.00,'{\"sku\":\"SW-111-A0-A1\",\"attributes\":\"(Size: M, Color: Black)\"}','2024-03-11 00:14:29','2024-03-11 00:14:29'),(69,43,'Botble\\Ecommerce\\Models\\Product',85,'Ciate Palemore Lipstick Bold Red Color',NULL,'products/23-1.jpg',3,1015.00,3045.00,0.00,0.00,3045.00,'{\"sku\":\"SW-193-A0-A1\",\"attributes\":\"(Size: M, Color: Brown)\"}','2024-03-11 00:14:29','2024-03-11 00:14:29'),(70,44,'Botble\\Ecommerce\\Models\\Product',63,'Sound Intone I65 Earphone White Version (Digital)',NULL,'products/13-1.jpg',1,504.00,504.00,0.00,0.00,504.00,'{\"sku\":\"SW-156-A0-A1\",\"attributes\":\"(Color: Black, Size: XXL)\"}','2024-03-11 00:14:30','2024-03-11 00:14:30'),(71,45,'Botble\\Ecommerce\\Models\\Product',76,'NYX Beauty Couton Pallete Makeup 12',NULL,'products/20.jpg',1,899.00,899.00,0.00,0.00,899.00,'{\"sku\":\"SW-113-A0\",\"attributes\":\"(Color: Blue, Size: M)\"}','2024-03-11 00:14:30','2024-03-11 00:14:30');

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

CREATE TABLE `ec_invoices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `reference_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_tax_id` varchar(255) 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` bigint unsigned DEFAULT NULL,
  `status` varchar(255) 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 AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_invoices` VALUES (1,'Botble\\Ecommerce\\Models\\Order',1,'INV-1','Aylin Effertz','',NULL,'frami.tyreek@example.com','+17628925007','7522 Koss Corners, Montanaborough, Rhode Island, RU',NULL,4757.00,0.00,0.00,0.00,'1','default',NULL,NULL,4757.00,NULL,1,'completed','2024-03-11 00:14:21','2024-02-28 08:14:21','2024-03-11 00:14:21'),(2,'Botble\\Ecommerce\\Models\\Order',2,'INV-2','Aylin Effertz','',NULL,'frami.tyreek@example.com','+17628925007','7522 Koss Corners, Montanaborough, Rhode Island, RU',NULL,1199.00,0.00,0.00,0.00,'1','default',NULL,NULL,1199.00,NULL,2,'completed','2024-03-11 00:14:22','2024-03-01 00:14:22','2024-03-11 00:14:22'),(3,'Botble\\Ecommerce\\Models\\Order',3,'INV-3','Dr. Michel Reynolds PhD','',NULL,'cristina.smitham@example.net','+14233056041','20837 Parisian Fall, West Laviniamouth, Arizona, CW',NULL,1266.00,0.00,0.00,0.00,'1','default',NULL,NULL,1266.00,NULL,3,'pending',NULL,'2024-03-07 20:14:22','2024-03-11 00:14:22'),(4,'Botble\\Ecommerce\\Models\\Order',4,'INV-4','Dr. Michel Reynolds PhD','',NULL,'cristina.smitham@example.net','+14233056041','20837 Parisian Fall, West Laviniamouth, Arizona, CW',NULL,5811.00,0.00,0.00,0.00,'1','default',NULL,NULL,5811.00,NULL,4,'completed','2024-03-11 00:14:22','2024-03-01 12:14:22','2024-03-11 00:14:22'),(5,'Botble\\Ecommerce\\Models\\Order',5,'INV-5','Dr. Michel Reynolds PhD','',NULL,'cristina.smitham@example.net','+14233056041','20837 Parisian Fall, West Laviniamouth, Arizona, CW',NULL,5670.00,0.00,0.00,0.00,'1','default',NULL,NULL,5670.00,NULL,5,'completed','2024-03-11 00:14:22','2024-02-25 00:14:22','2024-03-11 00:14:22'),(6,'Botble\\Ecommerce\\Models\\Order',6,'INV-6','Dr. Michel Reynolds PhD','',NULL,'cristina.smitham@example.net','+14233056041','20837 Parisian Fall, West Laviniamouth, Arizona, CW',NULL,1614.00,0.00,0.00,0.00,NULL,'',NULL,NULL,1614.00,NULL,6,'pending',NULL,'2024-03-09 12:14:22','2024-03-11 00:14:22'),(7,'Botble\\Ecommerce\\Models\\Order',7,'INV-7','Mr. Walton Pagac III','',NULL,'quincy.collins@example.net','+13365056070','18368 Sandrine Mill, Port Vada, Delaware, GU',NULL,40.00,0.00,0.00,0.00,'1','default',NULL,NULL,40.00,NULL,7,'completed','2024-03-11 00:14:23','2024-03-08 04:14:23','2024-03-11 00:14:23'),(8,'Botble\\Ecommerce\\Models\\Order',8,'INV-8','Mr. Walton Pagac III','',NULL,'quincy.collins@example.net','+13365056070','18368 Sandrine Mill, Port Vada, Delaware, GU',NULL,2020.00,0.00,0.00,0.00,NULL,'',NULL,NULL,2020.00,NULL,8,'completed','2024-03-11 00:14:23','2024-02-27 06:14:23','2024-03-11 00:14:23'),(9,'Botble\\Ecommerce\\Models\\Order',9,'INV-9','Mr. Walton Pagac III','',NULL,'quincy.collins@example.net','+13365056070','18368 Sandrine Mill, Port Vada, Delaware, GU',NULL,1044.00,0.00,0.00,0.00,'1','default',NULL,NULL,1044.00,NULL,9,'pending',NULL,'2024-03-08 08:14:23','2024-03-11 00:14:23'),(10,'Botble\\Ecommerce\\Models\\Order',10,'INV-10','Mr. Walton Pagac III','',NULL,'quincy.collins@example.net','+13365056070','18368 Sandrine Mill, Port Vada, Delaware, GU',NULL,5836.00,0.00,0.00,0.00,'1','default',NULL,NULL,5836.00,NULL,10,'completed','2024-03-11 00:14:23','2024-03-05 16:14:23','2024-03-11 00:14:23'),(11,'Botble\\Ecommerce\\Models\\Order',11,'INV-11','Dr. Michel Reynolds PhD','',NULL,'cristina.smitham@example.net','+14233056041','20837 Parisian Fall, West Laviniamouth, Arizona, CW',NULL,2538.75,0.00,0.00,0.00,'1','default',NULL,NULL,2538.75,NULL,11,'completed','2024-03-11 00:14:23','2024-02-28 18:14:23','2024-03-11 00:14:23'),(12,'Botble\\Ecommerce\\Models\\Order',12,'INV-12','Dr. Michel Reynolds PhD','',NULL,'cristina.smitham@example.net','+14233056041','20837 Parisian Fall, West Laviniamouth, Arizona, CW',NULL,1040.00,0.00,0.00,0.00,NULL,'',NULL,NULL,1040.00,NULL,12,'pending',NULL,'2024-03-02 06:14:24','2024-03-11 00:14:24'),(13,'Botble\\Ecommerce\\Models\\Order',13,'INV-13','Dr. Elyse Prohaska','',NULL,'customer@botble.com','+18127482672','83639 Hickle Drive Suite 309, West Addieville, Kansas, SA',NULL,659.50,0.00,0.00,0.00,'1','default',NULL,NULL,659.50,NULL,13,'completed','2024-03-11 00:14:24','2024-03-01 16:14:24','2024-03-11 00:14:24'),(14,'Botble\\Ecommerce\\Models\\Order',14,'INV-14','Dr. Elyse Prohaska','',NULL,'customer@botble.com','+18127482672','83639 Hickle Drive Suite 309, West Addieville, Kansas, SA',NULL,2232.00,0.00,0.00,0.00,NULL,'',NULL,NULL,2232.00,NULL,14,'completed','2024-03-11 00:14:24','2024-03-08 16:14:24','2024-03-11 00:14:24'),(15,'Botble\\Ecommerce\\Models\\Order',15,'INV-15','Dr. Elyse Prohaska','',NULL,'customer@botble.com','+18127482672','83639 Hickle Drive Suite 309, West Addieville, Kansas, SA',NULL,936.00,0.00,0.00,0.00,'1','default',NULL,NULL,936.00,NULL,15,'completed','2024-03-11 00:14:24','2024-03-01 16:14:24','2024-03-11 00:14:24'),(16,'Botble\\Ecommerce\\Models\\Order',16,'INV-16','Mr. Nels Legros IV','',NULL,'schulist.ariel@example.com','+12512908614','260 Brennon Estates Apt. 027, Kassulkehaven, Utah, LS',NULL,1565.00,0.00,0.00,0.00,'1','default',NULL,NULL,1565.00,NULL,16,'pending',NULL,'2024-03-01 06:14:24','2024-03-11 00:14:24'),(17,'Botble\\Ecommerce\\Models\\Order',17,'INV-17','Mr. Nels Legros IV','',NULL,'schulist.ariel@example.com','+12512908614','260 Brennon Estates Apt. 027, Kassulkehaven, Utah, LS',NULL,404.00,0.00,0.00,0.00,'1','default',NULL,NULL,404.00,NULL,17,'completed','2024-03-11 00:14:24','2024-03-03 10:14:24','2024-03-11 00:14:24'),(18,'Botble\\Ecommerce\\Models\\Order',18,'INV-18','Mr. Nels Legros IV','',NULL,'schulist.ariel@example.com','+12512908614','260 Brennon Estates Apt. 027, Kassulkehaven, Utah, LS',NULL,520.00,0.00,0.00,0.00,NULL,'',NULL,NULL,520.00,NULL,18,'pending',NULL,'2024-03-02 08:14:25','2024-03-11 00:14:25'),(19,'Botble\\Ecommerce\\Models\\Order',19,'INV-19','Dr. Michel Reynolds PhD','',NULL,'cristina.smitham@example.net','+14233056041','20837 Parisian Fall, West Laviniamouth, Arizona, CW',NULL,4796.00,0.00,0.00,0.00,'1','default',NULL,NULL,4796.00,NULL,19,'completed','2024-03-11 00:14:25','2024-03-10 00:14:25','2024-03-11 00:14:25'),(20,'Botble\\Ecommerce\\Models\\Order',20,'INV-20','Dr. Michel Reynolds PhD','',NULL,'cristina.smitham@example.net','+14233056041','20837 Parisian Fall, West Laviniamouth, Arizona, CW',NULL,1008.00,0.00,0.00,0.00,NULL,'',NULL,NULL,1008.00,NULL,20,'completed','2024-03-11 00:14:25','2024-03-07 00:14:25','2024-03-11 00:14:25'),(21,'Botble\\Ecommerce\\Models\\Order',21,'INV-21','Mr. Nels Legros IV','',NULL,'schulist.ariel@example.com','+12512908614','260 Brennon Estates Apt. 027, Kassulkehaven, Utah, LS',NULL,1149.00,0.00,0.00,0.00,'1','default',NULL,NULL,1149.00,NULL,21,'pending',NULL,'2024-03-05 12:14:25','2024-03-11 00:14:25'),(22,'Botble\\Ecommerce\\Models\\Order',22,'INV-22','Mr. Nels Legros IV','',NULL,'schulist.ariel@example.com','+12512908614','260 Brennon Estates Apt. 027, Kassulkehaven, Utah, LS',NULL,3833.00,0.00,0.00,0.00,'1','default',NULL,NULL,3833.00,NULL,22,'completed','2024-03-11 00:14:25','2024-03-09 04:14:25','2024-03-11 00:14:25'),(23,'Botble\\Ecommerce\\Models\\Order',23,'INV-23','Mr. Nels Legros IV','',NULL,'schulist.ariel@example.com','+12512908614','260 Brennon Estates Apt. 027, Kassulkehaven, Utah, LS',NULL,2808.00,0.00,0.00,0.00,'1','default',NULL,NULL,2808.00,NULL,23,'pending',NULL,'2024-03-05 12:14:26','2024-03-11 00:14:26'),(24,'Botble\\Ecommerce\\Models\\Order',24,'INV-24','Dr. Michel Reynolds PhD','',NULL,'cristina.smitham@example.net','+14233056041','20837 Parisian Fall, West Laviniamouth, Arizona, CW',NULL,5206.00,0.00,0.00,0.00,'1','default',NULL,NULL,5206.00,NULL,24,'completed','2024-03-11 00:14:26','2024-03-09 08:14:26','2024-03-11 00:14:26'),(25,'Botble\\Ecommerce\\Models\\Order',25,'INV-25','Dr. Michel Reynolds PhD','',NULL,'cristina.smitham@example.net','+14233056041','20837 Parisian Fall, West Laviniamouth, Arizona, CW',NULL,1920.00,0.00,0.00,0.00,'1','default',NULL,NULL,1920.00,NULL,25,'completed','2024-03-11 00:14:26','2024-03-09 12:14:26','2024-03-11 00:14:26'),(26,'Botble\\Ecommerce\\Models\\Order',26,'INV-26','Dr. Michel Reynolds PhD','',NULL,'cristina.smitham@example.net','+14233056041','20837 Parisian Fall, West Laviniamouth, Arizona, CW',NULL,2342.00,0.00,0.00,0.00,'1','default',NULL,NULL,2342.00,NULL,26,'completed','2024-03-11 00:14:26','2024-03-08 00:14:26','2024-03-11 00:14:26'),(27,'Botble\\Ecommerce\\Models\\Order',27,'INV-27','Dr. Michel Reynolds PhD','',NULL,'cristina.smitham@example.net','+14233056041','20837 Parisian Fall, West Laviniamouth, Arizona, CW',NULL,1798.00,0.00,0.00,0.00,'1','default',NULL,NULL,1798.00,NULL,27,'completed','2024-03-11 00:14:26','2024-03-08 00:14:26','2024-03-11 00:14:26'),(28,'Botble\\Ecommerce\\Models\\Order',28,'INV-28','Dr. Elyse Prohaska','',NULL,'customer@botble.com','+18127482672','83639 Hickle Drive Suite 309, West Addieville, Kansas, SA',NULL,1044.00,0.00,0.00,0.00,'1','default',NULL,NULL,1044.00,NULL,28,'completed','2024-03-11 00:14:27','2024-03-07 16:14:27','2024-03-11 00:14:27'),(29,'Botble\\Ecommerce\\Models\\Order',29,'INV-29','Dr. Elyse Prohaska','',NULL,'customer@botble.com','+18127482672','83639 Hickle Drive Suite 309, West Addieville, Kansas, SA',NULL,1266.00,0.00,0.00,0.00,'1','default',NULL,NULL,1266.00,NULL,29,'completed','2024-03-11 00:14:27','2024-03-08 08:14:27','2024-03-11 00:14:27'),(30,'Botble\\Ecommerce\\Models\\Order',30,'INV-30','Dr. Elyse Prohaska','',NULL,'customer@botble.com','+18127482672','83639 Hickle Drive Suite 309, West Addieville, Kansas, SA',NULL,1015.00,0.00,0.00,0.00,'1','default',NULL,NULL,1015.00,NULL,30,'completed','2024-03-11 00:14:27','2024-03-05 16:14:27','2024-03-11 00:14:27'),(31,'Botble\\Ecommerce\\Models\\Order',31,'INV-31','Mr. Walton Pagac III','',NULL,'quincy.collins@example.net','+13365056070','18368 Sandrine Mill, Port Vada, Delaware, GU',NULL,1212.00,0.00,0.00,0.00,'1','default',NULL,NULL,1212.00,NULL,31,'completed','2024-03-11 00:14:27','2024-03-07 12:14:27','2024-03-11 00:14:27'),(32,'Botble\\Ecommerce\\Models\\Order',32,'INV-32','Mr. Walton Pagac III','',NULL,'quincy.collins@example.net','+13365056070','18368 Sandrine Mill, Port Vada, Delaware, GU',NULL,3378.00,0.00,0.00,0.00,'1','default',NULL,NULL,3378.00,NULL,32,'completed','2024-03-11 00:14:27','2024-03-10 10:14:27','2024-03-11 00:14:27'),(33,'Botble\\Ecommerce\\Models\\Order',33,'INV-33','Mr. Walton Pagac III','',NULL,'quincy.collins@example.net','+13365056070','18368 Sandrine Mill, Port Vada, Delaware, GU',NULL,1560.00,0.00,0.00,0.00,NULL,'',NULL,NULL,1560.00,NULL,33,'completed','2024-03-11 00:14:27','2024-03-09 06:14:27','2024-03-11 00:14:27'),(34,'Botble\\Ecommerce\\Models\\Order',34,'INV-34','Mr. Walton Pagac III','',NULL,'quincy.collins@example.net','+13365056070','18368 Sandrine Mill, Port Vada, Delaware, GU',NULL,538.00,0.00,0.00,0.00,NULL,'',NULL,NULL,538.00,NULL,34,'completed','2024-03-11 00:14:28','2024-03-06 12:14:28','2024-03-11 00:14:28'),(35,'Botble\\Ecommerce\\Models\\Order',35,'INV-35','Mr. Walton Pagac III','',NULL,'quincy.collins@example.net','+13365056070','18368 Sandrine Mill, Port Vada, Delaware, GU',NULL,2138.00,0.00,0.00,0.00,'1','default',NULL,NULL,2138.00,NULL,35,'completed','2024-03-11 00:14:28','2024-03-09 12:14:28','2024-03-11 00:14:28'),(36,'Botble\\Ecommerce\\Models\\Order',36,'INV-36','Hertha Schuster','',NULL,'kaylee.mertz@example.com','+12515480623','50668 Okey Forge Suite 419, Raefurt, Alaska, AI',NULL,2702.00,0.00,0.00,0.00,'1','default',NULL,NULL,2702.00,NULL,36,'pending',NULL,'2024-03-08 22:14:28','2024-03-11 00:14:28'),(37,'Botble\\Ecommerce\\Models\\Order',37,'INV-37','Hertha Schuster','',NULL,'kaylee.mertz@example.com','+12515480623','50668 Okey Forge Suite 419, Raefurt, Alaska, AI',NULL,1688.00,0.00,0.00,0.00,'1','default',NULL,NULL,1688.00,NULL,37,'completed','2024-03-11 00:14:28','2024-03-06 20:14:28','2024-03-11 00:14:28'),(38,'Botble\\Ecommerce\\Models\\Order',38,'INV-38','Aylin Effertz','',NULL,'frami.tyreek@example.com','+17628925007','7522 Koss Corners, Montanaborough, Rhode Island, RU',NULL,1080.00,0.00,0.00,0.00,'1','default',NULL,NULL,1080.00,NULL,38,'completed','2024-03-11 00:14:28','2024-03-09 16:14:28','2024-03-11 00:14:28'),(39,'Botble\\Ecommerce\\Models\\Order',39,'INV-39','Aylin Effertz','',NULL,'frami.tyreek@example.com','+17628925007','7522 Koss Corners, Montanaborough, Rhode Island, RU',NULL,3502.00,0.00,0.00,0.00,'1','default',NULL,NULL,3502.00,NULL,39,'completed','2024-03-11 00:14:29','2024-03-07 16:14:29','2024-03-11 00:14:29'),(40,'Botble\\Ecommerce\\Models\\Order',40,'INV-40','Dr. Michel Reynolds PhD','',NULL,'cristina.smitham@example.net','+14233056041','20837 Parisian Fall, West Laviniamouth, Arizona, CW',NULL,1189.00,0.00,0.00,0.00,'1','default',NULL,NULL,1189.00,NULL,40,'completed','2024-03-11 00:14:29','2024-03-10 00:14:29','2024-03-11 00:14:29'),(41,'Botble\\Ecommerce\\Models\\Order',41,'INV-41','Dr. Michel Reynolds PhD','',NULL,'cristina.smitham@example.net','+14233056041','20837 Parisian Fall, West Laviniamouth, Arizona, CW',NULL,936.00,0.00,0.00,0.00,'1','default',NULL,NULL,936.00,NULL,41,'completed','2024-03-11 00:14:29','2024-03-09 12:14:29','2024-03-11 00:14:29'),(42,'Botble\\Ecommerce\\Models\\Order',42,'INV-42','Aylin Effertz','',NULL,'frami.tyreek@example.com','+17628925007','7522 Koss Corners, Montanaborough, Rhode Island, RU',NULL,2058.00,0.00,0.00,0.00,'1','default',NULL,NULL,2058.00,NULL,42,'completed','2024-03-11 00:14:29','2024-03-09 16:14:29','2024-03-11 00:14:29'),(43,'Botble\\Ecommerce\\Models\\Order',43,'INV-43','Aylin Effertz','',NULL,'frami.tyreek@example.com','+17628925007','7522 Koss Corners, Montanaborough, Rhode Island, RU',NULL,4917.00,0.00,0.00,0.00,'1','default',NULL,NULL,4917.00,NULL,43,'completed','2024-03-11 00:14:29','2024-03-10 08:14:29','2024-03-11 00:14:29'),(44,'Botble\\Ecommerce\\Models\\Order',44,'INV-44','Mr. Walton Pagac III','',NULL,'quincy.collins@example.net','+13365056070','18368 Sandrine Mill, Port Vada, Delaware, GU',NULL,504.00,0.00,0.00,0.00,NULL,'',NULL,NULL,504.00,NULL,44,'completed','2024-03-11 00:14:30','2024-03-10 18:14:30','2024-03-11 00:14:30'),(45,'Botble\\Ecommerce\\Models\\Order',45,'INV-45','Mr. Walton Pagac III','',NULL,'quincy.collins@example.net','+13365056070','18368 Sandrine Mill, Port Vada, Delaware, GU',NULL,899.00,0.00,0.00,0.00,'1','default',NULL,NULL,899.00,NULL,45,'completed','2024-03-11 00:14:30','2024-03-10 08:14:30','2024-03-11 00:14:30');

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

CREATE TABLE `ec_option_value` (
  `option_id` bigint unsigned NOT NULL COMMENT 'option id',
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `ec_option_value_translations`
--

CREATE TABLE `ec_option_value_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_option_value_id` bigint unsigned NOT NULL,
  `option_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_option_value_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_option_value_translations`
--


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

CREATE TABLE `ec_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of options',
  `option_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'option type',
  `product_id` bigint unsigned 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_options_translations`
--

CREATE TABLE `ec_options_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_options_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_options_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_options_translations`
--


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

CREATE TABLE `ec_order_addresses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) 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` bigint 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=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_order_addresses` VALUES (1,'Aylin Effertz','+17628925007','frami.tyreek@example.com','RU','Rhode Island','Montanaborough','7522 Koss Corners',1,'02353','shipping_address'),(2,'Aylin Effertz','+17628925007','frami.tyreek@example.com','RU','Rhode Island','Montanaborough','7522 Koss Corners',2,'02353','shipping_address'),(3,'Dr. Michel Reynolds PhD','+14233056041','cristina.smitham@example.net','CW','Arizona','West Laviniamouth','20837 Parisian Fall',3,'97666-3788','shipping_address'),(4,'Dr. Michel Reynolds PhD','+14233056041','cristina.smitham@example.net','CW','Arizona','West Laviniamouth','20837 Parisian Fall',4,'97666-3788','shipping_address'),(5,'Dr. Michel Reynolds PhD','+14233056041','cristina.smitham@example.net','CW','Arizona','West Laviniamouth','20837 Parisian Fall',5,'97666-3788','shipping_address'),(6,'Dr. Michel Reynolds PhD','+14233056041','cristina.smitham@example.net','CW','Arizona','West Laviniamouth','20837 Parisian Fall',6,'97666-3788','shipping_address'),(7,'Mr. Walton Pagac III','+13365056070','quincy.collins@example.net','GU','Delaware','Port Vada','18368 Sandrine Mill',7,'75805-4230','shipping_address'),(8,'Mr. Walton Pagac III','+13365056070','quincy.collins@example.net','GU','Delaware','Port Vada','18368 Sandrine Mill',8,'75805-4230','shipping_address'),(9,'Mr. Walton Pagac III','+13365056070','quincy.collins@example.net','GU','Delaware','Port Vada','18368 Sandrine Mill',9,'75805-4230','shipping_address'),(10,'Mr. Walton Pagac III','+13365056070','quincy.collins@example.net','GU','Delaware','Port Vada','18368 Sandrine Mill',10,'75805-4230','shipping_address'),(11,'Dr. Michel Reynolds PhD','+14233056041','cristina.smitham@example.net','CW','Arizona','West Laviniamouth','20837 Parisian Fall',11,'97666-3788','shipping_address'),(12,'Dr. Michel Reynolds PhD','+14233056041','cristina.smitham@example.net','CW','Arizona','West Laviniamouth','20837 Parisian Fall',12,'97666-3788','shipping_address'),(13,'Dr. Elyse Prohaska','+18127482672','customer@botble.com','SA','Kansas','West Addieville','83639 Hickle Drive Suite 309',13,'95742','shipping_address'),(14,'Dr. Elyse Prohaska','+18127482672','customer@botble.com','SA','Kansas','West Addieville','83639 Hickle Drive Suite 309',14,'95742','shipping_address'),(15,'Dr. Elyse Prohaska','+18127482672','customer@botble.com','SA','Kansas','West Addieville','83639 Hickle Drive Suite 309',15,'95742','shipping_address'),(16,'Mr. Nels Legros IV','+12512908614','schulist.ariel@example.com','LS','Utah','Kassulkehaven','260 Brennon Estates Apt. 027',16,'24166-7166','shipping_address'),(17,'Mr. Nels Legros IV','+12512908614','schulist.ariel@example.com','LS','Utah','Kassulkehaven','260 Brennon Estates Apt. 027',17,'24166-7166','shipping_address'),(18,'Mr. Nels Legros IV','+12512908614','schulist.ariel@example.com','LS','Utah','Kassulkehaven','260 Brennon Estates Apt. 027',18,'24166-7166','shipping_address'),(19,'Dr. Michel Reynolds PhD','+14233056041','cristina.smitham@example.net','CW','Arizona','West Laviniamouth','20837 Parisian Fall',19,'97666-3788','shipping_address'),(20,'Dr. Michel Reynolds PhD','+14233056041','cristina.smitham@example.net','CW','Arizona','West Laviniamouth','20837 Parisian Fall',20,'97666-3788','shipping_address'),(21,'Mr. Nels Legros IV','+12512908614','schulist.ariel@example.com','LS','Utah','Kassulkehaven','260 Brennon Estates Apt. 027',21,'24166-7166','shipping_address'),(22,'Mr. Nels Legros IV','+12512908614','schulist.ariel@example.com','LS','Utah','Kassulkehaven','260 Brennon Estates Apt. 027',22,'24166-7166','shipping_address'),(23,'Mr. Nels Legros IV','+12512908614','schulist.ariel@example.com','LS','Utah','Kassulkehaven','260 Brennon Estates Apt. 027',23,'24166-7166','shipping_address'),(24,'Dr. Michel Reynolds PhD','+14233056041','cristina.smitham@example.net','CW','Arizona','West Laviniamouth','20837 Parisian Fall',24,'97666-3788','shipping_address'),(25,'Dr. Michel Reynolds PhD','+14233056041','cristina.smitham@example.net','CW','Arizona','West Laviniamouth','20837 Parisian Fall',25,'97666-3788','shipping_address'),(26,'Dr. Michel Reynolds PhD','+14233056041','cristina.smitham@example.net','CW','Arizona','West Laviniamouth','20837 Parisian Fall',26,'97666-3788','shipping_address'),(27,'Dr. Michel Reynolds PhD','+14233056041','cristina.smitham@example.net','CW','Arizona','West Laviniamouth','20837 Parisian Fall',27,'97666-3788','shipping_address'),(28,'Dr. Elyse Prohaska','+18127482672','customer@botble.com','SA','Kansas','West Addieville','83639 Hickle Drive Suite 309',28,'95742','shipping_address'),(29,'Dr. Elyse Prohaska','+18127482672','customer@botble.com','SA','Kansas','West Addieville','83639 Hickle Drive Suite 309',29,'95742','shipping_address'),(30,'Dr. Elyse Prohaska','+18127482672','customer@botble.com','SA','Kansas','West Addieville','83639 Hickle Drive Suite 309',30,'95742','shipping_address'),(31,'Mr. Walton Pagac III','+13365056070','quincy.collins@example.net','GU','Delaware','Port Vada','18368 Sandrine Mill',31,'75805-4230','shipping_address'),(32,'Mr. Walton Pagac III','+13365056070','quincy.collins@example.net','GU','Delaware','Port Vada','18368 Sandrine Mill',32,'75805-4230','shipping_address'),(33,'Mr. Walton Pagac III','+13365056070','quincy.collins@example.net','GU','Delaware','Port Vada','18368 Sandrine Mill',33,'75805-4230','shipping_address'),(34,'Mr. Walton Pagac III','+13365056070','quincy.collins@example.net','GU','Delaware','Port Vada','18368 Sandrine Mill',34,'75805-4230','shipping_address'),(35,'Mr. Walton Pagac III','+13365056070','quincy.collins@example.net','GU','Delaware','Port Vada','18368 Sandrine Mill',35,'75805-4230','shipping_address'),(36,'Hertha Schuster','+12515480623','kaylee.mertz@example.com','AI','Alaska','Raefurt','50668 Okey Forge Suite 419',36,'74038','shipping_address'),(37,'Hertha Schuster','+12515480623','kaylee.mertz@example.com','AI','Alaska','Raefurt','50668 Okey Forge Suite 419',37,'74038','shipping_address'),(38,'Aylin Effertz','+17628925007','frami.tyreek@example.com','RU','Rhode Island','Montanaborough','7522 Koss Corners',38,'02353','shipping_address'),(39,'Aylin Effertz','+17628925007','frami.tyreek@example.com','RU','Rhode Island','Montanaborough','7522 Koss Corners',39,'02353','shipping_address'),(40,'Dr. Michel Reynolds PhD','+14233056041','cristina.smitham@example.net','CW','Arizona','West Laviniamouth','20837 Parisian Fall',40,'97666-3788','shipping_address'),(41,'Dr. Michel Reynolds PhD','+14233056041','cristina.smitham@example.net','CW','Arizona','West Laviniamouth','20837 Parisian Fall',41,'97666-3788','shipping_address'),(42,'Aylin Effertz','+17628925007','frami.tyreek@example.com','RU','Rhode Island','Montanaborough','7522 Koss Corners',42,'02353','shipping_address'),(43,'Aylin Effertz','+17628925007','frami.tyreek@example.com','RU','Rhode Island','Montanaborough','7522 Koss Corners',43,'02353','shipping_address'),(44,'Mr. Walton Pagac III','+13365056070','quincy.collins@example.net','GU','Delaware','Port Vada','18368 Sandrine Mill',44,'75805-4230','shipping_address'),(45,'Mr. Walton Pagac III','+13365056070','quincy.collins@example.net','GU','Delaware','Port Vada','18368 Sandrine Mill',45,'75805-4230','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(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `order_id` bigint 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=204 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,'2024-02-28 08:14:21','2024-02-28 08:14:21'),(2,'confirm_order','Order was verified by %user_name%',0,1,NULL,'2024-02-28 08:14:21','2024-02-28 08:14:21'),(3,'confirm_payment','Payment was confirmed (amount $4,757.00) by %user_name%',0,1,NULL,'2024-03-11 00:14:21','2024-03-11 00:14:21'),(4,'create_shipment','Created shipment for order',0,1,NULL,'2024-03-11 00:14:22','2024-03-11 00:14:22'),(5,'create_order_from_seeder','Order is created from the checkout page',NULL,2,NULL,'2024-03-01 00:14:22','2024-03-01 00:14:22'),(6,'confirm_order','Order was verified by %user_name%',0,2,NULL,'2024-03-01 00:14:22','2024-03-01 00:14:22'),(7,'confirm_payment','Payment was confirmed (amount $1,199.00) by %user_name%',0,2,NULL,'2024-03-11 00:14:22','2024-03-11 00:14:22'),(8,'create_shipment','Created shipment for order',0,2,NULL,'2024-03-11 00:14:22','2024-03-11 00:14:22'),(9,'create_order_from_seeder','Order is created from the checkout page',NULL,3,NULL,'2024-03-07 20:14:22','2024-03-07 20:14:22'),(10,'confirm_order','Order was verified by %user_name%',0,3,NULL,'2024-03-07 20:14:22','2024-03-07 20:14:22'),(11,'create_shipment','Created shipment for order',0,3,NULL,'2024-03-11 00:14:22','2024-03-11 00:14:22'),(12,'create_order_from_seeder','Order is created from the checkout page',NULL,4,NULL,'2024-03-01 12:14:22','2024-03-01 12:14:22'),(13,'confirm_order','Order was verified by %user_name%',0,4,NULL,'2024-03-01 12:14:22','2024-03-01 12:14:22'),(14,'confirm_payment','Payment was confirmed (amount $5,811.00) by %user_name%',0,4,NULL,'2024-03-11 00:14:22','2024-03-11 00:14:22'),(15,'create_shipment','Created shipment for order',0,4,NULL,'2024-03-11 00:14:22','2024-03-11 00:14:22'),(16,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,4,NULL,'2024-03-11 00:14:22','2024-03-11 00:14:22'),(17,'create_order_from_seeder','Order is created from the checkout page',NULL,5,NULL,'2024-02-25 00:14:22','2024-02-25 00:14:22'),(18,'confirm_order','Order was verified by %user_name%',0,5,NULL,'2024-02-25 00:14:22','2024-02-25 00:14:22'),(19,'confirm_payment','Payment was confirmed (amount $5,670.00) by %user_name%',0,5,NULL,'2024-03-11 00:14:22','2024-03-11 00:14:22'),(20,'create_shipment','Created shipment for order',0,5,NULL,'2024-03-11 00:14:22','2024-03-11 00:14:22'),(21,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,5,NULL,'2024-03-11 00:14:22','2024-03-11 00:14:22'),(22,'create_order_from_seeder','Order is created from the checkout page',NULL,6,NULL,'2024-03-09 12:14:22','2024-03-09 12:14:22'),(23,'confirm_order','Order was verified by %user_name%',0,6,NULL,'2024-03-09 12:14:22','2024-03-09 12:14:22'),(24,'create_order_from_seeder','Order is created from the checkout page',NULL,7,NULL,'2024-03-08 04:14:23','2024-03-08 04:14:23'),(25,'confirm_order','Order was verified by %user_name%',0,7,NULL,'2024-03-08 04:14:23','2024-03-08 04:14:23'),(26,'confirm_payment','Payment was confirmed (amount $40.00) by %user_name%',0,7,NULL,'2024-03-11 00:14:23','2024-03-11 00:14:23'),(27,'create_shipment','Created shipment for order',0,7,NULL,'2024-03-11 00:14:23','2024-03-11 00:14:23'),(28,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,7,NULL,'2024-03-11 00:14:23','2024-03-11 00:14:23'),(29,'create_order_from_seeder','Order is created from the checkout page',NULL,8,NULL,'2024-02-27 06:14:23','2024-02-27 06:14:23'),(30,'confirm_order','Order was verified by %user_name%',0,8,NULL,'2024-02-27 06:14:23','2024-02-27 06:14:23'),(31,'confirm_payment','Payment was confirmed (amount $2,020.00) by %user_name%',0,8,NULL,'2024-03-11 00:14:23','2024-03-11 00:14:23'),(32,'update_status','Changed status of shipping to: . Updated by: %user_name%',0,8,NULL,'2024-03-11 00:14:23','2024-03-11 00:14:23'),(33,'create_order_from_seeder','Order is created from the checkout page',NULL,9,NULL,'2024-03-08 08:14:23','2024-03-08 08:14:23'),(34,'confirm_order','Order was verified by %user_name%',0,9,NULL,'2024-03-08 08:14:23','2024-03-08 08:14:23'),(35,'create_shipment','Created shipment for order',0,9,NULL,'2024-03-11 00:14:23','2024-03-11 00:14:23'),(36,'create_order_from_seeder','Order is created from the checkout page',NULL,10,NULL,'2024-03-05 16:14:23','2024-03-05 16:14:23'),(37,'confirm_order','Order was verified by %user_name%',0,10,NULL,'2024-03-05 16:14:23','2024-03-05 16:14:23'),(38,'confirm_payment','Payment was confirmed (amount $5,836.00) by %user_name%',0,10,NULL,'2024-03-11 00:14:23','2024-03-11 00:14:23'),(39,'create_shipment','Created shipment for order',0,10,NULL,'2024-03-11 00:14:23','2024-03-11 00:14:23'),(40,'create_order_from_seeder','Order is created from the checkout page',NULL,11,NULL,'2024-02-28 18:14:23','2024-02-28 18:14:23'),(41,'confirm_order','Order was verified by %user_name%',0,11,NULL,'2024-02-28 18:14:23','2024-02-28 18:14:23'),(42,'confirm_payment','Payment was confirmed (amount $2,538.75) by %user_name%',0,11,NULL,'2024-03-11 00:14:23','2024-03-11 00:14:23'),(43,'create_shipment','Created shipment for order',0,11,NULL,'2024-03-11 00:14:23','2024-03-11 00:14:23'),(44,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,11,NULL,'2024-03-11 00:14:24','2024-03-11 00:14:24'),(45,'create_order_from_seeder','Order is created from the checkout page',NULL,12,NULL,'2024-03-02 06:14:24','2024-03-02 06:14:24'),(46,'confirm_order','Order was verified by %user_name%',0,12,NULL,'2024-03-02 06:14:24','2024-03-02 06:14:24'),(47,'create_order_from_seeder','Order is created from the checkout page',NULL,13,NULL,'2024-03-01 16:14:24','2024-03-01 16:14:24'),(48,'confirm_order','Order was verified by %user_name%',0,13,NULL,'2024-03-01 16:14:24','2024-03-01 16:14:24'),(49,'confirm_payment','Payment was confirmed (amount $659.50) by %user_name%',0,13,NULL,'2024-03-11 00:14:24','2024-03-11 00:14:24'),(50,'create_shipment','Created shipment for order',0,13,NULL,'2024-03-11 00:14:24','2024-03-11 00:14:24'),(51,'create_order_from_seeder','Order is created from the checkout page',NULL,14,NULL,'2024-03-08 16:14:24','2024-03-08 16:14:24'),(52,'confirm_order','Order was verified by %user_name%',0,14,NULL,'2024-03-08 16:14:24','2024-03-08 16:14:24'),(53,'confirm_payment','Payment was confirmed (amount $2,232.00) by %user_name%',0,14,NULL,'2024-03-11 00:14:24','2024-03-11 00:14:24'),(54,'update_status','Changed status of shipping to: . Updated by: %user_name%',0,14,NULL,'2024-03-11 00:14:24','2024-03-11 00:14:24'),(55,'create_order_from_seeder','Order is created from the checkout page',NULL,15,NULL,'2024-03-01 16:14:24','2024-03-01 16:14:24'),(56,'confirm_order','Order was verified by %user_name%',0,15,NULL,'2024-03-01 16:14:24','2024-03-01 16:14:24'),(57,'confirm_payment','Payment was confirmed (amount $936.00) by %user_name%',0,15,NULL,'2024-03-11 00:14:24','2024-03-11 00:14:24'),(58,'create_shipment','Created shipment for order',0,15,NULL,'2024-03-11 00:14:24','2024-03-11 00:14:24'),(59,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,15,NULL,'2024-03-11 00:14:24','2024-03-11 00:14:24'),(60,'create_order_from_seeder','Order is created from the checkout page',NULL,16,NULL,'2024-03-01 06:14:24','2024-03-01 06:14:24'),(61,'confirm_order','Order was verified by %user_name%',0,16,NULL,'2024-03-01 06:14:24','2024-03-01 06:14:24'),(62,'create_shipment','Created shipment for order',0,16,NULL,'2024-03-11 00:14:24','2024-03-11 00:14:24'),(63,'create_order_from_seeder','Order is created from the checkout page',NULL,17,NULL,'2024-03-03 10:14:24','2024-03-03 10:14:24'),(64,'confirm_order','Order was verified by %user_name%',0,17,NULL,'2024-03-03 10:14:24','2024-03-03 10:14:24'),(65,'confirm_payment','Payment was confirmed (amount $404.00) by %user_name%',0,17,NULL,'2024-03-11 00:14:24','2024-03-11 00:14:24'),(66,'create_shipment','Created shipment for order',0,17,NULL,'2024-03-11 00:14:25','2024-03-11 00:14:25'),(67,'create_order_from_seeder','Order is created from the checkout page',NULL,18,NULL,'2024-03-02 08:14:25','2024-03-02 08:14:25'),(68,'confirm_order','Order was verified by %user_name%',0,18,NULL,'2024-03-02 08:14:25','2024-03-02 08:14:25'),(69,'create_order_from_seeder','Order is created from the checkout page',NULL,19,NULL,'2024-03-10 00:14:25','2024-03-10 00:14:25'),(70,'confirm_order','Order was verified by %user_name%',0,19,NULL,'2024-03-10 00:14:25','2024-03-10 00:14:25'),(71,'confirm_payment','Payment was confirmed (amount $4,796.00) by %user_name%',0,19,NULL,'2024-03-11 00:14:25','2024-03-11 00:14:25'),(72,'create_shipment','Created shipment for order',0,19,NULL,'2024-03-11 00:14:25','2024-03-11 00:14:25'),(73,'create_order_from_seeder','Order is created from the checkout page',NULL,20,NULL,'2024-03-07 00:14:25','2024-03-07 00:14:25'),(74,'confirm_order','Order was verified by %user_name%',0,20,NULL,'2024-03-07 00:14:25','2024-03-07 00:14:25'),(75,'confirm_payment','Payment was confirmed (amount $1,008.00) by %user_name%',0,20,NULL,'2024-03-11 00:14:25','2024-03-11 00:14:25'),(76,'update_status','Changed status of shipping to: . Updated by: %user_name%',0,20,NULL,'2024-03-11 00:14:25','2024-03-11 00:14:25'),(77,'create_order_from_seeder','Order is created from the checkout page',NULL,21,NULL,'2024-03-05 12:14:25','2024-03-05 12:14:25'),(78,'confirm_order','Order was verified by %user_name%',0,21,NULL,'2024-03-05 12:14:25','2024-03-05 12:14:25'),(79,'create_shipment','Created shipment for order',0,21,NULL,'2024-03-11 00:14:25','2024-03-11 00:14:25'),(80,'create_order_from_seeder','Order is created from the checkout page',NULL,22,NULL,'2024-03-09 04:14:25','2024-03-09 04:14:25'),(81,'confirm_order','Order was verified by %user_name%',0,22,NULL,'2024-03-09 04:14:25','2024-03-09 04:14:25'),(82,'confirm_payment','Payment was confirmed (amount $3,833.00) by %user_name%',0,22,NULL,'2024-03-11 00:14:25','2024-03-11 00:14:25'),(83,'create_shipment','Created shipment for order',0,22,NULL,'2024-03-11 00:14:26','2024-03-11 00:14:26'),(84,'create_order_from_seeder','Order is created from the checkout page',NULL,23,NULL,'2024-03-05 12:14:26','2024-03-05 12:14:26'),(85,'confirm_order','Order was verified by %user_name%',0,23,NULL,'2024-03-05 12:14:26','2024-03-05 12:14:26'),(86,'create_shipment','Created shipment for order',0,23,NULL,'2024-03-11 00:14:26','2024-03-11 00:14:26'),(87,'create_order_from_seeder','Order is created from the checkout page',NULL,24,NULL,'2024-03-09 08:14:26','2024-03-09 08:14:26'),(88,'confirm_order','Order was verified by %user_name%',0,24,NULL,'2024-03-09 08:14:26','2024-03-09 08:14:26'),(89,'confirm_payment','Payment was confirmed (amount $5,206.00) by %user_name%',0,24,NULL,'2024-03-11 00:14:26','2024-03-11 00:14:26'),(90,'create_shipment','Created shipment for order',0,24,NULL,'2024-03-11 00:14:26','2024-03-11 00:14:26'),(91,'create_order_from_seeder','Order is created from the checkout page',NULL,25,NULL,'2024-03-09 12:14:26','2024-03-09 12:14:26'),(92,'confirm_order','Order was verified by %user_name%',0,25,NULL,'2024-03-09 12:14:26','2024-03-09 12:14:26'),(93,'confirm_payment','Payment was confirmed (amount $1,920.00) by %user_name%',0,25,NULL,'2024-03-11 00:14:26','2024-03-11 00:14:26'),(94,'create_shipment','Created shipment for order',0,25,NULL,'2024-03-11 00:14:26','2024-03-11 00:14:26'),(95,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,25,NULL,'2024-03-11 00:14:26','2024-03-11 00:14:26'),(96,'create_order_from_seeder','Order is created from the checkout page',NULL,26,NULL,'2024-03-08 00:14:26','2024-03-08 00:14:26'),(97,'confirm_order','Order was verified by %user_name%',0,26,NULL,'2024-03-08 00:14:26','2024-03-08 00:14:26'),(98,'confirm_payment','Payment was confirmed (amount $2,342.00) by %user_name%',0,26,NULL,'2024-03-11 00:14:26','2024-03-11 00:14:26'),(99,'create_shipment','Created shipment for order',0,26,NULL,'2024-03-11 00:14:26','2024-03-11 00:14:26'),(100,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,26,NULL,'2024-03-11 00:14:26','2024-03-11 00:14:26'),(101,'create_order_from_seeder','Order is created from the checkout page',NULL,27,NULL,'2024-03-08 00:14:26','2024-03-08 00:14:26'),(102,'confirm_order','Order was verified by %user_name%',0,27,NULL,'2024-03-08 00:14:26','2024-03-08 00:14:26'),(103,'confirm_payment','Payment was confirmed (amount $1,798.00) by %user_name%',0,27,NULL,'2024-03-11 00:14:26','2024-03-11 00:14:26'),(104,'create_shipment','Created shipment for order',0,27,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(105,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,27,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(106,'create_order_from_seeder','Order is created from the checkout page',NULL,28,NULL,'2024-03-07 16:14:27','2024-03-07 16:14:27'),(107,'confirm_order','Order was verified by %user_name%',0,28,NULL,'2024-03-07 16:14:27','2024-03-07 16:14:27'),(108,'confirm_payment','Payment was confirmed (amount $1,044.00) by %user_name%',0,28,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(109,'create_shipment','Created shipment for order',0,28,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(110,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,28,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(111,'create_order_from_seeder','Order is created from the checkout page',NULL,29,NULL,'2024-03-08 08:14:27','2024-03-08 08:14:27'),(112,'confirm_order','Order was verified by %user_name%',0,29,NULL,'2024-03-08 08:14:27','2024-03-08 08:14:27'),(113,'confirm_payment','Payment was confirmed (amount $1,266.00) by %user_name%',0,29,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(114,'create_shipment','Created shipment for order',0,29,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(115,'create_order_from_seeder','Order is created from the checkout page',NULL,30,NULL,'2024-03-05 16:14:27','2024-03-05 16:14:27'),(116,'confirm_order','Order was verified by %user_name%',0,30,NULL,'2024-03-05 16:14:27','2024-03-05 16:14:27'),(117,'confirm_payment','Payment was confirmed (amount $1,015.00) by %user_name%',0,30,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(118,'create_shipment','Created shipment for order',0,30,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(119,'create_order_from_seeder','Order is created from the checkout page',NULL,31,NULL,'2024-03-07 12:14:27','2024-03-07 12:14:27'),(120,'confirm_order','Order was verified by %user_name%',0,31,NULL,'2024-03-07 12:14:27','2024-03-07 12:14:27'),(121,'confirm_payment','Payment was confirmed (amount $1,212.00) by %user_name%',0,31,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(122,'create_shipment','Created shipment for order',0,31,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(123,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,31,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(124,'create_order_from_seeder','Order is created from the checkout page',NULL,32,NULL,'2024-03-10 10:14:27','2024-03-10 10:14:27'),(125,'confirm_order','Order was verified by %user_name%',0,32,NULL,'2024-03-10 10:14:27','2024-03-10 10:14:27'),(126,'confirm_payment','Payment was confirmed (amount $3,378.00) by %user_name%',0,32,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(127,'create_shipment','Created shipment for order',0,32,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(128,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,32,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(129,'create_order_from_seeder','Order is created from the checkout page',NULL,33,NULL,'2024-03-09 06:14:27','2024-03-09 06:14:27'),(130,'confirm_order','Order was verified by %user_name%',0,33,NULL,'2024-03-09 06:14:27','2024-03-09 06:14:27'),(131,'confirm_payment','Payment was confirmed (amount $1,560.00) by %user_name%',0,33,NULL,'2024-03-11 00:14:27','2024-03-11 00:14:27'),(132,'update_status','Changed status of shipping to: . Updated by: %user_name%',0,33,NULL,'2024-03-11 00:14:28','2024-03-11 00:14:28'),(133,'create_order_from_seeder','Order is created from the checkout page',NULL,34,NULL,'2024-03-06 12:14:28','2024-03-06 12:14:28'),(134,'confirm_order','Order was verified by %user_name%',0,34,NULL,'2024-03-06 12:14:28','2024-03-06 12:14:28'),(135,'confirm_payment','Payment was confirmed (amount $538.00) by %user_name%',0,34,NULL,'2024-03-11 00:14:28','2024-03-11 00:14:28'),(136,'update_status','Changed status of shipping to: . Updated by: %user_name%',0,34,NULL,'2024-03-11 00:14:28','2024-03-11 00:14:28'),(137,'create_order_from_seeder','Order is created from the checkout page',NULL,35,NULL,'2024-03-09 12:14:28','2024-03-09 12:14:28'),(138,'confirm_order','Order was verified by %user_name%',0,35,NULL,'2024-03-09 12:14:28','2024-03-09 12:14:28'),(139,'confirm_payment','Payment was confirmed (amount $2,138.00) by %user_name%',0,35,NULL,'2024-03-11 00:14:28','2024-03-11 00:14:28'),(140,'create_shipment','Created shipment for order',0,35,NULL,'2024-03-11 00:14:28','2024-03-11 00:14:28'),(141,'create_order_from_seeder','Order is created from the checkout page',NULL,36,NULL,'2024-03-08 22:14:28','2024-03-08 22:14:28'),(142,'confirm_order','Order was verified by %user_name%',0,36,NULL,'2024-03-08 22:14:28','2024-03-08 22:14:28'),(143,'create_shipment','Created shipment for order',0,36,NULL,'2024-03-11 00:14:28','2024-03-11 00:14:28'),(144,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,36,NULL,'2024-03-11 00:14:28','2024-03-11 00:14:28'),(145,'create_order_from_seeder','Order is created from the checkout page',NULL,37,NULL,'2024-03-06 20:14:28','2024-03-06 20:14:28'),(146,'confirm_order','Order was verified by %user_name%',0,37,NULL,'2024-03-06 20:14:28','2024-03-06 20:14:28'),(147,'confirm_payment','Payment was confirmed (amount $1,688.00) by %user_name%',0,37,NULL,'2024-03-11 00:14:28','2024-03-11 00:14:28'),(148,'create_shipment','Created shipment for order',0,37,NULL,'2024-03-11 00:14:28','2024-03-11 00:14:28'),(149,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,37,NULL,'2024-03-11 00:14:28','2024-03-11 00:14:28'),(150,'create_order_from_seeder','Order is created from the checkout page',NULL,38,NULL,'2024-03-09 16:14:28','2024-03-09 16:14:28'),(151,'confirm_order','Order was verified by %user_name%',0,38,NULL,'2024-03-09 16:14:28','2024-03-09 16:14:28'),(152,'confirm_payment','Payment was confirmed (amount $1,080.00) by %user_name%',0,38,NULL,'2024-03-11 00:14:28','2024-03-11 00:14:28'),(153,'create_shipment','Created shipment for order',0,38,NULL,'2024-03-11 00:14:29','2024-03-11 00:14:29'),(154,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,38,NULL,'2024-03-11 00:14:29','2024-03-11 00:14:29'),(155,'create_order_from_seeder','Order is created from the checkout page',NULL,39,NULL,'2024-03-07 16:14:29','2024-03-07 16:14:29'),(156,'confirm_order','Order was verified by %user_name%',0,39,NULL,'2024-03-07 16:14:29','2024-03-07 16:14:29'),(157,'confirm_payment','Payment was confirmed (amount $3,502.00) by %user_name%',0,39,NULL,'2024-03-11 00:14:29','2024-03-11 00:14:29'),(158,'create_shipment','Created shipment for order',0,39,NULL,'2024-03-11 00:14:29','2024-03-11 00:14:29'),(159,'create_order_from_seeder','Order is created from the checkout page',NULL,40,NULL,'2024-03-10 00:14:29','2024-03-10 00:14:29'),(160,'confirm_order','Order was verified by %user_name%',0,40,NULL,'2024-03-10 00:14:29','2024-03-10 00:14:29'),(161,'confirm_payment','Payment was confirmed (amount $1,189.00) by %user_name%',0,40,NULL,'2024-03-11 00:14:29','2024-03-11 00:14:29'),(162,'create_shipment','Created shipment for order',0,40,NULL,'2024-03-11 00:14:29','2024-03-11 00:14:29'),(163,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,40,NULL,'2024-03-11 00:14:29','2024-03-11 00:14:29'),(164,'create_order_from_seeder','Order is created from the checkout page',NULL,41,NULL,'2024-03-09 12:14:29','2024-03-09 12:14:29'),(165,'confirm_order','Order was verified by %user_name%',0,41,NULL,'2024-03-09 12:14:29','2024-03-09 12:14:29'),(166,'confirm_payment','Payment was confirmed (amount $936.00) by %user_name%',0,41,NULL,'2024-03-11 00:14:29','2024-03-11 00:14:29'),(167,'create_shipment','Created shipment for order',0,41,NULL,'2024-03-11 00:14:29','2024-03-11 00:14:29'),(168,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,41,NULL,'2024-03-11 00:14:29','2024-03-11 00:14:29'),(169,'create_order_from_seeder','Order is created from the checkout page',NULL,42,NULL,'2024-03-09 16:14:29','2024-03-09 16:14:29'),(170,'confirm_order','Order was verified by %user_name%',0,42,NULL,'2024-03-09 16:14:29','2024-03-09 16:14:29'),(171,'confirm_payment','Payment was confirmed (amount $2,058.00) by %user_name%',0,42,NULL,'2024-03-11 00:14:29','2024-03-11 00:14:29'),(172,'create_shipment','Created shipment for order',0,42,NULL,'2024-03-11 00:14:29','2024-03-11 00:14:29'),(173,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,42,NULL,'2024-03-11 00:14:29','2024-03-11 00:14:29'),(174,'create_order_from_seeder','Order is created from the checkout page',NULL,43,NULL,'2024-03-10 08:14:29','2024-03-10 08:14:29'),(175,'confirm_order','Order was verified by %user_name%',0,43,NULL,'2024-03-10 08:14:29','2024-03-10 08:14:29'),(176,'confirm_payment','Payment was confirmed (amount $4,917.00) by %user_name%',0,43,NULL,'2024-03-11 00:14:29','2024-03-11 00:14:29'),(177,'create_shipment','Created shipment for order',0,43,NULL,'2024-03-11 00:14:30','2024-03-11 00:14:30'),(178,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,43,NULL,'2024-03-11 00:14:30','2024-03-11 00:14:30'),(179,'create_order_from_seeder','Order is created from the checkout page',NULL,44,NULL,'2024-03-10 18:14:30','2024-03-10 18:14:30'),(180,'confirm_order','Order was verified by %user_name%',0,44,NULL,'2024-03-10 18:14:30','2024-03-10 18:14:30'),(181,'confirm_payment','Payment was confirmed (amount $504.00) by %user_name%',0,44,NULL,'2024-03-11 00:14:30','2024-03-11 00:14:30'),(182,'update_status','Changed status of shipping to: . Updated by: %user_name%',0,44,NULL,'2024-03-11 00:14:30','2024-03-11 00:14:30'),(183,'create_order_from_seeder','Order is created from the checkout page',NULL,45,NULL,'2024-03-10 08:14:30','2024-03-10 08:14:30'),(184,'confirm_order','Order was verified by %user_name%',0,45,NULL,'2024-03-10 08:14:30','2024-03-10 08:14:30'),(185,'confirm_payment','Payment was confirmed (amount $899.00) by %user_name%',0,45,NULL,'2024-03-11 00:14:30','2024-03-11 00:14:30'),(186,'create_shipment','Created shipment for order',0,45,NULL,'2024-03-11 00:14:30','2024-03-11 00:14:30'),(187,'update_status','Order confirmed by %user_name%',0,4,NULL,'2024-03-11 00:14:30','2024-03-11 00:14:30'),(188,'update_status','Order confirmed by %user_name%',0,5,NULL,'2024-03-11 00:14:31','2024-03-11 00:14:31'),(189,'update_status','Order confirmed by %user_name%',0,7,NULL,'2024-03-11 00:14:31','2024-03-11 00:14:31'),(190,'update_status','Order confirmed by %user_name%',0,11,NULL,'2024-03-11 00:14:32','2024-03-11 00:14:32'),(191,'update_status','Order confirmed by %user_name%',0,15,NULL,'2024-03-11 00:14:32','2024-03-11 00:14:32'),(192,'update_status','Order confirmed by %user_name%',0,25,NULL,'2024-03-11 00:14:33','2024-03-11 00:14:33'),(193,'update_status','Order confirmed by %user_name%',0,26,NULL,'2024-03-11 00:14:33','2024-03-11 00:14:33'),(194,'update_status','Order confirmed by %user_name%',0,27,NULL,'2024-03-11 00:14:34','2024-03-11 00:14:34'),(195,'update_status','Order confirmed by %user_name%',0,28,NULL,'2024-03-11 00:14:35','2024-03-11 00:14:35'),(196,'update_status','Order confirmed by %user_name%',0,31,NULL,'2024-03-11 00:14:35','2024-03-11 00:14:35'),(197,'update_status','Order confirmed by %user_name%',0,32,NULL,'2024-03-11 00:14:36','2024-03-11 00:14:36'),(198,'update_status','Order confirmed by %user_name%',0,37,NULL,'2024-03-11 00:14:36','2024-03-11 00:14:36'),(199,'update_status','Order confirmed by %user_name%',0,38,NULL,'2024-03-11 00:14:37','2024-03-11 00:14:37'),(200,'update_status','Order confirmed by %user_name%',0,40,NULL,'2024-03-11 00:14:37','2024-03-11 00:14:37'),(201,'update_status','Order confirmed by %user_name%',0,41,NULL,'2024-03-11 00:14:38','2024-03-11 00:14:38'),(202,'update_status','Order confirmed by %user_name%',0,42,NULL,'2024-03-11 00:14:38','2024-03-11 00:14:38'),(203,'update_status','Order confirmed by %user_name%',0,43,NULL,'2024-03-11 00:14:39','2024-03-11 00:14:39');

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

CREATE TABLE `ec_order_product` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint 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` bigint unsigned DEFAULT NULL,
  `product_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_image` varchar(255) 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',
  `license_code` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_order_product` VALUES (1,1,2,1171.00,0.00,'{\"sku\":\"SW-190-A0-A1\",\"attributes\":\"(Color: Red, Size: XL)\"}',NULL,44,'Smart Televisions','products/8-1.jpg',1482.00,0,'2024-03-11 00:14:21','2024-03-11 00:14:21','physical',0,NULL),(2,1,1,1149.00,0.00,'{\"sku\":\"SW-170-A0-A4\",\"attributes\":\"(Size: L, Color: Brown)\"}',NULL,58,'Xbox One Wireless Controller Black Color','products/11.jpg',779.00,0,'2024-03-11 00:14:21','2024-03-11 00:14:21','physical',0,NULL),(3,1,3,422.00,0.00,'{\"sku\":\"SW-112-A0-A1\",\"attributes\":\"(Color: Black, Size: XXL)\"}',NULL,82,'Baxter Care Hair Kit For Bearded Mens','products/22-1.jpg',1710.00,0,'2024-03-11 00:14:21','2024-03-11 00:14:21','physical',0,NULL),(4,2,1,1199.00,0.00,'{\"sku\":\"SW-147-A0-A3\",\"attributes\":\"(Color: Green, Size: L)\"}',NULL,52,'Herschel Leather Duffle Bag In Brown Color','products/10.jpg',681.00,0,'2024-03-11 00:14:22','2024-03-11 00:14:22','physical',0,NULL),(5,3,1,744.00,0.00,'{\"sku\":\"SW-181-A0-A1\",\"attributes\":\"(Color: Blue, Size: L)\"}',NULL,33,'Smart Watch External (Digital)','products/5-1.jpg',601.00,0,'2024-03-11 00:14:22','2024-03-11 00:14:22','digital',4,NULL),(6,3,1,522.00,0.00,'{\"sku\":\"SW-163-A0-A4\",\"attributes\":\"(Size: M, Color: Brown)\"}',NULL,42,'Audio Equipment','products/7.jpg',583.00,0,'2024-03-11 00:14:22','2024-03-11 00:14:22','physical',0,NULL),(7,4,3,1171.00,0.00,'{\"sku\":\"SW-190-A0-A1\",\"attributes\":\"(Color: Red, Size: XL)\"}',NULL,44,'Smart Televisions','products/8-1.jpg',2223.00,0,'2024-03-11 00:14:22','2024-03-11 00:14:22','physical',0,NULL),(8,4,2,1149.00,0.00,'{\"sku\":\"SW-170-A0-A4\",\"attributes\":\"(Size: L, Color: Brown)\"}',NULL,58,'Xbox One Wireless Controller Black Color','products/11.jpg',1558.00,0,'2024-03-11 00:14:22','2024-03-11 00:14:22','physical',0,NULL),(9,5,2,1171.00,0.00,'{\"sku\":\"SW-190-A0-A2\",\"attributes\":\"(Size: L, Color: Brown)\"}',NULL,45,'Smart Televisions','products/8-2.jpg',1482.00,0,'2024-03-11 00:14:22','2024-03-11 00:14:22','physical',0,NULL),(10,5,2,1149.00,0.00,'{\"sku\":\"SW-170-A0-A4\",\"attributes\":\"(Size: L, Color: Brown)\"}',NULL,58,'Xbox One Wireless Controller Black Color','products/11.jpg',1558.00,0,'2024-03-11 00:14:22','2024-03-11 00:14:22','physical',0,NULL),(11,5,2,515.00,0.00,'{\"sku\":\"SW-199-A0-A2\",\"attributes\":\"(Color: Black, Size: XL)\"}',NULL,61,'EPSION Plaster Printer','products/12-2.jpg',1768.00,0,'2024-03-11 00:14:22','2024-03-11 00:14:22','physical',0,NULL),(12,6,3,538.00,0.00,'{\"sku\":\"SW-138-A0\",\"attributes\":\"(Color: Red, Size: XXL)\"}',NULL,46,'Samsung Smart Phone (Digital)','products/9.jpg',2661.00,0,'2024-03-11 00:14:22','2024-03-11 00:14:22','digital',5,NULL),(13,7,2,20.00,0.00,'{\"sku\":\"SW-146-A0-A1\",\"attributes\":\"(Size: L, Color: Black)\"}',NULL,29,'Beat Headphone','products/3.jpg',1228.00,0,'2024-03-11 00:14:23','2024-03-11 00:14:23','physical',0,NULL),(14,8,1,504.00,0.00,'{\"sku\":\"SW-156-A0\",\"attributes\":\"(Color: Blue, Size: XL)\"}',NULL,62,'Sound Intone I65 Earphone White Version (Digital)','products/13.jpg',660.00,0,'2024-03-11 00:14:23','2024-03-11 00:14:23','digital',2,NULL),(15,8,2,758.00,0.00,'{\"sku\":\"SW-115-A0-A1\",\"attributes\":\"(Size: L, Color: Brown)\"}',NULL,80,'MVMTH Classical Leather Watch In Black (Digital)','products/21-1.jpg',1520.00,0,'2024-03-11 00:14:23','2024-03-11 00:14:23','digital',7,NULL),(16,9,2,522.00,0.00,'{\"sku\":\"SW-163-A0-A1\",\"attributes\":\"(Color: Black, Size: XXL)\"}',NULL,39,'Audio Equipment','products/7.jpg',1166.00,0,'2024-03-11 00:14:23','2024-03-11 00:14:23','physical',0,NULL),(17,10,2,1199.00,0.00,'{\"sku\":\"SW-147-A0-A3\",\"attributes\":\"(Color: Green, Size: L)\"}',NULL,52,'Herschel Leather Duffle Bag In Brown Color','products/10.jpg',1362.00,0,'2024-03-11 00:14:23','2024-03-11 00:14:23','physical',0,NULL),(18,10,2,1199.00,0.00,'{\"sku\":\"SW-147-A0-A4\",\"attributes\":\"(Color: Green, Size: XXL)\"}',NULL,53,'Herschel Leather Duffle Bag In Brown Color','products/10.jpg',1362.00,0,'2024-03-11 00:14:23','2024-03-11 00:14:23','physical',0,NULL),(19,10,2,520.00,0.00,'{\"sku\":\"SW-123-A0\",\"attributes\":\"(Color: Green, Size: L)\"}',NULL,70,'Samsung Gear VR Virtual Reality Headset (Digital)','products/17.jpg',1118.00,0,'2024-03-11 00:14:23','2024-03-11 00:14:23','digital',9,NULL),(20,11,3,80.25,0.00,'{\"sku\":\"SW-107-A0\",\"attributes\":\"(Color: Blue, Size: XL)\"}',NULL,24,'Dual Camera 20MP (Digital)','products/1.jpg',1998.00,0,'2024-03-11 00:14:23','2024-03-11 00:14:23','digital',10,NULL),(21,11,2,1149.00,0.00,'{\"sku\":\"SW-170-A0\",\"attributes\":\"(Color: Green, Size: XL)\"}',NULL,54,'Xbox One Wireless Controller Black Color','products/11.jpg',1558.00,0,'2024-03-11 00:14:23','2024-03-11 00:14:23','physical',0,NULL),(22,12,2,520.00,0.00,'{\"sku\":\"SW-123-A0\",\"attributes\":\"(Color: Green, Size: L)\"}',NULL,70,'Samsung Gear VR Virtual Reality Headset (Digital)','products/17.jpg',1118.00,0,'2024-03-11 00:14:24','2024-03-11 00:14:24','digital',4,NULL),(23,13,3,40.50,0.00,'{\"sku\":\"SW-148-A0-A2\",\"attributes\":\"(Color: Blue, Size: XXL)\"}',NULL,27,'Smart Watches','products/2-2.jpg',1812.00,0,'2024-03-11 00:14:24','2024-03-11 00:14:24','physical',0,NULL),(24,13,1,538.00,0.00,'{\"sku\":\"SW-138-A0\",\"attributes\":\"(Color: Red, Size: XXL)\"}',NULL,46,'Samsung Smart Phone (Digital)','products/9.jpg',887.00,0,'2024-03-11 00:14:24','2024-03-11 00:14:24','digital',10,NULL),(25,14,3,744.00,0.00,'{\"sku\":\"SW-181-A0-A2\",\"attributes\":\"(Color: Green, Size: XXL)\"}',NULL,34,'Smart Watch External (Digital)','products/5-2.jpg',1803.00,0,'2024-03-11 00:14:24','2024-03-11 00:14:24','digital',0,NULL),(26,15,1,936.00,0.00,'{\"sku\":\"SW-111-A0-A1\",\"attributes\":\"(Size: M, Color: Black)\"}',NULL,73,'Aveeno Moisturizing Body Shower 450ml','products/18-1.jpg',556.00,0,'2024-03-11 00:14:24','2024-03-11 00:14:24','physical',0,NULL),(27,16,1,20.00,0.00,'{\"sku\":\"SW-146-A0-A2\",\"attributes\":\"(Color: Brown, Size: XXL)\"}',NULL,30,'Beat Headphone','products/3.jpg',614.00,0,'2024-03-11 00:14:24','2024-03-11 00:14:24','physical',0,NULL),(28,16,3,515.00,0.00,'{\"sku\":\"SW-199-A0-A2\",\"attributes\":\"(Color: Black, Size: XL)\"}',NULL,61,'EPSION Plaster Printer','products/12-2.jpg',2652.00,0,'2024-03-11 00:14:24','2024-03-11 00:14:24','physical',0,NULL),(29,17,1,404.00,0.00,'{\"sku\":\"SW-194-A0-A2\",\"attributes\":\"(Color: Red, Size: XL)\"}',NULL,37,'Nikon HD camera','products/6.jpg',712.00,0,'2024-03-11 00:14:24','2024-03-11 00:14:24','physical',0,NULL),(30,18,1,520.00,0.00,'{\"sku\":\"SW-123-A0-A1\",\"attributes\":\"(Size: S, Color: Brown)\"}',NULL,71,'Samsung Gear VR Virtual Reality Headset (Digital)','products/17-1.jpg',559.00,0,'2024-03-11 00:14:25','2024-03-11 00:14:25','digital',5,NULL),(31,19,2,1199.00,0.00,'{\"sku\":\"SW-147-A0-A1\",\"attributes\":\"(Color: Blue, Size: M)\"}',NULL,50,'Herschel Leather Duffle Bag In Brown Color','products/10-1.jpg',1362.00,0,'2024-03-11 00:14:25','2024-03-11 00:14:25','physical',0,NULL),(32,19,2,1199.00,0.00,'{\"sku\":\"SW-147-A0-A2\",\"attributes\":\"(Color: Green, Size: L)\"}',NULL,51,'Herschel Leather Duffle Bag In Brown Color','products/10-2.jpg',1362.00,0,'2024-03-11 00:14:25','2024-03-11 00:14:25','physical',0,NULL),(33,20,2,504.00,0.00,'{\"sku\":\"SW-156-A0\",\"attributes\":\"(Color: Blue, Size: XL)\"}',NULL,62,'Sound Intone I65 Earphone White Version (Digital)','products/13.jpg',1320.00,0,'2024-03-11 00:14:25','2024-03-11 00:14:25','digital',1,NULL),(34,21,1,1149.00,0.00,'{\"sku\":\"SW-170-A0\",\"attributes\":\"(Color: Green, Size: XL)\"}',NULL,54,'Xbox One Wireless Controller Black Color','products/11.jpg',779.00,0,'2024-03-11 00:14:25','2024-03-11 00:14:25','physical',0,NULL),(35,22,2,568.00,0.00,'{\"sku\":\"SW-109-A0\",\"attributes\":\"(Size: XL, Color: Brown)\"}',NULL,68,'Apple MacBook Air Retina 12-Inch Laptop','products/16.jpg',1374.00,0,'2024-03-11 00:14:25','2024-03-11 00:14:25','physical',0,NULL),(36,22,3,899.00,0.00,'{\"sku\":\"SW-113-A0\",\"attributes\":\"(Color: Blue, Size: M)\"}',NULL,76,'NYX Beauty Couton Pallete Makeup 12','products/20.jpg',1509.00,0,'2024-03-11 00:14:25','2024-03-11 00:14:25','physical',0,NULL),(37,23,3,936.00,0.00,'{\"sku\":\"SW-111-A0\",\"attributes\":\"(Size: L, Color: Brown)\"}',NULL,72,'Aveeno Moisturizing Body Shower 450ml','products/18.jpg',1668.00,0,'2024-03-11 00:14:26','2024-03-11 00:14:26','physical',0,NULL),(38,24,1,1199.00,0.00,'{\"sku\":\"SW-147-A0-A3\",\"attributes\":\"(Color: Green, Size: L)\"}',NULL,52,'Herschel Leather Duffle Bag In Brown Color','products/10.jpg',681.00,0,'2024-03-11 00:14:26','2024-03-11 00:14:26','physical',0,NULL),(39,24,1,1199.00,0.00,'{\"sku\":\"SW-147-A0-A4\",\"attributes\":\"(Color: Green, Size: XXL)\"}',NULL,53,'Herschel Leather Duffle Bag In Brown Color','products/10.jpg',681.00,0,'2024-03-11 00:14:26','2024-03-11 00:14:26','physical',0,NULL),(40,24,2,936.00,0.00,'{\"sku\":\"SW-111-A0-A1\",\"attributes\":\"(Size: M, Color: Black)\"}',NULL,73,'Aveeno Moisturizing Body Shower 450ml','products/18-1.jpg',1112.00,0,'2024-03-11 00:14:26','2024-03-11 00:14:26','physical',0,NULL),(41,24,1,936.00,0.00,'{\"sku\":\"SW-111-A0-A2\",\"attributes\":\"(Size: L, Color: Brown)\"}',NULL,74,'Aveeno Moisturizing Body Shower 450ml','products/18-2.jpg',556.00,0,'2024-03-11 00:14:26','2024-03-11 00:14:26','physical',0,NULL),(42,25,1,404.00,0.00,'{\"sku\":\"SW-194-A0-A2\",\"attributes\":\"(Color: Red, Size: XL)\"}',NULL,37,'Nikon HD camera','products/6.jpg',712.00,0,'2024-03-11 00:14:26','2024-03-11 00:14:26','physical',0,NULL),(43,25,2,758.00,0.00,'{\"sku\":\"SW-115-A0\",\"attributes\":\"(Size: L, Color: Black)\"}',NULL,79,'MVMTH Classical Leather Watch In Black (Digital)','products/21.jpg',1520.00,0,'2024-03-11 00:14:26','2024-03-11 00:14:26','digital',0,NULL),(44,26,2,1171.00,0.00,'{\"sku\":\"SW-190-A0-A2\",\"attributes\":\"(Size: L, Color: Brown)\"}',NULL,45,'Smart Televisions','products/8-2.jpg',1482.00,0,'2024-03-11 00:14:26','2024-03-11 00:14:26','physical',0,NULL),(45,27,2,899.00,0.00,'{\"sku\":\"SW-113-A0-A2\",\"attributes\":\"(Size: M, Color: Black)\"}',NULL,78,'NYX Beauty Couton Pallete Makeup 12','products/20-2.jpg',1006.00,0,'2024-03-11 00:14:26','2024-03-11 00:14:26','physical',0,NULL),(46,28,2,522.00,0.00,'{\"sku\":\"SW-163-A0-A2\",\"attributes\":\"(Color: Red, Size: XL)\"}',NULL,40,'Audio Equipment','products/7.jpg',1166.00,0,'2024-03-11 00:14:27','2024-03-11 00:14:27','physical',0,NULL),(47,29,3,422.00,0.00,'{\"sku\":\"SW-112-A0-A2\",\"attributes\":\"(Size: L, Color: Brown)\"}',NULL,83,'Baxter Care Hair Kit For Bearded Mens','products/22-2.jpg',1710.00,0,'2024-03-11 00:14:27','2024-03-11 00:14:27','physical',0,NULL),(48,30,1,1015.00,0.00,'{\"sku\":\"SW-193-A0\",\"attributes\":\"(Color: Blue, Size: L)\"}',NULL,84,'Ciate Palemore Lipstick Bold Red Color','products/23.jpg',701.00,0,'2024-03-11 00:14:27','2024-03-11 00:14:27','physical',0,NULL),(49,31,3,404.00,0.00,'{\"sku\":\"SW-194-A0-A2\",\"attributes\":\"(Color: Red, Size: XL)\"}',NULL,37,'Nikon HD camera','products/6.jpg',2136.00,0,'2024-03-11 00:14:27','2024-03-11 00:14:27','physical',0,NULL),(50,32,2,1149.00,0.00,'{\"sku\":\"SW-170-A0\",\"attributes\":\"(Color: Green, Size: XL)\"}',NULL,54,'Xbox One Wireless Controller Black Color','products/11.jpg',1558.00,0,'2024-03-11 00:14:27','2024-03-11 00:14:27','physical',0,NULL),(51,32,2,540.00,0.00,'{\"sku\":\"SW-129-A0\",\"attributes\":\"(Color: Green, Size: XXL)\"}',NULL,64,'B&O Play Mini Bluetooth Speaker','products/14.jpg',1104.00,0,'2024-03-11 00:14:27','2024-03-11 00:14:27','physical',0,NULL),(52,33,3,520.00,0.00,'{\"sku\":\"SW-123-A0\",\"attributes\":\"(Color: Green, Size: L)\"}',NULL,70,'Samsung Gear VR Virtual Reality Headset (Digital)','products/17.jpg',1677.00,0,'2024-03-11 00:14:27','2024-03-11 00:14:27','digital',5,NULL),(53,34,1,538.00,0.00,'{\"sku\":\"SW-138-A0-A2\",\"attributes\":\"(Size: M, Color: Black)\"}',NULL,48,'Samsung Smart Phone (Digital)','products/9-2.jpg',887.00,0,'2024-03-11 00:14:28','2024-03-11 00:14:28','digital',0,NULL),(54,35,2,1069.00,0.00,'{\"sku\":\"SW-131-A0\",\"attributes\":\"(Color: Green, Size: S)\"}',NULL,75,'NYX Beauty Couton Pallete Makeup 12','products/19.jpg',1788.00,0,'2024-03-11 00:14:28','2024-03-11 00:14:28','physical',0,NULL),(55,36,3,522.00,0.00,'{\"sku\":\"SW-163-A0-A2\",\"attributes\":\"(Color: Red, Size: XL)\"}',NULL,40,'Audio Equipment','products/7.jpg',1749.00,0,'2024-03-11 00:14:28','2024-03-11 00:14:28','physical',0,NULL),(56,36,2,568.00,0.00,'{\"sku\":\"SW-109-A0-A1\",\"attributes\":\"(Size: M, Color: Brown)\"}',NULL,69,'Apple MacBook Air Retina 12-Inch Laptop','products/16.jpg',1374.00,0,'2024-03-11 00:14:28','2024-03-11 00:14:28','physical',0,NULL),(57,37,2,422.00,0.00,'{\"sku\":\"SW-112-A0\",\"attributes\":\"(Color: Green, Size: M)\"}',NULL,81,'Baxter Care Hair Kit For Bearded Mens','products/22.jpg',1140.00,0,'2024-03-11 00:14:28','2024-03-11 00:14:28','physical',0,NULL),(58,37,2,422.00,0.00,'{\"sku\":\"SW-112-A0-A2\",\"attributes\":\"(Size: L, Color: Brown)\"}',NULL,83,'Baxter Care Hair Kit For Bearded Mens','products/22-2.jpg',1140.00,0,'2024-03-11 00:14:28','2024-03-11 00:14:28','physical',0,NULL),(59,38,1,540.00,0.00,'{\"sku\":\"SW-129-A0\",\"attributes\":\"(Color: Green, Size: XXL)\"}',NULL,64,'B&O Play Mini Bluetooth Speaker','products/14.jpg',552.00,0,'2024-03-11 00:14:28','2024-03-11 00:14:28','physical',0,NULL),(60,38,1,540.00,0.00,'{\"sku\":\"SW-129-A0-A1\",\"attributes\":\"(Color: Black, Size: XXL)\"}',NULL,65,'B&O Play Mini Bluetooth Speaker','products/14.jpg',552.00,0,'2024-03-11 00:14:28','2024-03-11 00:14:28','physical',0,NULL),(61,39,3,568.00,0.00,'{\"sku\":\"SW-109-A0-A1\",\"attributes\":\"(Size: M, Color: Brown)\"}',NULL,69,'Apple MacBook Air Retina 12-Inch Laptop','products/16.jpg',2061.00,0,'2024-03-11 00:14:29','2024-03-11 00:14:29','physical',0,NULL),(62,39,2,899.00,0.00,'{\"sku\":\"SW-113-A0-A2\",\"attributes\":\"(Size: M, Color: Black)\"}',NULL,78,'NYX Beauty Couton Pallete Makeup 12','products/20-2.jpg',1006.00,0,'2024-03-11 00:14:29','2024-03-11 00:14:29','physical',0,NULL),(63,40,2,20.00,0.00,'{\"sku\":\"SW-146-A0-A2\",\"attributes\":\"(Color: Brown, Size: XXL)\"}',NULL,30,'Beat Headphone','products/3.jpg',1228.00,0,'2024-03-11 00:14:29','2024-03-11 00:14:29','physical',0,NULL),(64,40,1,1149.00,0.00,'{\"sku\":\"SW-170-A0\",\"attributes\":\"(Color: Green, Size: XL)\"}',NULL,54,'Xbox One Wireless Controller Black Color','products/11.jpg',779.00,0,'2024-03-11 00:14:29','2024-03-11 00:14:29','physical',0,NULL),(65,41,1,936.00,0.00,'{\"sku\":\"SW-111-A0\",\"attributes\":\"(Size: L, Color: Brown)\"}',NULL,72,'Aveeno Moisturizing Body Shower 450ml','products/18.jpg',556.00,0,'2024-03-11 00:14:29','2024-03-11 00:14:29','physical',0,NULL),(66,42,1,542.00,0.00,'{\"sku\":\"SW-109-A0\",\"attributes\":\"(Color: Blue, Size: XL)\"}',NULL,31,'Red & Black Headphone','products/4.jpg',747.00,0,'2024-03-11 00:14:29','2024-03-11 00:14:29','physical',0,NULL),(67,42,2,758.00,0.00,'{\"sku\":\"SW-115-A0\",\"attributes\":\"(Size: L, Color: Black)\"}',NULL,79,'MVMTH Classical Leather Watch In Black (Digital)','products/21.jpg',1520.00,0,'2024-03-11 00:14:29','2024-03-11 00:14:29','digital',4,NULL),(68,43,2,936.00,0.00,'{\"sku\":\"SW-111-A0-A1\",\"attributes\":\"(Size: M, Color: Black)\"}',NULL,73,'Aveeno Moisturizing Body Shower 450ml','products/18-1.jpg',1112.00,0,'2024-03-11 00:14:29','2024-03-11 00:14:29','physical',0,NULL),(69,43,3,1015.00,0.00,'{\"sku\":\"SW-193-A0-A1\",\"attributes\":\"(Size: M, Color: Brown)\"}',NULL,85,'Ciate Palemore Lipstick Bold Red Color','products/23-1.jpg',2103.00,0,'2024-03-11 00:14:29','2024-03-11 00:14:29','physical',0,NULL),(70,44,1,504.00,0.00,'{\"sku\":\"SW-156-A0-A1\",\"attributes\":\"(Color: Black, Size: XXL)\"}',NULL,63,'Sound Intone I65 Earphone White Version (Digital)','products/13-1.jpg',660.00,0,'2024-03-11 00:14:30','2024-03-11 00:14:30','digital',7,NULL),(71,45,1,899.00,0.00,'{\"sku\":\"SW-113-A0\",\"attributes\":\"(Color: Blue, Size: M)\"}',NULL,76,'NYX Beauty Couton Pallete Makeup 12','products/20.jpg',503.00,0,'2024-03-11 00:14:30','2024-03-11 00:14:30','physical',0,NULL);

--
-- 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` bigint unsigned 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` bigint unsigned NOT NULL COMMENT 'Order return id',
  `order_product_id` bigint unsigned NOT NULL COMMENT 'Order product id',
  `product_id` bigint unsigned NOT NULL COMMENT 'Product id',
  `product_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_image` varchar(255) 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,
  `refund_amount` decimal(12,2) DEFAULT '0.00',
  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(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_id` bigint unsigned NOT NULL COMMENT 'Order ID',
  `store_id` bigint unsigned DEFAULT NULL COMMENT 'Store ID',
  `user_id` bigint unsigned NOT NULL COMMENT 'Customer ID',
  `reason` text COLLATE utf8mb4_unicode_ci COMMENT 'Reason return order',
  `order_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Order current status',
  `return_status` varchar(255) 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_order_tax_information`
--

CREATE TABLE `ec_order_tax_information` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `company_name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_tax_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_email` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_order_tax_information_order_id_index` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_order_tax_information`
--


--
-- 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(255) 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,'2024-03-11 00:14:13','2024-03-11 00:14:13',0),(2,'Size','size','text',1,1,1,'published',1,'2024-03-11 00:14:13','2024-03-11 00:14:13',0);

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

CREATE TABLE `ec_product_attribute_sets_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_attribute_sets_id` bigint unsigned NOT NULL,
  `title` varchar(255) 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`
--


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

CREATE TABLE `ec_product_attributes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `attribute_set_id` bigint 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(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `order` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attribute_set_status_index` (`attribute_set_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_product_attributes` VALUES (1,1,'Green','green','#5FB7D4',NULL,1,1,'2024-03-11 00:14:13','2024-03-11 00:14:13'),(2,1,'Blue','blue','#333333',NULL,0,2,'2024-03-11 00:14:13','2024-03-11 00:14:13'),(3,1,'Red','red','#DA323F',NULL,0,3,'2024-03-11 00:14:13','2024-03-11 00:14:13'),(4,1,'Black','black','#2F366C',NULL,0,4,'2024-03-11 00:14:13','2024-03-11 00:14:13'),(5,1,'Brown','brown','#87554B',NULL,0,5,'2024-03-11 00:14:13','2024-03-11 00:14:13'),(6,2,'S','s',NULL,NULL,1,1,'2024-03-11 00:14:13','2024-03-11 00:14:13'),(7,2,'M','m',NULL,NULL,0,2,'2024-03-11 00:14:13','2024-03-11 00:14:13'),(8,2,'L','l',NULL,NULL,0,3,'2024-03-11 00:14:13','2024-03-11 00:14:13'),(9,2,'XL','xl',NULL,NULL,0,4,'2024-03-11 00:14:13','2024-03-11 00:14:13'),(10,2,'XXL','xxl',NULL,NULL,0,5,'2024-03-11 00:14:13','2024-03-11 00:14:13');

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

CREATE TABLE `ec_product_attributes_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_attributes_id` bigint unsigned NOT NULL,
  `title` varchar(255) 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`
--


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

CREATE TABLE `ec_product_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` bigint 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,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_image` varchar(255) COLLATE utf8mb4_unicode_ci 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,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(2,'Electronics',0,NULL,'published',1,'product-categories/1.jpg',1,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(3,'Consumer Electronic',2,NULL,'published',0,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(4,'Home Audio & Theaters',3,NULL,'published',0,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(5,'TV & Videos',3,NULL,'published',1,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(6,'Camera, Photos & Videos',3,NULL,'published',2,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(7,'Cellphones & Accessories',3,NULL,'published',3,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(8,'Headphones',3,NULL,'published',4,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(9,'Videos games',3,NULL,'published',5,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(10,'Wireless Speakers',3,NULL,'published',6,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(11,'Office Electronic',3,NULL,'published',7,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(12,'Accessories & Parts',2,NULL,'published',1,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(13,'Digital Cables',12,NULL,'published',0,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(14,'Audio & Video Cables',12,NULL,'published',1,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(15,'Batteries',12,NULL,'published',2,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(16,'Clothing',0,NULL,'published',2,'product-categories/2.jpg',1,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(17,'Computers',0,NULL,'published',3,'product-categories/3.jpg',1,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(18,'Computer & Technologies',17,NULL,'published',0,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(19,'Computer & Tablets',18,NULL,'published',0,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(20,'Laptop',18,NULL,'published',1,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(21,'Monitors',18,NULL,'published',2,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(22,'Computer Components',18,NULL,'published',3,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(23,'Networking',17,NULL,'published',1,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(24,'Drive & Storages',23,NULL,'published',0,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(25,'Gaming Laptop',23,NULL,'published',1,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(26,'Security & Protection',23,NULL,'published',2,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(27,'Accessories',23,NULL,'published',3,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(28,'Home & Kitchen',0,NULL,'published',4,'product-categories/4.jpg',1,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(29,'Health & Beauty',0,NULL,'published',5,'product-categories/5.jpg',1,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(30,'Jewelry & Watch',0,NULL,'published',6,'product-categories/6.jpg',1,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(31,'Technology Toys',0,NULL,'published',7,'product-categories/7.jpg',1,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(32,'Phones',0,NULL,'published',8,'product-categories/8.jpg',1,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(33,'Babies & Moms',0,NULL,'published',9,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(34,'Sport & Outdoor',0,NULL,'published',10,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(35,'Books & Office',0,NULL,'published',11,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(36,'Cars & Motorcycles',0,NULL,'published',12,NULL,0,'2024-03-11 00:14:06','2024-03-11 00:14:06',NULL,NULL),(37,'Home Improvements',0,NULL,'published',13,NULL,0,'2024-03-11 00:14:07','2024-03-11 00:14:07',NULL,NULL);

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

CREATE TABLE `ec_product_categories_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_categories_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` mediumtext 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`
--


--
-- Table structure for table `ec_product_categorizables`
--

CREATE TABLE `ec_product_categorizables` (
  `category_id` bigint unsigned NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `reference_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`category_id`,`reference_id`,`reference_type`),
  KEY `ec_product_categorizables_category_id_index` (`category_id`),
  KEY `ec_product_categorizables_reference_id_index` (`reference_id`),
  KEY `ec_product_categorizables_reference_type_index` (`reference_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_categorizables`
--


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

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

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

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

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

CREATE TABLE `ec_product_collection_products` (
  `product_collection_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`product_id`,`product_collection_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 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,18),(1,19),(1,22),(2,5),(2,6),(2,7),(2,9),(2,11),(2,15),(2,17),(2,20),(3,1),(3,2),(3,4),(3,8),(3,10),(3,12),(3,13),(3,14),(3,16),(3,21),(3,23);

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

CREATE TABLE `ec_product_collections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) 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','2024-03-11 00:14:07','2024-03-11 00:14:07',0),(2,'Best Sellers','best-sellers',NULL,NULL,'published','2024-03-11 00:14:07','2024-03-11 00:14:07',0),(3,'Special Offer','special-offer',NULL,NULL,'published','2024-03-11 00:14:07','2024-03-11 00:14:07',0);

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

CREATE TABLE `ec_product_collections_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_collections_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) 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`
--


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

CREATE TABLE `ec_product_cross_sale_relations` (
  `from_product_id` bigint unsigned NOT NULL,
  `to_product_id` bigint unsigned NOT NULL,
  `is_variant` tinyint(1) NOT NULL DEFAULT '0',
  `price` decimal(15,2) DEFAULT '0.00',
  `price_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fixed',
  `apply_to_all_variations` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`from_product_id`,`to_product_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 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,2,0,0.00,'fixed',1),(1,4,0,0.00,'fixed',1),(1,5,0,0.00,'fixed',1),(1,7,0,0.00,'fixed',1),(1,12,0,0.00,'fixed',1),(1,13,0,0.00,'fixed',1),(1,20,0,0.00,'fixed',1),(2,8,0,0.00,'fixed',1),(2,10,0,0.00,'fixed',1),(2,16,0,0.00,'fixed',1),(2,17,0,0.00,'fixed',1),(2,19,0,0.00,'fixed',1),(3,7,0,0.00,'fixed',1),(3,10,0,0.00,'fixed',1),(3,11,0,0.00,'fixed',1),(3,14,0,0.00,'fixed',1),(3,15,0,0.00,'fixed',1),(3,17,0,0.00,'fixed',1),(4,2,0,0.00,'fixed',1),(4,3,0,0.00,'fixed',1),(4,8,0,0.00,'fixed',1),(4,10,0,0.00,'fixed',1),(4,12,0,0.00,'fixed',1),(4,15,0,0.00,'fixed',1),(5,2,0,0.00,'fixed',1),(5,8,0,0.00,'fixed',1),(5,9,0,0.00,'fixed',1),(5,10,0,0.00,'fixed',1),(5,11,0,0.00,'fixed',1),(5,13,0,0.00,'fixed',1),(6,7,0,0.00,'fixed',1),(6,9,0,0.00,'fixed',1),(6,13,0,0.00,'fixed',1),(6,14,0,0.00,'fixed',1),(6,15,0,0.00,'fixed',1),(6,20,0,0.00,'fixed',1),(7,2,0,0.00,'fixed',1),(7,4,0,0.00,'fixed',1),(7,5,0,0.00,'fixed',1),(7,10,0,0.00,'fixed',1),(7,11,0,0.00,'fixed',1),(7,19,0,0.00,'fixed',1),(8,1,0,0.00,'fixed',1),(8,4,0,0.00,'fixed',1),(8,9,0,0.00,'fixed',1),(8,12,0,0.00,'fixed',1),(8,13,0,0.00,'fixed',1),(8,17,0,0.00,'fixed',1),(9,1,0,0.00,'fixed',1),(9,6,0,0.00,'fixed',1),(9,8,0,0.00,'fixed',1),(9,10,0,0.00,'fixed',1),(9,13,0,0.00,'fixed',1),(9,18,0,0.00,'fixed',1),(10,4,0,0.00,'fixed',1),(10,5,0,0.00,'fixed',1),(10,6,0,0.00,'fixed',1),(10,8,0,0.00,'fixed',1),(10,11,0,0.00,'fixed',1),(10,14,0,0.00,'fixed',1),(10,17,0,0.00,'fixed',1),(11,5,0,0.00,'fixed',1),(11,6,0,0.00,'fixed',1),(11,7,0,0.00,'fixed',1),(11,15,0,0.00,'fixed',1),(11,16,0,0.00,'fixed',1),(11,20,0,0.00,'fixed',1),(12,1,0,0.00,'fixed',1),(12,3,0,0.00,'fixed',1),(12,10,0,0.00,'fixed',1),(12,18,0,0.00,'fixed',1),(12,19,0,0.00,'fixed',1),(13,3,0,0.00,'fixed',1),(13,9,0,0.00,'fixed',1),(13,11,0,0.00,'fixed',1),(13,15,0,0.00,'fixed',1),(13,17,0,0.00,'fixed',1),(13,18,0,0.00,'fixed',1),(14,4,0,0.00,'fixed',1),(14,5,0,0.00,'fixed',1),(14,6,0,0.00,'fixed',1),(14,8,0,0.00,'fixed',1),(14,19,0,0.00,'fixed',1),(14,20,0,0.00,'fixed',1),(15,4,0,0.00,'fixed',1),(15,8,0,0.00,'fixed',1),(15,10,0,0.00,'fixed',1),(15,13,0,0.00,'fixed',1),(15,16,0,0.00,'fixed',1),(15,18,0,0.00,'fixed',1),(16,5,0,0.00,'fixed',1),(16,6,0,0.00,'fixed',1),(16,8,0,0.00,'fixed',1),(16,14,0,0.00,'fixed',1),(16,15,0,0.00,'fixed',1),(16,18,0,0.00,'fixed',1),(16,19,0,0.00,'fixed',1),(17,1,0,0.00,'fixed',1),(17,3,0,0.00,'fixed',1),(17,6,0,0.00,'fixed',1),(17,7,0,0.00,'fixed',1),(17,9,0,0.00,'fixed',1),(17,14,0,0.00,'fixed',1),(17,18,0,0.00,'fixed',1),(18,1,0,0.00,'fixed',1),(18,6,0,0.00,'fixed',1),(18,11,0,0.00,'fixed',1),(18,13,0,0.00,'fixed',1),(18,19,0,0.00,'fixed',1),(19,4,0,0.00,'fixed',1),(19,6,0,0.00,'fixed',1),(19,14,0,0.00,'fixed',1),(19,15,0,0.00,'fixed',1),(19,16,0,0.00,'fixed',1),(19,17,0,0.00,'fixed',1),(20,11,0,0.00,'fixed',1),(20,12,0,0.00,'fixed',1),(20,13,0,0.00,'fixed',1),(20,15,0,0.00,'fixed',1),(20,17,0,0.00,'fixed',1),(20,18,0,0.00,'fixed',1),(21,2,0,0.00,'fixed',1),(21,5,0,0.00,'fixed',1),(21,7,0,0.00,'fixed',1),(21,14,0,0.00,'fixed',1),(21,17,0,0.00,'fixed',1),(21,18,0,0.00,'fixed',1),(21,19,0,0.00,'fixed',1),(22,2,0,0.00,'fixed',1),(22,13,0,0.00,'fixed',1),(22,14,0,0.00,'fixed',1),(22,15,0,0.00,'fixed',1),(22,16,0,0.00,'fixed',1),(22,17,0,0.00,'fixed',1),(23,5,0,0.00,'fixed',1),(23,8,0,0.00,'fixed',1),(23,12,0,0.00,'fixed',1),(23,13,0,0.00,'fixed',1),(23,18,0,0.00,'fixed',1),(23,19,0,0.00,'fixed',1);

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

CREATE TABLE `ec_product_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned 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=41 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\":9730,\"modified\":\"2024-03-11 07:14:11\",\"name\":\"1\",\"extension\":\"jpg\"}','2024-03-11 00:14:11','2024-03-11 00:14:11'),(2,32,'product-files/5.jpg','{\"filename\":\"5.jpg\",\"url\":\"product-files\\/5.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:11\",\"name\":\"5\",\"extension\":\"jpg\"}','2024-03-11 00:14:11','2024-03-11 00:14:11'),(3,32,'product-files/5-1.jpg','{\"filename\":\"5-1.jpg\",\"url\":\"product-files\\/5-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:11\",\"name\":\"5-1\",\"extension\":\"jpg\"}','2024-03-11 00:14:11','2024-03-11 00:14:11'),(4,32,'product-files/5-2.jpg','{\"filename\":\"5-2.jpg\",\"url\":\"product-files\\/5-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:11\",\"name\":\"5-2\",\"extension\":\"jpg\"}','2024-03-11 00:14:11','2024-03-11 00:14:11'),(5,32,'product-files/5-3.jpg','{\"filename\":\"5-3.jpg\",\"url\":\"product-files\\/5-3.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:11\",\"name\":\"5-3\",\"extension\":\"jpg\"}','2024-03-11 00:14:11','2024-03-11 00:14:11'),(6,33,'product-files/5.jpg','{\"filename\":\"5.jpg\",\"url\":\"product-files\\/5.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"5\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(7,33,'product-files/5-1.jpg','{\"filename\":\"5-1.jpg\",\"url\":\"product-files\\/5-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"5-1\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(8,33,'product-files/5-2.jpg','{\"filename\":\"5-2.jpg\",\"url\":\"product-files\\/5-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"5-2\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(9,33,'product-files/5-3.jpg','{\"filename\":\"5-3.jpg\",\"url\":\"product-files\\/5-3.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"5-3\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(10,34,'product-files/5.jpg','{\"filename\":\"5.jpg\",\"url\":\"product-files\\/5.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"5\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(11,34,'product-files/5-1.jpg','{\"filename\":\"5-1.jpg\",\"url\":\"product-files\\/5-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"5-1\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(12,34,'product-files/5-2.jpg','{\"filename\":\"5-2.jpg\",\"url\":\"product-files\\/5-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"5-2\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(13,34,'product-files/5-3.jpg','{\"filename\":\"5-3.jpg\",\"url\":\"product-files\\/5-3.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"5-3\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(14,46,'product-files/9.jpg','{\"filename\":\"9.jpg\",\"url\":\"product-files\\/9.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"9\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(15,46,'product-files/9-1.jpg','{\"filename\":\"9-1.jpg\",\"url\":\"product-files\\/9-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"9-1\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(16,46,'product-files/9-2.jpg','{\"filename\":\"9-2.jpg\",\"url\":\"product-files\\/9-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"9-2\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(17,47,'product-files/9.jpg','{\"filename\":\"9.jpg\",\"url\":\"product-files\\/9.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"9\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(18,47,'product-files/9-1.jpg','{\"filename\":\"9-1.jpg\",\"url\":\"product-files\\/9-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"9-1\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(19,47,'product-files/9-2.jpg','{\"filename\":\"9-2.jpg\",\"url\":\"product-files\\/9-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"9-2\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(20,48,'product-files/9.jpg','{\"filename\":\"9.jpg\",\"url\":\"product-files\\/9.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"9\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(21,48,'product-files/9-1.jpg','{\"filename\":\"9-1.jpg\",\"url\":\"product-files\\/9-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"9-1\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(22,48,'product-files/9-2.jpg','{\"filename\":\"9-2.jpg\",\"url\":\"product-files\\/9-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"9-2\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(23,62,'product-files/13.jpg','{\"filename\":\"13.jpg\",\"url\":\"product-files\\/13.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"13\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(24,62,'product-files/13-1.jpg','{\"filename\":\"13-1.jpg\",\"url\":\"product-files\\/13-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"13-1\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(25,63,'product-files/13.jpg','{\"filename\":\"13.jpg\",\"url\":\"product-files\\/13.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"13\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(26,63,'product-files/13-1.jpg','{\"filename\":\"13-1.jpg\",\"url\":\"product-files\\/13-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"13-1\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(27,70,'product-files/17.jpg','{\"filename\":\"17.jpg\",\"url\":\"product-files\\/17.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"17\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(28,70,'product-files/17-1.jpg','{\"filename\":\"17-1.jpg\",\"url\":\"product-files\\/17-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"17-1\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(29,70,'product-files/17-2.jpg','{\"filename\":\"17-2.jpg\",\"url\":\"product-files\\/17-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"17-2\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(30,70,'product-files/17-3.jpg','{\"filename\":\"17-3.jpg\",\"url\":\"product-files\\/17-3.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"17-3\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(31,71,'product-files/17.jpg','{\"filename\":\"17.jpg\",\"url\":\"product-files\\/17.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"17\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(32,71,'product-files/17-1.jpg','{\"filename\":\"17-1.jpg\",\"url\":\"product-files\\/17-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"17-1\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(33,71,'product-files/17-2.jpg','{\"filename\":\"17-2.jpg\",\"url\":\"product-files\\/17-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"17-2\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(34,71,'product-files/17-3.jpg','{\"filename\":\"17-3.jpg\",\"url\":\"product-files\\/17-3.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:12\",\"name\":\"17-3\",\"extension\":\"jpg\"}','2024-03-11 00:14:12','2024-03-11 00:14:12'),(35,79,'product-files/21.jpg','{\"filename\":\"21.jpg\",\"url\":\"product-files\\/21.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:13\",\"name\":\"21\",\"extension\":\"jpg\"}','2024-03-11 00:14:13','2024-03-11 00:14:13'),(36,79,'product-files/21-1.jpg','{\"filename\":\"21-1.jpg\",\"url\":\"product-files\\/21-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:13\",\"name\":\"21-1\",\"extension\":\"jpg\"}','2024-03-11 00:14:13','2024-03-11 00:14:13'),(37,79,'product-files/21-2.jpg','{\"filename\":\"21-2.jpg\",\"url\":\"product-files\\/21-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:13\",\"name\":\"21-2\",\"extension\":\"jpg\"}','2024-03-11 00:14:13','2024-03-11 00:14:13'),(38,80,'product-files/21.jpg','{\"filename\":\"21.jpg\",\"url\":\"product-files\\/21.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:13\",\"name\":\"21\",\"extension\":\"jpg\"}','2024-03-11 00:14:13','2024-03-11 00:14:13'),(39,80,'product-files/21-1.jpg','{\"filename\":\"21-1.jpg\",\"url\":\"product-files\\/21-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:13\",\"name\":\"21-1\",\"extension\":\"jpg\"}','2024-03-11 00:14:13','2024-03-11 00:14:13'),(40,80,'product-files/21-2.jpg','{\"filename\":\"21-2.jpg\",\"url\":\"product-files\\/21-2.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-03-11 07:14:13\",\"name\":\"21-2\",\"extension\":\"jpg\"}','2024-03-11 00:14:13','2024-03-11 00:14:13');

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

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

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

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

--
-- 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','#d71e2d','published','2024-03-11 00:14:07','2024-03-11 00:14:07'),(2,'New','#02856e','published','2024-03-11 00:14:07','2024-03-11 00:14:07'),(3,'Sale','#fe9931','published','2024-03-11 00:14:07','2024-03-11 00:14:07');

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

CREATE TABLE `ec_product_labels_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_labels_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) 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`
--


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

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

--
-- 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','2024-03-11 00:14:16','2024-03-11 00:14:16'),(2,'Mobile',NULL,'published','2024-03-11 00:14:16','2024-03-11 00:14:16'),(3,'Iphone',NULL,'published','2024-03-11 00:14:16','2024-03-11 00:14:16'),(4,'Printer',NULL,'published','2024-03-11 00:14:16','2024-03-11 00:14:16'),(5,'Office',NULL,'published','2024-03-11 00:14:16','2024-03-11 00:14:16'),(6,'IT',NULL,'published','2024-03-11 00:14:16','2024-03-11 00:14:16');

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

CREATE TABLE `ec_product_tags_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_tags_id` bigint unsigned NOT NULL,
  `name` varchar(255) 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`
--


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

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

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

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

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

CREATE TABLE `ec_product_variations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned DEFAULT NULL,
  `configurable_product_id` bigint unsigned NOT NULL,
  `is_default` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_product_variations_product_id_configurable_product_id_unique` (`product_id`,`configurable_product_id`),
  KEY `configurable_product_index` (`product_id`,`configurable_product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 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,2,1),(3,26,2,0),(4,27,2,0),(5,28,3,1),(6,29,3,0),(7,30,3,0),(8,31,4,1),(9,32,5,1),(10,33,5,0),(11,34,5,0),(12,35,6,1),(13,36,6,0),(14,37,6,0),(15,38,7,1),(16,39,7,0),(17,40,7,0),(18,41,7,0),(19,42,7,0),(20,43,8,1),(21,44,8,0),(22,45,8,0),(23,46,9,1),(24,47,9,0),(25,48,9,0),(26,49,10,1),(27,50,10,0),(28,51,10,0),(29,52,10,0),(30,53,10,0),(31,54,11,1),(32,55,11,0),(33,56,11,0),(34,57,11,0),(35,58,11,0),(36,59,12,1),(37,60,12,0),(38,61,12,0),(39,62,13,1),(40,63,13,0),(41,64,14,1),(42,65,14,0),(43,66,15,1),(44,67,15,0),(45,68,16,1),(46,69,16,0),(47,70,17,1),(48,71,17,0),(49,72,18,1),(50,73,18,0),(51,74,18,0),(52,75,19,1),(53,76,20,1),(54,77,20,0),(55,78,20,0),(56,79,21,1),(57,80,21,0),(58,81,22,1),(59,82,22,0),(60,83,22,0),(61,84,23,1),(62,85,23,0);

--
-- Table structure for table `ec_product_views`
--

CREATE TABLE `ec_product_views` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned NOT NULL,
  `views` int NOT NULL DEFAULT '1',
  `date` date NOT NULL DEFAULT '2024-03-11',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_product_views_product_id_date_unique` (`product_id`,`date`),
  KEY `ec_product_views_product_id_index` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_views`
--


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

CREATE TABLE `ec_product_with_attribute_set` (
  `attribute_set_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  `order` tinyint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`product_id`,`attribute_set_id`)
) ENGINE=InnoDB 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,0),(2,1,0),(1,2,0),(2,2,0),(1,3,0),(2,3,0),(1,4,0),(2,4,0),(1,5,0),(2,5,0),(1,6,0),(2,6,0),(1,7,0),(2,7,0),(1,8,0),(2,8,0),(1,9,0),(2,9,0),(1,10,0),(2,10,0),(1,11,0),(2,11,0),(1,12,0),(2,12,0),(1,13,0),(2,13,0),(1,14,0),(2,14,0),(1,15,0),(2,15,0),(1,16,0),(2,16,0),(1,17,0),(2,17,0),(1,18,0),(2,18,0),(1,19,0),(2,19,0),(1,20,0),(2,20,0),(1,21,0),(2,21,0),(1,22,0),(2,22,0),(1,23,0),(2,23,0);

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

CREATE TABLE `ec_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) 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(255) 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` bigint 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` bigint unsigned DEFAULT NULL,
  `views` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `stock_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'in_stock',
  `created_by_id` bigint unsigned 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',
  `barcode` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cost_per_item` double DEFAULT NULL,
  `generate_license_code` tinyint(1) NOT NULL DEFAULT '0',
  `store_id` bigint unsigned DEFAULT NULL,
  `approved_by` bigint unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `ec_products_brand_id_status_is_variation_created_at_index` (`brand_id`,`status`,`is_variation`,`created_at`),
  KEY `sale_type_index` (`sale_type`),
  KEY `start_date_index` (`start_date`),
  KEY `end_date_index` (`end_date`),
  KEY `sale_price_index` (`sale_price`),
  KEY `is_variation_index` (`is_variation`),
  KEY `ec_products_sku_index` (`sku`)
) ENGINE=InnoDB AUTO_INCREMENT=86 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’ 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-107-A0',0,19,0,1,1,7,0,0,80.25,NULL,NULL,NULL,20.00,16.00,13.00,666.00,NULL,26140,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,4,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’ 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-148-A0',0,20,0,1,1,5,0,0,40.5,NULL,NULL,NULL,12.00,17.00,13.00,604.00,NULL,60865,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,1,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’ 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-146-A0',0,16,0,1,1,3,0,0,20,NULL,NULL,NULL,14.00,16.00,13.00,614.00,NULL,172153,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,4,0),(4,'Red &amp; 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’ 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-109-A0',0,10,0,1,1,4,0,0,542,406.5,NULL,NULL,15.00,17.00,16.00,747.00,NULL,153643,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,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’ 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-181-A0',0,19,0,1,1,5,0,0,744,NULL,NULL,NULL,12.00,11.00,13.00,601.00,NULL,17531,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,2,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’ 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-194-A0',0,18,0,1,1,6,0,0,404,NULL,NULL,NULL,20.00,14.00,19.00,712.00,NULL,198885,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,1,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’ 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-163-A0',0,13,0,1,1,2,0,0,522,NULL,NULL,NULL,18.00,16.00,20.00,583.00,NULL,140082,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,2,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’ 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-190-A0',0,15,0,1,1,4,0,0,1171,819.7,NULL,NULL,15.00,10.00,19.00,741.00,NULL,181485,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,4,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’ 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-138-A0',0,15,0,1,1,7,0,0,538,NULL,NULL,NULL,16.00,15.00,11.00,887.00,NULL,74496,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,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’ 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-147-A0',0,20,0,1,0,4,0,0,1199,NULL,NULL,NULL,18.00,13.00,16.00,681.00,NULL,3935,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,3,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’ 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-170-A0',0,11,0,1,0,7,0,0,1149,NULL,NULL,NULL,18.00,14.00,13.00,779.00,NULL,99742,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,4,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’ 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-199-A0',0,19,0,1,0,4,0,0,515,396.55,NULL,NULL,13.00,18.00,16.00,884.00,NULL,13726,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,4,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’ 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-156-A0',0,17,0,1,0,5,0,0,504,NULL,NULL,NULL,14.00,15.00,16.00,660.00,NULL,57596,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,1,0),(14,'B&amp;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’ 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-129-A0',0,11,0,1,0,2,0,0,540,NULL,NULL,NULL,18.00,16.00,15.00,552.00,NULL,176023,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,4,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’ 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-134-A0',0,10,0,1,0,1,0,0,520,NULL,NULL,NULL,17.00,14.00,11.00,614.00,NULL,163575,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,2,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’ 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-109-A0',0,16,0,1,0,7,0,0,568,443.04,NULL,NULL,12.00,12.00,17.00,687.00,NULL,2383,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,2,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’ 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-123-A0',0,17,0,1,0,2,0,0,520,NULL,NULL,NULL,12.00,15.00,20.00,559.00,NULL,178641,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,3,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’ 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-111-A0',0,12,0,1,0,1,0,0,936,NULL,NULL,NULL,13.00,20.00,11.00,556.00,NULL,102526,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,3,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’ 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-131-A0',0,14,0,1,0,7,0,0,1069,NULL,NULL,NULL,14.00,17.00,20.00,894.00,NULL,91353,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,2,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’ 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-113-A0',0,13,0,1,0,3,0,0,899,800.11,NULL,NULL,19.00,12.00,11.00,503.00,NULL,198515,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,2,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’ 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-115-A0',0,14,0,1,0,2,0,0,758,NULL,NULL,NULL,19.00,18.00,13.00,760.00,NULL,91166,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,1,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’ 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-112-A0',0,18,0,1,0,2,0,0,422,NULL,NULL,NULL,19.00,17.00,19.00,570.00,NULL,127234,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,4,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’ 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-193-A0',0,12,0,1,0,5,0,0,1015,NULL,NULL,NULL,18.00,19.00,17.00,701.00,NULL,145404,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,3,0),(24,'Dual Camera 20MP (Digital)',NULL,NULL,'published','[\"products\\/1.jpg\"]','SW-107-A0',0,19,0,1,0,7,1,0,80.25,NULL,NULL,NULL,20.00,16.00,13.00,666.00,NULL,0,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(25,'Smart Watches',NULL,NULL,'published','[\"products\\/2.jpg\"]','SW-148-A0',0,20,0,1,0,5,1,0,40.5,NULL,NULL,NULL,12.00,17.00,13.00,604.00,NULL,0,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(26,'Smart Watches',NULL,NULL,'published','[\"products\\/2-1.jpg\"]','SW-148-A0-A1',0,20,0,1,0,5,1,0,40.5,NULL,NULL,NULL,12.00,17.00,13.00,604.00,NULL,0,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(27,'Smart Watches',NULL,NULL,'published','[\"products\\/2-2.jpg\"]','SW-148-A0-A2',0,20,0,1,0,5,1,0,40.5,NULL,NULL,NULL,12.00,17.00,13.00,604.00,NULL,0,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(28,'Beat Headphone',NULL,NULL,'published','[\"products\\/3.jpg\"]','SW-146-A0',0,16,0,1,0,3,1,0,20,NULL,NULL,NULL,14.00,16.00,13.00,614.00,NULL,0,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(29,'Beat Headphone',NULL,NULL,'published','[\"products\\/3.jpg\"]','SW-146-A0-A1',0,16,0,1,0,3,1,0,20,NULL,NULL,NULL,14.00,16.00,13.00,614.00,NULL,0,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(30,'Beat Headphone',NULL,NULL,'published','[\"products\\/3.jpg\"]','SW-146-A0-A2',0,16,0,1,0,3,1,0,20,NULL,NULL,NULL,14.00,16.00,13.00,614.00,NULL,0,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(31,'Red & Black Headphone',NULL,NULL,'published','[\"products\\/4.jpg\"]','SW-109-A0',0,10,0,1,0,4,1,0,542,406.5,NULL,NULL,15.00,17.00,16.00,747.00,NULL,0,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(32,'Smart Watch External (Digital)',NULL,NULL,'published','[\"products\\/5.jpg\"]','SW-181-A0',0,19,0,1,0,5,1,0,744,NULL,NULL,NULL,12.00,11.00,13.00,601.00,NULL,0,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(33,'Smart Watch External (Digital)',NULL,NULL,'published','[\"products\\/5-1.jpg\"]','SW-181-A0-A1',0,19,0,1,0,5,1,0,744,NULL,NULL,NULL,12.00,11.00,13.00,601.00,NULL,0,'2024-03-11 00:14:11','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(34,'Smart Watch External (Digital)',NULL,NULL,'published','[\"products\\/5-2.jpg\"]','SW-181-A0-A2',0,19,0,1,0,5,1,0,744,NULL,NULL,NULL,12.00,11.00,13.00,601.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(35,'Nikon HD camera',NULL,NULL,'published','[\"products\\/6.jpg\"]','SW-194-A0',0,18,0,1,0,6,1,0,404,NULL,NULL,NULL,20.00,14.00,19.00,712.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(36,'Nikon HD camera',NULL,NULL,'published','[\"products\\/6.jpg\"]','SW-194-A0-A1',0,18,0,1,0,6,1,0,404,NULL,NULL,NULL,20.00,14.00,19.00,712.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(37,'Nikon HD camera',NULL,NULL,'published','[\"products\\/6.jpg\"]','SW-194-A0-A2',0,18,0,1,0,6,1,0,404,NULL,NULL,NULL,20.00,14.00,19.00,712.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(38,'Audio Equipment',NULL,NULL,'published','[\"products\\/7.jpg\"]','SW-163-A0',0,13,0,1,0,2,1,0,522,NULL,NULL,NULL,18.00,16.00,20.00,583.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(39,'Audio Equipment',NULL,NULL,'published','[\"products\\/7.jpg\"]','SW-163-A0-A1',0,13,0,1,0,2,1,0,522,NULL,NULL,NULL,18.00,16.00,20.00,583.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(40,'Audio Equipment',NULL,NULL,'published','[\"products\\/7.jpg\"]','SW-163-A0-A2',0,13,0,1,0,2,1,0,522,NULL,NULL,NULL,18.00,16.00,20.00,583.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(41,'Audio Equipment',NULL,NULL,'published','[\"products\\/7.jpg\"]','SW-163-A0-A3',0,13,0,1,0,2,1,0,522,NULL,NULL,NULL,18.00,16.00,20.00,583.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(42,'Audio Equipment',NULL,NULL,'published','[\"products\\/7.jpg\"]','SW-163-A0-A4',0,13,0,1,0,2,1,0,522,NULL,NULL,NULL,18.00,16.00,20.00,583.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(43,'Smart Televisions',NULL,NULL,'published','[\"products\\/8.jpg\"]','SW-190-A0',0,15,0,1,0,4,1,0,1171,819.7,NULL,NULL,15.00,10.00,19.00,741.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(44,'Smart Televisions',NULL,NULL,'published','[\"products\\/8-1.jpg\"]','SW-190-A0-A1',0,15,0,1,0,4,1,0,1171,960.22,NULL,NULL,15.00,10.00,19.00,741.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(45,'Smart Televisions',NULL,NULL,'published','[\"products\\/8-2.jpg\"]','SW-190-A0-A2',0,15,0,1,0,4,1,0,1171,1042.19,NULL,NULL,15.00,10.00,19.00,741.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(46,'Samsung Smart Phone (Digital)',NULL,NULL,'published','[\"products\\/9.jpg\"]','SW-138-A0',0,15,0,1,0,7,1,0,538,NULL,NULL,NULL,16.00,15.00,11.00,887.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(47,'Samsung Smart Phone (Digital)',NULL,NULL,'published','[\"products\\/9-1.jpg\"]','SW-138-A0-A1',0,15,0,1,0,7,1,0,538,NULL,NULL,NULL,16.00,15.00,11.00,887.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(48,'Samsung Smart Phone (Digital)',NULL,NULL,'published','[\"products\\/9-2.jpg\"]','SW-138-A0-A2',0,15,0,1,0,7,1,0,538,NULL,NULL,NULL,16.00,15.00,11.00,887.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(49,'Herschel Leather Duffle Bag In Brown Color',NULL,NULL,'published','[\"products\\/10.jpg\"]','SW-147-A0',0,20,0,1,0,4,1,0,1199,NULL,NULL,NULL,18.00,13.00,16.00,681.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(50,'Herschel Leather Duffle Bag In Brown Color',NULL,NULL,'published','[\"products\\/10-1.jpg\"]','SW-147-A0-A1',0,20,0,1,0,4,1,0,1199,NULL,NULL,NULL,18.00,13.00,16.00,681.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(51,'Herschel Leather Duffle Bag In Brown Color',NULL,NULL,'published','[\"products\\/10-2.jpg\"]','SW-147-A0-A2',0,20,0,1,0,4,1,0,1199,NULL,NULL,NULL,18.00,13.00,16.00,681.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(52,'Herschel Leather Duffle Bag In Brown Color',NULL,NULL,'published','[\"products\\/10.jpg\"]','SW-147-A0-A3',0,20,0,1,0,4,1,0,1199,NULL,NULL,NULL,18.00,13.00,16.00,681.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(53,'Herschel Leather Duffle Bag In Brown Color',NULL,NULL,'published','[\"products\\/10.jpg\"]','SW-147-A0-A4',0,20,0,1,0,4,1,0,1199,NULL,NULL,NULL,18.00,13.00,16.00,681.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(54,'Xbox One Wireless Controller Black Color',NULL,NULL,'published','[\"products\\/11.jpg\"]','SW-170-A0',0,11,0,1,0,7,1,0,1149,NULL,NULL,NULL,18.00,14.00,13.00,779.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(55,'Xbox One Wireless Controller Black Color',NULL,NULL,'published','[\"products\\/11-1.jpg\"]','SW-170-A0-A1',0,11,0,1,0,7,1,0,1149,NULL,NULL,NULL,18.00,14.00,13.00,779.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(56,'Xbox One Wireless Controller Black Color',NULL,NULL,'published','[\"products\\/11-2.jpg\"]','SW-170-A0-A2',0,11,0,1,0,7,1,0,1149,NULL,NULL,NULL,18.00,14.00,13.00,779.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(57,'Xbox One Wireless Controller Black Color',NULL,NULL,'published','[\"products\\/11-3.jpg\"]','SW-170-A0-A3',0,11,0,1,0,7,1,0,1149,NULL,NULL,NULL,18.00,14.00,13.00,779.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(58,'Xbox One Wireless Controller Black Color',NULL,NULL,'published','[\"products\\/11.jpg\"]','SW-170-A0-A4',0,11,0,1,0,7,1,0,1149,NULL,NULL,NULL,18.00,14.00,13.00,779.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(59,'EPSION Plaster Printer',NULL,NULL,'published','[\"products\\/12.jpg\"]','SW-199-A0',0,19,0,1,0,4,1,0,515,396.55,NULL,NULL,13.00,18.00,16.00,884.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(60,'EPSION Plaster Printer',NULL,NULL,'published','[\"products\\/12-1.jpg\"]','SW-199-A0-A1',0,19,0,1,0,4,1,0,515,391.4,NULL,NULL,13.00,18.00,16.00,884.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(61,'EPSION Plaster Printer',NULL,NULL,'published','[\"products\\/12-2.jpg\"]','SW-199-A0-A2',0,19,0,1,0,4,1,0,515,422.3,NULL,NULL,13.00,18.00,16.00,884.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(62,'Sound Intone I65 Earphone White Version (Digital)',NULL,NULL,'published','[\"products\\/13.jpg\"]','SW-156-A0',0,17,0,1,0,5,1,0,504,NULL,NULL,NULL,14.00,15.00,16.00,660.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(63,'Sound Intone I65 Earphone White Version (Digital)',NULL,NULL,'published','[\"products\\/13-1.jpg\"]','SW-156-A0-A1',0,17,0,1,0,5,1,0,504,NULL,NULL,NULL,14.00,15.00,16.00,660.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(64,'B&O Play Mini Bluetooth Speaker',NULL,NULL,'published','[\"products\\/14.jpg\"]','SW-129-A0',0,11,0,1,0,2,1,0,540,NULL,NULL,NULL,18.00,16.00,15.00,552.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(65,'B&O Play Mini Bluetooth Speaker',NULL,NULL,'published','[\"products\\/14.jpg\"]','SW-129-A0-A1',0,11,0,1,0,2,1,0,540,NULL,NULL,NULL,18.00,16.00,15.00,552.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(66,'Apple MacBook Air Retina 13.3-Inch Laptop',NULL,NULL,'published','[\"products\\/15.jpg\"]','SW-134-A0',0,10,0,1,0,1,1,0,520,NULL,NULL,NULL,17.00,14.00,11.00,614.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(67,'Apple MacBook Air Retina 13.3-Inch Laptop',NULL,NULL,'published','[\"products\\/15-1.jpg\"]','SW-134-A0-A1',0,10,0,1,0,1,1,0,520,NULL,NULL,NULL,17.00,14.00,11.00,614.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(68,'Apple MacBook Air Retina 12-Inch Laptop',NULL,NULL,'published','[\"products\\/16.jpg\"]','SW-109-A0',0,16,0,1,0,7,1,0,568,443.04,NULL,NULL,12.00,12.00,17.00,687.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(69,'Apple MacBook Air Retina 12-Inch Laptop',NULL,NULL,'published','[\"products\\/16.jpg\"]','SW-109-A0-A1',0,16,0,1,0,7,1,0,568,454.4,NULL,NULL,12.00,12.00,17.00,687.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(70,'Samsung Gear VR Virtual Reality Headset (Digital)',NULL,NULL,'published','[\"products\\/17.jpg\"]','SW-123-A0',0,17,0,1,0,2,1,0,520,NULL,NULL,NULL,12.00,15.00,20.00,559.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(71,'Samsung Gear VR Virtual Reality Headset (Digital)',NULL,NULL,'published','[\"products\\/17-1.jpg\"]','SW-123-A0-A1',0,17,0,1,0,2,1,0,520,NULL,NULL,NULL,12.00,15.00,20.00,559.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(72,'Aveeno Moisturizing Body Shower 450ml',NULL,NULL,'published','[\"products\\/18.jpg\"]','SW-111-A0',0,12,0,1,0,1,1,0,936,NULL,NULL,NULL,13.00,20.00,11.00,556.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(73,'Aveeno Moisturizing Body Shower 450ml',NULL,NULL,'published','[\"products\\/18-1.jpg\"]','SW-111-A0-A1',0,12,0,1,0,1,1,0,936,NULL,NULL,NULL,13.00,20.00,11.00,556.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(74,'Aveeno Moisturizing Body Shower 450ml',NULL,NULL,'published','[\"products\\/18-2.jpg\"]','SW-111-A0-A2',0,12,0,1,0,1,1,0,936,NULL,NULL,NULL,13.00,20.00,11.00,556.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(75,'NYX Beauty Couton Pallete Makeup 12',NULL,NULL,'published','[\"products\\/19.jpg\"]','SW-131-A0',0,14,0,1,0,7,1,0,1069,NULL,NULL,NULL,14.00,17.00,20.00,894.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(76,'NYX Beauty Couton Pallete Makeup 12',NULL,NULL,'published','[\"products\\/20.jpg\"]','SW-113-A0',0,13,0,1,0,3,1,0,899,800.11,NULL,NULL,19.00,12.00,11.00,503.00,NULL,0,'2024-03-11 00:14:12','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(77,'NYX Beauty Couton Pallete Makeup 12',NULL,NULL,'published','[\"products\\/20-1.jpg\"]','SW-113-A0-A1',0,13,0,1,0,3,1,0,899,755.16,NULL,NULL,19.00,12.00,11.00,503.00,NULL,0,'2024-03-11 00:14:13','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(78,'NYX Beauty Couton Pallete Makeup 12',NULL,NULL,'published','[\"products\\/20-2.jpg\"]','SW-113-A0-A2',0,13,0,1,0,3,1,0,899,773.14,NULL,NULL,19.00,12.00,11.00,503.00,NULL,0,'2024-03-11 00:14:13','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(79,'MVMTH Classical Leather Watch In Black (Digital)',NULL,NULL,'published','[\"products\\/21.jpg\"]','SW-115-A0',0,14,0,1,0,2,1,0,758,NULL,NULL,NULL,19.00,18.00,13.00,760.00,NULL,0,'2024-03-11 00:14:13','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(80,'MVMTH Classical Leather Watch In Black (Digital)',NULL,NULL,'published','[\"products\\/21-1.jpg\"]','SW-115-A0-A1',0,14,0,1,0,2,1,0,758,NULL,NULL,NULL,19.00,18.00,13.00,760.00,NULL,0,'2024-03-11 00:14:13','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(81,'Baxter Care Hair Kit For Bearded Mens',NULL,NULL,'published','[\"products\\/22.jpg\"]','SW-112-A0',0,18,0,1,0,2,1,0,422,NULL,NULL,NULL,19.00,17.00,19.00,570.00,NULL,0,'2024-03-11 00:14:13','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(82,'Baxter Care Hair Kit For Bearded Mens',NULL,NULL,'published','[\"products\\/22-1.jpg\"]','SW-112-A0-A1',0,18,0,1,0,2,1,0,422,NULL,NULL,NULL,19.00,17.00,19.00,570.00,NULL,0,'2024-03-11 00:14:13','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(83,'Baxter Care Hair Kit For Bearded Mens',NULL,NULL,'published','[\"products\\/22-2.jpg\"]','SW-112-A0-A2',0,18,0,1,0,2,1,0,422,NULL,NULL,NULL,19.00,17.00,19.00,570.00,NULL,0,'2024-03-11 00:14:13','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(84,'Ciate Palemore Lipstick Bold Red Color',NULL,NULL,'published','[\"products\\/23.jpg\"]','SW-193-A0',0,12,0,1,0,5,1,0,1015,NULL,NULL,NULL,18.00,19.00,17.00,701.00,NULL,0,'2024-03-11 00:14:13','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(85,'Ciate Palemore Lipstick Bold Red Color',NULL,NULL,'published','[\"products\\/23-1.jpg\"]','SW-193-A0-A1',0,12,0,1,0,5,1,0,1015,NULL,NULL,NULL,18.00,19.00,17.00,701.00,NULL,0,'2024-03-11 00:14:13','2024-03-11 00:14:21','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0);

--
