updates

This table contains sql updates already applied by the UpdateFetcher.

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

The filename with extension of the update.
 

hash

SHA1 hash of the query.
 

state

Defines if an update is released or archived.
 

timestamp

Timestamp when the query was applied.
 

speed

Time the query took to apply in ms.