psa.hosting

Overview

Column Descriptions

id –

CREATE TABLE `hosting` (
  `dom_id` int(10) unsigned NOT NULL,
  `sys_user_id` int(10) unsigned NOT NULL,
  `ip_address_id` int(10) unsigned NOT NULL,
  `www_root` text CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `real_traffic` bigint(20) unsigned DEFAULT '0',
  `fp` enum('false','true') NOT NULL DEFAULT 'false',
  `fp_ssl` enum('false','true') NOT NULL DEFAULT 'false',
  `fp_enable` enum('false','true') NOT NULL DEFAULT 'false',
  `fp_adm` varchar(16) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `fp_pass` varchar(20) CHARACTER SET ascii COLLATE ascii_bin 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',
  `webstat` enum('none','webalizer','awstats') NOT NULL DEFAULT 'none',
  `traffic_bandwidth` int(11) DEFAULT '-1',
  `max_connection` int(11) DEFAULT '-1',
  `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 (`dom_id`),
  KEY `ip_address_id` (`ip_address_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Related documentation