"""allow multiple business memberships per user

Revision ID: e4b82d6a91f0
Revises: c3d91e4b7f22
Create Date: 2026-09-20 14:10:00.000000
"""

from typing import Sequence, Union

from alembic import op


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


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


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