MySQL Forums
Forum List  »  French

problème avec une error 150
Posted by: guy gislain
Date: August 04, 2007 04:36AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
problème avec une error 150
5926
August 04, 2007 04:36AM
3453
August 08, 2007 11:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.