Table: Application
Each entry defines an application with its main attributes. All application specific data were derived to underlying tables.
ColumnName | DataType | Key | Not Null | Default | Comment | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ApplicationID | INTEGER | PK | NN | Unique application ID | |||||||||||||||||||||||||
AppTypeID | INTEGER | NN |
Application type
|
||||||||||||||||||||||||||
Name | NVARCHAR(255) | NN | Application name The name must be unique for each combination of AppLevel and GroupID |
||||||||||||||||||||||||||
AutoStart | SMALLINT(6) | NN | Start
automatically 0|1 |
||||||||||||||||||||||||||
TM | SMALLINT(6) | NN | Application
restart (terminal mode) 0|1 |
||||||||||||||||||||||||||
AppOnDesktop | SMALLINT(6) | Desktop
icon 0|1 |
|||||||||||||||||||||||||||
Roaming | SMALLINT(6) | NN | Roaming
(supported by AppTypeID=4 and AppTypeID=10) 0|1 |
||||||||||||||||||||||||||
AppLevel | SMALLINT(6) | NN |
Hierarchical level of application
|
||||||||||||||||||||||||||
GroupID | INTEGER | (FK) | NN | ID
of the OU/group which is owner of this application (see table Groups). For applications on base level this value must be set to -1. |
|||||||||||||||||||||||||
IconName | NVARCHAR(255) | Name
of the icon which to be displayed on the client). |
|||||||||||||||||||||||||||
PassThrough | SMALLINT(6) | NN | 0 | Defines whether an application can use pass-through login (supported by AppTypeID=4 and AppTypeID=13) 0|1 |
|||||||||||||||||||||||||
Xinerama | INTEGER | NN | 0 | Specifies the xinerama mode to be activated -1|0|1|2|3|4 |
|||||||||||||||||||||||||
SortID | INTEGER | NN | |||||||||||||||||||||||||||
LooseParameters | NVARCHAR(max) | Holds the free parameters of an application. Multiple parameters are separated by an '\r' character. Example: UseICAPreLogin=1 |
|||||||||||||||||||||||||||
DisplayName | NVARCHAR(255) | Display name on client | |||||||||||||||||||||||||||
ReservedString1 | NVARCHAR(255) | ||||||||||||||||||||||||||||
ReservedString2 | NVARCHAR(255) | ||||||||||||||||||||||||||||
ReservedInt1 | INTEGER | Start delay in seconds (used only if AutoStart is activated) | |||||||||||||||||||||||||||
ReservedInt2 | INTEGER |
IndexName | IndexType | Columns |
---|---|---|
PRIMARY | PRIMARY | ApplicationID |
How to create
CREATE TABLE Application(
ApplicationID INTEGER NOT NULL;
AppTypeID INTEGER NOT NULL;
Name NVARCHAR(255) NOT NULL;
AutoStart SMALLINT NOT NULL;
TM SMALLINT NOT NULL;
AppOnDesktop SMALLINT;
Roaming SMALLINT NOT NULL;
AppLevel SMALLINT NOT NULL;
GroupID INTEGER NOT NULL;
IconName NVARCHAR(255);
PassThrough SMALLINT;
Xinerama INTEGER;
SortID INTEGER NOT NULL CONSTRAINT DF_Application_SortID DEFAULT 1;
LooseParameters NVARCHAR(max);
DisplayName NVARCHAR(255);
ReservedString1 NVARCHAR(255);
ReservedString2 NVARCHAR(255);
ReservedInt1 INTEGER;
ReservedInt2 INTEGER;
PRIMARY KEY (ApplicationID));