kmx.io/kmxgit/priv/repo/migrations/20211208130339_create_users_auth_tables.exs

Branch : - branch - master nif nif2 nif2_rebased nif3 nif4 nif4_rebased nif_rebased v0.1 v0.2 v0.3 v0.4 - tag - v0 v0.1.0 v0.1.1 v0.2.0 v0.3.0 v0.3.1 v0.3.2 v0.3.3 v0.4.0

• Show log

  Commit

• Author : Thomas de Grivel
  Date : 2021-12-08 16:24:53
  Hash : e800e02b
  Message : mix phx.gen.auth

• priv/repo/migrations/20211208130339_create_users_auth_tables.exs

• defmodule Kmxgit.Repo.Migrations.CreateUsersAuthTables do
    use Ecto.Migration
  
    def change do
      execute "CREATE EXTENSION IF NOT EXISTS citext", ""
  
      drop index(:users, ["(lower(email))"], unique: true)
  
      alter table(:users) do
        modify :email, :citext, null: false
        remove :encrypted_password
        add :hashed_password, :string, null: false, default: "*"
        add :confirmed_at, :utc_datetime
      end
  
      create unique_index(:users, [:email])
  
      create table(:users_tokens) do
        add :user_id, references(:users, on_delete: :delete_all), null: false
        add :token, :binary, null: false
        add :context, :string, null: false
        add :sent_to, :string
        timestamps(updated_at: false)
      end
  
      create index(:users_tokens, [:user_id])
      create unique_index(:users_tokens, [:context, :token])
    end
  end