17 Dec 08 MySQL Error 1005

From personal experience, the error ERROR 1005 (HY000) is the result of having foreign key constraints of the same symbol name. It appears that the foreign key constraint cannot have the same symbol in the database – in other words, it must be unique throughout the database, not just the table.