Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Using SQLyog › Realtions And Foreign Keys
A good discussion on the same can be found at: http://forums.mysql.com/read.php?22,19755,38307
Make sure that the column definition for the source and target are same. InnoDB will not create FK even if there is a SIGN difference between the columns.
So … try making both integers UNSIGNED.