psa.domainaliases

Overview

Column Descriptions

id –

CREATE TABLE `domainaliases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dom_id` int(10) unsigned NOT NULL,
  `dns_zone_id` int(10) unsigned NOT NULL,
  `status` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET ascii NOT NULL,
  `displayName` varchar(255) CHARACTER SET utf8 NOT NULL,
  `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 DEFAULT CHARSET=latin1

Related documentation