--
-- Host: localhost    Database: master
-- ------------------------------------------------------


--
-- Table structure for table `TypeDirectoryElement`
--

CREATE TABLE `TypeDirectoryElement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `TypeDirectoryElement`
--

INSERT INTO `TypeDirectoryElement` VALUES (1,'Teléfono','icon-phone'),(2,'Email','icon-mail5');

--
-- Table structure for table `TypeSpartooComposition`
--

CREATE TABLE `TypeSpartooComposition` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `TypeSpartooComposition`
--

INSERT INTO `TypeSpartooComposition` VALUES (1,'1','Piel , cuero'),(2,'2','Cuero / Textil'),(3,'5','Textil'),(4,'6','sintética'),(5,'7','Forrado'),(6,'8','caucho'),(7,'3','Tejido natural'),(8,'4','Textil sintético'),(9,'9','crepé'),(10,'10','madera'),(11,'14','Lana'),(12,'15','Fieltro'),(13,'16','Cuero y Sintético'),(14,'17','Denim'),(15,'18','terciopelo'),(16,'19','Lentejuelas/Cequíes'),(17,'20','Piel sintética'),(18,'22','Satén'),(19,'23','Gore-TEX®'),(20,'25','Sintético y textil'),(21,'26','Gamuza/Ante'),(22,'27','Cuero '),(23,'28','Cuero bovino'),(24,'29','Cuero ovino'),(25,'30','Cuero porcino'),(26,'31','Cuero bovino'),(27,'32','Cuero serraje'),(28,'33','Piel de cabra'),(29,'34','Paja'),(30,'35','Piel de becerro'),(31,'36','Piel de cordero'),(32,'37','Piel de ante'),(33,'38','Ante'),(34,'39','Nubuck'),(35,'41','Caucho y sintéticos'),(36,'42','Textil y caucho'),(37,'43','Textil reciclado'),(38,'44','Lyocell'),(39,'45','Tencel'),(40,'46','Modal'),(41,'47','Jute'),(42,'48','Feutrine'),(43,'49','Lycra®'),(44,'50','Neopreno'),(45,'51','Polar'),(46,'52','Malla');

--
-- Table structure for table `TypeSpartooFirstComposition`
--

CREATE TABLE `TypeSpartooFirstComposition` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `TypeSpartooFirstComposition`
--

INSERT INTO `TypeSpartooFirstComposition` VALUES (1,'1','Piel , cuero'),(2,'5','Textil'),(3,'6','sintética'),(4,'7','Forrado'),(5,'8','caucho'),(6,'2','Cuero / Textil'),(7,'3','Tejido natural'),(8,'4','Textil sintético'),(9,'9','crepé'),(10,'10','madera'),(11,'11','cuerda'),(12,'12','Algodón'),(13,'14','Lana'),(14,'15','Fieltro'),(15,'16','Cuero y Sintético'),(16,'17','Denim'),(17,'18','terciopelo'),(18,'20','Piel sintética'),(19,'22','Satén'),(20,'25','Sintético y textil'),(21,'26','Gamuza/Ante'),(22,'27','Cuero '),(23,'28','Cuero bovino'),(24,'29','Cuero ovino'),(25,'30','Cuero porcino'),(26,'31','Cuero bovino'),(27,'32','Cuero serraje'),(28,'33','Piel de cabra'),(29,'34','Paja'),(30,'35','Piel de becerro'),(31,'36','Piel de cordero'),(32,'37','Piel de ante'),(33,'38','Ante'),(34,'39','Nubuck'),(35,'43','Textil reciclado'),(36,'44','Lyocell'),(37,'45','Tencel'),(38,'46','Modal'),(39,'47','Jute'),(40,'48','Feutrine'),(41,'49','Lycra®'),(42,'50','Neopreno'),(43,'51','Polar'),(44,'52','Malla');

--
-- Table structure for table `TypeSpartooVoeringComposition`
--

CREATE TABLE `TypeSpartooVoeringComposition` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `TypeSpartooVoeringComposition`
--

INSERT INTO `TypeSpartooVoeringComposition` VALUES (1,'1','Piel , cuero'),(2,'5','Textil'),(3,'6','sintética'),(4,'7','Forrado'),(5,'8','caucho'),(6,'2','Cuero / Textil'),(7,'3','Tejido natural'),(8,'4','Textil sintético'),(9,'11','cuerda'),(10,'12','Algodón'),(11,'14','Lana'),(12,'15','Fieltro'),(13,'16','Cuero y Sintético'),(14,'17','Denim'),(15,'18','terciopelo'),(16,'20','Piel sintética'),(17,'22','Satén'),(18,'23','Gore-TEX®'),(19,'25','Sintético y textil'),(20,'26','Gamuza/Ante'),(21,'27','Cuero '),(22,'28','Cuero bovino'),(23,'29','Cuero ovino'),(24,'30','Cuero porcino'),(25,'31','Cuero bovino'),(26,'32','Cuero serraje'),(27,'33','Piel de cabra'),(28,'34','Paja'),(29,'35','Piel de becerro'),(30,'36','Piel de cordero'),(31,'37','Piel de ante'),(32,'38','Ante'),(33,'39','Nubuck'),(34,'40','Sin forro'),(35,'43','Textil reciclado'),(36,'44','Lyocell'),(37,'45','Tencel'),(38,'46','Modal'),(39,'47','Jute'),(40,'48','Feutrine'),(41,'49','Lycra®'),(42,'50','Neopreno'),(43,'51','Polar'),(44,'52','Malla');

--
-- Table structure for table `TypeSpartooZoolComposition`
--

CREATE TABLE `TypeSpartooZoolComposition` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `TypeSpartooZoolComposition`
--

INSERT INTO `TypeSpartooZoolComposition` VALUES (1,'1','Piel , cuero'),(2,'5','Textil'),(3,'6','sintética'),(4,'8','caucho'),(5,'9','crepé'),(6,'10','madera'),(7,'11','cuerda'),(8,'3','Tejido natural'),(9,'4','Textil sintético'),(10,'12','Algodón'),(11,'14','Lana'),(12,'15','Fieltro'),(13,'16','Cuero y Sintético'),(14,'24','Vibram®'),(15,'26','Gamuza/Ante'),(16,'27','Cuero '),(17,'28','Cuero bovino'),(18,'29','Cuero ovino'),(19,'30','Cuero porcino'),(20,'31','Cuero bovino'),(21,'32','Cuero serraje'),(22,'33','Piel de cabra'),(23,'34','Paja'),(24,'35','Piel de becerro'),(25,'36','Piel de cordero'),(26,'37','Piel de ante'),(27,'38','Ante'),(28,'39','Nubuck'),(29,'41','Caucho y sintéticos'),(30,'42','Textil y caucho'),(31,'43','Textil reciclado'),(32,'47','Jute'),(33,'48','Feutrine');

--
-- Table structure for table `advice_notification`
--

CREATE TABLE `advice_notification` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `shop_sending_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shop_receiving_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `user_sending_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `user_receiving_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type_action_id` int DEFAULT NULL,
  `type_advice_notification_id` int NOT NULL,
  `id_action` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `date_sending` datetime DEFAULT NULL,
  `date_receiving` datetime DEFAULT NULL,
  `is_been_readed` tinyint(1) NOT NULL,
  `completion_date` datetime DEFAULT NULL,
  `description` varchar(400) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `user_to_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type_advice_notification_target_id` int DEFAULT NULL,
  `is_been_processed` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_1CF9AA401EE3E179` (`shop_sending_id`),
  KEY `IDX_1CF9AA40D572E5D3` (`shop_receiving_id`),
  KEY `IDX_1CF9AA40C3F7CAB3` (`user_sending_id`),
  KEY `IDX_1CF9AA4048DBFE43` (`user_receiving_id`),
  KEY `IDX_1CF9AA4029F4B125` (`type_action_id`),
  KEY `IDX_1CF9AA405792C602` (`type_advice_notification_id`),
  KEY `IDX_1CF9AA40D2F7B13D` (`user_to_id`),
  KEY `IDX_1CF9AA4067B8F6E3` (`type_advice_notification_target_id`),
  CONSTRAINT `FK_1CF9AA401EE3E179` FOREIGN KEY (`shop_sending_id`) REFERENCES `shop` (`id`),
  CONSTRAINT `FK_1CF9AA4029F4B125` FOREIGN KEY (`type_action_id`) REFERENCES `typeAction` (`id`),
  CONSTRAINT `FK_1CF9AA4048DBFE43` FOREIGN KEY (`user_receiving_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_1CF9AA405792C602` FOREIGN KEY (`type_advice_notification_id`) REFERENCES `typeAdviceNotification` (`id`),
  CONSTRAINT `FK_1CF9AA4067B8F6E3` FOREIGN KEY (`type_advice_notification_target_id`) REFERENCES `typeAdviceNotificationTarget` (`id`),
  CONSTRAINT `FK_1CF9AA40C3F7CAB3` FOREIGN KEY (`user_sending_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_1CF9AA40D2F7B13D` FOREIGN KEY (`user_to_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_1CF9AA40D572E5D3` FOREIGN KEY (`shop_receiving_id`) REFERENCES `shop` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `advice_notification`
--


--
-- Table structure for table `article`
--

CREATE TABLE `article` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `dealer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `brand_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `serie_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `section_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `category_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `season_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ref` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `alias` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `detail` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `pvp` decimal(8,2) DEFAULT NULL,
  `costPrice` decimal(8,2) DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `stockMin` int DEFAULT NULL,
  `description` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `barcode` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `articleModel_id` int NOT NULL,
  `articleColor_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeHeel_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeLine_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeLining_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeSole_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeInsole_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeLast_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeSkin_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeArticle_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_manual_creation` tinyint(1) NOT NULL,
  `is_available_on_website` tinyint(1) NOT NULL,
  `is_most_popular` tinyint(1) NOT NULL,
  `is_novelty` tinyint(1) NOT NULL,
  `website_description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `metatags` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_involved_in_stock_optimization` tinyint(1) NOT NULL,
  `website_visits` int DEFAULT NULL,
  `stats_available` int DEFAULT NULL,
  `stats_pending` int DEFAULT NULL,
  `stats_sold` int DEFAULT NULL,
  `stats_profitability` decimal(14,2) DEFAULT NULL,
  `stats_pvp_resume` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `stats_pc_resume` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `color_assistant_and_web` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `stockMinToReplenishment` int DEFAULT NULL,
  `subcategory_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description_label` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `locator_alias` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `locator` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `auto_increment` int DEFAULT NULL,
  `locatorAlias_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `articleColorAssistant_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_white_label` tinyint(1) NOT NULL,
  `is_available_on_amazon` tinyint(1) NOT NULL,
  `amazon_title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amazon_description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `amazon_key1` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amazon_key2` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amazon_key3` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amazon_key4` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amazon_key5` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amazonPrice` decimal(8,2) DEFAULT NULL,
  `dinamicPrice` decimal(8,2) DEFAULT NULL,
  `amazon_weight` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amazon_height` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amazon_width` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amazon_length` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fulfillment_latency` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `merchant_shipping_group_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeShoeWidth_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typePlatformHeight_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `info_discount` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pvp_website` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `recommended_browse_nodes` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `articleProperty_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `slug301seo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `slug_alternative` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_now_involved_in_stock_optimization` tinyint(1) NOT NULL,
  `external_software_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `id_plaza` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `assistant_visits` int DEFAULT NULL,
  `amazon_protected_units` int DEFAULT NULL,
  `is_available_on_amazon_prime` tinyint(1) NOT NULL,
  `amazonPrimePrice` decimal(8,2) DEFAULT NULL,
  `amazon_logistic_warehouse` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amazon_prime_protected_units` int DEFAULT NULL,
  `composition` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `articleSpartoo_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `articleTrendicoPricat_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `country_origin` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL,
  `text_binnacle` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `stats_pc_resume_no_taxes` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_lite` tinyint(1) DEFAULT NULL,
  `amazon_special_features` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `amazon_ocasion` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `amazon_pvpr` decimal(8,2) DEFAULT NULL,
  `out_of_sync` tinyint(1) NOT NULL,
  `is_size_negative` tinyint(1) NOT NULL,
  `articleStats_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_23A0E66F6D5CF64` (`info_discount`),
  UNIQUE KEY `UNIQ_23A0E668D9CBDC2` (`articleProperty_id`),
  UNIQUE KEY `UNIQ_23A0E66C08152CA` (`articleSpartoo_id`),
  UNIQUE KEY `UNIQ_23A0E6667510C5F` (`articleTrendicoPricat_id`),
  UNIQUE KEY `UNIQ_23A0E661046F31E` (`articleStats_id`),
  KEY `IDX_23A0E661999707B` (`articleModel_id`),
  KEY `IDX_23A0E661A36D829` (`articleColor_id`),
  KEY `IDX_23A0E6643592863` (`shoeHeel_id`),
  KEY `IDX_23A0E66CA0CB290` (`shoeLine_id`),
  KEY `IDX_23A0E66C875D9E9` (`shoeLining_id`),
  KEY `IDX_23A0E66F703EECA` (`shoeSole_id`),
  KEY `IDX_23A0E6688BE1047` (`shoeInsole_id`),
  KEY `IDX_23A0E66568A5334` (`shoeLast_id`),
  KEY `IDX_23A0E667373A4AD` (`shoeSkin_id`),
  KEY `IDX_23A0E66249E6EA1` (`dealer_id`),
  KEY `IDX_23A0E6644F5D008` (`brand_id`),
  KEY `IDX_23A0E66D94388BD` (`serie_id`),
  KEY `IDX_23A0E66D823E37A` (`section_id`),
  KEY `IDX_23A0E6612469DE2` (`category_id`),
  KEY `IDX_23A0E664EC001D1` (`season_id`),
  KEY `IDX_23A0E66C4936541` (`typeArticle_id`),
  KEY `IDX_23A0E66FE54D947` (`group_id`),
  KEY `IDX_23A0E665DC6FE57` (`subcategory_id`),
  KEY `IDX_23A0E6678DF20CA` (`locatorAlias_id`),
  KEY `IDX_23A0E664A90AFD8` (`articleColorAssistant_id`),
  KEY `IDX_23A0E6640F3FCF3` (`typeShoeWidth_id`),
  KEY `IDX_23A0E66BFC5B952` (`typePlatformHeight_id`),
  KEY `alias_idx` (`alias`),
  KEY `dateCreation_idx` (`date_creation`),
  CONSTRAINT `FK_23A0E661046F31E` FOREIGN KEY (`articleStats_id`) REFERENCES `articleStats` (`id`),
  CONSTRAINT `FK_23A0E6612469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
  CONSTRAINT `FK_23A0E661999707B` FOREIGN KEY (`articleModel_id`) REFERENCES `articleModel` (`id`),
  CONSTRAINT `FK_23A0E661A36D829` FOREIGN KEY (`articleColor_id`) REFERENCES `articleColor` (`id`),
  CONSTRAINT `FK_23A0E66249E6EA1` FOREIGN KEY (`dealer_id`) REFERENCES `dealer` (`id`),
  CONSTRAINT `FK_23A0E6640F3FCF3` FOREIGN KEY (`typeShoeWidth_id`) REFERENCES `typeShoeWidth` (`id`),
  CONSTRAINT `FK_23A0E6643592863` FOREIGN KEY (`shoeHeel_id`) REFERENCES `shoeHeel` (`id`),
  CONSTRAINT `FK_23A0E6644F5D008` FOREIGN KEY (`brand_id`) REFERENCES `brand` (`id`),
  CONSTRAINT `FK_23A0E664A90AFD8` FOREIGN KEY (`articleColorAssistant_id`) REFERENCES `articleColorAssistant` (`id`),
  CONSTRAINT `FK_23A0E664EC001D1` FOREIGN KEY (`season_id`) REFERENCES `season` (`id`),
  CONSTRAINT `FK_23A0E66568A5334` FOREIGN KEY (`shoeLast_id`) REFERENCES `shoeLast` (`id`),
  CONSTRAINT `FK_23A0E665DC6FE57` FOREIGN KEY (`subcategory_id`) REFERENCES `subcategory` (`id`),
  CONSTRAINT `FK_23A0E6667510C5F` FOREIGN KEY (`articleTrendicoPricat_id`) REFERENCES `articleTrendicoPricat` (`id`),
  CONSTRAINT `FK_23A0E667373A4AD` FOREIGN KEY (`shoeSkin_id`) REFERENCES `shoeSkin` (`id`),
  CONSTRAINT `FK_23A0E6678DF20CA` FOREIGN KEY (`locatorAlias_id`) REFERENCES `locatorAlias` (`id`),
  CONSTRAINT `FK_23A0E6688BE1047` FOREIGN KEY (`shoeInsole_id`) REFERENCES `shoeInsole` (`id`),
  CONSTRAINT `FK_23A0E668D9CBDC2` FOREIGN KEY (`articleProperty_id`) REFERENCES `articleProperty` (`id`),
  CONSTRAINT `FK_23A0E66BFC5B952` FOREIGN KEY (`typePlatformHeight_id`) REFERENCES `typePlatformHeight` (`id`),
  CONSTRAINT `FK_23A0E66C08152CA` FOREIGN KEY (`articleSpartoo_id`) REFERENCES `articleSpartoo` (`id`),
  CONSTRAINT `FK_23A0E66C4936541` FOREIGN KEY (`typeArticle_id`) REFERENCES `typeArticle` (`id`),
  CONSTRAINT `FK_23A0E66C875D9E9` FOREIGN KEY (`shoeLining_id`) REFERENCES `shoeLining` (`id`),
  CONSTRAINT `FK_23A0E66CA0CB290` FOREIGN KEY (`shoeLine_id`) REFERENCES `shoeLine` (`id`),
  CONSTRAINT `FK_23A0E66D823E37A` FOREIGN KEY (`section_id`) REFERENCES `section` (`id`),
  CONSTRAINT `FK_23A0E66D94388BD` FOREIGN KEY (`serie_id`) REFERENCES `serie` (`id`),
  CONSTRAINT `FK_23A0E66F6D5CF64` FOREIGN KEY (`info_discount`) REFERENCES `info` (`id`),
  CONSTRAINT `FK_23A0E66F703EECA` FOREIGN KEY (`shoeSole_id`) REFERENCES `shoeSole` (`id`),
  CONSTRAINT `FK_23A0E66FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `article`
--


--
-- Table structure for table `articleBinnacle`
--

CREATE TABLE `articleBinnacle` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `text_binnacle` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IDX_A04945607294869C` (`article_id`),
  CONSTRAINT `FK_A04945607294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleBinnacle`
--


--
-- Table structure for table `articleCategoryWebsiteSecondary`
--

CREATE TABLE `articleCategoryWebsiteSecondary` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `datecreation` datetime NOT NULL,
  `websiteConfig_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_7D35955E7294869C` (`article_id`),
  KEY `IDX_7D35955E59FD88CD` (`websiteConfig_id`),
  CONSTRAINT `FK_7D35955E59FD88CD` FOREIGN KEY (`websiteConfig_id`) REFERENCES `websiteConfig` (`id`),
  CONSTRAINT `FK_7D35955E7294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleCategoryWebsiteSecondary`
--


--
-- Table structure for table `articleCategoryWebsiteSecondary_category`
--

CREATE TABLE `articleCategoryWebsiteSecondary_category` (
  `article_category_website_secondary_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `category_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`article_category_website_secondary_id`,`category_id`),
  KEY `IDX_B89BE83A51CF7C14` (`article_category_website_secondary_id`),
  KEY `IDX_B89BE83A12469DE2` (`category_id`),
  CONSTRAINT `FK_B89BE83A12469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_B89BE83A51CF7C14` FOREIGN KEY (`article_category_website_secondary_id`) REFERENCES `articleCategoryWebsiteSecondary` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleCategoryWebsiteSecondary_category`
--


--
-- Table structure for table `articleColor`
--

CREATE TABLE `articleColor` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_4AF090F7FE54D947` (`group_id`),
  KEY `description_idx` (`description`),
  CONSTRAINT `FK_4AF090F7FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleColor`
--


--
-- Table structure for table `articleColorAssistant`
--

CREATE TABLE `articleColorAssistant` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `code` varchar(4) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_57C2F703FE54D947` (`group_id`),
  CONSTRAINT `FK_57C2F703FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleColorAssistant`
--


--
-- Table structure for table `articleDefaultPricesByTypeSize`
--

CREATE TABLE `articleDefaultPricesByTypeSize` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `costPrice` decimal(14,2) DEFAULT NULL,
  `pvp` decimal(14,2) DEFAULT NULL,
  `typeSize_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_9FC57B357294869C` (`article_id`),
  KEY `IDX_9FC57B355CD41D00` (`typeSize_id`),
  CONSTRAINT `FK_9FC57B355CD41D00` FOREIGN KEY (`typeSize_id`) REFERENCES `typeSize` (`id`),
  CONSTRAINT `FK_9FC57B357294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleDefaultPricesByTypeSize`
--


--
-- Table structure for table `articleDistroRealTime`
--

CREATE TABLE `articleDistroRealTime` (
  `id` int NOT NULL AUTO_INCREMENT,
  `eccom_inventory_sync_id_seq` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `article_alias` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `date_creation` datetime DEFAULT NULL,
  `last_date_update` datetime DEFAULT NULL,
  `stats_available` int DEFAULT NULL,
  `stats_pending` int DEFAULT NULL,
  `stats_sold` int DEFAULT NULL,
  `stats_available_json` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `stats_pending_json` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `stats_sold_json` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `is_available_on_fom` tinyint(1) NOT NULL,
  `is_available_on_atleet` tinyint(1) NOT NULL,
  `is_available_on_soktkatt` tinyint(1) NOT NULL,
  `product_reference` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `last_date_sent` datetime DEFAULT NULL,
  `last_json_sent` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleDistroRealTime`
--


--
-- Table structure for table `articleDraft`
--

CREATE TABLE `articleDraft` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `brand_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `serie_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `section_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `dealer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `pvp` decimal(8,2) DEFAULT NULL,
  `costPrice` decimal(8,2) DEFAULT NULL,
  `units_ordered` int NOT NULL,
  `discount_percentage` decimal(14,2) DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `articleModel_id` int NOT NULL,
  `articleColor_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeLast_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeHeel_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeSole_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeLining_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ref` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `category_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `articleColorAssistant_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_6ADA4E8AFE54D947` (`group_id`),
  KEY `IDX_6ADA4E8A1999707B` (`articleModel_id`),
  KEY `IDX_6ADA4E8A1A36D829` (`articleColor_id`),
  KEY `IDX_6ADA4E8A44F5D008` (`brand_id`),
  KEY `IDX_6ADA4E8AD94388BD` (`serie_id`),
  KEY `IDX_6ADA4E8AD823E37A` (`section_id`),
  KEY `IDX_6ADA4E8A249E6EA1` (`dealer_id`),
  KEY `IDX_6ADA4E8A568A5334` (`shoeLast_id`),
  KEY `IDX_6ADA4E8A43592863` (`shoeHeel_id`),
  KEY `IDX_6ADA4E8AF703EECA` (`shoeSole_id`),
  KEY `IDX_6ADA4E8AC875D9E9` (`shoeLining_id`),
  KEY `IDX_6ADA4E8A4A90AFD8` (`articleColorAssistant_id`),
  KEY `IDX_6ADA4E8A12469DE2` (`category_id`),
  CONSTRAINT `FK_6ADA4E8A12469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
  CONSTRAINT `FK_6ADA4E8A1999707B` FOREIGN KEY (`articleModel_id`) REFERENCES `articleModel` (`id`),
  CONSTRAINT `FK_6ADA4E8A1A36D829` FOREIGN KEY (`articleColor_id`) REFERENCES `articleColor` (`id`),
  CONSTRAINT `FK_6ADA4E8A249E6EA1` FOREIGN KEY (`dealer_id`) REFERENCES `dealer` (`id`),
  CONSTRAINT `FK_6ADA4E8A43592863` FOREIGN KEY (`shoeHeel_id`) REFERENCES `shoeHeel` (`id`),
  CONSTRAINT `FK_6ADA4E8A44F5D008` FOREIGN KEY (`brand_id`) REFERENCES `brand` (`id`),
  CONSTRAINT `FK_6ADA4E8A4A90AFD8` FOREIGN KEY (`articleColorAssistant_id`) REFERENCES `articleColorAssistant` (`id`),
  CONSTRAINT `FK_6ADA4E8A568A5334` FOREIGN KEY (`shoeLast_id`) REFERENCES `shoeLast` (`id`),
  CONSTRAINT `FK_6ADA4E8AC875D9E9` FOREIGN KEY (`shoeLining_id`) REFERENCES `shoeLining` (`id`),
  CONSTRAINT `FK_6ADA4E8AD823E37A` FOREIGN KEY (`section_id`) REFERENCES `section` (`id`),
  CONSTRAINT `FK_6ADA4E8AD94388BD` FOREIGN KEY (`serie_id`) REFERENCES `serie` (`id`),
  CONSTRAINT `FK_6ADA4E8AF703EECA` FOREIGN KEY (`shoeSole_id`) REFERENCES `shoeSole` (`id`),
  CONSTRAINT `FK_6ADA4E8AFE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleDraft`
--


--
-- Table structure for table `articleEAN`
--

CREATE TABLE `articleEAN` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `brand_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `serie_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `section_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `dealer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `category_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `subcategory_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `ref` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `trendicoPricatDivision` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `trendicoPricatGender` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `trendicoPricatCategory` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `trendicoPricatSubcategory` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pvp` decimal(8,2) DEFAULT NULL,
  `costPrice` decimal(8,2) DEFAULT NULL,
  `units_ordered` int NOT NULL,
  `discount_percentage` decimal(14,2) DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `articleModel_id` int NOT NULL,
  `articleColor_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeLast_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeHeel_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeSole_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoeLining_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `articleColorAssistant_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeArticle_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E5C3C746FE54D947` (`group_id`),
  KEY `IDX_E5C3C7461999707B` (`articleModel_id`),
  KEY `IDX_E5C3C7461A36D829` (`articleColor_id`),
  KEY `IDX_E5C3C74644F5D008` (`brand_id`),
  KEY `IDX_E5C3C746D94388BD` (`serie_id`),
  KEY `IDX_E5C3C746D823E37A` (`section_id`),
  KEY `IDX_E5C3C746249E6EA1` (`dealer_id`),
  KEY `IDX_E5C3C746568A5334` (`shoeLast_id`),
  KEY `IDX_E5C3C74643592863` (`shoeHeel_id`),
  KEY `IDX_E5C3C746F703EECA` (`shoeSole_id`),
  KEY `IDX_E5C3C746C875D9E9` (`shoeLining_id`),
  KEY `IDX_E5C3C74612469DE2` (`category_id`),
  KEY `IDX_E5C3C7465DC6FE57` (`subcategory_id`),
  KEY `IDX_E5C3C7464A90AFD8` (`articleColorAssistant_id`),
  KEY `IDX_E5C3C746C4936541` (`typeArticle_id`),
  CONSTRAINT `FK_E5C3C74612469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
  CONSTRAINT `FK_E5C3C7461999707B` FOREIGN KEY (`articleModel_id`) REFERENCES `articleModel` (`id`),
  CONSTRAINT `FK_E5C3C7461A36D829` FOREIGN KEY (`articleColor_id`) REFERENCES `articleColor` (`id`),
  CONSTRAINT `FK_E5C3C746249E6EA1` FOREIGN KEY (`dealer_id`) REFERENCES `dealer` (`id`),
  CONSTRAINT `FK_E5C3C74643592863` FOREIGN KEY (`shoeHeel_id`) REFERENCES `shoeHeel` (`id`),
  CONSTRAINT `FK_E5C3C74644F5D008` FOREIGN KEY (`brand_id`) REFERENCES `brand` (`id`),
  CONSTRAINT `FK_E5C3C7464A90AFD8` FOREIGN KEY (`articleColorAssistant_id`) REFERENCES `articleColorAssistant` (`id`),
  CONSTRAINT `FK_E5C3C746568A5334` FOREIGN KEY (`shoeLast_id`) REFERENCES `shoeLast` (`id`),
  CONSTRAINT `FK_E5C3C7465DC6FE57` FOREIGN KEY (`subcategory_id`) REFERENCES `subcategory` (`id`),
  CONSTRAINT `FK_E5C3C746C4936541` FOREIGN KEY (`typeArticle_id`) REFERENCES `typeArticle` (`id`),
  CONSTRAINT `FK_E5C3C746C875D9E9` FOREIGN KEY (`shoeLining_id`) REFERENCES `shoeLining` (`id`),
  CONSTRAINT `FK_E5C3C746D823E37A` FOREIGN KEY (`section_id`) REFERENCES `section` (`id`),
  CONSTRAINT `FK_E5C3C746D94388BD` FOREIGN KEY (`serie_id`) REFERENCES `serie` (`id`),
  CONSTRAINT `FK_E5C3C746F703EECA` FOREIGN KEY (`shoeSole_id`) REFERENCES `shoeSole` (`id`),
  CONSTRAINT `FK_E5C3C746FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleEAN`
--


--
-- Table structure for table `articleEANEquivalence`
--

CREATE TABLE `articleEANEquivalence` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `orders_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `datecreation` datetime NOT NULL,
  `size_clacclac` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `size_pricat` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_630CEA1BFE54D947` (`group_id`),
  KEY `IDX_630CEA1B7294869C` (`article_id`),
  KEY `IDX_630CEA1BCFFE9AD6` (`orders_id`),
  KEY `size_clacclac_idx` (`size_clacclac`),
  KEY `size_pricat_ind` (`size_pricat`),
  CONSTRAINT `FK_630CEA1B7294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`),
  CONSTRAINT `FK_630CEA1BCFFE9AD6` FOREIGN KEY (`orders_id`) REFERENCES `orders` (`id`),
  CONSTRAINT `FK_630CEA1BFE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleEANEquivalence`
--


--
-- Table structure for table `articleExtraAmazonOfferPrice`
--

CREATE TABLE `articleExtraAmazonOfferPrice` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `datecreation` datetime NOT NULL,
  `amazonPrice` decimal(8,2) DEFAULT NULL,
  `typeSize_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_F15504AFFE54D947` (`group_id`),
  KEY `IDX_F15504AF7294869C` (`article_id`),
  KEY `IDX_F15504AF5CD41D00` (`typeSize_id`),
  CONSTRAINT `FK_F15504AF5CD41D00` FOREIGN KEY (`typeSize_id`) REFERENCES `typeSize` (`id`),
  CONSTRAINT `FK_F15504AF7294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`),
  CONSTRAINT `FK_F15504AFFE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleExtraAmazonOfferPrice`
--


--
-- Table structure for table `articleExtraBarcode`
--

CREATE TABLE `articleExtraBarcode` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `datecreation` datetime NOT NULL,
  `barcode` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeSize_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `barcode_cc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_AB03E7B0FE54D947` (`group_id`),
  KEY `IDX_AB03E7B07294869C` (`article_id`),
  KEY `IDX_AB03E7B05CD41D00` (`typeSize_id`),
  KEY `barcode` (`barcode`),
  KEY `article_typesize` (`article_id`,`typeSize_id`),
  CONSTRAINT `FK_AB03E7B05CD41D00` FOREIGN KEY (`typeSize_id`) REFERENCES `typeSize` (`id`),
  CONSTRAINT `FK_AB03E7B07294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`),
  CONSTRAINT `FK_AB03E7B0FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleExtraBarcode`
--


--
-- Table structure for table `articleHistoricalOrder`
--

CREATE TABLE `articleHistoricalOrder` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `order_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `userCreation_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_9513DBBF7294869C` (`article_id`),
  KEY `IDX_9513DBBF764F1FD9` (`userCreation_id`),
  KEY `IDX_9513DBBF8D9F6D38` (`order_id`),
  CONSTRAINT `FK_9513DBBF7294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`),
  CONSTRAINT `FK_9513DBBF764F1FD9` FOREIGN KEY (`userCreation_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_9513DBBF8D9F6D38` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleHistoricalOrder`
--


--
-- Table structure for table `articleHistoricalOrderElement`
--

CREATE TABLE `articleHistoricalOrderElement` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `shop_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `units` int DEFAULT NULL,
  `costPrice` decimal(14,2) DEFAULT NULL,
  `pvp` decimal(14,2) DEFAULT NULL,
  `articleHistoricalOrder_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `typeSize_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_8DE748C44E312182` (`articleHistoricalOrder_id`),
  KEY `IDX_8DE748C44D16C4DD` (`shop_id`),
  KEY `IDX_8DE748C45CD41D00` (`typeSize_id`),
  CONSTRAINT `FK_8DE748C44D16C4DD` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`),
  CONSTRAINT `FK_8DE748C44E312182` FOREIGN KEY (`articleHistoricalOrder_id`) REFERENCES `articleHistoricalOrder` (`id`),
  CONSTRAINT `FK_8DE748C45CD41D00` FOREIGN KEY (`typeSize_id`) REFERENCES `typeSize` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleHistoricalOrderElement`
--


--
-- Table structure for table `articleImage`
--

CREATE TABLE `articleImage` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `datecreation` datetime NOT NULL,
  `filename` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sort` int DEFAULT NULL,
  `websiteConfig_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E99BDC417294869C` (`article_id`),
  KEY `IDX_E99BDC4159FD88CD` (`websiteConfig_id`),
  KEY `sort_idx` (`sort`),
  CONSTRAINT `FK_E99BDC4159FD88CD` FOREIGN KEY (`websiteConfig_id`) REFERENCES `websiteConfig` (`id`),
  CONSTRAINT `FK_E99BDC417294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleImage`
--


--
-- Table structure for table `articleMassivePrice`
--

CREATE TABLE `articleMassivePrice` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `date_creation` datetime NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `userCreation_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_81231A337294869C` (`article_id`),
  KEY `IDX_81231A33764F1FD9` (`userCreation_id`),
  CONSTRAINT `FK_81231A337294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`),
  CONSTRAINT `FK_81231A33764F1FD9` FOREIGN KEY (`userCreation_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleMassivePrice`
--


--
-- Table structure for table `articleMassivePriceElement`
--

CREATE TABLE `articleMassivePriceElement` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `stock_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `articleMassivePrice_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `pvp` decimal(14,2) DEFAULT NULL,
  `costPrice` decimal(14,2) DEFAULT NULL,
  `qty` int DEFAULT NULL,
  `stockLite_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_66BF7D1D522615D1` (`articleMassivePrice_id`),
  KEY `IDX_66BF7D1DDCD6110` (`stock_id`),
  KEY `IDX_66BF7D1D9B83F6E8` (`stockLite_id`),
  CONSTRAINT `FK_66BF7D1D522615D1` FOREIGN KEY (`articleMassivePrice_id`) REFERENCES `articleMassivePrice` (`id`),
  CONSTRAINT `FK_66BF7D1D9B83F6E8` FOREIGN KEY (`stockLite_id`) REFERENCES `stockLite` (`id`),
  CONSTRAINT `FK_66BF7D1DDCD6110` FOREIGN KEY (`stock_id`) REFERENCES `stock` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleMassivePriceElement`
--


--
-- Table structure for table `articleModel`
--

CREATE TABLE `articleModel` (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_FB33AAC7FE54D947` (`group_id`),
  KEY `description_idx` (`description`),
  CONSTRAINT `FK_FB33AAC7FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleModel`
--


--
-- Table structure for table `articlePrice`
--

CREATE TABLE `articlePrice` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `price1` double DEFAULT NULL,
  `price2` double DEFAULT NULL,
  `price3` double DEFAULT NULL,
  `price4` double DEFAULT NULL,
  `price5` double DEFAULT NULL,
  `price6` double DEFAULT NULL,
  `price7` double DEFAULT NULL,
  `price8` double DEFAULT NULL,
  `price9` double DEFAULT NULL,
  `price10` double DEFAULT NULL,
  `price11` double DEFAULT NULL,
  `price12` double DEFAULT NULL,
  `price13` double DEFAULT NULL,
  `price14` double DEFAULT NULL,
  `price15` double DEFAULT NULL,
  `price16` double DEFAULT NULL,
  `price17` double DEFAULT NULL,
  `price18` double DEFAULT NULL,
  `price19` double DEFAULT NULL,
  `price20` double DEFAULT NULL,
  `price21` double DEFAULT NULL,
  `price22` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E66EFAC77294869C` (`article_id`),
  CONSTRAINT `FK_E66EFAC77294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articlePrice`
--


--
-- Table structure for table `articleProperty`
--

CREATE TABLE `articleProperty` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `property1` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `property2` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `property3` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `property4` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `property5` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleProperty`
--


--
-- Table structure for table `articleSectionWebsiteSecondary`
--

CREATE TABLE `articleSectionWebsiteSecondary` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `datecreation` datetime NOT NULL,
  `websiteConfig_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_6D75C2B97294869C` (`article_id`),
  KEY `IDX_6D75C2B959FD88CD` (`websiteConfig_id`),
  CONSTRAINT `FK_6D75C2B959FD88CD` FOREIGN KEY (`websiteConfig_id`) REFERENCES `websiteConfig` (`id`),
  CONSTRAINT `FK_6D75C2B97294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleSectionWebsiteSecondary`
--


--
-- Table structure for table `articleSectionWebsiteSecondary_section`
--

CREATE TABLE `articleSectionWebsiteSecondary_section` (
  `article_section_website_secondary_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `section_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`article_section_website_secondary_id`,`section_id`),
  KEY `IDX_F14DF732EAD7769B` (`article_section_website_secondary_id`),
  KEY `IDX_F14DF732D823E37A` (`section_id`),
  CONSTRAINT `FK_F14DF732D823E37A` FOREIGN KEY (`section_id`) REFERENCES `section` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_F14DF732EAD7769B` FOREIGN KEY (`article_section_website_secondary_id`) REFERENCES `articleSectionWebsiteSecondary` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleSectionWebsiteSecondary_section`
--


--
-- Table structure for table `articleSpartoo`
--

CREATE TABLE `articleSpartoo` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `spartoo_description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `typeSpartooColor_id` int DEFAULT NULL,
  `typeSpartooSex_id` int DEFAULT NULL,
  `typeSpartooCategory_id` int DEFAULT NULL,
  `typeSpartooComposition_id` int DEFAULT NULL,
  `typeSpartooVoeringComposition_id` int DEFAULT NULL,
  `typeSpartooFirstComposition_id` int DEFAULT NULL,
  `typeSpartooZoolComposition_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_1E73AC517294869C` (`article_id`),
  KEY `IDX_1E73AC5138B5C431` (`typeSpartooColor_id`),
  KEY `IDX_1E73AC5114B952CF` (`typeSpartooSex_id`),
  KEY `IDX_1E73AC514BBB4EE1` (`typeSpartooCategory_id`),
  KEY `IDX_1E73AC516325886F` (`typeSpartooComposition_id`),
  KEY `IDX_1E73AC51874174F2` (`typeSpartooVoeringComposition_id`),
  KEY `IDX_1E73AC516598F826` (`typeSpartooFirstComposition_id`),
  KEY `IDX_1E73AC51EB7733E` (`typeSpartooZoolComposition_id`),
  CONSTRAINT `FK_1E73AC5114B952CF` FOREIGN KEY (`typeSpartooSex_id`) REFERENCES `typeSpartooSex` (`id`),
  CONSTRAINT `FK_1E73AC5138B5C431` FOREIGN KEY (`typeSpartooColor_id`) REFERENCES `typeSpartooColor` (`id`),
  CONSTRAINT `FK_1E73AC514BBB4EE1` FOREIGN KEY (`typeSpartooCategory_id`) REFERENCES `typeSpartooCategory` (`id`),
  CONSTRAINT `FK_1E73AC516325886F` FOREIGN KEY (`typeSpartooComposition_id`) REFERENCES `TypeSpartooComposition` (`id`),
  CONSTRAINT `FK_1E73AC516598F826` FOREIGN KEY (`typeSpartooFirstComposition_id`) REFERENCES `TypeSpartooFirstComposition` (`id`),
  CONSTRAINT `FK_1E73AC517294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`),
  CONSTRAINT `FK_1E73AC51874174F2` FOREIGN KEY (`typeSpartooVoeringComposition_id`) REFERENCES `TypeSpartooVoeringComposition` (`id`),
  CONSTRAINT `FK_1E73AC51EB7733E` FOREIGN KEY (`typeSpartooZoolComposition_id`) REFERENCES `TypeSpartooZoolComposition` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleSpartoo`
--


--
-- Table structure for table `articleStats`
--

CREATE TABLE `articleStats` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `received` int DEFAULT NULL,
  `profit` decimal(14,2) DEFAULT NULL,
  `available_qty` int DEFAULT NULL,
  `available_avg_days` decimal(14,2) DEFAULT NULL,
  `sold_qty` int DEFAULT NULL,
  `sold_avg_days` decimal(14,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_7BE1BFB47294869C` (`article_id`),
  CONSTRAINT `FK_7BE1BFB47294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleStats`
--


--
-- Table structure for table `articleTrendicoPricat`
--

CREATE TABLE `articleTrendicoPricat` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeTrendicoPricatDivision_id` int DEFAULT NULL,
  `typeTrendicoPricatGender_id` int DEFAULT NULL,
  `typeTrendicoPricatCategory_id` int DEFAULT NULL,
  `typeTrendicoPricatSubcategory_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C976CE97294869C` (`article_id`),
  KEY `IDX_C976CE972B0CDD9` (`typeTrendicoPricatDivision_id`),
  KEY `IDX_C976CE946F73B4A` (`typeTrendicoPricatGender_id`),
  KEY `IDX_C976CE92173C2B2` (`typeTrendicoPricatCategory_id`),
  KEY `IDX_C976CE95AEA556C` (`typeTrendicoPricatSubcategory_id`),
  CONSTRAINT `FK_C976CE92173C2B2` FOREIGN KEY (`typeTrendicoPricatCategory_id`) REFERENCES `typeTrendicoPricatCategory` (`id`),
  CONSTRAINT `FK_C976CE946F73B4A` FOREIGN KEY (`typeTrendicoPricatGender_id`) REFERENCES `typeTrendicoPricatGender` (`id`),
  CONSTRAINT `FK_C976CE95AEA556C` FOREIGN KEY (`typeTrendicoPricatSubcategory_id`) REFERENCES `typeTrendicoPricatSubcategory` (`id`),
  CONSTRAINT `FK_C976CE97294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`),
  CONSTRAINT `FK_C976CE972B0CDD9` FOREIGN KEY (`typeTrendicoPricatDivision_id`) REFERENCES `typeTrendicoPricatDivision` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleTrendicoPricat`
--


--
-- Table structure for table `articleWeb`
--

CREATE TABLE `articleWeb` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `is_available_on_website` tinyint(1) NOT NULL,
  `is_most_popular` tinyint(1) NOT NULL,
  `is_novelty` tinyint(1) NOT NULL,
  `description` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `website_description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `metatags` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `slug301seo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `slug_alternative` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `websiteConfig_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_39513D1D7294869C` (`article_id`),
  KEY `IDX_39513D1D59FD88CD` (`websiteConfig_id`),
  KEY `slug_idx` (`slug`),
  KEY `slug301seo_idx` (`slug301seo`),
  KEY `slug_alternative_idx` (`slug_alternative`),
  CONSTRAINT `FK_39513D1D59FD88CD` FOREIGN KEY (`websiteConfig_id`) REFERENCES `websiteConfig` (`id`),
  CONSTRAINT `FK_39513D1D7294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articleWeb`
--


--
-- Table structure for table `article_taxes`
--

CREATE TABLE `article_taxes` (
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `tax_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`article_id`,`tax_id`),
  KEY `IDX_B539D5E97294869C` (`article_id`),
  KEY `IDX_B539D5E9B2A824D8` (`tax_id`),
  CONSTRAINT `FK_B539D5E97294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_B539D5E9B2A824D8` FOREIGN KEY (`tax_id`) REFERENCES `tax` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `article_taxes`
--


--
-- Table structure for table `article_taxes_supported`
--

CREATE TABLE `article_taxes_supported` (
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `tax_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`article_id`,`tax_id`),
  KEY `IDX_C71070857294869C` (`article_id`),
  KEY `IDX_C7107085B2A824D8` (`tax_id`),
  CONSTRAINT `FK_C71070857294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_C7107085B2A824D8` FOREIGN KEY (`tax_id`) REFERENCES `tax` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `article_taxes_supported`
--


--
-- Table structure for table `articles_orders`
--

CREATE TABLE `articles_orders` (
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `orders_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`article_id`,`orders_id`),
  KEY `IDX_5F1729C37294869C` (`article_id`),
  KEY `IDX_5F1729C3CFFE9AD6` (`orders_id`),
  CONSTRAINT `FK_5F1729C37294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_5F1729C3CFFE9AD6` FOREIGN KEY (`orders_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `articles_orders`
--


--
-- Table structure for table `bagOnSale`
--

CREATE TABLE `bagOnSale` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sale_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `amount` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_7AFDAE70FE54D947` (`group_id`),
  KEY `IDX_7AFDAE70A76ED395` (`user_id`),
  KEY `IDX_7AFDAE704A7E4868` (`sale_id`),
  CONSTRAINT `FK_7AFDAE704A7E4868` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`),
  CONSTRAINT `FK_7AFDAE70A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_7AFDAE70FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `bagOnSale`
--


--
-- Table structure for table `binnacleReception`
--

CREATE TABLE `binnacleReception` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type_binnacle_action_id` int DEFAULT NULL,
  `reception_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date` datetime NOT NULL,
  `elements` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B78057D8A76ED395` (`user_id`),
  KEY `IDX_B78057D8DBAC1845` (`type_binnacle_action_id`),
  KEY `IDX_B78057D87C14DF52` (`reception_id`),
  CONSTRAINT `FK_B78057D87C14DF52` FOREIGN KEY (`reception_id`) REFERENCES `receptions` (`id`),
  CONSTRAINT `FK_B78057D8A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_B78057D8DBAC1845` FOREIGN KEY (`type_binnacle_action_id`) REFERENCES `typeBinnacleAction` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `binnacleReception`
--


--
-- Table structure for table `brand`
--

CREATE TABLE `brand` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `filename` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `website_visits` int DEFAULT NULL,
  `exclude_from_website` tinyint(1) NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `sort` int DEFAULT NULL,
  `hide_from_home_and_filters_on_website` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_1C52F958FE54D947` (`group_id`),
  KEY `slug_idx` (`slug`),
  CONSTRAINT `FK_1C52F958FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `brand`
--


--
-- Table structure for table `brandCC`
--

CREATE TABLE `brandCC` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `filename` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `brandCC`
--

INSERT INTO `brandCC` VALUES ('01021281-9f25-47a2-a973-81b6d3785ab7','24 HORAS','placeholder.png'),('02021281-9f25-47a2-a973-81b6d3785ab7','ADOC','placeholder.png'),('031281-9f25-47a2-a973-81b6d3785ab7','ALFONSO','placeholder.png'),('04021281-9f25-47a2-a973-81b6d3785ab7','ALMA EN PENA','placeholder.png'),('05021281-9f25-47a2-a973-81b6d3785ab7','ALPE','placeholder.png'),('06021281-9f25-47a2-a973-81b6d3785ab7','AMBITIUS','placeholder.png'),('07021281-9f25-47a2-a973-81b6d3785ab7','ANGEL INFANTES','placeholder.png'),('08021281-9f25-47a2-a973-81b6d3785ab7','BAERCHI','placeholder.png'),('09021281-9f25-47a2-a973-81b6d3785ab7','BARMINTON','placeholder.png'),('10021281-9f25-47a2-a973-81b6d3785ab7','BE FLY FLOW','placeholder.png'),('11021281-9f25-47a2-a973-81b6d3785ab7','BINNARI','placeholder.png'),('12021281-9f25-47a2-a973-81b6d3785ab7','BONAVENTURE','placeholder.png'),('13021281-9f25-47a2-a973-81b6d3785ab7','BRYAN','placeholder.png'),('14021281-9f25-47a2-a973-81b6d3785ab7','BULL BOXER','placeholder.png'),('15021281-9f25-47a2-a973-81b6d3785ab7','CALLAGHAN','placeholder.png'),('16021281-9f25-47a2-a973-81b6d3785ab7','CARLO PICCOLI','placeholder.png'),('17021281-9f25-47a2-a973-81b6d3785ab7','CETTI','placeholder.png'),('18021281-9f25-47a2-a973-81b6d3785ab7','COOLWAY','placeholder.png'),('19021281-9f25-47a2-a973-81b6d3785ab7','CORONEL TAPIOCA','placeholder.png'),('20021281-9f25-47a2-a973-81b6d3785ab7','DESIGUAL','placeholder.png'),('21021281-9f25-47a2-a973-81b6d3785ab7','DESTROY','placeholder.png'),('22021281-9f25-47a2-a973-81b6d3785ab7','DONATTELLI','placeholder.png'),('23021281-9f25-47a2-a973-81b6d3785ab7','DORKING','placeholder.png'),('24021281-9f25-47a2-a973-81b6d3785ab7','DUNLOP','placeholder.png'),('25021281-9f25-47a2-a973-81b6d3785ab7','DEVALVERDE','placeholder.png'),('26021281-9f25-47a2-a973-81b6d3785ab7','FLUCHOS','placeholder.png'),('27021281-9f25-47a2-a973-81b6d3785ab7','FOOT GEAR','placeholder.png'),('28021281-9f25-47a2-a973-81b6d3785ab7','FOOT PRINT','placeholder.png'),('29021281-9f25-47a2-a973-81b6d3785ab7','FUNCHAL KID','placeholder.png'),('30021281-9f25-47a2-a973-81b6d3785ab7','FUNCHAL LADY','placeholder.png'),('31021281-9f25-47a2-a973-81b6d3785ab7','FUNHOUSE','placeholder.png'),('32021281-9f25-47a2-a973-81b6d3785ab7','FUTURMODA','placeholder.png'),('33021281-9f25-47a2-a973-81b6d3785ab7','GEOX','placeholder.png'),('34021281-9f25-47a2-a973-81b6d3785ab7','GIKO','placeholder.png'),('35021281-9f25-47a2-a973-81b6d3785ab7','GIOSEPPO','placeholder.png'),('36021281-9f25-47a2-a973-81b6d3785ab7','GORILA','placeholder.png'),('37021281-9f25-47a2-a973-81b6d3785ab7','HISPANITAS','placeholder.png'),('38021281-9f25-47a2-a973-81b6d3785ab7','IMAC','placeholder.png'),('39021281-9f25-47a2-a973-81b6d3785ab7','IPANEMA','placeholder.png'),('40021281-9f25-47a2-a973-81b6d3785ab7','KANGAROOS','placeholder.png'),('41021281-9f25-47a2-a973-81b6d3785ab7','LA STRADA','placeholder.png'),('42021281-9f25-47a2-a973-81b6d3785ab7','LEVIS STRAUSS','placeholder.png'),('43021281-9f25-47a2-a973-81b6d3785ab7','LIBERTO','placeholder.png'),('44021281-9f25-47a2-a973-81b6d3785ab7','LIKE ME','placeholder.png'),('45021281-9f25-47a2-a973-81b6d3785ab7','LODI','placeholder.png'),('46021281-9f25-47a2-a973-81b6d3785ab7','LOEDS','placeholder.png'),('47021281-9f25-47a2-a973-81b6d3785ab7','LOIS','placeholder.png'),('48021281-9f25-47a2-a973-81b6d3785ab7','LUIS GONZALO','placeholder.png'),('49021281-9f25-47a2-a973-81b6d3785ab7','LUISETTI','placeholder.png'),('50021281-9f25-47a2-a973-81b6d3785ab7','MARIA JAEN','placeholder.png'),('51021281-9f25-47a2-a973-81b6d3785ab7','MARIA MARE','placeholder.png'),('52021281-9f25-47a2-a973-81b6d3785ab7','MARIAN','placeholder.png'),('53021281-9f25-47a2-a973-81b6d3785ab7','MARTINELLI','placeholder.png'),('54021281-9f25-47a2-a973-81b6d3785ab7','MODABELLA','placeholder.png'),('55021281-9f25-47a2-a973-81b6d3785ab7','MONTESINOS','placeholder.png'),('56021281-9f25-47a2-a973-81b6d3785ab7','MUSTANG','placeholder.png'),('57021281-9f25-47a2-a973-81b6d3785ab7','ON FOOT','placeholder.png'),('58021281-9f25-47a2-a973-81b6d3785ab7','PAREDES','placeholder.png'),('59021281-9f25-47a2-a973-81b6d3785ab7','PAULA URBAN','placeholder.png'),('60021281-9f25-47a2-a973-81b6d3785ab7','PENELOPE','placeholder.png'),('61021281-9f25-47a2-a973-81b6d3785ab7','PEPE JEANS','placeholder.png'),('62021281-9f25-47a2-a973-81b6d3785ab7','PIKOLINOS','placeholder.png'),('63021281-9f25-47a2-a973-81b6d3785ab7','PITILLOS','placeholder.png'),('64021281-9f25-47a2-a973-81b6d3785ab7','PORRONET','placeholder.png'),('65021281-9f25-47a2-a973-81b6d3785ab7','REFRESH','placeholder.png'),('66021281-9f25-47a2-a973-81b6d3785ab7','RIDER','placeholder.png'),('67021281-9f25-47a2-a973-81b6d3785ab7','SIXTY SEVEN','placeholder.png'),('68021281-9f25-47a2-a973-81b6d3785ab7','SKECHERS','placeholder.png'),('69021281-9f25-47a2-a973-81b6d3785ab7','SNIPE','placeholder.png'),('70021281-9f25-47a2-a973-81b6d3785ab7','STEFANO POZZO','placeholder.png'),('71021281-9f25-47a2-a973-81b6d3785ab7','STONEFLY','placeholder.png'),('72021281-9f25-47a2-a973-81b6d3785ab7','SUPERGA','placeholder.png'),('73021281-9f25-47a2-a973-81b6d3785ab7','TAMARIS','placeholder.png'),('74021281-9f25-47a2-a973-81b6d3785ab7','TAMBI','placeholder.png'),('75021281-9f25-47a2-a973-81b6d3785ab7','THEMA','placeholder.png'),('76021281-9f25-47a2-a973-81b6d3785ab7','TIMONELLI','placeholder.png'),('77021281-9f25-47a2-a973-81b6d3785ab7','TOP 3','placeholder.png'),('78021281-9f25-47a2-a973-81b6d3785ab7','TROTTERS','placeholder.png'),('79021281-9f25-47a2-a973-81b6d3785ab7','VANS OFF THE WALL','placeholder.png'),('80021281-9f25-47a2-a973-81b6d3785ab7','VEXED','placeholder.png'),('81021281-9f25-47a2-a973-81b6d3785ab7','VUL LADI','placeholder.png'),('82021281-9f25-47a2-a973-81b6d3785ab7','WONDERS','placeholder.png'),('83021281-9f25-47a2-a973-81b6d3785ab7','WRANGLER','placeholder.png'),('84021281-9f25-47a2-a973-81b6d3785ab7','XBONITA','placeholder.png'),('85021281-9f25-47a2-a973-81b6d3785ab7','XTI','placeholder.png'),('86021281-9f25-47a2-a973-81b6d3785ab7','YOKONO','placeholder.png'),('87021281-9f25-47a2-a973-81b6d3785ab7','ZEN','placeholder.png'),('99999999999999999999','No encontrado','placeholder.png');

--
-- Table structure for table `brandCompanyTrendico`
--

CREATE TABLE `brandCompanyTrendico` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `brand_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `company_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `date_creation` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_EB5C0CE544F5D008` (`brand_id`),
  KEY `IDX_EB5C0CE5979B1AD6` (`company_id`),
  CONSTRAINT `FK_EB5C0CE544F5D008` FOREIGN KEY (`brand_id`) REFERENCES `brand` (`id`),
  CONSTRAINT `FK_EB5C0CE5979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `brandCompanyTrendico`
--


--
-- Table structure for table `brand_dealers`
--

CREATE TABLE `brand_dealers` (
  `brand_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `dealer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`brand_id`,`dealer_id`),
  KEY `IDX_122CA86544F5D008` (`brand_id`),
  KEY `IDX_122CA865249E6EA1` (`dealer_id`),
  CONSTRAINT `FK_122CA865249E6EA1` FOREIGN KEY (`dealer_id`) REFERENCES `dealer` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_122CA86544F5D008` FOREIGN KEY (`brand_id`) REFERENCES `brand` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `brand_dealers`
--


--
-- Table structure for table `cashpoint`
--

CREATE TABLE `cashpoint` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `shop_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `datecreation` datetime NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `typeStatus_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D7064A52A39E082` (`typeStatus_id`),
  KEY `IDX_D7064A524D16C4DD` (`shop_id`),
  CONSTRAINT `FK_D7064A524D16C4DD` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`),
  CONSTRAINT `FK_D7064A52A39E082` FOREIGN KEY (`typeStatus_id`) REFERENCES `typeStatus` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `cashpoint`
--


--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `filename` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `website_visits` int DEFAULT NULL,
  `code` varchar(4) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `exclude_from_website` tinyint(1) NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_64C19C1FE54D947` (`group_id`),
  KEY `slug_idx` (`slug`),
  CONSTRAINT `FK_64C19C1FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `category`
--


--
-- Table structure for table `category_forwebsitesectioncategory`
--

CREATE TABLE `category_forwebsitesectioncategory` (
  `for_website_section_category_sorted_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `category_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`for_website_section_category_sorted_id`,`category_id`),
  KEY `IDX_4E51F1F2FBF4E2C7` (`for_website_section_category_sorted_id`),
  KEY `IDX_4E51F1F212469DE2` (`category_id`),
  CONSTRAINT `FK_4E51F1F212469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_4E51F1F2FBF4E2C7` FOREIGN KEY (`for_website_section_category_sorted_id`) REFERENCES `forWebsiteSectionCategorySorted` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `category_forwebsitesectioncategory`
--


--
-- Table structure for table `chatMessage`
--

CREATE TABLE `chatMessage` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `user_from_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `user_to_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_sending` datetime DEFAULT NULL,
  `date_receiving` datetime DEFAULT NULL,
  `is_been_readed_to` tinyint(1) NOT NULL,
  `message` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E7EFD94120C3C701` (`user_from_id`),
  KEY `IDX_E7EFD941D2F7B13D` (`user_to_id`),
  CONSTRAINT `FK_E7EFD94120C3C701` FOREIGN KEY (`user_from_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_E7EFD941D2F7B13D` FOREIGN KEY (`user_to_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `chatMessage`
--


--
-- Table structure for table `clipboard`
--

CREATE TABLE `clipboard` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `barcodes` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `userCreator_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_8FDBC496FE54D947` (`group_id`),
  KEY `IDX_8FDBC4966303218F` (`userCreator_id`),
  CONSTRAINT `FK_8FDBC4966303218F` FOREIGN KEY (`userCreator_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_8FDBC496FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `clipboard`
--


--
-- Table structure for table `comanyBankAccount`
--

CREATE TABLE `comanyBankAccount` (
  `id` int NOT NULL AUTO_INCREMENT,
  `company_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `accountNumber` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_3AE9BA4C979B1AD6` (`company_id`),
  CONSTRAINT `FK_3AE9BA4C979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `comanyBankAccount`
--


--
-- Table structure for table `companies_taxes`
--

CREATE TABLE `companies_taxes` (
  `company_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `tax_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`company_id`,`tax_id`),
  KEY `IDX_2107E81C979B1AD6` (`company_id`),
  KEY `IDX_2107E81CB2A824D8` (`tax_id`),
  CONSTRAINT `FK_2107E81C979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_2107E81CB2A824D8` FOREIGN KEY (`tax_id`) REFERENCES `tax` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `companies_taxes`
--


--
-- Table structure for table `correosExpress`
--

CREATE TABLE `correosExpress` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `pre_date_send` datetime DEFAULT NULL,
  `recogida_date_send` datetime DEFAULT NULL,
  `fecha_operacion` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cod_etiquetador` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `care` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `total_bultos` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `mod_dev_etiqueta` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `remitente_nombre` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `remitente_apellido1` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `remitente_nif` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `remitente_direccion` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `remitente_localidad` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `remitente_provincia` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `remitente_cp` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `remitente_telefonocontacto` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `remitente_email` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `destinatario_nombre` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `destinatario_apellido1` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `destinatario_nif` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `destinatario_direccion` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `destinatario_localidad` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `destinatario_provincia` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `destinatario_cp` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `destinatario_telefonocontacto` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `destinatario_email` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `envio_num_bulto` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `envio_referencia_cliente` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `envio_tipo_modificacion` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `envio_tipo_peso` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `envio_valor` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `envio_instrucciones_devolucion` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `envio_observaciones1` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `envio_tipo_envio` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `envio_envio_comercial` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `envio_factura_superior500` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `envio_duacon_correos` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `entrega_parcial` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cod_producto` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `referencia_expedicion` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `modalidad_entrega` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tipo_franqueo` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `recogida_num_contrato` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `recogida_detallable` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `recogida_cod_anexo` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `recogida_cod_sistema` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `recogida_ind_imprimir_etiquetas` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `recogida_ind_devolver_cod_solicitud` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pre_request` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `pre_response` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `recogida_request` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `recogida_response` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `pre_error_code` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pre_error_message` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `recogida_error_code` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `recogida_error_message` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pre_response_cod_expedicion` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pre_response_fecha_respuesta` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pre_response_resultado` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `recogida_response_cod_seguimiento` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pdf_encoded` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `webOrder_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `destinatario_pais` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_BAD461E7FE54D947` (`group_id`),
  KEY `IDX_BAD461E7E80E408D` (`webOrder_id`),
  CONSTRAINT `FK_BAD461E7E80E408D` FOREIGN KEY (`webOrder_id`) REFERENCES `webOrder` (`id`),
  CONSTRAINT `FK_BAD461E7FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `correosExpress`
--


--
-- Table structure for table `correosExpressNative`
--

CREATE TABLE `correosExpressNative` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `date_envio` datetime DEFAULT NULL,
  `date_recogida` datetime DEFAULT NULL,
  `json_request` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `json_response` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `codigo_seguimiento` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pdf_encoded` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `webOrder_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cod_producto` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `destinatario_pais` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `json_request_recogida` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `json_response_recogida` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `codigo_retorno_envio` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `mensaje_retorno_envio` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `codigo_seguimiento_cliente` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `num_recogida` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `data_recogida` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `num_recogida_correos_express` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `data_recogida_correos_express` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `codigo_retorno_recogida` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `mensaje_retorno_recogida` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `solicitante` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `num_envio` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ref` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fecha` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cod_rte` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `nom_rte` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `nif_rte` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `dir_rte` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pob_rte` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cod_pos_nac_rte` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pais_isorte` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cod_pos_int_rte` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `telef_rte` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email_rte` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cod_dest` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `nom_dest` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `nif_dest` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `dir_dest` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pob_dest` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cod_pos_nac_dest` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pais_isodest` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cod_pos_int_dest` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `telef_dest` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email_dest` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IDX_9C8384EFE54D947` (`group_id`),
  KEY `IDX_9C8384EE80E408D` (`webOrder_id`),
  CONSTRAINT `FK_9C8384EE80E408D` FOREIGN KEY (`webOrder_id`) REFERENCES `webOrder` (`id`),
  CONSTRAINT `FK_9C8384EFE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `correosExpressNative`
--


--
-- Table structure for table `couponCode_customer`
--

CREATE TABLE `couponCode_customer` (
  `coupon_code_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `customer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`coupon_code_id`,`customer_id`),
  KEY `IDX_D9588FA6C8B2BD81` (`coupon_code_id`),
  KEY `IDX_D9588FA69395C3F3` (`customer_id`),
  CONSTRAINT `FK_D9588FA69395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_D9588FA6C8B2BD81` FOREIGN KEY (`coupon_code_id`) REFERENCES `couponsCode` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `couponCode_customer`
--


--
-- Table structure for table `couponCode_shops`
--

CREATE TABLE `couponCode_shops` (
  `coupon_code_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `shop_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`coupon_code_id`,`shop_id`),
  KEY `IDX_5200EDCC8B2BD81` (`coupon_code_id`),
  KEY `IDX_5200EDC4D16C4DD` (`shop_id`),
  CONSTRAINT `FK_5200EDC4D16C4DD` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_5200EDCC8B2BD81` FOREIGN KEY (`coupon_code_id`) REFERENCES `couponsCode` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `couponCode_shops`
--


--
-- Table structure for table `coupon_customer`
--

CREATE TABLE `coupon_customer` (
  `coupon_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `customer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`coupon_id`,`customer_id`),
  KEY `IDX_98BAD03B66C5951B` (`coupon_id`),
  KEY `IDX_98BAD03B9395C3F3` (`customer_id`),
  CONSTRAINT `FK_98BAD03B66C5951B` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_98BAD03B9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `coupon_customer`
--


--
-- Table structure for table `coupon_shops`
--

CREATE TABLE `coupon_shops` (
  `coupon_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `shop_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`coupon_id`,`shop_id`),
  KEY `IDX_CD34387366C5951B` (`coupon_id`),
  KEY `IDX_CD3438734D16C4DD` (`shop_id`),
  CONSTRAINT `FK_CD3438734D16C4DD` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_CD34387366C5951B` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `coupon_shops`
--


--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `nameForLabels` varchar(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `date_start` datetime NOT NULL,
  `date_end` datetime DEFAULT NULL,
  `is_available_on_website` tinyint(1) DEFAULT NULL,
  `label_website_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `typeDiscount` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_F5641118FE54D947` (`group_id`),
  KEY `IDX_F5641118A76ED395` (`user_id`),
  KEY `IDX_F564111844FF58D0` (`typeDiscount`),
  CONSTRAINT `FK_F564111844FF58D0` FOREIGN KEY (`typeDiscount`) REFERENCES `typeDiscount` (`id`),
  CONSTRAINT `FK_F5641118A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_F5641118FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `coupons`
--


--
-- Table structure for table `couponsCode`
--

CREATE TABLE `couponsCode` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `code` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `date_start` datetime NOT NULL,
  `date_end` datetime DEFAULT NULL,
  `is_available_on_website` tinyint(1) DEFAULT NULL,
  `label_website_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `applications` int DEFAULT NULL,
  `typeDiscount` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_932881A1FE54D947` (`group_id`),
  KEY `IDX_932881A1A76ED395` (`user_id`),
  KEY `IDX_932881A144FF58D0` (`typeDiscount`),
  CONSTRAINT `FK_932881A144FF58D0` FOREIGN KEY (`typeDiscount`) REFERENCES `typeDiscount` (`id`),
  CONSTRAINT `FK_932881A1A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_932881A1FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `couponsCode`
--


--
-- Table structure for table `customDealerDiscount`
--

CREATE TABLE `customDealerDiscount` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `target_id` int DEFAULT NULL,
  `dealer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `dealerDiscounts_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C22A6F7B158E0B66` (`target_id`),
  KEY `IDX_C22A6F7B249E6EA1` (`dealer_id`),
  KEY `IDX_C22A6F7B47D66225` (`dealerDiscounts_id`),
  CONSTRAINT `FK_C22A6F7B158E0B66` FOREIGN KEY (`target_id`) REFERENCES `typeTargetDiscount` (`id`),
  CONSTRAINT `FK_C22A6F7B249E6EA1` FOREIGN KEY (`dealer_id`) REFERENCES `dealer` (`id`),
  CONSTRAINT `FK_C22A6F7B47D66225` FOREIGN KEY (`dealerDiscounts_id`) REFERENCES `typeDiscount` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `customDealerDiscount`
--


--
-- Table structure for table `custom_order_article_discount_dealer`
--

CREATE TABLE `custom_order_article_discount_dealer` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `order_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `custom_discount_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_1544F2BB8D9F6D38` (`order_id`),
  KEY `IDX_1544F2BB7294869C` (`article_id`),
  KEY `IDX_1544F2BB7A40D4D5` (`custom_discount_id`),
  CONSTRAINT `FK_1544F2BB7294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`),
  CONSTRAINT `FK_1544F2BB7A40D4D5` FOREIGN KEY (`custom_discount_id`) REFERENCES `customDealerDiscount` (`id`),
  CONSTRAINT `FK_1544F2BB8D9F6D38` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `custom_order_article_discount_dealer`
--


--
-- Table structure for table `custom_order_discount_dealer`
--

CREATE TABLE `custom_order_discount_dealer` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `order_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `custom_discount_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C6551B818D9F6D38` (`order_id`),
  KEY `IDX_C6551B817A40D4D5` (`custom_discount_id`),
  CONSTRAINT `FK_C6551B817A40D4D5` FOREIGN KEY (`custom_discount_id`) REFERENCES `customDealerDiscount` (`id`),
  CONSTRAINT `FK_C6551B818D9F6D38` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `custom_order_discount_dealer`
--


--
-- Table structure for table `customer`
--

CREATE TABLE `customer` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `company_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shop_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `datecreation` datetime NOT NULL,
  `cif` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `zip` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `telephone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `filename` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `razon_social_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `telephone_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `person_contact_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name_customer` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `surname_customer` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeProvince_id` int DEFAULT NULL,
  `typeStatus_id` int DEFAULT NULL,
  `typeCustomer_id` int DEFAULT NULL,
  `id_web` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeCustomerSource_id` int DEFAULT NULL,
  `subscription` tinyint(1) NOT NULL,
  `fidelityCard_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `dob` datetime DEFAULT NULL,
  `typeCountry_id` int DEFAULT NULL,
  `websiteConfig_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amountPiggyBank` double NOT NULL,
  `text_binnacle` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `piggyBank_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IDX_81398E091192B8C0` (`typeProvince_id`),
  KEY `IDX_81398E09A39E082` (`typeStatus_id`),
  KEY `IDX_81398E096B416A79` (`typeCustomer_id`),
  KEY `IDX_81398E09FE54D947` (`group_id`),
  KEY `IDX_81398E09979B1AD6` (`company_id`),
  KEY `IDX_81398E094D16C4DD` (`shop_id`),
  KEY `IDX_81398E09C5355E72` (`typeCustomerSource_id`),
  KEY `IDX_81398E099A5606AA` (`fidelityCard_id`),
  KEY `IDX_81398E094F28DDAD` (`typeCountry_id`),
  KEY `IDX_81398E0959FD88CD` (`websiteConfig_id`),
  KEY `IDX_81398E098F398B5A` (`piggyBank_id`),
  KEY `dateCreation_idx` (`datecreation`),
  CONSTRAINT `FK_81398E091192B8C0` FOREIGN KEY (`typeProvince_id`) REFERENCES `typeProvinces` (`id`),
  CONSTRAINT `FK_81398E094D16C4DD` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`),
  CONSTRAINT `FK_81398E094F28DDAD` FOREIGN KEY (`typeCountry_id`) REFERENCES `typeCountryGlobal` (`id`),
  CONSTRAINT `FK_81398E0959FD88CD` FOREIGN KEY (`websiteConfig_id`) REFERENCES `websiteConfig` (`id`),
  CONSTRAINT `FK_81398E096B416A79` FOREIGN KEY (`typeCustomer_id`) REFERENCES `typeCustomer` (`id`),
  CONSTRAINT `FK_81398E098F398B5A` FOREIGN KEY (`piggyBank_id`) REFERENCES `piggyBank` (`id`),
  CONSTRAINT `FK_81398E09979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`),
  CONSTRAINT `FK_81398E099A5606AA` FOREIGN KEY (`fidelityCard_id`) REFERENCES `fidelityCard` (`id`),
  CONSTRAINT `FK_81398E09A39E082` FOREIGN KEY (`typeStatus_id`) REFERENCES `typeStatus` (`id`),
  CONSTRAINT `FK_81398E09C5355E72` FOREIGN KEY (`typeCustomerSource_id`) REFERENCES `typeCustomerSource` (`id`),
  CONSTRAINT `FK_81398E09FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `customer`
--


--
-- Table structure for table `customerWholeSaler`
--

CREATE TABLE `customerWholeSaler` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `datecreation` datetime NOT NULL,
  `dob` datetime DEFAULT NULL,
  `cif` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `zip` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `telephone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `filename` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `razon_social_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `telephone_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `person_contact_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name_customer` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `surname_customer` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `subscription` tinyint(1) NOT NULL,
  `text_binnacle` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `notes` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `typeProvince_id` int DEFAULT NULL,
  `typeCountry_id` int DEFAULT NULL,
  `typeStatus_id` int DEFAULT NULL,
  `typeCustomer_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_BF191D581192B8C0` (`typeProvince_id`),
  KEY `IDX_BF191D584F28DDAD` (`typeCountry_id`),
  KEY `IDX_BF191D58A39E082` (`typeStatus_id`),
  KEY `IDX_BF191D586B416A79` (`typeCustomer_id`),
  KEY `IDX_BF191D58FE54D947` (`group_id`),
  KEY `dateCreation_idx` (`datecreation`),
  CONSTRAINT `FK_BF191D581192B8C0` FOREIGN KEY (`typeProvince_id`) REFERENCES `typeProvinces` (`id`),
  CONSTRAINT `FK_BF191D584F28DDAD` FOREIGN KEY (`typeCountry_id`) REFERENCES `typeCountryGlobal` (`id`),
  CONSTRAINT `FK_BF191D586B416A79` FOREIGN KEY (`typeCustomer_id`) REFERENCES `typeCustomer` (`id`),
  CONSTRAINT `FK_BF191D58A39E082` FOREIGN KEY (`typeStatus_id`) REFERENCES `typeStatus` (`id`),
  CONSTRAINT `FK_BF191D58FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `customerWholeSaler`
--


--
-- Table structure for table `customer_bank_transference`
--

CREATE TABLE `customer_bank_transference` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `customer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `company_bank_account_id` int DEFAULT NULL,
  `sale_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amount` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_A8F136EA9395C3F3` (`customer_id`),
  KEY `IDX_A8F136EA5D3AA371` (`company_bank_account_id`),
  KEY `IDX_A8F136EA4A7E4868` (`sale_id`),
  CONSTRAINT `FK_A8F136EA4A7E4868` FOREIGN KEY (`sale_id`) REFERENCES `sale` (`id`),
  CONSTRAINT `FK_A8F136EA5D3AA371` FOREIGN KEY (`company_bank_account_id`) REFERENCES `comanyBankAccount` (`id`),
  CONSTRAINT `FK_A8F136EA9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `customer_bank_transference`
--


--
-- Table structure for table `customer_coupon`
--

CREATE TABLE `customer_coupon` (
  `customer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `coupon_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`customer_id`,`coupon_id`),
  KEY `IDX_D57AE3539395C3F3` (`customer_id`),
  KEY `IDX_D57AE35366C5951B` (`coupon_id`),
  CONSTRAINT `FK_D57AE35366C5951B` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_D57AE3539395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `customer_coupon`
--


--
-- Table structure for table `customer_couponCode`
--

CREATE TABLE `customer_couponCode` (
  `customer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `coupon_code_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`customer_id`,`coupon_code_id`),
  KEY `IDX_8652E6349395C3F3` (`customer_id`),
  KEY `IDX_8652E634C8B2BD81` (`coupon_code_id`),
  CONSTRAINT `FK_8652E6349395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_8652E634C8B2BD81` FOREIGN KEY (`coupon_code_id`) REFERENCES `couponsCode` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `customer_couponCode`
--


--
-- Table structure for table `dealer`
--

CREATE TABLE `dealer` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `default_brand_account_id` int DEFAULT NULL,
  `default_dealer_agent_id` int DEFAULT NULL,
  `default_payment_method` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `cif` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `phone` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `address` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `city` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `zip` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `client_number` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `province` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeStatus_id` int DEFAULT NULL,
  `typeDealer_id` int DEFAULT NULL,
  `typeDealerCountry_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeDealerPayment_id` int DEFAULT NULL,
  `typeDealerCarrier_id` int DEFAULT NULL,
  `default_serie_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_intracommunity_dealer` tinyint(1) NOT NULL DEFAULT '0',
  `observations` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `current_dealer_account_id` int DEFAULT NULL,
  `current_payment_method_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `web` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fax` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_17A33902CBCD275E` (`current_dealer_account_id`),
  KEY `IDX_17A33902A39E082` (`typeStatus_id`),
  KEY `IDX_17A3390245508E9E` (`typeDealer_id`),
  KEY `IDX_17A339022B7ED1DE` (`typeDealerCountry_id`),
  KEY `IDX_17A33902D6924C15` (`typeDealerPayment_id`),
  KEY `IDX_17A33902F38E2839` (`typeDealerCarrier_id`),
  KEY `IDX_17A33902FE54D947` (`group_id`),
  KEY `IDX_17A339022E49B133` (`default_brand_account_id`),
  KEY `IDX_17A339025E6607B7` (`default_dealer_agent_id`),
  KEY `IDX_17A33902FFE9C1B4` (`default_payment_method`),
  KEY `IDX_17A33902DF07B8F3` (`default_serie_id`),
  KEY `IDX_17A33902E9108FB` (`current_payment_method_id`),
  CONSTRAINT `FK_17A339022B7ED1DE` FOREIGN KEY (`typeDealerCountry_id`) REFERENCES `typeCountry` (`id`),
  CONSTRAINT `FK_17A339022E49B133` FOREIGN KEY (`default_brand_account_id`) REFERENCES `dealerBankAccount` (`id`),
  CONSTRAINT `FK_17A3390245508E9E` FOREIGN KEY (`typeDealer_id`) REFERENCES `typeDealer` (`id`),
  CONSTRAINT `FK_17A339025E6607B7` FOREIGN KEY (`default_dealer_agent_id`) REFERENCES `dealerAgent` (`id`),
  CONSTRAINT `FK_17A33902A39E082` FOREIGN KEY (`typeStatus_id`) REFERENCES `typeStatus` (`id`),
  CONSTRAINT `FK_17A33902CBCD275E` FOREIGN KEY (`current_dealer_account_id`) REFERENCES `dealerBankAccount` (`id`),
  CONSTRAINT `FK_17A33902D6924C15` FOREIGN KEY (`typeDealerPayment_id`) REFERENCES `typeDealerPayment` (`id`),
  CONSTRAINT `FK_17A33902DF07B8F3` FOREIGN KEY (`default_serie_id`) REFERENCES `serie` (`id`),
  CONSTRAINT `FK_17A33902E9108FB` FOREIGN KEY (`current_payment_method_id`) REFERENCES `dealerPaymentMethod` (`id`),
  CONSTRAINT `FK_17A33902F38E2839` FOREIGN KEY (`typeDealerCarrier_id`) REFERENCES `typeDealerCarrier` (`id`),
  CONSTRAINT `FK_17A33902FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`),
  CONSTRAINT `FK_17A33902FFE9C1B4` FOREIGN KEY (`default_payment_method`) REFERENCES `dealerPaymentMethod` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `dealer`
--


--
-- Table structure for table `dealerAgent`
--

CREATE TABLE `dealerAgent` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dealer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `email` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `phone` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `address` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `city` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `zip` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `province` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeDealerAgent_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_CE14307D249E6EA1` (`dealer_id`),
  KEY `IDX_CE14307DED2D53B0` (`typeDealerAgent_id`),
  CONSTRAINT `FK_CE14307D249E6EA1` FOREIGN KEY (`dealer_id`) REFERENCES `dealer` (`id`),
  CONSTRAINT `FK_CE14307DED2D53B0` FOREIGN KEY (`typeDealerAgent_id`) REFERENCES `typeDealerAgent` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `dealerAgent`
--


--
-- Table structure for table `dealerBankAccount`
--

CREATE TABLE `dealerBankAccount` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dealer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `accountNumber` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_8A9CBE39249E6EA1` (`dealer_id`),
  CONSTRAINT `FK_8A9CBE39249E6EA1` FOREIGN KEY (`dealer_id`) REFERENCES `dealer` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `dealerBankAccount`
--


--
-- Table structure for table `dealerCC`
--

CREATE TABLE `dealerCC` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `cif` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `phone` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `address` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `city` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `zip` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `client_number` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `province` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `filename` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `observations` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_intracommunity_dealer` tinyint(1) NOT NULL DEFAULT '0',
  `typeDealerCountry_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_186BE33A2B7ED1DE` (`typeDealerCountry_id`),
  CONSTRAINT `FK_186BE33A2B7ED1DE` FOREIGN KEY (`typeDealerCountry_id`) REFERENCES `typeCountry` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `dealerCC`
--

INSERT INTO `dealerCC` VALUES ('001d4a75-f08c-4d38-a43e-ae61a6df02c8','GIANNI ZENNA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('006ef0e2-9c58-4b77-8a7c-e87f99661c3c','ISIDRO GONZALEZ PERANT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('008fc731-127c-4771-982d-d949dd659418','ANPA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('01b7fa3b-ff30-4f4c-a9df-bc94f1d9b75f','ARRUEBO PETRUS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('01c12257-2259-4210-8f67-caeca172e0fc','AGATHA SHOES S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('01c2c5f5-2242-4ee3-9baf-b78c6e9e6a8b','EXE SHOES, S.L.U',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('020e2965-f591-46dd-8cc9-caae6ad0e7ac','CUTILLAS CONFORT, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('025b1e3f-e6b3-4f7b-9ac4-fa931453ea7c','CALZADOS AMARPIES, SL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('028efbdf-dc9e-4924-8b3f-15238bbdefcf','VF JEANSWEAR ESPAÑA S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('02c12257-2259-4210-8f67-caeca172e0fc','AGNELLI INTERNACIONAL S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('02ce5eba-6cf2-4d42-b167-b364ad8d538a','DUENDY SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('03c12257-2259-4210-8f67-caeca172e0fc','AGUSTINA BEJIJAR S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('041e2a89-2eb8-446d-856f-8a60164a2b3b','BOMBONCHIC, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('0472b8ff-0351-4a85-a848-63aba9de3ff4','JOMA SPORT, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('04c12257-2259-4210-8f67-caeca172e0fc','ALBA ZAPATERO S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('053c4bc1-0990-4e04-bebf-ff617041b7ac','ALBION 1879, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('05c12257-2259-4210-8f67-caeca172e0fc','ALMANSA CUERO PIEL, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('0637a7bd-c36b-444e-b9cc-9af5d47865cb','CALZAMUR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('06c12257-2259-4210-8f67-caeca172e0fc','ARNAUTEX S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('07306e9a-eaef-48a8-8cb6-03aa1192654c','CAPICCIO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('07c12257-2259-4210-8f67-caeca172e0fc','AURA FUTURE S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('07cc884c-f2d4-4699-be87-0001f6595ef7','SCHUH KONZEPT, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('08370cf0-eede-41d3-974f-c816f1eff9d8','REXAC´S ARTESANOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('08c12257-2259-4210-8f67-caeca172e0fc','BAERCHI SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('0957692d-d2a0-4af6-bcf1-88cd043ceddd','DELTELL MOCASINES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('09c12257-2259-4210-8f67-caeca172e0fc','BARMINTON DISTRIBUCION, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('0a22caab-0518-41b2-abe9-84deb36f046f','POPA FOOTWEAR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('0c0f8d68-f5cb-4090-96c1-41e662095ff0','RELANCE CALCADOS, LDA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('0c7e4989-8b7d-49fc-abfb-367e324493c6','TAKE ME SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('0cad232b-48be-4852-9595-c81238157e07','DEITY SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('0da204d9-d509-42ec-961f-50a71fe3c33c','CALZADOS GAVI\'S, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('0df6b53a-4823-4071-8901-a933981c25f6','LUCK LUNA 5 ESTRELLAS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('0e18e868-4f12-4e44-b509-748b7348dcc1','MOTESA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('0e90cc9f-42cf-4c71-943b-046590b175fa','VULCA-BICHA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('0efbcbc6-a59c-4b52-b758-346cd7500943','CALZADOS ANPA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('0f26ce7d-993e-4e09-b388-c2c2eacc5306','STAY DESIGN, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('0faf767c-0b1c-47a3-9261-8810fd3063bf','DC CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('0fe256ff-354b-4e4a-8424-47f0e348ee4a','JINARVI, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('1075921d-6d8f-4de1-bb56-57e0c7c8bc3c','LEYLAND CALZADOS S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('1082d246-bfd0-49e2-b04b-f3db8cc126d4','CALZADOS SERYAL, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('10c12257-2259-4210-8f67-caeca172e0fc','BRYAN FOOTWEAR S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('118e6593-349e-45a6-b94c-98c13f61364d','CINTHYANA DISEÑO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('11c12257-2259-4210-8f67-caeca172e0fc','BUENO E HIJOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('1223a895-ab7d-4fb7-8c3e-da5fb500e25c','HILARIO MACIÁ VICENTE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('12bb5dcc-a7ff-461b-ae98-fe9e8b97e1bb','VUL-ALEX, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('12c12257-2259-4210-8f67-caeca172e0fc','C.N.P. BOLSOS 2000 S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('12e2cc76-879f-4a65-936c-a1e7f0f62d03','SELECCIONES MOLINA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('134d8b4c-243b-4b68-b3ef-00aef80c6838','CALZADOS BOSS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('13c12257-2259-4210-8f67-caeca172e0fc','CALMODA SL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('13c6062c-9b2c-40d7-82fb-4c3440352f09','GARTI SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('14c12257-2259-4210-8f67-caeca172e0fc','CALZADOS DANUBIO S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('1505beb9-d646-4ea0-a703-793dc6bb6314','TORRENS HERMANOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('1553dbc1-11e8-4f39-9beb-e3dbda51c6b1','INYERASP S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('15c12257-2259-4210-8f67-caeca172e0fc','CALZADOS DE CULTO',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('15ca4e11-ad19-41a8-8b34-18f93e2b876f','KURNICH, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('16117b98-9f0c-4616-a7e2-492cd2e6f521','MARCA BLANCA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('169bb28a-c800-437c-9280-0413e123b123','D´CALDERONI S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('16c12257-2259-4210-8f67-caeca172e0fc','CALZADOS DESERT S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('17c12257-2259-4210-8f67-caeca172e0fc','CALZADOS DONATELLI S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('1815520d-c804-4927-bdc8-8accf24ec6d9','CALZADOS DIORFI S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('18c12257-2259-4210-8f67-caeca172e0fc','CALZADOS FUTURMODA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('193d28a3-c332-4c24-b502-32391cc04507','ANSER CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('1982f534-b2b2-47d6-a89d-c7e7ec8eb93e','MARIANO GALIANA JOVER',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('19c12257-2259-4210-8f67-caeca172e0fc','CALZADOS H2O, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('19dc2681-3372-46be-b9ce-b6ce466e8f90','CALZADOS BOOGIE BOOGIE, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('1aabdd19-ec40-4f13-87e3-96113398b51c','MLS TEXTILES 1992, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('1b2932a0-fe88-4c8a-9237-e81bec4aef95','VITEANA S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('1c1ab396-71f6-48e1-8c96-994d1f5eaf63','EXCLUSIVAS YUMAS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('1c439c73-57e6-46ce-8dbc-438eba42ba82','FEEL FOUR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('1e0f44ea-9b3a-4762-b2d1-792714ffaeb4','CREACIONES PELINES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('1ff339ef-fdb1-42f1-aa66-c76d4da70c8d','MANEXCO S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('20763fd8-cf29-4a3c-ab71-7c97be978158','FUN VERBENAS S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('20c12257-2259-4210-8f67-caeca172e0fc','CALZADOS HERGAR, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('20c6e5dc-a976-40dc-a775-fd42e8627aef','CALCATS COMES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('20eb9a29-47f3-4cc8-883b-6b80da72af40','MUNBATALA COMPANY, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('21822604-6973-49a1-8b12-da26839f62dd','PASALI, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('21c12257-2259-4210-8f67-caeca172e0fc','CALZADOS JUNKER S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('22c12257-2259-4210-8f67-caeca172e0fc','CALZADOS LARO S.A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('23c12257-2259-4210-8f67-caeca172e0fc','CALZADOS MARIAN S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('24ba943d-69f5-46d7-9ec8-135732fd50a1','SUCESORES DE VICTORIAN VICENTE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('24c12257-2259-4210-8f67-caeca172e0fc','CALZADOS PENELOPE S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('25c12257-2259-4210-8f67-caeca172e0fc','CALZATURIFICIO THEMA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('25f0f0fa-e606-4936-bc98-51c06dd6b3cb','CINDICALFE COMERCIAL, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('25f9b7cf-1349-421e-8a9a-ec87828cfa38','CURTIDOS GILABERT S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('26baab70-2fbd-4ddb-8894-62099d539868','MAP SPAIN, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('26c12257-2259-4210-8f67-caeca172e0fc','CETTI LUXSPORTIVESHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('26c74bcf-1f4b-43a6-9a4d-06fcc6a84631','CORMODE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('27c12257-2259-4210-8f67-caeca172e0fc','CHILLI PEPPER SHOES COMPANY',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('27e111c8-38df-4aed-8584-3cf31e3819dc','ZAPATOS DE MED S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('285ecbe2-17d2-444b-920c-9e6e2dde641e','SANKA SHOES S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('28c12257-2259-4210-8f67-caeca172e0fc','CHLOE & LUCAS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('28c4b645-c552-496a-ac6e-5e81b3a92d17','BUBEL SHOES S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('29be5feb-8641-4464-937c-a3bb386991a0','CALZADOS SOGIGAL S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('29bf4a7a-0553-4ab3-af99-3dfd40ff7c32','CANTOS SAEZ, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('29c12257-2259-4210-8f67-caeca172e0fc','CREACIONES ALPE S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('2b5c8d08-3ebc-475c-b04b-5bc763368012','ZONA INDUSTRIAL LA FARGA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('2cb3a820-f617-4264-9b44-5f37925f8871','INYECTADOS ANTON, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('2cb8331e-7247-4df4-a7a3-48ba29f02ff7','LOIBA ESPACIO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('2cf5a135-ebb1-44c2-8666-c2beaa7e89d1','MANLISA SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('2e143cb6-35a0-4651-bd26-6ac71b645af4','TIGLIO 2000, S.R.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('2e45a584-37c4-45ed-81f9-267839fb4870','INYECTADOS LAURA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('2e993ff3-d160-4564-b433-e14835acea63','HEAD SPORT GMBH',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('2ec464f7-eaef-4220-8928-d02e1d28586b','ANYO NEW GENERATION, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('2ecb3632-1018-4a66-b2cf-ee496d28c599','GONDOLINE SPORT, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('2ff4a1f9-8136-4881-9ecc-d8a9d3a28072','CALZASOS FAL, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('30484465-5273-40c9-98c6-f576da763333','GARY GAR TOP, S. L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('30c12257-2259-4210-8f67-caeca172e0fc','CREACIONES D´GILCAR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('315802cf-7665-4528-a3fe-9017349699a4','MOVEON -  COMPONENTES E CALÇADO S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('31c12257-2259-4210-8f67-caeca172e0fc','CREACIONES MODABELLA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('31df71f9-d8c9-4fda-8411-e2be224b65f4','LEZNA 2000, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3248b23e-5479-4f79-992c-c6ead2f72110','BREAK & WALK DISTRIBUCION, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('32c12257-2259-4210-8f67-caeca172e0fc','EDEL FASHION B.V',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('33c12257-2259-4210-8f67-caeca172e0fc','ELOI & ANA, LDA.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('33ecea98-82aa-4e65-af29-9c8c3724c119','GRISPORT SPA.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3401a5df-0bee-41e1-802f-0238bc9e0cc2','INDUSTRIAS PLÁSTICAS IGOR S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3443af23-644e-4f32-887b-ab93f8db4176','ESPACIO PIEL, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('34c12257-2259-4210-8f67-caeca172e0fc','EMBOGA S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('34f65460-e558-48b6-b089-a47ba5ed2ac8','FALC S.P.A..',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('358a02ef-2157-413f-8baa-a22f487a8703','CALZADOS PESORA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('35c12257-2259-4210-8f67-caeca172e0fc','EXCURSION SHOES S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('36c12257-2259-4210-8f67-caeca172e0fc','FLUCHOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('3796da09-4913-4a1f-87f0-7393b2025f77','KARMINE MODE S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('37c12257-2259-4210-8f67-caeca172e0fc','FOOT GEAR S.L.U',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('38c12257-2259-4210-8f67-caeca172e0fc','FRANQUIZ COMERCIAL 21, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('39c12257-2259-4210-8f67-caeca172e0fc','GEOX S.A.P.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('39efbca0-c3cc-4268-981a-36c8756350c1','THE MONK EUROPE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3a96d460-b219-4659-bd79-d6b99e0f807f','INTER GESTIÓ BANYOLES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3ae299f3-49a4-4243-87be-bdce5f09cb1b','VANYOR, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3b439f43-c969-4a9f-87f5-cb76fabbc801','VIUCASAR, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3d3b1980-a00b-4f71-aaba-36af1aaf3307','YOWAS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3db1cba9-3353-4ab0-ab0c-26b3da740b7d','CALZADOS RAFI C.B.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3db5a289-d750-45b7-8c2b-3e9ec2f05761','ZAP-ZAP ZAPATOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3ddd9deb-bb32-45c7-9323-b35678194f52','ROBERT PIETRI, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3e4f5575-cbe5-40eb-a673-4b87ab1f8d36','VULCANIZADOS KOKI\'S, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3e54b022-168b-4247-83a7-128e547bcd76','AMANI BV',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3f0dd5ae-77e7-4ce5-ad1a-d8afc77bbfe9','SHOE REPUBLIC S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3f1f27fa-6913-4db1-9b62-43ef910b397c','OXFORD FOOTWEAR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3f4d68cb-ae62-429c-82a1-9a06be79fc65','ON FOOT SPAIN, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('3fa89b8f-1ceb-4b4d-8fd5-38fa86fe042a','GUX SHOES, SL.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('401e4106-04a7-4954-91eb-37ce657ba571','OXIGENO SHOES S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('40c12257-2259-4210-8f67-caeca172e0fc','GIANNI-ZENNA S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('40ffc4b7-1335-445e-9e27-55e7cfb61693','CALZADOS BARTTY, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('413047d0-7a41-4466-88ba-17bb1715544e','DRAVE MAD S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('41941a5b-1c10-435a-81f1-a91d835346a1','EUROGLORIA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('41c12257-2259-4210-8f67-caeca172e0fc','GIOSEPPO,S.L.U',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('41cb2ba2-f90b-42eb-af66-474e560dda4d','TERESA ATELIER S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('421c3481-0978-44fb-a428-fb6ab6e7e0e2','APICCAPS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('429fb931-281c-4017-9911-f3e11474cdce','CREACIONES FELU, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('42c12257-2259-4210-8f67-caeca172e0fc','CALZADOS PITILLOS, S.A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('43cff352-2a77-46e0-b366-ba785ef5e161','ABACK STYLE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('4457ab56-b7cd-4b24-95e4-5968d23176ff','MARCOS MOLL ANGLADA, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('44c12257-2259-4210-8f67-caeca172e0fc','GRUPO VULCASA S.A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('45c12257-2259-4210-8f67-caeca172e0fc','HENNA BOLSOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('45cc88f8-d66a-4785-9250-b8cf6b9a696e','MUÑOZ Y TERCERO CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('45e70778-125a-4a3b-a30e-c1c2a2578658','KAOLA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('45f74101-a7a5-4d47-968c-4ddb5ef9ff9e','PENTA SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('463b1d75-57c6-44f6-8037-dad9702c59c9','TARINEA DISTRICT, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('466207aa-4b93-4db1-9277-e2f82adb7396','VULCANIZADOS LADI, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('46c12257-2259-4210-8f67-caeca172e0fc','HERGILZA S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('46e836cc-a2c8-4e11-b047-0c866dd78828','SHEMERRY, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('4706e638-d33a-4350-9c50-8b546f9a4487','KANGAROOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('470d40ca-bd1d-4485-adf7-1d971748d7f7','CALZADOS LOYGAR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('477ff912-0a5d-462f-8687-1d9b85e01087','CREACIONES ROKISINI, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('47c12257-2259-4210-8f67-caeca172e0fc','HIJOS DE ALMACENES CORRALES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('482cdb8b-fc75-4090-86ad-2b5758afe038','OIZZE SHOES S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('483a91a6-04dd-4581-b603-405d846ae2ce','CRUPASGA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('484c3bbc-921f-4fb0-b0a9-cc0e7679215d','BIO-OPTIMUS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('48c12257-2259-4210-8f67-caeca172e0fc','IBERSHOES - SERVICIOS MARKETING L.D.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('494b62da-e4dd-482f-8685-889ad20edadb','CALZADOS DE BLAS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('49bd58bb-5fac-4083-aebb-23060361fcc3','ZACHA SPORT, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('49c12257-2259-4210-8f67-caeca172e0fc','IMAC S.P.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('4a1828b5-a634-40b1-baba-aed41c50333d','TIBAYO S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('4b64f70d-9b1b-4e4e-b89c-a407ef9f2771','D´TORRES CALZADO ORTOPEDICO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('4be9ecae-119d-422c-a19c-dd2bd77cc964','HANNIBAL LAGUNA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('4dba8235-9091-4183-a58f-a8e74ea6d368','HANDYFLEX, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('4ec306b0-88ba-433e-84e6-1100f4ce2bad','PACAL SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('4f76cc2f-e869-44a6-bc62-014dc3b10b37','CALZADOS NEW DRESS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5062e940-ea1a-4440-b811-dd0be838e581','LACOSTE S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('50c12257-2259-4210-8f67-caeca172e0fc','IMPORT DALSON, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('50e7bcc8-b59e-4b4c-a52a-f338c9cf1268','ASICS IEBERIA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('512510f9-4b8b-47f0-a4ea-ae2bb818c16a','AUGE CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('51c12257-2259-4210-8f67-caeca172e0fc','INDUSTRIA DEL CALÇADO CELITA, LDA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('521814e7-8477-4e20-be73-805715d275c4','CALZADOS TRBEDE S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5245ab04-9adc-4d3f-99b7-3fc8b584b6dc','VULCANIZADOS GARZON, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('524a7dc4-97f3-4b07-b9a1-5566335d8e09','MED FOOTWEAR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('52c12257-2259-4210-8f67-caeca172e0fc','JESUS ALFONSO S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('53c12257-2259-4210-8f67-caeca172e0fc','LEVI´S FOOTWEAR & ACCESSORIES SPAIN S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('5471c36e-400c-4c3c-aaab-0d6025d6dc04','PEDRO MIRALLES S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('54c12257-2259-4210-8f67-caeca172e0fc','MARKET SHOES S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('55afc71d-f048-45fd-9421-6b17a280ee93','JOSEF SEIBEL UK LTD',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('55c12257-2259-4210-8f67-caeca172e0fc','MASALVES CALZADOS UNIPERSONAL LDA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('55cd1c89-02a6-4893-bbbc-6a2d7951d289','PALMIPAO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('55f9787d-8e8c-421f-9c6b-6c4b147d8c2e','MAYA TROPIC, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('561887f5-7e9a-4da4-b3e6-53b66f91aeac','INDUARTE S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('56844e1f-3d9c-49ae-a9de-f2d58ef5c057','PEMIR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('56c12257-2259-4210-8f67-caeca172e0fc','MTNG EUROPE EXPERIENCE, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('5706a2ea-9166-48a0-a9f9-70dcbef69206','SPORT 2002, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('57c12257-2259-4210-8f67-caeca172e0fc','NEW MOC, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('585c356a-051d-4480-b6c1-18847d27249a','SANDALO STUDIO 2017, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('588fae9e-5acf-4b13-8542-09fd4aa0fdda','BRASILIEN TCC SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('58c12257-2259-4210-8f67-caeca172e0fc','PALA VEGA INTERNACIONAL , S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('590bdc4a-4322-4ebb-b5f0-41ee66193599','ARA CALZADOS, S.L.,',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('59c12257-2259-4210-8f67-caeca172e0fc','PEPE JEANS S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('5a09d3e8-cb9f-4712-bdbe-c139cd5ff7c1','RICARDO HERNANDEZ, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5a134667-0d97-4458-af7a-369a8bfc6d50','BERNEDA, S.A.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5aa12c02-4720-42d7-83d2-5ebf490898af','GLOBAL SIGLA unipessoal, LDA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5aabbe5d-c139-47ba-98e3-8d89bb6ef63f','HORCAJO INVESTMENT, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5bca07eb-0a06-45c7-85c8-5df4782857d5','CALZADOS PASODOBLE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5c80f46f-45d3-460e-b032-a7122bd3ffac','NORDIKA\'S, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5c849061-2311-4174-ae73-1d007a953342','INDUSTRIAS MERCURY, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5c9e1b5d-eff3-4c71-9c40-a11c683c781a','JESGLO S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5d186dba-ea15-4a52-9562-b3150fe96d36','INDIS CALZADO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5d6e642f-7afd-44ad-bf12-2c815b11abb0','BROTHERS A&A INTERNATIONAL SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5dfe3930-d1a9-4c97-bd67-28caed1ff347','TIMBERLAND ESPAÑA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5e65bd06-bf32-45db-97e8-be6de646faa4','ALMACENES DE CALZADO SEVA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5ec9de5a-368b-4028-bf88-8738c8cfe657','DAVIRGI',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5eca8e35-e0e8-447f-9982-e3c73248069d','CALZADOS VALDIVIESO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5eda18ab-592f-4e61-9f04-4174c3ab21d3','LIBERITAE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5edb2440-b50d-497b-83a1-04b652148584','CALZADOS MOYA E HIJOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('5f517f32-982a-4e51-9be3-f8c7df0a950c','NUOVO NICAR SRL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('60c12257-2259-4210-8f67-caeca172e0fc','PIKOLINOS INTERCONTINENTAL, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('61c12257-2259-4210-8f67-caeca172e0fc','PIKOLINOS S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('61cdb1d5-6f48-4c4d-a170-887d37d18ce0','CAFÉ DO BRASIL ES SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('629001d1-3794-497f-84c4-b6cf1eb48cd4','ALMACENES PEYCO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('62c12257-2259-4210-8f67-caeca172e0fc','REMAKE PREMIUM, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('62d1e980-331c-4fd8-86cb-39f2371edf8e','OUTDOOR KING, S.A.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('63c12257-2259-4210-8f67-caeca172e0fc','SHOES UNLIMITED B.V.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('63fce9ce-c3dc-4ecb-84d4-fa7f77624db2','Champion Europe S.R.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('640448f1-117a-48ba-9298-88f66f8d6c85','SALVADOR MULET, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('64177236-b8b1-42ba-95a1-f73e51fee9c8','CANDIDO SUBIRAN, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('64281b2e-bb53-4ac0-9615-f2fb0f3e6e76','PEPE MENARGUES',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('644ec86f-1b78-4c97-bde2-931256afd01f','JESO CONFORT S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('64c12257-2259-4210-8f67-caeca172e0fc','SKECHERS IBERIA, S.L.U',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('65997b93-567d-4e9b-911f-9558f7ff7f13','SPIFFY, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('65c12257-2259-4210-8f67-caeca172e0fc','STONEFLY S.P.A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('66083575-97ba-4231-bca0-7b763c1e4035','PIKOSTORE, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('66c12257-2259-4210-8f67-caeca172e0fc','TARKE UNION S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('66c667e0-70ad-42df-850d-e2b9c15a222c','D\'CALDERONI, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('67c12257-2259-4210-8f67-caeca172e0fc','TENDENCIAS SHOES S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('68707879-c5a4-489b-8ab0-064f8db87b4f','ZAPATELI, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('68c12257-2259-4210-8f67-caeca172e0fc','TOP 3 PROJECT S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('6969aad5-33df-487d-96cd-54d7e9941ba1','ANHELO ZAPATOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('69c12257-2259-4210-8f67-caeca172e0fc','TOP FASHION 88 S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('69d3e765-cef8-4f2a-9b0e-d106f42e05ff','KONA FOOTWEAR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('6a00ea52-6b0b-4ccf-821e-967bd6528909','SIMO SASTRE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('6a9f0d43-e409-4c00-80ab-ef47902235f9','EASY FOOTCARE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('6bea5878-2c50-4c7e-ab6c-4ff2db4e4682','LEROY, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('6d674b8a-04e5-4810-9171-ebf8576443b6','PEDRO INIESTA, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('6d86544c-9350-4505-8902-ecb4a11b1acf','NIKO IKO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('6e4fbdfd-dc50-4d5c-a182-59bc71818fba','NEOS CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('6eb216b1-ba6a-4946-acaa-3d3c8266ca9c','CALZADOS TORRES CALIDAD, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('70c12257-2259-4210-8f67-caeca172e0fc','VANITAS 2002, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('70de93f1-ee42-4b2e-a23e-26c91cf0c8f3','JUANA LLOP, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('70f8e9cc-1b97-4051-9e1b-4b32bf8cc272','JESUS HERAS LANDETE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('71c0cc3a-d268-44e1-92db-0cc55e6f1901','ROOTS UNIVERSAL S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('71c12257-2259-4210-8f67-caeca172e0fc','VEXED SHOES COMPANY, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('728645f0-7523-4534-a84e-b8aa6c2eabbe','PRONTAS TRADING, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('72c12257-2259-4210-8f67-caeca172e0fc','VIVENTI SHOES S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('72cf5297-cbf0-45c6-8e71-f3a678844f99','SILVIA HERNANDEZ, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('73c12257-2259-4210-8f67-caeca172e0fc','VIZGAR SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('7443859a-979d-44f5-be12-e102907eade7','BOLSOS H. FIGUEROA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('744694ae-dd08-4e98-98ee-fa3a740e6694','VULCANIZADOS ANIR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('74a60689-f73d-491e-b0a9-4e62d4a632de','CALZARELLA S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('74c12257-2259-4210-8f67-caeca172e0fc','MARROQUI SANCHEZ S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('7547a4d1-a298-42c4-80ad-b85a65884a04','ALPARGATAS SESMA, C.B.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('75c12257-2259-4210-8f67-caeca172e0fc','WORTMANN KG',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('76046fdd-3292-4019-a59e-a7b197dfbe6d','FORTUNATO O. FREDERICO & Ca',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('76c12257-2259-4210-8f67-caeca172e0fc','XTI FOOTWEAR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('77c12257-2259-4210-8f67-caeca172e0fc','YOKONO EUROPE, S.L.U',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('77f26f8e-ebac-4195-891e-8c4eddfaea2c','CALZADOS LUMEN, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7842e969-e352-4e9f-ba94-ce5383900c41','HIJOS DE RAFAEL CORRALES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('78d6386f-727d-4edf-8e1c-5094b8122c1e','HEVO IBERIA 2020, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('793046ac-8e3d-4420-8b3a-7f7bef4dd7fe','CALZADOS CALZALINE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('793583b8-a485-4ecb-8cde-9b0567b8c02b','GOLONCALZA S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('795df02d-78de-4cad-8422-ca682134182f','NORDIKA´S DISTRIBUCIÓN, S. L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7a1addd8-d4ba-4f2e-ad88-9bce6ec522b0','CNP BOLSOS 2000 S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7ac9eebd-d6ba-4be5-bdb9-f1e6b9033823','CALZADOS GAIMO S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7ae6232f-a6d3-41ac-b5de-7e120143847a','CALZADOS JOSEFA DIEZ, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7be54478-b139-483b-9143-29c8bd416ddb','INTER BIOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7c54de04-59b8-4057-a6a0-68a6ec9c962d','CALZACOMODO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7c98d86c-0010-4396-99c6-e13e22f9be62','GOLD WORLD BAG, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7cc6ea48-9a67-4c76-ba13-f526a5dddee4','NATURPIE, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7cec1cb5-e685-4ba2-bf93-9443f2347970','BRUEL, S.P.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7d728ae6-2439-4eee-867f-e783ab6a99e1','GRUPO SUTORIA MODA  S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7dc34bc0-e18d-4639-adb7-a586d335b04f','SPIRIT 2012, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7dd5a976-93e5-41ae-b433-67571e7ff61a','DIABOLO, S.C.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7e13f7da-01db-415d-928c-a87e82375e36','GRUPO LOLLAN´S TORREMATA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7e2037ac-0ff0-4313-ad0b-ec2e8073b57b','EMASA-CASTELLANO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7e4dc560-fc23-45d4-a194-d70d62773d85','ANZAMAR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7e58c133-35ae-4ef3-a129-54e2794021aa','TIRION SHOES S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7e96a4e5-24b6-4ea8-84ec-2a06901295b8','LIFE CONCEPT, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7eb5193a-eb54-4167-b328-594085fbbae6','BAG S.P.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7ee47e24-b51e-4c23-a950-9e43916cbfb0','SALVI CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('7f426c8a-38e2-4c08-8622-4e5a2b34bfb5','CRUAN, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('803962f2-d433-45fe-96a2-67f8e9c6e31c','SWELLON IMPORTS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('8089a78a-2b41-406b-93ce-504884c7a0c6','GROMO WORLD S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('8119680c-be22-4cd1-a2d4-2de925b22a42','KIOWAMODA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('81c73b3d-a78c-4cd4-852f-3b67aaa34b66','JEMMA FOOTWEAR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('824ecff3-247a-4746-b36b-d6e5379e1e9b','MY WAY FOOTWEAR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('84e34408-8f33-48be-be83-423e9d112458','FERMANBAG, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('84e68227-a4f0-40c4-8927-91f4affdaa83','OCA-LOCA KIDS SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('84fc1f48-a128-4405-ba4f-140e7d358674','ABC CONCEPT & CONSULTANCY HOUSE BV',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('854cc13d-527d-4900-b3ad-8380377758ee','DRENATI, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('8597f767-3607-4761-81c8-c801d3bcbbb8','ISSA MIEL DE CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('878c12257-2259-4210-8f67-caeca172e0fc','ZAPAMODA S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,'1'),('87f5839d-9218-4010-a59e-136d0d670f66','Huran Import Export, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('88b5eacd-e293-413e-99d5-bc7518cb8860','KRS SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('88d6e2ae-d842-4441-91b6-5e1313251b28','CALZADOS GEMA GARCIA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('89ce4cb0-b88e-4392-8b14-4deae6597ce4','ELOI Y ANA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('8a3bf721-d952-424a-a5ae-179a1c4986f8','ZAPATERIAS REUNIDAS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('8a462198-86fd-45a6-a156-51066a1061e0','LIBERTO JEANS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('8b57d777-93bd-4d33-9ad0-2a7d09bd87cc','MESQUITA SHOES S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('8daf4e5d-ecdd-416b-a5b4-612534e911d2','MANUEL ACOSTA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('8dee29fc-5c14-4e7c-9a8f-22a31bd7cff3','ILIDISCAL, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('8df1cdad-e148-4053-a6c1-9fac71c33f5b','VIDORRETA, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('8febfda8-48fc-464b-b441-b30957b22a4c','JUAN LACARCEL S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('8ffcb1e4-93da-4ee4-9201-8ccfd079e431','OU SHENG CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('90436cc8-0803-425d-82f7-b6d5d69bee8d','ANATÓMICOS D’KEL, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('90768f0a-6dc7-4a22-b057-d101a5190511','CORTY BENNETT, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('909b2a02-e80d-47d4-950b-031e5931d5de','MEDITERRANI BAGS, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('90eacc3b-df53-4409-856f-b013aa10794e','CALZADOS MORETTI, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('914ea963-15ce-4588-a0ca-03852931461c','KIOWAMODA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('92c8abfd-dfed-4a94-92b5-ac7d76de1ca7','GRUGESCAL SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('93a306be-6da7-4dca-9919-41119817b0cd','MASVA PROJECT, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('942ac93d-05d4-4752-952e-397a49303c2f','MARIA CRISTINA FERNÁNDEZ NÚÑEZ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('942ca4e1-c1a0-476f-ae5f-4a107edd2c80','CALZADOS ROAL, S.A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('942deb36-e295-4901-bfd8-2198f064ab68','J PONCE, S.C.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('955f6c6f-a040-44f0-8ab2-ad6fa5510743','ADOC S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('958916a7-f90e-472b-93f9-9d1ffd0e0668','BLUEBAGS & ACCESORIES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('95b2096c-dd4b-4f24-8cde-3dbb8b9b23cc','JDE SON TRES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('95da5894-1de8-4e6e-b2de-dd2d6830d592','CALZADOS ROMERO S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('966e1fd4-36d2-4e3b-99d7-bc9dd5967b33','COLISEO CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('968dc7b3-8c1b-41a7-88d2-44028014b368','SEYMA IMPORTACIÓ, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('97667441-09da-40b1-8aa8-1ec461cf7723','PAVACINI INTERNATIONAL, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('978e4f5b-ba7a-442f-ae27-32ea57b5392c','DEJERVIS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('982f41c7-7f70-40e8-aa5e-0d598db8b60b','THE MTNG GLOBAL EXPERIENCE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('98d2fcd0-fcb5-4be7-ae55-ef811850d04b','S.F.A., S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('98e36b24-9ca2-4d3e-9d44-ab37038e33df','JOSE ALFONSO ARPON, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('98edb8c2-8ffd-4723-ad2e-f614b1d6cb9c','TEAM SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('990be005-aa5d-499c-9dd4-f9d158f79d3c','ISOTONER POUR PLAIRE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('9964ad79-5a8f-44bb-89d2-b850e5b24906','D´C CALZADOS S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('99999999999999999999','No encontrado',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),('9a3c96db-8861-4576-99d2-197442cfa61f','MARIÍA DE LOS MILAGROS TRIÑANES OUVIÑA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('9a8c4251-47d6-4eb8-a8c8-09e076355851','JOSÉ TORTOSA ORDOÑEZ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('9abc54ad-54ce-4b8a-8699-440dde33763c','NAUTIC BLUE ILLICE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('9c2a60e6-e101-4eac-835c-0d87025da047','SIRERA TRADING, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('9c3a6002-a020-49ec-9fdb-c26ea617e27b','MARROQUINERIA SIGON, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('9cf40791-dd14-4c2f-904a-704b308ecece','NAVIMA CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('9e11a69c-3755-4774-8d8b-a9996a4c6d28','JÚLIO SAMPAIO TEIXEIRA &CIA, LDA.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('9f5e20ad-02a6-4f8c-8a85-9aeee9fa3d71','FABRICA DE CALZADO CAPO NORD, S.R.L.U',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a0305cf9-5fff-4d0f-9a56-1380fba0fb3c','RIVERTY SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a03d9403-884a-43f7-b5c0-5993d3736371','CALZAPEDIC, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a0f6ef57-ce1c-4b0a-aa67-240f1199adae','PLANTILLAS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a122238d-4887-4cd7-9ff1-419cbfd92204','AROS, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a134be31-59cf-438a-bc01-126f81536ece','ARETEX S.A.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a185a1a4-a369-42d1-9ea9-cb6472129ca6','AOLAN TRADING  S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a1c39b31-8df2-4402-a4c3-19acefdff12a','SHILA WOMAN, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a1fb3efc-fc26-48dd-baa8-86fdfdd2ca9c','CALZADOS DIGO DIGO, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a23416de-23ed-4a57-aed6-62fcd2e678ad','NOCO ACCESORIOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a24568a1-5d42-4250-958a-eb556ddceac9','ALTA MODA CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a2a4f2a2-74a0-49b4-b325-a95dd4c47d18','CARLOS PLA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a36a7e67-b384-410b-be3d-6e96382eec67','MIGUEL BELLIDO, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a3d544c9-12fb-41f9-99a5-efd4115ecaae','GIKO GROUP TELECOMUNICACIONES S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a3e59d67-2ed3-4118-aaa6-3d69c6f3f321','CLENAPAL, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a4bacdcf-e9d0-4069-8d09-54bb31aa51c4','PROFIVENSA S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a4bc11c7-aee4-46ee-8026-6047760d52ef','S. C. JOHNOSON & SON, INC.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a507532a-7775-44e9-bb56-38a6e16fb706','MILAN CLASSIC S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a6b093f1-ee9a-4fc5-ae33-aa90c5e561ce','JATRO BCN S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a963bd84-f9fa-49f0-b5fb-8d6f33a9951a','CALZADOS GUANFLEX, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('a96451a6-2131-4c7a-87e7-0d540fb25fa8','ARTESANOS SINDO\'S, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('aa52b8d1-23c8-4344-8546-ae5af23cb3bc','SAB CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('aa85ed1c-9a85-4106-b65f-421745634a34','BIRKENSTOCK SPAIN, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('aab49d85-fece-4530-86f2-884615ded5cb','UNISA EUROPA, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('aad117c8-9e64-4f0f-90f5-a53f00ced8fe','DEERFOOT SPORT, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('aad261f5-2e10-4e28-9389-7b87f70aa562','JOSE SAENZ, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ac36bfe9-9428-45ee-abcf-beb02286b7ce','COMERCIAL NEWPE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ac8bc4bc-cf0b-4342-936b-d63af6135403','NEW ERA CAP COMPANY LIMITED',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('aca1d5e4-fe9d-4875-a86d-364577012d75','ADULOMAR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ace5c3e0-96b5-40c4-b556-1c972f827d94','ECCO EMEA SALES SE.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('acfbddf5-a73f-4d1c-82a1-d6073e649b5c','CALÇATS PLANAS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('adfa4961-e934-472e-b39d-3533231e70f7','MONCAS CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('aee638a3-9feb-41c9-85d8-bf00e1901fe8','VULCANIZADOS CABRERA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('aef3088e-df32-4653-a3ee-f5d352d7d776','POMARES VAZQUEZ S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('afb473ee-06b6-4455-87da-552758640dc7','MARIA CARLÓ, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('afeb2b75-3286-4675-b201-6efaf1e014cc','CREACIONES PASOS DE BAILE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b0802f37-21d3-49f2-8fdb-10d7e4625b87','EUFORIA, S.L.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b0d2f743-9435-49b5-aaa7-e8b330049bee','PONI SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b2ca1c17-beb7-405a-8001-b40d957e27a5','CALZADOS ELCHE-JPG, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b3954a3b-6f5c-45c6-bb12-b3c9dbf673b4','NEW GENERATION MARISCAL, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b3b1b173-cf8f-4584-a7bb-aeb5cec2f376','CALZADOS ARANZA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b4eefbdd-cbf8-4f9a-b50d-d0c37464b9d9','LABORATORIOS HERBITAS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b510b51d-e6c8-49dc-b304-9713ddcf618b','HIJOS DE PEDRO ARROYO S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b53a1e00-0825-4b28-9b06-e89f64ac160e','VULCANIZADOS D\'VALVERDE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b5aacc95-0010-4260-85c7-4216510fd2dd','XDC EUROPE DISTRIBUTION, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b74fdffc-e080-462f-a430-89f6dc0d9d13','CALZADOS CASTELLER S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b7874865-0c9e-4f38-9f6a-757b6aca576d','SHOES FROM MED S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b7a72b70-6f23-4f84-bdd3-a00c04415c5b','JOYKIDS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b7be1431-4a8e-4c7c-afdd-dcf358da01a5','AIMAKE SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b91a9d02-761d-45ce-b43a-ab091edf7555','EL BOCAO CALZADOS Y COMPLEMENTOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b92ab370-4c94-4ce3-9c46-c31665359342','BONIS, S.P.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('b968efbd-239b-47f0-bd7e-1ed489d601e1','MEGASPORT, S.A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ba3bdf6a-b3cc-480d-9060-388dd6076f04','LEVANTINA DE CALZADO Y COMPLEMETOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ba85abf4-4474-4aab-ab64-628d7e1e4a2b','CLYFOR PIEL S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('bb6ef0a1-f927-4b89-ad25-27643c481bad','CALZADOS PACO SAEZ, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('bb864c90-1a4d-4d0b-a0b1-7faa1f9d5fe6','PASOLI, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('bd5784e5-51b9-41ab-a9f8-e65122127f70','AIRILLICE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('bdb7b20e-3130-49ea-82a8-c563e99e8664','CALZADOS ANDREA RUIZ , S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('beb1d468-40b2-4e4a-a6d7-359d3a7b9319','MENBUR, S.A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('bf4075f1-48fe-4688-98d9-485ade605c57','GRIMEY WEAR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('bfd8a76a-5e12-4216-83b1-04ae180158cf','RA-EL CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c06ad044-f14e-4b74-a3af-a327eb36eba5','NORTEÑAS S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c077b6a5-28b6-4327-95b4-51be92e543a8','VANITAS 2002, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c0c8d0fd-5b7c-486f-adc2-c33c0f82e845','NATURAL VULKAN, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c17cffaf-f63f-44c8-91a9-5ce4bea6f7a2','SANT LUIS CALZATURE, SRL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c1cb85e0-7571-448a-9890-0db968cdcbdc','CALZAFLECHY, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c2a1a67d-1199-43ed-90cd-43a5ef18c232','ILLICE INTERNACIONAL, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c346abcb-98e7-4381-9b67-f8dd92a4514b','K&K DISTRIGUICAO DE CALCADO, LDA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c39f5aa5-fcea-4c4b-b0de-98b989428a7d','GLOBAL DEL CALZADO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c4d02c0a-0902-4c11-b31d-f0a7e001fda0','PUMA IBERIA, S.L.U',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c4f2cad9-a774-4612-909c-3a1b967dcceb','LOTTUSSE, S.A.U',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c57575ae-13f2-4631-9009-fd6e89e89f88','GIMENEZ ANTON, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c5ee313c-62cd-42d4-b807-97cac535a1b0','CALZADOS NUEVO MILENIO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c66c3b5f-51ed-4df2-9527-92830c5a8588','LE COQ SPORTIF, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c6d0b8d5-7ff4-416c-bd23-c02db3d876c7','CALZADOS TREBEDE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c7d4aea6-da31-4b69-a0ac-3df07d93597e','FIRSTEAM COMERCIAL, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c8189c51-525b-4cc6-9087-4f315f20abb8','VICMART SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c8806b76-5238-4fe4-a41a-a09873cab4b1','MEPHISTO E-COMMERCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c8886ec7-6c59-4278-8cdd-3ee618179fb2','COMPAÑIA GENERAL DE ZAPATERIAS, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c8d58a4b-1aa7-4e89-a963-7050c2b548f7','RIF-RAF, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('c9fec5fe-cb22-477c-8f69-4df91d8a4232','PORRONET SOFT & LIGHT S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ca221d50-4829-4e79-b815-3c7ddab4d441','FOREST IMP. & EXP. S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('cb33ede3-ec9f-450d-93b1-c59b0ecb75da','FOUREME S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('cc801643-3641-43e9-bb27-14b521d4c470','J. MOREIRA LDA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ce308430-d3b6-4614-924e-ad0372102995','MEIVA SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ce382258-fc7b-4e61-a705-294370c44f02','REFLOY CALZADOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ce844299-d9c0-4f96-b01f-f6445d9e4d4d','KRL EN EL MUNDO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ced55e96-c6ff-49af-8e51-c89008ba1530','RAMONCINAS  S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('cf72f86f-711f-4459-b54b-c3ed8db32503','ARTESANIA RAPE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d02518e5-bd93-4afd-82dc-f71ba6120e87','INTERNACIONAL FOOTWEAR TECHNOLOGY, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d02ae3f7-afae-4df5-a1d2-081a1e1fead6','TECNI-SHOE,  S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d0c20df1-ec05-4717-a691-688a48261d45','SUELAS DE YUTE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d13aebc7-436b-417c-aec4-b193d0f3e480','ERASE SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d16c31ee-48fd-4d88-bdb8-04528fc8eb9b','DISTRIBUIDORA DE CALZADO ARTESANAL DE VILLENA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d16ee35a-74ab-4409-83d7-d2f863cea541','ALFICO, S.A.U',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d1ad3bea-363b-43c4-86f8-50eb5d841e18','SECRET SPOT, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d246ec0d-a516-45dc-8d0f-8115183e4ef9','FLOP SHOES S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d248177e-979f-4094-82f7-21334c17d9aa','CALZADOS DESIGN FRANK S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d24f50dc-5857-4272-b075-218e8f5e3560','INTERNATIONAL SHOES GARVALIN, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d29b39b6-d165-40f6-8b92-82037df9cee1','TOMAS GARCIA AGULLO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d413c979-7122-42a6-a334-e57c16d70ad3','CALZADOS ARNEDANOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d4189954-f5d2-498a-9f45-c2a41fb05e9c','FABRICA DE CALZADOS COSDAM S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d432473f-91c9-495e-bf26-05c4047edac7','PANAMA JACK S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d4ad6f62-2f4f-4857-be1b-d35f2d15e8e2','CALZADOS HOLLYWOOD, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d4ef38f5-cfac-44d4-bd05-5059f975db55','FLOSSY STYLE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d571f4c2-a3ae-429a-bb98-711a3a2a88f1','SEBASTIÁN FRONTERA RIPOLL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d5a933ba-1271-46f5-b327-ef28358810dc','PEPA RICO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d6744358-7bba-481f-b90a-fab77f723449','VULCANIZADOS GARZÓN, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d6f6fe1e-7344-4cf9-bc08-de99caa9d26d','CARLOS ROMERO',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d7468b33-923d-4029-81db-10d13f202088','CALZADOS ISARUS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d799a9d6-2e78-48f1-a4a1-e7a7669031df','CALZADOS PABLO, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('d8308aa8-6f3a-444e-bd7b-53a19a799281','MATÍAS SALVA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('dae2d8d8-5e1c-4008-843c-a0cd78dc1d19','PEPE MILAN, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('dbb60faf-e708-4ae9-9a0f-98d176f7a180','SCARPI EUROPA S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('dcc40d60-aa24-4c8a-9c50-f0022e7576d7','RIC BEL FABRICA DE CALZADO, LDA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('dd217a1a-16d6-41a7-9726-c2568d78c985','SILVIA PORROCHE TURRILLAS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('dd286385-0c0d-4791-9512-6d0f9bddfe5f','CALZADOS BAMA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('df091e3e-14e3-4538-84d7-8e7b98e75462','FOREVER RETAIL, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e009bd1d-ca16-44de-a666-d2dc214d9f56','SESEY S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e07b5b60-375f-474f-beea-8f8f3a1ccb74','Matias Salva, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e07bbf03-3083-4397-91dd-0430c46cce9a','CASTELHANOS COMERCIO E INDUSTRIA DE CALÇADO, LDA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e0a921c1-9237-4732-9154-c9297c20475e','ERDO AYAKKABI E, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e1269163-be27-49bf-905e-4c830bb04dfe','NATURAL-MAKER, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e13e134d-60ec-4bc1-a083-86a3d0b06c92','ADIDAS España S.A.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e13edaae-806e-4213-8be7-deb265d39b2a','LOLA CASADEMUNT, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e257760e-991c-43ea-935c-26a0a65d090a','RIA MENORCA RETAIL, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e2d8eef1-21aa-4854-a559-38d5a27e53e1','J´HOAQUINETTI, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e2dc0b8a-c3f1-4183-b872-66e4c78b3abc','SABRINAS COMFORT SHOES S.L.U',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e4d58a90-7473-44e2-b029-497c1f203619','CALZADOS SELQUIR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e4d6e014-4cf0-4958-b2f3-9296bf275f23','CALZANOR, S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e513c00f-7ca3-4c31-8af1-1b72d3eaef57','ROPAR ESPAÑA, E.P.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e56114c5-81ab-4e1e-bf3d-ca2a3ac079f2','BIRKENSTOCK GmbH & Co. KG',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e59071e8-712f-4c2b-b596-3ab782933ad1','HURLEY 999, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e5d0e0a1-40d8-405c-a974-0736ca3a6e01','MARROQUINERIA DINMAR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e631cd11-7756-4779-ba61-d34b69f71267','LRK SANDALS TRADING, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('e9ae1fd0-0a80-45ee-b5e9-46a8453ab6f3','CALZADOS DODI, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('eb09a35b-f7f2-4f90-8a39-18115c2ea808','RAGADI 2014,S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('eb3b3b17-2c61-45e5-ba85-5a87249e7edf','FACTORY INTERNATIONAL DEL CALZADO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('eb6caf6b-57ed-4092-ae9f-80cceb35c631','PINTURINES, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ec0ebcdd-6b33-4667-b0d4-16704eba56f5','DIVISIÓN ANATÓMICOS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ecd805f0-5dcb-45ea-a0de-6167a728da7d','PABIEG IMPORT EXPORT S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('edd47f4b-2a79-4293-a92c-f1699e385535','EUROHISPANA DE INVERSIONES, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ee0d58ac-a873-46bd-a1b3-9a066b614571','TRENDY KING S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('efe0e76f-003f-4cbd-bda8-032e08191447','ECOCALZA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('efe272d4-9658-4c62-a776-096211debb85','DIADORA S.P.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('effa9fc2-d23f-4187-8583-b232039270ef','SUMBAWA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f0b78499-7332-4261-9c6f-7f2d4eb69370','LORENS SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f3059285-ec64-4fae-9e77-d6de4853b5d2','ALMACENES CASORI, S.C.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f4e5100b-dfb2-4154-9717-b710beee0e5a','COMERCIAL SARCA, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f51b2742-6571-4b0e-9295-98c25915e3d7','CALZADOS ARANCHA, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f55a61e8-d1e3-4a96-bf82-02f8c18a9e6e','A.G. SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f568010a-85de-4b3f-b41a-4ca787e691bf','D. ISIDRO GONZÁLEZ PERANT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f5b40deb-2435-4d2a-bee6-799817a1cce1','HELENE ROUGE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f5c0aacc-4ad5-4672-9960-f307e4f51885','MORANGUITO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f6483f69-367f-4f18-9e65-7a2b7379e6f7','VULCANIZADOS FEMAR, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f6e3b822-bcf8-4f50-8fd4-518eee252b78','THE HOFF BRAND, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f71599e2-65a4-48f3-9eac-c1e0e6d625f3','CROCS SPAIN S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f788728f-03ce-44cd-8c2f-c7ef81ce8d2c','EZPELETA DIVISIÓN COMERCIAL, S.L.U.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f7ce9310-b73d-4431-8b83-93b015942620','HIMALAYA, S. COOP. LTDA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f930b898-8a81-4982-aa6f-7ef3eddc77e7','PACONFI, S.L',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('f9484efe-bc7f-406f-b340-58ea820991e0','WIKERS SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('fa08fcd3-66aa-481f-95f3-98cf0e80f472','AMERICAN NIKE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('fa5445c5-ad37-4828-b93f-083961dcb1cc','WALNIKKO SACS S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('fae754ed-fa51-44b1-af64-29d5026f0652','GARRIDO MURO, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('fb90b637-d7f2-49da-8341-f5085d11b054','NMC SHOES, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('fc1cfdd5-9b4a-4173-95ab-899248b20f4a','TOPYTES CALZADO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('fc7963ae-8ffa-4a72-af5e-7704571086f7','CALZADOS ROLDAN SERRANO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('fcef4f0a-b0d9-4be9-91db-4b7e952114b1','PLANELLES Y MAESTRE, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('fcf6432b-96e2-4cd8-8445-077a20b0bd68','C. & J. CLARK INTERNATIONAL LIMITED',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('fdd7e021-ea9f-4e32-9304-7d3e8efbc63c','EQUUS HISPALIS S.L.,',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('fe19debf-8733-400c-acb5-141e1324dbea','CALZADOS ZELS, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('fe541d37-1e2f-4fcd-8bd4-44afa8245ae4','GIORDA S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('fe58ec9f-cae7-45b5-83fe-03909fbd41dc','INYECTADOS Y VULCANIZADOS, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('fea9b903-4501-482d-bfef-06adfcce52f4','TANTREND BIJOUX, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('feb76665-2514-40bc-99d3-d6d64558a468','ATHLETIC KING, S.A.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ff8a133c-2ac1-4141-9c6c-f27d6230a75c','GRUP PELL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ff9823c9-b455-4cd2-81a6-35c54c51f2ea','CALSERGIO ROMERO, S.L.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL),('ffe0ffc6-2716-4c8c-bdd7-f1692df351ae','BRONX FASHION BV',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'user_placeholder.png',NULL,0,NULL);

--
-- Table structure for table `dealerCarrier`
--

CREATE TABLE `dealerCarrier` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dealer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `email` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `phone` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `address` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `city` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `zip` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `province` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C62705AC249E6EA1` (`dealer_id`),
  CONSTRAINT `FK_C62705AC249E6EA1` FOREIGN KEY (`dealer_id`) REFERENCES `dealer` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `dealerCarrier`
--


--
-- Table structure for table `dealerDefaultDiscounts`
--

CREATE TABLE `dealerDefaultDiscounts` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `dealer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `default_discount_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_876A0FF6249E6EA1` (`dealer_id`),
  KEY `IDX_876A0FF6988F72A9` (`default_discount_id`),
  CONSTRAINT `FK_876A0FF6249E6EA1` FOREIGN KEY (`dealer_id`) REFERENCES `dealer` (`id`),
  CONSTRAINT `FK_876A0FF6988F72A9` FOREIGN KEY (`default_discount_id`) REFERENCES `dealerDiscount` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `dealerDefaultDiscounts`
--


--
-- Table structure for table `dealerDiscount`
--

CREATE TABLE `dealerDiscount` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `target_id` int DEFAULT NULL,
  `dealer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `dealerDiscounts_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_2A001976158E0B66` (`target_id`),
  KEY `IDX_2A001976249E6EA1` (`dealer_id`),
  KEY `IDX_2A00197647D66225` (`dealerDiscounts_id`),
  CONSTRAINT `FK_2A001976158E0B66` FOREIGN KEY (`target_id`) REFERENCES `typeTargetDiscount` (`id`),
  CONSTRAINT `FK_2A001976249E6EA1` FOREIGN KEY (`dealer_id`) REFERENCES `dealer` (`id`),
  CONSTRAINT `FK_2A00197647D66225` FOREIGN KEY (`dealerDiscounts_id`) REFERENCES `typeDiscount` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `dealerDiscount`
--


--
-- Table structure for table `dealerDiscounts_companies`
--

CREATE TABLE `dealerDiscounts_companies` (
  `dealer_discount_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `company_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`dealer_discount_id`,`company_id`),
  KEY `IDX_858FAA432713A68D` (`dealer_discount_id`),
  KEY `IDX_858FAA43979B1AD6` (`company_id`),
  CONSTRAINT `FK_858FAA432713A68D` FOREIGN KEY (`dealer_discount_id`) REFERENCES `dealerDiscount` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_858FAA43979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `dealerDiscounts_companies`
--


--
-- Table structure for table `dealerPaymentMethod`
--

CREATE TABLE `dealerPaymentMethod` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `dealer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `expiration_days` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `type_dealer_payment_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_73CB518B249E6EA1` (`dealer_id`),
  KEY `IDX_73CB518BBC64D970` (`type_dealer_payment_id`),
  CONSTRAINT `FK_73CB518B249E6EA1` FOREIGN KEY (`dealer_id`) REFERENCES `dealer` (`id`),
  CONSTRAINT `FK_73CB518BBC64D970` FOREIGN KEY (`type_dealer_payment_id`) REFERENCES `typeDealerPayment` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `dealerPaymentMethod`
--


--
-- Table structure for table `dealer_brand`
--

CREATE TABLE `dealer_brand` (
  `dealer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `brand_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`dealer_id`,`brand_id`),
  KEY `IDX_31246D26249E6EA1` (`dealer_id`),
  KEY `IDX_31246D2644F5D008` (`brand_id`),
  CONSTRAINT `FK_31246D26249E6EA1` FOREIGN KEY (`dealer_id`) REFERENCES `dealer` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_31246D2644F5D008` FOREIGN KEY (`brand_id`) REFERENCES `brand` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `dealer_brand`
--


--
-- Table structure for table `dealer_stock_discount`
--

CREATE TABLE `dealer_stock_discount` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `stock_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_907B1F9DCD6110` (`stock_id`),
  CONSTRAINT `FK_907B1F9DCD6110` FOREIGN KEY (`stock_id`) REFERENCES `stock` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `dealer_stock_discount`
--


--
-- Table structure for table `directoryElement`
--

CREATE TABLE `directoryElement` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `dealer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `observations` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeDirectoryElement_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_625ADF3B249E6EA1` (`dealer_id`),
  KEY `IDX_625ADF3B2242E413` (`typeDirectoryElement_id`),
  CONSTRAINT `FK_625ADF3B2242E413` FOREIGN KEY (`typeDirectoryElement_id`) REFERENCES `TypeDirectoryElement` (`id`),
  CONSTRAINT `FK_625ADF3B249E6EA1` FOREIGN KEY (`dealer_id`) REFERENCES `dealer` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `directoryElement`
--


--
-- Table structure for table `discountCustomGroup`
--

CREATE TABLE `discountCustomGroup` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `amount` double DEFAULT NULL,
  `typeSaleDiscount` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `groupConfiguration_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D6E9F8A1FE54D947` (`group_id`),
  KEY `IDX_D6E9F8A1A76ED395` (`user_id`),
  KEY `IDX_D6E9F8A114554B20` (`typeSaleDiscount`),
  KEY `IDX_D6E9F8A1A7842C90` (`groupConfiguration_id`),
  CONSTRAINT `FK_D6E9F8A114554B20` FOREIGN KEY (`typeSaleDiscount`) REFERENCES `typeSaleDiscount` (`id`),
  CONSTRAINT `FK_D6E9F8A1A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_D6E9F8A1A7842C90` FOREIGN KEY (`groupConfiguration_id`) REFERENCES `group_configuration` (`id`),
  CONSTRAINT `FK_D6E9F8A1FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `discountCustomGroup`
--


--
-- Table structure for table `discounts`
--

CREATE TABLE `discounts` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `date_start` datetime NOT NULL,
  `date_end` datetime DEFAULT NULL,
  `nameForLabels` varchar(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_available_on_website` tinyint(1) DEFAULT NULL,
  `label_website_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `avoid_text_and_hide_discount` tinyint(1) DEFAULT NULL,
  `is_available_on_amazon` tinyint(1) DEFAULT NULL,
  `is_available_on_amazon_prime` tinyint(1) DEFAULT NULL,
  `migrated_at` datetime DEFAULT NULL,
  `is_migrated_to_discounts_for_article` tinyint(1) DEFAULT NULL,
  `typeArticlePrice_id` int DEFAULT NULL,
  `is_available_on_spartoo` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_FC5702B8FE54D947` (`group_id`),
  KEY `IDX_FC5702B8A76ED395` (`user_id`),
  KEY `dateStart_idx` (`date_start`),
  KEY `IDX_FC5702B8B4874AFE` (`typeArticlePrice_id`),
  KEY `dateEnd_idx` (`date_end`),
  KEY `isAvailableOnWebsite_idx` (`is_available_on_website`),
  KEY `isAvailableOnAmazon_idx` (`is_available_on_amazon`),
  KEY `isAvailableOnAmazonPrime_idx` (`is_available_on_amazon_prime`),
  KEY `isAvailableOnSpartoo_idx` (`is_available_on_spartoo`),
  CONSTRAINT `FK_FC5702B8A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_FC5702B8B4874AFE` FOREIGN KEY (`typeArticlePrice_id`) REFERENCES `typeArticlePrice` (`id`),
  CONSTRAINT `FK_FC5702B8FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `discounts`
--


--
-- Table structure for table `discountsElement`
--

CREATE TABLE `discountsElement` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `discounts_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `stock_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `amount` double DEFAULT NULL,
  `typeDiscount` int DEFAULT NULL,
  `is_different_prices` int DEFAULT NULL,
  `round_json` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_962C7DAD6A35CCB1` (`discounts_id`),
  KEY `IDX_962C7DADDCD6110` (`stock_id`),
  KEY `IDX_962C7DAD44FF58D0` (`typeDiscount`),
  CONSTRAINT `FK_962C7DAD44FF58D0` FOREIGN KEY (`typeDiscount`) REFERENCES `typeDiscount` (`id`),
  CONSTRAINT `FK_962C7DAD6A35CCB1` FOREIGN KEY (`discounts_id`) REFERENCES `discounts` (`id`),
  CONSTRAINT `FK_962C7DADDCD6110` FOREIGN KEY (`stock_id`) REFERENCES `stock` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `discountsElement`
--


--
-- Table structure for table `discountsElementArticle`
--

CREATE TABLE `discountsElementArticle` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `discounts_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `article_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `amount` double DEFAULT NULL,
  `is_different_prices` int DEFAULT NULL,
  `round_json` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pvp` decimal(14,2) DEFAULT NULL,
  `status_poscurrent` int DEFAULT NULL,
  `status_posnext` int DEFAULT NULL,
  `status_website` int DEFAULT NULL,
  `status_marketplace` int DEFAULT NULL,
  `typeDiscount` int DEFAULT NULL,
  `status_marketplace_1` int DEFAULT NULL,
  `status_marketplace_2` int DEFAULT NULL,
  `status_marketplace_3` int DEFAULT NULL,
  `status_marketplace_4` int DEFAULT NULL,
  `status_marketplace_5` int DEFAULT NULL,
  `status_marketplace_6` int DEFAULT NULL,
  `status_marketplace_7` int DEFAULT NULL,
  `status_marketplace_8` int DEFAULT NULL,
  `status_marketplace_9` int DEFAULT NULL,
  `status_marketplace_10` int DEFAULT NULL,
  `status_marketplace_11` int DEFAULT NULL,
  `status_marketplace_12` int DEFAULT NULL,
  `status_marketplace_13` int DEFAULT NULL,
  `status_marketplace_14` int DEFAULT NULL,
  `status_marketplace_15` int DEFAULT NULL,
  `status_marketplace_16` int DEFAULT NULL,
  `status_marketplace_17` int DEFAULT NULL,
  `status_marketplace_18` int DEFAULT NULL,
  `status_marketplace_19` int DEFAULT NULL,
  `status_marketplace_20` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C05DE7366A35CCB1` (`discounts_id`),
  KEY `IDX_C05DE7367294869C` (`article_id`),
  KEY `IDX_C05DE73644FF58D0` (`typeDiscount`),
  KEY `status_poscurrent_idx` (`status_poscurrent`),
  KEY `status_posnext_idx` (`status_posnext`),
  KEY `status_website_idx` (`status_website`),
  KEY `status_marketplace_idx` (`status_marketplace`),
  KEY `status_marketplace_1_idx` (`status_marketplace_1`),
  KEY `status_marketplace_2_idx` (`status_marketplace_2`),
  CONSTRAINT `FK_C05DE73644FF58D0` FOREIGN KEY (`typeDiscount`) REFERENCES `typeDiscount` (`id`),
  CONSTRAINT `FK_C05DE7366A35CCB1` FOREIGN KEY (`discounts_id`) REFERENCES `discounts` (`id`),
  CONSTRAINT `FK_C05DE7367294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `discountsElementArticle`
--


--
-- Table structure for table `discounts_shops`
--

CREATE TABLE `discounts_shops` (
  `discounts_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `shop_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`discounts_id`,`shop_id`),
  KEY `IDX_CF1FF4C86A35CCB1` (`discounts_id`),
  KEY `IDX_CF1FF4C84D16C4DD` (`shop_id`),
  CONSTRAINT `FK_CF1FF4C84D16C4DD` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_CF1FF4C86A35CCB1` FOREIGN KEY (`discounts_id`) REFERENCES `discounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `discounts_shops`
--


--
-- Table structure for table `document`
--

CREATE TABLE `document` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `orders_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `customer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `date_creation` datetime NOT NULL,
  `date_update` datetime NOT NULL,
  `filename` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeDocument_id` int DEFAULT NULL,
  `reception_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `invoice_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `customerWholeSaler_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `wholeSalerInvoice_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D8698A763BEBD1BD` (`typeDocument_id`),
  KEY `IDX_D8698A76CFFE9AD6` (`orders_id`),
  KEY `IDX_D8698A769395C3F3` (`customer_id`),
  KEY `IDX_D8698A767C14DF52` (`reception_id`),
  KEY `IDX_D8698A762989F1FD` (`invoice_id`),
  KEY `IDX_D8698A769FE97E5B` (`customerWholeSaler_id`),
  KEY `IDX_D8698A767EB10BA9` (`wholeSalerInvoice_id`),
  CONSTRAINT `FK_D8698A762989F1FD` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`id`),
  CONSTRAINT `FK_D8698A763BEBD1BD` FOREIGN KEY (`typeDocument_id`) REFERENCES `typeDocuments` (`id`),
  CONSTRAINT `FK_D8698A767C14DF52` FOREIGN KEY (`reception_id`) REFERENCES `receptions` (`id`),
  CONSTRAINT `FK_D8698A767EB10BA9` FOREIGN KEY (`wholeSalerInvoice_id`) REFERENCES `wholeSalerInvoice` (`id`),
  CONSTRAINT `FK_D8698A769395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`),
  CONSTRAINT `FK_D8698A769FE97E5B` FOREIGN KEY (`customerWholeSaler_id`) REFERENCES `customerWholeSaler` (`id`),
  CONSTRAINT `FK_D8698A76CFFE9AD6` FOREIGN KEY (`orders_id`) REFERENCES `orders` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `document`
--


--
-- Table structure for table `fidelityCard`
--

CREATE TABLE `fidelityCard` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_33A25E81FE54D947` (`group_id`),
  CONSTRAINT `FK_33A25E81FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `fidelityCard`
--


--
-- Table structure for table `forWebsiteSectionCategorySorted`
--

CREATE TABLE `forWebsiteSectionCategorySorted` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `section_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `websiteConfig_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_52B00A63FE54D947` (`group_id`),
  KEY `IDX_52B00A63D823E37A` (`section_id`),
  KEY `IDX_52B00A6359FD88CD` (`websiteConfig_id`),
  CONSTRAINT `FK_52B00A6359FD88CD` FOREIGN KEY (`websiteConfig_id`) REFERENCES `websiteConfig` (`id`),
  CONSTRAINT `FK_52B00A63D823E37A` FOREIGN KEY (`section_id`) REFERENCES `section` (`id`),
  CONSTRAINT `FK_52B00A63FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `forWebsiteSectionCategorySorted`
--


--
-- Table structure for table `forWebsiteSectionCategorySortedElement`
--

CREATE TABLE `forWebsiteSectionCategorySortedElement` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `section_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `category_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sort` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E4FBDD86D823E37A` (`section_id`),
  KEY `IDX_E4FBDD8612469DE2` (`category_id`),
  CONSTRAINT `FK_E4FBDD8612469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
  CONSTRAINT `FK_E4FBDD86D823E37A` FOREIGN KEY (`section_id`) REFERENCES `section` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `forWebsiteSectionCategorySortedElement`
--


--
-- Table structure for table `forWebsiteSectionCategorySubcategorySorted`
--

CREATE TABLE `forWebsiteSectionCategorySubcategorySorted` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `section_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `category_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `subcategory_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sort` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_24D88FEFD823E37A` (`section_id`),
  KEY `IDX_24D88FEF12469DE2` (`category_id`),
  KEY `IDX_24D88FEF5DC6FE57` (`subcategory_id`),
  CONSTRAINT `FK_24D88FEF12469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
  CONSTRAINT `FK_24D88FEF5DC6FE57` FOREIGN KEY (`subcategory_id`) REFERENCES `subcategory` (`id`),
  CONSTRAINT `FK_24D88FEFD823E37A` FOREIGN KEY (`section_id`) REFERENCES `section` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `forWebsiteSectionCategorySubcategorySorted`
--


--
-- Table structure for table `gift_card`
--

CREATE TABLE `gift_card` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `issuing_shop_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `issuing_user_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `alias` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `barcode` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `amount` double DEFAULT NULL,
  `is_been_exchange` tinyint(1) NOT NULL,
  `creation_sale_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sale_payment_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `current_sale_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_E4696A8EF99747FF` (`sale_payment_id`),
  KEY `IDX_E4696A8E4E8FAB81` (`issuing_shop_id`),
  KEY `IDX_E4696A8EA4F7BCC9` (`issuing_user_id`),
  KEY `IDX_E4696A8EE073CDED` (`current_sale_id`),
  KEY `alias_idx` (`alias`),
  KEY `IDX_E4696A8E6A7F9A03` (`creation_sale_id`),
  CONSTRAINT `FK_E4696A8E4E8FAB81` FOREIGN KEY (`issuing_shop_id`) REFERENCES `shop` (`id`),
  CONSTRAINT `FK_E4696A8E6A7F9A03` FOREIGN KEY (`creation_sale_id`) REFERENCES `sale` (`id`),
  CONSTRAINT `FK_E4696A8EA4F7BCC9` FOREIGN KEY (`issuing_user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_E4696A8EE073CDED` FOREIGN KEY (`current_sale_id`) REFERENCES `sale` (`id`),
  CONSTRAINT `FK_E4696A8EF99747FF` FOREIGN KEY (`sale_payment_id`) REFERENCES `salePayment` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `gift_card`
--


--
-- Table structure for table `gift_card_data_payment`
--

CREATE TABLE `gift_card_data_payment` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `sale_payment_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `gift_card_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_DE01182DF99747FF` (`sale_payment_id`),
  UNIQUE KEY `UNIQ_DE01182D2696A98F` (`gift_card_id`),
  CONSTRAINT `FK_DE01182D2696A98F` FOREIGN KEY (`gift_card_id`) REFERENCES `gift_card` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_DE01182DF99747FF` FOREIGN KEY (`sale_payment_id`) REFERENCES `salePayment` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `gift_card_data_payment`
--


--
-- Table structure for table `groupConfiguration_tax`
--

CREATE TABLE `groupConfiguration_tax` (
  `tax_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `groupConfiguration_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`groupConfiguration_id`,`tax_id`),
  KEY `IDX_15FDC58DA7842C90` (`groupConfiguration_id`),
  KEY `IDX_15FDC58DB2A824D8` (`tax_id`),
  CONSTRAINT `FK_15FDC58DA7842C90` FOREIGN KEY (`groupConfiguration_id`) REFERENCES `group_configuration` (`id`),
  CONSTRAINT `FK_15FDC58DB2A824D8` FOREIGN KEY (`tax_id`) REFERENCES `tax` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `groupConfiguration_tax`
--


--
-- Table structure for table `groupLabel`
--

CREATE TABLE `groupLabel` (
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `label_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `is_default_label` tinyint(1) NOT NULL,
  PRIMARY KEY (`group_id`,`label_id`),
  KEY `IDX_BB195487FE54D947` (`group_id`),
  KEY `IDX_BB19548733B92F39` (`label_id`),
  CONSTRAINT `FK_BB19548733B92F39` FOREIGN KEY (`label_id`) REFERENCES `label` (`id`),
  CONSTRAINT `FK_BB195487FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `groupLabel`
--


--
-- Table structure for table `groupcc`
--

CREATE TABLE `groupcc` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `datecreation` datetime NOT NULL,
  `sufix` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `cif` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `zip` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `profile_description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `website` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `telephone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeProvince_id` int DEFAULT NULL,
  `typeStatus_id` int DEFAULT NULL,
  `group_configuration_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `group_website_template_configuration_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `subdomain` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `domain` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name_clacclac` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_1C8ED13B8C42D435` (`group_configuration_id`),
  UNIQUE KEY `UNIQ_1C8ED13BA59C659F` (`group_website_template_configuration_id`),
  KEY `IDX_1C8ED13B1192B8C0` (`typeProvince_id`),
  KEY `IDX_1C8ED13BA39E082` (`typeStatus_id`),
  CONSTRAINT `FK_1C8ED13B1192B8C0` FOREIGN KEY (`typeProvince_id`) REFERENCES `typeProvinces` (`id`),
  CONSTRAINT `FK_1C8ED13B8C42D435` FOREIGN KEY (`group_configuration_id`) REFERENCES `group_configuration` (`id`),
  CONSTRAINT `FK_1C8ED13BA39E082` FOREIGN KEY (`typeStatus_id`) REFERENCES `typeStatus` (`id`),
  CONSTRAINT `FK_1C8ED13BA59C659F` FOREIGN KEY (`group_website_template_configuration_id`) REFERENCES `websiteTemplateConfig` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `groupcc`
--


--
-- Table structure for table `incidence`
--

CREATE TABLE `incidence` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shop_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `customer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `date_collection` datetime DEFAULT NULL,
  `alias` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `barcode` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `userCreation_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `userCollection_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeIncidence_id` int NOT NULL,
  `typeIncidenceStatus_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_17060417FE54D947` (`group_id`),
  KEY `IDX_170604174D16C4DD` (`shop_id`),
  KEY `IDX_17060417764F1FD9` (`userCreation_id`),
  KEY `IDX_1706041738A003A3` (`userCollection_id`),
  KEY `IDX_17060417FFB2AE74` (`typeIncidence_id`),
  KEY `IDX_17060417F53CB60E` (`typeIncidenceStatus_id`),
  KEY `IDX_170604179395C3F3` (`customer_id`),
  KEY `alias_idx` (`alias`),
  CONSTRAINT `FK_1706041738A003A3` FOREIGN KEY (`userCollection_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_170604174D16C4DD` FOREIGN KEY (`shop_id`) REFERENCES `shop` (`id`),
  CONSTRAINT `FK_17060417764F1FD9` FOREIGN KEY (`userCreation_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_170604179395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`),
  CONSTRAINT `FK_17060417F53CB60E` FOREIGN KEY (`typeIncidenceStatus_id`) REFERENCES `typeIncidenceStatus` (`id`),
  CONSTRAINT `FK_17060417FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`),
  CONSTRAINT `FK_17060417FFB2AE74` FOREIGN KEY (`typeIncidence_id`) REFERENCES `typeIncidence` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `incidence`
--


--
-- Table structure for table `incidenceElement`
--

CREATE TABLE `incidenceElement` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `incidence_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `stock_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_F59B1D75F22710E3` (`incidence_id`),
  KEY `IDX_F59B1D75DCD6110` (`stock_id`),
  CONSTRAINT `FK_F59B1D75DCD6110` FOREIGN KEY (`stock_id`) REFERENCES `stock` (`id`),
  CONSTRAINT `FK_F59B1D75F22710E3` FOREIGN KEY (`incidence_id`) REFERENCES `incidence` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `incidenceElement`
--


--
-- Table structure for table `info`
--

CREATE TABLE `info` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `discount_label` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `discount_amount` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `discount_rate` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `info`
--


--
-- Table structure for table `infoIcon`
--

CREATE TABLE `infoIcon` (
  `id` int NOT NULL AUTO_INCREMENT,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `infoIcon`
--

INSERT INTO `infoIcon` VALUES (1,'glyphicon glyphicon-user'),(2,'glyphicon glyphicon-ok'),(3,'glyphicon glyphicon-flag'),(4,'glyphicon glyphicon-map-marker'),(5,'glyphicon glyphicon-tint'),(6,'glyphicon glyphicon-question-sign'),(7,'glyphicon glyphicon-info-sign'),(8,'glyphicon glyphicon-home'),(9,'glyphicon glyphicon-time'),(10,'glyphicon glyphicon-leaf'),(11,'glyphicon glyphicon-eye-open'),(12,'glyphicon glyphicon-comment'),(13,'fa fa-gift'),(14,'glyphicon glyphicon-bullhorn'),(15,'glyphicon glyphicon-bell'),(16,'glyphicon glyphicon-heart-empty'),(17,'glyphicon glyphicon-flash'),(18,'fa fa-globe'),(19,'fa fa-shopping-cart'),(20,'fa fa-truck'),(21,'fa fa-rocket'),(22,'fa fa-paper-plane'),(23,'fa fa-star'),(24,'fa fa-trophy'),(25,'fa fa-whatsapp');

--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `creator_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `dealer_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `company_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `date_creation` datetime NOT NULL,
  `date_invoiced` datetime DEFAULT NULL,
  `date_payed` datetime DEFAULT NULL,
  `code_invoice` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `alias` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `total` decimal(14,2) DEFAULT NULL,
  `totalCustom` decimal(14,2) DEFAULT NULL,
  `discount` decimal(14,2) DEFAULT NULL,
  `articles` int DEFAULT NULL,
  `stocks` int DEFAULT NULL,
  `payment_description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type_payment` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `days_payment` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `bank_account_description_dealer` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `bank_account_number_dealer` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `bank_account_description_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `bank_account_number_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `typeStatusInvoice_id` int NOT NULL,
  `is_total_manual` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_90651744FE54D947` (`group_id`),
  KEY `IDX_9065174461220EA6` (`creator_id`),
  KEY `IDX_90651744249E6EA1` (`dealer_id`),
  KEY `IDX_90651744979B1AD6` (`company_id`),
  KEY `IDX_906517443E0DDB94` (`typeStatusInvoice_id`),
  KEY `alias_idx` (`alias`),
  KEY `codeInvoice_idx` (`code_invoice`),
  KEY `dateCreation_idx` (`date_creation`),
  KEY `dateInvoiced_idx` (`date_invoiced`),
  KEY `datePayed_idx` (`date_payed`),
  CONSTRAINT `FK_90651744249E6EA1` FOREIGN KEY (`dealer_id`) REFERENCES `dealer` (`id`),
  CONSTRAINT `FK_906517443E0DDB94` FOREIGN KEY (`typeStatusInvoice_id`) REFERENCES `typeStatusInvoice` (`id`),
  CONSTRAINT `FK_9065174461220EA6` FOREIGN KEY (`creator_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_90651744979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`),
  CONSTRAINT `FK_90651744FE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupcc` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `invoice`
--


--
-- Table structure for table `invoiceElement`
--

CREATE TABLE `invoiceElement` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `invoice_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `reception_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_CCF81D752989F1FD` (`invoice_id`),
  KEY `IDX_CCF81D757C14DF52` (`reception_id`),
  KEY `createAt_idx` (`created_at`),
  CONSTRAINT `FK_CCF81D752989F1FD` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`id`),
  CONSTRAINT `FK_CCF81D757C14DF52` FOREIGN KEY (`reception_id`) REFERENCES `receptions` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `invoiceElement`
--


--
-- Table structure for table `label`
--

CREATE TABLE `label` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `filename` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typeLabel_id` int DEFAULT NULL,
  `size_of_label` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `typePrinterSuggestion_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_EA750E896A6C3E7` (`typeLabel_id`),
  KEY `IDX_EA750E868AE1448` (`typePrinterSuggestion_id`),
  CONSTRAINT `FK_EA750E868AE1448` FOREIGN KEY (`typePrinterSuggestion_id`) REFERENCES `typePrinterSuggestion` (`id`),
  CONSTRAINT `FK_EA750E896A6C3E7` FOREIGN KEY (`typeLabel_id`) REFERENCES `typeLabel` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `label`
--

INSERT INTO `label` VALUES ('1','Caja - OPTIMIZADA PARA A4 4X10','11_df8fd19238a0f69f4e35af8890c1b61e.jpg',1,'52,5 x 29,7 mm',3),('10','Exposición Marketing- OPTIMIZADA PARA A4 5X13','11_ab2b85bcd1778b5f32aa8b03979cc5a5.png',2,'38.1 X 21,2 mm',1),('11','Stock pequeño-OPTIMIZADA PARA A4 5X13','11_0ffdf0239c9f58a2ffa91790c8d39e44.jpg',1,'38.1 X 21,2 mm',1),('12','Etiqueta caja talla destacada - OPTIMIZADA PARA A4 3X8 -M (4-3) AJUSTAR','11_74c8475dc4de6ecf4df818134da21579.jpg',1,'70 x 37 mm',3),('13','EXPOSICIÓN PVP OPTIMIZADA PARA A4 4X10 (3-5) NA)','11_9c6fc9247e5e438907b2c60b55865f59.jpg',2,'52,5 x 29,7 mm',3),('14','Stock pequeño marca- OPTIMIZADA PARA A4 4X10(ADAPTABLE)','11_feac46855a4d6acb220c357cd848b94c.jpg',1,'52,5 x 29,7 mm',1),('15','Caja y localizador sin color- OPTIMIZADA PARA A4 -3X6 (2-7)','11_5dcd21ccab0d3c087b3e6bbb7762948b.jpg',1,'70 X 35 mm',1),('16','Etiqueta triple invertida','11_9cc966e40b8099ffc0ce070341124e0a.jpg',1,'80 X 60 mm',2),('17','Etiqueta navete','11_13b4d8f5d5cd459bf882da632713401e.jpg',1,'',1),('18','Exposición Marketing - Sin redondeo- OPTIMIZADA PARA A4 5X13','11_d4f328bb0f23d622b8eac869f69e367a.png',2,'38.1 X 21,2 mm',1),('19','Exposición rebajas- OPTIMIZADA PARA A4 5X13','11_d05a173573d22108e6add65cb3cca641.jpg',2,'38.1 X 21,2 mm',1),('2','Exposición Interior- A4 4x10 ( Sin Márgenes)','11_fddf0aa939331ee330f15656e5e9de9b.jpg',2,'52,5 x 29,7 mm',3),('20','Exposición PVP Pequeña- OPTIMIZADA PARA A4 5X13','11_3d0640520238aff37882e606e2778ac4.jpg',2,'38.1 X 21,2 mm',1),('21','Talla destacada con Descripción- OPTIMIZADA PARA A4 3X8 ( 2-4)-(Ajustar)','https://clacclac-es.s3.eu-west-1.amazonaws.com/LABELS/2024/04/L_ce0a43c6d4d1453eeae7b8d78bb3f50b.jpg',1,'70 x 37 mm',3),('22','EXPOSICIÓN CON DESCRIPCIÓN Y ATRIBUTO EXTRA Nº 5-','11_6967d538113378b1abe02baa09cc416e.jpg',2,'38.1 x 21.2 mm',1),('23','Stock Pequeño con Atributo Extra nº5 y Descripción- OPTIMIZADA PARA A4 5X13 (1-2 )-(NA)','11_61843fdd217ee4b264ae057b9d52c0bc.jpg',1,'38.1 X 21.2 mm',1),('24','Stock con Fotografía y Atributos Extra- OPTIMIZADA PARA A4 2X7 ( 2-6 )','11_6b87244d1176a8a9836f6b5fa27e6a6e.jpg',1,'105 X 42.4 mm',1),('25','Caja (Temporada/Marca) - OPTIMIZADA PARA A4 4X10','11_29b58991433794e8b5526a40bc64d58c.jpg',1,'52,5 x 29,7 mm',1),('26','Stock doble  2x6 ( 0-0 NA)','11_9f461170f20f2ce6f5245869a853c02b.jpg',1,'105 X 49 mm',1),('27','Stock con fotografía simple - OPTIMIZADA PARA A4 - 2X6 (2-3) NA','11_6f7a024603956c59591c6b3060861ddd.jpg',1,'97 x 42.4 mm',1),('28','Exposición PVP Pequeña- Marca- OPTIMIZADA PARA A4 4X10','11_08d4ab6169adea4d1bc2f16beff17f63.jpg',2,'52,5 x 29,7 mm',1),('29','Etiqueta de stock (Categoría/Subcategoría) - OPTIMIZADA PARA A4 4X10','11_7caca1bf2008a1424059c314b1be851f.png',1,'52,5 x 29,7 mm',1),('3','Con Logo Marca','11_88c3d8b66b8724dbdaa37a562ec8ca1d.png',3,'',1),('30','Etiqueta caja talla destacada - OPTIMIZADA PARA A4 4X11','11_d5f0fd2fcdf948011eb473e3913b3630.jpg',1,'52,5 x 25,4 mm',1),('31','Exposición precio por tallas - OPTIMIZADA PARA A4 4X10','11_62af36ed73ed3da323d1755f40ef3678.png',2,'52,5 x 29,7 mm',1),('32','Exposición PVP Menor- OPTIMIZADA PARA A4 5X13','11_367a479ddc57f6b934e6b7783ee60551.jpg',2,'38.1 X 21,2 mm',1),('33','Caja Nº Orden- OPTIMIZADA PARA A4 4X10','11_5ef2991a21f2536db2f6d6b80c6180e7.jpg',1,'52,5 x 29,7 mm',1),('34','Vertical de stock - OPTIMIZADA PARA 17x54mm','11_7473d0275139116a8875179a1628032d.jpg',1,'17 x 54 mm',3),('35','Etiqueta triple invertida 2.0','11_ab7c7427b32ff898ec8bd29c17fe7967.jpeg',1,'80 x 60 mm',2),('36','Exposición PVP Menor SIN FOTO- OPTIMIZADA PARA A4 5X13','11_92f99d4945d3713676a8a4d38a177619.jpg',2,'38.1 X 21,2 mm',1),('37','Exposición Serie-Tallas- OPTIMIZADA PARA A4 5X13','11_5cf92093e68e41f8b38b3c4d45b057cc.jpg',2,'38.1 X 21,2 mm',1),('38','Exposición Pequeña Sin Marca - OPTIMIZADA PARA A4 4X11','11_9a82f0032f65d2dde3e8f4daa18eaf0a.png',2,'52 x 25 mm',1),('39','Caja rebajas precio Antes y Despues- OPTIMIZADA PARA 4X10','11_3909fe506a11b5cd60c37b875e68ded5.png',1,'52,5 x 29,7 mm',1),('4','Con Logo de Tienda','11_e1656ca6f8ad11d36ecb9acbd1a3655e.png',3,'',1),('40','Stock pequeño marca- Etiquetadora 70x30','11_b8d7f79bc2ffc15184ab49e0a8a89a94.jpg',1,'70 X 30 mm',2),('41','Articulo con marca y orden - OPTIMIZADA A4 3X8','11_e568d9189a5bb546b07931edc6f4b4cf.jpg',2,'70 x 37,1 mm',1),('42','Articulo simple proveedor - Etiquetadora 48x26','11_d8f64d549a9ac04b4efd0e5039fe33d9.png',2,'48x26mm',2),('43','Articulo precio recomendado proveedor - Etiquetadora 48x26','11_c54242100ea367414ff6b4bfcc1c8feb.png',2,'48x26mm',2),('44','Stock almacén - Etiquetadora 45x45','11_4c89dbdb479a5eec9f43c8119ff348dd.jpg',1,'45 X 45 mm',2),('45','Stock almacén con Precio - Etiquetadora 45x45','11_f21336036d67c5c1635345f10b1321d0.jpg',1,'45 X 45 mm',2),('46','Stock con fotografía simple (Alias/Orden) - OPTIMIZADA PARA A4 - 2X6 (2-3) NA','11_b2d2314f71570c50dea7f417296c7163.jpg',1,'97 x 42.4 mm',1),('47','Caja y Alias de Localizador SIN PVP OPTIMIZADA PARA  A4 3x6','11_0659f3acd3fb0849b39e4041046ad6af.jpg',1,'',1),('48','Exposición rebajas PRECIO - OPTIMIZADA PARA A4 5X13- MÁRGENES (4-2) MARGEN A4 MAYOR ARRIBA- PREDETERMINADO','11_5074df5313b0d16a9ff57cb19272dac2.jpg',2,'38.1 X 21,2 mm',1),('49','Exposición rebajas PRECIO - OPTIMIZADA PARA A4 4X10- MARGENES (3-5) PREDETERMINADO','11_58845ec91bbab515f52706e56a5f13ce.jpg',2,'52,5 x 29,7 mm',1),('5','Con Fotografía de Artículo','11_b170a210e25b96e0fe63de3123b4a205.png',3,'',1),('50','CAJA REFERENCIA OPTIMIZADA PARA A4 4X10 M(0-5)','11_f03bcc39603a2b25f829a5be2f8a192f.jpg',1,'52,5 x 29,7 mm',1),('51','Caja - OPTIMIZADA PARA ETIQUETADORA M(0-2)','11_a1b514c8549521afc624338122a8f14a.jpg',1,'38 x 25 mm',2),('52','Caja Nº Orden- OPTIMIZADA PARA ETIQUETADORA M(0-2)','11_5361250c1dda63b5ae9a9639a6fa528a.jpg',1,'38 x 25 mm',2),('53','REFERENCIA - OPTIMIZADA PARA A4 4X11 M(1-4) NO AJUSTAR (48,5 x 25,4 mm)','11_fc4df25f8558df9f9106a55508502cb5.jpg',1,'48,5 x 25,4 mm',1),('54','REFERENCIA - ETIQUETADORA 43 x 30 mm','11_290bc6438bc2f9b50769656859b28b43.jpg',1,'43 x 30 mm',2),('55','TRENDICO - PVP Y REBAJAS OPTIMIZADA PARA A4 4X11 M(1-4) NO AJUSTAR (48,5 X 25,4 MM)','11_65c6446dcfb4928bcd3fe3bf39c4adea.jpg',2,'48,5 x 25,4 mm',1),('56','TRENDICO - PVP Y REBAJAS OPTIMIZADA PARA ETIQUETADORA (43 x 30 mm)','11_04e171df689d16f6cfe1d99daae232c5.jpg',2,'43 x 30 mm',2),('57','CÓDIGO PVP Y REBAJAS OPTIMIZADA PARA A4 4X6 NO ADHESIVAS ( CREAR IMPRESORA A4 DE ESTE TAMAÑO 4X6)','11_1d7d42b4b491ab3913980c085cb207a1.jpg',3,'',1),('58','TRENDICO - SIN PVP - OPTIMIZADA PARA A4 4X11','11_d2209485a556b7d652d817655c3b3c77.jpg',1,'48,5 x 25,4 mm',1),('59','TRENDICO - SIN PVP - OPTIMIZADA PARA ETIQUETADORA','11_82ae069a224362e91b8ccf77296ac848.jpg',1,'43 x 30 mm',2),('6','Simple','11_ab4bbe259d5d151cd3c5ed87ff1f3e11.png',3,'',1),('60','TRENDICO PVP Y REBAJAS OPTIMIZADA PARA A4 4X11 M(1-2) NO AJUSTAR (48,5 x 25,4 mm)','11_7e990d5e33f283030c210f35d94d8711.jpg',1,'48,5 x 25,4 mm',1),('61','TRENDICO PVP Y REBAJAS OPTIMIZADA PARA ETIQUETADORA (43 x 30 mm)','11_318d4a82fcbf6ac3fba06f9142a5c1ae.jpg',1,'43 x 30 mm',2),('62','TRENDICO - ETIQUETA ESPECIAL PVP Y REBAJAS OPTIMIZADA PARA ETIQUETADORA( 30X70 mm)','11_28a027c2f7d1aefbd436902d1f7de799.jpg',1,'30 x 70 mm',2),('63','ETIQUETA DE STOCK (CATEGORÍA) - OPTIMIZADA PARA A4 4X10','11_308f1fdf338fcefee30671622ffc4874.png',1,'52,5 x 29,7 mm',1),('64','TRENDICO 2 - PVP Y REBAJAS OPTIMIZADA PARA IMPRESORRA A4 4X11 M(1-2) NO AJUSTAR (48,5 x 25,4 mm)','11_2b72207d7d2fab7cdf294244173cf527.png',2,'48,5 x 25,4 mm',1),('65','TRENDICO 2 - PVP Y REBAJAS OPTIMIZADA PARA ETIQUETADORA 43X30 mm','11_b51cb9b8762e29fd38541e5ee8373cc5.png',2,'43 x 30 mm',2),('66','Stock pequeño-SIN PVP-OPTIMIZADA PARA A4 5X13','11_60126361d0859ddc45146e67b4e2f784.png',1,'38.1 X 21,2 mm',1),('67','ETIQUETA VERTICAL TRIPLE PARA A4 3X4 (60 x 72 mm) M 0-0 PREDET. MARGENES INVERTIDOS','11_972dc3d43e6ddb0e2bbf064220f0ee47.png',1,'60 x 72 mm',1),('68','TRENDICO STOCK HORIZONTAL - PVP Y REBAJAS OPTIMIZADA PARA ETIQUETADORA (70X30 mm)','11_f9ab37cc28b67a54d2682696c96c8dd7.png',1,'70 x 30 mm',2),('69','TRENDICO STOCK VERTICAL - PVP Y REBAJAS OPTIMIZADA PARA ETIQUETADORA (30X70 mm)','11_5b44ee21cadd9304355a064d1075466e.png',1,'30 x 70 mm',2),('7','Simple Reducida','11_667e454d64d153e5eb9a6c210901ea84.png',3,'',1),('70','STOCK CON FOTOGRAFÍA SIMPLE V.2 - OPTIMIZADA PARA A4 - 2X6 (0-2 AJUSTAR PAPEL) (97 x 42.4 mm)','11_29575f16e6d2819f0f2fbb32ef8132fd.jpg',1,'97 x 42.4 mm',1),('71','TRENDICO - REFERENCIA Y SIN PVP - OPTIMIZADA PARA ETIQUETADORA (43 x 30 mm)','11_6594e71b07a95c73df074b22ce172d15.jpg',1,'43 x 30 mm',2),('72','TRENDICO 3 - ATRB.1 - PVP Y REBAJAS OPTIMIZADA PARA ETIQUETADORA 43X30 mm','',2,'43 x 30 mm',2),('8','Caja y Alias de Localizador OPTIMIZADA PARA  A4 3x6','11_9de420a84b20d0cb8d1999b37142c5d0.jpg',1,'70 x 35 mm',1),('9','Etiqueta triple- OPTIMIZADA PARA ETIQUETADORA','11_1b9f9bd7b8791f44cc163ef99aa201b9.jpg',1,'80 X 60 mm',2);

--
