X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2F20%2Fsetup_050_buffer.sql;h=a9206acbb73db00bc4ff7b9436715e9acad9d3f6;hb=31c1e758654388b080ce1dee7065afa053efc1b8;hp=bbf8ab6f5398706432c1776575085ae9f7c37811;hpb=d682289cc69fac3a5776ef29059cc1f54d8d37d4;p=quassel.git

diff --git a/src/core/SQL/PostgreSQL/20/setup_050_buffer.sql b/src/core/SQL/PostgreSQL/20/setup_050_buffer.sql
index bbf8ab6f..a9206acb 100644
--- 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)
 )