I am not very happy with this new limitation (especially since I have projects with models that mix InnoDB and MyISAM tables in the same DB), but maybe that's not a big deal for most users?
https://issues.apache.org/cayenne/browse/CAY-717 Andrus
Assuming we don't have MySQL 3.x users anymore, I went ahead and
implemented MySQL FK constraint handling per CAY-717. One caveat is
that the Modeler will now explicitly generate InnoDB tables on MySQL
(in the past it would rely on the default table type set up by MySQL
admin outside the Modeler).
