psa.SiteAppPackages

Overview

Column Descriptions

id –
name –
version –
release –
categories –
description –
access_level –
integrated –
package_type –
params_id –

CREATE TABLE `SiteAppPackages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `version` varchar(30) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `release` varchar(30) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `categories` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `access_level` int(10) unsigned NOT NULL DEFAULT '0',
  `integrated` enum('false','true') NOT NULL DEFAULT 'false',
  `package_type` int(10) unsigned NOT NULL DEFAULT '0',
  `params_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`,`version`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Related documentation