core: Separate SQL current and upgrade scripts

[quassel.git] / src / core / SQL / SQLite / version / 21 / upgrade_004_insert_into_buffer_new_from_buffer.sql

diff --git a/src/core/SQL/SQLite/version/21/upgrade_004_insert_into_buffer_new_from_buffer.sql b/src/core/SQL/SQLite/version/21/upgrade_004_insert_into_buffer_new_from_buffer.sql
new file mode 100644 (file)
index 0000000..08468c3
--- /dev/null
+++ b/src/core/SQL/SQLite/version/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;