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 |