diff options
| author | George Hazan <george.hazan@gmail.com> | 2023-10-01 20:32:37 +0300 |
|---|---|---|
| committer | George Hazan <george.hazan@gmail.com> | 2023-10-01 20:32:37 +0300 |
| commit | 442980bfbf83cd423b42811e4da0d5b651005781 (patch) | |
| tree | 20d60b677eaf223305a908eeafdf3d101f02609b /plugins/Dbx_sqlite/src/dbintf.cpp | |
| parent | 93babaf1665bd2b706a096057fdd06572c159622 (diff) | |
fixes #3670 (Long and incorrect loading of messaging window)
Diffstat (limited to 'plugins/Dbx_sqlite/src/dbintf.cpp')
| -rw-r--r-- | plugins/Dbx_sqlite/src/dbintf.cpp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/plugins/Dbx_sqlite/src/dbintf.cpp b/plugins/Dbx_sqlite/src/dbintf.cpp index b983184d32..a7596ec9bb 100644 --- a/plugins/Dbx_sqlite/src/dbintf.cpp +++ b/plugins/Dbx_sqlite/src/dbintf.cpp @@ -58,7 +58,7 @@ int CDbxSQLite::Create() rc = sqlite3_exec(m_db, "CREATE INDEX idx_events_isread ON events(contact_id, is_read, timestamp);", nullptr, nullptr, nullptr);
logError(rc, __FILE__, __LINE__);
- rc = sqlite3_exec(m_db, "CREATE TABLE events_srt (id INTEGER NOT NULL, contact_id INTEGER NOT NULL, timestamp INTEGER, PRIMARY KEY(contact_id, timestamp, id));", nullptr, nullptr, nullptr);
+ rc = sqlite3_exec(m_db, "CREATE TABLE events_srt (id INTEGER NOT NULL, contact_id INTEGER NOT NULL, timestamp INTEGER, PRIMARY KEY(contact_id, timestamp));", nullptr, nullptr, nullptr);
logError(rc, __FILE__, __LINE__);
rc = sqlite3_exec(m_db, "CREATE TABLE settings (contact_id INTEGER NOT NULL, module TEXT NOT NULL, setting TEXT NOT NULL, type INTEGER NOT NULL, value NOT NULL,"
|