· 5 years ago · Feb 10, 2020, 02:40 PM
1
2--
3-- Table structure for table `USUARIO`
4--
5
6DROP TABLE IF EXISTS `USUARIO`;
7/*!40101 SET @saved_cs_client = @@character_set_client */;
8/*!40101 SET character_set_client = utf8 */;
9CREATE TABLE `USUARIO` (
10 `ID` varchar(255) NOT NULL,
11 `ACTIVADO` tinyint(1) DEFAULT '0',
12 `APELLIDO` varchar(255) DEFAULT NULL,
13 `CORREO` varchar(255) DEFAULT NULL,
14 `imagen` longblob,
15 `NOMBRE` varchar(255) DEFAULT NULL,
16 `PASS` varchar(255) DEFAULT NULL,
17 `PUNTAJE` int(11) DEFAULT NULL,
18 `RESULTADOEMBOCADOS` int(11) DEFAULT NULL,
19 `RESULTADOERRADOS` int(11) DEFAULT NULL,
20 `RESULTADOSCONGOLESEMBOCADOS` int(11) DEFAULT NULL,
21 `RESULTADOSCONGOLESERRADOS` int(11) DEFAULT NULL,
22 `ROL` varchar(255) DEFAULT NULL,
23 PRIMARY KEY (`ID`)
24) ENGINE=InnoDB DEFAULT CHARSET=latin1;
25/*!40101 SET character_set_client = @saved_cs_client */;
26
27--
28-- Dumping data for table `USUARIO`
29--
30
31LOCK TABLES `USUARIO` WRITE;
32/*!40000 ALTER TABLE `USUARIO` DISABLE KEYS */;
33INSERT INTO `USUARIO` VALUES ('23mo23',1,'Silva','monicaagustina676@hotmail.com','\0\0\0\0\0\0\0\0\0\0','Monica','ed3844ee1f281bc88c406d40c6e0f755',82,13,13,3,23,''),('adefreitas_2015',1,'De Freitas','defma119@hotmail.com','\0\0\0\0\0\0\0\0\0\0','Álvaro','7971861d229ba931091aade32c247060',43,9,13,1,21,''),('adri ',1,'Prigue','aprigue@gmail.com','\0\0\0\0\0\0\0\0\0\0','Adriana','53e8973a9a9b14f6b29f845cc9c341a1',34,7,15,0,22,''),('alejandrav',1,'Valentin','anaalejandravalentin@gmail.com','\0\0\0\0\0\0\0\0\0\0','Alejandra','b5b4fc66ec2122feda2186286ee673b4',58,11,15,0,26,''),('alejoperdomo',1,'Perdomo','awperdomo@gmail.com','\0\0\0\0\0\0\0\0\0\0','Alejandro','ae9ec5150c74ae5f3aa55e3080ba49bf',88,16,10,1,25,''),('alekos',1,'Mara','alekosmara13@gmail.com','\0\0\0\0\0\0\0\0\0\0','Alekos','094fadc8ac4024add6e1e8dc72fd6ffb',26,6,12,1,17,''),('alelopez',1,'Lopez Viana','arqlopezviana@gmail.com','\0\0\0\0\0\0\0\0\0\0','Alejandro','86344ef2be3b01aa0a1f407aeb9e0229',64,13,9,2,20,''),('alevenossa',1,'Venossa','alevenossa@gmail.com','\0\0\0\0\0\0\0\0\0\0','Alejandro','cb8acb1dc9821bf74e6ca9068032d623',48,10,16,1,25,''),('amello',1,'Mello','amello@safa.edu.uy','\0\0\0\0\0\0\0\0\0\0','Alberto','4a60f4f97933f163a49ad9b47b3bd16c',6,1,3,0,4,''),('bcabrera',1,'Cabrera','brefabi@gmail.com ','\0\0\0\0\0\0\0\0\0\0','Brenda','d58a19b70c29e71bee34293dd5afc87f',20,5,7,0,12,''),('cblucas',1,'Lucas','cblucas@safa.edu.uy','\0\0\0\0\0\0\0\0\0\0','Carlos','f4c84b0ccc79aebb92c276ba45991bec',81,14,12,4,22,''),('ceciliar',1,'Russo','ceciliarusso@msn.com','\0\0\0\0\0\0\0\0\0\0','Cecilia','a6a54f39388e29234dacf43ad08b3321',0,0,0,0,0,''),('doris',1,'López','dlopezarbelo@gmail.com','\0\0\0\0\0\0\0\0\0\0','Doris','b21de16963efaac4d0f5fc79621b3ca2',71,13,13,2,24,''),('emadico',1,'Weinberg','emadico@gmail.com','\0\0\0\0\0\0\0\0\0\0','German','9c7d7c0b0db354baf5095561cbdd060c',38,8,17,2,23,''),('enrique',1,'Selios','enriqueselios@hotmail.com','\0\0\0\0\0\0\0\0\0\0','Enrique','294a2b321d419fd69a4d74fdd9801924',18,4,18,1,21,''),('esimerjian',1,'Simerjian','intendencia@safa.edu.uy','\0\0\0\0\0\0\0\0\0\0','Elizabeth','cfd0ab4663312126aa7534fdbc3e24fc',48,9,15,2,22,''),('fedefdz',1,'Fernández','fedefdz24@gmail.com','\0\0\0\0\0\0\0\0\0\0','Federico','cdb0b73426218db8896815541e6ad506',62,11,13,1,23,''),('fer',1,'Alvarez','falvarez@safa.edu.uy','\0\0\0\0\0\0\0\0\0\0','Fernanda','7d9790e985dd646b4fb376eab3150f38',91,15,11,4,22,''),('fernando59',1,'Martínez','fermars@adinet.com.uy','\0\0\0\0\0\0\0\0\0\0','Fernando','634944135df2551028524feb42b683d3',83,15,10,4,21,''),('fio18',1,'Portillo','silviaportillo30@hotmail','\0\0\0\0\0\0\0\0\0\0','Silvia','0004d0b59e19461ff126e3a08a814c33',62,12,13,1,24,''),('g.arevalocuesta',1,'Arévalo','g.arevalocuesta@gmail.com','\0\0\0\0\0\0\0\0\0\0','Gabriel','5416d7cd6ef195a0f7622a9c56b55e84',28,6,12,2,16,''),('gcameto',1,'Cameto','gcameto@safa.edu.uy',NULL,'Gonzalo','a345d6454c54961d4ca6d78454369c08',54,10,14,1,23,'Administrador'),('gomatsu',1,'París','mmhap3@gmail.com','\0\0\0\0\0\0\0\0\0\0','Adrián','bddd25463b8f7acd7e5bc16e9c47e87e',30,6,16,0,22,''),('guzconte',1,'Conte','guzmanconte@hotmail.com','\0\0\0\0\0\0\0\0\0\0','Guzman','1b346722dfbf2cec6c8d8a801fbd5267',61,13,12,1,24,''),('hector',1,'Escamendi','hescamendi@hotmail.com','\0\0\0\0\0\0\0\0\0\0','Hector','0e81ece9d1d32371c1820ab41bc34bcd',60,13,13,0,26,''),('hnojavier',1,'Gonzalez','hnojavier@gmail.com','\0\0\0\0\0\0\0\0\0\0','Javier','2cf431ff731abb53e5f9cec3d7a63384',49,8,17,1,24,''),('javisan1988',1,'Sandoval','javisan1988@','\0\0\0\0\0\0\0\0\0\0','Javier','0b59dd27dadf24131eb7789837a73776',48,11,9,1,19,''),('jbrisset',1,'Brisset','jbrisset@gmail.com','\0\0\0\0\0\0\0\0\0\0','Jorge','872abdfcd193152f194eaa1fe3bbce09',86,16,10,3,23,''),('jetd',1,'Turcatti','jturcatti@safa.edu.uy','\0\0\0\0\0\0\0\0\0\0','Julio','616706c4d6f7bdf68b30893f860cbb2b',48,10,10,0,20,''),('jorge david',1,'David','jog.david@gmail.com','\0\0\0\0\0\0\0\0\0\0','Jorge','5f855f7773e558e908b6965841b002e8',43,8,14,3,19,''),('josealustiza',1,'Alustiza','josealustiza@gmail.com','\0\0\0\0\0\0\0\0\0\0','José','468aef100b7750ffdd0ae2b71357b2ef',0,0,0,0,0,''),('jr',1,'Wenzel','roberto@safa.edu.uy','\0\0\0\0\0\0\0\0\0\0','Juan','4bb01f05ef2ea703a3f8312e77fedb68',64,13,13,2,24,''),('jsamudio',1,'Samudio','jsamudio@safa.edu.uy','\0\0\0\0\0\0\0\0\0\0','Javier','b82a0861421089be9ea04558df7768cf',46,8,16,0,24,''),('juan',1,'Mazzuco','juanmazzuco@hotmail.com','\0\0\0\0\0\0\0\0\0\0','Juan','52fb7a001379541772472a58e1d66842',0,0,0,0,0,''),('kelly',1,'Borghini','sugarykelly@gmail.com','\0\0\0\0\0\0\0\0\0\0','Ana','8d7962dd361f95ff0de91fc1ca6e9543',0,0,0,0,0,''),('kikñ',0,'Nose','grg@gmail.com','\0\0\0\0\0\0\0\0\0\0','Juan','a94652aa97c7211ba8954dd15a3cf838',0,0,0,0,0,''),('laca427',1,'Castro','santicg79@hotmail.com','\0\0\0\0\0\0\0\0\0\0','Santiago','a5061a49f9470ba69cf23ef7cb309b46',74,13,13,2,24,''),('lauravaldivieso',1,'Valdivieso','laura.valdivieso@hotmail.com','\0\0\0\0\0\0\0\0\0\0','Laura','0f989ce5934387faf7cfa95601107e21',68,12,14,3,23,''),('majo',1,'Guedikián','majoipa2012@gmail.com','\0\0\0\0\0\0\0\0\0\0','María José','50ad080be1072695b011a3206756cd02',79,15,11,4,22,''),('manuel28',1,'Mallarine','manuel.mallarine@gmail.com','\0\0\0\0\0\0\0\0\0\0','Manuel','1a474094a1f9143e1281cd4e562f7e1c',68,13,13,2,24,''),('marcelo',1,'Mónico','mmonico@safa.edu.uy','\0\0\0\0\0\0\0\0\0\0','Marcelo','0dc9d8536ceac623c00c5c42d55a5fdb',64,12,14,3,23,''),('marianela',1,'Kochan','marianelak@gmail.com','\0\0\0\0\0\0\0\0\0\0','Marianela','f029c0e893f6253292adf8f5b7ce62ac',0,0,0,0,0,''),('marianelam',1,'Marrero','marian_marre@hotmail.com','\0\0\0\0\0\0\0\0\0\0','Marianela','93fb9d4b16aa750c7475b6d601c35c2c',60,11,7,2,16,''),('mariel',1,'Loggia','mloggia@montevideo.com.uy','\0\0\0\0\0\0\0\0\0\0','Mariel','cbe4261b8834e257f707e6d960304004',61,11,14,1,24,''),('mathi13',1,'Sena','mathiassena@hotmail.com','\0\0\0\0\0\0\0\0\0\0','Mathias','798507a540b929dc915eb8fe1b9db8fd',46,9,14,1,22,''),('michelverdier23@gmail.com',1,'Verdier','michelverdier23@gmail.com','\0\0\0\0\0\0\0\0\0\0','Michel','db563b825a8988254dbb59820a851992',58,11,7,1,17,''),('miyagui',1,'Carbajales','dpcdfan@gmail.com','\0\0\0\0\0\0\0\0\0\0','Fernando','349c0c7e409f81857da065a57b887077',76,14,9,2,21,''),('nadie',1,'Bordón','vabordon@safa.edu.uy','\0\0\0\0\0\0\0\0\0\0','Viviana','8492f1ee65c005b09b3eabce0e1be172',70,13,13,4,22,''),('nico',1,'Ramírez','nicolasramirezgalli@gmail.com','\0\0\0\0\0\0\0\0\0\0','Nicolás','a226b386b6fd1e7ae05ca939318010ea',77,13,13,2,24,''),('nmoreira71',1,'Moreira','nmoreira71@gmail.com','\0\0\0\0\0\0\0\0\0\0','Nicolás','da1dadf93f1f9edd6b5467db725bbcad',56,11,15,1,25,''),('pablo fernandez',1,'Fernandez','p.fernandez.brittez@gmail.com','\0\0\0\0\0\0\0\0\0\0','Pablo','76905f1a8a757fb68c5c99c3c36b6050',0,0,0,0,0,''),('pferreira',1,'Ferreira','pferreira@safa.edu.uy','\0\0\0\0\0\0\0\0\0\0','Pablo','ba48f7339e6f6ed5c9df9d6b8bac9636',66,13,13,0,26,''),('pguedes',1,'Guedes','pguedes','\0\0\0\0\0\0\0\0\0\0','Paola','7c4787987a6cf0520c5acd6d2bdad3a3',28,7,12,0,19,''),('ppereiro',1,'Pereiro','ppereiro@safa.edu.uy',NULL,'Pablo','9caf693f70c1f16dc86edb985f26ca80',47,9,17,1,25,'Administrador'),('ricardot',1,'Terán','crteran@adinet.com.uy','\0\0\0\0\0\0\0\0\0\0','César','c29cb4993b032c4facbfae78fdb00f66',80,14,12,2,24,''),('rodrigov',1,'Viqueira','profviqueira@hotmail.com','\0\0\0\0\0\0\0\0\0\0','Rodrigo','356bc98f70c388d01e44d02453ed0c1a',85,14,12,3,23,''),('rorogar41',1,'García Martinez','rorogar41@gmail.com','\0\0\0\0\0\0\0\0\0\0','Rodrigo','d10a5bd3564e6400308b7309f9a2767b',20,4,10,0,14,''),('santiago dieste',1,'Dieste','santiagodieste@gmail.com','\0\0\0\0\0\0\0\0\0\0','Santiago','1a43f2fa7d87d6818afe7e1c1fb62d76',68,14,11,1,24,''),('sebaburg',1,'Burgueño','sebaburg@gmail.com','\0\0\0\0\0\0\0\0\0\0','Sebastián','37662a36ed8f6be2b790d18510e72b8f',61,11,11,1,21,''),('soledad',1,'Álvez','solealvez@gmail.com','\0\0\0\0\0\0\0\0\0\0','Soledad','3c9b096860b00c8f0c879057b3efde9b',85,14,11,4,21,''),('svilla',1,'Villa','silviavilla@safa.edu.uy','\0\0\0\0\0\0\0\0\0\0','Silvia','e10adc3949ba59abbe56e057f20f883e',4,1,1,0,2,''),('szodo',1,'Szodo','dszodo@safa.edu.uy','\0\0\0\0\0\0\0\0\0\0','Daniel','425d33fde567258bf5e79e9caf3af098',51,8,10,1,17,''),('tinchocicao ',1,'Cicao','tinchocicao@gmail.com','\0\0\0\0\0\0\0\0\0\0','Martín','5188a6afeef71ae55f179c64e92e510b',0,0,0,0,0,''),('tony ',1,'Dabin','antoniodabin @hotmail.com','\0\0\0\0\0\0\0\0\0\0','Antonio','2a0886bb876d48391e25599fc4c4fb28',64,10,15,3,22,''),('vazquezdiaz',1,'Vázquez Díaz','vdpablo@gmail.com','\0\0\0\0\0\0\0\0\0\0','Pablo','9b4d72cec46b42aa3de62f137da4b24e',46,9,13,0,22,''),('victor',1,'Suarez','visuar19@gmail.com','\0\0\0\0\0\0\0\0\0\0','Victor','8fa20053de607413a470759c662f7d44',82,14,12,6,20,''),('virginia ',1,'Firpo','virgir@hotmail.com','\0\0\0\0\0\0\0\0\0\0','Virginia','50c9cc20f7d0053ec7dcee9902940bb7',0,0,0,0,0,''),('walter',1,'Gordano','wgordano@hotmail.com','\0\0\0\0\0\0\0\0\0\0','Walter','a8522edaf9c30a89fd01359d6dab931b',40,9,15,0,24,'');
34/*!40000 ALTER TABLE `USUARIO` ENABLE KEYS */;
35UNLOCK TABLES;
36/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
37
38/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
39/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
40/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
41/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
42/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
43/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
44/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
45
46
47Kris ¬