"""company logo

Revision ID: b4e51a03cd8f
Revises: b5f98ce6698e
Create Date: 2026-01-21 10:45:40.356602

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision: str = 'b4e51a03cd8f'
down_revision: Union[str, None] = 'b5f98ce6698e'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint('categories_category_id_key', 'categories', type_='unique')
    op.create_index(op.f('ix_categories_category_id'), 'categories', ['category_id'], unique=False)
    op.create_unique_constraint('uq_categories_company_category', 'categories', ['company_id', 'category_id'])
    op.add_column('companies', sa.Column('company_logo', sa.String(length=500), nullable=True))
    op.drop_index('ix_discounts_discount_id', table_name='discounts')
    op.create_index(op.f('ix_discounts_discount_id'), 'discounts', ['discount_id'], unique=False)
    op.create_unique_constraint('uq_discounts_company_discount', 'discounts', ['company_id', 'discount_id'])
    op.drop_index('ix_inventory_batches_batch_ref', table_name='inventory_batches')
    op.create_index(op.f('ix_inventory_batches_batch_ref'), 'inventory_batches', ['batch_ref'], unique=False)
    op.create_unique_constraint('uq_inventory_batches_company_batch_ref', 'inventory_batches', ['company_id', 'batch_ref'])
    op.drop_index('ix_product_varients_varient_id', table_name='product_varients')
    op.create_index(op.f('ix_product_varients_varient_id'), 'product_varients', ['varient_id'], unique=False)
    op.create_unique_constraint('uq_product_varients_company_varient', 'product_varients', ['company_id', 'varient_id'])
    # ### end Alembic commands ###


def downgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint('uq_product_varients_company_varient', 'product_varients', type_='unique')
    op.drop_index(op.f('ix_product_varients_varient_id'), table_name='product_varients')
    op.create_index('ix_product_varients_varient_id', 'product_varients', ['varient_id'], unique=True)
    op.drop_constraint('uq_inventory_batches_company_batch_ref', 'inventory_batches', type_='unique')
    op.drop_index(op.f('ix_inventory_batches_batch_ref'), table_name='inventory_batches')
    op.create_index('ix_inventory_batches_batch_ref', 'inventory_batches', ['batch_ref'], unique=True)
    op.drop_constraint('uq_discounts_company_discount', 'discounts', type_='unique')
    op.drop_index(op.f('ix_discounts_discount_id'), table_name='discounts')
    op.create_index('ix_discounts_discount_id', 'discounts', ['discount_id'], unique=True)
    op.drop_column('companies', 'company_logo')
    op.drop_constraint('uq_categories_company_category', 'categories', type_='unique')
    op.drop_index(op.f('ix_categories_category_id'), table_name='categories')
    op.create_unique_constraint('categories_category_id_key', 'categories', ['category_id'])
    # ### end Alembic commands ###