Tigase MUC component uses few tables and stored procedures. To make it easier to find them on database level they are prefixed with tig_muc_
.
This table stores list of rooms and configuration of rooms.
Field | Description | Comments |
---|---|---|
room_id | Database ID of a room | |
jid | Room JID | |
jid_sha1 | SHA1 value of lowercased room JID | Used for proper bare JID comparison during lookup. (Not exists in PostgreSQL schema) |
name | Room name | |
config | Serialized room configuration | |
creator | Bare JID of room creator | |
creation_date | Room creation date | |
subject | Room subject | |
subject_creator_nick | Nick of participant who set subject | |
subject_date | Timestamp of subject |
Table stores rooms affiliations.
Field | Description | Comments |
---|---|---|
room_id | ID of a room | References |
jid | JID of affiliate | |
jid_sha1 | SHA1 value of lowercased affiliate JID | Used for proper bare JID comparison during lookup. (Not exists in PostgreSQL schema) |
affiliation | Affiliation between room and affiliate |
Table stores room messages history.
Field | Description | Comments |
---|---|---|
room_jid | Room JID | |
room_jid_sha1 | SHA1 value of lowercased room JID | Used for proper bare JID comparison during lookup. (Not exists in PostgreSQL schema) |
event_type | For future use, if we decide to store other events as well. | |
ts | Timestamp of a message | |
sender_jid | JID of a sender | |
sender_nickname | Nickname of a message sender | |
body | Body of a message | |
public_event | Mark public events | |
msg | Serialized message |