Versions Compared

Old Version 5

changes.mady.by.user Gill Houghton

Saved on

compared with

New Version 6

changes.mady.by.user Gill Houghton

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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"
Need tables 6 through 17 added