--
-- 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,'9R1AdJlIv01yOush5wIVZGTgplw0T1V9',1,'2026-05-28 19:06:14','2026-05-28 19:06:14','2026-05-28 19:06:14');

--
-- 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,'Care &amp; Cleaning',0,'Polishing, storage, and at-home rituals that keep gold, silver, and diamonds at their best.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2026-05-28 19:06:17','2026-05-28 19:06:17'),(2,'Investment Pieces',0,'Heritage motifs, certified diamonds, and jewelry built to outlast every trend cycle.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:06:17','2026-05-28 19:06:17'),(3,'Style Inspiration',0,'Layering, stacking, and pairing tips for everyday and occasion looks.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:06:17','2026-05-28 19:06:17'),(4,'Trends',0,'Yellow gold, mixed metals, and the silhouettes shaping each fine jewelry season.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:06:17','2026-05-28 19:06:17'),(5,'Buyer Guides',0,'Carat, cut, color, and clarity — practical guidance for jewelry purchases that matter.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:06:17','2026-05-28 19:06:17');

--
-- 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,'Care &amp; Cleaning','Polishing, storage, and at-home rituals that keep gold, silver, and diamonds at their best.'),('ar',2,'القطع الاستثمارية','تم تصميم الزخارف التراثية والماس المعتمد والمجوهرات لتتناسب مع كل دورة اتجاهات.'),('ar',3,'إلهام الأسلوب','لوحات الإلهام وقصص الألوان والغرف التي توضح ما هو ممكن.'),('ar',4,'الاتجاهات','تحدد الأبازيم المعدنية والأنماط وقصص الألوان كل موسم من الإكسسوارات.'),('ar',5,'أدلة المشتري','القيراط والقطع واللون والوضوح - دليل عملي لشراء المجوهرات المهمة.'),('fr',1,'Care &amp; Cleaning','Polishing, storage, and at-home rituals that keep gold, silver, and diamonds at their best.'),('fr',2,'Pièces d\'investissement','Motifs patrimoniaux, diamants certifiés et bijoux créés pour résister à tous les cycles de tendances.'),('fr',3,'Inspirations de style','Des tableaux d\'inspiration, des histoires de palettes de couleurs et des pièces qui montrent ce qui est possible.'),('fr',4,'Tendances','Les boucles métalliques, les styles et les histoires de couleurs définissent chaque saison d\'accessoires.'),('fr',5,'Guides d\'achat','Carat, taille, couleur et clarté — un guide pratique pour les achats importants de bijoux.'),('id',1,'Care &amp; Cleaning','Polishing, storage, and at-home rituals that keep gold, silver, and diamonds at their best.'),('id',2,'Potongan Investasi','Motif warisan, berlian bersertifikat, dan perhiasan diciptakan untuk menghadapi setiap siklus tren.'),('id',3,'Inspirasi Gaya','Papan inspirasi, cerita palet warna, dan ruangan yang menunjukkan apa yang mungkin.'),('id',4,'Tren','Gesper logam, gaya, dan kisah warna menentukan setiap musim aksesori.'),('id',5,'Panduan Pembeli','Karat, potongan, warna, dan kejernihan — panduan praktis untuk pembelian perhiasan penting.'),('tr',1,'Care &amp; Cleaning','Polishing, storage, and at-home rituals that keep gold, silver, and diamonds at their best.'),('tr',2,'Yatırım Parçaları','Her trend döngüsünü atlatmak için yaratılmış miras motifleri, sertifikalı pırlantalar ve mücevherler.'),('tr',3,'Stil İlhamı','Neyin mümkün olduğunu gösteren ilham panoları, renk paleti hikayeleri ve odalar.'),('tr',4,'Trendler','Metal tokalar, stiller ve renk hikayeleri her aksesuar sezonunu tanımlar.'),('tr',5,'Alıcı Kılavuzları','Karat, kesim, renk ve berraklık — önemli mücevher alımları için pratik bir rehber.'),('vi',1,'Care &amp; Cleaning','Polishing, storage, and at-home rituals that keep gold, silver, and diamonds at their best.'),('vi',2,'Món đồ đầu tư','Họa tiết di sản, kim cương được chứng nhận và trang sức được tạo ra để vượt qua mọi chu kỳ xu hướng.'),('vi',3,'Cảm Hứng Phong Cách','Bảng cảm hứng, câu chuyện về bảng màu và những căn phòng cho thấy điều gì là khả thi.'),('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,'Cẩm nang người mua','Carat, giác cắt, màu sắc và độ tinh khiết — hướng dẫn thiết thực cho những lần mua trang sức quan trọng.');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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


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

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

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

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

--
-- 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','Arizona','New York','456 Oak Avenue',1,1,'2026-05-28 19:06:27','2026-05-28 19:06:27','10001'),(2,'Emma Collins','customer@botble.com','+1-555-0107','CA','Georgia','Dallas','147 Elm Court',1,0,'2026-05-28 19:06:27','2026-05-28 19:06:27','80201'),(3,'Sophia Ramirez','vendor@botble.com','+1-555-0104','US','Arizona','Miami','654 Cedar Lane',2,1,'2026-05-28 19:06:27','2026-05-28 19:06:27','90210'),(4,'Sophia Ramirez','vendor@botble.com','+1-555-0108','GB','Pennsylvania','Phoenix','654 Cedar Lane',2,0,'2026-05-28 19:06:27','2026-05-28 19:06:27','60601'),(5,'Olivia Carter','customer1@example.com','+1-555-0110','US','Pennsylvania','New York','654 Cedar Lane',3,1,'2026-05-28 19:06:28','2026-05-28 19:06:28','19101'),(6,'Ava Mitchell','customer2@example.com','+1-555-0107','CA','Ohio','Miami','147 Elm Court',4,1,'2026-05-28 19:06:28','2026-05-28 19:06:28','30301'),(7,'Isabella Brooks','customer3@example.com','+1-555-0101','CA','Michigan','Houston','123 Main Street',5,1,'2026-05-28 19:06:28','2026-05-28 19:06:28','60601'),(8,'James Whitfield','customer4@example.com','+1-555-0107','CA','Arizona','New York','741 Spruce Street',6,1,'2026-05-28 19:06:28','2026-05-28 19:06:28','30301'),(9,'Liam Bennett','customer5@example.com','+1-555-0110','DE','Florida','Austin','147 Elm Court',7,1,'2026-05-28 19:06:29','2026-05-28 19:06:29','30301'),(10,'Noah Patterson','customer6@example.com','+1-555-0108','US','Texas','Phoenix','987 Birch Boulevard',8,1,'2026-05-28 19:06:29','2026-05-28 19:06:29','30301'),(11,'Charlotte Reed','customer7@example.com','+1-555-0110','DE','Georgia','San Diego','123 Main Street',9,1,'2026-05-28 19:06:29','2026-05-28 19:06:29','90210'),(12,'Amelia Foster','customer8@example.com','+1-555-0106','AU','Illinois','Dallas','456 Oak Avenue',10,1,'2026-05-28 19:06:29','2026-05-28 19:06:29','60601');

--
-- 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:06:30','2026-07-28 02:06:30',NULL,0,10,'coupon',0,0,NULL,NULL,'percentage','all-orders',0.00,0,1,'2026-05-28 19:06:30','2026-05-28 19:06:30',NULL,'A welcome discount for first-time shoppers — 10% off any order.'),(2,'Free Shipping Over $50','FREESHIP','2026-05-28 02:06:30',NULL,NULL,0,100,'coupon',0,0,NULL,NULL,'shipping','all-orders',50.00,0,1,'2026-05-28 19:06:30','2026-05-28 19:06:30',NULL,'Free shipping on any order $50 or above.'),(3,'Spring Sale — $25 Off','SPRING25','2026-05-28 02:06:30','2026-06-28 02:06:30',500,0,25,'coupon',0,0,NULL,NULL,'amount','all-orders',150.00,0,1,'2026-05-28 19:06:30','2026-05-28 19:06:30',NULL,'A flat $25 off orders over $150.'),(4,'VIP Member 20% Off','VIP20','2026-05-28 02:06:30','2026-08-27 02:06:30',NULL,0,20,'coupon',0,0,NULL,NULL,'percentage','all-orders',100.00,0,1,'2026-05-28 19:06:30','2026-05-28 19:06:30',NULL,'Exclusive 20% off for newsletter subscribers.'),(5,'Bundle & Save $50','BUNDLE50','2026-05-28 02:06:30','2026-07-13 02:06:30',NULL,0,50,'coupon',0,0,NULL,NULL,'amount','all-orders',300.00,0,1,'2026-05-28 19:06:30','2026-05-28 19:06:30',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,699.3,50,0),(1,7,909.3,50,0),(1,2,419.3,50,0),(1,6,90.3,50,0),(1,4,629.3,50,0),(1,5,839.3,50,0),(1,3,139.3,50,0),(2,3,149.25,75,0),(2,4,674.25,75,0),(2,5,899.25,75,0),(2,6,96.75,75,0),(2,2,449.25,75,0),(2,1,974.25,75,0),(2,8,749.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:06:30','published','2026-05-28 19:06:30','2026-05-28 19:06:30'),(2,'Weekend Doorbusters','2026-06-03 02:06:30','published','2026-05-28 19:06:30','2026-05-28 19:06:30');

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `ec_product_categories` VALUES (1,'Necklaces',NULL,0,'Pendants, link chains, and statement necklaces in 14k and 18k gold.','published',0,'categories/cate-43.jpg',1,'2026-05-28 19:06:19','2026-05-28 19:06:19',NULL,NULL),(2,'Earrings',NULL,0,'Studs, drops, and hoops crafted with diamonds, pearls, and precious stones.','published',1,'categories/cate-44.jpg',1,'2026-05-28 19:06:19','2026-05-28 19:06:19',NULL,NULL),(3,'Bracelets',NULL,0,'Tennis bracelets, bangles, and link styles for stacking or solo wear.','published',2,'categories/cate-45.jpg',1,'2026-05-28 19:06:19','2026-05-28 19:06:19',NULL,NULL),(4,'Rings',NULL,0,'Solitaires, eternity bands, and signet rings for everyday and milestone moments.','published',3,'categories/cate-46.jpg',1,'2026-05-28 19:06:20','2026-05-28 19:06:20',NULL,NULL),(5,'Diamonds',NULL,0,'GIA-certified loose stones and pre-set classic silhouettes for collectors.','published',4,'categories/cate-47.jpg',1,'2026-05-28 19:06:20','2026-05-28 19:06:20',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,'المعلقات وقلادات الارتباط والقلائد المميزة من الذهب عيار 14 قيراطًا و18 قيراطًا.'),('ar',2,'الأقراط',NULL,'أقراط برعم وقطرات وحلقة مصنوعة من الماس واللؤلؤ والأحجار الكريمة.'),('ar',3,'الأساور',NULL,'أساور التنس، والأساور والوصلات الصلبة يمكن ارتداؤها مع طبقات أو بمفردها.'),('ar',4,'خواتم',NULL,'خواتم ماسية فردية، وخواتم أبدية، وخواتم للحظات والمعالم اليومية.'),('ar',5,'الماس',NULL,'تتوفر الأحجار السائبة والأشكال الكلاسيكية المعتمدة من GIA لهواة الجمع.'),('fr',1,'Colliers',NULL,'Pendentifs, colliers à maillons et colliers décoratifs en or 14 carats et 18 carats.'),('fr',2,'Boucles d\'oreilles',NULL,'Boucles d\'oreilles bourgeons, pendantes et créoles ornées de diamants, de perles et de pierres précieuses.'),('fr',3,'Bracelets',NULL,'Bracelets tennis, bracelets unis et maillons à porter en superposition ou seuls.'),('fr',4,'Anneaux',NULL,'Des bagues à diamant unique, des bagues d\'éternité et des chevalières pour les moments et les événements marquants du quotidien.'),('fr',5,'Diamants',NULL,'Des pierres en vrac certifiées GIA et des formes classiques sont disponibles pour les collectionneurs.'),('id',1,'Kalung',NULL,'Liontin, kalung penghubung, dan kalung beraksen dari emas 14 karat dan 18 karat.'),('id',2,'Anting',NULL,'Anting kuncup, jatuhkan, dan melingkar yang dibuat dari berlian, mutiara, dan batu permata.'),('id',3,'Gelang',NULL,'Gelang tenis, gelang padat dan tautan untuk dipakai berlapis atau sendiri-sendiri.'),('id',4,'Cincin',NULL,'Cincin berlian tunggal, cincin keabadian, dan cincin meterai untuk momen dan pencapaian sehari-hari.'),('id',5,'berlian',NULL,'Batu lepas bersertifikat GIA dan bentuk klasik tersedia untuk kolektor.'),('tr',1,'Kolyeler',NULL,'14k ve 18k altın kolye uçları, bağlantılı kolyeler ve vurgulu kolyeler.'),('tr',2,'Küpeler',NULL,'Pırlanta, inci ve değerli taşlarla hazırlanmış tomurcuk, damla ve halka küpeler.'),('tr',3,'Bilezikler',NULL,'Katmanlı veya tek başına takılabilen tenis bileklikleri, sağlam bileklikler ve bağlantılar.'),('tr',4,'Yüzükler',NULL,'Hem gündelik anlar hem de dönüm noktaları için tek pırlanta yüzükler, sonsuzluk yüzükleri ve mühür yüzükleri.'),('tr',5,'Elmaslar',NULL,'GIA sertifikalı gevşek taşlar ve klasik şekiller koleksiyonerlerin beğenisine sunuluyor.'),('vi',1,'Dây chuyền',NULL,'Mặt dây, dây chuyền mắt xích và dây chuyền tạo điểm nhấn bằng vàng 14k và 18k.'),('vi',2,'Hoa tai',NULL,'Hoa tai nụ, giọt nước và khuyên tròn chế tác với kim cương, ngọc trai và đá quý.'),('vi',3,'Vòng tay',NULL,'Vòng tay tennis, vòng tay cứng và mắt xích để đeo xếp lớp hoặc đeo riêng.'),('vi',4,'Nhẫn',NULL,'Nhẫn kim cương đơn, nhẫn vĩnh cửu và nhẫn signet cho cả khoảnh khắc thường nhật lẫn dấu mốc.'),('vi',5,'Kim cương',NULL,'Đá rời đạt chứng nhận GIA và các dáng cổ điển có sẵn dành cho nhà sưu tầm.');

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

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

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

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

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

INSERT INTO `ec_product_collections` VALUES (1,'Shine Jewellery Collection','shine-jewellery-collection','Polished pieces curated to catch the light from every angle.','collection/cls-27.jpg','published','2026-05-28 19:06:21','2026-05-28 19:06:21',1),(2,'Luxury Gems Big Sale','luxury-gems-big-sale','Limited-time savings on rare gemstones and statement settings.','collection/cls-28.jpg','published','2026-05-28 19:06:21','2026-05-28 19:06:21',1),(3,'Fresh Sparkle New Arrivals','fresh-sparkle-new-arrivals','The latest drops from our jewelers — designed for everyday wear.','collection/cls-29.jpg','published','2026-05-28 19:06:21','2026-05-28 19:06:21',1),(4,'Elegant Gold Essentials','elegant-gold-essentials','Timeless 14k and 18k gold pieces that anchor any jewelry wardrobe.','section/accordion-cls.jpg','published','2026-05-28 19:06:21','2026-05-28 19:06:21',0),(5,'Sparkling Diamond Favorites','sparkling-diamond-favorites','Dazzling diamond pieces that capture light beautifully, adding timeless elegance for special occasions or everyday sophisticated style.','section/accordion-cls.jpg','published','2026-05-28 19:06:21','2026-05-28 19:06:21',0),(6,'Chic Silver Designs','chic-silver-designs','Sterling silver with a modern edge — minimalist links, bold cuffs, and sculptural rings.','section/accordion-cls.jpg','published','2026-05-28 19:06:21','2026-05-28 19:06:21',0),(7,'Gemstone Statement Pieces','gemstone-statement-pieces','Saturated stones in cocktail rings, drop earrings, and pendant necklaces ready to make an entrance.','section/accordion-cls.jpg','published','2026-05-28 19:06:21','2026-05-28 19:06:21',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,'أساسيات الذهب الأنيقة','تشكل قطع الذهب الخالدة عيار 14 قيراط و18 قيراط أساس أي خزانة مجوهرات.'),('ar',5,'تألق الماس المفضلة','يلتقط الماس المبهر الضوء بشكل جميل، مما يضفي أناقة خالدة على مناسبة خاصة أو أسلوب يومي متطور.'),('ar',6,'تصاميم فضية أنيقة','فضة نقية بلمسة عصرية - وصلات بسيطة وأساور كبيرة وخواتم منحوتة.'),('ar',7,'قطع بيان الأحجار الكريمة','الأحجار الكريمة ذات الألوان الجريئة في خواتم الكوكتيل والأقراط المتدلية والقلائد المتدلية جاهزة لترك انطباع جيد.'),('fr',1,'Collection de bijoux brillants','Les vernis sont conçus pour capturer la lumière sous tous les angles.'),('fr',2,'Grande vente de pierres précieuses de luxe','Offre à durée limitée sur les pierres précieuses rares et les montures d\'accent.'),('fr',3,'Nouveautés Fresh Sparkle','Les dernières créations de nos artisans, créées pour un usage quotidien.'),('fr',4,'Essentiels dorés élégants','Les pièces intemporelles en or 14 carats et 18 carats constituent la base de toute armoire à bijoux.'),('fr',5,'Favoris de diamants étincelants','Les diamants éblouissants capturent magnifiquement la lumière, apportant une élégance intemporelle à une occasion spéciale ou à un style sophistiqué de tous les jours.'),('fr',6,'Dessins argentés chics','De l\'argent pur avec une touche moderne : maillons minimalistes, grands bracelets et bagues sculptées.'),('fr',7,'Pièces de déclaration de pierres précieuses','Les pierres précieuses aux couleurs vives présentes dans les bagues de cocktail, les boucles d\'oreilles pendantes et les colliers à pendentif sont prêtes à faire impression.'),('id',1,'Koleksi Perhiasan Bersinar','Poles dikurasi untuk menangkap cahaya dari setiap sudut.'),('id',2,'Penjualan Besar Permata Mewah','Penawaran waktu terbatas untuk batu permata langka dan pengaturan aksen.'),('id',3,'Pendatang Baru Berkilau Segar','Desain terbaru dari pengrajin kami — dibuat untuk dipakai sehari-hari.'),('id',4,'Esensi Emas yang Elegan','Kepingan emas 14k dan 18k yang abadi menjadi fondasi lemari perhiasan mana pun.'),('id',5,'Favorit Berlian Berkilau','Berlian yang mempesona menangkap cahaya dengan indah, menghadirkan keanggunan abadi pada acara spesial atau gaya sehari-hari yang canggih.'),('id',6,'Desain Perak yang Cantik','Perak murni dengan sentuhan modern — tautan minimalis, gelang besar, dan cincin berukir.'),('id',7,'Potongan Pernyataan Batu Permata','Batu permata berwarna berani pada cincin koktail, anting-anting, dan kalung liontin siap memberikan kesan.'),('tr',1,'Shine Takı Koleksiyonu','Cilalar ışığı her açıdan yakalayacak şekilde tasarlanmıştır.'),('tr',2,'Lüks Taşlar Büyük İndirim','Nadir değerli taşlar ve vurgu ayarlarında sınırlı süreli teklif.'),('tr',3,'Taze Işıltı Yeni Gelenler','Zanaatkarlarımızın günlük kullanım için yarattığı en yeni tasarımlar.'),('tr',4,'Zarif Altının Temelleri','Zamansız 14 ayar ve 18 ayar altın parçalar her mücevher dolabının temelini oluşturur.'),('tr',5,'Köpüklü Pırlanta Favoriler','Göz kamaştırıcı pırlantalar ışığı güzel bir şekilde yakalayarak özel bir etkinliğe veya sofistike günlük stile zamansız bir zarafet katıyor.'),('tr',6,'Şık Gümüş Tasarımlar','Modern bir dokunuşa sahip saf gümüş; minimalist bağlantılar, büyük bilezikler ve şekilli yüzükler.'),('tr',7,'Değerli Taş İfade Parçaları','Kokteyl yüzüklerindeki, damla küpelerdeki ve kolyelerdeki koyu renkli değerli taşlar etki yaratmaya hazır.'),('vi',1,'Bộ sưu tập trang sức Tỏa sáng','Những món đồ đánh bóng được tuyển chọn để bắt sáng từ mọi góc độ.'),('vi',2,'Đại tiệc giảm giá đá quý cao cấp','Ưu đãi có thời hạn cho các loại đá quý hiếm và kiểu gắn tạo điểm nhấn.'),('vi',3,'Hàng mới về Lấp lánh tươi mới','Những thiết kế mới nhất từ các nghệ nhân của chúng tôi — được tạo ra để đeo hằng ngày.'),('vi',4,'Bộ vàng thiết yếu Thanh lịch','Những món vàng 14k và 18k vượt thời gian, làm nền tảng cho mọi tủ trang sức.'),('vi',5,'Những món kim cương lấp lánh yêu thích','Những món kim cương rực rỡ bắt sáng tuyệt đẹp, mang lại vẻ thanh lịch vượt thời gian cho dịp đặc biệt hay phong cách tinh tế thường ngày.'),('vi',6,'Thiết kế bạc Sành điệu','Bạc nguyên chất với nét hiện đại — mắt xích tối giản, vòng tay bản lớn và nhẫn điêu khắc.'),('vi',7,'Những món đá quý tạo điểm nhấn','Đá quý màu sắc đậm trong nhẫn cocktail, hoa tai giọt nước và dây chuyền mặt dây sẵn sàng tạo ấn tượng.');

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

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

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

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

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

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

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

INSERT INTO `ec_product_labels` VALUES (1,'Hot','#F0460E','published','2026-05-28 19:06:15','2026-05-28 19:06:15','#FFFFFF'),(2,'New','#22C55E','published','2026-05-28 19:06:15','2026-05-28 19:06:15','#FFFFFF'),(3,'Sale','#EF4444','published','2026-05-28 19:06:15','2026-05-28 19:06:15','#FFFFFF'),(4,'Best Seller','#1E1E1E','published','2026-05-28 19:06:15','2026-05-28 19:06:15','#FFFFFF'),(5,'Limited','#7B1F2B','published','2026-05-28 19:06:15','2026-05-28 19:06:15','#FFFFFF'),(6,'Eco','#6B7843','published','2026-05-28 19:06:15','2026-05-28 19:06:15','#FFFFFF');

--
-- Table structure for table `ec_product_labels_translations`
--

CREATE TABLE `ec_product_labels_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ec_product_labels_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ec_product_labels_id`),
  KEY `idx_product_labels_fk` (`ec_product_labels_id`),
  KEY `idx_product_labels_product_labels_lang` (`ec_product_labels_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_labels_translations`
--

INSERT INTO `ec_product_labels_translations` VALUES ('ar',1,'حار',NULL),('ar',2,'جديد',NULL),('ar',3,'أُوكَازيُون',NULL),('ar',4,'الأكثر مبيعًا',NULL),('ar',5,'محدود',NULL),('ar',6,'سابقة بمعنى البِيْئَة',NULL),('fr',1,'Chaud',NULL),('fr',2,'Nouveau',NULL),('fr',3,'Vente',NULL),('fr',4,'Meilleur vendeur',NULL),('fr',5,'Limité',NULL),('fr',6,'Écologique',NULL),('id',1,'Panas',NULL),('id',2,'Baru',NULL),('id',3,'Penjualan',NULL),('id',4,'Penjual Terbaik',NULL),('id',5,'Terbatas',NULL),('id',6,'ramah lingkungan',NULL),('tr',1,'Sıcak',NULL),('tr',2,'Yeni',NULL),('tr',3,'Satış',NULL),('tr',4,'En çok satan kitap',NULL),('tr',5,'Sınırlı',NULL),('tr',6,'Eko',NULL),('vi',1,'Hot',NULL),('vi',2,'Mới',NULL),('vi',3,'Giảm giá',NULL),('vi',4,'Bán chạy nhất',NULL),('vi',5,'Giới hạn',NULL),('vi',6,'Eco',NULL);

--
-- Table structure for table `ec_product_license_codes`
--

CREATE TABLE `ec_product_license_codes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned NOT NULL,
  `license_code` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'available',
  `assigned_order_product_id` bigint unsigned DEFAULT NULL,
  `assigned_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ec_product_license_codes_product_id_status_index` (`product_id`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_license_codes`
--


--
-- Table structure for table `ec_product_related_relations`
--

CREATE TABLE `ec_product_related_relations` (
  `from_product_id` bigint unsigned NOT NULL,
  `to_product_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`from_product_id`,`to_product_id`),
  KEY `ec_product_related_relations_from_product_id_index` (`from_product_id`),
  KEY `ec_product_related_relations_to_product_id_index` (`to_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_related_relations`
--


--
-- Table structure for table `ec_product_specification_attribute`
--

CREATE TABLE `ec_product_specification_attribute` (
  `product_id` bigint unsigned NOT NULL,
  `attribute_id` bigint unsigned NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `hidden` tinyint(1) NOT NULL DEFAULT '0',
  `order` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`product_id`,`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_specification_attribute`
--


--
-- Table structure for table `ec_product_specification_attribute_translations`
--

CREATE TABLE `ec_product_specification_attribute_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned NOT NULL,
  `attribute_id` bigint unsigned NOT NULL,
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `psat_unique` (`product_id`,`attribute_id`,`lang_code`),
  KEY `psat_product_attribute_index` (`product_id`,`attribute_id`),
  KEY `psat_product_id_index` (`product_id`),
  KEY `psat_attribute_id_index` (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_specification_attribute_translations`
--


--
-- Table structure for table `ec_product_tag_product`
--

CREATE TABLE `ec_product_tag_product` (
  `product_id` bigint unsigned NOT NULL,
  `tag_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`product_id`,`tag_id`),
  KEY `ec_product_tag_product_product_id_index` (`product_id`),
  KEY `ec_product_tag_product_tag_id_index` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ec_product_tag_product`
--

INSERT INTO `ec_product_tag_product` VALUES (1,9),(1,11),(1,14),(2,2),(2,6),(2,15),(3,3),(3,6),(3,9),(4,2),(4,8),(4,9),(5,5),(5,6),(5,10),(6,3),(6,5),(6,7),(7,5),(7,7),(7,10),(8,1),(8,7),(8,15);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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

INSERT INTO `ec_product_with_attribute_set` VALUES (1,1,0),(2,1,0),(1,2,0),(2,2,0),(1,3,0),(2,3,0),(3,4,0),(3,5,0),(3,6,0);

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

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

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

INSERT INTO `ec_products` VALUES (1,'Tiffany Lock Bangle','tiffany-lock-bangle','Heritage padlock-clasp bangle in 18k yellow gold with a hinged opening.','<p>Hand-finished 18k gold. Hinged open-and-close lock mechanism. Available in 60mm and 65mm sizes. Comes in a hand-stamped jewelry pouch.</p>','published','[\"products\\/jewelry\\/product-1.jpg\"]',NULL,'OU-184-A1',0,10,0,1,'in_stock',0,NULL,4,0,2,10,2.70,0,1299,999,NULL,NULL,15,18,19,826,NULL,'standard',54207,'2026-05-28 19:06:23','2026-05-28 19:06:32',1,0,'Botble\\ACL\\Models\\User',0,'products/jewelry/product-1.jpg','physical','8308139696616',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(2,'Link Necklace Gold','link-necklace-gold','Polished paperclip-link necklace in 14k yellow gold with an 18-inch length.','<p>Solid 14k gold links, lobster clasp closure. Layers well with shorter pendants or solo against an open neckline.</p>','published','[\"products\\/jewelry\\/product-2.jpg\"]',NULL,'PW-131-A1',0,18,0,1,'in_stock',0,NULL,6,0,3,10,2.80,0,599,449,NULL,NULL,17,13,11,837,NULL,'standard',199140,'2026-05-28 19:06:23','2026-05-28 19:06:32',2,0,'Botble\\ACL\\Models\\User',0,'products/jewelry/product-2.jpg','physical','6443485440369',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(3,'Elsa Drop Earrings','elsa-drop-earrings','Sculptural teardrop earrings in 14k gold with a high-polish curved silhouette.','<p>Hypoallergenic posts. 1-inch drop. Light enough for everyday wear. Designed by an in-house atelier in Florence.</p>','published','[\"products\\/jewelry\\/product-3.jpg\"]',NULL,'59-109-A1',0,13,0,1,'in_stock',0,NULL,2,0,2,10,3.70,0,199,149,NULL,NULL,14,14,19,560,NULL,'standard',134070,'2026-05-28 19:06:23','2026-05-28 19:06:32',3,0,'Botble\\ACL\\Models\\User',0,'products/jewelry/product-3.jpg','physical','5890813735320',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(4,'Diamond Pendant','diamond-pendant','Bezel-set 0.25ct round brilliant diamond pendant on a delicate gold chain.','<p>GIA-certified G/SI1 stone. Solid 14k yellow gold bezel and 16-inch box chain with adjustable 18-inch loop.</p>','published','[\"products\\/jewelry\\/product-4.jpg\"]',NULL,'YL-173-A1',0,11,0,1,'in_stock',0,NULL,3,0,4,10,3.20,0,899,699,NULL,NULL,17,12,13,513,NULL,'standard',36720,'2026-05-28 19:06:24','2026-05-28 19:06:32',4,0,'Botble\\ACL\\Models\\User',0,'products/jewelry/product-4.jpg','physical','6334195801628',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(5,'Gold Tennis Bracelet','gold-tennis-bracelet','Classic tennis bracelet with prong-set 1.5ct total diamond weight in 14k white gold.','<p>Hand-set round brilliant diamonds, F/G color, VS clarity. Double-locking safety clasp. Sized 7 inches with sizing service available.</p>','published','[\"products\\/jewelry\\/product-5.jpg\"]',NULL,'JH-174-A1',0,15,0,1,'in_stock',1,NULL,2,0,2,10,3.00,0,1199,949,NULL,NULL,14,18,14,664,NULL,'standard',137704,'2026-05-28 19:06:24','2026-05-28 19:06:32',1,0,'Botble\\ACL\\Models\\User',0,'products/jewelry/product-5.jpg','physical','1805046798800',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(6,'Pearl Drop Earrings','pearl-drop-earrings','Hand-set freshwater pearl drops with a 14k gold-fill post and an articulated link.','<p>8-9mm AA-grade pearls. 1.5-inch drop. Pairs with everyday and formal looks. Comes in a velvet pouch with a polishing cloth.</p>','published','[\"products\\/jewelry\\/product-6.jpg\"]',NULL,'WK-185-A1',0,14,0,1,'in_stock',0,NULL,12,0,2,10,2.30,0,129,89,NULL,NULL,10,16,16,577,NULL,'standard',42517,'2026-05-28 19:06:24','2026-05-28 19:06:32',2,0,'Botble\\ACL\\Models\\User',0,'products/jewelry/product-6.jpg','physical','7849646527983',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(7,'Solitaire Ring','solitaire-ring','Six-prong 0.5ct round brilliant solitaire in 18k white gold with a knife-edge band.','<p>GIA-certified F/VS2 diamond. Cathedral-set in solid 18k white gold. Available in sizes 4-9 with complimentary resizing.</p>','published','[\"products\\/jewelry\\/product-7.jpg\"]',NULL,'OK-179',0,12,0,1,'in_stock',0,NULL,3,0,0,10,3.40,0,1299,1099,NULL,NULL,15,14,11,871,NULL,'standard',168848,'2026-05-28 19:06:24','2026-05-28 19:06:32',3,0,'Botble\\ACL\\Models\\User',0,'products/jewelry/product-7.jpg','physical','4706636170457',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(8,'Eternity Band','eternity-band','Channel-set diamond eternity band with 1.0ct total weight in 14k yellow gold.','<p>Round brilliant diamonds set continuously around the band. F/G color, VS clarity. 2.5mm wide. Sized at order.</p>','published','[\"products\\/jewelry\\/product-8.jpg\"]',NULL,'NS-110',0,14,0,1,'in_stock',1,NULL,5,0,0,10,3.00,0,999,799,NULL,NULL,14,12,11,655,NULL,'standard',184596,'2026-05-28 19:06:24','2026-05-28 19:06:32',4,0,'Botble\\ACL\\Models\\User',0,'products/jewelry/product-8.jpg','physical','8111799236265',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(9,'Tiffany Lock Bangle',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-1.jpg\"]',NULL,'OU-184-A1',0,10,0,1,'in_stock',0,NULL,4,1,0,0,0.00,0,1299,NULL,NULL,NULL,15,18,19,826,NULL,'standard',0,'2026-05-28 19:06:24','2026-05-28 19:06:32',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5765661373201',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(10,'Tiffany Lock Bangle',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-1.jpg\"]',NULL,'OU-184-A1-A2',0,10,0,1,'in_stock',0,NULL,4,1,0,0,0.00,0,1299,NULL,NULL,NULL,15,18,19,826,NULL,'standard',0,'2026-05-28 19:06:24','2026-05-28 19:06:32',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2537232285410',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(11,'Link Necklace Gold',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-2.jpg\"]',NULL,'PW-131-A1',0,18,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,599,NULL,NULL,NULL,17,13,11,837,NULL,'standard',0,'2026-05-28 19:06:25','2026-05-28 19:06:32',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','7938322584607',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(12,'Link Necklace Gold',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-2.jpg\"]',NULL,'PW-131-A1-A2',0,18,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,599,NULL,NULL,NULL,17,13,11,837,NULL,'standard',0,'2026-05-28 19:06:25','2026-05-28 19:06:32',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8246179236556',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(13,'Link Necklace Gold',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-2.jpg\"]',NULL,'PW-131-A1-A3',0,18,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,599,NULL,NULL,NULL,17,13,11,837,NULL,'standard',0,'2026-05-28 19:06:25','2026-05-28 19:06:32',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9058481693267',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(14,'Elsa Drop Earrings',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-3.jpg\"]',NULL,'59-109-A1',0,13,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,199,NULL,NULL,NULL,14,14,19,560,NULL,'standard',0,'2026-05-28 19:06:25','2026-05-28 19:06:32',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2599717547789',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(15,'Elsa Drop Earrings',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-3.jpg\"]',NULL,'59-109-A1-A2',0,13,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,199,NULL,NULL,NULL,14,14,19,560,NULL,'standard',0,'2026-05-28 19:06:25','2026-05-28 19:06:32',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','3274302952368',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(16,'Diamond Pendant',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-4.jpg\"]',NULL,'YL-173-A1',0,11,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,899,764.15,NULL,NULL,17,12,13,513,NULL,'standard',0,'2026-05-28 19:06:25','2026-05-28 19:06:32',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8698463040644',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(17,'Diamond Pendant',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-4.jpg\"]',NULL,'YL-173-A1-A2',0,11,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,899,665.26,NULL,NULL,17,12,13,513,NULL,'standard',0,'2026-05-28 19:06:25','2026-05-28 19:06:32',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4707482938123',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(18,'Diamond Pendant',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-4.jpg\"]',NULL,'YL-173-A1-A3',0,11,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,899,647.28,NULL,NULL,17,12,13,513,NULL,'standard',0,'2026-05-28 19:06:25','2026-05-28 19:06:32',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9770434966067',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(19,'Diamond Pendant',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-4.jpg\"]',NULL,'YL-173-A1-A4',0,11,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,899,683.24,NULL,NULL,17,12,13,513,NULL,'standard',0,'2026-05-28 19:06:25','2026-05-28 19:06:32',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8179651020452',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(20,'Gold Tennis Bracelet',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-5.jpg\"]',NULL,'JH-174-A1',0,15,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,1199,NULL,NULL,NULL,14,18,14,664,NULL,'standard',0,'2026-05-28 19:06:25','2026-05-28 19:06:32',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4622019468181',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(21,'Gold Tennis Bracelet',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-5.jpg\"]',NULL,'JH-174-A1-A2',0,15,0,1,'in_stock',0,NULL,2,1,0,0,0.00,0,1199,NULL,NULL,NULL,14,18,14,664,NULL,'standard',0,'2026-05-28 19:06:26','2026-05-28 19:06:32',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6678668390395',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(22,'Pearl Drop Earrings',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-6.jpg\"]',NULL,'WK-185-A1',0,14,0,1,'in_stock',0,NULL,12,1,0,0,0.00,0,129,NULL,NULL,NULL,10,16,16,577,NULL,'standard',0,'2026-05-28 19:06:26','2026-05-28 19:06:32',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8024651643555',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(23,'Pearl Drop Earrings',NULL,NULL,NULL,'published','[\"products\\/jewelry\\/product-6.jpg\"]',NULL,'WK-185-A1-A2',0,14,0,1,'in_stock',0,NULL,12,1,0,0,0.00,0,129,NULL,NULL,NULL,10,16,16,577,NULL,'standard',0,'2026-05-28 19:06:26','2026-05-28 19:06:32',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5483375365540',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,'سوار قفل على الطراز التراثي من الذهب الأصفر عيار 18 قيراط مع فتحة مفصلية.','<p>18 قيراط من الذهب بلمسة نهائية يدوية. آلية قفل الفتح والإغلاق بمفصلات. متوفر بمقاسات 60 ملم و 65 ملم. تأتي مع حقيبة مجوهرات منقوشة يدويًا.</p>'),('ar',2,'ربط قلادة الذهب',NULL,'قلادة على شكل مشبك ورق مصقول من الذهب الأصفر عيار 14 قيراط، بطول 18 بوصة.','<p> سلسلة ذهبية صلبة عيار 14 قيراط، قفل جمبري. ارتديها بشكل جميل مع قلادة أقصر أو ارتديها بمفردها فوق ياقة مفتوحة.</p>'),('ar',3,'أقراط إلسا المتدلية',NULL,'أقراط متدلية من الذهب عيار 14 قيراط منحوتة مع منحنى شديد اللمعان.','<p> المشبك مضاد للحساسية. يبلغ طول القطرات 1 بوصة. خفيف بما يكفي للارتداء كل يوم. تم تصميمه بواسطة ورشة عمل داخلية في فلورنسا.</p>'),('ar',4,'قلادة الماس',NULL,'قلادة ألماس مستديرة رائعة عيار 0.25 قيراط مرصعة بسلسلة ذهبية رفيعة.','<p>الحجر حاصل على شهادة GIA G/SI1. إطار صلب من الذهب الأصفر عيار 14 قيراط وحزام صندوقي مقاس 16 بوصة مع حلقة قابلة للتعديل حتى 18 بوصة.</p>'),('ar',5,'سوار التنس الذهبي',NULL,'سوار تنس كلاسيكي مرصع بـ 1.5 قيراط من الذهب الأبيض عيار 14 قيراط.','<p> ماسة مستديرة رائعة مرصعة يدويًا، لون F/G، وضوح VS. قفل أمان مزدوج القفل. الحجم 7 بوصة، خدمة تغيير الحجم متاحة.</p>'),('ar',6,'أقراط اللؤلؤ المتدلية',NULL,'أقراط متدلية من لؤلؤ المياه العذبة مثبتة يدويًا مع دبابيس مطلية بالذهب عيار 14 قيراط وروابط مرنة.','<p>8-9 ملم درجة AA لؤلؤ. قطرة بطول 1.5 بوصة. مناسب لكل من الأنماط اليومية والرسمية. تأتي مع حقيبة مخملية وقطعة قماش للتنظيف.</p>'),('ar',7,'خاتم سوليتير',NULL,'خاتم ألماس دائري رائع بستة شقوق 0.5 قيراط من الذهب الأبيض عيار 18 قيراط مع جذع حافة السكين.','<p>ألماس معتمد من GIA F/VS2. طراز كاتدرائية مثبت على الذهب الأبيض عيار 18 قيراط. متوفر بمقاسات من 4 إلى 9 مع خدمة تغيير الحجم مجانًا.</p>'),('ar',8,'فرقة الخلود',NULL,'خاتم الخلود الماسي المخدد بوزن إجمالي 1.0 قيراط من الذهب الأصفر عيار 14 قيراط.','<p> يتم تركيب الماس المستدير اللامع بشكل مستمر حول جسم الخاتم. اللون F/G، النقاء مقابل. نسخة بعرض 2.5 ملم. اضبط الحجم حسب الطلب.</p>'),('ar',9,'تيفاني قفل الإسورة',NULL,'سوار قفل على الطراز التراثي من الذهب الأصفر عيار 18 قيراط مع فتحة مفصلية.','<p>18 قيراط من الذهب بلمسة نهائية يدوية. آلية قفل الفتح والإغلاق بمفصلات. متوفر بمقاسات 60 ملم و 65 ملم. تأتي مع حقيبة مجوهرات منقوشة يدويًا.</p>'),('ar',10,'تيفاني قفل الإسورة',NULL,'سوار قفل على الطراز التراثي من الذهب الأصفر عيار 18 قيراط مع فتحة مفصلية.','<p>18 قيراط من الذهب بلمسة نهائية يدوية. آلية قفل الفتح والإغلاق بمفصلات. متوفر بمقاسات 60 ملم و 65 ملم. تأتي مع حقيبة مجوهرات منقوشة يدويًا.</p>'),('ar',11,'ربط قلادة الذهب',NULL,'قلادة على شكل مشبك ورق مصقول من الذهب الأصفر عيار 14 قيراط، بطول 18 بوصة.','<p> سلسلة ذهبية صلبة عيار 14 قيراط، قفل جمبري. ارتديها بشكل جميل مع قلادة أقصر أو ارتديها بمفردها فوق ياقة مفتوحة.</p>'),('ar',12,'ربط قلادة الذهب',NULL,'قلادة على شكل مشبك ورق مصقول من الذهب الأصفر عيار 14 قيراط، بطول 18 بوصة.','<p> سلسلة ذهبية صلبة عيار 14 قيراط، قفل جمبري. ارتديها بشكل جميل مع قلادة أقصر أو ارتديها بمفردها فوق ياقة مفتوحة.</p>'),('ar',13,'ربط قلادة الذهب',NULL,'قلادة على شكل مشبك ورق مصقول من الذهب الأصفر عيار 14 قيراط، بطول 18 بوصة.','<p> سلسلة ذهبية صلبة عيار 14 قيراط، قفل جمبري. ارتديها بشكل جميل مع قلادة أقصر أو ارتديها بمفردها فوق ياقة مفتوحة.</p>'),('ar',14,'أقراط إلسا المتدلية',NULL,'أقراط متدلية من الذهب عيار 14 قيراط منحوتة مع منحنى شديد اللمعان.','<p> المشبك مضاد للحساسية. يبلغ طول القطرات 1 بوصة. خفيف بما يكفي للارتداء كل يوم. تم تصميمه بواسطة ورشة عمل داخلية في فلورنسا.</p>'),('ar',15,'أقراط إلسا المتدلية',NULL,'أقراط متدلية من الذهب عيار 14 قيراط منحوتة مع منحنى شديد اللمعان.','<p> المشبك مضاد للحساسية. يبلغ طول القطرات 1 بوصة. خفيف بما يكفي للارتداء كل يوم. تم تصميمه بواسطة ورشة عمل داخلية في فلورنسا.</p>'),('ar',16,'قلادة الماس',NULL,'قلادة ألماس مستديرة رائعة عيار 0.25 قيراط مرصعة بسلسلة ذهبية رفيعة.','<p>الحجر حاصل على شهادة GIA G/SI1. إطار صلب من الذهب الأصفر عيار 14 قيراط وحزام صندوقي مقاس 16 بوصة مع حلقة قابلة للتعديل حتى 18 بوصة.</p>'),('ar',17,'قلادة الماس',NULL,'قلادة ألماس مستديرة رائعة عيار 0.25 قيراط مرصعة بسلسلة ذهبية رفيعة.','<p>الحجر حاصل على شهادة GIA G/SI1. إطار صلب من الذهب الأصفر عيار 14 قيراط وحزام صندوقي مقاس 16 بوصة مع حلقة قابلة للتعديل حتى 18 بوصة.</p>'),('ar',18,'قلادة الماس',NULL,'قلادة ألماس مستديرة رائعة عيار 0.25 قيراط مرصعة بسلسلة ذهبية رفيعة.','<p>الحجر حاصل على شهادة GIA G/SI1. إطار صلب من الذهب الأصفر عيار 14 قيراط وحزام صندوقي مقاس 16 بوصة مع حلقة قابلة للتعديل حتى 18 بوصة.</p>'),('ar',19,'قلادة الماس',NULL,'قلادة ألماس مستديرة رائعة عيار 0.25 قيراط مرصعة بسلسلة ذهبية رفيعة.','<p>الحجر حاصل على شهادة GIA G/SI1. إطار صلب من الذهب الأصفر عيار 14 قيراط وحزام صندوقي مقاس 16 بوصة مع حلقة قابلة للتعديل حتى 18 بوصة.</p>'),('ar',20,'سوار التنس الذهبي',NULL,'سوار تنس كلاسيكي مرصع بـ 1.5 قيراط من الذهب الأبيض عيار 14 قيراط.','<p> ماسة مستديرة رائعة مرصعة يدويًا، لون F/G، وضوح VS. قفل أمان مزدوج القفل. الحجم 7 بوصة، خدمة تغيير الحجم متاحة.</p>'),('ar',21,'سوار التنس الذهبي',NULL,'سوار تنس كلاسيكي مرصع بـ 1.5 قيراط من الذهب الأبيض عيار 14 قيراط.','<p> ماسة مستديرة رائعة مرصعة يدويًا، لون F/G، وضوح VS. قفل أمان مزدوج القفل. الحجم 7 بوصة، خدمة تغيير الحجم متاحة.</p>'),('ar',22,'أقراط اللؤلؤ المتدلية',NULL,'أقراط متدلية من لؤلؤ المياه العذبة مثبتة يدويًا مع دبابيس مطلية بالذهب عيار 14 قيراط وروابط مرنة.','<p>8-9 ملم درجة AA لؤلؤ. قطرة بطول 1.5 بوصة. مناسب لكل من الأنماط اليومية والرسمية. تأتي مع حقيبة مخملية وقطعة قماش للتنظيف.</p>'),('ar',23,'أقراط اللؤلؤ المتدلية',NULL,'أقراط متدلية من لؤلؤ المياه العذبة مثبتة يدويًا مع دبابيس مطلية بالذهب عيار 14 قيراط وروابط مرنة.','<p>8-9 ملم درجة AA لؤلؤ. قطرة بطول 1.5 بوصة. مناسب لكل من الأنماط اليومية والرسمية. تأتي مع حقيبة مخملية وقطعة قماش للتنظيف.</p>'),('fr',1,'Bracelet cadenas Tiffany',NULL,'Bracelet cadenas de style patrimoine en or jaune 18 carats avec ouverture à charnière.','<p>Or 18 carats fini à la main. Mécanisme de verrouillage ouverture-fermeture avec charnières. Disponible en tailles 60 mm et 65 mm. Livré avec une pochette à bijoux gaufrée à la main.</p>'),('fr',2,'Collier Lien Or',NULL,'Collier à maillons style trombone poli en or jaune 14 carats, 18 pouces de long.','<p>Chaîne en or massif 14 carats, cadenas crevette. À porter joliment en superposition avec un pendentif plus court ou porté seul sur un col ouvert.</p>'),('fr',3,'Boucles d\'oreilles pendantes Elsa',NULL,'Boucles d\'oreilles pendantes sculptées en or 14 carats avec une courbe très brillante.','<p>Le fermoir est hypoallergénique. Les gouttes mesurent 1 pouce de long. Assez léger pour être porté tous les jours. Conçu par un atelier interne à Florence.</p>'),('fr',4,'Pendentif Diamant',NULL,'Pendentif diamant rond brillant de 0,25 ct monté sur une fine chaîne en or.','<p>La pierre est certifiée GIA G/SI1. Lunette en or jaune massif 14 carats et bracelet boîte de 16 pouces avec anneau réglable jusqu\'à 18 pouces.</p>'),('fr',5,'Bracelet Tennis Or',NULL,'Bracelet tennis classique avec diamants 1,5 ct en or blanc 14 carats.','<p>Diamant rond brillant serti à la main, couleur F/G, pureté VS. Verrou de sécurité à double verrouillage. Taille 7 pouces, service de redimensionnement disponible.</p>'),('fr',6,'Boucles d\'oreilles pendantes avec perles',NULL,'Boucles d\'oreilles pendantes en perles d\'eau douce installées à la main avec épingles plaquées or 14 carats et maillons flexibles.','<p>Perle AA de 8 à 9 mm. Gouttelette de 1,5 pouces de long. Convient aux styles quotidiens et formels. Livré avec un sac en velours et un chiffon de nettoyage.</p>'),('fr',7,'Bague Solitaire',NULL,'Brillante bague en diamant rond unique à six griffes de 0,5 ct en or blanc 18 carats avec tige en forme de couteau.','<p>Diamants certifiés par GIA F/VS2. Monté style cathédrale sur or blanc massif 18 carats. Disponible dans les tailles 4 à 9 avec service de redimensionnement gratuit.</p>'),('fr',8,'Bande d\'éternité',NULL,'Bague d\'éternité cannelée en diamant d\'un poids total de 1,0 ct en or jaune 14 carats.','<p>Des diamants ronds brillants sont montés en continu autour du corps de la bague. Couleur F/G, pureté VS. Version de 2,5 mm de large. Ajustez la taille en fonction de la commande.</p>'),('fr',9,'Bracelet cadenas Tiffany',NULL,'Bracelet cadenas de style patrimoine en or jaune 18 carats avec ouverture à charnière.','<p>Or 18 carats fini à la main. Mécanisme de verrouillage ouverture-fermeture avec charnières. Disponible en tailles 60 mm et 65 mm. Livré avec une pochette à bijoux gaufrée à la main.</p>'),('fr',10,'Bracelet cadenas Tiffany',NULL,'Bracelet cadenas de style patrimoine en or jaune 18 carats avec ouverture à charnière.','<p>Or 18 carats fini à la main. Mécanisme de verrouillage ouverture-fermeture avec charnières. Disponible en tailles 60 mm et 65 mm. Livré avec une pochette à bijoux gaufrée à la main.</p>'),('fr',11,'Collier Lien Or',NULL,'Collier à maillons style trombone poli en or jaune 14 carats, 18 pouces de long.','<p>Chaîne en or massif 14 carats, cadenas crevette. À porter joliment en superposition avec un pendentif plus court ou porté seul sur un col ouvert.</p>'),('fr',12,'Collier Lien Or',NULL,'Collier à maillons style trombone poli en or jaune 14 carats, 18 pouces de long.','<p>Chaîne en or massif 14 carats, cadenas crevette. À porter joliment en superposition avec un pendentif plus court ou porté seul sur un col ouvert.</p>'),('fr',13,'Collier Lien Or',NULL,'Collier à maillons style trombone poli en or jaune 14 carats, 18 pouces de long.','<p>Chaîne en or massif 14 carats, cadenas crevette. À porter joliment en superposition avec un pendentif plus court ou porté seul sur un col ouvert.</p>'),('fr',14,'Boucles d\'oreilles pendantes Elsa',NULL,'Boucles d\'oreilles pendantes sculptées en or 14 carats avec une courbe très brillante.','<p>Le fermoir est hypoallergénique. Les gouttes mesurent 1 pouce de long. Assez léger pour être porté tous les jours. Conçu par un atelier interne à Florence.</p>'),('fr',15,'Boucles d\'oreilles pendantes Elsa',NULL,'Boucles d\'oreilles pendantes sculptées en or 14 carats avec une courbe très brillante.','<p>Le fermoir est hypoallergénique. Les gouttes mesurent 1 pouce de long. Assez léger pour être porté tous les jours. Conçu par un atelier interne à Florence.</p>'),('fr',16,'Pendentif Diamant',NULL,'Pendentif diamant rond brillant de 0,25 ct monté sur une fine chaîne en or.','<p>La pierre est certifiée GIA G/SI1. Lunette en or jaune massif 14 carats et bracelet boîte de 16 pouces avec anneau réglable jusqu\'à 18 pouces.</p>'),('fr',17,'Pendentif Diamant',NULL,'Pendentif diamant rond brillant de 0,25 ct monté sur une fine chaîne en or.','<p>La pierre est certifiée GIA G/SI1. Lunette en or jaune massif 14 carats et bracelet boîte de 16 pouces avec anneau réglable jusqu\'à 18 pouces.</p>'),('fr',18,'Pendentif Diamant',NULL,'Pendentif diamant rond brillant de 0,25 ct monté sur une fine chaîne en or.','<p>La pierre est certifiée GIA G/SI1. Lunette en or jaune massif 14 carats et bracelet boîte de 16 pouces avec anneau réglable jusqu\'à 18 pouces.</p>'),('fr',19,'Pendentif Diamant',NULL,'Pendentif diamant rond brillant de 0,25 ct monté sur une fine chaîne en or.','<p>La pierre est certifiée GIA G/SI1. Lunette en or jaune massif 14 carats et bracelet boîte de 16 pouces avec anneau réglable jusqu\'à 18 pouces.</p>'),('fr',20,'Bracelet Tennis Or',NULL,'Bracelet tennis classique avec diamants 1,5 ct en or blanc 14 carats.','<p>Diamant rond brillant serti à la main, couleur F/G, pureté VS. Verrou de sécurité à double verrouillage. Taille 7 pouces, service de redimensionnement disponible.</p>'),('fr',21,'Bracelet Tennis Or',NULL,'Bracelet tennis classique avec diamants 1,5 ct en or blanc 14 carats.','<p>Diamant rond brillant serti à la main, couleur F/G, pureté VS. Verrou de sécurité à double verrouillage. Taille 7 pouces, service de redimensionnement disponible.</p>'),('fr',22,'Boucles d\'oreilles pendantes avec perles',NULL,'Boucles d\'oreilles pendantes en perles d\'eau douce installées à la main avec épingles plaquées or 14 carats et maillons flexibles.','<p>Perle AA de 8 à 9 mm. Gouttelette de 1,5 pouces de long. Convient aux styles quotidiens et formels. Livré avec un sac en velours et un chiffon de nettoyage.</p>'),('fr',23,'Boucles d\'oreilles pendantes avec perles',NULL,'Boucles d\'oreilles pendantes en perles d\'eau douce installées à la main avec épingles plaquées or 14 carats et maillons flexibles.','<p>Perle AA de 8 à 9 mm. Gouttelette de 1,5 pouces de long. Convient aux styles quotidiens et formels. Livré avec un sac en velours et un chiffon de nettoyage.</p>'),('id',1,'Gelang Kunci Tiffany',NULL,'Gelang gembok gaya warisan emas kuning 18 karat dengan bukaan berengsel.','<p>18k emas buatan tangan. Mekanisme penguncian buka-tutup dengan engsel. Tersedia dalam ukuran 60mm dan 65mm. Dilengkapi dengan tas perhiasan timbul tangan.</p>'),('id',2,'Tautan Kalung Emas',NULL,'Kalung tautan gaya penjepit kertas poles emas kuning 14 karat, panjang 18 inci.','<p>Rantai emas 14k solid, gembok udang. Kenakan pakaian berlapis indah dengan liontin pendek atau kenakan sendiri dengan kerah terbuka.</p>'),('id',3,'Anting Jatuh Elsa',NULL,'Anting-anting emas 14k yang dipahat dengan lekukan mengkilap yang tinggi.','<p> Gespernya hipoalergenik. Tetesannya panjangnya 1 inci. Cukup ringan untuk dipakai setiap hari. Dirancang oleh bengkel internal di Florence.</p>'),('id',4,'Liontin Berlian',NULL,'Liontin berlian bulat cemerlang 0,25 karat dipasang pada rantai emas tipis.','<p>Batu tersebut bersertifikat GIA G/SI1. Bingkai cincin emas kuning 14 karat solid dan tali kotak 16 inci dengan cincin yang dapat disesuaikan hingga 18 inci.</p>'),('id',5,'Gelang Tenis Emas',NULL,'Gelang tenis klasik dengan berlian 1,5 karat dalam emas putih 14 karat.','<p>Berlian bulat buatan tangan yang brilian, warna F/G, kejernihan VS. Kunci pengaman penguncian ganda. Ukuran 7 inci, tersedia layanan pengubahan ukuran.</p>'),('id',6,'Anting Mutiara Jatuh',NULL,'Anting-anting mutiara air tawar yang dipasang dengan tangan dengan pin berlapis emas 14k dan tautan fleksibel.','<p>8-9mm mutiara kelas AA. Tetesan sepanjang 1,5 inci. Cocok untuk gaya sehari-hari dan formal. Dilengkapi dengan tas beludru dan kain pembersih.</p>'),('id',7,'Cincin Solitaire',NULL,'Cincin berlian bulat tunggal enam cabang 0,5 karat yang brilian dari emas putih 18 karat dengan batang tepi pisau.','<p>Berlian disertifikasi oleh GIA F/VS2. Gaya katedral terpasang pada emas putih 18 karat padat. Tersedia dalam ukuran 4-9 dengan layanan pengubahan ukuran gratis.</p>'),('id',8,'Pita Keabadian',NULL,'Cincin keabadian bergalur berlian dengan berat total 1 karat dalam emas kuning 14 karat.','<p>Berlian bulat cemerlang dipasang terus menerus di sekeliling badan cincin. Warna F/G, kemurnian VS. Versi lebar 2,5 mm. Sesuaikan ukuran sesuai pesanan.</p>'),('id',9,'Gelang Kunci Tiffany',NULL,'Gelang gembok gaya warisan emas kuning 18 karat dengan bukaan berengsel.','<p>18k emas buatan tangan. Mekanisme penguncian buka-tutup dengan engsel. Tersedia dalam ukuran 60mm dan 65mm. Dilengkapi dengan tas perhiasan timbul tangan.</p>'),('id',10,'Gelang Kunci Tiffany',NULL,'Gelang gembok gaya warisan emas kuning 18 karat dengan bukaan berengsel.','<p>18k emas buatan tangan. Mekanisme penguncian buka-tutup dengan engsel. Tersedia dalam ukuran 60mm dan 65mm. Dilengkapi dengan tas perhiasan timbul tangan.</p>'),('id',11,'Tautan Kalung Emas',NULL,'Kalung tautan gaya penjepit kertas poles emas kuning 14 karat, panjang 18 inci.','<p>Rantai emas 14k solid, gembok udang. Kenakan pakaian berlapis indah dengan liontin pendek atau kenakan sendiri dengan kerah terbuka.</p>'),('id',12,'Tautan Kalung Emas',NULL,'Kalung tautan gaya penjepit kertas poles emas kuning 14 karat, panjang 18 inci.','<p>Rantai emas 14k solid, gembok udang. Kenakan pakaian berlapis indah dengan liontin pendek atau kenakan sendiri dengan kerah terbuka.</p>'),('id',13,'Tautan Kalung Emas',NULL,'Kalung tautan gaya penjepit kertas poles emas kuning 14 karat, panjang 18 inci.','<p>Rantai emas 14k solid, gembok udang. Kenakan pakaian berlapis indah dengan liontin pendek atau kenakan sendiri dengan kerah terbuka.</p>'),('id',14,'Anting Jatuh Elsa',NULL,'Anting-anting emas 14k yang dipahat dengan lekukan mengkilap yang tinggi.','<p> Gespernya hipoalergenik. Tetesannya panjangnya 1 inci. Cukup ringan untuk dipakai setiap hari. Dirancang oleh bengkel internal di Florence.</p>'),('id',15,'Anting Jatuh Elsa',NULL,'Anting-anting emas 14k yang dipahat dengan lekukan mengkilap yang tinggi.','<p> Gespernya hipoalergenik. Tetesannya panjangnya 1 inci. Cukup ringan untuk dipakai setiap hari. Dirancang oleh bengkel internal di Florence.</p>'),('id',16,'Liontin Berlian',NULL,'Liontin berlian bulat cemerlang 0,25 karat dipasang pada rantai emas tipis.','<p>Batu tersebut bersertifikat GIA G/SI1. Bingkai cincin emas kuning 14 karat solid dan tali kotak 16 inci dengan cincin yang dapat disesuaikan hingga 18 inci.</p>'),('id',17,'Liontin Berlian',NULL,'Liontin berlian bulat cemerlang 0,25 karat dipasang pada rantai emas tipis.','<p>Batu tersebut bersertifikat GIA G/SI1. Bingkai cincin emas kuning 14 karat solid dan tali kotak 16 inci dengan cincin yang dapat disesuaikan hingga 18 inci.</p>'),('id',18,'Liontin Berlian',NULL,'Liontin berlian bulat cemerlang 0,25 karat dipasang pada rantai emas tipis.','<p>Batu tersebut bersertifikat GIA G/SI1. Bingkai cincin emas kuning 14 karat solid dan tali kotak 16 inci dengan cincin yang dapat disesuaikan hingga 18 inci.</p>'),('id',19,'Liontin Berlian',NULL,'Liontin berlian bulat cemerlang 0,25 karat dipasang pada rantai emas tipis.','<p>Batu tersebut bersertifikat GIA G/SI1. Bingkai cincin emas kuning 14 karat solid dan tali kotak 16 inci dengan cincin yang dapat disesuaikan hingga 18 inci.</p>'),('id',20,'Gelang Tenis Emas',NULL,'Gelang tenis klasik dengan berlian 1,5 karat dalam emas putih 14 karat.','<p>Berlian bulat buatan tangan yang brilian, warna F/G, kejernihan VS. Kunci pengaman penguncian ganda. Ukuran 7 inci, tersedia layanan pengubahan ukuran.</p>'),('id',21,'Gelang Tenis Emas',NULL,'Gelang tenis klasik dengan berlian 1,5 karat dalam emas putih 14 karat.','<p>Berlian bulat buatan tangan yang brilian, warna F/G, kejernihan VS. Kunci pengaman penguncian ganda. Ukuran 7 inci, tersedia layanan pengubahan ukuran.</p>'),('id',22,'Anting Mutiara Jatuh',NULL,'Anting-anting mutiara air tawar yang dipasang dengan tangan dengan pin berlapis emas 14k dan tautan fleksibel.','<p>8-9mm mutiara kelas AA. Tetesan sepanjang 1,5 inci. Cocok untuk gaya sehari-hari dan formal. Dilengkapi dengan tas beludru dan kain pembersih.</p>'),('id',23,'Anting Mutiara Jatuh',NULL,'Anting-anting mutiara air tawar yang dipasang dengan tangan dengan pin berlapis emas 14k dan tautan fleksibel.','<p>8-9mm mutiara kelas AA. Tetesan sepanjang 1,5 inci. Cocok untuk gaya sehari-hari dan formal. Dilengkapi dengan tas beludru dan kain pembersih.</p>'),('tr',1,'Tiffany Kilit Bileklik',NULL,'18 ayar sarı altın, menteşeli açıklıklı, miras tarzı asma kilit bileklik.','<p>18k altın el yapımı. Menteşeli açma-kapama kilitleme mekanizması. 60mm ve 65mm ebatlarında mevcuttur. El kabartmalı mücevher çantasıyla birlikte gelir.</p>'),('tr',2,'Bağlantılı Kolye Altın',NULL,'14 ayar sarı altın cilalı ataç stili bağlantı kolye, 18 inç uzunluğunda.','<p>Som 14 ayar altın zincir, karides asma kilit. Daha kısa bir kolye ucuyla güzel bir şekilde katmanlı olarak giyin veya açık bir yakanın üzerine tek başına giyin.</p>'),('tr',3,'Elsa Damla Küpe',NULL,'Çok parlak kıvrımlı, oymalı 14 ayar altın damla küpe.','<p>Toka hipoalerjeniktir. Damlalar 1 inç uzunluğundadır. Her gün giyilebilecek kadar hafif. Floransa\'daki şirket içi atölye tarafından tasarlandı.</p>'),('tr',4,'Pırlanta Kolye',NULL,'İnce altın zincir üzerinde 0,25 karat parlak yuvarlak pırlanta kolye seti.','<p>Taş GIA G/SI1 sertifikalıdır. Sağlam 14 ayar sarı altın çerçeve ve 18 inç\'e kadar ayarlanabilir halkalı 16 inç kutu kayış.</p>'),('tr',5,'Altın Tenis Bilekliği',NULL,'14 ayar beyaz altın, 1,5 karat pırlantalı klasik tenis bilekliği.','<p>Parlak elle ayarlanmış yuvarlak elmas, F/G rengi, VS berraklığı. Çift kilitleme emniyet kilidi. Boyut 7 inç, yeniden boyutlandırma hizmeti mevcut.</p>'),('tr',6,'İnci Damla Küpe',NULL,'14k altın kaplama pimli ve esnek bağlantılı, elle takılan tatlı su incisi damla küpe.','<p>8-9mm AA sınıfı inci. 1,5 inç uzunluğunda damlacık. Hem günlük hem de resmi tarzlara uygundur. Kadife çantası ve temizleme beziyle birlikte gelir.</p>'),('tr',7,'Tektaş Yüzük',NULL,'Bıçak kenarlı saplı, 18 ayar beyaz altın, parlak 0,5 karat altı uçlu tek yuvarlak pırlanta yüzük.','<p>GIA F/VS2 sertifikalı elmaslar. Sağlam 18 ayar beyaz altın üzerine monte edilmiş katedral stili. Ücretsiz yeniden boyutlandırma hizmetiyle 4-9 bedenleri mevcuttur.</p>'),('tr',8,'Sonsuzluk Bandı',NULL,'14 ayar sarı altından toplam ağırlığı 1,0 karat olan pırlantalı yivli sonsuzluk yüzüğü.','<p>Yüzüğün gövdesinin etrafına sürekli olarak parlak yuvarlak elmaslar monte edilmiştir. Renk F/G, saflık VS. 2,5 mm genişliğinde versiyon. Boyutu siparişe göre ayarlayın.</p>'),('tr',9,'Tiffany Kilit Bileklik',NULL,'18 ayar sarı altın, menteşeli açıklıklı, miras tarzı asma kilit bileklik.','<p>18k altın el yapımı. Menteşeli açma-kapama kilitleme mekanizması. 60mm ve 65mm ebatlarında mevcuttur. El kabartmalı mücevher çantasıyla birlikte gelir.</p>'),('tr',10,'Tiffany Kilit Bileklik',NULL,'18 ayar sarı altın, menteşeli açıklıklı, miras tarzı asma kilit bileklik.','<p>18k altın el yapımı. Menteşeli açma-kapama kilitleme mekanizması. 60mm ve 65mm ebatlarında mevcuttur. El kabartmalı mücevher çantasıyla birlikte gelir.</p>'),('tr',11,'Bağlantılı Kolye Altın',NULL,'14 ayar sarı altın cilalı ataç stili bağlantı kolye, 18 inç uzunluğunda.','<p>Som 14 ayar altın zincir, karides asma kilit. Daha kısa bir kolye ucuyla güzel bir şekilde katmanlı olarak giyin veya açık bir yakanın üzerine tek başına giyin.</p>'),('tr',12,'Bağlantılı Kolye Altın',NULL,'14 ayar sarı altın cilalı ataç stili bağlantı kolye, 18 inç uzunluğunda.','<p>Som 14 ayar altın zincir, karides asma kilit. Daha kısa bir kolye ucuyla güzel bir şekilde katmanlı olarak giyin veya açık bir yakanın üzerine tek başına giyin.</p>'),('tr',13,'Bağlantılı Kolye Altın',NULL,'14 ayar sarı altın cilalı ataç stili bağlantı kolye, 18 inç uzunluğunda.','<p>Som 14 ayar altın zincir, karides asma kilit. Daha kısa bir kolye ucuyla güzel bir şekilde katmanlı olarak giyin veya açık bir yakanın üzerine tek başına giyin.</p>'),('tr',14,'Elsa Damla Küpe',NULL,'Çok parlak kıvrımlı, oymalı 14 ayar altın damla küpe.','<p>Toka hipoalerjeniktir. Damlalar 1 inç uzunluğundadır. Her gün giyilebilecek kadar hafif. Floransa\'daki şirket içi atölye tarafından tasarlandı.</p>'),('tr',15,'Elsa Damla Küpe',NULL,'Çok parlak kıvrımlı, oymalı 14 ayar altın damla küpe.','<p>Toka hipoalerjeniktir. Damlalar 1 inç uzunluğundadır. Her gün giyilebilecek kadar hafif. Floransa\'daki şirket içi atölye tarafından tasarlandı.</p>'),('tr',16,'Pırlanta Kolye',NULL,'İnce altın zincir üzerinde 0,25 karat parlak yuvarlak pırlanta kolye seti.','<p>Taş GIA G/SI1 sertifikalıdır. Sağlam 14 ayar sarı altın çerçeve ve 18 inç\'e kadar ayarlanabilir halkalı 16 inç kutu kayış.</p>'),('tr',17,'Pırlanta Kolye',NULL,'İnce altın zincir üzerinde 0,25 karat parlak yuvarlak pırlanta kolye seti.','<p>Taş GIA G/SI1 sertifikalıdır. Sağlam 14 ayar sarı altın çerçeve ve 18 inç\'e kadar ayarlanabilir halkalı 16 inç kutu kayış.</p>'),('tr',18,'Pırlanta Kolye',NULL,'İnce altın zincir üzerinde 0,25 karat parlak yuvarlak pırlanta kolye seti.','<p>Taş GIA G/SI1 sertifikalıdır. Sağlam 14 ayar sarı altın çerçeve ve 18 inç\'e kadar ayarlanabilir halkalı 16 inç kutu kayış.</p>'),('tr',19,'Pırlanta Kolye',NULL,'İnce altın zincir üzerinde 0,25 karat parlak yuvarlak pırlanta kolye seti.','<p>Taş GIA G/SI1 sertifikalıdır. Sağlam 14 ayar sarı altın çerçeve ve 18 inç\'e kadar ayarlanabilir halkalı 16 inç kutu kayış.</p>'),('tr',20,'Altın Tenis Bilekliği',NULL,'14 ayar beyaz altın, 1,5 karat pırlantalı klasik tenis bilekliği.','<p>Parlak elle ayarlanmış yuvarlak elmas, F/G rengi, VS berraklığı. Çift kilitleme emniyet kilidi. Boyut 7 inç, yeniden boyutlandırma hizmeti mevcut.</p>'),('tr',21,'Altın Tenis Bilekliği',NULL,'14 ayar beyaz altın, 1,5 karat pırlantalı klasik tenis bilekliği.','<p>Parlak elle ayarlanmış yuvarlak elmas, F/G rengi, VS berraklığı. Çift kilitleme emniyet kilidi. Boyut 7 inç, yeniden boyutlandırma hizmeti mevcut.</p>'),('tr',22,'İnci Damla Küpe',NULL,'14k altın kaplama pimli ve esnek bağlantılı, elle takılan tatlı su incisi damla küpe.','<p>8-9mm AA sınıfı inci. 1,5 inç uzunluğunda damlacık. Hem günlük hem de resmi tarzlara uygundur. Kadife çantası ve temizleme beziyle birlikte gelir.</p>'),('tr',23,'İnci Damla Küpe',NULL,'14k altın kaplama pimli ve esnek bağlantılı, elle takılan tatlı su incisi damla küpe.','<p>8-9mm AA sınıfı inci. 1,5 inç uzunluğunda damlacık. Hem günlük hem de resmi tarzlara uygundur. Kadife çantası ve temizleme beziyle birlikte gelir.</p>'),('vi',1,'Vòng tay khóa Tiffany Lock',NULL,'Vòng tay khóa ổ kiểu di sản bằng vàng vàng 18k với khớp mở bản lề.','<p>Vàng 18k hoàn thiện thủ công. Cơ chế khóa mở-đóng bằng bản lề. Có kích cỡ 60mm và 65mm. Kèm túi đựng trang sức dập nổi thủ công.</p>'),('vi',2,'Dây chuyền mắt xích vàng',NULL,'Dây chuyền mắt xích kiểu kẹp giấy đánh bóng bằng vàng vàng 14k, dài 18 inch.','<p>Mắt xích vàng 14k đặc, khóa móc tôm. Đeo lớp đẹp với mặt dây ngắn hơn hoặc đeo riêng trên cổ áo hở.</p>'),('vi',3,'Hoa tai giọt nước Elsa',NULL,'Hoa tai giọt nước điêu khắc bằng vàng 14k với dáng cong bóng cao.','<p>Chốt cài không gây dị ứng. Giọt dài 1 inch. Đủ nhẹ để đeo hằng ngày. Thiết kế bởi xưởng chế tác nội bộ tại Florence.</p>'),('vi',4,'Mặt dây kim cương',NULL,'Mặt dây kim cương tròn brilliant 0,25ct ốp viền trên dây chuyền vàng mảnh.','<p>Viên đá đạt chứng nhận GIA G/SI1. Viền vàng vàng 14k đặc và dây hộp 16 inch với vòng điều chỉnh tới 18 inch.</p>'),('vi',5,'Vòng tay tennis vàng',NULL,'Vòng tay tennis cổ điển với kim cương cài chấu tổng trọng lượng 1,5ct bằng vàng trắng 14k.','<p>Kim cương tròn brilliant cài tay, màu F/G, độ tinh khiết VS. Khóa an toàn khóa kép. Kích cỡ 7 inch, có dịch vụ chỉnh kích cỡ.</p>'),('vi',6,'Hoa tai giọt ngọc trai',NULL,'Hoa tai giọt ngọc trai nước ngọt cài tay với chốt mạ vàng 14k và mắt nối linh hoạt.','<p>Ngọc trai 8-9mm hạng AA. Giọt dài 1,5 inch. Hợp với cả phong cách hằng ngày lẫn trang trọng. Kèm túi nhung và khăn lau.</p>'),('vi',7,'Nhẫn kim cương đơn',NULL,'Nhẫn kim cương đơn tròn brilliant 0,5ct sáu chấu bằng vàng trắng 18k với thân nhẫn cạnh dao.','<p>Kim cương đạt chứng nhận GIA F/VS2. Gắn kiểu nhà thờ trên vàng trắng 18k đặc. Có kích cỡ 4-9 với dịch vụ chỉnh size miễn phí.</p>'),('vi',8,'Nhẫn vĩnh cửu',NULL,'Nhẫn vĩnh cửu cài rãnh kim cương với tổng trọng lượng 1,0ct bằng vàng vàng 14k.','<p>Kim cương tròn brilliant gắn liên tục quanh thân nhẫn. Màu F/G, độ tinh khiết VS. Bản rộng 2,5mm. Chỉnh kích cỡ theo đơn đặt.</p>'),('vi',9,'Vòng tay khóa Tiffany Lock',NULL,'Vòng tay khóa ổ kiểu di sản bằng vàng vàng 18k với khớp mở bản lề.','<p>Vàng 18k hoàn thiện thủ công. Cơ chế khóa mở-đóng bằng bản lề. Có kích cỡ 60mm và 65mm. Kèm túi đựng trang sức dập nổi thủ công.</p>'),('vi',10,'Vòng tay khóa Tiffany Lock',NULL,'Vòng tay khóa ổ kiểu di sản bằng vàng vàng 18k với khớp mở bản lề.','<p>Vàng 18k hoàn thiện thủ công. Cơ chế khóa mở-đóng bằng bản lề. Có kích cỡ 60mm và 65mm. Kèm túi đựng trang sức dập nổi thủ công.</p>'),('vi',11,'Dây chuyền mắt xích vàng',NULL,'Dây chuyền mắt xích kiểu kẹp giấy đánh bóng bằng vàng vàng 14k, dài 18 inch.','<p>Mắt xích vàng 14k đặc, khóa móc tôm. Đeo lớp đẹp với mặt dây ngắn hơn hoặc đeo riêng trên cổ áo hở.</p>'),('vi',12,'Dây chuyền mắt xích vàng',NULL,'Dây chuyền mắt xích kiểu kẹp giấy đánh bóng bằng vàng vàng 14k, dài 18 inch.','<p>Mắt xích vàng 14k đặc, khóa móc tôm. Đeo lớp đẹp với mặt dây ngắn hơn hoặc đeo riêng trên cổ áo hở.</p>'),('vi',13,'Dây chuyền mắt xích vàng',NULL,'Dây chuyền mắt xích kiểu kẹp giấy đánh bóng bằng vàng vàng 14k, dài 18 inch.','<p>Mắt xích vàng 14k đặc, khóa móc tôm. Đeo lớp đẹp với mặt dây ngắn hơn hoặc đeo riêng trên cổ áo hở.</p>'),('vi',14,'Hoa tai giọt nước Elsa',NULL,'Hoa tai giọt nước điêu khắc bằng vàng 14k với dáng cong bóng cao.','<p>Chốt cài không gây dị ứng. Giọt dài 1 inch. Đủ nhẹ để đeo hằng ngày. Thiết kế bởi xưởng chế tác nội bộ tại Florence.</p>'),('vi',15,'Hoa tai giọt nước Elsa',NULL,'Hoa tai giọt nước điêu khắc bằng vàng 14k với dáng cong bóng cao.','<p>Chốt cài không gây dị ứng. Giọt dài 1 inch. Đủ nhẹ để đeo hằng ngày. Thiết kế bởi xưởng chế tác nội bộ tại Florence.</p>'),('vi',16,'Mặt dây kim cương',NULL,'Mặt dây kim cương tròn brilliant 0,25ct ốp viền trên dây chuyền vàng mảnh.','<p>Viên đá đạt chứng nhận GIA G/SI1. Viền vàng vàng 14k đặc và dây hộp 16 inch với vòng điều chỉnh tới 18 inch.</p>'),('vi',17,'Mặt dây kim cương',NULL,'Mặt dây kim cương tròn brilliant 0,25ct ốp viền trên dây chuyền vàng mảnh.','<p>Viên đá đạt chứng nhận GIA G/SI1. Viền vàng vàng 14k đặc và dây hộp 16 inch với vòng điều chỉnh tới 18 inch.</p>'),('vi',18,'Mặt dây kim cương',NULL,'Mặt dây kim cương tròn brilliant 0,25ct ốp viền trên dây chuyền vàng mảnh.','<p>Viên đá đạt chứng nhận GIA G/SI1. Viền vàng vàng 14k đặc và dây hộp 16 inch với vòng điều chỉnh tới 18 inch.</p>'),('vi',19,'Mặt dây kim cương',NULL,'Mặt dây kim cương tròn brilliant 0,25ct ốp viền trên dây chuyền vàng mảnh.','<p>Viên đá đạt chứng nhận GIA G/SI1. Viền vàng vàng 14k đặc và dây hộp 16 inch với vòng điều chỉnh tới 18 inch.</p>'),('vi',20,'Vòng tay tennis vàng',NULL,'Vòng tay tennis cổ điển với kim cương cài chấu tổng trọng lượng 1,5ct bằng vàng trắng 14k.','<p>Kim cương tròn brilliant cài tay, màu F/G, độ tinh khiết VS. Khóa an toàn khóa kép. Kích cỡ 7 inch, có dịch vụ chỉnh kích cỡ.</p>'),('vi',21,'Vòng tay tennis vàng',NULL,'Vòng tay tennis cổ điển với kim cương cài chấu tổng trọng lượng 1,5ct bằng vàng trắng 14k.','<p>Kim cương tròn brilliant cài tay, màu F/G, độ tinh khiết VS. Khóa an toàn khóa kép. Kích cỡ 7 inch, có dịch vụ chỉnh kích cỡ.</p>'),('vi',22,'Hoa tai giọt ngọc trai',NULL,'Hoa tai giọt ngọc trai nước ngọt cài tay với chốt mạ vàng 14k và mắt nối linh hoạt.','<p>Ngọc trai 8-9mm hạng AA. Giọt dài 1,5 inch. Hợp với cả phong cách hằng ngày lẫn trang trọng. Kèm túi nhung và khăn lau.</p>'),('vi',23,'Hoa tai giọt ngọc trai',NULL,'Hoa tai giọt ngọc trai nước ngọt cài tay với chốt mạ vàng 14k và mắt nối linh hoạt.','<p>Ngọc trai 8-9mm hạng AA. Giọt dài 1,5 inch. Hợp với cả phong cách hằng ngày lẫn trang trọng. Kèm túi nhung và khăn lau.</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=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

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

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

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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

--
-- 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 19:06:15','2026-05-28 19:06:15');

--
