crowdAI/crowdai

class CreateLoginActivities < ActiveRecord::Migration[5.1]
  def change
    create_table :login_activities do |t|
      t.text :scope
      t.text :strategy
      t.text :identity
      t.boolean :success
      t.text :failure_reason
      t.references :user, polymorphic: true
      t.text :context
      t.text :ip
      t.text :user_agent
      t.text :referrer
      t.text :city
      t.text :region
      t.text :country
      t.datetime :created_at
    end

    add_index :login_activities, :identity
    add_index :login_activities, :ip
    add_index :login_activities, :user_id
  end
end