psa.hosting

Overview
The hosting table contains the web hosting configuration for domains on the server.

Column Descriptions
dom_id – links to id in domains table
sys_user_id – links to id in sys_users table
ip_address_id – links to id in IP_Addresses table
real_traffic – maximum amount of bandwidth that the site is allowed to use
fptrue if FrontPage extensions are enabled, otherwise false
fp_ssltrue if FrontPage extensions are enabled over SSL, otherwise false
fp_enabletrue if FrontPage extensions are enabled, otherwise false
fp_adm – FrontPage username
fp_pass – FrontPage password
ssitrue if server side includes are enabled, otherwise false
phptrue if PHP is enabled, otherwise false
php_safe_modetrue if PHP safe_mode enabled, otherwise false
cgitrue if CGI scripts are enabled, otherwise false
perltrue if mod_perl is enabled, otherwise false
pythontrue if mod_python is enabled, otherwise false
fastcgitrue if FastCGI is enabled, otherwise false
mivatrue if Miva Merchant is enabled, otherwise false
coldfusiontrue if ColdFusion is enabled, otherwise false
asptrue if ASP pages are enabled, otherwise false
asp_dot_nettrue if ASP.NET is enabled, otherwise false
ssltrue if SSL is enabled, otherwise false
webstat – type of web stats, can be none, webalizer or awstats
same_ssltrue if SSL and non-SSL requests should be served out of httpdocs, otherwise false
traffic_bandwidth – limits the transfer rate to the site
max_connection – maximum simultaneous connections to the site

Table Structure

CREATE TABLE `hosting` (
 `dom_id` int(10) unsigned NOT NULL default '0',
 `sys_user_id` int(10) unsigned NOT NULL default '0',
 `ip_address_id` int(10) unsigned NOT NULL default '0',
 `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 default '',
 `fp_pass` varchar(20) character set ascii collate ascii_bin NOT NULL default '',
 `ssi` enum('false','true') NOT NULL default 'false',
 `php` enum('false','true') NOT NULL default 'false',
 `php_safe_mode` enum('false','true') NOT NULL default 'true',
 `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',
 `webstat` enum('none','webalizer','awstats') NOT NULL default 'none',
 `same_ssl` enum('false','true') NOT NULL default 'false',
 `traffic_bandwidth` int(11) default '-1',
 `max_connection` int(11) default '-1',
 PRIMARY KEY  (`dom_id`),
 UNIQUE KEY `sys_user_id` (`sys_user_id`),
 KEY `ip_address_id` (`ip_address_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Related documentation