Table: PNATemplate
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) | |||||||||||||||||
ServerUrl | NVARCHAR(255) | Server
name or complete server URL (f.e. http://<server>/Citrix/PNAgent/config.xml) | |||||||||||||||||||
Port | INTEGER | 80 | Server port | ||||||||||||||||||
Username | NVARCHAR(255) | Username for logon | |||||||||||||||||||
Pass | NVARCHAR(255) | User
password for logon (encrypted) (use 000f4367616e78637f6c6e7e6e7a766760 for $ELUXPASSWORD single sign-on) | |||||||||||||||||||
Domain | NVARCHAR(255) | Domain name | |||||||||||||||||||
LogoffDelay | INTEGER | Logoff delay (in seconds), ignored if attribute UseLogoffDelay is not set | |||||||||||||||||||
UseLogoffDelay | SMALLINT(6) | 0 | Logoff
after delay of LogoffDelay seconds 0|1 | ||||||||||||||||||
AutostartFolder | NVARCHAR(255) | Folder
name Applications located in this folder are started after logon | |||||||||||||||||||
ShowLastUser | SMALLINT(6) | 1 | Last
user is displayed in logon dialog 0|1 | ||||||||||||||||||
AllowCancel | SMALLINT(6) | 1 | User
can cancel logon dialog 0|1 | ||||||||||||||||||
Resolution | INTEGER | 0 | Index
to the following resolution list:
| ||||||||||||||||||
Colors | INTEGER | 0 | Index
to the following list:
| ||||||||||||||||||
Audio | INTEGER | 0 | Sound
quality
| ||||||||||||||||||
ForcedLogoff | SMALLINT(6) | 0 | Logoff
after last PN agent session was closed 0|1 | ||||||||||||||||||
LogoffSessions | SMALLINT(6) | 0 | Logoff
PNA sessions if user logs off from client 0|1 | ||||||||||||||||||
ReservedString1 | NVARCHAR(255) | ||||||||||||||||||||
ReservedString2 | NVARCHAR(255) | ||||||||||||||||||||
ReservedInt1 | INTEGER | ||||||||||||||||||||
ReservedInt2 | INTEGER |
IndexName | IndexType | Columns |
---|---|---|
PRIMARY | PRIMARY | ApplicationTemplateID |
How to create
CREATE TABLE PNATemplate(
ApplicationTemplateID INTEGER NOT NULL,
ServerUrl NVARCHAR(255),
Port INTEGER,
Username NVARCHAR(255),
Pass NVARCHAR(255),
Domain NVARCHAR(255),
LogoffDelay INTEGER,
UseLogoffDelay SMALLINT,
AutostartFolder NVARCHAR(255),
ShowLastUser SMALLINT,
AllowCancel SMALLINT,
Resolution INTEGER,
Colors INTEGER,
Audio INTEGER,
ForcedLogoff SMALLINT,
LogoffSessions SMALLINT,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
CONSTRAINT FK_PNA_ApplicationTemplateID_ApplicationTemplate_ApplicationTemplateID FOREIGN KEY (ApplicationTemplateID) REFERENCES ApplicationTemplate (ApplicationTemplateID)),
PRIMARY KEY (ApplicationTemplateID ));