Deployment scripts don't retain the names of foreign keys. Should use the CONSTRAINT `name` syntax when generating the script.
Having foreign key constrains renamed things like 'ibfk_3' causes maintenance problems. When generating an update script, the tool should retain the name of the foreign key by using the CONSTRAINT
name_of_constraint syntax before the FOREIGN KEY keywords.