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