Using an ordinary client to access the database ... like the one you can download from www.sqlite.org
The only "description" field is an attribute (column) with the moz_places table. There is no "description" in the moz_bookmarks table. This is Firefox 68.0.1. Perhaps two years ago there was an attribute (column) in the moz_bookmarks table called description but there is no more. >sqlite places.sqlite SQLite version 3.30.0 2019-08-04 01:51:00 Enter ".help" for usage hints. sqlite> .schema --indent CREATE TABLE moz_places( id INTEGER PRIMARY KEY, url LONGVARCHAR, title LONGVARCHAR, rev_host LONGVARCHAR, visit_count INTEGER DEFAULT 0, hidden INTEGER DEFAULT 0 NOT NULL, typed INTEGER DEFAULT 0 NOT NULL, favicon_id INTEGER, frecency INTEGER DEFAULT -1 NOT NULL, last_visit_date INTEGER , guid TEXT, foreign_count INTEGER DEFAULT 0 NOT NULL, url_hash INTEGER DEFAULT 0 NOT NULL , description TEXT, preview_image_url TEXT, origin_id INTEGER REFERENCES moz_origins(id) ); CREATE TABLE moz_historyvisits( id INTEGER PRIMARY KEY, from_visit INTEGER, place_id INTEGER, visit_date INTEGER, visit_type INTEGER, session INTEGER ); CREATE TABLE moz_inputhistory( place_id INTEGER NOT NULL, input LONGVARCHAR NOT NULL, use_count INTEGER, PRIMARY KEY(place_id, input) ); CREATE TABLE moz_hosts( id INTEGER PRIMARY KEY, host TEXT NOT NULL UNIQUE, frecency INTEGER, typed INTEGER NOT NULL DEFAULT 0, prefix TEXT ); CREATE TABLE moz_bookmarks( id INTEGER PRIMARY KEY, type INTEGER, fk INTEGER DEFAULT NULL, parent INTEGER, position INTEGER, title LONGVARCHAR, keyword_id INTEGER, folder_type TEXT, dateAdded INTEGER, lastModified INTEGER, guid TEXT, syncStatus INTEGER DEFAULT 0 NOT NULL, syncChangeCounter INTEGER DEFAULT 1 NOT NULL ); CREATE TABLE moz_keywords( id INTEGER PRIMARY KEY AUTOINCREMENT, keyword TEXT UNIQUE, place_id INTEGER, post_data TEXT ); CREATE TABLE sqlite_sequence(name,seq); CREATE TABLE moz_anno_attributes( id INTEGER PRIMARY KEY, name VARCHAR(32) UNIQUE NOT NULL ); CREATE TABLE moz_annos( id INTEGER PRIMARY KEY, place_id INTEGER NOT NULL, anno_attribute_id INTEGER, mime_type VARCHAR(32) DEFAULT NULL, content LONGVARCHAR, flags INTEGER DEFAULT 0, expiration INTEGER DEFAULT 0, type INTEGER DEFAULT 0, dateAdded INTEGER DEFAULT 0, lastModified INTEGER DEFAULT 0 ); CREATE TABLE moz_items_annos( id INTEGER PRIMARY KEY, item_id INTEGER NOT NULL, anno_attribute_id INTEGER, mime_type VARCHAR(32) DEFAULT NULL, content LONGVARCHAR, flags INTEGER DEFAULT 0, expiration INTEGER DEFAULT 0, type INTEGER DEFAULT 0, dateAdded INTEGER DEFAULT 0, lastModified INTEGER DEFAULT 0 ); CREATE TABLE sqlite_stat1(tbl,idx,stat); CREATE TABLE moz_bookmarks_deleted( guid TEXT PRIMARY KEY, dateRemoved INTEGER NOT NULL DEFAULT 0 ); CREATE TABLE moz_meta(key TEXT PRIMARY KEY, value NOT NULL) WITHOUT ROWID; CREATE TABLE moz_origins( id INTEGER PRIMARY KEY, prefix TEXT NOT NULL, host TEXT NOT NULL, frecency INTEGER NOT NULL, UNIQUE(prefix, host) ); CREATE INDEX moz_places_url_hashindex ON moz_places(url_hash); CREATE INDEX moz_places_hostindex ON moz_places(rev_host); CREATE INDEX moz_places_visitcount ON moz_places(visit_count); CREATE INDEX moz_places_frecencyindex ON moz_places(frecency); CREATE INDEX moz_places_lastvisitdateindex ON moz_places(last_visit_date); CREATE UNIQUE INDEX moz_places_guid_uniqueindex ON moz_places(guid); CREATE INDEX moz_historyvisits_placedateindex ON moz_historyvisits( place_id, visit_date ); CREATE INDEX moz_historyvisits_fromindex ON moz_historyvisits(from_visit); CREATE INDEX moz_historyvisits_dateindex ON moz_historyvisits(visit_date); CREATE INDEX moz_bookmarks_itemindex ON moz_bookmarks(fk, type); CREATE INDEX moz_bookmarks_parentindex ON moz_bookmarks(parent, position); CREATE INDEX moz_bookmarks_itemlastmodifiedindex ON moz_bookmarks( fk, lastModified ); CREATE UNIQUE INDEX moz_bookmarks_guid_uniqueindex ON moz_bookmarks(guid); CREATE UNIQUE INDEX moz_keywords_placepostdata_uniqueindex ON moz_keywords( place_id, post_data ); CREATE UNIQUE INDEX moz_annos_placeattributeindex ON moz_annos( place_id, anno_attribute_id ); CREATE UNIQUE INDEX moz_items_annos_itemattributeindex ON moz_items_annos( item_id, anno_attribute_id ); CREATE INDEX moz_bookmarks_dateaddedindex ON moz_bookmarks(dateAdded); CREATE INDEX moz_places_originidindex ON moz_places(origin_id); sqlite> -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of bitwyse >Sent: Sunday, 4 August, 2019 12:55 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] Hidden data > >Keith Medcalf a écrit : >> >> You mistakenly assumed that the page description is an attribute of >the bookmark rather than of the page ... The list of all pages ever >visited is stored in the moz_places table and one of the attributes >(columns) in that table is the description of the page ... > >The bookmarks are stored in places.sqlite together with their >associated >descriptions, independently of the navigation history. >https://bugzilla.mozilla.org/show_bug.cgi?id=1402890 > >No description column is visible in moz_places in a normal >(non-forensic) viewer. > >-- >bitwyse [PGP KeyID 0x18EB38C4] >Les conseils - c'est ce qu'on demande >quand on connaît déjà la réponse >mais aurait préféré ne pas la savoir. > >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
