top of page
Shareware software

SQLITEDB_LIST table
The table stores information necessary to connect to SQLite databases.
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])
)
Description of the table fields
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 |
bottom of page