Page History
...
| 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" |
Overview
Content Tools