Lnx6Nfaa

1 public void create(){
2    	String sql="CREATE TABLE IF NOT EXISTS `film` ("
3    			+ "`id` int(250) unsigned NOT NULL AUTO_INCREMENT,"
4    			+ "`titre` varchar(100) NOT NULL,"
5    			+ "`annee` int(100) NOT NULL,"
6    			+ "`genre` varchar(100) NOT NULL,"
7    			+ "`nationalite` varchar(100) NOT NULL,"
8    			+ "`duree` int(100) NOT NULL,"
9    			+ "`realisateur` varchar(100) NOT NULL,"
10    			+ "`acteurs` int(100) NOT NULL,"
11    			+ "`histoire` text NOT NULL,"
12    			+ "`entrees` int(100) NOT NULL,"
13    			+ "PRIMARY KEY (`id`)"
14    			+ ")";
15    	this.execute(sql);
16    }