| | |
| | | `ispconfig_id` int(11) NOT NULL, |
| | | PRIMARY KEY (`id`), |
| | | UNIQUE KEY `name_index` (`name`) |
| | | ) ENGINE=MyISAM; |
| | | ) 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` varchar(255) default NULL, |
| | | `content` TEXT default NULL, |
| | | `ttl` int(11) default NULL, |
| | | `prio` int(11) default NULL, |
| | | `change_date` int(11) default NULL, |
| | |
| | | KEY `rec_name_index` (`name`), |
| | | KEY `nametype_index` (`name`,`type`), |
| | | KEY `domain_id` (`domain_id`) |
| | | ) ENGINE=MyISAM; |
| | | ) ENGINE=InnoDB; |
| | | |
| | | CREATE TABLE IF NOT EXISTS `supermasters` ( |
| | | `ip` varchar(25) NOT NULL, |
| | | `nameserver` varchar(255) NOT NULL, |
| | | `account` varchar(40) default NULL |
| | | ) ENGINE=MyISAM; |
| | | ) ENGINE=InnoDB; |