* 'create_tables.pgsql' - Removed unneeded sequences 'alias_id' and 'relocated_id' - Removed unneeded column 'id' from table 'alias' and 'relocated'.

     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