CREATE TABLE REALISATEUR
(
	`id` int(8) NOT NULL AUTO_INCREMENT,
	`nom` varchar(10) NOT NULL,
	PRIMARY KEY (`id`)
) TYPE = InnoDB;


CREATE TABLE FILM
(
	`id` int(8) NOT NULL AUTO_INCREMENT ,
	`titre_film` varchar(20) NOT NULL,
	`ref_realisateur` int(8) NOT NULL,
	PRIMARY KEY (`id`),
	INDEX (`ref_realisateur`),
	FOREIGN KEY (`ref_realisateur`) REFERENCES `REALISATEUR` (`id`) ON DELETE CASCADE
 ) TYPE=InnoDB;