/quassel-0.7.3/src/core/SQL/SQLite/4/upgrade_020_copy_buffertable.sql

# · SQL · 2 lines · 2 code · 0 blank · 0 comment · 0 complexity · 71f4893f8d154dc190cdfa29471dadcc MD5 · raw file 

    

  1. INSERT INTO buffer (bufferid, userid, groupid, networkid, buffername, buffercname)
    2. 

  2. SELECT bufferid, userid, groupid, networkid, buffername, lower(buffername) FROM bufferold
    3.