Информация о созданных темах на конференции
Поля (Fields)
| Поле (column) | Тип (type, MySQL) | Содержание (content) | Значение по умолчанию (default) |
| topic_id | mediumint(8) unsigned | primary key | auto_increment |
| forum_id | mediumint(8) unsigned | tbd | 0 |
| icon_id | mediumint(8) unsigned | tbd | 0 |
| topic_attachment | tinyint(1) unsigned | tbd | 0 |
| topic_approved | tinyint(1) unsigned | tbd | 1 |
| topic_reported | tinyint(1) unsigned | tbd | 0 |
| topic_title | varchar(255) | tbd | |
| topic_poster | mediumint(8) unsigned | tbd | 0 |
| topic_time | int(11) unsigned | tbd | 0 |
| topic_time_limit | int(11) unsigned | tbd | 0 |
| topic_views | mediumint(8) unsigned | tbd | 0 |
| topic_replies | mediumint(8) unsigned | tbd | 0 |
| topic_replies_real | mediumint(8) unsigned | tbd | 0 |
| topic_status | tinyint(3) | tbd | 0 |
| topic_type | tinyint(3) | tbd | 0 |
| topic_first_post_id | mediumint(8) unsigned | tbd | 0 |
| topic_first_poster_name | varchar(255) | tbd | |
| topic_first_poster_colour | varchar(6) | tbd | |
| topic_last_post_id | mediumint(8) unsigned | tbd | 0 |
| topic_last_poster_id | mediumint(8) unsigned | tbd | 0 |
| topic_last_poster_name | varchar(255) | tbd | |
| topic_last_poster_colour | varchar(6) | tbd | |
| topic_last_post_subject | varchar(255) | tbd | |
| topic_last_post_time | int(11) unsigned | tbd | 0 |
| topic_last_view_time | int(11) unsigned | tbd | 0 |
| topic_moved_id | mediumint(8) unsigned | tbd | 0 |
| topic_bumped | tinyint(1) unsigned | tbd | 0 |
| topic_bumper | mediumint(8) unsigned | tbd | 0 |
| poll_title | varchar(255) | tbd | |
| poll_start | int(11) unsigned | tbd | 0 |
| poll_length | int(11) unsigned | tbd | 0 |
| poll_max_options | tinyint(4) | tbd | 1 |
| poll_last_vote | int(11) unsigned | tbd | 0 |
| poll_vote_change | tinyint(1) unsigned | tbd | 0 |
Ключи (Keys)
| Имя (name) | Создан по полям (fields) |
| PRIMARY | topic_id |
| forum_id | forum_id |
| forum_id_type | forum_id |
| topic_type | |
| last_post_time | topic_last_post_time |
| topic_approved | topic_approved |
| forum_appr_last | forum_id |
| topic_approved | |
| topic_last_post_id | |
| fid_time_moved | forum_id |
| topic_last_post_time | |
| topic_moved_id |
