X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Ffreenet%2Fperiodicdbmaintenance.cpp;h=073da197e92296fd7d07547abd01af6c8f2af9c4;hp=84e7e941768848db6a9699e80a9ec01671477cf0;hb=bae54a5dae027ad0a6b0126ec9eeecd3bd2739eb;hpb=b4f4686250878cdf4fcb2986a2ea6546cba867d1

diff --git a/src/freenet/periodicdbmaintenance.cpp b/src/freenet/periodicdbmaintenance.cpp
index 84e7e94..073da19 100644
--- a/src/freenet/periodicdbmaintenance.cpp
+++ b/src/freenet/periodicdbmaintenance.cpp
@@ -245,6 +245,10 @@ void PeriodicDBMaintenance::Do1DayMaintenance()
 	st.Bind(0,date.Format("%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);");
+
 }
 
 void PeriodicDBMaintenance::Process()