Table tig_muc_room_history

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