rails/rails — pull request #8239 by kenmazaika (2012-11-16 15:58:32+00:00)
Title: Support Different Engines for Different Tables; Support MyISAM FULLTEXT indexes

Add support for different MySQL engines for different tables; Add support for MyISAM fulltext indexes in migrations, and schema.rb.

In a project I was working on we wanted to use MyISAM fulltext indexes for a single table, but continue to use InnoDB for the remaining tables. This patch adds support for that. Without this patch it's impossible to use the [full-text search query syntax](http://dev.mysql.com/doc/refman/5.5/en//fulltext-search.html), because in the test database it would continue to use the default engine for all, and not add the fulltext option to the index that is create (just a standard key would be created, which isn't what we needed).

* When dumping the schema to schema.rb, include engine information, and add a flag for fulltext indexes.
* When engine and fulltext index flags are in the migration, create the index as a fulltext one.

__Sources:__

Integrated: [multiple engine support from this gist](https://gist.github.com/1374003)