update_tables_0.2.x-0.3.pgsql
author Pascal Volk <neverseen@users.sourceforge.net>
Sun, 02 Mar 2008 20:22:00 +0000
changeset 9 e3d3dbeb5b84
parent 0 bb0aa2102206
permissions -rw-r--r--
* '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'

-- $Id$

DROP VIEW ma_aliases_count;
CREATE OR REPLACE VIEW vmm_alias_count AS
    SELECT count(DISTINCT address) AS aliases, gid
      FROM alias
  GROUP BY gid;