Sha256: 622d2049e643385275fab0bc7684f12969f9abeb7c47728bfd3bcc643e20daf0

Contents?: true

Size: 596 Bytes

Versions: 41

Compression:

Stored size: 596 Bytes

Contents

class AddMissingUniqueIndicesToTagsAndTaggings < ActiveRecord::Migration

  def self.up
    add_index :tags, :name, unique: true

    remove_index :taggings, :tag_id
    remove_index :taggings, [:taggable_id, :taggable_type, :context]
    add_index :taggings,
      [:tag_id, :taggable_id, :taggable_type, :context, :tagger_id, :tagger_type],
      unique: true, name: 'taggings_idx'
  end

  def self.down
    remove_index :tags, :name

    remove_index :taggings, name: 'tagging_idx'
    add_index :taggings, :tag_id
    add_index :taggings, [:taggable_id, :taggable_type, :context]
  end

end

Version data entries

41 entries across 21 versions & 1 rubygems

Version Path
alchemy_cms-3.1.3 db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.1 db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.1 spec/dummy/db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.0.4 db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.0.4 spec/dummy/db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.0 spec/dummy/db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.0 db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.0.rc3 db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.0.rc3 spec/dummy/db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.0.rc2 spec/dummy/db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.0.rc2 db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.0.rc1 db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.0.rc1 spec/dummy/db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.0.beta6 spec/dummy/db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.0.beta6 db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.0.beta5 db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.0.beta5 spec/dummy/db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.0.beta4 spec/dummy/db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.1.0.beta4 db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb
alchemy_cms-3.0.3 db/migrate/20140107192720_add_missing_unique_indices_to_tags_and_taggings.rb