mod_storage_sql: Also clear the prosodyarchive table when an user is deleted (fixes #1009)
authorKim Alvefur <zash@zash.se>
Thu, 05 Oct 2017 17:44:47 +0200
changeset 8296 34814a908557
parent 8295 2fc8b83dd736
child 8297 90576b60f2d0
child 8350 c72db8047440
mod_storage_sql: Also clear the prosodyarchive table when an user is deleted (fixes #1009)
plugins/mod_storage_sql.lua
--- 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