Changeset

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
parents 8292:2fc8b83dd736
children 8294:90576b60f2d0 8347:c72db8047440
files plugins/mod_storage_sql.lua
diffstat 1 files changed, 1 insertions(+), 0 deletions(-) [+]
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