switching from timestamps to msgid regarding lastseen states

[quassel.git] / src / core / SQL / SQLite / 10 / upgrade_030_copy_buffer_table.sql

diff --git a/src/core/SQL/SQLite/10/upgrade_030_copy_buffer_table.sql b/src/core/SQL/SQLite/10/upgrade_030_copy_buffer_table.sql
new file mode 100644 (file)
index 0000000..cb6b6b5
--- /dev/null
+++ b/src/core/SQL/SQLite/10/upgrade_030_copy_buffer_table.sql
@@ -0,0 +1,2 @@
+INSERT INTO buffer (bufferid, userid, groupid, networkid, buffername, buffercname, buffertype, lastseenmsgid, key, joined)
+SELECT bufferid, userid, groupid, networkid, buffername, buffercname, buffertype, lastseen, key, joined FROM buffer_old