| author | Stephen Paul Weber
<singpolyma@singpolyma.net> 2026-05-26 20:40:21 UTC |
| committer | Stephen Paul Weber
<singpolyma@singpolyma.net> 2026-05-26 20:40:21 UTC |
| parent | 91484027da93e9f284fb1b2ba63563a1028beddd |
| borogove/persistence/Sqlite.hx | +6 | -0 |
diff --git a/borogove/persistence/Sqlite.hx b/borogove/persistence/Sqlite.hx index 2dc14f6..f9bac0e 100644 --- a/borogove/persistence/Sqlite.hx +++ b/borogove/persistence/Sqlite.hx @@ -256,6 +256,12 @@ class Sqlite implements Persistence implements KeyValueStore { "PRAGMA user_version = 11"]); } return Promise.resolve(null); + }).then(_ -> { + if (version < 12) { + return exec(["CREATE INDEX messages_sync_point ON messages (account_id, mam_by, sort_id DESC) WHERE sync_point", + "PRAGMA user_version = 12"]); + } + return Promise.resolve(null); }); }); });