]>
git.madduck.net Git - etc/mailfilter.git/blobdiff - procmail/msgid-index
madduck's git repository
Every one of the projects in this repository is available at the canonical
URL git://git.madduck.net/madduck/pub/<projectpath> — see
each project's metadata for the exact URL.
All patches and comments are welcome. Please squash your changes to logical
commits before using git-format-patch and git-send-email to
patches@ git. madduck. net .
If you'd read over the Git project's submission guidelines and adhered to them,
I'd be especially grateful.
SSH access, as well as push access can be individually
arranged .
If you use my repositories frequently, consider adding the following
snippet to ~/.gitconfig and using the third clone URL listed for each
project:
[url "git://git.madduck.net/madduck/"]
insteadOf = madduck:
-# create table logfil es (sender text not null, recipient text not null,
+# create table messag es (sender text not null, recipient text not null,
# subject text not null, msgid text unique not null, filename text primary key
# 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);
+# not null unique, timestamp integer , dest text not null);
-# create trigger insert_logfiles_timestamp after insert on logfil es begin
-# update logfiles set timestamp = datetime( 'now') where filename
+# create trigger insert_messages_timestamp after insert on messag es begin
+# update messages set timestamp = strftime('%s', 'now') where filename
# = new.filename; end;
MSGID_INDEX_DB=$PMVAR/msgid-index.sqlite
# = new.filename; end;
MSGID_INDEX_DB=$PMVAR/msgid-index.sqlite
DATA="$FROM,$NL$ORIGINAL_TO,$NL$SUBJECT,$NL$MSGID"
INCLUDERC=$PMDIR/sql-escape
DATA="$FROM,$NL$ORIGINAL_TO,$NL$SUBJECT,$NL$MSGID"
INCLUDERC=$PMDIR/sql-escape
-QUERY="insert into logfil es (sender, recipient, subject, msgid, filename, dest) values (
- $DATA, '\\'$THISLOGFILE_REL\\'', '\\'\$DEST\\'')"
+QUERY="insert into messag es (sender, recipient, subject, msgid, filename, dest) values (
+ $DATA, '\\'$THISLOGFILE_REL\\'', '\\'\$DESTFILE \\'')"
TRAP="$TRAP; $DO_QUERY '$QUERY'"
QUERY
TRAP="$TRAP; $DO_QUERY '$QUERY'"
QUERY