From 6a7da771f7cecc994564434097e2bd9dba68627e Mon Sep 17 00:00:00 2001 From: Marcus Eggenberger Date: Sun, 10 Feb 2008 16:07:00 +0000 Subject: [PATCH] Conversion to lowercase is no longer done by SQLite but now from Qt --- src/core/SQL/SQLite/3/insert_buffer.sql | 2 - src/core/SQL/SQLite/3/setup_080_version.sql | 1 - .../SQLite/{3 => 4}/delete_backlog_by_uid.sql | 0 .../SQLite/{3 => 4}/delete_buffers_by_uid.sql | 0 .../{3 => 4}/delete_networks_by_uid.sql | 0 .../SQLite/{3 => 4}/delete_quasseluser.sql | 0 src/core/SQL/SQLite/4/insert_buffer.sql | 2 + .../SQL/SQLite/{3 => 4}/insert_message.sql | 0 .../SQL/SQLite/{3 => 4}/insert_network.sql | 0 .../SQLite/{3 => 4}/insert_quasseluser.sql | 0 .../SQL/SQLite/{3 => 4}/insert_sender.sql | 0 .../SQL/SQLite/{3 => 4}/select_authuser.sql | 0 .../SQLite/{3 => 4}/select_bufferByName.sql | 2 +- .../SQL/SQLite/{3 => 4}/select_buffers.sql | 0 .../SQLite/{3 => 4}/select_lastMessage.sql | 0 .../SQLite/{3 => 4}/select_messageRange.sql | 0 .../SQL/SQLite/{3 => 4}/select_messages.sql | 0 .../SQLite/{3 => 4}/select_messagesOffset.sql | 0 .../SQLite/{3 => 4}/select_messagesSince.sql | 0 .../{3 => 4}/select_messagesSinceOffset.sql | 0 .../SQL/SQLite/{3 => 4}/select_userid.sql | 0 .../SQLite/{3 => 4}/setup_000_quasseluser.sql | 0 .../SQL/SQLite/{3 => 4}/setup_010_sender.sql | 0 .../SQL/SQLite/{3 => 4}/setup_020_network.sql | 0 src/core/SQL/SQLite/4/setup_030_buffer.sql | 8 +++ .../setup_040_buffer_idx.sql} | 0 .../SQLite/4/setup_050_buffer_cname_idx.sql | 2 + .../SQL/SQLite/{3 => 4}/setup_060_backlog.sql | 0 .../SQLite/{3 => 4}/setup_070_coreinfo.sql | 0 src/core/SQL/SQLite/4/setup_080_version.sql | 1 + .../SQL/SQLite/{3 => 4}/update_username.sql | 0 .../SQLite/{3 => 4}/update_userpassword.sql | 0 .../4/upgrade_000_rename_buffertable.sql | 1 + .../upgrade_010_create_buffertable.sql} | 4 +- .../SQLite/4/upgrade_020_copy_buffertable.sql | 2 + .../4/upgrade_030_drop_oldbuffertable.sql | 1 + .../4/upgrade_040_create_buffer_idx.sql | 2 + .../4/upgrade_050_create_buffer_cname_idx.sql | 2 + .../4/upgrade_999_update_schemaversion.sql | 3 + src/core/sql.qrc | 66 +++++++++++-------- src/core/sqlitestorage.cpp | 3 +- version.inc | 2 +- 42 files changed, 68 insertions(+), 36 deletions(-) delete mode 100644 src/core/SQL/SQLite/3/insert_buffer.sql delete mode 100644 src/core/SQL/SQLite/3/setup_080_version.sql rename src/core/SQL/SQLite/{3 => 4}/delete_backlog_by_uid.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/delete_buffers_by_uid.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/delete_networks_by_uid.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/delete_quasseluser.sql (100%) create mode 100644 src/core/SQL/SQLite/4/insert_buffer.sql rename src/core/SQL/SQLite/{3 => 4}/insert_message.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/insert_network.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/insert_quasseluser.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/insert_sender.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/select_authuser.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/select_bufferByName.sql (64%) rename src/core/SQL/SQLite/{3 => 4}/select_buffers.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/select_lastMessage.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/select_messageRange.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/select_messages.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/select_messagesOffset.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/select_messagesSince.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/select_messagesSinceOffset.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/select_userid.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/setup_000_quasseluser.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/setup_010_sender.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/setup_020_network.sql (100%) create mode 100644 src/core/SQL/SQLite/4/setup_030_buffer.sql rename src/core/SQL/SQLite/{3/setup_050_buffer_idx.sql => 4/setup_040_buffer_idx.sql} (100%) create mode 100644 src/core/SQL/SQLite/4/setup_050_buffer_cname_idx.sql rename src/core/SQL/SQLite/{3 => 4}/setup_060_backlog.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/setup_070_coreinfo.sql (100%) create mode 100644 src/core/SQL/SQLite/4/setup_080_version.sql rename src/core/SQL/SQLite/{3 => 4}/update_username.sql (100%) rename src/core/SQL/SQLite/{3 => 4}/update_userpassword.sql (100%) create mode 100644 src/core/SQL/SQLite/4/upgrade_000_rename_buffertable.sql rename src/core/SQL/SQLite/{3/setup_040_buffer.sql => 4/upgrade_010_create_buffertable.sql} (73%) create mode 100644 src/core/SQL/SQLite/4/upgrade_020_copy_buffertable.sql create mode 100644 src/core/SQL/SQLite/4/upgrade_030_drop_oldbuffertable.sql create mode 100644 src/core/SQL/SQLite/4/upgrade_040_create_buffer_idx.sql create mode 100644 src/core/SQL/SQLite/4/upgrade_050_create_buffer_cname_idx.sql create mode 100644 src/core/SQL/SQLite/4/upgrade_999_update_schemaversion.sql diff --git a/src/core/SQL/SQLite/3/insert_buffer.sql b/src/core/SQL/SQLite/3/insert_buffer.sql deleted file mode 100644 index da5aa808..00000000 --- a/src/core/SQL/SQLite/3/insert_buffer.sql +++ /dev/null @@ -1,2 +0,0 @@ -INSERT INTO buffer (userid, networkid, buffername) -VALUES (:userid, :networkid, :buffername) diff --git a/src/core/SQL/SQLite/3/setup_080_version.sql b/src/core/SQL/SQLite/3/setup_080_version.sql deleted file mode 100644 index 6b1890a2..00000000 --- a/src/core/SQL/SQLite/3/setup_080_version.sql +++ /dev/null @@ -1 +0,0 @@ -INSERT INTO coreinfo (key, value) VALUES ('schemaversion', '3') diff --git a/src/core/SQL/SQLite/3/delete_backlog_by_uid.sql b/src/core/SQL/SQLite/4/delete_backlog_by_uid.sql similarity index 100% rename from src/core/SQL/SQLite/3/delete_backlog_by_uid.sql rename to src/core/SQL/SQLite/4/delete_backlog_by_uid.sql diff --git a/src/core/SQL/SQLite/3/delete_buffers_by_uid.sql b/src/core/SQL/SQLite/4/delete_buffers_by_uid.sql similarity index 100% rename from src/core/SQL/SQLite/3/delete_buffers_by_uid.sql rename to src/core/SQL/SQLite/4/delete_buffers_by_uid.sql diff --git a/src/core/SQL/SQLite/3/delete_networks_by_uid.sql b/src/core/SQL/SQLite/4/delete_networks_by_uid.sql similarity index 100% rename from src/core/SQL/SQLite/3/delete_networks_by_uid.sql rename to src/core/SQL/SQLite/4/delete_networks_by_uid.sql diff --git a/src/core/SQL/SQLite/3/delete_quasseluser.sql b/src/core/SQL/SQLite/4/delete_quasseluser.sql similarity index 100% rename from src/core/SQL/SQLite/3/delete_quasseluser.sql rename to src/core/SQL/SQLite/4/delete_quasseluser.sql diff --git a/src/core/SQL/SQLite/4/insert_buffer.sql b/src/core/SQL/SQLite/4/insert_buffer.sql new file mode 100644 index 00000000..013505a5 --- /dev/null +++ b/src/core/SQL/SQLite/4/insert_buffer.sql @@ -0,0 +1,2 @@ +INSERT INTO buffer (userid, networkid, buffername, buffercname) +VALUES (:userid, :networkid, :buffername, :buffercname) diff --git a/src/core/SQL/SQLite/3/insert_message.sql b/src/core/SQL/SQLite/4/insert_message.sql similarity index 100% rename from src/core/SQL/SQLite/3/insert_message.sql rename to src/core/SQL/SQLite/4/insert_message.sql diff --git a/src/core/SQL/SQLite/3/insert_network.sql b/src/core/SQL/SQLite/4/insert_network.sql similarity index 100% rename from src/core/SQL/SQLite/3/insert_network.sql rename to src/core/SQL/SQLite/4/insert_network.sql diff --git a/src/core/SQL/SQLite/3/insert_quasseluser.sql b/src/core/SQL/SQLite/4/insert_quasseluser.sql similarity index 100% rename from src/core/SQL/SQLite/3/insert_quasseluser.sql rename to src/core/SQL/SQLite/4/insert_quasseluser.sql diff --git a/src/core/SQL/SQLite/3/insert_sender.sql b/src/core/SQL/SQLite/4/insert_sender.sql similarity index 100% rename from src/core/SQL/SQLite/3/insert_sender.sql rename to src/core/SQL/SQLite/4/insert_sender.sql diff --git a/src/core/SQL/SQLite/3/select_authuser.sql b/src/core/SQL/SQLite/4/select_authuser.sql similarity index 100% rename from src/core/SQL/SQLite/3/select_authuser.sql rename to src/core/SQL/SQLite/4/select_authuser.sql diff --git a/src/core/SQL/SQLite/3/select_bufferByName.sql b/src/core/SQL/SQLite/4/select_bufferByName.sql similarity index 64% rename from src/core/SQL/SQLite/3/select_bufferByName.sql rename to src/core/SQL/SQLite/4/select_bufferByName.sql index eaab5ab8..de808766 100644 --- a/src/core/SQL/SQLite/3/select_bufferByName.sql +++ b/src/core/SQL/SQLite/4/select_bufferByName.sql @@ -1,3 +1,3 @@ SELECT bufferid FROM buffer -WHERE buffer.networkid = :networkid AND buffer.userid = :userid AND lower(buffer.buffername) = lower(:buffername) +WHERE buffer.networkid = :networkid AND buffer.userid = :userid AND buffer.buffercname = :buffercname diff --git a/src/core/SQL/SQLite/3/select_buffers.sql b/src/core/SQL/SQLite/4/select_buffers.sql similarity index 100% rename from src/core/SQL/SQLite/3/select_buffers.sql rename to src/core/SQL/SQLite/4/select_buffers.sql diff --git a/src/core/SQL/SQLite/3/select_lastMessage.sql b/src/core/SQL/SQLite/4/select_lastMessage.sql similarity index 100% rename from src/core/SQL/SQLite/3/select_lastMessage.sql rename to src/core/SQL/SQLite/4/select_lastMessage.sql diff --git a/src/core/SQL/SQLite/3/select_messageRange.sql b/src/core/SQL/SQLite/4/select_messageRange.sql similarity index 100% rename from src/core/SQL/SQLite/3/select_messageRange.sql rename to src/core/SQL/SQLite/4/select_messageRange.sql diff --git a/src/core/SQL/SQLite/3/select_messages.sql b/src/core/SQL/SQLite/4/select_messages.sql similarity index 100% rename from src/core/SQL/SQLite/3/select_messages.sql rename to src/core/SQL/SQLite/4/select_messages.sql diff --git a/src/core/SQL/SQLite/3/select_messagesOffset.sql b/src/core/SQL/SQLite/4/select_messagesOffset.sql similarity index 100% rename from src/core/SQL/SQLite/3/select_messagesOffset.sql rename to src/core/SQL/SQLite/4/select_messagesOffset.sql diff --git a/src/core/SQL/SQLite/3/select_messagesSince.sql b/src/core/SQL/SQLite/4/select_messagesSince.sql similarity index 100% rename from src/core/SQL/SQLite/3/select_messagesSince.sql rename to src/core/SQL/SQLite/4/select_messagesSince.sql diff --git a/src/core/SQL/SQLite/3/select_messagesSinceOffset.sql b/src/core/SQL/SQLite/4/select_messagesSinceOffset.sql similarity index 100% rename from src/core/SQL/SQLite/3/select_messagesSinceOffset.sql rename to src/core/SQL/SQLite/4/select_messagesSinceOffset.sql diff --git a/src/core/SQL/SQLite/3/select_userid.sql b/src/core/SQL/SQLite/4/select_userid.sql similarity index 100% rename from src/core/SQL/SQLite/3/select_userid.sql rename to src/core/SQL/SQLite/4/select_userid.sql diff --git a/src/core/SQL/SQLite/3/setup_000_quasseluser.sql b/src/core/SQL/SQLite/4/setup_000_quasseluser.sql similarity index 100% rename from src/core/SQL/SQLite/3/setup_000_quasseluser.sql rename to src/core/SQL/SQLite/4/setup_000_quasseluser.sql diff --git a/src/core/SQL/SQLite/3/setup_010_sender.sql b/src/core/SQL/SQLite/4/setup_010_sender.sql similarity index 100% rename from src/core/SQL/SQLite/3/setup_010_sender.sql rename to src/core/SQL/SQLite/4/setup_010_sender.sql diff --git a/src/core/SQL/SQLite/3/setup_020_network.sql b/src/core/SQL/SQLite/4/setup_020_network.sql similarity index 100% rename from src/core/SQL/SQLite/3/setup_020_network.sql rename to src/core/SQL/SQLite/4/setup_020_network.sql diff --git a/src/core/SQL/SQLite/4/setup_030_buffer.sql b/src/core/SQL/SQLite/4/setup_030_buffer.sql new file mode 100644 index 00000000..9a118ff6 --- /dev/null +++ b/src/core/SQL/SQLite/4/setup_030_buffer.sql @@ -0,0 +1,8 @@ +CREATE TABLE buffer ( + bufferid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + userid INTEGER NOT NULL, + groupid INTEGER, + networkid INTEGER NOT NULL, + buffername TEXT NOT NULL, + buffercname TEXT NOT NULL +) diff --git a/src/core/SQL/SQLite/3/setup_050_buffer_idx.sql b/src/core/SQL/SQLite/4/setup_040_buffer_idx.sql similarity index 100% rename from src/core/SQL/SQLite/3/setup_050_buffer_idx.sql rename to src/core/SQL/SQLite/4/setup_040_buffer_idx.sql diff --git a/src/core/SQL/SQLite/4/setup_050_buffer_cname_idx.sql b/src/core/SQL/SQLite/4/setup_050_buffer_cname_idx.sql new file mode 100644 index 00000000..3858455e --- /dev/null +++ b/src/core/SQL/SQLite/4/setup_050_buffer_cname_idx.sql @@ -0,0 +1,2 @@ +CREATE UNIQUE INDEX buffer_cname_idx + ON buffer(userid, networkid, buffercname) diff --git a/src/core/SQL/SQLite/3/setup_060_backlog.sql b/src/core/SQL/SQLite/4/setup_060_backlog.sql similarity index 100% rename from src/core/SQL/SQLite/3/setup_060_backlog.sql rename to src/core/SQL/SQLite/4/setup_060_backlog.sql diff --git a/src/core/SQL/SQLite/3/setup_070_coreinfo.sql b/src/core/SQL/SQLite/4/setup_070_coreinfo.sql similarity index 100% rename from src/core/SQL/SQLite/3/setup_070_coreinfo.sql rename to src/core/SQL/SQLite/4/setup_070_coreinfo.sql diff --git a/src/core/SQL/SQLite/4/setup_080_version.sql b/src/core/SQL/SQLite/4/setup_080_version.sql new file mode 100644 index 00000000..8cc4cdcb --- /dev/null +++ b/src/core/SQL/SQLite/4/setup_080_version.sql @@ -0,0 +1 @@ +INSERT INTO coreinfo (key, value) VALUES ('schemaversion', '4') diff --git a/src/core/SQL/SQLite/3/update_username.sql b/src/core/SQL/SQLite/4/update_username.sql similarity index 100% rename from src/core/SQL/SQLite/3/update_username.sql rename to src/core/SQL/SQLite/4/update_username.sql diff --git a/src/core/SQL/SQLite/3/update_userpassword.sql b/src/core/SQL/SQLite/4/update_userpassword.sql similarity index 100% rename from src/core/SQL/SQLite/3/update_userpassword.sql rename to src/core/SQL/SQLite/4/update_userpassword.sql diff --git a/src/core/SQL/SQLite/4/upgrade_000_rename_buffertable.sql b/src/core/SQL/SQLite/4/upgrade_000_rename_buffertable.sql new file mode 100644 index 00000000..616acfec --- /dev/null +++ b/src/core/SQL/SQLite/4/upgrade_000_rename_buffertable.sql @@ -0,0 +1 @@ +ALTER TABLE buffer RENAME TO bufferold diff --git a/src/core/SQL/SQLite/3/setup_040_buffer.sql b/src/core/SQL/SQLite/4/upgrade_010_create_buffertable.sql similarity index 73% rename from src/core/SQL/SQLite/3/setup_040_buffer.sql rename to src/core/SQL/SQLite/4/upgrade_010_create_buffertable.sql index a7473fa9..ee5adc9b 100644 --- a/src/core/SQL/SQLite/3/setup_040_buffer.sql +++ b/src/core/SQL/SQLite/4/upgrade_010_create_buffertable.sql @@ -3,4 +3,6 @@ CREATE TABLE buffer ( userid INTEGER NOT NULL, groupid INTEGER, networkid INTEGER NOT NULL, - buffername TEXT NOT NULL) + buffername TEXT NOT NULL, + buffercname TEXT NOT NULL +) \ No newline at end of file diff --git a/src/core/SQL/SQLite/4/upgrade_020_copy_buffertable.sql b/src/core/SQL/SQLite/4/upgrade_020_copy_buffertable.sql new file mode 100644 index 00000000..2ab373ac --- /dev/null +++ b/src/core/SQL/SQLite/4/upgrade_020_copy_buffertable.sql @@ -0,0 +1,2 @@ +INSERT INTO buffer (bufferid, userid, groupid, networkid, buffername, buffercname) +SELECT bufferid, userid, groupid, networkid, buffername, lower(buffername) FROM bufferold diff --git a/src/core/SQL/SQLite/4/upgrade_030_drop_oldbuffertable.sql b/src/core/SQL/SQLite/4/upgrade_030_drop_oldbuffertable.sql new file mode 100644 index 00000000..3a2c470a --- /dev/null +++ b/src/core/SQL/SQLite/4/upgrade_030_drop_oldbuffertable.sql @@ -0,0 +1 @@ +DROP TABLE bufferold diff --git a/src/core/SQL/SQLite/4/upgrade_040_create_buffer_idx.sql b/src/core/SQL/SQLite/4/upgrade_040_create_buffer_idx.sql new file mode 100644 index 00000000..042ce3a3 --- /dev/null +++ b/src/core/SQL/SQLite/4/upgrade_040_create_buffer_idx.sql @@ -0,0 +1,2 @@ +CREATE UNIQUE INDEX buffer_idx + ON buffer(userid, networkid, buffername) diff --git a/src/core/SQL/SQLite/4/upgrade_050_create_buffer_cname_idx.sql b/src/core/SQL/SQLite/4/upgrade_050_create_buffer_cname_idx.sql new file mode 100644 index 00000000..3858455e --- /dev/null +++ b/src/core/SQL/SQLite/4/upgrade_050_create_buffer_cname_idx.sql @@ -0,0 +1,2 @@ +CREATE UNIQUE INDEX buffer_cname_idx + ON buffer(userid, networkid, buffercname) diff --git a/src/core/SQL/SQLite/4/upgrade_999_update_schemaversion.sql b/src/core/SQL/SQLite/4/upgrade_999_update_schemaversion.sql new file mode 100644 index 00000000..39ffe0a9 --- /dev/null +++ b/src/core/SQL/SQLite/4/upgrade_999_update_schemaversion.sql @@ -0,0 +1,3 @@ +UPDATE coreinfo +SET value='4' +WHERE key = 'schemaversion' diff --git a/src/core/sql.qrc b/src/core/sql.qrc index 73ed98d9..7b75c7e2 100644 --- a/src/core/sql.qrc +++ b/src/core/sql.qrc @@ -5,36 +5,44 @@ ./SQL/SQLite/1/upgrade_020_update_schemaversion.sql ./SQL/SQLite/2/upgrade_000_drop_buffergroup.sql ./SQL/SQLite/2/upgrade_010_update_schemaversion.sql - ./SQL/SQLite/3/delete_backlog_by_uid.sql - ./SQL/SQLite/3/delete_buffers_by_uid.sql - ./SQL/SQLite/3/delete_networks_by_uid.sql - ./SQL/SQLite/3/delete_quasseluser.sql - ./SQL/SQLite/3/insert_buffer.sql - ./SQL/SQLite/3/insert_message.sql - ./SQL/SQLite/3/insert_network.sql - ./SQL/SQLite/3/insert_quasseluser.sql - ./SQL/SQLite/3/insert_sender.sql - ./SQL/SQLite/3/select_authuser.sql - ./SQL/SQLite/3/select_bufferByName.sql - ./SQL/SQLite/3/select_buffers.sql - ./SQL/SQLite/3/select_lastMessage.sql - ./SQL/SQLite/3/select_messageRange.sql - ./SQL/SQLite/3/select_messages.sql - ./SQL/SQLite/3/select_messagesOffset.sql - ./SQL/SQLite/3/select_messagesSince.sql - ./SQL/SQLite/3/select_messagesSinceOffset.sql - ./SQL/SQLite/3/select_userid.sql - ./SQL/SQLite/3/setup_000_quasseluser.sql - ./SQL/SQLite/3/setup_010_sender.sql - ./SQL/SQLite/3/setup_020_network.sql - ./SQL/SQLite/3/setup_040_buffer.sql - ./SQL/SQLite/3/setup_050_buffer_idx.sql - ./SQL/SQLite/3/setup_060_backlog.sql - ./SQL/SQLite/3/setup_070_coreinfo.sql - ./SQL/SQLite/3/setup_080_version.sql - ./SQL/SQLite/3/update_username.sql - ./SQL/SQLite/3/update_userpassword.sql ./SQL/SQLite/3/upgrade_000_update_backlog_flags.sql ./SQL/SQLite/3/upgrade_010_update_schemaversion.sql + ./SQL/SQLite/4/delete_backlog_by_uid.sql + ./SQL/SQLite/4/delete_buffers_by_uid.sql + ./SQL/SQLite/4/delete_networks_by_uid.sql + ./SQL/SQLite/4/delete_quasseluser.sql + ./SQL/SQLite/4/insert_buffer.sql + ./SQL/SQLite/4/insert_message.sql + ./SQL/SQLite/4/insert_network.sql + ./SQL/SQLite/4/insert_quasseluser.sql + ./SQL/SQLite/4/insert_sender.sql + ./SQL/SQLite/4/select_authuser.sql + ./SQL/SQLite/4/select_bufferByName.sql + ./SQL/SQLite/4/select_buffers.sql + ./SQL/SQLite/4/select_lastMessage.sql + ./SQL/SQLite/4/select_messageRange.sql + ./SQL/SQLite/4/select_messages.sql + ./SQL/SQLite/4/select_messagesOffset.sql + ./SQL/SQLite/4/select_messagesSince.sql + ./SQL/SQLite/4/select_messagesSinceOffset.sql + ./SQL/SQLite/4/select_userid.sql + ./SQL/SQLite/4/setup_000_quasseluser.sql + ./SQL/SQLite/4/setup_010_sender.sql + ./SQL/SQLite/4/setup_020_network.sql + ./SQL/SQLite/4/setup_030_buffer.sql + ./SQL/SQLite/4/setup_040_buffer_idx.sql + ./SQL/SQLite/4/setup_050_buffer_cname_idx.sql + ./SQL/SQLite/4/setup_060_backlog.sql + ./SQL/SQLite/4/setup_070_coreinfo.sql + ./SQL/SQLite/4/setup_080_version.sql + ./SQL/SQLite/4/update_username.sql + ./SQL/SQLite/4/update_userpassword.sql + ./SQL/SQLite/4/upgrade_000_rename_buffertable.sql + ./SQL/SQLite/4/upgrade_010_create_buffertable.sql + ./SQL/SQLite/4/upgrade_020_copy_buffertable.sql + ./SQL/SQLite/4/upgrade_030_drop_oldbuffertable.sql + ./SQL/SQLite/4/upgrade_040_create_buffer_idx.sql + ./SQL/SQLite/4/upgrade_050_create_buffer_cname_idx.sql + ./SQL/SQLite/4/upgrade_999_update_schemaversion.sql diff --git a/src/core/sqlitestorage.cpp b/src/core/sqlitestorage.cpp index 900a1931..a20640c4 100644 --- a/src/core/sqlitestorage.cpp +++ b/src/core/sqlitestorage.cpp @@ -175,6 +175,7 @@ void SqliteStorage::createBuffer(UserId user, const NetworkId &networkId, const query->bindValue(":userid", user.toInt()); query->bindValue(":networkid", networkId.toInt()); query->bindValue(":buffername", buffer); + query->bindValue(":buffercname", buffer.toLower()); query->exec(); watchQuery(query); @@ -184,7 +185,7 @@ BufferInfo SqliteStorage::getBufferInfo(UserId user, const NetworkId &networkId, QSqlQuery *query = cachedQuery("select_bufferByName"); query->bindValue(":networkid", networkId.toInt()); query->bindValue(":userid", user.toInt()); - query->bindValue(":buffername", buffer); + query->bindValue(":buffercname", buffer.toLower()); query->exec(); if(!query->first()) { diff --git a/version.inc b/version.inc index ba5bb55b..c3368e58 100644 --- a/version.inc +++ b/version.inc @@ -5,7 +5,7 @@ quasselVersion = "0.2.0-pre"; quasselDate = "2008-02-10"; - quasselBuild = 495; + quasselBuild = 497; //! Minimum client build number the core needs clientBuildNeeded = 480; -- 2.20.1