Sync last message id per buffer

[quassel.git] / src / core / SQL / PostgreSQL / setup_050_buffer.sql

diff --git a/src/core/SQL/PostgreSQL/setup_050_buffer.sql b/src/core/SQL/PostgreSQL/setup_050_buffer.sql
index a9206ac..0487dd3 100644 (file)
--- a/src/core/SQL/PostgreSQL/setup_050_buffer.sql
+++ b/src/core/SQL/PostgreSQL/setup_050_buffer.sql
@@ -6,11 +6,14 @@ create TABLE buffer (
        buffername varchar(128) NOT NULL,
        buffercname varchar(128) NOT NULL, -- CANONICAL BUFFER NAME (lowercase version)
        buffertype integer NOT NULL DEFAULT 0,
-       lastmsgid integer NOT NULL DEFAULT 0,
-       lastseenmsgid integer NOT NULL DEFAULT 0,
-       markerlinemsgid integer NOT NULL DEFAULT 0,
+       lastmsgid bigint NOT NULL DEFAULT 0,
+       lastseenmsgid bigint NOT NULL DEFAULT 0,
+       markerlinemsgid bigint NOT NULL DEFAULT 0,
+       bufferactivity integer NOT NULL DEFAULT 0,
+       highlightcount integer NOT NULL DEFAULT 0,
        key varchar(128),
        joined boolean NOT NULL DEFAULT FALSE, -- BOOL
+       cipher TEXT,
        UNIQUE(userid, networkid, buffercname),
        CHECK (buffer.lastseenmsgid <= buffer.lastmsgid)
 )