Below DDL for t_quiz_trivia
CREATE TABLE `t_quiz_trivia` (
`quiz_id` int(11) NOT NULL auto_increment,
`quiz_name` text NOT NULL,
`quiz_keycode` varchar(255) NOT NULL default '',
`quiz_pil_jwb` varchar(255) NOT NULL default '',
`quiz_confirmation_msg` varchar(255) NOT NULL default '',
`quiz_error_message` varchar(255) NOT NULL default '',
`quiz_help_message` varchar(255) NOT NULL default '',
`quiz_tarif_telkomsel` mediumint(9) NOT NULL default '2000',
`quiz_tarif_satelindo` mediumint(9) NOT NULL default '2000',
`quiz_tarif_im3` mediumint(9) NOT NULL default '2000',
`quiz_tarif_proxl` mediumint(9) NOT NULL default '2000',
`quiz_tarif_mobile8` mediumint(9) NOT NULL default '2000',
`quiz_tarif_flexy` mediumint(9) NOT NULL default '2000',
`quiz_tarif_lippo_telecom` mediumint(9) NOT NULL default '2000',
`quiz_point_keycode` varchar(45) NOT NULL default 'point,poin',
`quiz_point_answer` varchar(160) NOT NULL default 'Poin anda saat ini adalah: ___POIN___',
`quiz_help_keycode` varchar(45) NOT NULL default 'help',
`quiz_start_keycode` varchar(255) NOT NULL default 'start,ok',
`quiz_tarif_esia` mediumint(9) NOT NULL default '2000',
`quiz_tarif_starone` mediumint(9) NOT NULL default '2000',
`client_id` int(11) NOT NULL default '0',
PRIMARY KEY (`quiz_id`),
KEY `t_idx01` (`client_id`)
) TYPE=InnoDB
Victor Pendleton wrote:
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]
