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_login_attempts

CREATE TABLE phpbb_login_attempts (
	attempt_ip varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
	attempt_browser varchar(150) COLLATE utf8_bin NOT NULL DEFAULT '',
	attempt_forwarded_for varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
	attempt_time int(11) unsigned NOT NULL DEFAULT '0',
	user_id int(10) unsigned NOT NULL DEFAULT '0',
	username varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0',
	username_clean varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0',
	KEY att_ip (attempt_ip,attempt_time),
	KEY att_for (attempt_forwarded_for,attempt_time),
	KEY att_time (attempt_time),
	KEY user_id (user_id)
) CHARSET=utf8 COLLATE=utf8_bin;