Содержание всех личных сообщений
Поля (Fields)
| Поле (column) | Тип (type, MySQL) | Содержание (content) | Значение по умолчанию (default) |
| msg_id | mediumint(8) unsigned | primary key | auto_increment |
| root_level | mediumint(8) unsigned | tbd | 0 |
| author_id | mediumint(8) unsigned | tbd | 0 |
| icon_id | mediumint(8) unsigned | tbd | 0 |
| author_ip | varchar(40) | tbd | |
| message_time | int(11) unsigned | tbd | 0 |
| enable_bbcode | tinyint(1) unsigned | tbd | 1 |
| enable_smilies | tinyint(1) unsigned | tbd | 1 |
| enable_magic_url | tinyint(1) unsigned | tbd | 1 |
| enable_sig | tinyint(1) unsigned | tbd | 1 |
| message_subject | varchar(255) | tbd | |
| message_text | mediumtext | tbd | |
| message_edit_reason | varchar(255) | tbd | |
| message_edit_user | mediumint(8) unsigned | tbd | 0 |
| message_attachment | tinyint(1) unsigned | tbd | 0 |
| bbcode_bitfield | varchar(255) | tbd | |
| bbcode_uid | varchar(8) | tbd | |
| message_edit_time | int(11) unsigned | tbd | 0 |
| message_edit_count | smallint(4) unsigned | tbd | 0 |
| to_address | text | tbd | |
| bcc_address | text | tbd |
Ключи (Keys)
| Имя (name) | Создан по полям (fields) |
|---|---|
| PRIMARY | msg_id |
| author_ip | author_ip |
| message_time | message_time |
| author_id | author_id |
| root_level | root_level |