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

CREATE TABLE `domainaliases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dom_id` int(10) unsigned NOT NULL,
  `dns_zone_id` int(10) unsigned NOT NULL,
  `status` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET ascii NOT NULL,
  `displayName` varchar(255) CHARACTER SET utf8 NOT NULL,
  `dns` enum('false','true') NOT NULL DEFAULT 'false',
  `mail` enum('false','true') NOT NULL DEFAULT 'false',
  `web` enum('false','true') NOT NULL DEFAULT 'false',
  `tomcat` enum('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `dom_id` (`dom_id`),
  KEY `dns_zone_id` (`dns_zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `domainaliases` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `dom_id` int(10) unsigned NOT NULL, `dns_zone_id` int(10) unsigned NOT NULL, `status` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) CHARACTER SET ascii NOT NULL, `displayName` varchar(255) CHARACTER SET utf8 NOT NULL, `dns` enum('false','true') NOT NULL DEFAULT 'false', `mail` enum('false','true') NOT NULL DEFAULT 'false', `web` enum('false','true') NOT NULL DEFAULT 'false', `tomcat` enum('false','true') NOT NULL DEFAULT 'false', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `dom_id` (`dom_id`), KEY `dns_zone_id` (`dns_zone_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1