# create table messages (msgid text unique not null, filename text # primary key not null unique, release_ts integer not null); DELAYED_QUEUE_DB=$PMVAR/delayed-queue.sqlite DO_QUERY="$SQLITE $DELAYED_QUEUE_DB" DATA="$MSGID" INCLUDERC=$PMDIR/sql-escape QUERY="insert into messages values ($DATA, '\$DESTFILE', $RELEASE_TS);" TRAP="$TRAP; OUT=\"$(echo \"$QUERY\" | $DO_QUERY 2>&1)\"; [ -n \"\$OUT\" ] && echo \"delay: failed register delayed mail in database: \$OUT\"" QUERY DATA DO_QUERY DELAYED_QUEUE_DB