-
Notifications
You must be signed in to change notification settings - Fork 0
/
DEMO.sql
62 lines (54 loc) · 14.1 KB
/
DEMO.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
CREATE DATABASE IF NOT EXISTS `demo` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `demo`;
-- MySQL dump 10.13 Distrib 5.6.17, for Win64 (x86_64)
--
-- Host: localhost Database: demo
-- ------------------------------------------------------
-- Server version 5.6.21-log
/*!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 `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(11) NOT NULL DEFAULT '0',
`DOCUMENTO` varchar(50) NOT NULL,
`APELLIDO` varchar(255) DEFAULT NULL,
`NOMBRE` varchar(255) DEFAULT NULL,
`FECNAC` datetime DEFAULT NULL,
`CUPO` decimal(10,0) DEFAULT '1',
PRIMARY KEY (`ID_USUARIO`),
UNIQUE KEY `ID_AFILIADO_UNIQUE` (`ID_USUARIO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!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,'1001533539','RODRIGUEZ','MAIRON','2002-04-25 00:00:00',1),(2,'1143251470','SANCHEZ','YURY','1993-12-04 00:00:00',1),(3,'15536648','LONDOÑO','CARLOS','1967-02-17 00:00:00',1),(4,'43271225','RIVAS','LUZ','1977-12-11 00:00:00',1),(5,'99082615012','BERRIO','ELIANA','1999-08-26 00:00:00',1),(6,'1002146929','MAZO','CARLOS','2003-02-10 00:00:00',1),(7,'1045107635','MAZO','DONOBAN','2006-11-01 00:00:00',1),(8,'43897230','SANCHEZ','YENIFER','1982-05-30 00:00:00',1),(9,'1005278729','RIOS','JESSICA','2002-01-03 00:00:00',1),(10,'1026138498','MANRIQUE','ANDERSON','2007-08-30 00:00:00',1),(11,'43448709','VARGAS','DENIZ','1977-09-18 00:00:00',1),(12,'25992288','TAFUR','DIANA','1940-10-27 00:00:00',1),(13,'1007491188','CORREA','ALEJANDRA','1992-10-24 00:00:00',1),(14,'1029300334','BENITEZ','HEIDY','2005-07-27 00:00:00',1),(15,'32887331','MARTINEZ','PATRICIA','1973-03-20 00:00:00',1),(16,'08001D0052','ORTIZ','INRRY','1986-02-03 00:00:00',1),(17,'08001D0057','GARCIA','SERGIO','1986-05-08 00:00:00',1),(18,'08001D0079','GONZALEZ','ARDRUA','1968-09-10 00:00:00',1),(19,'08001D0110','REALES','ARLYS','1987-01-24 00:00:00',1),(20,'08001D0121','QUI?ONES','ALEXIS','1986-10-28 00:00:00',1),(21,'08001D0131','PARDO','ELVIS','1979-10-12 00:00:00',1),(22,'08001D0134','RUIZ','MAURIS','1968-12-24 00:00:00',1),(23,'08001D0141','MARTINEZ','JAIRO','1967-12-07 00:00:00',1),(24,'08001D0144','MARIOTE','CARLOS','1930-01-01 00:00:00',1),(25,'08001D0158','HERNANDEZ','MARTHA','1968-03-22 00:00:00',1),(26,'08001D0173','CAMARGO','REIDULFO','1936-02-17 00:00:00',1),(27,'08001D0176','CASTILLA','ALBERTO','1979-11-16 00:00:00',1),(28,'08001D0177','BLANCO','ALEXANDER','1986-02-15 00:00:00',1),(29,'08001D0193','FREILE','YESID','1986-08-30 00:00:00',1),(30,'08001D0199','JULIO','DIONISIO','1918-05-10 00:00:00',1),(31,'08001D0214','MERCADO','LEONARDO','1986-11-06 00:00:00',1),(32,'08001D0217','MU?OZ','VICTOR','1986-05-21 00:00:00',1),(33,'08001D0231','VICTOR','VALLEJO','1986-03-09 00:00:00',1),(34,'08001D0264','OLAYA','ENRIQUE','1930-02-05 00:00:00',1),(35,'08001D0269','GEL','ADOLFO','1987-02-01 00:00:00',1),(36,'08001D0278','GARCIA','JULIO','1967-07-01 00:00:00',1),(37,'08001D0281','CASPRILLO','ALFREDO','1931-11-18 00:00:00',1),(38,'08001D0296','MARTINEZ','JUSTIN','1986-07-21 00:00:00',1),(39,'08001D0298','BAYUELO','ADONAYS','1984-01-27 00:00:00',1),(40,'08001D0299','MALDONADO','ERICK','1986-07-21 00:00:00',1),(41,'08001D0313','ESCOBAR','SIMONA','1926-07-25 00:00:00',1),(42,'08001D0322','BOLIVAR','JOHANA','1979-10-09 00:00:00',1),(43,'08001D0338','ORREGO','ALBA','1986-09-26 00:00:00',1),(44,'08001D0340','PACHECO','MIRIAM','1926-03-18 00:00:00',1),(45,'08001D0356','LANDAZABAL','MILADYS','1978-01-14 00:00:00',1),(46,'08001D0364','CABALLERO','ABRAHAN','1986-12-30 00:00:00',1),(47,'08001D0384','ORTEGA','AIDA','1934-10-15 00:00:00',1),(48,'08001D0387','GUZMAN','GENOVEBA','1986-06-08 00:00:00',1),(49,'08001D0393','BARRAZA','RAFAEL','1955-06-10 00:00:00',1),(50,'08001D0407','MENDOZA','OSWALDO','1971-08-02 00:00:00',1),(51,'08001D0414','QUINTERO','RAMIRO','1987-11-04 00:00:00',1),(52,'08001D0416','PALENCIA','CLAUDIA','1968-01-04 00:00:00',1),(53,'08001D0418','BARRIOS','NICOLAS','1930-02-06 00:00:00',1),(54,'08001D0448','MERCADO','JAVIER','1967-10-22 00:00:00',1),(55,'08001D0469','BOTNETH','DANNY','1987-08-25 00:00:00',1),(56,'08001D0475','ARMANZA','CARLOS','1987-10-09 00:00:00',1),(57,'08001D0477','DAMETT','FEDERICK','1968-03-30 00:00:00',1),(58,'08001D0482','MORENO','MIGUEL','1986-07-16 00:00:00',1),(59,'08001D0502','ACEVEDO','MANUEL','1960-06-15 00:00:00',1),(60,'08001D0514','AHUMADA','HAMILTON','1974-06-25 00:00:00',1),(61,'08001D0560','GONZALEZ','JOSE','1936-12-14 00:00:00',1),(62,'08001D0562','DEL TORO','CESAR','1963-09-30 00:00:00',1),(63,'08001D0565','DIAZ','JOSE','1963-02-20 00:00:00',1),(64,'08001D0567','PEREZ','YIMMY','1967-04-15 00:00:00',1),(65,'08001D0568','RAMIREZ','CARLOS','1982-09-09 00:00:00',1),(66,'08001D0570','BLANCO','MARLON','1991-04-26 00:00:00',1),(67,'1042463568','PINTO','MICHEL','2010-06-05 00:00:00',1),(68,'55230651','GARCIA','ADRIANA','1984-05-09 00:00:00',1),(69,'1143248064','CASTRO','LISETTE','1993-10-09 00:00:00',1),(70,'1045230164','PINO','LORAINES','1988-12-07 00:00:00',1),(71,'22577097','HERRERA','NORA','1945-03-16 00:00:00',1),(72,'19752720','CABRALES','BALMORYS','1983-06-10 00:00:00',1),(73,'1079934541','TRIANA','ARMANDO','1992-06-06 00:00:00',1),(74,'8709053','GRANADOS','CARLOS','1961-02-16 00:00:00',1),(75,'1104411269','ZABALA','EDWIN','1987-10-14 00:00:00',1),(76,'72290343','VASQUEZ','DAVID','1983-12-29 00:00:00',1),(77,'1079940674','RODRIGUEZ','YULISA','1998-03-11 00:00:00',1),(78,'1140890976','ALVAREZ','RICARDO','1997-02-21 00:00:00',1),(79,'1127604643','MARRIAGA','BRIANNA','2014-06-11 00:00:00',1),(80,'72161201','ZUÑIGA','JORGE','1965-10-28 00:00:00',1),(81,'1104377960','AGUILERA','ROBERTO','1989-11-23 00:00:00',1),(82,'1129534854','OROZCO','DANIRIS','1987-01-27 00:00:00',1),(83,'32871262','VEGA','MABEL','1974-12-27 00:00:00',1),(84,'1143161570','BERMUDEZ','LUCINA','1997-05-16 00:00:00',1),(85,'1046696237','ORELLANO','JHONNIER','1999-07-15 00:00:00',1),(86,'1129538819','VARGAS','MAYRA','1987-12-18 00:00:00',1),(87,'1062910814','ESCRUCERIA','EILYN','2013-01-20 00:00:00',1),(88,'72230121','JINETE','GIOVANNY','1977-05-29 00:00:00',1),(89,'32870450','SEPULVEDA','KAREN','1982-11-03 00:00:00',1),(90,'1143428971','ACUÑA','ADRIANA','1998-09-04 00:00:00',1),(91,'1129491224','OQUENDO','YINNIS','1983-02-11 00:00:00',1),(92,'77178268','DIAZ','JOAQUIN','1975-01-30 00:00:00',1),(93,'1044609672','LADEOS','RICARDO','1986-09-04 00:00:00',1),(94,'1143252826','CACERES','YURANIS','1994-11-07 00:00:00',1),(95,'1129564240','GALVAN','MAYURIS','1985-09-15 00:00:00',1),(96,'72130402','VEGA','JAIME','1964-08-30 00:00:00',1),(97,'92031158','AGUILAR','OMAR','1975-09-24 00:00:00',1),(98,'3746124','CAPELL','ALEX','1967-01-01 00:00:00',1),(99,'1158464533','RODRIGUEZ','ANTONY','2014-10-29 00:00:00',1),(100,'72285443','ARIAS','JHONNIS','1982-03-16 00:00:00',1),(101,'19641008','CABALLERO','CELIO','1980-04-11 00:00:00',1),(102,'1047042161','SARMIENTO','ALEJANDRO','1997-08-03 00:00:00',1),(103,'1079936811','DE LA CRUZ','ANA','1994-07-07 00:00:00',1),(104,'5082430','RODRIGUEZ','MANUEL','1963-06-01 00:00:00',1),(105,'1143160661','RODRIGUEZ','WENDY','1997-03-17 00:00:00',1),(106,'1001856926','GUTIERREZ','KEILEN','1995-04-05 00:00:00',1),(107,'1193412022','MENDOZA','MARYELIS','1998-09-18 00:00:00',1),(108,'8717061','MARTINEZ','JAIME','1961-06-14 00:00:00',1),(109,'1143144348','PATIÑO','JOHNYS','1982-01-04 00:00:00',1),(110,'22597652','TORRENEGRA','ALIS','1962-08-21 00:00:00',1),(111,'1010026371','BERDUGO','MERYS','1990-06-09 00:00:00',1),(112,'22448495','VIDAL','CLAUDIA','1968-01-10 00:00:00',1),(113,'1045236534','ANGULO','OSNAIDER','1994-04-09 00:00:00',1),(114,'1041898203','ALARCON','EBERTO','1970-09-18 00:00:00',1),(115,'22591947','PEREZ','LILIBETH','1982-02-18 00:00:00',1),(116,'1082408743','GUTIERREZ','HENRY','1992-06-29 00:00:00',1),(117,'1001854997','MARTINEZ','DALWIS','1997-11-18 00:00:00',1),(118,'1046267213','PINEDA','JEFREE','1987-04-25 00:00:00',1),(119,'22514619','VILLALOBOS','NORMA','1980-09-07 00:00:00',1),(120,'1004121327','CONTRERAS','MARIA','1998-12-05 00:00:00',1),(121,'1085226919','ATENCIO','ADOLFO','1989-08-09 00:00:00',1),(122,'1129566882','MENDOZA','WILMER','1986-05-01 00:00:00',1),(123,'1143161092','MONTES','JORGE','1997-05-02 00:00:00',1),(124,'26813315','DE LA HOZ','AIRAIRA','1970-06-08 00:00:00',1),(125,'1046272659','ALMANZA','DANILO','1994-05-02 00:00:00',1),(126,'8540894','GUETTE','TONY','1984-05-12 00:00:00',1),(127,'1001819293','BARRAZA','FABIAN','1998-12-28 00:00:00',1),(128,'1083433642','BLANCO','CARLOS','1988-07-22 00:00:00',1),(129,'1079940251','TERNERA','ROSA','1997-12-13 00:00:00',1),(130,'1140855770','LARIOS','ROLAND','1992-05-08 00:00:00',1),(131,'1143452399','DIAZ','MIRIAM','1995-05-22 00:00:00',1),(132,'1043604146','RIVERA','DAVID','1986-03-08 00:00:00',1),(133,'1001994865','HERRERA','DAYANA','1995-10-05 00:00:00',1),(134,'1140867827','RODRIGUEZ','LUIS','1994-02-23 00:00:00',1),(135,'1001934111','PEÑALOZA','JONATHAN','1997-04-13 00:00:00',1),(136,'19725004','TRUJILLO','GUSTAVO','1956-12-08 00:00:00',1),(137,'1038133639','RAMOS','ALBERT','1996-10-14 00:00:00',1),(138,'1143261214','ROSALES','ISAC','1997-03-13 00:00:00',1),(139,'1047348752','GUTIERREZ','CARLOS','1994-10-29 00:00:00',1),(140,'1104009788','DORIA','JESUS','1986-06-19 00:00:00',1),(141,'1102855859','FLOREZ','YISETH','1993-08-26 00:00:00',1),(142,'1126248528','ANTEQUERA','MELISSA','1994-02-17 00:00:00',1),(143,'1045673151','CHAVEZ','DIDIER','1986-12-11 00:00:00',1),(144,'1129489314','BLANQUICET','KELLY','1996-03-17 00:00:00',1),(145,'22475942','PAEZ','MARY','1978-05-06 00:00:00',1),(146,'26694358','POTES','ROSA','1962-10-14 00:00:00',1),(147,'1143145206','LOZANO','GUILLERMO','1994-03-22 00:00:00',1),(148,'1083003318','GALUE','LUCIANA','2013-07-31 00:00:00',1),(149,'1140827548','BUSTAMANTE','ENILSA','1982-01-02 00:00:00',1),(150,'1002000749','HERRERA','NOEMI','1997-08-28 00:00:00',1),(151,'08001D0571','QUIROZ','DENIS','1944-09-12 00:00:00',1),(152,'08001D0572','MONTALVO','SANDRA','1986-09-26 00:00:00',1),(153,'08001D0573','REALES','EDGARDO','1960-11-11 00:00:00',1),(154,'08001D0576','JULIO','ALFONSO','1980-03-16 00:00:00',1),(155,'08001D0577','CANTILLO','CARLOS','1992-03-03 00:00:00',1),(156,'08001D0578','MARTINEZ','HAIDER','1975-01-10 00:00:00',1),(157,'08001D0579','GARCIA','DORA','1996-08-14 00:00:00',1),(158,'08001D0580','CORTEZ','MARIA','1965-08-10 00:00:00',1),(159,'08001D0582','SANTANA','LUIS','1982-04-25 00:00:00',1),(160,'08001D0583','OSPINO','JAVIER','1984-10-26 00:00:00',1),(161,'08001D0584','LEUDO','LUIS','1992-12-04 00:00:00',1),(162,'08001D0585','DE LA HOZ','OSCAR','1988-08-24 00:00:00',1),(163,'08001D0586','VALENCIA','VICTOR','1986-11-21 00:00:00',1),(164,'08001D0587','FERNANDEZ','WILFRIDO','1980-03-29 00:00:00',1),(165,'08001D0588','CANTILLO','JOSE','1950-06-06 00:00:00',1),(166,'08001D0589','CERA','JORGE','1982-02-06 00:00:00',1),(167,'08001D0590','BORNACELLE','CARMEN','1948-05-19 00:00:00',1),(168,'08001D0593','DE LAS SALAS','RAUL','1960-12-12 00:00:00',1),(169,'08001D0595','JIMENEZ','PABLO','1964-01-15 00:00:00',1),(170,'08001D0597','VELEZ','EDULFO','1946-06-17 00:00:00',1),(171,'08001D0598','QUINTERO','LUIS','1985-08-11 00:00:00',1),(172,'08001D0657','MULFO','LEUDITH','1982-05-24 00:00:00',1),(173,'08001D4947','PAREJO','MANUEL','1983-12-28 00:00:00',1),(174,'08001D9426','OSPINO','EDINSON','1967-01-24 00:00:00',1),(175,'08001D9427','CROOSS','BRAYAN','1988-01-01 00:00:00',1),(176,'08001D9428','MONTA?EZ','ORLANDO','1956-11-01 00:00:00',1),(177,'08001D9430','HERNANDEZ','ADRIANA','1978-05-28 00:00:00',1),(178,'08001D9432','RAMIREZ','MARIO','1930-03-04 00:00:00',1),(179,'08001D9433','MARTINEZ','ALBERT','1987-01-17 00:00:00',1),(180,'08001D9434','VILLAREAL','MERCEDES','1964-06-05 00:00:00',1),(181,'08001D9436','PUELLO','FRANCISCO','1955-02-19 00:00:00',1),(182,'08001D9438','MORENO','JEISON','1985-01-06 00:00:00',1),(183,'08001D9444','HERNANDEZ','EDGAR','1951-09-12 00:00:00',1),(184,'08001D9446','HENRIQUEZ','JOSE','1989-05-18 00:00:00',1),(185,'08001S1038','ALVIS','BETOLIA','1900-01-01 00:00:00',1),(186,'08001S1057','SUAREZ','MARIA','1900-01-01 00:00:00',1),(187,'08001S1059','SUAREZ','NATALI','1900-01-01 00:00:00',1),(188,'08001S1060','SUAREZ','ERICKA','1900-01-01 00:00:00',1),(189,'08001S1065','MARQUEZ','JANETH','1900-01-01 00:00:00',1),(190,'08001S1103','MEJIA','LUZ','1900-01-01 00:00:00',1),(191,'08001S1227','ORTIZ','DINUTILA','1900-01-01 00:00:00',1),(192,'08001S1241','OROZCO','EVA','1900-01-01 00:00:00',1),(193,'08001S1283','CASTRO','FALMIDES','1900-01-01 00:00:00',1),(194,'08001S1335','SUAREZ','ONADID','1900-01-01 00:00:00',1),(195,'08001S1411','CABALLERO','JOSEFINA','1986-11-08 00:00:00',1),(196,'08001S1418','GIL','YEISON','1900-01-01 00:00:00',1),(197,'08001S1442','PEREZ','SHIRLIS','1987-09-13 00:00:00',1),(198,'08001S1466','MORENO','LUDYS','1967-12-05 00:00:00',1),(199,'08001S1471','DE LA CRUZ','CIRA','1979-10-18 00:00:00',1),(200,'08001S1472','DE LA CRUZ','ANGELIS','1986-10-18 00:00:00',1);
/*!40000 ALTER TABLE `usuarios` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping routines for database 'demo'
--
/*!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 2018-05-21 11:31:47