1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27

CREATE TABLE `subdomains` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dom_id` int(10) unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET ascii NOT NULL,
  `displayName` varchar(255) CHARACTER SET utf8 NOT NULL,
  `www_root` text CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `sys_user_id` int(10) unsigned NOT NULL,
  `ssi` enum('false','true') NOT NULL DEFAULT 'false',
  `php` enum('false','true') NOT NULL DEFAULT 'false',
  `cgi` enum('false','true') NOT NULL DEFAULT 'false',
  `perl` enum('false','true') NOT NULL DEFAULT 'false',
  `python` enum('false','true') NOT NULL DEFAULT 'false',
  `fastcgi` enum('false','true') NOT NULL DEFAULT 'false',
  `miva` enum('false','true') NOT NULL DEFAULT 'false',
  `coldfusion` enum('false','true') NOT NULL DEFAULT 'false',
  `asp` enum('false','true') NOT NULL DEFAULT 'false',
  `asp_dot_net` enum('false','true') NOT NULL DEFAULT 'false',
  `ssl` enum('false','true') NOT NULL DEFAULT 'false',
  `same_ssl` enum('false','true') NOT NULL DEFAULT 'true',
  `php_handler_type` enum('cgi','fastcgi','module') NOT NULL DEFAULT 'module',
  `maintenance_mode` enum('false','true') NOT NULL DEFAULT 'false',
  `certificate_id` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `dom_id` (`dom_id`,`name`),
  KEY `dom_id_displayName` (`dom_id`,`displayName`),
  KEY `sys_user_id` (`sys_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `subdomains` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `dom_id` int(10) unsigned NOT NULL, `name` varchar(255) CHARACTER SET ascii NOT NULL, `displayName` varchar(255) CHARACTER SET utf8 NOT NULL, `www_root` text CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `sys_user_id` int(10) unsigned NOT NULL, `ssi` enum('false','true') NOT NULL DEFAULT 'false', `php` enum('false','true') NOT NULL DEFAULT 'false', `cgi` enum('false','true') NOT NULL DEFAULT 'false', `perl` enum('false','true') NOT NULL DEFAULT 'false', `python` enum('false','true') NOT NULL DEFAULT 'false', `fastcgi` enum('false','true') NOT NULL DEFAULT 'false', `miva` enum('false','true') NOT NULL DEFAULT 'false', `coldfusion` enum('false','true') NOT NULL DEFAULT 'false', `asp` enum('false','true') NOT NULL DEFAULT 'false', `asp_dot_net` enum('false','true') NOT NULL DEFAULT 'false', `ssl` enum('false','true') NOT NULL DEFAULT 'false', `same_ssl` enum('false','true') NOT NULL DEFAULT 'true', `php_handler_type` enum('cgi','fastcgi','module') NOT NULL DEFAULT 'module', `maintenance_mode` enum('false','true') NOT NULL DEFAULT 'false', `certificate_id` int(10) unsigned DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `dom_id` (`dom_id`,`name`), KEY `dom_id_displayName` (`dom_id`,`displayName`), KEY `sys_user_id` (`sys_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1