# generateChangeLog ignores foreign keys, DB engine types (InnoDB)

**URL:** <https://forum.liquibase.org/t/generatechangelog-ignores-foreign-keys-db-engine-types-innodb/2951>\
**Category:** General Discussion\
**Created:** [April 6, 2014, 6:46pm UTC](https://forum.liquibase.org/t/generatechangelog-ignores-foreign-keys-db-engine-types-innodb/2951 "2014-04-06T18:46:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![GavrielFleischer](https://avatars.discourse-cdn.com/v4/letter/g/7ea924/32.png) [@GavrielFleischer](https://forum.liquibase.org/u/GavrielFleischer)\
**Post date:** [April 6, 2014, 6:46pm UTC](https://forum.liquibase.org/t/generatechangelog-ignores-foreign-keys-db-engine-types-innodb/2951/1 "2014-04-06T18:46:00Z")

</div>

Hi,

I have a mysql database with some MyISAM and some InnoDB tables, foreign key relations between some of the InnoDB tables. When I do generateChangeLog, there are no foreign-keys in changelog.xml. Is this a bug? Or is this a missing feature?

The DB engine is also “lost” in changelog.xml.

PS: it’s impossible to log in to the forum using the Google as OpenId (redirects to 404 page)

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [April 6, 2014, 6:46pm UTC](https://forum.liquibase.org/t/generatechangelog-ignores-foreign-keys-db-engine-types-innodb/2951/2 "2014-04-06T18:46:00Z")

</div>

The foreign keys are between InnoDB tables? I don’t remember off hand if myisam stores FK metadata even though they don’t support FKs.&nbsp;

Also, are they between tables in different databases/schemas? Or all in the same database?

Unfortunately the DBEngine is database-specific functionality that is not captured in liquibase and so needs to be added yourself. The generateChangeLog logic tries to handle normal cross-database features but doesn’t yet get into more unique attributes.

Nathan