Change email field type to citext
defmodule Mango.Repo.Migrations.CreateCustomers do | |
use Ecto.Migration | |
def change do | |
execute "CREATE EXTENSION IF NOT EXISTS citext" | |
create table(:customers) do | |
add :name, :string | |
add :email, :citext | |
add :phone, :string | |
add :residence_area, :string | |
add :password_hash, :string | |
timestamps() | |
end | |
create unique_index(:customers, [:email]) | |
end | |
end |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment