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.