* 'create_tables.pgsql' - Added view vmm_domain_info * 'VirtualMailManager/Alias.py' - Removed attribute Alias._aid - Removed parameter basedir from Alias.__init__() and Alias._setAddr() * 'VirtualMailManager/MailLocation.py' - Fixed typo in MailLocation.__init__() * 'VirtualMailManager/Account.py' - Integrated Transport- and MailLocation-stuff - Removed attributes: Account._base and Account._home * 'VirtualMailManager/VirtualMailManager.py' - some small fixes * 'VirtualMailManager/Domain.py' - Added Transport-stuff * 'vmm.cfg' - 'Added option transport in section misc'

     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