Adding Foreign Key Fails in MySQL (errno 150)

gistfile1.txt

The solution:


    The two tables must have the same engine i.e. ENGINE=InnoDB. (can be others: ENGINE=MyISAM works too)
    The two tables must have the same charset.
    The PK column(s) in the parent table and the FK column(s) must be the same data type. (if the PRIMARY Key in the Parent table is UNSIGNED, be sure to select UNSIGNED in the Child Table field)
    The PK column(s) in the parent table and the FK column(s), if they have a define collation type, must have the same collation type;
    If there is data already in the foreign key table, the FK column value(s) must match values in the parent table PK columns.
    And the child table cannot be a temporary table.

Error: Cannot add or update a child row: a foreign key constraint fails
is returned when in one table dont have column number for other