"""add customer_ref to complaints (free-text customer ID)

Revision ID: dcu5t0m3rr3fc0d3
Revises: c5y5t3md3v414d9
Create Date: 2026-09-19

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa

revision: str = 'dcu5t0m3rr3fc0d3'
down_revision: Union[str, None] = 'c5y5t3md3v414d9'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    op.add_column('complaints', sa.Column('customer_ref', sa.String(length=80), nullable=True))
    op.create_index(op.f('ix_complaints_customer_ref'), 'complaints', ['customer_ref'], unique=False)


def downgrade() -> None:
    op.drop_index(op.f('ix_complaints_customer_ref'), table_name='complaints')
    op.drop_column('complaints', 'customer_ref')