Contents

class CreateConfigs < ActiveRecord::Migration[4.2]
  def change
    create_table :foreman_virt_who_configure_configs do |t|
      t.integer :interval, :default => 60, :null => true
      # this is not a foreign key but one of 'hostname', 'uuid', 'hwuuid'
      t.string :hypervisor_id, :null => true
      t.integer :listing_mode, :null => true
      t.text :whitelist, :null => true
      t.text :blacklist, :null => true

      t.references :compute_resource, :index => { :name => 'fvwc_c_compute_resource_id' }, :null => true
      t.references :organization, :index => { :name => 'fvwc_c_oragnization_id' }, :null => true
      t.references :service_user, :index => { :name => 'fvwc_su_service_user' }, :null => true

      t.timestamps :null => false
    end

    add_foreign_key :foreman_virt_who_configure_configs, :compute_resources, :column => :compute_resource_id
    add_foreign_key :foreman_virt_who_configure_configs, :taxonomies, :column => :organization_id
    add_foreign_key :foreman_virt_who_configure_configs, :foreman_virt_who_configure_service_users, :column => :service_user_id
  end
end

Version data entries

38 entries across 38 versions & 1 rubygems

Version	Path
foreman_virt_who_configure-0.5.25	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.24	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.23	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.21	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.20	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.19	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.18	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.17	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.16	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.15	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.14	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.13	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.12	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.11	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.10	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.9	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.8	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.7	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.6	db/migrate/20170102152650_create_configs.rb
foreman_virt_who_configure-0.5.5	db/migrate/20170102152650_create_configs.rb