WfjPZTES

1CREATE TABLE Conductores (
2	permiso varchar(3) NOT NULL,
3	puntos integer NOT NULL,
4	trabajador char(5) NOT NULL,
5	PRIMARY KEY (trabajador),
6	FOREIGN KEY (trabajador) REFERENCES Trabajadores(nTarj) ON DELETE CASCADE ON UPDATE CASCADE );
7
8DROP TABLE IF EXISTS Buses CASCADE;
9
10CREATE TABLE Buses (
11	matricula char(7) NOT NULL,
12	reparaciones integer NOT NULL,
13	central char(5) NOT NULL,
14	PRIMARY KEY (matricula),
15	FOREIGN KEY (central) REFERENCES Central(id) ON DELETE CASCADE ON UPDATE CASCADE );
16
17DROP TABLE IF EXISTS Linea CASCADE;
18
19CREATE TABLE Conducir (
20	conductor char(5) NOT NULL,
21	bus char(7) NOT NULL,
22	PRIMARY KEY (bus,conductor),
23	FOREIGN KEY (bus) REFERENCES Buses(matricula) ON DELETE CASCADE ON UPDATE CASCADE ,
24	FOREIGN KEY (conductor) REFERENCES Conductores(trabajador) ON DELETE CASCADE ON UPDATE CASCADE );
25
26DROP TABLE IF EXISTS Parada CASCADE;