also log final destination to database

[etc/mailfilter.git] / procmail / msgid-index

diff --git a/procmail/msgid-index b/procmail/msgid-index
index cef647672f13fc8b720a69d10fffda1d86af0770..1d31f0a9a264ad5773633bfd3bcb623403cbbd66 100644 (file)
--- a/procmail/msgid-index
+++ b/procmail/msgid-index
@@ -1,6 +1,6 @@
 # create table logfiles (sender text not null, recipient text not null,
 # subject text not null, msgid text unique not null, filename text primary key
 # 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);
+# 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
 #
 # create trigger insert_logfiles_timestamp after insert on logfiles begin
 # update logfiles set timestamp = datetime('now') where filename


@@ -14,9 +14,9 @@ DO_QUERY="$SQLITE $MSGID_INDEX_DB"
 SQ="'\\''"
 SQE="'\\\''"
 FIELDS="$FROM$NL$ORIGINAL_TO$NL$SUBJECT$NL$MSGID"
 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,\\\",\\\\\",g; s,'\'','$SQE$SQE',g; s/^.*$/'\$SQE'&'\$SQE',/'`
-  $SQ$THISLOGFILE_REL$SQ)"
+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
 TRAP="$TRAP; $DO_QUERY '$QUERY'"
 
 QUERY