Table: Firmware

Each entry is referred from the Setup table and holds a set of parameters for firmware update purposes.

ColumnName	DataType	Key	Not Null	Default Value	Comment
FirmwareID	INTEGER	PK	NN		Unique ID of firmware settings
ServerID	INTEGER	FK			Server ID Foreign key refers to table Server.ServerID
ProxyPort	INTEGER				Port to connect proxy server
Protocol	SMALLINT(6)				Protocol used for firmware update: 0 HTTP  1 FTP  HTTPS   FTPS
ProxyType	SMALLINT(6)		NN	0	None | Static (Consumer) | Static (Provider) | Dynamic
Path	NVARCHAR(255)				Path where the image files (IDF) can be found
Username	NVARCHAR(255)				Username to logon to update server
Pass	NVARCHAR(255)				Encrypted password to logon to update server
ProxyServerID	INTEGER	FK	NN		Server for VPN connections
ServerForVPN	NVARCHAR(255)				Encrypted password to logon to update server
AutoCheckUpdate	SMALLINT(6)			0	Check for update on system start 0|1
ConfirmUpdate	SMALLINT(6)			1	Update must be confirmed by user 0|1
CheckUpdateOnShutdown	SMALLINT(6)			0	Check for firmware update on client shutdown 0|1
MaxDeferments	INTEGER			0	Number of possible deferments 0 to 3
DefermentTimes	NVARCHAR(255)			15	Selected deferment periods: 15, 30, 60, 120, 240, 480 Example: Enter 60, 120 to allow both deferment periods on the client
SecurityOptions	INTEGER
BIOSFileName	NVARCHAR(255)				Name of .udf file for UEFI updates
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER

IndexName	IndexType	Colulmns
PRIMARY	PRIMARY	FirmwareID

 

how to create

CREATE TABLE Firmware(
FirmwareID INTEGER NOT NULL;
ServerID INTEGER;
ProxyPort INTEGER;
ServerForVPN NVARCHAR(255);
Protocol SMALLINT;
ProxyType SMALLINT NOT NULL;
Path NVARCHAR(255);
Username NVARCHAR(255);
Pass NVARCHAR(255);
ProxyServerID INTEGER;
AutoCheckUpdate SMALLINT NOT NULL;
ConfirmUpdate SMALLINT NOT NULL;
CheckUpdateOnShutdown SMALLINT;
MaxDeferments INTEGER;
DefermentTimes NVARCHAR(255);
SecurityOptions INTEGER;
ReservedString1 NVARCHAR(255);
ReservedString2 NVARCHAR(255);
ReservedInt1 INTEGER;
ReservedInt2 INTEGER;
BIOSFileName NVARCHAR(255);
CONSTRAINT FK_Firmware_ServerID_Server_ServerID FOREIGN KEY (ServerID) REFERENCES Server (ServerID);
CONSTRAINT FK_Firmware_ProxyServerID_Server_ServerID FOREIGN KEY (ProxyServerID) REFERENCES Server (ServerID);
PRIMARY KEY (FirmwareID));