X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2F21%2Fsetup_030_buffer.sql;fp=src%2Fcore%2FSQL%2FSQLite%2F20%2Fsetup_030_buffer.sql;h=53ea5429eff30e0684317ea988fc32a88e672707;hp=facb75cd7ae33c3453639f30c137e91336d29833;hb=10ee60164fb3701b20c439269f170a4f2cb2e2a9;hpb=dd449b81ff7f4499bef360a9a3676e48d794adcc

diff --git a/src/core/SQL/SQLite/20/setup_030_buffer.sql b/src/core/SQL/SQLite/21/setup_030_buffer.sql
similarity index 74%
rename from src/core/SQL/SQLite/20/setup_030_buffer.sql
rename to src/core/SQL/SQLite/21/setup_030_buffer.sql
index facb75cd..53ea5429 100644
--- a/src/core/SQL/SQLite/20/setup_030_buffer.sql
+++ b/src/core/SQL/SQLite/21/setup_030_buffer.sql
@@ -6,8 +6,10 @@ CREATE TABLE buffer (
 	buffername TEXT NOT NULL,
 	buffercname TEXT 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 TEXT,
-	joined INTEGER NOT NULL DEFAULT 0 -- BOOL
+	joined INTEGER NOT NULL DEFAULT 0, -- BOOL
+	ALTER TABLE buffer_new RENAME TO buffer;
 )