aboutsummaryrefslogtreecommitdiffstats
path: root/plugins
diff options
context:
space:
mode:
authorKim Alvefur <zash@zash.se>2017-12-12 01:40:09 +0100
committerKim Alvefur <zash@zash.se>2017-12-12 01:40:09 +0100
commitcf3af7a85ce0f7df439bd44421b7581f24aeea64 (patch)
tree606980a88015417512cc19a531f2589e7f924612 /plugins
parentea34ed2c8b43da2141253af2d7034374fc5e38a3 (diff)
downloadprosody-cf3af7a85ce0f7df439bd44421b7581f24aeea64.tar.gz
prosody-cf3af7a85ce0f7df439bd44421b7581f24aeea64.zip
mod_storage_sql: Index over contact and timestamp (happy now Ge0rg?)
Diffstat (limited to 'plugins')
-rw-r--r--plugins/mod_storage_sql.lua2
1 files changed, 1 insertions, 1 deletions
diff --git a/plugins/mod_storage_sql.lua b/plugins/mod_storage_sql.lua
index e25cb5c6..13c961f8 100644
--- a/plugins/mod_storage_sql.lua
+++ b/plugins/mod_storage_sql.lua
@@ -452,7 +452,7 @@ local function create_table(engine, name) -- luacheck: ignore 431/engine
Column { name="type", type="TEXT", nullable=false };
Column { name="value", type="MEDIUMTEXT", nullable=false };
Index { name="prosodyarchive_index", unique = true, "host", "user", "store", "key" };
- Index { name="prosodyarchive_with", "host", "user", "store", "with" };
+ Index { name="prosodyarchive_with_when", "host", "user", "store", "with", "when" };
Index { name="prosodyarchive_when", "host", "user", "store", "when" };
};
engine:transaction(function()