# Pending schema changes — images pipeline (agent R, 2026-09-07)

Applied locally with `drizzle-kit push`; the parent generates the migration.

Table `images` — new columns and indexes:

| column | type | note |
|---|---|---|
| `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) |
| `checked_at` | timestamptz | last validation |
| `bytes` | integer | original size |
| `content_type` | text | original MIME |
| `cache_key` | text | `sha1(url)`; key of `RI_DATA_DIR/images/{orig,w96,w192,w384,w768,w1200}/<k[0:2]>/<k>.*` |
| `error` | text | last failure reason (≤200 chars) |

Indexes: `images_cache_key_idx (cache_key)`, `images_status_idx (status, checked_at)`.

No other tables touched. `workers/lib/queue.ts` gained the job name `images.process`.