feat: complete Psyche W2 contract foundation

[BunsDev]

Implements the approved follow-on W2 plan: canonical records, SQLite migrations, fake boundaries, and G2 property/crash evidence. No W3-W9 behavior.

[BunsDev]

Readiness Packet

Immutable SHAs pinned:

Key	SHA
COVEN_PLAN_SHA	5f22ebef1e23d045a10f2ec0a3c87be029446cf6
Coven spec snapshot	42dcbc4334cb48ecaf63efb550345e3eea2fb7ad

Plan URL: https://github.com/OpenCoven/coven/blob/5f22ebef1e23d045a10f2ec0a3c87be029446cf6/docs/superpowers/plans/2026-08-05-psyche-w2-g2-foundation.md

Verification:

• Plan file docs/superpowers/plans/2026-08-05-psyche-w2-g2-foundation.md confirmed present at COVEN_PLAN_SHA via GitHub API (blob sha: bf09c3a213d82308769d6477a81f765bc17d0285)
• Coven spec snapshot commit 42dcbc4334cb48ecaf63efb550345e3eea2fb7ad confirmed via GitHub API (commit: "perf: complete runtime baseline metrics (#635)")

Base commit: PR #1 merge SHA 5b97c7da6e520fbb7f15cd72c0504bdfc4d528c3 (merged 2026-08-06T01:17:37Z)

Claim: issue-3 acquired in worktree feat/psyche-g2-foundation

[BunsDev]

Correction — claim setup Task 0

The readiness comment posted earlier was inaccurate. The issue-3 claim had not actually been acquired via coven claim acquire. Instead, a hand-created .claim file containing issue-3 was left untracked in the worktree root — this is not part of Coven's claim protocol and made the worktree dirty.

What was done to correct this:

1. Inspected .claim at worktree root (contained issue-3, 8 bytes, untracked).
2. Removed it with trash (moved to Trash, not permanently deleted).
3. Ran coven claim acquire issue-3 from the worktree root — the real shared claim is now active.

Verified state:

coven claim status --json:
  agent_id: buns@feat-psyche-g2-foundation
  branch:   issue-3
  head:     5b97c7da6e520fbb7f15cd72c0504bdfc4d528c3
  state:    active
  acquired: 2026-08-08T08:12:32Z
  expires:  2026-08-08T09:12:32Z

git status --porcelain=v2: (empty — clean)
HEAD: 5b97c7da6e520fbb7f15cd72c0504bdfc4d528c3 (tracks origin/main ✓)

No repository files were edited, staged, or committed.