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

CREATE TABLE `DatabaseServers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `host` varchar(63) CHARACTER SET utf8 NOT NULL,
  `port` int(10) unsigned DEFAULT NULL,
  `type` enum('mysql','postgresql') NOT NULL,
  `admin_login` varbinary(255) NOT NULL,
  `admin_password` varbinary(255) NOT NULL,
  `last_error` enum('no_error','connection_failed','permission_denied','other_error','credentials_not_set') NOT NULL DEFAULT 'no_error',
  `server_version` varbinary(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `host_port` (`host`,`port`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

CREATE TABLE `DatabaseServers` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `host` varchar(63) CHARACTER SET utf8 NOT NULL, `port` int(10) unsigned DEFAULT NULL, `type` enum('mysql','postgresql') NOT NULL, `admin_login` varbinary(255) NOT NULL, `admin_password` varbinary(255) NOT NULL, `last_error` enum('no_error','connection_failed','permission_denied','other_error','credentials_not_set') NOT NULL DEFAULT 'no_error', `server_version` varbinary(255) NOT NULL, PRIMARY KEY (`id`), KEY `host_port` (`host`,`port`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1