Do you have an index on the client_id in the t_quiz table? Can you post
the ddl for t_quiz?
Ady Wicaksono wrote:
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]