11-06-2023, 06:38 PM
sql file it has 77549 ~ useful records
contain names , phone numbers , address email and more
DROP TABLE IF EXISTS `padron`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `padron` (
`id_padron` int(11) NOT NULL AUTO_INCREMENT,
`id_unidad` int(11) NOT NULL,
`tipo_padron` varchar(50) NOT NULL,
`nombre_padron` varchar(100) NOT NULL,
`paterno_padron` varchar(100) NOT NULL,
`materno_padron` varchar(100) NOT NULL,
`curp_padron` varchar(50) DEFAULT NULL,
`email_padron` varchar(200) DEFAULT NULL,
`telefono_padron` varchar(500) DEFAULT NULL,
`matricula_padron` varchar(50) DEFAULT NULL,
`verificado_padron` varchar(255) NOT NULL DEFAULT 'NO',
`verificado2_padron` varchar(255) NOT NULL DEFAULT 'NO',
`status_padron` varchar(50) NOT NULL DEFAULT 'SI',
`registro_padron` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id_padron`),
UNIQUE KEY `idx_curp_padron_u` (`curp_padron`,`id_unidad`),
UNIQUE KEY `idx_email_padron_u` (`email_padron`),
KEY `fk_padron_unidad_idx` (`id_unidad`),
CONSTRAINT `fk_padron_unidad` FOREIGN KEY (`id_unidad`) REFERENCES `unidad` (`id_unidad`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=77550 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;INSERT INTO `padron` VALUES (1,11,'DOCENTE','CUAUHTEMOC','ALFARO','DELGADILLO','AADC600317HZSLLH00','cuauhtemoc.alfaro@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(2,11,'DOCENTE','GENARO','ALVAREZ','SANDOVAL','AASG510814HZSLNN01','genaro.alvarez@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(3,11,'DOCENTE','ROSA MA.','ACOSTA','LUEVANO','AOLR551205MASCVS00','rosamaria@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(4,11,'DOCENTE','MARIA CONCEPCION','CABRERA','ESTRADA','CAEC621121MDFBSN01','concepcion@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(5,11,'DOCENTE','CARLOS','CAZARES','VARGAS','CAVC710913HPLZRR05','carlos.cazares@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(6,11,'DOCENTE','ORLANDO','CORONEL','ROJAS','CORO760331HDFRJR01','orlando.coronel@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(7,11,'DOCENTE','ROGELIO','ENRIQUEZ','ARANDA','EIAR550108HASNRG09','renriquez@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(8,11,'DOCENTE','EDNA','HUERTA','VELASQUEZ','GUOR610418MDFTCB04',NULL,'','','NO','NO','SI','2022-04-06 01:45:44'),(9,11,'DOCENTE','GABRIELA','HERNANDEZ','ZAPATA','HEZG721011MASRPB08','gabriela@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(10,11,'DOCENTE','MALIKE DANIELA','LEDESMA','MUÑOZ','LEMM800528MASDXL09','malike.ledesma@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(11,11,'DOCENTE','ALEJANDRO','MARQUEZ','DIAZ DEL CASTILLO','MADA780613HDFRZL07','alejandro.marquez@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(12,11,'DOCENTE','ELIZABETH','MACIAS','SANCHEZ','MASE720615MASCNL00','emacias@upn011.edu.mx','','','NO','NO','SI','2022-04-06 01:45:44'),(13,11,'DOCENTE','GUSTAVO','MEZA','MEDINA','MEMG651216HASZDS08','mezame@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(14,11,'DOCENTE','OFELIA','MORQUECHO','BUENDIA','MOBO581029MZSRNF02','ofemor@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(15,11,'DOCENTE','GUSTAVO','ORNELAS','RODRIGUEZ','OERG830204HASRDS06',NULL,'','','NO','SI','SI','2022-04-06 01:45:44'),(16,11,'DOCENTE','JUAN JOSE','PADILLA','PARRA','PAPJ670603HASDRN07','juanjose.padilla@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(17,11,'DOCENTE','MARGARITA','REYES','ALONSO','REAM860623MASYLR02','margarita.reyes@upn011.edu.mx','','','NO','NO','SI','2022-04-06 01:45:44'),(18,11,'DOCENTE','AURORA','TERAN','FUENTES','TEFA701226MCLRNR04','aurora.teran@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(19,11,'DOCENTE','LETICIA','TORRES','SOTO','TOSL670617MASRTT02','leticia.torres@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(20,11,'DOCENTE','MARIA ELENA','TRUJILLO','RENDON','TURE670817MVZRNL08','elena.trujillo@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(21,11,'DOCENTE','MARIA ANTONIETA ANABEL','VALENCIA','GARCIA','VXGA600229MHGLRN06','ana290260@yahoo.com.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(22,11,'DOCENTE','LIZBETH ADRIANA','DE ANDA','AGUILERA','AAAL790506MASNGZ12','lizbeth.deanda@upn011.edu.mx','','','NO','NO','SI','2022-04-06 01:45:44'),(23,11,'DOCENTE','ADRIANA','MERCADO','SALAS','MESA811125MASRLD06','adriana.mercado@upn011.edu.mx','','','NO','NO','SI','2022-04-06 01:45:44'),(24,11,'DOCENTE','JOSE MATIAS','ROMO','MARTINEZ','ROMM760828HASMRT01','matias.romo@upn011.edu.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(25,41,'DOCENTE','JESÚS ELEAZAR','AYUSO','BARRERA','AUBJ511223HCCYRS02','jesus_ayba@hotmail.com','','','NO','SI','SI','2022-04-06 01:45:44'),(26,41,'DOCENTE','CARLOS RAFAEL','BERZUNZA','CRUZ','BECC730918HCCRRR06','crberzun@hotmail.com','','','NO','SI','SI','2022-04-06 01:45:44'),(27,41,'DOCENTE','JOSÉ LUIS','CANTO','RAMÍREZ','CARL531021HDFNMS04','cantoramirez@yahoo.com.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(28,41,'DOCENTE','MARÍA DEL SOCORRO','ESPINA','RODRÍGUEZ','EIRS440609MCCSDC09','mariaespina09@hotmail.com','','','NO','SI','SI','2022-04-06 01:45:44'),(29,41,'DOCENTE','MARIO ORLANDO','MARTÍN','PECH','MAPM561226HCCRCR08','xtacay72_dzit2011@hotmail.com','','','NO','SI','SI','2022-04-06 01:45:44'),(30,41,'DOCENTE','MANUEL JESÚS','NOVELO','PECH','NOPM521119HCCVCN22','manolopech52@hotmail.com','','','NO','SI','SI','2022-04-06 01:45:44'),(31,41,'DOCENTE','MANUEL RAYMUNDO','RIVERO','ROSADO','RIRM630508HCCVSN05','teinvitochocolates@outlook.com','','','NO','SI','SI','2022-04-06 01:45:44'),(32,41,'DOCENTE','TATIANA DE LOS REYES','SUÁREZ','TURRIZA','SUTT790106MYNRRT00','tatianne679@hotmail.com','','','SI','NO','SI','2022-04-06 01:45:44'),(33,41,'DOCENTE','JUANA','ZÁRATE','DOMÍNGUEZ','ZADJ630316MVZRMN06','juani_zarate@hotmail.com','','','NO','SI','SI','2022-04-06 01:45:44'),(34,54,'DOCENTE','EVA GRISELDA','AGUIRRE','MONTEMAYOR','AUME631229MCLGNV09','gicheaguirre@yahoo.com.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(35,54,'DOCENTE','JORGE ALFONSO','BORJAS','FRAIRE','BOFJ870815HCLRRR04','jabf87@hotmail.es','','','NO','NO','SI','2022-04-06 01:45:44'),(36,54,'DOCENTE','LOURDES PATRICIA','CARDIEL','ESCAMILLA','CAEL681227MCLRSR04','patycardielupn@gmail.com','','','NO','NO','SI','2022-04-06 01:45:44'),(37,54,'DOCENTE','ANASTACIA','ESCOBEDO','BANDA','EOBA460415MTSSNN08','esb.ana@hotmail.com','','','NO','SI','SI','2022-04-06 01:45:44'),(38,54,'DOCENTE','DULCE DIANETH','GÁMEZ','DÍAZ','GADD880310MCLMZL07','dulcedianeth_10@hotmail.com','','','NO','NO','SI','2022-04-06 01:45:44'),(39,54,'DOCENTE','JUAN MANUEL','GÁMEZ','ZAMORA','GAZJ621004HCLMMN00','gameza62@yahoo.com.mx','','','NO','SI','SI','2022-04-06 01:45:44'),(40,54,'DOCENTE','DIANA PATRICIA','GARZA','MORALES','GAMD701026MCLRRN04',NULL,'','','NO','SI','SI','2022-04-06 01:45:44'),(41,54,'DOCENTE','GRADLY','GONZÁLEZ','DOMÍNGUEZ','GODG860917MCLNMR04','gradlygd@hotmail.com','','','NO','NO','SI','2022-04-06 01:45:44'),(42,54,'DOCENTE','BRENDA ALHELÍ','GUTIÉRREZ','AGUILAR','GUAB880109MCLTGR08','brenda_amm88@hotmail.com','','','NO','NO','SI','2022-04-06 01:45:44'),(43,54,'DOCENTE','LAURA ALICIA','GUTIÉRREZ','DE LA GARZA','GUGL860828MCLTRR02','wita_2808@hotmail.com','','','NO','NO','SI','2022-04-06 01:45:44'),(44,54,'DOCENTE','JESSICA DEL CARMEN','GUZMÁN','MUÑOZ','GUMJ830708MCLZXS09','jess_gmx@hotmail.com','','','NO','NO','SI','2022-04-06 01:45:44'),(45,54,'DOCENTE','ARMANDO','HERNÁNDEZ','BARRERA','HEBA680730HCLRRR03','armandoh2006@gmail.com','','','NO','NO','SI','2022-04-06 01:45:44'),(46,54,'DOCENTE','LAURA CECILIA','LEIJA','BARRERA','LEBL700621MCLJRR03','laura_lb968@hotmail.com','','','NO','NO','SI','2022-04-06 01:45:44'),(47,54,'DOCENTE','HÉCTOR GERARDO','LERMA','OLIVARES','LEOH761115HCLRLC09','hectorlerma@outlook.com','','','NO','NO','SI','2022-04-06 01:45:44'),(48,54,'DOCENTE','JESÚS','MEZA','JIMÉNEZ','MEJJ600426HCLZMS04','meza3a@gmail.com','','','NO','SI','SI','2022-04-06 01:45:44')
