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


typevarchar(2)SQL Server Type
  • MY: MySQL
  • PG: PostgreSQL
  • MS: MS SQL Server

hostname

varchar(128)

Server Hostname



portintegerServer Port
Added Registry v3.3.2

username

varchar(120)

Database Username



password

varchar(80)

Database Password


This column should be encrypted

databasvarchar(128)Database Name
"database" is reserved by MySQL
  • No labels