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