From 9ce9e3fe0329a6736383a7a3a5bc1618f80885ca Mon Sep 17 00:00:00 2001 From: Daniel Albers Date: Sun, 14 Feb 2010 11:21:57 +0100 Subject: [PATCH] Schema changes for SASL support --- .../{15 => 16}/delete_backlog_by_uid.sql | 0 .../{15 => 16}/delete_backlog_for_buffer.sql | 0 .../{15 => 16}/delete_backlog_for_network.sql | 0 .../{15 => 16}/delete_buffer_for_bufferid.sql | 0 .../{15 => 16}/delete_buffers_by_uid.sql | 0 .../{15 => 16}/delete_buffers_for_network.sql | 0 .../PostgreSQL/{15 => 16}/delete_identity.sql | 0 .../delete_ircservers_for_network.sql | 0 .../PostgreSQL/{15 => 16}/delete_network.sql | 0 .../{15 => 16}/delete_networks_by_uid.sql | 0 .../PostgreSQL/{15 => 16}/delete_nicks.sql | 0 .../{15 => 16}/delete_quasseluser.sql | 0 .../PostgreSQL/{15 => 16}/insert_buffer.sql | 0 .../PostgreSQL/{15 => 16}/insert_identity.sql | 0 .../PostgreSQL/{15 => 16}/insert_message.sql | 0 .../PostgreSQL/{15 => 16}/insert_network.sql | 4 +- .../SQL/PostgreSQL/{15 => 16}/insert_nick.sql | 0 .../{15 => 16}/insert_quasseluser.sql | 0 .../PostgreSQL/{15 => 16}/insert_sender.sql | 0 .../PostgreSQL/{15 => 16}/insert_server.sql | 0 .../{15 => 16}/insert_user_setting.sql | 0 .../{15 => 16}/migrate_write_backlog.sql | 0 .../{15 => 16}/migrate_write_buffer.sql | 0 .../{15 => 16}/migrate_write_identity.sql | 0 .../migrate_write_identity_nick.sql | 0 .../{15 => 16}/migrate_write_ircserver.sql | 0 .../{15 => 16}/migrate_write_network.sql | 4 +- .../{15 => 16}/migrate_write_quasseluser.sql | 0 .../{15 => 16}/migrate_write_sender.sql | 0 .../{15 => 16}/migrate_write_usersetting.sql | 0 .../PostgreSQL/{15 => 16}/select_authuser.sql | 0 .../{15 => 16}/select_bufferByName.sql | 0 .../{15 => 16}/select_bufferExists.sql | 0 .../{15 => 16}/select_buffer_by_id.sql | 0 .../select_buffer_lastseen_messages.sql | 0 .../select_buffer_markerlinemsgids.sql | 0 .../PostgreSQL/{15 => 16}/select_buffers.sql | 0 .../{15 => 16}/select_buffers_for_network.sql | 0 .../{15 => 16}/select_checkidentity.sql | 0 .../{15 => 16}/select_connected_networks.sql | 0 .../{15 => 16}/select_identities.sql | 0 .../{15 => 16}/select_internaluser.sql | 0 .../PostgreSQL/{15 => 16}/select_messages.sql | 0 .../{15 => 16}/select_messagesAll.sql | 0 .../{15 => 16}/select_messagesAllNew.sql | 0 .../{15 => 16}/select_messagesNewerThan.sql | 0 .../{15 => 16}/select_messagesRange.sql | 0 .../{15 => 16}/select_networkExists.sql | 0 .../{15 => 16}/select_network_awaymsg.sql | 0 .../{15 => 16}/select_network_usermode.sql | 0 .../16/select_networks_for_user.sql | 5 +- .../PostgreSQL/{15 => 16}/select_nicks.sql | 0 .../{15 => 16}/select_persistent_channels.sql | 0 .../{15 => 16}/select_servers_for_network.sql | 0 .../{15 => 16}/select_user_setting.sql | 0 .../PostgreSQL/{15 => 16}/select_userid.sql | 0 .../{15 => 16}/setup_000_quasseluser.sql | 0 .../{15 => 16}/setup_010_sender.sql | 0 .../{15 => 16}/setup_020_identity.sql | 0 .../{15 => 16}/setup_030_identity_nick.sql | 0 .../{15 => 16}/setup_040_network.sql | 3 + .../{15 => 16}/setup_050_buffer.sql | 0 .../{15 => 16}/setup_060_backlog.sql | 0 .../{15 => 16}/setup_070_coreinfo.sql | 0 .../{15 => 16}/setup_080_ircservers.sql | 0 .../{15 => 16}/setup_090_backlog_idx.sql | 0 .../{15 => 16}/setup_100_user_setting.sql | 0 .../{15 => 16}/setup_110_alter_sender_seq.sql | 0 .../setup_120_alter_messageid_seq.sql | 0 .../{15 => 16}/update_backlog_bufferid.sql | 0 .../{15 => 16}/update_buffer_lastseen.sql | 0 .../update_buffer_markerlinemsgid.sql | 0 .../{15 => 16}/update_buffer_name.sql | 0 .../update_buffer_persistent_channel.sql | 0 .../update_buffer_set_channel_key.sql | 0 .../PostgreSQL/{15 => 16}/update_identity.sql | 0 .../PostgreSQL/{15 => 16}/update_network.sql | 5 +- .../{15 => 16}/update_network_connected.sql | 0 .../{15 => 16}/update_network_set_awaymsg.sql | 0 .../update_network_set_usermode.sql | 0 .../{15 => 16}/update_user_setting.sql | 0 .../PostgreSQL/{15 => 16}/update_username.sql | 0 .../{15 => 16}/update_userpassword.sql | 0 .../16/upgrade_000_alter_network_add_sasl.sql | 4 + .../{16 => 17}/delete_backlog_by_uid.sql | 0 .../{16 => 17}/delete_backlog_for_buffer.sql | 0 .../{16 => 17}/delete_backlog_for_network.sql | 0 .../{16 => 17}/delete_buffer_for_bufferid.sql | 0 .../{16 => 17}/delete_buffers_by_uid.sql | 0 .../{16 => 17}/delete_buffers_for_network.sql | 0 .../SQL/SQLite/{16 => 17}/delete_identity.sql | 0 .../delete_ircservers_for_network.sql | 0 .../SQL/SQLite/{16 => 17}/delete_network.sql | 0 .../{16 => 17}/delete_networks_by_uid.sql | 0 .../SQL/SQLite/{16 => 17}/delete_nicks.sql | 0 .../SQLite/{16 => 17}/delete_quasseluser.sql | 0 .../SQL/SQLite/{16 => 17}/insert_buffer.sql | 0 .../SQL/SQLite/{16 => 17}/insert_identity.sql | 0 .../SQL/SQLite/{16 => 17}/insert_message.sql | 0 .../SQL/SQLite/{16 => 17}/insert_network.sql | 4 +- .../SQL/SQLite/{16 => 17}/insert_nick.sql | 0 .../SQLite/{16 => 17}/insert_quasseluser.sql | 0 .../SQL/SQLite/{16 => 17}/insert_sender.sql | 0 .../SQL/SQLite/{16 => 17}/insert_server.sql | 0 .../SQLite/{16 => 17}/insert_user_setting.sql | 0 .../{16 => 17}/migrate_read_backlog.sql | 0 .../SQLite/{16 => 17}/migrate_read_buffer.sql | 0 .../{16 => 17}/migrate_read_identity.sql | 0 .../{16 => 17}/migrate_read_identity_nick.sql | 0 .../{16 => 17}/migrate_read_ircserver.sql | 0 .../{16 => 17}/migrate_read_network.sql | 0 .../{16 => 17}/migrate_read_quasseluser.sql | 0 .../SQLite/{16 => 17}/migrate_read_sender.sql | 0 .../{16 => 17}/migrate_read_usersetting.sql | 0 .../SQL/SQLite/{16 => 17}/select_authuser.sql | 0 .../SQLite/{16 => 17}/select_bufferByName.sql | 0 .../SQLite/{16 => 17}/select_bufferExists.sql | 0 .../SQLite/{16 => 17}/select_buffer_by_id.sql | 0 .../select_buffer_lastseen_messages.sql | 0 .../select_buffer_markerlinemsgids.sql | 0 .../SQL/SQLite/{16 => 17}/select_buffers.sql | 0 .../{16 => 17}/select_buffers_for_merge.sql | 0 .../{16 => 17}/select_buffers_for_network.sql | 0 .../{16 => 17}/select_checkidentity.sql | 0 .../{16 => 17}/select_connected_networks.sql | 0 .../SQLite/{16 => 17}/select_identities.sql | 0 .../SQLite/{16 => 17}/select_internaluser.sql | 0 .../SQL/SQLite/{16 => 17}/select_messages.sql | 0 .../SQLite/{16 => 17}/select_messagesAll.sql | 0 .../{16 => 17}/select_messagesAllNew.sql | 0 .../{16 => 17}/select_messagesNewerThan.sql | 0 .../{16 => 17}/select_messagesNewestK.sql | 0 .../{16 => 17}/select_networkExists.sql | 0 .../{16 => 17}/select_network_awaymsg.sql | 0 .../{16 => 17}/select_network_usermode.sql | 0 .../17}/select_networks_for_user.sql | 5 +- .../SQL/SQLite/{16 => 17}/select_nicks.sql | 0 .../{16 => 17}/select_persistent_channels.sql | 0 .../{16 => 17}/select_servers_for_network.sql | 0 .../SQLite/{16 => 17}/select_user_setting.sql | 0 .../SQL/SQLite/{16 => 17}/select_userid.sql | 0 .../{16 => 17}/setup_000_quasseluser.sql | 0 .../SQLite/{16 => 17}/setup_010_sender.sql | 0 .../SQLite/{16 => 17}/setup_020_network.sql | 3 + .../SQLite/{16 => 17}/setup_030_buffer.sql | 0 .../{16 => 17}/setup_040_buffer_idx.sql | 0 .../{16 => 17}/setup_050_buffer_cname_idx.sql | 0 .../SQLite/{16 => 17}/setup_060_backlog.sql | 0 .../SQLite/{16 => 17}/setup_070_coreinfo.sql | 0 .../{16 => 17}/setup_080_ircservers.sql | 0 .../{16 => 17}/setup_090_backlog_idx.sql | 0 .../{16 => 17}/setup_100_backlog_idx2.sql | 0 .../{16 => 17}/setup_110_buffer_user_idx.sql | 0 .../{16 => 17}/setup_120_user_setting.sql | 0 .../SQLite/{16 => 17}/setup_130_identity.sql | 0 .../{16 => 17}/setup_140_identity_nick.sql | 0 .../{16 => 17}/update_backlog_bufferid.sql | 0 .../{16 => 17}/update_buffer_lastseen.sql | 0 .../update_buffer_markerlinemsgid.sql | 0 .../SQLite/{16 => 17}/update_buffer_name.sql | 0 .../update_buffer_persistent_channel.sql | 0 .../update_buffer_set_channel_key.sql | 0 .../SQL/SQLite/{16 => 17}/update_identity.sql | 0 .../SQL/SQLite/{16 => 17}/update_network.sql | 5 +- .../{16 => 17}/update_network_connected.sql | 0 .../{16 => 17}/update_network_set_awaymsg.sql | 0 .../update_network_set_usermode.sql | 0 .../SQLite/{16 => 17}/update_user_setting.sql | 0 .../SQL/SQLite/{16 => 17}/update_username.sql | 0 .../SQLite/{16 => 17}/update_userpassword.sql | 0 .../17/upgrade_000_alter_network_add_sasl.sql | 3 + .../17/upgrade_001_alter_network_add_sasl.sql | 3 + .../17/upgrade_002_alter_network_add_sasl.sql | 3 + src/core/sql.qrc | 342 +++++++++--------- 174 files changed, 212 insertions(+), 181 deletions(-) rename src/core/SQL/PostgreSQL/{15 => 16}/delete_backlog_by_uid.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/delete_backlog_for_buffer.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/delete_backlog_for_network.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/delete_buffer_for_bufferid.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/delete_buffers_by_uid.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/delete_buffers_for_network.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/delete_identity.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/delete_ircservers_for_network.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/delete_network.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/delete_networks_by_uid.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/delete_nicks.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/delete_quasseluser.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/insert_buffer.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/insert_identity.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/insert_message.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/insert_network.sql (79%) rename src/core/SQL/PostgreSQL/{15 => 16}/insert_nick.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/insert_quasseluser.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/insert_sender.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/insert_server.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/insert_user_setting.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/migrate_write_backlog.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/migrate_write_buffer.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/migrate_write_identity.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/migrate_write_identity_nick.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/migrate_write_ircserver.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/migrate_write_network.sql (79%) rename src/core/SQL/PostgreSQL/{15 => 16}/migrate_write_quasseluser.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/migrate_write_sender.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/migrate_write_usersetting.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_authuser.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_bufferByName.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_bufferExists.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_buffer_by_id.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_buffer_lastseen_messages.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_buffer_markerlinemsgids.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_buffers.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_buffers_for_network.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_checkidentity.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_connected_networks.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_identities.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_internaluser.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_messages.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_messagesAll.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_messagesAllNew.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_messagesNewerThan.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_messagesRange.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_networkExists.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_network_awaymsg.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_network_usermode.sql (100%) rename src/core/SQL/{SQLite => PostgreSQL}/16/select_networks_for_user.sql (69%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_nicks.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_persistent_channels.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_servers_for_network.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_user_setting.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/select_userid.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/setup_000_quasseluser.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/setup_010_sender.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/setup_020_identity.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/setup_030_identity_nick.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/setup_040_network.sql (91%) rename src/core/SQL/PostgreSQL/{15 => 16}/setup_050_buffer.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/setup_060_backlog.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/setup_070_coreinfo.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/setup_080_ircservers.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/setup_090_backlog_idx.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/setup_100_user_setting.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/setup_110_alter_sender_seq.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/setup_120_alter_messageid_seq.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/update_backlog_bufferid.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/update_buffer_lastseen.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/update_buffer_markerlinemsgid.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/update_buffer_name.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/update_buffer_persistent_channel.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/update_buffer_set_channel_key.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/update_identity.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/update_network.sql (83%) rename src/core/SQL/PostgreSQL/{15 => 16}/update_network_connected.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/update_network_set_awaymsg.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/update_network_set_usermode.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/update_user_setting.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/update_username.sql (100%) rename src/core/SQL/PostgreSQL/{15 => 16}/update_userpassword.sql (100%) create mode 100644 src/core/SQL/PostgreSQL/16/upgrade_000_alter_network_add_sasl.sql rename src/core/SQL/SQLite/{16 => 17}/delete_backlog_by_uid.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/delete_backlog_for_buffer.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/delete_backlog_for_network.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/delete_buffer_for_bufferid.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/delete_buffers_by_uid.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/delete_buffers_for_network.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/delete_identity.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/delete_ircservers_for_network.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/delete_network.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/delete_networks_by_uid.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/delete_nicks.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/delete_quasseluser.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/insert_buffer.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/insert_identity.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/insert_message.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/insert_network.sql (79%) rename src/core/SQL/SQLite/{16 => 17}/insert_nick.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/insert_quasseluser.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/insert_sender.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/insert_server.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/insert_user_setting.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/migrate_read_backlog.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/migrate_read_buffer.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/migrate_read_identity.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/migrate_read_identity_nick.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/migrate_read_ircserver.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/migrate_read_network.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/migrate_read_quasseluser.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/migrate_read_sender.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/migrate_read_usersetting.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_authuser.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_bufferByName.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_bufferExists.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_buffer_by_id.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_buffer_lastseen_messages.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_buffer_markerlinemsgids.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_buffers.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_buffers_for_merge.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_buffers_for_network.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_checkidentity.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_connected_networks.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_identities.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_internaluser.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_messages.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_messagesAll.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_messagesAllNew.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_messagesNewerThan.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_messagesNewestK.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_networkExists.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_network_awaymsg.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_network_usermode.sql (100%) rename src/core/SQL/{PostgreSQL/15 => SQLite/17}/select_networks_for_user.sql (69%) rename src/core/SQL/SQLite/{16 => 17}/select_nicks.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_persistent_channels.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_servers_for_network.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_user_setting.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/select_userid.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/setup_000_quasseluser.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/setup_010_sender.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/setup_020_network.sql (92%) rename src/core/SQL/SQLite/{16 => 17}/setup_030_buffer.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/setup_040_buffer_idx.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/setup_050_buffer_cname_idx.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/setup_060_backlog.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/setup_070_coreinfo.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/setup_080_ircservers.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/setup_090_backlog_idx.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/setup_100_backlog_idx2.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/setup_110_buffer_user_idx.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/setup_120_user_setting.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/setup_130_identity.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/setup_140_identity_nick.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/update_backlog_bufferid.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/update_buffer_lastseen.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/update_buffer_markerlinemsgid.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/update_buffer_name.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/update_buffer_persistent_channel.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/update_buffer_set_channel_key.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/update_identity.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/update_network.sql (83%) rename src/core/SQL/SQLite/{16 => 17}/update_network_connected.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/update_network_set_awaymsg.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/update_network_set_usermode.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/update_user_setting.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/update_username.sql (100%) rename src/core/SQL/SQLite/{16 => 17}/update_userpassword.sql (100%) create mode 100644 src/core/SQL/SQLite/17/upgrade_000_alter_network_add_sasl.sql create mode 100644 src/core/SQL/SQLite/17/upgrade_001_alter_network_add_sasl.sql create mode 100644 src/core/SQL/SQLite/17/upgrade_002_alter_network_add_sasl.sql diff --git a/src/core/SQL/PostgreSQL/15/delete_backlog_by_uid.sql b/src/core/SQL/PostgreSQL/16/delete_backlog_by_uid.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/delete_backlog_by_uid.sql rename to src/core/SQL/PostgreSQL/16/delete_backlog_by_uid.sql diff --git a/src/core/SQL/PostgreSQL/15/delete_backlog_for_buffer.sql b/src/core/SQL/PostgreSQL/16/delete_backlog_for_buffer.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/delete_backlog_for_buffer.sql rename to src/core/SQL/PostgreSQL/16/delete_backlog_for_buffer.sql diff --git a/src/core/SQL/PostgreSQL/15/delete_backlog_for_network.sql b/src/core/SQL/PostgreSQL/16/delete_backlog_for_network.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/delete_backlog_for_network.sql rename to src/core/SQL/PostgreSQL/16/delete_backlog_for_network.sql diff --git a/src/core/SQL/PostgreSQL/15/delete_buffer_for_bufferid.sql b/src/core/SQL/PostgreSQL/16/delete_buffer_for_bufferid.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/delete_buffer_for_bufferid.sql rename to src/core/SQL/PostgreSQL/16/delete_buffer_for_bufferid.sql diff --git a/src/core/SQL/PostgreSQL/15/delete_buffers_by_uid.sql b/src/core/SQL/PostgreSQL/16/delete_buffers_by_uid.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/delete_buffers_by_uid.sql rename to src/core/SQL/PostgreSQL/16/delete_buffers_by_uid.sql diff --git a/src/core/SQL/PostgreSQL/15/delete_buffers_for_network.sql b/src/core/SQL/PostgreSQL/16/delete_buffers_for_network.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/delete_buffers_for_network.sql rename to src/core/SQL/PostgreSQL/16/delete_buffers_for_network.sql diff --git a/src/core/SQL/PostgreSQL/15/delete_identity.sql b/src/core/SQL/PostgreSQL/16/delete_identity.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/delete_identity.sql rename to src/core/SQL/PostgreSQL/16/delete_identity.sql diff --git a/src/core/SQL/PostgreSQL/15/delete_ircservers_for_network.sql b/src/core/SQL/PostgreSQL/16/delete_ircservers_for_network.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/delete_ircservers_for_network.sql rename to src/core/SQL/PostgreSQL/16/delete_ircservers_for_network.sql diff --git a/src/core/SQL/PostgreSQL/15/delete_network.sql b/src/core/SQL/PostgreSQL/16/delete_network.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/delete_network.sql rename to src/core/SQL/PostgreSQL/16/delete_network.sql diff --git a/src/core/SQL/PostgreSQL/15/delete_networks_by_uid.sql b/src/core/SQL/PostgreSQL/16/delete_networks_by_uid.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/delete_networks_by_uid.sql rename to src/core/SQL/PostgreSQL/16/delete_networks_by_uid.sql diff --git a/src/core/SQL/PostgreSQL/15/delete_nicks.sql b/src/core/SQL/PostgreSQL/16/delete_nicks.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/delete_nicks.sql rename to src/core/SQL/PostgreSQL/16/delete_nicks.sql diff --git a/src/core/SQL/PostgreSQL/15/delete_quasseluser.sql b/src/core/SQL/PostgreSQL/16/delete_quasseluser.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/delete_quasseluser.sql rename to src/core/SQL/PostgreSQL/16/delete_quasseluser.sql diff --git a/src/core/SQL/PostgreSQL/15/insert_buffer.sql b/src/core/SQL/PostgreSQL/16/insert_buffer.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/insert_buffer.sql rename to src/core/SQL/PostgreSQL/16/insert_buffer.sql diff --git a/src/core/SQL/PostgreSQL/15/insert_identity.sql b/src/core/SQL/PostgreSQL/16/insert_identity.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/insert_identity.sql rename to src/core/SQL/PostgreSQL/16/insert_identity.sql diff --git a/src/core/SQL/PostgreSQL/15/insert_message.sql b/src/core/SQL/PostgreSQL/16/insert_message.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/insert_message.sql rename to src/core/SQL/PostgreSQL/16/insert_message.sql diff --git a/src/core/SQL/PostgreSQL/15/insert_network.sql b/src/core/SQL/PostgreSQL/16/insert_network.sql similarity index 79% rename from src/core/SQL/PostgreSQL/15/insert_network.sql rename to src/core/SQL/PostgreSQL/16/insert_network.sql index 4f94b434..56fbef8e 100644 --- a/src/core/SQL/PostgreSQL/15/insert_network.sql +++ b/src/core/SQL/PostgreSQL/16/insert_network.sql @@ -1,3 +1,3 @@ -INSERT INTO network (userid, networkname, identityid, servercodec, encodingcodec, decodingcodec, userandomserver, perform, useautoidentify, autoidentifyservice, autoidentifypassword, useautoreconnect, autoreconnectinterval, autoreconnectretries, unlimitedconnectretries, rejoinchannels) -VALUES (:userid, :networkname, :identityid, :servercodec, :encodingcodec, :decodingcodec, :userandomserver, :perform, :useautoidentify, :autoidentifyservice, :autoidentifypassword, :useautoreconnect, :autoreconnectinterval, :autoreconnectretries, :unlimitedconnectretries, :rejoinchannels) +INSERT INTO network (userid, networkname, identityid, servercodec, encodingcodec, decodingcodec, userandomserver, perform, useautoidentify, autoidentifyservice, autoidentifypassword, useautoreconnect, autoreconnectinterval, autoreconnectretries, unlimitedconnectretries, rejoinchannels, usesasl, saslaccount, saslpassword) +VALUES (:userid, :networkname, :identityid, :servercodec, :encodingcodec, :decodingcodec, :userandomserver, :perform, :useautoidentify, :autoidentifyservice, :autoidentifypassword, :useautoreconnect, :autoreconnectinterval, :autoreconnectretries, :unlimitedconnectretries, :rejoinchannels, :usesasl, :saslaccount, :saslpassword) RETURNING networkid diff --git a/src/core/SQL/PostgreSQL/15/insert_nick.sql b/src/core/SQL/PostgreSQL/16/insert_nick.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/insert_nick.sql rename to src/core/SQL/PostgreSQL/16/insert_nick.sql diff --git a/src/core/SQL/PostgreSQL/15/insert_quasseluser.sql b/src/core/SQL/PostgreSQL/16/insert_quasseluser.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/insert_quasseluser.sql rename to src/core/SQL/PostgreSQL/16/insert_quasseluser.sql diff --git a/src/core/SQL/PostgreSQL/15/insert_sender.sql b/src/core/SQL/PostgreSQL/16/insert_sender.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/insert_sender.sql rename to src/core/SQL/PostgreSQL/16/insert_sender.sql diff --git a/src/core/SQL/PostgreSQL/15/insert_server.sql b/src/core/SQL/PostgreSQL/16/insert_server.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/insert_server.sql rename to src/core/SQL/PostgreSQL/16/insert_server.sql diff --git a/src/core/SQL/PostgreSQL/15/insert_user_setting.sql b/src/core/SQL/PostgreSQL/16/insert_user_setting.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/insert_user_setting.sql rename to src/core/SQL/PostgreSQL/16/insert_user_setting.sql diff --git a/src/core/SQL/PostgreSQL/15/migrate_write_backlog.sql b/src/core/SQL/PostgreSQL/16/migrate_write_backlog.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/migrate_write_backlog.sql rename to src/core/SQL/PostgreSQL/16/migrate_write_backlog.sql diff --git a/src/core/SQL/PostgreSQL/15/migrate_write_buffer.sql b/src/core/SQL/PostgreSQL/16/migrate_write_buffer.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/migrate_write_buffer.sql rename to src/core/SQL/PostgreSQL/16/migrate_write_buffer.sql diff --git a/src/core/SQL/PostgreSQL/15/migrate_write_identity.sql b/src/core/SQL/PostgreSQL/16/migrate_write_identity.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/migrate_write_identity.sql rename to src/core/SQL/PostgreSQL/16/migrate_write_identity.sql diff --git a/src/core/SQL/PostgreSQL/15/migrate_write_identity_nick.sql b/src/core/SQL/PostgreSQL/16/migrate_write_identity_nick.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/migrate_write_identity_nick.sql rename to src/core/SQL/PostgreSQL/16/migrate_write_identity_nick.sql diff --git a/src/core/SQL/PostgreSQL/15/migrate_write_ircserver.sql b/src/core/SQL/PostgreSQL/16/migrate_write_ircserver.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/migrate_write_ircserver.sql rename to src/core/SQL/PostgreSQL/16/migrate_write_ircserver.sql diff --git a/src/core/SQL/PostgreSQL/15/migrate_write_network.sql b/src/core/SQL/PostgreSQL/16/migrate_write_network.sql similarity index 79% rename from src/core/SQL/PostgreSQL/15/migrate_write_network.sql rename to src/core/SQL/PostgreSQL/16/migrate_write_network.sql index eeae51ae..45576eeb 100644 --- a/src/core/SQL/PostgreSQL/15/migrate_write_network.sql +++ b/src/core/SQL/PostgreSQL/16/migrate_write_network.sql @@ -1,2 +1,2 @@ -INSERT INTO network (networkid, userid, networkname, identityid, encodingcodec, decodingcodec, servercodec, userandomserver, perform, useautoidentify, autoidentifyservice, autoidentifypassword, useautoreconnect, autoreconnectinterval, autoreconnectretries, unlimitedconnectretries, rejoinchannels, connected, usermode, awaymessage, attachperform, detachperform) -VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) +INSERT INTO network (networkid, userid, networkname, identityid, encodingcodec, decodingcodec, servercodec, userandomserver, perform, useautoidentify, autoidentifyservice, autoidentifypassword, useautoreconnect, autoreconnectinterval, autoreconnectretries, unlimitedconnectretries, rejoinchannels, connected, usermode, awaymessage, attachperform, detachperform, usesasl, saslaccount, saslpassword) +VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) diff --git a/src/core/SQL/PostgreSQL/15/migrate_write_quasseluser.sql b/src/core/SQL/PostgreSQL/16/migrate_write_quasseluser.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/migrate_write_quasseluser.sql rename to src/core/SQL/PostgreSQL/16/migrate_write_quasseluser.sql diff --git a/src/core/SQL/PostgreSQL/15/migrate_write_sender.sql b/src/core/SQL/PostgreSQL/16/migrate_write_sender.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/migrate_write_sender.sql rename to src/core/SQL/PostgreSQL/16/migrate_write_sender.sql diff --git a/src/core/SQL/PostgreSQL/15/migrate_write_usersetting.sql b/src/core/SQL/PostgreSQL/16/migrate_write_usersetting.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/migrate_write_usersetting.sql rename to src/core/SQL/PostgreSQL/16/migrate_write_usersetting.sql diff --git a/src/core/SQL/PostgreSQL/15/select_authuser.sql b/src/core/SQL/PostgreSQL/16/select_authuser.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_authuser.sql rename to src/core/SQL/PostgreSQL/16/select_authuser.sql diff --git a/src/core/SQL/PostgreSQL/15/select_bufferByName.sql b/src/core/SQL/PostgreSQL/16/select_bufferByName.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_bufferByName.sql rename to src/core/SQL/PostgreSQL/16/select_bufferByName.sql diff --git a/src/core/SQL/PostgreSQL/15/select_bufferExists.sql b/src/core/SQL/PostgreSQL/16/select_bufferExists.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_bufferExists.sql rename to src/core/SQL/PostgreSQL/16/select_bufferExists.sql diff --git a/src/core/SQL/PostgreSQL/15/select_buffer_by_id.sql b/src/core/SQL/PostgreSQL/16/select_buffer_by_id.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_buffer_by_id.sql rename to src/core/SQL/PostgreSQL/16/select_buffer_by_id.sql diff --git a/src/core/SQL/PostgreSQL/15/select_buffer_lastseen_messages.sql b/src/core/SQL/PostgreSQL/16/select_buffer_lastseen_messages.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_buffer_lastseen_messages.sql rename to src/core/SQL/PostgreSQL/16/select_buffer_lastseen_messages.sql diff --git a/src/core/SQL/PostgreSQL/15/select_buffer_markerlinemsgids.sql b/src/core/SQL/PostgreSQL/16/select_buffer_markerlinemsgids.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_buffer_markerlinemsgids.sql rename to src/core/SQL/PostgreSQL/16/select_buffer_markerlinemsgids.sql diff --git a/src/core/SQL/PostgreSQL/15/select_buffers.sql b/src/core/SQL/PostgreSQL/16/select_buffers.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_buffers.sql rename to src/core/SQL/PostgreSQL/16/select_buffers.sql diff --git a/src/core/SQL/PostgreSQL/15/select_buffers_for_network.sql b/src/core/SQL/PostgreSQL/16/select_buffers_for_network.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_buffers_for_network.sql rename to src/core/SQL/PostgreSQL/16/select_buffers_for_network.sql diff --git a/src/core/SQL/PostgreSQL/15/select_checkidentity.sql b/src/core/SQL/PostgreSQL/16/select_checkidentity.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_checkidentity.sql rename to src/core/SQL/PostgreSQL/16/select_checkidentity.sql diff --git a/src/core/SQL/PostgreSQL/15/select_connected_networks.sql b/src/core/SQL/PostgreSQL/16/select_connected_networks.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_connected_networks.sql rename to src/core/SQL/PostgreSQL/16/select_connected_networks.sql diff --git a/src/core/SQL/PostgreSQL/15/select_identities.sql b/src/core/SQL/PostgreSQL/16/select_identities.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_identities.sql rename to src/core/SQL/PostgreSQL/16/select_identities.sql diff --git a/src/core/SQL/PostgreSQL/15/select_internaluser.sql b/src/core/SQL/PostgreSQL/16/select_internaluser.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_internaluser.sql rename to src/core/SQL/PostgreSQL/16/select_internaluser.sql diff --git a/src/core/SQL/PostgreSQL/15/select_messages.sql b/src/core/SQL/PostgreSQL/16/select_messages.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_messages.sql rename to src/core/SQL/PostgreSQL/16/select_messages.sql diff --git a/src/core/SQL/PostgreSQL/15/select_messagesAll.sql b/src/core/SQL/PostgreSQL/16/select_messagesAll.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_messagesAll.sql rename to src/core/SQL/PostgreSQL/16/select_messagesAll.sql diff --git a/src/core/SQL/PostgreSQL/15/select_messagesAllNew.sql b/src/core/SQL/PostgreSQL/16/select_messagesAllNew.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_messagesAllNew.sql rename to src/core/SQL/PostgreSQL/16/select_messagesAllNew.sql diff --git a/src/core/SQL/PostgreSQL/15/select_messagesNewerThan.sql b/src/core/SQL/PostgreSQL/16/select_messagesNewerThan.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_messagesNewerThan.sql rename to src/core/SQL/PostgreSQL/16/select_messagesNewerThan.sql diff --git a/src/core/SQL/PostgreSQL/15/select_messagesRange.sql b/src/core/SQL/PostgreSQL/16/select_messagesRange.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_messagesRange.sql rename to src/core/SQL/PostgreSQL/16/select_messagesRange.sql diff --git a/src/core/SQL/PostgreSQL/15/select_networkExists.sql b/src/core/SQL/PostgreSQL/16/select_networkExists.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_networkExists.sql rename to src/core/SQL/PostgreSQL/16/select_networkExists.sql diff --git a/src/core/SQL/PostgreSQL/15/select_network_awaymsg.sql b/src/core/SQL/PostgreSQL/16/select_network_awaymsg.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_network_awaymsg.sql rename to src/core/SQL/PostgreSQL/16/select_network_awaymsg.sql diff --git a/src/core/SQL/PostgreSQL/15/select_network_usermode.sql b/src/core/SQL/PostgreSQL/16/select_network_usermode.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_network_usermode.sql rename to src/core/SQL/PostgreSQL/16/select_network_usermode.sql diff --git a/src/core/SQL/SQLite/16/select_networks_for_user.sql b/src/core/SQL/PostgreSQL/16/select_networks_for_user.sql similarity index 69% rename from src/core/SQL/SQLite/16/select_networks_for_user.sql rename to src/core/SQL/PostgreSQL/16/select_networks_for_user.sql index 08855c93..9bef4054 100644 --- a/src/core/SQL/SQLite/16/select_networks_for_user.sql +++ b/src/core/SQL/PostgreSQL/16/select_networks_for_user.sql @@ -1,5 +1,6 @@ SELECT networkid, networkname, identityid, servercodec, encodingcodec, decodingcodec, userandomserver, perform, useautoidentify, autoidentifyservice, autoidentifypassword, - useautoreconnect, autoreconnectinterval, autoreconnectretries, unlimitedconnectretries, rejoinchannels + useautoreconnect, autoreconnectinterval, autoreconnectretries, unlimitedconnectretries, rejoinchannels, + usesasl, saslaccount, saslpassword FROM network -WHERE userid = :userid \ No newline at end of file +WHERE userid = :userid diff --git a/src/core/SQL/PostgreSQL/15/select_nicks.sql b/src/core/SQL/PostgreSQL/16/select_nicks.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_nicks.sql rename to src/core/SQL/PostgreSQL/16/select_nicks.sql diff --git a/src/core/SQL/PostgreSQL/15/select_persistent_channels.sql b/src/core/SQL/PostgreSQL/16/select_persistent_channels.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_persistent_channels.sql rename to src/core/SQL/PostgreSQL/16/select_persistent_channels.sql diff --git a/src/core/SQL/PostgreSQL/15/select_servers_for_network.sql b/src/core/SQL/PostgreSQL/16/select_servers_for_network.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_servers_for_network.sql rename to src/core/SQL/PostgreSQL/16/select_servers_for_network.sql diff --git a/src/core/SQL/PostgreSQL/15/select_user_setting.sql b/src/core/SQL/PostgreSQL/16/select_user_setting.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_user_setting.sql rename to src/core/SQL/PostgreSQL/16/select_user_setting.sql diff --git a/src/core/SQL/PostgreSQL/15/select_userid.sql b/src/core/SQL/PostgreSQL/16/select_userid.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/select_userid.sql rename to src/core/SQL/PostgreSQL/16/select_userid.sql diff --git a/src/core/SQL/PostgreSQL/15/setup_000_quasseluser.sql b/src/core/SQL/PostgreSQL/16/setup_000_quasseluser.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/setup_000_quasseluser.sql rename to src/core/SQL/PostgreSQL/16/setup_000_quasseluser.sql diff --git a/src/core/SQL/PostgreSQL/15/setup_010_sender.sql b/src/core/SQL/PostgreSQL/16/setup_010_sender.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/setup_010_sender.sql rename to src/core/SQL/PostgreSQL/16/setup_010_sender.sql diff --git a/src/core/SQL/PostgreSQL/15/setup_020_identity.sql b/src/core/SQL/PostgreSQL/16/setup_020_identity.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/setup_020_identity.sql rename to src/core/SQL/PostgreSQL/16/setup_020_identity.sql diff --git a/src/core/SQL/PostgreSQL/15/setup_030_identity_nick.sql b/src/core/SQL/PostgreSQL/16/setup_030_identity_nick.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/setup_030_identity_nick.sql rename to src/core/SQL/PostgreSQL/16/setup_030_identity_nick.sql diff --git a/src/core/SQL/PostgreSQL/15/setup_040_network.sql b/src/core/SQL/PostgreSQL/16/setup_040_network.sql similarity index 91% rename from src/core/SQL/PostgreSQL/15/setup_040_network.sql rename to src/core/SQL/PostgreSQL/16/setup_040_network.sql index 87f48b44..8515c95f 100644 --- a/src/core/SQL/PostgreSQL/15/setup_040_network.sql +++ b/src/core/SQL/PostgreSQL/16/setup_040_network.sql @@ -11,6 +11,9 @@ CREATE TABLE network ( useautoidentify boolean NOT NULL DEFAULT FALSE, autoidentifyservice varchar(128), autoidentifypassword varchar(128), + usesasl boolean NOT NULL DEFAULT FALSE, + saslaccount varchar(128), + saslpassword varchar(128), useautoreconnect boolean NOT NULL DEFAULT TRUE, autoreconnectinterval integer NOT NULL DEFAULT 0, autoreconnectretries integer NOT NULL DEFAULT 0, diff --git a/src/core/SQL/PostgreSQL/15/setup_050_buffer.sql b/src/core/SQL/PostgreSQL/16/setup_050_buffer.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/setup_050_buffer.sql rename to src/core/SQL/PostgreSQL/16/setup_050_buffer.sql diff --git a/src/core/SQL/PostgreSQL/15/setup_060_backlog.sql b/src/core/SQL/PostgreSQL/16/setup_060_backlog.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/setup_060_backlog.sql rename to src/core/SQL/PostgreSQL/16/setup_060_backlog.sql diff --git a/src/core/SQL/PostgreSQL/15/setup_070_coreinfo.sql b/src/core/SQL/PostgreSQL/16/setup_070_coreinfo.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/setup_070_coreinfo.sql rename to src/core/SQL/PostgreSQL/16/setup_070_coreinfo.sql diff --git a/src/core/SQL/PostgreSQL/15/setup_080_ircservers.sql b/src/core/SQL/PostgreSQL/16/setup_080_ircservers.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/setup_080_ircservers.sql rename to src/core/SQL/PostgreSQL/16/setup_080_ircservers.sql diff --git a/src/core/SQL/PostgreSQL/15/setup_090_backlog_idx.sql b/src/core/SQL/PostgreSQL/16/setup_090_backlog_idx.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/setup_090_backlog_idx.sql rename to src/core/SQL/PostgreSQL/16/setup_090_backlog_idx.sql diff --git a/src/core/SQL/PostgreSQL/15/setup_100_user_setting.sql b/src/core/SQL/PostgreSQL/16/setup_100_user_setting.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/setup_100_user_setting.sql rename to src/core/SQL/PostgreSQL/16/setup_100_user_setting.sql diff --git a/src/core/SQL/PostgreSQL/15/setup_110_alter_sender_seq.sql b/src/core/SQL/PostgreSQL/16/setup_110_alter_sender_seq.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/setup_110_alter_sender_seq.sql rename to src/core/SQL/PostgreSQL/16/setup_110_alter_sender_seq.sql diff --git a/src/core/SQL/PostgreSQL/15/setup_120_alter_messageid_seq.sql b/src/core/SQL/PostgreSQL/16/setup_120_alter_messageid_seq.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/setup_120_alter_messageid_seq.sql rename to src/core/SQL/PostgreSQL/16/setup_120_alter_messageid_seq.sql diff --git a/src/core/SQL/PostgreSQL/15/update_backlog_bufferid.sql b/src/core/SQL/PostgreSQL/16/update_backlog_bufferid.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/update_backlog_bufferid.sql rename to src/core/SQL/PostgreSQL/16/update_backlog_bufferid.sql diff --git a/src/core/SQL/PostgreSQL/15/update_buffer_lastseen.sql b/src/core/SQL/PostgreSQL/16/update_buffer_lastseen.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/update_buffer_lastseen.sql rename to src/core/SQL/PostgreSQL/16/update_buffer_lastseen.sql diff --git a/src/core/SQL/PostgreSQL/15/update_buffer_markerlinemsgid.sql b/src/core/SQL/PostgreSQL/16/update_buffer_markerlinemsgid.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/update_buffer_markerlinemsgid.sql rename to src/core/SQL/PostgreSQL/16/update_buffer_markerlinemsgid.sql diff --git a/src/core/SQL/PostgreSQL/15/update_buffer_name.sql b/src/core/SQL/PostgreSQL/16/update_buffer_name.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/update_buffer_name.sql rename to src/core/SQL/PostgreSQL/16/update_buffer_name.sql diff --git a/src/core/SQL/PostgreSQL/15/update_buffer_persistent_channel.sql b/src/core/SQL/PostgreSQL/16/update_buffer_persistent_channel.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/update_buffer_persistent_channel.sql rename to src/core/SQL/PostgreSQL/16/update_buffer_persistent_channel.sql diff --git a/src/core/SQL/PostgreSQL/15/update_buffer_set_channel_key.sql b/src/core/SQL/PostgreSQL/16/update_buffer_set_channel_key.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/update_buffer_set_channel_key.sql rename to src/core/SQL/PostgreSQL/16/update_buffer_set_channel_key.sql diff --git a/src/core/SQL/PostgreSQL/15/update_identity.sql b/src/core/SQL/PostgreSQL/16/update_identity.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/update_identity.sql rename to src/core/SQL/PostgreSQL/16/update_identity.sql diff --git a/src/core/SQL/PostgreSQL/15/update_network.sql b/src/core/SQL/PostgreSQL/16/update_network.sql similarity index 83% rename from src/core/SQL/PostgreSQL/15/update_network.sql rename to src/core/SQL/PostgreSQL/16/update_network.sql index 8d5a4628..a000f61e 100644 --- a/src/core/SQL/PostgreSQL/15/update_network.sql +++ b/src/core/SQL/PostgreSQL/16/update_network.sql @@ -13,5 +13,8 @@ useautoreconnect = :useautoreconnect, autoreconnectinterval = :autoreconnectinterval, autoreconnectretries = :autoreconnectretries, unlimitedconnectretries = :unlimitedconnectretries, -rejoinchannels = :rejoinchannels +rejoinchannels = :rejoinchannels, +usesasl = :usesasl, +saslaccount = :saslaccount, +saslpassword = :saslpassword WHERE networkid = :networkid diff --git a/src/core/SQL/PostgreSQL/15/update_network_connected.sql b/src/core/SQL/PostgreSQL/16/update_network_connected.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/update_network_connected.sql rename to src/core/SQL/PostgreSQL/16/update_network_connected.sql diff --git a/src/core/SQL/PostgreSQL/15/update_network_set_awaymsg.sql b/src/core/SQL/PostgreSQL/16/update_network_set_awaymsg.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/update_network_set_awaymsg.sql rename to src/core/SQL/PostgreSQL/16/update_network_set_awaymsg.sql diff --git a/src/core/SQL/PostgreSQL/15/update_network_set_usermode.sql b/src/core/SQL/PostgreSQL/16/update_network_set_usermode.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/update_network_set_usermode.sql rename to src/core/SQL/PostgreSQL/16/update_network_set_usermode.sql diff --git a/src/core/SQL/PostgreSQL/15/update_user_setting.sql b/src/core/SQL/PostgreSQL/16/update_user_setting.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/update_user_setting.sql rename to src/core/SQL/PostgreSQL/16/update_user_setting.sql diff --git a/src/core/SQL/PostgreSQL/15/update_username.sql b/src/core/SQL/PostgreSQL/16/update_username.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/update_username.sql rename to src/core/SQL/PostgreSQL/16/update_username.sql diff --git a/src/core/SQL/PostgreSQL/15/update_userpassword.sql b/src/core/SQL/PostgreSQL/16/update_userpassword.sql similarity index 100% rename from src/core/SQL/PostgreSQL/15/update_userpassword.sql rename to src/core/SQL/PostgreSQL/16/update_userpassword.sql diff --git a/src/core/SQL/PostgreSQL/16/upgrade_000_alter_network_add_sasl.sql b/src/core/SQL/PostgreSQL/16/upgrade_000_alter_network_add_sasl.sql new file mode 100644 index 00000000..62b75beb --- /dev/null +++ b/src/core/SQL/PostgreSQL/16/upgrade_000_alter_network_add_sasl.sql @@ -0,0 +1,4 @@ +ALTER TABLE network +ADD COLUMN usesasl boolean NOT NULL DEFAULT FALSE, +ADD COLUMN saslaccount varchar(128), +ADD COLUMN saslpassword varchar(128) diff --git a/src/core/SQL/SQLite/16/delete_backlog_by_uid.sql b/src/core/SQL/SQLite/17/delete_backlog_by_uid.sql similarity index 100% rename from src/core/SQL/SQLite/16/delete_backlog_by_uid.sql rename to src/core/SQL/SQLite/17/delete_backlog_by_uid.sql diff --git a/src/core/SQL/SQLite/16/delete_backlog_for_buffer.sql b/src/core/SQL/SQLite/17/delete_backlog_for_buffer.sql similarity index 100% rename from src/core/SQL/SQLite/16/delete_backlog_for_buffer.sql rename to src/core/SQL/SQLite/17/delete_backlog_for_buffer.sql diff --git a/src/core/SQL/SQLite/16/delete_backlog_for_network.sql b/src/core/SQL/SQLite/17/delete_backlog_for_network.sql similarity index 100% rename from src/core/SQL/SQLite/16/delete_backlog_for_network.sql rename to src/core/SQL/SQLite/17/delete_backlog_for_network.sql diff --git a/src/core/SQL/SQLite/16/delete_buffer_for_bufferid.sql b/src/core/SQL/SQLite/17/delete_buffer_for_bufferid.sql similarity index 100% rename from src/core/SQL/SQLite/16/delete_buffer_for_bufferid.sql rename to src/core/SQL/SQLite/17/delete_buffer_for_bufferid.sql diff --git a/src/core/SQL/SQLite/16/delete_buffers_by_uid.sql b/src/core/SQL/SQLite/17/delete_buffers_by_uid.sql similarity index 100% rename from src/core/SQL/SQLite/16/delete_buffers_by_uid.sql rename to src/core/SQL/SQLite/17/delete_buffers_by_uid.sql diff --git a/src/core/SQL/SQLite/16/delete_buffers_for_network.sql b/src/core/SQL/SQLite/17/delete_buffers_for_network.sql similarity index 100% rename from src/core/SQL/SQLite/16/delete_buffers_for_network.sql rename to src/core/SQL/SQLite/17/delete_buffers_for_network.sql diff --git a/src/core/SQL/SQLite/16/delete_identity.sql b/src/core/SQL/SQLite/17/delete_identity.sql similarity index 100% rename from src/core/SQL/SQLite/16/delete_identity.sql rename to src/core/SQL/SQLite/17/delete_identity.sql diff --git a/src/core/SQL/SQLite/16/delete_ircservers_for_network.sql b/src/core/SQL/SQLite/17/delete_ircservers_for_network.sql similarity index 100% rename from src/core/SQL/SQLite/16/delete_ircservers_for_network.sql rename to src/core/SQL/SQLite/17/delete_ircservers_for_network.sql diff --git a/src/core/SQL/SQLite/16/delete_network.sql b/src/core/SQL/SQLite/17/delete_network.sql similarity index 100% rename from src/core/SQL/SQLite/16/delete_network.sql rename to src/core/SQL/SQLite/17/delete_network.sql diff --git a/src/core/SQL/SQLite/16/delete_networks_by_uid.sql b/src/core/SQL/SQLite/17/delete_networks_by_uid.sql similarity index 100% rename from src/core/SQL/SQLite/16/delete_networks_by_uid.sql rename to src/core/SQL/SQLite/17/delete_networks_by_uid.sql diff --git a/src/core/SQL/SQLite/16/delete_nicks.sql b/src/core/SQL/SQLite/17/delete_nicks.sql similarity index 100% rename from src/core/SQL/SQLite/16/delete_nicks.sql rename to src/core/SQL/SQLite/17/delete_nicks.sql diff --git a/src/core/SQL/SQLite/16/delete_quasseluser.sql b/src/core/SQL/SQLite/17/delete_quasseluser.sql similarity index 100% rename from src/core/SQL/SQLite/16/delete_quasseluser.sql rename to src/core/SQL/SQLite/17/delete_quasseluser.sql diff --git a/src/core/SQL/SQLite/16/insert_buffer.sql b/src/core/SQL/SQLite/17/insert_buffer.sql similarity index 100% rename from src/core/SQL/SQLite/16/insert_buffer.sql rename to src/core/SQL/SQLite/17/insert_buffer.sql diff --git a/src/core/SQL/SQLite/16/insert_identity.sql b/src/core/SQL/SQLite/17/insert_identity.sql similarity index 100% rename from src/core/SQL/SQLite/16/insert_identity.sql rename to src/core/SQL/SQLite/17/insert_identity.sql diff --git a/src/core/SQL/SQLite/16/insert_message.sql b/src/core/SQL/SQLite/17/insert_message.sql similarity index 100% rename from src/core/SQL/SQLite/16/insert_message.sql rename to src/core/SQL/SQLite/17/insert_message.sql diff --git a/src/core/SQL/SQLite/16/insert_network.sql b/src/core/SQL/SQLite/17/insert_network.sql similarity index 79% rename from src/core/SQL/SQLite/16/insert_network.sql rename to src/core/SQL/SQLite/17/insert_network.sql index c64cbe12..4d9ff015 100644 --- a/src/core/SQL/SQLite/16/insert_network.sql +++ b/src/core/SQL/SQLite/17/insert_network.sql @@ -1,4 +1,4 @@ INSERT INTO network (userid, networkname, identityid, servercodec, encodingcodec, decodingcodec, userandomserver, - perform, useautoidentify, autoidentifyservice, autoidentifypassword, useautoreconnect, autoreconnectinterval, autoreconnectretries, unlimitedconnectretries, rejoinchannels) + perform, useautoidentify, autoidentifyservice, autoidentifypassword, useautoreconnect, autoreconnectinterval, autoreconnectretries, unlimitedconnectretries, rejoinchannels, usesasl, saslaccount, saslpassword) VALUES (:userid, :networkname, :identityid, :servercodec, :encodingcodec, :decodingcodec, :userandomserver, - :perform, :useautoidentify, :autoidentifyservice, :autoidentifypassword, :useautoreconnect, :autoreconnectinterval, :autoreconnectretries, :unlimitedconnectretries, :rejoinchannels) + :perform, :useautoidentify, :autoidentifyservice, :autoidentifypassword, :useautoreconnect, :autoreconnectinterval, :autoreconnectretries, :unlimitedconnectretries, :rejoinchannels, :usesasl, :saslaccount, :saslpassword) diff --git a/src/core/SQL/SQLite/16/insert_nick.sql b/src/core/SQL/SQLite/17/insert_nick.sql similarity index 100% rename from src/core/SQL/SQLite/16/insert_nick.sql rename to src/core/SQL/SQLite/17/insert_nick.sql diff --git a/src/core/SQL/SQLite/16/insert_quasseluser.sql b/src/core/SQL/SQLite/17/insert_quasseluser.sql similarity index 100% rename from src/core/SQL/SQLite/16/insert_quasseluser.sql rename to src/core/SQL/SQLite/17/insert_quasseluser.sql diff --git a/src/core/SQL/SQLite/16/insert_sender.sql b/src/core/SQL/SQLite/17/insert_sender.sql similarity index 100% rename from src/core/SQL/SQLite/16/insert_sender.sql rename to src/core/SQL/SQLite/17/insert_sender.sql diff --git a/src/core/SQL/SQLite/16/insert_server.sql b/src/core/SQL/SQLite/17/insert_server.sql similarity index 100% rename from src/core/SQL/SQLite/16/insert_server.sql rename to src/core/SQL/SQLite/17/insert_server.sql diff --git a/src/core/SQL/SQLite/16/insert_user_setting.sql b/src/core/SQL/SQLite/17/insert_user_setting.sql similarity index 100% rename from src/core/SQL/SQLite/16/insert_user_setting.sql rename to src/core/SQL/SQLite/17/insert_user_setting.sql diff --git a/src/core/SQL/SQLite/16/migrate_read_backlog.sql b/src/core/SQL/SQLite/17/migrate_read_backlog.sql similarity index 100% rename from src/core/SQL/SQLite/16/migrate_read_backlog.sql rename to src/core/SQL/SQLite/17/migrate_read_backlog.sql diff --git a/src/core/SQL/SQLite/16/migrate_read_buffer.sql b/src/core/SQL/SQLite/17/migrate_read_buffer.sql similarity index 100% rename from src/core/SQL/SQLite/16/migrate_read_buffer.sql rename to src/core/SQL/SQLite/17/migrate_read_buffer.sql diff --git a/src/core/SQL/SQLite/16/migrate_read_identity.sql b/src/core/SQL/SQLite/17/migrate_read_identity.sql similarity index 100% rename from src/core/SQL/SQLite/16/migrate_read_identity.sql rename to src/core/SQL/SQLite/17/migrate_read_identity.sql diff --git a/src/core/SQL/SQLite/16/migrate_read_identity_nick.sql b/src/core/SQL/SQLite/17/migrate_read_identity_nick.sql similarity index 100% rename from src/core/SQL/SQLite/16/migrate_read_identity_nick.sql rename to src/core/SQL/SQLite/17/migrate_read_identity_nick.sql diff --git a/src/core/SQL/SQLite/16/migrate_read_ircserver.sql b/src/core/SQL/SQLite/17/migrate_read_ircserver.sql similarity index 100% rename from src/core/SQL/SQLite/16/migrate_read_ircserver.sql rename to src/core/SQL/SQLite/17/migrate_read_ircserver.sql diff --git a/src/core/SQL/SQLite/16/migrate_read_network.sql b/src/core/SQL/SQLite/17/migrate_read_network.sql similarity index 100% rename from src/core/SQL/SQLite/16/migrate_read_network.sql rename to src/core/SQL/SQLite/17/migrate_read_network.sql diff --git a/src/core/SQL/SQLite/16/migrate_read_quasseluser.sql b/src/core/SQL/SQLite/17/migrate_read_quasseluser.sql similarity index 100% rename from src/core/SQL/SQLite/16/migrate_read_quasseluser.sql rename to src/core/SQL/SQLite/17/migrate_read_quasseluser.sql diff --git a/src/core/SQL/SQLite/16/migrate_read_sender.sql b/src/core/SQL/SQLite/17/migrate_read_sender.sql similarity index 100% rename from src/core/SQL/SQLite/16/migrate_read_sender.sql rename to src/core/SQL/SQLite/17/migrate_read_sender.sql diff --git a/src/core/SQL/SQLite/16/migrate_read_usersetting.sql b/src/core/SQL/SQLite/17/migrate_read_usersetting.sql similarity index 100% rename from src/core/SQL/SQLite/16/migrate_read_usersetting.sql rename to src/core/SQL/SQLite/17/migrate_read_usersetting.sql diff --git a/src/core/SQL/SQLite/16/select_authuser.sql b/src/core/SQL/SQLite/17/select_authuser.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_authuser.sql rename to src/core/SQL/SQLite/17/select_authuser.sql diff --git a/src/core/SQL/SQLite/16/select_bufferByName.sql b/src/core/SQL/SQLite/17/select_bufferByName.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_bufferByName.sql rename to src/core/SQL/SQLite/17/select_bufferByName.sql diff --git a/src/core/SQL/SQLite/16/select_bufferExists.sql b/src/core/SQL/SQLite/17/select_bufferExists.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_bufferExists.sql rename to src/core/SQL/SQLite/17/select_bufferExists.sql diff --git a/src/core/SQL/SQLite/16/select_buffer_by_id.sql b/src/core/SQL/SQLite/17/select_buffer_by_id.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_buffer_by_id.sql rename to src/core/SQL/SQLite/17/select_buffer_by_id.sql diff --git a/src/core/SQL/SQLite/16/select_buffer_lastseen_messages.sql b/src/core/SQL/SQLite/17/select_buffer_lastseen_messages.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_buffer_lastseen_messages.sql rename to src/core/SQL/SQLite/17/select_buffer_lastseen_messages.sql diff --git a/src/core/SQL/SQLite/16/select_buffer_markerlinemsgids.sql b/src/core/SQL/SQLite/17/select_buffer_markerlinemsgids.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_buffer_markerlinemsgids.sql rename to src/core/SQL/SQLite/17/select_buffer_markerlinemsgids.sql diff --git a/src/core/SQL/SQLite/16/select_buffers.sql b/src/core/SQL/SQLite/17/select_buffers.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_buffers.sql rename to src/core/SQL/SQLite/17/select_buffers.sql diff --git a/src/core/SQL/SQLite/16/select_buffers_for_merge.sql b/src/core/SQL/SQLite/17/select_buffers_for_merge.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_buffers_for_merge.sql rename to src/core/SQL/SQLite/17/select_buffers_for_merge.sql diff --git a/src/core/SQL/SQLite/16/select_buffers_for_network.sql b/src/core/SQL/SQLite/17/select_buffers_for_network.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_buffers_for_network.sql rename to src/core/SQL/SQLite/17/select_buffers_for_network.sql diff --git a/src/core/SQL/SQLite/16/select_checkidentity.sql b/src/core/SQL/SQLite/17/select_checkidentity.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_checkidentity.sql rename to src/core/SQL/SQLite/17/select_checkidentity.sql diff --git a/src/core/SQL/SQLite/16/select_connected_networks.sql b/src/core/SQL/SQLite/17/select_connected_networks.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_connected_networks.sql rename to src/core/SQL/SQLite/17/select_connected_networks.sql diff --git a/src/core/SQL/SQLite/16/select_identities.sql b/src/core/SQL/SQLite/17/select_identities.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_identities.sql rename to src/core/SQL/SQLite/17/select_identities.sql diff --git a/src/core/SQL/SQLite/16/select_internaluser.sql b/src/core/SQL/SQLite/17/select_internaluser.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_internaluser.sql rename to src/core/SQL/SQLite/17/select_internaluser.sql diff --git a/src/core/SQL/SQLite/16/select_messages.sql b/src/core/SQL/SQLite/17/select_messages.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_messages.sql rename to src/core/SQL/SQLite/17/select_messages.sql diff --git a/src/core/SQL/SQLite/16/select_messagesAll.sql b/src/core/SQL/SQLite/17/select_messagesAll.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_messagesAll.sql rename to src/core/SQL/SQLite/17/select_messagesAll.sql diff --git a/src/core/SQL/SQLite/16/select_messagesAllNew.sql b/src/core/SQL/SQLite/17/select_messagesAllNew.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_messagesAllNew.sql rename to src/core/SQL/SQLite/17/select_messagesAllNew.sql diff --git a/src/core/SQL/SQLite/16/select_messagesNewerThan.sql b/src/core/SQL/SQLite/17/select_messagesNewerThan.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_messagesNewerThan.sql rename to src/core/SQL/SQLite/17/select_messagesNewerThan.sql diff --git a/src/core/SQL/SQLite/16/select_messagesNewestK.sql b/src/core/SQL/SQLite/17/select_messagesNewestK.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_messagesNewestK.sql rename to src/core/SQL/SQLite/17/select_messagesNewestK.sql diff --git a/src/core/SQL/SQLite/16/select_networkExists.sql b/src/core/SQL/SQLite/17/select_networkExists.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_networkExists.sql rename to src/core/SQL/SQLite/17/select_networkExists.sql diff --git a/src/core/SQL/SQLite/16/select_network_awaymsg.sql b/src/core/SQL/SQLite/17/select_network_awaymsg.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_network_awaymsg.sql rename to src/core/SQL/SQLite/17/select_network_awaymsg.sql diff --git a/src/core/SQL/SQLite/16/select_network_usermode.sql b/src/core/SQL/SQLite/17/select_network_usermode.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_network_usermode.sql rename to src/core/SQL/SQLite/17/select_network_usermode.sql diff --git a/src/core/SQL/PostgreSQL/15/select_networks_for_user.sql b/src/core/SQL/SQLite/17/select_networks_for_user.sql similarity index 69% rename from src/core/SQL/PostgreSQL/15/select_networks_for_user.sql rename to src/core/SQL/SQLite/17/select_networks_for_user.sql index 08855c93..9bef4054 100644 --- a/src/core/SQL/PostgreSQL/15/select_networks_for_user.sql +++ b/src/core/SQL/SQLite/17/select_networks_for_user.sql @@ -1,5 +1,6 @@ SELECT networkid, networkname, identityid, servercodec, encodingcodec, decodingcodec, userandomserver, perform, useautoidentify, autoidentifyservice, autoidentifypassword, - useautoreconnect, autoreconnectinterval, autoreconnectretries, unlimitedconnectretries, rejoinchannels + useautoreconnect, autoreconnectinterval, autoreconnectretries, unlimitedconnectretries, rejoinchannels, + usesasl, saslaccount, saslpassword FROM network -WHERE userid = :userid \ No newline at end of file +WHERE userid = :userid diff --git a/src/core/SQL/SQLite/16/select_nicks.sql b/src/core/SQL/SQLite/17/select_nicks.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_nicks.sql rename to src/core/SQL/SQLite/17/select_nicks.sql diff --git a/src/core/SQL/SQLite/16/select_persistent_channels.sql b/src/core/SQL/SQLite/17/select_persistent_channels.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_persistent_channels.sql rename to src/core/SQL/SQLite/17/select_persistent_channels.sql diff --git a/src/core/SQL/SQLite/16/select_servers_for_network.sql b/src/core/SQL/SQLite/17/select_servers_for_network.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_servers_for_network.sql rename to src/core/SQL/SQLite/17/select_servers_for_network.sql diff --git a/src/core/SQL/SQLite/16/select_user_setting.sql b/src/core/SQL/SQLite/17/select_user_setting.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_user_setting.sql rename to src/core/SQL/SQLite/17/select_user_setting.sql diff --git a/src/core/SQL/SQLite/16/select_userid.sql b/src/core/SQL/SQLite/17/select_userid.sql similarity index 100% rename from src/core/SQL/SQLite/16/select_userid.sql rename to src/core/SQL/SQLite/17/select_userid.sql diff --git a/src/core/SQL/SQLite/16/setup_000_quasseluser.sql b/src/core/SQL/SQLite/17/setup_000_quasseluser.sql similarity index 100% rename from src/core/SQL/SQLite/16/setup_000_quasseluser.sql rename to src/core/SQL/SQLite/17/setup_000_quasseluser.sql diff --git a/src/core/SQL/SQLite/16/setup_010_sender.sql b/src/core/SQL/SQLite/17/setup_010_sender.sql similarity index 100% rename from src/core/SQL/SQLite/16/setup_010_sender.sql rename to src/core/SQL/SQLite/17/setup_010_sender.sql diff --git a/src/core/SQL/SQLite/16/setup_020_network.sql b/src/core/SQL/SQLite/17/setup_020_network.sql similarity index 92% rename from src/core/SQL/SQLite/16/setup_020_network.sql rename to src/core/SQL/SQLite/17/setup_020_network.sql index c4e864e1..efa1f8d1 100644 --- a/src/core/SQL/SQLite/16/setup_020_network.sql +++ b/src/core/SQL/SQLite/17/setup_020_network.sql @@ -11,6 +11,9 @@ CREATE TABLE network ( useautoidentify INTEGER NOT NULL DEFAULT 0, -- BOOL autoidentifyservice TEXT, autoidentifypassword TEXT, + usesasl INTEGER NOT NULL DEFAULT 0, -- BOOL + saslaccount TEXT, + saslpassword TEXT, useautoreconnect INTEGER NOT NULL DEFAULT 0, -- BOOL autoreconnectinterval INTEGER NOT NULL DEFAULT 0, autoreconnectretries INTEGER NOT NULL DEFAULT 0, diff --git a/src/core/SQL/SQLite/16/setup_030_buffer.sql b/src/core/SQL/SQLite/17/setup_030_buffer.sql similarity index 100% rename from src/core/SQL/SQLite/16/setup_030_buffer.sql rename to src/core/SQL/SQLite/17/setup_030_buffer.sql diff --git a/src/core/SQL/SQLite/16/setup_040_buffer_idx.sql b/src/core/SQL/SQLite/17/setup_040_buffer_idx.sql similarity index 100% rename from src/core/SQL/SQLite/16/setup_040_buffer_idx.sql rename to src/core/SQL/SQLite/17/setup_040_buffer_idx.sql diff --git a/src/core/SQL/SQLite/16/setup_050_buffer_cname_idx.sql b/src/core/SQL/SQLite/17/setup_050_buffer_cname_idx.sql similarity index 100% rename from src/core/SQL/SQLite/16/setup_050_buffer_cname_idx.sql rename to src/core/SQL/SQLite/17/setup_050_buffer_cname_idx.sql diff --git a/src/core/SQL/SQLite/16/setup_060_backlog.sql b/src/core/SQL/SQLite/17/setup_060_backlog.sql similarity index 100% rename from src/core/SQL/SQLite/16/setup_060_backlog.sql rename to src/core/SQL/SQLite/17/setup_060_backlog.sql diff --git a/src/core/SQL/SQLite/16/setup_070_coreinfo.sql b/src/core/SQL/SQLite/17/setup_070_coreinfo.sql similarity index 100% rename from src/core/SQL/SQLite/16/setup_070_coreinfo.sql rename to src/core/SQL/SQLite/17/setup_070_coreinfo.sql diff --git a/src/core/SQL/SQLite/16/setup_080_ircservers.sql b/src/core/SQL/SQLite/17/setup_080_ircservers.sql similarity index 100% rename from src/core/SQL/SQLite/16/setup_080_ircservers.sql rename to src/core/SQL/SQLite/17/setup_080_ircservers.sql diff --git a/src/core/SQL/SQLite/16/setup_090_backlog_idx.sql b/src/core/SQL/SQLite/17/setup_090_backlog_idx.sql similarity index 100% rename from src/core/SQL/SQLite/16/setup_090_backlog_idx.sql rename to src/core/SQL/SQLite/17/setup_090_backlog_idx.sql diff --git a/src/core/SQL/SQLite/16/setup_100_backlog_idx2.sql b/src/core/SQL/SQLite/17/setup_100_backlog_idx2.sql similarity index 100% rename from src/core/SQL/SQLite/16/setup_100_backlog_idx2.sql rename to src/core/SQL/SQLite/17/setup_100_backlog_idx2.sql diff --git a/src/core/SQL/SQLite/16/setup_110_buffer_user_idx.sql b/src/core/SQL/SQLite/17/setup_110_buffer_user_idx.sql similarity index 100% rename from src/core/SQL/SQLite/16/setup_110_buffer_user_idx.sql rename to src/core/SQL/SQLite/17/setup_110_buffer_user_idx.sql diff --git a/src/core/SQL/SQLite/16/setup_120_user_setting.sql b/src/core/SQL/SQLite/17/setup_120_user_setting.sql similarity index 100% rename from src/core/SQL/SQLite/16/setup_120_user_setting.sql rename to src/core/SQL/SQLite/17/setup_120_user_setting.sql diff --git a/src/core/SQL/SQLite/16/setup_130_identity.sql b/src/core/SQL/SQLite/17/setup_130_identity.sql similarity index 100% rename from src/core/SQL/SQLite/16/setup_130_identity.sql rename to src/core/SQL/SQLite/17/setup_130_identity.sql diff --git a/src/core/SQL/SQLite/16/setup_140_identity_nick.sql b/src/core/SQL/SQLite/17/setup_140_identity_nick.sql similarity index 100% rename from src/core/SQL/SQLite/16/setup_140_identity_nick.sql rename to src/core/SQL/SQLite/17/setup_140_identity_nick.sql diff --git a/src/core/SQL/SQLite/16/update_backlog_bufferid.sql b/src/core/SQL/SQLite/17/update_backlog_bufferid.sql similarity index 100% rename from src/core/SQL/SQLite/16/update_backlog_bufferid.sql rename to src/core/SQL/SQLite/17/update_backlog_bufferid.sql diff --git a/src/core/SQL/SQLite/16/update_buffer_lastseen.sql b/src/core/SQL/SQLite/17/update_buffer_lastseen.sql similarity index 100% rename from src/core/SQL/SQLite/16/update_buffer_lastseen.sql rename to src/core/SQL/SQLite/17/update_buffer_lastseen.sql diff --git a/src/core/SQL/SQLite/16/update_buffer_markerlinemsgid.sql b/src/core/SQL/SQLite/17/update_buffer_markerlinemsgid.sql similarity index 100% rename from src/core/SQL/SQLite/16/update_buffer_markerlinemsgid.sql rename to src/core/SQL/SQLite/17/update_buffer_markerlinemsgid.sql diff --git a/src/core/SQL/SQLite/16/update_buffer_name.sql b/src/core/SQL/SQLite/17/update_buffer_name.sql similarity index 100% rename from src/core/SQL/SQLite/16/update_buffer_name.sql rename to src/core/SQL/SQLite/17/update_buffer_name.sql diff --git a/src/core/SQL/SQLite/16/update_buffer_persistent_channel.sql b/src/core/SQL/SQLite/17/update_buffer_persistent_channel.sql similarity index 100% rename from src/core/SQL/SQLite/16/update_buffer_persistent_channel.sql rename to src/core/SQL/SQLite/17/update_buffer_persistent_channel.sql diff --git a/src/core/SQL/SQLite/16/update_buffer_set_channel_key.sql b/src/core/SQL/SQLite/17/update_buffer_set_channel_key.sql similarity index 100% rename from src/core/SQL/SQLite/16/update_buffer_set_channel_key.sql rename to src/core/SQL/SQLite/17/update_buffer_set_channel_key.sql diff --git a/src/core/SQL/SQLite/16/update_identity.sql b/src/core/SQL/SQLite/17/update_identity.sql similarity index 100% rename from src/core/SQL/SQLite/16/update_identity.sql rename to src/core/SQL/SQLite/17/update_identity.sql diff --git a/src/core/SQL/SQLite/16/update_network.sql b/src/core/SQL/SQLite/17/update_network.sql similarity index 83% rename from src/core/SQL/SQLite/16/update_network.sql rename to src/core/SQL/SQLite/17/update_network.sql index 21afc3f5..84c81959 100644 --- a/src/core/SQL/SQLite/16/update_network.sql +++ b/src/core/SQL/SQLite/17/update_network.sql @@ -13,5 +13,8 @@ useautoreconnect = :useautoreconnect, autoreconnectinterval = :autoreconnectinterval, autoreconnectretries = :autoreconnectretries, unlimitedconnectretries = :unlimitedconnectretries, -rejoinchannels = :rejoinchannels +rejoinchannels = :rejoinchannels, +usesasl = :usesasl, +saslaccount = :saslaccount, +saslpassword = :saslpassword WHERE networkid = :networkid AND userid = :userid diff --git a/src/core/SQL/SQLite/16/update_network_connected.sql b/src/core/SQL/SQLite/17/update_network_connected.sql similarity index 100% rename from src/core/SQL/SQLite/16/update_network_connected.sql rename to src/core/SQL/SQLite/17/update_network_connected.sql diff --git a/src/core/SQL/SQLite/16/update_network_set_awaymsg.sql b/src/core/SQL/SQLite/17/update_network_set_awaymsg.sql similarity index 100% rename from src/core/SQL/SQLite/16/update_network_set_awaymsg.sql rename to src/core/SQL/SQLite/17/update_network_set_awaymsg.sql diff --git a/src/core/SQL/SQLite/16/update_network_set_usermode.sql b/src/core/SQL/SQLite/17/update_network_set_usermode.sql similarity index 100% rename from src/core/SQL/SQLite/16/update_network_set_usermode.sql rename to src/core/SQL/SQLite/17/update_network_set_usermode.sql diff --git a/src/core/SQL/SQLite/16/update_user_setting.sql b/src/core/SQL/SQLite/17/update_user_setting.sql similarity index 100% rename from src/core/SQL/SQLite/16/update_user_setting.sql rename to src/core/SQL/SQLite/17/update_user_setting.sql diff --git a/src/core/SQL/SQLite/16/update_username.sql b/src/core/SQL/SQLite/17/update_username.sql similarity index 100% rename from src/core/SQL/SQLite/16/update_username.sql rename to src/core/SQL/SQLite/17/update_username.sql diff --git a/src/core/SQL/SQLite/16/update_userpassword.sql b/src/core/SQL/SQLite/17/update_userpassword.sql similarity index 100% rename from src/core/SQL/SQLite/16/update_userpassword.sql rename to src/core/SQL/SQLite/17/update_userpassword.sql diff --git a/src/core/SQL/SQLite/17/upgrade_000_alter_network_add_sasl.sql b/src/core/SQL/SQLite/17/upgrade_000_alter_network_add_sasl.sql new file mode 100644 index 00000000..f03eec51 --- /dev/null +++ b/src/core/SQL/SQLite/17/upgrade_000_alter_network_add_sasl.sql @@ -0,0 +1,3 @@ +ALTER TABLE network +ADD COLUMN +usesasl INTEGER NOT NULL DEFAULT 0 diff --git a/src/core/SQL/SQLite/17/upgrade_001_alter_network_add_sasl.sql b/src/core/SQL/SQLite/17/upgrade_001_alter_network_add_sasl.sql new file mode 100644 index 00000000..c3e3582d --- /dev/null +++ b/src/core/SQL/SQLite/17/upgrade_001_alter_network_add_sasl.sql @@ -0,0 +1,3 @@ +ALTER TABLE network +ADD COLUMN +saslaccount TEXT diff --git a/src/core/SQL/SQLite/17/upgrade_002_alter_network_add_sasl.sql b/src/core/SQL/SQLite/17/upgrade_002_alter_network_add_sasl.sql new file mode 100644 index 00000000..91c99808 --- /dev/null +++ b/src/core/SQL/SQLite/17/upgrade_002_alter_network_add_sasl.sql @@ -0,0 +1,3 @@ +ALTER TABLE network +ADD COLUMN +saslpassword TEXT diff --git a/src/core/sql.qrc b/src/core/sql.qrc index 07c1fdf9..f713861b 100644 --- a/src/core/sql.qrc +++ b/src/core/sql.qrc @@ -1,89 +1,90 @@ - ./SQL/PostgreSQL/15/delete_backlog_by_uid.sql - ./SQL/PostgreSQL/15/delete_backlog_for_buffer.sql - ./SQL/PostgreSQL/15/delete_backlog_for_network.sql - ./SQL/PostgreSQL/15/delete_buffer_for_bufferid.sql - ./SQL/PostgreSQL/15/delete_buffers_by_uid.sql - ./SQL/PostgreSQL/15/delete_buffers_for_network.sql - ./SQL/PostgreSQL/15/delete_identity.sql - ./SQL/PostgreSQL/15/delete_ircservers_for_network.sql - ./SQL/PostgreSQL/15/delete_network.sql - ./SQL/PostgreSQL/15/delete_networks_by_uid.sql - ./SQL/PostgreSQL/15/delete_nicks.sql - ./SQL/PostgreSQL/15/delete_quasseluser.sql - ./SQL/PostgreSQL/15/insert_buffer.sql - ./SQL/PostgreSQL/15/insert_identity.sql - ./SQL/PostgreSQL/15/insert_message.sql - ./SQL/PostgreSQL/15/insert_network.sql - ./SQL/PostgreSQL/15/insert_nick.sql - ./SQL/PostgreSQL/15/insert_quasseluser.sql - ./SQL/PostgreSQL/15/insert_sender.sql - ./SQL/PostgreSQL/15/insert_server.sql - ./SQL/PostgreSQL/15/insert_user_setting.sql - ./SQL/PostgreSQL/15/migrate_write_backlog.sql - ./SQL/PostgreSQL/15/migrate_write_buffer.sql - ./SQL/PostgreSQL/15/migrate_write_identity.sql - ./SQL/PostgreSQL/15/migrate_write_identity_nick.sql - ./SQL/PostgreSQL/15/migrate_write_ircserver.sql - ./SQL/PostgreSQL/15/migrate_write_network.sql - ./SQL/PostgreSQL/15/migrate_write_quasseluser.sql - ./SQL/PostgreSQL/15/migrate_write_sender.sql - ./SQL/PostgreSQL/15/migrate_write_usersetting.sql - ./SQL/PostgreSQL/15/select_authuser.sql - ./SQL/PostgreSQL/15/select_buffer_by_id.sql - ./SQL/PostgreSQL/15/select_buffer_lastseen_messages.sql - ./SQL/PostgreSQL/15/select_buffer_markerlinemsgids.sql - ./SQL/PostgreSQL/15/select_bufferByName.sql - ./SQL/PostgreSQL/15/select_bufferExists.sql - ./SQL/PostgreSQL/15/select_buffers.sql - ./SQL/PostgreSQL/15/select_buffers_for_network.sql - ./SQL/PostgreSQL/15/select_checkidentity.sql - ./SQL/PostgreSQL/15/select_connected_networks.sql - ./SQL/PostgreSQL/15/select_identities.sql - ./SQL/PostgreSQL/15/select_internaluser.sql - ./SQL/PostgreSQL/15/select_messages.sql - ./SQL/PostgreSQL/15/select_messagesAll.sql - ./SQL/PostgreSQL/15/select_messagesAllNew.sql - ./SQL/PostgreSQL/15/select_messagesNewerThan.sql - ./SQL/PostgreSQL/15/select_messagesRange.sql - ./SQL/PostgreSQL/15/select_network_awaymsg.sql - ./SQL/PostgreSQL/15/select_network_usermode.sql - ./SQL/PostgreSQL/15/select_networkExists.sql - ./SQL/PostgreSQL/15/select_networks_for_user.sql - ./SQL/PostgreSQL/15/select_nicks.sql - ./SQL/PostgreSQL/15/select_persistent_channels.sql - ./SQL/PostgreSQL/15/select_servers_for_network.sql - ./SQL/PostgreSQL/15/select_user_setting.sql - ./SQL/PostgreSQL/15/select_userid.sql - ./SQL/PostgreSQL/15/setup_000_quasseluser.sql - ./SQL/PostgreSQL/15/setup_010_sender.sql - ./SQL/PostgreSQL/15/setup_020_identity.sql - ./SQL/PostgreSQL/15/setup_030_identity_nick.sql - ./SQL/PostgreSQL/15/setup_040_network.sql - ./SQL/PostgreSQL/15/setup_050_buffer.sql - ./SQL/PostgreSQL/15/setup_060_backlog.sql - ./SQL/PostgreSQL/15/setup_070_coreinfo.sql - ./SQL/PostgreSQL/15/setup_080_ircservers.sql - ./SQL/PostgreSQL/15/setup_090_backlog_idx.sql - ./SQL/PostgreSQL/15/setup_100_user_setting.sql - ./SQL/PostgreSQL/15/setup_110_alter_sender_seq.sql - ./SQL/PostgreSQL/15/setup_120_alter_messageid_seq.sql - ./SQL/PostgreSQL/15/update_backlog_bufferid.sql - ./SQL/PostgreSQL/15/update_buffer_lastseen.sql - ./SQL/PostgreSQL/15/update_buffer_markerlinemsgid.sql - ./SQL/PostgreSQL/15/update_buffer_name.sql - ./SQL/PostgreSQL/15/update_buffer_persistent_channel.sql - ./SQL/PostgreSQL/15/update_buffer_set_channel_key.sql - ./SQL/PostgreSQL/15/update_identity.sql - ./SQL/PostgreSQL/15/update_network.sql - ./SQL/PostgreSQL/15/update_network_connected.sql - ./SQL/PostgreSQL/15/update_network_set_awaymsg.sql - ./SQL/PostgreSQL/15/update_network_set_usermode.sql - ./SQL/PostgreSQL/15/update_user_setting.sql - ./SQL/PostgreSQL/15/update_username.sql - ./SQL/PostgreSQL/15/update_userpassword.sql ./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_bufferByName.sql + ./SQL/PostgreSQL/16/select_bufferExists.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_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_networkExists.sql + ./SQL/PostgreSQL/16/select_network_awaymsg.sql + ./SQL/PostgreSQL/16/select_network_usermode.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_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 @@ -108,92 +109,6 @@ ./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/delete_backlog_by_uid.sql - ./SQL/SQLite/16/delete_backlog_for_buffer.sql - ./SQL/SQLite/16/delete_backlog_for_network.sql - ./SQL/SQLite/16/delete_buffer_for_bufferid.sql - ./SQL/SQLite/16/delete_buffers_by_uid.sql - ./SQL/SQLite/16/delete_buffers_for_network.sql - ./SQL/SQLite/16/delete_identity.sql - ./SQL/SQLite/16/delete_ircservers_for_network.sql - ./SQL/SQLite/16/delete_network.sql - ./SQL/SQLite/16/delete_networks_by_uid.sql - ./SQL/SQLite/16/delete_nicks.sql - ./SQL/SQLite/16/delete_quasseluser.sql - ./SQL/SQLite/16/insert_buffer.sql - ./SQL/SQLite/16/insert_identity.sql - ./SQL/SQLite/16/insert_message.sql - ./SQL/SQLite/16/insert_network.sql - ./SQL/SQLite/16/insert_nick.sql - ./SQL/SQLite/16/insert_quasseluser.sql - ./SQL/SQLite/16/insert_sender.sql - ./SQL/SQLite/16/insert_server.sql - ./SQL/SQLite/16/insert_user_setting.sql - ./SQL/SQLite/16/migrate_read_backlog.sql - ./SQL/SQLite/16/migrate_read_buffer.sql - ./SQL/SQLite/16/migrate_read_identity.sql - ./SQL/SQLite/16/migrate_read_identity_nick.sql - ./SQL/SQLite/16/migrate_read_ircserver.sql - ./SQL/SQLite/16/migrate_read_network.sql - ./SQL/SQLite/16/migrate_read_quasseluser.sql - ./SQL/SQLite/16/migrate_read_sender.sql - ./SQL/SQLite/16/migrate_read_usersetting.sql - ./SQL/SQLite/16/select_authuser.sql - ./SQL/SQLite/16/select_buffer_by_id.sql - ./SQL/SQLite/16/select_buffer_lastseen_messages.sql - ./SQL/SQLite/16/select_buffer_markerlinemsgids.sql - ./SQL/SQLite/16/select_bufferByName.sql - ./SQL/SQLite/16/select_bufferExists.sql - ./SQL/SQLite/16/select_buffers.sql - ./SQL/SQLite/16/select_buffers_for_merge.sql - ./SQL/SQLite/16/select_buffers_for_network.sql - ./SQL/SQLite/16/select_checkidentity.sql - ./SQL/SQLite/16/select_connected_networks.sql - ./SQL/SQLite/16/select_identities.sql - ./SQL/SQLite/16/select_internaluser.sql - ./SQL/SQLite/16/select_messages.sql - ./SQL/SQLite/16/select_messagesAll.sql - ./SQL/SQLite/16/select_messagesAllNew.sql - ./SQL/SQLite/16/select_messagesNewerThan.sql - ./SQL/SQLite/16/select_messagesNewestK.sql - ./SQL/SQLite/16/select_network_awaymsg.sql - ./SQL/SQLite/16/select_network_usermode.sql - ./SQL/SQLite/16/select_networkExists.sql - ./SQL/SQLite/16/select_networks_for_user.sql - ./SQL/SQLite/16/select_nicks.sql - ./SQL/SQLite/16/select_persistent_channels.sql - ./SQL/SQLite/16/select_servers_for_network.sql - ./SQL/SQLite/16/select_user_setting.sql - ./SQL/SQLite/16/select_userid.sql - ./SQL/SQLite/16/setup_000_quasseluser.sql - ./SQL/SQLite/16/setup_010_sender.sql - ./SQL/SQLite/16/setup_020_network.sql - ./SQL/SQLite/16/setup_030_buffer.sql - ./SQL/SQLite/16/setup_040_buffer_idx.sql - ./SQL/SQLite/16/setup_050_buffer_cname_idx.sql - ./SQL/SQLite/16/setup_060_backlog.sql - ./SQL/SQLite/16/setup_070_coreinfo.sql - ./SQL/SQLite/16/setup_080_ircservers.sql - ./SQL/SQLite/16/setup_090_backlog_idx.sql - ./SQL/SQLite/16/setup_100_backlog_idx2.sql - ./SQL/SQLite/16/setup_110_buffer_user_idx.sql - ./SQL/SQLite/16/setup_120_user_setting.sql - ./SQL/SQLite/16/setup_130_identity.sql - ./SQL/SQLite/16/setup_140_identity_nick.sql - ./SQL/SQLite/16/update_backlog_bufferid.sql - ./SQL/SQLite/16/update_buffer_lastseen.sql - ./SQL/SQLite/16/update_buffer_markerlinemsgid.sql - ./SQL/SQLite/16/update_buffer_name.sql - ./SQL/SQLite/16/update_buffer_persistent_channel.sql - ./SQL/SQLite/16/update_buffer_set_channel_key.sql - ./SQL/SQLite/16/update_identity.sql - ./SQL/SQLite/16/update_network.sql - ./SQL/SQLite/16/update_network_connected.sql - ./SQL/SQLite/16/update_network_set_awaymsg.sql - ./SQL/SQLite/16/update_network_set_usermode.sql - ./SQL/SQLite/16/update_user_setting.sql - ./SQL/SQLite/16/update_username.sql - ./SQL/SQLite/16/update_userpassword.sql ./SQL/SQLite/16/upgrade_000_alter_buffer_add_markerlinemsgid.sql ./SQL/SQLite/2/upgrade_000_drop_buffergroup.sql ./SQL/SQLite/2/upgrade_010_update_schemaversion.sql @@ -239,5 +154,94 @@ ./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/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_bufferByName.sql + ./SQL/SQLite/17/select_bufferExists.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_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_networkExists.sql + ./SQL/SQLite/17/select_network_awaymsg.sql + ./SQL/SQLite/17/select_network_usermode.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 -- 2.20.1