Hi, all.

Is it possible to implement MySQL global address book?

I heard many users expect this feature.

We store virtual mail users in MySQL as bellow (SQL structure is based
on PostfixAdmin):

mysql> desc mailbox;
+----------+--------------+------+-----+---------------------+-------+
| Field    | Type         | Null | Key | Default             | Extra |
+----------+--------------+------+-----+---------------------+-------+
| username | varchar(255) | NO   | PRI | NULL                |       |
| password | varchar(255) | NO   |     | NULL                |       |
| name     | varchar(255) | NO   |     | NULL                |       |
| maildir  | varchar(255) | NO   |     | NULL                |       |
| quota    | bigint(20)   | NO   |     | 0                   |       |
| domain   | varchar(255) | NO   |     | NULL                |       |
| created  | datetime     | NO   |     | 0000-00-00 00:00:00 |       |
| modified | datetime     | NO   |     | 0000-00-00 00:00:00 |       |
| active   | tinyint(1)   | NO   |     | 1                   |       |
+----------+--------------+------+-----+---------------------+-------+

mysql> select username,domain from mailbox;
+-----------------+--------+
| username        | domain |
+-----------------+--------+
| [EMAIL PROTECTED] | a.cn   |
| [EMAIL PROTECTED]        | a.cn   |
+-----------------+--------+

Is it possible to display 'username' and/or other fields in roundcubemail
address book area?

Thanks very much. :)

-- 
Best Regards.

Zhang Huangbin

- OpenBSD 4.2 -release, i386.
- RHEL 5.1 Client


_______________________________________________
List info: http://lists.roundcube.net/users/

Reply via email to