MySQL requires that indexes be created on all the columns used in a foreign key. This includes columns from both the child and parent table. Make sure there are indexes on all columns involved in foreign keys. However, starting with v4.1.2, MySQL will automatically add these indexes.

Make sure both tables use the InnoDb storage engine.

The data types of column pairs used in the foreign key should match, including the SIGNED/UNSIGNED settings.