1
2
3
4
5
6
7
8
9
10
11
12

CREATE TABLE `data_bases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(63) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `type` enum('mysql','postgresql','mssql') NOT NULL DEFAULT 'mysql',
  `dom_id` int(10) unsigned NOT NULL,
  `db_server_id` int(10) unsigned NOT NULL,
  `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=7 DEFAULT CHARSET=latin1

CREATE TABLE `data_bases` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(63) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `type` enum('mysql','postgresql','mssql') NOT NULL DEFAULT 'mysql', `dom_id` int(10) unsigned NOT NULL, `db_server_id` int(10) unsigned NOT NULL, `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=7 DEFAULT CHARSET=latin1