10 lines
403 B
SQL
10 lines
403 B
SQL
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;
|