commit | author | age
|
6ecbdc
|
1 |
CREATE TABLE IF NOT EXISTS `domains` ( |
T |
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, |
|
9 |
`ispconfig_id` int(11) NOT NULL, |
|
10 |
PRIMARY KEY (`id`), |
|
11 |
UNIQUE KEY `name_index` (`name`) |
a59731
|
12 |
) ENGINE=InnoDB; |
6ecbdc
|
13 |
|
T |
14 |
CREATE TABLE IF NOT EXISTS `records` ( |
|
15 |
`id` int(11) NOT NULL auto_increment, |
|
16 |
`domain_id` int(11) default NULL, |
|
17 |
`name` varchar(255) default NULL, |
|
18 |
`type` varchar(6) default NULL, |
cef9d9
|
19 |
`content` TEXT default NULL, |
6ecbdc
|
20 |
`ttl` int(11) default NULL, |
T |
21 |
`prio` int(11) default NULL, |
|
22 |
`change_date` int(11) default NULL, |
|
23 |
`ispconfig_id` int(11) NOT NULL, |
|
24 |
PRIMARY KEY (`id`), |
|
25 |
KEY `rec_name_index` (`name`), |
|
26 |
KEY `nametype_index` (`name`,`type`), |
|
27 |
KEY `domain_id` (`domain_id`) |
a59731
|
28 |
) ENGINE=InnoDB; |
6ecbdc
|
29 |
|
T |
30 |
CREATE TABLE IF NOT EXISTS `supermasters` ( |
|
31 |
`ip` varchar(25) NOT NULL, |
|
32 |
`nameserver` varchar(255) NOT NULL, |
|
33 |
`account` varchar(40) default NULL |
a59731
|
34 |
) ENGINE=InnoDB; |