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
fp – true
if FrontPage extensions are enabled, otherwise false
fp_ssl – true
if FrontPage extensions are enabled over SSL, otherwise false
fp_enable – true
if FrontPage extensions are enabled, otherwise false
fp_adm – FrontPage username
fp_pass – FrontPage password
ssi – true
if server side includes are enabled, otherwise false
php – true
if PHP is enabled, otherwise false
php_safe_mode – true
if PHP safe_mode enabled, otherwise false
cgi – true
if CGI scripts are enabled, otherwise false
perl – true
if mod_perl is enabled, otherwise false
python – true
if mod_python is enabled, otherwise false
fastcgi – true
if FastCGI is enabled, otherwise false
miva – true
if Miva Merchant is enabled, otherwise false
coldfusion – true
if ColdFusion is enabled, otherwise false
asp – true
if ASP pages are enabled, otherwise false
asp_dot_net – true
if ASP.NET is enabled, otherwise false
ssl – true
if SSL is enabled, otherwise false
webstat – type of web stats, can be none
, webalizer
or awstats
same_ssl – true
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 |