defmodule AccessPass.Repo.Migrations.AddUsers do
  use Ecto.Migration

  def change do
    create table(:users, primary_key: false) do
      add(:user_id, :string, primary_key: true)
      add(:username, :string, size: 20)
      add(:meta, :map)
      add(:email, :string)
      add(:password_hash, :string)
      add(:successful_login_attempts, :integer)
      add(:confirm_id, :string)
      add(:password_reset_key, :string)
      add(:password_reset_expire, :integer)
      add(:confirmed, :boolean)
      timestamps
    end

    create(unique_index(:users, [:email]))
    create(unique_index(:users, [:user_id]))
    create(unique_index(:users, [:username]))
  end
end