# 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; 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, dest) values ( `echo \"$FIELDS\" | sed -e 's,'\'','$SQE$SQE',g; s/^.*$/'\$SQE'&'\$SQE',/'` $SQ$THISLOGFILE_REL$SQ, '\\'\$DEST\\'')" TRAP="$TRAP; $DO_QUERY '$QUERY'" QUERY FIELDS SQE SQ DO_QUERY MSGID_INDEX_DB