--
-- 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,'WtFtjujEGZ3hX6zGUlXJ8vu5YXBOqjrs',1,'2026-05-28 19:02:09','2026-05-28 19:02:09','2026-05-28 19:02:09');

--
-- 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,'New Releases',0,'Hands-on first looks and launch coverage of the latest gadgets and gear.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2026-05-28 19:02:10','2026-05-28 19:02:10'),(2,'Tech Reviews',0,'In-depth, no-hype reviews of phones, audio, wearables, and creator gear.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:02:10','2026-05-28 19:02:10'),(3,'Smart Home',0,'Practical guides for building and automating a smarter, calmer home.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:02:10','2026-05-28 19:02:10'),(4,'Buying Guides',0,'Buying advice that compares specs, value, and real-world use.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:02:10','2026-05-28 19:02:10'),(5,'Lifestyle',0,'Tips and rituals for using technology with intention every day.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:02:10','2026-05-28 19:02:10');

--
-- 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,'المنزل الذكي','دليل عملي لبناء وأتمتة منزل أكثر ذكاءً وأمانًا.'),('ar',4,'أدلة الشراء','يساعدك دليل المقارنة المستقل على اختيار المنتج المناسب لاحتياجاتك وميزانيتك.'),('ar',5,'نمط الحياة','نصائح وعادات لاستخدام التكنولوجيا عمدا كل يوم.'),('fr',1,'Nouveautés','Obtenez une première expérience pratique et lancez une couverture des derniers gadgets et appareils.'),('fr',2,'Avis techniques','Examens approfondis et sans battage médiatique des téléphones, des systèmes audio, des appareils portables et du matériel de création.'),('fr',3,'Maison intelligente','Un guide pratique pour construire et automatiser une maison plus intelligente et plus sûre.'),('fr',4,'Guides d\'achat','Un guide de comparaison indépendant vous aide à choisir le produit adapté à vos besoins et à votre budget.'),('fr',5,'Mode de vie','Conseils et habitudes pour utiliser la technologie intentionnellement au quotidien.'),('id',1,'Rilis Baru','Dapatkan pengalaman langsung pertama dan luncurkan liputan gadget dan perangkat terbaru.'),('id',2,'Ulasan Teknologi','Ulasan mendalam dan tanpa sensasi tentang ponsel, audio, perangkat yang dapat dikenakan, dan perlengkapan pembuat konten.'),('id',3,'Rumah Pintar','Panduan praktis untuk membangun dan mengotomatisasi rumah yang lebih cerdas dan aman.'),('id',4,'Panduan Membeli','Panduan perbandingan independen membantu Anda memilih produk yang tepat sesuai kebutuhan dan anggaran Anda.'),('id',5,'Gaya hidup','Tips dan kebiasaan memanfaatkan teknologi dengan sengaja setiap hari.'),('tr',1,'Yeni Çıkanlar','İlk uygulamalı deneyimi edinin ve en yeni gadget ve cihazların kapsamını başlatın.'),('tr',2,'Teknik İncelemeler','Telefonlar, ses cihazları, giyilebilir cihazlar ve içerik oluşturucu donanımları hakkında derinlemesine, abartılı olmayan incelemeler.'),('tr',3,'Akıllı Ev','Daha akıllı, daha güvenli bir ev inşa etmek ve otomatikleştirmek için pratik bir kılavuz.'),('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,'Yaşam Tarzı','Teknolojiyi her gün bilinçli olarak kullanmaya yönelik ipuçları ve alışkanlıklar.'),('vi',1,'Sản Phẩm Mới Ra Mắt','Trải nghiệm thực tế đầu tiên và đưa tin ra mắt về những gadget và thiết bị mới nhất.'),('vi',2,'Đánh Giá Công Nghệ','Đánh giá chuyên sâu, không thổi phồng về điện thoại, âm thanh, thiết bị đeo và đồ cho người sáng tạo.'),('vi',3,'Nhà Thông Minh','Hướng dẫn thực tế để xây dựng và tự động hóa một ngôi nhà thông minh, an yên hơ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,'Phong Cách Sống','Mẹo và thói quen để sử dụng công nghệ một cách có chủ đích mỗi ngày.');

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

CREATE TABLE `cities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state_id` bigint unsigned DEFAULT NULL,
  `country_id` bigint unsigned DEFAULT NULL,
  `record_id` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `zip_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cities_slug_unique` (`slug`),
  KEY `idx_cities_name` (`name`),
  KEY `idx_cities_state_status` (`state_id`,`status`),
  KEY `idx_cities_status` (`status`),
  KEY `idx_cities_state_id` (`state_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `cities_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cities_id` bigint unsigned NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`cities_id`),
  KEY `idx_cities_trans_city_lang` (`cities_id`,`lang_code`),
  KEY `idx_cities_trans_name` (`name`),
  KEY `idx_cities_trans_cities_id` (`cities_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `contact_custom_field_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `custom_field_id` bigint unsigned NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL DEFAULT '999',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_custom_field_options`
--


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

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

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


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

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

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


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

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

--
-- Dumping data for table `contact_custom_fields_translations`
--


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

CREATE TABLE `contact_replies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_replies`
--


--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_fields` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unread',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--
-- 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 19:02:10','2026-05-28 19:02:10'),(2,'Anvouge','Modern fashion essentials cut from sustainable fibers.','https://example.com/anvouge','brands/anvouge.png','published',1,1,'2026-05-28 19:02:10','2026-05-28 19:02:10'),(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 19:02:10','2026-05-28 19:02:10'),(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 19:02:10','2026-05-28 19:02:10'),(5,'Cheryl','Bold prints and silhouettes for the contemporary woman.','https://example.com/cheryl','brands/cheryl.png','published',4,0,'2026-05-28 19:02:10','2026-05-28 19:02:10'),(6,'Crate','Mid-century-inspired furniture built to last generations.','https://example.com/crate','brands/crate.png','published',5,1,'2026-05-28 19:02:10','2026-05-28 19:02:10'),(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 19:02:10','2026-05-28 19:02:10'),(8,'Intdeco','Interior accents that bridge minimalism and warmth.','https://example.com/intdeco','brands/intdeco.png','published',7,0,'2026-05-28 19:02:10','2026-05-28 19:02:10'),(9,'Modave','Performance activewear made with recycled high-stretch knits.','https://example.com/modave','brands/modave.png','published',8,0,'2026-05-28 19:02:10','2026-05-28 19:02:10'),(10,'Panadoxn','Botanical skincare formulated by clinical herbalists.','https://example.com/panadoxn','brands/panadoxn.png','published',9,0,'2026-05-28 19:02:10','2026-05-28 19:02:10'),(11,'Shangxi','Heritage tea, ceramics, and meditation accessories.','https://example.com/shangxi','brands/shangxi.png','published',10,0,'2026-05-28 19:02:10','2026-05-28 19:02:10'),(12,'Sopify','Smart home devices designed for renters and travelers.','https://example.com/sopify','brands/sopify.png','published',11,0,'2026-05-28 19:02:10','2026-05-28 19:02:10');

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

--
-- 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-0103','US','Arizona','Dallas','369 Cherry Circle',1,1,'2026-05-28 19:02:19','2026-05-28 19:02:19','19101'),(2,'Emma Collins','customer@botble.com','+1-555-0107','AU','Ohio','Chicago','456 Oak Avenue',1,0,'2026-05-28 19:02:19','2026-05-28 19:02:19','85001'),(3,'Sophia Ramirez','vendor@botble.com','+1-555-0102','DE','Michigan','Los Angeles','741 Spruce Street',2,1,'2026-05-28 19:02:19','2026-05-28 19:02:19','19101'),(4,'Sophia Ramirez','vendor@botble.com','+1-555-0104','DE','Texas','Dallas','789 Pine Road',2,0,'2026-05-28 19:02:19','2026-05-28 19:02:19','10001'),(5,'Olivia Carter','customer1@example.com','+1-555-0108','AU','Arizona','Chicago','369 Cherry Circle',3,1,'2026-05-28 19:02:19','2026-05-28 19:02:19','48201'),(6,'Ava Mitchell','customer2@example.com','+1-555-0108','GB','Georgia','Denver','147 Elm Court',4,1,'2026-05-28 19:02:19','2026-05-28 19:02:19','19101'),(7,'Isabella Brooks','customer3@example.com','+1-555-0108','US','Ohio','Denver','654 Cedar Lane',5,1,'2026-05-28 19:02:20','2026-05-28 19:02:20','90210'),(8,'James Whitfield','customer4@example.com','+1-555-0110','CA','Texas','New York','456 Oak Avenue',6,1,'2026-05-28 19:02:20','2026-05-28 19:02:20','80201'),(9,'Liam Bennett','customer5@example.com','+1-555-0101','CA','Ohio','Miami','147 Elm Court',7,1,'2026-05-28 19:02:20','2026-05-28 19:02:20','77001'),(10,'Noah Patterson','customer6@example.com','+1-555-0109','CA','Ohio','Phoenix','147 Elm Court',8,1,'2026-05-28 19:02:20','2026-05-28 19:02:20','30301'),(11,'Charlotte Reed','customer7@example.com','+1-555-0105','CA','Texas','Los Angeles','258 Walnut Way',9,1,'2026-05-28 19:02:21','2026-05-28 19:02:21','33101'),(12,'Amelia Foster','customer8@example.com','+1-555-0107','AU','Michigan','Austin','456 Oak Avenue',10,1,'2026-05-28 19:02:21','2026-05-28 19:02:21','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$s9N2NdzWsV537eyxpcBTkuI.r7o93r960oKcEA.bhrBhO2SkwAxj2','testimonials/avatar-1.jpg','1986-05-16','regular',NULL,'+1-555-0101',NULL,'2026-05-28 19:02:19','2026-05-28 19:02:19','2026-05-29 02:02:19',NULL,0,NULL,'activated',NULL,NULL,NULL,0),(2,'Sophia Ramirez','vendor@botble.com','$2y$12$zBcAKN6RapnOssqPmFvRqeuhrofp/Ivci6TXadlOkg3ewBFMNcuzq','testimonials/avatar-2.jpg','1979-05-08','regular',NULL,'+1-555-0102',NULL,'2026-05-28 19:02:19','2026-05-28 19:02:21','2026-05-29 02:02:19',NULL,1,'2026-05-29 02:02:21','activated',NULL,NULL,NULL,0),(3,'Olivia Carter','customer1@example.com','$2y$12$5agyQMbowwYPj5.RZqrNwOawhZKeDvXeeqPICuSk0guyHJfggc2c2','testimonials/avatar-3.jpg','1987-05-22','regular',NULL,'+1-555-0109',NULL,'2026-05-28 19:02:19','2026-05-28 19:02:21','2026-05-29 02:02:19',NULL,1,'2026-05-29 02:02:21','activated',NULL,NULL,NULL,0),(4,'Ava Mitchell','customer2@example.com','$2y$12$MASLu6h.gzdH0jRRA30Ws.pTY.NobHtqPdyPIQNQ1LFCU.e3K6Eji','testimonials/avatar-4.jpg','1995-05-04','regular',NULL,'+1-555-0106',NULL,'2026-05-28 19:02:19','2026-05-28 19:02:22','2026-05-29 02:02:19',NULL,1,'2026-05-29 02:02:21','activated',NULL,NULL,NULL,0),(5,'Isabella Brooks','customer3@example.com','$2y$12$NdDAoTpjRUAyM42jP9AXO..HGRnZohGCi60HYicpqGZcBlw8HQp6W','testimonials/avatar-5.jpg','1997-05-17','regular',NULL,'+1-555-0102',NULL,'2026-05-28 19:02:20','2026-05-28 19:02:22','2026-05-29 02:02:19',NULL,1,'2026-05-29 02:02:21','activated',NULL,NULL,NULL,0),(6,'James Whitfield','customer4@example.com','$2y$12$Cs.GVMnV0RPzvnW/G2LjBOnBTdyJAIl5yl6OE7uGMGA0L6fyRpZrC','testimonials/avatar-6.jpg','1997-05-20','regular',NULL,'+1-555-0110',NULL,'2026-05-28 19:02:20','2026-05-28 19:02:22','2026-05-29 02:02:19',NULL,1,'2026-05-29 02:02:21','activated',NULL,NULL,NULL,0),(7,'Liam Bennett','customer5@example.com','$2y$12$4ojKEC0luKdbjZ.lMnxuhegA0MTG/PMowCn.kMqikQpmq.BxRsRfS','testimonials/avatar-7.jpg','2001-05-21','regular',NULL,'+1-555-0107',NULL,'2026-05-28 19:02:20','2026-05-28 19:02:22','2026-05-29 02:02:19',NULL,1,'2026-05-29 02:02:21','activated',NULL,NULL,NULL,0),(8,'Noah Patterson','customer6@example.com','$2y$12$PcJgMSjtwVyEBFsZAJgkPusKUFNe1jTQ9HF.JeqDPPs9/9KUEJ7Yy','testimonials/avatar-8.jpg','1978-05-03','regular',NULL,'+1-555-0104',NULL,'2026-05-28 19:02:20','2026-05-28 19:02:23','2026-05-29 02:02:19',NULL,1,'2026-05-29 02:02:21','activated',NULL,NULL,NULL,0),(9,'Charlotte Reed','customer7@example.com','$2y$12$AlhvswDHKqu3JhbNrzWwxeX401sDpdJ.gjAsnW4sRZrNGQDYiHc6q','testimonials/avatar-9.jpg','1991-05-06','regular',NULL,'+1-555-0104',NULL,'2026-05-28 19:02:21','2026-05-28 19:02:23','2026-05-29 02:02:19',NULL,1,'2026-05-29 02:02:21','activated',NULL,NULL,NULL,0),(10,'Amelia Foster','customer8@example.com','$2y$12$JdRmBnOuDJkTKTVqeVy59eya4CMOB5X8uQ6JS7.VHGROkbI8hpfKu','testimonials/avatar-10.jpg','2004-05-10','regular',NULL,'+1-555-0106',NULL,'2026-05-28 19:02:21','2026-05-28 19:02:23','2026-05-29 02:02:19',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 02:02:21','2026-07-28 02:02:21',NULL,0,10,'coupon',0,0,NULL,NULL,'percentage','all-orders',0.00,0,1,'2026-05-28 19:02:21','2026-05-28 19:02:21',NULL,'A welcome discount for first-time shoppers — 10% off any order.'),(2,'Free Shipping Over $50','FREESHIP','2026-05-28 02:02:21',NULL,NULL,0,100,'coupon',0,0,NULL,NULL,'shipping','all-orders',50.00,0,1,'2026-05-28 19:02:21','2026-05-28 19:02:21',NULL,'Free shipping on any order $50 or above.'),(3,'Spring Sale — $25 Off','SPRING25','2026-05-28 02:02:21','2026-06-28 02:02:21',500,0,25,'coupon',0,0,NULL,NULL,'amount','all-orders',150.00,0,1,'2026-05-28 19:02:21','2026-05-28 19:02:21',NULL,'A flat $25 off orders over $150.'),(4,'VIP Member 20% Off','VIP20','2026-05-28 02:02:21','2026-08-27 02:02:21',NULL,0,20,'coupon',0,0,NULL,NULL,'percentage','all-orders',100.00,0,1,'2026-05-28 19:02:21','2026-05-28 19:02:21',NULL,'Exclusive 20% off for newsletter subscribers.'),(5,'Bundle & Save $50','BUNDLE50','2026-05-28 02:02:21','2026-07-13 02:02:21',NULL,0,50,'coupon',0,0,NULL,NULL,'amount','all-orders',300.00,0,1,'2026-05-28 19:02:21','2026-05-28 19:02:21',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,8,279.3,50,0),(1,5,69.3,50,0),(1,6,62.3,50,0),(1,3,34.3,50,0),(1,1,909.3,50,0),(1,9,629.3,50,0),(1,10,27.3,50,0),(1,4,174.3,50,0),(1,2,300.3,50,0),(1,7,20.3,50,0),(2,1,974.25,75,0),(2,4,186.75,75,0),(2,9,674.25,75,0),(2,6,66.75,75,0),(2,10,29.25,75,0),(2,5,74.25,75,0),(2,3,36.75,75,0),(2,8,299.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 02:02:21','published','2026-05-28 19:02:21','2026-05-28 19:02:21'),(2,'Weekend Doorbusters','2026-06-03 02:02:21','published','2026-05-28 19:02:21','2026-05-28 19:02:21');

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

--
-- 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 19:02:10','2026-05-28 19:02:10',1),(2,'Size','size','text',1,1,1,'published',1,'2026-05-28 19:02:10','2026-05-28 19:02:10',0),(3,'Material','material','text',1,1,1,'published',2,'2026-05-28 19:02:10','2026-05-28 19:02:10',0);

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

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

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

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

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

CREATE TABLE `ec_product_attributes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `attribute_set_id` bigint unsigned NOT NULL,
  `title` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `order` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attribute_set_status_index` (`attribute_set_id`),
  KEY `idx_attribute_set_id` (`attribute_set_id`),
  KEY `idx_attribute_set_order_id` (`attribute_set_id`,`order`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

INSERT INTO `ec_product_categories` VALUES (1,'Learn More',NULL,0,'Featured electronics curation — explore the latest gear, accessories, and gadgets.','published',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/categories/cate-1.jpg',1,'2026-05-28 19:02:11','2026-05-28 19:02:11',NULL,NULL),(2,'Smart Watches',NULL,0,'Fitness trackers, smartwatches, and wearables that pair with your daily routine.','published',1,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/categories/cate-2.jpg',1,'2026-05-28 19:02:11','2026-05-28 19:02:11',NULL,NULL),(3,'EarPhone',NULL,0,'True wireless earbuds and in-ear monitors with rich sound and long battery life.','published',2,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/categories/cate-3.jpg',1,'2026-05-28 19:02:11','2026-05-28 19:02:11',NULL,NULL),(4,'Headphone',NULL,0,'Over-ear, on-ear, and active noise-cancelling headphones for everyday and studio listening.','published',3,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/categories/cate-4.jpg',1,'2026-05-28 19:02:11','2026-05-28 19:02:11',NULL,NULL),(5,'Speaker',NULL,0,'Portable Bluetooth speakers and home audio for room-filling sound anywhere.','published',4,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/categories/cate-5.jpg',1,'2026-05-28 19:02:12','2026-05-28 19:02:12',NULL,NULL),(6,'Smart Lamp',NULL,0,'Wi-Fi smart lighting with adjustable warmth, color, and voice-assistant integration.','published',5,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/categories/cate-6.jpg',1,'2026-05-28 19:02:12','2026-05-28 19:02:12',NULL,NULL),(7,'Cable',NULL,0,'USB-C, Lightning, and braided charging cables built to last.','published',6,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/categories/cate-7.jpg',1,'2026-05-28 19:02:12','2026-05-28 19:02:12',NULL,NULL),(8,'Accessories',NULL,0,'Phone stands, hubs, sleeves, and everyday-carry essentials for your gear.','published',7,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/categories/cate-8.jpg',1,'2026-05-28 19:02:12','2026-05-28 19:02:12',NULL,NULL),(9,'Mouse',NULL,0,'Computer mice and pointer accessories for daily workstations.','published',8,NULL,0,'2026-05-28 19:02:12','2026-05-28 19:02:12',NULL,NULL),(10,'Keyboard',NULL,0,'Keyboard accessories and creator desk essentials.','published',9,NULL,0,'2026-05-28 19:02:12','2026-05-28 19:02:12',NULL,NULL),(11,'Mousepad',NULL,0,'Desk mats, charging pads, and workspace surfaces.','published',10,NULL,0,'2026-05-28 19:02:12','2026-05-28 19:02:12',NULL,NULL),(12,'Networking',NULL,0,'Connected smart-home and networking accessories.','published',11,NULL,0,'2026-05-28 19:02:12','2026-05-28 19:02:12',NULL,NULL);

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

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

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

INSERT INTO `ec_product_categories_translations` VALUES ('ar',1,'يتعلم أكثر',NULL,'مجموعة مختارة من الأجهزة الإلكترونية المميزة - اكتشف أحدث الأجهزة والملحقات والأدوات الذكية.'),('ar',2,'الساعات الذكية',NULL,'ترتبط عصابات اللياقة البدنية والساعات الذكية والأجهزة القابلة للارتداء بروتينك اليومي.'),('ar',3,'سماعة',NULL,'سماعات أذن لاسلكية حقيقية تتميز بصوت غني وعمر بطارية طويل.'),('ar',4,'سماعة الرأس',NULL,'سماعات رأس توضع فوق الأذن مع خاصية إلغاء الضوضاء النشطة للاستماع إلى الموسيقى يوميًا وفي الاستوديو.'),('ar',5,'المتحدث',NULL,'مكبر صوت بلوتوث محمول وصوت منزلي للحصول على صوت يملأ الغرفة في أي مكان.'),('ar',6,'المصباح الذكي',NULL,'مصباح ذكي مزود بتقنية Wi-Fi مع دفء قابل للتعديل ولون ومساعد افتراضي متكامل.'),('ar',7,'كابل',NULL,'تم تصميم كابلات الشحن USB-C وLightning والمحمية لتدوم طويلاً.'),('ar',8,'مُكَمِّلات',NULL,'حقائب اليد والمحافظ والأحزمة والمجوهرات لإكمال أي ملابس.'),('ar',9,'الفأر',NULL,'فأرة الكمبيوتر وملحقات المؤشر لمساحة العمل اليومية.'),('ar',10,'لوحة المفاتيح',NULL,'ملحقات لوحة المفاتيح والأساسيات لمكتب المبدع.'),('ar',11,'لوحة الماوس',NULL,'الحصائر المكتبية وأرصفة الشحن وأسطح العمل.'),('ar',12,'الشبكات',NULL,'ملحقات المنزل الذكي والشبكات المتصلة.'),('fr',1,'Apprendre encore plus',NULL,'Sélection d\'appareils électroniques en vedette : découvrez les derniers appareils, accessoires et gadgets.'),('fr',2,'Montres intelligentes',NULL,'Les bracelets de fitness, les montres intelligentes et les appareils portables s\'intègrent à votre routine quotidienne.'),('fr',3,'Écouteur',NULL,'Véritables écouteurs sans fil et intra-auriculaires avec un son riche et une longue durée de vie de la batterie.'),('fr',4,'Casque',NULL,'Écouteurs supra-auriculaires avec suppression active du bruit pour l\'écoute musicale au quotidien et en studio.'),('fr',5,'Conférencier',NULL,'Haut-parleur Bluetooth portable et système audio domestique pour un son qui remplit la pièce n\'importe où.'),('fr',6,'Lampe intelligente',NULL,'Lampe intelligente Wi-Fi avec chaleur, couleur réglables et assistant virtuel intégré.'),('fr',7,'Câble',NULL,'Les câbles de chargement USB-C, Lightning et blindés sont conçus pour durer.'),('fr',8,'Accessoires',NULL,'Sacs à main, portefeuilles, ceintures et bijoux pour compléter n\'importe quelle tenue.'),('fr',9,'Souris',NULL,'Souris d\'ordinateur et accessoires de pointeur pour l\'espace de travail quotidien.'),('fr',10,'Clavier',NULL,'Accessoires de clavier et essentiels pour le bureau du créateur.'),('fr',11,'Tapis de souris',NULL,'Tapis de bureau, stations de chargement et surfaces de travail.'),('fr',12,'Réseautage',NULL,'Accessoires pour la maison intelligente et réseaux connectés.'),('id',1,'Pelajari Lebih Lanjut',NULL,'Pilihan elektronik unggulan — temukan perangkat, aksesori, dan gadget terbaru.'),('id',2,'Jam Tangan Pintar',NULL,'Gelang kebugaran, jam tangan pintar, dan perangkat yang dapat dikenakan sesuai dengan rutinitas harian Anda.'),('id',3,'Telepon Telinga',NULL,'Headphone nirkabel dan in-ear sejati dengan suara yang kaya dan masa pakai baterai yang lama.'),('id',4,'Headphone',NULL,'Headphone on-ear dengan peredam bising aktif untuk mendengarkan musik sehari-hari dan di studio.'),('id',5,'Pembicara',NULL,'Speaker Bluetooth portabel dan audio rumah untuk suara memenuhi ruangan di mana saja.'),('id',6,'Lampu Cerdas',NULL,'Lampu pintar Wi-Fi dengan kehangatan yang dapat disesuaikan, warna, dan asisten virtual terintegrasi.'),('id',7,'Kabel',NULL,'USB-C, Lightning, dan kabel pengisi daya berpelindung dibuat agar tahan lama.'),('id',8,'Aksesoris',NULL,'Tas tangan, dompet, ikat pinggang, dan perhiasan untuk melengkapi pakaian apa pun.'),('id',9,'Mouse',NULL,'Mouse komputer dan aksesoris penunjuk untuk ruang kerja sehari-hari.'),('id',10,'papan ketik',NULL,'Aksesori keyboard dan kebutuhan penting untuk meja pembuat.'),('id',11,'alas tetikus',NULL,'Alas meja, dok pengisi daya, dan permukaan kerja.'),('id',12,'Jaringan',NULL,'Aksesori rumah pintar dan jaringan yang terhubung.'),('tr',1,'Daha fazla bilgi edin',NULL,'Öne çıkan elektronik seçimi — en yeni cihazları, aksesuarları ve gadget\'ları keşfedin.'),('tr',2,'Akıllı Saatler',NULL,'Fitness bantları, akıllı saatler ve giyilebilir cihazlar günlük rutininize bağlanır.'),('tr',3,'Kulaklık',NULL,'Zengin ses ve uzun pil ömrüne sahip gerçek kablosuz ve kulak içi kulaklıklar.'),('tr',4,'Kulaklık',NULL,'Günlük müzik dinleme ve stüdyo için aktif gürültü engelleme özelliğine sahip kulak üstü kulaklıklar.'),('tr',5,'Hoparlör',NULL,'Her yerde odayı dolduran ses için taşınabilir Bluetooth hoparlör ve ev ses sistemi.'),('tr',6,'Akıllı Lamba',NULL,'Ayarlanabilir sıcaklığa, renge ve entegre sanal asistana sahip Wi-Fi akıllı lamba.'),('tr',7,'Kablo',NULL,'USB-C, Lightning ve korumalı şarj kabloları uzun süre dayanacak şekilde tasarlanmıştır.'),('tr',8,'Aksesuarlar',NULL,'Her türlü kıyafeti tamamlayacak çantalar, cüzdanlar, kemerler ve takılar.'),('tr',9,'Fare',NULL,'Günlük çalışma alanı için bilgisayar fareleri ve işaretçi aksesuarları.'),('tr',10,'Klavye',NULL,'Yaratıcının masası için klavye aksesuarları ve temel öğeler.'),('tr',11,'Fare Altlığı',NULL,'Masa paspasları, şarj istasyonları ve çalışma yüzeyleri.'),('tr',12,'Ağ oluşturma',NULL,'Akıllı ev aksesuarları ve bağlı ağlar.'),('vi',1,'Tìm Hiểu Thêm',NULL,'Tuyển chọn đồ điện tử nổi bật — khám phá thiết bị, phụ kiện và gadget mới nhất.'),('vi',2,'Đồng Hồ Thông Minh',NULL,'Vòng đeo theo dõi sức khỏe, đồng hồ thông minh và thiết bị đeo gắn liền với thói quen hằng ngày của bạn.'),('vi',3,'Tai Nghe Nhét Tai',NULL,'Tai nghe true wireless và tai nghe in-ear với âm thanh phong phú và thời lượng pin dài.'),('vi',4,'Tai Nghe Chụp Tai',NULL,'Tai nghe trùm tai, đặt trên tai và chống ồn chủ động cho việc nghe nhạc hằng ngày và trong phòng thu.'),('vi',5,'Loa',NULL,'Loa Bluetooth di động và âm thanh gia đình cho âm thanh tràn ngập căn phòng ở bất cứ đâu.'),('vi',6,'Đèn Thông Minh',NULL,'Đèn thông minh Wi-Fi với độ ấm, màu sắc điều chỉnh được và tích hợp trợ lý ảo.'),('vi',7,'Cáp',NULL,'Cáp sạc USB-C, Lightning và cáp bọc dù được chế tạo để bền lâu.'),('vi',8,'Phụ kiện',NULL,'Túi xách, ví, thắt lưng và trang sức để hoàn thiện mọi outfit.'),('vi',9,'Chuột',NULL,'Chuột máy tính và phụ kiện con trỏ cho không gian làm việc hằng ngày.'),('vi',10,'Bàn Phím',NULL,'Phụ kiện bàn phím và vật dụng thiết yếu cho bàn làm việc của người sáng tạo.'),('vi',11,'Lót Chuột',NULL,'Thảm bàn, đế sạc và bề mặt làm việc.'),('vi',12,'Mạng',NULL,'Phụ kiện nhà thông minh và mạng kết nối.');

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

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

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

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

INSERT INTO `ec_product_collections` VALUES (1,'Hear True Freedom in <br> Every Beat','hear-true-freedom-in-br-every-beat','Experience true wireless sound with deep bass, crystal clarity, and seamless connection made for music.','slider/electronics/slider-1.jpg','published','2026-05-28 19:02:13','2026-05-28 19:02:13',1),(2,'Desktop Sound','desktop-sound','Up to 50% Off Bestsellers.','collection/cls-9.jpg','published','2026-05-28 19:02:13','2026-05-28 19:02:13',1),(3,'Smart Watch','smart-watch','Up to 25% Off Bestsellers.','collection/cls-10.jpg','published','2026-05-28 19:02:13','2026-05-28 19:02:13',1),(4,'Table Lamp Sale','table-lamp-sale','Up to 50% Off Bestsellers.','collection/cls-11.jpg','published','2026-05-28 19:02:13','2026-05-28 19:02:13',1),(5,'Hear Every Detail','hear-every-detail','Power, comfort, clarity.','collection/cls-12.jpg','published','2026-05-28 19:02:13','2026-05-28 19:02:13',1);

--
-- 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,'استمع إلى الحرية الحقيقية في <br> في كل نبضة','استمتع بتجربة صوت لاسلكي حقيقي مع صوت جهير عميق ووضوح واتصال سلس لموسيقاك.'),('ar',2,'صوت سطح المكتب','خصم يصل إلى 50% على المنتجات الأكثر مبيعاً.'),('ar',3,'ساعة ذكية','خصم يصل إلى 25% على المنتجات الأكثر مبيعًا.'),('ar',4,'بيع مصباح الطاولة','خصم يصل إلى 50% على المنتجات الأكثر مبيعاً.'),('ar',5,'استمع إلى كل التفاصيل','قوية ومريحة وواضحة.'),('fr',1,'Écoutez la vraie liberté dans <br> Every Beat','Découvrez un véritable son sans fil avec des basses profondes, une clarté et une connectivité transparente pour votre musique.'),('fr',2,'Son du bureau','Jusqu\'à 50% de réduction sur les produits les plus vendus.'),('fr',3,'Montre intelligente','Jusqu\'à 25 % de réduction sur les produits les plus vendus.'),('fr',4,'Vente de lampes de table','Jusqu\'à 50% de réduction sur les produits les plus vendus.'),('fr',5,'Écoutez chaque détail','Puissant, confortable, clair.'),('id',1,'Dengarkan Kebebasan Sejati di <br> Setiap Detak','Nikmati suara nirkabel sesungguhnya dengan bass yang dalam, jernih, dan konektivitas tanpa batas untuk musik Anda.'),('id',2,'Suara Desktop','Diskon hingga 50% untuk produk terlaris.'),('id',3,'Jam Tangan Pintar','Diskon hingga 25% untuk produk terlaris.'),('id',4,'Penjualan Lampu Meja','Diskon hingga 50% untuk produk terlaris.'),('id',5,'Dengarkan Setiap Detailnya','Kuat, nyaman, jernih.'),('tr',1,'<br> Her Ritimde Gerçek Özgürlüğü Duyun','Müziğiniz için derin bas, netlik ve kusursuz bağlantıyla gerçek kablosuz sesi deneyimleyin.'),('tr',2,'Masaüstü Sesi','En çok satan ürünlerde %50\'ye varan indirim.'),('tr',3,'Akıllı Saat','En çok satan ürünlerde %25\'e varan indirim.'),('tr',4,'Masa Lambası İndirimi','En çok satan ürünlerde %50\'ye varan indirim.'),('tr',5,'Her Detayı Duyun','Güçlü, rahat ve net.'),('vi',1,'Cảm Nhận Tự Do Đích Thực Trong <br> Từng Nhịp Điệu','Trải nghiệm âm thanh true wireless với âm trầm sâu, độ trong vắt và kết nối liền mạch dành cho âm nhạc.'),('vi',2,'Âm Thanh Để Bàn','Giảm giá đến 50% các sản phẩm bán chạy.'),('vi',3,'Đồng Hồ Thông Minh','Giảm giá đến 25% các sản phẩm bán chạy.'),('vi',4,'Khuyến Mãi Đèn Bàn','Giảm giá đến 50% các sản phẩm bán chạy.'),('vi',5,'Nghe Trọn Từng Chi Tiết','Mạnh mẽ, thoải mái, rõ ràng.');

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

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

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

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

--
-- 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 (4,6),(6,3),(6,9);

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

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

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

INSERT INTO `ec_product_labels` VALUES (1,'Hot','#F0460E','published','2026-05-28 19:02:10','2026-05-28 19:02:10','#FFFFFF'),(2,'New','#22C55E','published','2026-05-28 19:02:10','2026-05-28 19:02:10','#FFFFFF'),(3,'Sale','#EF4444','published','2026-05-28 19:02:10','2026-05-28 19:02:10','#FFFFFF'),(4,'Best Seller','#1E1E1E','published','2026-05-28 19:02:10','2026-05-28 19:02:10','#FFFFFF'),(5,'Limited','#7B1F2B','published','2026-05-28 19:02:10','2026-05-28 19:02:10','#FFFFFF'),(6,'Eco','#6B7843','published','2026-05-28 19:02:10','2026-05-28 19:02:10','#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,3),(1,12),(1,14),(2,5),(2,13),(2,15),(3,1),(3,6),(3,11),(4,6),(4,13),(4,14),(5,1),(5,8),(5,15),(6,2),(6,5),(6,14),(7,4),(7,12),(7,13),(8,3),(8,8),(8,11),(9,6),(9,10),(9,14),(10,3),(10,5),(10,7);

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

CREATE TABLE `ec_product_tags` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` mediumtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--
-- 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,5,0,20.00,'percent',1),(1,6,0,5.00,'fixed',1),(2,4,0,50.00,'fixed',1),(2,5,0,20.00,'fixed',1),(3,6,0,20.00,'fixed',1),(3,8,0,5.00,'percent',1),(4,1,0,50.00,'fixed',1),(4,9,0,50.00,'fixed',1),(5,4,0,20.00,'percent',1),(5,7,0,5.00,'fixed',1),(6,1,0,10.00,'percent',1),(6,10,0,20.00,'fixed',1),(7,4,0,5.00,'percent',1),(7,9,0,5.00,'fixed',1),(8,1,0,20.00,'fixed',1),(8,2,0,15.00,'percent',1),(9,4,0,5.00,'fixed',1),(9,7,0,20.00,'fixed',1),(10,7,0,20.00,'fixed',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=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

INSERT INTO `ec_products` VALUES (1,'iPhone 17 Pro Max','iphone-17-pro-max','Flagship smartphone with titanium frame, ProMotion display, and pro-grade triple camera.','<p>6.9\" Super Retina XDR display, A19 Pro chip, and 5x optical zoom. Built to capture, edit, and stream from anywhere.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-1.jpg\"]',NULL,'0V-106',0,13,0,1,'in_stock',1,NULL,9,0,0,10,2.00,0,1299,1199,NULL,NULL,14,18,20,524,NULL,'standard',6183,'2026-05-28 19:02:15','2026-05-28 19:02:23',1,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/products/product-1.jpg','physical','2016821088248',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(2,'Apple Watch S10','apple-watch-s10','Always-on retina display with the most advanced sensors for fitness and health.','<p>ECG, blood oxygen, and sleep tracking. Aluminum case, 41mm and 45mm options, 18-hour battery.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-2.jpg\"]',NULL,'9L-137',0,10,0,1,'in_stock',0,NULL,8,0,0,10,3.90,0,429,379,NULL,NULL,11,10,13,677,NULL,'standard',142476,'2026-05-28 19:02:15','2026-05-28 19:02:23',2,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/products/product-2.jpg','physical','3802896705031',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(3,'Wireless Charging Pad','wireless-charging-pad','Qi-certified 15W fast wireless charger with anti-slip silicone surface.','<p>Compatible with iPhone, AirPods, and Android phones. USB-C input. Slim aluminum body.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-3.jpg\"]',NULL,'NQ-153-A1',0,18,0,1,'in_stock',0,NULL,5,0,1,10,3.30,0,49.99,34.99,NULL,NULL,10,20,14,616,NULL,'standard',7296,'2026-05-28 19:02:15','2026-05-28 19:02:23',3,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/products/product-3.jpg','physical','6734406008875',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(4,'Pro Earbuds Gen 4','pro-earbuds-gen-4','Adaptive ANC, spatial audio, and 30 hours total playback with the included charging case.','<p>IPX4 sweat resistance. Dual-mic noise reduction for clearer calls. USB-C and wireless charging.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-4.jpg\"]',NULL,'PX-150-A1',0,16,0,1,'in_stock',1,NULL,11,0,2,10,2.90,0,249,199,NULL,NULL,19,20,17,593,NULL,'standard',40019,'2026-05-28 19:02:16','2026-05-28 19:02:23',4,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/products/product-4.jpg','physical','4992523131698',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(5,'Smart Speaker Mini','smart-speaker-mini','Compact smart speaker with 360-degree sound and built-in voice assistant.','<p>Wi-Fi and Bluetooth multiroom audio. Alexa, Google, and AirPlay 2 support. Tap-to-pair pairing.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-5.jpg\"]',NULL,'YI-136-A1',0,12,0,1,'in_stock',0,NULL,8,0,3,10,2.80,0,99,79,NULL,NULL,13,15,11,808,NULL,'standard',189102,'2026-05-28 19:02:16','2026-05-28 19:02:23',1,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/products/product-5.jpg','physical','1509113117951',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(6,'Smart Lamp WiFi','smart-lamp-wifi','Dimmable Wi-Fi smart lamp with 16 million colors and scheduling via the companion app.','<p>Works with Alexa and Google Assistant. Voice and app control. Energy-efficient LED.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-6.jpg\"]',NULL,'MT-124-A1',0,19,0,1,'in_stock',0,NULL,2,0,3,10,2.20,0,89.99,64.99,NULL,NULL,11,16,12,810,NULL,'standard',170508,'2026-05-28 19:02:16','2026-05-28 19:02:23',2,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/products/product-6.jpg','physical','4931340413501',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(7,'USB-C Cable Pro','usb-c-cable-pro','Braided 100W USB-C to USB-C cable rated for 30,000+ bend cycles.','<p>Supports PD fast charging and 10Gbps data transfer. Available in 1m and 2m lengths.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-7.jpg\"]',NULL,'ZV-162-A1',0,10,0,1,'in_stock',1,NULL,5,0,3,10,3.00,0,29.99,19.99,NULL,NULL,15,17,11,871,NULL,'standard',81903,'2026-05-28 19:02:16','2026-05-28 19:02:23',3,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/products/product-7.jpg','physical','5231978684984',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(8,'Action Camera 4K','action-camera-4k','Pocket-sized 4K60 action camera with HyperSmooth stabilization and waterproof body.','<p>Records to microSD up to 512GB. Live streaming, voice control, and a 2-inch front display.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-8.jpg\"]',NULL,'8R-108',0,14,0,1,'in_stock',0,NULL,9,0,0,10,3.30,0,399,329,NULL,NULL,20,14,16,547,NULL,'standard',7803,'2026-05-28 19:02:16','2026-05-28 19:02:23',4,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/products/product-8.jpg','physical','5016381728049',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(9,'Tablet Pro 11','tablet-pro-11','11-inch Liquid Retina tablet with M-series chip — ideal for sketching, notes, and streaming.','<p>Apple Pencil and Magic Keyboard compatible. 128GB-2TB. All-day battery and Touch ID.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-9.jpg\"]',NULL,'QF-119-A1',0,12,0,1,'in_stock',1,NULL,6,0,3,10,2.90,0,899,799,NULL,NULL,18,13,17,555,NULL,'standard',84455,'2026-05-28 19:02:16','2026-05-28 19:02:23',1,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/products/product-9.jpg','physical','2982425038869',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(10,'Magnetic Phone Stand','magnetic-phone-stand','MagSafe-compatible aluminum stand with weighted base and tilt adjustment.','<p>Holds your phone at the perfect angle for FaceTime, recipes, or charging. Aluminum and silicone build.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-10.jpg\"]',NULL,'FX-167-A1',0,13,0,1,'in_stock',1,NULL,3,0,2,10,3.20,0,39.99,29.99,NULL,NULL,16,11,13,702,NULL,'standard',45768,'2026-05-28 19:02:16','2026-05-28 19:02:23',2,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homeelectronics/files/products/product-10.jpg','physical','5212487999400',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(11,'Wireless Charging Pad',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-3.jpg\"]',NULL,'NQ-153-A1',0,18,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,49.99,NULL,NULL,NULL,10,20,14,616,NULL,'standard',0,'2026-05-28 19:02:16','2026-05-28 19:02:23',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5826100505543',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(12,'Pro Earbuds Gen 4',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-4.jpg\"]',NULL,'PX-150-A1',0,16,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,249,206.67,NULL,NULL,19,20,17,593,NULL,'standard',0,'2026-05-28 19:02:16','2026-05-28 19:02:23',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9591625433355',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(13,'Pro Earbuds Gen 4',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-4.jpg\"]',NULL,'PX-150-A1-A2',0,16,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,249,199.2,NULL,NULL,19,20,17,593,NULL,'standard',0,'2026-05-28 19:02:17','2026-05-28 19:02:23',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8290985335231',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(14,'Smart Speaker Mini',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-5.jpg\"]',NULL,'YI-136-A1',0,12,0,1,'in_stock',0,NULL,8,1,0,0,0.00,0,99,NULL,NULL,NULL,13,15,11,808,NULL,'standard',0,'2026-05-28 19:02:17','2026-05-28 19:02:23',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5148459345534',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(15,'Smart Speaker Mini',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-5.jpg\"]',NULL,'YI-136-A1-A2',0,12,0,1,'in_stock',0,NULL,8,1,0,0,0.00,0,99,NULL,NULL,NULL,13,15,11,808,NULL,'standard',0,'2026-05-28 19:02:17','2026-05-28 19:02:23',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2877825855287',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(16,'Smart Speaker Mini',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-5.jpg\"]',NULL,'YI-136-A1-A3',0,12,0,1,'in_stock',0,NULL,8,1,0,0,0.00,0,99,NULL,NULL,NULL,13,15,11,808,NULL,'standard',0,'2026-05-28 19:02:17','2026-05-28 19:02:23',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','3251142872131',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(17,'Smart Lamp WiFi',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-6.jpg\"]',NULL,'MT-124-A1',0,19,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,89.99,NULL,NULL,NULL,11,16,12,810,NULL,'standard',0,'2026-05-28 19:02:17','2026-05-28 19:02:23',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2471853347310',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(18,'Smart Lamp WiFi',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-6.jpg\"]',NULL,'MT-124-A1-A2',0,19,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,89.99,NULL,NULL,NULL,11,16,12,810,NULL,'standard',0,'2026-05-28 19:02:17','2026-05-28 19:02:23',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4714034095869',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(19,'Smart Lamp WiFi',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-6.jpg\"]',NULL,'MT-124-A1-A3',0,19,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,89.99,NULL,NULL,NULL,11,16,12,810,NULL,'standard',0,'2026-05-28 19:02:17','2026-05-28 19:02:23',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','3249503164223',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(20,'USB-C Cable Pro',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-7.jpg\"]',NULL,'ZV-162-A1',0,10,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,29.99,NULL,NULL,NULL,15,17,11,871,NULL,'standard',0,'2026-05-28 19:02:17','2026-05-28 19:02:23',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','1521333490409',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(21,'USB-C Cable Pro',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-7.jpg\"]',NULL,'ZV-162-A1-A2',0,10,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,29.99,NULL,NULL,NULL,15,17,11,871,NULL,'standard',0,'2026-05-28 19:02:17','2026-05-28 19:02:23',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2118176907424',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(22,'USB-C Cable Pro',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-7.jpg\"]',NULL,'ZV-162-A1-A3',0,10,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,29.99,NULL,NULL,NULL,15,17,11,871,NULL,'standard',0,'2026-05-28 19:02:17','2026-05-28 19:02:23',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','0956367265906',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(23,'Tablet Pro 11',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-9.jpg\"]',NULL,'QF-119-A1',0,12,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,899,NULL,NULL,NULL,18,13,17,555,NULL,'standard',0,'2026-05-28 19:02:17','2026-05-28 19:02:23',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','7133249495078',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(24,'Tablet Pro 11',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-9.jpg\"]',NULL,'QF-119-A1-A2',0,12,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,899,NULL,NULL,NULL,18,13,17,555,NULL,'standard',0,'2026-05-28 19:02:18','2026-05-28 19:02:23',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5143463240363',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(25,'Tablet Pro 11',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-9.jpg\"]',NULL,'QF-119-A1-A3',0,12,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,899,NULL,NULL,NULL,18,13,17,555,NULL,'standard',0,'2026-05-28 19:02:18','2026-05-28 19:02:23',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','1098250292756',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(26,'Magnetic Phone Stand',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-10.jpg\"]',NULL,'FX-167-A1',0,13,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,39.99,NULL,NULL,NULL,16,11,13,702,NULL,'standard',0,'2026-05-28 19:02:18','2026-05-28 19:02:23',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5006025765455',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(27,'Magnetic Phone Stand',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homeelectronics\\/files\\/products\\/product-10.jpg\"]',NULL,'FX-167-A1-A2',0,13,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,39.99,NULL,NULL,NULL,16,11,13,702,NULL,'standard',0,'2026-05-28 19:02:18','2026-05-28 19:02:23',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6282223253768',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,'ايفون 17 برو ماكس',NULL,'هاتف ذكي متميز بإطار من التيتانيوم وشاشة ProMotion ومجموعة كاميرات ثلاثية احترافية.','<p>شاشة Super Retina XDR مقاس 6.9 بوصة، وشريحة A19 Pro وتقريب بصري 5x. مصممة للتصوير والتحرير والبث من أي مكان.</p>'),('ar',2,'ساعة ابل اس 10',NULL,'شاشة Retina تعمل دائمًا مع أجهزة الاستشعار الأكثر تقدمًا للياقة البدنية والصحة.','<p> قياس مخطط كهربية القلب ومستويات الأكسجين في الدم ومراقبة النوم. هيكل من الألومنيوم، خيارات مقاس 41 مم و45 مم، بطارية تدوم لمدة 18 ساعة.</p>'),('ar',3,'وسادة شحن لاسلكية',NULL,'يتوافق الشحن اللاسلكي السريع بقدرة 15 وات مع معيار Qi مع سطح سيليكون مضاد للانزلاق.','<p>متوافق مع هواتف iPhone وAirPods وAndroid. منفذ إدخال USB-C. جسم ألومنيوم رفيع.</p>'),('ar',4,'سماعات الأذن برو الجيل 4',NULL,'إلغاء الضوضاء النشط التكيفي، والصوت المكاني، وإجمالي وقت التشغيل لمدة 30 ساعة مع علبة الشحن المضمنة.','<p>IPX4 مقاومة العرق القياسية. تعمل الميكروفونات المزدوجة على تقليل الضوضاء لإجراء مكالمات أكثر وضوحًا. اشحن عبر USB-C ولاسلكيًا.</p>'),('ar',5,'مكبر صوت ذكي صغير',NULL,'مكبر صوت ذكي صغير الحجم مع صوت بزاوية 360 درجة ومساعد افتراضي مدمج.','<p> صوت متعدد الغرف عبر Wi-Fi وBluetooth. يدعم Alexa وGoogle وAirPlay 2. الاقتران باللمس للاتصال.</p>'),('ar',6,'مصباح ذكي واي فاي',NULL,'يعمل ضوء Wi-Fi الذكي على ضبط السطوع بـ 16 مليون لون ويضبط مؤقتًا عبر التطبيق المصاحب.','<p>يعمل مع Alexa وGoogle Assistant. التحكم بالصوت والتطبيق. مصابيح LED موفرة للطاقة.</p>'),('ar',7,'كابل USB-C برو',NULL,'كابل USB-C إلى USB-C بقدرة 100 واط مع غطاء مظلة، يتحمل أكثر من 30,000 طية.','<p>يدعم الشحن السريع PD ونقل البيانات بسرعة 10 جيجابت في الثانية. متوفر بطول 1 متر و2 متر.</p>'),('ar',8,'كاميرا الأكشن 4K',NULL,'كاميرا اندفاعة Pocket 4K60 مزودة بثبات HyperSmooth وجسم مقاوم للماء.','<p> سجل على بطاقة microSD بسعة تصل إلى 512 جيجابايت. بث مباشر وتحكم صوتي وشاشة أمامية 2 بوصة.</p>'),('ar',9,'تابلت برو 11',NULL,'جهاز لوحي Liquid Retina مقاس 11 بوصة مزود بشريحة السلسلة M - مثالي للرسم وتدوين الملاحظات ومشاهدة الأفلام.','<p>متوافق مع Apple Pencil ولوحة المفاتيح السحرية. سعة 128 جيجابايت - 2 تيرابايت. بطارية تدوم طوال اليوم ومعرف اللمس.</p>'),('ar',10,'حامل الهاتف المغناطيسي',NULL,'حامل ألومنيوم متوافق مع MagSafe مزود بقاعدة شديدة التحمل وإمكانية تعديل زاوية الإمالة.','<p> يحمل هاتفك بزاوية مثالية لـ FaceTime أو عرض الوصفات أو الشحن. مادة الألومنيوم والسيليكون.</p>'),('ar',11,'وسادة شحن لاسلكية',NULL,'يتوافق الشحن اللاسلكي السريع بقدرة 15 وات مع معيار Qi مع سطح سيليكون مضاد للانزلاق.','<p>متوافق مع هواتف iPhone وAirPods وAndroid. منفذ إدخال USB-C. جسم ألومنيوم رفيع.</p>'),('ar',12,'سماعات الأذن برو الجيل 4',NULL,'إلغاء الضوضاء النشط التكيفي، والصوت المكاني، وإجمالي وقت التشغيل لمدة 30 ساعة مع علبة الشحن المضمنة.','<p>IPX4 مقاومة العرق القياسية. تعمل الميكروفونات المزدوجة على تقليل الضوضاء لإجراء مكالمات أكثر وضوحًا. اشحن عبر USB-C ولاسلكيًا.</p>'),('ar',13,'سماعات الأذن برو الجيل 4',NULL,'إلغاء الضوضاء النشط التكيفي، والصوت المكاني، وإجمالي وقت التشغيل لمدة 30 ساعة مع علبة الشحن المضمنة.','<p>IPX4 مقاومة العرق القياسية. تعمل الميكروفونات المزدوجة على تقليل الضوضاء لإجراء مكالمات أكثر وضوحًا. اشحن عبر USB-C ولاسلكيًا.</p>'),('ar',14,'مكبر صوت ذكي صغير',NULL,'مكبر صوت ذكي صغير الحجم مع صوت بزاوية 360 درجة ومساعد افتراضي مدمج.','<p> صوت متعدد الغرف عبر Wi-Fi وBluetooth. يدعم Alexa وGoogle وAirPlay 2. الاقتران باللمس للاتصال.</p>'),('ar',15,'مكبر صوت ذكي صغير',NULL,'مكبر صوت ذكي صغير الحجم مع صوت بزاوية 360 درجة ومساعد افتراضي مدمج.','<p> صوت متعدد الغرف عبر Wi-Fi وBluetooth. يدعم Alexa وGoogle وAirPlay 2. الاقتران باللمس للاتصال.</p>'),('ar',16,'مكبر صوت ذكي صغير',NULL,'مكبر صوت ذكي صغير الحجم مع صوت بزاوية 360 درجة ومساعد افتراضي مدمج.','<p> صوت متعدد الغرف عبر Wi-Fi وBluetooth. يدعم Alexa وGoogle وAirPlay 2. الاقتران باللمس للاتصال.</p>'),('ar',17,'مصباح ذكي واي فاي',NULL,'يعمل ضوء Wi-Fi الذكي على ضبط السطوع بـ 16 مليون لون ويضبط مؤقتًا عبر التطبيق المصاحب.','<p>يعمل مع Alexa وGoogle Assistant. التحكم بالصوت والتطبيق. مصابيح LED موفرة للطاقة.</p>'),('ar',18,'مصباح ذكي واي فاي',NULL,'يعمل ضوء Wi-Fi الذكي على ضبط السطوع بـ 16 مليون لون ويضبط مؤقتًا عبر التطبيق المصاحب.','<p>يعمل مع Alexa وGoogle Assistant. التحكم بالصوت والتطبيق. مصابيح LED موفرة للطاقة.</p>'),('ar',19,'مصباح ذكي واي فاي',NULL,'يعمل ضوء Wi-Fi الذكي على ضبط السطوع بـ 16 مليون لون ويضبط مؤقتًا عبر التطبيق المصاحب.','<p>يعمل مع Alexa وGoogle Assistant. التحكم بالصوت والتطبيق. مصابيح LED موفرة للطاقة.</p>'),('ar',20,'كابل USB-C برو',NULL,'كابل USB-C إلى USB-C بقدرة 100 واط مع غطاء مظلة، يتحمل أكثر من 30,000 طية.','<p>يدعم الشحن السريع PD ونقل البيانات بسرعة 10 جيجابت في الثانية. متوفر بطول 1 متر و2 متر.</p>'),('ar',21,'كابل USB-C برو',NULL,'كابل USB-C إلى USB-C بقدرة 100 واط مع غطاء مظلة، يتحمل أكثر من 30,000 طية.','<p>يدعم الشحن السريع PD ونقل البيانات بسرعة 10 جيجابت في الثانية. متوفر بطول 1 متر و2 متر.</p>'),('ar',22,'كابل USB-C برو',NULL,'كابل USB-C إلى USB-C بقدرة 100 واط مع غطاء مظلة، يتحمل أكثر من 30,000 طية.','<p>يدعم الشحن السريع PD ونقل البيانات بسرعة 10 جيجابت في الثانية. متوفر بطول 1 متر و2 متر.</p>'),('ar',23,'تابلت برو 11',NULL,'جهاز لوحي Liquid Retina مقاس 11 بوصة مزود بشريحة السلسلة M - مثالي للرسم وتدوين الملاحظات ومشاهدة الأفلام.','<p>متوافق مع Apple Pencil ولوحة المفاتيح السحرية. سعة 128 جيجابايت - 2 تيرابايت. بطارية تدوم طوال اليوم ومعرف اللمس.</p>'),('ar',24,'تابلت برو 11',NULL,'جهاز لوحي Liquid Retina مقاس 11 بوصة مزود بشريحة السلسلة M - مثالي للرسم وتدوين الملاحظات ومشاهدة الأفلام.','<p>متوافق مع Apple Pencil ولوحة المفاتيح السحرية. سعة 128 جيجابايت - 2 تيرابايت. بطارية تدوم طوال اليوم ومعرف اللمس.</p>'),('ar',25,'تابلت برو 11',NULL,'جهاز لوحي Liquid Retina مقاس 11 بوصة مزود بشريحة السلسلة M - مثالي للرسم وتدوين الملاحظات ومشاهدة الأفلام.','<p>متوافق مع Apple Pencil ولوحة المفاتيح السحرية. سعة 128 جيجابايت - 2 تيرابايت. بطارية تدوم طوال اليوم ومعرف اللمس.</p>'),('ar',26,'حامل الهاتف المغناطيسي',NULL,'حامل ألومنيوم متوافق مع MagSafe مزود بقاعدة شديدة التحمل وإمكانية تعديل زاوية الإمالة.','<p> يحمل هاتفك بزاوية مثالية لـ FaceTime أو عرض الوصفات أو الشحن. مادة الألومنيوم والسيليكون.</p>'),('ar',27,'حامل الهاتف المغناطيسي',NULL,'حامل ألومنيوم متوافق مع MagSafe مزود بقاعدة شديدة التحمل وإمكانية تعديل زاوية الإمالة.','<p> يحمل هاتفك بزاوية مثالية لـ FaceTime أو عرض الوصفات أو الشحن. مادة الألومنيوم والسيليكون.</p>'),('fr',1,'iPhone 17 Pro Max',NULL,'Smartphone haut de gamme avec cadre en titane, écran ProMotion et triple caméra professionnelle.','<p>Écran Super Retina XDR de 6,9 pouces, puce A19 Pro et zoom optique 5x. Conçu pour filmer, éditer et diffuser depuis n\'importe où.</p>'),('fr',2,'AppleWatch S10',NULL,'Écran Retina toujours actif avec les capteurs les plus avancés pour la forme physique et la santé.','<p>Mesurez l\'électrocardiogramme, les niveaux d\'oxygène dans le sang et surveillez le sommeil. Boîtier en aluminium, options 41 mm et 45 mm, batterie de 18 heures.</p>'),('fr',3,'Tapis de chargement sans fil',NULL,'La charge sans fil rapide de 15 W répond à la norme Qi avec une surface en silicone antidérapante.','<p>Compatible avec les téléphones iPhone, AirPods et Android. Port d\'entrée USB-C. Corps mince en aluminium.</p>'),('fr',4,'Écouteurs Pro Gen 4',NULL,'Suppression active adaptative du bruit, audio spatial et 30 heures de lecture totale avec étui de chargement inclus.','Résistance à la transpiration standard <p>IPX4. Les deux microphones réduisent le bruit pour des appels plus clairs. Chargez via USB-C et sans fil.</p>'),('fr',5,'Mini haut-parleur intelligent',NULL,'Haut-parleur intelligent compact avec son à 360 degrés et assistant virtuel intégré.','<p>Audio multi-pièces via Wi-Fi et Bluetooth. Prend en charge Alexa, Google et AirPlay 2. Appairage tactile pour se connecter.</p>'),('fr',6,'Lampe intelligente WiFi',NULL,'La lumière intelligente Wi-Fi ajuste la luminosité avec 16 millions de couleurs et règle une minuterie via l\'application qui l\'accompagne.','<p>Fonctionne avec Alexa et Google Assistant. Contrôle vocal et application. Lumières LED à économie d\'énergie.</p>'),('fr',7,'Câble USB-C Pro',NULL,'Câble USB-C vers USB-C 100 W avec cache parachute, résiste à plus de 30 000 pliages.','<p>Prend en charge la charge rapide PD et la transmission de données à 10 Gbit/s. Disponible en longueurs de 1 m et 2 m.</p>'),('fr',8,'Caméra d\'action 4K',NULL,'Caméra de tableau de bord Pocket 4K60 avec stabilisation HyperSmooth et corps étanche.','<p>Enregistrez sur une carte microSD jusqu\'à 512 Go. Diffusion en direct, commande vocale et écran avant de 2 pouces.</p>'),('fr',9,'Tablette Pro 11',NULL,'Tablette Liquid Retina de 11 pouces avec puce de la série M — idéale pour dessiner, prendre des notes et regarder des films.','<p>Compatible avec Apple Pencil et Magic Keyboard. Capacité 128 Go-2 To. Batterie qui dure toute la journée et Touch ID.</p>'),('fr',10,'Support de téléphone magnétique',NULL,'Support en aluminium compatible MagSafe avec base robuste et réglage de l\'angle d\'inclinaison.','<p>Maintient votre téléphone à l\'angle parfait pour FaceTime, consulter des recettes ou charger. Matériau aluminium et silicium.</p>'),('fr',11,'Tapis de chargement sans fil',NULL,'La charge sans fil rapide de 15 W répond à la norme Qi avec une surface en silicone antidérapante.','<p>Compatible avec les téléphones iPhone, AirPods et Android. Port d\'entrée USB-C. Corps mince en aluminium.</p>'),('fr',12,'Écouteurs Pro Gen 4',NULL,'Suppression active adaptative du bruit, audio spatial et 30 heures de lecture totale avec étui de chargement inclus.','Résistance à la transpiration standard <p>IPX4. Les deux microphones réduisent le bruit pour des appels plus clairs. Chargez via USB-C et sans fil.</p>'),('fr',13,'Écouteurs Pro Gen 4',NULL,'Suppression active adaptative du bruit, audio spatial et 30 heures de lecture totale avec étui de chargement inclus.','Résistance à la transpiration standard <p>IPX4. Les deux microphones réduisent le bruit pour des appels plus clairs. Chargez via USB-C et sans fil.</p>'),('fr',14,'Mini haut-parleur intelligent',NULL,'Haut-parleur intelligent compact avec son à 360 degrés et assistant virtuel intégré.','<p>Audio multi-pièces via Wi-Fi et Bluetooth. Prend en charge Alexa, Google et AirPlay 2. Appairage tactile pour se connecter.</p>'),('fr',15,'Mini haut-parleur intelligent',NULL,'Haut-parleur intelligent compact avec son à 360 degrés et assistant virtuel intégré.','<p>Audio multi-pièces via Wi-Fi et Bluetooth. Prend en charge Alexa, Google et AirPlay 2. Appairage tactile pour se connecter.</p>'),('fr',16,'Mini haut-parleur intelligent',NULL,'Haut-parleur intelligent compact avec son à 360 degrés et assistant virtuel intégré.','<p>Audio multi-pièces via Wi-Fi et Bluetooth. Prend en charge Alexa, Google et AirPlay 2. Appairage tactile pour se connecter.</p>'),('fr',17,'Lampe intelligente WiFi',NULL,'La lumière intelligente Wi-Fi ajuste la luminosité avec 16 millions de couleurs et règle une minuterie via l\'application qui l\'accompagne.','<p>Fonctionne avec Alexa et Google Assistant. Contrôle vocal et application. Lumières LED à économie d\'énergie.</p>'),('fr',18,'Lampe intelligente WiFi',NULL,'La lumière intelligente Wi-Fi ajuste la luminosité avec 16 millions de couleurs et règle une minuterie via l\'application qui l\'accompagne.','<p>Fonctionne avec Alexa et Google Assistant. Contrôle vocal et application. Lumières LED à économie d\'énergie.</p>'),('fr',19,'Lampe intelligente WiFi',NULL,'La lumière intelligente Wi-Fi ajuste la luminosité avec 16 millions de couleurs et règle une minuterie via l\'application qui l\'accompagne.','<p>Fonctionne avec Alexa et Google Assistant. Contrôle vocal et application. Lumières LED à économie d\'énergie.</p>'),('fr',20,'Câble USB-C Pro',NULL,'Câble USB-C vers USB-C 100 W avec cache parachute, résiste à plus de 30 000 pliages.','<p>Prend en charge la charge rapide PD et la transmission de données à 10 Gbit/s. Disponible en longueurs de 1 m et 2 m.</p>'),('fr',21,'Câble USB-C Pro',NULL,'Câble USB-C vers USB-C 100 W avec cache parachute, résiste à plus de 30 000 pliages.','<p>Prend en charge la charge rapide PD et la transmission de données à 10 Gbit/s. Disponible en longueurs de 1 m et 2 m.</p>'),('fr',22,'Câble USB-C Pro',NULL,'Câble USB-C vers USB-C 100 W avec cache parachute, résiste à plus de 30 000 pliages.','<p>Prend en charge la charge rapide PD et la transmission de données à 10 Gbit/s. Disponible en longueurs de 1 m et 2 m.</p>'),('fr',23,'Tablette Pro 11',NULL,'Tablette Liquid Retina de 11 pouces avec puce de la série M — idéale pour dessiner, prendre des notes et regarder des films.','<p>Compatible avec Apple Pencil et Magic Keyboard. Capacité 128 Go-2 To. Batterie qui dure toute la journée et Touch ID.</p>'),('fr',24,'Tablette Pro 11',NULL,'Tablette Liquid Retina de 11 pouces avec puce de la série M — idéale pour dessiner, prendre des notes et regarder des films.','<p>Compatible avec Apple Pencil et Magic Keyboard. Capacité 128 Go-2 To. Batterie qui dure toute la journée et Touch ID.</p>'),('fr',25,'Tablette Pro 11',NULL,'Tablette Liquid Retina de 11 pouces avec puce de la série M — idéale pour dessiner, prendre des notes et regarder des films.','<p>Compatible avec Apple Pencil et Magic Keyboard. Capacité 128 Go-2 To. Batterie qui dure toute la journée et Touch ID.</p>'),('fr',26,'Support de téléphone magnétique',NULL,'Support en aluminium compatible MagSafe avec base robuste et réglage de l\'angle d\'inclinaison.','<p>Maintient votre téléphone à l\'angle parfait pour FaceTime, consulter des recettes ou charger. Matériau aluminium et silicium.</p>'),('fr',27,'Support de téléphone magnétique',NULL,'Support en aluminium compatible MagSafe avec base robuste et réglage de l\'angle d\'inclinaison.','<p>Maintient votre téléphone à l\'angle parfait pour FaceTime, consulter des recettes ou charger. Matériau aluminium et silicium.</p>'),('id',1,'iPhone 17 Pro Maks',NULL,'Ponsel pintar premium dengan bingkai titanium, layar ProMotion, dan cluster tiga kamera profesional.','<p>Layar Super Retina XDR 6,9\", chip A19 Pro, dan zoom optik 5x. Dirancang untuk memotret, mengedit, dan streaming dari mana saja.</p>'),('id',2,'jam apel S10',NULL,'Layar retina yang selalu aktif dengan sensor tercanggih untuk kebugaran dan kesehatan.','<p>Mengukur elektrokardiogram, kadar oksigen darah dan memantau tidur. Casing aluminium, opsi 41mm dan 45mm, baterai 18 jam.</p>'),('id',3,'Bantalan Pengisi Daya Nirkabel',NULL,'Pengisian daya nirkabel cepat 15W memenuhi standar Qi dengan permukaan silikon anti selip.','<p>Kompatibel dengan iPhone, AirPods, dan ponsel Android. Port masukan USB-C. Bodi aluminium tipis.</p>'),('id',4,'Earbud Pro Gen 4',NULL,'Peredam bising aktif adaptif, audio spasial, dan total waktu putar 30 jam dengan wadah pengisi daya yang disertakan.','<p>IPX4 standar tahan keringat. Mikrofon ganda mengurangi kebisingan untuk panggilan yang lebih jelas. Isi daya melalui USB-C dan secara nirkabel.</p>'),('id',5,'Pembicara Cerdas Mini',NULL,'Speaker cerdas ringkas dengan suara 360 derajat dan asisten virtual bawaan.','<p>Audio multi-ruangan melalui Wi-Fi dan Bluetooth. Mendukung Alexa, Google, dan AirPlay 2. Pemasangan sentuh untuk menghubungkan.</p>'),('id',6,'WiFi Lampu Cerdas',NULL,'Lampu pintar Wi-Fi menyesuaikan kecerahan dengan 16 juta warna dan menyetel pengatur waktu melalui aplikasi yang menyertainya.','<p>Bekerja dengan Alexa dan Asisten Google. Kontrol suara dan aplikasi. Lampu LED hemat energi.</p>'),('id',7,'Kabel USB-C Pro',NULL,'Kabel USB-C ke USB-C 100W dengan penutup parasut, tahan lebih dari 30.000 lipatan.','<p>Mendukung pengisian cepat PD dan transmisi data 10Gbps. Tersedia dalam panjang 1m dan 2m.</p>'),('id',8,'Kamera Aksi 4K',NULL,'Kamera dasbor Pocket 4K60 dengan stabilisasi HyperSmooth dan bodi tahan air.','<p>Rekam ke kartu microSD hingga 512GB. Streaming langsung, kontrol suara, dan layar depan 2 inci.</p>'),('id',9,'Tablet Pro 11',NULL,'Tablet Liquid Retina 11 inci dengan chip seri M — ideal untuk membuat sketsa, membuat catatan, dan menonton film.','<p>Kompatibel dengan Apple Pencil dan Magic Keyboard. Kapasitas 128GB-2TB. Baterai sepanjang hari dan Touch ID.</p>'),('id',10,'Dudukan Telepon Magnetik',NULL,'Dudukan aluminium yang kompatibel dengan MagSafe dengan dudukan tugas berat dan penyesuaian sudut kemiringan.','<p>Pegang ponsel Anda pada sudut yang sempurna untuk FaceTime, melihat resep, atau mengisi daya. Bahan alumunium dan silikon.</p>'),('id',11,'Bantalan Pengisi Daya Nirkabel',NULL,'Pengisian daya nirkabel cepat 15W memenuhi standar Qi dengan permukaan silikon anti selip.','<p>Kompatibel dengan iPhone, AirPods, dan ponsel Android. Port masukan USB-C. Bodi aluminium tipis.</p>'),('id',12,'Earbud Pro Gen 4',NULL,'Peredam bising aktif adaptif, audio spasial, dan total waktu putar 30 jam dengan wadah pengisi daya yang disertakan.','<p>IPX4 standar tahan keringat. Mikrofon ganda mengurangi kebisingan untuk panggilan yang lebih jelas. Isi daya melalui USB-C dan secara nirkabel.</p>'),('id',13,'Earbud Pro Gen 4',NULL,'Peredam bising aktif adaptif, audio spasial, dan total waktu putar 30 jam dengan wadah pengisi daya yang disertakan.','<p>IPX4 standar tahan keringat. Mikrofon ganda mengurangi kebisingan untuk panggilan yang lebih jelas. Isi daya melalui USB-C dan secara nirkabel.</p>'),('id',14,'Pembicara Cerdas Mini',NULL,'Speaker cerdas ringkas dengan suara 360 derajat dan asisten virtual bawaan.','<p>Audio multi-ruangan melalui Wi-Fi dan Bluetooth. Mendukung Alexa, Google, dan AirPlay 2. Pemasangan sentuh untuk menghubungkan.</p>'),('id',15,'Pembicara Cerdas Mini',NULL,'Speaker cerdas ringkas dengan suara 360 derajat dan asisten virtual bawaan.','<p>Audio multi-ruangan melalui Wi-Fi dan Bluetooth. Mendukung Alexa, Google, dan AirPlay 2. Pemasangan sentuh untuk menghubungkan.</p>'),('id',16,'Pembicara Cerdas Mini',NULL,'Speaker cerdas ringkas dengan suara 360 derajat dan asisten virtual bawaan.','<p>Audio multi-ruangan melalui Wi-Fi dan Bluetooth. Mendukung Alexa, Google, dan AirPlay 2. Pemasangan sentuh untuk menghubungkan.</p>'),('id',17,'WiFi Lampu Cerdas',NULL,'Lampu pintar Wi-Fi menyesuaikan kecerahan dengan 16 juta warna dan menyetel pengatur waktu melalui aplikasi yang menyertainya.','<p>Bekerja dengan Alexa dan Asisten Google. Kontrol suara dan aplikasi. Lampu LED hemat energi.</p>'),('id',18,'WiFi Lampu Cerdas',NULL,'Lampu pintar Wi-Fi menyesuaikan kecerahan dengan 16 juta warna dan menyetel pengatur waktu melalui aplikasi yang menyertainya.','<p>Bekerja dengan Alexa dan Asisten Google. Kontrol suara dan aplikasi. Lampu LED hemat energi.</p>'),('id',19,'WiFi Lampu Cerdas',NULL,'Lampu pintar Wi-Fi menyesuaikan kecerahan dengan 16 juta warna dan menyetel pengatur waktu melalui aplikasi yang menyertainya.','<p>Bekerja dengan Alexa dan Asisten Google. Kontrol suara dan aplikasi. Lampu LED hemat energi.</p>'),('id',20,'Kabel USB-C Pro',NULL,'Kabel USB-C ke USB-C 100W dengan penutup parasut, tahan lebih dari 30.000 lipatan.','<p>Mendukung pengisian cepat PD dan transmisi data 10Gbps. Tersedia dalam panjang 1m dan 2m.</p>'),('id',21,'Kabel USB-C Pro',NULL,'Kabel USB-C ke USB-C 100W dengan penutup parasut, tahan lebih dari 30.000 lipatan.','<p>Mendukung pengisian cepat PD dan transmisi data 10Gbps. Tersedia dalam panjang 1m dan 2m.</p>'),('id',22,'Kabel USB-C Pro',NULL,'Kabel USB-C ke USB-C 100W dengan penutup parasut, tahan lebih dari 30.000 lipatan.','<p>Mendukung pengisian cepat PD dan transmisi data 10Gbps. Tersedia dalam panjang 1m dan 2m.</p>'),('id',23,'Tablet Pro 11',NULL,'Tablet Liquid Retina 11 inci dengan chip seri M — ideal untuk membuat sketsa, membuat catatan, dan menonton film.','<p>Kompatibel dengan Apple Pencil dan Magic Keyboard. Kapasitas 128GB-2TB. Baterai sepanjang hari dan Touch ID.</p>'),('id',24,'Tablet Pro 11',NULL,'Tablet Liquid Retina 11 inci dengan chip seri M — ideal untuk membuat sketsa, membuat catatan, dan menonton film.','<p>Kompatibel dengan Apple Pencil dan Magic Keyboard. Kapasitas 128GB-2TB. Baterai sepanjang hari dan Touch ID.</p>'),('id',25,'Tablet Pro 11',NULL,'Tablet Liquid Retina 11 inci dengan chip seri M — ideal untuk membuat sketsa, membuat catatan, dan menonton film.','<p>Kompatibel dengan Apple Pencil dan Magic Keyboard. Kapasitas 128GB-2TB. Baterai sepanjang hari dan Touch ID.</p>'),('id',26,'Dudukan Telepon Magnetik',NULL,'Dudukan aluminium yang kompatibel dengan MagSafe dengan dudukan tugas berat dan penyesuaian sudut kemiringan.','<p>Pegang ponsel Anda pada sudut yang sempurna untuk FaceTime, melihat resep, atau mengisi daya. Bahan alumunium dan silikon.</p>'),('id',27,'Dudukan Telepon Magnetik',NULL,'Dudukan aluminium yang kompatibel dengan MagSafe dengan dudukan tugas berat dan penyesuaian sudut kemiringan.','<p>Pegang ponsel Anda pada sudut yang sempurna untuk FaceTime, melihat resep, atau mengisi daya. Bahan alumunium dan silikon.</p>'),('tr',1,'iPhone 17 Pro Max',NULL,'Titanyum çerçeveye, ProMotion ekrana ve profesyonel üçlü kamera kümesine sahip birinci sınıf akıllı telefon.','<p>6,9\" Super Retina XDR ekran, A19 Pro çip ve 5x optik yakınlaştırma. Her yerden çekim yapmak, düzenlemek ve yayın yapmak için tasarlandı.</p>'),('tr',2,'Apple Watch S10',NULL,'Fitness ve sağlık için en gelişmiş sensörlere sahip, her zaman açık retina ekran.','<p>Elektrokardiyogramı, kandaki oksijen seviyelerini ölçün ve uykuyu izleyin. Alüminyum kasa, 41mm ve 45mm seçenekleri, 18 saat pil ömrü.</p>'),('tr',3,'Kablosuz Şarj Pedi',NULL,'15W hızlı kablosuz şarj, kaymayı önleyen silikon yüzeyiyle Qi standardını karşılar.','<p>iPhone, AirPods ve Android telefonlarla uyumludur. USB-C giriş bağlantı noktası. İnce alüminyum gövde.</p>'),('tr',4,'Profesyonel Kulaklıklar 4. Nesil',NULL,'Uyarlanabilir aktif gürültü engelleme, uzamsal ses ve birlikte verilen şarj kutusuyla birlikte 30 saatlik toplam çalma süresi.','<p>IPX4 standart ter direnci. Çift mikrofon, daha net aramalar için gürültüyü azaltır. USB-C ile ve kablosuz olarak şarj edin.</p>'),('tr',5,'Akıllı Hoparlör Mini',NULL,'360 derece ses ve yerleşik sanal asistana sahip kompakt akıllı hoparlör.','<p>Wi-Fi ve Bluetooth üzerinden çok odalı ses. Alexa, Google ve AirPlay 2\'yi destekler. Dokunarak bağlanma eşleştirmesi.</p>'),('tr',6,'Akıllı Lamba WiFi',NULL,'Wi-Fi akıllı ışık, 16 milyon renkle parlaklığı ayarlar ve beraberindeki uygulama aracılığıyla bir zamanlayıcı ayarlar.','<p>Alexa ve Google Asistan ile çalışır. Ses ve uygulama kontrolü. Enerji tasarruflu LED ışıklar.</p>'),('tr',7,'USB-C Kablo Pro',NULL,'Paraşüt kapaklı 100 W USB-C\'den USB-C\'ye kablo, 30.000\'den fazla katlanmaya dayanıklıdır.','<p>PD hızlı şarjı ve 10 Gbps veri iletimini destekler. 1m ve 2m uzunluklarda mevcuttur.</p>'),('tr',8,'Aksiyon Kamerası 4K',NULL,'HyperSmooth sabitleme ve su geçirmez gövdeye sahip cep 4K60 araç kamerası.','<p>512 GB\'a kadar microSD karta kayıt yapın. Canlı yayın, ses kontrolü ve 2 inç ön ekran.</p>'),('tr',9,'Tablet Pro11',NULL,'M serisi çipli 11 inç Liquid Retina tablet; çizim yapmak, not almak ve film izlemek için idealdir.','<p>Apple Pencil ve Magic Keyboard ile uyumludur. Kapasite 128GB-2TB. Tüm gün dayanan pil ve Touch ID.</p>'),('tr',10,'Manyetik Telefon Standı',NULL,'Ağır hizmet tipi tabana ve eğim açısı ayarına sahip MagSafe uyumlu alüminyum montaj parçası.','<p>FaceTime, tarifleri görüntülemek veya şarj etmek için telefonunuzu mükemmel açıda tutar. Malzeme alüminyum ve silikon.</p>'),('tr',11,'Kablosuz Şarj Pedi',NULL,'15W hızlı kablosuz şarj, kaymayı önleyen silikon yüzeyiyle Qi standardını karşılar.','<p>iPhone, AirPods ve Android telefonlarla uyumludur. USB-C giriş bağlantı noktası. İnce alüminyum gövde.</p>'),('tr',12,'Profesyonel Kulaklıklar 4. Nesil',NULL,'Uyarlanabilir aktif gürültü engelleme, uzamsal ses ve birlikte verilen şarj kutusuyla birlikte 30 saatlik toplam çalma süresi.','<p>IPX4 standart ter direnci. Çift mikrofon, daha net aramalar için gürültüyü azaltır. USB-C ile ve kablosuz olarak şarj edin.</p>'),('tr',13,'Profesyonel Kulaklıklar 4. Nesil',NULL,'Uyarlanabilir aktif gürültü engelleme, uzamsal ses ve birlikte verilen şarj kutusuyla birlikte 30 saatlik toplam çalma süresi.','<p>IPX4 standart ter direnci. Çift mikrofon, daha net aramalar için gürültüyü azaltır. USB-C ile ve kablosuz olarak şarj edin.</p>'),('tr',14,'Akıllı Hoparlör Mini',NULL,'360 derece ses ve yerleşik sanal asistana sahip kompakt akıllı hoparlör.','<p>Wi-Fi ve Bluetooth üzerinden çok odalı ses. Alexa, Google ve AirPlay 2\'yi destekler. Dokunarak bağlanma eşleştirmesi.</p>'),('tr',15,'Akıllı Hoparlör Mini',NULL,'360 derece ses ve yerleşik sanal asistana sahip kompakt akıllı hoparlör.','<p>Wi-Fi ve Bluetooth üzerinden çok odalı ses. Alexa, Google ve AirPlay 2\'yi destekler. Dokunarak bağlanma eşleştirmesi.</p>'),('tr',16,'Akıllı Hoparlör Mini',NULL,'360 derece ses ve yerleşik sanal asistana sahip kompakt akıllı hoparlör.','<p>Wi-Fi ve Bluetooth üzerinden çok odalı ses. Alexa, Google ve AirPlay 2\'yi destekler. Dokunarak bağlanma eşleştirmesi.</p>'),('tr',17,'Akıllı Lamba WiFi',NULL,'Wi-Fi akıllı ışık, 16 milyon renkle parlaklığı ayarlar ve beraberindeki uygulama aracılığıyla bir zamanlayıcı ayarlar.','<p>Alexa ve Google Asistan ile çalışır. Ses ve uygulama kontrolü. Enerji tasarruflu LED ışıklar.</p>'),('tr',18,'Akıllı Lamba WiFi',NULL,'Wi-Fi akıllı ışık, 16 milyon renkle parlaklığı ayarlar ve beraberindeki uygulama aracılığıyla bir zamanlayıcı ayarlar.','<p>Alexa ve Google Asistan ile çalışır. Ses ve uygulama kontrolü. Enerji tasarruflu LED ışıklar.</p>'),('tr',19,'Akıllı Lamba WiFi',NULL,'Wi-Fi akıllı ışık, 16 milyon renkle parlaklığı ayarlar ve beraberindeki uygulama aracılığıyla bir zamanlayıcı ayarlar.','<p>Alexa ve Google Asistan ile çalışır. Ses ve uygulama kontrolü. Enerji tasarruflu LED ışıklar.</p>'),('tr',20,'USB-C Kablo Pro',NULL,'Paraşüt kapaklı 100 W USB-C\'den USB-C\'ye kablo, 30.000\'den fazla katlanmaya dayanıklıdır.','<p>PD hızlı şarjı ve 10 Gbps veri iletimini destekler. 1m ve 2m uzunluklarda mevcuttur.</p>'),('tr',21,'USB-C Kablo Pro',NULL,'Paraşüt kapaklı 100 W USB-C\'den USB-C\'ye kablo, 30.000\'den fazla katlanmaya dayanıklıdır.','<p>PD hızlı şarjı ve 10 Gbps veri iletimini destekler. 1m ve 2m uzunluklarda mevcuttur.</p>'),('tr',22,'USB-C Kablo Pro',NULL,'Paraşüt kapaklı 100 W USB-C\'den USB-C\'ye kablo, 30.000\'den fazla katlanmaya dayanıklıdır.','<p>PD hızlı şarjı ve 10 Gbps veri iletimini destekler. 1m ve 2m uzunluklarda mevcuttur.</p>'),('tr',23,'Tablet Pro11',NULL,'M serisi çipli 11 inç Liquid Retina tablet; çizim yapmak, not almak ve film izlemek için idealdir.','<p>Apple Pencil ve Magic Keyboard ile uyumludur. Kapasite 128GB-2TB. Tüm gün dayanan pil ve Touch ID.</p>'),('tr',24,'Tablet Pro11',NULL,'M serisi çipli 11 inç Liquid Retina tablet; çizim yapmak, not almak ve film izlemek için idealdir.','<p>Apple Pencil ve Magic Keyboard ile uyumludur. Kapasite 128GB-2TB. Tüm gün dayanan pil ve Touch ID.</p>'),('tr',25,'Tablet Pro11',NULL,'M serisi çipli 11 inç Liquid Retina tablet; çizim yapmak, not almak ve film izlemek için idealdir.','<p>Apple Pencil ve Magic Keyboard ile uyumludur. Kapasite 128GB-2TB. Tüm gün dayanan pil ve Touch ID.</p>'),('tr',26,'Manyetik Telefon Standı',NULL,'Ağır hizmet tipi tabana ve eğim açısı ayarına sahip MagSafe uyumlu alüminyum montaj parçası.','<p>FaceTime, tarifleri görüntülemek veya şarj etmek için telefonunuzu mükemmel açıda tutar. Malzeme alüminyum ve silikon.</p>'),('tr',27,'Manyetik Telefon Standı',NULL,'Ağır hizmet tipi tabana ve eğim açısı ayarına sahip MagSafe uyumlu alüminyum montaj parçası.','<p>FaceTime, tarifleri görüntülemek veya şarj etmek için telefonunuzu mükemmel açıda tutar. Malzeme alüminyum ve silikon.</p>'),('vi',1,'iPhone 17 Pro Max',NULL,'Điện thoại thông minh cao cấp với khung titan, màn hình ProMotion và cụm ba camera chuyên nghiệp.','<p>Màn hình Super Retina XDR 6.9\", chip A19 Pro và zoom quang học 5x. Được thiết kế để chụp, chỉnh sửa và phát trực tiếp từ bất cứ đâu.</p>'),('vi',2,'Apple Watch S10',NULL,'Màn hình retina luôn bật với các cảm biến tiên tiến nhất cho thể chất và sức khỏe.','<p>Đo điện tâm đồ, nồng độ oxy trong máu và theo dõi giấc ngủ. Vỏ nhôm, tùy chọn 41mm và 45mm, pin 18 giờ.</p>'),('vi',3,'Wireless Charging Pad',NULL,'Sạc không dây nhanh 15W đạt chuẩn Qi với bề mặt silicon chống trượt.','<p>Tương thích với iPhone, AirPods và điện thoại Android. Cổng vào USB-C. Thân nhôm mỏng.</p>'),('vi',4,'Pro Earbuds Gen 4',NULL,'Chống ồn chủ động thích ứng, âm thanh không gian và tổng thời lượng phát 30 giờ cùng hộp sạc đi kèm.','<p>Kháng mồ hôi chuẩn IPX4. Micro kép giảm tiếng ồn cho cuộc gọi rõ hơn. Sạc qua USB-C và không dây.</p>'),('vi',5,'Smart Speaker Mini',NULL,'Loa thông minh nhỏ gọn với âm thanh 360 độ và trợ lý ảo tích hợp.','<p>Âm thanh đa phòng qua Wi-Fi và Bluetooth. Hỗ trợ Alexa, Google và AirPlay 2. Ghép nối chạm để kết nối.</p>'),('vi',6,'Smart Lamp WiFi',NULL,'Đèn thông minh Wi-Fi điều chỉnh độ sáng với 16 triệu màu và hẹn giờ qua ứng dụng đi kèm.','<p>Hoạt động với Alexa và Google Assistant. Điều khiển bằng giọng nói và ứng dụng. Đèn LED tiết kiệm năng lượng.</p>'),('vi',7,'USB-C Cable Pro',NULL,'Cáp USB-C sang USB-C 100W bọc dù, chịu được hơn 30.000 lần gập.','<p>Hỗ trợ sạc nhanh PD và truyền dữ liệu 10Gbps. Có sẵn các độ dài 1m và 2m.</p>'),('vi',8,'Action Camera 4K',NULL,'Camera hành trình 4K60 bỏ túi với chống rung HyperSmooth và thân máy chống nước.','<p>Ghi vào thẻ microSD đến 512GB. Phát trực tiếp, điều khiển bằng giọng nói và màn hình trước 2 inch.</p>'),('vi',9,'Tablet Pro 11',NULL,'Máy tính bảng Liquid Retina 11 inch với chip dòng M — lý tưởng để vẽ phác thảo, ghi chú và xem phim.','<p>Tương thích với Apple Pencil và Magic Keyboard. Dung lượng 128GB-2TB. Pin cả ngày và Touch ID.</p>'),('vi',10,'Magnetic Phone Stand',NULL,'Giá đỡ nhôm tương thích MagSafe với đế nặng và điều chỉnh góc nghiêng.','<p>Giữ điện thoại ở góc hoàn hảo cho FaceTime, xem công thức nấu ăn hoặc sạc. Chất liệu nhôm và silicon.</p>'),('vi',11,'Wireless Charging Pad',NULL,'Sạc không dây nhanh 15W đạt chuẩn Qi với bề mặt silicon chống trượt.','<p>Tương thích với iPhone, AirPods và điện thoại Android. Cổng vào USB-C. Thân nhôm mỏng.</p>'),('vi',12,'Pro Earbuds Gen 4',NULL,'Chống ồn chủ động thích ứng, âm thanh không gian và tổng thời lượng phát 30 giờ cùng hộp sạc đi kèm.','<p>Kháng mồ hôi chuẩn IPX4. Micro kép giảm tiếng ồn cho cuộc gọi rõ hơn. Sạc qua USB-C và không dây.</p>'),('vi',13,'Pro Earbuds Gen 4',NULL,'Chống ồn chủ động thích ứng, âm thanh không gian và tổng thời lượng phát 30 giờ cùng hộp sạc đi kèm.','<p>Kháng mồ hôi chuẩn IPX4. Micro kép giảm tiếng ồn cho cuộc gọi rõ hơn. Sạc qua USB-C và không dây.</p>'),('vi',14,'Smart Speaker Mini',NULL,'Loa thông minh nhỏ gọn với âm thanh 360 độ và trợ lý ảo tích hợp.','<p>Âm thanh đa phòng qua Wi-Fi và Bluetooth. Hỗ trợ Alexa, Google và AirPlay 2. Ghép nối chạm để kết nối.</p>'),('vi',15,'Smart Speaker Mini',NULL,'Loa thông minh nhỏ gọn với âm thanh 360 độ và trợ lý ảo tích hợp.','<p>Âm thanh đa phòng qua Wi-Fi và Bluetooth. Hỗ trợ Alexa, Google và AirPlay 2. Ghép nối chạm để kết nối.</p>'),('vi',16,'Smart Speaker Mini',NULL,'Loa thông minh nhỏ gọn với âm thanh 360 độ và trợ lý ảo tích hợp.','<p>Âm thanh đa phòng qua Wi-Fi và Bluetooth. Hỗ trợ Alexa, Google và AirPlay 2. Ghép nối chạm để kết nối.</p>'),('vi',17,'Smart Lamp WiFi',NULL,'Đèn thông minh Wi-Fi điều chỉnh độ sáng với 16 triệu màu và hẹn giờ qua ứng dụng đi kèm.','<p>Hoạt động với Alexa và Google Assistant. Điều khiển bằng giọng nói và ứng dụng. Đèn LED tiết kiệm năng lượng.</p>'),('vi',18,'Smart Lamp WiFi',NULL,'Đèn thông minh Wi-Fi điều chỉnh độ sáng với 16 triệu màu và hẹn giờ qua ứng dụng đi kèm.','<p>Hoạt động với Alexa và Google Assistant. Điều khiển bằng giọng nói và ứng dụng. Đèn LED tiết kiệm năng lượng.</p>'),('vi',19,'Smart Lamp WiFi',NULL,'Đèn thông minh Wi-Fi điều chỉnh độ sáng với 16 triệu màu và hẹn giờ qua ứng dụng đi kèm.','<p>Hoạt động với Alexa và Google Assistant. Điều khiển bằng giọng nói và ứng dụng. Đèn LED tiết kiệm năng lượng.</p>'),('vi',20,'USB-C Cable Pro',NULL,'Cáp USB-C sang USB-C 100W bọc dù, chịu được hơn 30.000 lần gập.','<p>Hỗ trợ sạc nhanh PD và truyền dữ liệu 10Gbps. Có sẵn các độ dài 1m và 2m.</p>'),('vi',21,'USB-C Cable Pro',NULL,'Cáp USB-C sang USB-C 100W bọc dù, chịu được hơn 30.000 lần gập.','<p>Hỗ trợ sạc nhanh PD và truyền dữ liệu 10Gbps. Có sẵn các độ dài 1m và 2m.</p>'),('vi',22,'USB-C Cable Pro',NULL,'Cáp USB-C sang USB-C 100W bọc dù, chịu được hơn 30.000 lần gập.','<p>Hỗ trợ sạc nhanh PD và truyền dữ liệu 10Gbps. Có sẵn các độ dài 1m và 2m.</p>'),('vi',23,'Tablet Pro 11',NULL,'Máy tính bảng Liquid Retina 11 inch với chip dòng M — lý tưởng để vẽ phác thảo, ghi chú và xem phim.','<p>Tương thích với Apple Pencil và Magic Keyboard. Dung lượng 128GB-2TB. Pin cả ngày và Touch ID.</p>'),('vi',24,'Tablet Pro 11',NULL,'Máy tính bảng Liquid Retina 11 inch với chip dòng M — lý tưởng để vẽ phác thảo, ghi chú và xem phim.','<p>Tương thích với Apple Pencil và Magic Keyboard. Dung lượng 128GB-2TB. Pin cả ngày và Touch ID.</p>'),('vi',25,'Tablet Pro 11',NULL,'Máy tính bảng Liquid Retina 11 inch với chip dòng M — lý tưởng để vẽ phác thảo, ghi chú và xem phim.','<p>Tương thích với Apple Pencil và Magic Keyboard. Dung lượng 128GB-2TB. Pin cả ngày và Touch ID.</p>'),('vi',26,'Magnetic Phone Stand',NULL,'Giá đỡ nhôm tương thích MagSafe với đế nặng và điều chỉnh góc nghiêng.','<p>Giữ điện thoại ở góc hoàn hảo cho FaceTime, xem công thức nấu ăn hoặc sạc. Chất liệu nhôm và silicon.</p>'),('vi',27,'Magnetic Phone Stand',NULL,'Giá đỡ nhôm tương thích MagSafe với đế nặng và điều chỉnh góc nghiêng.','<p>Giữ điện thoại ở góc hoàn hảo cho FaceTime, xem công thức nấu ăn hoặc sạc. Chất liệu nhôm và silicon.</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,1,NULL,NULL,7,5,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(2,9,NULL,NULL,2,2,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(3,3,NULL,NULL,8,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 19:02:21','2026-05-28 19:02:21',NULL),(4,5,NULL,NULL,1,1,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(5,10,NULL,NULL,4,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 19:02:21','2026-05-28 19:02:21',NULL),(6,3,NULL,NULL,1,3,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(7,10,NULL,NULL,5,5,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(8,3,NULL,NULL,4,2,'Clean & perfect source code','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(9,2,NULL,NULL,4,3,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(10,6,NULL,NULL,5,3,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(11,4,NULL,NULL,8,4,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(12,9,NULL,NULL,9,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 19:02:21','2026-05-28 19:02:21',NULL),(13,10,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 19:02:21','2026-05-28 19:02:21',NULL),(14,2,NULL,NULL,3,4,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(15,8,NULL,NULL,5,3,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(16,6,NULL,NULL,9,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 19:02:21','2026-05-28 19:02:21',NULL),(17,5,NULL,NULL,8,5,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(18,6,NULL,NULL,10,2,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(19,7,NULL,NULL,5,2,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(20,6,NULL,NULL,8,4,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(21,10,NULL,NULL,2,5,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(22,9,NULL,NULL,4,2,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(23,5,NULL,NULL,7,3,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(24,9,NULL,NULL,8,5,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(25,1,NULL,NULL,6,3,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(26,9,NULL,NULL,10,5,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(27,7,NULL,NULL,2,2,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(28,2,NULL,NULL,6,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 19:02:21','2026-05-28 19:02:21',NULL),(29,6,NULL,NULL,1,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 19:02:21','2026-05-28 19:02:21',NULL),(30,1,NULL,NULL,9,5,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(31,6,NULL,NULL,2,5,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(32,6,NULL,NULL,6,2,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(33,6,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 19:02:21','2026-05-28 19:02:21',NULL),(34,2,NULL,NULL,9,3,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(35,8,NULL,NULL,2,3,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(36,9,NULL,NULL,1,1,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(37,10,NULL,NULL,3,3,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(38,5,NULL,NULL,10,3,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(39,3,NULL,NULL,2,5,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(40,8,NULL,NULL,1,1,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(41,2,NULL,NULL,1,2,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(42,8,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 19:02:21','2026-05-28 19:02:21',NULL),(43,8,NULL,NULL,7,3,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(44,9,NULL,NULL,5,1,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(45,8,NULL,NULL,4,4,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(46,5,NULL,NULL,2,3,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(47,7,NULL,NULL,7,1,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(48,6,NULL,NULL,4,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 19:02:21','2026-05-28 19:02:21',NULL),(49,6,NULL,NULL,3,5,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(50,3,NULL,NULL,6,2,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(51,9,NULL,NULL,6,2,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(52,3,NULL,NULL,7,3,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(53,9,NULL,NULL,7,3,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(54,5,NULL,NULL,5,5,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(55,10,NULL,NULL,7,4,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(56,5,NULL,NULL,4,5,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(57,10,NULL,NULL,1,4,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(58,5,NULL,NULL,6,4,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(59,5,NULL,NULL,9,2,'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 19:02:21','2026-05-28 19:02:21',NULL),(60,7,NULL,NULL,1,1,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(61,8,NULL,NULL,9,2,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(62,9,NULL,NULL,3,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 19:02:21','2026-05-28 19:02:21',NULL),(63,2,NULL,NULL,7,5,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(64,8,NULL,NULL,6,1,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(65,10,NULL,NULL,8,4,'Clean & perfect source code','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(66,2,NULL,NULL,10,4,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(67,10,NULL,NULL,6,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 19:02:21','2026-05-28 19:02:21',NULL),(68,1,NULL,NULL,10,3,'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 19:02:21','2026-05-28 19:02:21',NULL),(69,4,NULL,NULL,7,1,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(70,1,NULL,NULL,5,1,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(71,4,NULL,NULL,3,5,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(72,7,NULL,NULL,3,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 19:02:21','2026-05-28 19:02:21',NULL),(73,1,NULL,NULL,8,4,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(74,2,NULL,NULL,2,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 19:02:21','2026-05-28 19:02:21',NULL),(75,1,NULL,NULL,3,1,'Clean & perfect source code','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(76,3,NULL,NULL,10,3,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(77,8,NULL,NULL,10,3,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(78,7,NULL,NULL,9,5,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(79,4,NULL,NULL,6,3,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(80,7,NULL,NULL,4,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 19:02:21','2026-05-28 19:02:21',NULL),(81,7,NULL,NULL,10,2,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(82,1,NULL,NULL,4,1,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(83,3,NULL,NULL,9,5,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(84,7,NULL,NULL,6,2,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(85,3,NULL,NULL,3,3,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(86,10,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 19:02:21','2026-05-28 19:02:21',NULL),(87,4,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 19:02:21','2026-05-28 19:02:21',NULL),(88,1,NULL,NULL,2,5,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(89,2,NULL,NULL,5,2,'Clean & perfect source code','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(90,4,NULL,NULL,9,1,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(91,4,NULL,NULL,2,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 19:02:21','2026-05-28 19:02:21',NULL),(92,3,NULL,NULL,5,1,'Clean & perfect source code','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(93,5,NULL,NULL,3,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 19:02:21','2026-05-28 19:02:21',NULL),(94,4,NULL,NULL,5,5,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(95,8,NULL,NULL,3,3,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(96,4,NULL,NULL,1,2,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(97,7,NULL,NULL,8,2,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL),(98,1,NULL,NULL,1,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 19:02:21','2026-05-28 19:02:21',NULL),(99,4,NULL,NULL,4,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 19:02:21','2026-05-28 19:02:21',NULL),(100,2,NULL,NULL,8,1,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:02:21','2026-05-28 19:02:21',NULL);

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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

INSERT INTO `ec_specification_tables` VALUES (1,'Default Specifications','Default specification layout applied to all products.','2026-05-28 19:02:10','2026-05-28 19:02:10',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`
--


--
