--
-- Host: 127.0.0.1    Database: amerce
-- ------------------------------------------------------


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

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

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

INSERT INTO `activations` VALUES (1,1,'UyTeISH0oo4vzNUUpLArfgMc7b3DaAwF',1,'2026-05-28 19:07:05','2026-05-28 19:07:05','2026-05-28 19:07:05');

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

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

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


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

CREATE TABLE `ads_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ads_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tablet_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_image` 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 `announcements`
--

CREATE TABLE `announcements` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `has_action` tinyint(1) NOT NULL DEFAULT '0',
  `action_label` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action_url` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action_open_new_tab` tinyint(1) NOT NULL DEFAULT '0',
  `dismissible` tinyint(1) NOT NULL DEFAULT '0',
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `announcements`
--


--
-- Table structure for table `announcements_translations`
--

CREATE TABLE `announcements_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `announcements_id` bigint unsigned NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `action_label` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`announcements_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `announcements_translations`
--


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

CREATE TABLE `audit_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `user_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Botble\\ACL\\Models\\User',
  `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,
  `actor_id` bigint unsigned NOT NULL,
  `actor_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Botble\\ACL\\Models\\User',
  `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` text COLLATE utf8mb4_unicode_ci,
  `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` int unsigned 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=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` VALUES (1,'Mindful Living',0,'Daily practices, breathwork, and habits that help you find calm in everyday moments.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2026-05-28 19:07:07','2026-05-28 19:07:07'),(2,'Sleep &amp; Recovery',0,'Evidence-based guides to better sleep, deep rest, and post-stress recovery.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:07:07','2026-05-28 19:07:07'),(3,'Nutrition &amp; Supplements',0,'Clean nutrition, adaptogens, and the science of how food affects mood.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:07:07','2026-05-28 19:07:07'),(4,'Movement &amp; Breath',0,'Gentle yoga, walking meditations, and breathwork practices for an embodied calm.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:07:07','2026-05-28 19:07:07'),(5,'Stress Management',0,'Tools and frameworks for navigating modern stress with intention and resilience.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:07:07','2026-05-28 19:07:07');

--
-- 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` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`categories_id`),
  KEY `idx_categories_trans_categories_id` (`categories_id`),
  KEY `idx_categories_trans_category_lang` (`categories_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories_translations` VALUES ('ar',1,'العيش الواعي','تساعدك الممارسات اليومية وتمارين التنفس والعادات على إيجاد السلام في كل لحظة.'),('ar',2,'Sleep &amp; Recovery','Evidence-based guides to better sleep, deep rest, and post-stress recovery.'),('ar',3,'Nutrition &amp; Supplements','Clean nutrition, adaptogens, and the science of how food affects mood.'),('ar',4,'Movement &amp; Breath','Gentle yoga, walking meditations, and breathwork practices for an embodied calm.'),('ar',5,'إدارة الإجهاد','الأدوات والأطر المرجعية للتغلب على الضغوط الحديثة بالقصد والمثابرة.'),('fr',1,'Vivre en pleine conscience','Les pratiques quotidiennes, les exercices de respiration et les habitudes vous aident à trouver la paix à chaque instant.'),('fr',2,'Sleep &amp; Recovery','Evidence-based guides to better sleep, deep rest, and post-stress recovery.'),('fr',3,'Nutrition &amp; Supplements','Clean nutrition, adaptogens, and the science of how food affects mood.'),('fr',4,'Movement &amp; Breath','Gentle yoga, walking meditations, and breathwork practices for an embodied calm.'),('fr',5,'Gestion du stress','Outils et cadres de référence pour surmonter le stress moderne avec intention et persévérance.'),('id',1,'Hidup Penuh Perhatian','Latihan harian, latihan pernapasan, dan kebiasaan membantu Anda menemukan kedamaian setiap saat.'),('id',2,'Sleep &amp; Recovery','Evidence-based guides to better sleep, deep rest, and post-stress recovery.'),('id',3,'Nutrition &amp; Supplements','Clean nutrition, adaptogens, and the science of how food affects mood.'),('id',4,'Movement &amp; Breath','Gentle yoga, walking meditations, and breathwork practices for an embodied calm.'),('id',5,'Manajemen Stres','Alat dan kerangka acuan untuk mengatasi stres modern dengan niat dan ketekunan.'),('tr',1,'Farkında Yaşamak','Günlük uygulamalar, nefes egzersizleri ve alışkanlıklar her an huzuru bulmanıza yardımcı olur.'),('tr',2,'Sleep &amp; Recovery','Evidence-based guides to better sleep, deep rest, and post-stress recovery.'),('tr',3,'Nutrition &amp; Supplements','Clean nutrition, adaptogens, and the science of how food affects mood.'),('tr',4,'Movement &amp; Breath','Gentle yoga, walking meditations, and breathwork practices for an embodied calm.'),('tr',5,'Stres Yönetimi','Modern stresin niyet ve kararlılıkla üstesinden gelmek için araçlar ve referans çerçeveleri.'),('vi',1,'Sống chánh niệm','Những thực hành, bài tập thở và thói quen hằng ngày giúp bạn tìm thấy sự bình yên trong từng khoảnh khắc.'),('vi',2,'Sleep &amp; Recovery','Evidence-based guides to better sleep, deep rest, and post-stress recovery.'),('vi',3,'Nutrition &amp; Supplements','Clean nutrition, adaptogens, and the science of how food affects mood.'),('vi',4,'Movement &amp; Breath','Gentle yoga, walking meditations, and breathwork practices for an embodied calm.'),('vi',5,'Quản lý căng thẳng','Công cụ và khung tham chiếu để vượt qua căng thẳng hiện đại với sự chủ ý và bền bỉ.');

--
-- 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,
  `zip_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cities_slug_unique` (`slug`),
  KEY `idx_cities_name` (`name`),
  KEY `idx_cities_state_status` (`state_id`,`status`),
  KEY `idx_cities_status` (`status`),
  KEY `idx_cities_state_id` (`state_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `cities_translations` (
  `lang_code` varchar(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`),
  KEY `idx_cities_trans_city_lang` (`cities_id`,`lang_code`),
  KEY `idx_cities_trans_name` (`name`),
  KEY `idx_cities_trans_cities_id` (`cities_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `contact_custom_field_options`
--

CREATE TABLE `contact_custom_field_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `custom_field_id` bigint unsigned NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL DEFAULT '999',
  `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_custom_field_options`
--


--
-- Table structure for table `contact_custom_field_options_translations`
--

CREATE TABLE `contact_custom_field_options_translations` (
  `contact_custom_field_options_id` bigint unsigned NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`contact_custom_field_options_id`),
  KEY `idx_contact_cfo_trans_cfo_id` (`contact_custom_field_options_id`),
  KEY `idx_contact_cfo_trans_cfo_lang` (`contact_custom_field_options_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_custom_field_options_translations`
--


--
-- Table structure for table `contact_custom_fields`
--

CREATE TABLE `contact_custom_fields` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `placeholder` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int NOT NULL DEFAULT '999',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_custom_fields`
--


--
-- Table structure for table `contact_custom_fields_translations`
--

CREATE TABLE `contact_custom_fields_translations` (
  `contact_custom_fields_id` bigint unsigned NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placeholder` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`contact_custom_fields_id`),
  KEY `idx_contact_cf_trans_cf_id` (`contact_custom_fields_id`),
  KEY `idx_contact_cf_trans_cf_lang` (`contact_custom_fields_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_custom_fields_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 DEFAULT 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,
  `custom_fields` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unread',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `contacts` VALUES (1,'Sophia Bennett','sophia.bennett@example.com','+1-415-555-0142','124 Folsom Street, San Francisco, CA','Question about international shipping rates','Hi team — could you tell me whether you ship to Singapore and what the typical delivery window is for the spring outerwear collection? Many thanks.',NULL,'read','2026-05-28 19:07:05','2026-05-28 19:07:05'),(2,'Marcus Tan','marcus.tan@example.com','+44-20-7946-0312','47 Hatton Garden, London EC1N','Wholesale enquiry — boutique partnership','Good morning. I run a curated mens boutique in central London. We would love to discuss stocking a small selection of your accessories range. Could you send over your wholesale lookbook and minimum order quantities?',NULL,'unread','2026-05-28 19:07:05','2026-05-28 19:07:05'),(3,'Elena Rodriguez','elena.rodriguez@example.com','+34-93-555-0188','Carrer de Mallorca 287, Barcelona','Order #AM-10458 — color confirmation','Could you confirm the exact shade of the walnut side table I ordered last week? I want to make sure it matches the rest of my living room before it ships.',NULL,'read','2026-05-28 19:07:05','2026-05-28 19:07:05');

--
-- 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',
  `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,
  `code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_countries_name` (`name`),
  KEY `idx_countries_status` (`status`)
) 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`),
  KEY `idx_countries_trans_country_lang` (`countries_id`,`lang_code`),
  KEY `idx_countries_trans_name` (`name`),
  KEY `idx_countries_trans_countries_id` (`countries_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

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

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


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

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

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


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

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

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

INSERT INTO `ec_brands` VALUES (1,'Findr','Adaptogenic blends and clean supplements for everyday calm.','https://example.com/findr','brands/findr.png','published',0,1,'2026-05-28 19:07:08','2026-05-28 19:07:08'),(2,'Intdeco','Calming home accents and mindful living essentials.','https://example.com/intdeco','brands/intdeco.png','published',1,1,'2026-05-28 19:07:08','2026-05-28 19:07:08'),(3,'Modave','Botanical wellness skincare and body care, crafted in small batches.','https://example.com/modave','brands/modave.png','published',2,1,'2026-05-28 19:07:08','2026-05-28 19:07:08'),(4,'Sopify','Smart wellness devices designed for daily mindfulness practice.','https://example.com/sopify','brands/sopify.png','published',3,1,'2026-05-28 19:07:08','2026-05-28 19:07:08'),(5,'Vanfava','Plant-based superfoods and clean nutrition essentials.','https://example.com/vanfava','brands/vanfava.png','published',4,1,'2026-05-28 19:07:08','2026-05-28 19:07:08');

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

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

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

INSERT INTO `ec_brands_translations` VALUES ('ar',1,'مكتشف','معدات صوتية مصممة لتحقيق وضوح بجودة الاستوديو في البيئات اليومية.'),('ar',2,'انتديكو','تجمع المزايا الداخلية بين البساطة والراحة.'),('ar',3,'موداف','معدات تدريب عالية الأداء مصنوعة من نسيج مطاطي مُعاد تدويره.'),('ar',4,'سوبيفاي','أجهزة منزلية ذكية مصممة للمستأجرين والزوار.'),('ar',5,'فانفافا','الأطعمة النباتية الفائقة والأساسيات الغذائية النظيفة.'),('fr',1,'Trouver','Équipement audio conçu pour une clarté de qualité studio dans les environnements quotidiens.'),('fr',2,'Intdéco','Les points forts de l\'intérieur allient minimalisme et confort.'),('fr',3,'Modave','Équipement d\'entraînement haute performance fabriqué à partir de tissu extensible recyclé.'),('fr',4,'Sopifier','Appareils domestiques intelligents conçus pour les locataires et les visiteurs.'),('fr',5,'Vanfava','Superaliments à base de plantes et éléments nutritifs essentiels.'),('id',1,'Temukan','Perlengkapan audio dirancang untuk kejernihan kualitas studio di lingkungan sehari-hari.'),('id',2,'Intdeco','Sorotan interior memadukan minimalis dan kenyamanan.'),('id',3,'Modifikasi','Perlengkapan latihan berperforma tinggi yang terbuat dari kain stretch daur ulang.'),('id',4,'Sopify','Perangkat rumah pintar yang dirancang untuk penyewa dan pengunjung.'),('id',5,'Vanfava','Makanan super nabati dan nutrisi penting yang bersih.'),('tr',1,'Bulucu','Günlük ortamlarda stüdyo kalitesinde netlik için tasarlanmış ses ekipmanı.'),('tr',2,'Indeco','İç mekandaki vurgular minimalizm ve rahatlığı birleştiriyor.'),('tr',3,'modave','Geri dönüştürülmüş esnek kumaştan yapılmış yüksek performanslı antrenman ekipmanı.'),('tr',4,'sopify','Kiracılar ve ziyaretçiler için tasarlanmış akıllı ev cihazları.'),('tr',5,'Vanfava','Bitki bazlı süper gıdalar ve temiz beslenme esasları.'),('vi',1,'Findr','Thiết bị âm thanh thiết kế cho độ rõ chuẩn studio trong môi trường thường ngày.'),('vi',2,'Intdeco','Điểm nhấn nội thất kết hợp giữa tối giản và ấm cúng.'),('vi',3,'Modave','Đồ tập hiệu năng cao làm từ vải thun co giãn tái chế.'),('vi',4,'Sopify','Thiết bị nhà thông minh thiết kế dành cho người thuê nhà và du khách.'),('vi',5,'Vanfava','Siêu thực phẩm từ thực vật và những vật dụng dinh dưỡng sạch thiết yếu.');

--
-- 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,
  `customer_id` bigint unsigned DEFAULT 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`),
  KEY `ec_cart_customer_instance_index` (`customer_id`,`instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `ec_currencies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_prefix_symbol` tinyint unsigned NOT NULL DEFAULT '0',
  `decimals` tinyint unsigned DEFAULT '0',
  `number_format_style` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'western',
  `space_between_price_and_currency` tinyint(1) NOT NULL 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,'western',0,0,1,1,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(2,'EUR','€',0,2,'western',0,1,0,0.84,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(3,'VND','₫',0,0,'western',0,2,0,23203,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(4,'NGN','₦',1,2,'western',0,2,0,895.52,'2026-05-28 19:07:06','2026-05-28 19:07:06');

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

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

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

INSERT INTO `ec_customer_addresses` VALUES (1,'Emma Collins','customer@botble.com','+1-555-0105','GB','Pennsylvania','Chicago','987 Birch Boulevard',1,1,'2026-05-28 19:07:14','2026-05-28 19:07:14','30301'),(2,'Emma Collins','customer@botble.com','+1-555-0104','CA','Illinois','Houston','123 Main Street',1,0,'2026-05-28 19:07:14','2026-05-28 19:07:14','10001'),(3,'Sophia Ramirez','vendor@botble.com','+1-555-0109','DE','New York','Austin','258 Walnut Way',2,1,'2026-05-28 19:07:14','2026-05-28 19:07:14','33101'),(4,'Sophia Ramirez','vendor@botble.com','+1-555-0110','AU','Michigan','Miami','369 Cherry Circle',2,0,'2026-05-28 19:07:14','2026-05-28 19:07:14','90210'),(5,'Olivia Carter','customer1@example.com','+1-555-0110','CA','Arizona','Denver','147 Elm Court',3,1,'2026-05-28 19:07:15','2026-05-28 19:07:15','30301'),(6,'Ava Mitchell','customer2@example.com','+1-555-0101','DE','California','Miami','789 Pine Road',4,1,'2026-05-28 19:07:15','2026-05-28 19:07:15','80201'),(7,'Isabella Brooks','customer3@example.com','+1-555-0105','GB','New York','Dallas','369 Cherry Circle',5,1,'2026-05-28 19:07:15','2026-05-28 19:07:15','30301'),(8,'James Whitfield','customer4@example.com','+1-555-0101','AU','New York','Miami','741 Spruce Street',6,1,'2026-05-28 19:07:15','2026-05-28 19:07:15','90210'),(9,'Liam Bennett','customer5@example.com','+1-555-0107','US','New York','New York','741 Spruce Street',7,1,'2026-05-28 19:07:16','2026-05-28 19:07:16','10001'),(10,'Noah Patterson','customer6@example.com','+1-555-0101','CA','Michigan','Denver','147 Elm Court',8,1,'2026-05-28 19:07:16','2026-05-28 19:07:16','30301'),(11,'Charlotte Reed','customer7@example.com','+1-555-0106','DE','California','Los Angeles','789 Pine Road',9,1,'2026-05-28 19:07:16','2026-05-28 19:07:16','48201'),(12,'Amelia Foster','customer8@example.com','+1-555-0108','CA','Pennsylvania','Austin','123 Main Street',10,1,'2026-05-28 19:07:16','2026-05-28 19:07:16','80201');

--
-- Table structure for table `ec_customer_recently_viewed_products`
--

CREATE TABLE `ec_customer_recently_viewed_products` (
  `customer_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`customer_id`,`product_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',
  `can_use_with_flash_sale` 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,
  `store_id` bigint unsigned DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_discounts_code_unique` (`code`),
  KEY `ec_discounts_store_id_index` (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_discounts` VALUES (1,'Welcome 10% Off','WELCOME10','2026-05-28 02:07:17','2026-07-28 02:07:17',NULL,0,10,'coupon',0,0,NULL,NULL,'percentage','all-orders',0.00,0,1,'2026-05-28 19:07:17','2026-05-28 19:07:17',NULL,'A welcome discount for first-time shoppers — 10% off any order.'),(2,'Free Shipping Over $50','FREESHIP','2026-05-28 02:07:17',NULL,NULL,0,100,'coupon',0,0,NULL,NULL,'shipping','all-orders',50.00,0,1,'2026-05-28 19:07:17','2026-05-28 19:07:17',NULL,'Free shipping on any order $50 or above.'),(3,'Spring Sale — $25 Off','SPRING25','2026-05-28 02:07:17','2026-06-28 02:07:17',500,0,25,'coupon',0,0,NULL,NULL,'amount','all-orders',150.00,0,1,'2026-05-28 19:07:17','2026-05-28 19:07:17',NULL,'A flat $25 off orders over $150.'),(4,'VIP Member 20% Off','VIP20','2026-05-28 02:07:17','2026-08-27 02:07:17',NULL,0,20,'coupon',0,0,NULL,NULL,'percentage','all-orders',100.00,0,1,'2026-05-28 19:07:17','2026-05-28 19:07:17',NULL,'Exclusive 20% off for newsletter subscribers.'),(5,'Bundle & Save $50','BUNDLE50','2026-05-28 02:07:17','2026-07-13 02:07:17',NULL,0,50,'coupon',0,0,NULL,NULL,'amount','all-orders',300.00,0,1,'2026-05-28 19:07:17','2026-05-28 19:07:17',NULL,'Save $50 when you spend $300 or more.');

--
-- 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',
  KEY `ec_flash_sale_products_product_id_flash_sale_id_index` (`product_id`,`flash_sale_id`)
) 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,37.8,50,0),(1,2,27.3,50,0),(1,5,30.8,50,0),(1,7,20.3,50,0),(1,3,23.8,50,0),(1,4,55.3,50,0),(1,8,62.3,50,0),(1,9,16.8,50,0),(1,1,34.3,50,0),(2,3,25.5,75,0),(2,9,18,75,0),(2,5,33,75,0),(2,2,29.25,75,0),(2,6,40.5,75,0),(2,8,66.75,75,0),(2,7,21.75,75,0),(2,1,36.75,75,0);

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

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

INSERT INTO `ec_flash_sales` VALUES (1,'48-Hour Flash Sale','2026-05-31 02:07:16','published','2026-05-28 19:07:16','2026-05-28 19:07:16'),(2,'Weekend Doorbusters','2026-06-03 02:07:17','published','2026-05-28 19:07:17','2026-05-28 19:07:17');

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

CREATE TABLE `ec_flash_sales_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_flash_sales_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_flash_sales_id`),
  KEY `idx_flash_sales_fk` (`ec_flash_sales_id`),
  KEY `idx_flash_sales_flash_sales_lang` (`ec_flash_sales_id`,`lang_code`)
) 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` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `option_id` bigint unsigned NOT NULL COMMENT 'option id',
  `option_value` tinytext COLLATE utf8mb4_unicode_ci COMMENT 'option value',
  `affect_price` double DEFAULT NULL COMMENT 'value of price of this option affect',
  `order` int NOT NULL DEFAULT '9999',
  `affect_type` tinyint NOT NULL DEFAULT '0' COMMENT '0. fixed 1. percent',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_global_option_value` VALUES (1,1,'No gift wrap',0,0,0,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(2,1,'Standard kraft wrap',4.99,1,0,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(3,1,'Premium silk-ribbon wrap',9.99,2,0,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(4,2,'Up to 20 characters',14.99,0,0,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(5,3,'Standard 1-year warranty',0,0,0,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(6,3,'2-year extended warranty',29.99,1,0,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(7,3,'3-year premium care',59.99,2,0,'2026-05-28 19:07:06','2026-05-28 19:07:06');

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

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

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

INSERT INTO `ec_global_option_value_translations` VALUES ('ar',1,'لا يوجد تغليف هدايا'),('ar',2,'حزمة ورق الكرافت القياسية'),('ar',3,'حزمة الشريط الحريري الفاخر'),('ar',4,'الحد الأقصى 20 حرفا'),('ar',5,'ضمان قياسي لمدة سنة واحدة'),('ar',6,'ضمان ممتد لمدة عامين'),('ar',7,'رعاية متميزة لمدة 3 سنوات'),('fr',1,'Pas d\'emballage cadeau'),('fr',2,'Emballage en papier kraft standard'),('fr',3,'Paquet de rubans de soie haut de gamme'),('fr',4,'20 caractères maximum'),('fr',5,'Garantie standard 1 an'),('fr',6,'Garantie prolongée de 2 ans'),('fr',7,'Soins premium pendant 3 ans'),('id',1,'Tidak ada bungkus kado'),('id',2,'Paket kertas kraft standar'),('id',3,'Paket pita sutra premium'),('id',4,'Maksimum 20 karakter'),('id',5,'Garansi standar 1 tahun'),('id',6,'Garansi diperpanjang 2 tahun'),('id',7,'Perawatan premium selama 3 tahun'),('tr',1,'Hediye paketi yok'),('tr',2,'Standart kraft kağıt paketi'),('tr',3,'Premium ipek kurdele paketi'),('tr',4,'Maksimum 20 karakter'),('tr',5,'Standart 1 yıl garanti'),('tr',6,'2 yıl uzatılmış garanti'),('tr',7,'3 yıl boyunca premium bakım'),('vi',1,'Không gói quà'),('vi',2,'Gói giấy kraft tiêu chuẩn'),('vi',3,'Gói ruy băng lụa cao cấp'),('vi',4,'Tối đa 20 ký tự'),('vi',5,'Bảo hành tiêu chuẩn 1 năm'),('vi',6,'Bảo hành mở rộng 2 năm'),('vi',7,'Chăm sóc cao cấp 3 năm');

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

CREATE TABLE `ec_global_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of options',
  `option_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'option type',
  `required` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Checked if this option is required',
  `price_per_product` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_global_options` VALUES (1,'Gift Wrapping','Botble\\Ecommerce\\Option\\OptionType\\Dropdown',0,0,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(2,'Engraving','Botble\\Ecommerce\\Option\\OptionType\\Field',0,0,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(3,'Extended Warranty','Botble\\Ecommerce\\Option\\OptionType\\RadioButton',0,0,'2026-05-28 19:07:06','2026-05-28 19:07:06');

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

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

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

INSERT INTO `ec_global_options_translations` VALUES ('ar',1,'تغليف الهدايا'),('ar',2,'نقش'),('ar',3,'الضمان الممتد'),('fr',1,'Emballage cadeau'),('fr',2,'Gravure'),('fr',3,'Garantie prolongée'),('id',1,'Pembungkus Kado'),('id',2,'Ukiran'),('id',3,'Perpanjangan Garansi'),('tr',1,'Hediye Paketleme'),('tr',2,'Oymak'),('tr',3,'Uzatılmış Garanti'),('vi',1,'Gói quà'),('vi',2,'Khắc tên'),('vi',3,'Bảo hành mở rộng');

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

CREATE TABLE `ec_invoice_item_tax_components` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `invoice_item_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` decimal(8,4) NOT NULL DEFAULT '0.0000',
  `amount` decimal(15,2) NOT NULL DEFAULT '0.00',
  `jurisdiction` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `metadata` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_iitc_invoice_item` (`invoice_item_id`),
  CONSTRAINT `ec_invoice_item_tax_components_invoice_item_id_foreign` FOREIGN KEY (`invoice_item_id`) REFERENCES `ec_invoice_items` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_invoice_item_tax_components`
--


--
-- Table structure for table `ec_invoice_items`
--

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

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


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

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

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


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

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

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


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

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

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


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

CREATE TABLE `ec_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of options',
  `option_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'option type',
  `product_id` bigint unsigned NOT NULL DEFAULT '0',
  `order` int NOT NULL DEFAULT '9999',
  `required` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Checked if this option is required',
  `price_per_product` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_options`
--


--
-- Table structure for table `ec_options_translations`
--

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

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


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

CREATE TABLE `ec_order_addresses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_id` bigint unsigned NOT NULL,
  `zip_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'shipping_address',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_order_addresses_order_id_type_unique` (`order_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

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

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


--
-- Table structure for table `ec_order_metadata`
--

CREATE TABLE `ec_order_metadata` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_order_metadata_order_id_meta_key_index` (`order_id`,`meta_key`),
  KEY `ec_order_metadata_order_id_index` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_order_metadata`
--


--
-- 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) DEFAULT '0.00',
  `tax_breakdown` json DEFAULT NULL,
  `options` text COLLATE utf8mb4_unicode_ci,
  `product_options` text COLLATE utf8mb4_unicode_ci COMMENT 'product option data',
  `product_id` bigint unsigned DEFAULT NULL,
  `product_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` double DEFAULT '0',
  `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` text COLLATE utf8mb4_unicode_ci,
  `downloaded_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_order_product_order_id_product_id_index` (`order_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `ec_order_product_tax_components`
--

CREATE TABLE `ec_order_product_tax_components` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_product_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` decimal(8,4) NOT NULL DEFAULT '0.0000',
  `amount` decimal(15,2) NOT NULL DEFAULT '0.00',
  `jurisdiction` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `metadata` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_opt_order_product` (`order_product_id`),
  KEY `idx_opt_order_product_code` (`order_product_id`,`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_order_product_tax_components`
--


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

CREATE TABLE `ec_order_return_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `order_return_id` bigint unsigned NOT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_order_return_histories`
--


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

CREATE TABLE `ec_order_return_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_return_id` bigint unsigned NOT NULL COMMENT 'Order return id',
  `order_product_id` bigint unsigned NOT NULL COMMENT 'Order product id',
  `product_id` bigint unsigned NOT NULL COMMENT 'Product id',
  `product_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` int NOT NULL COMMENT 'Quantity return',
  `price` decimal(15,2) NOT NULL COMMENT 'Price Product',
  `reason` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `refund_amount` decimal(12,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_order_return_items`
--


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

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

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


--
-- Table structure for table `ec_order_tax_information`
--

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

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


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

CREATE TABLE `ec_product_attribute_sets` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `display_layout` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '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`),
  KEY `idx_order_id` (`order`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_product_attribute_sets` VALUES (1,'Color','color','visual',1,1,1,'published',0,'2026-05-28 19:07:06','2026-05-28 19:07:06',1),(2,'Size','size','text',1,1,1,'published',1,'2026-05-28 19:07:06','2026-05-28 19:07:06',0),(3,'Material','material','text',1,1,1,'published',2,'2026-05-28 19:07:06','2026-05-28 19:07:06',0);

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

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

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

INSERT INTO `ec_product_attribute_sets_translations` VALUES ('ar',1,'لون'),('ar',2,'مقاس'),('ar',3,'مادة'),('fr',1,'Couleur'),('fr',2,'Taille'),('fr',3,'Matériel'),('id',1,'Warna'),('id',2,'Ukuran'),('id',3,'Bahan'),('tr',1,'Renk'),('tr',2,'Boyut'),('tr',3,'Malzeme'),('vi',1,'Màu sắc'),('vi',2,'Kích cỡ'),('vi',3,'Chất liệu');

--
-- 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(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `order` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attribute_set_status_index` (`attribute_set_id`),
  KEY `idx_attribute_set_id` (`attribute_set_id`),
  KEY `idx_attribute_set_order_id` (`attribute_set_id`,`order`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_product_attributes` VALUES (1,1,'Black','black','#000000',NULL,1,0,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(2,1,'White','white','#FFFFFF',NULL,0,1,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(3,1,'Beige','beige','#D6BFA0',NULL,0,2,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(4,1,'Olive','olive','#6B7843',NULL,0,3,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(5,1,'Navy','navy','#10243F',NULL,0,4,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(6,1,'Burgundy','burgundy','#7B1F2B',NULL,0,5,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(7,1,'Charcoal','charcoal','#374049',NULL,0,6,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(8,1,'Cream','cream','#F1E8D7',NULL,0,7,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(9,1,'Pink','pink','#F2C2BB',NULL,0,8,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(10,1,'Brown','brown','#905D5D',NULL,0,9,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(11,1,'Green','green','#B2BD9F',NULL,0,10,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(12,1,'Blue','blue','#87CEEB',NULL,0,11,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(13,2,'XS','xs',NULL,NULL,1,0,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(14,2,'S','s',NULL,NULL,0,1,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(15,2,'M','m',NULL,NULL,0,2,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(16,2,'L','l',NULL,NULL,0,3,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(17,2,'XL','xl',NULL,NULL,0,4,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(18,2,'XXL','xxl',NULL,NULL,0,5,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(19,3,'Cotton','cotton',NULL,NULL,1,0,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(20,3,'Linen','linen',NULL,NULL,0,1,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(21,3,'Wool','wool',NULL,NULL,0,2,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(22,3,'Tencel','tencel',NULL,NULL,0,3,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(23,3,'Recycled Polyester','recycled-polyester',NULL,NULL,0,4,'2026-05-28 19:07:06','2026-05-28 19:07:06'),(24,3,'Full-Grain Leather','full-grain-leather',NULL,NULL,0,5,'2026-05-28 19:07:06','2026-05-28 19:07:06');

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

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

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

INSERT INTO `ec_product_attributes_translations` VALUES ('ar',1,'أسود'),('ar',2,'أبيض'),('ar',3,'البيج'),('ar',4,'زيتون'),('ar',5,'البحرية'),('ar',6,'بورجوندي'),('ar',7,'فحم'),('ar',8,'كريم'),('ar',9,'Pink'),('ar',10,'Brown'),('ar',11,'Green'),('ar',12,'Blue'),('ar',13,'XS'),('ar',14,'S'),('ar',15,'M'),('ar',16,'L'),('ar',17,'XL'),('ar',18,'XXL'),('ar',19,'قطن'),('ar',20,'الكتان'),('ar',21,'صوف'),('ar',22,'ايوسل'),('ar',23,'البوليستر المعاد تدويره'),('ar',24,'جلد محبب بالكامل'),('fr',1,'Noir'),('fr',2,'Blanc'),('fr',3,'Beige'),('fr',4,'Olive'),('fr',5,'Marine'),('fr',6,'Bourgogne'),('fr',7,'Charbon de bois'),('fr',8,'Crème'),('fr',9,'Pink'),('fr',10,'Brown'),('fr',11,'Green'),('fr',12,'Blue'),('fr',13,'XS'),('fr',14,'S'),('fr',15,'M'),('fr',16,'L'),('fr',17,'XL'),('fr',18,'XXL'),('fr',19,'Coton'),('fr',20,'Lin'),('fr',21,'Laine'),('fr',22,'Tencel'),('fr',23,'Polyester recyclé'),('fr',24,'Cuir pleine fleur'),('id',1,'Hitam'),('id',2,'Putih'),('id',3,'Krem'),('id',4,'Zaitun'),('id',5,'Angkatan laut'),('id',6,'merah anggur'),('id',7,'Arang'),('id',8,'Krim'),('id',9,'Pink'),('id',10,'Brown'),('id',11,'Green'),('id',12,'Blue'),('id',13,'XS'),('id',14,'S'),('id',15,'M'),('id',16,'L'),('id',17,'XL'),('id',18,'XXL'),('id',19,'Kapas'),('id',20,'Linen'),('id',21,'Wol'),('id',22,'Tencel'),('id',23,'Poliester Daur Ulang'),('id',24,'Kulit Gandum Penuh'),('tr',1,'Siyah'),('tr',2,'Beyaz'),('tr',3,'Bej'),('tr',4,'Zeytin'),('tr',5,'Donanma'),('tr',6,'Bordo'),('tr',7,'Kömür'),('tr',8,'Krem'),('tr',9,'Pink'),('tr',10,'Brown'),('tr',11,'Green'),('tr',12,'Blue'),('tr',13,'XS'),('tr',14,'S'),('tr',15,'M'),('tr',16,'L'),('tr',17,'XL'),('tr',18,'XXL'),('tr',19,'Pamuk'),('tr',20,'Keten'),('tr',21,'Yün'),('tr',22,'Tencel'),('tr',23,'Geri Dönüştürülmüş Polyester'),('tr',24,'Tam Sırçalı Deri'),('vi',1,'Đen'),('vi',2,'Trắng'),('vi',3,'Be'),('vi',4,'Ô-liu'),('vi',5,'Xanh navy'),('vi',6,'Đỏ burgundy'),('vi',7,'Xám than'),('vi',8,'Kem'),('vi',9,'Pink'),('vi',10,'Brown'),('vi',11,'Green'),('vi',12,'Blue'),('vi',13,'XS'),('vi',14,'S'),('vi',15,'M'),('vi',16,'L'),('vi',17,'XL'),('vi',18,'XXL'),('vi',19,'Cotton'),('vi',20,'Linen'),('vi',21,'Len'),('vi',22,'Tencel'),('vi',23,'Polyester tái chế'),('vi',24,'Da nguyên tấm');

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

CREATE TABLE `ec_product_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` bigint unsigned NOT NULL DEFAULT '0',
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `order` int unsigned NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_featured` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_product_categories_parent_id_status_created_at_index` (`parent_id`,`status`,`created_at`),
  KEY `ec_product_categories_parent_id_status_index` (`parent_id`,`status`),
  KEY `idx_categories_status_order` (`status`,`order`),
  KEY `idx_categories_order` (`order`),
  KEY `ec_product_categories_slug_index` (`slug`),
  KEY `idx_ec_product_categories_status` (`status`),
  KEY `idx_ec_product_categories_parent_id` (`parent_id`),
  KEY `idx_ec_product_categories_status_parent_order` (`status`,`parent_id`,`order`),
  KEY `idx_ec_product_categories_is_featured` (`is_featured`),
  KEY `idx_ec_product_categories_name` (`name`),
  KEY `idx_ec_product_categories_slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_product_categories` VALUES (1,'Relaxation',NULL,0,'Aromatherapy, meditation aids, and stress-relief essentials for daily decompression.','published',0,'categories/cate-1.png',1,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(2,'Sleep & Recovery',NULL,1,NULL,'published',0,NULL,0,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(3,'Guided Meditation',NULL,2,NULL,'published',0,NULL,0,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(4,'Deep Breathing',NULL,2,NULL,'published',1,NULL,0,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(5,'Progressive Relaxation',NULL,2,NULL,'published',2,NULL,0,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(6,'Calming Sounds',NULL,2,NULL,'published',3,NULL,0,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(7,'Stress Management Tools',NULL,1,NULL,'published',1,NULL,0,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(8,'Daily Stress Log',NULL,7,NULL,'published',0,NULL,0,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(9,'Mood Tracker',NULL,7,NULL,'published',1,NULL,0,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(10,'Stress-Level Quiz',NULL,7,NULL,'published',2,NULL,0,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(11,'Emotional Support Tips',NULL,1,NULL,'published',2,NULL,0,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(12,'Coping Methods',NULL,11,NULL,'published',0,NULL,0,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(13,'Emotional Awareness',NULL,11,NULL,'published',1,NULL,0,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(14,'Reset Routines',NULL,11,NULL,'published',2,NULL,0,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(15,'Grounding Practices',NULL,11,NULL,'published',3,NULL,0,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(16,'Supplements',NULL,0,'Daily greens, adaptogens, and mood-support supplements crafted with clean ingredients.','published',1,'categories/cate-2.png',1,'2026-05-28 19:07:08','2026-05-28 19:07:08',NULL,NULL),(17,'Natural Remedies',NULL,16,NULL,'published',0,NULL,0,'2026-05-28 19:07:09','2026-05-28 19:07:09',NULL,NULL),(18,'Herbal Teas',NULL,17,NULL,'published',0,NULL,0,'2026-05-28 19:07:09','2026-05-28 19:07:09',NULL,NULL),(19,'Aromatherapy Oils',NULL,17,NULL,'published',1,NULL,0,'2026-05-28 19:07:09','2026-05-28 19:07:09',NULL,NULL),(20,'Calming Supplements',NULL,17,NULL,'published',2,NULL,0,'2026-05-28 19:07:09','2026-05-28 19:07:09',NULL,NULL),(21,'Sleep-Friendly Herbs',NULL,17,NULL,'published',3,NULL,0,'2026-05-28 19:07:09','2026-05-28 19:07:09',NULL,NULL),(22,'Lifestyle Adjustments',NULL,16,NULL,'published',1,NULL,0,'2026-05-28 19:07:09','2026-05-28 19:07:09',NULL,NULL),(23,'Sleep Hygiene',NULL,22,NULL,'published',0,NULL,0,'2026-05-28 19:07:09','2026-05-28 19:07:09',NULL,NULL),(24,'Workload Balancing',NULL,22,NULL,'published',1,NULL,0,'2026-05-28 19:07:09','2026-05-28 19:07:09',NULL,NULL),(25,'Break Scheduling',NULL,22,NULL,'published',2,NULL,0,'2026-05-28 19:07:09','2026-05-28 19:07:09',NULL,NULL),(26,'Digital Detox',NULL,22,NULL,'published',3,NULL,0,'2026-05-28 19:07:09','2026-05-28 19:07:09',NULL,NULL),(27,'Health Devices',NULL,0,'Smart trackers, light therapy lamps, and wellness gadgets that work with your routine.','published',2,'categories/cate-3.png',1,'2026-05-28 19:07:09','2026-05-28 19:07:09',NULL,NULL),(28,'Body Care',NULL,0,'Botanical body oils, balms, and skincare formulated to nourish and calm.','published',3,'categories/cate-4.png',1,'2026-05-28 19:07:09','2026-05-28 19:07:09',NULL,NULL),(29,'Mind Balance',NULL,0,'Journals, breathwork tools, and mindfulness practices for inner balance.','published',4,'categories/cate-5.png',1,'2026-05-28 19:07:10','2026-05-28 19:07:10',NULL,NULL);

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

CREATE TABLE `ec_product_categories_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_categories_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`ec_product_categories_id`),
  KEY `idx_product_categories_fk` (`ec_product_categories_id`),
  KEY `idx_product_categories_product_categories_lang` (`ec_product_categories_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_product_categories_translations` VALUES ('ar',1,'الاسترخاء',NULL,'العلاج بالروائح العطرية وأدوات التأمل ومواد تخفيف التوتر للاسترخاء اليومي.'),('ar',2,'النوم والتعافي',NULL,''),('ar',3,'التأمل الموجه',NULL,''),('ar',4,'التنفس العميق',NULL,''),('ar',5,'الاسترخاء التدريجي',NULL,''),('ar',6,'أصوات مهدئة',NULL,''),('ar',7,'أدوات إدارة الإجهاد',NULL,''),('ar',8,'سجل الإجهاد اليومي',NULL,''),('ar',9,'تعقب المزاج',NULL,''),('ar',10,'اختبار مستوى التوتر',NULL,''),('ar',11,'نصائح الدعم العاطفي',NULL,''),('ar',12,'طرق المواجهة',NULL,''),('ar',13,'الوعي العاطفي',NULL,''),('ar',14,'إعادة ضبط الإجراءات',NULL,''),('ar',15,'ممارسات التأريض',NULL,''),('ar',16,'المكملات الغذائية',NULL,'الخضر اليومية والمكيفات والمكملات الغذائية الداعمة للمزاج المصنوعة من مكونات نظيفة.'),('ar',17,'العلاجات الطبيعية',NULL,''),('ar',18,'شاي الأعشاب',NULL,''),('ar',19,'الزيوت العطرية',NULL,''),('ar',20,'المكملات الغذائية المهدئة',NULL,''),('ar',21,'الأعشاب الصديقة للنوم',NULL,''),('ar',22,'تعديلات نمط الحياة',NULL,''),('ar',23,'نظافة النوم',NULL,''),('ar',24,'موازنة عبء العمل',NULL,''),('ar',25,'جدولة الاستراحة',NULL,''),('ar',26,'التخلص من السموم الرقمية',NULL,''),('ar',27,'الأجهزة الصحية',NULL,'أجهزة التتبع الذكية ومصابيح العلاج بالضوء وأجهزة الصحة التي تمتزج مع روتينك.'),('ar',28,'العناية بالجسم',NULL,'كريمات الجسم والمقشرات وطقوس الاستحمام للحصول على بشرة ناعمة ومشرقة من الرأس إلى أخمص القدمين.'),('ar',29,'توازن العقل',NULL,'المجلات وتمارين التنفس وممارسات اليقظة لتحقيق التوازن الداخلي.'),('fr',1,'Relaxation',NULL,'Aromathérapie, outils de méditation et articles anti-stress pour la relaxation quotidienne.'),('fr',2,'Sommeil et récupération',NULL,''),('fr',3,'Méditation guidée',NULL,''),('fr',4,'Respiration profonde',NULL,''),('fr',5,'Détente progressive',NULL,''),('fr',6,'Des sons apaisants',NULL,''),('fr',7,'Outils de gestion du stress',NULL,''),('fr',8,'Journal de stress quotidien',NULL,''),('fr',9,'Suivi de l\'humeur',NULL,''),('fr',10,'Quiz sur le niveau de stress',NULL,''),('fr',11,'Conseils de soutien émotionnel',NULL,''),('fr',12,'Méthodes d\'adaptation',NULL,''),('fr',13,'Conscience émotionnelle',NULL,''),('fr',14,'Réinitialiser les routines',NULL,''),('fr',15,'Pratiques de mise à la terre',NULL,''),('fr',16,'Suppléments',NULL,'Légumes verts quotidiens, adaptogènes et suppléments favorisant l’humeur fabriqués à partir d’ingrédients propres.'),('fr',17,'Remèdes naturels',NULL,''),('fr',18,'Tisanes',NULL,''),('fr',19,'Huiles d\'aromathérapie',NULL,''),('fr',20,'Suppléments apaisants',NULL,''),('fr',21,'Herbes propices au sommeil',NULL,''),('fr',22,'Ajustements du style de vie',NULL,''),('fr',23,'Hygiène du sommeil',NULL,''),('fr',24,'Équilibrage de la charge de travail',NULL,''),('fr',25,'Planification des pauses',NULL,''),('fr',26,'Détox numérique',NULL,''),('fr',27,'Appareils de santé',NULL,'Trackers intelligents, lampes de luminothérapie et appareils de bien-être qui se fondent dans votre routine.'),('fr',28,'Soins du corps',NULL,'Laits corporels, gommages et rituels de bain pour une peau douce et éclatante de la tête aux pieds.'),('fr',29,'Équilibre mental',NULL,'Journaux, exercices de respiration et pratiques de pleine conscience pour l’équilibre intérieur.'),('id',1,'Relaksasi',NULL,'Aromaterapi, alat meditasi, dan obat pereda stres untuk relaksasi sehari-hari.'),('id',2,'Tidur & Pemulihan',NULL,''),('id',3,'Meditasi Terpandu',NULL,''),('id',4,'Pernapasan Dalam',NULL,''),('id',5,'Relaksasi Progresif',NULL,''),('id',6,'Suara yang Menenangkan',NULL,''),('id',7,'Alat Manajemen Stres',NULL,''),('id',8,'Catatan Stres Harian',NULL,''),('id',9,'Pelacak Suasana Hati',NULL,''),('id',10,'Kuis Tingkat Stres',NULL,''),('id',11,'Tip Dukungan Emosional',NULL,''),('id',12,'Metode Mengatasi',NULL,''),('id',13,'Kesadaran Emosional',NULL,''),('id',14,'Atur Ulang Rutinitas',NULL,''),('id',15,'Praktek Pembumian',NULL,''),('id',16,'Suplemen',NULL,'Sayuran hijau harian, adaptogen, dan suplemen pendukung suasana hati dibuat dari bahan-bahan bersih.'),('id',17,'Pengobatan Alami',NULL,''),('id',18,'Teh Herbal',NULL,''),('id',19,'Minyak Aromaterapi',NULL,''),('id',20,'Suplemen yang Menenangkan',NULL,''),('id',21,'Herbal Ramah Tidur',NULL,''),('id',22,'Penyesuaian Gaya Hidup',NULL,''),('id',23,'Kebersihan Tidur',NULL,''),('id',24,'Penyeimbangan Beban Kerja',NULL,''),('id',25,'Penjadwalan Istirahat',NULL,''),('id',26,'Detoks Digital',NULL,''),('id',27,'Perangkat Kesehatan',NULL,'Pelacak pintar, lampu terapi cahaya, dan perangkat kesehatan yang menyatu dengan rutinitas Anda.'),('id',28,'Perawatan Tubuh',NULL,'Body lotion, scrub dan ritual mandi untuk kulit lembut bercahaya dari ujung kepala hingga ujung kaki.'),('id',29,'Keseimbangan Pikiran',NULL,'Jurnal, latihan pernapasan dan latihan mindfulness untuk keseimbangan batin.'),('tr',1,'Gevşeme',NULL,'Aromaterapi, meditasyon araçları ve günlük rahatlama için stres giderici öğeler.'),('tr',2,'Uyku ve Dinlenme',NULL,''),('tr',3,'Rehberli Meditasyon',NULL,''),('tr',4,'Derin Nefes Alma',NULL,''),('tr',5,'Aşamalı Gevşeme',NULL,''),('tr',6,'Sakinleştirici Sesler',NULL,''),('tr',7,'Stres Yönetimi Araçları',NULL,''),('tr',8,'Günlük Stres Günlüğü',NULL,''),('tr',9,'Ruh Hali Takibi',NULL,''),('tr',10,'Stres Seviyesi Testi',NULL,''),('tr',11,'Duygusal Destek İpuçları',NULL,''),('tr',12,'Başa Çıkma Yöntemleri',NULL,''),('tr',13,'Duygusal Farkındalık',NULL,''),('tr',14,'Rutinleri Sıfırla',NULL,''),('tr',15,'Topraklama Uygulamaları',NULL,''),('tr',16,'Takviyeler',NULL,'Temiz malzemelerden hazırlanmış günlük yeşillikler, adaptojenler ve ruh halini destekleyen takviyeler.'),('tr',17,'Doğal Çözümler',NULL,''),('tr',18,'Bitki Çayları',NULL,''),('tr',19,'Aromaterapi Yağları',NULL,''),('tr',20,'Sakinleştirici Takviyeler',NULL,''),('tr',21,'Uyku Dostu Bitkiler',NULL,''),('tr',22,'Yaşam Tarzı Düzenlemeleri',NULL,''),('tr',23,'Uyku Hijyeni',NULL,''),('tr',24,'İş Yükü Dengeleme',NULL,''),('tr',25,'Mola Planlaması',NULL,''),('tr',26,'Dijital Detoks',NULL,''),('tr',27,'Sağlık Cihazları',NULL,'Rutininize uyum sağlayan akıllı takip cihazları, ışık terapisi lambaları ve sağlıklı yaşam cihazları.'),('tr',28,'Vücut Bakımı',NULL,'Tepeden tırnağa yumuşak, ışıltılı bir cilt için vücut losyonları, peelingler ve banyo ritüelleri.'),('tr',29,'Zihin Dengesi',NULL,'İç denge için günlükler, nefes egzersizleri ve farkındalık uygulamaları.'),('vi',1,'Thư giãn',NULL,'Liệu pháp hương thơm, dụng cụ thiền và các vật dụng giảm căng thẳng cho việc thả lỏng mỗi ngày.'),('vi',2,'Giấc ngủ & phục hồi',NULL,''),('vi',3,'Thiền có hướng dẫn',NULL,''),('vi',4,'Thở sâu',NULL,''),('vi',5,'Thư giãn tịnh tiến',NULL,''),('vi',6,'Âm thanh xoa dịu',NULL,''),('vi',7,'Công cụ quản lý căng thẳng',NULL,''),('vi',8,'Nhật ký căng thẳng hằng ngày',NULL,''),('vi',9,'Bảng theo dõi tâm trạng',NULL,''),('vi',10,'Bài kiểm tra mức độ căng thẳng',NULL,''),('vi',11,'Mẹo hỗ trợ cảm xúc',NULL,''),('vi',12,'Phương pháp ứng phó',NULL,''),('vi',13,'Nhận thức cảm xúc',NULL,''),('vi',14,'Thói quen tái thiết lập',NULL,''),('vi',15,'Thực hành định tâm',NULL,''),('vi',16,'Thực phẩm bổ sung',NULL,'Rau xanh hằng ngày, adaptogen và thực phẩm bổ sung hỗ trợ tâm trạng được chế tác từ nguyên liệu sạch.'),('vi',17,'Phương thuốc tự nhiên',NULL,''),('vi',18,'Trà thảo mộc',NULL,''),('vi',19,'Tinh dầu trị liệu',NULL,''),('vi',20,'Thực phẩm bổ sung xoa dịu',NULL,''),('vi',21,'Thảo mộc thân thiện với giấc ngủ',NULL,''),('vi',22,'Điều chỉnh lối sống',NULL,''),('vi',23,'Vệ sinh giấc ngủ',NULL,''),('vi',24,'Cân bằng khối lượng công việc',NULL,''),('vi',25,'Lên lịch nghỉ giải lao',NULL,''),('vi',26,'Thải độc kỹ thuật số',NULL,''),('vi',27,'Thiết bị sức khỏe',NULL,'Thiết bị theo dõi thông minh, đèn trị liệu ánh sáng và các thiết bị chăm sóc sức khỏe hòa hợp với thói quen của bạn.'),('vi',28,'Chăm Sóc Cơ Thể',NULL,'Sữa dưỡng thể, tẩy tế bào chết và những nghi thức tắm cho làn da mềm mại, rạng rỡ từ đầu đến chân.'),('vi',29,'Cân bằng tâm trí',NULL,'Nhật ký, dụng cụ tập thở và các thực hành chánh niệm cho sự cân bằng nội tâm.');

--
-- 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`),
  KEY `idx_product_category_composite` (`product_id`,`category_id`),
  KEY `idx_product_category` (`product_id`,`category_id`),
  KEY `idx_product_id_category_id` (`product_id`,`category_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),(16,1),(16,2),(16,3),(27,4),(27,8),(28,6),(29,5),(29,7);

--
-- 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`),
  KEY `idx_product_id_collection_id` (`product_id`,`product_collection_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,8),(2,5),(3,7),(3,9),(4,2),(5,3),(6,4),(7,6),(8,1);

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

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

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

INSERT INTO `ec_product_collections` VALUES (1,'Daily Wellness','daily-wellness','Everyday essentials for body and mind — supplements, calming teas, and mindful tools.','collection/cls-1.jpg','published','2026-05-28 19:07:10','2026-05-28 19:07:10',1),(2,'Limited Edition','limited-edition','Curated wellness drops from trusted makers — once they sell through, they are gone.','collection/cls-10.jpg','published','2026-05-28 19:07:10','2026-05-28 19:07:10',1),(3,'Best Sellers','best-sellers','The wellness picks our customers reorder week after week.','collection/cls-11.jpg','published','2026-05-28 19:07:10','2026-05-28 19:07:10',1),(4,'Clean &amp; Mindful','clean-mindful','Products with verified clean sourcing — third-party tested, low-impact, transparent supply chain.','collection/cls-12.jpg','published','2026-05-28 19:07:10','2026-05-28 19:07:10',1),(5,'Routine Builders','routine-builders','Stack-ready essentials for morning rituals and evening wind-down.','collection/cls-1.jpg','published','2026-05-28 19:07:10','2026-05-28 19:07:10',0),(6,'Travel &amp; On-the-Go','travel-on-the-go','Portable wellness for jet lag, long flights, and busy weeks.','collection/cls-10.jpg','published','2026-05-28 19:07:10','2026-05-28 19:07:10',0),(7,'Rest Better, Live <br> Brighter','rest-better-live-br-brighter','Discover calming products for <br> deeper, peaceful sleep.','section/banner-1.jpg','published','2026-05-28 19:07:10','2026-05-28 19:07:10',0),(8,'Nourish From <br> Within','nourish-from-br-within','Daily essentials to support <br> energy and balance.','section/banner-2.jpg','published','2026-05-28 19:07:10','2026-05-28 19:07:10',0),(9,'Find Your Calm <br> Space','find-your-calm-br-space','Mindful pieces that bring ease <br> to every day.','section/banner-3.jpg','published','2026-05-28 19:07:10','2026-05-28 19:07:10',0);

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

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

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

INSERT INTO `ec_product_collections_translations` VALUES ('ar',1,'العافية اليومية','الأساسيات اليومية للجسم والعقل - المكملات الغذائية، وأنواع الشاي المريحة، وأدوات اليقظة الذهنية.'),('ar',2,'طبعة محدودة','الشحنات الوحيدة من الشركات المصنعة المستقلة. إذا تم بيعه، فقد ذهب.'),('ar',3,'أفضل البائعين','المنتجات التي يثق بها العملاء ويعيدون طلبها في كل موسم.'),('ar',4,'Clean &amp; Mindful','Products with verified clean sourcing — third-party tested, low-impact, transparent supply chain.'),('ar',5,'بناة الروتينية','عناصر أساسية جاهزة للجمع بين طقوس الصباح والاسترخاء في المساء.'),('ar',6,'Travel &amp; On-the-Go','Portable wellness for jet lag, long flights, and busy weeks.'),('ar',7,'احصل على راحة أفضل، وعيش <br> أكثر إشراقًا','اكتشف المنتجات المهدئة لنوم عميق وهادئ <br>.'),('ar',8,'تغذي من <br> في الداخل','الأساسيات اليومية لدعم <br> الطاقة والتوازن.'),('ar',9,'ابحث عن مساحة <br> الهادئة الخاصة بك','عناصر اليقظة الذهنية تجلب الاسترخاء <br> إلى كل يوم.'),('fr',1,'Bien-être au quotidien','Des essentiels du quotidien pour le corps et l\'esprit : suppléments, thés relaxants et outils de pleine conscience.'),('fr',2,'Édition limitée','Expéditions exclusives de fabricants indépendants. S\'il est épuisé, il est parti.'),('fr',3,'Meilleures ventes','Des produits auxquels les clients font confiance et qui les commandent chaque saison.'),('fr',4,'Clean &amp; Mindful','Products with verified clean sourcing — third-party tested, low-impact, transparent supply chain.'),('fr',5,'Générateurs de routines','Des articles essentiels prêts à être combinés pour les rituels du matin et la détente du soir.'),('fr',6,'Travel &amp; On-the-Go','Portable wellness for jet lag, long flights, and busy weeks.'),('fr',7,'Reposez-vous mieux, vivez <br> plus lumineux','Découvrez des produits apaisants pour un sommeil <br> profond et paisible.'),('fr',8,'Nourrir à partir de <br> à l’intérieur','Des essentiels du quotidien pour soutenir l\'énergie et l\'équilibre de <br>.'),('fr',9,'Trouvez votre espace calme <br>','Les objets de pleine conscience apportent la relaxation <br> au quotidien.'),('id',1,'Kesehatan Harian','Kebutuhan sehari-hari untuk tubuh dan pikiran — suplemen, teh relaksasi, dan alat mindfulness.'),('id',2,'Edisi Terbatas','Pengiriman tunggal dari produsen independen. Kalau sudah terjual habis.'),('id',3,'Terlaris','Produk yang dipercaya dan dipesan ulang oleh pelanggan setiap musim.'),('id',4,'Clean &amp; Mindful','Products with verified clean sourcing — third-party tested, low-impact, transparent supply chain.'),('id',5,'Pembangun Rutin','Barang-barang penting siap dipadukan untuk ritual pagi dan relaksasi malam.'),('id',6,'Travel &amp; On-the-Go','Portable wellness for jet lag, long flights, and busy weeks.'),('id',7,'Istirahat Lebih Baik, Hidup <br> Lebih Cerah','Temukan produk yang menenangkan untuk <br> tidur nyenyak dan damai.'),('id',8,'Memelihara Dari <br> Dalam','Kebutuhan sehari-hari untuk mendukung energi dan keseimbangan <br>.'),('id',9,'Temukan Ruang <br> Tenang Anda','Item mindfulness menghadirkan relaksasi <br> setiap hari.'),('tr',1,'Günlük Sağlık','Beden ve zihin için günlük temel ihtiyaçlar: Takviyeler, rahatlatıcı çaylar ve farkındalık araçları.'),('tr',2,'Sınırlı sayıda','Bağımsız üreticilerden tek gönderi. Eğer tükendiyse, gitmiştir.'),('tr',3,'En Çok Satanlar','Müşterilerin güvendiği ve her sezon yeniden sipariş ettiği ürünler.'),('tr',4,'Clean &amp; Mindful','Products with verified clean sourcing — third-party tested, low-impact, transparent supply chain.'),('tr',5,'Rutin Oluşturucular','Sabah ritüelleri ve akşam rahatlaması için kombinlenmeye hazır temel öğeler.'),('tr',6,'Travel &amp; On-the-Go','Portable wellness for jet lag, long flights, and busy weeks.'),('tr',7,'Daha İyi Dinlenin, <br> Daha Parlak Yaşayın','<br> derin ve huzurlu bir uyku için rahatlatıcı ürünleri keşfedin.'),('tr',8,'<br> İçinizden Besleyin','<br> enerji ve dengeyi desteklemek için günlük temel ihtiyaçlar.'),('tr',9,'Sakin <br> Alanınızı Bulun','Farkındalık öğeleri her güne rahatlama <br> getirir.'),('vi',1,'Sức khỏe hằng ngày','Những vật dụng thiết yếu mỗi ngày cho cơ thể và tâm trí — thực phẩm bổ sung, trà thư giãn và dụng cụ chánh niệm.'),('vi',2,'Phiên bản giới hạn','Những lô hàng duy nhất từ các nhà sản xuất độc lập. Bán hết là không còn nữa.'),('vi',3,'Bán chạy nhất','Những sản phẩm được khách hàng tin dùng và đặt lại qua từng mùa.'),('vi',4,'Clean &amp; Mindful','Products with verified clean sourcing — third-party tested, low-impact, transparent supply chain.'),('vi',5,'Xây dựng thói quen','Những vật dụng thiết yếu sẵn sàng kết hợp cho nghi thức buổi sáng và thư giãn buổi tối.'),('vi',6,'Travel &amp; On-the-Go','Portable wellness for jet lag, long flights, and busy weeks.'),('vi',7,'Nghỉ ngơi tốt hơn, Sống <br> rạng rỡ hơn','Khám phá những sản phẩm xoa dịu cho <br> giấc ngủ sâu và yên bình.'),('vi',8,'Nuôi dưỡng từ <br> bên trong','Những vật dụng thiết yếu hằng ngày để hỗ trợ <br> năng lượng và cân bằng.'),('vi',9,'Tìm không gian <br> bình yên của bạn','Những món đồ chánh niệm mang lại sự thư thái <br> cho mỗi ngày.');

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

CREATE TABLE `ec_product_cross_sale_relations` (
  `from_product_id` bigint unsigned NOT NULL,
  `to_product_id` bigint unsigned NOT NULL,
  `is_variant` tinyint(1) NOT NULL DEFAULT '0',
  `price` decimal(15,2) DEFAULT '0.00',
  `price_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fixed',
  `apply_to_all_variations` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`from_product_id`,`to_product_id`),
  KEY `ec_product_cross_sale_relations_from_product_id_index` (`from_product_id`),
  KEY `ec_product_cross_sale_relations_to_product_id_index` (`to_product_id`),
  KEY `idx_product_cross_sale` (`from_product_id`,`to_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_product_cross_sale_relations` VALUES (1,2,0,0.00,'fixed',1),(1,3,0,0.00,'fixed',1),(1,5,0,0.00,'fixed',1),(1,6,0,0.00,'fixed',1),(1,7,0,0.00,'fixed',1),(1,8,0,0.00,'fixed',1),(2,1,0,0.00,'fixed',1),(2,5,0,0.00,'fixed',1),(2,6,0,0.00,'fixed',1),(2,8,0,0.00,'fixed',1),(2,9,0,0.00,'fixed',1),(3,1,0,0.00,'fixed',1),(3,2,0,0.00,'fixed',1),(3,5,0,0.00,'fixed',1),(3,6,0,0.00,'fixed',1),(3,9,0,0.00,'fixed',1),(4,1,0,0.00,'fixed',1),(4,2,0,0.00,'fixed',1),(4,3,0,0.00,'fixed',1),(4,5,0,0.00,'fixed',1),(4,7,0,0.00,'fixed',1),(5,1,0,0.00,'fixed',1),(5,2,0,0.00,'fixed',1),(5,8,0,0.00,'fixed',1),(5,9,0,0.00,'fixed',1),(6,1,0,0.00,'fixed',1),(6,2,0,0.00,'fixed',1),(6,3,0,0.00,'fixed',1),(6,4,0,0.00,'fixed',1),(6,7,0,0.00,'fixed',1),(6,8,0,0.00,'fixed',1),(7,3,0,0.00,'fixed',1),(7,4,0,0.00,'fixed',1),(7,5,0,0.00,'fixed',1),(7,6,0,0.00,'fixed',1),(7,9,0,0.00,'fixed',1),(8,1,0,0.00,'fixed',1),(8,3,0,0.00,'fixed',1),(8,4,0,0.00,'fixed',1),(8,9,0,0.00,'fixed',1),(9,1,0,0.00,'fixed',1),(9,2,0,0.00,'fixed',1),(9,6,0,0.00,'fixed',1),(9,7,0,0.00,'fixed',1),(9,8,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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

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

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

INSERT INTO `ec_product_label_products` VALUES (1,9),(2,6),(3,3);

--
-- 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,
  `text_color` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_product_labels_status_index` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_product_labels` VALUES (1,'Hot','#F0460E','published','2026-05-28 19:07:06','2026-05-28 19:07:06','#FFFFFF'),(2,'New','#22C55E','published','2026-05-28 19:07:06','2026-05-28 19:07:06','#FFFFFF'),(3,'Sale','#EF4444','published','2026-05-28 19:07:06','2026-05-28 19:07:06','#FFFFFF'),(4,'Best Seller','#1E1E1E','published','2026-05-28 19:07:06','2026-05-28 19:07:06','#FFFFFF'),(5,'Limited','#7B1F2B','published','2026-05-28 19:07:06','2026-05-28 19:07:06','#FFFFFF'),(6,'Eco','#6B7843','published','2026-05-28 19:07:06','2026-05-28 19:07:06','#FFFFFF');

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

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

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

INSERT INTO `ec_product_labels_translations` VALUES ('ar',1,'حار',NULL),('ar',2,'جديد',NULL),('ar',3,'أُوكَازيُون',NULL),('ar',4,'الأكثر مبيعًا',NULL),('ar',5,'محدود',NULL),('ar',6,'سابقة بمعنى البِيْئَة',NULL),('fr',1,'Chaud',NULL),('fr',2,'Nouveau',NULL),('fr',3,'Vente',NULL),('fr',4,'Meilleur vendeur',NULL),('fr',5,'Limité',NULL),('fr',6,'Écologique',NULL),('id',1,'Panas',NULL),('id',2,'Baru',NULL),('id',3,'Penjualan',NULL),('id',4,'Penjual Terbaik',NULL),('id',5,'Terbatas',NULL),('id',6,'ramah lingkungan',NULL),('tr',1,'Sıcak',NULL),('tr',2,'Yeni',NULL),('tr',3,'Satış',NULL),('tr',4,'En çok satan kitap',NULL),('tr',5,'Sınırlı',NULL),('tr',6,'Eko',NULL),('vi',1,'Hot',NULL),('vi',2,'Mới',NULL),('vi',3,'Giảm giá',NULL),('vi',4,'Bán chạy nhất',NULL),('vi',5,'Giới hạn',NULL),('vi',6,'Eco',NULL);

--
-- Table structure for table `ec_product_license_codes`
--

CREATE TABLE `ec_product_license_codes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned NOT NULL,
  `license_code` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'available',
  `assigned_order_product_id` bigint unsigned DEFAULT NULL,
  `assigned_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_product_license_codes_product_id_status_index` (`product_id`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_license_codes`
--


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

CREATE TABLE `ec_product_specification_attribute` (
  `product_id` bigint unsigned NOT NULL,
  `attribute_id` bigint unsigned NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `hidden` tinyint(1) NOT NULL DEFAULT '0',
  `order` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`product_id`,`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_specification_attribute`
--


--
-- Table structure for table `ec_product_specification_attribute_translations`
--

CREATE TABLE `ec_product_specification_attribute_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned NOT NULL,
  `attribute_id` bigint unsigned NOT NULL,
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `psat_unique` (`product_id`,`attribute_id`,`lang_code`),
  KEY `psat_product_attribute_index` (`product_id`,`attribute_id`),
  KEY `psat_product_id_index` (`product_id`),
  KEY `psat_attribute_id_index` (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_specification_attribute_translations`
--


--
-- 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,4),(1,5),(1,15),(2,1),(2,2),(2,6),(3,6),(3,9),(3,13),(4,3),(4,8),(4,12),(5,8),(5,10),(5,12),(6,2),(6,8),(6,10),(7,6),(7,8),(7,10),(8,1),(8,4),(8,13),(9,3),(9,7),(9,8);

--
-- 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,
  `content` mediumtext COLLATE utf8mb4_unicode_ci,
  `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=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_product_tags` VALUES (1,'Cotton','Products tagged with Cotton.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06'),(2,'Linen','Products tagged with Linen.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06'),(3,'Wool','Products tagged with Wool.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06'),(4,'Leather','Products tagged with Leather.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06'),(5,'Tencel','Products tagged with Tencel.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06'),(6,'Recycled','Products tagged with Recycled.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06'),(7,'Made in Portugal','Products tagged with Made in Portugal.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06'),(8,'Made in Italy','Products tagged with Made in Italy.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06'),(9,'Hand-Crafted','Products tagged with Hand-Crafted.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06'),(10,'Vegan','Products tagged with Vegan.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06'),(11,'Limited Run','Products tagged with Limited Run.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06'),(12,'Best Seller','Products tagged with Best Seller.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06'),(13,'New Arrival','Products tagged with New Arrival.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06'),(14,'Editor Pick','Products tagged with Editor Pick.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06'),(15,'Eco-Friendly','Products tagged with Eco-Friendly.',NULL,'published','2026-05-28 19:07:06','2026-05-28 19:07:06');

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

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

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

INSERT INTO `ec_product_tags_translations` VALUES ('ar',1,'قطن',NULL),('ar',2,'الكتان',NULL),('ar',3,'صوف',NULL),('ar',4,'جلد',NULL),('ar',5,'ايوسل',NULL),('ar',6,'المعاد تدويرها',NULL),('ar',7,'صنع في البرتغال',NULL),('ar',8,'صنع في إيطاليا',NULL),('ar',9,'مصنوع يدويًا',NULL),('ar',10,'نباتي',NULL),('ar',11,'تشغيل محدود',NULL),('ar',12,'الأكثر مبيعًا',NULL),('ar',13,'وصول جديد',NULL),('ar',14,'اختيار المحرر',NULL),('ar',15,'صديقة للبيئة',NULL),('fr',1,'Coton',NULL),('fr',2,'Lin',NULL),('fr',3,'Laine',NULL),('fr',4,'Cuir',NULL),('fr',5,'Tencel',NULL),('fr',6,'Recyclé',NULL),('fr',7,'Fabriqué au Portugal',NULL),('fr',8,'Fabriqué en Italie',NULL),('fr',9,'Fabriqué à la main',NULL),('fr',10,'Végétalien',NULL),('fr',11,'Série limitée',NULL),('fr',12,'Meilleur vendeur',NULL),('fr',13,'Nouvelle Arrivée',NULL),('fr',14,'Choix de l\'éditeur',NULL),('fr',15,'Respectueux de l\'environnement',NULL),('id',1,'Kapas',NULL),('id',2,'Linen',NULL),('id',3,'Wol',NULL),('id',4,'Kulit',NULL),('id',5,'Tencel',NULL),('id',6,'Daur ulang',NULL),('id',7,'Dibuat di Portugal',NULL),('id',8,'Dibuat di Italia',NULL),('id',9,'Kerajinan Tangan',NULL),('id',10,'vegan',NULL),('id',11,'Jangka Terbatas',NULL),('id',12,'Penjual Terbaik',NULL),('id',13,'Kedatangan Baru',NULL),('id',14,'Pilihan Editor',NULL),('id',15,'Ramah Lingkungan',NULL),('tr',1,'Pamuk',NULL),('tr',2,'Keten',NULL),('tr',3,'Yün',NULL),('tr',4,'Deri',NULL),('tr',5,'Tencel',NULL),('tr',6,'Geri dönüştürülmüş',NULL),('tr',7,'Portekiz\'de yapıldı',NULL),('tr',8,'İtalya\'da yapıldı',NULL),('tr',9,'El Yapımı',NULL),('tr',10,'vegan',NULL),('tr',11,'Sınırlı Çalıştırma',NULL),('tr',12,'En çok satan kitap',NULL),('tr',13,'Yeni gelen',NULL),('tr',14,'Editörün Seçimi',NULL),('tr',15,'Çevre Dostu',NULL),('vi',1,'Cotton',NULL),('vi',2,'Linen',NULL),('vi',3,'Len',NULL),('vi',4,'Da',NULL),('vi',5,'Tencel',NULL),('vi',6,'Tái chế',NULL),('vi',7,'Sản xuất tại Bồ Đào Nha',NULL),('vi',8,'Sản xuất tại Ý',NULL),('vi',9,'Thủ công',NULL),('vi',10,'Thuần chay',NULL),('vi',11,'Lô giới hạn',NULL),('vi',12,'Bán chạy nhất',NULL),('vi',13,'Hàng mới về',NULL),('vi',14,'Biên tập viên chọn',NULL),('vi',15,'Thân thiện môi trường',NULL);

--
-- 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,
  `is_variant` tinyint(1) NOT NULL DEFAULT '0',
  `price` decimal(15,2) DEFAULT '0.00',
  `price_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fixed',
  `apply_to_all_variations` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`from_product_id`,`to_product_id`),
  KEY `ec_product_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`
--

INSERT INTO `ec_product_up_sale_relations` VALUES (1,3,0,20.00,'percent',1),(1,7,0,50.00,'fixed',1),(2,3,0,5.00,'percent',1),(2,4,0,10.00,'fixed',1),(3,8,0,5.00,'percent',1),(4,7,0,5.00,'fixed',1),(4,9,0,10.00,'fixed',1),(5,1,0,20.00,'percent',1),(5,6,0,10.00,'fixed',1),(6,7,0,20.00,'percent',1),(6,8,0,10.00,'fixed',1),(7,1,0,20.00,'percent',1),(7,6,0,10.00,'fixed',1),(8,1,0,20.00,'percent',1),(8,6,0,20.00,'percent',1),(9,3,0,5.00,'fixed',1),(9,7,0,15.00,'percent',1);

--
-- 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`),
  UNIQUE KEY `ec_product_variation_items_attribute_id_variation_id_unique` (`attribute_id`,`variation_id`),
  KEY `attribute_variation_index` (`attribute_id`,`variation_id`),
  KEY `idx_variation_id` (`variation_id`),
  KEY `idx_variation_attribute_covering` (`variation_id`,`attribute_id`),
  KEY `ec_product_variation_items_variation_id_attribute_id_index` (`variation_id`,`attribute_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 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),(1,2,1),(3,4,2),(9,4,5),(7,7,4),(6,13,3),(8,14,4),(4,15,2),(2,18,1),(10,18,5),(11,19,6),(16,22,11),(12,23,7),(13,24,8),(14,24,9),(15,24,10);

--
-- 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`),
  KEY `idx_configurable_product_id` (`configurable_product_id`),
  KEY `idx_product_variations_config` (`configurable_product_id`,`is_default`),
  KEY `ec_product_variations_product_id_index` (`product_id`),
  KEY `ec_product_variations_configurable_product_id_index` (`configurable_product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

CREATE TABLE `ec_product_views` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned NOT NULL,
  `views` int NOT NULL DEFAULT '1',
  `date` date NOT NULL DEFAULT '2026-05-29',
  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,2,0),(2,2,0),(1,3,0),(2,3,0),(3,5,0),(3,9,0);

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

CREATE TABLE `ec_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 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,
  `video_media` text COLLATE utf8mb4_unicode_ci,
  `sku` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int unsigned NOT NULL DEFAULT '0',
  `quantity` int unsigned DEFAULT NULL,
  `allow_checkout_when_out_of_stock` tinyint unsigned NOT NULL DEFAULT '0',
  `with_storehouse_management` tinyint unsigned NOT NULL DEFAULT '0',
  `stock_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'in_stock',
  `is_featured` tinyint unsigned NOT NULL DEFAULT '0',
  `is_new_until` date DEFAULT NULL,
  `brand_id` bigint unsigned DEFAULT NULL,
  `is_variation` tinyint NOT NULL DEFAULT '0',
  `variations_count` int unsigned NOT NULL DEFAULT '0',
  `reviews_count` int unsigned NOT NULL DEFAULT '0',
  `reviews_avg` decimal(3,2) NOT NULL DEFAULT '0.00',
  `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 DEFAULT NULL,
  `wide` double DEFAULT NULL,
  `height` double DEFAULT NULL,
  `weight` double DEFAULT NULL,
  `tax_id` bigint unsigned DEFAULT NULL,
  `tax_class` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'standard',
  `views` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `store_id` bigint unsigned DEFAULT NULL,
  `created_by_id` bigint unsigned DEFAULT '0',
  `created_by_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `approved_by` bigint unsigned DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_type` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT 'physical',
  `barcode` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cost_per_item` double DEFAULT NULL,
  `currency_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price_includes_tax` tinyint(1) NOT NULL DEFAULT '0',
  `generate_license_code` tinyint(1) NOT NULL DEFAULT '0',
  `license_code_type` enum('auto_generate','pick_from_list') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'auto_generate',
  `minimum_order_quantity` int unsigned DEFAULT '0',
  `maximum_order_quantity` int unsigned DEFAULT '0',
  `notify_attachment_updated` tinyint(1) NOT NULL DEFAULT '0',
  `specification_table_id` bigint unsigned DEFAULT NULL,
  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`),
  KEY `idx_products_export` (`id`,`is_variation`),
  KEY `idx_store_variation_status` (`store_id`,`is_variation`,`status`),
  KEY `idx_variation_name_id` (`is_variation`,`name`,`id`),
  KEY `ec_products_variations_count_index` (`variations_count`),
  KEY `ec_products_slug_index` (`slug`),
  KEY `idx_products_status_variation` (`status`,`is_variation`,`id`),
  KEY `idx_products_price_sale` (`sale_type`,`sale_price`,`price`),
  KEY `idx_products_order_created` (`order`,`created_at`),
  KEY `idx_products_stock` (`with_storehouse_management`,`stock_status`,`quantity`),
  KEY `ec_products_reviews_count_index` (`reviews_count`),
  KEY `ec_products_reviews_avg_index` (`reviews_avg`),
  KEY `ec_products_status_is_variation_index` (`status`,`is_variation`),
  KEY `ec_products_storehouse_quantity_index` (`with_storehouse_management`,`quantity`),
  KEY `ec_products_currency_code_index` (`currency_code`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_products` VALUES (1,'Daily Greens Powder','daily-greens-powder','Organic super-greens blend with spirulina, chlorella, and adaptogens for daily vitality.','<p>Plant-based, sugar-free, and packed with 24 nutrient-dense whole foods. Mix one scoop into water or your favorite smoothie each morning.</p>','published','[\"products\\/mental\\/product-1.jpg\"]',NULL,'EP-152',0,13,0,1,'in_stock',1,NULL,2,0,0,10,3.30,0,49.99,39.99,NULL,NULL,11,18,17,694,NULL,'standard',178792,'2026-05-28 19:07:12','2026-05-28 19:07:19',1,0,'Botble\\ACL\\Models\\User',0,'products/mental/product-1.jpg','physical','6058522011961',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(2,'Calm Mind Adaptogen Capsules','calm-mind-adaptogen-capsules','Ashwagandha + L-theanine blend formulated to ease stress and support clear focus.','<p>Vegan capsules combining 600mg KSM-66 ashwagandha with rhodiola and theanine. Take two capsules daily with food.</p>','published','[\"products\\/mental\\/product-2.jpg\"]',NULL,'W7-150-A1',0,13,0,1,'in_stock',1,NULL,2,0,4,10,3.40,0,39.99,29.99,NULL,NULL,11,19,16,897,NULL,'standard',122870,'2026-05-28 19:07:12','2026-05-28 19:07:19',2,0,'Botble\\ACL\\Models\\User',0,'products/mental/product-2.jpg','physical','0971288583922',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(3,'Sleep Restore Magnesium Drink','sleep-restore-magnesium-drink','Magnesium glycinate with chamomile and tart cherry — a calming nightly ritual.','<p>Mix into warm water 30 minutes before bed. 200mg highly absorbable magnesium per serving. Caffeine-free, non-habit forming.</p>','published','[\"products\\/mental\\/product-3.jpg\"]',NULL,'QW-153-A1',0,13,0,1,'in_stock',1,NULL,1,0,1,10,2.90,0,34.99,24.99,NULL,NULL,20,20,16,758,NULL,'standard',84282,'2026-05-28 19:07:12','2026-05-28 19:07:19',3,0,'Botble\\ACL\\Models\\User',0,'products/mental/product-3.jpg','physical','6739949841491',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(4,'Aromatherapy Diffuser','aromatherapy-diffuser','Ultrasonic ceramic diffuser with seven-color ambient lighting and four-hour run time.','<p>Whisper-quiet operation. Auto-shutoff. 200ml reservoir covers rooms up to 30sqm. Includes calming starter blend.</p>','published','[\"products\\/mental\\/product-4.jpg\"]',NULL,'PK-141',0,15,0,1,'in_stock',0,NULL,3,0,0,10,3.00,0,79.99,59.99,NULL,NULL,17,20,17,510,NULL,'standard',67922,'2026-05-28 19:07:12','2026-05-28 19:07:19',4,0,'Botble\\ACL\\Models\\User',0,'products/mental/product-4.jpg','physical','8210022857519',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(5,'Mood Support Mushroom Blend','mood-support-mushroom-blend','Functional mushroom complex — lions mane, reishi, and cordyceps — for cognitive support.','<p>Dual-extracted from organic fruiting bodies. 1500mg per serving. Mix into coffee, tea, or smoothies.</p>','published','[\"products\\/mental\\/product-5.jpg\"]',NULL,'KL-193-A1',0,19,0,1,'in_stock',1,NULL,1,0,4,10,3.20,0,44.99,34.99,NULL,NULL,13,14,17,722,NULL,'standard',150983,'2026-05-28 19:07:12','2026-05-28 19:07:19',1,0,'Botble\\ACL\\Models\\User',0,'products/mental/product-5.jpg','physical','2258007407492',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(6,'Botanical Body Oil','botanical-body-oil','Cold-pressed jojoba and squalane infused with lavender and bergamot — calms skin and senses.','<p>100ml frosted-glass bottle. Apply after showering for soft, hydrated skin and a calming aroma. Cruelty-free.</p>','published','[\"products\\/mental\\/product-6.jpg\"]',NULL,'JE-172',0,14,0,1,'in_stock',0,NULL,3,0,0,10,2.60,0,54.99,39.99,NULL,NULL,19,11,14,748,NULL,'standard',122027,'2026-05-28 19:07:12','2026-05-28 19:07:19',2,0,'Botble\\ACL\\Models\\User',0,'products/mental/product-6.jpg','physical','3343083136844',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(7,'Mindfulness Journal','mindfulness-journal','Guided 12-week journal with daily prompts for gratitude, reflection, and intention setting.','<p>FSC-certified paper. Linen hardcover. Includes habit tracker, breathing exercises, and weekly reviews.</p>','published','[\"products\\/mental\\/product-7.jpg\"]',NULL,'ZG-155',0,11,0,1,'in_stock',1,NULL,4,0,0,10,3.10,0,29.99,19.99,NULL,NULL,19,17,11,672,NULL,'standard',165506,'2026-05-28 19:07:12','2026-05-28 19:07:19',3,0,'Botble\\ACL\\Models\\User',0,'products/mental/product-7.jpg','physical','9575960535608',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(8,'Light Therapy Lamp','light-therapy-lamp','10,000 lux full-spectrum desk lamp with adjustable warmth and a built-in 30-minute timer.','<p>Helps regulate circadian rhythm during darker months. UV-filtered. Compact desk footprint and tilt adjustment.</p>','published','[\"products\\/mental\\/product-8.jpg\"]',NULL,'DV-155',0,12,0,1,'in_stock',1,NULL,2,0,0,10,3.10,0,89.99,69.99,NULL,NULL,13,13,18,631,NULL,'standard',80154,'2026-05-28 19:07:12','2026-05-28 19:07:19',4,0,'Botble\\ACL\\Models\\User',0,'products/mental/product-8.jpg','physical','3109149515400',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(9,'Herbal Recovery Tea','herbal-recovery-tea','Loose-leaf chamomile, valerian, and lemon balm — a nightly cup for unwinding before sleep.','<p>Organically grown and hand-blended. 50g resealable tin yields 25 servings. Naturally caffeine-free.</p>','published','[\"products\\/mental\\/product-9.jpg\"]',NULL,'PJ-108-A1',0,15,0,1,'in_stock',0,NULL,1,0,2,10,3.10,0,24.99,18.99,NULL,NULL,15,15,16,780,NULL,'standard',31647,'2026-05-28 19:07:12','2026-05-28 19:07:19',1,0,'Botble\\ACL\\Models\\User',0,'products/mental/product-9.jpg','physical','0359642137309',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(10,'Calm Mind Adaptogen Capsules',NULL,NULL,NULL,'published','[\"products\\/mental\\/product-2.jpg\"]',NULL,'W7-150-A1',0,13,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,39.99,NULL,NULL,NULL,11,19,16,897,NULL,'standard',0,'2026-05-28 19:07:13','2026-05-28 19:07:19',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6150207058619',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(11,'Calm Mind Adaptogen Capsules',NULL,NULL,NULL,'published','[\"products\\/mental\\/product-2.jpg\"]',NULL,'W7-150-A1-A2',0,13,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,39.99,NULL,NULL,NULL,11,19,16,897,NULL,'standard',0,'2026-05-28 19:07:13','2026-05-28 19:07:19',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','7334944519421',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(12,'Calm Mind Adaptogen Capsules',NULL,NULL,NULL,'published','[\"products\\/mental\\/product-2.jpg\"]',NULL,'W7-150-A1-A3',0,13,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,39.99,NULL,NULL,NULL,11,19,16,897,NULL,'standard',0,'2026-05-28 19:07:13','2026-05-28 19:07:19',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5229722117659',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(13,'Calm Mind Adaptogen Capsules',NULL,NULL,NULL,'published','[\"products\\/mental\\/product-2.jpg\"]',NULL,'W7-150-A1-A4',0,13,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,39.99,NULL,NULL,NULL,11,19,16,897,NULL,'standard',0,'2026-05-28 19:07:13','2026-05-28 19:07:19',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','1805414182705',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(14,'Sleep Restore Magnesium Drink',NULL,NULL,NULL,'published','[\"products\\/mental\\/product-3.jpg\"]',NULL,'QW-153-A1',0,13,0,1,'in_stock',0,NULL,1,1,0,0,0.00,0,34.99,NULL,NULL,NULL,20,20,16,758,NULL,'standard',0,'2026-05-28 19:07:13','2026-05-28 19:07:19',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5102576575168',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(15,'Mood Support Mushroom Blend',NULL,NULL,NULL,'published','[\"products\\/mental\\/product-5.jpg\"]',NULL,'KL-193-A1',0,19,0,1,'in_stock',0,NULL,1,1,0,0,0.00,0,44.99,NULL,NULL,NULL,13,14,17,722,NULL,'standard',0,'2026-05-28 19:07:13','2026-05-28 19:07:19',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','3405474710719',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(16,'Mood Support Mushroom Blend',NULL,NULL,NULL,'published','[\"products\\/mental\\/product-5.jpg\"]',NULL,'KL-193-A1-A2',0,19,0,1,'in_stock',0,NULL,1,1,0,0,0.00,0,44.99,NULL,NULL,NULL,13,14,17,722,NULL,'standard',0,'2026-05-28 19:07:13','2026-05-28 19:07:19',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','0859108861132',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(17,'Mood Support Mushroom Blend',NULL,NULL,NULL,'published','[\"products\\/mental\\/product-5.jpg\"]',NULL,'KL-193-A1-A3',0,19,0,1,'in_stock',0,NULL,1,1,0,0,0.00,0,44.99,NULL,NULL,NULL,13,14,17,722,NULL,'standard',0,'2026-05-28 19:07:13','2026-05-28 19:07:19',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6846629260869',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(18,'Mood Support Mushroom Blend',NULL,NULL,NULL,'published','[\"products\\/mental\\/product-5.jpg\"]',NULL,'KL-193-A1-A4',0,19,0,1,'in_stock',0,NULL,1,1,0,0,0.00,0,44.99,NULL,NULL,NULL,13,14,17,722,NULL,'standard',0,'2026-05-28 19:07:13','2026-05-28 19:07:19',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5910892171687',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(19,'Herbal Recovery Tea',NULL,NULL,NULL,'published','[\"products\\/mental\\/product-9.jpg\"]',NULL,'PJ-108-A1',0,15,0,1,'in_stock',0,NULL,1,1,0,0,0.00,0,24.99,NULL,NULL,NULL,15,15,16,780,NULL,'standard',0,'2026-05-28 19:07:13','2026-05-28 19:07:19',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5717465753796',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(20,'Herbal Recovery Tea',NULL,NULL,NULL,'published','[\"products\\/mental\\/product-9.jpg\"]',NULL,'PJ-108-A1-A2',0,15,0,1,'in_stock',0,NULL,1,1,0,0,0.00,0,24.99,NULL,NULL,NULL,15,15,16,780,NULL,'standard',0,'2026-05-28 19:07:13','2026-05-28 19:07:19',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6942068618701',NULL,NULL,0,0,'auto_generate',0,0,0,NULL);

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

CREATE TABLE `ec_products_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_products_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) 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`),
  KEY `idx_products_fk` (`ec_products_id`),
  KEY `idx_products_products_lang` (`ec_products_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_products_translations` VALUES ('ar',1,'مسحوق الخضر اليومي',NULL,'تمتزج الخضروات العضوية الفائقة مع السبيرولينا والكلوريلا والأدابتوجين للحيوية كل يوم.','<p> نباتي، خالي من السكر ويحتوي على 24 نوعًا من الأطعمة الكاملة الغنية بالمغذيات. قم بخلط ملعقة واحدة مع الماء أو العصير المفضل لديك كل صباح.</p>'),('ar',2,'كبسولات الهدوء العقل Adaptogen',NULL,'تم تركيب مزيج الأشواغاندا وال-ثيانين لتقليل التوتر ودعم التركيز الواضح.','<p> تجمع الكبسولات النباتية بين 600 ملغ من أشواغاندا KSM-66 مع الروديولا والثيانين. تناول قرصين يوميًا مع الوجبات.</p>'),('ar',3,'استعادة النوم مشروب المغنيسيوم',NULL,'جلايسينات المغنيسيوم مع البابونج والكرز اللاذع - طقوس ليلية مهدئة.','<p> امزجيه في ماء دافئ قبل النوم بـ 30 دقيقة. 200 ملغ من المغنيسيوم سهل الامتصاص لكل وجبة. لا كافيين، لا إدمان.</p>'),('ar',4,'الناشر الروائح',NULL,'ناشر سيراميك بالموجات فوق الصوتية مع إضاءة خلفية بسبعة ألوان ووقت تشغيل لمدة أربع ساعات.','<p> يعمل بهدوء مثل الهمس. الاغلاق التلقائي. حاوية سعة 200 مل تغطي مساحة تصل إلى 30 مترًا مربعًا من الغرفة. يأتي مع مزيج من الزيوت العطرية المريحة التي يمكنك تجربتها.</p>'),('ar',5,'مزيج الفطر لدعم المزاج',NULL,'مركب الفطر الوظيفي — عرف الأسد، والريشي، والكورديسيبس — يدعم الإدراك.','<p>مستخلص مزدوج من أجسام الفاكهة العضوية. 1500 ملغ لكل وجبة. امزجه مع القهوة أو الشاي أو العصائر.</p>'),('ar',6,'زيت الجسم النباتي',NULL,'زيوت الجوجوبا والسكوالان المضغوطة على البارد الممزوجة باللافندر والبرغموت - تهدئ البشرة والحواس.','<p>زجاجة زجاجية سعة 100 مل. ضعيه بعد الاستحمام للحصول على بشرة ناعمة ورطبة ورائحة مريحة. لم يتم اختباره على الحيوانات.</p>'),('ar',7,'مجلة اليقظه',NULL,'تتضمن المجلة دليلاً مدته 12 أسبوعًا يتضمن اقتراحات يومية للامتنان والتأمل وتحديد النية.','<p>شهادة شهادة FSC. غلاف مقوى مغطى بالكتان. يتضمن مخططًا لتتبع العادات وتمارين التنفس والمراجعة الأسبوعية.</p>'),('ar',8,'مصباح العلاج بالضوء',NULL,'مصباح مكتبي كامل الطيف 10,000 لوكس مع دفء قابل للتعديل ومؤقت مدمج لمدة 30 دقيقة.','<p> يساعد على تنظيم إيقاع الساعة البيولوجية خلال أشهر الإضاءة المنخفضة. الأشعة فوق البنفسجية المصفاة. حامل صغير الحجم وزاوية إمالة قابلة للتعديل.</p>'),('ar',9,'شاي الشفاء العشبي',NULL,'البابونج، حشيشة الهر، وبلسم الليمون في شكل أوراق فضفاضة - كوب من الشاي كل ليلة للاسترخاء قبل النوم.','<p> مزروع عضويًا ومختلط يدويًا. علبة 50 جرام قابلة للإغلاق تنتج 25 حصة. خالي من الكافيين بشكل طبيعي.</p>'),('ar',10,'كبسولات الهدوء العقل Adaptogen',NULL,'تم تركيب مزيج الأشواغاندا وال-ثيانين لتقليل التوتر ودعم التركيز الواضح.','<p> تجمع الكبسولات النباتية بين 600 ملغ من أشواغاندا KSM-66 مع الروديولا والثيانين. تناول قرصين يوميًا مع الوجبات.</p>'),('ar',11,'كبسولات الهدوء العقل Adaptogen',NULL,'تم تركيب مزيج الأشواغاندا وال-ثيانين لتقليل التوتر ودعم التركيز الواضح.','<p> تجمع الكبسولات النباتية بين 600 ملغ من أشواغاندا KSM-66 مع الروديولا والثيانين. تناول قرصين يوميًا مع الوجبات.</p>'),('ar',12,'كبسولات الهدوء العقل Adaptogen',NULL,'تم تركيب مزيج الأشواغاندا وال-ثيانين لتقليل التوتر ودعم التركيز الواضح.','<p> تجمع الكبسولات النباتية بين 600 ملغ من أشواغاندا KSM-66 مع الروديولا والثيانين. تناول قرصين يوميًا مع الوجبات.</p>'),('ar',13,'كبسولات الهدوء العقل Adaptogen',NULL,'تم تركيب مزيج الأشواغاندا وال-ثيانين لتقليل التوتر ودعم التركيز الواضح.','<p> تجمع الكبسولات النباتية بين 600 ملغ من أشواغاندا KSM-66 مع الروديولا والثيانين. تناول قرصين يوميًا مع الوجبات.</p>'),('ar',14,'استعادة النوم مشروب المغنيسيوم',NULL,'جلايسينات المغنيسيوم مع البابونج والكرز اللاذع - طقوس ليلية مهدئة.','<p> امزجيه في ماء دافئ قبل النوم بـ 30 دقيقة. 200 ملغ من المغنيسيوم سهل الامتصاص لكل وجبة. لا كافيين، لا إدمان.</p>'),('ar',15,'مزيج الفطر لدعم المزاج',NULL,'مركب الفطر الوظيفي — عرف الأسد، والريشي، والكورديسيبس — يدعم الإدراك.','<p>مستخلص مزدوج من أجسام الفاكهة العضوية. 1500 ملغ لكل وجبة. امزجه مع القهوة أو الشاي أو العصائر.</p>'),('ar',16,'مزيج الفطر لدعم المزاج',NULL,'مركب الفطر الوظيفي — عرف الأسد، والريشي، والكورديسيبس — يدعم الإدراك.','<p>مستخلص مزدوج من أجسام الفاكهة العضوية. 1500 ملغ لكل وجبة. امزجه مع القهوة أو الشاي أو العصائر.</p>'),('ar',17,'مزيج الفطر لدعم المزاج',NULL,'مركب الفطر الوظيفي — عرف الأسد، والريشي، والكورديسيبس — يدعم الإدراك.','<p>مستخلص مزدوج من أجسام الفاكهة العضوية. 1500 ملغ لكل وجبة. امزجه مع القهوة أو الشاي أو العصائر.</p>'),('ar',18,'مزيج الفطر لدعم المزاج',NULL,'مركب الفطر الوظيفي — عرف الأسد، والريشي، والكورديسيبس — يدعم الإدراك.','<p>مستخلص مزدوج من أجسام الفاكهة العضوية. 1500 ملغ لكل وجبة. امزجه مع القهوة أو الشاي أو العصائر.</p>'),('ar',19,'شاي الشفاء العشبي',NULL,'البابونج، حشيشة الهر، وبلسم الليمون في شكل أوراق فضفاضة - كوب من الشاي كل ليلة للاسترخاء قبل النوم.','<p> مزروع عضويًا ومختلط يدويًا. علبة 50 جرام قابلة للإغلاق تنتج 25 حصة. خالي من الكافيين بشكل طبيعي.</p>'),('ar',20,'شاي الشفاء العشبي',NULL,'البابونج، حشيشة الهر، وبلسم الليمون في شكل أوراق فضفاضة - كوب من الشاي كل ليلة للاسترخاء قبل النوم.','<p> مزروع عضويًا ومختلط يدويًا. علبة 50 جرام قابلة للإغلاق تنتج 25 حصة. خالي من الكافيين بشكل طبيعي.</p>'),('fr',1,'Poudre de légumes verts quotidiens',NULL,'Un mélange de super légumes verts biologiques avec de la spiruline, de la chlorelle et de l\'adaptogène pour une vitalité quotidienne.','<p>À base de plantes, sans sucre et contient 24 aliments entiers riches en nutriments. Mélangez une mesure dans de l\'eau ou dans votre smoothie préféré chaque matin.</p>'),('fr',2,'Capsules adaptogènes Calm Mind',NULL,'Le mélange d\'ashwagandha et de L-théanine est formulé pour réduire le stress et favoriser une concentration claire.','Les capsules <p>Vegan combinent 600 mg d\'ashwagandha KSM-66 avec de la rhodiola et de la théanine. Prendre deux comprimés par jour avec les repas.</p>'),('fr',3,'Boisson au magnésium pour restaurer le sommeil',NULL,'Glycinate de magnésium à la camomille et aux cerises acidulées : un rituel nocturne apaisant.','<p>Mélanger dans de l\'eau tiède 30 minutes avant de se coucher. 200 mg de magnésium facilement absorbable par portion. Pas de caféine, pas de dépendance.</p>'),('fr',4,'Diffuseur d\'aromathérapie',NULL,'Diffuseur en céramique à ultrasons avec rétroéclairage à sept couleurs et autonomie de quatre heures.','<p>Fonctionne aussi silencieusement qu\'un murmure. Arrêt automatique. Le récipient de 200 ml couvre jusqu\'à 30 m² de pièce. Livré avec un mélange d\'huiles essentielles relaxant à essayer.</p>'),('fr',5,'Mélange de champignons pour le soutien de l\'humeur',NULL,'Un complexe de champignons fonctionnels – crinière de lion, reishi et cordyceps – soutient la cognition.','<p>Double extrait de corps fruitiers biologiques. 1500 mg par portion. Mélanger avec du café, du thé ou des smoothies.</p>'),('fr',6,'Huile corporelle botanique',NULL,'Les huiles de jojoba et de squalane pressées à froid, infusées de lavande et de bergamote, apaisent la peau et les sens.','<p>Bouteille en verre dépoli de 100 ml. Appliquer après le bain pour une peau douce et hydratée et un parfum relaxant. Non testé sur les animaux.</p>'),('fr',7,'Journal de pleine conscience',NULL,'Le journal comprend un guide de 12 semaines avec des suggestions quotidiennes de gratitude, de réflexion et de définition d\'intentions.','<p>Certificat de certification FSC. Couverture rigide recouverte de lin. Comprend un tableau de suivi des habitudes, des exercices de respiration et un examen hebdomadaire.</p>'),('fr',8,'Lampe de luminothérapie',NULL,'Lampe de bureau à spectre complet de 10 000 lux avec chaleur réglable et minuterie intégrée de 30 minutes.','<p>Aide à réguler le rythme circadien pendant les mois de faible luminosité. Rayons UV filtrés. Support compact et angle d\'inclinaison réglable.</p>'),('fr',9,'Thé de récupération à base de plantes',NULL,'Camomille, valériane et mélisse sous forme de feuilles mobiles – une tasse de thé tous les soirs pour se détendre avant de se coucher.','<p>Cultivé biologiquement et mélangé à la main. La boîte refermable de 50 g donne 25 portions. Naturellement sans caféine.</p>'),('fr',10,'Capsules adaptogènes Calm Mind',NULL,'Le mélange d\'ashwagandha et de L-théanine est formulé pour réduire le stress et favoriser une concentration claire.','Les capsules <p>Vegan combinent 600 mg d\'ashwagandha KSM-66 avec de la rhodiola et de la théanine. Prendre deux comprimés par jour avec les repas.</p>'),('fr',11,'Capsules adaptogènes Calm Mind',NULL,'Le mélange d\'ashwagandha et de L-théanine est formulé pour réduire le stress et favoriser une concentration claire.','Les capsules <p>Vegan combinent 600 mg d\'ashwagandha KSM-66 avec de la rhodiola et de la théanine. Prendre deux comprimés par jour avec les repas.</p>'),('fr',12,'Capsules adaptogènes Calm Mind',NULL,'Le mélange d\'ashwagandha et de L-théanine est formulé pour réduire le stress et favoriser une concentration claire.','Les capsules <p>Vegan combinent 600 mg d\'ashwagandha KSM-66 avec de la rhodiola et de la théanine. Prendre deux comprimés par jour avec les repas.</p>'),('fr',13,'Capsules adaptogènes Calm Mind',NULL,'Le mélange d\'ashwagandha et de L-théanine est formulé pour réduire le stress et favoriser une concentration claire.','Les capsules <p>Vegan combinent 600 mg d\'ashwagandha KSM-66 avec de la rhodiola et de la théanine. Prendre deux comprimés par jour avec les repas.</p>'),('fr',14,'Boisson au magnésium pour restaurer le sommeil',NULL,'Glycinate de magnésium à la camomille et aux cerises acidulées : un rituel nocturne apaisant.','<p>Mélanger dans de l\'eau tiède 30 minutes avant de se coucher. 200 mg de magnésium facilement absorbable par portion. Pas de caféine, pas de dépendance.</p>'),('fr',15,'Mélange de champignons pour le soutien de l\'humeur',NULL,'Un complexe de champignons fonctionnels – crinière de lion, reishi et cordyceps – soutient la cognition.','<p>Double extrait de corps fruitiers biologiques. 1500 mg par portion. Mélanger avec du café, du thé ou des smoothies.</p>'),('fr',16,'Mélange de champignons pour le soutien de l\'humeur',NULL,'Un complexe de champignons fonctionnels – crinière de lion, reishi et cordyceps – soutient la cognition.','<p>Double extrait de corps fruitiers biologiques. 1500 mg par portion. Mélanger avec du café, du thé ou des smoothies.</p>'),('fr',17,'Mélange de champignons pour le soutien de l\'humeur',NULL,'Un complexe de champignons fonctionnels – crinière de lion, reishi et cordyceps – soutient la cognition.','<p>Double extrait de corps fruitiers biologiques. 1500 mg par portion. Mélanger avec du café, du thé ou des smoothies.</p>'),('fr',18,'Mélange de champignons pour le soutien de l\'humeur',NULL,'Un complexe de champignons fonctionnels – crinière de lion, reishi et cordyceps – soutient la cognition.','<p>Double extrait de corps fruitiers biologiques. 1500 mg par portion. Mélanger avec du café, du thé ou des smoothies.</p>'),('fr',19,'Thé de récupération à base de plantes',NULL,'Camomille, valériane et mélisse sous forme de feuilles mobiles – une tasse de thé tous les soirs pour se détendre avant de se coucher.','<p>Cultivé biologiquement et mélangé à la main. La boîte refermable de 50 g donne 25 portions. Naturellement sans caféine.</p>'),('fr',20,'Thé de récupération à base de plantes',NULL,'Camomille, valériane et mélisse sous forme de feuilles mobiles – une tasse de thé tous les soirs pour se détendre avant de se coucher.','<p>Cultivé biologiquement et mélangé à la main. La boîte refermable de 50 g donne 25 portions. Naturellement sans caféine.</p>'),('id',1,'Bubuk Hijau Harian',NULL,'Campuran sayuran super organik dengan spirulina, chlorella, dan adaptogen untuk vitalitas setiap hari.','<p>Berbasis tanaman, bebas gula dan mengandung 24 makanan utuh yang kaya nutrisi. Campurkan satu sendok ke dalam air atau smoothie favorit Anda setiap pagi.</p>'),('id',2,'Kapsul Adaptogen Pikiran Tenang',NULL,'Campuran ashwagandha dan L-theanine diformulasikan untuk mengurangi stres dan mendukung fokus yang jelas.','<p>Kapsul vegan menggabungkan 600mg ashwagandha KSM-66 dengan rhodiola dan theanine. Minum dua tablet per hari setelah makan.</p>'),('id',3,'Minuman Magnesium Pemulihan Tidur',NULL,'Magnesium glisinat dengan kamomil dan ceri asam—ritual malam yang menenangkan.','<p>Campurkan dalam air hangat 30 menit sebelum tidur. 200mg magnesium yang mudah diserap per porsi. Tanpa kafein, tanpa kecanduan.</p>'),('id',4,'Penyebar Aromaterapi',NULL,'Diffuser keramik ultrasonik dengan lampu latar tujuh warna dan waktu pengoperasian empat jam.','<p>Beroperasi senyap seperti bisikan. Shutdown otomatis. Wadah 200ml dapat menampung ruangan hingga 30m². Dilengkapi dengan campuran minyak esensial yang menenangkan untuk dicoba.</p>'),('id',5,'Campuran Jamur Pendukung Suasana Hati',NULL,'Kompleks jamur fungsional — surai singa, reishi, dan cordyceps — mendukung kognisi.','<p>Ekstrak ganda dari tubuh buah organik. 1500mg per porsi. Campurkan ke dalam kopi, teh atau smoothies.</p>'),('id',6,'Minyak Tubuh Botani',NULL,'Minyak jojoba dan squalane yang diperas dingin dengan kandungan lavender dan bergamot — menenangkan kulit dan indera.','<p>botol kaca buram 100ml. Oleskan setelah mandi untuk kulit lembut dan lembap serta wangi yang menenangkan. Tidak diuji pada hewan.</p>'),('id',7,'Jurnal Perhatian',NULL,'Jurnal ini mencakup panduan 12 minggu dengan saran harian untuk rasa syukur, refleksi, dan penetapan niat.','<p>Sertifikat sertifikasi FSC. Sampul keras berlapis linen. Termasuk bagan pelacakan kebiasaan, latihan pernapasan, dan ulasan mingguan.</p>'),('id',8,'Lampu Terapi Cahaya',NULL,'Lampu meja spektrum penuh 10.000 lux dengan kehangatan yang dapat disesuaikan dan pengatur waktu 30 menit bawaan.','<p>Membantu mengatur ritme sirkadian selama bulan-bulan dengan cahaya redup. Sinar UV yang disaring. Dudukan ringkas dan sudut kemiringan yang dapat disesuaikan.</p>'),('id',9,'Teh Pemulihan Herbal',NULL,'Chamomile, valerian, dan lemon balm dalam bentuk daun lepas — secangkir teh setiap malam untuk bersantai sebelum tidur.','<p>Ditanam secara organik dan dicampur dengan tangan. Kaleng 50g yang dapat ditutup kembali menghasilkan 25 porsi. Bebas kafein secara alami.</p>'),('id',10,'Kapsul Adaptogen Pikiran Tenang',NULL,'Campuran ashwagandha dan L-theanine diformulasikan untuk mengurangi stres dan mendukung fokus yang jelas.','<p>Kapsul vegan menggabungkan 600mg ashwagandha KSM-66 dengan rhodiola dan theanine. Minum dua tablet per hari setelah makan.</p>'),('id',11,'Kapsul Adaptogen Pikiran Tenang',NULL,'Campuran ashwagandha dan L-theanine diformulasikan untuk mengurangi stres dan mendukung fokus yang jelas.','<p>Kapsul vegan menggabungkan 600mg ashwagandha KSM-66 dengan rhodiola dan theanine. Minum dua tablet per hari setelah makan.</p>'),('id',12,'Kapsul Adaptogen Pikiran Tenang',NULL,'Campuran ashwagandha dan L-theanine diformulasikan untuk mengurangi stres dan mendukung fokus yang jelas.','<p>Kapsul vegan menggabungkan 600mg ashwagandha KSM-66 dengan rhodiola dan theanine. Minum dua tablet per hari setelah makan.</p>'),('id',13,'Kapsul Adaptogen Pikiran Tenang',NULL,'Campuran ashwagandha dan L-theanine diformulasikan untuk mengurangi stres dan mendukung fokus yang jelas.','<p>Kapsul vegan menggabungkan 600mg ashwagandha KSM-66 dengan rhodiola dan theanine. Minum dua tablet per hari setelah makan.</p>'),('id',14,'Minuman Magnesium Pemulihan Tidur',NULL,'Magnesium glisinat dengan kamomil dan ceri asam—ritual malam yang menenangkan.','<p>Campurkan dalam air hangat 30 menit sebelum tidur. 200mg magnesium yang mudah diserap per porsi. Tanpa kafein, tanpa kecanduan.</p>'),('id',15,'Campuran Jamur Pendukung Suasana Hati',NULL,'Kompleks jamur fungsional — surai singa, reishi, dan cordyceps — mendukung kognisi.','<p>Ekstrak ganda dari tubuh buah organik. 1500mg per porsi. Campurkan ke dalam kopi, teh atau smoothies.</p>'),('id',16,'Campuran Jamur Pendukung Suasana Hati',NULL,'Kompleks jamur fungsional — surai singa, reishi, dan cordyceps — mendukung kognisi.','<p>Ekstrak ganda dari tubuh buah organik. 1500mg per porsi. Campurkan ke dalam kopi, teh atau smoothies.</p>'),('id',17,'Campuran Jamur Pendukung Suasana Hati',NULL,'Kompleks jamur fungsional — surai singa, reishi, dan cordyceps — mendukung kognisi.','<p>Ekstrak ganda dari tubuh buah organik. 1500mg per porsi. Campurkan ke dalam kopi, teh atau smoothies.</p>'),('id',18,'Campuran Jamur Pendukung Suasana Hati',NULL,'Kompleks jamur fungsional — surai singa, reishi, dan cordyceps — mendukung kognisi.','<p>Ekstrak ganda dari tubuh buah organik. 1500mg per porsi. Campurkan ke dalam kopi, teh atau smoothies.</p>'),('id',19,'Teh Pemulihan Herbal',NULL,'Chamomile, valerian, dan lemon balm dalam bentuk daun lepas — secangkir teh setiap malam untuk bersantai sebelum tidur.','<p>Ditanam secara organik dan dicampur dengan tangan. Kaleng 50g yang dapat ditutup kembali menghasilkan 25 porsi. Bebas kafein secara alami.</p>'),('id',20,'Teh Pemulihan Herbal',NULL,'Chamomile, valerian, dan lemon balm dalam bentuk daun lepas — secangkir teh setiap malam untuk bersantai sebelum tidur.','<p>Ditanam secara organik dan dicampur dengan tangan. Kaleng 50g yang dapat ditutup kembali menghasilkan 25 porsi. Bebas kafein secara alami.</p>'),('tr',1,'Günlük Yeşillik Tozu',NULL,'Organik süper yeşillikler, her gün canlılık için spirulina, chlorella ve adaptogen ile harmanlanır.','<p>Bitki bazlı, şekersiz ve besin açısından zengin 24 tam gıda içerir. Her sabah bir ölçek suya veya en sevdiğiniz smoothie\'ye karıştırın.</p>'),('tr',2,'Sakin Zihin Adaptojen Kapsülleri',NULL,'Ashwagandha ve L-theanine karışımı, stresi azaltmak ve net odaklanmayı desteklemek için formüle edilmiştir.','<p>Vegan kapsülleri 600 mg ashwagandha KSM-66\'yı rhodiola ve theanine ile birleştirir. Yemeklerle birlikte günde iki tablet alın.</p>'),('tr',3,'Uyku Yenileyici Magnezyum İçeceği',NULL,'Papatya ve vişneli magnezyum glisinat; rahatlatıcı bir gece ritüeli.','<p>Yatmadan 30 dakika önce ılık suya karıştırın. Porsiyon başına 200 mg kolayca emilebilen magnezyum. Kafein yok, bağımlılık yok.</p>'),('tr',4,'Aromaterapi Difüzör',NULL,'Yedi renkli arka aydınlatmaya ve dört saatlik çalışma süresine sahip ultrasonik seramik difüzör.','<p>Fısıltı kadar sessiz çalışır. Otomatik kapanma. 200 ml\'lik kap 30 m²\'ye kadar alanı kaplar. Deneyebileceğiniz rahatlatıcı bir esansiyel yağ karışımıyla birlikte gelir.</p>'),('tr',5,'Ruh Hali Destekleyici Mantar Karışımı',NULL,'Fonksiyonel mantar kompleksi (aslan yelesi, reishi ve kordiseps) bilişi destekler.','<p>Organik meyve gövdelerinden çift ekstrakt. Porsiyon başına 1500 mg. Kahve, çay veya smoothie\'lere karıştırın.</p>'),('tr',6,'Botanik Vücut Yağı',NULL,'Lavanta ve bergamot ile zenginleştirilmiş soğuk preslenmiş jojoba ve skualen yağları cildi ve duyuları rahatlatır.','<p>100ml buzlu cam şişe. Yumuşak, nemli bir cilt ve rahatlatıcı bir koku için banyodan sonra uygulayın. Hayvanlar üzerinde test edilmemiştir.</p>'),('tr',7,'Farkındalık Günlüğü',NULL,'Dergide şükran, derinlemesine düşünme ve niyet belirlemeye yönelik günlük öneriler içeren 12 haftalık bir rehber bulunmaktadır.','<p>FSC sertifikasyon sertifikası. Keten kaplı ciltli. Alışkanlık izleme tablosu, nefes egzersizleri ve haftalık incelemeyi içerir.</p>'),('tr',8,'Işık Terapi Lambası',NULL,'Ayarlanabilir sıcaklığa ve dahili 30 dakikalık zamanlayıcıya sahip 10.000 lüks tam spektrumlu masa lambası.','<p>Işığın az olduğu aylarda sirkadiyen ritmi düzenlemeye yardımcı olur. Filtrelenmiş UV ışınları. Kompakt stand ve ayarlanabilir eğim açısı.</p>'),('tr',9,'Bitkisel İyileştirme Çayı',NULL,'Gevşek yaprak formundaki papatya, kediotu ve melisa – yatmadan önce rahatlamak için her gece bir fincan çay.','<p>Organik olarak yetiştirilmiş ve elle karıştırılmıştır. 50 g\'lık yeniden kapatılabilir tenekeden 25 porsiyon elde edilir. Doğal olarak kafeinsizdir.</p>'),('tr',10,'Sakin Zihin Adaptojen Kapsülleri',NULL,'Ashwagandha ve L-theanine karışımı, stresi azaltmak ve net odaklanmayı desteklemek için formüle edilmiştir.','<p>Vegan kapsülleri 600 mg ashwagandha KSM-66\'yı rhodiola ve theanine ile birleştirir. Yemeklerle birlikte günde iki tablet alın.</p>'),('tr',11,'Sakin Zihin Adaptojen Kapsülleri',NULL,'Ashwagandha ve L-theanine karışımı, stresi azaltmak ve net odaklanmayı desteklemek için formüle edilmiştir.','<p>Vegan kapsülleri 600 mg ashwagandha KSM-66\'yı rhodiola ve theanine ile birleştirir. Yemeklerle birlikte günde iki tablet alın.</p>'),('tr',12,'Sakin Zihin Adaptojen Kapsülleri',NULL,'Ashwagandha ve L-theanine karışımı, stresi azaltmak ve net odaklanmayı desteklemek için formüle edilmiştir.','<p>Vegan kapsülleri 600 mg ashwagandha KSM-66\'yı rhodiola ve theanine ile birleştirir. Yemeklerle birlikte günde iki tablet alın.</p>'),('tr',13,'Sakin Zihin Adaptojen Kapsülleri',NULL,'Ashwagandha ve L-theanine karışımı, stresi azaltmak ve net odaklanmayı desteklemek için formüle edilmiştir.','<p>Vegan kapsülleri 600 mg ashwagandha KSM-66\'yı rhodiola ve theanine ile birleştirir. Yemeklerle birlikte günde iki tablet alın.</p>'),('tr',14,'Uyku Yenileyici Magnezyum İçeceği',NULL,'Papatya ve vişneli magnezyum glisinat; rahatlatıcı bir gece ritüeli.','<p>Yatmadan 30 dakika önce ılık suya karıştırın. Porsiyon başına 200 mg kolayca emilebilen magnezyum. Kafein yok, bağımlılık yok.</p>'),('tr',15,'Ruh Hali Destekleyici Mantar Karışımı',NULL,'Fonksiyonel mantar kompleksi (aslan yelesi, reishi ve kordiseps) bilişi destekler.','<p>Organik meyve gövdelerinden çift ekstrakt. Porsiyon başına 1500 mg. Kahve, çay veya smoothie\'lere karıştırın.</p>'),('tr',16,'Ruh Hali Destekleyici Mantar Karışımı',NULL,'Fonksiyonel mantar kompleksi (aslan yelesi, reishi ve kordiseps) bilişi destekler.','<p>Organik meyve gövdelerinden çift ekstrakt. Porsiyon başına 1500 mg. Kahve, çay veya smoothie\'lere karıştırın.</p>'),('tr',17,'Ruh Hali Destekleyici Mantar Karışımı',NULL,'Fonksiyonel mantar kompleksi (aslan yelesi, reishi ve kordiseps) bilişi destekler.','<p>Organik meyve gövdelerinden çift ekstrakt. Porsiyon başına 1500 mg. Kahve, çay veya smoothie\'lere karıştırın.</p>'),('tr',18,'Ruh Hali Destekleyici Mantar Karışımı',NULL,'Fonksiyonel mantar kompleksi (aslan yelesi, reishi ve kordiseps) bilişi destekler.','<p>Organik meyve gövdelerinden çift ekstrakt. Porsiyon başına 1500 mg. Kahve, çay veya smoothie\'lere karıştırın.</p>'),('tr',19,'Bitkisel İyileştirme Çayı',NULL,'Gevşek yaprak formundaki papatya, kediotu ve melisa – yatmadan önce rahatlamak için her gece bir fincan çay.','<p>Organik olarak yetiştirilmiş ve elle karıştırılmıştır. 50 g\'lık yeniden kapatılabilir tenekeden 25 porsiyon elde edilir. Doğal olarak kafeinsizdir.</p>'),('tr',20,'Bitkisel İyileştirme Çayı',NULL,'Gevşek yaprak formundaki papatya, kediotu ve melisa – yatmadan önce rahatlamak için her gece bir fincan çay.','<p>Organik olarak yetiştirilmiş ve elle karıştırılmıştır. 50 g\'lık yeniden kapatılabilir tenekeden 25 porsiyon elde edilir. Doğal olarak kafeinsizdir.</p>'),('vi',1,'Bột rau xanh hằng ngày',NULL,'Hỗn hợp siêu rau xanh hữu cơ với tảo spirulina, chlorella và adaptogen cho sức sống mỗi ngày.','<p>Thuần thực vật, không đường và chứa 24 loại thực phẩm toàn phần giàu dưỡng chất. Pha một muỗng vào nước hoặc sinh tố yêu thích của bạn mỗi sáng.</p>'),('vi',2,'Viên adaptogen An tâm trí',NULL,'Hỗn hợp ashwagandha và L-theanine được bào chế để giảm căng thẳng và hỗ trợ tập trung rõ ràng.','<p>Viên thuần chay kết hợp 600mg ashwagandha KSM-66 với rhodiola và theanine. Uống hai viên mỗi ngày cùng bữa ăn.</p>'),('vi',3,'Thức uống magie Phục hồi giấc ngủ',NULL,'Magie glycinate với hoa cúc và quả anh đào chua — một nghi thức nhẹ nhàng mỗi đêm.','<p>Pha vào nước ấm 30 phút trước khi ngủ. 200mg magie dễ hấp thụ mỗi khẩu phần. Không caffeine, không gây nghiện.</p>'),('vi',4,'Máy khuếch tán tinh dầu',NULL,'Máy khuếch tán gốm siêu âm với đèn nền bảy màu và thời gian hoạt động bốn giờ.','<p>Hoạt động êm như thì thầm. Tự động ngắt. Bình chứa 200ml phủ phòng tới 30m². Kèm hỗn hợp tinh dầu thư giãn dùng thử.</p>'),('vi',5,'Hỗn hợp nấm Hỗ trợ tâm trạng',NULL,'Phức hợp nấm chức năng — bờm sư tử, linh chi và đông trùng hạ thảo — hỗ trợ nhận thức.','<p>Chiết xuất kép từ thể quả hữu cơ. 1500mg mỗi khẩu phần. Pha vào cà phê, trà hoặc sinh tố.</p>'),('vi',6,'Dầu dưỡng thể thực vật',NULL,'Dầu jojoba và squalane ép lạnh thấm tinh chất oải hương và cam bergamot — làm dịu làn da và giác quan.','<p>Chai thủy tinh mờ 100ml. Thoa sau khi tắm để có làn da mềm mại, ẩm mượt và hương thơm thư thái. Không thử nghiệm trên động vật.</p>'),('vi',7,'Nhật ký chánh niệm',NULL,'Nhật ký có hướng dẫn 12 tuần với các gợi ý hằng ngày về lòng biết ơn, sự suy ngẫm và đặt ý định.','<p>Giấy đạt chứng nhận FSC. Bìa cứng bọc vải lanh. Kèm bảng theo dõi thói quen, bài tập thở và phần ôn tập hằng tuần.</p>'),('vi',8,'Đèn trị liệu ánh sáng',NULL,'Đèn bàn quang phổ đầy đủ 10.000 lux với độ ấm điều chỉnh được và bộ hẹn giờ 30 phút tích hợp.','<p>Giúp điều hòa nhịp sinh học trong những tháng thiếu sáng. Đã lọc tia UV. Chân đế nhỏ gọn và điều chỉnh được góc nghiêng.</p>'),('vi',9,'Trà thảo mộc Phục hồi',NULL,'Hoa cúc, nữ lang và tía tô đất dạng lá rời — một tách trà mỗi đêm để thư giãn trước khi ngủ.','<p>Trồng hữu cơ và pha trộn thủ công. Hộp thiếc 50g đóng kín lại được cho 25 khẩu phần. Tự nhiên không chứa caffeine.</p>'),('vi',10,'Viên adaptogen An tâm trí',NULL,'Hỗn hợp ashwagandha và L-theanine được bào chế để giảm căng thẳng và hỗ trợ tập trung rõ ràng.','<p>Viên thuần chay kết hợp 600mg ashwagandha KSM-66 với rhodiola và theanine. Uống hai viên mỗi ngày cùng bữa ăn.</p>'),('vi',11,'Viên adaptogen An tâm trí',NULL,'Hỗn hợp ashwagandha và L-theanine được bào chế để giảm căng thẳng và hỗ trợ tập trung rõ ràng.','<p>Viên thuần chay kết hợp 600mg ashwagandha KSM-66 với rhodiola và theanine. Uống hai viên mỗi ngày cùng bữa ăn.</p>'),('vi',12,'Viên adaptogen An tâm trí',NULL,'Hỗn hợp ashwagandha và L-theanine được bào chế để giảm căng thẳng và hỗ trợ tập trung rõ ràng.','<p>Viên thuần chay kết hợp 600mg ashwagandha KSM-66 với rhodiola và theanine. Uống hai viên mỗi ngày cùng bữa ăn.</p>'),('vi',13,'Viên adaptogen An tâm trí',NULL,'Hỗn hợp ashwagandha và L-theanine được bào chế để giảm căng thẳng và hỗ trợ tập trung rõ ràng.','<p>Viên thuần chay kết hợp 600mg ashwagandha KSM-66 với rhodiola và theanine. Uống hai viên mỗi ngày cùng bữa ăn.</p>'),('vi',14,'Thức uống magie Phục hồi giấc ngủ',NULL,'Magie glycinate với hoa cúc và quả anh đào chua — một nghi thức nhẹ nhàng mỗi đêm.','<p>Pha vào nước ấm 30 phút trước khi ngủ. 200mg magie dễ hấp thụ mỗi khẩu phần. Không caffeine, không gây nghiện.</p>'),('vi',15,'Hỗn hợp nấm Hỗ trợ tâm trạng',NULL,'Phức hợp nấm chức năng — bờm sư tử, linh chi và đông trùng hạ thảo — hỗ trợ nhận thức.','<p>Chiết xuất kép từ thể quả hữu cơ. 1500mg mỗi khẩu phần. Pha vào cà phê, trà hoặc sinh tố.</p>'),('vi',16,'Hỗn hợp nấm Hỗ trợ tâm trạng',NULL,'Phức hợp nấm chức năng — bờm sư tử, linh chi và đông trùng hạ thảo — hỗ trợ nhận thức.','<p>Chiết xuất kép từ thể quả hữu cơ. 1500mg mỗi khẩu phần. Pha vào cà phê, trà hoặc sinh tố.</p>'),('vi',17,'Hỗn hợp nấm Hỗ trợ tâm trạng',NULL,'Phức hợp nấm chức năng — bờm sư tử, linh chi và đông trùng hạ thảo — hỗ trợ nhận thức.','<p>Chiết xuất kép từ thể quả hữu cơ. 1500mg mỗi khẩu phần. Pha vào cà phê, trà hoặc sinh tố.</p>'),('vi',18,'Hỗn hợp nấm Hỗ trợ tâm trạng',NULL,'Phức hợp nấm chức năng — bờm sư tử, linh chi và đông trùng hạ thảo — hỗ trợ nhận thức.','<p>Chiết xuất kép từ thể quả hữu cơ. 1500mg mỗi khẩu phần. Pha vào cà phê, trà hoặc sinh tố.</p>'),('vi',19,'Trà thảo mộc Phục hồi',NULL,'Hoa cúc, nữ lang và tía tô đất dạng lá rời — một tách trà mỗi đêm để thư giãn trước khi ngủ.','<p>Trồng hữu cơ và pha trộn thủ công. Hộp thiếc 50g đóng kín lại được cho 25 khẩu phần. Tự nhiên không chứa caffeine.</p>'),('vi',20,'Trà thảo mộc Phục hồi',NULL,'Hoa cúc, nữ lang và tía tô đất dạng lá rời — một tách trà mỗi đêm để thư giãn trước khi ngủ.','<p>Trồng hữu cơ và pha trộn thủ công. Hộp thiếc 50g đóng kín lại được cho 25 khẩu phần. Tự nhiên không chứa caffeine.</p>');

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

CREATE TABLE `ec_review_replies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `customer_id` bigint unsigned DEFAULT 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_unique` (`review_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `ec_reviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint unsigned DEFAULT NULL,
  `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_id` bigint unsigned NOT NULL,
  `star` double NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `badge_type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'auto',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `images` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_reviews_product_id_customer_id_unique` (`product_id`,`customer_id`),
  KEY `ec_reviews_product_id_customer_id_status_created_at_index` (`product_id`,`customer_id`,`status`,`created_at`),
  KEY `review_relation_index` (`product_id`,`customer_id`,`status`),
  KEY `ec_reviews_product_id_status_index` (`product_id`,`status`),
  KEY `ec_reviews_customer_id_status_index` (`customer_id`,`status`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--
-- Table structure for table `ec_shared_wishlists`
--

CREATE TABLE `ec_shared_wishlists` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_ids` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_shared_wishlists_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_shared_wishlists`
--


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

CREATE TABLE `ec_shipment_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `action` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `shipment_id` bigint unsigned NOT NULL,
  `order_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `ec_shipments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `weight` double DEFAULT '0',
  `shipment_id` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rate_id` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `cod_amount` decimal(15,2) DEFAULT '0.00',
  `cod_status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `cross_checking_status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `price` decimal(15,2) DEFAULT '0.00',
  `store_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tracking_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tracking_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `estimate_date_shipped` datetime DEFAULT NULL,
  `date_shipped` datetime DEFAULT NULL,
  `customer_delivered_confirmed_at` timestamp NULL DEFAULT NULL,
  `label_url` text COLLATE utf8mb4_unicode_ci,
  `metadata` mediumtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_shipments_order_id_unique` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

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

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

INSERT INTO `ec_shipping` VALUES (1,'Domestic',NULL,'2026-05-28 19:07:17','2026-05-28 19:07:17'),(2,'International',NULL,'2026-05-28 19:07:17','2026-05-28 19:07:17');

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

CREATE TABLE `ec_shipping_rule_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `shipping_rule_id` bigint unsigned NOT NULL,
  `name` varchar(120) 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,
  `zip_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip_code_from` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip_code_to` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adjustment_price` decimal(15,2) DEFAULT '0.00',
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_zip_range` (`zip_code_from`,`zip_code_to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

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

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

INSERT INTO `ec_shipping_rules` VALUES (1,'Free Standard Shipping (orders $99+)',1,'based_on_price',99.00,NULL,0.00,'2026-05-28 19:07:17','2026-05-28 19:07:17'),(2,'Standard (3-5 business days)',1,'based_on_price',0.00,NULL,7.99,'2026-05-28 19:07:17','2026-05-28 19:07:17'),(3,'Express (1-2 business days)',1,'based_on_price',0.00,NULL,19.99,'2026-05-28 19:07:17','2026-05-28 19:07:17'),(4,'Local Pickup',1,'based_on_price',0.00,NULL,0.00,'2026-05-28 19:07:17','2026-05-28 19:07:17'),(5,'International Standard (7-12 days)',2,'based_on_price',0.00,NULL,24.99,'2026-05-28 19:07:17','2026-05-28 19:07:17'),(6,'International Express (3-5 days)',2,'based_on_price',0.00,NULL,49.99,'2026-05-28 19:07:17','2026-05-28 19:07:17');

--
-- Table structure for table `ec_specification_attributes`
--

CREATE TABLE `ec_specification_attributes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `group_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` text COLLATE utf8mb4_unicode_ci,
  `default_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `author_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `author_index` (`author_type`,`author_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_specification_attributes`
--

INSERT INTO `ec_specification_attributes` VALUES (1,1,'Composition','text',NULL,'55% Polyester, 30% Acrylic, 13% Polyamide, 2% Elastane','2026-05-28 19:07:06','2026-05-28 19:07:06',NULL,NULL),(2,1,'Origin','text',NULL,'Made in Portugal','2026-05-28 19:07:06','2026-05-28 19:07:06',NULL,NULL),(3,1,'Care','text',NULL,'Machine wash cold. Tumble dry low. Do not bleach.','2026-05-28 19:07:06','2026-05-28 19:07:06',NULL,NULL),(4,2,'Designed In','text',NULL,'Barcelona, Spain','2026-05-28 19:07:06','2026-05-28 19:07:06',NULL,NULL),(5,2,'Warranty','text',NULL,'12 months manufacturer warranty','2026-05-28 19:07:06','2026-05-28 19:07:06',NULL,NULL),(6,2,'Made From Recycled Materials','checkbox',NULL,'1','2026-05-28 19:07:06','2026-05-28 19:07:06',NULL,NULL);

--
-- Table structure for table `ec_specification_attributes_translations`
--

CREATE TABLE `ec_specification_attributes_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_specification_attributes_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `options` text COLLATE utf8mb4_unicode_ci,
  `default_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_specification_attributes_id`),
  KEY `idx_specification_attributes_fk` (`ec_specification_attributes_id`),
  KEY `idx_specification_attributes_specification_attributes_lang` (`ec_specification_attributes_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_specification_attributes_translations`
--


--
-- Table structure for table `ec_specification_groups`
--

CREATE TABLE `ec_specification_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `author_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `author_index` (`author_type`,`author_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_specification_groups`
--

INSERT INTO `ec_specification_groups` VALUES (1,'Material & Composition','Fibre breakdown, origin and care guidance.','2026-05-28 19:07:06','2026-05-28 19:07:06',NULL,NULL),(2,'Product Details','Provenance, warranty and sustainability.','2026-05-28 19:07:06','2026-05-28 19:07:06',NULL,NULL);

--
-- Table structure for table `ec_specification_groups_translations`
--

CREATE TABLE `ec_specification_groups_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_specification_groups_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_specification_groups_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_specification_groups_translations`
--


--
-- Table structure for table `ec_specification_table_group`
--

CREATE TABLE `ec_specification_table_group` (
  `table_id` bigint unsigned NOT NULL,
  `group_id` bigint unsigned NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`table_id`,`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_specification_table_group`
--

INSERT INTO `ec_specification_table_group` VALUES (1,1,0),(1,2,1);

--
-- Table structure for table `ec_specification_tables`
--

CREATE TABLE `ec_specification_tables` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `author_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `author_index` (`author_type`,`author_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_specification_tables`
--

INSERT INTO `ec_specification_tables` VALUES (1,'Default Specifications','Default specification layout applied to all products.','2026-05-28 19:07:06','2026-05-28 19:07:06',NULL,NULL);

--
-- Table structure for table `ec_specification_tables_translations`
--

CREATE TABLE `ec_specification_tables_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_specification_tables_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_specification_tables_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_specification_tables_translations`
--


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

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

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


--
-- Table structure for table `ec_tax_products`
--

CREATE TABLE `ec_tax_products` (
  `tax_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`product_id`,`tax_id`),
  KEY `ec_tax_products_tax_id_index` (`tax_id`),
  KEY `ec_tax_products_product_id_index` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_tax_products`
--


--
-- Table structure for table `ec_tax_rules`
--

CREATE TABLE `ec_tax_rules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tax_id` bigint unsigned NOT NULL,
  `country` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `priority` int DEFAULT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `percentage` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_tax_rules`
--


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

CREATE TABLE `ec_taxes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `percentage` float DEFAULT NULL,
  `priority` int 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `ec_taxes_translations`
--

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

--
-- Dumping data for table `ec_taxes_translations`
--


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

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

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


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

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

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


--
-- Table structure for table `faq_categories`
--

CREATE TABLE `faq_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint 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,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faq_categories`
--

INSERT INTO `faq_categories` VALUES (1,'Orders &amp; Shipping',0,'published','2026-05-28 19:07:05','2026-05-28 19:07:05','Everything about placing, tracking, and receiving your order.'),(2,'Returns &amp; Refunds',1,'published','2026-05-28 19:07:05','2026-05-28 19:07:05','Our 30-day return policy and how to start a return.'),(3,'Products &amp; Stock',2,'published','2026-05-28 19:07:05','2026-05-28 19:07:05','Sizing, materials, restocks, and product care.'),(4,'Account &amp; Payment',3,'published','2026-05-28 19:07:05','2026-05-28 19:07:05','Managing your account and accepted payment methods.');

--
-- Table structure for table `faq_categories_translations`
--

CREATE TABLE `faq_categories_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `faq_categories_id` bigint unsigned NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`faq_categories_id`),
  KEY `idx_faq_cat_trans_faq_cat_id` (`faq_categories_id`),
  KEY `idx_faq_cat_trans_faq_cat_lang` (`faq_categories_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faq_categories_translations`
--

INSERT INTO `faq_categories_translations` VALUES ('ar',1,'Orders &amp; Shipping'),('ar',2,'Returns &amp; Refunds'),('ar',3,'Products &amp; Stock'),('ar',4,'Account &amp; Payment'),('fr',1,'Orders &amp; Shipping'),('fr',2,'Returns &amp; Refunds'),('fr',3,'Products &amp; Stock'),('fr',4,'Account &amp; Payment'),('id',1,'Orders &amp; Shipping'),('id',2,'Returns &amp; Refunds'),('id',3,'Products &amp; Stock'),('id',4,'Account &amp; Payment'),('tr',1,'Orders &amp; Shipping'),('tr',2,'Returns &amp; Refunds'),('tr',3,'Products &amp; Stock'),('tr',4,'Account &amp; Payment'),('vi',1,'Orders &amp; Shipping'),('vi',2,'Returns &amp; Refunds'),('vi',3,'Products &amp; Stock'),('vi',4,'Account &amp; Payment');

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` bigint unsigned 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=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` VALUES (1,'How long does standard shipping take?','Standard shipping arrives within 3-5 business days for domestic orders and 7-12 business days for international destinations. Express options are available at checkout.',1,'published','2026-05-28 19:07:05','2026-05-28 19:07:05'),(2,'Do you offer free shipping?','Yes — orders above $99 ship free within the continental US. International free-shipping thresholds vary by destination and are shown at checkout.',1,'published','2026-05-28 19:07:05','2026-05-28 19:07:05'),(3,'How can I track my order?','You will receive a tracking link by email as soon as your order is dispatched. You can also follow the parcel from your account dashboard under My Orders.',1,'published','2026-05-28 19:07:05','2026-05-28 19:07:05'),(4,'Can I change the shipping address after I place my order?','Address changes are possible if your order has not yet entered fulfilment. Contact us within two hours of placing the order for the best chance of a successful update.',1,'published','2026-05-28 19:07:05','2026-05-28 19:07:05'),(5,'What is your return policy?','We offer 30 days from delivery to return any unworn item in its original condition. Sale items and intimate apparel are final sale.',2,'published','2026-05-28 19:07:05','2026-05-28 19:07:05'),(6,'How do I start a return?','Start a return from your account dashboard or email returns@amerce.test with your order number. We will send a prepaid return label for domestic orders.',2,'published','2026-05-28 19:07:05','2026-05-28 19:07:05'),(7,'When will I receive my refund?','Refunds are processed within 3-5 business days of us receiving your return. The funds typically appear on your statement within an additional 5-7 days, depending on your bank.',2,'published','2026-05-28 19:07:05','2026-05-28 19:07:05'),(8,'How do I find the right size?','Each product page includes a size chart based on actual garment measurements. If you are between sizes, we generally recommend sizing up for our knitwear and outerwear.',3,'published','2026-05-28 19:07:05','2026-05-28 19:07:05'),(9,'When will sold-out items be restocked?','Most styles restock within 2-4 weeks. Click the Notify Me button on any sold-out variant to be alerted by email the moment it returns.',3,'published','2026-05-28 19:07:05','2026-05-28 19:07:05'),(10,'Are your products ethically sourced?','Yes. We work only with manufacturing partners who meet our supplier code of conduct, covering fair wages, safe conditions, and verified material provenance.',3,'published','2026-05-28 19:07:05','2026-05-28 19:07:05'),(11,'Which payment methods do you accept?','We accept Visa, Mastercard, American Express, Apple Pay, Google Pay, PayPal, and Klarna for eligible markets.',4,'published','2026-05-28 19:07:05','2026-05-28 19:07:05'),(12,'Is it safe to enter my card details?','All payments are processed by PCI-DSS Level 1 certified providers using TLS 1.3 encryption. We never store full card numbers on our servers.',4,'published','2026-05-28 19:07:05','2026-05-28 19:07:05'),(13,'How do I reset my password?','Use the Forgot Password link on the login page. A reset link will be sent to your registered email address and is valid for 30 minutes.',4,'published','2026-05-28 19:07:06','2026-05-28 19:07:06');

--
-- Table structure for table `faqs_translations`
--

CREATE TABLE `faqs_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `faqs_id` bigint unsigned NOT NULL,
  `question` text COLLATE utf8mb4_unicode_ci,
  `answer` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`faqs_id`),
  KEY `idx_faqs_trans_faqs_id` (`faqs_id`),
  KEY `idx_faqs_trans_faq_lang` (`faqs_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs_translations`
--

INSERT INTO `faqs_translations` VALUES ('ar',1,'كم من الوقت يستغرق الشحن القياسي؟','يصل الشحن القياسي خلال 3-5 أيام عمل للطلبات المحلية و7-12 يوم عمل للوجهات الدولية. تتوفر خيارات الشحن المعجل عند الخروج.'),('ar',2,'هل تقدمون الشحن المجاني؟','نعم - يتم شحن الطلبات التي تزيد قيمتها عن 99 دولارًا مجانًا داخل الولايات المتحدة القارية. يختلف الحد الأدنى للشحن الدولي المجاني حسب الوجهة ويتم عرضه عند الخروج.'),('ar',3,'كيف يمكنني تتبع طلبي؟','سوف تتلقى رابط تتبع عبر البريد الإلكتروني بمجرد شحن طلبك. يمكنك أيضًا تتبع الحزمة الخاصة بك من صفحة إدارة حسابك ضمن طلباتي.'),('ar',4,'هل يمكنني تغيير عنوان الشحن بعد تقديم طلبي؟','يمكن تغيير العنوان إذا لم تتم معالجة الطلب. اتصل بنا خلال ساعتين من تقديم طلبك للحصول على أفضل فرصة لتحديث ناجح.'),('ar',5,'ما هي سياسة الإرجاع الخاصة بك؟','نمنح 30 يومًا من تاريخ التسليم لإعادة أي منتج غير مستخدم بحالته الأصلية. العناصر والملابس الداخلية المخفضة نهائية - ولا توجد عوائد.'),('ar',6,'كيف أبدأ العودة؟','ابدأ عملية الإرجاع من صفحة إدارة حسابك أو أرسل بريدًا إلكترونيًا إلى return@amerce.test يتضمن رقم طلبك. سوف نرسل ملصق شحن الإرجاع المدفوع مسبقًا للطلبات المحلية.'),('ar',7,'متى سأستلم أموالي المستردة؟','تتم معالجة المبالغ المستردة في غضون 3-5 أيام عمل من تاريخ استلامنا للمنتج المرتجع. تظهر الأموال عادة في كشف حسابك بعد 5-7 أيام إضافية حسب البنك.'),('ar',8,'كيف أجد الحجم المناسب؟','تحتوي كل صفحة منتج على مخطط حجم يعتمد على قياسات المنتج الفعلية. إذا كان مقاسك بين مقاسين، فنوصي عادةً باختيار المقاس الأكبر للملابس المحبوكة والمعاطف.'),('ar',9,'متى سيتم إعادة تخزين العناصر المباعة؟','يتم إعادة تخزين معظم الأنماط في غضون 2-4 أسابيع. انقر فوق الزر \"أخطرني\" الموجود على أي إصدار غير متوفر في المخزون ليتم إعلامك عبر البريد الإلكتروني عندما يعود المنتج.'),('ar',10,'هل منتجاتك من مصادر أخلاقية؟','يملك. نحن نعمل فقط مع شركاء التصنيع الذين يستوفون قواعد سلوك الموردين الخاصة بنا، بما في ذلك الأجور العادلة والظروف الآمنة وأصول المواد التي تم التحقق منها.'),('ar',11,'ما هي طرق الدفع التي تقبلونها؟','نحن نقبل Visa وMastercard وAmerican Express وApple Pay وGoogle Pay وPayPal وKlarna للأسواق المدعومة.'),('ar',12,'هل من الآمن إدخال تفاصيل بطاقتي؟','تتم معالجة جميع المدفوعات بواسطة مزود معتمد من PCI-DSS من المستوى 1 مع تشفير TLS 1.3. لا نقوم مطلقًا بتخزين أرقام البطاقات الكاملة على خوادمنا.'),('ar',13,'كيف يمكنني إعادة تعيين كلمة المرور الخاصة بي؟','استخدم رابط نسيت كلمة المرور في صفحة تسجيل الدخول. سيتم إرسال رابط إعادة التعيين إلى بريدك الإلكتروني المسجل وهو صالح لمدة 30 دقيقة.'),('fr',1,'Combien de temps prend l\'expédition standard ?','L\'expédition standard arrive dans un délai de 3 à 5 jours ouvrables pour les commandes nationales et de 7 à 12 jours ouvrables pour les destinations internationales. Des options d’expédition accélérée sont disponibles à la caisse.'),('fr',2,'Offrez-vous la livraison gratuite ?','Oui, les commandes de plus de 99 $ sont expédiées gratuitement dans la zone continentale des États-Unis. Le seuil de livraison internationale gratuite varie selon la destination et est affiché au moment du paiement.'),('fr',3,'Comment puis-je suivre ma commande ?','Vous recevrez un lien de suivi par e-mail dès que votre commande sera expédiée. Vous pouvez également suivre votre colis depuis la page de gestion de votre compte sous Mes commandes.'),('fr',4,'Puis-je modifier l\'adresse de livraison après avoir passé ma commande ?','L\'adresse peut être modifiée si la commande n\'a pas été traitée. Contactez-nous dans les deux heures suivant votre commande pour avoir les meilleures chances de réussite de la mise à jour.'),('fr',5,'Quelle est votre politique de retour ?','Nous vous accordons 30 jours à compter de la date de livraison pour retourner tout produit non utilisé dans son état d\'origine. Les articles et sous-vêtements à prix réduit sont définitifs – aucun retour.'),('fr',6,'Comment démarrer un retour ?','Initiez un retour depuis la page de gestion de votre compte ou envoyez un e-mail à return@amerce.test avec votre numéro de commande. Nous enverrons une étiquette de retour prépayée pour les commandes nationales.'),('fr',7,'Quand vais-je recevoir mon remboursement ?','Les remboursements sont traités dans les 3 à 5 jours ouvrables à compter de la réception de l\'article retourné. Les fonds apparaissent généralement sur votre relevé après 5 à 7 jours supplémentaires selon la banque.'),('fr',8,'Comment trouver la bonne taille ?','Chaque page de produit comporte un tableau des tailles basé sur les mesures réelles du produit. Si vous êtes entre deux tailles, nous vous recommandons généralement de choisir la taille la plus grande pour les tricots et les manteaux.'),('fr',9,'Quand les articles épuisés seront-ils réapprovisionnés ?','La plupart des styles sont réapprovisionnés dans un délai de 2 à 4 semaines. Cliquez sur le bouton M\'avertir de toute variation en rupture de stock pour être averti par e-mail du retour du produit.'),('fr',10,'Vos produits sont-ils issus de sources éthiques ?','Avoir. Nous travaillons uniquement avec des partenaires de fabrication qui respectent notre code de conduite des fournisseurs, notamment des salaires équitables, des conditions sûres et des origines de matériaux vérifiées.'),('fr',11,'Quels modes de paiement acceptez-vous ?','Nous acceptons Visa, Mastercard, American Express, Apple Pay, Google Pay, PayPal et Klarna pour les marchés pris en charge.'),('fr',12,'Est-il sécuritaire de saisir les détails de ma carte ?','Tous les paiements sont traités par un fournisseur certifié PCI-DSS niveau 1 avec cryptage TLS 1.3. Nous ne stockons jamais les numéros de carte complets sur nos serveurs.'),('fr',13,'Comment réinitialiser mon mot de passe ?','Utilisez le lien Mot de passe oublié sur la page de connexion. Un lien de réinitialisation sera envoyé à votre adresse e-mail enregistrée et est valable 30 minutes.'),('id',1,'Berapa lama waktu pengiriman standar?','Pengiriman standar tiba dalam 3-5 hari kerja untuk pesanan domestik dan 7-12 hari kerja untuk tujuan internasional. Opsi pengiriman yang dipercepat tersedia saat checkout.'),('id',2,'Apakah Anda menawarkan pengiriman gratis?','Ya — pesanan di atas $99 dikirimkan gratis di wilayah AS. Ambang batas pengiriman internasional gratis bervariasi berdasarkan tujuan dan ditampilkan saat checkout.'),('id',3,'Bagaimana cara melacak pesanan saya?','Anda akan menerima tautan pelacakan melalui email segera setelah pesanan Anda dikirimkan. Anda juga dapat melacak paket Anda dari halaman manajemen akun Anda di bawah Pesanan Saya.'),('id',4,'Bisakah saya mengubah alamat pengiriman setelah saya melakukan pemesanan?','Alamat dapat diubah jika pesanan belum diproses. Hubungi kami dalam waktu dua jam setelah melakukan pemesanan untuk mendapatkan peluang terbaik agar pembaruan berhasil.'),('id',5,'Apa kebijakan pengembalian Anda?','Kami memberikan waktu 30 hari sejak tanggal pengiriman untuk mengembalikan produk yang tidak terpakai ke kondisi aslinya. Barang dan pakaian dalam yang didiskon bersifat final — tidak ada pengembalian.'),('id',6,'Bagaimana cara memulai pengembalian?','Lakukan pengembalian dari halaman manajemen akun Anda atau kirim email ke return@amerce.test dengan nomor pesanan Anda. Kami akan mengirimkan label pengiriman pengembalian prabayar untuk pesanan domestik.'),('id',7,'Kapan saya akan menerima pengembalian dana saya?','Pengembalian dana diproses dalam 3-5 hari kerja sejak kami menerima barang yang dikembalikan. Dana biasanya muncul di laporan Anda setelah 5-7 hari tambahan, tergantung banknya.'),('id',8,'Bagaimana cara menemukan ukuran yang tepat?','Setiap halaman produk memiliki tabel ukuran berdasarkan pengukuran produk sebenarnya. Jika Anda berada di antara dua ukuran, kami biasanya menyarankan memilih ukuran yang lebih besar untuk pakaian rajut dan mantel.'),('id',9,'Kapan barang yang terjual habis akan direstock?','Sebagian besar model diisi ulang dalam 2-4 minggu. Klik tombol Beritahu Saya pada variasi yang kehabisan stok untuk diberitahu melalui email ketika produk dikembalikan.'),('id',10,'Apakah produk Anda bersumber secara etis?','Memiliki. Kami hanya bekerja sama dengan mitra manufaktur yang memenuhi kode etik pemasok kami, termasuk upah yang adil, kondisi aman, dan asal bahan yang terverifikasi.'),('id',11,'Metode pembayaran apa yang Anda terima?','Kami menerima Visa, Mastercard, American Express, Apple Pay, Google Pay, PayPal, dan Klarna untuk pasar yang didukung.'),('id',12,'Apakah aman memasukkan detail kartu saya?','Semua pembayaran diproses oleh penyedia bersertifikat PCI-DSS Level 1 dengan enkripsi TLS 1.3. Kami tidak pernah menyimpan nomor kartu lengkap di server kami.'),('id',13,'Bagaimana cara mereset kata sandi saya?','Gunakan tautan Lupa Kata Sandi di halaman login. Tautan reset akan dikirimkan ke email Anda yang terdaftar dan berlaku selama 30 menit.'),('tr',1,'Standart gönderim ne kadar sürer?','Standart kargo, yurt içi siparişlerde 3-5 iş günü, yurt dışı siparişlerde ise 7-12 iş günü içerisinde ulaşır. Ödeme sırasında hızlandırılmış gönderim seçenekleri mevcuttur.'),('tr',2,'Ücretsiz kargo sunuyor musunuz?','Evet — 99$\'ın üzerindeki siparişler ABD kıtasında ücretsiz olarak gönderilir. Ücretsiz uluslararası gönderim eşiği varış noktasına göre değişir ve ödeme sırasında görüntülenir.'),('tr',3,'Siparişimi nasıl takip edebilirim?','Siparişiniz gönderilir gönderilmez e-posta yoluyla bir takip bağlantısı alacaksınız. Paketinizi ayrıca siparişlerim altındaki hesap yönetimi sayfanızdan da takip edebilirsiniz.'),('tr',4,'Siparişimi verdikten sonra teslimat adresini değiştirebilir miyim?','Siparişin işleme koyulmaması durumunda adres değiştirilebilir. Başarılı bir güncelleme şansı için siparişinizi verdikten sonraki iki saat içinde bizimle iletişime geçin.'),('tr',5,'İade politikanız nedir?','Kullanılmamış ürünü orijinal haliyle iade etmek için teslimat tarihinden itibaren 30 gün süre veriyoruz. İndirimli ürünler ve iç çamaşırları sondur; iade yoktur.'),('tr',6,'İade işlemini nasıl başlatabilirim?','Hesap yönetimi sayfanızdan bir iade işlemi başlatın veya sipariş numaranızla birlikte return@amerce.test adresine bir e-posta gönderin. Yurtiçi siparişlerde ön ödemeli iade nakliye etiketi göndereceğiz.'),('tr',7,'Geri ödememi ne zaman alacağım?','Geri ödemeler, iade edilen ürünün tarafımıza ulaşmasından itibaren 3-5 iş günü içerisinde gerçekleştirilir. Fonlar genellikle bankaya bağlı olarak ek 5-7 gün sonra ekstrenizde görünür.'),('tr',8,'Doğru boyutu nasıl bulurum?','Her ürün sayfasında gerçek ürün ölçülerine dayalı bir beden tablosu bulunur. Eğer iki beden arasında kaldıysanız triko ve kabanlarda genellikle büyük bedeni tercih etmenizi öneririz.'),('tr',9,'Tükenen ürünler ne zaman stoklara eklenecek?','Çoğu stil 2-4 hafta içinde yeniden stoklanır. Ürün iade edildiğinde e-postayla bilgilendirilmek için stokta olmayan herhangi bir varyasyonda Bana Bildir düğmesini tıklayın.'),('tr',10,'Ürünleriniz etik kurallara uygun mu?','Sahip olmak. Yalnızca adil ücretler, güvenli koşullar ve doğrulanmış malzeme menşeleri de dahil olmak üzere tedarikçi davranış kurallarımızı karşılayan üretim ortaklarıyla çalışıyoruz.'),('tr',11,'Hangi ödeme yöntemlerini kabul ediyorsunuz?','Desteklenen pazarlar için Visa, Mastercard, American Express, Apple Pay, Google Pay, PayPal ve Klarna\'yı kabul ediyoruz.'),('tr',12,'Kart bilgilerimi girmem güvenli mi?','Tüm ödemeler, TLS 1.3 şifrelemesine sahip PCI-DSS Seviye 1 sertifikalı bir sağlayıcı tarafından işlenir. Kart numaralarının tamamını hiçbir zaman sunucularımızda saklamayız.'),('tr',13,'Şifremi nasıl sıfırlarım?','Giriş sayfasındaki Şifremi Unuttum bağlantısını kullanın. Kayıtlı e-posta adresinize bir sıfırlama bağlantısı gönderilecek ve 30 dakika süreyle geçerlidir.'),('vi',1,'Vận chuyển tiêu chuẩn mất bao lâu?','Vận chuyển tiêu chuẩn đến trong vòng 3-5 ngày làm việc cho đơn hàng nội địa và 7-12 ngày làm việc cho điểm đến quốc tế. Lựa chọn vận chuyển nhanh có sẵn tại bước thanh toán.'),('vi',2,'Quý vị có hỗ trợ miễn phí vận chuyển không?','Có — đơn hàng trên 99$ được miễn phí vận chuyển trong khu vực Hoa Kỳ lục địa. Ngưỡng miễn phí vận chuyển quốc tế thay đổi theo điểm đến và được hiển thị tại bước thanh toán.'),('vi',3,'Làm thế nào để theo dõi đơn hàng?','Bạn sẽ nhận được liên kết theo dõi qua email ngay khi đơn hàng được gửi đi. Bạn cũng có thể theo dõi kiện hàng từ trang quản lý tài khoản trong mục Đơn hàng của tôi.'),('vi',4,'Tôi có thể đổi địa chỉ giao hàng sau khi đặt đơn không?','Có thể đổi địa chỉ nếu đơn hàng chưa được xử lý. Hãy liên hệ với chúng tôi trong vòng hai giờ kể từ khi đặt đơn để có cơ hội cập nhật thành công cao nhất.'),('vi',5,'Chính sách đổi trả của quý vị như thế nào?','Chúng tôi cho 30 ngày kể từ ngày giao hàng để trả lại bất kỳ sản phẩm nào chưa qua sử dụng trong tình trạng nguyên bản. Hàng giảm giá và đồ lót là hàng cuối — không đổi trả.'),('vi',6,'Làm thế nào để bắt đầu đổi trả?','Bắt đầu đổi trả từ trang quản lý tài khoản hoặc gửi email đến returns@amerce.test cùng số đơn hàng. Chúng tôi sẽ gửi nhãn vận chuyển trả hàng trả phí trước cho đơn hàng nội địa.'),('vi',7,'Khi nào tôi nhận được tiền hoàn lại?','Tiền hoàn được xử lý trong vòng 3-5 ngày làm việc kể từ khi chúng tôi nhận được hàng trả. Tiền thường xuất hiện trong sao kê của bạn sau thêm 5-7 ngày tùy ngân hàng.'),('vi',8,'Làm thế nào để tìm đúng kích cỡ?','Mỗi trang sản phẩm có bảng kích cỡ dựa trên số đo thực tế của sản phẩm. Nếu bạn ở giữa hai size, chúng tôi thường khuyên chọn size lớn hơn cho đồ dệt kim và áo khoác.'),('vi',9,'Khi nào sản phẩm hết hàng được nhập lại?','Hầu hết các kiểu được nhập lại trong vòng 2-4 tuần. Bấm nút Thông báo cho tôi trên bất kỳ biến thể nào hết hàng để được thông báo qua email khi sản phẩm trở lại.'),('vi',10,'Sản phẩm của quý vị có nguồn cung có đạo đức không?','Có. Chúng tôi chỉ làm việc với các đối tác sản xuất đáp ứng quy tắc ứng xử nhà cung cấp, bao gồm lương công bằng, điều kiện an toàn và nguồn gốc vật liệu được xác minh.'),('vi',11,'Quý vị chấp nhận những phương thức thanh toán nào?','Chúng tôi chấp nhận Visa, Mastercard, American Express, Apple Pay, Google Pay, PayPal và Klarna cho các thị trường được hỗ trợ.'),('vi',12,'Nhập thông tin thẻ có an toàn không?','Mọi thanh toán đều được xử lý bởi nhà cung cấp được chứng nhận PCI-DSS Level 1 với mã hóa TLS 1.3. Chúng tôi không bao giờ lưu trữ số thẻ đầy đủ trên máy chủ.'),('vi',13,'Làm thế nào để đặt lại mật khẩu?','Sử dụng liên kết Quên mật khẩu trên trang đăng nhập. Một liên kết đặt lại sẽ được gửi đến email đăng ký của bạn và có hiệu lực trong 30 phút.');

--
-- Table structure for table `fob_product_size_guide_relations`
--

CREATE TABLE `fob_product_size_guide_relations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `size_guide_id` bigint unsigned NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `reference_type` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fob_psg_relations_size_guide_id_idx` (`size_guide_id`),
  KEY `fob_psg_relations_ref_idx` (`reference_id`,`reference_type`),
  CONSTRAINT `fob_product_size_guide_relations_size_guide_id_foreign` FOREIGN KEY (`size_guide_id`) REFERENCES `fob_product_size_guides` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fob_product_size_guide_relations`
--

