Table: UpdateResult

Each entry represents an firmware update result (including complete update log file) according to an device specified by MAC address.

ColumnName	DataType	Key	Not Null	Default Value	Comment
UpdateResultID	INTEGER	PK	NN		Unique ID of update result
TimeReceived	INTEGER		NN		Entry timestamp (Unix time)
Mac	NVARCHAR(12)		NN		Client MAC address
ClientIdentifier	UNIQUEIDENTIFIER		NN		Unique identifier for client devices and eLux portable sticks
IntResult	INTEGER				Result of last update 0 UPD_DEVRESULT_OK Update successful 1 ~_E_UNKNOWN Update failed due to unspecified reason 2 ~_UPTODATE Update not necessary, client up to date 3 ~_INPROGRESS Update still in progress 256 ~_E_GENERAL Update failed, error unknown 257 ~_E_FIRMPARAM Update failed, bad firmware parameter 258 ~_E_AUTH Update failed, authorization failed 259 ~_E_FLASHSIZE Update failed, unsufficient flash size 260 ~_E_CONTAINER Update failed, container mismatch 261 ~_E_UNREACHED Update failed, client unreachable 262 ~_E_TIMEOUT Update failed, no answer from client
TextResult	NVARCHAR(max)				Update log file received from client
CommandType	INTEGER			0	0: Update 1: Custom command
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER

IndexName	IndexType	Columns
PRIMARY	PRIMARY	UpdateResultID

 

How to create

CREATE TABLE UpdateResult(
UpdateResultID INTEGER NOT NULL,
TimeReceived INTEGER NOT NULL,
Mac NVARCHAR(12) NOT NULL,
ClientIdentifier UNIQUEIDENTIFIER NOT NULL,
IntResult INTEGER,
TextResult NVARCHAR(max),
CommandType INTEGER,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
CONSTRAINT PK_UpdateResult
PRIMARY KEY (UpdateResultID));