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 |