Steps to reproduce:
1. get a Matterhorn 1.4.3+ mysql database
2. use the mysql upgrade script from 1.4.3_to_1.5.0
3. I get the error:
ERROR 1005 (HY000) at line 4: Can't create table 'matterhorneinsvier.mh_role' (errno: 150)
The table mh_role is renamed to mh_role_tmp with different columns. errno is:
If you re-create a table that was dropped, it must have a definition that conforms to the foreign key constraints referencing it. It must have the right column names and types, and it must have indexes on the referenced keys, as stated earlier. If these are not satisfied, MySQL returns error number 1005 and refers to error 150 in the error message.