# create table logfiles (sender text not null, recipient text not null,
# subject text not null, msgid text unique not null, filename text primary key
# not null unique, timestamp timestamp with time zone, dest text not null);
#
# create trigger insert_logfiles_timestamp after insert on logfiles begin
# update logfiles set timestamp = datetime('now') where filename
# = new.filename; end;

MSGID_INDEX_DB=$PMVAR/msgid-index.sqlite

DO_QUERY="$SQLITE $MSGID_INDEX_DB"

DATA="$FROM,$NL$ORIGINAL_TO,$NL$SUBJECT,$NL$MSGID"
INCLUDERC=$PMDIR/sql-escape

QUERY="insert into logfiles (sender, recipient, subject, msgid, filename, dest) values (
  $DATA, '\\'$THISLOGFILE_REL\\'', '\\'\$DEST\\'')"
TRAP="$TRAP; $DO_QUERY '$QUERY'"

QUERY
DATA
DO_QUERY
MSGID_INDEX_DB