stevenbeales / mental-test

class InstallAudited < ActiveRecord::Migration[5.1]

  def change

    create_table :audits, force: true do |t|

      t.column :auditable_id, :integer

      t.column :auditable_type, :string

      t.column :associated_id, :integer

      t.column :associated_type, :string

      t.column :user_id, :integer

      t.column :user_type, :string

      t.column :username, :string

      t.column :action, :string

      t.column :audited_changes, :jsonb

      t.column :version, :integer, default: 0

      t.column :comment, :string

      t.column :remote_address, :string

      t.column :request_uuid, :string

      t.column :created_at, :datetime

    end

    add_indexes

  end

  def add_indexes

    add_index :audits, %i[auditable_type auditable_id], name: 'auditable_index'

    add_index :audits, %i[associated_type associated_id], name: 'associated_index'

    add_index :audits, %i[user_id user_type], name: 'user_index'

    add_index :audits, :request_uuid

    add_index :audits, :created_at

  end

end