X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Fdbmaintenancethread.cpp;h=59bc01016c3d2dbed1c412a19459f8bcf82da81e;hp=bfee4fb4dbc1c6210ff3b33872f895347ce4eaa4;hb=b88f50bfec6dbcd169bb8285e7c42b93baf52b6b;hpb=07319f767b4c4f0e06e9957f217d5107b196617b

diff --git a/src/dbmaintenancethread.cpp b/src/dbmaintenancethread.cpp
index bfee4fb..59bc010 100644
--- a/src/dbmaintenancethread.cpp
+++ b/src/dbmaintenancethread.cpp
@@ -258,6 +258,13 @@ void DBMaintenanceThread::Do1DayMaintenance()
 	st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d"));
 	st.Step();
 
+	// delete old message requests
+	date=Poco::Timestamp();
+	date-=Poco::Timespan(90,0,0,0,0);
+	st=m_db->Prepare("DELETE FROM tblMessageRequests WHERE Day<?;");
+	st.Bind(0,Poco::DateTimeFormatter::format(date,"%Y-%m-%d"));
+	st.Step();
+
 	// delete tblIdentityTrust for local identities and identities that have been deleted
 	m_db->Execute("DELETE FROM tblIdentityTrust WHERE LocalIdentityID NOT IN (SELECT LocalIdentityID FROM tblLocalIdentity);");
 	m_db->Execute("DELETE FROM tblIdentityTrust WHERE IdentityID NOT IN (SELECT IdentityID FROM tblIdentity);");