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