f0HTRNGW

1CREATE TABLE IF NOT EXISTS Chanson
2(
3	id_chanson SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
4	titre VARCHAR(255) NOT NULL,
5	instrumentale BIT NOT NULL
6);
7
8CREATE TABLE IF NOT EXISTS Discographie
9(
10	id_discographie SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
11	titre VARCHAR(255) NOT NULL,
12	url_pochette TEXT NOT NULL,
13	date_sortie DATETIME NOT NULL,
14	label VARCHAR(255) NOT NULL,
15	type_album VARCHAR(255) NOT NULL,
16	caracteristiques_album TEXT,
17	caracteristiques_pochette TEXT
18);
19
20CREATE TABLE IF NOT EXISTS Chanson_discographie
21(
22	id_chanson SMALLINT UNSIGNED,
23	id_discographie SMALLINT UNSIGNED,
24	numero_ordre SMALLINT UNSIGNED NOT NULL,
25	PRIMARY KEY(id_chanson, id_discographie),
26	CONSTRAINT FK_Chanson_Chanson_Discographie 
27		FOREIGN KEY(id_chanson) REFERENCES Chanson(id_chanson) ON DELETE CASCADE,
28	CONSTRAINT FK_Discographie_Chanson_Discographie 
29		FOREIGN KEY(id_discographie) REFERENCES Discographie(id_discographie) ON DELETE CASCADE
30);