core: Separate SQL current and upgrade scripts
[quassel.git] / src / core / SQL / SQLite / version / 21 / upgrade_004_insert_into_buffer_new_from_buffer.sql
1 INSERT INTO buffer_new (
2         bufferid, 
3         userid, 
4         groupid, 
5         networkid, 
6         buffername, 
7         buffercname, 
8         buffertype, 
9         lastmsgid, 
10         lastseenmsgid,
11         markerlinemsgid,
12         key,
13         joined
14 )
15 SELECT 
16         bufferid,
17         userid,
18         groupid,
19         networkid,
20         buffername,
21         buffercname,
22         buffertype,
23         lastmsgid,
24         lastseenmsgid,
25         markerlinemsgid,
26         key,
27         joined
28 FROM buffer;