8cd02b9a0c402e9537137ae96ef1c07291d19228
[quassel.git] / setup_062_add_trigger_backlog_lastmsgid_update_direct_update.sql
1 CREATE TRIGGER IF NOT EXISTS backlog_lastmsgid_update_trigger_update
2 AFTER UPDATE
3 ON backlog
4 FOR EACH ROW
5     BEGIN
6         UPDATE buffer
7         SET lastmsgid = new.messageid
8         WHERE buffer.bufferid = new.bufferid
9             AND buffer.lastmsgid < new.messageid;
10     END