[Dovecot] domain quota dictionary

[alex]

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 at example.com      |  124038256 |    21830 | 2010-07-14 17:56:03 |
| radu at 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.