Slitaz -- firefox - sqlite

1.
tux@slitaz:~$ ls /home/tux/.mozilla/firefox/1w1lo56l.default/*.sqlite
/home/tux/.mozilla/firefox/1w1lo56l.default/addons.sqlite
/home/tux/.mozilla/firefox/1w1lo56l.default/chromeappsstore.sqlite
/home/tux/.mozilla/firefox/1w1lo56l.default/content-prefs.sqlite
/home/tux/.mozilla/firefox/1w1lo56l.default/cookies.sqlite
/home/tux/.mozilla/firefox/1w1lo56l.default/downloads.sqlite
/home/tux/.mozilla/firefox/1w1lo56l.default/extensions.sqlite
/home/tux/.mozilla/firefox/1w1lo56l.default/formhistory.sqlite
/home/tux/.mozilla/firefox/1w1lo56l.default/permissions.sqlite
/home/tux/.mozilla/firefox/1w1lo56l.default/places.sqlite
/home/tux/.mozilla/firefox/1w1lo56l.default/search.sqlite
/home/tux/.mozilla/firefox/1w1lo56l.default/signons.sqlite
/home/tux/.mozilla/firefox/1w1lo56l.default/urlclassifier3.sqlite
/home/tux/.mozilla/firefox/1w1lo56l.default/webappsstore.sqlite

2.
tux@slitaz:~$ sqlite3 /home/tux/.mozilla/firefox/1w1lo56l.default/extensions.sqlite
SQLite version 3.7.5
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .databases
seq  name             file                                                     
---  ---------------  ----------------------------------------------------------
0    main             /home/tux/.mozilla/firefox/1w1lo56l.default/extensions.sql

2.
sqlite> .tables
addon              locale             targetApplication
addon_locale       locale_strings     targetPlatform  

3.
sqlite> .schema addon
CREATE TABLE addon (internal_id INTEGER PRIMARY KEY AUTOINCREMENT, id TEXT, location TEXT, version TEXT, type TEXT, internalName TEXT, updateURL TEXT, updateKey TEXT, optionsURL TEXT, aboutURL TEXT, iconURL TEXT, icon64URL TEXT, defaultLocale INTEGER, visible INTEGER, active INTEGER, userDisabled INTEGER, appDisabled INTEGER, pendingUninstall INTEGER, descriptor TEXT, installDate INTEGER, updateDate INTEGER, applyBackgroundUpdates INTEGER, bootstrap INTEGER, skinnable INTEGER, size INTEGER, sourceURI TEXT, releaseNotesURI TEXT, UNIQUE (id, location));
CREATE TRIGGER delete_addon AFTER DELETE ON addon BEGIN DELETE FROM targetApplication WHERE addon_internal_id=old.internal_id; DELETE FROM targetPlatform WHERE addon_internal_id=old.internal_id; DELETE FROM addon_locale WHERE addon_internal_id=old.internal_id; DELETE FROM locale WHERE id=old.defaultLocale; END;

4.
sqlite> .header on
sqlite> select id,version,type from addon;
id|version|type
{972ce4c6-7e08-4474-a285-3208198ce6fd}|4.0.1|theme
{22870005-adef-4c9d-ae36-d0e1f2f27e5a}|0.4.0.9.1|extension
{aff87fa2-a58e-4edd-b852-0a20203c1e17}|0.9|extension
{53A03D43-5363-4669-8190-99061B2DEBA5}|1.4.9|extension
moonlight@novell.com|3.99.0.3|extension
sqlite> .quit
tux@slitaz:~$
.