Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ComputerID | INT | 10 | null |
|
|
|||
| HotFixID | VARCHAR | 40 | null |
|
|
|||
| Installed | INT | 10 | null |
|
|
|||
| Approved | INT | 10 | null |
|
|
|||
| Pushed | INT | 10 | null |
|
|
|||
| Last_Date | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
|||
| InstallDate | DATETIME | 19 | null |
|
|
|||
| Failed | INT | 10 | null |
|
|
|||
| Success | INT | 10 | null |
|
|
|||
| QueuedDate | DATETIME | 19 | null |
|
|
|||
| FinishedDate | DATETIME | 19 | null |
|
|
|||
| CmdID | INT | 10 | null |
|
|
|||
| InstallType | INT | 10 | null |
|
|
|||
| OS | VARCHAR | 100 | null |
|
|
|||
| Stage | INT | 10 | null |
|
|
|||
| Version | VARCHAR | 100 | null |
|
|
|||
| Action | INT | 10 | -1 |
|
|
|||
| InstalledVersion | VARCHAR | 100 | null |
|
|
|||
| CvssScore | DOUBLE | 22 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | HotFixID + ComputerID |
| Approved | Performance | Asc | Approved |
| Computer_idx | Performance | Asc | ComputerID |
| Installed | Performance | Asc | Installed |
| Pushed | Performance | Asc | Pushed |
Diagram producer might be missing
No diagrams were produced please see application output for any errors