Brad, > Hello, my msgs table does not contain an 'email' column, and I don't see it > in the mysql readme schema either.
It is a field in table mailaddr. Tables msgs and msgrcpt contain a reference (sid or rid) to an e-mail address, which is stored in full in table mailaddr. > Is it ok to add this field to the msgs > table, and will it get automagically used by the sql logging routine? No. > Right now it requires a rather long sql query string to build a report of > each users email without that value in the msgs table. Maybe I missed it > somewhere in the docs... Just do a JOIN. That's the whole point of relational databases: avoid duplicates, store unique information in one place only and save space. Mark ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
