defmodule Blossom.Migrations.Postgres.V13 do
  use Ecto.Migration

  def up(_opts) do
    alter table(:organizations) do
      add(
        :realm,
        references(:realms, type: :uuid, on_delete: :delete_all),
        null: true
      )
    end

    drop(index(:organizations, [:slug]))
    create(unique_index(:organizations, [:realm, :slug]))
  end

  def down(_opts) do
    drop(index(:organizations, [:realm, :slug]))
    create(unique_index(:organizations, [:slug]))

    alter table(:organizations) do
      remove(:realm, references(:realms, type: :uuid, on_delete: :delete_all),
        null: true
      )
    end
  end
end