--
-- 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,'lpLW7jhcKmarIrWE1RDRZZjxzW1TnTWW',1,'2026-05-28 19:10:32','2026-05-28 19:10:32','2026-05-28 19:10:32');

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

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

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


--
-- Table structure for table `ads`
--

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

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


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

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

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


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

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

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


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

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

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


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

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

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


--
-- Table structure for table `cache`
--

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

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


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

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

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


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

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

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

INSERT INTO `categories` VALUES (1,'Performance',0,'Running, training, and court reviews backed by miles, drops, and gym sessions.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2026-05-28 19:10:34','2026-05-28 19:10:34'),(2,'Style',0,'Lifestyle silhouettes, color stories, and outfit edits that pair sneakers with daily wear.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:10:34','2026-05-28 19:10:34'),(3,'Care Guide',0,'Cleaning, deodorizing, and storage tips that keep every pair looking new.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:10:34','2026-05-28 19:10:34'),(4,'New Releases',0,'Drop calendars, collaboration recaps, and the silhouettes worth the queue.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:10:34','2026-05-28 19:10:34'),(5,'Athletic Tech',0,'Foam compounds, plate stiffness, and the engineering behind modern performance shoes.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:10:34','2026-05-28 19:10:34');

--
-- 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,'Performance','Mises à niveau de puissance, réglages et améliorations de la conduite basées sur les données.'),('fr',2,'Style','Des modèles de chaussures lifestyle, des histoires de couleurs et des suggestions pour associer des baskets avec des tenues de tous les jours.'),('fr',3,'Guide d\'entretien','Les conseils de nettoyage, de désodorisation et de rangement permettent à chaque paire de chaussures de conserver son aspect neuf.'),('fr',4,'Nouveautés','Obtenez une première expérience pratique et lancez une couverture des derniers gadgets et appareils.'),('fr',5,'Technologie athlétique','Composés de mousse, rigidité de la semelle et ingénierie derrière les chaussures de performance modernes.'),('id',1,'Pertunjukan','Peningkatan daya, penyetelan, dan peningkatan berkendara berbasis data.'),('id',2,'Gaya','Desain sepatu gaya hidup, cerita warna, dan saran untuk memadukan sepatu kets dengan pakaian sehari-hari.'),('id',3,'Panduan Perawatan','Tips membersihkan, menghilangkan bau, dan menyimpan sepatu membuat setiap pasang sepatu tampak seperti baru.'),('id',4,'Rilis Baru','Dapatkan pengalaman langsung pertama dan luncurkan liputan gadget dan perangkat terbaru.'),('id',5,'Teknologi Atletik','Senyawa busa, kekakuan pelat sol, dan rekayasa di balik sepatu performa modern.'),('tr',1,'Performans','Güç yükseltmeleri, ayarlamalar ve veriye dayalı sürüş iyileştirmeleri.'),('tr',2,'Stil','Lifestyle ayakkabı tasarımları, renk hikayeleri ve spor ayakkabıları günlük kıyafetlerle kombinlemek için öneriler.'),('tr',3,'Bakım Kılavuzu','Temizleme, koku giderme ve saklama ipuçları, her çift ayakkabının yeni gibi görünmesini sağlar.'),('tr',4,'Yeni Çıkanlar','İlk uygulamalı deneyimi edinin ve en yeni gadget ve cihazların kapsamını başlatın.'),('tr',5,'Atletik Teknoloji','Köpük bileşikleri, taban plakası sertliği ve modern performans ayakkabılarının arkasındaki mühendislik.'),('vi',1,'Hiệu Năng','Nâng cấp sức mạnh, tinh chỉnh và các cải tiến cảm giác lái dựa trên dữ liệu.'),('vi',2,'Phong Cách','Những dáng giày phong cách sống, câu chuyện màu sắc và gợi ý phối đồ kết hợp sneaker với trang phục hàng ngày.'),('vi',3,'Hướng Dẫn Chăm Sóc','Mẹo vệ sinh, khử mùi và bảo quản giữ cho mọi đôi giày luôn như mới.'),('vi',4,'Sản Phẩm Mới Ra Mắt','Trải nghiệm thực tế đầu tiên và đưa tin ra mắt về những gadget và thiết bị mới nhất.'),('vi',5,'Công Nghệ Thể Thao','Hợp chất mút, độ cứng của tấm đế và kỹ thuật đằng sau những đôi giày hiệu năng hiệ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:10:32','2026-05-28 19:10:32'),(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:10:32','2026-05-28 19:10:32'),(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:10:32','2026-05-28 19:10:32');

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

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

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


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

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

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


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

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

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


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

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

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


--
-- Table structure for table `device_tokens`
--

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

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


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

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

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


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

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

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

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

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

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

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

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

--
-- Table structure for table `ec_cart`
--

CREATE TABLE `ec_cart` (
  `identifier` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `instance` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` bigint unsigned DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`identifier`,`instance`),
  KEY `ec_cart_customer_instance_index` (`customer_id`,`instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `ec_currencies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_prefix_symbol` tinyint unsigned NOT NULL DEFAULT '0',
  `decimals` tinyint unsigned DEFAULT '0',
  `number_format_style` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'western',
  `space_between_price_and_currency` tinyint(1) NOT NULL DEFAULT '0',
  `order` int unsigned DEFAULT '0',
  `is_default` tinyint NOT NULL DEFAULT '0',
  `exchange_rate` double NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_currencies`
--

INSERT INTO `ec_currencies` VALUES (1,'USD','$',1,2,'western',0,0,1,1,'2026-05-28 19:10:32','2026-05-28 19:10:32'),(2,'EUR','€',0,2,'western',0,1,0,0.84,'2026-05-28 19:10:32','2026-05-28 19:10:32'),(3,'VND','₫',0,0,'western',0,2,0,23203,'2026-05-28 19:10:32','2026-05-28 19:10:32'),(4,'NGN','₦',1,2,'western',0,2,0,895.52,'2026-05-28 19:10:32','2026-05-28 19:10:32');

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

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

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

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


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

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

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


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

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

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


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

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

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


--
-- Table structure for table `ec_customers`
--

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

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

INSERT INTO `ec_customers` VALUES (1,'Emma Collins','customer@botble.com','$2y$12$Q0REo.XfUlpQ37n9QvHdl.jzuH3BJevW6WK/T/KIsPxiiRmMURkw6','testimonials/avatar-1.jpg','1978-05-17','regular',NULL,'+1-555-0101',NULL,'2026-05-28 19:10:42','2026-05-28 19:10:42','2026-05-29 02:10:42',NULL,0,NULL,'activated',NULL,NULL,NULL,0),(2,'Sophia Ramirez','vendor@botble.com','$2y$12$FvUjFq63P5PuEMp0.pIiauhE.Kj5I/kCCAKslDKyL0aFX9fRbYTmS','testimonials/avatar-2.jpg','1992-04-29','regular',NULL,'+1-555-0102',NULL,'2026-05-28 19:10:43','2026-05-28 19:10:45','2026-05-29 02:10:42',NULL,1,'2026-05-29 02:10:45','activated',NULL,NULL,NULL,0),(3,'Olivia Carter','customer1@example.com','$2y$12$3vlTt4K44OsRyCK0XZ6NUuHZ0va40uBa32FuTb6PwLzk5GSIWgcji','testimonials/avatar-3.jpg','1991-05-18','regular',NULL,'+1-555-0104',NULL,'2026-05-28 19:10:43','2026-05-28 19:10:45','2026-05-29 02:10:42',NULL,1,'2026-05-29 02:10:45','activated',NULL,NULL,NULL,0),(4,'Ava Mitchell','customer2@example.com','$2y$12$jFgX5ujzOy68HL6XjVfAyefrcybejLHYLh5wM0VRVgllmLtvULwGO','testimonials/avatar-4.jpg','2003-05-09','regular',NULL,'+1-555-0101',NULL,'2026-05-28 19:10:43','2026-05-28 19:10:45','2026-05-29 02:10:42',NULL,1,'2026-05-29 02:10:45','activated',NULL,NULL,NULL,0),(5,'Isabella Brooks','customer3@example.com','$2y$12$ehaqOEeTdAObflBvzZoI7eefaxSKYMkFKWGXfpAkLT7lRdZaCX9Oy','testimonials/avatar-5.jpg','1997-05-14','regular',NULL,'+1-555-0105',NULL,'2026-05-28 19:10:43','2026-05-28 19:10:46','2026-05-29 02:10:42',NULL,1,'2026-05-29 02:10:45','activated',NULL,NULL,NULL,0),(6,'James Whitfield','customer4@example.com','$2y$12$VgqyLF7DnAhGvNbJdAsRJOmc0j14fppcfVibtdpeUAnW8uHtSrO4W','testimonials/avatar-6.jpg','1990-05-19','regular',NULL,'+1-555-0102',NULL,'2026-05-28 19:10:43','2026-05-28 19:10:46','2026-05-29 02:10:42',NULL,1,'2026-05-29 02:10:45','activated',NULL,NULL,NULL,0),(7,'Liam Bennett','customer5@example.com','$2y$12$qevAe96iup5iFo.kov./eOU4v44cNiMYDVERlBO4MqCEBB9itDG7W','testimonials/avatar-7.jpg','1993-05-10','regular',NULL,'+1-555-0104',NULL,'2026-05-28 19:10:44','2026-05-28 19:10:46','2026-05-29 02:10:42',NULL,1,'2026-05-29 02:10:45','activated',NULL,NULL,NULL,0),(8,'Noah Patterson','customer6@example.com','$2y$12$NacKwQIDa8cLXq8mCioDkOzpyiG/iRo0fm1iZFK816cLeeI/g91Z2','testimonials/avatar-8.jpg','1999-05-26','regular',NULL,'+1-555-0108',NULL,'2026-05-28 19:10:44','2026-05-28 19:10:46','2026-05-29 02:10:42',NULL,1,'2026-05-29 02:10:45','activated',NULL,NULL,NULL,0),(9,'Charlotte Reed','customer7@example.com','$2y$12$AEd07BjFgB.6xIMbUED2LOgOkrdlF3wngYMp5asJONlxAOVGtsQ/G','testimonials/avatar-9.jpg','1994-05-28','regular',NULL,'+1-555-0107',NULL,'2026-05-28 19:10:44','2026-05-28 19:10:47','2026-05-29 02:10:42',NULL,1,'2026-05-29 02:10:45','activated',NULL,NULL,NULL,0),(10,'Amelia Foster','customer8@example.com','$2y$12$I3Auz6IprRHycxs6B4QOXObO7s204uT28UTF1gylJOhbZlphv8WzG','testimonials/avatar-10.jpg','1976-05-13','regular',NULL,'+1-555-0104',NULL,'2026-05-28 19:10:44','2026-05-28 19:10:47','2026-05-29 02:10:42',NULL,0,NULL,'activated',NULL,NULL,NULL,0);

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `ec_discounts` VALUES (1,'Welcome 10% Off','WELCOME10','2026-05-28 02:10:45','2026-07-28 02:10:45',NULL,0,10,'coupon',0,0,NULL,NULL,'percentage','all-orders',0.00,0,1,'2026-05-28 19:10:45','2026-05-28 19:10:45',NULL,'A welcome discount for first-time shoppers — 10% off any order.'),(2,'Free Shipping Over $50','FREESHIP','2026-05-28 02:10:45',NULL,NULL,0,100,'coupon',0,0,NULL,NULL,'shipping','all-orders',50.00,0,1,'2026-05-28 19:10:45','2026-05-28 19:10:45',NULL,'Free shipping on any order $50 or above.'),(3,'Spring Sale — $25 Off','SPRING25','2026-05-28 02:10:45','2026-06-28 02:10:45',500,0,25,'coupon',0,0,NULL,NULL,'amount','all-orders',150.00,0,1,'2026-05-28 19:10:45','2026-05-28 19:10:45',NULL,'A flat $25 off orders over $150.'),(4,'VIP Member 20% Off','VIP20','2026-05-28 02:10:45','2026-08-27 02:10:45',NULL,0,20,'coupon',0,0,NULL,NULL,'percentage','all-orders',100.00,0,1,'2026-05-28 19:10:45','2026-05-28 19:10:45',NULL,'Exclusive 20% off for newsletter subscribers.'),(5,'Bundle & Save $50','BUNDLE50','2026-05-28 02:10:45','2026-07-13 02:10:45',NULL,0,50,'coupon',0,0,NULL,NULL,'amount','all-orders',300.00,0,1,'2026-05-28 19:10:45','2026-05-28 19:10:45',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,4,69.3,50,0),(1,3,55.3,50,0),(1,9,90.3,50,0),(1,1,62.3,50,0),(1,6,76.3,50,0),(1,7,139.3,50,0),(1,5,118.3,50,0),(1,10,34.3,50,0),(1,8,83.3,50,0),(2,7,149.25,75,0),(2,5,126.75,75,0),(2,8,89.25,75,0),(2,6,81.75,75,0),(2,9,96.75,75,0),(2,1,66.75,75,0),(2,10,36.75,75,0);

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


--
-- Table structure for table `ec_orders`
--

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

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


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

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

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

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

--
-- 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,'Outdoor Shoes',NULL,0,'Trail and hiking shoes engineered for grip, stability, and rugged terrain.','published',0,'categories/sneaker/cate-1.jpg',1,'2026-05-28 19:10:35','2026-05-28 19:10:35',NULL,NULL),(2,'Gym Shoes',NULL,0,'Cross-trainers and lifting shoes with stable bases and lateral support.','published',1,'categories/sneaker/cate-2.jpg',1,'2026-05-28 19:10:35','2026-05-28 19:10:35',NULL,NULL),(3,'Road Shoes',NULL,0,'Daily trainers tuned for pavement, with cushioned midsoles and durable outsoles.','published',2,'categories/sneaker/cate-3.jpg',1,'2026-05-28 19:10:35','2026-05-28 19:10:35',NULL,NULL),(4,'Speed Shoes',NULL,0,'Carbon-plated racers and tempo shoes built for personal records and race days.','published',3,'categories/sneaker/cate-4.jpg',1,'2026-05-28 19:10:36','2026-05-28 19:10:36',NULL,NULL),(5,'Lifestyle Shoes',NULL,0,'Heritage silhouettes and modern court shoes that pair with daily wear.','published',4,'categories/sneaker/cate-5.jpg',1,'2026-05-28 19:10:36','2026-05-28 19:10:36',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 d\'extérieur',NULL,'Les chaussures de trail running et de randonnée sont conçues pour l’adhérence, la stabilité et les terrains accidentés.'),('fr',2,'Chaussures de sport',NULL,'Baskets et chaussures d\'haltérophilie polyvalentes avec semelles robustes et support latéral.'),('fr',3,'Chaussures de route',NULL,'Les baskets de tous les jours sont conçues pour la route, avec une semelle intermédiaire coussinée et une semelle extérieure durable.'),('fr',4,'Chaussures de vitesse',NULL,'Les chaussures de course plaquées carbone et les chaussures de course Tempo sont conçues pour les records personnels et les journées sur piste.'),('fr',5,'Chaussures de style de vie',NULL,'Les silhouettes de chaussures classiques et les escarpins modernes se coordonnent avec les tenues de tous les jours.'),('id',1,'Sepatu Luar Ruangan',NULL,'Sepatu lari trail dan hiking dirancang untuk cengkeraman, stabilitas, dan medan yang kasar.'),('id',2,'Sepatu Olahraga',NULL,'Sepatu kets serbaguna dan sepatu angkat besi dengan sol kokoh dan penyangga lateral.'),('id',3,'Sepatu Jalan',NULL,'Sepatu olahraga sehari-hari disesuaikan dengan kondisi jalan, dengan midsole yang empuk dan outsole yang tahan lama.'),('id',4,'Sepatu Kecepatan',NULL,'Sepatu balap berlapis karbon dan sepatu lari tempo dibuat untuk catatan pribadi dan hari lintasan.'),('id',5,'Sepatu Gaya Hidup',NULL,'Siluet sepatu klasik dan sepatu pengadilan modern serasi dengan pakaian sehari-hari.'),('tr',1,'Açık Hava Ayakkabıları',NULL,'Patika koşusu ve yürüyüş ayakkabıları kavrama, denge ve engebeli arazi için tasarlanmıştır.'),('tr',2,'Spor Ayakkabı',NULL,'Sağlam tabanlı ve yanal destekli, çok amaçlı spor ayakkabı ve halter ayakkabıları.'),('tr',3,'Yol Ayakkabıları',NULL,'Günlük spor ayakkabı, yastıklı orta tabanı ve dayanıklı dış tabanıyla yola uygun olarak tasarlandı.'),('tr',4,'Hız Ayakkabıları',NULL,'Karbon kaplamalı yarış ayakkabıları ve tempolu koşu ayakkabıları kişisel rekorlar ve pist günleri için tasarlandı.'),('tr',5,'Yaşam Tarzı Ayakkabı',NULL,'Klasik ayakkabı silüetleri ve modern kort ayakkabıları günlük kıyafetlerle uyumludur.'),('vi',1,'Giày Ngoài Trời',NULL,'Giày chạy địa hình và đi bộ đường dài được thiết kế để bám tốt, ổn định và chinh phục địa hình gồ ghề.'),('vi',2,'Giày Tập Gym',NULL,'Giày tập đa năng và giày nâng tạ với đế vững chắc và hỗ trợ ngang.'),('vi',3,'Giày Chạy Đường Phố',NULL,'Giày tập hàng ngày được tinh chỉnh cho mặt đường, với đế giữa êm ái và đế ngoài bền bỉ.'),('vi',4,'Giày Tốc Độ',NULL,'Giày đua có tấm carbon và giày chạy tempo được làm cho những kỷ lục cá nhân và ngày thi đấu.'),('vi',5,'Giày Phong Cách Sống',NULL,'Những dáng giày cổ điển và giày court hiện đại phối hợp với trang phục hàng ngày.');

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

--
-- 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,'BIG SEASON SALE','big-season-sale','SALE OFF UP TO 50% — Limited time only on top performance shoes.','collection/cls-1.jpg','published','2026-05-28 19:10:33','2026-05-28 19:10:33',1),(2,'SALE OFF UP TO 50%','sale-off-up-to-50','Big season sale — get the latest sneaker styles at unbeatable prices.','collection/cls-10.jpg','published','2026-05-28 19:10:33','2026-05-28 19:10:33',1),(3,'New Arrivals','new-arrivals','Fresh drops from the brands powering elite athletes.','collection/cls-11.jpg','published','2026-05-28 19:10:33','2026-05-28 19:10:33',1),(4,'Featured','featured','Hand-picked sneaker essentials our team is wearing right now.','collection/cls-12.jpg','published','2026-05-28 19:10:33','2026-05-28 19:10:33',1),(5,'Best Sellers','best-sellers','The sneaker picks our customers reorder season after season.','collection/cls-13.jpg','published','2026-05-28 19:10:33','2026-05-28 19:10:33',0),(6,'Performance','performance','Built for daily training — moisture-wicking, supportive, durable.','collection/cls-14.jpg','published','2026-05-28 19:10:33','2026-05-28 19:10:33',0),(7,'Shop Men','shop-men','Athletic sneakers for men — running, training, lifestyle.','collection/cls-6.jpg','published','2026-05-28 19:10:33','2026-05-28 19:10:33',0),(8,'Shop Women','shop-women','Athletic sneakers for women — running, training, lifestyle.','collection/cls-7.jpg','published','2026-05-28 19:10:33','2026-05-28 19:10:33',0),(9,'Shop Essentials','shop-essentials','Daily-wear sneakers built to last beyond the trend cycle.','collection/cls-8.jpg','published','2026-05-28 19:10:33','2026-05-28 19:10:33',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,'بيع الموسم الكبير','خصم يصل إلى 50% - لفترة محدودة فقط على الأحذية عالية الأداء.'),('ar',2,'خصم يصل إلى 50%','حفلة التخفيضات الموسمية - امتلك أحدث موديلات الأحذية الرياضية بأسعار لا تقبل المنافسة.'),('ar',3,'الوافدون الجدد','يتم اختيار نماذج جديدة كل أسبوع.'),('ar',4,'مميز','أحذية رياضية أساسية اختارها فريقنا ويتم ارتداؤها الآن.'),('ar',5,'أفضل البائعين','المنتجات التي يثق بها العملاء ويعيدون طلبها في كل موسم.'),('ar',6,'أداء','مصنوع للتمارين اليومية - يتخلص من العرق، وداعم، ومتين.'),('ar',7,'تسوق الرجال','أساسيات متطورة وأساسيات حديثة - تدوم إلى ما بعد دورات الموضة.'),('ar',8,'تسوق النساء','خزانة ملابس منسقة لكل موسم - الفساتين والطبقات وأساسيات عطلة نهاية الأسبوع.'),('ar',9,'تسوق الأساسيات','يعيد العملاء طلب القطع اليومية - الدنيم والحياكة والمعاطف الخالدة.'),('fr',1,'GRANDE VENTE DE SAISON','JUSQU\'À 50 % DE RÉDUCTION — Pour une durée limitée uniquement sur les chaussures les plus performantes.'),('fr',2,'VENTE JUSQU\'À 50%','Fête des soldes saisonnières - possédez les derniers modèles de baskets à des prix imbattables.'),('fr',3,'Nouveautés','De nouveaux modèles sont sélectionnés chaque semaine.'),('fr',4,'En vedette','Des baskets incontournables sélectionnées par notre équipe et portées en ce moment.'),('fr',5,'Meilleures ventes','Des produits auxquels les clients font confiance et qui les commandent chaque saison.'),('fr',6,'Performance','Conçu pour les entraînements quotidiens : évacuant la transpiration, offrant un bon maintien et durable.'),('fr',7,'Acheter des hommes','Des essentiels sophistiqués et des basiques modernes – qui durent au-delà des cycles de la mode.'),('fr',8,'Magasinez les femmes','Une garde-robe organisée pour chaque saison : robes, superpositions et essentiels du week-end.'),('fr',9,'Achetez les essentiels','Les clients commandent des pièces du quotidien : jeans, tricots et manteaux intemporels.'),('id',1,'PENJUALAN MUSIM BESAR','DISKON HINGGA 50% — Untuk waktu terbatas hanya pada sepatu dengan performa tertinggi.'),('id',2,'PENJUALAN HINGGA 50%','Pesta penjualan musiman - miliki model sepatu kets terbaru dengan harga yang tidak ada duanya.'),('id',3,'Pendatang Baru','Model-model baru dipilih setiap minggu.'),('id',4,'Unggulan','Sepatu kets esensial yang dipilih oleh tim kami dan sedang dipakai saat ini.'),('id',5,'Terlaris','Produk yang dipercaya dan dipesan ulang oleh pelanggan setiap musim.'),('id',6,'Pertunjukan','Dibuat untuk olahraga sehari-hari — menyerap keringat, suportif, dan tahan lama.'),('id',7,'Toko Pria','Hal-hal penting yang canggih dan dasar-dasar modern — bertahan melampaui siklus mode.'),('id',8,'Belanja Wanita','Lemari pakaian pilihan untuk setiap musim — gaun, pakaian berlapis, dan kebutuhan akhir pekan.'),('id',9,'Belanja Penting','Barang sehari-hari yang dipesan ulang oleh pelanggan — denim, rajutan, dan mantel yang tak lekang oleh waktu.'),('tr',1,'BÜYÜK SEZON İNDİRİMİ','%50\'ye VARAN İNDİRİM — Yalnızca en yüksek performanslı ayakkabılarda sınırlı bir süre için.'),('tr',2,'%50\'YE VARAN İNDİRİM','Sezonluk indirim partisi - en yeni spor ayakkabı modellerine rakipsiz fiyatlarla sahip olun.'),('tr',3,'Yeni Gelenler','Her hafta yeni modeller seçiliyor.'),('tr',4,'Öne Çıkanlar','Ekibimiz tarafından seçilen ve şu anda giyilen vazgeçilmez spor ayakkabılar.'),('tr',5,'En Çok Satanlar','Müşterilerin güvendiği ve her sezon yeniden sipariş ettiği ürünler.'),('tr',6,'Performans','Günlük antrenmanlar için tasarlandı; ter tutmaz, destekleyici ve dayanıklıdır.'),('tr',7,'Erkek Alışverişi','Moda döngülerinin ötesinde kalıcı, sofistike temeller ve modern temeller.'),('tr',8,'Kadın Alışverişi','Her mevsime uygun seçilmiş bir gardırop; elbiseler, üst üste binmeler ve hafta sonu vazgeçilmezleri.'),('tr',9,'Temel Eşyaları Satın Alın','Müşterilerin yeniden sipariş ettiği gündelik parçalar: denim, örgüler ve zamansız montlar.'),('vi',1,'ĐẠI TIỆC SALE MÙA','GIẢM GIÁ ĐẾN 50% — Chỉ trong thời gian có hạn cho các mẫu giày hiệu năng cao nhất.'),('vi',2,'GIẢM GIÁ ĐẾN 50%','Đại tiệc sale mùa — sở hữu những mẫu sneaker mới nhất với giá không thể tốt hơn.'),('vi',3,'Hàng Mới Về','Những mẫu mới được tuyển chọn mỗi tuần.'),('vi',4,'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.'),('vi',5,'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',6,'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',7,'Mua đồ Nam','Đồ thiết yếu tinh tế và đồ cơ bản hiện đại — bền vượt qua chu kỳ thời trang.'),('vi',8,'Mua đồ Nữ','Tủ đồ tuyển chọn cho mọi mùa — đầm, đồ layering và đồ thiết yếu cuối tuần.'),('vi',9,'Mua đồ thiết yếu','Những món đồ hàng ngày khách hàng đặt lại — denim, đồ dệt kim và áo khoác vượt thời gian.');

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

--
-- Table structure for table `ec_product_files`
--

CREATE TABLE `ec_product_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned DEFAULT NULL,
  `url` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `extras` mediumtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_product_files_product_id_index` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE `ec_product_views` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned NOT NULL,
  `views` int NOT NULL DEFAULT '1',
  `date` date NOT NULL DEFAULT '2026-05-29',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_product_views_product_id_date_unique` (`product_id`,`date`),
  KEY `ec_product_views_product_id_index` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_views`
--


--
-- Table structure for table `ec_product_with_attribute_set`
--

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

--
-- Dumping data for table `ec_product_with_attribute_set`
--

INSERT INTO `ec_product_with_attribute_set` VALUES (1,2,0),(2,2,0),(1,3,0),(2,3,0),(1,4,0),(2,4,0),(3,5,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=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_products` VALUES (1,'Men Sports Shoes with Mesh upper','men-sports-shoes-with-mesh-upper','Breathable mesh trainer with a cushioned midsole and a durable rubber outsole.','<p>Engineered mesh upper, EVA midsole, and a high-abrasion outsole. Sized true to fit. Pairs with daily training and treadmill miles.</p>','published','[\"products\\/sneaker\\/product-1.jpg\"]',NULL,'ZQ-111',0,13,0,1,'in_stock',1,NULL,10,0,0,10,2.90,0,89,69,NULL,NULL,13,14,13,649,NULL,'standard',193426,'2026-05-28 19:10:39','2026-05-28 19:10:47',1,0,'Botble\\ACL\\Models\\User',0,'products/sneaker/product-1.jpg','physical','2903859275897',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(2,'Sneakersy Niskie','sneakersy-niskie','Low-top sneaker with a clean leather upper, padded collar, and minimal branding.','<p>Full-grain leather, foam-cushioned tongue, and a vulcanized rubber outsole. The everyday lifestyle shoe — one pair you can dress up or down.</p>','published','[\"products\\/sneaker\\/product-2.jpg\"]',NULL,'3J-101-A1',0,14,0,1,'in_stock',0,NULL,5,0,4,10,2.90,0,129,99,NULL,NULL,18,12,16,550,NULL,'standard',158003,'2026-05-28 19:10:39','2026-05-28 19:10:47',2,0,'Botble\\ACL\\Models\\User',0,'products/sneaker/product-2.jpg','physical','9044156658082',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(3,'RED TAPE Men Flat Sneakers','red-tape-men-flat-sneakers','Flat-soled lifestyle sneaker with a soft leather upper and a low-profile silhouette.','<p>Pebbled leather, suede heel patch, and a flat rubber sole. Pairs with denim, chinos, and tailored trousers.</p>','published','[\"products\\/sneaker\\/product-3.jpg\"]',NULL,'FT-165-A1',0,14,0,1,'in_stock',1,NULL,11,0,4,10,2.80,0,79,59,NULL,NULL,15,20,14,758,NULL,'standard',71638,'2026-05-28 19:10:39','2026-05-28 19:10:47',3,0,'Botble\\ACL\\Models\\User',0,'products/sneaker/product-3.jpg','physical','6204773732746',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(4,'Men Flat Sneakers','men-flat-sneakers','Versatile trainer with a knit upper, foam midsole, and slip-on construction.','<p>Stretch knit upper for sock-like fit. Compression-molded EVA midsole. The travel-day shoe — security-line friendly and good for long walks.</p>','published','[\"products\\/sneaker\\/product-4.jpg\"]',NULL,'4F-172-A1',0,17,0,1,'in_stock',1,NULL,5,0,2,10,3.30,0,99,79,NULL,NULL,15,18,20,800,NULL,'standard',42459,'2026-05-28 19:10:39','2026-05-28 19:10:47',4,0,'Botble\\ACL\\Models\\User',0,'products/sneaker/product-4.jpg','physical','4679453032744',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(5,'Ultimashow 2.0 Mer Lace-Up Sneakers','ultimashow-20-mer-lace-up-sneakers','Aggressive trail shoe with 4mm lugs, a rock plate, and a reinforced toe cap.','<p>Vibram Megagrip outsole, EVA midsole, and a TPU rock plate. Handles muddy descents, rocky climbs, and technical terrain.</p>','published','[\"products\\/sneaker\\/product-5.jpg\"]',NULL,'ZR-115-A1',0,14,0,1,'in_stock',1,NULL,2,0,3,10,3.40,0,169,139,NULL,NULL,16,18,16,608,NULL,'standard',34562,'2026-05-28 19:10:40','2026-05-28 19:10:47',1,0,'Botble\\ACL\\Models\\User',0,'products/sneaker/product-5.jpg','physical','9317564213885',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(6,'Men Panelled Athleisure Shoes','men-panelled-athleisure-shoes','Heritage low-top court silhouette in white leather with tonal stitching.','<p>Smooth leather upper, padded collar, and a herringbone rubber outsole. The minimalist white sneaker that pairs with everything.</p>','published','[\"products\\/sneaker\\/product-6.jpg\"]',NULL,'HE-156',0,20,0,1,'in_stock',0,NULL,7,0,0,10,2.70,0,109,89,NULL,NULL,19,10,12,522,NULL,'standard',54655,'2026-05-28 19:10:40','2026-05-28 19:10:47',2,0,'Botble\\ACL\\Models\\User',0,'products/sneaker/product-6.jpg','physical','6568735543598',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(7,'Up Casual Shoes with Rubber Sole','up-casual-shoes-with-rubber-sole','Carbon-plated racing shoe with a PEBA foam midsole and a curved rocker geometry.','<p>Full-length carbon plate. PEBA-blend foam returns 80%+ energy. Designed for half-marathon to marathon race days.</p>','published','[\"products\\/sneaker\\/product-7.jpg\"]',NULL,'XS-163',0,13,0,1,'in_stock',1,NULL,3,0,0,10,2.80,0,199,169,NULL,NULL,13,16,12,892,NULL,'standard',14879,'2026-05-28 19:10:40','2026-05-28 19:10:47',3,0,'Botble\\ACL\\Models\\User',0,'products/sneaker/product-7.jpg','physical','9483342955619',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(8,'Men Flat Low','men-flat-low','Leather walking sneaker with a cushioned footbed and a flexible rubber outsole.','<p>Soft leather upper with stretch panels at the ankle. Removable insole for orthotics. The all-day commuter shoe.</p>','published','[\"products\\/sneaker\\/product-8.jpg\"]',NULL,'S0-160',0,17,0,1,'in_stock',0,NULL,7,0,0,10,3.20,0,119,89,NULL,NULL,11,12,15,824,NULL,'standard',14411,'2026-05-28 19:10:40','2026-05-28 19:10:47',4,0,'Botble\\ACL\\Models\\User',0,'products/sneaker/product-8.jpg','physical','3896786025927',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(9,'Men Casual Shoes with PU Upper','men-casual-shoes-with-pu-upper','Tennis-inspired court shoe with lateral support, a cushioned midfoot, and a herringbone outsole.','<p>Synthetic leather upper with TPU overlays. Wraparound midsole for stability through quick lateral cuts. Multi-court outsole.</p>','published','[\"products\\/sneaker\\/product-9.jpg\"]',NULL,'DD-190',0,16,0,1,'in_stock',1,NULL,8,0,0,10,2.50,0,129,99,NULL,NULL,13,10,10,870,NULL,'standard',10886,'2026-05-28 19:10:40','2026-05-28 19:10:47',1,0,'Botble\\ACL\\Models\\User',0,'products/sneaker/product-9.jpg','physical','1624182986571',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(10,'Men Duramo','men-duramo','Classic running silhouette with a suede-and-mesh upper and a foam-cushioned heel.','<p>Suede overlays on a breathable mesh base. EVA midsole with a visible air unit at the heel. The lifestyle classic that started it all.</p>','published','[\"products\\/sneaker\\/product-10.jpg\"]',NULL,'NQ-144',0,19,0,1,'in_stock',1,NULL,3,0,0,10,2.90,0,49,39,NULL,NULL,20,18,17,753,NULL,'standard',41988,'2026-05-28 19:10:40','2026-05-28 19:10:47',2,0,'Botble\\ACL\\Models\\User',0,'products/sneaker/product-10.jpg','physical','7086218380441',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(11,'Sneakersy Niskie',NULL,NULL,NULL,'published','[\"products\\/sneaker\\/product-2.jpg\"]',NULL,'3J-101-A1',0,14,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,129,NULL,NULL,NULL,18,12,16,550,NULL,'standard',0,'2026-05-28 19:10:40','2026-05-28 19:10:47',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9648757508434',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(12,'Sneakersy Niskie',NULL,NULL,NULL,'published','[\"products\\/sneaker\\/product-2.jpg\"]',NULL,'3J-101-A1-A2',0,14,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,129,NULL,NULL,NULL,18,12,16,550,NULL,'standard',0,'2026-05-28 19:10:40','2026-05-28 19:10:47',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2205191444970',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(13,'Sneakersy Niskie',NULL,NULL,NULL,'published','[\"products\\/sneaker\\/product-2.jpg\"]',NULL,'3J-101-A1-A3',0,14,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,129,NULL,NULL,NULL,18,12,16,550,NULL,'standard',0,'2026-05-28 19:10:41','2026-05-28 19:10:47',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4779050535157',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(14,'Sneakersy Niskie',NULL,NULL,NULL,'published','[\"products\\/sneaker\\/product-2.jpg\"]',NULL,'3J-101-A1-A4',0,14,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,129,NULL,NULL,NULL,18,12,16,550,NULL,'standard',0,'2026-05-28 19:10:41','2026-05-28 19:10:47',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','1642755690335',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(15,'RED TAPE Men Flat Sneakers',NULL,NULL,NULL,'published','[\"products\\/sneaker\\/product-3.jpg\"]',NULL,'FT-165-A1',0,14,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,79,NULL,NULL,NULL,15,20,14,758,NULL,'standard',0,'2026-05-28 19:10:41','2026-05-28 19:10:47',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9058697498984',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(16,'RED TAPE Men Flat Sneakers',NULL,NULL,NULL,'published','[\"products\\/sneaker\\/product-3.jpg\"]',NULL,'FT-165-A1-A2',0,14,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,79,NULL,NULL,NULL,15,20,14,758,NULL,'standard',0,'2026-05-28 19:10:41','2026-05-28 19:10:47',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6154731111109',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(17,'RED TAPE Men Flat Sneakers',NULL,NULL,NULL,'published','[\"products\\/sneaker\\/product-3.jpg\"]',NULL,'FT-165-A1-A3',0,14,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,79,NULL,NULL,NULL,15,20,14,758,NULL,'standard',0,'2026-05-28 19:10:41','2026-05-28 19:10:47',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8923228595450',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(18,'RED TAPE Men Flat Sneakers',NULL,NULL,NULL,'published','[\"products\\/sneaker\\/product-3.jpg\"]',NULL,'FT-165-A1-A4',0,14,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,79,NULL,NULL,NULL,15,20,14,758,NULL,'standard',0,'2026-05-28 19:10:41','2026-05-28 19:10:47',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9273111929510',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(19,'Men Flat Sneakers',NULL,NULL,NULL,'published','[\"products\\/sneaker\\/product-4.jpg\"]',NULL,'4F-172-A1',0,17,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,99,74.25,NULL,NULL,15,18,20,800,NULL,'standard',0,'2026-05-28 19:10:41','2026-05-28 19:10:47',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9912582394334',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(20,'Men Flat Sneakers',NULL,NULL,NULL,'published','[\"products\\/sneaker\\/product-4.jpg\"]',NULL,'4F-172-A1-A2',0,17,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,99,76.23,NULL,NULL,15,18,20,800,NULL,'standard',0,'2026-05-28 19:10:41','2026-05-28 19:10:47',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','1180994018942',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(21,'Ultimashow 2.0 Mer Lace-Up Sneakers',NULL,NULL,NULL,'published','[\"products\\/sneaker\\/product-5.jpg\"]',NULL,'ZR-115-A1',0,14,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,169,NULL,NULL,NULL,16,18,16,608,NULL,'standard',0,'2026-05-28 19:10:41','2026-05-28 19:10:47',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','7430253896526',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(22,'Ultimashow 2.0 Mer Lace-Up Sneakers',NULL,NULL,NULL,'published','[\"products\\/sneaker\\/product-5.jpg\"]',NULL,'ZR-115-A1-A2',0,14,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,169,NULL,NULL,NULL,16,18,16,608,NULL,'standard',0,'2026-05-28 19:10:41','2026-05-28 19:10:47',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2911498552477',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(23,'Ultimashow 2.0 Mer Lace-Up Sneakers',NULL,NULL,NULL,'published','[\"products\\/sneaker\\/product-5.jpg\"]',NULL,'ZR-115-A1-A3',0,14,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,169,NULL,NULL,NULL,16,18,16,608,NULL,'standard',0,'2026-05-28 19:10:41','2026-05-28 19:10:47',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2306303331055',NULL,NULL,0,0,'auto_generate',0,0,0,NULL);

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

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

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

INSERT INTO `ec_products_translations` VALUES ('ar',1,'حذاء رياضي للرجال مع جزء علوي شبكي',NULL,'حذاء رياضي شبكي يسمح بالتهوية مع نعل أوسط مبطن ونعل خارجي مطاطي متين.','<p> جزء عُلوي شبكي تقني، ونعل أوسط EVA ونعل خارجي مقاوم للتآكل بدرجة عالية. شكل الحجم القياسي. مناسب للتمارين اليومية والجري على الجهاز.</p>'),('ar',2,'سنيكرز نيسكي',NULL,'حذاء رياضي منخفض مع جزء علوي من الجلد النظيف، وياقة مبطنة وشعار بسيط.','<p> جلد محبب بالكامل، ولسان إسفنجي، ونعل خارجي مطاطي مبركن. أحذية نمط الحياة لكل يوم - زوج يمكنك ارتداؤه لأعلى أو أسفل.</p>'),('ar',3,'أحذية رياضية مسطحة للرجال من الشريط الأحمر',NULL,'حذاء رياضي بنعل مسطح مع جزء علوي من الجلد الناعم وتصميم منخفض القطع.','<p> جلد محبب منقوش، ورقعة كعب من جلد الغزال ونعل مطاطي مسطح. مناسب للجينز والتشينو والسراويل.</p>'),('ar',4,'أحذية رياضية مسطحة للرجال',NULL,'حذاء رياضي متعدد الاستخدامات مع جزء علوي محبوك ونعل أوسط من الفوم وتصميم سهل الارتداء.','<p> جسم محبوك مرن يحتضن القدم مثل الجورب. نعل أوسط مصبوب من مادة إي في إيه. حذاء مناسب لأيام السفر — يسهل المرور عبر نقاط الأمان ورائع للمشي لمسافات طويلة.</p>'),('ar',5,'حذاء ألتيماشو 2.0 مير برباط',NULL,'حذاء جري قوي بمداس 4 مم، ولوحة مضادة للركل، وغطاء معزز لأصابع القدم.','<p> نعل خارجي Vibram Megagrip ونعل أوسط EVA ولوحة مقاومة للركل من مادة TPU. تغلب على المنحدرات الموحلة والتسلق الصخري والتضاريس الفنية.</p>'),('ar',6,'أحذية رياضية للرجال',NULL,'حذاء رياضي كلاسيكي بقصة منخفضة مصنوع من الجلد الأبيض مع خياطة متطابقة.','<p> جزء علوي من الجلد الناعم، وياقة مبطنة، ونعل خارجي مطاطي متعرج. حذاء أبيض بسيط يتناسب مع كل شيء.</p>'),('ar',7,'حذاء كاجوال بنعل مطاطي',NULL,'يتميز حذاء السباق بلوحة كربونية مع نعل أوسط من إسفنج PEBA وتصميم هزاز منحني.','<p> لوح كربون كامل الطول. تقوم رغوة PEBA بإرجاع أكثر من 80% من الطاقة. مصممة لأيام السباق من نصف الماراثون إلى الماراثون.</p>'),('ar',8,'الرجال شقة منخفضة',NULL,'حذاء رياضي مصنوع من الجلد مع نعل داخلي مبطن ونعل خارجي مطاطي مرن.','<p> جسم من الجلد الناعم مع رقع مطاطية عند الكاحلين. نعل داخلي قابل للإزالة للاستخدام في تقويم العظام. حذاء للعمل طوال اليوم.</p>'),('ar',9,'أحذية كاجوال للرجال مع جزء علوي من البولي يوريثان',NULL,'حذاء ملعب مستوحى من رياضة التنس مع دعم جانبي، ووسط قدم مبطن ونعل خارجي متعرج.','<p> جسم من الجلد الصناعي مع طبقة من مادة TPU. يوفر النعل الأوسط الملتف الثبات من خلال الحركات الجانبية السريعة. نعل خارجي متعدد الدرجات.</p>'),('ar',10,'رجال دورامو',NULL,'صورة ظلية لحذاء جري كلاسيكي مع جزء علوي من الجلد السويدي الشبكي وكعب مبطن.','<p> طبقات من الجلد السويدي على قاعدة شبكية مسامية. نعل أوسط EVA مع حجرة هواء مكشوفة للكعب. حذاء نمط الحياة الكلاسيكي الذي يبدأ كل شيء.</p>'),('ar',11,'سنيكرز نيسكي',NULL,'حذاء رياضي منخفض مع جزء علوي من الجلد النظيف، وياقة مبطنة وشعار بسيط.','<p> جلد محبب بالكامل، ولسان إسفنجي، ونعل خارجي مطاطي مبركن. أحذية نمط الحياة لكل يوم - زوج يمكنك ارتداؤه لأعلى أو أسفل.</p>'),('ar',12,'سنيكرز نيسكي',NULL,'حذاء رياضي منخفض مع جزء علوي من الجلد النظيف، وياقة مبطنة وشعار بسيط.','<p> جلد محبب بالكامل، ولسان إسفنجي، ونعل خارجي مطاطي مبركن. أحذية نمط الحياة لكل يوم - زوج يمكنك ارتداؤه لأعلى أو أسفل.</p>'),('ar',13,'سنيكرز نيسكي',NULL,'حذاء رياضي منخفض مع جزء علوي من الجلد النظيف، وياقة مبطنة وشعار بسيط.','<p> جلد محبب بالكامل، ولسان إسفنجي، ونعل خارجي مطاطي مبركن. أحذية نمط الحياة لكل يوم - زوج يمكنك ارتداؤه لأعلى أو أسفل.</p>'),('ar',14,'سنيكرز نيسكي',NULL,'حذاء رياضي منخفض مع جزء علوي من الجلد النظيف، وياقة مبطنة وشعار بسيط.','<p> جلد محبب بالكامل، ولسان إسفنجي، ونعل خارجي مطاطي مبركن. أحذية نمط الحياة لكل يوم - زوج يمكنك ارتداؤه لأعلى أو أسفل.</p>'),('ar',15,'أحذية رياضية مسطحة للرجال من الشريط الأحمر',NULL,'حذاء رياضي بنعل مسطح مع جزء علوي من الجلد الناعم وتصميم منخفض القطع.','<p> جلد محبب منقوش، ورقعة كعب من جلد الغزال ونعل مطاطي مسطح. مناسب للجينز والتشينو والسراويل.</p>'),('ar',16,'أحذية رياضية مسطحة للرجال من الشريط الأحمر',NULL,'حذاء رياضي بنعل مسطح مع جزء علوي من الجلد الناعم وتصميم منخفض القطع.','<p> جلد محبب منقوش، ورقعة كعب من جلد الغزال ونعل مطاطي مسطح. مناسب للجينز والتشينو والسراويل.</p>'),('ar',17,'أحذية رياضية مسطحة للرجال من الشريط الأحمر',NULL,'حذاء رياضي بنعل مسطح مع جزء علوي من الجلد الناعم وتصميم منخفض القطع.','<p> جلد محبب منقوش، ورقعة كعب من جلد الغزال ونعل مطاطي مسطح. مناسب للجينز والتشينو والسراويل.</p>'),('ar',18,'أحذية رياضية مسطحة للرجال من الشريط الأحمر',NULL,'حذاء رياضي بنعل مسطح مع جزء علوي من الجلد الناعم وتصميم منخفض القطع.','<p> جلد محبب منقوش، ورقعة كعب من جلد الغزال ونعل مطاطي مسطح. مناسب للجينز والتشينو والسراويل.</p>'),('ar',19,'أحذية رياضية مسطحة للرجال',NULL,'حذاء رياضي متعدد الاستخدامات مع جزء علوي محبوك ونعل أوسط من الفوم وتصميم سهل الارتداء.','<p> جسم محبوك مرن يحتضن القدم مثل الجورب. نعل أوسط مصبوب من مادة إي في إيه. حذاء مناسب لأيام السفر — يسهل المرور عبر نقاط الأمان ورائع للمشي لمسافات طويلة.</p>'),('ar',20,'أحذية رياضية مسطحة للرجال',NULL,'حذاء رياضي متعدد الاستخدامات مع جزء علوي محبوك ونعل أوسط من الفوم وتصميم سهل الارتداء.','<p> جسم محبوك مرن يحتضن القدم مثل الجورب. نعل أوسط مصبوب من مادة إي في إيه. حذاء مناسب لأيام السفر — يسهل المرور عبر نقاط الأمان ورائع للمشي لمسافات طويلة.</p>'),('ar',21,'حذاء ألتيماشو 2.0 مير برباط',NULL,'حذاء جري قوي بمداس 4 مم، ولوحة مضادة للركل، وغطاء معزز لأصابع القدم.','<p> نعل خارجي Vibram Megagrip ونعل أوسط EVA ولوحة مقاومة للركل من مادة TPU. تغلب على المنحدرات الموحلة والتسلق الصخري والتضاريس الفنية.</p>'),('ar',22,'حذاء ألتيماشو 2.0 مير برباط',NULL,'حذاء جري قوي بمداس 4 مم، ولوحة مضادة للركل، وغطاء معزز لأصابع القدم.','<p> نعل خارجي Vibram Megagrip ونعل أوسط EVA ولوحة مقاومة للركل من مادة TPU. تغلب على المنحدرات الموحلة والتسلق الصخري والتضاريس الفنية.</p>'),('ar',23,'حذاء ألتيماشو 2.0 مير برباط',NULL,'حذاء جري قوي بمداس 4 مم، ولوحة مضادة للركل، وغطاء معزز لأصابع القدم.','<p> نعل خارجي Vibram Megagrip ونعل أوسط EVA ولوحة مقاومة للركل من مادة TPU. تغلب على المنحدرات الموحلة والتسلق الصخري والتضاريس الفنية.</p>'),('fr',1,'Chaussures de sport pour hommes avec tige en mesh',NULL,'Baskets en mesh respirant avec semelle intercalaire coussinée et semelle extérieure en caoutchouc durable.','<p>Tige en mesh technique, semelle intermédiaire en EVA et semelle extérieure hautement résistante à l\'abrasion. Forme de taille standard. Convient aux entraînements quotidiens et à la course sur la machine.</p>'),('fr',2,'Niskie baskets',NULL,'Baskets basses avec tige en cuir épuré, col rembourré et logo minimaliste.','<p>Cuir pleine fleur, languette en mousse et semelle extérieure en caoutchouc vulcanisé. Des chaussures lifestyle pour tous les jours : une paire que vous pouvez habiller de manière habillée ou décontractée.</p>'),('fr',3,'RED TAPE Baskets plates pour hommes',NULL,'Baskets lifestyle à semelle plate avec tige en cuir souple et silhouette basse.','<p>Cuir fleur embossé, patch talon en daim et semelle plate en caoutchouc. Convient aux jeans, chinos et pantalons.</p>'),('fr',4,'Baskets plates pour hommes',NULL,'Baskets polyvalentes avec tige en tricot, semelle intercalaire en mousse et design à enfiler.','<p>Le corps tricoté élastique épouse le pied comme une chaussette. Semelle intercalaire moulée en EVA. Chaussures pour les jours de voyage : faciles à passer le contrôle de sécurité et idéales pour la randonnée.</p>'),('fr',5,'Baskets à lacets Ultimashow 2.0 Mer',NULL,'Chaussure de trail running robuste avec bande de roulement de 4 mm, plaque anti-coup de pied et embout renforcé.','<p>Semelle extérieure Vibram Megagrip, semelle intermédiaire en EVA et plaque anti-coup de pied en TPU. Partez à la conquête des descentes boueuses, des montées rocheuses et des terrains techniques.</p>'),('fr',6,'Chaussures de sport à empiècements pour hommes',NULL,'Escarpin classique bas en cuir blanc avec surpiqûres assorties.','<p>Tige en cuir lisse, col rembourré et semelle extérieure en caoutchouc à chevrons. Des chaussures blanches minimalistes qui s\'accordent avec tout.</p>'),('fr',7,'Chaussures décontractées Up avec semelle en caoutchouc',NULL,'La chaussure de course comporte une plaque de carbone avec une semelle intercalaire en mousse PEBA et un design à bascule incurvé.','<p>Plaque de carbone pleine longueur. La mousse PEBA restitue plus de 80 % d’énergie. Conçu pour les jours de course du semi-marathon au marathon.</p>'),('fr',8,'Hommes Plat Bas',NULL,'Baskets de marche en cuir avec semelle intérieure coussinée et semelle extérieure en caoutchouc flexible.','<p>Corps en cuir souple avec patchs élastiques aux chevilles. Semelle intérieure amovible pour utilisation d\'orthèses. Des chaussures pour travailler toute la journée.</p>'),('fr',9,'Chaussures décontractées pour hommes avec dessus en PU',NULL,'Chaussure de tennis inspirée du tennis avec maintien latéral, médio-pied rembourré et semelle extérieure à chevrons.','<p>Corps en cuir synthétique avec revêtement TPU. La semelle intermédiaire enveloppante offre une stabilité grâce à des mouvements latéraux rapides. Semelle extérieure multi-pas.</p>'),('fr',10,'Hommes Duramo',NULL,'Silhouette de chaussure de course classique avec tige en daim et talon coussiné.','<p>Superpositions en daim sur une base en mesh respirant. Semelle intercalaire en EVA avec chambre à air exposée au talon. La chaussure lifestyle classique qui commence tout.</p>'),('fr',11,'Niskie baskets',NULL,'Baskets basses avec tige en cuir épuré, col rembourré et logo minimaliste.','<p>Cuir pleine fleur, languette en mousse et semelle extérieure en caoutchouc vulcanisé. Des chaussures lifestyle pour tous les jours : une paire que vous pouvez habiller de manière habillée ou décontractée.</p>'),('fr',12,'Niskie baskets',NULL,'Baskets basses avec tige en cuir épuré, col rembourré et logo minimaliste.','<p>Cuir pleine fleur, languette en mousse et semelle extérieure en caoutchouc vulcanisé. Des chaussures lifestyle pour tous les jours : une paire que vous pouvez habiller de manière habillée ou décontractée.</p>'),('fr',13,'Niskie baskets',NULL,'Baskets basses avec tige en cuir épuré, col rembourré et logo minimaliste.','<p>Cuir pleine fleur, languette en mousse et semelle extérieure en caoutchouc vulcanisé. Des chaussures lifestyle pour tous les jours : une paire que vous pouvez habiller de manière habillée ou décontractée.</p>'),('fr',14,'Niskie baskets',NULL,'Baskets basses avec tige en cuir épuré, col rembourré et logo minimaliste.','<p>Cuir pleine fleur, languette en mousse et semelle extérieure en caoutchouc vulcanisé. Des chaussures lifestyle pour tous les jours : une paire que vous pouvez habiller de manière habillée ou décontractée.</p>'),('fr',15,'RED TAPE Baskets plates pour hommes',NULL,'Baskets lifestyle à semelle plate avec tige en cuir souple et silhouette basse.','<p>Cuir fleur embossé, patch talon en daim et semelle plate en caoutchouc. Convient aux jeans, chinos et pantalons.</p>'),('fr',16,'RED TAPE Baskets plates pour hommes',NULL,'Baskets lifestyle à semelle plate avec tige en cuir souple et silhouette basse.','<p>Cuir fleur embossé, patch talon en daim et semelle plate en caoutchouc. Convient aux jeans, chinos et pantalons.</p>'),('fr',17,'RED TAPE Baskets plates pour hommes',NULL,'Baskets lifestyle à semelle plate avec tige en cuir souple et silhouette basse.','<p>Cuir fleur embossé, patch talon en daim et semelle plate en caoutchouc. Convient aux jeans, chinos et pantalons.</p>'),('fr',18,'RED TAPE Baskets plates pour hommes',NULL,'Baskets lifestyle à semelle plate avec tige en cuir souple et silhouette basse.','<p>Cuir fleur embossé, patch talon en daim et semelle plate en caoutchouc. Convient aux jeans, chinos et pantalons.</p>'),('fr',19,'Baskets plates pour hommes',NULL,'Baskets polyvalentes avec tige en tricot, semelle intercalaire en mousse et design à enfiler.','<p>Le corps tricoté élastique épouse le pied comme une chaussette. Semelle intercalaire moulée en EVA. Chaussures pour les jours de voyage : faciles à passer le contrôle de sécurité et idéales pour la randonnée.</p>'),('fr',20,'Baskets plates pour hommes',NULL,'Baskets polyvalentes avec tige en tricot, semelle intercalaire en mousse et design à enfiler.','<p>Le corps tricoté élastique épouse le pied comme une chaussette. Semelle intercalaire moulée en EVA. Chaussures pour les jours de voyage : faciles à passer le contrôle de sécurité et idéales pour la randonnée.</p>'),('fr',21,'Baskets à lacets Ultimashow 2.0 Mer',NULL,'Chaussure de trail running robuste avec bande de roulement de 4 mm, plaque anti-coup de pied et embout renforcé.','<p>Semelle extérieure Vibram Megagrip, semelle intermédiaire en EVA et plaque anti-coup de pied en TPU. Partez à la conquête des descentes boueuses, des montées rocheuses et des terrains techniques.</p>'),('fr',22,'Baskets à lacets Ultimashow 2.0 Mer',NULL,'Chaussure de trail running robuste avec bande de roulement de 4 mm, plaque anti-coup de pied et embout renforcé.','<p>Semelle extérieure Vibram Megagrip, semelle intermédiaire en EVA et plaque anti-coup de pied en TPU. Partez à la conquête des descentes boueuses, des montées rocheuses et des terrains techniques.</p>'),('fr',23,'Baskets à lacets Ultimashow 2.0 Mer',NULL,'Chaussure de trail running robuste avec bande de roulement de 4 mm, plaque anti-coup de pied et embout renforcé.','<p>Semelle extérieure Vibram Megagrip, semelle intermédiaire en EVA et plaque anti-coup de pied en TPU. Partez à la conquête des descentes boueuses, des montées rocheuses et des terrains techniques.</p>'),('id',1,'Sepatu Olahraga Pria dengan Upper Mesh',NULL,'Sepatu olahraga mesh bersirkulasi udara dengan midsole empuk dan outsole karet tahan lama.','<p> Upper mesh teknis, midsole EVA, dan outsole yang sangat tahan abrasi. Bentuk ukuran standar. Cocok untuk latihan sehari-hari dan berlari di atas mesin.</p>'),('id',2,'Niskie yang licik',NULL,'Sneaker low-top dengan upper berbahan kulit bersih, kerah empuk, dan logo minimalis.','<p>Kulit gandum penuh, lidah busa, dan sol luar karet vulkanisasi. Sepatu gaya hidup untuk setiap hari — sepasang yang bisa Anda kenakan atau kenakan.</p>'),('id',3,'Sepatu Flat Pria Pita Merah',NULL,'Sneaker gaya hidup bersol datar dengan bagian atas berbahan kulit lembut dan siluet berpotongan rendah.','<p>Kulit gandum timbul, tambalan tumit suede, dan sol karet datar. Cocok untuk jeans, chino, dan celana panjang.</p>'),('id',4,'Sepatu Flat Pria',NULL,'Sepatu olahraga serbaguna dengan bagian atas rajutan, midsole busa, dan desain slip-on.','<p>Badan rajutan elastis memeluk kaki seperti kaos kaki. Sol tengah EVA yang dibentuk. Sepatu untuk hari-hari perjalanan — mudah melewati keamanan dan cocok untuk hiking.</p>'),('id',5,'Sepatu Kets Bertali Ultimashow 2.0 Mer',NULL,'Sepatu lari trail yang kokoh dengan tapak 4mm, pelat anti-tendangan, dan penutup jari kaki yang diperkuat.','<p>Sole luar Vibram Megagrip, midsole EVA, dan pelat anti-tendangan TPU. Taklukkan lereng berlumpur, tanjakan berbatu, dan medan teknis.</p>'),('id',6,'Sepatu Athleisure Berpanel Pria',NULL,'Sepatu lapangan klasik berpotongan rendah dari kulit putih dengan jahitan serasi.','<p>Bagian atas berbahan kulit halus, kerah empuk, dan sol luar karet herringbone. Sepatu putih minimalis yang cocok untuk segala hal.</p>'),('id',7,'Sepatu Kasual dengan Sol Karet',NULL,'Sepatu balap ini dilengkapi pelat karbon dengan midsole busa PEBA dan desain rocker melengkung.','<p>Plat karbon panjang penuh. Busa PEBA mengembalikan lebih dari 80% energi. Dirancang untuk hari perlombaan dari setengah maraton hingga maraton.</p>'),('id',8,'Pria Datar Rendah',NULL,'Sneaker berjalan berbahan kulit dengan insole empuk dan outsole karet fleksibel.','<p>Bodi kulit lembut dengan tambalan elastis di bagian pergelangan kaki. Sol dalam yang dapat dilepas untuk penggunaan ortotik. Sepatu untuk bekerja sepanjang hari.</p>'),('id',9,'Sepatu Kasual Pria dengan Upper PU',NULL,'Sepatu lapangan yang terinspirasi dari tenis dengan penyangga lateral, bagian tengah kaki yang empuk, dan sol luar herringbone.','<p>Bodi kulit sintetis dengan lapisan TPU. Midsole yang melingkar memberikan stabilitas melalui gerakan lateral yang cepat. Sol luar multi-pitch.</p>'),('id',10,'Pria Duramo',NULL,'Siluet sepatu lari klasik dengan upper mesh-suede dan tumit empuk.','<p>Lapisan suede dengan dasar jaring yang dapat menyerap keringat. Sol tengah EVA dengan ruang udara di bagian tumit terbuka. Sepatu gaya hidup klasik yang memulai semuanya.</p>'),('id',11,'Niskie yang licik',NULL,'Sneaker low-top dengan upper berbahan kulit bersih, kerah empuk, dan logo minimalis.','<p>Kulit gandum penuh, lidah busa, dan sol luar karet vulkanisasi. Sepatu gaya hidup untuk setiap hari — sepasang yang bisa Anda kenakan atau kenakan.</p>'),('id',12,'Niskie yang licik',NULL,'Sneaker low-top dengan upper berbahan kulit bersih, kerah empuk, dan logo minimalis.','<p>Kulit gandum penuh, lidah busa, dan sol luar karet vulkanisasi. Sepatu gaya hidup untuk setiap hari — sepasang yang bisa Anda kenakan atau kenakan.</p>'),('id',13,'Niskie yang licik',NULL,'Sneaker low-top dengan upper berbahan kulit bersih, kerah empuk, dan logo minimalis.','<p>Kulit gandum penuh, lidah busa, dan sol luar karet vulkanisasi. Sepatu gaya hidup untuk setiap hari — sepasang yang bisa Anda kenakan atau kenakan.</p>'),('id',14,'Niskie yang licik',NULL,'Sneaker low-top dengan upper berbahan kulit bersih, kerah empuk, dan logo minimalis.','<p>Kulit gandum penuh, lidah busa, dan sol luar karet vulkanisasi. Sepatu gaya hidup untuk setiap hari — sepasang yang bisa Anda kenakan atau kenakan.</p>'),('id',15,'Sepatu Flat Pria Pita Merah',NULL,'Sneaker gaya hidup bersol datar dengan bagian atas berbahan kulit lembut dan siluet berpotongan rendah.','<p>Kulit gandum timbul, tambalan tumit suede, dan sol karet datar. Cocok untuk jeans, chino, dan celana panjang.</p>'),('id',16,'Sepatu Flat Pria Pita Merah',NULL,'Sneaker gaya hidup bersol datar dengan bagian atas berbahan kulit lembut dan siluet berpotongan rendah.','<p>Kulit gandum timbul, tambalan tumit suede, dan sol karet datar. Cocok untuk jeans, chino, dan celana panjang.</p>'),('id',17,'Sepatu Flat Pria Pita Merah',NULL,'Sneaker gaya hidup bersol datar dengan bagian atas berbahan kulit lembut dan siluet berpotongan rendah.','<p>Kulit gandum timbul, tambalan tumit suede, dan sol karet datar. Cocok untuk jeans, chino, dan celana panjang.</p>'),('id',18,'Sepatu Flat Pria Pita Merah',NULL,'Sneaker gaya hidup bersol datar dengan bagian atas berbahan kulit lembut dan siluet berpotongan rendah.','<p>Kulit gandum timbul, tambalan tumit suede, dan sol karet datar. Cocok untuk jeans, chino, dan celana panjang.</p>'),('id',19,'Sepatu Flat Pria',NULL,'Sepatu olahraga serbaguna dengan bagian atas rajutan, midsole busa, dan desain slip-on.','<p>Badan rajutan elastis memeluk kaki seperti kaos kaki. Sol tengah EVA yang dibentuk. Sepatu untuk hari-hari perjalanan — mudah melewati keamanan dan cocok untuk hiking.</p>'),('id',20,'Sepatu Flat Pria',NULL,'Sepatu olahraga serbaguna dengan bagian atas rajutan, midsole busa, dan desain slip-on.','<p>Badan rajutan elastis memeluk kaki seperti kaos kaki. Sol tengah EVA yang dibentuk. Sepatu untuk hari-hari perjalanan — mudah melewati keamanan dan cocok untuk hiking.</p>'),('id',21,'Sepatu Kets Bertali Ultimashow 2.0 Mer',NULL,'Sepatu lari trail yang kokoh dengan tapak 4mm, pelat anti-tendangan, dan penutup jari kaki yang diperkuat.','<p>Sole luar Vibram Megagrip, midsole EVA, dan pelat anti-tendangan TPU. Taklukkan lereng berlumpur, tanjakan berbatu, dan medan teknis.</p>'),('id',22,'Sepatu Kets Bertali Ultimashow 2.0 Mer',NULL,'Sepatu lari trail yang kokoh dengan tapak 4mm, pelat anti-tendangan, dan penutup jari kaki yang diperkuat.','<p>Sole luar Vibram Megagrip, midsole EVA, dan pelat anti-tendangan TPU. Taklukkan lereng berlumpur, tanjakan berbatu, dan medan teknis.</p>'),('id',23,'Sepatu Kets Bertali Ultimashow 2.0 Mer',NULL,'Sepatu lari trail yang kokoh dengan tapak 4mm, pelat anti-tendangan, dan penutup jari kaki yang diperkuat.','<p>Sole luar Vibram Megagrip, midsole EVA, dan pelat anti-tendangan TPU. Taklukkan lereng berlumpur, tanjakan berbatu, dan medan teknis.</p>'),('tr',1,'File sayalı Erkek Spor Ayakkabı',NULL,'Yastıklı orta tabanlı ve dayanıklı kauçuk dış tabanlı, nefes alabilen file spor ayakkabı.','<p>Teknik file saya, EVA orta taban ve aşınmaya karşı son derece dayanıklı dış taban. Standart ölçü formu. Günlük egzersizler ve makinede koşmak için uygundur.</p>'),('tr',2,'Spor Ayakkabı Niskie',NULL,'Temiz deri sayalı, dolgulu yakalı ve minimal logolu düşük bilekli spor ayakkabı.','<p>Sırçalı deri, köpük dil ve vulkanize kauçuk dış taban. Her güne uygun yaşam tarzı ayakkabılar — hem şık hem de sade giyinebileceğiniz bir çift.</p>'),('tr',3,'RED BANT Erkek Düz Spor Ayakkabı',NULL,'Yumuşak deri sayalı ve düşük kesimli, düz tabanlı yaşam tarzı spor ayakkabı.','<p>Kabartmalı deri, süet topuk yaması ve düz kauçuk taban. Kot pantolon, chino ve pantolonlara uygundur.</p>'),('tr',4,'Erkek Düz Spor Ayakkabı',NULL,'Örme sayalı, köpük orta tabanlı ve bağcıksız tasarımlı çok yönlü spor ayakkabı.','<p>Elastik örgü gövde ayağı çorap gibi sarar. Kalıplanmış EVA orta taban. Seyahat günleri için ayakkabılar — güvenliği aşması kolay ve yürüyüş için harika.</p>'),('tr',5,'Ultimashow 2.0 Mer Bağcıklı Spor Ayakkabı',NULL,'4 mm lastik sırtı, tekme önleyici plaka ve güçlendirilmiş burun kısmıyla sağlam arazi koşu ayakkabısı.','<p>Vibram Megagrip dış taban, EVA orta taban ve TPU darbe önleyici plaka. Çamurlu yokuşları, kayalık tırmanışları ve teknik arazileri fethedin.</p>'),('tr',6,'Erkek Panelli Spor Ayakkabı',NULL,'Uyumlu dikişlere sahip, beyaz deriden yapılmış, klasik dekolteli kort ayakkabısı.','<p>Pürüzsüz deri saya, dolgulu yaka ve balıksırtı kauçuk dış taban. Her şeye uyum sağlayan minimalist beyaz ayakkabılar.</p>'),('tr',7,'Kauçuk Tabanlı Up Casual Ayakkabı',NULL,'Yarış ayakkabısı, PEBA köpük orta tabanlı ve kavisli rocker tasarımına sahip bir karbon plakaya sahiptir.','<p>Tam uzunlukta karbon plaka. PEBA köpüğü %80\'den fazla enerji geri kazandırır. Yarı maratondan maratona kadar yarış günleri için tasarlandı.</p>'),('tr',8,'Erkekler Düz Düşük',NULL,'Yastıklı iç tabanlı ve esnek kauçuk dış tabanlı, deri yürüyüş ayakkabısı.','<p>Bileklerde elastik yamalar bulunan yumuşak deri gövde. Ortotik kullanım için çıkarılabilir iç taban. Bütün gün çalışmaya uygun ayakkabılar.</p>'),('tr',9,'PU Üstlü Erkek Günlük Ayakkabı',NULL,'Yanal destekli, yastıklı orta ayaklı ve balıksırtı dış tabanlı, tenisten ilham alan kort ayakkabısı.','<p>TPU kaplamalı sentetik deri gövde. Çevreleyen orta taban, hızlı yanal hareketlerle stabilite sağlar. Çok adımlı dış taban.</p>'),('tr',10,'Erkekler Duramo',NULL,'File süet sayalı ve yastıklı topuklu klasik koşu ayakkabısı silueti.','<p>Nefes alabilen file taban üzerinde süet katmanlar. Açık topuk hava bölmesine sahip EVA orta taban. Her şeyi başlatan klasik yaşam tarzı ayakkabısı.</p>'),('tr',11,'Spor Ayakkabı Niskie',NULL,'Temiz deri sayalı, dolgulu yakalı ve minimal logolu düşük bilekli spor ayakkabı.','<p>Sırçalı deri, köpük dil ve vulkanize kauçuk dış taban. Her güne uygun yaşam tarzı ayakkabılar — hem şık hem de sade giyinebileceğiniz bir çift.</p>'),('tr',12,'Spor Ayakkabı Niskie',NULL,'Temiz deri sayalı, dolgulu yakalı ve minimal logolu düşük bilekli spor ayakkabı.','<p>Sırçalı deri, köpük dil ve vulkanize kauçuk dış taban. Her güne uygun yaşam tarzı ayakkabılar — hem şık hem de sade giyinebileceğiniz bir çift.</p>'),('tr',13,'Spor Ayakkabı Niskie',NULL,'Temiz deri sayalı, dolgulu yakalı ve minimal logolu düşük bilekli spor ayakkabı.','<p>Sırçalı deri, köpük dil ve vulkanize kauçuk dış taban. Her güne uygun yaşam tarzı ayakkabılar — hem şık hem de sade giyinebileceğiniz bir çift.</p>'),('tr',14,'Spor Ayakkabı Niskie',NULL,'Temiz deri sayalı, dolgulu yakalı ve minimal logolu düşük bilekli spor ayakkabı.','<p>Sırçalı deri, köpük dil ve vulkanize kauçuk dış taban. Her güne uygun yaşam tarzı ayakkabılar — hem şık hem de sade giyinebileceğiniz bir çift.</p>'),('tr',15,'RED BANT Erkek Düz Spor Ayakkabı',NULL,'Yumuşak deri sayalı ve düşük kesimli, düz tabanlı yaşam tarzı spor ayakkabı.','<p>Kabartmalı deri, süet topuk yaması ve düz kauçuk taban. Kot pantolon, chino ve pantolonlara uygundur.</p>'),('tr',16,'RED BANT Erkek Düz Spor Ayakkabı',NULL,'Yumuşak deri sayalı ve düşük kesimli, düz tabanlı yaşam tarzı spor ayakkabı.','<p>Kabartmalı deri, süet topuk yaması ve düz kauçuk taban. Kot pantolon, chino ve pantolonlara uygundur.</p>'),('tr',17,'RED BANT Erkek Düz Spor Ayakkabı',NULL,'Yumuşak deri sayalı ve düşük kesimli, düz tabanlı yaşam tarzı spor ayakkabı.','<p>Kabartmalı deri, süet topuk yaması ve düz kauçuk taban. Kot pantolon, chino ve pantolonlara uygundur.</p>'),('tr',18,'RED BANT Erkek Düz Spor Ayakkabı',NULL,'Yumuşak deri sayalı ve düşük kesimli, düz tabanlı yaşam tarzı spor ayakkabı.','<p>Kabartmalı deri, süet topuk yaması ve düz kauçuk taban. Kot pantolon, chino ve pantolonlara uygundur.</p>'),('tr',19,'Erkek Düz Spor Ayakkabı',NULL,'Örme sayalı, köpük orta tabanlı ve bağcıksız tasarımlı çok yönlü spor ayakkabı.','<p>Elastik örgü gövde ayağı çorap gibi sarar. Kalıplanmış EVA orta taban. Seyahat günleri için ayakkabılar — güvenliği aşması kolay ve yürüyüş için harika.</p>'),('tr',20,'Erkek Düz Spor Ayakkabı',NULL,'Örme sayalı, köpük orta tabanlı ve bağcıksız tasarımlı çok yönlü spor ayakkabı.','<p>Elastik örgü gövde ayağı çorap gibi sarar. Kalıplanmış EVA orta taban. Seyahat günleri için ayakkabılar — güvenliği aşması kolay ve yürüyüş için harika.</p>'),('tr',21,'Ultimashow 2.0 Mer Bağcıklı Spor Ayakkabı',NULL,'4 mm lastik sırtı, tekme önleyici plaka ve güçlendirilmiş burun kısmıyla sağlam arazi koşu ayakkabısı.','<p>Vibram Megagrip dış taban, EVA orta taban ve TPU darbe önleyici plaka. Çamurlu yokuşları, kayalık tırmanışları ve teknik arazileri fethedin.</p>'),('tr',22,'Ultimashow 2.0 Mer Bağcıklı Spor Ayakkabı',NULL,'4 mm lastik sırtı, tekme önleyici plaka ve güçlendirilmiş burun kısmıyla sağlam arazi koşu ayakkabısı.','<p>Vibram Megagrip dış taban, EVA orta taban ve TPU darbe önleyici plaka. Çamurlu yokuşları, kayalık tırmanışları ve teknik arazileri fethedin.</p>'),('tr',23,'Ultimashow 2.0 Mer Bağcıklı Spor Ayakkabı',NULL,'4 mm lastik sırtı, tekme önleyici plaka ve güçlendirilmiş burun kısmıyla sağlam arazi koşu ayakkabısı.','<p>Vibram Megagrip dış taban, EVA orta taban ve TPU darbe önleyici plaka. Çamurlu yokuşları, kayalık tırmanışları ve teknik arazileri fethedin.</p>'),('vi',1,'Giày Thể Thao Nam Thân Lưới',NULL,'Giày tập thân lưới thoáng khí với đế giữa êm ái và đế ngoài cao su bền bỉ.','<p>Thân lưới kỹ thuật, đế giữa EVA và đế ngoài chống mài mòn cao. Kích cỡ chuẩn form. Phù hợp cho tập luyện hàng ngày và chạy trên máy.</p>'),('vi',2,'Giày Sneaker Cổ Thấp',NULL,'Giày sneaker cổ thấp với thân da sạch sẽ, cổ giày có đệm và logo tối giản.','<p>Da nguyên tấm, lưỡi gà có đệm mút và đế ngoài cao su lưu hóa. Đôi giày phong cách sống cho mỗi ngày — một đôi bạn có thể phối lịch sự hay năng động.</p>'),('vi',3,'Giày Sneaker Đế Bằng Nam RED TAPE',NULL,'Giày sneaker phong cách sống đế bằng với thân da mềm và dáng giày thấp gọn.','<p>Da hạt nổi, miếng vá gót bằng da lộn và đế cao su bằng. Phù hợp với quần jeans, quần chinos và quần tây.</p>'),('vi',4,'Giày Sneaker Đế Bằng Nam',NULL,'Giày tập đa năng với thân dệt kim, đế giữa bằng mút và thiết kế xỏ chân.','<p>Thân dệt kim co giãn ôm chân như tất. Đế giữa EVA ép khuôn. Đôi giày cho ngày di chuyển — dễ dàng qua cửa an ninh và phù hợp đi bộ đường dài.</p>'),('vi',5,'Giày Sneaker Buộc Dây Ultimashow 2.0',NULL,'Giày chạy địa hình mạnh mẽ với gai đế 4mm, tấm chống đá và mũi giày được gia cố.','<p>Đế ngoài Vibram Megagrip, đế giữa EVA và tấm chống đá TPU. Chinh phục những đoạn xuống dốc lầy lội, leo dốc đá và địa hình kỹ thuật.</p>'),('vi',6,'Giày Athleisure Nam Phối Mảng',NULL,'Dáng giày court cổ thấp cổ điển bằng da trắng với đường chỉ may đồng màu.','<p>Thân da trơn, cổ giày có đệm và đế ngoài cao su họa tiết xương cá. Đôi giày trắng tối giản phối được với mọi thứ.</p>'),('vi',7,'Giày Casual Đế Cao Su',NULL,'Giày chạy đua có tấm carbon với đế giữa bằng mút PEBA và thiết kế cong kiểu rocker.','<p>Tấm carbon dài toàn bộ. Mút pha PEBA hoàn trả hơn 80% năng lượng. Thiết kế cho những ngày đua từ bán marathon đến marathon.</p>'),('vi',8,'Giày Đế Bằng Cổ Thấp Nam',NULL,'Giày sneaker đi bộ bằng da với lót đế êm ái và đế ngoài cao su linh hoạt.','<p>Thân da mềm với các mảng co giãn ở cổ chân. Lót đế có thể tháo rời để dùng đế chỉnh hình. Đôi giày đi làm cả ngày.</p>'),('vi',9,'Giày Casual Nam Thân PU',NULL,'Giày court lấy cảm hứng từ tennis với hỗ trợ ngang, phần giữa bàn chân có đệm và đế ngoài họa tiết xương cá.','<p>Thân da tổng hợp với lớp phủ TPU. Đế giữa bao quanh giúp ổn định qua những pha di chuyển ngang nhanh. Đế ngoài đa sân.</p>'),('vi',10,'Giày Chạy Nam Duramo',NULL,'Dáng giày chạy cổ điển với thân da lộn pha lưới và gót giày có đệm mút.','<p>Lớp phủ da lộn trên nền lưới thoáng khí. Đế giữa EVA với khoang khí lộ ở gót. Đôi giày phong cách sống cổ điển khởi đầu mọi thứ.</p>'),('vi',11,'Giày Sneaker Cổ Thấp',NULL,'Giày sneaker cổ thấp với thân da sạch sẽ, cổ giày có đệm và logo tối giản.','<p>Da nguyên tấm, lưỡi gà có đệm mút và đế ngoài cao su lưu hóa. Đôi giày phong cách sống cho mỗi ngày — một đôi bạn có thể phối lịch sự hay năng động.</p>'),('vi',12,'Giày Sneaker Cổ Thấp',NULL,'Giày sneaker cổ thấp với thân da sạch sẽ, cổ giày có đệm và logo tối giản.','<p>Da nguyên tấm, lưỡi gà có đệm mút và đế ngoài cao su lưu hóa. Đôi giày phong cách sống cho mỗi ngày — một đôi bạn có thể phối lịch sự hay năng động.</p>'),('vi',13,'Giày Sneaker Cổ Thấp',NULL,'Giày sneaker cổ thấp với thân da sạch sẽ, cổ giày có đệm và logo tối giản.','<p>Da nguyên tấm, lưỡi gà có đệm mút và đế ngoài cao su lưu hóa. Đôi giày phong cách sống cho mỗi ngày — một đôi bạn có thể phối lịch sự hay năng động.</p>'),('vi',14,'Giày Sneaker Cổ Thấp',NULL,'Giày sneaker cổ thấp với thân da sạch sẽ, cổ giày có đệm và logo tối giản.','<p>Da nguyên tấm, lưỡi gà có đệm mút và đế ngoài cao su lưu hóa. Đôi giày phong cách sống cho mỗi ngày — một đôi bạn có thể phối lịch sự hay năng động.</p>'),('vi',15,'Giày Sneaker Đế Bằng Nam RED TAPE',NULL,'Giày sneaker phong cách sống đế bằng với thân da mềm và dáng giày thấp gọn.','<p>Da hạt nổi, miếng vá gót bằng da lộn và đế cao su bằng. Phù hợp với quần jeans, quần chinos và quần tây.</p>'),('vi',16,'Giày Sneaker Đế Bằng Nam RED TAPE',NULL,'Giày sneaker phong cách sống đế bằng với thân da mềm và dáng giày thấp gọn.','<p>Da hạt nổi, miếng vá gót bằng da lộn và đế cao su bằng. Phù hợp với quần jeans, quần chinos và quần tây.</p>'),('vi',17,'Giày Sneaker Đế Bằng Nam RED TAPE',NULL,'Giày sneaker phong cách sống đế bằng với thân da mềm và dáng giày thấp gọn.','<p>Da hạt nổi, miếng vá gót bằng da lộn và đế cao su bằng. Phù hợp với quần jeans, quần chinos và quần tây.</p>'),('vi',18,'Giày Sneaker Đế Bằng Nam RED TAPE',NULL,'Giày sneaker phong cách sống đế bằng với thân da mềm và dáng giày thấp gọn.','<p>Da hạt nổi, miếng vá gót bằng da lộn và đế cao su bằng. Phù hợp với quần jeans, quần chinos và quần tây.</p>'),('vi',19,'Giày Sneaker Đế Bằng Nam',NULL,'Giày tập đa năng với thân dệt kim, đế giữa bằng mút và thiết kế xỏ chân.','<p>Thân dệt kim co giãn ôm chân như tất. Đế giữa EVA ép khuôn. Đôi giày cho ngày di chuyển — dễ dàng qua cửa an ninh và phù hợp đi bộ đường dài.</p>'),('vi',20,'Giày Sneaker Đế Bằng Nam',NULL,'Giày tập đa năng với thân dệt kim, đế giữa bằng mút và thiết kế xỏ chân.','<p>Thân dệt kim co giãn ôm chân như tất. Đế giữa EVA ép khuôn. Đôi giày cho ngày di chuyển — dễ dàng qua cửa an ninh và phù hợp đi bộ đường dài.</p>'),('vi',21,'Giày Sneaker Buộc Dây Ultimashow 2.0',NULL,'Giày chạy địa hình mạnh mẽ với gai đế 4mm, tấm chống đá và mũi giày được gia cố.','<p>Đế ngoài Vibram Megagrip, đế giữa EVA và tấm chống đá TPU. Chinh phục những đoạn xuống dốc lầy lội, leo dốc đá và địa hình kỹ thuật.</p>'),('vi',22,'Giày Sneaker Buộc Dây Ultimashow 2.0',NULL,'Giày chạy địa hình mạnh mẽ với gai đế 4mm, tấm chống đá và mũi giày được gia cố.','<p>Đế ngoài Vibram Megagrip, đế giữa EVA và tấm chống đá TPU. Chinh phục những đoạn xuống dốc lầy lội, leo dốc đá và địa hình kỹ thuật.</p>'),('vi',23,'Giày Sneaker Buộc Dây Ultimashow 2.0',NULL,'Giày chạy địa hình mạnh mẽ với gai đế 4mm, tấm chống đá và mũi giày được gia cố.','<p>Đế ngoài Vibram Megagrip, đế giữa EVA và tấm chống đá TPU. Chinh phục những đoạn xuống dốc lầy lội, leo dốc đá và địa hình kỹ thuật.</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,8,NULL,NULL,1,5,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(2,5,NULL,NULL,4,3,'Clean & perfect source code','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(3,3,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:10:45','2026-05-28 19:10:45',NULL),(4,3,NULL,NULL,6,4,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(5,2,NULL,NULL,5,5,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(6,4,NULL,NULL,10,1,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(7,5,NULL,NULL,7,1,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(8,2,NULL,NULL,10,4,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(9,2,NULL,NULL,8,4,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(10,9,NULL,NULL,2,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:10:45','2026-05-28 19:10:45',NULL),(11,2,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:10:45','2026-05-28 19:10:45',NULL),(12,5,NULL,NULL,8,4,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(13,5,NULL,NULL,3,1,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(14,5,NULL,NULL,6,1,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(15,9,NULL,NULL,4,5,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(16,1,NULL,NULL,8,1,'Clean & perfect source code','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(17,6,NULL,NULL,4,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:10:45','2026-05-28 19:10:45',NULL),(18,8,NULL,NULL,4,3,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(19,4,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:10:45','2026-05-28 19:10:45',NULL),(20,3,NULL,NULL,4,1,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(21,10,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:10:45','2026-05-28 19:10:45',NULL),(22,9,NULL,NULL,1,3,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(23,1,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:10:45','2026-05-28 19:10:45',NULL),(24,1,NULL,NULL,3,2,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(25,5,NULL,NULL,5,4,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(26,3,NULL,NULL,5,3,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(27,8,NULL,NULL,6,1,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(28,9,NULL,NULL,5,5,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(29,3,NULL,NULL,7,1,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(30,5,NULL,NULL,2,4,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(31,4,NULL,NULL,8,4,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(32,3,NULL,NULL,8,4,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(33,10,NULL,NULL,10,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:10:45','2026-05-28 19:10:45',NULL),(34,10,NULL,NULL,1,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:10:45','2026-05-28 19:10:45',NULL),(35,7,NULL,NULL,2,4,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(36,1,NULL,NULL,6,1,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(37,3,NULL,NULL,2,1,'Clean & perfect source code','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(38,10,NULL,NULL,4,4,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(39,4,NULL,NULL,2,3,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(40,8,NULL,NULL,7,4,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(41,10,NULL,NULL,3,5,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(42,6,NULL,NULL,8,2,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(43,2,NULL,NULL,2,4,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(44,2,NULL,NULL,3,2,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(45,2,NULL,NULL,9,2,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(46,6,NULL,NULL,1,3,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(47,8,NULL,NULL,5,4,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(48,5,NULL,NULL,10,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:10:45','2026-05-28 19:10:45',NULL),(49,5,NULL,NULL,9,5,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(50,10,NULL,NULL,9,1,'Clean & perfect source code','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(51,7,NULL,NULL,10,4,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(52,7,NULL,NULL,4,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:10:45','2026-05-28 19:10:45',NULL),(53,4,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:10:45','2026-05-28 19:10:45',NULL),(54,4,NULL,NULL,9,4,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(55,9,NULL,NULL,8,3,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(56,2,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:10:45','2026-05-28 19:10:45',NULL),(57,1,NULL,NULL,1,1,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(58,7,NULL,NULL,3,5,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(59,4,NULL,NULL,3,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:10:45','2026-05-28 19:10:45',NULL),(60,6,NULL,NULL,3,5,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(61,10,NULL,NULL,6,2,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(62,3,NULL,NULL,10,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:10:45','2026-05-28 19:10:45',NULL),(63,9,NULL,NULL,7,3,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(64,8,NULL,NULL,9,2,'Clean & perfect source code','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(65,10,NULL,NULL,5,4,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(66,7,NULL,NULL,8,3,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(67,6,NULL,NULL,2,5,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(68,8,NULL,NULL,8,4,'Clean & perfect source code','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(69,9,NULL,NULL,9,2,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(70,7,NULL,NULL,5,4,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(71,3,NULL,NULL,3,2,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(72,7,NULL,NULL,9,3,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(73,1,NULL,NULL,2,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:10:45','2026-05-28 19:10:45',NULL),(74,7,NULL,NULL,1,4,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(75,1,NULL,NULL,10,4,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(76,9,NULL,NULL,3,1,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(77,9,NULL,NULL,10,5,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(78,7,NULL,NULL,7,5,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(79,6,NULL,NULL,9,1,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(80,8,NULL,NULL,10,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:10:45','2026-05-28 19:10:45',NULL),(81,6,NULL,NULL,10,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:10:45','2026-05-28 19:10:45',NULL),(82,6,NULL,NULL,6,4,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(83,8,NULL,NULL,2,1,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(84,6,NULL,NULL,5,1,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(85,10,NULL,NULL,2,1,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(86,1,NULL,NULL,4,4,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(87,1,NULL,NULL,7,5,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(88,6,NULL,NULL,7,2,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(89,3,NULL,NULL,9,1,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(90,7,NULL,NULL,6,4,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(91,4,NULL,NULL,5,3,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(92,4,NULL,NULL,1,1,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(93,8,NULL,NULL,3,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:10:45','2026-05-28 19:10:45',NULL),(94,5,NULL,NULL,1,4,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(95,1,NULL,NULL,5,1,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(96,9,NULL,NULL,6,3,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(97,2,NULL,NULL,1,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:10:45','2026-05-28 19:10:45',NULL),(98,10,NULL,NULL,8,3,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(99,2,NULL,NULL,7,1,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','auto','2026-05-28 19:10:45','2026-05-28 19:10:45',NULL),(100,4,NULL,NULL,6,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:10:45','2026-05-28 19:10:45',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:10:45','2026-05-28 19:10:45'),(2,'International',NULL,'2026-05-28 19:10:45','2026-05-28 19:10:45');

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

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

--
