Топ-100
 
logo-cerebrosql

Таблица SQLITEDB_LIST

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

CREATE TABLE SQLITEDB_LIST (
     [id]         INTEGER PRIMARY KEY AUTOINCREMENT,
     [attach]     TEXT,
     [file]       TEXT,
     [mode]       TEXT,
     [passwd]     TEXT,
     [bkp_file]   TEXT,
     [bkp_mode]   TEXT,
     [bkp_passwd] TEXT,
     [comment]    TEXT,
     UNIQUE ([attach])

)

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

id
record number in the table
alias
alias under which the database is connected in the editor. Unique value.
file
full path to the SQLite database file.
mode
database encryption protocol
passwd
database password. It is stored in ASCII code due to the peculiarities of storing data in some encodings in SQLite databases
bkp_file
full path to the database backup file. Backup is done from the Query Editor interface
bkp_mode
backup database encryption protocol
bkp_passwd
database password. It is stored in ASCII code due to the peculiarities of storing data in some encodings in SQLite databases
comment
comment