Files
byre/internal/store/migrations/041-add-review-finding-states.sql
2026-10-18 21:24:41 -07:00

4 lines
256 B
SQL

ALTER TABLE reviews ADD COLUMN finding_states TEXT NOT NULL DEFAULT '{}';
UPDATE events SET payload = json_set(payload, '$.finding_states', json('{}'))
WHERE kind IN ('review.started', 'review.finished') AND json_type(payload, '$.finding_states') IS NULL;