Scout Database Model (CR)
Table: StoreFront
Each entry describes an application of type APPLTYPE_STOREFRONT.
| ColumnName | DataType | Key | Not Null | Default Value | Comment |
|---|---|---|---|---|---|
| ApplicationID | INTEGER | PK, FK | NN | Unique application ID (foreign key refers to table Application) | |
| Stores | NVARCHAR(max) | Comma-separated list of URLs to Citrix stores | |||
| LogoffSessions | SMALLINT(6) | 0 | Logoff StoreFront sessions when user logs off from client 0/1 | ||
| DesktopsUseFullscreen | SMALLINT(6) | 1 | |||
| AutostartResources | NVARCHAR(255) | Comma-separated list of resources to be started automatically | |||
| ReservedString1 | NVARCHAR(255) | ||||
| ReservedString2 | NVARCHAR(255) | ||||
| ReservedInt1 | INTEGER | ||||
| ReservedInt2 | INTEGER | ||||
| Username | NVARCHAR(255) | ||||
| Pass | NVARCHAR(255) | ||||
| Domain | NVARCHAR(255) | ||||
| LogoffDelay | INT | Time to wait until the client logs off | |||
| UseLogoffDelay | SMALLINT | Flag indicating whether LogoffDelayis used | |||
| ForcedLogoff | SMALLINT | Flag indicating mode of logoff (wait for all session apps to be closed or immediately) | |||
| ShowLastUser | SMALLINT | Flag indicating if last user credentials are to be be shown at logon | |||
| UseCRFile | BIT NOT NULL | 0 | Use a Citrix Provisioning file (.cr) instead | ||
| CRFile | NVARCHAR(255) | Provisioning file |
| IndexName | IndexType | Columns |
|---|---|---|
| PRIMARY | PRIMARY | ApplicationID |
How to create
CREATE TABLE Storefront(
ApplicationID INTEGER NOT NULL,
Stores NVARCHAR(max),
LogoffSessions SMALLINT,
DesktopsUseFullscreen SMALLINT,
Username NVARCHAR(255),
Pass NVARCHAR(255),
Domain NVARCHAR(255),
LogoffDelay INTEGER,
UseLogoffDelay SMALLINT,
ForcedLogoff SMALLINT,
ShowLastUser SMALLINT,
UseCRFile BIT NOT NULL,
CRFile NVARCHAR(255),
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
CONSTRAINT FK_StoreFront_ApplicationID_Application_ApplicationID FOREIGN KEY (ApplicationID) REFERENCES Application (ApplicationID),
PRIMARY KEY (ApplicationID));
Table: StoreFront
In this article
Copied!
Failed!