--
-- 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,'nNWwzmGCEkb6rpCxXo9gwyilyZObEyzk',1,'2026-05-28 19:09:50','2026-05-28 19:09:50','2026-05-28 19:09:50');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `categories` VALUES (1,'Gift Ideas',0,'Curated gift inspiration for birthdays, weddings, anniversaries, and every milestone.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2026-05-28 19:09:51','2026-05-28 19:09:51'),(2,'Customization Tips',0,'How to design, photograph, and proof a personalized product youll actually love.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:09:51','2026-05-28 19:09:51'),(3,'Occasions',0,'Holiday-by-holiday and milestone-by-milestone guides for thoughtful gifting.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:09:51','2026-05-28 19:09:51'),(4,'Personalization Trends',0,'Whats new in print-on-demand — typography, illustration, and design trends.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:09:51','2026-05-28 19:09:51'),(5,'Behind the Print',0,'A look inside our print process, materials, and quality standards.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:09:51','2026-05-28 19:09:51');

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

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

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

INSERT INTO `categories_translations` VALUES ('ar',1,'أفكار الهدايا','إلهام هدية منسقة لأعياد الميلاد وحفلات الزفاف واحتفالات الذكرى السنوية وكل حدث مهم.'),('ar',2,'نصائح التخصيص','كيفية تصميم وتصوير وإنشاء نموذج أولي لمنتج شخصي ستحبه حقًا.'),('ar',3,'مناسبات','دليل هدايا متطور لكل عطلة وكل معلم.'),('ar',4,'اتجاهات التخصيص','ما هو الجديد في الطباعة حسب الطلب - اتجاهات الطباعة والتوضيح والتصميم.'),('ar',5,'خلف الطباعة','نظرة داخلية على عملية الطباعة والمواد ومعايير الجودة لدينا.'),('fr',1,'Idées cadeaux','Inspiration de cadeaux sélectionnés pour les anniversaires, les mariages, les anniversaires et chaque étape importante.'),('fr',2,'Conseils de personnalisation','Comment concevoir, photographier et prototyper un produit personnalisé que vous adorerez vraiment.'),('fr',3,'Occasions','Un guide de cadeaux sophistiqué pour chaque fête et chaque étape importante.'),('fr',4,'Tendances de personnalisation','Quoi de neuf en matière d\'impression à la demande : tendances en matière de typographie, d\'illustration et de design.'),('fr',5,'Derrière l\'impression','Un aperçu de notre processus d’impression, de nos matériaux et de nos normes de qualité.'),('id',1,'Ide Hadiah','Inspirasi hadiah yang dikurasi untuk ulang tahun, pernikahan, hari jadi, dan setiap pencapaian.'),('id',2,'Tip Kustomisasi','Cara mendesain, memotret, dan membuat prototipe produk hasil personalisasi yang pasti Anda sukai.'),('id',3,'Kesempatan','Panduan hadiah canggih untuk setiap liburan dan setiap pencapaian.'),('id',4,'Tren Personalisasi','Apa yang baru dalam print-on-demand — tren tipografi, ilustrasi, dan desain.'),('id',5,'Di Balik Cetakan','Pandangan mendalam tentang proses pencetakan, bahan, dan standar kualitas kami.'),('tr',1,'Hediye Fikirleri','Doğum günleri, düğünler, yıldönümleri ve her dönüm noktası için seçilmiş hediye ilhamı.'),('tr',2,'Özelleştirme İpuçları','Gerçekten seveceğiniz kişiselleştirilmiş bir ürünü nasıl tasarlayabilir, fotoğraflayabilir ve prototipini oluşturabilirsiniz.'),('tr',3,'Günler','Her tatil ve her dönüm noktası için sofistike bir hediye rehberi.'),('tr',4,'Kişiselleştirme Trendleri','Talep üzerine baskıdaki yenilikler — tipografi, illüstrasyon ve tasarımdaki trendler.'),('tr',5,'Baskının Arkasında','Baskı sürecimize, malzemelerimize ve kalite standartlarımıza içeriden bir bakış.'),('vi',1,'Ý Tưởng Quà Tặng','Nguồn cảm hứng quà tặng được tuyển chọn cho sinh nhật, đám cưới, ngày kỷ niệm và mọi cột mốc.'),('vi',2,'Mẹo Tùy Chỉnh','Cách thiết kế, chụp ảnh và duyệt mẫu một sản phẩm cá nhân hóa mà bạn thực sự yêu thích.'),('vi',3,'Dịp Lễ','Hướng dẫn quà tặng tinh tế theo từng ngày lễ và từng cột mốc.'),('vi',4,'Xu Hướng Cá Nhân Hóa','Những điều mới trong in theo yêu cầu — xu hướng typography, minh họa và thiết kế.'),('vi',5,'Hậu Trường In Ấn','Một góc nhìn bên trong quy trình in, vật liệu và tiêu chuẩn chất lượng của chúng tôi.');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

CREATE TABLE `ec_brands` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `order` tinyint unsigned NOT NULL DEFAULT '0',
  `is_featured` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=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:09:50','2026-05-28 19:09:50'),(2,'Anvouge','Modern fashion essentials cut from sustainable fibers.','https://example.com/anvouge','brands/anvouge.png','published',1,1,'2026-05-28 19:09:50','2026-05-28 19:09:50'),(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:09:50','2026-05-28 19:09:50'),(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:09:50','2026-05-28 19:09:50'),(5,'Cheryl','Bold prints and silhouettes for the contemporary woman.','https://example.com/cheryl','brands/cheryl.png','published',4,0,'2026-05-28 19:09:50','2026-05-28 19:09:50'),(6,'Crate','Mid-century-inspired furniture built to last generations.','https://example.com/crate','brands/crate.png','published',5,1,'2026-05-28 19:09:50','2026-05-28 19:09:50'),(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:09:50','2026-05-28 19:09:50'),(8,'Intdeco','Interior accents that bridge minimalism and warmth.','https://example.com/intdeco','brands/intdeco.png','published',7,0,'2026-05-28 19:09:50','2026-05-28 19:09:50'),(9,'Modave','Performance activewear made with recycled high-stretch knits.','https://example.com/modave','brands/modave.png','published',8,0,'2026-05-28 19:09:50','2026-05-28 19:09:50'),(10,'Panadoxn','Botanical skincare formulated by clinical herbalists.','https://example.com/panadoxn','brands/panadoxn.png','published',9,0,'2026-05-28 19:09:50','2026-05-28 19:09:50'),(11,'Shangxi','Heritage tea, ceramics, and meditation accessories.','https://example.com/shangxi','brands/shangxi.png','published',10,0,'2026-05-28 19:09:50','2026-05-28 19:09:50'),(12,'Sopify','Smart home devices designed for renters and travelers.','https://example.com/sopify','brands/sopify.png','published',11,0,'2026-05-28 19:09:50','2026-05-28 19:09:50');

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

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

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

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

INSERT INTO `ec_customer_addresses` VALUES (1,'Emma Collins','customer@botble.com','+1-555-0106','US','California','New York','987 Birch Boulevard',1,1,'2026-05-28 19:10:01','2026-05-28 19:10:01','19101'),(2,'Emma Collins','customer@botble.com','+1-555-0103','CA','Georgia','Phoenix','987 Birch Boulevard',1,0,'2026-05-28 19:10:01','2026-05-28 19:10:01','60601'),(3,'Sophia Ramirez','vendor@botble.com','+1-555-0109','US','Florida','Denver','987 Birch Boulevard',2,1,'2026-05-28 19:10:01','2026-05-28 19:10:01','30301'),(4,'Sophia Ramirez','vendor@botble.com','+1-555-0103','DE','California','Dallas','321 Maple Drive',2,0,'2026-05-28 19:10:01','2026-05-28 19:10:01','30301'),(5,'Olivia Carter','customer1@example.com','+1-555-0105','AU','Georgia','Chicago','741 Spruce Street',3,1,'2026-05-28 19:10:02','2026-05-28 19:10:02','10001'),(6,'Ava Mitchell','customer2@example.com','+1-555-0109','CA','Michigan','Phoenix','321 Maple Drive',4,1,'2026-05-28 19:10:02','2026-05-28 19:10:02','33101'),(7,'Isabella Brooks','customer3@example.com','+1-555-0102','GB','Arizona','San Diego','987 Birch Boulevard',5,1,'2026-05-28 19:10:02','2026-05-28 19:10:02','30301'),(8,'James Whitfield','customer4@example.com','+1-555-0108','CA','Florida','New York','147 Elm Court',6,1,'2026-05-28 19:10:02','2026-05-28 19:10:02','19101'),(9,'Liam Bennett','customer5@example.com','+1-555-0103','GB','California','Phoenix','147 Elm Court',7,1,'2026-05-28 19:10:02','2026-05-28 19:10:02','80201'),(10,'Noah Patterson','customer6@example.com','+1-555-0106','DE','New York','Los Angeles','258 Walnut Way',8,1,'2026-05-28 19:10:03','2026-05-28 19:10:03','77001'),(11,'Charlotte Reed','customer7@example.com','+1-555-0103','AU','Texas','Austin','321 Maple Drive',9,1,'2026-05-28 19:10:03','2026-05-28 19:10:03','77001'),(12,'Amelia Foster','customer8@example.com','+1-555-0104','CA','Pennsylvania','Dallas','456 Oak Avenue',10,1,'2026-05-28 19:10:03','2026-05-28 19:10:03','48201');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `ec_flash_sale_products` VALUES (1,4,27.3,50,0),(1,8,16.8,50,0),(1,12,18.2,50,0),(1,9,18.9,50,0),(1,1,20.3,50,0),(1,6,22.4,50,0),(1,3,15.4,50,0),(1,7,34.3,50,0),(1,11,30.8,50,0),(1,10,25.2,50,0),(1,2,13.3,50,0),(1,5,23.8,50,0),(2,4,29.25,75,0),(2,11,33,75,0),(2,1,21.75,75,0),(2,9,20.25,75,0),(2,12,19.5,75,0),(2,10,27,75,0),(2,7,36.75,75,0),(2,5,25.5,75,0);

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

INSERT INTO `ec_product_categories` VALUES (1,'Custom T-Shirts',NULL,0,'Personalized cotton tees with your photos, names, and favorite memories printed in vivid color.','published',0,'categories/pod/cate-7.jpg',1,'2026-05-28 19:09:51','2026-05-28 19:09:51',NULL,NULL),(2,'Mugs & Drinkware',NULL,0,'Custom mugs, tumblers, and water bottles printed with photos and one-of-a-kind designs.','published',1,'categories/pod/cate-8.jpg',1,'2026-05-28 19:09:51','2026-05-28 19:09:51',NULL,NULL),(3,'Wall Art',NULL,0,'Photo prints, posters, and canvases that turn favorite moments into statement pieces.','published',2,'categories/pod/cate-9.jpg',1,'2026-05-28 19:09:51','2026-05-28 19:09:51',NULL,NULL),(4,'Phone Cases',NULL,0,'Slim, drop-tested phone cases with your custom photo or design — for every recent model.','published',3,'categories/pod/cate-10.jpg',1,'2026-05-28 19:09:52','2026-05-28 19:09:52',NULL,NULL),(5,'Gifts & Occasions',NULL,0,'Curated gift bundles for birthdays, weddings, anniversaries, and every milestone in between.','published',4,'categories/pod/cate-11.jpg',1,'2026-05-28 19:09:52','2026-05-28 19:09:52',NULL,NULL),(6,'Personalized Decor',NULL,0,'Engraved coasters, keepsake boxes, and decor that makes any room feel a little more like home.','published',5,'categories/pod/cate-12.jpg',1,'2026-05-28 19:09:52','2026-05-28 19:09:52',NULL,NULL),(7,'Tote Bags',NULL,0,'Heavy-duty cotton totes printed with photos, monograms, or original artwork.','published',6,'categories/pod/cate-13.jpg',1,'2026-05-28 19:09:52','2026-05-28 19:09:52',NULL,NULL),(8,'Pillows',NULL,0,'Custom-printed throw pillows that turn the couch or bedroom into a personal gallery.','published',7,'categories/pod/cate-14.jpg',1,'2026-05-28 19:09:52','2026-05-28 19:09:52',NULL,NULL),(9,'Photo Books',NULL,0,'Premium hardcover photo books for weddings, travels, and the moments worth keeping in print.','published',8,'categories/pod/cate-15.jpg',1,'2026-05-28 19:09:53','2026-05-28 19:09:53',NULL,NULL);

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

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

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

INSERT INTO `ec_product_categories_translations` VALUES ('ar',1,'قمصان مخصصة',NULL,'تي شيرت قطني مخصص مطبوع عليه صورة، الاسم والذكريات المفضلة بألوان زاهية.'),('ar',2,'الأكواب وأدوات الشرب',NULL,'أكواب وترمس وزجاجات مياه مخصصة مطبوعة بالصور والتصميمات الفريدة.'),('ar',3,'فن الحائط',NULL,'تعمل مطبوعات الصور والملصقات واللوحات القماشية على تحويل اللحظات المفضلة إلى أعمال مذهلة.'),('ar',4,'حالات الهاتف',NULL,'حافظات هاتف رفيعة تم اختبارها ضد السقوط مع رسومات أو تصميمات مخصصة - لجميع الموديلات الجديدة.'),('ar',5,'الهدايا والمناسبات',NULL,'مجموعات هدايا منسقة لأعياد الميلاد وحفلات الزفاف واحتفالات الذكرى السنوية وكل المعالم الأخرى.'),('ar',6,'ديكور شخصي',NULL,'الوقايات المنقوشة وصناديق التذكارات والعناصر الزخرفية تجعل أي غرفة تبدو مألوفة أكثر.'),('ar',7,'حمل الحقائب',NULL,'حقائب حمل قطنية فائقة المتانة مطبوعة بالصور أو الأحرف الأولى أو اللوحات الأصلية.'),('ar',8,'الوسائد',NULL,'تعمل الوسائد المطبوعة المخصصة على تحويل أريكتك أو غرفة نومك إلى صالة عرض شخصية.'),('ar',9,'كتب الصور',NULL,'ألبومات صور فاخرة بغلاف مقوى لحفلات الزفاف والرحلات واللحظات التي تستحق التقاطها على الورق.'),('fr',1,'T-shirts personnalisés',NULL,'T-shirt en coton personnalisé avec photo, nom et souvenirs préférés imprimés en couleurs vives.'),('fr',2,'Tasses et verres',NULL,'Mugs, thermos et bouteilles d\'eau personnalisés imprimés avec des images et des designs uniques.'),('fr',3,'Art mural',NULL,'Les tirages photo, les affiches et les peintures sur toile transforment vos moments préférés en œuvres époustouflantes.'),('fr',4,'Coques de téléphone',NULL,'Coques de téléphone fines et testées contre les chutes, avec des graphismes ou des designs personnalisés — pour tous les nouveaux modèles.'),('fr',5,'Cadeaux et occasions',NULL,'Coffrets cadeaux sélectionnés pour les anniversaires, les mariages, les anniversaires et tout autre événement marquant.'),('fr',6,'Décor personnalisé',NULL,'Des sous-verres gravés, des boîtes à souvenirs et des objets décoratifs rendent n\'importe quelle pièce plus familière.'),('fr',7,'Sacs fourre-tout',NULL,'Sacs fourre-tout en coton ultra résistant imprimés d\'images, d\'initiales ou de peintures originales.'),('fr',8,'Oreillers',NULL,'Les coussins imprimés personnalisés transforment votre canapé ou votre chambre en une salle d\'exposition personnelle.'),('fr',9,'Livres photos',NULL,'Albums photo à couverture rigide haut de gamme pour les mariages, les voyages et les moments à capturer sur papier.'),('id',1,'Kaos Khusus',NULL,'Kaos katun personalisasi dengan foto, nama, dan kenangan favorit dicetak dalam warna cerah.'),('id',2,'Mug & Perlengkapan Minum',NULL,'Mug, termos, dan botol air custom dicetak dengan gambar dan desain unik.'),('id',3,'Seni Dinding',NULL,'Cetakan foto, poster, dan lukisan kanvas mengubah momen favorit menjadi karya menakjubkan.'),('id',4,'Kasus Telepon',NULL,'Casing ponsel ramping dan teruji jatuh dengan grafis atau desain khusus — untuk semua model baru.'),('id',5,'Hadiah & Acara',NULL,'Set hadiah yang dikurasi untuk ulang tahun, pernikahan, hari jadi, dan setiap pencapaian lainnya.'),('id',6,'Dekorasi yang Dipersonalisasi',NULL,'Tatakan gelas berukir, kotak kenang-kenangan, dan barang-barang dekoratif membuat ruangan mana pun terasa lebih akrab.'),('id',7,'Tas Jinjing',NULL,'Tas jinjing berbahan katun ultra-tahan lama yang dicetak dengan gambar, inisial, atau lukisan asli.'),('id',8,'Bantal',NULL,'Bantal yang dicetak khusus mengubah sofa atau kamar tidur Anda menjadi ruang pamer pribadi.'),('id',9,'Buku Foto',NULL,'Album foto hardcover premium untuk pernikahan, perjalanan, dan momen yang layak diabadikan di atas kertas.'),('tr',1,'Özel Tişörtler',NULL,'Fotoğraf, isim ve en sevdiğiniz anıların canlı renkte basıldığı kişiye özel pamuklu tişört.'),('tr',2,'Kupalar ve Bardak Takımları',NULL,'Resimler ve benzersiz tasarımlarla basılmış özel kupalar, termoslar ve su şişeleri.'),('tr',3,'Duvar Sanatı',NULL,'Fotoğraf baskıları, posterler ve kanvas tablolar, en sevdiğiniz anları çarpıcı çalışmalara dönüştürüyor.'),('tr',4,'Telefon Kılıfları',NULL,'Tüm yeni modeller için özel grafik veya tasarımlara sahip ince, düşmeye karşı test edilmiş telefon kılıfları.'),('tr',5,'Hediyeler ve Özel Günler',NULL,'Doğum günleri, düğünler, yıldönümleri ve diğer tüm dönüm noktaları için özenle seçilmiş hediye setleri.'),('tr',6,'Kişiselleştirilmiş Dekor',NULL,'Oymalı bardak altlıkları, hatıra kutuları ve dekoratif öğeler her odayı daha tanıdık hale getirir.'),('tr',7,'Bez Çantalar',NULL,'Resimler, baş harfler veya orijinal resimlerle basılmış, ultra dayanıklı pamuklu bez çantalar.'),('tr',8,'Yastıklar',NULL,'Özel baskılı kırlentler, kanepenizi veya yatak odanızı kişisel bir sergi salonuna dönüştürür.'),('tr',9,'Fotoğraf Kitapları',NULL,'Düğünler, geziler ve kağıt üzerinde kaydedilmeye değer anlar için birinci sınıf ciltli fotoğraf albümleri.'),('vi',1,'Áo Thun Tùy Chỉnh',NULL,'Áo thun cotton cá nhân hóa với hình ảnh, tên và những kỷ niệm yêu thích được in màu sống động.'),('vi',2,'Cốc & Ly Uống Nước',NULL,'Cốc, ly giữ nhiệt và bình nước tùy chỉnh in hình ảnh và những thiết kế độc nhất vô nhị.'),('vi',3,'Tranh Treo Tường',NULL,'Tranh in ảnh, áp phích và tranh canvas biến những khoảnh khắc yêu thích thành tác phẩm ấn tượng.'),('vi',4,'Ốp Lưng Điện Thoại',NULL,'Ốp lưng điện thoại mỏng, đã kiểm định chống rơi với hình ảnh hoặc thiết kế tùy chỉnh — cho mọi dòng máy mới.'),('vi',5,'Quà Tặng & Dịp Lễ',NULL,'Bộ quà tặng được tuyển chọn cho sinh nhật, đám cưới, ngày kỷ niệm và mọi cột mốc khác.'),('vi',6,'Đồ Trang Trí Cá Nhân Hóa',NULL,'Lót ly khắc tên, hộp lưu niệm và đồ trang trí khiến mọi căn phòng cảm thấy thân thuộc hơn.'),('vi',7,'Túi Tote',NULL,'Túi tote cotton siêu bền in hình ảnh, tên viết tắt hoặc tranh vẽ nguyên bản.'),('vi',8,'Gối Tựa',NULL,'Gối tựa in tùy chỉnh biến chiếc ghế sofa hoặc phòng ngủ thành phòng trưng bày cá nhân.'),('vi',9,'Album Ảnh',NULL,'Album ảnh bìa cứng cao cấp cho đám cưới, những chuyến đi và những khoảnh khắc đáng lưu giữ trên giấy.');

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

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

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


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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `ec_product_collections` VALUES (1,'Custom T-Shirts','custom-t-shirts','Personalize cotton tees with your photos, names, and stories.','collection/cls-1.jpg','published','2026-05-28 19:09:53','2026-05-28 19:09:53',1),(2,'Mugs &amp; Drinkware','mugs-drinkware','Custom mugs and tumblers printed with your favorite designs.','collection/cls-10.jpg','published','2026-05-28 19:09:53','2026-05-28 19:09:53',1),(3,'Wall Art Print','wall-art-print','Photo prints and posters that turn moments into statement pieces.','collection/cls-11.jpg','published','2026-05-28 19:09:53','2026-05-28 19:09:53',1),(4,'Save 25% Today','save-25-today','T-Shirts, Hoodies & More','collection/pod-hero-save25.jpg','published','2026-05-28 19:09:53','2026-05-28 19:09:53',1),(5,'Up To 35% Off','up-to-35-off','','collection/pod-promo-12.jpg','published','2026-05-28 19:09:53','2026-05-28 19:09:53',0),(6,'Free Shipping On All Orders','free-shipping-on-all-orders','','collection/pod-promo-13.jpg','published','2026-05-28 19:09:53','2026-05-28 19:09:53',0),(7,'Free Gift With Purchase','free-gift-with-purchase','','collection/pod-promo-14.jpg','published','2026-05-28 19:09:53','2026-05-28 19:09:53',0),(8,'Limited Time Offer','limited-time-offer','','collection/pod-promo-15.jpg','published','2026-05-28 19:09:54','2026-05-28 19:09:54',0),(9,'Pet Portraits','pet-portraits','Hand-illustrated portraits of your pets on archival paper.','collection/cls-17.jpg','published','2026-05-28 19:09:54','2026-05-28 19:09:54',0);

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

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

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

INSERT INTO `ec_product_collections_translations` VALUES ('ar',1,'قمصان مخصصة','قم بتخصيص القمصان القطنية بصورتك واسمك وقصتك.'),('ar',2,'Mugs &amp; Drinkware','Custom mugs and tumblers printed with your favorite designs.'),('ar',3,'طباعة فنية على الحائط','تعمل مطبوعات الصور والملصقات على تحويل اللحظات إلى أعمال مثيرة للإعجاب.'),('ar',4,'وفر 25% اليوم','قمصان، هوديس وأكثر'),('ar',5,'خصم يصل إلى 35%',''),('ar',6,'شحن مجاني لجميع الطلبات',''),('ar',7,'هدية مجانية مع الشراء',''),('ar',8,'عرض لفترة محدودة',''),('ar',9,'صور الحيوانات الأليفة','يتم رسم صور حيواناتك الأليفة يدويًا على ورق أرشيفي عالي الجودة.'),('fr',1,'T-shirts personnalisés','Personnalisez des t-shirts en coton avec votre photo, votre nom et votre histoire.'),('fr',2,'Mugs &amp; Drinkware','Custom mugs and tumblers printed with your favorite designs.'),('fr',3,'Impression d’art mural','Les tirages photo et les affiches transforment ces moments en œuvres impressionnantes.'),('fr',4,'Économisez 25 % aujourd\'hui','T-shirts, sweats à capuche et plus'),('fr',5,'Jusqu\'à 35% de réduction',''),('fr',6,'Livraison gratuite sur toutes les commandes',''),('fr',7,'Cadeau gratuit avec achat',''),('fr',8,'Offre à durée limitée',''),('fr',9,'Portraits d\'animaux de compagnie','Vos portraits d’animaux de compagnie sont peints à la main sur du papier de qualité archivistique.'),('id',1,'Kaos Khusus','Personalisasikan kaos katun dengan foto, nama, dan cerita Anda.'),('id',2,'Mugs &amp; Drinkware','Custom mugs and tumblers printed with your favorite designs.'),('id',3,'Cetak Seni Dinding','Cetakan foto dan poster mengubah momen menjadi karya yang mengesankan.'),('id',4,'Hemat 25% Hari Ini','T-Shirt, Hoodies & Lainnya'),('id',5,'Diskon Hingga 35%.',''),('id',6,'Pengiriman Gratis Untuk Semua Pesanan',''),('id',7,'Hadiah Gratis Dengan Pembelian',''),('id',8,'Penawaran Waktu Terbatas',''),('id',9,'Potret Hewan Peliharaan','Potret hewan peliharaan Anda dilukis dengan tangan di atas kertas berkualitas arsip.'),('tr',1,'Özel Tişörtler','Pamuklu tişörtlerinizi fotoğrafınız, isminiz ve hikayenizle kişiselleştirin.'),('tr',2,'Mugs &amp; Drinkware','Custom mugs and tumblers printed with your favorite designs.'),('tr',3,'Duvar Sanatı Baskısı','Fotoğraf baskıları ve posterler anları etkileyici çalışmalara dönüştürüyor.'),('tr',4,'Bugün %25 Tasarruf Edin','Tişörtler, Kapüşonlular ve Daha Fazlası'),('tr',5,'%35\'e Varan İndirim',''),('tr',6,'Tüm Siparişlerde Ücretsiz Kargo',''),('tr',7,'Satın Almada Ücretsiz Hediye',''),('tr',8,'Sınırlı Süreli Teklif',''),('tr',9,'Evcil Hayvan Portreleri','Evcil hayvanınızın portreleri arşiv kalitesinde kağıt üzerine elle boyanır.'),('vi',1,'Áo Thun Tùy Chỉnh','Cá nhân hóa áo thun cotton với hình ảnh, tên và câu chuyện của bạn.'),('vi',2,'Mugs &amp; Drinkware','Custom mugs and tumblers printed with your favorite designs.'),('vi',3,'Tranh In Treo Tường','Tranh in ảnh và áp phích biến những khoảnh khắc thành tác phẩm ấn tượng.'),('vi',4,'Tiết kiệm 25% ngay hôm nay','Áo phông, áo hoodie và hơn thế nữa'),('vi',5,'Giảm giá tới 35%',''),('vi',6,'Miễn phí vận chuyển cho tất cả các đơn hàng',''),('vi',7,'Quà tặng miễn phí khi mua hàng',''),('vi',8,'Ưu đãi trong thời gian có hạn',''),('vi',9,'Chân Dung Thú Cưng','Những bức chân dung thú cưng của bạn được vẽ tay trên giấy chất lượng lưu trữ.');

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

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `ec_product_variation_items` VALUES (3,3,2),(5,3,3),(1,11,1),(4,16,2),(6,16,3),(2,18,1),(12,19,9),(13,19,10),(17,19,14),(8,21,5),(9,21,6),(19,21,16),(7,22,4),(10,22,7),(11,22,8),(15,22,12),(16,22,13),(14,24,11),(18,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=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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


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

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

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

INSERT INTO `ec_product_with_attribute_set` VALUES (1,1,0),(2,1,0),(3,7,0),(3,8,0),(3,10,0),(3,12,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=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ec_products` VALUES (1,'Astronaut Phone Case','astronaut-phone-case','Drop-tested slim phone case featuring a custom astronaut illustration and your name.','<p>Polycarbonate shell with TPU bumper. Wireless-charging compatible. Available for iPhone and Pixel models.</p>','published','[\"products\\/personal\\/product-1.jpg\",\"products\\/personal\\/detail-1.jpg\",\"products\\/personal\\/detail-1-2.jpg\",\"products\\/personal\\/detail-1-3.jpg\",\"products\\/personal\\/detail-1-5.jpg\",\"products\\/personal\\/detail-1-6.jpg\"]',NULL,'VI-110-A1',0,10,0,1,'in_stock',1,NULL,3,0,3,10,2.20,0,29.99,22.99,NULL,NULL,12,13,18,869,NULL,'standard',25143,'2026-05-28 19:09:58','2026-05-28 19:10:05',1,0,'Botble\\ACL\\Models\\User',0,'products/personal/product-1.jpg','physical','3583949581603',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(2,'Dinosaur Theme Mug','dinosaur-theme-mug','Glossy ceramic mug printed with playful dinosaur artwork and a custom name.','<p>11oz capacity. Microwave and dishwasher safe. Photo-quality print that survives daily use.</p>','published','[\"products\\/personal\\/product-2.jpg\"]',NULL,'MR-111',0,17,0,1,'in_stock',1,NULL,4,0,0,10,3.00,0,19.99,14.99,NULL,NULL,13,18,10,790,NULL,'standard',95137,'2026-05-28 19:09:58','2026-05-28 19:10:05',2,0,'Botble\\ACL\\Models\\User',0,'products/personal/product-2.jpg','physical','4073906302833',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(3,'Coffee Mug Custom','coffee-mug-custom','Personalize a 15oz coffee mug with your favorite photo, quote, or monogram.','<p>Premium ceramic. Dishwasher and microwave safe. Edge-to-edge full-color print.</p>','published','[\"products\\/personal\\/product-3.jpg\"]',NULL,'S7-119',0,18,0,1,'in_stock',1,NULL,2,0,0,10,3.00,0,22.99,16.99,NULL,NULL,16,12,20,874,NULL,'standard',24982,'2026-05-28 19:09:58','2026-05-28 19:10:05',3,0,'Botble\\ACL\\Models\\User',0,'products/personal/product-3.jpg','physical','7799379710445',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(4,'Egg-Crate Wall Art','egg-crate-wall-art','Statement wall art print with a playful egg-crate motif on archival matte paper.','<p>Archival inks. Available in 12x18 and 18x24. FSC-certified paper. Frame sold separately.</p>','published','[\"products\\/personal\\/product-4.jpg\"]',NULL,'TX-189',0,16,0,1,'in_stock',1,NULL,5,0,0,10,3.50,0,39.99,29.99,NULL,NULL,10,11,11,542,NULL,'standard',57699,'2026-05-28 19:09:58','2026-05-28 19:10:05',4,0,'Botble\\ACL\\Models\\User',0,'products/personal/product-4.jpg','physical','0401681383831',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(5,'Photo Candle','photo-candle','Soy-blend candle in a frosted glass jar wrapped with your favorite photograph.','<p>40-hour burn time. Lightly scented or unscented options. Perfect anniversary or memorial gift.</p>','published','[\"products\\/personal\\/product-5.jpg\"]',NULL,'AB-148',0,13,0,1,'in_stock',1,NULL,6,0,0,10,3.40,0,34.99,24.99,NULL,NULL,20,18,10,800,NULL,'standard',40262,'2026-05-28 19:09:58','2026-05-28 19:10:05',1,0,'Botble\\ACL\\Models\\User',0,'products/personal/product-5.jpg','physical','1764063675382',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(6,'Custom Tee Premium','custom-tee-premium','Heavyweight 100% cotton tee printed with your photo, art, or message.','<p>Pre-shrunk ringspun cotton. Sizes XS-3XL. Direct-to-garment print resists fading wash after wash.</p>','published','[\"products\\/personal\\/product-6.jpg\"]',NULL,'T4-118',0,10,0,1,'in_stock',1,NULL,9,0,0,10,3.50,0,32.99,24.99,NULL,NULL,16,16,10,882,NULL,'standard',76383,'2026-05-28 19:09:58','2026-05-28 19:10:05',2,0,'Botble\\ACL\\Models\\User',0,'products/personal/product-6.jpg','physical','1499506912792',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(7,'Pet Portrait Print','pet-portrait-print','Hand-illustrated portrait of your pet, printed on archival matte paper.','<p>Send any photo and our illustrators turn it into a stylized portrait. 8x10 and 16x20 sizes.</p>','published','[\"products\\/personal\\/product-7.jpg\"]',NULL,'XB-165-A1',0,12,0,1,'in_stock',1,NULL,11,0,3,10,2.70,0,49.99,39.99,NULL,NULL,17,20,14,824,NULL,'standard',34137,'2026-05-28 19:09:58','2026-05-28 19:10:05',3,0,'Botble\\ACL\\Models\\User',0,'products/personal/product-7.jpg','physical','7243276249237',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(8,'Family Tote Bag','family-tote-bag','Heavy-duty 12oz cotton tote printed with a custom family monogram or photo.','<p>Reinforced handles, machine washable. Great as a beach bag, market tote, or daily carry.</p>','published','[\"products\\/personal\\/product-8.jpg\"]',NULL,'DX-121-A1',0,17,0,1,'in_stock',0,NULL,11,0,4,10,2.60,0,24.99,17.99,NULL,NULL,18,19,15,707,NULL,'standard',59809,'2026-05-28 19:09:58','2026-05-28 19:10:05',4,0,'Botble\\ACL\\Models\\User',0,'products/personal/product-8.jpg','physical','0551391999386',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(9,'Heart Photo Frame','heart-photo-frame','Heart-shaped wooden frame with your favorite couple photo printed in soft matte.','<p>FSC-certified beech wood. Free-standing or wall-mountable. 5x5 print area.</p>','published','[\"products\\/personal\\/product-9.jpg\"]',NULL,'OH-100',0,13,0,1,'in_stock',1,NULL,5,0,0,10,2.70,0,27.99,19.99,NULL,NULL,14,14,13,749,NULL,'standard',20402,'2026-05-28 19:09:58','2026-05-28 19:10:05',1,0,'Botble\\ACL\\Models\\User',0,'products/personal/product-9.jpg','physical','9802255462975',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(10,'Personalized Pillow','personalized-pillow','Plush throw pillow printed with your photo or design — soft on both sides.','<p>16x16 polyester cover with feather-blend insert. Removable and machine washable.</p>','published','[\"products\\/personal\\/product-10.jpg\"]',NULL,'UG-144-A1',0,19,0,1,'in_stock',0,NULL,12,0,3,10,3.70,0,36.99,27.99,NULL,NULL,14,14,12,729,NULL,'standard',1482,'2026-05-28 19:09:58','2026-05-28 19:10:05',2,0,'Botble\\ACL\\Models\\User',0,'products/personal/product-10.jpg','physical','3805188083862',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(11,'Photo Book Mini','photo-book-mini','Compact 5x7 hardcover photo book — ideal for trips, weddings, or year-in-review keepsakes.','<p>20-100 page options. Premium silk paper. Layflat binding for distortion-free spreads.</p>','published','[\"products\\/personal\\/product-11.jpg\"]',NULL,'YT-152',0,18,0,1,'in_stock',1,NULL,11,0,0,10,1.60,0,44.99,34.99,NULL,NULL,18,20,20,831,NULL,'standard',124729,'2026-05-28 19:09:59','2026-05-28 19:10:05',3,0,'Botble\\ACL\\Models\\User',0,'products/personal/product-11.jpg','physical','4330946144442',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(12,'Engraved Coaster Set','engraved-coaster-set','Set of four bamboo coasters laser-engraved with names, dates, or custom artwork.','<p>FSC-certified bamboo. Cork base protects surfaces. Comes in a kraft gift box ready to give.</p>','published','[\"products\\/personal\\/product-12.jpg\"]',NULL,'PF-141-A1',0,11,0,1,'in_stock',1,NULL,6,0,3,10,3.00,0,26.99,19.99,NULL,NULL,15,19,11,639,NULL,'standard',68847,'2026-05-28 19:09:59','2026-05-28 19:10:05',4,0,'Botble\\ACL\\Models\\User',0,'products/personal/product-12.jpg','physical','1794586937407',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(13,'Astronaut Phone Case',NULL,NULL,NULL,'published','[\"products\\/personal\\/detail-1.jpg\"]',NULL,'VI-110-A1',0,10,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,29.99,NULL,NULL,NULL,12,13,18,869,NULL,'standard',0,'2026-05-28 19:09:59','2026-05-28 19:10:05',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4981471714329',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(14,'Astronaut Phone Case',NULL,NULL,NULL,'published','[\"products\\/personal\\/detail-1-2.jpg\"]',NULL,'VI-110-A1-A2',0,10,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,29.99,NULL,NULL,NULL,12,13,18,869,NULL,'standard',0,'2026-05-28 19:09:59','2026-05-28 19:10:05',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8368789256134',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(15,'Astronaut Phone Case',NULL,NULL,NULL,'published','[\"products\\/personal\\/detail-1-3.jpg\"]',NULL,'VI-110-A1-A3',0,10,0,1,'in_stock',0,NULL,3,1,0,0,0.00,0,29.99,NULL,NULL,NULL,12,13,18,869,NULL,'standard',0,'2026-05-28 19:09:59','2026-05-28 19:10:05',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5447819682143',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(16,'Pet Portrait Print',NULL,NULL,NULL,'published','[\"products\\/personal\\/product-7.jpg\"]',NULL,'XB-165-A1',0,12,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,49.99,NULL,NULL,NULL,17,20,14,824,NULL,'standard',0,'2026-05-28 19:09:59','2026-05-28 19:10:05',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','3035949805116',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(17,'Pet Portrait Print',NULL,NULL,NULL,'published','[\"products\\/personal\\/product-7.jpg\"]',NULL,'XB-165-A1-A2',0,12,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,49.99,NULL,NULL,NULL,17,20,14,824,NULL,'standard',0,'2026-05-28 19:09:59','2026-05-28 19:10:05',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6845198607686',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(18,'Pet Portrait Print',NULL,NULL,NULL,'published','[\"products\\/personal\\/product-7.jpg\"]',NULL,'XB-165-A1-A3',0,12,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,49.99,NULL,NULL,NULL,17,20,14,824,NULL,'standard',0,'2026-05-28 19:09:59','2026-05-28 19:10:05',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4354859936390',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(19,'Family Tote Bag',NULL,NULL,NULL,'published','[\"products\\/personal\\/product-8.jpg\"]',NULL,'DX-121-A1',0,17,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,24.99,20.4918,NULL,NULL,18,19,15,707,NULL,'standard',0,'2026-05-28 19:09:59','2026-05-28 19:10:05',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8896771660503',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(20,'Family Tote Bag',NULL,NULL,NULL,'published','[\"products\\/personal\\/product-8.jpg\"]',NULL,'DX-121-A1-A2',0,17,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,24.99,17.9928,NULL,NULL,18,19,15,707,NULL,'standard',0,'2026-05-28 19:09:59','2026-05-28 19:10:05',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9801287112735',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(21,'Family Tote Bag',NULL,NULL,NULL,'published','[\"products\\/personal\\/product-8.jpg\"]',NULL,'DX-121-A1-A3',0,17,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,24.99,18.7425,NULL,NULL,18,19,15,707,NULL,'standard',0,'2026-05-28 19:09:59','2026-05-28 19:10:05',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4161646547079',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(22,'Family Tote Bag',NULL,NULL,NULL,'published','[\"products\\/personal\\/product-8.jpg\"]',NULL,'DX-121-A1-A4',0,17,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,24.99,21.9912,NULL,NULL,18,19,15,707,NULL,'standard',0,'2026-05-28 19:10:00','2026-05-28 19:10:05',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6116372950165',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(23,'Personalized Pillow',NULL,NULL,NULL,'published','[\"products\\/personal\\/product-10.jpg\"]',NULL,'UG-144-A1',0,19,0,1,'in_stock',0,NULL,12,1,0,0,0.00,0,36.99,NULL,NULL,NULL,14,14,12,729,NULL,'standard',0,'2026-05-28 19:10:00','2026-05-28 19:10:05',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','0544597909440',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(24,'Personalized Pillow',NULL,NULL,NULL,'published','[\"products\\/personal\\/product-10.jpg\"]',NULL,'UG-144-A1-A2',0,19,0,1,'in_stock',0,NULL,12,1,0,0,0.00,0,36.99,NULL,NULL,NULL,14,14,12,729,NULL,'standard',0,'2026-05-28 19:10:00','2026-05-28 19:10:05',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9974560047526',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(25,'Personalized Pillow',NULL,NULL,NULL,'published','[\"products\\/personal\\/product-10.jpg\"]',NULL,'UG-144-A1-A3',0,19,0,1,'in_stock',0,NULL,12,1,0,0,0.00,0,36.99,NULL,NULL,NULL,14,14,12,729,NULL,'standard',0,'2026-05-28 19:10:00','2026-05-28 19:10:05',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','0965613468039',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(26,'Engraved Coaster Set',NULL,NULL,NULL,'published','[\"products\\/personal\\/product-12.jpg\"]',NULL,'PF-141-A1',0,11,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,26.99,22.4017,NULL,NULL,15,19,11,639,NULL,'standard',0,'2026-05-28 19:10:00','2026-05-28 19:10:05',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','7232307794280',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(27,'Engraved Coaster Set',NULL,NULL,NULL,'published','[\"products\\/personal\\/product-12.jpg\"]',NULL,'PF-141-A1-A2',0,11,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,26.99,23.4813,NULL,NULL,15,19,11,639,NULL,'standard',0,'2026-05-28 19:10:00','2026-05-28 19:10:05',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4105390459882',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(28,'Engraved Coaster Set',NULL,NULL,NULL,'published','[\"products\\/personal\\/product-12.jpg\"]',NULL,'PF-141-A1-A3',0,11,0,1,'in_stock',0,NULL,6,1,0,0,0.00,0,26.99,22.4017,NULL,NULL,15,19,11,639,NULL,'standard',0,'2026-05-28 19:10:00','2026-05-28 19:10:05',4,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4981023008357',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> حافظة من البولي كربونات مع حدود من مادة TPU. متوافق مع الشحن اللاسلكي. متوفر لطرازات iPhone وPixel.</p>'),('ar',2,'القدح موضوع الديناصور',NULL,'كوب سيراميك لامع مطبوع عليه صورة ديناصور مضحكة واسم مخصص.','<p> السعة 11 أونصة. آمن للاستخدام في الميكروويف وغسالات الأطباق. طباعة بجودة الصور التي تدوم طوال الاستخدام اليومي.</p>'),('ar',3,'كوب قهوة مخصص',NULL,'أضف طابعًا شخصيًا على كوب القهوة سعة 15 أونصة باستخدام صورتك المفضلة أو اقتباسك أو الحرف الأول من اسمك.','<p>بورسلين عالي الجودة. آمنة للاستخدام في غسالة الأطباق والميكروويف. تغطي الطباعة الملونة السطح بالكامل.</p>'),('ar',4,'لوحة فنية جدارية على شكل قفص البيض',NULL,'لوحة فنية جدارية مذهلة مع زخارف صينية البيض الممتعة على ورق أرشيفي غير لامع.','<p> حبر أرشيفي عالي الجودة. متوفر بمقاسات 12×18 و18×24. شهادة FSC. يُباع الإطار بشكل منفصل.</p>'),('ar',5,'شمعة الصورة',NULL,'شموع مملوءة بشمع الصويا في مرطبانات زجاجية بلورية مغلفة بصورتك المفضلة.','<p>مدة الحرق 40 ساعة. هناك خيارات للروائح الخفيفة أو غير المعطرة. الهدية المثالية لذكرى سنوية أو ذكرى.</p>'),('ar',6,'قسط المحملة المخصصة',NULL,'قمصان سميكة مصنوعة من القطن بنسبة 100% مطبوعة عليها صورك أو رسوماتك أو رسائلك.','<p>خيوط قطنية ملتوية منكمش مسبقًا. متوفر بمقاسات XS-3XL. قم بالطباعة مباشرة على القماش لمنع بهتان اللون خلال العديد من الغسلات.</p>'),('ar',7,'طباعة صورة الحيوانات الأليفة',NULL,'صورة حيوانك الأليف مرسومة يدويًا، ومطبوعة على ورق غير لامع بجودة أرشيفية.','<p> أرسل أي صورة وسيقوم فنانونا بتحويلها إلى صورة شخصية. متوفر بمقاسات 8x10 و16x20.</p>'),('ar',8,'حقيبة حمل العائلة',NULL,'حقيبة حمل قطنية متينة بوزن 12 أونصة مطبوعة بالأحرف الأولى أو صورة عائلية مخصصة.','<p> حزام الحقيبة مقوى ويمكن غسله في الغسالة. رائعة لحقائب الشاطئ أو حقائب التسوق أو الحقائب اليومية.</p>'),('ar',9,'إطار صور القلب',NULL,'إطار صورة خشبي على شكل قلب مع صورتك الزوجية المفضلة مطبوعة بلمسة نهائية ناعمة غير لامعة.','<p> خشب البلوط معتمد من مجلس رعاية الغابات (FSC). يمكن وضعها واقفة أو مثبتة على الحائط. منطقة طباعة الصور 5x5.</p>'),('ar',10,'وسادة شخصية',NULL,'وسائد مريحة مطبوع عليها صورتك أو تصميمك — ناعمة على كلا الجانبين.','<p> غلاف من البوليستر مقاس 16 × 16 مع جزء داخلي مملوء بالريش. قابل للإزالة والغسل في الغسالة.</p>'),('ar',11,'كتاب الصور المصغرة',NULL,'ألبوم صور صغير الحجم بغلاف مقوى مقاس 5 × 7 - مثالي للرحلات أو حفلات الزفاف أو احتفالات نهاية العام.','<p>اختياري 20-100 صفحة. ورق مناديل عالي الجودة. تجليد مسطح لصفحات الصور الطويلة والخالية من التشويه.</p>'),('ar',12,'مجموعة كوستر محفورة',NULL,'طقم من أربع قواعد أكواب من الخيزران محفورة بالليزر بالأسماء أو التواريخ أو الرسومات المخصصة.','<p> الخيزران معتمد من مجلس رعاية الغابات (FSC). نعل الفلين يحمي السطح. معبأة في صندوق هدايا من ورق الكرافت جاهز للتقديم.</p>'),('ar',13,'حافظة هاتف رائد الفضاء',NULL,'حافظة هاتف رفيعة تم اختبارها ضد السقوط مع طباعة مخصصة لرائد فضاء واسمك.','<p> حافظة من البولي كربونات مع حدود من مادة TPU. متوافق مع الشحن اللاسلكي. متوفر لطرازات iPhone وPixel.</p>'),('ar',14,'حافظة هاتف رائد الفضاء',NULL,'حافظة هاتف رفيعة تم اختبارها ضد السقوط مع طباعة مخصصة لرائد فضاء واسمك.','<p> حافظة من البولي كربونات مع حدود من مادة TPU. متوافق مع الشحن اللاسلكي. متوفر لطرازات iPhone وPixel.</p>'),('ar',15,'حافظة هاتف رائد الفضاء',NULL,'حافظة هاتف رفيعة تم اختبارها ضد السقوط مع طباعة مخصصة لرائد فضاء واسمك.','<p> حافظة من البولي كربونات مع حدود من مادة TPU. متوافق مع الشحن اللاسلكي. متوفر لطرازات iPhone وPixel.</p>'),('ar',16,'طباعة صورة الحيوانات الأليفة',NULL,'صورة حيوانك الأليف مرسومة يدويًا، ومطبوعة على ورق غير لامع بجودة أرشيفية.','<p> أرسل أي صورة وسيقوم فنانونا بتحويلها إلى صورة شخصية. متوفر بمقاسات 8x10 و16x20.</p>'),('ar',17,'طباعة صورة الحيوانات الأليفة',NULL,'صورة حيوانك الأليف مرسومة يدويًا، ومطبوعة على ورق غير لامع بجودة أرشيفية.','<p> أرسل أي صورة وسيقوم فنانونا بتحويلها إلى صورة شخصية. متوفر بمقاسات 8x10 و16x20.</p>'),('ar',18,'طباعة صورة الحيوانات الأليفة',NULL,'صورة حيوانك الأليف مرسومة يدويًا، ومطبوعة على ورق غير لامع بجودة أرشيفية.','<p> أرسل أي صورة وسيقوم فنانونا بتحويلها إلى صورة شخصية. متوفر بمقاسات 8x10 و16x20.</p>'),('ar',19,'حقيبة حمل العائلة',NULL,'حقيبة حمل قطنية متينة بوزن 12 أونصة مطبوعة بالأحرف الأولى أو صورة عائلية مخصصة.','<p> حزام الحقيبة مقوى ويمكن غسله في الغسالة. رائعة لحقائب الشاطئ أو حقائب التسوق أو الحقائب اليومية.</p>'),('ar',20,'حقيبة حمل العائلة',NULL,'حقيبة حمل قطنية متينة بوزن 12 أونصة مطبوعة بالأحرف الأولى أو صورة عائلية مخصصة.','<p> حزام الحقيبة مقوى ويمكن غسله في الغسالة. رائعة لحقائب الشاطئ أو حقائب التسوق أو الحقائب اليومية.</p>'),('ar',21,'حقيبة حمل العائلة',NULL,'حقيبة حمل قطنية متينة بوزن 12 أونصة مطبوعة بالأحرف الأولى أو صورة عائلية مخصصة.','<p> حزام الحقيبة مقوى ويمكن غسله في الغسالة. رائعة لحقائب الشاطئ أو حقائب التسوق أو الحقائب اليومية.</p>'),('ar',22,'حقيبة حمل العائلة',NULL,'حقيبة حمل قطنية متينة بوزن 12 أونصة مطبوعة بالأحرف الأولى أو صورة عائلية مخصصة.','<p> حزام الحقيبة مقوى ويمكن غسله في الغسالة. رائعة لحقائب الشاطئ أو حقائب التسوق أو الحقائب اليومية.</p>'),('ar',23,'وسادة شخصية',NULL,'وسائد مريحة مطبوع عليها صورتك أو تصميمك — ناعمة على كلا الجانبين.','<p> غلاف من البوليستر مقاس 16 × 16 مع جزء داخلي مملوء بالريش. قابل للإزالة والغسل في الغسالة.</p>'),('ar',24,'وسادة شخصية',NULL,'وسائد مريحة مطبوع عليها صورتك أو تصميمك — ناعمة على كلا الجانبين.','<p> غلاف من البوليستر مقاس 16 × 16 مع جزء داخلي مملوء بالريش. قابل للإزالة والغسل في الغسالة.</p>'),('ar',25,'وسادة شخصية',NULL,'وسائد مريحة مطبوع عليها صورتك أو تصميمك — ناعمة على كلا الجانبين.','<p> غلاف من البوليستر مقاس 16 × 16 مع جزء داخلي مملوء بالريش. قابل للإزالة والغسل في الغسالة.</p>'),('ar',26,'مجموعة كوستر محفورة',NULL,'طقم من أربع قواعد أكواب من الخيزران محفورة بالليزر بالأسماء أو التواريخ أو الرسومات المخصصة.','<p> الخيزران معتمد من مجلس رعاية الغابات (FSC). نعل الفلين يحمي السطح. معبأة في صندوق هدايا من ورق الكرافت جاهز للتقديم.</p>'),('ar',27,'مجموعة كوستر محفورة',NULL,'طقم من أربع قواعد أكواب من الخيزران محفورة بالليزر بالأسماء أو التواريخ أو الرسومات المخصصة.','<p> الخيزران معتمد من مجلس رعاية الغابات (FSC). نعل الفلين يحمي السطح. معبأة في صندوق هدايا من ورق الكرافت جاهز للتقديم.</p>'),('ar',28,'مجموعة كوستر محفورة',NULL,'طقم من أربع قواعد أكواب من الخيزران محفورة بالليزر بالأسماء أو التواريخ أو الرسومات المخصصة.','<p> الخيزران معتمد من مجلس رعاية الغابات (FSC). نعل الفلين يحمي السطح. معبأة في صندوق هدايا من ورق الكرافت جاهز للتقديم.</p>'),('fr',1,'Coque de téléphone astronaute',NULL,'Coque de téléphone fine et résistante aux chutes, avec imprimé astronaute personnalisé et votre nom.','<p>Coque en polycarbonate avec bordure en TPU. Compatible chargement sans fil. Disponible pour les modèles iPhone et Pixel.</p>'),('fr',2,'Tasse thème dinosaure',NULL,'Tasse en céramique brillante imprimée avec une image amusante de dinosaure et un nom personnalisé.','<p>Capacité 11oz. Passe au micro-ondes et au lave-vaisselle. Imprimez une qualité photo qui dure lors d\'une utilisation quotidienne.</p>'),('fr',3,'Tasse à café personnalisée',NULL,'Personnalisez votre tasse à café de 15 oz avec votre photo, citation ou initiale préférée.','<p>Porcelaine de haute qualité. Passe au lave-vaisselle et au micro-ondes. L\'impression couleur couvre toute la surface.</p>'),('fr',4,'Art mural en forme de caisse à œufs',NULL,'Superbe art mural avec un motif amusant de plateau à œufs sur du papier mat de qualité archivistique.','<p>Encre de qualité archivistique. Disponible en tailles 12x18 et 18x24. Certificat FSC. Cadre vendu séparément.</p>'),('fr',5,'Bougie photo',NULL,'Bougies infusées à la cire de soja dans des pots en verre dépoli enveloppées de votre photo préférée.','<p>Durée de combustion 40 heures. Il existe des options pour des parfums légers ou non parfumés. Le cadeau parfait pour un anniversaire ou un souvenir.</p>'),('fr',6,'T-shirt personnalisé Premium',NULL,'T-shirts épais 100% coton imprimés avec vos images, dessins ou messages.','<p>Fil de coton torsadé pré-rétréci. Disponible dans les tailles XS-3XL. Imprimez directement sur le tissu pour éviter la décoloration après de nombreux lavages.</p>'),('fr',7,'Impression de portrait d’animal de compagnie',NULL,'Le portrait de votre animal est dessiné à la main, imprimé sur du papier mat de qualité archivistique.','<p>Envoyez n\'importe quelle photo et nos artistes la transformeront en un portrait stylisé. Disponible en tailles 8x10 et 16x20.</p>'),('fr',8,'Sac fourre-tout familial',NULL,'Sac fourre-tout en coton durable de 12 oz imprimé avec des initiales ou une photo de famille personnalisée.','<p>La sangle du sac est renforcée et lavable en machine. Idéal pour les sacs de plage, les sacs de courses ou les sacs de tous les jours.</p>'),('fr',9,'Cadre photo coeur',NULL,'Cadre photo en bois en forme de cœur avec votre photo de couple préférée imprimée dans une finition mate douce.','<p>Le bois de chêne est certifié FSC. Peut être placé debout ou fixé au mur. Zone d\'impression photo 5x5.</p>'),('fr',10,'Oreiller personnalisé',NULL,'Coussins confortables imprimés à votre image ou design – doux des deux côtés.','Coquille en polyester <p>16x16 avec intérieur rempli de plumes. Amovible et lavable en machine.</p>'),('fr',11,'Livre photo mini',NULL,'Album photo compact à couverture rigide 5 x 7 — idéal pour les voyages, les mariages ou les fêtes de fin d\'année.','<p>20 à 100 pages en option. Papier de soie de haute qualité. Reliure plate pour de longues pages photo sans distorsion.</p>'),('fr',12,'Ensemble de sous-verres gravés',NULL,'Ensemble de quatre sous-verres en bambou gravés au laser avec des noms, des dates ou des dessins personnalisés.','<p>Bambou est certifié FSC. La semelle en liège protège la surface. Emballé dans une boîte cadeau en papier kraft prêt à offrir.</p>'),('fr',13,'Coque de téléphone astronaute',NULL,'Coque de téléphone fine et résistante aux chutes, avec imprimé astronaute personnalisé et votre nom.','<p>Coque en polycarbonate avec bordure en TPU. Compatible chargement sans fil. Disponible pour les modèles iPhone et Pixel.</p>'),('fr',14,'Coque de téléphone astronaute',NULL,'Coque de téléphone fine et résistante aux chutes, avec imprimé astronaute personnalisé et votre nom.','<p>Coque en polycarbonate avec bordure en TPU. Compatible chargement sans fil. Disponible pour les modèles iPhone et Pixel.</p>'),('fr',15,'Coque de téléphone astronaute',NULL,'Coque de téléphone fine et résistante aux chutes, avec imprimé astronaute personnalisé et votre nom.','<p>Coque en polycarbonate avec bordure en TPU. Compatible chargement sans fil. Disponible pour les modèles iPhone et Pixel.</p>'),('fr',16,'Impression de portrait d’animal de compagnie',NULL,'Le portrait de votre animal est dessiné à la main, imprimé sur du papier mat de qualité archivistique.','<p>Envoyez n\'importe quelle photo et nos artistes la transformeront en un portrait stylisé. Disponible en tailles 8x10 et 16x20.</p>'),('fr',17,'Impression de portrait d’animal de compagnie',NULL,'Le portrait de votre animal est dessiné à la main, imprimé sur du papier mat de qualité archivistique.','<p>Envoyez n\'importe quelle photo et nos artistes la transformeront en un portrait stylisé. Disponible en tailles 8x10 et 16x20.</p>'),('fr',18,'Impression de portrait d’animal de compagnie',NULL,'Le portrait de votre animal est dessiné à la main, imprimé sur du papier mat de qualité archivistique.','<p>Envoyez n\'importe quelle photo et nos artistes la transformeront en un portrait stylisé. Disponible en tailles 8x10 et 16x20.</p>'),('fr',19,'Sac fourre-tout familial',NULL,'Sac fourre-tout en coton durable de 12 oz imprimé avec des initiales ou une photo de famille personnalisée.','<p>La sangle du sac est renforcée et lavable en machine. Idéal pour les sacs de plage, les sacs de courses ou les sacs de tous les jours.</p>'),('fr',20,'Sac fourre-tout familial',NULL,'Sac fourre-tout en coton durable de 12 oz imprimé avec des initiales ou une photo de famille personnalisée.','<p>La sangle du sac est renforcée et lavable en machine. Idéal pour les sacs de plage, les sacs de courses ou les sacs de tous les jours.</p>'),('fr',21,'Sac fourre-tout familial',NULL,'Sac fourre-tout en coton durable de 12 oz imprimé avec des initiales ou une photo de famille personnalisée.','<p>La sangle du sac est renforcée et lavable en machine. Idéal pour les sacs de plage, les sacs de courses ou les sacs de tous les jours.</p>'),('fr',22,'Sac fourre-tout familial',NULL,'Sac fourre-tout en coton durable de 12 oz imprimé avec des initiales ou une photo de famille personnalisée.','<p>La sangle du sac est renforcée et lavable en machine. Idéal pour les sacs de plage, les sacs de courses ou les sacs de tous les jours.</p>'),('fr',23,'Oreiller personnalisé',NULL,'Coussins confortables imprimés à votre image ou design – doux des deux côtés.','Coquille en polyester <p>16x16 avec intérieur rempli de plumes. Amovible et lavable en machine.</p>'),('fr',24,'Oreiller personnalisé',NULL,'Coussins confortables imprimés à votre image ou design – doux des deux côtés.','Coquille en polyester <p>16x16 avec intérieur rempli de plumes. Amovible et lavable en machine.</p>'),('fr',25,'Oreiller personnalisé',NULL,'Coussins confortables imprimés à votre image ou design – doux des deux côtés.','Coquille en polyester <p>16x16 avec intérieur rempli de plumes. Amovible et lavable en machine.</p>'),('fr',26,'Ensemble de sous-verres gravés',NULL,'Ensemble de quatre sous-verres en bambou gravés au laser avec des noms, des dates ou des dessins personnalisés.','<p>Bambou est certifié FSC. La semelle en liège protège la surface. Emballé dans une boîte cadeau en papier kraft prêt à offrir.</p>'),('fr',27,'Ensemble de sous-verres gravés',NULL,'Ensemble de quatre sous-verres en bambou gravés au laser avec des noms, des dates ou des dessins personnalisés.','<p>Bambou est certifié FSC. La semelle en liège protège la surface. Emballé dans une boîte cadeau en papier kraft prêt à offrir.</p>'),('fr',28,'Ensemble de sous-verres gravés',NULL,'Ensemble de quatre sous-verres en bambou gravés au laser avec des noms, des dates ou des dessins personnalisés.','<p>Bambou est certifié FSC. La semelle en liège protège la surface. Emballé dans une boîte cadeau en papier kraft prêt à offrir.</p>'),('id',1,'Casing Ponsel Astronot',NULL,'Casing ponsel ramping dan tahan jatuh dengan cetakan astronot khusus dan nama Anda.','<p>Kasing polikarbonat dengan pinggiran TPU. Kompatibel dengan pengisian daya nirkabel. Tersedia untuk model iPhone dan Pixel.</p>'),('id',2,'Mug Tema Dinosaurus',NULL,'Mug keramik mengkilap dengan motif gambar dinosaurus lucu dan nama custom.','<p>Kapasitas 11oz. Aman untuk microwave dan mesin pencuci piring. Kualitas cetak foto yang tahan lama digunakan sehari-hari.</p>'),('id',3,'Mug Kopi Kustom',NULL,'Personalisasikan cangkir kopi 15oz Anda dengan foto, kutipan, atau inisial favorit Anda.','<p>Porselen berkualitas tinggi. Aman untuk mesin pencuci piring dan microwave. Pencetakan warna menutupi seluruh permukaan.</p>'),('id',4,'Seni Dinding Peti Telur',NULL,'Seni dinding menakjubkan dengan motif baki telur yang lucu di atas kertas matte kualitas arsip.','<p>Tinta kualitas arsip. Tersedia dalam ukuran 12x18 dan 18x24. Sertifikat FSC. Bingkai dijual terpisah.</p>'),('id',5,'Lilin Foto',NULL,'Lilin berisi lilin kedelai dalam stoples kaca buram yang dibungkus dengan foto favorit Anda.','<p>Waktu pembakaran 40 jam. Ada pilihan untuk aroma ringan atau tanpa pewangi. Hadiah yang sempurna untuk ulang tahun atau kenangan.</p>'),('id',6,'Kaos Premium Kustom',NULL,'Kaos katun 100% tebal yang dicetak dengan gambar, gambar, atau pesan Anda.','<p>Benang katun pilin yang sudah menyusut. Tersedia dalam ukuran XS-3XL. Cetak langsung pada kain untuk mencegah luntur setelah berkali-kali dicuci.</p>'),('id',7,'Cetak Potret Hewan Peliharaan',NULL,'Potret hewan peliharaan Anda digambar tangan, dicetak di atas kertas matte berkualitas arsip.','<p>Kirim foto apa pun dan artis kami akan mengubahnya menjadi potret bergaya. Tersedia dalam ukuran 8x10 dan 16x20.</p>'),('id',8,'Tas Jinjing Keluarga',NULL,'Tas jinjing katun 12oz yang tahan lama dicetak dengan inisial atau foto keluarga khusus.','<p>Tali tas diperkuat dan bisa dicuci dengan mesin. Cocok untuk tas pantai, tas belanja, atau tas sehari-hari.</p>'),('id',9,'Bingkai Foto Hati',NULL,'Bingkai foto kayu berbentuk hati dengan foto pasangan favorit Anda dicetak dengan finishing matte lembut.','<p>Kayu ek bersertifikat FSC. Dapat ditempatkan berdiri atau dipasang di dinding. Area pencetakan foto 5x5.</p>'),('id',10,'Bantal yang Dipersonalisasi',NULL,'Bantal nyaman yang dicetak dengan gambar atau desain Anda — lembut di kedua sisi.','<p>16x16 cangkang poliester dengan bagian dalam berisi bulu. Dapat dilepas dan dicuci dengan mesin.</p>'),('id',11,'Buku Foto Mini',NULL,'Album foto hardcover berukuran 5x7 yang ringkas — ideal untuk perjalanan, pernikahan, atau perayaan akhir tahun.','<p>Opsional 20-100 halaman. Kertas tisu berkualitas tinggi. Penjilidan datar untuk halaman foto yang panjang dan bebas distorsi.</p>'),('id',12,'Set Tatakan Terukir',NULL,'Set empat tatakan gelas bambu yang diukir dengan nama, tanggal, atau gambar khusus.','<p>Bambu bersertifikat FSC. Sol gabus melindungi permukaan. Dikemas dalam kotak kado kertas kraft siap untuk diberikan.</p>'),('id',13,'Casing Ponsel Astronot',NULL,'Casing ponsel ramping dan tahan jatuh dengan cetakan astronot khusus dan nama Anda.','<p>Kasing polikarbonat dengan pinggiran TPU. Kompatibel dengan pengisian daya nirkabel. Tersedia untuk model iPhone dan Pixel.</p>'),('id',14,'Casing Ponsel Astronot',NULL,'Casing ponsel ramping dan tahan jatuh dengan cetakan astronot khusus dan nama Anda.','<p>Kasing polikarbonat dengan pinggiran TPU. Kompatibel dengan pengisian daya nirkabel. Tersedia untuk model iPhone dan Pixel.</p>'),('id',15,'Casing Ponsel Astronot',NULL,'Casing ponsel ramping dan tahan jatuh dengan cetakan astronot khusus dan nama Anda.','<p>Kasing polikarbonat dengan pinggiran TPU. Kompatibel dengan pengisian daya nirkabel. Tersedia untuk model iPhone dan Pixel.</p>'),('id',16,'Cetak Potret Hewan Peliharaan',NULL,'Potret hewan peliharaan Anda digambar tangan, dicetak di atas kertas matte berkualitas arsip.','<p>Kirim foto apa pun dan artis kami akan mengubahnya menjadi potret bergaya. Tersedia dalam ukuran 8x10 dan 16x20.</p>'),('id',17,'Cetak Potret Hewan Peliharaan',NULL,'Potret hewan peliharaan Anda digambar tangan, dicetak di atas kertas matte berkualitas arsip.','<p>Kirim foto apa pun dan artis kami akan mengubahnya menjadi potret bergaya. Tersedia dalam ukuran 8x10 dan 16x20.</p>'),('id',18,'Cetak Potret Hewan Peliharaan',NULL,'Potret hewan peliharaan Anda digambar tangan, dicetak di atas kertas matte berkualitas arsip.','<p>Kirim foto apa pun dan artis kami akan mengubahnya menjadi potret bergaya. Tersedia dalam ukuran 8x10 dan 16x20.</p>'),('id',19,'Tas Jinjing Keluarga',NULL,'Tas jinjing katun 12oz yang tahan lama dicetak dengan inisial atau foto keluarga khusus.','<p>Tali tas diperkuat dan bisa dicuci dengan mesin. Cocok untuk tas pantai, tas belanja, atau tas sehari-hari.</p>'),('id',20,'Tas Jinjing Keluarga',NULL,'Tas jinjing katun 12oz yang tahan lama dicetak dengan inisial atau foto keluarga khusus.','<p>Tali tas diperkuat dan bisa dicuci dengan mesin. Cocok untuk tas pantai, tas belanja, atau tas sehari-hari.</p>'),('id',21,'Tas Jinjing Keluarga',NULL,'Tas jinjing katun 12oz yang tahan lama dicetak dengan inisial atau foto keluarga khusus.','<p>Tali tas diperkuat dan bisa dicuci dengan mesin. Cocok untuk tas pantai, tas belanja, atau tas sehari-hari.</p>'),('id',22,'Tas Jinjing Keluarga',NULL,'Tas jinjing katun 12oz yang tahan lama dicetak dengan inisial atau foto keluarga khusus.','<p>Tali tas diperkuat dan bisa dicuci dengan mesin. Cocok untuk tas pantai, tas belanja, atau tas sehari-hari.</p>'),('id',23,'Bantal yang Dipersonalisasi',NULL,'Bantal nyaman yang dicetak dengan gambar atau desain Anda — lembut di kedua sisi.','<p>16x16 cangkang poliester dengan bagian dalam berisi bulu. Dapat dilepas dan dicuci dengan mesin.</p>'),('id',24,'Bantal yang Dipersonalisasi',NULL,'Bantal nyaman yang dicetak dengan gambar atau desain Anda — lembut di kedua sisi.','<p>16x16 cangkang poliester dengan bagian dalam berisi bulu. Dapat dilepas dan dicuci dengan mesin.</p>'),('id',25,'Bantal yang Dipersonalisasi',NULL,'Bantal nyaman yang dicetak dengan gambar atau desain Anda — lembut di kedua sisi.','<p>16x16 cangkang poliester dengan bagian dalam berisi bulu. Dapat dilepas dan dicuci dengan mesin.</p>'),('id',26,'Set Tatakan Terukir',NULL,'Set empat tatakan gelas bambu yang diukir dengan nama, tanggal, atau gambar khusus.','<p>Bambu bersertifikat FSC. Sol gabus melindungi permukaan. Dikemas dalam kotak kado kertas kraft siap untuk diberikan.</p>'),('id',27,'Set Tatakan Terukir',NULL,'Set empat tatakan gelas bambu yang diukir dengan nama, tanggal, atau gambar khusus.','<p>Bambu bersertifikat FSC. Sol gabus melindungi permukaan. Dikemas dalam kotak kado kertas kraft siap untuk diberikan.</p>'),('id',28,'Set Tatakan Terukir',NULL,'Set empat tatakan gelas bambu yang diukir dengan nama, tanggal, atau gambar khusus.','<p>Bambu bersertifikat FSC. Sol gabus melindungi permukaan. Dikemas dalam kotak kado kertas kraft siap untuk diberikan.</p>'),('tr',1,'Astronot Telefon Kılıfı',NULL,'Özel astronot baskısı ve adınızın yer aldığı ince, düşmeye karşı test edilmiş telefon kılıfı.','<p>TPU çerçeveli polikarbon kasa. Kablosuz şarj uyumlu. iPhone ve Pixel modellerinde mevcuttur.</p>'),('tr',2,'Dinozor Temalı Kupa',NULL,'Komik bir dinozor görseli ve kişiselleştirilmiş ismin basıldığı parlak seramik kupa.','<p>Kapasite 11 ons. Mikrodalga fırınlar ve bulaşık makineleri için güvenlidir. Günlük kullanıma dayanacak fotoğraf kalitesine sahip baskılar alın.</p>'),('tr',3,'Kahve Kupa Özel',NULL,'15 oz kahve kupanızı en sevdiğiniz fotoğraf, alıntı veya baş harfle kişiselleştirin.','<p>Yüksek kaliteli porselen. Bulaşık makinesi ve mikrodalga fırına uygundur. Renkli baskı tüm yüzeyi kaplar.</p>'),('tr',4,'Yumurta Sandığı Duvar Sanatı',NULL,'Arşiv kalitesinde mat kağıt üzerine eğlenceli yumurta tepsisi motifli göz alıcı duvar sanatı.','<p>Arşiv kalitesinde mürekkep. 12x18 ve 18x24 ebatlarında mevcuttur. FSC sertifikası. Çerçeve ayrı satılır.</p>'),('tr',5,'Fotoğraf Mumu',NULL,'En sevdiğiniz fotoğrafla sarılmış buzlu cam kavanozlarda soya mumu içeren mumlar.','<p>Yanma süresi 40 saat. Hafif veya kokusuz koku seçenekleri mevcuttur. Bir yıldönümü veya anma için mükemmel bir hediye.</p>'),('tr',6,'Özel Tişört Premium',NULL,'Resimlerinizin, çizimlerinizin veya mesajlarınızın basıldığı %100 pamuklu kalın tişörtler.','<p>Önceden çektirilmiş bükümlü pamuk ipliği. XS-3XL bedenleri mevcuttur. Birçok yıkamada solmayı önlemek için doğrudan kumaş üzerine baskı yapın.</p>'),('tr',7,'Evcil Hayvan Portresi Baskısı',NULL,'Evcil hayvanınızın portresi elle çizilmiş, arşiv kalitesinde mat kağıda basılmıştır.','<p>Herhangi bir fotoğrafı gönderin, sanatçılarımız bunu stilize edilmiş bir portreye dönüştürsün. 8x10 ve 16x20 ebatlarında mevcuttur.</p>'),('tr',8,'Aile Çantası',NULL,'Baş harfleri veya özel aile fotoğrafı baskılı, dayanıklı 12 ons pamuklu çanta.','<p>Çanta askısı güçlendirilmiştir ve makinede yıkanabilir. Plaj çantaları, alışveriş çantaları veya günlük çantalar için idealdir.</p>'),('tr',9,'Kalp Fotoğraf Çerçevesi',NULL,'En sevdiğiniz çift fotoğrafının yumuşak mat yüzeye basıldığı kalp şeklinde ahşap fotoğraf çerçevesi.','<p>Meşe ağacı FSC sertifikalıdır. Ayakta yerleştirilebilir veya duvara monte edilebilir. Fotoğraf baskı alanı 5x5.</p>'),('tr',10,'Kişiye Özel Yastık',NULL,'Her iki tarafı da yumuşak olan, görselinizin veya tasarımınızın basıldığı konforlu kırlentler.','<p>16x16 içi tüy dolgulu polyester kabuk. Çıkarılabilir ve makinede yıkanabilir.</p>'),('tr',11,'Fotoğraf Kitabı Mini',NULL,'Kompakt 5x7 ciltli fotoğraf albümü — geziler, düğünler veya yıl sonu kutlamaları için idealdir.','<p>İsteğe bağlı 20-100 sayfa. Yüksek kaliteli kağıt mendil. Uzun, bozulmasız fotoğraf sayfaları için düz ciltleme.</p>'),('tr',12,'İşlemeli Bardak Altlığı Seti',NULL,'İsimler, tarihler veya özel çizimlerle lazerle kazınmış dört bambu bardak altlığı seti.','<p>Bambu FSC sertifikalıdır. Mantar taban yüzeyi korur. Hediyeye hazır kraft kağıt hediye kutusunda paketlenmiştir.</p>'),('tr',13,'Astronot Telefon Kılıfı',NULL,'Özel astronot baskısı ve adınızın yer aldığı ince, düşmeye karşı test edilmiş telefon kılıfı.','<p>TPU çerçeveli polikarbon kasa. Kablosuz şarj uyumlu. iPhone ve Pixel modellerinde mevcuttur.</p>'),('tr',14,'Astronot Telefon Kılıfı',NULL,'Özel astronot baskısı ve adınızın yer aldığı ince, düşmeye karşı test edilmiş telefon kılıfı.','<p>TPU çerçeveli polikarbon kasa. Kablosuz şarj uyumlu. iPhone ve Pixel modellerinde mevcuttur.</p>'),('tr',15,'Astronot Telefon Kılıfı',NULL,'Özel astronot baskısı ve adınızın yer aldığı ince, düşmeye karşı test edilmiş telefon kılıfı.','<p>TPU çerçeveli polikarbon kasa. Kablosuz şarj uyumlu. iPhone ve Pixel modellerinde mevcuttur.</p>'),('tr',16,'Evcil Hayvan Portresi Baskısı',NULL,'Evcil hayvanınızın portresi elle çizilmiş, arşiv kalitesinde mat kağıda basılmıştır.','<p>Herhangi bir fotoğrafı gönderin, sanatçılarımız bunu stilize edilmiş bir portreye dönüştürsün. 8x10 ve 16x20 ebatlarında mevcuttur.</p>'),('tr',17,'Evcil Hayvan Portresi Baskısı',NULL,'Evcil hayvanınızın portresi elle çizilmiş, arşiv kalitesinde mat kağıda basılmıştır.','<p>Herhangi bir fotoğrafı gönderin, sanatçılarımız bunu stilize edilmiş bir portreye dönüştürsün. 8x10 ve 16x20 ebatlarında mevcuttur.</p>'),('tr',18,'Evcil Hayvan Portresi Baskısı',NULL,'Evcil hayvanınızın portresi elle çizilmiş, arşiv kalitesinde mat kağıda basılmıştır.','<p>Herhangi bir fotoğrafı gönderin, sanatçılarımız bunu stilize edilmiş bir portreye dönüştürsün. 8x10 ve 16x20 ebatlarında mevcuttur.</p>'),('tr',19,'Aile Çantası',NULL,'Baş harfleri veya özel aile fotoğrafı baskılı, dayanıklı 12 ons pamuklu çanta.','<p>Çanta askısı güçlendirilmiştir ve makinede yıkanabilir. Plaj çantaları, alışveriş çantaları veya günlük çantalar için idealdir.</p>'),('tr',20,'Aile Çantası',NULL,'Baş harfleri veya özel aile fotoğrafı baskılı, dayanıklı 12 ons pamuklu çanta.','<p>Çanta askısı güçlendirilmiştir ve makinede yıkanabilir. Plaj çantaları, alışveriş çantaları veya günlük çantalar için idealdir.</p>'),('tr',21,'Aile Çantası',NULL,'Baş harfleri veya özel aile fotoğrafı baskılı, dayanıklı 12 ons pamuklu çanta.','<p>Çanta askısı güçlendirilmiştir ve makinede yıkanabilir. Plaj çantaları, alışveriş çantaları veya günlük çantalar için idealdir.</p>'),('tr',22,'Aile Çantası',NULL,'Baş harfleri veya özel aile fotoğrafı baskılı, dayanıklı 12 ons pamuklu çanta.','<p>Çanta askısı güçlendirilmiştir ve makinede yıkanabilir. Plaj çantaları, alışveriş çantaları veya günlük çantalar için idealdir.</p>'),('tr',23,'Kişiye Özel Yastık',NULL,'Her iki tarafı da yumuşak olan, görselinizin veya tasarımınızın basıldığı konforlu kırlentler.','<p>16x16 içi tüy dolgulu polyester kabuk. Çıkarılabilir ve makinede yıkanabilir.</p>'),('tr',24,'Kişiye Özel Yastık',NULL,'Her iki tarafı da yumuşak olan, görselinizin veya tasarımınızın basıldığı konforlu kırlentler.','<p>16x16 içi tüy dolgulu polyester kabuk. Çıkarılabilir ve makinede yıkanabilir.</p>'),('tr',25,'Kişiye Özel Yastık',NULL,'Her iki tarafı da yumuşak olan, görselinizin veya tasarımınızın basıldığı konforlu kırlentler.','<p>16x16 içi tüy dolgulu polyester kabuk. Çıkarılabilir ve makinede yıkanabilir.</p>'),('tr',26,'İşlemeli Bardak Altlığı Seti',NULL,'İsimler, tarihler veya özel çizimlerle lazerle kazınmış dört bambu bardak altlığı seti.','<p>Bambu FSC sertifikalıdır. Mantar taban yüzeyi korur. Hediyeye hazır kraft kağıt hediye kutusunda paketlenmiştir.</p>'),('tr',27,'İşlemeli Bardak Altlığı Seti',NULL,'İsimler, tarihler veya özel çizimlerle lazerle kazınmış dört bambu bardak altlığı seti.','<p>Bambu FSC sertifikalıdır. Mantar taban yüzeyi korur. Hediyeye hazır kraft kağıt hediye kutusunda paketlenmiştir.</p>'),('tr',28,'İşlemeli Bardak Altlığı Seti',NULL,'İsimler, tarihler veya özel çizimlerle lazerle kazınmış dört bambu bardak altlığı seti.','<p>Bambu FSC sertifikalıdır. Mantar taban yüzeyi korur. Hediyeye hazır kraft kağıt hediye kutusunda paketlenmiştir.</p>'),('vi',1,'Ốp Lưng Điện Thoại Phi Hành Gia',NULL,'Ốp lưng điện thoại mỏng đã qua kiểm định chống rơi, in hình phi hành gia tùy chỉnh kèm tên của bạn.','<p>Vỏ polycarbonate với viền TPU. Tương thích sạc không dây. Có sẵn cho các dòng iPhone và Pixel.</p>'),('vi',2,'Cốc Sứ Họa Tiết Khủng Long',NULL,'Cốc sứ bóng in hình khủng long ngộ nghĩnh kèm tên tùy chỉnh.','<p>Dung tích 11oz. An toàn với lò vi sóng và máy rửa chén. In chất lượng ảnh bền bỉ qua sử dụng hàng ngày.</p>'),('vi',3,'Cốc Cà Phê Tùy Chỉnh',NULL,'Cá nhân hóa chiếc cốc cà phê 15oz với bức ảnh, câu nói hoặc tên viết tắt yêu thích của bạn.','<p>Sứ cao cấp. An toàn với máy rửa chén và lò vi sóng. In màu phủ kín toàn bộ bề mặt.</p>'),('vi',4,'Tranh Treo Tường Họa Tiết Khay Trứng',NULL,'Tranh treo tường ấn tượng với họa tiết khay trứng vui nhộn trên giấy mờ chất lượng lưu trữ.','<p>Mực in chất lượng lưu trữ. Có sẵn các kích thước 12x18 và 18x24. Giấy chứng nhận FSC. Khung bán riêng.</p>'),('vi',5,'Nến In Hình',NULL,'Nến pha sáp đậu nành trong lọ thủy tinh mờ bọc bức ảnh yêu thích của bạn.','<p>Thời gian cháy 40 giờ. Có tùy chọn hương nhẹ hoặc không hương. Món quà hoàn hảo cho dịp kỷ niệm hoặc tưởng nhớ.</p>'),('vi',6,'Áo Thun Tùy Chỉnh Cao Cấp',NULL,'Áo thun 100% cotton dày dặn in hình ảnh, tranh vẽ hoặc thông điệp của bạn.','<p>Cotton sợi xoắn đã làm co trước. Có cỡ XS-3XL. In trực tiếp lên vải chống phai màu qua nhiều lần giặt.</p>'),('vi',7,'Tranh In Chân Dung Thú Cưng',NULL,'Bức chân dung thú cưng của bạn được vẽ tay, in trên giấy mờ chất lượng lưu trữ.','<p>Gửi bất kỳ bức ảnh nào và các họa sĩ của chúng tôi sẽ biến nó thành bức chân dung cách điệu. Có kích thước 8x10 và 16x20.</p>'),('vi',8,'Túi Tote Gia Đình',NULL,'Túi tote cotton 12oz siêu bền in tên viết tắt hoặc ảnh gia đình tùy chỉnh.','<p>Quai túi được gia cố, giặt máy được. Tuyệt vời cho túi đi biển, túi đi chợ hoặc túi dùng hàng ngày.</p>'),('vi',9,'Khung Ảnh Trái Tim',NULL,'Khung ảnh gỗ hình trái tim với bức ảnh đôi yêu thích của bạn in dạng mờ dịu.','<p>Gỗ sồi đạt chứng nhận FSC. Có thể đặt đứng hoặc treo tường. Vùng in ảnh 5x5.</p>'),('vi',10,'Gối Tựa Cá Nhân Hóa',NULL,'Gối tựa êm ái in hình ảnh hoặc thiết kế của bạn — mềm mại cả hai mặt.','<p>Vỏ polyester 16x16 với ruột pha lông vũ. Có thể tháo rời và giặt máy.</p>'),('vi',11,'Album Ảnh Mini',NULL,'Album ảnh bìa cứng 5x7 nhỏ gọn — lý tưởng cho những chuyến đi, đám cưới hoặc kỷ niệm tổng kết năm.','<p>Tùy chọn 20-100 trang. Giấy lụa cao cấp. Đóng gáy phẳng cho những trang ảnh trải dài không méo mó.</p>'),('vi',12,'Bộ Lót Ly Khắc Tên',NULL,'Bộ bốn lót ly bằng tre được khắc laser tên, ngày tháng hoặc tranh vẽ tùy chỉnh.','<p>Tre đạt chứng nhận FSC. Đế bần bảo vệ bề mặt. Đựng trong hộp quà giấy kraft sẵn sàng để tặng.</p>'),('vi',13,'Ốp Lưng Điện Thoại Phi Hành Gia',NULL,'Ốp lưng điện thoại mỏng đã qua kiểm định chống rơi, in hình phi hành gia tùy chỉnh kèm tên của bạn.','<p>Vỏ polycarbonate với viền TPU. Tương thích sạc không dây. Có sẵn cho các dòng iPhone và Pixel.</p>'),('vi',14,'Ốp Lưng Điện Thoại Phi Hành Gia',NULL,'Ốp lưng điện thoại mỏng đã qua kiểm định chống rơi, in hình phi hành gia tùy chỉnh kèm tên của bạn.','<p>Vỏ polycarbonate với viền TPU. Tương thích sạc không dây. Có sẵn cho các dòng iPhone và Pixel.</p>'),('vi',15,'Ốp Lưng Điện Thoại Phi Hành Gia',NULL,'Ốp lưng điện thoại mỏng đã qua kiểm định chống rơi, in hình phi hành gia tùy chỉnh kèm tên của bạn.','<p>Vỏ polycarbonate với viền TPU. Tương thích sạc không dây. Có sẵn cho các dòng iPhone và Pixel.</p>'),('vi',16,'Tranh In Chân Dung Thú Cưng',NULL,'Bức chân dung thú cưng của bạn được vẽ tay, in trên giấy mờ chất lượng lưu trữ.','<p>Gửi bất kỳ bức ảnh nào và các họa sĩ của chúng tôi sẽ biến nó thành bức chân dung cách điệu. Có kích thước 8x10 và 16x20.</p>'),('vi',17,'Tranh In Chân Dung Thú Cưng',NULL,'Bức chân dung thú cưng của bạn được vẽ tay, in trên giấy mờ chất lượng lưu trữ.','<p>Gửi bất kỳ bức ảnh nào và các họa sĩ của chúng tôi sẽ biến nó thành bức chân dung cách điệu. Có kích thước 8x10 và 16x20.</p>'),('vi',18,'Tranh In Chân Dung Thú Cưng',NULL,'Bức chân dung thú cưng của bạn được vẽ tay, in trên giấy mờ chất lượng lưu trữ.','<p>Gửi bất kỳ bức ảnh nào và các họa sĩ của chúng tôi sẽ biến nó thành bức chân dung cách điệu. Có kích thước 8x10 và 16x20.</p>'),('vi',19,'Túi Tote Gia Đình',NULL,'Túi tote cotton 12oz siêu bền in tên viết tắt hoặc ảnh gia đình tùy chỉnh.','<p>Quai túi được gia cố, giặt máy được. Tuyệt vời cho túi đi biển, túi đi chợ hoặc túi dùng hàng ngày.</p>'),('vi',20,'Túi Tote Gia Đình',NULL,'Túi tote cotton 12oz siêu bền in tên viết tắt hoặc ảnh gia đình tùy chỉnh.','<p>Quai túi được gia cố, giặt máy được. Tuyệt vời cho túi đi biển, túi đi chợ hoặc túi dùng hàng ngày.</p>'),('vi',21,'Túi Tote Gia Đình',NULL,'Túi tote cotton 12oz siêu bền in tên viết tắt hoặc ảnh gia đình tùy chỉnh.','<p>Quai túi được gia cố, giặt máy được. Tuyệt vời cho túi đi biển, túi đi chợ hoặc túi dùng hàng ngày.</p>'),('vi',22,'Túi Tote Gia Đình',NULL,'Túi tote cotton 12oz siêu bền in tên viết tắt hoặc ảnh gia đình tùy chỉnh.','<p>Quai túi được gia cố, giặt máy được. Tuyệt vời cho túi đi biển, túi đi chợ hoặc túi dùng hàng ngày.</p>'),('vi',23,'Gối Tựa Cá Nhân Hóa',NULL,'Gối tựa êm ái in hình ảnh hoặc thiết kế của bạn — mềm mại cả hai mặt.','<p>Vỏ polyester 16x16 với ruột pha lông vũ. Có thể tháo rời và giặt máy.</p>'),('vi',24,'Gối Tựa Cá Nhân Hóa',NULL,'Gối tựa êm ái in hình ảnh hoặc thiết kế của bạn — mềm mại cả hai mặt.','<p>Vỏ polyester 16x16 với ruột pha lông vũ. Có thể tháo rời và giặt máy.</p>'),('vi',25,'Gối Tựa Cá Nhân Hóa',NULL,'Gối tựa êm ái in hình ảnh hoặc thiết kế của bạn — mềm mại cả hai mặt.','<p>Vỏ polyester 16x16 với ruột pha lông vũ. Có thể tháo rời và giặt máy.</p>'),('vi',26,'Bộ Lót Ly Khắc Tên',NULL,'Bộ bốn lót ly bằng tre được khắc laser tên, ngày tháng hoặc tranh vẽ tùy chỉnh.','<p>Tre đạt chứng nhận FSC. Đế bần bảo vệ bề mặt. Đựng trong hộp quà giấy kraft sẵn sàng để tặng.</p>'),('vi',27,'Bộ Lót Ly Khắc Tên',NULL,'Bộ bốn lót ly bằng tre được khắc laser tên, ngày tháng hoặc tranh vẽ tùy chỉnh.','<p>Tre đạt chứng nhận FSC. Đế bần bảo vệ bề mặt. Đựng trong hộp quà giấy kraft sẵn sàng để tặng.</p>'),('vi',28,'Bộ Lót Ly Khắc Tên',NULL,'Bộ bốn lót ly bằng tre được khắc laser tên, ngày tháng hoặc tranh vẽ tùy chỉnh.','<p>Tre đạt chứng nhận FSC. Đế bần bảo vệ bề mặt. Đựng trong hộp quà giấy kraft sẵn sàng để tặng.</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=121 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

--
