Table: PNA
Each entry describes an application of the type APPLTYPE_PNL.
ColumnName | DataType | Key | Not Null | Default Value | Comment | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ApplicationID | INTEGER | PK, FK | NN | Unique application ID (foreign key refers to table Application) | |||||||||||||||||
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 | ApplicationID |
How to create
CREATE TABLE PNA(
ApplicationID 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_ApplicationID_Application_ApplicationID FOREIGN KEY (ApplicationID) REFERENCES Application (ApplicationID),
PRIMARY KEY (ApplicationID));