bład errno: 150, tworzenie obcych kluczy Opcje

[squid]

majac takie tabele :

[SQL] pobierz, plaintext 
CREATE TABLE `nodes` (
  `nodeID` int(10) UNSIGNED NOT NULL,
  `nodeName` varchar(64) DEFAULT NULL,
  PRIMARY KEY  (`nodeID`)
) TYPE=InnoDB;
 
# --------------------------------------------------------
 
#
# Struktura tabeli dla  `blood`
#
 
CREATE TABLE `blood` (
  `parentID` int(10) UNSIGNED NOT NULL,
  `childID` int(10) UNSIGNED NOT NULL,
  INDEX (`parentID`,`childID`),
  FOREIGN KEY(`parentID`) REFERENCES nodes(`nodeID`),
  FOREIGN KEY(`childID`) REFERENCES nodes(`nodeID`)
) TYPE=InnoDB;
[SQL] pobierz, plaintext 

otrzymuje taki komunikat:

Błąd


zapytanie SQL : 


CREATE TABLE `blood` (
`parentID` int( 10 ) unsigned NOT NULL ,
`childID` int( 10 ) unsigned NOT NULL ,
INDEX ( `parentID` , `childID` ) ,
FOREIGN KEY ( `parentID` ) REFERENCES nodes( `nodeID` ) ,
FOREIGN KEY ( `childID` ) REFERENCES nodes( `nodeID` )
) TYPE = InnoDB


MySQL zwrócił komunikat:


#1005 - Can't create table './test2/blood.frm' (errno: 150)

nie wiem co tam poprawic, ktos ma jakis pomysl?