# HG changeset patch
# User Kim Alvefur <zash@zash.se>
# Date 1507218287 -7200
# Node ID 34814a908557d7c9029bc0220510e3aed028ab2f
# Parent  2fc8b83dd7369a27d156587b47699d8229e3cf92
mod_storage_sql: Also clear the prosodyarchive table when an user is deleted (fixes #1009)

diff -r 2fc8b83dd736 -r 34814a908557 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