Table: FirefoxDefaults

This table stores the Firefox software defaults.

ColumnName	DataType	Key	Not Null	Default Value	Comment
FirefoxDefaultsID	INTEGER IDENTITY (1,1)	PK	NN		Unique ID
HomeDirectory	NVARCHAR(255)				holds the home directory
ItemID	INTEGER		NN		OU ID
ItemType	INTEGER		NN		always 1 (TYPE_OU) at this time

IndexName	IndexType	Columns
PRIMARY	PRIMARY	FirefoxDefaultsID

 

How to create

CREATE TABLE FirefoxDefaults(
FirefoxDefaultsID INTEGER IDENTITY (1,1) NOT NULL,
HomeDirectory NVARCHAR(255),
ItemID INTEGER NOT NULL,
ItemType INTEGER NOT NULL,
CONSTRAINT PK_FirefoxDefaults,
PRIMARY KEY (FirefoxDefaultsID));

How to initialize

INSERT INTO FirefoxDefaults(HomeDirectory, ItemType, ItemID) SELECT Home,1,-1 FROM Setup WHERE SetupID=0;