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

diff --git a/src/core/SQL/PostgreSQL/19/setup_050_buffer.sql b/src/core/SQL/PostgreSQL/20/setup_050_buffer.sql
similarity index 92%
rename from src/core/SQL/PostgreSQL/19/setup_050_buffer.sql
rename to src/core/SQL/PostgreSQL/20/setup_050_buffer.sql
index a4b0ce56..bbf8ab6f 100644
--- a/src/core/SQL/PostgreSQL/19/setup_050_buffer.sql
+++ b/src/core/SQL/PostgreSQL/20/setup_050_buffer.sql
@@ -6,6 +6,7 @@ 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,
 	key varchar(128),