--- a/pgsql/create_tables-dovecot-1.2.x.pgsql Thu Feb 10 20:10:28 2011 +0000
+++ b/pgsql/create_tables-dovecot-1.2.x.pgsql Thu Feb 10 23:33:57 2011 +0000
@@ -192,8 +192,7 @@
LEFT JOIN domain_name USING (gid);
CREATE OR REPLACE VIEW vmm_domain_info AS
- SELECT gid, domainname, transport, domaindir,
- count(uid) AS accounts,
+ SELECT gid, count(uid) AS accounts,
(SELECT count(DISTINCT address)
FROM alias
WHERE alias.gid = domain_data.gid) AS aliases,
@@ -203,15 +202,12 @@
(SELECT count(gid)
FROM domain_name
WHERE domain_name.gid = domain_data.gid
- AND NOT domain_name.is_primary) AS aliasdomains,
- bytes, messages
+ AND NOT domain_name.is_primary) AS aliasdomains
FROM domain_data
LEFT JOIN domain_name USING (gid)
- LEFT JOIN quotalimit USING (qid)
- LEFT JOIN transport USING (tid)
LEFT JOIN users USING (gid)
WHERE domain_name.is_primary
- GROUP BY gid, domainname, transport, domaindir, bytes, messages;
+ GROUP BY gid;
CREATE LANGUAGE plpgsql;