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.
精彩评论