Mysql Create table shows ERROR 1005 errno 150

foreign keyinnodbMySQLtable

I am trying to make a junction table, but I getting a ERROR 1005 errno 150

CREATE TABLE 61furiousFistPokemon(
cardNumber int NOT NULL PRIMARY KEY,
pokemonName VARCHAR(12),
type VARCHAR(10),
stage VARCHAR(10),
evolvesFrom VARCHAR(12),
HP INT,
retreatCost INT,
weakness VARCHAR(10),
weaknessAmount VARCHAR(5),
resistance VARCHAR(5),
resistanceAmount VARCHAR(5)
);

CREATE TABLE cardTags (
tagId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
tagName VARCHAR(60) NOT NULL
);

CREATE TABLE 61furiousFistPokemonTags (
tagId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
pokemonCardNumber int,
tagName VARCHAR(60),
FOREIGN KEY (pokemonCardNumber) REFERENCES 61furiousFistPokemon(cardNumber),
FOREIGN KEY (tagName) REFERENCES cardTags(tagName)
);

Any help would be greatly appreciated.

Best Answer

tagName column in table cardTags is not defined as primary key and you are declaring foreign key FOREIGN KEY (tagName) REFERENCES cardTags(tagName).