Информация о созданных темах на конференции

 

 


Поля (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

 

Список таблиц

Joomla SEF URLs by Artio