X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Ffreenet%2Fperiodicdbmaintenance.cpp;h=0febbbd736f6210ff8a1ecedf89fe8cec2008e12;hp=22a4ccff800b30097c0a0e456d5c8f24151fa264;hb=f60495a029c54358f82956482fe203fe2b7b5b23;hpb=b9c3763a932cebaa015a27fe111017f6f34dfbaa

diff --git a/src/freenet/periodicdbmaintenance.cpp b/src/freenet/periodicdbmaintenance.cpp
index 22a4ccf..0febbbd 100644
--- a/src/freenet/periodicdbmaintenance.cpp
+++ b/src/freenet/periodicdbmaintenance.cpp
@@ -58,6 +58,33 @@ void PeriodicDBMaintenance::Do1DayMaintenance()
 
 	m_log->WriteLog(LogFile::LOGLEVEL_DEBUG,"PeriodicDBMaintenance::Do1DayMaintenance");
 
+	// delete all identities we've never seen and were added more than 20 days ago
+	date.SetToGMTime();
+	date.Add(0,0,0,-20);
+	m_db->Execute("DELETE FROM tblIdentity WHERE LastSeen IS NULL AND DateAdded<'"+date.Format("%Y-%m-%d")+"';");
+
+	// delete old identity requests - we don't need them anymore
+	date.SetToGMTime();
+	date.Add(0,0,0,-2);
+	m_db->Execute("DELETE FROM tblIdentityRequests WHERE Day<'"+date.Format("%Y-%m-%d")+"';");
+
+	// delete old local identity inserts - we don't need them anymore
+	date.SetToGMTime();
+	date.Add(0,0,0,-2);
+	m_db->Execute("DELETE FROM tblLocalIdentityInserts WHERE Day<'"+date.Format("%Y-%m-%d")+"';");
+
+	// delete old message list inserts/requests - we don't need them anymore
+	date.SetToGMTime();
+	date.Add(0,0,0,-2);
+	m_db->Execute("DELETE FROM tblMessageListInserts WHERE Day<'"+date.Format("%Y-%m-%d")+"';");
+	m_db->Execute("DELETE FROM tblMessageListRequests WHERE Day<'"+date.Format("%Y-%m-%d")+"';");
+
+	// delete old trust list inserts/requests - we don't need them anymore
+	date.SetToGMTime();
+	date.Add(0,0,0,-2);
+	m_db->Execute("DELETE FROM tblTrustListInserts WHERE Day<'"+date.Format("%Y-%m-%d")+"';");
+	m_db->Execute("DELETE FROM tblTrustListRequests WHERE Day<'"+date.Format("%Y-%m-%d")+"';"); 
+
 }
 
 void PeriodicDBMaintenance::Process()