Mal placé

[sixdouglas]

Ces lignes devraient être mises dans un fichier schema.sql

prog-composant-voitures/src/main/resources/data.sql

Lines 1 to 82 in 63f579f

	CREATE TABLE IF NOT EXISTS marque
	(
	id_marque INT NOT NULL,
	nom VARCHAR(250) NOT NULL,
	PRIMARY KEY(id_marque)
	);
	CREATE TABLE IF NOT EXISTS voiture
	(
	id_voiture INT NOT NULL,
	id_marque INT NOT NULL,
	id_client INT NOT NULL,
	modele VARCHAR(250) NOT NULL,
	PRIMARY KEY(id_voiture)
	);
	CREATE TABLE IF NOT EXISTS concessionaire
	(
	id_concessionaire INT NOT NULL,
	nom VARCHAR(250) NOT NULL,
	PRIMARY KEY(id_concessionaire)
	);
	CREATE TABLE IF NOT EXISTS adresse
	(
	id_adresse INT NOT NULL,
	libelle VARCHAR(250) NOT NULL,
	id_concessionaire INT NOT NULL,
	PRIMARY KEY(id_adresse)
	);
	CREATE TABLE IF NOT EXISTS client
	(
	id_client INT NOT NULL,
	nom VARCHAR(250) NOT NULL,
	PRIMARY KEY(id_client)
	);
	CREATE TABLE IF NOT EXISTS mar_co
	(
	id_marque INT NOT NULL,
	id_concessionaire INT NOT NULL,
	PRIMARY KEY(id_marque, id_concessionaire)
	);
	ALTER TABLE voiture
	ADD FOREIGN KEY (id_marque)
	REFERENCES marque(id_marque)
	ON DELETE CASCADE
	ON UPDATE CASCADE
	;
	ALTER TABLE adresse
	ADD FOREIGN KEY (id_concessionaire)
	REFERENCES concessionaire(id_concessionaire)
	ON DELETE CASCADE
	ON UPDATE CASCADE
	;
	ALTER TABLE voiture
	ADD FOREIGN KEY (id_client)
	REFERENCES client(id_client)
	ON DELETE CASCADE
	ON UPDATE CASCADE
	;
	ALTER TABLE mar_co
	ADD FOREIGN KEY (id_marque)
	REFERENCES marque(id_marque)
	ON DELETE CASCADE
	ON UPDATE CASCADE
	;
	ALTER TABLE mar_co
	ADD FOREIGN KEY (id_concessionaire)
	REFERENCES concessionaire(id_concessionaire)
	ON DELETE CASCADE
	ON UPDATE CASCADE
	;