psa.IP_Addresses
Overview
The IP_Addresses
table contains the IP addresses that are configured on the server.
Column Descriptions
id – links to component_id
in Repository
table
ip_address – IP address configured on the server
mask – netmask that corresponds to the IP
iface – which interface the IP is assigned to
type – shared
or exclusive
ssl_certificate_id – links to id
in certificates
table
default_domain_id – links to id
in domains
table
Table Structure
CREATE TABLE `IP_Addresses` ( `id` int(10) unsigned NOT NULL auto_increment, `ip_address` varchar(15) character set ascii NOT NULL default '', `mask` varchar(15) character set ascii NOT NULL default '255.255.255.0', `iface` varchar(255) character set ascii collate ascii_bin NOT NULL default '', `type` enum('shared','exclusive') NOT NULL default 'shared', `ssl_certificate_id` int(10) unsigned NOT NULL default '0', `default_domain_id` int(10) unsigned default NULL, PRIMARY KEY (`id`), UNIQUE KEY `ip_address` (`ip_address`), KEY `ssl_certificate_id` (`ssl_certificate_id`), KEY `default_domain_id` (`default_domain_id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 |