# md-db-baseline evidence

Committed machine outputs for the md-db-baseline plan. Connection strings are redacted to protocol/user@host/path.

## Task 4 — gated live mark-applied (2026-07-19T18:49:25Z)

### Target-identity gate

| URL | endpoint | project | branch |
| --- | --- | --- | --- |
| DATABASE_URL | ep-misty-cloud-ajlx6fex (ep-misty-cloud-ajlx6fex.c-3.us-east-2.aws.neon.tech) | multideal-v2 (rough-brook-49654702) | br-damp-glitter-ajgjb39f |
| MIGRATE_DATABASE_URL | ep-misty-cloud-ajlx6fex (ep-misty-cloud-ajlx6fex.c-3.us-east-2.aws.neon.tech) | multideal-v2 (rough-brook-49654702) | br-damp-glitter-ajgjb39f |

Redacted URLs: `postgresql://multideal_app@ep-misty-cloud-ajlx6fex-pooler.c-3.us-east-2.aws.neon.tech/neondb`, `postgresql://neondb_owner@ep-misty-cloud-ajlx6fex.c-3.us-east-2.aws.neon.tech/neondb`

### Harvested baseline row (scratch pgvector:0.8.0-pg17)

- hash: `df56700f22740e667d7d7af97b2dbfdc1909e1c577af86d43b2506f57c909cbe`
- created_at: `1784467965162`
- sha256(0000_baseline.sql): `df56700f22740e667d7d7af97b2dbfdc1909e1c577af86d43b2506f57c909cbe`

### Restore branch

- name: `pre-rebaseline-2026-07-12`
- id: `br-noisy-water-aj3zqzag`
- parent branch: `br-damp-glitter-ajgjb39f`
- project: `rough-brook-49654702`

### Pre-state rows (captured before stamp)

```json
[{"id":118,"hash":"df56700f22740e667d7d7af97b2dbfdc1909e1c577af86d43b2506f57c909cbe","created_at":1784467965162}]
```

### Transaction

- result: skipped (live already carries harvested baseline row)

## Task 5 — final verification sweep (2026-07-20T05:06:23Z)

Machine-gated acceptances re-run on integrated tree at `071cf481f`. Connection strings redacted.

### verifycmd

```text
pnpm --filter web typecheck                               → exit 0
bash apps/web/scripts/db-test-ci-parity.sh                → exit 0 (548 files passed, 3334 tests; db-cli-gate suite included)
bash apps/web/scripts/db-baseline-oracle.sh full-live     → exit 0 (b0/a/b/c passed)
bash apps/web/scripts/db-migrate-noop-check.sh            → exit 0 (all gates passed; count=1, hash=df56700f22740e667d7d7af97b2dbfdc1909e1c577af86d43b2506f57c909cbe)
bash apps/web/scripts/db-baseline-oracle.sh local-scratch → exit 0 (b0/b/c passed)
```

### A–D verdict checklist

| Acceptance | Gate | Verdict | Evidence |
| --- | --- | --- | --- |
| A | `db-baseline-oracle.sh full-live` — scratch migrate + normalized pg_dump scratch≡live + `pg_extension` versions + gates b0/b/c | **PASS** | exit 0; oracle reports `b0/a/b/c passed` |
| B | `db-migrate-noop-check.sh` — state-based no-op (count unchanged, single harvested row) | **PASS** | exit 0; `all gates passed` |
| C | `db:push` refusal — `tests/unit/db-cli-gate.test.ts` in CI-parity test run | **PASS** | `db-test-ci-parity.sh` exit 0 (db-cli-gate cases green) |
| D | `db-baseline-oracle.sh local-scratch` — CI-equivalent gates b0/b/c on podman scratch | **PASS** | exit 0; oracle reports `b0/b/c passed` |

### Scratch cleanup

- Oracle scratch DBs: 10 lingering `pgvector:0.8.0-pg17` podman containers removed (`podman rm -f`); current-run containers torn down by script traps.
- Neon scratch branches: none created during this sweep; `pre-rebaseline-2026-07-12` (`br-noisy-water-aj3zqzag`) **retained** per contract.