class CreateEffectiveLogging < ActiveRecord::Migration[4.2]
  def self.up
    create_table <%= @logs_table_name %> do |t|
      t.integer       :parent_id

      t.string        :user_type
      t.integer       :user_id

      t.string        :changes_to_type
      t.integer       :changes_to_id

      t.string        :associated_type
      t.integer       :associated_id
      t.string        :associated_to_s

      t.integer       :logs_count

      t.text          :message
      t.text          :details

      t.string        :status

      t.timestamps
    end

    add_index <%= @logs_table_name %>, :user_id
    add_index <%= @logs_table_name %>, :parent_id
    add_index <%= @logs_table_name %>, [:associated_type, :associated_id]
    add_index <%= @logs_table_name %>, :associated_id
    add_index <%= @logs_table_name %>, :associated_to_s
  end

  def self.down
    drop_table <%= @logs_table_name %>
  end
end