Update "2013_03_1_Merc_Rules_and Equipment" SQL Error

[PallbearerX]

MySQL is complaining about the foreign key definition in the 'CREATE TABLE merc_inventory' step.

/* SQL Error (1005): Can't create table 'peq.merc_inventory' (errno: 150)
Foreign key constraint is incorrectly formed */

I've been following the Windows Server Setup Guide. This is the first issue I've encountered.

The peqdb source is revision 2506 and I'm attempting to apply the required updates under the \EQ\Source\utils\sql\git\required directory.

This is the SQL statement from the source file.

CREATE TABLE merc_inventory (
merc_inventory_id int(10) unsigned NOT NULL auto_increment,
merc_subtype_id int(10) unsigned NOT NULL default '0',
item_id int(11) unsigned NOT NULL default '0',
min_level int(10) unsigned NOT NULL default '0',
max_level int(10) unsigned NOT NULL default '0',
PRIMARY KEY (merc_inventory_id),
KEY FK_merc_inventory_1 (merc_subtype_id),
CONSTRAINT FK_merc_inventory_1 FOREIGN KEY (merc_subtype_id) REFERENCES merc_subtypes (merc_subtype_id)
);

Normally, I think we'd see this error if the merc_subtype_id column in the merc_subtypes table did not have an index, but I've verified that it does. I'm not sure why SQL would be throwing this foreign key constaint error.

Has anyone else run into this?

PbX