Hi, > I'm trying to create a table with the following syntax > > CREATE TABLE TNSession > ( > SessionID int(11) NOT NULL auto_increment, > IPAddress varchar(50) default NULL, > Created datetime default NULL, > Expired tinyint(4) default '0', > AccountID int(11) default '0', > PRIMARY KEY (SessionID), > KEY FK_AccountID (AccountID), > CONSTRAINT `0_20` FOREIGN KEY (`AccountID`) REFERENCES `TNAccount` > (`AccountID`) > ) TYPE=InnoDB ROW_FORMAT=DYNAMIC; > > it results in a > > ERROR 1005: Can't create table './TNMailServer/TNSession.frm' (errno: 121) > > This is on version mysql-standard-4.0.18-pc-linux-i686 > > Can anyone shed any light on this as it has me stumped - There is a > TNAccount table with a AccountID column?
Is it indexed? And don't forget you can use the command SHOW INNODB STATUS\G to show the last FK related error. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
