On 07/14/2010 05:55 PM, Timo Sirainen wrote:
On Wed, 2010-07-14 at 17:42 +0300, alex wrote:
login with the first user .. ..so far so good
login with the second user
..domain quota usage is unchange and messages the same.
A login doesn't change quota (the first login recalculates it, because there is no row in dict). What if the second user saves new mails or expunges mails? That should change quota.
Ok, I have send a mail to the second user:
select * from domain_quota where domain like '%example.com'; +----------------+------------+----------+---------------------+ | domain | used_quota | messages | last_update | +----------------+------------+----------+---------------------+ | example.com | 124042046 | 21831 | 2010-07-14 17:57:37 | +----------------+------------+----------+---------------------+
select * from quota where email like '%example.com'; +---------------------+------------+----------+---------------------+ | email | used_quota | messages | last_update | +---------------------+------------+----------+---------------------+ | me@example.com | 124038256 | 21830 | 2010-07-14 17:56:03 | | radu@example.com | 1802216 | 3 | 2010-07-14 17:57:37 | +---------------------+------------+----------+---------------------+
The domain_quota is updated only with the new message. The two messages and sizes, that already exists are not added to the domain quota.