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

• Show log

  Commit

• Hash : e800e02b
  Author : Thomas de Grivel
  Date : 2021-12-08T16:24:53
  

  mix phx.gen.auth

Download

• 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
  

Download