top of page
logo-cerebrosql

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