Documentation for SQLite files

[Andre Majorel]

Where is the structure of the SQLite files that Firefox uses
documented ? Specifically, I'm looking for the values of the
"permission" column in the moz_hosts table in the
permissions.sqlite file for Firefox 3.5.19.

Thanks in advance.

--
André Majorel http://www.teaser.fr/~amajorel/

[Mihamina Rakotomandimby]

On 04/22/2012 07:40 PM, Andre Majorel wrote:
> I'm looking for the values of the
> "permission" column in the moz_hosts table in the
> permissions.sqlite file for Firefox 3.5.19.

The SQLite file format (this is not what you look for):
http://sqlite.org/fileformat2.html
But see the "Querying the database schema" chapter in
http://www.sqlite.org/sqlite.html
You would have found it but searching 5 minutes.

--
RMA.

[Jeremy Nicoll - ml mozilla support-firefox]

I think he wants to know what values FF writes to particular fields in the
db. I should think that needs a FF developer to answer; it's not an SQLite
question.

--
Jeremy Nicoll - my opinions are my own.

[Andre Majorel]

On 2012-04-22 18:08 +0100, Jeremy Nicoll - ml mozilla support-firefox wrote:

> I think he wants to know what values FF writes to particular
> fields in the db. I should think that needs a FF developer to
> answer; it's not an SQLite question.

Spot on.

[Fox on the run]

Here's what I have on it:

If type is popup, a value of 1 under permission means to allow popups for whatever host is listed for that entry.

If type is cookie, permission will have 1=allow, 2=block, 8=for session only, again for the host listed for that entry.

If type is install, 1=allow the install up updates.

If type is image, 1=allow images, 2=block

JB

[Fox on the run]

On Sunday, April 22, 2012 2:10:48 PM UTC-2:30, Andre Majorel wrote: