PU7RybNE

1CREATE TABLE IF NOT EXISTS 'upo'.'alumnos' (
2  'id' INT NOT NULL AUTO_INCREMENT,
3  'identificador' VARCHAR(45) NOT NULL,
4  'nombre' VARCHAR(45) NULL,
5  'ape1' VARCHAR(45) NULL,
6  'ape2' VARCHAR(45) NULL,
7  'password' VARCHAR(45) NULL,
8  'dni' VARCHAR(45) NOT NULL,
9  'correo' VARCHAR(45) NOT NULL,
10  PRIMARY KEY ('id'),
11  UNIQUE INDEX 'username_UNIQUE' ('identificador' ASC),
12  UNIQUE INDEX 'legalid_UNIQUE' ('dni' ASC),
13  UNIQUE INDEX 'email_UNIQUE' ('correo' ASC));
14
15CREATE TABLE IF NOT EXISTS 'upo'.'asignaturas' (
16  'id' INT NOT NULL AUTO_INCREMENT,
17  'acod' VARCHAR(45) NOT NULL,
18  'description' VARCHAR(45) NULL,
19  'cod' VARCHAR(45) NOT NULL,
20  PRIMARY KEY ('id'),
21  UNIQUE INDEX 'cod_UNIQUE' ('cod' ASC));
22
23CREATE TABLE IF NOT EXISTS 'upo'.'matriculados' (
24  'id' INT NOT NULL AUTO_INCREMENT,
25  'id_alumno' INT NULL,
26  'id_asignatura' INT NULL,
27  'enabled' INT NULL,
28  PRIMARY KEY ('id'),
29  INDEX 'fk_matriculados_1_idx' ('id_asignatura' ASC),
30  INDEX 'fk_matriculados_2_idx' ('id_alumno' ASC),
31  CONSTRAINT 'fk_matriculados_1'
32    FOREIGN KEY ('id_asignatura')
33    REFERENCES 'mydb'.'asignaturas' ('id')
34    ON DELETE NO ACTION
35    ON UPDATE NO ACTION,
36  CONSTRAINT 'fk_matriculados_2'
37    FOREIGN KEY ('id_alumno')
38    REFERENCES 'mydb'.'alumnos' ('id')
39    ON DELETE NO ACTION,
40    ON UPDATE NO ACTION);