Tigase Message Archiving component uses few tables and stored procedures. To make it easier to find them on database level they are prefixed with tig_ma_.
This table stores all jids related to stored messages, ie. from to and from attributes of archived stanzas.
| Field | Description | Comments |
|---|---|---|
jid_id | Database ID of a JID | |
jid | Value of a bare JID | |
jid_sha1 | SHA1 value of lowercased bare JID | Used for proper bare JID comparison during lookup. (N/A to PostgreSQL schema) |
domain | Domain part of a bare JID | Stored for easier lookup of messages owned by users of a particular domain |
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 |
buddy_id | ID of a bare JID of a message recipient/sender (different than owner) | References |
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 |
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 |
Table stores tags of archived messages. It stores one tag for many messages using tig_ma_msgs_tags to store relation between tag and a message.
| Field | Description | Comments |
|---|---|---|
tag_id | Database ID of a tag | |
owner_id | ID of a bare JID of a tag owner | ID of bare JID of owner for which messages with this tag were archived |
tag | Actual tag value |