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_forums

CREATE TABLE phpbb_forums (
	forum_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
	parent_id mediumint(8) unsigned NOT NULL DEFAULT '0',
	left_id mediumint(8) unsigned NOT NULL DEFAULT '0',
	right_id mediumint(8) unsigned NOT NULL DEFAULT '0',
	forum_parents mediumtext COLLATE utf8_bin NOT NULL,
	forum_name varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	forum_desc text COLLATE utf8_bin NOT NULL,
	forum_desc_bitfield varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	forum_desc_options int(11) unsigned NOT NULL DEFAULT '7',
	forum_desc_uid varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
	forum_link varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	forum_password varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	forum_style mediumint(8) unsigned NOT NULL DEFAULT '0',
	forum_image varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	forum_rules text COLLATE utf8_bin NOT NULL,
	forum_rules_link varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	forum_rules_bitfield varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	forum_rules_options int(11) unsigned NOT NULL DEFAULT '7',
	forum_rules_uid varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
	forum_topics_per_page smallint(4) unsigned NOT NULL DEFAULT '0',
	forum_type tinyint(4) NOT NULL DEFAULT '0',
	forum_status tinyint(4) NOT NULL DEFAULT '0',
	forum_last_post_id int(10) unsigned NOT NULL DEFAULT '0',
	forum_last_poster_id int(10) unsigned NOT NULL DEFAULT '0',
	forum_last_post_subject varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	forum_last_post_time int(11) unsigned NOT NULL DEFAULT '0',
	forum_last_poster_name varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	forum_last_poster_colour varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
	forum_flags tinyint(4) NOT NULL DEFAULT '32',
	display_on_index tinyint(1) unsigned NOT NULL DEFAULT '1',
	enable_indexing tinyint(1) unsigned NOT NULL DEFAULT '1',
	enable_icons tinyint(1) unsigned NOT NULL DEFAULT '1',
	enable_prune tinyint(1) unsigned NOT NULL DEFAULT '0',
	prune_next int(11) unsigned NOT NULL DEFAULT '0',
	prune_days mediumint(8) unsigned NOT NULL DEFAULT '0',
	prune_viewed mediumint(8) unsigned NOT NULL DEFAULT '0',
	prune_freq mediumint(8) unsigned NOT NULL DEFAULT '0',
	display_subforum_list tinyint(1) unsigned NOT NULL DEFAULT '1',
	display_subforum_limit tinyint(1) unsigned NOT NULL DEFAULT '0',
	forum_options int(20) unsigned NOT NULL DEFAULT '0',
	enable_shadow_prune tinyint(1) unsigned NOT NULL DEFAULT '0',
	prune_shadow_days mediumint(8) unsigned NOT NULL DEFAULT '7',
	prune_shadow_freq mediumint(8) unsigned NOT NULL DEFAULT '1',
	prune_shadow_next int(11) NOT NULL DEFAULT '0',
	forum_posts_approved mediumint(8) unsigned NOT NULL DEFAULT '0',
	forum_posts_unapproved mediumint(8) unsigned NOT NULL DEFAULT '0',
	forum_posts_softdeleted mediumint(8) unsigned NOT NULL DEFAULT '0',
	forum_topics_approved mediumint(8) unsigned NOT NULL DEFAULT '0',
	forum_topics_unapproved mediumint(8) unsigned NOT NULL DEFAULT '0',
	forum_topics_softdeleted mediumint(8) unsigned NOT NULL DEFAULT '0',
	PRIMARY KEY (forum_id),
	KEY left_right_id (left_id,right_id),
	KEY forum_lastpost_id (forum_last_post_id)
) CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_forums (forum_name, forum_desc, left_id, right_id, parent_id, forum_type, forum_posts_approved, forum_posts_unapproved, forum_posts_softdeleted, forum_topics_approved, forum_topics_unapproved, forum_topics_softdeleted, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_poster_colour, forum_last_post_time, forum_link, forum_password, forum_image, forum_rules, forum_rules_link, forum_rules_uid, forum_desc_uid, prune_days, prune_viewed, forum_parents) VALUES ('{L_FORUMS_FIRST_CATEGORY}', '', 1, 4, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2, 'Admin', 'AA0000', 972086460, '', '', '', '', '', '', '', 0, 0, '');
INSERT INTO phpbb_forums (forum_name, forum_desc, left_id, right_id, parent_id, forum_type, forum_posts_approved, forum_posts_unapproved, forum_posts_softdeleted, forum_topics_approved, forum_topics_unapproved, forum_topics_softdeleted, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_poster_colour, forum_last_post_subject, forum_last_post_time, forum_link, forum_password, forum_image, forum_rules, forum_rules_link, forum_rules_uid, forum_desc_uid, prune_freq, prune_days, prune_viewed, forum_parents, forum_flags) VALUES ('{L_FORUMS_TEST_FORUM_TITLE}', '{L_FORUMS_TEST_FORUM_DESC}', 2, 3, 1, 1, 1, 0, 0, 1, 0, 0, 1, 2, 'Admin', 'AA0000', '{L_TOPICS_TOPIC_TITLE}', 972086460, '', '', '', '', '', '', '', 1, 7, 7, '', 48);