"""Brand-to-collection assignments for V2 admin.

Revision ID: 0070_add_v2_brand_collection
Revises: 0069_add_v2_import_mapper_tables
Create Date: 2026-08-21 18:40:00.000000
"""

from __future__ import annotations

import sqlalchemy as sa
from alembic import op

revision = "0070_add_v2_brand_collection"
down_revision = "0069_add_v2_import_mapper_tables"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.create_table(
        "v2_brand_collection",
        sa.Column("brand_id", sa.Integer(), sa.ForeignKey("master_brand.id", ondelete="CASCADE"), primary_key=True),
        sa.Column("collection_id", sa.BigInteger(), sa.ForeignKey("v2_category.id", ondelete="CASCADE"), primary_key=True),
        sa.UniqueConstraint("collection_id", name="uq_v2_brand_collection_collection"),
    )


def downgrade() -> None:
    op.drop_table("v2_brand_collection")