1CREATE DATABASE `BindDB` DEFAULT CHARACTER SET latin1; 2USE `BindDB`; 3 4CREATE TABLE `ZoneData` ( 5 `id` int(11) NOT NULL AUTO_INCREMENT, 6 `zone_id` int(11) NOT NULL, 7 `name` varchar(128) NOT NULL DEFAULT '', 8 `type` varchar(16) NOT NULL DEFAULT '', 9 `data` varchar(128) NOT NULL DEFAULT '', 10 `ttl` int(11) NOT NULL DEFAULT '86400', 11 PRIMARY KEY (`id`), 12 KEY `zone_idx` (`zone_id`), 13 KEY `name_idx` (`zone_id`, `name`), 14 KEY `type_idx` (`type`) 15) ENGINE=InnoDB DEFAULT CHARSET=latin1; 16 17CREATE TABLE `Zones` ( 18 `id` int(11) NOT NULL AUTO_INCREMENT, 19 `domain` varchar(128) NOT NULL DEFAULT '', 20 `host` varchar(128) NOT NULL DEFAULT '', 21 `admin` varchar(128) NOT NULL DEFAULT '', 22 `serial` int(11) NOT NULL DEFAULT '1', 23 `expire` int(11) NOT NULL DEFAULT '86400', 24 `refresh` int(11) NOT NULL DEFAULT '86400', 25 `retry` int(11) NOT NULL DEFAULT '86400', 26 `minimum` int(11) NOT NULL DEFAULT '86400', 27 `ttl` int(11) NOT NULL DEFAULT '86400', 28 `writeable` tinyint(1) NOT NULL DEFAULT '0', 29 PRIMARY KEY (`id`), 30 KEY `domain_idx` (`domain`) 31) ENGINE=InnoDB DEFAULT CHARSET=latin1; 32