bonjour j'essaye executer ce script mais voici mon erreur

ERROR at line 4: Invalid default value for 'id'


voici mon script


# Table structure for table 'userinfo'

CREATE TABLE userinfo (
id int(10) DEFAULT '0' NOT NULL auto_increment,
UserName varchar(30),
Name varchar(200),
Mail varchar(200),
Department varchar(200),
WorkPhone varchar(200),
HomePhone varchar(200),
Mobile varchar(200),
PRIMARY KEY (id),
KEY UserName (UserName),
KEY Department (Department)
);


si quelqu'un a une idée merci