Топ-100
 
logo-cerebrosql

Таблица 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