# create table messages (sender text not null, recipient text not null,
# subject text not null, msgid text not null, filename text primary key
# not null unique, timestamp integer, dest text not null);
#
# create trigger insert_messages_timestamp after insert on messages begin
# update messages set timestamp = strftime('%s', '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 messages (sender, recipient, subject, msgid, filename, dest) values (
  $DATA, '$THISLOGFILE_REL', '\$DESTFILE');"
TRAP="$TRAP; OUT=\"$(echo \"$QUERY\" | $DO_QUERY 2>&1)\";
      [ -n \"\$OUT\" ] && echo \"msgid-index: failed to insert reference into database: \$OUT\""

QUERY
DATA
DO_QUERY
MSGID_INDEX_DB