| [vhffs-dev] [694] Removed useless distinct. |
[ Thread Index |
Date Index
| More vhffs.org/vhffs-dev Archives
]
Revision: 694
Author: gradator
Date: 2007-07-08 17:34:37 +0000 (Sun, 08 Jul 2007)
Log Message:
-----------
Removed useless distinct.
Modified Paths:
--------------
trunk/vhffs-doc/config/exim4-mx1/exim4.conf
Modified: trunk/vhffs-doc/config/exim4-mx1/exim4.conf
===================================================================
--- trunk/vhffs-doc/config/exim4-mx1/exim4.conf 2007-07-08 17:14:13 UTC (rev 693)
+++ trunk/vhffs-doc/config/exim4-mx1/exim4.conf 2007-07-08 17:34:37 UTC (rev 694)
@@ -1,6 +1,6 @@
hide pgsql_servers = PGHOST/PGDB/PGUSER/PGPASS
MAIL_HOME=/data/mail/boxes
-PGSQL_LOCAL_DOMAINS = ${lookup pgsql{SELECT DISTINCT domain FROM vhffs_mxdomain WHERE domain = '$domain'}}
+PGSQL_LOCAL_DOMAINS = ${lookup pgsql{SELECT domain FROM vhffs_mxdomain WHERE domain = '$domain'}}
PGSQL_VIRTUAL_LOCAL_DOMAINS = ${lookup pgsql{select vhffs_boxes.domain from vhffs_boxes, vhffs_mxdomain where local_part = '$local_part' and vhffs_boxes.domain = vhffs_mxdomain.domain and vhffs_mxdomain.domain = '$domain'}}
PGSQL_VIRTUAL_LOCAL_DIR = MAIL_HOME/${lookup pgsql{select boxes_path from vhffs_mxdomain where domain = '$domain'}{$value}fail}/${lookup pgsql{select mbox_name from vhffs_boxes where domain = '$domain' and local_part = '$local_part'}{$value}fail}/Maildir
PGSQL_VIRTUAL_FORWARD_DATA = ${lookup pgsql{select remote_name from vhffs_forward, vhffs_mxdomain where local_part = '$local_part' and vhffs_forward.domain = vhffs_mxdomain.domain and vhffs_mxdomain.domain = '$domain'}}