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_OKUpdate successful
1 ~_E_UNKNOWNUpdate failed due to unspecified reason
2 ~_UPTODATEUpdate not necessary, client up to date
3 ~_INPROGRESSUpdate still in progress
256 ~_E_GENERALUpdate failed, error unknown
257 ~_E_FIRMPARAMUpdate failed, bad firmware parameter
258~_E_AUTHUpdate failed, authorization failed
259 ~_E_FLASHSIZEUpdate failed, unsufficient flash size
260~_E_CONTAINERUpdate failed, container mismatch
261 ~_E_UNREACHEDUpdate failed, client unreachable
262 ~_E_TIMEOUTUpdate 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));