Tigase Message Archiving component uses few tables and stored procedures. To make it easier to find them on database level they are prefixed with
This table stores all jids related to stored messages, ie. from
from attributes of archived stanzas.
Database ID of a JID
Value of a bare JID
SHA1 value of lowercased bare JID
Used for proper bare JID comparison during lookup.
(N/A to PostgreSQL schema)
Domain part of a bare JID
Stored for easier lookup of messages owned by users of a particular domain
Table stores archived messages.
Database ID of a message
ID of a bare JID of a message owner
ID of a bare JID of a message recipient/sender (different than owner)
Resource part of a message recipient/sender JID
Timestamp of a message
Timestamp of archivization or delayed delivery
Direction of message
0 - sent by owner
1 - received by owner
Value of message
Body of a message
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.
Database ID of a tag
ID of a bare JID of a tag owner
ID of bare JID of owner for which messages with this tag were archived
Actual tag value