1CREATE DATABASE `BindDB` DEFAULT CHARACTER SET latin1; 2USE `BindDB`; 3 4CREATE TABLE IF NOT EXISTS `records` ( 5 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 6 `zone` varchar(255) NOT NULL, 7 `ttl` int(11) NOT NULL DEFAULT '86400', 8 `type` varchar(255) NOT NULL, 9 `host` varchar(255) NOT NULL DEFAULT '@', 10 `mx_priority` int(11) DEFAULT NULL, 11 `data` text, 12 `primary_ns` varchar(255) DEFAULT NULL, 13 `resp_contact` varchar(255) DEFAULT NULL, 14 `serial` bigint(20) DEFAULT NULL, 15 `refresh` int(11) DEFAULT NULL, 16 `retry` int(11) DEFAULT NULL, 17 `expire` int(11) DEFAULT NULL, 18 `minimum` int(11) DEFAULT NULL, 19 PRIMARY KEY (`id`), 20 KEY `type` (`type`), 21 KEY `host` (`host`), 22 KEY `zone` (`zone`) 23) ENGINE=InnoDB DEFAULT CHARSET=latin1; 24 25CREATE TABLE IF NOT EXISTS `xfr` ( 26 `zone` varchar(255) NOT NULL, 27 `client` varchar(255) NOT NULL, 28 KEY `zone` (`zone`), 29 KEY `client` (`client`) 30) ENGINE=InnoDB DEFAULT CHARSET=latin1; 31