Tables/messages

From Joomla! Documentation

< Tables

Usage[edit]

  • Since:

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

Notes[edit]

Indices
Index Name Column(s) Unique?
useridto_state user_id_to, state No
  • Default character set: utf8