+CREATE TABLE email_virtual_domains (
+ id SMALLINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
+ name VARCHAR(255) NOT NULL DEFAULT '',
+ aliasing SMALLINT(3) UNSIGNED NOT NULL DEFAULT 1,
+ PRIMARY KEY (id),
+ KEY (name),
+ FOREIGN KEY (aliasing) REFERENCES email_virtual_domains (id) ON UPDATE CASCADE ON DELETE CASCADE
+) ENGINE=InnoDB, CHARSET=utf8;
+