From: Alan Knowles Date: Thu, 16 Oct 2014 05:32:09 +0000 (+0800) Subject: Prune.php X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=429da98861c33ccf777011b8f44b63094ca5eefe Prune.php --- diff --git a/Prune.php b/Prune.php index 9d1c103f..d1848309 100644 --- a/Prune.php +++ b/Prune.php @@ -46,12 +46,8 @@ class Pman_Core_Prune extends Pman //DB_DataObject::debugLevel(1); $f = DB_DataObject::Factory('reader_article'); $f->query(" - DELETE FROM reader_article where - fetched_dt < NOW() - INTERVAL {$inM} MONTH - AND - fetched - AND - views < 1 + DELETE FROM Events where + event_when < NOW() - INTERVAL {$inM} MONTH LIMIT 100000 "); // pruning is for our press project - so we do not clean up dependant tables at present..