Description de la table
Table contenant les informations des membres du forum.
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_users
Schéma de la table en image
Requête SQL de la structure de la table lors de l’installation
CREATE TABLE phpbb_users ( user_id int(10) unsigned NOT NULL AUTO_INCREMENT, user_type tinyint(2) NOT NULL DEFAULT '0', group_id mediumint(8) unsigned NOT NULL DEFAULT '3', user_permissions mediumtext COLLATE utf8_bin NOT NULL, user_perm_from mediumint(8) unsigned NOT NULL DEFAULT '0', user_ip varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '', user_regdate int(11) unsigned NOT NULL DEFAULT '0', username varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', username_clean varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', user_password varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', user_passchg int(11) unsigned NOT NULL DEFAULT '0', user_email varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '', user_birthday varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '', user_lastvisit int(11) unsigned NOT NULL DEFAULT '0', user_lastmark int(11) unsigned NOT NULL DEFAULT '0', user_lastpost_time int(11) unsigned NOT NULL DEFAULT '0', user_lastpage varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '', user_last_confirm_key varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '', user_last_search int(11) unsigned NOT NULL DEFAULT '0', user_warnings tinyint(4) NOT NULL DEFAULT '0', user_last_warning int(11) unsigned NOT NULL DEFAULT '0', user_login_attempts tinyint(4) NOT NULL DEFAULT '0', user_inactive_reason tinyint(2) NOT NULL DEFAULT '0', user_inactive_time int(11) unsigned NOT NULL DEFAULT '0', user_posts mediumint(8) unsigned NOT NULL DEFAULT '0', user_lang varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '', user_timezone varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '', user_dateformat varchar(64) COLLATE utf8_bin NOT NULL DEFAULT 'd M Y H:i', user_style mediumint(8) unsigned NOT NULL DEFAULT '0', user_rank mediumint(8) unsigned NOT NULL DEFAULT '0', user_colour varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '', user_new_privmsg int(4) NOT NULL DEFAULT '0', user_unread_privmsg int(4) NOT NULL DEFAULT '0', user_last_privmsg int(11) unsigned NOT NULL DEFAULT '0', user_message_rules tinyint(1) unsigned NOT NULL DEFAULT '0', user_full_folder int(11) NOT NULL DEFAULT '-3', user_emailtime int(11) unsigned NOT NULL DEFAULT '0', user_topic_show_days smallint(4) unsigned NOT NULL DEFAULT '0', user_topic_sortby_type varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 't', user_topic_sortby_dir varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 'd', user_post_show_days smallint(4) unsigned NOT NULL DEFAULT '0', user_post_sortby_type varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 't', user_post_sortby_dir varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 'a', user_notify tinyint(1) unsigned NOT NULL DEFAULT '0', user_notify_pm tinyint(1) unsigned NOT NULL DEFAULT '1', user_notify_type tinyint(4) NOT NULL DEFAULT '0', user_allow_pm tinyint(1) unsigned NOT NULL DEFAULT '1', user_allow_viewonline tinyint(1) unsigned NOT NULL DEFAULT '1', user_allow_viewemail tinyint(1) unsigned NOT NULL DEFAULT '1', user_allow_massemail tinyint(1) unsigned NOT NULL DEFAULT '1', user_options int(11) unsigned NOT NULL DEFAULT '230271', user_avatar varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', user_avatar_type varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', user_avatar_width smallint(4) unsigned NOT NULL DEFAULT '0', user_avatar_height smallint(4) unsigned NOT NULL DEFAULT '0', user_sig mediumtext COLLATE utf8_bin NOT NULL, user_sig_bbcode_uid varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '', user_sig_bbcode_bitfield varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', user_jabber varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', user_actkey varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', reset_token varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '', reset_token_expiration int(11) unsigned NOT NULL DEFAULT '0', user_newpasswd varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', user_form_salt varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '', user_new tinyint(1) unsigned NOT NULL DEFAULT '1', user_reminded tinyint(4) NOT NULL DEFAULT '0', user_reminded_time int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (user_id), UNIQUE KEY username_clean (username_clean), KEY user_birthday (user_birthday), KEY user_type (user_type), KEY user_email (user_email) ) CHARSET=utf8 COLLATE=utf8_bin;
Requête SQL des données insérées dans la table
INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_jabber, user_actkey, user_newpasswd, user_allow_massemail) VALUES (2, 1, 'Anonymous', 'anonymous', 0, '', '', 'en', 1, 0, '', 0, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', 0);
INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_jabber, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin', 'admin', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '');