psa.SiteApps

Overview

Column Descriptions

id –
app_release –
dom_id –
dom_type –
install_prefix –
htdocs_directory –
capp_item_id –
params_id –
license_id –

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

Related documentation