Sure. Here is the information on both tables:
DROP TABLE IF EXISTS `karate`.`custtournaments`;
CREATE TABLE `karate`.`custtournaments` (
`ID` int(10) unsigned NOT NULL auto_increment,
`CustID` int(10) unsigned NOT NULL default '0',
`TournamentName` varchar(45) NOT NULL default '',
`TournamentDate` datetime NOT NULL default '0000-00-00 00:00:00',
`Style` varchar(20) default NULL,
`BegLevel` varchar(20) NOT NULL default '',
`EndLevel` varchar(20) NOT NULL default '',
`Match` varchar(20) NOT NULL default '',
`SubDiv` varchar(60) NOT NULL default '',
`BegWt` int(10) unsigned NOT NULL default '0',
`EndWt` int(10) unsigned NOT NULL default '0',
`BegAge` int(10) unsigned NOT NULL default '0',
`EndAge` int(10) unsigned NOT NULL default '0',
`BegHtFt` int(10) unsigned NOT NULL default '0',
`BegHtIn` int(10) unsigned NOT NULL default '0',
`EndHtFt` int(10) unsigned NOT NULL default '0',
`EndHtIn` int(10) unsigned NOT NULL default '0',
`Gender` varchar(1) NOT NULL default '',
`Ring` varchar(2) default NULL,
`Order` int(10) unsigned NOT NULL default '0',
`DivNum` varchar(7) NOT NULL default '',
`Time` varchar(8) default NULL,
`Status` varchar(3) NOT NULL default '',
`Judge1` varchar(30) default NULL,
`Judge1Score` double(5,1) default '0.0',
`Judge2` varchar(30) default NULL,
`Judge2Score` double(5,1) default '0.0',
`Judge3` varchar(30) default NULL,
`Judge3Score` double(5,1) default '0.0',
`Judge4` varchar(30) default NULL,
`Judge4Score` double(5,1) default '0.0',
`Judge5` varchar(30) default NULL,
`Judge5Score` double(5,1) default '0.0',
`ScoreKeep` varchar(30) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `karate`.`custpoints`;
CREATE TABLE `karate`.`custpoints` (
`ID` int(11) NOT NULL auto_increment,
`Status` varchar(3) default NULL,
`Association` varchar(15) default NULL,
`Points` tinyint(3) default NULL,
`CTID` int(11) NOT NULL,
PRIMARY KEY (`ID`),
KEY `CTID` (`CTID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Thanks,
Jesse
----- Original Message -----
From: "Chris White" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Wednesday, July 19, 2006 2:33 PM
Subject: Re: Error when creating Foreign Key
On Wednesday 19 July 2006 10:25 am, Jesse wrote:
MySQL Error Number 1005
Can't create table '.\karate\#sql-304_9.frm' (errno: 150)
KEY `FK_custpoints_1` (`CTID`)
REFERENCES `custtournaments` (`ID`)
can you show us the column declarations for these two?
Any idea why this is happening, and how to fix it?
Thanks,
Jesse
--
Chris White
PHP Programmer/DBlankSlate
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]