X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2Fsql.qrc;h=a6f3b3e9b18801b995199281fa295a9452c854b0;hp=7b75c7e2a4c3098a9759c43c002d9d3eac0b6144;hb=8f976cfdc7090cf4a752dab08126cc6107aa9626;hpb=6a7da771f7cecc994564434097e2bd9dba68627e diff --git a/src/core/sql.qrc b/src/core/sql.qrc index 7b75c7e2..a6f3b3e9 100644 --- a/src/core/sql.qrc +++ b/src/core/sql.qrc @@ -1,48 +1,295 @@ - ./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/2/upgrade_000_drop_buffergroup.sql - ./SQL/SQLite/2/upgrade_010_update_schemaversion.sql - ./SQL/SQLite/3/upgrade_000_update_backlog_flags.sql - ./SQL/SQLite/3/upgrade_010_update_schemaversion.sql - ./SQL/SQLite/4/delete_backlog_by_uid.sql - ./SQL/SQLite/4/delete_buffers_by_uid.sql - ./SQL/SQLite/4/delete_networks_by_uid.sql - ./SQL/SQLite/4/delete_quasseluser.sql - ./SQL/SQLite/4/insert_buffer.sql - ./SQL/SQLite/4/insert_message.sql - ./SQL/SQLite/4/insert_network.sql - ./SQL/SQLite/4/insert_quasseluser.sql - ./SQL/SQLite/4/insert_sender.sql - ./SQL/SQLite/4/select_authuser.sql - ./SQL/SQLite/4/select_bufferByName.sql - ./SQL/SQLite/4/select_buffers.sql - ./SQL/SQLite/4/select_lastMessage.sql - ./SQL/SQLite/4/select_messageRange.sql - ./SQL/SQLite/4/select_messages.sql - ./SQL/SQLite/4/select_messagesOffset.sql - ./SQL/SQLite/4/select_messagesSince.sql - ./SQL/SQLite/4/select_messagesSinceOffset.sql - ./SQL/SQLite/4/select_userid.sql - ./SQL/SQLite/4/setup_000_quasseluser.sql - ./SQL/SQLite/4/setup_010_sender.sql - ./SQL/SQLite/4/setup_020_network.sql - ./SQL/SQLite/4/setup_030_buffer.sql - ./SQL/SQLite/4/setup_040_buffer_idx.sql - ./SQL/SQLite/4/setup_050_buffer_cname_idx.sql - ./SQL/SQLite/4/setup_060_backlog.sql - ./SQL/SQLite/4/setup_070_coreinfo.sql - ./SQL/SQLite/4/setup_080_version.sql - ./SQL/SQLite/4/update_username.sql - ./SQL/SQLite/4/update_userpassword.sql - ./SQL/SQLite/4/upgrade_000_rename_buffertable.sql - ./SQL/SQLite/4/upgrade_010_create_buffertable.sql - ./SQL/SQLite/4/upgrade_020_copy_buffertable.sql - ./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/PostgreSQL/delete_backlog_by_uid.sql + ./SQL/PostgreSQL/delete_backlog_for_buffer.sql + ./SQL/PostgreSQL/delete_backlog_for_network.sql + ./SQL/PostgreSQL/delete_buffer_for_bufferid.sql + ./SQL/PostgreSQL/delete_buffers_by_uid.sql + ./SQL/PostgreSQL/delete_buffers_for_network.sql + ./SQL/PostgreSQL/delete_identity.sql + ./SQL/PostgreSQL/delete_ircservers_for_network.sql + ./SQL/PostgreSQL/delete_network.sql + ./SQL/PostgreSQL/delete_networks_by_uid.sql + ./SQL/PostgreSQL/delete_nicks.sql + ./SQL/PostgreSQL/delete_quasseluser.sql + ./SQL/PostgreSQL/insert_buffer.sql + ./SQL/PostgreSQL/insert_identity.sql + ./SQL/PostgreSQL/insert_message.sql + ./SQL/PostgreSQL/insert_network.sql + ./SQL/PostgreSQL/insert_nick.sql + ./SQL/PostgreSQL/insert_quasseluser.sql + ./SQL/PostgreSQL/insert_sender.sql + ./SQL/PostgreSQL/insert_server.sql + ./SQL/PostgreSQL/insert_user_setting.sql + ./SQL/PostgreSQL/migrate_write_backlog.sql + ./SQL/PostgreSQL/migrate_write_buffer.sql + ./SQL/PostgreSQL/migrate_write_identity.sql + ./SQL/PostgreSQL/migrate_write_identity_nick.sql + ./SQL/PostgreSQL/migrate_write_ircserver.sql + ./SQL/PostgreSQL/migrate_write_network.sql + ./SQL/PostgreSQL/migrate_write_quasseluser.sql + ./SQL/PostgreSQL/migrate_write_sender.sql + ./SQL/PostgreSQL/migrate_write_usersetting.sql + ./SQL/PostgreSQL/select_authenticator.sql + ./SQL/PostgreSQL/select_authuser.sql + ./SQL/PostgreSQL/select_bufferByName.sql + ./SQL/PostgreSQL/select_bufferExists.sql + ./SQL/PostgreSQL/select_buffer_bufferactivities.sql + ./SQL/PostgreSQL/select_buffer_bufferactivity.sql + ./SQL/PostgreSQL/select_buffer_by_id.sql + ./SQL/PostgreSQL/select_buffer_lastseen_messages.sql + ./SQL/PostgreSQL/select_buffer_markerlinemsgids.sql + ./SQL/PostgreSQL/select_buffers.sql + ./SQL/PostgreSQL/select_buffers_for_network.sql + ./SQL/PostgreSQL/select_checkidentity.sql + ./SQL/PostgreSQL/select_connected_networks.sql + ./SQL/PostgreSQL/select_identities.sql + ./SQL/PostgreSQL/select_internaluser.sql + ./SQL/PostgreSQL/select_messagesAll.sql + ./SQL/PostgreSQL/select_messagesAllNew.sql + ./SQL/PostgreSQL/select_messagesNewerThan.sql + ./SQL/PostgreSQL/select_messagesNewestK.sql + ./SQL/PostgreSQL/select_messagesRange.sql + ./SQL/PostgreSQL/select_networkExists.sql + ./SQL/PostgreSQL/select_network_awaymsg.sql + ./SQL/PostgreSQL/select_network_usermode.sql + ./SQL/PostgreSQL/select_networks_for_user.sql + ./SQL/PostgreSQL/select_nicks.sql + ./SQL/PostgreSQL/select_persistent_channels.sql + ./SQL/PostgreSQL/select_senderid.sql + ./SQL/PostgreSQL/select_servers_for_network.sql + ./SQL/PostgreSQL/select_user_setting.sql + ./SQL/PostgreSQL/select_userid.sql + ./SQL/PostgreSQL/setup_000_quasseluser.sql + ./SQL/PostgreSQL/setup_010_sender.sql + ./SQL/PostgreSQL/setup_020_identity.sql + ./SQL/PostgreSQL/setup_030_identity_nick.sql + ./SQL/PostgreSQL/setup_040_network.sql + ./SQL/PostgreSQL/setup_050_buffer.sql + ./SQL/PostgreSQL/setup_060_backlog.sql + ./SQL/PostgreSQL/setup_061_add_function_backlog_lastmsgid_update.sql + ./SQL/PostgreSQL/setup_062_add_trigger_backlog_lastmsgid_update.sql + ./SQL/PostgreSQL/setup_070_coreinfo.sql + ./SQL/PostgreSQL/setup_080_ircservers.sql + ./SQL/PostgreSQL/setup_090_backlog_idx.sql + ./SQL/PostgreSQL/setup_100_user_setting.sql + ./SQL/PostgreSQL/setup_110_alter_sender_seq.sql + ./SQL/PostgreSQL/setup_120_alter_messageid_seq.sql + ./SQL/PostgreSQL/setup_130_function_lastmsgid.sql + ./SQL/PostgreSQL/update_backlog_bufferid.sql + ./SQL/PostgreSQL/update_buffer_bufferactivity.sql + ./SQL/PostgreSQL/update_buffer_lastseen.sql + ./SQL/PostgreSQL/update_buffer_markerlinemsgid.sql + ./SQL/PostgreSQL/update_buffer_name.sql + ./SQL/PostgreSQL/update_buffer_persistent_channel.sql + ./SQL/PostgreSQL/update_buffer_set_channel_key.sql + ./SQL/PostgreSQL/update_identity.sql + ./SQL/PostgreSQL/update_network.sql + ./SQL/PostgreSQL/update_network_connected.sql + ./SQL/PostgreSQL/update_network_set_awaymsg.sql + ./SQL/PostgreSQL/update_network_set_usermode.sql + ./SQL/PostgreSQL/update_user_setting.sql + ./SQL/PostgreSQL/update_username.sql + ./SQL/PostgreSQL/update_userpassword.sql + ./SQL/PostgreSQL/version/15/upgrade_000_alter_buffer_add_markerlinemsgid.sql + ./SQL/PostgreSQL/version/16/upgrade_000_alter_network_add_sasl.sql + ./SQL/PostgreSQL/version/17/upgrade_000_alter_quasseluser_add_passwordversion.sql + ./SQL/PostgreSQL/version/18/upgrade_000_alter_ircserver_add_sslverify.sql + ./SQL/PostgreSQL/version/19/upgrade_000_alter_network_add_ratelimit_usecustom.sql + ./SQL/PostgreSQL/version/19/upgrade_001_alter_network_add_ratelimit_burstsize.sql + ./SQL/PostgreSQL/version/19/upgrade_002_alter_network_add_ratelimit_delay.sql + ./SQL/PostgreSQL/version/19/upgrade_003_alter_network_add_ratelimit_unlimited.sql + ./SQL/PostgreSQL/version/20/upgrade_000_alter_buffer_add_lastmsgid.sql + ./SQL/PostgreSQL/version/20/upgrade_001_add_function_populate_lastmsgid.sql + ./SQL/PostgreSQL/version/20/upgrade_002_run_function_populate_lastmsgid.sql + ./SQL/PostgreSQL/version/20/upgrade_003_correct_bad_lastseenmsgid.sql + ./SQL/PostgreSQL/version/20/upgrade_004_add_lastseenmsgid_constraint.sql + ./SQL/PostgreSQL/version/21/upgrade_000_add_function_backlog_lastmsgid_update.sql + ./SQL/PostgreSQL/version/21/upgrade_001_add_trigger_backlog_lastmsgid_update.sql + ./SQL/PostgreSQL/version/22/upgrade_000_alter_quasseluser_add_authenticator.sql + ./SQL/PostgreSQL/version/23/upgrade_000_create_senderprefixes.sql + ./SQL/PostgreSQL/version/24/upgrade_000_alter_buffer_add_bufferactivity.sql + ./SQL/SQLite/delete_backlog_by_uid.sql + ./SQL/SQLite/delete_backlog_for_buffer.sql + ./SQL/SQLite/delete_backlog_for_network.sql + ./SQL/SQLite/delete_buffer_for_bufferid.sql + ./SQL/SQLite/delete_buffers_by_uid.sql + ./SQL/SQLite/delete_buffers_for_network.sql + ./SQL/SQLite/delete_identity.sql + ./SQL/SQLite/delete_ircservers_for_network.sql + ./SQL/SQLite/delete_network.sql + ./SQL/SQLite/delete_networks_by_uid.sql + ./SQL/SQLite/delete_nicks.sql + ./SQL/SQLite/delete_quasseluser.sql + ./SQL/SQLite/insert_buffer.sql + ./SQL/SQLite/insert_identity.sql + ./SQL/SQLite/insert_message.sql + ./SQL/SQLite/insert_network.sql + ./SQL/SQLite/insert_nick.sql + ./SQL/SQLite/insert_quasseluser.sql + ./SQL/SQLite/insert_sender.sql + ./SQL/SQLite/insert_server.sql + ./SQL/SQLite/insert_user_setting.sql + ./SQL/SQLite/migrate_read_backlog.sql + ./SQL/SQLite/migrate_read_buffer.sql + ./SQL/SQLite/migrate_read_identity.sql + ./SQL/SQLite/migrate_read_identity_nick.sql + ./SQL/SQLite/migrate_read_ircserver.sql + ./SQL/SQLite/migrate_read_network.sql + ./SQL/SQLite/migrate_read_quasseluser.sql + ./SQL/SQLite/migrate_read_sender.sql + ./SQL/SQLite/migrate_read_usersetting.sql + ./SQL/SQLite/select_authenticator.sql + ./SQL/SQLite/select_authuser.sql + ./SQL/SQLite/select_bufferByName.sql + ./SQL/SQLite/select_bufferExists.sql + ./SQL/SQLite/select_buffer_bufferactivities.sql + ./SQL/SQLite/select_buffer_bufferactivity.sql + ./SQL/SQLite/select_buffer_by_id.sql + ./SQL/SQLite/select_buffer_lastseen_messages.sql + ./SQL/SQLite/select_buffer_markerlinemsgids.sql + ./SQL/SQLite/select_buffers.sql + ./SQL/SQLite/select_buffers_for_merge.sql + ./SQL/SQLite/select_buffers_for_network.sql + ./SQL/SQLite/select_checkidentity.sql + ./SQL/SQLite/select_connected_networks.sql + ./SQL/SQLite/select_identities.sql + ./SQL/SQLite/select_internaluser.sql + ./SQL/SQLite/select_messagesAll.sql + ./SQL/SQLite/select_messagesAllNew.sql + ./SQL/SQLite/select_messagesNewerThan.sql + ./SQL/SQLite/select_messagesNewestK.sql + ./SQL/SQLite/select_messagesRange.sql + ./SQL/SQLite/select_networkExists.sql + ./SQL/SQLite/select_network_awaymsg.sql + ./SQL/SQLite/select_network_usermode.sql + ./SQL/SQLite/select_networks_for_user.sql + ./SQL/SQLite/select_nicks.sql + ./SQL/SQLite/select_persistent_channels.sql + ./SQL/SQLite/select_servers_for_network.sql + ./SQL/SQLite/select_user_setting.sql + ./SQL/SQLite/select_userid.sql + ./SQL/SQLite/setup_000_quasseluser.sql + ./SQL/SQLite/setup_010_sender.sql + ./SQL/SQLite/setup_020_network.sql + ./SQL/SQLite/setup_030_buffer.sql + ./SQL/SQLite/setup_040_buffer_idx.sql + ./SQL/SQLite/setup_050_buffer_cname_idx.sql + ./SQL/SQLite/setup_060_backlog.sql + ./SQL/SQLite/setup_061_add_trigger_backlog_lastmsgid_update_direct_insert.sql + ./SQL/SQLite/setup_062_add_trigger_backlog_lastmsgid_update_direct_update.sql + ./SQL/SQLite/setup_070_coreinfo.sql + ./SQL/SQLite/setup_080_ircservers.sql + ./SQL/SQLite/setup_090_backlog_idx.sql + ./SQL/SQLite/setup_100_backlog_idx2.sql + ./SQL/SQLite/setup_110_buffer_user_idx.sql + ./SQL/SQLite/setup_120_user_setting.sql + ./SQL/SQLite/setup_130_identity.sql + ./SQL/SQLite/setup_140_identity_nick.sql + ./SQL/SQLite/update_backlog_bufferid.sql + ./SQL/SQLite/update_buffer_bufferactivity.sql + ./SQL/SQLite/update_buffer_lastseen.sql + ./SQL/SQLite/update_buffer_markerlinemsgid.sql + ./SQL/SQLite/update_buffer_name.sql + ./SQL/SQLite/update_buffer_persistent_channel.sql + ./SQL/SQLite/update_buffer_set_channel_key.sql + ./SQL/SQLite/update_identity.sql + ./SQL/SQLite/update_network.sql + ./SQL/SQLite/update_network_connected.sql + ./SQL/SQLite/update_network_set_awaymsg.sql + ./SQL/SQLite/update_network_set_usermode.sql + ./SQL/SQLite/update_user_setting.sql + ./SQL/SQLite/update_username.sql + ./SQL/SQLite/update_userpassword.sql + ./SQL/SQLite/version/1/upgrade_000_drop_coreinfo.sql + ./SQL/SQLite/version/1/upgrade_010_create_coreinfo.sql + ./SQL/SQLite/version/1/upgrade_020_update_schemaversion.sql + ./SQL/SQLite/version/2/upgrade_000_drop_buffergroup.sql + ./SQL/SQLite/version/2/upgrade_010_update_schemaversion.sql + ./SQL/SQLite/version/3/upgrade_000_update_backlog_flags.sql + ./SQL/SQLite/version/3/upgrade_010_update_schemaversion.sql + ./SQL/SQLite/version/4/upgrade_000_rename_buffertable.sql + ./SQL/SQLite/version/4/upgrade_010_create_buffertable.sql + ./SQL/SQLite/version/4/upgrade_020_copy_buffertable.sql + ./SQL/SQLite/version/4/upgrade_030_drop_oldbuffertable.sql + ./SQL/SQLite/version/4/upgrade_040_create_buffer_idx.sql + ./SQL/SQLite/version/4/upgrade_050_create_buffer_cname_idx.sql + ./SQL/SQLite/version/5/upgrade_000_rename_networktable.sql + ./SQL/SQLite/version/5/upgrade_010_create_newnetworktable.sql + ./SQL/SQLite/version/5/upgrade_020_copy_networktable.sql + ./SQL/SQLite/version/5/upgrade_030_drop_oldnetworktable.sql + ./SQL/SQLite/version/5/upgrade_180_create_ircservers.sql + ./SQL/SQLite/version/6/upgrade_000_alter_buffertable.sql + ./SQL/SQLite/version/6/upgrade_010_set_statusbuffertype.sql + ./SQL/SQLite/version/6/upgrade_020_set_channelbuffertype.sql + ./SQL/SQLite/version/6/upgrade_030_set_querybuffertype.sql + ./SQL/SQLite/version/6/upgrade_040_update_msgtype.sql + ./SQL/SQLite/version/6/upgrade_050_update_msgtype.sql + ./SQL/SQLite/version/6/upgrade_060_update_msgtype.sql + ./SQL/SQLite/version/6/upgrade_070_update_msgtype.sql + ./SQL/SQLite/version/6/upgrade_080_update_msgtype.sql + ./SQL/SQLite/version/6/upgrade_090_update_msgtype.sql + ./SQL/SQLite/version/6/upgrade_100_update_msgtype.sql + ./SQL/SQLite/version/6/upgrade_110_update_msgtype.sql + ./SQL/SQLite/version/6/upgrade_120_update_msgtype.sql + ./SQL/SQLite/version/6/upgrade_130_update_msgtype.sql + ./SQL/SQLite/version/6/upgrade_140_update_msgtype.sql + ./SQL/SQLite/version/6/upgrade_150_update_msgtype.sql + ./SQL/SQLite/version/6/upgrade_160_update_msgtype.sql + ./SQL/SQLite/version/7/upgrade_000_rename_networktable.sql + ./SQL/SQLite/version/7/upgrade_010_create_newnetworktable.sql + ./SQL/SQLite/version/7/upgrade_020_copy_networktable.sql + ./SQL/SQLite/version/7/upgrade_030_drop_oldnetworktable.sql + ./SQL/SQLite/version/7/upgrade_040_alter_buffer_add_lastseen.sql + ./SQL/SQLite/version/8/upgrade_000_alter_network_add_connected.sql + ./SQL/SQLite/version/8/upgrade_010_alter_buffer_add_key.sql + ./SQL/SQLite/version/8/upgrade_020_alter_buffer_add_joined.sql + ./SQL/SQLite/version/8/upgrade_030_update_buffer_set_joined_for_channels.sql + ./SQL/SQLite/version/9/upgrade_000_create_backlog_idx.sql + ./SQL/SQLite/version/9/upgrade_010_create_backlog_idx2.sql + ./SQL/SQLite/version/9/upgrade_020_create_buffer_idx.sql + ./SQL/SQLite/version/10/upgrade_000_switch_to_msgid.sql + ./SQL/SQLite/version/10/upgrade_010_rename_buffer_table.sql + ./SQL/SQLite/version/10/upgrade_020_create_buffer_table.sql + ./SQL/SQLite/version/10/upgrade_030_copy_buffer_table.sql + ./SQL/SQLite/version/10/upgrade_040_drop_buffer_old_table.sql + ./SQL/SQLite/version/11/upgrade_000_create_user_setting.sql + ./SQL/SQLite/version/12/upgrade_000_create_identity.sql + ./SQL/SQLite/version/12/upgrade_010_create_identity_nick.sql + ./SQL/SQLite/version/12/upgrade_020_rename_servertable.sql + ./SQL/SQLite/version/12/upgrade_030_create_ircserver.sql + ./SQL/SQLite/version/12/upgrade_040_copy_ircserver.sql + ./SQL/SQLite/version/12/upgrade_050_drop_ircserverold.sql + ./SQL/SQLite/version/13/upgrade_000_create_buffer_user_idx.sql + ./SQL/SQLite/version/13/upgrade_010_create_buffer_cname_idx.sql + ./SQL/SQLite/version/13/upgrade_020_create_buffer_cname_idx.sql + ./SQL/SQLite/version/14/upgrade_000_rename_networktable.sql + ./SQL/SQLite/version/14/upgrade_010_create_networktable.sql + ./SQL/SQLite/version/14/upgrade_030_copy_networktable.sql + ./SQL/SQLite/version/14/upgrade_040_drop_networkold.sql + ./SQL/SQLite/version/15/upgrade_000_fix_ircservers.sql + ./SQL/SQLite/version/15/upgrade_000_fix_network.sql + ./SQL/SQLite/version/16/upgrade_000_alter_buffer_add_markerlinemsgid.sql + ./SQL/SQLite/version/17/upgrade_000_alter_network_add_sasl.sql + ./SQL/SQLite/version/17/upgrade_001_alter_network_add_sasl.sql + ./SQL/SQLite/version/17/upgrade_002_alter_network_add_sasl.sql + ./SQL/SQLite/version/18/upgrade_000_alter_quasseluser_add_passwordversion.sql + ./SQL/SQLite/version/19/upgrade_000_alter_ircserver_add_sslverify.sql + ./SQL/SQLite/version/20/upgrade_000_alter_network_add_ratelimit_usecustom.sql + ./SQL/SQLite/version/20/upgrade_001_alter_network_add_ratelimit_burstsize.sql + ./SQL/SQLite/version/20/upgrade_002_alter_network_add_ratelimit_delay.sql + ./SQL/SQLite/version/20/upgrade_003_alter_network_add_ratelimit_unlimited.sql + ./SQL/SQLite/version/21/upgrade_000_alter_buffer_add_lastmsgid.sql + ./SQL/SQLite/version/21/upgrade_001_update_buffer_set_lastmsgid.sql + ./SQL/SQLite/version/21/upgrade_002_update_buffer_fix_lastseenmsgid_over_lastmsgid.sql + ./SQL/SQLite/version/21/upgrade_003_create_table_buffer_new.sql + ./SQL/SQLite/version/21/upgrade_004_insert_into_buffer_new_from_buffer.sql + ./SQL/SQLite/version/21/upgrade_005_drop_table_buffer.sql + ./SQL/SQLite/version/21/upgrade_006_alter_table_buffer_new_rename_to_buffer.sql + ./SQL/SQLite/version/22/upgrade_000_add_trigger_backlog_lastmsgid_update_direct_insert.sql + ./SQL/SQLite/version/22/upgrade_001_add_trigger_backlog_lastmsgid_update_direct_update.sql + ./SQL/SQLite/version/23/upgrade_000_alter_quasseluser_add_authenticator.sql + ./SQL/SQLite/version/24/upgrade_000_create_senderprefixes.sql + ./SQL/SQLite/version/25/upgrade_000_alter_buffer_add_bufferactivity.sql