mod_storage_sql: Also clear the prosodyarchive table when an user is deleted (fixes #1009)
--- a/plugins/mod_storage_sql.lua Thu Oct 05 17:22:42 2017 +0200
+++ b/plugins/mod_storage_sql.lua Thu Oct 05 17:44:47 2017 +0200
@@ -416,6 +416,7 @@
function driver:purge(username)
return engine:transaction(function()
engine:delete("DELETE FROM \"prosody\" WHERE \"host\"=? AND \"user\"=?", host, username);
+ engine:delete("DELETE FROM \"prosodyarchive\" WHERE \"host\"=? AND \"user\"=?", host, username);
end);
end