update_tables_0.2.x-0.3.pgsql
author Pascal Volk <neverseen@users.sourceforge.net>
Wed, 09 Jan 2008 20:34:31 +0000
changeset 4 f3c30b7421b9
parent 0 bb0aa2102206
permissions -rw-r--r--
* 'install.sh' - Also install docs * 'VirtualMailManager/Account.py' * 'VirtualMailManager/Alias.py' * 'VirtualMailManager/Config.py' * 'VirtualMailManager/Domain.py' * 'VirtualMailManager/Exceptions.py' * 'VirtualMailManager/VirtualMailManager.py' * 'setup.py' * 'vmm' - Included global version number. * 'VirtualMailManager/constants/VERSION.py' - Added to repository.

-- $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;