version 0.1.14

[fms.git] / src / freenet / periodicdbmaintenance.cpp

diff --git a/src/freenet/periodicdbmaintenance.cpp b/src/freenet/periodicdbmaintenance.cpp
index c615d60..63863f8 100644 (file)
--- a/src/freenet/periodicdbmaintenance.cpp
+++ b/src/freenet/periodicdbmaintenance.cpp
@@ -133,6 +133,20 @@ void PeriodicDBMaintenance::Do1DayMaintenance()
                st.Step();\r
        }\r
 \r
+       // delete single use identities that are older than 7 days\r
+       date.SetToGMTime();\r
+       date.Add(0,0,0,-7);\r
+       st=m_db->Prepare("DELETE FROM tblIdentity WHERE SingleUse='true' AND DateAdded<?;");\r
+       st.Bind(0,date.Format("%Y-%m-%d %H:%M:%S"));\r
+       st.Step();\r
+\r
+       // delete local single use identities that are older than 7 days\r
+       date.SetToGMTime();\r
+       date.Add(0,0,0,-7);\r
+       st=m_db->Prepare("DELETE FROM tblLocalIdentity WHERE SingleUse='true' AND DateCreated<?;");\r
+       st.Bind(0,date.Format("%Y-%m-%d %H:%M:%S"));\r
+       st.Step();\r
+\r
 }\r
 \r
 void PeriodicDBMaintenance::Process()\r