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 5b73c88..0487dd3 100644 (file)
--- a/src/core/SQL/PostgreSQL/setup_050_buffer.sql
+++ b/src/core/SQL/PostgreSQL/setup_050_buffer.sql
@@ -6,9 +6,9 @@ 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),