Re: Forward Engineer - Force insert order for FK constraints?

[Courtney Miles]

I just noticed at the head of the Forward Engineer script:

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

Clearly, FK constraints shouldn't be enforced. So I dug through the script and found that the set of variable set at the head of the script are reverted before the INSERT statements.

I'm not sure if this is intentional or not.

At least knowing this, each time I run the forward engineer, I just need to dig out where the variables are reverted and move them to the end of file... actually, I probably just need to delete them.