update0006.sql (revision 17e5ba2e368ec05e910550acf2c6f8a4e66b7bb2) - 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);