LzsMxJn3

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) 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
28CREATE TABLE `proyectophpbios`.`Enter table name` (`pepe` INT (11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(`pepe`)) TYPE = InnoDB 
29CREATE TABLE `proyectophpbios`.`Enter table name` (`asd` INT UNSIGNED NOT NULL AUTO_INCREMENT, `das` VARCHAR (50), PRIMARY KEY(`asd`)) TYPE = InnoDB /*!40100 DEFAULT CHARSET latin1 COLLATE latin1_swedish_ci */ ;
30CREATE TABLE `proyectophpbios`.`Enter table name` (`Enter column name` INT UNSIGNED NOT NULL AUTO_INCREMENT, `Enter column nameasd` VARCHAR (50) NOT NULL, PRIMARY KEY(`Enter column name`)) TYPE = InnoDB /*!40100 DEFAULT CHARSET latin1 COLLATE latin1_swedish_ci */ ;
31CREATE TABLE `proyectophpbios`.`Enter table name` (`Enter column name` INT UNSIGNED NOT NULL AUTO_INCREMENT, `asd` VARCHAR (50) NOT NULL, PRIMARY KEY(`Enter column name`), UNIQUE(`asd`)) TYPE = InnoDB /*!40100 DEFAULT CHARSET latin1 COLLATE latin1_swedish_ci */ ;
32CREATE TABLE `proyectophpbios`.`disciplina` (`idDisciplina` INT UNSIGNED NOT NULL AUTO_INCREMENT, `NombreDisciplina` VARCHAR (50) NOT NULL, PRIMARY KEY(`idDisciplina`), UNIQUE(`idDisciplina`,`NombreDisciplina`)) ENGINE = InnoDB /*!40100 DEFAULT CHARSET latin1 COLLATE latin1_swedish_ci */ ;
33
34
35
36CREATE TABLE `disciplina` (
37  `idDisciplina` INT (11) UNSIGNED NOT NULL AUTO_INCREMENT,
38  `NombreDisciplina` VARCHAR (50) NOT NULL,
39  PRIMARY KEY(`idDisciplina`), 
40  UNIQUE(`idDisciplina`,`NombreDisciplina`))
41  
42ENGINE = InnoDB;
43
44
45LOCK TABLES `disciplina` WRITE;
46/*!40000 ALTER TABLE `disciplina` DISABLE KEYS */;
47INSERT INTO `disciplina` VALUES (23,'Ajedrez'),(26,'Bolos'),(24,'Damas Chinas'),(25,'Dardos'),(22,'E-Sports'),(27,'Ludo'),(28,'Ping Pong');
48/*!40000 ALTER TABLE `disciplina` ENABLE KEYS */;
49UNLOCK TABLES;
50/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
51
52/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
53/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
54/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
55/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
56/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
57/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
58/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
59
60-- Dump completed on 2020-07-24 16:56:42
61