Message Read Table Schema (message_read)


Description

Stores all messages that have been read

message_read table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
useridfrom bigint 10 0
useridto bigint 10 0
subject longtext 2147483647 null

The message subject

fullmessage longtext 2147483647 null
fullmessageformat smallint 4 0

The format of the full message

fullmessagehtml longtext 2147483647 null

html format of message

smallmessage longtext 2147483647 null

Smal version of message (eg sms)

notification BIT 1 0
contexturl longtext 2147483647 null

If this message is a notification of an event contexturl should contain a link to view this event. For example if its a notification of a forum post contexturl should contain a link to the forum post.

contexturlname longtext 2147483647 null

Display text for the contexturl

timecreated bigint 10 0
timeread bigint 10 0
timeuserfromdeleted bigint 10 0
timeusertodeleted bigint 10 0
component varchar 100 null
eventtype varchar 100 null

Table contained -1 rows

message_read table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
messread_nottim_ix Performance Asc/Asc notification + timeread
messread_usetimnot2_ix Performance Asc/Asc/Asc useridto + timeusertodeleted + notification
messread_usetimnot_ix Performance Asc/Asc/Asc useridfrom + timeuserfromdeleted + notification
messread_useusetimtim_ix Performance Asc/Asc/Asc/Asc useridfrom + useridto + timeuserfromdeleted + timeusertodeleted