Port the previous PostgreSQL improvements to SQLite3. 273/head
authorAlex Ingram <reimu@reimuhakurei.net>
Sat, 4 Mar 2017 02:34:20 +0000 (20:34 -0600)
committerAlex Ingram <reimu@reimuhakurei.net>
Sat, 4 Mar 2017 04:47:14 +0000 (23:47 -0500)
commit10ee60164fb3701b20c439269f170a4f2cb2e2a9
tree69e6e78c81081c1fa1b017b29d259b92cd2458de
parentdd449b81ff7f4499bef360a9a3676e48d794adcc
Port the previous PostgreSQL improvements to SQLite3.
99 files changed:
src/core/SQL/PostgreSQL/20/select_messagesNewerThan.sql
src/core/SQL/PostgreSQL/20/update_buffer_lastseen.sql
src/core/SQL/SQLite/21/delete_backlog_by_uid.sql [moved from src/core/SQL/SQLite/20/delete_backlog_by_uid.sql with 100% similarity]
src/core/SQL/SQLite/21/delete_backlog_for_buffer.sql [moved from src/core/SQL/SQLite/20/delete_backlog_for_buffer.sql with 100% similarity]
src/core/SQL/SQLite/21/delete_backlog_for_network.sql [moved from src/core/SQL/SQLite/20/delete_backlog_for_network.sql with 100% similarity]
src/core/SQL/SQLite/21/delete_buffer_for_bufferid.sql [moved from src/core/SQL/SQLite/20/delete_buffer_for_bufferid.sql with 100% similarity]
src/core/SQL/SQLite/21/delete_buffers_by_uid.sql [moved from src/core/SQL/SQLite/20/delete_buffers_by_uid.sql with 100% similarity]
src/core/SQL/SQLite/21/delete_buffers_for_network.sql [moved from src/core/SQL/SQLite/20/delete_buffers_for_network.sql with 100% similarity]
src/core/SQL/SQLite/21/delete_identity.sql [moved from src/core/SQL/SQLite/20/delete_identity.sql with 100% similarity]
src/core/SQL/SQLite/21/delete_ircservers_for_network.sql [moved from src/core/SQL/SQLite/20/delete_ircservers_for_network.sql with 100% similarity]
src/core/SQL/SQLite/21/delete_network.sql [moved from src/core/SQL/SQLite/20/delete_network.sql with 100% similarity]
src/core/SQL/SQLite/21/delete_networks_by_uid.sql [moved from src/core/SQL/SQLite/20/delete_networks_by_uid.sql with 100% similarity]
src/core/SQL/SQLite/21/delete_nicks.sql [moved from src/core/SQL/SQLite/20/delete_nicks.sql with 100% similarity]
src/core/SQL/SQLite/21/delete_quasseluser.sql [moved from src/core/SQL/SQLite/20/delete_quasseluser.sql with 100% similarity]
src/core/SQL/SQLite/21/insert_buffer.sql [moved from src/core/SQL/SQLite/20/insert_buffer.sql with 100% similarity]
src/core/SQL/SQLite/21/insert_identity.sql [moved from src/core/SQL/SQLite/20/insert_identity.sql with 100% similarity]
src/core/SQL/SQLite/21/insert_message.sql [moved from src/core/SQL/SQLite/20/insert_message.sql with 100% similarity]
src/core/SQL/SQLite/21/insert_network.sql [moved from src/core/SQL/SQLite/20/insert_network.sql with 100% similarity]
src/core/SQL/SQLite/21/insert_nick.sql [moved from src/core/SQL/SQLite/20/insert_nick.sql with 100% similarity]
src/core/SQL/SQLite/21/insert_quasseluser.sql [moved from src/core/SQL/SQLite/20/insert_quasseluser.sql with 100% similarity]
src/core/SQL/SQLite/21/insert_sender.sql [moved from src/core/SQL/SQLite/20/insert_sender.sql with 100% similarity]
src/core/SQL/SQLite/21/insert_server.sql [moved from src/core/SQL/SQLite/20/insert_server.sql with 100% similarity]
src/core/SQL/SQLite/21/insert_user_setting.sql [moved from src/core/SQL/SQLite/20/insert_user_setting.sql with 100% similarity]
src/core/SQL/SQLite/21/migrate_read_backlog.sql [moved from src/core/SQL/SQLite/20/migrate_read_backlog.sql with 100% similarity]
src/core/SQL/SQLite/21/migrate_read_buffer.sql [moved from src/core/SQL/SQLite/20/migrate_read_buffer.sql with 100% similarity]
src/core/SQL/SQLite/21/migrate_read_identity.sql [moved from src/core/SQL/SQLite/20/migrate_read_identity.sql with 100% similarity]
src/core/SQL/SQLite/21/migrate_read_identity_nick.sql [moved from src/core/SQL/SQLite/20/migrate_read_identity_nick.sql with 100% similarity]
src/core/SQL/SQLite/21/migrate_read_ircserver.sql [moved from src/core/SQL/SQLite/20/migrate_read_ircserver.sql with 100% similarity]
src/core/SQL/SQLite/21/migrate_read_network.sql [moved from src/core/SQL/SQLite/20/migrate_read_network.sql with 100% similarity]
src/core/SQL/SQLite/21/migrate_read_quasseluser.sql [moved from src/core/SQL/SQLite/20/migrate_read_quasseluser.sql with 100% similarity]
src/core/SQL/SQLite/21/migrate_read_sender.sql [moved from src/core/SQL/SQLite/20/migrate_read_sender.sql with 100% similarity]
src/core/SQL/SQLite/21/migrate_read_usersetting.sql [moved from src/core/SQL/SQLite/20/migrate_read_usersetting.sql with 100% similarity]
src/core/SQL/SQLite/21/select_authuser.sql [moved from src/core/SQL/SQLite/20/select_authuser.sql with 100% similarity]
src/core/SQL/SQLite/21/select_bufferByName.sql [moved from src/core/SQL/SQLite/20/select_bufferByName.sql with 100% similarity]
src/core/SQL/SQLite/21/select_bufferExists.sql [moved from src/core/SQL/SQLite/20/select_bufferExists.sql with 100% similarity]
src/core/SQL/SQLite/21/select_buffer_by_id.sql [moved from src/core/SQL/SQLite/20/select_buffer_by_id.sql with 100% similarity]
src/core/SQL/SQLite/21/select_buffer_lastseen_messages.sql [moved from src/core/SQL/SQLite/20/select_buffer_lastseen_messages.sql with 100% similarity]
src/core/SQL/SQLite/21/select_buffer_markerlinemsgids.sql [moved from src/core/SQL/SQLite/20/select_buffer_markerlinemsgids.sql with 100% similarity]
src/core/SQL/SQLite/21/select_buffers.sql [moved from src/core/SQL/SQLite/20/select_buffers.sql with 100% similarity]
src/core/SQL/SQLite/21/select_buffers_for_merge.sql [moved from src/core/SQL/SQLite/20/select_buffers_for_merge.sql with 100% similarity]
src/core/SQL/SQLite/21/select_buffers_for_network.sql [moved from src/core/SQL/SQLite/20/select_buffers_for_network.sql with 100% similarity]
src/core/SQL/SQLite/21/select_checkidentity.sql [moved from src/core/SQL/SQLite/20/select_checkidentity.sql with 100% similarity]
src/core/SQL/SQLite/21/select_connected_networks.sql [moved from src/core/SQL/SQLite/20/select_connected_networks.sql with 100% similarity]
src/core/SQL/SQLite/21/select_identities.sql [moved from src/core/SQL/SQLite/20/select_identities.sql with 100% similarity]
src/core/SQL/SQLite/21/select_internaluser.sql [moved from src/core/SQL/SQLite/20/select_internaluser.sql with 100% similarity]
src/core/SQL/SQLite/21/select_messages.sql [moved from src/core/SQL/SQLite/20/select_messages.sql with 100% similarity]
src/core/SQL/SQLite/21/select_messagesAll.sql [moved from src/core/SQL/SQLite/20/select_messagesAll.sql with 100% similarity]
src/core/SQL/SQLite/21/select_messagesAllNew.sql [moved from src/core/SQL/SQLite/20/select_messagesAllNew.sql with 100% similarity]
src/core/SQL/SQLite/21/select_messagesNewerThan.sql [moved from src/core/SQL/SQLite/20/select_messagesNewerThan.sql with 100% similarity]
src/core/SQL/SQLite/21/select_messagesNewestK.sql [moved from src/core/SQL/SQLite/20/select_messagesNewestK.sql with 100% similarity]
src/core/SQL/SQLite/21/select_networkExists.sql [moved from src/core/SQL/SQLite/20/select_networkExists.sql with 100% similarity]
src/core/SQL/SQLite/21/select_network_awaymsg.sql [moved from src/core/SQL/SQLite/20/select_network_awaymsg.sql with 100% similarity]
src/core/SQL/SQLite/21/select_network_usermode.sql [moved from src/core/SQL/SQLite/20/select_network_usermode.sql with 100% similarity]
src/core/SQL/SQLite/21/select_networks_for_user.sql [moved from src/core/SQL/SQLite/20/select_networks_for_user.sql with 100% similarity]
src/core/SQL/SQLite/21/select_nicks.sql [moved from src/core/SQL/SQLite/20/select_nicks.sql with 100% similarity]
src/core/SQL/SQLite/21/select_persistent_channels.sql [moved from src/core/SQL/SQLite/20/select_persistent_channels.sql with 100% similarity]
src/core/SQL/SQLite/21/select_servers_for_network.sql [moved from src/core/SQL/SQLite/20/select_servers_for_network.sql with 100% similarity]
src/core/SQL/SQLite/21/select_user_setting.sql [moved from src/core/SQL/SQLite/20/select_user_setting.sql with 100% similarity]
src/core/SQL/SQLite/21/select_userid.sql [moved from src/core/SQL/SQLite/20/select_userid.sql with 100% similarity]
src/core/SQL/SQLite/21/setup_000_quasseluser.sql [moved from src/core/SQL/SQLite/20/setup_000_quasseluser.sql with 100% similarity]
src/core/SQL/SQLite/21/setup_010_sender.sql [moved from src/core/SQL/SQLite/20/setup_010_sender.sql with 100% similarity]
src/core/SQL/SQLite/21/setup_020_network.sql [moved from src/core/SQL/SQLite/20/setup_020_network.sql with 100% similarity]
src/core/SQL/SQLite/21/setup_030_buffer.sql [moved from src/core/SQL/SQLite/20/setup_030_buffer.sql with 74% similarity]
src/core/SQL/SQLite/21/setup_040_buffer_idx.sql [moved from src/core/SQL/SQLite/20/setup_040_buffer_idx.sql with 100% similarity]
src/core/SQL/SQLite/21/setup_050_buffer_cname_idx.sql [moved from src/core/SQL/SQLite/20/setup_050_buffer_cname_idx.sql with 100% similarity]
src/core/SQL/SQLite/21/setup_060_backlog.sql [moved from src/core/SQL/SQLite/20/setup_060_backlog.sql with 100% similarity]
src/core/SQL/SQLite/21/setup_070_coreinfo.sql [moved from src/core/SQL/SQLite/20/setup_070_coreinfo.sql with 100% similarity]
src/core/SQL/SQLite/21/setup_080_ircservers.sql [moved from src/core/SQL/SQLite/20/setup_080_ircservers.sql with 100% similarity]
src/core/SQL/SQLite/21/setup_090_backlog_idx.sql [moved from src/core/SQL/SQLite/20/setup_090_backlog_idx.sql with 100% similarity]
src/core/SQL/SQLite/21/setup_100_backlog_idx2.sql [moved from src/core/SQL/SQLite/20/setup_100_backlog_idx2.sql with 100% similarity]
src/core/SQL/SQLite/21/setup_110_buffer_user_idx.sql [moved from src/core/SQL/SQLite/20/setup_110_buffer_user_idx.sql with 100% similarity]
src/core/SQL/SQLite/21/setup_120_user_setting.sql [moved from src/core/SQL/SQLite/20/setup_120_user_setting.sql with 100% similarity]
src/core/SQL/SQLite/21/setup_130_identity.sql [moved from src/core/SQL/SQLite/20/setup_130_identity.sql with 100% similarity]
src/core/SQL/SQLite/21/setup_140_identity_nick.sql [moved from src/core/SQL/SQLite/20/setup_140_identity_nick.sql with 100% similarity]
src/core/SQL/SQLite/21/update_backlog_bufferid.sql [moved from src/core/SQL/SQLite/20/update_backlog_bufferid.sql with 100% similarity]
src/core/SQL/SQLite/21/update_buffer_lastmsgid.sql [new file with mode: 0644]
src/core/SQL/SQLite/21/update_buffer_lastseen.sql [moved from src/core/SQL/SQLite/20/update_buffer_lastseen.sql with 51% similarity]
src/core/SQL/SQLite/21/update_buffer_markerlinemsgid.sql [moved from src/core/SQL/SQLite/20/update_buffer_markerlinemsgid.sql with 100% similarity]
src/core/SQL/SQLite/21/update_buffer_name.sql [moved from src/core/SQL/SQLite/20/update_buffer_name.sql with 100% similarity]
src/core/SQL/SQLite/21/update_buffer_persistent_channel.sql [moved from src/core/SQL/SQLite/20/update_buffer_persistent_channel.sql with 100% similarity]
src/core/SQL/SQLite/21/update_buffer_set_channel_key.sql [moved from src/core/SQL/SQLite/20/update_buffer_set_channel_key.sql with 100% similarity]
src/core/SQL/SQLite/21/update_identity.sql [moved from src/core/SQL/SQLite/20/update_identity.sql with 100% similarity]
src/core/SQL/SQLite/21/update_network.sql [moved from src/core/SQL/SQLite/20/update_network.sql with 100% similarity]
src/core/SQL/SQLite/21/update_network_connected.sql [moved from src/core/SQL/SQLite/20/update_network_connected.sql with 100% similarity]
src/core/SQL/SQLite/21/update_network_set_awaymsg.sql [moved from src/core/SQL/SQLite/20/update_network_set_awaymsg.sql with 100% similarity]
src/core/SQL/SQLite/21/update_network_set_usermode.sql [moved from src/core/SQL/SQLite/20/update_network_set_usermode.sql with 100% similarity]
src/core/SQL/SQLite/21/update_user_setting.sql [moved from src/core/SQL/SQLite/20/update_user_setting.sql with 100% similarity]
src/core/SQL/SQLite/21/update_username.sql [moved from src/core/SQL/SQLite/20/update_username.sql with 100% similarity]
src/core/SQL/SQLite/21/update_userpassword.sql [moved from src/core/SQL/SQLite/20/update_userpassword.sql with 100% similarity]
src/core/SQL/SQLite/21/upgrade_000_alter_buffer_add_lastmsgid.sql [new file with mode: 0644]
src/core/SQL/SQLite/21/upgrade_001_update_buffer_set_lastmsgid.sql [new file with mode: 0644]
src/core/SQL/SQLite/21/upgrade_002_update_buffer_fix_lastseenmsgid_over_lastmsgid.sql [new file with mode: 0644]
src/core/SQL/SQLite/21/upgrade_003_create_table_buffer_new.sql [new file with mode: 0644]
src/core/SQL/SQLite/21/upgrade_004_insert_into_buffer_new_from_buffer.sql [new file with mode: 0644]
src/core/SQL/SQLite/21/upgrade_005_drop_table_buffer.sql [new file with mode: 0644]
src/core/SQL/SQLite/21/upgrade_006_alter_table_buffer_new_rename_to_buffer.sql [new file with mode: 0644]
src/core/sql.qrc
src/core/sqlitestorage.cpp
src/core/sqlitestorage.h