Date datetime not null default '0'

[trafficinsanity]

MySQL version 5.0.67-community

 

Here is the query in question

 

$sql="create table users

(

  ID int unsigned not null auto_increment primary key,

  Name varchar(75),

  Address varchar(175),

  City varchar(75),

  State varchar(75),

  Zip varchar(15),

  Country varchar(75),

  Email varchar(75),

  Username varchar(75),

  Password varchar(75),

  active varchar(75),

  ref_by varchar(75),

  IP varchar(25),

  Date datetime not null default '0'

)";

 

 

I am getting this error message:

 

Invalid default value for 'Date'

create table users ( ID int unsigned not null auto_increment primary key, Name varchar(75), Address varchar(175), City varchar(75), State varchar(75), Zip varchar(15), Country varchar(75), Email varchar(75), Username varchar(75), Password varchar(75), active varchar(75), ref_by varchar(75), IP varchar(25), Date datetime not null default '0' )

 

[fenway]

Because '0' is not a valid date/time... does that surprise you?