psa.sys_users

Overview
The sys_users table contains the FTP users that are associated with each domain.

Column Descriptions
id – primary key that is automatically incremented
login – username for the FTP login
account_id – links to id in accounts
home – home directory for the FTP user
shell – which shell the FTP user should have for SSH access
quota – filesystem quota for the user, or 0 if unlimited

Table Structure

CREATE TABLE `sys_users` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `login` varchar(20) character set ascii NOT NULL default '',
 `account_id` int(10) unsigned NOT NULL default '0',
 `home` varchar(255) character set ascii collate ascii_bin NOT NULL default '',
 `shell` varchar(255) character set ascii collate ascii_bin NOT NULL default '',
 `quota` bigint(20) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`),
 UNIQUE KEY `login` (`login`),
 KEY `account_id` (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=latin1

Related documentation