Tables/messages: Difference between revisions
From Joomla! Documentation
< Tables
< Tables
New page: == Usage: == * Since: == Description: == {| border="1" |+ '''messages Table (#__messages)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |- ... |
class="wikitable" |
||
| Line 4: | Line 4: | ||
== Description: == | == Description: == | ||
{| border="1" | {| class="wikitable" border="1" | ||
|+ '''messages Table (#__messages)''' | |+ '''messages Table (#__messages)''' | ||
|- bgcolor="lightgrey" | |- bgcolor="lightgrey" | ||
| Line 30: | Line 30: | ||
== Notes == | == Notes == | ||
{| border="1" | {| class="wikitable" border="1" | ||
|+ '''Indices''' | |+ '''Indices''' | ||
|- bgcolor="lightgrey" | |- bgcolor="lightgrey" | ||
Revision as of 03:21, 25 September 2011
Usage:
- Since:
Description:
| 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
| Index Name | Column(s) | Unique? |
| useridto_state | user_id_to, state | No |
- Default character set: utf8