td-934e92: P1: Add schema migration system to claude-remote-server

Description

Current db.exec(schema) with CREATE TABLE IF NOT EXISTS cannot add columns. Add a PRAGMA user_version based migration runner with numbered files in src/db/migrations/. Run on startup, idempotent. Prerequisite for any DB schema changes in v2.

Session Log (5 entries)

Mar 3, 2:01 PM

lg-803ab2f4 ses_389af1

progress

Started work

Mar 3, 2:03 PM

lg-6a8fa803 ses_1b63dc

progress

Part 3 complete. Removed repair hack, added 7 migration tests. Commit 4afe26d. 170 tests passing.

Mar 3, 2:03 PM

lg-32651516 ses_1b63dc

progress

Closed

Mar 3, 2:08 PM

lg-66143f8b ses_1b63dc

progress

Part 4 Phase 1: Fixed multi-turn SSE streaming bug. SSE stays alive between turns for interactive sessions. Commit d45283a.

Mar 3, 2:17 PM

lg-ea3939f5 ses_1b63dc

progress

All v2 Parts 1-4 pushed to origin/master. 8 commits, 2176 lines added. 174 tests. Senior engineer review caught and fixed 6 issues (3 HIGH, 3 MEDIUM).

Git State

Started 5c247ab (master) Current 5c247ab (master)

Sessions Involved

ses_389af1 (implementer)
ses_1b63dc