From 3f1e855bb32235c0122f9f992200691d8ea62fa8 Mon Sep 17 00:00:00 2001 From: George Hazan Date: Tue, 30 Apr 2024 11:36:43 +0300 Subject: SQLITE: useless index removed --- plugins/Dbx_sqlite/src/dbintf.cpp | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) (limited to 'plugins/Dbx_sqlite') diff --git a/plugins/Dbx_sqlite/src/dbintf.cpp b/plugins/Dbx_sqlite/src/dbintf.cpp index dc872f64c7..7d3d06a1a5 100644 --- a/plugins/Dbx_sqlite/src/dbintf.cpp +++ b/plugins/Dbx_sqlite/src/dbintf.cpp @@ -29,7 +29,7 @@ CDbxSQLite::~CDbxSQLite() ///////////////////////////////////////////////////////////////////////////////////////// -#define CURRVER 6 +#define CURRVER 7 int CDbxSQLite::Create() { @@ -51,9 +51,6 @@ int CDbxSQLite::Create() "timestamp INTEGER NOT NULL, type INTEGER NOT NULL, flags INTEGER NOT NULL, data BLOB, server_id TEXT NULL, user_id TEXT NULL, is_read INTEGER NOT NULL DEFAULT 0, reply_id TEXT NULL);", nullptr, nullptr, nullptr); logError(rc, __FILE__, __LINE__); - rc = sqlite3_exec(m_db, "CREATE INDEX idx_events_contactid_timestamp ON events(contact_id, timestamp);", nullptr, nullptr, nullptr); - logError(rc, __FILE__, __LINE__); - rc = sqlite3_exec(m_db, "CREATE INDEX idx_events_module_serverid ON events(module, server_id);", nullptr, nullptr, nullptr); logError(rc, __FILE__, __LINE__); @@ -204,6 +201,11 @@ void CDbxSQLite::CheckConversion() logError(rc, __FILE__, __LINE__); } + if (dbv.bVal < 7) { + int rc = sqlite3_exec(m_db, "DROP INDEX IF EXISTS idx_events_contactid_timestamp;", 0, 0, 0); + logError(rc, __FILE__, __LINE__); + } + dbv.bVal = CURRVER; WriteContactSetting(0, "Compatibility", "Sqlite", &dbv); -- cgit v1.2.3