Current section

Files

Jump to
blossom lib blossom migrations postgres v18.ex
Raw

lib/blossom/migrations/postgres/v18.ex

defmodule Blossom.Migrations.Postgres.V18 do
use Ecto.Migration
def up(_opts) do
drop(constraint(:organizations_roles, "organizations_roles_cask_fkey"))
drop(constraint(:organizations_roles, "organizations_roles_user_fkey"))
rename(table(:organizations_roles), to: table(:casks_roles))
rename(
index(:casks_roles, [:cask, :user, :role],
name: "organizations_roles_organization_user_role_index"
),
to: "casks_roles_cask_user_role_index"
)
rename(index(:casks_roles, [:id], name: "organizations_roles_pkey"),
to: "casks_roles_pkey"
)
alter table(:casks_roles) do
modify(
:cask,
references(:casks, type: :uuid, on_delete: :delete_all),
null: false
)
modify(
:user,
references(:users, type: :uuid, on_delete: :delete_all),
null: false
)
end
end
def down(_opts) do
drop(constraint(:casks_roles, "casks_roles_cask_fkey"))
drop(constraint(:casks_roles, "casks_roles_user_fkey"))
rename(table(:casks_roles), to: table(:organizations_roles))
rename(
index(:organizations_roles, [:cask, :user, :role],
name: "casks_roles_cask_user_role_index"
),
to: "organizations_roles_organization_user_role_index"
)
rename(index(:organizations_roles, [:id], name: "casks_roles_pkey"),
to: "organizations_roles_pkey"
)
alter table(:organizations_roles) do
modify(
:cask,
references(:casks, type: :uuid, on_delete: :delete_all),
null: false
)
modify(
:user,
references(:users, type: :uuid, on_delete: :delete_all),
null: false
)
end
end
end