X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2Fsql.qrc;h=0ac40d9e9ff2ed3e65ed6c814a3d7e76d1ab13eb;hp=da98f98326c7300a765bb3729e8d296e674ec236;hb=5e3bcda8c341dbe6846d4723afe7096acca8f304;hpb=52a7b4d0f289f075aa386445a47d876743bcb6d0 diff --git a/src/core/sql.qrc b/src/core/sql.qrc index da98f983..0ac40d9e 100644 --- a/src/core/sql.qrc +++ b/src/core/sql.qrc @@ -1,75 +1,107 @@ + ./SQL/PostgreSQL/15/upgrade_000_alter_buffer_add_markerlinemsgid.sql + ./SQL/PostgreSQL/16/upgrade_000_alter_network_add_sasl.sql + ./SQL/PostgreSQL/17/upgrade_000_alter_quasseluser_add_passwordversion.sql + ./SQL/PostgreSQL/18/upgrade_000_alter_ircserver_add_sslverify.sql + ./SQL/PostgreSQL/19/upgrade_000_alter_network_add_ratelimit_usecustom.sql + ./SQL/PostgreSQL/19/upgrade_001_alter_network_add_ratelimit_burstsize.sql + ./SQL/PostgreSQL/19/upgrade_002_alter_network_add_ratelimit_delay.sql + ./SQL/PostgreSQL/19/upgrade_003_alter_network_add_ratelimit_unlimited.sql + ./SQL/PostgreSQL/20/delete_backlog_by_uid.sql + ./SQL/PostgreSQL/20/delete_backlog_for_buffer.sql + ./SQL/PostgreSQL/20/delete_backlog_for_network.sql + ./SQL/PostgreSQL/20/delete_buffer_for_bufferid.sql + ./SQL/PostgreSQL/20/delete_buffers_by_uid.sql + ./SQL/PostgreSQL/20/delete_buffers_for_network.sql + ./SQL/PostgreSQL/20/delete_identity.sql + ./SQL/PostgreSQL/20/delete_ircservers_for_network.sql + ./SQL/PostgreSQL/20/delete_networks_by_uid.sql + ./SQL/PostgreSQL/20/delete_network.sql + ./SQL/PostgreSQL/20/delete_nicks.sql + ./SQL/PostgreSQL/20/delete_quasseluser.sql + ./SQL/PostgreSQL/20/insert_buffer.sql + ./SQL/PostgreSQL/20/insert_identity.sql + ./SQL/PostgreSQL/20/insert_message.sql + ./SQL/PostgreSQL/20/insert_network.sql + ./SQL/PostgreSQL/20/insert_nick.sql + ./SQL/PostgreSQL/20/insert_quasseluser.sql + ./SQL/PostgreSQL/20/insert_sender.sql + ./SQL/PostgreSQL/20/insert_server.sql + ./SQL/PostgreSQL/20/insert_user_setting.sql + ./SQL/PostgreSQL/20/migrate_write_backlog.sql + ./SQL/PostgreSQL/20/migrate_write_buffer.sql + ./SQL/PostgreSQL/20/migrate_write_identity_nick.sql + ./SQL/PostgreSQL/20/migrate_write_identity.sql + ./SQL/PostgreSQL/20/migrate_write_ircserver.sql + ./SQL/PostgreSQL/20/migrate_write_network.sql + ./SQL/PostgreSQL/20/migrate_write_quasseluser.sql + ./SQL/PostgreSQL/20/migrate_write_sender.sql + ./SQL/PostgreSQL/20/migrate_write_usersetting.sql + ./SQL/PostgreSQL/20/select_authuser.sql + ./SQL/PostgreSQL/20/select_buffer_by_id.sql + ./SQL/PostgreSQL/20/select_bufferByName.sql + ./SQL/PostgreSQL/20/select_bufferExists.sql + ./SQL/PostgreSQL/20/select_buffer_lastseen_messages.sql + ./SQL/PostgreSQL/20/select_buffer_markerlinemsgids.sql + ./SQL/PostgreSQL/20/select_buffers_for_network.sql + ./SQL/PostgreSQL/20/select_buffers.sql + ./SQL/PostgreSQL/20/select_checkidentity.sql + ./SQL/PostgreSQL/20/select_connected_networks.sql + ./SQL/PostgreSQL/20/select_identities.sql + ./SQL/PostgreSQL/20/select_internaluser.sql + ./SQL/PostgreSQL/20/select_messagesAllNew.sql + ./SQL/PostgreSQL/20/select_messagesAll.sql + ./SQL/PostgreSQL/20/select_messagesNewerThan.sql + ./SQL/PostgreSQL/20/select_messagesNewestK.sql + ./SQL/PostgreSQL/20/select_messagesRange.sql + ./SQL/PostgreSQL/20/select_network_awaymsg.sql + ./SQL/PostgreSQL/20/select_networkExists.sql + ./SQL/PostgreSQL/20/select_networks_for_user.sql + ./SQL/PostgreSQL/20/select_network_usermode.sql + ./SQL/PostgreSQL/20/select_nicks.sql + ./SQL/PostgreSQL/20/select_persistent_channels.sql + ./SQL/PostgreSQL/20/select_senderid.sql + ./SQL/PostgreSQL/20/select_servers_for_network.sql + ./SQL/PostgreSQL/20/select_userid.sql + ./SQL/PostgreSQL/20/select_user_setting.sql + ./SQL/PostgreSQL/20/setup_000_quasseluser.sql + ./SQL/PostgreSQL/20/setup_010_sender.sql + ./SQL/PostgreSQL/20/setup_020_identity.sql + ./SQL/PostgreSQL/20/setup_030_identity_nick.sql + ./SQL/PostgreSQL/20/setup_040_network.sql + ./SQL/PostgreSQL/20/setup_050_buffer.sql + ./SQL/PostgreSQL/20/setup_060_backlog.sql + ./SQL/PostgreSQL/20/setup_070_coreinfo.sql + ./SQL/PostgreSQL/20/setup_080_ircservers.sql + ./SQL/PostgreSQL/20/setup_090_backlog_idx.sql + ./SQL/PostgreSQL/20/setup_100_user_setting.sql + ./SQL/PostgreSQL/20/setup_110_alter_sender_seq.sql + ./SQL/PostgreSQL/20/setup_120_alter_messageid_seq.sql + ./SQL/PostgreSQL/20/setup_130_function_lastmsgid.sql + ./SQL/PostgreSQL/20/update_backlog_bufferid.sql + ./SQL/PostgreSQL/20/update_buffer_lastmsgid.sql + ./SQL/PostgreSQL/20/update_buffer_lastseen.sql + ./SQL/PostgreSQL/20/update_buffer_markerlinemsgid.sql + ./SQL/PostgreSQL/20/update_buffer_name.sql + ./SQL/PostgreSQL/20/update_buffer_persistent_channel.sql + ./SQL/PostgreSQL/20/update_buffer_set_channel_key.sql + ./SQL/PostgreSQL/20/update_identity.sql + ./SQL/PostgreSQL/20/update_network_connected.sql + ./SQL/PostgreSQL/20/update_network_set_awaymsg.sql + ./SQL/PostgreSQL/20/update_network_set_usermode.sql + ./SQL/PostgreSQL/20/update_network.sql + ./SQL/PostgreSQL/20/update_username.sql + ./SQL/PostgreSQL/20/update_userpassword.sql + ./SQL/PostgreSQL/20/update_user_setting.sql + ./SQL/PostgreSQL/20/upgrade_000_alter_buffer_add_lastmsgid.sql + ./SQL/PostgreSQL/20/upgrade_001_add_function_populate_lastmsgid.sql + ./SQL/PostgreSQL/20/upgrade_002_run_function_populate_lastmsgid.sql + ./SQL/PostgreSQL/20/upgrade_003_correct_bad_lastseenmsgid.sql + ./SQL/PostgreSQL/20/upgrade_004_add_lastseenmsgid_constraint.sql ./SQL/SQLite/1/upgrade_000_drop_coreinfo.sql ./SQL/SQLite/1/upgrade_010_create_coreinfo.sql ./SQL/SQLite/1/upgrade_020_update_schemaversion.sql - ./SQL/SQLite/10/upgrade_000_switch_to_msgid.sql - ./SQL/SQLite/10/upgrade_010_rename_buffer_table.sql - ./SQL/SQLite/10/upgrade_020_create_buffer_table.sql - ./SQL/SQLite/10/upgrade_030_copy_buffer_table.sql - ./SQL/SQLite/10/upgrade_040_drop_buffer_old_table.sql - ./SQL/SQLite/10/upgrade_999_version.sql - ./SQL/SQLite/11/delete_backlog_by_uid.sql - ./SQL/SQLite/11/delete_backlog_for_buffer.sql - ./SQL/SQLite/11/delete_backlog_for_network.sql - ./SQL/SQLite/11/delete_buffer_for_bufferid.sql - ./SQL/SQLite/11/delete_buffers_by_uid.sql - ./SQL/SQLite/11/delete_buffers_for_network.sql - ./SQL/SQLite/11/delete_ircservers_for_network.sql - ./SQL/SQLite/11/delete_network.sql - ./SQL/SQLite/11/delete_networks_by_uid.sql - ./SQL/SQLite/11/delete_quasseluser.sql - ./SQL/SQLite/11/insert_buffer.sql - ./SQL/SQLite/11/insert_message.sql - ./SQL/SQLite/11/insert_network.sql - ./SQL/SQLite/11/insert_quasseluser.sql - ./SQL/SQLite/11/insert_sender.sql - ./SQL/SQLite/11/insert_server.sql - ./SQL/SQLite/11/insert_user_setting.sql - ./SQL/SQLite/11/select_authuser.sql - ./SQL/SQLite/11/select_buffer_by_id.sql - ./SQL/SQLite/11/select_buffer_lastseen_messages.sql - ./SQL/SQLite/11/select_bufferByName.sql - ./SQL/SQLite/11/select_bufferExists.sql - ./SQL/SQLite/11/select_buffers.sql - ./SQL/SQLite/11/select_buffers_for_network.sql - ./SQL/SQLite/11/select_connected_networks.sql - ./SQL/SQLite/11/select_messageRange.sql - ./SQL/SQLite/11/select_messages.sql - ./SQL/SQLite/11/select_messagesOffset.sql - ./SQL/SQLite/11/select_messagesSince.sql - ./SQL/SQLite/11/select_messagesSinceOffset.sql - ./SQL/SQLite/11/select_networkExists.sql - ./SQL/SQLite/11/select_networks_for_user.sql - ./SQL/SQLite/11/select_persistent_channels.sql - ./SQL/SQLite/11/select_servers_for_network.sql - ./SQL/SQLite/11/select_user_setting.sql - ./SQL/SQLite/11/select_userid.sql - ./SQL/SQLite/11/setup_000_quasseluser.sql - ./SQL/SQLite/11/setup_010_sender.sql - ./SQL/SQLite/11/setup_020_network.sql - ./SQL/SQLite/11/setup_030_buffer.sql - ./SQL/SQLite/11/setup_040_buffer_idx.sql - ./SQL/SQLite/11/setup_050_buffer_cname_idx.sql - ./SQL/SQLite/11/setup_060_backlog.sql - ./SQL/SQLite/11/setup_070_coreinfo.sql - ./SQL/SQLite/11/setup_080_ircservers.sql - ./SQL/SQLite/11/setup_090_create_backlog_idx.sql - ./SQL/SQLite/11/setup_100_create_backlog_idx2.sql - ./SQL/SQLite/11/setup_110_create_buffer_idx.sql - ./SQL/SQLite/11/setup_120_create_user_setting.sql - ./SQL/SQLite/11/setup_999_version.sql - ./SQL/SQLite/11/update_buffer_lastseen.sql - ./SQL/SQLite/11/update_buffer_name.sql - ./SQL/SQLite/11/update_buffer_persistent_channel.sql - ./SQL/SQLite/11/update_buffer_set_channel_key.sql - ./SQL/SQLite/11/update_network.sql - ./SQL/SQLite/11/update_network_connected.sql - ./SQL/SQLite/11/update_user_setting.sql - ./SQL/SQLite/11/update_username.sql - ./SQL/SQLite/11/update_userpassword.sql - ./SQL/SQLite/11/upgrade_000_create_user_setting.sql - ./SQL/SQLite/11/upgrade_999_version.sql ./SQL/SQLite/2/upgrade_000_drop_buffergroup.sql ./SQL/SQLite/2/upgrade_010_update_schemaversion.sql ./SQL/SQLite/3/upgrade_000_update_backlog_flags.sql @@ -80,13 +112,11 @@ ./SQL/SQLite/4/upgrade_030_drop_oldbuffertable.sql ./SQL/SQLite/4/upgrade_040_create_buffer_idx.sql ./SQL/SQLite/4/upgrade_050_create_buffer_cname_idx.sql - ./SQL/SQLite/4/upgrade_999_update_schemaversion.sql ./SQL/SQLite/5/upgrade_000_rename_networktable.sql ./SQL/SQLite/5/upgrade_010_create_newnetworktable.sql ./SQL/SQLite/5/upgrade_020_copy_networktable.sql ./SQL/SQLite/5/upgrade_030_drop_oldnetworktable.sql ./SQL/SQLite/5/upgrade_180_create_ircservers.sql - ./SQL/SQLite/5/upgrade_999_update_schemaversion.sql ./SQL/SQLite/6/upgrade_000_alter_buffertable.sql ./SQL/SQLite/6/upgrade_010_set_statusbuffertype.sql ./SQL/SQLite/6/upgrade_020_set_channelbuffertype.sql @@ -104,21 +134,142 @@ ./SQL/SQLite/6/upgrade_140_update_msgtype.sql ./SQL/SQLite/6/upgrade_150_update_msgtype.sql ./SQL/SQLite/6/upgrade_160_update_msgtype.sql - ./SQL/SQLite/6/upgrade_999_version.sql ./SQL/SQLite/7/upgrade_000_rename_networktable.sql ./SQL/SQLite/7/upgrade_010_create_newnetworktable.sql ./SQL/SQLite/7/upgrade_020_copy_networktable.sql ./SQL/SQLite/7/upgrade_030_drop_oldnetworktable.sql ./SQL/SQLite/7/upgrade_040_alter_buffer_add_lastseen.sql - ./SQL/SQLite/7/upgrade_999_version.sql ./SQL/SQLite/8/upgrade_000_alter_network_add_connected.sql ./SQL/SQLite/8/upgrade_010_alter_buffer_add_key.sql ./SQL/SQLite/8/upgrade_020_alter_buffer_add_joined.sql ./SQL/SQLite/8/upgrade_030_update_buffer_set_joined_for_channels.sql - ./SQL/SQLite/8/upgrade_999_version.sql ./SQL/SQLite/9/upgrade_000_create_backlog_idx.sql ./SQL/SQLite/9/upgrade_010_create_backlog_idx2.sql ./SQL/SQLite/9/upgrade_020_create_buffer_idx.sql - ./SQL/SQLite/9/upgrade_999_version.sql + ./SQL/SQLite/10/upgrade_000_switch_to_msgid.sql + ./SQL/SQLite/10/upgrade_010_rename_buffer_table.sql + ./SQL/SQLite/10/upgrade_020_create_buffer_table.sql + ./SQL/SQLite/10/upgrade_030_copy_buffer_table.sql + ./SQL/SQLite/10/upgrade_040_drop_buffer_old_table.sql + ./SQL/SQLite/11/upgrade_000_create_user_setting.sql + ./SQL/SQLite/12/upgrade_000_create_identity.sql + ./SQL/SQLite/12/upgrade_010_create_identity_nick.sql + ./SQL/SQLite/12/upgrade_020_rename_servertable.sql + ./SQL/SQLite/12/upgrade_030_create_ircserver.sql + ./SQL/SQLite/12/upgrade_040_copy_ircserver.sql + ./SQL/SQLite/12/upgrade_050_drop_ircserverold.sql + ./SQL/SQLite/13/upgrade_000_create_buffer_user_idx.sql + ./SQL/SQLite/13/upgrade_010_create_buffer_cname_idx.sql + ./SQL/SQLite/13/upgrade_020_create_buffer_cname_idx.sql + ./SQL/SQLite/14/upgrade_000_rename_networktable.sql + ./SQL/SQLite/14/upgrade_010_create_networktable.sql + ./SQL/SQLite/14/upgrade_030_copy_networktable.sql + ./SQL/SQLite/14/upgrade_040_drop_networkold.sql + ./SQL/SQLite/15/upgrade_000_fix_ircservers.sql + ./SQL/SQLite/15/upgrade_000_fix_network.sql + ./SQL/SQLite/16/upgrade_000_alter_buffer_add_markerlinemsgid.sql + ./SQL/SQLite/17/upgrade_000_alter_network_add_sasl.sql + ./SQL/SQLite/17/upgrade_001_alter_network_add_sasl.sql + ./SQL/SQLite/17/upgrade_002_alter_network_add_sasl.sql + ./SQL/SQLite/18/upgrade_000_alter_quasseluser_add_passwordversion.sql + ./SQL/SQLite/19/upgrade_000_alter_ircserver_add_sslverify.sql + ./SQL/SQLite/20/upgrade_000_alter_network_add_ratelimit_usecustom.sql + ./SQL/SQLite/20/upgrade_001_alter_network_add_ratelimit_burstsize.sql + ./SQL/SQLite/20/upgrade_002_alter_network_add_ratelimit_delay.sql + ./SQL/SQLite/20/upgrade_003_alter_network_add_ratelimit_unlimited.sql + ./SQL/SQLite/21/delete_backlog_by_uid.sql + ./SQL/SQLite/21/delete_backlog_for_buffer.sql + ./SQL/SQLite/21/delete_backlog_for_network.sql + ./SQL/SQLite/21/delete_buffer_for_bufferid.sql + ./SQL/SQLite/21/delete_buffers_by_uid.sql + ./SQL/SQLite/21/delete_buffers_for_network.sql + ./SQL/SQLite/21/delete_identity.sql + ./SQL/SQLite/21/delete_ircservers_for_network.sql + ./SQL/SQLite/21/delete_networks_by_uid.sql + ./SQL/SQLite/21/delete_network.sql + ./SQL/SQLite/21/delete_nicks.sql + ./SQL/SQLite/21/delete_quasseluser.sql + ./SQL/SQLite/21/insert_buffer.sql + ./SQL/SQLite/21/insert_identity.sql + ./SQL/SQLite/21/insert_message.sql + ./SQL/SQLite/21/insert_network.sql + ./SQL/SQLite/21/insert_nick.sql + ./SQL/SQLite/21/insert_quasseluser.sql + ./SQL/SQLite/21/insert_sender.sql + ./SQL/SQLite/21/insert_server.sql + ./SQL/SQLite/21/insert_user_setting.sql + ./SQL/SQLite/21/migrate_read_backlog.sql + ./SQL/SQLite/21/migrate_read_buffer.sql + ./SQL/SQLite/21/migrate_read_identity_nick.sql + ./SQL/SQLite/21/migrate_read_identity.sql + ./SQL/SQLite/21/migrate_read_ircserver.sql + ./SQL/SQLite/21/migrate_read_network.sql + ./SQL/SQLite/21/migrate_read_quasseluser.sql + ./SQL/SQLite/21/migrate_read_sender.sql + ./SQL/SQLite/21/migrate_read_usersetting.sql + ./SQL/SQLite/21/select_authuser.sql + ./SQL/SQLite/21/select_buffer_by_id.sql + ./SQL/SQLite/21/select_bufferByName.sql + ./SQL/SQLite/21/select_bufferExists.sql + ./SQL/SQLite/21/select_buffer_lastseen_messages.sql + ./SQL/SQLite/21/select_buffer_markerlinemsgids.sql + ./SQL/SQLite/21/select_buffers_for_merge.sql + ./SQL/SQLite/21/select_buffers_for_network.sql + ./SQL/SQLite/21/select_buffers.sql + ./SQL/SQLite/21/select_checkidentity.sql + ./SQL/SQLite/21/select_connected_networks.sql + ./SQL/SQLite/21/select_identities.sql + ./SQL/SQLite/21/select_internaluser.sql + ./SQL/SQLite/21/select_messagesAllNew.sql + ./SQL/SQLite/21/select_messagesAll.sql + ./SQL/SQLite/21/select_messagesNewerThan.sql + ./SQL/SQLite/21/select_messagesNewestK.sql + ./SQL/SQLite/21/select_messagesRange.sql + ./SQL/SQLite/21/select_network_awaymsg.sql + ./SQL/SQLite/21/select_networkExists.sql + ./SQL/SQLite/21/select_networks_for_user.sql + ./SQL/SQLite/21/select_network_usermode.sql + ./SQL/SQLite/21/select_nicks.sql + ./SQL/SQLite/21/select_persistent_channels.sql + ./SQL/SQLite/21/select_servers_for_network.sql + ./SQL/SQLite/21/select_userid.sql + ./SQL/SQLite/21/select_user_setting.sql + ./SQL/SQLite/21/setup_000_quasseluser.sql + ./SQL/SQLite/21/setup_010_sender.sql + ./SQL/SQLite/21/setup_020_network.sql + ./SQL/SQLite/21/setup_030_buffer.sql + ./SQL/SQLite/21/setup_040_buffer_idx.sql + ./SQL/SQLite/21/setup_050_buffer_cname_idx.sql + ./SQL/SQLite/21/setup_060_backlog.sql + ./SQL/SQLite/21/setup_070_coreinfo.sql + ./SQL/SQLite/21/setup_080_ircservers.sql + ./SQL/SQLite/21/setup_090_backlog_idx.sql + ./SQL/SQLite/21/setup_100_backlog_idx2.sql + ./SQL/SQLite/21/setup_110_buffer_user_idx.sql + ./SQL/SQLite/21/setup_120_user_setting.sql + ./SQL/SQLite/21/setup_130_identity.sql + ./SQL/SQLite/21/setup_140_identity_nick.sql + ./SQL/SQLite/21/update_backlog_bufferid.sql + ./SQL/SQLite/21/update_buffer_lastmsgid.sql + ./SQL/SQLite/21/update_buffer_lastseen.sql + ./SQL/SQLite/21/update_buffer_markerlinemsgid.sql + ./SQL/SQLite/21/update_buffer_name.sql + ./SQL/SQLite/21/update_buffer_persistent_channel.sql + ./SQL/SQLite/21/update_buffer_set_channel_key.sql + ./SQL/SQLite/21/update_identity.sql + ./SQL/SQLite/21/update_network_connected.sql + ./SQL/SQLite/21/update_network_set_awaymsg.sql + ./SQL/SQLite/21/update_network_set_usermode.sql + ./SQL/SQLite/21/update_network.sql + ./SQL/SQLite/21/update_username.sql + ./SQL/SQLite/21/update_userpassword.sql + ./SQL/SQLite/21/update_user_setting.sql + ./SQL/SQLite/21/upgrade_000_alter_buffer_add_lastmsgid.sql + ./SQL/SQLite/21/upgrade_001_update_buffer_set_lastmsgid.sql + ./SQL/SQLite/21/upgrade_002_update_buffer_fix_lastseenmsgid_over_lastmsgid.sql + ./SQL/SQLite/21/upgrade_003_create_table_buffer_new.sql + ./SQL/SQLite/21/upgrade_004_insert_into_buffer_new_from_buffer.sql + ./SQL/SQLite/21/upgrade_005_drop_table_buffer.sql + ./SQL/SQLite/21/upgrade_006_alter_table_buffer_new_rename_to_buffer.sql