File: /home/semanacmab/backup.sql
-- MySQL dump 10.13 Distrib 5.7.35, for Linux (x86_64)
--
-- Host: localhost Database: semanacm_incripciones2021
-- ------------------------------------------------------
-- Server version 5.7.35
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `2021acompanantes`
--
DROP TABLE IF EXISTS `2021acompanantes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `2021acompanantes` (
`id_acompanantes` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_inscripcion_pral` int(10) unsigned DEFAULT NULL,
`id_inscripcion_acompanante` int(10) unsigned DEFAULT NULL,
`relacion_padre` tinyint(3) unsigned DEFAULT NULL COMMENT '1 => invitado\n2 => acompanate',
`fecha_alta` datetime DEFAULT NULL,
PRIMARY KEY (`id_acompanantes`),
KEY `fk_acompanantes_2_idx` (`id_inscripcion_acompanante`),
KEY `fk_acompanantes_1_idx` (`id_inscripcion_pral`),
CONSTRAINT `2021acompanantes_ibfk_1` FOREIGN KEY (`id_inscripcion_pral`) REFERENCES `2021inscripciones` (`id_inscripciones`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=255 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `2021acompanantes`
--
LOCK TABLES `2021acompanantes` WRITE;
/*!40000 ALTER TABLE `2021acompanantes` DISABLE KEYS */;
INSERT INTO `2021acompanantes` VALUES (95,54,55,2,'2021-09-09 12:40:11'),(96,54,55,2,'2021-09-09 12:40:12'),(97,57,58,2,'2021-09-09 12:41:55'),(98,57,58,2,'2021-09-09 12:41:55'),(99,60,61,2,'2021-09-09 12:55:43'),(100,62,63,2,'2021-09-09 13:02:28'),(101,62,63,2,'2021-09-09 13:02:28'),(102,66,67,2,'2021-09-09 13:17:26'),(103,66,67,2,'2021-09-09 13:17:26'),(104,69,70,2,'2021-09-09 13:30:41'),(105,69,70,2,'2021-09-09 13:30:41'),(106,71,72,2,'2021-09-09 13:31:53'),(107,71,72,2,'2021-09-09 13:31:53'),(108,73,74,2,'2021-09-09 13:33:12'),(109,73,74,2,'2021-09-09 13:33:12'),(110,75,76,2,'2021-09-09 13:33:57'),(111,75,76,2,'2021-09-09 13:33:57'),(112,79,80,2,'2021-09-09 13:46:36'),(113,79,80,2,'2021-09-09 13:46:36'),(114,81,82,2,'2021-09-09 13:47:24'),(115,81,82,2,'2021-09-09 13:47:25'),(116,83,84,2,'2021-09-09 13:54:56'),(117,83,84,2,'2021-09-09 13:54:57'),(118,85,86,2,'2021-09-09 13:55:55'),(119,85,86,2,'2021-09-09 13:55:55'),(120,92,93,2,'2021-09-09 14:41:27'),(121,92,93,2,'2021-09-09 14:41:27'),(122,94,95,2,'2021-09-09 14:50:18'),(123,94,95,2,'2021-09-09 14:50:19'),(124,96,97,2,'2021-09-09 15:43:35'),(125,96,97,2,'2021-09-09 15:43:35'),(126,102,103,2,'2021-09-09 17:02:08'),(127,102,103,2,'2021-09-09 17:02:08'),(128,104,105,2,'2021-09-09 17:03:54'),(129,104,105,2,'2021-09-09 17:03:54'),(130,106,107,2,'2021-09-09 18:01:03'),(131,106,107,2,'2021-09-09 18:01:03'),(132,108,109,2,'2021-09-09 18:14:54'),(133,108,109,2,'2021-09-09 18:14:54'),(134,110,111,2,'2021-09-09 18:21:13'),(135,110,111,2,'2021-09-09 18:21:14'),(136,115,116,2,'2021-09-10 07:58:05'),(137,115,116,2,'2021-09-10 07:58:06'),(138,117,118,2,'2021-09-10 08:20:04'),(139,117,118,2,'2021-09-10 08:20:04'),(140,120,121,2,'2021-09-10 09:42:25'),(141,120,121,2,'2021-09-10 09:42:25'),(142,123,124,2,'2021-09-10 09:46:52'),(143,123,124,2,'2021-09-10 09:46:53'),(144,125,126,2,'2021-09-10 10:12:41'),(145,125,126,2,'2021-09-10 10:12:41'),(148,133,134,2,'2021-09-10 13:20:43'),(149,133,134,2,'2021-09-10 13:20:43'),(150,135,136,2,'2021-09-10 17:32:40'),(151,135,136,2,'2021-09-10 17:32:40'),(152,140,141,2,'2021-09-13 09:29:12'),(153,140,141,2,'2021-09-13 09:29:12'),(154,142,143,2,'2021-09-13 10:35:14'),(155,142,143,2,'2021-09-13 10:35:14'),(156,146,147,2,'2021-09-13 13:00:42'),(157,146,147,2,'2021-09-13 13:03:01'),(158,150,151,2,'2021-09-13 13:58:23'),(159,150,151,2,'2021-09-13 13:58:23'),(160,156,157,2,'2021-09-14 09:37:46'),(161,156,157,2,'2021-09-14 09:37:46'),(162,159,160,2,'2021-09-14 12:59:08'),(163,159,160,2,'2021-09-14 12:59:08'),(193,248,249,2,'2021-09-14 13:19:50'),(194,248,250,2,'2021-09-14 13:19:50'),(195,248,251,2,'2021-09-14 13:19:50'),(196,248,249,2,'2021-09-14 13:21:38'),(197,248,250,2,'2021-09-14 13:21:38'),(198,248,251,2,'2021-09-14 13:21:38'),(200,254,255,2,'2021-09-14 18:26:15'),(201,254,255,2,'2021-09-14 18:26:15'),(202,256,257,2,'2021-09-15 11:33:59'),(203,256,257,2,'2021-09-15 11:33:59'),(204,261,262,2,'2021-09-15 13:25:06'),(205,261,262,2,'2021-09-15 13:25:06'),(206,267,268,2,'2021-09-16 11:37:54'),(207,267,268,2,'2021-09-16 11:37:55'),(208,269,270,2,'2021-09-16 11:39:03'),(209,269,270,2,'2021-09-16 11:39:03'),(210,288,289,2,'2021-09-17 09:48:14'),(211,288,289,2,'2021-09-17 09:48:14'),(212,291,292,2,'2021-09-17 10:20:21'),(213,291,292,2,'2021-09-17 10:20:21'),(214,293,294,2,'2021-09-17 10:29:46'),(215,293,294,2,'2021-09-17 10:29:46'),(216,293,294,2,'2021-09-17 10:30:47'),(217,296,297,2,'2021-09-17 15:09:58'),(218,296,297,2,'2021-09-17 15:09:58'),(224,365,366,2,'2021-09-21 12:08:40'),(225,365,366,2,'2021-09-21 12:08:40'),(226,367,368,2,'2021-09-21 12:59:57'),(227,367,368,2,'2021-09-21 12:59:57'),(228,369,370,2,'2021-09-21 13:02:24'),(229,369,370,2,'2021-09-21 13:02:25'),(230,371,372,2,'2021-09-21 16:50:59'),(231,371,372,2,'2021-09-21 16:50:59'),(232,373,374,2,'2021-09-22 11:03:45'),(233,373,374,2,'2021-09-22 11:05:34'),(235,379,380,2,'2021-09-22 16:15:13'),(236,379,380,2,'2021-09-22 16:15:13'),(237,382,383,2,'2021-09-23 09:12:22'),(238,382,383,2,'2021-09-23 09:12:22'),(239,384,385,2,'2021-09-23 09:23:25'),(240,384,385,2,'2021-09-23 09:23:25'),(241,386,387,2,'2021-09-23 09:40:40'),(242,386,387,2,'2021-09-23 09:40:40'),(243,390,391,2,'2021-09-23 10:24:58'),(244,390,391,2,'2021-09-23 10:24:58'),(245,392,393,2,'2021-09-23 10:26:54'),(246,392,393,2,'2021-09-23 10:26:54'),(247,395,396,2,'2021-09-23 10:50:05'),(248,395,396,2,'2021-09-23 10:50:05'),(249,397,398,2,'2021-09-23 10:54:44'),(250,397,398,2,'2021-09-23 10:54:44'),(251,399,400,2,'2021-09-23 11:39:40'),(252,399,400,2,'2021-09-23 11:39:40'),(253,401,402,2,'2021-09-23 11:45:43'),(254,401,402,2,'2021-09-23 11:45:44');
/*!40000 ALTER TABLE `2021acompanantes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `2021inscripciones`
--
DROP TABLE IF EXISTS `2021inscripciones`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `2021inscripciones` (
`id_inscripciones` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nombre` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`apellido1` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`apellido2` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`empresa` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
`cargo` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
`direccion` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`codigo_postal` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`ciudad` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`pais` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`telefono` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`email` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
`dni` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`foro1` varchar(5) COLLATE utf8_bin DEFAULT NULL,
`foro2` varchar(5) COLLATE utf8_bin DEFAULT NULL,
`acto_social` tinyint(4) DEFAULT NULL,
`id_padre` int(10) unsigned DEFAULT NULL COMMENT 'null => no tiene padre (inscripción principal)\n!null => Sin inscritos invitados o acompanates. Indica cual es la inscripción padre',
`relacion_padre` int(10) unsigned DEFAULT NULL COMMENT 'null => No tiene padre\n1 => es un invitado del padre (ver id_padre)\n2 => es un acompañante del padre (ver id_padre)',
`tipo_inscripcion` smallint(5) unsigned DEFAULT NULL COMMENT '1 -> Mediador colegiado\n2 -> Mediador no colegiado\n3 -> Profesional de compañis aseguradora\n4 -> Otro profesional\n5 -> Invitado\n6 -> Acompañante',
`fecha_alta` datetime DEFAULT NULL,
`ha_asistido` smallint(5) unsigned DEFAULT '0',
`fecha_asistencia` datetime DEFAULT NULL COMMENT 'Fechas_hora en que se ha identificado en el registro de asistencia al foro (app)',
`fecha_asistencia_cocktel` datetime DEFAULT NULL COMMENT 'Fechas_hora en que se ha identificado en el registro de asistencia al cocktel (app)',
`empresa_inivitacion` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`tipo_registro` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT 'web, empresa, vip',
`fecha_envio_mail` datetime DEFAULT NULL,
`codigo_qr` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`fecha_pendiente` datetime DEFAULT NULL,
`con_factura` smallint(5) unsigned DEFAULT '0',
`importe_factura` float(9,2) DEFAULT '0.00',
`codigo_autorizacion` varchar(45) COLLATE utf8_bin DEFAULT NULL COMMENT 'Código de autorización devuelto por el TPV',
`tipo_empresa` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`codigo_reserva` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'código de reserva',
`reservado` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Asiento reservado?',
`numero_asiento` varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '',
PRIMARY KEY (`id_inscripciones`),
UNIQUE KEY `dni_UNIQUE` (`dni`),
KEY `index4` (`codigo_qr`)
) ENGINE=InnoDB AUTO_INCREMENT=403 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `2021inscripciones`
--
LOCK TABLES `2021inscripciones` WRITE;
/*!40000 ALTER TABLE `2021inscripciones` DISABLE KEYS */;
INSERT INTO `2021inscripciones` VALUES (54,'Elisabeth','Barange','Corachan','CofbServeis','Resposable seguros','Muntaner 470 3-1','08006','Barcelona','españa','696763198','ebarange@cofbserveis.net','46115166M','0','0',0,NULL,NULL,1,'2021-09-09 12:40:11',0,NULL,NULL,NULL,NULL,'2021-09-09 12:40:12','c616ed003f1d09b52989fb603d56c57e',NULL,0,0.00,'','','',0,'\'\''),(55,'Agustin','Ortega','Lozano','Cofbserveis','Gerente','Girona 64-66','08009','Barcelona','','932440720','aortega@cofbserveis.net','37745213M','0','0',0,54,2,6,'2021-09-09 12:40:11',0,NULL,NULL,NULL,'web','2021-09-09 12:40:12','2c06c76d60d89e79383bd512260d69dc',NULL,0,0.00,'','','',0,'\'\''),(56,'XAVI','CAMPMANY','MUÑOZ','NEW RISK','DIRECTOR GENERAL','Avda. Via augusta, 15, planta 3ª','08174','Sant Cugat','','935571033','xcampmany@newrisk.es','46623016S','0','0',0,NULL,NULL,1,'2021-09-09 12:41:22',0,NULL,NULL,NULL,NULL,'2021-09-09 12:41:22','32e415525be4130a32af345d80f1e0b4',NULL,0,0.00,'','CORRDURIA','',0,'\'\''),(57,'Josep','Romagosa','Lluch','ROMACOBER','ADMINISTRADOR','Pere IV, 363, primera planta local 16','08020','BARCELONA','','647327612','jromagosa@romacober.com','46132444X','0','0',0,NULL,NULL,1,'2021-09-09 12:41:55',0,NULL,NULL,NULL,NULL,'2021-09-09 12:41:55','1e536f698c6cb7b77c6e411b0ee77882',NULL,0,0.00,'','ROMACOBER','',0,'\'\''),(58,'SARA','TORTOSA','GIL','ROMACOBER','GESTORA','Pere IV, 363. primaera planta, local 16','08020','BARCELONA','','934707788','stortosa@romacober.com','38829524G','0','0',0,57,2,6,'2021-09-09 12:41:55',0,NULL,NULL,NULL,'web','2021-09-09 12:41:55','f6690755a6ebce9c88029a151827dee3',NULL,0,0.00,'','','',0,'\'\''),(59,'Lluís ','Morató ','Prats','','','Font del Remei n/ 36 1-2','08023','Barcelona','España','626933692','lluismoratoprats@gmail.com','46325099V','0','0',0,NULL,NULL,1,'2021-09-09 12:44:45',0,NULL,NULL,NULL,NULL,'2021-09-09 12:44:45','fdd3e823e06666bee0f73e6dbce53521',NULL,0,0.00,'','Agente','',0,'\'\''),(60,'josep','gendra','hom','','','','','','','616950342','gendrajosep@gmail.com','77297389r','0','0',1,NULL,NULL,4,'2021-09-09 12:55:43',0,NULL,NULL,NULL,NULL,NULL,'','2021-09-09 12:55:43',0,120.00,'12550060','','',0,'\'\''),(61,'ingrid','ballesta','farres','','','','','','','616950342','gendrajosep@gmail.com','46054649r','0','0',1,60,2,9,'2021-09-09 12:55:43',0,NULL,NULL,NULL,'web',NULL,'','2021-09-09 12:55:43',0,0.00,'','','',0,'\'\''),(62,'Olivia ','Giménez','Álvarez','Grupo Giménez','','Muntaner 316 1º 1ª','08021','Barcelona','España','934147081','ogimenez@grupogimenez.com','36524263X','0','0',0,NULL,NULL,1,'2021-09-09 13:02:28',0,NULL,NULL,NULL,NULL,'2021-09-09 13:02:28','1f964a975d6afeee9b37c7c617f58a30',NULL,0,0.00,'','Correduría Seguros','',0,'\'\''),(63,'Daniel','Giménez','Holgado','Grupo Giménez','','Muntaner 316 1 1','08021','Barcelona','','934147081','dgimenez@grupogimenez.com','46216811J','0','0',0,62,2,6,'2021-09-09 13:02:28',0,NULL,NULL,NULL,'web','2021-09-09 13:02:28','8b371e32ca00806b3ce6b30b75e8fbae',NULL,0,0.00,'','','',0,'\'\''),(64,'JAVIER','FLO','VIDAL RIBAS','ASEDESA','DIRECTOR','TRAV. DE GRACIA 15 2º','08021','BARCELONA','ESPAÑA','648512970','javier.flo@asedesa.es','46231962F','0','0',0,NULL,NULL,1,'2021-09-09 13:03:50',0,NULL,NULL,NULL,NULL,'2021-09-09 13:03:51','21b89ec80b4e06d62d398faa2d839c28',NULL,0,0.00,'','CORREDURIA','',0,'\'\''),(65,'ANTONIO','DEL CASTILLO','AGUILÁ','CONFORT RISK GESTIÓN SL','GERENTE','SICILIA 390 BAJOS 3','08025','BARCELONA','ESPAÑA','667605834','antonio.crg@agencia.axa.es','37745264X','0','0',0,NULL,NULL,1,'2021-09-09 13:07:24',0,NULL,NULL,NULL,NULL,'2021-09-09 13:07:24','e1dead66655f1a047518747cfbb34a58',NULL,0,0.00,'','AGENCIA','',0,'\'\''),(66,'Albert','Parés','Gonzàlez','La Teva Assegurança','Corredor','Avinguda Rabassaires 28, 1a Planta','08100','Mollet del Vallès','Espanya','693101288','albert.pares@asseguranceslta.cat','47814754P','0','0',0,NULL,NULL,1,'2021-09-09 13:17:26',0,NULL,NULL,NULL,NULL,'2021-09-09 13:17:27','4c14720efc18db94d1037333214df561',NULL,0,0.00,'','Corredor individual','',0,'\'\''),(67,'Meritxell','Humbert','Lacruz','','','','','','','620819702','mhumbert@lce-led.com','47716128Y','0','0',0,66,2,6,'2021-09-09 13:17:26',0,NULL,NULL,NULL,'web','2021-09-09 13:17:27','352e80156e408e82b599afff32670097',NULL,0,0.00,'','','',0,'\'\''),(68,'Ramon','Pané','Farré','','','','','','','610 708 635','rpane@vidacaixa.es','40869574T','0','0',1,NULL,NULL,3,'2021-09-09 13:23:40',0,NULL,NULL,NULL,NULL,'2021-09-09 13:29:05','784b8e29f13f39affba73dbb9d9f186b',NULL,0,60.00,'13230068','','',0,'\'\''),(69,'JOAQUIN','LUNA','BRAVO','','','','','','','934085744','jluna@luna-bravo.com','37726931P','0','0',1,NULL,NULL,1,'2021-09-09 13:30:41',0,NULL,NULL,NULL,NULL,'2021-09-09 13:30:41','865fd43b68c12348363b80b5e2775dc6',NULL,0,0.00,'','','',0,'\'\''),(70,'LAURA','LUNA','DIAZ','','','','','','','934085744','lauraluna@luna-bravo.com','46408300G','0','0',1,69,2,6,'2021-09-09 13:30:41',0,NULL,NULL,NULL,'web','2021-09-09 13:30:41','e08188d58d3769d92be9f4ae54356949',NULL,0,0.00,'','','',0,'\'\''),(71,'Joan','Sala','Llargués','','jubilat','','08202','Sabadell','','639882480','joansalallargues@gmail.com','38998014L','0','0',0,NULL,NULL,1,'2021-09-09 13:31:53',0,NULL,NULL,NULL,NULL,'2021-09-09 13:31:53','e899663d54dad6927001eb3bff333c9b',NULL,0,0.00,'','','',0,'\'\''),(72,'Maria Marta','GONZALEZ','SALA','','','','','','','','','39007484L','0','0',0,71,2,6,'2021-09-09 13:31:53',0,NULL,NULL,NULL,'web','2021-09-09 13:31:53','5626851c95b3848231d72af56991d335',NULL,0,0.00,'','','',0,'\'\''),(73,'VANESSA','NAVARRO','LASCORZ','VNL CORREDORIA D\'ASSEGURANCES LASCORZ, S.L.','DIRECCIÓ','C/ ROVELLAT 22, LOC. 2','08950','ESPLUGUES DE LLOBREGAT','ESPANYA','933720127','vanessa@arvlascorz.com','38106176Y','0','0',1,NULL,NULL,1,'2021-09-09 13:33:12',0,NULL,NULL,NULL,NULL,'2021-09-09 13:33:12','83571b7cd54733cb8227fc49ecb0fab6',NULL,0,0.00,'','CORREDORIA','',0,'\'\''),(74,'ARACELI','LASCORZ','ORTEGA','','','','','','','933720127','vanessa@arvlascorz.com','38394937W','0','0',1,73,2,6,'2021-09-09 13:33:12',0,NULL,NULL,NULL,'web','2021-09-09 13:33:12','775c0f2ffbd92ce6b55ec2d8b64b277c',NULL,0,0.00,'','','',0,'\'\''),(75,'LLORENÇ','SERRA','FRONTERA','ASP Corredoria','Gerente','Bon Pastor','08021','Barcelona','España','935511616','lserra@aspcorredoria.cat','35005802D','0','0',1,NULL,NULL,1,'2021-09-09 13:33:57',0,NULL,NULL,NULL,NULL,'2021-09-09 13:33:57','1c2c76f562795bda2e3b416c80484390',NULL,0,0.00,'','Corredoria','',0,'\'\''),(76,'SANDRA','DOMÍNGUEZ','FANDOS','ASP Correduría','Cap de Gestió','Bon Pastor','08021','Barcelona','España','935511616','sdominguez@aspcorredoria.cat','53085287E','0','0',1,75,2,6,'2021-09-09 13:33:57',0,NULL,NULL,NULL,'web','2021-09-09 13:33:58','3065fcf3931c04ee1031ceb9358b792d',NULL,0,0.00,'','','',0,'\'\''),(77,'Francesc','Bartrina','Aulinas','','','C/ Espronceda 143, 4-3','08005','Barcelona','','617374296','fbartrina@auditoriaseguros.com','35082223R','0','0',0,NULL,NULL,1,'2021-09-09 13:34:06',0,NULL,NULL,NULL,NULL,'2021-09-09 13:34:06','17ec61d494729a7db59212c0b57b6cf4',NULL,0,0.00,'','','',0,'\'\''),(78,'ANGEL','PALMA','CABRERA ','BROKER PALMA ','CEO ','C/SANT LLORENÇ Nº67','08201','SABAELL','ESPAÑA ','673844366','angel@brokerpalma.com','47152135L','0','0',0,NULL,NULL,1,'2021-09-09 13:39:54',0,NULL,NULL,NULL,NULL,'2021-09-09 13:39:54','109a68e652d4a2ff68d514c931829ed4',NULL,0,0.00,'','CORREDOR ','',0,'\'\''),(79,'JORDI','ALBAREDA','BOSCH','','','','','','','687760726','jordi@dauder.com','33901197W','0','0',1,NULL,NULL,1,'2021-09-09 13:46:36',0,NULL,NULL,NULL,NULL,'2021-09-09 13:46:36','614dbca874f900622b85cd14741f44c0',NULL,0,0.00,'','','',0,'\'\''),(80,'NURIA','DAUDER','ROS','','','','','','','','nuria@dauder.com','33906918L','0','0',1,79,2,6,'2021-09-09 13:46:36',0,NULL,NULL,NULL,'web','2021-09-09 13:46:36','93a638b2b488e094166242907c5af331',NULL,0,0.00,'','','',0,'\'\''),(81,'Manuel','ALTES ','ESPARZA','Corredor','Titular','Av. Josep Tarradellas, 55, At. 2ª','08029','BARCELONA','España','934102133/640502902','maltesvisconti@gmail.com','46111995P','0','0',0,NULL,NULL,1,'2021-09-09 13:47:24',0,NULL,NULL,NULL,NULL,'2021-09-09 13:47:25','de4647ac748c37f15f427e48e56529f4',NULL,0,0.00,'','Corredor','',0,'\'\''),(82,'Lidia','SOLE','VIDAL','Corredor','','Av. Josep Tarradellas, 55, At. 2ª','08029','BARCELONA','España','934102133','lydiasole@gmail.com','37273175L','0','0',0,81,2,6,'2021-09-09 13:47:24',0,NULL,NULL,NULL,'web','2021-09-09 13:47:25','e68e671fc834c274a04cbb0356feebf9',NULL,0,0.00,'','','',0,'\'\''),(83,'FRANCESC XAVIER','AYALA','VALLESPI','XAVIER AYALA VALLESPI, S.L.U.','GERENTE','RIERA GAVARRA, 73 ','08360','CANET DE MAR - BARCELONA','ESPAÑA','+34615318485','xavier@ayalavallespi.com','38801424X','0','0',1,NULL,NULL,1,'2021-09-09 13:54:56',0,NULL,NULL,NULL,NULL,'2021-09-09 13:54:57','c7b10ad8f9c5fc7a22337c3c613cee49',NULL,0,0.00,'','AGENCIA EXCLUSIVA','',0,'\'\''),(84,'FRANCISCO JOSE ','GARCIA','GARCIA','AUTONOMO','GERENTE','JAUME ISERN, 23','08302','MATARO','ESPAÑA','627910963','franciscojgarciagarcia@gmail.com','38797944A','0','0',0,83,2,6,'2021-09-09 13:54:56',0,NULL,NULL,NULL,'web','2021-09-09 13:54:57','c9fcbfe7f40fb92a2fbe971c5e741a4e',NULL,0,0.00,'','','',0,'\'\''),(85,'BENITO','PALMA','CORREDOR','PREVANZE SL','Administrador','Avda. Francesc Macia, 38 planta 10','08208','Sabadell','España','655878130','bpalma@prevanz.com','45462118L','0','0',0,NULL,NULL,1,'2021-09-09 13:55:55',0,NULL,NULL,NULL,NULL,'2021-09-09 13:55:55','094eedec40915c818a2863dab2e2c237',NULL,0,0.00,'','Sociedad','',0,'\'\''),(86,'XAVIER','MARTINEZ','MARTINEZ','PREVANZE SL','Director Oficina','c/ Santa Rosalia, 13','08120','La Llagosta','España','678524962','xmartinez@prevanz.com','52177960E','0','0',0,85,2,6,'2021-09-09 13:55:55',0,NULL,NULL,NULL,'web','2021-09-09 13:55:55','5ded6a30b77355e2b0bb65d2f3c82925',NULL,0,0.00,'','','',0,'\'\''),(89,'JORDI','GOU','BOLTA','ALLSURANCE 2020 CORREDURIA SEGUROS SL','ADMINISTRADOR - DIRECTOR TECNICO','Panagall 44','08358','ARENYS DE MUNT','ES','639349372','jgou@gerbrokers.com','40306849Q','0','0',0,NULL,0,2,'2021-09-09 16:00:33',0,NULL,NULL,NULL,NULL,'2021-09-17 02:00:00','2a641241802d808c0fed4f7eab641b1d',NULL,0,60.00,'14080089','CORREDURIA','',0,'\'\''),(90,'Maria de les Neus','Gomez','Munne','U&ENE Associats Corredoria','Directora','Avda. Ramon y Cajal 76 local 3','43005','Tarragona','Espanya','628178035','nmunne@uncorredoria.eu','39885782X','0','0',0,NULL,NULL,1,'2021-09-09 14:09:23',0,NULL,NULL,NULL,NULL,'2021-09-09 14:09:23','47a6b1d84bf16023e6ce4adb6206f401',NULL,0,0.00,'','Mediador','',0,'\'\''),(91,'GONZALO','CALZADO','ROMAGOSA','PER IBERIA,SL','DIRECTOR GENERAL ESPAÑA','Calle Aribau, 171, 3º 2ª','08006','BARCELONA','ESPAÑA','+34699641678','gonzalo.calzado@per-iberia.com','B67047183','0','0',0,NULL,NULL,2,'2021-09-09 14:13:32',0,NULL,NULL,NULL,NULL,'2021-09-09 14:15:25','97319a98f00c5463f59418a7bb4a0d25',NULL,0,60.00,'14130091','RECUPERACION','',0,'\'\''),(92,'VICENTE','IRISARRI','SOLA','IRISARRI PRIETO S.L.','ADMINSITRADOR','SARDENYA, 292','08013','BARCELONA','ESPAÑA','652932750','vicente@irisarri-prieto.com','46019467D','0','0',0,NULL,NULL,1,'2021-09-09 14:41:27',0,NULL,NULL,NULL,NULL,'2021-09-09 14:41:27','b158010eca8f6026a2ec6f217658e934',NULL,0,0.00,'','CORREUDRIA DE SEGUROS','',0,'\'\''),(93,'ASIER','IRISARRI','PRIETO','IRISARRI PRIETO S.L.','SOCIO','sardenya , 292 local','08013','barcelona','españa','652932750','asier@irisarri-prieto.com','43544671J','0','0',0,92,2,6,'2021-09-09 14:41:27',0,NULL,NULL,NULL,'web','2021-09-09 14:41:27','e1d9f35df818b42af2f4954b6c36334e',NULL,0,0.00,'','','',0,'\'\''),(94,'AMPARO','CARMONA','MARIN','CAB','Gerent','C.C. Baricentro 159A','08210','Barbera del Valles','Españya','606531276','cab@cabcorredoria.com','35108784C','0','0',1,NULL,NULL,1,'2021-09-09 14:50:18',0,NULL,NULL,NULL,NULL,'2021-09-09 14:50:19','82ab88d7fea8973135ceef64782402fd',NULL,0,0.00,'','Corredoria','',0,'\'\''),(95,'DIEGO ANTONIO','GARCIA','CARRASCO','CAB','Gerent','C.C. Baricentro 159A','08210','Barbera del Valles','Espanya','606531276','cab@cabcorredoria.com','52145242X','0','0',1,94,2,6,'2021-09-09 14:50:18',0,NULL,NULL,NULL,'web','2021-09-09 14:50:19','a22859a07e53b2fd7c35d291e672bfe4',NULL,0,0.00,'','','',0,'\'\''),(96,'CARLOS','HERRERA','VENTURA','GLOBALBROK CORREDURIA DE SEGUROS','ADMINISTRADOR','Gran Via de les Corts Catalanes 628, 5º, 2ª','08007','BARCELONA','','639752138','carlos.herrera@globalbrok.com','35007821G','0','0',0,NULL,NULL,1,'2021-09-09 15:43:35',0,NULL,NULL,NULL,NULL,'2021-09-09 15:43:35','3b2a30b7b83f75136e6ba66c9a77b4db',NULL,0,0.00,'','Correduria de seguros','',0,'\'\''),(97,'MARIA DEL MAR ','MARTIN DE ARRIVA','HERNANDEZ','GLOBALBROK CORREDURIA DE SEGUROS','Departamento de Siniestros','Gran Via de les Corts Catalanes 628, 5º, 2ª','08007','barcelona','','626337811','mar.martin@globalbrok.com','28872598P','0','0',0,96,2,6,'2021-09-09 15:43:35',0,NULL,NULL,NULL,'web','2021-09-09 15:43:35','ce4f98b9b64ebc8f19d617757bd79f48',NULL,0,0.00,'','','',0,'\'\''),(98,'Óscar','Herrero','Arenas','Getlife','Senior Business Developer','C/ Pierre Gassier, 27','50018','Zaragoza','España','656424197','oscar@getlife.es','29127896Y','0','0',0,NULL,NULL,4,'2021-09-09 15:50:18',0,NULL,NULL,NULL,NULL,'2021-09-09 15:54:08','e920b9967e63efaac285a468cf3bf5be',NULL,0,60.00,'15500098','Star-Up','',0,'\'\''),(101,'CRISTINA','CASANOVAS','ROFAS','RACC','RESPONSABLE TERRITORIAL CATALUNYA ESTE','Avda Diagonal, 687-689','08028','BARCELONA','ESPAÑA','609731851','cristina.casanovas@racc.es','38096837M','0','0',0,NULL,NULL,3,'2021-09-09 16:46:18',0,NULL,NULL,NULL,NULL,NULL,'','2021-09-09 16:46:18',0,60.00,'16460101','ASSISTENCIA','',0,'\'\''),(102,'ISABEL','PEREZ','ESCUDERO','AGENCIA MIRASOL ASSEGURANCES S.C.P.','GERENT','Av. Caresmar, 53','08700','IGUALADA','ESPANYA','677974609','agencia.mirasol@agentes.catalanaoccidente.com','46581951M','0','0',0,NULL,NULL,1,'2021-09-09 17:02:08',0,NULL,NULL,NULL,NULL,'2021-09-09 17:02:08','9e2ca2e93d0376c2a032a38a0d10e6c5',NULL,0,0.00,'','OF. D\'AGÈNCIA','',0,''),(103,'ANTONI','FARRERAS ','TORRA','AGENCIA MIRASOL ASSEGURANCES, S.C.P.','DIRECTOR COMERCIAL','Av. Caresmar, 53','08700','IGUALDA','ESPANYA','677974609','antoni.farreras@agentes.catalanaoccidente.com','77112080A','0','0',0,102,2,6,'2021-09-09 17:02:08',0,NULL,NULL,NULL,'web','2021-09-09 17:02:08','f2e90a88908470a9e3fcb0d701e15603',NULL,0,0.00,'','','',0,''),(104,'Guillem','Gonzalez','Escobar','CLUB CATALA DE CORREDORS','PRESIDENT','C/ GALILEU, 120 BXOS','08224','TERRASSA ','ESPAÑA','661814701','guillem@bgonzalezsl.com','45461411W','0','0',0,NULL,NULL,1,'2021-09-09 17:03:54',0,NULL,NULL,NULL,NULL,'2021-09-09 17:03:54','abe1f916322a031a6c33023523b9f467',NULL,0,0.00,'','CLUB CATALA DE CORREDORS','',0,''),(105,'Guillem','Escobar','LANASPA','CLUB CATALA DE CORREDORS','GERENT','C/ ARAGÓ, 208','085186315','BARCELONA','ESPAÑA','661814701','guillem@bgonzalezsl.com','43408699V','0','0',0,104,2,6,'2021-09-09 17:03:54',0,NULL,NULL,NULL,'web','2021-09-09 17:03:54','7def42288b4520b28f44a1bd8e8a30cb',NULL,0,0.00,'','','',0,''),(106,'JUAN PEDRO ','OÑATE','GARCIA','','','avda ramon escayola 38','08197','VALLDOREIX','España','629768488','jponate@opersa.com','43684548G','0','0',1,NULL,NULL,1,'2021-09-09 18:01:03',0,NULL,NULL,NULL,NULL,'2021-09-09 18:01:03','e5b300bba65f7058296c65b6a60dfc2c',NULL,0,0.00,'','','',0,''),(107,'abril','oñate','viñolas','','','AVDA RAMON ESCAYOLA 38','08197','VALLDOREIX','España','629768488','jponate@opersa.com','54328364h','0','0',0,106,2,6,'2021-09-09 18:01:03',0,NULL,NULL,NULL,'web','2021-09-09 18:01:03','58b53611f384a1ea38de068677b10200',NULL,0,0.00,'','','',0,''),(108,'Julio María','Picornell','Esteve','MDC Correduria','Ejecutivo Comercial','calle Pronvenza, 173','08036','Barcelona','España','607242780','jpicornell@correduriamdc.com','46314367A','0','0',1,NULL,NULL,1,'2021-09-09 18:14:54',0,NULL,NULL,NULL,NULL,'2021-09-09 18:14:55','ed010bb482a43db6d90ef8ea5e072b13',NULL,0,0.00,'','Mediadores','',0,''),(109,'María Luisa','Mestres','Estartús','MDC Correduria','Colaborador','calle Provenza, 173','08036','Barcelona','España','607242780','jpicornell@correduriamdc.com','46315496M','0','0',1,108,2,6,'2021-09-09 18:14:54',0,NULL,NULL,NULL,'web','2021-09-09 18:14:55','742fa56917a9a4c453cfde33e7559ff6',NULL,0,0.00,'','','',0,''),(110,'Marc','Ortiz','Costa','Risk Associats SL','director tecnico','Major, 89','08550','Els Hostalets de Balenyà','españa','655058891','etrabal@riskseguros.es','45638027R','0','0',0,NULL,NULL,1,'2021-09-09 18:21:13',0,NULL,NULL,NULL,NULL,'2021-09-09 18:21:14','c641d34198daa99af937e3f3691b35a4',NULL,0,0.00,'','correduria','',0,''),(111,'Estefanía','Trabal','Blanch','Risk Associats SL','comercial','Major, 89','08550','Els Hostalets de Balenyà','españa','655058891','etrabal@riskseguros.es','33955050N','0','0',0,110,2,6,'2021-09-09 18:21:13',0,NULL,NULL,NULL,'web','2021-09-09 18:21:14','fe7c4ae4f71f008e71fae2ce6c14095f',NULL,0,0.00,'','','',0,''),(113,'JORDI','CATASUS','CORBALAN','CORBALAN 3 ASSESSORS','DIRECTOR TECNIC - ADMIN','C. FRANCESC MACIA, 2, 1r','08720','VILAFRANCA DEL PENEDÈS','Espanya','669790365','jordi@corbalan3.cat','77316312H','0','0',0,NULL,NULL,1,'2021-09-09 18:31:46',0,NULL,NULL,NULL,NULL,'2021-09-09 18:31:46','46bb4921b12c78b350c1b53de5d61330',NULL,0,0.00,'','CORREDORIA','',0,''),(114,'Josefa','Utesà','Camí','','','Paco Mutllo, , 143-3º-4ª','08208','Sabadell','','667491966','pepi.utesa@vear.net','39037359B','0','0',0,NULL,NULL,1,'2021-09-09 19:08:23',0,NULL,NULL,NULL,NULL,'2021-09-09 19:08:23','46341fe141419067c01eeb47b4e64656',NULL,0,0.00,'','Correduria','',0,''),(115,'Dídac','Poveda','Ruano','ESTALELLA @ estallo, C.A.,S.L.','Director Gerent','Montseny, 14, casa 9 ','43883','Roda de Berà','España','669711627','didacpoveda.cat@icloud.com','37704613T','0','0',0,NULL,NULL,1,'2021-09-10 07:58:05',0,NULL,NULL,NULL,NULL,'2021-09-10 07:58:06','3aeee8308183c263fadce558bdbed416',NULL,0,0.00,'','Corredoria d\'Assegurances','',0,''),(116,'Montserrat','Chaler','Gil','ESTALELLA & ESTALLO,C.A.,S.L.','Colaboradora','Montseny 14,casa 9,','43883','Roda de Berà','España','669711627','didacpoveda.cat@gmail.com','39030700E','0','0',0,115,2,6,'2021-09-10 07:58:05',0,NULL,NULL,NULL,'web','2021-09-10 07:58:06','16b90e496e4e8895d17a28796a3b20dc',NULL,0,0.00,'','','',0,''),(117,'XAVIER ','ORTS','FORNS','ORTS RISK CORREDORIA D´ASSEGURANCES','GERENTE','Pare Secchi 42-54','08030','Barcelona','ESPAÑA','933464690','xavierorts@ortsrisk.com','35069976J','0','0',0,NULL,NULL,1,'2021-09-10 08:20:04',0,NULL,NULL,NULL,NULL,'2021-09-10 08:20:04','0fafd2dc69b0133fcc80710046fab261',NULL,0,0.00,'','correduria','',0,''),(118,'DANIEL','ORTS','PEREZ','CORREDORIA ORTS RISK ','COMERCIAL','Pare Secchi 42-54','08030','Barcelona','España','933464690','danielorts@ortsrisk.com','43565776G','0','0',0,117,2,6,'2021-09-10 08:20:04',0,NULL,NULL,NULL,'web','2021-09-10 08:20:04','9f135a3eed5e8183c76b08c5d6130cc6',NULL,0,0.00,'','','',0,''),(119,'BETSAIDA','QUESADA','IMBERNON','SEGUROS QUESADA','TITULAR','RENAIXENÇA, 4 LOCAL','Barcelona','Barcelona','España','687071913','betsaida@segurosquesada.es','43446183B','0','0',1,NULL,NULL,1,'2021-09-10 08:47:25',0,NULL,NULL,NULL,NULL,'2021-09-10 08:47:26','128cd8bbf2e855910b416f52e8dae12d',NULL,0,0.00,'','CORREDURIA','',0,''),(120,'SERGI','CAMPDEPADROS','URPI','IBEX UNIVERSAL S.A. CORREDURIA DE SEGUROS','ADMINISTRADOR','','','','','933762057','sergi@ibexuniversal.es','40996019Z','0','0',1,NULL,NULL,1,'2021-09-10 09:42:25',0,NULL,NULL,NULL,NULL,'2021-09-10 09:42:26','44e54a26176b0b3db7f35b1b02f0349d',NULL,0,0.00,'','','',0,''),(121,'ELENA','SADURNI','ESCURRIOLA','','','','','','','933762057','elenasadurni@gmail.com','38841780R','0','0',1,120,2,6,'2021-09-10 09:42:25',0,NULL,NULL,NULL,'web','2021-09-10 09:42:26','b5e750a286306355ae0a5db1267d0371',NULL,0,0.00,'','','',0,''),(122,'Gemma','Descarrega','Sábat','SOFT QS','Direcció Comercial Catalunya','C/ Enric Vincke 11','17230','Palamòs','Espanya','629371248','gemma@softqs.com','36972101','0','0',0,NULL,NULL,4,'2021-09-10 09:43:20',0,NULL,NULL,NULL,NULL,'2021-09-10 09:46:37','673e462c21e91b36d78138387bbad462',NULL,0,60.00,'09430122','Tecnològica','',0,''),(123,'NURIA','ARBOLES ','MIRALLES','ASSENUR','DIRECTORA','CL. ORIENT, 78-84 3 7 ','08172','SANT CUGAT DEL VALLÈS','ESPAÑA','639357610','assenur@assenur.com','52596417V','0','0',1,NULL,NULL,1,'2021-09-10 09:46:52',0,NULL,NULL,NULL,NULL,'2021-09-10 09:46:53','d198893bbe447d4b3c1a0315236fceca',NULL,0,0.00,'','FISICA-CORREDORA','',0,''),(124,'ANNA','ARBOLES','MIRALLES','ASSENUR','DIRECTORA','ORIENT, 78-84 3.7.','08172','SANT CUGAT DEL VALLES','ESPAÑA','633016170','anna@assenur.com','46628026B','0','0',1,123,2,6,'2021-09-10 09:46:52',0,NULL,NULL,NULL,'web','2021-09-10 09:46:53','b386b5419b7e44d84257e49f06bdb36f',NULL,0,0.00,'','','',0,''),(125,'Joan','Casanova','Batlle','Aass Correduria','Director','Corsega, 108, Pral. 2ª','08029','Barcelona','España','933632920','jfcasanova@ascorreduria.com','46117371W','0','0',0,NULL,NULL,1,'2021-09-10 10:12:41',0,NULL,NULL,NULL,NULL,'2021-09-10 10:12:41','c3689cfe3b97faddc79686a6a1f12dcc',NULL,0,0.00,'','Correduria','',0,''),(126,'Ana','Casanova','Batlle','Aass Correduría d\'Assegurances, S.L.','Directora Técnica','Corsega, 108, Pral. 2ª','08029','Barcelona','España','933632920','acasanova@ascorreduria.com','46117480L','0','0',0,125,2,6,'2021-09-10 10:12:41',0,NULL,NULL,NULL,'web','2021-09-10 10:12:42','daeab3d7d74a00f6bcca086d9ac021f0',NULL,0,0.00,'','','',0,''),(127,'IOLANDA','PIÑERO','ESCUDE','CORREDORIA PIÑERO','CORREDOR','','','','','','david@asspinero.com','39347505W','','',1,NULL,0,1,'2021-09-10 00:00:00',0,NULL,NULL,'','','2021-09-10 05:00:38','1c1f07c78182d7b8434fc75d06800604',NULL,0,0.00,'','','',0,''),(128,'JORDI','GRAELL','COSTA','CORREDORIA PIÑERO','CORREDOR','','','','','','jordi@asspinero.com','39363697W','','',0,NULL,0,6,'2021-09-10 00:00:00',0,NULL,NULL,'','','2021-09-10 10:15:02','336d5ebc5436534e61d16e63ddfca327',NULL,0,0.00,'','','',0,''),(131,'ISMAEL','IZQUIERDO','PUERTAS','SA COYFER','DIRECTOR COMERCIAL','casanova 164','08036','barcelona','ESPAÑA','666259653','ismael.izquierdo@coyfer.es','46800663X','0','0',0,129,2,6,'2021-09-10 11:12:34',0,NULL,NULL,NULL,'web',NULL,'','2021-09-10 11:12:34',0,0.00,'','','',0,''),(132,'FONTCALDA','MARTINEZ-SEARA','MONNE','FONTCALDA MTZ-SEARA','','ESPRONCEDA 5-7, 6º 4ª','08005','BARCELONA','ESPANYA','649040739','fsearam@cgillsl.com','46711794J','0','0',0,NULL,NULL,1,'2021-09-10 12:08:13',0,NULL,NULL,NULL,NULL,'2021-09-10 12:08:13','6353881268a46ba7a01deff7b364f724',NULL,0,0.00,'','CORREDORIA','',0,''),(133,'Mercè','Guixot ','Rovira','CORREDORIA D\'ASSEGURANCES DE FÈLIX FELIU QUINTANA, SL','Adjunta a gerència','Carrer del Parc, 46 baix','08302','MATARÓ','ESPAÑA','937571739','merce@assegurancesfeliu.cat','38793122B ','0','0',0,NULL,NULL,1,'2021-09-10 13:20:43',0,NULL,NULL,NULL,NULL,'2021-09-10 13:20:43','da1ad3008246ee678624e7d2d4b057df',NULL,0,0.00,'','CORREDORIA','',0,''),(134,'JOSE ','MONTES','MONTES','CORREDORIA D\'ASSEGURANCES DE FÈLIX FELIU QUINTANA, SL.','Invitado','Carrer del Parc, 46 baix','08302','Mataró','ESPAÑA','937571739','merce@assegurancesfeliu.cat','38802601z','0','0',0,133,2,6,'2021-09-10 13:20:43',0,NULL,NULL,NULL,'web','2021-09-10 13:20:43','02eba6cda514798dbb7d7613833128c1',NULL,0,0.00,'','','',0,''),(135,'Luis Manuel','Moreno','Bellerino','Moreno Sbd Corredoria d\'Assegurances','Corredor','Marquès de Comillas, 21','08202','Sabadell','España','937277707','luisma@morenosbd.com','33903357T','0','0',0,NULL,NULL,1,'2021-09-10 17:32:40',0,NULL,NULL,NULL,NULL,'2021-09-10 17:32:40','36baac821f5edad3eea709e4a43840ed',NULL,0,0.00,'','Correduría','',0,''),(136,'Eva ','Moreno','Bellerino','Moreno Sbd Corredoría d\'Assegurances','Administrativa','Marquès de Comillas, 21','08202','Sabadell','España','937277707','eva@morenosbd.com','34764260J','0','0',0,135,2,6,'2021-09-10 17:32:40',0,NULL,NULL,NULL,'web','2021-09-10 17:32:40','7cc25a48bac2056bdca4560b1d3f1b36',NULL,0,0.00,'','','',0,''),(137,'Antonio','García','Guerrero','Soft QS','Gerente - Director general','Plaza Azteca, 4','50012','Zaragoza','España','629371248','antonio.garcia@isegur.es','25138225F','0','0',0,NULL,NULL,4,'2021-09-10 19:26:14',0,NULL,NULL,NULL,NULL,'2021-09-10 19:28:34','43962149dd4110d8865c8e6a9fcd7297',NULL,0,60.00,'19260137','Tecnológica','',0,''),(138,'Manel','Vila','Calsina','','','Comtessa Ermessenda,18','08242','Manresa','','618060376','manelvila47@gmail.com','39282528T','0','0',0,NULL,NULL,1,'2021-09-11 12:09:21',0,NULL,NULL,NULL,NULL,'2021-09-11 12:09:21','11119051c4659c33027970a727b68a6a',NULL,0,0.00,'','Jubilado','',0,''),(139,'CHELO','LORENZO','MORENO','BLUECOVER','DIRECTORA','Gran Vía de les Corts Catalanes 617 Entlo 3ª','08007','Barcelona','España','646554314','bluecover@zurichagente.es','38103269C','0','0',0,NULL,NULL,1,'2021-09-12 10:24:46',0,NULL,NULL,NULL,NULL,'2021-09-12 10:24:46','39abf10160d701a754a885a8b4735cc6',NULL,0,0.00,'','AGENCIA','',0,''),(140,'CARLOS','REIXACH','MORALES','MARESBROKER CORREDURIA DE SEGUROS S.L.','DIRECTOR TECNICO','RONDA ALFONS X EL SAVI,70','08301','MATARO','España','680318535','creixach@maresbroker.com','52141284P','0','0',1,NULL,NULL,1,'2021-09-13 09:29:12',0,NULL,NULL,NULL,NULL,'2021-09-13 09:29:12','5aa212c6cdb965d19789fc1e0ac03eed',NULL,0,0.00,'','CORREDURIA DE SEGUROS','',0,''),(141,'RAMON','PLA','CABEDO','MARESBROKER CORREDURIA DE SEGUROS S.L.','COLABORADOR','RDA. ALFONS X EL SAVI, 70','08301','MATARO','España','625478406','ramon.colex@maresbroker.com','35047443 C','0','0',1,140,2,6,'2021-09-13 09:29:12',0,NULL,NULL,NULL,'web','2021-09-13 09:29:12','0dfa8a1eecd07cea72e0f46fb5b2d42e',NULL,0,0.00,'','','',0,''),(142,'Rosa Maria','Pla','Brunet','Assegurances Pla Brunet, s.l','Gerent','C/ Santiago, 6 Baixos','08512','Sant Hipòlit de Voltrgà','','620624921','rmplabrunet@gmail.com','77113440Y','0','0',0,NULL,NULL,1,'2021-09-13 10:35:14',0,NULL,NULL,NULL,NULL,'2021-09-13 10:35:14','6ee48f03ac01edd2c782a315f13bfe1f',NULL,0,0.00,'','','',0,''),(143,'ESTER','SOLER','ROCA','Assegurances Pla Brunet, s.l','','Cami Antic del Pilar, 37','08512','Sant. Hipòlit de Vgà.','','608444258','estercatcat@gmail.com','33947396V','0','0',0,142,2,6,'2021-09-13 10:35:14',0,NULL,NULL,NULL,'web','2021-09-13 10:35:14','a14b365b769abf091f0a99f65e30f60f',NULL,0,0.00,'','','',0,''),(144,'MARTA','IGLESIAS','BERNAL','MGC MUTUA','GERENTA NEGOCIO ALIANZAS','TUSET 5-11','08006','BARCELONA','ESPAÑA','639129943','miglesiasber@mgc.es','46618330k','0','0',0,NULL,NULL,3,'2021-09-13 11:32:54',0,NULL,NULL,NULL,NULL,'2021-09-13 11:35:57','b9974fdfd9725f7f479f1c03a218f085',NULL,0,60.00,'11320144','','',0,''),(145,'CARLES','GRAU','PASSARELL','CARLS GRAU & ASSOCIATS CORREDORIA D\'ASSEGURANCES, S.L.U.','DIRECTOR TÈCNIC/GERENT','Ferran Casablancas, 23','08201','SABADELL','España','+34937258700','carles@grau-associats.com','39027096Y','0','0',0,NULL,NULL,1,'2021-09-13 12:13:25',0,NULL,NULL,NULL,NULL,'2021-09-13 12:13:26','6b0ba1cf6c4f9909a3766d68cbd05725',NULL,0,0.00,'','corredoria ','',0,''),(146,'CASIMIRO ','REY','VIÑUELA','GRUPO GALILEA PUIG, C.S.A., S.A.','DIRECTOR EMPRESAS E INTERNACIONAL','Gran Via Carlos III, 62-64, bajos','08028','Barcelona','ESPAÑA','934145151','casimiro.rey@grupogalilea.com','35018075T','0','0',0,NULL,NULL,2,'2021-09-13 13:00:42',0,NULL,NULL,NULL,NULL,'2021-09-13 13:03:01','aa8a5999b95b6143369f31440b66151e',NULL,0,120.00,'13000146','GRUPO GALILEA PUIG, C.S.A., S.A.','',0,''),(147,'ESTHER','TOMAS','AYMA','GRUPO GALILEA PUIG, C.S.A., S.A.','DIRECTORA TECNICA','Gran Via Carlos III, 62-64, bajos','08028','Barcelona','ESPAÑA','934145151','esther.tomas@grupogalilea.com','38082441F','0','0',0,146,2,7,'2021-09-13 13:00:42',0,NULL,NULL,NULL,'web','2021-09-13 13:03:01','6dfe463ed146a0ad3399cd5b22135eeb',NULL,0,0.00,'','','',0,''),(148,'JORDI','MARTI','CANO','GRUPO GALILEA PUIG, C.S.A., S.A.','DIRECTOR COMERCIAL TERRITORIAL','Gran Via Carlos III, 62-64, bajos','08028','Barcelona','España','934145151','jordi.marti@grupogalilea.com','39330711K','0','0',0,NULL,NULL,2,'2021-09-13 13:07:11',0,NULL,NULL,NULL,NULL,'2021-09-13 13:11:13','86013a73b0931072b25b9265b3243b25',NULL,0,60.00,'13070148','GRUPO GALILEA PUIG, C.S.A., S.A.','',0,''),(150,'AURORA','codina','FUENTEFRIA','Asseguris Mediterraneus, c aSSEG sl','DIRECTORA','garbi 88-90','08397','pineda de mar','España','609385793','aurora.codina@grupserhs.com','38794452F','0','0',0,NULL,NULL,1,'2021-09-13 13:58:23',0,NULL,NULL,NULL,NULL,'2021-09-13 13:58:23','65480eaf13e68ac1a38e67eaba21dcc3',NULL,0,0.00,'','correduria','',0,''),(151,'merce','fernandez ','quiles','Asseguris Med. C asseg SL','Cap comercial','garbi 88-90','08397','pineda de mar','España','610789807','merce.fernandez@grupserhs.com','38076893W','0','0',0,150,2,6,'2021-09-13 13:58:23',0,NULL,NULL,NULL,'web','2021-09-13 13:58:23','929b08474d11c9e61009e852b6982d22',NULL,0,0.00,'','','',0,''),(152,'DAVID','COLLAR','MUT','SEGUROS LAGUN ARO S.A.','RESPONSABLE CANAL MEDIADORES CATALUNYA','Roger de Lluria, 50 entlo-2a','08009','BARCELONA','ESPAÑA','650414592','dmut@seguroslagunaro.com','36515149G','0','0',0,NULL,NULL,3,'2021-09-13 14:26:19',0,NULL,NULL,NULL,NULL,'2021-09-13 14:28:09','3ed3e533015187f90224044323030eb7',NULL,0,60.00,'14260152','COMPAÑIA','',0,''),(154,'JOSE ','MULÀ ','ARMERO','GRUPO GALILEA PUIG, C.S.A., S.A.','DIRECTOR GENERAL','Gran Via Carlos III, 62-64, bajos','08028','Barcelona','españa','934145151','josep.mula@grupogalilea.com','46620862T','0','0',0,NULL,0,1,'2021-09-13 17:00:00',0,NULL,NULL,NULL,NULL,'2021-09-13 17:00:00','3c07701e910751587ef6b6e562197daa',NULL,0,0.00,'','GRUPO GALILEA PUIG, C.S.A., S.A.','',0,''),(155,'Josep','CASTELL ','FERRE','JNR CARTERAS DE SEGUROS SL','','Roger de Flor , 47-49 Local','08302','MATARO','España','618937216','josep@carterasdeseguros.com','40906325C','0','0',1,NULL,NULL,4,'2021-09-13 20:35:26',0,NULL,NULL,NULL,NULL,'2021-09-13 20:37:52','c7cb472ec9b2f25e757fc47a3f3ff86f',NULL,0,60.00,'20350155','CONSULTORA','',0,''),(156,'MIQUEL','MAESO','i LEBRUN','ATI GABINET TÈCNIC D\'ASSEGURANCES','corredor','Plaça Àngel, 4','08202','Sabadell','Espanya','647596002','miquel@corredor-assegurances.cat','38998271T','0','0',0,NULL,NULL,1,'2021-09-14 09:37:46',0,NULL,NULL,NULL,NULL,'2021-09-14 09:37:46','28a4170ca09e45f29254ee2608dc94e9',NULL,0,0.00,'','corredoria','',0,''),(157,'CARMEN','VILADOMS','GENERO','ATI GABINET TÈCNIC D\'ASSEGURANCES','corredora','Plaça Àngel, 4','08202','Sabadell','Espanya','607775140','assegurances@ati.cat','39006372M','0','0',0,156,2,6,'2021-09-14 09:37:46',0,NULL,NULL,NULL,'web','2021-09-14 09:37:47','2ef9f58b4a467ceedb41bef09d864056',NULL,0,0.00,'','','',0,''),(159,'MIGUEL ANGEL','MARICALVA','ROBLES','','','','','','','933394575','miguelangel@mambrok.com','37651343K','0','0',0,NULL,NULL,1,'2021-09-14 12:59:08',0,NULL,NULL,NULL,NULL,'2021-09-14 12:59:09','c09afdc6ef322b789c3913313a22c8f3',NULL,0,0.00,'','','',0,''),(160,'IVÁN','SANTANA','SORIANO','','','','','','','933394575','ivan@mambrok.com','46131106Y','0','0',0,159,2,6,'2021-09-14 12:59:08',0,NULL,NULL,NULL,'web','2021-09-14 12:59:09','159293520da6e12afb770173d381e926',NULL,0,0.00,'','','',0,''),(248,'JOSE LUIS','SALAS','ECER','SA COYFER','CONSEJERO DELEGADO','casanova 164','08036','barcelona','España','639331155','joseluis.salas@coyfer.es','35088889C','0','0',1,NULL,NULL,1,'2021-09-14 13:19:50',0,NULL,NULL,NULL,NULL,'2021-09-14 13:21:38','9b992bc46060d5aadbe1c68427fbb923',NULL,0,120.00,'13190248','CORREDURIA','',0,''),(249,'FRANCISCO','SANCHEZ','MONTERRUBIO','SA COYFER','DIRECTOR','casanva164','08036','barcelona','españa','639623246','francisco.sanchez@coyfer.es','38545539t','0','0',1,248,2,6,'2021-09-14 13:19:50',0,NULL,NULL,NULL,'web','2021-09-14 13:21:38','bf5c71e1e84c6dc009fbf747c739493b',NULL,0,0.00,'','','',0,''),(250,'JOSE ANTONIO','RAMIREZ','MANZANO','sa coyfer','','valldaura 84','08195','sant cugat','españa','616836687','jaramirez@aserbrokers.es','38403461Q','0','0',1,248,2,6,'2021-09-14 13:19:50',0,NULL,NULL,NULL,'web','2021-09-14 13:21:39','245ccc571f597a63aeb0eb3cbf5f88a7',NULL,0,0.00,'','','',0,''),(251,'ISMAEL','IZQUIERDO','PUERTAS','sa coyfer','DIRECTOR COMERCIAL','casanova 164 ','08036','barcelona','españa','666259653','ismael.izquierdo@coyfer.es','468000663X','0','0',0,248,2,6,'2021-09-14 13:19:50',0,NULL,NULL,NULL,'web','2021-09-14 13:21:39','8751d3f3f3b4720c1381f6ee36927481',NULL,0,0.00,'','','',0,''),(254,'JUAN','GONZALEZ','SARMIENTO','','','','','','','629200718','jgonzalez@gomarsrl.com','39352351H','0','0',0,NULL,NULL,1,'2021-09-14 18:26:15',0,NULL,NULL,NULL,NULL,'2021-09-14 18:26:15','758565e68f6e6a6b5c9659c3f030d971',NULL,0,0.00,'','','',0,''),(255,'ANTONIO','GARCIA','PEREZ','','','','','','','622193784','segur7seguros@gmail.com','39370967G','0','0',0,254,2,6,'2021-09-14 18:26:15',0,NULL,NULL,NULL,'web','2021-09-14 18:26:15','26587db094c79b6e568c205cf38c9e2d',NULL,0,0.00,'','','',0,''),(256,'guillermo','adell','romero','GUILLERMO ADELL CORREDURIA DE SEGUROS,SL','DIRECTOR','PEDRO I PONS , 5','08034','barelona','españa','627960085','cvega@segurosadell.com','46122404K','0','0',0,NULL,NULL,1,'2021-09-15 11:33:59',0,NULL,NULL,NULL,NULL,'2021-09-15 11:34:00','c85ee1bf101c8d8c6531f8c597329676',NULL,0,0.00,'','CORREDURIA','',0,''),(257,'CRISTINA','VEGA','GALCERAN','G.ADELL CDS, SL ','DIRECTORA COMERCIAL ','PEDRO I PONS , 5','08034','BARCELONA','España','627960085','cvega@segurosadell.com','72533098E','0','0',0,256,2,6,'2021-09-15 11:33:59',0,NULL,NULL,NULL,'web','2021-09-15 11:34:00','816d7c364cc55b94972b5f608f1668ae',NULL,0,0.00,'','','',0,''),(258,'Mateo Ignacio','Segui','Perez-Caballero','IBERSER Correduría de Seguros','Director Técnico','Marqués de Mulhacen, 11, bjos, 1º, 1ª','08034','Barcelona','España','610483065','msegui@iberser.es','46142549H','0','0',1,NULL,NULL,1,'2021-09-15 11:41:43',0,NULL,NULL,NULL,NULL,'2021-09-15 11:41:44','ce1e475a25c9309e8b953709dd46041f',NULL,0,0.00,'','Coorreduría de Seguros','',0,''),(260,'Mari Luz ','Pérez','Catalán','Cristalbox','Directora Comercial','Avda Zaragoza, 44 Entlo E','31500','Tudela','España','675975890','mperez@cristalbox.es','16018129d','0','0',0,NULL,0,4,'2021-09-14 15:00:53',0,NULL,NULL,NULL,NULL,'2021-09-15 13:00:18','7db29d6b7b81ba6228e0fd84b2fae0e4',NULL,0,120.00,'13240252','Servicios','',0,''),(261,'Guido ','Bravo','G.','GB BROKER','Director General','Av Eduard Maristany 13','08930','Barcelona','España','628003091','gbravo@gbbroker.es','X5508858J','0','0',1,NULL,NULL,1,'2021-09-15 13:25:06',0,NULL,NULL,NULL,NULL,'2021-09-15 13:25:06','105ee161cce55dc7e218233f542b4feb',NULL,0,0.00,'','Corredor','',0,''),(262,'Elena ','Marciano','M.','GB BROKER','Business Development Manager','Av Eduard Maristany 13 ','08930','Barcelona','España','628003091','gbravo@gbbroker.es','55326259N','0','0',1,261,2,6,'2021-09-15 13:25:06',0,NULL,NULL,NULL,'web','2021-09-15 13:25:06','9134408a1d7629fc4b2ec2f83690b809',NULL,0,0.00,'','','',0,''),(263,'LAUREN','ARAUCO','AGUIRRE','LAGUN ARO','DIRECTOR ZONA ESTE','','','','','','larauco@seguroslagunaro.com','78868291A','','',1,NULL,0,3,'2021-09-15 02:00:00',0,NULL,NULL,'','',NULL,'56f282ab2ddc581e12a61bfd2d83c5b9',NULL,0,60.00,'','','15200153',0,''),(264,'Josep','Calvo','Lafita','39677743Y','Assessor Tecnic CMAB','Ronda Ponent nº 13,, 2º 5ª','08206','Sabadell','España','649849882','josep.calvo@elcol-legi.org','39677743Y','0','0',0,NULL,NULL,1,'2021-09-15 15:11:50',0,NULL,NULL,NULL,NULL,'2021-09-15 15:12:20','85c94eae5b2b95f79d60de3963824ea8',NULL,0,0.00,'','39677743Y','',0,''),(265,'Carla','Capell','Font','Alertis Brok.','Dirección','','08008','','España','934161790','ccapell@alertis.es','37642784H','0','0',0,NULL,NULL,1,'2021-09-16 10:39:35',0,NULL,NULL,NULL,NULL,'2021-09-16 10:39:36','32f74e218ccb23ff44c70374e07fbe9a',NULL,0,0.00,'','Correduria','',0,''),(266,'Rosó','Güell','Vinyals','Alertis Brok.','Dirección','','08008','','España','934161790','rguell@alertis.es','46242279C','0','0',0,NULL,NULL,2,'2021-09-16 10:40:21',0,NULL,NULL,NULL,NULL,'2021-09-16 10:41:35','cec0f1b201c9dc7f0cb414fec73f0ffa',NULL,1,60.00,'10400266','Correduria','',0,''),(267,'CRISTINA','MAYMÓ','LÓPEZ','','','','','','','679284855','cmaymo@kripton.cat','46700069H','0','0',0,NULL,NULL,1,'2021-09-16 11:37:54',0,NULL,NULL,NULL,NULL,'2021-09-16 11:37:55','5ddbe907b894948d27371ee3ceb7c9e5',NULL,0,0.00,'','','',0,''),(268,'NEREA','LLOP','LAPREA','','','','','','','','nerea.llop.laprea@gmail.com','12345678G','0','0',0,267,2,6,'2021-09-16 11:37:54',0,NULL,NULL,NULL,'web','2021-09-16 11:37:55','11c6425ec1128ecc76cbcbff4303512c',NULL,0,0.00,'','','',0,''),(269,'Agustín ','Pérez ','Parra','','','','','','','677977850','agustin.perez@agentes.catalanaoccidente.com','36481365F','0','0',0,NULL,NULL,1,'2021-09-16 11:39:03',0,NULL,NULL,NULL,NULL,'2021-09-16 11:39:03','15006875fc267660f7fbc7faad4420ff',NULL,0,0.00,'','','',0,''),(270,'Agustín','Pérez','Farrés','','','','','','','932662491','agustin.perez@agentes.catalanaoccidente.com','46064219a','0','0',0,269,2,6,'2021-09-16 11:39:03',0,NULL,NULL,NULL,'web','2021-09-16 11:39:03','dea046e66022f9c617e7eaa9505635b7',NULL,0,0.00,'','','',0,''),(272,'Fernando','Urquiza','Rodrigo','SEGUROS LAGUN ARO','Director Canal Mediación','Capuchinos de Basurto, 6 - 2º','48013','Bilbao','España','650412717','ferurkiza@gmail.com','16049621Z','0','0',0,NULL,NULL,3,'2021-09-16 12:46:34',0,NULL,NULL,NULL,NULL,'2021-09-16 12:50:36','ac190450b14b10179c708a5913e45fd1',NULL,0,60.00,'12460272','SEGUROS','',0,''),(288,'RICARDO','GARCIA','DE LA CALLE','','','','','','','606974321','richard@evaristautomocio.com','43689387J','0','0',0,NULL,NULL,1,'2021-09-17 09:48:14',0,NULL,NULL,NULL,NULL,'2021-09-17 09:48:15','4bdab812f41d0bbb622774579e6c273e',NULL,0,0.00,'','','',0,''),(289,'DORI','ARUMI','BAYO','','','','','','','628716090','dori@evaristautomocio.com','52158307B','0','0',0,288,2,6,'2021-09-17 09:48:14',0,NULL,NULL,NULL,'web','2021-09-17 09:48:15','9ffe5e9195d8eba890f4e98fe32b9577',NULL,0,0.00,'','','',0,''),(290,'VERONICA','JIMENEZ','LOPEZ','','','','','','','667371772','veronica@evaristautomocio.com','53085143q','0','0',0,NULL,NULL,2,'2021-09-17 09:49:36',0,NULL,NULL,NULL,NULL,'2021-09-17 10:28:10','1148707b1449e9db2885f0cc08b8718d',NULL,1,60.00,'09490290','','',0,''),(291,'OLGA','GALLEGO','ALFOS','','','','','','','932724501','olgagallego@segurosalfos.com','40970316W','0','0',1,NULL,NULL,1,'2021-09-17 10:20:21',0,NULL,NULL,NULL,NULL,'2021-09-17 10:20:22','9458ba1820230aaa4f019dd9d3956817',NULL,0,0.00,'','','',0,''),(292,'MERCEDES','FERNÁNDEZ','BERMEJO','','','','','','','932724501','olgagallego@segurosalfos.com','35074961F','0','0',0,291,2,6,'2021-09-17 10:20:21',0,NULL,NULL,NULL,'web','2021-09-17 10:20:22','a64857dadfbcc67b9666e6d6487ed862',NULL,0,0.00,'','','',0,''),(293,'Manuel','Marin','Gallardo','Marín-Llavero SL','Agente-Administrador','PJE. Font del Sauc, 6','08207','Sabadell','España','607386862','mmaring53@gmail.com','39022072L','0','0',0,NULL,NULL,1,'2021-09-17 10:29:46',0,NULL,NULL,NULL,NULL,'2021-09-17 10:30:47','2afecb55e0f3779881325dcc5f2ee861',NULL,0,0.00,'','Agencia de Seguros','',0,''),(294,'Juana','Llavero','Cuadros','Marín-Llavero SL','Socia','PJE. Font del Sauc, 6','08207','Sabadell ','España','677482752','juani.llavero@gmail.com','39023875M','0','0',0,293,2,6,'2021-09-17 10:29:46',0,NULL,NULL,NULL,'web','2021-09-17 10:30:47','fd6d774be2e48d497aefc0652a7b8cd3',NULL,0,0.00,'','','',0,''),(295,'GABRIEL ','CERETO ','NAVAZ','CONFIDE ','Managing Director&Partner','CARRER D\'ARIBAU 200 - 3PL','08036','BARCELONA','ESPAÑA ','933065800','gabriel.cereto@confide.es','37726096R','0','0',0,NULL,NULL,1,'2021-09-17 11:10:11',0,NULL,NULL,NULL,NULL,'2021-09-17 11:10:11','4e82da762232548984c11d5dd09b9b80',NULL,0,0.00,'','CORREDURIA','',0,''),(296,'PATRICIA','DELGADO','PAVON','DKV SEGUROS ','CONSULTORA RED CORREDORES','Gustavo Becquer, 45, bajos 2','08023','Barcelona','España','620775679','patricia.delgado@dkvseguros.es','43692498L','0','0',0,NULL,NULL,1,'2021-09-17 15:09:58',0,NULL,NULL,NULL,NULL,'2021-09-17 15:09:58','d2facb85026974cf4fd93f197228d3bf',NULL,0,0.00,'','ASEGURADORA','',0,''),(297,'SANDRA','BUENO','SANCHEZ ','DKV SEGUROS ','Consultora Red Corredurias','Paseo de Gracia, 55-57','08007','Barcelona ','España','628593814','sandra.bueno@dkvseguros.es','38853188R','0','0',0,296,2,6,'2021-09-17 15:09:58',0,NULL,NULL,NULL,'web','2021-09-17 15:09:58','a2263c52a384b38d5f3a612259441bd2',NULL,0,0.00,'','','',0,''),(298,'Rafael','Nadal','Ribas','','','Vilassar de Dalt n 25','08340','Vilassar de Mar','España','699665049','nrrafael@hotmail.com','36468366A','0','0',1,NULL,NULL,1,'2021-09-17 17:44:16',0,NULL,NULL,NULL,NULL,'2021-09-17 17:44:16','0c442d1f7220facc6066161ca8187234',NULL,0,0.00,'','','',0,''),(304,'FREDERIC','GARCIA','GASCONS','FIJ GARCIA GASCON, S.L.U.','DIRECTOR','Garbí, 196','08397','pineda de mar','españa','696045570','fredy.garcia@mac.com','38797141M','0','0',0,NULL,NULL,1,'2021-09-20 09:42:17',0,NULL,NULL,NULL,NULL,'2021-09-20 09:42:17','d2df59130f66b40324720c51753f8fd7',NULL,0,0.00,'','agencia','',0,''),(365,'SIMÓ','SANFELIU','VILA','Simó Sanfeliu Vila','Agente ','Nou 7','08272','SANT FRUITÓS DE BAGES','ESPAÑA','650200641','sanfeliu.vila@allianzmed.es','39332914Q','0','0',0,NULL,NULL,1,'2021-09-21 12:08:40',0,NULL,NULL,NULL,NULL,'2021-09-21 12:08:40','66f62d028c85783b9f4c58def19a8237',NULL,0,0.00,'','Agente de Seguros','',0,''),(366,'EMPAR','GARCIA','GRIMALDOS','Assegurances Empar Garcia','Agent','camí de Sant Jordi 38','08698','Cercs','España','699977479','garcia.grimaldos@allianzmed.es','77735936f','0','0',0,365,2,6,'2021-09-21 12:08:40',0,NULL,NULL,NULL,'web','2021-09-21 12:08:40','db65a9dee080e009b204a4a155392159',NULL,0,0.00,'','','',0,''),(367,'MONTSERRAT','FREIXA','SERRA','FOS ASSESSORS','ADMINISTRADOR','PASSEIG DE LA PAU, 47','08600','BERGA','ESPANYA','663769701','montse@fos.cat','39365129P','0','0',1,NULL,NULL,1,'2021-09-21 12:59:57',0,NULL,NULL,NULL,NULL,'2021-09-21 12:59:58','7fc278db3e56045b5b5164d1bb6c1af0',NULL,0,0.00,'','CORREDORIA','',0,''),(368,'MONTSERRAT','RATÉS','VENDRELL','FOS ASSESSORS','COMERCIAL','PG DE LA PAU, 47','08600','BERGA','ESPANYA','663769701','montse@fos.cat','39350476y','0','0',1,367,2,6,'2021-09-21 12:59:57',0,NULL,NULL,NULL,'web','2021-09-21 12:59:58','40cf21a03684873063151785be75bf44',NULL,0,0.00,'','','',0,''),(369,'JOAN','FREIXA','SANCHEZ','FOS ASSESSORS','DIRECTOR TECNIC','PG DE LA PAU 47','08600','BERGA','ESPANYA','607886420','joan@fos.cat','77726387A','0','0',1,NULL,NULL,1,'2021-09-21 13:02:24',0,NULL,NULL,NULL,NULL,'2021-09-21 13:02:25','adc86f585f19e50498842e84dd05afc7',NULL,0,0.00,'','CORREDORIA','',0,''),(370,'JOSEFINA','CASALS','PUJOL','FOS ASSESSORS','PRODUCCIO','PG DE LA PAU, 47','08600','BERGA','ESPANYA','607886420','joan@fos.cat','77732303P','0','0',1,369,2,6,'2021-09-21 13:02:24',0,NULL,NULL,NULL,'web','2021-09-21 13:02:25','52a16223e6eb0b6aa5fffa639112eafb',NULL,0,0.00,'','','',0,''),(371,'MERCE','LLARGUES','ASBERT','LLARGUES MEDIADORS D\'ASSEGURANCES','GERENT','PRAT DE LA RIBA 2 B LOCAL','08290','CERDANYOLA DEL VALLES','ESPAÑA','649239695','llargues@corredoria.es','46646920','0','0',1,NULL,NULL,1,'2021-09-21 16:50:59',0,NULL,NULL,NULL,NULL,'2021-09-21 16:51:00','b5d1afa298d95c986d156c41dc73ca1d',NULL,0,0.00,'','MEDIACION','',0,''),(372,'ANNA','CARNE','BINEFA','CATRISK AGENCIA DE CREDIT S.L.','GERENT','prat de la riba 2b local','08290','CERDANYOLA DEL VALLES','ESPAÑA','649239695','llargues@corredoria.es','43684818K','0','0',1,371,2,6,'2021-09-21 16:50:59',0,NULL,NULL,NULL,'web','2021-09-21 16:51:00','450587bc852041ae2026b1eb48566128',NULL,0,0.00,'','','',0,''),(373,'JOSEP','PÉREZ','MORROS','MGC INSURANCE BROKERAGE, CORREDURIA DE SEGUROS Y REASEGUROS, S.L.','DIRECTOR OFICINA','Tuset 5-11','08006','BARCELONA','ESPAÑA','937882718','jperez@mgc.es','39146781E','0','0',1,NULL,NULL,2,'2021-09-22 11:03:45',0,NULL,NULL,NULL,NULL,'2021-09-22 11:05:34','5367cc927ac0127a002710b4aa55e3ce',NULL,1,120.00,'11030373','CORREDORIA','',0,''),(374,'FRANCESC','DELGADO','RUIZ','','','Tuset 5-11','08006','BARCELONA','ESPAÑA','934143600','francesc@mgc.es','40978101J','0','0',1,373,2,7,'2021-09-22 11:03:45',0,NULL,NULL,NULL,'web','2021-09-22 11:05:34','a2a342b2198a4e9a2ed4e3250142bdf5',NULL,0,0.00,'','','',0,''),(378,'JOSE MIGUEL','ESPINAR','ESPINOSA','MAPFRE ESPAÑA','DIRECTOR OFICINA','C/VALENCIA 372','08013','BARCELONA','ESPAÑA','648656483','jespina@mapfre.com','53066228F','0','0',0,NULL,NULL,3,'2021-09-22 12:02:57',0,NULL,NULL,NULL,NULL,'2021-09-22 12:04:47','b945dc49d538e2922b11065c18ddf21e',NULL,1,60.00,'12020378','SECTOR SEGUROS','',0,''),(379,'MARIA','MARTINEZ','INIESTA','ZALOGAN 10, S.L.','RESPONSABLE','C/ PAU CLARIS, 95 3ª PLANTA','08009','BARCELONA','ESPAÑA','678508719','m.martinez@adean.es','37514471E','0','0',1,NULL,NULL,1,'2021-09-22 16:15:13',0,NULL,NULL,NULL,NULL,'2021-09-22 16:15:14','5f81a0646e3f7f4b24e9876b6c2ecbc5',NULL,0,0.00,'','CORREDURIA','',0,''),(380,'FCO. JAVIER','GARCIA','NIETO','ZALOGAN 10, S.L.','ACOMPAÑANTE','C/ PAU CLARIS, 95 3ª PLANTA','08009','BARCELONA','ESPAÑA','678508719','m.martinez@adean.es','39163800K','0','0',1,379,2,6,'2021-09-22 16:15:13',0,NULL,NULL,NULL,'web','2021-09-22 16:15:14','207315498b0e8c1432c99ed9157bdbca',NULL,0,0.00,'','','',0,''),(381,'Maurici','Torres','Vilamala','','','','','','','666523603','matovi@gmail.com','46125715C','0','0',0,NULL,NULL,1,'2021-09-23 09:07:47',0,NULL,NULL,NULL,NULL,'2021-09-23 09:07:47','15d880b3e6c8aa2b566935f8d27d898f',NULL,0,0.00,'','','',0,''),(382,'GERARD','BAILO','PELEGRIN','ASAP RISK BROKERS CORREDURIA DE SEGUROS, SL','ADMINISTRADOR','C/ ALZINES 16 CASA 2','43761','TARRAGONA','ESPAÑA','661500155','g.bailo@asaprisk.com','47924596W','0','0',0,NULL,NULL,1,'2021-09-23 09:12:22',0,NULL,NULL,NULL,NULL,'2021-09-23 09:12:22','61fad50e376e837e484260bf69215434',NULL,0,0.00,'','CORREDURIA','',0,''),(383,'JAUME','BAILO','ALCALDE','ASAP RISK BROKERS CORREDURIA DE SEGUROS, S,L.','CEO','C/ MORERES 15','43761','TARRAGONA','ESPAÑA','620188065','j.bailo@asaprisk.com','38079150M','0','0',0,382,2,6,'2021-09-23 09:12:22',0,NULL,NULL,NULL,'web','2021-09-23 09:12:22','1a3d88febbdd62d0a464f09f5dc531c9',NULL,0,0.00,'','','',0,''),(384,'ESPERANZA','PALET','PI','GESRISC PALET','CORREDORA','Pl.Dr.Letamendi 1-2','08007','BARCELONA','España','627552712','epalet@gesriscpalet.com','36965347T','0','0',1,NULL,NULL,1,'2021-09-23 09:23:25',0,NULL,NULL,NULL,NULL,'2021-09-23 09:23:25','aae67a714c7bd875e6cd6e5473ecd142',NULL,0,0.00,'','CORREDURIA','',0,''),(385,'MARIA DEL MAR','VENTURA','MARTIN','GESRISC PALET S.L','','Pl.Dr.Letamendi 1-2 1','08007','BARCELONA','','933 900 900','mventura@gesriscpalet.com','46678172V','0','0',1,384,2,6,'2021-09-23 09:23:25',0,NULL,NULL,NULL,'web','2021-09-23 09:23:25','f6e8158f9fb4ef6cf1faef334fca636c',NULL,0,0.00,'','','',0,''),(386,'Josep','Piris','Barrientos','','','','','','','933886299','jpiris@jpiris.com','35096532G','0','0',1,NULL,NULL,1,'2021-09-23 09:40:40',0,NULL,NULL,NULL,NULL,'2021-09-23 09:40:40','42d234ff1224c501708ddfa7e3a093fc',NULL,0,0.00,'','','',0,''),(387,'Carol','Sebastián','Puyo','','','','','','','933886299','carol@jpiris.com','43556734R','0','0',1,386,2,6,'2021-09-23 09:40:40',0,NULL,NULL,NULL,'web','2021-09-23 09:40:40','9e14e31c59ba756b280af86c3e6da6b3',NULL,0,0.00,'','','',0,''),(388,'LAURA','BEAS','MARTIN','MUTUA MADRILEÑA','','DIPUTACION 260','08007','BARCELONA','ESPAÑA','619629380','lbeas@mutua.es','46794300h','0','0',0,NULL,NULL,3,'2021-09-23 10:10:00',0,NULL,NULL,NULL,NULL,'2021-09-23 10:11:27','165ecf473d534cdfe2b551e51f2d1dc0',NULL,1,60.00,'10100388','','',0,''),(389,'Jordi','Dellago','Voto','','','Passeig Mare de Deu del Coll 60, local,','08023','','','627922092','jdvassegurances60@gmail.com','37723463J','0','0',0,NULL,NULL,1,'2021-09-23 10:19:05',0,NULL,NULL,NULL,NULL,'2021-09-23 10:19:05','c9f51c33cf5e0bb5865c45e8c858447b',NULL,0,0.00,'','Corredor','',0,''),(390,'GUERAU','MARTÍNEZ','RODON','Selling Consult','Consultor - Técnico','C/ Sant Francesc, 29','08340','Vilassar de Mar','España','629270729','guerau@sellingconsult.com','43390414V','0','0',0,NULL,NULL,1,'2021-09-23 10:24:58',0,NULL,NULL,NULL,NULL,'2021-09-23 10:24:59','6f02035853a382317626c84b1ade1a19',NULL,0,0.00,'','Consultoría','',0,''),(391,'Meritxell','Morelo','Valcárcel','','','','','','','630471154','mvmeri91@gmail.com','4732886Q','0','0',0,390,2,6,'2021-09-23 10:24:58',0,NULL,NULL,NULL,'web','2021-09-23 10:24:59','2a3c4037aaf6005400fd7e658c4f783c',NULL,0,0.00,'','','',0,''),(392,'EMILI','BORDES','ISERN','BORDES & ISERN CORREDORIA D\'ASSEG., S.L.','ADMINISTRADOR-DIR. TÈCNICO','c/. Agustí Santacruz 3, entl. 1ª','08182','SANT FELIU DE CODINES','España','677346602','emili@bordesisern.com','46655815Q','0','0',1,NULL,NULL,1,'2021-09-23 10:26:54',0,NULL,NULL,NULL,NULL,'2021-09-23 10:26:55','5f6c00cbf704d2ca7ce81246936d1723',NULL,0,0.00,'','Corredoria','',0,''),(393,'MÒNICA','REYES','GALDÓN','Bordes & Isern Corredoria d\'Asseg., s.l.','','c/. Agustí Santacruz 3, entl. 1ª','08182','SANT FELIU DE CODINES','España','677346602','emili@bordesisern.com','34748613y','0','0',0,392,2,6,'2021-09-23 10:26:54',0,NULL,NULL,NULL,'web','2021-09-23 10:26:55','5a0b63ecd456d5becbe9da41228879f3',NULL,0,0.00,'','','',0,''),(394,'JORDI','CAMARASA','ALBIÑANA','FERCAM CORR.ASSEGURANCES, SL','Administrador','c/Mallorca, 576','08026','Barcelona','España','654588793','jcamarasa@fercam.cat','35082115P','0','0',0,NULL,NULL,1,'2021-09-23 10:44:33',0,NULL,NULL,NULL,NULL,'2021-09-23 10:44:34','4798d18da3a2ba04b47ce645d67f3c23',NULL,0,0.00,'','','',0,''),(395,'JOAQUIM','BARÓN','IZQUIERDO','JBARON COVERSEG, S.L.','ADMINISTRADOR ','AVENIDA DIAGONAL 223 BAJOS','08013','BARCELONA','ESPAÑA','607996150','jbaron@coverseg.org','43692492J','0','0',0,NULL,NULL,1,'2021-09-23 10:50:05',0,NULL,NULL,NULL,NULL,'2021-09-23 10:50:05','d36a473122e6ee9028c12138b111843a',NULL,0,0.00,'','CORREDURIA DE SEGUROS','',0,''),(396,'NEUS','MAÑÉ','MATEU','','','','','','','635638408','neusmane@coverseg.org','43453649W','0','0',0,395,2,6,'2021-09-23 10:50:05',0,NULL,NULL,NULL,'web','2021-09-23 10:50:05','62022d3a57bb5e62ba041373dd1d5fd3',NULL,0,0.00,'','','',0,''),(397,'JOSE MARIA ','DE LA PUENTE ','DEL POZO','CICOR INTERNACIONAL','DIRECTOR TECNICO','MUNTANER 292 PPAL','08021 BARCELONA','BARCELONA','España','+34610119730','jm.puente@cicor.es','32851724L','0','0',0,NULL,NULL,1,'2021-09-23 10:54:44',0,NULL,NULL,NULL,NULL,'2021-09-23 10:54:44','bbf0cee66b847c076f518cc65fcc4251',NULL,0,0.00,'','CICOR INTERNACIONAL','',0,''),(398,'JUAN ANTONIO','FERNADEZ ','ONIEVA','CICOR INTERNACIONAL','DIRECTOR COMERCIAL','MUNTANER 292 PPAL','08021 BARCELONA','BARCELONA','España','639753105','ja.fernandez@cicor.es','38445925k','0','0',0,397,2,6,'2021-09-23 10:54:44',0,NULL,NULL,NULL,'web','2021-09-23 10:54:44','29fb6df7e52ddd0e895073a20bf14c5d',NULL,0,0.00,'','','',0,''),(399,'Francesc','Sagarra','González','','','','','','','669868838','fsagarra@jsjoma.es','46766575P','0','0',1,NULL,NULL,1,'2021-09-23 11:39:40',0,NULL,NULL,NULL,NULL,'2021-09-23 11:39:40','f3923ebaaae47306202619da5c1495f8',NULL,0,0.00,'','','',0,''),(400,'Alberto','Navarro','Alonso','','','','','','','610701706','navarroal@oac.segurcaixaadeslas.es','46235323X','0','0',1,399,2,6,'2021-09-23 11:39:40',0,NULL,NULL,NULL,'web','2021-09-23 11:39:40','6374d6853f2a818ffa3c15cfd735650d',NULL,0,0.00,'','','',0,''),(401,'Antoni','Abril','de Diego','','','','','','','619228232','info@corredoriaabril.cat','77080290E','0','0',1,NULL,NULL,1,'2021-09-23 11:45:43',0,NULL,NULL,NULL,NULL,'2021-09-23 11:45:44','c35c68bc33ecb358738ef520d0a498f4',NULL,0,0.00,'','','',0,''),(402,'Mª Elena','Martín','Menconi','','','','','','','619228232','info@corredoriaabril.cat','37263736X','0','0',0,401,2,6,'2021-09-23 11:45:43',0,NULL,NULL,NULL,'web','2021-09-23 11:45:44','b51b429d0c685f66bf59b3e9d0cea7d5',NULL,0,0.00,'','','',0,'');
/*!40000 ALTER TABLE `2021inscripciones` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `colegiados`
--
DROP TABLE IF EXISTS `colegiados`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `colegiados` (
`numero_colegiado` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`nombre_colegiado` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`dni_colegiado` varchar(45) COLLATE utf8_bin DEFAULT NULL,
UNIQUE KEY `dni_colegiado_UNIQUE` (`dni_colegiado`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `colegiados`
--
LOCK TABLES `colegiados` WRITE;
/*!40000 ALTER TABLE `colegiados` DISABLE KEYS */;
INSERT INTO `colegiados` VALUES ('63756','Abadia Lamarca, Manuel','37685661T'),('61639','Abril De Diego, Antoni','77080290E'),('57763','Adell Romero, Guillermo','46122404K'),('73498','Aguilar Garcia, Raimundo','03431996M'),('70435','Aguirrezabal Alarcon, Begoña','38509018A'),('67485','Aineto Cebollero, Luis Maria','40865755E'),('76374','Alarcon Porras, Josep Ramon','46824344R'),('76582','Alasraki Samitier, Anna','46999433Z'),('77030','Albareda Bosch, Jordi','33901197W'),('68805','Albert Balanza, Francisco','38555915A'),('77898','Albet Mayne, Xavier','52215994Z'),('51564','Albiol Biosca, Enrique','37667208Q'),('74824','Alerany Pozo, Maria del Mar','46649653H'),('69985','Alguero Dasca, Rosa','37514471E'),('32830','Alguero Fortuny, Mª Concepcion','37010443Q'),('35748','Alsina Margall, Antoni','36951023M'),('39026','Altayo Reig, Juan','37827235D'),('73504','Altes Clares, Joan','38074916A'),('49652','Altes Esparza, Manuel','46111995P'),('69758','Alvarez Garcia, Vicente','09701963B'),('70287','Alvarez Prada, Francisco','36021866W'),('77390','Alvarez Rodriguez, Miguel Angel','10200915R'),('72083','Amate Miralles, Jose','39161933V'),('13091','Ambros Maseras, Francisco','36488410Z'),('72930','Andersson Oliver, Anna','38152977W'),('60758','Andres Casamiquela, Jesus','37683894G'),('51423','Andres Castillo, Antonio','37307357T'),('64623','Andreu Moreno, Ildefonso','38465143N'),('77351','Andujar Manzanares, Noemi','440047151B'),('65137','Anet Colomer, Jose Maria','46207565J'),('74643','Anglada Camara, David','33949126E'),('77044','Anton Carpinell, Miguel','52215685G'),('55081','Anzizu Furest, Jose Maria','36178786Q'),('76240','Arboles Miralles, Nuria','52596417V'),('75597','Arias Anglada, Enric','46121626W'),('63949','Ariet Xiro, Antonio','37614452E'),('66915','Ariso Espinal, Mariano Antonio','37708458G'),('75596','Arnau Sebastian, Carlos','43693522P'),('76559','Arreaza Garcia, Franz Jose','Y3930832P'),('65595','Arruga Elias, Carlos','46330016N'),('61035','Arteaga Nohet, Jose Luis De','35085870Z'),('77396','Arus Marti, Natalia','44608353Z'),('67953','Auger Jose, Vanessa','43693862A'),('66868','Ayala Vallespi, Francisco Javier','38801424X'),('77330','Aznar Martinez, Alexandre','43684516H'),('48277','Badia Almirall, Manuel','35056096W'),('77939','Bailo Pelegrin, Gerardo','47924596W'),('77740','Baixeras Borrell, Gonzalo','46145570A'),('51937','Balaguer Zanuy, Jose Maria','38039163S'),('45755','Ballaro Riu, Josep','46103883S'),('8933','Ballbe Camps, Maria Josefa','36777283F'),('73149','Ballester Ferra, Miguel Angel','35109230Y'),('63763','Balsells Pardell, Ramon','39822919Y'),('76874','Baltasar Marti, Carlos','46797132K'),('75695','Balza Landaeta, Mayela','X4471713F'),('68305','Banus Teule, Fermi','33889748F'),('71240','Baños De Prada, Jesus Julio','11736063Z'),('62281','Barange Corachan, Elisabeth','46115166M'),('74333','Barcelo Ferrer, Jessica','52596758J'),('65596','Barchilon Amselem, Armando','40977722W'),('71710','Barcons Grau, Josep','37655843J'),('75338','Bardes Cortadas, Josep','46584713F'),('77088','Barea Castillo, Cristobal','46516530L'),('67488','Barniol Simo, Carlos','46326821Z'),('69981','Baron Izquierdo, Joaquin','43692492J'),('74648','Barriocanal Quintana, Mireia','46344349Q'),('73513','Barros Moya, Pasion','39715016L'),('63766','Bartomeu Floreta, Ester','46132962E'),('76292','Bartrina Aulinas, Francesc','35082223R'),('19595','Bassas Miquel, Jose Ramon','37968572B'),('56734','Batlle Estruch, Jose Maria','37585791L'),('74091','Batlle Munilla, Oriol','38129169E'),('37299','Batllori Cruces, Joaquin','36591258Y'),('69872','Baulenas Aulet, Luis','77312196L'),('52616','Baulenas Guiteras, Josep','38161466G'),('53322','Bellart Pedrola, Joan Pere','78068995A'),('70131','Bellmunt Casamitjana, Ruth','38454986K'),('56324','Belmonte Silva, Cristina','36981301S'),('68079','Beltran Lazur, Mª Assumpció','39136283N'),('36096','Benitez Lahuerta, Jose Luis','37749836M'),('55851','Berge Cabezas, Felipe De','46211711L'),('74418','Bernado Mateu, Oscar Fernando','43414123J'),('73150','Bernal Domingo, Alex','52421113L'),('45311','Berruezo Altarriba, Francesc','37669042X'),('52617','Bertran Campaña, Ramon Enrique','35027447B'),('59535','Bertran Canela, Oscar','46331146S'),('838','Bertran Rius, Fernando','37999472E'),('17997','Biarnes Andreu, Jose','36605903T'),('77685','Blanch Grau, Josep Mª','48088626L'),('76880','Blancher Parcerisa, Francisca','46220600F'),('77211','Blasco Ferrer, Montse','37376838K'),('576','Blay Tusquets, Emili','37418722E'),('77736','Blot, François','Y2748857A'),('57100','Bofarull Mora, Manuel','46114638Y'),('67985','Boix Gras, Arturo','39303490D'),('56754','Bonet Alsina, Ferran','46221152F'),('66279','Bonet Andreu, Andres','38432446K'),('59741','Bonet Monllor, Rafael Enrique','77297365T'),('10043','Bonet Vives, Rafael','39598486F'),('76293','Bonet-Godo Duran, Carlos','37741470B'),('75561','Bonilla Barranco, Joaquin','36926681C'),('76962','Bonvehi Pesarrodona, Ignasi','39386453B'),('75824','Bordes Isern, Emili','46655815Q'),('73515','Borras Sanmarti, Francesc','46130791J'),('47990','Bosch Millas, Francisco','37655390C'),('31654','Botella Puigdollers, Eulalia','36624105D'),('76960','Brao Canovas , Alba','47158743A'),('77007','Bravo Gonzalez, Guido','X5508858J'),('55223','Bretos Roma, Enrique','37262907D'),('55171','Bruguera Barbany, Josep','38752933A'),('44162','Brull Rifa, Daniel','37638986S'),('77006','Brumwell Guilera, Roger J.','46129381Y'),('56690','Brunet Vila, Ferran','39269153B'),('55092','Buch Cerda, Montserrat','38770276G'),('69996','Bueso Mata, David','39352603V'),('58097','Burcet Isalt, Jose Luis','37734573Z'),('49622','Busquets Bellavista, Joan','33885299C'),('65076','Busquets Bellavista, Josep','33900068T'),('39558','Busquets Folch, Jaime','39098536P'),('48706','Buti Ferret, Juan Cristobal','37680604A'),('75304','Butjosa Novales, Alejandro','52439797G'),('77046','Caballero Megias, Antonio','46700069H'),('58739','Cabot Duran, Ricardo','46207146P'),('73607','Cacho Gomez, Manuel','44000750W'),('75331','Caldero Martinez, Manuel','53076315C'),('973','Caldero Rodriguez, Andres','37041865C'),('37315','Callejas Roma, Rafael','39102093T'),('77110','Calvo Lafita, Josep','39677743Y'),('69225','Calzado Desvalls, Alfonso','46129301H'),('39331','Calzado Romagosa, Francisco De Asis','46107201K'),('47188','Caminal Canals, Xavier','39154366V'),('48792','Camins Just, Jordi','77095304V'),('9444','Camins Talavera, Sebastian','36332561J'),('77111','Campdepadros Urpi, Sergi','40996019Z'),('56391','Campi Valls, Anna','46212543T'),('76376','Campillo de Anzizu, Enric','46338913P'),('74251','Campmany Muñoz, Xavier','46623016S'),('68970','Camps Badia, Joan','46529489Y'),('68969','Camps Nyssen, Joan Carles','46685802B'),('70970','Camps Salvat, Lluis','40976956H'),('73872','Canal More, Adrian','36975562A'),('43870','Canals Clotet, Esteban','77270447S'),('56326','Cano Canto, Manuel','25552195T'),('57990','Canovas Sanchez,Francisco','37679471C'),('39167','Cañameras Ribas, Josep Maria','77251207A'),('69800','Capell Antich, Jaume','37642784H'),('22464','Capmany Soler, Alfonso','39118955A'),('73810','Carbo Guerra, Jaume','39650935Q'),('70439','Carbo Seriñana, Jordi','35027219J'),('75696','Carbonell Alsina, Chantal','36571819W'),('68792','Carbonell Cuxart, Mateo','37244196C'),('58013','Carles Freixas, Sebastia','77079384J'),('73824','Carmona Marin, Mª Amparo','35108784C'),('75907','Carne Gonzalez, Elena','43429209B'),('49871','Carrera Blasco, Fernando','46312206G'),('51934','Carrera Zubeldia, Alberto','35047034W'),('55227','Carreras Almirall, Maria Montserrat','39328460R'),('48282','Carreras Juanico, Victor','37273128H'),('61346','Carulla Felices, Jordi','33918489K'),('71421','Casadella Pol, Mª Angels','43692549R'),('61328','Casals Reig, Efrem','33931259A'),('64626','Casanova Batlle, Juan Francisco','46117371W'),('60007','Casanovas Vidal, Antoni','77103817C'),('55854','Casas Caballeria, Joaquim','77284308F'),('42690','Casas I Gasso, Enric','46207511M'),('64586','Casas Redorta, Guillem','33934826M'),('53203','Casassayas Ricart, Montserrat','36276396Z'),('44557','Castaños Martinez, Jose Luis','36891801P'),('63783','Castellano De Sola, Ana Maria','36556831X'),('42315','Castells Trius, Juan','77261878W'),('67958','Castellvi Parcerisas, Montserrat','46620197W'),('76181','Castillo Alarcon, Jordi','46620458X'),('75946','Catala Llado, Esteve','38839431K'),('74650','Catasus Corbalan, Jordi','77316312H'),('74532','Cattani, Ugo','X0652297V'),('74370','Cazorla Serrano, David','39141990S'),('76294','Cedeira Comesaña, Borja','76991772P'),('65570','Cercos Santin, Vicenç','46605110A'),('73256','Cerdeño Sanchez, Jose Luis','03828776N'),('76074','Chacon Cuadra, Manuel','38546064L'),('76868','Chamorro Zambrano, Mª Dolores','52157140V'),('61668','Checa Rosado, Ana','46642539B'),('77212','Chico Lucas, Adolfo','44180819G'),('75952','Chiva Ferrer, Lidia','35029380N'),('50073','Cirera Cabeza, Francisco','39147664P'),('46954','Clanchet Casamitjana, Juan','37586748X'),('75562','Claveria Lopez, Marta','52598953T'),('65140','Closa Cañellas, Jose Maria','35049314M'),('66919','Cobacho Antunez, Eustaquio','40967424P'),('44675','Cobo Cisa, Francisco','38763069L'),('72156','Cobo Cordoba, Andres Avelino','40283203Z'),('76490','Codina Fabrega, Ester','52305763Z'),('75692','Codina Fuentefria, Aurora','38794452F'),('66876','Codina Vilardell, Jaume','39324829G'),('70232','Colell Vidal, Alberto Antonio','36912007C'),('61111','Colillas Amills, Luis','77266768Q'),('37022','Coll Ros, Josep Maria','38760825Y'),('42480','Colom Ballonga, Josep ','36722150M'),('72102','Colomer Larrucea, Miren Arantzazu','46611410R'),('58940','Comellas Orriols, Joan Francesc','39161122B'),('55098','Compte Valls, Jordi','46316556F'),('54010','Condeminas Frigole, Narciso','35042265V'),('77723','Conesa Caralt, Marc','46732600G'),('63790','Corbalan Marin, Manuel','77262464J'),('74254','Corchero Sanchez, Jose Miguel','38450247C'),('77583','Cordero Fernandez, Santiago','10188583C'),('76182','Corpas Romero, Ivan','43546643F'),('76241','Corral Martinez, Josep Miquel','53032298W'),('73517','Corral Martinez, Mª Luisa','39178828F'),('29355','Corral Notario, Julian','36638070J'),('77405','Cortes Gil, Carla','46348381T'),('74025','Costa Serra, Jordi','46703526W'),('74026','Costafreda Escofet, Xavier','46140637S'),('57104','Crespi Farres, Josep','77087899H'),('59399','Crespo Peralta, Felipe','39149121Q'),('58014','Creus Ventura, Maria Jose','52190111Y'),('55298','Cristofol Gomis, Jose Maria','77281311T'),('55173','Cruz Pluja, Celedonio','37719386F'),('75856','Cruz Ropero, Fernando','33871960K'),('75685','Cuesta Castillo, Javier','46711730H'),('76076','Cuezva Jimenez, Javier','46142483K'),('71365','Cunill Sola, Francisco Javier','39107405E'),('45654','Da Pena Postius, Xavier','77287744Q'),('70237','Daniel Molina, Llorenç','46650354Y'),('74908','De Gea Nadal, Roberto','38819741L'),('68950','De La Cruz Bajos, Alberto','33883088V'),('77870','De la Puente del Pozo, Jose Maria','32851724L'),('75195','De Quiros Almorin, Ana','35124897X'),('77404','de Temple Jove, Joan Enric','46119308F'),('70092','Del Castillo Aguila, Antonio','37745264X'),('77653','Delgado Pavon, Patricia','43692498L'),('76923','Dellago Voto, Jorge','37723463J'),('69725','Delriu Just, Carmen','77298745T'),('71241','Devahive Francois, Serge','X0224266Q'),('75364','Diaz Diaz, Jose Enrique','38135525F'),('72519','Diaz Luccini, Francesc Xavier','35044976Z'),('68082','Domenech Palau, Josefina','37752999V'),('66250','Domingo Asensio, Mercedes','38492394P'),('76462','Dominguez Martinez, Luis','70484467R'),('60045','Dorado De Olano, Luis','46118198R'),('59742','Dordal Zueras, Ferran','43395021R'),('49354','Dot Palleres, Jose Maria','37633983A'),('75567','Doutres Lopez, Silvia','77316193Z'),('72548','Du Pre Fernandez, Federico','38114794E'),('48771','Duran Lopez, Francisco','77675522Z'),('45756','Duro Lago, Rosa Maria','38039130M'),('54626','Edo Royo, Jose Javier','77730291C'),('72828','Elipe Rodriguez, Francisco','37691446N'),('50712','Escude Torrente, Antoni','39112972T'),('42623','Espinos Perez, Andres','37664213B'),('26906','Espinos Taya, Andres','37804327D'),('60760','Esquius Figueras, Jose Luis','40799210Q'),('12438','Estallo Bartroli, Juan','37704613T'),('39032','Estebanez Castañeda, Maria Asuncion','38282785K'),('43581','Estrada Margarit, Luis','37358517P'),('70673','Falguera Gaminde, Alvaro De','46141228P'),('67986','Farre Estela, Jorge','35019120X'),('73518','Farre Soler, Jordi','52421682J'),('19360','Farreras Sabadell, Antonio','38260934C'),('73776','Felip Roura, Esteban','38500021'),('59184','Felip Soler, Joan','39340507L'),('62851','Feliu Bohera, Juan Maria','46118319F'),('71512','Feliu Canaleta, Jaume','38793122B'),('19829','Fenosa Gabarro, Enrique','37009244J'),('59401','Fernandez Arias, Francisco','33819783P'),('45648','Fernandez Crespo, Emilio','37354072W'),('67987','Fernandez Diaz, Manuel','38432685F'),('76822','Fernandez Llansana, Ruben Jose','46658389Z'),('77893','Fernandez Luque, Monica','47158940Q'),('41267','Fernandez Merino, Dolores','36296911J'),('77929','Fernandez Moreno, Marta','46064265A'),('58105','Fernandez Vicente, Maria','77052171D'),('76088','Fernandez-Bao Rodríguez, Dolors','36932012S'),('51801','Ferre Portero, Jose','35017343G'),('73777','Ferre Revilla, Natalia','46767778S'),('50271','Ferrer Gaya, Jorge','46109189P'),('44889','Ferrer Gaya, Luis','46315780J'),('70668','Ferrer Lopez, Milagros','35082115P'),('73615','Ferrer Martin, Joan','46116279Z'),('77544','Ferrer Ramon, Albert','46146336X'),('71001','Ferrer Santaularia, Jaume ','40870726W'),('44885','Figueras Romeu, Carmen','46311849S'),('51389','Figueras Viñolas, Jordi','38996546T'),('71651','Filella Muset, Roger','35031487A'),('69142','Flo Vidal-ribas, Javier','46231962F'),('72634','Fondevila Lopez, Salome','39684018W'),('69077','Font Escayola, Marti','33866216G'),('57533','Fornies Colas, Luis','37639004X'),('70675','Fortuny Soler, Anna','35062993E'),('75336','Fradera Maestre, Marc','44019752Y'),('58331','Fraile Guijo, Juan','39146133H'),('68506','Franco Arias, Just','35009086G'),('74910','Franco Puyal, Jose Luis','73198348C'),('14679','Freixa Sanchez, Juan','77726387A'),('75948','Freixa Serra, Montserrat','39365129P'),('73507','Freixas Vives, Xavier','38805411H'),('67965','Fuste Paz, Agustin','52207083G'),('61889','Fuste Sole, Ricard','77291967F'),('49046','Galceran Homet, Alejandro','37672772Z'),('39171','Galceran Homet, Carlos','46106006'),('41428','Galceran Homet, Victor','46107351X'),('15436','Galiano Quesada, Antonio','37252556P'),('14563','Galilea Puig, Jose Maria','46311971E'),('53036','Galimany Pubill, Josep','38478192C'),('59420','Galindo Colacios, Antoni','39145638Y'),('74702','Gallego Alfos, Olga','40970316W'),('72546','Gallego Llorca, Fernando','38077328T'),('75332','Gallego Lopez, Francisco Javier','36568311J'),('78159','Gallen Royo, Francesc','38059719D'),('72343','Gallissa Mitjans, Ricard','46117139T'),('18741','Gallofre Llastarry, Manuel','37563976P'),('73916','Galtes Olivella, Joan','46581689L'),('60249','Gamez Lozano, Antonio','39185236K'),('77231','Ganduxe Alejandro, Susanna','52158068W'),('71513','Garcia Ayuso, David','46757071A'),('61114','Garcia Baraldes, Antonio','39295186P'),('56863','Garcia Baranga, Francisco Javier','36890025A'),('70969','Garcia Borobia, Jaime','35112505S'),('76091','Garcia Camuñas, Mario','40999761F'),('78084','Garcia de la Calle, Ricardo','43689387J'),('52347','Garcia Garcia, Pablo','35001966Z'),('56343','Garcia Gascons, Federico','38797141M'),('58028','Garcia Lambea, Enrique','37775328J'),('12037','Garcia Maranges, Jose Maria','37699847H'),('66882','Garcia Medialdea, Maria Rosa','77738766P'),('66883','Garcia Mena, Miquel','35122076H'),('71144','Garcia Molina, Mª José','35104532T'),('57996','Garcia Moreta, Rosa Maria','35103721V'),('71603','Garcia Ribatallada, Marc','46337679Q'),('76705','Garcia Rivadeneira, Elva','53071635D'),('77277','Garcia Rueda, Juan Carlos','52150651Z'),('72107','Garcia Sanchez, David','45482076J'),('75949','Garcia Sanchez, Josep','38848197R'),('68388','Garcia-barroso Arias, Benito','03964564P'),('77866','Garcia-Moreno Morillo, Francisco','46613049F'),('73606','Garcia-Nieto Alonso, Javier','12360291E'),('978','Gardo Montserrat, Eliseo','36268015M'),('1031','Gargallo Buenaluque, Jose Maria','37457977Q'),('55897','Garre Lacalle, Juan Ignacio','37719833V'),('55250','Garriga Caro, Jose Agustin','39299425S'),('67494','Garriga Coderch, Albert','35014424Y'),('75686','Garzon Fernandez, Vicente','37793915Q'),('46233','Gassiot Calvet, Jordi','40791996R'),('63810','Gavin Velasco, Antonio','39022470A'),('76959','Gazquez Sampayo, Sergio','46048053Y'),('54182','Genesca Baraldes, Josep','77273322S'),('12596','Genesca Molera, Climent','36385234Q'),('26881','Genoves Capdevila, Jaime','37423590Z'),('63811','Gerones Lucea, Montserrat','37357697Q'),('60039','Gibert Flo, Victor de','37745193P'),('63956','Gil De Pareja Rodriguez, Jose','38493218G'),('39193','Gil Sallares, Joaquin','38903284A'),('74825','Gimenez Alvarez, Olivia','36524263X'),('77867','Gimenez Meseguer, Teodoro','44418770C'),('60251','Gimeno Gabande, Montserrat','38498679Z'),('73871','Giralt Folch, Carles','47766174G'),('76295','Girbau Pujol, Jaume','53123053E'),('29480','Giro Cunill, Juan ','39240924A'),('61691','Gironella Culubret, Joan','40429117Q'),('55251','Gispert Amoros, Fernando','43683007G'),('59195','Gispert Amoros, Jose Maria','40966608C'),('77960','Gomez Munne, Neus','39885782X'),('77927','Gomez Segura, Ricard','46127183Q'),('54018','Gonell Aparici, Ramon','38486417B'),('72030','Gonzalez Escobar, Guillermo','45461411W'),('15352','Gonzalez Gomez, Francisco','38359503B'),('78160','Gonzalez Gonzalez, Trinidad Gabriel','35048763Y'),('71634','Gonzalez Lois, Jorge','46746255C'),('70661','Gonzalez Martos, Javier','43516845V'),('63955','Gonzalez Sabater, Francisco Javier','35062781V'),('77393','Gonzalez Safont, Joan','46531725B'),('73511','Gonzalez Sarmiento, Juan','39352351H'),('26625','Gorriz Guillen, Sergio','36627259N'),('71809','Gracia Ballesteros, Maria','39156207H'),('18009','Gracia Camps, Maria Victoria','37061491G'),('53671','Gracia Fajardo, Dionisio','17399273A'),('9991','Granados Valdepeñas, Jose Maria','38282814G'),('73521','Gras Graupera, Jordi','38827684G'),('74978','Grau Alcaine, Ignasi','39894476X'),('43942','Grau Baulo, Juan','77884312X'),('33360','Grau Claravall, Dolors','37634554E'),('74646','Grau Paredes, Jordi','52460010T'),('41402','Grau Passarell, Carles','39027096Y'),('70089','Grau Pujadas, Gregori','46223255V'),('51838','Grimal Verdura, Marc','77100873C'),('18694','Gros Vilageliu, Francisco','36397449H'),('77891','Guerrero Medinilla, Silvia','47190960C'),('76961','Guillamon i Bruguera, Jordi','46046332X'),('44961','Guillamot Vallribera, Miguel','46319632R'),('55898','Guix Borrell, Jaime','37226219Y'),('77908','Guix Oller, Montserrat','39381414D'),('73829','Guma Mas, Albert','46584521E'),('20092','Guma Puiggros, Jose','36321509R'),('52342','Gutierrez Espinosa, Salvador','46032512J'),('69603','Gutierrez Fuentes, Alex','38108763V'),('67968','Gutierrez Garcia, Luisa','43495176Z'),('63929','Heredia De La Piedad, Esmeralda','36966387M'),('77043','Hereu Morales, Pau','46450707E'),('55255','Hernandez Bueno, Jose','33880280S'),('46773','Hernandez Catala, Miguel','37664327X'),('70771','Hernandez Reyes, Marta Elena','52424603J'),('72338','Herrera Ventura, Carlos','35007821G'),('43448','Hijos Gonzalez, Jose Miguel','37784856L'),('74027','Hilari Doce, Josep','77608025E'),('69566','Homs i Ferret, Carmina','46212797R'),('75340','Horta Casassayas , Merce','35094263N'),('41401','Hosta Soldevila, Luis','37262758K'),('75691','Hoya Muñoz, Francisco Jose','45464048V'),('39165','Iglesias Sarret, Juan','36591634Z'),('37191','Iglesias Vives, Ricardo','37047420D'),('30488','Insa Conca, Rafael','20283453Y'),('70233','Irisarri Sola, Vicente','46019467D'),('75337','Jarabo Fidalgo, Jordi','43695393Q'),('73144','Jimenez Alvarez, Carolina','52275074F'),('14675','Jimenez Castell, Sandalio','36231614J'),('52676','Jimenez Gomez, Manuel','46028766Q'),('73827','Jimenez Serrano, Manuel','43395577M'),('69482','Jorba Castells, Mª Del Pilar','39330220J'),('72931','Jorba Soteras, Imma','37684365S'),('54021','Jordan Gomez, Francisco Javier','38055841H'),('39002','Jori Armengol, Amadeo','37615145W'),('77392','Jornet Figueras, Carlos','46240166T'),('49023','Jounou Alborna, Antonio','37638725F'),('75599','Juan Balsam, Carme','38100954M'),('77400','Juan Sart, Lidia','34758828D'),('55868','Julia Orpi, Francisco','37638470M'),('53675','Julian Olivan, Emilio','43405157V'),('61331','Juncosas Mitjans, Miguel','46661479E'),('64598','Junyent Carrillo, Daniel','46586267C'),('54022','Junyent Carrillo, Josep','37372478P'),('56879','Lacal Hueso, Isidro','38546275T'),('70773','Lacasa Valls, Rafael','43073120P'),('53042','Lacuesta Hernandez, Rigoberto','43495891Q'),('77426','Laffite Sola, Pau','46362041K'),('61116','Lago Dominguez, Nestor','46119448D'),('76824','Laguna Martinez de Albeniz, Miguel','43458074B'),('58694','Lahoz Mora, Tomas','37355616M'),('69874','Leon Mendez, Juan Antonio','79271585S'),('77808','Llargues Asbert, Merce','46646920E'),('73778','Llobet Pineda, Lourdes','37382069P'),('76460','Llompart Gordillo, Daniel','35044102Z'),('75083','Llorens Fabregat, Irma','43515302S'),('55126','Llorente Ferrer, Jose Maria','39304720C'),('52343','Lobato Pimentel, Mateo','24091047L'),('72545','Lodhi, Michael','702998266'),('74531','Lopez Balcells, Javier','46570158B'),('555','Lopez Balcells, Jose Antonio','36627387W'),('76093','Lopez Bonafonte, Abel','46813770F'),('63838','Lopez Jara, Elena','36594448E'),('54049','Lopez Lizondo, Modesto','37252931S'),('60220','Lopez Miras, Pedro','36509515M'),('63839','Lopez Nicolau, Jose','46027847V'),('77722','Lopez Parra, Raul','52622519Z'),('77749','Lopez Rodriguez, Jose Antonio','43537628P'),('63930','Lopez Salvador, Jose Luis','39163211F'),('77841','Lopez Santiago, Miguel Angel','43496695S'),('77313','Lopez-Balcells Alvarez, Manuel','37291344H'),('72341','Loredo De Izcue, Juan Antonio','50858441J'),('37302','Lorente Gomez, Cesar','17803932T'),('73617','Lorente Gutierrez, Maria Esther','46800230Z'),('78005','Lorenzo Moreno, Chelo','38103269C'),('78121','Lucca, Tommaso','Y3263327D'),('51830','Luis Reverter, Antonio','38743357H'),('48744','Luna Bravo, Joaquin','37726931P'),('73249','Luzuriaga Biarnes, Roser','40514619G'),('77185','Machado Cabrera, Cesar Abraham','Y3997482G'),('53724','Macia Calmet, Josep','39318795L'),('77882','Macia Oferil, Cristina','33940660C'),('50679','Maeso I Lebrun, Miquel','38998271T'),('73616','Maeso Sole, Jordi','33888214Z'),('56710','Magriña Sole, Maria Del Carme','37735257P'),('49635','Male Fajula, Joaquin','40290698B'),('76579','Mante Prats, Carles','38810972J'),('74330','Marañes Vidal, Josep Ramon','34755739W'),('75771','Marcial Camuñez, Jorge','34750824D'),('69995','Marcos Villescas, Gumersindo','43689615B'),('55179','Maricalva Robles, Miguel Angel','37651343K'),('59529','Marin Gallardo, Manuel','39022072L'),('77041','Marin Moreno, Salvador','52634375W'),('71358','Maroto Borras, Jose Luis','38060581C'),('58689','Marques Baro, Joan','35006408V'),('41174','Marti Carrasco, Antoni','37703373W'),('75776','Marti de la Fuente, Uriel','47604685K'),('56397','Marti Escursell, Miguel','39022054R'),('76581','Marti Gascon, Ramon','46335080Q'),('71636','Marti Ruiz, Manuel','37673910W'),('77559','Martin Aisa, Olga','43683343H'),('75950','Martin Cachon, Andres','52629496E'),('75857','Martin Cachon, Eva','52623950L'),('56712','Martin Sales, Jose Miguel','36509079Y'),('75793','Martin Vallespin, Ruben','52406916J'),('53046','Martin Zamora, Javier ','46122482F'),('68625','Martinez Balastegui, Agustin','37307825P'),('56403','Martinez Bernabe, Antonio','37757044Z'),('11205','Martinez Daniel, Emilio','37807646Q'),('48780','Martinez Garrido, Francesc','38721587Y'),('77084','Martinez Gonzalez, Sonia','43513800P'),('71635','Martinez Ivars, Isidre','43390414V'),('67691','Martinez Maldonado, Juan','39662925T'),('78158','Martinez Olivenza, Immaculada','52167840'),('77560','Martinez Regales, Lleonard-Sebastia','36977660P'),('26855','Martinez Torrecillas, Jose Maria','40937103R'),('77186','Martinez-Seara Monne, Fontcalda','46711794J'),('71871','Martorell Basurte, Alejandro','35028585E'),('34144','Martorell Marti, Jaime','37645981H'),('57130','Mas Bigas, Juan','33864988H'),('73501','Mas Garcia, Augusto','36978712W'),('52642','Mas Pares, Jordi','39306334R'),('59188','Mas Rosas, Carlos Ivan','49187606J'),('51924','Mas Sanchis, Francesc Xavier','37694159B'),('75797','Masa del Moral, Gerard','40341243W'),('77979','Masats Buendia, Maria del Mar','4673889J'),('72547','Masdeu Baques, Ester','77320057Z'),('77331','Masip Pipo, Mª Teresa','46664022N'),('62254','Masramon Pla, Joan','39314391P'),('49579','Massague I Riu, Pere','46660596J'),('49027','Massons Rabassa, Cristina Eugenia','46202036G'),('74805','Massuet Soler, Montse','38826451J'),('76703','Mata Martin, Nuria','37330179Y'),('52644','Mataro Moreno, Jose Maria','77286747P'),('60017','Mateo Font, Galo','37253949K'),('49049','Mateu Bort, Josep Lluis','40942305M'),('63935','Matias Aibar, Jose','27900847F'),('75446','Mayol Homs, Oriol','47646496H'),('20900','Mayordomo Arpa, Jaime','39293578X'),('72579','Mellado Ferreiro, Araceli','45488690A'),('70328','Mercader Fernandez, Cesar Augusto','43688930Q'),('55132','Mestres Gils, Isabel','46014058M'),('70676','Mestres Travería, Magi','39326209G'),('48263','Meya Rovira, Jorge','38072377V'),('69921','Miguel Batista, Juan-carlos','37289294S'),('42989','Miguel Galindo, Frco.javier','36906605T'),('51086','Miguel Ruiz, Laurentino De','12711841V'),('54656','Milian Olive, Josep','38478010E'),('76704','Mingote Alvarez, Andreu','36525461N'),('72264','Miñano Canovas, Mª Jose','38555978C'),('61351','Miquel Domenech, Jose Antonio','46314777E'),('77384','Miralles Garcia del Valle, Alejandro','43438401A'),('55876','Miralles Pey, Maria Teresa','35105455A'),('64633','Miro Borrell, Eduardo','35030011E'),('71921','Miro Panzano, Marta','33960719T'),('56359','Molina Gol, Sergio','37722457L'),('55268','Molina Hernandez, Juan','36503513Y'),('46412','Molina Moreno, Manuel','25293700W'),('60755','Molina Tena, Miguel','77625491P'),('58019','Monaco Rosich, Jose Maria','46207602G'),('78102','Mongay Soler, Montserrat','46642161R'),('62284','Monllor Carmona, Orencio','46315713S'),('76492','Mons Pujol, Josep Mª','46526647Q'),('70440','Mora Hoyos, Julio','46653146S'),('68503','Morante Valverde, Maria Del Carme','52192611E'),('49028','Morato Prats, Lluis','46325099V'),('58943','More Piera, Salvador','36967381X'),('77493','Morell Riera, Marcelo','38769462H'),('72029','Moreno Bellerino, Luis Manuel','33903357T'),('74243','Moreno Cardenas, Francisco','52217164B'),('77789','Moreno Palacios, Lorena','47152493D'),('72760','Morera Casablancas, Marc','34749355N'),('76963','Morera Uris, Clara','37315854X'),('37865','Muelas Fernandez, Diego','39019614E'),('74093','Mula Armero, Josep','46620862T'),('44163','Nadal Ribas, Rafael','36468366A'),('75823','Navarro Aguilera, Mª Pilar','33933168A'),('73143','Navarro Lascorz, Vanessa','38106176Y'),('77894','Navarro Martinez, Alberto','46559570A'),('68840','Navaz Guinea, Martin-jose','37726096R'),('72034','Naya Foved, Jose Luis','38414887B'),('76937','Nicolás Guitart, Xavier','47983982W'),('76183','Nicolau Lopez, Juan Ignacio','35103637W'),('76114','Noguera Coll, Joan','45491376K'),('70359','Nonell Corominas, Alfons','39022143K'),('58120','Novellas Rodriguez, Maria Lourdes','52142094J'),('77395','Nuñez Alvarez, Cesar','37279577G'),('644','Nuñez Clemente, Jose Luis','37427597L'),('58944','Nuñez Navarro, Josep Lluis','35008397M'),('42845','Obis Artal, Jose','40959752H'),('49656','Ojeda Portillo, Juan','37269745Q'),('62836','Ojeda Zambrano, Jose','38029349E'),('72031','Oliva Gila, Antonio','77605037R'),('76378','Oliva Mata, Marc','52309755G'),('58003','Olivares Carrera, Albert','35101089F'),('55881','Oliver Sola, Maria Teresa','77098269S'),('46429','Olle Bertran, Juan','36910623Q'),('44470','Oller Miro, Jaume','33930371N'),('77542','Oller Ochaita, Marta','46147224R'),('74537','Oñate Garcia, Juan Pedro','43684548G'),('75365','Orrit Borregan, Albert','43442772G'),('51088','Ortiz Casas, Felipe','37355451R'),('75566','Ortiz Costa, Marc','45638027R'),('74331','Orts Forns, Xavier','35069976J'),('60049','Orue Pamies, Jose Maria','39843619Y'),('54663','Pachan Vilalta, Nicolas','37039002D'),('75773','Paez Sacristan, Josep','38080210F'),('64605','Pages Noes, Luis','38486592W'),('61686','Palacio Albero, Juan Domingo','17977590P'),('41176','Palau Sola, Esteban','37642363B'),('50075','Palet Pi, Esperanza','36965347T'),('77825','Palma Cabrera, Angel','47152135L'),('73614','Palma Corredor, Benito','45462118L'),('63859','Palma Pizarro, Juan Manuel','80112761N'),('77350','Palmes Orero, Cristina','46653893A'),('75777','Palomino Alzaga, Antonio','33968238K'),('47500','Panes Ferrer, Jordi','38422651R'),('74945','Pape, Christina','X0353621L'),('14617','Parera Cardus, Joan','37185897A'),('78085','Parera Gol, Ismael','44012703H'),('77791','Pares Gonzalez, Albert','47814754P'),('53244','Paret Mora, Ramon','77080506P'),('77232','Parrilla Miñano, Alex','47994188L'),('76731','Parrilla Miñano, Sara','47994498F'),('49345','Parrilla Navarro, Jordi','38555207P'),('73502','Paya Fusalbas, Elisabeth','46543563G'),('75303','Pedragosa Casamitjana, Francesc','46529966T'),('60021','Pedrol Rebull, Francisco','39858930E'),('75082','Peña Coca, Artur','38069620C'),('71670','Peña Morales, Gracia Maria','39330292Q'),('51411','Perarnau Torne, Jordi','33875040L'),('53726','Perea Conillas, Pere','38417652Q'),('68839','Perello Vila, Miquel','37679795E'),('75363','Perera Molina, Maria Nieves','16041029R'),('77868','Perez Escudero, Isabel','46581951M'),('72667','Perez Gonzalez, Luis','40961332B'),('73146','Perez Martinez, Eduardo','43392988S'),('67471','Perez Moles, Javier','43407679D'),('62854','Perez Navarro, Carles','35101283V'),('43954','Perez Parra, Agustin','36481365F'),('70158','Perez Planella, Mª Dolores','46239566K'),('75694','Perez Riera, Marc','53121483Q'),('57324','Pi Basolas, Eulalia','37262592Q'),('67473','Pi Puig, Lluis Maria','46216309V'),('42629','Picornell Esteve, Julio Maria','46314367A'),('69197','Pie Fonolla, Maria Jesus','46503628C'),('41051','Piera Vila, Jose','37354629F'),('56882','Pinazo Rodriguez, Maria Carmen','77279802D'),('77385','Pineda Galvez, Emili','38147724Q'),('75689','Pintos Mascaro, Josep','37315264H'),('11468','Piñero Planas, Joan','39280744X'),('56723','Piñol Soria, Antonio','36191562G'),('40165','Pique Fajas, Miquel','46315643Z'),('72887','Piris Barrientos, Josep','35096532G'),('73528','Pla Brunet, Rosa Mª','77113440Y'),('74874','Pla Cabedo, Ramon Jorge','35047443C'),('42874','Pla Sociats, Pedro','77725479S'),('71813','Plana Saulo, Janina','38128406H'),('72269','Planas Soler, Manuel','38784396W'),('57547','Planella Adria, Guillem','38056874Q'),('61654','Planells D´ocon, Maria Pilar','19471354Z'),('76379','Plaza Pascual, Francesc','46718067F'),('73503','Pociello Majoral, Jaume','39346917N'),('77890','Ponce Campillo, Paquita','44986606D'),('70330','Pons Duran, Bernat','77605206D'),('74456','Pons Duran, Janina','77605205P'),('42689','Pons Juli, Joaquim','38707822H'),('75367','Pons Marques, Pedro','37683529F'),('69605','Pons Sabater, Ferran','40966618F'),('38081','Pons Sola, Jose De','36710772N'),('14622','Pons Tubau, Jose','38330756Z'),('19025','Pont Net, Jaime','38639350V'),('41105','Porta Roca, Pere','39628270Y'),('44559','Portillo Aragay, Juan Manuel','39136689G'),('78101','Portus Noguera, Albert','33947954T'),('38477','Pous Layret, Josep Maria','38737495K'),('41891','Prades Mompart, Rafael','38966471D'),('73153','Prat Camps, Eduard','33934459Y'),('22107','Prat Clara, Albert','39217100F'),('58113','Prat Vilar, Albert','38779863T'),('50719','Prats Pardo, Pere','37698777Y'),('72157','Prim Jorda, Josep Oriol','38103834X'),('58347','Pruna Dominguez, Jose','77298025Q'),('57756','Puente Fluvia, Jordi','46534871Y'),('76463','Puig Eyre, Raimundo','43680555J'),('78004','Puig Gonzalez, Esther','44985060G'),('73250','Pujadas D´osso, Oriol','33896818Q'),('53727','Pujol Argemi, Josep','33876722'),('22110','Pujol Badia, Josep','39278537B'),('73151','Pujol Carbonell, Francesc','39347252W'),('55146','Pujol Carbonell, Lluis','39320129L'),('77840','Pujol Gendrau, Marc','39351121F'),('77899','Purja Garcia, Jessica','36516715Y'),('61500','Puyol Miro, Josep Ramon','41094952R'),('76113','Quesada Imbernon, Betsaida','43446183B'),('72678','Quintana Pou, Jordi','52144074S'),('76073','Ramos Rodriguez, Marina','40981881K'),('74804','Raya Cortes, Juan Jose','35040784P'),('53059','Raya Guillen, Concepcion','36905677S'),('63963','Redondo Garcia, Daniel','36920568W'),('76580','Regaño Pozo, Alba','43567988P'),('61906','Reixach Morales, Carlos','52141284P'),('73529','Retali, Bernard','X3476079C'),('72339','Ribe Salat, Monica','38105558D'),('70780','Riera Manresa, Ana','46125646C'),('77406','Rios Gracia, Vicente','40968016W'),('74911','Ripol Malet, Javier','46117995M'),('76266','Riquelme Zurita, Lluis','40322461B'),('66272','Riu Rovira De Villar, Angels','37253444'),('77978','Rius Pinya, Jordi','Y5415190S'),('71811','Roca Nogue, Jaume','77294279L'),('70358','Rocha Montoliu, Maurici','35045638D'),('33414','Rocha Sanz, Abel','38632834X'),('44156','Rodes Gubern, Raimundo','37311331H'),('56727','Rodriguez Farfan De Los Godos, Carlos','36843813K'),('42986','Rodriguez Fernandez, Miguel','37305770T'),('45656','Rodriguez Galvez, Joaquin','36924165B'),('73530','Rodriguez Hotellerie Fallois, Elisabeth','46739343P'),('77042','Rodriguez Lagunas, Aureli','44006329S'),('31725','Rodriguez Ruperez, Maria Del Carmen','16916601D'),('73612','Rofas Cires, Juan','37746313R'),('75301','Roig Soler, Eloi','47640543'),('78152','Rojas Castillo, Josep','52162559P'),('76370','Romagosa Lluch, Josep','46132444X'),('77427','Romero Chamorro, Victor','46805445P'),('63939','Ros Bordes, Maria Teresa','46227896N'),('53226','Rosell Pujol, Josep Maria','35001521Y'),('77966','Rosell Pujol, Xavier','39333502Y'),('54684','Rosello Valentin, Ramon','46315656G'),('77790','Roses Flores, Luis','47711334L'),('7068','Rosich Ribas, Antonio','36583563Q'),('75951','Rotllan Duran, Elisabeth','40432415W'),('60024','Rotllan Pare, Martí','77103740N'),('74806','Rovira i Obradors, Santi','77731202B'),('77741','Rovira Isanda, Fernando','35043763C'),('48722','Rovira Simo, Jaime','36477372Q'),('68091','Ruano Garcia, Pedro','07789255Y'),('75193','Rufe Jorba, Montserrat','46610998A'),('49890','Ruiz Barroso, Isidro','76221910W'),('74530','Ruiz Dotras, Anna','43689876L'),('41411','Ruiz Ferrer, Enrique','38477218N'),('78006','Ruiz Mirones, Francisco Javier','39170902Q'),('77869','Ruiz Mora, Francisco','46709182T'),('9947','Ruiz Vigo, Justo','36416301X'),('75976','Ruz Cazorla, Pedro','35035854T'),('73605','Ruz Martin, Jose','46803887Z'),('63889','Sabate Jorba, Maria Antonia','37742763Q'),('54036','Saco Garcia, Luis','74953345W'),('47951','Saez Perez, Ramon','37251646H'),('70684','Sagarra Gonzalez, Francesc','46766575P'),('63965','Sainz De Baranda Puig, Manuel','46315590F'),('77807','Saiz Garcia, Ester','46795352N'),('34223','Sala Barange, Ignacio','37094613Y'),('75822','Sala Costa, Valenti','46341878Y'),('15348','Sala Llargues, Joan','38998014L'),('77083','Salas Arboli, Cesar','43409228V'),('53729','Salas Ecer, Jose Luis','35088889C'),('58125','Salgueiro Armengot, Marc','38500533M'),('59414','Samitier Hurtado, Felip','38056308W'),('62269','Samitier Soto, Jorge','46017953J'),('62859','Sanchez Calvo, Maria Jose','37287427B'),('62271','Sanchez Cuevas, Tomas','46666804B'),('53238','Sanchez De Ocaña Bravo, Gabriel','46115961H'),('57122','Sanchez Lopez, Ramon','46528640P'),('69818','Sanchez Molina, Jose Antonio','77905955X'),('72268','Sanchez Naves, Monica','52216344L'),('71441','Sanchez Villalba, Atanasio','46325854J'),('66905','Sanfeliu Vila, Simo','39332914Q'),('56376','Sanglas Serradell, Maria Angels','77726454R'),('40539','Sanmartin De Jodar, Ricardo','36952985N'),('72342','Sanmartin Mases, Ricardo','46358104V'),('70434','Santamaria Martinez, Cesar','12688783M'),('53239','Santasusana Ribo, Josep','39333944B'),('53240','Santasusana Riera, Francesc','39312604S'),('77788','Santasusana Rius, Mariona','39397432L'),('77523','Santoro, Anton Carlo','Y4764019C'),('76907','Santos-Olmo Barragan, Joan Josep','43416086K'),('77928','Sas Vidal-Ribas, Pablo','35048437W'),('32461','Sastre Pascual, Jose','38945726X'),('74094','Sauque Alcrudo, Cayetano','40964054L'),('68393','Sebastia Bafaluy, Berta','37724278T'),('69089','Sebastian Dolz, Jose Angel','37315260Z'),('74458','Secanell Viladot, Josep Maria','43719275R'),('71810','Segarra Miret, Albert','35060194Y'),('73828','Segui Perez-caballero, Mateo Ignacio','46142549H'),('69979','Segui Prat, Francesc','39350462S'),('72104','Segura Baños, Felip','46537166R'),('76375','Segura Santamaria, Itziar','46342187Q'),('77892','Sellares Guarro, Joana','47844556W'),('53710','Sells Bruguera, Enrique','46318355N'),('70666','Serarols Fajas, Jaume','46582393X'),('74701','Serra Frontera, Lorenzo Jose','35005802D'),('56873','Serra Garcia, Jacint','36908874S'),('78148','Serra Muñoz, Sergi','52216209'),('63905','Serra Pifarre, Eduardo','41074925F'),('71711','Simon Anguera, Francesc','38115787A'),('61124','Simon I Picher, Josep Manel','35030168H'),('71146','Sisquella Enjuanes, Luis','46641271P'),('70331','Sola Castel, Xavier','41094640B'),('74649','Sola Catala, Joan','33935878'),('47956','Sole Franco, Jorge','37250025F'),('72265','Sole Rabella, Silvia','35104638Z'),('70436','Soler Sanglas, Guillem','77311885F'),('57761','Sosa Naranjo, Antonio','40846609N'),('76112','Spitzer, Gunther Kark Heinz','X5834244H'),('61125','Suarez Garcia, Jose Carlos','36018742Y'),('48714','Subias Sanchez, Silvia','36917341H'),('65132','Subira Esteller, Jorge','35038237Z'),('10880','Suque Puig, Arturo','36990117'),('67598','Surribas Garcia, Ramon-victor','37260103B'),('67727','Tarin Puig, Santiago','46110007K'),('70389','Tarinas Salichs, Xavier','35097066D'),('51018','Tarrada Gol, Juan','77090002M'),('70363','Tarradellas Gordo, Anna','46351698M'),('63910','Tarrida Riba, David','38559984R'),('60050','Tell Cerexhe, Javier','46228266Z'),('67599','Tello Ruiz, Antonio','39331667B'),('65117','Terron Bazaga, Jose Manuel','36976627X'),('76243','Tizon Pujals, Manuel','37288677L'),('69700','Tomas Diago, David','46034939W'),('75910','Toro Martínez, Gerard','43514597T'),('65133','Torra Badia, Maria','36953311Q'),('76710','Torras Bernal, Cristina','52210902M'),('70727','Torres Garcia, Irene','46601659W'),('75564','Torres Vilamala, Maurici','46125715C'),('38891','Tort Tosal, Antonio','77259019H'),('70156','Traby Marine, Enric','43418888V'),('76821','Trasobares Llorens, Monica','38124159A'),('65119','Tresserra Barba, Montserrat','35043169R'),('74976','Trigueros Marti, Mª Carmen','52208732C'),('75855','Trillo Rodriguez, Jose Luis','77105987M'),('75559','Trullols Rodriguez, David','38441927A'),('77543','Tusell Artigas, Pau','46145759P'),('76092','Tuset Rebull, Natalia','52196866'),('73823','Ubach Altirriba, Joan','45462806V'),('54042','Ubiergo Lopez-munte, Mateo','46213539F'),('72888','Urtusol Carreras, Francisca','77263966C'),('70132','Usach Rofes, Enric','36978341'),('68092','Utesa Cami, Josefa','39037359B'),('66912','Vallbona Pujol, Inmaculada','33933389V'),('73505','Valldosera Brell, Josep','36514239Z'),('45766','Valles Parellada, Miguel','37251713Q'),('54043','Valls Marata, Joaquim','77278770N'),('76087','Vallve Banus, Xavier','39728531X'),('39045','Vancells Espel, Jose','39298083F'),('67483','Vazquez Gomez, Jose Carlos','46662460Z'),('75302','Vear Sanchez, Gustau','43416223C'),('67728','Vear Sanchez, Joaquin','43415153P'),('29463','Vega Mendez, Manuel','08379273M'),('62845','Velasco Osete, Fulgencio','52211641P'),('58695','Ventin Camprubi, Juan Carlos','46215876K'),('58024','Ventura Queija, Santiago','46227524P'),('37221','Verdaguer Serrat, Josep Maria','77272899Y'),('70731','Verdaguer Serrat, Ramon','33931018S'),('73244','Vergara Martinez, Vanesa-victoria','46734184R'),('57125','Verges Tubau, Imma','77287837V'),('76147','Viaplana Blasco, Rosa','52436761G'),('10578','Viaplana Prat, Joan','38970290X'),('77085','Vicente Palacio, Josep','35110467R'),('73531','Vidal Vidal, Francesc','35072010T'),('39917','Vidal Vinaixa, Jose','46203643R'),('47517','Vidal-ribas Recolons, Marta','37674085Q'),('69759','Vigue Pujol, Miquel','40602462X'),('73610','Vila Borque, Vanessa','46821088B'),('10956','Vila Busquets, Pedro','39198646'),('40076','Vila Calsina, Manuel','39282528T'),('61044','Vila Escalada, Angel','38792446W'),('72266','Vila Forcadell, Mireia','46744837M'),('58685','Vila Nuri, Jordi','77273867P'),('76184','Vila Poca, Josep Maria','39844526Q'),('45326','Vila Puig, Xavier','46322140W'),('67984','Viladecans Lacasa, Joaquim','33931167A'),('55900','Viladoms Genero, Maria Carmen','39006372M'),('73836','Vilalta Reixach, Guillem','77743542T'),('34712','Vilalta Riera, Jose','77263350W'),('64621','Vilanova Gregori, Montserrat','46551197W'),('76075','Vilarrasa Puig, Jaime','40972405K'),('78125','Vilaseca Conesa, Anna','44011695'),('70779','Vilaseca Sole, Emilia','39340581R'),('40538','Vilella Llovet, Antonio','38468252Q'),('72028','Villar Saltiberi, Sonia','34733953C'),('74877','Vinyals Faura, Salvador','43698858P'),('69160','Vinyes Casajoana, Jordi','34732088H'),('75196','Vinyeta Punti, Josep Mª','77296114Z'),('69247','Vives De La Cortada Bechtold, Joaquin','35033176J'),('56387','Vosseler Navarro, Julio','X010583N'),('73915','Wolters, Johannes-jacobus','X6049882P'),('74642','Zamora Jarque, Miguel Angel','46563610H'),('68312','Zaragoza Ferrer, Jaime','38490485P'),('76873','Zoroa Mena, Isabel','46549723T');
/*!40000 ALTER TABLE `colegiados` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `usuarios`
--
DROP TABLE IF EXISTS `usuarios`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usuarios` (
`id_usuario` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nombre` varchar(64) NOT NULL,
`descripcion` varchar(64) NOT NULL,
`password` varchar(32) NOT NULL,
`activo` tinyint(4) NOT NULL DEFAULT '1',
`fecha_alta` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id_usuario`),
UNIQUE KEY `nombre` (`nombre`),
KEY `password` (`nombre`,`password`,`activo`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=big5;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `usuarios`
--
LOCK TABLES `usuarios` WRITE;
/*!40000 ALTER TABLE `usuarios` DISABLE KEYS */;
INSERT INTO `usuarios` VALUES (1,'anonimo','Usuario anonimo','-',1,'2013-04-18 20:00:00'),(2,'gonzalo','gonzalo','d53cfc2a4c508a09dfb115a2e6100de4',1,'2012-12-19 08:59:37'),(3,'Admin','Administrador','294228dbca14b20d3a7f8d206589c185',1,'2012-12-19 08:59:37'),(4,'Usuario','Usuario normal sin permisos de lectura escritura a1b2C3!$','9a391c400c16ae54cff798a8aabf198b',1,'2016-09-04 09:39:00');
/*!40000 ALTER TABLE `usuarios` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `usuarios_acciones`
--
DROP TABLE IF EXISTS `usuarios_acciones`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usuarios_acciones` (
`id_accion` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nombre` varchar(64) NOT NULL,
`comentario` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id_accion`),
UNIQUE KEY `nombre` (`nombre`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=big5;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `usuarios_acciones`
--
LOCK TABLES `usuarios_acciones` WRITE;
/*!40000 ALTER TABLE `usuarios_acciones` DISABLE KEYS */;
INSERT INTO `usuarios_acciones` VALUES (1,'Login','Usuario autorizado a hacer login en el sistema'),(2,'Administrador del sistema','Administrador del sistema'),(3,'Usuarios','Gestión de usuarios'),(4,'Administrador','Administrador de contenidos');
/*!40000 ALTER TABLE `usuarios_acciones` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `usuarios_permisos`
--
DROP TABLE IF EXISTS `usuarios_permisos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usuarios_permisos` (
`id_permiso` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id_usuario` int(11) unsigned NOT NULL,
`id_accion` int(11) unsigned NOT NULL,
PRIMARY KEY (`id_permiso`),
KEY `id_usuario` (`id_usuario`),
KEY `id_accion` (`id_accion`),
CONSTRAINT `fk_usuarios_permisos_1` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id_usuario`) ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT `fk_usuarios_permisos_2` FOREIGN KEY (`id_accion`) REFERENCES `usuarios_acciones` (`id_accion`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=big5;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `usuarios_permisos`
--
LOCK TABLES `usuarios_permisos` WRITE;
/*!40000 ALTER TABLE `usuarios_permisos` DISABLE KEYS */;
INSERT INTO `usuarios_permisos` VALUES (1,1,1),(2,2,1),(3,2,2),(4,2,3),(5,2,4),(6,3,1),(7,3,4),(8,4,1);
/*!40000 ALTER TABLE `usuarios_permisos` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2021-09-23 11:59:29