--
-- Host: localhost    Database: bagisto_db
-- ------------------------------------------------------


--
-- Table structure for table `addresses`
--

CREATE TABLE `addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `address_type` varchar(255) NOT NULL,
  `parent_address_id` int(10) unsigned DEFAULT NULL,
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'null if guest checkout',
  `cart_id` int(10) unsigned DEFAULT NULL COMMENT 'only for cart_addresses',
  `order_id` int(10) unsigned DEFAULT NULL COMMENT 'only for order_addresses',
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `vat_id` varchar(255) DEFAULT NULL,
  `default_address` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'only for customer_addresses',
  `use_for_shipping` tinyint(1) NOT NULL DEFAULT 0,
  `additional` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`additional`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `addresses_customer_id_foreign` (`customer_id`),
  KEY `addresses_cart_id_foreign` (`cart_id`),
  KEY `addresses_order_id_foreign` (`order_id`),
  KEY `addresses_parent_address_id_foreign` (`parent_address_id`),
  CONSTRAINT `addresses_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `cart` (`id`) ON DELETE CASCADE,
  CONSTRAINT `addresses_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `addresses_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `addresses_parent_address_id_foreign` FOREIGN KEY (`parent_address_id`) REFERENCES `addresses` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `addresses`
--

INSERT INTO `addresses` VALUES (1,'cart_billing',NULL,NULL,1,NULL,'Lourenço','Vilanculo',NULL,'Paytek África','Av. Agostinho Neto, no. 1982, Maputo, Moçambique','Maputo','Please select region, state or province','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,1,NULL,'2026-02-16 23:49:21','2026-02-16 23:49:21'),(2,'cart_shipping',NULL,NULL,1,NULL,'Lourenço','Vilanculo',NULL,'Paytek África','Av. Agostinho Neto, no. 1982, Maputo, Moçambique','Maputo','Please select region, state or province','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-16 23:49:21','2026-02-16 23:49:21'),(3,'order_shipping',NULL,NULL,NULL,1,'Lourenço','Vilanculo',NULL,'Paytek África','Av. Agostinho Neto, no. 1982, Maputo, Moçambique','Maputo','Please select region, state or province','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-16 23:50:04','2026-02-16 23:50:04'),(4,'order_billing',NULL,NULL,NULL,1,'Lourenço','Vilanculo',NULL,'Paytek África','Av. Agostinho Neto, no. 1982, Maputo, Moçambique','Maputo','Please select region, state or province','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-16 23:50:04','2026-02-16 23:50:04'),(5,'customer',NULL,1,NULL,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-17 22:53:13','2026-02-17 22:53:13'),(6,'cart_billing',5,1,3,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,1,NULL,'2026-02-17 22:53:20','2026-02-17 22:53:20'),(7,'cart_shipping',5,1,3,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-17 22:53:20','2026-02-17 22:53:20'),(8,'order_shipping',NULL,NULL,NULL,2,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-17 22:53:41','2026-02-17 22:53:41'),(9,'order_billing',NULL,NULL,NULL,2,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-17 22:53:41','2026-02-17 22:53:41'),(10,'cart_billing',NULL,NULL,4,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,1,NULL,'2026-02-21 23:04:07','2026-02-21 23:04:07'),(11,'cart_shipping',NULL,NULL,4,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-21 23:04:07','2026-02-21 23:04:07'),(12,'order_shipping',NULL,NULL,NULL,3,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-21 23:04:36','2026-02-21 23:04:36'),(13,'order_billing',NULL,NULL,NULL,3,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-21 23:04:36','2026-02-21 23:04:36'),(14,'cart_billing',5,1,5,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,1,NULL,'2026-02-22 00:19:49','2026-02-22 02:05:57'),(15,'cart_shipping',5,1,5,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-22 00:19:49','2026-02-22 01:39:28'),(16,'cart_billing',NULL,NULL,6,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,1,NULL,'2026-02-23 11:24:07','2026-02-23 11:24:07'),(17,'cart_shipping',NULL,NULL,6,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-23 11:24:07','2026-02-23 11:24:07'),(18,'cart_billing',NULL,NULL,7,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,1,NULL,'2026-02-23 11:40:43','2026-02-23 11:40:43'),(19,'cart_shipping',NULL,NULL,7,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-23 11:40:43','2026-02-23 11:40:43'),(20,'order_shipping',NULL,NULL,NULL,4,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-23 12:39:00','2026-02-23 12:39:00'),(21,'order_billing',NULL,NULL,NULL,4,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-23 12:39:00','2026-02-23 12:39:00'),(22,'cart_billing',NULL,NULL,8,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,1,NULL,'2026-02-23 12:42:13','2026-02-23 12:42:13'),(23,'cart_shipping',NULL,NULL,8,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-23 12:42:13','2026-02-23 12:42:13'),(24,'cart_billing',NULL,NULL,9,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','BI','1114','dkayron123@gmail.com','845408577',NULL,0,1,NULL,'2026-02-23 23:42:19','2026-02-23 23:42:19'),(25,'cart_shipping',NULL,NULL,9,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','BI','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-23 23:42:19','2026-02-23 23:42:19'),(28,'order_shipping',NULL,NULL,NULL,5,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-25 20:36:18','2026-02-25 20:36:18'),(29,'order_billing',NULL,NULL,NULL,5,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-25 20:36:18','2026-02-25 20:36:18'),(30,'cart_billing',5,1,13,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,1,NULL,'2026-02-25 20:42:57','2026-02-25 20:42:57'),(31,'cart_shipping',5,1,13,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-25 20:42:57','2026-02-25 20:42:57'),(32,'order_shipping',NULL,NULL,NULL,6,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-25 20:59:54','2026-02-25 20:59:54'),(33,'order_billing',NULL,NULL,NULL,6,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-25 20:59:54','2026-02-25 20:59:54'),(36,'cart_billing',5,1,15,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,1,NULL,'2026-02-25 21:55:43','2026-02-25 21:55:43'),(37,'order_billing',NULL,NULL,NULL,7,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-26 11:06:22','2026-02-26 11:06:22'),(38,'cart_billing',5,1,18,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,1,NULL,'2026-02-26 11:18:00','2026-02-26 11:18:00'),(39,'cart_shipping',5,1,18,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-26 11:18:00','2026-02-26 11:18:00'),(40,'order_shipping',NULL,NULL,NULL,8,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-26 11:32:06','2026-02-26 11:32:06'),(41,'order_billing',NULL,NULL,NULL,8,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-02-26 11:32:06','2026-02-26 11:32:06'),(42,'cart_billing',5,1,19,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,1,NULL,'2026-03-12 00:32:08','2026-03-12 00:32:08'),(43,'cart_shipping',5,1,19,NULL,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-03-14 14:09:45','2026-03-14 14:09:45'),(44,'order_shipping',NULL,NULL,NULL,9,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-03-14 14:15:00','2026-03-14 14:15:00'),(45,'order_billing',NULL,NULL,NULL,9,'Lourenço','Macilau',NULL,'louresintercontinental','sao Damasso','Maputo','RenovacionOrient','MZ','1114','dkayron123@gmail.com','845408577',NULL,0,0,NULL,'2026-03-14 14:15:00','2026-03-14 14:15:00');

--
-- Table structure for table `attribute_families`
--

CREATE TABLE `attribute_families` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `is_user_defined` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attribute_families`
--

INSERT INTO `attribute_families` VALUES (1,'default','Default',0,1);

--
-- Table structure for table `attribute_group_mappings`
--

CREATE TABLE `attribute_group_mappings` (
  `attribute_id` int(10) unsigned NOT NULL,
  `attribute_group_id` int(10) unsigned NOT NULL,
  `position` int(11) DEFAULT NULL,
  PRIMARY KEY (`attribute_id`,`attribute_group_id`),
  KEY `attribute_group_mappings_attribute_group_id_foreign` (`attribute_group_id`),
  CONSTRAINT `attribute_group_mappings_attribute_group_id_foreign` FOREIGN KEY (`attribute_group_id`) REFERENCES `attribute_groups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `attribute_group_mappings_attribute_id_foreign` FOREIGN KEY (`attribute_id`) REFERENCES `attributes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attribute_group_mappings`
--

INSERT INTO `attribute_group_mappings` VALUES (2,1,2),(3,1,3),(5,6,1),(6,6,2),(7,6,3),(8,6,4),(9,2,1),(10,2,2),(11,4,1),(16,3,1),(17,3,2),(18,3,3),(26,6,5),(27,1,1),(28,7,1);

--
-- Table structure for table `attribute_groups`
--

CREATE TABLE `attribute_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL,
  `attribute_family_id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `column` int(11) NOT NULL DEFAULT 1,
  `position` int(11) NOT NULL,
  `is_user_defined` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `attribute_groups_attribute_family_id_name_unique` (`attribute_family_id`,`name`),
  CONSTRAINT `attribute_groups_attribute_family_id_foreign` FOREIGN KEY (`attribute_family_id`) REFERENCES `attribute_families` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attribute_groups`
--

INSERT INTO `attribute_groups` VALUES (1,'general',1,'General',1,1,0),(2,'description',1,'Description',1,3,0),(3,'meta_description',1,'Meta Description',1,4,0),(4,'price',1,'Price',1,2,0),(5,'shipping',1,'Shipping',2,3,0),(6,'settings',1,'Settings',2,1,0),(7,'inventories',1,'Inventories',2,2,0);

--
-- Table structure for table `attribute_option_translations`
--

CREATE TABLE `attribute_option_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_option_id` int(10) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `label` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `attribute_option_locale_unique` (`attribute_option_id`,`locale`),
  CONSTRAINT `attribute_option_translations_attribute_option_id_foreign` FOREIGN KEY (`attribute_option_id`) REFERENCES `attribute_options` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attribute_option_translations`
--

INSERT INTO `attribute_option_translations` VALUES (10,1,'en','Red'),(11,2,'en','Green'),(12,3,'en','Yellow'),(13,4,'en','Black'),(14,5,'en','White'),(15,6,'en','S'),(16,7,'en','M'),(17,8,'en','L'),(18,9,'en','XL');

--
-- Table structure for table `attribute_options`
--

CREATE TABLE `attribute_options` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_id` int(10) unsigned NOT NULL,
  `admin_name` varchar(255) DEFAULT NULL,
  `sort_order` int(11) DEFAULT NULL,
  `swatch_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attribute_options_attribute_id_foreign` (`attribute_id`),
  CONSTRAINT `attribute_options_attribute_id_foreign` FOREIGN KEY (`attribute_id`) REFERENCES `attributes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attribute_options`
--

INSERT INTO `attribute_options` VALUES (1,23,'Red',1,NULL),(2,23,'Green',2,NULL),(3,23,'Yellow',3,NULL),(4,23,'Black',4,NULL),(5,23,'White',5,NULL),(6,24,'S',1,NULL),(7,24,'M',2,NULL),(8,24,'L',3,NULL),(9,24,'XL',4,NULL);

--
-- Table structure for table `attribute_translations`
--

CREATE TABLE `attribute_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_id` int(10) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `name` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `attribute_translations_attribute_id_locale_unique` (`attribute_id`,`locale`),
  CONSTRAINT `attribute_translations_attribute_id_foreign` FOREIGN KEY (`attribute_id`) REFERENCES `attributes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attribute_translations`
--

INSERT INTO `attribute_translations` VALUES (29,1,'en','SKU'),(30,2,'en','Name'),(31,3,'en','URL Key'),(32,4,'en','Tax Category'),(33,5,'en','New'),(34,6,'en','Featured'),(35,7,'en','Visible Individually'),(36,8,'en','Status'),(37,9,'en','Short Description'),(38,10,'en','Description'),(39,11,'en','Price'),(40,12,'en','Cost'),(41,13,'en','Special Price'),(42,14,'en','Special Price From'),(43,15,'en','Special Price To'),(44,16,'en','Meta Title'),(45,17,'en','Meta Keywords'),(46,18,'en','Meta Description'),(47,19,'en','Length'),(48,20,'en','Width'),(49,21,'en','Height'),(50,22,'en','Weight'),(51,23,'en','Color'),(52,24,'en','Size'),(53,25,'en','Brand'),(54,26,'en','Guest Checkout'),(55,27,'en','Product Number'),(56,28,'en','Manage Stock'),(57,3,'pt_BR','Url_key'),(58,1,'pt_BR','');

--
-- Table structure for table `attributes`
--

CREATE TABLE `attributes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `admin_name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `swatch_type` varchar(255) DEFAULT NULL,
  `validation` varchar(255) DEFAULT NULL,
  `regex` varchar(255) DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  `is_required` tinyint(1) NOT NULL DEFAULT 0,
  `is_unique` tinyint(1) NOT NULL DEFAULT 0,
  `is_filterable` tinyint(1) NOT NULL DEFAULT 0,
  `is_comparable` tinyint(1) NOT NULL DEFAULT 0,
  `is_configurable` tinyint(1) NOT NULL DEFAULT 0,
  `is_user_defined` tinyint(1) NOT NULL DEFAULT 1,
  `is_visible_on_front` tinyint(1) NOT NULL DEFAULT 0,
  `value_per_locale` tinyint(1) NOT NULL DEFAULT 0,
  `value_per_channel` tinyint(1) NOT NULL DEFAULT 0,
  `default_value` int(11) DEFAULT NULL,
  `enable_wysiwyg` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `attributes_code_unique` (`code`),
  KEY `attributes_code_index` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attributes`
--

INSERT INTO `attributes` VALUES (1,'sku','SKU','text',NULL,NULL,NULL,1,0,1,0,0,0,0,0,0,0,NULL,0,'2026-02-16 20:08:27','2026-03-14 13:27:27'),(2,'name','Name','text',NULL,NULL,NULL,3,1,0,0,1,0,0,0,1,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(3,'url_key','URL Key','text',NULL,NULL,NULL,4,0,1,0,0,0,0,0,0,0,NULL,0,'2026-02-16 20:08:27','2026-03-14 13:26:57'),(4,'tax_category_id','Tax Category','select',NULL,NULL,NULL,5,0,0,0,0,0,0,0,0,1,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(5,'new','New','boolean',NULL,NULL,NULL,6,0,0,0,0,0,0,0,0,0,1,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(6,'featured','Featured','boolean',NULL,NULL,NULL,7,0,0,0,0,0,0,0,0,0,1,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(7,'visible_individually','Visible Individually','boolean',NULL,NULL,NULL,9,1,0,0,0,0,0,0,0,0,1,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(8,'status','Status','boolean',NULL,NULL,NULL,10,1,0,0,0,0,0,0,0,1,1,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(9,'short_description','Short Description','textarea',NULL,NULL,NULL,11,1,0,0,0,0,0,0,1,0,NULL,1,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(10,'description','Description','textarea',NULL,NULL,NULL,12,1,0,0,1,0,0,0,1,0,NULL,1,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(11,'price','Price','price',NULL,'decimal',NULL,13,1,0,1,1,0,0,0,0,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(12,'cost','Cost','price',NULL,'decimal',NULL,14,0,0,0,0,0,1,0,0,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(13,'special_price','Special Price','price',NULL,'decimal',NULL,15,0,0,0,0,0,0,0,0,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(14,'special_price_from','Special Price From','date',NULL,NULL,NULL,16,0,0,0,0,0,0,0,0,1,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(15,'special_price_to','Special Price To','date',NULL,NULL,NULL,17,0,0,0,0,0,0,0,0,1,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(16,'meta_title','Meta Title','textarea',NULL,NULL,NULL,18,0,0,0,0,0,0,0,1,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(17,'meta_keywords','Meta Keywords','textarea',NULL,NULL,NULL,20,0,0,0,0,0,0,0,1,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(18,'meta_description','Meta Description','textarea',NULL,NULL,NULL,21,0,0,0,0,0,1,0,1,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(19,'length','Length','text',NULL,'decimal',NULL,22,0,0,0,0,0,1,0,0,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(20,'width','Width','text',NULL,'decimal',NULL,23,0,0,0,0,0,1,0,0,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(21,'height','Height','text',NULL,'decimal',NULL,24,0,0,0,0,0,1,0,0,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(22,'weight','Weight','text',NULL,'decimal',NULL,25,1,0,0,0,0,0,0,0,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(23,'color','Color','select',NULL,NULL,NULL,26,0,0,1,0,1,1,0,0,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(24,'size','Size','select',NULL,NULL,NULL,27,0,0,1,0,1,1,0,0,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(25,'brand','Brand','select',NULL,NULL,NULL,28,0,0,1,0,0,1,1,0,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(26,'guest_checkout','Guest Checkout','boolean',NULL,NULL,NULL,8,1,0,0,0,0,0,0,0,0,1,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(27,'product_number','Product Number','text',NULL,NULL,NULL,2,0,1,0,0,0,0,0,0,0,NULL,0,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(28,'manage_stock','Manage Stock','boolean',NULL,NULL,NULL,1,0,0,0,0,0,0,0,0,1,1,0,'2026-02-16 20:08:27','2026-02-16 20:08:27');

--
-- Table structure for table `booking_product_appointment_slots`
--

CREATE TABLE `booking_product_appointment_slots` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_product_id` int(10) unsigned NOT NULL,
  `duration` int(11) DEFAULT NULL,
  `break_time` int(11) DEFAULT NULL,
  `same_slot_all_days` tinyint(1) DEFAULT NULL,
  `slots` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`slots`)),
  PRIMARY KEY (`id`),
  KEY `booking_product_appointment_slots_booking_product_id_foreign` (`booking_product_id`),
  CONSTRAINT `booking_product_appointment_slots_booking_product_id_foreign` FOREIGN KEY (`booking_product_id`) REFERENCES `booking_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `booking_product_appointment_slots`
--


--
-- Table structure for table `booking_product_default_slots`
--

CREATE TABLE `booking_product_default_slots` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_product_id` int(10) unsigned NOT NULL,
  `booking_type` varchar(255) NOT NULL,
  `duration` int(11) DEFAULT NULL,
  `break_time` int(11) DEFAULT NULL,
  `slots` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`slots`)),
  PRIMARY KEY (`id`),
  KEY `booking_product_default_slots_booking_product_id_foreign` (`booking_product_id`),
  CONSTRAINT `booking_product_default_slots_booking_product_id_foreign` FOREIGN KEY (`booking_product_id`) REFERENCES `booking_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `booking_product_default_slots`
--


--
-- Table structure for table `booking_product_event_ticket_translations`
--

CREATE TABLE `booking_product_event_ticket_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_product_event_ticket_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `name` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bpet_locale_unique` (`booking_product_event_ticket_id`,`locale`),
  CONSTRAINT `bpet_translations_fk` FOREIGN KEY (`booking_product_event_ticket_id`) REFERENCES `booking_product_event_tickets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `booking_product_event_ticket_translations`
--


--
-- Table structure for table `booking_product_event_tickets`
--

CREATE TABLE `booking_product_event_tickets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_product_id` int(10) unsigned NOT NULL,
  `price` decimal(12,4) DEFAULT 0.0000,
  `qty` int(11) DEFAULT 0,
  `special_price` decimal(12,4) DEFAULT NULL,
  `special_price_from` datetime DEFAULT NULL,
  `special_price_to` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `booking_product_event_tickets_booking_product_id_foreign` (`booking_product_id`),
  CONSTRAINT `booking_product_event_tickets_booking_product_id_foreign` FOREIGN KEY (`booking_product_id`) REFERENCES `booking_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `booking_product_event_tickets`
--


--
-- Table structure for table `booking_product_rental_slots`
--

CREATE TABLE `booking_product_rental_slots` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_product_id` int(10) unsigned NOT NULL,
  `renting_type` varchar(255) NOT NULL,
  `daily_price` decimal(12,4) DEFAULT 0.0000,
  `hourly_price` decimal(12,4) DEFAULT 0.0000,
  `same_slot_all_days` tinyint(1) DEFAULT NULL,
  `slots` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`slots`)),
  PRIMARY KEY (`id`),
  KEY `booking_product_rental_slots_booking_product_id_foreign` (`booking_product_id`),
  CONSTRAINT `booking_product_rental_slots_booking_product_id_foreign` FOREIGN KEY (`booking_product_id`) REFERENCES `booking_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `booking_product_rental_slots`
--


--
-- Table structure for table `booking_product_table_slots`
--

CREATE TABLE `booking_product_table_slots` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `booking_product_id` int(10) unsigned NOT NULL,
  `price_type` varchar(255) NOT NULL,
  `guest_limit` int(11) NOT NULL DEFAULT 0,
  `duration` int(11) NOT NULL,
  `break_time` int(11) NOT NULL,
  `prevent_scheduling_before` int(11) NOT NULL,
  `same_slot_all_days` tinyint(1) DEFAULT NULL,
  `slots` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`slots`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `booking_product_table_slots_booking_product_id_foreign` (`booking_product_id`),
  CONSTRAINT `booking_product_table_slots_booking_product_id_foreign` FOREIGN KEY (`booking_product_id`) REFERENCES `booking_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `booking_product_table_slots`
--


--
-- Table structure for table `booking_products`
--

CREATE TABLE `booking_products` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(10) unsigned NOT NULL,
  `type` varchar(255) NOT NULL,
  `qty` int(11) DEFAULT 0,
  `location` varchar(255) DEFAULT NULL,
  `show_location` tinyint(1) NOT NULL DEFAULT 0,
  `available_every_week` tinyint(1) DEFAULT NULL,
  `available_from` datetime DEFAULT NULL,
  `available_to` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `booking_products_product_id_foreign` (`product_id`),
  CONSTRAINT `booking_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `booking_products`
--


--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(10) unsigned DEFAULT NULL,
  `order_item_id` int(10) unsigned DEFAULT NULL,
  `order_id` int(10) unsigned DEFAULT NULL,
  `qty` int(11) DEFAULT 0,
  `from` int(11) DEFAULT NULL,
  `to` int(11) DEFAULT NULL,
  `booking_product_event_ticket_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bookings_order_item_id_foreign` (`order_item_id`),
  KEY `bookings_booking_product_event_ticket_id_foreign` (`booking_product_event_ticket_id`),
  KEY `bookings_order_id_foreign` (`order_id`),
  KEY `bookings_product_id_foreign` (`product_id`),
  CONSTRAINT `bookings_booking_product_event_ticket_id_foreign` FOREIGN KEY (`booking_product_event_ticket_id`) REFERENCES `booking_product_event_tickets` (`id`) ON DELETE SET NULL,
  CONSTRAINT `bookings_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL,
  CONSTRAINT `bookings_order_item_id_foreign` FOREIGN KEY (`order_item_id`) REFERENCES `order_items` (`id`) ON DELETE SET NULL,
  CONSTRAINT `bookings_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bookings`
--


--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_email` varchar(255) DEFAULT NULL,
  `customer_first_name` varchar(255) DEFAULT NULL,
  `customer_last_name` varchar(255) DEFAULT NULL,
  `shipping_method` varchar(255) DEFAULT NULL,
  `coupon_code` varchar(255) DEFAULT NULL,
  `is_gift` tinyint(1) NOT NULL DEFAULT 0,
  `items_count` int(11) DEFAULT NULL,
  `items_qty` decimal(12,4) DEFAULT NULL,
  `exchange_rate` decimal(12,4) DEFAULT NULL,
  `global_currency_code` varchar(255) DEFAULT NULL,
  `base_currency_code` varchar(255) DEFAULT NULL,
  `channel_currency_code` varchar(255) DEFAULT NULL,
  `cart_currency_code` varchar(255) DEFAULT NULL,
  `grand_total` decimal(12,4) DEFAULT 0.0000,
  `base_grand_total` decimal(12,4) DEFAULT 0.0000,
  `sub_total` decimal(12,4) DEFAULT 0.0000,
  `base_sub_total` decimal(12,4) DEFAULT 0.0000,
  `tax_total` decimal(12,4) DEFAULT 0.0000,
  `base_tax_total` decimal(12,4) DEFAULT 0.0000,
  `discount_amount` decimal(12,4) DEFAULT 0.0000,
  `base_discount_amount` decimal(12,4) DEFAULT 0.0000,
  `shipping_amount` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_shipping_amount` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `shipping_amount_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_shipping_amount_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `sub_total_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_sub_total_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `checkout_method` varchar(255) DEFAULT NULL,
  `is_guest` tinyint(1) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `applied_cart_rule_ids` varchar(255) DEFAULT NULL,
  `customer_id` int(10) unsigned DEFAULT NULL,
  `channel_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cart_customer_id_foreign` (`customer_id`),
  KEY `cart_channel_id_foreign` (`channel_id`),
  CONSTRAINT `cart_channel_id_foreign` FOREIGN KEY (`channel_id`) REFERENCES `channels` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cart_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart`
--

INSERT INTO `cart` VALUES (1,'dkayron123@gmail.com','Lourenço','Vilanculo','free_free',NULL,0,1,2.0000,NULL,'USD','USD','USD','USD',200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,NULL,1,0,NULL,NULL,1,'2026-02-16 23:48:15','2026-02-16 23:50:13'),(2,NULL,NULL,NULL,NULL,NULL,0,1,110.0000,NULL,'USD','USD','USD','USD',11000.0000,11000.0000,11000.0000,11000.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,11000.0000,11000.0000,NULL,1,1,NULL,NULL,1,'2026-02-17 12:01:56','2026-02-17 12:02:03'),(3,'costumer@gmail.com','Lourenço','Macilau','flatrate_flatrate',NULL,0,1,2.0000,NULL,'USD','USD','USD','USD',220.0000,220.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,20.0000,20.0000,20.0000,20.0000,200.0000,200.0000,NULL,0,0,NULL,1,1,'2026-02-17 22:51:45','2026-02-17 22:53:54'),(4,'dkayron123@gmail.com','Lourenço','Macilau','free_free',NULL,0,1,2.0000,NULL,'USD','USD','USD','USD',200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,NULL,1,0,NULL,NULL,1,'2026-02-21 23:03:34','2026-02-21 23:04:46'),(5,'costumer@gmail.com','Lourenço','Macilau','free_free',NULL,0,1,4.0000,NULL,'USD','USD','USD','MZN',400.0000,400.0000,400.0000,400.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,400.0000,400.0000,NULL,0,0,NULL,1,1,'2026-02-22 00:19:16','2026-02-25 20:36:30'),(6,'dkayron123@gmail.com','Lourenço','Macilau','free_free',NULL,0,1,2.0000,NULL,'USD','USD','USD','USD',200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,NULL,1,0,NULL,NULL,1,'2026-02-23 11:23:44','2026-02-23 12:39:13'),(7,'dkayron123@gmail.com','Lourenço','Macilau',NULL,NULL,0,1,1.0000,NULL,'USD','USD','USD','USD',100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,NULL,1,1,NULL,NULL,1,'2026-02-23 11:40:13','2026-02-23 11:40:57'),(8,'dkayron123@gmail.com','Lourenço','Macilau','free_free',NULL,0,1,1.0000,NULL,'USD','USD','USD','USD',100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,NULL,1,1,NULL,NULL,1,'2026-02-23 12:41:38','2026-02-23 12:42:22'),(9,'dkayron123@gmail.com','Lourenço','Macilau','free_free',NULL,0,1,1.0000,NULL,'USD','USD','USD','USD',100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,NULL,1,1,NULL,NULL,1,'2026-02-23 23:41:43','2026-02-24 00:50:51'),(13,'costumer@gmail.com','Lourenço','Macilau','free_free',NULL,0,1,1.0000,NULL,'USD','USD','MZN','MZN',100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,NULL,0,0,NULL,1,1,'2026-02-25 20:41:48','2026-02-25 21:00:00'),(15,'costumer@gmail.com','Lourenço','Macilau',NULL,NULL,0,1,2.0000,NULL,'USD','USD','MZN','MZN',400.0000,400.0000,400.0000,400.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,400.0000,200.0000,NULL,0,0,NULL,1,1,'2026-02-25 21:55:30','2026-02-26 11:06:32'),(18,'costumer@gmail.com','Lourenço','Macilau','free_free',NULL,0,1,1.0000,NULL,'USD','USD','MZN','MZN',100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,NULL,0,0,NULL,1,1,'2026-02-26 11:17:41','2026-02-26 11:32:12'),(19,'costumer@gmail.com','Lourenço','Macilau','free_free',NULL,0,1,2.0000,NULL,'USD','USD','MZN','MZN',800.0000,800.0000,800.0000,800.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,800.0000,800.0000,NULL,0,0,NULL,1,1,'2026-03-12 00:08:05','2026-03-14 14:15:17'),(24,'seller2@example.com','Seller','seller2',NULL,NULL,0,1,1.0000,NULL,'USD','USD','MZN','MZN',400.0000,400.0000,400.0000,400.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,400.0000,400.0000,NULL,0,1,NULL,1,1,'2026-03-14 21:06:32','2026-03-14 21:54:33');

--
-- Table structure for table `cart_item_inventories`
--

CREATE TABLE `cart_item_inventories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `qty` int(10) unsigned NOT NULL DEFAULT 0,
  `inventory_source_id` int(10) unsigned DEFAULT NULL,
  `cart_item_id` int(10) unsigned 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 `cart_item_inventories`
--


--
-- Table structure for table `cart_items`
--

CREATE TABLE `cart_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `quantity` int(10) unsigned NOT NULL DEFAULT 0,
  `sku` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `coupon_code` varchar(255) DEFAULT NULL,
  `weight` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `total_weight` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_total_weight` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `price` decimal(12,4) NOT NULL DEFAULT 1.0000,
  `base_price` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `custom_price` decimal(12,4) DEFAULT NULL,
  `total` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_total` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `tax_percent` decimal(12,4) DEFAULT 0.0000,
  `tax_amount` decimal(12,4) DEFAULT 0.0000,
  `base_tax_amount` decimal(12,4) DEFAULT 0.0000,
  `discount_percent` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `price_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_price_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `total_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_total_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `applied_tax_rate` varchar(255) DEFAULT NULL,
  `parent_id` int(10) unsigned DEFAULT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `cart_id` int(10) unsigned NOT NULL,
  `tax_category_id` int(10) unsigned DEFAULT NULL,
  `applied_cart_rule_ids` varchar(255) DEFAULT NULL,
  `additional` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`additional`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cart_items_parent_id_foreign` (`parent_id`),
  KEY `cart_items_product_id_foreign` (`product_id`),
  KEY `cart_items_cart_id_foreign` (`cart_id`),
  KEY `cart_items_tax_category_id_foreign` (`tax_category_id`),
  CONSTRAINT `cart_items_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `cart` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cart_items_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `cart_items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cart_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cart_items_tax_category_id_foreign` FOREIGN KEY (`tax_category_id`) REFERENCES `tax_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart_items`
--

INSERT INTO `cart_items` VALUES (1,2,'Bla','simple','Bola',NULL,10.0000,20.0000,20.0000,100.0000,100.0000,NULL,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,200.0000,200.0000,NULL,NULL,1,1,NULL,NULL,'{\"product_id\":\"1\",\"is_buy_now\":\"0\",\"quantity\":2,\"cart_id\":1,\"attributes\":[]}','2026-02-16 23:48:16','2026-02-16 23:48:16'),(2,110,'Bla','simple','Bola',NULL,10.0000,1100.0000,1100.0000,100.0000,100.0000,NULL,11000.0000,11000.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,11000.0000,11000.0000,NULL,NULL,1,2,NULL,NULL,'{\"product_id\":\"1\",\"is_buy_now\":\"0\",\"quantity\":110,\"cart_id\":2,\"attributes\":[]}','2026-02-17 12:01:56','2026-02-17 12:01:56'),(3,2,'Bla','simple','Bola',NULL,10.0000,20.0000,20.0000,100.0000,100.0000,NULL,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,200.0000,200.0000,NULL,NULL,1,3,NULL,NULL,'{\"product_id\":\"1\",\"is_buy_now\":\"0\",\"quantity\":2,\"cart_id\":3,\"attributes\":[]}','2026-02-17 22:51:45','2026-02-17 22:51:45'),(4,2,'Bla','simple','Bola',NULL,10.0000,20.0000,20.0000,100.0000,100.0000,NULL,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,200.0000,200.0000,NULL,NULL,1,4,NULL,NULL,'{\"quantity\":2,\"product_id\":1,\"cart_id\":4,\"attributes\":[]}','2026-02-21 23:03:34','2026-02-21 23:03:38'),(5,4,'Bla','simple',NULL,NULL,10.0000,40.0000,40.0000,100.0000,100.0000,NULL,400.0000,400.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,400.0000,400.0000,NULL,NULL,1,5,NULL,NULL,'{\"quantity\":4,\"product_id\":1,\"cart_id\":5,\"attributes\":[]}','2026-02-22 00:19:16','2026-02-25 19:51:26'),(6,2,'Bla','simple',NULL,NULL,10.0000,20.0000,20.0000,100.0000,100.0000,NULL,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,200.0000,200.0000,NULL,NULL,1,6,NULL,NULL,'{\"quantity\":2,\"product_id\":1,\"cart_id\":6,\"attributes\":[]}','2026-02-23 11:23:45','2026-02-23 12:37:53'),(7,1,'Bla','simple',NULL,NULL,10.0000,10.0000,10.0000,100.0000,100.0000,NULL,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,100.0000,100.0000,NULL,NULL,1,7,NULL,NULL,'{\"quantity\":1,\"product_id\":1,\"cart_id\":7,\"attributes\":[]}','2026-02-23 11:40:14','2026-02-23 11:40:14'),(8,1,'Bla','simple',NULL,NULL,10.0000,10.0000,10.0000,100.0000,100.0000,NULL,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,100.0000,100.0000,NULL,NULL,1,8,NULL,NULL,'{\"quantity\":1,\"product_id\":1,\"cart_id\":8,\"attributes\":[]}','2026-02-23 12:41:38','2026-02-23 12:41:38'),(9,1,'Bla','simple',NULL,NULL,10.0000,10.0000,10.0000,100.0000,100.0000,NULL,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,100.0000,100.0000,NULL,NULL,1,9,NULL,NULL,'{\"quantity\":1,\"product_id\":1,\"cart_id\":9,\"attributes\":[]}','2026-02-23 23:41:43','2026-02-23 23:41:43'),(13,1,'Bla','simple',NULL,NULL,10.0000,10.0000,10.0000,100.0000,100.0000,NULL,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,100.0000,100.0000,NULL,NULL,1,13,NULL,NULL,'{\"quantity\":1,\"product_id\":1,\"cart_id\":13,\"attributes\":[]}','2026-02-25 20:41:48','2026-02-25 20:41:48'),(15,2,'Agua','downloadable','Agua Mineral',NULL,0.0000,0.0000,0.0000,200.0000,200.0000,NULL,400.0000,400.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,400.0000,200.0000,NULL,NULL,2,15,NULL,NULL,'{\"product_id\":2,\"is_buy_now\":\"0\",\"links\":[\"1\"],\"Seller_Rating\":\"0.0\",\"quantity\":2,\"seller_info\":{\"product_id\":1,\"seller_id\":2,\"is_owner\":1},\"cart_id\":15,\"attributes\":[{\"attribute_name\":\"Downloads\",\"option_id\":0,\"option_label\":\"AguaDownload\"},{\"attribute_type\":\"marketplace\",\"attribute_name\":\"Vendido por\",\"option_label\":\"seller2\"}]}','2026-02-25 21:55:30','2026-02-26 11:05:23'),(17,1,'Bla','simple',NULL,NULL,10.0000,10.0000,10.0000,100.0000,100.0000,NULL,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,100.0000,100.0000,NULL,NULL,1,18,NULL,NULL,'{\"quantity\":1,\"product_id\":1,\"cart_id\":18,\"attributes\":[]}','2026-02-26 11:17:41','2026-02-26 11:17:41'),(22,2,'Bolachas','simple','Bolacha Maria',NULL,0.0000,0.0000,0.0000,400.0000,400.0000,NULL,800.0000,800.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,400.0000,400.0000,800.0000,800.0000,NULL,NULL,4,19,NULL,NULL,'{\"product_id\":4,\"quantity\":2,\"is_buy_now\":0,\"cart_id\":19,\"attributes\":[]}','2026-03-14 13:35:14','2026-03-14 13:50:49'),(24,1,'Bolachas','simple','Bolacha Maria',NULL,0.0000,0.0000,0.0000,400.0000,400.0000,NULL,400.0000,400.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,400.0000,400.0000,400.0000,400.0000,NULL,NULL,4,24,NULL,NULL,'{\"product_id\":\"4\",\"is_buy_now\":\"0\",\"quantity\":1,\"cart_id\":24,\"attributes\":[]}','2026-03-14 21:06:32','2026-03-14 21:06:32');

--
-- Table structure for table `cart_payment`
--

CREATE TABLE `cart_payment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `method` varchar(255) NOT NULL,
  `method_title` varchar(255) DEFAULT NULL,
  `cart_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cart_payment_cart_id_foreign` (`cart_id`),
  CONSTRAINT `cart_payment_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `cart` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart_payment`
--

INSERT INTO `cart_payment` VALUES (1,'moneytransfer','Money Transfer',1,'2026-02-16 23:50:02','2026-02-16 23:50:02'),(2,'cashondelivery','M-pesa',3,'2026-02-17 22:53:39','2026-02-17 22:53:39'),(3,'cashondelivery','M-pesa',4,'2026-02-21 23:04:31','2026-02-21 23:04:31'),(4,'cashondelivery','Cash On Delivery',6,'2026-02-23 12:38:57','2026-02-23 12:38:57'),(7,'mpesa','M-Pesa',9,'2026-02-24 00:44:51','2026-02-24 00:44:51'),(60,'mpesa','M-Pesa',5,'2026-02-25 20:35:55','2026-02-25 20:35:55'),(62,'mpesa','M-Pesa',13,'2026-02-25 20:59:26','2026-02-25 20:59:26'),(66,'mpesa','M-Pesa',15,'2026-02-26 11:05:56','2026-02-26 11:05:56'),(69,'mkesh','MKesh',18,'2026-02-26 11:30:58','2026-02-26 11:30:58'),(106,'mpesa','M-Pesa',19,'2026-03-14 14:09:36','2026-03-14 14:09:36'),(109,'bnpl','Buy Now Pay Later (BNPL)',24,'2026-03-14 21:13:43','2026-03-14 21:13:43');

--
-- Table structure for table `cart_rule_channels`
--

CREATE TABLE `cart_rule_channels` (
  `cart_rule_id` int(10) unsigned NOT NULL,
  `channel_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`cart_rule_id`,`channel_id`),
  KEY `cart_rule_channels_channel_id_foreign` (`channel_id`),
  CONSTRAINT `cart_rule_channels_cart_rule_id_foreign` FOREIGN KEY (`cart_rule_id`) REFERENCES `cart_rules` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cart_rule_channels_channel_id_foreign` FOREIGN KEY (`channel_id`) REFERENCES `channels` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart_rule_channels`
--


--
-- Table structure for table `cart_rule_coupon_usage`
--

CREATE TABLE `cart_rule_coupon_usage` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `times_used` int(11) NOT NULL DEFAULT 0,
  `cart_rule_coupon_id` int(10) unsigned NOT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cart_rule_coupon_usage_cart_rule_coupon_id_foreign` (`cart_rule_coupon_id`),
  KEY `cart_rule_coupon_usage_customer_id_foreign` (`customer_id`),
  CONSTRAINT `cart_rule_coupon_usage_cart_rule_coupon_id_foreign` FOREIGN KEY (`cart_rule_coupon_id`) REFERENCES `cart_rule_coupons` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cart_rule_coupon_usage_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart_rule_coupon_usage`
--


--
-- Table structure for table `cart_rule_coupons`
--

CREATE TABLE `cart_rule_coupons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL,
  `usage_limit` int(10) unsigned NOT NULL DEFAULT 0,
  `usage_per_customer` int(10) unsigned NOT NULL DEFAULT 0,
  `times_used` int(10) unsigned NOT NULL DEFAULT 0,
  `type` int(10) unsigned NOT NULL DEFAULT 0,
  `is_primary` tinyint(1) NOT NULL DEFAULT 0,
  `expired_at` date DEFAULT NULL,
  `cart_rule_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cart_rule_coupons_cart_rule_id_foreign` (`cart_rule_id`),
  CONSTRAINT `cart_rule_coupons_cart_rule_id_foreign` FOREIGN KEY (`cart_rule_id`) REFERENCES `cart_rules` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart_rule_coupons`
--


--
-- Table structure for table `cart_rule_customer_groups`
--

CREATE TABLE `cart_rule_customer_groups` (
  `cart_rule_id` int(10) unsigned NOT NULL,
  `customer_group_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`cart_rule_id`,`customer_group_id`),
  KEY `cart_rule_customer_groups_customer_group_id_foreign` (`customer_group_id`),
  CONSTRAINT `cart_rule_customer_groups_cart_rule_id_foreign` FOREIGN KEY (`cart_rule_id`) REFERENCES `cart_rules` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cart_rule_customer_groups_customer_group_id_foreign` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart_rule_customer_groups`
--


--
-- Table structure for table `cart_rule_customers`
--

CREATE TABLE `cart_rule_customers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `times_used` bigint(20) unsigned NOT NULL DEFAULT 0,
  `customer_id` int(10) unsigned NOT NULL,
  `cart_rule_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cart_rule_customers_cart_rule_id_foreign` (`cart_rule_id`),
  KEY `cart_rule_customers_customer_id_foreign` (`customer_id`),
  CONSTRAINT `cart_rule_customers_cart_rule_id_foreign` FOREIGN KEY (`cart_rule_id`) REFERENCES `cart_rules` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cart_rule_customers_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart_rule_customers`
--


--
-- Table structure for table `cart_rule_translations`
--

CREATE TABLE `cart_rule_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `locale` varchar(255) NOT NULL,
  `label` text DEFAULT NULL,
  `cart_rule_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cart_rule_translations_cart_rule_id_locale_unique` (`cart_rule_id`,`locale`),
  CONSTRAINT `cart_rule_translations_cart_rule_id_foreign` FOREIGN KEY (`cart_rule_id`) REFERENCES `cart_rules` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart_rule_translations`
--


--
-- Table structure for table `cart_rules`
--

CREATE TABLE `cart_rules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `starts_from` datetime DEFAULT NULL,
  `ends_till` datetime DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `coupon_type` int(11) NOT NULL DEFAULT 1,
  `use_auto_generation` tinyint(1) NOT NULL DEFAULT 0,
  `usage_per_customer` int(11) NOT NULL DEFAULT 0,
  `uses_per_coupon` int(11) NOT NULL DEFAULT 0,
  `times_used` int(10) unsigned NOT NULL DEFAULT 0,
  `condition_type` tinyint(1) NOT NULL DEFAULT 1,
  `conditions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`conditions`)),
  `end_other_rules` tinyint(1) NOT NULL DEFAULT 0,
  `uses_attribute_conditions` tinyint(1) NOT NULL DEFAULT 0,
  `action_type` varchar(255) DEFAULT NULL,
  `discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `discount_quantity` int(11) NOT NULL DEFAULT 1,
  `discount_step` varchar(255) NOT NULL DEFAULT '1',
  `apply_to_shipping` tinyint(1) NOT NULL DEFAULT 0,
  `free_shipping` tinyint(1) NOT NULL DEFAULT 0,
  `sort_order` int(10) unsigned 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 `cart_rules`
--


--
-- Table structure for table `cart_shipping_rates`
--

CREATE TABLE `cart_shipping_rates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `carrier` varchar(255) NOT NULL,
  `carrier_title` varchar(255) NOT NULL,
  `method` varchar(255) NOT NULL,
  `method_title` varchar(255) NOT NULL,
  `method_description` varchar(255) DEFAULT NULL,
  `price` double DEFAULT 0,
  `base_price` double DEFAULT 0,
  `discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `tax_percent` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `tax_amount` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_tax_amount` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `price_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_price_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `applied_tax_rate` varchar(255) DEFAULT NULL,
  `is_calculate_tax` tinyint(1) NOT NULL DEFAULT 1,
  `cart_address_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `cart_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cart_shipping_rates_cart_id_foreign` (`cart_id`),
  CONSTRAINT `cart_shipping_rates_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `cart` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6306 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart_shipping_rates`
--

INSERT INTO `cart_shipping_rates` VALUES (3,'flatrate','Flat Rate','flatrate_flatrate','Flat Rate','Flat Rate Shipping',20,20,0.0000,0.0000,0.0000,0.0000,0.0000,20.0000,20.0000,NULL,1,2,'2026-02-16 23:49:29','2026-02-16 23:49:29',1),(4,'free','Free Shipping','free_free','Free Shipping','Free Shipping',0,0,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,1,2,'2026-02-16 23:49:29','2026-02-16 23:49:29',1),(7,'flatrate','Flat Rate','flatrate_flatrate','Flat Rate','Flat Rate Shipping',20,20,0.0000,0.0000,0.0000,0.0000,0.0000,20.0000,20.0000,NULL,1,7,'2026-02-17 22:53:26','2026-02-17 22:53:26',3),(8,'free','Free Shipping','free_free','Free Shipping','Free Shipping',0,0,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,1,7,'2026-02-17 22:53:26','2026-02-17 22:53:26',3),(15,'flatrate','Flat Rate','flatrate_flatrate','Flat Rate','Flat Rate Shipping',20,20,0.0000,0.0000,0.0000,0.0000,0.0000,20.0000,20.0000,NULL,1,11,'2026-02-21 23:04:27','2026-02-21 23:04:27',4),(16,'free','Free Shipping','free_free','Free Shipping','Free Shipping',0,0,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,1,11,'2026-02-21 23:04:27','2026-02-21 23:04:27',4),(6097,'flatrate','Flat Rate','flatrate_flatrate','Flat Rate','Flat Rate Shipping',10,10,0.0000,0.0000,0.0000,0.0000,0.0000,10.0000,10.0000,NULL,1,19,'2026-02-23 11:40:43','2026-02-23 11:40:43',7),(6098,'free','Free Shipping','free_free','Free Shipping','Free Shipping',0,0,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,1,19,'2026-02-23 11:40:43','2026-02-23 11:40:43',7),(6109,'flatrate','Flat Rate','flatrate_flatrate','Flat Rate','Flat Rate Shipping',20,20,0.0000,0.0000,0.0000,0.0000,0.0000,20.0000,20.0000,NULL,1,17,'2026-02-23 12:38:48','2026-02-23 12:38:48',6),(6110,'free','Free Shipping','free_free','Free Shipping','Free Shipping',0,0,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,1,17,'2026-02-23 12:38:48','2026-02-23 12:38:48',6),(6113,'flatrate','Flat Rate','flatrate_flatrate','Flat Rate','Flat Rate Shipping',10,10,0.0000,0.0000,0.0000,0.0000,0.0000,10.0000,10.0000,NULL,1,23,'2026-02-23 12:42:21','2026-02-23 12:42:21',8),(6114,'free','Free Shipping','free_free','Free Shipping','Free Shipping',0,0,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,1,23,'2026-02-23 12:42:21','2026-02-23 12:42:21',8),(6141,'flatrate','Flat Rate','flatrate_flatrate','Flat Rate','Flat Rate Shipping',10,10,0.0000,0.0000,0.0000,0.0000,0.0000,10.0000,10.0000,NULL,1,25,'2026-02-24 00:44:37','2026-02-24 00:44:37',9),(6142,'free','Free Shipping','free_free','Free Shipping','Free Shipping',0,0,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,1,25,'2026-02-24 00:44:37','2026-02-24 00:44:37',9),(6271,'flatrate','Flat Rate','flatrate_flatrate','Flat Rate','Flat Rate Shipping',40,40,0.0000,0.0000,0.0000,0.0000,0.0000,40.0000,40.0000,NULL,1,15,'2026-02-25 20:35:52','2026-02-25 20:35:52',5),(6272,'free','Free Shipping','free_free','Free Shipping','Free Shipping',0,0,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,1,15,'2026-02-25 20:35:52','2026-02-25 20:35:52',5),(6279,'flatrate','Flat Rate','flatrate_flatrate','Flat Rate','Flat Rate Shipping',10,10,0.0000,0.0000,0.0000,0.0000,0.0000,10.0000,10.0000,NULL,1,31,'2026-02-25 20:59:23','2026-02-25 20:59:23',13),(6280,'free','Free Shipping','free_free','Free Shipping','Free Shipping',0,0,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,1,31,'2026-02-25 20:59:23','2026-02-25 20:59:23',13),(6295,'flatrate','Flat Rate','flatrate_flatrate','Flat Rate','Flat Rate Shipping',10,10,0.0000,0.0000,0.0000,0.0000,0.0000,10.0000,10.0000,NULL,1,39,'2026-02-26 11:30:54','2026-02-26 11:30:54',18),(6296,'free','Free Shipping','free_free','Free Shipping','Free Shipping',0,0,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,1,39,'2026-02-26 11:30:54','2026-02-26 11:30:54',18),(6305,'free','Free Shipping','free_free','Free Shipping','Free Shipping',0,0,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,1,43,'2026-03-14 14:14:34','2026-03-14 14:14:34',19);

--
-- Table structure for table `catalog_rule_channels`
--

CREATE TABLE `catalog_rule_channels` (
  `catalog_rule_id` int(10) unsigned NOT NULL,
  `channel_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`catalog_rule_id`,`channel_id`),
  KEY `catalog_rule_channels_channel_id_foreign` (`channel_id`),
  CONSTRAINT `catalog_rule_channels_catalog_rule_id_foreign` FOREIGN KEY (`catalog_rule_id`) REFERENCES `catalog_rules` (`id`) ON DELETE CASCADE,
  CONSTRAINT `catalog_rule_channels_channel_id_foreign` FOREIGN KEY (`channel_id`) REFERENCES `channels` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `catalog_rule_channels`
--


--
-- Table structure for table `catalog_rule_customer_groups`
--

CREATE TABLE `catalog_rule_customer_groups` (
  `catalog_rule_id` int(10) unsigned NOT NULL,
  `customer_group_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`catalog_rule_id`,`customer_group_id`),
  KEY `catalog_rule_customer_groups_customer_group_id_foreign` (`customer_group_id`),
  CONSTRAINT `catalog_rule_customer_groups_catalog_rule_id_foreign` FOREIGN KEY (`catalog_rule_id`) REFERENCES `catalog_rules` (`id`) ON DELETE CASCADE,
  CONSTRAINT `catalog_rule_customer_groups_customer_group_id_foreign` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `catalog_rule_customer_groups`
--


--
-- Table structure for table `catalog_rule_product_prices`
--

CREATE TABLE `catalog_rule_product_prices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `price` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `rule_date` date NOT NULL,
  `starts_from` datetime DEFAULT NULL,
  `ends_till` datetime DEFAULT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `customer_group_id` int(10) unsigned NOT NULL,
  `catalog_rule_id` int(10) unsigned NOT NULL,
  `channel_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `catalog_rule_product_prices_product_id_foreign` (`product_id`),
  KEY `catalog_rule_product_prices_customer_group_id_foreign` (`customer_group_id`),
  KEY `catalog_rule_product_prices_catalog_rule_id_foreign` (`catalog_rule_id`),
  KEY `catalog_rule_product_prices_channel_id_foreign` (`channel_id`),
  CONSTRAINT `catalog_rule_product_prices_catalog_rule_id_foreign` FOREIGN KEY (`catalog_rule_id`) REFERENCES `catalog_rules` (`id`) ON DELETE CASCADE,
  CONSTRAINT `catalog_rule_product_prices_channel_id_foreign` FOREIGN KEY (`channel_id`) REFERENCES `channels` (`id`) ON DELETE CASCADE,
  CONSTRAINT `catalog_rule_product_prices_customer_group_id_foreign` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_groups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `catalog_rule_product_prices_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `catalog_rule_product_prices`
--


--
-- Table structure for table `catalog_rule_products`
--

CREATE TABLE `catalog_rule_products` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `starts_from` datetime DEFAULT NULL,
  `ends_till` datetime DEFAULT NULL,
  `end_other_rules` tinyint(1) NOT NULL DEFAULT 0,
  `action_type` varchar(255) DEFAULT NULL,
  `discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `sort_order` int(10) unsigned NOT NULL DEFAULT 0,
  `product_id` int(10) unsigned NOT NULL,
  `customer_group_id` int(10) unsigned NOT NULL,
  `catalog_rule_id` int(10) unsigned NOT NULL,
  `channel_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `catalog_rule_products_product_id_foreign` (`product_id`),
  KEY `catalog_rule_products_customer_group_id_foreign` (`customer_group_id`),
  KEY `catalog_rule_products_catalog_rule_id_foreign` (`catalog_rule_id`),
  KEY `catalog_rule_products_channel_id_foreign` (`channel_id`),
  CONSTRAINT `catalog_rule_products_catalog_rule_id_foreign` FOREIGN KEY (`catalog_rule_id`) REFERENCES `catalog_rules` (`id`) ON DELETE CASCADE,
  CONSTRAINT `catalog_rule_products_channel_id_foreign` FOREIGN KEY (`channel_id`) REFERENCES `channels` (`id`) ON DELETE CASCADE,
  CONSTRAINT `catalog_rule_products_customer_group_id_foreign` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_groups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `catalog_rule_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `catalog_rule_products`
--


--
-- Table structure for table `catalog_rules`
--

CREATE TABLE `catalog_rules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `starts_from` date DEFAULT NULL,
  `ends_till` date DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `condition_type` tinyint(1) NOT NULL DEFAULT 1,
  `conditions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`conditions`)),
  `end_other_rules` tinyint(1) NOT NULL DEFAULT 0,
  `action_type` varchar(255) DEFAULT NULL,
  `discount_amount` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `sort_order` int(10) unsigned 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 `catalog_rules`
--


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

CREATE TABLE `categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `position` int(11) NOT NULL DEFAULT 0,
  `logo_path` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `display_mode` varchar(255) DEFAULT 'products_and_description',
  `_lft` int(10) unsigned NOT NULL DEFAULT 0,
  `_rgt` int(10) unsigned NOT NULL DEFAULT 0,
  `parent_id` int(10) unsigned DEFAULT NULL,
  `additional` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`additional`)),
  `banner_path` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `categories__lft__rgt_parent_id_index` (`_lft`,`_rgt`,`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` VALUES (1,1,NULL,1,'products_and_description',1,6,NULL,NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27');

--
-- Table structure for table `category_filterable_attributes`
--

CREATE TABLE `category_filterable_attributes` (
  `category_id` int(10) unsigned NOT NULL,
  `attribute_id` int(10) unsigned NOT NULL,
  KEY `category_filterable_attributes_category_id_foreign` (`category_id`),
  KEY `category_filterable_attributes_attribute_id_foreign` (`attribute_id`),
  CONSTRAINT `category_filterable_attributes_attribute_id_foreign` FOREIGN KEY (`attribute_id`) REFERENCES `attributes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `category_filterable_attributes_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_filterable_attributes`
--


--
-- Table structure for table `category_translations`
--

CREATE TABLE `category_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned NOT NULL,
  `name` text NOT NULL,
  `slug` varchar(255) NOT NULL,
  `url_path` varchar(2048) NOT NULL,
  `description` text DEFAULT NULL,
  `meta_title` text DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_keywords` text DEFAULT NULL,
  `locale_id` int(10) unsigned DEFAULT NULL,
  `locale` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `category_translations_category_id_slug_locale_unique` (`category_id`,`slug`,`locale`),
  KEY `category_translations_locale_id_foreign` (`locale_id`),
  CONSTRAINT `category_translations_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `category_translations_locale_id_foreign` FOREIGN KEY (`locale_id`) REFERENCES `locales` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_translations`
--

INSERT INTO `category_translations` VALUES (2,1,'Root','root','','Root Category Description','','','',NULL,'en');

--
-- Table structure for table `channel_currencies`
--

CREATE TABLE `channel_currencies` (
  `channel_id` int(10) unsigned NOT NULL,
  `currency_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`channel_id`,`currency_id`),
  KEY `channel_currencies_currency_id_foreign` (`currency_id`),
  KEY `channel_currencies_cid_cyid_idx` (`channel_id`,`currency_id`),
  CONSTRAINT `channel_currencies_channel_id_foreign` FOREIGN KEY (`channel_id`) REFERENCES `channels` (`id`) ON DELETE CASCADE,
  CONSTRAINT `channel_currencies_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `channel_currencies`
--

INSERT INTO `channel_currencies` VALUES (1,1),(1,4);

--
-- Table structure for table `channel_inventory_sources`
--

CREATE TABLE `channel_inventory_sources` (
  `channel_id` int(10) unsigned NOT NULL,
  `inventory_source_id` int(10) unsigned NOT NULL,
  UNIQUE KEY `channel_inventory_source_unique` (`channel_id`,`inventory_source_id`),
  KEY `channel_inventory_sources_inventory_source_id_foreign` (`inventory_source_id`),
  CONSTRAINT `channel_inventory_sources_channel_id_foreign` FOREIGN KEY (`channel_id`) REFERENCES `channels` (`id`) ON DELETE CASCADE,
  CONSTRAINT `channel_inventory_sources_inventory_source_id_foreign` FOREIGN KEY (`inventory_source_id`) REFERENCES `inventory_sources` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `channel_inventory_sources`
--

INSERT INTO `channel_inventory_sources` VALUES (1,1),(1,3),(1,4);

--
-- Table structure for table `channel_locales`
--

CREATE TABLE `channel_locales` (
  `channel_id` int(10) unsigned NOT NULL,
  `locale_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`channel_id`,`locale_id`),
  KEY `channel_locales_locale_id_foreign` (`locale_id`),
  KEY `channel_locales_cid_lid_idx` (`channel_id`,`locale_id`),
  CONSTRAINT `channel_locales_channel_id_foreign` FOREIGN KEY (`channel_id`) REFERENCES `channels` (`id`) ON DELETE CASCADE,
  CONSTRAINT `channel_locales_locale_id_foreign` FOREIGN KEY (`locale_id`) REFERENCES `locales` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `channel_locales`
--

INSERT INTO `channel_locales` VALUES (1,1),(1,5);

--
-- Table structure for table `channel_seller`
--

CREATE TABLE `channel_seller` (
  `channel_id` int(10) unsigned NOT NULL,
  `seller_id` int(10) unsigned NOT NULL,
  KEY `channel_seller_channel_id_foreign` (`channel_id`),
  KEY `channel_seller_seller_id_foreign` (`seller_id`),
  CONSTRAINT `channel_seller_channel_id_foreign` FOREIGN KEY (`channel_id`) REFERENCES `channels` (`id`) ON DELETE CASCADE,
  CONSTRAINT `channel_seller_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `marketplace_sellers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `channel_seller`
--

INSERT INTO `channel_seller` VALUES (1,1),(1,2),(1,3);

--
-- Table structure for table `channel_translations`
--

CREATE TABLE `channel_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `channel_id` int(10) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `maintenance_mode_text` text DEFAULT NULL,
  `home_seo` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`home_seo`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `channel_translations_channel_id_locale_unique` (`channel_id`,`locale`),
  KEY `channel_translations_locale_index` (`locale`),
  CONSTRAINT `channel_translations_channel_id_foreign` FOREIGN KEY (`channel_id`) REFERENCES `channels` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `channel_translations`
--

INSERT INTO `channel_translations` VALUES (5,1,'en','Default',NULL,NULL,'{\"meta_title\":\"Demo store\",\"meta_description\":\"Demo store meta description\",\"meta_keywords\":\"Demo store meta keyword\"}',NULL,NULL),(6,1,'pt_BR','Default',NULL,'','{\"meta_title\":\"Demo store\",\"meta_description\":\"Demo store meta description\",\"meta_keywords\":\"Demo store meta keyword\"}','2026-02-25 14:18:16','2026-02-25 14:18:16');

--
-- Table structure for table `channels`
--

CREATE TABLE `channels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `timezone` varchar(255) DEFAULT NULL,
  `theme` varchar(255) DEFAULT NULL,
  `hostname` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `favicon` varchar(255) DEFAULT NULL,
  `home_seo` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`home_seo`)),
  `is_maintenance_on` tinyint(1) NOT NULL DEFAULT 0,
  `allowed_ips` text DEFAULT NULL,
  `root_category_id` int(10) unsigned DEFAULT NULL,
  `default_locale_id` int(10) unsigned NOT NULL,
  `base_currency_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `channels_root_category_id_foreign` (`root_category_id`),
  KEY `channels_default_locale_id_foreign` (`default_locale_id`),
  KEY `channels_base_currency_id_foreign` (`base_currency_id`),
  KEY `channels_hostname_idx` (`hostname`),
  CONSTRAINT `channels_base_currency_id_foreign` FOREIGN KEY (`base_currency_id`) REFERENCES `currencies` (`id`),
  CONSTRAINT `channels_default_locale_id_foreign` FOREIGN KEY (`default_locale_id`) REFERENCES `locales` (`id`),
  CONSTRAINT `channels_root_category_id_foreign` FOREIGN KEY (`root_category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `channels`
--

INSERT INTO `channels` VALUES (1,'default',NULL,'default','http://localhost/bagisto/public',NULL,NULL,NULL,0,'',1,5,4,'2026-02-16 20:08:27','2026-02-25 14:18:16');

--
-- Table structure for table `cms_page_channels`
--

CREATE TABLE `cms_page_channels` (
  `cms_page_id` int(10) unsigned NOT NULL,
  `channel_id` int(10) unsigned NOT NULL,
  UNIQUE KEY `cms_page_channels_cms_page_id_channel_id_unique` (`cms_page_id`,`channel_id`),
  KEY `cms_page_channels_channel_id_foreign` (`channel_id`),
  CONSTRAINT `cms_page_channels_channel_id_foreign` FOREIGN KEY (`channel_id`) REFERENCES `channels` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cms_page_channels_cms_page_id_foreign` FOREIGN KEY (`cms_page_id`) REFERENCES `cms_pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cms_page_channels`
--

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

--
-- Table structure for table `cms_page_translations`
--

CREATE TABLE `cms_page_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `page_title` varchar(255) NOT NULL,
  `url_key` varchar(255) NOT NULL,
  `html_content` longtext DEFAULT NULL,
  `meta_title` text DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_keywords` text DEFAULT NULL,
  `locale` varchar(255) NOT NULL,
  `cms_page_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cms_page_translations_cms_page_id_url_key_locale_unique` (`cms_page_id`,`url_key`,`locale`),
  CONSTRAINT `cms_page_translations_cms_page_id_foreign` FOREIGN KEY (`cms_page_id`) REFERENCES `cms_pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cms_page_translations`
--

INSERT INTO `cms_page_translations` VALUES (11,'About Us','about-us','<div class=\"static-container\"><div class=\"mb-5\">About Us Page Content</div></div>','about us','','aboutus','en',1),(12,'Return Policy','return-policy','<div class=\"static-container\"><div class=\"mb-5\">Return Policy Page Content</div></div>','return policy','','return, policy','en',2),(13,'Refund Policy','refund-policy','<div class=\"static-container\"><div class=\"mb-5\">Refund Policy Page Content</div></div>','Refund policy','','refund, policy','en',3),(14,'Terms & Conditions','terms-conditions','<div class=\"static-container\"><div class=\"mb-5\">Terms & Conditions Page Content</div></div>','Terms & Conditions','','term, conditions','en',4),(15,'Terms of Use','terms-of-use','<div class=\"static-container\"><div class=\"mb-5\">Terms of Use Page Content</div></div>','Terms of use','','term, use','en',5),(16,'Customer Service','customer-service','<div class=\"static-container\"><div class=\"mb-5\">Customer Service Page Content</div></div>','Customer Service','','customer, service','en',6),(17,'What\'s New','whats-new','<div class=\"static-container\"><div class=\"mb-5\">What\'s New page content</div></div>','What\'s New','','new','en',7),(18,'Payment Policy','payment-policy','<div class=\"static-container\"><div class=\"mb-5\">Payment Policy Page Content</div></div>','Payment Policy','','payment, policy','en',8),(19,'Shipping Policy','shipping-policy','<div class=\"static-container\"><div class=\"mb-5\">Shipping Policy Page Content</div></div>','Shipping Policy','','shipping, policy','en',9),(20,'Privacy Policy','privacy-policy','<div class=\"static-container\"><div class=\"mb-5\">Privacy Policy Page Content</div></div>','Privacy Policy','','privacy, policy','en',10);

--
-- Table structure for table `cms_pages`
--

CREATE TABLE `cms_pages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `layout` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cms_pages`
--

INSERT INTO `cms_pages` VALUES (1,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(2,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(3,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(4,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(5,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(6,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(7,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(8,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(9,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(10,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27');

--
-- Table structure for table `compare_items`
--

CREATE TABLE `compare_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(10) unsigned NOT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `compare_items_product_id_foreign` (`product_id`),
  KEY `compare_items_customer_id_foreign` (`customer_id`),
  CONSTRAINT `compare_items_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `compare_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `compare_items`
--

INSERT INTO `compare_items` VALUES (1,2,1,'2026-03-12 10:54:35','2026-03-12 10:54:35');

--
-- Table structure for table `core_config`
--

CREATE TABLE `core_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `value` text NOT NULL,
  `channel_code` varchar(255) DEFAULT NULL,
  `locale_code` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=317 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `core_config`
--

INSERT INTO `core_config` VALUES (1,'sales.checkout.shopping_cart.allow_guest_checkout','1',NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(2,'emails.general.notifications.emails.general.notifications.registration','1',NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(3,'emails.general.notifications.emails.general.notifications.customer_registration_confirmation_mail_to_admin','0',NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(4,'emails.general.notifications.emails.general.notifications.customer_account_credentials','1',NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(5,'emails.general.notifications.emails.general.notifications.new_order','1',NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(6,'emails.general.notifications.emails.general.notifications.new_order_mail_to_admin','1',NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(7,'emails.general.notifications.emails.general.notifications.new_invoice','1',NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(8,'emails.general.notifications.emails.general.notifications.new_invoice_mail_to_admin','0',NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(9,'emails.general.notifications.emails.general.notifications.new_refund','1',NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(10,'emails.general.notifications.emails.general.notifications.new_refund_mail_to_admin','1',NULL,NULL,'2026-02-16 20:08:27','2026-03-06 10:33:59'),(11,'emails.general.notifications.emails.general.notifications.new_shipment','1',NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(12,'emails.general.notifications.emails.general.notifications.new_shipment_mail_to_admin','0',NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(13,'emails.general.notifications.emails.general.notifications.new_inventory_source','1',NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(14,'emails.general.notifications.emails.general.notifications.cancel_order','1',NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(15,'emails.general.notifications.emails.general.notifications.cancel_order_mail_to_admin','0',NULL,NULL,'2026-02-16 20:08:27','2026-02-16 20:08:27'),(88,'marketplace.settings.general.status','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(89,'marketplace.settings.general.admin_commission_percentage','1','default',NULL,'2026-02-16 22:18:47','2026-03-06 10:39:49'),(90,'marketplace.settings.product.approval_required','0','default',NULL,'2026-02-16 22:18:47','2026-03-06 10:39:49'),(91,'marketplace.settings.product.seller_can_assign','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(92,'marketplace.settings.product.seller_can_create','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(93,'marketplace.settings.product.show_progress_bar','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(94,'marketplace.settings.product.flag_enabled','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(95,'marketplace.settings.seller.show_publicly','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(96,'marketplace.settings.seller.can_view_customers','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(97,'marketplace.settings.seller.approval_required','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(98,'marketplace.settings.seller.can_create_invoice','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(99,'marketplace.settings.seller.can_create_shipment','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(100,'marketplace.settings.seller.can_cancel_order','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(101,'marketplace.settings.seller.enable_minimum_order_amount','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(102,'marketplace.settings.seller.flag_enabled','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(103,'marketplace.settings.seller.show_red_flag','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(104,'marketplace.settings.seller.red_flag_limit','10',NULL,NULL,'2026-02-16 22:18:47','2026-02-16 22:24:47'),(105,'marketplace.settings.seller.max_file_upload_size','1024',NULL,NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(106,'marketplace.settings.featured_sellers.status','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(107,'marketplace.settings.featured_sellers.limit_count','12','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(108,'marketplace.settings.featured_sellers.popularity_criteria','all','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(109,'marketplace.settings.landing_page.banner_title','Create a Velocity seller account','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(110,'marketplace.settings.landing_page.banner_description','Velocity can be a great platform for selling your products to new-age businesses in India. By following these tips, you can set yourself up for success as a Velocity seller!','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(111,'marketplace.settings.landing_page.banner_btn_title','Open Store','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(112,'marketplace.settings.landing_page.banner_image','configuration/DyBS0HBGRGW147DvZKTdgdiSiaWf6kHPgLK6qQFm.webp','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(113,'marketplace.settings.landing_page.community_count','1000','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(114,'marketplace.settings.landing_page.business_hour','24x7','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(115,'marketplace.settings.landing_page.payment_duration','15','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(116,'marketplace.settings.landing_page.serviceable_pincode','1000','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(117,'marketplace.settings.landing_page.feature_title','Why do sellers love to sell on velocity?','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(118,'marketplace.settings.landing_page.feature_description','sellers love high-velocity platforms because they offer the potential for increased sales, better exposure, and an efficient selling experience that can contribute to business growth and success.','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(119,'marketplace.settings.landing_page.feature_image','configuration/A9BsGYfcgCioTpGbmvnuSDR2BNIGf9hxTxpo1x3B.webp','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(120,'marketplace.settings.landing_page.feature_box1_icon','configuration/IWddepraaapncnfs8BxLVCPFaFv2joaCbNxRoKpQ.svg','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(121,'marketplace.settings.landing_page.feature_box1_title','Increased Sales Opportunities','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(122,'marketplace.settings.landing_page.feature_box1_desc','sellers love high-velocity platforms because they offer the potential for increased sales, better exposure, and an efficient selling experience that can contribute to business growth and success.','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(123,'marketplace.settings.landing_page.feature_box2_icon','configuration/ffSBdy4Bsh3crYXSMMxoQEwBsf7jnEA4cRBJzLpC.svg','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(124,'marketplace.settings.landing_page.feature_box2_title','Faster Turnaround','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(125,'marketplace.settings.landing_page.feature_box2_desc','Products tend to sell more quickly on high-velocity platforms, leading to faster inventory turnover and revenue generation for sellers.','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(126,'marketplace.settings.landing_page.feature_box3_icon','configuration/LP9XZ9XfXPMoTq3rWra0ndEngVUdAXDgGDUvKUuK.svg','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(127,'marketplace.settings.landing_page.feature_box3_title','Enhanced Visibility','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(128,'marketplace.settings.landing_page.feature_box3_desc','These platforms offer greater visibility and exposure for seller products, resulting in more views and potential sales.','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(129,'marketplace.settings.landing_page.feature_box4_icon','configuration/rRXj8cIvGt1ym9DKFuCZoEgrPAT01lfPG7ZfilLk.png','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(130,'marketplace.settings.landing_page.feature_box4_title','Efficiency and Convenience','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(131,'marketplace.settings.landing_page.feature_box4_desc','High-velocity platforms often have streamlined processes and tools that make selling more efficient, saving sellers time and effort in managing their online businesses.','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(132,'marketplace.settings.landing_page.journey_title','Start your journey on velocity','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(133,'marketplace.settings.landing_page.journey_description','Start selling with large customers around the world, round the clock.','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(134,'marketplace.settings.landing_page.journey_step1_icon','configuration/eXlLe5OmdaQfWpV6i4kDi00ubgeVzdl7tyivVCw6.svg','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(135,'marketplace.settings.landing_page.journey_step1_title','Become Seller','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(136,'marketplace.settings.landing_page.journey_step1_desc','Setup your store, with all the basic information.','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(137,'marketplace.settings.landing_page.journey_step2_icon','configuration/wePx7Gu2ZB0yNxaVTnQVfGO5e9SvkRKfSAmBRHDc.svg','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(138,'marketplace.settings.landing_page.journey_step2_title','List Products','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(139,'marketplace.settings.landing_page.journey_step2_desc','List the products in store for the customer to view and purchase.','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(140,'marketplace.settings.landing_page.journey_step3_icon','configuration/w9ovY22tcbqM99HsnVd4fbFcCxkssF54E2Q5w7zr.svg','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(141,'marketplace.settings.landing_page.journey_step3_title','Receive Order','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(142,'marketplace.settings.landing_page.journey_step3_desc','Receive orders from a wide range of customers around the world.','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(143,'marketplace.settings.landing_page.journey_step4_icon','configuration/0bVS9AXCfEFE3n57Zx2axZbzdCYvJ8HSGVc3LlVn.svg','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(144,'marketplace.settings.landing_page.journey_step4_title','Product Delivery','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(145,'marketplace.settings.landing_page.journey_step4_desc','Once the product is delivered and payment received','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(146,'marketplace.settings.landing_page.journey_step5_icon','configuration/rYld3h3AMAQcHFWWQkI7DwrCoOD1b2cR4n9U7bZW.svg','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(147,'marketplace.settings.landing_page.journey_step5_title','Payment','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(148,'marketplace.settings.landing_page.journey_step5_desc','Payment request, get payment after the commission cut.','default','en','2026-02-16 22:18:47','2026-02-16 22:18:47'),(149,'marketplace.rma.setting.active','0','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(150,'marketplace.rma.setting.allow_after_cancel','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(151,'marketplace.rma.setting.allow_after_decline','1','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(152,'marketplace.rma.setting.return_window','15','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(153,'marketplace.rma.setting.order_status_scope','completed','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(154,'marketplace.rma.setting.allowed_product_types','simple,configurable,bundle,grouped','default',NULL,'2026-02-16 22:18:47','2026-02-16 22:18:47'),(155,'sales.payment_methods.cashondelivery.title','M-pesa','default','en','2026-02-17 22:17:07','2026-02-17 22:17:07'),(156,'sales.payment_methods.cashondelivery.description','Pagamento com a carteira móvel da vodacom','default','en','2026-02-17 22:17:11','2026-02-17 22:17:11'),(157,'sales.payment_methods.cashondelivery.instructions','','default','en','2026-02-17 22:17:11','2026-02-17 22:17:11'),(158,'sales.payment_methods.cashondelivery.generate_invoice','0','default',NULL,'2026-02-17 22:17:12','2026-02-17 22:17:12'),(159,'sales.payment_methods.cashondelivery.active','1','default',NULL,'2026-02-17 22:17:12','2026-02-17 22:17:12'),(160,'sales.payment_methods.cashondelivery.sort','1',NULL,NULL,'2026-02-17 22:17:13','2026-02-17 22:17:13'),(161,'sales.payment_methods.cashondelivery.image','configuration/IzBifJ9JiCitVT7auroq2At17o6QuQ3wb3Cp0NLJ.jpg','default',NULL,'2026-02-17 22:17:13','2026-02-17 22:17:25'),(162,'sales.payment_methods.moneytransfer.title','Emola','default','en','2026-02-17 22:17:14','2026-02-17 22:17:14'),(163,'sales.payment_methods.moneytransfer.description','Pagamento com a carteira móvel da Movitel','default','en','2026-02-17 22:17:14','2026-02-17 22:17:14'),(164,'sales.payment_methods.moneytransfer.generate_invoice','0','default',NULL,'2026-02-17 22:17:14','2026-02-17 22:17:14'),(165,'sales.payment_methods.moneytransfer.mailing_address','','default','en','2026-02-17 22:17:15','2026-02-17 22:17:15'),(166,'sales.payment_methods.moneytransfer.active','0','default',NULL,'2026-02-17 22:17:15','2026-02-24 00:27:43'),(167,'sales.payment_methods.moneytransfer.sort','2',NULL,NULL,'2026-02-17 22:17:16','2026-02-17 22:17:16'),(168,'sales.payment_methods.moneytransfer.image','configuration/oRuiexOuUpEKa1OfsWsutHOtz1LJ8egnPFfJ5MFv.png',NULL,NULL,'2026-02-17 22:17:16','2026-02-17 22:17:28'),(169,'sales.payment_methods.paypal_standard.title','PayPal Standard','default','en','2026-02-17 22:17:16','2026-02-17 22:17:16'),(170,'sales.payment_methods.paypal_standard.description','PayPal Standard','default','en','2026-02-17 22:17:17','2026-02-17 22:17:17'),(171,'sales.payment_methods.paypal_standard.business_account','test@webkul.com','default',NULL,'2026-02-17 22:17:17','2026-02-17 22:17:17'),(172,'sales.payment_methods.paypal_standard.active','1','default',NULL,'2026-02-17 22:17:17','2026-02-17 22:17:17'),(173,'sales.payment_methods.paypal_standard.sandbox','1','default',NULL,'2026-02-17 22:17:18','2026-02-17 22:17:18'),(174,'sales.payment_methods.paypal_standard.sort','3',NULL,NULL,'2026-02-17 22:17:18','2026-02-17 22:17:18'),(175,'sales.payment_methods.paypal_smart_button.title','PayPal Smart Button','default','en','2026-02-17 22:17:18','2026-02-17 22:17:18'),(176,'sales.payment_methods.paypal_smart_button.description','PayPal','default','en','2026-02-17 22:17:18','2026-02-17 22:17:18'),(177,'sales.payment_methods.paypal_smart_button.client_id','sb','default',NULL,'2026-02-17 22:17:19','2026-02-17 22:17:19'),(178,'sales.payment_methods.paypal_smart_button.client_secret','CLIENT_SECRET','default',NULL,'2026-02-17 22:17:19','2026-02-17 22:17:19'),(179,'sales.payment_methods.paypal_smart_button.accepted_currencies','USD','default',NULL,'2026-02-17 22:17:19','2026-02-17 22:17:19'),(180,'sales.payment_methods.paypal_smart_button.active','1','default',NULL,'2026-02-17 22:17:20','2026-02-17 22:17:20'),(181,'sales.payment_methods.paypal_smart_button.sandbox','1','default',NULL,'2026-02-17 22:17:20','2026-02-17 22:17:20'),(182,'sales.payment_methods.paypal_smart_button.sort','4',NULL,NULL,'2026-02-17 22:17:20','2026-02-17 22:17:20'),(183,'sales.checkout.shopping_cart.cart_page','1',NULL,NULL,'2026-02-17 22:19:18','2026-02-17 22:19:18'),(184,'sales.checkout.shopping_cart.cross_sell','1',NULL,NULL,'2026-02-17 22:19:18','2026-02-17 22:19:18'),(185,'sales.checkout.shopping_cart.estimate_shipping','0',NULL,NULL,'2026-02-17 22:19:19','2026-02-17 22:19:19'),(186,'sales.checkout.my_cart.summary','display_number_of_items_in_cart',NULL,NULL,'2026-02-17 22:19:19','2026-02-17 22:19:19'),(187,'sales.checkout.mini_cart.display_mini_cart','1',NULL,NULL,'2026-02-17 22:19:19','2026-02-17 22:19:19'),(188,'sales.checkout.mini_cart.offer_info','Get Up To 30% OFF on your 1st order',NULL,NULL,'2026-02-17 22:19:19','2026-02-17 22:19:19'),(189,'sales.payment_methods.imaliway.base_url','https://paytek-africa.net:11901','default',NULL,'2026-02-22 00:34:24','2026-02-25 13:08:26'),(190,'sales.payment_methods.imaliway.api_key','69|cHS8Fqobo8mENHoaWMthB7AiPSmwsvbqlr75N5nu','default',NULL,'2026-02-22 00:34:24','2026-02-22 00:34:24'),(191,'sales.payment_methods.imaliway.public_key','-----BEGIN PUBLIC KEY-----\r\nMIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEA0rKiVlDXjvuVHzpMN77z\r\nvDxJ+/fePcwHZkR6nr0yFbpT61tPUfGO554gx9Via/bZkqJD7T+bv9Ega6hT+vPy\r\n++Ry5+S1QZl9NFhDnJFoxPMI72yHqswrTVBW+Ol/FeiabAiUgZluip309txvrmo5\r\n1XddV0ukOyuZ4gjTPLcAauPaQ6YaUkG/4V8bJWcjroCFC+uvU76Skd/TxTvI6yV8\r\nHm7GeRt5sFDgWXijGJLb9isUqkhBLjL21Mr5s3MSzUgeICOcvWhL8t/fn4kRq8X6\r\ncCev9SInCLwkl3SmN+gUANsf6DDknuUgBWPyIeB1xnQgo2NdI2tjw3JYdnlc0mTt\r\nHzZd2M3OysxJ0i8M7oeUV44+YgCDpyBztuCTIT9nZ+318aN9CBlyhzcGvwP35SId\r\n/GIvliV0sh2VdNh6nxk1zAHPETrAygf5YOUhcIW8FvrfMjApdDX1D6HHW/HjeNPR\r\nKUw5ewQhs/sM77dSAegowz/p6pNEAiFBGEiYNMkeA67Ke31dNfeQ+Fkr0zUUPu6u\r\nQJxlqt6L4GAn0q42Ltm/OoDnn1aXvMXzbkCbhNN3FWYm8varS3rpmMEdjp/fiIOd\r\nmnQ3VgI04N54t9VsXQp6t5Omp9IwIRawJumoVYUgcrGgAgwh6D6v4nJqoTOdSNhd\r\n6fkE4k4vNPqcWg4nB28ilnsCAwEAAQ==\r\n-----END PUBLIC KEY-----','default',NULL,'2026-02-22 00:34:24','2026-02-22 00:34:24'),(192,'sales.payment_methods.imaliway.x_client_id','2026596751','default',NULL,'2026-02-22 00:34:24','2026-02-22 00:34:24'),(193,'sales.payment_methods.imaliway.store_account_number','260000005','default',NULL,'2026-02-22 00:34:24','2026-02-22 00:34:24'),(194,'sales.payment_methods.imaliway.active','1','default',NULL,'2026-02-22 00:34:24','2026-02-22 00:34:24'),(195,'sales.payment_methods.mpesa.title','M-Pesa','default','pt_BR','2026-02-22 00:34:24','2026-02-22 00:34:24'),(196,'sales.payment_methods.mpesa.description','Pagamento com a carteira movel da operadora da Vodacom','default','pt_BR','2026-02-22 00:34:24','2026-02-22 00:34:24'),(197,'sales.payment_methods.mpesa.active','1','default',NULL,'2026-02-22 00:34:24','2026-02-22 00:34:24'),(198,'sales.payment_methods.mpesa.sort','2','default',NULL,'2026-02-22 00:34:25','2026-02-24 00:27:45'),(199,'sales.payment_methods.mpesa.image','configuration/bFhDzz2kqt218m7ycZql4Uu9Y5aEVBEfeoro1SHH.jpg','default',NULL,'2026-02-22 00:34:25','2026-02-22 00:34:25'),(200,'sales.payment_methods.emola.title','Emola','default','pt_BR','2026-02-22 00:34:25','2026-02-22 00:34:25'),(201,'sales.payment_methods.emola.description','Pagamento com a carteira movel da operadora da Movitel','default','pt_BR','2026-02-22 00:34:25','2026-02-22 00:34:25'),(202,'sales.payment_methods.emola.active','1','default',NULL,'2026-02-22 00:34:25','2026-02-22 00:34:25'),(203,'sales.payment_methods.emola.sort','2','default',NULL,'2026-02-22 00:34:25','2026-02-22 00:34:25'),(204,'sales.payment_methods.emola.image','configuration/iEwPORECnlXHIvgyLxySTACFfW5T0srN4ukOOh7Z.png','default',NULL,'2026-02-22 00:34:25','2026-02-22 00:34:25'),(205,'sales.payment_methods.mkesh.title','MKesh','default','pt_BR','2026-02-22 00:34:25','2026-02-22 00:34:25'),(206,'sales.payment_methods.mkesh.description','Pagamento com a carteira movel da operadora da TMCEL','default','pt_BR','2026-02-22 00:34:25','2026-02-22 00:34:25'),(207,'sales.payment_methods.mkesh.active','1','default',NULL,'2026-02-22 00:34:25','2026-02-22 00:34:25'),(208,'sales.payment_methods.mkesh.sort','3','default',NULL,'2026-02-22 00:34:25','2026-02-22 00:34:25'),(209,'sales.payment_methods.mkesh.image','configuration/T40KSLMmiQANCccNXNaXhbxF8s16nOru4G1h7CBP.png','default',NULL,'2026-02-22 00:34:25','2026-02-22 00:34:25'),(210,'sales.payment_methods.imali.title','IMali','default','pt_BR','2026-02-22 00:34:25','2026-02-22 00:34:25'),(211,'sales.payment_methods.imali.description','Pagamento com a conta IMali','default','pt_BR','2026-02-22 00:34:25','2026-02-22 00:34:25'),(212,'sales.payment_methods.imali.active','1','default',NULL,'2026-02-22 00:34:25','2026-02-22 00:34:25'),(213,'sales.payment_methods.imali.sort','4','default',NULL,'2026-02-22 00:34:25','2026-02-22 00:34:25'),(214,'sales.payment_methods.imali.image','configuration/8NCnoSszE5CQ1UlwJmLM8TwjOJsHo5wCk8Vd3o1o.webp','default',NULL,'2026-02-22 00:34:25','2026-02-22 00:34:25'),(215,'sales.payment_methods.bnpl.title','Buy Now Pay Later (BNPL)','default','pt_BR','2026-02-22 00:34:25','2026-02-22 00:34:25'),(216,'sales.payment_methods.bnpl.description','Serviço de pagamento diferido, efectue a compra hoje e finalize o pagamento depois','default','pt_BR','2026-02-22 00:34:25','2026-02-22 00:34:25'),(217,'sales.payment_methods.bnpl.active','1','default',NULL,'2026-02-22 00:34:25','2026-02-22 00:34:25'),(218,'sales.payment_methods.bnpl.sort','5','default',NULL,'2026-02-22 00:34:25','2026-02-22 00:34:25'),(219,'sales.payment_methods.bnpl.image','configuration/ImezrERr1BpdLZgAmgygHfEFyPLfnpgmKtLzZx4e.png','default',NULL,'2026-02-22 00:34:25','2026-02-22 00:34:25'),(220,'sales.payment_methods.cashondelivery.title','Cash On Delivery','default','pt_BR','2026-02-24 00:16:56','2026-02-24 00:16:56'),(221,'sales.payment_methods.cashondelivery.description','Cash On Delivery','default','pt_BR','2026-02-24 00:16:57','2026-02-24 00:16:57'),(222,'sales.payment_methods.cashondelivery.instructions','','default','pt_BR','2026-02-24 00:16:57','2026-02-24 00:16:57'),(223,'sales.payment_methods.cashondelivery.sort','6','default',NULL,'2026-02-24 00:16:57','2026-02-24 00:16:57'),(224,'sales.payment_methods.moneytransfer.title','Money Transfer','default','pt_BR','2026-02-24 00:16:57','2026-02-24 00:16:57'),(225,'sales.payment_methods.moneytransfer.description','Money Transfer','default','pt_BR','2026-02-24 00:16:57','2026-02-24 00:16:57'),(226,'sales.payment_methods.moneytransfer.mailing_address','','default','pt_BR','2026-02-24 00:16:57','2026-02-24 00:16:57'),(227,'sales.payment_methods.moneytransfer.sort','2','default',NULL,'2026-02-24 00:16:57','2026-02-24 00:16:57'),(228,'sales.payment_methods.paypal_standard.title','PayPal Standard','default','pt_BR','2026-02-24 00:16:57','2026-02-24 00:16:57'),(229,'sales.payment_methods.paypal_standard.description','PayPal Standard','default','pt_BR','2026-02-24 00:16:57','2026-02-24 00:16:57'),(230,'sales.payment_methods.paypal_standard.sort','3','default',NULL,'2026-02-24 00:16:57','2026-02-24 00:16:57'),(231,'sales.payment_methods.paypal_smart_button.title','PayPal Smart Button','default','pt_BR','2026-02-24 00:16:57','2026-02-24 00:16:57'),(232,'sales.payment_methods.paypal_smart_button.description','PayPal','default','pt_BR','2026-02-24 00:16:57','2026-02-24 00:16:57'),(233,'sales.payment_methods.paypal_smart_button.sort','4','default',NULL,'2026-02-24 00:16:58','2026-02-24 00:16:58'),(234,'general.design.categories.category_view','sidebar',NULL,NULL,'2026-03-06 10:31:46','2026-03-06 10:31:46'),(235,'general.general.locale_options.weight_unit','kgs','default',NULL,'2026-03-06 10:34:39','2026-03-06 10:34:39'),(236,'general.general.breadcrumbs.shop','1',NULL,NULL,'2026-03-06 10:34:39','2026-03-06 10:34:39'),(237,'general.general.visitor_options.enabled','1',NULL,NULL,'2026-03-06 10:34:39','2026-03-06 10:34:39'),(238,'customer.settings.wishlist.wishlist_option','1',NULL,NULL,'2026-03-06 10:35:40','2026-03-06 10:35:40'),(239,'customer.settings.login_options.redirected_to_page','home',NULL,NULL,'2026-03-06 10:35:40','2026-03-06 10:35:40'),(240,'customer.settings.create_new_account_options.default_group','general',NULL,NULL,'2026-03-06 10:35:40','2026-03-06 10:35:40'),(241,'customer.settings.create_new_account_options.news_letter','0',NULL,NULL,'2026-03-06 10:35:40','2026-03-06 10:35:40'),(242,'customer.settings.newsletter.subscription','0',NULL,NULL,'2026-03-06 10:35:40','2026-03-06 10:35:40'),(243,'customer.settings.email.verification','0',NULL,NULL,'2026-03-06 10:35:40','2026-03-06 10:35:40'),(244,'customer.settings.social_login.enable_facebook','0','default',NULL,'2026-03-06 10:35:40','2026-03-06 10:35:40'),(245,'customer.settings.social_login.enable_twitter','0','default',NULL,'2026-03-06 10:35:40','2026-03-06 10:35:40'),(246,'customer.settings.social_login.enable_google','0','default',NULL,'2026-03-06 10:35:40','2026-03-06 10:35:40'),(247,'customer.settings.social_login.enable_linkedin-openid','0','default',NULL,'2026-03-06 10:35:40','2026-03-06 10:35:40'),(248,'customer.settings.social_login.enable_github','0','default',NULL,'2026-03-06 10:35:40','2026-03-06 10:35:40'),(249,'marketplace.settings.landing_page.banner_title','Create a Velocity seller account','default','pt_BR','2026-03-06 10:39:50','2026-03-06 10:39:50'),(250,'marketplace.settings.landing_page.banner_description','seller','default','pt_BR','2026-03-06 10:39:50','2026-03-06 10:39:50'),(251,'marketplace.settings.landing_page.banner_btn_title','Open Store','default','pt_BR','2026-03-06 10:39:50','2026-03-06 10:39:50'),(252,'marketplace.settings.landing_page.feature_title','Why do sellers love to sell on velocity?','default','pt_BR','2026-03-06 10:39:50','2026-03-06 10:39:50'),(253,'marketplace.settings.landing_page.feature_description','why?','default','pt_BR','2026-03-06 10:39:50','2026-03-06 10:39:50'),(254,'marketplace.settings.landing_page.feature_box1_title','Increased Sales Opportunities','default','pt_BR','2026-03-06 10:39:50','2026-03-06 10:39:50'),(255,'marketplace.settings.landing_page.feature_box1_desc','increased','default','pt_BR','2026-03-06 10:39:50','2026-03-06 10:39:50'),(256,'marketplace.settings.landing_page.feature_box2_title','Faster Turnaround','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(257,'marketplace.settings.landing_page.feature_box2_desc','faster','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(258,'marketplace.settings.landing_page.feature_box3_title','Enhanced Visibility','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(259,'marketplace.settings.landing_page.feature_box3_desc','visibility','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(260,'marketplace.settings.landing_page.feature_box4_title','Efficiency and Convenience','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(261,'marketplace.settings.landing_page.feature_box4_desc','convenience','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(262,'marketplace.settings.landing_page.journey_title','Start your journey on velocity','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(263,'marketplace.settings.landing_page.journey_description','journey','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(264,'marketplace.settings.landing_page.journey_step1_title','Become Seller','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(265,'marketplace.settings.landing_page.journey_step1_desc','become','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(266,'marketplace.settings.landing_page.journey_step2_title','List Products','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(267,'marketplace.settings.landing_page.journey_step2_desc','list products','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(268,'marketplace.settings.landing_page.journey_step3_title','Receive Order','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(269,'marketplace.settings.landing_page.journey_step3_desc','receive order','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(270,'marketplace.settings.landing_page.journey_step4_title','Product Delivery','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(271,'marketplace.settings.landing_page.journey_step4_desc','Product delivery','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(272,'marketplace.settings.landing_page.journey_step5_title','Payment','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(273,'marketplace.settings.landing_page.journey_step5_desc','payment','default','pt_BR','2026-03-06 10:39:51','2026-03-06 10:39:51'),(274,'catalog.products.settings.compare_option','1',NULL,NULL,'2026-03-06 10:41:54','2026-03-06 10:41:54'),(275,'catalog.products.settings.image_search','1',NULL,NULL,'2026-03-06 10:41:54','2026-03-06 10:41:54'),(276,'catalog.products.search.engine','database',NULL,NULL,'2026-03-06 10:41:54','2026-03-06 10:41:54'),(277,'catalog.products.search.admin_mode','database',NULL,NULL,'2026-03-06 10:41:54','2026-03-06 10:41:54'),(278,'catalog.products.search.storefront_mode','database',NULL,NULL,'2026-03-06 10:41:54','2026-03-06 10:41:54'),(279,'catalog.products.search.min_query_length','0',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(280,'catalog.products.search.max_query_length','1000',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(281,'catalog.products.product_view_page.no_of_related_products','',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(282,'catalog.products.product_view_page.no_of_up_sells_products','',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(283,'catalog.products.cart_view_page.no_of_cross_sells_products','',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(284,'catalog.products.storefront.products_per_page','','default',NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(285,'catalog.products.storefront.buy_now_button_display','0',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(286,'catalog.products.cache_small_image.width','',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(287,'catalog.products.cache_small_image.height','',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(288,'catalog.products.cache_medium_image.width','',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(289,'catalog.products.cache_medium_image.height','',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(290,'catalog.products.cache_large_image.width','',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(291,'catalog.products.cache_large_image.height','',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(292,'catalog.products.review.guest_review','0',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(293,'catalog.products.review.customer_review','1',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(294,'catalog.products.review.censoring_reviewer_name','1',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(295,'catalog.products.review.summary','star_counts',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(296,'catalog.products.attribute.image_attribute_upload_size','',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(297,'catalog.products.attribute.file_attribute_upload_size','',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(298,'catalog.products.social_share.enabled','0',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(299,'catalog.products.social_share.facebook','0',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(300,'catalog.products.social_share.twitter','0',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(301,'catalog.products.social_share.pinterest','0',NULL,NULL,'2026-03-06 10:41:55','2026-03-06 10:41:55'),(302,'catalog.products.social_share.whatsapp','0',NULL,NULL,'2026-03-06 10:41:56','2026-03-06 10:41:56'),(303,'catalog.products.social_share.linkedin','0',NULL,NULL,'2026-03-06 10:41:56','2026-03-06 10:41:56'),(304,'catalog.products.social_share.email','0',NULL,NULL,'2026-03-06 10:41:56','2026-03-06 10:41:56'),(305,'catalog.products.social_share.share_message','',NULL,NULL,'2026-03-06 10:41:56','2026-03-06 10:41:56'),(306,'sales.payment_methods.imaliway.login_email','','default',NULL,'2026-03-12 10:26:49','2026-03-13 18:25:58'),(307,'sales.payment_methods.imaliway.login_password','','default',NULL,'2026-03-12 10:26:49','2026-03-13 18:25:58'),(308,'sales.payment_methods.imaliway.firebase_token','','default',NULL,'2026-03-12 10:26:49','2026-03-13 18:25:58'),(309,'sales.payment_methods.imaliway.mobile_reference','','default',NULL,'2026-03-12 10:26:50','2026-03-13 18:25:58'),(310,'sales.payment_methods.imaliway.access_token','','default',NULL,'2026-03-13 12:32:49','2026-03-13 18:25:58'),(311,'sales.carriers.free.title','Free Shipping','default','pt_BR','2026-03-14 13:58:01','2026-03-14 13:58:01'),(312,'sales.carriers.free.description','Free Shipping','default','pt_BR','2026-03-14 13:58:01','2026-03-14 13:58:01'),(313,'sales.carriers.free.active','1','default',NULL,'2026-03-14 13:58:01','2026-03-14 13:58:01'),(314,'sales.carriers.flatrate.description','Flat Rate Shipping','default','pt_BR','2026-03-14 13:58:01','2026-03-14 13:58:01'),(315,'sales.carriers.flatrate.type','per_unit','default',NULL,'2026-03-14 13:58:01','2026-03-14 13:58:01'),(316,'sales.carriers.flatrate.active','0','default',NULL,'2026-03-14 13:58:02','2026-03-14 13:58:02');

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

CREATE TABLE `countries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `countries` VALUES (1,'AF','Afghanistan'),(2,'AX','Åland Islands'),(3,'AL','Albania'),(4,'DZ','Algeria'),(5,'AS','American Samoa'),(6,'AD','Andorra'),(7,'AO','Angola'),(8,'AI','Anguilla'),(9,'AQ','Antarctica'),(10,'AG','Antigua & Barbuda'),(11,'AR','Argentina'),(12,'AM','Armenia'),(13,'AW','Aruba'),(14,'AC','Ascension Island'),(15,'AU','Australia'),(16,'AT','Austria'),(17,'AZ','Azerbaijan'),(18,'BS','Bahamas'),(19,'BH','Bahrain'),(20,'BD','Bangladesh'),(21,'BB','Barbados'),(22,'BY','Belarus'),(23,'BE','Belgium'),(24,'BZ','Belize'),(25,'BJ','Benin'),(26,'BM','Bermuda'),(27,'BT','Bhutan'),(28,'BO','Bolivia'),(29,'BA','Bosnia & Herzegovina'),(30,'BW','Botswana'),(31,'BR','Brazil'),(32,'IO','British Indian Ocean Territory'),(33,'VG','British Virgin Islands'),(34,'BN','Brunei'),(35,'BG','Bulgaria'),(36,'BF','Burkina Faso'),(37,'BI','Burundi'),(38,'KH','Cambodia'),(39,'CM','Cameroon'),(40,'CA','Canada'),(41,'IC','Canary Islands'),(42,'CV','Cape Verde'),(43,'BQ','Caribbean Netherlands'),(44,'KY','Cayman Islands'),(45,'CF','Central African Republic'),(46,'EA','Ceuta & Melilla'),(47,'TD','Chad'),(48,'CL','Chile'),(49,'CN','China'),(50,'CX','Christmas Island'),(51,'CC','Cocos (Keeling) Islands'),(52,'CO','Colombia'),(53,'KM','Comoros'),(54,'CG','Congo - Brazzaville'),(55,'CD','Congo - Kinshasa'),(56,'CK','Cook Islands'),(57,'CR','Costa Rica'),(58,'CI','Côte d’Ivoire'),(59,'HR','Croatia'),(60,'CU','Cuba'),(61,'CW','Curaçao'),(62,'CY','Cyprus'),(63,'CZ','Czechia'),(64,'DK','Denmark'),(65,'DG','Diego Garcia'),(66,'DJ','Djibouti'),(67,'DM','Dominica'),(68,'DO','Dominican Republic'),(69,'EC','Ecuador'),(70,'EG','Egypt'),(71,'SV','El Salvador'),(72,'GQ','Equatorial Guinea'),(73,'ER','Eritrea'),(74,'EE','Estonia'),(75,'ET','Ethiopia'),(76,'EZ','Eurozone'),(77,'FK','Falkland Islands'),(78,'FO','Faroe Islands'),(79,'FJ','Fiji'),(80,'FI','Finland'),(81,'FR','France'),(82,'GF','French Guiana'),(83,'PF','French Polynesia'),(84,'TF','French Southern Territories'),(85,'GA','Gabon'),(86,'GM','Gambia'),(87,'GE','Georgia'),(88,'DE','Germany'),(89,'GH','Ghana'),(90,'GI','Gibraltar'),(91,'GR','Greece'),(92,'GL','Greenland'),(93,'GD','Grenada'),(94,'GP','Guadeloupe'),(95,'GU','Guam'),(96,'GT','Guatemala'),(97,'GG','Guernsey'),(98,'GN','Guinea'),(99,'GW','Guinea-Bissau'),(100,'GY','Guyana'),(101,'HT','Haiti'),(102,'HN','Honduras'),(103,'HK','Hong Kong SAR China'),(104,'HU','Hungary'),(105,'IS','Iceland'),(106,'IN','India'),(107,'ID','Indonesia'),(108,'IR','Iran'),(109,'IQ','Iraq'),(110,'IE','Ireland'),(111,'IM','Isle of Man'),(112,'IL','Israel'),(113,'IT','Italy'),(114,'JM','Jamaica'),(115,'JP','Japan'),(116,'JE','Jersey'),(117,'JO','Jordan'),(118,'KZ','Kazakhstan'),(119,'KE','Kenya'),(120,'KI','Kiribati'),(121,'XK','Kosovo'),(122,'KW','Kuwait'),(123,'KG','Kyrgyzstan'),(124,'LA','Laos'),(125,'LV','Latvia'),(126,'LB','Lebanon'),(127,'LS','Lesotho'),(128,'LR','Liberia'),(129,'LY','Libya'),(130,'LI','Liechtenstein'),(131,'LT','Lithuania'),(132,'LU','Luxembourg'),(133,'MO','Macau SAR China'),(134,'MK','Macedonia'),(135,'MG','Madagascar'),(136,'MW','Malawi'),(137,'MY','Malaysia'),(138,'MV','Maldives'),(139,'ML','Mali'),(140,'MT','Malta'),(141,'MH','Marshall Islands'),(142,'MQ','Martinique'),(143,'MR','Mauritania'),(144,'MU','Mauritius'),(145,'YT','Mayotte'),(146,'MX','Mexico'),(147,'FM','Micronesia'),(148,'MD','Moldova'),(149,'MC','Monaco'),(150,'MN','Mongolia'),(151,'ME','Montenegro'),(152,'MS','Montserrat'),(153,'MA','Morocco'),(154,'MZ','Mozambique'),(155,'MM','Myanmar (Burma)'),(156,'NA','Namibia'),(157,'NR','Nauru'),(158,'NP','Nepal'),(159,'NL','Netherlands'),(160,'NC','New Caledonia'),(161,'NZ','New Zealand'),(162,'NI','Nicaragua'),(163,'NE','Niger'),(164,'NG','Nigeria'),(165,'NU','Niue'),(166,'NF','Norfolk Island'),(167,'KP','North Korea'),(168,'MP','Northern Mariana Islands'),(169,'NO','Norway'),(170,'OM','Oman'),(171,'PK','Pakistan'),(172,'PW','Palau'),(173,'PS','Palestinian Territories'),(174,'PA','Panama'),(175,'PG','Papua New Guinea'),(176,'PY','Paraguay'),(177,'PE','Peru'),(178,'PH','Philippines'),(179,'PN','Pitcairn Islands'),(180,'PL','Poland'),(181,'PT','Portugal'),(182,'PR','Puerto Rico'),(183,'QA','Qatar'),(184,'RE','Réunion'),(185,'RO','Romania'),(186,'RU','Russia'),(187,'RW','Rwanda'),(188,'WS','Samoa'),(189,'SM','San Marino'),(190,'ST','São Tomé & Príncipe'),(191,'SA','Saudi Arabia'),(192,'SN','Senegal'),(193,'RS','Serbia'),(194,'SC','Seychelles'),(195,'SL','Sierra Leone'),(196,'SG','Singapore'),(197,'SX','Sint Maarten'),(198,'SK','Slovakia'),(199,'SI','Slovenia'),(200,'SB','Solomon Islands'),(201,'SO','Somalia'),(202,'ZA','South Africa'),(203,'GS','South Georgia & South Sandwich Islands'),(204,'KR','South Korea'),(205,'SS','South Sudan'),(206,'ES','Spain'),(207,'LK','Sri Lanka'),(208,'BL','St. Barthélemy'),(209,'SH','St. Helena'),(210,'KN','St. Kitts & Nevis'),(211,'LC','St. Lucia'),(212,'MF','St. Martin'),(213,'PM','St. Pierre & Miquelon'),(214,'VC','St. Vincent & Grenadines'),(215,'SD','Sudan'),(216,'SR','Suriname'),(217,'SJ','Svalbard & Jan Mayen'),(218,'SZ','Swaziland'),(219,'SE','Sweden'),(220,'CH','Switzerland'),(221,'SY','Syria'),(222,'TW','Taiwan'),(223,'TJ','Tajikistan'),(224,'TZ','Tanzania'),(225,'TH','Thailand'),(226,'TL','Timor-Leste'),(227,'TG','Togo'),(228,'TK','Tokelau'),(229,'TO','Tonga'),(230,'TT','Trinidad & Tobago'),(231,'TA','Tristan da Cunha'),(232,'TN','Tunisia'),(233,'TR','Turkey'),(234,'TM','Turkmenistan'),(235,'TC','Turks & Caicos Islands'),(236,'TV','Tuvalu'),(237,'UM','U.S. Outlying Islands'),(238,'VI','U.S. Virgin Islands'),(239,'UG','Uganda'),(240,'UA','Ukraine'),(241,'AE','United Arab Emirates'),(242,'GB','United Kingdom'),(244,'US','United States'),(245,'UY','Uruguay'),(246,'UZ','Uzbekistan'),(247,'VU','Vanuatu'),(248,'VA','Vatican City'),(249,'VE','Venezuela'),(250,'VN','Vietnam'),(251,'WF','Wallis & Futuna'),(252,'EH','Western Sahara'),(253,'YE','Yemen'),(254,'ZM','Zambia'),(255,'ZW','Zimbabwe');

--
-- Table structure for table `country_state_translations`
--

CREATE TABLE `country_state_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `country_state_id` int(10) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `default_name` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `country_state_translations_country_state_id_foreign` (`country_state_id`),
  CONSTRAINT `country_state_translations_country_state_id_foreign` FOREIGN KEY (`country_state_id`) REFERENCES `country_states` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `country_state_translations`
--


--
-- Table structure for table `country_states`
--

CREATE TABLE `country_states` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `country_id` int(10) unsigned DEFAULT NULL,
  `country_code` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `default_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `country_states_country_id_foreign` (`country_id`),
  CONSTRAINT `country_states_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=587 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `country_states`
--

INSERT INTO `country_states` VALUES (1,244,'US','AL','Alabama'),(2,244,'US','AK','Alaska'),(3,244,'US','AS','American Samoa'),(4,244,'US','AZ','Arizona'),(5,244,'US','AR','Arkansas'),(6,244,'US','AE','Armed Forces Africa'),(7,244,'US','AA','Armed Forces Americas'),(8,244,'US','AE','Armed Forces Canada'),(9,244,'US','AE','Armed Forces Europe'),(10,244,'US','AE','Armed Forces Middle East'),(11,244,'US','AP','Armed Forces Pacific'),(12,244,'US','CA','California'),(13,244,'US','CO','Colorado'),(14,244,'US','CT','Connecticut'),(15,244,'US','DE','Delaware'),(16,244,'US','DC','District of Columbia'),(17,244,'US','FM','Federated States Of Micronesia'),(18,244,'US','FL','Florida'),(19,244,'US','GA','Georgia'),(20,244,'US','GU','Guam'),(21,244,'US','HI','Hawaii'),(22,244,'US','ID','Idaho'),(23,244,'US','IL','Illinois'),(24,244,'US','IN','Indiana'),(25,244,'US','IA','Iowa'),(26,244,'US','KS','Kansas'),(27,244,'US','KY','Kentucky'),(28,244,'US','LA','Louisiana'),(29,244,'US','ME','Maine'),(30,244,'US','MH','Marshall Islands'),(31,244,'US','MD','Maryland'),(32,244,'US','MA','Massachusetts'),(33,244,'US','MI','Michigan'),(34,244,'US','MN','Minnesota'),(35,244,'US','MS','Mississippi'),(36,244,'US','MO','Missouri'),(37,244,'US','MT','Montana'),(38,244,'US','NE','Nebraska'),(39,244,'US','NV','Nevada'),(40,244,'US','NH','New Hampshire'),(41,244,'US','NJ','New Jersey'),(42,244,'US','NM','New Mexico'),(43,244,'US','NY','New York'),(44,244,'US','NC','North Carolina'),(45,244,'US','ND','North Dakota'),(46,244,'US','MP','Northern Mariana Islands'),(47,244,'US','OH','Ohio'),(48,244,'US','OK','Oklahoma'),(49,244,'US','OR','Oregon'),(50,244,'US','PW','Palau'),(51,244,'US','PA','Pennsylvania'),(52,244,'US','PR','Puerto Rico'),(53,244,'US','RI','Rhode Island'),(54,244,'US','SC','South Carolina'),(55,244,'US','SD','South Dakota'),(56,244,'US','TN','Tennessee'),(57,244,'US','TX','Texas'),(58,244,'US','UT','Utah'),(59,244,'US','VT','Vermont'),(60,244,'US','VI','Virgin Islands'),(61,244,'US','VA','Virginia'),(62,244,'US','WA','Washington'),(63,244,'US','WV','West Virginia'),(64,244,'US','WI','Wisconsin'),(65,244,'US','WY','Wyoming'),(66,40,'CA','AB','Alberta'),(67,40,'CA','BC','British Columbia'),(68,40,'CA','MB','Manitoba'),(69,40,'CA','NL','Newfoundland and Labrador'),(70,40,'CA','NB','New Brunswick'),(71,40,'CA','NS','Nova Scotia'),(72,40,'CA','NT','Northwest Territories'),(73,40,'CA','NU','Nunavut'),(74,40,'CA','ON','Ontario'),(75,40,'CA','PE','Prince Edward Island'),(76,40,'CA','QC','Quebec'),(77,40,'CA','SK','Saskatchewan'),(78,40,'CA','YT','Yukon Territory'),(79,88,'DE','NDS','Niedersachsen'),(80,88,'DE','BAW','Baden-Württemberg'),(81,88,'DE','BAY','Bayern'),(82,88,'DE','BER','Berlin'),(83,88,'DE','BRG','Brandenburg'),(84,88,'DE','BRE','Bremen'),(85,88,'DE','HAM','Hamburg'),(86,88,'DE','HES','Hessen'),(87,88,'DE','MEC','Mecklenburg-Vorpommern'),(88,88,'DE','NRW','Nordrhein-Westfalen'),(89,88,'DE','RHE','Rheinland-Pfalz'),(90,88,'DE','SAR','Saarland'),(91,88,'DE','SAS','Sachsen'),(92,88,'DE','SAC','Sachsen-Anhalt'),(93,88,'DE','SCN','Schleswig-Holstein'),(94,88,'DE','THE','Thüringen'),(95,16,'AT','WI','Wien'),(96,16,'AT','NO','Niederösterreich'),(97,16,'AT','OO','Oberösterreich'),(98,16,'AT','SB','Salzburg'),(99,16,'AT','KN','Kärnten'),(100,16,'AT','ST','Steiermark'),(101,16,'AT','TI','Tirol'),(102,16,'AT','BL','Burgenland'),(103,16,'AT','VB','Vorarlberg'),(104,220,'CH','AG','Aargau'),(105,220,'CH','AI','Appenzell Innerrhoden'),(106,220,'CH','AR','Appenzell Ausserrhoden'),(107,220,'CH','BE','Bern'),(108,220,'CH','BL','Basel-Landschaft'),(109,220,'CH','BS','Basel-Stadt'),(110,220,'CH','FR','Freiburg'),(111,220,'CH','GE','Genf'),(112,220,'CH','GL','Glarus'),(113,220,'CH','GR','Graubünden'),(114,220,'CH','JU','Jura'),(115,220,'CH','LU','Luzern'),(116,220,'CH','NE','Neuenburg'),(117,220,'CH','NW','Nidwalden'),(118,220,'CH','OW','Obwalden'),(119,220,'CH','SG','St. Gallen'),(120,220,'CH','SH','Schaffhausen'),(121,220,'CH','SO','Solothurn'),(122,220,'CH','SZ','Schwyz'),(123,220,'CH','TG','Thurgau'),(124,220,'CH','TI','Tessin'),(125,220,'CH','UR','Uri'),(126,220,'CH','VD','Waadt'),(127,220,'CH','VS','Wallis'),(128,220,'CH','ZG','Zug'),(129,220,'CH','ZH','Zürich'),(130,206,'ES','A Coruсa','A Coruña'),(131,206,'ES','Alava','Alava'),(132,206,'ES','Albacete','Albacete'),(133,206,'ES','Alicante','Alicante'),(134,206,'ES','Almeria','Almeria'),(135,206,'ES','Asturias','Asturias'),(136,206,'ES','Avila','Avila'),(137,206,'ES','Badajoz','Badajoz'),(138,206,'ES','Baleares','Baleares'),(139,206,'ES','Barcelona','Barcelona'),(140,206,'ES','Burgos','Burgos'),(141,206,'ES','Caceres','Caceres'),(142,206,'ES','Cadiz','Cadiz'),(143,206,'ES','Cantabria','Cantabria'),(144,206,'ES','Castellon','Castellon'),(145,206,'ES','Ceuta','Ceuta'),(146,206,'ES','Ciudad Real','Ciudad Real'),(147,206,'ES','Cordoba','Cordoba'),(148,206,'ES','Cuenca','Cuenca'),(149,206,'ES','Girona','Girona'),(150,206,'ES','Granada','Granada'),(151,206,'ES','Guadalajara','Guadalajara'),(152,206,'ES','Guipuzcoa','Guipuzcoa'),(153,206,'ES','Huelva','Huelva'),(154,206,'ES','Huesca','Huesca'),(155,206,'ES','Jaen','Jaen'),(156,206,'ES','La Rioja','La Rioja'),(157,206,'ES','Las Palmas','Las Palmas'),(158,206,'ES','Leon','Leon'),(159,206,'ES','Lleida','Lleida'),(160,206,'ES','Lugo','Lugo'),(161,206,'ES','Madrid','Madrid'),(162,206,'ES','Malaga','Malaga'),(163,206,'ES','Melilla','Melilla'),(164,206,'ES','Murcia','Murcia'),(165,206,'ES','Navarra','Navarra'),(166,206,'ES','Ourense','Ourense'),(167,206,'ES','Palencia','Palencia'),(168,206,'ES','Pontevedra','Pontevedra'),(169,206,'ES','Salamanca','Salamanca'),(170,206,'ES','Santa Cruz de Tenerife','Santa Cruz de Tenerife'),(171,206,'ES','Segovia','Segovia'),(172,206,'ES','Sevilla','Sevilla'),(173,206,'ES','Soria','Soria'),(174,206,'ES','Tarragona','Tarragona'),(175,206,'ES','Teruel','Teruel'),(176,206,'ES','Toledo','Toledo'),(177,206,'ES','Valencia','Valencia'),(178,206,'ES','Valladolid','Valladolid'),(179,206,'ES','Vizcaya','Vizcaya'),(180,206,'ES','Zamora','Zamora'),(181,206,'ES','Zaragoza','Zaragoza'),(182,81,'FR','1','Ain'),(183,81,'FR','2','Aisne'),(184,81,'FR','3','Allier'),(185,81,'FR','4','Alpes-de-Haute-Provence'),(186,81,'FR','5','Hautes-Alpes'),(187,81,'FR','6','Alpes-Maritimes'),(188,81,'FR','7','Ardèche'),(189,81,'FR','8','Ardennes'),(190,81,'FR','9','Ariège'),(191,81,'FR','10','Aube'),(192,81,'FR','11','Aude'),(193,81,'FR','12','Aveyron'),(194,81,'FR','13','Bouches-du-Rhône'),(195,81,'FR','14','Calvados'),(196,81,'FR','15','Cantal'),(197,81,'FR','16','Charente'),(198,81,'FR','17','Charente-Maritime'),(199,81,'FR','18','Cher'),(200,81,'FR','19','Corrèze'),(201,81,'FR','2A','Corse-du-Sud'),(202,81,'FR','2B','Haute-Corse'),(203,81,'FR','21','Côte-d\'Or'),(204,81,'FR','22','Côtes-d\'Armor'),(205,81,'FR','23','Creuse'),(206,81,'FR','24','Dordogne'),(207,81,'FR','25','Doubs'),(208,81,'FR','26','Drôme'),(209,81,'FR','27','Eure'),(210,81,'FR','28','Eure-et-Loir'),(211,81,'FR','29','Finistère'),(212,81,'FR','30','Gard'),(213,81,'FR','31','Haute-Garonne'),(214,81,'FR','32','Gers'),(215,81,'FR','33','Gironde'),(216,81,'FR','34','Hérault'),(217,81,'FR','35','Ille-et-Vilaine'),(218,81,'FR','36','Indre'),(219,81,'FR','37','Indre-et-Loire'),(220,81,'FR','38','Isère'),(221,81,'FR','39','Jura'),(222,81,'FR','40','Landes'),(223,81,'FR','41','Loir-et-Cher'),(224,81,'FR','42','Loire'),(225,81,'FR','43','Haute-Loire'),(226,81,'FR','44','Loire-Atlantique'),(227,81,'FR','45','Loiret'),(228,81,'FR','46','Lot'),(229,81,'FR','47','Lot-et-Garonne'),(230,81,'FR','48','Lozère'),(231,81,'FR','49','Maine-et-Loire'),(232,81,'FR','50','Manche'),(233,81,'FR','51','Marne'),(234,81,'FR','52','Haute-Marne'),(235,81,'FR','53','Mayenne'),(236,81,'FR','54','Meurthe-et-Moselle'),(237,81,'FR','55','Meuse'),(238,81,'FR','56','Morbihan'),(239,81,'FR','57','Moselle'),(240,81,'FR','58','Nièvre'),(241,81,'FR','59','Nord'),(242,81,'FR','60','Oise'),(243,81,'FR','61','Orne'),(244,81,'FR','62','Pas-de-Calais'),(245,81,'FR','63','Puy-de-Dôme'),(246,81,'FR','64','Pyrénées-Atlantiques'),(247,81,'FR','65','Hautes-Pyrénées'),(248,81,'FR','66','Pyrénées-Orientales'),(249,81,'FR','67','Bas-Rhin'),(250,81,'FR','68','Haut-Rhin'),(251,81,'FR','69','Rhône'),(252,81,'FR','70','Haute-Saône'),(253,81,'FR','71','Saône-et-Loire'),(254,81,'FR','72','Sarthe'),(255,81,'FR','73','Savoie'),(256,81,'FR','74','Haute-Savoie'),(257,81,'FR','75','Paris'),(258,81,'FR','76','Seine-Maritime'),(259,81,'FR','77','Seine-et-Marne'),(260,81,'FR','78','Yvelines'),(261,81,'FR','79','Deux-Sèvres'),(262,81,'FR','80','Somme'),(263,81,'FR','81','Tarn'),(264,81,'FR','82','Tarn-et-Garonne'),(265,81,'FR','83','Var'),(266,81,'FR','84','Vaucluse'),(267,81,'FR','85','Vendée'),(268,81,'FR','86','Vienne'),(269,81,'FR','87','Haute-Vienne'),(270,81,'FR','88','Vosges'),(271,81,'FR','89','Yonne'),(272,81,'FR','90','Territoire-de-Belfort'),(273,81,'FR','91','Essonne'),(274,81,'FR','92','Hauts-de-Seine'),(275,81,'FR','93','Seine-Saint-Denis'),(276,81,'FR','94','Val-de-Marne'),(277,81,'FR','95','Val-d\'Oise'),(278,185,'RO','AB','Alba'),(279,185,'RO','AR','Arad'),(280,185,'RO','AG','Argeş'),(281,185,'RO','BC','Bacău'),(282,185,'RO','BH','Bihor'),(283,185,'RO','BN','Bistriţa-Năsăud'),(284,185,'RO','BT','Botoşani'),(285,185,'RO','BV','Braşov'),(286,185,'RO','BR','Brăila'),(287,185,'RO','B','Bucureşti'),(288,185,'RO','BZ','Buzău'),(289,185,'RO','CS','Caraş-Severin'),(290,185,'RO','CL','Călăraşi'),(291,185,'RO','CJ','Cluj'),(292,185,'RO','CT','Constanţa'),(293,185,'RO','CV','Covasna'),(294,185,'RO','DB','Dâmboviţa'),(295,185,'RO','DJ','Dolj'),(296,185,'RO','GL','Galaţi'),(297,185,'RO','GR','Giurgiu'),(298,185,'RO','GJ','Gorj'),(299,185,'RO','HR','Harghita'),(300,185,'RO','HD','Hunedoara'),(301,185,'RO','IL','Ialomiţa'),(302,185,'RO','IS','Iaşi'),(303,185,'RO','IF','Ilfov'),(304,185,'RO','MM','Maramureş'),(305,185,'RO','MH','Mehedinţi'),(306,185,'RO','MS','Mureş'),(307,185,'RO','NT','Neamţ'),(308,185,'RO','OT','Olt'),(309,185,'RO','PH','Prahova'),(310,185,'RO','SM','Satu-Mare'),(311,185,'RO','SJ','Sălaj'),(312,185,'RO','SB','Sibiu'),(313,185,'RO','SV','Suceava'),(314,185,'RO','TR','Teleorman'),(315,185,'RO','TM','Timiş'),(316,185,'RO','TL','Tulcea'),(317,185,'RO','VS','Vaslui'),(318,185,'RO','VL','Vâlcea'),(319,185,'RO','VN','Vrancea'),(320,80,'FI','Lappi','Lappi'),(321,80,'FI','Pohjois-Pohjanmaa','Pohjois-Pohjanmaa'),(322,80,'FI','Kainuu','Kainuu'),(323,80,'FI','Pohjois-Karjala','Pohjois-Karjala'),(324,80,'FI','Pohjois-Savo','Pohjois-Savo'),(325,80,'FI','Etelä-Savo','Etelä-Savo'),(326,80,'FI','Etelä-Pohjanmaa','Etelä-Pohjanmaa'),(327,80,'FI','Pohjanmaa','Pohjanmaa'),(328,80,'FI','Pirkanmaa','Pirkanmaa'),(329,80,'FI','Satakunta','Satakunta'),(330,80,'FI','Keski-Pohjanmaa','Keski-Pohjanmaa'),(331,80,'FI','Keski-Suomi','Keski-Suomi'),(332,80,'FI','Varsinais-Suomi','Varsinais-Suomi'),(333,80,'FI','Etelä-Karjala','Etelä-Karjala'),(334,80,'FI','Päijät-Häme','Päijät-Häme'),(335,80,'FI','Kanta-Häme','Kanta-Häme'),(336,80,'FI','Uusimaa','Uusimaa'),(337,80,'FI','Itä-Uusimaa','Itä-Uusimaa'),(338,80,'FI','Kymenlaakso','Kymenlaakso'),(339,80,'FI','Ahvenanmaa','Ahvenanmaa'),(340,74,'EE','EE-37','Harjumaa'),(341,74,'EE','EE-39','Hiiumaa'),(342,74,'EE','EE-44','Ida-Virumaa'),(343,74,'EE','EE-49','Jõgevamaa'),(344,74,'EE','EE-51','Järvamaa'),(345,74,'EE','EE-57','Läänemaa'),(346,74,'EE','EE-59','Lääne-Virumaa'),(347,74,'EE','EE-65','Põlvamaa'),(348,74,'EE','EE-67','Pärnumaa'),(349,74,'EE','EE-70','Raplamaa'),(350,74,'EE','EE-74','Saaremaa'),(351,74,'EE','EE-78','Tartumaa'),(352,74,'EE','EE-82','Valgamaa'),(353,74,'EE','EE-84','Viljandimaa'),(354,74,'EE','EE-86','Võrumaa'),(355,125,'LV','LV-DGV','Daugavpils'),(356,125,'LV','LV-JEL','Jelgava'),(357,125,'LV','Jēkabpils','Jēkabpils'),(358,125,'LV','LV-JUR','Jūrmala'),(359,125,'LV','LV-LPX','Liepāja'),(360,125,'LV','LV-LE','Liepājas novads'),(361,125,'LV','LV-REZ','Rēzekne'),(362,125,'LV','LV-RIX','Rīga'),(363,125,'LV','LV-RI','Rīgas novads'),(364,125,'LV','Valmiera','Valmiera'),(365,125,'LV','LV-VEN','Ventspils'),(366,125,'LV','Aglonas novads','Aglonas novads'),(367,125,'LV','LV-AI','Aizkraukles novads'),(368,125,'LV','Aizputes novads','Aizputes novads'),(369,125,'LV','Aknīstes novads','Aknīstes novads'),(370,125,'LV','Alojas novads','Alojas novads'),(371,125,'LV','Alsungas novads','Alsungas novads'),(372,125,'LV','LV-AL','Alūksnes novads'),(373,125,'LV','Amatas novads','Amatas novads'),(374,125,'LV','Apes novads','Apes novads'),(375,125,'LV','Auces novads','Auces novads'),(376,125,'LV','Babītes novads','Babītes novads'),(377,125,'LV','Baldones novads','Baldones novads'),(378,125,'LV','Baltinavas novads','Baltinavas novads'),(379,125,'LV','LV-BL','Balvu novads'),(380,125,'LV','LV-BU','Bauskas novads'),(381,125,'LV','Beverīnas novads','Beverīnas novads'),(382,125,'LV','Brocēnu novads','Brocēnu novads'),(383,125,'LV','Burtnieku novads','Burtnieku novads'),(384,125,'LV','Carnikavas novads','Carnikavas novads'),(385,125,'LV','Cesvaines novads','Cesvaines novads'),(386,125,'LV','Ciblas novads','Ciblas novads'),(387,125,'LV','LV-CE','Cēsu novads'),(388,125,'LV','Dagdas novads','Dagdas novads'),(389,125,'LV','LV-DA','Daugavpils novads'),(390,125,'LV','LV-DO','Dobeles novads'),(391,125,'LV','Dundagas novads','Dundagas novads'),(392,125,'LV','Durbes novads','Durbes novads'),(393,125,'LV','Engures novads','Engures novads'),(394,125,'LV','Garkalnes novads','Garkalnes novads'),(395,125,'LV','Grobiņas novads','Grobiņas novads'),(396,125,'LV','LV-GU','Gulbenes novads'),(397,125,'LV','Iecavas novads','Iecavas novads'),(398,125,'LV','Ikšķiles novads','Ikšķiles novads'),(399,125,'LV','Ilūkstes novads','Ilūkstes novads'),(400,125,'LV','Inčukalna novads','Inčukalna novads'),(401,125,'LV','Jaunjelgavas novads','Jaunjelgavas novads'),(402,125,'LV','Jaunpiebalgas novads','Jaunpiebalgas novads'),(403,125,'LV','Jaunpils novads','Jaunpils novads'),(404,125,'LV','LV-JL','Jelgavas novads'),(405,125,'LV','LV-JK','Jēkabpils novads'),(406,125,'LV','Kandavas novads','Kandavas novads'),(407,125,'LV','Kokneses novads','Kokneses novads'),(408,125,'LV','Krimuldas novads','Krimuldas novads'),(409,125,'LV','Krustpils novads','Krustpils novads'),(410,125,'LV','LV-KR','Krāslavas novads'),(411,125,'LV','LV-KU','Kuldīgas novads'),(412,125,'LV','Kārsavas novads','Kārsavas novads'),(413,125,'LV','Lielvārdes novads','Lielvārdes novads'),(414,125,'LV','LV-LM','Limbažu novads'),(415,125,'LV','Lubānas novads','Lubānas novads'),(416,125,'LV','LV-LU','Ludzas novads'),(417,125,'LV','Līgatnes novads','Līgatnes novads'),(418,125,'LV','Līvānu novads','Līvānu novads'),(419,125,'LV','LV-MA','Madonas novads'),(420,125,'LV','Mazsalacas novads','Mazsalacas novads'),(421,125,'LV','Mālpils novads','Mālpils novads'),(422,125,'LV','Mārupes novads','Mārupes novads'),(423,125,'LV','Naukšēnu novads','Naukšēnu novads'),(424,125,'LV','Neretas novads','Neretas novads'),(425,125,'LV','Nīcas novads','Nīcas novads'),(426,125,'LV','LV-OG','Ogres novads'),(427,125,'LV','Olaines novads','Olaines novads'),(428,125,'LV','Ozolnieku novads','Ozolnieku novads'),(429,125,'LV','LV-PR','Preiļu novads'),(430,125,'LV','Priekules novads','Priekules novads'),(431,125,'LV','Priekuļu novads','Priekuļu novads'),(432,125,'LV','Pārgaujas novads','Pārgaujas novads'),(433,125,'LV','Pāvilostas novads','Pāvilostas novads'),(434,125,'LV','Pļaviņu novads','Pļaviņu novads'),(435,125,'LV','Raunas novads','Raunas novads'),(436,125,'LV','Riebiņu novads','Riebiņu novads'),(437,125,'LV','Rojas novads','Rojas novads'),(438,125,'LV','Ropažu novads','Ropažu novads'),(439,125,'LV','Rucavas novads','Rucavas novads'),(440,125,'LV','Rugāju novads','Rugāju novads'),(441,125,'LV','Rundāles novads','Rundāles novads'),(442,125,'LV','LV-RE','Rēzeknes novads'),(443,125,'LV','Rūjienas novads','Rūjienas novads'),(444,125,'LV','Salacgrīvas novads','Salacgrīvas novads'),(445,125,'LV','Salas novads','Salas novads'),(446,125,'LV','Salaspils novads','Salaspils novads'),(447,125,'LV','LV-SA','Saldus novads'),(448,125,'LV','Saulkrastu novads','Saulkrastu novads'),(449,125,'LV','Siguldas novads','Siguldas novads'),(450,125,'LV','Skrundas novads','Skrundas novads'),(451,125,'LV','Skrīveru novads','Skrīveru novads'),(452,125,'LV','Smiltenes novads','Smiltenes novads'),(453,125,'LV','Stopiņu novads','Stopiņu novads'),(454,125,'LV','Strenču novads','Strenču novads'),(455,125,'LV','Sējas novads','Sējas novads'),(456,125,'LV','LV-TA','Talsu novads'),(457,125,'LV','LV-TU','Tukuma novads'),(458,125,'LV','Tērvetes novads','Tērvetes novads'),(459,125,'LV','Vaiņodes novads','Vaiņodes novads'),(460,125,'LV','LV-VK','Valkas novads'),(461,125,'LV','LV-VM','Valmieras novads'),(462,125,'LV','Varakļānu novads','Varakļānu novads'),(463,125,'LV','Vecpiebalgas novads','Vecpiebalgas novads'),(464,125,'LV','Vecumnieku novads','Vecumnieku novads'),(465,125,'LV','LV-VE','Ventspils novads'),(466,125,'LV','Viesītes novads','Viesītes novads'),(467,125,'LV','Viļakas novads','Viļakas novads'),(468,125,'LV','Viļānu novads','Viļānu novads'),(469,125,'LV','Vārkavas novads','Vārkavas novads'),(470,125,'LV','Zilupes novads','Zilupes novads'),(471,125,'LV','Ādažu novads','Ādažu novads'),(472,125,'LV','Ērgļu novads','Ērgļu novads'),(473,125,'LV','Ķeguma novads','Ķeguma novads'),(474,125,'LV','Ķekavas novads','Ķekavas novads'),(475,131,'LT','LT-AL','Alytaus Apskritis'),(476,131,'LT','LT-KU','Kauno Apskritis'),(477,131,'LT','LT-KL','Klaipėdos Apskritis'),(478,131,'LT','LT-MR','Marijampolės Apskritis'),(479,131,'LT','LT-PN','Panevėžio Apskritis'),(480,131,'LT','LT-SA','Šiaulių Apskritis'),(481,131,'LT','LT-TA','Tauragės Apskritis'),(482,131,'LT','LT-TE','Telšių Apskritis'),(483,131,'LT','LT-UT','Utenos Apskritis'),(484,131,'LT','LT-VL','Vilniaus Apskritis'),(485,31,'BR','AC','Acre'),(486,31,'BR','AL','Alagoas'),(487,31,'BR','AP','Amapá'),(488,31,'BR','AM','Amazonas'),(489,31,'BR','BA','Bahia'),(490,31,'BR','CE','Ceará'),(491,31,'BR','ES','Espírito Santo'),(492,31,'BR','GO','Goiás'),(493,31,'BR','MA','Maranhão'),(494,31,'BR','MT','Mato Grosso'),(495,31,'BR','MS','Mato Grosso do Sul'),(496,31,'BR','MG','Minas Gerais'),(497,31,'BR','PA','Pará'),(498,31,'BR','PB','Paraíba'),(499,31,'BR','PR','Paraná'),(500,31,'BR','PE','Pernambuco'),(501,31,'BR','PI','Piauí'),(502,31,'BR','RJ','Rio de Janeiro'),(503,31,'BR','RN','Rio Grande do Norte'),(504,31,'BR','RS','Rio Grande do Sul'),(505,31,'BR','RO','Rondônia'),(506,31,'BR','RR','Roraima'),(507,31,'BR','SC','Santa Catarina'),(508,31,'BR','SP','São Paulo'),(509,31,'BR','SE','Sergipe'),(510,31,'BR','TO','Tocantins'),(511,31,'BR','DF','Distrito Federal'),(512,59,'HR','HR-01','Zagrebačka županija'),(513,59,'HR','HR-02','Krapinsko-zagorska županija'),(514,59,'HR','HR-03','Sisačko-moslavačka županija'),(515,59,'HR','HR-04','Karlovačka županija'),(516,59,'HR','HR-05','Varaždinska županija'),(517,59,'HR','HR-06','Koprivničko-križevačka županija'),(518,59,'HR','HR-07','Bjelovarsko-bilogorska županija'),(519,59,'HR','HR-08','Primorsko-goranska županija'),(520,59,'HR','HR-09','Ličko-senjska županija'),(521,59,'HR','HR-10','Virovitičko-podravska županija'),(522,59,'HR','HR-11','Požeško-slavonska županija'),(523,59,'HR','HR-12','Brodsko-posavska županija'),(524,59,'HR','HR-13','Zadarska županija'),(525,59,'HR','HR-14','Osječko-baranjska županija'),(526,59,'HR','HR-15','Šibensko-kninska županija'),(527,59,'HR','HR-16','Vukovarsko-srijemska županija'),(528,59,'HR','HR-17','Splitsko-dalmatinska županija'),(529,59,'HR','HR-18','Istarska županija'),(530,59,'HR','HR-19','Dubrovačko-neretvanska županija'),(531,59,'HR','HR-20','Međimurska županija'),(532,59,'HR','HR-21','Grad Zagreb'),(533,106,'IN','AN','Andaman and Nicobar Islands'),(534,106,'IN','AP','Andhra Pradesh'),(535,106,'IN','AR','Arunachal Pradesh'),(536,106,'IN','AS','Assam'),(537,106,'IN','BR','Bihar'),(538,106,'IN','CH','Chandigarh'),(539,106,'IN','CT','Chhattisgarh'),(540,106,'IN','DN','Dadra and Nagar Haveli'),(541,106,'IN','DD','Daman and Diu'),(542,106,'IN','DL','Delhi'),(543,106,'IN','GA','Goa'),(544,106,'IN','GJ','Gujarat'),(545,106,'IN','HR','Haryana'),(546,106,'IN','HP','Himachal Pradesh'),(547,106,'IN','JK','Jammu and Kashmir'),(548,106,'IN','JH','Jharkhand'),(549,106,'IN','KA','Karnataka'),(550,106,'IN','KL','Kerala'),(551,106,'IN','LD','Lakshadweep'),(552,106,'IN','MP','Madhya Pradesh'),(553,106,'IN','MH','Maharashtra'),(554,106,'IN','MN','Manipur'),(555,106,'IN','ML','Meghalaya'),(556,106,'IN','MZ','Mizoram'),(557,106,'IN','NL','Nagaland'),(558,106,'IN','OR','Odisha'),(559,106,'IN','PY','Puducherry'),(560,106,'IN','PB','Punjab'),(561,106,'IN','RJ','Rajasthan'),(562,106,'IN','SK','Sikkim'),(563,106,'IN','TN','Tamil Nadu'),(564,106,'IN','TG','Telangana'),(565,106,'IN','TR','Tripura'),(566,106,'IN','UP','Uttar Pradesh'),(567,106,'IN','UT','Uttarakhand'),(568,106,'IN','WB','West Bengal'),(569,176,'PY','PY-16','Alto Paraguay'),(570,176,'PY','PY-10','Alto Paraná'),(571,176,'PY','PY-13','Amambay'),(572,176,'PY','PY-ASU','Asunción'),(573,176,'PY','PY-19','Boquerón'),(574,176,'PY','PY-5','Caaguazú'),(575,176,'PY','PY-6','Caazapá'),(576,176,'PY','PY-14','Canindeyú'),(577,176,'PY','PY-11','Central'),(578,176,'PY','PY-1','Concepción'),(579,176,'PY','PY-3','Cordillera'),(580,176,'PY','PY-4','Guairá'),(581,176,'PY','PY-7','Itapúa'),(582,176,'PY','PY-8','Misiones'),(583,176,'PY','PY-9','Paraguarí'),(584,176,'PY','PY-15','Presidente Hayes'),(585,176,'PY','PY-2','San Pedro'),(586,176,'PY','PY-12','Ñeembucú');

--
-- Table structure for table `country_translations`
--

CREATE TABLE `country_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `country_id` int(10) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `name` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `country_translations_country_id_foreign` (`country_id`),
  CONSTRAINT `country_translations_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `country_translations`
--


--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `symbol` varchar(255) DEFAULT NULL,
  `decimal` int(10) unsigned NOT NULL DEFAULT 2,
  `group_separator` varchar(255) NOT NULL DEFAULT ',',
  `decimal_separator` varchar(255) NOT NULL DEFAULT '.',
  `currency_position` varchar(255) DEFAULT NULL,
  `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 `currencies`
--

INSERT INTO `currencies` VALUES (1,'USD','United States Dollar','$',2,',','.','right_with_space',NULL,'2026-02-25 14:17:30'),(4,'MZN','Metical Moçambicano','MZN',2,',','.','left','2026-02-25 12:50:47','2026-02-25 14:20:09');

--
-- Table structure for table `currency_exchange_rates`
--

CREATE TABLE `currency_exchange_rates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rate` decimal(24,12) NOT NULL,
  `target_currency` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `currency_exchange_rates_target_currency_unique` (`target_currency`),
  CONSTRAINT `currency_exchange_rates_target_currency_foreign` FOREIGN KEY (`target_currency`) REFERENCES `currencies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currency_exchange_rates`
--


--
-- Table structure for table `customer_groups`
--

CREATE TABLE `customer_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `is_user_defined` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `customer_groups_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_groups`
--

INSERT INTO `customer_groups` VALUES (1,'guest','Guest',0,NULL,NULL),(2,'general','General',0,NULL,NULL),(3,'wholesale','Wholesale',0,NULL,NULL);

--
-- Table structure for table `customer_notes`
--

CREATE TABLE `customer_notes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(10) unsigned DEFAULT NULL,
  `note` text NOT NULL,
  `customer_notified` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `customer_notes_customer_id_foreign` (`customer_id`),
  CONSTRAINT `customer_notes_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_notes`
--


--
-- Table structure for table `customer_social_accounts`
--

CREATE TABLE `customer_social_accounts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(10) unsigned NOT NULL,
  `provider_name` varchar(255) DEFAULT NULL,
  `provider_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `customer_social_accounts_provider_id_unique` (`provider_id`),
  KEY `customer_social_accounts_customer_id_foreign` (`customer_id`),
  CONSTRAINT `customer_social_accounts_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_social_accounts`
--


--
-- Table structure for table `datagrid_saved_filters`
--

CREATE TABLE `datagrid_saved_filters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `src` varchar(255) NOT NULL,
  `applied` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`applied`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `datagrid_saved_filters_user_id_name_src_unique` (`user_id`,`name`,`src`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `datagrid_saved_filters`
--


--
-- Table structure for table `downloadable_link_purchased`
--

CREATE TABLE `downloadable_link_purchased` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `product_name` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `download_bought` int(11) NOT NULL DEFAULT 0,
  `download_used` int(11) NOT NULL DEFAULT 0,
  `status` varchar(255) DEFAULT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  `order_id` int(10) unsigned NOT NULL,
  `order_item_id` int(10) unsigned NOT NULL,
  `download_canceled` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `downloadable_link_purchased_customer_id_foreign` (`customer_id`),
  KEY `downloadable_link_purchased_order_id_foreign` (`order_id`),
  KEY `downloadable_link_purchased_order_item_id_foreign` (`order_item_id`),
  CONSTRAINT `downloadable_link_purchased_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `downloadable_link_purchased_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `downloadable_link_purchased_order_item_id_foreign` FOREIGN KEY (`order_item_id`) REFERENCES `order_items` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `downloadable_link_purchased`
--

INSERT INTO `downloadable_link_purchased` VALUES (1,'Agua Mineral','AguaDownload',NULL,'product_downloadable_links/2/40wCeTA7OKRTOFI48wGGInOJtUnqPQINmQkun9S7.pdf','Pre-Projecto - Lourenço Macilau Vilanculo Junior.pdf','file',2,0,'available',1,7,7,0,'2026-02-26 11:06:22','2026-02-26 11:14:17');

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext 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 `gdpr_data_request`
--

CREATE TABLE `gdpr_data_request` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(10) unsigned NOT NULL,
  `email` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `message` varchar(500) NOT NULL,
  `revoked_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gdpr_data_request_customer_id_foreign` (`customer_id`),
  CONSTRAINT `gdpr_data_request_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gdpr_data_request`
--


--
-- Table structure for table `import_batches`
--

CREATE TABLE `import_batches` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `state` varchar(255) NOT NULL DEFAULT 'pending',
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`data`)),
  `summary` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`summary`)),
  `import_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `import_batches_import_id_foreign` (`import_id`),
  CONSTRAINT `import_batches_import_id_foreign` FOREIGN KEY (`import_id`) REFERENCES `imports` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `import_batches`
--


--
-- Table structure for table `imports`
--

CREATE TABLE `imports` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `state` varchar(255) NOT NULL DEFAULT 'pending',
  `process_in_queue` tinyint(1) NOT NULL DEFAULT 1,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `validation_strategy` varchar(255) NOT NULL,
  `allowed_errors` int(11) NOT NULL DEFAULT 0,
  `processed_rows_count` int(11) NOT NULL DEFAULT 0,
  `invalid_rows_count` int(11) NOT NULL DEFAULT 0,
  `errors_count` int(11) NOT NULL DEFAULT 0,
  `errors` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`errors`)),
  `field_separator` varchar(255) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `images_directory_path` varchar(255) DEFAULT NULL,
  `error_file_path` varchar(255) DEFAULT NULL,
  `summary` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`summary`)),
  `started_at` datetime DEFAULT NULL,
  `completed_at` datetime 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 `imports`
--


--
-- Table structure for table `inventory_sources`
--

CREATE TABLE `inventory_sources` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `contact_name` varchar(255) NOT NULL,
  `contact_email` varchar(255) NOT NULL,
  `contact_number` varchar(255) NOT NULL,
  `contact_fax` varchar(255) DEFAULT NULL,
  `country` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `street` varchar(255) NOT NULL,
  `postcode` varchar(255) NOT NULL,
  `priority` int(11) NOT NULL DEFAULT 0,
  `latitude` decimal(10,5) DEFAULT NULL,
  `longitude` decimal(10,5) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `vendor_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `inventory_sources_code_unique` (`code`),
  KEY `inventory_sources_vendor_id_foreign` (`vendor_id`),
  CONSTRAINT `inventory_sources_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `marketplace_sellers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventory_sources`
--

INSERT INTO `inventory_sources` VALUES (1,'default','Default',NULL,'Default','warehouse@example.com','1234567899',NULL,'US','MI','Detroit','12th Street','48127',0,NULL,NULL,1,NULL,NULL,NULL),(3,'vendorseller2','Marquardt, Connelly and Brakus',NULL,'LM','seller2@example.com','8928626808',NULL,'KG','South Dakota','Marshallton','55081 Joe Forge Apt. 747\nSpinkachester, SD 80525-7141','95689',0,NULL,NULL,1,2,'2026-02-25 21:33:20','2026-02-25 21:33:20'),(4,'vendorPMD','Stamm-Prohaska',NULL,'Muhammad Machado','muhmachado90@gmail.com','1180970197',NULL,'AX','Vermont','Leannonborough','975 Ebert Light Apt. 697\nMcKenziehaven, AR 05580-1090','05413-1080',0,NULL,NULL,1,3,'2026-03-12 16:05:19','2026-03-12 16:05:19');

--
-- Table structure for table `invoice_items`
--

CREATE TABLE `invoice_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `sku` varchar(255) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `price` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_price` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `total` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_total` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `tax_amount` decimal(12,4) DEFAULT 0.0000,
  `base_tax_amount` decimal(12,4) DEFAULT 0.0000,
  `discount_percent` decimal(12,4) DEFAULT 0.0000,
  `discount_amount` decimal(12,4) DEFAULT 0.0000,
  `base_discount_amount` decimal(12,4) DEFAULT 0.0000,
  `price_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_price_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `total_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_total_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `product_id` int(10) unsigned DEFAULT NULL,
  `product_type` varchar(255) DEFAULT NULL,
  `order_item_id` int(10) unsigned DEFAULT NULL,
  `invoice_id` int(10) unsigned DEFAULT NULL,
  `additional` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`additional`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_items_invoice_id_foreign` (`invoice_id`),
  KEY `invoice_items_parent_id_foreign` (`parent_id`),
  CONSTRAINT `invoice_items_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoice_items_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `invoice_items` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoice_items`
--

INSERT INTO `invoice_items` VALUES (1,NULL,NULL,NULL,'Bla',2,100.0000,100.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,200.0000,200.0000,1,'Webkul\\Marketplace\\Models\\Product\\Product',4,1,'{\"quantity\":2,\"product_id\":1,\"cart_id\":6,\"attributes\":[],\"locale\":\"pt_BR\"}','2026-02-25 12:02:47','2026-02-25 12:02:47'),(2,NULL,'Agua Mineral',NULL,'Agua',2,200.0000,200.0000,400.0000,400.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,400.0000,400.0000,2,'Webkul\\Marketplace\\Models\\Product\\Product',7,2,'{\"product_id\":2,\"is_buy_now\":\"0\",\"links\":[\"1\"],\"Seller_Rating\":\"0.0\",\"quantity\":2,\"seller_info\":{\"product_id\":1,\"seller_id\":2,\"is_owner\":1},\"cart_id\":15,\"attributes\":[{\"attribute_name\":\"Downloads\",\"option_id\":0,\"option_label\":\"AguaDownload\"},{\"attribute_type\":\"marketplace\",\"attribute_name\":\"Vendido por\",\"option_label\":\"seller2\"}],\"locale\":\"pt_BR\"}','2026-02-26 11:14:17','2026-02-26 11:14:17'),(3,NULL,NULL,NULL,'Bla',1,100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,100.0000,100.0000,1,'Webkul\\Marketplace\\Models\\Product\\Product',8,3,'{\"quantity\":1,\"product_id\":1,\"cart_id\":18,\"attributes\":[],\"locale\":\"pt_BR\"}','2026-02-26 11:43:13','2026-02-26 11:43:13'),(4,NULL,'Bolacha Maria',NULL,'Bolachas',2,400.0000,400.0000,800.0000,800.0000,0.0000,0.0000,0.0000,0.0000,0.0000,400.0000,400.0000,800.0000,800.0000,4,'Webkul\\Marketplace\\Models\\Product\\Product',9,4,'{\"product_id\":4,\"quantity\":2,\"is_buy_now\":0,\"cart_id\":19,\"attributes\":[],\"locale\":\"pt_BR\"}','2026-03-14 14:16:58','2026-03-14 14:16:58');

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `increment_id` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `email_sent` tinyint(1) NOT NULL DEFAULT 0,
  `total_qty` int(11) DEFAULT NULL,
  `base_currency_code` varchar(255) DEFAULT NULL,
  `channel_currency_code` varchar(255) DEFAULT NULL,
  `order_currency_code` varchar(255) DEFAULT NULL,
  `sub_total` decimal(12,4) DEFAULT 0.0000,
  `base_sub_total` decimal(12,4) DEFAULT 0.0000,
  `grand_total` decimal(12,4) DEFAULT 0.0000,
  `base_grand_total` decimal(12,4) DEFAULT 0.0000,
  `shipping_amount` decimal(12,4) DEFAULT 0.0000,
  `base_shipping_amount` decimal(12,4) DEFAULT 0.0000,
  `tax_amount` decimal(12,4) DEFAULT 0.0000,
  `base_tax_amount` decimal(12,4) DEFAULT 0.0000,
  `discount_amount` decimal(12,4) DEFAULT 0.0000,
  `base_discount_amount` decimal(12,4) DEFAULT 0.0000,
  `shipping_tax_amount` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_shipping_tax_amount` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `sub_total_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_sub_total_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `shipping_amount_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_shipping_amount_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `order_id` int(10) unsigned DEFAULT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `reminders` int(11) NOT NULL DEFAULT 0,
  `next_reminder_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoices_order_id_foreign` (`order_id`),
  CONSTRAINT `invoices_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoices`
--

INSERT INTO `invoices` VALUES (1,'1','paid',1,2,'USD','USD','USD',200.0000,200.0000,200.0000,200.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,200.0000,200.0000,0.0000,0.0000,4,NULL,0,NULL,'2026-02-25 12:02:47','2026-03-14 14:17:15'),(2,'2','paid',1,2,'USD','MZN','MZN',400.0000,400.0000,400.0000,400.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,400.0000,400.0000,0.0000,0.0000,7,NULL,0,NULL,'2026-02-26 11:14:17','2026-03-14 14:17:15'),(3,'3','paid',1,1,'USD','MZN','MZN',100.0000,100.0000,100.0000,100.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,100.0000,100.0000,0.0000,0.0000,8,NULL,0,NULL,'2026-02-26 11:43:13','2026-03-14 14:17:15'),(4,'4','paid',1,2,'USD','MZN','MZN',800.0000,800.0000,800.0000,800.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,800.0000,800.0000,0.0000,0.0000,9,NULL,0,NULL,'2026-03-14 14:16:58','2026-03-14 14:17:15');

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` text NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `locales`
--

CREATE TABLE `locales` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `direction` enum('ltr','rtl') NOT NULL DEFAULT 'ltr',
  `logo_path` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `locales_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `locales`
--

INSERT INTO `locales` VALUES (1,'en','English','ltr','locales/uixgyHqLkP8etd1S5c50VFUBqlhNtzlUMx2fpDu7.png',NULL,NULL),(5,'pt_BR','Portugues Brazil','ltr',NULL,'2026-02-21 23:51:45','2026-02-21 23:51:45');

--
-- Table structure for table `marketing_campaigns`
--

CREATE TABLE `marketing_campaigns` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `type` varchar(255) NOT NULL,
  `mail_to` varchar(255) NOT NULL,
  `spooling` varchar(255) DEFAULT NULL,
  `channel_id` int(10) unsigned DEFAULT NULL,
  `customer_group_id` int(10) unsigned DEFAULT NULL,
  `marketing_template_id` int(10) unsigned DEFAULT NULL,
  `marketing_event_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketing_campaigns_channel_id_foreign` (`channel_id`),
  KEY `marketing_campaigns_customer_group_id_foreign` (`customer_group_id`),
  KEY `marketing_campaigns_marketing_template_id_foreign` (`marketing_template_id`),
  KEY `marketing_campaigns_marketing_event_id_foreign` (`marketing_event_id`),
  CONSTRAINT `marketing_campaigns_channel_id_foreign` FOREIGN KEY (`channel_id`) REFERENCES `channels` (`id`) ON DELETE SET NULL,
  CONSTRAINT `marketing_campaigns_customer_group_id_foreign` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_groups` (`id`) ON DELETE SET NULL,
  CONSTRAINT `marketing_campaigns_marketing_event_id_foreign` FOREIGN KEY (`marketing_event_id`) REFERENCES `marketing_events` (`id`) ON DELETE SET NULL,
  CONSTRAINT `marketing_campaigns_marketing_template_id_foreign` FOREIGN KEY (`marketing_template_id`) REFERENCES `marketing_templates` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketing_campaigns`
--


--
-- Table structure for table `marketing_events`
--

CREATE TABLE `marketing_events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketing_events`
--

INSERT INTO `marketing_events` VALUES (1,'Birthday','Birthday',NULL,NULL,NULL);

--
-- Table structure for table `marketing_templates`
--

CREATE TABLE `marketing_templates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `content` text 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 `marketing_templates`
--


--
-- Table structure for table `marketplace_invoice_items`
--

CREATE TABLE `marketplace_invoice_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `marketplace_invoice_id` int(10) unsigned NOT NULL,
  `invoice_item_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_invoice_items_marketplace_invoice_id_foreign` (`marketplace_invoice_id`),
  KEY `marketplace_invoice_items_invoice_item_id_foreign` (`invoice_item_id`),
  CONSTRAINT `marketplace_invoice_items_invoice_item_id_foreign` FOREIGN KEY (`invoice_item_id`) REFERENCES `invoice_items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_invoice_items_marketplace_invoice_id_foreign` FOREIGN KEY (`marketplace_invoice_id`) REFERENCES `marketplace_invoices` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_invoice_items`
--

INSERT INTO `marketplace_invoice_items` VALUES (1,1,2);

--
-- Table structure for table `marketplace_invoices`
--

CREATE TABLE `marketplace_invoices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `state` varchar(255) DEFAULT NULL,
  `email_sent` tinyint(1) NOT NULL DEFAULT 0,
  `total_qty` int(11) DEFAULT NULL,
  `sub_total` decimal(12,4) DEFAULT 0.0000,
  `base_sub_total` decimal(12,4) DEFAULT 0.0000,
  `grand_total` decimal(12,4) DEFAULT 0.0000,
  `base_grand_total` decimal(12,4) DEFAULT 0.0000,
  `shipping_amount` decimal(12,4) DEFAULT 0.0000,
  `base_shipping_amount` decimal(12,4) DEFAULT 0.0000,
  `tax_amount` decimal(12,4) DEFAULT 0.0000,
  `base_tax_amount` decimal(12,4) DEFAULT 0.0000,
  `discount_amount` decimal(12,4) DEFAULT 0.0000,
  `base_discount_amount` decimal(12,4) DEFAULT 0.0000,
  `sub_total_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_sub_total_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `shipping_amount_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_shipping_amount_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `invoice_id` int(10) unsigned NOT NULL,
  `marketplace_order_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_invoices_invoice_id_foreign` (`invoice_id`),
  KEY `marketplace_invoices_marketplace_order_id_foreign` (`marketplace_order_id`),
  CONSTRAINT `marketplace_invoices_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_invoices_marketplace_order_id_foreign` FOREIGN KEY (`marketplace_order_id`) REFERENCES `marketplace_orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_invoices`
--

INSERT INTO `marketplace_invoices` VALUES (1,'paid',0,2,400.0000,400.0000,400.0000,400.0000,NULL,NULL,0.0000,0.0000,0.0000,0.0000,400.0000,400.0000,0.0000,0.0000,2,1,'2026-02-26 11:14:20','2026-02-26 11:14:21');

--
-- Table structure for table `marketplace_order_items`
--

CREATE TABLE `marketplace_order_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `commission` decimal(12,4) DEFAULT 0.0000,
  `base_commission` decimal(12,4) DEFAULT 0.0000,
  `commission_invoiced` decimal(12,4) DEFAULT 0.0000,
  `base_commission_invoiced` decimal(12,4) DEFAULT 0.0000,
  `seller_total` decimal(12,4) DEFAULT 0.0000,
  `base_seller_total` decimal(12,4) DEFAULT 0.0000,
  `seller_total_invoiced` decimal(12,4) DEFAULT 0.0000,
  `base_seller_total_invoiced` decimal(12,4) DEFAULT 0.0000,
  `order_item_id` int(10) unsigned NOT NULL,
  `marketplace_product_id` int(10) unsigned DEFAULT NULL,
  `marketplace_order_id` int(10) unsigned NOT NULL,
  `parent_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_order_items_order_item_id_foreign` (`order_item_id`),
  KEY `marketplace_order_items_marketplace_product_id_foreign` (`marketplace_product_id`),
  KEY `marketplace_order_items_marketplace_order_id_foreign` (`marketplace_order_id`),
  KEY `marketplace_order_items_parent_id_foreign` (`parent_id`),
  CONSTRAINT `marketplace_order_items_marketplace_order_id_foreign` FOREIGN KEY (`marketplace_order_id`) REFERENCES `marketplace_orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_order_items_marketplace_product_id_foreign` FOREIGN KEY (`marketplace_product_id`) REFERENCES `marketplace_products` (`id`) ON DELETE SET NULL,
  CONSTRAINT `marketplace_order_items_order_item_id_foreign` FOREIGN KEY (`order_item_id`) REFERENCES `order_items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_order_items_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `marketplace_order_items` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_order_items`
--

INSERT INTO `marketplace_order_items` VALUES (1,80.0000,80.0000,80.0000,80.0000,320.0000,320.0000,320.0000,320.0000,7,1,1,NULL);

--
-- Table structure for table `marketplace_orders`
--

CREATE TABLE `marketplace_orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(255) DEFAULT NULL,
  `is_withdrawal_requested` tinyint(1) NOT NULL DEFAULT 0,
  `seller_payout_status` varchar(255) DEFAULT NULL,
  `commission_percentage` decimal(12,4) DEFAULT 0.0000,
  `commission` decimal(12,4) DEFAULT 0.0000,
  `base_commission` decimal(12,4) DEFAULT 0.0000,
  `commission_invoiced` decimal(12,4) DEFAULT 0.0000,
  `base_commission_invoiced` decimal(12,4) DEFAULT 0.0000,
  `seller_total` decimal(12,4) DEFAULT 0.0000,
  `base_seller_total` decimal(12,4) DEFAULT 0.0000,
  `seller_total_invoiced` decimal(12,4) DEFAULT 0.0000,
  `base_seller_total_invoiced` decimal(12,4) DEFAULT 0.0000,
  `total_item_count` int(11) DEFAULT NULL,
  `total_qty_ordered` int(11) DEFAULT NULL,
  `grand_total` decimal(12,4) DEFAULT 0.0000,
  `base_grand_total` decimal(12,4) DEFAULT 0.0000,
  `grand_total_invoiced` decimal(12,4) DEFAULT 0.0000,
  `base_grand_total_invoiced` decimal(12,4) DEFAULT 0.0000,
  `grand_total_refunded` decimal(12,4) DEFAULT 0.0000,
  `base_grand_total_refunded` decimal(12,4) DEFAULT 0.0000,
  `sub_total` decimal(12,4) DEFAULT 0.0000,
  `base_sub_total` decimal(12,4) DEFAULT 0.0000,
  `sub_total_invoiced` decimal(12,4) DEFAULT 0.0000,
  `base_sub_total_invoiced` decimal(12,4) DEFAULT 0.0000,
  `sub_total_refunded` decimal(12,4) DEFAULT 0.0000,
  `base_sub_total_refunded` decimal(12,4) DEFAULT 0.0000,
  `discount_percent` decimal(12,4) DEFAULT 0.0000,
  `discount_amount` decimal(12,4) DEFAULT 0.0000,
  `base_discount_amount` decimal(12,4) DEFAULT 0.0000,
  `discount_amount_invoiced` decimal(12,4) DEFAULT 0.0000,
  `base_discount_amount_invoiced` decimal(12,4) DEFAULT 0.0000,
  `discount_refunded` decimal(12,4) DEFAULT 0.0000,
  `base_discount_refunded` decimal(12,4) DEFAULT 0.0000,
  `tax_amount` decimal(12,4) DEFAULT 0.0000,
  `base_tax_amount` decimal(12,4) DEFAULT 0.0000,
  `tax_amount_invoiced` decimal(12,4) DEFAULT 0.0000,
  `base_tax_amount_invoiced` decimal(12,4) DEFAULT 0.0000,
  `tax_amount_refunded` decimal(12,4) DEFAULT 0.0000,
  `base_tax_amount_refunded` decimal(12,4) DEFAULT 0.0000,
  `shipping_amount` decimal(12,4) DEFAULT 0.0000,
  `base_shipping_amount` decimal(12,4) DEFAULT 0.0000,
  `shipping_invoiced` decimal(12,4) DEFAULT 0.0000,
  `base_shipping_invoiced` decimal(12,4) DEFAULT 0.0000,
  `shipping_refunded` decimal(12,4) DEFAULT 0.0000,
  `base_shipping_refunded` decimal(12,4) DEFAULT 0.0000,
  `sub_total_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_sub_total_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `shipping_amount_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_shipping_amount_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `marketplace_seller_id` int(10) unsigned NOT NULL,
  `order_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `marketplace_orders_marketplace_seller_id_order_id_unique` (`marketplace_seller_id`,`order_id`),
  KEY `marketplace_orders_order_id_foreign` (`order_id`),
  CONSTRAINT `marketplace_orders_marketplace_seller_id_foreign` FOREIGN KEY (`marketplace_seller_id`) REFERENCES `marketplace_sellers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_orders_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_orders`
--

INSERT INTO `marketplace_orders` VALUES (1,'completed',0,'pending',20.0000,80.0000,80.0000,80.0000,80.0000,320.0000,320.0000,320.0000,320.0000,1,2,400.0000,400.0000,400.0000,400.0000,0.0000,0.0000,400.0000,400.0000,400.0000,400.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,NULL,NULL,0.0000,0.0000,0.0000,0.0000,400.0000,400.0000,0.0000,0.0000,2,7,'2026-02-26 11:06:30','2026-02-26 11:14:21');

--
-- Table structure for table `marketplace_product_images`
--

CREATE TABLE `marketplace_product_images` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) DEFAULT NULL,
  `path` varchar(255) NOT NULL,
  `marketplace_product_id` int(10) unsigned NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `marketplace_product_images_marketplace_product_id_foreign` (`marketplace_product_id`),
  CONSTRAINT `marketplace_product_images_marketplace_product_id_foreign` FOREIGN KEY (`marketplace_product_id`) REFERENCES `marketplace_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_product_images`
--


--
-- Table structure for table `marketplace_product_reviews`
--

CREATE TABLE `marketplace_product_reviews` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(10) unsigned NOT NULL,
  `product_review_id` int(10) unsigned NOT NULL,
  `marketplace_seller_id` int(10) unsigned NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_product_reviews_marketplace_seller_id_foreign` (`marketplace_seller_id`),
  KEY `marketplace_product_reviews_product_review_id_foreign` (`product_review_id`),
  KEY `marketplace_product_reviews_product_id_foreign` (`product_id`),
  CONSTRAINT `marketplace_product_reviews_marketplace_seller_id_foreign` FOREIGN KEY (`marketplace_seller_id`) REFERENCES `marketplace_sellers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_product_reviews_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_product_reviews_product_review_id_foreign` FOREIGN KEY (`product_review_id`) REFERENCES `product_reviews` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_product_reviews`
--


--
-- Table structure for table `marketplace_product_videos`
--

CREATE TABLE `marketplace_product_videos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) DEFAULT NULL,
  `path` varchar(255) NOT NULL,
  `marketplace_product_id` int(10) unsigned NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `marketplace_product_videos_marketplace_product_id_foreign` (`marketplace_product_id`),
  CONSTRAINT `marketplace_product_videos_marketplace_product_id_foreign` FOREIGN KEY (`marketplace_product_id`) REFERENCES `marketplace_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_product_videos`
--


--
-- Table structure for table `marketplace_products`
--

CREATE TABLE `marketplace_products` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `condition` varchar(255) DEFAULT NULL,
  `price` double NOT NULL DEFAULT 0,
  `description` text DEFAULT NULL,
  `is_approved` tinyint(1) DEFAULT NULL,
  `is_owner` tinyint(1) NOT NULL DEFAULT 0,
  `parent_id` int(10) unsigned DEFAULT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `marketplace_seller_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `marketplace_products_marketplace_seller_id_product_id_unique` (`marketplace_seller_id`,`product_id`),
  KEY `marketplace_products_product_id_foreign` (`product_id`),
  KEY `marketplace_products_parent_id_foreign` (`parent_id`),
  CONSTRAINT `marketplace_products_marketplace_seller_id_foreign` FOREIGN KEY (`marketplace_seller_id`) REFERENCES `marketplace_sellers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_products_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `marketplace_products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_products`
--

INSERT INTO `marketplace_products` VALUES (1,NULL,100,'<p>desc</p>',1,1,NULL,2,2,'2026-02-25 21:42:36','2026-02-25 21:55:11');

--
-- Table structure for table `marketplace_refund_items`
--

CREATE TABLE `marketplace_refund_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `marketplace_refund_id` int(10) unsigned NOT NULL,
  `refund_item_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_refund_items_marketplace_refund_id_foreign` (`marketplace_refund_id`),
  KEY `marketplace_refund_items_refund_item_id_foreign` (`refund_item_id`),
  CONSTRAINT `marketplace_refund_items_marketplace_refund_id_foreign` FOREIGN KEY (`marketplace_refund_id`) REFERENCES `marketplace_refunds` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_refund_items_refund_item_id_foreign` FOREIGN KEY (`refund_item_id`) REFERENCES `refund_items` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_refund_items`
--


--
-- Table structure for table `marketplace_refunds`
--

CREATE TABLE `marketplace_refunds` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `increment_id` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `email_sent` tinyint(1) NOT NULL DEFAULT 0,
  `total_qty` int(11) DEFAULT NULL,
  `adjustment_refund` decimal(12,4) DEFAULT 0.0000,
  `base_adjustment_refund` decimal(12,4) DEFAULT 0.0000,
  `adjustment_fee` decimal(12,4) DEFAULT 0.0000,
  `base_adjustment_fee` decimal(12,4) DEFAULT 0.0000,
  `sub_total` decimal(12,4) DEFAULT 0.0000,
  `base_sub_total` decimal(12,4) DEFAULT 0.0000,
  `grand_total` decimal(12,4) DEFAULT 0.0000,
  `base_grand_total` decimal(12,4) DEFAULT 0.0000,
  `shipping_amount` decimal(12,4) DEFAULT 0.0000,
  `base_shipping_amount` decimal(12,4) DEFAULT 0.0000,
  `tax_amount` decimal(12,4) DEFAULT 0.0000,
  `base_tax_amount` decimal(12,4) DEFAULT 0.0000,
  `discount_percent` decimal(12,4) DEFAULT 0.0000,
  `discount_amount` decimal(12,4) DEFAULT 0.0000,
  `base_discount_amount` decimal(12,4) DEFAULT 0.0000,
  `sub_total_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_sub_total_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `shipping_amount_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `base_shipping_amount_incl_tax` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `refund_id` int(10) unsigned DEFAULT NULL,
  `marketplace_order_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_refunds_refund_id_foreign` (`refund_id`),
  KEY `marketplace_refunds_marketplace_order_id_foreign` (`marketplace_order_id`),
  CONSTRAINT `marketplace_refunds_marketplace_order_id_foreign` FOREIGN KEY (`marketplace_order_id`) REFERENCES `marketplace_orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_refunds_refund_id_foreign` FOREIGN KEY (`refund_id`) REFERENCES `refunds` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_refunds`
--


--
-- Table structure for table `marketplace_roles`
--

CREATE TABLE `marketplace_roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `permission_type` varchar(255) NOT NULL,
  `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`permissions`)),
  `marketplace_seller_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_roles_marketplace_seller_id_foreign` (`marketplace_seller_id`),
  CONSTRAINT `marketplace_roles_marketplace_seller_id_foreign` FOREIGN KEY (`marketplace_seller_id`) REFERENCES `marketplace_sellers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_roles`
--


--
-- Table structure for table `marketplace_seller_flat`
--

CREATE TABLE `marketplace_seller_flat` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `marketplace_seller_id` int(10) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `business_name` varchar(255) DEFAULT NULL,
  `business_description` longtext DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` longtext DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `return_policy` longtext DEFAULT NULL,
  `shipping_policy` longtext DEFAULT NULL,
  `privacy_policy` longtext DEFAULT NULL,
  `commission_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `commission_percentage` decimal(12,4) DEFAULT NULL,
  `min_order_amount` decimal(12,4) DEFAULT NULL,
  `google_analytics_id` varchar(255) DEFAULT NULL,
  `allowed_product_types` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`allowed_product_types`)),
  `facebook` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `youtube` varchar(255) DEFAULT NULL,
  `locale` varchar(255) DEFAULT NULL,
  `channel` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `marketplace_seller_local_channel_flat_unique` (`marketplace_seller_id`,`locale`,`channel`),
  CONSTRAINT `marketplace_seller_flat_marketplace_seller_id_foreign` FOREIGN KEY (`marketplace_seller_id`) REFERENCES `marketplace_sellers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_seller_flat`
--

INSERT INTO `marketplace_seller_flat` VALUES (1,1,NULL,'Admin@gmail.com','LM',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pt-BR','default','2026-02-13 11:00:08','2026-02-13 11:00:08'),(2,1,'Lourenço Macilau','Admin@gmail.com','LM','LM_development & technology','<p>Empresa focada em tecnologia</p>','','','','258845408577','sao Damasso','Pago','Maputo','MZ','1114','','','',0,NULL,NULL,'',NULL,'','','','en','default','2026-02-13 11:00:08','2026-02-16 22:32:12'),(3,1,NULL,'Admin@gmail.com','LM',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'es','default','2026-02-13 11:00:08','2026-02-13 11:00:08'),(4,2,NULL,'seller2@example.com','seller2',NULL,NULL,NULL,NULL,NULL,'845408577',NULL,NULL,NULL,NULL,'1114',NULL,NULL,NULL,0,NULL,NULL,'','\"1,2,3,4,5,6,7\"','','','','en','default','2026-02-25 21:33:11','2026-02-25 21:41:39'),(5,2,'Seller','seller2@example.com','seller2','seller2','<p>Desc</p>','Seller2','','Seller','845408577','sao Damasso\r\nFerreira Loja','RenovacionOrient','Maputo','MZ','1114','<p>descde</p>','<p>desc</p>','<p>desc</p>',0,NULL,NULL,'','\"1,2,3,4,5,6,7\"','','','','pt_BR','default','2026-02-25 21:33:11','2026-02-25 21:41:39'),(6,3,NULL,'muhmachado90@gmail.com','PMD',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'\"1,2,3,4,5,6,7\"',NULL,NULL,NULL,'en','default','2026-03-12 16:05:08','2026-03-12 16:30:25'),(7,3,'Muhammad Machado','muhmachado90@gmail.com','PMD','Plus4u Marketing and Design',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'\"1,2,3,4,5,6,7\"',NULL,NULL,NULL,'pt_BR','default','2026-03-12 16:05:08','2026-03-12 16:30:25');

--
-- Table structure for table `marketplace_seller_reviews`
--

CREATE TABLE `marketplace_seller_reviews` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rating` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `comment` text DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `marketplace_seller_id` int(10) unsigned NOT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_seller_reviews_marketplace_seller_id_foreign` (`marketplace_seller_id`),
  KEY `marketplace_seller_reviews_customer_id_foreign` (`customer_id`),
  CONSTRAINT `marketplace_seller_reviews_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_seller_reviews_marketplace_seller_id_foreign` FOREIGN KEY (`marketplace_seller_id`) REFERENCES `marketplace_sellers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_seller_reviews`
--


--
-- Table structure for table `marketplace_shipment_items`
--

CREATE TABLE `marketplace_shipment_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `marketplace_shipment_id` int(10) unsigned NOT NULL,
  `shipment_item_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_shipment_items_marketplace_shipment_id_foreign` (`marketplace_shipment_id`),
  KEY `marketplace_shipment_items_shipment_item_id_foreign` (`shipment_item_id`),
  CONSTRAINT `marketplace_shipment_items_marketplace_shipment_id_foreign` FOREIGN KEY (`marketplace_shipment_id`) REFERENCES `marketplace_shipments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_shipment_items_shipment_item_id_foreign` FOREIGN KEY (`shipment_item_id`) REFERENCES `shipment_items` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_shipment_items`
--


--
-- Table structure for table `marketplace_shipments`
--

CREATE TABLE `marketplace_shipments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `total_qty` int(11) DEFAULT NULL,
  `shipment_id` int(10) unsigned NOT NULL,
  `marketplace_order_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marketplace_shipments_shipment_id_foreign` (`shipment_id`),
  KEY `marketplace_shipments_marketplace_order_id_foreign` (`marketplace_order_id`),
  CONSTRAINT `marketplace_shipments_marketplace_order_id_foreign` FOREIGN KEY (`marketplace_order_id`) REFERENCES `marketplace_orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_shipments_shipment_id_foreign` FOREIGN KEY (`shipment_id`) REFERENCES `shipments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_shipments`
--


--
-- Table structure for table `marketplace_transactions`
--

CREATE TABLE `marketplace_transactions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) DEFAULT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `method` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `base_total` decimal(12,4) DEFAULT 0.0000,
  `marketplace_seller_id` int(10) unsigned NOT NULL,
  `marketplace_order_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `marketplace_transactions_transaction_id_unique` (`transaction_id`),
  KEY `marketplace_transactions_marketplace_seller_id_foreign` (`marketplace_seller_id`),
  KEY `marketplace_transactions_marketplace_order_id_foreign` (`marketplace_order_id`),
  CONSTRAINT `marketplace_transactions_marketplace_order_id_foreign` FOREIGN KEY (`marketplace_order_id`) REFERENCES `marketplace_orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `marketplace_transactions_marketplace_seller_id_foreign` FOREIGN KEY (`marketplace_seller_id`) REFERENCES `marketplace_sellers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_transactions`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=229 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_admin_password_resets_table',1),(3,'2014_10_12_100000_create_password_resets_table',1),(4,'2018_06_12_111907_create_admins_table',1),(5,'2018_06_13_055341_create_roles_table',1),(6,'2018_07_05_130148_create_attributes_table',1),(7,'2018_07_05_132854_create_attribute_translations_table',1),(8,'2018_07_05_135150_create_attribute_families_table',1),(9,'2018_07_05_135152_create_attribute_groups_table',1),(10,'2018_07_05_140832_create_attribute_options_table',1),(11,'2018_07_05_140856_create_attribute_option_translations_table',1),(12,'2018_07_05_142820_create_categories_table',1),(13,'2018_07_10_055143_create_locales_table',1),(14,'2018_07_20_054426_create_countries_table',1),(15,'2018_07_20_054502_create_currencies_table',1),(16,'2018_07_20_054542_create_currency_exchange_rates_table',1),(17,'2018_07_20_064849_create_channels_table',1),(18,'2018_07_21_142836_create_category_translations_table',1),(19,'2018_07_23_110040_create_inventory_sources_table',1),(20,'2018_07_24_082635_create_customer_groups_table',1),(21,'2018_07_24_082930_create_customers_table',1),(22,'2018_07_27_065727_create_products_table',1),(23,'2018_07_27_070011_create_product_attribute_values_table',1),(24,'2018_07_27_092623_create_product_reviews_table',1),(25,'2018_07_27_113941_create_product_images_table',1),(26,'2018_07_27_113956_create_product_inventories_table',1),(27,'2018_08_30_064755_create_tax_categories_table',1),(28,'2018_08_30_065042_create_tax_rates_table',1),(29,'2018_08_30_065840_create_tax_mappings_table',1),(30,'2018_09_05_150444_create_cart_table',1),(31,'2018_09_05_150915_create_cart_items_table',1),(32,'2018_09_11_064045_customer_password_resets',1),(33,'2018_09_19_093453_create_cart_payment',1),(34,'2018_09_19_093508_create_cart_shipping_rates_table',1),(35,'2018_09_20_060658_create_core_config_table',1),(36,'2018_09_27_113154_create_orders_table',1),(37,'2018_09_27_113207_create_order_items_table',1),(38,'2018_09_27_115022_create_shipments_table',1),(39,'2018_09_27_115029_create_shipment_items_table',1),(40,'2018_09_27_115135_create_invoices_table',1),(41,'2018_09_27_115144_create_invoice_items_table',1),(42,'2018_10_01_095504_create_order_payment_table',1),(43,'2018_10_03_025230_create_wishlist_table',1),(44,'2018_10_12_101803_create_country_translations_table',1),(45,'2018_10_12_101913_create_country_states_table',1),(46,'2018_10_12_101923_create_country_state_translations_table',1),(47,'2018_11_16_173504_create_subscribers_list_table',1),(48,'2018_11_21_144411_create_cart_item_inventories_table',1),(49,'2018_12_06_185202_create_product_flat_table',1),(50,'2018_12_07_164618_create_marketplace_sellers_table',1),(51,'2018_12_19_103208_create_marketplace_products_table',1),(52,'2018_12_19_130903_create_marketplace_seller_reviews_table',1),(53,'2018_12_24_123812_create_channel_inventory_sources_table',1),(54,'2018_12_26_165327_create_product_ordered_inventories_table',1),(55,'2018_12_31_152453_create_marketplace_product_images_table',1),(56,'2019_01_07_180846_create_marketplace_orders_table',1),(57,'2019_01_07_185328_create_marketplace_order_items_table',1),(58,'2019_01_11_163303_create_marketplace_shipments_table',1),(59,'2019_01_11_163341_create_marketplace_shipment_items_table',1),(60,'2019_01_11_182037_create_marketplace_invoices_table',1),(61,'2019_01_11_182104_create_marketplace_invoice_items_table',1),(62,'2019_01_16_130617_create_marketplace_transactions_table',1),(63,'2019_05_13_024321_create_cart_rules_table',1),(64,'2019_05_13_024322_create_cart_rule_channels_table',1),(65,'2019_05_13_024323_create_cart_rule_customer_groups_table',1),(66,'2019_05_13_024324_create_cart_rule_translations_table',1),(67,'2019_05_13_024325_create_cart_rule_customers_table',1),(68,'2019_05_13_024326_create_cart_rule_coupons_table',1),(69,'2019_05_13_024327_create_cart_rule_coupon_usage_table',1),(70,'2019_05_24_184029_rename_discount_invoiced_columns_in_marketplace_orders_table',1),(71,'2019_06_17_180258_create_product_downloadable_samples_table',1),(72,'2019_06_17_180314_create_product_downloadable_sample_translations_table',1),(73,'2019_06_17_180325_create_product_downloadable_links_table',1),(74,'2019_06_17_180346_create_product_downloadable_link_translations_table',1),(75,'2019_06_21_202249_create_downloadable_link_purchased_table',1),(76,'2019_07_02_180307_create_booking_products_table',1),(77,'2019_07_05_154415_create_booking_product_default_slots_table',1),(78,'2019_07_05_154429_create_booking_product_appointment_slots_table',1),(79,'2019_07_05_154440_create_booking_product_event_tickets_table',1),(80,'2019_07_05_154451_create_booking_product_rental_slots_table',1),(81,'2019_07_05_154502_create_booking_product_table_slots_table',1),(82,'2019_07_30_153530_create_cms_pages_table',1),(83,'2019_07_31_143339_create_category_filterable_attributes_table',1),(84,'2019_08_02_105320_create_product_grouped_products_table',1),(85,'2019_08_20_170510_create_product_bundle_options_table',1),(86,'2019_08_20_170520_create_product_bundle_option_translations_table',1),(87,'2019_08_20_170528_create_product_bundle_option_products_table',1),(88,'2019_09_11_184511_create_refunds_table',1),(89,'2019_09_11_184519_create_refund_items_table',1),(90,'2019_10_24_105250_create_marketplace_refunds_table',1),(91,'2019_10_24_105315_create_marketplace_refund_items_table',1),(92,'2019_12_03_184613_create_catalog_rules_table',1),(93,'2019_12_03_184651_create_catalog_rule_channels_table',1),(94,'2019_12_03_184732_create_catalog_rule_customer_groups_table',1),(95,'2019_12_06_101110_create_catalog_rule_products_table',1),(96,'2019_12_06_110507_create_catalog_rule_product_prices_table',1),(97,'2019_12_14_000001_create_personal_access_tokens_table',1),(98,'2020_01_14_191854_create_cms_page_translations_table',1),(99,'2020_01_15_130209_create_cms_page_channels_table',1),(100,'2020_02_18_165639_create_bookings_table',1),(101,'2020_02_21_121201_create_booking_product_event_ticket_translations_table',1),(102,'2020_04_16_185147_add_table_addresses',1),(103,'2020_05_06_171638_create_order_comments_table',1),(104,'2020_05_21_171500_create_product_customer_group_prices_table',1),(105,'2020_06_25_162154_create_customer_social_accounts_table',1),(106,'2020_08_07_174804_create_gdpr_data_request_table',1),(107,'2020_11_19_112228_create_product_videos_table',1),(108,'2020_11_26_141455_create_marketing_templates_table',1),(109,'2020_11_26_150534_create_marketing_events_table',1),(110,'2020_11_26_150644_create_marketing_campaigns_table',1),(111,'2020_12_21_000200_create_channel_translations_table',1),(112,'2020_12_27_121950_create_jobs_table',1),(113,'2021_02_25_181228_create_marketplace_product_videos_table',1),(114,'2021_03_11_212124_create_order_transactions_table',1),(115,'2021_04_07_132010_create_product_review_images_table',1),(116,'2021_08_31_180258_create_mp_product_downloadable_samples_table',1),(117,'2021_08_31_180314_create_mp_product_downloadable_sample_translations_table',1),(118,'2021_08_31_180325_create_mp_product_downloadable_links_table',1),(119,'2021_08_31_180346_create_mp_product_downloadable_link_translations_table',1),(120,'2021_12_15_104544_notifications',1),(121,'2022_03_15_160510_create_failed_jobs_table',1),(122,'2022_04_01_094622_create_sitemaps_table',1),(123,'2022_10_03_144232_create_product_price_indices_table',1),(124,'2022_10_04_144444_create_job_batches_table',1),(125,'2022_10_08_134150_create_product_inventory_indices_table',1),(126,'2023_05_26_213105_create_wishlist_items_table',1),(127,'2023_05_26_213120_create_compare_items_table',1),(128,'2023_06_27_163529_rename_product_review_images_to_product_review_attachments',1),(129,'2023_07_06_140013_add_logo_path_column_to_locales',1),(130,'2023_07_10_184256_create_theme_customizations_table',1),(131,'2023_07_12_181722_remove_home_page_and_footer_content_column_from_channel_translations_table',1),(132,'2023_07_20_185324_add_column_column_in_attribute_groups_table',1),(133,'2023_07_25_145943_add_regex_column_in_attributes_table',1),(134,'2023_07_25_165945_drop_notes_column_from_customers_table',1),(135,'2023_07_25_171058_create_customer_notes_table',1),(136,'2023_07_31_125232_rename_image_and_category_banner_columns_from_categories_table',1),(137,'2023_08_07_162814_add_title_to_marketplace_seller_reviews_table',1),(138,'2023_09_15_170053_create_theme_customization_translations_table',1),(139,'2023_09_20_102031_add_default_value_column_in_attributes_table',1),(140,'2023_09_20_102635_add_inventories_group_in_attribute_groups_table',1),(141,'2023_09_26_155709_add_columns_to_currencies',1),(142,'2023_10_05_163612_create_visits_table',1),(143,'2023_10_12_090446_add_tax_category_id_column_in_order_items_table',1),(144,'2023_11_08_054614_add_code_column_in_attribute_groups_table',1),(145,'2023_11_08_140116_create_search_terms_table',1),(146,'2023_11_09_162805_create_url_rewrites_table',1),(147,'2023_11_17_150401_create_search_synonyms_table',1),(148,'2023_12_11_054614_add_channel_id_column_in_product_price_indices_table',1),(149,'2024_01_11_154640_create_imports_table',1),(150,'2024_01_11_154741_create_import_batches_table',1),(151,'2024_01_19_170350_add_unique_id_column_in_product_attribute_values_table',1),(152,'2024_01_19_170350_add_unique_id_column_in_product_customer_group_prices_table',1),(153,'2024_01_22_170814_add_unique_index_in_mapping_tables',1),(154,'2024_02_22_171303_seller_password_resets_table',1),(155,'2024_02_26_153000_add_columns_to_addresses_table',1),(156,'2024_03_07_193421_rename_address1_column_in_addresses_table',1),(157,'2024_03_15_135617_alter_product_images_and_videos_table',1),(158,'2024_04_16_144400_add_cart_id_column_in_cart_shipping_rates_table',1),(159,'2024_04_19_102939_add_incl_tax_columns_in_orders_table',1),(160,'2024_04_19_135405_add_incl_tax_columns_in_cart_items_table',1),(161,'2024_04_19_144641_add_incl_tax_columns_in_order_items_table',1),(162,'2024_04_23_133154_add_incl_tax_columns_in_cart_table',1),(163,'2024_04_23_150945_add_incl_tax_columns_in_cart_shipping_rates_table',1),(164,'2024_04_24_102939_add_incl_tax_columns_in_invoices_table',1),(165,'2024_04_24_102939_add_incl_tax_columns_in_refunds_table',1),(166,'2024_04_24_144641_add_incl_tax_columns_in_invoice_items_table',1),(167,'2024_04_24_144641_add_incl_tax_columns_in_refund_items_table',1),(168,'2024_04_24_144641_add_incl_tax_columns_in_shipment_items_table',1),(169,'2024_05_10_152848_create_saved_filters_table',1),(170,'2024_06_03_174128_create_product_channels_table',1),(171,'2024_06_04_130527_add_channel_id_column_in_customers_table',1),(172,'2024_06_04_134403_add_channel_id_column_in_visits_table',1),(173,'2024_06_13_184426_add_theme_column_into_theme_customizations_table',1),(174,'2024_07_17_172645_add_additional_column_to_sitemaps_table',1),(175,'2024_07_25_102939_add_incl_tax_columns_in_marketplace_invoices_table',1),(176,'2024_07_25_102939_add_incl_tax_columns_in_marketplace_orders_table',1),(177,'2024_07_25_102939_add_incl_tax_columns_in_marketplace_refunds_table',1),(178,'2024_07_25_102939_add_shipping_incl_tax_columns_in_marketplace_orders_table',1),(179,'2024_07_25_102939_add_shipping_incl_tax_columns_in_marketplace_refunds_table',1),(180,'2024_08_29_092623_create_marketplace_product_reviews_table',1),(181,'2024_09_02_145652_add_vendor_id_in_product_inventory_indices_table',1),(182,'2024_09_05_165327_add_vendor_id_in_product_ordered_inventories_table',1),(183,'2024_09_10_102939_add_shipping_incl_tax_columns_in_marketplace_invoices_table',1),(184,'2024_09_18_130624_create_marketplace_roles_table',1),(185,'2024_09_20_145652_alter_marketplace_seller_table',1),(186,'2024_10_11_135010_create_product_customizable_options_table',1),(187,'2024_10_11_135110_create_product_customizable_option_translations_table',1),(188,'2024_10_11_135228_create_product_customizable_option_prices_table',1),(189,'2024_12_03_102131_create_mp_flag_reasons_table',1),(190,'2024_12_03_102224_create_mp_flag_reason_translations_table',1),(191,'2024_12_03_164252_create_mp_seller_flags_table',1),(192,'2024_12_03_191336_create_mp_product_flags_table',1),(193,'2024_12_19_101031_create_mp_communications_table',1),(194,'2024_12_19_101053_create_mp_communication_messages_table',1),(195,'2025_01_13_124418_add_columns_to_visits_table',1),(196,'2025_02_04_151636_create_channel_seller_table',1),(197,'2025_02_05_113522_add_vendor_id_column_to_inventory_sources_table',1),(198,'2025_05_07_121250_update_total_weight_columns_in_shipments_and_weight_shipment_items_tables',1),(199,'2025_08_05_123124_create_mp_seller_attributes_table',1),(200,'2025_08_05_123149_create_mp_seller_attribute_translations_table',1),(201,'2025_08_05_123212_create_mp_seller_attribute_options_table',1),(202,'2025_08_05_123228_create_mp_seller_attribute_option_translations_table',1),(203,'2025_08_11_163653_create_mp_seller_attribute_groups_table',1),(204,'2025_08_11_163740_create_mp_seller_attribute_group_translations_table',1),(205,'2025_08_11_175523_create_mp_seller_attribute_group_mappings_table',1),(206,'2025_08_12_175302_create_mp_seller_attribute_values_table',1),(207,'2025_08_13_171856_create_marketplace_seller_flat_table',1),(208,'2025_08_29_181704_create_seller_restricted_categories_table',1),(209,'2025_09_05_000100_add_indexes_to_channels_tables',1),(210,'2025_09_05_000200_add_indexes_to_product_relation_tables',1),(211,'2025_09_05_000300_add_indexes_to_product_media_and_attributes',1),(212,'2025_09_05_000400_add_indexes_to_attributes_and_product_types',1),(213,'2025_09_05_000500_add_indexes_to_product_grouped_products_and_product_bundle_option_products',1),(214,'2025_09_05_000500_add_indexes_to_url_rewrites_and_visits',1),(215,'2025_10_03_103302_create_mp_imports_table',1),(216,'2025_10_06_140105_create_rma_table',1),(217,'2025_10_06_140827_create_rma_reasons_table',1),(218,'2025_10_06_141234_create_rma_items_table',1),(219,'2025_10_06_141512_create_rma_images_table',1),(220,'2025_10_06_141845_create_rma_messages_table',1),(221,'2025_10_06_142003_create_rma_rules_table',1),(222,'2025_10_06_142315_create_rma_statuses_table',1),(223,'2025_10_06_142734_create_rma_additional_fields_table',1),(224,'2025_10_06_143002_create_rma_custom_fields_table',1),(225,'2025_10_06_143512_create_rma_custom_field_options_table',1),(226,'2025_10_06_143809_alter_products_table',1),(227,'2026_03_07_120000_add_imali_business_account_to_customers_table',2),(228,'2026_03_07_120001_add_imali_business_account_to_marketplace_sellers_table',2);

--
-- Table structure for table `mp_communication_messages`
--

CREATE TABLE `mp_communication_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `mp_communication_id` bigint(20) unsigned NOT NULL,
  `sender_type` enum('admin','seller') NOT NULL,
  `text` text NOT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `attachment_name` varchar(255) DEFAULT NULL,
  `attachment_type` varchar(255) DEFAULT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mp_communication_messages_mp_communication_id_foreign` (`mp_communication_id`),
  CONSTRAINT `mp_communication_messages_mp_communication_id_foreign` FOREIGN KEY (`mp_communication_id`) REFERENCES `mp_communications` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_communication_messages`
--


--
-- Table structure for table `mp_communications`
--

CREATE TABLE `mp_communications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `marketplace_seller_id` int(10) unsigned NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `is_blocked` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mp_communications_marketplace_seller_id_foreign` (`marketplace_seller_id`),
  CONSTRAINT `mp_communications_marketplace_seller_id_foreign` FOREIGN KEY (`marketplace_seller_id`) REFERENCES `marketplace_sellers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_communications`
--


--
-- Table structure for table `mp_flag_reason_translations`
--

CREATE TABLE `mp_flag_reason_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `mp_flag_reason_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `name` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mp_flag_reason_translations_mp_flag_reason_id_foreign` (`mp_flag_reason_id`),
  CONSTRAINT `mp_flag_reason_translations_mp_flag_reason_id_foreign` FOREIGN KEY (`mp_flag_reason_id`) REFERENCES `mp_flag_reasons` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_flag_reason_translations`
--

INSERT INTO `mp_flag_reason_translations` VALUES (1,1,'en','Duplicate product'),(2,2,'en','Damaged product'),(3,3,'en','Poor product quality'),(4,4,'en','Over price product'),(5,5,'en','Missing product parts'),(6,6,'en','Receive wrong product'),(7,7,'en','Duplicate product sold by seller'),(8,8,'en','Damaged product sold by seller'),(9,9,'en','Poor product quality sold by seller'),(10,10,'en','Over price product sold by seller'),(11,11,'en','Wrong product sold by seller');

--
-- Table structure for table `mp_flag_reasons`
--

CREATE TABLE `mp_flag_reasons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `admin_name` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `type` enum('product','seller') DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_flag_reasons`
--

INSERT INTO `mp_flag_reasons` VALUES (1,'Duplicate product',1,'product','2026-02-16 22:18:47','2026-02-16 22:18:47'),(2,'Damaged product',1,'product','2026-02-16 22:18:47','2026-02-16 22:18:47'),(3,'Poor product quality',1,'product','2026-02-16 22:18:47','2026-02-16 22:18:47'),(4,'Over price product',1,'product','2026-02-16 22:18:47','2026-02-16 22:18:47'),(5,'Missing product parts',1,'product','2026-02-16 22:18:47','2026-02-16 22:18:47'),(6,'Receive wrong product',1,'product','2026-02-16 22:18:47','2026-02-16 22:18:47'),(7,'Duplicate product sold by seller',1,'seller','2026-02-16 22:18:47','2026-02-16 22:18:47'),(8,'Damaged product sold by seller',1,'seller','2026-02-16 22:18:47','2026-02-16 22:18:47'),(9,'Poor product quality sold by seller',1,'seller','2026-02-16 22:18:47','2026-02-16 22:18:47'),(10,'Over price product sold by seller',1,'seller','2026-02-16 22:18:47','2026-02-16 22:18:47'),(11,'Wrong product sold by seller',1,'seller','2026-02-16 22:18:47','2026-02-16 22:18:47');

--
-- Table structure for table `mp_imports`
--

CREATE TABLE `mp_imports` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `marketplace_seller_id` int(10) unsigned NOT NULL,
  `import_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mp_imports_marketplace_seller_id_foreign` (`marketplace_seller_id`),
  KEY `mp_imports_import_id_foreign` (`import_id`),
  CONSTRAINT `mp_imports_import_id_foreign` FOREIGN KEY (`import_id`) REFERENCES `imports` (`id`) ON DELETE CASCADE,
  CONSTRAINT `mp_imports_marketplace_seller_id_foreign` FOREIGN KEY (`marketplace_seller_id`) REFERENCES `marketplace_sellers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_imports`
--


--
-- Table structure for table `mp_product_downloadable_link_translations`
--

CREATE TABLE `mp_product_downloadable_link_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `locale` varchar(255) NOT NULL,
  `title` text DEFAULT NULL,
  `mp_product_downloadable_link_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mp_link_translations_link_id_foreign` (`mp_product_downloadable_link_id`),
  CONSTRAINT `mp_link_translations_link_id_foreign` FOREIGN KEY (`mp_product_downloadable_link_id`) REFERENCES `mp_product_downloadable_links` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_product_downloadable_link_translations`
--


--
-- Table structure for table `mp_product_downloadable_links`
--

CREATE TABLE `mp_product_downloadable_links` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `price` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `sample_url` varchar(255) DEFAULT NULL,
  `sample_file` varchar(255) DEFAULT NULL,
  `sample_file_name` varchar(255) DEFAULT NULL,
  `sample_type` varchar(255) DEFAULT NULL,
  `downloads` int(11) NOT NULL DEFAULT 0,
  `sort_order` int(11) DEFAULT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mp_product_downloadable_links_product_id_foreign` (`product_id`),
  CONSTRAINT `mp_product_downloadable_links_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `marketplace_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_product_downloadable_links`
--


--
-- Table structure for table `mp_product_downloadable_sample_translations`
--

CREATE TABLE `mp_product_downloadable_sample_translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `locale` varchar(255) NOT NULL,
  `title` text DEFAULT NULL,
  `mp_product_downloadable_sample_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mp_sample_translations_sample_id_foreign` (`mp_product_downloadable_sample_id`),
  CONSTRAINT `mp_sample_translations_sample_id_foreign` FOREIGN KEY (`mp_product_downloadable_sample_id`) REFERENCES `mp_product_downloadable_samples` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_product_downloadable_sample_translations`
--


--
-- Table structure for table `mp_product_downloadable_samples`
--

CREATE TABLE `mp_product_downloadable_samples` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `sort_order` int(11) DEFAULT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mp_product_downloadable_samples_product_id_foreign` (`product_id`),
  CONSTRAINT `mp_product_downloadable_samples_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `marketplace_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_product_downloadable_samples`
--


--
-- Table structure for table `mp_product_flags`
--

CREATE TABLE `mp_product_flags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `reason` text NOT NULL,
  `customer_id` int(10) unsigned DEFAULT NULL,
  `marketplace_seller_id` int(10) unsigned NOT NULL,
  `marketplace_product_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mp_product_flags_customer_id_foreign` (`customer_id`),
  KEY `mp_product_flags_marketplace_seller_id_foreign` (`marketplace_seller_id`),
  KEY `mp_product_flags_marketplace_product_id_foreign` (`marketplace_product_id`),
  CONSTRAINT `mp_product_flags_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE SET NULL,
  CONSTRAINT `mp_product_flags_marketplace_product_id_foreign` FOREIGN KEY (`marketplace_product_id`) REFERENCES `marketplace_products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `mp_product_flags_marketplace_seller_id_foreign` FOREIGN KEY (`marketplace_seller_id`) REFERENCES `marketplace_sellers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_product_flags`
--


--
-- Table structure for table `mp_seller_attribute_group_mappings`
--

CREATE TABLE `mp_seller_attribute_group_mappings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `mp_seller_attribute_id` bigint(20) unsigned NOT NULL,
  `mp_seller_attribute_group_id` bigint(20) unsigned NOT NULL,
  `position` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mp_seller_attr_id_foreign` (`mp_seller_attribute_id`),
  KEY `mp_seller_attr_group_id_foreign` (`mp_seller_attribute_group_id`),
  CONSTRAINT `mp_seller_attr_group_id_foreign` FOREIGN KEY (`mp_seller_attribute_group_id`) REFERENCES `mp_seller_attribute_groups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `mp_seller_attr_id_foreign` FOREIGN KEY (`mp_seller_attribute_id`) REFERENCES `mp_seller_attributes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_seller_attribute_group_mappings`
--

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

--
-- Table structure for table `mp_seller_attribute_group_translations`
--

CREATE TABLE `mp_seller_attribute_group_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `mp_seller_attribute_group_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `name` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mp_seller_attr_group_local_unique` (`mp_seller_attribute_group_id`,`locale`),
  CONSTRAINT `mp_seller_attribute_group_id_foreign` FOREIGN KEY (`mp_seller_attribute_group_id`) REFERENCES `mp_seller_attribute_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_seller_attribute_group_translations`
--

INSERT INTO `mp_seller_attribute_group_translations` VALUES (1,1,'en','General'),(2,2,'en','Description'),(3,3,'en','Policies'),(4,4,'en','Meta Description'),(5,5,'en','Address'),(6,6,'en','Social Links'),(7,7,'en','Settings'),(8,1,'pt_BR',''),(9,2,'pt_BR',''),(10,3,'pt_BR',''),(11,4,'pt_BR',''),(12,5,'pt_BR',''),(13,6,'pt_BR',''),(14,7,'pt_BR','');

--
-- Table structure for table `mp_seller_attribute_groups`
--

CREATE TABLE `mp_seller_attribute_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `admin_name` varchar(255) NOT NULL,
  `column` int(11) NOT NULL DEFAULT 1,
  `position` int(11) NOT NULL,
  `is_user_defined` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mp_seller_attribute_groups_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_seller_attribute_groups`
--

INSERT INTO `mp_seller_attribute_groups` VALUES (1,'general','General',1,1,0),(2,'description','Description',1,2,0),(3,'policies','Policies',1,3,0),(4,'meta_description','Meta Description',1,4,0),(5,'address','Address',2,1,0),(6,'social_links','Social Links',2,2,0),(7,'settings','Settings',2,3,0);

--
-- Table structure for table `mp_seller_attribute_option_translations`
--

CREATE TABLE `mp_seller_attribute_option_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `mp_seller_attribute_option_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `label` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mp_seller_attr_option_locale_unique` (`mp_seller_attribute_option_id`,`locale`),
  CONSTRAINT `mp_seller_attribute_option_id_foreign` FOREIGN KEY (`mp_seller_attribute_option_id`) REFERENCES `mp_seller_attribute_options` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_seller_attribute_option_translations`
--

INSERT INTO `mp_seller_attribute_option_translations` VALUES (1,1,'en','Simple'),(2,2,'en','Booking'),(3,3,'en','Configurable'),(4,4,'en','Virtual'),(5,5,'en','Grouped'),(6,6,'en','Downloadable'),(7,7,'en','Bundle');

--
-- Table structure for table `mp_seller_attribute_options`
--

CREATE TABLE `mp_seller_attribute_options` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `mp_seller_attribute_id` bigint(20) unsigned NOT NULL,
  `admin_name` varchar(255) DEFAULT NULL,
  `sort_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mp_seller_attribute_options_mp_seller_attribute_id_foreign` (`mp_seller_attribute_id`),
  CONSTRAINT `mp_seller_attribute_options_mp_seller_attribute_id_foreign` FOREIGN KEY (`mp_seller_attribute_id`) REFERENCES `mp_seller_attributes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_seller_attribute_options`
--

INSERT INTO `mp_seller_attribute_options` VALUES (1,25,'Simple',1),(2,25,'Booking',2),(3,25,'Configurable',3),(4,25,'Virtual',4),(5,25,'Grouped',5),(6,25,'Downloadable',6),(7,25,'Bundle',7);

--
-- Table structure for table `mp_seller_attribute_translations`
--

CREATE TABLE `mp_seller_attribute_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `mp_seller_attribute_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(255) NOT NULL,
  `name` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mp_seller_attr_local_unique` (`mp_seller_attribute_id`,`locale`),
  CONSTRAINT `mp_seller_attr_trans_foreign` FOREIGN KEY (`mp_seller_attribute_id`) REFERENCES `mp_seller_attributes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_seller_attribute_translations`
--

INSERT INTO `mp_seller_attribute_translations` VALUES (1,1,'en','Name'),(2,2,'en','Email'),(3,3,'en','Phone'),(4,4,'en','Slug'),(5,5,'en','Business Name'),(6,6,'en','Business Description'),(7,7,'en','Return Policy'),(8,8,'en','Shipping Policy'),(9,9,'en','Privacy Policy'),(10,10,'en','Meta Title'),(11,11,'en','Meta Keywords'),(12,12,'en','Meta Description'),(13,13,'en','Address'),(14,14,'en','City'),(15,15,'en','Country'),(16,16,'en','State'),(17,17,'en','Postcode'),(18,18,'en','Facebook'),(19,19,'en','Instagram'),(20,20,'en','YouTube'),(21,21,'en','Commission Enabled'),(22,22,'en','Commission Percentage'),(23,23,'en','Minimum Order Amount'),(24,24,'en','Google Analytics ID'),(25,25,'en','Allowed Product Types');

--
