"""prevent multiple business memberships per user

Revision ID: c3d91e4b7f22
Revises: 6a20ac70d0f4
Create Date: 2026-09-20 13:45:00.000000
"""

from typing import Sequence, Union

from alembic import op


revision: str = "c3d91e4b7f22"
down_revision: Union[str, Sequence[str], None] = "6a20ac70d0f4"
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    op.create_unique_constraint(
        "uq_membership_user",
        "memberships",
        ["user_id"],
    )


def downgrade() -> None:
    op.drop_constraint(
        "uq_membership_user",
        "memberships",
        type_="unique",
    )