updates
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| name | varchar(200) | PRI | NO | filename with extension of the update. | |||
| hash | char(40) | YES | '' | sha1 hash of the sql file. | |||
| state | enum( 'RELEASED', 'ARCHIVED') | NO | RELEASED | defines if an update is released or archived. | |||
| timestamp | timestamp | NO | CURRENT_TIMESTAMP | DEFAULT_GENERATED | timestamp when the query was applied. | ||
| speed | int | unsigned | NO | 0 | time the query takes to apply in ms. | ||
Description of fields
name
Filename with extension of the update
hash
SHA1 hash of the sql file
state
Defines if an update is released or archived. Archived means its part of TDB.
timestamp
Timestamp when the query was applied
speed
Time the query took to apply in ms
