for (Class<?> clazz : classes) {
generator.addTable(clazz);
}
// get the Database model
Database database = generator.getDatabase();
Platform platform = PlatformFactory.createNewPlatformInstance("mysql");
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection = DriverManager.getConnection(url, username, password);
System.out.println(platform.getAlterTablesSql(connection, database));
// this will perform the database changes
CreationParameters cp = new CreationParameters();
// to search, it requires MyISAM
cp.addParameter(database.findTable("discoveries_search"), "ENGINE", "MyISAM");
cp.addParameter(database.findTable("discoveries_search2"), "ENGINE", "MyISAM");
platform.alterTables(connection, database, cp, true);
connection.close();