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

CREATE TABLE `dns_recs_t` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
  `type` enum('NS','A','AAAA','CNAME','MX','PTR','TXT','SRV') 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`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1

CREATE TABLE `dns_recs_t` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL, `type` enum('NS','A','AAAA','CNAME','MX','PTR','TXT','SRV') 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`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1