"""bootstrap the complete application schema for an empty database

Revision ID: 20260731_14
Revises: 20260731_13
Create Date: 2026-07-31
"""
from __future__ import annotations

from collections.abc import Sequence

from alembic import op

from supply_infra.db.base import Base
import supply_infra.db.models  # noqa: F401

revision: str = "20260731_14"
down_revision: str | None = "20260731_13"
branch_labels: str | Sequence[str] | None = None
depends_on: str | Sequence[str] | None = None


def upgrade() -> None:
    """Create model-owned tables that historical deployments supplied manually."""

    Base.metadata.create_all(bind=op.get_bind(), checkfirst=True)


def downgrade() -> None:
    # This is an adoption migration. Some tables may predate Alembic, so a
    # downgrade must not guess ownership and delete existing application data.
    pass