module QueryConstants
Schema¶ ↑
References¶ ↑
stackoverflow.com/questions/464516/firefox-bookmarks-sqlite-structure developer.mozilla.org/en-US/docs/Places developer.mozilla.org/en-US/docs/Retrieving_part_of_the_bookmarks_tree developer.mozilla.org/en-US/docs/XPCOM_Interface_Reference/nsINavBookmarksService davidkoepi.wordpress.com/2010/11/27/firefoxforensics/
Queries¶ ↑
select moz_places.url, moz_bookmarks.title from moz_places,moz_bookmarks where moz_places.id = moz_bookmarks.fk and moz_bookmarks.title != '';
select keyword,url from moz_keywords left join moz_bookmarks on (moz_keywords.id = keyword_id) left join moz_places on (fk = moz_places.id);
select moz_places.url, datetime((moz_historyvisits.visit_date/1000000), ‘unixepoch’, ‘localtime’), moz_historyvisits.visit_type from moz_places, moz_historyvisits where moz_historyvisits.place_id = moz_places.id order by moz_historyvisits.visit_date desc;
Constants
- BOOKMARKS_QUERY
all bookmarks
- QUERY_BY_TAG
all bookmarks with the “given” tag.id
- QUERY_FOR_LINK
select the link between bookmars and tags fk_id = 1387
> 1934|1387|1144¶ ↑
- QUERY_FOR_SIMPLE_BOOKMARKS
bookmark.id|bookmark.fk|bookmark.title ...
> 1933|1387|SQLite Home Page¶ ↑
...
- QUERY_FOR_TAGS
tag.id|tag.title
- QUERY_FOR_TAG_BY_ID
tag.id|tag.title parent = 1144
> 1144|coding¶ ↑