I have a table that I converted in a migration from InnoDB to MyISAM (so I can add a fulltext index). The migrations all work well on development and deployment environments. My problem is I can not rake db:test:purge and then rake db:test:prepare because the schema.rb that gets generated does not have the engine change in it. I tried to go way back in the migrations (003 back from 068) and put in the :options => 'ENGINE=MyISAM' on the original create_table but the schema.rb still does not have that in it's create_table line.
I'm guessing this is a bug. (how presumptious of me!) Anybody seen this and have a workaround? I would like to be able to run the unit tests.
I know, I looked at ferret and solr. I have my own plugin
:acts_as_idiot
Mike Vargo