hello
I try to create a table with this statment
CREATE TABLE referants (
id int(10) DEFAULT '0' NOT NULL auto_increment,
referant char(200) NOT NULL,
hits int(10) DEFAULT '0' NOT NULL,
UNIQUE id (id)
);

but MySQL return a error message
#1067 - Invalid default value for 'id'

and because I'm a beginner I don't know how to avoid this error

thanks for your help

bruno