Table: Browser

Each entry describes an application of type APPLTYPE_BROWSER.

ColumnName	DataType	Key	Not Null	DefaultValue	Comment
ApplicationID	INTEGER	PK, FK	NN		Unique application ID Foreign key refers to table Application
StartPage	NVARCHAR(255)				Home page
CallPage	NVARCHAR(255)				Called at browser start
Proxy	NVARCHAR(255)				Proxy server (IP address or name)
ProxyType	INTEGER				Use proxy server 0|1
BrowserType	INTEGER				3 Firefox 4 Chromium
KioskMode	SMALLINT(6)				Kiosk mode 0|1
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER
ProxyExceptions	NVARCHAR(max)				Holds the entries of the browser proxy exception list

IndexName	IndexType	Columns
PRIMARY	PRIMARY	ApplicationID

 

How to create

CREATE TABLE Browser(
ApplicationID INTEGER NOT NULL,
StartPage NVARCHAR(255),
CallPage NVARCHAR(255),
Proxy NVARCHAR(255),
ProxyType INTEGER,
BrowserType INTEGER,
KioskMode SMALLINT,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
ProxyExceptions NVARCHAR(max),
CONSTRAINT FK_Browser_ApplicationID_Application_ApplicationID FOREIGN KEY (ApplicationID) REFERENCES Application (ApplicationID),
PRIMARY KEY (ApplicationID));