Contents

class CreatePostFulltextIndex < ActiveRecord::Migration
  def self.up
    execute 'ALTER TABLE posts ENGINE = MyISAM'
    execute 'CREATE FULLTEXT INDEX fulltext_posts ON posts (title,content)'
  end

  def self.down
    execute 'ALTER TABLE posts ENGINE = InnoDB'
    execute 'DROP INDEX fulltext_posts ON posts'
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
mysql_simple_fulltext-0.0.3	test/dummy/db/migrate/20120219133758_create_post_fulltext_index.rb
mysql_simple_fulltext-0.0.2	test/dummy/db/migrate/20120219133758_create_post_fulltext_index.rb
mysql_simple_fulltext-0.0.1	test/dummy/db/migrate/20120219133758_create_post_fulltext_index.rb