#!/bin/sh

# You should probably run this hourly

MYSQLHOST="localhost"
MYSQLUSER="milter"
MYSQLPASS="milter"
MYSQLDB="relaydelay"

mysql -h $MYSQLHOST -u $MYSQLUSER -p$MYSQLPASS $MYSQLDB -e "delete FROM  relaytofrom WHERE origin_type = \"AUTO\" and ( unix_timestamp(  )- unix_timestamp( record_expires )  >0 )"