--- a/pgsql/update_tables_0.5.x-0.6-dovecot-1.2.x.pgsql Sun Apr 08 19:05:25 2012 +0000
+++ b/pgsql/update_tables_0.5.x-0.6-dovecot-1.2.x.pgsql Mon Apr 09 17:45:02 2012 +0200
@@ -165,6 +165,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