Re: ERROR 1005: Can't create table (errno: 150) [ANOTHER SOLUTION]

[Esen Sagynov]

Jim Smith Wrote:
-------------------------------------------------------
> In my case, the problem was that the NAMES of the
> foreign keys were not unique.
> I wasn't aware that this was a requirement, but
> changing them worked.
> So I changed the line:
> KEY `fk_productid`
> to
> KEY `fk_productid222`
>
> And it worked! (This was because another table
> was using the foreign key name "fk_productid"

This is really stupid, but it solved my problem. I suppose MySQL keeps track of constraint names globally for the current database, so names should be unique.
CUBRID DBMS (http://www.cubrid.org), for example, creates constraints per table, which does not make me search for an hour for such kind of solution.