On 25.4.2012, at 9.49, Robert Schetterer wrote:
#when saving to Trash mailbox the user gets additional 50MB "Trash:storage=+50240" AS quota_rule2,
#when saving to Sent mailbox the user gets additional 50MB "Sent:storage=+50240" AS quota_rule3,
#when saving to Drafts mailbox the user gets additional 50MB "Drafts:storage=+50240" AS quota_rule4,
#when saving to Templates mailbox the user gets additional 50MB "Templates:storage=+50240" AS quota_rule5,
#when saving to Junk mailbox the user gets additional 50MB "Junk:storage=+50240" AS quota_rule6,
#when saving to Archives mailbox the user gets additional 50MB "Archives:storage=+50240" AS quota_rule7,
###########
BTW. These are all static values and don't really need to be in SQL query:
plugin { quota_rule2 = Trash:... quota_rule3 = ... ... }
1001 as userdb_uid,
1001 as userdb_gid,
"/usr/local/virtual/%d/%u/" AS userdb_home,
"maildir:/usr/local/virtual/%d/%u/" AS userdb_mail \
Same for these. Also slightly confusing that your passdb and userdb lookups return mail setting differently.