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 |