Contents

class RemoveDuplicatedIndexOnAllTables < ActiveRecord::Migration
    def self.up
        ActiveRecord::Base.connection.tables.each do |t|
            if ActiveRecord::Base.connection.indexes(t).collect {|c| c.columns}.include?("id")
                remove_index t.to_s, :id
            end
        end 
    end

    def self.down
        ActiveRecord::Base.connection.tables.each do |t|
            unless ActiveRecord::Base.connection.indexes(t).collect {|c| c.columns}.include?("id")
                add_index t.to_s, :id, :integer => true
            end
        end    
    end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
puppet-0.24.9	lib/puppet/rails/database/002_remove_duplicated_index_on_all_tables.rb
puppet-0.24.6	lib/puppet/rails/database/002_remove_duplicated_index_on_all_tables.rb
puppet-0.24.7	lib/puppet/rails/database/002_remove_duplicated_index_on_all_tables.rb
puppet-0.24.8	lib/puppet/rails/database/002_remove_duplicated_index_on_all_tables.rb