ALTER TABLE tasks ADD COLUMN ready_prompt_seq INTEGER NOT NULL DEFAULT 0;

UPDATE tasks SET ready_prompt_seq = COALESCE((
	SELECT MAX(e.seq) FROM events e
	WHERE e.task_id = tasks.id AND e.kind = 'user.message' AND e.actor = 'byre'
		AND json_extract(e.payload, '$.text') LIKE 'Your turn has ended and the review of your latest work has finished.%'
), 0);

ALTER TABLE tasks DROP COLUMN ready_prompt_n;