psa.data_bases

Overview
The data_bases table contains information about the databases stored on the server.

Column Descriptions
id - primary key that is automatically incremented
name - database’s name
type - can be mysql, mssql, postgresql
dom_id - links to id in domains table
db_server_id - links to id in DatabaseServers table
default_user_id - links to id in db_users

Table Structure

CREATE TABLE `data_bases` (
 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `name` VARCHAR(63) character SET ASCII COLLATE ascii_bin NOT NULL DEFAULT '',
 `type` ENUM('mysql','postgresql','mssql') NOT NULL DEFAULT 'mysql',
 `dom_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
 `db_server_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
 `default_user_id` INT(10) UNSIGNED DEFAULT NULL,
 PRIMARY KEY  (`id`),
 UNIQUE KEY `name` (`name`,`db_server_id`),
 KEY `dom_id` (`dom_id`),
 KEY `db_server_id` (`db_server_id`)
) ENGINE=INNODB AUTO_INCREMENT=103 DEFAULT CHARSET=latin1

Related documentation

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