Invalid default value

[egturnkey]

Hello Friends,

I'm trying to write a table but it keeps giving me error as the following



#1067 - Invalid default value for 'membership'






CREATE TABLE tmpmember (
tmpmemberID int(11) NOT NULL auto_increment,
title varchar(80) NOT NULL default '',
name varchar(80) NOT NULL default '',
email varchar(80) NOT NULL default '',
address varchar(80) NOT NULL default '',
mobile varchar(80) NOT NULL default '',
phone varchar(80) NOT NULL default '',
fax varchar(80) NOT NULL default '',
username varchar(15) NOT NULL default '',
password varchar(15) NOT NULL default '',
membership int(2) NOT NULL default '',
payment int(2) NOT NULL default '',
creation_date bigint(14) NOT NULL,
PRIMARY KEY (tmpmemberID),
UNIQUE (tmpmemberID),
FOREIGN KEY (userID) REFERENCES userdb(userID) ON DELETE CASCADE
) TYPE=MyISAM;



thanks in advance.

[thetestingsite]

Try adding the highlighted below:


CREATE TABLE tmpmember (
tmpmemberID int(11) NOT NULL auto_increment,
title varchar(80) NOT NULL default '',
name varchar(80) NOT NULL default '',
email varchar(80) NOT NULL default '',
address varchar(80) NOT NULL default '',
mobile varchar(80) NOT NULL default '',
phone varchar(80) NOT NULL default '',
fax varchar(80) NOT NULL default '',
username varchar(15) NOT NULL default '',
password varchar(15) NOT NULL default '',
membership int(2) NOT NULL default '0',
payment int(2) NOT NULL default '0',
creation_date bigint(14) NOT NULL,
PRIMARY KEY (tmpmemberID),
UNIQUE (tmpmemberID),
FOREIGN KEY (userID) REFERENCES userdb(userID) ON DELETE CASCADE
) TYPE=MyISAM;


Hope this helps.

[egturnkey]

thanks you so much , it now works fine.