This description contains only basic description of schema and only basic part of it. More collections may be created if additional components of Tigase XMPP Server are loaded and configured to use MongoDB.
Basic schema for UserRespository and AuthRepository consists of two collections: . tig_users - contains list of users . tig_nodes - contains data related to users in tree-like way
tig_users
collection contains the following fields:
Table 7. tig_users
Name | Description |
---|---|
_id |
id of user which is SHA256 hash of users jid (raw byte array). |
user_id |
contains full user jid. |
domain |
domain to which user belongs for easier lookup of users by domain. |
password |
password of user (will be removed after upgrade to 8.0.0). |
tig_nodes
collection contains the following fields
Table 8. tig_nodes
Name | Description |
---|---|
_id |
id of row auto-generated by MongoDB. |
uid |
id of user which is SHA256 hash of users jid (raw byte array). |
node |
full path of node in tree-like structure separated by / (may not exist). |
key |
key for which value for node is set. |
value |
value which is set for node key. |
Tigase XMPP Server also uses additional collections for storage of Offline Messages
Table 9. msg_history collection
Name | Description |
---|---|
from |
full user jid of message sender. |
from_hash |
SHA256 hash of message sender jid as raw byte array. |
to |
full users jid of message recipient. |
to_hash |
SHA256 hash of message recipient full jid as raw byte array. |
ts |
timestamp of message as date. |
message |
serialized XML stanza containing message. |
expire-at |
timestamp of expiration of message (if message contains AMP expire-at set). |
<mongodb-schema-changes-8> <title>Additions for v8.0 Schema</title>
Due to changes in authentication and credentials storage in AuthRepository, we moved password
field from tig_users
collection to a newly created collection called tig_user_credentials
.
This new collection has following fields:
Name | Description |
---|---|
_id |
id of document automatically generated by MongoDB |
uid |
SHA256 hash of a user for which credentails are stored |
username |
username provided during authentication (or |
account_status |
name of an account state (copy of value stored in user document from`tig_users`) |
Additionally for each mechanism we store separate field in this object, so for:
PLAIN
we havePLAIN
field with value for this mechanismSCRAM-SHA-1
we haveSCRAM-SHA-1
field with value for this mechanism- etc…
Upgrade is not done in one step, and rather will be done once a particular user will log in.
During authentication if there is no data in tig_user_credentials
, Tigase XMPP Server will check if password
field in tig_user
exists.
If it does, and it is filled credentials will be migrated to the new collection.