| | |
| | | `server_id` int(11) NOT NULL default '1', |
| | | `zone` int(11) unsigned NOT NULL DEFAULT '0', |
| | | `name` varchar(255) NOT NULL DEFAULT '', |
| | | `type` enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT') default NULL, |
| | | `type` enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT','TLSA','DNSKEY') default NULL, |
| | | `data` TEXT NOT NULL DEFAULT '', |
| | | `aux` int(11) unsigned NOT NULL default '0', |
| | | `ttl` int(11) unsigned NOT NULL default '3600', |
| | |
| | | `xfer` varchar(255) NOT NULL DEFAULT '', |
| | | `also_notify` varchar(255) default NULL, |
| | | `update_acl` varchar(255) default NULL, |
| | | `dnssec_initialized` ENUM('Y','N') NOT NULL DEFAULT 'N', |
| | | `dnssec_info` TEXT NULL, |
| | | PRIMARY KEY (`id`), |
| | | UNIQUE KEY `origin` (`origin`), |
| | | KEY `active` (`active`) |