You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

NEEDS TABLE 13 THROUGH 17 ADDED

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"
  • No labels

New to MQTT? Start Here!