[Dovecot] MySQL database structure

[Joan]

2007/3/11, Erdenebat Gantomor <rklogin at gmail.com>:
>
> In Postfix+Postfixadmin+Dovecot+SASL+MySQL case what is the best and
> compact MySQL database structure for storing all configuration? What
> will you suggest me guys? I've already installed postfixadmin and I'm
> confusing (actually my experience is not enough) extending and
> organizing my database for postfix+dovecot. Please give me some quick
> tips.
> --
> In /etc/dovecot/dovecot-sql.conf you can see the sample structure with the
> minimum required fields:
>
> # 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
> # );
>
> In my case I changed to use always the same userid and groupid, so that
> fields are not needed,  and if you plan to use virtual domains, you will
> need to split userid to separate into id and domain.
>
> Cheers
>
>
> Best regards,
>
> Erdenebat Guntomor/                   /mailto:RkLogin at gmail.com
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://dovecot.org/pipermail/dovecot/attachments/20070312/223f8eb0/attachment.html