--
-- Host: localhost    Database: nest
-- ------------------------------------------------------


--
-- 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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `activations` VALUES (1,1,'9fBD8SPqlONsoovJpPXJ1a1whcfQouts',1,'2024-02-24 01:32:41','2024-02-24 01:32:41','2024-02-24 01:32:41'),(2,2,'QCa0DqGwgJkMmbpbfT9N2ZfpBtdLve9c',1,'2024-02-24 01:32:42','2024-02-24 01:32:42','2024-02-24 01:32:42');

--
-- 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 NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `permission` varchar(191) 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(191) 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,'Rerum aliquam ad velit. Optio ea quod culpa mollitia. Repellendus consequatur ratione eos molestias ducimus non nihil.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2024-02-24 01:32:40','2024-02-24 01:32:40'),(2,'Fashion',0,'Molestiae corrupti et voluptatum pariatur mollitia. Omnis optio ut quod aperiam expedita. Possimus occaecati voluptatibus deserunt voluptates quo aliquid.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-02-24 01:32:40','2024-02-24 01:32:40'),(3,'Electronic',0,'Alias tempore quam voluptatem debitis eos qui voluptas. Error suscipit quo est unde at est et quisquam. Porro et eius odit aut rem.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-02-24 01:32:40','2024-02-24 01:32:40'),(4,'Commercial',0,'Inventore cupiditate ut consequuntur voluptatem. Placeat sed dolores in vero. Quia voluptatem explicabo ea similique.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-02-24 01:32:40','2024-02-24 01:32:40');

--
-- 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- 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(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `order` tinyint unsigned NOT NULL DEFAULT '0',
  `is_featured` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_brands` VALUES (1,'Perxsion',NULL,NULL,NULL,'published',0,1,'2024-02-24 01:32:24','2024-02-24 01:32:24'),(2,'Hiching',NULL,NULL,NULL,'published',1,1,'2024-02-24 01:32:24','2024-02-24 01:32:24'),(3,'Kepslo',NULL,NULL,NULL,'published',2,1,'2024-02-24 01:32:24','2024-02-24 01:32:24'),(4,'Groneba',NULL,NULL,NULL,'published',3,1,'2024-02-24 01:32:24','2024-02-24 01:32:24'),(5,'Babian',NULL,NULL,NULL,'published',4,1,'2024-02-24 01:32:24','2024-02-24 01:32:24'),(6,'Valorant',NULL,NULL,NULL,'published',5,1,'2024-02-24 01:32:24','2024-02-24 01:32:24'),(7,'Pure',NULL,NULL,NULL,'published',6,1,'2024-02-24 01:32:24','2024-02-24 01:32:24');

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

CREATE TABLE `ec_brands_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_brands_id` bigint unsigned NOT NULL,
  `name` varchar(191) 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(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_prefix_symbol` tinyint unsigned NOT NULL DEFAULT '0',
  `decimals` tinyint unsigned DEFAULT '0',
  `order` int unsigned DEFAULT '0',
  `is_default` tinyint NOT NULL DEFAULT '0',
  `exchange_rate` double NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=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-02-24 01:32:24','2024-02-24 01:32:24'),(2,'EUR','€',0,2,1,0,0.84,'2024-02-24 01:32:24','2024-02-24 01:32:24'),(3,'VND','₫',0,0,2,0,23203,'2024-02-24 01:32:24','2024-02-24 01:32:24'),(4,'NGN','₦',1,2,2,0,895.52,'2024-02-24 01:32:24','2024-02-24 01:32:24');

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

CREATE TABLE `ec_customer_addresses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(20) 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,'Prof. Leo Hegmann Jr.','customer@botble.com','+17812399616','HN','Missouri','Sporerstad','52589 Billie Unions',1,1,'2024-02-24 01:32:34','2024-02-24 01:32:34','86000-8745'),(2,'Prof. Leo Hegmann Jr.','customer@botble.com','+17182401835','JE','Washington','Damienton','68883 Kuphal Crescent Suite 703',1,0,'2024-02-24 01:32:34','2024-02-24 01:32:34','25979'),(3,'Carson Howe Jr.','vendor@botble.com','+14436536946','SB','Wisconsin','Julieberg','6050 Leland Crescent',2,1,'2024-02-24 01:32:34','2024-02-24 01:32:34','22203'),(4,'Carson Howe Jr.','vendor@botble.com','+17729882415','EE','South Carolina','Eudoraville','5827 Boehm Squares',2,0,'2024-02-24 01:32:34','2024-02-24 01:32:34','71734-9665'),(5,'Allene Leuschke','monserrate27@example.com','+15159894876','GW','Texas','Dewaynetown','998 Gilbert Forges Apt. 825',3,1,'2024-02-24 01:32:35','2024-02-24 01:32:35','33018-6386'),(6,'Blair Robel V','pagac.alize@example.com','+12816311473','NO','Missouri','North Dariana','4811 Purdy Keys Suite 497',4,1,'2024-02-24 01:32:35','2024-02-24 01:32:35','08901'),(7,'Turner Mills','madonna58@example.org','+15747946368','GE','District of Columbia','Lake Chelsieborough','7463 Brown Creek Suite 905',5,1,'2024-02-24 01:32:35','2024-02-24 01:32:35','20420-5583'),(8,'Mr. Davonte Borer','brandi79@example.com','+14148778317','PL','South Dakota','Padbergton','7518 Swaniawski Gateway Suite 791',6,1,'2024-02-24 01:32:35','2024-02-24 01:32:35','10001'),(9,'Jeff Wilkinson','vbechtelar@example.org','+13145811686','CO','South Carolina','Kossville','28077 Glennie Alley Suite 937',7,1,'2024-02-24 01:32:36','2024-02-24 01:32:36','71972'),(10,'Prof. Rodrick Gorczany','laura.doyle@example.org','+13216127341','BQ','Mississippi','West Cecile','8963 Kassulke Parks',8,1,'2024-02-24 01:32:36','2024-02-24 01:32:36','23183'),(11,'Miss Callie Zboncak','nhilpert@example.org','+19082025793','RW','California','Gretaborough','891 Jarrett Stravenue',9,1,'2024-02-24 01:32:36','2024-02-24 01:32:36','97406'),(12,'Karl Dooley','macey51@example.org','+15159928134','KZ','North Carolina','West Irwinton','4136 Taurean Extensions',10,1,'2024-02-24 01:32:36','2024-02-24 01:32:36','55925');

--
-- 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(191) 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,6,41.8,8,4),(2,5,40,11,1),(3,19,75.04,13,4),(4,7,49.14,19,2),(5,3,351.78,19,4),(5,1,254.15,17,4),(5,2,255.42,7,1),(5,3,243.54,15,3),(5,4,31.68,8,3),(5,5,35,14,3);

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

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

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

INSERT INTO `ec_flash_sales` VALUES (1,'Deal of the Day','2024-04-11 00:00:00','published','2024-02-24 01:32:37','2024-02-24 01:32:37'),(2,'Winter Sale','2024-03-11 00:00:00','published','2024-02-24 01:32:37','2024-02-24 01:32:37'),(3,'Gadgets &amp; Accessories','2024-03-27 00:00:00','published','2024-02-24 01:32:37','2024-02-24 01:32:37'),(4,'Hot products','2024-03-31 00:00:00','published','2024-02-24 01:32:37','2024-02-24 01:32:37'),(5,'Best sale items','2024-04-10 00:00:00','published','2024-02-24 01:32:37','2024-02-24 01:32:37');

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

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

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


--
-- 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-02-24 01:32:46','2024-02-24 01:32:46'),(1,2,'2 Year',10,9999,0,'2024-02-24 01:32:46','2024-02-24 01:32:46'),(1,3,'3 Year',20,9999,0,'2024-02-24 01:32:46','2024-02-24 01:32:46'),(2,4,'4GB',0,9999,0,'2024-02-24 01:32:46','2024-02-24 01:32:46'),(2,5,'8GB',10,9999,0,'2024-02-24 01:32:46','2024-02-24 01:32:46'),(2,6,'16GB',20,9999,0,'2024-02-24 01:32:46','2024-02-24 01:32:46'),(3,7,'Core i5',0,9999,0,'2024-02-24 01:32:46','2024-02-24 01:32:46'),(3,8,'Core i7',10,9999,0,'2024-02-24 01:32:46','2024-02-24 01:32:46'),(3,9,'Core i9',20,9999,0,'2024-02-24 01:32:46','2024-02-24 01:32:46'),(4,10,'128GB',0,9999,0,'2024-02-24 01:32:46','2024-02-24 01:32:46'),(4,11,'256GB',10,9999,0,'2024-02-24 01:32:46','2024-02-24 01:32:46'),(4,12,'512GB',20,9999,0,'2024-02-24 01:32:46','2024-02-24 01:32:46');

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

CREATE TABLE `ec_global_option_value_translations` (
  `lang_code` varchar(191) 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(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of options',
  `option_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'option type',
  `required` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Checked if this option is required',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_global_options`
--

INSERT INTO `ec_global_options` VALUES (1,'Warranty','Botble\\Ecommerce\\Option\\OptionType\\RadioButton',1,'2024-02-24 01:32:46','2024-02-24 01:32:46'),(2,'RAM','Botble\\Ecommerce\\Option\\OptionType\\RadioButton',1,'2024-02-24 01:32:46','2024-02-24 01:32:46'),(3,'CPU','Botble\\Ecommerce\\Option\\OptionType\\RadioButton',1,'2024-02-24 01:32:46','2024-02-24 01:32:46'),(4,'HDD','Botble\\Ecommerce\\Option\\OptionType\\Dropdown',0,'2024-02-24 01:32:46','2024-02-24 01:32:46');

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

CREATE TABLE `ec_global_options_translations` (
  `lang_code` varchar(191) 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(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` int unsigned NOT NULL,
  `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=63 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',27,'Angie’s Boomchickapop Sweet &amp; Salty Kettle Corn',NULL,'products/3.jpg',3,451.00,1353.00,0.00,0.00,1353.00,'{\"sku\":\"HS-153-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 3 Boxes)\"}','2024-02-24 01:32:49','2024-02-24 01:32:49'),(2,2,'Botble\\Ecommerce\\Models\\Product',52,'Organic Frozen Triple Berry Blend',NULL,'products/14.jpg',3,125.00,375.00,0.00,0.00,375.00,'{\"sku\":\"HS-115-A0\",\"attributes\":\"(Weight: 5KG, Boxes: 5 Boxes)\"}','2024-02-24 01:32:49','2024-02-24 01:32:49'),(3,3,'Botble\\Ecommerce\\Models\\Product',79,'Colorful Banana',NULL,'products/23-1.jpg',1,121.00,121.00,0.00,0.00,121.00,'{\"sku\":\"HS-110-A0-A1\",\"attributes\":\"(Weight: 1KG, Boxes: 3 Boxes)\"}','2024-02-24 01:32:50','2024-02-24 01:32:50'),(4,4,'Botble\\Ecommerce\\Models\\Product',34,'Canada Dry Ginger Ale – 2 L Bottle',NULL,'products/7-1.jpg',3,117.00,351.00,0.00,0.00,351.00,'{\"sku\":\"HS-138-A0-A1\",\"attributes\":\"(Boxes: 1 Box, Weight: 2KG)\"}','2024-02-24 01:32:50','2024-02-24 01:32:50'),(5,4,'Botble\\Ecommerce\\Models\\Product',62,'Angie’s Boomchickapop Sweet &amp; Salty Kettle Corn (Digital)',NULL,'products/17.jpg',1,112.00,112.00,0.00,0.00,112.00,'{\"sku\":\"HS-183-A0-A2\",\"attributes\":\"(Weight: 2KG, Boxes: 2 Boxes)\"}','2024-02-24 01:32:50','2024-02-24 01:32:50'),(6,5,'Botble\\Ecommerce\\Models\\Product',38,'Gorton’s Beer Battered Fish Fillets (Digital)',NULL,'products/9-1.jpg',3,119.00,357.00,0.00,0.00,357.00,'{\"sku\":\"HS-156-A0-A1\",\"attributes\":\"(Weight: 2KG, Boxes: 5 Boxes)\"}','2024-02-24 01:32:50','2024-02-24 01:32:50'),(7,6,'Botble\\Ecommerce\\Models\\Product',71,'Perdue Simply Smart Organics Gluten Free',NULL,'products/20.jpg',3,110.00,330.00,0.00,0.00,330.00,'{\"sku\":\"HS-122-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 3 Boxes)\"}','2024-02-24 01:32:50','2024-02-24 01:32:50'),(8,7,'Botble\\Ecommerce\\Models\\Product',45,'Nestle Original Coffee-Mate Coffee Creamer',NULL,'products/11-1.jpg',3,114.00,342.00,0.00,0.00,342.00,'{\"sku\":\"HS-178-A0-A1\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}','2024-02-24 01:32:51','2024-02-24 01:32:51'),(9,8,'Botble\\Ecommerce\\Models\\Product',46,'Naturally Flavored Cinnamon Vanilla Light Roast Coffee',NULL,'products/12.jpg',1,129.00,129.00,0.00,0.00,129.00,'{\"sku\":\"HS-171-A0\",\"attributes\":\"(Weight: 2KG, Boxes: 5 Boxes)\"}','2024-02-24 01:32:51','2024-02-24 01:32:51'),(10,9,'Botble\\Ecommerce\\Models\\Product',29,'Foster Farms Takeout Crispy Classic',NULL,'products/4-1.jpg',3,88.00,264.00,0.00,0.00,264.00,'{\"sku\":\"HS-105-A0-A1\",\"attributes\":\"(Weight: 1KG, Boxes: 2 Boxes)\"}','2024-02-24 01:32:51','2024-02-24 01:32:51'),(11,10,'Botble\\Ecommerce\\Models\\Product',30,'Blue Diamond Almonds Lightly (Digital)',NULL,'products/5.jpg',2,50.00,100.00,0.00,0.00,100.00,'{\"sku\":\"HS-189-A0\",\"attributes\":\"(Boxes: 1 Box, Weight: 5KG)\"}','2024-02-24 01:32:51','2024-02-24 01:32:51'),(12,10,'Botble\\Ecommerce\\Models\\Product',66,'Simply Lemonade with Raspberry Juice',NULL,'products/19.jpg',3,112.00,336.00,0.00,0.00,336.00,'{\"sku\":\"HS-121-A0\",\"attributes\":\"(Boxes: 2 Boxes, Weight: 5KG)\"}','2024-02-24 01:32:51','2024-02-24 01:32:51'),(13,11,'Botble\\Ecommerce\\Models\\Product',33,'Canada Dry Ginger Ale – 2 L Bottle',NULL,'products/7.jpg',2,117.00,234.00,0.00,0.00,234.00,'{\"sku\":\"HS-138-A0\",\"attributes\":\"(Weight: 3KG, Boxes: 4 Boxes)\"}','2024-02-24 01:32:52','2024-02-24 01:32:52'),(14,12,'Botble\\Ecommerce\\Models\\Product',44,'Nestle Original Coffee-Mate Coffee Creamer',NULL,'products/11.jpg',2,114.00,228.00,0.00,0.00,228.00,'{\"sku\":\"HS-178-A0\",\"attributes\":\"(Weight: 2KG, Boxes: 5 Boxes)\"}','2024-02-24 01:32:52','2024-02-24 01:32:52'),(15,13,'Botble\\Ecommerce\\Models\\Product',47,'Naturally Flavored Cinnamon Vanilla Light Roast Coffee',NULL,'products/12-1.jpg',3,129.00,387.00,0.00,0.00,387.00,'{\"sku\":\"HS-171-A0-A1\",\"attributes\":\"(Weight: 2KG, Boxes: 4 Boxes)\"}','2024-02-24 01:32:52','2024-02-24 01:32:52'),(16,13,'Botble\\Ecommerce\\Models\\Product',62,'Angie’s Boomchickapop Sweet &amp; Salty Kettle Corn (Digital)',NULL,'products/17.jpg',3,112.00,336.00,0.00,0.00,336.00,'{\"sku\":\"HS-183-A0-A2\",\"attributes\":\"(Weight: 2KG, Boxes: 2 Boxes)\"}','2024-02-24 01:32:52','2024-02-24 01:32:52'),(17,14,'Botble\\Ecommerce\\Models\\Product',25,'Seeds of Change Organic Quinoe (Digital)',NULL,'products/1.jpg',2,391.00,782.00,0.00,0.00,782.00,'{\"sku\":\"HS-173-A0\",\"attributes\":\"(Boxes: 1 Box, Weight: 5KG)\"}','2024-02-24 01:32:52','2024-02-24 01:32:52'),(18,15,'Botble\\Ecommerce\\Models\\Product',26,'All Natural Italian-Style Chicken Meatballs',NULL,'products/2.jpg',2,387.00,774.00,0.00,0.00,774.00,'{\"sku\":\"HS-176-A0\",\"attributes\":\"(Boxes: 2 Boxes, Weight: 5KG)\"}','2024-02-24 01:32:53','2024-02-24 01:32:53'),(19,16,'Botble\\Ecommerce\\Models\\Product',53,'Organic Frozen Triple Berry Blend',NULL,'products/14-1.jpg',1,125.00,125.00,0.00,0.00,125.00,'{\"sku\":\"HS-115-A0-A1\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}','2024-02-24 01:32:53','2024-02-24 01:32:53'),(20,17,'Botble\\Ecommerce\\Models\\Product',29,'Foster Farms Takeout Crispy Classic',NULL,'products/4-1.jpg',3,88.00,264.00,0.00,0.00,264.00,'{\"sku\":\"HS-105-A0-A1\",\"attributes\":\"(Weight: 1KG, Boxes: 2 Boxes)\"}','2024-02-24 01:32:53','2024-02-24 01:32:53'),(21,18,'Botble\\Ecommerce\\Models\\Product',35,'Encore Seafoods Stuffed Alaskan',NULL,'products/8.jpg',2,114.00,228.00,0.00,0.00,228.00,'{\"sku\":\"HS-179-A0\",\"attributes\":\"(Weight: 3KG, Boxes: 5 Boxes)\"}','2024-02-24 01:32:53','2024-02-24 01:32:53'),(22,19,'Botble\\Ecommerce\\Models\\Product',58,'Oroweat Country Buttermilk Bread',NULL,'products/15.jpg',1,127.00,127.00,0.00,0.00,127.00,'{\"sku\":\"HS-177-A0-A3\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}','2024-02-24 01:32:54','2024-02-24 01:32:54'),(23,20,'Botble\\Ecommerce\\Models\\Product',26,'All Natural Italian-Style Chicken Meatballs',NULL,'products/2.jpg',2,387.00,774.00,0.00,0.00,774.00,'{\"sku\":\"HS-176-A0\",\"attributes\":\"(Boxes: 2 Boxes, Weight: 5KG)\"}','2024-02-24 01:32:54','2024-02-24 01:32:54'),(24,21,'Botble\\Ecommerce\\Models\\Product',30,'Blue Diamond Almonds Lightly (Digital)',NULL,'products/5.jpg',3,50.00,150.00,0.00,0.00,150.00,'{\"sku\":\"HS-189-A0\",\"attributes\":\"(Boxes: 1 Box, Weight: 5KG)\"}','2024-02-24 01:32:54','2024-02-24 01:32:54'),(25,21,'Botble\\Ecommerce\\Models\\Product',53,'Organic Frozen Triple Berry Blend',NULL,'products/14-1.jpg',2,125.00,250.00,0.00,0.00,250.00,'{\"sku\":\"HS-115-A0-A1\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}','2024-02-24 01:32:54','2024-02-24 01:32:54'),(26,22,'Botble\\Ecommerce\\Models\\Product',48,'Naturally Flavored Cinnamon Vanilla Light Roast Coffee',NULL,'products/12.jpg',1,129.00,129.00,0.00,0.00,129.00,'{\"sku\":\"HS-171-A0-A2\",\"attributes\":\"(Weight: 1KG, Boxes: 3 Boxes)\"}','2024-02-24 01:32:54','2024-02-24 01:32:54'),(27,23,'Botble\\Ecommerce\\Models\\Product',31,'Blue Diamond Almonds Lightly (Digital)',NULL,'products/5-1.jpg',1,50.00,50.00,0.00,0.00,50.00,'{\"sku\":\"HS-189-A0-A1\",\"attributes\":\"(Boxes: 1 Box, Weight: 4KG)\"}','2024-02-24 01:32:55','2024-02-24 01:32:55'),(28,23,'Botble\\Ecommerce\\Models\\Product',53,'Organic Frozen Triple Berry Blend',NULL,'products/14-1.jpg',3,125.00,375.00,0.00,0.00,375.00,'{\"sku\":\"HS-115-A0-A1\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}','2024-02-24 01:32:55','2024-02-24 01:32:55'),(29,23,'Botble\\Ecommerce\\Models\\Product',80,'Signature Wood-Fired Mushroom and Caramelized',NULL,'products/24.jpg',2,114.00,228.00,0.00,0.00,228.00,'{\"sku\":\"HS-156-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 2 Boxes)\"}','2024-02-24 01:32:55','2024-02-24 01:32:55'),(30,24,'Botble\\Ecommerce\\Models\\Product',75,'Chen Watermelon (Digital)',NULL,'products/21.jpg',3,126.00,378.00,0.00,0.00,378.00,'{\"sku\":\"HS-161-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 1 Box)\"}','2024-02-24 01:32:55','2024-02-24 01:32:55'),(31,25,'Botble\\Ecommerce\\Models\\Product',30,'Blue Diamond Almonds Lightly (Digital)',NULL,'products/5.jpg',1,50.00,50.00,0.00,0.00,50.00,'{\"sku\":\"HS-189-A0\",\"attributes\":\"(Boxes: 1 Box, Weight: 5KG)\"}','2024-02-24 01:32:55','2024-02-24 01:32:55'),(32,26,'Botble\\Ecommerce\\Models\\Product',32,'Chobani Complete Vanilla Greek',NULL,'products/6.jpg',2,55.00,110.00,0.00,0.00,110.00,'{\"sku\":\"HS-171-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 1 Box)\"}','2024-02-24 01:32:55','2024-02-24 01:32:55'),(33,27,'Botble\\Ecommerce\\Models\\Product',77,'Organic Cage-Free Grade A Large Brown Eggs',NULL,'products/22.jpg',2,116.00,232.00,0.00,0.00,232.00,'{\"sku\":\"HS-178-A0\",\"attributes\":\"(Weight: 2KG, Boxes: 5 Boxes)\"}','2024-02-24 01:32:55','2024-02-24 01:32:55'),(34,28,'Botble\\Ecommerce\\Models\\Product',26,'All Natural Italian-Style Chicken Meatballs',NULL,'products/2.jpg',1,387.00,387.00,0.00,0.00,387.00,'{\"sku\":\"HS-176-A0\",\"attributes\":\"(Boxes: 2 Boxes, Weight: 5KG)\"}','2024-02-24 01:32:56','2024-02-24 01:32:56'),(35,29,'Botble\\Ecommerce\\Models\\Product',37,'Gorton’s Beer Battered Fish Fillets (Digital)',NULL,'products/9.jpg',2,119.00,238.00,0.00,0.00,238.00,'{\"sku\":\"HS-156-A0\",\"attributes\":\"(Boxes: 1 Box, Weight: 2KG)\"}','2024-02-24 01:32:56','2024-02-24 01:32:56'),(36,29,'Botble\\Ecommerce\\Models\\Product',70,'Simply Lemonade with Raspberry Juice',NULL,'products/19.jpg',1,112.00,112.00,0.00,0.00,112.00,'{\"sku\":\"HS-121-A0-A4\",\"attributes\":\"(Boxes: 1 Box, Weight: 3KG)\"}','2024-02-24 01:32:56','2024-02-24 01:32:56'),(37,30,'Botble\\Ecommerce\\Models\\Product',39,'Haagen-Dazs Caramel Cone Ice Cream',NULL,'products/10.jpg',3,500.00,1500.00,0.00,0.00,1500.00,'{\"sku\":\"HS-116-A0\",\"attributes\":\"(Weight: 2KG, Boxes: 4 Boxes)\"}','2024-02-24 01:32:56','2024-02-24 01:32:56'),(38,30,'Botble\\Ecommerce\\Models\\Product',40,'Haagen-Dazs Caramel Cone Ice Cream',NULL,'products/10-1.jpg',2,500.00,1000.00,0.00,0.00,1000.00,'{\"sku\":\"HS-116-A0-A1\",\"attributes\":\"(Weight: 4KG, Boxes: 4 Boxes)\"}','2024-02-24 01:32:56','2024-02-24 01:32:56'),(39,30,'Botble\\Ecommerce\\Models\\Product',59,'Foster Farms Takeout Crispy Classic Buffalo Wings',NULL,'products/16.jpg',1,116.00,116.00,0.00,0.00,116.00,'{\"sku\":\"HS-196-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 3 Boxes)\"}','2024-02-24 01:32:56','2024-02-24 01:32:56'),(40,31,'Botble\\Ecommerce\\Models\\Product',31,'Blue Diamond Almonds Lightly (Digital)',NULL,'products/5-1.jpg',1,50.00,50.00,0.00,0.00,50.00,'{\"sku\":\"HS-189-A0-A1\",\"attributes\":\"(Boxes: 1 Box, Weight: 4KG)\"}','2024-02-24 01:32:56','2024-02-24 01:32:56'),(41,31,'Botble\\Ecommerce\\Models\\Product',68,'Simply Lemonade with Raspberry Juice',NULL,'products/19.jpg',3,112.00,336.00,0.00,0.00,336.00,'{\"sku\":\"HS-121-A0-A2\",\"attributes\":\"(Weight: 2KG, Boxes: 5 Boxes)\"}','2024-02-24 01:32:56','2024-02-24 01:32:56'),(42,32,'Botble\\Ecommerce\\Models\\Product',40,'Haagen-Dazs Caramel Cone Ice Cream',NULL,'products/10-1.jpg',3,500.00,1500.00,0.00,0.00,1500.00,'{\"sku\":\"HS-116-A0-A1\",\"attributes\":\"(Weight: 4KG, Boxes: 4 Boxes)\"}','2024-02-24 01:32:57','2024-02-24 01:32:57'),(43,33,'Botble\\Ecommerce\\Models\\Product',56,'Oroweat Country Buttermilk Bread',NULL,'products/15-1.jpg',1,127.00,127.00,0.00,0.00,127.00,'{\"sku\":\"HS-177-A0-A1\",\"attributes\":\"(Weight: 5KG, Boxes: 5 Boxes)\"}','2024-02-24 01:32:57','2024-02-24 01:32:57'),(44,34,'Botble\\Ecommerce\\Models\\Product',32,'Chobani Complete Vanilla Greek',NULL,'products/6.jpg',3,55.00,165.00,0.00,0.00,165.00,'{\"sku\":\"HS-171-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 1 Box)\"}','2024-02-24 01:32:57','2024-02-24 01:32:57'),(45,34,'Botble\\Ecommerce\\Models\\Product',58,'Oroweat Country Buttermilk Bread',NULL,'products/15.jpg',3,127.00,381.00,0.00,0.00,381.00,'{\"sku\":\"HS-177-A0-A3\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}','2024-02-24 01:32:57','2024-02-24 01:32:57'),(46,35,'Botble\\Ecommerce\\Models\\Product',34,'Canada Dry Ginger Ale – 2 L Bottle',NULL,'products/7-1.jpg',2,117.00,234.00,0.00,0.00,234.00,'{\"sku\":\"HS-138-A0-A1\",\"attributes\":\"(Boxes: 1 Box, Weight: 2KG)\"}','2024-02-24 01:32:57','2024-02-24 01:32:57'),(47,35,'Botble\\Ecommerce\\Models\\Product',61,'Angie’s Boomchickapop Sweet &amp; Salty Kettle Corn (Digital)',NULL,'products/17-1.jpg',1,112.00,112.00,0.00,0.00,112.00,'{\"sku\":\"HS-183-A0-A1\",\"attributes\":\"(Boxes: 2 Boxes, Weight: 5KG)\"}','2024-02-24 01:32:57','2024-02-24 01:32:57'),(48,36,'Botble\\Ecommerce\\Models\\Product',47,'Naturally Flavored Cinnamon Vanilla Light Roast Coffee',NULL,'products/12-1.jpg',3,129.00,387.00,0.00,0.00,387.00,'{\"sku\":\"HS-171-A0-A1\",\"attributes\":\"(Weight: 2KG, Boxes: 4 Boxes)\"}','2024-02-24 01:32:58','2024-02-24 01:32:58'),(49,37,'Botble\\Ecommerce\\Models\\Product',59,'Foster Farms Takeout Crispy Classic Buffalo Wings',NULL,'products/16.jpg',3,116.00,348.00,0.00,0.00,348.00,'{\"sku\":\"HS-196-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 3 Boxes)\"}','2024-02-24 01:32:58','2024-02-24 01:32:58'),(50,38,'Botble\\Ecommerce\\Models\\Product',34,'Canada Dry Ginger Ale – 2 L Bottle',NULL,'products/7-1.jpg',1,117.00,117.00,0.00,0.00,117.00,'{\"sku\":\"HS-138-A0-A1\",\"attributes\":\"(Boxes: 1 Box, Weight: 2KG)\"}','2024-02-24 01:32:59','2024-02-24 01:32:59'),(51,39,'Botble\\Ecommerce\\Models\\Product',58,'Oroweat Country Buttermilk Bread',NULL,'products/15.jpg',1,127.00,127.00,0.00,0.00,127.00,'{\"sku\":\"HS-177-A0-A3\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}','2024-02-24 01:32:59','2024-02-24 01:32:59'),(52,40,'Botble\\Ecommerce\\Models\\Product',30,'Blue Diamond Almonds Lightly (Digital)',NULL,'products/5.jpg',1,50.00,50.00,0.00,0.00,50.00,'{\"sku\":\"HS-189-A0\",\"attributes\":\"(Boxes: 1 Box, Weight: 5KG)\"}','2024-02-24 01:33:00','2024-02-24 01:33:00'),(53,41,'Botble\\Ecommerce\\Models\\Product',34,'Canada Dry Ginger Ale – 2 L Bottle',NULL,'products/7-1.jpg',1,117.00,117.00,0.00,0.00,117.00,'{\"sku\":\"HS-138-A0-A1\",\"attributes\":\"(Boxes: 1 Box, Weight: 2KG)\"}','2024-02-24 01:33:00','2024-02-24 01:33:00'),(54,42,'Botble\\Ecommerce\\Models\\Product',76,'Chen Watermelon (Digital)',NULL,'products/21-1.jpg',2,126.00,252.00,0.00,0.00,252.00,'{\"sku\":\"HS-161-A0-A1\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}','2024-02-24 01:33:01','2024-02-24 01:33:01'),(55,43,'Botble\\Ecommerce\\Models\\Product',29,'Foster Farms Takeout Crispy Classic',NULL,'products/4-1.jpg',2,88.00,176.00,0.00,0.00,176.00,'{\"sku\":\"HS-105-A0-A1\",\"attributes\":\"(Weight: 1KG, Boxes: 2 Boxes)\"}','2024-02-24 01:33:01','2024-02-24 01:33:01'),(56,44,'Botble\\Ecommerce\\Models\\Product',40,'Haagen-Dazs Caramel Cone Ice Cream',NULL,'products/10-1.jpg',2,500.00,1000.00,0.00,0.00,1000.00,'{\"sku\":\"HS-116-A0-A1\",\"attributes\":\"(Weight: 4KG, Boxes: 4 Boxes)\"}','2024-02-24 01:33:02','2024-02-24 01:33:02'),(57,45,'Botble\\Ecommerce\\Models\\Product',52,'Organic Frozen Triple Berry Blend',NULL,'products/14.jpg',2,125.00,250.00,0.00,0.00,250.00,'{\"sku\":\"HS-115-A0\",\"attributes\":\"(Weight: 5KG, Boxes: 5 Boxes)\"}','2024-02-24 01:33:02','2024-02-24 01:33:02'),(58,46,'Botble\\Ecommerce\\Models\\Product',62,'Angie’s Boomchickapop Sweet &amp; Salty Kettle Corn (Digital)',NULL,'products/17.jpg',2,112.00,224.00,0.00,0.00,224.00,'{\"sku\":\"HS-183-A0-A2\",\"attributes\":\"(Weight: 2KG, Boxes: 2 Boxes)\"}','2024-02-24 01:33:03','2024-02-24 01:33:03'),(59,47,'Botble\\Ecommerce\\Models\\Product',71,'Perdue Simply Smart Organics Gluten Free',NULL,'products/20.jpg',3,110.00,330.00,0.00,0.00,330.00,'{\"sku\":\"HS-122-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 3 Boxes)\"}','2024-02-24 01:33:03','2024-02-24 01:33:03'),(60,48,'Botble\\Ecommerce\\Models\\Product',77,'Organic Cage-Free Grade A Large Brown Eggs',NULL,'products/22.jpg',2,116.00,232.00,0.00,0.00,232.00,'{\"sku\":\"HS-178-A0\",\"attributes\":\"(Weight: 2KG, Boxes: 5 Boxes)\"}','2024-02-24 01:33:04','2024-02-24 01:33:04'),(61,49,'Botble\\Ecommerce\\Models\\Product',25,'Seeds of Change Organic Quinoe (Digital)',NULL,'products/1.jpg',2,391.00,782.00,0.00,0.00,782.00,'{\"sku\":\"HS-173-A0\",\"attributes\":\"(Boxes: 1 Box, Weight: 5KG)\"}','2024-02-24 01:33:04','2024-02-24 01:33:04'),(62,50,'Botble\\Ecommerce\\Models\\Product',66,'Simply Lemonade with Raspberry Juice',NULL,'products/19.jpg',1,112.00,112.00,0.00,0.00,112.00,'{\"sku\":\"HS-121-A0\",\"attributes\":\"(Boxes: 2 Boxes, Weight: 5KG)\"}','2024-02-24 01:33:05','2024-02-24 01:33:05');

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

CREATE TABLE `ec_invoices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `reference_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_tax_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_total` decimal(15,2) unsigned NOT NULL,
  `tax_amount` decimal(15,2) unsigned NOT NULL DEFAULT '0.00',
  `shipping_amount` decimal(15,2) unsigned NOT NULL DEFAULT '0.00',
  `discount_amount` decimal(15,2) unsigned NOT NULL DEFAULT '0.00',
  `shipping_option` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_method` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
  `coupon_code` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(15,2) unsigned NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `payment_id` bigint unsigned DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `paid_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_invoices_code_unique` (`code`),
  KEY `ec_invoices_reference_type_reference_id_index` (`reference_type`,`reference_id`),
  KEY `ec_invoices_payment_id_index` (`payment_id`),
  KEY `ec_invoices_status_index` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=51 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','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,1353.00,0.00,0.00,0.00,'1','default',NULL,NULL,1353.00,NULL,1,'completed','2024-02-24 01:32:49','2024-02-20 17:32:49','2024-02-24 01:32:49'),(2,'Botble\\Ecommerce\\Models\\Order',2,'INV-2','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,375.00,0.00,0.00,0.00,'1','default',NULL,NULL,375.00,NULL,2,'pending',NULL,'2024-02-09 01:32:49','2024-02-24 01:32:49'),(3,'Botble\\Ecommerce\\Models\\Order',3,'INV-3','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,121.00,0.00,0.00,0.00,'1','default',NULL,NULL,121.00,NULL,3,'completed','2024-02-24 01:32:50','2024-02-10 17:32:50','2024-02-24 01:32:50'),(4,'Botble\\Ecommerce\\Models\\Order',4,'INV-4','Prof. Rodrick Gorczany','',NULL,'laura.doyle@example.org','+13216127341','8963 Kassulke Parks, West Cecile, Mississippi, BQ',NULL,463.00,0.00,0.00,0.00,'1','default',NULL,NULL,463.00,NULL,4,'completed','2024-02-24 01:32:50','2024-02-16 03:32:50','2024-02-24 01:32:50'),(5,'Botble\\Ecommerce\\Models\\Order',5,'INV-5','Prof. Rodrick Gorczany','',NULL,'laura.doyle@example.org','+13216127341','8963 Kassulke Parks, West Cecile, Mississippi, BQ',NULL,357.00,0.00,0.00,0.00,NULL,'',NULL,NULL,357.00,NULL,5,'completed','2024-02-24 01:32:50','2024-02-09 19:32:50','2024-02-24 01:32:50'),(6,'Botble\\Ecommerce\\Models\\Order',6,'INV-6','Prof. Rodrick Gorczany','',NULL,'laura.doyle@example.org','+13216127341','8963 Kassulke Parks, West Cecile, Mississippi, BQ',NULL,330.00,0.00,0.00,0.00,'1','default',NULL,NULL,330.00,NULL,6,'completed','2024-02-24 01:32:50','2024-02-22 11:32:50','2024-02-24 01:32:50'),(7,'Botble\\Ecommerce\\Models\\Order',7,'INV-7','Mr. Davonte Borer','',NULL,'brandi79@example.com','+14148778317','7518 Swaniawski Gateway Suite 791, Padbergton, South Dakota, PL',NULL,342.00,0.00,0.00,0.00,'1','default',NULL,NULL,342.00,NULL,7,'completed','2024-02-24 01:32:51','2024-02-13 13:32:51','2024-02-24 01:32:51'),(8,'Botble\\Ecommerce\\Models\\Order',8,'INV-8','Mr. Davonte Borer','',NULL,'brandi79@example.com','+14148778317','7518 Swaniawski Gateway Suite 791, Padbergton, South Dakota, PL',NULL,129.00,0.00,0.00,0.00,'1','default',NULL,NULL,129.00,NULL,8,'completed','2024-02-24 01:32:51','2024-02-15 01:32:51','2024-02-24 01:32:51'),(9,'Botble\\Ecommerce\\Models\\Order',9,'INV-9','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,264.00,0.00,0.00,0.00,'1','default',NULL,NULL,264.00,NULL,9,'completed','2024-02-24 01:32:51','2024-02-11 07:32:51','2024-02-24 01:32:51'),(10,'Botble\\Ecommerce\\Models\\Order',10,'INV-10','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,436.00,0.00,0.00,0.00,'1','default',NULL,NULL,436.00,NULL,10,'completed','2024-02-24 01:32:51','2024-02-19 19:32:51','2024-02-24 01:32:51'),(11,'Botble\\Ecommerce\\Models\\Order',11,'INV-11','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,234.00,0.00,0.00,0.00,'1','default',NULL,NULL,234.00,NULL,11,'completed','2024-02-24 01:32:52','2024-02-12 17:32:52','2024-02-24 01:32:52'),(12,'Botble\\Ecommerce\\Models\\Order',12,'INV-12','Prof. Leo Hegmann Jr.','',NULL,'customer@botble.com','+17812399616','52589 Billie Unions, Sporerstad, Missouri, HN',NULL,228.00,0.00,0.00,0.00,'1','default',NULL,NULL,228.00,NULL,12,'completed','2024-02-24 01:32:52','2024-02-18 17:32:52','2024-02-24 01:32:52'),(13,'Botble\\Ecommerce\\Models\\Order',13,'INV-13','Prof. Leo Hegmann Jr.','',NULL,'customer@botble.com','+17812399616','52589 Billie Unions, Sporerstad, Missouri, HN',NULL,723.00,0.00,0.00,0.00,'1','default',NULL,NULL,723.00,NULL,13,'pending',NULL,'2024-02-10 17:32:52','2024-02-24 01:32:52'),(14,'Botble\\Ecommerce\\Models\\Order',14,'INV-14','Prof. Leo Hegmann Jr.','',NULL,'customer@botble.com','+17812399616','52589 Billie Unions, Sporerstad, Missouri, HN',NULL,782.00,0.00,0.00,0.00,NULL,'',NULL,NULL,782.00,NULL,14,'completed','2024-02-24 01:32:52','2024-02-19 01:32:52','2024-02-24 01:32:52'),(15,'Botble\\Ecommerce\\Models\\Order',15,'INV-15','Prof. Leo Hegmann Jr.','',NULL,'customer@botble.com','+17812399616','52589 Billie Unions, Sporerstad, Missouri, HN',NULL,774.00,0.00,0.00,0.00,'1','default',NULL,NULL,774.00,NULL,15,'completed','2024-02-24 01:32:53','2024-02-14 01:32:53','2024-02-24 01:32:53'),(16,'Botble\\Ecommerce\\Models\\Order',16,'INV-16','Prof. Leo Hegmann Jr.','',NULL,'customer@botble.com','+17812399616','52589 Billie Unions, Sporerstad, Missouri, HN',NULL,125.00,0.00,0.00,0.00,'1','default',NULL,NULL,125.00,NULL,16,'pending',NULL,'2024-02-11 13:32:53','2024-02-24 01:32:53'),(17,'Botble\\Ecommerce\\Models\\Order',17,'INV-17','Blair Robel V','',NULL,'pagac.alize@example.com','+12816311473','4811 Purdy Keys Suite 497, North Dariana, Missouri, NO',NULL,264.00,0.00,0.00,0.00,'1','default',NULL,NULL,264.00,NULL,17,'completed','2024-02-24 01:32:53','2024-02-21 17:32:53','2024-02-24 01:32:53'),(18,'Botble\\Ecommerce\\Models\\Order',18,'INV-18','Blair Robel V','',NULL,'pagac.alize@example.com','+12816311473','4811 Purdy Keys Suite 497, North Dariana, Missouri, NO',NULL,228.00,0.00,0.00,0.00,'1','default',NULL,NULL,228.00,NULL,18,'completed','2024-02-24 01:32:53','2024-02-22 21:32:53','2024-02-24 01:32:53'),(19,'Botble\\Ecommerce\\Models\\Order',19,'INV-19','Blair Robel V','',NULL,'pagac.alize@example.com','+12816311473','4811 Purdy Keys Suite 497, North Dariana, Missouri, NO',NULL,127.00,0.00,0.00,0.00,'1','default',NULL,NULL,127.00,NULL,19,'completed','2024-02-24 01:32:54','2024-02-14 17:32:54','2024-02-24 01:32:54'),(20,'Botble\\Ecommerce\\Models\\Order',20,'INV-20','Mr. Davonte Borer','',NULL,'brandi79@example.com','+14148778317','7518 Swaniawski Gateway Suite 791, Padbergton, South Dakota, PL',NULL,774.00,0.00,0.00,0.00,'1','default',NULL,NULL,774.00,NULL,20,'pending',NULL,'2024-02-14 07:32:54','2024-02-24 01:32:54'),(21,'Botble\\Ecommerce\\Models\\Order',21,'INV-21','Mr. Davonte Borer','',NULL,'brandi79@example.com','+14148778317','7518 Swaniawski Gateway Suite 791, Padbergton, South Dakota, PL',NULL,400.00,0.00,0.00,0.00,'1','default',NULL,NULL,400.00,NULL,21,'pending',NULL,'2024-02-14 07:32:54','2024-02-24 01:32:54'),(22,'Botble\\Ecommerce\\Models\\Order',22,'INV-22','Mr. Davonte Borer','',NULL,'brandi79@example.com','+14148778317','7518 Swaniawski Gateway Suite 791, Padbergton, South Dakota, PL',NULL,129.00,0.00,0.00,0.00,'1','default',NULL,NULL,129.00,NULL,22,'completed','2024-02-24 01:32:54','2024-02-13 05:32:54','2024-02-24 01:32:54'),(23,'Botble\\Ecommerce\\Models\\Order',23,'INV-23','Mr. Davonte Borer','',NULL,'brandi79@example.com','+14148778317','7518 Swaniawski Gateway Suite 791, Padbergton, South Dakota, PL',NULL,653.00,0.00,0.00,0.00,'1','default',NULL,NULL,653.00,NULL,23,'completed','2024-02-24 01:32:55','2024-02-20 01:32:55','2024-02-24 01:32:55'),(24,'Botble\\Ecommerce\\Models\\Order',24,'INV-24','Mr. Davonte Borer','',NULL,'brandi79@example.com','+14148778317','7518 Swaniawski Gateway Suite 791, Padbergton, South Dakota, PL',NULL,378.00,0.00,0.00,0.00,NULL,'',NULL,NULL,378.00,NULL,24,'completed','2024-02-24 01:32:55','2024-02-18 01:32:55','2024-02-24 01:32:55'),(25,'Botble\\Ecommerce\\Models\\Order',25,'INV-25','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,50.00,0.00,0.00,0.00,NULL,'',NULL,NULL,50.00,NULL,25,'pending',NULL,'2024-02-14 21:32:55','2024-02-24 01:32:55'),(26,'Botble\\Ecommerce\\Models\\Order',26,'INV-26','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,110.00,0.00,0.00,0.00,'1','default',NULL,NULL,110.00,NULL,26,'completed','2024-02-24 01:32:55','2024-02-21 07:32:55','2024-02-24 01:32:55'),(27,'Botble\\Ecommerce\\Models\\Order',27,'INV-27','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,232.00,0.00,0.00,0.00,'1','default',NULL,NULL,232.00,NULL,27,'completed','2024-02-24 01:32:55','2024-02-17 15:32:55','2024-02-24 01:32:55'),(28,'Botble\\Ecommerce\\Models\\Order',28,'INV-28','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,387.00,0.00,0.00,0.00,'1','default',NULL,NULL,387.00,NULL,28,'completed','2024-02-24 01:32:56','2024-02-16 13:32:56','2024-02-24 01:32:56'),(29,'Botble\\Ecommerce\\Models\\Order',29,'INV-29','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,350.00,0.00,0.00,0.00,'1','default',NULL,NULL,350.00,NULL,29,'pending',NULL,'2024-02-17 09:32:56','2024-02-24 01:32:56'),(30,'Botble\\Ecommerce\\Models\\Order',30,'INV-30','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,2616.00,0.00,0.00,0.00,'1','default',NULL,NULL,2616.00,NULL,30,'pending',NULL,'2024-02-17 07:32:56','2024-02-24 01:32:56'),(31,'Botble\\Ecommerce\\Models\\Order',31,'INV-31','Mr. Davonte Borer','',NULL,'brandi79@example.com','+14148778317','7518 Swaniawski Gateway Suite 791, Padbergton, South Dakota, PL',NULL,386.00,0.00,0.00,0.00,'1','default',NULL,NULL,386.00,NULL,31,'completed','2024-02-24 01:32:56','2024-02-17 09:32:56','2024-02-24 01:32:56'),(32,'Botble\\Ecommerce\\Models\\Order',32,'INV-32','Mr. Davonte Borer','',NULL,'brandi79@example.com','+14148778317','7518 Swaniawski Gateway Suite 791, Padbergton, South Dakota, PL',NULL,1500.00,0.00,0.00,0.00,'1','default',NULL,NULL,1500.00,NULL,32,'completed','2024-02-24 01:32:57','2024-02-17 09:32:57','2024-02-24 01:32:57'),(33,'Botble\\Ecommerce\\Models\\Order',33,'INV-33','Mr. Davonte Borer','',NULL,'brandi79@example.com','+14148778317','7518 Swaniawski Gateway Suite 791, Padbergton, South Dakota, PL',NULL,127.00,0.00,0.00,0.00,'1','default',NULL,NULL,127.00,NULL,33,'completed','2024-02-24 01:32:57','2024-02-22 17:32:57','2024-02-24 01:32:57'),(34,'Botble\\Ecommerce\\Models\\Order',34,'INV-34','Blair Robel V','',NULL,'pagac.alize@example.com','+12816311473','4811 Purdy Keys Suite 497, North Dariana, Missouri, NO',NULL,546.00,0.00,0.00,0.00,'1','default',NULL,NULL,546.00,NULL,34,'pending',NULL,'2024-02-22 07:32:57','2024-02-24 01:32:57'),(35,'Botble\\Ecommerce\\Models\\Order',35,'INV-35','Blair Robel V','',NULL,'pagac.alize@example.com','+12816311473','4811 Purdy Keys Suite 497, North Dariana, Missouri, NO',NULL,346.00,0.00,0.00,0.00,'1','default',NULL,NULL,346.00,NULL,35,'pending',NULL,'2024-02-19 09:32:57','2024-02-24 01:32:57'),(36,'Botble\\Ecommerce\\Models\\Order',36,'INV-36','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,387.00,0.00,0.00,0.00,'1','default',NULL,NULL,387.00,NULL,36,'pending',NULL,'2024-02-21 13:32:58','2024-02-24 01:32:58'),(37,'Botble\\Ecommerce\\Models\\Order',37,'INV-37','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,348.00,0.00,0.00,0.00,'1','default',NULL,NULL,348.00,NULL,37,'completed','2024-02-24 01:32:58','2024-02-22 01:32:58','2024-02-24 01:32:58'),(38,'Botble\\Ecommerce\\Models\\Order',38,'INV-38','Prof. Rodrick Gorczany','',NULL,'laura.doyle@example.org','+13216127341','8963 Kassulke Parks, West Cecile, Mississippi, BQ',NULL,117.00,0.00,0.00,0.00,'1','default',NULL,NULL,117.00,NULL,38,'pending',NULL,'2024-02-23 15:32:59','2024-02-24 01:32:59'),(39,'Botble\\Ecommerce\\Models\\Order',39,'INV-39','Prof. Rodrick Gorczany','',NULL,'laura.doyle@example.org','+13216127341','8963 Kassulke Parks, West Cecile, Mississippi, BQ',NULL,127.00,0.00,0.00,0.00,'1','default',NULL,NULL,127.00,NULL,39,'completed','2024-02-24 01:32:59','2024-02-20 17:32:59','2024-02-24 01:32:59'),(40,'Botble\\Ecommerce\\Models\\Order',40,'INV-40','Blair Robel V','',NULL,'pagac.alize@example.com','+12816311473','4811 Purdy Keys Suite 497, North Dariana, Missouri, NO',NULL,50.00,0.00,0.00,0.00,NULL,'',NULL,NULL,50.00,NULL,40,'pending',NULL,'2024-02-21 17:33:00','2024-02-24 01:33:00'),(41,'Botble\\Ecommerce\\Models\\Order',41,'INV-41','Blair Robel V','',NULL,'pagac.alize@example.com','+12816311473','4811 Purdy Keys Suite 497, North Dariana, Missouri, NO',NULL,117.00,0.00,0.00,0.00,'1','default',NULL,NULL,117.00,NULL,41,'completed','2024-02-24 01:33:00','2024-02-22 01:33:00','2024-02-24 01:33:00'),(42,'Botble\\Ecommerce\\Models\\Order',42,'INV-42','Blair Robel V','',NULL,'pagac.alize@example.com','+12816311473','4811 Purdy Keys Suite 497, North Dariana, Missouri, NO',NULL,252.00,0.00,0.00,0.00,NULL,'',NULL,NULL,252.00,NULL,42,'completed','2024-02-24 01:33:01','2024-02-23 01:33:01','2024-02-24 01:33:01'),(43,'Botble\\Ecommerce\\Models\\Order',43,'INV-43','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,176.00,0.00,0.00,0.00,'1','default',NULL,NULL,176.00,NULL,43,'completed','2024-02-24 01:33:01','2024-02-22 07:33:01','2024-02-24 01:33:01'),(44,'Botble\\Ecommerce\\Models\\Order',44,'INV-44','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,1000.00,0.00,0.00,0.00,'1','default',NULL,NULL,1000.00,NULL,44,'completed','2024-02-24 01:33:02','2024-02-23 01:33:02','2024-02-24 01:33:02'),(45,'Botble\\Ecommerce\\Models\\Order',45,'INV-45','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,250.00,0.00,0.00,0.00,'1','default',NULL,NULL,250.00,NULL,45,'completed','2024-02-24 01:33:02','2024-02-23 07:33:02','2024-02-24 01:33:02'),(46,'Botble\\Ecommerce\\Models\\Order',46,'INV-46','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,224.00,0.00,0.00,0.00,NULL,'',NULL,NULL,224.00,NULL,46,'completed','2024-02-24 01:33:03','2024-02-23 21:33:03','2024-02-24 01:33:03'),(47,'Botble\\Ecommerce\\Models\\Order',47,'INV-47','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,330.00,0.00,0.00,0.00,'1','default',NULL,NULL,330.00,NULL,47,'completed','2024-02-24 01:33:03','2024-02-22 21:33:03','2024-02-24 01:33:03'),(48,'Botble\\Ecommerce\\Models\\Order',48,'INV-48','Miss Callie Zboncak','',NULL,'nhilpert@example.org','+19082025793','891 Jarrett Stravenue, Gretaborough, California, RW',NULL,232.00,0.00,0.00,0.00,'1','default',NULL,NULL,232.00,NULL,48,'completed','2024-02-24 01:33:04','2024-02-23 21:33:04','2024-02-24 01:33:04'),(49,'Botble\\Ecommerce\\Models\\Order',49,'INV-49','Mr. Davonte Borer','',NULL,'brandi79@example.com','+14148778317','7518 Swaniawski Gateway Suite 791, Padbergton, South Dakota, PL',NULL,782.00,0.00,0.00,0.00,NULL,'',NULL,NULL,782.00,NULL,49,'pending',NULL,'2024-02-23 05:33:04','2024-02-24 01:33:04'),(50,'Botble\\Ecommerce\\Models\\Order',50,'INV-50','Mr. Davonte Borer','',NULL,'brandi79@example.com','+14148778317','7518 Swaniawski Gateway Suite 791, Padbergton, South Dakota, PL',NULL,112.00,0.00,0.00,0.00,'1','default',NULL,NULL,112.00,NULL,50,'completed','2024-02-24 01:33:05','2024-02-23 05:33:04','2024-02-24 01:33:05');

--
-- 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(191) 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(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of options',
  `option_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'option type',
  `product_id` bigint 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(191) 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(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_id` 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=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_order_addresses` VALUES (1,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',1,'97406','shipping_address'),(2,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',2,'97406','shipping_address'),(3,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',3,'97406','shipping_address'),(4,'Prof. Rodrick Gorczany','+13216127341','laura.doyle@example.org','BQ','Mississippi','West Cecile','8963 Kassulke Parks',4,'23183','shipping_address'),(5,'Prof. Rodrick Gorczany','+13216127341','laura.doyle@example.org','BQ','Mississippi','West Cecile','8963 Kassulke Parks',5,'23183','shipping_address'),(6,'Prof. Rodrick Gorczany','+13216127341','laura.doyle@example.org','BQ','Mississippi','West Cecile','8963 Kassulke Parks',6,'23183','shipping_address'),(7,'Mr. Davonte Borer','+14148778317','brandi79@example.com','PL','South Dakota','Padbergton','7518 Swaniawski Gateway Suite 791',7,'10001','shipping_address'),(8,'Mr. Davonte Borer','+14148778317','brandi79@example.com','PL','South Dakota','Padbergton','7518 Swaniawski Gateway Suite 791',8,'10001','shipping_address'),(9,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',9,'97406','shipping_address'),(10,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',10,'97406','shipping_address'),(11,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',11,'97406','shipping_address'),(12,'Prof. Leo Hegmann Jr.','+17812399616','customer@botble.com','HN','Missouri','Sporerstad','52589 Billie Unions',12,'86000-8745','shipping_address'),(13,'Prof. Leo Hegmann Jr.','+17812399616','customer@botble.com','HN','Missouri','Sporerstad','52589 Billie Unions',13,'86000-8745','shipping_address'),(14,'Prof. Leo Hegmann Jr.','+17812399616','customer@botble.com','HN','Missouri','Sporerstad','52589 Billie Unions',14,'86000-8745','shipping_address'),(15,'Prof. Leo Hegmann Jr.','+17812399616','customer@botble.com','HN','Missouri','Sporerstad','52589 Billie Unions',15,'86000-8745','shipping_address'),(16,'Prof. Leo Hegmann Jr.','+17812399616','customer@botble.com','HN','Missouri','Sporerstad','52589 Billie Unions',16,'86000-8745','shipping_address'),(17,'Blair Robel V','+12816311473','pagac.alize@example.com','NO','Missouri','North Dariana','4811 Purdy Keys Suite 497',17,'08901','shipping_address'),(18,'Blair Robel V','+12816311473','pagac.alize@example.com','NO','Missouri','North Dariana','4811 Purdy Keys Suite 497',18,'08901','shipping_address'),(19,'Blair Robel V','+12816311473','pagac.alize@example.com','NO','Missouri','North Dariana','4811 Purdy Keys Suite 497',19,'08901','shipping_address'),(20,'Mr. Davonte Borer','+14148778317','brandi79@example.com','PL','South Dakota','Padbergton','7518 Swaniawski Gateway Suite 791',20,'10001','shipping_address'),(21,'Mr. Davonte Borer','+14148778317','brandi79@example.com','PL','South Dakota','Padbergton','7518 Swaniawski Gateway Suite 791',21,'10001','shipping_address'),(22,'Mr. Davonte Borer','+14148778317','brandi79@example.com','PL','South Dakota','Padbergton','7518 Swaniawski Gateway Suite 791',22,'10001','shipping_address'),(23,'Mr. Davonte Borer','+14148778317','brandi79@example.com','PL','South Dakota','Padbergton','7518 Swaniawski Gateway Suite 791',23,'10001','shipping_address'),(24,'Mr. Davonte Borer','+14148778317','brandi79@example.com','PL','South Dakota','Padbergton','7518 Swaniawski Gateway Suite 791',24,'10001','shipping_address'),(25,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',25,'97406','shipping_address'),(26,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',26,'97406','shipping_address'),(27,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',27,'97406','shipping_address'),(28,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',28,'97406','shipping_address'),(29,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',29,'97406','shipping_address'),(30,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',30,'97406','shipping_address'),(31,'Mr. Davonte Borer','+14148778317','brandi79@example.com','PL','South Dakota','Padbergton','7518 Swaniawski Gateway Suite 791',31,'10001','shipping_address'),(32,'Mr. Davonte Borer','+14148778317','brandi79@example.com','PL','South Dakota','Padbergton','7518 Swaniawski Gateway Suite 791',32,'10001','shipping_address'),(33,'Mr. Davonte Borer','+14148778317','brandi79@example.com','PL','South Dakota','Padbergton','7518 Swaniawski Gateway Suite 791',33,'10001','shipping_address'),(34,'Blair Robel V','+12816311473','pagac.alize@example.com','NO','Missouri','North Dariana','4811 Purdy Keys Suite 497',34,'08901','shipping_address'),(35,'Blair Robel V','+12816311473','pagac.alize@example.com','NO','Missouri','North Dariana','4811 Purdy Keys Suite 497',35,'08901','shipping_address'),(36,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',36,'97406','shipping_address'),(37,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',37,'97406','shipping_address'),(38,'Prof. Rodrick Gorczany','+13216127341','laura.doyle@example.org','BQ','Mississippi','West Cecile','8963 Kassulke Parks',38,'23183','shipping_address'),(39,'Prof. Rodrick Gorczany','+13216127341','laura.doyle@example.org','BQ','Mississippi','West Cecile','8963 Kassulke Parks',39,'23183','shipping_address'),(40,'Blair Robel V','+12816311473','pagac.alize@example.com','NO','Missouri','North Dariana','4811 Purdy Keys Suite 497',40,'08901','shipping_address'),(41,'Blair Robel V','+12816311473','pagac.alize@example.com','NO','Missouri','North Dariana','4811 Purdy Keys Suite 497',41,'08901','shipping_address'),(42,'Blair Robel V','+12816311473','pagac.alize@example.com','NO','Missouri','North Dariana','4811 Purdy Keys Suite 497',42,'08901','shipping_address'),(43,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',43,'97406','shipping_address'),(44,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',44,'97406','shipping_address'),(45,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',45,'97406','shipping_address'),(46,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',46,'97406','shipping_address'),(47,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',47,'97406','shipping_address'),(48,'Miss Callie Zboncak','+19082025793','nhilpert@example.org','RW','California','Gretaborough','891 Jarrett Stravenue',48,'97406','shipping_address'),(49,'Mr. Davonte Borer','+14148778317','brandi79@example.com','PL','South Dakota','Padbergton','7518 Swaniawski Gateway Suite 791',49,'10001','shipping_address'),(50,'Mr. Davonte Borer','+14148778317','brandi79@example.com','PL','South Dakota','Padbergton','7518 Swaniawski Gateway Suite 791',50,'10001','shipping_address');

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

CREATE TABLE `ec_order_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `action` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` 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=214 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-20 17:32:49','2024-02-20 17:32:49'),(2,'confirm_order','Order was verified by %user_name%',0,1,NULL,'2024-02-20 17:32:49','2024-02-20 17:32:49'),(3,'confirm_payment','Payment was confirmed (amount $1,353.00) by %user_name%',0,1,NULL,'2024-02-24 01:32:49','2024-02-24 01:32:49'),(4,'create_shipment','Created shipment for order',0,1,NULL,'2024-02-24 01:32:49','2024-02-24 01:32:49'),(5,'create_order_from_seeder','Order is created from the checkout page',NULL,2,NULL,'2024-02-09 01:32:49','2024-02-09 01:32:49'),(6,'confirm_order','Order was verified by %user_name%',0,2,NULL,'2024-02-09 01:32:49','2024-02-09 01:32:49'),(7,'create_shipment','Created shipment for order',0,2,NULL,'2024-02-24 01:32:50','2024-02-24 01:32:50'),(8,'create_order_from_seeder','Order is created from the checkout page',NULL,3,NULL,'2024-02-10 17:32:50','2024-02-10 17:32:50'),(9,'confirm_order','Order was verified by %user_name%',0,3,NULL,'2024-02-10 17:32:50','2024-02-10 17:32:50'),(10,'confirm_payment','Payment was confirmed (amount $121.00) by %user_name%',0,3,NULL,'2024-02-24 01:32:50','2024-02-24 01:32:50'),(11,'create_shipment','Created shipment for order',0,3,NULL,'2024-02-24 01:32:50','2024-02-24 01:32:50'),(12,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,3,NULL,'2024-02-24 01:32:50','2024-02-24 01:32:50'),(13,'create_order_from_seeder','Order is created from the checkout page',NULL,4,NULL,'2024-02-16 03:32:50','2024-02-16 03:32:50'),(14,'confirm_order','Order was verified by %user_name%',0,4,NULL,'2024-02-16 03:32:50','2024-02-16 03:32:50'),(15,'confirm_payment','Payment was confirmed (amount $463.00) by %user_name%',0,4,NULL,'2024-02-24 01:32:50','2024-02-24 01:32:50'),(16,'create_shipment','Created shipment for order',0,4,NULL,'2024-02-24 01:32:50','2024-02-24 01:32:50'),(17,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,4,NULL,'2024-02-24 01:32:50','2024-02-24 01:32:50'),(18,'create_order_from_seeder','Order is created from the checkout page',NULL,5,NULL,'2024-02-09 19:32:50','2024-02-09 19:32:50'),(19,'confirm_order','Order was verified by %user_name%',0,5,NULL,'2024-02-09 19:32:50','2024-02-09 19:32:50'),(20,'confirm_payment','Payment was confirmed (amount $357.00) by %user_name%',0,5,NULL,'2024-02-24 01:32:50','2024-02-24 01:32:50'),(21,'update_status','Changed status of shipping to: . Updated by: %user_name%',0,5,NULL,'2024-02-24 01:32:50','2024-02-24 01:32:50'),(22,'create_order_from_seeder','Order is created from the checkout page',NULL,6,NULL,'2024-02-22 11:32:50','2024-02-22 11:32:50'),(23,'confirm_order','Order was verified by %user_name%',0,6,NULL,'2024-02-22 11:32:50','2024-02-22 11:32:50'),(24,'confirm_payment','Payment was confirmed (amount $330.00) by %user_name%',0,6,NULL,'2024-02-24 01:32:50','2024-02-24 01:32:50'),(25,'create_shipment','Created shipment for order',0,6,NULL,'2024-02-24 01:32:51','2024-02-24 01:32:51'),(26,'create_order_from_seeder','Order is created from the checkout page',NULL,7,NULL,'2024-02-13 13:32:51','2024-02-13 13:32:51'),(27,'confirm_order','Order was verified by %user_name%',0,7,NULL,'2024-02-13 13:32:51','2024-02-13 13:32:51'),(28,'confirm_payment','Payment was confirmed (amount $342.00) by %user_name%',0,7,NULL,'2024-02-24 01:32:51','2024-02-24 01:32:51'),(29,'create_shipment','Created shipment for order',0,7,NULL,'2024-02-24 01:32:51','2024-02-24 01:32:51'),(30,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,7,NULL,'2024-02-24 01:32:51','2024-02-24 01:32:51'),(31,'create_order_from_seeder','Order is created from the checkout page',NULL,8,NULL,'2024-02-15 01:32:51','2024-02-15 01:32:51'),(32,'confirm_order','Order was verified by %user_name%',0,8,NULL,'2024-02-15 01:32:51','2024-02-15 01:32:51'),(33,'confirm_payment','Payment was confirmed (amount $129.00) by %user_name%',0,8,NULL,'2024-02-24 01:32:51','2024-02-24 01:32:51'),(34,'create_shipment','Created shipment for order',0,8,NULL,'2024-02-24 01:32:51','2024-02-24 01:32:51'),(35,'create_order_from_seeder','Order is created from the checkout page',NULL,9,NULL,'2024-02-11 07:32:51','2024-02-11 07:32:51'),(36,'confirm_order','Order was verified by %user_name%',0,9,NULL,'2024-02-11 07:32:51','2024-02-11 07:32:51'),(37,'confirm_payment','Payment was confirmed (amount $264.00) by %user_name%',0,9,NULL,'2024-02-24 01:32:51','2024-02-24 01:32:51'),(38,'create_shipment','Created shipment for order',0,9,NULL,'2024-02-24 01:32:51','2024-02-24 01:32:51'),(39,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,9,NULL,'2024-02-24 01:32:51','2024-02-24 01:32:51'),(40,'create_order_from_seeder','Order is created from the checkout page',NULL,10,NULL,'2024-02-19 19:32:51','2024-02-19 19:32:51'),(41,'confirm_order','Order was verified by %user_name%',0,10,NULL,'2024-02-19 19:32:51','2024-02-19 19:32:51'),(42,'confirm_payment','Payment was confirmed (amount $436.00) by %user_name%',0,10,NULL,'2024-02-24 01:32:51','2024-02-24 01:32:51'),(43,'create_shipment','Created shipment for order',0,10,NULL,'2024-02-24 01:32:52','2024-02-24 01:32:52'),(44,'create_order_from_seeder','Order is created from the checkout page',NULL,11,NULL,'2024-02-12 17:32:52','2024-02-12 17:32:52'),(45,'confirm_order','Order was verified by %user_name%',0,11,NULL,'2024-02-12 17:32:52','2024-02-12 17:32:52'),(46,'confirm_payment','Payment was confirmed (amount $234.00) by %user_name%',0,11,NULL,'2024-02-24 01:32:52','2024-02-24 01:32:52'),(47,'create_shipment','Created shipment for order',0,11,NULL,'2024-02-24 01:32:52','2024-02-24 01:32:52'),(48,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,11,NULL,'2024-02-24 01:32:52','2024-02-24 01:32:52'),(49,'create_order_from_seeder','Order is created from the checkout page',NULL,12,NULL,'2024-02-18 17:32:52','2024-02-18 17:32:52'),(50,'confirm_order','Order was verified by %user_name%',0,12,NULL,'2024-02-18 17:32:52','2024-02-18 17:32:52'),(51,'confirm_payment','Payment was confirmed (amount $228.00) by %user_name%',0,12,NULL,'2024-02-24 01:32:52','2024-02-24 01:32:52'),(52,'create_shipment','Created shipment for order',0,12,NULL,'2024-02-24 01:32:52','2024-02-24 01:32:52'),(53,'create_order_from_seeder','Order is created from the checkout page',NULL,13,NULL,'2024-02-10 17:32:52','2024-02-10 17:32:52'),(54,'confirm_order','Order was verified by %user_name%',0,13,NULL,'2024-02-10 17:32:52','2024-02-10 17:32:52'),(55,'create_shipment','Created shipment for order',0,13,NULL,'2024-02-24 01:32:52','2024-02-24 01:32:52'),(56,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,13,NULL,'2024-02-24 01:32:52','2024-02-24 01:32:52'),(57,'create_order_from_seeder','Order is created from the checkout page',NULL,14,NULL,'2024-02-19 01:32:52','2024-02-19 01:32:52'),(58,'confirm_order','Order was verified by %user_name%',0,14,NULL,'2024-02-19 01:32:52','2024-02-19 01:32:52'),(59,'confirm_payment','Payment was confirmed (amount $782.00) by %user_name%',0,14,NULL,'2024-02-24 01:32:52','2024-02-24 01:32:52'),(60,'update_status','Changed status of shipping to: . Updated by: %user_name%',0,14,NULL,'2024-02-24 01:32:53','2024-02-24 01:32:53'),(61,'create_order_from_seeder','Order is created from the checkout page',NULL,15,NULL,'2024-02-14 01:32:53','2024-02-14 01:32:53'),(62,'confirm_order','Order was verified by %user_name%',0,15,NULL,'2024-02-14 01:32:53','2024-02-14 01:32:53'),(63,'confirm_payment','Payment was confirmed (amount $774.00) by %user_name%',0,15,NULL,'2024-02-24 01:32:53','2024-02-24 01:32:53'),(64,'create_shipment','Created shipment for order',0,15,NULL,'2024-02-24 01:32:53','2024-02-24 01:32:53'),(65,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,15,NULL,'2024-02-24 01:32:53','2024-02-24 01:32:53'),(66,'create_order_from_seeder','Order is created from the checkout page',NULL,16,NULL,'2024-02-11 13:32:53','2024-02-11 13:32:53'),(67,'confirm_order','Order was verified by %user_name%',0,16,NULL,'2024-02-11 13:32:53','2024-02-11 13:32:53'),(68,'create_shipment','Created shipment for order',0,16,NULL,'2024-02-24 01:32:53','2024-02-24 01:32:53'),(69,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,16,NULL,'2024-02-24 01:32:53','2024-02-24 01:32:53'),(70,'create_order_from_seeder','Order is created from the checkout page',NULL,17,NULL,'2024-02-21 17:32:53','2024-02-21 17:32:53'),(71,'confirm_order','Order was verified by %user_name%',0,17,NULL,'2024-02-21 17:32:53','2024-02-21 17:32:53'),(72,'confirm_payment','Payment was confirmed (amount $264.00) by %user_name%',0,17,NULL,'2024-02-24 01:32:53','2024-02-24 01:32:53'),(73,'create_shipment','Created shipment for order',0,17,NULL,'2024-02-24 01:32:53','2024-02-24 01:32:53'),(74,'create_order_from_seeder','Order is created from the checkout page',NULL,18,NULL,'2024-02-22 21:32:53','2024-02-22 21:32:53'),(75,'confirm_order','Order was verified by %user_name%',0,18,NULL,'2024-02-22 21:32:53','2024-02-22 21:32:53'),(76,'confirm_payment','Payment was confirmed (amount $228.00) by %user_name%',0,18,NULL,'2024-02-24 01:32:53','2024-02-24 01:32:53'),(77,'create_shipment','Created shipment for order',0,18,NULL,'2024-02-24 01:32:54','2024-02-24 01:32:54'),(78,'create_order_from_seeder','Order is created from the checkout page',NULL,19,NULL,'2024-02-14 17:32:54','2024-02-14 17:32:54'),(79,'confirm_order','Order was verified by %user_name%',0,19,NULL,'2024-02-14 17:32:54','2024-02-14 17:32:54'),(80,'confirm_payment','Payment was confirmed (amount $127.00) by %user_name%',0,19,NULL,'2024-02-24 01:32:54','2024-02-24 01:32:54'),(81,'create_shipment','Created shipment for order',0,19,NULL,'2024-02-24 01:32:54','2024-02-24 01:32:54'),(82,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,19,NULL,'2024-02-24 01:32:54','2024-02-24 01:32:54'),(83,'create_order_from_seeder','Order is created from the checkout page',NULL,20,NULL,'2024-02-14 07:32:54','2024-02-14 07:32:54'),(84,'confirm_order','Order was verified by %user_name%',0,20,NULL,'2024-02-14 07:32:54','2024-02-14 07:32:54'),(85,'create_shipment','Created shipment for order',0,20,NULL,'2024-02-24 01:32:54','2024-02-24 01:32:54'),(86,'create_order_from_seeder','Order is created from the checkout page',NULL,21,NULL,'2024-02-14 07:32:54','2024-02-14 07:32:54'),(87,'confirm_order','Order was verified by %user_name%',0,21,NULL,'2024-02-14 07:32:54','2024-02-14 07:32:54'),(88,'create_shipment','Created shipment for order',0,21,NULL,'2024-02-24 01:32:54','2024-02-24 01:32:54'),(89,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,21,NULL,'2024-02-24 01:32:54','2024-02-24 01:32:54'),(90,'create_order_from_seeder','Order is created from the checkout page',NULL,22,NULL,'2024-02-13 05:32:54','2024-02-13 05:32:54'),(91,'confirm_order','Order was verified by %user_name%',0,22,NULL,'2024-02-13 05:32:54','2024-02-13 05:32:54'),(92,'confirm_payment','Payment was confirmed (amount $129.00) by %user_name%',0,22,NULL,'2024-02-24 01:32:54','2024-02-24 01:32:54'),(93,'create_shipment','Created shipment for order',0,22,NULL,'2024-02-24 01:32:55','2024-02-24 01:32:55'),(94,'create_order_from_seeder','Order is created from the checkout page',NULL,23,NULL,'2024-02-20 01:32:55','2024-02-20 01:32:55'),(95,'confirm_order','Order was verified by %user_name%',0,23,NULL,'2024-02-20 01:32:55','2024-02-20 01:32:55'),(96,'confirm_payment','Payment was confirmed (amount $653.00) by %user_name%',0,23,NULL,'2024-02-24 01:32:55','2024-02-24 01:32:55'),(97,'create_shipment','Created shipment for order',0,23,NULL,'2024-02-24 01:32:55','2024-02-24 01:32:55'),(98,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,23,NULL,'2024-02-24 01:32:55','2024-02-24 01:32:55'),(99,'create_order_from_seeder','Order is created from the checkout page',NULL,24,NULL,'2024-02-18 01:32:55','2024-02-18 01:32:55'),(100,'confirm_order','Order was verified by %user_name%',0,24,NULL,'2024-02-18 01:32:55','2024-02-18 01:32:55'),(101,'confirm_payment','Payment was confirmed (amount $378.00) by %user_name%',0,24,NULL,'2024-02-24 01:32:55','2024-02-24 01:32:55'),(102,'update_status','Changed status of shipping to: . Updated by: %user_name%',0,24,NULL,'2024-02-24 01:32:55','2024-02-24 01:32:55'),(103,'create_order_from_seeder','Order is created from the checkout page',NULL,25,NULL,'2024-02-14 21:32:55','2024-02-14 21:32:55'),(104,'confirm_order','Order was verified by %user_name%',0,25,NULL,'2024-02-14 21:32:55','2024-02-14 21:32:55'),(105,'create_order_from_seeder','Order is created from the checkout page',NULL,26,NULL,'2024-02-21 07:32:55','2024-02-21 07:32:55'),(106,'confirm_order','Order was verified by %user_name%',0,26,NULL,'2024-02-21 07:32:55','2024-02-21 07:32:55'),(107,'confirm_payment','Payment was confirmed (amount $110.00) by %user_name%',0,26,NULL,'2024-02-24 01:32:55','2024-02-24 01:32:55'),(108,'create_shipment','Created shipment for order',0,26,NULL,'2024-02-24 01:32:55','2024-02-24 01:32:55'),(109,'create_order_from_seeder','Order is created from the checkout page',NULL,27,NULL,'2024-02-17 15:32:55','2024-02-17 15:32:55'),(110,'confirm_order','Order was verified by %user_name%',0,27,NULL,'2024-02-17 15:32:55','2024-02-17 15:32:55'),(111,'confirm_payment','Payment was confirmed (amount $232.00) by %user_name%',0,27,NULL,'2024-02-24 01:32:55','2024-02-24 01:32:55'),(112,'create_shipment','Created shipment for order',0,27,NULL,'2024-02-24 01:32:56','2024-02-24 01:32:56'),(113,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,27,NULL,'2024-02-24 01:32:56','2024-02-24 01:32:56'),(114,'create_order_from_seeder','Order is created from the checkout page',NULL,28,NULL,'2024-02-16 13:32:56','2024-02-16 13:32:56'),(115,'confirm_order','Order was verified by %user_name%',0,28,NULL,'2024-02-16 13:32:56','2024-02-16 13:32:56'),(116,'confirm_payment','Payment was confirmed (amount $387.00) by %user_name%',0,28,NULL,'2024-02-24 01:32:56','2024-02-24 01:32:56'),(117,'create_shipment','Created shipment for order',0,28,NULL,'2024-02-24 01:32:56','2024-02-24 01:32:56'),(118,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,28,NULL,'2024-02-24 01:32:56','2024-02-24 01:32:56'),(119,'create_order_from_seeder','Order is created from the checkout page',NULL,29,NULL,'2024-02-17 09:32:56','2024-02-17 09:32:56'),(120,'confirm_order','Order was verified by %user_name%',0,29,NULL,'2024-02-17 09:32:56','2024-02-17 09:32:56'),(121,'create_shipment','Created shipment for order',0,29,NULL,'2024-02-24 01:32:56','2024-02-24 01:32:56'),(122,'create_order_from_seeder','Order is created from the checkout page',NULL,30,NULL,'2024-02-17 07:32:56','2024-02-17 07:32:56'),(123,'confirm_order','Order was verified by %user_name%',0,30,NULL,'2024-02-17 07:32:56','2024-02-17 07:32:56'),(124,'create_shipment','Created shipment for order',0,30,NULL,'2024-02-24 01:32:56','2024-02-24 01:32:56'),(125,'create_order_from_seeder','Order is created from the checkout page',NULL,31,NULL,'2024-02-17 09:32:56','2024-02-17 09:32:56'),(126,'confirm_order','Order was verified by %user_name%',0,31,NULL,'2024-02-17 09:32:56','2024-02-17 09:32:56'),(127,'confirm_payment','Payment was confirmed (amount $386.00) by %user_name%',0,31,NULL,'2024-02-24 01:32:56','2024-02-24 01:32:56'),(128,'create_shipment','Created shipment for order',0,31,NULL,'2024-02-24 01:32:57','2024-02-24 01:32:57'),(129,'create_order_from_seeder','Order is created from the checkout page',NULL,32,NULL,'2024-02-17 09:32:57','2024-02-17 09:32:57'),(130,'confirm_order','Order was verified by %user_name%',0,32,NULL,'2024-02-17 09:32:57','2024-02-17 09:32:57'),(131,'confirm_payment','Payment was confirmed (amount $1,500.00) by %user_name%',0,32,NULL,'2024-02-24 01:32:57','2024-02-24 01:32:57'),(132,'create_shipment','Created shipment for order',0,32,NULL,'2024-02-24 01:32:57','2024-02-24 01:32:57'),(133,'create_order_from_seeder','Order is created from the checkout page',NULL,33,NULL,'2024-02-22 17:32:57','2024-02-22 17:32:57'),(134,'confirm_order','Order was verified by %user_name%',0,33,NULL,'2024-02-22 17:32:57','2024-02-22 17:32:57'),(135,'confirm_payment','Payment was confirmed (amount $127.00) by %user_name%',0,33,NULL,'2024-02-24 01:32:57','2024-02-24 01:32:57'),(136,'create_shipment','Created shipment for order',0,33,NULL,'2024-02-24 01:32:57','2024-02-24 01:32:57'),(137,'create_order_from_seeder','Order is created from the checkout page',NULL,34,NULL,'2024-02-22 07:32:57','2024-02-22 07:32:57'),(138,'confirm_order','Order was verified by %user_name%',0,34,NULL,'2024-02-22 07:32:57','2024-02-22 07:32:57'),(139,'create_shipment','Created shipment for order',0,34,NULL,'2024-02-24 01:32:57','2024-02-24 01:32:57'),(140,'create_order_from_seeder','Order is created from the checkout page',NULL,35,NULL,'2024-02-19 09:32:57','2024-02-19 09:32:57'),(141,'confirm_order','Order was verified by %user_name%',0,35,NULL,'2024-02-19 09:32:57','2024-02-19 09:32:57'),(142,'create_shipment','Created shipment for order',0,35,NULL,'2024-02-24 01:32:58','2024-02-24 01:32:58'),(143,'create_order_from_seeder','Order is created from the checkout page',NULL,36,NULL,'2024-02-21 13:32:58','2024-02-21 13:32:58'),(144,'confirm_order','Order was verified by %user_name%',0,36,NULL,'2024-02-21 13:32:58','2024-02-21 13:32:58'),(145,'create_shipment','Created shipment for order',0,36,NULL,'2024-02-24 01:32:58','2024-02-24 01:32:58'),(146,'create_order_from_seeder','Order is created from the checkout page',NULL,37,NULL,'2024-02-22 01:32:58','2024-02-22 01:32:58'),(147,'confirm_order','Order was verified by %user_name%',0,37,NULL,'2024-02-22 01:32:58','2024-02-22 01:32:58'),(148,'confirm_payment','Payment was confirmed (amount $348.00) by %user_name%',0,37,NULL,'2024-02-24 01:32:58','2024-02-24 01:32:58'),(149,'create_shipment','Created shipment for order',0,37,NULL,'2024-02-24 01:32:59','2024-02-24 01:32:59'),(150,'create_order_from_seeder','Order is created from the checkout page',NULL,38,NULL,'2024-02-23 15:32:59','2024-02-23 15:32:59'),(151,'confirm_order','Order was verified by %user_name%',0,38,NULL,'2024-02-23 15:32:59','2024-02-23 15:32:59'),(152,'create_shipment','Created shipment for order',0,38,NULL,'2024-02-24 01:32:59','2024-02-24 01:32:59'),(153,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,38,NULL,'2024-02-24 01:32:59','2024-02-24 01:32:59'),(154,'create_order_from_seeder','Order is created from the checkout page',NULL,39,NULL,'2024-02-20 17:32:59','2024-02-20 17:32:59'),(155,'confirm_order','Order was verified by %user_name%',0,39,NULL,'2024-02-20 17:32:59','2024-02-20 17:32:59'),(156,'confirm_payment','Payment was confirmed (amount $127.00) by %user_name%',0,39,NULL,'2024-02-24 01:32:59','2024-02-24 01:32:59'),(157,'create_shipment','Created shipment for order',0,39,NULL,'2024-02-24 01:33:00','2024-02-24 01:33:00'),(158,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,39,NULL,'2024-02-24 01:33:00','2024-02-24 01:33:00'),(159,'create_order_from_seeder','Order is created from the checkout page',NULL,40,NULL,'2024-02-21 17:33:00','2024-02-21 17:33:00'),(160,'confirm_order','Order was verified by %user_name%',0,40,NULL,'2024-02-21 17:33:00','2024-02-21 17:33:00'),(161,'create_order_from_seeder','Order is created from the checkout page',NULL,41,NULL,'2024-02-22 01:33:00','2024-02-22 01:33:00'),(162,'confirm_order','Order was verified by %user_name%',0,41,NULL,'2024-02-22 01:33:00','2024-02-22 01:33:00'),(163,'confirm_payment','Payment was confirmed (amount $117.00) by %user_name%',0,41,NULL,'2024-02-24 01:33:00','2024-02-24 01:33:00'),(164,'create_shipment','Created shipment for order',0,41,NULL,'2024-02-24 01:33:01','2024-02-24 01:33:01'),(165,'create_order_from_seeder','Order is created from the checkout page',NULL,42,NULL,'2024-02-23 01:33:01','2024-02-23 01:33:01'),(166,'confirm_order','Order was verified by %user_name%',0,42,NULL,'2024-02-23 01:33:01','2024-02-23 01:33:01'),(167,'confirm_payment','Payment was confirmed (amount $252.00) by %user_name%',0,42,NULL,'2024-02-24 01:33:01','2024-02-24 01:33:01'),(168,'update_status','Changed status of shipping to: . Updated by: %user_name%',0,42,NULL,'2024-02-24 01:33:01','2024-02-24 01:33:01'),(169,'create_order_from_seeder','Order is created from the checkout page',NULL,43,NULL,'2024-02-22 07:33:01','2024-02-22 07:33:01'),(170,'confirm_order','Order was verified by %user_name%',0,43,NULL,'2024-02-22 07:33:01','2024-02-22 07:33:01'),(171,'confirm_payment','Payment was confirmed (amount $176.00) by %user_name%',0,43,NULL,'2024-02-24 01:33:01','2024-02-24 01:33:01'),(172,'create_shipment','Created shipment for order',0,43,NULL,'2024-02-24 01:33:02','2024-02-24 01:33:02'),(173,'create_order_from_seeder','Order is created from the checkout page',NULL,44,NULL,'2024-02-23 01:33:02','2024-02-23 01:33:02'),(174,'confirm_order','Order was verified by %user_name%',0,44,NULL,'2024-02-23 01:33:02','2024-02-23 01:33:02'),(175,'confirm_payment','Payment was confirmed (amount $1,000.00) by %user_name%',0,44,NULL,'2024-02-24 01:33:02','2024-02-24 01:33:02'),(176,'create_shipment','Created shipment for order',0,44,NULL,'2024-02-24 01:33:02','2024-02-24 01:33:02'),(177,'create_order_from_seeder','Order is created from the checkout page',NULL,45,NULL,'2024-02-23 07:33:02','2024-02-23 07:33:02'),(178,'confirm_order','Order was verified by %user_name%',0,45,NULL,'2024-02-23 07:33:02','2024-02-23 07:33:02'),(179,'confirm_payment','Payment was confirmed (amount $250.00) by %user_name%',0,45,NULL,'2024-02-24 01:33:02','2024-02-24 01:33:02'),(180,'create_shipment','Created shipment for order',0,45,NULL,'2024-02-24 01:33:03','2024-02-24 01:33:03'),(181,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,45,NULL,'2024-02-24 01:33:03','2024-02-24 01:33:03'),(182,'create_order_from_seeder','Order is created from the checkout page',NULL,46,NULL,'2024-02-23 21:33:03','2024-02-23 21:33:03'),(183,'confirm_order','Order was verified by %user_name%',0,46,NULL,'2024-02-23 21:33:03','2024-02-23 21:33:03'),(184,'confirm_payment','Payment was confirmed (amount $224.00) by %user_name%',0,46,NULL,'2024-02-24 01:33:03','2024-02-24 01:33:03'),(185,'update_status','Changed status of shipping to: . Updated by: %user_name%',0,46,NULL,'2024-02-24 01:33:03','2024-02-24 01:33:03'),(186,'create_order_from_seeder','Order is created from the checkout page',NULL,47,NULL,'2024-02-22 21:33:03','2024-02-22 21:33:03'),(187,'confirm_order','Order was verified by %user_name%',0,47,NULL,'2024-02-22 21:33:03','2024-02-22 21:33:03'),(188,'confirm_payment','Payment was confirmed (amount $330.00) by %user_name%',0,47,NULL,'2024-02-24 01:33:03','2024-02-24 01:33:03'),(189,'create_shipment','Created shipment for order',0,47,NULL,'2024-02-24 01:33:04','2024-02-24 01:33:04'),(190,'create_order_from_seeder','Order is created from the checkout page',NULL,48,NULL,'2024-02-23 21:33:04','2024-02-23 21:33:04'),(191,'confirm_order','Order was verified by %user_name%',0,48,NULL,'2024-02-23 21:33:04','2024-02-23 21:33:04'),(192,'confirm_payment','Payment was confirmed (amount $232.00) by %user_name%',0,48,NULL,'2024-02-24 01:33:04','2024-02-24 01:33:04'),(193,'create_shipment','Created shipment for order',0,48,NULL,'2024-02-24 01:33:04','2024-02-24 01:33:04'),(194,'update_status','Changed status of shipping to: Delivered. Updated by: %user_name%',0,48,NULL,'2024-02-24 01:33:04','2024-02-24 01:33:04'),(195,'create_order_from_seeder','Order is created from the checkout page',NULL,49,NULL,'2024-02-23 05:33:04','2024-02-23 05:33:04'),(196,'confirm_order','Order was verified by %user_name%',0,49,NULL,'2024-02-23 05:33:04','2024-02-23 05:33:04'),(197,'create_order_from_seeder','Order is created from the checkout page',NULL,50,NULL,'2024-02-23 05:33:04','2024-02-23 05:33:04'),(198,'confirm_order','Order was verified by %user_name%',0,50,NULL,'2024-02-23 05:33:04','2024-02-23 05:33:04'),(199,'confirm_payment','Payment was confirmed (amount $112.00) by %user_name%',0,50,NULL,'2024-02-24 01:33:05','2024-02-24 01:33:05'),(200,'create_shipment','Created shipment for order',0,50,NULL,'2024-02-24 01:33:05','2024-02-24 01:33:05'),(201,'update_status','Order confirmed by %user_name%',0,3,NULL,'2024-02-24 01:33:05','2024-02-24 01:33:05'),(202,'update_status','Order confirmed by %user_name%',0,4,NULL,'2024-02-24 01:33:06','2024-02-24 01:33:06'),(203,'update_status','Order confirmed by %user_name%',0,7,NULL,'2024-02-24 01:33:07','2024-02-24 01:33:07'),(204,'update_status','Order confirmed by %user_name%',0,9,NULL,'2024-02-24 01:33:08','2024-02-24 01:33:08'),(205,'update_status','Order confirmed by %user_name%',0,11,NULL,'2024-02-24 01:33:09','2024-02-24 01:33:09'),(206,'update_status','Order confirmed by %user_name%',0,15,NULL,'2024-02-24 01:33:10','2024-02-24 01:33:10'),(207,'update_status','Order confirmed by %user_name%',0,19,NULL,'2024-02-24 01:33:11','2024-02-24 01:33:11'),(208,'update_status','Order confirmed by %user_name%',0,23,NULL,'2024-02-24 01:33:12','2024-02-24 01:33:12'),(209,'update_status','Order confirmed by %user_name%',0,27,NULL,'2024-02-24 01:33:13','2024-02-24 01:33:13'),(210,'update_status','Order confirmed by %user_name%',0,28,NULL,'2024-02-24 01:33:15','2024-02-24 01:33:15'),(211,'update_status','Order confirmed by %user_name%',0,39,NULL,'2024-02-24 01:33:16','2024-02-24 01:33:16'),(212,'update_status','Order confirmed by %user_name%',0,45,NULL,'2024-02-24 01:33:16','2024-02-24 01:33:16'),(213,'update_status','Order confirmed by %user_name%',0,48,NULL,'2024-02-24 01:33:17','2024-02-24 01:33:17');

--
-- 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(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` double(8,2) DEFAULT '0.00',
  `restock_quantity` int unsigned DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `product_type` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'physical',
  `times_downloaded` int NOT NULL DEFAULT '0',
  `license_code` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_order_product` VALUES (1,1,3,451.00,0.00,'{\"sku\":\"HS-153-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 3 Boxes)\"}',NULL,27,'Angie’s Boomchickapop Sweet & Salty Kettle Corn','products/3.jpg',2415.00,0,'2024-02-24 01:32:49','2024-02-24 01:32:49','physical',0,NULL),(2,2,3,125.00,0.00,'{\"sku\":\"HS-115-A0\",\"attributes\":\"(Weight: 5KG, Boxes: 5 Boxes)\"}',NULL,52,'Organic Frozen Triple Berry Blend','products/14.jpg',2319.00,0,'2024-02-24 01:32:49','2024-02-24 01:32:49','physical',0,NULL),(3,3,1,121.00,0.00,'{\"sku\":\"HS-110-A0-A1\",\"attributes\":\"(Weight: 1KG, Boxes: 3 Boxes)\"}',NULL,79,'Colorful Banana','products/23-1.jpg',590.00,0,'2024-02-24 01:32:50','2024-02-24 01:32:50','physical',0,NULL),(4,4,3,117.00,0.00,'{\"sku\":\"HS-138-A0-A1\",\"attributes\":\"(Boxes: 1 Box, Weight: 2KG)\"}',NULL,34,'Canada Dry Ginger Ale – 2 L Bottle','products/7-1.jpg',1551.00,0,'2024-02-24 01:32:50','2024-02-24 01:32:50','physical',0,NULL),(5,4,1,112.00,0.00,'{\"sku\":\"HS-183-A0-A2\",\"attributes\":\"(Weight: 2KG, Boxes: 2 Boxes)\"}',NULL,62,'Angie’s Boomchickapop Sweet & Salty Kettle Corn (Digital)','products/17.jpg',815.00,0,'2024-02-24 01:32:50','2024-02-24 01:32:50','digital',2,NULL),(6,5,3,119.00,0.00,'{\"sku\":\"HS-156-A0-A1\",\"attributes\":\"(Weight: 2KG, Boxes: 5 Boxes)\"}',NULL,38,'Gorton’s Beer Battered Fish Fillets (Digital)','products/9-1.jpg',2373.00,0,'2024-02-24 01:32:50','2024-02-24 01:32:50','digital',4,NULL),(7,6,3,110.00,0.00,'{\"sku\":\"HS-122-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 3 Boxes)\"}',NULL,71,'Perdue Simply Smart Organics Gluten Free','products/20.jpg',1977.00,0,'2024-02-24 01:32:50','2024-02-24 01:32:50','physical',0,NULL),(8,7,3,114.00,0.00,'{\"sku\":\"HS-178-A0-A1\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}',NULL,45,'Nestle Original Coffee-Mate Coffee Creamer','products/11-1.jpg',1728.00,0,'2024-02-24 01:32:51','2024-02-24 01:32:51','physical',0,NULL),(9,8,1,129.00,0.00,'{\"sku\":\"HS-171-A0\",\"attributes\":\"(Weight: 2KG, Boxes: 5 Boxes)\"}',NULL,46,'Naturally Flavored Cinnamon Vanilla Light Roast Coffee','products/12.jpg',871.00,0,'2024-02-24 01:32:51','2024-02-24 01:32:51','physical',0,NULL),(10,9,3,88.00,0.00,'{\"sku\":\"HS-105-A0-A1\",\"attributes\":\"(Weight: 1KG, Boxes: 2 Boxes)\"}',NULL,29,'Foster Farms Takeout Crispy Classic','products/4-1.jpg',1557.00,0,'2024-02-24 01:32:51','2024-02-24 01:32:51','physical',0,NULL),(11,10,2,50.00,0.00,'{\"sku\":\"HS-189-A0\",\"attributes\":\"(Boxes: 1 Box, Weight: 5KG)\"}',NULL,30,'Blue Diamond Almonds Lightly (Digital)','products/5.jpg',1750.00,0,'2024-02-24 01:32:51','2024-02-24 01:32:51','digital',9,NULL),(12,10,3,112.00,0.00,'{\"sku\":\"HS-121-A0\",\"attributes\":\"(Boxes: 2 Boxes, Weight: 5KG)\"}',NULL,66,'Simply Lemonade with Raspberry Juice','products/19.jpg',1785.00,0,'2024-02-24 01:32:51','2024-02-24 01:32:51','physical',0,NULL),(13,11,2,117.00,0.00,'{\"sku\":\"HS-138-A0\",\"attributes\":\"(Weight: 3KG, Boxes: 4 Boxes)\"}',NULL,33,'Canada Dry Ginger Ale – 2 L Bottle','products/7.jpg',1034.00,0,'2024-02-24 01:32:52','2024-02-24 01:32:52','physical',0,NULL),(14,12,2,114.00,0.00,'{\"sku\":\"HS-178-A0\",\"attributes\":\"(Weight: 2KG, Boxes: 5 Boxes)\"}',NULL,44,'Nestle Original Coffee-Mate Coffee Creamer','products/11.jpg',1152.00,0,'2024-02-24 01:32:52','2024-02-24 01:32:52','physical',0,NULL),(15,13,3,129.00,0.00,'{\"sku\":\"HS-171-A0-A1\",\"attributes\":\"(Weight: 2KG, Boxes: 4 Boxes)\"}',NULL,47,'Naturally Flavored Cinnamon Vanilla Light Roast Coffee','products/12-1.jpg',2613.00,0,'2024-02-24 01:32:52','2024-02-24 01:32:52','physical',0,NULL),(16,13,3,112.00,0.00,'{\"sku\":\"HS-183-A0-A2\",\"attributes\":\"(Weight: 2KG, Boxes: 2 Boxes)\"}',NULL,62,'Angie’s Boomchickapop Sweet & Salty Kettle Corn (Digital)','products/17.jpg',2445.00,0,'2024-02-24 01:32:52','2024-02-24 01:32:52','digital',7,NULL),(17,14,2,391.00,0.00,'{\"sku\":\"HS-173-A0\",\"attributes\":\"(Boxes: 1 Box, Weight: 5KG)\"}',NULL,25,'Seeds of Change Organic Quinoe (Digital)','products/1.jpg',1376.00,0,'2024-02-24 01:32:52','2024-02-24 01:32:52','digital',4,NULL),(18,15,2,387.00,0.00,'{\"sku\":\"HS-176-A0\",\"attributes\":\"(Boxes: 2 Boxes, Weight: 5KG)\"}',NULL,26,'All Natural Italian-Style Chicken Meatballs','products/2.jpg',1682.00,0,'2024-02-24 01:32:53','2024-02-24 01:32:53','physical',0,NULL),(19,16,1,125.00,0.00,'{\"sku\":\"HS-115-A0-A1\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}',NULL,53,'Organic Frozen Triple Berry Blend','products/14-1.jpg',773.00,0,'2024-02-24 01:32:53','2024-02-24 01:32:53','physical',0,NULL),(20,17,3,88.00,0.00,'{\"sku\":\"HS-105-A0-A1\",\"attributes\":\"(Weight: 1KG, Boxes: 2 Boxes)\"}',NULL,29,'Foster Farms Takeout Crispy Classic','products/4-1.jpg',1557.00,0,'2024-02-24 01:32:53','2024-02-24 01:32:53','physical',0,NULL),(21,18,2,114.00,0.00,'{\"sku\":\"HS-179-A0\",\"attributes\":\"(Weight: 3KG, Boxes: 5 Boxes)\"}',NULL,35,'Encore Seafoods Stuffed Alaskan','products/8.jpg',1450.00,0,'2024-02-24 01:32:53','2024-02-24 01:32:53','physical',0,NULL),(22,19,1,127.00,0.00,'{\"sku\":\"HS-177-A0-A3\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}',NULL,58,'Oroweat Country Buttermilk Bread','products/15.jpg',678.00,0,'2024-02-24 01:32:54','2024-02-24 01:32:54','physical',0,NULL),(23,20,2,387.00,0.00,'{\"sku\":\"HS-176-A0\",\"attributes\":\"(Boxes: 2 Boxes, Weight: 5KG)\"}',NULL,26,'All Natural Italian-Style Chicken Meatballs','products/2.jpg',1682.00,0,'2024-02-24 01:32:54','2024-02-24 01:32:54','physical',0,NULL),(24,21,3,50.00,0.00,'{\"sku\":\"HS-189-A0\",\"attributes\":\"(Boxes: 1 Box, Weight: 5KG)\"}',NULL,30,'Blue Diamond Almonds Lightly (Digital)','products/5.jpg',2625.00,0,'2024-02-24 01:32:54','2024-02-24 01:32:54','digital',10,NULL),(25,21,2,125.00,0.00,'{\"sku\":\"HS-115-A0-A1\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}',NULL,53,'Organic Frozen Triple Berry Blend','products/14-1.jpg',1546.00,0,'2024-02-24 01:32:54','2024-02-24 01:32:54','physical',0,NULL),(26,22,1,129.00,0.00,'{\"sku\":\"HS-171-A0-A2\",\"attributes\":\"(Weight: 1KG, Boxes: 3 Boxes)\"}',NULL,48,'Naturally Flavored Cinnamon Vanilla Light Roast Coffee','products/12.jpg',871.00,0,'2024-02-24 01:32:54','2024-02-24 01:32:54','physical',0,NULL),(27,23,1,50.00,0.00,'{\"sku\":\"HS-189-A0-A1\",\"attributes\":\"(Boxes: 1 Box, Weight: 4KG)\"}',NULL,31,'Blue Diamond Almonds Lightly (Digital)','products/5-1.jpg',875.00,0,'2024-02-24 01:32:55','2024-02-24 01:32:55','digital',5,NULL),(28,23,3,125.00,0.00,'{\"sku\":\"HS-115-A0-A1\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}',NULL,53,'Organic Frozen Triple Berry Blend','products/14-1.jpg',2319.00,0,'2024-02-24 01:32:55','2024-02-24 01:32:55','physical',0,NULL),(29,23,2,114.00,0.00,'{\"sku\":\"HS-156-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 2 Boxes)\"}',NULL,80,'Signature Wood-Fired Mushroom and Caramelized','products/24.jpg',1664.00,0,'2024-02-24 01:32:55','2024-02-24 01:32:55','physical',0,NULL),(30,24,3,126.00,0.00,'{\"sku\":\"HS-161-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 1 Box)\"}',NULL,75,'Chen Watermelon (Digital)','products/21.jpg',2136.00,0,'2024-02-24 01:32:55','2024-02-24 01:32:55','digital',6,NULL),(31,25,1,50.00,0.00,'{\"sku\":\"HS-189-A0\",\"attributes\":\"(Boxes: 1 Box, Weight: 5KG)\"}',NULL,30,'Blue Diamond Almonds Lightly (Digital)','products/5.jpg',875.00,0,'2024-02-24 01:32:55','2024-02-24 01:32:55','digital',1,NULL),(32,26,2,55.00,0.00,'{\"sku\":\"HS-171-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 1 Box)\"}',NULL,32,'Chobani Complete Vanilla Greek','products/6.jpg',1282.00,0,'2024-02-24 01:32:55','2024-02-24 01:32:55','physical',0,NULL),(33,27,2,116.00,0.00,'{\"sku\":\"HS-178-A0\",\"attributes\":\"(Weight: 2KG, Boxes: 5 Boxes)\"}',NULL,77,'Organic Cage-Free Grade A Large Brown Eggs','products/22.jpg',1014.00,0,'2024-02-24 01:32:55','2024-02-24 01:32:55','physical',0,NULL),(34,28,1,387.00,0.00,'{\"sku\":\"HS-176-A0\",\"attributes\":\"(Boxes: 2 Boxes, Weight: 5KG)\"}',NULL,26,'All Natural Italian-Style Chicken Meatballs','products/2.jpg',841.00,0,'2024-02-24 01:32:56','2024-02-24 01:32:56','physical',0,NULL),(35,29,2,119.00,0.00,'{\"sku\":\"HS-156-A0\",\"attributes\":\"(Boxes: 1 Box, Weight: 2KG)\"}',NULL,37,'Gorton’s Beer Battered Fish Fillets (Digital)','products/9.jpg',1582.00,0,'2024-02-24 01:32:56','2024-02-24 01:32:56','digital',5,NULL),(36,29,1,112.00,0.00,'{\"sku\":\"HS-121-A0-A4\",\"attributes\":\"(Boxes: 1 Box, Weight: 3KG)\"}',NULL,70,'Simply Lemonade with Raspberry Juice','products/19.jpg',595.00,0,'2024-02-24 01:32:56','2024-02-24 01:32:56','physical',0,NULL),(37,30,3,500.00,0.00,'{\"sku\":\"HS-116-A0\",\"attributes\":\"(Weight: 2KG, Boxes: 4 Boxes)\"}',NULL,39,'Haagen-Dazs Caramel Cone Ice Cream','products/10.jpg',2637.00,0,'2024-02-24 01:32:56','2024-02-24 01:32:56','physical',0,NULL),(38,30,2,500.00,0.00,'{\"sku\":\"HS-116-A0-A1\",\"attributes\":\"(Weight: 4KG, Boxes: 4 Boxes)\"}',NULL,40,'Haagen-Dazs Caramel Cone Ice Cream','products/10-1.jpg',1758.00,0,'2024-02-24 01:32:56','2024-02-24 01:32:56','physical',0,NULL),(39,30,1,116.00,0.00,'{\"sku\":\"HS-196-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 3 Boxes)\"}',NULL,59,'Foster Farms Takeout Crispy Classic Buffalo Wings','products/16.jpg',718.00,0,'2024-02-24 01:32:56','2024-02-24 01:32:56','physical',0,NULL),(40,31,1,50.00,0.00,'{\"sku\":\"HS-189-A0-A1\",\"attributes\":\"(Boxes: 1 Box, Weight: 4KG)\"}',NULL,31,'Blue Diamond Almonds Lightly (Digital)','products/5-1.jpg',875.00,0,'2024-02-24 01:32:56','2024-02-24 01:32:56','digital',4,NULL),(41,31,3,112.00,0.00,'{\"sku\":\"HS-121-A0-A2\",\"attributes\":\"(Weight: 2KG, Boxes: 5 Boxes)\"}',NULL,68,'Simply Lemonade with Raspberry Juice','products/19.jpg',1785.00,0,'2024-02-24 01:32:56','2024-02-24 01:32:56','physical',0,NULL),(42,32,3,500.00,0.00,'{\"sku\":\"HS-116-A0-A1\",\"attributes\":\"(Weight: 4KG, Boxes: 4 Boxes)\"}',NULL,40,'Haagen-Dazs Caramel Cone Ice Cream','products/10-1.jpg',2637.00,0,'2024-02-24 01:32:57','2024-02-24 01:32:57','physical',0,NULL),(43,33,1,127.00,0.00,'{\"sku\":\"HS-177-A0-A1\",\"attributes\":\"(Weight: 5KG, Boxes: 5 Boxes)\"}',NULL,56,'Oroweat Country Buttermilk Bread','products/15-1.jpg',678.00,0,'2024-02-24 01:32:57','2024-02-24 01:32:57','physical',0,NULL),(44,34,3,55.00,0.00,'{\"sku\":\"HS-171-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 1 Box)\"}',NULL,32,'Chobani Complete Vanilla Greek','products/6.jpg',1923.00,0,'2024-02-24 01:32:57','2024-02-24 01:32:57','physical',0,NULL),(45,34,3,127.00,0.00,'{\"sku\":\"HS-177-A0-A3\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}',NULL,58,'Oroweat Country Buttermilk Bread','products/15.jpg',2034.00,0,'2024-02-24 01:32:57','2024-02-24 01:32:57','physical',0,NULL),(46,35,2,117.00,0.00,'{\"sku\":\"HS-138-A0-A1\",\"attributes\":\"(Boxes: 1 Box, Weight: 2KG)\"}',NULL,34,'Canada Dry Ginger Ale – 2 L Bottle','products/7-1.jpg',1034.00,0,'2024-02-24 01:32:57','2024-02-24 01:32:57','physical',0,NULL),(47,35,1,112.00,0.00,'{\"sku\":\"HS-183-A0-A1\",\"attributes\":\"(Boxes: 2 Boxes, Weight: 5KG)\"}',NULL,61,'Angie’s Boomchickapop Sweet & Salty Kettle Corn (Digital)','products/17-1.jpg',815.00,0,'2024-02-24 01:32:57','2024-02-24 01:32:57','digital',3,NULL),(48,36,3,129.00,0.00,'{\"sku\":\"HS-171-A0-A1\",\"attributes\":\"(Weight: 2KG, Boxes: 4 Boxes)\"}',NULL,47,'Naturally Flavored Cinnamon Vanilla Light Roast Coffee','products/12-1.jpg',2613.00,0,'2024-02-24 01:32:58','2024-02-24 01:32:58','physical',0,NULL),(49,37,3,116.00,0.00,'{\"sku\":\"HS-196-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 3 Boxes)\"}',NULL,59,'Foster Farms Takeout Crispy Classic Buffalo Wings','products/16.jpg',2154.00,0,'2024-02-24 01:32:58','2024-02-24 01:32:58','physical',0,NULL),(50,38,1,117.00,0.00,'{\"sku\":\"HS-138-A0-A1\",\"attributes\":\"(Boxes: 1 Box, Weight: 2KG)\"}',NULL,34,'Canada Dry Ginger Ale – 2 L Bottle','products/7-1.jpg',517.00,0,'2024-02-24 01:32:59','2024-02-24 01:32:59','physical',0,NULL),(51,39,1,127.00,0.00,'{\"sku\":\"HS-177-A0-A3\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}',NULL,58,'Oroweat Country Buttermilk Bread','products/15.jpg',678.00,0,'2024-02-24 01:32:59','2024-02-24 01:32:59','physical',0,NULL),(52,40,1,50.00,0.00,'{\"sku\":\"HS-189-A0\",\"attributes\":\"(Boxes: 1 Box, Weight: 5KG)\"}',NULL,30,'Blue Diamond Almonds Lightly (Digital)','products/5.jpg',875.00,0,'2024-02-24 01:33:00','2024-02-24 01:33:00','digital',10,NULL),(53,41,1,117.00,0.00,'{\"sku\":\"HS-138-A0-A1\",\"attributes\":\"(Boxes: 1 Box, Weight: 2KG)\"}',NULL,34,'Canada Dry Ginger Ale – 2 L Bottle','products/7-1.jpg',517.00,0,'2024-02-24 01:33:00','2024-02-24 01:33:00','physical',0,NULL),(54,42,2,126.00,0.00,'{\"sku\":\"HS-161-A0-A1\",\"attributes\":\"(Boxes: 4 Boxes, Weight: 5KG)\"}',NULL,76,'Chen Watermelon (Digital)','products/21-1.jpg',1424.00,0,'2024-02-24 01:33:01','2024-02-24 01:33:01','digital',5,NULL),(55,43,2,88.00,0.00,'{\"sku\":\"HS-105-A0-A1\",\"attributes\":\"(Weight: 1KG, Boxes: 2 Boxes)\"}',NULL,29,'Foster Farms Takeout Crispy Classic','products/4-1.jpg',1038.00,0,'2024-02-24 01:33:01','2024-02-24 01:33:01','physical',0,NULL),(56,44,2,500.00,0.00,'{\"sku\":\"HS-116-A0-A1\",\"attributes\":\"(Weight: 4KG, Boxes: 4 Boxes)\"}',NULL,40,'Haagen-Dazs Caramel Cone Ice Cream','products/10-1.jpg',1758.00,0,'2024-02-24 01:33:02','2024-02-24 01:33:02','physical',0,NULL),(57,45,2,125.00,0.00,'{\"sku\":\"HS-115-A0\",\"attributes\":\"(Weight: 5KG, Boxes: 5 Boxes)\"}',NULL,52,'Organic Frozen Triple Berry Blend','products/14.jpg',1546.00,0,'2024-02-24 01:33:02','2024-02-24 01:33:02','physical',0,NULL),(58,46,2,112.00,0.00,'{\"sku\":\"HS-183-A0-A2\",\"attributes\":\"(Weight: 2KG, Boxes: 2 Boxes)\"}',NULL,62,'Angie’s Boomchickapop Sweet & Salty Kettle Corn (Digital)','products/17.jpg',1630.00,0,'2024-02-24 01:33:03','2024-02-24 01:33:03','digital',8,NULL),(59,47,3,110.00,0.00,'{\"sku\":\"HS-122-A0\",\"attributes\":\"(Weight: 1KG, Boxes: 3 Boxes)\"}',NULL,71,'Perdue Simply Smart Organics Gluten Free','products/20.jpg',1977.00,0,'2024-02-24 01:33:03','2024-02-24 01:33:03','physical',0,NULL),(60,48,2,116.00,0.00,'{\"sku\":\"HS-178-A0\",\"attributes\":\"(Weight: 2KG, Boxes: 5 Boxes)\"}',NULL,77,'Organic Cage-Free Grade A Large Brown Eggs','products/22.jpg',1014.00,0,'2024-02-24 01:33:04','2024-02-24 01:33:04','physical',0,NULL),(61,49,2,391.00,0.00,'{\"sku\":\"HS-173-A0\",\"attributes\":\"(Boxes: 1 Box, Weight: 5KG)\"}',NULL,25,'Seeds of Change Organic Quinoe (Digital)','products/1.jpg',1376.00,0,'2024-02-24 01:33:04','2024-02-24 01:33:04','digital',9,NULL),(62,50,1,112.00,0.00,'{\"sku\":\"HS-121-A0\",\"attributes\":\"(Boxes: 2 Boxes, Weight: 5KG)\"}',NULL,66,'Simply Lemonade with Raspberry Juice','products/19.jpg',595.00,0,'2024-02-24 01:33:05','2024-02-24 01:33:05','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(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` int NOT NULL COMMENT 'Quantity return',
  `price` decimal(15,2) NOT NULL COMMENT 'Price Product',
  `reason` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `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(191) 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(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Order current status',
  `return_status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Return status',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_order_returns_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `ec_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(191) 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(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'swatch_dropdown',
  `is_searchable` tinyint unsigned NOT NULL DEFAULT '1',
  `is_comparable` tinyint unsigned NOT NULL DEFAULT '1',
  `is_use_in_product_listing` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `order` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `use_image_from_product_variation` tinyint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_product_attribute_sets` VALUES (1,'Weight','weight','text',1,1,1,'published',0,'2024-02-24 01:32:26','2024-02-24 01:32:26',0),(2,'Boxes','boxes','text',1,1,1,'published',1,'2024-02-24 01:32:26','2024-02-24 01:32:26',0);

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

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

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


--
-- 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(191) 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,'1KG','1kg',NULL,NULL,1,1,'2024-02-24 01:32:26','2024-02-24 01:32:26'),(2,1,'2KG','2kg',NULL,NULL,0,2,'2024-02-24 01:32:26','2024-02-24 01:32:26'),(3,1,'3KG','3kg',NULL,NULL,0,3,'2024-02-24 01:32:26','2024-02-24 01:32:26'),(4,1,'4KG','4kg',NULL,NULL,0,4,'2024-02-24 01:32:26','2024-02-24 01:32:26'),(5,1,'5KG','5kg',NULL,NULL,0,5,'2024-02-24 01:32:26','2024-02-24 01:32:26'),(6,2,'1 Box','1-box',NULL,NULL,1,1,'2024-02-24 01:32:26','2024-02-24 01:32:26'),(7,2,'2 Boxes','2-boxes',NULL,NULL,0,2,'2024-02-24 01:32:26','2024-02-24 01:32:26'),(8,2,'3 Boxes','3-boxes',NULL,NULL,0,3,'2024-02-24 01:32:26','2024-02-24 01:32:26'),(9,2,'4 Boxes','4-boxes',NULL,NULL,0,4,'2024-02-24 01:32:26','2024-02-24 01:32:26'),(10,2,'5 Boxes','5-boxes',NULL,NULL,0,5,'2024-02-24 01:32:26','2024-02-24 01:32:26');

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

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

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


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

CREATE TABLE `ec_product_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` 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(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_image` varchar(191) 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=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_product_categories` VALUES (1,'Milks and Dairies',0,NULL,'published',0,'product-categories/image-1.png',1,'2024-02-24 01:32:26','2024-02-24 01:32:26',NULL,'product-categories/icon-1.png'),(2,'Clothing & beauty',0,NULL,'published',1,'product-categories/image-2.png',1,'2024-02-24 01:32:26','2024-02-24 01:32:26',NULL,'product-categories/icon-2.png'),(3,'Pet Toy',0,NULL,'published',2,'product-categories/image-3.png',1,'2024-02-24 01:32:26','2024-02-24 01:32:26',NULL,'product-categories/icon-3.png'),(4,'Baking material',0,NULL,'published',3,'product-categories/image-4.png',1,'2024-02-24 01:32:26','2024-02-24 01:32:26',NULL,'product-categories/icon-4.png'),(5,'Fresh Fruit',0,NULL,'published',4,'product-categories/image-5.png',1,'2024-02-24 01:32:26','2024-02-24 01:32:26',NULL,'product-categories/icon-5.png'),(6,'Wines & Drinks',0,NULL,'published',5,'product-categories/image-6.png',1,'2024-02-24 01:32:26','2024-02-24 01:32:26',NULL,'product-categories/icon-6.png'),(7,'Fresh Seafood',0,NULL,'published',6,'product-categories/image-7.png',1,'2024-02-24 01:32:26','2024-02-24 01:32:26',NULL,'product-categories/icon-7.png'),(8,'Fast food',0,NULL,'published',7,'product-categories/image-8.png',1,'2024-02-24 01:32:26','2024-02-24 01:32:26',NULL,'product-categories/icon-8.png'),(9,'Vegetables',0,NULL,'published',8,'product-categories/image-9.png',1,'2024-02-24 01:32:26','2024-02-24 01:32:26',NULL,'product-categories/icon-9.png'),(10,'Bread and Juice',0,NULL,'published',9,'product-categories/image-10.png',1,'2024-02-24 01:32:26','2024-02-24 01:32:26',NULL,'product-categories/icon-10.png'),(11,'Cake & Milk',0,NULL,'published',10,'product-categories/image-11.png',1,'2024-02-24 01:32:26','2024-02-24 01:32:26',NULL,'product-categories/icon-11.png'),(12,'Coffee & Teas',0,NULL,'published',11,'product-categories/image-12.png',1,'2024-02-24 01:32:26','2024-02-24 01:32:26',NULL,'product-categories/icon-12.png'),(13,'Pet Foods',0,NULL,'published',12,'product-categories/image-13.png',0,'2024-02-24 01:32:26','2024-02-24 01:32:26',NULL,'product-categories/icon-13.png'),(14,'Diet Foods',0,NULL,'published',13,'product-categories/image-14.png',0,'2024-02-24 01:32:26','2024-02-24 01:32:26',NULL,'product-categories/icon-14.png');

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

CREATE TABLE `ec_product_categories_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_categories_id` bigint unsigned NOT NULL,
  `name` varchar(191) 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,9),(2,19),(4,1),(4,10),(4,14),(5,6),(5,7),(5,21),(6,2),(6,23),(7,5),(8,22),(9,15),(10,16),(10,20),(11,11),(12,12),(13,3),(13,4),(13,8),(13,13),(13,24),(14,17),(14,18);

--
-- 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,15),(1,19),(1,20),(1,21),(2,1),(2,2),(2,3),(2,4),(2,5),(2,7),(2,8),(2,10),(2,13),(2,14),(2,16),(2,18),(2,22),(2,23),(2,24),(3,6),(3,9),(3,11),(3,12),(3,17);

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

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

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

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

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

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

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


--
-- 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(191) 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,5,0,0.00,'fixed',1),(1,16,0,0.00,'fixed',1),(1,17,0,0.00,'fixed',1),(1,23,0,0.00,'fixed',1),(2,1,0,0.00,'fixed',1),(2,5,0,0.00,'fixed',1),(2,9,0,0.00,'fixed',1),(2,12,0,0.00,'fixed',1),(3,6,0,0.00,'fixed',1),(3,14,0,0.00,'fixed',1),(3,20,0,0.00,'fixed',1),(3,24,0,0.00,'fixed',1),(4,13,0,0.00,'fixed',1),(4,17,0,0.00,'fixed',1),(4,19,0,0.00,'fixed',1),(4,20,0,0.00,'fixed',1),(5,7,0,0.00,'fixed',1),(5,10,0,0.00,'fixed',1),(5,19,0,0.00,'fixed',1),(5,22,0,0.00,'fixed',1),(6,9,0,0.00,'fixed',1),(6,11,0,0.00,'fixed',1),(6,14,0,0.00,'fixed',1),(6,17,0,0.00,'fixed',1),(7,11,0,0.00,'fixed',1),(7,12,0,0.00,'fixed',1),(7,20,0,0.00,'fixed',1),(7,21,0,0.00,'fixed',1),(8,2,0,0.00,'fixed',1),(8,4,0,0.00,'fixed',1),(8,18,0,0.00,'fixed',1),(8,23,0,0.00,'fixed',1),(9,8,0,0.00,'fixed',1),(9,16,0,0.00,'fixed',1),(9,17,0,0.00,'fixed',1),(9,22,0,0.00,'fixed',1),(10,1,0,0.00,'fixed',1),(10,15,0,0.00,'fixed',1),(10,21,0,0.00,'fixed',1),(10,24,0,0.00,'fixed',1),(11,10,0,0.00,'fixed',1),(11,14,0,0.00,'fixed',1),(11,19,0,0.00,'fixed',1),(11,22,0,0.00,'fixed',1),(12,19,0,0.00,'fixed',1),(12,20,0,0.00,'fixed',1),(12,23,0,0.00,'fixed',1),(12,24,0,0.00,'fixed',1),(13,5,0,0.00,'fixed',1),(13,22,0,0.00,'fixed',1),(13,23,0,0.00,'fixed',1),(14,8,0,0.00,'fixed',1),(14,10,0,0.00,'fixed',1),(14,13,0,0.00,'fixed',1),(14,18,0,0.00,'fixed',1),(15,3,0,0.00,'fixed',1),(15,10,0,0.00,'fixed',1),(15,16,0,0.00,'fixed',1),(15,22,0,0.00,'fixed',1),(16,2,0,0.00,'fixed',1),(16,9,0,0.00,'fixed',1),(16,10,0,0.00,'fixed',1),(16,19,0,0.00,'fixed',1),(17,12,0,0.00,'fixed',1),(17,14,0,0.00,'fixed',1),(17,15,0,0.00,'fixed',1),(17,22,0,0.00,'fixed',1),(18,5,0,0.00,'fixed',1),(18,7,0,0.00,'fixed',1),(18,15,0,0.00,'fixed',1),(19,3,0,0.00,'fixed',1),(19,10,0,0.00,'fixed',1),(19,20,0,0.00,'fixed',1),(19,24,0,0.00,'fixed',1),(20,16,0,0.00,'fixed',1),(20,17,0,0.00,'fixed',1),(20,18,0,0.00,'fixed',1),(20,23,0,0.00,'fixed',1),(21,10,0,0.00,'fixed',1),(21,11,0,0.00,'fixed',1),(21,13,0,0.00,'fixed',1),(21,17,0,0.00,'fixed',1),(22,5,0,0.00,'fixed',1),(22,12,0,0.00,'fixed',1),(22,19,0,0.00,'fixed',1),(22,23,0,0.00,'fixed',1),(23,4,0,0.00,'fixed',1),(23,10,0,0.00,'fixed',1),(23,21,0,0.00,'fixed',1),(24,10,0,0.00,'fixed',1),(24,15,0,0.00,'fixed',1),(24,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=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_product_files` VALUES (1,25,'product-files/1.jpg','{\"filename\":\"1.jpg\",\"url\":\"product-files\\/1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:31\",\"name\":\"1\",\"extension\":\"jpg\"}','2024-02-24 01:32:31','2024-02-24 01:32:31'),(2,25,'product-files/1-1.jpg','{\"filename\":\"1-1.jpg\",\"url\":\"product-files\\/1-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:31\",\"name\":\"1-1\",\"extension\":\"jpg\"}','2024-02-24 01:32:31','2024-02-24 01:32:31'),(3,30,'product-files/5.jpg','{\"filename\":\"5.jpg\",\"url\":\"product-files\\/5.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"5\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(4,30,'product-files/5-1.jpg','{\"filename\":\"5-1.jpg\",\"url\":\"product-files\\/5-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"5-1\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(5,31,'product-files/5.jpg','{\"filename\":\"5.jpg\",\"url\":\"product-files\\/5.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"5\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(6,31,'product-files/5-1.jpg','{\"filename\":\"5-1.jpg\",\"url\":\"product-files\\/5-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"5-1\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(7,37,'product-files/9.jpg','{\"filename\":\"9.jpg\",\"url\":\"product-files\\/9.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"9\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(8,37,'product-files/9-1.jpg','{\"filename\":\"9-1.jpg\",\"url\":\"product-files\\/9-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"9-1\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(9,38,'product-files/9.jpg','{\"filename\":\"9.jpg\",\"url\":\"product-files\\/9.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"9\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(10,38,'product-files/9-1.jpg','{\"filename\":\"9-1.jpg\",\"url\":\"product-files\\/9-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"9-1\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(11,49,'product-files/13.jpg','{\"filename\":\"13.jpg\",\"url\":\"product-files\\/13.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"13\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(12,49,'product-files/13-1.jpg','{\"filename\":\"13-1.jpg\",\"url\":\"product-files\\/13-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"13-1\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(13,50,'product-files/13.jpg','{\"filename\":\"13.jpg\",\"url\":\"product-files\\/13.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"13\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(14,50,'product-files/13-1.jpg','{\"filename\":\"13-1.jpg\",\"url\":\"product-files\\/13-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"13-1\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(15,51,'product-files/13.jpg','{\"filename\":\"13.jpg\",\"url\":\"product-files\\/13.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"13\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(16,51,'product-files/13-1.jpg','{\"filename\":\"13-1.jpg\",\"url\":\"product-files\\/13-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"13-1\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(17,60,'product-files/17.jpg','{\"filename\":\"17.jpg\",\"url\":\"product-files\\/17.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"17\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(18,60,'product-files/17-1.jpg','{\"filename\":\"17-1.jpg\",\"url\":\"product-files\\/17-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"17-1\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(19,61,'product-files/17.jpg','{\"filename\":\"17.jpg\",\"url\":\"product-files\\/17.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"17\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(20,61,'product-files/17-1.jpg','{\"filename\":\"17-1.jpg\",\"url\":\"product-files\\/17-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"17-1\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(21,62,'product-files/17.jpg','{\"filename\":\"17.jpg\",\"url\":\"product-files\\/17.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"17\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(22,62,'product-files/17-1.jpg','{\"filename\":\"17-1.jpg\",\"url\":\"product-files\\/17-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"17-1\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(23,63,'product-files/17.jpg','{\"filename\":\"17.jpg\",\"url\":\"product-files\\/17.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"17\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(24,63,'product-files/17-1.jpg','{\"filename\":\"17-1.jpg\",\"url\":\"product-files\\/17-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:32\",\"name\":\"17-1\",\"extension\":\"jpg\"}','2024-02-24 01:32:32','2024-02-24 01:32:32'),(25,75,'product-files/21.jpg','{\"filename\":\"21.jpg\",\"url\":\"product-files\\/21.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:33\",\"name\":\"21\",\"extension\":\"jpg\"}','2024-02-24 01:32:33','2024-02-24 01:32:33'),(26,75,'product-files/21-1.jpg','{\"filename\":\"21-1.jpg\",\"url\":\"product-files\\/21-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:33\",\"name\":\"21-1\",\"extension\":\"jpg\"}','2024-02-24 01:32:33','2024-02-24 01:32:33'),(27,76,'product-files/21.jpg','{\"filename\":\"21.jpg\",\"url\":\"product-files\\/21.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:33\",\"name\":\"21\",\"extension\":\"jpg\"}','2024-02-24 01:32:33','2024-02-24 01:32:33'),(28,76,'product-files/21-1.jpg','{\"filename\":\"21-1.jpg\",\"url\":\"product-files\\/21-1.jpg\",\"mime_type\":\"image\\/jpeg\",\"size\":9730,\"modified\":\"2024-02-24 08:32:33\",\"name\":\"21-1\",\"extension\":\"jpg\"}','2024-02-24 01:32:33','2024-02-24 01:32:33');

--
-- 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 (2,14),(3,7),(3,21);

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

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

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

INSERT INTO `ec_product_labels` VALUES (1,'Hot','#d71e2d','published','2024-02-24 01:32:26','2024-02-24 01:32:26'),(2,'New','#02856e','published','2024-02-24 01:32:26','2024-02-24 01:32:26'),(3,'Sale','#fe9931','published','2024-02-24 01:32:26','2024-02-24 01:32:26');

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

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

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


--
-- 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,1),(1,2),(1,5),(2,2),(2,5),(2,6),(3,2),(3,4),(4,1),(4,2),(4,4),(5,4),(5,6),(6,2),(6,5),(7,2),(7,4),(7,5),(8,2),(8,3),(8,6),(9,2),(9,5),(10,1),(10,2),(10,3),(11,1),(11,3),(12,3),(12,4),(12,6),(13,1),(13,3),(14,2),(14,4),(14,6),(15,1),(15,2),(15,4),(16,1),(16,5),(17,1),(17,4),(18,2),(18,3),(18,5),(19,4),(19,5),(19,6),(20,2),(20,4),(21,1),(21,2),(21,4),(22,2),(22,5),(22,6),(23,1),(23,5),(23,6),(24,2),(24,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=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_product_tags` VALUES (1,'Wallet',NULL,'published','2024-02-24 01:32:26','2024-02-24 01:32:26'),(2,'Bags',NULL,'published','2024-02-24 01:32:26','2024-02-24 01:32:26'),(3,'Shoes',NULL,'published','2024-02-24 01:32:26','2024-02-24 01:32:26'),(4,'Clothes',NULL,'published','2024-02-24 01:32:26','2024-02-24 01:32:26'),(5,'Hand bag',NULL,'published','2024-02-24 01:32:26','2024-02-24 01:32:26');

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

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

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


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

--
-- 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=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--
-- 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-02-24',
  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),(1,24,0),(2,24,0);

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

CREATE TABLE `ec_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `images` text COLLATE utf8mb4_unicode_ci,
  `sku` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int unsigned NOT NULL DEFAULT '0',
  `quantity` int unsigned DEFAULT NULL,
  `allow_checkout_when_out_of_stock` tinyint unsigned NOT NULL DEFAULT '0',
  `with_storehouse_management` tinyint unsigned NOT NULL DEFAULT '0',
  `is_featured` tinyint unsigned NOT NULL DEFAULT '0',
  `brand_id` 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(191) 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=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_products` VALUES (1,'Seeds of Change Organic Quinoe (Digital)','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/1.jpg\",\"products\\/1-1.jpg\"]','HS-173-A0',0,16,0,1,1,1,0,0,391,NULL,NULL,NULL,15.00,16.00,18.00,688.00,NULL,91577,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,2,0),(2,'All Natural Italian-Style Chicken Meatballs','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/2.jpg\",\"products\\/2-1.jpg\"]','HS-176-A0',0,18,0,1,1,7,0,0,387,NULL,NULL,NULL,20.00,16.00,18.00,841.00,NULL,48419,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,3,0),(3,'Angie’s Boomchickapop Sweet &amp; Salty Kettle Corn','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/3.jpg\",\"products\\/3-1.jpg\"]','HS-153-A0',0,19,0,1,1,1,0,0,451,NULL,NULL,NULL,19.00,11.00,18.00,805.00,NULL,173849,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,2,0),(4,'Foster Farms Takeout Crispy Classic','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/4.jpg\",\"products\\/4-1.jpg\"]','HS-105-A0',0,13,0,1,1,1,0,0,88,66,NULL,NULL,18.00,18.00,13.00,519.00,NULL,112463,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,3,0),(5,'Blue Diamond Almonds Lightly (Digital)','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/5.jpg\",\"products\\/5-1.jpg\"]','HS-189-A0',0,19,0,1,1,3,0,0,50,NULL,NULL,NULL,19.00,10.00,15.00,875.00,NULL,114983,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,4,0),(6,'Chobani Complete Vanilla Greek','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/6.jpg\",\"products\\/6-1.jpg\"]','HS-171-A0',0,19,0,1,1,7,0,0,55,NULL,NULL,NULL,16.00,14.00,19.00,641.00,NULL,63236,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,2,0),(7,'Canada Dry Ginger Ale – 2 L Bottle','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/7.jpg\",\"products\\/7-1.jpg\"]','HS-138-A0',0,18,0,1,1,5,0,0,117,NULL,NULL,NULL,13.00,14.00,16.00,517.00,NULL,92627,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,5,0),(8,'Encore Seafoods Stuffed Alaskan','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/8.jpg\",\"products\\/8-1.jpg\"]','HS-179-A0',0,15,0,1,1,7,0,0,114,87.78,NULL,NULL,15.00,18.00,19.00,725.00,NULL,194533,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,4,0),(9,'Gorton’s Beer Battered Fish Fillets (Digital)','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/9.jpg\",\"products\\/9-1.jpg\"]','HS-156-A0',0,15,0,1,1,3,0,0,119,NULL,NULL,NULL,20.00,14.00,20.00,791.00,NULL,130440,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,4,0),(10,'Haagen-Dazs Caramel Cone Ice Cream','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/10.jpg\",\"products\\/10-1.jpg\"]','HS-116-A0',0,17,0,1,1,7,0,0,500,NULL,NULL,NULL,17.00,20.00,20.00,879.00,NULL,100976,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,1,0),(11,'Nestle Original Coffee-Mate Coffee Creamer','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/11.jpg\",\"products\\/11-1.jpg\"]','HS-178-A0',0,19,0,1,1,6,0,0,114,NULL,NULL,NULL,15.00,15.00,10.00,576.00,NULL,57630,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,4,0),(12,'Naturally Flavored Cinnamon Vanilla Light Roast Coffee','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/12.jpg\",\"products\\/12-1.jpg\"]','HS-171-A0',0,14,0,1,1,3,0,0,129,90.3,NULL,NULL,15.00,10.00,13.00,871.00,NULL,96692,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,5,0),(13,'Pepperidge Farm Farmhouse Hearty White Bread (Digital)','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/13.jpg\",\"products\\/13-1.jpg\"]','HS-131-A0',0,19,0,1,1,7,0,0,117,NULL,NULL,NULL,19.00,20.00,20.00,752.00,NULL,171359,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,1,0),(14,'Organic Frozen Triple Berry Blend','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/14.jpg\",\"products\\/14-1.jpg\"]','HS-115-A0',0,13,0,1,1,5,0,0,125,NULL,NULL,NULL,20.00,13.00,18.00,773.00,NULL,82576,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,4,0),(15,'Oroweat Country Buttermilk Bread','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/15.jpg\",\"products\\/15-1.jpg\"]','HS-177-A0',0,14,0,1,1,4,0,0,127,NULL,NULL,NULL,14.00,10.00,12.00,678.00,NULL,1401,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,2,0),(16,'Foster Farms Takeout Crispy Classic Buffalo Wings','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/16.jpg\",\"products\\/16-1.jpg\",\"products\\/16-2.jpg\",\"products\\/16-3.jpg\",\"products\\/16-4.jpg\",\"products\\/16-5.jpg\",\"products\\/16-6.jpg\"]','HS-196-A0',0,12,0,1,1,3,0,0,116,103.24,NULL,NULL,19.00,13.00,20.00,718.00,NULL,25033,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,1,0),(17,'Angie’s Boomchickapop Sweet &amp; Salty Kettle Corn (Digital)','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/17.jpg\",\"products\\/17-1.jpg\"]','HS-183-A0',0,14,0,1,1,7,0,0,112,NULL,NULL,NULL,13.00,18.00,12.00,815.00,NULL,87809,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,5,0),(18,'All Natural Italian-Style Chicken Meatballs','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/18.jpg\",\"products\\/18-1.jpg\"]','HS-133-A0',0,15,0,1,1,6,0,0,123,NULL,NULL,NULL,18.00,12.00,19.00,675.00,NULL,143671,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,4,0),(19,'Simply Lemonade with Raspberry Juice','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/19.jpg\",\"products\\/19-1.jpg\"]','HS-121-A0',0,17,0,1,1,2,0,0,112,NULL,NULL,NULL,15.00,15.00,10.00,595.00,NULL,145324,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,4,0),(20,'Perdue Simply Smart Organics Gluten Free','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/20.jpg\",\"products\\/20-1.jpg\"]','HS-122-A0',0,11,0,1,1,4,0,0,110,94.6,NULL,NULL,14.00,18.00,10.00,659.00,NULL,124079,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,1,0),(21,'Chen Watermelon (Digital)','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/21.jpg\",\"products\\/21-1.jpg\"]','HS-161-A0',0,19,0,1,1,6,0,0,126,NULL,NULL,NULL,15.00,17.00,12.00,712.00,NULL,103394,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,1,0),(22,'Organic Cage-Free Grade A Large Brown Eggs','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/22.jpg\",\"products\\/22-1.jpg\"]','HS-178-A0',0,19,0,1,1,5,0,0,116,NULL,NULL,NULL,16.00,13.00,14.00,507.00,NULL,134342,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,3,0),(23,'Colorful Banana','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/23.jpg\",\"products\\/23-1.jpg\"]','HS-110-A0',0,20,0,1,1,5,0,0,121,NULL,NULL,NULL,19.00,12.00,20.00,590.00,NULL,130149,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,5,0),(24,'Signature Wood-Fired Mushroom and Caramelized','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline.</p>\n<p><img src=\"/storage/general/clock.png\" alt=\"icon\" style=\"height:15px;\">  1 Year AL Jazeera Brand Warranty\n</p>\n<p><img src=\"/storage/general/paper-plane.png\" alt=\"icon\" style=\"height:15px;\">   30 Day Return Policy</p>\n<p><img src=\"/storage/general/credit-card.png\" alt=\"icon\" style=\"height:15px;\">  Cash on Delivery available\n</p>\n','<p>Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string\n    detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in\n    cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic\n    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\n    information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean\n    and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising\n    from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody-\n    but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy\n    days, issuing an invitation to explore even in the most mercurial weather.</p>\n','published','[\"products\\/24.jpg\",\"products\\/24-1.jpg\"]','HS-156-A0',0,17,0,1,1,4,0,0,114,93.48,NULL,NULL,12.00,12.00,10.00,832.00,NULL,26127,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,4,0),(25,'Seeds of Change Organic Quinoe (Digital)',NULL,NULL,'published','[\"products\\/1.jpg\"]','HS-173-A0',0,16,0,1,0,1,1,0,391,NULL,NULL,NULL,15.00,16.00,18.00,688.00,NULL,0,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(26,'All Natural Italian-Style Chicken Meatballs',NULL,NULL,'published','[\"products\\/2.jpg\"]','HS-176-A0',0,18,0,1,0,7,1,0,387,NULL,NULL,NULL,20.00,16.00,18.00,841.00,NULL,0,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(27,'Angie’s Boomchickapop Sweet & Salty Kettle Corn',NULL,NULL,'published','[\"products\\/3.jpg\"]','HS-153-A0',0,19,0,1,0,1,1,0,451,NULL,NULL,NULL,19.00,11.00,18.00,805.00,NULL,0,'2024-02-24 01:32:31','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(28,'Foster Farms Takeout Crispy Classic',NULL,NULL,'published','[\"products\\/4.jpg\"]','HS-105-A0',0,13,0,1,0,1,1,0,88,66,NULL,NULL,18.00,18.00,13.00,519.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(29,'Foster Farms Takeout Crispy Classic',NULL,NULL,'published','[\"products\\/4-1.jpg\"]','HS-105-A0-A1',0,13,0,1,0,1,1,0,88,63.36,NULL,NULL,18.00,18.00,13.00,519.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(30,'Blue Diamond Almonds Lightly (Digital)',NULL,NULL,'published','[\"products\\/5.jpg\"]','HS-189-A0',0,19,0,1,0,3,1,0,50,NULL,NULL,NULL,19.00,10.00,15.00,875.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(31,'Blue Diamond Almonds Lightly (Digital)',NULL,NULL,'published','[\"products\\/5-1.jpg\"]','HS-189-A0-A1',0,19,0,1,0,3,1,0,50,NULL,NULL,NULL,19.00,10.00,15.00,875.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(32,'Chobani Complete Vanilla Greek',NULL,NULL,'published','[\"products\\/6.jpg\"]','HS-171-A0',0,19,0,1,0,7,1,0,55,NULL,NULL,NULL,16.00,14.00,19.00,641.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(33,'Canada Dry Ginger Ale – 2 L Bottle',NULL,NULL,'published','[\"products\\/7.jpg\"]','HS-138-A0',0,18,0,1,0,5,1,0,117,NULL,NULL,NULL,13.00,14.00,16.00,517.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(34,'Canada Dry Ginger Ale – 2 L Bottle',NULL,NULL,'published','[\"products\\/7-1.jpg\"]','HS-138-A0-A1',0,18,0,1,0,5,1,0,117,NULL,NULL,NULL,13.00,14.00,16.00,517.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(35,'Encore Seafoods Stuffed Alaskan',NULL,NULL,'published','[\"products\\/8.jpg\"]','HS-179-A0',0,15,0,1,0,7,1,0,114,87.78,NULL,NULL,15.00,18.00,19.00,725.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(36,'Encore Seafoods Stuffed Alaskan',NULL,NULL,'published','[\"products\\/8-1.jpg\"]','HS-179-A0-A1',0,15,0,1,0,7,1,0,114,87.78,NULL,NULL,15.00,18.00,19.00,725.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(37,'Gorton’s Beer Battered Fish Fillets (Digital)',NULL,NULL,'published','[\"products\\/9.jpg\"]','HS-156-A0',0,15,0,1,0,3,1,0,119,NULL,NULL,NULL,20.00,14.00,20.00,791.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(38,'Gorton’s Beer Battered Fish Fillets (Digital)',NULL,NULL,'published','[\"products\\/9-1.jpg\"]','HS-156-A0-A1',0,15,0,1,0,3,1,0,119,NULL,NULL,NULL,20.00,14.00,20.00,791.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(39,'Haagen-Dazs Caramel Cone Ice Cream',NULL,NULL,'published','[\"products\\/10.jpg\"]','HS-116-A0',0,17,0,1,0,7,1,0,500,NULL,NULL,NULL,17.00,20.00,20.00,879.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(40,'Haagen-Dazs Caramel Cone Ice Cream',NULL,NULL,'published','[\"products\\/10-1.jpg\"]','HS-116-A0-A1',0,17,0,1,0,7,1,0,500,NULL,NULL,NULL,17.00,20.00,20.00,879.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(41,'Haagen-Dazs Caramel Cone Ice Cream',NULL,NULL,'published','[\"products\\/10.jpg\"]','HS-116-A0-A2',0,17,0,1,0,7,1,0,500,NULL,NULL,NULL,17.00,20.00,20.00,879.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(42,'Haagen-Dazs Caramel Cone Ice Cream',NULL,NULL,'published','[\"products\\/10.jpg\"]','HS-116-A0-A3',0,17,0,1,0,7,1,0,500,NULL,NULL,NULL,17.00,20.00,20.00,879.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(43,'Haagen-Dazs Caramel Cone Ice Cream',NULL,NULL,'published','[\"products\\/10.jpg\"]','HS-116-A0-A4',0,17,0,1,0,7,1,0,500,NULL,NULL,NULL,17.00,20.00,20.00,879.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(44,'Nestle Original Coffee-Mate Coffee Creamer',NULL,NULL,'published','[\"products\\/11.jpg\"]','HS-178-A0',0,19,0,1,0,6,1,0,114,NULL,NULL,NULL,15.00,15.00,10.00,576.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(45,'Nestle Original Coffee-Mate Coffee Creamer',NULL,NULL,'published','[\"products\\/11-1.jpg\"]','HS-178-A0-A1',0,19,0,1,0,6,1,0,114,NULL,NULL,NULL,15.00,15.00,10.00,576.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(46,'Naturally Flavored Cinnamon Vanilla Light Roast Coffee',NULL,NULL,'published','[\"products\\/12.jpg\"]','HS-171-A0',0,14,0,1,0,3,1,0,129,90.3,NULL,NULL,15.00,10.00,13.00,871.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(47,'Naturally Flavored Cinnamon Vanilla Light Roast Coffee',NULL,NULL,'published','[\"products\\/12-1.jpg\"]','HS-171-A0-A1',0,14,0,1,0,3,1,0,129,107.07,NULL,NULL,15.00,10.00,13.00,871.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(48,'Naturally Flavored Cinnamon Vanilla Light Roast Coffee',NULL,NULL,'published','[\"products\\/12.jpg\"]','HS-171-A0-A2',0,14,0,1,0,3,1,0,129,105.78,NULL,NULL,15.00,10.00,13.00,871.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(49,'Pepperidge Farm Farmhouse Hearty White Bread (Digital)',NULL,NULL,'published','[\"products\\/13.jpg\"]','HS-131-A0',0,19,0,1,0,7,1,0,117,NULL,NULL,NULL,19.00,20.00,20.00,752.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(50,'Pepperidge Farm Farmhouse Hearty White Bread (Digital)',NULL,NULL,'published','[\"products\\/13-1.jpg\"]','HS-131-A0-A1',0,19,0,1,0,7,1,0,117,NULL,NULL,NULL,19.00,20.00,20.00,752.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(51,'Pepperidge Farm Farmhouse Hearty White Bread (Digital)',NULL,NULL,'published','[\"products\\/13.jpg\"]','HS-131-A0-A2',0,19,0,1,0,7,1,0,117,NULL,NULL,NULL,19.00,20.00,20.00,752.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(52,'Organic Frozen Triple Berry Blend',NULL,NULL,'published','[\"products\\/14.jpg\"]','HS-115-A0',0,13,0,1,0,5,1,0,125,NULL,NULL,NULL,20.00,13.00,18.00,773.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(53,'Organic Frozen Triple Berry Blend',NULL,NULL,'published','[\"products\\/14-1.jpg\"]','HS-115-A0-A1',0,13,0,1,0,5,1,0,125,NULL,NULL,NULL,20.00,13.00,18.00,773.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(54,'Organic Frozen Triple Berry Blend',NULL,NULL,'published','[\"products\\/14.jpg\"]','HS-115-A0-A2',0,13,0,1,0,5,1,0,125,NULL,NULL,NULL,20.00,13.00,18.00,773.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(55,'Oroweat Country Buttermilk Bread',NULL,NULL,'published','[\"products\\/15.jpg\"]','HS-177-A0',0,14,0,1,0,4,1,0,127,NULL,NULL,NULL,14.00,10.00,12.00,678.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(56,'Oroweat Country Buttermilk Bread',NULL,NULL,'published','[\"products\\/15-1.jpg\"]','HS-177-A0-A1',0,14,0,1,0,4,1,0,127,NULL,NULL,NULL,14.00,10.00,12.00,678.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(57,'Oroweat Country Buttermilk Bread',NULL,NULL,'published','[\"products\\/15.jpg\"]','HS-177-A0-A2',0,14,0,1,0,4,1,0,127,NULL,NULL,NULL,14.00,10.00,12.00,678.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(58,'Oroweat Country Buttermilk Bread',NULL,NULL,'published','[\"products\\/15.jpg\"]','HS-177-A0-A3',0,14,0,1,0,4,1,0,127,NULL,NULL,NULL,14.00,10.00,12.00,678.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(59,'Foster Farms Takeout Crispy Classic Buffalo Wings',NULL,NULL,'published','[\"products\\/16.jpg\"]','HS-196-A0',0,12,0,1,0,3,1,0,116,103.24,NULL,NULL,19.00,13.00,20.00,718.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(60,'Angie’s Boomchickapop Sweet & Salty Kettle Corn (Digital)',NULL,NULL,'published','[\"products\\/17.jpg\"]','HS-183-A0',0,14,0,1,0,7,1,0,112,NULL,NULL,NULL,13.00,18.00,12.00,815.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(61,'Angie’s Boomchickapop Sweet & Salty Kettle Corn (Digital)',NULL,NULL,'published','[\"products\\/17-1.jpg\"]','HS-183-A0-A1',0,14,0,1,0,7,1,0,112,NULL,NULL,NULL,13.00,18.00,12.00,815.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(62,'Angie’s Boomchickapop Sweet & Salty Kettle Corn (Digital)',NULL,NULL,'published','[\"products\\/17.jpg\"]','HS-183-A0-A2',0,14,0,1,0,7,1,0,112,NULL,NULL,NULL,13.00,18.00,12.00,815.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(63,'Angie’s Boomchickapop Sweet & Salty Kettle Corn (Digital)',NULL,NULL,'published','[\"products\\/17.jpg\"]','HS-183-A0-A3',0,14,0,1,0,7,1,0,112,NULL,NULL,NULL,13.00,18.00,12.00,815.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(64,'All Natural Italian-Style Chicken Meatballs',NULL,NULL,'published','[\"products\\/18.jpg\"]','HS-133-A0',0,15,0,1,0,6,1,0,123,NULL,NULL,NULL,18.00,12.00,19.00,675.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(65,'All Natural Italian-Style Chicken Meatballs',NULL,NULL,'published','[\"products\\/18-1.jpg\"]','HS-133-A0-A1',0,15,0,1,0,6,1,0,123,NULL,NULL,NULL,18.00,12.00,19.00,675.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(66,'Simply Lemonade with Raspberry Juice',NULL,NULL,'published','[\"products\\/19.jpg\"]','HS-121-A0',0,17,0,1,0,2,1,0,112,NULL,NULL,NULL,15.00,15.00,10.00,595.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(67,'Simply Lemonade with Raspberry Juice',NULL,NULL,'published','[\"products\\/19-1.jpg\"]','HS-121-A0-A1',0,17,0,1,0,2,1,0,112,NULL,NULL,NULL,15.00,15.00,10.00,595.00,NULL,0,'2024-02-24 01:32:32','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(68,'Simply Lemonade with Raspberry Juice',NULL,NULL,'published','[\"products\\/19.jpg\"]','HS-121-A0-A2',0,17,0,1,0,2,1,0,112,NULL,NULL,NULL,15.00,15.00,10.00,595.00,NULL,0,'2024-02-24 01:32:33','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(69,'Simply Lemonade with Raspberry Juice',NULL,NULL,'published','[\"products\\/19.jpg\"]','HS-121-A0-A3',0,17,0,1,0,2,1,0,112,NULL,NULL,NULL,15.00,15.00,10.00,595.00,NULL,0,'2024-02-24 01:32:33','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(70,'Simply Lemonade with Raspberry Juice',NULL,NULL,'published','[\"products\\/19.jpg\"]','HS-121-A0-A4',0,17,0,1,0,2,1,0,112,NULL,NULL,NULL,15.00,15.00,10.00,595.00,NULL,0,'2024-02-24 01:32:33','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(71,'Perdue Simply Smart Organics Gluten Free',NULL,NULL,'published','[\"products\\/20.jpg\"]','HS-122-A0',0,11,0,1,0,4,1,0,110,94.6,NULL,NULL,14.00,18.00,10.00,659.00,NULL,0,'2024-02-24 01:32:33','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(72,'Perdue Simply Smart Organics Gluten Free',NULL,NULL,'published','[\"products\\/20-1.jpg\"]','HS-122-A0-A1',0,11,0,1,0,4,1,0,110,99,NULL,NULL,14.00,18.00,10.00,659.00,NULL,0,'2024-02-24 01:32:33','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(73,'Perdue Simply Smart Organics Gluten Free',NULL,NULL,'published','[\"products\\/20.jpg\"]','HS-122-A0-A2',0,11,0,1,0,4,1,0,110,92.4,NULL,NULL,14.00,18.00,10.00,659.00,NULL,0,'2024-02-24 01:32:33','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(74,'Perdue Simply Smart Organics Gluten Free',NULL,NULL,'published','[\"products\\/20.jpg\"]','HS-122-A0-A3',0,11,0,1,0,4,1,0,110,84.7,NULL,NULL,14.00,18.00,10.00,659.00,NULL,0,'2024-02-24 01:32:33','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(75,'Chen Watermelon (Digital)',NULL,NULL,'published','[\"products\\/21.jpg\"]','HS-161-A0',0,19,0,1,0,6,1,0,126,NULL,NULL,NULL,15.00,17.00,12.00,712.00,NULL,0,'2024-02-24 01:32:33','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(76,'Chen Watermelon (Digital)',NULL,NULL,'published','[\"products\\/21-1.jpg\"]','HS-161-A0-A1',0,19,0,1,0,6,1,0,126,NULL,NULL,NULL,15.00,17.00,12.00,712.00,NULL,0,'2024-02-24 01:32:33','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'digital',NULL,NULL,0,NULL,0),(77,'Organic Cage-Free Grade A Large Brown Eggs',NULL,NULL,'published','[\"products\\/22.jpg\"]','HS-178-A0',0,19,0,1,0,5,1,0,116,NULL,NULL,NULL,16.00,13.00,14.00,507.00,NULL,0,'2024-02-24 01:32:33','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(78,'Colorful Banana',NULL,NULL,'published','[\"products\\/23.jpg\"]','HS-110-A0',0,20,0,1,0,5,1,0,121,NULL,NULL,NULL,19.00,12.00,20.00,590.00,NULL,0,'2024-02-24 01:32:33','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(79,'Colorful Banana',NULL,NULL,'published','[\"products\\/23-1.jpg\"]','HS-110-A0-A1',0,20,0,1,0,5,1,0,121,NULL,NULL,NULL,19.00,12.00,20.00,590.00,NULL,0,'2024-02-24 01:32:33','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0),(80,'Signature Wood-Fired Mushroom and Caramelized',NULL,NULL,'published','[\"products\\/24.jpg\"]','HS-156-A0',0,17,0,1,0,4,1,0,114,93.48,NULL,NULL,12.00,12.00,10.00,832.00,NULL,0,'2024-02-24 01:32:33','2024-02-24 01:32:48','in_stock',0,'Botble\\ACL\\Models\\User',NULL,'physical',NULL,NULL,0,NULL,0);

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

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

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


--
-- Table structure for table `ec_review_replies`
--

CREATE TABLE `ec_review_replies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `review_id` bigint unsigned NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_review_replies_review_id_user_id_unique` (`review_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_review_replies`
--


--
