This is an old revision of the document!

CREATE TABLE users (
    userid VARCHAR(128) NOT NULL,
    password VARCHAR(64) NOT NULL,
    home VARCHAR(255) NOT NULL,
    uid INTEGER NOT NULL,
    gid INTEGER NOT NULL,
    active CHAR(1) DEFAULT 'Y' NOT NULL
);

auth_passdb = mysql /etc/dovecot/dovecot-mysql.conf auth_userdb = mysql /etc/dovecot/dovecot-mysql.conf

default_mail_env = maildir:/home/virtual_mail/%u/Maildir:INDEX=/var/mail/%u