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)
status – 0 if DNS is enabled, 16 if disabled
email – e-mail address to include in the SOA record
type – master 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