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 |
+---------------------+------------+----------+---------------------+
| m...@example.com | 124038256 | 21830 | 2010-07-14 17:56:03 |
| r...@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.
