"""Add sections.google_maps_url column.

Nullable, staff-entered Google Maps share link per section — used as the
content_url for the section's QR code marker (Settings → QR Codes) instead
of relying on drawn boundary geometry. NULL on all existing rows means "not
configured yet"; QR generation for a section without one raises a clear
error asking the admin to set it first.

Revision ID: 0071
Revises: 0070
"""
import sqlalchemy as sa
from alembic import op

revision = "0071"
down_revision = "0070"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.add_column(
        "sections",
        sa.Column("google_maps_url", sa.String(length=500), nullable=True),
    )


def downgrade() -> None:
    op.drop_column("sections", "google_maps_url")