Scout Database Model (CR)

Table: PredefinedCommandTemplates

March 25, 2025

Contributed by:

Data for command preferences (for standard commands)

ColumnName	DataType	Key	Not Null	Default Value	Comment
CommandID	INTEGER	PK	NN		Unique ID of the command
					1 - Shutdown
					3 - Restart
					5 - Update
					8 - Factory reset
					10 - Delivery
Policies	INTEGER		NN	0	Values for preferences, can be combined by OR
					0x8 - Inform user
					0x100 - Format before update
					0x200 - Run as root
					0x800 - Enable this template
					0x1000 - Template is mandatory
					0x2000 - User 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);
 

The official version of this content is in English. Some of the Cloud Software Group documentation content is machine translated for your convenience only. Cloud Software Group has no control over machine-translated content, which may contain errors, inaccuracies or unsuitable language. No warranty of any kind, either expressed or implied, is made as to the accuracy, reliability, suitability, or correctness of any translations made from the English original into any other language, or that your Cloud Software Group product or service conforms to any machine translated content, and any warranty provided under the applicable end user license agreement or terms of service, or any other agreement with Cloud Software Group, that the product or service conforms with any documentation shall not apply to the extent that such documentation has been machine translated. Cloud Software Group will not be held responsible for any damage or issues that may arise from using machine-translated content.

Was this helpful

Table: PredefinedCommandTemplates

March 25, 2025

Contributed by:

Table: PredefinedCommandTemplates

How to create

How to initialize

In this article