Tigase Unified Archive component uses few tables and stored procedures and it shares same tables with Tigase Message Archiving component - in fact it uses same tables with addition of few fields.
Due to that used tables are prefixed with
tig_ma_, but used stored procedures are prefixed with
This table stores all jids related to stored messages and events, 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.
(Not exists in PostgreSQL schema)
Domain part of a bare JID
Stored for easier lookup of messages owned by users of a particular domain
Table stores archived events.
Database ID of a event
ID of a bare JID of a event owner
ID of a bare JID of a event recipient/sender (different than owner)
Resource part of a event recipient/sender JID
Timestamp of a event
Timestamp of archivization or delayed delivery
Direction of event
0 - sent by owner
1 - recevied by owner
Value of message
Body of a message
Hash of event parts
It is used to make sure that event is stored only once
May be one of:
Marks offline events
It is set to 1 when it stores offline event, not yet delivered to client
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