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

Leave a comment

Your comment