"""Add tickets.scheduled_for.

Mike's flow chart: "job is scheduled ... date and time stamped". A `scheduled`
status without a date says a job was planned but not when, which is the single
fact a planner most needs.

Revision ID: 0003
Revises: 0002
Create Date: 2026-07-30
"""

from __future__ import annotations

import sqlalchemy as sa
from alembic import op

revision = "0003"
down_revision = "0002"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.add_column(
        "tickets", sa.Column("scheduled_for", sa.DateTime(timezone=True), nullable=True)
    )


def downgrade() -> None:
    op.drop_column("tickets", "scheduled_for")