Table | cm_sql_servers |
|---|---|
Description | SQL Servers |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | |
server_id | integer, foreign key | Server ID | cm_servers:id | |
| type | varchar(2) | SQL Server Type |
| |
hostname | varchar(128) | Server Hostname | ||
| dbport | integer | Server Port | dbport added Registry v3.3.2; "port" is reserved by MySQL. | |
username | varchar(120) | Database Username | ||
password | varchar(80) | Database Password | This column should be encrypted | |
| databas | varchar(128) | Database Name | "database" is reserved by MySQL |