Browser databas

在android com.android.browser目录下的数据库有
1.browser.db
2.WebpageIcons.db
3.webview.db
4.webviewCache.db
5.CachedGeoposition.db
6.GeolocationPermissions.db

1.browser.db含有3张表

android_metadata
CREATE TABLE android_metadata (locale TEXT); 

bookmarks
CREATE TABLE bookmarks (_id INTEGER PRIMARY KEY,title TEXT,url TEXT,visits INTEGER,date LONG,created LONG,description TEXT,bookmark INTEGER,favicon BLOB DEFAULT NULL,thumbnail BLOB DEFAULT NULL,touch_icon BLOB DEFAULT NULL,user_entered INTEGER); 

searches
CREATE TABLE searches (_id INTEGER PRIMARY KEY,search TEXT,date LONG);

2.WebpageIcons.db含有4张表

PageURL
CREATE TABLE PageURL (url TEXT NOT NULL ON CONFLICT FAIL UNIQUE ON CONFLICT REPLACE,iconID INTEGER NOT NULL ON CONFLICT FAIL);
CREATE INDEX PageURLIndex ON PageURL (url);

IconInfo
CREATE TABLE IconInfo (iconID INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE ON CONFLICT REPLACE, url TEXT NOT NULL ON CONFLICT FAIL UNIQUE ON CONFLICT FAIL, stamp INTEGER);
CREATE INDEX IconInfoIndex ON IconInfo (url, iconID);

IconData
CREATE TABLE IconData (iconID INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE ON CONFLICT REPLACE, data BLOB);
CREATE INDEX IconDataIndex ON IconData (iconID);

IconDatabaseInfo
CREATE TABLE IconDatabaseInfo (key TEXT NOT NULL ON CONFLICT FAIL UNIQUE ON CONFLICT REPLACE,value TEXT NOT NULL ON CONFLICT FAIL);

 

3.webview.db含有6张表

android_metadata
CREATE TABLE android_metadata (locale TEXT);

cookies
CREATE TABLE cookies (_id INTEGER PRIMARY KEY, name TEXT, value TEXT, domain TEXT, path TEXT, expires INTEGER, secure INTEGER);
CREATE INDEX cookiesIndex ON cookies (path);

formurl
CREATE TABLE formurl (_id INTEGER PRIMARY KEY, url TEXT);

formdata
CREATE TABLE formdata (_id INTEGER PRIMARY KEY, urlid INTEGER, name TEXT, value TEXT, UNIQUE (urlid, name, value) ON CONFLICT IGNORE);

httpauth
CREATE TABLE httpauth (_id INTEGER PRIMARY KEY, host TEXT, realm TEXT, username TEXT, password TEXT, UNIQUE (host, realm) ON CONFLICT REPLACE);

password
CREATE TABLE password (_id INTEGER PRIMARY KEY, host TEXT, username TEXT, password TEXT, UNIQUE (host, username) ON CONFLICT REPLACE);

4.webviewCache.db含有2张表

android_metadata
CREATE TABLE android_metadata (locale TEXT); 

cache
CREATE TABLE cache (_id INTEGER PRIMARY KEY, url TEXT, filepath TEXT, lastmodify TEXT, etag TEXT, expires INTEGER, expiresstring TEXT, mimetype TEXT, encoding TEXT,httpstatus INTEGER, location TEXT, contentlength INTEGER, contentdisposition TEXT, crossdomain TEXT, UNIQUE (url) ON CONFLICT REPLACE);
CREATE INDEX cacheUrlIndex ON cache (url);

5.CachedGeoposition.db含有1张表

CachedPosition
CREATE TABLE CachedPosition (latitude REAL NOT NULL, longitude REAL NOT NULL, altitude REAL, accuracy REAL NOT NULL, altitudeAccuracy REAL, heading REAL, speed REAL, timestamp INTEGER NOT NULL);

6.GeolocationPermissions.db含有1张表

Permissions
CREATE TABLE Permissions (origin TEXT UNIQUE NOT NULL, allow INTEGER NOT NULL);