psa.dns_recs

Overview

Column Descriptions

id –
dns_zone_id –
type –
displayHost –
host –
displayVal –
val –
opt –
time_stamp –

CREATE TABLE `dns_recs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dns_zone_id` int(10) unsigned DEFAULT NULL,
  `type` enum('NS','A','AAAA','CNAME','MX','PTR','TXT','SRV','master','none') NOT NULL DEFAULT 'A',
  `displayHost` varchar(255) CHARACTER SET utf8 NOT NULL,
  `host` varchar(255) CHARACTER SET ascii NOT NULL,
  `displayVal` varchar(255) CHARACTER SET utf8 NOT NULL,
  `val` varchar(255) CHARACTER SET ascii NOT NULL,
  `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`),
  KEY `host` (`host`)
) ENGINE=InnoDB AUTO_INCREMENT=332 DEFAULT CHARSET=latin1

Related documentation