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

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