Таблица MSSQL_LIST

В таблице хранится информация необходимая для подключения к базам MS SQL Server.

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])

)

Описание полей таблицы

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