5 lines
411 B
SQL
5 lines
411 B
SQL
ALTER TABLE reviews ADD COLUMN finding_responses TEXT NOT NULL DEFAULT '{}';
|
|
UPDATE events SET payload = json_set(payload, '$.finding_responses', json('{}'))
|
|
WHERE kind IN ('review.started', 'review.finished', 'review.finding') AND json_type(payload, '$.finding_responses') IS NULL;
|
|
UPDATE users SET focus = json_set(focus, '$.tab', 'transcript') WHERE json_extract(focus, '$.tab') IN ('questions', 'reviews');
|