Current section

Files

Jump to
blossom lib blossom migrations postgres v23.ex
Raw

lib/blossom/migrations/postgres/v23.ex

defmodule Blossom.Migrations.Postgres.V23 do
use Ecto.Migration
def up(_opts) do
drop(constraint(:casks_roles, "casks_roles_cask_fkey"))
alter table(:casks_roles) do
add(
:realm,
references(:realms, type: :uuid, on_delete: :delete_all),
null: false
)
modify(
:cask,
references(:casks, type: :uuid, on_delete: :delete_all),
null: true
)
end
create(unique_index(:casks_roles, [:cask, :user, :role_definition, :scope]))
drop(unique_index(:casks_roles, [:cask, :user, :role_definition]))
end
def down(_opts) do
drop(constraint(:casks_roles, "casks_roles_cask_fkey"))
alter table(:casks_roles) do
remove(:realm)
modify(
:cask,
references(:casks, type: :uuid, on_delete: :delete_all),
null: false
)
end
drop(unique_index(:casks_roles, [:cask, :user, :role_definition, :scope]))
create(unique_index(:casks_roles, [:cask, :user, :role_definition]))
end
end