--- a/plugins/mod_storage_sql.lua Sun Mar 22 17:35:26 2020 +0100
+++ b/plugins/mod_storage_sql.lua Sun Mar 22 21:05:59 2020 +0100
@@ -500,6 +500,7 @@
Index { name="prosodyarchive_index", unique = engine.params.driver ~= "MySQL", "host", "user", "store", "key" };
Index { name="prosodyarchive_with_when", "host", "user", "store", "with", "when" };
Index { name="prosodyarchive_when", "host", "user", "store", "when" };
+ Index { name="prosodyarchive_sort", "host", "user", "store", "sort_id" };
};
engine:transaction(function()
ProsodyArchiveTable:create(engine);