From 87691841376583c0db5817c54c30bc60c81a0deb Mon Sep 17 00:00:00 2001 From: Florent Bruneau Date: Thu, 18 Oct 2007 23:46:37 +0200 Subject: [PATCH] Auto-cleanup profile event table Signed-off-by: Florent Bruneau --- bin/cron/notifs.send.php | 3 +++ 1 file changed, 3 insertions(+) diff --git a/bin/cron/notifs.send.php b/bin/cron/notifs.send.php index b48682f..0f9f216 100755 --- a/bin/cron/notifs.send.php +++ b/bin/cron/notifs.send.php @@ -92,5 +92,8 @@ EOF; $mailer->send(); } +XDB::execute("DELETE FROM watch_profile + WHERE ts < DATE_SUB(CURRENT_DATE, INTERVAL 15 DAY)"); + // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?> -- 2.1.4