Celui de phpbb_users est celui là
`user_id` mediumint(8) NOT NULL,
`user_active` tinyint(1) default ´1´,
`username` varchar(25) collate latin1_general_ci NOT NULL,
`user_password` varchar(32) collate latin1_general_ci NOT NULL,
`user_session_time` int(11) NOT NULL default ´0´,
`user_session_page` smallint(5) NOT NULL default ´0´,
`user_lastvisit` int(11) NOT NULL default ´0´,
`user_regdate` int(11) NOT NULL default ´0´,
`user_level` tinyint(4) default ´0´,
`user_posts` mediumint(8) unsigned NOT NULL default ´0´,
`user_timezone` decimal(5,2) NOT NULL default ´0.00´,
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) collate latin1_general_ci default NULL,
`user_dateformat` varchar(14) collate latin1_general_ci NOT NULL default ´d M Y H:i´,
`user_new_privmsg` smallint(5) unsigned NOT NULL default ´0´,
`user_unread_privmsg` smallint(5) unsigned NOT NULL default ´0´,
`user_last_privmsg` int(11) NOT NULL default ´0´,
`user_login_tries` smallint(5) unsigned NOT NULL default ´0´,
`user_last_login_try` int(11) NOT NULL default ´0´,
`user_emailtime` int(11) default NULL,
`user_viewemail` tinyint(1) default NULL,
`user_attachsig` tinyint(1) default NULL,
`user_allowhtml` tinyint(1) default ´1´,
`user_allowbbcode` tinyint(1) default ´1´,
`user_allowsmile` tinyint(1) default ´1´,
`user_allowavatar` tinyint(1) NOT NULL default ´1´,
`user_allow_pm` tinyint(1) NOT NULL default ´1´,
`user_allow_viewonline` tinyint(1) NOT NULL default ´1´,
`user_notify` tinyint(1) NOT NULL default ´1´,
`user_notify_pm` tinyint(1) NOT NULL default ´0´,
`user_popup_pm` tinyint(1) NOT NULL default ´0´,
`user_rank` int(11) default ´0´,
`user_avatar` varchar(100) collate latin1_general_ci default NULL,
`user_avatar_type` tinyint(4) NOT NULL default ´0´,
`user_email` varchar(255) collate latin1_general_ci default NULL,
`user_icq` varchar(15) collate latin1_general_ci default NULL,
`user_website` varchar(100) collate latin1_general_ci default NULL,
`user_from` varchar(100) collate latin1_general_ci default NULL,
`user_sig` text collate latin1_general_ci,
`user_sig_bbcode_uid` char(10) collate latin1_general_ci default NULL,
`user_aim` varchar(255) collate latin1_general_ci default NULL,
`user_yim` varchar(255) collate latin1_general_ci default NULL,
`user_msnm` varchar(255) collate latin1_general_ci default NULL,
`user_occ` varchar(100) collate latin1_general_ci default NULL,
`user_interests` varchar(255) collate latin1_general_ci default NULL,
`user_actkey` varchar(32) collate latin1_general_ci default NULL,
`user_newpasswd` varchar(32) collate latin1_general_ci default NULL,
PRIMARY KEY (`user_id`),
KEY `user_session_time` (`user_session_time`)