Contents

class PruneIndexes < ActiveRecord::Migration
	def self.up

		if indexes(:hosts).map{|x| x.columns }.flatten.include?("comments")
			remove_index :hosts, :comments
		end

		if indexes(:services).map{|x| x.columns }.flatten.include?("info")
			remove_index :services, :info
		end

		if indexes(:vulns).map{|x| x.columns }.flatten.include?("info")
			remove_index :vulns, :info
		end
	end

	def self.down
		add_index :hosts, :comments
		add_index :services, :info
		add_index :vulns, :info
	end
end

Version data entries

154 entries across 154 versions & 1 rubygems

Version	Path
metasploit_data_models-3.0.10	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-3.0.9	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-3.0.8	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-3.0.7	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-3.0.6	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-3.0.5	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-2.0.17	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-3.0.4	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-3.0.2	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-3.0.1	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-3.0.0	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-2.0.16	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-2.0.15	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-2.0.14	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-2.0.13	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-2.0.12	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-2.0.11	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-2.0.10	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-2.0.9	db/migrate/20110812000001_prune_indexes.rb
metasploit_data_models-2.0.8	db/migrate/20110812000001_prune_indexes.rb