qddzeJc0

1CREATE DATABASE /*!32312 IF NOT EXISTS*/ `pythonmysql` /*!40100 DEFAULT CHARACTER SET latin1 */;
2
3USE `pythonmysql`;
4
5
6CREATE TABLE `alumno` (
7  `codigo` char(10) NOT NULL,
8  `nombre_completo` varchar(300) NOT NULL,
9  PRIMARY KEY (`codigo`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1;
11/*!40101 SET character_set_client = @saved_cs_client */;
12
13
14CREATE TABLE `curso` (
15  `id_curso` int(11) NOT NULL AUTO_INCREMENT,
16  `nombre` varchar(100) NOT NULL,
17  PRIMARY KEY (`id_curso`)
18) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
19/*!40101 SET character_set_client = @saved_cs_client */;
20
21
22CREATE TABLE `notas` (
23  `id_notas` int(11) NOT NULL AUTO_INCREMENT,
24  `fk_alumno` char(10) DEFAULT NULL,
25  `fk_curso` int(11) DEFAULT NULL,
26  `nota` tinyint(4) NOT NULL,
27  PRIMARY KEY (`id_notas`)
28) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
29/*!40101 SET character_set_client = @saved_cs_client */;
30
31
32CREATE TABLE `persona` (
33  `id_persona` int(11) NOT NULL AUTO_INCREMENT,
34  `nombres` varchar(200) NOT NULL,
35  `apellidos` varchar(200) NOT NULL,
36  `email` varchar(200) NOT NULL,
37  PRIMARY KEY (`id_persona`)
38) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
39/*!40101 SET character_set_client = @saved_cs_client */;