--
-- 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,'vf8vsKuQWjcTWSGhrpwNGfaE0u8kcqwK',1,'2026-05-28 18:59:07','2026-05-28 18:59:07','2026-05-28 18:59:07');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `categories` VALUES (1,'New Parents',0,'Guides and reassurance for the first weeks and months with a newborn.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2026-05-28 18:59:09','2026-05-28 18:59:09'),(2,'Baby Care',0,'Daily care, gentle products, and habits that support a healthy little one.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 18:59:09','2026-05-28 18:59:09'),(3,'Sleep &amp; Routines',0,'Soothing rituals, nap schedules, and tools for calmer nights.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 18:59:09','2026-05-28 18:59:09'),(4,'Nutrition',0,'Feeding milestones, weaning, and clean nutrition for growing babies.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 18:59:09','2026-05-28 18:59:09'),(5,'Safety',0,'Practical safety advice, gear checks, and peace-of-mind essentials.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 18:59:09','2026-05-28 18:59:09');

--
-- 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,'Sleep &amp; Routines','Soothing rituals, nap schedules, and tools for calmer nights.'),('ar',4,'تَغذِيَة','مراحل الأكل والفطام والتغذية الصحية لنمو الأطفال.'),('ar',5,'أمان','نصائح عملية تتعلق بالسلامة، وفحص العتاد، وأساسيات راحة البال.'),('fr',1,'Nouveaux parents','Conseils et réconfort pendant les premières semaines et mois avec votre nouveau-né.'),('fr',2,'Soins de bébé','Des soins quotidiens, des produits doux et des habitudes qui favorisent un bébé en bonne santé.'),('fr',3,'Sleep &amp; Routines','Soothing rituals, nap schedules, and tools for calmer nights.'),('fr',4,'Nutrition','Étapes d’alimentation, de sevrage et de nutrition saine pour les bébés en pleine croissance.'),('fr',5,'Sécurité','Conseils pratiques de sécurité, contrôle du matériel et essentiels pour la tranquillité d\'esprit.'),('id',1,'Orang Tua Baru','Bimbingan dan kepastian untuk minggu dan bulan pertama bersama bayi baru lahir Anda.'),('id',2,'Perawatan Bayi','Perawatan sehari-hari, produk lembut dan kebiasaan yang mendukung bayi sehat.'),('id',3,'Sleep &amp; Routines','Soothing rituals, nap schedules, and tools for calmer nights.'),('id',4,'Nutrisi','Pola makan, penyapihan, dan nutrisi yang sehat merupakan tonggak sejarah bagi pertumbuhan bayi.'),('id',5,'Keamanan','Saran keselamatan praktis, pemeriksaan perlengkapan, dan hal-hal penting yang menenangkan pikiran.'),('tr',1,'Yeni Ebeveynler','Yeni doğmuş bebeğinizle ilk haftalar ve aylar için rehberlik ve güvence.'),('tr',2,'Bebek Bakımı','Sağlıklı bir bebeği destekleyen günlük bakım, nazik ürünler ve alışkanlıklar.'),('tr',3,'Sleep &amp; Routines','Soothing rituals, nap schedules, and tools for calmer nights.'),('tr',4,'Beslenme','Büyüyen bebekler için yemek yeme, sütten kesme ve sağlıklı beslenme kilometre taşları.'),('tr',5,'Emniyet','Pratik güvenlik tavsiyeleri, vites kontrolleri ve gönül rahatlığıyla ilgili temel bilgiler.'),('vi',1,'Cha Mẹ Mới','Hướng dẫn và lời trấn an cho những tuần và tháng đầu tiên cùng trẻ sơ sinh.'),('vi',2,'Chăm Sóc Bé','Chăm sóc hằng ngày, sản phẩm dịu nhẹ và những thói quen hỗ trợ một em bé khỏe mạnh.'),('vi',3,'Sleep &amp; Routines','Soothing rituals, nap schedules, and tools for calmer nights.'),('vi',4,'Dinh Dưỡng','Các cột mốc ăn uống, cai sữa và dinh dưỡng lành mạnh cho bé đang lớn.'),('vi',5,'An Toàn','Lời khuyên an toàn thiết thực, kiểm tra đồ dùng và những điều thiết yếu giúp yên tâm.');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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


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

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

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

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

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

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

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

INSERT INTO `ec_customer_addresses` VALUES (1,'Emma Collins','customer@botble.com','+1-555-0105','CA','Michigan','Austin','987 Birch Boulevard',1,1,'2026-05-28 18:59:15','2026-05-28 18:59:15','19101'),(2,'Emma Collins','customer@botble.com','+1-555-0102','GB','Ohio','Chicago','789 Pine Road',1,0,'2026-05-28 18:59:15','2026-05-28 18:59:15','10001'),(3,'Sophia Ramirez','vendor@botble.com','+1-555-0107','CA','Pennsylvania','Phoenix','741 Spruce Street',2,1,'2026-05-28 18:59:16','2026-05-28 18:59:16','10001'),(4,'Sophia Ramirez','vendor@botble.com','+1-555-0103','GB','Texas','Los Angeles','258 Walnut Way',2,0,'2026-05-28 18:59:16','2026-05-28 18:59:16','30301'),(5,'Olivia Carter','customer1@example.com','+1-555-0101','GB','Florida','Houston','321 Maple Drive',3,1,'2026-05-28 18:59:16','2026-05-28 18:59:16','60601'),(6,'Ava Mitchell','customer2@example.com','+1-555-0109','GB','Illinois','Miami','987 Birch Boulevard',4,1,'2026-05-28 18:59:16','2026-05-28 18:59:16','30301'),(7,'Isabella Brooks','customer3@example.com','+1-555-0108','AU','Ohio','Austin','369 Cherry Circle',5,1,'2026-05-28 18:59:16','2026-05-28 18:59:16','85001'),(8,'James Whitfield','customer4@example.com','+1-555-0103','GB','Ohio','Dallas','789 Pine Road',6,1,'2026-05-28 18:59:17','2026-05-28 18:59:17','90210'),(9,'Liam Bennett','customer5@example.com','+1-555-0107','GB','New York','Houston','147 Elm Court',7,1,'2026-05-28 18:59:17','2026-05-28 18:59:17','80201'),(10,'Noah Patterson','customer6@example.com','+1-555-0108','GB','Arizona','Dallas','456 Oak Avenue',8,1,'2026-05-28 18:59:17','2026-05-28 18:59:17','30301'),(11,'Charlotte Reed','customer7@example.com','+1-555-0105','GB','Ohio','Phoenix','123 Main Street',9,1,'2026-05-28 18:59:17','2026-05-28 18:59:17','80201'),(12,'Amelia Foster','customer8@example.com','+1-555-0108','DE','California','San Diego','456 Oak Avenue',10,1,'2026-05-28 18:59:18','2026-05-28 18:59:18','48201');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `ec_discounts` VALUES (1,'Welcome 10% Off','WELCOME10','2026-05-28 01:59:18','2026-07-28 01:59:18',NULL,0,10,'coupon',0,0,NULL,NULL,'percentage','all-orders',0.00,0,1,'2026-05-28 18:59:18','2026-05-28 18:59:18',NULL,'A welcome discount for first-time shoppers — 10% off any order.'),(2,'Free Shipping Over $50','FREESHIP','2026-05-28 01:59:18',NULL,NULL,0,100,'coupon',0,0,NULL,NULL,'shipping','all-orders',50.00,0,1,'2026-05-28 18:59:18','2026-05-28 18:59:18',NULL,'Free shipping on any order $50 or above.'),(3,'Spring Sale — $25 Off','SPRING25','2026-05-28 01:59:18','2026-06-28 01:59:18',500,0,25,'coupon',0,0,NULL,NULL,'amount','all-orders',150.00,0,1,'2026-05-28 18:59:18','2026-05-28 18:59:18',NULL,'A flat $25 off orders over $150.'),(4,'VIP Member 20% Off','VIP20','2026-05-28 01:59:18','2026-08-27 01:59:18',NULL,0,20,'coupon',0,0,NULL,NULL,'percentage','all-orders',100.00,0,1,'2026-05-28 18:59:18','2026-05-28 18:59:18',NULL,'Exclusive 20% off for newsletter subscribers.'),(5,'Bundle & Save $50','BUNDLE50','2026-05-28 01:59:18','2026-07-13 01:59:18',NULL,0,50,'coupon',0,0,NULL,NULL,'amount','all-orders',300.00,0,1,'2026-05-28 18:59:18','2026-05-28 18:59:18',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,5,41.3,50,0),(1,7,15.4,50,0),(1,8,13.3,50,0),(1,6,62.3,50,0),(1,10,30.8,50,0),(1,3,34.3,50,0),(1,2,23.8,50,0),(1,9,16.8,50,0),(1,1,27.3,50,0),(2,8,14.25,75,0),(2,1,29.25,75,0),(2,7,16.5,75,0),(2,9,18,75,0),(2,10,33,75,0),(2,2,25.5,75,0),(2,5,44.25,75,0);

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

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

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

INSERT INTO `ec_flash_sales` VALUES (1,'48-Hour Flash Sale','2026-05-31 01:59:18','published','2026-05-28 18:59:18','2026-05-28 18:59:18'),(2,'Weekend Doorbusters','2026-06-03 01:59:18','published','2026-05-28 18:59:18','2026-05-28 18:59:18');

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `ec_product_categories` VALUES (1,'Feeding Gear',NULL,0,'Bottles, bibs, and feeding essentials designed for safe and easy mealtimes.','published',0,'categories/cate-16.jpg',1,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(2,'Bottles & Teats',NULL,1,NULL,'published',0,NULL,0,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(3,'Bibs & Burp Cloths',NULL,1,NULL,'published',1,NULL,0,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(4,'Pacifiers & Soothers',NULL,1,NULL,'published',2,NULL,0,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(5,'Feeding Sets & Utensils',NULL,1,NULL,'published',3,NULL,0,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(6,'Baby Wear',NULL,0,'Soft cotton onesies, booties, and everyday outfits for delicate baby skin.','published',1,'categories/cate-17.jpg',1,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(7,'Bodysuits & Onesies',NULL,6,NULL,'published',0,NULL,0,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(8,'Booties & Socks',NULL,6,NULL,'published',1,NULL,0,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(9,'Hats & Mittens',NULL,6,NULL,'published',2,NULL,0,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(10,'Sleepwear',NULL,6,NULL,'published',3,NULL,0,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(11,'Play Time',NULL,0,'Wooden teethers, plush toys, and gentle play companions for early development.','published',2,'categories/cate-18.jpg',1,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(12,'Teethers',NULL,11,NULL,'published',0,NULL,0,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(13,'Plush Toys',NULL,11,NULL,'published',1,NULL,0,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(14,'Activity Gyms',NULL,11,NULL,'published',2,NULL,0,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(15,'Wooden Toys',NULL,11,NULL,'published',3,NULL,0,'2026-05-28 18:59:10','2026-05-28 18:59:10',NULL,NULL),(16,'Bath Care',NULL,0,'Hooded towels, lotions, and bath time essentials that keep skin soft and calm.','published',3,'categories/cate-19.jpg',1,'2026-05-28 18:59:11','2026-05-28 18:59:11',NULL,NULL),(17,'Hooded Towels',NULL,16,NULL,'published',0,NULL,0,'2026-05-28 18:59:11','2026-05-28 18:59:11',NULL,NULL),(18,'Lotions & Oils',NULL,16,NULL,'published',1,NULL,0,'2026-05-28 18:59:11','2026-05-28 18:59:11',NULL,NULL),(19,'Bath Tubs & Seats',NULL,16,NULL,'published',2,NULL,0,'2026-05-28 18:59:11','2026-05-28 18:59:11',NULL,NULL),(20,'Washcloths & Sponges',NULL,16,NULL,'published',3,NULL,0,'2026-05-28 18:59:11','2026-05-28 18:59:11',NULL,NULL),(21,'Baby Room',NULL,0,'Cribs, mobiles, sleeping bags, and nursery essentials that shape a soothing space.','published',4,'categories/cate-20.jpg',1,'2026-05-28 18:59:11','2026-05-28 18:59:11',NULL,NULL),(22,'Cribs & Bassinets',NULL,21,NULL,'published',0,NULL,0,'2026-05-28 18:59:11','2026-05-28 18:59:11',NULL,NULL),(23,'Sleeping Bags',NULL,21,NULL,'published',1,NULL,0,'2026-05-28 18:59:11','2026-05-28 18:59:11',NULL,NULL),(24,'Mobiles & Night Lights',NULL,21,NULL,'published',2,NULL,0,'2026-05-28 18:59:11','2026-05-28 18:59:11',NULL,NULL),(25,'Nursery Decor',NULL,21,NULL,'published',3,NULL,0,'2026-05-28 18:59:11','2026-05-28 18:59:11',NULL,NULL);

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

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

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

INSERT INTO `ec_product_categories_translations` VALUES ('ar',1,'معدات التغذية',NULL,'تم تصميم الزجاجات والمرايل وغيرها من مستلزمات التغذية لجعل أوقات الوجبات آمنة وسهلة.'),('ar',2,'الزجاجات والحلمات',NULL,''),('ar',3,'المرايل وملابس التجشؤ',NULL,''),('ar',4,'اللهايات واللهايات',NULL,''),('ar',5,'مجموعات وأدوات التغذية',NULL,''),('ar',6,'ملابس اطفال',NULL,'ملابس داخلية وأحذية وملابس يومية مصنوعة من القطن الناعم لبشرة طفلك الرقيقة.'),('ar',7,'ملابس داخلية وملابس داخلية',NULL,''),('ar',8,'الجوارب والجوارب',NULL,''),('ar',9,'القبعات والقفازات',NULL,''),('ar',10,'ملابس نوم',NULL,''),('ar',11,'وقت اللعب',NULL,'عضاضات خشبية وحيوانات محشوة وأصدقاء ألعاب لطيفة للنمو المبكر.'),('ar',12,'التسنين',NULL,''),('ar',13,'ألعاب قطيفة',NULL,''),('ar',14,'صالات رياضية للأنشطة',NULL,''),('ar',15,'ألعاب خشبية',NULL,''),('ar',16,'العناية بالحمام',NULL,'تساعد المناشف ذات القلنسوة والغسول وأدوات الاستحمام الأساسية في الحفاظ على بشرة الطفل ناعمة ولطيفة.'),('ar',17,'مناشف مقنعين',NULL,''),('ar',18,'المستحضرات والزيوت',NULL,''),('ar',19,'أحواض الاستحمام والمقاعد',NULL,''),('ar',20,'المناشف والإسفنج',NULL,''),('ar',21,'غرفة الطفل',NULL,'توفر أسرة الأطفال والشماعات وأكياس النوم وغيرها من مستلزمات غرفة الطفل مساحة مريحة.'),('ar',22,'أسرة وأسرّة أطفال',NULL,''),('ar',23,'أكياس النوم',NULL,''),('ar',24,'الهواتف النقالة وأضواء الليل',NULL,''),('ar',25,'ديكور الحضانة',NULL,''),('fr',1,'Équipement d\'alimentation',NULL,'Les biberons, bavoirs et autres articles essentiels pour l\'alimentation sont conçus pour rendre les repas sûrs et faciles.'),('fr',2,'Biberons et tétines',NULL,''),('fr',3,'Bavoirs et torchons',NULL,''),('fr',4,'Sucettes et sucettes',NULL,''),('fr',5,'Ensembles d\'alimentation et ustensiles',NULL,''),('fr',6,'Vêtements pour bébé',NULL,'Body, chaussures et vêtements de tous les jours en coton doux pour la peau tendre de votre bébé.'),('fr',7,'Bodys et combinaisons',NULL,''),('fr',8,'Chaussons et chaussettes',NULL,''),('fr',9,'Chapeaux et mitaines',NULL,''),('fr',10,'Vêtement de nuit',NULL,''),('fr',11,'Temps de jeu',NULL,'Anneaux de dentition en bois, animaux en peluche et amis jouets doux pour le développement précoce.'),('fr',12,'Anneaux de dentition',NULL,''),('fr',13,'Jouets en peluche',NULL,''),('fr',14,'Salles d\'activités',NULL,''),('fr',15,'Jouets en bois',NULL,''),('fr',16,'Soins du bain',NULL,'Les serviettes à capuche, la lotion et les articles de bain essentiels aident à garder la peau de bébé douce et douce.'),('fr',17,'Serviettes à capuche',NULL,''),('fr',18,'Lotions & Oils',NULL,''),('fr',19,'Baignoires et sièges',NULL,''),('fr',20,'Débarbouillettes et éponges',NULL,''),('fr',21,'Chambre bébé',NULL,'Berceaux, cintres, gigoteuses et autres essentiels de la chambre de bébé créent un espace apaisant.'),('fr',22,'Berceaux et berceaux',NULL,''),('fr',23,'Sacs de couchage',NULL,''),('fr',24,'Mobiles et veilleuses',NULL,''),('fr',25,'Décor de chambre d\'enfant',NULL,''),('id',1,'Perlengkapan Makan',NULL,'Botol, celemek, dan perlengkapan makan lainnya dirancang untuk membuat waktu makan aman dan mudah.'),('id',2,'Botol & Dot',NULL,''),('id',3,'Kain Oto & Sendawa',NULL,''),('id',4,'Dot & Empeng',NULL,''),('id',5,'Set & Peralatan Makan',NULL,''),('id',6,'Pakaian Bayi',NULL,'Bodysuit, sepatu dan pakaian sehari-hari terbuat dari bahan katun lembut untuk kulit lembut bayi Anda.'),('id',7,'Bodysuit & Onesie',NULL,''),('id',8,'Sepatu Bot & Kaus Kaki',NULL,''),('id',9,'Topi & Sarung Tangan',NULL,''),('id',10,'Pakaian tidur',NULL,''),('id',11,'Waktu Bermain',NULL,'Teether kayu, boneka binatang, dan mainan teman yang lembut untuk pengembangan awal.'),('id',12,'Teether',NULL,''),('id',13,'Mainan Mewah',NULL,''),('id',14,'Pusat Aktivitas',NULL,''),('id',15,'Mainan Kayu',NULL,''),('id',16,'Perawatan Mandi',NULL,'Handuk bertudung, losion, dan perlengkapan mandi penting membantu menjaga kulit bayi tetap lembut dan lembut.'),('id',17,'Handuk Berkerudung',NULL,''),('id',18,'Lotion & Minyak',NULL,''),('id',19,'Bak Mandi & Kursi',NULL,''),('id',20,'Kain lap & Spons',NULL,''),('id',21,'Kamar Bayi',NULL,'Tempat tidur bayi, gantungan baju, kantong tidur, dan perlengkapan kamar bayi lainnya menciptakan ruangan yang menenangkan.'),('id',22,'Tempat Tidur Bayi & Bassinets',NULL,''),('id',23,'Kantong Tidur',NULL,''),('id',24,'Ponsel & Lampu Malam',NULL,''),('id',25,'Dekorasi Kamar Anak',NULL,''),('tr',1,'Besleme Dişlisi',NULL,'Biberonlar, önlükler ve diğer beslenme malzemeleri yemek zamanlarını güvenli ve kolay hale getirmek için tasarlanmıştır.'),('tr',2,'Şişeler ve Emzikler',NULL,''),('tr',3,'Önlükler ve Geğirme Bezleri',NULL,''),('tr',4,'Emzikler ve Emzikler',NULL,''),('tr',5,'Besleme Setleri ve Gereçleri',NULL,''),('tr',6,'Bebek Giyim',NULL,'Bebeğinizin hassas cildine uygun, yumuşak pamuklu tulum, ayakkabı ve günlük kıyafetler.'),('tr',7,'Bodysuits ve Onesies',NULL,''),('tr',8,'Patik ve Çorap',NULL,''),('tr',9,'Şapkalar ve Eldivenler',NULL,''),('tr',10,'pijama',NULL,''),('tr',11,'Oyun Zamanı',NULL,'Erken gelişim için ahşap dişlikler, doldurulmuş hayvanlar ve yumuşak oyuncak arkadaşlar.'),('tr',12,'Diş kaşıyıcılar',NULL,''),('tr',13,'Peluş Oyuncaklar',NULL,''),('tr',14,'Aktivite Spor Salonları',NULL,''),('tr',15,'Ahşap Oyuncaklar',NULL,''),('tr',16,'Banyo Bakımı',NULL,'Kapüşonlu havlular, losyon ve temel banyo malzemeleri bebeğin cildinin yumuşak ve yumuşak kalmasına yardımcı olur.'),('tr',17,'Kapşonlu Havlular',NULL,''),('tr',18,'Losyonlar ve Yağlar',NULL,''),('tr',19,'Banyo Küvetleri ve Koltuklar',NULL,''),('tr',20,'Keseler ve Süngerler',NULL,''),('tr',21,'Bebek Odası',NULL,'Beşikler, askılar, uyku tulumları ve diğer bebek odası malzemeleri rahatlatıcı bir alan yaratır.'),('tr',22,'Beşikler ve Beşikler',NULL,''),('tr',23,'Sleeping Bags',NULL,''),('tr',24,'Cep Telefonları ve Gece Işıkları',NULL,''),('tr',25,'Kreş Dekoru',NULL,''),('vi',1,'Dụng Cụ Cho Bé Ăn',NULL,'Bình sữa, yếm và những vật dụng thiết yếu khi cho bé ăn được thiết kế để bữa ăn an toàn và dễ dàng.'),('vi',2,'Bình Sữa & Núm Ti',NULL,''),('vi',3,'Yếm & Khăn Ợ Sữa',NULL,''),('vi',4,'Ti Giả & Đồ Trấn An',NULL,''),('vi',5,'Bộ Đồ Ăn & Dụng Cụ',NULL,''),('vi',6,'Trang Phục Cho Bé',NULL,'Bodysuit, giày và trang phục hằng ngày bằng cotton mềm mại cho làn da non nớt của bé.'),('vi',7,'Bodysuit & Áo Liền Quần',NULL,''),('vi',8,'Giày & Tất',NULL,''),('vi',9,'Mũ & Bao Tay',NULL,''),('vi',10,'Đồ Ngủ',NULL,''),('vi',11,'Giờ Vui Chơi',NULL,'Vòng ngậm nướu bằng gỗ, thú bông và những người bạn đồ chơi nhẹ nhàng cho sự phát triển sớm.'),('vi',12,'Vòng Ngậm Nướu',NULL,''),('vi',13,'Thú Bông',NULL,''),('vi',14,'Thảm Chơi Vận Động',NULL,''),('vi',15,'Đồ Chơi Gỗ',NULL,''),('vi',16,'Chăm Sóc Khi Tắm',NULL,'Khăn tắm có mũ, lotion và những vật dụng thiết yếu khi tắm giúp da bé mềm mại và dịu nhẹ.'),('vi',17,'Khăn Tắm Có Mũ',NULL,''),('vi',18,'Lotion & Dầu',NULL,''),('vi',19,'Chậu & Ghế Tắm',NULL,''),('vi',20,'Khăn Lau & Bọt Biển',NULL,''),('vi',21,'Phòng Của Bé',NULL,'Nôi, đồ treo, túi ngủ và những vật dụng thiết yếu cho phòng bé tạo nên không gian êm dịu.'),('vi',22,'Cũi & Nôi',NULL,''),('vi',23,'Túi Ngủ',NULL,''),('vi',24,'Đồ Treo & Đèn Ngủ',NULL,''),('vi',25,'Trang Trí Phòng Bé',NULL,'');

--
-- 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,7),(2,1),(2,2),(2,5),(2,6),(3,10),(4,1),(4,4),(4,8),(6,1),(6,3),(6,10),(7,9),(10,5),(10,9),(11,2),(11,6),(12,8),(13,6),(13,7),(14,3),(14,7),(14,8),(15,2),(15,5),(15,7),(15,9),(16,4),(17,9),(18,1),(18,10),(19,4),(20,2),(20,6),(21,8),(22,3),(23,5),(24,3),(24,10),(25,4);

--
-- Table structure for table `ec_product_collection_products`
--

CREATE TABLE `ec_product_collection_products` (
  `product_collection_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`product_id`,`product_collection_id`),
  KEY `ec_product_collection_products_product_collection_id_index` (`product_collection_id`),
  KEY `ec_product_collection_products_product_id_index` (`product_id`),
  KEY `idx_product_id_collection_id` (`product_id`,`product_collection_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_collection_products`
--

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

--
-- 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,'Spring Essentials','spring-essentials','Lightweight layers, fluid silhouettes, and the colors driving this seasons mood boards.','collection/cls-1.jpg','published','2026-05-28 18:59:07','2026-05-28 18:59:07',1),(2,'Limited Edition','limited-edition','One-time runs from independent makers. Once they sell through, they are gone.','collection/cls-10.jpg','published','2026-05-28 18:59:08','2026-05-28 18:59:08',1),(3,'Best Sellers','best-sellers','The pieces our customers reorder season after season.','collection/cls-11.jpg','published','2026-05-28 18:59:08','2026-05-28 18:59:08',1),(4,'Sustainable Picks','sustainable-picks','Products with a verified sustainability story — recycled materials, low-impact dyes, or fair-wage manufacturing.','collection/cls-12.jpg','published','2026-05-28 18:59:08','2026-05-28 18:59:08',1),(5,'Workwear','workwear','Tailored basics ready for the office, the studio, and everything in between.','collection/cls-1.jpg','published','2026-05-28 18:59:08','2026-05-28 18:59:08',0),(6,'Weekend','weekend','Off-duty essentials that elevate the simplest jeans-and-tee uniform.','collection/cls-10.jpg','published','2026-05-28 18:59:08','2026-05-28 18:59:08',0),(7,'Shop Women','shop-women','Curated wardrobes for every season — dresses, layering pieces, and weekend staples.','collection/cls-6.jpg','published','2026-05-28 18:59:08','2026-05-28 18:59:08',0),(8,'Shop Men','shop-men','Tailored essentials and modern basics — built to last beyond the trend cycle.','collection/cls-7.jpg','published','2026-05-28 18:59:08','2026-05-28 18:59:08',0),(9,'Shop Essentials','shop-essentials','The everyday pieces our customers reorder — denim, knits, and timeless outerwear.','collection/cls-8.jpg','published','2026-05-28 18:59:08','2026-05-28 18:59:08',0);

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

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

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

INSERT INTO `ec_product_collections_translations` VALUES ('ar',1,'أساسيات الربيع','الملابس الخفيفة والفضفاضة والألوان الزاهية هي التي تتصدر المزاج العام هذا الموسم.'),('ar',2,'طبعة محدودة','الشحنات الوحيدة من الشركات المصنعة المستقلة. إذا تم بيعه، فقد ذهب.'),('ar',3,'أفضل البائعين','المنتجات التي يثق بها العملاء ويعيدون طلبها في كل موسم.'),('ar',4,'اللقطات المستدامة','منتجات ذات قصص استدامة مثبتة - مواد معاد تدويرها، أو أصباغ منخفضة التأثير، أو مصنوعة بأجور عادلة.'),('ar',5,'ملابس العمل','الأساسيات المتطورة جاهزة للمكتب والاستوديو وفي كل مكان بينهما.'),('ar',6,'عطلة نهاية الأسبوع','تعمل الأساسيات خارج أوقات العمل على رفع مستوى أبسط أطقم الجينز والقمصان.'),('ar',7,'تسوق النساء','خزانة ملابس منسقة لكل موسم - الفساتين والطبقات وأساسيات عطلة نهاية الأسبوع.'),('ar',8,'تسوق الرجال','أساسيات متطورة وأساسيات حديثة - تدوم إلى ما بعد دورات الموضة.'),('ar',9,'تسوق الأساسيات','يعيد العملاء طلب القطع اليومية - الدنيم والحياكة والمعاطف الخالدة.'),('fr',1,'Les essentiels du printemps','Des tenues légères, des coupes amples et des couleurs vives sont en tête du mood board cette saison.'),('fr',2,'Édition limitée','Expéditions exclusives de fabricants indépendants. S\'il est épuisé, il est parti.'),('fr',3,'Meilleures ventes','Des produits auxquels les clients font confiance et qui les commandent chaque saison.'),('fr',4,'Choix durables','Des produits avec des histoires de durabilité éprouvées : matériaux recyclés, colorants à faible impact ou fabriqués avec des salaires équitables.'),('fr',5,'Vêtements de travail','Les basiques sophistiqués sont prêts pour le bureau, le studio et partout ailleurs.'),('fr',6,'Fin de semaine','Les essentiels décontractés rehaussent les ensembles jeans et t-shirts les plus simples.'),('fr',7,'Magasinez les femmes','Une garde-robe organisée pour chaque saison : robes, superpositions et essentiels du week-end.'),('fr',8,'Acheter des hommes','Des essentiels sophistiqués et des basiques modernes – qui durent au-delà des cycles de la mode.'),('fr',9,'Achetez les essentiels','Les clients commandent des pièces du quotidien : jeans, tricots et manteaux intemporels.'),('id',1,'Hal Penting Musim Semi','Pakaian ringan, pakaian longgar, dan warna-warna cerah memimpin mood board musim ini.'),('id',2,'Edisi Terbatas','Pengiriman tunggal dari produsen independen. Kalau sudah terjual habis.'),('id',3,'Terlaris','Produk yang dipercaya dan dipesan ulang oleh pelanggan setiap musim.'),('id',4,'Pilihan Berkelanjutan','Produk dengan kisah keberlanjutan yang terbukti — bahan daur ulang, pewarna berdampak rendah, atau dibuat dengan upah yang wajar.'),('id',5,'Pakaian kerja','Perlengkapan dasar yang canggih siap digunakan di kantor, studio, dan di mana pun di antaranya.'),('id',6,'Akhir pekan','Barang-barang penting di luar tugas menonjolkan set jeans dan T-shirt paling sederhana.'),('id',7,'Belanja Wanita','Lemari pakaian pilihan untuk setiap musim — gaun, pakaian berlapis, dan kebutuhan akhir pekan.'),('id',8,'Toko Pria','Hal-hal penting yang canggih dan dasar-dasar modern — bertahan melampaui siklus mode.'),('id',9,'Belanja Penting','Barang sehari-hari yang dipesan ulang oleh pelanggan — denim, rajutan, dan mantel yang tak lekang oleh waktu.'),('tr',1,'Baharın Temelleri','Hafif kıyafetler, bol kesimler ve parlak renkler bu sezon mood board\'un başını çekiyor.'),('tr',2,'Sınırlı sayıda','Bağımsız üreticilerden tek gönderi. Eğer tükendiyse, gitmiştir.'),('tr',3,'En Çok Satanlar','Müşterilerin güvendiği ve her sezon yeniden sipariş ettiği ürünler.'),('tr',4,'Sürdürülebilir Seçimler','Kanıtlanmış sürdürülebilirlik öykülerine sahip ürünler: geri dönüştürülmüş malzemeler, düşük etkili boyalar veya adil ücretlerle üretilen ürünler.'),('tr',5,'İş kıyafeti','Ofis, stüdyo ve aradaki her yer için gelişmiş temel öğeler hazır.'),('tr',6,'Hafta sonu','İş dışında giyilen malzemeler, en basit kot pantolon ve tişört takımlarını öne çıkarıyor.'),('tr',7,'Kadın Alışverişi','Her mevsime uygun seçilmiş bir gardırop; elbiseler, üst üste binmeler ve hafta sonu vazgeçilmezleri.'),('tr',8,'Erkek Alışverişi','Moda döngülerinin ötesinde kalıcı, sofistike temeller ve modern temeller.'),('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,'Thiết yếu mùa Xuân','Lớp trang phục nhẹ, phom rộng rãi và những gam màu đang dẫn dắt mood board mùa này.'),('vi',2,'Phiên bản giới hạn','Những lô hàng duy nhất từ các nhà sản xuất độc lập. Bán hết là không còn nữa.'),('vi',3,'Bán chạy nhất','Những sản phẩm được khách hàng tin dùng và đặt lại qua từng mùa.'),('vi',4,'Lựa chọn bền vững','Sản phẩm có câu chuyện bền vững được kiểm chứng — vật liệu tái chế, thuốc nhuộm ít tác động hoặc sản xuất với mức lương công bằng.'),('vi',5,'Trang phục công sở','Đồ cơ bản tinh tế sẵn sàng cho văn phòng, studio và mọi nơi khác.'),('vi',6,'Cuối tuần','Đồ off-duty thiết yếu nâng tầm những bộ jeans-và-áo thun đơn giản nhất.'),('vi',7,'Mua đồ Nữ','Tủ đồ tuyển chọn cho mọi mùa — đầm, đồ layering và đồ thiết yếu cuối tuần.'),('vi',8,'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',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,5,0,0.00,'fixed',1),(1,7,0,0.00,'fixed',1),(1,8,0,0.00,'fixed',1),(1,9,0,0.00,'fixed',1),(1,10,0,0.00,'fixed',1),(2,3,0,0.00,'fixed',1),(2,4,0,0.00,'fixed',1),(2,6,0,0.00,'fixed',1),(2,7,0,0.00,'fixed',1),(2,8,0,0.00,'fixed',1),(2,10,0,0.00,'fixed',1),(3,4,0,0.00,'fixed',1),(3,5,0,0.00,'fixed',1),(3,6,0,0.00,'fixed',1),(3,8,0,0.00,'fixed',1),(3,9,0,0.00,'fixed',1),(3,10,0,0.00,'fixed',1),(4,3,0,0.00,'fixed',1),(4,5,0,0.00,'fixed',1),(4,7,0,0.00,'fixed',1),(4,8,0,0.00,'fixed',1),(4,9,0,0.00,'fixed',1),(4,10,0,0.00,'fixed',1),(5,4,0,0.00,'fixed',1),(5,6,0,0.00,'fixed',1),(5,9,0,0.00,'fixed',1),(5,10,0,0.00,'fixed',1),(6,2,0,0.00,'fixed',1),(6,4,0,0.00,'fixed',1),(6,5,0,0.00,'fixed',1),(6,7,0,0.00,'fixed',1),(6,8,0,0.00,'fixed',1),(6,9,0,0.00,'fixed',1),(7,3,0,0.00,'fixed',1),(7,6,0,0.00,'fixed',1),(7,8,0,0.00,'fixed',1),(7,10,0,0.00,'fixed',1),(8,4,0,0.00,'fixed',1),(8,6,0,0.00,'fixed',1),(8,7,0,0.00,'fixed',1),(8,9,0,0.00,'fixed',1),(9,1,0,0.00,'fixed',1),(9,2,0,0.00,'fixed',1),(9,3,0,0.00,'fixed',1),(9,4,0,0.00,'fixed',1),(9,7,0,0.00,'fixed',1),(10,2,0,0.00,'fixed',1),(10,3,0,0.00,'fixed',1),(10,5,0,0.00,'fixed',1),(10,6,0,0.00,'fixed',1),(10,7,0,0.00,'fixed',1),(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 (4,9),(6,3),(6,6);

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Table structure for table `ec_product_up_sale_relations`
--

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

--
-- Dumping data for table `ec_product_up_sale_relations`
--

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

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

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

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

INSERT INTO `ec_product_variation_items` VALUES (5,21,5),(6,21,6),(7,21,7),(3,22,3),(2,23,2),(1,24,1),(4,24,4);

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

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

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

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

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

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


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

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

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

INSERT INTO `ec_product_with_attribute_set` VALUES (3,6,0),(3,8,0),(3,9,0);

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

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

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

INSERT INTO `ec_products` VALUES (1,'Merino Wool Knit Booties with Drawstring – Snug Comfort for Newborns','merino-wool-knit-booties-with-drawstring-snug-comfort-for-newborns','Soft merino wool booties that keep tiny feet warm without overheating.','<p>Naturally breathable merino lining with elasticated cuffs. Machine washable on a gentle cycle. Sizes 0-12 months.</p>','published','[\"products\\/baby\\/product-1.jpg\"]',NULL,'FU-147',0,13,0,1,'in_stock',1,NULL,3,0,0,10,4.00,0,39.99,29.99,NULL,NULL,13,19,18,553,NULL,'standard',3233,'2026-05-28 18:59:13','2026-05-28 18:59:20',1,0,'Botble\\ACL\\Models\\User',0,'products/baby/product-1.jpg','physical','6455319259474',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(2,'Soft Cotton Dribble Bibs 3 Pack – Gentle Protection for Little Messes','soft-cotton-dribble-bibs-3-pack-gentle-protection-for-little-messes','Three-pack of organic cotton dribble bibs with adjustable nickel-free snaps.','<p>Triple-layered absorbent core with a waterproof inner barrier. OEKO-TEX certified prints. Fits 3-24 months.</p>','published','[\"products\\/baby\\/product-2.jpg\"]',NULL,'YX-122',0,14,0,1,'in_stock',0,NULL,4,0,0,10,2.40,0,34.99,24.99,NULL,NULL,11,16,17,874,NULL,'standard',171272,'2026-05-28 18:59:13','2026-05-28 18:59:20',2,0,'Botble\\ACL\\Models\\User',0,'products/baby/product-2.jpg','physical','7633896789211',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(3,'Cozy Bunny Hooded Towel for Newborns and Toddlers','cozy-bunny-hooded-towel-for-newborns-and-toddlers','Plush bamboo-cotton hooded towel that keeps baby cozy after every bath.','<p>500gsm bamboo-cotton terry. Generous 90x90cm size. Soft hood with embroidered ear detail. Hypoallergenic and chlorine-free.</p>','published','[\"products\\/baby\\/product-3.jpg\"]',NULL,'J8-127',0,15,0,1,'in_stock',0,NULL,10,0,0,10,2.20,0,49.99,39.99,NULL,NULL,11,18,14,554,NULL,'standard',117215,'2026-05-28 18:59:13','2026-05-28 18:59:20',3,0,'Botble\\ACL\\Models\\User',0,'products/baby/product-3.jpg','physical','7631065497127',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(4,'MUSHIE Frigg Baby\'s First Pacifier Floral Heart | Kido Bebe','mushie-frigg-babys-first-pacifier-floral-heart-kido-bebe','One-piece medical-grade silicone pacifier shaped to support natural latch.','<p>BPA, BPS, PVC, and phthalate-free. Symmetrical orthodontic shape. Boil-sterilizable and dishwasher safe.</p>','published','[\"products\\/baby\\/product-4.jpg\"]',NULL,'VY-167',0,12,0,1,'in_stock',1,NULL,5,0,0,10,2.90,0,19.99,14.99,NULL,NULL,14,10,11,852,NULL,'standard',52649,'2026-05-28 18:59:14','2026-05-28 18:59:20',4,0,'Botble\\ACL\\Models\\User',0,'products/baby/product-4.jpg','physical','8998950525723',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(5,'Baby Glass Bottle Set 4oz with Latex Nipple – Blush Pink for Little Moments','baby-glass-bottle-set-4oz-with-latex-nipple-blush-pink-for-little-moments','Twin-pack borosilicate glass bottles with anti-colic silicone teats.','<p>Heat-shock resistant glass with a soft silicone sleeve. Wide-neck design for easy cleaning. 240ml capacity.</p>','published','[\"products\\/baby\\/product-5.jpg\"]',NULL,'RB-115',0,15,0,1,'in_stock',1,NULL,11,0,0,10,3.00,0,59.99,49.99,NULL,NULL,17,17,15,631,NULL,'standard',39839,'2026-05-28 18:59:14','2026-05-28 18:59:20',1,0,'Botble\\ACL\\Models\\User',0,'products/baby/product-5.jpg','physical','8399326682604',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(6,'Silicone Fork and Spoon Set – Perfect for Self-Feeding Babies','silicone-fork-and-spoon-set-perfect-for-self-feeding-babies','Organic cotton sleeping bag with TOG 2.5 rating for cooler nights.','<p>GOTS-certified outer with hypoallergenic fill. Two-way zip for easy nappy changes. Sizes 0-6, 6-18, and 18-36 months.</p>','published','[\"products\\/baby\\/product-6.jpg\"]',NULL,'WM-198-A1',0,14,0,1,'in_stock',0,NULL,3,0,2,10,2.20,0,89.99,69.99,NULL,NULL,10,10,18,701,NULL,'standard',58088,'2026-05-28 18:59:14','2026-05-28 18:59:20',2,0,'Botble\\ACL\\Models\\User',0,'products/baby/product-6.jpg','physical','0968122168100',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(7,'Teal Blue 5 Pack Baby Bodysuits – 100% Cotton for Everyday Comfort','teal-blue-5-pack-baby-bodysuits-100-cotton-for-everyday-comfort','GOTS-certified organic cotton onesie with envelope shoulders for easy dressing.','<p>Soft single-jersey knit. Nickel-free press studs. Machine washable. Available in newborn through 18 months.</p>','published','[\"products\\/baby\\/product-7.jpg\"]',NULL,'DD-160',0,19,0,1,'in_stock',1,NULL,8,0,0,10,3.10,0,22.99,16.99,NULL,NULL,19,17,15,680,NULL,'standard',107431,'2026-05-28 18:59:14','2026-05-28 18:59:20',3,0,'Botble\\ACL\\Models\\User',0,'products/baby/product-7.jpg','physical','5699635391857',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(8,'White Delicate Double Pom Baby Hat – Soft &amp; Cozy Warmth for Little Heads','white-delicate-double-pom-baby-hat-soft-cozy-warmth-for-little-heads','Beech wood teether finished with food-grade beeswax, sized for tiny hands.','<p>Sustainably harvested European beech. Naturally antibacterial. Pair with a silicone clip to keep it close to baby.</p>','published','[\"products\\/baby\\/product-8.jpg\"]',NULL,'AT-117-A1',0,13,0,1,'in_stock',0,NULL,11,0,3,10,2.50,0,19.99,14.99,NULL,NULL,12,10,14,817,NULL,'standard',107145,'2026-05-28 18:59:14','2026-05-28 18:59:20',4,0,'Botble\\ACL\\Models\\User',0,'products/baby/product-8.jpg','physical','1715564388547',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(9,'Frigg Moon Natural Rubber Baby Pacifier Gentle Comfort','frigg-moon-natural-rubber-baby-pacifier-gentle-comfort','Fragrance-free lotion with oat extract and shea butter for sensitive baby skin.','<p>Dermatologist-tested. No parabens, sulphates, or synthetic fragrance. 200ml pump bottle.</p>','published','[\"products\\/baby\\/product-9.jpg\"]',NULL,'RA-147-A1',0,15,0,1,'in_stock',0,NULL,4,0,2,10,3.20,0,24.99,18.99,NULL,NULL,18,13,17,854,NULL,'standard',20689,'2026-05-28 18:59:14','2026-05-28 18:59:20',1,0,'Botble\\ACL\\Models\\User',0,'products/baby/product-9.jpg','physical','2634367481158',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(10,'Little Dine Wooden High Chair Elegant Comfort for Tiny Foodies','little-dine-wooden-high-chair-elegant-comfort-for-tiny-foodies','Hand-knit organic cotton plush companion sized perfectly for little arms.','<p>Hypoallergenic recycled fill. Embroidered facial details — no small parts. Surface washable.</p>','published','[\"products\\/baby\\/product-10.jpg\"]',NULL,'7R-181',0,18,0,1,'in_stock',0,NULL,9,0,0,10,3.10,0,44.99,34.99,NULL,NULL,10,12,16,637,NULL,'standard',90749,'2026-05-28 18:59:14','2026-05-28 18:59:20',2,0,'Botble\\ACL\\Models\\User',0,'products/baby/product-10.jpg','physical','9893239434729',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(11,'Silicone Fork and Spoon Set – Perfect for Self-Feeding Babies',NULL,NULL,NULL,'published','[\"products\\/baby\\/product-6.jpg\"]',NULL,'WM-198-A1',0,14,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,89.99,NULL,NULL,NULL,10,10,18,701,NULL,'standard',0,'2026-05-28 18:59:14','2026-05-28 18:59:20',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','1184758826125',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(12,'Silicone Fork and Spoon Set – Perfect for Self-Feeding Babies',NULL,NULL,NULL,'published','[\"products\\/baby\\/product-6.jpg\"]',NULL,'WM-198-A1-A2',0,14,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,89.99,NULL,NULL,NULL,10,10,18,701,NULL,'standard',0,'2026-05-28 18:59:14','2026-05-28 18:59:20',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4870233000117',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(13,'White Delicate Double Pom Baby Hat – Soft & Cozy Warmth for Little Heads',NULL,NULL,NULL,'published','[\"products\\/baby\\/product-8.jpg\"]',NULL,'AT-117-A1',0,13,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,19.99,16.1919,NULL,NULL,12,10,14,817,NULL,'standard',0,'2026-05-28 18:59:14','2026-05-28 18:59:20',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','7375264313627',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(14,'White Delicate Double Pom Baby Hat – Soft & Cozy Warmth for Little Heads',NULL,NULL,NULL,'published','[\"products\\/baby\\/product-8.jpg\"]',NULL,'AT-117-A1-A2',0,13,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,19.99,17.5912,NULL,NULL,12,10,14,817,NULL,'standard',0,'2026-05-28 18:59:15','2026-05-28 18:59:20',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2305267260975',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(15,'White Delicate Double Pom Baby Hat – Soft & Cozy Warmth for Little Heads',NULL,NULL,NULL,'published','[\"products\\/baby\\/product-8.jpg\"]',NULL,'AT-117-A1-A3',0,13,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,19.99,14.1929,NULL,NULL,12,10,14,817,NULL,'standard',0,'2026-05-28 18:59:15','2026-05-28 18:59:20',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','0915702685496',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(16,'Frigg Moon Natural Rubber Baby Pacifier Gentle Comfort',NULL,NULL,NULL,'published','[\"products\\/baby\\/product-9.jpg\"]',NULL,'RA-147-A1',0,15,0,1,'in_stock',0,NULL,4,1,0,0,0.00,0,24.99,NULL,NULL,NULL,18,13,17,854,NULL,'standard',0,'2026-05-28 18:59:15','2026-05-28 18:59:20',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','7858713975718',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(17,'Frigg Moon Natural Rubber Baby Pacifier Gentle Comfort',NULL,NULL,NULL,'published','[\"products\\/baby\\/product-9.jpg\"]',NULL,'RA-147-A1-A2',0,15,0,1,'in_stock',0,NULL,4,1,0,0,0.00,0,24.99,NULL,NULL,NULL,18,13,17,854,NULL,'standard',0,'2026-05-28 18:59:15','2026-05-28 18:59:20',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4986962010782',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> بطانة صوف ميرينو طبيعية مسامية مع ياقة مرنة. يمكن غسله في الغسالة على دورة لطيفة. المقاسات 0-12 شهر.</p>'),('ar',2,'صدريات قطنية ناعمة مكونة من 3 قطع - حماية لطيفة من الفوضى الصغيرة',NULL,'مجموعة من ثلاث مرايل من القطن العضوي مع أزرار كبس قابلة للتعديل خالية من النيكل.','<p> قلب ماص من ثلاث طبقات مع بطانة داخلية مقاومة للماء. الأنماط معتمدة من OEKO-TEX. مناسب للأطفال من 3 إلى 24 شهرًا.</p>'),('ar',3,'منشفة مريحة بغطاء رأس على شكل أرنب لحديثي الولادة والأطفال الصغار',NULL,'تحتوي منشفة الحمام على غطاء ناعم من القطن والخيزران للحفاظ على دفء طفلك بعد كل حمام.','<p>500gsm منشفة من الخيزران القطني المختلط. مقاس واسع 90×90 سم. قبعة ناعمة مع تفاصيل أذن مطرزة. لا يسبب الحساسية وخالي من الكلور.</p>'),('ar',4,'لهاية الأطفال الأولى من موشي فريغ على شكل قلب زهري | كيدو بيبي',NULL,'اللهايات المصنوعة من السيليكون الطبي الصلب مصممة لدعم المزلاج الطبيعي.','<p>خالي من BPA وBPS وPVC والفثالات. شكل الأسنان متماثل. يمكن تعقيمها بالغليان وغسلها في غسالة الأطباق.</p>'),('ar',5,'مجموعة زجاجات الأطفال الزجاجية سعة 4 أونصة مع حلمة من اللاتكس - وردي فاتح للحظات صغيرة',NULL,'زجاجة أطفال ثنائية من زجاج البورسليكات مع حلمة سيليكون مضادة للمغص.','<p> زجاج حراري مقاوم للصدمات مع غلاف سيليكون ناعم. تصميم رقبة واسعة لسهولة التنظيف. السعة 240 مل.</p>'),('ar',6,'مجموعة شوكة وملعقة من السيليكون - مثالية للأطفال الذين يتناولون طعامهم ذاتيًا',NULL,'كيس نوم من القطن العضوي مع TOG 2.5 لليالي الباردة.','<p> الطبقة الخارجية معتمدة من GOTS مع بطانة داخلية مضادة للحساسية. سحاب ثنائي الاتجاه يجعل تغيير الحفاضات سهلاً. المقاسات 0-6، 6-18، 18-36 شهر.</p>'),('ar',7,'طقم من 5 ملابس داخلية للأطفال باللون الأزرق المخضر - 100% قطن لراحة يومية',NULL,'بدلة للجسم من القطن العضوي المعتمد من GOTS مع أكتاف مغلف لسهولة الارتداء.','<p>قماش ناعم ومتماسك. الأزرار خالية من النيكل. يمكن غسله في الغسالة. متوفر من مقاسات حديثي الولادة حتى 18 شهرًا.</p>'),('ar',8,'White Delicate Double Pom Baby Hat – Soft &amp; Cozy Warmth for Little Heads',NULL,'Beech wood teether finished with food-grade beeswax, sized for tiny hands.','<p>Sustainably harvested European beech. Naturally antibacterial. Pair with a silicone clip to keep it close to baby.</p>'),('ar',9,'لهاية أطفال من المطاط الطبيعي من فريج مون، مريحة ولطيفة',NULL,'لوشن خالي من العطور بخلاصة الشوفان وزبدة الشيا لبشرة الطفل الحساسة.','<p> تم اختباره من قبل أطباء الجلدية. لا يحتوي على بارابين أو كبريتات أو عطور صناعية. زجاجة مضخة 200 مل.</p>'),('ar',10,'كرسي مرتفع خشبي من Little Dine مريح وأنيق لمحبي الطعام الصغار',NULL,'حيوان محشو بالقطن العضوي محبوك يدويًا بحجم مثالي للأذرع الصغيرة.','<p>أمعاء معاد تدويرها مضادة للحساسية. تفاصيل وجه مطرزة - بدون تفاصيل صغيرة. يمكن مسح السطح.</p>'),('ar',11,'مجموعة شوكة وملعقة من السيليكون - مثالية للأطفال الذين يتناولون طعامهم ذاتيًا',NULL,'كيس نوم من القطن العضوي مع TOG 2.5 لليالي الباردة.','<p> الطبقة الخارجية معتمدة من GOTS مع بطانة داخلية مضادة للحساسية. سحاب ثنائي الاتجاه يجعل تغيير الحفاضات سهلاً. المقاسات 0-6، 6-18، 18-36 شهر.</p>'),('ar',12,'مجموعة شوكة وملعقة من السيليكون - مثالية للأطفال الذين يتناولون طعامهم ذاتيًا',NULL,'كيس نوم من القطن العضوي مع TOG 2.5 لليالي الباردة.','<p> الطبقة الخارجية معتمدة من GOTS مع بطانة داخلية مضادة للحساسية. سحاب ثنائي الاتجاه يجعل تغيير الحفاضات سهلاً. المقاسات 0-6، 6-18، 18-36 شهر.</p>'),('ar',13,'قبعة أطفال بيضاء رقيقة مزدوجة بوم - دفء ناعم ومريح للرؤوس الصغيرة',NULL,'حلقة العلكة مصنوعة من خشب البلوط، مع لمسة نهائية من شمع العسل الصالح للطعام، وتناسب الأيدي الصغيرة.','<p> بلوط أوروبي يتم حصاده بشكل مستدام. مضاد طبيعي للجراثيم. مدمج مع مشبك سيليكون لإبقاء الحلقة قريبة من طفلك.</p>'),('ar',14,'قبعة أطفال بيضاء رقيقة مزدوجة بوم - دفء ناعم ومريح للرؤوس الصغيرة',NULL,'حلقة العلكة مصنوعة من خشب البلوط، مع لمسة نهائية من شمع العسل الصالح للطعام، وتناسب الأيدي الصغيرة.','<p> بلوط أوروبي يتم حصاده بشكل مستدام. مضاد طبيعي للجراثيم. مدمج مع مشبك سيليكون لإبقاء الحلقة قريبة من طفلك.</p>'),('ar',15,'قبعة أطفال بيضاء رقيقة مزدوجة بوم - دفء ناعم ومريح للرؤوس الصغيرة',NULL,'حلقة العلكة مصنوعة من خشب البلوط، مع لمسة نهائية من شمع العسل الصالح للطعام، وتناسب الأيدي الصغيرة.','<p> بلوط أوروبي يتم حصاده بشكل مستدام. مضاد طبيعي للجراثيم. مدمج مع مشبك سيليكون لإبقاء الحلقة قريبة من طفلك.</p>'),('ar',16,'لهاية أطفال من المطاط الطبيعي من فريج مون، مريحة ولطيفة',NULL,'لوشن خالي من العطور بخلاصة الشوفان وزبدة الشيا لبشرة الطفل الحساسة.','<p> تم اختباره من قبل أطباء الجلدية. لا يحتوي على بارابين أو كبريتات أو عطور صناعية. زجاجة مضخة 200 مل.</p>'),('ar',17,'لهاية أطفال من المطاط الطبيعي من فريج مون، مريحة ولطيفة',NULL,'لوشن خالي من العطور بخلاصة الشوفان وزبدة الشيا لبشرة الطفل الحساسة.','<p> تم اختباره من قبل أطباء الجلدية. لا يحتوي على بارابين أو كبريتات أو عطور صناعية. زجاجة مضخة 200 مل.</p>'),('fr',1,'Chaussons tricotés en laine mérinos avec cordon de serrage – Confort douillet pour les nouveau-nés',NULL,'Les chaussures douces en laine mérinos gardent les petits pieds au chaud sans provoquer de chaleur.','<p>Doublure en laine mérinos naturelle respirante avec col élastique. Lavable en machine sur cycle délicat. Tailles 0-12 mois.</p>'),('fr',2,'Lot de 3 bavoirs en coton doux – Protection douce pour les petits dégâts',NULL,'Lot de trois bavoirs en coton bio avec boutons pression réglables sans nickel.','<p>Noyau absorbant à trois couches avec doublure intérieure imperméable. Les motifs sont certifiés OEKO-TEX. Convient pour 3-24 mois.</p>'),('fr',3,'Serviette à capuche Cozy Bunny pour nouveau-nés et tout-petits',NULL,'La serviette de bain est dotée d\'une capuche douce en coton et bambou pour garder votre bébé au chaud après chaque bain.','<p>Serviette en bambou mélangé de coton 500 g/m². Dimensions spacieuses 90x90cm. Chapeau doux avec détails d\'oreilles brodés. Hypoallergénique et sans chlore.</p>'),('fr',4,'MUSHIE Frigg Première sucette cœur floral pour bébé | Kido Bébé',NULL,'Les sucettes solides en silicone de qualité médicale sont conçues pour soutenir une prise naturelle du sein.','<p>Sans BPA, BPS, PVC et phtalates. Forme dentaire symétrique. Peut être stérilisé par ébullition et lavé au lave-vaisselle.</p>'),('fr',5,'Ensemble de biberons en verre 4 oz avec tétine en latex – Rose blush pour les petits moments',NULL,'Duo de biberons en verre borosilicate avec tétine en silicone anti-colique.','<p>Verre résistant aux chocs thermiques avec coque en silicone souple. Conception à col large pour un nettoyage facile. Capacité 240 ml.</p>'),('fr',6,'Ensemble fourchette et cuillère en silicone – Parfait pour les bébés auto-alimentés',NULL,'Gigoteuse en coton biologique avec TOG 2,5 pour les nuits fraîches.','<p>La couche extérieure est certifiée GOTS avec un intérieur antiallergénique. La fermeture éclair bidirectionnelle facilite le changement des couches. Tailles 0-6, 6-18 et 18-36 mois.</p>'),('fr',7,'Lot de 5 bodys bébé bleu sarcelle – 100 % coton pour un confort au quotidien',NULL,'Body en coton biologique certifié GOTS avec épaules enveloppes pour un port facile.','<p>Tissu tricoté simple doux. Les boutons sont sans nickel. Lavable en machine. Disponible de la taille du nouveau-né au 18 mois.</p>'),('fr',8,'White Delicate Double Pom Baby Hat – Soft &amp; Cozy Warmth for Little Heads',NULL,'Beech wood teether finished with food-grade beeswax, sized for tiny hands.','<p>Sustainably harvested European beech. Naturally antibacterial. Pair with a silicone clip to keep it close to baby.</p>'),('fr',9,'Sucette pour bébé en caoutchouc naturel Frigg Moon Confort doux',NULL,'Lotion sans parfum à l\'extrait d\'avoine et au beurre de karité pour la peau sensible de bébé.','<p>Testé dermatologiquement. Ne contient pas de parabènes, de sulfates ou de parfums synthétiques. Flacon pompe 200ml.</p>'),('fr',10,'Chaise haute en bois Little Dine, confort élégant pour les petits gourmets',NULL,'Peluche en coton biologique tricotée à la main, parfaitement dimensionnée pour les petits bras.','<p>Intestin anti-allergique recyclé. Détail du visage brodé – pas de petits détails. La surface peut être essuyée.</p>'),('fr',11,'Ensemble fourchette et cuillère en silicone – Parfait pour les bébés auto-alimentés',NULL,'Gigoteuse en coton biologique avec TOG 2,5 pour les nuits fraîches.','<p>La couche extérieure est certifiée GOTS avec un intérieur antiallergénique. La fermeture éclair bidirectionnelle facilite le changement des couches. Tailles 0-6, 6-18 et 18-36 mois.</p>'),('fr',12,'Ensemble fourchette et cuillère en silicone – Parfait pour les bébés auto-alimentés',NULL,'Gigoteuse en coton biologique avec TOG 2,5 pour les nuits fraîches.','<p>La couche extérieure est certifiée GOTS avec un intérieur antiallergénique. La fermeture éclair bidirectionnelle facilite le changement des couches. Tailles 0-6, 6-18 et 18-36 mois.</p>'),('fr',13,'Bonnet bébé blanc délicat à double pompon – Chaleur douce et confortable pour les petites têtes',NULL,'L\'anneau de gomme est fait de bois de chêne, fini avec de la cire d\'abeille de qualité alimentaire, et s\'adapte aux petites mains.','<p>Chêne européen récolté de manière durable. Antibactérien naturel. Combiné avec un clip en silicone pour maintenir l\'anneau près de votre bébé.</p>'),('fr',14,'Bonnet bébé blanc délicat à double pompon – Chaleur douce et confortable pour les petites têtes',NULL,'L\'anneau de gomme est fait de bois de chêne, fini avec de la cire d\'abeille de qualité alimentaire, et s\'adapte aux petites mains.','<p>Chêne européen récolté de manière durable. Antibactérien naturel. Combiné avec un clip en silicone pour maintenir l\'anneau près de votre bébé.</p>'),('fr',15,'Bonnet bébé blanc délicat à double pompon – Chaleur douce et confortable pour les petites têtes',NULL,'L\'anneau de gomme est fait de bois de chêne, fini avec de la cire d\'abeille de qualité alimentaire, et s\'adapte aux petites mains.','<p>Chêne européen récolté de manière durable. Antibactérien naturel. Combiné avec un clip en silicone pour maintenir l\'anneau près de votre bébé.</p>'),('fr',16,'Sucette pour bébé en caoutchouc naturel Frigg Moon Confort doux',NULL,'Lotion sans parfum à l\'extrait d\'avoine et au beurre de karité pour la peau sensible de bébé.','<p>Testé dermatologiquement. Ne contient pas de parabènes, de sulfates ou de parfums synthétiques. Flacon pompe 200ml.</p>'),('fr',17,'Sucette pour bébé en caoutchouc naturel Frigg Moon Confort doux',NULL,'Lotion sans parfum à l\'extrait d\'avoine et au beurre de karité pour la peau sensible de bébé.','<p>Testé dermatologiquement. Ne contient pas de parabènes, de sulfates ou de parfums synthétiques. Flacon pompe 200ml.</p>'),('id',1,'Sepatu Bot Rajut Wol Merino dengan Tali – Kenyamanan Nyaman untuk Bayi Baru Lahir',NULL,'Sepatu berbahan wol merino yang lembut menjaga kaki si kecil tetap hangat tanpa menimbulkan rasa panas.','<p>Lapisan wol merino bernapas alami dengan kerah elastis. Bisa dicuci dengan mesin dengan siklus lembut. Ukuran 0-12 bulan.</p>'),('id',2,'Soft Cotton Dribble Bibs 3 Pack – Perlindungan Lembut untuk Kekacauan Kecil',NULL,'Set tiga oto air liur katun organik dengan kancing bebas nikel yang dapat disesuaikan.','<p>Inti penyerap tiga lapis dengan lapisan dalam tahan air. Polanya bersertifikat OEKO-TEX. Cocok untuk 3-24 bulan.</p>'),('id',3,'Handuk Berkerudung Kelinci yang Nyaman untuk Bayi Baru Lahir dan Balita',NULL,'Handuk mandinya dilengkapi tudung katun-bambu yang lembut untuk menjaga bayi Anda tetap hangat setiap habis mandi.','<p>500gsm handuk bambu campuran katun. Luas ukuran 90x90cm. Topi lembut dengan detail bordir telinga. Hypoallergenic dan bebas klorin.</p>'),('id',4,'Dot Bunga Pertama Bayi MUSHIE Frigg | Kido Bebe',NULL,'Dot silikon padat kelas medis dibentuk untuk mendukung pelekatan alami.','<p>Bebas BPA, BPS, PVC, dan ftalat. Bentuk gigi simetris. Dapat disterilkan dengan cara direbus dan dicuci di mesin pencuci piring.</p>'),('id',5,'Set Botol Kaca Bayi 4oz dengan Puting Lateks – Blush Pink untuk Momen Kecil',NULL,'Duo botol bayi berbahan kaca borosilikat dengan dot silikon anti kolik.','<p>Kaca tahan guncangan termal dengan cangkang silikon lembut. Desain leher lebar agar mudah dibersihkan. Kapasitas 240ml.</p>'),('id',6,'Set Garpu dan Sendok Silikon – Sempurna untuk Bayi yang Makan Sendiri',NULL,'Kantong tidur katun organik dengan TOG 2.5 untuk malam yang dingin.','<p>Lapisan luar bersertifikat GOTS dengan interior anti-alergi. Ritsleting dua arah memudahkan penggantian popok. Ukuran 0-6, 6-18 dan 18-36 bulan.</p>'),('id',7,'Bodysuit Bayi 5 Paket Biru Teal – 100% Katun untuk Kenyamanan Sehari-hari',NULL,'Bodysuit katun organik bersertifikat GOTS dengan bahu amplop agar mudah dipakai.','<p>Kain rajutan tunggal yang lembut. Tombol-tombolnya bebas nikel. Bisa dicuci dengan mesin. Tersedia dari ukuran bayi baru lahir hingga 18 bulan.</p>'),('id',8,'White Delicate Double Pom Baby Hat – Soft &amp; Cozy Warmth for Little Heads',NULL,'Beech wood teether finished with food-grade beeswax, sized for tiny hands.','<p>Sustainably harvested European beech. Naturally antibacterial. Pair with a silicone clip to keep it close to baby.</p>'),('id',9,'Dot Bayi Karet Alam Frigg Moon Kenyamanan Lembut',NULL,'Lotion bebas pewangi dengan ekstrak oat dan shea butter untuk kulit sensitif bayi.','<p>Teruji secara dermatologis. Tidak mengandung paraben, sulfat, atau pewangi sintetis. Botol pompa 200ml.</p>'),('id',10,'Kursi Tinggi Kayu Little Dine Kenyamanan Elegan untuk Pecinta Makanan Mungil',NULL,'Boneka binatang katun organik tenunan tangan berukuran sempurna untuk lengan kecil.','<p>Usus anti alergi daur ulang. Detail wajah yang dibordir — tidak ada detail kecil. Permukaannya bisa dilap.</p>'),('id',11,'Set Garpu dan Sendok Silikon – Sempurna untuk Bayi yang Makan Sendiri',NULL,'Kantong tidur katun organik dengan TOG 2.5 untuk malam yang dingin.','<p>Lapisan luar bersertifikat GOTS dengan interior anti-alergi. Ritsleting dua arah memudahkan penggantian popok. Ukuran 0-6, 6-18 dan 18-36 bulan.</p>'),('id',12,'Set Garpu dan Sendok Silikon – Sempurna untuk Bayi yang Makan Sendiri',NULL,'Kantong tidur katun organik dengan TOG 2.5 untuk malam yang dingin.','<p>Lapisan luar bersertifikat GOTS dengan interior anti-alergi. Ritsleting dua arah memudahkan penggantian popok. Ukuran 0-6, 6-18 dan 18-36 bulan.</p>'),('id',13,'Topi Bayi Pom Ganda Halus Putih – Kehangatan Lembut & Nyaman untuk Kepala Kecil',NULL,'Cincin permen karet terbuat dari kayu ek, diberi finishing lilin lebah food grade, dan pas untuk tangan si kecil.','<p>Ek Eropa yang dipanen secara lestari. Antibakteri alami. Dikombinasikan dengan klip silikon untuk menjaga cincin tetap dekat dengan bayi Anda.</p>'),('id',14,'Topi Bayi Pom Ganda Halus Putih – Kehangatan Lembut & Nyaman untuk Kepala Kecil',NULL,'Cincin permen karet terbuat dari kayu ek, diberi finishing lilin lebah food grade, dan pas untuk tangan si kecil.','<p>Ek Eropa yang dipanen secara lestari. Antibakteri alami. Dikombinasikan dengan klip silikon untuk menjaga cincin tetap dekat dengan bayi Anda.</p>'),('id',15,'Topi Bayi Pom Ganda Halus Putih – Kehangatan Lembut & Nyaman untuk Kepala Kecil',NULL,'Cincin permen karet terbuat dari kayu ek, diberi finishing lilin lebah food grade, dan pas untuk tangan si kecil.','<p>Ek Eropa yang dipanen secara lestari. Antibakteri alami. Dikombinasikan dengan klip silikon untuk menjaga cincin tetap dekat dengan bayi Anda.</p>'),('id',16,'Dot Bayi Karet Alam Frigg Moon Kenyamanan Lembut',NULL,'Lotion bebas pewangi dengan ekstrak oat dan shea butter untuk kulit sensitif bayi.','<p>Teruji secara dermatologis. Tidak mengandung paraben, sulfat, atau pewangi sintetis. Botol pompa 200ml.</p>'),('id',17,'Dot Bayi Karet Alam Frigg Moon Kenyamanan Lembut',NULL,'Lotion bebas pewangi dengan ekstrak oat dan shea butter untuk kulit sensitif bayi.','<p>Teruji secara dermatologis. Tidak mengandung paraben, sulfat, atau pewangi sintetis. Botol pompa 200ml.</p>'),('tr',1,'Merinos Yünü Büzgülü Örgü Patik – Yeni Doğanlar İçin Rahat Rahatlık',NULL,'Yumuşak merinos yünü ayakkabılar minik ayakları ısıya neden olmadan sıcak tutar.','<p>Elastik yakalı doğal nefes alabilen merinos yünü astar. Makinede hassas programda yıkanabilir. 0-12 ay arası bedenler.</p>'),('tr',2,'Yumuşak Pamuklu Dribble Önlükler 3\'lü Paket - Küçük Sorunlar için Nazik Koruma',NULL,'Ayarlanabilir nikel içermeyen çıtçıtlı, üç adet organik pamuklu salya önlüğü seti.','<p>Su geçirmez iç astarlı üç katmanlı emici çekirdek. Desenler OEKO-TEX sertifikalıdır. 3-24 ay arası uygundur.</p>'),('tr',3,'Yeni Doğanlar ve Küçük Çocuklar için Cosy Bunny Kapşonlu Havlu',NULL,'Banyo havlusu, bebeğinizi her banyodan sonra sıcak tutmak için yumuşak pamuklu bambu kapüşonludur.','<p>500gsm pamuk karışımlı bambu havlu. 90x90cm geniş ebatlıdır. İşlemeli kulak detaylı yumuşak şapka. Hipoalerjenik ve klor içermez.</p>'),('tr',4,'MUSHIE Frigg Bebeğin İlk Emziği Çiçekli Kalp | Kido Bebe',NULL,'Katı tıbbi sınıf silikon emzikler, doğal bir mandalı destekleyecek şekilde şekillendirilmiştir.','<p>BPA, BPS, PVC ve ftalat içermez. Simetrik diş şekli. Kaynatılarak sterilize edilebilir ve bulaşık makinesinde yıkanabilir.</p>'),('tr',5,'Bebek Cam Biberon Seti 4oz Lateks Emzikli – Küçük Anlar için Allık Pembe',NULL,'Antikolik silikon emzikli borosilikat cam biberon ikilisi.','<p>Yumuşak silikon kabuklu, termal şoklara dayanıklı cam. Kolay temizlik için geniş boyun tasarımı. Kapasite 240ml.</p>'),('tr',6,'Silikon Çatal ve Kaşık Seti – Kendi Kendine Beslenen Bebekler için Mükemmel',NULL,'Serin geceler için TOG 2,5\'lu organik pamuklu uyku tulumu.','<p>Dış katman GOTS sertifikalıdır ve anti-alerjik iç kısıma sahiptir. İki yönlü fermuar, bebek bezi değişikliklerini kolaylaştırır. 0-6, 6-18 ve 18-36 ay bedenleri.</p>'),('tr',7,'Teal Blue 5\'li Bebek Tulumu – Günlük Konfor için %100 Pamuk',NULL,'GOTS sertifikalı, organik pamuklu, omuzları kolay giyilebilen body.','<p>Yumuşak tek örgü kumaş. Düğmeler nikel içermez. Makinede yıkanabilir. Yenidoğandan 18 aya kadar bedenleri mevcuttur.</p>'),('tr',8,'White Delicate Double Pom Baby Hat – Soft &amp; Cozy Warmth for Little Heads',NULL,'Beech wood teether finished with food-grade beeswax, sized for tiny hands.','<p>Sustainably harvested European beech. Naturally antibacterial. Pair with a silicone clip to keep it close to baby.</p>'),('tr',9,'Frigg Moon Doğal Kauçuk Bebek Emziği Nazik Konfor',NULL,'Bebeğinizin hassas cildi için yulaf özü ve shea yağı içeren kokusuz losyon.','<p>Dermatolojik olarak test edilmiştir. Paraben, sülfat veya sentetik koku içermez. Pompalı şişe 200ml.</p>'),('tr',10,'Little Dine Ahşap Mama Sandalyesi Minik Yemek Meraklıları için Zarif Konfor',NULL,'Küçük kollar için mükemmel boyutta, el örgüsü organik pamuktan doldurulmuş hayvan.','<p>Geri dönüştürülmüş anti-alerjik bağırsak. İşlemeli yüz detayı — küçük detaylar yok. Yüzey silinebilir.</p>'),('tr',11,'Silikon Çatal ve Kaşık Seti – Kendi Kendine Beslenen Bebekler için Mükemmel',NULL,'Serin geceler için TOG 2,5\'lu organik pamuklu uyku tulumu.','<p>Dış katman GOTS sertifikalıdır ve anti-alerjik iç kısıma sahiptir. İki yönlü fermuar, bebek bezi değişikliklerini kolaylaştırır. 0-6, 6-18 ve 18-36 ay bedenleri.</p>'),('tr',12,'Silikon Çatal ve Kaşık Seti – Kendi Kendine Beslenen Bebekler için Mükemmel',NULL,'Serin geceler için TOG 2,5\'lu organik pamuklu uyku tulumu.','<p>Dış katman GOTS sertifikalıdır ve anti-alerjik iç kısıma sahiptir. İki yönlü fermuar, bebek bezi değişikliklerini kolaylaştırır. 0-6, 6-18 ve 18-36 ay bedenleri.</p>'),('tr',13,'Beyaz Narin Çift Pom Bebek Şapkası – Küçük Kafalar için Yumuşak ve Rahat Sıcaklık',NULL,'Sakız halkası meşe ağacından yapılmıştır, gıdaya uygun balmumu ile kaplanmıştır ve küçük ellere uygundur.','<p>Sürdürülebilir şekilde hasat edilmiş Avrupa meşesi. Doğal antibakteriyel. Yüzüğü bebeğinize yakın tutmak için silikon klipsle birleştirilmiştir.</p>'),('tr',14,'Beyaz Narin Çift Pom Bebek Şapkası – Küçük Kafalar için Yumuşak ve Rahat Sıcaklık',NULL,'Sakız halkası meşe ağacından yapılmıştır, gıdaya uygun balmumu ile kaplanmıştır ve küçük ellere uygundur.','<p>Sürdürülebilir şekilde hasat edilmiş Avrupa meşesi. Doğal antibakteriyel. Yüzüğü bebeğinize yakın tutmak için silikon klipsle birleştirilmiştir.</p>'),('tr',15,'Beyaz Narin Çift Pom Bebek Şapkası – Küçük Kafalar için Yumuşak ve Rahat Sıcaklık',NULL,'Sakız halkası meşe ağacından yapılmıştır, gıdaya uygun balmumu ile kaplanmıştır ve küçük ellere uygundur.','<p>Sürdürülebilir şekilde hasat edilmiş Avrupa meşesi. Doğal antibakteriyel. Yüzüğü bebeğinize yakın tutmak için silikon klipsle birleştirilmiştir.</p>'),('tr',16,'Frigg Moon Doğal Kauçuk Bebek Emziği Nazik Konfor',NULL,'Bebeğinizin hassas cildi için yulaf özü ve shea yağı içeren kokusuz losyon.','<p>Dermatolojik olarak test edilmiştir. Paraben, sülfat veya sentetik koku içermez. Pompalı şişe 200ml.</p>'),('tr',17,'Frigg Moon Doğal Kauçuk Bebek Emziği Nazik Konfor',NULL,'Bebeğinizin hassas cildi için yulaf özü ve shea yağı içeren kokusuz losyon.','<p>Dermatolojik olarak test edilmiştir. Paraben, sülfat veya sentetik koku içermez. Pompalı şişe 200ml.</p>'),('vi',1,'Giày Len Merino Đan Có Dây Rút – Ấm Áp Êm Ái Cho Trẻ Sơ Sinh',NULL,'Giày len merino mềm mại giữ ấm đôi chân nhỏ xíu mà không gây nóng bức.','<p>Lớp lót len merino thoáng khí tự nhiên với cổ giày co giãn. Giặt máy được ở chế độ nhẹ. Kích cỡ 0-12 tháng.</p>'),('vi',2,'Bộ 3 Yếm Cotton Mềm Thấm Dãi – Bảo Vệ Nhẹ Nhàng Cho Những Lúc Lấm Lem',NULL,'Bộ ba chiếc yếm thấm dãi bằng cotton hữu cơ với nút bấm không chứa niken có thể điều chỉnh.','<p>Lõi thấm hút ba lớp với lớp lót trong chống thấm nước. Họa tiết đạt chứng nhận OEKO-TEX. Phù hợp 3-24 tháng.</p>'),('vi',3,'Khăn Tắm Có Mũ Hình Thỏ Ấm Áp Cho Trẻ Sơ Sinh Và Trẻ Tập Đi',NULL,'Khăn tắm có mũ bằng cotton pha tre mềm mịn giúp bé ấm áp sau mỗi lần tắm.','<p>Khăn bông cotton pha tre 500gsm. Kích thước rộng rãi 90x90cm. Mũ mềm với chi tiết tai thêu. Không gây dị ứng và không chứa clo.</p>'),('vi',4,'Ti Giả Đầu Đời MUSHIE Frigg Họa Tiết Hoa Trái Tim | Kido Bebe',NULL,'Ti giả silicone y tế nguyên khối được tạo hình để hỗ trợ khớp ngậm tự nhiên.','<p>Không chứa BPA, BPS, PVC và phthalate. Hình dáng nha khoa đối xứng. Có thể tiệt trùng bằng cách đun sôi và rửa được trong máy rửa bát.</p>'),('vi',5,'Bộ Bình Sữa Thủy Tinh 4oz Với Núm Latex – Hồng Phấn Cho Những Khoảnh Khắc Nhỏ Xinh',NULL,'Bộ đôi bình sữa thủy tinh borosilicate với núm ti silicone chống đầy hơi.','<p>Thủy tinh chịu sốc nhiệt với lớp vỏ silicone mềm. Thiết kế cổ rộng dễ vệ sinh. Dung tích 240ml.</p>'),('vi',6,'Bộ Nĩa Và Thìa Silicone – Hoàn Hảo Cho Bé Tập Tự Ăn',NULL,'Túi ngủ cotton hữu cơ với chỉ số TOG 2.5 cho những đêm se lạnh.','<p>Lớp ngoài đạt chứng nhận GOTS với ruột chống dị ứng. Khóa kéo hai chiều giúp dễ thay tã. Kích cỡ 0-6, 6-18 và 18-36 tháng.</p>'),('vi',7,'Bộ 5 Bodysuit Cho Bé Màu Xanh Mòng Két – 100% Cotton Cho Sự Thoải Mái Mỗi Ngày',NULL,'Bodysuit cotton hữu cơ đạt chứng nhận GOTS với vai dạng phong bì giúp mặc dễ dàng.','<p>Vải dệt kim đơn mềm mại. Nút bấm không chứa niken. Giặt máy được. Có sẵn từ size sơ sinh đến 18 tháng.</p>'),('vi',8,'White Delicate Double Pom Baby Hat – Soft &amp; Cozy Warmth for Little Heads',NULL,'Beech wood teether finished with food-grade beeswax, sized for tiny hands.','<p>Sustainably harvested European beech. Naturally antibacterial. Pair with a silicone clip to keep it close to baby.</p>'),('vi',9,'Ti Giả Cao Su Tự Nhiên Frigg Moon Êm Dịu Nhẹ Nhàng',NULL,'Lotion không hương liệu với chiết xuất yến mạch và bơ hạt mỡ cho làn da nhạy cảm của bé.','<p>Đã được kiểm nghiệm da liễu. Không chứa paraben, sulphate hay hương liệu tổng hợp. Chai bơm 200ml.</p>'),('vi',10,'Ghế Ăn Dặm Bằng Gỗ Little Dine Tinh Tế Thoải Mái Cho Những Thực Khách Nhí',NULL,'Thú bông cotton hữu cơ đan tay với kích thước hoàn hảo cho vòng tay nhỏ bé.','<p>Ruột tái chế chống dị ứng. Chi tiết khuôn mặt được thêu — không có chi tiết nhỏ. Có thể lau bề mặt.</p>'),('vi',11,'Bộ Nĩa Và Thìa Silicone – Hoàn Hảo Cho Bé Tập Tự Ăn',NULL,'Túi ngủ cotton hữu cơ với chỉ số TOG 2.5 cho những đêm se lạnh.','<p>Lớp ngoài đạt chứng nhận GOTS với ruột chống dị ứng. Khóa kéo hai chiều giúp dễ thay tã. Kích cỡ 0-6, 6-18 và 18-36 tháng.</p>'),('vi',12,'Bộ Nĩa Và Thìa Silicone – Hoàn Hảo Cho Bé Tập Tự Ăn',NULL,'Túi ngủ cotton hữu cơ với chỉ số TOG 2.5 cho những đêm se lạnh.','<p>Lớp ngoài đạt chứng nhận GOTS với ruột chống dị ứng. Khóa kéo hai chiều giúp dễ thay tã. Kích cỡ 0-6, 6-18 và 18-36 tháng.</p>'),('vi',13,'Mũ Cho Bé Hai Cục Bông Trắng Tinh Tế – Ấm Áp Êm Ái Cho Đầu Bé',NULL,'Vòng ngậm nướu bằng gỗ sồi hoàn thiện với sáp ong đạt chuẩn thực phẩm, vừa với bàn tay nhỏ xíu.','<p>Gỗ sồi châu Âu được thu hoạch bền vững. Kháng khuẩn tự nhiên. Kết hợp với kẹp silicone để giữ vòng ngậm gần bé.</p>'),('vi',14,'Mũ Cho Bé Hai Cục Bông Trắng Tinh Tế – Ấm Áp Êm Ái Cho Đầu Bé',NULL,'Vòng ngậm nướu bằng gỗ sồi hoàn thiện với sáp ong đạt chuẩn thực phẩm, vừa với bàn tay nhỏ xíu.','<p>Gỗ sồi châu Âu được thu hoạch bền vững. Kháng khuẩn tự nhiên. Kết hợp với kẹp silicone để giữ vòng ngậm gần bé.</p>'),('vi',15,'Mũ Cho Bé Hai Cục Bông Trắng Tinh Tế – Ấm Áp Êm Ái Cho Đầu Bé',NULL,'Vòng ngậm nướu bằng gỗ sồi hoàn thiện với sáp ong đạt chuẩn thực phẩm, vừa với bàn tay nhỏ xíu.','<p>Gỗ sồi châu Âu được thu hoạch bền vững. Kháng khuẩn tự nhiên. Kết hợp với kẹp silicone để giữ vòng ngậm gần bé.</p>'),('vi',16,'Ti Giả Cao Su Tự Nhiên Frigg Moon Êm Dịu Nhẹ Nhàng',NULL,'Lotion không hương liệu với chiết xuất yến mạch và bơ hạt mỡ cho làn da nhạy cảm của bé.','<p>Đã được kiểm nghiệm da liễu. Không chứa paraben, sulphate hay hương liệu tổng hợp. Chai bơm 200ml.</p>'),('vi',17,'Ti Giả Cao Su Tự Nhiên Frigg Moon Êm Dịu Nhẹ Nhàng',NULL,'Lotion không hương liệu với chiết xuất yến mạch và bơ hạt mỡ cho làn da nhạy cảm của bé.','<p>Đã được kiểm nghiệm da liễu. Không chứa paraben, sulphate hay hương liệu tổng hợp. Chai bơm 200ml.</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,6,NULL,NULL,2,4,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(2,3,NULL,NULL,8,2,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(3,7,NULL,NULL,2,2,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(4,2,NULL,NULL,3,1,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(5,10,NULL,NULL,8,3,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(6,8,NULL,NULL,10,4,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(7,2,NULL,NULL,10,5,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(8,5,NULL,NULL,4,3,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(9,10,NULL,NULL,4,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 18:59:18','2026-05-28 18:59:18',NULL),(10,9,NULL,NULL,6,1,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(11,1,NULL,NULL,10,2,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(12,1,NULL,NULL,8,1,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(13,6,NULL,NULL,1,4,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(14,9,NULL,NULL,7,3,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(15,10,NULL,NULL,9,1,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(16,3,NULL,NULL,4,1,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(17,2,NULL,NULL,1,3,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(18,4,NULL,NULL,1,4,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(19,10,NULL,NULL,3,3,'Clean & perfect source code','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(20,5,NULL,NULL,1,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 18:59:18','2026-05-28 18:59:18',NULL),(21,8,NULL,NULL,4,2,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(22,1,NULL,NULL,9,4,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(23,5,NULL,NULL,7,5,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(24,6,NULL,NULL,7,2,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(25,9,NULL,NULL,2,1,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(26,6,NULL,NULL,4,4,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(27,5,NULL,NULL,5,4,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(28,2,NULL,NULL,4,4,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(29,4,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 18:59:18','2026-05-28 18:59:18',NULL),(30,8,NULL,NULL,3,2,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(31,3,NULL,NULL,6,5,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(32,9,NULL,NULL,10,1,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(33,10,NULL,NULL,1,5,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(34,6,NULL,NULL,10,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 18:59:18','2026-05-28 18:59:18',NULL),(35,5,NULL,NULL,3,2,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(36,3,NULL,NULL,3,3,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(37,5,NULL,NULL,2,3,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(38,8,NULL,NULL,8,3,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(39,10,NULL,NULL,6,1,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(40,1,NULL,NULL,4,4,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(41,10,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 18:59:18','2026-05-28 18:59:18',NULL),(42,10,NULL,NULL,7,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 18:59:18','2026-05-28 18:59:18',NULL),(43,6,NULL,NULL,9,2,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(44,2,NULL,NULL,8,1,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(45,8,NULL,NULL,9,5,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(46,2,NULL,NULL,6,5,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(47,6,NULL,NULL,6,1,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(48,9,NULL,NULL,8,3,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(49,4,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 18:59:18','2026-05-28 18:59:18',NULL),(50,2,NULL,NULL,7,5,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(51,4,NULL,NULL,7,4,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(52,3,NULL,NULL,10,4,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(53,1,NULL,NULL,3,2,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(54,7,NULL,NULL,10,3,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(55,9,NULL,NULL,3,1,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(56,8,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 18:59:18','2026-05-28 18:59:18',NULL),(57,6,NULL,NULL,3,5,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(58,7,NULL,NULL,9,5,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(59,5,NULL,NULL,8,1,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(60,7,NULL,NULL,8,2,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(61,4,NULL,NULL,2,1,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(62,3,NULL,NULL,9,5,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(63,4,NULL,NULL,4,1,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(64,9,NULL,NULL,5,4,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(65,8,NULL,NULL,7,2,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(66,7,NULL,NULL,7,3,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(67,6,NULL,NULL,8,4,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(68,6,NULL,NULL,5,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 18:59:18','2026-05-28 18:59:18',NULL),(69,5,NULL,NULL,10,2,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(70,2,NULL,NULL,2,2,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(71,8,NULL,NULL,5,3,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(72,7,NULL,NULL,4,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 18:59:18','2026-05-28 18:59:18',NULL),(73,9,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 18:59:18','2026-05-28 18:59:18',NULL),(74,10,NULL,NULL,10,5,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(75,4,NULL,NULL,10,4,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(76,8,NULL,NULL,6,3,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(77,1,NULL,NULL,5,2,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(78,9,NULL,NULL,9,2,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(79,7,NULL,NULL,3,1,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(80,1,NULL,NULL,2,3,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(81,8,NULL,NULL,1,5,'Best ecommerce CMS online store!','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(82,4,NULL,NULL,3,2,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(83,10,NULL,NULL,2,4,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(84,4,NULL,NULL,8,5,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(85,5,NULL,NULL,6,1,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(86,9,NULL,NULL,1,5,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(87,2,NULL,NULL,9,5,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(88,1,NULL,NULL,7,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 18:59:18','2026-05-28 18:59:18',NULL),(89,3,NULL,NULL,7,3,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(90,3,NULL,NULL,5,5,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(91,1,NULL,NULL,1,4,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(92,4,NULL,NULL,9,1,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(93,2,NULL,NULL,5,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 18:59:18','2026-05-28 18:59:18',NULL),(94,3,NULL,NULL,2,3,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(95,7,NULL,NULL,5,1,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(96,7,NULL,NULL,1,4,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(97,7,NULL,NULL,6,2,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(98,5,NULL,NULL,9,2,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(99,3,NULL,NULL,1,3,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL),(100,1,NULL,NULL,6,2,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','auto','2026-05-28 18:59:18','2026-05-28 18:59:18',NULL);

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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
