Table: PredefinedCommandTemplates

Data for command preferences (for standard commands)

ColumnName DataType Key Not Null Default Value Comment
CommandID INTEGER PK NN   Unique ID of the command
1Shutdown
3Restart
5Update
8Factory reset
10Delivery
 
Policies INTEGER   NN 0 Values for preferences, can be combined by OR:
0x8Inform user
0x100Format before update
0x200Run as root
0x800Enable this template
0x1000Template is mandatory
0x2000User can cancel
InformInSeconds INTEGER   NN 0 Number of seconds to show the command message
IndexName IndexType Columns
PRIMARY PRIMARY CommandID

 

how to create

CREATE TABLE PredefinedCommandTemplates(
CommandID INTEGER NOT NULL,
Policies INTEGER NOT NULL DEFAULT 0,
InformInSeconds INTEGER NOT NULL DEFAULT 0,
CONSTRAINT PK_PredefinedCommandTemplates
PRIMARY KEY (CommandID));

how to initialize

INSERT INTO PredefinedCommandTemplates (CommandID) VALUES (1);
INSERT INTO PredefinedCommandTemplates (CommandID) VALUES (3);
INSERT INTO PredefinedCommandTemplates (CommandID) VALUES (5);
INSERT INTO PredefinedCommandTemplates (CommandID) VALUES (8);
INSERT INTO PredefinedCommandTemplates (CommandID) VALUES (10);