Diff

plugins/mod_storage_sql.lua @ 10701:929c95e518f0

Merge 0.11->trunk
author Kim Alvefur <zash@zash.se>
date Sun, 22 Mar 2020 21:13:09 +0100
parent 10680:19692fc5c106
parent 10700:3fce670e0733
child 10793:9ce67da45e54
line wrap: on
line diff
--- a/plugins/mod_storage_sql.lua	Sat Mar 21 00:00:50 2020 +0100
+++ b/plugins/mod_storage_sql.lua	Sun Mar 22 21:13:09 2020 +0100
@@ -649,6 +649,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);