Clean log DB table

-- простой вариант
DELETE FROM logs WHERE TIME < DATE_ADD(NOW(), INTERVAL -7 DAY);
-- надо проверить как это будет работать
CREATE TRIGGER clean_logs AFTER INSERT ON logsTable
FOR EACH ROW
BEGIN
DELETE FROM logs WHERE TIME < DATE_ADD(NOW(), INTERVAL -7 DAY);
END;
-- через евенты
CREATE EVENT cleanLogs
ON SCHEDULE EVERY 1 DAY
DO DELETE FROM logs WHERE TIME < DATE_ADD(NOW(), INTERVAL -30 DAY);
-- из доки
-- "EVERY interval" means "Do this repeatedly". A recurring interval starts with EVERY, -- -- followed by a positive integer plus one of the keywords
-- YEAR, MONTH, WEEK, DAY, HOUR, MINUTE, or SECOND.