psa.dns_recs

Overview
The dns_recs table contains the actual DNS records for a specific DNS zone.

Column Descriptions
id - primary key that is automatically incremented
dns_zone_id - Links to id in dns_zone table
type - DNS record type (NS, A, CNAME, MX, PTR, TXT, master or none)
displayHost - hostname part of DNS record (left side of DNS zone file)
host - shown in Plesk, should match displayHost
displayVal - DNS server’s response (right side of DNS zone file)
val - shown in Plesk, should match displayVal
opt - subnet mask for PTR records, priority for MX records, or empty for other records
time_stamp - the last time the record was updated (automatic MySQL timestamp)

Table Structure

CREATE TABLE `dns_recs` (
 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `dns_zone_id` INT(10) UNSIGNED DEFAULT NULL,
 `type` ENUM('NS','A','CNAME','MX','PTR','TXT','SRV','master','none') NOT NULL DEFAULT 'A',
 `displayHost` VARCHAR(255) character SET utf8 NOT NULL DEFAULT '',
 `host` VARCHAR(255) character SET ASCII NOT NULL DEFAULT '',
 `displayVal` VARCHAR(255) character SET utf8 NOT NULL DEFAULT '',
 `val` VARCHAR(255) character SET ASCII NOT NULL DEFAULT '',
 `opt` VARCHAR(255) character SET ASCII NOT NULL DEFAULT '',
 `time_stamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP on UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY  (`id`),
 KEY `type` (`type`),
 KEY `dns_zone_id` (`dns_zone_id`)
) ENGINE=INNODB AUTO_INCREMENT=2827 DEFAULT CHARSET=latin1

Related documentation

September 21st, 2008 in All Tables, DNS | tags: ,