Table: StoreFrontTemplate

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

ColumnName	DataType	Key	Not Null	Default Value	Comment
ApplicationTemplateID	INTEGER	PK, FK	NN		Unique application template ID (foreign key refers to table ApplicationTemplate)
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 LogoffDelay is used
ForcedLogoff	SMALLINT				Flag indicating mode of logoff (wait for all session apps to be closed or immediately)
ShowLastUser	SMALLINT				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

IndexName	IndexType	Columns
PRIMARY	PRIMARY	ApplicationTemplateID

 

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));