--
-- 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,'fv04VzQw3ljBfcOhnjuWE2UpFPGQHaMe',1,'2026-05-28 18:58:28','2026-05-28 18:58:28','2026-05-28 18:58:28');

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

CREATE TABLE `ads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expired_at` datetime DEFAULT NULL,
  `location` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `key` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clicked` bigint NOT NULL DEFAULT '0',
  `order` int DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `open_in_new_tab` tinyint(1) NOT NULL DEFAULT '1',
  `tablet_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ads_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `google_adsense_slot_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ads_key_unique` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` bigint NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache`
--


--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` bigint NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache_locks`
--


--
-- 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,'Maintenance',0,'Service intervals, fluids, and routine care that keep your vehicle running.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2026-05-28 18:58:29','2026-05-28 18:58:29'),(2,'Performance',0,'Power upgrades, tuning, and drive-feel modifications backed by data.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 18:58:29','2026-05-28 18:58:29'),(3,'DIY Repair',0,'Step-by-step guides for at-home repairs and weekend wrenching projects.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 18:58:29','2026-05-28 18:58:29'),(4,'Buying Guides',0,'OEM versus aftermarket, trim comparisons, and upgrade decisions explained.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 18:58:29','2026-05-28 18:58:29'),(5,'Detailing',0,'Wash, polish, and protect — keep your ride looking factory-fresh.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 18:58:29','2026-05-28 18:58:29');

--
-- 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,'أداء','ترقيات الطاقة والضبط وتحسينات القيادة المستندة إلى البيانات.'),('ar',3,'إصلاح DIY','تعليمات خطوة بخطوة لإصلاحات المنزل ومشاريع نهاية الأسبوع.'),('ar',4,'أدلة الشراء','يساعدك دليل المقارنة المستقل على اختيار المنتج المناسب لاحتياجاتك وميزانيتك.'),('ar',5,'تفصيل','اغسل وصقل واحمي - حافظ على مظهر سيارتك وكأنها جديدة من المصنع.'),('fr',1,'Entretien','Un entretien régulier, des solutions et des programmes d\'entretien contribuent au bon fonctionnement de votre voiture.'),('fr',2,'Performance','Mises à niveau de puissance, réglages et améliorations de la conduite basées sur les données.'),('fr',3,'Réparation DIY','Instructions étape par étape pour les réparations à domicile et les projets du week-end.'),('fr',4,'Guides d\'achat','Un guide de comparaison indépendant vous aide à choisir le produit adapté à vos besoins et à votre budget.'),('fr',5,'Détails','Lavez, polissez et protégez – gardez votre voiture comme neuve dès sa sortie d’usine.'),('id',1,'Pemeliharaan','Perawatan rutin, solusi dan jadwal perawatan membantu menjaga mobil Anda tetap berjalan dengan baik.'),('id',2,'Pertunjukan','Peningkatan daya, penyetelan, dan peningkatan berkendara berbasis data.'),('id',3,'Perbaikan DIY','Petunjuk langkah demi langkah untuk perbaikan rumah dan proyek akhir pekan.'),('id',4,'Panduan Membeli','Panduan perbandingan independen membantu Anda memilih produk yang tepat sesuai kebutuhan dan anggaran Anda.'),('id',5,'Merinci','Cuci, poles, dan lindungi — jaga mobil Anda tampak seperti baru dari pabrik.'),('tr',1,'Bakım','Düzenli bakım, çözümler ve bakım programları arabanızın iyi çalışmasına yardımcı olur.'),('tr',2,'Performans','Güç yükseltmeleri, ayarlamalar ve veriye dayalı sürüş iyileştirmeleri.'),('tr',3,'Kendin Yap Onarımı','Ev onarımları ve hafta sonu projeleri için adım adım talimatlar.'),('tr',4,'Satın Alma Kılavuzları','Bağımsız karşılaştırma kılavuzu ihtiyaçlarınıza ve bütçenize uygun doğru ürünü seçmenize yardımcı olur.'),('tr',5,'Detaylandırma','Yıkayın, cilalayın ve koruyun; arabanızın fabrikadan yeni çıkmış gibi görünmesini sağlayın.'),('vi',1,'Bảo Dưỡng','Lịch bảo dưỡng, dung dịch và chăm sóc định kỳ giúp xe của bạn luôn vận hành tốt.'),('vi',2,'Hiệu Năng','Nâng cấp sức mạnh, tinh chỉnh và các cải tiến cảm giác lái dựa trên dữ liệu.'),('vi',3,'Tự Sửa Chữa','Hướng dẫn từng bước cho việc sửa chữa tại nhà và các dự án cuối tuần.'),('vi',4,'Hướng dẫn mua sắm','Hướng dẫn so sánh độc lập giúp bạn chọn sản phẩm phù hợp với nhu cầu và ngân sách.'),('vi',5,'Chăm Sóc Chi Tiết','Rửa, đánh bóng và bảo vệ — giữ chiếc xe của bạn luôn như mới xuất xưởng.');

--
-- 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 18:58:28','2026-05-28 18:58:28'),(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 18:58:28','2026-05-28 18:58:28'),(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 18:58:28','2026-05-28 18:58:28');

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

CREATE TABLE `device_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `platform` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `app_version` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `device_tokens_token_unique` (`token`),
  KEY `device_tokens_user_type_user_id_index` (`user_type`,`user_id`),
  KEY `device_tokens_platform_is_active_index` (`platform`,`is_active`),
  KEY `device_tokens_is_active_index` (`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `device_tokens`
--


--
-- Table structure for table `ec_abandoned_carts`
--

CREATE TABLE `ec_abandoned_carts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint unsigned DEFAULT NULL,
  `session_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cart_data` json NOT NULL,
  `total_amount` decimal(15,2) NOT NULL DEFAULT '0.00',
  `items_count` int NOT NULL DEFAULT '0',
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abandoned_at` timestamp NULL DEFAULT NULL,
  `reminder_sent_at` timestamp NULL DEFAULT NULL,
  `reminders_sent` int NOT NULL DEFAULT '0',
  `last_email_sequence` tinyint unsigned NOT NULL DEFAULT '0',
  `recovery_token` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coupon_code` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clicked_at` timestamp NULL DEFAULT NULL,
  `unsubscribe_token` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unsubscribed_at` timestamp NULL DEFAULT NULL,
  `is_recovered` tinyint(1) NOT NULL DEFAULT '0',
  `recovered_at` timestamp NULL DEFAULT NULL,
  `recovered_order_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_abandoned_carts_recovery_token_unique` (`recovery_token`),
  UNIQUE KEY `ec_abandoned_carts_unsubscribe_token_unique` (`unsubscribe_token`),
  KEY `ec_abandoned_carts_abandoned_at_is_recovered_index` (`abandoned_at`,`is_recovered`),
  KEY `ec_abandoned_carts_created_at_is_recovered_index` (`created_at`,`is_recovered`),
  KEY `ec_abandoned_carts_customer_id_index` (`customer_id`),
  KEY `ec_abandoned_carts_session_id_index` (`session_id`),
  KEY `ec_abandoned_carts_email_index` (`email`),
  KEY `ec_abandoned_carts_recovered_order_id_index` (`recovered_order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_abandoned_carts`
--


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

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

INSERT INTO `ec_brands` VALUES (1,'Anthro','Eclectic apparel and home goods inspired by global craftsmanship traditions.','https://example.com/anthro','brands/anthro.png','published',0,1,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(2,'Anvouge','Modern fashion essentials cut from sustainable fibers.','https://example.com/anvouge','brands/anvouge.png','published',1,1,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(3,'Bohome','Bohemian-inspired homewares and textiles for the relaxed modern home.','https://example.com/bohome','brands/bohome.png','published',2,1,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(4,'Carolin','Demi-fine jewelry made by hand in small Italian ateliers.','https://example.com/carolin','brands/carolin.png','published',3,1,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(5,'Cheryl','Bold prints and silhouettes for the contemporary woman.','https://example.com/cheryl','brands/cheryl.png','published',4,0,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(6,'Crate','Mid-century-inspired furniture built to last generations.','https://example.com/crate','brands/crate.png','published',5,1,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(7,'Findr','Audio gear engineered for studio-grade clarity in everyday environments.','https://example.com/findr','brands/findr.png','published',6,0,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(8,'Intdeco','Interior accents that bridge minimalism and warmth.','https://example.com/intdeco','brands/intdeco.png','published',7,0,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(9,'Modave','Performance activewear made with recycled high-stretch knits.','https://example.com/modave','brands/modave.png','published',8,0,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(10,'Panadoxn','Botanical skincare formulated by clinical herbalists.','https://example.com/panadoxn','brands/panadoxn.png','published',9,0,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(11,'Shangxi','Heritage tea, ceramics, and meditation accessories.','https://example.com/shangxi','brands/shangxi.png','published',10,0,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(12,'Sopify','Smart home devices designed for renters and travelers.','https://example.com/sopify','brands/sopify.png','published',11,0,'2026-05-28 18:58:28','2026-05-28 18:58:28');

--
-- 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,'شيريل','أنماط وأشكال متميزة للمرأة العصرية.'),('ar',6,'قفص','تم تصميم الأثاث المستوحى من منتصف القرن ليدوم لأجيال.'),('ar',7,'مكتشف','معدات صوتية مصممة لتحقيق وضوح بجودة الاستوديو في البيئات اليومية.'),('ar',8,'انتديكو','تجمع المزايا الداخلية بين البساطة والراحة.'),('ar',9,'موداف','معدات تدريب عالية الأداء مصنوعة من نسيج مطاطي مُعاد تدويره.'),('ar',10,'بانادوكسن','مستحضرات التجميل الطبيعية التي بحثها خبراء الأعشاب السريرية.'),('ar',11,'شانغشى','الشاي التراثي والسيراميك وإكسسوارات التأمل.'),('ar',12,'سوبيفاي','أجهزة منزلية ذكية مصممة للمستأجرين والزوار.'),('fr',1,'Anthro','Vêtements et articles pour la maison multi-styles inspirés des traditions artisanales mondiales.'),('fr',2,'Anvouge','Des essentiels de la mode moderne coupés à partir de fibres durables.'),('fr',3,'Bohème','Articles de maison et textiles d\'inspiration bohème pour une maison moderne et décontractée.'),('fr',4,'Caroline','Les bijoux demi-fins sont fabriqués à la main dans de petits ateliers en Italie.'),('fr',5,'Cheryl','Des motifs et des formes exceptionnels pour les femmes modernes.'),('fr',6,'Caisse','Les meubles inspirés du milieu du siècle sont conçus pour durer des générations.'),('fr',7,'Trouver','Équipement audio conçu pour une clarté de qualité studio dans les environnements quotidiens.'),('fr',8,'Intdéco','Les points forts de l\'intérieur allient minimalisme et confort.'),('fr',9,'Modave','Équipement d\'entraînement haute performance fabriqué à partir de tissu extensible recyclé.'),('fr',10,'Panadoxn','Cosmétiques naturels recherchés par des experts cliniques en plantes médicinales.'),('fr',11,'Shangxi','Thé du patrimoine, céramiques et accessoires de méditation.'),('fr',12,'Sopifier','Appareils domestiques intelligents conçus pour les locataires et les visiteurs.'),('id',1,'Antro','Pakaian dan peralatan rumah tangga multi-gaya yang terinspirasi oleh tradisi kerajinan global.'),('id',2,'Anvouge','Perlengkapan fesyen modern yang dipotong dari serat ramah lingkungan.'),('id',3,'Bohome','Peralatan rumah tangga dan tekstil yang terinspirasi bohemian untuk rumah modern yang santai.'),('id',4,'Karolina','Perhiasan demi-fine dibuat dengan tangan di bengkel-bengkel kecil di Italia.'),('id',5,'Cheryl','Pola dan bentuk luar biasa untuk wanita modern.'),('id',6,'Peti','Furnitur yang terinspirasi abad pertengahan dibuat untuk bertahan selama beberapa generasi.'),('id',7,'Temukan','Perlengkapan audio dirancang untuk kejernihan kualitas studio di lingkungan sehari-hari.'),('id',8,'Intdeco','Sorotan interior memadukan minimalis dan kenyamanan.'),('id',9,'Modifikasi','Perlengkapan latihan berperforma tinggi yang terbuat dari kain stretch daur ulang.'),('id',10,'Panadoxn','Kosmetik alami yang diteliti oleh para ahli herbal klinis.'),('id',11,'Shangxi','Teh warisan, keramik, dan aksesoris meditasi.'),('id',12,'Sopify','Perangkat rumah pintar yang dirancang untuk penyewa dan pengunjung.'),('tr',1,'Antropo','Küresel zanaat geleneklerinden ilham alan çok stilde giysiler ve ev eşyaları.'),('tr',2,'Anvouge','Sürdürülebilir elyaflardan kesilmiş modern moda temelleri.'),('tr',3,'Bohome','Rahat ve modern ev için bohem esintili ev eşyaları ve tekstil ürünleri.'),('tr',4,'Carolin','Yarı kaliteli takılar İtalya\'daki küçük atölyelerde el yapımıdır.'),('tr',5,'Cheryl','Modern kadınlar için olağanüstü desenler ve şekiller.'),('tr',6,'Sandık','Yüzyılın ortasından ilham alan mobilyalar nesiller boyu dayanacak şekilde tasarlandı.'),('tr',7,'Bulucu','Günlük ortamlarda stüdyo kalitesinde netlik için tasarlanmış ses ekipmanı.'),('tr',8,'Indeco','İç mekandaki vurgular minimalizm ve rahatlığı birleştiriyor.'),('tr',9,'modave','Geri dönüştürülmüş esnek kumaştan yapılmış yüksek performanslı antrenman ekipmanı.'),('tr',10,'Panadoxn','Klinik bitkisel uzmanlar tarafından araştırılan doğal kozmetikler.'),('tr',11,'Şangxi','Miras çay, seramik ve meditasyon aksesuarları.'),('tr',12,'sopify','Kiracılar ve ziyaretçiler için tasarlanmış akıllı ev cihazları.'),('vi',1,'Anthro','Trang phục và đồ gia dụng đa phong cách lấy cảm hứng từ truyền thống thủ công toàn cầu.'),('vi',2,'Anvouge','Đồ thời trang thiết yếu hiện đại được cắt may từ sợi bền vững.'),('vi',3,'Bohome','Đồ gia dụng và dệt may cảm hứng bohemian cho ngôi nhà hiện đại thư thái.'),('vi',4,'Carolin','Trang sức demi-fine làm thủ công tại các xưởng nhỏ ở Ý.'),('vi',5,'Cheryl','Họa tiết và phom dáng nổi bật dành cho phụ nữ hiện đại.'),('vi',6,'Crate','Nội thất cảm hứng mid-century được chế tác bền vững qua nhiều thế hệ.'),('vi',7,'Findr','Thiết bị âm thanh thiết kế cho độ rõ chuẩn studio trong môi trường thường ngày.'),('vi',8,'Intdeco','Điểm nhấn nội thất kết hợp giữa tối giản và ấm cúng.'),('vi',9,'Modave','Đồ tập hiệu năng cao làm từ vải thun co giãn tái chế.'),('vi',10,'Panadoxn','Mỹ phẩm thiên nhiên được nghiên cứu bởi các chuyên gia thảo dược lâm sàng.'),('vi',11,'Shangxi','Trà di sản, gốm sứ và phụ kiện thiền.'),('vi',12,'Sopify','Thiết bị nhà thông minh thiết kế dành cho người thuê nhà và du khách.');

--
-- 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 18:58:28','2026-05-28 18:58:28'),(2,'EUR','€',0,2,'western',0,1,0,0.84,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(3,'VND','₫',0,0,'western',0,2,0,23203,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(4,'NGN','₦',1,2,'western',0,2,0,895.52,'2026-05-28 18:58:28','2026-05-28 18:58:28');

--
-- 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-0109','AU','Michigan','Phoenix','369 Cherry Circle',1,1,'2026-05-28 18:58:38','2026-05-28 18:58:38','30301'),(2,'Emma Collins','customer@botble.com','+1-555-0108','CA','Michigan','Dallas','789 Pine Road',1,0,'2026-05-28 18:58:38','2026-05-28 18:58:38','33101'),(3,'Sophia Ramirez','vendor@botble.com','+1-555-0109','CA','Arizona','Denver','789 Pine Road',2,1,'2026-05-28 18:58:38','2026-05-28 18:58:38','90210'),(4,'Sophia Ramirez','vendor@botble.com','+1-555-0101','GB','Texas','Chicago','654 Cedar Lane',2,0,'2026-05-28 18:58:38','2026-05-28 18:58:38','30301'),(5,'Olivia Carter','customer1@example.com','+1-555-0108','GB','Georgia','Los Angeles','789 Pine Road',3,1,'2026-05-28 18:58:38','2026-05-28 18:58:38','30301'),(6,'Ava Mitchell','customer2@example.com','+1-555-0108','CA','Michigan','Denver','456 Oak Avenue',4,1,'2026-05-28 18:58:39','2026-05-28 18:58:39','90210'),(7,'Isabella Brooks','customer3@example.com','+1-555-0101','CA','California','Miami','741 Spruce Street',5,1,'2026-05-28 18:58:39','2026-05-28 18:58:39','85001'),(8,'James Whitfield','customer4@example.com','+1-555-0102','GB','California','Austin','741 Spruce Street',6,1,'2026-05-28 18:58:39','2026-05-28 18:58:39','80201'),(9,'Liam Bennett','customer5@example.com','+1-555-0110','US','Pennsylvania','New York','789 Pine Road',7,1,'2026-05-28 18:58:39','2026-05-28 18:58:39','80201'),(10,'Noah Patterson','customer6@example.com','+1-555-0104','AU','Pennsylvania','Denver','258 Walnut Way',8,1,'2026-05-28 18:58:39','2026-05-28 18:58:39','19101'),(11,'Charlotte Reed','customer7@example.com','+1-555-0106','CA','Arizona','Phoenix','147 Elm Court',9,1,'2026-05-28 18:58:40','2026-05-28 18:58:40','33101'),(12,'Amelia Foster','customer8@example.com','+1-555-0106','CA','Pennsylvania','San Diego','123 Main Street',10,1,'2026-05-28 18:58:40','2026-05-28 18:58:40','33101');

--
-- Table structure for table `ec_customer_deletion_requests`
--

CREATE TABLE `ec_customer_deletion_requests` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint unsigned NOT NULL,
  `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `verification_code` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code_expires_at` timestamp NULL DEFAULT NULL,
  `status` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'waiting_for_confirmation',
  `reason` text COLLATE utf8mb4_unicode_ci,
  `confirmed_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_customer_deletion_requests_token_unique` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_customer_deletion_requests`
--


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

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

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


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

CREATE TABLE `ec_customer_recently_viewed_products` (
  `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_customers`
--

CREATE TABLE `ec_customers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `tax_class` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'regular',
  `tax_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `confirmed_at` datetime DEFAULT NULL,
  `email_verify_token` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_vendor` tinyint(1) NOT NULL DEFAULT '0',
  `vendor_verified_at` datetime DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'activated',
  `block_reason` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `private_notes` text COLLATE utf8mb4_unicode_ci,
  `stripe_account_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stripe_account_active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `ec_customers_is_vendor_index` (`is_vendor`),
  KEY `ec_customers_vendor_verified_at_index` (`vendor_verified_at`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_customers` VALUES (1,'Emma Collins','customer@botble.com','$2y$12$5cOVoX5WmmzTzfpvSk9tCeV67/kwJ6j3nfB4DnxRSKUSo9NBebUIu','testimonials/avatar-1.jpg','1981-05-23','regular',NULL,'+1-555-0101',NULL,'2026-05-28 18:58:38','2026-05-28 18:58:38','2026-05-29 01:58:38',NULL,0,NULL,'activated',NULL,NULL,NULL,0),(2,'Sophia Ramirez','vendor@botble.com','$2y$12$sh7KCI6YP3ZGqPaCz40.gufpUP8NwRzuFWXNHuqccTpjHHiETiYRm','testimonials/avatar-2.jpg','1982-05-21','regular',NULL,'+1-555-0102',NULL,'2026-05-28 18:58:38','2026-05-28 18:58:40','2026-05-29 01:58:38',NULL,1,'2026-05-29 01:58:40','activated',NULL,NULL,NULL,0),(3,'Olivia Carter','customer1@example.com','$2y$12$jgCP65EoLhO0Vf8KEbu8/..bGBMOXEZsg1pxLayIvtubhH0RNPGAO','testimonials/avatar-3.jpg','1994-05-24','regular',NULL,'+1-555-0108',NULL,'2026-05-28 18:58:38','2026-05-28 18:58:41','2026-05-29 01:58:38',NULL,1,'2026-05-29 01:58:40','activated',NULL,NULL,NULL,0),(4,'Ava Mitchell','customer2@example.com','$2y$12$N9TuMtCAnSw04vUK.eyRPe4no4w2lJWOahqxm/XqGSDRGO9nUNI7K','testimonials/avatar-4.jpg','1993-05-14','regular',NULL,'+1-555-0101',NULL,'2026-05-28 18:58:39','2026-05-28 18:58:41','2026-05-29 01:58:38',NULL,1,'2026-05-29 01:58:40','activated',NULL,NULL,NULL,0),(5,'Isabella Brooks','customer3@example.com','$2y$12$14l/4WaOPVOdDjS49jcToO1gbYHLFmecI4M3.RkLNKqalb7A8TrZ6','testimonials/avatar-5.jpg','1983-05-11','regular',NULL,'+1-555-0104',NULL,'2026-05-28 18:58:39','2026-05-28 18:58:41','2026-05-29 01:58:38',NULL,1,'2026-05-29 01:58:40','activated',NULL,NULL,NULL,0),(6,'James Whitfield','customer4@example.com','$2y$12$eMfTIG6ZCOUJ/8qb5YvhZ.uF5yCGQBtw.wn/clMdoMLHC3YLppdga','testimonials/avatar-6.jpg','1981-05-02','regular',NULL,'+1-555-0108',NULL,'2026-05-28 18:58:39','2026-05-28 18:58:41','2026-05-29 01:58:38',NULL,1,'2026-05-29 01:58:40','activated',NULL,NULL,NULL,0),(7,'Liam Bennett','customer5@example.com','$2y$12$8vgvCipxybJ2shXVKiuK/.pcd9BU28C2R4GY5lnkOIuayb9Vsxg1a','testimonials/avatar-7.jpg','1996-05-19','regular',NULL,'+1-555-0102',NULL,'2026-05-28 18:58:39','2026-05-28 18:58:41','2026-05-29 01:58:38',NULL,1,'2026-05-29 01:58:40','activated',NULL,NULL,NULL,0),(8,'Noah Patterson','customer6@example.com','$2y$12$xbaKZiaIz3auNMlMzma4xenshEPg7llNicjppFbfTr5DLNMLig/46','testimonials/avatar-8.jpg','1979-05-10','regular',NULL,'+1-555-0106',NULL,'2026-05-28 18:58:39','2026-05-28 18:58:42','2026-05-29 01:58:38',NULL,1,'2026-05-29 01:58:40','activated',NULL,NULL,NULL,0),(9,'Charlotte Reed','customer7@example.com','$2y$12$sdfVhBkWrz1U9vG50rt2puCUzzLEgfcbWDMZXEJYUrMbeD6UPpke.','testimonials/avatar-9.jpg','1999-05-24','regular',NULL,'+1-555-0103',NULL,'2026-05-28 18:58:40','2026-05-28 18:58:42','2026-05-29 01:58:38',NULL,1,'2026-05-29 01:58:40','activated',NULL,NULL,NULL,0),(10,'Amelia Foster','customer8@example.com','$2y$12$ewGYYwCxJevvSR6wYQjZmOajz72ACwT8isKMxVfrQE.jCeDIkMA7q','testimonials/avatar-10.jpg','1998-05-19','regular',NULL,'+1-555-0102',NULL,'2026-05-28 18:58:40','2026-05-28 18:58:42','2026-05-29 01:58:38',NULL,0,NULL,'activated',NULL,NULL,NULL,0);

--
-- 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 01:58:40','2026-07-28 01:58:40',NULL,0,10,'coupon',0,0,NULL,NULL,'percentage','all-orders',0.00,0,1,'2026-05-28 18:58:40','2026-05-28 18:58:40',NULL,'A welcome discount for first-time shoppers — 10% off any order.'),(2,'Free Shipping Over $50','FREESHIP','2026-05-28 01:58:40',NULL,NULL,0,100,'coupon',0,0,NULL,NULL,'shipping','all-orders',50.00,0,1,'2026-05-28 18:58:40','2026-05-28 18:58:40',NULL,'Free shipping on any order $50 or above.'),(3,'Spring Sale — $25 Off','SPRING25','2026-05-28 01:58:40','2026-06-28 01:58:40',500,0,25,'coupon',0,0,NULL,NULL,'amount','all-orders',150.00,0,1,'2026-05-28 18:58:40','2026-05-28 18:58:40',NULL,'A flat $25 off orders over $150.'),(4,'VIP Member 20% Off','VIP20','2026-05-28 01:58:40','2026-08-27 01:58:40',NULL,0,20,'coupon',0,0,NULL,NULL,'percentage','all-orders',100.00,0,1,'2026-05-28 18:58:40','2026-05-28 18:58:40',NULL,'Exclusive 20% off for newsletter subscribers.'),(5,'Bundle & Save $50','BUNDLE50','2026-05-28 01:58:40','2026-07-13 01:58:40',NULL,0,50,'coupon',0,0,NULL,NULL,'amount','all-orders',300.00,0,1,'2026-05-28 18:58:40','2026-05-28 18:58:40',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,10,153.3,50,0),(1,2,209.3,50,0),(1,8,62.3,50,0),(1,9,90.3,50,0),(1,1,139.3,50,0),(1,5,55.3,50,0),(1,7,20.3,50,0),(1,4,188.3,50,0),(1,6,24.5,50,0),(2,5,59.25,75,0),(2,7,21.75,75,0),(2,9,96.75,75,0),(2,1,149.25,75,0),(2,8,66.75,75,0),(2,4,201.75,75,0),(2,6,26.25,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 01:58:40','published','2026-05-28 18:58:40','2026-05-28 18:58:40'),(2,'Weekend Doorbusters','2026-06-03 01:58:40','published','2026-05-28 18:58:40','2026-05-28 18:58:40');

--
-- 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 18:58:28','2026-05-28 18:58:28'),(2,1,'Standard kraft wrap',4.99,1,0,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(3,1,'Premium silk-ribbon wrap',9.99,2,0,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(4,2,'Up to 20 characters',14.99,0,0,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(5,3,'Standard 1-year warranty',0,0,0,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(6,3,'2-year extended warranty',29.99,1,0,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(7,3,'3-year premium care',59.99,2,0,'2026-05-28 18:58:28','2026-05-28 18:58:28');

--
-- 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 18:58:28','2026-05-28 18:58:28'),(2,'Engraving','Botble\\Ecommerce\\Option\\OptionType\\Field',0,0,'2026-05-28 18:58:28','2026-05-28 18:58:28'),(3,'Extended Warranty','Botble\\Ecommerce\\Option\\OptionType\\RadioButton',0,0,'2026-05-28 18:58:28','2026-05-28 18:58:28');

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

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

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


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

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

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

INSERT INTO `ec_product_categories` VALUES (1,'Brake Pads',NULL,0,'Premium ceramic and semi-metallic brake pads for confident stopping power.','published',0,'categories/cate-21.jpg',1,'2026-05-28 18:58:30','2026-05-28 18:58:30',NULL,NULL),(2,'Air Filters',NULL,0,'Performance and OEM-grade engine air filters for cleaner intake and efficiency.','published',1,'categories/cate-22.jpg',1,'2026-05-28 18:58:30','2026-05-28 18:58:30',NULL,NULL),(3,'Brake Rotors',NULL,0,'Vented and slotted brake discs engineered for heat dissipation and durability.','published',2,'categories/cate-23.jpg',1,'2026-05-28 18:58:30','2026-05-28 18:58:30',NULL,NULL),(4,'Brake Hydraulics',NULL,0,'Power steering pumps, master cylinders, and hydraulic components built to last.','published',3,'categories/cate-24.jpg',1,'2026-05-28 18:58:31','2026-05-28 18:58:31',NULL,NULL),(5,'Oil Filters',NULL,0,'High-flow oil filtration for extended engine life and peak performance.','published',4,'categories/cate-25.jpg',1,'2026-05-28 18:58:31','2026-05-28 18:58:31',NULL,NULL),(6,'Lighting',NULL,0,'LED bulbs, projector headlights, and accessory lighting for visibility and style.','published',5,'categories/cate-26.jpg',1,'2026-05-28 18:58:31','2026-05-28 18:58:31',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,'فلتر هواء المحرك عالي الأداء ومعايير OEM لتدفق هواء السحب أنظف وأكثر اقتصاداً.'),('ar',3,'دوارات الفرامل',NULL,'تم تصميم أقراص الفرامل المهواة والمشقوقة لتبديد الحرارة ولتكون متينة.'),('ar',4,'هيدروليكا الفرامل',NULL,'تم تصميم مضخة التوجيه المعزز والأسطوانة الرئيسية والمكونات الهيدروليكية لتدوم طويلاً.'),('ar',5,'مرشحات الزيت',NULL,'يساعد فلتر الزيت عالي التدفق على إطالة عمر المحرك وتحقيق الأداء الأمثل.'),('ar',6,'إضاءة',NULL,'مصابيح LED ومصابيح أمامية لجهاز العرض وأضواء ملحقة للرؤية والأناقة.'),('fr',1,'Plaquettes de frein',NULL,'Les plaquettes de frein en céramique et semi-métalliques de qualité supérieure offrent une puissance de freinage forte et sûre.'),('fr',2,'Filtres à air',NULL,'Filtre à air moteur haute performance et normes OEM pour un débit d\'air d\'admission plus propre et plus économique.'),('fr',3,'Disques de frein',NULL,'Les disques de frein ventilés et fendus sont conçus pour dissiper la chaleur et être durables.'),('fr',4,'Circuit hydraulique de freinage',NULL,'La pompe de direction assistée, le maître-cylindre et les composants hydrauliques sont construits pour durer.'),('fr',5,'Filtres à huile',NULL,'Le filtre à huile à haut débit contribue à prolonger la durée de vie du moteur et à obtenir des performances optimales.'),('fr',6,'Éclairage',NULL,'Ampoules LED, phares de projecteur et éclairages accessoires pour la visibilité et le style.'),('id',1,'Bantalan Rem',NULL,'Bantalan rem keramik dan semi-logam premium memberikan daya pengereman yang kuat dan percaya diri.'),('id',2,'Filter Udara',NULL,'Filter udara mesin berkinerja tinggi dan standar OEM untuk aliran udara masuk yang lebih bersih dan ekonomis.'),('id',3,'Rotor Rem',NULL,'Rem cakram berventilasi dan berlubang dirancang untuk menghilangkan panas dan tahan lama.'),('id',4,'Hidrolik Rem',NULL,'Pompa power steering, master silinder, dan komponen hidrolik dibuat agar tahan lama.'),('id',5,'Filter Oli',NULL,'Filter oli aliran tinggi membantu memperpanjang umur mesin dan mencapai kinerja optimal.'),('id',6,'Penerangan',NULL,'Bohlam LED, lampu depan proyektor, dan lampu aksesori untuk visibilitas dan gaya.'),('tr',1,'Fren Balataları',NULL,'Birinci sınıf seramik ve yarı metalik fren balataları güçlü, güvenli frenleme gücü sağlar.'),('tr',2,'Hava Filtreleri',NULL,'Daha temiz ve daha ekonomik emme havası akışı için yüksek performanslı motor hava filtresi ve OEM standartları.'),('tr',3,'Fren Rotorları',NULL,'Havalandırmalı ve oluklu fren diskleri ısıyı dağıtacak ve dayanıklı olacak şekilde tasarlanmıştır.'),('tr',4,'Fren Hidroliği',NULL,'Servo direksiyon pompası, ana silindir ve hidrolik bileşenler uzun süre dayanacak şekilde üretilmiştir.'),('tr',5,'Yağ Filtreleri',NULL,'Yüksek akışlı yağ filtresi, motor ömrünün uzatılmasına ve optimum performansın elde edilmesine yardımcı olur.'),('tr',6,'Aydınlatma',NULL,'Görünürlük ve stil için LED ampuller, projektör farları ve aksesuar ışıkları.'),('vi',1,'Má Phanh',NULL,'Má phanh gốm và bán kim loại cao cấp cho lực phanh chắc chắn, tự tin.'),('vi',2,'Lọc Gió',NULL,'Lọc gió động cơ hiệu năng cao và đạt chuẩn OEM cho luồng khí nạp sạch hơn và tiết kiệm hơn.'),('vi',3,'Đĩa Phanh',NULL,'Đĩa phanh thông gió và xẻ rãnh được thiết kế để tản nhiệt và bền bỉ.'),('vi',4,'Hệ Thủy Lực Phanh',NULL,'Bơm trợ lực lái, xy-lanh chính và các bộ phận thủy lực được chế tạo để bền lâu.'),('vi',5,'Lọc Dầu',NULL,'Lọc dầu lưu lượng cao giúp kéo dài tuổi thọ động cơ và đạt hiệu năng tối ưu.'),('vi',6,'Hệ Thống Đèn',NULL,'Bóng LED, đèn pha projector và đèn phụ kiện cho tầm nhìn và phong cách.');

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

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

--
-- 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,'Performance Parts','performance-parts','High-performance upgrades engineered for power and precision on every road.','collection/cls-1.jpg','published','2026-05-28 18:58:31','2026-05-28 18:58:31',1),(2,'Engine &amp; Drivetrain','engine-drivetrain','Pistons, belts, and gaskets — OEM-grade essentials for every powertrain.','collection/cls-10.jpg','published','2026-05-28 18:58:31','2026-05-28 18:58:31',1),(3,'Suspension &amp; Brakes','suspension-brakes','Shocks, struts, rotors, and pads to keep every drive smooth and safe.','collection/cls-11.jpg','published','2026-05-28 18:58:31','2026-05-28 18:58:31',1),(4,'Tires &amp; Wheels','tires-wheels','Track-tested tires and alloy wheels built for grip, balance, and style.','collection/cls-12.jpg','published','2026-05-28 18:58:31','2026-05-28 18:58:31',1),(5,'Lighting &amp; Electrical','lighting-electrical','LED headlights, fog kits, and harnesses for visibility and reliability.','collection/cls-13.jpg','published','2026-05-28 18:58:31','2026-05-28 18:58:31',0),(6,'Tools &amp; Garage','tools-garage','Repair kits, lifts, and tool sets for every wrench-day in your garage.','collection/cls-14.jpg','published','2026-05-28 18:58:31','2026-05-28 18:58:31',0),(7,'Interior &amp; Comfort','interior-comfort','Seat covers, mats, and accessories to refine every mile inside the cabin.','collection/cls-15.jpg','published','2026-05-28 18:58:32','2026-05-28 18:58:32',0),(8,'Body &amp; Exterior','body-exterior','Spoilers, bumpers, and protective film for a track-ready exterior.','collection/cls-16.jpg','published','2026-05-28 18:58:32','2026-05-28 18:58:32',0),(9,'Fluids &amp; Maintenance','fluids-maintenance','Premium oils, filters, and additives keeping your engine in peak shape.','collection/cls-17.jpg','published','2026-05-28 18:58:32','2026-05-28 18:58:32',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,'Engine &amp; Drivetrain','Pistons, belts, and gaskets — OEM-grade essentials for every powertrain.'),('ar',3,'Suspension &amp; Brakes','Shocks, struts, rotors, and pads to keep every drive smooth and safe.'),('ar',4,'Tires &amp; Wheels','Track-tested tires and alloy wheels built for grip, balance, and style.'),('ar',5,'Lighting &amp; Electrical','LED headlights, fog kits, and harnesses for visibility and reliability.'),('ar',6,'Tools &amp; Garage','Repair kits, lifts, and tool sets for every wrench-day in your garage.'),('ar',7,'Interior &amp; Comfort','Seat covers, mats, and accessories to refine every mile inside the cabin.'),('ar',8,'Body &amp; Exterior','Spoilers, bumpers, and protective film for a track-ready exterior.'),('ar',9,'Fluids &amp; Maintenance','Premium oils, filters, and additives keeping your engine in peak shape.'),('fr',1,'Pièces de performance','Des améliorations hautes performances conçues pour la puissance et la précision sur la route.'),('fr',2,'Engine &amp; Drivetrain','Pistons, belts, and gaskets — OEM-grade essentials for every powertrain.'),('fr',3,'Suspension &amp; Brakes','Shocks, struts, rotors, and pads to keep every drive smooth and safe.'),('fr',4,'Tires &amp; Wheels','Track-tested tires and alloy wheels built for grip, balance, and style.'),('fr',5,'Lighting &amp; Electrical','LED headlights, fog kits, and harnesses for visibility and reliability.'),('fr',6,'Tools &amp; Garage','Repair kits, lifts, and tool sets for every wrench-day in your garage.'),('fr',7,'Interior &amp; Comfort','Seat covers, mats, and accessories to refine every mile inside the cabin.'),('fr',8,'Body &amp; Exterior','Spoilers, bumpers, and protective film for a track-ready exterior.'),('fr',9,'Fluids &amp; Maintenance','Premium oils, filters, and additives keeping your engine in peak shape.'),('id',1,'Bagian Kinerja','Peningkatan performa tinggi yang dirancang untuk menghasilkan tenaga dan presisi di jalan.'),('id',2,'Engine &amp; Drivetrain','Pistons, belts, and gaskets — OEM-grade essentials for every powertrain.'),('id',3,'Suspension &amp; Brakes','Shocks, struts, rotors, and pads to keep every drive smooth and safe.'),('id',4,'Tires &amp; Wheels','Track-tested tires and alloy wheels built for grip, balance, and style.'),('id',5,'Lighting &amp; Electrical','LED headlights, fog kits, and harnesses for visibility and reliability.'),('id',6,'Tools &amp; Garage','Repair kits, lifts, and tool sets for every wrench-day in your garage.'),('id',7,'Interior &amp; Comfort','Seat covers, mats, and accessories to refine every mile inside the cabin.'),('id',8,'Body &amp; Exterior','Spoilers, bumpers, and protective film for a track-ready exterior.'),('id',9,'Fluids &amp; Maintenance','Premium oils, filters, and additives keeping your engine in peak shape.'),('tr',1,'Performans Parçaları','Yolda güç ve hassasiyet için tasarlanmış yüksek performanslı yükseltmeler.'),('tr',2,'Engine &amp; Drivetrain','Pistons, belts, and gaskets — OEM-grade essentials for every powertrain.'),('tr',3,'Suspension &amp; Brakes','Shocks, struts, rotors, and pads to keep every drive smooth and safe.'),('tr',4,'Tires &amp; Wheels','Track-tested tires and alloy wheels built for grip, balance, and style.'),('tr',5,'Lighting &amp; Electrical','LED headlights, fog kits, and harnesses for visibility and reliability.'),('tr',6,'Tools &amp; Garage','Repair kits, lifts, and tool sets for every wrench-day in your garage.'),('tr',7,'Interior &amp; Comfort','Seat covers, mats, and accessories to refine every mile inside the cabin.'),('tr',8,'Body &amp; Exterior','Spoilers, bumpers, and protective film for a track-ready exterior.'),('tr',9,'Fluids &amp; Maintenance','Premium oils, filters, and additives keeping your engine in peak shape.'),('vi',1,'Phụ Tùng Hiệu Năng','Nâng cấp hiệu năng cao được thiết kế cho sức mạnh và độ chính xác trên mọi cung đường.'),('vi',2,'Engine &amp; Drivetrain','Pistons, belts, and gaskets — OEM-grade essentials for every powertrain.'),('vi',3,'Suspension &amp; Brakes','Shocks, struts, rotors, and pads to keep every drive smooth and safe.'),('vi',4,'Tires &amp; Wheels','Track-tested tires and alloy wheels built for grip, balance, and style.'),('vi',5,'Lighting &amp; Electrical','LED headlights, fog kits, and harnesses for visibility and reliability.'),('vi',6,'Tools &amp; Garage','Repair kits, lifts, and tool sets for every wrench-day in your garage.'),('vi',7,'Interior &amp; Comfort','Seat covers, mats, and accessories to refine every mile inside the cabin.'),('vi',8,'Body &amp; Exterior','Spoilers, bumpers, and protective film for a track-ready exterior.'),('vi',9,'Fluids &amp; Maintenance','Premium oils, filters, and additives keeping your engine in peak shape.');

--
-- 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,3,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),(1,9,0,0.00,'fixed',1),(2,4,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,10,0,0.00,'fixed',1),(3,2,0,0.00,'fixed',1),(3,4,0,0.00,'fixed',1),(3,5,0,0.00,'fixed',1),(3,7,0,0.00,'fixed',1),(3,8,0,0.00,'fixed',1),(3,9,0,0.00,'fixed',1),(4,1,0,0.00,'fixed',1),(4,5,0,0.00,'fixed',1),(4,6,0,0.00,'fixed',1),(4,8,0,0.00,'fixed',1),(4,10,0,0.00,'fixed',1),(5,1,0,0.00,'fixed',1),(5,3,0,0.00,'fixed',1),(5,4,0,0.00,'fixed',1),(5,6,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,3,0,0.00,'fixed',1),(6,4,0,0.00,'fixed',1),(6,5,0,0.00,'fixed',1),(6,7,0,0.00,'fixed',1),(6,8,0,0.00,'fixed',1),(7,2,0,0.00,'fixed',1),(7,3,0,0.00,'fixed',1),(7,4,0,0.00,'fixed',1),(7,8,0,0.00,'fixed',1),(7,9,0,0.00,'fixed',1),(8,1,0,0.00,'fixed',1),(8,4,0,0.00,'fixed',1),(8,5,0,0.00,'fixed',1),(8,6,0,0.00,'fixed',1),(8,7,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,5,0,0.00,'fixed',1),(9,7,0,0.00,'fixed',1),(9,10,0,0.00,'fixed',1),(10,1,0,0.00,'fixed',1),(10,4,0,0.00,'fixed',1),(10,7,0,0.00,'fixed',1),(10,9,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 (2,9),(4,3),(5,6);

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

CREATE TABLE `ec_product_labels` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `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 18:58:28','2026-05-28 18:58:28','#FFFFFF'),(2,'New','#22C55E','published','2026-05-28 18:58:28','2026-05-28 18:58:28','#FFFFFF'),(3,'Sale','#EF4444','published','2026-05-28 18:58:28','2026-05-28 18:58:28','#FFFFFF'),(4,'Best Seller','#1E1E1E','published','2026-05-28 18:58:28','2026-05-28 18:58:28','#FFFFFF'),(5,'Limited','#7B1F2B','published','2026-05-28 18:58:28','2026-05-28 18:58:28','#FFFFFF'),(6,'Eco','#6B7843','published','2026-05-28 18:58:28','2026-05-28 18:58:28','#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,5),(1,14),(1,15),(2,2),(2,6),(2,9),(3,3),(3,5),(3,14),(4,3),(4,7),(4,12),(5,1),(5,3),(5,6),(6,2),(6,5),(6,7),(7,5),(7,8),(7,15),(8,3),(8,9),(8,11),(9,3),(9,12),(9,15),(10,3),(10,7),(10,10);

--
-- 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 18:58:28','2026-05-28 18:58:28'),(2,'Linen','Products tagged with Linen.',NULL,'published','2026-05-28 18:58:28','2026-05-28 18:58:28'),(3,'Wool','Products tagged with Wool.',NULL,'published','2026-05-28 18:58:28','2026-05-28 18:58:28'),(4,'Leather','Products tagged with Leather.',NULL,'published','2026-05-28 18:58:28','2026-05-28 18:58:28'),(5,'Tencel','Products tagged with Tencel.',NULL,'published','2026-05-28 18:58:28','2026-05-28 18:58:28'),(6,'Recycled','Products tagged with Recycled.',NULL,'published','2026-05-28 18:58:28','2026-05-28 18:58:28'),(7,'Made in Portugal','Products tagged with Made in Portugal.',NULL,'published','2026-05-28 18:58:28','2026-05-28 18:58:28'),(8,'Made in Italy','Products tagged with Made in Italy.',NULL,'published','2026-05-28 18:58:28','2026-05-28 18:58:28'),(9,'Hand-Crafted','Products tagged with Hand-Crafted.',NULL,'published','2026-05-28 18:58:28','2026-05-28 18:58:28'),(10,'Vegan','Products tagged with Vegan.',NULL,'published','2026-05-28 18:58:28','2026-05-28 18:58:28'),(11,'Limited Run','Products tagged with Limited Run.',NULL,'published','2026-05-28 18:58:28','2026-05-28 18:58:28'),(12,'Best Seller','Products tagged with Best Seller.',NULL,'published','2026-05-28 18:58:28','2026-05-28 18:58:28'),(13,'New Arrival','Products tagged with New Arrival.',NULL,'published','2026-05-28 18:58:28','2026-05-28 18:58:28'),(14,'Editor Pick','Products tagged with Editor Pick.',NULL,'published','2026-05-28 18:58:28','2026-05-28 18:58:28'),(15,'Eco-Friendly','Products tagged with Eco-Friendly.',NULL,'published','2026-05-28 18:58:28','2026-05-28 18:58:28');

--
-- 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,8,0,50.00,'fixed',1),(1,10,0,15.00,'percent',1),(2,6,0,10.00,'fixed',1),(2,8,0,5.00,'fixed',1),(3,2,0,10.00,'percent',1),(3,10,0,50.00,'fixed',1),(4,1,0,5.00,'percent',1),(4,8,0,5.00,'fixed',1),(5,2,0,15.00,'percent',1),(5,9,0,5.00,'fixed',1),(6,7,0,10.00,'percent',1),(6,10,0,50.00,'fixed',1),(7,1,0,5.00,'fixed',1),(7,5,0,50.00,'fixed',1),(8,3,0,5.00,'fixed',1),(8,5,0,10.00,'percent',1),(9,1,0,20.00,'percent',1),(9,8,0,20.00,'percent',1),(10,1,0,20.00,'percent',1),(10,8,0,10.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 (3,6,2),(1,9,1),(2,16,1),(4,17,2),(5,19,3),(6,19,4),(7,19,5),(10,19,8),(12,19,10),(14,20,12),(8,21,6),(16,21,14),(9,22,7),(11,22,9),(15,22,13),(13,24,11);

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

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

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

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

INSERT INTO `ec_products` VALUES (1,'Dash Camera Pro','dash-camera-pro','1440p front + rear dash cam with parking mode and built-in GPS logging.','<p>Records every drive in razor-sharp 1440p with night-vision sensors front and back. 24-hour parking surveillance and Wi-Fi app pairing included.</p>','published','[\"products\\/auto\\/product-1.jpg\"]',NULL,'PM-182',0,17,0,1,'in_stock',0,NULL,9,0,0,10,3.30,0,199,159,NULL,NULL,14,16,14,506,NULL,'standard',32302,'2026-05-28 18:58:35','2026-05-28 18:58:42',1,0,'Botble\\ACL\\Models\\User',0,'products/auto/product-1.jpg','physical','7474444991522',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(2,'Projector Headlights','projector-headlights','Plug-and-play LED projector headlight pair with sequential turn signals.','<p>DOT-compliant LED projector assembly with halo daytime running lights. Direct-fit replacement, no wiring harness modifications required.</p>','published','[\"products\\/auto\\/product-2.jpg\"]',NULL,'3Z-177',0,14,0,1,'in_stock',1,NULL,1,0,0,10,2.90,0,299,249,NULL,NULL,17,14,17,561,NULL,'standard',171395,'2026-05-28 18:58:35','2026-05-28 18:58:42',2,0,'Botble\\ACL\\Models\\User',0,'products/auto/product-2.jpg','physical','4957705877009',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(3,'Cylinder Head Gasket','cylinder-head-gasket','Multi-layer steel cylinder head gasket engineered for high-compression engines.','<p>OE-grade MLS construction resists thermal cycling and combustion pressure. Ships with torque sequence guide.</p>','published','[\"products\\/auto\\/product-3.jpg\"]',NULL,'ZD-113-A1',0,15,0,1,'in_stock',1,NULL,12,0,2,10,3.60,0,89,69,NULL,NULL,17,11,19,538,NULL,'standard',157815,'2026-05-28 18:58:35','2026-05-28 18:58:42',3,0,'Botble\\ACL\\Models\\User',0,'products/auto/product-3.jpg','physical','4069538694194',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(4,'Alloy Sport Wheel','alloy-sport-wheel','18-inch lightweight alloy wheel with gunmetal finish and forged construction.','<p>Reduces unsprung weight by 22 percent versus stock. Hub-centric design, includes center cap and valve stem.</p>','published','[\"products\\/auto\\/product-4.jpg\"]',NULL,'ZH-115',0,19,0,1,'in_stock',1,NULL,3,0,0,10,3.00,0,269,219,NULL,NULL,12,14,11,623,NULL,'standard',41885,'2026-05-28 18:58:35','2026-05-28 18:58:42',4,0,'Botble\\ACL\\Models\\User',0,'products/auto/product-4.jpg','physical','3346098619036',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(5,'Brake Pad Set Premium','brake-pad-set-premium','Low-dust ceramic brake pads with stainless shims for quiet, confident stopping.','<p>Front pad set engineered for daily driving and spirited use. Reduces brake dust by up to 80 percent compared to OE pads.</p>','published','[\"products\\/auto\\/product-5.jpg\"]',NULL,'QA-131',0,12,0,1,'in_stock',1,NULL,1,0,0,10,2.60,0,79,59,NULL,NULL,15,19,13,742,NULL,'standard',150676,'2026-05-28 18:58:35','2026-05-28 18:58:42',1,0,'Botble\\ACL\\Models\\User',0,'products/auto/product-5.jpg','physical','1347522632166',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(6,'Cabin Air Filter','cabin-air-filter','Activated-carbon cabin filter that traps allergens, dust, and exhaust odors.','<p>Three-layer filtration captures particles down to 0.3 microns. Recommended replacement every 15,000 miles.</p>','published','[\"products\\/auto\\/product-6.jpg\"]',NULL,'I7-146-A1',0,13,0,1,'in_stock',0,NULL,10,0,3,10,2.90,0,35,25,NULL,NULL,10,16,19,845,NULL,'standard',142289,'2026-05-28 18:58:35','2026-05-28 18:58:42',2,0,'Botble\\ACL\\Models\\User',0,'products/auto/product-6.jpg','physical','5434081884467',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(7,'Performance Oil Filter','performance-oil-filter','High-flow synthetic-media oil filter rated for extended drain intervals.','<p>Anti-drainback valve and silicone gasket ensure cold-start protection. Compatible with synthetic and conventional oils.</p>','published','[\"products\\/auto\\/product-7.jpg\"]',NULL,'DK-107',0,20,0,1,'in_stock',1,NULL,9,0,0,10,3.00,0,29,25,NULL,NULL,13,10,11,708,NULL,'standard',15558,'2026-05-28 18:58:35','2026-05-28 18:58:42',3,0,'Botble\\ACL\\Models\\User',0,'products/auto/product-7.jpg','physical','4209353633606',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(8,'LED Headlight Bulb','led-headlight-bulb','10,000 lumen pair of LED conversion bulbs with whisper-quiet cooling fans.','<p>6500K daylight color temperature, plug-and-play install, CANBus compatible on most vehicles. 50,000 hour lifespan.</p>','published','[\"products\\/auto\\/product-8.jpg\"]',NULL,'LD-142-A1',0,19,0,1,'in_stock',1,NULL,11,0,2,10,3.10,0,89,69,NULL,NULL,17,16,13,609,NULL,'standard',63538,'2026-05-28 18:58:35','2026-05-28 18:58:42',4,0,'Botble\\ACL\\Models\\User',0,'products/auto/product-8.jpg','physical','0329481400247',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(9,'Brake Disc Vented','brake-disc-vented','Cross-drilled and slotted vented brake rotor for cooler, more consistent braking.','<p>Anti-corrosion zinc coating and balanced construction. Ships as a single rotor; order in pairs for axle service.</p>','published','[\"products\\/auto\\/product-9.jpg\"]',NULL,'RY-180-A1',0,13,0,1,'in_stock',1,NULL,4,0,3,10,2.60,0,129,99,NULL,NULL,14,11,12,596,NULL,'standard',92863,'2026-05-28 18:58:35','2026-05-28 18:58:42',1,0,'Botble\\ACL\\Models\\User',0,'products/auto/product-9.jpg','physical','3497168258058',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(10,'Power Steering Pump','power-steering-pump','Remanufactured power steering pump tested to OE specifications.','<p>Includes new reservoir, pulley, and seal kit. 2-year unlimited mileage warranty.</p>','published','[\"products\\/auto\\/product-10.jpg\"]',NULL,'B6-197-A1',0,16,0,1,'in_stock',0,NULL,7,0,4,10,3.40,0,219,179,NULL,NULL,15,12,10,674,NULL,'standard',178635,'2026-05-28 18:58:36','2026-05-28 18:58:42',2,0,'Botble\\ACL\\Models\\User',0,'products/auto/product-10.jpg','physical','1984874257618',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(11,'Cylinder Head Gasket',NULL,NULL,NULL,'published','[\"products\\/auto\\/product-3.jpg\"]',NULL,'ZD-113-A1',0,15,0,1,'in_stock',0,NULL,12,1,0,0,0.00,0,89,NULL,NULL,NULL,17,11,19,538,NULL,'standard',0,'2026-05-28 18:58:36','2026-05-28 18:58:42',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9422095655025',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(12,'Cylinder Head Gasket',NULL,NULL,NULL,'published','[\"products\\/auto\\/product-3.jpg\"]',NULL,'ZD-113-A1-A2',0,15,0,1,'in_stock',0,NULL,12,1,0,0,0.00,0,89,NULL,NULL,NULL,17,11,19,538,NULL,'standard',0,'2026-05-28 18:58:36','2026-05-28 18:58:42',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4796175469198',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(13,'Cabin Air Filter',NULL,NULL,NULL,'published','[\"products\\/auto\\/product-6.jpg\"]',NULL,'I7-146-A1',0,13,0,1,'in_stock',0,NULL,10,1,0,0,0.00,0,35,NULL,NULL,NULL,10,16,19,845,NULL,'standard',0,'2026-05-28 18:58:36','2026-05-28 18:58:42',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5812453162335',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(14,'Cabin Air Filter',NULL,NULL,NULL,'published','[\"products\\/auto\\/product-6.jpg\"]',NULL,'I7-146-A1-A2',0,13,0,1,'in_stock',0,NULL,10,1,0,0,0.00,0,35,NULL,NULL,NULL,10,16,19,845,NULL,'standard',0,'2026-05-28 18:58:36','2026-05-28 18:58:42',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','1019997711850',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(15,'Cabin Air Filter',NULL,NULL,NULL,'published','[\"products\\/auto\\/product-6.jpg\"]',NULL,'I7-146-A1-A3',0,13,0,1,'in_stock',0,NULL,10,1,0,0,0.00,0,35,NULL,NULL,NULL,10,16,19,845,NULL,'standard',0,'2026-05-28 18:58:36','2026-05-28 18:58:42',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4462850178739',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(16,'LED Headlight Bulb',NULL,NULL,NULL,'published','[\"products\\/auto\\/product-8.jpg\"]',NULL,'LD-142-A1',0,19,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,89,67.64,NULL,NULL,17,16,13,609,NULL,'standard',0,'2026-05-28 18:58:36','2026-05-28 18:58:42',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5152201983011',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(17,'LED Headlight Bulb',NULL,NULL,NULL,'published','[\"products\\/auto\\/product-8.jpg\"]',NULL,'LD-142-A1-A2',0,19,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,89,70.31,NULL,NULL,17,16,13,609,NULL,'standard',0,'2026-05-28 18:58:36','2026-05-28 18:58:42',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5917426957649',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(18,'Brake Disc Vented',NULL,NULL,NULL,'published','[\"products\\/auto\\/product-9.jpg\"]',NULL,'RY-180-A1',0,13,0,1,'in_stock',0,NULL,4,1,0,0,0.00,0,129,NULL,NULL,NULL,14,11,12,596,NULL,'standard',0,'2026-05-28 18:58:36','2026-05-28 18:58:42',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8598873015143',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(19,'Brake Disc Vented',NULL,NULL,NULL,'published','[\"products\\/auto\\/product-9.jpg\"]',NULL,'RY-180-A1-A2',0,13,0,1,'in_stock',0,NULL,4,1,0,0,0.00,0,129,NULL,NULL,NULL,14,11,12,596,NULL,'standard',0,'2026-05-28 18:58:37','2026-05-28 18:58:42',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','7263328163571',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(20,'Brake Disc Vented',NULL,NULL,NULL,'published','[\"products\\/auto\\/product-9.jpg\"]',NULL,'RY-180-A1-A3',0,13,0,1,'in_stock',0,NULL,4,1,0,0,0.00,0,129,NULL,NULL,NULL,14,11,12,596,NULL,'standard',0,'2026-05-28 18:58:37','2026-05-28 18:58:42',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9920446063296',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(21,'Power Steering Pump',NULL,NULL,NULL,'published','[\"products\\/auto\\/product-10.jpg\"]',NULL,'B6-197-A1',0,16,0,1,'in_stock',0,NULL,7,1,0,0,0.00,0,219,NULL,NULL,NULL,15,12,10,674,NULL,'standard',0,'2026-05-28 18:58:37','2026-05-28 18:58:42',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4785219291253',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(22,'Power Steering Pump',NULL,NULL,NULL,'published','[\"products\\/auto\\/product-10.jpg\"]',NULL,'B6-197-A1-A2',0,16,0,1,'in_stock',0,NULL,7,1,0,0,0.00,0,219,NULL,NULL,NULL,15,12,10,674,NULL,'standard',0,'2026-05-28 18:58:37','2026-05-28 18:58:42',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2700697815441',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(23,'Power Steering Pump',NULL,NULL,NULL,'published','[\"products\\/auto\\/product-10.jpg\"]',NULL,'B6-197-A1-A3',0,16,0,1,'in_stock',0,NULL,7,1,0,0,0.00,0,219,NULL,NULL,NULL,15,12,10,674,NULL,'standard',0,'2026-05-28 18:58:37','2026-05-28 18:58:42',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2813389638720',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(24,'Power Steering Pump',NULL,NULL,NULL,'published','[\"products\\/auto\\/product-10.jpg\"]',NULL,'B6-197-A1-A4',0,16,0,1,'in_stock',0,NULL,7,1,0,0,0.00,0,219,NULL,NULL,NULL,15,12,10,674,NULL,'standard',0,'2026-05-28 18:58:37','2026-05-28 18:58:42',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6772163195124',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,'كاميرا أمامية + خلفية بدقة 1440 بكسل، ووضع انتظار السيارة، وتسجيل GPS مدمج.','<p> التقط كل رحلة بوضوح شديد يبلغ 1440 بكسل باستخدام مستشعرات الرؤية الليلية الأمامية والخلفية. يتضمن مراقبة مواقف السيارات على مدار 24 ساعة والاتصال بتطبيق Wi-Fi.</p>'),('ar',2,'المصابيح الأمامية لجهاز العرض',NULL,'زوج من المصابيح الأمامية لجهاز العرض LED القابلة للتوصيل والتشغيل مع إشارات انعطاف المسح التسلسلي.','<p>تتوافق مجموعة مصابيح جهاز العرض LED مع معايير DOT مع حلقة الإضاءة النهارية. استبدال مباشر، لا حاجة لتعديل السلك.</p>'),('ar',3,'حشية رأس الاسطوانة',NULL,'تم تصميم جوانات وجه المحرك الفولاذية متعددة الطبقات للمحركات ذات نسبة الضغط العالية.','<p>OE هيكل MLS القياسي يتحمل دورات الحرارة وضغط غرفة الاحتراق. مرفق تعليمات حول إجراءات التشديد.</p>'),('ar',4,'عجلة رياضية مصنوعة من السبائك',NULL,'عجلات معدنية خفيفة الوزن مقاس 18 بوصة مع تشطيب باللون الرمادي الفحمي وبنية مصقولة.','<p> يقلل الكتلة غير المخمدة بنسبة 22 بالمائة مقارنة بحواف الزنك. تصميم مركزي للمحور، مكتمل بغطاء مركزي وصمام.</p>'),('ar',5,'مجموعة وسادة الفرامل بريميوم',NULL,'توفر وسادات الفرامل المصنوعة من السيراميك منخفض الغبار مع وسادات من الفولاذ المقاوم للصدأ توقفًا سلسًا ومضمونًا.','<p> تم تصميم وسادات الفرامل الأمامية للقيادة اليومية والأداء القوي. يقلل من غبار الفرامل بنسبة تصل إلى 80 بالمائة مقارنةً بوسادات الفرامل الأصلية.</p>'),('ar',6,'فلتر هواء المقصورة',NULL,'يعمل فلتر هواء المقصورة المصنوع من الكربون المنشط على احتجاز حبوب اللقاح والغبار وروائح العادم.','<p> يحتفظ الترشيح ثلاثي الطبقات بالجزيئات الصغيرة التي يصل حجمها إلى 0.3 ميكرون. يوصى بالاستبدال كل 15000 ميل.</p>'),('ar',7,'فلتر زيت الأداء',NULL,'فلتر زيت أساسي صناعي عالي التدفق، مناسب لفترات تغيير الزيت الممتدة.','<p>يضمن الصمام المضاد للتدفق الخلفي وحشية السيليكون الحماية أثناء بدء التشغيل البارد. متوافق مع الزيوت الاصطناعية والتقليدية.</p>'),('ar',8,'لمبة المصباح LED',NULL,'زوج من مصابيح LED قابلة للتحويل بقوة 10000 لومن مع مروحة تبريد هادئة.','<p> درجة حرارة لون ضوء النهار 6500 كلفن، تركيب التوصيل والتشغيل، CANBus متوافق مع معظم المركبات. العمر الافتراضي 50,000 ساعة.</p>'),('ar',9,'قرص الفرامل منفس',NULL,'توفر أقراص الفرامل المثقبة والمشقوقة ذات التهوية فرملة أكثر برودة وأكثر استقرارًا.','<p> طلاء زنك مقاوم للتآكل وهيكل متوازن. تسليم واحد؛ اطلب في أزواج عند خدمة المحور بأكمله.</p>'),('ar',10,'مضخة التوجيه',NULL,'يتم اختبار مضخات التوجيه المعزز المعاد تصنيعها وفقًا لمعايير المعدات الأصلية.','<p> يتضمن خزانًا جديدًا وبكرة ومجموعة مانعة للتسرب. ضمان لمدة عامين غير محدود عدد الكيلومترات.</p>'),('ar',11,'حشية رأس الاسطوانة',NULL,'تم تصميم جوانات وجه المحرك الفولاذية متعددة الطبقات للمحركات ذات نسبة الضغط العالية.','<p>OE هيكل MLS القياسي يتحمل دورات الحرارة وضغط غرفة الاحتراق. مرفق تعليمات حول إجراءات التشديد.</p>'),('ar',12,'حشية رأس الاسطوانة',NULL,'تم تصميم جوانات وجه المحرك الفولاذية متعددة الطبقات للمحركات ذات نسبة الضغط العالية.','<p>OE هيكل MLS القياسي يتحمل دورات الحرارة وضغط غرفة الاحتراق. مرفق تعليمات حول إجراءات التشديد.</p>'),('ar',13,'فلتر هواء المقصورة',NULL,'يعمل فلتر هواء المقصورة المصنوع من الكربون المنشط على احتجاز حبوب اللقاح والغبار وروائح العادم.','<p> يحتفظ الترشيح ثلاثي الطبقات بالجزيئات الصغيرة التي يصل حجمها إلى 0.3 ميكرون. يوصى بالاستبدال كل 15000 ميل.</p>'),('ar',14,'فلتر هواء المقصورة',NULL,'يعمل فلتر هواء المقصورة المصنوع من الكربون المنشط على احتجاز حبوب اللقاح والغبار وروائح العادم.','<p> يحتفظ الترشيح ثلاثي الطبقات بالجزيئات الصغيرة التي يصل حجمها إلى 0.3 ميكرون. يوصى بالاستبدال كل 15000 ميل.</p>'),('ar',15,'فلتر هواء المقصورة',NULL,'يعمل فلتر هواء المقصورة المصنوع من الكربون المنشط على احتجاز حبوب اللقاح والغبار وروائح العادم.','<p> يحتفظ الترشيح ثلاثي الطبقات بالجزيئات الصغيرة التي يصل حجمها إلى 0.3 ميكرون. يوصى بالاستبدال كل 15000 ميل.</p>'),('ar',16,'لمبة المصباح LED',NULL,'زوج من مصابيح LED قابلة للتحويل بقوة 10000 لومن مع مروحة تبريد هادئة.','<p> درجة حرارة لون ضوء النهار 6500 كلفن، تركيب التوصيل والتشغيل، CANBus متوافق مع معظم المركبات. العمر الافتراضي 50,000 ساعة.</p>'),('ar',17,'لمبة المصباح LED',NULL,'زوج من مصابيح LED قابلة للتحويل بقوة 10000 لومن مع مروحة تبريد هادئة.','<p> درجة حرارة لون ضوء النهار 6500 كلفن، تركيب التوصيل والتشغيل، CANBus متوافق مع معظم المركبات. العمر الافتراضي 50,000 ساعة.</p>'),('ar',18,'قرص الفرامل منفس',NULL,'توفر أقراص الفرامل المثقبة والمشقوقة ذات التهوية فرملة أكثر برودة وأكثر استقرارًا.','<p> طلاء زنك مقاوم للتآكل وهيكل متوازن. تسليم واحد؛ اطلب في أزواج عند خدمة المحور بأكمله.</p>'),('ar',19,'قرص الفرامل منفس',NULL,'توفر أقراص الفرامل المثقبة والمشقوقة ذات التهوية فرملة أكثر برودة وأكثر استقرارًا.','<p> طلاء زنك مقاوم للتآكل وهيكل متوازن. تسليم واحد؛ اطلب في أزواج عند خدمة المحور بأكمله.</p>'),('ar',20,'قرص الفرامل منفس',NULL,'توفر أقراص الفرامل المثقبة والمشقوقة ذات التهوية فرملة أكثر برودة وأكثر استقرارًا.','<p> طلاء زنك مقاوم للتآكل وهيكل متوازن. تسليم واحد؛ اطلب في أزواج عند خدمة المحور بأكمله.</p>'),('ar',21,'مضخة التوجيه',NULL,'يتم اختبار مضخات التوجيه المعزز المعاد تصنيعها وفقًا لمعايير المعدات الأصلية.','<p> يتضمن خزانًا جديدًا وبكرة ومجموعة مانعة للتسرب. ضمان لمدة عامين غير محدود عدد الكيلومترات.</p>'),('ar',22,'مضخة التوجيه',NULL,'يتم اختبار مضخات التوجيه المعزز المعاد تصنيعها وفقًا لمعايير المعدات الأصلية.','<p> يتضمن خزانًا جديدًا وبكرة ومجموعة مانعة للتسرب. ضمان لمدة عامين غير محدود عدد الكيلومترات.</p>'),('ar',23,'مضخة التوجيه',NULL,'يتم اختبار مضخات التوجيه المعزز المعاد تصنيعها وفقًا لمعايير المعدات الأصلية.','<p> يتضمن خزانًا جديدًا وبكرة ومجموعة مانعة للتسرب. ضمان لمدة عامين غير محدود عدد الكيلومترات.</p>'),('ar',24,'مضخة التوجيه',NULL,'يتم اختبار مضخات التوجيه المعزز المعاد تصنيعها وفقًا لمعايير المعدات الأصلية.','<p> يتضمن خزانًا جديدًا وبكرة ومجموعة مانعة للتسرب. ضمان لمدة عامين غير محدود عدد الكيلومترات.</p>'),('fr',1,'Caméra de tableau de bord Pro',NULL,'Caméra de tableau de bord avant et arrière avec résolution 1440p, mode stationnement et enregistrement GPS intégré.','<p>Capturez chaque voyage avec une clarté 1440p d\'une netteté exceptionnelle grâce aux capteurs de vision nocturne avant et arrière. Comprend une surveillance du stationnement 24 heures sur 24 et une connectivité d\'application Wi-Fi.</p>'),('fr',2,'Phares de projecteur',NULL,'Paire de phares projecteurs LED plug-and-play avec clignotants à balayage séquentiel.','Le cluster d\'éclairage du projecteur <p>LED répond aux normes DOT avec un anneau de feux diurnes. Remplacement Direct, pas besoin de modifier le fil.</p>'),('fr',3,'Joint De Culasse',NULL,'Les joints de face moteur en acier multicouche sont conçus pour les moteurs à taux de compression élevé.','La structure MLS standard <p>OE résiste aux cycles thermiques et à la pression de la chambre de combustion. Vous trouverez ci-joint des instructions sur les procédures de serrage.</p>'),('fr',4,'Roue sport en alliage',NULL,'Jantes en alliage léger de 18 pouces avec finition gris anthracite et construction forgée.','<p>Réduit la masse non amortie de 22 % par rapport aux jantes en zinc. Conception de centrage du moyeu, complète avec capuchon central et valve.</p>'),('fr',5,'Jeu de plaquettes de frein Premium',NULL,'Les plaquettes de frein en céramique à faible poussière avec plaquettes en acier inoxydable assurent un arrêt en douceur et sûr.','<p>Les plaquettes de frein avant sont conçues pour la conduite quotidienne et des performances puissantes. Réduit la poussière de frein jusqu\'à 80 % par rapport aux plaquettes de frein d\'origine.</p>'),('fr',6,'Filtre à air d\'habitacle',NULL,'Le filtre à air d\'habitacle au charbon actif retient le pollen, la poussière et les odeurs d\'échappement.','<p>La filtration à trois couches retient les particules aussi petites que 0,3 microns. Remplacement recommandé tous les 15 000 miles.</p>'),('fr',7,'Filtre à huile performant',NULL,'Filtre à huile à noyau synthétique à haut débit, adapté aux intervalles de vidange d\'huile prolongés.','<p>Le clapet anti-retour et le joint en silicone assurent la protection lors des démarrages à froid. Compatible avec les huiles synthétiques et conventionnelles.</p>'),('fr',8,'Ampoule de phare LED',NULL,'Paire d\'ampoules LED convertibles de 10 000 lumens avec ventilateur de refroidissement silencieux.','<p>Température de couleur lumière du jour 6 500 K, installation plug-and-play, compatible CANBus sur la plupart des véhicules. Durée de vie 50 000 heures.</p>'),('fr',9,'Disque de frein ventilé',NULL,'Les disques de frein ventilés perforés et fendus offrent un freinage plus frais et plus stable.','<p>Revêtement de zinc résistant à la corrosion et structure équilibrée. Livraison unique ; Commandez par paires lors de l\'entretien de l\'essieu entier.</p>'),('fr',10,'Pompe de direction assistée',NULL,'Les pompes de direction assistée reconditionnées sont testées selon les normes OE.','<p>Comprend un nouveau réservoir, une poulie et un jeu de joints. Garantie kilométrage illimité de 2 ans.</p>'),('fr',11,'Joint De Culasse',NULL,'Les joints de face moteur en acier multicouche sont conçus pour les moteurs à taux de compression élevé.','La structure MLS standard <p>OE résiste aux cycles thermiques et à la pression de la chambre de combustion. Vous trouverez ci-joint des instructions sur les procédures de serrage.</p>'),('fr',12,'Joint De Culasse',NULL,'Les joints de face moteur en acier multicouche sont conçus pour les moteurs à taux de compression élevé.','La structure MLS standard <p>OE résiste aux cycles thermiques et à la pression de la chambre de combustion. Vous trouverez ci-joint des instructions sur les procédures de serrage.</p>'),('fr',13,'Filtre à air d\'habitacle',NULL,'Le filtre à air d\'habitacle au charbon actif retient le pollen, la poussière et les odeurs d\'échappement.','<p>La filtration à trois couches retient les particules aussi petites que 0,3 microns. Remplacement recommandé tous les 15 000 miles.</p>'),('fr',14,'Filtre à air d\'habitacle',NULL,'Le filtre à air d\'habitacle au charbon actif retient le pollen, la poussière et les odeurs d\'échappement.','<p>La filtration à trois couches retient les particules aussi petites que 0,3 microns. Remplacement recommandé tous les 15 000 miles.</p>'),('fr',15,'Filtre à air d\'habitacle',NULL,'Le filtre à air d\'habitacle au charbon actif retient le pollen, la poussière et les odeurs d\'échappement.','<p>La filtration à trois couches retient les particules aussi petites que 0,3 microns. Remplacement recommandé tous les 15 000 miles.</p>'),('fr',16,'Ampoule de phare LED',NULL,'Paire d\'ampoules LED convertibles de 10 000 lumens avec ventilateur de refroidissement silencieux.','<p>Température de couleur lumière du jour 6 500 K, installation plug-and-play, compatible CANBus sur la plupart des véhicules. Durée de vie 50 000 heures.</p>'),('fr',17,'Ampoule de phare LED',NULL,'Paire d\'ampoules LED convertibles de 10 000 lumens avec ventilateur de refroidissement silencieux.','<p>Température de couleur lumière du jour 6 500 K, installation plug-and-play, compatible CANBus sur la plupart des véhicules. Durée de vie 50 000 heures.</p>'),('fr',18,'Disque de frein ventilé',NULL,'Les disques de frein ventilés perforés et fendus offrent un freinage plus frais et plus stable.','<p>Revêtement de zinc résistant à la corrosion et structure équilibrée. Livraison unique ; Commandez par paires lors de l\'entretien de l\'essieu entier.</p>'),('fr',19,'Disque de frein ventilé',NULL,'Les disques de frein ventilés perforés et fendus offrent un freinage plus frais et plus stable.','<p>Revêtement de zinc résistant à la corrosion et structure équilibrée. Livraison unique ; Commandez par paires lors de l\'entretien de l\'essieu entier.</p>'),('fr',20,'Disque de frein ventilé',NULL,'Les disques de frein ventilés perforés et fendus offrent un freinage plus frais et plus stable.','<p>Revêtement de zinc résistant à la corrosion et structure équilibrée. Livraison unique ; Commandez par paires lors de l\'entretien de l\'essieu entier.</p>'),('fr',21,'Pompe de direction assistée',NULL,'Les pompes de direction assistée reconditionnées sont testées selon les normes OE.','<p>Comprend un nouveau réservoir, une poulie et un jeu de joints. Garantie kilométrage illimité de 2 ans.</p>'),('fr',22,'Pompe de direction assistée',NULL,'Les pompes de direction assistée reconditionnées sont testées selon les normes OE.','<p>Comprend un nouveau réservoir, une poulie et un jeu de joints. Garantie kilométrage illimité de 2 ans.</p>'),('fr',23,'Pompe de direction assistée',NULL,'Les pompes de direction assistée reconditionnées sont testées selon les normes OE.','<p>Comprend un nouveau réservoir, une poulie et un jeu de joints. Garantie kilométrage illimité de 2 ans.</p>'),('fr',24,'Pompe de direction assistée',NULL,'Les pompes de direction assistée reconditionnées sont testées selon les normes OE.','<p>Comprend un nouveau réservoir, une poulie et un jeu de joints. Garantie kilométrage illimité de 2 ans.</p>'),('id',1,'Kamera Dasbor Pro',NULL,'Kamera dasbor depan + belakang dengan resolusi 1440p, mode parkir, dan pencatatan GPS internal.','<p>Rekam setiap perjalanan dalam kejernihan 1440p yang sangat tajam dengan sensor penglihatan malam depan dan belakang. Termasuk pemantauan parkir 24 jam dan konektivitas aplikasi Wi-Fi.</p>'),('id',2,'Lampu Depan Proyektor',NULL,'Sepasang lampu depan proyektor LED plug-and-play dengan sinyal belok pemindaian berurutan.','<p>Lampu proyektor LED memenuhi standar DOT dengan lampu berjalan siang hari. Penggantian langsung, tidak perlu memodifikasi kabel.</p>'),('id',3,'Paking Kepala Silinder',NULL,'Gasket muka mesin baja multilapis dirancang untuk mesin dengan rasio kompresi tinggi.','Struktur MLS standar <p>OE tahan terhadap siklus panas dan tekanan ruang bakar. Terlampir adalah petunjuk prosedur pengetatan.</p>'),('id',4,'Roda Olahraga Paduan',NULL,'Velg ringan 18 inci dengan finishing abu-abu arang dan konstruksi tempa.','<p>Mengurangi massa yang tidak teredam sebesar 22 persen dibandingkan dengan pelek seng. Desain pemusatan hub, lengkap dengan tutup tengah dan katup.</p>'),('id',5,'Kampas Rem Set Premium',NULL,'Bantalan rem keramik rendah debu dengan bantalan baja tahan karat menghasilkan pengereman yang mulus dan pasti.','<p>Bantalan rem depan dirancang untuk berkendara sehari-hari dan performa bertenaga. Mengurangi debu rem hingga 80 persen dibandingkan dengan bantalan rem OE.</p>'),('id',6,'Filter Udara Kabin',NULL,'Filter udara kabin karbon aktif memerangkap serbuk sari, debu, dan bau knalpot.','<p>Filtrasi tiga lapis menahan partikel sekecil 0,3 mikron. Penggantian yang disarankan setiap 15.000 mil.</p>'),('id',7,'Filter Oli Kinerja',NULL,'Filter oli inti sintetis aliran tinggi, cocok untuk interval penggantian oli yang diperpanjang.','<p>Katup anti-aliran balik dan paking silikon memastikan perlindungan selama start dingin. Kompatibel dengan oli sintetis dan konvensional.</p>'),('id',8,'Bohlam Lampu Depan LED',NULL,'Sepasang bohlam LED konvertibel 10.000 lumen dengan kipas pendingin senyap.','<p>Suhu warna siang hari 6500K, pemasangan plug-and-play, kompatibel dengan CANBus di sebagian besar kendaraan. Umur 50,000 jam.</p>'),('id',9,'Rem Cakram Berventilasi',NULL,'Cakram rem berventilasi berlubang dan berlubang memberikan pengereman yang lebih dingin dan stabil.','<p>Lapisan seng tahan korosi dan struktur seimbang. Pengiriman tunggal; Pesan berpasangan saat menyervis seluruh gardan.</p>'),('id',10,'Pompa Power Steering',NULL,'Pompa power steering yang diproduksi ulang diuji sesuai standar OE.','<p>Termasuk tangki, katrol, dan set segel baru. Garansi jarak tempuh tak terbatas 2 tahun.</p>'),('id',11,'Paking Kepala Silinder',NULL,'Gasket muka mesin baja multilapis dirancang untuk mesin dengan rasio kompresi tinggi.','Struktur MLS standar <p>OE tahan terhadap siklus panas dan tekanan ruang bakar. Terlampir adalah petunjuk prosedur pengetatan.</p>'),('id',12,'Paking Kepala Silinder',NULL,'Gasket muka mesin baja multilapis dirancang untuk mesin dengan rasio kompresi tinggi.','Struktur MLS standar <p>OE tahan terhadap siklus panas dan tekanan ruang bakar. Terlampir adalah petunjuk prosedur pengetatan.</p>'),('id',13,'Filter Udara Kabin',NULL,'Filter udara kabin karbon aktif memerangkap serbuk sari, debu, dan bau knalpot.','<p>Filtrasi tiga lapis menahan partikel sekecil 0,3 mikron. Penggantian yang disarankan setiap 15.000 mil.</p>'),('id',14,'Filter Udara Kabin',NULL,'Filter udara kabin karbon aktif memerangkap serbuk sari, debu, dan bau knalpot.','<p>Filtrasi tiga lapis menahan partikel sekecil 0,3 mikron. Penggantian yang disarankan setiap 15.000 mil.</p>'),('id',15,'Filter Udara Kabin',NULL,'Filter udara kabin karbon aktif memerangkap serbuk sari, debu, dan bau knalpot.','<p>Filtrasi tiga lapis menahan partikel sekecil 0,3 mikron. Penggantian yang disarankan setiap 15.000 mil.</p>'),('id',16,'Bohlam Lampu Depan LED',NULL,'Sepasang bohlam LED konvertibel 10.000 lumen dengan kipas pendingin senyap.','<p>Suhu warna siang hari 6500K, pemasangan plug-and-play, kompatibel dengan CANBus di sebagian besar kendaraan. Umur 50,000 jam.</p>'),('id',17,'Bohlam Lampu Depan LED',NULL,'Sepasang bohlam LED konvertibel 10.000 lumen dengan kipas pendingin senyap.','<p>Suhu warna siang hari 6500K, pemasangan plug-and-play, kompatibel dengan CANBus di sebagian besar kendaraan. Umur 50,000 jam.</p>'),('id',18,'Rem Cakram Berventilasi',NULL,'Cakram rem berventilasi berlubang dan berlubang memberikan pengereman yang lebih dingin dan stabil.','<p>Lapisan seng tahan korosi dan struktur seimbang. Pengiriman tunggal; Pesan berpasangan saat menyervis seluruh gardan.</p>'),('id',19,'Rem Cakram Berventilasi',NULL,'Cakram rem berventilasi berlubang dan berlubang memberikan pengereman yang lebih dingin dan stabil.','<p>Lapisan seng tahan korosi dan struktur seimbang. Pengiriman tunggal; Pesan berpasangan saat menyervis seluruh gardan.</p>'),('id',20,'Rem Cakram Berventilasi',NULL,'Cakram rem berventilasi berlubang dan berlubang memberikan pengereman yang lebih dingin dan stabil.','<p>Lapisan seng tahan korosi dan struktur seimbang. Pengiriman tunggal; Pesan berpasangan saat menyervis seluruh gardan.</p>'),('id',21,'Pompa Power Steering',NULL,'Pompa power steering yang diproduksi ulang diuji sesuai standar OE.','<p>Termasuk tangki, katrol, dan set segel baru. Garansi jarak tempuh tak terbatas 2 tahun.</p>'),('id',22,'Pompa Power Steering',NULL,'Pompa power steering yang diproduksi ulang diuji sesuai standar OE.','<p>Termasuk tangki, katrol, dan set segel baru. Garansi jarak tempuh tak terbatas 2 tahun.</p>'),('id',23,'Pompa Power Steering',NULL,'Pompa power steering yang diproduksi ulang diuji sesuai standar OE.','<p>Termasuk tangki, katrol, dan set segel baru. Garansi jarak tempuh tak terbatas 2 tahun.</p>'),('id',24,'Pompa Power Steering',NULL,'Pompa power steering yang diproduksi ulang diuji sesuai standar OE.','<p>Termasuk tangki, katrol, dan set segel baru. Garansi jarak tempuh tak terbatas 2 tahun.</p>'),('tr',1,'Araç İçi Kamera Pro',NULL,'1440p çözünürlüğe, park moduna ve dahili GPS kaydına sahip ön + arka araç kamerası.','<p>Ön ve arka gece görüş sensörleriyle her yolculuğu son derece keskin 1440p netlikte yakalayın. 24 saat park izleme ve Wi-Fi uygulaması bağlantısı içerir.</p>'),('tr',2,'Projektör Farları',NULL,'Sıralı tarama dönüş sinyallerine sahip bir çift tak ve çalıştır LED projektör farları.','<p>LED projektör ışık kümesi, gündüz yanan ışık halkasıyla DOT standartlarını karşılar. Doğrudan takılan değiştirme, kabloyu değiştirmeye gerek yok.</p>'),('tr',3,'Silindir Kapak Contası',NULL,'Çok katmanlı çelik motor yüzey contaları, yüksek sıkıştırma oranlı motorlar için tasarlanmıştır.','<p>OE standart MLS yapısı ısı çevrimlerine ve yanma odası basıncına dayanıklıdır. Ekte sıkma prosedürlerine ilişkin talimatlar bulunmaktadır.</p>'),('tr',4,'Alaşım Spor Jant',NULL,'Kömür grisi kaplamalı ve dövme yapılı hafif 18 inç alaşım jantlar.','<p>Çinko jantlara kıyasla sönümsüz kütleyi yüzde 22 azaltır. Göbek merkezleme tasarımı, göbek kapağı ve valfle tamamlanmıştır.</p>'),('tr',5,'Fren Balatası Seti Premium',NULL,'Paslanmaz çelik balatalı, az tozlu seramik fren balataları yumuşak ve emin duruş sağlar.','<p>Ön fren balataları günlük sürüş ve güçlü performans için tasarlanmıştır. Orijinal ekipman fren balatalarına kıyasla fren tozunu yüzde 80\'e kadar azaltır.</p>'),('tr',6,'Kabin Hava Filtresi',NULL,'Aktif karbon kabin hava filtresi polen, toz ve egzoz kokularını yakalar.','<p>Üç katmanlı filtreleme, 0,3 mikrona kadar küçük parçacıkları tutar. Her 15.000 milde bir değiştirilmesi önerilir.</p>'),('tr',7,'Performans Yağ Filtresi',NULL,'Uzun yağ değişim aralıklarına uygun, yüksek akışlı sentetik çekirdek yağ filtresi.','<p>Geri akış önleyici valf ve silikon conta, soğuk çalıştırma sırasında koruma sağlar. Sentetik ve konvansiyonel yağlarla uyumludur.</p>'),('tr',8,'LED Far Ampulü',NULL,'Sessiz soğutma fanına sahip 10.000 lümenlik dönüştürülebilir LED ampul çifti.','<p>Gün ışığı renk sıcaklığı 6500K, tak ve çalıştır kurulumu, çoğu araçta CANBus uyumludur. Ömrü 50.000 saat.</p>'),('tr',9,'Fren Diski Havalandırmalı',NULL,'Delikli ve oluklu havalandırmalı fren diskleri daha serin ve daha dengeli frenleme sağlar.','<p>Korozyona dayanıklı çinko kaplama ve dengeli yapı. Tek teslimat; Aksın tamamına servis yapılırken çift olarak sipariş verin.</p>'),('tr',10,'Servo Direksiyon Pompası',NULL,'Yeniden üretilen hidrolik direksiyon pompaları OE standartlarına göre test edilir.','<p>Yeni tank, kasnak ve conta setini içerir. 2 yıl sınırsız kilometre garantisi.</p>'),('tr',11,'Silindir Kapak Contası',NULL,'Çok katmanlı çelik motor yüzey contaları, yüksek sıkıştırma oranlı motorlar için tasarlanmıştır.','<p>OE standart MLS yapısı ısı çevrimlerine ve yanma odası basıncına dayanıklıdır. Ekte sıkma prosedürlerine ilişkin talimatlar bulunmaktadır.</p>'),('tr',12,'Silindir Kapak Contası',NULL,'Çok katmanlı çelik motor yüzey contaları, yüksek sıkıştırma oranlı motorlar için tasarlanmıştır.','<p>OE standart MLS yapısı ısı çevrimlerine ve yanma odası basıncına dayanıklıdır. Ekte sıkma prosedürlerine ilişkin talimatlar bulunmaktadır.</p>'),('tr',13,'Kabin Hava Filtresi',NULL,'Aktif karbon kabin hava filtresi polen, toz ve egzoz kokularını yakalar.','<p>Üç katmanlı filtreleme, 0,3 mikrona kadar küçük parçacıkları tutar. Her 15.000 milde bir değiştirilmesi önerilir.</p>'),('tr',14,'Kabin Hava Filtresi',NULL,'Aktif karbon kabin hava filtresi polen, toz ve egzoz kokularını yakalar.','<p>Üç katmanlı filtreleme, 0,3 mikrona kadar küçük parçacıkları tutar. Her 15.000 milde bir değiştirilmesi önerilir.</p>'),('tr',15,'Kabin Hava Filtresi',NULL,'Aktif karbon kabin hava filtresi polen, toz ve egzoz kokularını yakalar.','<p>Üç katmanlı filtreleme, 0,3 mikrona kadar küçük parçacıkları tutar. Her 15.000 milde bir değiştirilmesi önerilir.</p>'),('tr',16,'LED Far Ampulü',NULL,'Sessiz soğutma fanına sahip 10.000 lümenlik dönüştürülebilir LED ampul çifti.','<p>Gün ışığı renk sıcaklığı 6500K, tak ve çalıştır kurulumu, çoğu araçta CANBus uyumludur. Ömrü 50.000 saat.</p>'),('tr',17,'LED Far Ampulü',NULL,'Sessiz soğutma fanına sahip 10.000 lümenlik dönüştürülebilir LED ampul çifti.','<p>Gün ışığı renk sıcaklığı 6500K, tak ve çalıştır kurulumu, çoğu araçta CANBus uyumludur. Ömrü 50.000 saat.</p>'),('tr',18,'Fren Diski Havalandırmalı',NULL,'Delikli ve oluklu havalandırmalı fren diskleri daha serin ve daha dengeli frenleme sağlar.','<p>Korozyona dayanıklı çinko kaplama ve dengeli yapı. Tek teslimat; Aksın tamamına servis yapılırken çift olarak sipariş verin.</p>'),('tr',19,'Fren Diski Havalandırmalı',NULL,'Delikli ve oluklu havalandırmalı fren diskleri daha serin ve daha dengeli frenleme sağlar.','<p>Korozyona dayanıklı çinko kaplama ve dengeli yapı. Tek teslimat; Aksın tamamına servis yapılırken çift olarak sipariş verin.</p>'),('tr',20,'Fren Diski Havalandırmalı',NULL,'Delikli ve oluklu havalandırmalı fren diskleri daha serin ve daha dengeli frenleme sağlar.','<p>Korozyona dayanıklı çinko kaplama ve dengeli yapı. Tek teslimat; Aksın tamamına servis yapılırken çift olarak sipariş verin.</p>'),('tr',21,'Servo Direksiyon Pompası',NULL,'Yeniden üretilen hidrolik direksiyon pompaları OE standartlarına göre test edilir.','<p>Yeni tank, kasnak ve conta setini içerir. 2 yıl sınırsız kilometre garantisi.</p>'),('tr',22,'Servo Direksiyon Pompası',NULL,'Yeniden üretilen hidrolik direksiyon pompaları OE standartlarına göre test edilir.','<p>Yeni tank, kasnak ve conta setini içerir. 2 yıl sınırsız kilometre garantisi.</p>'),('tr',23,'Servo Direksiyon Pompası',NULL,'Yeniden üretilen hidrolik direksiyon pompaları OE standartlarına göre test edilir.','<p>Yeni tank, kasnak ve conta setini içerir. 2 yıl sınırsız kilometre garantisi.</p>'),('tr',24,'Servo Direksiyon Pompası',NULL,'Yeniden üretilen hidrolik direksiyon pompaları OE standartlarına göre test edilir.','<p>Yeni tank, kasnak ve conta setini içerir. 2 yıl sınırsız kilometre garantisi.</p>'),('vi',1,'Camera Hành Trình Pro',NULL,'Camera hành trình trước + sau độ phân giải 1440p, có chế độ đỗ xe và ghi nhật ký GPS tích hợp.','<p>Ghi lại mọi hành trình với độ nét 1440p sắc bén nhờ cảm biến nhìn đêm ở cả trước và sau. Bao gồm giám sát khi đỗ xe 24 giờ và kết nối ứng dụng qua Wi-Fi.</p>'),('vi',2,'Đèn Pha Projector',NULL,'Cặp đèn pha LED projector cắm-là-chạy với đèn xi-nhan dạng quét tuần tự.','<p>Cụm đèn LED projector đạt chuẩn DOT với vòng đèn chạy ban ngày. Thay thế lắp vừa trực tiếp, không cần chỉnh sửa dây điện.</p>'),('vi',3,'Gioăng Mặt Máy',NULL,'Gioăng mặt máy bằng thép đa lớp được thiết kế cho động cơ tỷ số nén cao.','<p>Cấu tạo MLS chuẩn OE chịu được chu kỳ nhiệt và áp suất buồng đốt. Kèm theo hướng dẫn trình tự siết lực.</p>'),('vi',4,'Mâm Hợp Kim Thể Thao',NULL,'Mâm hợp kim 18 inch nhẹ với lớp hoàn thiện màu xám than và cấu tạo rèn.','<p>Giảm 22 phần trăm khối lượng không được giảm chấn so với mâm zin. Thiết kế định tâm moay-ơ, kèm theo nắp chụp trung tâm và van.</p>'),('vi',5,'Bộ Má Phanh Cao Cấp',NULL,'Má phanh gốm ít bụi với miếng đệm inox cho khả năng dừng êm ái và chắc chắn.','<p>Bộ má phanh trước được thiết kế cho việc lái xe hằng ngày và vận hành mạnh mẽ. Giảm tới 80 phần trăm bụi phanh so với má phanh OE.</p>'),('vi',6,'Lọc Gió Điều Hòa',NULL,'Lọc gió cabin than hoạt tính giữ lại phấn hoa, bụi và mùi khí thải.','<p>Lọc ba lớp giữ lại các hạt nhỏ tới 0,3 micron. Khuyến nghị thay thế sau mỗi 15.000 dặm.</p>'),('vi',7,'Lọc Dầu Hiệu Năng Cao',NULL,'Lọc dầu lõi tổng hợp lưu lượng cao, phù hợp cho chu kỳ thay dầu kéo dài.','<p>Van chống chảy ngược và gioăng silicone đảm bảo bảo vệ khi khởi động nguội. Tương thích với dầu tổng hợp và dầu thường.</p>'),('vi',8,'Bóng Đèn Pha LED',NULL,'Cặp bóng đèn LED chuyển đổi 10.000 lumen với quạt làm mát êm ái.','<p>Nhiệt độ màu ánh sáng ban ngày 6500K, lắp đặt cắm-là-chạy, tương thích CANBus trên hầu hết các xe. Tuổi thọ 50.000 giờ.</p>'),('vi',9,'Đĩa Phanh Thông Gió',NULL,'Đĩa phanh thông gió khoan lỗ và xẻ rãnh cho khả năng phanh mát hơn, ổn định hơn.','<p>Lớp phủ kẽm chống ăn mòn và cấu tạo cân bằng. Giao hàng dạng đĩa đơn; đặt theo cặp khi bảo dưỡng cả cầu xe.</p>'),('vi',10,'Bơm Trợ Lực Lái',NULL,'Bơm trợ lực lái tái chế được kiểm tra theo tiêu chuẩn OE.','<p>Bao gồm bình chứa, puli và bộ phớt mới. Bảo hành 2 năm không giới hạn số dặm.</p>'),('vi',11,'Gioăng Mặt Máy',NULL,'Gioăng mặt máy bằng thép đa lớp được thiết kế cho động cơ tỷ số nén cao.','<p>Cấu tạo MLS chuẩn OE chịu được chu kỳ nhiệt và áp suất buồng đốt. Kèm theo hướng dẫn trình tự siết lực.</p>'),('vi',12,'Gioăng Mặt Máy',NULL,'Gioăng mặt máy bằng thép đa lớp được thiết kế cho động cơ tỷ số nén cao.','<p>Cấu tạo MLS chuẩn OE chịu được chu kỳ nhiệt và áp suất buồng đốt. Kèm theo hướng dẫn trình tự siết lực.</p>'),('vi',13,'Lọc Gió Điều Hòa',NULL,'Lọc gió cabin than hoạt tính giữ lại phấn hoa, bụi và mùi khí thải.','<p>Lọc ba lớp giữ lại các hạt nhỏ tới 0,3 micron. Khuyến nghị thay thế sau mỗi 15.000 dặm.</p>'),('vi',14,'Lọc Gió Điều Hòa',NULL,'Lọc gió cabin than hoạt tính giữ lại phấn hoa, bụi và mùi khí thải.','<p>Lọc ba lớp giữ lại các hạt nhỏ tới 0,3 micron. Khuyến nghị thay thế sau mỗi 15.000 dặm.</p>'),('vi',15,'Lọc Gió Điều Hòa',NULL,'Lọc gió cabin than hoạt tính giữ lại phấn hoa, bụi và mùi khí thải.','<p>Lọc ba lớp giữ lại các hạt nhỏ tới 0,3 micron. Khuyến nghị thay thế sau mỗi 15.000 dặm.</p>'),('vi',16,'Bóng Đèn Pha LED',NULL,'Cặp bóng đèn LED chuyển đổi 10.000 lumen với quạt làm mát êm ái.','<p>Nhiệt độ màu ánh sáng ban ngày 6500K, lắp đặt cắm-là-chạy, tương thích CANBus trên hầu hết các xe. Tuổi thọ 50.000 giờ.</p>'),('vi',17,'Bóng Đèn Pha LED',NULL,'Cặp bóng đèn LED chuyển đổi 10.000 lumen với quạt làm mát êm ái.','<p>Nhiệt độ màu ánh sáng ban ngày 6500K, lắp đặt cắm-là-chạy, tương thích CANBus trên hầu hết các xe. Tuổi thọ 50.000 giờ.</p>'),('vi',18,'Đĩa Phanh Thông Gió',NULL,'Đĩa phanh thông gió khoan lỗ và xẻ rãnh cho khả năng phanh mát hơn, ổn định hơn.','<p>Lớp phủ kẽm chống ăn mòn và cấu tạo cân bằng. Giao hàng dạng đĩa đơn; đặt theo cặp khi bảo dưỡng cả cầu xe.</p>'),('vi',19,'Đĩa Phanh Thông Gió',NULL,'Đĩa phanh thông gió khoan lỗ và xẻ rãnh cho khả năng phanh mát hơn, ổn định hơn.','<p>Lớp phủ kẽm chống ăn mòn và cấu tạo cân bằng. Giao hàng dạng đĩa đơn; đặt theo cặp khi bảo dưỡng cả cầu xe.</p>'),('vi',20,'Đĩa Phanh Thông Gió',NULL,'Đĩa phanh thông gió khoan lỗ và xẻ rãnh cho khả năng phanh mát hơn, ổn định hơn.','<p>Lớp phủ kẽm chống ăn mòn và cấu tạo cân bằng. Giao hàng dạng đĩa đơn; đặt theo cặp khi bảo dưỡng cả cầu xe.</p>'),('vi',21,'Bơm Trợ Lực Lái',NULL,'Bơm trợ lực lái tái chế được kiểm tra theo tiêu chuẩn OE.','<p>Bao gồm bình chứa, puli và bộ phớt mới. Bảo hành 2 năm không giới hạn số dặm.</p>'),('vi',22,'Bơm Trợ Lực Lái',NULL,'Bơm trợ lực lái tái chế được kiểm tra theo tiêu chuẩn OE.','<p>Bao gồm bình chứa, puli và bộ phớt mới. Bảo hành 2 năm không giới hạn số dặm.</p>'),('vi',23,'Bơm Trợ Lực Lái',NULL,'Bơm trợ lực lái tái chế được kiểm tra theo tiêu chuẩn OE.','<p>Bao gồm bình chứa, puli và bộ phớt mới. Bảo hành 2 năm không giới hạn số dặm.</p>'),('vi',24,'Bơm Trợ Lực Lái',NULL,'Bơm trợ lực lái tái chế được kiểm tra theo tiêu chuẩn OE.','<p>Bao gồm bình chứa, puli và bộ phớt mới. Bảo hành 2 năm không giới hạn số dặm.</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=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_reviews` VALUES (1,9,NULL,NULL,2,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 18:58:40','2026-05-28 18:58:40',NULL),(2,5,NULL,NULL,3,2,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(3,9,NULL,NULL,5,1,'Best ecommerce CMS online store!','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(4,5,NULL,NULL,2,5,'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 18:58:40','2026-05-28 18:58:40',NULL),(5,4,NULL,NULL,7,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 18:58:40','2026-05-28 18:58:40',NULL),(6,6,NULL,NULL,7,3,'Clean & perfect source code','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(7,6,NULL,NULL,10,4,'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 18:58:40','2026-05-28 18:58:40',NULL),(8,3,NULL,NULL,6,3,'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 18:58:40','2026-05-28 18:58:40',NULL),(9,5,NULL,NULL,4,2,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(10,4,NULL,NULL,9,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 18:58:40','2026-05-28 18:58:40',NULL),(11,10,NULL,NULL,2,5,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(12,8,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 18:58:40','2026-05-28 18:58:40',NULL),(13,2,NULL,NULL,3,5,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(14,6,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 18:58:40','2026-05-28 18:58:40',NULL),(15,3,NULL,NULL,9,5,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(16,8,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 18:58:40','2026-05-28 18:58:40',NULL),(17,2,NULL,NULL,9,1,'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 18:58:40','2026-05-28 18:58:40',NULL),(18,4,NULL,NULL,4,4,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(19,6,NULL,NULL,8,1,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(20,1,NULL,NULL,7,5,'Clean & perfect source code','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(21,2,NULL,NULL,1,4,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(22,5,NULL,NULL,9,5,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(23,2,NULL,NULL,7,2,'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 18:58:40','2026-05-28 18:58:40',NULL),(24,1,NULL,NULL,5,2,'Best ecommerce CMS online store!','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(25,10,NULL,NULL,10,4,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(26,4,NULL,NULL,1,1,'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 18:58:40','2026-05-28 18:58:40',NULL),(27,9,NULL,NULL,6,2,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(28,4,NULL,NULL,2,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 18:58:40','2026-05-28 18:58:40',NULL),(29,3,NULL,NULL,1,4,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(30,9,NULL,NULL,8,4,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(31,6,NULL,NULL,1,5,'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 18:58:40','2026-05-28 18:58:40',NULL),(32,5,NULL,NULL,7,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 18:58:40','2026-05-28 18:58:40',NULL),(33,10,NULL,NULL,8,5,'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 18:58:40','2026-05-28 18:58:40',NULL),(34,7,NULL,NULL,9,2,'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 18:58:40','2026-05-28 18:58:40',NULL),(35,7,NULL,NULL,6,1,'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 18:58:40','2026-05-28 18:58:40',NULL),(36,1,NULL,NULL,9,1,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(37,3,NULL,NULL,8,3,'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 18:58:40','2026-05-28 18:58:40',NULL),(38,8,NULL,NULL,6,1,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(39,4,NULL,NULL,6,3,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(40,9,NULL,NULL,10,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 18:58:40','2026-05-28 18:58:40',NULL),(41,1,NULL,NULL,6,3,'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 18:58:40','2026-05-28 18:58:40',NULL),(42,8,NULL,NULL,5,1,'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 18:58:40','2026-05-28 18:58:40',NULL),(43,8,NULL,NULL,10,2,'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 18:58:40','2026-05-28 18:58:40',NULL),(44,10,NULL,NULL,4,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 18:58:40','2026-05-28 18:58:40',NULL),(45,6,NULL,NULL,4,1,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(46,10,NULL,NULL,7,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 18:58:40','2026-05-28 18:58:40',NULL),(47,10,NULL,NULL,1,1,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(48,7,NULL,NULL,1,4,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(49,4,NULL,NULL,3,3,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(50,8,NULL,NULL,8,5,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(51,3,NULL,NULL,5,3,'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 18:58:40','2026-05-28 18:58:40',NULL),(52,2,NULL,NULL,2,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 18:58:40','2026-05-28 18:58:40',NULL),(53,7,NULL,NULL,5,1,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(54,7,NULL,NULL,8,3,'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 18:58:40','2026-05-28 18:58:40',NULL),(55,2,NULL,NULL,6,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 18:58:40','2026-05-28 18:58:40',NULL),(56,3,NULL,NULL,4,5,'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 18:58:40','2026-05-28 18:58:40',NULL),(57,5,NULL,NULL,5,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 18:58:40','2026-05-28 18:58:40',NULL),(58,9,NULL,NULL,1,3,'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 18:58:40','2026-05-28 18:58:40',NULL),(59,6,NULL,NULL,6,4,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(60,2,NULL,NULL,10,4,'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 18:58:40','2026-05-28 18:58:40',NULL),(61,3,NULL,NULL,3,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 18:58:40','2026-05-28 18:58:40',NULL),(62,9,NULL,NULL,7,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 18:58:40','2026-05-28 18:58:40',NULL),(63,10,NULL,NULL,9,1,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(64,5,NULL,NULL,1,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 18:58:40','2026-05-28 18:58:40',NULL),(65,5,NULL,NULL,8,1,'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 18:58:40','2026-05-28 18:58:40',NULL),(66,2,NULL,NULL,5,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 18:58:40','2026-05-28 18:58:40',NULL),(67,8,NULL,NULL,2,4,'Best ecommerce CMS online store!','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(68,5,NULL,NULL,10,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 18:58:40','2026-05-28 18:58:40',NULL),(69,8,NULL,NULL,7,4,'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 18:58:40','2026-05-28 18:58:40',NULL),(70,1,NULL,NULL,2,4,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(71,8,NULL,NULL,9,2,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(72,6,NULL,NULL,2,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 18:58:40','2026-05-28 18:58:40',NULL),(73,10,NULL,NULL,3,5,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(74,7,NULL,NULL,2,3,'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 18:58:40','2026-05-28 18:58:40',NULL),(75,5,NULL,NULL,6,4,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(76,1,NULL,NULL,1,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 18:58:40','2026-05-28 18:58:40',NULL),(77,10,NULL,NULL,6,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 18:58:40','2026-05-28 18:58:40',NULL),(78,3,NULL,NULL,10,3,'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 18:58:40','2026-05-28 18:58:40',NULL),(79,2,NULL,NULL,8,5,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(80,8,NULL,NULL,4,1,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(81,4,NULL,NULL,5,4,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(82,9,NULL,NULL,9,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 18:58:40','2026-05-28 18:58:40',NULL),(83,2,NULL,NULL,4,4,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(84,1,NULL,NULL,10,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 18:58:40','2026-05-28 18:58:40',NULL),(85,7,NULL,NULL,4,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 18:58:40','2026-05-28 18:58:40',NULL),(86,7,NULL,NULL,3,4,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(87,9,NULL,NULL,3,5,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(88,4,NULL,NULL,8,2,'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 18:58:40','2026-05-28 18:58:40',NULL),(89,3,NULL,NULL,2,2,'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 18:58:40','2026-05-28 18:58:40',NULL),(90,6,NULL,NULL,9,3,'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 18:58:40','2026-05-28 18:58:40',NULL),(91,3,NULL,NULL,7,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 18:58:40','2026-05-28 18:58:40',NULL),(92,1,NULL,NULL,3,1,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(93,7,NULL,NULL,10,5,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(94,9,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 18:58:40','2026-05-28 18:58:40',NULL),(95,1,NULL,NULL,8,2,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(96,7,NULL,NULL,7,4,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(97,4,NULL,NULL,10,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 18:58:40','2026-05-28 18:58:40',NULL),(98,6,NULL,NULL,3,3,'Best ecommerce CMS online store!','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',NULL),(99,1,NULL,NULL,4,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 18:58:40','2026-05-28 18:58:40',NULL),(100,10,NULL,NULL,5,5,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','auto','2026-05-28 18:58:40','2026-05-28 18:58:40',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 18:58:40','2026-05-28 18:58:40'),(2,'International',NULL,'2026-05-28 18:58:40','2026-05-28 18:58:40');

--
-- 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 18:58:40','2026-05-28 18:58:40'),(2,'Standard (3-5 business days)',1,'based_on_price',0.00,NULL,7.99,'2026-05-28 18:58:40','2026-05-28 18:58:40'),(3,'Express (1-2 business days)',1,'based_on_price',0.00,NULL,19.99,'2026-05-28 18:58:40','2026-05-28 18:58:40'),(4,'Local Pickup',1,'based_on_price',0.00,NULL,0.00,'2026-05-28 18:58:40','2026-05-28 18:58:40'),(5,'International Standard (7-12 days)',2,'based_on_price',0.00,NULL,24.99,'2026-05-28 18:58:40','2026-05-28 18:58:40'),(6,'International Express (3-5 days)',2,'based_on_price',0.00,NULL,49.99,'2026-05-28 18:58:40','2026-05-28 18:58:40');

--
-- 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 18:58:28','2026-05-28 18:58:28',NULL,NULL),(2,1,'Origin','text',NULL,'Made in Portugal','2026-05-28 18:58:28','2026-05-28 18:58:28',NULL,NULL),(3,1,'Care','text',NULL,'Machine wash cold. Tumble dry low. Do not bleach.','2026-05-28 18:58:28','2026-05-28 18:58:28',NULL,NULL),(4,2,'Designed In','text',NULL,'Barcelona, Spain','2026-05-28 18:58:28','2026-05-28 18:58:28',NULL,NULL),(5,2,'Warranty','text',NULL,'12 months manufacturer warranty','2026-05-28 18:58:28','2026-05-28 18:58:28',NULL,NULL),(6,2,'Made From Recycled Materials','checkbox',NULL,'1','2026-05-28 18:58:28','2026-05-28 18:58:28',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 18:58:28','2026-05-28 18:58:28',NULL,NULL),(2,'Product Details','Provenance, warranty and sustainability.','2026-05-28 18:58:28','2026-05-28 18:58:28',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 18:58:28','2026-05-28 18:58:28',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 18:58:28','2026-05-28 18:58:28','Everything about placing, tracking, and receiving your order.'),(2,'Returns &amp; Refunds',1,'published','2026-05-28 18:58:28','2026-05-28 18:58:28','Our 30-day return policy and how to start a return.'),(3,'Products &amp; Stock',2,'published','2026-05-28 18:58:28','2026-05-28 18:58:28','Sizing, materials, restocks, and product care.'),(4,'Account &amp; Payment',3,'published','2026-05-28 18:58:28','2026-05-28 18:58:28','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;

--
