<p>I've recently been working with a MySQL database, and using MySQL workbench to design the Database.</p>

<p>When I use the export to SQL function, so I can actually get the layout in to the Database, I get:</p>

<blockquote>
  <p>"Error 1005: Cannot create table"</p>
</blockquote>

<p>This appears to be related to Foreign Keys in the create table statement.</p>

<p>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.</p>

I ran into this situation recently when I attempted (in InnoDB tables) to make a foreign key reference to a column that had a different data type.
MySQL 5.1 Documentation