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: databaseservers, data_bases, db_users, domains