psa.dns_zone

Overview
Column Descriptions

id –

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

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

March 13th, 2013 in Uncategorized