--
-- 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,'h081OKeVXRECheajbvWr6f064qH2eXq2',1,'2026-05-28 19:11:13','2026-05-28 19:11:13','2026-05-28 19:11:13');

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

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

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


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

CREATE TABLE `ads_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ads_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tablet_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ads_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ads_translations`
--


--
-- Table structure for table `announcements`
--

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

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


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

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

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


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

CREATE TABLE `audit_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `user_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Botble\\ACL\\Models\\User',
  `module` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `request` longtext COLLATE utf8mb4_unicode_ci,
  `action` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `actor_id` bigint unsigned NOT NULL,
  `actor_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Botble\\ACL\\Models\\User',
  `reference_id` bigint unsigned NOT NULL,
  `reference_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_histories_user_id_index` (`user_id`),
  KEY `audit_histories_module_index` (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_histories`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` bigint unsigned NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `author_id` bigint unsigned DEFAULT NULL,
  `author_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `icon` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int unsigned NOT NULL DEFAULT '0',
  `is_featured` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `categories_parent_id_index` (`parent_id`),
  KEY `categories_status_index` (`status`),
  KEY `categories_created_at_index` (`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` VALUES (1,'Training',0,'Programs, sets, and progressions for runners, lifters, and weekend athletes.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2026-05-28 19:11:13','2026-05-28 19:11:13'),(2,'Recovery',0,'Sleep, mobility, and active recovery practices that keep you in the game.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:11:13','2026-05-28 19:11:13'),(3,'Gear Reviews',0,'Honest takes on shoes, apparel, and training equipment — tested under load.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:11:13','2026-05-28 19:11:13'),(4,'Lifestyle',0,'Habits, mindset, and stories from athletes balancing real life and the work.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:11:13','2026-05-28 19:11:13'),(5,'Sports News',0,'Updates from the worlds of running, racquet sports, and emerging fitness movements.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:11:13','2026-05-28 19:11:13');

--
-- 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,'Entraînement','Conseils de formation au renforcement positif pour les chiots, les chatons et les animaux adultes.'),('fr',2,'Récupération','Les méthodes de sommeil, de mobilité et de récupération active vous maintiennent dans le jeu.'),('fr',3,'Avis sur les équipements','Commentaires honnêtes sur les chaussures, les vêtements et les équipements d\'entraînement – ​​testés sous charge.'),('fr',4,'Mode de vie','Conseils et habitudes pour utiliser la technologie intentionnellement au quotidien.'),('fr',5,'Actualités sportives','Restez informé du monde de la course à pied, des sports de raquette et des mouvements de fitness émergents.'),('id',1,'Pelatihan','Kiat pelatihan penguatan positif untuk anak anjing, anak kucing, dan hewan peliharaan dewasa.'),('id',2,'Pemulihan','Metode tidur, mobilitas, dan pemulihan aktif membuat Anda tetap bisa bermain.'),('id',3,'Ulasan Perlengkapan','Ulasan jujur ​​tentang sepatu, pakaian, dan peralatan olahraga — diuji di bawah beban.'),('id',4,'Gaya hidup','Tips dan kebiasaan memanfaatkan teknologi dengan sengaja setiap hari.'),('id',5,'Berita Olahraga','Ikuti perkembangan terkini dari dunia lari, olahraga raket, dan gerakan kebugaran yang sedang berkembang.'),('tr',1,'Eğitim','Yavru köpekler, yavru kediler ve yetişkin evcil hayvanlar için olumlu takviye eğitimi ipuçları.'),('tr',2,'İyileşmek','Uyku, hareketlilik ve aktif dinlenme yöntemleri sizi oyunda tutar.'),('tr',3,'Dişli İncelemeleri','Yük altında test edilen ayakkabılar, giysiler ve egzersiz ekipmanlarıyla ilgili dürüst incelemeler.'),('tr',4,'Yaşam Tarzı','Teknolojiyi her gün bilinçli olarak kullanmaya yönelik ipuçları ve alışkanlıklar.'),('tr',5,'Spor Haberleri','Koşu, raket sporları ve yeni ortaya çıkan fitness hareketleri dünyasından güncel kalın.'),('vi',1,'Huấn Luyện','Mẹo huấn luyện bằng phương pháp củng cố tích cực cho chó con, mèo con và thú cưng đã trưởng thành.'),('vi',2,'Phục Hồi','Giấc ngủ, sự vận động linh hoạt và các phương pháp phục hồi chủ động giữ bạn luôn trong cuộc chơi.'),('vi',3,'Đánh Giá Dụng Cụ','Những nhận định chân thực về giày, trang phục và thiết bị tập luyện — được kiểm chứng dưới tải trọng.'),('vi',4,'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.'),('vi',5,'Tin Tức Thể Thao','Cập nhật từ thế giới chạy bộ, thể thao dùng vợt và những phong trào thể hình mới nổi.');

--
-- 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:11:13','2026-05-28 19:11:13'),(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:11:13','2026-05-28 19:11:13'),(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:11:13','2026-05-28 19:11:13');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nationality` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_countries_name` (`name`),
  KEY `idx_countries_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--


--
-- Table structure for table `countries_translations`
--

CREATE TABLE `countries_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `countries_id` bigint unsigned NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nationality` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`countries_id`),
  KEY `idx_countries_trans_country_lang` (`countries_id`,`lang_code`),
  KEY `idx_countries_trans_name` (`name`),
  KEY `idx_countries_trans_countries_id` (`countries_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

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

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


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

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

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


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

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

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

INSERT INTO `ec_brands` VALUES (1,'Carolin','Performance footwear designed for runners and everyday athletes.','https://example.com/carolin','brands/carolin.png','published',0,1,'2026-05-28 19:11:14','2026-05-28 19:11:14'),(2,'Cheryl','Studio-tested apparel for yoga, pilates, and modern movement practices.','https://example.com/cheryl','brands/cheryl.png','published',1,1,'2026-05-28 19:11:14','2026-05-28 19:11:14'),(3,'Panadoxn','Strength equipment built for at-home training and small-studio gyms.','https://example.com/panadoxn','brands/panadoxn.png','published',2,1,'2026-05-28 19:11:14','2026-05-28 19:11:14'),(4,'Shangxi','Recovery and mobility tools trusted by physical therapists and coaches.','https://example.com/shangxi','brands/shangxi.png','published',3,1,'2026-05-28 19:11:14','2026-05-28 19:11:14'),(5,'Textitles','Technical sports apparel and base layers for endurance athletes.','https://example.com/textitles','brands/textitles.png','published',4,0,'2026-05-28 19:11:14','2026-05-28 19:11:14'),(6,'Vanfaba','Racquet sports gear and pickleball equipment crafted for competitive play.','https://example.com/vanfaba','brands/vanfaba.png','published',5,0,'2026-05-28 19:11:14','2026-05-28 19:11:14');

--
-- 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,'فانفابا','المجوهرات والأحزمة والسلع الجلدية الصغيرة تكمل مظهرك.'),('fr',1,'Caroline','Les bijoux demi-fins sont fabriqués à la main dans de petits ateliers en Italie.'),('fr',2,'Cheryl','Des motifs et des formes exceptionnels pour les femmes modernes.'),('fr',3,'Panadoxn','Cosmétiques naturels recherchés par des experts cliniques en plantes médicinales.'),('fr',4,'Shangxi','Thé du patrimoine, céramiques et accessoires de méditation.'),('fr',5,'Textes','Daim doux et tissu tissé pour des silhouettes décontractées de hobo et de sac à bandoulière.'),('fr',6,'Vanfaba','Bijoux décoratifs, ceintures et petite maroquinerie complètent votre look.'),('id',1,'Karolina','Perhiasan demi-fine dibuat dengan tangan di bengkel-bengkel kecil di Italia.'),('id',2,'Cheryl','Pola dan bentuk luar biasa untuk wanita modern.'),('id',3,'Panadoxn','Kosmetik alami yang diteliti oleh para ahli herbal klinis.'),('id',4,'Shangxi','Teh warisan, keramik, dan aksesoris meditasi.'),('id',5,'Tekstil','Suede lembut dan kain tenun untuk siluet hobo dan tas bahu kasual.'),('id',6,'Vanfaba','Perhiasan beraksen, ikat pinggang, dan barang-barang kulit kecil melengkapi penampilan Anda.'),('tr',1,'Carolin','Yarı kaliteli takılar İtalya\'daki küçük atölyelerde el yapımıdır.'),('tr',2,'Cheryl','Modern kadınlar için olağanüstü desenler ve şekiller.'),('tr',3,'Panadoxn','Klinik bitkisel uzmanlar tarafından araştırılan doğal kozmetikler.'),('tr',4,'Şangxi','Miras çay, seramik ve meditasyon aksesuarları.'),('tr',5,'Metinler','Gündelik serseri ve omuz çantası silüetleri için yumuşak süet ve dokuma kumaş.'),('tr',6,'Vanfaba','Vurgulu takılar, kemerler ve küçük deri eşyalar görünümünüzü tamamlıyor.'),('vi',1,'Carolin','Trang sức demi-fine làm thủ công tại các xưởng nhỏ ở Ý.'),('vi',2,'Cheryl','Họa tiết và phom dáng nổi bật dành cho phụ nữ hiện đại.'),('vi',3,'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',4,'Shangxi','Trà di sản, gốm sứ và phụ kiện thiền.'),('vi',5,'Textitles','Da lộn mềm mại và vải dệt cho các dáng túi hobo và túi đeo vai thường ngày.'),('vi',6,'Vanfaba','Trang sức tạo điểm nhấn, thắt lưng và đồ da nhỏ hoàn thiện diện mạo của bạn.');

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

--
-- 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-0104','GB','Arizona','Phoenix','321 Maple Drive',1,1,'2026-05-28 19:11:30','2026-05-28 19:11:30','19101'),(2,'Emma Collins','customer@botble.com','+1-555-0103','GB','Michigan','San Diego','789 Pine Road',1,0,'2026-05-28 19:11:30','2026-05-28 19:11:30','33101'),(3,'Sophia Ramirez','vendor@botble.com','+1-555-0109','GB','Ohio','Denver','258 Walnut Way',2,1,'2026-05-28 19:11:31','2026-05-28 19:11:31','33101'),(4,'Sophia Ramirez','vendor@botble.com','+1-555-0101','US','Arizona','Chicago','369 Cherry Circle',2,0,'2026-05-28 19:11:31','2026-05-28 19:11:31','19101'),(5,'Olivia Carter','customer1@example.com','+1-555-0110','DE','New York','Miami','123 Main Street',3,1,'2026-05-28 19:11:31','2026-05-28 19:11:31','60601'),(6,'Ava Mitchell','customer2@example.com','+1-555-0109','US','California','New York','789 Pine Road',4,1,'2026-05-28 19:11:32','2026-05-28 19:11:32','90210'),(7,'Isabella Brooks','customer3@example.com','+1-555-0104','GB','Ohio','Chicago','456 Oak Avenue',5,1,'2026-05-28 19:11:32','2026-05-28 19:11:32','90210'),(8,'James Whitfield','customer4@example.com','+1-555-0109','AU','California','Miami','741 Spruce Street',6,1,'2026-05-28 19:11:33','2026-05-28 19:11:33','85001'),(9,'Liam Bennett','customer5@example.com','+1-555-0104','AU','Texas','Dallas','987 Birch Boulevard',7,1,'2026-05-28 19:11:33','2026-05-28 19:11:33','30301'),(10,'Noah Patterson','customer6@example.com','+1-555-0103','DE','Pennsylvania','Austin','123 Main Street',8,1,'2026-05-28 19:11:33','2026-05-28 19:11:33','60601'),(11,'Charlotte Reed','customer7@example.com','+1-555-0106','US','Georgia','New York','258 Walnut Way',9,1,'2026-05-28 19:11:34','2026-05-28 19:11:34','30301'),(12,'Amelia Foster','customer8@example.com','+1-555-0109','CA','Texas','Houston','321 Maple Drive',10,1,'2026-05-28 19:11:34','2026-05-28 19:11:34','30301');

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

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

--
-- Dumping data for table `ec_customer_recently_viewed_products`
--


--
-- Table structure for table `ec_customer_used_coupons`
--

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

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


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

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

--
-- Dumping data for table `ec_discount_customers`
--


--
-- Table structure for table `ec_discount_product_categories`
--

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

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


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

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

--
-- Dumping data for table `ec_discount_product_collections`
--


--
-- Table structure for table `ec_discount_products`
--

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

--
-- Dumping data for table `ec_discount_products`
--


--
-- Table structure for table `ec_discounts`
--

CREATE TABLE `ec_discounts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `total_used` int unsigned NOT NULL DEFAULT '0',
  `value` double DEFAULT NULL,
  `type` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT 'coupon',
  `can_use_with_promotion` tinyint(1) NOT NULL DEFAULT '0',
  `can_use_with_flash_sale` tinyint(1) NOT NULL DEFAULT '0',
  `discount_on` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_quantity` int unsigned DEFAULT NULL,
  `type_option` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'amount',
  `target` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'all-orders',
  `min_order_price` decimal(15,2) DEFAULT NULL,
  `apply_via_url` tinyint(1) NOT NULL DEFAULT '0',
  `display_at_checkout` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `store_id` bigint unsigned DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_discounts_code_unique` (`code`),
  KEY `ec_discounts_store_id_index` (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--
-- Table structure for table `ec_flash_sale_products`
--

CREATE TABLE `ec_flash_sale_products` (
  `flash_sale_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  `price` double unsigned DEFAULT NULL,
  `quantity` int unsigned DEFAULT NULL,
  `sold` int unsigned NOT NULL DEFAULT '0',
  KEY `ec_flash_sale_products_product_id_flash_sale_id_index` (`product_id`,`flash_sale_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_flash_sale_products`
--

INSERT INTO `ec_flash_sale_products` VALUES (1,6,41.3,50,0),(1,3,17.5,50,0),(1,4,55.3,50,0),(1,8,69.3,50,0),(1,7,27.3,50,0),(1,2,34.3,50,0),(1,5,13.3,50,0),(2,9,44.25,75,0),(2,2,36.75,75,0),(2,8,74.25,75,0),(2,3,18.75,75,0),(2,4,59.25,75,0),(2,5,14.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:11:35','published','2026-05-28 19:11:35','2026-05-28 19:11:35'),(2,'Weekend Doorbusters','2026-06-03 02:11:35','published','2026-05-28 19:11:35','2026-05-28 19:11:35');

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

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

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

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

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

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

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

CREATE TABLE `ec_grouped_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `parent_product_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  `fixed_qty` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_grouped_products`
--


--
-- Table structure for table `ec_invoice_item_tax_components`
--

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

CREATE TABLE `ec_order_product` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `qty` int NOT NULL,
  `price` decimal(15,2) NOT NULL,
  `tax_amount` decimal(15,2) DEFAULT '0.00',
  `tax_breakdown` json DEFAULT NULL,
  `options` text COLLATE utf8mb4_unicode_ci,
  `product_options` text COLLATE utf8mb4_unicode_ci COMMENT 'product option data',
  `product_id` bigint unsigned DEFAULT NULL,
  `product_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` double DEFAULT '0',
  `restock_quantity` int unsigned DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `product_type` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'physical',
  `times_downloaded` int NOT NULL DEFAULT '0',
  `license_code` text COLLATE utf8mb4_unicode_ci,
  `downloaded_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_order_product_order_id_product_id_index` (`order_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

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

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


--
-- Table structure for table `ec_order_referrals`
--

CREATE TABLE `ec_order_referrals` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(39) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `landing_domain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `landing_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `landing_params` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referral` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gclid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fclid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_source` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_campaign` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_medium` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_term` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_content` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referrer_url` text COLLATE utf8mb4_unicode_ci,
  `referrer_domain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_order_referrals_order_id_index` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_order_referrals`
--


--
-- Table structure for table `ec_order_return_histories`
--

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

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


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

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

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


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

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

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


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

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

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


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

CREATE TABLE `ec_product_attribute_sets` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `display_layout` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'dropdown',
  `is_searchable` tinyint unsigned NOT NULL DEFAULT '1',
  `is_comparable` tinyint unsigned NOT NULL DEFAULT '1',
  `is_use_in_product_listing` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `order` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `use_image_from_product_variation` tinyint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_order_id` (`order`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

CREATE TABLE `ec_product_attributes_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_attributes_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_product_attributes_id`),
  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=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_product_categories` VALUES (1,'Running Shoes',NULL,0,'Cushioned trainers and lightweight racers for every distance.','published',0,NULL,1,'2026-05-28 19:11:14','2026-05-28 19:11:14',NULL,NULL),(2,'Hand Weights',NULL,0,'Dumbbells, kettlebells, and grip-friendly weights for at-home strength work.','published',1,NULL,1,'2026-05-28 19:11:14','2026-05-28 19:11:14',NULL,NULL),(3,'Sports Apparel',NULL,0,'Performance shorts, tops, and layering pieces engineered for movement.','published',2,NULL,1,'2026-05-28 19:11:14','2026-05-28 19:11:14',NULL,NULL),(4,'Yoga Mats',NULL,0,'High-grip yoga and pilates mats for studio and home practice.','published',3,NULL,1,'2026-05-28 19:11:14','2026-05-28 19:11:14',NULL,NULL),(5,'Pickleball',NULL,0,'Paddles, balls, and pickleball gear for the fastest-growing sport.','published',4,NULL,1,'2026-05-28 19:11:14','2026-05-28 19:11:14',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,'مضارب وكرات ومعدات كرة البيسبول للرياضة الأسرع نموًا.'),('fr',1,'Chaussures de course',NULL,'Baskets coussinées et chaussures de course légères pour toutes les distances.'),('fr',2,'Poids à main',NULL,'Haltères, kettlebells et haltères faciles à saisir pour l\'entraînement de force à la maison.'),('fr',3,'Vêtements de sport',NULL,'Shorts, hauts et vêtements superposés haute performance conçus pour le mouvement.'),('fr',4,'Tapis de yoga',NULL,'Tapis de yoga et de Pilates à haute adhérence pour la pratique en studio et à domicile.'),('fr',5,'Pickleball',NULL,'Raquettes, balles et équipements de pickleball pour le sport à la croissance la plus rapide.'),('id',1,'Sepatu Lari',NULL,'Sepatu kets berbantalan dan sepatu balap ringan untuk segala jarak.'),('id',2,'Beban Tangan',NULL,'Dumbel, kettlebell, dan dumbel yang mudah digenggam untuk latihan kekuatan di rumah.'),('id',3,'Pakaian Olahraga',NULL,'Celana pendek, atasan, dan perlengkapan pelapis berperforma tinggi yang dirancang untuk bergerak.'),('id',4,'Matras Yoga',NULL,'Matras yoga dan pilates dengan cengkeraman tinggi untuk latihan di studio dan di rumah.'),('id',5,'bola acar',NULL,'Raket, bola, dan perlengkapan Pickleball untuk olahraga yang paling cepat berkembang.'),('tr',1,'Koşu Ayakkabısı',NULL,'Tüm mesafeler için yastıklamalı spor ayakkabılar ve hafif yarış ayakkabıları.'),('tr',2,'El Ağırlıkları',NULL,'Evde kuvvet antrenmanı için dambıllar, kettlebell\'ler ve tutması kolay dambıllar.'),('tr',3,'Spor Giyim',NULL,'Hareket için tasarlanmış yüksek performanslı şortlar, üstler ve üstler.'),('tr',4,'Yoga Matları',NULL,'Stüdyo ve ev uygulamaları için yüksek tutuşlu yoga ve pilates matları.'),('tr',5,'Turşu topu',NULL,'En hızlı büyüyen spor için turşu raketleri, topları ve ekipmanları.'),('vi',1,'Giày Chạy Bộ',NULL,'Giày tập có đệm và giày đua nhẹ cho mọi cự ly.'),('vi',2,'Tạ Tay',NULL,'Tạ đơn, tạ ấm và tạ dễ cầm nắm cho bài tập sức mạnh tại nhà.'),('vi',3,'Trang Phục Thể Thao',NULL,'Quần short, áo và đồ mặc lớp hiệu năng cao được thiết kế cho chuyển động.'),('vi',4,'Thảm Yoga',NULL,'Thảm yoga và pilates độ bám cao cho luyện tập tại studio và tại nhà.'),('vi',5,'Pickleball',NULL,'Vợt, bóng và dụng cụ pickleball cho môn thể thao phát triển nhanh nhất.');

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

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

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


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

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

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

INSERT INTO `ec_product_category_product` VALUES (1,1),(1,2),(1,3),(1,4),(1,5),(1,6),(1,7),(1,8),(1,9),(1,10),(2,1),(2,3),(2,4),(2,5),(2,8),(2,9),(2,10),(3,1),(3,2),(3,3),(3,6),(3,7),(3,8),(3,9),(3,10),(4,1),(4,2),(4,3),(4,4),(4,5),(4,6),(4,7),(4,8),(5,2),(5,4),(5,5),(5,6),(5,7),(5,9),(5,10);

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

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

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

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

INSERT INTO `ec_product_collections` VALUES (1,'Performance','performance','Sport apparel and basics built for daily training — moisture-wicking tees, shorts, and active basics.','collection/cls-1.jpg','published','2026-05-28 19:11:14','2026-05-28 19:11:14',1),(2,'Precision Gear','precision-gear','High-performance equipment dialed in for your ultimate game.','collection/cls-10.jpg','published','2026-05-28 19:11:14','2026-05-28 19:11:14',1),(3,'Peak Performance','peak-performance','Pro-level gear for athletes chasing their best result.','collection/cls-11.jpg','published','2026-05-28 19:11:14','2026-05-28 19:11:14',1),(4,'Strength Training Essentials','strength-training-essentials','Build power and control','section/banner-62.jpg','published','2026-05-28 19:11:14','2026-05-28 19:11:14',1),(5,'Outdoor Active Protection Gear','outdoor-active-protection-gear','Move safely outdoors.','section/banner-63.jpg','published','2026-05-28 19:11:15','2026-05-28 19:11:15',0),(6,'Court Sports Game Gear','court-sports-game-gear','Play compete enjoy.','section/banner-64.jpg','published','2026-05-28 19:11:15','2026-05-28 19:11:15',0),(7,'Best Sellers','best-sellers','The sport picks our customers reorder season after season.','section/banner-1.jpg','published','2026-05-28 19:11:15','2026-05-28 19:11:15',0),(8,'New Arrivals','new-arrivals','Fresh drops from the brands powering elite athletes.','section/banner-2.jpg','published','2026-05-28 19:11:15','2026-05-28 19:11:15',0),(9,'Featured','featured','Hand-picked sport essentials our team is training in right now.','section/banner-3.jpg','published','2026-05-28 19:11:15','2026-05-28 19:11:15',0);

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

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

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

INSERT INTO `ec_product_collections_translations` VALUES ('ar',1,'أداء','مصنوع للتمارين اليومية - يتخلص من العرق، وداعم، ومتين.'),('ar',2,'معدات الدقة','معدات عالية الأداء تم ضبطها لتناسب لعبتك المثالية.'),('ar',3,'ذروة الأداء','معدات احترافية للرياضيين الذين يسعون لتحقيق أفضل أداء لهم.'),('ar',4,'أساسيات تدريب القوة','بناء القوة والسيطرة.'),('ar',5,'معدات الحماية النشطة في الهواء الطلق','التحرك بأمان في الهواء الطلق.'),('ar',6,'معدات لعبة المحكمة الرياضية','العب، تنافس، استمتع.'),('ar',7,'أفضل البائعين','المنتجات التي يثق بها العملاء ويعيدون طلبها في كل موسم.'),('ar',8,'الوافدون الجدد','يتم اختيار نماذج جديدة كل أسبوع.'),('ar',9,'مميز','أحذية رياضية أساسية اختارها فريقنا ويتم ارتداؤها الآن.'),('fr',1,'Performance','Conçu pour les entraînements quotidiens : évacuant la transpiration, offrant un bon maintien et durable.'),('fr',2,'Équipement de précision','Un équipement haute performance conçu pour votre jeu ultime.'),('fr',3,'Performances maximales','Équipement de qualité professionnelle pour les athlètes qui recherchent leurs meilleures performances.'),('fr',4,'Les essentiels de l’entraînement en force','Développez la force et le contrôle.'),('fr',5,'Équipement de protection active extérieure','Déplacez-vous à l’extérieur en toute sécurité.'),('fr',6,'Équipement de jeu de sports de terrain','Jouez, rivalisez, profitez-en.'),('fr',7,'Meilleures ventes','Des produits auxquels les clients font confiance et qui les commandent chaque saison.'),('fr',8,'Nouveautés','De nouveaux modèles sont sélectionnés chaque semaine.'),('fr',9,'En vedette','Des baskets incontournables sélectionnées par notre équipe et portées en ce moment.'),('id',1,'Pertunjukan','Dibuat untuk olahraga sehari-hari — menyerap keringat, suportif, dan tahan lama.'),('id',2,'Perlengkapan Presisi','Perlengkapan berperforma tinggi yang disesuaikan untuk permainan pamungkas Anda.'),('id',3,'Performa Puncak','Perlengkapan kelas profesional untuk atlet yang mengejar performa terbaiknya.'),('id',4,'Esensi Pelatihan Kekuatan','Bangun kekuatan dan kendali.'),('id',5,'Perlengkapan Perlindungan Aktif Luar Ruangan','Bergerak dengan aman di luar ruangan.'),('id',6,'Perlengkapan Permainan Olahraga Lapangan','Mainkan, berkompetisi, nikmati.'),('id',7,'Terlaris','Produk yang dipercaya dan dipesan ulang oleh pelanggan setiap musim.'),('id',8,'Pendatang Baru','Model-model baru dipilih setiap minggu.'),('id',9,'Unggulan','Sepatu kets esensial yang dipilih oleh tim kami dan sedang dipakai saat ini.'),('tr',1,'Performans','Günlük antrenmanlar için tasarlandı; ter tutmaz, destekleyici ve dayanıklıdır.'),('tr',2,'Hassas Dişli','En iyi oyununuz için ayarlanmış yüksek performanslı donanım.'),('tr',3,'En Yüksek Performans','En iyi performanslarını arayan sporcular için profesyonel kalitede ekipmanlar.'),('tr',4,'Güç Antrenmanının Temelleri','Güç ve kontrol oluşturun.'),('tr',5,'Dış Mekan Aktif Koruma Donanımı','Açık havada güvenle hareket edin.'),('tr',6,'Mahkeme Sporları Oyun Ekipmanı','Oynayın, yarışın, tadını çıkarın.'),('tr',7,'En Çok Satanlar','Müşterilerin güvendiği ve her sezon yeniden sipariş ettiği ürünler.'),('tr',8,'Yeni Gelenler','Her hafta yeni modeller seçiliyor.'),('tr',9,'Öne Çıkanlar','Ekibimiz tarafından seçilen ve şu anda giyilen vazgeçilmez spor ayakkabılar.'),('vi',1,'Hiệu Năng','Được làm cho tập luyện hàng ngày — thấm hút mồ hôi, hỗ trợ tốt, bền bỉ.'),('vi',2,'Dụng Cụ Chính Xác','Thiết bị hiệu năng cao được tinh chỉnh cho trận đấu đỉnh cao của bạn.'),('vi',3,'Hiệu Năng Đỉnh Cao','Dụng cụ cấp độ chuyên nghiệp cho những vận động viên theo đuổi thành tích tốt nhất.'),('vi',4,'Đồ Thiết Yếu Cho Tập Sức Mạnh','Xây dựng sức mạnh và sự kiểm soát.'),('vi',5,'Đồ Bảo Vệ Vận Động Ngoài Trời','Di chuyển an toàn ngoài trời.'),('vi',6,'Dụng Cụ Thi Đấu Thể Thao Sân','Chơi, thi đấu, tận hưởng.'),('vi',7,'Bán chạy nhất','Những sản phẩm được khách hàng tin dùng và đặt lại qua từng mùa.'),('vi',8,'Hàng Mới Về','Những mẫu mới được tuyển chọn mỗi tuần.'),('vi',9,'Nổi Bật','Những đôi sneaker thiết yếu được đội ngũ của chúng tôi tuyển chọn và đang mang ngay lúc này.');

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

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

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

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

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

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

--
-- Table structure for table `ec_product_variation_items`
--

CREATE TABLE `ec_product_variation_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `attribute_id` bigint unsigned NOT NULL,
  `variation_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_product_variation_items_attribute_id_variation_id_unique` (`attribute_id`,`variation_id`),
  KEY `attribute_variation_index` (`attribute_id`,`variation_id`),
  KEY `idx_variation_id` (`variation_id`),
  KEY `idx_variation_attribute_covering` (`variation_id`,`attribute_id`),
  KEY `ec_product_variation_items_variation_id_attribute_id_index` (`variation_id`,`attribute_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

CREATE TABLE `ec_product_variations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned DEFAULT NULL,
  `configurable_product_id` bigint unsigned NOT NULL,
  `is_default` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_product_variations_product_id_configurable_product_id_unique` (`product_id`,`configurable_product_id`),
  KEY `configurable_product_index` (`product_id`,`configurable_product_id`),
  KEY `idx_configurable_product_id` (`configurable_product_id`),
  KEY `idx_product_variations_config` (`configurable_product_id`,`is_default`),
  KEY `ec_product_variations_product_id_index` (`product_id`),
  KEY `ec_product_variations_configurable_product_id_index` (`configurable_product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

INSERT INTO `ec_products` VALUES (1,'Men\'s Running JF190.1 Grip White','mens-running-jf1901-grip-white','Lightweight neutral trainer with responsive foam midsole and breathable mesh upper in clean white.','<p>Engineered for daily mileage, the JF190.1 balances cushion with energy return. Recycled-plastic upper, 8mm drop, suitable for road and groomed paths.</p>','published','[\"products\\/sport\\/product-1.jpg\"]',NULL,'JO-196-A1',0,17,0,1,'in_stock',0,NULL,3,0,3,10,3.60,0,99.99,69.99,NULL,NULL,11,17,20,752,NULL,'standard',47158,'2026-05-28 19:11:23','2026-05-28 19:11:39',1,0,'Botble\\ACL\\Models\\User',0,'products/sport/product-1.jpg','physical','0779490252052',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(2,'Set Of 2 3kg Hand Weights','set-of-2-3kg-hand-weights','Vinyl-coated 3kg dumbbell pair with hexagonal anti-roll heads. Sold as a matched set of two.','<p>Comfortable contoured grip, ideal for HIIT, sculpting, and rehab work. Hex heads keep the weights stable on any flat surface.</p>','published','[\"products\\/sport\\/product-2.jpg\"]',NULL,'IW-132',0,17,0,1,'in_stock',1,NULL,2,0,0,10,3.80,0,49.99,29.99,NULL,NULL,13,12,11,899,NULL,'standard',92418,'2026-05-28 19:11:24','2026-05-28 19:11:39',2,0,'Botble\\ACL\\Models\\User',0,'products/sport/product-2.jpg','physical','3202528983101',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(3,'Tennis Ball With Elastic String','tennis-ball-with-elastic-string','Solo trainer tennis ball tethered with an elastic cord — practice strokes anywhere.','<p>Felt-covered ball with a high-tension elastic return. Great for grooving forehands, backhands, and serves without a partner or court.</p>','published','[\"products\\/sport\\/product-3.jpg\"]',NULL,'GL-195-A1',0,19,0,1,'in_stock',0,NULL,6,0,2,10,3.50,0,25.99,15.99,NULL,NULL,11,12,12,666,NULL,'standard',69634,'2026-05-28 19:11:24','2026-05-28 19:11:39',3,0,'Botble\\ACL\\Models\\User',0,'products/sport/product-3.jpg','physical','9206069765886',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(4,'Pickleball Racket - Kuikma Open Blue','pickleball-racket-kuikma-open-blue','Tournament-ready pickleball paddle with graphite face and honeycomb polymer core.','<p>USAPA-approved, 8oz playing weight, perforated cushion grip for sweaty conditions. Great for control and finesse play.</p>','published','[\"products\\/sport\\/product-4.jpg\",\"products\\/sport\\/product-4-2.jpg\",\"products\\/sport\\/product-4-3.jpg\",\"products\\/sport\\/product-4-4.jpg\"]',NULL,'UW-127-A1',0,13,0,1,'in_stock',1,NULL,2,0,3,10,2.90,0,79.99,45.99,NULL,NULL,20,20,18,623,NULL,'standard',195772,'2026-05-28 19:11:24','2026-05-28 19:11:39',4,0,'Botble\\ACL\\Models\\User',0,'products/sport/product-4.jpg','physical','6942814839107',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(5,'Men\'s Sports T-Shirt - Dry Brown','mens-sports-t-shirt-dry-brown','Sweat-wicking active tee in dry brown — quick-dry knit with mesh side panels.','<p>Lightweight polyester blend keeps you cool through long sets. Flatlock seams reduce chafe and the dropped hem stays put through every rep.</p>','published','[\"products\\/sport\\/product-5.jpg\"]',NULL,'H3-123',0,17,0,1,'in_stock',0,NULL,1,0,0,10,3.30,0,19.99,9.99,NULL,NULL,13,18,20,875,NULL,'standard',90099,'2026-05-28 19:11:24','2026-05-28 19:11:39',1,0,'Botble\\ACL\\Models\\User',0,'products/sport/product-5.jpg','physical','2023700324977',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(6,'Women\'s Thin and Light Sports Shorts Black','womens-thin-and-light-sports-shorts-black','Featherweight running shorts with built-in liner and zippered key pocket.','<p>4-way stretch fabric, breathable mesh inner brief, and reflective hits for low-light visibility. Cut for natural stride and fast pace.</p>','published','[\"products\\/sport\\/product-6.jpg\"]',NULL,'MA-156',0,16,0,1,'in_stock',1,NULL,4,0,0,10,2.90,0,59.99,34.99,NULL,NULL,13,16,16,588,NULL,'standard',78594,'2026-05-28 19:11:25','2026-05-28 19:11:39',2,0,'Botble\\ACL\\Models\\User',0,'products/sport/product-6.jpg','physical','0977924058618',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(7,'4mm Ultra Grip Yoga Mat - Blue Grip','4mm-ultra-grip-yoga-mat-blue-grip','Eco-friendly natural rubber yoga mat with non-slip top texture in calm blue.','<p>4mm thick for joint cushion without losing floor feel. PVC-free, latex-free, and biodegradable. Carrying strap included.</p>','published','[\"products\\/sport\\/product-7.jpg\"]',NULL,'P1-151-A1',0,13,0,1,'in_stock',1,NULL,6,0,3,10,2.60,0,39.99,22.99,NULL,NULL,19,16,13,743,NULL,'standard',106293,'2026-05-28 19:11:25','2026-05-28 19:11:39',3,0,'Botble\\ACL\\Models\\User',0,'products/sport/product-7.jpg','physical','4782195672793',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(8,'20L Sports Bag - Gray','20l-sports-bag-gray','Compact 20L gym duffel in gray with ventilated shoe compartment and reinforced straps.','<p>Fits a full gym kit plus shoes. Zippered side pockets, water-resistant base panel, and a padded shoulder strap.</p>','published','[\"products\\/sport\\/product-8.jpg\"]',NULL,'PS-182',0,14,0,1,'in_stock',0,NULL,1,0,0,10,2.80,0,99.99,67.99,NULL,NULL,20,10,10,867,NULL,'standard',4872,'2026-05-28 19:11:25','2026-05-28 19:11:39',4,0,'Botble\\ACL\\Models\\User',0,'products/sport/product-8.jpg','physical','6043694020965',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(9,'Resistance Bands Set','resistance-bands-set','Five-band stackable resistance set with handles, ankle straps, and door anchor.','<p>Combine bands for up to 150lb resistance. Carry bag and printed exercise guide included.</p>','published','[\"products\\/sport\\/product-9.jpg\"]',NULL,'IC-133',0,20,0,1,'in_stock',0,NULL,1,0,0,10,3.10,0,59,39,NULL,NULL,15,13,14,697,NULL,'standard',104228,'2026-05-28 19:11:25','2026-05-28 19:11:39',1,0,'Botble\\ACL\\Models\\User',0,'products/sport/product-9.jpg','physical','5272133183942',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(10,'Foam Roller Pro','foam-roller-pro','High-density 24-inch foam roller with textured surface for deep tissue work.','<p>EVA construction holds shape under repeated heavy use. Targets quads, glutes, IT band, and upper back.</p>','published','[\"products\\/sport\\/product-10.jpg\"]',NULL,'SB-115',0,20,0,1,'in_stock',1,NULL,6,0,0,10,3.10,0,59,39,NULL,NULL,15,18,16,732,NULL,'standard',91066,'2026-05-28 19:11:26','2026-05-28 19:11:39',2,0,'Botble\\ACL\\Models\\User',0,'products/sport/product-10.jpg','physical','5787482635290',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(11,'Men\'s Running JF190.1 Grip White',NULL,NULL,NULL,'published','[\"products\\/sport\\/product-1.jpg\"]',NULL,'JO-196-A1',0,17,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,99.99,NULL,NULL,NULL,11,17,20,752,NULL,'standard',0,'2026-05-28 19:11:26','2026-05-28 19:11:39',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6969567689810',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(12,'Men\'s Running JF190.1 Grip White',NULL,NULL,NULL,'published','[\"products\\/sport\\/product-1.jpg\"]',NULL,'JO-196-A1-A2',0,17,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,99.99,NULL,NULL,NULL,11,17,20,752,NULL,'standard',0,'2026-05-28 19:11:26','2026-05-28 19:11:39',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8677021394597',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(13,'Men\'s Running JF190.1 Grip White',NULL,NULL,NULL,'published','[\"products\\/sport\\/product-1.jpg\"]',NULL,'JO-196-A1-A3',0,17,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,99.99,NULL,NULL,NULL,11,17,20,752,NULL,'standard',0,'2026-05-28 19:11:27','2026-05-28 19:11:39',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2979667165699',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(14,'Tennis Ball With Elastic String',NULL,NULL,NULL,'published','[\"products\\/sport\\/product-3.jpg\"]',NULL,'GL-195-A1',0,19,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,25.99,NULL,NULL,NULL,11,12,12,666,NULL,'standard',0,'2026-05-28 19:11:27','2026-05-28 19:11:39',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8240577440638',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(15,'Tennis Ball With Elastic String',NULL,NULL,NULL,'published','[\"products\\/sport\\/product-3.jpg\"]',NULL,'GL-195-A1-A2',0,19,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,25.99,NULL,NULL,NULL,11,12,12,666,NULL,'standard',0,'2026-05-28 19:11:27','2026-05-28 19:11:39',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','3046713631541',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(16,'Pickleball Racket - Kuikma Open Blue',NULL,NULL,NULL,'published','[\"products\\/sport\\/product-4-2.jpg\"]',NULL,'UW-127-A1',0,13,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,79.99,69.5913,NULL,NULL,20,20,18,623,NULL,'standard',0,'2026-05-28 19:11:27','2026-05-28 19:11:39',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','1213328710691',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(17,'Pickleball Racket - Kuikma Open Blue',NULL,NULL,NULL,'published','[\"products\\/sport\\/product-4-3.jpg\"]',NULL,'UW-127-A1-A2',0,13,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,79.99,61.5923,NULL,NULL,20,20,18,623,NULL,'standard',0,'2026-05-28 19:11:28','2026-05-28 19:11:39',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9953343010858',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(18,'Pickleball Racket - Kuikma Open Blue',NULL,NULL,NULL,'published','[\"products\\/sport\\/product-4-4.jpg\"]',NULL,'UW-127-A1-A3',0,13,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,79.99,67.1916,NULL,NULL,20,20,18,623,NULL,'standard',0,'2026-05-28 19:11:28','2026-05-28 19:11:39',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8804987154112',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(19,'4mm Ultra Grip Yoga Mat - Blue Grip',NULL,NULL,NULL,'published','[\"products\\/sport\\/product-7.jpg\"]',NULL,'P1-151-A1',0,13,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,39.99,NULL,NULL,NULL,19,16,13,743,NULL,'standard',0,'2026-05-28 19:11:28','2026-05-28 19:11:39',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4608311539200',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(20,'4mm Ultra Grip Yoga Mat - Blue Grip',NULL,NULL,NULL,'published','[\"products\\/sport\\/product-7.jpg\"]',NULL,'P1-151-A1-A2',0,13,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,39.99,NULL,NULL,NULL,19,16,13,743,NULL,'standard',0,'2026-05-28 19:11:28','2026-05-28 19:11:39',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','1937809770409',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(21,'4mm Ultra Grip Yoga Mat - Blue Grip',NULL,NULL,NULL,'published','[\"products\\/sport\\/product-7.jpg\"]',NULL,'P1-151-A1-A3',0,13,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,39.99,NULL,NULL,NULL,19,16,13,743,NULL,'standard',0,'2026-05-28 19:11:28','2026-05-28 19:11:39',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5274871477659',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,'حذاء جري للرجال JF190.1 باللون الأبيض',NULL,'يركز الحذاء على الخفة مع نعل أوسط من الفوم المرن وشبكة علوية بيضاء نظيفة قابلة للتنفس.','<p> مصمم للركوب اليومي، يوازن JF190.1 بين الراحة واستعادة الطاقة. الجسم مصنوع من البلاستيك المعاد تدويره، إزاحة 8 مم، مناسب للطرق الإسفلتية والممرات المسطحة.</p>'),('ar',2,'مجموعة من أوزان يدوية 3 كجم',NULL,'زوج من الدمبل المطلي بالفينيل بوزن 3 كجم مع أوزان سداسية مضادة للدوران. تباع في مجموعات من قطعتين متطابقتين.','<p> مقبض مريح، مثالي لتمارين HIIT والنحت والتعافي. يحافظ رأس الدمبل السداسي على ثبات الوزن على أي سطح مستو.</p>'),('ar',3,'كرة تنس بخيط مطاطي',NULL,'ترتبط كرات التنس الخاصة بالتدريب الشخصي بأربطة مطاطية، ويمكنك ممارسة التأرجح في أي مكان.','<p> كرة مغطاة باللباد مع شريط مطاطي عالي التمدد. رائعة للتدريب على الضربات الأمامية والخلفية والإرسال بدون شريك أو ملعب.</p>'),('ar',4,'مضرب كرة البيسبول - كويكما مفتوح باللون الأزرق',NULL,'مضرب كرة البيسبول جاهز للمنافسة مع وجه جرافيت وقلب بوليمر على شكل قرص العسل.','<p>USAPA معتمد، وزن اللعب 8 أونصة، مقبض مبطن مثقوب لظروف التعرق. رائعة للعب المتحكم والمحسن.</p>'),('ar',5,'تيشيرت رياضي رجالي - بني جاف',NULL,'تي شيرت رياضي بني جاف يتخلص من العرق — نسيج منسوج سريع الجفاف مع ألواح شبكية على الجوانب.','<p> مزيج من البوليستر خفيف الوزن يبقيك منتعشًا خلال المجموعات الطويلة. تعمل طبقات Flatlock على تقليل الاحتكاك وتبقى حاشية ao dai كما هي خلال كل تكرار.</p>'),('ar',6,'شورت رياضي رقيق وخفيف للسيدات باللون الأسود',NULL,'شورت جري خفيف للغاية مع بطانة مدمجة وجيب مفاتيح بسحاب.','<p> قماش مطاطي في 4 اتجاهات، وبطانة داخلية شبكية مسامية وتفاصيل عاكسة للرؤية في ظروف الإضاءة المنخفضة. قطع الشكل للخطوة الطبيعية والسرعة السريعة.</p>'),('ar',7,'سجادة يوجا ألترا جريب 4 ملم - قبضة زرقاء',NULL,'سجادة يوجا مطاطية طبيعية صديقة للبيئة مع سطح أزرق مضاد للانزلاق لافت للنظر.','<p>4 مم وسائد سميكة للمفاصل دون فقدان الشعور بالأرضية. خالية من PVC، وخالية من اللاتكس، وقابلة للتحلل البيولوجي. يأتي مع حزام حمل.</p>'),('ar',8,'حقيبة رياضية سعة 20 لتر – رمادي',NULL,'حقيبة رياضية رمادية صغيرة بسعة 20 لترًا مع حجرة أحذية قابلة للتنفس وأشرطة معززة.','<p> يمكن أن يحمل مجموعة كاملة من الملابس والأحذية الرياضية. جيوب جانبية بسحاب، جزء سفلي مقاوم للماء وحمالات كتف مبطنة.</p>'),('ar',9,'مجموعة عصابات المقاومة',NULL,'مجموعة من خمسة أشرطة مقاومة قابلة للتكديس مع مقابض وأشرطة للكاحل ومثبتات للأبواب.','<p> اجمع بين الأربطة لتحقيق مقاومة تصل إلى 150 رطلاً. تأتي مع حقيبة حمل وتعليمات تمرين مطبوعة.</p>'),('ar',10,'رغوة الرول برو',NULL,'أسطوانة إسفنجية عالية الكثافة بطول 60.96 سم مع سطح خشن لعمل الأنسجة العميقة.','هيكل <p>EVA يحافظ على شكله من خلال الاستخدام المكثف المتكرر. يعمل على تمرين عضلات الفخذ والأرداف وشريط IT وأعلى الظهر.</p>'),('ar',11,'حذاء جري للرجال JF190.1 باللون الأبيض',NULL,'يركز الحذاء على الخفة مع نعل أوسط من الفوم المرن وشبكة علوية بيضاء نظيفة قابلة للتنفس.','<p> مصمم للركوب اليومي، يوازن JF190.1 بين الراحة واستعادة الطاقة. الجسم مصنوع من البلاستيك المعاد تدويره، إزاحة 8 مم، مناسب للطرق الإسفلتية والممرات المسطحة.</p>'),('ar',12,'حذاء جري للرجال JF190.1 باللون الأبيض',NULL,'يركز الحذاء على الخفة مع نعل أوسط من الفوم المرن وشبكة علوية بيضاء نظيفة قابلة للتنفس.','<p> مصمم للركوب اليومي، يوازن JF190.1 بين الراحة واستعادة الطاقة. الجسم مصنوع من البلاستيك المعاد تدويره، إزاحة 8 مم، مناسب للطرق الإسفلتية والممرات المسطحة.</p>'),('ar',13,'حذاء جري للرجال JF190.1 باللون الأبيض',NULL,'يركز الحذاء على الخفة مع نعل أوسط من الفوم المرن وشبكة علوية بيضاء نظيفة قابلة للتنفس.','<p> مصمم للركوب اليومي، يوازن JF190.1 بين الراحة واستعادة الطاقة. الجسم مصنوع من البلاستيك المعاد تدويره، إزاحة 8 مم، مناسب للطرق الإسفلتية والممرات المسطحة.</p>'),('ar',14,'كرة تنس بخيط مطاطي',NULL,'ترتبط كرات التنس الخاصة بالتدريب الشخصي بأربطة مطاطية، ويمكنك ممارسة التأرجح في أي مكان.','<p> كرة مغطاة باللباد مع شريط مطاطي عالي التمدد. رائعة للتدريب على الضربات الأمامية والخلفية والإرسال بدون شريك أو ملعب.</p>'),('ar',15,'كرة تنس بخيط مطاطي',NULL,'ترتبط كرات التنس الخاصة بالتدريب الشخصي بأربطة مطاطية، ويمكنك ممارسة التأرجح في أي مكان.','<p> كرة مغطاة باللباد مع شريط مطاطي عالي التمدد. رائعة للتدريب على الضربات الأمامية والخلفية والإرسال بدون شريك أو ملعب.</p>'),('ar',16,'مضرب كرة البيسبول - كويكما مفتوح باللون الأزرق',NULL,'مضرب كرة البيسبول جاهز للمنافسة مع وجه جرافيت وقلب بوليمر على شكل قرص العسل.','<p>USAPA معتمد، وزن اللعب 8 أونصة، مقبض مبطن مثقوب لظروف التعرق. رائعة للعب المتحكم والمحسن.</p>'),('ar',17,'مضرب كرة البيسبول - كويكما مفتوح باللون الأزرق',NULL,'مضرب كرة البيسبول جاهز للمنافسة مع وجه جرافيت وقلب بوليمر على شكل قرص العسل.','<p>USAPA معتمد، وزن اللعب 8 أونصة، مقبض مبطن مثقوب لظروف التعرق. رائعة للعب المتحكم والمحسن.</p>'),('ar',18,'مضرب كرة البيسبول - كويكما مفتوح باللون الأزرق',NULL,'مضرب كرة البيسبول جاهز للمنافسة مع وجه جرافيت وقلب بوليمر على شكل قرص العسل.','<p>USAPA معتمد، وزن اللعب 8 أونصة، مقبض مبطن مثقوب لظروف التعرق. رائعة للعب المتحكم والمحسن.</p>'),('ar',19,'سجادة يوجا ألترا جريب 4 ملم - قبضة زرقاء',NULL,'سجادة يوجا مطاطية طبيعية صديقة للبيئة مع سطح أزرق مضاد للانزلاق لافت للنظر.','<p>4 مم وسائد سميكة للمفاصل دون فقدان الشعور بالأرضية. خالية من PVC، وخالية من اللاتكس، وقابلة للتحلل البيولوجي. يأتي مع حزام حمل.</p>'),('ar',20,'سجادة يوجا ألترا جريب 4 ملم - قبضة زرقاء',NULL,'سجادة يوجا مطاطية طبيعية صديقة للبيئة مع سطح أزرق مضاد للانزلاق لافت للنظر.','<p>4 مم وسائد سميكة للمفاصل دون فقدان الشعور بالأرضية. خالية من PVC، وخالية من اللاتكس، وقابلة للتحلل البيولوجي. يأتي مع حزام حمل.</p>'),('ar',21,'سجادة يوجا ألترا جريب 4 ملم - قبضة زرقاء',NULL,'سجادة يوجا مطاطية طبيعية صديقة للبيئة مع سطح أزرق مضاد للانزلاق لافت للنظر.','<p>4 مم وسائد سميكة للمفاصل دون فقدان الشعور بالأرضية. خالية من PVC، وخالية من اللاتكس، وقابلة للتحلل البيولوجي. يأتي مع حزام حمل.</p>'),('fr',1,'Homme Running JF190.1 Grip Blanc',NULL,'La chaussure met l\'accent sur la légèreté avec une semelle intercalaire en mousse résistante et une tige en maille respirante blanche et propre.','<p>Conçu pour la conduite quotidienne, le JF190.1 équilibre confort et retour d\'énergie. Carrosserie en plastique recyclé, déport de 8 mm, adaptée aux routes asphaltées et aux sentiers plats.</p>'),('fr',2,'Lot de 2 poids à main de 3 kg',NULL,'Paire d\'haltères de 3 kg recouverts de vinyle avec poids hexagonaux anti-roulement. Vendu par lot de deux pièces assorties.','<p>Poignée confortable, idéale pour les exercices HIIT, de sculpture et de récupération. La tête d\'haltère hexagonale maintient le poids stable sur toute surface plane.</p>'),('fr',3,'Balle de tennis avec corde élastique',NULL,'Les balles de tennis d\'entraînement personnel sont attachées avec des bandes élastiques : pratiquez votre swing n\'importe où.','<p>Ballon recouvert de feutre avec bande élastique hautement extensible. Idéal pour pratiquer les coups droits, les revers et les services sans partenaire ni terrain.</p>'),('fr',4,'Raquette de Pickleball - Kuikma Open Bleu',NULL,'Raquette de pickleball prête pour la compétition avec face en graphite et noyau en polymère nid d\'abeille.','<p>USAPA approuvé, poids de jeu de 8 oz, poignée rembourrée perforée pour les conditions de transpiration. Idéal pour un gameplay contrôlé et raffiné.</p>'),('fr',5,'T-Shirt de Sport Homme - Marron Sec',NULL,'T-shirt de sport marron sec qui évacue la transpiration — tissu tissé à séchage rapide avec empiècements en mesh sur les côtés.','<p>Un mélange de polyester léger vous garde au frais pendant les longues séries. Les coutures plates réduisent les frottements et l\'ourlet de l\'ao dai reste le même à chaque répétition.</p>'),('fr',6,'Short de sport fin et léger pour femme noir',NULL,'Short de course ultraléger avec doublure intégrée et poche zippée pour clés.','<p>Tissu extensible dans 4 directions, doublure intérieure en mesh respirant et détails réfléchissants pour une visibilité dans des conditions de faible luminosité. Forme coupée pour une foulée naturelle et une vitesse rapide.</p>'),('fr',7,'Tapis de yoga Ultra Grip 4 mm - Grip bleu',NULL,'Tapis de yoga en caoutchouc naturel respectueux de l\'environnement avec une surface antidérapante bleue attrayante.','<p>4 mm d\'épaisseur amortit les joints sans perdre la sensation du sol. Sans PVC, sans latex et biodégradable. Livré avec une sangle de transport.</p>'),('fr',8,'Sac de sport 20L - Gris',NULL,'Sac de sport gris compact 20 L avec compartiment à chaussures respirant et bretelles renforcées.','<p>Peut contenir un ensemble complet de vêtements et de chaussures de sport. Poches latérales zippées, fond imperméable et bretelles rembourrées.</p>'),('fr',9,'Ensemble de bandes de résistance',NULL,'Ensemble de cinq bandes de résistance empilables avec poignées, sangles de cheville et ancrages de porte.','<p>Combinez des bandes pour atteindre une résistance jusqu\'à 150 lb. Livré avec un sac de transport et des instructions d\'exercices imprimées.</p>'),('fr',10,'Rouleau en mousse Pro',NULL,'Rouleau en mousse haute densité de 24 pouces de long avec surface rugueuse pour le travail des tissus en profondeur.','La construction <p>EVA conserve sa forme grâce à une utilisation intensive et répétée. Travaille les quadriceps, les fessiers, la bande informatique et le haut du dos.</p>'),('fr',11,'Homme Running JF190.1 Grip Blanc',NULL,'La chaussure met l\'accent sur la légèreté avec une semelle intercalaire en mousse résistante et une tige en maille respirante blanche et propre.','<p>Conçu pour la conduite quotidienne, le JF190.1 équilibre confort et retour d\'énergie. Carrosserie en plastique recyclé, déport de 8 mm, adaptée aux routes asphaltées et aux sentiers plats.</p>'),('fr',12,'Homme Running JF190.1 Grip Blanc',NULL,'La chaussure met l\'accent sur la légèreté avec une semelle intercalaire en mousse résistante et une tige en maille respirante blanche et propre.','<p>Conçu pour la conduite quotidienne, le JF190.1 équilibre confort et retour d\'énergie. Carrosserie en plastique recyclé, déport de 8 mm, adaptée aux routes asphaltées et aux sentiers plats.</p>'),('fr',13,'Homme Running JF190.1 Grip Blanc',NULL,'La chaussure met l\'accent sur la légèreté avec une semelle intercalaire en mousse résistante et une tige en maille respirante blanche et propre.','<p>Conçu pour la conduite quotidienne, le JF190.1 équilibre confort et retour d\'énergie. Carrosserie en plastique recyclé, déport de 8 mm, adaptée aux routes asphaltées et aux sentiers plats.</p>'),('fr',14,'Balle de tennis avec corde élastique',NULL,'Les balles de tennis d\'entraînement personnel sont attachées avec des bandes élastiques : pratiquez votre swing n\'importe où.','<p>Ballon recouvert de feutre avec bande élastique hautement extensible. Idéal pour pratiquer les coups droits, les revers et les services sans partenaire ni terrain.</p>'),('fr',15,'Balle de tennis avec corde élastique',NULL,'Les balles de tennis d\'entraînement personnel sont attachées avec des bandes élastiques : pratiquez votre swing n\'importe où.','<p>Ballon recouvert de feutre avec bande élastique hautement extensible. Idéal pour pratiquer les coups droits, les revers et les services sans partenaire ni terrain.</p>'),('fr',16,'Raquette de Pickleball - Kuikma Open Bleu',NULL,'Raquette de pickleball prête pour la compétition avec face en graphite et noyau en polymère nid d\'abeille.','<p>USAPA approuvé, poids de jeu de 8 oz, poignée rembourrée perforée pour les conditions de transpiration. Idéal pour un gameplay contrôlé et raffiné.</p>'),('fr',17,'Raquette de Pickleball - Kuikma Open Bleu',NULL,'Raquette de pickleball prête pour la compétition avec face en graphite et noyau en polymère nid d\'abeille.','<p>USAPA approuvé, poids de jeu de 8 oz, poignée rembourrée perforée pour les conditions de transpiration. Idéal pour un gameplay contrôlé et raffiné.</p>'),('fr',18,'Raquette de Pickleball - Kuikma Open Bleu',NULL,'Raquette de pickleball prête pour la compétition avec face en graphite et noyau en polymère nid d\'abeille.','<p>USAPA approuvé, poids de jeu de 8 oz, poignée rembourrée perforée pour les conditions de transpiration. Idéal pour un gameplay contrôlé et raffiné.</p>'),('fr',19,'Tapis de yoga Ultra Grip 4 mm - Grip bleu',NULL,'Tapis de yoga en caoutchouc naturel respectueux de l\'environnement avec une surface antidérapante bleue attrayante.','<p>4 mm d\'épaisseur amortit les joints sans perdre la sensation du sol. Sans PVC, sans latex et biodégradable. Livré avec une sangle de transport.</p>'),('fr',20,'Tapis de yoga Ultra Grip 4 mm - Grip bleu',NULL,'Tapis de yoga en caoutchouc naturel respectueux de l\'environnement avec une surface antidérapante bleue attrayante.','<p>4 mm d\'épaisseur amortit les joints sans perdre la sensation du sol. Sans PVC, sans latex et biodégradable. Livré avec une sangle de transport.</p>'),('fr',21,'Tapis de yoga Ultra Grip 4 mm - Grip bleu',NULL,'Tapis de yoga en caoutchouc naturel respectueux de l\'environnement avec une surface antidérapante bleue attrayante.','<p>4 mm d\'épaisseur amortit les joints sans perdre la sensation du sol. Sans PVC, sans latex et biodégradable. Livré avec une sangle de transport.</p>'),('id',1,'Lari Pria JF190.1 Grip Putih',NULL,'Sepatu ini berfokus pada bobot ringan dengan midsole busa elastis dan bagian atas mesh bernapas berwarna putih bersih.','<p>Dirancang untuk berkendara sehari-hari, JF190.1 menyeimbangkan kenyamanan dan pengembalian energi. Bodi terbuat dari plastik daur ulang, offset 8mm, cocok untuk jalan aspal dan jalan datar.</p>'),('id',2,'Set 2 Beban Tangan 3kg',NULL,'Sepasang dumbel berlapis vinil seberat 3kg dengan beban heksagonal anti-bergulir. Dijual dalam set dua potong yang serasi.','<p>Pegangan pegangan yang nyaman, ideal untuk HIIT, latihan memahat, dan pemulihan. Kepala halter heksagonal menjaga beban tetap stabil di permukaan datar apa pun.</p>'),('id',3,'Bola Tenis Dengan Tali Elastis',NULL,'Bola tenis latihan pribadi diikat dengan karet gelang — latih ayunan Anda di mana saja.','<p>Bola terasa tertutup dengan karet gelang elastis tinggi. Cocok untuk berlatih forehand, backhand, dan servis tanpa partner atau lapangan.</p>'),('id',4,'Raket Pickleball - Kuikma Terbuka Biru',NULL,'Raket Pickleball siap kompetisi dengan permukaan grafit dan inti polimer sarang lebah.','<p>USAPA disetujui, bobot permainan 8oz, pegangan empuk berlubang untuk kondisi berkeringat. Bagus untuk gameplay yang terkontrol dan halus.</p>'),('id',5,'Kaos Olahraga Pria - Coklat Kering',NULL,'Kaos olahraga kering berwarna coklat yang menyerap keringat — kain tenun yang cepat kering dengan panel jaring di bagian samping.','<p> Campuran poliester yang ringan membuat Anda tetap sejuk selama set panjang. Jahitan flatlock mengurangi gesekan dan ujung ao dai tetap sama setiap kali diulang.</p>'),('id',6,'Celana Pendek Olahraga Wanita Tipis dan Ringan Warna Hitam',NULL,'Celana pendek lari ultraringan dengan lapisan terintegrasi dan saku kunci berritsleting.','<p>Kain elastis 4 arah, lapisan interior mesh bernapas, dan detail reflektif untuk visibilitas dalam kondisi cahaya redup. Bentuk potongan untuk langkah alami dan kecepatan cepat.</p>'),('id',7,'Matras Yoga Ultra Grip 4mm - Pegangan Biru',NULL,'Matras yoga karet alam ramah lingkungan dengan permukaan anti selip berwarna biru yang menarik.','Sambungan bantalan tebal <p>4mm tanpa menghilangkan kesan lantai. Bebas PVC, bebas lateks, dan dapat terurai secara hayati. Dilengkapi dengan tali jinjing.</p>'),('id',8,'Tas Olahraga 20L - Abu-abu',NULL,'Tas olahraga abu-abu 20L ringkas dengan kompartemen sepatu bernapas dan tali pengikat yang diperkuat.','<p>Dapat menampung satu set pakaian dan sepatu olahraga lengkap. Saku samping beritsleting, bagian bawah tahan air, dan tali bahu empuk.</p>'),('id',9,'Kumpulan Pita Perlawanan',NULL,'Set lima tali penahan yang dapat ditumpuk dengan pegangan, tali pergelangan kaki, dan jangkar pintu.','<p>Gabungkan tali untuk mencapai ketahanan hingga 150 pon. Dilengkapi dengan tas jinjing dan instruksi latihan tercetak.</p>'),('id',10,'Busa Rol Pro',NULL,'Rol busa kepadatan tinggi sepanjang 24 inci dengan permukaan kasar untuk pekerjaan jaringan dalam.','Konstruksi <p>EVA mempertahankan bentuknya melalui penggunaan berat yang berulang-ulang. Bekerja pada paha depan, bokong, pita IT, dan punggung atas.</p>'),('id',11,'Lari Pria JF190.1 Grip Putih',NULL,'Sepatu ini berfokus pada bobot ringan dengan midsole busa elastis dan bagian atas mesh bernapas berwarna putih bersih.','<p>Dirancang untuk berkendara sehari-hari, JF190.1 menyeimbangkan kenyamanan dan pengembalian energi. Bodi terbuat dari plastik daur ulang, offset 8mm, cocok untuk jalan aspal dan jalan datar.</p>'),('id',12,'Lari Pria JF190.1 Grip Putih',NULL,'Sepatu ini berfokus pada bobot ringan dengan midsole busa elastis dan bagian atas mesh bernapas berwarna putih bersih.','<p>Dirancang untuk berkendara sehari-hari, JF190.1 menyeimbangkan kenyamanan dan pengembalian energi. Bodi terbuat dari plastik daur ulang, offset 8mm, cocok untuk jalan aspal dan jalan datar.</p>'),('id',13,'Lari Pria JF190.1 Grip Putih',NULL,'Sepatu ini berfokus pada bobot ringan dengan midsole busa elastis dan bagian atas mesh bernapas berwarna putih bersih.','<p>Dirancang untuk berkendara sehari-hari, JF190.1 menyeimbangkan kenyamanan dan pengembalian energi. Bodi terbuat dari plastik daur ulang, offset 8mm, cocok untuk jalan aspal dan jalan datar.</p>'),('id',14,'Bola Tenis Dengan Tali Elastis',NULL,'Bola tenis latihan pribadi diikat dengan karet gelang — latih ayunan Anda di mana saja.','<p>Bola terasa tertutup dengan karet gelang elastis tinggi. Cocok untuk berlatih forehand, backhand, dan servis tanpa partner atau lapangan.</p>'),('id',15,'Bola Tenis Dengan Tali Elastis',NULL,'Bola tenis latihan pribadi diikat dengan karet gelang — latih ayunan Anda di mana saja.','<p>Bola terasa tertutup dengan karet gelang elastis tinggi. Cocok untuk berlatih forehand, backhand, dan servis tanpa partner atau lapangan.</p>'),('id',16,'Raket Pickleball - Kuikma Terbuka Biru',NULL,'Raket Pickleball siap kompetisi dengan permukaan grafit dan inti polimer sarang lebah.','<p>USAPA disetujui, bobot permainan 8oz, pegangan empuk berlubang untuk kondisi berkeringat. Bagus untuk gameplay yang terkontrol dan halus.</p>'),('id',17,'Raket Pickleball - Kuikma Terbuka Biru',NULL,'Raket Pickleball siap kompetisi dengan permukaan grafit dan inti polimer sarang lebah.','<p>USAPA disetujui, bobot permainan 8oz, pegangan empuk berlubang untuk kondisi berkeringat. Bagus untuk gameplay yang terkontrol dan halus.</p>'),('id',18,'Raket Pickleball - Kuikma Terbuka Biru',NULL,'Raket Pickleball siap kompetisi dengan permukaan grafit dan inti polimer sarang lebah.','<p>USAPA disetujui, bobot permainan 8oz, pegangan empuk berlubang untuk kondisi berkeringat. Bagus untuk gameplay yang terkontrol dan halus.</p>'),('id',19,'Matras Yoga Ultra Grip 4mm - Pegangan Biru',NULL,'Matras yoga karet alam ramah lingkungan dengan permukaan anti selip berwarna biru yang menarik.','Sambungan bantalan tebal <p>4mm tanpa menghilangkan kesan lantai. Bebas PVC, bebas lateks, dan dapat terurai secara hayati. Dilengkapi dengan tali jinjing.</p>'),('id',20,'Matras Yoga Ultra Grip 4mm - Pegangan Biru',NULL,'Matras yoga karet alam ramah lingkungan dengan permukaan anti selip berwarna biru yang menarik.','Sambungan bantalan tebal <p>4mm tanpa menghilangkan kesan lantai. Bebas PVC, bebas lateks, dan dapat terurai secara hayati. Dilengkapi dengan tali jinjing.</p>'),('id',21,'Matras Yoga Ultra Grip 4mm - Pegangan Biru',NULL,'Matras yoga karet alam ramah lingkungan dengan permukaan anti selip berwarna biru yang menarik.','Sambungan bantalan tebal <p>4mm tanpa menghilangkan kesan lantai. Bebas PVC, bebas lateks, dan dapat terurai secara hayati. Dilengkapi dengan tali jinjing.</p>'),('tr',1,'Erkek Koşu JF190.1 Grip Beyaz',NULL,'Ayakkabı, dayanıklı köpük orta tabanı ve temiz beyaz, nefes alabilen file üst kısmıyla hafifliğe odaklanıyor.','<p>Günlük sürüş için tasarlanan JF190.1, konfor ve enerji geri dönüşünü dengeler. Geri dönüştürülmüş plastikten yapılmış gövde, 8mm ofset, asfalt yollara ve düz yollara uygun.</p>'),('tr',2,'2\'li 3kg El Ağırlığı Seti',NULL,'Yuvarlanmayı önleyen altıgen ağırlıklara sahip 3 kg\'lık vinil kaplı dambıl çifti. İki eşleşen parçadan oluşan setler halinde satılır.','<p>Rahat kavrama sapı, HIIT, şekillendirme ve toparlanma egzersizleri için idealdir. Altıgen dambıl başlığı, ağırlığı her türlü düz yüzeyde sabit tutar.</p>'),('tr',3,'Elastik İpli Tenis Topu',NULL,'Kişisel antrenman tenis topları elastik bantlarla bağlanmıştır; vuruşunuzu istediğiniz yerde yapın.','<p>Yüksek esneme elastik bantlı, keçe kaplı top. Partneriniz veya kortunuz olmadan forehand, backhand ve servis antrenmanı yapmak için idealdir.</p>'),('tr',4,'Pickleball Raketi - Kuikma Açık Mavi',NULL,'Grafit yüzeyli ve petek polimer çekirdekli, yarışmaya hazır turşu raketi.','<p>USAPA onaylı, 8 oz oyun ağırlığı, terli koşullar için delikli yastıklı sap. Kontrollü ve gelişmiş oyun için harika.</p>'),('tr',5,'Erkek Spor Tişört - Kuru Kahverengi',NULL,'Ter tutmayan kuru kahverengi spor tişört - yanları file panelli, çabuk kuruyan dokuma kumaş.','<p>Hafif polyester karışımı, uzun setlerde serin kalmanızı sağlar. Yassı dikişler sürtünmeyi azaltır ve ao dai\'nin etek kısmı her tekrarda aynı kalır.</p>'),('tr',6,'Kadın İnce ve Hafif Spor Şort Siyah',NULL,'Entegre astarlı ve fermuarlı anahtar cepli, ultra hafif koşu şortu.','<p>4 yönlü streç kumaş, nefes alabilen file iç astar ve düşük ışık koşullarında görünürlük için yansıtıcı ayrıntılar. Doğal adım ve yüksek hız için kesilmiş form.</p>'),('tr',7,'4mm Ultra Grip Yoga Minderi - Mavi Grip',NULL,'Göz alıcı mavi kaymaz yüzeye sahip çevre dostu doğal kauçuk yoga matı.','<p>4mm kalınlığındaki yastık bağlantıları, zemin hissini kaybetmez. PVC içermez, lateks içermez ve biyolojik olarak parçalanabilir. Taşıma askısıyla birlikte gelir.</p>'),('tr',8,'20L Spor Çanta - Gri',NULL,'Nefes alabilen ayakkabı bölmeli ve güçlendirilmiş askılı, kompakt 20L gri spor çantası.','<p>Tam bir spor kıyafeti ve ayakkabı setini tutabilir. Fermuarlı yan cepler, su geçirmez alt kısım ve dolgulu omuz askıları.</p>'),('tr',9,'Direnç Bantları Seti',NULL,'Tutma yerleri, ayak bileği kayışları ve kapı ankrajlarından oluşan beş adet istiflenebilir direnç bandı seti.','<p>150 lb\'ye kadar direnç elde etmek için bantları birleştirin. Taşıma çantası ve basılı egzersiz talimatlarıyla birlikte gelir.</p>'),('tr',10,'Köpük Rulo Pro',NULL,'Derin doku çalışmaları için pürüzlü yüzeye sahip 24 inç uzunluğunda yüksek yoğunluklu köpük rulo.','<p>EVA yapısı defalarca yoğun kullanımla formunu korur. Dörtlü kasları, kalça kaslarını, IT bandını ve sırtın üst kısmını çalıştırır.</p>'),('tr',11,'Erkek Koşu JF190.1 Grip Beyaz',NULL,'Ayakkabı, dayanıklı köpük orta tabanı ve temiz beyaz, nefes alabilen file üst kısmıyla hafifliğe odaklanıyor.','<p>Günlük sürüş için tasarlanan JF190.1, konfor ve enerji geri dönüşünü dengeler. Geri dönüştürülmüş plastikten yapılmış gövde, 8mm ofset, asfalt yollara ve düz yollara uygun.</p>'),('tr',12,'Erkek Koşu JF190.1 Grip Beyaz',NULL,'Ayakkabı, dayanıklı köpük orta tabanı ve temiz beyaz, nefes alabilen file üst kısmıyla hafifliğe odaklanıyor.','<p>Günlük sürüş için tasarlanan JF190.1, konfor ve enerji geri dönüşünü dengeler. Geri dönüştürülmüş plastikten yapılmış gövde, 8mm ofset, asfalt yollara ve düz yollara uygun.</p>'),('tr',13,'Erkek Koşu JF190.1 Grip Beyaz',NULL,'Ayakkabı, dayanıklı köpük orta tabanı ve temiz beyaz, nefes alabilen file üst kısmıyla hafifliğe odaklanıyor.','<p>Günlük sürüş için tasarlanan JF190.1, konfor ve enerji geri dönüşünü dengeler. Geri dönüştürülmüş plastikten yapılmış gövde, 8mm ofset, asfalt yollara ve düz yollara uygun.</p>'),('tr',14,'Elastik İpli Tenis Topu',NULL,'Kişisel antrenman tenis topları elastik bantlarla bağlanmıştır; vuruşunuzu istediğiniz yerde yapın.','<p>Yüksek esneme elastik bantlı, keçe kaplı top. Partneriniz veya kortunuz olmadan forehand, backhand ve servis antrenmanı yapmak için idealdir.</p>'),('tr',15,'Elastik İpli Tenis Topu',NULL,'Kişisel antrenman tenis topları elastik bantlarla bağlanmıştır; vuruşunuzu istediğiniz yerde yapın.','<p>Yüksek esneme elastik bantlı, keçe kaplı top. Partneriniz veya kortunuz olmadan forehand, backhand ve servis antrenmanı yapmak için idealdir.</p>'),('tr',16,'Pickleball Raketi - Kuikma Açık Mavi',NULL,'Grafit yüzeyli ve petek polimer çekirdekli, yarışmaya hazır turşu raketi.','<p>USAPA onaylı, 8 oz oyun ağırlığı, terli koşullar için delikli yastıklı sap. Kontrollü ve gelişmiş oyun için harika.</p>'),('tr',17,'Pickleball Raketi - Kuikma Açık Mavi',NULL,'Grafit yüzeyli ve petek polimer çekirdekli, yarışmaya hazır turşu raketi.','<p>USAPA onaylı, 8 oz oyun ağırlığı, terli koşullar için delikli yastıklı sap. Kontrollü ve gelişmiş oyun için harika.</p>'),('tr',18,'Pickleball Raketi - Kuikma Açık Mavi',NULL,'Grafit yüzeyli ve petek polimer çekirdekli, yarışmaya hazır turşu raketi.','<p>USAPA onaylı, 8 oz oyun ağırlığı, terli koşullar için delikli yastıklı sap. Kontrollü ve gelişmiş oyun için harika.</p>'),('tr',19,'4mm Ultra Grip Yoga Minderi - Mavi Grip',NULL,'Göz alıcı mavi kaymaz yüzeye sahip çevre dostu doğal kauçuk yoga matı.','<p>4mm kalınlığındaki yastık bağlantıları, zemin hissini kaybetmez. PVC içermez, lateks içermez ve biyolojik olarak parçalanabilir. Taşıma askısıyla birlikte gelir.</p>'),('tr',20,'4mm Ultra Grip Yoga Minderi - Mavi Grip',NULL,'Göz alıcı mavi kaymaz yüzeye sahip çevre dostu doğal kauçuk yoga matı.','<p>4mm kalınlığındaki yastık bağlantıları, zemin hissini kaybetmez. PVC içermez, lateks içermez ve biyolojik olarak parçalanabilir. Taşıma askısıyla birlikte gelir.</p>'),('tr',21,'4mm Ultra Grip Yoga Minderi - Mavi Grip',NULL,'Göz alıcı mavi kaymaz yüzeye sahip çevre dostu doğal kauçuk yoga matı.','<p>4mm kalınlığındaki yastık bağlantıları, zemin hissini kaybetmez. PVC içermez, lateks içermez ve biyolojik olarak parçalanabilir. Taşıma askısıyla birlikte gelir.</p>'),('vi',1,'Giày Chạy Bộ Nam JF190.1 Grip White',NULL,'Giày tập trung tính nhẹ nhàng với đế giữa bằng mút đàn hồi và thân lưới thoáng khí màu trắng sạch sẽ.','<p>Được thiết kế cho quãng đường chạy hàng ngày, JF190.1 cân bằng giữa độ êm và hoàn trả năng lượng. Thân làm từ nhựa tái chế, độ chênh 8mm, phù hợp cho đường nhựa và đường mòn phẳng.</p>'),('vi',2,'Bộ 2 Tạ Tay 3kg',NULL,'Cặp tạ đơn 3kg phủ vinyl với đầu tạ lục giác chống lăn. Bán theo bộ hai chiếc đồng bộ.','<p>Tay cầm ôm sát thoải mái, lý tưởng cho HIIT, tạo dáng cơ và bài tập phục hồi. Đầu tạ lục giác giữ tạ ổn định trên mọi bề mặt phẳng.</p>'),('vi',3,'Bóng Tennis Có Dây Thun',NULL,'Bóng tennis tập luyện cá nhân được buộc với dây thun — luyện cú đánh ở bất cứ đâu.','<p>Bóng phủ nỉ với dây thun đàn hồi căng cao. Tuyệt vời để luyện cú thuận tay, trái tay và giao bóng mà không cần bạn tập hay sân.</p>'),('vi',4,'Vợt Pickleball - Kuikma Open Blue',NULL,'Vợt pickleball sẵn sàng thi đấu với mặt graphite và lõi polymer tổ ong.','<p>Được USAPA chứng nhận, trọng lượng chơi 8oz, tay cầm đệm đục lỗ cho điều kiện ra mồ hôi. Tuyệt vời cho lối chơi kiểm soát và tinh tế.</p>'),('vi',5,'Áo Thun Thể Thao Nam - Dry Brown',NULL,'Áo thun thể thao thấm hút mồ hôi màu nâu khô — vải dệt nhanh khô với các mảng lưới hai bên hông.','<p>Chất liệu pha polyester nhẹ giữ bạn mát mẻ qua những hiệp tập dài. Đường may flatlock giảm cọ xát và phần gấu áo dài giữ nguyên qua mọi lần lặp lại động tác.</p>'),('vi',6,'Quần Short Thể Thao Nữ Mỏng Nhẹ Màu Đen',NULL,'Quần short chạy bộ siêu nhẹ với lớp lót tích hợp và túi khóa kéo đựng chìa khóa.','<p>Vải co giãn 4 chiều, lớp lót lưới thoáng khí bên trong và các chi tiết phản quang giúp dễ thấy trong điều kiện thiếu sáng. Form cắt cho sải chân tự nhiên và tốc độ nhanh.</p>'),('vi',7,'Thảm Yoga Siêu Bám 4mm - Blue Grip',NULL,'Thảm yoga cao su tự nhiên thân thiện môi trường với bề mặt chống trượt màu xanh dịu mắt.','<p>Dày 4mm đệm cho khớp mà không mất cảm giác sàn. Không PVC, không latex và phân hủy sinh học. Kèm theo dây đeo mang theo.</p>'),('vi',8,'Túi Thể Thao 20L - Màu Xám',NULL,'Túi tập gym 20L nhỏ gọn màu xám với ngăn để giày thoáng khí và quai đeo được gia cố.','<p>Đựng được trọn bộ đồ tập gym kèm giày. Túi bên có khóa kéo, đáy túi chống nước và quai đeo vai có đệm.</p>'),('vi',9,'Bộ Dây Kháng Lực',NULL,'Bộ năm dây kháng lực xếp chồng được với tay cầm, đai cổ chân và móc neo cửa.','<p>Kết hợp các dây để đạt kháng lực lên đến 150lb. Kèm theo túi đựng và hướng dẫn bài tập được in sẵn.</p>'),('vi',10,'Con Lăn Mút Pro',NULL,'Con lăn mút mật độ cao dài 24 inch với bề mặt nhám cho bài tập mô sâu.','<p>Cấu trúc EVA giữ form qua nhiều lần sử dụng nặng lặp lại. Tác động vào cơ đùi trước, cơ mông, dải IT và phần lưng trên.</p>'),('vi',11,'Giày Chạy Bộ Nam JF190.1 Grip White',NULL,'Giày tập trung tính nhẹ nhàng với đế giữa bằng mút đàn hồi và thân lưới thoáng khí màu trắng sạch sẽ.','<p>Được thiết kế cho quãng đường chạy hàng ngày, JF190.1 cân bằng giữa độ êm và hoàn trả năng lượng. Thân làm từ nhựa tái chế, độ chênh 8mm, phù hợp cho đường nhựa và đường mòn phẳng.</p>'),('vi',12,'Giày Chạy Bộ Nam JF190.1 Grip White',NULL,'Giày tập trung tính nhẹ nhàng với đế giữa bằng mút đàn hồi và thân lưới thoáng khí màu trắng sạch sẽ.','<p>Được thiết kế cho quãng đường chạy hàng ngày, JF190.1 cân bằng giữa độ êm và hoàn trả năng lượng. Thân làm từ nhựa tái chế, độ chênh 8mm, phù hợp cho đường nhựa và đường mòn phẳng.</p>'),('vi',13,'Giày Chạy Bộ Nam JF190.1 Grip White',NULL,'Giày tập trung tính nhẹ nhàng với đế giữa bằng mút đàn hồi và thân lưới thoáng khí màu trắng sạch sẽ.','<p>Được thiết kế cho quãng đường chạy hàng ngày, JF190.1 cân bằng giữa độ êm và hoàn trả năng lượng. Thân làm từ nhựa tái chế, độ chênh 8mm, phù hợp cho đường nhựa và đường mòn phẳng.</p>'),('vi',14,'Bóng Tennis Có Dây Thun',NULL,'Bóng tennis tập luyện cá nhân được buộc với dây thun — luyện cú đánh ở bất cứ đâu.','<p>Bóng phủ nỉ với dây thun đàn hồi căng cao. Tuyệt vời để luyện cú thuận tay, trái tay và giao bóng mà không cần bạn tập hay sân.</p>'),('vi',15,'Bóng Tennis Có Dây Thun',NULL,'Bóng tennis tập luyện cá nhân được buộc với dây thun — luyện cú đánh ở bất cứ đâu.','<p>Bóng phủ nỉ với dây thun đàn hồi căng cao. Tuyệt vời để luyện cú thuận tay, trái tay và giao bóng mà không cần bạn tập hay sân.</p>'),('vi',16,'Vợt Pickleball - Kuikma Open Blue',NULL,'Vợt pickleball sẵn sàng thi đấu với mặt graphite và lõi polymer tổ ong.','<p>Được USAPA chứng nhận, trọng lượng chơi 8oz, tay cầm đệm đục lỗ cho điều kiện ra mồ hôi. Tuyệt vời cho lối chơi kiểm soát và tinh tế.</p>'),('vi',17,'Vợt Pickleball - Kuikma Open Blue',NULL,'Vợt pickleball sẵn sàng thi đấu với mặt graphite và lõi polymer tổ ong.','<p>Được USAPA chứng nhận, trọng lượng chơi 8oz, tay cầm đệm đục lỗ cho điều kiện ra mồ hôi. Tuyệt vời cho lối chơi kiểm soát và tinh tế.</p>'),('vi',18,'Vợt Pickleball - Kuikma Open Blue',NULL,'Vợt pickleball sẵn sàng thi đấu với mặt graphite và lõi polymer tổ ong.','<p>Được USAPA chứng nhận, trọng lượng chơi 8oz, tay cầm đệm đục lỗ cho điều kiện ra mồ hôi. Tuyệt vời cho lối chơi kiểm soát và tinh tế.</p>'),('vi',19,'Thảm Yoga Siêu Bám 4mm - Blue Grip',NULL,'Thảm yoga cao su tự nhiên thân thiện môi trường với bề mặt chống trượt màu xanh dịu mắt.','<p>Dày 4mm đệm cho khớp mà không mất cảm giác sàn. Không PVC, không latex và phân hủy sinh học. Kèm theo dây đeo mang theo.</p>'),('vi',20,'Thảm Yoga Siêu Bám 4mm - Blue Grip',NULL,'Thảm yoga cao su tự nhiên thân thiện môi trường với bề mặt chống trượt màu xanh dịu mắt.','<p>Dày 4mm đệm cho khớp mà không mất cảm giác sàn. Không PVC, không latex và phân hủy sinh học. Kèm theo dây đeo mang theo.</p>'),('vi',21,'Thảm Yoga Siêu Bám 4mm - Blue Grip',NULL,'Thảm yoga cao su tự nhiên thân thiện môi trường với bề mặt chống trượt màu xanh dịu mắt.','<p>Dày 4mm đệm cho khớp mà không mất cảm giác sàn. Không PVC, không latex và phân hủy sinh học. Kèm theo dây đeo mang theo.</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,5,NULL,NULL,7,5,'Clean & perfect source code','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(2,4,NULL,NULL,10,5,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(3,10,NULL,NULL,5,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:11:34','2026-05-28 19:11:34',NULL),(4,2,NULL,NULL,2,5,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(5,9,NULL,NULL,1,4,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(6,6,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:11:34','2026-05-28 19:11:34',NULL),(7,6,NULL,NULL,3,4,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(8,4,NULL,NULL,6,5,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(9,4,NULL,NULL,1,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:11:34','2026-05-28 19:11:34',NULL),(10,10,NULL,NULL,1,5,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(11,3,NULL,NULL,4,5,'Clean & perfect source code','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(12,3,NULL,NULL,5,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:11:34','2026-05-28 19:11:34',NULL),(13,1,NULL,NULL,9,5,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(14,7,NULL,NULL,1,2,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(15,10,NULL,NULL,9,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:11:34','2026-05-28 19:11:34',NULL),(16,7,NULL,NULL,9,4,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(17,1,NULL,NULL,3,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:11:34','2026-05-28 19:11:34',NULL),(18,3,NULL,NULL,8,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:11:34','2026-05-28 19:11:34',NULL),(19,10,NULL,NULL,6,1,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(20,6,NULL,NULL,1,4,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(21,3,NULL,NULL,1,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:11:34','2026-05-28 19:11:34',NULL),(22,1,NULL,NULL,5,5,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(23,1,NULL,NULL,8,1,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(24,9,NULL,NULL,5,2,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(25,3,NULL,NULL,6,1,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(26,5,NULL,NULL,2,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:11:34','2026-05-28 19:11:34',NULL),(27,5,NULL,NULL,9,1,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(28,8,NULL,NULL,6,3,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(29,9,NULL,NULL,2,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:11:34','2026-05-28 19:11:34',NULL),(30,8,NULL,NULL,2,5,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(31,2,NULL,NULL,4,5,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(32,10,NULL,NULL,10,2,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(33,8,NULL,NULL,8,1,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(34,2,NULL,NULL,6,5,'Clean & perfect source code','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(35,10,NULL,NULL,8,3,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(36,1,NULL,NULL,7,3,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(37,8,NULL,NULL,10,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:11:34','2026-05-28 19:11:34',NULL),(38,7,NULL,NULL,10,5,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(39,3,NULL,NULL,2,5,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(40,8,NULL,NULL,4,3,'Clean & perfect source code','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(41,3,NULL,NULL,9,4,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(42,5,NULL,NULL,3,1,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(43,1,NULL,NULL,4,3,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(44,8,NULL,NULL,1,1,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(45,4,NULL,NULL,4,1,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(46,1,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:11:34','2026-05-28 19:11:34',NULL),(47,3,NULL,NULL,7,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:11:34','2026-05-28 19:11:34',NULL),(48,2,NULL,NULL,1,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:11:34','2026-05-28 19:11:34',NULL),(49,5,NULL,NULL,6,1,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(50,9,NULL,NULL,4,1,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(51,6,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:11:34','2026-05-28 19:11:34',NULL),(52,9,NULL,NULL,7,1,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(53,7,NULL,NULL,4,3,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(54,2,NULL,NULL,8,5,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(55,6,NULL,NULL,5,5,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(56,6,NULL,NULL,7,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:11:34','2026-05-28 19:11:34',NULL),(57,10,NULL,NULL,4,4,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(58,4,NULL,NULL,8,2,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(59,10,NULL,NULL,2,2,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','auto','2026-05-28 19:11:34','2026-05-28 19:11:34',NULL),(60,5,NULL,NULL,4,2,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(61,1,NULL,NULL,10,3,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(62,6,NULL,NULL,10,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:11:35','2026-05-28 19:11:35',NULL),(63,7,NULL,NULL,8,4,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(64,10,NULL,NULL,3,3,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(65,2,NULL,NULL,7,1,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(66,7,NULL,NULL,5,3,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(67,1,NULL,NULL,6,3,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(68,1,NULL,NULL,2,5,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(69,8,NULL,NULL,9,4,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(70,7,NULL,NULL,7,3,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(71,2,NULL,NULL,3,3,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(72,8,NULL,NULL,7,3,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(73,4,NULL,NULL,7,5,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(74,6,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:11:35','2026-05-28 19:11:35',NULL),(75,2,NULL,NULL,5,3,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(76,7,NULL,NULL,2,2,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(77,9,NULL,NULL,3,4,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(78,5,NULL,NULL,8,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:11:35','2026-05-28 19:11:35',NULL),(79,3,NULL,NULL,10,1,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(80,4,NULL,NULL,9,5,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(81,4,NULL,NULL,2,5,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(82,5,NULL,NULL,5,4,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(83,3,NULL,NULL,3,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:11:35','2026-05-28 19:11:35',NULL),(84,4,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:11:35','2026-05-28 19:11:35',NULL),(85,8,NULL,NULL,3,5,'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:11:35','2026-05-28 19:11:35',NULL),(86,5,NULL,NULL,1,4,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(87,10,NULL,NULL,7,1,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(88,4,NULL,NULL,3,5,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(89,9,NULL,NULL,9,3,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(90,2,NULL,NULL,9,1,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(91,7,NULL,NULL,3,4,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(92,9,NULL,NULL,6,4,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(93,5,NULL,NULL,10,2,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(94,9,NULL,NULL,8,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:11:35','2026-05-28 19:11:35',NULL),(95,7,NULL,NULL,6,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:11:35','2026-05-28 19:11:35',NULL),(96,9,NULL,NULL,10,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:11:35','2026-05-28 19:11:35',NULL),(97,6,NULL,NULL,8,5,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(98,6,NULL,NULL,2,1,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(99,2,NULL,NULL,10,5,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','auto','2026-05-28 19:11:35','2026-05-28 19:11:35',NULL),(100,8,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:11:35','2026-05-28 19:11:35',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:11:35','2026-05-28 19:11:35'),(2,'International',NULL,'2026-05-28 19:11:35','2026-05-28 19:11:35');

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

--
-- 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:11:13','2026-05-28 19:11:13',NULL,NULL),(2,1,'Origin','text',NULL,'Made in Portugal','2026-05-28 19:11:13','2026-05-28 19:11:13',NULL,NULL),(3,1,'Care','text',NULL,'Machine wash cold. Tumble dry low. Do not bleach.','2026-05-28 19:11:13','2026-05-28 19:11:13',NULL,NULL),(4,2,'Designed In','text',NULL,'Barcelona, Spain','2026-05-28 19:11:13','2026-05-28 19:11:13',NULL,NULL),(5,2,'Warranty','text',NULL,'12 months manufacturer warranty','2026-05-28 19:11:13','2026-05-28 19:11:13',NULL,NULL),(6,2,'Made From Recycled Materials','checkbox',NULL,'1','2026-05-28 19:11:13','2026-05-28 19:11:13',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:11:13','2026-05-28 19:11:13',NULL,NULL),(2,'Product Details','Provenance, warranty and sustainability.','2026-05-28 19:11:13','2026-05-28 19:11:13',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:11:13','2026-05-28 19:11:13',NULL,NULL);

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

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

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


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

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

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


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

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

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


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

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

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


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

CREATE TABLE `ec_taxes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `percentage` float DEFAULT NULL,
  `priority` int DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

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

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


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

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

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


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

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

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


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

CREATE TABLE `faq_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

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

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

CREATE TABLE `faqs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

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

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

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

--
