Bug 1207575

Description of problem:

The file db.changelog-1.0.xml includes a couple of changesets which attempt to prevent Zanata from creating MyISAM tables by accident, but they don't seem to be working in all cases (recent versions of mysql?).  Since Zanata is supposed to be using InnoDB, this can lead to all sorts of transaction consistency and performance bugs.

This sql can be used to show the MyISAM tables in a schema:
  SELECT TABLE_NAME FROM information_schema.TABLES WHERE ENGINE='MyISAM' and TABLE_SCHEMA='zanata';

On my machine with a fairly recent production backup (March 2015), multiple tables are showing as MyISAM:

	Activity
	DATABASECHANGELOG
	DATABASECHANGELOGLOCK
	HAccountOption
	HDocumentUpload
	HDocumentUploadPart
	HDocument_RawDocument
	HPersonEmailValidationKey
	HProjectIteration_Validation
	HProject_Validation
	HRawDocument
	HRoleAssignmentRule
	HTextFlowTargetReviewComment
	IterationGroup_Locale
	TransMemory
	TransMemoryUnit
	TransMemoryUnitVariant
	TransMemory_Metadata

I think we need to revisit the way we ensure tables are created as InnoDB in Liquibase.  One option is modifySql: http://www.liquibase.org/documentation/modify_sql.html  A cleaner solution is probably a custom CreateTableGenerator, as suggested here: http://blog.liquibase.org/2011/01/liquibase-2-0-officially-released.html

We also need to run another changeset to convert any potentially affected tables to InnoDB.  See the original fix for an example of this: https://github.com/zanata/zanata-server/commit/45d8e57e7476a1146e72abea0011f657555cbb75