CODE EXAMPLE FOR SQL

SQL DROP TABLES EVENT

SELECT
    TABLE_NAME
FROM
    information_schema.TABLES
WHERE 
    UPDATE_TIME < (NOW()-INTERVAL 1 WEEK)