Table tig_ma_msgs

Table stores archived events.

Field Description Comments

msg_id

Database ID of a event

  

owner_id

ID of a bare JID of a event owner

References jid_id from tig_ma_jids

buddy_id

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

References jid_id from tig_ma_jids

buddy_res

Resource part of a event recipient/sender JID

  

ts

Timestamp of a event

Timestamp of archivization or delayed delivery

direction

Direction of event

0 - sent by owner

1 - recevied by owner

type

Stanza type

Value of message type attribute

body

Body of a message

  

msg

Serialized event

  

stanza_hash

Hash of event parts

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

item-type

Event type

May be one of: chat, call, login, logout. (Added in UA schema)

offline

Marks offline events

It is set to 1 when it stores offline event, not yet delivered to client
Prev  Up  Next
  Home