Contents

class CreateForemanPatchGroups < ActiveRecord::Migration[6.0]
  def change
    create_table :foreman_patch_groups do |t|
      t.string  :name, null: false
      t.text    :description
      t.integer :default_window_id
      t.integer :max_unavailable
      t.integer :default_priority

      t.timestamps
    end

    add_index :foreman_patch_groups, :name, unique: true, name: :foreman_patch_groups_name_uq

    add_foreign_key :foreman_patch_groups, :foreman_patch_window_plans, column: :default_window_id, name: :foreman_patch_groups_default_window_id_fk

    create_table :foreman_patch_window_groups do |t|
      t.integer :window_id, null: false
      t.integer :group_id, null: false
      t.integer :priority, null: false

      t.timestamps
    end

    add_foreign_key :foreman_patch_window_groups, :foreman_patch_groups, column: :group_id, name: :foreman_patch_window_groups_group_id_fk
    add_foreign_key :foreman_patch_window_groups, :foreman_patch_windows, column: :window_id, name: :foreman_patch_window_groups_window_id_fk

    create_table :foreman_patch_group_facets do |t|
      t.integer :host_id, null: false
      t.integer :group_id
      t.timestamp :last_patched_at
    end

    add_foreign_key :foreman_patch_group_facets, :hosts, column: :host_id, name: :foreman_patch_group_facets_host_id_fk
    add_foreign_key :foreman_patch_group_facets, :foreman_patch_groups, column: :group_id, name: :foreman_patch_group_facets_group_id_fk
  end
end

Version data entries

9 entries across 9 versions & 1 rubygems

Version	Path
foreman_patch-1.2.1	db/migrate/20210202164301_create_foreman_patch_groups.rb
foreman_patch-1.2.0	db/migrate/20210202164301_create_foreman_patch_groups.rb
foreman_patch-1.2.0.alpha1	db/migrate/20210202164301_create_foreman_patch_groups.rb
foreman_patch-1.1.6.alpha5	db/migrate/20210202164301_create_foreman_patch_groups.rb
foreman_patch-1.1.6.alpha4	db/migrate/20210202164301_create_foreman_patch_groups.rb
foreman_patch-1.1.5	db/migrate/20210202164301_create_foreman_patch_groups.rb
foreman_patch-1.1.4	db/migrate/20210202164301_create_foreman_patch_groups.rb
foreman_patch-1.1.3	db/migrate/20210202164301_create_foreman_patch_groups.rb
foreman_patch-1.1.1	db/migrate/20210202164301_create_foreman_patch_groups.rb