Keith Medcalf a écrit : > > The only "description" field is an attribute (column) with the moz_places > table. There is no "description" in the moz_bookmarks table.
There is NO description column in the moz_places table in my "places.sqlite" 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 ); The last 3 columns you saw are only created by new versions. You overlooked the fact that I clearly stated that the data remains in files created by earlier releases; in which the descriptions are attached to the bookmarks and not to the history. (I use the latest release of SeaMonkey (2.49.4): "places.sqlite" is totally compatible with FireFox.) In any case your reply is not relevant to the problem I described. -- 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
