psa.db_users
Overview
The db_users
table contains the database users for the databases on the server.
Column Descriptions
id – primary key that is automatically incremented
login – username for the database user
account_id – links to id
in accounts
table
db_id – links to id
in data_bases
table
Table Structure
CREATE TABLE `db_users` ( `id` int(10) unsigned NOT NULL auto_increment, `login` varchar(16) character set ascii collate ascii_bin NOT NULL default '', `account_id` int(10) unsigned NOT NULL default '0', `db_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `db_id` (`db_id`,`login`), KEY `account_id` (`account_id`) ) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=latin1 |