SQL Грешка

[dashe]

Каква е тази грешка за първи път ми излиза

Грешка

SQL заявка:

CREATE TABLE comments(
id int( 11 ) NOT NULL AUTO_INCREMENT ,
article_id int( 11 ) NOT NULL default '',
name varchar( 30 ) NOT NULL default '',
website varchar( 50 ) NOT NULL default '',
email varchar( 50 ) NOT NULL default '',
COMMENT text NOT NULL ,
date datetime NOT NULL default '0000-00-00 00:00:00',
ip varchar( 20 ) NOT NULL default '',
PRIMARY KEY ( id )
) TYPE = MYISAM AUTO_INCREMENT =1

MySQL отговори:
#1067 - Invalid default value for 'article_id'

Друг път пак съм го слагал и не е излза а сега?
.. :?

 

[koko5]

опитай:
................
article_id int( 11 ) NOT NULL default 0,
.........................
ЕДИТ: DEFAULT 3a INT поле може да е 0, а не ''

CREATE TABLE comments(
id int( 11 ) NOT NULL AUTO_INCREMENT ,
article_id int( 11 ) NOT NULL default 0,
name varchar( 30 ) NOT NULL default '',
website varchar( 50 ) NOT NULL default '',
email varchar( 50 ) NOT NULL default '',
COMMENT text NOT NULL ,
date datetime NOT NULL default '0000-00-00 00:00:00',
ip varchar( 20 ) NOT NULL default '',
PRIMARY KEY ( id )
) TYPE = MYISAM;

8)

 

[hrischo]

CREATE TABLE comments(
id int( 11 ) NOT NULL AUTO_INCREMENT ,
article_id int( 11 ) NOT NULL,
name varchar( 30 ) NOT NULL default '',
website varchar( 50 ) NOT NULL default '',
email varchar( 50 ) NOT NULL default '',
COMMENT text NOT NULL ,
date datetime NOT NULL default '0000-00-00 00:00:00',
ip varchar( 20 ) NOT NULL default '',
PRIMARY KEY ( id )
) TYPE = MYISAM AUTO_INCREMENT =1

 

[dashe]

CREATE TABLE comments(
id int( 11 ) NOT NULL AUTO_INCREMENT ,
article_id int( 11 ) NOT NULL,
name varchar( 30 ) NOT NULL default '',
website varchar( 50 ) NOT NULL default '',
email varchar( 50 ) NOT NULL default '',
COMMENT text NOT NULL ,
date datetime NOT NULL default '0000-00-00 00:00:00',
ip varchar( 20 ) NOT NULL default '',
PRIMARY KEY ( id )
) TYPE = MYISAM AUTO_INCREMENT =1

+1