#! /bin/sh
/usr/local/bin/mysql -e "\
update messages set messagelen = length(message) where messagelen is null;
delete from messages where ts < now() - interval 3 day and messagelen > 65536;
delete from messages where ts < now() - interval 7 day and messagelen > 8192;
delete from messages where ts < now() - interval 21 day;
delete from messages where messagelen > 262144;
" mail