The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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