Freddies Create mySQL Table Script

I was trying to use the Freddy tute but get a error message with PHP admin 2.5.3

CREATE TABLE auth (
userid
int(4)
unsigned
zerofill
DEFAULT ‘0000’
NOT NULL
auto_increment,
username varchar(20),
userpassword varchar(20),
PRIMARY KEY (userid)
);

Error

SQL-query :

CREATE TABLE auth( useridint( 4 ) unsignedzerofillDEFAULT ‘0000’ NOT NULL AUTO_INCREMENT ,
username varchar( 20 ) ,
userpassword varchar( 20 ) ,
PRIMARY KEY ( userid )
)

MySQL said:

#1064 - You have an error in your SQL syntax near ‘( 4 ) unsignedzerofillDEFAULT ‘0000’ NOT NULL AUTO_INCREMENT ,username varc’ at line 1

Can anyone see whats wrong with the table creation script ?