On 5/8/19 12:33 AM, bitwyse wrote: > There is a field "bookmarkProperties/description" in the > "moz_anno_attributes" table but I can't find the corresponding data.
I suspect that's the key right there. I don't have any descriptions stored in my places.sqlite, but this may surface something for you: $ sqlite3 places.sqlite SQLite version 3.24.0 2018-06-04 19:24:41 Enter ".help" for usage hints. sqlite> .schema moz_annos 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 UNIQUE INDEX moz_annos_placeattributeindex ON moz_annos (place_id, anno_attribute_id); sqlite> .schema moz_anno_attributes CREATE TABLE moz_anno_attributes (id INTEGER PRIMARY KEY,name VARCHAR(32) UNIQUE NOT NULL); The field names suggest a "foreign key" relationship of sorts between moz_annos:anno_attribute_id and moz_anno_attribute:id, so... sqlite> select * from moz_anno_attributes; 3|bookmarkProperties/description 4|URIProperties/characterSet 17|downloads/destinationFileURI 19|downloads/metaData 20|mobile/bookmarksRoot 22|Places/SmartBookmark sqlite> select content from moz_annos where anno_attribute_id=3; -- Best Regards, Adrian _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
