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
typeshared 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

Related documentation