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