meter varias claves foranes

[superweb360]

Código SQL:

CREATE TABLE `ffxi_characterJob` (
`serverID` INT(11) NOT NULL,
`userid` INT(10)UNSIGNED NOT NULL,
`characterName` VARCHAR(255) NOT NULL,
`jobAbbr` CHAR(4) NOT NULL,
`jobLevel` INT(11) DEFAULT '0',
PRIMARY KEY (`serverID`,`userid`,`characterName`,`jobAbbr`),
INDEX (`jobAbbr`),
CONSTRAINT FOREIGN KEY (`serverID`,`userid`,`characterName`) REFERENCES `ffxi_characters` (`serverID`,`userid`,`characterName`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT FOREIGN KEY (`jobAbbr`) REFERENCES `ffxi_jobType` (`jobAbbr`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB;