Current section

Files

Jump to
blossom lib blossom migrations postgres v12.ex
Raw

lib/blossom/migrations/postgres/v12.ex

defmodule Blossom.Migrations.Postgres.V12 do
use Ecto.Migration
def up(_opts) do
alter table(:users) do
add(
:realm,
references(:realms, type: :uuid, on_delete: :delete_all),
null: true
)
add(:role, :text, null: true)
end
drop(index(:users, [:email]))
drop(index(:users, [:username]))
create(unique_index(:users, [:realm, :email]))
create(unique_index(:users, [:realm, :username]))
end
def down(_opts) do
drop(index(:users, [:realm, :email]))
drop(index(:users, [:realm, :username]))
create(unique_index(:users, [:email]))
create(unique_index(:users, [:username]))
alter table(:users) do
remove(:role, :text, null: true)
remove(:realm, references(:realms, type: :uuid, on_delete: :delete_all),
null: true
)
end
end
end