#1067 - Invalid default value for 'userid'

[dfi]

I'm using MySQL 4.1 and an online tutorial to create a password-protected Flash homepage.  The tutorial instructs me to use this script to create a table in MySQL.

 

--------------------------------------------------------

CREATE TABLE auth (

  userid

    int(4)

    unsigned

    zerofill

    DEFAULT '0000'

    NOT NULL

    auto_increment,

  username varchar(20),

  userpassword varchar(20),

  PRIMARY KEY (userid)

);

--------------------------------------------------------

 

When I enter that script, I get this error from MySQL.

 

--------------------------------------------------------

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: Documentation

#1067 - Invalid default value for 'userid'

--------------------------------------------------------

 

I know Flash well, but I am very new to MySQL.  Any help would be greatly appreciated to get me passed this error.  Thank you in advance.  Here is the link to the tutorial that I'm using.

http://www.kirupa.com/developer/actionscript/authentication.htm

[gevans]

You don't need a default with an auto_increment field.

Get rid of the default line and it should work fine.