Philipp Hörist pushed to branch master at gajim / gajim
Commits:
-
96f9fbc2
by Philipp Hörist at 2019-11-01T09:14:07Z
1 changed file:
Changes:
| ... | ... | @@ -95,7 +95,8 @@ LOGS_SQL_STATEMENT = ''' |
| 95 | 95 |
);
|
| 96 | 96 |
CREATE INDEX idx_logs_jid_id_time ON logs (jid_id, time DESC);
|
| 97 | 97 |
CREATE INDEX idx_logs_stanza_id ON logs (stanza_id);
|
| 98 |
- PRAGMA user_version=4;
|
|
| 98 |
+ CREATE INDEX idx_logs_message_id ON logs (message_id);
|
|
| 99 |
+ PRAGMA user_version=5;
|
|
| 99 | 100 |
'''
|
| 100 | 101 |
|
| 101 | 102 |
CACHE_SQL_STATEMENT = '''
|
| ... | ... | @@ -328,6 +329,13 @@ class Logger: |
| 328 | 329 |
]
|
| 329 | 330 |
self._execute_multiple(con, statements)
|
| 330 | 331 |
|
| 332 |
+ if self._get_user_version(con) < 5:
|
|
| 333 |
+ statements = [
|
|
| 334 |
+ 'CREATE INDEX idx_logs_message_id ON logs (message_id)',
|
|
| 335 |
+ 'PRAGMA user_version=5'
|
|
| 336 |
+ ]
|
|
| 337 |
+ self._execute_multiple(con, statements)
|
|
| 338 |
+ |
|
| 331 | 339 |
def _migrate_cache(self, con):
|
| 332 | 340 |
if self._get_user_version(con) == 0:
|
| 333 | 341 |
# All migrations from 0.16.9 until 1.0.0
|