Содержание всех сообщений
Поля (Fields)
Поле (column) | Тип (type, MySQL) | Содержание (content) | Значение по умолчанию (default) |
post_id | mediumint(8) unsigned | primary key | auto_increment |
topic_id | mediumint(8) unsigned | tbd | 0 |
forum_id | mediumint(8) unsigned | tbd | 0 |
poster_id | mediumint(8) unsigned | tbd | 0 |
icon_id | mediumint(8) unsigned | tbd | 0 |
poster_ip | varchar(40) | tbd | |
post_time | int(11) unsigned | tbd | 0 |
post_approved | tinyint(1) unsigned | tbd | 1 |
post_reported | tinyint(1) 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 |
post_username | varchar(255) | tbd | |
post_subject | varchar(255) | tbd | |
post_text | mediumtext | tbd | |
post_checksum | varchar(32) | tbd | |
post_attachment | tinyint(1) unsigned | tbd | 0 |
bbcode_bitfield | varchar(255) | tbd | |
bbcode_uid | varchar(8) | tbd | |
post_postcount | tinyint(1) unsigned | tbd | 1 |
post_edit_time | int(11) unsigned | tbd | 0 |
post_edit_reason | varchar(255) | tbd | |
post_edit_user | mediumint(8) unsigned | tbd | 0 |
post_edit_count | smallint(4) unsigned | tbd | 0 |
post_edit_locked | tinyint(1) unsigned | tbd | 0 |
Ключи (Keys)
Имя (name) | Создан по полям (fields) |
PRIMARY | post_id |
forum_id | forum_id |
topic_id | topic_id |
poster_ip | poster_ip |
poster_id | poster_id |
post_approved | post_approved |
tid_post_time | topic_id |
post_time |