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