dryad

defmodule Dryad.Migrations.Postgres.V02 do
  use Ecto.Migration

  def up(_opts) do
    drop(constraint(:service_accounts, "service_accounts_organization_fkey"))
    rename(table(:service_accounts), :organization, to: :cask)

    alter table(:service_accounts) do
      modify(
        :cask,
        references(:casks, type: :uuid, on_delete: :delete_all),
        null: false
      )
    end
  end

  def down(_opts) do
    drop(constraint(:service_accounts, "service_accounts_cask_fkey"))
    rename(table(:service_accounts), :cask, to: :organization)

    alter table(:service_accounts) do
      modify(
        :organization,
        references(:organizations, type: :uuid, on_delete: :delete_all),
        null: false
      )
    end
  end
end