--
-- 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,'byisMEy17UQvp7Uz6HVbHL3qwuR7tO8z',1,'2026-05-28 19:03:26','2026-05-28 19:03:26','2026-05-28 19:03:26');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `categories` VALUES (1,'Style Inspiration',0,'Mood boards, palette stories, and rooms that show whats possible.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2026-05-28 19:03:27','2026-05-28 19:03:27'),(2,'Care &amp; Maintenance',0,'How to keep wood, leather, and upholstery looking their best for decades.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:03:27','2026-05-28 19:03:27'),(3,'Buying Guides',0,'Sofa, mattress, and dining-table comparisons grounded in real-world testing.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:03:27','2026-05-28 19:03:27'),(4,'Behind the Craft',0,'Workshop visits, maker profiles, and the people behind your favorite pieces.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:03:27','2026-05-28 19:03:27'),(5,'Spaces',0,'Real homes, real apartments — design ideas you can actually use.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:03:27','2026-05-28 19:03:27');

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

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

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

INSERT INTO `categories_translations` VALUES ('ar',1,'إلهام الأسلوب','لوحات الإلهام وقصص الألوان والغرف التي توضح ما هو ممكن.'),('ar',2,'Care &amp; Maintenance','How to keep wood, leather, and upholstery looking their best for decades.'),('ar',3,'أدلة الشراء','يساعدك دليل المقارنة المستقل على اختيار المنتج المناسب لاحتياجاتك وميزانيتك.'),('ar',4,'خلف الحرفة','زيارات لورش العمل وصور الحرفيين والأشخاص الذين يقفون وراء العناصر المفضلة لديك.'),('ar',5,'المساحات','منازل حقيقية، وشقق حقيقية - أفكار تصميمية يمكنك تطبيقها على الفور.'),('fr',1,'Inspirations de style','Des tableaux d\'inspiration, des histoires de palettes de couleurs et des pièces qui montrent ce qui est possible.'),('fr',2,'Care &amp; Maintenance','How to keep wood, leather, and upholstery looking their best for decades.'),('fr',3,'Guides d\'achat','Un guide de comparaison indépendant vous aide à choisir le produit adapté à vos besoins et à votre budget.'),('fr',4,'Derrière le métier','Visites d\'ateliers, portraits d\'artisans et personnes derrière vos objets préférés.'),('fr',5,'Espaces','De vraies maisons, de vrais appartements : des idées de design que vous pouvez appliquer immédiatement.'),('id',1,'Inspirasi Gaya','Papan inspirasi, cerita palet warna, dan ruangan yang menunjukkan apa yang mungkin.'),('id',2,'Care &amp; Maintenance','How to keep wood, leather, and upholstery looking their best for decades.'),('id',3,'Panduan Membeli','Panduan perbandingan independen membantu Anda memilih produk yang tepat sesuai kebutuhan dan anggaran Anda.'),('id',4,'Dibalik Kerajinan itu','Kunjungan lokakarya, potret pengrajin, dan orang-orang di balik barang favorit Anda.'),('id',5,'Spasi','Rumah sungguhan, apartemen sungguhan — ide desain yang dapat Anda terapkan segera.'),('tr',1,'Stil İlhamı','Neyin mümkün olduğunu gösteren ilham panoları, renk paleti hikayeleri ve odalar.'),('tr',2,'Care &amp; Maintenance','How to keep wood, leather, and upholstery looking their best for decades.'),('tr',3,'Satın Alma Kılavuzları','Bağımsız karşılaştırma kılavuzu ihtiyaçlarınıza ve bütçenize uygun doğru ürünü seçmenize yardımcı olur.'),('tr',4,'Zanaatın Arkasında','Atölye ziyaretleri, zanaatkar portreleri ve en sevdiğiniz eşyaların arkasındaki insanlar.'),('tr',5,'Alanlar','Gerçek evler, gerçek daireler; hemen uygulayabileceğiniz tasarım fikirleri.'),('vi',1,'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',2,'Care &amp; Maintenance','How to keep wood, leather, and upholstery looking their best for decades.'),('vi',3,'Hướng dẫn mua sắm','Hướng dẫn so sánh độc lập giúp bạn chọn sản phẩm phù hợp với nhu cầu và ngân sách.'),('vi',4,'Đằng Sau Nghề Thủ Công','Những chuyến thăm xưởng, chân dung nghệ nhân và những con người đằng sau món đồ yêu thích của bạn.'),('vi',5,'Không Gian','Những ngôi nhà thật, những căn hộ thật — ý tưởng thiết kế bạn có thể áp dụng ngay.');

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `ec_brands` VALUES (1,'Anthro','Eclectic apparel and home goods inspired by global craftsmanship traditions.','https://example.com/anthro','brands/anthro.png','published',0,1,'2026-05-28 19:03:26','2026-05-28 19:03:26'),(2,'Anvouge','Modern fashion essentials cut from sustainable fibers.','https://example.com/anvouge','brands/anvouge.png','published',1,1,'2026-05-28 19:03:26','2026-05-28 19:03:26'),(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:03:26','2026-05-28 19:03:26'),(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:03:26','2026-05-28 19:03:26'),(5,'Cheryl','Bold prints and silhouettes for the contemporary woman.','https://example.com/cheryl','brands/cheryl.png','published',4,0,'2026-05-28 19:03:26','2026-05-28 19:03:26'),(6,'Crate','Mid-century-inspired furniture built to last generations.','https://example.com/crate','brands/crate.png','published',5,1,'2026-05-28 19:03:26','2026-05-28 19:03:26'),(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:03:26','2026-05-28 19:03:26'),(8,'Intdeco','Interior accents that bridge minimalism and warmth.','https://example.com/intdeco','brands/intdeco.png','published',7,0,'2026-05-28 19:03:26','2026-05-28 19:03:26'),(9,'Modave','Performance activewear made with recycled high-stretch knits.','https://example.com/modave','brands/modave.png','published',8,0,'2026-05-28 19:03:26','2026-05-28 19:03:26'),(10,'Panadoxn','Botanical skincare formulated by clinical herbalists.','https://example.com/panadoxn','brands/panadoxn.png','published',9,0,'2026-05-28 19:03:26','2026-05-28 19:03:26'),(11,'Shangxi','Heritage tea, ceramics, and meditation accessories.','https://example.com/shangxi','brands/shangxi.png','published',10,0,'2026-05-28 19:03:26','2026-05-28 19:03:26'),(12,'Sopify','Smart home devices designed for renters and travelers.','https://example.com/sopify','brands/sopify.png','published',11,0,'2026-05-28 19:03:26','2026-05-28 19:03:26');

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

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

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

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

INSERT INTO `ec_customer_addresses` VALUES (1,'Emma Collins','customer@botble.com','+1-555-0110','DE','Pennsylvania','Los Angeles','987 Birch Boulevard',1,1,'2026-05-28 19:03:36','2026-05-28 19:03:36','90210'),(2,'Emma Collins','customer@botble.com','+1-555-0109','US','Georgia','Los Angeles','321 Maple Drive',1,0,'2026-05-28 19:03:36','2026-05-28 19:03:36','77001'),(3,'Sophia Ramirez','vendor@botble.com','+1-555-0109','US','Arizona','San Diego','258 Walnut Way',2,1,'2026-05-28 19:03:37','2026-05-28 19:03:37','85001'),(4,'Sophia Ramirez','vendor@botble.com','+1-555-0101','DE','Illinois','San Diego','456 Oak Avenue',2,0,'2026-05-28 19:03:37','2026-05-28 19:03:37','10001'),(5,'Olivia Carter','customer1@example.com','+1-555-0101','CA','California','Chicago','789 Pine Road',3,1,'2026-05-28 19:03:37','2026-05-28 19:03:37','48201'),(6,'Ava Mitchell','customer2@example.com','+1-555-0110','US','New York','Chicago','654 Cedar Lane',4,1,'2026-05-28 19:03:37','2026-05-28 19:03:37','60601'),(7,'Isabella Brooks','customer3@example.com','+1-555-0108','DE','Illinois','Phoenix','987 Birch Boulevard',5,1,'2026-05-28 19:03:37','2026-05-28 19:03:37','30301'),(8,'James Whitfield','customer4@example.com','+1-555-0101','AU','Georgia','San Diego','789 Pine Road',6,1,'2026-05-28 19:03:38','2026-05-28 19:03:38','10001'),(9,'Liam Bennett','customer5@example.com','+1-555-0104','AU','Illinois','Austin','123 Main Street',7,1,'2026-05-28 19:03:38','2026-05-28 19:03:38','80201'),(10,'Noah Patterson','customer6@example.com','+1-555-0110','AU','Pennsylvania','Chicago','369 Cherry Circle',8,1,'2026-05-28 19:03:38','2026-05-28 19:03:38','77001'),(11,'Charlotte Reed','customer7@example.com','+1-555-0104','CA','New York','New York','789 Pine Road',9,1,'2026-05-28 19:03:38','2026-05-28 19:03:38','85001'),(12,'Amelia Foster','customer8@example.com','+1-555-0104','CA','California','San Diego','123 Main Street',10,1,'2026-05-28 19:03:39','2026-05-28 19:03:39','77001');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `ec_customers` VALUES (1,'Emma Collins','customer@botble.com','$2y$12$JTCXO6YnCYVJMDO7SqYgoeCaJF3DM.p91VBQjluLJ38WYGBYvlFRy','testimonials/avatar-1.jpg','1995-05-04','regular',NULL,'+1-555-0101',NULL,'2026-05-28 19:03:36','2026-05-28 19:03:36','2026-05-29 02:03:36',NULL,0,NULL,'activated',NULL,NULL,NULL,0),(2,'Sophia Ramirez','vendor@botble.com','$2y$12$txKOt27rCRfdgMSkiiSQa.I.VDlvi/PJxaDL9gYWYrv8WXoqgWdVG','testimonials/avatar-2.jpg','1986-05-27','regular',NULL,'+1-555-0102',NULL,'2026-05-28 19:03:37','2026-05-28 19:03:39','2026-05-29 02:03:36',NULL,1,'2026-05-29 02:03:39','activated',NULL,NULL,NULL,0),(3,'Olivia Carter','customer1@example.com','$2y$12$5sUGdxd34venE9I6kkUZ2e7FqJkiEbrr3fWeQJ0DqfwV.GO.7Esne','testimonials/avatar-3.jpg','2003-05-01','regular',NULL,'+1-555-0107',NULL,'2026-05-28 19:03:37','2026-05-28 19:03:39','2026-05-29 02:03:36',NULL,1,'2026-05-29 02:03:39','activated',NULL,NULL,NULL,0),(4,'Ava Mitchell','customer2@example.com','$2y$12$EtCB5IM6UnTXSV18NLIl8uqgSATRvu7cw/fylqXoR5EHIviNhiX2C','testimonials/avatar-4.jpg','1997-04-29','regular',NULL,'+1-555-0105',NULL,'2026-05-28 19:03:37','2026-05-28 19:03:39','2026-05-29 02:03:36',NULL,1,'2026-05-29 02:03:39','activated',NULL,NULL,NULL,0),(5,'Isabella Brooks','customer3@example.com','$2y$12$C5wu4iJHqPbT71QzUT0.kuIt7DRQWKGDpVnOl/450N9WDdRszF2nu','testimonials/avatar-5.jpg','1979-05-04','regular',NULL,'+1-555-0104',NULL,'2026-05-28 19:03:37','2026-05-28 19:03:40','2026-05-29 02:03:36',NULL,1,'2026-05-29 02:03:39','activated',NULL,NULL,NULL,0),(6,'James Whitfield','customer4@example.com','$2y$12$G8.AQc9o.evylNOiso5zaOxNfrti0yUosaHqQ3w43eYbqLEah/dka','testimonials/avatar-6.jpg','2005-05-27','regular',NULL,'+1-555-0110',NULL,'2026-05-28 19:03:38','2026-05-28 19:03:40','2026-05-29 02:03:36',NULL,1,'2026-05-29 02:03:39','activated',NULL,NULL,NULL,0),(7,'Liam Bennett','customer5@example.com','$2y$12$h.hqaqW8It/XWkoHWKsruuAeSD8CcftmO7YjmrLpI.MdOMlAcFkca','testimonials/avatar-7.jpg','1977-05-24','regular',NULL,'+1-555-0102',NULL,'2026-05-28 19:03:38','2026-05-28 19:03:40','2026-05-29 02:03:36',NULL,1,'2026-05-29 02:03:39','activated',NULL,NULL,NULL,0),(8,'Noah Patterson','customer6@example.com','$2y$12$n.5FI83ewSxaVRzhyBPV0.M0vdYAJquG9dQnxtmUM..rg5K2EKtW6','testimonials/avatar-8.jpg','1992-05-11','regular',NULL,'+1-555-0103',NULL,'2026-05-28 19:03:38','2026-05-28 19:03:40','2026-05-29 02:03:36',NULL,1,'2026-05-29 02:03:39','activated',NULL,NULL,NULL,0),(9,'Charlotte Reed','customer7@example.com','$2y$12$NaVEgVndYNBXbMNEdGcfvubNZcw/xM9oOd1cnD7o2t02rTy6eDpxy','testimonials/avatar-9.jpg','1976-05-12','regular',NULL,'+1-555-0101',NULL,'2026-05-28 19:03:38','2026-05-28 19:03:41','2026-05-29 02:03:36',NULL,1,'2026-05-29 02:03:39','activated',NULL,NULL,NULL,0),(10,'Amelia Foster','customer8@example.com','$2y$12$Jxwegw7NSsv8Dv0LI6KHSuLE8XlQwNQtIwlumM5asLlwVw3BYeC2C','testimonials/avatar-10.jpg','1980-05-23','regular',NULL,'+1-555-0105',NULL,'2026-05-28 19:03:39','2026-05-28 19:03:41','2026-05-29 02:03:36',NULL,0,NULL,'activated',NULL,NULL,NULL,0);

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `ec_discounts` VALUES (1,'Welcome 10% Off','WELCOME10','2026-05-28 02:03:39','2026-07-28 02:03:39',NULL,0,10,'coupon',0,0,NULL,NULL,'percentage','all-orders',0.00,0,1,'2026-05-28 19:03:39','2026-05-28 19:03:39',NULL,'A welcome discount for first-time shoppers — 10% off any order.'),(2,'Free Shipping Over $50','FREESHIP','2026-05-28 02:03:39',NULL,NULL,0,100,'coupon',0,0,NULL,NULL,'shipping','all-orders',50.00,0,1,'2026-05-28 19:03:39','2026-05-28 19:03:39',NULL,'Free shipping on any order $50 or above.'),(3,'Spring Sale — $25 Off','SPRING25','2026-05-28 02:03:39','2026-06-28 02:03:39',500,0,25,'coupon',0,0,NULL,NULL,'amount','all-orders',150.00,0,1,'2026-05-28 19:03:39','2026-05-28 19:03:39',NULL,'A flat $25 off orders over $150.'),(4,'VIP Member 20% Off','VIP20','2026-05-28 02:03:39','2026-08-27 02:03:39',NULL,0,20,'coupon',0,0,NULL,NULL,'percentage','all-orders',100.00,0,1,'2026-05-28 19:03:39','2026-05-28 19:03:39',NULL,'Exclusive 20% off for newsletter subscribers.'),(5,'Bundle & Save $50','BUNDLE50','2026-05-28 02:03:39','2026-07-13 02:03:39',NULL,0,50,'coupon',0,0,NULL,NULL,'amount','all-orders',300.00,0,1,'2026-05-28 19:03:39','2026-05-28 19:03:39',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,1,909.3,50,0),(1,4,1329.3,50,0),(1,2,321.3,50,0),(1,7,1119.3,50,0),(1,5,272.3,50,0),(1,6,188.3,50,0),(1,3,510.3,50,0),(1,9,1259.3,50,0),(1,10,118.3,50,0),(2,5,291.75,75,0),(2,8,1424.25,75,0),(2,3,546.75,75,0),(2,10,126.75,75,0),(2,2,344.25,75,0),(2,9,1349.25,75,0),(2,1,974.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:03:39','published','2026-05-28 19:03:39','2026-05-28 19:03:39'),(2,'Weekend Doorbusters','2026-06-03 02:03:39','published','2026-05-28 19:03:39','2026-05-28 19:03:39');

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `ec_product_categories` VALUES (1,'New Arrivals',NULL,0,'The latest releases from our designer roster — fresh forms and finishes.','published',0,'categories/furniture/cate-1.jpg',1,'2026-05-28 19:03:28','2026-05-28 19:03:28',NULL,NULL),(2,'Sofas',NULL,0,'Two- and three-seat sofas, modular sectionals, and statement loveseats.','published',1,'categories/furniture/cate-2.jpg',1,'2026-05-28 19:03:28','2026-05-28 19:03:28',NULL,NULL),(3,'Chairs',NULL,0,'Lounge chairs, accent seats, and dining chairs sourced from artisan makers.','published',2,'categories/furniture/cate-3.jpg',1,'2026-05-28 19:03:29','2026-05-28 19:03:29',NULL,NULL),(4,'Tables',NULL,0,'Dining tables, coffee tables, and side tables in wood, stone, and steel.','published',3,'categories/furniture/cate-4.jpg',1,'2026-05-28 19:03:29','2026-05-28 19:03:29',NULL,NULL),(5,'Beds',NULL,0,'Platform beds, upholstered headboards, and bedroom anchor pieces.','published',4,'categories/furniture/cate-5.jpg',1,'2026-05-28 19:03:29','2026-05-28 19:03:29',NULL,NULL),(6,'Storage',NULL,0,'Shelving, sideboards, and credenzas crafted to organize beautifully.','published',5,'categories/furniture/cate-6.jpg',1,'2026-05-28 19:03:30','2026-05-28 19:03:30',NULL,NULL);

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

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

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

INSERT INTO `ec_product_categories_translations` VALUES ('ar',1,'الوافدون الجدد',NULL,'أحدث الموديلات من فريق المصممين لدينا – أشكال وتشطيبات جديدة.'),('ar',2,'الأرائك',NULL,'أرائك ذات مقعدين وثلاثة مقاعد وأرائك زاوية معيارية وكراسي مزدوجة.'),('ar',3,'الكراسي',NULL,'يتم اختيار كراسي الاسترخاء والكراسي المميزة وكراسي تناول الطعام من الحرفيين.'),('ar',4,'الجداول',NULL,'طاولات الطعام وطاولات الشاي والطاولات الجانبية مصنوعة من الخشب والحجر والفولاذ.'),('ar',5,'سرير',NULL,'أسرة ذات منصات وألواح أمامية منجدة ودعائم أساسية لغرفة النوم.'),('ar',6,'تخزين',NULL,'تم تصميم الرفوف والبوفيهات والخزائن المنخفضة لترتيبها بشكل جميل.'),('fr',1,'Nouveautés',NULL,'Les derniers modèles de notre équipe de designers — des formes et des finitions fraîches.'),('fr',2,'Canapés',NULL,'Canapés à deux et trois places, canapés d\'angle modulables et fauteuils d\'appoint doubles.'),('fr',3,'Chaises',NULL,'Les fauteuils de relaxation, les fauteuils d\'appoint et les chaises de salle à manger sont sélectionnés auprès d\'artisans.'),('fr',4,'Tableaux',NULL,'Les tables à manger, les tables à thé et les tables d\'appoint sont en bois, en pierre et en acier.'),('fr',5,'Lits',NULL,'Lits plateforme, têtes de lit rembourrées et piliers de chambre.'),('fr',6,'Stockage',NULL,'Les étagères, buffets et meubles bas sont conçus pour s\'agencer à merveille.'),('id',1,'Pendatang Baru',NULL,'Model terbaru dari tim desainer kami — bentuk dan hasil akhir yang segar.'),('id',2,'Sofa',NULL,'Sofa dua dan tiga dudukan, sofa sudut modular, dan kursi beraksen ganda.'),('id',3,'Kursi',NULL,'Kursi relaksasi, kursi beraksen, dan kursi makan dipilih dari pengrajin.'),('id',4,'Tabel',NULL,'Meja makan, meja teh, dan meja samping terbuat dari kayu, batu, dan baja.'),('id',5,'Tempat tidur',NULL,'Tempat tidur platform, sandaran kepala berlapis kain, dan andalan kamar tidur.'),('id',6,'Penyimpanan',NULL,'Rak, bufet, dan lemari rendah dibuat ditata dengan indah.'),('tr',1,'Yeni Gelenler',NULL,'Tasarımcı ekibimizin en yeni modelleri; yeni şekiller ve yüzeyler.'),('tr',2,'Kanepeler',NULL,'İkili ve üçlü kanepeler, modüler köşe kanepeler ve çift vurgulu sandalyeler.'),('tr',3,'Sandalyeler',NULL,'Dinlenme sandalyeleri, vurgulu sandalyeler ve yemek sandalyeleri zanaatkârlar arasından seçilmektedir.'),('tr',4,'Tablolar',NULL,'Yemek masaları, çay masaları ve yan sehpalar ahşap, taş ve çelikten yapılmıştır.'),('tr',5,'Yataklar',NULL,'Platform yataklar, döşemeli yatak başlıkları ve yatak odası dayanakları.'),('tr',6,'Depolamak',NULL,'Raflar, büfeler ve alçak dolaplar güzelce düzenlenmek üzere tasarlandı.'),('vi',1,'Hàng Mới Về',NULL,'Những mẫu mới nhất từ đội ngũ nhà thiết kế của chúng tôi — hình khối và lớp hoàn thiện mới mẻ.'),('vi',2,'Ghế Sofa',NULL,'Ghế sofa hai và ba chỗ, sofa góc module và ghế đôi tạo điểm nhấn.'),('vi',3,'Ghế',NULL,'Ghế thư giãn, ghế tạo điểm nhấn và ghế ăn được tuyển chọn từ các nghệ nhân chế tác.'),('vi',4,'Bàn',NULL,'Bàn ăn, bàn trà và bàn phụ bằng gỗ, đá và thép.'),('vi',5,'Giường',NULL,'Giường bệ, đầu giường bọc vải và những món đồ trụ cột cho phòng ngủ.'),('vi',6,'Lưu Trữ',NULL,'Kệ, tủ buffet và tủ thấp được chế tác để sắp xếp một cách đẹp mắt.');

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

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

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


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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `ec_product_collections` VALUES (1,'Modern Living Room','modern-living-room','Sofas, accent chairs, and tables curated for the way you live now.','collection/furniture/cls-1.jpg','published','2026-05-28 19:03:31','2026-05-28 19:03:31',1),(2,'Calm Bedroom','calm-bedroom','Beds, nightstands, and storage built for restful sleep and quiet mornings.','collection/furniture/cls-2.jpg','published','2026-05-28 19:03:31','2026-05-28 19:03:31',1),(3,'Workspace Essentials','workspace-essentials','Desks, lighting, and seating for a focused, design-forward home office.','collection/furniture/cls-3.jpg','published','2026-05-28 19:03:31','2026-05-28 19:03:31',1),(4,'Storage &amp; Organization','storage-organization','Shelving and storage that double as design statements.','collection/cls-4.jpg','published','2026-05-28 19:03:31','2026-05-28 19:03:31',0),(5,'Tables &amp; Surfaces','tables-surfaces','Coffee tables, side tables, and surfaces for every room.','collection/cls-5.jpg','published','2026-05-28 19:03:31','2026-05-28 19:03:31',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,'Storage &amp; Organization','Shelving and storage that double as design statements.'),('ar',5,'Tables &amp; Surfaces','Coffee tables, side tables, and surfaces for every room.'),('fr',1,'Salon moderne','Les canapés, les chaises d\'appoint et les tables sont adaptés à votre façon de vivre d\'aujourd\'hui.'),('fr',2,'Chambre Calme','Les lits, les tables de nuit et les armoires de rangement sont conçus pour un sommeil réparateur et des matinées tranquilles.'),('fr',3,'Les essentiels de l\'espace de travail','Bureau, éclairage et sièges pour un bureau à domicile ciblé et inspiré du design.'),('fr',4,'Storage &amp; Organization','Shelving and storage that double as design statements.'),('fr',5,'Tables &amp; Surfaces','Coffee tables, side tables, and surfaces for every room.'),('id',1,'Ruang Tamu Modern','Sofa, kursi beraksen, dan meja disesuaikan dengan gaya hidup Anda saat ini.'),('id',2,'Kamar Tidur yang Tenang','Tempat tidur, meja samping tempat tidur, dan lemari penyimpanan dibuat untuk tidur nyenyak dan pagi yang tenang.'),('id',3,'Hal Penting Ruang Kerja','Meja, pencahayaan, dan tempat duduk untuk kantor rumah yang fokus dan terinspirasi desain.'),('id',4,'Storage &amp; Organization','Shelving and storage that double as design statements.'),('id',5,'Tables &amp; Surfaces','Coffee tables, side tables, and surfaces for every room.'),('tr',1,'Modern Oturma Odası','Kanepeler, vurgulu sandalyeler ve masalar bugün yaşama şeklinize göre seçilmiştir.'),('tr',2,'Sakin Yatak Odası','Yataklar, komodinler ve saklama dolapları dinlendirici bir uyku ve sessiz sabahlar için tasarlandı.'),('tr',3,'Çalışma Alanının Temelleri','Odaklanmış, tasarımdan ilham alan bir ev ofisi için masa, aydınlatma ve oturma alanı.'),('tr',4,'Storage &amp; Organization','Shelving and storage that double as design statements.'),('tr',5,'Tables &amp; Surfaces','Coffee tables, side tables, and surfaces for every room.'),('vi',1,'Phòng Khách Hiện Đại','Ghế sofa, ghế tạo điểm nhấn và bàn được tuyển chọn theo cách bạn sống ngày nay.'),('vi',2,'Phòng Ngủ An Yên','Giường, tủ đầu giường và tủ lưu trữ được tạo nên cho giấc ngủ thư thái và những buổi sáng tĩnh lặng.'),('vi',3,'Vật Dụng Thiết Yếu Cho Không Gian Làm Việc','Bàn làm việc, đèn chiếu sáng và ghế ngồi cho một văn phòng tại nhà tập trung, đậm chất thiết kế.'),('vi',4,'Storage &amp; Organization','Shelving and storage that double as design statements.'),('vi',5,'Tables &amp; Surfaces','Coffee tables, side tables, and surfaces for every room.');

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

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

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

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


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

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

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

INSERT INTO `ec_product_label_products` VALUES (2,9),(3,3),(6,6);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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

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

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

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

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

INSERT INTO `ec_products` VALUES (1,'Imola Armchair','imola-armchair','Sculptural lounge armchair upholstered in boucle with solid oak base.','<p>FSC-certified oak frame with high-resilience foam and natural latex cushioning. Designed for living rooms that earn second looks.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-1.jpg\"]',NULL,'PU-155',0,13,0,1,'in_stock',0,NULL,2,0,0,10,2.90,0,1299,999,NULL,NULL,15,20,19,627,NULL,'standard',60116,'2026-05-28 19:03:33','2026-05-28 19:03:41',1,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homefurniture/files/products/product-1.jpg','physical','4862021380150',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(2,'Expose Side Table','expose-side-table','Sculpted side table with travertine top and powder-coated steel base.','<p>Each travertine slab is unique — natural veining and subtle tonal variations are the signature of the piece.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-2.jpg\"]',NULL,'FF-161-A1',0,19,0,1,'in_stock',0,NULL,7,0,2,10,3.50,0,459,379,NULL,NULL,15,13,10,744,NULL,'standard',176102,'2026-05-28 19:03:33','2026-05-28 19:03:41',2,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homefurniture/files/products/product-2.jpg','physical','5420789876590',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(3,'Element Nightstand','element-nightstand','Two-drawer walnut nightstand with soft-close hardware and brass pulls.','<p>Solid walnut throughout, hand-rubbed finish, and dovetailed drawers. Designed to age into a richer patina over decades.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-3.jpg\"]',NULL,'FB-132',0,16,0,1,'in_stock',0,NULL,1,0,0,10,3.10,0,729,599,NULL,NULL,13,17,16,719,NULL,'standard',186143,'2026-05-28 19:03:33','2026-05-28 19:03:41',3,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homefurniture/files/products/product-3.jpg','physical','6601629456779',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(4,'Bukowski Lounge Chair','bukowski-lounge-chair','Cantilevered lounge chair in saddle leather over a stainless-steel frame.','<p>Inspired by mid-century icons, hand-stitched edges and full-grain Italian leather make this a future heirloom.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-4.jpg\"]',NULL,'WM-177-A1',0,12,0,1,'in_stock',0,NULL,5,0,2,10,2.70,0,1899,1499,NULL,NULL,11,18,16,794,NULL,'standard',53152,'2026-05-28 19:03:33','2026-05-28 19:03:41',4,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homefurniture/files/products/product-4.jpg','physical','3771727300113',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(5,'Stockholm Pendant','stockholm-pendant','Sculptural pendant lamp in hand-blown amber glass and matte-black hardware.','<p>Direct-wire installation, dimmable, and works beautifully solo or in clusters above a dining table.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-5.jpg\"]',NULL,'R4-124-A1',0,20,0,1,'in_stock',1,NULL,10,0,2,10,3.90,0,389,319,NULL,NULL,10,15,11,569,NULL,'standard',56035,'2026-05-28 19:03:34','2026-05-28 19:03:41',1,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homefurniture/files/products/product-5.jpg','physical','8392111046131',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(6,'Modular Storage Cube','modular-storage-cube','Stackable storage cube in solid ash with optional drop-front doors.','<p>Configure as a single unit or stack into shelving — modular hardware lets the system grow with your space.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-6.jpg\"]',NULL,'CX-179-A1',0,11,0,1,'in_stock',0,NULL,10,0,5,10,3.10,0,269,219,NULL,NULL,19,20,16,865,NULL,'standard',34658,'2026-05-28 19:03:34','2026-05-28 19:03:41',2,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homefurniture/files/products/product-6.jpg','physical','5643819495893',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(7,'King Platform Bed','king-platform-bed','Low-profile platform bed with upholstered linen headboard and oak frame.','<p>Slat foundation supports any mattress without a box spring. Linen cover removes for cleaning.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-7.jpg\"]',NULL,'OW-183',0,20,0,1,'in_stock',1,NULL,6,0,0,10,3.40,0,1599,1299,NULL,NULL,12,15,14,833,NULL,'standard',29548,'2026-05-28 19:03:34','2026-05-28 19:03:41',3,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homefurniture/files/products/product-7.jpg','physical','4820654162123',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(8,'Dining Table Oak','dining-table-oak','Solid white-oak extending dining table seats six to ten with center leaf.','<p>Trestle base provides ample knee room. Hand-finished surface is treated with natural oil — easy to refresh year over year.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-8.jpg\"]',NULL,'HO-116',0,19,0,1,'in_stock',1,NULL,8,0,0,10,2.80,0,1899,1499,NULL,NULL,20,11,11,655,NULL,'standard',103548,'2026-05-28 19:03:34','2026-05-28 19:03:41',4,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homefurniture/files/products/product-8.jpg','physical','2204272273607',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(9,'Velvet Sofa 3-Seater','velvet-sofa-3-seater','Tailored three-seat sofa in deep emerald velvet with brass tapered legs.','<p>Kiln-dried hardwood frame, sinuous spring suspension, and feather-wrapped cushions. White-glove delivery included.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-9.jpg\"]',NULL,'TV-110-A1',0,11,0,1,'in_stock',0,NULL,5,0,3,10,3.50,0,1799,1399,NULL,NULL,13,13,18,757,NULL,'standard',96096,'2026-05-28 19:03:34','2026-05-28 19:03:41',1,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homefurniture/files/products/product-9.jpg','physical','8983134064419',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(10,'Bookshelf Tall','bookshelf-tall','Floor-to-ceiling bookshelf in solid walnut with adjustable shelving.','<p>Eight adjustable shelves and reinforced anchor points. Each shelf supports up to 50 pounds of books and objects.</p>','published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-10.jpg\"]',NULL,'IR-163-A1',0,16,0,1,'in_stock',0,NULL,6,0,3,10,3.10,0,169,129,NULL,NULL,17,14,15,698,NULL,'standard',14392,'2026-05-28 19:03:34','2026-05-28 19:03:41',2,0,'Botble\\ACL\\Models\\User',0,'users/sangnguyen/workspace/amerce/database/seeders/themes/homefurniture/files/products/product-10.jpg','physical','4645653871544',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(11,'Expose Side Table',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-2.jpg\"]',NULL,'FF-161-A1',0,19,0,1,'in_stock',0,NULL,7,1,0,0,0.00,0,459,NULL,NULL,NULL,15,13,10,744,NULL,'standard',0,'2026-05-28 19:03:34','2026-05-28 19:03:41',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','1522091062747',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(12,'Expose Side Table',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-2.jpg\"]',NULL,'FF-161-A1-A2',0,19,0,1,'in_stock',0,NULL,7,1,0,0,0.00,0,459,NULL,NULL,NULL,15,13,10,744,NULL,'standard',0,'2026-05-28 19:03:34','2026-05-28 19:03:41',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9520220716488',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(13,'Bukowski Lounge Chair',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-4.jpg\"]',NULL,'WM-177-A1',0,12,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,1899,1557.18,NULL,NULL,11,18,16,794,NULL,'standard',0,'2026-05-28 19:03:34','2026-05-28 19:03:41',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2824856489998',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(14,'Bukowski Lounge Chair',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-4.jpg\"]',NULL,'WM-177-A1-A2',0,12,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,1899,1424.25,NULL,NULL,11,18,16,794,NULL,'standard',0,'2026-05-28 19:03:34','2026-05-28 19:03:41',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4969242044684',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(15,'Stockholm Pendant',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-5.jpg\"]',NULL,'R4-124-A1',0,20,0,1,'in_stock',0,NULL,10,1,0,0,0.00,0,389,NULL,NULL,NULL,10,15,11,569,NULL,'standard',0,'2026-05-28 19:03:34','2026-05-28 19:03:41',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','0616145118069',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(16,'Stockholm Pendant',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-5.jpg\"]',NULL,'R4-124-A1-A2',0,20,0,1,'in_stock',0,NULL,10,1,0,0,0.00,0,389,NULL,NULL,NULL,10,15,11,569,NULL,'standard',0,'2026-05-28 19:03:35','2026-05-28 19:03:41',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9367329646588',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(17,'Modular Storage Cube',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-6.jpg\"]',NULL,'CX-179-A1',0,11,0,1,'in_stock',0,NULL,10,1,0,0,0.00,0,269,NULL,NULL,NULL,19,20,16,865,NULL,'standard',0,'2026-05-28 19:03:35','2026-05-28 19:03:41',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','7659653590241',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(18,'Modular Storage Cube',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-6.jpg\"]',NULL,'CX-179-A1-A2',0,11,0,1,'in_stock',0,NULL,10,1,0,0,0.00,0,269,NULL,NULL,NULL,19,20,16,865,NULL,'standard',0,'2026-05-28 19:03:35','2026-05-28 19:03:41',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','3344684582078',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(19,'Modular Storage Cube',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-6.jpg\"]',NULL,'CX-179-A1-A3',0,11,0,1,'in_stock',0,NULL,10,1,0,0,0.00,0,269,NULL,NULL,NULL,19,20,16,865,NULL,'standard',0,'2026-05-28 19:03:35','2026-05-28 19:03:41',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','7780269451418',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(20,'Modular Storage Cube',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-6.jpg\"]',NULL,'CX-179-A1-A4',0,11,0,1,'in_stock',0,NULL,10,1,0,0,0.00,0,269,NULL,NULL,NULL,19,20,16,865,NULL,'standard',0,'2026-05-28 19:03:35','2026-05-28 19:03:41',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8771007244491',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(21,'Modular Storage Cube',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-6.jpg\"]',NULL,'CX-179-A1-A5',0,11,0,1,'in_stock',0,NULL,10,1,0,0,0.00,0,269,NULL,NULL,NULL,19,20,16,865,NULL,'standard',0,'2026-05-28 19:03:35','2026-05-28 19:03:41',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','1905726725246',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(22,'Velvet Sofa 3-Seater',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-9.jpg\"]',NULL,'TV-110-A1',0,11,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,1799,NULL,NULL,NULL,13,13,18,757,NULL,'standard',0,'2026-05-28 19:03:35','2026-05-28 19:03:41',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9207992061410',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(23,'Velvet Sofa 3-Seater',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-9.jpg\"]',NULL,'TV-110-A1-A2',0,11,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,1799,NULL,NULL,NULL,13,13,18,757,NULL,'standard',0,'2026-05-28 19:03:35','2026-05-28 19:03:41',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4487156285233',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(24,'Velvet Sofa 3-Seater',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-9.jpg\"]',NULL,'TV-110-A1-A3',0,11,0,1,'in_stock',0,NULL,5,1,0,0,0.00,0,1799,NULL,NULL,NULL,13,13,18,757,NULL,'standard',0,'2026-05-28 19:03:35','2026-05-28 19:03:41',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','1344908635346',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(25,'Bookshelf Tall',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-10.jpg\"]',NULL,'IR-163-A1',0,16,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,169,NULL,NULL,NULL,17,14,15,698,NULL,'standard',0,'2026-05-28 19:03:35','2026-05-28 19:03:41',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2186192090680',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(26,'Bookshelf Tall',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-10.jpg\"]',NULL,'IR-163-A1-A2',0,16,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,169,NULL,NULL,NULL,17,14,15,698,NULL,'standard',0,'2026-05-28 19:03:35','2026-05-28 19:03:41',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','1635146643560',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(27,'Bookshelf Tall',NULL,NULL,NULL,'published','[\"users\\/sangnguyen\\/workspace\\/amerce\\/database\\/seeders\\/themes\\/homefurniture\\/files\\/products\\/product-10.jpg\"]',NULL,'IR-163-A1-A3',0,16,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,169,NULL,NULL,NULL,17,14,15,698,NULL,'standard',0,'2026-05-28 19:03:35','2026-05-28 19:03:41',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','3411285924023',NULL,NULL,0,0,'auto_generate',0,0,0,NULL);

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

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

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

INSERT INTO `ec_products_translations` VALUES ('ar',1,'كرسي إيمولا',NULL,'كرسي بذراعين للاسترخاء منحوت منجد بقماش بوكلي مع أرجل من خشب البلوط الصلب.','<p>إطار من خشب البلوط معتمد من FSC مع رغوة عالية المرونة ووسادة مطاطية طبيعية. تصميم لغرف المعيشة التي تجعل الناس ينظرون مرتين.</p>'),('ar',2,'فضح طاولة جانبية',NULL,'طاولة جانبية منحوتة بسطح من الحجر الجيري وأرجل فولاذية مطلية بالمسحوق.','<p> كل لوح من ألواح الحجر الجيري فريد من نوعه - فحبيبات الحجر الطبيعي والتنوع الدقيق في الألوان هي السمة المميزة للمنتج.</p>'),('ar',3,'منضدة العنصر',NULL,'طاولة جانبية للسرير ذات درجين من خشب الجوز مع سكك انزلاقية ناعمة ومقابض نحاسية.','<p> خشب الجوز الصلب بالكامل، تشطيب يدوي وأدراج متداخلة. مُصمم لتعميق اللون على مدار عقود.</p>'),('ar',4,'كرسي صالة بوكوفسكي',NULL,'كرسي استرخاء ناتئ منجد بجلد السرج على إطار من الفولاذ المقاوم للصدأ.','<p> مستوحى من أيقونات منتصف القرن، وزخرفة مخيطة يدويًا وجلد إيطالي محبب بالكامل يحول هذا الكرسي إلى إرث مستقبلي.</p>'),('ar',5,'قلادة ستوكهولم',NULL,'مصباح معلق منحوت مصنوع من الزجاج الكهرماني المنفوخ يدويًا وإبزيم معدني أسود غير لامع.','<p> تركيب سلكي مباشر، وسطوع قابل للتعديل، ويبدو رائعًا عند استخدامه منفردًا أو في مجموعات فوق طاولة الطعام.</p>'),('ar',6,'مكعب تخزين معياري',NULL,'مكعب تخزين قابل للتكديس من خشب الدردار الصلب مع باب اختياري قابل للطي.','<p> قم بتكوينها كوحدة واحدة أو مجمعة على أرفف — يسمح التجميع المعياري للنظام بالتوسع وفقًا للمساحة المتوفرة لديك.</p>'),('ar',7,'سرير بمنصة كينج',NULL,'سرير منخفض المنصة مع لوح رأسي من الكتان وإطار من خشب البلوط.','<p>منصة السرير المرصعة تدعم جميع أنواع المراتب دون الحاجة إلى إطار زنبركي. غطاء من الكتان قابل للإزالة للتنظيف.</p>'),('ar',8,'طاولة طعام بلوط',NULL,'طاولة الطعام الممتدة مصنوعة من خشب البلوط الأبيض الصلب، وتتسع لستة إلى عشرة أشخاص مع وجود ورقة ممتدة في المنتصف.','<p> توفر الأرجل المصممة على شكل المهد الكثير من المساحة المريحة للساقين. يتم معالجة السطح المصقول يدويًا بالزيوت الطبيعية - ومن السهل تجديده عامًا بعد عام.</p>'),('ar',9,'أريكة مخملية 3 مقاعد',NULL,'أريكة مصممة بثلاثة مقاعد من المخمل الأخضر الزمردي العميق مع أرجل نحاسية مدببة.','<p>إطار من الخشب الصلب المجفف في الفرن، ونظام نوابض منحني ومرتبة مغطاة بالريش. يشمل خدمة توصيل القفازات البيضاء.</p>'),('ar',10,'رف الكتب طويل القامة',NULL,'رف كتب ممتد من الأرض حتى السقف من خشب الجوز الصلب مع أرفف قابلة للتعديل.','<p>ثمانية مستويات من الأرفف القابلة للتعديل ونقاط التثبيت المعززة. يمكن لكل مستوى رف استيعاب ما يصل إلى 50 رطلاً من الكتب والأشياء.</p>'),('ar',11,'فضح طاولة جانبية',NULL,'طاولة جانبية منحوتة بسطح من الحجر الجيري وأرجل فولاذية مطلية بالمسحوق.','<p> كل لوح من ألواح الحجر الجيري فريد من نوعه - فحبيبات الحجر الطبيعي والتنوع الدقيق في الألوان هي السمة المميزة للمنتج.</p>'),('ar',12,'فضح طاولة جانبية',NULL,'طاولة جانبية منحوتة بسطح من الحجر الجيري وأرجل فولاذية مطلية بالمسحوق.','<p> كل لوح من ألواح الحجر الجيري فريد من نوعه - فحبيبات الحجر الطبيعي والتنوع الدقيق في الألوان هي السمة المميزة للمنتج.</p>'),('ar',13,'كرسي صالة بوكوفسكي',NULL,'كرسي استرخاء ناتئ منجد بجلد السرج على إطار من الفولاذ المقاوم للصدأ.','<p> مستوحى من أيقونات منتصف القرن، وزخرفة مخيطة يدويًا وجلد إيطالي محبب بالكامل يحول هذا الكرسي إلى إرث مستقبلي.</p>'),('ar',14,'كرسي صالة بوكوفسكي',NULL,'كرسي استرخاء ناتئ منجد بجلد السرج على إطار من الفولاذ المقاوم للصدأ.','<p> مستوحى من أيقونات منتصف القرن، وزخرفة مخيطة يدويًا وجلد إيطالي محبب بالكامل يحول هذا الكرسي إلى إرث مستقبلي.</p>'),('ar',15,'قلادة ستوكهولم',NULL,'مصباح معلق منحوت مصنوع من الزجاج الكهرماني المنفوخ يدويًا وإبزيم معدني أسود غير لامع.','<p> تركيب سلكي مباشر، وسطوع قابل للتعديل، ويبدو رائعًا عند استخدامه منفردًا أو في مجموعات فوق طاولة الطعام.</p>'),('ar',16,'قلادة ستوكهولم',NULL,'مصباح معلق منحوت مصنوع من الزجاج الكهرماني المنفوخ يدويًا وإبزيم معدني أسود غير لامع.','<p> تركيب سلكي مباشر، وسطوع قابل للتعديل، ويبدو رائعًا عند استخدامه منفردًا أو في مجموعات فوق طاولة الطعام.</p>'),('ar',17,'مكعب تخزين معياري',NULL,'مكعب تخزين قابل للتكديس من خشب الدردار الصلب مع باب اختياري قابل للطي.','<p> قم بتكوينها كوحدة واحدة أو مجمعة على أرفف — يسمح التجميع المعياري للنظام بالتوسع وفقًا للمساحة المتوفرة لديك.</p>'),('ar',18,'مكعب تخزين معياري',NULL,'مكعب تخزين قابل للتكديس من خشب الدردار الصلب مع باب اختياري قابل للطي.','<p> قم بتكوينها كوحدة واحدة أو مجمعة على أرفف — يسمح التجميع المعياري للنظام بالتوسع وفقًا للمساحة المتوفرة لديك.</p>'),('ar',19,'مكعب تخزين معياري',NULL,'مكعب تخزين قابل للتكديس من خشب الدردار الصلب مع باب اختياري قابل للطي.','<p> قم بتكوينها كوحدة واحدة أو مجمعة على أرفف — يسمح التجميع المعياري للنظام بالتوسع وفقًا للمساحة المتوفرة لديك.</p>'),('ar',20,'مكعب تخزين معياري',NULL,'مكعب تخزين قابل للتكديس من خشب الدردار الصلب مع باب اختياري قابل للطي.','<p> قم بتكوينها كوحدة واحدة أو مجمعة على أرفف — يسمح التجميع المعياري للنظام بالتوسع وفقًا للمساحة المتوفرة لديك.</p>'),('ar',21,'مكعب تخزين معياري',NULL,'مكعب تخزين قابل للتكديس من خشب الدردار الصلب مع باب اختياري قابل للطي.','<p> قم بتكوينها كوحدة واحدة أو مجمعة على أرفف — يسمح التجميع المعياري للنظام بالتوسع وفقًا للمساحة المتوفرة لديك.</p>'),('ar',22,'أريكة مخملية 3 مقاعد',NULL,'أريكة مصممة بثلاثة مقاعد من المخمل الأخضر الزمردي العميق مع أرجل نحاسية مدببة.','<p>إطار من الخشب الصلب المجفف في الفرن، ونظام نوابض منحني ومرتبة مغطاة بالريش. يشمل خدمة توصيل القفازات البيضاء.</p>'),('ar',23,'أريكة مخملية 3 مقاعد',NULL,'أريكة مصممة بثلاثة مقاعد من المخمل الأخضر الزمردي العميق مع أرجل نحاسية مدببة.','<p>إطار من الخشب الصلب المجفف في الفرن، ونظام نوابض منحني ومرتبة مغطاة بالريش. يشمل خدمة توصيل القفازات البيضاء.</p>'),('ar',24,'أريكة مخملية 3 مقاعد',NULL,'أريكة مصممة بثلاثة مقاعد من المخمل الأخضر الزمردي العميق مع أرجل نحاسية مدببة.','<p>إطار من الخشب الصلب المجفف في الفرن، ونظام نوابض منحني ومرتبة مغطاة بالريش. يشمل خدمة توصيل القفازات البيضاء.</p>'),('ar',25,'رف الكتب طويل القامة',NULL,'رف كتب ممتد من الأرض حتى السقف من خشب الجوز الصلب مع أرفف قابلة للتعديل.','<p>ثمانية مستويات من الأرفف القابلة للتعديل ونقاط التثبيت المعززة. يمكن لكل مستوى رف استيعاب ما يصل إلى 50 رطلاً من الكتب والأشياء.</p>'),('ar',26,'رف الكتب طويل القامة',NULL,'رف كتب ممتد من الأرض حتى السقف من خشب الجوز الصلب مع أرفف قابلة للتعديل.','<p>ثمانية مستويات من الأرفف القابلة للتعديل ونقاط التثبيت المعززة. يمكن لكل مستوى رف استيعاب ما يصل إلى 50 رطلاً من الكتب والأشياء.</p>'),('ar',27,'رف الكتب طويل القامة',NULL,'رف كتب ممتد من الأرض حتى السقف من خشب الجوز الصلب مع أرفف قابلة للتعديل.','<p>ثمانية مستويات من الأرفف القابلة للتعديل ونقاط التثبيت المعززة. يمكن لكل مستوى رف استيعاب ما يصل إلى 50 رطلاً من الكتب والأشياء.</p>'),('fr',1,'Fauteuil Imola',NULL,'Fauteuil de relaxation sculptural recouvert de tissu bouclé avec pieds en chêne massif.','Structure en chêne certifié <p>FSC avec mousse hautement élastique et coussin en caoutchouc naturel. Conception pour des salons qui incitent les gens à y regarder à deux fois.</p>'),('fr',2,'Exposer la table d\'appoint',NULL,'Table d\'appoint sculpturale avec plateau en travertin et pieds en acier thermolaqué.','<p>Chaque dalle de travertin est unique — le grain de la pierre naturelle et les subtiles variations de couleurs sont la marque du produit.</p>'),('fr',3,'Table de chevet élément',NULL,'Table de chevet à deux tiroirs en noyer avec rails coulissants lisses et poignées en laiton.','<p>Bois de noyer massif, finition frottée à la main et tiroirs à queue d\'aronde. Conçu pour approfondir la couleur au fil des décennies.</p>'),('fr',4,'Chaise longue Bukowski',NULL,'Fauteuil de relaxation en porte-à-faux recouvert de cuir sellier sur une structure en acier inoxydable.','<p>Inspiré des icônes du milieu du siècle, les garnitures cousues à la main et le cuir italien pleine fleur transforment cette chaise en un héritage futuriste.</p>'),('fr',5,'Suspension Stockholm',NULL,'Lampe à suspension sculpturale en verre ambré soufflé à la bouche et boucle en métal noir mat.','<p>Installation filaire directe, luminosité réglable et superbe apparence lorsqu\'il est utilisé seul ou en groupes au-dessus de la table à manger.</p>'),('fr',6,'Cube de rangement modulaire',NULL,'Cube de rangement empilable en bois de frêne massif avec porte rabattable en option.','<p>Configurez-le comme une seule unité ou empilé sur des étagères : l\'assemblage modulaire permet au système de s\'étendre en fonction de votre espace.</p>'),('fr',7,'Très grand lit plateforme',NULL,'Lit plateforme bas avec tête de lit en lin et structure en chêne.','<p>La plateforme de lit incrustée supporte tous les types de matelas sans avoir besoin d\'un cadre à ressorts. Housse en lin amovible pour le nettoyage.</p>'),('fr',8,'Table à manger en chêne',NULL,'La table à manger allongée est en chêne blanc massif et peut accueillir six à dix personnes avec une rallonge au milieu.','<p>Les pieds de style berceau offrent beaucoup d\'espace confortable pour les jambes. La surface finie à la main est traitée avec des huiles naturelles — facile à renouveler année après année.</p>'),('fr',9,'Canapé en velours 3 places',NULL,'Canapé sur mesure trois places en velours vert émeraude profond avec pieds fuselés en laiton.','<p>Cadre en bois dur séché au four, système de ressorts courbés et matelas recouvert de plumes. Comprend un service de livraison de gants blancs.</p>'),('fr',10,'Bibliothèque haute',NULL,'Bibliothèque du sol au plafond en noyer massif avec étagères réglables.','<p>Huit niveaux d\'étagères réglables et points d\'ancrage renforcés. Chaque niveau d\'étagère peut contenir jusqu\'à 50 livres de livres et d\'objets.</p>'),('fr',11,'Exposer la table d\'appoint',NULL,'Table d\'appoint sculpturale avec plateau en travertin et pieds en acier thermolaqué.','<p>Chaque dalle de travertin est unique — le grain de la pierre naturelle et les subtiles variations de couleurs sont la marque du produit.</p>'),('fr',12,'Exposer la table d\'appoint',NULL,'Table d\'appoint sculpturale avec plateau en travertin et pieds en acier thermolaqué.','<p>Chaque dalle de travertin est unique — le grain de la pierre naturelle et les subtiles variations de couleurs sont la marque du produit.</p>'),('fr',13,'Chaise longue Bukowski',NULL,'Fauteuil de relaxation en porte-à-faux recouvert de cuir sellier sur une structure en acier inoxydable.','<p>Inspiré des icônes du milieu du siècle, les garnitures cousues à la main et le cuir italien pleine fleur transforment cette chaise en un héritage futuriste.</p>'),('fr',14,'Chaise longue Bukowski',NULL,'Fauteuil de relaxation en porte-à-faux recouvert de cuir sellier sur une structure en acier inoxydable.','<p>Inspiré des icônes du milieu du siècle, les garnitures cousues à la main et le cuir italien pleine fleur transforment cette chaise en un héritage futuriste.</p>'),('fr',15,'Suspension Stockholm',NULL,'Lampe à suspension sculpturale en verre ambré soufflé à la bouche et boucle en métal noir mat.','<p>Installation filaire directe, luminosité réglable et superbe apparence lorsqu\'il est utilisé seul ou en groupes au-dessus de la table à manger.</p>'),('fr',16,'Suspension Stockholm',NULL,'Lampe à suspension sculpturale en verre ambré soufflé à la bouche et boucle en métal noir mat.','<p>Installation filaire directe, luminosité réglable et superbe apparence lorsqu\'il est utilisé seul ou en groupes au-dessus de la table à manger.</p>'),('fr',17,'Cube de rangement modulaire',NULL,'Cube de rangement empilable en bois de frêne massif avec porte rabattable en option.','<p>Configurez-le comme une seule unité ou empilé sur des étagères : l\'assemblage modulaire permet au système de s\'étendre en fonction de votre espace.</p>'),('fr',18,'Cube de rangement modulaire',NULL,'Cube de rangement empilable en bois de frêne massif avec porte rabattable en option.','<p>Configurez-le comme une seule unité ou empilé sur des étagères : l\'assemblage modulaire permet au système de s\'étendre en fonction de votre espace.</p>'),('fr',19,'Cube de rangement modulaire',NULL,'Cube de rangement empilable en bois de frêne massif avec porte rabattable en option.','<p>Configurez-le comme une seule unité ou empilé sur des étagères : l\'assemblage modulaire permet au système de s\'étendre en fonction de votre espace.</p>'),('fr',20,'Cube de rangement modulaire',NULL,'Cube de rangement empilable en bois de frêne massif avec porte rabattable en option.','<p>Configurez-le comme une seule unité ou empilé sur des étagères : l\'assemblage modulaire permet au système de s\'étendre en fonction de votre espace.</p>'),('fr',21,'Cube de rangement modulaire',NULL,'Cube de rangement empilable en bois de frêne massif avec porte rabattable en option.','<p>Configurez-le comme une seule unité ou empilé sur des étagères : l\'assemblage modulaire permet au système de s\'étendre en fonction de votre espace.</p>'),('fr',22,'Canapé en velours 3 places',NULL,'Canapé sur mesure trois places en velours vert émeraude profond avec pieds fuselés en laiton.','<p>Cadre en bois dur séché au four, système de ressorts courbés et matelas recouvert de plumes. Comprend un service de livraison de gants blancs.</p>'),('fr',23,'Canapé en velours 3 places',NULL,'Canapé sur mesure trois places en velours vert émeraude profond avec pieds fuselés en laiton.','<p>Cadre en bois dur séché au four, système de ressorts courbés et matelas recouvert de plumes. Comprend un service de livraison de gants blancs.</p>'),('fr',24,'Canapé en velours 3 places',NULL,'Canapé sur mesure trois places en velours vert émeraude profond avec pieds fuselés en laiton.','<p>Cadre en bois dur séché au four, système de ressorts courbés et matelas recouvert de plumes. Comprend un service de livraison de gants blancs.</p>'),('fr',25,'Bibliothèque haute',NULL,'Bibliothèque du sol au plafond en noyer massif avec étagères réglables.','<p>Huit niveaux d\'étagères réglables et points d\'ancrage renforcés. Chaque niveau d\'étagère peut contenir jusqu\'à 50 livres de livres et d\'objets.</p>'),('fr',26,'Bibliothèque haute',NULL,'Bibliothèque du sol au plafond en noyer massif avec étagères réglables.','<p>Huit niveaux d\'étagères réglables et points d\'ancrage renforcés. Chaque niveau d\'étagère peut contenir jusqu\'à 50 livres de livres et d\'objets.</p>'),('fr',27,'Bibliothèque haute',NULL,'Bibliothèque du sol au plafond en noyer massif avec étagères réglables.','<p>Huit niveaux d\'étagères réglables et points d\'ancrage renforcés. Chaque niveau d\'étagère peut contenir jusqu\'à 50 livres de livres et d\'objets.</p>'),('id',1,'Kursi Berlengan Imola',NULL,'Kursi relaksasi pahatan berlapis kain bouclé dengan kaki kayu ek padat.','<p>Rangka kayu ek bersertifikat FSC dengan busa elastis tinggi dan bantalan karet alam. Desain ruang tamu yang membuat orang melihat dua kali.</p>'),('id',2,'Paparkan Meja Samping',NULL,'Meja samping pahatan dengan bagian atas travertine dan kaki baja berlapis bubuk.','<p>Setiap lempengan travertine unik — butiran batu alam dan variasi warna yang halus adalah ciri khas produk ini.</p>'),('id',3,'Elemen Meja Tempat Tidur',NULL,'Meja samping tempat tidur kenari dua laci dengan rel geser halus dan pegangan kuningan.','<p>Kayu walnut solid penuh, finishing gosok dengan tangan, dan laci pas. Dirancang untuk memperdalam warna selama beberapa dekade.</p>'),('id',4,'Kursi Santai Bukowski',NULL,'Kursi relaksasi kantilever berlapis kulit sadel pada rangka baja tahan karat.','<p>Terinspirasi oleh ikon abad pertengahan, trim jahitan tangan dan kulit asli Italia mengubah kursi ini menjadi pusaka futuristik.</p>'),('id',5,'Liontin Stockholm',NULL,'Lampu gantung pahatan terbuat dari kaca amber buatan tangan dan gesper logam hitam matte.','<p>Pemasangan kabel langsung, kecerahan dapat disesuaikan, dan tampak hebat bila digunakan sendiri atau berkelompok di atas meja makan.</p>'),('id',6,'Kubus Penyimpanan Modular',NULL,'Kubus penyimpanan kayu ash solid yang dapat ditumpuk dengan pintu flip-up opsional.','<p>Konfigurasi sebagai satu unit atau ditumpuk ke dalam rak — perakitan modular memungkinkan sistem diperluas sesuai dengan ruang Anda.</p>'),('id',7,'Tempat Tidur Platform Raja',NULL,'Tempat tidur platform rendah dengan sandaran kepala linen dan bingkai kayu ek.','<p>Platform tempat tidur bertatahkan mendukung semua jenis kasur tanpa memerlukan rangka pegas. Sarung linen yang dapat dilepas untuk dibersihkan.</p>'),('id',8,'Meja Makan Kayu Oak',NULL,'Meja makan memanjang terbuat dari kayu ek putih solid, dapat menampung enam hingga sepuluh orang dengan daun memanjang di tengahnya.','<p>Kaki bergaya buaian memberikan banyak ruang kaki yang nyaman. Permukaan yang dibuat dengan tangan diolah dengan minyak alami — mudah diperbarui dari tahun ke tahun.</p>'),('id',9,'Sofa Beludru 3 Tempat Duduk',NULL,'Sofa tiga dudukan berbahan beludru hijau zamrud tua dengan kaki kuningan meruncing.','<p>Rangka kayu keras yang dikeringkan dengan tungku pembakaran, sistem pegas melengkung, dan kasur berlapis bulu. Termasuk layanan pengiriman sarung tangan putih.</p>'),('id',10,'Rak Buku Tinggi',NULL,'Rak buku setinggi langit-langit dari kayu kenari dengan rak yang dapat disesuaikan.','<p>Delapan tingkat rak yang dapat disesuaikan dan titik jangkar yang diperkuat. Setiap tingkat rak dapat menampung hingga 50 pon buku dan benda.</p>'),('id',11,'Paparkan Meja Samping',NULL,'Meja samping pahatan dengan bagian atas travertine dan kaki baja berlapis bubuk.','<p>Setiap lempengan travertine unik — butiran batu alam dan variasi warna yang halus adalah ciri khas produk ini.</p>'),('id',12,'Paparkan Meja Samping',NULL,'Meja samping pahatan dengan bagian atas travertine dan kaki baja berlapis bubuk.','<p>Setiap lempengan travertine unik — butiran batu alam dan variasi warna yang halus adalah ciri khas produk ini.</p>'),('id',13,'Kursi Santai Bukowski',NULL,'Kursi relaksasi kantilever berlapis kulit sadel pada rangka baja tahan karat.','<p>Terinspirasi oleh ikon abad pertengahan, trim jahitan tangan dan kulit asli Italia mengubah kursi ini menjadi pusaka futuristik.</p>'),('id',14,'Kursi Santai Bukowski',NULL,'Kursi relaksasi kantilever berlapis kulit sadel pada rangka baja tahan karat.','<p>Terinspirasi oleh ikon abad pertengahan, trim jahitan tangan dan kulit asli Italia mengubah kursi ini menjadi pusaka futuristik.</p>'),('id',15,'Liontin Stockholm',NULL,'Lampu gantung pahatan terbuat dari kaca amber buatan tangan dan gesper logam hitam matte.','<p>Pemasangan kabel langsung, kecerahan dapat disesuaikan, dan tampak hebat bila digunakan sendiri atau berkelompok di atas meja makan.</p>'),('id',16,'Liontin Stockholm',NULL,'Lampu gantung pahatan terbuat dari kaca amber buatan tangan dan gesper logam hitam matte.','<p>Pemasangan kabel langsung, kecerahan dapat disesuaikan, dan tampak hebat bila digunakan sendiri atau berkelompok di atas meja makan.</p>'),('id',17,'Kubus Penyimpanan Modular',NULL,'Kubus penyimpanan kayu ash solid yang dapat ditumpuk dengan pintu flip-up opsional.','<p>Konfigurasi sebagai satu unit atau ditumpuk ke dalam rak — perakitan modular memungkinkan sistem diperluas sesuai dengan ruang Anda.</p>'),('id',18,'Kubus Penyimpanan Modular',NULL,'Kubus penyimpanan kayu ash solid yang dapat ditumpuk dengan pintu flip-up opsional.','<p>Konfigurasi sebagai satu unit atau ditumpuk ke dalam rak — perakitan modular memungkinkan sistem diperluas sesuai dengan ruang Anda.</p>'),('id',19,'Kubus Penyimpanan Modular',NULL,'Kubus penyimpanan kayu ash solid yang dapat ditumpuk dengan pintu flip-up opsional.','<p>Konfigurasi sebagai satu unit atau ditumpuk ke dalam rak — perakitan modular memungkinkan sistem diperluas sesuai dengan ruang Anda.</p>'),('id',20,'Kubus Penyimpanan Modular',NULL,'Kubus penyimpanan kayu ash solid yang dapat ditumpuk dengan pintu flip-up opsional.','<p>Konfigurasi sebagai satu unit atau ditumpuk ke dalam rak — perakitan modular memungkinkan sistem diperluas sesuai dengan ruang Anda.</p>'),('id',21,'Kubus Penyimpanan Modular',NULL,'Kubus penyimpanan kayu ash solid yang dapat ditumpuk dengan pintu flip-up opsional.','<p>Konfigurasi sebagai satu unit atau ditumpuk ke dalam rak — perakitan modular memungkinkan sistem diperluas sesuai dengan ruang Anda.</p>'),('id',22,'Sofa Beludru 3 Tempat Duduk',NULL,'Sofa tiga dudukan berbahan beludru hijau zamrud tua dengan kaki kuningan meruncing.','<p>Rangka kayu keras yang dikeringkan dengan tungku pembakaran, sistem pegas melengkung, dan kasur berlapis bulu. Termasuk layanan pengiriman sarung tangan putih.</p>'),('id',23,'Sofa Beludru 3 Tempat Duduk',NULL,'Sofa tiga dudukan berbahan beludru hijau zamrud tua dengan kaki kuningan meruncing.','<p>Rangka kayu keras yang dikeringkan dengan tungku pembakaran, sistem pegas melengkung, dan kasur berlapis bulu. Termasuk layanan pengiriman sarung tangan putih.</p>'),('id',24,'Sofa Beludru 3 Tempat Duduk',NULL,'Sofa tiga dudukan berbahan beludru hijau zamrud tua dengan kaki kuningan meruncing.','<p>Rangka kayu keras yang dikeringkan dengan tungku pembakaran, sistem pegas melengkung, dan kasur berlapis bulu. Termasuk layanan pengiriman sarung tangan putih.</p>'),('id',25,'Rak Buku Tinggi',NULL,'Rak buku setinggi langit-langit dari kayu kenari dengan rak yang dapat disesuaikan.','<p>Delapan tingkat rak yang dapat disesuaikan dan titik jangkar yang diperkuat. Setiap tingkat rak dapat menampung hingga 50 pon buku dan benda.</p>'),('id',26,'Rak Buku Tinggi',NULL,'Rak buku setinggi langit-langit dari kayu kenari dengan rak yang dapat disesuaikan.','<p>Delapan tingkat rak yang dapat disesuaikan dan titik jangkar yang diperkuat. Setiap tingkat rak dapat menampung hingga 50 pon buku dan benda.</p>'),('id',27,'Rak Buku Tinggi',NULL,'Rak buku setinggi langit-langit dari kayu kenari dengan rak yang dapat disesuaikan.','<p>Delapan tingkat rak yang dapat disesuaikan dan titik jangkar yang diperkuat. Setiap tingkat rak dapat menampung hingga 50 pon buku dan benda.</p>'),('tr',1,'Imola Koltuk',NULL,'Masif meşe ayaklı, buklet kumaşla kaplı, heykelsi dinlenme koltuğu.','<p>FSC sertifikalı, yüksek elastik süngerli ve doğal kauçuk yastıklı meşe çerçeve. İnsanların iki kez bakmasını sağlayacak oturma odaları tasarımı.</p>'),('tr',2,'Yan Sehpayı Açığa Çıkarın',NULL,'Traverten üstlü ve toz boyalı çelik ayaklı, heykelsi yan sehpa.','<p>Her traverten levha benzersizdir — doğal taş dokusu ve hafif renk farklılıkları ürünün ayırt edici özelliğidir.</p>'),('tr',3,'Eleman Komidin',NULL,'Pürüzsüz sürgülü raylı ve pirinç kulplu, iki çekmeceli ceviz komodin.','<p>Tam masif ceviz ağacı, elle ovulmuş yüzey ve geçmeli çekmeceler. Onlarca yıl boyunca rengi derinleştirmek için tasarlandı.</p>'),('tr',4,'Bukowski Şezlong',NULL,'Paslanmaz çelik çerçeve üzerine eyer deri döşemeli, konsollu dinlenme koltuğu.','<p>Yüzyılın ikonlarından ilham alan, elle dikilmiş kaplamalar ve sırçalı İtalyan derisi bu sandalyeyi fütüristik bir yadigâra dönüştürüyor.</p>'),('tr',5,'Stokholm Kolye',NULL,'El üfleme amber rengi camdan ve mat siyah metal tokadan yapılmış heykelsi sarkıt lamba.','<p>Doğrudan kablolu kurulum, ayarlanabilir parlaklık ve tek başına veya yemek masasının üzerinde kümeler halinde kullanıldığında harika görünür.</p>'),('tr',6,'Modüler Depolama Küpü',NULL,'İsteğe bağlı açılır kapılı, masif dişbudak ağacından istiflenebilir depolama küpü.','<p>Tek bir ünite olarak veya raflara istiflenerek yapılandırın — modüler montaj, sistemin alanınıza göre genişlemesine olanak tanır.</p>'),('tr',7,'Kral Platform Yatağı',NULL,'Keten başlıklı ve meşe çerçeveli alçak platform yatak.','<p>Kakma yatak platformu, yaylı çerçeveye ihtiyaç duymadan her türlü yatağı destekler. Temizlik için çıkarılabilir nevresim.</p>'),('tr',8,'Yemek Masası Meşe',NULL,'Genişletilmiş yemek masası masif beyaz meşeden yapılmış olup, ortasında uzatılmış bir yaprak bulunan, altı ila on kişi kapasitelidir.','<p>Beşik tarzı bacaklar bol miktarda rahat bacak alanı sağlar. Elle cilalanan yüzey doğal yağlarla işlenmiştir; her yıl yenilenmesi kolaydır.</p>'),('tr',9,'Kadife Kanepe 3\'lü',NULL,'Koyu zümrüt yeşili kadifeden, konik pirinç ayaklı, üç kişilik özel yapım kanepe.','<p>Fırınlanmış parke gövde, kavisli yay sistemi ve kuş tüyü yatak. Beyaz eldiven dağıtım hizmeti dahildir.</p>'),('tr',10,'Kitaplık Uzun',NULL,'Ayarlanabilir raflı, masif cevizden tavana kadar kitaplık.','<p>Sekiz seviyeli ayarlanabilir raflar ve güçlendirilmiş bağlantı noktaları. Her raf seviyesine 50 pound\'a kadar kitap ve nesne yerleştirilebilir.</p>'),('tr',11,'Yan Sehpayı Açığa Çıkarın',NULL,'Traverten üstlü ve toz boyalı çelik ayaklı, heykelsi yan sehpa.','<p>Her traverten levha benzersizdir — doğal taş dokusu ve hafif renk farklılıkları ürünün ayırt edici özelliğidir.</p>'),('tr',12,'Yan Sehpayı Açığa Çıkarın',NULL,'Traverten üstlü ve toz boyalı çelik ayaklı, heykelsi yan sehpa.','<p>Her traverten levha benzersizdir — doğal taş dokusu ve hafif renk farklılıkları ürünün ayırt edici özelliğidir.</p>'),('tr',13,'Bukowski Şezlong',NULL,'Paslanmaz çelik çerçeve üzerine eyer deri döşemeli, konsollu dinlenme koltuğu.','<p>Yüzyılın ikonlarından ilham alan, elle dikilmiş kaplamalar ve sırçalı İtalyan derisi bu sandalyeyi fütüristik bir yadigâra dönüştürüyor.</p>'),('tr',14,'Bukowski Şezlong',NULL,'Paslanmaz çelik çerçeve üzerine eyer deri döşemeli, konsollu dinlenme koltuğu.','<p>Yüzyılın ikonlarından ilham alan, elle dikilmiş kaplamalar ve sırçalı İtalyan derisi bu sandalyeyi fütüristik bir yadigâra dönüştürüyor.</p>'),('tr',15,'Stokholm Kolye',NULL,'El üfleme amber rengi camdan ve mat siyah metal tokadan yapılmış heykelsi sarkıt lamba.','<p>Doğrudan kablolu kurulum, ayarlanabilir parlaklık ve tek başına veya yemek masasının üzerinde kümeler halinde kullanıldığında harika görünür.</p>'),('tr',16,'Stokholm Kolye',NULL,'El üfleme amber rengi camdan ve mat siyah metal tokadan yapılmış heykelsi sarkıt lamba.','<p>Doğrudan kablolu kurulum, ayarlanabilir parlaklık ve tek başına veya yemek masasının üzerinde kümeler halinde kullanıldığında harika görünür.</p>'),('tr',17,'Modüler Depolama Küpü',NULL,'İsteğe bağlı açılır kapılı, masif dişbudak ağacından istiflenebilir depolama küpü.','<p>Tek bir ünite olarak veya raflara istiflenerek yapılandırın — modüler montaj, sistemin alanınıza göre genişlemesine olanak tanır.</p>'),('tr',18,'Modüler Depolama Küpü',NULL,'İsteğe bağlı açılır kapılı, masif dişbudak ağacından istiflenebilir depolama küpü.','<p>Tek bir ünite olarak veya raflara istiflenerek yapılandırın — modüler montaj, sistemin alanınıza göre genişlemesine olanak tanır.</p>'),('tr',19,'Modüler Depolama Küpü',NULL,'İsteğe bağlı açılır kapılı, masif dişbudak ağacından istiflenebilir depolama küpü.','<p>Tek bir ünite olarak veya raflara istiflenerek yapılandırın — modüler montaj, sistemin alanınıza göre genişlemesine olanak tanır.</p>'),('tr',20,'Modüler Depolama Küpü',NULL,'İsteğe bağlı açılır kapılı, masif dişbudak ağacından istiflenebilir depolama küpü.','<p>Tek bir ünite olarak veya raflara istiflenerek yapılandırın — modüler montaj, sistemin alanınıza göre genişlemesine olanak tanır.</p>'),('tr',21,'Modüler Depolama Küpü',NULL,'İsteğe bağlı açılır kapılı, masif dişbudak ağacından istiflenebilir depolama küpü.','<p>Tek bir ünite olarak veya raflara istiflenerek yapılandırın — modüler montaj, sistemin alanınıza göre genişlemesine olanak tanır.</p>'),('tr',22,'Kadife Kanepe 3\'lü',NULL,'Koyu zümrüt yeşili kadifeden, konik pirinç ayaklı, üç kişilik özel yapım kanepe.','<p>Fırınlanmış parke gövde, kavisli yay sistemi ve kuş tüyü yatak. Beyaz eldiven dağıtım hizmeti dahildir.</p>'),('tr',23,'Kadife Kanepe 3\'lü',NULL,'Koyu zümrüt yeşili kadifeden, konik pirinç ayaklı, üç kişilik özel yapım kanepe.','<p>Fırınlanmış parke gövde, kavisli yay sistemi ve kuş tüyü yatak. Beyaz eldiven dağıtım hizmeti dahildir.</p>'),('tr',24,'Kadife Kanepe 3\'lü',NULL,'Koyu zümrüt yeşili kadifeden, konik pirinç ayaklı, üç kişilik özel yapım kanepe.','<p>Fırınlanmış parke gövde, kavisli yay sistemi ve kuş tüyü yatak. Beyaz eldiven dağıtım hizmeti dahildir.</p>'),('tr',25,'Kitaplık Uzun',NULL,'Ayarlanabilir raflı, masif cevizden tavana kadar kitaplık.','<p>Sekiz seviyeli ayarlanabilir raflar ve güçlendirilmiş bağlantı noktaları. Her raf seviyesine 50 pound\'a kadar kitap ve nesne yerleştirilebilir.</p>'),('tr',26,'Kitaplık Uzun',NULL,'Ayarlanabilir raflı, masif cevizden tavana kadar kitaplık.','<p>Sekiz seviyeli ayarlanabilir raflar ve güçlendirilmiş bağlantı noktaları. Her raf seviyesine 50 pound\'a kadar kitap ve nesne yerleştirilebilir.</p>'),('tr',27,'Kitaplık Uzun',NULL,'Ayarlanabilir raflı, masif cevizden tavana kadar kitaplık.','<p>Sekiz seviyeli ayarlanabilir raflar ve güçlendirilmiş bağlantı noktaları. Her raf seviyesine 50 pound\'a kadar kitap ve nesne yerleştirilebilir.</p>'),('vi',1,'Ghế Bành Imola',NULL,'Ghế bành thư giãn tạo hình điêu khắc bọc vải bouclé với chân gỗ sồi nguyên khối.','<p>Khung gỗ sồi đạt chứng nhận FSC với mút đàn hồi cao và đệm cao su tự nhiên. Thiết kế cho những phòng khách khiến người ta phải ngoái nhìn lần thứ hai.</p>'),('vi',2,'Bàn Phụ Expose',NULL,'Bàn phụ tạo hình điêu khắc với mặt đá travertine và chân thép sơn tĩnh điện.','<p>Mỗi tấm đá travertine là độc nhất — vân đá tự nhiên và những biến đổi sắc độ tinh tế là dấu ấn đặc trưng của sản phẩm.</p>'),('vi',3,'Tủ Đầu Giường Element',NULL,'Tủ đầu giường gỗ óc chó hai ngăn kéo với ray trượt êm và tay nắm đồng thau.','<p>Gỗ óc chó nguyên khối toàn bộ, hoàn thiện chà tay và ngăn kéo ghép mộng đuôi én. Được thiết kế để lên màu đậm đà hơn qua nhiều thập kỷ.</p>'),('vi',4,'Ghế Thư Giãn Bukowski',NULL,'Ghế thư giãn dạng công xôn bọc da yên ngựa trên khung thép không gỉ.','<p>Lấy cảm hứng từ những biểu tượng giữa thế kỷ, đường viền khâu tay và da Ý nguyên tấm biến chiếc ghế này thành vật gia truyền tương lai.</p>'),('vi',5,'Đèn Thả Stockholm',NULL,'Đèn thả tạo hình điêu khắc bằng thủy tinh hổ phách thổi tay và khóa kim loại đen nhám.','<p>Lắp đặt nối dây trực tiếp, điều chỉnh độ sáng được, và đẹp tuyệt khi dùng đơn lẻ hoặc theo cụm phía trên bàn ăn.</p>'),('vi',6,'Khối Lưu Trữ Module',NULL,'Khối lưu trữ xếp chồng được bằng gỗ tần bì nguyên khối với cửa lật tùy chọn.','<p>Cấu hình thành một khối đơn lẻ hoặc xếp chồng thành kệ — phần ghép nối dạng module cho phép hệ thống mở rộng theo không gian của bạn.</p>'),('vi',7,'Giường Bệ King',NULL,'Giường bệ thấp với đầu giường bọc vải lanh và khung gỗ sồi.','<p>Nền dát giường nâng đỡ mọi loại nệm mà không cần khung lò xo. Lớp vỏ vải lanh tháo rời để vệ sinh.</p>'),('vi',8,'Bàn Ăn Gỗ Sồi',NULL,'Bàn ăn mở rộng bằng gỗ sồi trắng nguyên khối, ngồi được sáu đến mười người với phần lá mở rộng ở giữa.','<p>Chân kiểu giá đỡ tạo nhiều khoảng để chân thoải mái. Bề mặt hoàn thiện thủ công được xử lý bằng dầu tự nhiên — dễ làm mới qua từng năm.</p>'),('vi',9,'Ghế Sofa Nhung 3 Chỗ',NULL,'Ghế sofa ba chỗ may đo bằng nhung xanh ngọc lục bảo đậm với chân thon đồng thau.','<p>Khung gỗ cứng sấy lò, hệ lò xo uốn lượn và đệm bọc lông vũ. Bao gồm dịch vụ giao hàng găng tay trắng.</p>'),('vi',10,'Kệ Sách Cao',NULL,'Kệ sách từ sàn tới trần bằng gỗ óc chó nguyên khối với các tầng kệ điều chỉnh được.','<p>Tám tầng kệ điều chỉnh được và các điểm neo gia cố. Mỗi tầng kệ chịu được đến 50 pound sách và đồ vật.</p>'),('vi',11,'Bàn Phụ Expose',NULL,'Bàn phụ tạo hình điêu khắc với mặt đá travertine và chân thép sơn tĩnh điện.','<p>Mỗi tấm đá travertine là độc nhất — vân đá tự nhiên và những biến đổi sắc độ tinh tế là dấu ấn đặc trưng của sản phẩm.</p>'),('vi',12,'Bàn Phụ Expose',NULL,'Bàn phụ tạo hình điêu khắc với mặt đá travertine và chân thép sơn tĩnh điện.','<p>Mỗi tấm đá travertine là độc nhất — vân đá tự nhiên và những biến đổi sắc độ tinh tế là dấu ấn đặc trưng của sản phẩm.</p>'),('vi',13,'Ghế Thư Giãn Bukowski',NULL,'Ghế thư giãn dạng công xôn bọc da yên ngựa trên khung thép không gỉ.','<p>Lấy cảm hứng từ những biểu tượng giữa thế kỷ, đường viền khâu tay và da Ý nguyên tấm biến chiếc ghế này thành vật gia truyền tương lai.</p>'),('vi',14,'Ghế Thư Giãn Bukowski',NULL,'Ghế thư giãn dạng công xôn bọc da yên ngựa trên khung thép không gỉ.','<p>Lấy cảm hứng từ những biểu tượng giữa thế kỷ, đường viền khâu tay và da Ý nguyên tấm biến chiếc ghế này thành vật gia truyền tương lai.</p>'),('vi',15,'Đèn Thả Stockholm',NULL,'Đèn thả tạo hình điêu khắc bằng thủy tinh hổ phách thổi tay và khóa kim loại đen nhám.','<p>Lắp đặt nối dây trực tiếp, điều chỉnh độ sáng được, và đẹp tuyệt khi dùng đơn lẻ hoặc theo cụm phía trên bàn ăn.</p>'),('vi',16,'Đèn Thả Stockholm',NULL,'Đèn thả tạo hình điêu khắc bằng thủy tinh hổ phách thổi tay và khóa kim loại đen nhám.','<p>Lắp đặt nối dây trực tiếp, điều chỉnh độ sáng được, và đẹp tuyệt khi dùng đơn lẻ hoặc theo cụm phía trên bàn ăn.</p>'),('vi',17,'Khối Lưu Trữ Module',NULL,'Khối lưu trữ xếp chồng được bằng gỗ tần bì nguyên khối với cửa lật tùy chọn.','<p>Cấu hình thành một khối đơn lẻ hoặc xếp chồng thành kệ — phần ghép nối dạng module cho phép hệ thống mở rộng theo không gian của bạn.</p>'),('vi',18,'Khối Lưu Trữ Module',NULL,'Khối lưu trữ xếp chồng được bằng gỗ tần bì nguyên khối với cửa lật tùy chọn.','<p>Cấu hình thành một khối đơn lẻ hoặc xếp chồng thành kệ — phần ghép nối dạng module cho phép hệ thống mở rộng theo không gian của bạn.</p>'),('vi',19,'Khối Lưu Trữ Module',NULL,'Khối lưu trữ xếp chồng được bằng gỗ tần bì nguyên khối với cửa lật tùy chọn.','<p>Cấu hình thành một khối đơn lẻ hoặc xếp chồng thành kệ — phần ghép nối dạng module cho phép hệ thống mở rộng theo không gian của bạn.</p>'),('vi',20,'Khối Lưu Trữ Module',NULL,'Khối lưu trữ xếp chồng được bằng gỗ tần bì nguyên khối với cửa lật tùy chọn.','<p>Cấu hình thành một khối đơn lẻ hoặc xếp chồng thành kệ — phần ghép nối dạng module cho phép hệ thống mở rộng theo không gian của bạn.</p>'),('vi',21,'Khối Lưu Trữ Module',NULL,'Khối lưu trữ xếp chồng được bằng gỗ tần bì nguyên khối với cửa lật tùy chọn.','<p>Cấu hình thành một khối đơn lẻ hoặc xếp chồng thành kệ — phần ghép nối dạng module cho phép hệ thống mở rộng theo không gian của bạn.</p>'),('vi',22,'Ghế Sofa Nhung 3 Chỗ',NULL,'Ghế sofa ba chỗ may đo bằng nhung xanh ngọc lục bảo đậm với chân thon đồng thau.','<p>Khung gỗ cứng sấy lò, hệ lò xo uốn lượn và đệm bọc lông vũ. Bao gồm dịch vụ giao hàng găng tay trắng.</p>'),('vi',23,'Ghế Sofa Nhung 3 Chỗ',NULL,'Ghế sofa ba chỗ may đo bằng nhung xanh ngọc lục bảo đậm với chân thon đồng thau.','<p>Khung gỗ cứng sấy lò, hệ lò xo uốn lượn và đệm bọc lông vũ. Bao gồm dịch vụ giao hàng găng tay trắng.</p>'),('vi',24,'Ghế Sofa Nhung 3 Chỗ',NULL,'Ghế sofa ba chỗ may đo bằng nhung xanh ngọc lục bảo đậm với chân thon đồng thau.','<p>Khung gỗ cứng sấy lò, hệ lò xo uốn lượn và đệm bọc lông vũ. Bao gồm dịch vụ giao hàng găng tay trắng.</p>'),('vi',25,'Kệ Sách Cao',NULL,'Kệ sách từ sàn tới trần bằng gỗ óc chó nguyên khối với các tầng kệ điều chỉnh được.','<p>Tám tầng kệ điều chỉnh được và các điểm neo gia cố. Mỗi tầng kệ chịu được đến 50 pound sách và đồ vật.</p>'),('vi',26,'Kệ Sách Cao',NULL,'Kệ sách từ sàn tới trần bằng gỗ óc chó nguyên khối với các tầng kệ điều chỉnh được.','<p>Tám tầng kệ điều chỉnh được và các điểm neo gia cố. Mỗi tầng kệ chịu được đến 50 pound sách và đồ vật.</p>'),('vi',27,'Kệ Sách Cao',NULL,'Kệ sách từ sàn tới trần bằng gỗ óc chó nguyên khối với các tầng kệ điều chỉnh được.','<p>Tám tầng kệ điều chỉnh được và các điểm neo gia cố. Mỗi tầng kệ chịu được đến 50 pound sách và đồ vật.</p>');

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

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

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


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

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

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

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

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

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

--
