core: Fix SQLite realname/avatarurl handling

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

diff --git a/src/core/SQL/SQLite/setup_030_buffer.sql b/src/core/SQL/SQLite/setup_030_buffer.sql
index 66f22fa..7e29531 100644 (file)
--- a/src/core/SQL/SQLite/setup_030_buffer.sql
+++ b/src/core/SQL/SQLite/setup_030_buffer.sql
@@ -9,7 +9,10 @@ CREATE TABLE buffer (
        lastmsgid INTEGER NOT NULL DEFAULT 0,
        lastseenmsgid INTEGER NOT NULL DEFAULT 0,
        markerlinemsgid INTEGER NOT NULL DEFAULT 0,
        lastmsgid INTEGER NOT NULL DEFAULT 0,
        lastseenmsgid INTEGER NOT NULL DEFAULT 0,
        markerlinemsgid INTEGER NOT NULL DEFAULT 0,

+       bufferactivity INTEGER NOT NULL DEFAULT 0,
+       highlightcount INTEGER NOT NULL DEFAULT 0,

        key TEXT,
        joined INTEGER NOT NULL DEFAULT 0, -- BOOL
        key TEXT,
        joined INTEGER NOT NULL DEFAULT 0, -- BOOL

+       cipher TEXT,

        CHECK (lastseenmsgid <= lastmsgid)
 )
        CHECK (lastseenmsgid <= lastmsgid)
 )