--
-- 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,'5569BrG9zSnPgtXIbhtQwdXqqYADYgTg',1,'2026-05-28 19:09:12','2026-05-28 19:09:12','2026-05-28 19:09:12');

--
-- 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,'Pet Health',0,'Preventive care, supplements, and signs to watch for at every life stage.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2026-05-28 19:09:12','2026-05-28 19:09:12'),(2,'Nutrition',0,'Food choices, feeding schedules, and ingredients that fuel a long, healthy life.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:09:12','2026-05-28 19:09:12'),(3,'Training',0,'Positive-reinforcement training tips for puppies, kittens, and seasoned pets.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:09:12','2026-05-28 19:09:12'),(4,'Pet Lifestyle',0,'Travel, play, grooming, and the small joys of life with a four-legged friend.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:09:12','2026-05-28 19:09:12'),(5,'Vet Tips',0,'Practical advice from veterinary professionals on common questions and concerns.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2026-05-28 19:09:12','2026-05-28 19:09:12');

--
-- 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,'Santé des animaux','Soins préventifs, suppléments et signes à surveiller à chaque étape de la vie.'),('fr',2,'Nutrition','Étapes d’alimentation, de sevrage et de nutrition saine pour les bébés en pleine croissance.'),('fr',3,'Entraînement','Conseils de formation au renforcement positif pour les chiots, les chatons et les animaux adultes.'),('fr',4,'Mode de vie des animaux de compagnie','Voyager, jouer, faire sa toilette et les petits bonheurs de vivre avec un compagnon à quatre pattes.'),('fr',5,'Conseils vétérinaires','Conseils pratiques d\'experts vétérinaires sur les questions et préoccupations fréquemment posées.'),('id',1,'Kesehatan Hewan Peliharaan','Perawatan pencegahan, suplemen, dan tanda-tanda yang harus diperhatikan pada setiap tahap kehidupan.'),('id',2,'Nutrisi','Pola makan, penyapihan, dan nutrisi yang sehat merupakan tonggak sejarah bagi pertumbuhan bayi.'),('id',3,'Pelatihan','Kiat pelatihan penguatan positif untuk anak anjing, anak kucing, dan hewan peliharaan dewasa.'),('id',4,'Gaya Hidup Hewan Peliharaan','Bepergian, bermain, berdandan, dan sedikit kegembiraan hidup bersama teman berkaki empat.'),('id',5,'Tip Dokter Hewan','Nasihat praktis dari para ahli kedokteran hewan mengenai pertanyaan dan kekhawatiran yang sering diajukan.'),('tr',1,'Evcil Hayvan Sağlığı','Yaşamın her aşamasında dikkat edilmesi gereken önleyici bakım, takviyeler ve işaretler.'),('tr',2,'Beslenme','Büyüyen bebekler için yemek yeme, sütten kesme ve sağlıklı beslenme kilometre taşları.'),('tr',3,'Eğitim','Yavru köpekler, yavru kediler ve yetişkin evcil hayvanlar için olumlu takviye eğitimi ipuçları.'),('tr',4,'Evcil Hayvan Yaşam Tarzı','Seyahat etmek, oynamak, bakım yapmak ve dört ayaklı bir arkadaşla yaşamanın küçük zevkleri.'),('tr',5,'Veteriner İpuçları','Veteriner uzmanlarından sık sorulan sorular ve endişelere ilişkin pratik tavsiyeler.'),('vi',1,'Sức Khỏe Thú Cưng','Chăm sóc phòng ngừa, thực phẩm bổ sung và các dấu hiệu cần lưu ý ở mọi giai đoạn cuộc đời.'),('vi',2,'Dinh Dưỡng','Các cột mốc ăn uống, cai sữa và dinh dưỡng lành mạnh cho bé đang lớn.'),('vi',3,'Huấn Luyện','Mẹo huấn luyện bằng phương pháp củng cố tích cực cho chó con, mèo con và thú cưng đã trưởng thành.'),('vi',4,'Phong Cách Sống Cùng Thú Cưng','Du lịch, vui chơi, chăm sóc lông và những niềm vui nhỏ bé khi sống cùng người bạn bốn chân.'),('vi',5,'Lời Khuyên Từ Bác Sĩ Thú Y','Lời khuyên thiết thực từ các chuyên gia thú y về những câu hỏi và mối quan tâm thường gặp.');

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

--
-- 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:12','2026-05-28 19:09:12'),(2,'Anvouge','Modern fashion essentials cut from sustainable fibers.','https://example.com/anvouge','brands/anvouge.png','published',1,1,'2026-05-28 19:09:12','2026-05-28 19:09:12'),(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:12','2026-05-28 19:09:12'),(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:12','2026-05-28 19:09:12'),(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:12','2026-05-28 19:09:12'),(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:12','2026-05-28 19:09:12'),(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:12','2026-05-28 19:09:12'),(8,'Intdeco','Interior accents that bridge minimalism and warmth.','https://example.com/intdeco','brands/intdeco.png','published',7,0,'2026-05-28 19:09:12','2026-05-28 19:09:12'),(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:12','2026-05-28 19:09:12'),(10,'Panadoxn','Botanical skincare formulated by clinical herbalists.','https://example.com/panadoxn','brands/panadoxn.png','published',9,0,'2026-05-28 19:09:12','2026-05-28 19:09:12'),(11,'Shangxi','Heritage tea, ceramics, and meditation accessories.','https://example.com/shangxi','brands/shangxi.png','published',10,0,'2026-05-28 19:09:12','2026-05-28 19:09:12'),(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:12','2026-05-28 19:09:12');

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

--
-- 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-0101','US','Illinois','Los Angeles','147 Elm Court',1,1,'2026-05-28 19:09:22','2026-05-28 19:09:22','10001'),(2,'Emma Collins','customer@botble.com','+1-555-0106','US','California','Phoenix','369 Cherry Circle',1,0,'2026-05-28 19:09:22','2026-05-28 19:09:22','77001'),(3,'Sophia Ramirez','vendor@botble.com','+1-555-0102','AU','Illinois','Denver','258 Walnut Way',2,1,'2026-05-28 19:09:22','2026-05-28 19:09:22','33101'),(4,'Sophia Ramirez','vendor@botble.com','+1-555-0101','CA','Illinois','San Diego','123 Main Street',2,0,'2026-05-28 19:09:22','2026-05-28 19:09:22','10001'),(5,'Olivia Carter','customer1@example.com','+1-555-0109','AU','Ohio','New York','654 Cedar Lane',3,1,'2026-05-28 19:09:22','2026-05-28 19:09:22','60601'),(6,'Ava Mitchell','customer2@example.com','+1-555-0109','GB','California','Los Angeles','258 Walnut Way',4,1,'2026-05-28 19:09:22','2026-05-28 19:09:22','10001'),(7,'Isabella Brooks','customer3@example.com','+1-555-0103','CA','Texas','Dallas','147 Elm Court',5,1,'2026-05-28 19:09:22','2026-05-28 19:09:22','33101'),(8,'James Whitfield','customer4@example.com','+1-555-0103','US','Pennsylvania','New York','147 Elm Court',6,1,'2026-05-28 19:09:23','2026-05-28 19:09:23','19101'),(9,'Liam Bennett','customer5@example.com','+1-555-0108','DE','Pennsylvania','Los Angeles','123 Main Street',7,1,'2026-05-28 19:09:23','2026-05-28 19:09:23','30301'),(10,'Noah Patterson','customer6@example.com','+1-555-0108','CA','California','Miami','123 Main Street',8,1,'2026-05-28 19:09:23','2026-05-28 19:09:23','48201'),(11,'Charlotte Reed','customer7@example.com','+1-555-0106','DE','Florida','Phoenix','741 Spruce Street',9,1,'2026-05-28 19:09:23','2026-05-28 19:09:23','33101'),(12,'Amelia Foster','customer8@example.com','+1-555-0106','CA','Michigan','Los Angeles','258 Walnut Way',10,1,'2026-05-28 19:09:24','2026-05-28 19:09:24','77001');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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

INSERT INTO `ec_flash_sale_products` VALUES (1,1,27.3,50,0),(1,8,20.3,50,0),(1,5,30.8,50,0),(1,2,17.5,50,0),(1,6,34.3,50,0),(1,9,55.3,50,0),(1,3,68.6,50,0),(1,10,22.4,50,0),(1,4,23.8,50,0),(2,5,33,75,0),(2,9,59.25,75,0),(2,6,36.75,75,0),(2,1,29.25,75,0),(2,4,25.5,75,0),(2,2,18.75,75,0),(2,3,73.5,75,0),(2,8,21.75,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:09:24','published','2026-05-28 19:09:24','2026-05-28 19:09:24'),(2,'Weekend Doorbusters','2026-06-03 02:09:24','published','2026-05-28 19:09:24','2026-05-28 19:09:24');

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

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

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

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

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

INSERT INTO `ec_product_categories` VALUES (1,'Nutrition',NULL,0,'Premium kibble, wet food, and treats formulated for every life stage.','published',0,'categories/cate-6.png',1,'2026-05-28 19:09:13','2026-05-28 19:09:13',NULL,NULL),(2,'Accessories',NULL,0,'Collars, leashes, and bowls that combine durability with everyday comfort.','published',1,'categories/cate-7.png',1,'2026-05-28 19:09:14','2026-05-28 19:09:14',NULL,NULL),(3,'Apparel',NULL,0,'Soft sweaters, raincoats, and cozy layers for pets who feel the chill.','published',2,'categories/cate-8.png',1,'2026-05-28 19:09:14','2026-05-28 19:09:14',NULL,NULL),(4,'Toys',NULL,0,'Chew toys, plush companions, and enrichment puzzles that keep play meaningful.','published',3,'categories/cate-9.png',1,'2026-05-28 19:09:14','2026-05-28 19:09:14',NULL,NULL),(5,'Grooming',NULL,0,'Shampoos, brushes, and tools that keep coats clean and skin healthy.','published',4,'categories/cate-10.png',1,'2026-05-28 19:09:15','2026-05-28 19:09:15',NULL,NULL),(6,'Health & Wellness',NULL,0,'Supplements, dental care, and calming aids backed by veterinary research.','published',5,'categories/cate-11.png',1,'2026-05-28 19:09:15','2026-05-28 19:09:15',NULL,NULL),(7,'Travel',NULL,0,'Carriers, harnesses, and travel essentials for stress-free adventures.','published',6,'categories/cate-12.png',1,'2026-05-28 19:09:15','2026-05-28 19:09:15',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,'حقائب الحمل والأحزمة ومعدات السفر لرحلات خالية من التوتر.'),('fr',1,'Nutrition',NULL,'Des granulés, des aliments humides et des friandises de qualité supérieure sont formulés pour chaque étape de la vie.'),('fr',2,'Accessoires',NULL,'Sacs à main, portefeuilles, ceintures et bijoux pour compléter n\'importe quelle tenue.'),('fr',3,'Vêtements',NULL,'Pulls doux, imperméables et couches chaudes pour les animaux qui ont facilement froid.'),('fr',4,'Jouets',NULL,'Les friandises, les compagnons en peluche et les puzzles rendent le temps de jeu plus significatif.'),('fr',5,'Toilettage',NULL,'Les shampooings, brosses et outils gardent le pelage propre et la peau saine.'),('fr',6,'Santé et bien-être',NULL,'Les compléments alimentaires, les soins bucco-dentaires et les produits apaisants sont soutenus par la recherche vétérinaire.'),('fr',7,'Voyage',NULL,'Sacs de transport, harnais et matériel de voyage pour des voyages sans stress.'),('id',1,'Nutrisi',NULL,'Butiran premium, makanan basah, dan camilan diformulasikan untuk setiap tahap kehidupan.'),('id',2,'Aksesoris',NULL,'Tas tangan, dompet, ikat pinggang, dan perhiasan untuk melengkapi pakaian apa pun.'),('id',3,'Pakaian',NULL,'Sweater lembut, jas hujan, dan lapisan hangat untuk hewan peliharaan yang mudah kedinginan.'),('id',4,'Mainan',NULL,'Permen kunyah, boneka teman, dan teka-teki membuat waktu bermain lebih bermakna.'),('id',5,'Perawatan diri',NULL,'Sampo, sikat, dan peralatan menjaga bulu tetap bersih dan kulit tetap sehat.'),('id',6,'Kesehatan & Kebugaran',NULL,'Suplemen makanan, perawatan mulut, dan produk penenang didukung oleh penelitian dokter hewan.'),('id',7,'Bepergian',NULL,'Tas jinjing, tali pengaman, dan perlengkapan perjalanan untuk perjalanan bebas stres.'),('tr',1,'Beslenme',NULL,'Birinci sınıf granüller, ıslak gıdalar ve ikramlar her yaşam aşaması için formüle edilmiştir.'),('tr',2,'Aksesuarlar',NULL,'Her türlü kıyafeti tamamlayacak çantalar, cüzdanlar, kemerler ve takılar.'),('tr',3,'Giyim',NULL,'Kolayca üşüyen evcil hayvanlar için yumuşak kazaklar, yağmurluklar ve sıcak tutan katmanlar.'),('tr',4,'Oyuncaklar',NULL,'Çiğnemeler, doldurulmuş oyuncaklar ve bulmacalar oyun süresini daha anlamlı hale getirir.'),('tr',5,'bakım',NULL,'Şampuanlar, fırçalar ve aletler tüyleri temiz ve cildi sağlıklı tutar.'),('tr',6,'Sağlık ve Sağlıklı Yaşam',NULL,'Diyet takviyeleri, ağız bakımı ve yatıştırıcı ürünler veteriner araştırmalarıyla desteklenmektedir.'),('tr',7,'Seyahat',NULL,'Stressiz yolculuklar için taşıma çantaları, koşum takımları ve seyahat malzemeleri.'),('vi',1,'Dinh Dưỡng',NULL,'Hạt cao cấp, thức ăn ướt và bánh thưởng được bào chế cho mọi giai đoạn cuộc đời.'),('vi',2,'Phụ kiện',NULL,'Túi xách, ví, thắt lưng và trang sức để hoàn thiện mọi outfit.'),('vi',3,'Trang Phục',NULL,'Áo len mềm mại, áo mưa và những lớp áo ấm áp cho thú cưng dễ bị lạnh.'),('vi',4,'Đồ Chơi',NULL,'Đồ gặm, bạn đồng hành nhồi bông và trò chơi giải đố giúp giờ chơi thêm ý nghĩa.'),('vi',5,'Chăm Sóc Lông',NULL,'Sữa tắm, lược chải và dụng cụ giữ cho bộ lông sạch sẽ và làn da khỏe mạnh.'),('vi',6,'Sức Khỏe & Thể Trạng',NULL,'Thực phẩm bổ sung, chăm sóc răng miệng và sản phẩm làm dịu được hỗ trợ bởi nghiên cứu thú y.'),('vi',7,'Du Lịch',NULL,'Túi vận chuyển, đai yếm và đồ dùng du lịch cho những chuyến đi không lo căng thẳng.');

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

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

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


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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `ec_product_collections` VALUES (1,'Everything Your Pet Deserves','everything-your-pet-deserves','Experience true wireless sound with deep bass, crystal clarity.','section/banner-15.jpg','published','2026-05-28 19:09:16','2026-05-28 19:09:16',1),(2,'Cat Feast','cat-feast','Healthy, tasty meals for cats','collection/cls-18.jpg','published','2026-05-28 19:09:16','2026-05-28 19:09:16',1),(3,'Pet Fashion','pet-fashion','Cute outfits for every pet','collection/cls-17.jpg','published','2026-05-28 19:09:16','2026-05-28 19:09:16',1),(4,'Toy &amp; Playtime','toy-playtime','Durable toys built for tug, fetch, and pounce — in every size.','collection/cls-10.jpg','published','2026-05-28 19:09:16','2026-05-28 19:09:16',1),(5,'Grooming &amp; Care','grooming-care','Shampoos, brushes, and nail kits for at-home grooming made easy.','collection/cls-11.jpg','published','2026-05-28 19:09:16','2026-05-28 19:09:16',0),(6,'Treats &amp; Snacks','treats-snacks','Reward-worthy treats your pets will sit, stay, and beg for.','collection/cls-12.jpg','published','2026-05-28 19:09:16','2026-05-28 19:09:16',0),(7,'Pet Health Hub','pet-health-hub','Vitamins, dental care, and wellness picks recommended by vets.','collection/cls-13.jpg','published','2026-05-28 19:09:16','2026-05-28 19:09:16',0),(8,'Travel &amp; Outdoor','travel-outdoor','Carriers, leashes, and harnesses for adventures big and small.','collection/cls-14.jpg','published','2026-05-28 19:09:16','2026-05-28 19:09:16',0),(9,'Small Pets &amp; Birds','small-pets-birds','Cozy habitats and nutrition for hamsters, rabbits, birds, and more.','collection/cls-15.jpg','published','2026-05-28 19:09:16','2026-05-28 19:09:16',0);

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

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

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

INSERT INTO `ec_product_collections_translations` VALUES ('ar',1,'كل ما يستحقه حيوانك الأليف','استمتع بتجربة صوت لاسلكي حقيقي مع صوت جهير عميق ووضوح مذهل.'),('ar',2,'عيد القطط','وجبات صحية ولذيذة للقطط.'),('ar',3,'أزياء الحيوانات الأليفة','ملابس رائعتين لكل حيوان أليف.'),('ar',4,'Toy &amp; Playtime','Durable toys built for tug, fetch, and pounce — in every size.'),('ar',5,'Grooming &amp; Care','Shampoos, brushes, and nail kits for at-home grooming made easy.'),('ar',6,'Treats &amp; Snacks','Reward-worthy treats your pets will sit, stay, and beg for.'),('ar',7,'مركز صحة الحيوانات الأليفة','ينصح الطبيب البيطري بالفيتامينات والعناية بالأسنان ومنتجات الصحة.'),('ar',8,'Travel &amp; Outdoor','Carriers, leashes, and harnesses for adventures big and small.'),('ar',9,'Small Pets &amp; Birds','Cozy habitats and nutrition for hamsters, rabbits, birds, and more.'),('fr',1,'Tout ce que votre animal mérite','Découvrez un véritable son sans fil avec des basses profondes et une clarté époustouflante.'),('fr',2,'Fête du chat','Repas sains et délicieux pour chats.'),('fr',3,'Mode pour animaux de compagnie','Des tenues adorables pour chaque animal de compagnie.'),('fr',4,'Toy &amp; Playtime','Durable toys built for tug, fetch, and pounce — in every size.'),('fr',5,'Grooming &amp; Care','Shampoos, brushes, and nail kits for at-home grooming made easy.'),('fr',6,'Treats &amp; Snacks','Reward-worthy treats your pets will sit, stay, and beg for.'),('fr',7,'Centre de santé des animaux de compagnie','Vitamines, soins dentaires et produits de bien-être vous sont recommandés par votre vétérinaire.'),('fr',8,'Travel &amp; Outdoor','Carriers, leashes, and harnesses for adventures big and small.'),('fr',9,'Small Pets &amp; Birds','Cozy habitats and nutrition for hamsters, rabbits, birds, and more.'),('id',1,'Segala yang Layak untuk Hewan Peliharaan Anda','Nikmati audio nirkabel sesungguhnya dengan bass yang dalam dan kejernihan menakjubkan.'),('id',2,'Pesta Kucing','Makanan sehat dan lezat untuk kucing.'),('id',3,'Mode Hewan Peliharaan','Pakaian menggemaskan untuk setiap hewan peliharaan.'),('id',4,'Toy &amp; Playtime','Durable toys built for tug, fetch, and pounce — in every size.'),('id',5,'Grooming &amp; Care','Shampoos, brushes, and nail kits for at-home grooming made easy.'),('id',6,'Treats &amp; Snacks','Reward-worthy treats your pets will sit, stay, and beg for.'),('id',7,'Pusat Kesehatan Hewan Peliharaan','Vitamin, perawatan gigi, dan produk kesehatan direkomendasikan oleh dokter hewan Anda.'),('id',8,'Travel &amp; Outdoor','Carriers, leashes, and harnesses for adventures big and small.'),('id',9,'Small Pets &amp; Birds','Cozy habitats and nutrition for hamsters, rabbits, birds, and more.'),('tr',1,'Evcil Hayvanınızın Hak Ettiği Herşey','Derin bas ve çarpıcı netlikle gerçek kablosuz sesi deneyimleyin.'),('tr',2,'Kedi Bayramı','Kediler için sağlıklı, lezzetli yemekler.'),('tr',3,'Evcil Hayvan Modası','Her evcil hayvan için sevimli kıyafetler.'),('tr',4,'Toy &amp; Playtime','Durable toys built for tug, fetch, and pounce — in every size.'),('tr',5,'Grooming &amp; Care','Shampoos, brushes, and nail kits for at-home grooming made easy.'),('tr',6,'Treats &amp; Snacks','Reward-worthy treats your pets will sit, stay, and beg for.'),('tr',7,'Evcil Hayvan Sağlığı Merkezi','Vitaminler, diş bakımı ve sağlıklı yaşam ürünleri veteriner hekiminiz tarafından tavsiye edilmektedir.'),('tr',8,'Travel &amp; Outdoor','Carriers, leashes, and harnesses for adventures big and small.'),('tr',9,'Small Pets &amp; Birds','Cozy habitats and nutrition for hamsters, rabbits, birds, and more.'),('vi',1,'Tất Cả Những Gì Thú Cưng Của Bạn Xứng Đáng','Trải nghiệm âm thanh không dây thực thụ với âm trầm sâu lắng và độ trong trẻo tuyệt vời.'),('vi',2,'Bữa Tiệc Cho Mèo','Những bữa ăn lành mạnh, ngon miệng dành cho mèo.'),('vi',3,'Thời Trang Thú Cưng','Những bộ trang phục đáng yêu cho mọi thú cưng.'),('vi',4,'Toy &amp; Playtime','Durable toys built for tug, fetch, and pounce — in every size.'),('vi',5,'Grooming &amp; Care','Shampoos, brushes, and nail kits for at-home grooming made easy.'),('vi',6,'Treats &amp; Snacks','Reward-worthy treats your pets will sit, stay, and beg for.'),('vi',7,'Trung Tâm Sức Khỏe Thú Cưng','Vitamin, chăm sóc răng miệng và các sản phẩm thể trạng được bác sĩ thú y khuyên dùng.'),('vi',8,'Travel &amp; Outdoor','Carriers, leashes, and harnesses for adventures big and small.'),('vi',9,'Small Pets &amp; Birds','Cozy habitats and nutrition for hamsters, rabbits, birds, and more.');

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

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

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

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


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

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

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

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

--
-- 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:12','2026-05-28 19:09:12'),(2,'Linen','Products tagged with Linen.',NULL,'published','2026-05-28 19:09:12','2026-05-28 19:09:12'),(3,'Wool','Products tagged with Wool.',NULL,'published','2026-05-28 19:09:12','2026-05-28 19:09:12'),(4,'Leather','Products tagged with Leather.',NULL,'published','2026-05-28 19:09:12','2026-05-28 19:09:12'),(5,'Tencel','Products tagged with Tencel.',NULL,'published','2026-05-28 19:09:12','2026-05-28 19:09:12'),(6,'Recycled','Products tagged with Recycled.',NULL,'published','2026-05-28 19:09:12','2026-05-28 19:09:12'),(7,'Made in Portugal','Products tagged with Made in Portugal.',NULL,'published','2026-05-28 19:09:12','2026-05-28 19:09:12'),(8,'Made in Italy','Products tagged with Made in Italy.',NULL,'published','2026-05-28 19:09:12','2026-05-28 19:09:12'),(9,'Hand-Crafted','Products tagged with Hand-Crafted.',NULL,'published','2026-05-28 19:09:12','2026-05-28 19:09:12'),(10,'Vegan','Products tagged with Vegan.',NULL,'published','2026-05-28 19:09:12','2026-05-28 19:09:12'),(11,'Limited Run','Products tagged with Limited Run.',NULL,'published','2026-05-28 19:09:12','2026-05-28 19:09:12'),(12,'Best Seller','Products tagged with Best Seller.',NULL,'published','2026-05-28 19:09:12','2026-05-28 19:09:12'),(13,'New Arrival','Products tagged with New Arrival.',NULL,'published','2026-05-28 19:09:12','2026-05-28 19:09:12'),(14,'Editor Pick','Products tagged with Editor Pick.',NULL,'published','2026-05-28 19:09:12','2026-05-28 19:09:12'),(15,'Eco-Friendly','Products tagged with Eco-Friendly.',NULL,'published','2026-05-28 19:09:12','2026-05-28 19:09:12');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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

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

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

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

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

INSERT INTO `ec_products` VALUES (1,'Premium Cat Food','premium-cat-food','Grain-free dry food with real salmon as the first ingredient and added taurine.','<p>Formulated for adult indoor cats. Crude protein 38% min. Resealable 2.5kg bag. No artificial colors or preservatives.</p>','published','[\"products\\/pet\\/product-1.jpg\"]',NULL,'QV-196-A1',0,10,0,1,'in_stock',1,NULL,12,0,4,10,3.30,0,39.99,29.99,NULL,NULL,17,17,17,742,NULL,'standard',113104,'2026-05-28 19:09:18','2026-05-28 19:09:26',1,0,'Botble\\ACL\\Models\\User',0,'products/pet/product-1.jpg','physical','8417959261192',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(2,'Dog Chew Toy','dog-chew-toy','Heavy-duty rubber chew that bounces, floats, and stands up to power chewers.','<p>Non-toxic natural rubber. Dishwasher safe. Hollow centre stuffs with treats or peanut butter. Sized small through XL.</p>','published','[\"products\\/pet\\/product-2.jpg\"]',NULL,'GF-115-A1',0,11,0,1,'in_stock',1,NULL,9,0,2,10,3.00,0,25,18.99,NULL,NULL,20,10,16,555,NULL,'standard',8183,'2026-05-28 19:09:18','2026-05-28 19:09:26',2,0,'Botble\\ACL\\Models\\User',0,'products/pet/product-2.jpg','physical','9305332927799',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(3,'Hammock Cat Tower Grey','hammock-cat-tower-grey','Three-level cat tower with sisal scratching posts and a cozy plush hideaway. Built from solid pine with a soft plush hammock perch and a removable cushion.','<p>Particle-board core wrapped in soft plush. 110cm tall with replaceable sisal posts. Easy assembly with included tool.</p>','published','[\"products\\/pet\\/product-3.jpg\"]',NULL,'CJ-174-A1',0,16,0,1,'in_stock',0,NULL,4,0,5,10,3.10,0,98.99,79.99,NULL,NULL,12,20,16,736,NULL,'standard',51472,'2026-05-28 19:09:18','2026-05-28 19:09:26',3,0,'Botble\\ACL\\Models\\User',0,'products/pet/product-3.jpg','physical','5181704948876',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(4,'Allergy Relief Drops','allergy-relief-drops','Vet-formulated liquid drops with omega-3s and quercetin for itchy, sensitive pets.','<p>Easy-dose dropper. Add to food or water. Suitable for cats and dogs over 6 months. 60ml bottle.</p>','published','[\"products\\/pet\\/product-4.jpg\"]',NULL,'Q8-185',0,19,0,1,'in_stock',0,NULL,9,0,0,10,3.50,0,34.99,26.99,NULL,NULL,14,13,11,641,NULL,'standard',39815,'2026-05-28 19:09:19','2026-05-28 19:09:26',4,0,'Botble\\ACL\\Models\\User',0,'products/pet/product-4.jpg','physical','3027723669670',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(5,'Vitality Supplements','vitality-supplements','Daily multivitamin chews with glucosamine, omega-3, and probiotics for active dogs.','<p>Beef-flavored soft chews. 90 chews per tub. Supports joints, coat, and digestion. Made in vet-audited facility.</p>','published','[\"products\\/pet\\/product-5.jpg\"]',NULL,'OV-115-A1',0,16,0,1,'in_stock',0,NULL,1,0,3,10,3.00,0,44.99,32.99,NULL,NULL,16,15,16,716,NULL,'standard',3517,'2026-05-28 19:09:19','2026-05-28 19:09:26',1,0,'Botble\\ACL\\Models\\User',0,'products/pet/product-5.jpg','physical','9124470638516',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(6,'Dog Harness','dog-harness','Padded no-pull harness with reflective trim and twin leash attachment points.','<p>Breathable mesh padding. Adjustable five-point fit. Sizes XS-XL. Hand-wash cold.</p>','published','[\"products\\/pet\\/product-6.jpg\"]',NULL,'6J-135',0,11,0,1,'in_stock',1,NULL,1,0,0,10,3.00,0,49.99,39.99,NULL,NULL,15,19,17,677,NULL,'standard',192180,'2026-05-28 19:09:19','2026-05-28 19:09:26',2,0,'Botble\\ACL\\Models\\User',0,'products/pet/product-6.jpg','physical','8578714265418',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(7,'Cat Scratching Post','cat-scratching-post','Solid-base sisal scratching post sized for full-stretch scratching.','<p>70cm tall with weighted MDF base for stability. Replaceable sisal column. Includes a hanging feather toy.</p>','published','[\"products\\/pet\\/product-7.jpg\"]',NULL,'D7-133-A1',0,17,0,1,'in_stock',1,NULL,10,0,4,10,2.90,0,39.99,29.99,NULL,NULL,16,13,14,665,NULL,'standard',157528,'2026-05-28 19:09:19','2026-05-28 19:09:26',3,0,'Botble\\ACL\\Models\\User',0,'products/pet/product-7.jpg','physical','6216964984995',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(8,'Pet Shampoo','pet-shampoo','Oatmeal and aloe shampoo that cleans without stripping natural oils.','<p>pH-balanced for cats and dogs. Soap-free. Coconut-derived surfactants. 500ml bottle. Cruelty-free.</p>','published','[\"products\\/pet\\/product-8.jpg\"]',NULL,'NS-167',0,12,0,1,'in_stock',0,NULL,5,0,0,10,2.80,0,29.99,22.99,NULL,NULL,19,10,20,808,NULL,'standard',194371,'2026-05-28 19:09:19','2026-05-28 19:09:26',4,0,'Botble\\ACL\\Models\\User',0,'products/pet/product-8.jpg','physical','2751272959371',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(9,'Cozy Dog Bed','cozy-dog-bed','Memory-foam orthopedic bed with a removable, machine-washable cover.','<p>High-density foam supports senior joints. Sherpa fleece cover. Sizes M-XL. Non-slip base.</p>','published','[\"products\\/pet\\/product-9.jpg\"]',NULL,'HW-118-A1',0,11,0,1,'in_stock',0,NULL,11,0,2,10,2.80,0,79.99,64.99,NULL,NULL,12,11,20,789,NULL,'standard',142086,'2026-05-28 19:09:19','2026-05-28 19:09:26',1,0,'Botble\\ACL\\Models\\User',0,'products/pet/product-9.jpg','physical','5382830856862',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(10,'Calming Treats','calming-treats','Soft chew treats with chamomile and L-theanine for stressful events.','<p>Drug-free formula. 60 treats per bag. Use during travel, storms, or vet visits. Suitable for dogs over 12 weeks.</p>','published','[\"products\\/pet\\/product-10.jpg\"]',NULL,'LR-187',0,16,0,1,'in_stock',0,NULL,1,0,0,10,2.80,0,32.99,24.99,NULL,NULL,16,18,16,840,NULL,'standard',168489,'2026-05-28 19:09:19','2026-05-28 19:09:26',2,0,'Botble\\ACL\\Models\\User',0,'products/pet/product-10.jpg','physical','9730184954486',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(11,'Premium Cat Food',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-1.jpg\"]',NULL,'QV-196-A1',0,10,0,1,'in_stock',0,NULL,12,1,0,0,0.00,0,39.99,NULL,NULL,NULL,17,17,17,742,NULL,'standard',0,'2026-05-28 19:09:19','2026-05-28 19:09:26',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8776211832113',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(12,'Premium Cat Food',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-1.jpg\"]',NULL,'QV-196-A1-A2',0,10,0,1,'in_stock',0,NULL,12,1,0,0,0.00,0,39.99,NULL,NULL,NULL,17,17,17,742,NULL,'standard',0,'2026-05-28 19:09:19','2026-05-28 19:09:26',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6338195644032',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(13,'Premium Cat Food',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-1.jpg\"]',NULL,'QV-196-A1-A3',0,10,0,1,'in_stock',0,NULL,12,1,0,0,0.00,0,39.99,NULL,NULL,NULL,17,17,17,742,NULL,'standard',0,'2026-05-28 19:09:19','2026-05-28 19:09:26',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6663575863544',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(14,'Premium Cat Food',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-1.jpg\"]',NULL,'QV-196-A1-A4',0,10,0,1,'in_stock',0,NULL,12,1,0,0,0.00,0,39.99,NULL,NULL,NULL,17,17,17,742,NULL,'standard',0,'2026-05-28 19:09:19','2026-05-28 19:09:26',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5024150772278',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(15,'Dog Chew Toy',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-2.jpg\"]',NULL,'GF-115-A1',0,11,0,1,'in_stock',0,NULL,9,1,0,0,0.00,0,25,NULL,NULL,NULL,20,10,16,555,NULL,'standard',0,'2026-05-28 19:09:20','2026-05-28 19:09:26',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','6428086658887',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(16,'Dog Chew Toy',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-2.jpg\"]',NULL,'GF-115-A1-A2',0,11,0,1,'in_stock',0,NULL,9,1,0,0,0.00,0,25,NULL,NULL,NULL,20,10,16,555,NULL,'standard',0,'2026-05-28 19:09:20','2026-05-28 19:09:26',2,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','7726196279541',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(17,'Hammock Cat Tower Grey',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-3.jpg\"]',NULL,'CJ-174-A1',0,16,0,1,'in_stock',0,NULL,4,1,0,0,0.00,0,98.99,NULL,NULL,NULL,12,20,16,736,NULL,'standard',0,'2026-05-28 19:09:20','2026-05-28 19:09:26',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5641651890531',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(18,'Hammock Cat Tower Grey',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-3.jpg\"]',NULL,'CJ-174-A1-A2',0,16,0,1,'in_stock',0,NULL,4,1,0,0,0.00,0,98.99,NULL,NULL,NULL,12,20,16,736,NULL,'standard',0,'2026-05-28 19:09:20','2026-05-28 19:09:26',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','0607739951377',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(19,'Hammock Cat Tower Grey',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-3.jpg\"]',NULL,'CJ-174-A1-A3',0,16,0,1,'in_stock',0,NULL,4,1,0,0,0.00,0,98.99,NULL,NULL,NULL,12,20,16,736,NULL,'standard',0,'2026-05-28 19:09:20','2026-05-28 19:09:26',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5496263051500',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(20,'Hammock Cat Tower Grey',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-3.jpg\"]',NULL,'CJ-174-A1-A4',0,16,0,1,'in_stock',0,NULL,4,1,0,0,0.00,0,98.99,NULL,NULL,NULL,12,20,16,736,NULL,'standard',0,'2026-05-28 19:09:20','2026-05-28 19:09:26',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8920164990912',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(21,'Hammock Cat Tower Grey',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-3.jpg\"]',NULL,'CJ-174-A1-A5',0,16,0,1,'in_stock',0,NULL,4,1,0,0,0.00,0,98.99,NULL,NULL,NULL,12,20,16,736,NULL,'standard',0,'2026-05-28 19:09:20','2026-05-28 19:09:26',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','1287251447528',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(22,'Vitality Supplements',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-5.jpg\"]',NULL,'OV-115-A1',0,16,0,1,'in_stock',0,NULL,1,1,0,0,0.00,0,44.99,NULL,NULL,NULL,16,15,16,716,NULL,'standard',0,'2026-05-28 19:09:20','2026-05-28 19:09:26',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2557999886132',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(23,'Vitality Supplements',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-5.jpg\"]',NULL,'OV-115-A1-A2',0,16,0,1,'in_stock',0,NULL,1,1,0,0,0.00,0,44.99,NULL,NULL,NULL,16,15,16,716,NULL,'standard',0,'2026-05-28 19:09:20','2026-05-28 19:09:26',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','9085399998788',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(24,'Vitality Supplements',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-5.jpg\"]',NULL,'OV-115-A1-A3',0,16,0,1,'in_stock',0,NULL,1,1,0,0,0.00,0,44.99,NULL,NULL,NULL,16,15,16,716,NULL,'standard',0,'2026-05-28 19:09:20','2026-05-28 19:09:26',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5709460852864',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(25,'Cat Scratching Post',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-7.jpg\"]',NULL,'D7-133-A1',0,17,0,1,'in_stock',0,NULL,10,1,0,0,0.00,0,39.99,NULL,NULL,NULL,16,13,14,665,NULL,'standard',0,'2026-05-28 19:09:20','2026-05-28 19:09:26',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','2835826407577',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(26,'Cat Scratching Post',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-7.jpg\"]',NULL,'D7-133-A1-A2',0,17,0,1,'in_stock',0,NULL,10,1,0,0,0.00,0,39.99,NULL,NULL,NULL,16,13,14,665,NULL,'standard',0,'2026-05-28 19:09:20','2026-05-28 19:09:26',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','7662562270609',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(27,'Cat Scratching Post',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-7.jpg\"]',NULL,'D7-133-A1-A3',0,17,0,1,'in_stock',0,NULL,10,1,0,0,0.00,0,39.99,NULL,NULL,NULL,16,13,14,665,NULL,'standard',0,'2026-05-28 19:09:20','2026-05-28 19:09:26',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','8858346501765',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(28,'Cat Scratching Post',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-7.jpg\"]',NULL,'D7-133-A1-A4',0,17,0,1,'in_stock',0,NULL,10,1,0,0,0.00,0,39.99,NULL,NULL,NULL,16,13,14,665,NULL,'standard',0,'2026-05-28 19:09:21','2026-05-28 19:09:26',3,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','5899635715855',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(29,'Cozy Dog Bed',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-9.jpg\"]',NULL,'HW-118-A1',0,11,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,79.99,NULL,NULL,NULL,12,11,20,789,NULL,'standard',0,'2026-05-28 19:09:21','2026-05-28 19:09:26',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','0068857195928',NULL,NULL,0,0,'auto_generate',0,0,0,NULL),(30,'Cozy Dog Bed',NULL,NULL,NULL,'published','[\"products\\/pet\\/product-9.jpg\"]',NULL,'HW-118-A1-A2',0,11,0,1,'in_stock',0,NULL,11,1,0,0,0.00,0,79.99,NULL,NULL,NULL,12,11,20,789,NULL,'standard',0,'2026-05-28 19:09:21','2026-05-28 19:09:26',1,0,'Botble\\ACL\\Models\\User',0,NULL,'physical','4571253249349',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>صيغة للقطط المنزلية البالغة. الحد الأدنى من البروتين الخام 38%. حقيبة بوزن 2.5 كجم مع قفل بسحاب مناسب. لا يوجد ألوان صناعية أو مواد حافظة.</p>'),('ar',2,'لعبة مضغ الكلب',NULL,'يمكن للمضغ المطاطي فائق المتانة أن يرتد ويطفو على الماء ويتحمل المضغ القوي من قبل الكلاب.','<p> المطاط الطبيعي غير سام. آمن للغسيل في الغسالة. يمكن حشو اللب المجوف بالوجبات الخفيفة أو زبدة الفول السوداني. متوفر بمقاسات من صغير إلى XL.</p>'),('ar',3,'أرجوحة برج القط الرمادي',NULL,'عمود تسلق للقطط ثلاثي الطبقات مع عمود خدش من حبل السيزال ومنطقة استراحة قطيفة. مصنوعة من خشب الصنوبر الصلب مع أرجوحة مخملية ناعمة ووسادة قابلة للإزالة.','<p> قلب لوح الجسيمات مغطى بقماش مخملي ناعم. ارتفاع 110 سم مع عمود سيزال قابل للاستبدال. سهولة التجميع باستخدام الأدوات المضمنة.</p>'),('ar',4,'قطرات تخفيف الحساسية',NULL,'قطرات تركيبة بيطرية تحتوي على أوميغا 3 وكيرسيتين للحيوانات الأليفة التي تسبب الحكة والحساسة.','<p> قطارة سهلة الجرعات. أضف إلى الطعام أو الشراب. مناسب للكلاب والقطط فوق عمر 6 أشهر. زجاجة سعة 60 مل.</p>'),('ar',5,'مكملات الحيوية',NULL,'مضغ الفيتامينات اليومية مع الجلوكوزامين والأوميغا 3 والبروبيوتيك للكلاب النشطة.','<p> أقراص طرية قابلة للمضغ بنكهة لحم البقر. 90 حبة لكل علبة. يدعم المفاصل والشعر والهضم. تم تصنيعه في منشأة يتم فحصها بواسطة طبيب بيطري.</p>'),('ar',6,'تسخير الكلب',NULL,'حزام مبطن مضاد للارتداد مع زخرفة عاكسة ونقطتي ربط للمقود.','<p> وسادة شبكية قابلة للتنفس. تعديل من خمس نقاط لملاءمة محكمة. متوفر بمقاسات XS-XL. يُغسل يدويًا بالماء البارد.</p>'),('ar',7,'عمود خدش القطط',NULL,'يحتوي عمود الخدش المصنوع من سلك السيزال على قاعدة متينة وحجم مناسب للقطط للخدش بشكل مريح.','<p>70 سم طول مع قاعدة MDF مرجحة لتحقيق الثبات. عمود السيزال قابل للاستبدال. تأتي مع لعبة ريشة معلقة.</p>'),('ar',8,'شامبو الحيوانات الأليفة',NULL,'جل الاستحمام بالشوفان والصبار ينظف البشرة دون إزالة الزيوت الطبيعية.','<p> يوازن درجة الحموضة للكلاب والقطط. لا يحتوي على صابون. السطحي المستخرج من جوز الهند. زجاجة 500 مل. لم يتم اختباره على الحيوانات.</p>'),('ar',9,'سرير كلب مريح',NULL,'مرتبة لتقويم العظام من الإسفنج الذكي مع غطاء قابل للإزالة والغسل في الغسالة.','<p> رغوة عالية الكثافة تدعم مفاصل الحيوانات الأليفة الأكبر سنًا. غطاء من صوف الشيربا. متوفر بمقاسات M-XL. نعل مضاد للانزلاق.</p>'),('ar',10,'يعامل تهدئة',NULL,'علاج مضغ ناعم مع البابونج وإل-ثيانين في المواقف العصيبة.','<p>الصيغة لا تحتوي على أدوية. 60 حبة لكل كيس. استخدم عند السفر أو العواصف أو الذهاب إلى العيادة البيطرية. مناسب للكلاب التي يزيد عمرها عن 12 أسبوعًا.</p>'),('ar',11,'طعام قطط فاخر',NULL,'طعام جاف خالي من الحبوب مع سمك السلمون الحقيقي كعنصر أول وإضافة التورين.','<p>صيغة للقطط المنزلية البالغة. الحد الأدنى من البروتين الخام 38%. حقيبة بوزن 2.5 كجم مع قفل بسحاب مناسب. لا يوجد ألوان صناعية أو مواد حافظة.</p>'),('ar',12,'طعام قطط فاخر',NULL,'طعام جاف خالي من الحبوب مع سمك السلمون الحقيقي كعنصر أول وإضافة التورين.','<p>صيغة للقطط المنزلية البالغة. الحد الأدنى من البروتين الخام 38%. حقيبة بوزن 2.5 كجم مع قفل بسحاب مناسب. لا يوجد ألوان صناعية أو مواد حافظة.</p>'),('ar',13,'طعام قطط فاخر',NULL,'طعام جاف خالي من الحبوب مع سمك السلمون الحقيقي كعنصر أول وإضافة التورين.','<p>صيغة للقطط المنزلية البالغة. الحد الأدنى من البروتين الخام 38%. حقيبة بوزن 2.5 كجم مع قفل بسحاب مناسب. لا يوجد ألوان صناعية أو مواد حافظة.</p>'),('ar',14,'طعام قطط فاخر',NULL,'طعام جاف خالي من الحبوب مع سمك السلمون الحقيقي كعنصر أول وإضافة التورين.','<p>صيغة للقطط المنزلية البالغة. الحد الأدنى من البروتين الخام 38%. حقيبة بوزن 2.5 كجم مع قفل بسحاب مناسب. لا يوجد ألوان صناعية أو مواد حافظة.</p>'),('ar',15,'لعبة مضغ الكلب',NULL,'يمكن للمضغ المطاطي فائق المتانة أن يرتد ويطفو على الماء ويتحمل المضغ القوي من قبل الكلاب.','<p> المطاط الطبيعي غير سام. آمن للغسيل في الغسالة. يمكن حشو اللب المجوف بالوجبات الخفيفة أو زبدة الفول السوداني. متوفر بمقاسات من صغير إلى XL.</p>'),('ar',16,'لعبة مضغ الكلب',NULL,'يمكن للمضغ المطاطي فائق المتانة أن يرتد ويطفو على الماء ويتحمل المضغ القوي من قبل الكلاب.','<p> المطاط الطبيعي غير سام. آمن للغسيل في الغسالة. يمكن حشو اللب المجوف بالوجبات الخفيفة أو زبدة الفول السوداني. متوفر بمقاسات من صغير إلى XL.</p>'),('ar',17,'أرجوحة برج القط الرمادي',NULL,'عمود تسلق للقطط ثلاثي الطبقات مع عمود خدش من حبل السيزال ومنطقة استراحة قطيفة. مصنوعة من خشب الصنوبر الصلب مع أرجوحة مخملية ناعمة ووسادة قابلة للإزالة.','<p> قلب لوح الجسيمات مغطى بقماش مخملي ناعم. ارتفاع 110 سم مع عمود سيزال قابل للاستبدال. سهولة التجميع باستخدام الأدوات المضمنة.</p>'),('ar',18,'أرجوحة برج القط الرمادي',NULL,'عمود تسلق للقطط ثلاثي الطبقات مع عمود خدش من حبل السيزال ومنطقة استراحة قطيفة. مصنوعة من خشب الصنوبر الصلب مع أرجوحة مخملية ناعمة ووسادة قابلة للإزالة.','<p> قلب لوح الجسيمات مغطى بقماش مخملي ناعم. ارتفاع 110 سم مع عمود سيزال قابل للاستبدال. سهولة التجميع باستخدام الأدوات المضمنة.</p>'),('ar',19,'أرجوحة برج القط الرمادي',NULL,'عمود تسلق للقطط ثلاثي الطبقات مع عمود خدش من حبل السيزال ومنطقة استراحة قطيفة. مصنوعة من خشب الصنوبر الصلب مع أرجوحة مخملية ناعمة ووسادة قابلة للإزالة.','<p> قلب لوح الجسيمات مغطى بقماش مخملي ناعم. ارتفاع 110 سم مع عمود سيزال قابل للاستبدال. سهولة التجميع باستخدام الأدوات المضمنة.</p>'),('ar',20,'أرجوحة برج القط الرمادي',NULL,'عمود تسلق للقطط ثلاثي الطبقات مع عمود خدش من حبل السيزال ومنطقة استراحة قطيفة. مصنوعة من خشب الصنوبر الصلب مع أرجوحة مخملية ناعمة ووسادة قابلة للإزالة.','<p> قلب لوح الجسيمات مغطى بقماش مخملي ناعم. ارتفاع 110 سم مع عمود سيزال قابل للاستبدال. سهولة التجميع باستخدام الأدوات المضمنة.</p>'),('ar',21,'أرجوحة برج القط الرمادي',NULL,'عمود تسلق للقطط ثلاثي الطبقات مع عمود خدش من حبل السيزال ومنطقة استراحة قطيفة. مصنوعة من خشب الصنوبر الصلب مع أرجوحة مخملية ناعمة ووسادة قابلة للإزالة.','<p> قلب لوح الجسيمات مغطى بقماش مخملي ناعم. ارتفاع 110 سم مع عمود سيزال قابل للاستبدال. سهولة التجميع باستخدام الأدوات المضمنة.</p>'),('ar',22,'مكملات الحيوية',NULL,'مضغ الفيتامينات اليومية مع الجلوكوزامين والأوميغا 3 والبروبيوتيك للكلاب النشطة.','<p> أقراص طرية قابلة للمضغ بنكهة لحم البقر. 90 حبة لكل علبة. يدعم المفاصل والشعر والهضم. تم تصنيعه في منشأة يتم فحصها بواسطة طبيب بيطري.</p>'),('ar',23,'مكملات الحيوية',NULL,'مضغ الفيتامينات اليومية مع الجلوكوزامين والأوميغا 3 والبروبيوتيك للكلاب النشطة.','<p> أقراص طرية قابلة للمضغ بنكهة لحم البقر. 90 حبة لكل علبة. يدعم المفاصل والشعر والهضم. تم تصنيعه في منشأة يتم فحصها بواسطة طبيب بيطري.</p>'),('ar',24,'مكملات الحيوية',NULL,'مضغ الفيتامينات اليومية مع الجلوكوزامين والأوميغا 3 والبروبيوتيك للكلاب النشطة.','<p> أقراص طرية قابلة للمضغ بنكهة لحم البقر. 90 حبة لكل علبة. يدعم المفاصل والشعر والهضم. تم تصنيعه في منشأة يتم فحصها بواسطة طبيب بيطري.</p>'),('ar',25,'عمود خدش القطط',NULL,'يحتوي عمود الخدش المصنوع من سلك السيزال على قاعدة متينة وحجم مناسب للقطط للخدش بشكل مريح.','<p>70 سم طول مع قاعدة MDF مرجحة لتحقيق الثبات. عمود السيزال قابل للاستبدال. تأتي مع لعبة ريشة معلقة.</p>'),('ar',26,'عمود خدش القطط',NULL,'يحتوي عمود الخدش المصنوع من سلك السيزال على قاعدة متينة وحجم مناسب للقطط للخدش بشكل مريح.','<p>70 سم طول مع قاعدة MDF مرجحة لتحقيق الثبات. عمود السيزال قابل للاستبدال. تأتي مع لعبة ريشة معلقة.</p>'),('ar',27,'عمود خدش القطط',NULL,'يحتوي عمود الخدش المصنوع من سلك السيزال على قاعدة متينة وحجم مناسب للقطط للخدش بشكل مريح.','<p>70 سم طول مع قاعدة MDF مرجحة لتحقيق الثبات. عمود السيزال قابل للاستبدال. تأتي مع لعبة ريشة معلقة.</p>'),('ar',28,'عمود خدش القطط',NULL,'يحتوي عمود الخدش المصنوع من سلك السيزال على قاعدة متينة وحجم مناسب للقطط للخدش بشكل مريح.','<p>70 سم طول مع قاعدة MDF مرجحة لتحقيق الثبات. عمود السيزال قابل للاستبدال. تأتي مع لعبة ريشة معلقة.</p>'),('ar',29,'سرير كلب مريح',NULL,'مرتبة لتقويم العظام من الإسفنج الذكي مع غطاء قابل للإزالة والغسل في الغسالة.','<p> رغوة عالية الكثافة تدعم مفاصل الحيوانات الأليفة الأكبر سنًا. غطاء من صوف الشيربا. متوفر بمقاسات M-XL. نعل مضاد للانزلاق.</p>'),('ar',30,'سرير كلب مريح',NULL,'مرتبة لتقويم العظام من الإسفنج الذكي مع غطاء قابل للإزالة والغسل في الغسالة.','<p> رغوة عالية الكثافة تدعم مفاصل الحيوانات الأليفة الأكبر سنًا. غطاء من صوف الشيربا. متوفر بمقاسات M-XL. نعل مضاد للانزلاق.</p>'),('fr',1,'Nourriture pour chats de qualité supérieure',NULL,'Croquettes sans céréales avec du vrai saumon comme premier ingrédient et de la taurine ajoutée.','<p>Formule pour chats adultes d\'intérieur. Protéine brute minimale 38%. Sac de 2,5 kg avec fermeture éclair pratique. Sans colorants ni conservateurs artificiels.</p>'),('fr',2,'Jouet à mâcher pour chien',NULL,'Les produits à mâcher en caoutchouc super durables peuvent rebondir, flotter sur l\'eau et résister aux fortes mastications des chiens.','<p>Le caoutchouc naturel est non toxique. Lavable en machine en toute sécurité. Le noyau creux peut être farci de collations ou de beurre de cacahuète. Disponible dans les tailles allant du petit au XL.</p>'),('fr',3,'Hamac Tour à Chat Gris',NULL,'Poteau d\'escalade pour chat à trois niveaux avec griffoir en corde de sisal et aire de repos en peluche. Fabriqué en pin massif avec un hamac en velours doux et un coussin amovible.','<p>Âme en panneaux de particules recouverts d\'un tissu velours doux. 110 cm de hauteur avec colonne en sisal remplaçable. Assemblage facile avec les outils inclus.</p>'),('fr',4,'Gouttes anti-allergies',NULL,'Gouttes formulées par un vétérinaire contenant des oméga-3 et de la quercétine pour les animaux sensibles et qui démangent.','<p>Compte-gouttes à dosage facile. Ajouter à la nourriture ou à la boisson. Convient aux chiens et chats de plus de 6 mois. Flacon de 60 ml.</p>'),('fr',5,'Suppléments de vitalité',NULL,'Multivitamines quotidiennes à mâcher avec de la glucosamine, des oméga-3 et des probiotiques pour les chiens actifs.','<p>Comprimés à croquer mous au goût de bœuf. 90 comprimés par boîte. Soutient les articulations, les cheveux et la digestion. Fabriqué dans un établissement inspecté par un vétérinaire.</p>'),('fr',6,'Harnais pour chien',NULL,'Harnais anti-recul rembourré avec bordure réfléchissante et deux points d\'attache de laisse.','<p>Coussin en maille respirante. Réglage en cinq points pour un ajustement parfait. Disponible dans les tailles XS-XL. Lavage à la main à l\'eau froide.</p>'),('fr',7,'Arbre à chat pour chat',NULL,'Le griffoir en fil de sisal a une base robuste et est de la bonne taille pour que les chats puissent gratter confortablement.','<p>70 cm de haut avec base en MDF lesté pour plus de stabilité. Colonne en sisal remplaçable. Livré avec un jouet en plumes suspendu.</p>'),('fr',8,'Shampoing pour animaux de compagnie',NULL,'Le gel douche à l\'avoine et à l\'aloe vera nettoie sans éliminer les huiles naturelles.','<p>Équilibre le pH pour les chiens et les chats. Ne contient pas de savon. Tensioactif extrait de la noix de coco. Flacon de 500 ml. Non testé sur les animaux.</p>'),('fr',9,'Lit confortable pour chien',NULL,'Matelas orthopédique à mémoire de forme avec housse amovible et lavable en machine.','<p>La mousse haute densité soutient les articulations des animaux plus âgés. Housse polaire Sherpa. Disponible dans les tailles M-XL. Semelle antidérapante.</p>'),('fr',10,'Gâteries apaisantes',NULL,'Gâterie douce à mâcher à la camomille et à la L-théanine pour les situations stressantes.','<p>Formula ne contient pas de médicaments. 60 comprimés par sachet. À utiliser en voyage, en cas de tempête ou en allant à la clinique vétérinaire. Convient aux chiens de plus de 12 semaines.</p>'),('fr',11,'Nourriture pour chats de qualité supérieure',NULL,'Croquettes sans céréales avec du vrai saumon comme premier ingrédient et de la taurine ajoutée.','<p>Formule pour chats adultes d\'intérieur. Protéine brute minimale 38%. Sac de 2,5 kg avec fermeture éclair pratique. Sans colorants ni conservateurs artificiels.</p>'),('fr',12,'Nourriture pour chats de qualité supérieure',NULL,'Croquettes sans céréales avec du vrai saumon comme premier ingrédient et de la taurine ajoutée.','<p>Formule pour chats adultes d\'intérieur. Protéine brute minimale 38%. Sac de 2,5 kg avec fermeture éclair pratique. Sans colorants ni conservateurs artificiels.</p>'),('fr',13,'Nourriture pour chats de qualité supérieure',NULL,'Croquettes sans céréales avec du vrai saumon comme premier ingrédient et de la taurine ajoutée.','<p>Formule pour chats adultes d\'intérieur. Protéine brute minimale 38%. Sac de 2,5 kg avec fermeture éclair pratique. Sans colorants ni conservateurs artificiels.</p>'),('fr',14,'Nourriture pour chats de qualité supérieure',NULL,'Croquettes sans céréales avec du vrai saumon comme premier ingrédient et de la taurine ajoutée.','<p>Formule pour chats adultes d\'intérieur. Protéine brute minimale 38%. Sac de 2,5 kg avec fermeture éclair pratique. Sans colorants ni conservateurs artificiels.</p>'),('fr',15,'Jouet à mâcher pour chien',NULL,'Les produits à mâcher en caoutchouc super durables peuvent rebondir, flotter sur l\'eau et résister aux fortes mastications des chiens.','<p>Le caoutchouc naturel est non toxique. Lavable en machine en toute sécurité. Le noyau creux peut être farci de collations ou de beurre de cacahuète. Disponible dans les tailles allant du petit au XL.</p>'),('fr',16,'Jouet à mâcher pour chien',NULL,'Les produits à mâcher en caoutchouc super durables peuvent rebondir, flotter sur l\'eau et résister aux fortes mastications des chiens.','<p>Le caoutchouc naturel est non toxique. Lavable en machine en toute sécurité. Le noyau creux peut être farci de collations ou de beurre de cacahuète. Disponible dans les tailles allant du petit au XL.</p>'),('fr',17,'Hamac Tour à Chat Gris',NULL,'Poteau d\'escalade pour chat à trois niveaux avec griffoir en corde de sisal et aire de repos en peluche. Fabriqué en pin massif avec un hamac en velours doux et un coussin amovible.','<p>Âme en panneaux de particules recouverts d\'un tissu velours doux. 110 cm de hauteur avec colonne en sisal remplaçable. Assemblage facile avec les outils inclus.</p>'),('fr',18,'Hamac Tour à Chat Gris',NULL,'Poteau d\'escalade pour chat à trois niveaux avec griffoir en corde de sisal et aire de repos en peluche. Fabriqué en pin massif avec un hamac en velours doux et un coussin amovible.','<p>Âme en panneaux de particules recouverts d\'un tissu velours doux. 110 cm de hauteur avec colonne en sisal remplaçable. Assemblage facile avec les outils inclus.</p>'),('fr',19,'Hamac Tour à Chat Gris',NULL,'Poteau d\'escalade pour chat à trois niveaux avec griffoir en corde de sisal et aire de repos en peluche. Fabriqué en pin massif avec un hamac en velours doux et un coussin amovible.','<p>Âme en panneaux de particules recouverts d\'un tissu velours doux. 110 cm de hauteur avec colonne en sisal remplaçable. Assemblage facile avec les outils inclus.</p>'),('fr',20,'Hamac Tour à Chat Gris',NULL,'Poteau d\'escalade pour chat à trois niveaux avec griffoir en corde de sisal et aire de repos en peluche. Fabriqué en pin massif avec un hamac en velours doux et un coussin amovible.','<p>Âme en panneaux de particules recouverts d\'un tissu velours doux. 110 cm de hauteur avec colonne en sisal remplaçable. Assemblage facile avec les outils inclus.</p>'),('fr',21,'Hamac Tour à Chat Gris',NULL,'Poteau d\'escalade pour chat à trois niveaux avec griffoir en corde de sisal et aire de repos en peluche. Fabriqué en pin massif avec un hamac en velours doux et un coussin amovible.','<p>Âme en panneaux de particules recouverts d\'un tissu velours doux. 110 cm de hauteur avec colonne en sisal remplaçable. Assemblage facile avec les outils inclus.</p>'),('fr',22,'Suppléments de vitalité',NULL,'Multivitamines quotidiennes à mâcher avec de la glucosamine, des oméga-3 et des probiotiques pour les chiens actifs.','<p>Comprimés à croquer mous au goût de bœuf. 90 comprimés par boîte. Soutient les articulations, les cheveux et la digestion. Fabriqué dans un établissement inspecté par un vétérinaire.</p>'),('fr',23,'Suppléments de vitalité',NULL,'Multivitamines quotidiennes à mâcher avec de la glucosamine, des oméga-3 et des probiotiques pour les chiens actifs.','<p>Comprimés à croquer mous au goût de bœuf. 90 comprimés par boîte. Soutient les articulations, les cheveux et la digestion. Fabriqué dans un établissement inspecté par un vétérinaire.</p>'),('fr',24,'Suppléments de vitalité',NULL,'Multivitamines quotidiennes à mâcher avec de la glucosamine, des oméga-3 et des probiotiques pour les chiens actifs.','<p>Comprimés à croquer mous au goût de bœuf. 90 comprimés par boîte. Soutient les articulations, les cheveux et la digestion. Fabriqué dans un établissement inspecté par un vétérinaire.</p>'),('fr',25,'Arbre à chat pour chat',NULL,'Le griffoir en fil de sisal a une base robuste et est de la bonne taille pour que les chats puissent gratter confortablement.','<p>70 cm de haut avec base en MDF lesté pour plus de stabilité. Colonne en sisal remplaçable. Livré avec un jouet en plumes suspendu.</p>'),('fr',26,'Arbre à chat pour chat',NULL,'Le griffoir en fil de sisal a une base robuste et est de la bonne taille pour que les chats puissent gratter confortablement.','<p>70 cm de haut avec base en MDF lesté pour plus de stabilité. Colonne en sisal remplaçable. Livré avec un jouet en plumes suspendu.</p>'),('fr',27,'Arbre à chat pour chat',NULL,'Le griffoir en fil de sisal a une base robuste et est de la bonne taille pour que les chats puissent gratter confortablement.','<p>70 cm de haut avec base en MDF lesté pour plus de stabilité. Colonne en sisal remplaçable. Livré avec un jouet en plumes suspendu.</p>'),('fr',28,'Arbre à chat pour chat',NULL,'Le griffoir en fil de sisal a une base robuste et est de la bonne taille pour que les chats puissent gratter confortablement.','<p>70 cm de haut avec base en MDF lesté pour plus de stabilité. Colonne en sisal remplaçable. Livré avec un jouet en plumes suspendu.</p>'),('fr',29,'Lit confortable pour chien',NULL,'Matelas orthopédique à mémoire de forme avec housse amovible et lavable en machine.','<p>La mousse haute densité soutient les articulations des animaux plus âgés. Housse polaire Sherpa. Disponible dans les tailles M-XL. Semelle antidérapante.</p>'),('fr',30,'Lit confortable pour chien',NULL,'Matelas orthopédique à mémoire de forme avec housse amovible et lavable en machine.','<p>La mousse haute densité soutient les articulations des animaux plus âgés. Housse polaire Sherpa. Disponible dans les tailles M-XL. Semelle antidérapante.</p>'),('id',1,'Makanan Kucing Premium',NULL,'Makanan kering tanpa biji-bijian dengan salmon asli sebagai bahan pertama dan tambahan taurin.','<p>Formula untuk kucing dalam ruangan dewasa. Protein kasar minimal 38%. Tas 2,5kg dengan kunci zip yang nyaman. Tanpa pewarna atau pengawet buatan.</p>'),('id',2,'Mainan Kunyah Anjing',NULL,'Kunyah karet super tahan lama dapat memantul, mengapung di atas air, dan tahan terhadap kunyahan kuat oleh anjing.','<p>Karet alam tidak beracun. Aman untuk dicuci dengan mesin. Inti yang berongga bisa diisi dengan makanan ringan atau selai kacang. Tersedia dalam ukuran dari kecil hingga XL.</p>'),('id',3,'Tempat Tidur Gantung Menara Kucing Abu-abu',NULL,'Pos panjat kucing tiga tingkat dengan tiang garukan tali sisal dan tempat istirahat yang mewah. Terbuat dari kayu pinus padat dengan tempat tidur gantung beludru lembut dan bantal yang dapat dilepas.','<p>Inti papan partikel dilapisi kain beludru lembut. Tinggi 110cm dengan kolom sisal yang dapat diganti. Perakitan mudah dengan alat yang disertakan.</p>'),('id',4,'Obat Pereda Alergi',NULL,'Obat tetes yang diformulasikan oleh dokter hewan yang mengandung omega-3 dan quercetin untuk hewan peliharaan yang gatal dan sensitif.','<p>Penetes dosis mudah. Tambahkan ke makanan atau minuman. Cocok untuk anjing dan kucing berusia di atas 6 bulan. Botol 60ml.</p>'),('id',5,'Suplemen Vitalitas',NULL,'Kunyah multivitamin setiap hari dengan glukosamin, omega-3, dan probiotik untuk anjing aktif.','<p>Tablet kunyah lembut rasa sapi. 90 pil per kotak. Mendukung sendi, rambut dan pencernaan. Diproduksi di fasilitas yang diperiksa dokter hewan.</p>'),('id',6,'Tali Kekang Anjing',NULL,'Harness anti-mundur empuk dengan trim reflektif dan dua titik pengikat tali.','<p>Bantal jaring bernapas. Penyesuaian lima titik agar pas. Tersedia dalam ukuran XS-XL. Cuci tangan dengan air dingin.</p>'),('id',7,'Pos Garukan Kucing',NULL,'Tiang garukan kawat sisal memiliki alas yang kokoh dan ukurannya pas agar kucing dapat menggaruk dengan nyaman.','Tinggi <p>70cm dengan dasar MDF berbobot untuk stabilitas. Kolom sisal yang dapat diganti. Dilengkapi dengan mainan bulu gantung.</p>'),('id',8,'Shampo Hewan Peliharaan',NULL,'Gel mandi oatmeal dan lidah buaya membersihkan tanpa menghilangkan minyak alami.','<p>Menyeimbangkan pH untuk anjing dan kucing. Tidak mengandung sabun. Surfaktan diekstrak dari kelapa. botol 500ml. Tidak diuji pada hewan.</p>'),('id',9,'Tempat Tidur Anjing yang Nyaman',NULL,'Kasur ortopedi busa memori dengan penutup yang dapat dilepas dan dicuci dengan mesin.','<p>Busa dengan kepadatan tinggi menopang persendian hewan peliharaan yang lebih tua. Penutup bulu sherpa. Tersedia dalam ukuran M-XL. Sol anti selip.</p>'),('id',10,'Camilan yang Menenangkan',NULL,'Camilan kunyah lembut dengan kamomil dan L-theanine untuk situasi stres.','<p>Formula tidak mengandung obat. 60 tablet per kantong. Gunakan saat bepergian, badai atau pergi ke klinik hewan. Cocok untuk anjing berusia di atas 12 minggu.</p>'),('id',11,'Makanan Kucing Premium',NULL,'Makanan kering tanpa biji-bijian dengan salmon asli sebagai bahan pertama dan tambahan taurin.','<p>Formula untuk kucing dalam ruangan dewasa. Protein kasar minimal 38%. Tas 2,5kg dengan kunci zip yang nyaman. Tanpa pewarna atau pengawet buatan.</p>'),('id',12,'Makanan Kucing Premium',NULL,'Makanan kering tanpa biji-bijian dengan salmon asli sebagai bahan pertama dan tambahan taurin.','<p>Formula untuk kucing dalam ruangan dewasa. Protein kasar minimal 38%. Tas 2,5kg dengan kunci zip yang nyaman. Tanpa pewarna atau pengawet buatan.</p>'),('id',13,'Makanan Kucing Premium',NULL,'Makanan kering tanpa biji-bijian dengan salmon asli sebagai bahan pertama dan tambahan taurin.','<p>Formula untuk kucing dalam ruangan dewasa. Protein kasar minimal 38%. Tas 2,5kg dengan kunci zip yang nyaman. Tanpa pewarna atau pengawet buatan.</p>'),('id',14,'Makanan Kucing Premium',NULL,'Makanan kering tanpa biji-bijian dengan salmon asli sebagai bahan pertama dan tambahan taurin.','<p>Formula untuk kucing dalam ruangan dewasa. Protein kasar minimal 38%. Tas 2,5kg dengan kunci zip yang nyaman. Tanpa pewarna atau pengawet buatan.</p>'),('id',15,'Mainan Kunyah Anjing',NULL,'Kunyah karet super tahan lama dapat memantul, mengapung di atas air, dan tahan terhadap kunyahan kuat oleh anjing.','<p>Karet alam tidak beracun. Aman untuk dicuci dengan mesin. Inti yang berongga bisa diisi dengan makanan ringan atau selai kacang. Tersedia dalam ukuran dari kecil hingga XL.</p>'),('id',16,'Mainan Kunyah Anjing',NULL,'Kunyah karet super tahan lama dapat memantul, mengapung di atas air, dan tahan terhadap kunyahan kuat oleh anjing.','<p>Karet alam tidak beracun. Aman untuk dicuci dengan mesin. Inti yang berongga bisa diisi dengan makanan ringan atau selai kacang. Tersedia dalam ukuran dari kecil hingga XL.</p>'),('id',17,'Tempat Tidur Gantung Menara Kucing Abu-abu',NULL,'Pos panjat kucing tiga tingkat dengan tiang garukan tali sisal dan tempat istirahat yang mewah. Terbuat dari kayu pinus padat dengan tempat tidur gantung beludru lembut dan bantal yang dapat dilepas.','<p>Inti papan partikel dilapisi kain beludru lembut. Tinggi 110cm dengan kolom sisal yang dapat diganti. Perakitan mudah dengan alat yang disertakan.</p>'),('id',18,'Tempat Tidur Gantung Menara Kucing Abu-abu',NULL,'Pos panjat kucing tiga tingkat dengan tiang garukan tali sisal dan tempat istirahat yang mewah. Terbuat dari kayu pinus padat dengan tempat tidur gantung beludru lembut dan bantal yang dapat dilepas.','<p>Inti papan partikel dilapisi kain beludru lembut. Tinggi 110cm dengan kolom sisal yang dapat diganti. Perakitan mudah dengan alat yang disertakan.</p>'),('id',19,'Tempat Tidur Gantung Menara Kucing Abu-abu',NULL,'Pos panjat kucing tiga tingkat dengan tiang garukan tali sisal dan tempat istirahat yang mewah. Terbuat dari kayu pinus padat dengan tempat tidur gantung beludru lembut dan bantal yang dapat dilepas.','<p>Inti papan partikel dilapisi kain beludru lembut. Tinggi 110cm dengan kolom sisal yang dapat diganti. Perakitan mudah dengan alat yang disertakan.</p>'),('id',20,'Tempat Tidur Gantung Menara Kucing Abu-abu',NULL,'Pos panjat kucing tiga tingkat dengan tiang garukan tali sisal dan tempat istirahat yang mewah. Terbuat dari kayu pinus padat dengan tempat tidur gantung beludru lembut dan bantal yang dapat dilepas.','<p>Inti papan partikel dilapisi kain beludru lembut. Tinggi 110cm dengan kolom sisal yang dapat diganti. Perakitan mudah dengan alat yang disertakan.</p>'),('id',21,'Tempat Tidur Gantung Menara Kucing Abu-abu',NULL,'Pos panjat kucing tiga tingkat dengan tiang garukan tali sisal dan tempat istirahat yang mewah. Terbuat dari kayu pinus padat dengan tempat tidur gantung beludru lembut dan bantal yang dapat dilepas.','<p>Inti papan partikel dilapisi kain beludru lembut. Tinggi 110cm dengan kolom sisal yang dapat diganti. Perakitan mudah dengan alat yang disertakan.</p>'),('id',22,'Suplemen Vitalitas',NULL,'Kunyah multivitamin setiap hari dengan glukosamin, omega-3, dan probiotik untuk anjing aktif.','<p>Tablet kunyah lembut rasa sapi. 90 pil per kotak. Mendukung sendi, rambut dan pencernaan. Diproduksi di fasilitas yang diperiksa dokter hewan.</p>'),('id',23,'Suplemen Vitalitas',NULL,'Kunyah multivitamin setiap hari dengan glukosamin, omega-3, dan probiotik untuk anjing aktif.','<p>Tablet kunyah lembut rasa sapi. 90 pil per kotak. Mendukung sendi, rambut dan pencernaan. Diproduksi di fasilitas yang diperiksa dokter hewan.</p>'),('id',24,'Suplemen Vitalitas',NULL,'Kunyah multivitamin setiap hari dengan glukosamin, omega-3, dan probiotik untuk anjing aktif.','<p>Tablet kunyah lembut rasa sapi. 90 pil per kotak. Mendukung sendi, rambut dan pencernaan. Diproduksi di fasilitas yang diperiksa dokter hewan.</p>'),('id',25,'Pos Garukan Kucing',NULL,'Tiang garukan kawat sisal memiliki alas yang kokoh dan ukurannya pas agar kucing dapat menggaruk dengan nyaman.','Tinggi <p>70cm dengan dasar MDF berbobot untuk stabilitas. Kolom sisal yang dapat diganti. Dilengkapi dengan mainan bulu gantung.</p>'),('id',26,'Pos Garukan Kucing',NULL,'Tiang garukan kawat sisal memiliki alas yang kokoh dan ukurannya pas agar kucing dapat menggaruk dengan nyaman.','Tinggi <p>70cm dengan dasar MDF berbobot untuk stabilitas. Kolom sisal yang dapat diganti. Dilengkapi dengan mainan bulu gantung.</p>'),('id',27,'Pos Garukan Kucing',NULL,'Tiang garukan kawat sisal memiliki alas yang kokoh dan ukurannya pas agar kucing dapat menggaruk dengan nyaman.','Tinggi <p>70cm dengan dasar MDF berbobot untuk stabilitas. Kolom sisal yang dapat diganti. Dilengkapi dengan mainan bulu gantung.</p>'),('id',28,'Pos Garukan Kucing',NULL,'Tiang garukan kawat sisal memiliki alas yang kokoh dan ukurannya pas agar kucing dapat menggaruk dengan nyaman.','Tinggi <p>70cm dengan dasar MDF berbobot untuk stabilitas. Kolom sisal yang dapat diganti. Dilengkapi dengan mainan bulu gantung.</p>'),('id',29,'Tempat Tidur Anjing yang Nyaman',NULL,'Kasur ortopedi busa memori dengan penutup yang dapat dilepas dan dicuci dengan mesin.','<p>Busa dengan kepadatan tinggi menopang persendian hewan peliharaan yang lebih tua. Penutup bulu sherpa. Tersedia dalam ukuran M-XL. Sol anti selip.</p>'),('id',30,'Tempat Tidur Anjing yang Nyaman',NULL,'Kasur ortopedi busa memori dengan penutup yang dapat dilepas dan dicuci dengan mesin.','<p>Busa dengan kepadatan tinggi menopang persendian hewan peliharaan yang lebih tua. Penutup bulu sherpa. Tersedia dalam ukuran M-XL. Sol anti selip.</p>'),('tr',1,'Premium Kedi Maması',NULL,'İlk maddesi gerçek somon olan ve taurin eklenmiş tahılsız kuru mama.','<p>Yetişkin ev kedileri için formül. Minimum ham protein %38. Kullanışlı fermuarlı 2,5 kg\'lık çanta. Yapay renklendirici veya koruyucu madde yok.</p>'),('tr',2,'Köpek Çiğneme Oyuncak',NULL,'Süper dayanıklı kauçuk çiğneme parçaları sıçrayabilir, suda yüzebilir ve köpeklerin güçlü çiğnemelerine dayanabilir.','<p>Doğal kauçuk toksik değildir. Makinede yıkamak güvenlidir. İçi boş çekirdek atıştırmalıklar veya fıstık ezmesi ile doldurulabilir. Küçükten XL\'ye kadar bedenleri mevcuttur.</p>'),('tr',3,'Hamak Kedi Kulesi Gri',NULL,'Sisal halatlı tırmalama direği ve konforlu dinlenme alanı bulunan üç katmanlı kedi tırmanma direği. Yumuşak kadife hamak ve çıkarılabilir minder ile masif çamdan yapılmıştır.','<p>Yumuşak kadife kumaşla kaplanmış yonga levha göbeği. Değiştirilebilir sisal sütunlu 110 cm yüksekliğinde. Birlikte verilen aletlerle kolay montaj.</p>'),('tr',4,'Alerji Giderici Damlalar',NULL,'Kaşıntılı ve hassas evcil hayvanlar için omega-3 ve quercetin içeren veteriner formüllü damlalar.','<p>Kolay dozaj damlalığı. Yiyecek veya içeceklere ekleyin. 6 aydan büyük köpek ve kediler için uygundur. 60 ml\'lik şişe.</p>'),('tr',5,'Canlılık Takviyeleri',NULL,'Aktif köpekler için glukozamin, omega-3 ve probiyotikler içeren günlük multivitamin çiğnemeleri.','<p>Sığır eti aromalı yumuşak çiğneme tabletleri. Kutu başına 90 hap. Eklemleri, saçları ve sindirimi destekler. Veteriner tarafından denetlenen bir tesiste üretilmiştir.</p>'),('tr',6,'Köpek Koşum Takımı',NULL,'Yansıtıcı süslemeli ve iki kayış bağlantı noktasına sahip, yastıklı geri tepme önleyici koşum takımı.','<p>Nefes alabilen file yastık. Rahat bir uyum için beş noktalı ayar. XS-XL bedenleri mevcuttur. Soğuk suyla elde yıkayın.</p>'),('tr',7,'Kedi Tırmalama Direği',NULL,'Sisal tel tırmalama direği sağlam bir tabana sahiptir ve kedilerin rahatça tırmalaması için doğru boyuttadır.','<p>70cm yüksekliğinde, stabilite için ağırlıklı MDF tabanı. Değiştirilebilir sisal sütunu. Asılı tüylü bir oyuncakla birlikte gelir.</p>'),('tr',8,'Evcil Hayvan Şampuanı',NULL,'Yulaf ezmesi ve aloe vera duş jeli, doğal yağları soymadan temizler.','<p>Köpekler ve kediler için pH\'ı dengeler. Sabun içermez. Hindistan cevizinden elde edilen yüzey aktif madde. 500 ml\'lik şişe. Hayvanlar üzerinde test edilmemiştir.</p>'),('tr',9,'Rahat Köpek Yatağı',NULL,'Çıkarılabilir ve makinede yıkanabilir kapaklı hafızalı köpük ortopedik yatak.','<p>Yüksek yoğunluklu köpük yaşlı evcil hayvanların eklemlerini destekler. Sherpa polar kılıf. M-XL bedenleri mevcuttur. Kaymaz taban.</p>'),('tr',10,'Sakinleştirici İkramlar',NULL,'Stresli durumlar için papatya ve L-theanine ile yumuşak çiğneme tedavisi.','<p>Formül ilaç içermez. Torba başına 60 tablet. Seyahat ederken, fırtınalarda veya veteriner kliniğine giderken kullanın. 12 haftalıktan büyük köpekler için uygundur.</p>'),('tr',11,'Premium Kedi Maması',NULL,'İlk maddesi gerçek somon olan ve taurin eklenmiş tahılsız kuru mama.','<p>Yetişkin ev kedileri için formül. Minimum ham protein %38. Kullanışlı fermuarlı 2,5 kg\'lık çanta. Yapay renklendirici veya koruyucu madde yok.</p>'),('tr',12,'Premium Kedi Maması',NULL,'İlk maddesi gerçek somon olan ve taurin eklenmiş tahılsız kuru mama.','<p>Yetişkin ev kedileri için formül. Minimum ham protein %38. Kullanışlı fermuarlı 2,5 kg\'lık çanta. Yapay renklendirici veya koruyucu madde yok.</p>'),('tr',13,'Premium Kedi Maması',NULL,'İlk maddesi gerçek somon olan ve taurin eklenmiş tahılsız kuru mama.','<p>Yetişkin ev kedileri için formül. Minimum ham protein %38. Kullanışlı fermuarlı 2,5 kg\'lık çanta. Yapay renklendirici veya koruyucu madde yok.</p>'),('tr',14,'Premium Kedi Maması',NULL,'İlk maddesi gerçek somon olan ve taurin eklenmiş tahılsız kuru mama.','<p>Yetişkin ev kedileri için formül. Minimum ham protein %38. Kullanışlı fermuarlı 2,5 kg\'lık çanta. Yapay renklendirici veya koruyucu madde yok.</p>'),('tr',15,'Köpek Çiğneme Oyuncak',NULL,'Süper dayanıklı kauçuk çiğneme parçaları sıçrayabilir, suda yüzebilir ve köpeklerin güçlü çiğnemelerine dayanabilir.','<p>Doğal kauçuk toksik değildir. Makinede yıkamak güvenlidir. İçi boş çekirdek atıştırmalıklar veya fıstık ezmesi ile doldurulabilir. Küçükten XL\'ye kadar bedenleri mevcuttur.</p>'),('tr',16,'Köpek Çiğneme Oyuncak',NULL,'Süper dayanıklı kauçuk çiğneme parçaları sıçrayabilir, suda yüzebilir ve köpeklerin güçlü çiğnemelerine dayanabilir.','<p>Doğal kauçuk toksik değildir. Makinede yıkamak güvenlidir. İçi boş çekirdek atıştırmalıklar veya fıstık ezmesi ile doldurulabilir. Küçükten XL\'ye kadar bedenleri mevcuttur.</p>'),('tr',17,'Hamak Kedi Kulesi Gri',NULL,'Sisal halatlı tırmalama direği ve konforlu dinlenme alanı bulunan üç katmanlı kedi tırmanma direği. Yumuşak kadife hamak ve çıkarılabilir minder ile masif çamdan yapılmıştır.','<p>Yumuşak kadife kumaşla kaplanmış yonga levha göbeği. Değiştirilebilir sisal sütunlu 110 cm yüksekliğinde. Birlikte verilen aletlerle kolay montaj.</p>'),('tr',18,'Hamak Kedi Kulesi Gri',NULL,'Sisal halatlı tırmalama direği ve konforlu dinlenme alanı bulunan üç katmanlı kedi tırmanma direği. Yumuşak kadife hamak ve çıkarılabilir minder ile masif çamdan yapılmıştır.','<p>Yumuşak kadife kumaşla kaplanmış yonga levha göbeği. Değiştirilebilir sisal sütunlu 110 cm yüksekliğinde. Birlikte verilen aletlerle kolay montaj.</p>'),('tr',19,'Hamak Kedi Kulesi Gri',NULL,'Sisal halatlı tırmalama direği ve konforlu dinlenme alanı bulunan üç katmanlı kedi tırmanma direği. Yumuşak kadife hamak ve çıkarılabilir minder ile masif çamdan yapılmıştır.','<p>Yumuşak kadife kumaşla kaplanmış yonga levha göbeği. Değiştirilebilir sisal sütunlu 110 cm yüksekliğinde. Birlikte verilen aletlerle kolay montaj.</p>'),('tr',20,'Hamak Kedi Kulesi Gri',NULL,'Sisal halatlı tırmalama direği ve konforlu dinlenme alanı bulunan üç katmanlı kedi tırmanma direği. Yumuşak kadife hamak ve çıkarılabilir minder ile masif çamdan yapılmıştır.','<p>Yumuşak kadife kumaşla kaplanmış yonga levha göbeği. Değiştirilebilir sisal sütunlu 110 cm yüksekliğinde. Birlikte verilen aletlerle kolay montaj.</p>'),('tr',21,'Hamak Kedi Kulesi Gri',NULL,'Sisal halatlı tırmalama direği ve konforlu dinlenme alanı bulunan üç katmanlı kedi tırmanma direği. Yumuşak kadife hamak ve çıkarılabilir minder ile masif çamdan yapılmıştır.','<p>Yumuşak kadife kumaşla kaplanmış yonga levha göbeği. Değiştirilebilir sisal sütunlu 110 cm yüksekliğinde. Birlikte verilen aletlerle kolay montaj.</p>'),('tr',22,'Canlılık Takviyeleri',NULL,'Aktif köpekler için glukozamin, omega-3 ve probiyotikler içeren günlük multivitamin çiğnemeleri.','<p>Sığır eti aromalı yumuşak çiğneme tabletleri. Kutu başına 90 hap. Eklemleri, saçları ve sindirimi destekler. Veteriner tarafından denetlenen bir tesiste üretilmiştir.</p>'),('tr',23,'Canlılık Takviyeleri',NULL,'Aktif köpekler için glukozamin, omega-3 ve probiyotikler içeren günlük multivitamin çiğnemeleri.','<p>Sığır eti aromalı yumuşak çiğneme tabletleri. Kutu başına 90 hap. Eklemleri, saçları ve sindirimi destekler. Veteriner tarafından denetlenen bir tesiste üretilmiştir.</p>'),('tr',24,'Canlılık Takviyeleri',NULL,'Aktif köpekler için glukozamin, omega-3 ve probiyotikler içeren günlük multivitamin çiğnemeleri.','<p>Sığır eti aromalı yumuşak çiğneme tabletleri. Kutu başına 90 hap. Eklemleri, saçları ve sindirimi destekler. Veteriner tarafından denetlenen bir tesiste üretilmiştir.</p>'),('tr',25,'Kedi Tırmalama Direği',NULL,'Sisal tel tırmalama direği sağlam bir tabana sahiptir ve kedilerin rahatça tırmalaması için doğru boyuttadır.','<p>70cm yüksekliğinde, stabilite için ağırlıklı MDF tabanı. Değiştirilebilir sisal sütunu. Asılı tüylü bir oyuncakla birlikte gelir.</p>'),('tr',26,'Kedi Tırmalama Direği',NULL,'Sisal tel tırmalama direği sağlam bir tabana sahiptir ve kedilerin rahatça tırmalaması için doğru boyuttadır.','<p>70cm yüksekliğinde, stabilite için ağırlıklı MDF tabanı. Değiştirilebilir sisal sütunu. Asılı tüylü bir oyuncakla birlikte gelir.</p>'),('tr',27,'Kedi Tırmalama Direği',NULL,'Sisal tel tırmalama direği sağlam bir tabana sahiptir ve kedilerin rahatça tırmalaması için doğru boyuttadır.','<p>70cm yüksekliğinde, stabilite için ağırlıklı MDF tabanı. Değiştirilebilir sisal sütunu. Asılı tüylü bir oyuncakla birlikte gelir.</p>'),('tr',28,'Kedi Tırmalama Direği',NULL,'Sisal tel tırmalama direği sağlam bir tabana sahiptir ve kedilerin rahatça tırmalaması için doğru boyuttadır.','<p>70cm yüksekliğinde, stabilite için ağırlıklı MDF tabanı. Değiştirilebilir sisal sütunu. Asılı tüylü bir oyuncakla birlikte gelir.</p>'),('tr',29,'Rahat Köpek Yatağı',NULL,'Çıkarılabilir ve makinede yıkanabilir kapaklı hafızalı köpük ortopedik yatak.','<p>Yüksek yoğunluklu köpük yaşlı evcil hayvanların eklemlerini destekler. Sherpa polar kılıf. M-XL bedenleri mevcuttur. Kaymaz taban.</p>'),('tr',30,'Rahat Köpek Yatağı',NULL,'Çıkarılabilir ve makinede yıkanabilir kapaklı hafızalı köpük ortopedik yatak.','<p>Yüksek yoğunluklu köpük yaşlı evcil hayvanların eklemlerini destekler. Sherpa polar kılıf. M-XL bedenleri mevcuttur. Kaymaz taban.</p>'),('vi',1,'Thức Ăn Cao Cấp Cho Mèo',NULL,'Thức ăn khô không ngũ cốc với cá hồi thật là thành phần đầu tiên và bổ sung taurine.','<p>Công thức dành cho mèo trưởng thành nuôi trong nhà. Đạm thô tối thiểu 38%. Túi 2,5kg có khóa zip tiện lợi. Không phẩm màu hay chất bảo quản nhân tạo.</p>'),('vi',2,'Đồ Chơi Gặm Cho Chó',NULL,'Đồ gặm cao su siêu bền có thể nảy, nổi trên nước và chịu được những chú chó gặm mạnh.','<p>Cao su tự nhiên không độc hại. An toàn khi rửa bằng máy. Lõi rỗng có thể nhồi đồ ăn vặt hoặc bơ đậu phộng. Có các cỡ từ nhỏ đến XL.</p>'),('vi',3,'Trụ Leo Cho Mèo Kiểu Võng Màu Xám',NULL,'Trụ leo ba tầng cho mèo với cột cào bằng dây sisal và hốc nghỉ êm ái bằng vải nhung. Làm từ gỗ thông đặc với võng nhung mềm mại và đệm có thể tháo rời.','<p>Lõi ván dăm bọc vải nhung mềm. Cao 110cm với cột sisal có thể thay thế. Lắp ráp dễ dàng với dụng cụ kèm theo.</p>'),('vi',4,'Dung Dịch Nhỏ Giảm Dị Ứng',NULL,'Dung dịch nhỏ giọt do bác sĩ thú y bào chế, chứa omega-3 và quercetin cho thú cưng bị ngứa và nhạy cảm.','<p>Ống nhỏ giọt dễ định liều. Thêm vào thức ăn hoặc nước uống. Phù hợp cho chó mèo trên 6 tháng tuổi. Chai 60ml.</p>'),('vi',5,'Viên Bổ Sung Tăng Sức Sống',NULL,'Viên nhai đa vitamin hàng ngày với glucosamine, omega-3 và lợi khuẩn cho những chú chó năng động.','<p>Viên nhai mềm vị bò. 90 viên mỗi hộp. Hỗ trợ khớp, lông và tiêu hóa. Sản xuất tại cơ sở được bác sĩ thú y kiểm định.</p>'),('vi',6,'Đai Yếm Cho Chó',NULL,'Đai yếm chống giật có đệm với viền phản quang và hai điểm gắn dây dắt.','<p>Đệm lưới thoáng khí. Điều chỉnh năm điểm vừa vặn. Có cỡ XS-XL. Giặt tay với nước lạnh.</p>'),('vi',7,'Cột Cào Móng Cho Mèo',NULL,'Cột cào móng bằng dây sisal có đế chắc, kích thước phù hợp để mèo cào duỗi người thoải mái.','<p>Cao 70cm với đế MDF có trọng lượng để ổn định. Cột sisal có thể thay thế. Kèm theo một món đồ chơi lông vũ treo.</p>'),('vi',8,'Sữa Tắm Cho Thú Cưng',NULL,'Sữa tắm yến mạch và nha đam làm sạch mà không lấy đi lớp dầu tự nhiên.','<p>Cân bằng độ pH cho chó và mèo. Không chứa xà phòng. Chất hoạt động bề mặt chiết xuất từ dừa. Chai 500ml. Không thử nghiệm trên động vật.</p>'),('vi',9,'Đệm Nằm Êm Ái Cho Chó',NULL,'Đệm nằm chỉnh hình bằng mút hoạt tính với lớp vỏ có thể tháo rời và giặt máy.','<p>Mút mật độ cao nâng đỡ khớp của thú cưng lớn tuổi. Vỏ bọc lông cừu Sherpa. Có cỡ M-XL. Đế chống trượt.</p>'),('vi',10,'Bánh Thưởng Làm Dịu',NULL,'Bánh thưởng nhai mềm với hoa cúc và L-theanine dành cho những tình huống căng thẳng.','<p>Công thức không chứa thuốc. 60 viên mỗi túi. Dùng khi đi du lịch, có bão hoặc đến phòng khám thú y. Phù hợp cho chó trên 12 tuần tuổi.</p>'),('vi',11,'Thức Ăn Cao Cấp Cho Mèo',NULL,'Thức ăn khô không ngũ cốc với cá hồi thật là thành phần đầu tiên và bổ sung taurine.','<p>Công thức dành cho mèo trưởng thành nuôi trong nhà. Đạm thô tối thiểu 38%. Túi 2,5kg có khóa zip tiện lợi. Không phẩm màu hay chất bảo quản nhân tạo.</p>'),('vi',12,'Thức Ăn Cao Cấp Cho Mèo',NULL,'Thức ăn khô không ngũ cốc với cá hồi thật là thành phần đầu tiên và bổ sung taurine.','<p>Công thức dành cho mèo trưởng thành nuôi trong nhà. Đạm thô tối thiểu 38%. Túi 2,5kg có khóa zip tiện lợi. Không phẩm màu hay chất bảo quản nhân tạo.</p>'),('vi',13,'Thức Ăn Cao Cấp Cho Mèo',NULL,'Thức ăn khô không ngũ cốc với cá hồi thật là thành phần đầu tiên và bổ sung taurine.','<p>Công thức dành cho mèo trưởng thành nuôi trong nhà. Đạm thô tối thiểu 38%. Túi 2,5kg có khóa zip tiện lợi. Không phẩm màu hay chất bảo quản nhân tạo.</p>'),('vi',14,'Thức Ăn Cao Cấp Cho Mèo',NULL,'Thức ăn khô không ngũ cốc với cá hồi thật là thành phần đầu tiên và bổ sung taurine.','<p>Công thức dành cho mèo trưởng thành nuôi trong nhà. Đạm thô tối thiểu 38%. Túi 2,5kg có khóa zip tiện lợi. Không phẩm màu hay chất bảo quản nhân tạo.</p>'),('vi',15,'Đồ Chơi Gặm Cho Chó',NULL,'Đồ gặm cao su siêu bền có thể nảy, nổi trên nước và chịu được những chú chó gặm mạnh.','<p>Cao su tự nhiên không độc hại. An toàn khi rửa bằng máy. Lõi rỗng có thể nhồi đồ ăn vặt hoặc bơ đậu phộng. Có các cỡ từ nhỏ đến XL.</p>'),('vi',16,'Đồ Chơi Gặm Cho Chó',NULL,'Đồ gặm cao su siêu bền có thể nảy, nổi trên nước và chịu được những chú chó gặm mạnh.','<p>Cao su tự nhiên không độc hại. An toàn khi rửa bằng máy. Lõi rỗng có thể nhồi đồ ăn vặt hoặc bơ đậu phộng. Có các cỡ từ nhỏ đến XL.</p>'),('vi',17,'Trụ Leo Cho Mèo Kiểu Võng Màu Xám',NULL,'Trụ leo ba tầng cho mèo với cột cào bằng dây sisal và hốc nghỉ êm ái bằng vải nhung. Làm từ gỗ thông đặc với võng nhung mềm mại và đệm có thể tháo rời.','<p>Lõi ván dăm bọc vải nhung mềm. Cao 110cm với cột sisal có thể thay thế. Lắp ráp dễ dàng với dụng cụ kèm theo.</p>'),('vi',18,'Trụ Leo Cho Mèo Kiểu Võng Màu Xám',NULL,'Trụ leo ba tầng cho mèo với cột cào bằng dây sisal và hốc nghỉ êm ái bằng vải nhung. Làm từ gỗ thông đặc với võng nhung mềm mại và đệm có thể tháo rời.','<p>Lõi ván dăm bọc vải nhung mềm. Cao 110cm với cột sisal có thể thay thế. Lắp ráp dễ dàng với dụng cụ kèm theo.</p>'),('vi',19,'Trụ Leo Cho Mèo Kiểu Võng Màu Xám',NULL,'Trụ leo ba tầng cho mèo với cột cào bằng dây sisal và hốc nghỉ êm ái bằng vải nhung. Làm từ gỗ thông đặc với võng nhung mềm mại và đệm có thể tháo rời.','<p>Lõi ván dăm bọc vải nhung mềm. Cao 110cm với cột sisal có thể thay thế. Lắp ráp dễ dàng với dụng cụ kèm theo.</p>'),('vi',20,'Trụ Leo Cho Mèo Kiểu Võng Màu Xám',NULL,'Trụ leo ba tầng cho mèo với cột cào bằng dây sisal và hốc nghỉ êm ái bằng vải nhung. Làm từ gỗ thông đặc với võng nhung mềm mại và đệm có thể tháo rời.','<p>Lõi ván dăm bọc vải nhung mềm. Cao 110cm với cột sisal có thể thay thế. Lắp ráp dễ dàng với dụng cụ kèm theo.</p>'),('vi',21,'Trụ Leo Cho Mèo Kiểu Võng Màu Xám',NULL,'Trụ leo ba tầng cho mèo với cột cào bằng dây sisal và hốc nghỉ êm ái bằng vải nhung. Làm từ gỗ thông đặc với võng nhung mềm mại và đệm có thể tháo rời.','<p>Lõi ván dăm bọc vải nhung mềm. Cao 110cm với cột sisal có thể thay thế. Lắp ráp dễ dàng với dụng cụ kèm theo.</p>'),('vi',22,'Viên Bổ Sung Tăng Sức Sống',NULL,'Viên nhai đa vitamin hàng ngày với glucosamine, omega-3 và lợi khuẩn cho những chú chó năng động.','<p>Viên nhai mềm vị bò. 90 viên mỗi hộp. Hỗ trợ khớp, lông và tiêu hóa. Sản xuất tại cơ sở được bác sĩ thú y kiểm định.</p>'),('vi',23,'Viên Bổ Sung Tăng Sức Sống',NULL,'Viên nhai đa vitamin hàng ngày với glucosamine, omega-3 và lợi khuẩn cho những chú chó năng động.','<p>Viên nhai mềm vị bò. 90 viên mỗi hộp. Hỗ trợ khớp, lông và tiêu hóa. Sản xuất tại cơ sở được bác sĩ thú y kiểm định.</p>'),('vi',24,'Viên Bổ Sung Tăng Sức Sống',NULL,'Viên nhai đa vitamin hàng ngày với glucosamine, omega-3 và lợi khuẩn cho những chú chó năng động.','<p>Viên nhai mềm vị bò. 90 viên mỗi hộp. Hỗ trợ khớp, lông và tiêu hóa. Sản xuất tại cơ sở được bác sĩ thú y kiểm định.</p>'),('vi',25,'Cột Cào Móng Cho Mèo',NULL,'Cột cào móng bằng dây sisal có đế chắc, kích thước phù hợp để mèo cào duỗi người thoải mái.','<p>Cao 70cm với đế MDF có trọng lượng để ổn định. Cột sisal có thể thay thế. Kèm theo một món đồ chơi lông vũ treo.</p>'),('vi',26,'Cột Cào Móng Cho Mèo',NULL,'Cột cào móng bằng dây sisal có đế chắc, kích thước phù hợp để mèo cào duỗi người thoải mái.','<p>Cao 70cm với đế MDF có trọng lượng để ổn định. Cột sisal có thể thay thế. Kèm theo một món đồ chơi lông vũ treo.</p>'),('vi',27,'Cột Cào Móng Cho Mèo',NULL,'Cột cào móng bằng dây sisal có đế chắc, kích thước phù hợp để mèo cào duỗi người thoải mái.','<p>Cao 70cm với đế MDF có trọng lượng để ổn định. Cột sisal có thể thay thế. Kèm theo một món đồ chơi lông vũ treo.</p>'),('vi',28,'Cột Cào Móng Cho Mèo',NULL,'Cột cào móng bằng dây sisal có đế chắc, kích thước phù hợp để mèo cào duỗi người thoải mái.','<p>Cao 70cm với đế MDF có trọng lượng để ổn định. Cột sisal có thể thay thế. Kèm theo một món đồ chơi lông vũ treo.</p>'),('vi',29,'Đệm Nằm Êm Ái Cho Chó',NULL,'Đệm nằm chỉnh hình bằng mút hoạt tính với lớp vỏ có thể tháo rời và giặt máy.','<p>Mút mật độ cao nâng đỡ khớp của thú cưng lớn tuổi. Vỏ bọc lông cừu Sherpa. Có cỡ M-XL. Đế chống trượt.</p>'),('vi',30,'Đệm Nằm Êm Ái Cho Chó',NULL,'Đệm nằm chỉnh hình bằng mút hoạt tính với lớp vỏ có thể tháo rời và giặt máy.','<p>Mút mật độ cao nâng đỡ khớp của thú cưng lớn tuổi. Vỏ bọc lông cừu Sherpa. Có cỡ M-XL. Đế chống trượt.</p>');

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

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

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


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

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

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

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

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

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

--
