Contents

class AddIndexToHost < ActiveRecord::Migration
  def self.up
    add_index "hosts", "last_report"
    add_index "hosts", "installed_at"
    add_index "hosts", "puppet_status"
    add_index "hosts", :domain_id, :name => 'host_domain_id_ix'
    add_index "hosts", :architecture_id, :name => 'host_arch_id_ix'
    add_index "hosts", :operatingsystem_id, :name => 'host_os_id_ix'
    add_index "hosts", :environment_id, :name => 'host_env_id_ix'
    add_index "hosts", :medium_id, :name => 'host_medium_id_ix'
    add_index "hosts", :hostgroup_id, :name => 'host_group_id_ix'
  end

  def self.down
    remove_index "hosts", "last_report"
    remove_index "hosts", "installed_at"
    remove_index "hosts", "puppet_status"
    remove_index "hosts", :name => 'host_domain_id_ix'
    remove_index "hosts", :name => 'host_arch_id_ix'
    remove_index "hosts", :name => 'host_os_id_ix'
    remove_index "hosts", :name => 'host_env_id_ix'
    remove_index "hosts", :name => 'host_medium_id_ix'
    remove_index "hosts", :name => 'host_group_id_ix'
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
foreman_discovery-1.0.0	test/foreman_app/db/migrate/20090920043521_add_index_to_host.rb
foreman_discovery-1.0.0.rc4	test/foreman_app/db/migrate/20090920043521_add_index_to_host.rb
foreman_discovery-1.0.0.rc3	test/foreman_app/db/migrate/20090920043521_add_index_to_host.rb
foreman_discovery-1.0.0.rc2	test/foreman_app/db/migrate/20090920043521_add_index_to_host.rb
foreman_discovery-1.0.0.rc1	test/foreman_app/db/migrate/20090920043521_add_index_to_host.rb