18F/identity-idp

class CreateMonthlyAuthCounts < ActiveRecord::Migration[5.1]
  disable_ddl_transaction!

  def change
    create_table :monthly_auth_counts do |t|
      t.string :issuer, null: false
      t.string :year_month, null: false
      t.integer :user_id, null: false
      t.integer :auth_count, default: 1, null: false
    end
    add_index :monthly_auth_counts, %i[issuer year_month user_id], algorithm: :concurrently, unique: true
  end
end