Table: StoreFrontTemplate

To allow working with application templates, application template tables are provided. They contain the same fields as the application tables.

ColumnNameDataTypeKeyNot NullDefault ValueComment
ApplicationTemplateIDINTEGERPK, FKNN Unique application template ID (foreign key refers to table ApplicationTemplate)
StoresNVARCHAR(max)   Comma-separated list of URLs to Citrix stores
LogoffSessionsSMALLINT(6)  0Logoff StoreFront sessions when user logs off from client
0|1
DesktopsUseFullscreenSMALLINT(6)  1 
AutostartResourcesNVARCHAR(255)   Comma-separated list of resources to be started automatically
ReservedString1NVARCHAR(255)    
ReservedString2NVARCHAR(255)    
ReservedInt1INTEGER    
ReservedInt2INTEGER    
UsernameNVARCHAR(255)    
PassNVARCHAR(255)    
DomainNVARCHAR(255)    
LogoffDelayINT   Time to wait until the client logs off
UseLogoffDelaySMALLINT   Flag indicating whether LogoffDelay is used
ForcedLogoffSMALLINT   Flag indicating mode of logoff
(wait for all session apps to be closed or immediately)
ShowLastUserSMALLINT   Flag indicating whether last user credentials are shown on logon
UseCRFile BIT NOT NULL  0 Use a Citrix Provisioning file (.cr) instead
CRFile NVARCHAR(255)    Provisioning file
IndexNameIndexTypeColumns
PRIMARYPRIMARYApplicationTemplateID

 

How to create

CREATE TABLE StorefrontTemplate(
ApplicationTemplateID 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_StoreFrontTemplate_ApplicationTemplateID_ApplicationTemplate_ApplicationTemplateID FOREIGN KEY (ApplicationTemplateID) REFERENCES ApplicationTemplate (ApplicationTemplateID),
PRIMARY KEY (ApplicationTemplateID))
;