gjJA7wZa

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