"""add address to complaints

Revision ID: 5f6a7b8c9d0e
Revises: 1a2b3c4d5e6f
Create Date: 2026-08-09

Complaint tickets gain an optional free-text address/location, captured from the
caller so the field staff know where the problem is.
"""
from typing import Sequence, Union

import sqlalchemy as sa
from alembic import op


revision: str = '5f6a7b8c9d0e'
down_revision: Union[str, None] = '1a2b3c4d5e6f'
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('address', sa.Text(), nullable=True))


def downgrade() -> None:
    op.drop_column('complaints', 'address')