psa.domainaliases

Overview
The domainaliases table contains aliases for domains on the server.

Column Descriptions
id – primary key that is automatically incremented
dom_id – links to id in domains table
dns_zone_id – links to id in dns_zone
status0 if enabled, otherwise 16
name – name of the domain alias (should match displayName)
displayName – name of the domain alias (should match name)
dnstrue if DNS should match parent domain, otherwise falsetrue if mail delivery should be forwarded to the parent domain, otherwise false
mailtrue if mail delivery should be forwarded to the parent domain, otherwise false
webtrue if web traffic should be forwarded to the parent domain, otherwise false
tomcattrue if java application requests should be forwarded to the parent domain, otherwise false

Table Structure

CREATE TABLE `domainaliases` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `dom_id` int(10) unsigned NOT NULL default '0',
 `dns_zone_id` int(10) unsigned NOT NULL default '0',
 `status` int(10) unsigned NOT NULL default '0',
 `name` varchar(255) character set ascii NOT NULL default '',
 `displayName` varchar(255) character set utf8 NOT NULL default '',
 `dns` enum('false','true') NOT NULL default 'false',
 `mail` enum('false','true') NOT NULL default 'false',
 `web` enum('false','true') NOT NULL default 'false',
 `tomcat` enum('false','true') NOT NULL default 'false',
 PRIMARY KEY  (`id`),
 UNIQUE KEY `name` (`name`),
 KEY `dom_id` (`dom_id`),
 KEY `dns_zone_id` (`dns_zone_id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1

Related documentation