Information only - do not modify without consulting Cirrus Link
ParameterTypeDescriptionDefault
namestring
"default"
folderstring
"h2/default"
userstring
"sa"
passwordstring
""
loginTimeoutinteger
I"40"
tables.1.namestring
"accounts"
tables.1.keys.1string
"account"
tables.1.columns.1.namestring
"id"
tables.1.columns.1.typestring
"INT IDENTITY(1,1)"
tables.1.columns.1.isPrimaryboolean
B"true"
tables.1.columns.2.namestring
"accountName"
tables.1.columns.2.typestring
"VARCHAR (255)"
tables.1.columns.2.isIdboolean
B"true"
tables.1.columns.3.namestring
"accountDescription"
tables.1.columns.3.typestring
"VARCHAR (255)"
tables.1.columns.4.namestring
"meta_createdBy"
tables.1.columns.4.typestring
"VARCHAR (255)"
tables.1.columns.5.namestring
"meta_createdOn"
tables.1.columns.5.typestring
"BIGINT"
tables.1.columns.6.namestring
"meta_modifiedBy"
tables.1.columns.6.typestring
"VARCHAR (255)"
tables.1.columns.7.namestring
"meta_modifiedOn"
tables.1.columns.7.typestring
"BIGINT"
tables.1.columns.8.namestring
"accountId"
tables.1.columns.8.typestring
"VARCHAR (255)"
tables.2.namestring
"users"
tables.2.keys.1string
"user"
tables.2.columns.1.namestring
"id"
tables.2.columns.1.typestring
"INT IDENTITY(1,1)"
tables.2.columns.1.isPrimaryboolean
B"true"
tables.2.columns.2.namestring
"username"
tables.2.columns.2.typestring
"VARCHAR (255)"
tables.2.columns.2.isIdboolean
B"true"
tables.2.columns.3.namestring
"meta_createdBy"
tables.2.columns.3.typestring
"VARCHAR (255)"
tables.2.columns.4.namestring
"meta_createdOn"
tables.2.columns.4.typestring
"BIGINT"
tables.2.columns.5.namestring
"meta_modifiedBy"
tables.2.columns.5.typestring
"VARCHAR (255)"
tables.2.columns.6.namestring
"meta_modifiedOn"
tables.2.columns.6.typestring
"BIGINT"
tables.2.columns.7.namestring
"accountId"
tables.2.columns.7.typestring
"VARCHAR (255)"
tables.2.columns.8.namestring
"password_value"
tables.2.columns.8.typestring
"VARCHAR (255)"
tables.2.columns.9.namestring
"password_salt"
tables.2.columns.9.typestring
"BINARY(32)"
tables.2.columns.10.namestring
"password_algorithm"
tables.2.columns.10.typestring
"VARCHAR (255)"
tables.2.columns.11.namestring
"password_hashIterations"
tables.2.columns.11.typestring
"INT"
tables.2.columns.12.namestring
"roles"
tables.2.columns.12.typestring
"VARCHAR"
tables.2.columns.13.namestring
"permissions"
tables.2.columns.13.typestring
"VARCHAR"
tables.2.columns.14.namestring
"firstName"
tables.2.columns.14.typestring
"VARCHAR (255)"
tables.2.columns.15.namestring
"lastName"
tables.2.columns.15.typestring
"VARCHAR (255)"
tables.2.columns.16.namestring
"phoneNumber"
tables.2.columns.16.typestring
"VARCHAR (255)"
tables.2.columns.17.namestring
"email"
tables.2.columns.17.typestring
"VARCHAR (255)"
tables.2.columns.18.namestring
"company"
tables.2.columns.18.typestring
"VARCHAR (255)"
tables.2.columns.19.namestring
"address_number"
tables.2.columns.19.typestring
"INT"
tables.2.columns.20.namestring
"address_street"
tables.2.columns.20.typestring
"VARCHAR (255)"
tables.2.columns.21.namestring
"address_city"
tables.2.columns.21.typestring
"VARCHAR (255)"
tables.2.columns.22.namestring
"address_province"
tables.2.columns.22.typestring
"VARCHAR (255)"
tables.2.columns.23.namestring
"address_zip"
tables.2.columns.23.typestring
"VARCHAR (255)"
tables.2.columns.24.namestring
"address_country"
tables.2.columns.24.typestring
"VARCHAR (255)"
tables.3.namestring
"mqttusers"
tables.3.keys.1string
"mqttuser"
tables.3.columns.1.namestring
"id"
tables.3.columns.1.typestring
"INT IDENTITY(1,1)"
tables.3.columns.1.isPrimaryboolean
B"true"
tables.3.columns.2.namestring
"username"
tables.3.columns.2.typestring
"VARCHAR (255)"
tables.3.columns.2.isIdboolean
B"true"
tables.3.columns.3.namestring
"meta_createdBy"
tables.3.columns.3.typestring
"VARCHAR (255)"
tables.3.columns.4.namestring
"meta_createdOn"
tables.3.columns.4.typestring
"BIGINT"
tables.3.columns.5.namestring
"meta_modifiedBy"
tables.3.columns.5.typestring
"VARCHAR (255)"
tables.3.columns.6.namestring
"meta_modifiedOn"
tables.3.columns.6.typestring
"BIGINT"
tables.3.columns.7.namestring
"accountId"
tables.3.columns.7.typestring
"VARCHAR (255)"
tables.3.columns.8.namestring
"password_value"
tables.3.columns.8.typestring
"VARCHAR (255)"
tables.3.columns.9.namestring
"password_salt"
tables.3.columns.9.typestring
"BINARY(32)"
tables.3.columns.10.namestring
"password_algorithm"
tables.3.columns.10.typestring
"VARCHAR (255)"
tables.3.columns.11.namestring
"password_hashIterations"
tables.3.columns.11.typestring
"INT"
tables.3.columns.12.namestring
"acl_subscribe"
tables.3.columns.12.typestring
"VARCHAR"
tables.3.columns.13.namestring
"acl_publish"
tables.3.columns.13.typestring
"VARCHAR"
tables.4.namestring
"roles"
tables.4.keys.1string
"role"
tables.4.columns.1.namestring
"id"
tables.4.columns.1.typestring
"INT IDENTITY(1,1)"
tables.4.columns.1.isPrimaryboolean
B"true"
tables.4.columns.2.namestring
"name"
tables.4.columns.2.typestring
"VARCHAR (255)"
tables.4.columns.2.isIdboolean
B"true"
tables.4.columns.3.namestring
"meta_createdBy"
tables.4.columns.3.typestring
"VARCHAR (255)"
tables.4.columns.4.namestring
"meta_createdOn"
tables.4.columns.4.typestring
"BIGINT"
tables.4.columns.5.namestring
"meta_modifiedBy"
tables.4.columns.5.typestring
"VARCHAR (255)"
tables.4.columns.6.namestring
"meta_modifiedOn"
tables.4.columns.6.typestring
"BIGINT"
tables.4.columns.7.namestring
"accountId"
tables.4.columns.7.typestring
"VARCHAR (255)"
tables.4.columns.8.namestring
"permissions"
tables.4.columns.8.typestring
"VARCHAR"
tables.5.namestring
"licenses"
tables.5.keys.1string
"license"
tables.5.columns.1.namestring
"id"
tables.5.columns.1.typestring
"INT IDENTITY(1,1)"
tables.5.columns.1.isPrimaryboolean
B"true"
tables.5.columns.2.name=string
"licenseName"
tables.5.columns.2.typestring
"VARCHAR (255)"
tables.5.columns.2.isIdboolean
B"true"
tables.5.columns.3.namestring
"state"
tables.5.columns.3.typestring
"VARCHAR"
tables.5.columns.4.namestring
"licenseType"
tables.5.columns.4.typestring
"INT"
tables.5.columns.5.namestring
"licenseString"
tables.5.columns.5.typestring
"VARCHAR"
tables.5.columns.6.namestring
"activatedLicenseType"
tables.5.columns.6.typestring
"INT"
tables.5.columns.7.namestring
"activatedLicenseString"
tables.5.columns.7.typestring
"VARCHAR"
tables.5.columns.8.namestring
"activationServerAddress"
tables.5.columns.8.typestring
"VARCHAR"
tables.5.columns.9.namestring
"meta_createdBy"
tables.5.columns.9.typestring
"VARCHAR (255)"
tables.5.columns.10.namestring
"meta_createdOn"
tables.5.columns.10.typestring
"BIGINT"
tables.5.columns.11.namestring
"meta_modifiedBy"
tables.5.columns.11.typestring
"VARCHAR (255)"
tables.5.columns.12.namestring
"meta_modifiedOn"
tables.5.columns.12.typestring
"BIGINT"
tables.5.columns.13.namestring
"customHardwareId"
tables.5.columns.13.typestring
"VARCHAR"
tables.5.columns.14.namestring
"activatedOnline"
tables.5.columns.14.typestring
"BOOLEAN"
tables.6.namestring
"eulas"
tables.6.keys.1string
"eula"
tables.6.columns.1.namestring
"id"
tables.6.columns.1.typestring
"INT IDENTITY(1,1)"
tables.6.columns.1.isPrimaryboolean
B"true"
tables.6.columns.2.namestring
"name"
tables.6.columns.2.typestring
"VARCHAR (255)"
tables.6.columns.2.isIdboolean
B"true"
tables.6.columns.3.namestring
"isAccepted"
tables.6.columns.3.typestring
"BOOLEAN"
tables.6.columns.4.namestring
"acceptedOn"
tables.6.columns.4.typestring
"BIGINT"
tables.7.namestring
"servers"
tables.7.keys.1string
"server"
tables.7.columns.1.namestring
"id"
tables.7.columns.1.typestring
"INT IDENTITY(1,1)"
tables.7.columns.1.isPrimaryboolean
B"true"
tables.7.columns.2.namestring
"name"
tables.7.columns.2.typestring
"VARCHAR (255)"
tables.7.columns.2.isIdboolean
B"true"
tables.7.columns.3.namestring
"isStopped"
tables.7.columns.3.typestring
"BOOLEAN"
tables.7.columns.4.namestring
"stoppedOn"
tables.7.columns.4.typestring
"BIGINT"
tables.8.namestring
"uploads"
tables.8.keys.1string
"upload"
tables.8.columns.1.namestring
"id"
tables.8.columns.1.typestring
"INT IDENTITY(1,1)"
tables.8.columns.1.isPrimaryboolean
B"true"
tables.8.columns.2.namestring
"fileId"
tables.8.columns.2.typestring
"VARCHAR"
tables.8.columns.2.isIdboolean
B"true"
tables.8.columns.3.namestring
"filename"
tables.8.columns.3.typestring
"VARCHAR"
tables.8.columns.4.namestring
"timestamp"
tables.8.columns.4.typestring
"BIGINT"
tables.9.namestring
"system"
tables.9.keys.1string
"system"
tables.9.columns.1.namestring
"id"
tables.9.columns.1.typestring
"INT IDENTITY(1,1)"
tables.9.columns.1.isPrimaryboolean
B"true"
tables.9.columns.2.namestring
"systemName"
tables.9.columns.2.typestring
"VARCHAR"
tables.9.columns.2.isIdboolean
B"true"
tables.9.columns.3.namestring
"isSslSetup"
tables.9.columns.3.typestring
"BOOLEAN"
tables.9.columns.4.namestring
"setupOn"
tables.9.columns.4.typestring
"BIGINT"
tables.9.columns.5.namestring
"privateKeyFilename"
tables.9.columns.5.typestring
"VARCHAR"
tables.9.columns.6.namestring
"caChainFilename"
tables.9.columns.6.typestring
"VARCHAR"
tables.9.columns.7.namestring
"certificateFilename"
tables.9.columns.7.typestring
"VARCHAR"
tables.10.namestring
"mqttevents"
tables.10.maxRowsinteger
I"655360"
tables.10.keys.1string
"mqttevent"
tables.10.indexes.1string
"MQTTEVENTS"
tables.10.columns.1.namestring
"id"
tables.10.columns.1.typestring
"INT IDENTITY(1,1)"
tables.10.columns.1.isIdboolean
B"true"
tables.10.columns.1.indexstring
"MQTTEVENTS"
tables.10.columns.1.orderstring
"DESC"
tables.10.columns.2.namestring
"clientId"
tables.10.columns.2.typestring
"VARCHAR (255)"
tables.10.columns.3.namestring
"clientIp"
tables.10.columns.3.typestring
"VARCHAR (255)"
tables.10.columns.4.namestring
"message"
tables.10.columns.4.typestring
"VARCHAR"
tables.10.columns.5.namestring
"type"
tables.10.columns.5.typestring
"INT"
tables.10.columns.6.namestring
"timestamp"
tables.10.columns.6.typestring
"BIGINT"
tables.11.namestring
"alerts"
tables.11.maxRowsinteger
I"65536"
tables.11.mergeTablesboolean
B"true"
tables.11.keys.1string
"alert"
tables.11.indexes.1string
"ALERTS"
tables.11.columns.1.namestring
"id"
tables.11.columns.1.typestring
"INT IDENTITY(1,1)"
tables.11.columns.1.isPrimaryboolean
B"true"
tables.11.columns.1.isIdboolean
B"true"
tables.11.columns.1.indexstring
"ALERTS"
tables.11.columns.1.orderstring
"DESC"
tables.11.columns.2.namestring
"type"
tables.11.columns.2.typestring
"VARCHAR (255)"
tables.11.columns.3.namestring
"activeTime"
tables.11.columns.3.typestring
"BIGINT"
tables.11.columns.4.namestring
"description"
tables.11.columns.4.typestring
"VARCHAR"
tables.11.columns.5.namestring
"acknowledged"
tables.11.columns.5.typestring
"BOOLEAN"
tables.11.columns.6.namestring
"cleared"
tables.11.columns.6.typestring
"BOOLEAN"
tables.11.columns.7.namestring
"deleted"
tables.11.columns.7.typestring
"BOOLEAN"
tables.11.columns.8.namestring
"priority"
tables.11.columns.8.typestring
"INT"
tables.11.columns.9.namestring
"severity"
tables.11.columns.9.typestring
"INT"
tables.11.columns.10.namestring
"meta_createdBy"
tables.11.columns.10.typestring
"VARCHAR (255)"
tables.11.columns.11.namestring
"meta_createdOn"
tables.11.columns.11.typestring
"BIGINT"
tables.11.columns.12.namestring
"meta_modifiedBy"
tables.11.columns.12.typestring
"VARCHAR (255)"
tables.11.columns.13.namestring
"meta_modifiedOn"
tables.11.columns.13.typestring
"BIGINT"
tables.12.namestring
"alerttypes"
tables.12.keys.1string
"alerttype"
tables.12.columns.1.namestring
"id"
tables.12.columns.1.typestring
"INT IDENTITY(1,1)"
tables.12.columns.1.isPrimaryboolean
B"true"
tables.12.columns.2.namestring
"name"
tables.12.columns.2.typestring
"VARCHAR (255)"
tables.12.columns.2.isIdboolean
B"true"
tables.12.columns.3.namestring
"path"
tables.12.columns.3.typestring
"VARCHAR (255)"
tables.12.columns.4.namestring
"priority"
tables.12.columns.4.typestring
"INT"
tables.12.columns.5.namestring
"severity"
tables.12.columns.5.typestring
"INT"
tables.12.columns.6.namestring
"enabled"
tables.12.columns.6.typestring
"BOOLEAN"
tables.13.namestring
"version"
tables.13.columns.1.namestring
"id"
tables.13.columns.1.typestring
"INT IDENTITY(1,1)"
tables.13.columns.1.isIdboolean
B"true"
tables.13.columns.2.namestring
"chariotVersion"
tables.13.columns.2.typestring
"VARCHAR"
tables.13.columns.3.namestring
"buildTimestamp"
tables.13.columns.3.typestring
"VARCHAR"
tables.13.columns.4.namestring
"buildPlatform"
tables.13.columns.4.typestring
"VARCHAR"
tables.14.namestring
"bridgeclients"
tables.14.keys.1string
"bridgeclient"
tables.14.columns.1.namestring
"id"
tables.14.columns.1.typestring
"INT IDENTITY(1,1)"
tables.14.columns.1.isPrimaryboolean
B"true"
tables.14.columns.2.namestring
"name"
tables.14.columns.2.typestring
"VARCHAR (255)"
tables.14.columns.2.isIdboolean
B"true"
tables.14.columns.3.namestring
"meta_createdBy"
tables.14.columns.3.typestring
"VARCHAR (255)"
tables.14.columns.4.namestring
"meta_createdOn"
tables.14.columns.4.typestring
"BIGINT"
tables.14.columns.5.namestring
"meta_modifiedBy"
tables.14.columns.5.typestring
"VARCHAR (255)"
tables.14.columns.6.namestring
"meta_modifiedOn"
tables.14.columns.6.typestring
"BIGINT"
tables.14.columns.7.namestring
"accountId"
tables.14.columns.7.typestring
"VARCHAR (255)"
tables.14.columns.8.namestring
"username"
tables.14.columns.8.typestring
"VARCHAR (255)"
tables.14.columns.9.namestring
"password"
tables.14.columns.9.typestring
"VARCHAR (255)"
tables.14.columns.10.namestring
"address"
tables.14.columns.10.typestring
"VARCHAR (255)"
tables.14.columns.11.namestring
"port"
tables.14.columns.11.typestring
"INT"
tables.14.columns.12.namestring
"clientId"
tables.14.columns.12.typestring
"VARCHAR (255)"
tables.14.columns.13.namestring
"keepAlive"
tables.14.columns.13.typestring
"INT"
tables.14.columns.14.namestring
"cleanSession"
tables.14.columns.14.typestring
"BOOLEAN"
tables.14.columns.15.namestring
"allowRetained"
tables.14.columns.15.typestring
"BOOLEAN"
tables.14.columns.16.namestring
"tryPrivate"
tables.14.columns.16.typestring
"BOOLEAN"
tables.14.columns.17.namestring
"subTopics"
tables.14.columns.17.typestring
"VARCHAR"
tables.14.columns.18.namestring
"pubTopics"
tables.14.columns.18.typestring
"VARCHAR"
tables.14.columns.19.namestring
"useTls"
tables.14.columns.19.typestring
"BOOLEAN"
tables.14.columns.20.namestring
"enabled"
tables.14.columns.20.typestring
"BOOLEAN"
tables.15.namestring
"authsources"
tables.15.keys.1string
"authsource"
tables.15.columns.1.namestring
"id"
tables.15.columns.1.typestring
"INT IDENTITY(1,1)"
tables.15.columns.1.isPrimaryboolean
B"true"
tables.15.columns.2.namestring
"name"
tables.15.columns.2.typestring
"VARCHAR (255)"
tables.15.columns.2.isIdboolean
B"true"
tables.15.columns.3.namestring
"meta_createdBy"
tables.15.columns.3.typestring
"VARCHAR (255)"
tables.15.columns.4.namestring
"meta_createdOn"
tables.15.columns.4.typestring
"BIGINT"
tables.15.columns.5.namestring
"meta_modifiedBy"
tables.15.columns.5.typestring
"VARCHAR (255)"
tables.15.columns.6.namestring
"meta_modifiedOn"
tables.15.columns.6.typestring
"BIGINT"
tables.15.columns.7.namestring
"accountId"
tables.15.columns.7.typestring
"VARCHAR (255)"
tables.15.columns.8.namestring
"sourceType"
tables.15.columns.8.typestring
"VARCHAR"
tables.15.columns.9.namestring
"enabled"
tables.15.columns.9.typestring
"BOOLEAN"
tables.15.columns.10.namestring
"host"
tables.15.columns.10.typestring
"VARCHAR"
tables.15.columns.11.namestring
"port"
tables.15.columns.11.typestring
"VARCHAR"
tables.15.columns.12.namestring
"useTls"
tables.15.columns.12.typestring
"BOOLEAN"
tables.15.columns.13.namestring
"sysUsername"
tables.15.columns.13.typestring
"VARCHAR"
tables.15.columns.14.namestring
"sysPassword"
tables.15.columns.14.typestring
"VARCHAR"
tables.15.columns.14.isEncryptedstring
B"true"
tables.15.columns.15.namestring
"referral"
tables.15.columns.15.typestring
"VARCHAR"
tables.15.columns.16.namestring
"connectTimeout"
tables.15.columns.16.typestring
"INT"
tables.15.columns.17.namestring
"readTimeout"
tables.15.columns.17.typestring
"INT"
tables.15.columns.18.namestring
"userDnTemplate"
tables.15.columns.18.typestring
"VARCHAR"
tables.15.columns.19.namestring
"groupSearchBase"
tables.15.columns.19.typestring
"VARCHAR"
tables.15.columns.20.namestring
"groupSearchFilter"
tables.15.columns.20.typestring
"VARCHAR"
tables.15.columns.21.namestring
"groupNameAttribute"
tables.15.columns.21.typestring
"VARCHAR"
tables.15.columns.22.namestring
"groupToRoleMapping"
tables.15.columns.22.typestring
"VARCHAR"
tables.15.columns.23.namestring
"userSearchBase"
tables.15.columns.23.typestring
"VARCHAR"
tables.15.columns.24.namestring
"userSearchFilter"
tables.15.columns.24.typestring
"VARCHAR"
tables.15.columns.25.namestring
"userListFilter"
tables.15.columns.25.typestring
"VARCHAR"
tables.15.columns.26.namestring
"userNameAttribute"
tables.15.columns.26.typestring
"VARCHAR"
tables.15.columns.27.namestring
"userFullNameAttribute"
tables.15.columns.27.typestring
"VARCHAR"
tables.15.columns.28.namestring
"userGroupAttribute"
tables.15.columns.28.typestring
"VARCHAR"
tables.15.columns.29.namestring
"cacheTimeout"
tables.15.columns.29.typestring
"INT"
tables.15.columns.30.namestring
"enableCache"
tables.15.columns.30.typestring
"BOOLEAN"
tables.15.columns.31.namestring
"domain"
tables.15.columns.31.typestring
"VARCHAR"
tables.15.columns.32.namestring
"autoSuffix"
tables.15.columns.32.typestring
"BOOLEAN"
tables.15.columns.33.namestring
"usernameSuffix"
tables.15.columns.33.typestring
"VARCHAR"
tables.15.columns.34.namestring
"usernamePrefix"
tables.15.columns.34.typestring
"VARCHAR"
tables.15.columns.35.namestring
"systemSuffixPrefix"
tables.15.columns.35.typestring
"BOOLEAN"
tables.16.namestring
"mqttauthconfigs"
tables.16.keys.1string
"mqttauthconfig"
tables.16.columns.1.namestring
"id"
tables.16.columns.1.typestring
"INT IDENTITY(1,1)"
tables.16.columns.1.isPrimaryboolean
"B"true"
tables.16.columns.2.namestring
"name"
tables.16.columns.2.typestring
"VARCHAR (255)"
tables.16.columns.2.isIdboolean
B"true"
tables.16.columns.3.namestring
"meta_createdBy"
tables.16.columns.3.typestring
"VARCHAR (255)"
tables.16.columns.4.namestring
"meta_createdOn"
tables.16.columns.4.typestring
"BIGINT"
tables.16.columns.5.namestring
"meta_modifiedBy"
tables.16.columns.5.typestring
"VARCHAR (255)"
tables.16.columns.6.namestring
"meta_modifiedOn"
tables.16.columns.6.typestring
"BIGINT"
tables.16.columns.7.namestring
"accountId"
tables.16.columns.7.typestring
"VARCHAR (255)"
tables.16.columns.8.namestring
"sourceType"
tables.16.columns.8.typestring
"VARCHAR"
tables.16.columns.9.namestring
"enabled"
tables.16.columns.9.typestring
"BOOLEAN"
tables.16.columns.10.namestring
"host"
tables.16.columns.10.typestring
"VARCHAR"
tables.16.columns.11.namestring
"port"
tables.16.columns.11.typestring
"VARCHAR"
tables.16.columns.12.namestring
"useTls"
tables.16.columns.12.typestring
"BOOLEAN"
tables.16.columns.13.namestring
"sysUsername"
tables.16.columns.13.typestring
"VARCHAR"
tables.16.columns.14.namestring
"sysPassword"
tables.16.columns.14.typestring
"VARCHAR"
tables.16.columns.14.isEncryptedstring
B"true"
tables.16.columns.15.namestring
"referral"
tables.16.columns.15.typestring
"VARCHAR"
tables.16.columns.16.namestring
"connectTimeout"
tables.16.columns.16.typestring
"INT"
tables.16.columns.17.namestring
"readTimeout"
tables.16.columns.17.typestring
"INT"
tables.16.columns.18.namestring
"baseDn"
tables.16.columns.18.typestring
"VARCHAR"
tables.16.columns.19.namestring
"usernameAttributeName"
tables.16.columns.19.typestring
"VARCHAR"
tables.16.columns.20.namestring
"pubTopicAttributeName"
tables.16.columns.20.typestring
"VARCHAR"
tables.16.columns.21.namestring
"subTopicAttributeName"
tables.16.columns.21.typestring
"VARCHAR"
tables.16.columns.22.namestring
"credentialObjectClassName"
tables.16.columns.22.typestring
"VARCHAR"
tables.16.columns.23.namestring
"aclCheckInterval"
tables.16.columns.23.typestring
"BIGINT"
tables.16.columns.24.namestring
"cacheTimeout"
tables.16.columns.24.typestring
"INT"
tables.16.columns.25.namestring
"enableCache"
tables.16.columns.25.typestring
"BOOLEAN"
tables.16.columns.26.namestring
"domain"
tables.16.columns.26.typestring
"VARCHAR"
tables.16.columns.27.namestring
"autoSuffix"
tables.16.columns.27.typestring
"BOOLEAN"
tables.16.columns.28.namestring
"usernameSuffix"
tables.16.columns.28.typestring
"VARCHAR"
tables.16.columns.29.namestring
"usernamePrefix"
tables.16.columns.29.typestring
"VARCHAR"
tables.16.columns.30.namestring
"systemSuffixPrefix"
tables.16.columns.30.typestring
"BOOLEAN"
tables.17.namestring
"clientprofiles"
tables.17.keys.1string
"clientprofile"
tables.17.columns.1.namestring
"id"
tables.17.columns.1.typestring
"INT IDENTITY(1,1)"
tables.17.columns.1.isPrimaryboolean
B"true"
tables.17.columns.2.namestring
"name"
tables.17.columns.2.typestring
"VARCHAR (255)"
tables.17.columns.2.isIdboolean
B"true"
tables.17.columns.3.namestring
"meta_createdBy"
tables.17.columns.3.typestring
"VARCHAR (255)"
tables.17.columns.4.namestring
"meta_createdOn"
tables.17.columns.4.typestring
"BIGINT"
tables.17.columns.5.namestring
"meta_modifiedBy"
tables.17.columns.5.typestring
"VARCHAR (255)"
tables.17.columns.6.namestring
"meta_modifiedOn"
tables.17.columns.6.typestring
"BIGINT"
tables.17.columns.7.namestring
"accountId"
tables.17.columns.7.typestring
"VARCHAR (255)"
tables.17.columns.8.namestring
"username"
tables.17.columns.8.typestring
"VARCHAR (255)"
tables.17.columns.9.namestring
"password"
tables.17.columns.9.typestring
"VARCHAR (255)"
tables.17.columns.10.namestring
"address"
tables.17.columns.10.typestring
"VARCHAR (255)"
tables.17.columns.11.namestring
"port"
tables.17.columns.11.typestring
"INT"
tables.17.columns.12.namestring
"clientId"
tables.17.columns.12.typestring
"VARCHAR (255)"
tables.17.columns.13.namestring
"keepAlive"
tables.17.columns.13.typestring
"INT"
tables.17.columns.14.namestring
"cleanSession"
tables.17.columns.14.typestring
"BOOLEAN"
tables.17.columns.15.namestring
"useTls"
tables.17.columns.15.typestring
"BOOLEAN"
tables.17.columns.16.namestring
"lwtFlag"
tables.17.columns.16.typestring
"BOOLEAN"
tables.17.columns.17.namestring
"lwtTopic"
tables.17.columns.17.typestring
"VARCHAR (255)"
tables.17.columns.18.namestring
"lwtPayload"
tables.17.columns.18.typestring
"VARCHAR"
tables.17.columns.19.namestring
"lwtQos"
tables.17.columns.19.typestring
"INT"
tables.17.columns.20.namestring
"subscribeTopics"
tables.17.columns.20.typestring
"VARCHAR"
tables.17.columns.21.namestring
"autoSubscribe"
tables.17.columns.21.typestring
"BOOLEAN"
  • No labels

New to MQTT? Start Here!