I've recently been working with a MySQL Database, and using MySQL workbench to design the Database. When I use the export to SQL function - so I can actually get the layout in to the Database - I get "Error 1005: Cannot create table" from MySQL. This appears to be related to Foreign Keys in the create table statement.
Does anybody have a work around for this that doesn't involve taking the constraints out and putting them back in later? That's a less than ideal solution given the size of the database.