BE-M0-13 · Tenancy and access, settings, pool dates and document numbers

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

Goal

Tenancy and access (organizations to overrides, profiles with locale, my_permissions(), set_my_locale()), settings, pool dates and document numbers pass their tests on the local stack; committed.

Before

• BE-M0-12 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-13/. .
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): tenancy, access, settings and document numbers"

Expect

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

Check

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

Expect 20261006000200 in both columns as the last row, then “feat(supabase): tenancy, access, settings and document numbers”.

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.