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