update0006.sql (revision 8f69a4e63b9668d2f3a43571baca9b354c205ae8) - OpenGrok cross reference for /plugin/bez/db/update0006.sql

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