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

CREATE TABLE `SiteApps` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `app_release` varchar(30) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `dom_id` int(10) unsigned NOT NULL,
  `dom_type` enum('domain','subdomain') NOT NULL DEFAULT 'domain',
  `install_prefix` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `htdocs_directory` enum('httpdocs','httpsdocs') NOT NULL DEFAULT 'httpdocs',
  `capp_item_id` int(10) unsigned NOT NULL,
  `params_id` int(10) unsigned DEFAULT NULL,
  `license_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `capp_item_id` (`capp_item_id`),
  KEY `params_id` (`params_id`),
  KEY `license_id` (`license_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `SiteApps` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `app_release` varchar(30) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `dom_id` int(10) unsigned NOT NULL, `dom_type` enum('domain','subdomain') NOT NULL DEFAULT 'domain', `install_prefix` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `htdocs_directory` enum('httpdocs','httpsdocs') NOT NULL DEFAULT 'httpdocs', `capp_item_id` int(10) unsigned NOT NULL, `params_id` int(10) unsigned DEFAULT NULL, `license_id` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `capp_item_id` (`capp_item_id`), KEY `params_id` (`params_id`), KEY `license_id` (`license_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1