|
This table is used only for QAnywhere applications. It contains messages that are to be sent to a QAnywhere client using SQL Anywhere version 9.0.1.
| Caution
Do not alter this table. |
| Column |
Description |
|---|---|
|
seqno | BIGINT. Used to give a total ordering to the messages, this is necessary for true queuing. |
| msgid |
VARCHAR(255). Primary key. Globally unique message identifier. |
| destination | VARCHAR(128). The address of the message. |
| originator | VARCHAR(128). The name of the originating MobiLink user. |
| status | VARCHAR(128). The status of the message. Can be pending, receiving, received, unreceivable, expired, or cancelled. The default is pending. |
| statustime | TIMESTAMP. The last time the status was changed. |
| expires | TIMESTAMP. Expiry time after which the message will not be delivered. |
| priority | INTEGER. A number from 0 to 9. Messages with a higher number will always be delivered before messages with a lower number. The default is 4. |
| props | LONG BINARY. An encoding of the message properties. |
| kind | INTEGER. Indicates whether the message is binary (1) or text (2). |
| content | LONG BINARY. The content of the message. Text messages are encoded as UTF-8. |
| 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. |
| mluser | VARCHAR(128). The MobiLink user name that uniquely identifies a remote database. |