Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
MajorVersion | INT | 10 | 0 |
|
|
|||
MinorVersion | INT | 10 | 0 |
|
|
|||
DownloadURL | VARCHAR | 100 |
|
|
||||
RedirHostName | VARCHAR | 50 |
|
|
||||
RedirPort | INT | 10 | 0 |
|
|
|||
RedirPasscode | INT | 10 | null |
|
|
|||
UpdateName | VARCHAR | 50 |
|
|
||||
SystemPassword | VARCHAR | 16 | null |
|
|
|||
OldSystemPassword | VARCHAR | 16 | null |
|
|
|||
VARCHAR | 50 | null |
|
|
||||
VARCHAR | 50 | null |
|
|
||||
License | VARCHAR | 5000 | null |
|
|
|||
VerifierData | VARCHAR | 200 | null |
|
|
|||
LastUpdate | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
|||
AgentIP | VARCHAR | 30 | null |
|
|
|||
DynamicClients | INT | 10 | null |
|
|
|||
MailServer | VARCHAR | 50 | null |
|
|
|||
MailUser | VARCHAR | 50 | null |
|
|
|||
mailpass | VARCHAR | 255 | null |
|
|
|||
SubjectFilter | VARCHAR | 200 | null |
|
|
|||
SupportEmail | VARCHAR | 100 | null |
|
|
|||
SupportMessage | VARCHAR | 1024 | null |
|
|
|||
SiteName | VARCHAR | 50 | null |
|
|
|||
ClientVersion | INT | 10 | null |
|
|
|||
FinishMessage | VARCHAR | 1024 | null |
|
|
|||
VARCHAR | 1024 | null |
|
|
||||
DynamicPhones | INT | 10 | null |
|
|
|||
DynamicTablets | INT | 10 | null |
|
|
|||
InstalledFeatures | INT | 10 | null |
|
|
|||
AdditionalPackages | INT | 10 | null |
|
|
|||
IgniteVersion | DECIMAL | 10,3 | null |
|
|
|||
ProductVersion1 | DECIMAL | 10,3 | null |
|
|
|||
ProductVersion2 | DECIMAL | 10,3 | null |
|
|
|||
ProductVersion3 | DECIMAL | 10,3 | null |
|
|
|||
ProductVersion4 | DECIMAL | 10,3 | null |
|
|
|||
LinuxClientVersion | VARCHAR | 10 | null |
|
|
|||
MacClientVersion | VARCHAR | 10 | null |
|
|
|||
UnderAssurance | INT | 10 | null |
|
|
|||
ReplicationDb | VARCHAR | 512 | null |
|
|
|||
Maintenance | VARCHAR | 5000 | Not Set |
|
|
|||
AccountFlags | INT | 10 | 0 |
|
|
|||
ServerId | VARCHAR | 255 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc/Asc | MajorVersion + MinorVersion |
Diagram producer might be missing
No diagrams were produced please see application output for any errors