1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

CREATE TABLE `dns_recs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dns_zone_id` int(10) unsigned DEFAULT NULL,
  `type` enum('NS','A','AAAA','CNAME','MX','PTR','TXT','SRV','master','none') NOT NULL DEFAULT 'A',
  `displayHost` varchar(255) CHARACTER SET utf8 NOT NULL,
  `host` varchar(255) CHARACTER SET ascii NOT NULL,
  `displayVal` varchar(255) CHARACTER SET utf8 NOT NULL,
  `val` varchar(255) CHARACTER SET ascii NOT NULL,
  `opt` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '',
  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `type` (`type`),
  KEY `dns_zone_id` (`dns_zone_id`),
  KEY `host` (`host`)
) ENGINE=InnoDB AUTO_INCREMENT=332 DEFAULT CHARSET=latin1

CREATE TABLE `dns_recs` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `dns_zone_id` int(10) unsigned DEFAULT NULL, `type` enum('NS','A','AAAA','CNAME','MX','PTR','TXT','SRV','master','none') NOT NULL DEFAULT 'A', `displayHost` varchar(255) CHARACTER SET utf8 NOT NULL, `host` varchar(255) CHARACTER SET ascii NOT NULL, `displayVal` varchar(255) CHARACTER SET utf8 NOT NULL, `val` varchar(255) CHARACTER SET ascii NOT NULL, `opt` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '', `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `type` (`type`), KEY `dns_zone_id` (`dns_zone_id`), KEY `host` (`host`) ) ENGINE=InnoDB AUTO_INCREMENT=332 DEFAULT CHARSET=latin1