Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
ClientID | INT | 10 | 0 |
|
|
|||||
LocationID | INT | 10 | 0 |
|
|
|||||
ComputerID | INT | 10 | 0 |
|
|
|||||
HotfixID | VARCHAR | 40 | null |
|
|
|||||
HotfixTitle | VARCHAR | 255 | null |
|
|
|||||
HotfixKB | VARCHAR | 30 | null |
|
|
|||||
HotfixBulletin | VARCHAR | 255 | null |
|
|
|||||
HotfixDescription | VARCHAR | 1024 | null |
|
|
|||||
HotfixDateAdded | DATETIME | 19 | null |
|
|
|||||
HotfixCategory | VARCHAR | 255 | null |
|
|
|||||
HotfixSeverity | VARCHAR | 50 |
|
|
||||||
HotfixPatchType | VARCHAR | 25 | null |
|
|
|||||
HotfixOS | VARCHAR | 100 | null |
|
|
|||||
HotfixIgnore | INT | 10 | null |
|
|
|||||
HotfixApproved | INT | 10 | null |
|
|
|||||
HotfixPushed | INT | 10 | null |
|
|
|||||
HotfixInstalled | INT | 10 | null |
|
|
|||||
HotfixFailed | INT | 10 | null |
|
|
|||||
HotfixInstallDate | DATETIME | 19 | null |
|
|
|||||
HotfixFinishedDate | DATETIME | 19 | null |
|
|