MSSQL_LIST table

The table stores information necessary to connect to MS SQL Server databases.

CREATE TABLE MSSQL_LIST (
[id] INTEGER PRIMARY KEY AUTOINCREMENT,
[alias] TEXT,
[groupname] TEXT,
[servername] TEXT,

[serverport] TEXT,

[dbname] TEXT,
[auth] INTEGER default 0,
[username] TEXT,
[userpasswd] TEXT,
[color_page] TEXT,
UNIQUE ([alias])

)

Description of table fields

id	record number in the table
alias	synonym for connection. Displayed in connection selection forms. Unique value
groupname	the name of the system to which the MS SQL Server belongs. The value in the field is used to group data in lists
servername	DNS name of the server or its IP address
serverport	the port on which the MS SQL Server DBMS instance is running
auth	authentication method, 0 - domain, 1 - login/password
username	username in the MS SQL Server DBMS under which the connection is made
userpasswd	user password. It is stored in ASCII code due to the peculiarities of storing data in some encodings in SQLite databases
color_page	obsolete