problème avec une error 150
Bonjour, lors de l'exécution des 2 séquences suivantes, j'ai une error 150.
Voici les 2 séquences :
CREATE TABLE `agtconfig` (
`agentID` int( 10 ) unsigned NOT NULL default '0',
`k` varchar( 17 ) NOT NULL default '',
`v` varchar( 17 ) NOT NULL default '',
PRIMARY KEY ( `agentID` , `k` ) ,
CONSTRAINT `FK_AGTCONFIG_AGTAGENTS` FOREIGN KEY ( `agentID` ) REFERENCES `agtagents` ( `agentID` )
) ENGINE = InnoDB DEFAULT CHARSET = utf8;
MySQL a répondu:
#1005 - Can't create table '.\evet4\agtconfig.frm' (errno: 150)
et
CREATE TABLE `agtagents` (
`agentID` int(10) unsigned NOT NULL default '0',
`divisionID` int(10) unsigned NOT NULL default '0',
`corporationID` int(10) unsigned NOT NULL default '0',
`stationID` int(10) unsigned default NULL,
`level` tinyint(3) unsigned NOT NULL default '0',
`quality` int(11) default NULL,
`agentTypeID` int(10) unsigned NOT NULL default '0',
`gender` tinyint(3) unsigned NOT NULL default '0',
`bloodlineID` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`agentID`),
KEY `FK_AGENTS_AGENTTYPES` (`agentTypeID`),
KEY `stationID` (`stationID`),
KEY `divisionID` (`divisionID`),
KEY `FK_AGENTS_CORPORATION` (`corporationID`),
CONSTRAINT `agtAgents_ibfk_1` FOREIGN KEY (`stationID`) REFERENCES `stastations` (`stationID`),
CONSTRAINT `agtAgents_ibfk_3` FOREIGN KEY (`divisionID`) REFERENCES `crpnpcdivisions` (`divisionID`),
CONSTRAINT `FK_AGENTS_AGENTTYPES` FOREIGN KEY (`agentTypeID`) REFERENCES `agtagenttypes` (`agentTypeID`),
CONSTRAINT `FK_AGENTS_CORPORATION` FOREIGN KEY (`corporationID`) REFERENCES `corporation` (`corporationID`),
CONSTRAINT `FK_AGENTS_NPCDIVISIONS` FOREIGN KEY (`divisionID`) REFERENCES `crpnpcdivisions` (`divisionID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
et je n'arrive pas à trouver mes erreurs. Merci d'avance