This changeset adds two interesting new features: - single-instance header storage. The migration will flush out all cache tables - except envelopes. These will need refilling with dbmail-util -by.
- sql-based 'file-into' style delivery filter. Filters assigned to the 'anyone' user are globally applied. For now, this feature has it's own migration script. happy testing. Paul J Stevens wrote: > This is an automated email from the git hooks/post-receive script. It was > generated because a ref change was pushed to the repository containing > the project "Paul's DBMail tree". > > The branch, master has been updated > via becf2ef1cd8c7bea77a4c37dbdd4956f73643a70 (commit) > via 6b31363bccc1c76718853eb5cea6b683950c477a (commit) > via bc3f6239665c34dbb83c8b25a21ba71d3daec943 (commit) > via 64fbf547597a0a249cb5658ba642e5062beec2b7 (commit) > via 7552bc38e85502662776de5b86fc915690f9cb66 (commit) > via 7d8fb32be589cb4baeede2749b80a444805a3a06 (commit) > via 2c324ba40459f8ffd31a6efc71ea5d9e062bb018 (commit) > via b695e9b64d6c4e87fdd9573fd1556048130fa341 (commit) > via d38261c3fe797ce3b3e8432f1f009d64b5ddaabf (commit) > via ba65a86bf5772cf881afe5d5a4be7e6e5901a495 (commit) > via 42eaa2808f03ed77c27b17f99b0e6ea17ca027f1 (commit) > via a2f90b05ff88ac863e0e02e605c787f252cd25ab (commit) > from e0101f6faae6c5e09dfb164d76370103b322be83 (commit) > > Those revisions listed above that are new to this repository have > not appeared on any other notification email; so we list those > revisions in full, below. > > - Log ----------------------------------------------------------------- > commit becf2ef1cd8c7bea77a4c37dbdd4956f73643a70 > Author: Paul J Stevens <[email protected]> > Date: Fri Jan 30 19:44:11 2009 +0100 > > merge filter branch > > commit 6b31363bccc1c76718853eb5cea6b683950c477a > Author: Paul J Stevens <[email protected]> > Date: Wed Jan 28 17:19:55 2009 +0100 > > fix single-instance-storage for pgsql > > commit bc3f6239665c34dbb83c8b25a21ba71d3daec943 > Author: Paul J Stevens <[email protected]> > Date: Tue Jan 27 21:46:31 2009 +0100 > > fixes missed edit in query > > commit 64fbf547597a0a249cb5658ba642e5062beec2b7 > Author: Paul J Stevens <[email protected]> > Date: Tue Jan 27 17:05:42 2009 +0100 > > minor edit > > commit 7552bc38e85502662776de5b86fc915690f9cb66 > Author: Paul J Stevens <[email protected]> > Date: Tue Jan 27 16:50:21 2009 +0100 > > add sqlite migration > > commit 7d8fb32be589cb4baeede2749b80a444805a3a06 > Author: Paul J Stevens <[email protected]> > Date: Tue Jan 27 16:25:24 2009 +0100 > > add mysql migration > > also rename the postgresql migration, and leave the dbmail_headername > table intact > > commit 2c324ba40459f8ffd31a6efc71ea5d9e062bb018 > Author: Paul J Stevens <[email protected]> > Date: Tue Jan 27 15:40:18 2009 +0100 > > fix typo > > commit b695e9b64d6c4e87fdd9573fd1556048130fa341 > Author: Paul J Stevens <[email protected]> > Date: Tue Jan 27 15:18:06 2009 +0100 > > update single instance header storage > > cleanup migration > add hash digest to quickly lookup headervalues > > commit d38261c3fe797ce3b3e8432f1f009d64b5ddaabf > Author: Niki Guldbrand <[email protected]> > Date: Sun Jan 25 15:25:57 2009 +0100 > > WIP: Fixup the migration script. > > During conversion of my setup, I noticed that during > migration of my own setup. > > commit ba65a86bf5772cf881afe5d5a4be7e6e5901a495 > Author: Niki Guldbrand <[email protected]> > Date: Sun Jan 25 13:03:48 2009 +0100 > > WIP: Fixed up headervalue storage. > > The header values was stored multiple times. > > commit 42eaa2808f03ed77c27b17f99b0e6ea17ca027f1 > Author: Niki Guldbrand <[email protected]> > Date: Sat Jan 24 22:30:00 2009 +0100 > > WIP: Adding single instance header storage. > > This patch adds single instance storage for headers, > in an attempt to save storage space, and to make > lookups faster (Based on a request/idea from > Michael Monnerie). > > At this time storage of new mail is working, > fetching af headers is working, and > dbmail-util -ay will fill the tables with data. > > NOTE: Only tested on postgres 8.3 so far. > > commit a2f90b05ff88ac863e0e02e605c787f252cd25ab > Author: Paul J Stevens <[email protected]> > Date: Fri Jan 30 10:14:02 2009 +0100 > > add large file support on 32bit systems > > this will allow dbmail-export to handle mailboxes > larger than 2 GB > > ----------------------------------------------------------------------- > > Summary of changes: > doc/README.filters | 40 +++++++ > sql/mysql/2_3_5-2_3_6.mysql | 41 ++++++++ > sql/mysql/add_filter_tables.mysql | 13 +++ > sql/mysql/create_tables.mysql | 38 ++++--- > sql/postgresql/2_3_5-2_3_6.pgsql | 46 +++++++++ > sql/postgresql/add_filter_tables.pgsql | 12 ++ > sql/postgresql/create_tables.pgsql | 40 ++++--- > sql/sqlite/2_3_5-2_3_6.sqlite | 175 > ++++++++++++++++++++++++++++++++ > sql/sqlite/add_filter_tables.sqlite | 57 ++++++++++ > sql/sqlite/create_tables.sqlite | 120 ++++++++++++++-------- > src/dbmail-imapsession.c | 15 ++-- > src/dbmail-mailbox.c | 43 ++++---- > src/dbmail-message.c | 175 > +++++++++++++++++++++++++++++--- > src/dbmail.h.in | 2 + > src/dm_db.c | 25 +++-- > 15 files changed, 714 insertions(+), 128 deletions(-) > create mode 100644 doc/README.filters > create mode 100644 sql/mysql/2_3_5-2_3_6.mysql > create mode 100644 sql/mysql/add_filter_tables.mysql > create mode 100644 sql/postgresql/2_3_5-2_3_6.pgsql > create mode 100644 sql/postgresql/add_filter_tables.pgsql > create mode 100644 sql/sqlite/2_3_5-2_3_6.sqlite > create mode 100644 sql/sqlite/add_filter_tables.sqlite > > > hooks/post-receive > -- > Paul's DBMail tree > _______________________________________________ > Dbmail-dev mailing list > [email protected] > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
