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_posts

CREATE TABLE phpbb_posts (
	post_id int(10) unsigned NOT NULL AUTO_INCREMENT,
	topic_id int(10) unsigned NOT NULL DEFAULT '0',
	forum_id mediumint(8) unsigned NOT NULL DEFAULT '0',
	poster_id int(10) unsigned NOT NULL DEFAULT '0',
	icon_id mediumint(8) unsigned NOT NULL DEFAULT '0',
	poster_ip varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
	post_time int(11) unsigned NOT NULL DEFAULT '0',
	post_reported tinyint(1) unsigned NOT NULL DEFAULT '0',
	enable_bbcode tinyint(1) unsigned NOT NULL DEFAULT '1',
	enable_smilies tinyint(1) unsigned NOT NULL DEFAULT '1',
	enable_magic_url tinyint(1) unsigned NOT NULL DEFAULT '1',
	enable_sig tinyint(1) unsigned NOT NULL DEFAULT '1',
	post_username varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	post_subject varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
	post_text mediumtext COLLATE utf8_bin NOT NULL,
	post_checksum varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
	post_attachment tinyint(1) unsigned NOT NULL DEFAULT '0',
	bbcode_bitfield varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	bbcode_uid varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
	post_postcount tinyint(1) unsigned NOT NULL DEFAULT '1',
	post_edit_time int(11) unsigned NOT NULL DEFAULT '0',
	post_edit_reason varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	post_edit_user int(10) unsigned NOT NULL DEFAULT '0',
	post_edit_count smallint(4) unsigned NOT NULL DEFAULT '0',
	post_edit_locked tinyint(1) unsigned NOT NULL DEFAULT '0',
	post_visibility tinyint(3) NOT NULL DEFAULT '0',
	post_delete_time int(11) unsigned NOT NULL DEFAULT '0',
	post_delete_reason varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	post_delete_user int(10) unsigned NOT NULL DEFAULT '0',
	PRIMARY KEY (post_id),
	KEY forum_id (forum_id),
	KEY topic_id (topic_id),
	KEY poster_ip (poster_ip),
	KEY poster_id (poster_id),
	KEY tid_post_time (topic_id,post_time),
	KEY post_username (post_username),
	KEY post_visibility (post_visibility)
) CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_posts (topic_id, forum_id, poster_id, icon_id, post_time, post_username, poster_ip, post_subject, post_text, post_checksum, bbcode_uid, post_visibility) VALUES (1, 2, 2, 0, 972086460, '', '127.0.0.1', '{L_TOPICS_TOPIC_TITLE}', '{L_DEFAULT_INSTALL_POST}', '5dd683b17f641daf84c040bfefc58ce9', '', 1);