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

--
-- 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,'Style Edit',0,'Curated bag and accessory edits for every occasion — work, travel, and weekend.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2026-05-28 18:59:51','2026-05-28 18:59:51'),(2,'Bag Care',0,'Cleaning, storage, and conditioning rituals to extend the life of your investment pieces.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 18:59:51','2026-05-28 18:59:51'),(3,'Material Guides',0,'Suede, full-grain leather, and exotic materials — what to buy and how to maintain it.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 18:59:51','2026-05-28 18:59:51'),(4,'Trends',0,'Hardware, silhouettes, and color stories shaping each accessory season.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 18:59:51','2026-05-28 18:59:51'),(5,'Behind the Brand',0,'Workshops, artisans, and origin stories from the brands we carry.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 18:59:51','2026-05-28 18:59:51');

--
-- Table structure for table `categories_translations`
--

CREATE TABLE `categories_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `categories_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`categories_id`),
  KEY `idx_categories_trans_categories_id` (`categories_id`),
  KEY `idx_categories_trans_category_lang` (`categories_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories_translations`
--

INSERT INTO `categories_translations` VALUES ('ar',1,'تحرير النمط','مجموعة مختارة من حقائب اليد والإكسسوارات لكل المناسبات - العمل والسفر وعطلات نهاية الأسبوع.'),('ar',2,'العناية بالحقيبة','طقوس التنظيف والحفظ والتكييف لإطالة عمر مقتنياتك الثمينة.'),('ar',3,'أدلة المواد','جلد سويدي، جلد محبب بالكامل، ومواد فاخرة - ماذا تشتري وكيفية العناية بها.'),('ar',4,'الاتجاهات','تحدد الأبازيم المعدنية والأنماط وقصص الألوان كل موسم من الإكسسوارات.'),('ar',5,'خلف العلامة التجارية','ورش العمل والحرفيين وقصص الأصل من العلامات التجارية التي نوزعها.'),('fr',1,'Modifier le style','Une sélection de sacs à main et d\'accessoires pour toutes les occasions : travail, voyages et week-end.'),('fr',2,'Entretien des sacs','Des rituels de nettoyage, de conservation et de conditionnement pour prolonger la durée de vie de vos objets de valeur.'),('fr',3,'Guides des matériaux','Daim, cuir pleine fleur et matériaux haut de gamme : quoi acheter et comment en prendre soin.'),('fr',4,'Tendances','Les boucles métalliques, les styles et les histoires de couleurs définissent chaque saison d\'accessoires.'),('fr',5,'Derrière la marque','Ateliers, artisans et histoires d\'origine des marques que nous distribuons.'),('id',1,'Pengeditan Gaya','Pilihan tas dan aksesori untuk setiap kesempatan — kerja, perjalanan, dan akhir pekan.'),('id',2,'Perawatan Tas','Ritual pembersihan, pelestarian, dan pengkondisian untuk memperpanjang umur barang berharga Anda.'),('id',3,'Panduan Materi','Suede, kulit gandum utuh, dan bahan premium — apa yang harus dibeli dan cara merawatnya.'),('id',4,'Tren','Gesper logam, gaya, dan kisah warna menentukan setiap musim aksesori.'),('id',5,'Dibalik Merek','Lokakarya, pengrajin, dan kisah asal usul merek yang kami distribusikan.'),('tr',1,'Stil Düzenle','İş, seyahat ve hafta sonları gibi her duruma uygun çanta ve aksesuar seçenekleri.'),('tr',2,'Çanta Bakımı','Değerli eşyalarınızın ömrünü uzatmak için temizlik, muhafaza ve bakım ritüelleri.'),('tr',3,'Malzeme Kılavuzları','Süet, sırçalı deri ve birinci sınıf malzemeler — ne satın alınır ve bunların bakımı nasıl yapılır.'),('tr',4,'Trendler','Metal tokalar, stiller ve renk hikayeleri her aksesuar sezonunu tanımlar.'),('tr',5,'Markanın Arkasında','Distribütörlüğünü yaptığımız markaların atölyeleri, zanaatkarları ve köken hikayeleri.'),('vi',1,'Tuyển Chọn Phong Cách','Tuyển chọn túi xách và phụ kiện cho mọi dịp — đi làm, du lịch và cuối tuần.'),('vi',2,'Chăm Sóc Túi','Những nghi thức làm sạch, bảo quản và dưỡng da để kéo dài tuổi thọ những món đồ giá trị của bạn.'),('vi',3,'Cẩm Nang Chất Liệu','Da lộn, da nguyên tấm và các chất liệu cao cấp — nên mua gì và bảo dưỡng ra sao.'),('vi',4,'Xu Hướng','Khóa kim loại, kiểu dáng và câu chuyện màu sắc định hình mỗi mùa phụ kiện.'),('vi',5,'Hậu Trường Thương Hiệu','Xưởng sản xuất, nghệ nhân và câu chuyện nguồn gốc từ các thương hiệu chúng tôi phân phối.');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `contacts` VALUES (1,'Sophia Bennett','sophia.bennett@example.com','+1-415-555-0142','124 Folsom Street, San Francisco, CA','Question about international shipping rates','Hi team — could you tell me whether you ship to Singapore and what the typical delivery window is for the spring outerwear collection? Many thanks.',NULL,'read','2026-05-28 18:59:50','2026-05-28 18:59:50'),(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:50','2026-05-28 18:59:50'),(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:50','2026-05-28 18:59:50');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `ec_brands` VALUES (1,'Carolin','Boutique handbag atelier crafting structured leathers in small batches.','https://example.com/carolin','brands/carolin.png','published',0,1,'2026-05-28 18:59:51','2026-05-28 18:59:51'),(2,'Cheryl','Italian artisan leather goods with hand-finished edges and brushed-brass hardware.','https://example.com/cheryl','brands/cheryl.png','published',1,1,'2026-05-28 18:59:51','2026-05-28 18:59:51'),(3,'Panadoxn','Modern minimalist accessories — quiet silhouettes in vegetable-tanned leather.','https://example.com/panadoxn','brands/panadoxn.png','published',2,1,'2026-05-28 18:59:51','2026-05-28 18:59:51'),(4,'Shangxi','Heritage leather house known for embossed wallets and structured totes.','https://example.com/shangxi','brands/shangxi.png','published',3,1,'2026-05-28 18:59:51','2026-05-28 18:59:51'),(5,'Textitles','Soft suede and woven textiles for everyday hobo and shoulder bag silhouettes.','https://example.com/textitles','brands/textitles.png','published',4,0,'2026-05-28 18:59:52','2026-05-28 18:59:52'),(6,'Vanfaba','Statement jewelry, belts, and small leather goods that finish a look.','https://example.com/vanfaba','brands/vanfaba.png','published',5,0,'2026-05-28 18:59:52','2026-05-28 18:59:52');

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

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

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

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

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

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

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


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

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

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

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

--
-- 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','AU','California','Los Angeles','369 Cherry Circle',1,1,'2026-05-28 19:00:00','2026-05-28 19:00:00','19101'),(2,'Emma Collins','customer@botble.com','+1-555-0104','DE','Illinois','Dallas','789 Pine Road',1,0,'2026-05-28 19:00:00','2026-05-28 19:00:00','48201'),(3,'Sophia Ramirez','vendor@botble.com','+1-555-0104','CA','New York','Phoenix','123 Main Street',2,1,'2026-05-28 19:00:00','2026-05-28 19:00:00','10001'),(4,'Sophia Ramirez','vendor@botble.com','+1-555-0101','AU','New York','Miami','654 Cedar Lane',2,0,'2026-05-28 19:00:00','2026-05-28 19:00:00','90210'),(5,'Olivia Carter','customer1@example.com','+1-555-0110','GB','Michigan','Chicago','789 Pine Road',3,1,'2026-05-28 19:00:00','2026-05-28 19:00:00','60601'),(6,'Ava Mitchell','customer2@example.com','+1-555-0105','US','Florida','Chicago','654 Cedar Lane',4,1,'2026-05-28 19:00:01','2026-05-28 19:00:01','48201'),(7,'Isabella Brooks','customer3@example.com','+1-555-0107','DE','Arizona','New York','654 Cedar Lane',5,1,'2026-05-28 19:00:01','2026-05-28 19:00:01','48201'),(8,'James Whitfield','customer4@example.com','+1-555-0110','DE','Georgia','New York','456 Oak Avenue',6,1,'2026-05-28 19:00:01','2026-05-28 19:00:01','80201'),(9,'Liam Bennett','customer5@example.com','+1-555-0108','AU','Arizona','Denver','654 Cedar Lane',7,1,'2026-05-28 19:00:01','2026-05-28 19:00:01','80201'),(10,'Noah Patterson','customer6@example.com','+1-555-0101','AU','Florida','Denver','789 Pine Road',8,1,'2026-05-28 19:00:01','2026-05-28 19:00:01','48201'),(11,'Charlotte Reed','customer7@example.com','+1-555-0101','US','Texas','New York','741 Spruce Street',9,1,'2026-05-28 19:00:02','2026-05-28 19:00:02','19101'),(12,'Amelia Foster','customer8@example.com','+1-555-0109','GB','Georgia','New York','456 Oak Avenue',10,1,'2026-05-28 19:00:02','2026-05-28 19:00:02','77001');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `ec_flash_sale_products` VALUES (1,8,69.3,50,0),(1,6,41.3,50,0),(1,4,55.3,50,0),(1,7,27.3,50,0),(1,5,13.3,50,0),(1,9,62.3,50,0),(1,3,17.5,50,0),(1,2,34.3,50,0),(2,9,66.75,75,0),(2,10,74.25,75,0),(2,4,59.25,75,0),(2,6,44.25,75,0),(2,5,14.25,75,0),(2,7,29.25,75,0);

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

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

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

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

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

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

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

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

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

--
-- Dumping data for table `ec_product_attributes_translations`
--

INSERT INTO `ec_product_attributes_translations` VALUES ('ar',1,'أسود'),('ar',2,'أبيض'),('ar',3,'البيج'),('ar',4,'زيتون'),('ar',5,'البحرية'),('ar',6,'بورجوندي'),('ar',7,'فحم'),('ar',8,'كريم'),('ar',9,'Pink'),('ar',10,'Brown'),('ar',11,'Green'),('ar',12,'Blue'),('ar',13,'XS'),('ar',14,'S'),('ar',15,'M'),('ar',16,'L'),('ar',17,'XL'),('ar',18,'XXL'),('ar',19,'قطن'),('ar',20,'الكتان'),('ar',21,'صوف'),('ar',22,'ايوسل'),('ar',23,'البوليستر المعاد تدويره'),('ar',24,'جلد محبب بالكامل'),('fr',1,'Noir'),('fr',2,'Blanc'),('fr',3,'Beige'),('fr',4,'Olive'),('fr',5,'Marine'),('fr',6,'Bourgogne'),('fr',7,'Charbon de bois'),('fr',8,'Crème'),('fr',9,'Pink'),('fr',10,'Brown'),('fr',11,'Green'),('fr',12,'Blue'),('fr',13,'XS'),('fr',14,'S'),('fr',15,'M'),('fr',16,'L'),('fr',17,'XL'),('fr',18,'XXL'),('fr',19,'Coton'),('fr',20,'Lin'),('fr',21,'Laine'),('fr',22,'Tencel'),('fr',23,'Polyester recyclé'),('fr',24,'Cuir pleine fleur'),('id',1,'Hitam'),('id',2,'Putih'),('id',3,'Krem'),('id',4,'Zaitun'),('id',5,'Angkatan laut'),('id',6,'merah anggur'),('id',7,'Arang'),('id',8,'Krim'),('id',9,'Pink'),('id',10,'Brown'),('id',11,'Green'),('id',12,'Blue'),('id',13,'XS'),('id',14,'S'),('id',15,'M'),('id',16,'L'),('id',17,'XL'),('id',18,'XXL'),('id',19,'Kapas'),('id',20,'Linen'),('id',21,'Wol'),('id',22,'Tencel'),('id',23,'Poliester Daur Ulang'),('id',24,'Kulit Gandum Penuh'),('tr',1,'Siyah'),('tr',2,'Beyaz'),('tr',3,'Bej'),('tr',4,'Zeytin'),('tr',5,'Donanma'),('tr',6,'Bordo'),('tr',7,'Kömür'),('tr',8,'Krem'),('tr',9,'Pink'),('tr',10,'Brown'),('tr',11,'Green'),('tr',12,'Blue'),('tr',13,'XS'),('tr',14,'S'),('tr',15,'M'),('tr',16,'L'),('tr',17,'XL'),('tr',18,'XXL'),('tr',19,'Pamuk'),('tr',20,'Keten'),('tr',21,'Yün'),('tr',22,'Tencel'),('tr',23,'Geri Dönüştürülmüş Polyester'),('tr',24,'Tam Sırçalı Deri'),('vi',1,'Đen'),('vi',2,'Trắng'),('vi',3,'Be'),('vi',4,'Ô-liu'),('vi',5,'Xanh navy'),('vi',6,'Đỏ burgundy'),('vi',7,'Xám than'),('vi',8,'Kem'),('vi',9,'Pink'),('vi',10,'Brown'),('vi',11,'Green'),('vi',12,'Blue'),('vi',13,'XS'),('vi',14,'S'),('vi',15,'M'),('vi',16,'L'),('vi',17,'XL'),('vi',18,'XXL'),('vi',19,'Cotton'),('vi',20,'Linen'),('vi',21,'Len'),('vi',22,'Tencel'),('vi',23,'Polyester tái chế'),('vi',24,'Da nguyên tấm');

--
-- Table structure for table `ec_product_categories`
--

CREATE TABLE `ec_product_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` bigint unsigned NOT NULL DEFAULT '0',
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `order` int unsigned NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_featured` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_product_categories_parent_id_status_created_at_index` (`parent_id`,`status`,`created_at`),
  KEY `ec_product_categories_parent_id_status_index` (`parent_id`,`status`),
  KEY `idx_categories_status_order` (`status`,`order`),
  KEY `idx_categories_order` (`order`),
  KEY `ec_product_categories_slug_index` (`slug`),
  KEY `idx_ec_product_categories_status` (`status`),
  KEY `idx_ec_product_categories_parent_id` (`parent_id`),
  KEY `idx_ec_product_categories_status_parent_order` (`status`,`parent_id`,`order`),
  KEY `idx_ec_product_categories_is_featured` (`is_featured`),
  KEY `idx_ec_product_categories_name` (`name`),
  KEY `idx_ec_product_categories_slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_product_categories` VALUES (1,'Bags',NULL,0,'Totes, hobos, crossbodies, and clutches in soft suede and full-grain leather.','published',0,'categories/cate-58.jpg',1,'2026-05-28 18:59:52','2026-05-28 18:59:52',NULL,NULL),(2,'Beanie',NULL,0,'Wool and cashmere beanies in classic ribbed and slouchy fits.','published',1,'categories/cate-59.jpg',1,'2026-05-28 18:59:52','2026-05-28 18:59:52',NULL,NULL),(3,'Belts',NULL,0,'Slim and statement belts with brushed brass and antique silver buckles.','published',2,'categories/cate-60.jpg',1,'2026-05-28 18:59:53','2026-05-28 18:59:53',NULL,NULL),(4,'Jewelry',NULL,0,'Statement earrings, layered necklaces, and stacking rings for every season.','published',3,'categories/cate-61.jpg',1,'2026-05-28 18:59:53','2026-05-28 18:59:53',NULL,NULL),(5,'Mittens',NULL,0,'Cashmere-lined mittens and gloves for cold-weather layering.','published',4,'categories/cate-62.jpg',1,'2026-05-28 18:59:53','2026-05-28 18:59:53',NULL,NULL),(6,'Shoes',NULL,0,'Leather boots, loafers, and ankle silhouettes that pair across seasons.','published',5,'categories/cate-63.jpg',1,'2026-05-28 18:59:53','2026-05-28 18:59:53',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,'الأحذية الجلدية والأحذية بدون كعب وأنماط الأحذية ذات القطع المنخفضة مناسبة لجميع المواسم.'),('fr',1,'Sacs',NULL,'Sacs fourre-tout, sacs hobo, sacs à bandoulière et pochettes en daim souple et cuir pleine fleur.'),('fr',2,'Bonnet',NULL,'Bonnet en laine et cachemire avec motif côtelé classique et coupe ample confortable.'),('fr',3,'Ceintures',NULL,'Ceintures fines et ornées rehaussées de boucles classiques en argent et en bronze brossé.'),('fr',4,'Bijoux',NULL,'Boucles d\'oreilles accentuées, colliers superposés et bagues superposées pour chaque saison.'),('fr',5,'Mitaines',NULL,'Gants et mitaines doublés de cachemire pour plus de chaleur lors des journées froides.'),('fr',6,'Chaussures',NULL,'Les bottes en cuir, les mocassins et les chaussures basses conviennent à toutes les saisons.'),('id',1,'Tas',NULL,'Tas jinjing, tas hobo, tas selempang, dan tas genggam dari bahan suede lembut dan kulit gandum utuh.'),('id',2,'Beanie',NULL,'Topi wol dan kasmir dengan pola bergaris klasik dan potongan longgar yang nyaman.'),('id',3,'ikat pinggang',NULL,'Ikat pinggang tipis dan penuh hiasan dengan aksen gesper perak klasik dan perunggu.'),('id',4,'Perhiasan',NULL,'Anting beraksen, kalung berlapis, dan cincin berlapis untuk setiap musim.'),('id',5,'sarung tangan',NULL,'Sarung tangan dan sarung tangan berlapis kasmir untuk kehangatan di hari yang dingin.'),('id',6,'Sepatu',NULL,'Sepatu bot kulit, sepatu pantofel, dan model sepatu berpotongan rendah cocok untuk segala musim.'),('tr',1,'Çantalar',NULL,'Yumuşak süet ve sırçalı deriden bez çantalar, hobo çantalar, çapraz çantalar ve el çantaları.'),('tr',2,'Bere',NULL,'Klasik nervürlü desenli, rahat, bol kesimli, yün ve kaşmir şapka.'),('tr',3,'Kemerler',NULL,'Klasik gümüş ve fırçalanmış bronz tokalarla vurgulanan ince ve süslü kemerler.'),('tr',4,'Takı',NULL,'Her mevsime uygun vurgulu küpeler, katmanlı kolyeler ve katmanlı yüzükler.'),('tr',5,'Eldivenler',NULL,'Soğuk günlerde sıcaklık için kaşmir astarlı eldivenler ve eldivenler.'),('tr',6,'Ayakkabı',NULL,'Deri çizme, loafer ve dekolte ayakkabı modelleri her mevsime uygundur.'),('vi',1,'Túi Xách',NULL,'Túi tote, túi hobo, túi đeo chéo và ví cầm tay bằng da lộn mềm mại và da nguyên tấm.'),('vi',2,'Mũ Len',NULL,'Mũ len và cashmere với kiểu gân cổ điển và dáng rộng thoải mái.'),('vi',3,'Thắt Lưng',NULL,'Thắt lưng bản mảnh và bản tạo điểm nhấn với khóa đồng chải và bạc cổ điển.'),('vi',4,'Trang Sức',NULL,'Bông tai tạo điểm nhấn, vòng cổ nhiều lớp và nhẫn xếp tầng cho mọi mùa.'),('vi',5,'Găng Tay Bao',NULL,'Găng tay bao và găng tay lót cashmere cho việc giữ ấm những ngày lạnh giá.'),('vi',6,'Giày Dép',NULL,'Bốt da, giày lười và các dáng giày cổ thấp phù hợp qua mọi mùa.');

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

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

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


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

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

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

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

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

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

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

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

--
-- 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,'Handbags','handbags','Crossbodies, totes, and shoulder bags for every season.','collection/bag/cls-1.jpg','published','2026-05-28 18:59:54','2026-05-28 18:59:54',1),(2,'Belts','belts','Classic dress and casual belts for every wardrobe.','collection/bag/cls-2.jpg','published','2026-05-28 18:59:54','2026-05-28 18:59:54',1),(3,'Jewelry','jewelry','Necklaces, rings, and earrings to layer with every outfit.','collection/bag/cls-3.jpg','published','2026-05-28 18:59:54','2026-05-28 18:59:54',1),(4,'Backpacks','backpacks','Daily commuters and weekend carry-alls built to last.','collection/cls-10.jpg','published','2026-05-28 18:59:54','2026-05-28 18:59:54',1),(5,'Wallets','wallets','Slim cardholders and bifolds in premium leather.','collection/cls-11.jpg','published','2026-05-28 18:59:54','2026-05-28 18:59:54',0),(6,'Sunglasses','sunglasses','Trend-led shades and timeless aviators for any face shape.','collection/cls-13.jpg','published','2026-05-28 18:59:54','2026-05-28 18:59:54',0),(7,'Watches','watches','Quartz, automatic, and smart watches with refined finishes.','collection/cls-14.jpg','published','2026-05-28 18:59:54','2026-05-28 18:59:54',0),(8,'Travel Bags','travel-bags','Weekenders, duffles, and luggage for every getaway.','collection/cls-16.jpg','published','2026-05-28 18:59:54','2026-05-28 18:59:54',0),(9,'Hats &amp; Scarves','hats-scarves','Seasonal accessories that complete the look.','collection/cls-17.jpg','published','2026-05-28 18:59:54','2026-05-28 18:59:54',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,'Hats &amp; Scarves','Seasonal accessories that complete the look.'),('fr',1,'Sacs à main','Sacs à bandoulière, fourre-tout et sacs à bandoulière pour chaque saison.'),('fr',2,'Ceintures','Ceintures formelles classiques et ceintures décontractées pour chaque garde-robe.'),('fr',3,'Bijoux','Colliers, bagues et boucles d\'oreilles pour s\'adapter à toutes les tenues.'),('fr',4,'Sacs à dos','Les sacs à dos de travail quotidiens et les sacs de week-end sont conçus pour durer.'),('fr',5,'Portefeuilles','Portefeuille fin pour cartes et portefeuille à deux volets en cuir de première qualité.'),('fr',6,'Lunettes de soleil','Des lunettes tendance et des lunettes de soleil aviateur intemporelles pour toutes les formes de visage.'),('fr',7,'Montres','Montres à quartz, automatiques et intelligentes aux finitions exquises.'),('fr',8,'Sacs de voyage','Sacs de week-end, fourre-tout et valises pour chaque voyage.'),('fr',9,'Hats &amp; Scarves','Seasonal accessories that complete the look.'),('id',1,'tas tangan','Tas selempang, tas jinjing, dan tas bahu untuk setiap musim.'),('id',2,'ikat pinggang','Ikat pinggang formal klasik dan ikat pinggang kasual untuk setiap lemari pakaian.'),('id',3,'Perhiasan','Kalung, cincin, dan anting-anting yang cocok dipadukan dengan pakaian apa pun.'),('id',4,'ransel','Ransel kerja sehari-hari dan tas akhir pekan dibuat agar tahan lama.'),('id',5,'Dompet','Dompet kartu ramping dan dompet lipat dua terbuat dari kulit premium.'),('id',6,'Kacamata hitam','Kacamata trendi dan trendi serta kacamata penerbang abadi untuk setiap bentuk wajah.'),('id',7,'Jam tangan','Jam tangan kuarsa, otomatis, dan pintar dengan sentuhan akhir yang indah.'),('id',8,'Tas Perjalanan','Tas akhir pekan, tas jinjing dan koper untuk setiap perjalanan.'),('id',9,'Hats &amp; Scarves','Seasonal accessories that complete the look.'),('tr',1,'Çanta','Her mevsime uygun çapraz çantalar, totelar ve omuz çantaları.'),('tr',2,'Kemerler','Her gardırop için klasik resmi kemerler ve gündelik kemerler.'),('tr',3,'Takı','Her kıyafete uygun kolyeler, yüzükler ve küpeler.'),('tr',4,'Sırt çantaları','Günlük iş çantaları ve hafta sonu çantaları uzun süre dayanacak şekilde tasarlanmıştır.'),('tr',5,'Cüzdanlar','Birinci sınıf deriden yapılmış ince kart cüzdanı ve ikiye katlanan cüzdan.'),('tr',6,'Güneş gözlüğü','Her yüz şekline uygun modaya uygun, trend gözlükler ve zamansız havacı güneş gözlükleri.'),('tr',7,'Saatler','Zarif yüzeylere sahip Quartz, otomatik ve akıllı saatler.'),('tr',8,'Seyahat Çantaları','Her yolculuk için hafta sonu çantaları, tote\'lar ve valizler.'),('tr',9,'Hats &amp; Scarves','Seasonal accessories that complete the look.'),('vi',1,'Túi Xách Tay','Túi đeo chéo, túi tote và túi đeo vai cho mọi mùa.'),('vi',2,'Thắt Lưng','Thắt lưng trang trọng cổ điển và thắt lưng thường ngày cho mọi tủ đồ.'),('vi',3,'Trang Sức','Vòng cổ, nhẫn và bông tai để phối cùng mọi bộ trang phục.'),('vi',4,'Balo','Balo đi làm hằng ngày và túi xách cuối tuần được chế tạo để bền lâu.'),('vi',5,'Ví','Ví đựng thẻ mỏng và ví gập đôi bằng da cao cấp.'),('vi',6,'Kính Râm','Kính thời thượng theo xu hướng và kính phi công vượt thời gian cho mọi dáng khuôn mặt.'),('vi',7,'Đồng Hồ','Đồng hồ quartz, cơ tự động và thông minh với lớp hoàn thiện tinh tế.'),('vi',8,'Túi Du Lịch','Túi cuối tuần, túi trống và vali cho mọi chuyến đi.'),('vi',9,'Hats &amp; Scarves','Seasonal accessories that complete the look.');

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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

INSERT INTO `ec_product_with_attribute_set` VALUES (1,2,0),(2,2,0),(1,3,0),(2,3,0),(3,5,0),(3,7,0),(3,9,0),(3,10,0);

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

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

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

INSERT INTO `ec_products` VALUES (1,'Suede Tote Bag','suede-tote-bag','Oversized suede tote with twin top handles, magnetic snap, and an unlined interior.','<p>Brushed suede in espresso. Holds a 15-inch laptop, day binder, and water bottle. Brass feet protect the base from wear.</p>','published','[\"products\\/bag\\/product-1.jpg\"]',NULL,'OB-103',0,12,0,1,'in_stock',0,NULL,3,0,0,10,3.30,0,99.99,69.99,NULL,NULL,13,10,16,803,NULL,'standard',85026,'2026-05-28 18:59:57','2026-05-28 19:00:04',1,0,'Botble\\ACL\\Models\\User',0,'products/bag/product-1.jpg','physical','7872601746655',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(2,'Suede Mini Bag','suede-mini-bag','Petite suede shoulder bag with a curb-chain strap and tonal flap closure.','<p>Holds a phone, cards, and lipstick. Adjustable chain strap from 22 to 24 inches. Cotton drill lining.</p>','published','[\"products\\/bag\\/product-2.jpg\"]',NULL,'KY-116-A1',0,20,0,1,'in_stock',0,NULL,6,0,4,10,2.30,0,49.99,29.99,NULL,NULL,19,20,19,563,NULL,'standard',10601,'2026-05-28 18:59:57','2026-05-28 19:00:04',2,0,'Botble\\ACL\\Models\\User',0,'products/bag/product-2.jpg','physical','9406666512245',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(3,'Mini Sue Crossbody Bag','mini-sue-crossbody-bag','Smooth leather crossbody with adjustable strap, gold-tone hardware, and three card slots.','<p>Italian full-grain leather. Hand-painted edges. Pairs with everyday and dressed-up looks.</p>','published','[\"products\\/bag\\/product-3.jpg\"]',NULL,'WD-199-A1',0,10,0,1,'in_stock',1,NULL,6,0,1,10,3.00,0,25.99,15.99,NULL,NULL,20,15,10,750,NULL,'standard',104377,'2026-05-28 18:59:57','2026-05-28 19:00:04',3,0,'Botble\\ACL\\Models\\User',0,'products/bag/product-3.jpg','physical','3801131815290',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(4,'Shearling-Suede Tote Bag','shearling-suede-tote-bag','Plush shearling-trimmed suede tote with twin top handles and a roomy interior.','<p>Soft suede body with cozy shearling collar. Magnetic snap closure. Fits a 13-inch laptop and daily essentials.</p>','published','[\"products\\/bag\\/product-4.jpg\"]',NULL,'AV-140',0,20,0,1,'in_stock',0,NULL,3,0,0,10,3.10,0,79.99,45.99,NULL,NULL,19,16,17,556,NULL,'standard',24131,'2026-05-28 18:59:57','2026-05-28 19:00:04',4,0,'Botble\\ACL\\Models\\User',0,'products/bag/product-4.jpg','physical','0407624448667',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(5,'Small Nappa Leather Pouch With Button','small-nappa-leather-pouch-with-button','Compact nappa leather pouch with a magnetic button closure and slim card slots.','<p>Soft nappa leather. Hand-stitched edges. Holds cards, cash, and a phone.</p>','published','[\"products\\/bag\\/product-5.jpg\"]',NULL,'XD-130-A1',0,13,0,1,'in_stock',1,NULL,2,0,3,10,3.60,0,19.99,9.99,NULL,NULL,12,13,20,576,NULL,'standard',10854,'2026-05-28 18:59:57','2026-05-28 19:00:04',1,0,'Botble\\ACL\\Models\\User',0,'products/bag/product-5.jpg','physical','7053207453233',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(6,'Long Leaf Shaped Earrings','long-leaf-shaped-earrings','Sculpted leaf-shaped drop earrings in polished gold-tone finish.','<p>Lightweight cast brass with hypoallergenic posts. Hand-finished. Comes in a velvet pouch.</p>','published','[\"products\\/bag\\/product-6.jpg\"]',NULL,'91-195',0,14,0,1,'in_stock',1,NULL,1,0,0,10,3.20,0,59.99,34.99,NULL,NULL,12,15,10,895,NULL,'standard',13637,'2026-05-28 18:59:57','2026-05-28 19:00:04',2,0,'Botble\\ACL\\Models\\User',0,'products/bag/product-6.jpg','physical','7186665648474',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(7,'Leather Crossbody Bag','leather-crossbody-bag','Smooth leather crossbody with adjustable strap, gold-tone hardware, and three card slots.','<p>Italian full-grain leather. Hand-painted edges. Pairs with everyday and dressed-up looks.</p>','published','[\"products\\/bag\\/product-7.jpg\"]',NULL,'DJ-130-A1',0,16,0,1,'in_stock',1,NULL,3,0,2,10,3.40,0,39.99,22.99,NULL,NULL,19,14,12,678,NULL,'standard',189966,'2026-05-28 18:59:57','2026-05-28 19:00:04',3,0,'Botble\\ACL\\Models\\User',0,'products/bag/product-7.jpg','physical','1013627859554',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(8,'Suede Bowling Bag','suede-bowling-bag','Soft-structured bowling silhouette in pebbled suede with a top zip and side handles.','<p>Generous interior with one zip pocket and two slip pockets. Holds a tablet, planner, and overnight basics.</p>','published','[\"products\\/bag\\/product-8.jpg\"]',NULL,'NA-174',0,19,0,1,'in_stock',0,NULL,4,0,0,10,2.60,0,99.99,67.99,NULL,NULL,20,16,20,502,NULL,'standard',139142,'2026-05-28 18:59:57','2026-05-28 19:00:04',4,0,'Botble\\ACL\\Models\\User',0,'products/bag/product-8.jpg','physical','3144316471721',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(9,'Cashmere Mittens','cashmere-mittens','Cashmere-lined mittens with a leather palm and elasticated wrist for cold-weather days.','<p>100% Mongolian cashmere lining. Lambskin palm for grip and durability. Sized unisex.</p>','published','[\"products\\/bag\\/product-9.jpg\"]',NULL,'XF-137-A1',0,10,0,1,'in_stock',0,NULL,1,0,3,10,3.30,0,89,59,NULL,NULL,13,15,18,688,NULL,'standard',132062,'2026-05-28 18:59:57','2026-05-28 19:00:04',1,0,'Botble\\ACL\\Models\\User',0,'products/bag/product-9.jpg','physical','3602712923546',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(10,'Embossed Wallet','embossed-wallet','Bifold leather wallet with subtle embossed monogram, six card slots, and a coin pocket.','<p>Vegetable-tanned leather. RFID-blocking lining. Hand-painted edges and bar-tacked stress points.</p>','published','[\"products\\/bag\\/product-10.jpg\"]',NULL,'9V-154-A1',0,18,0,1,'in_stock',1,NULL,4,0,2,10,3.50,0,99,69,NULL,NULL,16,17,19,736,NULL,'standard',177221,'2026-05-28 18:59:57','2026-05-28 19:00:04',2,0,'Botble\\ACL\\Models\\User',0,'products/bag/product-10.jpg','physical','8732496635108',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(11,'Suede Mini Bag',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-2.jpg\"]',NULL,'KY-116-A1',0,20,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,49.99,NULL,NULL,NULL,19,20,19,563,NULL,'standard',0,'2026-05-28 18:59:58','2026-05-28 19:00:04',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5277201736884',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(12,'Suede Mini Bag',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-2.jpg\"]',NULL,'KY-116-A1-A2',0,20,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,49.99,NULL,NULL,NULL,19,20,19,563,NULL,'standard',0,'2026-05-28 18:59:58','2026-05-28 19:00:04',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','3168253882389',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(13,'Suede Mini Bag',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-2.jpg\"]',NULL,'KY-116-A1-A3',0,20,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,49.99,NULL,NULL,NULL,19,20,19,563,NULL,'standard',0,'2026-05-28 18:59:58','2026-05-28 19:00:04',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','7694287141711',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(14,'Suede Mini Bag',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-2.jpg\"]',NULL,'KY-116-A1-A4',0,20,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,49.99,NULL,NULL,NULL,19,20,19,563,NULL,'standard',0,'2026-05-28 18:59:58','2026-05-28 19:00:04',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','3888249964850',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(15,'Mini Sue Crossbody Bag',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-3.jpg\"]',NULL,'WD-199-A1',0,10,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,25.99,NULL,NULL,NULL,20,15,10,750,NULL,'standard',0,'2026-05-28 18:59:58','2026-05-28 19:00:04',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','0752447830695',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(16,'Small Nappa Leather Pouch With Button',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-5.jpg\"]',NULL,'XD-130-A1',0,13,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,19.99,NULL,NULL,NULL,12,13,20,576,NULL,'standard',0,'2026-05-28 18:59:58','2026-05-28 19:00:04',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6921416197822',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(17,'Small Nappa Leather Pouch With Button',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-5.jpg\"]',NULL,'XD-130-A1-A2',0,13,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,19.99,NULL,NULL,NULL,12,13,20,576,NULL,'standard',0,'2026-05-28 18:59:58','2026-05-28 19:00:04',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5407067487389',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(18,'Small Nappa Leather Pouch With Button',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-5.jpg\"]',NULL,'XD-130-A1-A3',0,13,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,19.99,NULL,NULL,NULL,12,13,20,576,NULL,'standard',0,'2026-05-28 18:59:58','2026-05-28 19:00:04',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6623722652650',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(19,'Leather Crossbody Bag',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-7.jpg\"]',NULL,'DJ-130-A1',0,16,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,39.99,NULL,NULL,NULL,19,14,12,678,NULL,'standard',0,'2026-05-28 18:59:58','2026-05-28 19:00:04',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4047453408973',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(20,'Leather Crossbody Bag',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-7.jpg\"]',NULL,'DJ-130-A1-A2',0,16,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,39.99,NULL,NULL,NULL,19,14,12,678,NULL,'standard',0,'2026-05-28 18:59:58','2026-05-28 19:00:04',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','7068929808353',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(21,'Cashmere Mittens',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-9.jpg\"]',NULL,'XF-137-A1',0,10,0,1,'in_stock',0,NULL,1,1,0,0,0.00,0,89,NULL,NULL,NULL,13,15,18,688,NULL,'standard',0,'2026-05-28 18:59:59','2026-05-28 19:00:04',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9785958774746',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(22,'Cashmere Mittens',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-9.jpg\"]',NULL,'XF-137-A1-A2',0,10,0,1,'in_stock',0,NULL,1,1,0,0,0.00,0,89,NULL,NULL,NULL,13,15,18,688,NULL,'standard',0,'2026-05-28 18:59:59','2026-05-28 19:00:04',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','3113930882176',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(23,'Cashmere Mittens',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-9.jpg\"]',NULL,'XF-137-A1-A3',0,10,0,1,'in_stock',0,NULL,1,1,0,0,0.00,0,89,NULL,NULL,NULL,13,15,18,688,NULL,'standard',0,'2026-05-28 18:59:59','2026-05-28 19:00:04',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4103887542505',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(24,'Embossed Wallet',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-10.jpg\"]',NULL,'9V-154-A1',0,18,0,1,'in_stock',0,NULL,4,1,0,0,0.00,0,99,NULL,NULL,NULL,16,17,19,736,NULL,'standard',0,'2026-05-28 18:59:59','2026-05-28 19:00:04',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9412812013511',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(25,'Embossed Wallet',NULL,NULL,NULL,'published','[\"products\\/bag\\/product-10.jpg\"]',NULL,'9V-154-A1-A2',0,18,0,1,'in_stock',0,NULL,4,1,0,0,0.00,0,99,NULL,NULL,NULL,16,17,19,736,NULL,'standard',0,'2026-05-28 18:59:59','2026-05-28 19:00:04',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8564331488347',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> جلد سويدي مصقول بلون بني إسبرسو. يمكنها حمل كمبيوتر محمول مقاس 15 بوصة ومجلد وزجاجة ماء. قاعدة قدم نحاسية تحمي الجزء السفلي من الحقيبة من التآكل.</p>'),('ar',2,'حقيبة صغيرة من جلد الغزال',NULL,'حقيبة كتف صغيرة من الجلد السويدي مزودة بسلسلة وغطاء بلون مختلف.','<p>يمكنه حمل الهاتف والبطاقات وأحمر الشفاه. السلسلة قابلة للتعديل من 22 إلى 24 بوصة. حفر بطانة من نسيج القطن.</p>'),('ar',3,'حقيبة كروس صغيرة سو',NULL,'حقيبة كروس من الجلد الناعم مع أحزمة قابلة للتعديل، وإبزيم معدني ذهبي اللون، وثلاث فتحات للبطاقات.','<p>جلد إيطالي محبب بالكامل. حافة الحقيبة مرسومة باليد. مناسب لكل من الأنماط اليومية والرسمية.</p>'),('ar',4,'حقيبة حمل من جلد الغزال شيرلينغ',NULL,'حقيبة يد من الجلد السويدي الناعم مع زخرفة من الصوف مع مقابض علوية وجيب واسع.','<p> حقيبة من الجلد السويدي الناعم مع ياقة صوفية دافئة. قفل بزر مغناطيسي. يناسب جهاز كمبيوتر محمول مقاس 13 بوصة وأدوات يومية.</p>'),('ar',5,'حقيبة صغيرة من جلد نابا مع زر',NULL,'حقيبة صغيرة من جلد نابا مزودة بزر إغلاق مغناطيسي وفتحات رفيعة للبطاقات.','<p>جلد نابا ناعم. حواف مخيطة يدويًا. يمكنه حمل البطاقات والنقود والهاتف.</p>'),('ar',6,'أقراط طويلة على شكل ورقة شجر',NULL,'أقراط متدلية على شكل ورقة شجر منحوتة بلمسة نهائية ذهبية لامعة.','<p> برونز مصبوب خفيف الوزن مع مشبك مضاد للحساسية. تشطيب يدوي. تأتي مع حقيبة مخملية.</p>'),('ar',7,'حقيبة كروس جلدية',NULL,'حقيبة كروس من الجلد الناعم مع أحزمة قابلة للتعديل، وإبزيم معدني ذهبي اللون، وثلاث فتحات للبطاقات.','<p>جلد إيطالي محبب بالكامل. حافة الحقيبة مرسومة باليد. مناسب لكل من الأنماط اليومية والرسمية.</p>'),('ar',8,'حقيبة البولينج من جلد الغزال',NULL,'حقيبة بولينج ناعمة مصنوعة من الجلد السويدي المحبب مع سحاب علوي ومقابض جانبية.','<p> الحقيبة واسعة مع حجرة واحدة بسحاب وحجرتين للقفص. يحمل الأجهزة اللوحية والمخططات واللوازم الليلية.</p>'),('ar',9,'القفازات الكشمير',NULL,'قفازات مبطنة بالكشمير مع راحة يد جلدية وأساور مطاطية للأيام الباردة.','<p> بطانة من الكشمير المنغولي بنسبة 100%. راحة اليد من جلد الخراف من أجل الإمساك والمتانة. مقاس للجنسين.</p>'),('ar',10,'محفظة منقوشة',NULL,'محفظة جلدية ثنائية الطي مع نقش مونوغرام منقوش رقيق، وستة أقسام للبطاقات وقسم واحد للعملات المعدنية.','<p>جلد نباتي. بطانة مضادة للسرقة RFID. حواف مرسومة يدويًا ونقاط ضغط معززة.</p>'),('ar',11,'حقيبة صغيرة من جلد الغزال',NULL,'حقيبة كتف صغيرة من الجلد السويدي مزودة بسلسلة وغطاء بلون مختلف.','<p>يمكنه حمل الهاتف والبطاقات وأحمر الشفاه. السلسلة قابلة للتعديل من 22 إلى 24 بوصة. حفر بطانة من نسيج القطن.</p>'),('ar',12,'حقيبة صغيرة من جلد الغزال',NULL,'حقيبة كتف صغيرة من الجلد السويدي مزودة بسلسلة وغطاء بلون مختلف.','<p>يمكنه حمل الهاتف والبطاقات وأحمر الشفاه. السلسلة قابلة للتعديل من 22 إلى 24 بوصة. حفر بطانة من نسيج القطن.</p>'),('ar',13,'حقيبة صغيرة من جلد الغزال',NULL,'حقيبة كتف صغيرة من الجلد السويدي مزودة بسلسلة وغطاء بلون مختلف.','<p>يمكنه حمل الهاتف والبطاقات وأحمر الشفاه. السلسلة قابلة للتعديل من 22 إلى 24 بوصة. حفر بطانة من نسيج القطن.</p>'),('ar',14,'حقيبة صغيرة من جلد الغزال',NULL,'حقيبة كتف صغيرة من الجلد السويدي مزودة بسلسلة وغطاء بلون مختلف.','<p>يمكنه حمل الهاتف والبطاقات وأحمر الشفاه. السلسلة قابلة للتعديل من 22 إلى 24 بوصة. حفر بطانة من نسيج القطن.</p>'),('ar',15,'حقيبة كروس صغيرة سو',NULL,'حقيبة كروس من الجلد الناعم مع أحزمة قابلة للتعديل، وإبزيم معدني ذهبي اللون، وثلاث فتحات للبطاقات.','<p>جلد إيطالي محبب بالكامل. حافة الحقيبة مرسومة باليد. مناسب لكل من الأنماط اليومية والرسمية.</p>'),('ar',16,'حقيبة صغيرة من جلد نابا مع زر',NULL,'حقيبة صغيرة من جلد نابا مزودة بزر إغلاق مغناطيسي وفتحات رفيعة للبطاقات.','<p>جلد نابا ناعم. حواف مخيطة يدويًا. يمكنه حمل البطاقات والنقود والهاتف.</p>'),('ar',17,'حقيبة صغيرة من جلد نابا مع زر',NULL,'حقيبة صغيرة من جلد نابا مزودة بزر إغلاق مغناطيسي وفتحات رفيعة للبطاقات.','<p>جلد نابا ناعم. حواف مخيطة يدويًا. يمكنه حمل البطاقات والنقود والهاتف.</p>'),('ar',18,'حقيبة صغيرة من جلد نابا مع زر',NULL,'حقيبة صغيرة من جلد نابا مزودة بزر إغلاق مغناطيسي وفتحات رفيعة للبطاقات.','<p>جلد نابا ناعم. حواف مخيطة يدويًا. يمكنه حمل البطاقات والنقود والهاتف.</p>'),('ar',19,'حقيبة كروس جلدية',NULL,'حقيبة كروس من الجلد الناعم مع أحزمة قابلة للتعديل، وإبزيم معدني ذهبي اللون، وثلاث فتحات للبطاقات.','<p>جلد إيطالي محبب بالكامل. حافة الحقيبة مرسومة باليد. مناسب لكل من الأنماط اليومية والرسمية.</p>'),('ar',20,'حقيبة كروس جلدية',NULL,'حقيبة كروس من الجلد الناعم مع أحزمة قابلة للتعديل، وإبزيم معدني ذهبي اللون، وثلاث فتحات للبطاقات.','<p>جلد إيطالي محبب بالكامل. حافة الحقيبة مرسومة باليد. مناسب لكل من الأنماط اليومية والرسمية.</p>'),('ar',21,'القفازات الكشمير',NULL,'قفازات مبطنة بالكشمير مع راحة يد جلدية وأساور مطاطية للأيام الباردة.','<p> بطانة من الكشمير المنغولي بنسبة 100%. راحة اليد من جلد الخراف من أجل الإمساك والمتانة. مقاس للجنسين.</p>'),('ar',22,'القفازات الكشمير',NULL,'قفازات مبطنة بالكشمير مع راحة يد جلدية وأساور مطاطية للأيام الباردة.','<p> بطانة من الكشمير المنغولي بنسبة 100%. راحة اليد من جلد الخراف من أجل الإمساك والمتانة. مقاس للجنسين.</p>'),('ar',23,'القفازات الكشمير',NULL,'قفازات مبطنة بالكشمير مع راحة يد جلدية وأساور مطاطية للأيام الباردة.','<p> بطانة من الكشمير المنغولي بنسبة 100%. راحة اليد من جلد الخراف من أجل الإمساك والمتانة. مقاس للجنسين.</p>'),('ar',24,'محفظة منقوشة',NULL,'محفظة جلدية ثنائية الطي مع نقش مونوغرام منقوش رقيق، وستة أقسام للبطاقات وقسم واحد للعملات المعدنية.','<p>جلد نباتي. بطانة مضادة للسرقة RFID. حواف مرسومة يدويًا ونقاط ضغط معززة.</p>'),('ar',25,'محفظة منقوشة',NULL,'محفظة جلدية ثنائية الطي مع نقش مونوغرام منقوش رقيق، وستة أقسام للبطاقات وقسم واحد للعملات المعدنية.','<p>جلد نباتي. بطانة مضادة للسرقة RFID. حواف مرسومة يدويًا ونقاط ضغط معززة.</p>'),('fr',1,'Sac fourre-tout en daim',NULL,'Grand sac cabas en daim avec poignées supérieures, fermeture magnétique et poche non doublée.','<p>Daim brossé marron expresso. Peut contenir un ordinateur portable de 15 pouces, un dossier et une bouteille d\'eau. La base du pied en cuivre protège le fond du sac de l\'abrasion.</p>'),('fr',2,'Mini sac en daim',NULL,'Petit sac bandoulière en daim avec chaîne et rabat ton sur ton.','<p>Peut contenir un téléphone, des cartes et du rouge à lèvres. La chaîne s\'ajuste de 22 à 24 pouces. Doublure en tissu de coton Drill.</p>'),('fr',3,'Mini sac à bandoulière Sue',NULL,'Sac bandoulière en cuir lisse avec bretelles réglables, boucle en métal doré et trois fentes pour cartes.','<p>Cuir pleine fleur italien. Bord du sac peint à la main. Convient aux styles quotidiens et formels.</p>'),('fr',4,'Sac fourre-tout en peau de mouton retournée et en daim',NULL,'Sac fourre-tout en daim doux avec bordure en polaire, poignées supérieures et poche spacieuse.','<p>Corps de sac en daim doux avec col en polaire chaude. Verrouillage par bouton magnétique. Convient à un ordinateur portable de 13 pouces et à des objets du quotidien.</p>'),('fr',5,'Petite pochette en cuir nappa avec bouton',NULL,'Sac compact en cuir nappa avec fermeture à bouton magnétique et fines fentes pour cartes.','<p>Cuir nappa souple. Bords cousus main. Peut contenir des cartes, de l\'argent liquide et un téléphone.</p>'),('fr',6,'Boucles d\'oreilles en forme de longue feuille',NULL,'Les boucles d\'oreilles pendantes en forme de feuille sont sculptées avec une finition dorée brillante.','<p>Bronze coulé léger avec fermoir anti-allergique. Finition artisanale. Livré avec un sac en velours.</p>'),('fr',7,'Sac bandoulière en cuir',NULL,'Sac bandoulière en cuir lisse avec bretelles réglables, boucle en métal doré et trois fentes pour cartes.','<p>Cuir pleine fleur italien. Bord du sac peint à la main. Convient aux styles quotidiens et formels.</p>'),('fr',8,'Sac bowling en daim',NULL,'Silhouette de sac bowling doux en daim grainé avec fermeture éclair sur le dessus et poignées latérales.','<p>Le sac est spacieux avec un compartiment zippé et deux compartiments cage. Peut contenir des tablettes, des planificateurs et des fournitures de nuit.</p>'),('fr',9,'Mitaines en Cachemire',NULL,'Gants doublés en cachemire avec paume en cuir et poignets élastiqués pour les journées froides.','<p>Doublure 100% cachemire mongol. Paume en cuir d\'agneau pour plus d\'adhérence et de durabilité. Taille unisexe.</p>'),('fr',10,'Portefeuille en relief',NULL,'Portefeuille en cuir à deux volets avec délicat motif monogramme en relief, six compartiments pour cartes et un compartiment pour la monnaie.','<p>Cuir végétal. Doublure antivol RFID. Bords peints à la main et points de pression renforcés.</p>'),('fr',11,'Mini sac en daim',NULL,'Petit sac bandoulière en daim avec chaîne et rabat ton sur ton.','<p>Peut contenir un téléphone, des cartes et du rouge à lèvres. La chaîne s\'ajuste de 22 à 24 pouces. Doublure en tissu de coton Drill.</p>'),('fr',12,'Mini sac en daim',NULL,'Petit sac bandoulière en daim avec chaîne et rabat ton sur ton.','<p>Peut contenir un téléphone, des cartes et du rouge à lèvres. La chaîne s\'ajuste de 22 à 24 pouces. Doublure en tissu de coton Drill.</p>'),('fr',13,'Mini sac en daim',NULL,'Petit sac bandoulière en daim avec chaîne et rabat ton sur ton.','<p>Peut contenir un téléphone, des cartes et du rouge à lèvres. La chaîne s\'ajuste de 22 à 24 pouces. Doublure en tissu de coton Drill.</p>'),('fr',14,'Mini sac en daim',NULL,'Petit sac bandoulière en daim avec chaîne et rabat ton sur ton.','<p>Peut contenir un téléphone, des cartes et du rouge à lèvres. La chaîne s\'ajuste de 22 à 24 pouces. Doublure en tissu de coton Drill.</p>'),('fr',15,'Mini sac à bandoulière Sue',NULL,'Sac bandoulière en cuir lisse avec bretelles réglables, boucle en métal doré et trois fentes pour cartes.','<p>Cuir pleine fleur italien. Bord du sac peint à la main. Convient aux styles quotidiens et formels.</p>'),('fr',16,'Petite pochette en cuir nappa avec bouton',NULL,'Sac compact en cuir nappa avec fermeture à bouton magnétique et fines fentes pour cartes.','<p>Cuir nappa souple. Bords cousus main. Peut contenir des cartes, de l\'argent liquide et un téléphone.</p>'),('fr',17,'Petite pochette en cuir nappa avec bouton',NULL,'Sac compact en cuir nappa avec fermeture à bouton magnétique et fines fentes pour cartes.','<p>Cuir nappa souple. Bords cousus main. Peut contenir des cartes, de l\'argent liquide et un téléphone.</p>'),('fr',18,'Petite pochette en cuir nappa avec bouton',NULL,'Sac compact en cuir nappa avec fermeture à bouton magnétique et fines fentes pour cartes.','<p>Cuir nappa souple. Bords cousus main. Peut contenir des cartes, de l\'argent liquide et un téléphone.</p>'),('fr',19,'Sac bandoulière en cuir',NULL,'Sac bandoulière en cuir lisse avec bretelles réglables, boucle en métal doré et trois fentes pour cartes.','<p>Cuir pleine fleur italien. Bord du sac peint à la main. Convient aux styles quotidiens et formels.</p>'),('fr',20,'Sac bandoulière en cuir',NULL,'Sac bandoulière en cuir lisse avec bretelles réglables, boucle en métal doré et trois fentes pour cartes.','<p>Cuir pleine fleur italien. Bord du sac peint à la main. Convient aux styles quotidiens et formels.</p>'),('fr',21,'Mitaines en Cachemire',NULL,'Gants doublés en cachemire avec paume en cuir et poignets élastiqués pour les journées froides.','<p>Doublure 100% cachemire mongol. Paume en cuir d\'agneau pour plus d\'adhérence et de durabilité. Taille unisexe.</p>'),('fr',22,'Mitaines en Cachemire',NULL,'Gants doublés en cachemire avec paume en cuir et poignets élastiqués pour les journées froides.','<p>Doublure 100% cachemire mongol. Paume en cuir d\'agneau pour plus d\'adhérence et de durabilité. Taille unisexe.</p>'),('fr',23,'Mitaines en Cachemire',NULL,'Gants doublés en cachemire avec paume en cuir et poignets élastiqués pour les journées froides.','<p>Doublure 100% cachemire mongol. Paume en cuir d\'agneau pour plus d\'adhérence et de durabilité. Taille unisexe.</p>'),('fr',24,'Portefeuille en relief',NULL,'Portefeuille en cuir à deux volets avec délicat motif monogramme en relief, six compartiments pour cartes et un compartiment pour la monnaie.','<p>Cuir végétal. Doublure antivol RFID. Bords peints à la main et points de pression renforcés.</p>'),('fr',25,'Portefeuille en relief',NULL,'Portefeuille en cuir à deux volets avec délicat motif monogramme en relief, six compartiments pour cartes et un compartiment pour la monnaie.','<p>Cuir végétal. Doublure antivol RFID. Bords peints à la main et points de pression renforcés.</p>'),('id',1,'Tas Jinjing Suede',NULL,'Tas jinjing suede besar dengan pegangan atas, penutup magnet, dan saku tanpa garis.','<p>Suede warna coklat espresso. Dapat menampung laptop 15 inci, folder dan botol air. Alas kaki tembaga melindungi bagian bawah tas dari abrasi.</p>'),('id',2,'Tas Mini Suede',NULL,'Tas bahu suede kecil dengan rantai dan penutup warna senada.','<p>Dapat menampung ponsel, kartu, dan lipstik. Rantai menyesuaikan dari 22 hingga 24 inci. Lapisan kain katun bor.</p>'),('id',3,'Tas Selempang Mini Sue',NULL,'Tas selempang kulit halus dengan tali pengikat yang dapat disesuaikan, gesper logam warna emas, dan tiga slot kartu.','<p>Kulit gandum penuh Italia. Tepi tas yang dilukis dengan tangan. Cocok untuk gaya sehari-hari maupun formal.</p>'),('id',4,'Tas Jinjing Shearling-Suede',NULL,'Tas jinjing berbahan suede lembut dengan trim bulu domba dengan pegangan atas dan saku luas.','<p>Bodi tas suede lembut dengan kerah bulu hangat. Kunci tombol magnetik. Cocok untuk laptop 13 inci dan barang sehari-hari.</p>'),('id',5,'Kantong Kulit Nappa Kecil Dengan Kancing',NULL,'Tas kulit nappa ringkas dengan penutup kancing magnetis dan slot kartu ramping.','<p>Kulit nappa lembut. Tepinya dijahit dengan tangan. Dapat menyimpan kartu, uang tunai dan telepon.</p>'),('id',6,'Anting Berbentuk Daun Panjang',NULL,'Anting drop berbentuk daun dipahat dengan lapisan emas mengkilap.','<p>Perunggu cor ringan dengan gesper anti alergi. Penyelesaian buatan tangan. Dilengkapi dengan tas beludru.</p>'),('id',7,'Tas Selempang Kulit',NULL,'Tas selempang kulit halus dengan tali pengikat yang dapat disesuaikan, gesper logam warna emas, dan tiga slot kartu.','<p>Kulit gandum penuh Italia. Tepi tas yang dilukis dengan tangan. Cocok untuk gaya sehari-hari maupun formal.</p>'),('id',8,'Tas Bowling Suede',NULL,'Siluet tas bowling lembut dari bahan suede berbutir dengan ritsleting atas dan pegangan samping.','<p>Tasnya luas dengan satu kompartemen ritsleting dan dua kompartemen kandang. Menyimpan tablet, agenda, dan perlengkapan semalam.</p>'),('id',9,'Sarung Tangan Kasmir',NULL,'Sarung tangan berlapis kasmir dengan telapak kulit dan manset elastis untuk hari dingin.','<p>100% lapisan kasmir Mongolia. Telapak tangan kulit domba untuk cengkeraman dan daya tahan. Ukuran uniseks.</p>'),('id',10,'Dompet Timbul',NULL,'Dompet kulit lipat dua dengan pola monogram timbul halus, enam kompartemen kartu, dan satu kompartemen koin.','<p>Kulit sayur. Lapisan anti maling RFID. Tepi yang dilukis dengan tangan dan titik tekanan yang diperkuat.</p>'),('id',11,'Tas Mini Suede',NULL,'Tas bahu suede kecil dengan rantai dan penutup warna senada.','<p>Dapat menampung ponsel, kartu, dan lipstik. Rantai menyesuaikan dari 22 hingga 24 inci. Lapisan kain katun bor.</p>'),('id',12,'Tas Mini Suede',NULL,'Tas bahu suede kecil dengan rantai dan penutup warna senada.','<p>Dapat menampung ponsel, kartu, dan lipstik. Rantai menyesuaikan dari 22 hingga 24 inci. Lapisan kain katun bor.</p>'),('id',13,'Tas Mini Suede',NULL,'Tas bahu suede kecil dengan rantai dan penutup warna senada.','<p>Dapat menampung ponsel, kartu, dan lipstik. Rantai menyesuaikan dari 22 hingga 24 inci. Lapisan kain katun bor.</p>'),('id',14,'Tas Mini Suede',NULL,'Tas bahu suede kecil dengan rantai dan penutup warna senada.','<p>Dapat menampung ponsel, kartu, dan lipstik. Rantai menyesuaikan dari 22 hingga 24 inci. Lapisan kain katun bor.</p>'),('id',15,'Tas Selempang Mini Sue',NULL,'Tas selempang kulit halus dengan tali pengikat yang dapat disesuaikan, gesper logam warna emas, dan tiga slot kartu.','<p>Kulit gandum penuh Italia. Tepi tas yang dilukis dengan tangan. Cocok untuk gaya sehari-hari maupun formal.</p>'),('id',16,'Kantong Kulit Nappa Kecil Dengan Kancing',NULL,'Tas kulit nappa ringkas dengan penutup kancing magnetis dan slot kartu ramping.','<p>Kulit nappa lembut. Tepinya dijahit dengan tangan. Dapat menyimpan kartu, uang tunai dan telepon.</p>'),('id',17,'Kantong Kulit Nappa Kecil Dengan Kancing',NULL,'Tas kulit nappa ringkas dengan penutup kancing magnetis dan slot kartu ramping.','<p>Kulit nappa lembut. Tepinya dijahit dengan tangan. Dapat menyimpan kartu, uang tunai dan telepon.</p>'),('id',18,'Kantong Kulit Nappa Kecil Dengan Kancing',NULL,'Tas kulit nappa ringkas dengan penutup kancing magnetis dan slot kartu ramping.','<p>Kulit nappa lembut. Tepinya dijahit dengan tangan. Dapat menyimpan kartu, uang tunai dan telepon.</p>'),('id',19,'Tas Selempang Kulit',NULL,'Tas selempang kulit halus dengan tali pengikat yang dapat disesuaikan, gesper logam warna emas, dan tiga slot kartu.','<p>Kulit gandum penuh Italia. Tepi tas yang dilukis dengan tangan. Cocok untuk gaya sehari-hari maupun formal.</p>'),('id',20,'Tas Selempang Kulit',NULL,'Tas selempang kulit halus dengan tali pengikat yang dapat disesuaikan, gesper logam warna emas, dan tiga slot kartu.','<p>Kulit gandum penuh Italia. Tepi tas yang dilukis dengan tangan. Cocok untuk gaya sehari-hari maupun formal.</p>'),('id',21,'Sarung Tangan Kasmir',NULL,'Sarung tangan berlapis kasmir dengan telapak kulit dan manset elastis untuk hari dingin.','<p>100% lapisan kasmir Mongolia. Telapak tangan kulit domba untuk cengkeraman dan daya tahan. Ukuran uniseks.</p>'),('id',22,'Sarung Tangan Kasmir',NULL,'Sarung tangan berlapis kasmir dengan telapak kulit dan manset elastis untuk hari dingin.','<p>100% lapisan kasmir Mongolia. Telapak tangan kulit domba untuk cengkeraman dan daya tahan. Ukuran uniseks.</p>'),('id',23,'Sarung Tangan Kasmir',NULL,'Sarung tangan berlapis kasmir dengan telapak kulit dan manset elastis untuk hari dingin.','<p>100% lapisan kasmir Mongolia. Telapak tangan kulit domba untuk cengkeraman dan daya tahan. Ukuran uniseks.</p>'),('id',24,'Dompet Timbul',NULL,'Dompet kulit lipat dua dengan pola monogram timbul halus, enam kompartemen kartu, dan satu kompartemen koin.','<p>Kulit sayur. Lapisan anti maling RFID. Tepi yang dilukis dengan tangan dan titik tekanan yang diperkuat.</p>'),('id',25,'Dompet Timbul',NULL,'Dompet kulit lipat dua dengan pola monogram timbul halus, enam kompartemen kartu, dan satu kompartemen koin.','<p>Kulit sayur. Lapisan anti maling RFID. Tepi yang dilukis dengan tangan dan titik tekanan yang diperkuat.</p>'),('tr',1,'Süet Kadın Çantası',NULL,'Üstten saplı, mıknatıslı kapamalı ve astarsız cepli büyük süet tote çanta.','<p>Espresso kahverengi fırçalanmış süet. 15 inçlik bir dizüstü bilgisayarı, klasörü ve su şişesini tutabilir. Bakır ayak tabanı çanta tabanını aşınmaya karşı korur.</p>'),('tr',2,'Süet Mini Çanta',NULL,'Zincirli ve renkli kapaklı küçük süet omuz çantası.','<p>Telefonu, kartları ve ruju tutabilir. Zincir 22 ila 24 inç arasında ayarlanır. Pamuklu kumaş astarı delin.</p>'),('tr',3,'Mini Sue Çapraz Çanta',NULL,'Ayarlanabilir askılı, altın rengi metal tokalı, üç kart bölmeli, pürüzsüz deri çapraz askılı çanta.','<p>İtalyan sırçalı deri. Elle boyanmış çantanın kenarı. Hem gündelik hem de resmi tarzlara uygundur.</p>'),('tr',4,'Kürk-Süet Tote Çanta',NULL,'Üstten saplı, geniş cepli, polar şeritli, yumuşak süet tote çanta.','<p>Sıcak tutan polar yakalı, yumuşak süet çanta gövdesi. Manyetik düğme kilidi. 13 inçlik bir dizüstü bilgisayara ve günlük eşyalara uygundur.</p>'),('tr',5,'Düğmeli Küçük Nappa Deri Kese',NULL,'Manyetik düğme kapatmalı ve ince kart yuvalı kompakt Nappa deri çanta.','<p>Yumuşak nappa deri. Elle dikilmiş kenarlar. Kartları, nakit parayı ve telefonu tutabilir.</p>'),('tr',6,'Uzun Yaprak Şekilli Küpe',NULL,'Yaprak şeklindeki damla küpeler parlak altın kaplamayla şekillendirilmiştir.','<p>Anti-alerji tokalı hafif döküm bronz. El işi bitirme. Kadife çantasıyla birlikte gelir.</p>'),('tr',7,'Deri Çapraz Çanta',NULL,'Ayarlanabilir askılı, altın rengi metal tokalı, üç kart bölmeli, pürüzsüz deri çapraz askılı çanta.','<p>İtalyan sırçalı deri. Elle boyanmış çantanın kenarı. Hem gündelik hem de resmi tarzlara uygundur.</p>'),('tr',8,'Süet Bowling Çantası',NULL,'Damarlı süetten, üstten fermuarlı ve yan saplı yumuşak bowling çantası silueti.','<p>Çanta bir fermuarlı bölmesi ve iki kafes bölmesiyle oldukça geniştir. Tabletleri, planlayıcıları ve gecelik malzemeleri barındırır.</p>'),('tr',9,'Kaşmir Eldivenler',NULL,'Soğuk günler için avuç içi deri ve elastik manşetli, kaşmir astarlı eldiven.','<p>100% Moğol kaşmir astarı. Kavrama ve dayanıklılık için kuzu derisi avuç içi. Üniseks beden.</p>'),('tr',10,'Kabartmalı Cüzdan',NULL,'Narin kabartmalı monogram desenli, altı kart bölmeli ve bir bozuk para bölmeli, ikiye katlanmış deri cüzdan.','<p>Bitkisel deri. RFID hırsızlığa karşı astar. Elle boyanmış kenarlar ve güçlendirilmiş baskı noktaları.</p>'),('tr',11,'Süet Mini Çanta',NULL,'Zincirli ve renkli kapaklı küçük süet omuz çantası.','<p>Telefonu, kartları ve ruju tutabilir. Zincir 22 ila 24 inç arasında ayarlanır. Pamuklu kumaş astarı delin.</p>'),('tr',12,'Süet Mini Çanta',NULL,'Zincirli ve renkli kapaklı küçük süet omuz çantası.','<p>Telefonu, kartları ve ruju tutabilir. Zincir 22 ila 24 inç arasında ayarlanır. Pamuklu kumaş astarı delin.</p>'),('tr',13,'Süet Mini Çanta',NULL,'Zincirli ve renkli kapaklı küçük süet omuz çantası.','<p>Telefonu, kartları ve ruju tutabilir. Zincir 22 ila 24 inç arasında ayarlanır. Pamuklu kumaş astarı delin.</p>'),('tr',14,'Süet Mini Çanta',NULL,'Zincirli ve renkli kapaklı küçük süet omuz çantası.','<p>Telefonu, kartları ve ruju tutabilir. Zincir 22 ila 24 inç arasında ayarlanır. Pamuklu kumaş astarı delin.</p>'),('tr',15,'Mini Sue Çapraz Çanta',NULL,'Ayarlanabilir askılı, altın rengi metal tokalı, üç kart bölmeli, pürüzsüz deri çapraz askılı çanta.','<p>İtalyan sırçalı deri. Elle boyanmış çantanın kenarı. Hem gündelik hem de resmi tarzlara uygundur.</p>'),('tr',16,'Düğmeli Küçük Nappa Deri Kese',NULL,'Manyetik düğme kapatmalı ve ince kart yuvalı kompakt Nappa deri çanta.','<p>Yumuşak nappa deri. Elle dikilmiş kenarlar. Kartları, nakit parayı ve telefonu tutabilir.</p>'),('tr',17,'Düğmeli Küçük Nappa Deri Kese',NULL,'Manyetik düğme kapatmalı ve ince kart yuvalı kompakt Nappa deri çanta.','<p>Yumuşak nappa deri. Elle dikilmiş kenarlar. Kartları, nakit parayı ve telefonu tutabilir.</p>'),('tr',18,'Düğmeli Küçük Nappa Deri Kese',NULL,'Manyetik düğme kapatmalı ve ince kart yuvalı kompakt Nappa deri çanta.','<p>Yumuşak nappa deri. Elle dikilmiş kenarlar. Kartları, nakit parayı ve telefonu tutabilir.</p>'),('tr',19,'Deri Çapraz Çanta',NULL,'Ayarlanabilir askılı, altın rengi metal tokalı, üç kart bölmeli, pürüzsüz deri çapraz askılı çanta.','<p>İtalyan sırçalı deri. Elle boyanmış çantanın kenarı. Hem gündelik hem de resmi tarzlara uygundur.</p>'),('tr',20,'Deri Çapraz Çanta',NULL,'Ayarlanabilir askılı, altın rengi metal tokalı, üç kart bölmeli, pürüzsüz deri çapraz askılı çanta.','<p>İtalyan sırçalı deri. Elle boyanmış çantanın kenarı. Hem gündelik hem de resmi tarzlara uygundur.</p>'),('tr',21,'Kaşmir Eldivenler',NULL,'Soğuk günler için avuç içi deri ve elastik manşetli, kaşmir astarlı eldiven.','<p>100% Moğol kaşmir astarı. Kavrama ve dayanıklılık için kuzu derisi avuç içi. Üniseks beden.</p>'),('tr',22,'Kaşmir Eldivenler',NULL,'Soğuk günler için avuç içi deri ve elastik manşetli, kaşmir astarlı eldiven.','<p>100% Moğol kaşmir astarı. Kavrama ve dayanıklılık için kuzu derisi avuç içi. Üniseks beden.</p>'),('tr',23,'Kaşmir Eldivenler',NULL,'Soğuk günler için avuç içi deri ve elastik manşetli, kaşmir astarlı eldiven.','<p>100% Moğol kaşmir astarı. Kavrama ve dayanıklılık için kuzu derisi avuç içi. Üniseks beden.</p>'),('tr',24,'Kabartmalı Cüzdan',NULL,'Narin kabartmalı monogram desenli, altı kart bölmeli ve bir bozuk para bölmeli, ikiye katlanmış deri cüzdan.','<p>Bitkisel deri. RFID hırsızlığa karşı astar. Elle boyanmış kenarlar ve güçlendirilmiş baskı noktaları.</p>'),('tr',25,'Kabartmalı Cüzdan',NULL,'Narin kabartmalı monogram desenli, altı kart bölmeli ve bir bozuk para bölmeli, ikiye katlanmış deri cüzdan.','<p>Bitkisel deri. RFID hırsızlığa karşı astar. Elle boyanmış kenarlar ve güçlendirilmiş baskı noktaları.</p>'),('vi',1,'Túi Tote Da Lộn',NULL,'Túi tote da lộn cỡ lớn với cặp quai trên, nút bấm nam châm và lòng túi không lót.','<p>Da lộn chải màu nâu espresso. Đựng được laptop 15 inch, bìa kẹp tài liệu và bình nước. Đế chân đồng bảo vệ đáy túi khỏi mài mòn.</p>'),('vi',2,'Túi Mini Da Lộn',NULL,'Túi đeo vai da lộn nhỏ nhắn với dây xích và nắp gập cùng tông màu.','<p>Đựng được điện thoại, thẻ và son môi. Dây xích điều chỉnh từ 22 đến 24 inch. Lót vải cotton drill.</p>'),('vi',3,'Túi Đeo Chéo Mini Sue',NULL,'Túi đeo chéo da mịn với dây điều chỉnh được, khóa kim loại màu vàng và ba ngăn đựng thẻ.','<p>Da nguyên tấm của Ý. Cạnh túi sơn thủ công. Phù hợp với cả phong cách hằng ngày lẫn trang trọng.</p>'),('vi',4,'Túi Tote Da Lộn Viền Lông Cừu',NULL,'Túi tote da lộn viền lông cừu mềm mại với cặp quai trên và lòng túi rộng rãi.','<p>Thân túi da lộn mềm mại với cổ túi lông cừu ấm áp. Khóa nút bấm nam châm. Đựng vừa laptop 13 inch và các vật dụng hằng ngày.</p>'),('vi',5,'Túi Da Nappa Nhỏ Có Nút',NULL,'Túi da nappa nhỏ gọn với khóa nút nam châm và các ngăn đựng thẻ mỏng.','<p>Da nappa mềm mại. Cạnh khâu tay. Đựng được thẻ, tiền mặt và điện thoại.</p>'),('vi',6,'Bông Tai Hình Chiếc Lá Dài',NULL,'Bông tai thả hình chiếc lá được tạo hình điêu khắc với lớp hoàn thiện vàng bóng.','<p>Đồng đúc nhẹ với chốt cài chống dị ứng. Hoàn thiện thủ công. Kèm theo túi nhung.</p>'),('vi',7,'Túi Đeo Chéo Da',NULL,'Túi đeo chéo da mịn với dây điều chỉnh được, khóa kim loại màu vàng và ba ngăn đựng thẻ.','<p>Da nguyên tấm của Ý. Cạnh túi sơn thủ công. Phù hợp với cả phong cách hằng ngày lẫn trang trọng.</p>'),('vi',8,'Túi Bowling Da Lộn',NULL,'Dáng túi bowling mềm mại bằng da lộn sần với khóa kéo trên và quai cầm hai bên.','<p>Lòng túi rộng rãi với một ngăn khóa kéo và hai ngăn lồng. Đựng được máy tính bảng, sổ kế hoạch và vật dụng qua đêm.</p>'),('vi',9,'Găng Tay Bao Cashmere',NULL,'Găng tay bao lót cashmere với lòng bàn tay bằng da và cổ tay co giãn cho những ngày lạnh giá.','<p>Lớp lót 100% cashmere Mông Cổ. Lòng bàn tay da cừu cho độ bám và độ bền. Kích cỡ unisex.</p>'),('vi',10,'Ví Dập Nổi',NULL,'Ví da gập đôi với họa tiết monogram dập nổi tinh tế, sáu ngăn đựng thẻ và một ngăn đựng tiền xu.','<p>Da thuộc thực vật. Lớp lót chống đọc trộm RFID. Cạnh sơn thủ công và các điểm chịu lực được may gia cố.</p>'),('vi',11,'Túi Mini Da Lộn',NULL,'Túi đeo vai da lộn nhỏ nhắn với dây xích và nắp gập cùng tông màu.','<p>Đựng được điện thoại, thẻ và son môi. Dây xích điều chỉnh từ 22 đến 24 inch. Lót vải cotton drill.</p>'),('vi',12,'Túi Mini Da Lộn',NULL,'Túi đeo vai da lộn nhỏ nhắn với dây xích và nắp gập cùng tông màu.','<p>Đựng được điện thoại, thẻ và son môi. Dây xích điều chỉnh từ 22 đến 24 inch. Lót vải cotton drill.</p>'),('vi',13,'Túi Mini Da Lộn',NULL,'Túi đeo vai da lộn nhỏ nhắn với dây xích và nắp gập cùng tông màu.','<p>Đựng được điện thoại, thẻ và son môi. Dây xích điều chỉnh từ 22 đến 24 inch. Lót vải cotton drill.</p>'),('vi',14,'Túi Mini Da Lộn',NULL,'Túi đeo vai da lộn nhỏ nhắn với dây xích và nắp gập cùng tông màu.','<p>Đựng được điện thoại, thẻ và son môi. Dây xích điều chỉnh từ 22 đến 24 inch. Lót vải cotton drill.</p>'),('vi',15,'Túi Đeo Chéo Mini Sue',NULL,'Túi đeo chéo da mịn với dây điều chỉnh được, khóa kim loại màu vàng và ba ngăn đựng thẻ.','<p>Da nguyên tấm của Ý. Cạnh túi sơn thủ công. Phù hợp với cả phong cách hằng ngày lẫn trang trọng.</p>'),('vi',16,'Túi Da Nappa Nhỏ Có Nút',NULL,'Túi da nappa nhỏ gọn với khóa nút nam châm và các ngăn đựng thẻ mỏng.','<p>Da nappa mềm mại. Cạnh khâu tay. Đựng được thẻ, tiền mặt và điện thoại.</p>'),('vi',17,'Túi Da Nappa Nhỏ Có Nút',NULL,'Túi da nappa nhỏ gọn với khóa nút nam châm và các ngăn đựng thẻ mỏng.','<p>Da nappa mềm mại. Cạnh khâu tay. Đựng được thẻ, tiền mặt và điện thoại.</p>'),('vi',18,'Túi Da Nappa Nhỏ Có Nút',NULL,'Túi da nappa nhỏ gọn với khóa nút nam châm và các ngăn đựng thẻ mỏng.','<p>Da nappa mềm mại. Cạnh khâu tay. Đựng được thẻ, tiền mặt và điện thoại.</p>'),('vi',19,'Túi Đeo Chéo Da',NULL,'Túi đeo chéo da mịn với dây điều chỉnh được, khóa kim loại màu vàng và ba ngăn đựng thẻ.','<p>Da nguyên tấm của Ý. Cạnh túi sơn thủ công. Phù hợp với cả phong cách hằng ngày lẫn trang trọng.</p>'),('vi',20,'Túi Đeo Chéo Da',NULL,'Túi đeo chéo da mịn với dây điều chỉnh được, khóa kim loại màu vàng và ba ngăn đựng thẻ.','<p>Da nguyên tấm của Ý. Cạnh túi sơn thủ công. Phù hợp với cả phong cách hằng ngày lẫn trang trọng.</p>'),('vi',21,'Găng Tay Bao Cashmere',NULL,'Găng tay bao lót cashmere với lòng bàn tay bằng da và cổ tay co giãn cho những ngày lạnh giá.','<p>Lớp lót 100% cashmere Mông Cổ. Lòng bàn tay da cừu cho độ bám và độ bền. Kích cỡ unisex.</p>'),('vi',22,'Găng Tay Bao Cashmere',NULL,'Găng tay bao lót cashmere với lòng bàn tay bằng da và cổ tay co giãn cho những ngày lạnh giá.','<p>Lớp lót 100% cashmere Mông Cổ. Lòng bàn tay da cừu cho độ bám và độ bền. Kích cỡ unisex.</p>'),('vi',23,'Găng Tay Bao Cashmere',NULL,'Găng tay bao lót cashmere với lòng bàn tay bằng da và cổ tay co giãn cho những ngày lạnh giá.','<p>Lớp lót 100% cashmere Mông Cổ. Lòng bàn tay da cừu cho độ bám và độ bền. Kích cỡ unisex.</p>'),('vi',24,'Ví Dập Nổi',NULL,'Ví da gập đôi với họa tiết monogram dập nổi tinh tế, sáu ngăn đựng thẻ và một ngăn đựng tiền xu.','<p>Da thuộc thực vật. Lớp lót chống đọc trộm RFID. Cạnh sơn thủ công và các điểm chịu lực được may gia cố.</p>'),('vi',25,'Ví Dập Nổi',NULL,'Ví da gập đôi với họa tiết monogram dập nổi tinh tế, sáu ngăn đựng thẻ và một ngăn đựng tiền xu.','<p>Da thuộc thực vật. Lớp lót chống đọc trộm RFID. Cạnh sơn thủ công và các điểm chịu lực được may gia cố.</p>');

--
-- Table structure for table `ec_review_replies`
--

CREATE TABLE `ec_review_replies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `customer_id` bigint unsigned DEFAULT NULL,
  `review_id` bigint unsigned NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_review_replies_review_id_unique` (`review_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_review_replies`
--


--
-- Table structure for table `ec_reviews`
--

CREATE TABLE `ec_reviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint unsigned DEFAULT NULL,
  `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_id` bigint unsigned NOT NULL,
  `star` double NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `badge_type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'auto',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `images` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ec_reviews_product_id_customer_id_unique` (`product_id`,`customer_id`),
  KEY `ec_reviews_product_id_customer_id_status_created_at_index` (`product_id`,`customer_id`,`status`,`created_at`),
  KEY `review_relation_index` (`product_id`,`customer_id`,`status`),
  KEY `ec_reviews_product_id_status_index` (`product_id`,`status`),
  KEY `ec_reviews_customer_id_status_index` (`customer_id`,`status`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_reviews` VALUES (1,9,NULL,NULL,3,1,'Clean & perfect source code','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(2,4,NULL,NULL,4,2,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(3,8,NULL,NULL,10,5,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(4,2,NULL,NULL,8,5,'The best ecommerce CMS! Excellent coding! best support service! Thank you so much..... I really like your hard work.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(5,3,NULL,NULL,3,5,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(6,10,NULL,NULL,8,1,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(7,2,NULL,NULL,3,3,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(8,10,NULL,NULL,3,1,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(9,7,NULL,NULL,5,4,'Clean & perfect source code','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(10,9,NULL,NULL,10,5,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(11,6,NULL,NULL,1,4,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(12,8,NULL,NULL,8,3,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(13,7,NULL,NULL,6,3,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(14,1,NULL,NULL,6,4,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(15,8,NULL,NULL,3,5,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(16,4,NULL,NULL,6,2,'These guys are amazing! Responses immediately, amazing support and help... I immediately feel at ease after Purchasing..','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(17,10,NULL,NULL,7,5,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(18,9,NULL,NULL,9,3,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(19,6,NULL,NULL,10,2,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(20,7,NULL,NULL,2,2,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(21,8,NULL,NULL,2,4,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(22,5,NULL,NULL,3,4,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(23,1,NULL,NULL,1,2,'Clean & perfect source code','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(24,6,NULL,NULL,3,4,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(25,2,NULL,NULL,5,5,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(26,3,NULL,NULL,9,5,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(27,3,NULL,NULL,6,5,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(28,7,NULL,NULL,9,5,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(29,7,NULL,NULL,4,2,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(30,6,NULL,NULL,2,4,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(31,7,NULL,NULL,10,1,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(32,4,NULL,NULL,7,4,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(33,10,NULL,NULL,9,1,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(34,5,NULL,NULL,2,4,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(35,5,NULL,NULL,1,4,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(36,3,NULL,NULL,8,1,'As a developer I reviewed this script. This is really awesome ecommerce script. I have convinced when I noticed that it\'s built on fully WordPress concept.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(37,7,NULL,NULL,3,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 19:00:02','2026-05-28 19:00:02',NULL),(38,8,NULL,NULL,1,5,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(39,6,NULL,NULL,4,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 19:00:02','2026-05-28 19:00:02',NULL),(40,10,NULL,NULL,4,5,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(41,5,NULL,NULL,6,3,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(42,4,NULL,NULL,1,2,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(43,4,NULL,NULL,5,4,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(44,2,NULL,NULL,4,5,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(45,2,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 19:00:02','2026-05-28 19:00:02',NULL),(46,10,NULL,NULL,6,1,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(47,4,NULL,NULL,8,4,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(48,10,NULL,NULL,1,5,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(49,9,NULL,NULL,7,1,'Clean & perfect source code','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(50,3,NULL,NULL,5,5,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(51,2,NULL,NULL,9,1,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(52,10,NULL,NULL,5,1,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(53,2,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 19:00:02','2026-05-28 19:00:02',NULL),(54,9,NULL,NULL,4,4,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(55,6,NULL,NULL,8,1,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(56,5,NULL,NULL,8,1,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(57,10,NULL,NULL,2,1,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(58,6,NULL,NULL,9,4,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(59,9,NULL,NULL,5,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 19:00:02','2026-05-28 19:00:02',NULL),(60,9,NULL,NULL,1,3,'This web app is really good in design, code quality & features. Besides, the customer support provided by the Botble team was really fast & helpful. You guys are awesome!','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(61,1,NULL,NULL,10,2,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(62,4,NULL,NULL,2,2,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(63,2,NULL,NULL,2,3,'The script is the best of its class, fast, easy to implement and work with , and the most important thing is the great support team , Recommend with no doubt.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(64,4,NULL,NULL,10,1,'Great E-commerce system. And much more : Wonderful Customer Support.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(65,1,NULL,NULL,7,5,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(66,9,NULL,NULL,2,1,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(67,8,NULL,NULL,7,4,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(68,7,NULL,NULL,7,1,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(69,7,NULL,NULL,1,5,'The code is good, in general, if you like it, can you give it 5 stars?','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(70,3,NULL,NULL,2,1,'Best ecommerce CMS online store!','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(71,6,NULL,NULL,7,4,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(72,1,NULL,NULL,4,3,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(73,3,NULL,NULL,10,5,'Amazing code, amazing support. Overall, im really confident in Botble and im happy I made the right choice! Thank you so much guys for coding this masterpiece','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(74,5,NULL,NULL,7,4,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(75,5,NULL,NULL,9,3,'Perfect +++++++++ i love it really also i get to fast ticket answers... Thanks Lot BOTBLE Teams','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(76,10,NULL,NULL,10,5,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(77,1,NULL,NULL,9,5,'The best store template! Excellent coding! Very good support! Thank you so much for all the help, I really appreciated.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(78,5,NULL,NULL,4,1,'Second or third time that I buy a Botble product, happy with the products and support. You guys do a good job :)','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(79,2,NULL,NULL,10,4,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(80,6,NULL,NULL,5,3,'Great system, great support, good job Botble. I\'m looking forward to more great functional plugins.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(81,5,NULL,NULL,5,4,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(82,3,NULL,NULL,4,2,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(83,8,NULL,NULL,4,2,'For me the best eCommerce script on Envato at this moment: modern, clean code, a lot of great features. The customer support is great too: I always get an answer within hours!','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(84,3,NULL,NULL,7,3,'Those guys now what they are doing, the release such a good product that it\'s a pleasure to work with ! Even when I was stuck on the project, I created a ticket and the next day it was replied by the team. GOOD JOB guys. I love working with them :)','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(85,8,NULL,NULL,6,3,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(86,2,NULL,NULL,1,1,'We have received brilliant service support and will be expanding the features with the developer. Nice product!','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(87,4,NULL,NULL,9,2,'Cool template. Excellent code quality. The support responds very quickly, which is very rare on themeforest and codecanyon.net, I buy a lot of templates, and everyone will have a response from technical support for two or three days. Thanks to tech support. I recommend to buy.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(88,7,NULL,NULL,8,4,'Clean & perfect source code','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(89,6,NULL,NULL,6,5,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(90,1,NULL,NULL,8,2,'Good app, good backup service and support. Good documentation.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(91,1,NULL,NULL,2,1,'I Love this Script. I also found how to add other fees. Now I just wait the BIG update for the Marketplace with the Bulk Import. Just do not forget to make it to be Multi-language for us the Botble Fans.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(92,5,NULL,NULL,10,5,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(93,3,NULL,NULL,1,2,'This script is well coded and is super fast. The support is pretty quick. Very patient and helpful team. I strongly recommend it and they deserve more than 5 stars.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(94,8,NULL,NULL,5,4,'Very enthusiastic support! Excellent code is written. It\'s a true pleasure working with.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(95,1,NULL,NULL,3,2,'It\'s not my first experience here on Codecanyon and I can honestly tell you all that Botble puts a LOT of effort into the support. They answer so fast, they helped me tons of times. REALLY by far THE BEST EXPERIENCE on Codecanyon. Those guys at Botble are so good that they deserve 5 stars. I recommend them, I trust them and I can\'t wait to see what they will sell in a near future. Thank you Botble :)','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(96,8,NULL,NULL,9,4,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(97,4,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 19:00:02','2026-05-28 19:00:02',NULL),(98,9,NULL,NULL,8,4,'Customer Support are grade (A*), however the code is a way too over engineered for it\'s purpose.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(99,1,NULL,NULL,5,4,'Solution is too robust for our purpose so we didn\'t use it at the end. But I appreciate customer support during initial configuration.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL),(100,9,NULL,NULL,6,3,'Ok good product. I have some issues in customizations. But its not correct to blame the developer. The product is good. Good luck for your business.','published','auto','2026-05-28 19:00:02','2026-05-28 19:00:02',NULL);

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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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

--
-- Dumping data for table `fob_product_size_guide_relations`
--


--
-- Table structure for table `fob_product_size_guides`
--

CREATE TABLE `fob_product_size_guides` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `table_headers` json DEFAULT NULL,
  `table_rows` json DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `order` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fob_psg_status_idx` (`status`),
  KEY `fob_psg_order_idx` (`order`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fob_product_size_guides`
--

INSERT INTO `fob_product_size_guides` VALUES (1,'Default Size Chart','<h6>Bust</h6><p>Measure around the fullest part of your bust.</p><h6>Waist</h6><p>Measure around the narrowest part of your torso.</p><h6>Low Hip</h6><p>With your feet together measure around the fullest part of your hips/rear.</p>',NULL,'[\"size\", \"us\", \"bust\", \"waist\", \"low-hip\"]','[[\"XS\", \"2\", \"32\", \"24 - 25\", \"33 - 34\"], [\"S\", \"4\", \"34 - 35\", \"26 - 27\", \"35 - 26\"], [\"M\", \"6\", \"36 - 37\", \"28 - 29\", \"38 - 40\"], [\"L\", \"8\", \"38 - 29\", \"30 - 31\", \"42 - 44\"], [\"XL\", \"10\", \"40 - 41\", \"32 - 33\", \"45 - 47\"], [\"XXL\", \"12\", \"42 - 43\", \"34 - 35\", \"48 - 50\"]]','published',0,'2026-05-28 18:59:51','2026-05-28 18:59:51');

--
