Idea detail
schema_migrations
reqlan rq/indexer/sqlite-schema.rq:109
block
Summary
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
Navigation
Attributes
Ancestor context
No ancestor chain recorded.
Outbound references
| Kind | Idea | Path | Snippet |
|---|---|---|---|
| file_reference | ../../packages/analytical/src/index-store/schema.ts | packages/analytical/src/index-store/schema.ts | schema.ts |
| file_reference | ../../crates/reqlan-index/src/schema.rs | crates/reqlan-index/src/schema.rs | schema.rs |
| references | sqlite_wal_sidecars | reqlan rq/indexer/sidecars.rq | sqlite_wal_sidecars |
| references | ideas_index_sqlite | reqlan rq/indexer/sqlite-schema.rq | ideas_index_sqlite |
| file_reference | ../../crates/reqlan-index/src/store.rs | crates/reqlan-index/src/store.rs | store.rs |
| file_reference | "../../crates/reqlan-index/tests/schema.rs" | crates/reqlan-index/tests/schema.rs | schema.rs |
| file_reference | "../../packages/analytical/test/schema-v4-roundtrip.test.ts" | packages/analytical/test/schema-v4-roundtrip.test.ts | schema-v4-roundtrip.test.ts |
Inbound references
| Kind | Idea | Path | Snippet |
|---|---|---|---|
| references | sqlite_wal_sidecars | reqlan rq/indexer/sidecars.rq | schema_migrations |
Unresolved references
| Kind | Idea | Path | Snippet |
|---|---|---|---|
| None | |||
Local graph
Initialising graph…