Tables/messages
From Joomla! Documentation
Description[edit]
messages Table (#__messages)
Field |
Type |
Nullable |
Default |
Key |
Extra |
Comments
|
message_id |
integer unsigned |
NOT NULL |
|
PK |
auto_increment |
|
user_id_from |
integer unsigned |
NOT NULL |
0 |
|
|
|
user_id_to |
integer unsigned |
NOT NULL |
0 |
|
|
|
folder_id |
tinyint(3) unsigned |
NOT NULL |
0 |
|
|
|
date_time |
datetime |
NOT NULL |
'0000-00-00 00:00:00' |
|
|
|
state |
tinyint(1) |
NOT NULL |
0 |
|
|
|
priority |
tinyint(1) unsigned |
NOT NULL |
0 |
|
|
|
subject |
varchar(255) |
NOT NULL |
|
|
|
|
message |
text |
NOT NULL |
|
|
|
|
Indices
Index Name |
Column(s) |
Unique?
|
useridto_state |
user_id_to, state |
No
|
- Default character set: utf8