Contents

class AddIndexToTaggings < ActiveRecord::Migration[5.2]
  def change
    add_index MakeTaggable.taggings_table, :taggable_id
    add_index MakeTaggable.taggings_table, :tagger_id
    add_index MakeTaggable.taggings_table, :taggable_type
    add_index MakeTaggable.taggings_table, :context
    add_index MakeTaggable.taggings_table, [:tagger_id, :tagger_type]
    add_index MakeTaggable.taggings_table, [:tag_id, :taggable_id, :taggable_type, :context, :tagger_id, :tagger_type], unique: true, name: "taggings_idx"
    add_index MakeTaggable.taggings_table, [:taggable_id, :taggable_type, :context], name: "taggings_taggable_context_idx"
    add_index MakeTaggable.taggings_table, [:taggable_id, :taggable_type, :tagger_id, :context], name: "taggings_idy"
  end
end

Version data entries

10 entries across 10 versions & 1 rubygems

Version	Path
make_taggable-0.7.5	db/migrate/5_add_index_to_taggings.rb
make_taggable-0.7.4	db/migrate/5_add_index_to_taggings.rb
make_taggable-0.7.3	db/migrate/5_add_index_to_taggings.rb
make_taggable-0.7.2	db/migrate/5_add_index_to_taggings.rb
make_taggable-0.7.1	db/migrate/5_add_index_to_taggings.rb
make_taggable-0.7.0	db/migrate/5_add_index_to_taggings.rb
make_taggable-0.6.6	db/migrate/5_add_index_to_taggings.rb
make_taggable-0.6.5	db/migrate/5_add_index_to_taggings.rb
make_taggable-0.6.4	db/migrate/5_add_index_to_taggings.rb
make_taggable-0.6.3	db/migrate/4_add_index_to_taggings.rb