Store highlight status per buffer coreside

[quassel.git] / src / core / SQL / SQLite / select_buffer_highlightcount.sql

diff --git a/src/core/SQL/SQLite/select_buffer_highlightcount.sql b/src/core/SQL/SQLite/select_buffer_highlightcount.sql
new file mode 100644 (file)
index 0000000..33058f8
--- /dev/null
+++ b/src/core/SQL/SQLite/select_buffer_highlightcount.sql
@@ -0,0 +1,7 @@
+SELECT COALESCE(t.sum,0)
+FROM
+  (SELECT COUNT(*) AS sum FROM backlog
+   WHERE bufferid = :bufferid
+     AND flags & 2 != 0
+     AND flags & 1 = 0
+     AND messageid > :lastseenmsgid) t;