jpUAHxEi

1CREATE DATABASE  IF NOT EXISTS proyectophpbios ;
2USE proyectophpbios;
3
4
5DROP TABLE IF EXISTS `atleta`;
6
7CREATE TABLE `atleta` (
8  `idAtleta` int(11) NOT NULL AUTO_INCREMENT,
9  `NombreAtleta` varchar(256) COLLATE utf8_spanish_ci NOT NULL,
10  `FechaNacAtleta` date NOT NULL,
11  `OrigenAtleta` varchar(256) COLLATE utf8_spanish_ci NOT NULL,
12  `idDisciplina` int(11) UNSIGNED NOT NULL,
13  PRIMARY KEY (`idAtleta`),
14  UNIQUE KEY `idAtleta_UNIQUE` (`idAtleta`),
15  KEY `idAtletaIndex` (`idAtleta`),
16  KEY `fkDisciplina_idx` (`idDisciplina`),
17  CONSTRAINT `fkDisciplina` FOREIGN KEY (`idDisciplina`) REFERENCES `disciplina` (`idDisciplina`)
18) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
19
20
21INSERT INTO `atleta` VALUES (22,'Angela Fernanda Buela Masullo','2002-05-13','Suecia',24),(23,'Milena Cabanelas','1992-01-01','Alemania',24),(24,'Santiago Illarze Mujica','2002-07-02','Paises Bajos',22),(25,'Juan Marcelo Mereles Vallejos','2001-11-30','Paises Bajos',22),(26,'Melissa Rios','1969-01-01','Paises Bajos',23),(27,'Melina Aymara Taramasco De la Torre','1998-01-18','Suecia',26),(28,'Guillermina Fedorczuk','1972-10-12','Suecia',25),(29,'Nicolas Trombotti','1996-12-24','Alemania',23),(30,'Ana Gabriela Schvartzman','1976-06-11','Suecia',26),(33,'Bruno Acosta','1999-11-19','Alemania',27),(34,'Agustín Martinez','1997-01-07','Alemania',27),(35,'Samira Carneiro','1989-07-07','Paises Bajos',28),(36,'Sofia Curcho','1976-08-05','Suecia',28);
22
23
24
25
26DROP TABLE IF EXISTS `disciplina`;
27
28
29CREATE TABLE `disciplina` (
30  `idDisciplina` INT (11) UNSIGNED NOT NULL AUTO_INCREMENT,
31  `NombreDisciplina` VARCHAR (50) NOT NULL,
32  PRIMARY KEY(`idDisciplina`), 
33  UNIQUE(`idDisciplina`,`NombreDisciplina`))
34  
35ENGINE = InnoDB;
36
37
38LOCK TABLES `disciplina` WRITE;
39/*!40000 ALTER TABLE `disciplina` DISABLE KEYS */;
40INSERT INTO `disciplina` VALUES (23,'Ajedrez'),(26,'Bolos'),(24,'Damas Chinas'),(25,'Dardos'),(22,'E-Sports'),(27,'Ludo'),(28,'Ping Pong');
41/*!40000 ALTER TABLE `disciplina` ENABLE KEYS */;
42UNLOCK TABLES;
43/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
44
45/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
46/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
47/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
48/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
49/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
50/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
51/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
52
53-- Dump completed on 2020-07-24 16:56:42
54