1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE `dns_refs` (
  `uid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `zoneId` int(10) unsigned NOT NULL,
  `zoneRecordId` int(10) unsigned DEFAULT NULL,
  `templateRecordId` int(10) unsigned DEFAULT NULL,
  `status` enum('syn','mod','del') NOT NULL DEFAULT 'syn',
  PRIMARY KEY (`uid`),
  KEY `zoneId` (`zoneId`),
  KEY `zoneRecordId` (`zoneRecordId`),
  KEY `templateRecordId` (`templateRecordId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `dns_refs` ( `uid` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `zoneId` int(10) unsigned NOT NULL, `zoneRecordId` int(10) unsigned DEFAULT NULL, `templateRecordId` int(10) unsigned DEFAULT NULL, `status` enum('syn','mod','del') NOT NULL DEFAULT 'syn', PRIMARY KEY (`uid`), KEY `zoneId` (`zoneId`), KEY `zoneRecordId` (`zoneRecordId`), KEY `templateRecordId` (`templateRecordId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1