I'm using MySQL 5 with InnoDB tables. I'm trying to create a foreign key,
but when I try, it's giving me an error. I've tried this with the
MySQLQuery Browser, and EMS SQL Manager 2005. I get the following error in
the Query Browser:
Error while executing query.
ALTER TABLE `karate`.`custpoints` ADD CONSTRAINT `FK_custpoints_1` FOREIGN
KEY `FK_custpoints_1` (`CTID`)
REFERENCES `custtournaments` (`ID`)
ON DELETE CASCADE
ON UPDATE RESTRICT;
MySQL Error Number 1005
Can't create table '.\karate\#sql-304_9.frm' (errno: 150)
Any idea why this is happening, and how to fix it?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
