1# Pending schema changes — images pipeline (agent R, 2026-09-07)23Applied locally with `drizzle-kit push`; the parent generates the migration.45Table `images` — new columns and indexes:67| column | type | note |8|---|---|---|9| `status` | text not null default `'unchecked'` | `unchecked` · `ok` · `dead` (404/410/not an image) · `blocked` (400/401/403/429) · `error` (network/timeout, retried after 6 h) |10| `checked_at` | timestamptz | last validation |11| `bytes` | integer | original size |12| `content_type` | text | original MIME |13| `cache_key` | text | `sha1(url)`; key of `RI_DATA_DIR/images/{orig,w96,w192,w384,w768,w1200}/<k[0:2]>/<k>.*` |14| `error` | text | last failure reason (≤200 chars) |1516Indexes: `images_cache_key_idx (cache_key)`, `images_status_idx (status, checked_at)`.1718No other tables touched. `workers/lib/queue.ts` gained the job name `images.process`.19