Table: Local

Each entry describes an application of type APPLTYPE_LOCALSHELL.

ColumnName	DataType	Key	Not Null	Default Value	Comment
ApplicationID	INTEGER	PK, FK	NN		Unique application ID (foreign key refers to table Application)
Type	NVARCHAR(255)				Local application type CUSTOM User-defined command RESINFO Resource info SHELL Local shell (XTERM) SSH Secure shell QFM File manager QTT Text editor MPLAYER Movie player THUNDERBIRD Thunderbird mail client ICACC ICA Connection Center CLIENTINFO Client information MAGNIFIER Magnifier
Parameter	NVARCHAR(255)				Command line parameter string For custom applications, this is the complete command string including all parameters
Hidden	SMALLINT(6)				Application is hidden to the user 0|1
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER

IndexName	IndexType	Columns
PRIMARY	PRIMARY	ApplicationID

 

How to create

CREATE TABLE Local(
ApplicationID INTEGER NOT NULL,
Type NVARCHAR(255),
Parameter NVARCHAR(255),
Hidden SMALLINT,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
CONSTRAINT FK_LocalApplicationID_Application_ApplicationID FOREIGN KEY (ApplicationID) REFERENCES Application (ApplicationID),
PRIMARY KEY (ApplicationID));