Table: IccMessageParam

This table contains all  messages which may be sent from one to another console

ColumnName DataType Key Not Null Default Value Comment
IccMessageParam INTEGER PK NN    
DisplayTime INTEGER        
CanCancel SMALLINT        
MsgText1 NVARCHAR(255)        
MsgText2 NVARCHAR(255)        
MsgText3 NVARCHAR(255)        
MsgText4 NVARCHAR(255)        
IndexName IndexType Columns
PRIMARY PRIMARY IccMessageParam

 

how to create

CREATE TABLE IccMessageParam(
IccMessageParamID INTEGER NOT NULL,
DisplayTime INTEGER,
CanCancel SMALLINT,
MsgText1 NVARCHAR(255),
MsgText2 NVARCHAR(255),
MsgText3 NVARCHAR(255),
MsgText4 NVARCHAR(255),
PRIMARY KEY (IccMessageParamID));