psa.clients
Overview
The clients table is the root table where the most basic details about a client are stored.
Column Descriptions
id - primary key that is linked to many other tables as client_id
cr_date - date the client was created (YYYY-MM-DD)
cname - client’s company name
pname - client’s actual name
login - login username for Plesk access
account_id - links to id in accounts table
status - 0 if enabled or 16 if disabled
phone - client’s phone number
fax - client’s fax number
email - client’s e-mail address
address - client’s physical address
city - client’s city
state - client’s state
pcode - client’s postal code
country - client’s country
locale - localization for the client (defaults to en-US)
limits_id - links to id in Limits table
params_id - links to id in Parameters table
perm_id - links to id in Permissions table
pool_id - links to rep_id in Repository table (and then Repository.component_id links to id in IP_Addresses table)
logo_id - links to id in Logos table
tmpl_id - links to id in Templates table
sapp_pool_id - currently unknown, but most likely relates to site applications in the Application Vault
guid - unique identifier assigned by Plesk for the client
Table Structure
CREATE TABLE `clients` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `cr_date` DATE DEFAULT NULL, `cname` VARCHAR(255) character SET utf8 DEFAULT NULL, `pname` VARCHAR(255) character SET utf8 NOT NULL DEFAULT '', `login` VARCHAR(20) character SET utf8 NOT NULL DEFAULT '', `account_id` INT(10) UNSIGNED NOT NULL DEFAULT '0', `status` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `phone` VARCHAR(255) character SET ASCII COLLATE ascii_bin DEFAULT NULL, `fax` VARCHAR(255) character SET ASCII COLLATE ascii_bin DEFAULT NULL, `email` VARCHAR(255) character SET utf8 DEFAULT NULL, `address` VARCHAR(255) character SET utf8 DEFAULT NULL, `city` VARCHAR(255) character SET utf8 DEFAULT NULL, `state` VARCHAR(255) character SET utf8 DEFAULT NULL, `pcode` VARCHAR(10) character SET ASCII COLLATE ascii_bin DEFAULT NULL, `country` CHAR(2) character SET ASCII COLLATE ascii_bin DEFAULT NULL, `locale` VARCHAR(17) character SET ASCII COLLATE ascii_bin NOT NULL DEFAULT 'en-US', `limits_id` INT(10) UNSIGNED DEFAULT NULL, `params_id` INT(10) UNSIGNED DEFAULT NULL, `perm_id` INT(10) UNSIGNED DEFAULT NULL, `pool_id` INT(10) UNSIGNED DEFAULT NULL, `logo_id` INT(10) UNSIGNED DEFAULT NULL, `tmpl_id` INT(10) UNSIGNED DEFAULT NULL, `sapp_pool_id` INT(10) UNSIGNED DEFAULT NULL, `guid` VARCHAR(36) character SET ASCII COLLATE ascii_bin NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', PRIMARY KEY (`id`), UNIQUE KEY `login` (`login`), KEY `account_id` (`account_id`), KEY `limits_id` (`limits_id`), KEY `params_id` (`params_id`), KEY `perm_id` (`perm_id`), KEY `pool_id` (`pool_id`), KEY `logo_id` (`logo_id`), KEY `tmpl_id` (`tmpl_id`), KEY `sapp_pool_id` (`sapp_pool_id`), KEY `pname` (`pname`) ) ENGINE=INNODB AUTO_INCREMENT=57 DEFAULT CHARSET=latin1