CREATE TABLE HSRSMessageArchive (
SenderId MVARCHAR(63) NOT NULL,
ReceiverId MVARCHAR(63) NOT NULL,
MessageId MVARCHAR(255) NOT NULL,
DocumentData BLOB(1468007) IN RDHSRSMALOB NOT NULL,
FormatType MVARCHAR(255) NOT NULL,
DocumentType MVARCHAR(255) NOT NULL,
CompressType MVARCHAR(63) NOT NULL,
DocumentState INTEGER NOT NULL WITH DEFAULT,
ReceiveDate TIMESTAMP NOT NULL,
ReceiveCompleteDate TIMESTAMP
) IN RDHSRSMA; |