Sha256: 2ff6cb38823e1a106a44131e8f4a1da52d5f47be7df2cd6ca33e4188448dc898

Contents?: true

Size: 985 Bytes

Versions: 20

Compression:

Stored size: 985 Bytes

Contents

class AddFulltextBuilderFields < ActiveRecord::Migration
  def self.up
    rename_column 'versions', :title, :idx_text_high
    rename_column 'versions', :summary, :idx_text_medium
    rename_column 'versions', :text, :idx_text_low

    add_column 'roles', :idx_text_low, :text
    add_column 'roles', :idx_text_medium, :text
    add_column 'roles', :idx_text_high, :text

    #add_index 'versions', Zena::Use::Fulltext::FULLTEXT_FIELDS, :index_type => "FULLTEXT"
    #remove_index 'versions', %w{title text summary}
  end

  def self.down
    #remove_index 'versions', Zena::Use::Fulltext::FULLTEXT_FIELDS

    rename_column 'versions', :idx_text_high, :title
    rename_column 'versions', :idx_text_medium, :summary
    rename_column 'versions', :idx_text_low, :text

    remove_column 'roles', :idx_text_low
    remove_column 'roles', :idx_text_medium
    remove_column 'roles', :idx_text_high

    #add_index 'versions', %w{title text summary}, :index_type => "FULLTEXT"
  end
end

Version data entries

20 entries across 20 versions & 1 rubygems

Version Path
zena-1.2.8 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.2.7 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.2.6 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.2.5 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.2.4 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.2.3 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.2.2 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.2.1 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.2.0 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.1.3 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.1.2 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.1.1 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.1.0 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.0.0 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.0.0.rc3 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.0.0.rc2 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.0.0.rc1 db/fix/old_migrations/20100531135128_add_fulltext_builder_fields.rb
zena-1.0.0.beta3 db/migrate/20100531135128_add_fulltext_builder_fields.rb
zena-1.0.0.beta2 db/migrate/20100531135128_add_fulltext_builder_fields.rb
zena-1.0.0.beta1 db/migrate/20100531135128_add_fulltext_builder_fields.rb