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: , , ,