Documentation contenant le détail des tables de la base de données d’un forum phpBB 3.3.10

Détails de la table phpbb_topics

Description de la table

Table contenant les sujets du forum.

Schéma de la table en image

Capture d’écran de la tablephpbb_topics

Requête SQL de la structure de la table lors de l’installation

CREATE TABLE phpbb_topics (
	topic_id int(10) unsigned NOT NULL AUTO_INCREMENT,
	forum_id mediumint(8) unsigned NOT NULL DEFAULT '0',
	icon_id mediumint(8) unsigned NOT NULL DEFAULT '0',
	topic_attachment tinyint(1) unsigned NOT NULL DEFAULT '0',
	topic_reported tinyint(1) unsigned NOT NULL DEFAULT '0',
	topic_title varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
	topic_poster int(10) unsigned NOT NULL DEFAULT '0',
	topic_time int(11) unsigned NOT NULL DEFAULT '0',
	topic_time_limit int(11) unsigned NOT NULL DEFAULT '0',
	topic_views mediumint(8) unsigned NOT NULL DEFAULT '0',
	topic_status tinyint(3) NOT NULL DEFAULT '0',
	topic_type tinyint(3) NOT NULL DEFAULT '0',
	topic_first_post_id int(10) unsigned NOT NULL DEFAULT '0',
	topic_first_poster_name varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
	topic_first_poster_colour varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
	topic_last_post_id int(10) unsigned NOT NULL DEFAULT '0',
	topic_last_poster_id int(10) unsigned NOT NULL DEFAULT '0',
	topic_last_poster_name varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	topic_last_poster_colour varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
	topic_last_post_subject varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	topic_last_post_time int(11) unsigned NOT NULL DEFAULT '0',
	topic_last_view_time int(11) unsigned NOT NULL DEFAULT '0',
	topic_moved_id int(10) unsigned NOT NULL DEFAULT '0',
	topic_bumped tinyint(1) unsigned NOT NULL DEFAULT '0',
	topic_bumper mediumint(8) unsigned NOT NULL DEFAULT '0',
	poll_title varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	poll_start int(11) unsigned NOT NULL DEFAULT '0',
	poll_length int(11) unsigned NOT NULL DEFAULT '0',
	poll_max_options tinyint(4) NOT NULL DEFAULT '1',
	poll_last_vote int(11) unsigned NOT NULL DEFAULT '0',
	poll_vote_change tinyint(1) unsigned NOT NULL DEFAULT '0',
	topic_visibility tinyint(3) NOT NULL DEFAULT '0',
	topic_delete_time int(11) unsigned NOT NULL DEFAULT '0',
	topic_delete_reason varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	topic_delete_user int(10) unsigned NOT NULL DEFAULT '0',
	topic_posts_approved mediumint(8) unsigned NOT NULL DEFAULT '0',
	topic_posts_unapproved mediumint(8) unsigned NOT NULL DEFAULT '0',
	topic_posts_softdeleted mediumint(8) unsigned NOT NULL DEFAULT '0',
	PRIMARY KEY (topic_id),
	KEY forum_id (forum_id),
	KEY forum_id_type (forum_id,topic_type),
	KEY last_post_time (topic_last_post_time),
	KEY fid_time_moved (forum_id,topic_last_post_time,topic_moved_id),
	KEY topic_visibility (topic_visibility),
	KEY forum_vis_last (forum_id,topic_visibility,topic_last_post_id),
	KEY latest_topics (forum_id,topic_last_post_time,topic_last_post_id,topic_moved_id)
) CHARSET=utf8 COLLATE=utf8_bin;

Requête SQL des données insérées dans la table

INSERT INTO phpbb_topics (topic_title, topic_poster, topic_time, topic_views, topic_posts_approved, topic_posts_unapproved, topic_posts_softdeleted, forum_id, topic_status, topic_type, topic_first_post_id, topic_first_poster_name, topic_first_poster_colour, topic_last_post_id, topic_last_poster_id, topic_last_poster_name, topic_last_poster_colour, topic_last_post_subject, topic_last_post_time, topic_last_view_time, poll_title, topic_visibility) VALUES ('{L_TOPICS_TOPIC_TITLE}', 2, 972086460, 0, 1, 0, 0, 2, 0, 0, 1, 'Admin', 'AA0000', 1, 2, 'Admin', 'AA0000', '{L_TOPICS_TOPIC_TITLE}', 972086460, 972086460, '', 1);