Bad? id int(11) DEFAULT '0'

Hello

I'm trying to install the authlib module that's required for
the open-source iOutliner web-based outliner (http://ioutliner.com),
but it fails halfway through when creating the tables:

//Bad! /* SQL Error: Invalid default value for 'id' */
$query = mysql_query("CREATE TABLE authlib_data (
id int(11) DEFAULT '0' NOT NULL auto_increment,
name text NOT NULL,
email text NOT NULL,
age int(3) DEFAULT '0' NOT NULL,
*** text NOT NULL,
school text NOT NULL,
PRIMARY KEY (id)
)");

//Bad! /* SQL Error: Invalid default value for 'id' */
$query = mysql_query("CREATE TABLE authlib_login (
id int(11) DEFAULT '0' NOT NULL auto_increment,
username text NOT NULL,
password text NOT NULL,
PRIMARY KEY (id)
)");

According to Google, DEFAULT '(0)' seems a legit instruction. What's
wrong with this?

Thank you.

> id int(11) DEFAULT '0' NOT NULL auto_increment,

....

> According to Google, DEFAULT '(0)' seems a legit instruction. What's
> wrong with this?

Maybe the fact that an auto_increment column cannot have a default? I
mean, what are you trying to accomplish with that default value?

Regards,
--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/

On Fri, 08 Jun 2007 08:49:20 +0200, Willem Bogaerts
<w.bogaerts@kratz.maardanzonderditstuk.nl> wrote:
>Maybe the fact that an auto_increment column cannot have a default? I
>mean, what are you trying to accomplish with that default value?

I'm just the messenger :-)