X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2Fsql.qrc;h=bbf41acb66ad11ebac794fa1694215bbc1c7151d;hp=22de48e676e294584ef7b34d19db9a3d36c87fea;hb=10ee60164fb3701b20c439269f170a4f2cb2e2a9;hpb=d682289cc69fac3a5776ef29059cc1f54d8d37d4
diff --git a/src/core/sql.qrc b/src/core/sql.qrc
index 22de48e6..bbf41acb 100644
--- a/src/core/sql.qrc
+++ b/src/core/sql.qrc
@@ -78,8 +78,9 @@
./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_lastseen.sql
+ ./SQL/PostgreSQL/20/update_buffer_lastmsgid.sql
./SQL/PostgreSQL/20/update_buffer_markerlinemsgid.sql
./SQL/PostgreSQL/20/update_buffer_name.sql
./SQL/PostgreSQL/20/update_buffer_persistent_channel.sql
@@ -93,10 +94,11 @@
./SQL/PostgreSQL/20/update_username.sql
./SQL/PostgreSQL/20/update_userpassword.sql
./SQL/PostgreSQL/20/upgrade_000_alter_buffer_add_lastmsgid.sql
- ./SQL/PostgreSQL/20/update_buffer_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/setup_130_function_lastmsgid.sql
+ ./SQL/PostgreSQL/20/upgrade_003_correct_bad_lastseenmsgid.sql
+ ./SQL/PostgreSQL/20/upgrade_004_add_lastseenmsgid_constraint.sql
+ ./SQL/PostgreSQL/20/update_buffer_lastseen.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
@@ -129,92 +131,6 @@
./SQL/SQLite/19/upgrade_000_alter_ircserver_add_sslverify.sql
./SQL/SQLite/2/upgrade_000_drop_buffergroup.sql
./SQL/SQLite/2/upgrade_010_update_schemaversion.sql
- ./SQL/SQLite/20/delete_backlog_by_uid.sql
- ./SQL/SQLite/20/delete_backlog_for_buffer.sql
- ./SQL/SQLite/20/delete_backlog_for_network.sql
- ./SQL/SQLite/20/delete_buffer_for_bufferid.sql
- ./SQL/SQLite/20/delete_buffers_by_uid.sql
- ./SQL/SQLite/20/delete_buffers_for_network.sql
- ./SQL/SQLite/20/delete_identity.sql
- ./SQL/SQLite/20/delete_ircservers_for_network.sql
- ./SQL/SQLite/20/delete_network.sql
- ./SQL/SQLite/20/delete_networks_by_uid.sql
- ./SQL/SQLite/20/delete_nicks.sql
- ./SQL/SQLite/20/delete_quasseluser.sql
- ./SQL/SQLite/20/insert_buffer.sql
- ./SQL/SQLite/20/insert_identity.sql
- ./SQL/SQLite/20/insert_message.sql
- ./SQL/SQLite/20/insert_network.sql
- ./SQL/SQLite/20/insert_nick.sql
- ./SQL/SQLite/20/insert_quasseluser.sql
- ./SQL/SQLite/20/insert_sender.sql
- ./SQL/SQLite/20/insert_server.sql
- ./SQL/SQLite/20/insert_user_setting.sql
- ./SQL/SQLite/20/migrate_read_backlog.sql
- ./SQL/SQLite/20/migrate_read_buffer.sql
- ./SQL/SQLite/20/migrate_read_identity.sql
- ./SQL/SQLite/20/migrate_read_identity_nick.sql
- ./SQL/SQLite/20/migrate_read_ircserver.sql
- ./SQL/SQLite/20/migrate_read_network.sql
- ./SQL/SQLite/20/migrate_read_quasseluser.sql
- ./SQL/SQLite/20/migrate_read_sender.sql
- ./SQL/SQLite/20/migrate_read_usersetting.sql
- ./SQL/SQLite/20/select_authuser.sql
- ./SQL/SQLite/20/select_bufferByName.sql
- ./SQL/SQLite/20/select_bufferExists.sql
- ./SQL/SQLite/20/select_buffer_by_id.sql
- ./SQL/SQLite/20/select_buffer_lastseen_messages.sql
- ./SQL/SQLite/20/select_buffer_markerlinemsgids.sql
- ./SQL/SQLite/20/select_buffers.sql
- ./SQL/SQLite/20/select_buffers_for_merge.sql
- ./SQL/SQLite/20/select_buffers_for_network.sql
- ./SQL/SQLite/20/select_checkidentity.sql
- ./SQL/SQLite/20/select_connected_networks.sql
- ./SQL/SQLite/20/select_identities.sql
- ./SQL/SQLite/20/select_internaluser.sql
- ./SQL/SQLite/20/select_messages.sql
- ./SQL/SQLite/20/select_messagesAll.sql
- ./SQL/SQLite/20/select_messagesAllNew.sql
- ./SQL/SQLite/20/select_messagesNewerThan.sql
- ./SQL/SQLite/20/select_messagesNewestK.sql
- ./SQL/SQLite/20/select_networkExists.sql
- ./SQL/SQLite/20/select_network_awaymsg.sql
- ./SQL/SQLite/20/select_network_usermode.sql
- ./SQL/SQLite/20/select_networks_for_user.sql
- ./SQL/SQLite/20/select_nicks.sql
- ./SQL/SQLite/20/select_persistent_channels.sql
- ./SQL/SQLite/20/select_servers_for_network.sql
- ./SQL/SQLite/20/select_user_setting.sql
- ./SQL/SQLite/20/select_userid.sql
- ./SQL/SQLite/20/setup_000_quasseluser.sql
- ./SQL/SQLite/20/setup_010_sender.sql
- ./SQL/SQLite/20/setup_020_network.sql
- ./SQL/SQLite/20/setup_030_buffer.sql
- ./SQL/SQLite/20/setup_040_buffer_idx.sql
- ./SQL/SQLite/20/setup_050_buffer_cname_idx.sql
- ./SQL/SQLite/20/setup_060_backlog.sql
- ./SQL/SQLite/20/setup_070_coreinfo.sql
- ./SQL/SQLite/20/setup_080_ircservers.sql
- ./SQL/SQLite/20/setup_090_backlog_idx.sql
- ./SQL/SQLite/20/setup_100_backlog_idx2.sql
- ./SQL/SQLite/20/setup_110_buffer_user_idx.sql
- ./SQL/SQLite/20/setup_120_user_setting.sql
- ./SQL/SQLite/20/setup_130_identity.sql
- ./SQL/SQLite/20/setup_140_identity_nick.sql
- ./SQL/SQLite/20/update_backlog_bufferid.sql
- ./SQL/SQLite/20/update_buffer_lastseen.sql
- ./SQL/SQLite/20/update_buffer_markerlinemsgid.sql
- ./SQL/SQLite/20/update_buffer_name.sql
- ./SQL/SQLite/20/update_buffer_persistent_channel.sql
- ./SQL/SQLite/20/update_buffer_set_channel_key.sql
- ./SQL/SQLite/20/update_identity.sql
- ./SQL/SQLite/20/update_network.sql
- ./SQL/SQLite/20/update_network_connected.sql
- ./SQL/SQLite/20/update_network_set_awaymsg.sql
- ./SQL/SQLite/20/update_network_set_usermode.sql
- ./SQL/SQLite/20/update_user_setting.sql
- ./SQL/SQLite/20/update_username.sql
- ./SQL/SQLite/20/update_userpassword.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
@@ -261,5 +177,99 @@
./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/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_network.sql
+ ./SQL/SQLite/21/delete_networks_by_uid.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.sql
+ ./SQL/SQLite/21/migrate_read_identity_nick.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_bufferByName.sql
+ ./SQL/SQLite/21/select_bufferExists.sql
+ ./SQL/SQLite/21/select_buffer_by_id.sql
+ ./SQL/SQLite/21/select_buffer_lastseen_messages.sql
+ ./SQL/SQLite/21/select_buffer_markerlinemsgids.sql
+ ./SQL/SQLite/21/select_buffers.sql
+ ./SQL/SQLite/21/select_buffers_for_merge.sql
+ ./SQL/SQLite/21/select_buffers_for_network.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_messages.sql
+ ./SQL/SQLite/21/select_messagesAll.sql
+ ./SQL/SQLite/21/select_messagesAllNew.sql
+ ./SQL/SQLite/21/select_messagesNewerThan.sql
+ ./SQL/SQLite/21/select_messagesNewestK.sql
+ ./SQL/SQLite/21/select_networkExists.sql
+ ./SQL/SQLite/21/select_network_awaymsg.sql
+ ./SQL/SQLite/21/select_network_usermode.sql
+ ./SQL/SQLite/21/select_networks_for_user.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_user_setting.sql
+ ./SQL/SQLite/21/select_userid.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_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.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_user_setting.sql
+ ./SQL/SQLite/21/update_username.sql
+ ./SQL/SQLite/21/update_userpassword.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_006_alter_table_buffer_new_rename_to_buffer.sql
+ ./SQL/SQLite/21/update_buffer_lastmsgid.sql
+ ./SQL/SQLite/21/update_buffer_lastseen.sql
+ ./SQL/SQLite/21/upgrade_005_drop_table_buffer.sql