diff options
| author | George Hazan <george.hazan@gmail.com> | 2023-10-02 14:15:18 +0300 |
|---|---|---|
| committer | George Hazan <george.hazan@gmail.com> | 2023-10-02 14:15:18 +0300 |
| commit | fb7edbe76a928d134fd334e5bad68e32096e0424 (patch) | |
| tree | 34b5f491d81a1b930e819d4b8d6fcc420c515567 /plugins/Dbx_sqlite/src/dbintf.cpp | |
| parent | a6821e1eefdbd4c428a62bfd41cb2bf1f9fa7f39 (diff) | |
fixes #3700 )dbx_sqlite: удаление истории метаконтакта оставляет пустые события)
Diffstat (limited to 'plugins/Dbx_sqlite/src/dbintf.cpp')
| -rw-r--r-- | plugins/Dbx_sqlite/src/dbintf.cpp | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/plugins/Dbx_sqlite/src/dbintf.cpp b/plugins/Dbx_sqlite/src/dbintf.cpp index a7596ec9bb..70d35e9fbf 100644 --- a/plugins/Dbx_sqlite/src/dbintf.cpp +++ b/plugins/Dbx_sqlite/src/dbintf.cpp @@ -61,6 +61,9 @@ int CDbxSQLite::Create() 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 INDEX i1_srt ON events_srt(id);", 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,"
"PRIMARY KEY(contact_id, module, setting)) WITHOUT ROWID;", nullptr, nullptr, nullptr);
logError(rc, __FILE__, __LINE__);
|