X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2F21%2Fupgrade_004_insert_into_buffer_new_from_buffer.sql;fp=src%2Fcore%2FSQL%2FSQLite%2F21%2Fupgrade_004_insert_into_buffer_new_from_buffer.sql;h=08468c3c177b282763807978dd5e80c3aa18ff1e;hb=10ee60164fb3701b20c439269f170a4f2cb2e2a9;hp=0000000000000000000000000000000000000000;hpb=dd449b81ff7f4499bef360a9a3676e48d794adcc;p=quassel.git

diff --git a/src/core/SQL/SQLite/21/upgrade_004_insert_into_buffer_new_from_buffer.sql b/src/core/SQL/SQLite/21/upgrade_004_insert_into_buffer_new_from_buffer.sql
new file mode 100644
index 00000000..08468c3c
--- /dev/null
+++ b/src/core/SQL/SQLite/21/upgrade_004_insert_into_buffer_new_from_buffer.sql
@@ -0,0 +1,28 @@
+INSERT INTO buffer_new (
+	bufferid, 
+	userid, 
+	groupid, 
+	networkid, 
+	buffername, 
+	buffercname, 
+	buffertype, 
+	lastmsgid, 
+	lastseenmsgid,
+	markerlinemsgid,
+	key,
+	joined
+)
+SELECT 
+	bufferid,
+	userid,
+	groupid,
+	networkid,
+	buffername,
+	buffercname,
+	buffertype,
+	lastmsgid,
+	lastseenmsgid,
+	markerlinemsgid,
+	key,
+	joined
+FROM buffer;