# Scratchpad — fix-ci-migrations-20260330

## Objective

- Fix Drizzle migration journal ordering so fresh Postgres instances apply all schema migrations in CI.

## Plan

- Inspect migration SQL, journal, and snapshot chain.
- Patch metadata consistently.
- Run full test suite.
- Record result and risks.

## Progress

- Inspected migration files and confirmed 0001_cynical_ultimatum.sql is missing from journal while 0002 depends on it.
- Patched `packages/db/drizzle/meta/_journal.json` to insert `0001_cynical_ultimatum` at idx 1 and shift later entries to idx 2-7.
- Verified snapshot content is already semantically aligned with the fixed ordering: the missing tables exist in `0001_snapshot.json`, and `mutable` appears in later snapshots.
- Installed workspace dependencies in this worktree to make the requested test command runnable.
- Ran `pnpm test` successfully; gateway reported `347 passed (347)` and Turbo finished with `35 successful, 35 total`.