X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fclean.php;h=9744d972f6dc59c16402ff9171183dfdf7687ac3;hb=12a587df92f7bc9efeb91c1a2d27f763070b8609;hp=3c0590d02c49c4de5b0c94bb0a1ea77fcf1ebb2d;hpb=69e3c9f320a0a4a001c4000e173d4afef78a8eed;p=platal.git diff --git a/bin/cron/clean.php b/bin/cron/clean.php index 3c0590d..9744d97 100755 --- a/bin/cron/clean.php +++ b/bin/cron/clean.php @@ -43,6 +43,8 @@ query("ALTER TABLE groupesx_def ORDER BY text"); query("ALTER TABLE secteur ORDER BY text"); query("ALTER TABLE sections ORDER BY text"); +// Prunes older autocomplete queries. +query("DELETE FROM search_autocomplete WHERE generated < DATE_SUB(NOW(), INTERVAL 1 DAY)"); // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?>