[RESOLVED] MySQL warning when creating tables

[igorlopez]

Hi,

I have three tables that produces a warning upon creation.
What should I do about it?

The tables are created like:

create table Comments(
 cId           int(10) unsigned    NOT NULL auto_increment,
 cRev          tinyint unsigned    NOT NULL default 0,
 c_apId        int(10) unsigned    NOT NULL references APhotoList(apId),
 cCont         text                NOT NULL default '',
 cCreated      int(10) unsigned,
 c_uId         int(10) unsigned    references Users(uId),
 PRIMARY KEY (cId)
);

create table Topics(
 tId           int(10) unsigned    NOT NULL auto_increment,
 tRev          tinyint unsigned    NOT NULL default 0,
 t_gId         int(10) unsigned    NOT NULL references Groups(gId), 
 t_uId         int(10) unsigned    NOT NULL references Users(uId),
 tDescr        varchar(100)        NOT NULL default '',
 tCont         text                NOT NULL default '',
 tCreated      int(10) unsigned,
 tLast         int(10) unsigned,
 tLast_uId     int(10) unsigned             references Users(uId),
 tVisi	       enum('PUB', 'PRI')  NOT NULL default 'PRI',
 PRIMARY KEY (tId)
);

create table Replys(
 rId           int(10) unsigned    NOT NULL auto_increment,
 r_tId         int(10) unsigned    NOT NULL references Topics(tId), 
 r_uId         int(10) unsigned    NOT NULL references Users(uId),
 rCont         text                NOT NULL default '',
 rCreated      int(10) unsigned,
 PRIMARY KEY (rId)
);

The warning in the mysql window:

Query OK, 0 rows affected, 1 warning (0.01 sec)

[YAOMK]

what is the actual warning?

in mysql console:

show warnings;

[igorlopez]

Thanx for the help.

mysql> show warnings;
+---------+------+-----------------------------------------------------+
| Level   | Code | Message                                             |
+---------+------+-----------------------------------------------------+
| Warning | 1101 | BLOB/TEXT column 'rCont' can't have a default value | 
+---------+------+-----------------------------------------------------+
1 row in set (0.00 sec)

solved the pb.