منتديات phpBBArabia

كود: تحديد الكل

define('LOGIN_ATTEMPT_TABLE',		$table_prefix . 'login_attempts');

كود: تحديد الكل

define('LOG_TABLE',					$table_prefix . 'log');

كود: تحديد الكل

CREATE TABLE phpbb_login_attempts (
	attempt_ip varchar(40) DEFAULT '' NOT NULL,
	attempt_browser varchar(150) DEFAULT '' NOT NULL,
	attempt_forwarded_for varchar(255) DEFAULT '' NOT NULL,
	attempt_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
	username varchar(255) DEFAULT '0' NOT NULL,
	username_clean varchar(255) DEFAULT '0' NOT NULL,
	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)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;