Table: RDP

Each entry describes an application of type APPLTYPE_RDP.

ColumnName	DataType	Key	Not Null	Default Value	Comment
ApplicationID	INTEGER	PK, FK	NN		Unique application ID Foreign key refers to table Application
Server	NVARCHAR(255)				Server name (or IP)
Application	NVARCHAR(255)				Application to start
WorkDir	NVARCHAR(255)				Working directory of application
Username	NVARCHAR(255)				Username
Pass	NVARCHAR(255)				User password for logon (encrypted) (use 000f4367616e78637f6c6e7e6e7a766760 for $ELUXPASSWORD single sign on)
Domain	NVARCHAR(255)				Domain
RDPType	NVARCHAR(255)				native
Autologin	NVARCHAR(255)				Process automatic logon using Username, Pass, Domain true|false
Resolution	SMALLINT(6)				Index to the following resolution list: 0 full screen 1 640x480 2 800x600 3 1024x768 4 1152x864 5 1280x1024
Colors	SMALLINT(6)				Colors: 8 | 16 | 24
Keyboard	NVARCHAR(255)				Keyboard layout: "auto" auto "da" Dansk "de" German "de-ch" German(Switzerland) "en-gb" English(UK) "en-us" English(UK) "en-us_intl" English(US,international) "es" Spanish "fi" Finnish "fr" French "fr-be" French(Belgium) "fr-ch" French(Switzerland) "hu" Hungarian "is" Icelandic "it" Italian "nl" Dutch "nl-be" Dutch(Belgium) "no" Norwegian "pl" Polish "pt" Portuguese "ru" Russian "sk" Slovak "sl" Slovenian "sv" Swedish "tr" Turkish(Q) "trf" Turkish(F)
Sound	SMALLINT(6)				Play sound: 0 sound off 3 play local 5 play remote
Printer	SMALLINT(6)				Local printer available in server session 0|1
Serial	SMALLINT(6)				Local serial ports available in server session 0|1
Parallel	SMALLINT(6)				Local parallel ports available in server session 0|1
Smartcard	SMALLINT(6)				Local smart card available in server session 0|1
Options	INTEGER			15	RDP options as a combination of the following values: 1 RDP_OPT_WMDECORATIONS  Window manager decorations enabled 2 ~_ENCRYPTION Encryption enabled 4 ~_MOUSEMOTIONEVENTS  Mouse motion events enabled 8 ~_NUMLOCKSYNC  Numlock syncronisation enabled 16 ~_COMPRESSION  Compression enabled
Protocol	SMALLINT(6)			0	Protocol version: 0 auto 4 RDP V4 5 RDP V5
Bandwidth	INTEGER			0	Bandwidth to use: 0 Standard 1 Modem 2 Broadband 3 LAN
DriveName1	NVARCHAR(255)				Drive letter A - Z
DriveLocalDir1	NVARCHAR(255)				Local directory to be mapped
DriveOption1	INTEGER				1 RDP_DRIVEOPT_ON Drive enabled
DriveName2	NVARCHAR(255)				see DriveName1
DriveLocalDir2	NVARCHAR(255)				see DriveLocalDir1
DriveOption2	INTEGER				see DriveOption1
DriveName3	NVARCHAR(255)				see DriveName1
DriveLocalDir3	NVARCHAR(255)				see DriveLocalDir1
DriveOption3	INTEGER				see DriveOption1
DriveName4	NVARCHAR(255)				see DriveName1
DriveLocalDir4	NVARCHAR(255)				see DriveLocalDir1
DriveOption4	INTEGER				see DriveOption1
DriveName5	NVARCHAR(255)				see DriveName1
DriveLocalDir5	NVARCHAR(255)				see DriveLocalDir1
DriveOption5	INTEGER				see DriveOption1
DriveName6	NVARCHAR(255)				see DriveName1
DriveLocalDir6	NVARCHAR(255)				see DriveLocalDir1
DriveOption6	INTEGER				see DriveOption1
DriveName7	NVARCHAR(255)				see DriveName1
DriveLocalDir7	NVARCHAR(255)				see DriveLocalDir1
DriveOption7	INTEGER				see DriveOption1
DriveName8	NVARCHAR(255)				see DriveName1
DriveLocalDir8	NVARCHAR(255)				see DriveLocalDir1
DriveOption8	INTEGER				see DriveOption1
DriveName9	NVARCHAR(255)				see DriveName1
DriveLocalDir9	NVARCHAR(255)				see DriveLocalDir1
DriveOption9	INTEGER				see DriveOption1
DriveName10	NVARCHAR(255)				see DriveName1
DriveLocalDir10	NVARCHAR(255)				see DriveLocalDir1
DriveOption10	INTEGER
ComName1	NVARCHAR(255)
ComDev1	NVARCHAR(255)
ComName2	NVARCHAR(255)				see ComName1
ComDev2	NVARCHAR(255)				see ComDev1
ComName3	NVARCHAR(255)				see ComName1
ComDev3	NVARCHAR(255)				see ComDev1
ComName4	NVARCHAR(255)				see ComName1
ComDev4	NVARCHAR(255)				see ComDev1
ComName5	NVARCHAR(255)				see ComName1
ComDev5	NVARCHAR(255)				see ComDev1
ComName6	NVARCHAR(255)				see ComName1
ComDev6	NVARCHAR(255)				see ComDev1
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER

IndexName	IndexType	Columns
PRIMARY	PRIMARY	ApplicationID

 

how to create

CREATE TABLE RDP(
ApplicationID INTEGER NOT NULL,
Server NVARCHAR(255),
Application NVARCHAR(255),
WorkDir NVARCHAR(255),
Username NVARCHAR(255),
Pass NVARCHAR(255),
Domain NVARCHAR(255),
RDPType NVARCHAR(255),
Autologin NVARCHAR(255),
Resolution SMALLINT,
Colors SMALLINT,
Keyboard NVARCHAR(255),
Sound SMALLINT,
Printer SMALLINT,
Serial SMALLINT,
Parallel SMALLINT,
Smartcard SMALLINT,
Options INTEGER,
Protocol SMALLINT,
DriveName1 NVARCHAR(255),
DriveLocalDir1 NVARCHAR(255),
DriveOption1 INTEGER,
DriveName2 NVARCHAR(255),
DriveLocalDir2 NVARCHAR(255),
DriveOption2 INTEGER,
DriveName3 NVARCHAR(255),
DriveLocalDir3 NVARCHAR(255),
DriveOption3 INTEGER,
DriveName4 NVARCHAR(255),
DriveLocalDir4 NVARCHAR(255),
DriveOption4 INTEGER,
DriveName5 NVARCHAR(255),
DriveLocalDir5 NVARCHAR(255),
DriveOption5 INTEGER,
DriveName6 NVARCHAR(255),
DriveLocalDir6 NVARCHAR(255),
DriveOption6 INTEGER,
DriveName7 NVARCHAR(255),
DriveLocalDir7 NVARCHAR(255),
DriveOption7 INTEGER,
DriveName8 NVARCHAR(255),
DriveLocalDir8 NVARCHAR(255),
DriveOption8 INTEGER,
DriveName9 NVARCHAR(255),
DriveLocalDir9 NVARCHAR(255),
DriveOption9 INTEGER,
DriveName10 NVARCHAR(255),
DriveLocalDir10 NVARCHAR(255),
DriveOption10 INTEGER,
ComName1 NVARCHAR(255),
ComDev1 NVARCHAR(255),
ComName2 NVARCHAR(255),
ComDev2 NVARCHAR(255),
ComName3 NVARCHAR(255),
ComDev3 NVARCHAR(255),
ComName4 NVARCHAR(255),
ComDev4 NVARCHAR(255),
ComName5 NVARCHAR(255),
ComDev5 NVARCHAR(255),
ComName6 NVARCHAR(255),
ComDev6 NVARCHAR(255),
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
CONSTRAINT FK_RDP_ApplicationID_Application_ApplicationID FOREIGN KEY (ApplicationID) REFERENCES Application (ApplicationID),
PRIMARY KEY (ApplicationID));