diff -r e1b32377032f -r 492c179094c9 pgsql/update_tables_0.5.x-0.6.pgsql --- a/pgsql/update_tables_0.5.x-0.6.pgsql Sun Apr 08 19:05:25 2012 +0000 +++ b/pgsql/update_tables_0.5.x-0.6.pgsql Mon Apr 09 17:45:02 2012 +0200 @@ -143,6 +143,18 @@ FOREIGN KEY (ssid) REFERENCES service_set (ssid); -- --- +-- Catchall +-- --- + +CREATE TABLE catchall ( + gid bigint NOT NULL, + destination varchar(320) NOT NULL, + CONSTRAINT pkey_catchall PRIMARY KEY (gid, destination), + CONSTRAINT fkey_catchall_gid_domain_data FOREIGN KEY (gid) + REFERENCES domain_data (gid) +); + +-- --- -- Restore view -- --- CREATE VIEW vmm_domain_info AS