projects / quassel.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
core: Migrate SQLite schema to MSec, warn of slow
[quassel.git] / src / core / sql.qrc
diff --git a/src/core/sql.qrc b/src/core/sql.qrc
index 8d38df0..7a88399 100644 (file)
--- a/src/core/sql.qrc
+++ b/src/core/sql.qrc
@@ -1,123 +1,352 @@
 <!DOCTYPE RCC><RCC version="1.0">
 <qresource>
-    <file>./SQL/SQLite/1/upgrade_000_drop_coreinfo.sql</file>
-    <file>./SQL/SQLite/1/upgrade_010_create_coreinfo.sql</file>
-    <file>./SQL/SQLite/1/upgrade_020_update_schemaversion.sql</file>
-    <file>./SQL/SQLite/10/upgrade_000_switch_to_msgid.sql</file>
-    <file>./SQL/SQLite/10/upgrade_010_rename_buffer_table.sql</file>
-    <file>./SQL/SQLite/10/upgrade_020_create_buffer_table.sql</file>
-    <file>./SQL/SQLite/10/upgrade_030_copy_buffer_table.sql</file>
-    <file>./SQL/SQLite/10/upgrade_040_drop_buffer_old_table.sql</file>
-    <file>./SQL/SQLite/10/upgrade_999_version.sql</file>
-    <file>./SQL/SQLite/11/delete_backlog_by_uid.sql</file>
-    <file>./SQL/SQLite/11/delete_backlog_for_buffer.sql</file>
-    <file>./SQL/SQLite/11/delete_backlog_for_network.sql</file>
-    <file>./SQL/SQLite/11/delete_buffer_for_bufferid.sql</file>
-    <file>./SQL/SQLite/11/delete_buffers_by_uid.sql</file>
-    <file>./SQL/SQLite/11/delete_buffers_for_network.sql</file>
-    <file>./SQL/SQLite/11/delete_ircservers_for_network.sql</file>
-    <file>./SQL/SQLite/11/delete_network.sql</file>
-    <file>./SQL/SQLite/11/delete_networks_by_uid.sql</file>
-    <file>./SQL/SQLite/11/delete_quasseluser.sql</file>
-    <file>./SQL/SQLite/11/insert_buffer.sql</file>
-    <file>./SQL/SQLite/11/insert_message.sql</file>
-    <file>./SQL/SQLite/11/insert_network.sql</file>
-    <file>./SQL/SQLite/11/insert_quasseluser.sql</file>
-    <file>./SQL/SQLite/11/insert_sender.sql</file>
-    <file>./SQL/SQLite/11/insert_server.sql</file>
-    <file>./SQL/SQLite/11/insert_user_setting.sql</file>
-    <file>./SQL/SQLite/11/select_authuser.sql</file>
-    <file>./SQL/SQLite/11/select_buffer_by_id.sql</file>
-    <file>./SQL/SQLite/11/select_buffer_lastseen_messages.sql</file>
-    <file>./SQL/SQLite/11/select_bufferByName.sql</file>
-    <file>./SQL/SQLite/11/select_bufferExists.sql</file>
-    <file>./SQL/SQLite/11/select_buffers.sql</file>
-    <file>./SQL/SQLite/11/select_connected_networks.sql</file>
-    <file>./SQL/SQLite/11/select_messageRange.sql</file>
-    <file>./SQL/SQLite/11/select_messages.sql</file>
-    <file>./SQL/SQLite/11/select_messagesOffset.sql</file>
-    <file>./SQL/SQLite/11/select_messagesSince.sql</file>
-    <file>./SQL/SQLite/11/select_messagesSinceOffset.sql</file>
-    <file>./SQL/SQLite/11/select_networkExists.sql</file>
-    <file>./SQL/SQLite/11/select_networks_for_user.sql</file>
-    <file>./SQL/SQLite/11/select_persistent_channels.sql</file>
-    <file>./SQL/SQLite/11/select_servers_for_network.sql</file>
-    <file>./SQL/SQLite/11/select_user_setting.sql</file>
-    <file>./SQL/SQLite/11/select_userid.sql</file>
-    <file>./SQL/SQLite/11/setup_000_quasseluser.sql</file>
-    <file>./SQL/SQLite/11/setup_010_sender.sql</file>
-    <file>./SQL/SQLite/11/setup_020_network.sql</file>
-    <file>./SQL/SQLite/11/setup_030_buffer.sql</file>
-    <file>./SQL/SQLite/11/setup_040_buffer_idx.sql</file>
-    <file>./SQL/SQLite/11/setup_050_buffer_cname_idx.sql</file>
-    <file>./SQL/SQLite/11/setup_060_backlog.sql</file>
-    <file>./SQL/SQLite/11/setup_070_coreinfo.sql</file>
-    <file>./SQL/SQLite/11/setup_080_ircservers.sql</file>
-    <file>./SQL/SQLite/11/setup_090_create_backlog_idx.sql</file>
-    <file>./SQL/SQLite/11/setup_100_create_backlog_idx2.sql</file>
-    <file>./SQL/SQLite/11/setup_110_create_buffer_idx.sql</file>
-    <file>./SQL/SQLite/11/setup_120_create_user_setting.sql</file>
-    <file>./SQL/SQLite/11/setup_999_version.sql</file>
-    <file>./SQL/SQLite/11/update_buffer_lastseen.sql</file>
-    <file>./SQL/SQLite/11/update_buffer_name.sql</file>
-    <file>./SQL/SQLite/11/update_buffer_persistent_channel.sql</file>
-    <file>./SQL/SQLite/11/update_buffer_set_channel_key.sql</file>
-    <file>./SQL/SQLite/11/update_network.sql</file>
-    <file>./SQL/SQLite/11/update_network_connected.sql</file>
-    <file>./SQL/SQLite/11/update_user_setting.sql</file>
-    <file>./SQL/SQLite/11/update_username.sql</file>
-    <file>./SQL/SQLite/11/update_userpassword.sql</file>
-    <file>./SQL/SQLite/11/upgrade_000_create_user_setting.sql</file>
-    <file>./SQL/SQLite/11/upgrade_999_version.sql</file>
-    <file>./SQL/SQLite/2/upgrade_000_drop_buffergroup.sql</file>
-    <file>./SQL/SQLite/2/upgrade_010_update_schemaversion.sql</file>
-    <file>./SQL/SQLite/3/upgrade_000_update_backlog_flags.sql</file>
-    <file>./SQL/SQLite/3/upgrade_010_update_schemaversion.sql</file>
-    <file>./SQL/SQLite/4/upgrade_000_rename_buffertable.sql</file>
-    <file>./SQL/SQLite/4/upgrade_010_create_buffertable.sql</file>
-    <file>./SQL/SQLite/4/upgrade_020_copy_buffertable.sql</file>
-    <file>./SQL/SQLite/4/upgrade_030_drop_oldbuffertable.sql</file>
-    <file>./SQL/SQLite/4/upgrade_040_create_buffer_idx.sql</file>
-    <file>./SQL/SQLite/4/upgrade_050_create_buffer_cname_idx.sql</file>
-    <file>./SQL/SQLite/4/upgrade_999_update_schemaversion.sql</file>
-    <file>./SQL/SQLite/5/upgrade_000_rename_networktable.sql</file>
-    <file>./SQL/SQLite/5/upgrade_010_create_newnetworktable.sql</file>
-    <file>./SQL/SQLite/5/upgrade_020_copy_networktable.sql</file>
-    <file>./SQL/SQLite/5/upgrade_030_drop_oldnetworktable.sql</file>
-    <file>./SQL/SQLite/5/upgrade_180_create_ircservers.sql</file>
-    <file>./SQL/SQLite/5/upgrade_999_update_schemaversion.sql</file>
-    <file>./SQL/SQLite/6/upgrade_000_alter_buffertable.sql</file>
-    <file>./SQL/SQLite/6/upgrade_010_set_statusbuffertype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_020_set_channelbuffertype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_030_set_querybuffertype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_040_update_msgtype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_050_update_msgtype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_060_update_msgtype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_070_update_msgtype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_080_update_msgtype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_090_update_msgtype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_100_update_msgtype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_110_update_msgtype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_120_update_msgtype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_130_update_msgtype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_140_update_msgtype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_150_update_msgtype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_160_update_msgtype.sql</file>
-    <file>./SQL/SQLite/6/upgrade_999_version.sql</file>
-    <file>./SQL/SQLite/7/upgrade_000_rename_networktable.sql</file>
-    <file>./SQL/SQLite/7/upgrade_010_create_newnetworktable.sql</file>
-    <file>./SQL/SQLite/7/upgrade_020_copy_networktable.sql</file>
-    <file>./SQL/SQLite/7/upgrade_030_drop_oldnetworktable.sql</file>
-    <file>./SQL/SQLite/7/upgrade_040_alter_buffer_add_lastseen.sql</file>
-    <file>./SQL/SQLite/7/upgrade_999_version.sql</file>
-    <file>./SQL/SQLite/8/upgrade_000_alter_network_add_connected.sql</file>
-    <file>./SQL/SQLite/8/upgrade_010_alter_buffer_add_key.sql</file>
-    <file>./SQL/SQLite/8/upgrade_020_alter_buffer_add_joined.sql</file>
-    <file>./SQL/SQLite/8/upgrade_030_update_buffer_set_joined_for_channels.sql</file>
-    <file>./SQL/SQLite/8/upgrade_999_version.sql</file>
-    <file>./SQL/SQLite/9/upgrade_000_create_backlog_idx.sql</file>
-    <file>./SQL/SQLite/9/upgrade_010_create_backlog_idx2.sql</file>
-    <file>./SQL/SQLite/9/upgrade_020_create_buffer_idx.sql</file>
-    <file>./SQL/SQLite/9/upgrade_999_version.sql</file>
+    <file>./SQL/PostgreSQL/delete_backlog_by_uid.sql</file>
+    <file>./SQL/PostgreSQL/delete_backlog_for_buffer.sql</file>
+    <file>./SQL/PostgreSQL/delete_backlog_for_network.sql</file>
+    <file>./SQL/PostgreSQL/delete_buffer_for_bufferid.sql</file>
+    <file>./SQL/PostgreSQL/delete_buffers_by_uid.sql</file>
+    <file>./SQL/PostgreSQL/delete_buffers_for_network.sql</file>
+    <file>./SQL/PostgreSQL/delete_identity.sql</file>
+    <file>./SQL/PostgreSQL/delete_ircservers_for_network.sql</file>
+    <file>./SQL/PostgreSQL/delete_network.sql</file>
+    <file>./SQL/PostgreSQL/delete_networks_by_uid.sql</file>
+    <file>./SQL/PostgreSQL/delete_nicks.sql</file>
+    <file>./SQL/PostgreSQL/delete_quasseluser.sql</file>
+    <file>./SQL/PostgreSQL/insert_buffer.sql</file>
+    <file>./SQL/PostgreSQL/insert_core_state.sql</file>
+    <file>./SQL/PostgreSQL/insert_identity.sql</file>
+    <file>./SQL/PostgreSQL/insert_message.sql</file>
+    <file>./SQL/PostgreSQL/insert_network.sql</file>
+    <file>./SQL/PostgreSQL/insert_nick.sql</file>
+    <file>./SQL/PostgreSQL/insert_quasseluser.sql</file>
+    <file>./SQL/PostgreSQL/insert_sender.sql</file>
+    <file>./SQL/PostgreSQL/insert_server.sql</file>
+    <file>./SQL/PostgreSQL/insert_user_setting.sql</file>
+    <file>./SQL/PostgreSQL/migrate_write_backlog.sql</file>
+    <file>./SQL/PostgreSQL/migrate_write_buffer.sql</file>
+    <file>./SQL/PostgreSQL/migrate_write_corestate.sql</file>
+    <file>./SQL/PostgreSQL/migrate_write_identity.sql</file>
+    <file>./SQL/PostgreSQL/migrate_write_identity_nick.sql</file>
+    <file>./SQL/PostgreSQL/migrate_write_ircserver.sql</file>
+    <file>./SQL/PostgreSQL/migrate_write_network.sql</file>
+    <file>./SQL/PostgreSQL/migrate_write_quasseluser.sql</file>
+    <file>./SQL/PostgreSQL/migrate_write_sender.sql</file>
+    <file>./SQL/PostgreSQL/migrate_write_usersetting.sql</file>
+    <file>./SQL/PostgreSQL/select_all_authusernames.sql</file>
+    <file>./SQL/PostgreSQL/select_authenticator.sql</file>
+    <file>./SQL/PostgreSQL/select_authuser.sql</file>
+    <file>./SQL/PostgreSQL/select_authusername.sql</file>
+    <file>./SQL/PostgreSQL/select_bufferByName.sql</file>
+    <file>./SQL/PostgreSQL/select_bufferExists.sql</file>
+    <file>./SQL/PostgreSQL/select_buffer_bufferactivities.sql</file>
+    <file>./SQL/PostgreSQL/select_buffer_bufferactivity.sql</file>
+    <file>./SQL/PostgreSQL/select_buffer_by_id.sql</file>
+    <file>./SQL/PostgreSQL/select_buffer_ciphers.sql</file>
+    <file>./SQL/PostgreSQL/select_buffer_highlightcount.sql</file>
+    <file>./SQL/PostgreSQL/select_buffer_highlightcounts.sql</file>
+    <file>./SQL/PostgreSQL/select_buffer_lastseen_messages.sql</file>
+    <file>./SQL/PostgreSQL/select_buffer_markerlinemsgids.sql</file>
+    <file>./SQL/PostgreSQL/select_buffers.sql</file>
+    <file>./SQL/PostgreSQL/select_buffers_for_network.sql</file>
+    <file>./SQL/PostgreSQL/select_checkidentity.sql</file>
+    <file>./SQL/PostgreSQL/select_connected_networks.sql</file>
+    <file>./SQL/PostgreSQL/select_core_state.sql</file>
+    <file>./SQL/PostgreSQL/select_identities.sql</file>
+    <file>./SQL/PostgreSQL/select_internaluser.sql</file>
+    <file>./SQL/PostgreSQL/select_messagesAll.sql</file>
+    <file>./SQL/PostgreSQL/select_messagesAllNew.sql</file>
+    <file>./SQL/PostgreSQL/select_messagesAllNew_filtered.sql</file>
+    <file>./SQL/PostgreSQL/select_messagesAll_filtered.sql</file>
+    <file>./SQL/PostgreSQL/select_messagesNewerThan.sql</file>
+    <file>./SQL/PostgreSQL/select_messagesNewerThan_filtered.sql</file>
+    <file>./SQL/PostgreSQL/select_messagesNewestK.sql</file>
+    <file>./SQL/PostgreSQL/select_messagesNewestK_filtered.sql</file>
+    <file>./SQL/PostgreSQL/select_messagesRange.sql</file>
+    <file>./SQL/PostgreSQL/select_messagesRange_filtered.sql</file>
+    <file>./SQL/PostgreSQL/select_networkExists.sql</file>
+    <file>./SQL/PostgreSQL/select_network_awaymsg.sql</file>
+    <file>./SQL/PostgreSQL/select_network_usermode.sql</file>
+    <file>./SQL/PostgreSQL/select_networks_for_user.sql</file>
+    <file>./SQL/PostgreSQL/select_nicks.sql</file>
+    <file>./SQL/PostgreSQL/select_persistent_channels.sql</file>
+    <file>./SQL/PostgreSQL/select_senderid.sql</file>
+    <file>./SQL/PostgreSQL/select_servers_for_network.sql</file>
+    <file>./SQL/PostgreSQL/select_user_setting.sql</file>
+    <file>./SQL/PostgreSQL/select_userid.sql</file>
+    <file>./SQL/PostgreSQL/setup_000_quasseluser.sql</file>
+    <file>./SQL/PostgreSQL/setup_010_sender.sql</file>
+    <file>./SQL/PostgreSQL/setup_020_identity.sql</file>
+    <file>./SQL/PostgreSQL/setup_030_identity_nick.sql</file>
+    <file>./SQL/PostgreSQL/setup_040_network.sql</file>
+    <file>./SQL/PostgreSQL/setup_050_buffer.sql</file>
+    <file>./SQL/PostgreSQL/setup_060_backlog.sql</file>
+    <file>./SQL/PostgreSQL/setup_061_add_function_backlog_lastmsgid_update.sql</file>
+    <file>./SQL/PostgreSQL/setup_062_add_trigger_backlog_lastmsgid_update.sql</file>
+    <file>./SQL/PostgreSQL/setup_070_coreinfo.sql</file>
+    <file>./SQL/PostgreSQL/setup_080_ircservers.sql</file>
+    <file>./SQL/PostgreSQL/setup_090_backlog_idx.sql</file>
+    <file>./SQL/PostgreSQL/setup_100_user_setting.sql</file>
+    <file>./SQL/PostgreSQL/setup_110_alter_sender_seq.sql</file>
+    <file>./SQL/PostgreSQL/setup_120_alter_messageid_seq.sql</file>
+    <file>./SQL/PostgreSQL/setup_130_function_lastmsgid.sql</file>
+    <file>./SQL/PostgreSQL/setup_140_sender_idx.sql</file>
+    <file>./SQL/PostgreSQL/setup_150_corestate.sql</file>
+    <file>./SQL/PostgreSQL/update_backlog_bufferid.sql</file>
+    <file>./SQL/PostgreSQL/update_buffer_bufferactivity.sql</file>
+    <file>./SQL/PostgreSQL/update_buffer_cipher.sql</file>
+    <file>./SQL/PostgreSQL/update_buffer_highlightcount.sql</file>
+    <file>./SQL/PostgreSQL/update_buffer_lastseen.sql</file>
+    <file>./SQL/PostgreSQL/update_buffer_markerlinemsgid.sql</file>
+    <file>./SQL/PostgreSQL/update_buffer_name.sql</file>
+    <file>./SQL/PostgreSQL/update_buffer_persistent_channel.sql</file>
+    <file>./SQL/PostgreSQL/update_buffer_set_channel_key.sql</file>
+    <file>./SQL/PostgreSQL/update_core_state.sql</file>
+    <file>./SQL/PostgreSQL/update_identity.sql</file>
+    <file>./SQL/PostgreSQL/update_network.sql</file>
+    <file>./SQL/PostgreSQL/update_network_connected.sql</file>
+    <file>./SQL/PostgreSQL/update_network_set_awaymsg.sql</file>
+    <file>./SQL/PostgreSQL/update_network_set_usermode.sql</file>
+    <file>./SQL/PostgreSQL/update_user_setting.sql</file>
+    <file>./SQL/PostgreSQL/update_username.sql</file>
+    <file>./SQL/PostgreSQL/update_userpassword.sql</file>
+    <file>./SQL/PostgreSQL/version/15/upgrade_000_alter_buffer_add_markerlinemsgid.sql</file>
+    <file>./SQL/PostgreSQL/version/16/upgrade_000_alter_network_add_sasl.sql</file>
+    <file>./SQL/PostgreSQL/version/17/upgrade_000_alter_quasseluser_add_passwordversion.sql</file>
+    <file>./SQL/PostgreSQL/version/18/upgrade_000_alter_ircserver_add_sslverify.sql</file>
+    <file>./SQL/PostgreSQL/version/19/upgrade_000_alter_network_add_ratelimit_usecustom.sql</file>
+    <file>./SQL/PostgreSQL/version/19/upgrade_001_alter_network_add_ratelimit_burstsize.sql</file>
+    <file>./SQL/PostgreSQL/version/19/upgrade_002_alter_network_add_ratelimit_delay.sql</file>
+    <file>./SQL/PostgreSQL/version/19/upgrade_003_alter_network_add_ratelimit_unlimited.sql</file>
+    <file>./SQL/PostgreSQL/version/20/upgrade_000_alter_buffer_add_lastmsgid.sql</file>
+    <file>./SQL/PostgreSQL/version/20/upgrade_001_add_function_populate_lastmsgid.sql</file>
+    <file>./SQL/PostgreSQL/version/20/upgrade_002_run_function_populate_lastmsgid.sql</file>
+    <file>./SQL/PostgreSQL/version/20/upgrade_003_correct_bad_lastseenmsgid.sql</file>
+    <file>./SQL/PostgreSQL/version/20/upgrade_004_add_lastseenmsgid_constraint.sql</file>
+    <file>./SQL/PostgreSQL/version/21/upgrade_000_add_function_backlog_lastmsgid_update.sql</file>
+    <file>./SQL/PostgreSQL/version/21/upgrade_001_add_trigger_backlog_lastmsgid_update.sql</file>
+    <file>./SQL/PostgreSQL/version/22/upgrade_000_alter_quasseluser_add_authenticator.sql</file>
+    <file>./SQL/PostgreSQL/version/23/upgrade_000_create_senderprefixes.sql</file>
+    <file>./SQL/PostgreSQL/version/24/upgrade_000_alter_buffer_add_bufferactivity.sql</file>
+    <file>./SQL/PostgreSQL/version/25/upgrade_000_alter_buffer_add_cipher.sql</file>
+    <file>./SQL/PostgreSQL/version/26/upgrade_000_alter_buffer_add_highlightcount.sql</file>
+    <file>./SQL/PostgreSQL/version/27/upgrade_000_update_sender_add_realname.sql</file>
+    <file>./SQL/PostgreSQL/version/27/upgrade_010_update_sender_add_avatarurl.sql</file>
+    <file>./SQL/PostgreSQL/version/27/upgrade_020_update_sender_add_new_constraint.sql</file>
+    <file>./SQL/PostgreSQL/version/27/upgrade_030_upgrade_sender_drop_old_constraint.sql</file>
+    <file>./SQL/PostgreSQL/version/28/upgrade_000_create_corestate.sql</file>
+    <file>./SQL/PostgreSQL/version/29/upgrade_010_alter_sender_64bit_ids.sql</file>
+    <file>./SQL/PostgreSQL/version/29/upgrade_050_alter_buffer_64bit_ids.sql</file>
+    <file>./SQL/PostgreSQL/version/29/upgrade_060_alter_backlog_64bit_ids.sql</file>
+    <file>./SQL/SQLite/delete_backlog_by_uid.sql</file>
+    <file>./SQL/SQLite/delete_backlog_for_buffer.sql</file>
+    <file>./SQL/SQLite/delete_backlog_for_network.sql</file>
+    <file>./SQL/SQLite/delete_buffer_for_bufferid.sql</file>
+    <file>./SQL/SQLite/delete_buffers_by_uid.sql</file>
+    <file>./SQL/SQLite/delete_buffers_for_network.sql</file>
+    <file>./SQL/SQLite/delete_identity.sql</file>
+    <file>./SQL/SQLite/delete_ircservers_for_network.sql</file>
+    <file>./SQL/SQLite/delete_network.sql</file>
+    <file>./SQL/SQLite/delete_networks_by_uid.sql</file>
+    <file>./SQL/SQLite/delete_nicks.sql</file>
+    <file>./SQL/SQLite/delete_quasseluser.sql</file>
+    <file>./SQL/SQLite/insert_buffer.sql</file>
+    <file>./SQL/SQLite/insert_core_state.sql</file>
+    <file>./SQL/SQLite/insert_identity.sql</file>
+    <file>./SQL/SQLite/insert_message.sql</file>
+    <file>./SQL/SQLite/insert_network.sql</file>
+    <file>./SQL/SQLite/insert_nick.sql</file>
+    <file>./SQL/SQLite/insert_quasseluser.sql</file>
+    <file>./SQL/SQLite/insert_sender.sql</file>
+    <file>./SQL/SQLite/insert_server.sql</file>
+    <file>./SQL/SQLite/insert_user_setting.sql</file>
+    <file>./SQL/SQLite/migrate_read_backlog.sql</file>
+    <file>./SQL/SQLite/migrate_read_buffer.sql</file>
+    <file>./SQL/SQLite/migrate_read_corestate.sql</file>
+    <file>./SQL/SQLite/migrate_read_identity.sql</file>
+    <file>./SQL/SQLite/migrate_read_identity_nick.sql</file>
+    <file>./SQL/SQLite/migrate_read_ircserver.sql</file>
+    <file>./SQL/SQLite/migrate_read_network.sql</file>
+    <file>./SQL/SQLite/migrate_read_quasseluser.sql</file>
+    <file>./SQL/SQLite/migrate_read_sender.sql</file>
+    <file>./SQL/SQLite/migrate_read_usersetting.sql</file>
+    <file>./SQL/SQLite/select_all_authusernames.sql</file>
+    <file>./SQL/SQLite/select_authenticator.sql</file>
+    <file>./SQL/SQLite/select_authuser.sql</file>
+    <file>./SQL/SQLite/select_authusername.sql</file>
+    <file>./SQL/SQLite/select_bufferByName.sql</file>
+    <file>./SQL/SQLite/select_bufferExists.sql</file>
+    <file>./SQL/SQLite/select_buffer_bufferactivities.sql</file>
+    <file>./SQL/SQLite/select_buffer_bufferactivity.sql</file>
+    <file>./SQL/SQLite/select_buffer_by_id.sql</file>
+    <file>./SQL/SQLite/select_buffer_ciphers.sql</file>
+    <file>./SQL/SQLite/select_buffer_highlightcount.sql</file>
+    <file>./SQL/SQLite/select_buffer_highlightcounts.sql</file>
+    <file>./SQL/SQLite/select_buffer_lastseen_messages.sql</file>
+    <file>./SQL/SQLite/select_buffer_markerlinemsgids.sql</file>
+    <file>./SQL/SQLite/select_buffers.sql</file>
+    <file>./SQL/SQLite/select_buffers_for_merge.sql</file>
+    <file>./SQL/SQLite/select_buffers_for_network.sql</file>
+    <file>./SQL/SQLite/select_checkidentity.sql</file>
+    <file>./SQL/SQLite/select_connected_networks.sql</file>
+    <file>./SQL/SQLite/select_core_state.sql</file>
+    <file>./SQL/SQLite/select_identities.sql</file>
+    <file>./SQL/SQLite/select_internaluser.sql</file>
+    <file>./SQL/SQLite/select_messagesAll.sql</file>
+    <file>./SQL/SQLite/select_messagesAllNew.sql</file>
+    <file>./SQL/SQLite/select_messagesAllNew_filtered.sql</file>
+    <file>./SQL/SQLite/select_messagesAll_filtered.sql</file>
+    <file>./SQL/SQLite/select_messagesNewerThan.sql</file>
+    <file>./SQL/SQLite/select_messagesNewerThan_filtered.sql</file>
+    <file>./SQL/SQLite/select_messagesNewestK.sql</file>
+    <file>./SQL/SQLite/select_messagesNewestK_filtered.sql</file>
+    <file>./SQL/SQLite/select_messagesRange.sql</file>
+    <file>./SQL/SQLite/select_messagesRange_filtered.sql</file>
+    <file>./SQL/SQLite/select_networkExists.sql</file>
+    <file>./SQL/SQLite/select_network_awaymsg.sql</file>
+    <file>./SQL/SQLite/select_network_usermode.sql</file>
+    <file>./SQL/SQLite/select_networks_for_user.sql</file>
+    <file>./SQL/SQLite/select_nicks.sql</file>
+    <file>./SQL/SQLite/select_persistent_channels.sql</file>
+    <file>./SQL/SQLite/select_servers_for_network.sql</file>
+    <file>./SQL/SQLite/select_user_setting.sql</file>
+    <file>./SQL/SQLite/select_userid.sql</file>
+    <file>./SQL/SQLite/setup_000_quasseluser.sql</file>
+    <file>./SQL/SQLite/setup_010_sender.sql</file>
+    <file>./SQL/SQLite/setup_020_network.sql</file>
+    <file>./SQL/SQLite/setup_030_buffer.sql</file>
+    <file>./SQL/SQLite/setup_040_buffer_idx.sql</file>
+    <file>./SQL/SQLite/setup_050_buffer_cname_idx.sql</file>
+    <file>./SQL/SQLite/setup_060_backlog.sql</file>
+    <file>./SQL/SQLite/setup_061_add_trigger_backlog_lastmsgid_update_direct_insert.sql</file>
+    <file>./SQL/SQLite/setup_062_add_trigger_backlog_lastmsgid_update_direct_update.sql</file>
+    <file>./SQL/SQLite/setup_070_coreinfo.sql</file>
+    <file>./SQL/SQLite/setup_080_ircservers.sql</file>
+    <file>./SQL/SQLite/setup_090_backlog_idx.sql</file>
+    <file>./SQL/SQLite/setup_100_backlog_idx2.sql</file>
+    <file>./SQL/SQLite/setup_110_backlog_idx3.sql</file>
+    <file>./SQL/SQLite/setup_110_buffer_user_idx.sql</file>
+    <file>./SQL/SQLite/setup_120_user_setting.sql</file>
+    <file>./SQL/SQLite/setup_130_identity.sql</file>
+    <file>./SQL/SQLite/setup_140_identity_nick.sql</file>
+    <file>./SQL/SQLite/setup_150_sender_idx.sql</file>
+    <file>./SQL/SQLite/setup_160_corestate.sql</file>
+    <file>./SQL/SQLite/update_backlog_bufferid.sql</file>
+    <file>./SQL/SQLite/update_buffer_bufferactivity.sql</file>
+    <file>./SQL/SQLite/update_buffer_cipher.sql</file>
+    <file>./SQL/SQLite/update_buffer_highlightcount.sql</file>
+    <file>./SQL/SQLite/update_buffer_lastseen.sql</file>
+    <file>./SQL/SQLite/update_buffer_markerlinemsgid.sql</file>
+    <file>./SQL/SQLite/update_buffer_name.sql</file>
+    <file>./SQL/SQLite/update_buffer_persistent_channel.sql</file>
+    <file>./SQL/SQLite/update_buffer_set_channel_key.sql</file>
+    <file>./SQL/SQLite/update_core_state.sql</file>
+    <file>./SQL/SQLite/update_identity.sql</file>
+    <file>./SQL/SQLite/update_network.sql</file>
+    <file>./SQL/SQLite/update_network_connected.sql</file>
+    <file>./SQL/SQLite/update_network_set_awaymsg.sql</file>
+    <file>./SQL/SQLite/update_network_set_usermode.sql</file>
+    <file>./SQL/SQLite/update_user_setting.sql</file>
+    <file>./SQL/SQLite/update_username.sql</file>
+    <file>./SQL/SQLite/update_userpassword.sql</file>
+    <file>./SQL/SQLite/version/1/upgrade_000_drop_coreinfo.sql</file>
+    <file>./SQL/SQLite/version/1/upgrade_010_create_coreinfo.sql</file>
+    <file>./SQL/SQLite/version/1/upgrade_020_update_schemaversion.sql</file>
+    <file>./SQL/SQLite/version/2/upgrade_000_drop_buffergroup.sql</file>
+    <file>./SQL/SQLite/version/2/upgrade_010_update_schemaversion.sql</file>
+    <file>./SQL/SQLite/version/3/upgrade_000_update_backlog_flags.sql</file>
+    <file>./SQL/SQLite/version/3/upgrade_010_update_schemaversion.sql</file>
+    <file>./SQL/SQLite/version/4/upgrade_000_rename_buffertable.sql</file>
+    <file>./SQL/SQLite/version/4/upgrade_010_create_buffertable.sql</file>
+    <file>./SQL/SQLite/version/4/upgrade_020_copy_buffertable.sql</file>
+    <file>./SQL/SQLite/version/4/upgrade_030_drop_oldbuffertable.sql</file>
+    <file>./SQL/SQLite/version/4/upgrade_040_create_buffer_idx.sql</file>
+    <file>./SQL/SQLite/version/4/upgrade_050_create_buffer_cname_idx.sql</file>
+    <file>./SQL/SQLite/version/5/upgrade_000_rename_networktable.sql</file>
+    <file>./SQL/SQLite/version/5/upgrade_010_create_newnetworktable.sql</file>
+    <file>./SQL/SQLite/version/5/upgrade_020_copy_networktable.sql</file>
+    <file>./SQL/SQLite/version/5/upgrade_030_drop_oldnetworktable.sql</file>
+    <file>./SQL/SQLite/version/5/upgrade_180_create_ircservers.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_000_alter_buffertable.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_010_set_statusbuffertype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_020_set_channelbuffertype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_030_set_querybuffertype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_040_update_msgtype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_050_update_msgtype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_060_update_msgtype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_070_update_msgtype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_080_update_msgtype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_090_update_msgtype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_100_update_msgtype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_110_update_msgtype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_120_update_msgtype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_130_update_msgtype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_140_update_msgtype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_150_update_msgtype.sql</file>
+    <file>./SQL/SQLite/version/6/upgrade_160_update_msgtype.sql</file>
+    <file>./SQL/SQLite/version/7/upgrade_000_rename_networktable.sql</file>
+    <file>./SQL/SQLite/version/7/upgrade_010_create_newnetworktable.sql</file>
+    <file>./SQL/SQLite/version/7/upgrade_020_copy_networktable.sql</file>
+    <file>./SQL/SQLite/version/7/upgrade_030_drop_oldnetworktable.sql</file>
+    <file>./SQL/SQLite/version/7/upgrade_040_alter_buffer_add_lastseen.sql</file>
+    <file>./SQL/SQLite/version/8/upgrade_000_alter_network_add_connected.sql</file>
+    <file>./SQL/SQLite/version/8/upgrade_010_alter_buffer_add_key.sql</file>
+    <file>./SQL/SQLite/version/8/upgrade_020_alter_buffer_add_joined.sql</file>
+    <file>./SQL/SQLite/version/8/upgrade_030_update_buffer_set_joined_for_channels.sql</file>
+    <file>./SQL/SQLite/version/9/upgrade_000_create_backlog_idx.sql</file>
+    <file>./SQL/SQLite/version/9/upgrade_010_create_backlog_idx2.sql</file>
+    <file>./SQL/SQLite/version/9/upgrade_020_create_buffer_idx.sql</file>
+    <file>./SQL/SQLite/version/10/upgrade_000_switch_to_msgid.sql</file>
+    <file>./SQL/SQLite/version/10/upgrade_010_rename_buffer_table.sql</file>
+    <file>./SQL/SQLite/version/10/upgrade_020_create_buffer_table.sql</file>
+    <file>./SQL/SQLite/version/10/upgrade_030_copy_buffer_table.sql</file>
+    <file>./SQL/SQLite/version/10/upgrade_040_drop_buffer_old_table.sql</file>
+    <file>./SQL/SQLite/version/11/upgrade_000_create_user_setting.sql</file>
+    <file>./SQL/SQLite/version/12/upgrade_000_create_identity.sql</file>
+    <file>./SQL/SQLite/version/12/upgrade_010_create_identity_nick.sql</file>
+    <file>./SQL/SQLite/version/12/upgrade_020_rename_servertable.sql</file>
+    <file>./SQL/SQLite/version/12/upgrade_030_create_ircserver.sql</file>
+    <file>./SQL/SQLite/version/12/upgrade_040_copy_ircserver.sql</file>
+    <file>./SQL/SQLite/version/12/upgrade_050_drop_ircserverold.sql</file>
+    <file>./SQL/SQLite/version/13/upgrade_000_create_buffer_user_idx.sql</file>
+    <file>./SQL/SQLite/version/13/upgrade_010_create_buffer_cname_idx.sql</file>
+    <file>./SQL/SQLite/version/13/upgrade_020_create_buffer_cname_idx.sql</file>
+    <file>./SQL/SQLite/version/14/upgrade_000_rename_networktable.sql</file>
+    <file>./SQL/SQLite/version/14/upgrade_010_create_networktable.sql</file>
+    <file>./SQL/SQLite/version/14/upgrade_030_copy_networktable.sql</file>
+    <file>./SQL/SQLite/version/14/upgrade_040_drop_networkold.sql</file>
+    <file>./SQL/SQLite/version/15/upgrade_000_fix_ircservers.sql</file>
+    <file>./SQL/SQLite/version/15/upgrade_000_fix_network.sql</file>
+    <file>./SQL/SQLite/version/16/upgrade_000_alter_buffer_add_markerlinemsgid.sql</file>
+    <file>./SQL/SQLite/version/17/upgrade_000_alter_network_add_sasl.sql</file>
+    <file>./SQL/SQLite/version/17/upgrade_001_alter_network_add_sasl.sql</file>
+    <file>./SQL/SQLite/version/17/upgrade_002_alter_network_add_sasl.sql</file>
+    <file>./SQL/SQLite/version/18/upgrade_000_alter_quasseluser_add_passwordversion.sql</file>
+    <file>./SQL/SQLite/version/19/upgrade_000_alter_ircserver_add_sslverify.sql</file>
+    <file>./SQL/SQLite/version/20/upgrade_000_alter_network_add_ratelimit_usecustom.sql</file>
+    <file>./SQL/SQLite/version/20/upgrade_001_alter_network_add_ratelimit_burstsize.sql</file>
+    <file>./SQL/SQLite/version/20/upgrade_002_alter_network_add_ratelimit_delay.sql</file>
+    <file>./SQL/SQLite/version/20/upgrade_003_alter_network_add_ratelimit_unlimited.sql</file>
+    <file>./SQL/SQLite/version/21/upgrade_000_alter_buffer_add_lastmsgid.sql</file>
+    <file>./SQL/SQLite/version/21/upgrade_001_update_buffer_set_lastmsgid.sql</file>
+    <file>./SQL/SQLite/version/21/upgrade_002_update_buffer_fix_lastseenmsgid_over_lastmsgid.sql</file>
+    <file>./SQL/SQLite/version/21/upgrade_003_create_table_buffer_new.sql</file>
+    <file>./SQL/SQLite/version/21/upgrade_004_insert_into_buffer_new_from_buffer.sql</file>
+    <file>./SQL/SQLite/version/21/upgrade_005_drop_table_buffer.sql</file>
+    <file>./SQL/SQLite/version/21/upgrade_006_alter_table_buffer_new_rename_to_buffer.sql</file>
+    <file>./SQL/SQLite/version/22/upgrade_000_add_trigger_backlog_lastmsgid_update_direct_insert.sql</file>
+    <file>./SQL/SQLite/version/22/upgrade_001_add_trigger_backlog_lastmsgid_update_direct_update.sql</file>
+    <file>./SQL/SQLite/version/23/upgrade_000_alter_quasseluser_add_authenticator.sql</file>
+    <file>./SQL/SQLite/version/24/upgrade_000_create_senderprefixes.sql</file>
+    <file>./SQL/SQLite/version/25/upgrade_000_alter_buffer_add_bufferactivity.sql</file>
+    <file>./SQL/SQLite/version/26/upgrade_000_create_buffer_idx.sql</file>
+    <file>./SQL/SQLite/version/27/upgrade_000_alter_buffer_add_cipher.sql</file>
+    <file>./SQL/SQLite/version/28/upgrade_000_alter_buffer_add_highlightcount.sql</file>
+    <file>./SQL/SQLite/version/29/upgrade_000_create_sender_tmp.sql</file>
+    <file>./SQL/SQLite/version/29/upgrade_010_copy_sender_sender_tmp.sql</file>
+    <file>./SQL/SQLite/version/29/upgrade_020_drop_sender.sql</file>
+    <file>./SQL/SQLite/version/29/upgrade_030_rename_sender_tmp_sender.sql</file>
+    <file>./SQL/SQLite/version/29/upgrade_040_update_sender_add_realname_avatarurl.sql</file>
+    <file>./SQL/SQLite/version/30/upgrade_000_create_corestate.sql</file>
+    <file>./SQL/SQLite/version/31/upgrade_000_update_buffer_set_time_extended.sql</file>
 </qresource>
 </RCC>
Quassel IRC