# generateChangeLog (MySQL) does not work with cross schema foreign keys?

**URL:** https://forum.liquibase.org/t/generatechangelog-mysql-does-not-work-with-cross-schema-foreign-keys/2927
**Category:** General Discussion
**Created:** [March 3, 2014, 8:21pm UTC](https://forum.liquibase.org/t/generatechangelog-mysql-does-not-work-with-cross-schema-foreign-keys/2927 "2014-03-03T20:21:00Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![PhoenixtheII](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/phoenixtheii/32/121_2.png) [@PhoenixtheII](https://forum.liquibase.org/u/PhoenixtheII)
#### Post date: [March 3, 2014, 8:21pm UTC](https://forum.liquibase.org/t/generatechangelog-mysql-does-not-work-with-cross-schema-foreign-keys/2927/1 "2014-03-03T20:21:00Z")

</div>

We’re using MySQL 5.5 and a database designed with mysql workbench.

We have defined multiple schema’s with tables inside them ofcourse.

tables in the schema’s can have foreign keys to another schema’s table.

I’m using maven to run liquibase:

I’m willing to provide the .sql to create the entire database structure to reproduce this problem. But not through public channels.

---

<div class="post-metadata">

### Author: ![un1393848631976r75id](https://avatars.discourse-cdn.com/v4/letter/u/ecae2f/32.png) [@un1393848631976r75id](https://forum.liquibase.org/u/un1393848631976r75id)
#### Post date: [March 3, 2014, 8:21pm UTC](https://forum.liquibase.org/t/generatechangelog-mysql-does-not-work-with-cross-schema-foreign-keys/2927/2 "2014-03-03T20:21:00Z")

</div>

Could this have any relevance to&nbsp;[https://liquibase.jira.com/browse/CORE-1785](https://liquibase.jira.com/browse/CORE-1785) and&nbsp;[https://liquibase.jira.com/browse/CORE-1784&nbsp;by](https://liquibase.jira.com/browse/CORE-1784%C2%A0by) any chance?

---

<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: [March 3, 2014, 8:21pm UTC](https://forum.liquibase.org/t/generatechangelog-mysql-does-not-work-with-cross-schema-foreign-keys/2927/3 "2014-03-03T20:21:00Z")

</div>

The fix for CORE-1784 may apply to your problem even through you are seeing a different symptom. CORE-1785 will add the support you are looking for to create a single changelog across multiple schemas. It is implemented for the command line version so far, so the change just needs to be added to the maven plugin.

If you could send your sql to me [nathan@liquibase.org](mailto:nathan@liquibase.org) I could make sure the fixes address your problem.

Nathan