Skip to content

Instantly share code, notes, and snippets.

@jonniesweb
Created March 27, 2016 22:34
Show Gist options
  • Save jonniesweb/e1e14d4e230987e1ef84 to your computer and use it in GitHub Desktop.
Save jonniesweb/e1e14d4e230987e1ef84 to your computer and use it in GitHub Desktop.
Liquibase configuration for setting the MySql engine and charset for each table
<changeSet>
<createTable>
...
</createTable>
<!-- Place this <modifySql> block at the bottom of each table definition. Search and replace works really well. -->
<modifySql dbms="mysql">
<append value="ENGINE=INNODB DEFAULT CHARSET=UTF8"/>
</modifySql>
</changeSet>
@way2jatin
Copy link

Is it possible to write inside a separate as on starting the db migration process, it will fire an error if the database is already deployed elsewhere.?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment