Programs that respect your privacy

Android Settings Schema

Beginning with Privacy Browser Android 2.13, there is an option to export and import settings and bookmarks. These settings are stored in an SQLite database. Privacy Browser defaults to using a .pbs (Privacy Browser Settings) file extension, but the import/export algorithm doesn’t care what the extension is. This page documents the database schema.

Changelog
SchemaVersionChanges
12.13Initial release.
22.14Add download_with_external_app to the Preferences table.
32.15Rename the default_font_size field to font_size in the Preferences table.
42.16Add the pinned_ip_addresses fields to the Domains table.
52.17Remove hide_system_bars and translucent_navigation_bar from the Preferences table and add hide_app_bar and scroll_app_bar.
63.0Add open_intents_in_new_tab to the Preferences table.
73.1Add wide_viewport to the Preferences and Domains tables and google_analytics, facebook_click_ids, and twitter_amp_redirects to the Preferences table.
83.2Add ultralist to the Preferences and Domains tables.
93.3Remove proxy_through_orbot, tor_homepage, tor_search, and tor_search_custom_url from the Preferences table and add proxy and proxy_custom_url to the Preferences table.
103.4Remove download_with_external_app and add download_location and download_custom_location to the Preferences table.
113.5Replace nightmode with webview_theme in the domains table, replace dark_theme with app_theme in the preferences table, and replace night_mode with webview_theme in the preferences table.
123.6Add clear_logcat to the preferences table.
133.7Remove download_location and download_custom_location from the Preferences table.
143.8Remove enablethirdpartycookies from the Domains table and do_not_track and third_party_cookies from the Preferences table. Rename enablefirstpartycookies to cookies in the Domains table and first_party_cookies to cookies in the Preferences table. Add download_with_external_app to the Preferences table.
153.11Remove facebook_click_ids from the Preferences table. Rename google_analytics to tracking_queries and twitter_amp_redirects to amp_redirects in the Preferences table. Add x_requested_with_header to the Domains and Preferences tables.
163.12Remove x_requested_with_header from the Domains and Preferences tables.
173.15Remove parentfolder and add parent_folder_id and folder_id to the Bookmarks table. Convert the following Domains boolean switch values to integers: enablejavascript, cookies, enabledomstorage, enableformdata, enableeasylist, enableeasyprivacy, enablefanboysannoyancelist, enableffanboyssocialblockinglist, ultralist, enableultraprivacy, blockallthirdpartyrequests.
183.17Remove download_with_external_app from the Preferences table. Add display_under_cutouts and download_provider to the Preferences table.
193.18Remove enableformdata from the Domains table and save_form_data and clear_form_data from the Preferences table.
203.19Remove display_under_cutouts and add sort_bookmarks_alphabetically to the Preferences table.

The database contains three tables: Bookmarks, Domains, and Preferences.

Bookmarks
FieldTypeSchemaVersion
_idINTEGER PRIMARY KEY12.13
bookmarknameTEXT12.13
bookmarkurlTEXT12.13
parent_folder_idINTEGER173.15
displayorderINTEGER12.13
isfolderBOOLEAN12.13
folder_idINTEGER173.15
favoriteiconBLOB12.13
Domains
FieldTypeSchemaVersion
_idINTEGER PRIMARY KEY12.13
domainnameTEXT12.13
enablejavascriptINTEGER173.15
cookiesINTEGER173.15
enabledomstorageINTEGER173.15
enableeasylistINTEGER173.15
enableeasyprivacyINTEGER173.15
enablefanboysannoyancelistINTEGER173.15
enableffanboyssocialblockinglistINTEGER173.15
ultralistINTEGER173.15
enableultraprivacyINTEGER173.15
blockallthirdpartyrequestsINTEGER173.15
useragentTEXT12.13
fontsizeINTEGER12.13
swipetorefreshINTEGER12.13
webview_themeINTEGER113.5
wide_viewportINTEGER73.1
displayimagesINTEGER12.13
pinnedsslcertificateBOOLEAN12.13
sslissuedtocommonnameTEXT12.13
institutionalizationTEXT12.13
sslissuedtoorganizationalunitTEXT12.13
sslissuedbycommonnameTEXT12.13
sslissuedbyorganizationTEXT12.13
sslissuedbyorganizationalunitTEXT12.13
sslstartdateINTEGER12.13
sslenddateINTEGER12.13
pinned_ip_addressesBOOLEAN42.16
ip_addressesTEXT42.16
Preferences
FieldTypeSchemaVersion
_idINTEGER PRIMARY KEY12.13
javascriptBOOLEAN12.13
cookiesBOOLEAN143.8
dom_storageBOOLEAN12.13
user_agentTEXT12.13
custom_user_agentTEXT12.13
incognito_modeBOOLEAN12.13
allow_screenshotsBOOLEAN12.13
easylistBOOLEAN12.13
easyprivacyBOOLEAN12.13
fanboys_annoyance_listBOOLEAN12.13
fanboys_social_blocking_listBOOLEAN12.13
ultralistBOOLEAN83.2
ultraprivacyBOOLEAN12.13
block_all_third_party_requestsBOOLEAN12.13
tracking_queriesBOOLEAN153.11
twitter_amp_redirectsBOOLEAN153.11
searchTEXT12.13
search_custom_urlTEXT12.13
proxyTEXT93.3
proxy_custom_urlTEXT93.3
full_screen_browsing_modeBOOLEAN12.13
hide_app_barBOOLEAN52.17
clear_everythingBOOLEAN12.13
clear_cookiesBOOLEAN12.13
clear_dom_storageBOOLEAN12.13
clear_logcatBOOLEAN123.6
clear_cacheBOOLEAN12.13
homepageTEXT12.13
font_sizeTEXT32.15
open_intents_in_new_tabBOOLEAN63.0
swipe_to_refreshBOOLEAN12.13
download_providerTEXT183.17
scroll_app_barBOOLEAN52.17
display_additional_app_bar_iconsBOOLEAN12.13
sort_bookmarks_alphabeticallyBOOLEAN203.19
app_themeTEXT113.5
webview_themeTEXT113.5
wide_viewportBOOLEAN73.1
display_webpage_imagesBOOLEAN12.13

Last updated

Leave a Reply