sql error somewhere

[eaglelegend]

hey this is what comes up when I try dyumping my sql tables in my database, I am unsure what is up?

[code][code]SQL query: 

CREATE TABLE colors(

id int( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
hex varchar( 6 ) DEFAULT 'dddddd' NOT NULL ,
label varchar( 20 ) DEFAULT 'Medium Gray' NOT NULL ,
PRIMARY KEY ( id ) 
);



MySQL said:  

#1067 - Invalid default value for 'id' 

[/code] [/code]

[Chicken Little]

Browse the structure of the table and see if you can change the id field to

 

int(11) unsigned NOT NULL auto_increment

 

The id field is set to autoincrement (zero wouldn't apply).