dbpath = /etc/postfix/private/mail.sqlite
query = SELECT coalesce(VM.vmGid, 800)
	FROM VMailbox AS VM
	JOIN Address AS A1 ON VM.vmNum=A1.addNum
	JOIN Domain AS D1 ON A1.addDomNum=D1.domNum
	WHERE A1.addLocalpart || '@' || D1.domName IS '%s'
	AND VM.active!=0

# Most howtos for Postfix virtual mailboxes, including the official
# VIRTUAL_README document, use static maps for UID and GID:
#	virtual_uid_maps = static:5000
#	virtual_gid_maps = static:5000
# This is easiest for usability, but exposes a potential security
# weakness in that an exploit of the imapd or the virtual user/group
# could lead to compromise or loss of all mailboxes.
#
# Here for the GID query, we use a default shared GID which owns and has
# g+rwx privilege on /home/vmail, under which is where we deliver mail
# to %d/%u/Mail/ maildirs. This means that virtual(8) can create new
# mailboxes when mail arrives.