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
|
|||||||||||||
Policies | INTEGER | NN | 0 | Values for preferences, can be combined by OR:
|
|||||||||||||
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);