FuTpV3je

1CREATE TABLE IF NOT EXISTS `domains` (
2`id` int(11) NOT NULL AUTO_INCREMENT,
3`name` varchar(255) NOT NULL,
4`master` varchar(128) DEFAULT NULL,
5`last_check` int(11) DEFAULT NULL,
6`type` varchar(6) NOT NULL,
7`notified_serial` int(11) DEFAULT NULL,
8`account` varchar(40) DEFAULT NULL,
9PRIMARY KEY (`id`),
10UNIQUE KEY `name_index` (`name`)
11) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
12
13CREATE TABLE IF NOT EXISTS `records` (
14`id` int(11) NOT NULL AUTO_INCREMENT,
15`domain_id` int(11) DEFAULT NULL,
16`name` varchar(255) DEFAULT NULL,
17`type` varchar(6) DEFAULT NULL,
18`content` varchar(255) DEFAULT NULL,
19`ttl` int(11) DEFAULT NULL,
20`prio` int(11) DEFAULT NULL,
21`change_date` int(11) DEFAULT NULL,
22PRIMARY KEY (`id`),
23KEY `rec_name_index` (`name`),
24KEY `nametype_index` (`name`,`type`),
25KEY `domain_id` (`domain_id`)
26) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;