"""users.access_level + users.city — BW Auth (Pattern B) app-owned fields.

- access_level: app-defined role reported to the BW hub (display-only there).
- city: app-only profile field, never sent to BW.

Both are v2-native (the users table itself is v2-only, D1), so no diff-harness
allowlist change is needed — the whole table is v2-only.

Revision ID: b3f8a1c05d2e
Revises: a7c2f19e4b02
Create Date: 2026-07-07
"""
from __future__ import annotations

import sqlalchemy as sa
from alembic import op

revision = "b3f8a1c05d2e"
down_revision = "a7c2f19e4b02"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.add_column(
        "users",
        sa.Column("access_level", sa.Text(), nullable=False, server_default=sa.text("''")),
    )
    op.add_column(
        "users",
        sa.Column("city", sa.Text(), nullable=False, server_default=sa.text("''")),
    )


def downgrade() -> None:
    op.drop_column("users", "city")
    op.drop_column("users", "access_level")