Merge pull request #2298 from SOlangsam/patch-2

Update mysql_db_setup.sql

1 files changed, 144 insertions, 140 deletions

diff --git a/mRemoteNGDocumentation/mysql_db_setup.sql b/mRemoteNGDocumentation/mysql_db_setup.sql
index 2b3a22fd..297904d5 100644
--- a/mRemoteNGDocumentation/mysql_db_setup.sql
+++ b/mRemoteNGDocumentation/mysql_db_setup.sql
@@ -25,146 +25,150 @@ CREATE TABLE `tblCons` (
     `Name` varchar(128) NOT NULL,
     `Type` varchar(32) NOT NULL,
     `Expanded` tinyint(1) NOT NULL,
-	`AutomaticResize` tinyint(1) NOT NULL DEFAULT 1,
-	`CacheBitmaps` tinyint(1) NOT NULL,
-	`Colors` varchar(32) NOT NULL,
-	`ConnectToConsole` tinyint(1) NOT NULL,
-	`Connected` tinyint(1) NOT NULL,
-	`Description` varchar(1024) DEFAULT NULL,
-	`DisableCursorBlinking` tinyint(1) NOT NULL,
-	`DisableCursorShadow` tinyint(1) NOT NULL,
-	`DisableFullWindowDrag` tinyint(1) NOT NULL,
-	`DisableMenuAnimations` tinyint(1) NOT NULL,
-	`DisplayThemes` tinyint(1) NOT NULL,
-	`DisplayWallpaper` tinyint(1) NOT NULL,
-	`Domain` varchar(512) DEFAULT NULL,
-	`EnableDesktopComposition` tinyint(1) NOT NULL,
-	`EnableFontSmoothing` tinyint(1) NOT NULL,
-	`ExtApp` varchar(256) DEFAULT NULL,
-	`Favorite`  tinyint(1) NOT NULL,
-	`Hostname` varchar(512) DEFAULT NULL,
-	`LoadBalanceInfo` varchar(1024) DEFAULT NULL,
-	`MacAddress` varchar(32) DEFAULT NULL,
-	`OpeningCommand` varchar(512) DEFAULT NULL,
-	`Panel` varchar(128) NOT NULL,
-	`Password` varchar(1024) DEFAULT NULL,
-	`Port` int(11) NOT NULL,
-	`PostExtApp` varchar(256) DEFAULT NULL,
-	`PreExtApp` varchar(256) DEFAULT NULL,
-	`Protocol` varchar(32) NOT NULL,
-	`PuttySession` varchar(128) DEFAULT NULL,
-	`RDGatewayDomain` varchar(512) DEFAULT NULL,
-	`RDGatewayHostname` varchar(512) DEFAULT NULL,
-	`RDGatewayPassword` varchar(1024) DEFAULT NULL,
-	`RDGatewayUsageMethod` varchar(32) NOT NULL,
-	`RDGatewayUseConnectionCredentials` varchar(32) NOT NULL,
-	`RDGatewayUsername` varchar(512) DEFAULT NULL,
-	`RDPAlertIdleTimeout` tinyint(1) NOT NULL,
-	`RDPAuthenticationLevel` varchar(32) NOT NULL,
-	`RDPMinutesToIdleTimeout` int(11) NOT NULL,
-	`RdpVersion` varchar(10) DEFAULT NULL,
-	`RedirectAudioCapture` tinyint(1) NOT NULL DEFAULT 0,
-	`RedirectClipboard` tinyint(1) NOT NULL DEFAULT 0,
-	`RedirectDiskDrives` tinyint(1) NOT NULL,
-	`RedirectKeys` tinyint(1) NOT NULL,
-	`RedirectPorts` tinyint(1) NOT NULL,
-	`RedirectPrinters` tinyint(1) NOT NULL,
-	`RedirectSmartCards` tinyint(1) NOT NULL,
-	`RedirectSound` varchar(64) NOT NULL,  
-	`RenderingEngine` varchar(16) DEFAULT NULL,
-	`Resolution` varchar(32) NOT NULL,
-	`SSHOptions` varchar(1024) NOT NULL,
-	`SSHTunnelConnectionName` varchar(128) NOT NULL,
-	`SoundQuality` varchar(20) NOT NULL,
-	`UseCredSsp` tinyint(1) NOT NULL,
-	`UseEnhancedMode` tinyint(1) DEFAULT NULL,
-	`UseVmId` tinyint(1) DEFAULT NULL,
-	`UserField` varchar(256) DEFAULT NULL,
-	`Username` varchar(512) DEFAULT NULL,
-	`VNCAuthMode` varchar(10) DEFAULT NULL,
-	`VNCColors` varchar(10) DEFAULT NULL,
-	`VNCCompression` varchar(10) DEFAULT NULL,
-	`VNCEncoding` varchar(20) DEFAULT NULL,
-	`VNCProxyIP` varchar(128) DEFAULT NULL,
-	`VNCProxyPassword` varchar(1024) DEFAULT NULL,
-	`VNCProxyPort` int(11) DEFAULT NULL,
-	`VNCProxyType` varchar(20) DEFAULT NULL,
-	`VNCProxyUsername` varchar(512) DEFAULT NULL,
-	`VNCSmartSizeMode` varchar(20) DEFAULT NULL,
-	`VNCViewOnly` tinyint(1) NOT NULL,
-	`VmId` varchar(512) DEFAULT NULL,
-	`ICAEncryptionStrength` varchar(32) NOT NULL,
-	`Icon` varchar(128) NOT NULL,
-	`InheritAutomaticResize` tinyint(1) NOT NULL DEFAULT 0,
-	`InheritCacheBitmaps` tinyint(1) NOT NULL,
-	`InheritColors` tinyint(1) NOT NULL,
-	`InheritDescription` tinyint(1) NOT NULL,
-	`InheritDisableCursorBlinking` tinyint(1) NOT NULL,
-	`InheritDisableCursorShadow` tinyint(1) NOT NULL,
-	`InheritDisableFullWindowDrag` tinyint(1) NOT NULL,
-	`InheritDisableMenuAnimations` tinyint(1) NOT NULL,
-	`InheritDisplayThemes` tinyint(1) NOT NULL,
-	`InheritDisplayWallpaper` tinyint(1) NOT NULL,
-	`InheritDomain` tinyint(1) NOT NULL,
-	`InheritEnableDesktopComposition` tinyint(1) NOT NULL,
-	`InheritEnableFontSmoothing` tinyint(1) NOT NULL,
-	`InheritExtApp` tinyint(1) NOT NULL,
-	`InheritFavorite` tinyint(1) NOT NULL,
-	`InheritICAEncryptionStrength` tinyint(1) NOT NULL,
-	`InheritIcon` tinyint(1) NOT NULL,
-	`InheritLoadBalanceInfo` tinyint(1) NOT NULL DEFAULT 0,
-	`InheritMacAddress` tinyint(1) NOT NULL,
-	`InheritOpeningCommand` tinyint(1) NOT NULL,
-	`InheritPanel` tinyint(1) NOT NULL,
-	`InheritPassword` tinyint(1) NOT NULL,
-	`InheritPort` tinyint(1) NOT NULL,
-	`InheritPostExtApp` tinyint(1) NOT NULL,
-	`InheritPreExtApp` tinyint(1) NOT NULL,
-	`InheritProtocol` tinyint(1) NOT NULL,
-	`InheritPuttySession` tinyint(1) NOT NULL,
-	`InheritRDGatewayDomain` tinyint(1) NOT NULL,
-	`InheritRDGatewayHostname` tinyint(1) NOT NULL,
-	`InheritRDGatewayPassword` tinyint(1) NOT NULL,
-	`InheritRDGatewayUsageMethod` tinyint(1) NOT NULL,
-	`InheritRDGatewayUseConnectionCredentials` tinyint(1) NOT NULL,
-	`InheritRDGatewayUsername` tinyint(1) NOT NULL,
-	`InheritRDPAlertIdleTimeout` tinyint(1) NOT NULL,
-	`InheritRDPAuthenticationLevel` tinyint(1) NOT NULL,
-	`InheritRDPMinutesToIdleTimeout` tinyint(1) NOT NULL,
-	`InheritRdpVersion` tinyint(1) NOT NULL DEFAULT 0,
-	`InheritRedirectAudioCapture` tinyint(1) NOT NULL DEFAULT 0,
-	`InheritRedirectClipboard` tinyint(1) NOT NULL DEFAULT 0,
-	`InheritRedirectDiskDrives` tinyint(1) NOT NULL,
-	`InheritRedirectKeys` tinyint(1) NOT NULL,
-	`InheritRedirectPorts` tinyint(1) NOT NULL,
-	`InheritRedirectPrinters` tinyint(1) NOT NULL,
-	`InheritRedirectSmartCards` tinyint(1) NOT NULL,
-	`InheritRedirectSound` tinyint(1) NOT NULL,
-	`InheritRenderingEngine` tinyint(1) NOT NULL,
-	`InheritResolution` tinyint(1) NOT NULL,
-	`InheritSSHOptions` tinyint(1) NOT NULL,
-	`InheritSSHTunnelConnectionName` tinyint(1) NOT NULL,
-	`InheritSoundQuality` tinyint(1) NOT NULL,
-	`InheritUseConsoleSession` tinyint(1) NOT NULL,
-	`InheritUseCredSsp` tinyint(1) NOT NULL,
-	`InheritUseEnhancedMode` tinyint(1) DEFAULT NULL,
-	`InheritUseVmId` tinyint(1) DEFAULT NULL,
-	`InheritUserField` tinyint(1) NOT NULL,
-	`InheritUsername` tinyint(1) NOT NULL,
-	`InheritVNCAuthMode` tinyint(1) NOT NULL,
-	`InheritVNCColors` tinyint(1) NOT NULL,
-	`InheritVNCCompression` tinyint(1) NOT NULL,
-	`InheritVNCEncoding` tinyint(1) NOT NULL,
-	`InheritVNCProxyIP` tinyint(1) NOT NULL,
-	`InheritVNCProxyPassword` tinyint(1) NOT NULL,
-	`InheritVNCProxyPort` tinyint(1) NOT NULL,
-	`InheritVNCProxyType` tinyint(1) NOT NULL,
-	`InheritVNCProxyUsername` tinyint(1) NOT NULL,
-	`InheritVNCSmartSizeMode` tinyint(1) NOT NULL,
-	`InheritVNCViewOnly` tinyint(1) NOT NULL,
-	`InheritVmId` tinyint(1) DEFAULT NULL,
-	`StartProgram` varchar(512) DEFAULT NULL,
-	`StartProgramWorkDir` varchar(512) DEFAULT NULL,
+    `AutomaticResize` tinyint(1) NOT NULL DEFAULT 1,
+    `CacheBitmaps` tinyint(1) NOT NULL,
+    `Colors` varchar(32) NOT NULL,
+    `ConnectToConsole` tinyint(1) NOT NULL,
+    `Connected` tinyint(1) NOT NULL,
+    `Description` varchar(1024) DEFAULT NULL,
+    `DisableCursorBlinking` tinyint(1) NOT NULL,
+    `DisableCursorShadow` tinyint(1) NOT NULL,
+    `DisableFullWindowDrag` tinyint(1) NOT NULL,
+    `DisableMenuAnimations` tinyint(1) NOT NULL,
+    `DisplayThemes` tinyint(1) NOT NULL,
+    `DisplayWallpaper` tinyint(1) NOT NULL,
+    `Domain` varchar(512) DEFAULT NULL,
+    `EnableDesktopComposition` tinyint(1) NOT NULL,
+    `EnableFontSmoothing` tinyint(1) NOT NULL,
+    `ExtApp` varchar(256) DEFAULT NULL,
+    `Favorite` tinyint(1) NOT NULL,
+    `Hostname` varchar(512) DEFAULT NULL,
+    `LoadBalanceInfo` varchar(1024) DEFAULT NULL,
+    `MacAddress` varchar(32) DEFAULT NULL,
+    `OpeningCommand` varchar(512) DEFAULT NULL,
+    `Panel` varchar(128) NOT NULL,
+    `Password` varchar(1024) DEFAULT NULL,
+    `Port` int(11) NOT NULL,
+    `PostExtApp` varchar(256) DEFAULT NULL,
+    `PreExtApp` varchar(256) DEFAULT NULL,
+    `Protocol` varchar(32) NOT NULL,
+    `PuttySession` varchar(128) DEFAULT NULL,
+    `RDGatewayDomain` varchar(512) DEFAULT NULL,
+    `RDGatewayHostname` varchar(512) DEFAULT NULL,
+    `RDGatewayPassword` varchar(1024) DEFAULT NULL,
+    `RDGatewayUsageMethod` varchar(32) NOT NULL,
+    `RDGatewayUseConnectionCredentials` varchar(32) NOT NULL,
+    `RDGatewayUsername` varchar(512) DEFAULT NULL,
+    `RDPAlertIdleTimeout` tinyint(1) NOT NULL,
+    `RDPAuthenticationLevel` varchar(32) NOT NULL,
+    `RDPMinutesToIdleTimeout` int(11) NOT NULL,
+    `RdpVersion` varchar(10) DEFAULT NULL,
+    `RedirectAudioCapture` tinyint(1) NOT NULL DEFAULT 0,
+    `RedirectClipboard` tinyint(1) NOT NULL DEFAULT 0,
+    `RedirectDiskDrives` tinyint(1) NOT NULL,
+    `RedirectKeys` tinyint(1) NOT NULL,
+    `RedirectPorts` tinyint(1) NOT NULL,
+    `RedirectPrinters` tinyint(1) NOT NULL,
+    `RedirectSmartCards` tinyint(1) NOT NULL,
+    `RedirectSound` varchar(64) NOT NULL,
+    `RenderingEngine` varchar(16) DEFAULT NULL,
+    `Resolution` varchar(32) NOT NULL,
+    `SSHOptions` varchar(1024) NOT NULL,
+    `SSHTunnelConnectionName` varchar(128) NOT NULL,
+    `SoundQuality` varchar(20) NOT NULL,
+    `UseCredSsp` tinyint(1) NOT NULL,
+    `UseEnhancedMode` tinyint(1) DEFAULT NULL,
+    `UseVmId` tinyint(1) DEFAULT NULL,
+    `UserField` varchar(256) DEFAULT NULL,
+    `Username` varchar(512) DEFAULT NULL,
+    `VNCAuthMode` varchar(10) DEFAULT NULL,
+    `VNCColors` varchar(10) DEFAULT NULL,
+    `VNCCompression` varchar(10) DEFAULT NULL,
+    `VNCEncoding` varchar(20) DEFAULT NULL,
+    `VNCProxyIP` varchar(128) DEFAULT NULL,
+    `VNCProxyPassword` varchar(1024) DEFAULT NULL,
+    `VNCProxyPort` int(11) DEFAULT NULL,
+    `VNCProxyType` varchar(20) DEFAULT NULL,
+    `VNCProxyUsername` varchar(512) DEFAULT NULL,
+    `VNCSmartSizeMode` varchar(20) DEFAULT NULL,
+    `VNCViewOnly` tinyint(1) NOT NULL,
+    `VmId` varchar(512) DEFAULT NULL,
+    `ICAEncryptionStrength` varchar(32) NOT NULL,
+    `Icon` varchar(128) NOT NULL,
+    `InheritAutomaticResize` tinyint(1) NOT NULL DEFAULT 0,
+    `InheritCacheBitmaps` tinyint(1) NOT NULL,
+    `InheritColors` tinyint(1) NOT NULL,
+    `InheritDescription` tinyint(1) NOT NULL,
+    `InheritDisableCursorBlinking` tinyint(1) NOT NULL,
+    `InheritDisableCursorShadow` tinyint(1) NOT NULL,
+    `InheritDisableFullWindowDrag` tinyint(1) NOT NULL,
+    `InheritDisableMenuAnimations` tinyint(1) NOT NULL,
+    `InheritDisplayThemes` tinyint(1) NOT NULL,
+    `InheritDisplayWallpaper` tinyint(1) NOT NULL,
+    `InheritDomain` tinyint(1) NOT NULL,
+    `InheritEnableDesktopComposition` tinyint(1) NOT NULL,
+    `InheritEnableFontSmoothing` tinyint(1) NOT NULL,
+    `InheritExtApp` tinyint(1) NOT NULL,
+    `InheritFavorite` tinyint(1) NOT NULL,
+    `InheritICAEncryptionStrength` tinyint(1) NOT NULL,
+    `InheritIcon` tinyint(1) NOT NULL,
+    `InheritLoadBalanceInfo` tinyint(1) NOT NULL DEFAULT 0,
+    `InheritMacAddress` tinyint(1) NOT NULL,
+    `InheritOpeningCommand` tinyint(1) NOT NULL,
+    `InheritPanel` tinyint(1) NOT NULL,
+    `InheritPassword` tinyint(1) NOT NULL,
+    `InheritPort` tinyint(1) NOT NULL,
+    `InheritPostExtApp` tinyint(1) NOT NULL,
+    `InheritPreExtApp` tinyint(1) NOT NULL,
+    `InheritProtocol` tinyint(1) NOT NULL,
+    `InheritPuttySession` tinyint(1) NOT NULL,
+    `InheritRDGatewayDomain` tinyint(1) NOT NULL,
+    `InheritRDGatewayHostname` tinyint(1) NOT NULL,
+    `InheritRDGatewayPassword` tinyint(1) NOT NULL,
+    `InheritRDGatewayUsageMethod` tinyint(1) NOT NULL,
+    `InheritRDGatewayUseConnectionCredentials` tinyint(1) NOT NULL,
+    `InheritRDGatewayUsername` tinyint(1) NOT NULL,
+    `InheritRDPAlertIdleTimeout` tinyint(1) NOT NULL,
+    `InheritRDPAuthenticationLevel` tinyint(1) NOT NULL,
+    `InheritRDPMinutesToIdleTimeout` tinyint(1) NOT NULL,
+    `InheritRdpVersion` tinyint(1) NOT NULL DEFAULT 0,
+    `InheritRedirectAudioCapture` tinyint(1) NOT NULL DEFAULT 0,
+    `InheritRedirectClipboard` tinyint(1) NOT NULL DEFAULT 0,
+    `InheritRedirectDiskDrives` tinyint(1) NOT NULL,
+    `InheritRedirectKeys` tinyint(1) NOT NULL,
+    `InheritRedirectPorts` tinyint(1) NOT NULL,
+    `InheritRedirectPrinters` tinyint(1) NOT NULL,
+    `InheritRedirectSmartCards` tinyint(1) NOT NULL,
+    `InheritRedirectSound` tinyint(1) NOT NULL,
+    `InheritRenderingEngine` tinyint(1) NOT NULL,
+    `InheritResolution` tinyint(1) NOT NULL,
+    `InheritSSHOptions` tinyint(1) NOT NULL,
+    `InheritSSHTunnelConnectionName` tinyint(1) NOT NULL,
+    `InheritSoundQuality` tinyint(1) NOT NULL,
+    `InheritUseConsoleSession` tinyint(1) NOT NULL,
+    `InheritUseCredSsp` tinyint(1) NOT NULL,
+    `InheritUseRestrictedAdmin` tinyint(1) NOT NULL,
+    `InheritUseRCG` tinyint(1) NOT NULL,
+    `UseRestrictedAdmin` tinyint(1) NOT NULL,
+    `UseRCG` tinyint(1) NOT NULL,
+    `InheritUseEnhancedMode` tinyint(1) DEFAULT NULL,
+    `InheritUseVmId` tinyint(1) DEFAULT NULL,
+    `InheritUserField` tinyint(1) NOT NULL,
+    `InheritUsername` tinyint(1) NOT NULL,
+    `InheritVNCAuthMode` tinyint(1) NOT NULL,
+    `InheritVNCColors` tinyint(1) NOT NULL,
+    `InheritVNCCompression` tinyint(1) NOT NULL,
+    `InheritVNCEncoding` tinyint(1) NOT NULL,
+    `InheritVNCProxyIP` tinyint(1) NOT NULL,
+    `InheritVNCProxyPassword` tinyint(1) NOT NULL,
+    `InheritVNCProxyPort` tinyint(1) NOT NULL,
+    `InheritVNCProxyType` tinyint(1) NOT NULL,
+    `InheritVNCProxyUsername` tinyint(1) NOT NULL,
+    `InheritVNCSmartSizeMode` tinyint(1) NOT NULL,
+    `InheritVNCViewOnly` tinyint(1) NOT NULL,
+    `InheritVmId` tinyint(1) DEFAULT NULL,
+    `StartProgram` varchar(512) DEFAULT NULL,
+    `StartProgramWorkDir` varchar(512) DEFAULT NULL,
     PRIMARY KEY (`ConstantID`),
     UNIQUE (`ID`)
 ) ENGINE=InnoDB AUTO_INCREMENT=3324 DEFAULT CHARSET=latin1;