CREATE TABLE MshMessaging (
MsCtxId CHAR (63) PRIMARY KEY IN RDMSGIDX,
MsDefId MVARCHAR (127) NOT NULL,
CpaId MVARCHAR (63) NOT NULL,
Service MVARCHAR (255) NOT NULL,
SType MVARCHAR (255),
MsAct MVARCHAR (255) NOT NULL,
MsRole MVARCHAR (255),
MsType INTEGER NOT NULL,
Sender MVARCHAR (63),
Receiver MVARCHAR (63),
ConvId MVARCHAR (255) NOT NULL,
MsgId MVARCHAR (255) NOT NULL,
StateC INTEGER NOT NULL,
Suspended CHAR (1) NOT NULL,
CreationD CHAR (24) NOT NULL,
TimeToLive CHAR (24),
CompD CHAR (24),
ClosedD CHAR (24),
PersistD CHAR (24),
Security INTEGER,
QoS INTEGER,
ErrC INTEGER,
ErrDesc MVARCHAR (1023),
ErrDescLang MVARCHAR (31),
RetryCnt INTEGER,
SeqNum INTEGER,
RefTo MVARCHAR (255),
ApTimerRef CHAR (63),
SendTimerRef CHAR (63),
MsgSize INTEGER,
MsgNum INTEGER,
CntType CHAR (255),
PlName MVARCHAR (4096),
SigRef MVARCHAR (255),
SigSize INTEGER,
SigNum INTEGER,
SigCntType CHAR (255),
SlotNum INTEGER,
OdrState INTEGER,
IsReset CHAR (1)
) IN RDMSGTBL;
CREATE UNIQUE INDEX MshStatusIdx ON MshMessaging (
MsDefId, MsgId
) IN RDMSGIDX2;
CREATE INDEX MshReferenceIdx ON MshMessaging (
CompD, StateC, Service, MsAct
) IN RDMSGIDX3; |