Table: ServerAction

Server actions are a integral part of the internal communications between Scout Enterprise components. Table entries should never be manually added, removed or changed.

ColumnName DataType Key Not Null Default Value Comment
ServerActionID INTEGER IDENTITY(1,1) PK NN   Unique ID of server action entry
Type INTEGER   NN    
ServerID INTEGER (FK) NN   Target server of the action 
Refers to EntityID of table Entity
StartTime INTEGER   NN    
MemberType INTEGER        
MemberID INTEGER        
RequestingConsole INTEGER        
StringParameter NVARCHAR(255)        
IntParameter INTEGER        
StringParameter2 NVARCHAR(255)        
IntParameter2 INTEGER        
StringParameter3 NVARCHAR(255)        
IntParameter3 INTEGER        
StringParameter4 NVARCHAR(255)        
IntParameter4 INTEGER        
StringParameter5 NVARCHAR(255)        
IntParameter5 INTEGER        
LongStringParameter NVARCHAR(max)        
ReservedString1 NVARCHAR(255)        
ReservedString2 NVARCHAR(255)        
ReservedInt1 INTEGER        
ReservedInt2 INTEGER        
IndexName IndexType Columns
PRIMARY PRIMARY ServerActionID

 

how to create

CREATE TABLE ServerAction(
ServerActionID INTEGER NOT NULL,
Type INTEGER NOT NULL,
ServerID INTEGER,
StartTime INTEGER NOT NULL,
MemberType INTEGER,
MemberID INTEGER,
RequestingConsole INTEGER,
StringParameter NVARCHAR(255),
IntParameter INTEGER,
StringParameter2 NVARCHAR(255),
IntParameter2 INTEGER,
StringParameter3 NVARCHAR(255),
IntParameter3 INTEGER,
StringParameter4 NVARCHAR(255),
IntParameter4 INTEGER,
StringParameter5 NVARCHAR(255),
IntParameter5 INTEGER,
LongStringParameter NVARCHAR(max),
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
PRIMARY KEY (ServerActionID));