grails not generating foreign keys

I`m really confused here about this weird behavior! The thing is, I have a grails app which in my local machine it is creating all FK in my MYSQL db.

But when I try running it in another machines the FK are not being created!

开发者_开发百科

Some reason for that? some permission problem? is there any way to debug the creation of the grails tables so I can figure this out?

thanks!

---

Your database is probably using ENGINE = MyISAM, which will cause foreign keys to not be created.

Try changing your engine to InnoDB.