BE-M0-16 · Drivers, the walk-in queue and screening

ID BE-M0-16 · Level L0 · Pack Pack B · Schema V13, domain by domain · Run order row 19 · Issue #11

Goal

The driver, queue and screening tables, with drivers.stage changed only through app.set_driver_stage(), pass their tests on the local stack; committed.

Before

• BE-M0-15 is Done. You are on the branch supabase/schema-v13 in ~/opleet-v2/opleet, git status --short prints nothing, and the stack is running.

Run

1 · Copy this step's files in

cp -R ~/opleet-v2/packs/be-pack-b/BE-M0-16/. .
git status --short

2 · Rebuild the local database from every migration, then run every test

pnpm supabase db reset
pnpm supabase test db

3 · Commit

git add supabase
git commit -m "feat(supabase): drivers, queue and screening"

Expect

• Block 1: ?? supabase/migrations/20261006000500_drivers.sql and ?? supabase/tests/database/16_drivers.test.sql.
• Block 2: db reset applies 20261006000500_drivers.sql last and ends with “Finished supabase db reset”; test db ends with “All tests successful.”, “Files=5, Tests=93” and “Result: PASS”.
• Block 3: the commit line with 2 files changed.

Check

pnpm supabase migration list --local
git log --oneline -1

Expect 20261006000500 in both columns as the last row, then “feat(supabase): drivers, queue and screening”.

If it fails

• db reset stops at a migration: the error names the file and the line. Paste it into the BE chat; don't edit the file.
• test db prints “not ok”: paste every “not ok” line and the lines under it. Don't commit.
• The stack isn't running: pnpm supabase start, then the rebuild and tests again.

Undo

Not committed yet: git clean -fd supabase/migrations supabase/tests, then pnpm supabase db reset. Committed: git reset --hard HEAD~1, then pnpm supabase db reset. Nothing has been pushed; the earlier steps stay.

Runs

Not run yet. Log each run as a comment on #11.