Create MySql table not working

programming
1

[font=verdana, arial, helvetica][size=2]hi,

I’m using myphpadmin to create a table in my MySql database (following the tutorial on this site), like this

CREATE TABLE tableauth (

username VARCHAR( 20 ) UNSIGNED ZEROFILL DEFAULT ‘0000’ NOT NULL AUTO_INCREMENT ,
userpassword VARCHAR( 20 ) UNSIGNED ZEROFILL DEFAULT ‘0000’ NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( username , userpassword )
)

but myphpadmin keeps giving me the error…

You have an error in your SQL syntax near ‘UNSIGNED ZEROFILL DEFAULT ‘0000’ NOT NULL AUTO_INCREMENT, userpassword VARCHAR’ at line 1

any ideas??

thanks

boombanguk[/size][/font]