/
diev
/
mRemoteNG
Обзор
Документация
Войти
/
diev
/
mRemoteNG
Код
Запросы
0
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
develop
mRemoteNGDocumentation/mysql_db_setup.sql
209 строк
9 KB
Andy Binder
Update mysql_db_setup.sql
23 фев 2022, 23:57
Не верифицирован
23 фев 2022, 23:57
e95b6f1
Код
Авторство
О чём код?
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `tblCons` -- DROP TABLE IF EXISTS `tblCons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblCons` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `ConstantID` varchar(128) NOT NULL, `PositionID` int(11) NOT NULL, `ParentID` varchar(128) DEFAULT NULL, `LastChange` datetime NOT NULL, `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, PRIMARY KEY (`ConstantID`), UNIQUE (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=3324 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tblRoot` -- DROP TABLE IF EXISTS `tblRoot`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblRoot` ( `Name` varchar(2048) NOT NULL, `Export` tinyint(1) NOT NULL, `Protected` varchar(4048) NOT NULL, `ConfVersion` varchar(15) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tblUpdate` -- DROP TABLE IF EXISTS `tblUpdate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblUpdate` ( `LastUpdate` datetime(3) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;