· 8 years ago · Jan 16, 2018, 07:34 AM
1CREATE TABLE IF NOT EXISTS `film` (
2 `id` int(250) unsigned NOT NULL AUTO_INCREMENT,
3 `titre` varchar(100) NOT NULL,
4 `annee` int(100) NOT NULL,
5 `genre` varchar(100) NOT NULL,
6 `nationalite` varchar(100) NOT NULL,
7 `duree` int(100) NOT NULL,
8 `realisateur` varchar(100) NOT NULL,
9 `acteurs` int(100) NOT NULL,
10 `histoire` text NOT NULL,
11 `entrees` int(100) NOT NULL,
12 PRIMARY KEY (`id`)
13)