sql fout ? maar wat ?

[djwouter]

deze quary heb ik gemaakt maar zo dra ik hem invoer werkt hij niet dat zegt hij dat er een fout zit bij birth day maar ik kan niet ontdeken wat :S

CREATE TABLE IF NOT EXISTS PRO_MEMBERS(

id smallint unsigned ZEROFILL NOT NULL AUTO_INCREMENT ,
fname varchar( 16 ) NOT NULL default '',
lname varchar( 30 ) NOT NULL default '',
PASSWORD char( 16 ) NOT NULL default '',
birthday DATE NOT NULL default '0',
gender tinyint unsigned NOT NULL default '0',
purposes tinyint unsigned NOT NULL default '0',
country tinyint unsigned NOT NULL default '0',
email varchar( 64 ) NOT NULL default '',
url varchar( 64 ) NOT NULL default '',
icq int unsigned NOT NULL default '0',
aim varchar( 16 ) NOT NULL default '',
phone varchar( 20 ) NOT NULL default '',
city varchar( 32 ) NOT NULL default '',
marstat tinyint unsigned NOT NULL default '0',
child tinyint unsigned NOT NULL default '0',
height tinyint unsigned NOT NULL default '0',
weight tinyint unsigned NOT NULL default '0',
hcolor tinyint unsigned NOT NULL default '0',
ecolor tinyint unsigned NOT NULL default '0',
etnicity tinyint unsigned NOT NULL default '0',
religion tinyint unsigned NOT NULL default '0',
smoke tinyint unsigned NOT NULL default '0',
drink tinyint unsigned NOT NULL default '0',
education tinyint unsigned NOT NULL default '0',
job varchar( 30 ) NOT NULL default '',
hobby tinytext NOT NULL default '',
descr text NOT NULL default '',
sgender tinyint unsigned NOT NULL default '0',
setnicity tinyint unsigned NOT NULL default '0',
sreligion tinyint unsigned NOT NULL default '0',
agef tinyint unsigned NOT NULL default '0',
aget tinyint unsigned NOT NULL default '0',
heightf tinyint unsigned NOT NULL default '0',
heightt tinyint unsigned NOT NULL default '0',
weightf tinyint unsigned NOT NULL default '0',
weightt tinyint unsigned NOT NULL default '0',
hdyfu tinyint unsigned NOT NULL default '0',
pic1 varchar( 24 ) NOT NULL default '',
pic2 varchar( 24 ) NOT NULL default '',
pic3 varchar( 24 ) NOT NULL default '',
horo tinyint unsigned NOT NULL default '0',
regdate DATETIME NOT NULL default '0',
editdate DATETIME NOT NULL default '0',
ip int unsigned NOT NULL default '0',
STATUS tinyint unsigned NOT NULL default '0',
req tinyint unsigned NOT NULL default '0',
UNIQUE KEY id( id ) 
)

dit is de fout melding

#1067 - Invalid default value for 'birthday'

ik haal de quary uit een php script om dat het met die install al niet werkte dus hier onder de php

$sql = "CREATE TABLE IF NOT EXISTS ".C_MYSQL_MEMBERS." (
  id smallint unsigned ZEROFILL NOT NULL auto_increment,
  fname varchar(16) NOT NULL default '',
  lname varchar(30) NOT NULL default '',
  password char(16) NOT NULL default '',
  birthday DATE NOT NULL default '0',
  gender tinyint unsigned NOT NULL default '0',
  purposes tinyint unsigned NOT NULL default '0',
  country tinyint unsigned NOT NULL default '0',
  email varchar(64) NOT NULL default '',
  url varchar(64) NOT NULL default '',
  icq int unsigned NOT NULL default '0',
  aim varchar(16) NOT NULL default '',
  phone varchar(20) NOT NULL default '',
  city varchar(32) NOT NULL default '',
  marstat tinyint unsigned NOT NULL default '0',
  child tinyint unsigned NOT NULL default '0',
  height tinyint unsigned NOT NULL default '0',
  weight tinyint unsigned NOT NULL default '0',
  hcolor tinyint unsigned NOT NULL default '0',
  ecolor tinyint unsigned NOT NULL default '0',
  etnicity tinyint unsigned NOT NULL default '0',
  religion tinyint unsigned NOT NULL default '0',
  smoke tinyint unsigned NOT NULL default '0',
  drink tinyint unsigned NOT NULL default '0',
  education tinyint unsigned NOT NULL default '0',
  job varchar(30) NOT NULL default '',
  hobby tinytext NOT NULL default '',
  descr text NOT NULL default '',
  sgender tinyint unsigned NOT NULL default '0',
  setnicity tinyint unsigned NOT NULL default '0',
  sreligion tinyint unsigned NOT NULL default '0',
  agef tinyint unsigned NOT NULL default '0',
  aget tinyint unsigned NOT NULL default '0',
  heightf tinyint unsigned NOT NULL default '0',
  heightt tinyint unsigned NOT NULL default '0',
  weightf tinyint unsigned NOT NULL default '0',
  weightt tinyint unsigned NOT NULL default '0',
  hdyfu tinyint unsigned NOT NULL default '0',
  pic1 varchar(24) NOT NULL default '',
  pic2 varchar(24) NOT NULL default '',
  pic3 varchar(24) NOT NULL default '',
  horo tinyint unsigned NOT NULL default '0',
  regdate DATETIME NOT NULL default '0',
  editdate DATETIME NOT NULL default '0',
  ip int unsigned NOT NULL default '0',
  status tinyint unsigned NOT NULL default '0',
  req tinyint unsigned NOT NULL default '0',
  UNIQUE KEY id (id)
)";

dus heb zelf al het een en ander aan gepast maar weet niet zekker of dat wel helemaal goed is

zouden julie de fout kunen vinden ??

 

[Tha Devil]

Probeer dit eens:

birthday DATE NOT NULL default '0000-00-00',

Aangezien het een type DATE is zul je dus een datum-formaat moeten instellen.