On Sonntag, 17. Dezember 2006 00:42 Michael Monnerie wrote: > Advantage:
Seems nobody wants to discuss this here. If the extra "dbmail_domains" table would be included, there's another simplification that would be nice: - in dbmail_users.userid you only need to store the user name without domain extension - dbmail could automatically append all possible alias domains for that user - that would need another field "domain_idnr" or so, because one client (customer) could have several domains like this: domA domB (alias of domA) domC domD (alias of domC) with my current model, you can't know from a user if he should be in domA+B or domC+D, because only the client_idnr exists The advantage: - store only userpart of login (e.g. user1, user2, user3) - auto-append alias and root domains ([EMAIL PROTECTED], [EMAIL PROTECTED], etc) - so the user can login as both domains, without any difference - the difference is just for logging purposes, e.g. user1 has a PC and a Notebook. The admin sets as username on the PC [EMAIL PROTECTED], and on the Notebook [EMAIL PROTECTED], to easily find out which PC/notebook connected when One other feature request: I'd like to have more stats. - For every hour a user logs in via imap/pop, log number of queries and bytes transferred. Like this, you can find your heavy users, which is good for optimizing the database (balance over multiple servers) - How many e-mails and bytes per hour does a user receive mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846914666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi3.asc | gpg --import" // Fingerprint: 44A3 C1EC B71E C71A B4C2 9AA6 C818 847C 55CB A4EE // Keyserver: www.keyserver.net Key-ID: 0x55CBA4EE
pgpVtn4DT6Xy9.pgp
Description: PGP signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
