[Error Code: 1005, SQL State: HY000]

[Alejandro Barrero]

ALTER TABLE child ADD CONSTRAINT oneToMany FOREIGN KEY (one_to_many_name_col, one_to_many_primary_key_fk) REFERENCES parent(name, primaryKey) ON DELETE CASCADE
fails with error message: [Error Code: 1005, SQL State: HY000] Can't create table '.\mysql\#sql-a80_327.frm' (errno: 150)

With only the name primary key works fine, but fails with only primaryKey.
The SQL types are correct. one_to_many_name_col and name are VARCHAR(50), one_to_many_primary_key_fk is INTEGER and primaryKey is INTEGER UNSIGNED.

I initially had primaryKey INTEGER (it was failing too), but changed to INTEGER UNSIGNED after reading that the primary key becomes unsigned.

I am using MySQL Server 5.0.

Your help will be greatly appreciated,

Alejandro Barrero