Table tig_ma_msgs

Table stores archived messages.

Field Description Comments

msg_id

Database ID of a message

 

owner_id

ID of a bare JID of a message owner

References jid_id from tig_ma_jids

buddy_id

ID of a bare JID of a message recipient/sender (different than owner)

References jid_id from tig_ma_jids

buddy_res

Resource part of a message recipient/sender JID

 

ts

Timestamp of a message

Timestamp of archivization or delayed delivery

direction

Direction of message

0 - sent by owner

1 - received by owner

type

Message type

Value of message type attribute

body

Body of a message

 

msg

Serialized message

 

stanza_hash

Hash of message parts

It is used to make sure that message is stored only once