File indexing completed on 2024-06-16 04:39:09

0001 -- Falkon browsedata.db
0002 
0003 -- Tables
0004 CREATE TABLE autofill (
0005     id INTEGER PRIMARY KEY,
0006     server TEXT NOT NULL,
0007     data TEXT,
0008     password TEXT,
0009     username TEXT,
0010     last_used INTEGER DEFAULT 0 NOT NULL
0011 );
0012 CREATE INDEX autofill_serverindex ON autofill (server);
0013 
0014 CREATE TABLE autofill_encrypted (
0015     id INTEGER PRIMARY KEY,
0016     server TEXT NOT NULL,
0017     data_encrypted TEXT,
0018     password_encrypted TEXT,
0019     username_encrypted TEXT,
0020     last_used INTEGER DEFAULT 0 NOT NULL
0021 );
0022 CREATE INDEX autofill_encrypted_serverindex ON autofill_encrypted (server);
0023 
0024 CREATE TABLE autofill_exceptions (
0025     id INTEGER PRIMARY KEY,
0026     server TEXT NOT NULL
0027 );
0028 CREATE INDEX autofill_exception_serverindex ON autofill_exceptions (server);
0029 
0030 CREATE TABLE history (
0031     id INTEGER PRIMARY KEY,
0032     url TEXT NOT NULL,
0033     title TEXT,
0034     date INTEGER DEFAULT 0 NOT NULL,
0035     count INTEGER DEFAULT 0 NOT NULL
0036 );
0037 CREATE INDEX history_titleindex ON history (title);
0038 CREATE UNIQUE INDEX history_urluniqueindex ON history (url);
0039 
0040 CREATE TABLE search_engines (
0041     id INTEGER PRIMARY KEY,
0042     name TEXT NOT NULL,
0043     url TEXT,
0044     icon BLOB,
0045     shortcut TEXT,
0046     suggestionsUrl TEXT,
0047     suggestionsParameters TEXT,
0048     postData TEXT
0049 );
0050 
0051 CREATE TABLE icons (
0052     id INTEGER PRIMARY KEY,
0053     url TEXT NOT NULL,
0054     icon BLOB
0055 );
0056 CREATE UNIQUE INDEX icons_urluniqueindex ON icons (url);
0057 
0058 -- Data