· 7 years ago · Dec 17, 2018, 08:52 PM
1CREATE TABLE IF NOT EXISTS `records` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `domain_id` int(11) DEFAULT NULL,
4 `name` varchar(255) DEFAULT NULL,
5 `type` varchar(10) DEFAULT NULL,
6 `content` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
7 `ttl` int(11) DEFAULT NULL,
8 `prio` int(11) DEFAULT NULL,
9 `change_date` int(11) DEFAULT NULL,
10 PRIMARY KEY (`id`),
11 KEY `rec_name_index` (`name`),
12 KEY `nametype_index` (`name`,`type`),
13 KEY `domain_id` (`domain_id`)
14) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ;