CREATE TABLE IF NOT EXISTS `domains` (
|
`id` int(11) NOT NULL auto_increment,
|
`name` varchar(255) NOT NULL,
|
`master` varchar(128) default NULL,
|
`last_check` int(11) default NULL,
|
`type` varchar(6) NOT NULL,
|
`notified_serial` int(11) default NULL,
|
`account` varchar(40) default NULL,
|
`ispconfig_id` int(11) NOT NULL,
|
PRIMARY KEY (`id`),
|
UNIQUE KEY `name_index` (`name`)
|
) ENGINE=InnoDB;
|
|
CREATE TABLE IF NOT EXISTS `records` (
|
`id` int(11) NOT NULL auto_increment,
|
`domain_id` int(11) default NULL,
|
`name` varchar(255) default NULL,
|
`type` varchar(6) default NULL,
|
`content` TEXT default NULL,
|
`ttl` int(11) default NULL,
|
`prio` int(11) default NULL,
|
`change_date` int(11) default NULL,
|
`ispconfig_id` int(11) NOT NULL,
|
PRIMARY KEY (`id`),
|
KEY `rec_name_index` (`name`),
|
KEY `nametype_index` (`name`,`type`),
|
KEY `domain_id` (`domain_id`)
|
) ENGINE=InnoDB;
|
|
CREATE TABLE IF NOT EXISTS `supermasters` (
|
`ip` varchar(25) NOT NULL,
|
`nameserver` varchar(255) NOT NULL,
|
`account` varchar(40) default NULL
|
) ENGINE=InnoDB;
|