schema_migrations

Katz 0.058

Base tables use `CREATE … IF NOT EXISTS` ( schema.ts `BASE_MIGRATIONS` / schema.rs ).
Versioned upgrades run `(current+1)..=SCHEMA_VERSION`:
- v2 — edge `source_line`, `snippet`, `is_resolved`
- v3 — document `mtime_ms`
- v4 — idea `git_change_count`
Duplicate-column errors on ALTER are ignored so re-open is safe.
Fresh databases create full v4 columns, then set `schema_version` to 4.
Open pragmas: `foreign_keys=ON`, `journal_mode=WAL` ( sqlite_wal_sidecars ).
ideas_index_sqlite

implementation

schema.ts, schema.rs, store.rs

tests

schema.rs, schema-v4-roundtrip.test.ts

Interactive page: schema_migrations