SQL sorgusu: hata ?

my adminden sql aktardigim zaman hata aliyorum

CREATE TABLE letopdutop (
   id int(9) DEFAULT '0' NOT NULL AUTO_INCREMENT,
   titre longtext NOT NULL,
   description longtext NOT NULL,
   siteurl longtext NOT NULL,
   banurl longtext,
   email longtext NOT NULL,
   password longtext NOT NULL,
   bh int(9) DEFAULT '0' NOT NULL,
   bw int(9) DEFAULT '0' NOT NULL,
   entree int(7) DEFAULT '0' NOT NULL,
   sortie int(7) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id)
);

hata kodu ise

Hata
SQL sorgusu: 
CREATE TABLE letopdutop(
id int( 9 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
titre longtext NOT NULL ,
description longtext NOT NULL ,
siteurl longtext NOT NULL ,
banurl longtext,
email longtext NOT NULL ,
PASSWORD longtext NOT NULL ,
bh int( 9 ) DEFAULT '0' NOT NULL ,
bw int( 9 ) DEFAULT '0' NOT NULL ,
entree int( 7 ) DEFAULT '0' NOT NULL ,
sortie int( 7 ) DEFAULT '0' NOT NULL ,
PRIMARY KEY ( id ) 
) 
MySQL çıktısı:  
#1067 - Invalid default value for 'id'

CREATE TABLE letopdutop (
id int(9) NOT NULL AUTO_INCREMENT,
titre longtext NOT NULL,
description longtext NOT NULL,
siteurl longtext NOT NULL,
banurl longtext,
email longtext NOT NULL,
password longtext NOT NULL,
bh int(9) DEFAULT '0' NOT NULL,
bw int(9) DEFAULT '0' NOT NULL,
entree int(7) DEFAULT '0' NOT NULL,
sortie int(7) DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);



Bu sekilde calısacaktır. ID degerinde Default vermene gerek yok cunku

evet çalişdi çok tşkler bilgi için