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