<?php
include_once 'global.php';
$db = new QueueTaskLogModelDB();
$minId = $db->getFirst('SELECT MIN(id) FROM ' . $db->getTableName());
$addTime = strtotime('-1 month');
$lastId = $db->getFirst('SELECT MAX(id) FROM ' . $db->getTableName() . " WHERE begin_time<{$addTime} ORDER BY id DESC");
$limit = 1000;
while (true) {
$db->exec('DELETE FROM ' . $db->getTableName() . " WHERE id >= {$minId} LIMIT {$limit}");
$minId += $limit;
if ($minId > $lastId) {
break;
}
}
