| 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; |
