aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan HuntCREATE DATABASE `BindDB` DEFAULT CHARACTER SET latin1;
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan HuntUSE `BindDB`;
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan HuntCREATE TABLE `ZoneData` (
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `id` int(11) NOT NULL AUTO_INCREMENT,
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `zone_id` int(11) NOT NULL,
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `name` varchar(128) NOT NULL DEFAULT '',
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `type` varchar(16) NOT NULL DEFAULT '',
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `data` varchar(128) NOT NULL DEFAULT '',
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `ttl` int(11) NOT NULL DEFAULT '86400',
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt PRIMARY KEY (`id`),
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt KEY `zone_idx` (`zone_id`),
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt KEY `name_idx` (`zone_id`, `name`),
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt KEY `type_idx` (`type`)
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt) ENGINE=InnoDB DEFAULT CHARSET=latin1;
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan HuntCREATE TABLE `Zones` (
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `id` int(11) NOT NULL AUTO_INCREMENT,
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `domain` varchar(128) NOT NULL DEFAULT '',
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `host` varchar(128) NOT NULL DEFAULT '',
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `admin` varchar(128) NOT NULL DEFAULT '',
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `serial` int(11) NOT NULL DEFAULT '1',
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `expire` int(11) NOT NULL DEFAULT '86400',
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `refresh` int(11) NOT NULL DEFAULT '86400',
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `retry` int(11) NOT NULL DEFAULT '86400',
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `minimum` int(11) NOT NULL DEFAULT '86400',
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `ttl` int(11) NOT NULL DEFAULT '86400',
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt `writeable` tinyint(1) NOT NULL DEFAULT '0',
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt PRIMARY KEY (`id`),
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt KEY `domain_idx` (`domain`)
aefb3e308ba01ad47a3d3aaadf77a5edd4261cb9Evan Hunt) ENGINE=InnoDB DEFAULT CHARSET=latin1;