# 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);
#
# create trigger insert_logfiles_timestamp after insert on logfiles begin
# update logfiles set timestamp = datetime('now') where filename
# = new.filename; end;

SQLITE=/usr/bin/sqlite3
MSGID_INDEX_DB=$PMVAR/msgid-index.sqlite

DO_QUERY="$SQLITE $MSGID_INDEX_DB"

SQ="'\\''"
SQE="'\\\''"
FIELDS="$FROM$NL$ORIGINAL_TO$NL$SUBJECT$NL$MSGID"
QUERY="insert into logfiles (sender, recipient, subject, msgid, filename) values (
  `echo \"$FIELDS\" | sed -e 's,'\'','$SQE$SQE',g; s/^.*$/'\$SQE'&'\$SQE',/'`
  $SQ$THISLOGFILE_REL$SQ)"
TRAP="$TRAP; $DO_QUERY '$QUERY'"

QUERY
FIELDS
SQE
SQ
DO_QUERY
MSGID_INDEX_DB