This table is used only for QAnywhere applications.
Do not alter this table.
|msgid||VARCHAR(128). Globally unique message identifier.|
|seqno||BIGINT. Used to give an ordering to the messages, which is necessary for true queuing.|
|address||VARCHAR(255). Address of the target recipient.|
|clientaddress||VARCHAR(128). Client part of the address.|
|client||VARCHAR(128). Client targeted by current client state.|
|originator||VARCHAR(128). The name of the originating client.|
|priority||INTEGER. A number from 0 to 9. Messages with a higher priority number are delivered before messages with a lower priority. The default is 4.|
|expires||TIMESTAMP . Expiry time after which the message might not be delivered.|
|kind||INTEGER. Indicates whether the message is binary (1) or text (2).|
|contentsize||BIGINT. The size of the message. For binary messages, this is the number of bytes. For text messages, this is the number of characters.|
|status||INTEGER. The status of the message. Can be 1 (pending), 10 (receiving), 30 (expired), 40 (cancelled), 50 (unreceivable), or 60 (received).|
|statustime||TIMESTAMP. The time this status was achieved. The time is local to the client achieving the state.|
|syncstatus||INTEGER. Indicates the state of the synchronization between the client and server with respect to this message. Can be 0 (not in sync), 1 (in sync), 2 (message should not be synchronized), or 3 (synchronizing).|
|receiverid||VARCHAR(128). An identifier set by the receiver that identifies the receiver of the message, if any.|