Port the previous PostgreSQL improvements to SQLite3.

[quassel.git] / src / core / SQL / SQLite / 21 / upgrade_001_update_buffer_set_lastmsgid.sql

diff --git a/src/core/SQL/SQLite/21/upgrade_001_update_buffer_set_lastmsgid.sql b/src/core/SQL/SQLite/21/upgrade_001_update_buffer_set_lastmsgid.sql
new file mode 100644 (file)
index 0000000..221e814
--- /dev/null
+++ b/src/core/SQL/SQLite/21/upgrade_001_update_buffer_set_lastmsgid.sql
@@ -0,0 +1,8 @@
+UPDATE buffer
+SET lastmsgid = (
+       SELECT messageid 
+       FROM backlog 
+       WHERE backlog.bufferid = buffer.bufferid
+       ORDER BY messageid 
+       DESC LIMIT 1
+);