# ==============================================================
MYSQL_SERVER localhost
MYSQL_USERNAME vmailprovider
MYSQL_PASSWORD **********
MYSQL_PORT 0
MYSQL_DATABASE vmaildata
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD cryptpass
MYSQL_CLEAR_PWFIELD clearpass
MYSQL_UID_FIELD 910
MYSQL_GID_FIELD 910
MYSQL_LOGIN_FIELD email
# create individual home for use .mailfilter
MYSQL_HOME_FIELD CONCAT('${VMAIL_MAILDIR_ROOT}/',SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1))
# MYSQL_MAILDIR_FIELD CONCAT('${VMAIL_MAILDIR_ROOT}/',SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
MYSQL_MAILDIR_FIELD './'
# MYSQL_NAME_FIELD (comment this out)
MYSQL_QUOTA_FIELD CONCAT(quota,'S')
MYSQL_WHERE_CLAUSE active='1'