Table

sql_servers

Description

SQL Server definitions

PluginCore Server Plugin

Column

Format

Description

Definition

Required

Comments

id

integer, primary key

Row identifier

autoincrement

(tick)


server_idinteger, foreign keyServer ID, of type SQLservers:id(tick)
typevarchar(32)SQL Server Type
  • LT: SQLite
  • MA: MariaDB
  • MS: MS SQL Server
  • MY: MySQL
  • PG: PostgreSQL
(tick)
hostnamevarchar(128)Server Hostname
(tick)
portintegerServer Port

Should only be specified when non-standard ports are in use
databasvarchar(128)Database Name
(tick)"database" is reserved by MySQL
usernamevarchar(128)Database Username


passwordvarchar(80)Database Password


  • No labels