nyazoom/queries/records/delete_expired_records.sql

6 lines
129 B
MySQL
Raw Permalink Normal View History

2024-11-21 19:06:41 +00:00
DELETE FROM records
WHERE
downloads >= max_downloads
OR julianday('now') - julianday(uploaded) > 3
RETURNING cache_name;