psa.pd_users

Overview
The pd_users table contains the users for the protected directories on the server.

Column Descriptions
id – primary key that is automatically incremented
login – the username for the user
account_id – links to id in accounts table
pd_id – links to id in protected_dirs table

Table Structure

CREATE TABLE `pd_users` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `login` varchar(20) character set ascii collate ascii_bin NOT NULL default '',
 `account_id` int(10) unsigned NOT NULL default '0',
 `pd_id` int(10) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`),
 UNIQUE KEY `pd_id` (`pd_id`,`login`),
 KEY `account_id` (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1

Related documentation

September 24th, 2008 in All Tables, Domains | tags: , ,