psa.dns_recs_t
Overview
The dns_recs_t table contains the DNS template for the server level.
Column Descriptions
id – primary key that is automatically incremented
type – DNS record type (NS, A, CNAME, MX, PTR, TXT, master, none)
displayHost – hostname part of the record (left side of DNS zone)
host – should match displayHost
displayVal – DNS server responds with this (right side of DNS zone)
val – should match displayVal
opt – subnet mask for PTR records, priority for MX records, or empty
time_stamp – the last time the record was updated
Table Structure
CREATE TABLE `dns_recs_t` ( `id` int(10) unsigned NOT NULL auto_increment, `type` enum('NS','A','CNAME','MX','PTR','TXT','SRV') 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`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1