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

Related documentation

September 23rd, 2008 in All Tables, Databases | tags: , ,