psa.dns_zone

Overview

Column Descriptions

id –

CREATE TABLE `dns_zone` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET ascii NOT NULL,
  `displayName` varchar(255) CHARACTER SET utf8 NOT NULL,
  `status` int(10) unsigned NOT NULL DEFAULT '0',
  `syncSoa` enum('true','false','skip') NOT NULL DEFAULT 'skip',
  `syncRecords` enum('true','false','skip') NOT NULL DEFAULT 'skip',
  `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=15 DEFAULT CHARSET=latin1

Related documentation