Fix lastseenmsgid updates in PostgreSQL

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

diff --git a/src/core/SQL/PostgreSQL/20/setup_050_buffer.sql b/src/core/SQL/PostgreSQL/20/setup_050_buffer.sql
index bbf8ab6..a9206ac 100644 (file)
--- a/src/core/SQL/PostgreSQL/20/setup_050_buffer.sql
+++ b/src/core/SQL/PostgreSQL/20/setup_050_buffer.sql
@@ -6,10 +6,11 @@ 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,
+       lastmsgid integer NOT NULL DEFAULT 0,
        lastseenmsgid integer NOT NULL DEFAULT 0,
        markerlinemsgid integer NOT NULL DEFAULT 0,
        key varchar(128),
        joined boolean NOT NULL DEFAULT FALSE, -- BOOL
-       UNIQUE(userid, networkid, buffercname)
+       UNIQUE(userid, networkid, buffercname),
+       CHECK (buffer.lastseenmsgid <= buffer.lastmsgid)
 )