psa.dns_zone

Overview
The dns_zone table contains the basic information about the DNS zones on the server. Most of the data that you would find in the SOA record is stored in the dns_zone table.

Column Descriptions
id – primary key that is linked from the domains table as dns_zone_id
name – the zone’s domain name as it appears in the zone file (should match displayName)
displayName – the zone’s domain name as it appears in Plesk (should match name)
status0 if DNS is enabled, 16 if disabled
email – e-mail address to include in the SOA record
typemaster for master zone, or slave for slave zone
ttl – current TTL value for the zone
ttl_unit – which TTL unit to show in Plesk
refresh – refresh value for the zone
refresh_unit – which refresh value unit to show in Plesk
retry – retry value for the zone
retry_unit – which retry value unit to show in Plesk
expire – expire value for the zone
expire_unit – which expire unit to show in Plesk
minimum – minimum value for the zone
minimum_unit – which minimum unit to show in Plesk
serial_format – either UNIXTIMESTAMP or a specific date string in the format YYYYMMDDNN
serial – contains serial value based on the serial_format

Table Structure

CREATE TABLE `dns_zone` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `name` varchar(255) character set ascii NOT NULL default '',
 `displayName` varchar(255) character set utf8 NOT NULL default '',
 `status` int(10) unsigned NOT NULL default '0',
 `email` varchar(255) character set utf8 default NULL,
 `type` enum('slave','master') NOT NULL default 'master',
 `ttl` int(10) unsigned NOT NULL default '86400',
 `ttl_unit` int(10) unsigned NOT NULL default '1',
 `refresh` int(10) unsigned NOT NULL default '10800',
 `refresh_unit` int(10) unsigned NOT NULL default '1',
 `retry` int(10) unsigned NOT NULL default '3600',
 `retry_unit` int(10) unsigned NOT NULL default '1',
 `expire` int(10) unsigned NOT NULL default '604800',
 `expire_unit` int(10) unsigned NOT NULL default '1',
 `minimum` int(10) unsigned NOT NULL default '10800',
 `minimum_unit` int(10) unsigned NOT NULL default '1',
 `serial_format` enum('UNIXTIMESTAMP','YYYYMMDDNN') NOT NULL default 'UNIXTIMESTAMP',
 `serial` varchar(12) character set ascii collate ascii_bin NOT NULL default '0',
 PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=229 DEFAULT CHARSET=latin1

Related documentation