Adding Foreign Key

[Ady Wicaksono]

mysql> alter table t_quiz_trivia add foreign key (client_id) references 
t_client (client_id) on delete set default;
ERROR 1005: Can't create table './smsserver/#sql-215d_11eff.frm' (errno: 
150)

May i know what makes error ?
Here is the reference table
CREATE TABLE `t_client` (
 `client_id` int(11) NOT NULL default '0',
 `client_desc` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`client_id`)
) TYPE=InnoDB;

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]