Diff

plugins/mod_storage_sql.lua @ 8293:34814a908557

mod_storage_sql: Also clear the prosodyarchive table when an user is deleted (fixes #1009)
author Kim Alvefur <zash@zash.se>
date Thu, 05 Oct 2017 17:44:47 +0200
parent 8292:2fc8b83dd736
child 8294:90576b60f2d0
child 8409:e98b4352d7df
line wrap: on
line diff
--- 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