* 'create_tables.pgsql' - Renamed table maildir to maillocation - Added transport id (tid) to table domains, for default transport * 'VirtualMailManager/MailLocation.py' * 'VirtualMailManager/Transport.py' - Added to repository * 'VirtualMailManager/constants/ERROR.py' - Added error codes for MailLocation and Transport classes * 'VirtualMailManager/Exceptions.py' - Added exception classes for MailLocation and Transport

     1

-- $Id$

     2

     3

DROP VIEW ma_aliases_count;

     4

CREATE OR REPLACE VIEW vmm_alias_count AS

     5

    SELECT count(DISTINCT address) AS aliases, gid

     6

      FROM alias

     7

  GROUP BY gid;

     8