updates

<-Back-to:Auth<-Back-to:Characters<-Back-to:World

The `updates` table

table-no-description

Table 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,CUSTOM,ARCHIVED		NO	RELEASED		Defines if an update is released, custom or archived.
timestamp	TIMESTAMP			NO	CURRENT_TIMESTAMP		Timestamp when the query was applied.
speed	INT	UNSIGNED		NO	0		Time the query takes to apply in ms.

Description of the fields

name

The filename of the imported file.

hash

The SHA1 hash from the imported file.

state

Defines if the update is released, custom or archived.

timestamp

The time that the file was imported.

speed

How long in ms it took to import the file.