X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2Fsql.qrc;h=fce069256ff7907c6c869dea17b844455e41a20b;hp=e3459e14600dddfa981a467f07407b5cef84f463;hb=4ae8f86c1ce452582d6fe576956c7c1bc1460adf;hpb=4c83963b1d77f4c2dbae606876be0eee59f53dae diff --git a/src/core/sql.qrc b/src/core/sql.qrc index e3459e14..fce06925 100644 --- a/src/core/sql.qrc +++ b/src/core/sql.qrc @@ -1,5 +1,91 @@ + ./SQL/PostgreSQL/15/upgrade_000_alter_buffer_add_markerlinemsgid.sql + ./SQL/PostgreSQL/16/delete_backlog_by_uid.sql + ./SQL/PostgreSQL/16/delete_backlog_for_buffer.sql + ./SQL/PostgreSQL/16/delete_backlog_for_network.sql + ./SQL/PostgreSQL/16/delete_buffer_for_bufferid.sql + ./SQL/PostgreSQL/16/delete_buffers_by_uid.sql + ./SQL/PostgreSQL/16/delete_buffers_for_network.sql + ./SQL/PostgreSQL/16/delete_identity.sql + ./SQL/PostgreSQL/16/delete_ircservers_for_network.sql + ./SQL/PostgreSQL/16/delete_network.sql + ./SQL/PostgreSQL/16/delete_networks_by_uid.sql + ./SQL/PostgreSQL/16/delete_nicks.sql + ./SQL/PostgreSQL/16/delete_quasseluser.sql + ./SQL/PostgreSQL/16/insert_buffer.sql + ./SQL/PostgreSQL/16/insert_identity.sql + ./SQL/PostgreSQL/16/insert_message.sql + ./SQL/PostgreSQL/16/insert_network.sql + ./SQL/PostgreSQL/16/insert_nick.sql + ./SQL/PostgreSQL/16/insert_quasseluser.sql + ./SQL/PostgreSQL/16/insert_sender.sql + ./SQL/PostgreSQL/16/insert_server.sql + ./SQL/PostgreSQL/16/insert_user_setting.sql + ./SQL/PostgreSQL/16/migrate_write_backlog.sql + ./SQL/PostgreSQL/16/migrate_write_buffer.sql + ./SQL/PostgreSQL/16/migrate_write_identity.sql + ./SQL/PostgreSQL/16/migrate_write_identity_nick.sql + ./SQL/PostgreSQL/16/migrate_write_ircserver.sql + ./SQL/PostgreSQL/16/migrate_write_network.sql + ./SQL/PostgreSQL/16/migrate_write_quasseluser.sql + ./SQL/PostgreSQL/16/migrate_write_sender.sql + ./SQL/PostgreSQL/16/migrate_write_usersetting.sql + ./SQL/PostgreSQL/16/select_authuser.sql + ./SQL/PostgreSQL/16/select_buffer_by_id.sql + ./SQL/PostgreSQL/16/select_buffer_lastseen_messages.sql + ./SQL/PostgreSQL/16/select_buffer_markerlinemsgids.sql + ./SQL/PostgreSQL/16/select_bufferByName.sql + ./SQL/PostgreSQL/16/select_bufferExists.sql + ./SQL/PostgreSQL/16/select_buffers.sql + ./SQL/PostgreSQL/16/select_buffers_for_network.sql + ./SQL/PostgreSQL/16/select_checkidentity.sql + ./SQL/PostgreSQL/16/select_connected_networks.sql + ./SQL/PostgreSQL/16/select_identities.sql + ./SQL/PostgreSQL/16/select_internaluser.sql + ./SQL/PostgreSQL/16/select_messages.sql + ./SQL/PostgreSQL/16/select_messagesAll.sql + ./SQL/PostgreSQL/16/select_messagesAllNew.sql + ./SQL/PostgreSQL/16/select_messagesNewerThan.sql + ./SQL/PostgreSQL/16/select_messagesRange.sql + ./SQL/PostgreSQL/16/select_network_awaymsg.sql + ./SQL/PostgreSQL/16/select_network_usermode.sql + ./SQL/PostgreSQL/16/select_networkExists.sql + ./SQL/PostgreSQL/16/select_networks_for_user.sql + ./SQL/PostgreSQL/16/select_nicks.sql + ./SQL/PostgreSQL/16/select_persistent_channels.sql + ./SQL/PostgreSQL/16/select_senderid.sql + ./SQL/PostgreSQL/16/select_servers_for_network.sql + ./SQL/PostgreSQL/16/select_user_setting.sql + ./SQL/PostgreSQL/16/select_userid.sql + ./SQL/PostgreSQL/16/setup_000_quasseluser.sql + ./SQL/PostgreSQL/16/setup_010_sender.sql + ./SQL/PostgreSQL/16/setup_020_identity.sql + ./SQL/PostgreSQL/16/setup_030_identity_nick.sql + ./SQL/PostgreSQL/16/setup_040_network.sql + ./SQL/PostgreSQL/16/setup_050_buffer.sql + ./SQL/PostgreSQL/16/setup_060_backlog.sql + ./SQL/PostgreSQL/16/setup_070_coreinfo.sql + ./SQL/PostgreSQL/16/setup_080_ircservers.sql + ./SQL/PostgreSQL/16/setup_090_backlog_idx.sql + ./SQL/PostgreSQL/16/setup_100_user_setting.sql + ./SQL/PostgreSQL/16/setup_110_alter_sender_seq.sql + ./SQL/PostgreSQL/16/setup_120_alter_messageid_seq.sql + ./SQL/PostgreSQL/16/update_backlog_bufferid.sql + ./SQL/PostgreSQL/16/update_buffer_lastseen.sql + ./SQL/PostgreSQL/16/update_buffer_markerlinemsgid.sql + ./SQL/PostgreSQL/16/update_buffer_name.sql + ./SQL/PostgreSQL/16/update_buffer_persistent_channel.sql + ./SQL/PostgreSQL/16/update_buffer_set_channel_key.sql + ./SQL/PostgreSQL/16/update_identity.sql + ./SQL/PostgreSQL/16/update_network.sql + ./SQL/PostgreSQL/16/update_network_connected.sql + ./SQL/PostgreSQL/16/update_network_set_awaymsg.sql + ./SQL/PostgreSQL/16/update_network_set_usermode.sql + ./SQL/PostgreSQL/16/update_user_setting.sql + ./SQL/PostgreSQL/16/update_username.sql + ./SQL/PostgreSQL/16/update_userpassword.sql + ./SQL/PostgreSQL/16/upgrade_000_alter_network_add_sasl.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 @@ -8,85 +94,112 @@ ./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/upgrade_000_create_user_setting.sql - ./SQL/SQLite/11/upgrade_999_version.sql - ./SQL/SQLite/12/delete_backlog_by_uid.sql - ./SQL/SQLite/12/delete_backlog_for_buffer.sql - ./SQL/SQLite/12/delete_backlog_for_network.sql - ./SQL/SQLite/12/delete_buffer_for_bufferid.sql - ./SQL/SQLite/12/delete_buffers_by_uid.sql - ./SQL/SQLite/12/delete_buffers_for_network.sql - ./SQL/SQLite/12/delete_identity.sql - ./SQL/SQLite/12/delete_ircservers_for_network.sql - ./SQL/SQLite/12/delete_network.sql - ./SQL/SQLite/12/delete_networks_by_uid.sql - ./SQL/SQLite/12/delete_nicks.sql - ./SQL/SQLite/12/delete_quasseluser.sql - ./SQL/SQLite/12/insert_buffer.sql - ./SQL/SQLite/12/insert_identity.sql - ./SQL/SQLite/12/insert_message.sql - ./SQL/SQLite/12/insert_network.sql - ./SQL/SQLite/12/insert_nick.sql - ./SQL/SQLite/12/insert_quasseluser.sql - ./SQL/SQLite/12/insert_sender.sql - ./SQL/SQLite/12/insert_server.sql - ./SQL/SQLite/12/insert_user_setting.sql - ./SQL/SQLite/12/select_authuser.sql - ./SQL/SQLite/12/select_buffer_by_id.sql - ./SQL/SQLite/12/select_buffer_lastseen_messages.sql - ./SQL/SQLite/12/select_bufferByName.sql - ./SQL/SQLite/12/select_bufferExists.sql - ./SQL/SQLite/12/select_buffers.sql - ./SQL/SQLite/12/select_buffers_for_network.sql - ./SQL/SQLite/12/select_checkidentity.sql - ./SQL/SQLite/12/select_connected_networks.sql - ./SQL/SQLite/12/select_identities.sql - ./SQL/SQLite/12/select_internaluser.sql - ./SQL/SQLite/12/select_messages.sql - ./SQL/SQLite/12/select_messagesAll.sql - ./SQL/SQLite/12/select_messagesAllNew.sql - ./SQL/SQLite/12/select_messagesNew.sql - ./SQL/SQLite/12/select_networkExists.sql - ./SQL/SQLite/12/select_networks_for_user.sql - ./SQL/SQLite/12/select_nicks.sql - ./SQL/SQLite/12/select_persistent_channels.sql - ./SQL/SQLite/12/select_servers_for_network.sql - ./SQL/SQLite/12/select_user_setting.sql - ./SQL/SQLite/12/select_userid.sql - ./SQL/SQLite/12/setup_000_quasseluser.sql - ./SQL/SQLite/12/setup_010_sender.sql - ./SQL/SQLite/12/setup_020_network.sql - ./SQL/SQLite/12/setup_030_buffer.sql - ./SQL/SQLite/12/setup_040_buffer_idx.sql - ./SQL/SQLite/12/setup_050_buffer_cname_idx.sql - ./SQL/SQLite/12/setup_060_backlog.sql - ./SQL/SQLite/12/setup_070_coreinfo.sql - ./SQL/SQLite/12/setup_080_ircservers.sql - ./SQL/SQLite/12/setup_090_create_backlog_idx.sql - ./SQL/SQLite/12/setup_100_create_backlog_idx2.sql - ./SQL/SQLite/12/setup_110_create_buffer_idx.sql - ./SQL/SQLite/12/setup_120_create_user_setting.sql - ./SQL/SQLite/12/setup_130_identity.sql - ./SQL/SQLite/12/setup_140_identity_nick.sql - ./SQL/SQLite/12/setup_999_version.sql - ./SQL/SQLite/12/update_buffer_lastseen.sql - ./SQL/SQLite/12/update_buffer_name.sql - ./SQL/SQLite/12/update_buffer_persistent_channel.sql - ./SQL/SQLite/12/update_buffer_set_channel_key.sql - ./SQL/SQLite/12/update_identity.sql - ./SQL/SQLite/12/update_network.sql - ./SQL/SQLite/12/update_network_connected.sql - ./SQL/SQLite/12/update_user_setting.sql - ./SQL/SQLite/12/update_username.sql - ./SQL/SQLite/12/update_userpassword.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/12/upgrade_999_version.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/delete_backlog_by_uid.sql + ./SQL/SQLite/17/delete_backlog_for_buffer.sql + ./SQL/SQLite/17/delete_backlog_for_network.sql + ./SQL/SQLite/17/delete_buffer_for_bufferid.sql + ./SQL/SQLite/17/delete_buffers_by_uid.sql + ./SQL/SQLite/17/delete_buffers_for_network.sql + ./SQL/SQLite/17/delete_identity.sql + ./SQL/SQLite/17/delete_ircservers_for_network.sql + ./SQL/SQLite/17/delete_network.sql + ./SQL/SQLite/17/delete_networks_by_uid.sql + ./SQL/SQLite/17/delete_nicks.sql + ./SQL/SQLite/17/delete_quasseluser.sql + ./SQL/SQLite/17/insert_buffer.sql + ./SQL/SQLite/17/insert_identity.sql + ./SQL/SQLite/17/insert_message.sql + ./SQL/SQLite/17/insert_network.sql + ./SQL/SQLite/17/insert_nick.sql + ./SQL/SQLite/17/insert_quasseluser.sql + ./SQL/SQLite/17/insert_sender.sql + ./SQL/SQLite/17/insert_server.sql + ./SQL/SQLite/17/insert_user_setting.sql + ./SQL/SQLite/17/migrate_read_backlog.sql + ./SQL/SQLite/17/migrate_read_buffer.sql + ./SQL/SQLite/17/migrate_read_identity.sql + ./SQL/SQLite/17/migrate_read_identity_nick.sql + ./SQL/SQLite/17/migrate_read_ircserver.sql + ./SQL/SQLite/17/migrate_read_network.sql + ./SQL/SQLite/17/migrate_read_quasseluser.sql + ./SQL/SQLite/17/migrate_read_sender.sql + ./SQL/SQLite/17/migrate_read_usersetting.sql + ./SQL/SQLite/17/select_authuser.sql + ./SQL/SQLite/17/select_buffer_by_id.sql + ./SQL/SQLite/17/select_buffer_lastseen_messages.sql + ./SQL/SQLite/17/select_buffer_markerlinemsgids.sql + ./SQL/SQLite/17/select_bufferByName.sql + ./SQL/SQLite/17/select_bufferExists.sql + ./SQL/SQLite/17/select_buffers.sql + ./SQL/SQLite/17/select_buffers_for_merge.sql + ./SQL/SQLite/17/select_buffers_for_network.sql + ./SQL/SQLite/17/select_checkidentity.sql + ./SQL/SQLite/17/select_connected_networks.sql + ./SQL/SQLite/17/select_identities.sql + ./SQL/SQLite/17/select_internaluser.sql + ./SQL/SQLite/17/select_messages.sql + ./SQL/SQLite/17/select_messagesAll.sql + ./SQL/SQLite/17/select_messagesAllNew.sql + ./SQL/SQLite/17/select_messagesNewerThan.sql + ./SQL/SQLite/17/select_messagesNewestK.sql + ./SQL/SQLite/17/select_network_awaymsg.sql + ./SQL/SQLite/17/select_network_usermode.sql + ./SQL/SQLite/17/select_networkExists.sql + ./SQL/SQLite/17/select_networks_for_user.sql + ./SQL/SQLite/17/select_nicks.sql + ./SQL/SQLite/17/select_persistent_channels.sql + ./SQL/SQLite/17/select_servers_for_network.sql + ./SQL/SQLite/17/select_user_setting.sql + ./SQL/SQLite/17/select_userid.sql + ./SQL/SQLite/17/setup_000_quasseluser.sql + ./SQL/SQLite/17/setup_010_sender.sql + ./SQL/SQLite/17/setup_020_network.sql + ./SQL/SQLite/17/setup_030_buffer.sql + ./SQL/SQLite/17/setup_040_buffer_idx.sql + ./SQL/SQLite/17/setup_050_buffer_cname_idx.sql + ./SQL/SQLite/17/setup_060_backlog.sql + ./SQL/SQLite/17/setup_070_coreinfo.sql + ./SQL/SQLite/17/setup_080_ircservers.sql + ./SQL/SQLite/17/setup_090_backlog_idx.sql + ./SQL/SQLite/17/setup_100_backlog_idx2.sql + ./SQL/SQLite/17/setup_110_buffer_user_idx.sql + ./SQL/SQLite/17/setup_120_user_setting.sql + ./SQL/SQLite/17/setup_130_identity.sql + ./SQL/SQLite/17/setup_140_identity_nick.sql + ./SQL/SQLite/17/update_backlog_bufferid.sql + ./SQL/SQLite/17/update_buffer_lastseen.sql + ./SQL/SQLite/17/update_buffer_markerlinemsgid.sql + ./SQL/SQLite/17/update_buffer_name.sql + ./SQL/SQLite/17/update_buffer_persistent_channel.sql + ./SQL/SQLite/17/update_buffer_set_channel_key.sql + ./SQL/SQLite/17/update_identity.sql + ./SQL/SQLite/17/update_network.sql + ./SQL/SQLite/17/update_network_connected.sql + ./SQL/SQLite/17/update_network_set_awaymsg.sql + ./SQL/SQLite/17/update_network_set_usermode.sql + ./SQL/SQLite/17/update_user_setting.sql + ./SQL/SQLite/17/update_username.sql + ./SQL/SQLite/17/update_userpassword.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/2/upgrade_000_drop_buffergroup.sql ./SQL/SQLite/2/upgrade_010_update_schemaversion.sql ./SQL/SQLite/3/upgrade_000_update_backlog_flags.sql @@ -97,13 +210,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 @@ -121,21 +232,17 @@ ./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