1PRAGMA journal_mode=WAL; 2 3ALTER TABLE task_comment 4 ADD closing BOOLEAN NOT NULL DEFAULT 0; 5 6UPDATE task_comment SET closing=1 WHERE id IN (SELECT MAX(id) FROM task_comment GROUP BY task_id);
1PRAGMA journal_mode=WAL; 2 3ALTER TABLE task_comment 4 ADD closing BOOLEAN NOT NULL DEFAULT 0; 5 6UPDATE task_comment SET closing=1 WHERE id IN (SELECT MAX(id) FROM task_comment GROUP BY task_id);