MySQL Error - Need assistance!

[xtrax]

Hello everyone.

 

I am new here but need help with a MySQL statment...

 

This is the mySQL table

 

/*Begin Create Clients*/

$query = "CREATE TABLE `".DB_PREFIX."clients` (

`client_id` int(11) NOT NULL auto_increment,

`username` varchar(100) NOT NULL default '',

`password` varchar(100) NOT NULL default '',

`company` varchar(255) default NULL,

`email` varchar(255) NOT NULL default '',

`first_name` varchar(100) default '',

`last_name` varchar(100) default '',

`address` varchar(255) default NULL,

`address_2` varchar(100) default '',

`city` varchar(100) default '',

`state` varchar(100) default '',

`zip` varchar(100) default '',

`client_number` int(11) default '',

`phone_number` varchar(100) default '',

`fax_number` varchar(100) default '',

`ptax` double(10,4) NOT NULL default '0.0725',

`p2tax` double(10,4) NOT NULL default '0.1900',

`gtax` double(10,4) NOT NULL default '0.0725',

PRIMARY KEY  (`client_id`),

UNIQUE KEY `username` (`username`)

) TYPE=MyISAM;";

mysql_query ($query);

 

However mySQL is complaining about the following line

 

MySQL said: 

 

#1067 - Invalid default value for 'client_number'

 

If anyone could help me it would be appreciated....

 

xtrax

[xtrax]

I am running the following Specs,

 

MySQL version: 5.0.67-community

PHP version 5.2.6

 

Any help would be appreciated

[kickstart]

Hi

 

ClientNumber is an integer, so the default should be an integer. Probably 0 rather than ''.

 

All the best

 

Keith