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
status – 0 if enabled, otherwise 16
name – name of the domain alias (should match displayName)
displayName – name of the domain alias (should match name)
dns – true if DNS should match parent domain, otherwise false – true if mail delivery should be forwarded to the parent domain, otherwise false
mail – true if mail delivery should be forwarded to the parent domain, otherwise false
web – true if web traffic should be forwarded to the parent domain, otherwise false
tomcat – true 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 |