"""Allow GitHub user app installations per workspace.

Revision ID: 061
Revises: 060
Create Date: 2026-05-02
"""
from alembic import op

revision = "061"
down_revision = "060"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.drop_constraint(
        "uq_workspace_user_gh_installation_id",
        "workspace_user_github_installations",
        type_="unique",
    )
    op.create_unique_constraint(
        "uq_workspace_user_gh_installation_workspace_installation",
        "workspace_user_github_installations",
        ["workspace_id", "github_installation_id"],
    )


def downgrade() -> None:
    op.drop_constraint(
        "uq_workspace_user_gh_installation_workspace_installation",
        "workspace_user_github_installations",
        type_="unique",
    )
    op.create_unique_constraint(
        "uq_workspace_user_gh_installation_id",
        "workspace_user_github_installations",
        ["github_installation_id"],
    )