psa.subdomains

Overview

Column Descriptions

id –

CREATE TABLE `subdomains` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dom_id` int(10) unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET ascii NOT NULL,
  `displayName` varchar(255) CHARACTER SET utf8 NOT NULL,
  `www_root` text CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `sys_user_id` int(10) unsigned NOT NULL,
  `ssi` enum('false','true') NOT NULL DEFAULT 'false',
  `php` enum('false','true') NOT NULL DEFAULT 'false',
  `cgi` enum('false','true') NOT NULL DEFAULT 'false',
  `perl` enum('false','true') NOT NULL DEFAULT 'false',
  `python` enum('false','true') NOT NULL DEFAULT 'false',
  `fastcgi` enum('false','true') NOT NULL DEFAULT 'false',
  `miva` enum('false','true') NOT NULL DEFAULT 'false',
  `coldfusion` enum('false','true') NOT NULL DEFAULT 'false',
  `asp` enum('false','true') NOT NULL DEFAULT 'false',
  `asp_dot_net` enum('false','true') NOT NULL DEFAULT 'false',
  `ssl` enum('false','true') NOT NULL DEFAULT 'false',
  `same_ssl` enum('false','true') NOT NULL DEFAULT 'true',
  `php_handler_type` enum('cgi','fastcgi','module') NOT NULL DEFAULT 'module',
  `maintenance_mode` enum('false','true') NOT NULL DEFAULT 'false',
  `certificate_id` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `dom_id` (`dom_id`,`name`),
  KEY `dom_id_displayName` (`dom_id`,`displayName`),
  KEY `sys_user_id` (`sys_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Related documentation